<?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);
}