tp6之批量导入1

<?php


namespace appapicontrollerconsole;

use appapimodelMonitoringViolationType;
use PhpOfficePhpSpreadsheetIOFactory;
use thinkRequest;

class Violation
{

    /**
     * 批量导入
     * @param Request $request
     * @param MonitoringViolationType $MonitoringViolationType
     * @return 	hinkResponse
     */
    public function importPost(Request $request, MonitoringViolationType $MonitoringViolationType)
    {
        $file = $request->file();
        $type = $request->post('type/d', 1);
        validate([
            'file' => 'require|file|fileExt:xlsx',
        ])->check($file);

        $path = app('filesystem')->disk('local')->putFile('import', $file['file'], function(){
            return 'violation_'.time();
        });

        $objRead = IOFactory::createReader('Xlsx');
        $objRead->setReadDataOnly(true);    //则只读内容，提升读取Excel效率
        $obj = $objRead->load(config('filesystem.disks.local.root').'/'.$path); //建立excel对象
        $currSheet = $obj->getSheet(0); //获取指定的sheet表
        $rowCount = $currSheet->getHighestRow(); //获取总行数

        $data = [];
        //读取内容
        for ($row = 9; $row <= $rowCount; $row++) {
            //分类
            $data['A'] = $currSheet->getCell('A'.$row)->getValue();
            $data['B'] = $currSheet->getCell('B'.$row)->getValue();
            $data['C'] = $currSheet->getCell('C'.$row)->getValue();
            $data['D'] = $currSheet->getCell('D'.$row)->getValue();
            $data['E'] = $currSheet->getCell('E'.$row)->getValue();
            $data['F'] = $currSheet->getCell('F'.$row)->getValue();
            $data['G'] = $currSheet->getCell('G'.$row)->getValue();

            $pid = 0;
            foreach($data as $key => $val) {
                if (!empty($val)) {
                    $where = $pid == 0 ? ['name' => $val, 'type' => $type] : ['name' => $val, 'pid' => $pid, 'type' => $type];
                    $id = $MonitoringViolationType->where($where)->value('id', 0);
                    if (empty($id)) {
                        $pid = $MonitoringViolationType->insertGetId(['name' => $val, 'pid' => $pid, 'is_directly' => 0, 'type' => $type]);
                    } else {
                        $pid = $id;
                    }
                }
            }

            //内容
            $name = $currSheet->getCell('H'.$row)->getValue() ?? '';
            $remark = $currSheet->getCell('I'.$row)->getValue() ?? '';

            if (!empty($name)) {
                if (!$MonitoringViolationType->where(['name' => $name, 'pid' => $pid, 'type' => $type])->value('id')) {
                    $MonitoringViolationType->insert(['name' => $name, 'pid' => $pid, 'remark' => $remark, 'is_directly' => 0, 'type' => $type]);
                }
            }
        }

        app('filesystem')->disk('local')->delete($path);

        return JsonSuccess('导入成功');
    }

    /**
     * 下载模板表格
     * @return
     */
    public function tempGet()
    {
        $file = getcwd().'/storage/违法类型模块表格.xlsx';
        header('content-type:application/octet-stream');
        header('content-disposition:attachment; filename=' . basename($file));
        header('content-length:' . filesize($file));
        return file_get_contents($file);
       //return download(config('filesystem.disks.public.root').'/'.'违法类型模块表格.xlsx');
    }
}