I have a query to return: All schedules that doesn't have program or all schedules that have at least a program but the program is yet to end. The issue is that, the query returns all schedules that doesn't have…
I am creating a virtual shop website and I'm trying to do a Product register page. Some of the fields from the product form are not required, so I need a way to make my Controller only add the columns…
I want to join two tables with laravel relationship, but I've gotten stuck. I have 2 MySSL tables table strans + id + trans_code + trans_description table step + step_id + step_trans_code + step_proc_sequence My models look like this: class…
Looking for laravel equivalent of a Query. SELECT * FROM ( SELECT * FROM tbl ORDER BY updated_at LIMIT 20 ) ORDER BY random() LIMIT 5; Please assume we have a model class "TableA" that already exists. Inner query can…
I keep running into this one over and over again, and seeking if there is a better (much more optimized) way to achieve this. Requirement : From a table XYZ select a random n rows (n can be one or…
I want to retrieve all places where parent_place_id = 999 in the attractions table. What relationships would I set up and what would this query look like? I've tried using the "Has Many Through" relationship, but I'm not sure if…
I'm trying to make a custom table widget in filament for showing best selling products. When I do sum(quantity) as total_quantity, it gives me Column not found error. Here's my entire code and the error message : public function table(Table…
I am very new to Laravel. I am still learning the concepts. I tried to google this problem but i don't think I know what to type? I am retrieving a single row, single column of data from my database…
I have a table journals having columns transaction_id, type(receipt or payment), debit and credit columns for amount, account_id relation with accounts table the records can be multiple receipt or payment entries, and an opposite entry to record sum of these…
this code is not working: $removedEmployees = $mergedEmployees->diff($uniqueEmployees); here is my code. $employees1 = Employee::where('employment_status', '<>', 'SEPARATED') ->where('client_code_1', $client->client_code) ->where('position', $grouping->position) ->where('billable_rate', $grouping->billable_rate) ->get(); $employees2 = Employee::where('employment_status', '<>', 'SEPARATED') ->where('client_code_2', $client->client_code) ->where('position', $grouping->position) ->where('billable_rate', $grouping->billable_rate) ->get(); $mergedEmployees = $employees1->merge($employees2); $uniqueEmployees…