SupplierStatisticsService.php

<?php


namespace App\Http\Services;

use App\Http\Controllers\Filter\SupplierFilter;
use App\Model\SupplierChannelModel;
use Illuminate\Support\Facades\DB;

class SupplierStatisticsService
{
    //获取供应商列表需要统计的信息
    public function getSupplierListStatistics()
    {

        $total = $this->getStatisticsCount('all');
        //待审核,就是以前的草稿
        $pending = $this->getStatisticsCount('pending');
        //审核中
        $inReview = $this->getStatisticsCount('in_review');
        //通过
        $passed = $this->getStatisticsCount('passed');
        //未通过
        $rejected = $this->getStatisticsCount('rejected');
        //禁用
        $disable = $this->getStatisticsCount('disable');
        //没有渠道开发员
        $noPurchaseUid = $this->getStatisticsCount('no_purchase_uid');
        //存在无效(离职)采购员
        $invalidChannelUid = $this->getStatisticsCount('invalid_channel_uid');
        //存在无效(离职)开发员
        $invalidPurchaseUid = $this->getStatisticsCount('invalid_purchase_uid');
        //需要跟进的
        $toFollowUp = $this->getStatisticsCount('to_follow_up');
        //没有sku的
        $noSku = $this->getStatisticsCount('no_sku');

        $result = [
            'total' => $total,
            'pending' => $pending,
            'in_review' => $inReview,
            'passed' => $passed,
            'rejected' => $rejected,
            'disable' => $disable,
            'no_purchase_uid' => $noPurchaseUid,
            'invalid_channel_uid' => $invalidChannelUid,
            'invalid_purchase_uid' => $invalidPurchaseUid,
            'to_follow_up' => $toFollowUp,
            'no_sku' => $noSku,
        ];
        $result = array_map(function ($value) {
            if ($value > 999) {
                $value = '999+';
            }
            return $value;
        }, $result);

        return $result;
    }

    private function getStatisticsCount($type)
    {
        $model = new SupplierChannelModel();
        $model = $model->where('supplier_id','>',0);
        //显示默认的数据(有权限逻辑)
        $filter = new SupplierFilter();
        return $filter->defaultFilter($model, $type)->count();
    }
}