| Заявки | |
|---|---|
| Пришло уникальных заявок | 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(); ?> шт. |
| Бесплатные | partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->where('cartprice', '!=', 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)->where('cartprice', '!=', 0)->checkStatus(array('statusType'=>'checkpatterns'))->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))->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']; } } } } ?>шт. |
| Заказы (маржа) | |
| Рекламные | 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')); ?> руб. |
| Бесплатные | partners()->whereIsFranchiseesOrder(0)->whereRaw(DB::raw("DATE(`partners`.datetime_of_agree)=DATE(?)"), array($startDate))->where('lead_id', '=', 0)->where('cartprice', '!=', 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)->where('cartprice', '!=', 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)->where('cartprice', '!=', 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)->where('cartprice', '!=', 0)->checkStatus(array('statusType'=>'checkpatterns'))->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`.prime_cost')); ?> руб. |
| Произведено | |
| Заказов | where('status', '=', Partner::STATUS_REGISTRATION)->count(DB::raw('distinct partner_id')); ?> шт. |
| Комплекты | count(); ?> шт. |
| Размеры | |
| Всего висит в размерах | count(); ?> шт. |
| Снято за день | — |