function do_get_zipcodes($f3, $args)
{
$zipcodes = fOption::load_zipcodes(f3()->get('POST')['query']);
$rtn = array();
$rtn['html'] = '<option value="">請選擇</option>';
foreach ($zipcodes as $value) {
$rtn['html'] .= '<option value="' . $value['town'] . ' ' . $value['zipcode'] . '">' . $value['town'] . ' ' . $value['zipcode'] . '</option>';
}
return parent::_return(1, $rtn);
}
/**
* adapter for PHPExcel
*
* @param string $filename -
* @param integer $startRow -
* @param integer $endRow -
* @param array $columns -
*
* @return array
*/
static function readExcel($filename, $startRow, $endRow, $columns)
{
$root = f3()->get('ROOT') . f3()->get('BASE');
// include_once $root . f3()->get('vendors') . 'PHPExcel/IOFactory.php';
$inputFileName = $root . '' . $filename;
$filterSubset = new XlsReadFilter($startRow, $endRow, $columns);
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objReader->setReadFilter($filterSubset);
$objPHPExcel = $objReader->load($inputFileName);
return $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
} catch (PHPExcel_Reader_Exception $e) {
Reaction::_return("2005", str_replace($root, '', $e->getMessage()));
}
}
function do_dl_csv($f3, $args)
{
if (!rStaff::_isLogin()) {
return parent::_return(8001);
}
$rows = $this->_db->exec("SELECT * FROM `" . self::fmTbl() . "` ORDER BY insert_ts DESC ");
if (!$rows) {
header("Content-Type:text/html; charset=utf-8");
echo '無結果';
} else {
$template = new Template();
f3()->set('rows', $rows);
Outfit::_setXls("contact_" . date("YmdHis"));
echo $template->render('contact.dl.html', "application/vnd.ms-excel");
}
}
static function _chkLogin()
{
if (!self::_isLogin()) {
return parent::_return(8001);
}
}
function do_save_new_schedules($f3, $args)
{
$allData = json_decode(f3()->get('SESSION.uploadPrograms'), true);
db()->begin();
foreach ($allData['schedules'] as $prog) {
$program = Program::get_program_by_codename($prog['c']);
if (empty($program)) {
$program['title'] = $prog['c'];
$program['uri'] = '';
$program['id'] = 0;
}
db()->exec("INSERT INTO `" . tpf() . "schedules`(`title`, `uri`, `program_id`, `start_date`, `end_date`, `status`, `last_ts`, " . "`last_user`, `insert_user`, `insert_ts`) VALUES ('" . $program['title'] . "', '" . $program['uri'] . "', '" . $program['id'] . "', '" . $prog['d'] . " " . $prog['s'] . ":00', '" . $prog['d'] . " " . $prog['e'] . ":00', 'Yes', '" . date('Y-m-d H:i:s') . "', '" . rStaff::_CStaff('id') . "', '" . rStaff::_CStaff('id') . "', '" . date('Y-m-d H:i:s') . "')");
}
db()->commit();
return parent::_return(1, $allData['schedules']);
}
/**
* save sorter
* @param object $f3 - $f3
* @param array $args - uri params
* @return array - std json
*/
function do_update_sorter($f3, $args)
{
rStaff::_chkLogin();
$req = parent::_getReq();
foreach ($req['data'] as $row) {
fMenu::update_sorter($row['id'], $row['sorter']);
}
return parent::_return(1, $req);
}
