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

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

      $rows = array();
      if( $rst ){
        $retval['code'] = true;
        while( $row = $baseObj->DB->fetch_array($rst) ){
          $row['PUR_DATE'] = getDT_date($row['PUR_DATE']);
          $row['JIG_CD_OLD'] = $row['JIG_CD'];
          $rows[] = $row;
        }
        $retval['data'] = $rows;
      }
      $retval['code'] = 1;
    break;


    case "putJig":
      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['JIG_CD']) { $retval['mesg'] = cUtil\Mlang::getText("단말기코드가 누락된 행은 반영되지 않았습니다."); $rst=false; break; }

        $chksql = "USP_B_JIG_S20"; //CD 중복검사용
        $chkparams = Array( //CD 중복검사용
          $data['JIG_CD']
        );

        if( $data['JIG_CD'] && $data['_STATUS_'] == 'D' ){
          $sql = "USP_B_JIG_D10";
          $params = Array(
            "JIG_CD"     => $data['JIG_CD'],
          );
        }else{
          if( $data['JIG_CD'] && $data['_STATUS_'] == 'U' ) {
            $chkparams[] = $data['JIG_CD_OLD']; //CD 중복검사용

            $sql = "USP_B_JIG_U10";
            $params = Array();
          }else{
            $sql = "USP_B_JIG_I10";
            $params = Array();
          }

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

          $params = array_merge($params, Array(
            "JIG_CD"       => $data['JIG_CD']?:"",
            "JIG_NM"       => $data['JIG_NM']?:"",
            "JIG_MODEL"    => $data['JIG_MODEL']?:"",
            "JIG_NUM"      => $data['JIG_NUM']?:"",
            "JIG_MF"       => $data['JIG_MF']?:"",
            "PUR_NM"       => $data['PUR_NM']?:"",
            "PUR_PRICE"    => $data['PUR_PRICE']?:"",
            "PUR_DATE"     => $data['PUR_DATE']?:"",
            "USE_FLG"      => $data['USE_FLG']?:"",
            "MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
          ));
        }
        $rst2 = $baseObj->DB->exec($sql, $params);
        if( $rst2 ) $ok_cd[] = $data['JIG_CD'];
        $rst = $rst && $rst2;
      }

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




    case "getJigHstList":
      $sql = "USP_B_JIG_HST_S10";
      $params = Array(
        "JIG_CD" => $_REQUEST['JIG_CD'],
      );
      $rst = $baseObj->DB->exec($sql, $params);

      $rows = array();
      if( $rst ){
        $retval['code'] = true;
        while( $row = $baseObj->DB->fetch_array($rst) ){
          $row['JIG_ADATE'] = getDT_date($row['JIG_ADATE']);
          $row['JIG_ODATE'] = getDT_date($row['JIG_ODATE']);
          $row['JIG_IDATE'] = getDT_date($row['JIG_IDATE']);
          $row['JIG_REF_CD_OLD'] = $row['JIG_REF_CD'];
          $rows[] = $row;
        }
        $retval['data'] = $rows;
      }
      $retval['code'] = 1;
    break;


    case "putJigHst":
      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['JIG_REF_CD'] && $data['_STATUS_'] == 'D' ){
          $sql = "USP_B_JIG_HST_D10";
          $params = Array(
            "JIG_REF_CD"     => $data['JIG_REF_CD'],
          );
        }else{
          if( $data['JIG_CD'] && $data['_STATUS_'] == 'U' ) {
            $sql = "USP_B_JIG_HST_U10";
            $params = Array();
          }else{
            $sql = "USP_B_JIG_HST_I10";
            $params = Array();
          }

          $params = array_merge($params, Array(
            "JIG_REF_CD"   => $data['JIG_REF_CD']?:"",
            "JIG_CD"       => $data['JIG_CD']?:"",
            "JIG_REASON"   => $data['JIG_REASON']?:"",
            "JIG_REPAIR"   => $data['JIG_REPAIR']?:"",
            "JIG_ADATE"    => $data['JIG_ADATE']?:"",
            "JIG_A_EMP_NO" => $data['JIG_A_EMP_NO']?:"",
            "JIG_ODATE"    => $data['JIG_ODATE']?:"",
            "JIG_IDATE"    => $data['JIG_IDATE']?:"",
            "REMK"         => $data['REMK']?:"",
            "USE_FLG"      => $data['USE_FLG']?:"",
            "MAKE_USER_ID" => $GLOBALS['_Umem']['member_id'],
          ));
        }
        $rst2 = $baseObj->DB->exec($sql, $params);
        if( $rst2 ) $ok_cd[] = $data['JIG_REF_CD'];
        $rst = $rst && $rst2;
      }

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

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