<?
//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"]; 
	$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;
	}

//===========================================================================
/*
   $incName = false;	
   if ($simple = "Y") {
	   $qr = 
			"SELECT GUBUN, JPNO, VENCD, DATACNT, TOTCNT, TOTAMT, MKDT ".
			  "FROM MOB_PUR_H_SMPL ".
			"WHERE PHONENUM = '$pn' AND GUBUN='$gubun' AND ADEL = '0' AND (PURDT IS NULL OR PURDT = '') ";
	   $incName = false;	
   }
   else {
	   $qr = 
			"SELECT A.GUBUN, A.JPNO, A.VENCD, B.VEN_NAME, A.DATACNT, A.TOTCNT, A.TOTAMT, A.MKDT ".
			"FROM MOB_PUR_H_SMPL A LEFT OUTER JOIN MMSVEM B ON (A.VENCD = B.VEN_CODE AND B.STR_CODE = (SELECT TOP 1 STR_CODE FROM MMSTRM WHERE STR_CODE > '000') ) ".
			"WHERE A.PHONENUM = '$pn' AND A.GUBUN = '$gubun' AND A.ADEL = '0' AND (A.PURDT IS NULL OR A.PURDT = '')"; 
	   $incName = true;	
   }
*/

   if ($gubun == "ALL" || $gubun == "A") {
	   $qr = 
			"SELECT A.GUBUN, A.JPNO, A.VENCD, B.VEN_NAME, A.DATACNT, A.TOTCNT, A.TOTAMT, A.MKDT ".
			"FROM MOB_PUR_H_SMPL A LEFT OUTER JOIN MMSVEM B ON (A.VENCD = B.VEN_CODE AND B.STR_CODE = (SELECT TOP 1 STR_CODE FROM MMSTRM WHERE STR_CODE > '000') ) ".
			"WHERE A.PHONENUM = '$pn' AND A.ADEL = '0' AND (A.PURDT IS NULL OR A.PURDT = '')"; 
   }
   else {
	   $qr = 
			"SELECT A.GUBUN, A.JPNO, A.VENCD, B.VEN_NAME, A.DATACNT, A.TOTCNT, A.TOTAMT, A.MKDT ".
			"FROM MOB_PUR_H_SMPL A LEFT OUTER JOIN MMSVEM B ON (A.VENCD = B.VEN_CODE AND B.STR_CODE = (SELECT TOP 1 STR_CODE FROM MMSTRM WHERE STR_CODE > '000') ) ".
			"WHERE A.PHONENUM = '$pn' AND A.GUBUN = '$gubun' AND A.ADEL = '0' AND (A.PURDT IS NULL OR A.PURDT = '')"; 
   }


   $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["VENCD"] = $row["VENCD"];
		$rowArray["VENNM"] = urlencode($row["VEN_NAME"]);
		//if ( $incName ) {
		//	$rowArray["VENNM"] = urlencode($row["VEN_NAME"]);
		//}
		$rowArray["DATACNT"] = $row["DATACNT"];
		$rowArray["TOTCNT"] = $row["TOTCNT"];
		$rowArray["TOTAMT"] = $row["TOTAMT"];
		$rowArray["MKDT"] = $row["MKDT"];
//		$rowArray["UPDT"] = $row["UPDT"];

		array_push($dataArray, $rowArray);
	}

    $arr["DATA"] = $dataArray;

go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>