function admin_export()
{
$this->MailServer->recursive = 0;
$raw_data = $this->paginate();
App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php'));
$excelHandler = new PHPExcel_Handler("writer", "excel5");
$objActSheet = $excelHandler->getExcel()->getActiveSheet();
//-- set current sheet name --
$objActSheet->setTitle(date("Y-m-d"));
//-- set contents
$data = array();
$title_data = array(__("Host", true), __("Ssl", true), __("Port", true), __("Account", true), __("Passwd", true));
array_push($data, $title_data);
foreach ($raw_data as $row) {
$item = array($row['MailServer']['host'], $row['MailServer']['ssl'], $row['MailServer']['port'], $row['MailServer']['account'], $row['MailServer']['passwd']);
array_push($data, $item);
}
$objActSheet->fromArray($data);
$outputFileName = "mail_servers_list.xls";
$excelHandler->saveOutput($outputFileName);
}
function admin_export()
{
$this->Financy->recursive = 0;
$raw_data = $this->paginate();
App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php'));
$excelHandler = new PHPExcel_Handler("writer", "excel5");
$objActSheet = $excelHandler->getExcel()->getActiveSheet();
//设置当前活动sheet的名称
$objActSheet->setTitle(date("Y-m-d"));
//-- set contents
$data = array();
$title_data = array(__("Categories", true), __("Create Date", true), __("Debit", true), __("Money", true), __("Memo", true));
array_push($data, $title_data);
Configure::load("common");
$debit_options = Configure::read('debit_options');
foreach ($raw_data as $row) {
$item = array($row['FinanceCategory']['category_name'], $row['Financy']['create_date'], $debit_options[$row['Financy']['debit']], $row['Financy']['money'], $row['Financy']['memo']);
array_push($data, $item);
}
$objActSheet->fromArray($data);
$outputFileName = "output.xls";
$excelHandler->saveOutput($outputFileName);
}
function admin_export()
{
$this->MailCustomer->recursive = 0;
$raw_data = $this->paginate();
App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php'));
$excelHandler = new PHPExcel_Handler("writer", "excel5");
$objActSheet = $excelHandler->getExcel()->getActiveSheet();
//-- set current sheet name --
$objActSheet->setTitle(date("Y-m-d"));
//-- set contents
$data = array();
$title_data = array(__("Nickname", true), __("Categories", true), __("Gender", true), __("Email", true), __("Tel", true));
array_push($data, $title_data);
foreach ($raw_data as $row) {
$item = array($row['MailCustomer']['nickname'], $row['MailCustomer']['mail_customer_category_id'], $row['MailCustomer']['gender'], $row['MailCustomer']['email'], $row['MailCustomer']['tel']);
array_push($data, $item);
}
$objActSheet->fromArray($data);
$outputFileName = "mail_customers_list.xls";
$excelHandler->saveOutput($outputFileName);
}
