/**
* 区分マスタの保存が成功したかJSON形式で返す
* @access public
* @see Admin_ActionClass::perform()
*/
function perform()
{
// get request params
$category_id = $this->af->get('category_id');
$kbn_id = $this->af->get('kbn_id');
$kbn_name = $this->af->get('kbn_name');
// get session params
$company_id = $this->session->get('company_id');
$user_id = $this->session->get('user_id');
// dao
$kbnDao = DaoFactory::KbnMst();
try {
// begin
$kbnDao->BeginTransaction();
// cd exists
$params = array('company_id' => $company_id, 'category_id' => $category_id, 'kbn_id' => $kbn_id, 'kbn_name' => $kbn_name, 'UID' => $user_id, 'PGM' => get_class());
$kbnDao->Insert($params);
// commit
$kbnDao->CommitTransaction();
} catch (Exception $e) {
$kbnDao->AbortTransaction();
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array(500, $e->getMessage());
}
exit;
}
/**
* 区分マスタの保存が成功したかJSON形式で返す
* @access public
* @see Admin_ActionClass::perform()
*/
function perform()
{
// get request params
$record_arr = $this->af->get('record_arr');
// get session params
$company_id = $this->session->get('company_id');
// dao
$KbnDao = DaoFactory::KbnMst();
try {
// begin
$params = array('company_id' => $company_id);
$KbnDao->BeginTransaction();
if ($_REQUEST['del'] == 'all') {
$KbnDao->Delete(' company_id = ? ', $params);
} else {
foreach ($record_arr as $key => $pk) {
$params['category_id'] = $pk['category_id'];
$params['kbn_id'] = $pk['kbn_id'];
$KbnDao->Delete(' company_id = ? AND category_id = ? AND kbn_id = ? ', $params);
}
}
$KbnDao->CommitTransaction();
} catch (Exception $e) {
$KbnDao->AbortTransaction();
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array(500, $e->getMessage());
}
exit;
}
/**
* 区分マスタCSVを出力
* @access public
* @see Admin_ActionClass::perform()
*/
function perform()
{
set_time_limit(DEFAULT_CSV_PROCESS_TIME_LIMIT);
// get request params
$category_id = $this->af->get('category_id');
$category_name = $this->af->get('category_name');
$kbn_id = $this->af->get('kbn_id');
$kbn_name = $this->af->get('kbn_name');
$keyword = $this->af->get('keyword');
$record_arr = $this->af->get('record_arr');
// get session params
$company_id = $this->session->get('company_id');
// pager setting
$order = $this->af->get('order');
// default asc
$column = $this->af->get('column');
// default warehouse_id
try {
// 一覧を取得
if (!empty($record_arr)) {
$params = array('company_id' => $company_id, 'record_arr' => $record_arr, 'csv' => true);
} else {
$params = array('company_id' => $company_id, 'kbn_id' => $kbn_id, 'kbn_name' => $kbn_name, 'keyword' => $keyword, 'order' => $order, 'column' => $column, 'csv' => true);
}
$dao = DaoFactory::KbnMst();
$sth = $dao->getKbnList($params);
// 書き込みクラスを生成
require_once 'csv/KbnMstCsvWriter.class.php';
$writer = new KbnMstCsvWriter();
} catch (Exception $e) {
// 致命的なエラーが発生
return array('500', $e->getMessage());
}
return array('csv', $writer, $sth, 'KbnMst' . date('YmdHis') . '.csv');
}
public function check_kbn_not_exists($name)
{
$bind = array('company_id' => $this->backend->getSession()->get('company_id'), 'category_id' => $this->form_vars['category_id'], 'kbn_id' => $this->form_vars['kbn_id']);
// 区分を取得
$dao = DaoFactory::KbnMst();
$result = $dao->Retrieve(' COMPANY_ID = ? AND CATEGORY_ID = ? AND KBN_ID = ? ', $bind);
if (!empty($result)) {
$this->ae->add($name, "入力された{form}は既に登録されています", E_FORM_INVALIDCHAR);
}
}
/**
* 区分マスタのデータをJSON形式で返す
* @access public
* @return array 区分マスタ
* @see Admin_ActionClass::perform()
*/
public function perform()
{
// get request params ( search )
$kbn_id = $this->af->get('kbn_id');
$category_id = $this->af->get('category_id');
// get session params
$company_id = $this->session->get('company_id');
try {
// DAO パラメータ定義
$params = array('company_id' => $company_id, 'kbn_id' => $kbn_id, 'category_id' => $category_id);
// 詳細を取得
$detail = DaoFactory::KbnMst()->getKbnForEdit($params);
// output にセット
$output['totalData'] = array();
$output['listData'] = $detail;
$output['pagerData'] = array();
} catch (Exception $e) {
// 致命的なエラーが発生
return array('500', $e->getMessage());
}
return array('json', $output);
}
/**
* 区分マスタのデータをJSON形式で返す
* @access public
* @return array 区分マスタ
* @see Admin_ActionClass::perform()
*/
public function perform()
{
// get request params
$category_id = $this->af->get('category_id');
$category_name = $this->af->get('category_name');
$kbn_id = $this->af->get('kbn_id');
$kbn_name = $this->af->get('kbn_name');
$keyword = $this->af->get('keyword');
// get session params
$company_id = $this->session->get('company_id');
// pager setting
$limit = $this->af->get('limit');
// default 50
$page = $this->af->get('page');
// default 1
$order = $this->af->get('order');
// default asc
$column = $this->af->get('column');
// default warehouse_id
$start_page = ($page - 1) * $limit + 1;
$end_page = ($page - 1) * $limit + $limit;
try {
// DAO パラメータ定義
$params = array('category_id' => $category_id, 'category_name' => $category_name, 'kbn_id' => $kbn_id, 'kbn_name' => $kbn_name, 'keyword' => $keyword, 'limit' => $limit, 'page' => $page, 'order' => $order, 'column' => $column, 'company_id' => $company_id, 'start_page' => $start_page, 'end_page' => $end_page);
// 一覧を取得
$list = DaoFactory::KbnMst()->getKbnList($params);
// ページ情報を設定
$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);
}
