I have a strange Laravel 9 setup due to being constrained to a very ancient database. I'm trying to come up with a clean way to create a hasMany relationship to multiple models located in a folder. I believe it…
i am trying to retrieve questions based on the category witch they belong with this function inside my questions controller: public function getByCategoryName($categoryName) { $category = Category::where('name', $categoryName)->first(); return response($category->questions); } the problem is that, even if $category its being…
I have a reports table which looks like something as follows: Reports is monthly reports of users putting their efforts. It's many to many relationship table. id user_id project_id total_effort created_at 1 5 232 40 2023-01-23 I want to get…
I am struggling with a mysql problem. I have two exact same queries, just the item_id at the end is different, but they return different execution plans when I execute them with analyze/explain. This results in a huge difference of…
I have a simple list of tasks that need to be completed today, at various times. Each task has a reminder/notification that needs to be sent x amount of minutes before it is planned. Simplified migration is as follows: Schema::create('user_tasks',…
How do I generate pagination links? My code looks like this: // In Model public function comments() { return $this->hasMany(Comment::class); } // In Controller public function show(User $user) { $user = User::query() ->with(['comments' => fn ($query) => $query->paginate(20)->withQueryString()]) ->find($user->id); return…
I want to use a record fields in laravel eloquent subquery I tried this $clients = Client::with(['records' => function (Builder $query) { // how can i take a record fields there? $record = $query->first(); $query->where('time', Carbon::now()->subMinutes(10 + $record->duration); }])->where('profile_id', $profile->id)->get();…
i have one problem , i try to fetch data from database to show it on view page .. when this data not ready in database , i dont want to show attempt to read property on null or 404…
I have a staff controller and transactions model. In the staff controller, I am fetching staff transactions with other data as below StaffController.php $transactions = Transaction::thisMerchant() ->earnedByStaff($staff) ->where(function ($q) use ($staffID) { $q->where('staff_id', $staffID) ->orWhere(function ($qq) use ($staffID) { $qq…
I want to add a field to an Eloquent model instance. This field data comes from a query, not a constant or a value. Yes, it could be done adding a field to $appends and adding an Attribute, but the…