<?
//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"]; 
	$actseq = $params["actseq"]; 
	$itmcd = $params["itmcd"]; 
	$barcd = $params["barcd"]; 
	$actqty = $params["actqty"]; 
	$mode = $params["mode"]; 
    $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 = "";
    if ($mode == "NEW") {
		$qr = "INSERT INTO MIACTP ".
			"SELECT STR_CODE, '$actdt' ACT_DATE, '0000' GONDORA, $actno ACT_NO, $actseq ACT_SEQ, '3' ACT_IND, '000' LOC_NO, ITM_CODEX POS_CODE, '' CHK_DGT, '0' LIC_IS, ".
				"0 TIE_IND, 0 TIE_QTY, ITM_CODE, 0 ITM_SPCODE, ITM_FLAG, TAX_ID, GRP_CODE, DPT_CODE, LINE_CODE, VEN_CODE, $actqty ACT_QTYA, ".
				"MIN_SIZE*$actqty ACT_COST, UP_SALE*$actqty ACT_AMTS, 0 ACT_AMTD, UP_BOT*$actqty ACT_AMTX, UP_BOX*$actqty ACT_AMTY, $actqty ACT_QTY, ".
				"0 UP_TSALE, 0 UP_DSALE, 0 UP_ASALE, 0 UP_ABOT, 0 UP_ABOX, MIN_SIZE UP_COST, UP_SALE, UP_BOT, UP_BOX, '0' BOT_TYPE, '0' SET_IND, ".
				"'0' SET_FLAG, '0' IN_IND, '$dt' LMNT_DATE, '$tm' LMNT_TIME, 'MOB' LMNT_CHG ".
			"FROM MMSTMM WHERE STR_CODE = '$strcd'  AND ITM_CODE = $itmcd ";
	}
	else if ($mode == "UPDATE") {
		$qr = 
			"UPDATE MIACTP SET ACT_QTYA=$actqty, ACT_QTY=$actqty, TAX_IND=B.TAX_ID, GRP_CODE=B.GRP_CODE, DPT_CODE=B.DPT_CODE, LINE_CODE=B.LINE_CODE, ".
			      "VEN_CODE=B.VEN_CODE, ACT_COST=B.MIN_SIZE*$actqty, ACT_AMTS=B.UP_SALE*$actqty, ACT_AMTX=B.UP_BOT*$actqty, ACT_AMTY=B.UP_BOX*$actqty, ".
				  "UP_COST=B.MIN_SIZE, UP_SALE=B.UP_SALE, UP_BOT=B.UP_BOT, UP_BOX=B.UP_BOX ".
		      "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 AND A.ITM_CODE=$itmcd ";
	}
	else if ($mode == "DELETE") {
		$qr = "DELETE FROM MIACTP WHERE STR_CODE='$strcd' AND ACT_DATE='$actdt' AND GONDORA='0000' AND ACT_NO=$actno AND ACT_SEQ=$actseq ";
	}
	else {
		$qr = "";
	}

	// echo $qr;

	if (strlen($qr) > 0) {
		$ret = mssql_query($qr, $dbconn);
//		$cnt = mssql_affected_rows();
	}
	else {
		$ret = false;
//		$cnt = 0;
	}

//	if ( $ret && $cnt > 0 ) {
	if ( $ret ) {
		$arr["RET"] = "OK";
		$arr["ERMSG"]="";
	}
	else {
		$arr["RET"] = "ER_NO";
		$arr["ERMSG"]=urlencode("저장오류 입니다.");
	}

	if ($arr["RET"] == "OK") {
		$qr = 
			"UPDATE MIACTH SET ACT_QTY_TOT = B.TOTQTY, ACT_COST_TOT=B.TOTCOST, ACT_AMT_TOT = B.TOTAMT, ACT_AMTX_TOT=B.TOTAMTX, ACT_AMTY_TOT=B.TOTAMTY ".
			  "FROM MIACTH A LEFT OUTER JOIN ".
			     "(SELECT STR_CODE, ACT_DATE, GONDORA, ACT_NO, SUM(ACT_QTY) TOTQTY,  SUM(ACT_COST) TOTCOST, SUM(ACT_AMTS) TOTAMT, SUM(ACT_AMTX) TOTAMTX, SUM(ACT_AMTY) TOTAMTY ".
			      "FROM MIACTP ".
			      "WHERE STR_CODE = '$strcd' AND ACT_DATE = '$actdt' AND GONDORA = '0000' AND ACT_NO = $actno ".
					"GROUP BY STR_CODE, ACT_DATE, GONDORA, ACT_NO) 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.STR_CODE = '$strcd' AND A.ACT_DATE = '$actdt' AND A.GONDORA = '0000' AND A.ACT_NO = $actno ";

		$ret = mssql_query($qr, $dbconn);
	}

go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>