<?
//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"]; 
	$gubun = trim($params["gubun"]); 
    $pn = $params["pn"]; 

	if ($pn === $myTestPhoneNumber) {
	    $ip = $myTestIp;
		$port = $myTestPort;
		$strcd = $myTestStrCd;
	}
	include "./../comon/dbconn.inc";

	$arr = array();

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


	$arr["RET"] = "";
	$arr["ROWCNT"] = 0;
	$arr["ERMSG"]="";

//===========================================================================
   $qr = "SELECT ISNULL(MAX(JPNO), 0) + 1 JPNO FROM MOB_PUR_H_SMPL WHERE PHONENUM = '$pn' AND GUBUN= '$gubun'";
   $ret = mssql_query($qr, $dbconn);

   if (!$ret) {
		$arr["RET"] = "ER";
		$arr["ROWCNT"] = 0;
		$arr["ERMSG"] = urlencode("전표생성 오류입니다.1");
		goto go_finish_return;
   }

   if (!($row = mssql_fetch_array( $ret ))) {
		$arr["RET"] = "ER";
		$arr["ROWCNT"] = 0;
		$arr["ERMSG"] = urlencode("전표생성 오류입니다.2");
		goto go_finish_return;
   }

   $jpno = $row["JPNO"];
   $venName = "";

   mssql_free_result($ret);
	$dty = date("Y"); 
	$dtm = date("m"); 
	$dtd = date("d"); 
	$dt= $dty.$dtm.$dtd;

	if (strlen($vencd) > 0) {
		$qr = "SELECT  CONVERT(VARBINARY(200), VEN_NAME)  VEN_NAME  FROM MMSVEM WHERE STR_CODE='$strcd' AND VEN_CODE='$vencd'";
		$ret = mssql_query($qr, $dbconn);
		if($ret) {
			if ($row = mssql_fetch_array( $ret )) {
				$venName = $row["VEN_NAME"];
			}
		}
	}


   $ins = "INSERT INTO MOB_PUR_H_SMPL ".
				"(PHONENUM, GUBUN, JPNO, VENCD, DATACNT, TOTCNT, TOTAMT, MKDT, UPDT, PURDT, ADEL, SRSVD1, SRSVD2, IRSVD1, IRSVD2) ".
		  "VALUES('$pn', '$gubun', $jpno, '$vencd', 0, 0, 0, '$dt', '$dt', '', '0', '', '', 0, 0)";

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

   if ($ret) {
		$arr["RET"] = "OK";
		$arr["ROWCNT"] = 1;
		$arr["ERMSG"]="";
		$arr["GUBUN"]=$gubun;
		$arr["JPNO"]=$jpno;
		$arr["VENCD"]=$vencd;
		$arr["VENNM"]=BinToKor($venName);

		$arr["DATACNT"] = 0;
		$arr["TOTCNT"] = 0;
		$arr["TOTAMT"] = 0;
		$arr["MKDT"] = $dt;
   }
   else {
		$arr["RET"] = "ER";
		$arr["ROWCNT"] = 0;
		$arr["ERMSG"] = urlencode("전표생성 오류입니다.3");
   }

go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>