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',…
I'm encountering a PHP execution time error while inserting approximately 250k records into a MySQL database using Laravel Eloquent. I'm aiming to achieve this without increasing the overall execution time, considering the following constraints: Frontend: Angular Multi-tenancy: Implemented using https://tenancyforlaravel.com/…
I have this long query builder where I am basically searching a table and then filter the results based on the passed query strings: $projects = Listing::query() ->when(request('q'), function($builder) { $builder->searchQuery(request('q')); }) ->when(request('tags'), function($builder) { $tags = request('tags'); $builder->whereHas('tags', function($builder)…
I have a schools table, I also have a school_relations table. The issue is i want to only show once relation between schools and not have to repeat it the other way round on the table of the relations. Here…
I'm dispatching a delayed job that should created some entries in the database: `$userId = Auth::user() ? Auth::user()->getAuthIdentifier() : null; $job = new DelayedAddPeopleJob($event, $userId); dispatch($job)->delay(DelayedAddPeopleJob::DELAY);` After 15 minutes DelayedAddPeopleJob is executed and in there im creating entries in the…
I have User and Holiday models related this way: User model: class User extends Authenticatable { public function holidays(): HasMany { return $this->hasMany(Holiday::class); } Holiday model: class Holiday { protected $fillable = [ 'dayoff', // DATE YYYY-MM-DD 'user_id', ]; public…
I am using a third party table which very annoyingly has name and surname fields. The first name goes into name and of course the surname goes into surname. I want to concat these together in the model as I…
I have four tables: supplies, stocks, stock_ins, and stock_outs. In the Stock controller, I want to sum the total stock_out for each supply . For this, I have used the following query: $supplies = Stock::select( 'supplies.name', 'stocks.supply_id', 'stocks.id', 'stocks.stock', 'stock_ins.quantity…
For this issue, I have reduced the complexity of the database. I have a table with Orders id name And a table with Suborders id order_id user_id One order may contain numerous suborders. A suborder is only connected to one…