forked from HANYANG/HANYANG_MES
228 lines
8.0 KiB
PHP
228 lines
8.0 KiB
PHP
<?php
|
|
$cate_id = "ORDER_REGISTRATION"; //현재 메뉴 ID 필수!!!
|
|
include_once "{$_SERVER['DOCUMENT_ROOT']}/common.inc.php";
|
|
include_once _SVC_INC_PATH_ ."/auth_check.php";
|
|
include_once _HOME_INC_PATH_ ."/ajax_init.php";
|
|
|
|
|
|
if( !_notAuth("R") ){/************ 권한체크*/
|
|
switch( $_REQUEST['mode'] ){
|
|
case "putOutsourcing":
|
|
if( _notAuth("W") ) break; /************ 권한체크*/
|
|
$PO_UID = $_REQUEST['PO_UID'];
|
|
if(!$PO_UID) { $retval['mesg'] = cUtil\Mlang::getText("발주번호가 누락되었습니다."); $rst=false; break; }
|
|
$chksql = "USP_Y_OUTSOURCING_S11";
|
|
$chkparams = Array( "PO_UID" => $PO_UID );
|
|
$rst = $baseObj->DB->exec($chksql, $chkparams);
|
|
if( $rst ){
|
|
$row = $baseObj->DB->fetch_array($rst);
|
|
if( $row['PO_NO'] ){
|
|
$rst = 0;
|
|
$retval['mesg'] = cUtil\Mlang::getText("해당 발주번호는 사용 중 입니다.."); break;
|
|
}
|
|
}
|
|
|
|
if( isset($PO_UID)) {
|
|
$sql = "USP_Y_OUTSOURCING_I10";
|
|
$params = Array();
|
|
|
|
$soInfo = json_decode($_REQUEST['SO'], true);
|
|
|
|
$params = array_merge($params, Array(
|
|
"PO_NO" => "",
|
|
"PO_UID" => $_REQUEST['PO_UID'],
|
|
"BIZ_AREA_CD" => $_REQUEST['BIZ_AREA_CD']?:NULL,
|
|
"PO_DT" => $_REQUEST['PO_DT']?:NULL,
|
|
"PO_BP_CD" => $_REQUEST['PO_BP_CD']?:NULL,
|
|
"PAYMENT_COND" => $_REQUEST['PAYMENT_COND']?:NULL,
|
|
"PO_PRSN_TEL" => $_REQUEST['PO_PRSN_TEL']?:NULL,
|
|
"PO_PRSN_NM" => $_REQUEST['PO_PRSN_NM']?:NULL,
|
|
"PO_BP_NM" => $_REQUEST['PO_BP_NM']?:NULL,
|
|
"PO_BP_ADDR" => $_REQUEST['PO_BP_ADDR']?:NULL,
|
|
"PO_BP_TEL" => $_REQUEST['PO_BP_TEL']?:NULL,
|
|
"CURRENCY_CD" => $_REQUEST['CURRENCY_CD']?:NULL,
|
|
"PO_DEL_COND" => $_REQUEST['PO_DEL_COND']?:NULL,
|
|
"PO_INSPT_COND" => $_REQUEST['PO_INSPT_COND']?:NULL,
|
|
"PO_MATR_CLASS" => $_REQUEST['PO_MATR_CLASS']?:NULL,
|
|
"PO_MNG_CLASS" => $_REQUEST['PO_MNG_CLASS']?:NULL,
|
|
"PO_REMARK1" => $_REQUEST['PO_REMARK1']?:NULL,
|
|
"PO_REMARK2" => $_REQUEST['PO_REMARK2']?:NULL,
|
|
"MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
|
|
"SO_NO" => $soInfo['SO_NO']?:""
|
|
));
|
|
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
}
|
|
if ($_REQUEST['ITEM']) {
|
|
$chksql = "USP_Y_OUTSOURCING_S11";
|
|
$chkparams = Array( "PO_UID" => $PO_UID );
|
|
$rst = $baseObj->DB->exec($chksql, $chkparams);
|
|
$L_PO_NO = null;
|
|
if( $rst ){
|
|
$row = $baseObj->DB->fetch_array($rst);
|
|
if( $row['PO_NO'] ){
|
|
$L_PO_NO = $row['PO_NO'];
|
|
}
|
|
}
|
|
|
|
$items = json_decode($_REQUEST['ITEM']);
|
|
foreach ($items as $item) {
|
|
$item = (array)$item;
|
|
$sql = "USP_Y_OUTSOURCING_I20";
|
|
$params = Array(
|
|
"PO_NO" => $L_PO_NO,
|
|
"PO_DTL_ORD_NO" => $item['PO_DTL_ORD_NO']?:NULL,
|
|
"MNG_NO" => $item['MNG_NO'],
|
|
"DRAW_NO" => $item['ASS_DRAW']?:NULL,
|
|
"QTY" => $item['SO_QTY'],
|
|
"REQ_DLVY_DT" => $item['REQ_DLVY_DT']?:NULL,
|
|
"PRICE" => $item['PRICE']?:NULL,
|
|
"AMT" => $item['AMT']?:NULL,
|
|
"SPC_OD" => $item['OUT_DIA']?:NULL,
|
|
"SPC_ID" => $item['IN_DIA']?:NULL,
|
|
"SPC_TH" => $item['THICK']?:NULL,
|
|
"SPC_W" => $item['WIDTH']?:NULL,
|
|
"SPC_L" => $item['LENGTH']?:NULL,
|
|
"MATR" => $item['MATR_TYPE']?:NULL,
|
|
"PO_UNIT" => $item['SO_UNIT']?:NULL,
|
|
"PO_DTL_COND" => $item['PO_DTL_COND']?:NULL,
|
|
"SPEM" => $item['SPEM']?:NULL,
|
|
"INST_COND" => $item['INST_COND']?:NULL,
|
|
"PWR_PRICE" => $item['PWR_PRICE']?:NULL,
|
|
"PWR_AMT" => $item['PWR_AMT']?:NULL,
|
|
"REMARK" => $item['REMARK']?:NULL,
|
|
"CUST_PO_NO" => $item['CUST_PO_NO']?:NULL,
|
|
"MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
|
|
"ITEM_CD" => $item['ITEM_CD']?:null,
|
|
"SO_NO" => $item['SO_NO']?:null,
|
|
);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
$sql = "USP_S_SO_U21";
|
|
$params = Array(
|
|
"MNG_NO" => $item['MNG_NO'],
|
|
"APPROV_FLG" => 'Y'
|
|
);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
}
|
|
}
|
|
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
}
|
|
break;
|
|
|
|
case "getOrderList":
|
|
$sql = "USP_SALES_SO_LIST_S1";
|
|
$params = Array(
|
|
"BP_CD" => $_REQUEST['BP_CD']?:"",
|
|
"SO_DT_ST" => $_REQUEST['SO_DT_ST']?:"",
|
|
"SO_DT_ED" => $_REQUEST['SO_DT_ED']?:"",
|
|
"MNG_NO" => $_REQUEST['MNG_NO']?:"",
|
|
"SALES_GRP" => $_REQUEST['SALES_GRP']?:"",
|
|
"SO_TYPE_I" => $_REQUEST['SO_TYPE_I']?:"",
|
|
"SO_TYPE_E" => $_REQUEST['SO_TYPE_E']?:"",
|
|
"OFLD" => $_REQUEST['OFLD']?:"",
|
|
"OASC" => $_REQUEST['OASC']?:"",
|
|
"LINE_NUM" => $_REQUEST['LINE_NUM']?:"",
|
|
"NOW_PAGE" => $_REQUEST['NOW_PAGE']?:"",
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$row['LIST_NUM'] = $row['TOTAL_ROWS_NUM'] - $row['START_ROW'] - $i++;
|
|
$row['SO_NO_OLD'] = $row['SO_NO'];
|
|
$row['CUST_EMAIL'] = $baseObj->lcrypt->dec_secure($row['CUST_EMAIL']);
|
|
$row['CUST_TEL_NO'] = $baseObj->lcrypt->dec_secure($row['CUST_TEL_NO']);
|
|
$row['CUST_CELL_NO'] = $baseObj->lcrypt->dec_secure($row['CUST_CELL_NO']);
|
|
$mng_nos_c = "";
|
|
$mn_arr = explode(',', $row['MNG_NOS']);
|
|
$mn_arr_c = [];
|
|
for ($i = 0; $i < sizeof($mn_arr); $i++) {
|
|
$mn = substr( $mn_arr[$i], 0, strpos($mn_arr[$i], '!') );
|
|
$mn_arr_c[] = $mn;
|
|
}
|
|
$mn_arr_u = array_unique($mn_arr_c);
|
|
$row['MNG_NOS_US'] = implode(' / ', $mn_arr_u);
|
|
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "getDetailList":
|
|
$sql = "USP_S_SO_S20";
|
|
$params = Array(
|
|
"SO_NO" => $_REQUEST['SO_NO']?:"",
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$row['MNG_NO_OLD'] = $row['MNG_NO'];
|
|
$row['MNG_NO_P'] = substr($row['MNG_NO'], 0, strpos($row['MNG_NO'], '!'));
|
|
$row['DTL_SEQ'] = substr($row['MNG_NO'], strpos($row['MNG_NO'], '!') +1, 4);
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "getOpPartList":
|
|
$sql = "USP_B_OPPART_S10";
|
|
$params = Array(
|
|
"SHAPE_TYPE" => $_REQUEST['SHAPE_TYPE']?:"",
|
|
"PROC_SEQ" => $_REQUEST['PROC_SEQ']?:"",
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
break;
|
|
|
|
case "getInspSpecList":
|
|
$sql = "USP_B_INSTSPEC_S10";
|
|
$params = Array(
|
|
"SHAPE_TYPE" => $_REQUEST['SHAPE_TYPE']?:"",
|
|
"PROC_SEQ" => $_REQUEST['PROC_SEQ']?:"",
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
break;
|
|
|
|
case "getAttList":
|
|
$rst = 1;
|
|
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
}
|
|
break;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
if( !$_REQUEST['no_echo'] ){
|
|
echo json_encode($retval);
|
|
} |