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

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


	include "./../../comon/dbconn_sm.inc";
	$strcd = "300";


//===========================================================================
    $qr = 
		"SELECT PHONENUM, GUBUN, JPNO ".
		"FROM ( ".
			"SELECT PHONENUM, GUBUN, JPNO, MAX(SEQ) LASTSEQ, COUNT(*) CNT ".
			"FROM MOB_OUT_P_SMPL ".
			"GROUP BY PHONENUM, GUBUN, JPNO ) X ".
		"WHERE X.LASTSEQ <> X.CNT ";

   $ret = mssql_query($qr, $dbconn);
   
   while( $row = mssql_fetch_array( $ret ) ) {

	   $phoneNo = $row["PHONENUM"];
	   $gubun = $row["GUBUN"];
	   $jpno = $row["JPNO"];

		$qr2 = 
			"UPDATE MOB_OUT_P_SMPL SET SEQ = B.NEWSEQ ".
			"FROM MOB_OUT_P_SMPL A LEFT OUTER JOIN ( ".
				"SELECT PHONENUM, GUBUN, JPNO, SEQ, ROW_NUMBER() OVER (ORDER BY PHONENUM, GUBUN, JPNO, SEQ) NEWSEQ ".
				"FROM MOB_OUT_P_SMPL WHERE PHONENUM = '$phoneNo' AND GUBUN = '$gubun' AND JPNO = $jpno ) B ON ". 
				"(A.PHONENUM=B.PHONENUM AND A.GUBUN=B.GUBUN AND A.JPNO=B.JPNO AND A.SEQ=B.SEQ) ".
			"WHERE A.PHONENUM='$phoneNo' AND A.GUBUN = '$gubun' AND A.JPNO = $jpno ";

		mssql_query($qr2, $dbconn);

   }


	$arr = array();
	$arr["RET"] = "OK";

go_finish_return:

    $retData = json_encode($arr);

    echo $retData;

    mssql_free_result($ret);
    mssql_close();

?>