I am trying to do union with DB query builder because with models is not working the union with paginate/cursorPaginate. I have this but give an SQL error because Laravel is not building the right query (maybe my fault, I…
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'm trying to update event name through postman with the following json object: PUT {{base_url}}events/1 { "name":"this Event Name is Edited" } in my controller i'm using sometimes constraint because not all fields must be updated, it could be only…
Imagine I had 4 models as follows: Year Position PositionAllowance : This is a pivot table of Position and Year, with the addition of "allowance" i.e. it defines the amount of allowance for each position in a specified year. Employee…
I want to filter records with relation which has another relation with conditions and with count > 0 Code: $classClass = ClassClass::query() ->with('parent') ->with('children', function (BelongsTo $query) { $query ->withCount(['serialNumbers' => function($query) { $query ->whereNull('serial_number_parent_id') ->whereNull('inherit_class_for_serial_number_id'); }]); }) ->where('parent_class_id','=', $class->id)…
I'm trying to convert a json column name with path 'foo->bar' to be compatible with mysql/postgresql using Laravel's wrapJsonSelector() method. How can I access this method from the query builder calling getGrammar throws error: Method IlluminateDatabaseQueryGrammarsMySqlGrammar::isJsonSelector does not exist. Eg…
laravel query with fetch data I have below table in "ORDCOMPLETE" is duplicate with same order ID #11310, so I need to remove this duplicate id with the same prefix. #11309 ORDCOMPLETE7104671693208650 $30 #11310 ORDCOMPLETE4335631693207733 $30 #11310 ORDCOMPLETE4335631693207744 $30 #11310…
This is driving me nuts. I have a super simple query that runs correctly in MySQL but returns no results in Laravel Eloquent: Laravel Code that returns no results. $feedback = FeaturedFeedback::where("company_id", "=", $company->id); if ($request->category != "") { $category…
I have table with records. In table i have column 'payment_date', and it's integer with unix timestamp. I need to select records from the database that are in the time interval of two days for each year and each month..…
I want to get each employees task count in a month and integrate into bar chart,i managed to get total count of tasks based in a month i am confused how to do that user based,let's say i have 10…