partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->checkStatus(array('statusType'=>'agreed'))->get() as $partner) { foreach ($partner->getCart() as $item) { foreach ($item as $item2) { if($item2['quant'] > 0) { $productsQuant += $item2['quant']; } } } } foreach($project->partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->checkStatus(array('statusType'=>'checkpatterns'))->get() as $partner) { foreach ($partner->getCart() as $item) { foreach ($item as $item2) { if($item2['quant'] > 0) { $productsQuant += $item2['quant']; } } } } ?>

Заявки
Пришло уникальных заявок	leadsWithTrashed()->whereRaw(DB::raw("DATE(`leads`.created_at)=DATE(?)"), array($startDate))->count(DB::raw('distinct phone')); ?> шт.
Обработано уникальных заявок	leadsWithTrashed()->whereRaw(DB::raw("DATE(`leads`.created_at)=DATE(?)"), array($startDate))->whereNotNull('deleted_at')->count(DB::raw('distinct phone')); ?> шт.
Заказы
Рекламные	partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '!=', 0)->checkStatus(array('statusType'=>'agreed'))->count() + $project->partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '!=', 0)->checkStatus(array('statusType'=>'checkpatterns'))->count(); ?> шт.
Из StreamWood	partners()->whereIsFranchiseesOrder(0)->where('partners.info_source_id','=', 5)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->count(); ?> шт.
Из Vk.com	partners()->whereIsFranchiseesOrder(0)->whereIn('partners.info_source_id',array(1,2))->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->count(); ?> шт.
Входящий звонок	partners()->whereIsFranchiseesOrder(0)->whereNotIn('partners.info_source_id',array(1,2,5))->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->count(); ?> шт.
Из размеров	on('partners.id', '=', 'refrences.partner_id'); }) ->whereRaw(DB::raw("DATE(`refrences`.created_at)=DATE(?)"), array($startDate))->where('refrences.status', '=', Partner::STATUS_SIZING_END)->where('partners.is_franchisees_order', '=', 0)->count(DB::raw('distinct refrences.partner_id')); ?> шт.
На обмен	partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('cartprice', '=', 0)->checkStatus(array('statusType'=>'agreed'))->count(); ?> шт.
Проверка лекал	partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->checkStatus(array('statusType'=>'checkpatterns'))->count(); ?> шт.
Ушли в снятие размеров	on('partners.id', '=', 'refrences.partner_id'); }) ->whereRaw(DB::raw("partners.status=?"), array(Partner::STATUS_SIZING))->whereRaw(DB::raw("DATE(`refrences`.created_at)=DATE(?)"), array($startDate))->where('refrences.status', '=', Partner::STATUS_SIZING)->where('partners.is_franchisees_order', '=', 0)->count(DB::raw('distinct refrences.partner_id')); ?> шт.
Комплекты
Комплекты	шт.
Заказы (маржа)
Рекламные	partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '!=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice')) + $project->partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '!=', 0)->checkStatus(array('statusType'=>'checkpatterns'))->sum(DB::raw('cartprice')); ?> руб. / partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '!=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice-prime_cost')) + $project->partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '!=', 0)->checkStatus(array('statusType'=>'checkpatterns'))->sum(DB::raw('cartprice-prime_cost')); ?> руб.
Из StreamWood	partners()->whereIsFranchiseesOrder(0)->where('partners.info_source_id','=', 5)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice')); ?> руб. / partners()->whereIsFranchiseesOrder(0)->where('partners.info_source_id','=', 5)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice-prime_cost')); ?> руб.
Из Vk.com	partners()->whereIsFranchiseesOrder(0)->whereIn('partners.info_source_id',array(1,2))->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice')); ?> руб. / partners()->whereIsFranchiseesOrder(0)->whereIn('partners.info_source_id',array(1,2))->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice-prime_cost')); ?> руб.
Входящий звонок	partners()->whereIsFranchiseesOrder(0)->whereNotIn('partners.info_source_id',array(1,2,5))->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice')); ?> руб. / partners()->whereIsFranchiseesOrder(0)->whereNotIn('partners.info_source_id',array(1,2,5))->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->checkStatus(array('statusType'=>'agreed'))->sum(DB::raw('cartprice-prime_cost')); ?> руб.
Из размеров	on('partners.id', '=', 'refrences.partner_id'); }) ->whereRaw(DB::raw("DATE(`refrences`.created_at)=DATE(?)"), array($startDate))->where('refrences.status', '=', Partner::STATUS_SIZING_END)->where('partners.is_franchisees_order', '=', 0)->sum(DB::raw('`partners`.cartprice')); ?> руб. / on('partners.id', '=', 'refrences.partner_id'); }) ->whereRaw(DB::raw("DATE(`refrences`.created_at)=DATE(?)"), array($startDate))->where('refrences.status', '=', Partner::STATUS_SIZING_END)->where('partners.is_franchisees_order', '=', 0)->sum(DB::raw('`partners`.cartprice-`partners`.prime_cost')); ?> руб.
Проверка лекал	partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->checkStatus(array('statusType'=>'checkpatterns'))->sum(DB::raw('`partners`.cartprice')); ?> руб. / partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->checkStatus(array('statusType'=>'checkpatterns'))->sum(DB::raw('`partners`.cartprice-`partners`.prime_cost')); ?> руб.
Произведено
Заказов	where('status', '=', Partner::STATUS_REGISTRATION)->count(DB::raw('distinct partner_id')); ?> шт.
Комплекты	count(); ?> шт.
Размеры
Всего висит в размерах	count(); ?> шт.
Снято за день	—