HANYANG_MES/home_dir/www/ksvc_old/base/process/process.ajax.php

<?php
$cate_id = "BASE_PROC"; //현재 메뉴 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 "getProcList":
      $params = Array("SHAPE_TYPE" => $_REQUEST['SHAPE_TYPE']);
      switch ( $_REQUEST['PROC_TYPE'] ) {
        case "SPARE":
          $sql = "USP_B_PROC_SPARE_S10";
          break;
        case "TURN":
          $sql = "USP_B_PROC_TURN_S10";
          break;
        case "HOLE":
          $sql = "USP_B_PROC_HOLE_S10";
          break;
        case "RATE":
          $sql = "USP_B_PROC_RATE_S10";
          break;
        case "WTAMT":
          $sql = "USP_B_PROC_WTAMT_S10";
          break;
      }
      $rst = $baseObj->DB->exec($sql, $params);
    
      $rows = array();
      if( $rst ){
        $retval['code'] = true;
        while( $row = $baseObj->DB->fetch_array($rst) ){
          $rows[] = $row;
        }
        $retval['data'] = $rows;
      }
      $retval['code'] = 1;
    break;


    case "putProcList":
      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['PK_NO'] && $data['_STATUS_'] == 'D' ){
          switch ( $data['PROC_TYPE'] ) {
            case "SPARE":
              $sql = "USP_B_PROC_SPARE_D10";
              break;
            case "TURN":
              $sql = "USP_B_PROC_TURN_D10";
              break;
            case "HOLE":
              $sql = "USP_B_PROC_HOLE_D10";
              break;
            case "RATE":
              $sql = "USP_B_PROC_RATE_D10";
              break;
            case "WTAMT":
              $sql = "USP_B_PROC_WTAMT_D10";
              break;
          }
          $params = Array(
            "PK_NO" => $data['PK_NO'],
          );
        }else{
          if( $data['PK_NO'] && $data['_STATUS_'] == 'U' ) {
            switch ( $data['PROC_TYPE'] ) {
              case "SPARE":
                $sql = "USP_B_PROC_SPARE_U10";
                $params = Array(
                  "PK_NO" => $data['PK_NO'],
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "OUT_DIA" => $data['OUT_DIA'],
                  "IN_DIA" => $data['IN_DIA'],
                  "THICK" => $data['THICK'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "TURN":
                $sql = "USP_B_PROC_TURN_U10";
                $params = Array(
                  "PK_NO" => $data['PK_NO'],
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "ROUGH_TURN" => $data['ROUGH_TURN'],
                  "ROUGH_FEED" => $data['ROUGH_FEED'],
                  "FINISH_TURN" => $data['FINISH_TURN'],
                  "FINISH_FEED" => $data['FINISH_FEED'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "HOLE":
                $sql = "USP_B_PROC_HOLE_U10";
                $params = Array(
                  "PK_NO" => $data['PK_NO'],
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "HOLE_FEED" => $data['HOLE_FEED'],
                  "HOLE_TURN_ST" => $data['HOLE_TURN_ST'],
                  "HOLE_TURN_ED" => $data['HOLE_TURN_ED'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "RATE":
                $sql = "USP_B_PROC_RATE_U10";
                $params = Array(
                  "PK_NO" => $data['PK_NO'],
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "TM_RATE" => $data['TM_RATE'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "WTAMT":
                $sql = "USP_B_PROC_WTAMT_U10";
                $params = Array(
                  "PK_NO" => $data['PK_NO'],
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "START_WGT" => $data['START_WGT'],
                  "END_WGT" => $data['END_WGT'],
                  "UNIT_PRICE" => $data['UNIT_PRICE'],
                  "UNIT_AMT" => $data['UNIT_AMT'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
            }
          }else{
            switch ( $data['PROC_TYPE'] ) {
              case "SPARE":
                $sql = "USP_B_PROC_SPARE_I10";
                $params = Array(
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "OUT_DIA" => $data['OUT_DIA'],
                  "IN_DIA" => $data['IN_DIA'],
                  "THICK" => $data['THICK'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "TURN":
                $sql = "USP_B_PROC_TURN_I10";
                $params = Array(
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "ROUGH_TURN" => $data['ROUGH_TURN'],
                  "ROUGH_FEED" => $data['ROUGH_FEED'],
                  "FINISH_TURN" => $data['FINISH_TURN'],
                  "FINISH_FEED" => $data['FINISH_FEED'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "HOLE":
                $sql = "USP_B_PROC_HOLE_I10";
                $params = Array(
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "HOLE_FEED" => $data['HOLE_FEED'],
                  "HOLE_TURN_ST" => $data['HOLE_TURN_ST'],
                  "HOLE_TURN_ED" => $data['HOLE_TURN_ED'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "RATE":
                $sql = "USP_B_PROC_RATE_I10";
                $params = Array(
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "TM_RATE" => $data['TM_RATE'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
              case "WTAMT":
                $sql = "USP_B_PROC_WTAMT_I10";
                $params = Array(
                  "SHAPE_TYPE" => $data['SHAPE_TYPE'],
                  "START_SIZE" => $data['START_SIZE'],
                  "END_SIZE" => $data['END_SIZE'],
                  "START_WGT" => $data['START_WGT'],
                  "END_WGT" => $data['END_WGT'],
                  "UNIT_PRICE" => $data['UNIT_PRICE'],
                  "UNIT_AMT" => $data['UNIT_AMT'],
                  "REMK" => $data['REMK'],
                  "USER_ID" => $GLOBALS['_Umem']['member_id'],
                );
                break;
            }
          }
        }
        $rst2 = $baseObj->DB->exec($sql, $params);
        if( $rst2 ) $ok_cd[] = $data['PK_NO'];
        $rst = $rst && $rst2;
      }

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



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