beauti-nof/application/common/service/MobileExportCsv.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 MobileExportCsv{
    public static function export1($list,$export){
        $admin=Admin::get($export['admin_id']);
        $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'];
                },
            ],
        ];

        $export['filename']=sprintf('/uploads/mobile_export/%s',session_create_id(date('Ymd-')).'.csv');
        $filePath=ROOT_PATH.'/public'.$export['filename'];
        $dir=str_replace(basename($filePath),'',$filePath);
        if(!is_dir($dir)){
            mkdir($dir,0777,true);
        }
        $csvFile=fopen($filePath,'w+');

        $headers=[];
        foreach ($header as $value){
            if(is_callable($value['value']) && self::visible($value)){
                $headers[]=$value;
            }
        }
        unset($header);
        mb_convert_variables('GBK','UTF-8',$headers);

        fputcsv($csvFile,array_column($headers,'name'));
        foreach ($list as $key=>$mobile){
            $mobileData=[];
            foreach ($headers as $header){
                $mobileData[]=$header['value']($mobile);
            }
            echo $key.PHP_EOL;
            mb_convert_variables('gbk','utf-8',$mobileData);
            fputcsv($csvFile,$mobileData);
        }
        fclose($csvFile);

        $export['status']=2;
        $export->save();
    }
    public static function export($list,$export){
        $admin=Admin::get($export['admin_id']);
        $header=[
            [
                'name'=>'手机号',
                'value'=>function($model){
                    return $model['no'];
                },
            ],
            [
                'name'=>"省份\n（自动识别）",
                'value'=>function($model){
                    return '';
                },
            ],
            [
                'name'=>'归属地',
                'value'=>function($model){
                    return $model['city'];
                },
            ],
            [
                'name'=>'运营商',
                'value'=>function($model){
                    return $model['network'];
                },
            ],
            [
                'name'=>'卡品牌',
                'value'=>function($model){
                    return $model['brand'];
                },
            ],
            [
                'name'=>"规律\n（自动识别）",
                'value'=>function($row){
                    return '';
                },
            ],
            [
                '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_base'];
                },
            ],
            [
                'name'=>'预存话费',
                'value'=>function($model){
                    return $model['amount_charge'];
                },
            ],
            [
                'name'=>"备注\n(全部可见)",
                'value'=>function($model){
                    return $model['remark'];
                },
            ],
            [
                'name'=>'号码状态',
                'value'=>function($model)use($admin){
                    $status=Mobile::beautiStatus();
                    return $status[$model['status']];
                },
            ],
            [
                'name'=>'代理价',
                'value'=>function($model){
                    return $model['amount_proxy'];
                },
            ],
            [
                'name'=>'供应商',
                'value'=>function($model){
                    return $model['proxy']['nickname'];
                },
            ],
            [
                'name'=>'供应商电话',
                'value'=>function($model){
                    return $model['proxy']['phone'];
                },
            ],
            [
                'name'=>'批号',
                'value'=>function($model){
                    return $model['batch_no'];
                },
            ],
            [
                'name'=>"备注\n(仅我可见)",
                'value'=>function($model){
                    return $model['remark_me'];
                },
            ]
        ];

        $export['filename']=sprintf('/uploads/mobile_export/%s',session_create_id(date('Ymd-')).'.csv');
        $filePath=ROOT_PATH.'/public'.$export['filename'];
        $dir=str_replace(basename($filePath),'',$filePath);
        if(!is_dir($dir)){
            mkdir($dir,0777,true);
        }
        $csvFile=fopen($filePath,'w+');

        $headers=[];
        foreach ($header as $value){
            if(is_callable($value['value']) && self::visible($value)){
                $headers[]=$value;
            }
        }
        unset($header);
        mb_convert_variables('GBK','UTF-8',$headers);

        fputcsv($csvFile,array_column($headers,'name'));
        foreach ($list as $key=>$mobile){
            $mobile['proxy']=Admin::find($mobile['proxy_id']);
            $mobileData=[];
            foreach ($headers as $header){
                $mobileData[]=$header['value']($mobile);
            }
            echo $key.PHP_EOL;
            mb_convert_variables('gbk','utf-8',$mobileData);
            fputcsv($csvFile,$mobileData);
        }
        fclose($csvFile);

        $export['status']=2;
        $export->save();
    }

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