I am developing a sort of multi-tenant application with Laravel 11 on PHP 8.3, where each "user" must belong to a "company". For user management, I started from Laravel Breeze, and then modified the users table to include a company_id…
I have two tables that are connected with a pivot table. shows: +----+--------+ | id | show | +----+--------+ | 1 | show1 | | 2 | show2 | | 3 | show3 | +----+--------+ draft_types: +----+--------+ | id |…
I have an eloquent query: $cameras=Jump::Video() ->with('flight','flight.aircraft','flight.airfield') ->with('student','student.logininfo','student.logininfo.reservations') ->with('camera','camera.status') ->whereBetween('data',[ $from, $to]) ->orderBy($sortBy, $orderDesc) ->paginate($request->perPage); and relations between student, logininfo and reservations Model Jump.php public function scopeVideo($query) { return $query->where('exercise', '104'); } public function student() { return $this->hasOne('AppModelsPersonalData','id','student'); } Model…
I have three models: Group, Activity, User. With the following relationships in the models. Activities belongTo a Group (with the group_id being a field in the activity) Users belongTo a Group (with the group_id being a field in the user)…
Imagine we have a Facture and Item model in a one-to-many relationship. I'm using $facture->items() or $facture->load('items') and it works perfectly. However, when I need to use a condition on items like where('items.price', 30), I have no idea how to…
please help, I've been stuck here since then. I want to insert shipmentrequestitem from shipmentrequest model using update method public function update(UpdateShipmentRequestRequest $request, $id) { $shipmentRequest = ShipmentRequest::with( 'shipmentRequestItems', )->where('id',$id)->first(); $shipmentRequest->update($request->all()); $validatedData = $request->validated(); $shipmentRequestItems = $validatedData['shipmentRequestItems']; // $shipmentRequest =…
i have a 3 tables rentals table,unit sizes tables and rental_units_pivot table.the rentals table contains the details of a rental,the unit sizes table contains a list of the units sizes such as i bedroom,2 bed room,etc.A rental facility might have…
here is my code - $list = Plot::active() ->whereNotNull('user_id') ->distinct('user_id') ->with('user') ->paginate(10); but here "distinct('user_id')" not working. I want only unique user_id.
I have a ModelA with columns: name, last_name, email I want ModelA with the name Test to add an extra where on email what I tried is the following $model_a_res = A::when( function($query){ return $query->where('name','Test'); }, function ($query) { $query->where('email',…
stores table (id, name) store_opening_hours table (id, store_id, day_of_week, opens_at, closes_at) StoreFactory.php file: class StoreFactory extends Factory { public function definition(): array { return [ 'name' => fake()->company ]; } } StoreOpeningHourFactory.php file: class StoreOpeningHourFactory extends Factory { public function…