drb/app/Service/StatisticsService.php

<?php

namespace App\Service;

use App\Model\BasicType;
use App\Model\BasicTypeAllUse;
use App\Model\Customer;
use App\Model\CustomerPerFormance;
use App\Model\CustomerReport;
use App\Model\CustomerReportDepart;
use App\Model\Depart;
use App\Model\DepartIndex;
use App\Model\Employee;
use App\Model\EmployeeDepartPermission;
use App\Model\InOutRecord;
use App\Model\InvoiceOrder;
use App\Model\InvoiceOrderInfo;
use App\Model\LastJc;
use App\Model\MonthlyPerFormance;
use App\Model\Product;
use App\Model\ProductAdjustment;
use App\Model\ProductCategory;
use App\Model\PurchaseOrder;
use App\Model\PurchaseOrderInfo;
use App\Model\ReturnExchangeOrder;
use App\Model\ReturnExchangeOrderProductInfo;
use App\Model\SalesOrder;
use App\Model\SalesOrderProductInfo;
use App\Model\SalesOrderReport;
use App\Model\SeeRange;
use App\Model\Setting;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;

class StatisticsService extends Service
{
    public function statisticsCustomer($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择客资创建时间区间'];

        $model = Customer::Clear($user,$data);
        $model = $model->where('del_time',0)
            ->select('id','model_type','customer_from','top_depart_id')
            ->orderby('id', 'desc');

        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

        $list = $model->get()->toArray();
        $list1 = $this->fillStatisticsCustomer($list);
        $list2 = $this->fillStatisticsCustomer2($list);
        $list3 = $this->fillStatisticsCustomer3($list);

        return [true, ['bt' => $list1, 'zz' => $list2, 'table' => $list3]];
    }

    public function fillStatisticsCustomer($data){
        if(empty($data)) return $data;

        $customer_from = array_unique(array_column($data,'customer_from'));
        $basic_type = BasicType::where('del_time',0)
            ->whereIn('id',$customer_from)
            ->where('type',2)
            ->pluck('title','id')
            ->toArray();

        $return = [];
        foreach ($data as $value){
            $tmp = $basic_type[$value['customer_from']] ?? "";
            if(! $tmp) continue;
            if(isset($return[$tmp])){
                $return[$tmp]['total'] += 1;
            }else{
                $return[$tmp] = [
                    'total' => 1,
                    'title' => $tmp
                ];
            }
        }

        return array_values($return);
    }

    public function fillStatisticsCustomer2($data){
        if(empty($data)) return $data;

        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->where('is_main',0)
            ->pluck('title','id')
            ->toArray();
        $return = [];
        foreach ($depart as $key => $value){
            $return[$key] = [
                'title' => $value,
                'total' => 0
            ];
        }

        $top_depart_id = SeeRange::where('del_time',0)
            ->where('data_type',SeeRange::type_one)
            ->where('type',SeeRange::data_three)
            ->whereIn('data_id', array_column($data,'id'))
            ->select('param_id as fp_top_depart_id')
            ->get()->toArray();
        $top_depart_map = [];
        foreach ($top_depart_id as $value){
            if(isset($top_depart_map[$value['fp_top_depart_id']])){
                $top_depart_map[$value['fp_top_depart_id']] += 1;
            }else{
                $top_depart_map[$value['fp_top_depart_id']] = 1;
            }
        }

        foreach ($return as $key => $value){
            if(isset($top_depart_map[$key])) $return[$key]['total'] = $top_depart_map[$key];
        }

        $return = array_values($return);
        usort($return, function($a, $b) {
            return $b['total'] - $a['total'];
        });

        return $return;
    }

    public function fillStatisticsCustomer3($data){
        if(empty($data)) return $data;

        $array = array_unique(array_column($data,'customer_from'));
        $basic_map = BasicType::whereIn('id',$array)
            ->pluck('title','id')
            ->toArray();
        $return_first = $customer_from_map = $header = [];
        foreach ($data as $value){
            $title = $basic_map[$value['customer_from']] ?? "";
            if(! $title) continue;
            if(isset($return_first[$title])){
                $return_first[$title]['total'] += 1;
            }else{
                $return_first[$title] = [
                    'title' => $title,
                    'total' => 1,
                ];
            }
            $customer_from_map[$value['id']] = $value['customer_from'];
            if(! in_array($title, $header)) $header[] = $title;
        }
        $header_tmp = $header_return = [];
        foreach ($header as $value){
            $header_tmp[] = [
                "title" => $value,
                "total" => 0,
            ];
            $header_return[] = [
                "title" => $value
            ];
        }

        $return_first = array_values($return_first);

        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->where('is_main',0)
            ->pluck('title','id')
            ->toArray();
        $return = [];
        foreach ($depart as $key => $value){
            $return[$key] = [
                'title' => $value,
                'total' => 0,
                'customer_from' => $header_tmp,
            ];
        }

        $top_depart_id = SeeRange::where('del_time',0)
            ->where('data_type',SeeRange::type_one)
            ->where('type',SeeRange::data_three)
            ->whereIn('data_id', array_column($data,'id'))
            ->select('param_id as fp_top_depart_id','data_id as customer_id')
            ->get()->toArray();
        $top_depart_map = $top_depart_map2 = [];
        foreach ($top_depart_id as $value){
            if(isset($top_depart_map[$value['fp_top_depart_id']])){
                $top_depart_map[$value['fp_top_depart_id']] += 1;
            }else{
                $top_depart_map[$value['fp_top_depart_id']] = 1;
            }
            $customer_from_tmp = $customer_from_map[$value['customer_id']] ?? 0;
            if($customer_from_tmp){
                if(isset($top_depart_map2[$value['fp_top_depart_id']][$customer_from_tmp])){
                    $top_depart_map2[$value['fp_top_depart_id']][$customer_from_tmp] += 1;
                }else{
                    $top_depart_map2[$value['fp_top_depart_id']][$customer_from_tmp] = 1;
                }
            }
        }

        foreach ($return as $key => $value){
            if(isset($top_depart_map[$key])) {
                $num = $top_depart_map[$key];
                if($num <= 0) {
                    unset($return[$key]);
                    continue;
                }else{
                    $return[$key]['total'] = $top_depart_map[$key];
                }
            }else{
                unset($return[$key]);
                continue;
            }
            if(isset($top_depart_map2[$key])) {
                $tmp = $top_depart_map2[$key];
                foreach ($tmp as $k => $v){
                    $title = $basic_map[$k] ?? "";
                    if(! $title) continue;

                    foreach ($return[$key]['customer_from'] as $kk => $vv){
                        if($vv['title'] == $title){
                            $return[$key]['customer_from'][$kk]['total'] = $v;
                        }
                    }
                }
            }
        }

        $return = array_values($return);
        usort($return, function($a, $b) {
            return $b['total'] - $a['total'];
        });

        return ['header' => $header_return,'left' => $return_first, 'right' => $return];
    }

