<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?
$table_names = "user_cash";
		/***
		수정일 : 2018-09-13
		넘어온회원의 user_cash데이터는 없지만 유료회원(10)일때가 있다.
		이때 시작일과 마감일은 이전마감일 데이터를 구하여 업데이트해 넣어줘야함.
		$idx = user_cash
		$midx = user
		user 테이블에 있는 auth_code 10
		m_startdate m_enddate 의 기간을 비교하여 넣는다.
		***/
if($idx){
	if($mode == D){
		$qry = Get_dbres("select * from user where id = '$midx'");
		$row = mysql_fetch_array($qry);
		$mCode = $row[member_code];
		$benddate = $row[m_enddate];

		if($benddate && $row[auth_code] == 10){
			$end_arr = explode("-",$benddate);
			$end_time = mktime(0,0,0,$end_arr[1], $end_arr[2], $end_arr[0]);
			$now_time = mktime(0,0,0,date("m"), date("d"), date("Y"));
			$giganCount = ($end_time - $now_time)/86400;

		}else{
			$giganCount =-1;
		}
		//echo $giganCount;

		if($giganCount >= 0){
			#유료회원 기간이 남아있다면.. m_enddate 날짜에 기간 플러스함.
			$end_arr = explode("-",$benddate);
			$tmpyearn = $end_arr[0];
			$tmpyearp=$end_arr[0]+1;
			$time =mktime(0, 0, 0, $end_arr[1], '01', $end_arr[0]);
			$beforeMonth = date("Y-m-d",strtotime("+1 month", $time));
			$beforeMonthArr	= explode("-",$beforeMonth);
			$tmp_start_date = $tmpyearn."-".$beforeMonthArr[1]."-01";

			$end_day = date("t", mktime(0, 0, 0, $end_arr[1], 1, $tmpyearp)); //윤달로 인한 마지막날 변경 20200206 신정철
			$tmp_end_date = $tmpyearp."-".$end_arr[1]."-".$end_day;

			$whereDate1 =",startdate='$tmp_start_date',enddate='$tmp_end_date'";
			$whereDate2 =",m_startdate='$tmp_start_date',m_enddate='$tmp_end_date'";



		}else{
			#유료회원 기간이 없다면.. 입금완료일의 월의 1일로 시작일이되고 ,enddate는 이 시작일의 전달 의 말일로 된다.
			//$today="2018-03-15";
			$todayArr = explode("-",$today);
			$tmp_start_date = $todayArr[0]."-".$todayArr[1]."-01";
			$time =mktime(0, 0, 0, $todayArr[1], $todayArr[2], $todayArr[0]);
			$beforeMonth = date("Y-m-d",strtotime("-1 month", $time));
			$beforeMonthArr	= explode("-",$beforeMonth);

			if($todayArr[1] == "01"){
				$tmpyearp= $todayArr[0];
			}else{
				$tmpyearp= $todayArr[0]+1;
			}

			$end_day = date("t", mktime(0, 0, 0, $beforeMonthArr[1], 1, $tmpyearp));
			$tmp_end_date = $tmpyearp."-".$beforeMonthArr[1]."-".$end_day;

			$whereDate1 =",startdate='$tmp_start_date',enddate='$tmp_end_date'";
			$whereDate2 =",m_startdate='$tmp_start_date',m_enddate='$tmp_end_date'";

		}

		//회원번호가 있다면 그대로 쓰기..20150502
		if(!$mCode){
			$member_code  = get_db("select max(member_code) from user where activated = 1"); //정회원번호주기
			$numberVal = substr($member_code, 3, 6)+1;
			//SV03400 번 부터 시작 루크코리아 번호 시작하자.20180910
			if($numberVal <= 101) $numberVal= 101;//첫번째 들어갈 사람위해
			$member_code = "XIA".sprintf("%05d",$numberVal);
		}else{
			 $member_code=$mCode;
		}
		//echo $member_code;
		//exit;

		//캐쉬 결제
		$adminIP = $_SERVER["REMOTE_ADDR"];
		$cash_cnt = get_db("SELECT count(user_id) FROM user_cash where user_id='$midx' and flag='D'")+1;
		$queryupok = "update $table_names set flag = '$mode' ,inning='$cash_cnt',admin_id='$HTTP_SESSION_VARS[S_ID]' ,admin_date=now() , admin_ip='$adminIP' $whereDate1 where id = '$idx'";
		$queryupok_result = mysql_query($queryupok,$db_con);
		//echo "<br>";

		//member table 결재 정보 수정
		$queryupok = "update user set auth_code = '10',cash_chk='$idx',cash_cnt='$cash_cnt' $whereDate2 ,member_code='$member_code' where id = '$midx'";
		$queryupok_result = mysql_query($queryupok,$db_con);
	}else if($mode=='C'){
		//캐쉬 결제
		$queryupok = "update $table_names set flag = '$mode',refund_date='now()' where id = '$idx'";
		$queryupok_result = mysql_query($queryupok,$db_con);

		$auth_code = 3;
		$cash_chk = "";
		$m_startdate = "";
		$m_enddate = "";
		//$member_code  = get_db("select member_code from user where id = '$midx'");

		//member table 결재 정보 수정
		$queryupok = "update user set auth_code = '$auth_code',cash_chk='$cash_chk',m_startdate='$m_startdate',m_enddate='$m_enddate' where id = '$midx'";
		$queryupok_result = mysql_query($queryupok,$db_con);

	}else if($mode=='A'){
		//캐쉬 결제
		$queryupok = "update $table_names set flag = '$mode' ,inning='',startdate='',enddate='',admin_id='',admin_date='' where id = '$idx'";
		$queryupok_result = mysql_query($queryupok,$db_con);

		//이전 결제 처리
		$beforeCash = Get_dbres("select * from $table_names where flag = 'D' and user_id = '$midx' order by id desc");
		$row = mysql_fetch_array($beforeCash);
		if($row[id] && $today < $row[enddate]){
			$auth_code = 10;
			$cash_chk = $row[id];
			$m_startdate = $row[startdate];
			$m_enddate = $row[enddate];
		}else{
			$auth_code = 3;
			$cash_chk = "";
			$m_startdate = "";
			$m_enddate = "";
		}

		$member_code  = get_db("select member_code from user where id = '$midx'");

		//member table 결재 정보 수정
		$queryupok = "update user set auth_code = '$auth_code',cash_chk='$cash_chk',m_startdate='$m_startdate',m_enddate='$m_enddate' ,member_code='$member_code' where id = '$midx'";
		$queryupok_result = mysql_query($queryupok,$db_con);

	}//mode

		$pathURL="../memberlist1.php?act=4&key=$key&key_word=$key_word";

}else{
		$pathURL="../memberlist.php?act=1";
}//idx
//exit;

?>
<script>
//alert("保存しました.");
parent.location.href = "<?=$pathURL?>";
</script>