public function importAction() { $type = $this->_getParam('type', 1); $this->view->type = $type; $adapter = new Zend_File_Transfer_Adapter_Http(); $wrdir = Yy_Utils::getWriteDir(); $adapter->setDestination($wrdir); if (!$adapter->receive()) { $messages = $adapter->getMessages(); //echo implode("\n", $messages); } //echo APPLICATION_PATH;exit; $filename = $adapter->getFileName(); if (is_string($filename)) { //上传文件后的处理 require_once APPLICATION_PATH . '/../library/Yy/Excel/PHPExcel/IOFactory.php'; if (PHP_OS == 'WINNT') { $filename = iconv('UTF-8', 'gb2312', $filename); } $inputFileType = PHPExcel_IOFactory::identify($filename); if (stristr($inputFileType, 'excel') || stristr($inputFileType, 'csv')) { $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($filename); $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); array_shift($sheetData); if (count($sheetData) > 0) { $travels = array(); foreach ($sheetData as $record) { $travel = new Application_Model_O_Travel(); $travel->setType($type); if ($record['A'] == '国内') { $ltype = 1; } elseif ($record['A'] == '国外') { $ltype = 2; } else { continue; } $travel->setLocation_type($ltype); $travel->setAdult_oprice($record['B'])->setAdult_dprice($record['C'])->setChild_oprice($record['D'])->setChild_dprice($record['E'])->setArea($record['F'])->setTitle($record['G'])->setSubtitle($record['H']); if ($record['I'] == '正常') { $status = 1; } elseif ($record['I'] == '禁用') { $status = 0; } else { continue; } $travel->setStatus($status); try { $travel->setCtime(date('Y-m-d H:i:s')); $travel->save(); array_push($travels, $travel); $this->view->travels = $travels; } catch (Zend_Db_Exception $e) { } } } } else { echo "<script type='text/javascript'>alert('请上传正确的文件类型')</script>"; } } }