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…
I am trying to use a count(..) to get the count value of matching records from a related table, using Laravel 8 (Eloquent). The idea is simply to count the number of tasks assigned to each user. I already have…
I have a table inventory, which has a one-to-many relationship to a table called data. I'm creating a filter application, where the user will be able to filter inventory by color and by material for example. It's important that this…
We recently started using PHPStan 1.10 at level 6 in a Laravel 10 PHP 8.2 project. It reports a few remaining issues in the following model that I would like to fix. class ArticlePrice extends Model { protected $fillable =…