<?
//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 = $params["gubun"]; 
	$jpno = $params["jpno"]; 
	$simple = $params["smpl"]; 
    $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;
	}

//===========================================================================
/*
UPDATE MOB_PUR_H_SMPL SET DATACNT = B.DATACNT, TOTCNT = B.TOTCNT, TOTAMT = B.PURAMT
FROM MOB_PUR_H_SMPL A LEFT OUTER JOIN (
	SELECT PHONENUM, GUBUN, JPNO, COUNT(*) DATACNT, SUM(QTY) TOTCNT, ROUND(SUM(UCOST), 2) PURAMT 
	FROM MOB_PUR_P_SMPL WHERE PHONENUM = '01046489201' AND GUBUN = '1' AND JPNO = 1
	GROUP BY PHONENUM, GUBUN, JPNO) B ON (A.PHONENUM=B.PHONENUM AND A.GUBUN=B.GUBUN AND A.JPNO=B.JPNO)
WHERE A.PHONENUM='01046489201' AND A.GUBUN = '1' AND A.JPNO = 1
*/

   $qr = 
		"SELECT A.GUBUN, A.JPNO, A.SEQ, A.ITMCD, B.ITM_NAME, B.ITM_SPEC, A.BARCD, A.EVT , ROUND(A.MCOST, 2) MCOST, ROUND(A.UCOST, 2) UCOST, A.MSPRC, A.USPRC, A.QTY, A.PURAMT, A.MKDT, ".
		       "ISNULL(C.INV_QTY, 0) INV_QTY ".
		  "FROM MOB_PUR_P_SMPL A LEFT OUTER JOIN MMSTMM B On (A.ITMCD = B.ITM_CODE AND B.STR_CODE = (SELECT TOP 1 STR_CODE FROM MMSTRM WHERE STR_CODE > '000') ) ".
		                        "LEFT OUTER JOIN MIRINM C ON (C.STR_CODE = B.STR_CODE AND C.ITM_CODE = B.ITM_CODE) ".
		 "WHERE A.PHONENUM = '$pn' AND GUBUN = '$gubun' AND JPNO = $jpno "; 


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

	if ($cnt > 0) {
		$arr["RET"] = "OK";
		$arr["ROWCNT"] = $cnt;
		$arr["ERMSG"]="";
	}
	else {
		$arr["RET"] = "NODATA";
		$arr["ROWCNT"] = 0;
		$arr["ERMSG"]=urlencode("자료가 없습니다.");
		goto go_finish_return;
	}

	$dataArray = array();


    while( $row = mssql_fetch_array( $ret ) ) {
		$rowAry = array();
		$rowArray["GUBUN"] = $row["GUBUN"];
		$rowArray["JPNO"] = $row["JPNO"];
		$rowArray["SEQ"] = $row["SEQ"];
		$rowArray["ITMCD"] = $row["ITMCD"];

		if ($ip === "121.148.198.224") {
		   $rowArray["ITMNM"] = urlencode($row["ITM_NAME"].":".$row["ITM_SPEC"]);
	    }
		else {
		   $rowArray["ITMNM"] = urlencode($row["ITM_NAME"]);
		}
//		$rowArray["ITMNM"] = urlencode($row["ITM_NAME"]);

		$rowArray["BARCD"] = $row["BARCD"];
		$rowArray["EVT"] = $row["EVT"];
		$rowArray["MCOST"] = $row["MCOST"];
		$rowArray["UCOST"] = $row["UCOST"];
		$rowArray["MSPRC"] = $row["MSPRC"];
		$rowArray["USPRC"] = $row["USPRC"];
		$rowArray["QTY"] = $row["QTY"];
		$rowArray["PURAMT"] = $row["PURAMT"];
		$rowArray["MKDT"] = $row["MKDT"];
		$rowArray["INVQTY"] = $row["INV_QTY"];

		array_push($dataArray, $rowArray);
	}

    $arr["DATA"] = $dataArray;

go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>