<?
//http://nrsysmob.cafe24.com/_nrsys/feesale/feesaletot.php

	error_reporting(0);

	header("Content-Type: text/html; charset=euc-kr");
	include "./../comon/comon.php";

	$urlData = $_GET["dat"];

    $params = __DecryptParams($urlData);

	$ip = $params["ip"]; 
	$port = $params["port"]; 
	$strcd = $params["stcd"];
	$cmd = strtoupper($params["cmd"]);
	$gubun = $params["gubun"]; 
	$type = $params["type"]; 
	$key = $params["key"];  
	$orgSeq = $params["seq"];  
	$itmcd=$params["itmcd"];  
	$barcd=$params["barcd"];  
	$qty=$params["qty"];  
	$evt=$params["evt"];  
	if (in_array("price", $params)) {
		$price=$params["price"];   
	}
	else {
		$price=0;   
	}
    $pn = $params["pn"]; 
	$keyStrUTF = urldecode($params["keystr"]);
	$keyStr = trim( iconv("utf8", "euc-kr",$keyStrUTF) );


	if ($pn === $myTestPhoneNumber) {
	    $ip = $myTestIp;
		$port = $myTestPort;
		$strcd = $myTestStrCd;
	}


	include "./../comon/dbconn.inc";

	$arr = array();

    if ( permissionCheck($dbconn, $pn, "PRINTBAR") == false ) {
		$arr["RET"] = "ER_PM";
		$arr["ROWCNT"] = 0;
		$arr["ERMSG"] = urlencode("권한이 없습니다.");
		goto go_finish_return;
	}

    $dt = date("Ymd");   


//===========================================================================

   if (strlen($keyStr) == 0) {
		$qr = 
			"SELECT ISNULL(MAX(KEYSTR), '') KEYSTR ".
			"FROM MOB_DATA_ETC " .
			"WHERE PHONENUM = '$pn' AND GUBUN = '$gubun' AND ATYPE = '$type' AND AKEY = $key";

		$ret = mssql_query($qr, $dbconn);

	    if (!$ret) {
			$arr["RET"] = "EROPEN";
			$arr["ROWCNT"] = 0;
			$arr["ERMSG"]=urlencode("자료검색 오류입니다-KEYSTR.");
			goto go_finish_return;
	    }

	    $row = mssql_fetch_array( $ret );
		$keyStr = trim( $row["KEYSTR"] );
	
		if (strlen($keyStr) == 0) {
			$keyStr = date("Y-m-d H:i");
		}
   }


//===========================================================================


   if ($cmd == "NEW") {	

	   $qr = 
			"SELECT ISNULL(MAX(SEQ), 0)+1 SEQ ".
			"FROM MOB_DATA_ETC " .
			"WHERE PHONENUM = '$pn' AND GUBUN = '$gubun' AND ATYPE = '$type' AND AKEY = $key";

	   $ret = mssql_query($qr, $dbconn);

	   if (!$ret) {
			$arr["RET"] = "EROPEN";
			$arr["ROWCNT"] = 0;
			$arr["ERMSG"]=urlencode("자료검색 오류입니다..");
			goto go_finish_return;
	   }

	   $row = mssql_fetch_array( $ret );
	   $seq = $row["SEQ"];

		mssql_free_result($ret);


	   $qr = "INSERT INTO MOB_DATA_ETC ".
		     "(PHONENUM, GUBUN, ATYPE, AKEY, SEQ, ITMCD, BARCD, EVT, MCOST, MSPRC, QTY, SUMAMT, MKDT, UPDT, KEYSTR, SDATA1, SDATA2, IDATA1, IDATA2, RDATA1, RDATA2, ADEL) ".
			 "VALUES ".
			 "('$pn', '$gubun', '$type', $key, $seq, $itmcd, '$barcd', '$evt', 0, 0, $qty, 0, '$dt', '$dt', '$keyStr', '', '', $price, 0, 0, 0, '0')";


   }
   else if ($cmd == "EDIT") {
	   $seq = $orgSeq;

	   $qr = "UPDATE MOB_DATA_ETC SET QTY=$qty, IDATA1=$price, UPDT='$dt' ".
		      "WHERE PHONENUM='$pn' AND GUBUN='$gubun' AND ATYPE= '$type' AND AKEY=$key AND SEQ=$seq ";
   }
   else if ($cmd == "DELETE") {
	   $seq = $orgSeq;

	   $qr = "DELETE FROM MOB_DATA_ETC ".
		      "WHERE PHONENUM='$pn' AND GUBUN='$gubun' AND ATYPE= '$type' AND AKEY=$key AND SEQ=$seq ";
   }
   
   
   $ret = mssql_query($qr, $dbconn);
   if (!$ret) {
		$arr["RET"] = "ERSAVE";
		$arr["ROWCNT"] = 0;
		$arr["ERMSG"]=urlencode("자료저장 오류입니다..");
		goto go_finish_return;
   }

   $qr = "UPDATE MOB_DATA_ETC SET KEYSTR='$keyStr' ".
	      "WHERE PHONENUM='$pn' AND GUBUN='$gubun' AND ATYPE='$type' AND AKEY=$key AND KEYSTR <> '$keyStr' ";
   $ret = mssql_query($qr, $dbconn);


	$arr["RET"] = "OK";
	$arr["ROWCNT"] = 1;
	$arr["SEQ"]=$seq;
	$arr["ERMSG"]="";


go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>