where('created_at','>',date('Y-m-d',strtotime('first day of last month')).' 00:00:00')
->where('created_at','<',date('Y-m-d',strtotime('first day of this month')).' 00:00:00')
->where('deleted_at','>',date('Y-m-d',strtotime('first day of this month')).' 00:00:00')
->select('id')
->get();
$totalDeletedReoccuringRevenue = 0.00;
$totalDeletedOneTimeRevenue = 0.00;
foreach($lastMonthDeleted as $deletedOrder)
{
foreach(\App\Ordered_Service::where('order','=',$deletedOrder->id)->get() as $orderedService)
{
$theService = \App\Service::where('id','=',$orderedService->service)->first();
if($theService && $theService->billing_type == 'monthly')
{
$totalDeletedReoccuringRevenue += $theService->price;
}
if($theService && $theService->billing_type == 'once')
{
$totalDeletedOneTimeRevenue += $theService->price;
}
}
}
?>
Previously active orders created in that have been deleted this month:
count()); ?>
(MRC: $ | NRC: $)