How can I change the property that belongs to one of returned entry's relationship without affecting the other? The example query below returns two entries with each having their own set of relationship attached to them $tttt = AppManualTicket::where(function ($checkUser)…
I have a problem to eagerload 2 relation in 1 table in laravel 9. i have table called photos have relation with users and photo_categories. so what i want to achieve is to load user and categories in same time.also…
I have something strange going on. I am trying to query with a whereNull and also a where statement. When i just use the whereNull it returns results, but as soon as I add the where statement, nothing gets returned…
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]);…