\n";
$rs = ExecSql($obj, $sql);
if(!$rs){
ErrorLogWrite(ERR_DBEXEC, $sql, __FILE__, __LINE__);
CloseDB($obj);
return -1;
}
$rows = pg_numrows($rs);
$row = 0;
while($row < $rows){
$DATA = pg_fetch_object($rs, $row);
$recInfo = array();
$recInfo["zone_cd"] = $DATA->zone_cd;
$recInfo["zone_nm"] = mb_convert_encoding($DATA->zone_nm, ENCODE_SCR, ENCODE_DB);
$result[] = $recInfo;
$row++;
}
CloseDB($obj);
return 1;
}
function getSessionId(&$p_s_id)
{
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return;
}
$sql = "";
$sql = "select nextval('seq_session_id') as s_id";
//TODO
//echo $sql."
\n";
$rs = ExecSql($obj, $sql);
if(!$rs){
ErrorLogWrite(ERR_DBEXEC, $sql, __FILE__, __LINE__);
CloseDB($obj);
return -1;
}
$rows = pg_numrows($rs);
if($rows > 0){
$DATA = pg_fetch_object($rs, $row);
$p_s_id = $DATA->s_id;
}
CloseDB($obj);
return 1;
}
function loadOrder($i_kei_date, $i_zone_cd, $i_kkk_cd, &$recInfo)
{
$recInfo = array();
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return;
}
$sql = "";
$sql .= "select spe_su_1, spe_su_2, spe_su_3";
$sql .= " from t_order";
$sql .= " where kei_date = '" . $i_kei_date . "'";
$sql .= " and zone_cd = '" . $i_zone_cd . "'";
$sql .= " and kkk_cd = '" . $i_kkk_cd . "'";
//TODO
//echo $sql."
\n";
$rs = ExecSql($obj, $sql);
if(!$rs){
ErrorLogWrite(ERR_DBEXEC, $sql, __FILE__, __LINE__);
CloseDB($obj);
return -1;
}
$rows = pg_numrows($rs);
if($rows > 0){
$DATA = pg_fetch_object($rs, $row);
$recInfo["spe_su_1"] = $DATA->spe_su_1;
$recInfo["spe_su_2"] = $DATA->spe_su_2;
$recInfo["spe_su_3"] = $DATA->spe_su_3;
}
CloseDB($obj);
return 1;
}
function loadOrderWork($i_s_id, $i_kei_date, $i_zone_cd, $i_kkk_cd)
{
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return;
}
$sql = "";
$sql = "select fnc_load_order(" . $i_s_id . ", '" . $i_kei_date . "', '" . $i_zone_cd . "', '" . $i_kkk_cd . "')";
//TODO
//echo $sql."
\n";
ExecSql($obj, $sql);
CloseDB($obj);
}
function getOrderWork($i_s_id, &$result)
{
$result = array();
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return -1;
}
$sql = "";
$sql .= "select";
$sql .= " d.seq_no";
$sql .= ", fnc_opt_names(d.s_id,d.kei_date,d.zone_cd,d.kkk_cd,d.seq_no) as opt_names";
$sql .= ", d.order_su";
$sql .= " from w_order_d d";
$sql .= " where d.s_id = " . $i_s_id . "";
$sql .= " order by seq_no";
//TODO
//echo $sql."
\n";
$rs = ExecSql($obj, $sql);
if(!$rs){
ErrorLogWrite(ERR_DBEXEC, $sql, __FILE__, __LINE__);
CloseDB($obj);
return -1;
}
$rows = pg_numrows($rs);
$row = 0;
while($row < $rows){
$DATA = pg_fetch_object($rs, $row);
$recInfo = array();
$recInfo["seq_no"] = $DATA->seq_no;
$recInfo["opt_names"] = mb_convert_encoding($DATA->opt_names, ENCODE_SCR, ENCODE_DB);
$recInfo["order_su"] = $DATA->order_su;
$result[] = $recInfo;
$row++;
}
CloseDB($obj);
return 1;
}
function getOptionWork($i_s_id, &$result)
{
$result = array();
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return -1;
}
$sql = "";
$sql .= "select";
$sql .= " d.opt_cd";
$sql .= ", v.opt_nm";
// $sql .= ", d.select_flg as checkbox";
$sql .= " from w_order_op d";
$sql .= " left join v_opt v on (v.zone_cd = d.zone_cd and v.opt_cd = d.opt_cd)";
$sql .= " where d.s_id = " . $i_s_id . "";
$sql .= " and d.seq_no = 0";
$sql .= " order by opt_cd";
//TODO
//echo $sql."
\n";
$rs = ExecSql($obj, $sql);
if(!$rs){
ErrorLogWrite(ERR_DBEXEC, $sql, __FILE__, __LINE__);
CloseDB($obj);
return -1;
}
$rows = pg_numrows($rs);
$row = 0;
while($row < $rows){
$DATA = pg_fetch_object($rs, $row);
$recInfo = array();
$recInfo["opt_cd"] = $DATA->opt_cd;
$recInfo["opt_nm"] = mb_convert_encoding($DATA->opt_nm, ENCODE_SCR, ENCODE_DB);
$result[] = $recInfo;
$row++;
}
CloseDB($obj);
return 1;
}
function insertOptionWork($i_s_id, $i_kei_date, $i_zone_cd, $i_kkk_cd, $i_order_su, $i_opt_keys)
{
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return -1;
}
$s_keys = "";
if(isset($i_opt_keys)){
foreach ($i_opt_keys as $opt_cd) {
if(!empty($s_keys)){
$s_keys .= ",";
}
$s_keys .= "'".$opt_cd."'";
}
}
if($s_keys != ""){
$sql = "";
$sql .= "update w_order_op set";
$sql .= " select_flg = 1";
$sql .= " where s_id = " . $i_s_id . "";
$sql .= " and seq_no = 0";
$sql .= " and opt_cd in (" . $s_keys . ")";
ExecSql($obj, $sql);
//TODO
//echo $sql."
\n";
}
$sql = "";
$sql .= "select fnc_add_order_work(" . $i_s_id . ", '" . $i_kei_date . "', '" . $i_zone_cd . "', '" . $i_kkk_cd . "', cast('0'||'" . $i_order_su . "' as int), '" . $i_kkk_cd . "')";
ExecSql($obj, $sql);
//TODO
//echo $sql."
\n";
$sql = "";
$sql .= "update w_order_op set";
$sql .= " select_flg = 0";
$sql .= " where s_id = " . $i_s_id . "";
$sql .= " and seq_no = 0";
// $sql .= " and select_flg != 0";
ExecSql($obj, $sql);
//TODO
//echo $sql."
\n";
CloseDB($obj);
return 0;
}
function deleteOptionWork($i_s_id, $i_kei_date, $i_zone_cd, $i_kkk_cd, $i_order_key)
{
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return -1;
}
$sql = "";
$sql .= "select fnc_del_order_work(" . $i_s_id . ", '" . $i_kei_date . "', '" . $i_zone_cd . "', '" . $i_kkk_cd . "', " . $i_order_key . ")";
ExecSql($obj, $sql);
//TODO
//echo $sql."
\n";
CloseDB($obj);
return 0;
}
function commitWork($i_s_id, $i_kei_date, $i_zone_cd, $i_kkk_cd, $i_headInfo)
{
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return -1;
}
$sql = "";
$sql .= "select fnc_update_order(" . $i_s_id . ", '" . $i_kei_date . "', '" . $i_zone_cd . "', '" . $i_kkk_cd . "', cast('0'||'" . $i_headInfo["spe_su_1"] . "' as int), cast('0'||'" . $i_headInfo["spe_su_2"] . "' as int), cast('0'||'" . $i_headInfo["spe_su_3"] . "' as int), '" . $i_kkk_cd . "')";
ExecSql($obj, $sql);
//TODO
//echo $sql."
\n";
CloseDB($obj);
return 0;
}
function nzval($iValue)
{
if(empty($iValue)){
return "0";
}
else {
return $iValue;
}
}
function zeroNull($iValue)
{
if(empty($iValue)){
return "";
}
else {
return $iValue;
}
}
function nz($sValue)
{
return $sValue;
}
function isOrderOk($i_kei_date, $i_zone_cd)
{
$bRet = false;
$obj = OpenDBConnectAssign(AP_CONNECT_STR);
if (!$obj) {
ErrorLogWrite(ERR_DBOPEN, AP_CONNECT_STR, __FILE__, __LINE__);
return false;
}
$sql = "";
$sql .= "select 1";
$sql .= " from t_kakutei";
$sql .= " where kei_date = '" . $i_kei_date . "'";
$sql .= " and zone_cd = '" . $i_zone_cd . "'";
//TODO
//echo $sql."
\n";
$rs = ExecSql($obj, $sql);
if(!$rs){
ErrorLogWrite(ERR_DBEXEC, $sql, __FILE__, __LINE__);
CloseDB($obj);
return false;
}
$rows = pg_numrows($rs);
if($rows > 0){
} else {
$bRet = true;
}
CloseDB($obj);
return $bRet;
}
?>