<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?
$table_names = "user_cash";

if($idx){
	if($mode == D){
		$benddate = get_db("SELECT enddate FROM user_cash where user_id='$midx' and flag='D' order by id desc");
		if($benddate){
			$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 =0;
		}
		if($giganCount >= 1){
			//연장건
			//echo $giganCount." 기간 +++";
			$member_code=$mCode;
			$end_arr = explode("-",$benddate);
			$tmpyearn = $end_arr[0];
			$tmpyearp=$end_arr[0]+1;
			$tmp_start_date = $tmpyearn."-".$end_arr[1]."-".$end_arr[2];
			$tmp_end_date = $tmpyearp."-".$end_arr[1]."-".$end_arr[2];
			$whereDate1 =",startdate='$tmp_start_date',enddate='$tmp_end_date'";
			$whereDate2 =",m_startdate='$tmp_start_date',m_enddate='$tmp_end_date'";

		}else{
			//신규건
			//echo $giganCount." 기간 ---";
			$member_code  = get_db("select max(member_code) from user where activated = 1")+1; //정회원번호주기
			//윤달로 인한 날짜수정.
			$tmpStartDate = $Today;
			$tmpEndDate = date("Y-m-d",strtotime("+12 month", time()));
			$whereDate1 =",startdate='$tmpStartDate',enddate='$tmpEndDate'";
			$whereDate2 =",m_startdate='$tmpStartDate',m_enddate='$tmpEndDate'";
		}
		//캐쉬 결제
		$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);

		//캐쉬 카운트


		//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);

		/*
		//module_name 2 jyj, mode 2- 정회원 가입 정보 메일
		$mail_qry = Get_dbres("SELECT * FROM user where id='$idx'");
		$row = mysql_fetch_array($mail_qry);

		$mail_qry		= "SELECT * FROM mail_form where module_name = 2 and mode = 2";
		$mresult	= mysql_query($mail_qry,$db_con);
		$rows		= mysql_fetch_array($mresult);

		$message = $row[jname2]."様<br>";
		//$message .= "会員番号 : ".$row[member_code]."<br>";
		$message .= "会員期間 : ".$row[m_startdate]."~".$row[m_enddate]."<br>";
		$message .= $rows[contents];

		$to_email = $row[email]; //받는사람

		$title = $rows[subject];
		$from_email = $rows[from_email];
		$from_name = $rows[from_email]; //송신자 명

		$from .= "From: JYJ Japan Official Website<".$from_email.">\n";
		$from .= "Return-Path: <".$from_email.">\n";
		$from .= "Content-Type: text/html; charset=UTF-8";
		$enc = iconv("UTF-8", "ISO-2022-JP", $title);
		$subject = "=?ISO-2022-JP?B?".base64_encode($enc) ."?=";
		//mail("$to_email", "$subject", "$message", "$from");
		*/
  //신규 카페 회원정보 등록
  if($giganCount ==0){

    $QUERY_PAGE  = "SELECT * FROM  user where auth_code = 10 and id ='$midx'";
    $result= mysql_query($QUERY_PAGE,$db_con);

    //신규 db 연결 부분
    $db_host_1 = "localhost";
    $db_user_1 = "queenjbs";
    $db_pass_1 = "jbs5642";
    $db_name_1 = "sihooCafe";
    $db_con_1 = mysql_connect($db_host_1, $db_user_1, $db_pass_1) or die(mysql_error());
    $db_sel_1 = mysql_select_db($db_name_1, $db_con_1) or die(mysql_error());

    while($row = mysql_fetch_array($result)) {
     $mailArr  = explode("@","$row[email]");
     /*회원 삽입*/
     $userID = 'cafe_'.$row[userid];

     $QUERY_DB1  = "SELECT member_srl FROM  `xe_member` where member_srl = '$row[id]'";
     $results= mysql_query($QUERY_DB1,$db_con_1);
     $rows = mysql_fetch_array($results);
     if(!$rows[member_srl]){
     $insert_query="INSERT INTO `xe_member` (`member_srl`, `user_id`, `email_address`, `password`, `email_id`, `email_host`, `user_name`, `nick_name`, `homepage`, `blog`, `birthday`, `allow_mailing`, `allow_message`, `denied`, `limit_date`, `regdate`, `last_login`, `is_admin`, `description`, `extra_vars`) VALUES
    ($row[id], '$userID', '$row[email]_', '$row[password]', '$mailArr[0]', '$mailArr[1]', '$row[nickname]_', '$row[nickname]_', '', '', '', 'N', 'N', 'N', '', '', '', 'N', '', '')";
     mysql_query($insert_query,$db_con_1);

     echo "idx : ".$row[id]." ID :".$userID."<br>";
     //echo "$insert_query <br>";

     }

    }
  }

	}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);

		$cash_cnt = get_db("SELECT count(user_id) FROM user_cash where user_id='$midx' and flag='D'");
		if($row[id] && $today < $row[enddate]){
			$auth_code = 10;
			$cash_chk = $row[id];
			$m_startdate = $row[startdate];
			$m_enddate = $row[enddate];
			$member_code  = get_db("select member_code from user where id = '$midx'");
		}else{

			$auth_code = 3;
			$cash_chk = "";
			$m_startdate = "";
			$m_enddate = "";
			$member_code = "";
		}


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

	}

		$pathURL="../memberlist1.php?act=4&key=$key&key_word=$key_word";
	}else{
		$pathURL="../memberlist.php?act=1";
	}
?>
<script>
//alert("保存しました.");
parent.location.href = "<?=$pathURL?>";
</script>