startSection('title'); ?> @parent Статистика stopSection(); ?> startSection('css'); ?> stopSection(); ?> startSection('js'); ?> stopSection(); ?> startSection('content'); ?> projects()->whereUsecrm(1)->get() as $project): ?> name; ?> */ ?>

Статистика по сегодняшним заявкам

Проект	Заявки	Не обработано	Отказ	Повтор	Неверный номер	Снятие размеров	В работе	Ожидают оплаты	Оплачены	Оформлены
name; ?>	leadsWithTrashed()->whereRaw('DATE(created_at)=DATE(NOW())')->count(); ?>	leads()->whereRaw('DATE(created_at)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'reject'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->whereStatus(Partner::STATUS_SIZING)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'work'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->where('paytype', '=', 1)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->count(); ?> partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice'); ?> partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('prime_cost'); ?>

Статистика по прошлым заявкам

Проект	Заявки	Не обработано	Отказ	Повтор	Неверный номер	Снятие размеров	В работе	Ожидают оплаты	Оплачены	Оформлены
name; ?>	leadsWithTrashed()->whereRaw('DATE(created_at)!=DATE(NOW())')->count(); ?>	leadsWithTrashed()->whereRaw('DATE(created_at)!=DATE(NOW())')->whereNull('deleted_at')->count(); ?>	partners()->checkStatus(array('statusType'=>'reject'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->whereStatus(Partner::STATUS_SIZING)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'work'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->where('paytype', '=', 1)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->count(); ?> partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice'); ?> partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('prime_cost'); ?>

Итого оформлено сегодня

Проект	Ожидают оплаты	Оплачены	Оформлены
name; ?>	partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('DATE(updated_at)=DATE(NOW())')->count(); ?>	partners()->where('paytype', '=', 1)->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->count(); ?>	partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->count(); ?> partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice'); ?> partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->sum('prime_cost'); ?>

Распределение заявок по часам

stopSection(); ?> make('layouts.default', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>