workHour/app/Service/ExportFileService.php

<?php

namespace App\Service;

use App\Exports\ExportOrder;
use App\Exports\MultiSheetExport;
use Maatwebsite\Excel\Facades\Excel;

class ExportFileService extends Service
{
    public static $filename = "";

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

    public function exportAll($data,$user){
        if(empty($data['menu_id'])) return [false, 'menu_id不能为空'];
        if(empty($data['type'])) return [false, 'type不能为空'];
        $function = $data['type'];
        $name = $this->fillE($data['type'], $user);
        if (! method_exists(self::class, $function)) return [false, "导出方法不存在,请联系开发"];
        self::$filename = $name;

        $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,'请选择导出数据'];
            $search = $data;
        }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条'];
            $data['order_search']['menu_id'] = $data['menu_id'];
            $search = $data['order_search'];
        }

        list($status, $return) = $this->$function($search,$user);
        if(! $status) return [false, $return];

        return [true, $return];
    }

    public function fillE($type, &$user){
        $header = config("excel." . $type) ?? [];
        $funcName = $header['name'] ?? "";

//        $header_f = "extra_" . $menu_id;
//        $service = new TableHeadService();
//        if(method_exists($service,$header_f)) $service->$header_f($header_default);

        $user['e_header_default'] = $header['array'];

        return $funcName;
    }

    private function fillData($data, $column, &$return)
    {
        // 预先创建包含默认值的键数组
        $default = array_fill_keys($column, '');

        foreach ($data as $value) {
            // 提取交集，并用默认值补充缺失的键
            $return[] = array_merge($default, array_intersect_key($value, $default));
        }
    }

    private function fillTotalData($data, $column, &$return){
        $tmp = [];
        foreach ($column as $value){
            $key = $value['key'];
            if(! empty($value['sum']) && isset($data[$value['key']])){
                $decimals = $col['decimals'] ?? 2;
//                $tmp[$value['key']] = $data[$value['key']];

                // 用 number_format 格式化输出（保持字符串形式，避免科学计数）
                $tmp[$key] = number_format((float)$data[$key], $decimals, '.', '');
            }else{
                $tmp[$value['key']] = "";
            }
        }

        $return[] = $tmp;
    }

    public function depart($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new EmployeeService();
        $model = $service->departCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column, $user){
            $data = $data->toArray();
            $list['data'] = $data;

            //订单数据
            $list = $service->fillDepartList($list, $user, true);
            //返回数据
            $this->fillData($list['data'], $column, $return);
        });

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

    public function device($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new DeviceService();
        $model = $service->deviceCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column){
            $data = $data->toArray();
            $list['data'] = $data;

            //订单数据
            $list = $service->fillData($list);
            //返回数据
            $this->fillData($list['data'], $column, $return);
        });

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

    public function item($ergs,$user){
        // 导出数据
        $return = [];

        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new ItemService();
        $model = $service->itemCommon($ergs, $user);
        $model->chunk(500,function ($data) use(&$return,$column,$service){
            $data = $data->toArray();

            $list['data'] = $data;
            $list = $service->fillData($list, true);

            $this->fillData($list['data'], $column, $return);
        });

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

    public function fee($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new FeeService();
        $model = $service->feeCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column, $user){
            $data = $data->toArray();
            $list['data'] = $data;

            //订单数据
            $list = $service->fillFeeList($list, $user, true);
            //返回数据
            $this->fillData($list['data'], $column, $return);
        });

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

    public function monthPwOrder($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new PersonWorkService();
        $model = $service->monthlyPwOrderCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column){
            // 直接处理这一批主表数据，将其与详情合并平铺
            $service->fillDataForExport($data->toArray(), $column, $return);
        });

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

    public function monthDwOrder($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new DeviceWorkService();
        $model = $service->monthlyDwOrderCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column){
            // 直接处理这一批主表数据，将其与详情合并平铺
            $service->fillDataForExport($data->toArray(), $column, $return);
        });

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

    public function monthPsOrder($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new PersonSalaryService();
        $model = $service->monthlyPsOrderCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column){
            // 直接处理这一批主表数据，将其与详情合并平铺
            $service->fillDataForExport($data->toArray(), $column, $return);
        });

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

    public function monthDdOrder($ergs,$user){
        // 导出数据
        $return = [];
        $header_default = $user['e_header_default'];
        $column = array_column($header_default,'export');
        $header = array_column($header_default,'value');

        $service = new DeviceDepreciationService();
        $model = $service->monthlyDdOrderCommon($ergs, $user);

        $model->chunk(500,function ($data) use(&$return, $service, $column){
            // 直接处理这一批主表数据，将其与详情合并平铺
            $service->fillDataForExport($data->toArray(), $column, $return);
        });

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

    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;
    }

    public function saveExportData2($data,$type = 1,$column,$timeRow, $file_name = ''){
        if(empty($file_name)) $file_name = self::$filename . "_". date("Y-m-d") . "_". rand(1000,9999);
        $filename =  $file_name . '.' . 'xlsx';
        \Maatwebsite\Excel\Facades\Excel::store(new MultiSheetExport($data, $type,$column,$timeRow),"/public/export/{$filename}", null, 'Xlsx', []);

        return $filename;
    }
}