|
format("d.m.Y"); ?>
|
leadsWithTrashed()->whereRaw(DB::raw("DATE(`leads`.created_at)=DATE(?)"), array($date))->count(DB::raw('distinct phone'));
$leadsCnt += $cnt;
?>
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->checkStatus(array('statusType'=>'agreed'))->count() + $project->partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->checkStatus(array('statusType'=>'reject'))->count();
$ordersCnt += $cnt;
?>
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->checkStatus(array('statusType'=>'reject'))->count();
$rejectsCnt += $cnt;
?>
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->checkStatus(array('statusType'=>'production'))->count();
$productionCnt += $cnt;
?>
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->checkStatus(array('statusType'=>'agreedinwork'))->count();
$deliveringCnt += $cnt;
?>
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->checkStatus(array('statusType'=>'agreed', 'type'=>'success'))->count();
$successCnt += $cnt;
?>
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->where('paidsum', '>', 0)->checkStatus(array('statusType'=>'agreed', 'type'=>'success'))->sum('paidsum');
$successSum += $sum;
?>
руб.
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->where('paidsum', '>', 0)->checkStatus(array('statusType'=>'agreed', 'type'=>'success'))->sum(DB::raw('paidsum-prime_cost'));
$marginSum += $msum;
?>
руб.
|
partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($date))->where('paidsum', '<', 0)->checkStatus(array('statusType'=>'reject'))->sum('paidsum');
$rejectSum += $rsum;
?>
руб.
|