| Оформлены: кол-во сумма маржа |
Доставляется | Внесена предоплата | Доставлено | Отказ | Средние: доставка чек маржа |
|---|---|---|---|---|---|
|
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))->where('partners.cartprice', '>', '1');
$countAllAgreeFranchisees = $allAgree->count();
$franchiseesCost = $allAgree->sum('franchisees_cost');
$franchiseesСartprice = $allAgree->sum('partners.cartprice');
$franchiseesProduction = $allAgree->sum('prime_cost'); // 327 600
$franchiseesDeliveryCost = $allAgree->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->sum('partners.deliveryprice');
// ---------------- ------------//
$count = Partner::whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->count();
$sum = Partner::whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('cartprice');
$productionCost = Partner::whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('prime_cost');
$deliveryCost = Partner::whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->where('partners.deliveryprice', '>', '1')->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->sum('partners.deliveryprice');
//Маржа
$margin = $sum + $franchiseesCost - $productionCost - $franchiseesProduction - $franchiseesDeliveryCost - $deliveryCost;
?>
|
whereStatus(Partner::STATUS_DELIVERING)->where('partners.cartprice', '>', '1')->count(); ?> |
whereRaw('(paytype = 1 AND paidsum > 0)')->where('partners.cartprice', '>', '1')->count(); ?> |
whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->where('partners.cartprice', '>', '1')->whereIsFranchiseesOrder(1)->sum('franchisees_cost');
$sumDelivered = Partner::whereRaw($dateCreatePartners)->whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->where('partners.cartprice', '>', '1')->whereIsFranchiseesOrder(0)->sum('cartprice');
// общая стоимость доставки
$delCostDelivered = Partner::whereRaw($dateCreatePartners)->whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->where('partners.cartprice', '>', '1')->where('partners.deliveryprice', '>', '1')->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->sum('partners.deliveryprice');
//сумма производства
$productionCostDelivered = Partner::whereRaw($dateCreatePartners)->whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->where('partners.cartprice', '>', '1')->sum('prime_cost');
//Маржа
$marginDelivered = $franchiseesCostDelivered + $sumDelivered - $delCostDelivered - $productionCostDelivered;
?>
whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->where('partners.cartprice', '>', '1')->count(); ?> |
whereIn('status', array(Partner::STATUS_REJECT, Partner::STATUS_WAIT_CLIENT_PAY_FAIL, Partner::STATUS_DELIVERING_FAIL))->whereRaw('partners.datetime_of_agree IS NOT NULL')->count();; ?> |
whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.cartprice', '>', '1')->where('partners.deliveryprice','>',1)->sum('deliveryprice');
$deliveryCountFranchisees = $allAgree->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.cartprice', '>', '1')->where('partners.deliveryprice','>',1)->count();
// --
$deliveryCount = Partner::whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.cartprice', '>', '1')->where('partners.deliveryprice','>',1)->count();
$deliverySum = Partner::whereRaw($dateCreatePartners)->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.cartprice', '>', '1')->where('partners.deliveryprice','>',1)->sum('deliveryprice');
$deliveryAvg = 0;
$sumAvg = 0;
$marginAvg = 0;
if ($deliveryCount || $deliveryCountFranchisees) {
$deliveryAvg = ($deliverySum + $deliverySumFranchisees) / ($deliveryCount + $deliveryCountFranchisees);
}
if ($count || $countAllAgreeFranchisees) {
$sumAvg = ($sum + $franchiseesСartprice)/ ($count + $countAllAgreeFranchisees);
$marginAvg = $margin / ($count + $countAllAgreeFranchisees);
}
?>
|