    //销售统计饼图 根据合同类型区分(例如线上合同、线下合同)
    public function statisticsBt($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择销售订单时间区间'];

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //需要所有数据的门店
        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        //当前门店是否在设置门店中
        $bool = in_array($current_top_depart_id,$bt_top_depart_id);

        $model = SalesOrder::where('del_time',0)
            ->when(! $bool, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->select('model_type','contract_fee as total','top_depart_id');

        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

        $list = $model->get()->toArray();
        $list = $this->fillStatisticsBt($list,$bt_top_depart_id,$bool);

        return [true, $list];
    }

    public function fillStatisticsBt($data,$bt_top_depart_id,$bool){
        if(empty($data)) return $data;

        $return = [];
        foreach ($data as $value){
            $model_type_title = SalesOrder::$model_type_title[$value['model_type']] ?? "";
            if($bool){
                if($value['model_type'] != SalesOrder::Model_type_two){
                    if(in_array($value['top_depart_id'], $bt_top_depart_id)){
                        $this->makeThis($return,$value,$model_type_title);
                    }
                }else{
                    $this->makeThis($return,$value,$model_type_title);
                }
            }else{
                $this->makeThis($return,$value,$model_type_title);
            }
        }

        return array_values($return);
    }

    public function makeThis(&$return,$value,$model_type_title){
        if(isset($return[$value['model_type']])){
            $total = bcadd($value['total'], $return[$value['model_type']]['total'],2);
            $return[$value['model_type']]['total'] = $total;
        }else{
            $return[$value['model_type']] = [
                'model_type' => $value['model_type'],
                'model_type_title' => $model_type_title,
                'total' => $value['total'],
            ];
        }
    }

    //省 订单类型细分统计
    public function statisticsProvince($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //销售订单类型
        $model_type = 0;
        if(! empty($data['model_type'])) $model_type = $data['model_type'];

        //门店设置的指标 按照区域汇总
        $index_map = DepartIndex::where('del_time',0)
            ->pluck('param_one','top_depart_id')
            ->toArray();
        //分社所属省
        $depart_map = $province_map = [];
        $depart = Depart::where('parent_id',0)
            ->where('province','<>','')
            ->where('del_time',0)
            ->select('province','id')
            ->get()->toArray();
        foreach ($depart as $value){
            $depart_map[$value['id']] = $value['province'];
            $province_map[$value['province']][] = $value['id'];
        }

        $address_map = config('address');
        $address_map = array_column($address_map,'label','value');

        //省
        $final_address_map = [];
        foreach ($address_map as $key => $value){
            $tmp = [
                'key' => $key,
                'title' => $value,
                'total' => 0,
                'index' => 0
            ];
            $top_depart_id = $province_map[$key] ?? [];
            if(! empty($top_depart_id)){
                foreach ($top_depart_id as $depart_id){
                    $index = $index_map[$depart_id] ?? 0;
                    $tmp['index'] = bcadd($tmp['index'], $index,2);
                }
            }
            $final_address_map[] = $tmp;
        }

        //特殊的门店
        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        //当前门店是否在设置门店中
        $bool = in_array($current_top_depart_id,$bt_top_depart_id);

        $sale_order = SalesOrder::where("del_time",0)
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->when(! $bool, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->when(! empty($model_type), function ($query) use ($model_type) {
                return $query->where('model_type',$model_type);
            })
            ->select('id','top_depart_id','contract_fee','model_type')
            ->get()->toArray();

        //合同
        $purchase_map = $sale_order_id = [];
        foreach ($sale_order as $value){
            $area = $depart_map[$value['top_depart_id']] ?? 0;
            if(! $area) continue;

            if($value['model_type'] != SalesOrder::Model_type_two){
                if(in_array($value['top_depart_id'], $bt_top_depart_id)){
                    $sale_order_id[] = $value['id'];
                    $this->makeData($purchase_map,$value,$area);
                }
            }else{
                $sale_order_id[] = $value['id'];
                $this->makeData($purchase_map,$value,$area);
            }
        }

        //退货的差异
        $returnExchange_map = [];
        $returnExchange = ReturnExchangeOrder::where('del_time',0)
            ->where('type',ReturnExchangeOrder::Order_type)
             ->whereIn('data_id',array_unique($sale_order_id))
            ->select('top_depart_id','difference_amount')
            ->get()->toArray();
        foreach ($returnExchange as $value){
            $area = $depart_map[$value['top_depart_id']] ?? 0;
            if(! $area) continue;
            if(isset($returnExchange_map[$area])){
                $total = bcadd($returnExchange_map[$area], $value['difference_amount'],2);
                $returnExchange_map[$area] = $total;
            }else{
                $returnExchange_map[$area] = $value['difference_amount'];
            }
        }

        foreach ($final_address_map as $key => $value){
            $purchase_tmp = $purchase_map[$value['key']] ?? 0;
            $return_tmp = $returnExchange_map[$value['key']] ?? 0;
            $final_address_map[$key]['total'] = bcsub($purchase_tmp, $return_tmp,2);
        }

        usort($final_address_map, function($a, $b) {
            return $b['total'] - $a['total'];
        });

        return [true, $final_address_map];
    }

    public function makeData(&$purchase_map, $value,$area){
        if(isset($purchase_map[$area])){
            $total = bcadd($purchase_map[$area], $value['contract_fee'],2);
            $purchase_map[$area] = $total;
        }else{
            $purchase_map[$area] = $value['contract_fee'];
        }
    }

    //大区 订单类型细分统计
    public function statisticsArea($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //销售订单类型
        $model_type = 0;
        if(! empty($data['model_type'])) $model_type = $data['model_type'];

        //门店设置的指标 按照区域汇总
        $index_map = DepartIndex::where('del_time',0)
            ->pluck('param_one','top_depart_id')
            ->toArray();
        //分社所属大区
        $depart_map = $area_map = [];
        $depart = Depart::where('parent_id',0)
            ->where('area','>',0)
            ->where('del_time',0)
            ->select('area','id')
            ->get()->toArray();
        foreach ($depart as $value){
            $depart_map[$value['id']] = $value['area'];
            $area_map[$value['area']][] = $value['id'];
        }

        //大区
        $area = Depart::$area;
        $area_map = [];
        foreach ($area as $key => $value){
            $tmp = [
                'key' => $key,
                'title' => $value,
                'total' => 0,
                'index' => 0
            ];
            $top_depart_id = $area_map[$key] ?? [];
            if(! empty($top_depart_id)){
                foreach ($top_depart_id as $depart_id){
                    $index = $index_map[$depart_id] ?? 0;
                    $tmp['index'] = bcadd($tmp['index'], $index,2);
                }
            }
            $area_map[] = $tmp;
        }

        //特殊的门店
        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        //当前门店是否在设置门店中
        $bool = in_array($current_top_depart_id,$bt_top_depart_id);

        $sale_order = SalesOrder::where("del_time",0)
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->when(! $bool, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->when(! empty($model_type), function ($query) use ($model_type) {
                return $query->where('model_type',$model_type);
            })
            ->select('top_depart_id','contract_fee','model_type','id')
            ->get()->toArray();

        $purchase_map = $sale_order_id = [];
        foreach ($sale_order as $value){
            $area = $depart_map[$value['top_depart_id']] ?? 0;
            if(! $area) continue;

            if($value['model_type'] != SalesOrder::Model_type_two){
                if(in_array($value['top_depart_id'], $bt_top_depart_id)){
                    $sale_order_id[] = $value['id'];
                    $this->makeData($purchase_map,$value,$area);
                }
            }else{
                $sale_order_id[] = $value['id'];
                $this->makeData($purchase_map,$value,$area);
            }
        }

        //退货的差异
        $returnExchange_map = [];
        $returnExchange = ReturnExchangeOrder::where('del_time',0)
            ->where('type',ReturnExchangeOrder::Order_type)
             ->whereIn('data_id',array_unique($sale_order_id))
            ->select('top_depart_id','difference_amount')
            ->get()->toArray();
        foreach ($returnExchange as $value){
            $area = $depart_map[$value['top_depart_id']] ?? 0;
            if(! $area) continue;
            if(isset($returnExchange_map[$area])){
                $total = bcadd($returnExchange_map[$area], $value['difference_amount'],2);
                $returnExchange_map[$area] = $total;
            }else{
                $returnExchange_map[$area] = $value['difference_amount'];
            }
        }

        foreach ($area_map as $key => $value){
            $purchase_tmp = $purchase_map[$value['key']] ?? 0;
            $return_tmp = $returnExchange_map[$value['key']] ?? 0;
            $area_map[$key]['total'] = bcsub($purchase_tmp, $return_tmp,2);
        }

        usort($area_map, function($a, $b) {
            return $b['total'] - $a['total'];
        });

        return [true, $area_map];
    }

    // 省|大区下的门店  订货统计
    public function statisticsAreaDepart($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);

        if(empty($data['area']) && empty($data['province'])) return [false, '大区或省份必须选择一个'];
        if(! empty($data['area']) && ! empty($data['province']))return [false, '大区或省份有且只能有一个'];
        if(! empty($data['area']) && ! isset(Depart::$area[$data['area']])) return [false, '该大区不存在'];
        $address_map = config('address');
        $address_map = array_column($address_map,'label','value');
        if(! empty($data['province']) && ! isset($address_map[$data['province']])) return [false, '该省不存在'];

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //销售订单类型
        $model_type = 0;
        if(! empty($data['model_type'])) $model_type = $data['model_type'];

        if(! empty($data['area'])){
            $depart = Depart::where('parent_id',0)
                ->where('del_time',0)
                ->where('area',$data['area'])
                ->select('id','title')
                ->get()
                ->toArray();
            if(empty($depart)) return [false, '该大区下不存在门店'];
        }else{
            $depart = Depart::where('parent_id',0)
                ->where('del_time',0)
                ->where('province',$data['province'])
                ->select('id','title')
                ->get()
                ->toArray();
            if(empty($depart)) return [false, '该省下不存在门店'];
        }

        //门店设置的指标
        $index_map = DepartIndex::where('del_time',0)
            ->whereIn('top_depart_id',array_column($depart,'id'))
            ->pluck('param_one','top_depart_id')
            ->toArray();

        //特殊的门店
        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        //当前门店是否在设置门店中
        $bool = in_array($current_top_depart_id,$bt_top_depart_id);

        //合同
        $sale_order = SalesOrder::where("del_time",0)
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->when(! $bool, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->when(! empty($model_type), function ($query) use ($model_type) {
                return $query->where('model_type',$model_type);
            })
            ->select('top_depart_id','contract_fee','id','model_type')
            ->get()->toArray();
        //向总社采购的钱
        $purchase_map = $sale_order_id = [];
        foreach ($sale_order as $value){
            if($value['model_type'] != SalesOrder::Model_type_two){
                if(in_array($value['top_depart_id'], $bt_top_depart_id)){
                    $sale_order_id[] = $value['id'];
                    $this->makeData($purchase_map,$value,$value['top_depart_id']);
                }
            }else{
                $sale_order_id[] = $value['id'];
                $this->makeData($purchase_map,$value,$value['top_depart_id']);
            }
        }

        //退货的差异
        $returnExchange_map = [];
        $returnExchange = ReturnExchangeOrder::where('del_time',0)
            ->whereIn('top_depart_id',array_column($depart,'id'))
            ->where('type',ReturnExchangeOrder::Order_type)
             ->whereIn('data_id',array_unique($sale_order_id))
            ->select('top_depart_id','difference_amount')
            ->get()->toArray();
        foreach ($returnExchange as $value){
            if(isset($returnExchange_map[$value['top_depart_id']])){
                $total = bcadd($returnExchange_map[$value['top_depart_id']], $value['difference_amount'],2);
                $returnExchange_map[$value['top_depart_id']] = $total;
            }else{
                $returnExchange_map[$value['top_depart_id']] = $value['difference_amount'];
            }
        }

        foreach ($depart as $key => $value){
            $purchase_tmp = $purchase_map[$value['id']] ?? 0;
            $return_tmp = $returnExchange_map[$value['id']] ?? 0;
            $depart[$key]['total'] = bcsub($purchase_tmp, $return_tmp,2);
            $depart[$key]['index'] = $index_map[$value['id']] ?? 0;
        }

        return [true, $depart];
    }

    //某个门店 关于产品以及分类的统计  订货统计
    public function statisticsAreaDepartProduct($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
        if(empty($data['top_depart_id'])) return [false, '请选择门店'];

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //特殊的门店
        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        //当前门店是否在设置门店中
        $bool = in_array($current_top_depart_id,$bt_top_depart_id);

        //销售订单类型
        $model_type = 0;
        if(! empty($data['model_type'])) $model_type = $data['model_type'];

        //时间 =》 钱
        $purchase_map1 = $this->getTime($return);
        //产品 =》 数量
        $purchase_category_map = $purchase_map = [];

        $sale_order = SalesOrder::where("del_time",0)
            ->where('top_depart_id',$data['top_depart_id'])
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->when(! $bool, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->when(! empty($model_type), function ($query) use ($model_type) {
                return $query->where('model_type',$model_type);
            })
            ->select('id','crt_time')
            ->get()->toArray();
        $purchase_for_time = array_column($sale_order,'crt_time','id');
        $sale_order_id = array_column($sale_order,'id');
        $purchase_product = SalesOrderProductInfo::where("del_time",0)
            ->whereIn('sales_order_id',$sale_order_id)
            ->select('sales_order_id','product_id','number','price','final_amount','sports_bag_id')
            ->get()->toArray();

        //退换货
        list($returnExchange_map,$returnExchange_map_2) = $this->returnExchange($data,$sale_order_id);
        //产品
        $product_list = Product::whereIn('id',array_unique(array_merge_recursive(array_column($purchase_product,'product_id'),array_keys($returnExchange_map,'product_id'))))
            ->select('id','product_category','title','code')
            ->get()->toArray();
        $product_list_map = array_column($product_list,null,'id');

        $category_return = ProductCategory::where('del_time',0)
            ->where('parent_id',0)
            ->pluck('title','id')
            ->toArray();
        foreach ($purchase_product as $value){
            if($value['sports_bag_id'] > 0){
                $money = $value['final_amount'];
            }elseif($value['final_amount'] > 0){
                $money = $value['final_amount'];
            }else{
                $money = bcmul($value['price'],$value['number'],2);
            }
            $crt_time = $purchase_for_time[$value['sales_order_id']];
            $crt_time = date("Y-m-d",$crt_time);

            //产品信息
            $product_tmp = $product_list_map[$value['product_id']] ?? [];

            $time_money = 0;
            if(isset($returnExchange_map_2[$crt_time])) {
                $time_money = $returnExchange_map_2[$crt_time] ?? 0;
                unset($returnExchange_map_2[$crt_time]);
            }
            //钱
            if(isset($purchase_map1[$crt_time])){
                $time_total = bcadd($purchase_map1[$crt_time]['total'],$money,2);
                $time_total = bcsub($time_total,$time_money,2);
                $purchase_map1[$crt_time]['total'] = $time_total;
            }

            $return_number = $return_total = 0;
            $return_category_number = $return_category_total = 0;
            if(isset($returnExchange_map[$value['product_id']])){
                $tmp = $returnExchange_map[$value['product_id']];
                $return_number = bcsub($value['number'], $tmp['number'],2);
                $return_total = bcsub($money, $tmp['total'],2);
                $return_category_number = $return_number;
                $return_category_total = $return_total;
            }

            //-------根据产品
            //数量
            if(isset($purchase_map[$value['product_id']])){
                $tmp_number = bcadd($purchase_map[$value['product_id']]['number'], $value['number'],2);
                $tmp_money = bcadd($purchase_map[$value['product_id']]['total'], $money,2);
                $purchase_map[$value['product_id']]['number'] = $tmp_number;
                $purchase_map[$value['product_id']]['total'] = $tmp_money;
            }else{
                //减去退换货
                $number = bcsub($value['number'], $return_number,2);
                $total = bcsub($money, $return_total,2);
                $purchase_map[$value['product_id']] = [
                    'title' => $product_tmp['title'] . "(" . $product_tmp['code'] .")",
                    'number' => $number,
                    'total' => $total
                ];
            }
            //-------根据产品

            //-------根据产品大类
            //数量
            $category_tmp = json_decode($product_tmp['product_category']);
            $category_tmp = min($category_tmp);
            //退换货
            $number_2 = bcsub($value['number'], $return_category_number,2);
            $total_2 = bcsub($money, $return_category_total,2);
            if(isset($purchase_category_map[$category_tmp])){
                $tmp_number = bcadd($purchase_map[$value['product_id']]['number'], $value['number'],2);
                $tmp_number = bcsub($tmp_number,$number_2,2);
                $tmp_money = bcadd($purchase_map[$value['product_id']]['total'], $money,2);
                $tmp_money = bcsub($tmp_money,$total_2,2);
                $purchase_category_map[$category_tmp]['number'] = $tmp_number;
                $purchase_category_map[$category_tmp]['total'] = $tmp_money;
            }else{
                $num = bcsub($value['number'],$number_2,2);
                $tol = bcsub($money,$total_2,2);
                $purchase_category_map[$category_tmp] = [
                    'number' => $num,
                    'title' => $category_return[$category_tmp] ?? "",
                    'total' => $tol
                ];
            }
        }

        return [true, ['money' => array_values($purchase_map1), 'product_num' => array_values($purchase_map), 'category_num' => array_values($purchase_category_map)]];
    }

    public function getTime($data){
        $startTimestamp = $data[0]; // 起始时间戳
        $endTimestamp = $data[1];   // 结束时间戳

        // 创建 DateTime 对象
        $startDate = new \DateTime();
        $endDate = new \DateTime();

        $startDate->setTimestamp($startTimestamp);
        $endDate->setTimestamp($endTimestamp);

        // 创建 DatePeriod 对象
        $interval = new \DateInterval('P1D'); // 每天的间隔
        $dateRange = new \DatePeriod($startDate, $interval, $endDate);

        // 遍历日期范围并输出每个日期
        $return = [];
        foreach ($dateRange as $date) {
            $day = $date->format('Y-m-d');
            $return[$day] = [
                'day' => $day,
                'total' => 0
            ];
        }
        return $return;
    }

    public function returnExchange($data,$sale_order_id){
        $returnExchange_map = $returnExchange_map_2 = [];
        $returnExchange = ReturnExchangeOrder::where('del_time',0)
            ->where('type',ReturnExchangeOrder::Order_type)
            ->whereIn('data_id', $sale_order_id)
            ->select('id')
            ->get()->toArray();
        $returnExchange_product = ReturnExchangeOrderProductInfo::where("del_time",0)
            ->whereIn('return_exchange_id',array_column($returnExchange,'id'))
            ->select('return_exchange_id','product_id','number','return_exchange_price as price','crt_time')
            ->get()->toArray();
        foreach ($returnExchange_product as $value){
            $money = bcmul($value['price'],$value['number'],2);

            if(isset($returnExchange_map[$value['product_id']])){
                $tmp_money = bcadd($returnExchange_map[$value['product_id']]['total'], $money,2);
                $tmp_number = bcadd($returnExchange_map[$value['product_id']]['number'], $value['number'],2);
                $returnExchange_map[$value['product_id']] = [
                    'number' => $tmp_number,
                    'total' => $tmp_money
                ];
            }else{
                $returnExchange_map[$value['product_id']] = [
                    'number' => $value['number'],
                    'total' => $money
                ];
            }

            $crt_time = date("Y-m-d",$value['crt_time']);
            if(isset($returnExchange_map_2[$crt_time])){
                $tmp_money_2 = bcadd($returnExchange_map_2[$crt_time], $money,2);
                $returnExchange_map_2[$crt_time] = $tmp_money_2;
            }else{
                $returnExchange_map_2[$crt_time] = $money;
            }
        }

        return [$returnExchange_map,$returnExchange_map_2];
    }

    //线下订单
    public function statisticsModelTypeOne($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
        if(empty($data['x'])) return [false, '请选择X轴维度'];

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //线下 销售订单类型
        $model_type = SalesOrder::Model_type_one;

        $sale_order = SalesOrder::where("del_time",0)
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->where('model_type',$model_type)
            ->when(! empty($current_top_depart_id) && $current_top_depart_id != $head, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->select('id','top_depart_id','contract_fee','crt_id')
            ->get()->toArray();
        //合同
        $sale_order_id = array_column($sale_order,'id');

        $statistics = [];
        if($data['x'] == "crt_id"){
            $emp = Employee::whereIn('id', array_unique(array_column($sale_order,'crt_id')))
                ->pluck('emp_name','id')
                ->toArray();

            //退货的差异
            $returnExchange_map = [];
            $returnExchange = ReturnExchangeOrder::where('del_time',0)
                ->where('type',ReturnExchangeOrder::Order_type)
                ->whereIn('data_id',array_unique($sale_order_id))
                ->select('top_depart_id','difference_amount','data_id')
                ->get()->toArray();
            foreach ($returnExchange as $value){
                if(isset($returnExchange_map[$value['data_id']])){
                    $total = bcadd($returnExchange_map[$value['data_id']], $value['difference_amount'],2);
                    $returnExchange_map[$value['data_id']] = $total;
                }else{
                    $returnExchange_map[$value['data_id']] = $value['difference_amount'];
                }
            }

            foreach ($sale_order as $value){
                $crt_name = $emp[$value['crt_id']] ?? "";
                if(! $crt_name) continue;
                $return_money = $returnExchange_map[$value['id']] ?? 0;
                $tmp = bcsub($value['contract_fee'], $return_money,2);
                if(isset($statistics[$value['crt_id']])){
                    $total = bcadd($tmp,$statistics[$value['crt_id']]['total'],2);
                    $statistics[$value['crt_id']]['total'] = $total;
                }else{
                    $statistics[$value['crt_id']] = [
                        'title' => $crt_name,
                        'total' => $tmp,
                    ];
                }
            }
        }elseif($data['x'] == "product"){
            $sales_product = SalesOrderProductInfo::where('del_time',0)
                ->whereIn('sales_order_id',$sale_order_id)
                ->select('product_id','number','retail_price','price')
                ->get()->toArray();
            $product = Product::whereIn('id',array_unique(array_column($sales_product,'product_id')))
                ->select('id','title','code')
                ->get()->toArray();
            $product_map = [];
            foreach ($product as $value){
                $product_map[$value['id']] = $value['title'] . "(" . $value['code']. ")";
            }

            //退货的差异
            $returnExchange_map = [];
            $returnExchange = ReturnExchangeOrder::where('del_time',0)
                ->where('type',ReturnExchangeOrder::Order_type)
                ->whereIn('data_id',array_unique($sale_order_id))
                ->select('id')
                ->get()->toArray();
            $return_product = ReturnExchangeOrderProductInfo::where('del_time',0)
                ->whereIn('return_exchange_id', array_column($returnExchange,'id'))
                ->select('product_id','number','return_exchange_price')
                ->get()->toArray();
            foreach ($return_product as $value){
                $tmp = bcmul($value['number'],$value['return_exchange_price'],2);
                if(isset($returnExchange_map[$value['product_id']])){
                    $total = bcadd($returnExchange_map[$value['product_id']], $tmp,2);
                    $returnExchange_map[$value['product_id']] = $total;
                }else{
                    $returnExchange_map[$value['product_id']] = $tmp;
                }
            }

            foreach ($sales_product as $value){
                $product_tmp = $product_map[$value['product_id']] ?? "";
                if(! $product_tmp) continue;
                if($value['price'] > 0){
                    $tmp = bcmul($value['price'], $value['number'],2);
                }else{
                    $tmp = bcmul($value['retail_price'], $value['number'],2);
                }
                $return_tmp = 0;
                if(isset($returnExchange_map[$value['product_id']])){
                    $return_tmp = $returnExchange_map[$value['product_id']] ?? 0;
                    unset($returnExchange_map[$value['product_id']]);
                }
                $tmp = bcsub($tmp,$return_tmp,2);
                if(isset($statistics[$value['product_id']])){
                    $total = bcadd($tmp,$statistics[$value['product_id']]['total'],2);
                    $statistics[$value['product_id']]['total'] = $total;
                }else{
                    $statistics[$value['product_id']] = [
                        'title' => $product_tmp,
                        'total' => $tmp,
                    ];
                }
            }
        }

        foreach ($statistics as $key => $value){
            if(floatval($value['total']) <= 0) unset($statistics[$key]);
        }
        $statistics = array_values($statistics);
        usort($statistics, function($a, $b) {
            return $b['total'] - $a['total'];
        });

        return [true, $statistics];
    }

    //线上订单
    public function statisticsModelTypeFour($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
        if(empty($data['x'])) return [false, '请选择X轴维度'];

        //总社id
        $head = $user['head']['id'] ?? 0;
        //当前门店
        $current_top_depart_id = $this->getMyTopDepart($user);

        //线下 销售订单类型
        $model_type = SalesOrder::Model_type_four;

        $sale_order = SalesOrder::where("del_time",0)
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->where('model_type',$model_type)
            ->when(! empty($current_top_depart_id) && $current_top_depart_id != $head, function ($query) use ($current_top_depart_id) {
                return $query->where('top_depart_id', $current_top_depart_id);
            })
            ->select('id','top_depart_id','contract_fee','plat_type')
            ->get()->toArray();
        //合同
        $sale_order_id = array_column($sale_order,'id');

        $statistics = [];
        if($data['x'] == "order_from"){
            $array = array_unique(array_column($sale_order,'plat_type'));
            $basic_map = BasicType::whereIn('id',$array)
                ->pluck('title','id')
                ->toArray();

            //退货的差异
            $returnExchange_map = [];
            $returnExchange = ReturnExchangeOrder::where('del_time',0)
                ->where('type',ReturnExchangeOrder::Order_type)
                ->whereIn('data_id',array_unique($sale_order_id))
                ->select('top_depart_id','difference_amount','data_id')
                ->get()->toArray();
            foreach ($returnExchange as $value){
                if(isset($returnExchange_map[$value['data_id']])){
                    $total = bcadd($returnExchange_map[$value['data_id']], $value['difference_amount'],2);
                    $returnExchange_map[$value['data_id']] = $total;
                }else{
                    $returnExchange_map[$value['data_id']] = $value['difference_amount'];
                }
            }

            foreach ($sale_order as $value){
                $plat_type = $basic_map[$value['plat_type']] ?? "";
                if(! $plat_type) continue;
                $return_money = $returnExchange_map[$value['id']] ?? 0;
                $tmp = bcsub($value['contract_fee'], $return_money,2);
                if(isset($statistics[$value['plat_type']])){
                    $total = bcadd($tmp,$statistics[$value['plat_type']]['total'],2);
                    $statistics[$value['plat_type']]['total'] = $total;
                }else{
                    $statistics[$value['plat_type']] = [
                        'title' => $plat_type,
                        'total' => $tmp,
                    ];
                }
            }
        }elseif($data['x'] == "product"){
            $sales_product = SalesOrderProductInfo::where('del_time',0)
                ->whereIn('sales_order_id',$sale_order_id)
                ->select('product_id','number','retail_price','price')
                ->get()->toArray();
            $product = Product::whereIn('id',array_unique(array_column($sales_product,'product_id')))
                ->select('id','title','code')
                ->get()->toArray();
            $product_map = [];
            foreach ($product as $value){
                $product_map[$value['id']] = $value['title'] . "(" . $value['code']. ")";
            }

            //退货的差异
            $returnExchange_map = [];
            $returnExchange = ReturnExchangeOrder::where('del_time',0)
                ->where('type',ReturnExchangeOrder::Order_type)
                ->whereIn('data_id',array_unique($sale_order_id))
                ->select('id')
                ->get()->toArray();
            $return_product = ReturnExchangeOrderProductInfo::where('del_time',0)
                ->whereIn('return_exchange_id', array_column($returnExchange,'id'))
                ->select('product_id','number','return_exchange_price')
                ->get()->toArray();
            foreach ($return_product as $value){
                $tmp = bcmul($value['number'],$value['return_exchange_price'],2);
                if(isset($returnExchange_map[$value['product_id']])){
                    $total = bcadd($returnExchange_map[$value['product_id']], $tmp,2);
                    $returnExchange_map[$value['product_id']] = $total;
                }else{
                    $returnExchange_map[$value['product_id']] = $tmp;
                }
            }

            foreach ($sales_product as $value){
                $product_tmp = $product_map[$value['product_id']] ?? "";
                if(! $product_tmp) continue;
                if($value['price'] > 0){
                    $tmp = bcmul($value['price'], $value['number'],2);
                }else{
                    $tmp = bcmul($value['retail_price'], $value['number'],2);
                }
                $return_tmp = 0;
                if(isset($returnExchange_map[$value['product_id']])){
                    $return_tmp = $returnExchange_map[$value['product_id']] ?? 0;
                    unset($returnExchange_map[$value['product_id']]);
                }
                $tmp = bcsub($tmp,$return_tmp,2);
                if(isset($statistics[$value['product_id']])){
                    $total = bcadd($tmp,$statistics[$value['product_id']]['total'],2);
                    $statistics[$value['product_id']]['total'] = $total;
                }else{
                    $statistics[$value['product_id']] = [
                        'title' => $product_tmp,
                        'total' => $tmp,
                    ];
                }
            }
        }

        foreach ($statistics as $key => $value){
            if(floatval($value['total']) <= 0) unset($statistics[$key]);
        }
        $statistics = array_values($statistics);
        usort($statistics, function($a, $b) {
            return $b['total'] - $a['total'];
        });

        return [true, $statistics];
    }

    public function statisticsJc($data,$user){
        $model = Product::ProductClear2($user,$data);
        $model = $model->where('del_time',0)
            ->select('title','id','code','depart_id','top_depart_id','product_attribute')
            ->orderby('product_attribute', 'desc')
            ->orderby('id', 'desc');

        if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
        if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
        if(isset($data['product_attribute'])) $model->where('product_attribute', $data['product_attribute']);
        if(! empty($data['product_category_id'])) $model->where('product_category_id', $data['product_category_id']);
        if(! empty($data['product_category'])) {
            $product_category = ProductCategory::where('del_time',0)
                ->where('title', 'LIKE', '%'.$data['product_category'].'%')
                ->select('id')
                ->get()->toArray();
            $model->whereIn('product_category_id',array_unique(array_column($product_category,'id')));
        }

        $list = $this->limit($model,'',$data);
        $list = $this->fillData($list,$user,$data);

        return [true, $list];
    }

    public function fillData($data, $user, $search){
        if(empty($data['data'])) return $data;

        //产品
        $product = array_column($data['data'],'id');
        //本月入库 本月出库
        list($in, $out) = $this->getThisMonthData($product,$user,$search);
        //上月结存 汇总这个月之前的出入
        list($last_in,$last_out) = $this->getLastMonthBalance($product,$user,$search);

        foreach ($data['data'] as $key => $value){
            $last_in_tmp = $last_in[$value['id']] ?? [];
            $last_in_money = $last_in_tmp['total'] ?? 0;//本月之前入的金额
            $last_in_number = $last_in_tmp['number'] ?? 0;//本月之前入的数量
            $last_out_tmp = $last_out[$value['id']] ?? [];
            $last_out_money = $last_out_tmp['total'] ?? 0;//本月之前出的金额
            $last_out_number = $last_out_tmp['number'] ?? 0;//本月之前出的数量

            //上月结存
            $last_jc_money = bcsub($last_in_money,$last_out_money,2);//结存金额
            $last_jc_number = bcsub($last_in_number,$last_out_number,2);//结存数量
            $last_jc_price = floatval($last_jc_number) ? bcdiv($last_jc_money,$last_jc_number,2) : 0;//结存单价
            $data['data'][$key]['last_jc_money'] = $last_jc_money;
            $data['data'][$key]['last_jc_number'] = $last_jc_number;
            $data['data'][$key]['last_jc_price'] = $last_jc_price;

            //本月入库
            $this_in_tmp = $in[$value['id']] ?? [];
            $this_in_money = $this_in_tmp['total'] ?? 0;//本月入的金额
            $this_in_number = $this_in_tmp['number'] ?? 0;//本月入的数量
            $this_in_price = floatval($this_in_number) ? bcdiv($this_in_money,$this_in_number,2) : 0;//本月入单价
            $data['data'][$key]['this_in_money'] = $this_in_money;
            $data['data'][$key]['this_in_number'] = $this_in_number;
            $data['data'][$key]['this_in_price'] = $this_in_price;

            //本月出库
            $this_out_tmp = $out[$value['id']] ?? [];
            $this_out_money = $this_out_tmp['total'] ?? 0;//本月出的金额
            $this_out_number = $this_out_tmp['number'] ?? 0;//本月出的数量
            //单价= (上月结存金额+本月入库金额) /上月结存数量+本月入库数量
            $amount = bcadd($last_jc_money, $this_in_money,2);
            $number = bcadd($last_jc_number, $this_in_number,2);
            $this_out_price = floatval($number) ? bcdiv($amount,$number,2) : 0;//本月出单价
            $data['data'][$key]['this_out_money'] = $this_out_money;
            $data['data'][$key]['this_out_number'] = $this_out_number;
            $data['data'][$key]['this_out_price'] = $this_out_price;

            //本月结存
            //本月结存 数量/金额=本月入库+上月结存+(-本月出库)
            $this_jc_money = bcsub(bcadd($this_in_money,$last_jc_money,2),$this_out_money,2);
            $this_jc_number = bcadd(bcadd($this_in_number,$last_jc_number,2),$this_out_number,2);
            $this_jc_price = floatval($this_jc_number) ? bcdiv($this_jc_money,$this_jc_number,2) : 0;//本月结存单价
            $data['data'][$key]['this_jc_money'] = $this_jc_money;
            $data['data'][$key]['this_jc_number'] = $this_jc_number;
            $data['data'][$key]['this_jc_price'] = $this_jc_price;
        }

        return $data;
    }

    //本月入库 出库(库存流水)
    public function getThisMonthData($product = [], $user = [], $search = []){
        $in = $out = [];
        $startStamp = strtotime(date("Y-m-01 00:00:00"));
        $endStamp = strtotime(date("Y-m-t 23:59:59"));

        //本月出和入的数据
        $model = InOutRecord::TopClear($user,$search);
        $list = $model->where('del_time',0)
            ->where('crt_time','>=',$startStamp)
            ->where('crt_time','<=',$endStamp)
            ->whereIn('product_id',$product)
            ->select('product_id','number','price')
            ->get()->toArray();

        foreach ($list as $value){
            if($value['number'] >= 0){
                $tmp_total = bcmul($value['number'], $value['price'], 2);
                if(isset($in[$value['product_id']])){
                    $number = bcadd($in[$value['product_id']]['number'], $value['number'],2);
                    $total = bcadd($in[$value['product_id']]['total'], $tmp_total,2);
                    $in[$value['product_id']]['number'] = $number;
                    $in[$value['product_id']]['total'] = $total;
                }else{
                    $in[$value['product_id']] = [
                        'number' => $value['number'],
                        'total' => $tmp_total,
                    ];
                }
            }else{
                $number = abs($value['number']);
                $tmp_total = bcmul($number, $value['price'], 2);
                if(isset($out[$value['product_id']])){
                    $number = bcadd($out[$value['product_id']]['number'], $number,2);
                    $total = bcadd($out[$value['product_id']]['total'], $tmp_total,2);
                    $out[$value['product_id']]['number'] = $number;
                    $out[$value['product_id']]['total'] = $total;
                }else{
                    $out[$value['product_id']] = [
                        'number' => $number,
                        'total' => $tmp_total,
                    ];
                }
            }
        }

        return [$in, $out];
    }

    //上月结存(汇总这个月之前的出入)(库存流水)
    public function getLastMonthBalance($product = [], $user = [], $search = []){
        //用户提交的上月结存
        $lastData = $this->getLastMonthJc($product,$user,$search);

        $startStamp = strtotime(date("Y-m-01 00:00:00"));
        $model = InOutRecord::TopClear($user,$search);
        $list = $model->where('del_time',0)
            ->where('crt_time','<',$startStamp)
            ->whereIn('product_id',$product)
            ->select('product_id','number','price','top_depart_id')
            ->get()->toArray();
        $map = [];
        foreach ($list as $val){
            $map[$val['product_id'] . $val['top_depart_id']] = $val;
        }

        //先结存表
        $in = $out = [];
        foreach ($lastData as $value){
            $key = $value['product_id'] . '|' . $value['top_depart_id'];
            if($value['number'] >= 0){
                if(isset($in[$key])){
                    $number = bcadd($in[$key]['number'], $value['number'],2);
                    $total = bcadd($in[$key]['total'], $value['total'],2);
                    $in[$key]['number'] = $number;
                    $in[$key]['total'] = $total;
                }else{
                    $in[$key] = [
                        'number' => $value['number'],
                        'total' => $value['total'],
                    ];
                }
            }else{
                $number = abs($value['number']);
                $total = abs($value['total']);
                if(isset($out[$key])){
                    $number = bcadd($out[$key]['number'], $number,2);
                    $total = bcadd($out[$key]['total'], $total,2);
                    $out[$key]['number'] = $number;
                    $out[$key]['total'] = $total;
                }else{
                    $out[$key] = [
                        'number' => $number,
                        'total' => $total,
                    ];
                }
            }
        }
        //后库存流水
        foreach ($list as $value){
           $key = $value['product_id'] . '|' . $value['top_depart_id'];

            if($value['number'] >= 0){
                if(isset($in[$key])) continue;
                $tmp_total = bcmul($value['number'], $value['price'], 2);
                if(isset($in[$value['product_id']])){
                    $number = bcadd($in[$value['product_id']]['number'], $value['number'],2);
                    $total = bcadd($in[$value['product_id']]['total'], $tmp_total,2);
                    $in[$value['product_id']]['number'] = $number;
                    $in[$value['product_id']]['total'] = $total;
                }else{
                    $in[$value['product_id']] = [
                        'number' => $value['number'],
                        'total' => $tmp_total,
                    ];
                }
            }else{
                if(isset($out[$key])) continue;
                $number = abs($value['number']);
                $tmp_total = bcmul($number, $value['price'], 2);
                if(isset($out[$value['product_id']])){
                    $number = bcadd($out[$value['product_id']]['number'], $number,2);
                    $total = bcadd($out[$value['product_id']]['total'], $tmp_total,2);
                    $out[$value['product_id']]['number'] = $number;
                    $out[$value['product_id']]['total'] = $total;
                }else{
                    $out[$value['product_id']] = [
                        'number' => $number,
                        'total' => $tmp_total,
                    ];
                }
            }
        }
        //两个数组组合过滤
        $new_in = $new_out = [];
        foreach ($in as $key => $value){
            $tmp = explode('|', $key);
            $product_id = $tmp[0];
            if(isset($new_in[$product_id])){
                $number = bcadd($new_in[$product_id]['number'], $value['number'],2);
                $total = bcadd($new_in[$product_id]['total'], $value['total'],2);
                $new_in[$product_id] = [
                    'number' => $number,
                    'total' => $total,
                ];
            }else{
                $new_in[$product_id] = [
                    'number' => $value['number'],
                    'total' => $value['total'],
                ];
            }
        }
        foreach ($out as $key => $value){
            $tmp = explode('|', $key);
            $product_id = $tmp[0];
            if(isset($new_out[$product_id])){
                $number = bcadd($new_out[$product_id]['number'], $value['number'],2);
                $total = bcadd($new_out[$product_id]['total'], $value['total'],2);
                $new_out[$product_id] = [
                    'number' => $number,
                    'total' => $total,
                ];
            }else{
                $new_out[$product_id] = [
                    'number' => $value['number'],
                    'total' => $value['total'],
                ];
            }
        }

        return [$new_in, $new_out];
    }

    public function getLastMonthJc($product = [], $user = [], $search = []){
        // 如果存在上月结存数据则使用这个
        $top_depart_id = 0;
        if(! empty($search['top_depart_id'])) $top_depart_id = $search['top_depart_id'];

        $startStamp = strtotime(date("Y-m-01 00:00:00"));
        $result = LastJc::where('del_time',0)
            ->whereIn('product_id',$product)
            ->where('time','<',$startStamp)
            ->when(! empty($top_depart_id), function ($query) use ($top_depart_id) {
                return $query->where('top_depart_id',$top_depart_id);
            })
            ->select('product_id','top_depart_id','total','number','price')
            ->orderBy('time','desc')
            ->get()->toArray();
        $return = [];
        $tmp = [];
        foreach ($result as $value){
            $key = $value['product_id'] . $value['top_depart_id'];
            if(in_array($key, $tmp)) continue;

            $return[] = $value;
            $tmp[] = $key;
        }

        return $return;
    }

    //本月入库(单据)暂时没用
    public function getThisMonthIn1($product = [], $user = [], $search = []){
        $return = [];
        $startStamp = strtotime(date("Y-m-01 00:00:00"));
        $endStamp = strtotime(date("Y-m-t 23:59:59"));
        //本月采购单
        $model = PurchaseOrder::Clear($user,$search);
        $list = $model->where('del_time',0)
            ->where('state', PurchaseOrder::STATE_Four)
            ->where('crt_time','>=',$startStamp)
            ->where('crt_time','<=',$endStamp)
            ->select('id')
            ->get()->toArray();
        if(empty($list)) return $return;
        //本月采购产品
        $purchase_product_array = [];
        $purchase_product = PurchaseOrderInfo::where('del_time',0)
            ->whereIn('product_id',$product)
            ->whereIn('purchase_order_id',array_column($list,'id'))
            ->select('product_id','number','price')
            ->get()->toArray();
        foreach ($purchase_product as $value){
            $total = bcmul($value['number'],$value['price'],2);
            if(isset($purchase_product_array[$value['product_id']])){
                $purchase_product_array[$value['product_id']]['number'] += $value['number'];
                $total_tmp = bcadd($purchase_product_array[$value['product_id']]['total'], $total, 2);
                $purchase_product_array[$value['product_id']]['total'] = $total_tmp;
            }else{
                $purchase_product_array[$value['product_id']] = [
                    'number' => $value['number'],
                    'total' => $total,
                ];
            }
        }

        //本月退货(采购)
        $model2 = ReturnExchangeOrder::Clear($user, $search);
        $return_list = $model2->where('del_time',0)
            ->where('state', ReturnExchangeOrder::State_two)
            ->where('type',ReturnExchangeOrder::Order_type2)
            ->where('crt_time','>=',$startStamp)
            ->where('crt_time','<=',$endStamp)
            ->select('id')
            ->get()->toArray();
        //本月退货产品
        $return_product_array = [];
        if(! empty($return_list)){
            $return_product = ReturnExchangeOrderProductInfo::where('del_time',0)
                ->where('return_exchange_id', array_column($return_list, 'id'))
                ->whereIn('product_id',$product)
                ->where('return_or_exchange',ReturnExchangeOrderProductInfo::type_one)
                ->select('product_id','number','return_or_exchange')
                ->get()->toArray();
            foreach ($return_product as $value){
                $total = bcmul($value['number'],$value['return_or_exchange'],2);
                if(isset($return_product_array[$value['product_id']])){
                    $return_product_array[$value['product_id']]['number'] += $value['number'];
                    $total_tmp = bcadd($return_product_array[$value['product_id']]['total'], $total, 2);
                    $return_product_array[$value['product_id']]['total'] = $total_tmp;
                }else{
                    $return_product_array[$value['product_id']] = [
                        'number' => $value['number'],
                        'total' => $total,
                    ];
                }
            }
        }

        foreach ($return_product_array as $p => $n){
            $number_tmp = -$n['number'];
            $total_tmp = -$n['total'];
            $purchase_product_tmp = $purchase_product_array[$p] ?? [];
            if(empty($purchase_product_tmp)){
                $purchase_product_array[$p] = [
                    'number' => $number_tmp,
                    'total' => $total_tmp,
                ];
            }else{
                $purchase_product_array[$p]['number'] += $number_tmp;
                $total_tmp2 = bcadd($purchase_product_array[$p]['total'], $total_tmp, 2);
                $purchase_product_array[$p]['total'] += $total_tmp2;
            }
        }

        return $purchase_product_array;
    }

    //新的进销存统计通用搜索底层抽象
    public function statisticsJcNewCommonOrigin($data,$user,$field = []){
        if(! empty($data['count_month'])) {
            $startStamp = $this->changeDateToDate($data['count_month']);
        }else{
            $startStamp = strtotime(date("Y-m-01 00:00:00"));
        }
        $endTimeStamp = strtotime('first day of next month', $startStamp) - 1;

        //-------- 结存数量汇总 ---------- //
        //上月结存
        $last_month_stock = "SUM(CASE WHEN crt_time < $startStamp THEN number ELSE 0 END)";
        //本月入库
        $this_month_in = "SUM(CASE WHEN crt_time >= $startStamp AND crt_time <= $endTimeStamp AND number > 0 THEN number ELSE 0 END)";
        //本月出库
        $this_month_out = "SUM(CASE WHEN crt_time >= $startStamp AND crt_time <= $endTimeStamp AND number < 0 THEN number ELSE 0 END)";
        //本月结存
        $this_month_stock = "($last_month_stock + $this_month_in + $this_month_out)";
        //-------- 结存数量汇总 ---------- //

        //-------- 结存金额汇总 ---------- //
        $order_type = ProductAdjustment::prefix;
        //上月结存
        $last_month_stock_m = "ROUND(
                                    SUM(
                                        CASE 
                                            WHEN crt_time < $startStamp and number <> 0 THEN (number * price)
                                            WHEN crt_time < $startStamp and number = 0 and order_type = '$order_type' THEN price
                                            ELSE 0 
                                        END
                                    ), 
                               2)";
        //本月入库
        $this_month_in_m = "ROUND(
                                  SUM(
                                      CASE 
                                            WHEN crt_time >= $startStamp and crt_time <= $endTimeStamp and number > 0 THEN (number * price)
                                            WHEN crt_time >= $startStamp and crt_time <= $endTimeStamp and number = 0 and price >= 0 and order_type = '$order_type' THEN price
                                            ELSE 0 
                                      END
                                 ), 
                            2)";
        //本月出库
        $this_month_out_m = "ROUND(
                                  SUM(
                                      CASE 
                                            WHEN crt_time >= $startStamp and crt_time <= $endTimeStamp and number < 0 THEN (number * price)
                                            WHEN crt_time >= $startStamp and crt_time <= $endTimeStamp and number = 0 and price < 0 and order_type = '$order_type' THEN price
                                            ELSE 0 
                                      END
                                 ), 
                            2)";
        //上月结存
//        $last_month_stock_m = "ROUND(SUM(CASE WHEN crt_time < $startStamp THEN (number * price) ELSE 0 END), 2)";
//        //本月入库
//        $this_month_in_m = "ROUND(SUM(CASE WHEN crt_time >= $startStamp AND number > 0 THEN (number * price) ELSE 0 END), 2)";
//        //本月出库
//        $this_month_out_m = "ROUND(SUM(CASE WHEN crt_time >= $startStamp AND number < 0 THEN (number * price) ELSE 0 END), 2)";
        //-------- 结存金额汇总 ---------- //

        if(empty($field)){
            $field = ['product_id as id',
                DB::raw("$last_month_stock as last_jc_number"),
                DB::raw("$last_month_stock_m as last_jc_money"),
                DB::raw("$this_month_in as this_in_number"),
                DB::raw("$this_month_in_m as this_in_money"),
                DB::raw("$this_month_out as this_out_number"),
                DB::raw("$this_month_out_m as this_out_money"),
//                DB::raw("$this_month_stock as this_jc_number")];
            ];
        }

        $model = InOutRecord::TopClear($user,$data);
        $model = $model->where('del_time',0)
            ->select($field)
            ->groupBy('product_id')
            ->havingRaw("$last_month_stock != 0 OR $this_month_in != 0 OR $this_month_out != 0 OR $this_month_stock != 0");

        return $model;
    }

    //新的进销存统计通用搜索
    public function statisticsJcNewCommon($data,$user, $field = []){
        $model = $this->statisticsJcNewCommonOrigin($data, $user, $field);

        if(! empty($data['product_name']) || ! empty($data['product_category_name']) || ! empty($data['code'])) {
            $id = $this->searchForProduct($data, $user);
            $model->whereIn('product_id', $id);
        }

        return $model;
    }

    //新的进销存统计
    public function statisticsJcNew($data,$user){
        $model = $this->statisticsJcNewCommon($data, $user);
        $model->orderBy('product_id','desc');
        $list = $this->limit($model,'',$data);
        $list = $this->fillDataNew($list);

        return [true, $list];
    }

    public function fillDataNew($data){
        if(empty($data['data'])) return $data;

        //产品
        $map = (new ProductService())->getProductDetail(array_column($data['data'],'id'));

        foreach ($data['data'] as $key => $value){
            //上月结存
            $last_jc_price = floatval($value['last_jc_number']) ? bcdiv($value['last_jc_money'],$value['last_jc_number'],2) : 0;//结存单价
            $data['data'][$key]['last_jc_price'] = $last_jc_price;

            //本月入库
            $this_in_price = floatval($value['this_in_number']) ? bcdiv($value['this_in_money'],$value['this_in_number'],2) : 0;//本月入单价
            $data['data'][$key]['this_in_price'] = $this_in_price;

            //本月出库
            //单价= (上月结存金额+本月入库金额) /上月结存数量+本月入库数量
            $amount = bcadd($value['last_jc_money'], $value['this_in_money'],2);
            $number = bcadd($value['last_jc_number'], $value['this_in_number'],2);
            $this_out_price = floatval($number) ? bcdiv($amount,$number,2) : 0;//本月出单价
            $data['data'][$key]['this_out_price'] = $this_out_price;

            //本月结存
            //本月结存 数量/金额=本月入库+上月结存+(-本月出库)
            $this_jc_money = bcadd(bcadd($value['this_in_money'],$value['last_jc_money'],2),$value['this_out_money'],2);
            $this_jc_number = bcadd(bcadd($value['this_in_number'],$value['last_jc_number'],2),$value['this_out_number'],2);
            $this_jc_price = floatval($this_jc_number) ? bcdiv($this_jc_money,$this_jc_number,2) : 0;//本月结存单价
            $data['data'][$key]['this_jc_money'] = $this_jc_money;
            $data['data'][$key]['this_jc_number'] = $this_jc_number;
            $data['data'][$key]['this_jc_price'] = $this_jc_price;

            //产品
            $tmp = $map[$value['id']] ?? [];
            $data['data'][$key]['title'] = $tmp['title'] ?? "";
            $data['data'][$key]['code'] = $tmp['code'] ?? "";

            //负数改为正数
            $data['data'][$key]['this_out_number'] = abs($value['this_out_number']);
            $data['data'][$key]['this_out_money'] = abs($value['this_out_money']);
        }

        return $data;
    }

    public function searchForProduct($data, $user){
        $search = [];
        if(! empty($data['product_name'])) $search['title'] = $data['product_name'];
        if(! empty($data['product_category_name'])) $search['product_category'] = $data['product_category_name'];
        if(! empty($data['code'])) $search['code'] = $data['code'];
        $model = (new ProductService())->productCommon($search, $user, ['id']);
        $product = $model->get()->toArray();

        return array_column($product,'id');
    }

    public function statisticsAreaDepartProduct222($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
        if(empty($data['top_depart_id'])) return [false, '请选择门店'];

        //向总社采购的钱
        $purchase_map = [];
        $purchase = PurchaseOrder::where('del_time',0)
            ->where('top_depart_id',$data['top_depart_id'])
            ->where('order_type',[PurchaseOrder::Order_type_three,PurchaseOrder::Order_type_four])
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->select('id')
            ->get()->toArray();
        $purchase_product = PurchaseOrderInfo::where("del_time",0)
            ->whereIn('purchase_order_id',array_column($purchase,'id'))
            ->select('product_id','number','price','final_amount','sports_bag_id')
            ->get()->toArray();
        foreach ($purchase_product as $value){
            if($value['sports_bag_id'] > 0){
                $money = $value['final_amount'];
            }elseif($value['final_amount'] > 0){
                $money = $value['final_amount'];
            }else{
                $money = bcmul($value['price'],$value['number'],2);
            }

            if(isset($purchase_map[$value['product_id']])){
                $tmp_money = bcadd($purchase_map[$value['product_id']]['total'], $money,2);
                $tmp_number = bcadd($purchase_map[$value['product_id']]['number'], $value['number'],2);
                $purchase_map[$value['product_id']] = [
                    'number' => $tmp_number,
                    'total' => $tmp_money
                ];
            }else{
                $purchase_map[$value['product_id']] = [
                    'number' => $value['number'],
                    'total' => $money
                ];
            }
        }

        //退货的差异
//        $returnExchange_map = $this->returnExchange($data,$return);

        //产品
        $product_list = Product::whereIn('id',array_unique(array_merge_recursive(array_column($purchase_product,'product_id'),array_keys([],'product_id'))))
            ->select('id','product_category','title')
            ->get()->toArray();
        $product_list_map = array_column($product_list,null,'id');

        $category = $category_sum = [];
        foreach ($purchase_map as $key => $value){
//            if(isset($returnExchange_map[$key])){
//                $tmp = $returnExchange_map[$key];
//                $number = bcsub($value['number'], $tmp['number'],2);
//                $total = bcsub($value['total'], $tmp['total'],2);
//                $purchase_map[$key] = [
//                    'number' => $number,
//                    'total' => $total,
//                ];
//            }
            $product_tmp = $product_list_map[$key] ?? [];
            $purchase_map[$key]['title'] = $product_tmp['title'];
            $category_tmp = json_decode($product_tmp['product_category']);
            $category_tmp = $category_tmp[0];
            if(! in_array($category_tmp,$category)) $category[] = $category_tmp;

            if(isset($category_sum[$category_tmp])){
                $tmp_number = bcadd($category_sum[$category_tmp]['number'], $purchase_map[$key]['number'],2);
                $tmp_total = bcadd($category_sum[$category_tmp]['total'], $purchase_map[$key]['total'],2);
                $category_sum[$category_tmp] = [
                    'number' => $tmp_number,
                    'total' => $tmp_total,
                ];
            }else{
                $category_sum[$category_tmp] = [
                    'number' =>  $purchase_map[$key]['number'],
                    'total' => $purchase_map[$key]['total'],
                ];
            }
        }

        //根据产品大类 $category_sum
        $category_return = ProductCategory::whereIn('id',$category)
            ->select('id','title')
            ->get()->toArray();
        foreach ($category_return as $key => $value){
            $tmp = $category_sum[$value['id']] ?? [];
            $category_return[$key]['number'] = $tmp['number'];
            $category_return[$key]['total'] = $tmp['total'];
        }

        //根据产品 $purchase_map
        dd($purchase_map);


        return [true, ''];
    }

    public function statisticsProvince2222($data,$user){
        if(empty($data['crt_time'][0]) || empty($data['crt_time'][1])) return [false, '请选择时间区间'];
        $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);

        //门店设置的指标 按照区域汇总
        $index_map = DepartIndex::where('del_time',0)
            ->pluck('param_one','top_depart_id')
            ->toArray();
        //分社所属省
        $depart_map = $province_map = [];
        $depart = Depart::where('parent_id',0)
            ->where('province','<>','')
            ->where('del_time',0)
            ->select('province','id')
            ->get()->toArray();
        foreach ($depart as $value){
            $depart_map[$value['id']] = $value['province'];
            $province_map[$value['province']][] = $value['id'];
        }

        $address_map = config('address');
        $address_map = array_column($address_map,'label','value');

        //大区
        $final_address_map = [];
        foreach ($address_map as $key => $value){
            $tmp = [
                'key' => $key,
                'title' => $value,
                'total' => 0,
                'index' => 0
            ];
            $top_depart_id = $province_map[$key] ?? [];
            if(! empty($top_depart_id)){
                foreach ($top_depart_id as $depart_id){
                    $index = $index_map[$depart_id] ?? 0;
                    $tmp['index'] = bcadd($tmp['index'], $index,2);
                }
            }
            $final_address_map[] = $tmp;
        }

        //向总社采购的钱
        $purchase_map = [];
        $purchase = PurchaseOrder::where('del_time',0)
            ->where('order_type',[PurchaseOrder::Order_type_three,PurchaseOrder::Order_type_four])
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->select('top_depart_id','purchase_total')
            ->get()->toArray();
        foreach ($purchase as $value){
            $area = $depart_map[$value['top_depart_id']] ?? 0;
            if(! $area) continue;
            if(isset($purchase_map[$area])){
                $total = bcadd($purchase_map[$area], $value['purchase_total'],2);
                $purchase_map[$area] = $total;
            }else{
                $purchase_map[$area] = $value['purchase_total'];
            }
        }

        //退货的差异
        $returnExchange_map = [];
        $returnExchange = ReturnExchangeOrder::where('del_time',0)
            ->where('type',ReturnExchangeOrder::Order_type2)
            ->where('crt_time','>=',$return[0])
            ->where('crt_time','<=',$return[1])
            ->where('crt_time','<=',$return[1])
            ->select('top_depart_id','difference_amount')
            ->get()->toArray();
        foreach ($returnExchange as $value){
            $area = $depart_map[$value['top_depart_id']] ?? 0;
            if(! $area) continue;
            if(isset($returnExchange_map[$area])){
                $total = bcadd($returnExchange_map[$area], $value['difference_amount'],2);
                $returnExchange_map[$area] = $total;
            }else{
                $returnExchange_map[$area] = $value['difference_amount'];
            }
        }

        foreach ($final_address_map as $key => $value){
            $purchase_tmp = $purchase_map[$value['key']] ?? 0;
            $return_tmp = $returnExchange_map[$value['key']] ?? 0;
            $final_address_map[$key]['total'] = bcsub($purchase_tmp, $return_tmp,2);
        }

        return [true, $final_address_map];
    }

    public function fillStatisticsBt1($data){
        if(empty($data)) return $data;

        $total = floatval(array_sum(array_column($data,'total')));

        // 设置一个最小显示阈值，比如0.5%
        $threshold = 0.5;

        // 用于存储调整后的数据
        $adjustedData = [];
        $otherTotal = 0;
        $other = [];

        foreach ($data as $value) {
            $model_type_title = SalesOrder::$model_type_title[$value['model_type']] ?? "";
            $rate = $total ? $value['total'] / $total : 0;
            // 检查是否低于阈值
            if ($rate * 100 < $threshold) {
                // 小于阈值的部分加到"其他"中
                $otherTotal += $value['total'];
                $other[] = $model_type_title;
            } else {
                // 保留更多小数位数
                $adjustedData[] = [
                    'model_type' => $value['model_type'],
                    'total' => $value['total'],
                    'model_type_title' => $model_type_title,
                    'rate' => round($rate * 100, 2)
                ];
            }
        }

        // 如果有"其他"值，则添加到数据集中
        if ($otherTotal > 0) {
            $other_title = implode(',',$other);
            $adjustedData[] = [
                'model_type' => -1, // 自定义一个类型标识
                'total' => $otherTotal,
                'model_type_title' => '其他(' . $other_title . ')',
                'rate' => round($otherTotal / $total * 100, 2)
            ];
        }


        return $adjustedData;
    }

    private function aboutTime($return){
        $day = $this->returnDays($return);
        if($day > 60) return [false, '查询时间仅支持范围区间在两月(60天)内'];
        return [true ,''];
    }

    //改装 客户模板 t9改装  不是分配的客户 是所有的 =》 点击省 展示市  只有这个有产品
    //分社 客户模板 t9改装  不是分配的客户 是所有的 =》 点击省 展示分社
    //加盟 客户模板 t9分社  不是分配的客户 是所有的 =》 点击省 展示市
    //销售 不是分配的客户 是所有的 =》 点击分社 展示销售人员(客户的负责人)
    public function customerReportStepOfFirst($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        $type = $data['type'];
        $result = [];
        if($type == 1){
            $type_detail = 1;
            if(! empty($data['type_detail'])) $type_detail = $data['type_detail'];
            if($type_detail == 1){
                $result = $this->customerReportStepOneForProvince($return,$type);
            }else{
                $result = $this->customerReportStepOneForProduct($return);
            }
        }elseif ($type == 2){
            $result = $this->customerReportStepOneForProvinceFs($return);
        }elseif ($type == 3){
            $result = $this->customerReportStepOneForProvince($return,$type);
        }elseif ($type == 4){
            $result = $this->customerReportStepOneForProvinceXs($return);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $result]];
    }

