This is driving me nuts. I have a super simple query that runs correctly in MySQL but returns no results in Laravel Eloquent: Laravel Code that returns no results. $feedback = FeaturedFeedback::where("company_id", "=", $company->id); if ($request->category != "") { $category…
Laravel 9. PHP 8.0. The task is to write an array line by line. Can you tell me why writing with eloquent in this form does not work, while writing as DB select works fine. What is my problem? Original…
I am trying to make a query using Eloquent Model in Laravel. My original query does not work Query1::where('Course_ID', '=', $request->FLA) ->where('Date', '=', Carbon::today()) I would like the query to include both inside of a single WHERE, akin to: Query1::where('Course_ID',…
I have three tables in database tableA tableB tableC All these three table have document_date. I need eloquent with model for max( ( max of document_date in table A) Union ( max of document_date in table B) Union ( max…
We have a need to store user provided translations, and the current design approached the problem in what I thought was a sufficient structure: id | language_id (FK) | item_id (FK) | translation So, if I have item A with…
i have a team, project, user, role, permissions relationship in laravel. User can have many teams, a team can have many projects and user can have User role, team role and project role. How can i get the user permissions…
I’ve next database structure: friends: id, first_name, last_name, friends_activities: friend_id, user_id, type (enum), created_at, friends_reactions: friend_id, user_id, type (enum), And I need to count all friends_reactions and friends_activity together as e.g. engagements_count. So far I’ve created eloquent relationship in the…
As @JonasStaudenmeir answered on laravel eager loading with limit, which query looks like: User::select('id') ->with([ 'posts' => fn($query) => $query->select(['id', 'user_id'])->limit(4) ]) ->limit(2) ->get(); select `id` from `users` limit 2 select * from (select `id`, `user_id`, row_number() over (partition by…
I have three models: Product Review Score They are linked like this: Product (hasMany) -> Review (hasOne) -> Score Review model: text product_id score_id Score model: value (number) My relation in Product model: public function reviews () { return $this->hasMany(Review::class,…
I am working on the Laravel back-end and I have a some question. Can I put some logic methods to the the models? Get data in specific format, for example. And some like this: public function getAllWithObjects() { $all_photos =…