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…
I have the following Models and relationships. AppSubscriber.php <?php namespace AppModels; use IlluminateDatabaseEloquentModel; use IlluminateSupportFacadesDB; use IlluminateSupportStr; use IlluminateFoundationAuthUser as Authenticatable; use IlluminateNotificationsNotifiable; use GrosvLaravelPasswordlessLoginTraitsPasswordlessLogin; class Subscriber extends Authenticatable { use Notifiable, PasswordlessLogin; public function customFieldValues() { return $this->morphMany(CustomFieldValue::class, 'customFieldValueable');…
say Table A and Table B (table B has a foreign key a_id) I want to be able to update a row in A as long as it's not ref in B I already did it but I'm looking for…