    private function customerReportStepOneForProduct($time){
        //基础产品数据
        $basic_all_data = BasicTypeAllUse::where('del_time',0)
            ->where('type', BasicTypeAllUse::type_one)
            ->select('title','id')
            ->get()->toArray();
        $basic_all = [];
        foreach ($basic_all_data as $value){
            $basic_all[] = [
                'label' => $value['title'],
                'value' => $value['id'],
                'all_num' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;
        $label = "所有产品";
        $total = [
            'label' => $label,
            'value' => "",
            'all_num' => 0
        ];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->select('consulting_product_new')
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['consulting_product_new']])) {
                $map[$value['consulting_product_new']] += 1;
            }else{
                $map[$value['consulting_product_new']] = 1;
            }
            $total['all_num'] += 1;
        }

        foreach ($basic_all as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $basic_all[$key]['all_num'] = $tmp;
            }
        }

        usort($basic_all, function($a, $b) {
            return $b['all_num'] - $a['all_num'];
        });

        array_unshift($basic_all, $total);

        return $basic_all;
    }

    private function customerReportStepOneForProvince($time, $type){
        //省市数据
        $addressData = config('address3');
        if(is_string($addressData)) $addressData = json_decode($addressData, true);
        $province = [];
        foreach ($addressData as $value){
            $province[] = [
                'label' => $value['label'],
                'value' => $value['value'],
                'follow_num' => 0,
                'all_num' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;
        if($type == 3) $model_type = Customer::Model_type_three;
        $label = "所有客资";
        $total = [
            'label' => $label,
            'value' => "",
            'follow_num' => 0,
            'all_num' => 0
        ];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->where('province_code','<>','')
            ->select('province_code','follow_num')
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['province_code']])) {
                $tmp = bcadd($value['follow_num'], $map[$value['province_code']]['num_1']);
                $map[$value['province_code']]['num_1'] = $tmp;
                $map[$value['province_code']]['num_2'] += 1;
            }else{
                $map[$value['province_code']] = [
                    'num_1' => $value['follow_num'],
                    'num_2' => 1,
                ];
            }
            $tmp_t = bcadd($total['follow_num'], $value['follow_num']);
            $total['follow_num'] = $tmp_t;
            $total['all_num'] += 1;
        }

        foreach ($province as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $province[$key]['follow_num'] = intval($tmp['num_1']);
                $province[$key]['all_num'] = $tmp['num_2'];
            }
        }

        usort($province, function($a, $b) {
            // 先比较 all_num
            if ($b['all_num'] !== $a['all_num']) {
                return $b['all_num'] - $a['all_num']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['value'] - $b['value']; // value 正序
        });

        array_unshift($province, $total);

        return $province;
    }

    private function customerReportStepOneForProvinceFs($time){
        //省市数据
        $addressData = config('address3');
        if(is_string($addressData)) $addressData = json_decode($addressData, true);
        $province = [];
        foreach ($addressData as $value){
            $province[] = [
                'label' => $value['label'],
                'value' => $value['value'],
                'follow_num' => 0,
                'all_num' => 0
            ];
        }
        //门店归属省
        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->where('province','<>','')
            ->select('id','province as province_code')
            ->get()->toArray();
        $depart_map = [];
        foreach ($depart as $value){
            $depart_map[$value['id']] = $value['province_code'];
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;
        $label = "全国分社";
        $total = [
            'label' => $label,
            'value' => "",
            'follow_num' => 0,
            'all_num' => 0
        ];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->where('province_code','<>','')
            ->select('province_code','follow_num','customer_id')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->where('type',CustomerReportDepart::type_one)
            ->select('customer_id','top_depart_id')
            ->get()->toArray();
        $detail_map = [];
        foreach ($detail as $value){
            $detail_map[$value['customer_id']][] = $value['top_depart_id'];
        }

        $map = [];
        foreach ($list as $value) {
            //客资所属门店
            $c_belong_id = $detail_map[$value['customer_id']] ?? "";
            if(empty($c_belong_id)) continue;
            foreach ($c_belong_id as $id){
                //客资所属门店所属省
                $province_code = $depart_map[$id] ?? "";
                if(empty($province_code)) continue;
                if(isset($map[$province_code])) {
                    $tmp = bcadd($value['follow_num'], $map[$province_code]['num_1']);
                    $map[$province_code]['num_1'] = $tmp;
                    $map[$province_code]['num_2'] += 1;
                }else{
                    $map[$province_code] = [
                        'num_1' => $value['follow_num'],
                        'num_2' => 1,
                    ];
                }
                $tmp_t = bcadd($total['follow_num'], $value['follow_num']);
                $total['follow_num'] = $tmp_t;
                $total['all_num'] += 1;
            }
        }

        foreach ($province as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $province[$key]['follow_num'] = intval($tmp['num_1']);
                $province[$key]['all_num'] = $tmp['num_2'];
            }
        }

        usort($province, function($a, $b) {
            // 先比较 all_num
            if ($b['all_num'] !== $a['all_num']) {
                return $b['all_num'] - $a['all_num']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['value'] - $b['value']; // value 正序
        });

        array_unshift($province, $total);

        return $province;
    }

    private function customerReportStepOneForProvinceXs($time){
        //门店
        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->select('id','title')
            ->get()->toArray();
        $departArray = [];
        foreach ($depart as $value){
            $departArray[]= [
                'label' => $value['title'],
                'value' => $value['id'],
                'follow_num' => 0,
                'all_num' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];
        $label = "所有门店";
        $total = [
            'label' => $label,
            'value' => "",
            'follow_num' => 0,
            'all_num' => 0
        ];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->select('follow_num','customer_id')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->where('type',CustomerReportDepart::type_one)
            ->select('customer_id','top_depart_id')
            ->get()->toArray();
        $detail_map = [];
        foreach ($detail as $value){
            $detail_map[$value['customer_id']][] = $value['top_depart_id'];
        }

        $map = [];
        foreach ($list as $value) {
            if(isset($detail_map[$value['customer_id']])){
                //客资所属门店
                $c_belong_id = $detail_map[$value['customer_id']];
                if(empty($c_belong_id)) continue;
                foreach ($c_belong_id as $id){
                    if(isset($map[$id])) {
                        $tmp = bcadd($value['follow_num'], $map[$id]['num_1']);
                        $map[$id]['num_1'] = $tmp;
                        $map[$id]['num_2'] += 1;
                    }else{
                        $map[$id] = [
                            'num_1' => $value['follow_num'],
                            'num_2' => 1,
                        ];
                    }
                    $tmp_t = bcadd($total['follow_num'], $value['follow_num']);
                    $total['follow_num'] = $tmp_t;
                    $total['all_num'] += 1;
                }
            }
        }

        foreach ($departArray as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $departArray[$key]['follow_num'] = intval($tmp['num_1']);
                $departArray[$key]['all_num'] = $tmp['num_2'];
            }
        }

        usort($departArray, function($a, $b) {
            // 先比较 all_num
            if ($b['all_num'] !== $a['all_num']) {
                return $b['all_num'] - $a['all_num']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['value'] - $b['value']; // value 正序
        });

        array_unshift($departArray, $total);

        return $departArray;
    }

    public function customerReportStepOfSecond($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        if(empty($data['value'])) return [false, 'value不能为空'];
        $type = $data['type'];
        if($type == 1){
            list($list, $total) = $this->customerReportStepSecondForCity($return,$data,$type);
        }elseif ($type == 2){
            list($list, $total) = $this->customerReportStepSecondForFs($return, $data);
        }elseif ($type == 3){
            list($list, $total) = $this->customerReportStepSecondForCity($return,$data,$type);
        }elseif ($type == 4){
            list($list, $total) = $this->customerReportStepSecondForProvinceXs($return,$data);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $list, 'total' => $total]];
    }

    private function customerReportStepSecondForCity($time, $data, $type){
        $province_code = $data['value'];
        //市数据
        $addressData = config('address3');
        if(is_string($addressData)) $addressData = json_decode($addressData, true);
        $city = [];
        foreach ($addressData as $value){
            if($value['value'] != $province_code) continue;
            foreach ($value['children'] as $val){
                $city[] = [
                    'label' => $val['label'],
                    'value' => $val['value'],
                    'follow_num' => 0,
                    'all_num' => 0
                ];
            }
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;
        if($type == 3) $model_type = Customer::Model_type_three;
//        $label = "所有客资";
//        $total = [
//            'label' => $label,
//            'value' => "",
//            'follow_num' => 0,
//            'all_num' => 0
//        ];

        $total = [
            'follow_num' => 0,
            'all_num' => 0
        ];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->where('province_code', $province_code)
            ->select('city_code','follow_num')
            ->get()->toArray();

        $map = [];
        $first_city = $city[0];
        foreach ($list as $value) {
            if(empty($value['city_code'])) $value['city_code'] = $first_city['value'];
            if(isset($map[$value['city_code']])) {
                $tmp = bcadd($value['follow_num'], $map[$value['city_code']]['num_1']);
                $map[$value['city_code']]['num_1'] = $tmp;
                $map[$value['city_code']]['num_2'] += 1;
            }else{
                $map[$value['city_code']] = [
                    'num_1' => $value['follow_num'],
                    'num_2' => 1,
                ];
            }
            $tmp_t = bcadd($total['follow_num'], $value['follow_num']);
            $total['follow_num'] = $tmp_t;
            $total['all_num'] += 1;
        }

        foreach ($city as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $city[$key]['follow_num'] = intval($tmp['num_1']);
                $city[$key]['all_num'] = $tmp['num_2'];
            }
        }

        usort($city, function($a, $b) {
            // 先比较 all_num
            if ($b['all_num'] !== $a['all_num']) {
                return $b['all_num'] - $a['all_num']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['value'] - $b['value']; // value 正序
        });

        return [$city, $total];
    }

    private function customerReportStepSecondForFs($time, $data){
        $province_code = $data['value'];

        //省下的所有门店
        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->where('province', $province_code)
            ->select('id','title')
            ->get()->toArray();
        $depart_id = array_column($depart,'id');
        $depart_array = [];
        foreach ($depart as $value){
            $depart_array[] = [
                'label' => $value['title'],
                'value' => $value['id'],
                'follow_num' => 0,
                'all_num' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->where('province','<>','')
            ->select('province_code','follow_num','customer_id')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->where('type',CustomerReportDepart::type_one)
            ->whereIn('top_depart_id',$depart_id)
            ->select('customer_id','top_depart_id')
            ->get()->toArray();
        $detail_map = [];
        foreach ($detail as $value){
            $detail_map[$value['customer_id']][] = $value['top_depart_id'];
        }

        $total = [
            'follow_num' => 0,
            'all_num' => 0
        ];
        $map = [];
        foreach ($list as $value) {
            if(isset($detail_map[$value['customer_id']])){
                //客资所属门店
                $c_belong_id = $detail_map[$value['customer_id']] ?? [];
                if(empty($c_belong_id)) continue;
                foreach ($c_belong_id as $id){
                    if(isset($map[$id])) {
                        $tmp = bcadd($value['follow_num'], $map[$id]['num_1']);
                        $map[$id]['num_1'] = $tmp;
                        $map[$id]['num_2'] += 1;
                    }else{
                        $map[$id] = [
                            'num_1' => $value['follow_num'],
                            'num_2' => 1,
                        ];
                    }
                    $tmp_t = bcadd($total['follow_num'], $value['follow_num']);
                    $total['follow_num'] = $tmp_t;
                    $total['all_num'] += 1;
                }
            }
        }

        foreach ($depart_array as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $depart_array[$key]['follow_num'] = intval($tmp['num_1']);
                $depart_array[$key]['all_num'] = $tmp['num_2'];
            }
        }

        usort($depart_array, function($a, $b) {
            // 先比较 all_num
            if ($b['all_num'] !== $a['all_num']) {
                return $b['all_num'] - $a['all_num']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['value'] - $b['value']; // value 正序
        });

        return [$depart_array, $total];
    }

    private function customerReportStepSecondForProvinceXs($time,$data){
        $top_depart_id = intval($data['value']);

        //门店下所有部门
        $all_depart_id = DB::select("
            WITH RECURSIVE sub_departments AS (
                SELECT id FROM depart WHERE parent_id = ? AND del_time = 0
                UNION ALL
                SELECT d.id FROM depart d
                INNER JOIN sub_departments s ON d.parent_id = s.id
                WHERE d.del_time = 0
            )
            SELECT id FROM sub_departments
        ", [$top_depart_id]);
        $allDepartIds = collect($all_depart_id)->pluck('id')->toArray();
        $allDepartIds[] = $top_depart_id;
        //所属于这个门店下的人
        $man = EmployeeDepartPermission::whereIn('depart_id', $allDepartIds)
            ->select('employee_id')
            ->get()->toArray();
        $man = array_column($man,'employee_id');
        $employee = Employee::where('del_time',0)
            ->whereIn('id', $man)
            ->select('id', 'emp_name', 'number')
            ->get()->toArray();
        $employee_map = array_column($employee,null,'id');

        $start = $time[0];
        $end = $time[1];
        $total = [
            'follow_num' => 0,
            'all_num' => 0
        ];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->select('follow_num','customer_id')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->select('customer_id','man_id','type','top_depart_id')
            ->get()->toArray();
        $manArray = $man_flag = $detail_array = $man_map = [];
        foreach ($detail as $value){
            if($value['type'] == CustomerReportDepart::type_two){
                if(isset($employee_map[$value['man_id']])){
                    if(in_array($value['man_id'], $man_flag)) continue;
                    if(! in_array($value['man_id'], $man)) continue;
                    $man_flag[] = $value['man_id'];
                    $e_t = $employee_map[$value['man_id']];
                    $manArray[] = [
                        'label' => $e_t['emp_name'],
                        'value' => $e_t['id'],
                        'follow_num' => 0,
                        'all_num' => 0
                    ];
                }
            }elseif ($value['type'] == CustomerReportDepart::type_one && $value['top_depart_id'] == $top_depart_id){
                if(! in_array($value['customer_id'], $detail_array)) $detail_array[] = $value['customer_id'];
            }elseif ($value['type'] == CustomerReportDepart::type_three){
               if(isset($man_map[$value['customer_id']][$value['man_id']])){
                   $man_map[$value['customer_id']][$value['man_id']] += 1;
               }else{
                   $man_map[$value['customer_id']][$value['man_id']] = 1;
               }
            }
        }unset($man_flag);

        $map = [];
        foreach ($list as $value) {
            //这个客户是否属于这个门店
            if(in_array($value['customer_id'], $detail_array)){
                if(isset($man_map[$value['customer_id']])) {
                    //客户由谁创建跟进记录
                    $tmp = $man_map[$value['customer_id']];
                    foreach ($tmp as $m_id => $val){
                        if(isset($map[$m_id])) {
                            $tmp = bcadd($value['follow_num'], $map[$m_id]['num_1']);
                            $map[$m_id]['num_1'] = $tmp;
                            $map[$m_id]['num_2'] += 1;
                        }else{
                            $map[$m_id] = [
                                'num_1' => $val,
                                'num_2' => 1,
                            ];
                        }
                        $tmp_t = bcadd($total['follow_num'], $val);
                        $total['follow_num'] = $tmp_t;
                    }
                }
                $total['all_num'] += 1;
            }
        }

        foreach ($manArray as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $manArray[$key]['follow_num'] = intval($tmp['num_1']);
                $manArray[$key]['all_num'] = $tmp['num_2'];
            }
        }

        usort($manArray, function($a, $b) {
            // 先比较 all_num
            if ($b['all_num'] !== $a['all_num']) {
                return $b['all_num'] - $a['all_num']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['value'] - $b['value']; // value 正序
        });

        return [$manArray, $total];
    }

    public function customerReportStepOfThird($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        if(empty($data['value'])) return [false, 'value不能为空'];
        if(empty($data['value2'])) return [false, 'value2不能为空'];
        $type = $data['type'];
        if($type == 1){
            $result = $this->customerReportStepThirdForDetail($return,$data,$type);
        }elseif ($type == 2){
            $result = $this->customerReportStepThirdForFsDetail($return, $data);
        }elseif ($type == 3){
            $result = $this->customerReportStepThirdForDetail($return,$data,$type);
        }elseif ($type == 4){
            $result = $this->customerReportStepThirdForProvinceXsDetail($return,$data);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $result]];
    }

    private function customerReportStepThirdForDetail($time, $data, $type){
        $province_code = $data['value'];
        $city_code = $data['value2'];

        //市数据
        $addressData = config('address3');
        if(is_string($addressData)) $addressData = json_decode($addressData, true);
        $first_city = "";
        foreach ($addressData as $value){
            if($value['value'] != $province_code && ! empty($city)) continue;
            foreach ($value['children'] as $val){
                if(! empty($city)) continue;
                $first_city = $val['value'];
            }
        }

        $customer = [];
        foreach (CustomerReportDepart::type_list as $key => $value){
            $customer[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;
        if($type == 3) $model_type = Customer::Model_type_three;

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->where('province_code', $province_code)
            ->select('city_code','type','customer_id','title','customer_from','car_type','consulting_product_new_title','enter_time','contact_info')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->where('type',CustomerReportDepart::type_one)
            ->select('customer_id','top_depart_id')
            ->get()->toArray();
        $detail_map = [];
        foreach ($detail as $value){
            $detail_map[$value['customer_id']][] = $value['top_depart_id'];
        }
        $depart = Depart::whereIn('id',array_unique(array_column($detail,'top_depart_id')))
            ->pluck('title','id')
            ->toArray();

        $map = [];
        foreach ($list as $value) {
            if(empty($value['city_code']) && $first_city != $city_code) continue;
            if($value['city_code'] != $city_code) continue;
            $depart_title = "";
            if(isset($detail_map[$value['customer_id']])){
                foreach ($detail_map[$value['customer_id']] as $val){
                    $t = $depart[$val];
                    if(! $t) continue;
                    $depart_title .= $t . ',';
                }
            }
            $depart_title = rtrim($depart_title,',');
            $tmp = [
                'depart_title' => $depart_title,
                'title' => $value['title'],
                'customer_from' => $value['customer_from'],
                'car_type' => $value['car_type'],
                'consulting_product_new_title' => $value['consulting_product_new_title'],
                'enter_time' => $value['enter_time'] ? date("Y-m-d H:i:s", $value['enter_time']) : "",
                'contact_info' => $value['contact_info'],
            ];
            $map[$value['type']][] = $tmp;
        }

        foreach ($customer as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $customer[$key]['list'] = $tmp;
                $customer[$key]['count'] = count($tmp);
            }
        }

        return $customer;
    }

    private function customerReportStepThirdForFsDetail($time, $data){
        $province_code = $data['value'];
        $top_depart_id = $data['value2'];

        $customer = [];
        foreach (CustomerReportDepart::type_list as $key => $value){
            $customer[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];
        $model_type = Customer::Model_type_one;

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->where('model_type',$model_type)
            ->where('province','<>','')
            ->select('type','customer_id','title','customer_from','car_type','consulting_product_new_title','enter_time','contact_info')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->where('type',CustomerReportDepart::type_one)
            ->where('top_depart_id', $top_depart_id)
            ->select('customer_id')
            ->get()->toArray();
        $detail_array = array_column($detail,'customer_id');

        $depart = Depart::where('id',$top_depart_id)->value('title');
        $map = [];
        foreach ($list as $value) {
            if(in_array($value['customer_id'], $detail_array)){
                $tmp = [
                    'depart_title' => $depart,
                    'title' => $value['title'],
                    'customer_from' => $value['customer_from'],
                    'car_type' => $value['car_type'],
                    'consulting_product_new_title' => $value['consulting_product_new_title'],
                    'enter_time' => $value['enter_time'] ? date("Y-m-d H:i:s", $value['enter_time']) : "",
                    'contact_info' => $value['contact_info'],
                ];
                $map[$value['type']][] = $tmp;
            }
        }

        foreach ($customer as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $customer[$key]['list'] = $tmp;
                $customer[$key]['count'] = count($tmp);
            }
        }

        return $customer;
    }

    private function customerReportStepThirdForProvinceXsDetail($time, $data){
        $top_depart_id = intval($data['value']);
        $man_id = $data['value2'];

        $customer = [];
        foreach (CustomerReportDepart::type_list as $key => $value){
            $customer[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0
            ];
        }

        //门店下所有部门
        $all_depart_id = DB::select("
            WITH RECURSIVE sub_departments AS (
                SELECT id FROM depart WHERE parent_id = ? AND del_time = 0
                UNION ALL
                SELECT d.id FROM depart d
                INNER JOIN sub_departments s ON d.parent_id = s.id
                WHERE d.del_time = 0
            )
            SELECT id FROM sub_departments
        ", [$top_depart_id]);
        $allDepartIds = collect($all_depart_id)->pluck('id')->toArray();
        $allDepartIds[] = $top_depart_id;
        //所属于这个门店下的人
        $exists = EmployeeDepartPermission::whereIn('depart_id', $allDepartIds)
            ->where('employee_id',$man_id)
            ->exists();
        if(! $exists) return [];

        $start = $time[0];
        $end = $time[1];

        $list = CustomerReport::where('del_time',0)
            ->where('enter_time','>=', $start)
            ->where('enter_time','<=', $end)
            ->select('type','customer_id','title','customer_from','car_type','consulting_product_new_title','enter_time','contact_info')
            ->get()->toArray();
        $detail = CustomerReportDepart::where('del_time',0)
            ->whereIn('customer_id',array_unique(array_column($list,'customer_id')))
            ->select('customer_id','man_id','type','top_depart_id')
            ->get()->toArray();

        $detail_map = [];
        $detail_array = $man_map = [];
        foreach ($detail as $value){
            if($value['type'] == CustomerReportDepart::type_two){

            }elseif ($value['type'] == CustomerReportDepart::type_one && $value['top_depart_id'] == $top_depart_id){
                $detail_map[$value['customer_id']][] = $value['top_depart_id'];
                if(! in_array($value['customer_id'], $detail_array)) $detail_array[] = $value['customer_id'];
            }elseif ($value['type'] == CustomerReportDepart::type_three){
                if($value['man_id'] == $man_id) $man_map[$value['customer_id']] = 1;
            }
        }
        $depart = Depart::whereIn('id',array_unique(array_column($detail,'top_depart_id')))
            ->pluck('title','id')
            ->toArray();

        $map = [];
        foreach ($list as $value) {
            //这个客户是否属于当前这个门店
            if(in_array($value['customer_id'], $detail_array)){
                $depart_title = "";
                if(isset($detail_map[$value['customer_id']])){
                    foreach ($detail_map[$value['customer_id']] as $val){
                        $t = $depart[$val];
                        if(! $t) continue;
                        $depart_title .= $t . ',';
                    }
                }
                $depart_title = rtrim($depart_title,',');

                if(isset($man_map[$value['customer_id']])) {
                    $tmp = [
                        'depart_title' => $depart_title,
                        'title' => $value['title'],
                        'customer_from' => $value['customer_from'],
                        'car_type' => $value['car_type'],
                        'consulting_product_new_title' => $value['consulting_product_new_title'],
                        'enter_time' => $value['enter_time'] ? date("Y-m-d H:i:s", $value['enter_time']) : "",
                        'contact_info' => $value['contact_info'],
                    ];
                    $map[$value['type']][] = $tmp;
                }
            }
        }

        foreach ($customer as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $customer[$key]['list'] = $tmp;
                $customer[$key]['count'] = count($tmp);
            }
        }

        return $customer;
    }

    //门店零售：统计各个门店所有的订单总金额
    //私域营销：统计T9品牌中心和杭州旗舰店的营销部部门下所有的人员的线下订单成交金额的总计
    //线上销售：来自T9品牌中心所有的线上订单的合同金额总计
    //门店业绩：来自分社采购单转成的订单的合同金额汇总
    //客资业绩：导入的数据
    public function saleReportStepOfFirst($data,$user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        $result = $this->saleReportStepOfFirstStart($return,$user);

        return [true, ['list' => $result]];
    }

    private function saleReportStepOfFirstStart($time,$user){
        $result = $type = [];
        foreach (SalesOrderReport::$all_list as $key => $value){
            $result[] = [
                'label' => $value,
                'value' => $key,
                'all' => ""
            ];
            $type[$key] = 0;
        }

        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        $id = [];
        $depart_list = Depart::where('del_time',0)->select('id','parent_id','title')->get()->toArray();
        foreach ($depart_list as $value){
            if(in_array($value['parent_id'], $bt_top_depart_id) && $value['title'] == "营销部"){
                $id[] = $value['id'];
            }
        }
        // 查找所有部门id
        $all_depart_id = [];
        foreach ($id as $value){
            $childIds = $this->findChildIds($value, $depart_list);
            $all_depart_id_tmp = array_merge($childIds, [$value]);
            $all_depart_id = array_merge($all_depart_id, $all_depart_id_tmp);
        }
        // 获取部门下的人
        $employee = EmployeeDepartPermission::whereIn('depart_id', $all_depart_id)
            ->select('employee_id')
            ->get()->toArray();
        $employee = array_unique(array_column($employee,'employee_id'));

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->get()->toArray();

        $head = $user['head']['id'] ?? 0;

        foreach ($list as $value){
            //门店零售
            $type[SalesOrderReport::type_one] = bcadd($type[SalesOrderReport::type_one], $value['contract_fee'],2);
            //私域营销
            $bool = in_array($value['top_depart_id'], $bt_top_depart_id);
            if($bool && in_array($value['crt_id'], $employee) && $value['model_type'] == SalesOrder::Model_type_one) $type[SalesOrderReport::type_two] = bcadd($type[SalesOrderReport::type_two], $value['contract_fee'],2);
            //线上销售
            if($value['top_depart_id'] == $head && $value['model_type'] == SalesOrder::Model_type_four) $type[SalesOrderReport::type_three] = bcadd($type[SalesOrderReport::type_three], $value['contract_fee'],2);
            //门店业绩
            if($value['from_top_depart_id'] > 0 && $value['model_type'] == SalesOrder::Model_type_two) $type[SalesOrderReport::type_four] = bcadd($type[SalesOrderReport::type_four], $value['contract_fee'],2);
        }

        //客资业绩
        $start_time = strtotime(date("Y-m-01 00:00:00", $start));
        $type_five = CustomerPerFormance::where('del_time',0)
            ->where('crt_time','>=', $start_time)
            ->where('crt_time','<=', $end)
            ->select(DB::raw('sum(current_month_payment) as current_month_payment'))
            ->first()->toArray();
        $type[SalesOrderReport::type_five] = $type_five['current_month_payment'] ?? 0;

        foreach ($result as $key => $value){
            if(isset($type[$value['value']])){
                $result[$key]['all'] = $type[$value['value']];
            }
        }

        return $result;
    }

    public function saleReportStepOfSecond($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        $type = $data['type'];
        if($type == 1){
            $result = $this->saleReportStepOfSecondTypeOne($return);
        }elseif ($type == 2){
            $result = $this->saleReportStepOfSecondTypeTwo($return);
        }elseif ($type == 3){
            $result = $this->saleReportStepOfSecondTypeThree($return, $user);
        }elseif ($type == 4){
            $result = $this->saleReportStepOfSecondTypeFour($return, $user);
        }elseif ($type == 5){
            $result = $this->saleReportStepOfSecondTypeFive($return);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $result]];
    }

    private function saleReportStepOfSecondTypeOne($time){
        //大区
        $area = [];
        foreach (Depart::$area as $key => $value){
            $area[] = [
                'label' => $value,
                'value' => $key,
                'receipt' => 0,
                'all' => 0
            ];
        }
        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'receipt' => 0,
            'all' => 0
        ];

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['area']])) {
                $tmp = bcadd($value['receipt'], $map[$value['area']]['num_1']);
                $tmp2 = bcadd($value['contract_fee'], $map[$value['area']]['num_2']);
                $map[$value['area']]['num_1'] = $tmp;
                $map[$value['area']]['num_2'] = $tmp2;
            }else{
                $map[$value['area']] = [
                    'num_1' => $value['receipt'],
                    'num_2' => $value['contract_fee'],
                ];
            }

            $tmp_t = bcadd($total['receipt'], $value['receipt'],2);
            $tmp_t1 = bcadd($total['all'], $value['contract_fee'],2);
            $total['receipt'] = $tmp_t;
            $total['all'] = $tmp_t1;
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['receipt'] = $tmp['num_1'];
                $area[$key]['all'] = $tmp['num_2'];
            }
        }

        usort($area, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['receipt'] - $b['receipt']; // value 正序
        });

        array_unshift($area, $total);

        return $area;
    }

    private function saleReportStepOfSecondTypeTwo($time){
        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        $id = [];
        $depart_list = Depart::where('del_time',0)->select('id','parent_id','title')->get()->toArray();
        foreach ($depart_list as $value){
            if(in_array($value['parent_id'], $bt_top_depart_id) && $value['title'] == "营销部"){
                $id[] = $value['id'];
            }
        }
        // 查找所有部门id
        $all_depart_id = [];
        foreach ($id as $value){
            $childIds = $this->findChildIds($value, $depart_list);
            $all_depart_id_tmp = array_merge($childIds, [$value]);
            $all_depart_id = array_merge($all_depart_id, $all_depart_id_tmp);
        }
        // 获取部门下的人
        $employee = EmployeeDepartPermission::whereIn('depart_id', $all_depart_id)
            ->select('employee_id')
            ->get()->toArray();
        $employee = array_unique(array_column($employee,'employee_id'));

        $empList = Employee::whereIn('id', $employee)
            ->select('id','emp_name as title')
            ->get()->toArray();

        $man = [];
        foreach ($empList as $value){
            $man[] = [
                'label' => $value['title'],
                'value' => $value['id'],
                'receipt' => 0,
                'all' => 0,
                'goal' => 0,
            ];
        }

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->whereIn('top_depart_id', $bt_top_depart_id)
            ->where('model_type',SalesOrder::Model_type_one)
            ->whereIn('crt_id',$employee)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['crt_id']])) {
                $tmp = bcadd($value['receipt'], $map[$value['crt_id']]['num_1']);
                $tmp2 = bcadd($value['contract_fee'], $map[$value['crt_id']]['num_2']);
                $map[$value['crt_id']]['num_1'] = $tmp;
                $map[$value['crt_id']]['num_2'] = $tmp2;
            }else{
                $map[$value['crt_id']] = [
                    'num_1' => $value['receipt'],
                    'num_2' => $value['contract_fee'],
                ];
            }
        }

        $start_time = strtotime(date("Y-m-01 00:00:00", $start));
        $month = MonthlyPerFormance::where('del_time',0)
            ->where('crt_time',">=",$start_time)
            ->where('crt_time','<=',$end)
            ->select('employee_id','sales_index')
            ->get()->toArray();
        $month_map = [];
        foreach ($month as $value){
            $month_map[$value['employee_id']] = $value['sales_index'];
        }

        foreach ($man as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $man[$key]['receipt'] = $tmp['num_1'];
                $man[$key]['all'] = $tmp['num_2'];
            }
            $man[$key]['goal'] = $month_map[$value['value']] ?? 0;
        }

        usort($man, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['receipt'] - $b['receipt']; // value 正序
        });


        return $man;
    }

    private function saleReportStepOfSecondTypeThree($time, $user){
        $head = $user['head']['id'] ?? 0;
        $list = BasicType::where('del_time',0)
            ->where('type',24)
            ->where('top_depart_id', $head)
            ->select('title')
            ->get()->toArray();

        //大区
        $area = [];
        foreach ($list as $value){
            $area[] = [
                'label' => $value['title'],
                'value' => $value['title'],
                'all' => 0
            ];
        }
        $label = "无平台来源";

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('model_type', SalesOrder::Model_type_four)
            ->where('top_depart_id', $head)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(empty($value['plat_type_title'])) $value['plat_type_title'] = $label;
            if(isset($map[$value['plat_type_title']])) {
                $tmp = bcadd($value['contract_fee'], $map[$value['plat_type_title']]['num_1']);
                $map[$value['plat_type_title']]['num_1'] = $tmp;
            }else{
                $map[$value['plat_type_title']] = [
                    'num_1' => $value['contract_fee'],
                ];
            }
        }
        if(isset($map[$label])){
            $area[] = [
                'label' => $label,
                'value' => $label,
                'all' => 0
            ];
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['all'] = $tmp['num_1'];
            }
        }

        usort($area, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }
        });


        return $area;
    }

    private function saleReportStepOfSecondTypeFour($time, $user){
        $head = $user['head']['id'] ?? 0;

        //大区
        $area = [];
        foreach (Depart::$area as $key => $value){
            $area[] = [
                'label' => $value,
                'value' => $key,
                'receipt' => 0,
                'all' => 0
            ];
        }
        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'receipt' => 0,
            'all' => 0
        ];

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('model_type', SalesOrder::Model_type_two)
            ->where('from_top_depart_id', '>', 0)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['area']])) {
                $tmp = bcadd($value['receipt'], $map[$value['area']]['num_1']);
                $tmp2 = bcadd($value['contract_fee'], $map[$value['area']]['num_2']);
                $map[$value['area']]['num_1'] = $tmp;
                $map[$value['area']]['num_2'] = $tmp2;
            }else{
                $map[$value['area']] = [
                    'num_1' => $value['receipt'],
                    'num_2' => $value['contract_fee'],
                ];
            }

            $tmp_t = bcadd($total['receipt'], $value['receipt'],2);
            $tmp_t1 = bcadd($total['all'], $value['contract_fee'],2);
            $total['receipt'] = $tmp_t;
            $total['all'] = $tmp_t1;
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['receipt'] = $tmp['num_1'];
                $area[$key]['all'] = $tmp['num_2'];
            }
        }

        usort($area, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['receipt'] - $b['receipt']; // value 正序
        });

        array_unshift($area, $total);

        return $area;
    }

    private function saleReportStepOfSecondTypeFive($time){
        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'all' => 0
        ];

        $start = $time[0];
        $end = $time[1];

        $start_time = strtotime(date("Y-m-01 00:00:00", $start));
        $list = CustomerPerFormance::where('del_time',0)
            ->where('crt_time','>=', $start_time)
            ->where('crt_time','<=', $end)
            ->get()->toArray();


        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['area']])) {
                $tmp = bcadd($value['current_month_payment'], $map[$value['area']]['all']);
                $map[$value['area']]['all'] = $tmp;
            }else{
                $map[$value['area']] = [
                    'label' => $value['area'],
                    'value' => $value['area'],
                    'all' => $value['current_month_payment']
                ];
            }

            $tmp_t1 = bcadd($total['all'], $value['current_month_payment'],2);
            $total['all'] = $tmp_t1;
        }

        $map = array_values($map);

        usort($map, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }
        });

        array_unshift($map, $total);

        return $map;
    }

    public function saleReportStepOfThird($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        if(empty($data['value'])) return [false, 'value不能为空'];
        $type = $data['type'];
        if($type == 1){
            $result = $this->saleReportStepOfThirdTypeOne($return, $data);
        }elseif ($type == 2){
            $result = $this->saleReportStepOfThirdTypeTwo($return, $data);
        }elseif ($type == 3){
            $result = $this->saleReportStepOfThirdTypeThree($return, $data, $user);
        }elseif ($type == 4){
            $result = $this->saleReportStepOfThirdTypeFour($return, $data, $user);
        }elseif ($type == 5){
            $result = $this->saleReportStepOfThreeTypeFive($return,$data);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $result]];
    }

    private function saleReportStepOfThirdTypeOne($time,$data){
        $area_value = $data['value'];

        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->where('area',$area_value)
            ->select('id','title')
            ->get()->toArray();
        //大区
        $area = [];
        foreach ($depart as $value){
            $area[] = [
                'label' => $value['title'],
                'value' => $value['id'],
                'receipt' => 0,
                'all' => 0
            ];
        }
        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'receipt' => 0,
            'all' => 0
        ];

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('area',$area_value)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['top_depart_id']])) {
                $tmp = bcadd($value['receipt'], $map[$value['top_depart_id']]['num_1']);
                $tmp2 = bcadd($value['contract_fee'], $map[$value['top_depart_id']]['num_2']);
                $map[$value['top_depart_id']]['num_1'] = $tmp;
                $map[$value['top_depart_id']]['num_2'] = $tmp2;
            }else{
                $map[$value['top_depart_id']] = [
                    'num_1' => $value['receipt'],
                    'num_2' => $value['contract_fee'],
                ];
            }

            $tmp_t = bcadd($total['receipt'], $value['receipt'],2);
            $tmp_t1 = bcadd($total['all'], $value['contract_fee'],2);
            $total['receipt'] = $tmp_t;
            $total['all'] = $tmp_t1;
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['receipt'] = $tmp['num_1'];
                $area[$key]['all'] = $tmp['num_2'];
            }
        }

        usort($area, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['receipt'] - $b['receipt']; // value 正序
        });

        array_unshift($area, $total);

        return $area;
    }

    private function saleReportStepOfThirdTypeTwo($time,$data){
        $man_value = $data['value'];

        $area = [];
        foreach (SalesOrderReport::$all_state_list as $key => $value){
            $area[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0
            ];
        }

        $setting = Setting::where('setting_name','bt_top_depart_id')->first();
        $bt_top_depart_id = $setting['setting_value'] ?? [];
        $bt_top_depart_id = json_decode($bt_top_depart_id,true);

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->whereIn('top_depart_id', $bt_top_depart_id)
            ->where('model_type',SalesOrder::Model_type_one)
            ->where('crt_id', $man_value)
            ->orderBy('crt_time','desc')
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            $crt_time = $value['crt_time'] ? date("Y-m-d H:i:s", $value['crt_time']) : "";
            $model_type_title = SalesOrder::$model_type_title[$value['model_type']] ?? "";
            $tmp = [
                'crt_time' => $crt_time,
                'model_type_title' => $model_type_title,
                'customer' => $value['customer_title'],
                'contact_product' => $value['contact_product'],
                'fz' => $value['fz_man'],
                'contract_fee' => $value['contract_fee'],
            ];
            $map[SalesOrderReport::state_zero][] = $tmp;

            if($value['state'] == 1){
                $map[SalesOrderReport::state_one][] = $tmp;
            }elseif ($value['state'] == 2){
                $map[SalesOrderReport::state_two][] = $tmp;
            }elseif ($value['state'] == 3){
                $map[SalesOrderReport::state_three][] = $tmp;
            }elseif ($value['state'] == 4){
                $map[SalesOrderReport::state_four][] = $tmp;
            }
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['list'] = $tmp;
                $area[$key]['count'] = count($tmp);
            }
        }

        return $area;
    }

    private function saleReportStepOfThirdTypeThree($time,$data, $user){
        $head = $user['head']['id'] ?? 0;
        $basic_value = $data['value'];

        $area = [];
        foreach (SalesOrderReport::$all_state_list as $key => $value){
            $area[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('model_type', SalesOrder::Model_type_four)
            ->where('top_depart_id', $head)
            ->where('plat_type_title', $basic_value)
            ->orderBy('crt_time','desc')
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            $crt_time = $value['crt_time'] ? date("Y-m-d H:i:s", $value['crt_time']) : "";
            $model_type_title = SalesOrder::$model_type_title[$value['model_type']] ?? "";
            $tmp = [
                'crt_time' => $crt_time,
                'model_type_title' => $model_type_title,
                'customer' => $value['customer_title'],
                'contact_product' => $value['contact_product'],
                'fz' => $value['fz_man'],
                'contract_fee' => $value['contract_fee'],
            ];
            $map[SalesOrderReport::state_zero][] = $tmp;

            if($value['state'] == 1){
                $map[SalesOrderReport::state_one][] = $tmp;
            }elseif ($value['state'] == 2){
                $map[SalesOrderReport::state_two][] = $tmp;
            }elseif ($value['state'] == 3){
                $map[SalesOrderReport::state_three][] = $tmp;
            }elseif ($value['state'] == 4){
                $map[SalesOrderReport::state_four][] = $tmp;
            }
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['list'] = $tmp;
                $area[$key]['count'] = count($tmp);
            }
        }

        return $area;
    }

    private function saleReportStepOfThirdTypeFour($time,$data, $user){
        $head = $user['head']['id'] ?? 0;
        $area_value = $data['value'];

        $depart = Depart::where('del_time',0)
            ->where('parent_id',0)
            ->where('area', $area_value)
            ->select('id','title')
            ->get()->toArray();
        //大区
        $area = [];
        foreach ($depart as $value){
            $area[] = [
                'label' => $value['title'],
                'value' => $value['id'],
                'receipt' => 0,
                'all' => 0
            ];
        }
        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'receipt' => 0,
            'all' => 0
        ];

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('area',$area_value)
            ->where('model_type', SalesOrder::Model_type_two)
            ->where('from_top_depart_id', '>',0)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['from_top_depart_id']])) {
                $tmp = bcadd($value['receipt'], $map[$value['from_top_depart_id']]['num_1']);
                $tmp2 = bcadd($value['contract_fee'], $map[$value['from_top_depart_id']]['num_2']);
                $map[$value['from_top_depart_id']]['num_1'] = $tmp;
                $map[$value['from_top_depart_id']]['num_2'] = $tmp2;
            }else{
                $map[$value['from_top_depart_id']] = [
                    'num_1' => $value['receipt'],
                    'num_2' => $value['contract_fee'],
                ];
            }

            $tmp_t = bcadd($total['receipt'], $value['receipt'],2);
            $tmp_t1 = bcadd($total['all'], $value['contract_fee'],2);
            $total['receipt'] = $tmp_t;
            $total['all'] = $tmp_t1;
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['receipt'] = $tmp['num_1'];
                $area[$key]['all'] = $tmp['num_2'];
            }
        }

        usort($area, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['receipt'] - $b['receipt']; // value 正序
        });

        array_unshift($area, $total);

        return $area;
    }

    private function saleReportStepOfThreeTypeFive($time,$data){
        $area_value = $data['value'];

        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'all' => 0
        ];

        $start = $time[0];
        $end = $time[1];

        $start_time = strtotime(date("Y-m-01 00:00:00", $start));
        $list = CustomerPerFormance::where('del_time',0)
            ->where('crt_time','>=', $start_time)
            ->where('crt_time','<=', $end)
            ->where('area', $area_value)
            ->get()->toArray();


        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['title']])) {
                $tmp = bcadd($value['current_month_payment'], $map[$value['title']]['all']);
                $map[$value['title']]['all'] = $tmp;
            }else{
                $map[$value['title']] = [
                    'label' => $value['title'],
                    'value' => $value['title'],
                    'all' => $value['current_month_payment']
                ];
            }

            $tmp_t1 = bcadd($total['all'], $value['current_month_payment'],2);
            $total['all'] = $tmp_t1;
        }

        $map = array_values($map);

        usort($map, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all 降序
            }
        });

        array_unshift($map, $total);

        return $map;
    }

    public function saleReportStepOfFour($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        if(empty($data['value'])) return [false, 'value不能为空'];
        if(empty($data['value2'])) return [false, 'value2不能为空'];
        $type = $data['type'];
        if($type == 1){
            $result = $this->saleReportStepOfFourTypeOne($return, $data);
        }elseif ($type == 4){
            $result = $this->saleReportStepOfFourTypeFour($return, $data, $user);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $result]];
    }

    private function saleReportStepOfFourTypeOne($time,$data){
        $area_value = $data['value'];
        $depart_value = $data['value2'];

        $depart_list = Depart::where('del_time',0)->select('id','parent_id','title')->get()->toArray();
        // 查找所有部门id
        $childIds = $this->findChildIds($depart_value, $depart_list);
        $all_depart_id = array_merge($childIds, [$depart_value]);

        // 获取部门下的人
        $employee = EmployeeDepartPermission::whereIn('depart_id', $all_depart_id)
            ->select('employee_id')
            ->get()->toArray();
        $employee = array_unique(array_column($employee,'employee_id'));

        $empMap = Employee::whereIn('id', $employee)
            ->pluck('emp_name as title','id')
            ->toArray();
        $area = [];
        foreach ($empMap as $key => $value){
            $area[$key] = [
                'label' => $value,
                'value' => $key,
                'receipt' => 0,
                'all' => 0,
                'goal' => 0,
            ];
        }

        $label = "全部";
        $total = [
            'label' => $label,
            'value' => "",
            'receipt' => 0,
            'all' => 0,
            'goal' => 0,
        ];

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('area',$area_value)
            ->where('top_depart_id',$depart_value)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            if(isset($map[$value['crt_id']])) {
                $tmp = bcadd($value['receipt'], $map[$value['crt_id']]['num_1']);
                $tmp2 = bcadd($value['contract_fee'], $map[$value['crt_id']]['num_2']);
                $map[$value['crt_id']]['num_1'] = $tmp;
                $map[$value['crt_id']]['num_2'] = $tmp2;
            }else{
                $map[$value['crt_id']] = [
                    'num_1' => $value['receipt'],
                    'num_2' => $value['contract_fee'],
                ];
            }

            $tmp_t = bcadd($total['receipt'], $value['receipt'],2);
            $tmp_t1 = bcadd($total['all'], $value['contract_fee'],2);
            $total['receipt'] = $tmp_t;
            $total['all'] = $tmp_t1;
        }

        $start_time = strtotime(date("Y-m-01 00:00:00", $start));
        $month = MonthlyPerFormance::where('del_time',0)
            ->where('crt_time',">=",$start_time)
            ->where('crt_time','<=',$end)
            ->select('employee_id','sales_index')
            ->get()->toArray();
        $month_map = [];
        foreach ($month as $value){
            $month_map[$value['employee_id']] = $value['sales_index'];
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['receipt'] = $tmp['num_1'];
                $area[$key]['all'] = $tmp['num_2'];
                $goal = $month_map[$value['value']] ?? 0;
                $area[$key]['goal'] = $goal;
                $total['goal'] = bcadd($goal, $total['goal'],2);
            }else{
                unset($area[$key]);
            }
        }

        $area = array_values($area);

        usort($area, function($a, $b) {
            // 先比较 all_num
            if ($b['all'] !== $a['all']) {
                return $b['all'] - $a['all']; // all_num 降序
            }

            // 如果 all_num 相同，再比较 value
            return $a['receipt'] - $b['receipt']; // value 正序
        });

        array_unshift($area, $total);

        return $area;
    }

    private function saleReportStepOfFourTypeFour($time,$data, $user){
        $head = $user['head']['id'] ?? 0;
        $area_value = $data['value'];
        $depart_value = $data['value2'];

        $area = [];
        foreach (SalesOrderReport::$all_state_list as $key => $value){
            $area[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0,
            ];
        }

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('area',$area_value)
            ->where('model_type', SalesOrder::Model_type_two)
            ->where('from_top_depart_id', $depart_value)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            $crt_time = $value['crt_time'] ? date("Y-m-d H:i:s", $value['crt_time']) : "";
            $model_type_title = SalesOrder::$model_type_title[$value['model_type']] ?? "";
            $tmp = [
                'crt_time' => $crt_time,
                'model_type_title' => $model_type_title,
                'customer' => $value['customer_title'],
                'contact_product' => $value['contact_product'],
                'fz' => $value['fz_man'],
                'contract_fee' => $value['contract_fee'],
            ];
            $map[SalesOrderReport::state_zero][] = $tmp;

            if($value['state'] == 1){
                $map[SalesOrderReport::state_one][] = $tmp;
            }elseif ($value['state'] == 2){
                $map[SalesOrderReport::state_two][] = $tmp;
            }elseif ($value['state'] == 3){
                $map[SalesOrderReport::state_three][] = $tmp;
            }elseif ($value['state'] == 4){
                $map[SalesOrderReport::state_four][] = $tmp;
            }
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['list'] = $tmp;
                $area[$key]['count'] = count($tmp);
            }
        }

        return $area;
    }

    public function saleReportStepOfFive($data, $user){
        if(empty($data['enter_time'][0]) || empty($data['enter_time'][1])) return [false, '请选择日期'];
        $return = $this->changeDateToTimeStampAboutRange($data['enter_time']);
        list($status, $msg) = $this->aboutTime($return);
        if(! $status) return [false, $msg];
        if(empty($data['type'])) return [false, '请选择报表查看类型'];
        if(empty($data['value'])) return [false, 'value不能为空'];
        if(empty($data['value2'])) return [false, 'value2不能为空'];
        if(empty($data['value3'])) return [false, 'value3不能为空'];
        $type = $data['type'];
        if($type == 1){
            $result = $this->saleReportStepOfFiveTypeOne($return, $data);
        }else{
            return [false ,'报表查看类型错误'];
        }

        return [true, ['list' => $result]];
    }

    private function saleReportStepOfFiveTypeOne($time,$data){
        $area_value = $data['value'];
        $depart_value = $data['value2'];
        $man_value = $data['value3'];

        $area = [];
        foreach (SalesOrderReport::$all_state_list as $key => $value){
            $area[] = [
                'label' => $value,
                'value' => $key,
                'list' => [],
                'count' => 0
            ];
        }

        $start = $time[0];
        $end = $time[1];

        $list = SalesOrderReport::where('del_time',0)
            ->where('crt_time','>=', $start)
            ->where('crt_time','<=', $end)
            ->where('area',$area_value)
            ->where('top_depart_id',$depart_value)
            ->where('crt_id', $man_value)
            ->get()->toArray();

        $map = [];
        foreach ($list as $value) {
            $crt_time = $value['crt_time'] ? date("Y-m-d H:i:s", $value['crt_time']) : "";
            $model_type_title = SalesOrder::$model_type_title[$value['model_type']] ?? "";
            $tmp = [
                'crt_time' => $crt_time,
                'model_type_title' => $model_type_title,
                'customer' => $value['customer_title'],
                'contact_product' => $value['contact_product'],
                'fz' => $value['fz_man'],
                'contract_fee' => $value['contract_fee'],
            ];
            $map[SalesOrderReport::state_zero][] = $tmp;

            if($value['state'] == 1){
                $map[SalesOrderReport::state_one][] = $tmp;
            }elseif ($value['state'] == 2){
                $map[SalesOrderReport::state_two][] = $tmp;
            }elseif ($value['state'] == 3){
                $map[SalesOrderReport::state_three][] = $tmp;
            }elseif ($value['state'] == 4){
                $map[SalesOrderReport::state_four][] = $tmp;
            }
        }

        foreach ($area as $key => $value){
            if(isset($map[$value['value']])){
                $tmp = $map[$value['value']];
                $area[$key]['list'] = $tmp;
                $area[$key]['count'] = count($tmp);
            }
        }

        return $area;
    }
}