drb/app/Service/RangeService.php

<?php

namespace App\Service;

use App\Model\ConstructionInfo;
use App\Model\CustomerInfo;
use App\Model\ProductRange;
use App\Model\ReturnExchangeOrderRange;
use App\Model\SalesOrderInfo;
use App\Model\SalesOrderRange;
use App\Model\SportsBagRange;
use App\Model\SupplierInfo;

class RangeService extends Service
{
    //获取客户可见数据
    public static function customerRange($user){
        $user_id = $user['id'];
        $depart_id = $user['depart_range'];
        $type = implode(',',CustomerInfo::$see_man);
        $type2 = CustomerInfo::type_eight;
        $depart_str = implode(',',$depart_id);
        $str = "(data_id = $user_id AND type IN({$type})) OR (data_id IN({$depart_str}) AND type = {$type2})";

        // 销售人员/负责人 3协同人  可见部门 可见人 可以看见
        $customer_id = CustomerInfo::where('del_time',0)
            ->where(function ($query) use($str) {
                $query->whereRaw($str);
            })->select('customer_id')->get()->toArray();
        return array_unique(array_column($customer_id,'customer_id'));
    }

    //获取供应商可见数据
    public static function supplierRange($user){
        $user_id = $user['id'];
        $depart_id = $user['depart_range'];
        $type = SupplierInfo::type_two;
        $type2 = SupplierInfo::type_one;
        $depart_str = implode(',',$depart_id);
        $str = "(data_id = $user_id AND type IN({$type})) OR (data_id IN({$depart_str}) AND type = {$type2})";

        // 可见部门 可见人 可以看见
        $supplier_id = SupplierInfo::where('del_time',0)
            ->where(function ($query) use($str) {
                $query->whereRaw($str);
            })->select('supplier_id')->get()->toArray();
        return array_unique(array_column($supplier_id,'supplier_id'));
    }

    //获取产品可见数据
    public static function productRange($user){
        $user_id = $user['id'];
        $depart_id = $user['depart_range'];
        $product_id = ProductRange::where('del_time',0)
            ->where(function ($query) use($user_id, $depart_id) {
                $query->where('employee_id',$user_id)
                    ->orWhereIn('depart_id', $depart_id);
            })->select('product_id')->get()
            ->toArray();
        return array_unique(array_column($product_id,'product_id'));
    }

    //获取合同可见数据
    public static function salesOrderRange($user){
        //单据中选择的签订负责协同人
        $sales_order_id = SalesOrderInfo::where('del_time',0)
            ->whereIn('type',SalesOrderInfo::$man)
            ->where('data_id',$user['id'])
            ->select('sales_order_id')
            ->get()->toArray();
        $sales_order_id = array_unique(array_column($sales_order_id,'sales_order_id'));
        //指派后
        $user_id = $user['id'];
        $depart_id = $user['depart_range'];
        $sales_order_id2 = SalesOrderRange::where('del_time',0)
            ->where(function ($query) use($user_id, $depart_id) {
                $query->where('employee_id',$user_id)
                    ->orWhereIn('depart_id', $depart_id);
            })->select('sales_order_id')->get()
            ->toArray();
        return array_unique(array_merge_recursive($sales_order_id,array_column($sales_order_id2,'sales_order_id')));
    }

    //获取施工单可见数据
    public static function constructionRange($user){
        //单据中选择的签订负责协同人
        $construction_id = ConstructionInfo::where('del_time',0)
            ->where('employee_id',$user['id'])
            ->select('construction_id')
            ->get()->toArray();
        return array_unique(array_column($construction_id,'construction_id'));
    }

    //获取退换货单可见数据
    public static function returnExchangeOrderRange($user){
        $user_id = $user['id'];
        $depart_id = $user['depart_range'];
        $return_exchange_id = ReturnExchangeOrderRange::where('del_time',0)
            ->where(function ($query) use($user_id, $depart_id) {
                $query->where('employee_id',$user_id)
                    ->orWhereIn('depart_id', $depart_id);
            })->select('return_exchange_id')->get()
            ->toArray();
        return array_unique(array_column($return_exchange_id,'return_exchange_id'));
    }

    //获取活动包可见数据
    public static function sportsBagRange($user){
        $user_id = $user['id'];
        $depart_id = $user['depart_range'];
        $return_exchange_id = SportsBagRange::where('del_time',0)
            ->where(function ($query) use($user_id, $depart_id) {
                $query->where('employee_id',$user_id)
                    ->orWhereIn('depart_id', $depart_id);
            })->select('sports_bag_id')->get()
            ->toArray();
        return array_unique(array_column($return_exchange_id,'sports_bag_id'));
    }
}