zhijiayun/app/Http/Controllers/Manager/Statistics/BasicPanel.php

<?php

namespace App\Http\Controllers\manager\Statistics;

use App\Http\Controllers\Controller;
use App\Http\Requests\Manager\Statistics\BasicPanel as request;
use App\Models\Manager\Process\LowPriceGoods as LowPriceGoodsModel;
use App\Models\Manager\Process\ViolationProduct as ViolationProductModel;
use App\Models\Manager\Process\ViolationStore as ViolationStoreModel;
use App\Models\Manager\Collect\Product as ProductModel;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Carbon;
use App\Models\Manager\Collect\ProductTask as ProductTaskModel;
use PhpParser\Node\Stmt\Foreach_;

/**
 * 数据分析-基础概览面板
 * @author 唐远望
 * @version   1.0
 * @date      2026-02-10
 * 
 */
class BasicPanel extends Controller
{

    /*
     * 挂网数据统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_online_goods_count(request $request, LowPriceGoodsModel $lowPriceGoodsModel, ViolationProductModel $violationProductModel, ViolationStoreModel $violationStoreModel, ProductModel $productModel)
    {
        $request->scene('get_online_goods_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);

        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];

        // 统计挂网商品数量=低价挂网商品数量（去重）+ 禁止挂网商品数量（去重）
        $lowPriceGoodsModel = $lowPriceGoodsModel->query();
        $violationProductModel = $violationProductModel->query();

        if ($is_admin != 1 && $company_id != 0) {
            $lowPriceGoodsModel = $lowPriceGoodsModel->where('company_id', $company_id);
            $violationProductModel = $violationProductModel->where('company_id', $company_id);
            $violationStoreModel = $violationStoreModel->where('company_id', $company_id);
        } else {
            $lowPriceGoodsModel = $lowPriceGoodsModel->where('company_id', $admin_company_id);
            $violationProductModel = $violationProductModel->where('company_id', $admin_company_id);
            $violationStoreModel = $violationStoreModel->where('company_id', $admin_company_id);
        }

        //获取采集商品数量
        $collect_statistics_data = $this->get_product_count($start_time, $end_time, $product_name, $is_admin, $company_id, $admin_company_id);

        // 低价挂网商品数量查询
        $lowPriceGoodsCount = $lowPriceGoodsModel->where($map)
            ->where('status', 0)
            ->get()->count();
        // 禁止挂网商品数量查询
        $violationProductCount = $violationProductModel->where($map)
            ->where('status', 0)
            ->get()->count();

        $store_map = [];
        if ($start_time) $store_map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $store_map[]   = ['insert_time', '<=', $end_time];
        // 违规店铺数量查询
        $violationStoreCount = $violationStoreModel->where($store_map)
            ->where('status', 0)
            ->groupBy('store_name')
            ->select('store_name')
            ->get()->count();

        $result_data = [
            'low_price_goods_count' => $lowPriceGoodsCount, // 低价挂网商品数量
            'violation_product_count' => $violationProductCount, // 禁止挂网商品数量
            'violation_store_count' => $violationStoreCount, // 违规店铺数量
            'totle_product_count' => $lowPriceGoodsCount + $violationProductCount, // 总商品数量
        ];
        $result_data = array_merge($result_data, $collect_statistics_data);

        return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result_data]);
    }


    /**
     * 品规数量统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    private function get_product_count($start_time, $end_time, $product_name, $is_admin, $company_id, $admin_company_id)
    {
        $ProductTaskModel = new ProductTaskModel();
        $select_company_id = 0;
        if ($is_admin != 1 && $company_id != 0) {
            $select_company_id = $company_id;
        } else {
            $select_company_id = $admin_company_id;
        }
        $map = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        //获取B端品规数量
        //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
        $collect_b_product_count = 0;
        $collect_b_product_list_data = $ProductTaskModel
            ->whereIn('platform',['0', '5', '6', '7', '8', '9', '10'])//1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
            ->where('company_id', $select_company_id)
            ->where($map)
            ->get()->toarray();
        $collect_b_product_list =[];//按品规
        $collect_b_product_name_list =[];//按商品名称
        if(!empty($collect_b_product_list_data)){
            foreach ($collect_b_product_list_data as $key => $value) {
                $collect_b_product_name =trim($value['product_brand'].'_'. $value['product_name']);
                $collect_b_product_specs = $value['product_specs'] !='' ? explode(',', $value['product_specs']) : [];
                if(isset($collect_b_product_list[$collect_b_product_name])){
                    $collect_b_product_list[$collect_b_product_name] = array_merge($collect_b_product_list[$collect_b_product_name],$collect_b_product_specs);
                }else{
                    $collect_b_product_list[$collect_b_product_name] = $collect_b_product_specs;
                }
                //去重$collect_b_product_list[$collect_b_product_name]数据
                $collect_b_product_list[$collect_b_product_name] =count($collect_b_product_list[$collect_b_product_name]) > 0 ? array_unique($collect_b_product_list[$collect_b_product_name]):[];
                $collect_b_product_name_list[$value['product_name']] = 1;
            }
        }
        $collect_b_product_name_count = count($collect_b_product_name_list);
        //计算B端品规数量
        if(!empty($collect_b_product_list)){
            foreach ($collect_b_product_list as $key => $value) {
                if(empty($value)){
                     $value = ['全量采集'];
                     $collect_b_product_list[$key] = $value;
                }
                $collect_b_product_count = $collect_b_product_count + count($value);
            }
        }
       
        //获取C端品规数量
        //C端：美团、拼多多、天猫、京东、药房网
        $collect_c_product_count = 0;
        $collect_c_product_list_data = $ProductTaskModel
            ->whereIn('platform',['0', '1', '2', '3', '4', '11'])//1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
            ->where('company_id', $select_company_id)
            ->where($map)
            ->get()->toarray();
        $collect_c_product_list =[];
        $collect_c_product_name_list =[];//按商品名称
        if(!empty($collect_c_product_list_data)){
            foreach ($collect_c_product_list_data as $key => $value) {
                $collect_c_product_name = trim($value['product_brand'].'_'. $value['product_name']);
                $collect_c_product_specs = $value['product_specs'] !='' ? explode(',', $value['product_specs']) : [];
                if(isset($collect_c_product_list[$collect_c_product_name])){
                    $collect_c_product_list[$collect_c_product_name] = array_merge($collect_c_product_list[$collect_c_product_name],$collect_c_product_specs);
                }else{
                    $collect_c_product_list[$collect_c_product_name] = $collect_c_product_specs;
                }
                //去重$collect_c_product_list[$collect_c_product_name]数据
                $collect_c_product_list[$collect_c_product_name] = count($collect_c_product_list[$collect_c_product_name]) > 0 ? array_unique($collect_c_product_list[$collect_c_product_name]):[];
                $collect_c_product_name_list[$value['product_name']] = 1;
            }
        }
        $collect_c_product_name_count = count($collect_c_product_name_list);
        //计算C端品规数量
        if(!empty($collect_c_product_list)){
            foreach ($collect_c_product_list as $key => $value) {
                if(empty($value)){
                     $value = ['全量采集'];
                     $collect_c_product_list[$key] = $value;
                }
                $collect_c_product_count = $collect_c_product_count + count($value);
            }
        }
        //获取所有终端品规数量
        $collect_totle_product_count = $collect_b_product_count + $collect_c_product_count;
        //合并去重C端品规，以及B端品规数据
        $collect_product_list_data =[];
        if(count($collect_c_product_list) > 0){
            foreach ($collect_c_product_list as $collect_c_product_key => $collect_c_product_values) {
                if(count($value)){
                    foreach ($collect_c_product_values as $value_specs_key => $collect_c_product_value) {
                        $product_specs_name = $collect_c_product_key .'_'. $collect_c_product_value;
                        $collect_product_list_data[$product_specs_name] ='1';
                    }
                }else{
                    $collect_product_list_data[$key] ='1';
                }
            }
        }
        if(count($collect_b_product_list) > 0){
            foreach ($collect_b_product_list as $collect_b_product_key => $collect_b_product_values) {
                if(count($value)){
                    foreach ($collect_b_product_values as $k => $collect_b_product_value) {
                        $product_specs_name = $collect_b_product_key .'_'. $collect_b_product_value;//按品规数量去重
                        $collect_product_list_data[$product_specs_name] ='1';
                    }
                }else{
                    $collect_product_list_data[$key] ='1';
                }
            }
        }
        //合并去重C端商品名称，以及B端商品名称
        $collect_product_name_list_data =[];
        if(count($collect_c_product_name_list) > 0){
            foreach ($collect_c_product_name_list as $collect_c_product_name_key => $collect_c_product_name_value) {
               $collect_product_name_list_data[$collect_c_product_name_key] = 1;
            }
        }
        if(count($collect_b_product_name_list) > 0){
            foreach ($collect_b_product_name_list as $collect_b_product_name_key => $collect_b_product_name_value) {
               $collect_product_name_list_data[$collect_b_product_name_key] = 1;
            }
        }
         //显示去重后的商品名称数量
        $collect_product_name_count = count($collect_product_name_list_data);
        //显示去重后的商品品规数量
        $collect_totle_product_count = count($collect_product_list_data);
        $result_data = [
            'collect_b_product_count' => $collect_b_product_name_count, // B端商品名称数量
            'collect_c_product_count' => $collect_c_product_name_count, // C端商品名称数量
            'collect_oto_product_count' => 0, // OTO商品名称数量
            'collect_totle_product_count' => $collect_product_name_count, // 所有终端商品名称数量
            'collect_c_product_data' => $collect_c_product_name_list, // C端商品名称数据
            'collect_b_product_data' => $collect_b_product_name_list, // B端商品名称数据
            'collect_product_list_data' => $collect_product_name_list_data, // 所有终端商品名称数据

            'collect_b_product_spc_count' => $collect_b_product_count, // B端品规数量
            'collect_c_product_spc_count' => $collect_c_product_count, // C端品规数量
            'collect_oto_product_spc_count' => 0, // OTO品规数量
            'collect_totle_product_spc_count' => $collect_totle_product_count, // 所有终端品规数量
            'collect_c_product_spc_data' => $collect_c_product_list, // C端品规数据
            'collect_b_product_spc_data' => $collect_b_product_list, // B端品规数据
            'collect_product_spc_list_data' => $collect_product_list_data, // 所有终端品规数据
        ];
        return $result_data;
    }


    /**
     * 禁止挂网商品数统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_violation_product_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_product_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        $limit = request('limit', config('page_num', 10));
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        $violationProductModel = $violationProductModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        $result = $violationProductModel->where($map)->where('status', 0)
            ->select(['product_name', DB::raw('count(product_name) as count')])->distinct('product_name')->orderby('count', 'desc')
            ->groupby('product_name')->paginate($limit);
        return  json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
    }

    /**
     * 禁止挂网省份统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_violation_province_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_province_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网省份统计
        $violationProductModel = $violationProductModel->where([['province_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        try {
            // 假设 ViolationProductModel 中有 province 字段，表示省份信息
            // 查询指定时间范围内的数据，并按 province 分组统计数量
            $result = $violationProductModel->where($map)->where('status', 0)
                ->select(['province_name', DB::raw('count(province_name) as count')])
                ->groupby('province_name')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $province_totle_count = 0;
            if (!empty($result)) {
                $province_totle_count = array_sum(array_column($result, 'count'));
                //计算占比
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $province_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 禁止挂网城市统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_violation_city_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_city_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $province_id = request('province_id', ''); //省份ID
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        if ($province_id) $map[] = ['province_id', '=', $province_id];
        // 禁止挂网城市统计
        $violationProductModel = $violationProductModel->where([['city_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        try {
            // 假设 ViolationProductModel 中有 city 字段，表示城市信息
            // 查询指定时间范围内的数据，并按 city 分组统计数量
            $result = $violationProductModel->where($map)->where('status', 0)
                ->select(['city_name', DB::raw('count(city_name) as count')])
                ->groupby('city_name')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $city_totle_count = 0;
            if (!empty($result)) {
                $city_totle_count = array_sum(array_column($result, 'count'));
                //计算占比
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $city_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }





    /**
     * 禁止挂网公司数统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_violation_company_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_company_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $limit = request('limit', config('page_num', 10));
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        $violationProductModel = $violationProductModel->where([['company_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        $result = $violationProductModel->where($map)->where('status', 0)
            ->select(['company_name', DB::raw('count(company_name) as count')])->groupby('company_name')->orderby('count', 'desc')
            ->paginate($limit);
        return  json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
    }



    /*
     * 低价违规商品数统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_low_price_product_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_product_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $limit = request('limit', config('page_num', 10));
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        $LowPriceGoodsModel = $LowPriceGoodsModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        $result = $LowPriceGoodsModel->where($map)->where('status', 0)
            ->select(['product_name', DB::raw('count(product_name) as count')])->distinct('product_name')->orderby('count', 'desc')
            ->groupby('product_name')->paginate($limit);
        return  json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
    }

    /*
     * 低价违规公司数统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_low_price_company_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_company_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $limit = request('limit', config('page_num', 10));
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        $LowPriceGoodsModel = $LowPriceGoodsModel->where([['company_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        $map[] = ['company_name', '!=', ''];
        $result = $LowPriceGoodsModel->where($map)->where('status', 0)
            ->select(['company_name', DB::raw('count(company_name) as count')])->groupby('company_name')->orderby('count', 'desc')
            ->paginate($limit);
        return  json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
    }

    /**
     * 低价挂网省份统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_low_price_province_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_province_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网省份统计
        $LowPriceGoodsModel = $LowPriceGoodsModel->where([['province_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        try {
            // 假设 LowPriceGoodsModel 中有 province 字段，表示省份信息
            // 查询指定时间范围内的数据，并按 province 分组统计数量
            $result = $LowPriceGoodsModel->where($map)->where('status', 0)
                ->select(['province_name', DB::raw('count(province_name) as count')])
                ->groupby('province_name')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $province_totle_count = 0;
            if (!empty($result)) {
                $province_totle_count = array_sum(array_column($result, 'count'));
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $province_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 低价挂网城市统计
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-10
     * 
     */
    public function get_low_price_city_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_city_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否

