I have a many to many relationship between Users & Courses with a pivot table, Users_Courses, containing an isComplete value, but i can't seem to retrieve the isComplete value without looping through every user, getting their courses and then looping…
I have this 3 tables and I want to get the same subjects by given student_id For example I will select Vince (student_id = 1) And Jane (student_id = 3) the return value should be the subjects english and science.
I'm training with many to many relationships and today i'm trying to compare 2 pivot tables. I'm trying a site for a nutritionist. On one hand the nutritionist/admin can create patient's card (my table "User". In this cards he informs…
I have two columns called price and date, so i want to sum the total of price where the month is 01: price | date ------------------- 200 | 01-01-2022 100 | 09-01-2022 400 | 01-03-2022 120 | 01-06-2022 Here my…
I have a complicated query that I would like to translate either in Eloquent ORM or with the Query Builder for a Laravel site, but I can't do it, can someone help me? Here is my SQL query SELECT opp_id,…
I have a User model which has a hasMany relationship to a Brands model and I am having issues updating the Brands for a user properly. I have a form which allows a user to enter / delete / update…
My Product Model is public function IncomeRepo(){ return $this->hasMany(Income::class,'Product'); } My Income Report Model Is public function ProductData(){ return $this->belongsTo(Product::class,'Product','id'); } My Query is public function SearchIncomeData(Request $request){ $GetFromDate = $request->FromDate; $GetToDate = $request->ToDate; $ProductData = Product::with('IncomeRepo')->whereBetween('created_at', [$GetFromDate, $GetToDate])->get(); return…
The following are the function that I am trying to make work. I think I have the information required correct and the corresponding data also exist in the table but it is showing the error as above. Below are the…
I am trying to work through the below code and it is giving me the error as above in postman. I thought that by storing AttendanceRecord in a variable should've sufficed. I wonder what did I do wrong ? Below…
I am currently developping a crud application with Laravel. I have an Ad class that contains a user_id and a model_id. I want to filter my ads with user and model table fields. I managed to do the request with…