/**
* カテゴリマスタのデータをJSON形式で返す
* @access public
* @return array カテゴリマスタ
* @see Admin_ActionClass::perform()
*/
public function perform()
{
// get request params ( search )
$category_id = $this->af->get('category_id');
$kbn_category_name = $this->af->get('kbn_category_name');
$must_flg = $this->af->get('must_flg');
$keyword = $this->af->get('keyword');
// get request params ( pager )
$limit = $this->af->get('limit');
$page = $this->af->get('page');
$order = $this->af->get('order');
$column = $this->af->get('column');
// get session params
$company_id = $this->session->get('company_id');
// pager setting
$start_page = ($page - 1) * $limit + 1;
$end_page = ($page - 1) * $limit + $limit;
try {
// DAO パラメータ定義
$params = array('category_id' => $category_id, 'kbn_category_name' => $kbn_category_name, 'must_flg' => $must_flg, 'keyword' => $keyword, 'order' => $order, 'column' => $column, 'company_id' => $company_id, 'start_page' => $start_page, 'end_page' => $end_page);
// 一覧を取得
$stmt = DaoFactory::KbnCategoryMst()->KbnCategoryMst_GetList($params);
$list = $stmt->fetchAll();
// ページ情報を設定
$pager = array('result_page' => $page, 'result_start_num' => $start_page, 'result_end_num' => $end_page, 'result_all_count' => count($list) ? $list[0]['FOUND_ROWS'] : 0, 'result_get_count' => count($list), 'result_limit' => $limit);
// output にセット
$output['totalData'] = array();
$output['listData'] = $list;
$output['pagerData'] = $pager;
} catch (Exception $e) {
// 致命的なエラーが発生
return array('500', $e->getMessage());
}
return array('json', $output);
}
/**
* 端末マスタの保存が成功したかJSON形式で返す
* @access public
* @see Admin_ActionClass::perform()
*/
function perform()
{
// get request params
$category_id_arr = $this->af->get('category_id_arr');
$status_flg = $this->af->get('status_flg');
// get session params
$company_id = $this->session->get('company_id');
$s_user_id = $this->session->get('user_id');
// dao
$Dao = DaoFactory::KbnCategoryMst();
try {
// begin
$Dao->BeginTransaction();
foreach ($category_id_arr as $category_id) {
// set params
$params = array('IS_MUST' => $status_flg, 'UID' => $s_user_id, 'PGM' => get_class());
// dao update
$Dao->Update($params, ' COMPANY_ID = ? AND CATEGORY_ID = ? ', array($company_id, $category_id));
}
// commit
$Dao->CommitTransaction();
} catch (Exception $e) {
// rollback
$Dao->AbortTransaction();
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array(500, $e->getMessage());
}
exit;
}
public function getCategoryList()
{
$company_id = $this->backend->getSession()->get('company_id');
$dao = DaoFactory::KbnCategoryMst();
$list = $dao->getCategoryListForSelectBox(array('company_id' => $company_id));
$option = array('' => '');
foreach ($list as $row) {
$option[$row['CATEGORY_ID']] = $row['CATEGORY_ID'] . ':' . $row['KBN_CATEGORY_NAME'];
}
return $option;
}
