<?
error_reporting(0);
include 'myfunc.php';
$cell = 0;
$login = 0;
      if (isset($_GET['c'])){
	     if (isset($_GET['pass'])&&!empty($_GET['pass'])) {
			$q = "SELECT pass FROM customers WHERE cell='".$_GET['c']."'";
			$re = mysqli_query($link, $q) ;
			$pass = mysqli_fetch_array($re);
			if (!empty($pass)){
						if ($pass[0] == $_GET['pass'])	{
					$login = 1;
					setcookie("pass", $_GET['pass'], time()+24*60*60);
					$cell = $_GET['c'];
				}	
			}
	     } else if (isset($_COOKIE['pass'])){
		$q = "SELECT pass FROM customers WHERE cell='".$_GET['c']."'";
		$re = mysqli_query($link, $q) ;
		$pass = mysqli_fetch_array($re);
		if (!empty($pass)){
	                if ($pass[0] == $_COOKIE['pass'])	{
				$login = 1;
				$cell = $_GET['c'];
			}
			    
		}
	    }
        }
$m = "";
if ($login == 1){
	$q = "SELECT * FROM customers WHERE cell='".$_GET['c']."'";
	$re = mysqli_query($link, $q) ;
	$info = mysqli_fetch_assoc($re);
	 $cell = $_GET['c'];
	 $city = $info['city'];
	 $q = "SELECT timezone FROM subarea WHERE subcity='".$city."'||city='".$city."'";
	 $res = mysqli_query($link, $q) ;
	 $timezone = mysqli_fetch_array($res);
	 date_default_timezone_set("America/".$timezone[0]."");
	 
	 if (isset($_GET['stage'])){
	 if ($_GET['stage'] == -1) {
		 $q = "UPDATE customers SET stage='-1' WHERE cell='".$cell."'";
		  mysqli_query($link, $q) ;
		  $info['stage'] = -1;
	 }}
	 
  if (isset($_POST['newlocation_submit'])){
	  $q = "UPDATE customers SET storeid='".$_POST['newlocation_submit']."' WHERE cell='".$cell."'";
	  mysqli_query($link, $q) ;
  }
  if (isset($_POST['city_submit'])){
	  if (!empty($_POST['city'])){
		  $city = $_POST['city'];
		 $q = "SELECT timezone FROM subarea WHERE subcity='".$city."'||city='".$city."'";
		  $res = mysqli_query($link, $q) ;
		  $timezone = mysqli_fetch_array($res);
		  date_default_timezone_set("America/".$timezone[0]."");
		  $id = Store_Find($city, 0, $link);
		  mysqli_query($link, "UPDATE customers SET city='".$city."', storeid='".$id."', stage='1' WHERE cell='".$cell."'");
		  $q = "SELECT id FROM adsphonelist WHERE storeid='".$id."'";
		  $res1 = mysqli_query($link, $q) ;
		  while ( $rw2 = mysqli_fetch_row($res1) ){ 
			  $id_arr[] = $rw2[0];
		  }
		  $k = rand(0, count($id_arr)-1);
		 // Message_Send("hi, you have changed your meetup city to ".$city." in which I am, I am available now.", $cell, $id_arr[$k], $link);
		  $q = "SELECT * FROM customers WHERE cell='".$_GET['c']."'";
		  $re = mysqli_query($link, $q) ;
		  $info = mysqli_fetch_assoc($re);
	  }
  }
      $q = "SELECT id FROM adsphonelist WHERE storeid='".$info['storeid']."' LIMIT 0,1";
	  $res = mysqli_query($link, $q) ;
	  $adsphoneid = mysqli_fetch_array($res);
	  
	  if (isset($_POST['outcall_submit'])){
		  $msg = "外卖信息： cell:".$cell.", hotel:".$_POST['hotel'].", address:".$_POST['address'].", suite:".$_POST['suite'].", time:".$_POST['arrival'].", City: ".$_POST['city'];
		//  $q = "INSERT INTO wechatmsg VALUES ('', 'frxgoeasy', '".addslashes($msg)."', '".date('Y-m-d H:i')."', '0')";
		  $q = "INSERT INTO message VALUES ('', '17783888125', '".$adsphoneid[0]."', '".addslashes($msg)."', '".date('Y-m-d H:i')."', '0')";	
		  mysqli_query($link, $q) ;
		  $msg = "Your outcall inquiry has been received.";
		  $q = "INSERT INTO message VALUES ('', '".$cell."', '".$adsphoneid[0]."', '".addslashes($msg)."', '".date('Y-m-d H:i')."', '0')";	
		  mysqli_query($link, $q) ;
		  $q = "UPDATE customers SET rept='".($info['rept']+1)."' WHERE cell='".$cell."'";
		  mysqli_query($link, $q) ;
		  $m = "Your outcall inquiry has been received.";
	  }
	  if (isset($_POST['arrive_submit'])){
		  Arrival_Notice($_POST['arrive_submit'], date('Y-m-d H:i'), $link);
		  $q = "UPDATE customers SET rept='".($info['rept']+1)."' WHERE cell='".$cell."'";
		  mysqli_query($link, $q) ;
		 }
	  
	  if (isset($_POST['Newappt_submit'])){
                   $d = $_POST['estTime'];
				 
				  if (time() < strtotime($d)+30*60){
						  $q = "SELECT id FROM appt WHERE status<='1'&&customercell='".$cell."'&&intime>='".date('Y-m-d H:i', time()-4*60*60)."' ORDER BY id DESC LIMIT 0, 1";
						  $re = mysqli_query($link, $q) ;
						  $id = mysqli_fetch_array($re);
						  if (!empty($id[0])){
							  $q = "UPDATE appt SET intime='".$d."', status='0' WHERE id='".$id[0]."'";
							  mysqli_query($link, $q) ;
					  } else {
						$q = "INSERT INTO appt VALUES ('', '".$cell."', '".$info['storeid']."', '', '', '".$d."', '0', '0')";
						mysqli_query($link, $q) ;
						$q = "UPDATE customers SET rept='1' WHERE cell='".$cell."'";
						  mysqli_query($link, $q) ;
						$q = "SELECT userid FROM girlprofile WHERE storeid='".$info['storeid']."'";
						$re = mysqli_query($link, $q) ;
						while ( $rw = mysqli_fetch_row($re) ){
							$q = "SELECT id, cell, logincode, wechat FROM users WHERE id='".$rw[0]."'";
							$res = mysqli_query($link, $q) ;
							  $girlinfo = mysqli_fetch_array($res); 
							$msg = date('m-d H:i', strtotime($d))." 有人到，他的电话尾号是：".substr($cell, -4).", 点击此链接查看预约动态：https://pva799.com/meet/?cell=".$girlinfo[1]."&passcode=".$girlinfo[2];
							$q = "UPDATE users SET expiry='".date('Y-m-d H:i', time()+12*60*60)."' WHERE id='".$girlinfo[0]."'";
							mysqli_query($link, $q) ;
						//	if (!empty($girlinfo[3])){
						//	   $q = "INSERT INTO wechatmsg VALUES ('', '".$girlinfo[3]."', '".addslashes($msg)."', '".date('Y-m-d H:i')."', '0')";
						//	   mysqli_query($link, "SET NAMES utf8");
						//	   mysqli_query($link, $q) ;
						//	}
							   if (strpos($girlinfo[1], "E") !== false)
								   $tonum = substr($girlinfo[1], 0, strlen($manager[0])-2); 
							  else $tonum = $girlinfo[1];
							  $q = "INSERT INTO message VALUES ('', '".$tonum."', '".$adsphoneid[0]."', '".addslashes($msg)."', '".date('Y-m-d H:i')."', '0')";	  
							  mysqli_query($link, "SET NAMES utf8");
							  mysqli_query($link, $q) ;
						  }			  
				  } $m = "New appointment info has been received.";
				  if (strtotime($d) - time() >= 4*60*60)
					  $t = "is made and confirmed.";
				  else $t = "is made, see you soon. ";
				  $msg = "Your appointment at ".date('m-d H:i', strtotime($d))." ".$t." When you arrive, you may either come to the website to tap the button *I am here* or text *I am here* to me. See the incall location on the website.";
				//  Message_Send($msg, $cell, $adsphoneid[0], $link);
				   mysqli_query($link, "UPDATE customers SET stage='2' WHERE cell='".$cell."'", $link) or die(mysql_error());			   
				  } else { Message_Send("Do you need help with the booking?", $cell, $adsphoneid[0], $link); }
	  }
  
		  if (isset($_POST['rlink_submit'])){
			  if (!empty($info['reflink'])){
				 $rlinkmsg = "Referral link is ".$info['reflink'];
				 Message_Send($rlinkmsg, $cell, $adsphoneid[0], $link);
				 }
		  }
		  if (isset($_POST['cancel_submit'])){
			  $q = "SELECT source FROM appt WHERE customercell='".$cell."'&&status='0'";
			   $res = mysqli_query($link, $q) ;
			   $source = mysqli_fetch_array($res);
			   if ($source[0] > 0){
				   $q = "DELETE FROM appointments WHERE id='".$source[0]."'";
				   mysqli_query($link, $q) ; 
			   }
			   $q = "DELETE FROM appt WHERE customercell='".$cell."'&&status='0'";
			   mysqli_query($link, $q) ;   
		  }
}
?>

