beauti-nof/application/common/service/MobileExport.php

<?php
namespace app\common\service;

use app\admin\model\Admin;
use app\common\library\MobileConstant;
use app\common\model\Mobile;
use app\common\model\MobileInfo;
use app\common\model\MobileOrder;
use app\common\model\MobileSub;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class MobileExport{
    public static function export($list,$export){
        $admin=Admin::get($export['admin_id']);
        $excel=new Spreadsheet();
        $header=[
            [
                'name'=>'ID',
                'value'=>function($model){
                    return $model['id'];
                },
            ],
            [
                'name'=>'手机号',
                'value'=>function($model){
                    return $model['no'];
                },
            ],
            [
                'name'=>'省份',
                'value'=>function($model){
                    return $model['province'];
                },
            ],
            [
                'name'=>'归属地',
                'value'=>function($model){
                    return $model['city'];
                },
            ],
            [
                'name'=>'运营商',
                'value'=>function($model){
                    return $model['network'];
                },
            ],
            [
                'name'=>'供应商',
                'value'=>function($model){
                    return Admin::where('id',$model['proxy_id'])->value('nickname');
                },
                'hidden'=>!$admin['is_manager']
            ],
            [
                'name'=>'卡品牌',
                'value'=>function($model){
                    return $model['brand'];
                },
            ],
            [
                'name'=>'规律',
                'value'=>function($row){
                    $rules=[];
                    foreach (MobileConstant::getFilters() as $rule=>$field){
                        foreach (array_values($field) as $column){
                            if($row[$column]==1){
                                $rules[]=$rule;
                            }
                        }
                    }
                    $rules=array_values(array_unique($rules));
                    return implode(",",$rules);
                },
            ],
            [
                'name'=>'套餐信息',
                'value'=>function($model){
                    return MobileInfo::where('mobile_id',$model['id'])->value('describe');
                },
            ],
            [
                'name'=>'原价',
                'value'=>function($model){
                    return $model['amount_original'];
                },
            ],
            [
                'name'=>'底价',
                'value'=>function($model){
                    return $model['amount_di'];
                },
            ],
            [
                'name'=>'代理价',
                'value'=>function($model){
                    return $model['amount_proxy'];
                },
                'hidden'=>!$admin['is_manager']
            ],
            [
                'name'=>'售价',
                'value'=>function($model){
                    return $model['amount_base'];
                },
            ],
            [
                'name'=>'秒杀价',
                'value'=>function($model){
                    return $model['amount_kill'];
                },
            ],
            [
                'name'=>'预存话费',
                'value'=>function($model){
                    return $model['amount_charge'];
                },
            ],
            [
                'name'=>'备注',
                'value'=>function($model){
                    return $model['remark'];
                },
            ],
            [
                'name'=>'置顶',
                'value'=>function($model)use($admin){
                    if($admin['is_manager']){
                        return $model['top_time']?'是':'否';
                    }else{
                        return MobileSub::where('sub_admin_id',$admin['id'])->where('mobile_id',$model['id'])->value('sub_top_time')?'是':'否';
                    }
                },
            ],
            [
                'name'=>'推荐',
                'value'=>function($model)use($admin){
                    if($admin['is_manager']){
                        return $model['rec_time']?'是':'否';
                    }else{
                        return MobileSub::where('sub_admin_id',$admin['id'])->where('mobile_id',$model['id'])->value('sub_rec_time')?'是':'否';
                    }
                },
            ],
            [
                'name'=>'号码状态',
                'value'=>function($model)use($admin){
                    $status=Mobile::beautiStatus();
                    return $status[$model['status']];
                },
            ],
            [
                'name'=>'更新时间',
                'value'=>function($model){
                    return date('Y-m-d H:i:s',$model['update_time']);
                },
            ],
            [
                'name'=>'上架时间',
                'value'=>function($model){
                    return date('Y-m-d H:i:s',$model['create_time']);
                },
            ],
            [
                'name'=>'排序',
                'value'=>function($model){
                    return $model['sort'];
                },
            ],
            [
                'name'=>'预占通道',
                'value'=>function($model){
                    return $model['hold_chan'];
                },
            ],
            [
                'name'=>'预占用户ID',
                'value'=>function($model){
                    return $model['hold_user'];
                },
            ],
            [
                'name'=>'上传用户',
                'value'=>function($model){
                    return $model['admin_id'];
                },
            ],
        ];
        $headers=[];
        $sheet=$excel->getActiveSheet();
        $headerPoint='A';
        foreach ($header as $value){
            if(is_callable($value['value']) && self::visible($value)){
                $headers[]=$value;
                $sheet->setCellValue(sprintf("%s%d",$headerPoint,1),$value['name']);
                $headerPoint++;
            }
        }
        unset($header);

        $y=2;
        foreach ($list as $key=>$value){
            $x='A';
            if(IS_CLI){
                echo "{$y}".PHP_EOL;
            }
            foreach ($headers as $_key=>$_value){
                $val=$_value['value']($value);
                $sheet->setCellValue(sprintf("%s%d", $x, $y), $val);
                $x++;
            }
            $y++;
            unset($list[$key]);
        }
        unset($list);

        $sheet->getColumnDimension('A')->setAutoSize(true);
        $xlsx=new Xlsx($excel);
        $export['filename']=sprintf('/uploads/mobile_export/%s',session_create_id(date('Ymd-')).'.xlsx');
        $filePath=ROOT_PATH.'/public'.$export['filename'];
        $dir=str_replace(basename($filePath),'',$filePath);
        if(!is_dir($dir)){
            mkdir($dir,0777,true);
        }
        $xlsx->save($filePath);
        $export['status']=2;
        $export->save();
    }

    protected static function visible($item){
        return empty($item['hidden']) || !$item['hidden'];
    }
}