projects()->whereUsecrm(1)->whereType(Project::TYPE_SHOP)->get() as $currentProject): ?> name; ?>

Статистика по заявкам

leads()->withTrashed()->whereRaw($dateWhere2)->groupBy('entrypoint')->orderBy('entrypoint', 'ASC')->get(array(DB::raw('COUNT(*) as cnt, entrypoint'))); ?>

Проект	Заявки	Не обработано	Отказ	Повтор	Неверный номер	В работе	Ожидают оплаты	Оплачены	Оформлены	Средняя доставка/средний чек
name; ?>	leadsWithTrashed()->whereRaw($dateWhere2)->count(DB::raw('distinct visitor_id')); $leadsCnt2 = $project->leadsWithTrashed()->whereRaw($dateWhere2)->count(); $leadsCntDiff = 0; //$leadsCntDiff = $leadsCnt - $project->leadsWithTrashed()->whereRaw('TIME(created_at)count(DB::raw('distinct visitor_id')); ?> () 0): ?>+	leads()->whereRaw($dateWhere2)->count(); ?>	partners()->checkStatus(array('statusType'=>'reject'))->whereRaw($dateWhere)->count(); ?>	partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw($dateWhere)->count(); ?>	partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw($dateWhere)->count(); ?>	partners()->checkStatus(array('statusType'=>'work'))->whereRaw($dateWhere)->count(); ?>	partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw($dateWhere)->count(); ?>	partners()->whereIn('status', array(Partner::STATUS_DELIVERY_AFTER_REGISTRATION, Partner::STATUS_DELIVERY_AFTER_WAIT_DELIVERING))->whereRaw($dateWhere)->count(); ?>	partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereRaw($dateWhere)->count(); $deliveryCount = $project->partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw($dateWhere)->count(); $sum = $project->partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereRaw($dateWhere)->sum('cartprice'); $deliverySum = $project->partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw($dateWhere)->sum('deliveryprice'); ?> partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereRaw($dateWhere)->sum('purchaseprice'); ?>
entrypoint; ?>	leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateWhere2)->count(DB::raw('distinct visitor_id')); $leadsCnt2 = $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateWhere2)->count(); $leadsCntDiff = 0; //$leadsCntDiff = $leadsCnt - $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw('TIME(created_at)count(DB::raw('distinct visitor_id')); ?> () 0): ?>+	leads()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateWhere2)->count(); ?>	partners()->checkStatus(array('statusType'=>'reject'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); ?>	partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); ?>	partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); ?>	partners()->checkStatus(array('statusType'=>'work'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); ?>	partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); ?>	partners()->whereIn('status', array(Partner::STATUS_DELIVERY_AFTER_REGISTRATION, Partner::STATUS_DELIVERY_AFTER_WAIT_DELIVERING))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); ?>	partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); $deliveryCount = $project->partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->count(); $sum = $project->partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->sum('cartprice'); $deliverySum = $project->partners()->checkStatus(array('statusType'=>'agreed', 'type'=>'all'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->sum('deliveryprice'); ?> partners()->checkStatus(array('statusType'=>'agreed', 'type' => 'all'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint=?)'), array($entrypoint->entrypoint))->sum('purchaseprice'); ?>