Maybe someone has already asked, but I didn't find the right answer. I need group arrays by mpn and product_id key values and count it's quantities. my array: [0] => Array ( [product] => Product HTC [mpn] => [quantity] =>…
Hey I need some help with sql query I have this data count Timestamp 1 10:05 2 10:06 3 10:07 1 10:08 2 10:09 3 10:10 I would like to obtain for each timestamp the total of count until that…
[user checks relation] [1]checks table users tablegot this console query to get the result i want but can't figure out how to make it a function in laravel. select DATE(c.check_in), group_concat(users.id), sec_to_time(sum(TIME_TO_SEC(c.check_hours))) AS total_time from users join checks c on…
So I can run two separate queries like this: SELECT date as date1, product as product1, product_id as product_id_1, SUM(revenue) AS rev1 FROM product_inventory WHERE date = '2021-11-17' GROUP BY date1 , product1, product_id_1 ORDER BY rev1 DESC SELECT date…
I'm looking for the right sql query to do the following operation: I need to display all record for today and for each make sum of price field for the curent user and date < today Table Commandes: (today =…
I am trying to filter a set of appartments by computing every possible surface the building has got, and then checking if it matches my criterias or not. Example : I have one building A that is composed of 3…
So i have table Project --------------------------------- project_id | name| --------------------------------- 1 | project 1 | 2 | project 2 | --------------------------------- table 02 report ---------------------------------------------------- report_id | report_emp | report_hours |report_project_id| --------------------------------------------------- 1 | 1 | 5 | 1 |…
How is it possible to show all orders which are not completely paid off related to a client? for e.g. SHOW ALL order details of ‘unpaid’ ORDERS for CLIENT ‘50’ table: orders id order_total client_id 1 15.00 50 2 18.50…
I have the following code that case-insensitively groups associative elements in a flat array and sums the related values, but I don't really understand how it works. function add_array_vals($arr) { $sums = []; foreach ( $arr as $key => $val…
I have a query like this Select a.ordernum, a.region, c.area, a.branchname, a.stagename, sum(case when b.entrydatetime is not null THEN 1 ELSE 0 END) as 'Total Count', sum(case when DATEDIFF(day, b.entrydatetime, GETDATE()) <=1 THEN 1 ELSE 0 END) as 'WITHIN 1…