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 =…
I have multiple tables with millions of records, and I'm facing performance challenges with my current Eloquent queries. I have three tables = 'sales', 'expenses', and 'profits' Each table has columns such as 'amount', 'date', and 'category_id' I need to…
I have tables called event and eventinfo. Where the event hasMany eventinfo. I am trying to get the event that has eventinfo with active=1, but it get all the eventinfo whether active is 0 or 1. $eventsInfo = Event::find($eventId) ->whereHas('EventInfo',…
I have a model named Document, Document has a status field where the possible values are, let's say dummy_data ['done', 'failed', 'sent', ....]. I want to get all documents where status='done' if they are present in DB OR all documents…
I'm trying to archive month date 1 to month end date with. below code now get this year month complete date 1 to 31 by below code. but it only gives current year month I want to pass dynamic year…
After retrieving the first article number, I can only obtain the data for all products from the query. Each product has a "type_id" that determines in which junction table the product options can be found. My question is how can…
I need to get data of default_item_name relationship by using command php artisan schedule: run. but I am not getting default_item_name relationship data is empty because event_id not passed from controller. My code is Below. CronController public function sendFoodMenuPdfEmailOrTelegram() {…
I make a controller function to insert new records on the quizzes table. To do that, I used Laravel mass assignment, and after that, I got this error message. "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field…