| Проект | Заявки | Не обработано | Отказ/ Повтор/ Недозвон/ Неверный номер/ Нет денег | В работе | Снятие размеров | Оформлены/ Маржа | Ожидают предоплаты | Внесена предоплата | В производстве | Средние: доставка чек маржа |
|---|---|---|---|---|---|---|---|---|---|---|
|
name; ?> |
count('partners.id');
?>
leads()->whereRaw($dateLeadCreate)->count(); ?> |
leads()->whereRaw($dateLeadCreate)->count(); ?> |
whereIn('status', array(Partner::STATUS_REJECT, Partner::STATUS_WAIT_CLIENT_PAY_FAIL, Partner::STATUS_DELIVERING_FAIL))->count(); ?>/ whereStatus(Partner::STATUS_REPEATED)->count(); ?>/ whereStatus(Partner::STATUS_NOANSWER)->count(); ?>/ whereStatus(Partner::STATUS_TRASH_PHONE)->count(); ?>/ whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_WAIT_FRANCHISEES_PAY)->count(); ?> |
checkStatus(array('statusType'=>'work'))->count(); ?> |
whereStatus(Partner::STATUS_SIZING)->count(); ?> |
whereRaw($dateCreatePartners)->whereIn('status', array(
Partner::STATUS_PRODUCTION_WAIT,
Partner::STATUS_PRODUCTION_PROCESS,
Partner::STATUS_PRODUCTION_SUCCESS,
Partner::STATUS_REGISTRATION,
Partner::STATUS_WAIT_DELIVERING,
Partner::STATUS_WAIT_SENDING,
Partner::STATUS_DELIVERING,
Partner::STATUS_FRANCHISEES_WAIT_CLIENT,
Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY,
Partner::STATUS_SUCCESS));
$countAllAgreeFranchisees = $allAgree->count();
$franchiseesSum = $allAgree->where('partners.cartprice', '>', '1')->sum('cartprice');
//Маржа
$franchiseesCost = $allAgree->where('partners.cartprice', '>', '1')->sum('franchisees_cost');
$franchiseesMargin = $franchiseesSum - $franchiseesCost;
// ---------------- ------------//
$countAllAgree = Partner::whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->count();
$count = Partner::whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->count();
$deliveryCount = Partner::whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->count();
$sum = Partner::whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('cartprice');
$deliverySum = Partner::whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->sum('deliveryprice');
//Маржа
$productionCost = Partner::whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('prime_cost');
$margin = $sum - $productionCost;
?>
|
whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->count(); ?> |
whereRaw('(paytype = 1 AND paidsum > 0)')->count(); ?> |
whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS ))->count(); ?> |
whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->sum('deliveryprice');
$countFranchisees = $allAgree->where('partners.cartprice', '>', '1')->count();
$deliveryCountFranchisees = $allAgree->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->count();
// --
$deliveryAvg = 0;
$sumAvg = 0;
$marginAvg = 0;
if ($deliveryCount || $deliveryCountFranchisees) {
$deliveryAvg = ($deliverySum + $deliverySumFranchisees) / ($deliveryCount + $deliveryCountFranchisees);
}
if ($count || $countFranchisees) {
$sumAvg = ($sum + $franchiseesSum)/ ($count + $countFranchisees);
$marginAvg = ($margin + $franchiseesMargin) / ($count + $countFranchisees);
}
?>
|
|
Франчайзи |
whereRaw($dateCreatePartners)->count('partners.id'); ?> |
0 |
whereRaw($dateCreatePartners)->whereIn('status', array(Partner::STATUS_REJECT, Partner::STATUS_WAIT_CLIENT_PAY_FAIL, Partner::STATUS_DELIVERING_FAIL))->count(); ?>/ whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_REPEATED)->count(); ?>/ whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_NOANSWER)->count(); ?>/ whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_TRASH_PHONE)->count(); ?>/ whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_WAIT_FRANCHISEES_PAY)->count(); ?> |
whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'work'))->count(); ?> |
whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_SIZING)->count(); ?> |
|
whereRaw($dateCreatePartners)->whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->count(); ?> |
whereRaw($dateCreatePartners)->whereRaw('(paytype = 1 AND paidsum > 0)')->count(); ?> |
whereRaw($dateCreatePartners)->whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS ))->count(); ?> |
|
|
|
whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->count();
?>
|
0 |
whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'reject'))->count();
// повторы
$pointRepeated = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_REPEATED)->count();
// недозвон
$pointNoanswer = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_NOANSWER)->count();
// неверный телефон
$pointTrashPhone = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_TRASH_PHONE)->count();
?>
/ / / / 0 |
whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'work'))->count(); ?> | whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_SIZING)->count(); ?> |
whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->count();
$pointAgree = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->count();
//кол-во доставляемых
$pointdeliveryCount = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->count();
// сумма оформленных
$pointAgreeSum = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('cartprice');
//сумма доставляемых
$pointdeliverySum = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->sum('deliveryprice');
//маржа
$productionCost = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('prime_cost');
$margin = $pointAgreeSum - $productionCost;
?>
|
whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->count(); ?> | whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereRaw('(paytype = 1 AND paidsum > 0)')->count(); ?> | whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS))->count(); ?> |
|
|
entrypoint;; ?> |
whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
?>
leads()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateLeadCreate)->count(); ?> |
leads()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateLeadCreate)->count(); ?> |
whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'reject'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
// повторы
$pointRepeated = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_REPEATED)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
// недозвон
$pointNoanswer = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_NOANSWER)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
// неверный телефон
$pointTrashPhone = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
?>
/ / / / 0 |
whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'work'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count(); ?> | whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_SIZING)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count(); ?> |
whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
$pointAgree = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.cartprice', '>', '1')->count();
//кол-во доставляемых
$pointdeliveryCount = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
// сумма оформленных
$pointAgreeSum = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.cartprice', '>', '1')->sum('cartprice');
//сумма доставляемых
$pointdeliverySum = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->sum('deliveryprice');
//Маржа
$productionCost = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.cartprice', '>', '1')->sum('prime_cost');
$margin = $pointAgreeSum - $productionCost;
?>
|
whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count(); ?> | whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereRaw('(paytype = 1 AND paidsum > 0)')->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count(); ?> | whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count(); ?> |
|