<? if ($cell == 0) {
	$q = "UPDATE customers SET rept='1', shortlink='' WHERE id='".$info['id']."'";
	mysqli_query($link, $q) ;
	echo "Sorry, Your link either has expired or is incomplete (you have to copy the whole link including all the letters/numbers after 'pass=')."; 
}
else {
	$q = "SELECT id, storeid, intime FROM appt WHERE customercell='".$cell."'&&status='0'&&intime>='".date('Y-m-d H:i', time()-2*60*60)."' ORDER BY id DESC LIMIT 0, 1";
	$res = mysqli_query($link, $q) ;
	$appt = mysqli_fetch_array($res);
?>
<html>
	<head>
		<title>Meet Me Today</title>
		<meta charset="utf-8" />
		<meta name="viewport" content="width=device-width, initial-scale=1" />
        <link rel="stylesheet" href="assets/font/flaticon.css">
<link href='https://fonts.googleapis.com/css?family=Lato:300,400,700' rel='stylesheet' type='text/css'>

<link rel="stylesheet" href="assets/font/fa/css/font-awesome.min.css">
		<!--[if lte IE 8]><script src="assets/js/ie/html5shiv.js"></script><![endif]-->
		<link rel="stylesheet" href="assets/css/main.css" />
        <link rel="stylesheet" href="assets/bootstrap-material-datetimepicker/css/bootstrap-material-datetimepicker.css">
		<!--[if lte IE 9]><link rel="stylesheet" href="assets/css/ie9.css" /><![endif]-->
		<!--[if lte IE 8]><link rel="stylesheet" href="assets/css/ie8.css" /><![endif]-->
	</head>
	<body>

		<!-- Sidebar -->
			<section id="sidebar">
				<div class="inner">
					<nav>
						<ul> <? if ($info['stage'] >= 1) {?>
							<li><a href="#intro">HOME</a></li>
							<li><a href="#two">INCALL</a></li>
							<li><a href="#one">OUTCALL</a></li>
							<li><a href="#two">APPOINTMENTS</a></li>
						    <li><a href="#three">More ads, More Choice</a></li> <? } ?>
						</ul>
					</nav>
				</div>
			</section>

		<!-- Wrapper -->
			<div id="wrapper">

				<!-- Intro --><? if ($info['stage'] == 0||!empty($m)) {?>
					<section id="intro" class="wrapper style1 fullscreen fade-up">
						<div class="inner">
							<? if ($info['stage'] == 0) { ?>
							<p> You must be 19 or older to use this website. <a href="index.php?c=<? echo $cell;?>&stage=-1"> I agree and continue</a></p> 
							<? } else if (!empty($m)) echo "<p><font color='red'>".$m."</font> /p"; ?>
						</div>
					</section>
                <? } if ($info['stage'] != 0) { ?>
				<!-- One -->
					<section id="one" class="wrapper style1 fade-up">
						<section>
							<div class="content">
								<div class="inner">
									<h2>MeetUp City For Incall</h2>
									<p><? if (!empty($city)) { echo "Your current meetup city is <font color='red'> ".$info['city']; ?></font> Please <a href="https://pva799.com/meet/mypic.php?subcity=<? echo $info['city']; ?>"> read the instructions here </a> for texting to me. <? } else {?> Please choose your meetup city below and view my service details and real pictures. Thanks. <? } ?>
									<form method="POST" action="index.php?c=<? echo $cell;?>">
									<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="70%" id="AutoNumber1">
									  <tr>
										<td width="20%"><select size="25" name="city"> <? 
										if (!empty($city)) echo "<option selected value='0'>".$city."</option>";
										else echo "<option selected value='0'> Please Choose A City</option>";
										$q = "SELECT id, city FROM store GROUP BY city";
										$re = mysqli_query($link, $q) ;
			                            while ( $rw = mysqli_fetch_row($re) ){ 
										      $id = 0;
											  $id = Store_Find($rw[1], 0, $link);
										    if ($id > 0){
												$q = "SELECT city, province FROM subarea WHERE subcity='".$rw[1]."'";
												$res = mysqli_query($link, $q) ;
												$subarea = mysqli_fetch_array($res);
												echo "<option value='".$rw[1]."'>".$rw[1]."-".$subarea[0]."-".$subarea[1]."</option>";
											}
										}?></select></td><td><? if (!empty($city)){ 
                                                                    $store_close = 0;										
																	$q = "SELECT id, name FROM girlprofile WHERE storeid=(SELECT storeid FROM customers WHERE cell='".$cell."')";
																	$re = mysqli_query($link, $q) ;
																	$num = mysqli_num_rows($re);
																	if ($num == 0)
																		$store_close = 1;
																	if ($num >= 1)
										                                echo "View the service details and pictures by clicking the name here. ";
																	else echo "We are off at this location. Please check back later.";
																	if ($num >= 2) echo "<br>";
																	$i = 1;
																	while ( $rw = mysqli_fetch_row($re) ){ ?>
																	   <a href="https://pva799.com/meet/mypic.php?id=<? echo $rw[0];?>"><font color="red"><? echo $rw[1]; ?></font> <img src="imagethumb.php?num=<? echo $i; ?>"> </a> 
																<?	$i++; }
										        }
										?></td>
									  </tr>
									  <tr>
										<td width="20%"><button name="B1" type="reset">Reset</button></td>
										
										<td width="50%"> <? if (empty($appt)) {?> <button name="city_submit" type="submit">Change to meetup city <? echo $info['city'];?></button> <? } else { echo "You have an unfulfilled appointment. Can't change meetup city.";} ?></td>
									  </tr>
									</table>
									</form>
									</p>
									
								</div>
							</div>
						</section>
						<section>
							<div class="content">
								<div class="inner">
									<h2>OUTCALL</h2>
									<p>My outcall (you host) rate varies between $280hr and $380hr depending on the distance. one hour minimum for each outcall visit. If you think the outcall rate is acceptable to you, please submit your exact address to me in the following form, my driver will contact you in a few minutes.
									<form method="POST" action="index.php?c=<? echo $cell;?>">
									<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="70%" id="AutoNumber1">
									  <tr>
										<td width="20%">Hotel Name if it is a hotel</td>
										<td width="50%"><input type="text" name="hotel" size="20"></td>
									  </tr>
									  <tr>
										<td width="20%">Address</td>
										<td width="50%"><input type="text" name="address" size="20"></td>
									  </tr>
									  <tr>
										<td width="20%">Suite</td>
										<td width="50%"><input type="text" name="suite" size="20"></td>
									  </tr>
									  <tr>
										<td width="20%">Desired Time of Arrival</td>
										<td width="50%"><input type="text" name="arrival" size="20"><input type="hidden" name="city" value="<? echo $info['city']; ?>"></td>
									  </tr>
									  <tr>
										<td width="20%"><button name="B1">Reset</button></td>
										<td width="50%"><button name="outcall_submit" type="submit">Submit</button></td>
									  </tr>
									</table></form>
									</p>
								</div>
							</div>
						</section>
						
						</section>
						

				<!-- Two -->
					<section id="two" class="wrapper style3 fade-up">
						<div class="inner">
							<h2>INCALL</h2>
							<p>You can make an appointment or modify an existing appointment here for incall (I host):</p>
								<section>
									<p><? $q = "SELECT id, storeid, intime FROM appt WHERE customercell='".$cell."'&&status='0'&&intime>='".date('Y-m-d H:i', time()- 4*60*60)."' ORDER BY intime DESC LIMIT 0,1";
									      $re = mysqli_query($link, $q) ;
									      $storeid =  mysqli_fetch_array($re);
										  if (!empty($storeid)){
										      $store = $storeid[1];
											  echo "You have an existing appointment for ".date('m-d H:i', strtotime($storeid[2]));
											  echo "<br> If you have arrived at the incall location, please click this button, you will receive buzz code by sms text.";
											  echo "<br><form method='POST' action='index.php?c=".$cell."'><button name='arrive_submit' type='submit' value='".$storeid[0]."'>I am here </button></form>";
											  echo "<br><form method='POST' action='index.php?c=".$cell."'><button name='cancel_submit' type='submit' value='".$storeid[0]."'> Cancel </button></form>";
											  echo "<br> You can also modify the appointment in the following form";
										    }
										  else {
											  $q = "SELECT storeid FROM customers WHERE cell='".$cell."'";
											  $re = mysqli_query($link, $q) ;
									          $storeid =  mysqli_fetch_array($re);
											  $store = $storeid[0];
										  }
										  if (isset($store)){
											  $i = 0;
											  $id = $store;
											  while ($id == $store&&$i <= 2) {
											     $id = Store_Find($info['city'], 0, $link);
												 $i = $i + 1;
											  }
											  if ($id != $store&&empty($appt)){
											      echo "We have multiple locations in your current meetup city, please click the button below to change location. <br>";
											      echo "<br><form method='POST' action='index.php?c=".$cell."'><button name='newlocation_submit' type='submit' value='".$id."'>Change Location </button></form><br>";
											  }
											  $q = "SELECT address, crossing FROM store WHERE id='".$store."'";
											  $re = mysqli_query($link, $q) ;
											  $storeinfo =  mysqli_fetch_array($re);
										  }
										  if (!empty($storeinfo)){
									?><form method="POST" action="index.php?c=<? echo $cell;?>">
								<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="70%" id="AutoNumber1">
								  <tr>
									<td width="20%">Incall Location</td>
									<td width="50%" colspan="3"><? 
									if (stripos($storeinfo[1], "apartment") !== false)
										echo $storeinfo[0].",  ".$storeinfo[1];
									else echo $storeinfo[1].", Exact address will be sent to you when you arrive at this intersection.";
									?></td>
								  </tr>
								  <tr>
									<td width="20%">Estimated Time of Arrival</td>
									<td width="14%"><input size="20" type="text" name='estTime' value="" placeholder='Enter Time' readonly id='date-format' class="date-format"></td>
									
								  </tr>
								  <tr>
									<td width="20%"><button name="B1" type="reset">Reset</button></td>
									<td width="50%" colspan="3"><? if ($store_close == 1) echo "We are off for now."; else {?><button name="Newappt_submit" type="submit" value="<? if (!empty($storeid)) echo $storeid[0]; else echo "0";?>">New Appointment Submit
									</button><? } ?></td>
								  </tr>
										  </table></form> <? } else echo "Please choose your incall meetup city before making an appointment. Thanks"; ?>
</p>
								</section>
							</div>
					</section>
					
				<!-- Three -->
					<section id="three" class="wrapper style1 fade-up">
						<div class="inner">
							<h2>Book at <a href="https://www.pva799.com"> www.PVA799.com </a> to get PVA dollars</h2>
							<p> More ads, More choice and Save big by earning PVA dollars. To learn how, please visit <a href="https://www.pva799.com"> www.PVA799.com </a> </p>
						</div>
					</section>

				</div> <? } ?>

		<!-- Footer -->
			<footer id="footer" class="wrapper style1-alt">
				<div class="inner">
					<ul class="menu">
						<li>&copy; MeetMe. All rights reserved.</li><li>Design: <a href="http://html5up.net">HTML5 UP</a></li>
					</ul>
				</div>
			</footer>

		<!-- Scripts -->
			<script src="assets/js/jquery.min.js"></script>
            <script src="//momentjs.com/downloads/moment.min.js"></script>

			<script src="assets/js/jquery.scrollex.min.js"></script>
			<script src="assets/js/jquery.scrolly.min.js"></script>
			<script src="assets/js/skel.min.js"></script>
			<script src="assets/js/util.js"></script>
            <script type="text/javascript" src="assets/bootstrap-material-datetimepicker/js/bootstrap-material-datetimepicker.js"></script>

			<!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script>
                            <![endif]-->
			<script src="assets/js/main.js"></script>
            <script type="text/javascript">
    jQuery('#date-format').bootstrapMaterialDatePicker({ format : 'YYYY-MM-DD HH:mm:ss' });
</script>

	</body>
</html> <? } ?>