I’m using Laravel 5.8 and I want to download data from view with LaravelExcel. Here is my Export Class: namespace AppExports; use AppMemberStudent; use IlluminateContractsViewView; use MaatwebsiteExcelConcernsFromView; use MaatwebsiteExcelFacadesExcel; class StudentExportView implements FromView { /** * @return IlluminateSupportCollection */ public function view(): View { return view(‘admin.students.custom’, [ ‘students’ => Student::take(1)->get(), ‘customs’ => Student::take(1)->get(), ]); } ..
This is your docker-compose file to add "Phpmyadmin" you just have to the following commands that I will leave in "answer" For more information: https://laravel.com/docs/sail version: "3" services: laravel.test: build: context: ./vendor/laravel/sail/runtimes/8.0 dockerfile: Dockerfile args: WWWGROUP: "${WWWGROUP}" image: sail-8.0/app ports: – "${APP_PORT:-80}:80" environment: WWWUSER: "${WWWUSER}" LARAVEL_SAIL: 1 volumes: – ".:/var/www/html" networks: – sail depends_on: – ..
"select users.id, users.name, users.avatar, users.email, messages.message, messages.is_read, messages.msg_to, messages.msg_from, messages.created_at, max(messages.created_at) as max_created_at from users LEFT JOIN messages ON users.id = messages.msg_from and is_read = 0 and messages.msg_to = " . Auth::id() . " where users.id != " . Auth::id() . " AND users.id IN ( SELECT friends.friend_id from friends WHERE friends.user_id = " . ..
How can I compare two words and check if they’re of the same meaning in Php. Any idea because I’m working on a project that’ll require that but I have no idea how to go about it Sourc..
I get popup showing are you sure you want to delet this data? But what i want is I want to make an axios call and fetch data inside that popup, asking where do you want to shift the data related to that data inside ? and show the dropdown? deleteBeacon(beacon) { swal({ title: "Are ..
i am having the error stated above, and here is the copy log php artisan db:seed BadMethodCallException Call to undefined method AppModelsCategory::factory() at vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:50 46▕ * @throws BadMethodCallException 47▕ */ 48▕ protected static function throwBadMethodCallException($method) 49▕ { ➜ 50▕ throw new BadMethodCallException(sprintf( 51▕ ‘Call to undefined method %s::%s()’, static::class, $method 52▕ )); 53▕ } 54▕ ..
Tengo una duda, jamás había trabajado con Laravel, pero se me pide imprimir una tabla con solo ciertos id de un modelo. Este modelo de donde estoy sacando el id(El 4, 5, 9, 10, 13 y 14) esta relacionado con otra tabla llamada Expedientejuzgado2019 que es la que tiene el dato que necesito, solo que ..
I’m stumped on what to do to fix this issue I’m having in laravel where the results of the models relationship returns empty/null relationship fields when I only want it to show "animals" with data when doing a GET call with a search string. For example in the response below in the "favorite_animals" field I ..
need to join two data and compile to show in datatable but i dont know what is wrong in my code controller $data = DB::table(‘items’) ->join(‘shipments’, ‘shipments.shp_no’,’=’,’items.shp_no_for_it’) ->select(‘items.it_arabic_name’, ‘shipments.shp_destination_shipping_fees’) ->get(); return Datatables::of($data) ->make(true); ajax columns: [ {data: ‘items.it_arabic_name’, render: function ( data, type, row ) { return row.items.it_arabic_name + ‘ ‘ + row.shipments.shp_destination_shipping_fees; } }] ..
I have this code: $user = User::updateOrCreate([ ’email’ => $employee->email, ], [ ‘username’ => $employee->username, ‘password’ => bcrypt("123456"), ‘first_name’ => $employee->first_name, ‘last_name’ => $employee->last_name, ]); I want to add a condition that if record exists, it shouldn’t update: ‘password’ => bcrypt("123456"), How do I achieve this? Thanks Sourc..
I’m updating my Laravel 8 project from Vue 2 and Laravel Mix 5 to Vue 3 and Laravel Mix 6, and I’ve noticed that the recompile-time when a component is modified to be significantly longer than with Mix 5. Before Upgrading { "laravel-mix": "^5.0.1", "vue": "^2.5.17", "vue-template-compiler": "^2.6.10" } Before the upgrade, my app.js and ..
Would like to create a history in Laravel 8 when a change has occurred when saving a record against (when updating). This history I would like to save in the database. Is there a solution with Laravel 8 or do you have a tip for me? Sourc..
I am editing the next error while printing a model content on my blade.php view: And this is how i’m trying to use it on my view: blade.php <div class="form-group"> <label for="color">انتخاب رنگ</label> @if(!$product->colors) <div id="showColors"> </div> @else <div class="row no-gutters mb-1"> <div class="col-md-3"> <label for="color_name" class="ml-1">نام رنگ:</label> <input type="text" id="color_name" name="color_name[]" class="form-control w-auto d-inline" ..
I am developing a project with Laravel 8. There are fields such as "us_name", "us_surname" in my Users table. After the user is logged in, I can reach these values by saying "auth()->user()->us_name" etc. So far, no problem. What I want to do is add some values here that are not in my table. For ..
I am trying to add Watermark of 800x100px to Images which can have any resolution greater than 800×100, i.e. 801×110, 1200×1000, 1300×200, 1920×1080, 4000×2010, etc. I want to keep the aspect ratio of Watermark and image to 2:50. i.e., if image has 1000px width, then watarmark over image should occupy 20px(1000/50). Here is my Function ..
I am redirecting to a named route in Laravel 7 and instead of the route being redirected it returns the user to the previous page. Controller return redirect()->route(‘NAMEDRoute’)->with("Information", $information[0]); web.php Route::get(‘/x/y’, "[email protected]")->name(‘NAMEDRoute’); This just returns me to the route I was on before, I have tested other routes that also work but the function that ..
I am integrating Razorpay API to my Web App coded in PHP Laravel. I have 2 files – RazorpayController.php public function create($profile = null, Request $request){ $details = json_decode($request->details); return view(‘profile.payment.razorPay’, [‘profile’ => $this->profile, ‘details’ => $details, ‘total’ => $total, ‘data’ => $data]); } public function verify($profile = null, Request $request){ $orders = [‘details’ => ..
i want trigger an command with argument from another command, and also trigger a command with argument from controller, so my command solutions of command is: class ChangeLanguageCommand extends Command { /** * @var string Command Name */ protected $name = ‘change_language’; /** * @var string Command Description */ protected $description = ‘Change Language,Change language ..
In Laravel-8 Maatwebsite Excel import, I am implementing Custom ID Generator from helper. I have this code in the Maatwebsite ExcelImport: protected $companyId = Auth::user()->company_id; public function getID(){ return IdGenerator::select(‘id’) ->where(‘company_id’, $this->companyId)->first(); } I got this error: Constant expression contains invalid operations This is highlighted: protected $companyId = Auth::user()->company_id; Sourc..
I have stored images in the public folder and access them via API calls. Every time it takes the same amount of time to load those images. It is a very annoying thing. So I need to cache those images without using any external libraries. Sourc..
public function createall() { $users = User::orderBy(‘id’, ‘ASC’) ->where(‘server’, ‘Demo’) ->where(‘enable’, ‘1’) ->where(‘mt4_account’, ‘!=’, 0) ->take(4) ->get(); foreach ($users as $user) { $server = Server::where(‘Serverdesc’, $user->server)->first(); $post = [ ‘server’ => $server->serverdesc, ‘api_key’ => ‘xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx’, ‘login’ => intval($user->mt4_account), ]; $datapost = json_encode($post); // initialize cURL $ch = curl_init(); // set options curl_setopt($ch, CURLOPT_URL, "http://xxxxxxxxxxxxxxxxx/closetrades"); curl_setopt($ch, ..
I want to pass an additional parameter from controller to collection resource, Please have a look at the following code, I don’t know why It’s not working. I might be doing something wron here, please help Controller $batchStudents = $batch->students->except($batch->host->id); $batchStudents->test = ‘This is testing’; $students = UserCollection::collection($batchStudents); Collection: class UserCollection extends JsonResource { return ..
so I’m relatively new to laravel and am trying to understand it. So far it has been good but I’ve been stuck at an error for a while now so any help would be appreciated. I’m trying to follow along with a youtube tutorial (not sure if links are allowed) and this is what I’m ..
I’m creating a SNS app, in which User and Post are in many-to-many relationship, with a pivot table Favorite. Is there way to fetch all posts you didn’t faved? $posts = Post::wherehas("users",function($q)use($your_id){ $q->where(‘user_id’, ‘!=’, $your_id); })->orDoesntHave(‘users’)->get(); return $posts; The above method was what I came up with, but it seemed not to work when more ..
I am working on a meal planning application in Laravel, and one of the functionality is to have meal plans that are past their end date move to an ‘Archives’ page (stored in a new MealPlan_Archives table and displayed on a different page). Both MealPlanDisplay table and MealPlan_Archives have the exact same table columns, except ..
