Relation public function groups() { return $this->belongsToMany('AppModelsItemGroup','item_to_group','item_id','item_group_id'); } ** How to select all Items that have item_group_id 0 and 9 BOTH?** $zero_and_nine_count = AppModelsItem::with(['groups' => function ($query) { $where[] = ['item_group_id', , 0]; $where[] = ['item_group_id', '=', 9]; $query->where($where); }])->count();…
How can I change this query [email protected]? $query = "select * from nozzle a left join nozzlereading b on a.id = b.nozzle and b.date=" . $date . " where a.meter=" . $meterid; $reading = DB::select($query); My models are Nozzle and…
I have made my own Access Control List with Laravel 9 and basically, I made also a Many To Many relationships between User & Role: User Model: public function roles() { return $this->belongsToMany(Role::class); } Role Model: public function users() {…
My view displays collections from four different tables. $redtable is my longest collection. @for ($i = 0; $counter < $redtable->count(); $i++) <div> {{ $red->slice($i, 1)->first()?->content }} {{ $green->slice($i, 1)->first()?->content }} {{ $blue->slice($i, 1)->first()?->content }} {{ $gray->slice($i, 1)->first()?->content }} <div> @endfor…
I have two related models in a job listing application, Company and Listing. The relationship between them is that company may have listing and a listing must have exactly one company. class Company extends Model { use HasFactory; /** *…
I want to make a chat app. So I can get a list of patient but the top last message doesn't have the patient. How to solve my problem. PHP : $appointment = Appointment::with([ 'upcoming.consultant' => function($query) use ($user) {…
I have two models, User and Post, where a User can have multiple Post models. In my application, I only want to retrieve the title column from the related Post model when querying for a User. Here is my current…
I have a Laravel application. I am performing the user information update function, but I can't bypass the validation check for the admin_email and admin_title fields in the tbl_admin database. I am using the following FormRequest: <?php namespace AppHttpRequests; use…
I have a small Laravel app that is basically a few tables as follows and I'm having a problem with Laravel Eloquent generating more SQL queries than it needs. I am basically trying to display all 'grades' for a student…
I am trying to figure out how to form my database query to build up a collection of projects, each of which has a set of personnel with their assigned working periods and the daily shift hours that they submit.…