DB->exec($sql); $rows = array(); if( $rst ){ $retval['code'] = true; while( $row = $baseObj->DB->fetch_array($rst) ){ $row['BIZ_AREA_CD_OLD'] = $row['BIZ_AREA_CD']; $row['WORK_STD_TIME'] = getDT_datetime($row['WORK_STD_TIME'],"H:i"); $rows[] = $row; } $retval['data'] = $rows; } $retval['code'] = 1; break; case "putBizarea": if( _notAuth("W") ) break; /************ 권한체크*/ $_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata']); $rst = true; $ok_cd = array(); 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['BIZ_AREA_CD']) { $retval['mesg'] = cUtil\Mlang::getText("사업장코드가 누락된 행은 반영되지 않았습니다."); $rst=false; break; } else if(!$data['BIZ_AREA_NM']) { $retval['mesg'] = cUtil\Mlang::getText("사업장명이 누락된 행은 반영되지 않았습니다."); $rst=false; break; } $chksql = "USP_B_BIZ_AREA_S20"; //CD 중복검사용 $chkparams = Array( //CD 중복검사용 $data['BIZ_AREA_CD'] ); if( $data['BIZ_AREA_CD'] && $data['_STATUS_'] == 'D' ){ $sql = "USP_B_BIZ_AREA_D10"; $params = Array( "BIZ_AREA_CD" => $data['BIZ_AREA_CD'], ); }else{ if( $data['BIZ_AREA_CD'] && $data['_STATUS_'] == 'U' ) { $chkparams[] = $data['BIZ_AREA_CD_OLD']; //CD 중복검사용 $sql = "USP_B_BIZ_AREA_U10"; $params = Array( "BIZ_AREA_CD_OLD" => $data['BIZ_AREA_CD_OLD'] ); }else{ $sql = "USP_B_BIZ_AREA_I10"; $params = Array(); } $rst = $baseObj->DB->exec($chksql, $chkparams); if( $rst ){ $row = $baseObj->DB->fetch_array($rst); if( $row['BIZ_AREA_CD'] == $data['BIZ_AREA_CD'] ){ $rst = 0; $retval['mesg'] = cUtil\Mlang::getText("{@1} 는 이미 사용중인 코드입니다.",array($data['BIZ_AREA_CD'])); break; } } $params = array_merge($params, Array( "BIZ_AREA_CD" => $data['BIZ_AREA_CD']?:"", "BIZ_AREA_NM" => $data['BIZ_AREA_NM']?:"", "HQ_FLG" => $data['HQ_FLG']?:"", "BIZ_AREA_BP_CD" => $data['BIZ_AREA_BP_CD'], "WORK_STD_TIME" => $data['WORK_STD_TIME'], "STD_CURRENCY_CD" => $data['STD_CURRENCY_CD'], "USE_FLG" => $data['USE_FLG']?:"Y", "MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'], )); } $rst2 = $rst && $baseObj->DB->exec($sql, $params); if( $rst2 ) $ok_cd[] = $data['BIZ_AREA_CD']; $rst = $rst && $rst2; } $retval['data'] = $ok_cd; if( $rst ){ $retval['code'] = 1; } break; } } if( !$_REQUEST['no_echo'] ){ echo json_encode($retval); }