forked from HANYANG/HANYANG_MES
442 lines
15 KiB
PHP
442 lines
15 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 "getOrderList":
|
|
$sql = "USP_S_SO_S10P";
|
|
$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']);
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "putOrderList":
|
|
case "putOrderListInEst":
|
|
if( _notAuth("W") ) break; /************ 권한체크*/
|
|
if ($_REQUEST['mode'] == "putOrderListInEst") {
|
|
$_REQUEST['no_echo'] = 1;
|
|
}
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata']);
|
|
$rst = true;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
$data = (array)$data;
|
|
|
|
$cdata = $data;
|
|
unset($cdata['_STATUS_']);
|
|
unset($cdata['SO_TYPE']);
|
|
unset($cdata['USE_FLG']);
|
|
|
|
if( empty(array_filter($cdata)) ){
|
|
if( $data['_STATUS_'] == 'I' ) continue; //빈열제거
|
|
if( $data['_STATUS_'] == 'U' ) $data['_STATUS_'] = 'D'; //빈열제거
|
|
}
|
|
|
|
$chksql = "USP_S_SO_S11"; //CD 중복검사용
|
|
$chkparams = Array( //CD 중복검사용
|
|
$data['SO_NO']
|
|
);
|
|
|
|
if( $data['SO_NO'] && $data['_STATUS_'] == 'D' ){
|
|
$sql = "USP_S_SO_D10";
|
|
$params = Array(
|
|
"SO_NO" => $data['SO_NO'],
|
|
);
|
|
}else{
|
|
if( $data['SO_NO'] && $data['_STATUS_'] == 'U' ) {
|
|
$chkparams[] = $data['SO_NO_OLD']; //CD 중복검사용
|
|
|
|
$sql = "USP_S_SO_U10";
|
|
$params = Array();
|
|
}else{
|
|
$sql = "USP_S_SO_I10";
|
|
$params = Array();
|
|
}
|
|
|
|
$rst = $baseObj->DB->exec($chksql, $chkparams);
|
|
if( $rst ){
|
|
$row = $baseObj->DB->fetch_array($rst);
|
|
if( $data['_STATUS_'] == 'U' && $row['SO_NO'] == $data['SO_NO'] ){
|
|
$rst = 0;
|
|
$retval['mesg'] = cUtil\Mlang::getText("{@1} 는 이미 사용중인 코드입니다.",array($data['SO_NO'])); break;
|
|
}
|
|
}
|
|
|
|
$params = array_merge($params, Array(
|
|
"SO_NO" => $data['SO_NO']?:"",
|
|
"SO_DT" => $data['SO_DT']?:"",
|
|
"SO_TYPE" => $data['SO_TYPE']?:"",
|
|
"SALES_GRP" => $data['SALES_GRP']?:"",
|
|
"SO_PRSN_EMP_NO" => $data['SO_PRSN_EMP_NO']?:"",
|
|
"ORDR_BP_CD" => $data['ORDR_BP_CD'],
|
|
"DLVY_BP_CD" => $data['DLVY_BP_CD'],
|
|
"BILL_BP_CD" => $data['BILL_BP_CD'],
|
|
"DEAL_TYPE" => $data['DEAL_TYPE']?:"",
|
|
"PAY_METH" => $data['PAY_METH']?:"",
|
|
"PAY_TERM_DOWN" => $data['PAY_TERM_DOWN']?:0,
|
|
"PAY_TERM_INTR1" => $data['PAY_TERM_INTR1']?:0,
|
|
"PAY_TERM_INTR2" => $data['PAY_TERM_INTR2']?:0,
|
|
"PAY_TERM_REMD" => $data['PAY_TERM_REMD']?:0,
|
|
"CURRENCY_CD" => $data['CURRENCY_CD']?:"",
|
|
"TRANS_FEE" => $data['TRANS_FEE']?:"N",
|
|
"CUSTOM_FEE" => $data['CUSTOM_FEE']?:"N",
|
|
"SPECFIC_DOC" => $data['SPECFIC_DOC']?:"",
|
|
"CUST_PRSN_NM" => $data['CUST_PRSN_NM']?:"",
|
|
"CUST_EMAIL" => $data['CUST_EMAIL']?:"",
|
|
"CUST_TEL_NO" => $data['CUST_TEL_NO']?:"",
|
|
"CUST_CELL_NO" => $data['CUST_CELL_NO']?:"",
|
|
"CUST_FAX_NO" => $data['CUST_FAX_NO']?:"",
|
|
"CUST_PO_NO" => $data['CUST_PO_NO']?:"",
|
|
"ESTM_NO" => $data['ESTM_NO']?:"",
|
|
"BIZ_AREA_CD" => $data['BIZ_AREA_CD'],
|
|
"SO_STATUS" => $data['SO_STATUS']?:"",
|
|
"REMK" => $data['REMK']?:"",
|
|
"MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
|
|
));
|
|
}
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
}
|
|
|
|
if( $rst ){
|
|
$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'];
|
|
if (strpos($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);
|
|
} else {
|
|
$row['MNG_NO_P'] = $row['MNG_NO'];
|
|
$row['DTL_SEQ'] = '';
|
|
}
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "getOrderDetailList":
|
|
$sql = "USP_S_SO_S30";
|
|
$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']?:"",
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$row['SO_DT'] = date("m월 d일",strtotime($row['SO_DT']));
|
|
$row['REQ_DLVY_DT'] = date("m/d",strtotime($row['REQ_DLVY_DT']));
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "putDetailList":
|
|
if( _notAuth("W") ) break; /************ 권한체크*/
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata']);
|
|
$rst = true;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
$data = (array)$data;
|
|
|
|
$cdata = $data;
|
|
unset($cdata['_STATUS_']);
|
|
unset($cdata['USE_FLG']);
|
|
unset($cdata['SO_NO']);
|
|
|
|
if( empty(array_filter($cdata)) ){
|
|
if( $data['_STATUS_'] == 'I' ) continue; //빈열제거
|
|
if( $data['_STATUS_'] == 'U' ) $data['_STATUS_'] = 'D'; //빈열제거
|
|
}
|
|
|
|
$chksql = "USP_S_SO_S21"; //CD 중복검사용
|
|
$chkparams = Array( //CD 중복검사용
|
|
$data['MNG_NO']
|
|
);
|
|
|
|
if( $data['_STATUS_'] == 'D' ){
|
|
$sql = "USP_S_SO_D20";
|
|
$params = Array(
|
|
"SO_NO" => $data['SO_NO'],
|
|
"SO_SEQ" => $data['SO_SEQ'],
|
|
);
|
|
}else{
|
|
if( $data['SO_SEQ'] && $data['_STATUS_'] == 'U' ) {
|
|
$sql = "USP_S_SO_U20";
|
|
$params = Array();
|
|
}else{
|
|
$rst = $baseObj->DB->exec($chksql, $chkparams);
|
|
if( $rst ){
|
|
$row = $baseObj->DB->fetch_array($rst);
|
|
if( ($row['MNG_NO'] == $data['MNG_NO']) && $row['MNG_NO'] != null ){
|
|
$rst = 0;
|
|
$retval['mesg'] = cUtil\Mlang::getText("{@1} 는 이미 사용중인 수주번호입니다.",array($data['MNG_NO'])); break;
|
|
}
|
|
}
|
|
$sql = "USP_S_SO_I20";
|
|
$params = Array();
|
|
}
|
|
if ($data['MNG_NO_P']) {
|
|
$data['MNG_NO'] = $data['MNG_NO_P'];
|
|
}
|
|
if ($data['MNG_NO_P'] && $data['DTL_SEQ']) {
|
|
$data['MNG_NO'] = $data['MNG_NO_P']."!".$data['DTL_SEQ'];
|
|
}
|
|
|
|
$params = array_merge($params, Array(
|
|
"SO_NO" => $data['SO_NO']?:"",
|
|
"SO_SEQ" => $data['SO_SEQ']?:0,
|
|
"MNG_NO" => $data['MNG_NO']?:null,
|
|
"ITEM_CD" => $data['ITEM_CD']?:"",
|
|
"OUT_DIA" => $data['OUT_DIA']?:0,
|
|
"IN_DIA" => $data['IN_DIA']?:0,
|
|
"THICK" => $data['THICK']?:0,
|
|
"WIDTH" => $data['WIDTH']?:0,
|
|
"LENGTH" => $data['LENGTH']?:0,
|
|
"MATR_TYPE" => $data['MATR_TYPE']?:"",
|
|
"REQ_DLVY_DT" => $data['REQ_DLVY_DT']?:"",
|
|
"DLVY_BP_CD" => $data['DLVY_BP_CD']?:"",
|
|
"SO_QTY" => $data['SO_QTY']?:0,
|
|
"SO_UNIT" => $data['SO_UNIT']?:"",
|
|
"CURRENCY_CD" => $data['CURRENCY_CD']?:"",
|
|
"XCH_RATE" => $data['XCH_RATE']?:0,
|
|
"SO_PRICE_LOC" => $data['SO_PRICE_LOC']?:0,
|
|
"SO_PRICE" => $data['SO_PRICE']?:0,
|
|
"SO_NET_AMT_LOC" => $data['SO_NET_AMT_LOC']?:0,
|
|
"SO_NET_AMT" => $data['SO_NET_AMT']?:0,
|
|
"PWR_WGT" => $data['PWR_WGT']?:0,
|
|
"PWR_UNT" => $data['PWR_UNT']?:"",
|
|
"UNIT_WGT" => $data['UNIT_WGT']?:0,
|
|
"WGT_UNIT" => $data['WGT_UNIT']?:"",
|
|
"SHAPE_TYPE" => $data['SHAPE_TYPE']?:"",
|
|
"ITEM_NRULE" => $data['ITEM_NRULE']?:"N",
|
|
"REMK" => $data['REMK']?:"",
|
|
"MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
|
|
"RMK1" => $data['RMK1']?:"",
|
|
"RMK2" => $data['RMK2']?:"",
|
|
"RMK3" => $data['RMK3']?:"",
|
|
"RMK4" => $data['RMK4']?:"",
|
|
"RMK_ETC" => $data['RMK_ETC']?:"",
|
|
"REVNO" => $data['REVNO']?:"",
|
|
"CPRNO" => $data['CPRNO']?:"",
|
|
"CHANGE_DATE" => $data['CHANGE_DATE']?:"",
|
|
"CHANGE_DTL" => $data['CHANGE_DTL']?:"",
|
|
"MNG_GRD" => $data['MNG_GRD']?:"",
|
|
"PROC_GRD" => $data['PROC_GRD']?:"",
|
|
"CLASSIFICATION" => $data['CLASSIFICATION']?:"",
|
|
"PRESENCE" => $data['PRESENCE']?:"",
|
|
"HEAT_TREATMENT" => $data['HEAT_TREATMENT']?:"",
|
|
"APPROVAL" => $data['APPROVAL']?:"",
|
|
"EST_DTL_ID" => $data['EST_DTL_ID']?:"",
|
|
));
|
|
}
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
}
|
|
|
|
if( $rst ){
|
|
$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 "putOpPartList":
|
|
if( _notAuth("W") ) break; /************ 권한체크*/
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata']);
|
|
$rst = true;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
$data = (array)$data;
|
|
|
|
$cdata = $data;
|
|
unset($cdata['_STATUS_']);
|
|
unset($cdata['USE_FLG']);
|
|
|
|
if( empty(array_filter($cdata)) ){
|
|
if( $data['_STATUS_'] == 'I' ) continue; //빈열제거
|
|
if( $data['_STATUS_'] == 'U' ) $data['_STATUS_'] = 'D'; //빈열제거
|
|
}
|
|
|
|
if( $data['PROC_SEQ'] && $data['_STATUS_'] == 'D' ){
|
|
$sql = "USP_B_OPPART_D10";
|
|
$params = Array(
|
|
"PROC_SEQ" => $data['PROC_SEQ'],
|
|
);
|
|
}else{
|
|
$sql = "USP_B_OPPART_U10";
|
|
$params = Array(
|
|
"SHAPE_TYPE" => $data['SHAPE_TYPE']?:"",
|
|
"PROC_SEQ" => $data['PROC_SEQ']?:"",
|
|
"PROC_CD" => $data['PROC_CD']?:"",
|
|
"PART_CD" => $data['PART_CD']?:"",
|
|
"USE_FLG" => $data['USE_FLG']?:"",
|
|
"MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
|
|
);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
}
|
|
}
|
|
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
}
|
|
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 "putInspSpecList":
|
|
if( _notAuth("W") ) break; /************ 권한체크*/
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata']);
|
|
$rst = true;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
$data = (array)$data;
|
|
|
|
$cdata = $data;
|
|
unset($cdata['_STATUS_']);
|
|
unset($cdata['USE_FLG']);
|
|
|
|
if( empty(array_filter($cdata)) ){
|
|
if( $data['_STATUS_'] == 'I' ) continue; //빈열제거
|
|
if( $data['_STATUS_'] == 'U' ) $data['_STATUS_'] = 'D'; //빈열제거
|
|
}
|
|
|
|
if( $data['PROC_SEQ'] && $data['_STATUS_'] == 'D' ){
|
|
$sql = "USP_B_INSTSPEC_D10";
|
|
$params = Array(
|
|
"SHAPE_TYPE" => $data['SHAPE_TYPE']?:"",
|
|
"PROC_SEQ" => $data['PROC_SEQ'],
|
|
);
|
|
}else{
|
|
$sql = "USP_B_INSTSPEC_U10";
|
|
$params = Array(
|
|
"SHAPE_TYPE" => $data['SHAPE_TYPE'],
|
|
"PROC_SEQ" => $data['PROC_SEQ'],
|
|
"PROC_CD" => $data['PROC_CD'],
|
|
"STD_INSP_ITEM" => $data['ITEM_CD']?:"",
|
|
"INSP_METH" => $data['INSP_METH']?:"",
|
|
"STD_TOL_UPPER" => $data['STD_TOL_UPPER']?:"",
|
|
"STD_TOL_LOWER" => $data['STD_TOL_LOWER']?:"",
|
|
"USE_FLG" => $data['USE_FLG']?:"",
|
|
"MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
|
|
);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
}
|
|
}
|
|
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
}
|
|
break;
|
|
|
|
case "getAttList":
|
|
$rst = 1;
|
|
|
|
if( $rst ){
|
|
$retval['code'] = 1;
|
|
}
|
|
break;
|
|
|
|
case "getRmkStr":
|
|
$sql = "USP_GET_SO_DTL_RMK_STR";
|
|
$params = [];
|
|
$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;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
if( !$_REQUEST['no_echo'] ){
|
|
echo json_encode($retval);
|
|
} |