startSection('title'); ?> @parent Статистика CRM stopSection(); ?> startSection('breadcrumbs'); ?> stopSection(); ?> startSection('js'); ?> stopSection(); ?> startSection('content'); ?>

Статистика CRM

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

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

leads()->withTrashed()->whereRaw('DATE(created_at)=DATE(NOW())')->groupBy('entrypoint')->orderBy('entrypoint', 'ASC')->get(array(DB::raw('COUNT(*) as cnt, entrypoint'))); ?>
Проект Заявки Не обработано Отказ Повтор Неверный номер В работе Ожидают оплаты Оплачены Оформлены

name; ?>

 leadsWithTrashed()->whereRaw('DATE(created_at)=DATE(NOW())')->count(DB::raw('distinct visitor_id')); $leadsCnt2 = $project->leadsWithTrashed()->whereRaw('DATE(created_at)=DATE(NOW())')->count(); $leadsCntDiff = $leadsCnt - $project->leadsWithTrashed()->whereRaw('TIME(created_at)count(DB::raw('distinct visitor_id')); ?>

() 0): ?>+

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()->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()->whereIn('status', array(Partner::STATUS_DELIVERY_AFTER_REGISTRATION, Partner::STATUS_DELIVERY_AFTER_WAIT_DELIVERING))->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('purchaseprice'); ?>

   entrypoint; ?>

 leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw('DATE(created_at)=DATE(NOW())')->count(DB::raw('distinct visitor_id')); $leadsCnt2 = $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw('DATE(created_at)=DATE(NOW())')->count(); $leadsCntDiff = $leadsCnt - $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw('TIME(created_at)count(DB::raw('distinct visitor_id')); ?>

() 0): ?>+

leads()->whereEntrypoint($entrypoint->entrypoint)->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())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>

partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>

partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>

partners()->checkStatus(array('statusType'=>'work'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>

partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>

partners()->whereIn('status', array(Partner::STATUS_DELIVERY_AFTER_REGISTRATION, Partner::STATUS_DELIVERY_AFTER_WAIT_DELIVERING))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>

partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->count(); ?>
partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->sum('cartprice'); ?>
partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE DATE(created_at)=DATE(NOW()) AND entrypoint="'.$entrypoint->entrypoint.'")'))->sum('purchaseprice'); ?>

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

Проект Заявки Не обработано Отказ Повтор Неверный номер В работе Ожидают оплаты Оплачены Оформлены

name; ?>

leadsWithTrashed()->whereRaw('DATE(created_at)!=DATE(NOW())')->count(DB::raw('distinct visitor_id')); ?>

leadsWithTrashed()->whereRaw('DATE(created_at)!=DATE(NOW())')->whereNull('deleted_at')->count(DB::raw('distinct visitor_id')); ?>

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()->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()->whereIn('status', array(Partner::STATUS_DELIVERY_AFTER_REGISTRATION, Partner::STATUS_DELIVERY_AFTER_WAIT_DELIVERING))->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) 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) 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) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('purchaseprice'); ?>

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

Проект Ожидают оплаты Оплачены Оформлены

name; ?>

partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('DATE(updated_at)=DATE(NOW())')->count(); ?>

partners()->whereIn('status', array(Partner::STATUS_DELIVERY_AFTER_REGISTRATION, Partner::STATUS_DELIVERY_AFTER_WAIT_DELIVERING))->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('purchaseprice'); ?>

Распределение заявок по часам
stopSection(); ?> make('layouts.default', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>