drb/app/Service/StatisticsService.php

<?php

namespace App\Service;

use App\Model\RevenueCost;
use App\Model\RevenueCostTotal;

class StatisticsService extends Service
{
    public function statisticsRevenueCostCommon($data,$user, $field = []){
        if(empty($field)) $field = RevenueCostTotal::$field;
        $model = RevenueCostTotal::where('del_time',0)
            ->select($field)
            ->orderby('id', 'desc');
        if(! empty($data['order_time'])){
            list($start_time, $end_time) = $this->changeDateToTimeStampAboutRange($data['order_time'],false);
            if ($start_time === null || $end_time === null || $start_time > $end_time) return [false, "单据日期的区间无效"];
            $model->where('order_time', '>=', $start_time)
                ->where('order_time', '<', $end_time);
        }
        if(! empty($data['order_type'])) $model->where('order_type',$data['order_type']);

        return [true, $model];
    }

    public function statisticsRevenueCost($data,$user){
        list($status, $model) = $this->statisticsRevenueCostCommon($data, $user);
        if(! $status) return [false, $model];
        $list = $this->limit($model,'',$data);
        $list = $this->statisticsRevenueCostFillData($list);

        return [true, $list];
    }

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

        foreach ($data['data'] as $key => $value){
            $time = date("Y-m", $value['order_time']);
            $data['data'][$key]['order_time'] = $time;
            $data['data'][$key]['order_type_title'] = RevenueCost::$order_type[$value['order_type']] ?? "";
            $data['data'][$key]['profit_rate'] = bcmul($value['profit_rate'], 100,2);
        }

        return $data;
    }

    //无用
    public function statisticsRevenueCostFillData1($data){
        if(empty($data)) return $data;

        $return = [];
        foreach ($data as $key => $value){
            $time = date("Y-m", $value['order_time']);
            if($value['order_type'] == RevenueCost::ORDER_ONE){
                $income = $value['price_3_total'];
            }elseif ($value['order_type'] == RevenueCost::ORDER_TWO){
                $income = $value['price_1_total'];
            }else{
                $income = $value['payment_amount'];
            }
            $adjust = $income < 0 ? $income : 0;
            $business = $value['price_4_total'];
            if(isset($return[$time][$value['order_type']])){
                $income_total = bcadd($return[$time][$value['order_type']]['income'], $income,2);
                $adjust_total = bcadd($return[$time][$value['order_type']]['adjust'], $adjust,2);
                $business_total = bcadd($return[$time][$value['order_type']]['business'], $business,2);
                $return[$time][$value['order_type']]['income'] = $income_total;
                $return[$time][$value['order_type']]['adjust'] = $adjust_total;
                $return[$time][$value['order_type']]['business'] = $business_total;
            }else{
                $return[$time][$value['order_type']] = [
                    'income' => $income,
                    'adjust' => $adjust,
                    'business' => $business,
                    'time' => $time,
                ];
            }
        }
        $final = [];
        foreach ($return as $value){
            foreach ($value as $key => $val){
                $title = RevenueCost::$order_type[$key] ?? "";
                $val['title'] = $title;
                $profit = bcsub($val['income'], $val['business'],2);
                $profit_rate = $val['income'] > 0 ? bcdiv($profit, $val['income'],2) : 0;
                $profit_rate = bcmul($profit_rate, 100,2);
                $val['profit'] = $profit;
                $val['profit_rate'] = $profit_rate;
                $val['order_type'] = $key;
                $final[] = $val;
            }
        }

        return $final;
    }

    public function statisticsRevenueCostOneAndTwoCommon($data,$user, $field = []){
        if(empty($data['order_type']) || ! isset(RevenueCost::$order_type[$data['order_type']])) return [false, '单据类型不存在或错误'];

        if(empty($field)) {
            if($data['order_type'] == 1){
                $field = RevenueCost::$field_xhd;
            }else{
                $field = RevenueCost::$field_xsfp;
            }
        }
        $model = RevenueCost::where('del_time',0)
            ->select($field)
            ->orderby('id', 'desc');
        if(! empty($data['order_time'])){
            list($start_time, $end_time) = $this->changeDateToTimeStampAboutRange($data['order_time'],false);
            if ($start_time === null || $end_time === null || $start_time > $end_time) return [false, "单据日期的区间无效"];
            $model->where('order_time', '>=', $start_time)
                ->where('order_time', '<=', $end_time);
        }
        if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
        if(! empty($data['customer_title'])) $model->where('customer_title', 'LIKE', '%'.$data['customer_title'].'%');
        if(! empty($data['employee_id_1_title'])) $model->where('employee_id_1_title', 'LIKE', '%'.$data['employee_id_1_title'].'%');

        return [true, $model];
    }

    public function statisticsRevenueCostOneAndTwo($data,$user){
        list($status, $model) = $this->statisticsRevenueCostOneAndTwoCommon($data, $user);
        if(! $status) return [false, $model];
        $list = $this->limit($model,'',$data);
        $list = $this->statisticsRevenueCostOneAndTwoFillData($list,$user,$data);

        return [true, $list];
    }

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

        foreach ($data['data'] as $key => $value){
            $data['data'][$key]['profit_rate'] = bcmul($value['profit_rate'], 100,2);
            $data['data'][$key]['order_time'] = $value['order_time'] ? date("Y-m-d", $value['order_time']) : "";
        }

        return $data;
    }
}