drb/app/Service/ExportFileService.php

<?php

namespace App\Service;

use App\Exports\ExportOrder;
use App\Model\Freight;
use App\Model\Product;
use Illuminate\Support\Facades\DB;
use Maatwebsite\Excel\Facades\Excel;

class ExportFileService extends Service
{
    //导出文件
    const type_one = 1;
    const type_two = 2;
    const type_three = 3;
    const type_four = 4;
    const type_five = 5;
    const type_six = 6;
    const type_seven = 7;
    const type_eight = 8;
    const type_nine = 9;
    const type_ten = 10;
    const type_eve = 11;
    const type_twl = 12;

    //导出文件方法
    protected static $fuc = [
        self::type_one => 'one',
        self::type_two => 'two',
        self::type_three => 'three',
        self::type_four => 'four',
        self::type_five => 'five',
        self::type_six => 'six',
        self::type_seven => 'seven',
        self::type_eight => 'eight',
        self::type_nine => 'nine',
        self::type_ten => 'ten',
        self::type_eve => 'eve',
        self::type_twl => 'twl',
    ];

    protected static $fuc_name = [
        self::type_one => '存货',
        self::type_two => '运费设置',
        self::type_three => '收付款单',
        self::type_four => '施工单',
        self::type_five => '采购单',
        self::type_six => '退换货单',
        self::type_seven => '发货单',
        self::type_eight => '进销存报表',
        self::type_nine => '虚拟采购单',
        self::type_ten => '客户',
        self::type_eve => '现存量',
        self::type_twl => '库存台账',
    ];

    public static $filename = "";

    //导出的方式 0 选择导出的数据 1 查询后 导出指定的数据（最多每次一千条）
    public static $export_type = [
        0,
        1
    ];

    public function exportAll($data,$user){
        if(empty($data['type']) || ! isset(self::$fuc[$data['type']])) return [false,'导出文件类型错误或者不存在'];
        self::$filename = self::$fuc_name[$data['type']] ?? "";

        $export_type = $data['export_type'] ?? 0;
        if(! isset(self::$export_type[$export_type])) return [false,'导出文件方式错误或者不存在'];
        if(empty($export_type)){
            if(empty($data['id'])) return [false,'请选择导出数据'];
        }else{
            if(empty($data['order_search'])) return [false,'搜索条件不能为空'];
            $search = $data['order_search'];
            if(empty($search['page_index'])) return [false,'请选择导出数据的开始页码'];
            if(empty($search['page_size'])) return [false,'请选择导出数据的条数'];
            if($search['page_size'] > 5000) return [false,'请选择导出数据的条数每次最多5000条'];
            $id = $this->getListForSearch($data, $user);
            $data['id'] = $id;
        }

        $function = self::$fuc[$data['type']];
        $return = $this->$function($data,$user);

        return [true, $return];
    }

    public function one($ergs,$user){
        $id = $ergs['id'];

        // 导出数据
        $return = [];

        DB::table('product')
            ->whereIn('id', $id)
            ->select(Product::$field)
            ->orderBy('id','desc')
            ->chunkById(500,function ($data) use(&$return){
                $data = Collect($data)->map(function ($object) {
                    return (array)$object;
                })->toArray();

                foreach ($data as $value) {
                    $return[] = [
                        0 => $value['code'],
                        1 => $value['title'],
                        2 => $value['size'],
                        3 => $value['category'],
                        4 => $value['unit'],
                        5 => $value['cost'],
                        6 => $value['business_cost'],
                        7 => $value['major_client_settlement_price'],
                        8 => $value['write_off_price'],
                        9 => $value['return_change_price'],
                        10 => $value['freight_price'],
                        11 => $value['mark'],
                    ];
                }
            });

        $header = ['存货编码','存货名称','规格类型','所属类别','计量单位','成本单价','业务成本单价','大客户结算单价','核销单价','退换货损耗单价','运费单价','备注'];

        return $this->saveExportData($return,$header);
    }

    public function two($ergs,$user){
        $id = $ergs['id'];

        // 导出数据
        $return = [];

        DB::table('freight')
            ->whereIn('id', $id)
            ->select(Freight::$field)
            ->orderBy('id','desc')
            ->chunkById(500,function ($data) use(&$return){
                $data = Collect($data)->map(function ($object) {
                    return (array)$object;
                })->toArray();

                foreach ($data as $value) {
                    $return[] = [
                        0 => $value['area'],
                        1 => $value['region'],
                        2 => $value['kilometer'],
                        3 => $value['min_freight_fee'],
                        4 => $value['one_and_five'],
                        5 => $value['greater_than_five'],
                        6 => $value['company'],
                    ];
                }
            });

        $header = ['所属区域','地区','公里数','最低运费','1-5吨','5吨以上','物流公司'];

        return $this->saveExportData($return,$header);
    }

    public function getListForSearch($ergs, $user){
        $data = $ergs['order_search'];
        $id = [];
        if($ergs['type'] == self::type_one){
            $service = new ProductService();
            $model = $service->productCommon($data, $user, ['id']);
            $return = $this->limitData($model,'',$data);
            $id = array_column($return,'id');
        }elseif ($ergs['type'] == self::type_two){
            $service = new FreightService();
            $model = $service->freightCommon($data, $user, ['id']);
            $return = $this->limitData($model,'',$data);
            $id = array_column($return,'id');
        }

        return $id;
    }

    public function saveExportData($data, $headers, $type = 'default',$file_name = ''){
        if(empty($file_name)) $file_name = self::$filename . "_". date("Y-m-d") . "_". rand(1000,9999);
        $filename =  $file_name . '.' . 'xlsx';
        $bool = Excel::store(new ExportOrder($data,$type,$headers),"/public/export/{$filename}", null, 'Xlsx', []);
        return $filename;
    }
}