39 lines
1.4 KiB
PHP
39 lines
1.4 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
namespace Modules\Report;
|
||
|
|
|
||
|
|
use Modules\Order\Entities\Order;
|
||
|
|
|
||
|
|
class CustomersOrderReport extends Report
|
||
|
|
{
|
||
|
|
protected function view()
|
||
|
|
{
|
||
|
|
return 'report::admin.reports.customers_order_report.index';
|
||
|
|
}
|
||
|
|
|
||
|
|
protected function query()
|
||
|
|
{
|
||
|
|
return Order::select('customer_id', 'customer_first_name', 'customer_last_name', 'customer_email')
|
||
|
|
->selectRaw('MIN(orders.created_at) as start_date')
|
||
|
|
->selectRaw('MAX(orders.created_at) as end_date')
|
||
|
|
->selectRaw('COUNT(*) as total_orders')
|
||
|
|
->join('order_products', 'orders.id', '=', 'order_products.order_id')
|
||
|
|
->selectRaw('SUM(order_products.qty) as total_products')
|
||
|
|
->selectRaw('SUM(orders.total) as total')
|
||
|
|
->when(request()->has('customer_name'), function ($query) {
|
||
|
|
$query->where('customer_first_name', 'like', request('customer_name') . '%')
|
||
|
|
->orWhere('customer_last_name', 'like', request('customer_name') . '%');
|
||
|
|
})
|
||
|
|
->when(request()->has('customer_email'), function ($query) {
|
||
|
|
$query->where('customer_email', request('customer_email'));
|
||
|
|
})
|
||
|
|
->groupBy([
|
||
|
|
'orders.id',
|
||
|
|
'customer_id',
|
||
|
|
'customer_first_name',
|
||
|
|
'customer_last_name',
|
||
|
|
'customer_email',
|
||
|
|
]);
|
||
|
|
}
|
||
|
|
}
|