试题导入特殊字符处理-CRMEB社区

试题导入特殊字符处理

管理

编辑

删除

问题说明：导入中有些特殊字符被转成了对象，需要转成字符串

修改文件：application\admin\model\questions\Questions

修改方法：GetExcelData()

/**文件导入
     * @param string $filename
     * @param int $startLine
     * @param array $width
     * @return array
     * @throws \PHPExcel_Exception
     * @throws \PHPExcel_Reader_Exception
     */
    public static function GetExcelData($filename = '1.xlsx', $startLine = 4)
    {
        $width = [
            'question_type' => 'A',
            'pid' => 'B',
            'stem' => 'C',
            'image' => 'D',
            'is_img' => 'E',
            'a' => 'F',
            'b' => 'G',
            'c' => 'H',
            'd' => 'I',
            'e' => 'J',
            'f' => 'K',
            'answer' => 'L',
            'difficulty' => 'M',
            'analysis' => 'N',
            'sort' => 'O'
        ];
        $filename = ROOT_PATH . 'public' . $filename;
        $extension = strtolower(pathinfo($filename, PATHINFO_EXTENSION));
        switch ($extension) {
            case 'xlsx':
                $reader = IOFactory::createReader('Xlsx');
                $spreadsheet = $reader->load($filename);
                break;
            case 'xls':
                $reader = IOFactory::createReader('Xls');
                $spreadsheet = $reader->load($filename);
                break;
            case 'csv':
                $reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
                $reader->setInputEncoding('GBK');
                $reader->setDelimiter(',');
                $reader->setEnclosure('');
                $reader->setSheetIndex(0);
                $spreadsheet = $reader->load($filename);
                break;
        }
        $highestRow = $spreadsheet->getSheet(0)->getHighestRow(); // 取得总行数
        $getvalue = $spreadsheet->getActiveSheet();
        $data = [];
        for ($j = $startLine; $j <= (int)$highestRow; $j++) {
            $value = [];
            foreach ($width as $key => $val) {
                if ($v = $getvalue->getCell($val . $j)->getValue()) {
                    if(in_array($key,['stem','image','a','b','c','d','e','f','answer','analysis','relation'])){
                        $v = (string)$v;
                    }
                    $value[$key] = $v;
                } else {
                    $value[$key] = '';
                }
            }
            if ($value) $data[] = $value;
        }
        return $data;
    }