Witam
![smile.gif](style_emoticons/default/smile.gif)
Dodaje pytanie tutaj mimo tego ze troche zwiazane jest z Laravelem. Z gory przepraszam.
SELECT qc_checks.order_id,
qc_checks.created_at,
qc_checks.operator,
despatches.no_of_boxes,
order_items.id,
order_items.qty_order,
order_items.tax_amount,
users.name,
order_items.unit_price, order_items.qty_order * order_items.unit_price AS despValueNet, order_items.tax_rate
FROM qc_checks
INNER JOIN order_items ON qc_checks.order_id = order_items.order_id
INNER JOIN users ON qc_checks.operator = users.id
INNER JOIN
despatches ON qc_checks.order_despatch_no = despatches.order_despatch_id
AND
qc_checks.order_id = despatches.order_id
WHERE
(qc_checks.`type` = 'DESPATCH')
AND (qc_checks.created_at>='2020-03-01 00:00:00')
AND ( qc_checks.created_at < '2020-03-23 23:59:59');
Takie mam zapytanie ktore pobiera mi dane z bazy. W tak zwanym miedzy czasie przy pomocy laravela pobieram sobie wyniki.
$data = $collection->pipe(function ($collection) {
return collect([
'net_total' => number_format($collection->sum('despValueNet'), 2), 'despatches' => $collection->count('order_id'),
'average_net_order' => number_format($collection->sum('despValueNet') / $collection->count('order_id'), 2), 'gross_total' => number_format($collection->sum('despValueNet') + $collection->sum('tax_amount'), 2
) ]);
});
I teraz moje pytanie, czy jest mozliwosc w tym zapytaniu pogrupowac wyniki :
- kazdy dzien zawieral `operatorow` imie
- liczbe ich rekordow
- sume `despValueNet`
Z gory dziekuje.