/**
* 出庫一覧の保存が成功したかJSON形式で返す
* @access public
* @see Admin_ActionClass::perform()
*/
function perform()
{
set_time_limit(DEFAULT_CSV_PROCESS_TIME_LIMIT);
// 初期化
$nyushutsu_date_from = $this->af->get('nyushutsu_date_from');
$nyushutsu_date_to = $this->af->get('nyushutsu_date_to');
$warehouse_id = $this->af->get('warehouse_id');
$product_id = $this->af->get('product_id');
$product_name = $this->af->get('product_name');
$denpyo_no = $this->af->get('denpyo_no');
$record_arr = $this->af->get('record_arr');
$keyword = $this->af->get('keyword');
$company_id = $this->session->get('company_id');
if (!empty($record_arr)) {
$params = array('company_id' => $company_id, 'record_arr' => $record_arr);
} else {
$params = array('company_id' => $company_id, 'nyushutsu_date_from' => $nyushutsu_date_from, 'nyushutsu_date_to' => $nyushutsu_date_to, 'product_id' => $product_id, 'product_name' => $product_name, 'warehouse_id' => $warehouse_id, 'denpyo_no' => $denpyo_no, 'keyword' => $keyword);
}
try {
// 一覧を取得
$sth = DaoFactory::NyushutsuD()->getStoragerecordCsvData($params);
// 書き込みクラスを生成
require_once 'csv/NyushutsuDCsvWriter.class.php';
$writer = new NyushutsuDCsvWriter();
} catch (Exception $e) {
// 致命的なエラーが発生
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array('500', $e->getMessage());
}
return array('csv', $writer, $sth, 'NyushutsuD' . date('YmdHis') . '.csv');
}
/**
* 入出履歴一覧のデータを返す
* @access public
* @return array 入出履歴一覧
* @see Admin_ActionClass::perform()
*/
public function perform()
{
// get request params ( search )
$warehouse_id = $this->af->get('warehouse_id');
$product_id = $this->af->get('product_id');
$product_name = $this->af->get('product_name');
$nyushutsu_date_from = $this->af->get('nyushutsu_date_from');
$nyushutsu_date_to = $this->af->get('nyushutsu_date_to');
$denpyo_no = $this->af->get('denpyo_no');
$keyword = $this->af->get('keyword');
// get request params ( pager )
$limit = $this->af->get('limit');
// default 50
$page = $this->af->get('page');
// default 1
$order = $this->af->get('order');
// default desc
$column = $this->af->get('column');
// default uriage_bi
// get session params
$company_id = $this->session->get('company_id');
// setting pager
$start_page = ($page - 1) * $limit + 1;
$end_page = ($page - 1) * $limit + $limit;
$output = array();
try {
$dao = DaoFactory::NyushutsuD();
//検索
$params = array('warehouse_id' => $warehouse_id, 'product_id' => $product_id, 'product_name' => $product_name, 'nyushutsu_date_from' => $nyushutsu_date_from, 'nyushutsu_date_to' => $nyushutsu_date_to, 'denpyo_no' => $denpyo_no, 'company_id' => $company_id, 'start_page' => $start_page, 'end_page' => $end_page, 'order' => $order, 'column' => $column, 'keyword' => $keyword);
$list = $dao->NyushutsuD_GetNyushutsuList($params);
// pager array setting
$pagerData = 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'] = $pagerData;
} catch (Exception $e) {
// 致命的なエラーが発生
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array('500', $e->getMessage());
}
return array('json', $output);
}
