/** * 区分マスタの保存が成功したか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); }