public function exportCMS()
{
$list = array_merge(Configure::read('MultiLanguage.fallback'), Configure::read('MultiLanguage.list'));
App::uses('ExcelLib', 'Lib');
$excel = new ExcelLib();
$excel->init();
$data = array();
//save
$mapping = array();
foreach (Configure::read('MultiLanguage.app_mapping_list') as $key => $val) {
$mapping[$val] = strtoupper($key);
}
$header[] = 'Key';
foreach (array_keys($list) as $lang) {
$header[] = $mapping[$lang];
}
$data[] = $header;
$languages = $this->getCMSLanguages();
foreach ($languages as $key => $language) {
$row = array();
$row[] = $key;
foreach ($language as $val) {
$row[] = $val;
}
$data[] = $row;
}
$excel->writeFromArray($data);
$excel->send2Browser(array('filename' => sprintf("cms-translation-%s.xls", date("Ymd", time()))));
}
function export($id = 0)
{
$costingDb = $this->Costing->findById($id);
$this->checkCanDo($costingDb);
App::uses('ExcelLib', 'Lib');
$costingRecord = $this->Costing->getCostingRecord($costingDb);
$data = $costingRecord['excelData'];
$excel = new ExcelLib();
$excel->init();
$excel->writeFromArray($data);
$excel->PHPExcel->getActiveSheet()->setTitle('Costing');
$excel->PHPExcel->setActiveSheetIndex(0);
$excel->send2Browser();
die;
}
