$user = Auth::user();
$start = Carbon::now()->subDays(6)->startOfDay();
$end = Carbon::now()->endOfDay();

$completed = DB::table('order_everpros')
->where('status', 'COMPLETED')
->whereBetween('order_date', [$start, $end])
->select(DB::raw('SUM(total_cod_disbursement) as total_profit'))
->first();

$returned = DB::table('order_everpros')
->where('status', 'RETURNED')
->whereBetween('order_date', [$start, $end])
->select(DB::raw('SUM(shipment_price) as total_loss'))
->first();

$completedProfit = $completed->total_profit ?? 0;
$returnedLoss = $returned->total_loss ?? 0;

$orderNew = TempOrder::where('status', 'pending')
->where('distributor_id', $user->distributor->id)
->count();

$orderProcess = OrderEverpro::whereIn(
'order_everpros.status',
[
'DROPOFF',
'IN PROCESS',
'ARRIVED AT DESTINATION CITY',
'ONGOING TO RECEIVER'
]
)
->join('temp_orders as o', 'order_everpros.order_id', '=', 'o.id')
->where('o.distributor_id', $user->distributor->id)
->count();

$orderCompleted = OrderEverpro::whereIn(
'order_everpros.status',
[
'DELIVERED',
'COMPLETED',
]
)
->join('temp_orders as o', 'order_everpros.order_id', '=', 'o.id')
->where('o.distributor_id', $user->distributor->id)
->count();

$orderReturned = OrderEverpro::whereIn(
'order_everpros.status',
[
'RETURNED',
]
)
->join('temp_orders as o', 'order_everpros.order_id', '=', 'o.id')
->where('o.distributor_id', $user->distributor->id)
->count();

$orderNeedProcess = OrderEverpro::whereIn(
'order_everpros.status',
[
'PAID',
'WAITING',
'WAITING FOR DROP OFF',
]
)
->join('temp_orders as o', 'order_everpros.order_id', '=', 'o.id')
->where('o.distributor_id', $user->distributor->id)
->count();