I have an appended attribute that works when I do Model::first()->appended_attribute, but when get the model object instantiated through laravel's route dependency injection like below : public function update(UserRequest $request, User $user) { $user->appended_attribute; // returns null } When I…
I've gone through the possible related questions, but I haven't found anything about it, please, if you see that I'm wrong and there's something similar, let me know and I'll delete this question if the rules say so to avoid…
I want Data From Both Queries One After Another ->when($todayDate, function ($query) use ($todayDate) { $query->whereDate('startdate', '>=', $todayDate)->orderBy('batches.startdate', 'desc'); })->when($todayDate, function ($query) use ($todayDate) { $query->whereDate('startdate', '<=', $todayDate)->orderBy('batches.startdate', 'desc'); })
When you give a 404 NOT FOUND, even though I am using it route resource. I don't go to any page Route::resource('/' , ClientController::class) <tbody> @forelse($clients as $client) <tr> <th scope="row">{{$client->id}}</th> <td>{{$client->email}}</td> <td>{{$client->password}}</td> <td>{{$client->city}}</td> <td><a href="{{route('edit',$client->id)}}" >Update</a></td> </tr> <tr> @empty…
I have successfully implemented the fetching of data, Am using loop to fetch the data. how do i pass it to collection; my data now looks like when i try returning from the controller direct to the view: 0 :…
I am learning to use the laravel eloquent and I have this query SELECT SUM(precio_total) FROM `venta` GROUP BY (MONTH(fecha)); So far i wear this $cantidad_venta = Venta::select('SUM(PRECIO_TOTAL) as suma_precio') ->groupBy('MONTH(fecha)') ->get(); I try to go through axios, but it…
Help me little please. I can't filtering single record. May be or not. // In Controller public function show(Post $post) { $post = Post::with(['comments' => function($query) { $query->where('status', 'active'); } ])->find($post); // can't filter comments return view('post.show', ['post' => $post]);…
i have a table which has the fields attachment_id and file_path ,file_path field stores the path from s3 bucket corresponding to the attachment id . is there any way to initialize a method or call an event directly from the…
After spending hours on this, finally I felt to post this question here. I am trying to join tables. Due to some circumstances, I have to use the query in the same way that I have pasted below. select posts.id,…
I've defined a Backpack select_from_array column for the field form_trx in the table transactions. I want to populate the options array for that Backpack column with data that's stored in two columns (called value_store and value_display) of another database table…