TP6之批量导入2

<?php

declare(strict_types=1);

namespace app\api\controller\console;

use app\api\model\Orepipe as OrepipeModel;
use PhpOffice\PhpSpreadsheet\IOFactory;


use think\Request;


class Orepipe
{
    /**
     * 批量导入
     * @param Request $request
     * @param Orepipe $Orepipe
     * @return \think\Response
     */
    public function importPost(Request $request, OrepipeModel $OrepipeModel)
    {
        $file = $request->file();

        validate([
            'file' => 'require|file|fileExt:xlsx',
        ])->check($file);

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

        $objRead = IOFactory::createReader('Xlsx');
        $objRead->setReadDataOnly(true);    //则只读内容，提升读取Excel效率
        $obj = $objRead->load(config('filesystem.disks.local.root') . '/' . $path); //建立excel对象

        if($obj)
        {
            $sheetContent = $obj->getSheet(0)->toArray(); //获取指定的sheet表
            unset($sheetContent[0]);

            $data = [];
            $i = 0;
            //读取内容
            foreach($sheetContent as $k => $v)
            {
                $data[$k]['number'] = $v[1];
                $data[$k]['name'] = $v[3];
                $data[$k]['address'] = $v[4];
                $data[$k]['title'] = $v[5];
                $data[$k]['product_scale'] = $v[9];
                $data[$k]['mining_area'] = $v[10];
                $data[$k]['coordinate'] = '';
                $i++;
            }  
            $info =  $OrepipeModel->saveAll($data);
            if( $info )
            {
                return JsonSuccess('导入成功');
            }else{
                return JsonError('导入失败');
            }
        }else{
            return JsonError('请上传表格');
        }
    }
    /**
     * 下载模板表格
     * @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);
    }
}