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


//===========================================================================
	$dt = date("Ymd");
	$tm = date("His");

   $qr = 
     "SELECT ISNULL(MAX(ACT_NO), 0) + 1 ACTNO FROM MIACTH ".
     "WHERE STR_CODE = '$strcd' AND ACT_DATE = '$actdt' AND GONDORA = '0000' AND SET_CHG = '$pn'"; 

//	 echo $qr;

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

   $actNo = 0;

	if ($ret) {
		$row = mssql_fetch_array( $ret );
		$actNo = $row["ACTNO"];

		mssql_free_result($ret);

		$qr = 
			"INSERT INTO MIACTH (STR_CODE, ACT_DATE, GONDORA, ACT_NO, ACT_IND, ACT_QTY_TOT, ACT_COST_TOT, ".
                    "ACT_AMT_TOT, ACT_AMTX_TOT, ACT_AMTXY_TOT, ACT_AMTY_TOT, ACT_AMTZ_TOT, ".
					"SET_IND, SET_CHG, SET_DATE, SET_TIME, SET_FLAG, LMNT_DATE, LMNT_TIME, LMNT_CHG) ".
			"VALUES ('$strcd', '$actdt', '0000', $actNo, '3', 0, 0, 0, 0, 0, 0, 0, '0', '$pn', '$dt', '$tm', '0', '$dt', '$tm', 'MOB')";

		//echo $qr;

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

		if (!$ret) { $actNo = 0; }

	}


	if ($actNo > 0) {
		$arr["RET"] = "OK";
		$arr["ACTNO"] = $actNo;
		$arr["ERMSG"]="";
	}
	else {
		$arr["RET"] = "NODATA";
		$arr["ACTNO"] = 0;
		$arr["ERMSG"]=urlencode("재고전표 생성오류.");
	}


go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>