        //终端类型B端、C端、OTO
        $province_id = request('province_id', ''); //省份id
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        if ($province_id) $map[] = ['province_id', '=', $province_id];
        // 禁止挂网城市统计
        $LowPriceGoodsModel = $LowPriceGoodsModel->where([['city_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        try {
            // 假设 LowPriceGoodsModel 中有 city 字段，表示城市信息
            // 查询指定时间范围内的数据，并按 city 分组统计数量
            $result = $LowPriceGoodsModel->where($map)->where('status', 0)
                ->select(['city_name', DB::raw('count(city_name) as count')])
                ->groupby('city_name')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $city_totle_count = 0;
            if (!empty($result)) {
                $city_totle_count = array_sum(array_column($result, 'count'));
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $city_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 低价挂网平台分布
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-27
     * 
     */
    public function get_low_price_platform_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_platform_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网平台分布统计
        $LowPriceGoodsModel = $LowPriceGoodsModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        try {
            // 假设 LowPriceGoodsModel 中有 platform 字段，表示平台信息
            // 查询指定时间范围内的数据，并按 platform 分组统计数量
            $result = $LowPriceGoodsModel->where($map)->where('status', 0)
                ->select(['platform', DB::raw('count(platform) as count')])
                ->groupby('platform')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $platform_totle_count = 0;
            if (!empty($result)) {
                $platform_totle_count = array_sum(array_column($result, 'count'));
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $platform_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }
    /**
     * 低价挂网平台省份分布
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-27
     * 
     */
    public function get_low_price_platform_province_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_platform_province_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网平台分布统计
        $LowPriceGoodsModel = $LowPriceGoodsModel->where([['province_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        try {
            // 假设 LowPriceGoodsModel 中有 province 字段，表示省份信息
            // 查询指定时间范围内的数据，并按 province 分组统计数量
            $result = $LowPriceGoodsModel->where($map)->where('status', 0)
                ->select(['province_name', DB::raw('count(province_name) as count')])
                ->groupby('province_name')
                ->orderby('count', 'desc')
                ->get();
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }



    /**
     * 禁止挂网平台分布
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-27
     * 
     */
    public function get_violation_platform_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_platform_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网平台分布统计
        $violationProductModel = $violationProductModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        try {
            // 假设 ViolationProductModel 中有 platform 字段，表示平台信息
            // 查询指定时间范围内的数据，并按 platform 分组统计数量
            $result = $violationProductModel->where($map)->where('status', 0)
                ->select(['platform', DB::raw('count(platform) as count')])
                ->groupby('platform')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $platform_totle_count = 0;
            if (!empty($result)) {
                $platform_totle_count = array_sum(array_column($result, 'count'));
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $platform_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 禁止挂网平台省份分布
     * @author 唐远望
     * @version   1.0
     * @date      2026-02-27
     * 
     */
    public function get_violation_platform_province_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_platform_province_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网平台分布统计
        $violationProductModel = $violationProductModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        try {
            // 假设 ViolationProductModel 中有 platform 字段，表示平台信息
            // 查询指定时间范围内的数据，并按 platform 分组统计数量
            $result = $violationProductModel->where($map)->where('status', 0)
                ->select(['province_name', DB::raw('count(province_name) as count')])
                ->groupby(['province_name'])
                ->orderby('count', 'desc')
                ->get();
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 违规公司平台占比
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-23
     * 
     */
    public function get_violation_company_platform_proportion(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_company_platform_proportion')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        // 禁止挂网平台分布统计
        $violationProductModel = $violationProductModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        try {
            // 假设 LowPriceGoodsModel 中有 platform 字段，表示平台信息
            // 查询指定时间范围内的数据，并按 platform 分组统计数量
            $result = $violationProductModel->where($map)->where('status', 0)
                ->select(['platform', DB::raw('count(platform) as count')])
                ->distinct('company_name')
                ->groupby('platform')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $platform_totle_count = 0;
            if (!empty($result)) {
                $platform_totle_count = array_sum(array_column($result, 'count'));
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $platform_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 违规店铺平台占比
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-23
     * 
     */
    public function get_violation_store_platform_proportion(request $request, ViolationStoreModel $ViolationStoreModel)
    {
        $request->scene('get_violation_store_platform_proportion')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        // 禁止挂网平台分布统计
        $ViolationStoreModel = $ViolationStoreModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $ViolationStoreModel = $ViolationStoreModel->whereIn('platform', $platform);
        }
        try {
            // 假设 LowPriceGoodsModel 中有 platform 字段，表示平台信息
            // 查询指定时间范围内的数据，并按 platform 分组统计数量
            $result = $ViolationStoreModel->where($map)->where('status', 0)
                ->select(['platform', DB::raw('count(platform) as count')])
                ->groupby('platform')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $platform_totle_count = 0;
            if (!empty($result)) {
                $platform_totle_count = array_sum(array_column($result, 'count'));
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $platform_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 违规店铺平台省份分布
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-23
     * 
     */
    public function get_violation_store_province_count(request $request, ViolationStoreModel $ViolationStoreModel)
    {
        $request->scene('get_violation_store_province_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        // 违规公司平台分布统计
        $ViolationStoreModel = $ViolationStoreModel->where([['province_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $ViolationStoreModel = $ViolationStoreModel->whereIn('platform', $platform);
        }
        try {
            // 假设 $violationProductModel 中有 province 字段，表示省份信息
            // 查询指定时间范围内的数据，并按 province 分组统计数量
            $result = $ViolationStoreModel->where($map)->where('status', 0)
                ->select(['province_name', DB::raw('count(province_name) as count')])
                ->groupby('province_name')
                ->orderby('count', 'desc')
                ->get();
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 违规店铺省份统计占比
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-23
     * 
     */
    public function get_violation_store_province_proportion(request $request, ViolationStoreModel $ViolationStoreModel)
    {
        $request->scene('get_violation_store_province_proportion')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        // 违规店铺省份统计
        $ViolationStoreModel = $ViolationStoreModel->where([['province_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $ViolationStoreModel = $ViolationStoreModel->whereIn('platform', $platform);
        }
        try {
            // 假设 $ViolationStoreModel 中有 province 字段，表示省份信息
            // 查询指定时间范围内的数据，并按 province 分组统计数量
            $result = $ViolationStoreModel->where($map)->where('status', 0)
                ->select(['province_name', DB::raw('count(province_name) as count')])
                ->groupby('province_name')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $province_totle_count = 0;
            if (!empty($result)) {
                $province_totle_count = array_sum(array_column($result, 'count'));
                //计算占比
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $province_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }

    /**
     * 违规店铺城市统计占比
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-23
     * 
     */
    public function get_violation_store_city_proportion(request $request, ViolationStoreModel $ViolationStoreModel)
    {
        $request->scene('get_violation_store_city_proportion')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $province_id = request('province_id', ''); //省份id
        $terminal_type = request('terminal_type', '');
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        if ($province_id) $map[] = ['province_id', '=', $province_id];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }

        // 违规店铺省份统计
        $ViolationStoreModel = $ViolationStoreModel->where([['city_name','!=','']]);
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $ViolationStoreModel = $ViolationStoreModel->whereIn('platform', $platform);
        }
        try {
            // 假设 $ViolationStoreModel 中有 province 字段，表示省份信息
            // 查询指定时间范围内的数据，并按 province 分组统计数量
            $result = $ViolationStoreModel->where($map)->where('status', 0)
                ->select(['city_name', DB::raw('count(city_name) as count')])
                ->distinct('company_name')
                ->groupby('city_name')
                ->orderby('count', 'desc')
                ->get()->toArray();
            $province_totle_count = 0;
            if (!empty($result)) {
                $province_totle_count = array_sum(array_column($result, 'count'));
                //计算占比
                foreach ($result as $key => $value) {
                    $result[$key]['percent'] = round(($value['count'] / $province_totle_count) * 100, 2);
                }
            }
            return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
        } catch (\Exception $e) {
            return json_send(['code' => 'error', 'msg' => '获取失败：' . $e->getMessage()]);
        }
    }


    /*
     * 低价挂网商品规格数统计排行
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-24
     * 
     */
    public function get_low_price_product_spec_count(request $request, LowPriceGoodsModel $LowPriceGoodsModel)
    {
        $request->scene('get_low_price_product_spec_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $limit = request('limit', config('page_num', 10));
        $product_name = request('product_name', ''); //商品名称
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        $LowPriceGoodsModel = $LowPriceGoodsModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $LowPriceGoodsModel = $LowPriceGoodsModel->whereIn('platform', $platform);
        }
        $result = $LowPriceGoodsModel->where($map)->where('status', 0)
            ->select(['product_name', 'product_specs', DB::raw('count(*) as count')])
            ->groupby('product_name', 'product_specs')
            ->orderby('count', 'desc')
            ->paginate($limit);
        return  json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
    }

    /**
     * 禁止挂网商品规格数统计排行
     * @author 唐远望
     * @version   1.0
     * @date      2026-03-24
     * 
     */
    public function get_violation_product_spec_count(request $request, ViolationProductModel $violationProductModel)
    {
        $request->scene('get_violation_product_spec_count')->validate();
        $admin_company_id = request('admin_company_id', '0');
        $company_id = request('access_token.company_id', '0');

        //终端类型B端、C端、OTO
        $terminal_type = request('terminal_type', '');
        $product_name = request('product_name', ''); //商品名称
        $is_admin = request('access_token.is_admin', '0'); //是否管理员操作 0=是1=否
        $limit = request('limit', config('page_num', 10));
        $yesterdayStart = Carbon::yesterday()->startOfDay()->getTimestamp(); // 昨天开始时间 00:00:00
        $yesterdayEnd = Carbon::yesterday()->endOfDay()->getTimestamp(); // 昨天结束时间 23:59:59
        $start_time_string = request('start_time', '');
        $end_time_string = request('end_time', '');
        $start_time = $start_time_string ? strtotime($start_time_string . ' 00:00:00') : $yesterdayStart;
        $end_time = $end_time_string ? strtotime($end_time_string . ' 23:59:59') : $yesterdayEnd;
        $todayStart = Carbon::today()->startOfDay()->getTimestamp(); // 今天开始时间 00:00:00
        // if ($start_time > $todayStart || $end_time > $todayStart) return  json_send(['code' => 'error', 'msg' => '不支持查询今天或以后时间', 'data' => '']);
        // 时间条件
        $map  = [];
        if ($start_time) $map[] = ['insert_time', '>=', $start_time];
        if ($end_time) $map[]   = ['insert_time', '<=', $end_time];
        // 权限判断
        if ($is_admin != 1 && $company_id != 0) {
            $map[] = ['company_id', '=', $company_id];
        } else {
            $map[] = ['company_id', '=', $admin_company_id];
        }
        if ($product_name) $map[] = ['product_name', 'like', '%' . $product_name . '%'];
        $violationProductModel = $violationProductModel->query();
        if ($terminal_type) {
            $platform = [];
            switch ($terminal_type) {
                case '1': //B端：药师帮、1药城、药九九、药易购、药帮忙、熊猫药药
                    $platform = ['0', '5', '6', '7', '8', '9', '10']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '2': //C端：美团、拼多多、天猫、京东、药房网
                    $platform = ['0', '1', '2', '3', '4', '11']; //1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药九九,8=药易购，9=药帮忙，10=熊猫药药11=药房网
                    break;
                case '3': //OTO：美团买药、淘宝闪送、京东秒送
                    $platform = ['0'];
                    break;
                default:
                    # code...
                    break;
            }
            $violationProductModel = $violationProductModel->whereIn('platform', $platform);
        }
        $result = $violationProductModel->where($map)->where('status', 0)
            ->select(['product_name', 'product_specs', DB::raw('count(*) as count')])
            ->groupby('product_name', 'product_specs')
            ->orderby('count', 'desc')
            ->paginate($limit);
        return  json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
    }
}