function admin_import()
{
App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php'));
$excelHandler = new PHPExcel_Handler("reader", "excel5");
$excelReader = $excelHandler->getProcesser();
$outputFileName = "d:/output.xls";
$excelObj = $excelReader->load($outputFileName);
debug($excelObj->getActiveSheet()->toArray());
$this->render("admin_export");
}
function admin_import_data()
{
$this->layout = 'ajax';
if (!empty($this->data)) {
// do validate
$this->MailServer->set($this->data);
if ($this->MailServer->validates()) {
if (isset($this->data['MailServer']['file']['size']) && $this->data['MailServer']['file']['size'] > 0) {
$importFileName = $this->Upload->upload('file', 'MailServer');
App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php'));
$excelHandler = new PHPExcel_Handler("reader", "excel5");
$excelReader = $excelHandler->getProcesser();
$excelObj = $excelReader->load($importFileName);
$data = $excelObj->getActiveSheet()->toArray();
if (is_array($data) && count($data) > 1) {
array_shift($data);
foreach ($data as $key => $item) {
$tmp = array('MailServer' => array('host' => $item[0], 'ssl' => $item[1], 'port' => $item[2], 'account' => $item[3], 'passwd' => $item[4]));
unset($data[$key]);
$data[$key] = $tmp;
}
$this->MailServer->saveAll($data);
}
unlink($importFileName);
echo "done";
exit;
} else {
echo "done";
exit;
}
}
}
}
