startSection('title'); ?> @parent Статистика по менеджерам stopSection(); ?> startSection('breadcrumbs'); ?> stopSection(); ?> startSection('js'); ?> stopSection(); ?> startSection('content'); ?>

Статистика по менеджерам


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

Менеджеры

за с по

count() == 1): ?> whereRaw('id in (SELECT user_id FROM users_projects WHERE project_id=?)', array($project->id))->get() as $manager): ?> partners()->whereUserId($manager->id)->whereRaw($dateWhere)->count(); $stat = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->get(array(DB::raw('COUNT(*) as cnt, SUM(cartprice) as cartprice, SUM(purchaseprice) as purchaseprice, SUM(discount) as discount')))->first(); $rejectsQuant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->checkStatus(array('statusType'=>'reject'))->count(); $agreePercent = 0; $rejectsPercent = 0; if ($leadsQuant) { $agreePercent = round(($stat->cnt * 100) / $leadsQuant, 0); $rejectsPercent = round(($rejectsQuant * 100) / $leadsQuant, 0); } ?> hasRole(Role::ROLE_CRM) && !$manager->isAdmin() && ($leadsQuant || $stat->cnt)): ?> partners()->whereRaw($dateWhere)->count(); $stat = $project->partners()->whereRaw($dateWhere)->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->get(array(DB::raw('COUNT(*) as cnt, SUM(cartprice) as cartprice, SUM(purchaseprice) as purchaseprice, SUM(discount) as discount')))->first(); $rejectsQuant = $project->partners()->whereRaw($dateWhere)->checkStatus(array('statusType'=>'reject'))->count(); $agreePercent = 0; $rejectsPercent = 0; if ($leadsQuant) { $agreePercent = round(($stat->cnt * 100) / $leadsQuant, 0); $rejectsPercent = round(($rejectsQuant * 100) / $leadsQuant, 0); } ?>
Менеджер Заявок Отказов Оформлено Менее 1 минуты 1-5 минут 5-10 минут 10-30 минут 30-60 минут Более часа

first_name; ?> last_name; ?>

(%)

cnt; ?> (%)
cartprice; ?>
cnt) ? (round($stat->cartprice / $stat->cnt, 0)) : 0; ?> cartprice - $stat->purchaseprice; ?> */ ?>

partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->count(); $quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->count(); $quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->count(); $quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->count(); $quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->count(); $quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->count(); $quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%
count() == 1): ?>

Итого

name; ?>

(%)

cnt; ?> (%)
cartprice; ?>
cnt) ? (round($stat->cartprice / $stat->cnt, 0)) : 0; ?> cartprice - $stat->purchaseprice; ?> */ ?>

partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->count(); $quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->count(); $quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->count(); $quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->count(); $quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->count(); $quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

/
%

 partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->count(); $quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count(); $sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice'); $quantPercent = 0; if ($quantAll) { $quantPercent = round(($quant * 100) / $quantAll, 0); } ?>

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