HANYANG_MES/show_dir/www/ksvc/base/facility/facility.ajax.php

<?php
$cate_id = "BASE_FACILITY"; //현재 메뉴 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 "getFacilityList":
      $sql = "USP_B_FACILITY_S10";
      $rst = $baseObj->DB->exec($sql);

      $rows = array();
      if( $rst ){
        $retval['code'] = true;
        while( $row = $baseObj->DB->fetch_array($rst) ){
          $row['FACLT_CD_OLD'] = $row['FACLT_CD'];
          $row['PUR_DT'] = $row['PUR_DT'] ? getDT_date($row['PUR_DT']) : null;
          $rows[] = $row;
        }
        $retval['data'] = $rows;
      }
      $retval['code'] = 1;
    break;

    case "getRepairInfo":
      $sql = "USP_B_FACILITY_S20";
      $params = Array(
        $_REQUEST['FACLT_CD'],
      );
      $rst = $baseObj->DB->exec($sql, $params);
      if( $rst ){
        $retval['data'] = $baseObj->DB->fetch_array($rst);
        $retval['data']['FACLT_CD_OLD'] = $retval['data']['FACLT_CD'];

        $sql = "USP_ZB_ATTACH_S10";
        $params = Array(
          "file_id" => $_REQUEST['file_id'],
          "gubun"   => "faclt",
          "nid"     => $_REQUEST['FACLT_CD'],
        );
        $rst2 = $baseObj->DB->exec($sql, $params);
        if( $rst2 ){
          $retval['data']['ATT'] = [];
          while( $fr = $baseObj->DB->fetch_array($rst2) ){
            $retval['data']['ATT'][$fr['sid']] = $fr;
          }
        }

        $sql = "USP_B_FACILITY_HST_S10";
        $params = Array(
          $_REQUEST['FACLT_CD'],
          'Y'
        );
        $rst3 = $baseObj->DB->exec($sql, $params);
        if( $rst3 ){
          $retval['code'] = 1;
          $rows = Array();
          while( $row = $baseObj->DB->fetch_array($rst3) ){
            $row['REPAIR_DT'] = $row['REPAIR_DT'] ? getDT_date($row['REPAIR_DT']) : null;
            $rows[] = $row;
          }
          $retval['data']['REPAIR'] = $rows;
        }
      }
    break;

    case "setFacility":
        if( _notAuth("D") ) break; /************ 권한체크*/

    case "putFacility":
      if( _notAuth("W") ) break; /************ 권한체크*/

      if( !$_REQUEST['FACLT_CD'] ){
        $retval['mesg'] = cUtil\Mlang::getText("설비코드를 입력하지 않았습니다."); break;
      }else if( !$_REQUEST['FACLT_NM'] ){
        $retval['mesg'] = cUtil\Mlang::getText("설비명을 입력하지 않았습니다."); break;
      }

      $chksql = "USP_B_FACILITY_S20"; //CD 중복검사용
      $chkparams = Array( //CD 중복검사용
        $_REQUEST['FACLT_CD']
      );

      if( $_REQUEST['mode'] == "setFacility" ){
        $chkparams[] = $_REQUEST['FACLT_CD_OLD']; //CD 중복검사용

        $sql = "USP_B_FACILITY_U10";
        $params = Array();
      }else{
        $sql = "USP_B_FACILITY_I10";
        $params = Array();
      }

      $rst = $baseObj->DB->exec($chksql, $chkparams);

      if( $rst ){
        $row = $baseObj->DB->fetch_array($rst);
        if( $row['FACLT_CD'] == $_REQUEST['FACLT_CD'] ){
          $retval['mesg'] = cUtil\Mlang::getText("{@1} 는 이미 사용중인 코드입니다.",array($_REQUEST['FACLT_CD'])); break;
        }
      }

      $params = array_merge($params, Array(
        "FACLT_CD"          => $_REQUEST['FACLT_CD']?:"",
        "FACLT_NM"          => $_REQUEST['FACLT_NM']?:"",
        "FACLT_MNG_NO"      => $_REQUEST['FACLT_MNG_NO']?:"",
        "MAJR_EMP_NO"       => $_REQUEST['MAJR_EMP_NO']?:"",
        "MINR_EMP_NO"       => $_REQUEST['MINR_EMP_NO']?:"",
        "PUR_BP_NM"         => $_REQUEST['PUR_BP_NM']?:"",
        "PUR_DT"            => $_REQUEST['PUR_DT']?:null,
        "PUR_REPRE_NM"      => $_REQUEST['PUR_REPRE_NM']?:"",
        "PUR_PRSN_NM"       => $_REQUEST['PUR_PRSN_NM']?:"",
        "PUR_TEL_NO"        => $_REQUEST['PUR_TEL_NO']?:"",
        "MAKER_NM"          => $_REQUEST['MAKER_NM']?:"",
        "INTNL_USE_DEPT_CD" => $_REQUEST['INTNL_USE_DEPT_CD']?:"",
        "FACLT_SPEC"        => $_REQUEST['FACLT_SPEC']?:"",
        "FACLT_TYPE"        => $_REQUEST['FACLT_TYPE']?:"",
        "PURPOS_USAGE"      => $_REQUEST['PURPOS_USAGE']?:"",
        "MANUL_FLG"         => $_REQUEST['MANUL_FLG']?:"",
        "USE_FLG"           => $_REQUEST['USE_FLG']?:"N",
        "SORT_IDX"          => $_REQUEST['SORT_IDX']?:0,
        "MAKE_USER_ID"      => $GLOBALS['_Umem']['member_id'],
      ));
      $rst = $baseObj->DB->exec($sql, $params);

      if( $rst ){
        $att_obj = new Sk_Attach(TB_attach_list);
        if( $_FILES['FACLT_IMG']['name'] ){
          $att_obj->putAttach($_FILES['FACLT_IMG'], "faclt", $_REQUEST['FACLT_CD'], "image");
        }
        if( $_FILES['FACLT_MANUAL']['name'] ){
          $att_obj->putAttach($_FILES['FACLT_MANUAL'], "faclt", $_REQUEST['FACLT_CD'], "manual");
        }

        $_REQUEST['REPAIR'] = json_decode($_REQUEST['REPAIR']);
        foreach( $_REQUEST['REPAIR'] as $repair ){
          $repair = (array)$repair;
          if( $repair['_STATUS_'] == 'I' && $repair['USE_FLG'] != "Y" ) continue;
          $data = $repair;

          unset($data['_STATUS_']);
          unset($data['USE_FLG']);
          if( empty(array_filter($data)) ){
            if( $repair['_STATUS_'] == 'I' ) continue; //빈열제거
            if( $repair['_STATUS_'] == 'U' ) $repair['_STATUS_'] = 'D'; //빈열제거
          }

          if( $repair['SEQ'] && $repair['_STATUS_'] == 'D' ){
            $sql = "USP_B_BIZ_PARTNER_PRSN_D10";
            $params = Array(
              "BP_CD"      => $_REQUEST['BP_CD'],
              "BP_PRSN_ID" => $repair['BP_PRSN_ID'],
            );
          }else{
            if( $repair['SEQ'] && $repair['_STATUS_'] == 'U' ) {
              $sql = "USP_B_FACILITY_HST_U10";
              $params = Array("SEQ" => $repair['SEQ']);
            }else{
              $sql = "USP_B_FACILITY_HST_I10";
              $params = Array();
            }

            $params = array_merge($params, Array(
              "FACLT_CD"      => $_REQUEST['FACLT_CD'],
              "REPAIR_DT"     => $repair['REPAIR_DT']?:null,
              "REPAIR_DESC"   => $repair['REPAIR_DESC']?:"",
              "REPAIR_AMT"    => $repair['REPAIR_AMT']?:"",
              "REPAIR_CORP"   => $repair['REPAIR_CORP']?:"",
              "REPAIR_TEL_NO" => $repair['REPAIR_TEL_NO']?:"",
              "USE_FLG"       => $repair['USE_FLG']?:"N",
              "MAKE_USER_ID"  => $GLOBALS['_Umem']['member_id'],
            ));
          }
          $rst = $rst && $baseObj->DB->exec($sql, $params);
        }

        if( $rst ){
          $retval['code'] = 1;
        }
      }
    break;
  }
}

if( !$_REQUEST['no_echo'] ){
  echo json_encode($retval);
}