function perform()
{
//パラメータ取得
$company_id = $this->af->get('company_id');
$warehouse_id = $this->af->get('warehouse_id');
$product_id = $this->af->get('product_id');
$keyword = $this->af->get('keyword');
$bc_1 = $this->af->get('bc_1');
$ai = $this->af->get('ai');
$ai_arr = array();
if (!empty($ai)) {
foreach ($ai as $key => $value) {
$ai_arr[] = '%(' . str_replace('y', '_', $key) . ')' . $value . '%';
}
}
try {
$dao = DaoFactory::ZaikoD();
$params = array('company_id' => $company_id, 'warehouse_id' => $warehouse_id, 'product_id' => $product_id, 'barcode' => $bc_1, 'keyword' => $keyword, 'ai_arr' => $ai_arr);
$output = $dao->searchZaikoListForApi($params);
} catch (Exception $e) {
// 致命的なエラーが発生
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array('500', $e->getMessage());
}
return array('json', $output);
}
/**
* 在庫一覧のデータを返す
* @access public
* @return array 在庫一覧
* @see Admin_ActionClass::perform()
*/
public function perform()
{
// get request params ( search )
$warehouse_id_arr = $this->af->get('warehouse_id_arr');
$product_id = $this->af->get('product_id');
$product_name = $this->af->get('product_name');
$ai_cd = $this->af->get('ai_cd');
$ai = $this->af->get('ai');
$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();
$ai_arr = array();
if ('' != $ai) {
$tmparr = explode(';', $ai);
foreach ($tmparr as $value) {
$row = explode('=', $value);
$ai_arr[] = '%(' . str_replace('y', '_', $row[0]) . ')' . $row[1] . '%';
}
}
try {
$stock = DaoFactory::ZaikoD();
//検索
$params = array('company_id' => $company_id, 'product_id2' => $product_id, 'product_name' => $product_name, 'start_page' => $start_page, 'warehouse_id_arr' => $warehouse_id_arr, 'end_page' => $end_page, 'order' => $order, 'column' => $column, 'keyword' => $keyword);
$result = $stock->getZaikoList($params);
$total = $result[0];
$list = $stock->getZaikoAiList($params)->fetchAll(PDO::FETCH_ASSOC);
// 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'] = $total;
$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);
}
/**
* 在庫一覧の保存が成功したかJSON形式で返す
* @access public
* @see Admin_ActionClass::perform()
*/
function perform()
{
set_time_limit(DEFAULT_CSV_PROCESS_TIME_LIMIT);
// 初期化
$warehouse_id_arr = $this->af->get('warehouse_id_arr');
$product_id = $this->af->get('product_id');
$product_name = $this->af->get('product_name');
$ai = $this->af->get('ai');
$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, 'warehouse_id_arr' => $warehouse_id_arr, 'product_id' => $product_name, 'product_name' => $product_id, 'keyword' => $keyword);
}
$ai_arr = array();
if ('' != $ai) {
$tmparr = explode(';', $ai);
foreach ($tmparr as $value) {
$row = explode('=', $value);
$ai_arr[] = '%(' . str_replace('y', '_', $row[0]) . ')' . $row[1] . '%';
}
$params['ai_arr'] = $ai_arr;
}
try {
// 一覧を取得
$sth = DaoFactory::ZaikoD()->getZaikoForCsvData($params);
// 書き込みクラスを生成
require_once 'csv/ZaikoDCsvWriter.class.php';
$writer = new ZaikoDCsvWriter();
if (!isset($params['ai_arr'])) {
unset($writer->format['AI_INFO']);
}
} catch (Exception $e) {
// 致命的なエラーが発生
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array('500', $e->getMessage());
}
return array('csv', $writer, $sth, 'ZaikoD' . date('YmdHis') . '.csv');
}
function perform()
{
//パラメータ取得
$company_id = $this->af->get('company_id');
$warehouse_id = $this->af->get('warehouse_id');
$product_id = $this->af->get('product_id');
$zk = DaoFactory::ZaikoD()->Retrieve(" company_id = ? and warehouse_id = ? and product_id = ? ", array($company_id, $warehouse_id, $product_id));
$product = DaoFactory::ProductMst()->Retrieve(" company_id = ? and product_id = ? ", array($company_id, $product_id));
$warehouse = DaoFactory::WarehouseMst()->Retrieve(" company_id = ? and warehouse_id = ? ", array($company_id, $warehouse_id));
try {
$rec['PRODUCT_ID'] = $product_id;
$rec['PRODUCT_NAME'] = $product["PRODUCT_NAME"];
$rec['WAREHOUSE_ID'] = $warehouse_id;
$rec['WAREHOUSE_NAME'] = $warehouse['WAREHOUSE_NAME'];
$rec['QTY'] = empty($zk['ZAIKOSU']) ? "0" : $zk['ZAIKOSU'];
} catch (Exception $e) {
// 致命的なエラーが発生
$this->logger->log(LOG_DEBUG, $e->getTraceAsString());
return array('500', $e->getMessage());
}
return array('json', $rec);
}
/**
* 一覧のデータを返す
* @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');
$ai_info = $this->af->get('ai_info');
$keyword = $this->af->get('keyword');
// get request params ( pager )
// $limit = $this->af->get('limit'); // default 50
$limit = 500;
$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');
$user_id = $this->session->get('user_id');
// setting pager
$start_page = ($page - 1) * $limit + 1;
$end_page = ($page - 1) * $limit + $limit;
$output = array();
if ('' != $ai_info) {
$ai_arr[] = $ai_info;
}
try {
$dao = DaoFactory::ZaikoD();
//検索
$params = array();
$params = array('company_id' => $company_id, 'warehouse_id' => $warehouse_id, 'product_id' => $product_id, 'ai_info' => $ai_info, 'keyword' => $keyword, 'start_page' => $start_page, 'end_page' => $end_page, 'order' => $order, 'keyword' => $keyword);
$params2 = array('company_id' => $company_id, 'warehouse_id' => $warehouse_id, 'product_id2' => $product_id, 'ai_arr' => $ai_arr);
$total = $dao->getZaikoList($params2);
$result = $dao->getZaikoGs128Data($params);
$list = array();
$aiarr = array();
foreach ($result as $row) {
$row['AI_INFO'] = ltrim($row['AI_INFO'], '(');
$tmparr = explode('(', $row['AI_INFO']);
foreach ($tmparr as $value) {
$arr = explode(')', $value);
$list[] = array('AI' => $arr[0], 'AI_NAME' => '', 'VALUE' => $arr[1]);
if (!in_array($arr[0], $aiarr)) {
$aiarr[] = $arr[0];
}
}
}
$result = DaoFactory::AicustomMst()->getAiOptions(array('company_id' => $company_id, 'ai_arr' => $aiarr));
// $result[1]['AI'] = '3101';
// file_put_contents('/tmp/zai_result',var_export($result,true));
$namearr = array();
foreach ($result as $row) {
if ($row['AI'][0] == '3' && strlen($row['AI']) == 4) {
//处理310y的情况，只按前三位处理
// file_put_contents('/tmp/run'.$row['AI'],1);
$namearr[substr($row['AI'], 0, 3)] = $row['AI_NAME'];
} else {
$namearr[$row['AI']] = $row['AI_NAME'];
}
}
// file_put_contents('/tmp/zai_namearr',var_export($namearr,true));
foreach ($list as $key => $row) {
if ($row['AI'][0] == '3' && strlen($row['AI']) == 4) {
//处理310y的情况，只按前三位处理
$list[$key]['AI_NAME'] = $namearr[substr($row['AI'], 0, 3)];
} else {
$list[$key]['AI_NAME'] = $namearr[$row['AI']];
}
}
// file_put_contents('/tmp/zai_list',var_export($list,true));
// pager array setting
$pagerData = array('result_page' => $page, 'result_start_num' => $start_page, 'result_end_num' => $end_page, 'result_all_count' => count($list), 'result_get_count' => count($list), 'result_limit' => $limit);
// output にセット
$output['totalData'] = $total[0];
$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);
}
