public function importAction()
{
$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) {
$destinations = array();
foreach ($sheetData as $record) {
$destination = new Application_Model_O_Destination();
$destination->setCity($record['A']);
if ($record['B'] == '国内') {
$type = 1;
} elseif ($record['B'] == '国外') {
$type = 2;
} else {
continue;
}
$destination->setType($type);
$destination->setLongitude($record['C'])->setLatitude($record['D'])->setSort($record['E']);
if ($record['F'] == '正常') {
$status = 1;
} elseif ($record['F'] == '禁用') {
$status = 0;
} else {
continue;
}
$destination->setStatus($status);
try {
$destination->setCtime(date('Y-m-d H:i:s'));
$destination->save();
array_push($destinations, $destination);
$this->view->destinations = $destinations;
} catch (Zend_Db_Exception $e) {
}
}
}
} else {
echo "<script type='text/javascript'>alert('请上传正确的文件类型')</script>";
}
}
}
