<?
//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"]; 
	$with_list = $params["withlist"];
    $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 = 
	"DELETE FROM MIACTH ".
		"FROM MIACTH A ". 
			"LEFT JOIN (SELECT DISTINCT STR_CODE, ACT_DATE, GONDORA, ACT_NO FROM MIACTP) B ". 
				"ON (A.STR_CODE=B.STR_CODE AND A.ACT_DATE=B.ACT_DATE AND A.GONDORA=B.GONDORA AND A.ACT_NO = B.ACT_NO) ".
	"WHERE A.SET_CHG = '$pn' AND B.ACT_DATE IS NULL  ";
   $ret = mssql_query($qr, $dbconn);


//     "SELECT ACT_DATE, ACT_NO, ACT_QTY_TOT, ACT_AMT_TOT, SET_IND, SET_DATE, SET_FLAG  FROM MIACTH ".
   $qr = 
     "SELECT ACT_DATE, ACT_NO, ACT_QTY_TOT, ACT_AMT_TOT  FROM MIACTH ".
     "WHERE STR_CODE = '$strcd' AND ACT_DATE = '$actdt' AND GONDORA = '0000' AND SET_CHG = '$pn'"; 

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

   $actNo = 0;

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

	if ($row = mssql_fetch_array( $ret )) {
		$actNo = $row["ACT_NO"];
		$arr["ACT_DATE"] = $row["ACT_DATE"];
		$arr["ACT_NO"] = $actNo;
		$arr["ACT_QTY_TOT"] = $row["ACT_QTY_TOT"];
		$arr["ACT_AMT_TOT"] = $row["ACT_AMT_TOT"];
		//$arr["SET_IND"] = $row["SET_IND"];
		//$arr["SET_DATE"] = $row["SET_DATE"];
		//$arr["SET_FLAG"] = $row["SET_FLAG"];
	}
	else {
		$arr["ACT_DATE"] = "";
		$arr["ACT_NO"] =  0;
		$arr["ACT_QTY_TOT"] =  0;
		$arr["ACT_AMT_TOT"] =  0;
		//$arr["SET_IND"] =  "0";
		//$arr["SET_DATE"] =  "";
		//$arr["SET_FLAG"] =  "0";
	}
    
	$arr["SCANQTY"] = 0;


	mssql_free_result($ret);

   $qr =   
      "SELECT COUNT(*) ROWCNT ".
      "FROM MIACTP WHERE STR_CODE = '$strcd' AND ACT_DATE = '$actdt' AND GONDORA = '0000' AND ACT_NO = $actNo";

   $ret = mssql_query($qr, $dbconn);
   $cnt = mssql_num_rows($ret);
   if ($cnt > 0) {
      
      if ($row = mssql_fetch_array( $ret )) {
		 $arr["SCANQTY"] = $row["ROWCNT"];
      }

   }

   if ($with_list == "Y") {

		$qr = 
		"SELECT TOP 50 ACT_DATE, ACT_NO, ACT_QTY_TOT, ACT_COST_TOT, ACT_AMT_TOT ".
		"FROM MIACTH ".
		"WHERE STR_CODE = '$strcd' AND ACT_DATE > '' AND GONDORA >= '' AND ACT_NO >= 0  AND SET_CHG = '$pn' ".
		"ORDER BY ACT_DATE DESC ";

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

		if ($cnt > 0) {
			$arr["RET"] = "OK";
			$arr["DATECNT"] = $cnt;

			$dataArray = array();

			while( $row = mssql_fetch_array( $ret ) ) {
				$rowAry = array();
				$rowArray["ACTDT"] = $row["ACT_DATE"];
				$rowArray["ACTNO"] = $row["ACT_NO"];
				$rowArray["TQTY"] = $row["ACT_QTY_TOT"];
				$rowArray["TCOST"] = $row["ACT_COST_TOT"];
				$rowArray["TAMT"] = $row["ACT_AMT_TOT"];
			
				array_push($dataArray, $rowArray);
			}

			$arr["DATA"] = $dataArray;


		}

   }

go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>