<?
//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"]; 
	$actdt = $params["actdt"]; 
	$actno = $params["actno"]; 
    $pn = $params["pn"]; 

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

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

	$arr = array();

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


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


   $qr = 
      "SELECT A.ACT_SEQ, A.POS_CODE, A.ITM_CODE, A.ACT_QTYA, B.MIN_SIZE, B.UP_SALE, B.ITM_NAME ". 
      "FROM MIACTP A LEFT OUTER JOIN MMSTMM B ON (A.STR_CODE = B.STR_CODE AND A.ITM_CODE = B.ITM_CODE) ". 
      "WHERE A.STR_CODE = '$strcd' AND A.ACT_DATE = '$actdt' AND A.GONDORA = '0000' AND A.ACT_NO = $actno";

   $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["ASEQ"] = $row["ACT_SEQ"];
		$rowArray["BARCD"] = $row["POS_CODE"];
		$rowArray["ITMCD"] = $row["ITM_CODE"];
		$rowArray["QTY"] = $row["ACT_QTYA"];
		$rowArray["COST"] = $row["MIN_SIZE"];
		$rowArray["SPRC"] = $row["UP_SALE"];
		$rowArray["ITMNM"] = urlencode($row["ITM_NAME"]);

		array_push($dataArray, $rowArray);
	}

    $arr["DATA"] = $dataArray;


go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>