导入'csv', 'xls', 'xlsx'

$fileName= $_FILES['file']['name'];
        $filePath = $_FILES['file']['tmp_name'];
        $ext = pathinfo($fileName, PATHINFO_EXTENSION);
        if (!in_array($ext, ['csv', 'xls', 'xlsx'])) {
            $result['status'] = false;
            $result['msg'] = '导入文件格式错误';
            return $result;
        }
        if ($ext === 'csv') {
            $file = fopen($filePath, 'r');
            $filePath = tempnam(sys_get_temp_dir(), 'import_csv');
            $fp = fopen($filePath, "w");
            $n = 0;
            while ($line = fgets($file)) {
                $line = rtrim($line, "\n\r\0");
                $encoding = mb_detect_encoding($line, ['utf-8', 'gbk', 'latin1', 'big5']);
                if ($encoding != 'utf-8') {
                    $line = mb_convert_encoding($line, 'utf-8', $encoding);
                }
                if ($n == 0 || preg_match('/^".*"$/', $line)) {
                    fwrite($fp, $line . "\n");
                } else {
                    fwrite($fp, '"' . str_replace(['"', ','], ['""', '","'], $line) . "\"\n");
                }
                $n++;
            }
            fclose($file) || fclose($fp);
            $reader = new Csv();
        } elseif ($ext === 'xls') {
            $reader = new Xls();
        } else {
            $reader = new Xlsx();
        }
        $insert = [];
        try {
            if (!$PHPExcel = $reader->load($filePath)) {
                $result['status'] = false;
                $result['msg'] = '未知数据格式';
                return $result;
            }
            $currentSheet = $PHPExcel->getSheet(0);  //读取文件中的第一个工作表
            $allColumn = $currentSheet->getHighestDataColumn(); //取得最大的列号
            $allRow = $currentSheet->getHighestRow(); //取得一共有多少行
            $maxColumnNumber = Coordinate::columnIndexFromString($allColumn);
            $fields = [];
            for ($currentRow = 1; $currentRow <= 1; $currentRow++) {
                for ($currentColumn = 1; $currentColumn <= $maxColumnNumber; $currentColumn++) {
                    $val = $currentSheet->getCellByColumnAndRow($currentColumn, $currentRow)->getValue();
                    $fields[] = $val;
                }
            }
            $insert[] = $fields;
            for ($currentRow = 2; $currentRow <= $allRow; $currentRow++) {
                $values = [];
                for ($currentColumn = 1; $currentColumn <= $maxColumnNumber; $currentColumn++) {
                    $val = $currentSheet->getCellByColumnAndRow($currentColumn, $currentRow)->getValue();
                    $values[] = is_null($val) ? '' : $val;
                }
                $flag = false;
                foreach ($values as $v) {
                    if (!empty($v)) $flag = true;
                }
                if ($flag) $insert[] = $values;
            }
        } catch (\Exception $exception) {
            $this->error($exception->getMessage());
        }
//        print_r($insert);die;
        unset($insert[0],$insert[1]);
        if (!$insert) {
            $result['status'] = false;
            $result['msg'] = '未更新任何行';
            return $result;
        }
        $currencyModel = new Currency();
        //数据处理
        $tradeOrderList = [];
        foreach ($insert as $v){
            $list = [];
            $tradeOrderList[] = $list;
        }
        $count = count($tradeOrderList);
        $deciveNoCount = round($count/1000);
        for ($i = 0; $i <= $deciveNoCount; $i++) {
            $res[] = array_slice($tradeOrderList, $i * 1000, 1000);
        }
        $tradeOrderModel = new TradeOrder();
        foreach ($res as $key=>$val){
            if(empty($val)){
                continue;
            }
            $rest = $tradeOrderModel->insertAll($val);
        }
        $result['data'] = $rest;
        return $result;