<?
error_reporting(0);

session_start();
header("content-type:text/html; charset=utf-8");  
include 'meetme_connect.php';
mysqli_query($link, "SET NAMES utf8");
date_default_timezone_set("America/Vancouver");

function Income_Report($userid, $pay, $status, $link) {
	if ($status == 0)
		$txt = "新增手动：";
	else if ($status == 2)
		$txt = "修改：";
	else if ($status == 3)
		$txt = "外卖/特定：";
	else if ($status == 4)
		$txt = "结算：";
	else $txt = "";
	
	$q = "SELECT name FROM store WHERE id=(SELECT storeid FROM girlprofile WHERE userid='".$userid."')";
	$re = mysqli_query($link, $q) ;
	$storename = mysqli_fetch_array($re);
	$q = "SELECT cell FROM users WHERE id='".$userid."'";
	$re = mysqli_query($link, $q) ;
	$girlcell = mysqli_fetch_array($re);
	$cell = substr($girlcell[0], 0, 10);
	$q = "SELECT id, cell FROM users";
	$re = mysqli_query($link, $q) ;
	while ( $rw = mysqli_fetch_row($re) ){
		if (strpos($rw[1], $cell) !== false) 
            $id_arr[] = $rw[0];			
	}
	$total = 0; $today_total = 0;
	if ($storename[0] == "Kelowna")
		$m = 1;
	else $m = 2;
	
	foreach ($id_arr as $v){
		$total += Income_Cal($v, -1, $link, $m);
		$today_total += Income_Cal($v, 0, $link, $m);
	}
	$p = 0;
	$q = "SELECT managerid FROM store WHERE id=(SELECT storeid FROM girlprofile WHERE userid='".$userid."')";
	$re = mysqli_query($link, $q) ;
	$managerid = mysqli_fetch_array($re);
	 $q = "SELECT amount FROM payment WHERE senderid='".$managerid[0]."'&&receiverid='".$userid."'";
	 $res2 = mysqli_query($link, $q) ;  
	 while ( $rw1 = mysqli_fetch_row($res2) ){
		 $p += $rw1[0];
	 }
	 $q = "SELECT amount FROM payment WHERE senderid='".$userid."'&&receiverid='".$managerid[0]."'";
	 $res2 = mysqli_query($link, $q) ;  
	 while ( $rw1 = mysqli_fetch_row($res2) ){
		 $p -= $rw1[0];
	 }
	 $p1 = 0;
	 $q = "SELECT amount FROM payment WHERE senderid='".$managerid[0]."'&&receiverid='".$userid."'&&intime>='".date('Y-m-d')."'&&source='outcall'";
	 $res2 = mysqli_query($link, $q) ;  
	 while ( $rw1 = mysqli_fetch_row($res2) ){
		 $p1 += $rw1[0];
	 }
	$q = "SELECT wechat FROM users WHERE cell='".$cell."'";
	$re = mysqli_query($link, $q) ;
	$wechat = mysqli_fetch_array($re);
	if (!empty($wechat)){
		$wechatmsg = $txt."已输入：".$pay."，总数为：".($total+$p)."， 从今日零点开始小计为：".($today_total+$p1);
		if (rand(0,1) > 0.5)
			$wechatmsg .= "， 若有错，请当日改正，谢谢。";
		if (rand(0,1) > 0.7)
			$wechatmsg .= " 不要把你的链接发送给其他人，修改密码可以sms短信发pass给我的任意号码。";
		$q = "INSERT INTO wechatmsg VALUES ('', '".$wechat[0]."', '".addslashes($wechatmsg)."', '".date('Y-m-d H:i')."', '0')";
    	mysqli_query($link, $q) ;
	}
	$wechatmsg = $storename[0].", ".$txt." 已输入".$pay.", 总数为：".($total+$p)."， 从今日零点开始小计为：".$today_total;
	$q = "INSERT INTO wechatmsg VALUES ('', 'frxgoeasy', '".addslashes($wechatmsg)."', '".date('Y-m-d H:i')."', '0')";
    mysqli_query($link, $q) ;
}

function Income_Cal($id, $type, $link, $m) {
		$q = "SELECT rate, cut2m, cut2p FROM girlprofile WHERE userid='".$id."'";
		$re = mysqli_query($link, $q) ;
	    $girlinfo = mysqli_fetch_array($re);
        $rate = explode("*", $girlinfo[0]);
		$cut2p = explode("*", $girlinfo[2]);
		$amt = 0;
		$tbl = array("appt", "outcall");
		foreach ($tbl as $v){
			if ($m == 1&&$v == "outcall") continue;
			if ($type == -1)
			   $q = "SELECT pay FROM ".$v." WHERE status='2'&&userid='".$id."'";
			if ($type == 0)
			   $q = "SELECT pay FROM ".$v." WHERE status='2'&&userid='".$id."'&&intime>='".date('Y-m-d')."'";
			if ($type == 7)
			   $q = "SELECT pay FROM ".$v." WHERE status='2'&&userid='".$id."'&&intime>='".date('Y-m-d', time()-7*24*60*60)."'";
			if ($type == 15)
			   $q = "SELECT pay FROM ".$v." WHERE status='2'&&userid='".$id."'&&intime>='".date('Y-m-d', time()-15*24*60*60)."'";
			$re = mysqli_query($link, $q) ;
			while ( $rw = mysqli_fetch_row($re) ){
				if (empty($rw[0])) continue;
				if ($m == 1)
				   $amt += ($rw[0]-80)/2+20;
				if ($m == 2){
					if ($v == "appt"){
						if ($rw[0] <= $rate[3])
							$amt += $cut2p[0];
						else if ($rw[0] >= 1.5*$rate[3]&&$rw[0] < 2*$rate[3])
							$amt += 1.5*$cut2p[0];
						else if ($rw[0] >= 2*$rate[3])
							$amt += 2*$cut2p[0];
					}
					if ($v == "outcall"){
						if ($rw[0] <= $rate[6])
							$amt += $cut2p[1];
						else if ($rw[0] >= 1.5*$rate[3]&&$rw[0] < 2*$rate[3])
							$amt += 1.5*$cut2p[1];
						else if ($rw[0] >= 2*$rate[3])
							$amt += 2*$cut2p[1];
					}
				   
				}
			}
		}
       return $amt;
	}
	
function Appt_List($userid, $link, $type) {
	  $q = "SELECT id, name, city FROM store WHERE managerid='".$userid."' ORDER BY city";
	  $re = mysqli_query($link, $q) ;
	  while ( $rw = mysqli_fetch_row($re) ){
		  $q = "SELECT timezone FROM subarea WHERE subcity='".$rw[2]."'||city='".$rw[2]."'";
		  $res = mysqli_query($link, $q) ;
		  $timezone = mysqli_fetch_array($res);
		  date_default_timezone_set("America/".$timezone[0]."");
		  if ($type == 0)
		     $q = "SELECT id, customercell, intime, status FROM appt WHERE storeid='".$rw[0]."'&&(status='0'||status='1')&&intime>='".date('Y-m-d,H:i', time()-3*60*60)."'&&intime<='".date('Y-m-d,H:i', time()+3*60*60)."' ORDER BY intime DESC";
		  if ($type == 600)
			 $q = "SELECT id, customercell, intime, status FROM appt WHERE storeid='".$rw[0]."'&&(status='0'||status='1')&&intime>='".date('Y-m-d,H:i', time()-6*60*60)."'&&intime<='".date('Y-m-d,H:i', time()+6*60*60)."' ORDER BY intime DESC"; 
		  if ($type == -1)
			 $q = "SELECT id, customercell, userid, pay, intime FROM appt WHERE storeid='".$rw[0]."'&&status='2'&&intime>='".date('Y-m-d,H:i', time()-24*60*60)."' ORDER BY intime DESC"; 
		  $res = mysqli_query($link, $q) ;
		  while ( $rw1 = mysqli_fetch_row($res) ){ 
		      if ($type >= 0)
			     $appt[] = array($rw[1], $rw1[0], $rw1[1], $rw1[2], $rw1[3]); 
			  else if (!empty($rw1[3]))
				 $appt[] = array($rw[1], $rw1[0], $rw1[1], $rw1[2], $rw1[3], $rw1[4]);
		  }
	  } 
	 $q = "SELECT storeid FROM girlprofile WHERE userid='".$userid."'";
	 $re = mysqli_query($link, $q) ;	
	 $storeid = mysqli_fetch_array($re);	
	 $q = "SELECT id, name, city FROM store WHERE id='".$storeid[0]."'";
	 $re = mysqli_query($link, $q) ;
	 $info = mysqli_fetch_array($re);
	 $q = "SELECT timezone FROM subarea WHERE subcity='".$info[2]."'||city='".$info[2]."'";
	 $res = mysqli_query($link, $q) ;
	 $timezone = mysqli_fetch_array($res);
	 date_default_timezone_set("America/".$timezone[0]."");
	 
	  if ($type == 0)
		  $q = "SELECT id, customercell, intime, status FROM appt WHERE storeid='".$storeid[0]."'&&(status='0'||status='1')&&intime>='".date('Y-m-d,H:i', time()-3*60*60)."'&&intime<='".date('Y-m-d,H:i', time()+3*60*60)."'";
	  if ($type == 600)
		  $q = "SELECT id, customercell, intime, status FROM appt WHERE storeid='".$storeid[0]."'&&(status='0'||status='1')&&intime>='".date('Y-m-d,H:i', time()-6*60*60)."'&&intime<='".date('Y-m-d,H:i', time()+6*60*60)."'";
	  if ($type == -1)
		  $q = "SELECT id, customercell, userid, pay, intime FROM appt WHERE storeid='".$storeid[0]."'&&status='2'&&intime>='".date('Y-m-d,H:i', time()-30*60*60)."'"; 
	  $res = mysqli_query($link, $q) ;
	  while ( $rw1 = mysqli_fetch_row($res) ){ 
				if ($type >= 0)
				   $appt[count($appt)] = array($info[1], $rw1[0], $rw1[1], $rw1[2], $rw1[3]); 
				else if (!empty($rw1[3]))
				   $appt[count($appt)] = array($info[1], $rw1[0], $rw1[1], $rw1[2], $rw1[3], $rw1[4]); 
			} 
  date_default_timezone_set("America/Vancouver");				
  return $appt;
}

function Photo_Upload($userfile, $id, $tmpName, $link) {
	$fp      = fopen($tmpName, 'r');
	$content = fread($fp, filesize($tmpName));
	$content = addslashes($content);
	fclose($fp);
	$q = "UPDATE girlprofile SET ".$userfile."='".$content."' WHERE id='".$id."'";
	mysqli_query($link, $q) ;
	return;
} 
if (isset($_POST['login_submit'])){
	$_GET['cell'] = trim($_POST['cell']);
	$_GET['passcode'] = $_POST['logincode'];
}

$login = 0; $cell = 0;
if (isset($_POST['change_login_submit'])){
	$q = "UPDATE users SET expiry='".date('Y-m-d H:i', time()+60*60)."' WHERE id='".$_POST['userid']."'";
	mysqli_query($link, $q) ;
	$q = "SELECT cell, logincode FROM users WHERE id='".$_POST['userid']."'";
	$re = mysqli_query($link, $q) ;
	$info = mysqli_fetch_array($re);
	$_GET['cell'] = $info[0];
	$_GET['passcode'] = $info[1];
	unset($_COOKIE['cell']);
	unset($_COOKIE['passcode']);
}
if (isset($_GET['cell'])&&isset($_GET['passcode'])) {
	$q = "SELECT logincode FROM users WHERE cell='".$_GET['cell']."'&&expiry >='".date('Y-m-d H:i')."'";
	$re = mysqli_query($link, $q) ;
	$num = mysqli_num_rows($re);
	if ($num == 1){
		$logincode = mysqli_fetch_array($re);
        if ($logincode[0] == $_GET['passcode'])	{
			$login = 1;
			setcookie("cell", $_GET['cell'], time()+24*60*60);
			setcookie("passcode", $_GET['passcode'], time()+24*60*60);
			$cell = $_GET['cell'];
		}	
	}
} else if (isset($_COOKIE['cell'])&&isset($_COOKIE['passcode'])){
	$q = "SELECT logincode FROM users WHERE cell='".$_COOKIE['cell']."'&&expiry >='".date('Y-m-d H:i')."'";
	$re = mysqli_query($link, $q) ;
	$num = mysqli_num_rows($re);
	if ($num == 1){
		$logincode = mysqli_fetch_array($re);
        if ($logincode[0] == $_COOKIE['passcode'])	{
			$login = 1;
			$cell = $_COOKIE['cell'];
		}
		    
	}
}
if ($_GET['menucode'] == 900) { 
        $login = 0;
		setcookie("cell", '', time()-24*60*60);
		setcookie("passcode", '', time()-24*60*60);
		header("location: index.php");
	}
	
if ($login == 1){
	$msg = "";
	$q = "SELECT id,menuitem FROM users WHERE cell='".$cell."'";
	$re = mysqli_query($link, $q) ;
	$menuitem = mysqli_fetch_array($re);
	$itemid = explode("*", $menuitem[1]);
	$userid = $menuitem[0];
	for ($j=0; $j<count($itemid); $j++){
	  $q = "SELECT * FROM menuitems WHERE id ='".$itemid[$j]."'";
	  $re = mysqli_query($link, $q) ;
	  $item[$j] = mysqli_fetch_array($re);
	}
	
	if (isset($_GET['menucode'])){ 
	    if (array_search($_GET['menucode']/100, $itemid) !== false)
	           $menucode = $_GET['menucode']; 
		else   { $menucode = 900; $login = 0; }
	}
	else $menucode = 0;
	if (isset($_GET['subcode'])){ 
		if (array_search(round($_GET['subcode']/100), $itemid) !== false) 
		   $subcode = $_GET['subcode'];
	    else { $subcode = 900; $login = 0; }
	}
	else $subcode = 0;
	
	$q = "SELECT * FROM store WHERE managerid='".$userid."'";
	$re = mysqli_query($link, $q) ;
	$num = mysqli_num_rows($re);
	if ($num == 0)
		$is_worker = 1;
	else $is_worker = 0;
	
	if (isset($_POST['comment_submit'])){
		$q = "SELECT id FROM blacklist WHERE cell='".$_POST['comment_submit']."'";
		$re = mysqli_query($link, $q) ;
	    $info = mysqli_fetch_array($re);
		if (empty($info)){
			$q = "INSERT INTO blacklist VALUES ('', '".$_POST['comment_submit']."', '".$userid."', '".$_POST['grade']."', '".date('Y-m-d H:i')."')";
			mysqli_query($link, $q) ;
		} else {
			$q = "UPDATE blacklist SET grade='".$_POST['grade']."', userid='".$userid."' WHERE cell='".$_POST['comment_submit']."'";
			mysqli_query($link, $q) ;
		}
	}
	if (isset($_POST['appt_submit'])&&is_numeric($_POST['pay'])&&$_POST['pay'] >= 0){
		$q = "SELECT city FROM store WHERE id=(SELECT storeid FROM appt WHERE id='".$_POST['appt_submit']."')";
		$re = mysqli_query($link, $q) ;
	    $info = mysqli_fetch_array($re);
		$q = "SELECT timezone FROM subarea WHERE subcity='".$info[0]."'||city='".$info[0]."'";
	    $res = mysqli_query($link, $q) ;
	    $timezone = mysqli_fetch_array($res);
	    date_default_timezone_set("America/".$timezone[0]."");
		
		$q = "SELECT status FROM appt WHERE id='".$_POST['appt_submit']."'";
		$re = mysqli_query($link, $q) ;
	    $info = mysqli_fetch_array($re);
		
		$q = "UPDATE appt SET userid='".$userid."', pay='".$_POST['pay']."', intime='".date('Y-m-d H:i')."', status='2' WHERE id='".$_POST['appt_submit']."'";
		mysqli_query($link, $q) ;
		$q = "UPDATE customers SET stage='1', rept='0', intime='".date('Y-m-d H:i')."' WHERE cell=(SELECT customercell FROM appt WHERE id='".$_POST['appt_submit']."')";
		mysqli_query($link, $q) ;
		date_default_timezone_set("America/Vancouver");
		$msg = "收款已经输入";
        Income_Report($userid, $_POST['pay'], $info[0], $link);		
	}
	if (isset($_POST['send_message'])){
		if ($_POST['message'] == 1)
			$content = "Hi, the time ".date('H:i', strtotime($_POST['intime']))." works for me. I look forward to seeing you soon. Thanks";
		else if ($_POST['message'] >= 6) {
			$q = "SELECT buzz, suite, address, crossing FROM store WHERE id=(SELECT storeid FROM appt WHERE customercell='".$_POST['cell']."' ORDER BY id DESC LIMIT 0,1)";
			$re = mysqli_query($link, $q) ;
			$buzzinfo = mysqli_fetch_array($re);
			if ($_POST['message'] == 6){
				if (stripos($buzzinfo[3], "apartment") !== false)
				     $content = "Pls come to the buzz panel at the front entrance. I will text you the buzz code right after.";
				else $content = "Pls come to ".$buzzinfo[2];
			}
			$buzzinfo[0] = str_replace("*", "", $buzzinfo[0]);
			$buzzinfo[1] = str_replace("*", "", $buzzinfo[1]);
			
			if (stripos($buzzinfo[3], "apartment") !== false||stripos($buzzinfo[3], "hotel") !== false){
				if (stripos($buzzinfo[0], "||") !== false){
					$entrybuzz = explode("||", $buzzinfo[0]);
					$entrysuite = explode("||", $buzzinfo[1]);
					if ($_POST['message'] == 7)
					     $content = "My buzz code is ".$entrybuzz[0];
					if ($_POST['message'] == 9)
					     $content = "My buzz code is ".$entrybuzz[1];
                    if ($_POST['message'] == 8)
					     $content = "My suite no. is ".$entrysuite[0];	
                    if ($_POST['message'] == 10)
					     $content = "My suite no. is ".$entrysuite[1];						 
				} else {
					if ($_POST['message'] == 7)
					     $content = "My buzz code is ".$buzzinfo[0];
                    if ($_POST['message'] == 8)
					     $content = "My suite no. is ".$buzzinfo[1];	
				}	
			}
		} else {
			$q = "SELECT English FROM arrival_msg WHERE formid='".$_POST['message']."'";
			$re = mysqli_query($link, $q) ;
			$info = mysqli_fetch_array($re);
			$content = $info[0];
		}
		$q = "SELECT id FROM message WHERE cell='".$_POST['cell']."'&&content='".$content."'&&intime>='".date('Y-m-d H:i', time()-2*60)."'";
		$re = mysqli_query($link, $q) ;
	    $num = mysqli_num_rows($re);
		if ($num == 0) {
		   $q = "INSERT INTO message VALUES ('', '".$_POST['cell']."', '0', '".$content."', '".date('Y-m-d H:i')."', '0')";
		   mysqli_query($link, $q) ;
		   $msg = "短信已发出";
		}
	}
	if (isset($_POST['store_submit'])){
		if ($_POST['operation'] == 1){
			$q = "UPDATE store SET address='".$_POST['address']."', city='".$_POST['city']."', buzz='".$_POST['buzz']."', suite='".$_POST['suite']."', crossing='".$_POST['cross']."' WHERE id='".$_POST['store_submit']."'";
			mysqli_query($link, $q) ;
		    $msg = $_POST['name']." 店的信息已经修改";
		}
		if ($_POST['operation'] == 2){
			$q = "SELECT managerid FROM store WHERE id='".$_POST['store_submit']."'";
			$re = mysqli_query($link, $q) ;
			$managerid = mysqli_fetch_array($re);
			$q = "SELECT userid FROM girlprofile WHERE storeid='".$_POST['store_submit']."'";
			$re = mysqli_query($link, $q) ;
	        while ( $rw = mysqli_fetch_row($re) ){
				$income = Income_Cal($rw[0], -1, $link, 1);
				$q = "INSERT INTO payment VALUES ('', '".$managerid[0]."', '".$rw[0]."', '".$income."', '".date('Y-m-d H:i')."', '')";
				mysqli_query($link, $q) ;
				if ($managerid[0] != 1){
					$income = Income_Cal($rw[0], -1, $link, 2);
					$q = "INSERT INTO payment VALUES ('', '1', '".$managerid[0]."', '".$income."', '".date('Y-m-d H:i')."', '')";
				    mysqli_query($link, $q) ;	
				}
			}
			$q = "DELETE FROM appt WHERE storeid='".$_POST['store_submit']."'";
			mysqli_query($link, $q) ;
			$q = "DELETE FROM store WHERE id='".$_POST['store_submit']."'";
			mysqli_query($link, $q) ;
			$msg = $_POST['name']." 店的信息以及相关的预约信息已经删除";
		}
	}
	if (isset($_POST['add_store_submit'])){
		$q = "INSERT INTO store VALUES ('', '".$_POST['name']."', '".$userid."','".$_POST['address']."','".$_POST['city']."','".$_POST['buzz']."','".$_POST['suite']."','".$_POST['cross']."', '')";
		mysqli_query($link, $q) ;
	    $msg = $_POST['name']." 店已经添加";
	}
	if (isset($_POST['girl1_submit'])){
		if ($_POST['operation'] == 2){
			$q = "SELECT userid FROM girlprofile WHERE id='".$_POST['girlprofileid']."'";
			$re = mysqli_query($link, $q) ;
	        $id = mysqli_fetch_array($re);
			$income = Income_Cal($id[0], -1, $link, 1);
			$q = "INSERT INTO payment VALUES ('', '".$userid."', '".$id[0]."', '".$income."', '".date('Y-m-d H:i')."', '')";
			mysqli_query($link, $q) ;
			$income = Income_Cal($id[0], -1, $link, 2);
			$q = "INSERT INTO payment VALUES ('', '1', '".$userid."', '".$income."', '".date('Y-m-d H:i')."', '')";
			mysqli_query($link, $q) ;
			$q = "DELETE FROM appt WHERE userid='".$id[0]."'";
			mysqli_query($link, $q) ;
			$q = "SELECT name, storeid FROM girlprofile WHERE id='".$_POST['girlprofileid']."'";
			$re = mysqli_query($link, $q) ;
	        $name = mysqli_fetch_array($re);
			$q = "DELETE FROM girlprofile WHERE id='".$_POST['girlprofileid']."'";
			mysqli_query($link, $q) ;
			$msg = $name[0]." 的本人信息以及相关预约信息已经删除";
			$q = "SELECT id FROM girlprofile WHERE storeid='".$name[1]."'";
			$re = mysqli_query($link, $q) ;
			$num = mysqli_num_rows($re);
		    if ($num == 0) {
				$q = "DELETE FROM newgirl WHERE storeid='".$name[1]."'";
				mysqli_query($link, $q) ;
			}
		}
	}
	
	if (isset($_POST['girl2_submit'])){
		$q = "SELECT userid, storeid, cut2p, cut2m FROM girlprofile WHERE id='".$_POST['girl2_submit']."'";
		$re = mysqli_query($link, $q) ;
	    $info = mysqli_fetch_array($re);
		$q = "SELECT managerid FROM store WHERE id='".$info[1]."'";
		$re = mysqli_query($link, $q) ;
	    $managerid = mysqli_fetch_array($re);
		
		if ($info[1] != $_POST['storeid']||$info[2] != $_POST['cut2p']||$info[3] != $_POST['cut2m']){
			if ($info[1] != $_POST['storeid']){
				$q = "INSERT INTO newgirl VALUES ('', '".$_POST['storeid']."', '1', '".date('Y-m-d H:i')."')";
				mysqli_query($link, $q) ;
			}
			$income = Income_Cal($info[0], -1, $link, 1);
			if ($income > 0){
				$q = "INSERT INTO payment VALUES ('', '".$managerid[0]."', '".$info[0]."', '".$income."', '".date('Y-m-d H:i')."', '')";
				mysqli_query($link, $q) ;
			}
			$income = Income_Cal($info[0], -1, $link, 2);
			if ($income > 0){
				$q = "INSERT INTO payment VALUES ('', '1', '".$managerid[0]."', '".$income."', '".date('Y-m-d H:i')."', '')";
				mysqli_query($link, $q) ;
				$q = "DELETE FROM appt WHERE userid='".$info[0]."'";
				mysqli_query($link, $q) ;
			}	
		}
        $id = $_POST['girl2_submit'];
		unset($_POST['girl2_submit']);
		$info_key = array_keys($_POST);
		foreach($info_key as $v){ 
			   if ($v == "MAX_FILE_SIZE") continue;
			   $q = "UPDATE girlprofile SET ".$v."='".$_POST[$v]."' WHERE id='".$id."'"; 
			   mysqli_query($link, $q) ;
		   }
        $photo = array("photo1", "photo2", "photo3");
		foreach ($photo as $v){
			if($_FILES[$v]['size'] > 0){ 
				  $tmpName  = $_FILES[$v]['tmp_name'];
				  Photo_Upload($v, $id, $tmpName, $link); 
				  } else $msg .= " <font color='red'>".$v." 图片上传失败！</font>"; 
			}
	    
		$q = "SELECT name FROM users WHERE id='".$info[0]."'";
		$re = mysqli_query($link, $q) ;
	    $name = mysqli_fetch_array($re);
		$msg = $name[0]." 的信息已经更新";
	}
	if (isset($_POST['new_girl_submit'])){
		if (!empty($_POST['name'])&&!empty($_POST['cell'])){
			$q = "SELECT id FROM users WHERE cell='".$_POST['cell']."'";
			$re = mysqli_query($link, $q) ;
	        $info = mysqli_fetch_array($re);
			if (empty($info)){
			     $q = "INSERT INTO users VALUES ('', '".$_POST['name']."', '".$_POST['cell']."', '2*3*6*7*9', '123456', '".date('Y-m-d H:i', time()+4*60*60)."', '".$_POST['wechat']."')";
			     mysqli_query($link, $q) ;
				 $q = "SELECT id FROM users WHERE cell='".$_POST['cell']."'";
			     $re = mysqli_query($link, $q) ;
	             $info = mysqli_fetch_array($re);
			 }
			
			$q = "SELECT id FROM store WHERE managerid='".$userid."' LIMIT 0,1";
			$re = mysqli_query($link, $q) ;
	        $info1 = mysqli_fetch_array($re);
			$q = "INSERT INTO girlprofile VALUES ('', '".$info[0]."', '".$info1[0]."', '".$_POST['name']."', '100*120*140*160*260*300*240*360', '35*70', '30*40*50*60*90*100', '34C-25-35*115lbs*5#3*24','China','massage*gfe*bbbj*cim*daty*cof', 'greek/anal*bbfs', 'msog-40*cim-20', '', '00:00*00:00', '', '', '', '', '1')";
			mysqli_query($link, $q) ;
			$msg = "新技师已经添加";
			$q = "INSERT INTO newgirl VALUES ('', '".$info1[0]."', '1', '".date('Y-m-d H:i')."')";
			mysqli_query($link, $q) ;
		}
		
	}
	if (isset($_POST['amount_submit'])&&is_numeric($_POST['amount'])&&$_POST['amount'] > 0){
		$q = "INSERT INTO payment VALUES ('', '".$_POST['amount_submit']."', '".$userid."', '".$_POST['amount']."', '".date('Y-m-d H:i')."', 'paid')";
		mysqli_query($link, $q) ;
		Income_Report($userid, $_POST['amount'], 4, $link);
		$msg = $_POST['amount']." 金额已经输入。";	
	}
	if (isset($_POST['girlstatus_submit'])){
		$q = "SELECT storeid FROM girlprofile WHERE id='".$_POST['girlstatus_submit']."'";
		$re = mysqli_query($link, $q) ;
	    $info1 = mysqli_fetch_array($re);
		$q = "UPDATE girlprofile SET status='".$_POST['status']."' WHERE storeid='".$info1[0]."'";
		mysqli_query($link, $q) ;
		if ($_POST['status'] == 0)
		    $msg = "已经改成放工状态";
        else $msg = "已经改成上工状态";		
	}
	if (isset($_POST['phonepay_submit'])&&is_numeric($_POST['amount'])&&$_POST['amount'] > 0){
		$q = "INSERT INTO payment VALUES ('', '".$_POST['phonepay_submit']."', '".$userid."', '".$_POST['amount']."', '".date('Y-m-d H:i')."', 'paid')";
		mysqli_query($link, $q) ;
		Income_Report($userid, $_POST['amount'], 4, $link);
		$msg = $_POST['amount']." 金额已经输入。";	
	}
	if (isset($_POST['add_appt_submit'])&&is_numeric($_POST['pay'])&&$_POST['pay'] >= 80){
		$q = "SELECT storeid FROM girlprofile WHERE userid='".$_POST['add_appt_submit']."'";
		$re = mysqli_query($link, $q) ;
	    $info = mysqli_fetch_array($re);
		$q = "INSERT INTO appt VALUES ('', '', '".$info[0]."', '".$_POST['add_appt_submit']."', '".$_POST['pay']."', '".date('Y-m-d H:i')."', '2', '0')";
		mysqli_query($link, $q) ;
		Income_Report($_POST['add_appt_submit'], $_POST['pay'], 0, $link);
		$msg = $_POST['pay']." 金额预约信息已经输入。";
	}
	if (isset($_POST['manager_submit'])&&is_numeric($_POST['pay'])&&$_POST['pay'] >= 80){
		$q = "SELECT storeid FROM girlprofile WHERE userid='".$_POST['girlid']."'";
		$re = mysqli_query($link, $q) ;
	    $info = mysqli_fetch_array($re);
		$q = "INSERT INTO appt VALUES ('', '', '".$info[0]."', '".$_POST['girlid']."', '".$_POST['pay']."', '".date('Y-m-d H:i')."', '2', '0')";
		mysqli_query($link, $q) ;
		Income_Report($_POST['girlid'], $_POST['pay'], 0, $link);
		$msg = $_POST['pay']." 金额预约信息已经输入。";
	}
	if (isset($_POST['outcall_submit'])&&is_numeric($_POST['pay'])&&$_POST['pay'] >= 80&&is_numeric($_POST['mpay'])&&$_POST['mpay'] > 0){
		$customercell = "";
		if (is_numeric($_POST['addr'])){
			$q = "SELECT cell FROM customers WHERE intime>='".date('Y-m-d H:i', time()-8*60*60)."'";
			$re = mysqli_query($link, $q) ;
		    while ( $rw = mysqli_fetch_row($re) ){ 
				     if (strpos($rw[0], $_POST['addr']) !== false ){
						 $customercell = $rw[0];
					     break;
					    }
					}
		}
		if (array_key_exists("girlid", $_POST)){ 
			$q = "INSERT INTO payment VALUES ('', '".$userid."', '".$_POST['girlid']."', '".$_POST['mpay']."', '".date('Y-m-d H:i')."', 'outcall')";
			mysqli_query($link, $q) ;
			$q = "SELECT storeid FROM girlprofile WHERE userid='".$_POST['girlid']."'";
			$re = mysqli_query($link, $q) ;
	        $info = mysqli_fetch_array($re);
			$q = "INSERT INTO outcall VALUES ('', '".$customercell."', '".$_POST['girlid']."', '".$userid."', '".$_POST['addr']."', '".$_POST['pay']."', '".date('Y-m-d H:i')."', '2')";
			mysqli_query($link, $q) ;
			
		} else {
			$q = "SELECT storeid FROM girlprofile WHERE userid='".$userid."'";
			$re = mysqli_query($link, $q) ;
	        $info = mysqli_fetch_array($re);
			$q = "SELECT managerid FROM store WHERE id='".$info[0]."'";
			$re = mysqli_query($link, $q) ;
	        $info1 = mysqli_fetch_array($re);
			$q = "INSERT INTO payment VALUES ('', '".$info1[0]."', '".$userid."', '".$_POST['mpay']."', '".date('Y-m-d H:i')."', 'outcall')";
			mysqli_query($link, $q) ;
			$q = "INSERT INTO outcall VALUES ('', '".$customercell."', '".$userid."', '".$info1[0]."', '".$_POST['addr']."', '".$_POST['pay']."', '".date('Y-m-d H:i')."', '2')";
			mysqli_query($link, $q) ;
		}
		Income_Report($userid, $_POST['pay'], 3, $link);
		$msg = $_POST['pay']." 金额预约信息已经输入。";
	}
	if (isset($_POST['new_manager_submit'])&&!empty($_POST['cell'])&&!empty($_POST['name'])){
		$q = "INSERT users VALUES('', '".$_POST['name']."', '".$_POST['cell']."', '1*2*3*4*6*7*9', '123456', '".date('Y-m-d H:i', time()+4*60*60)."', '".$_POST['wechat']."')";
		mysqli_query($link, $q) ;
		$msg = "新的店经理已经添加";
	}
}
?>
<!DOCTYPE HTML>
<!--
	Arcana by HTML5 UP
	html5up.net | @ajlkn
	Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
	<head>
		<title>Arcana by HTML5 UP</title>
		<meta http-equiv="Content-Type" content="text/html; charset="utf-8" />
		<meta name="viewport" content="width=device-width, initial-scale=1" />
		<!--[if lte IE 8]><script src="assets/js/ie/html5shiv.js"></script><![endif]-->
		<link rel="stylesheet" href="assets/css/main.css" />
		<!--[if lte IE 8]><link rel="stylesheet" href="assets/css/ie8.css" /><![endif]-->
		<!--[if lte IE 9]><link rel="stylesheet" href="assets/css/ie9.css" /><![endif]-->
	</head>
	<body>
	    <? if ($login == 0) {?>
		<div id="page-wrapper">
			<!-- Header -->
				<div id="header">
                
					<!-- Logo -->
						<h1><a href="index.html" id="logo">Arcana <em>by HTML5 UP</em></a></h1>

					<!-- Nav -->
						<nav id="nav">
							<ul>
								<li class="current"><a href="index.html">Home</a></li>
								<li>
									<a href="#">Dropdown</a>
									<ul>
										<li><a href="#">Lorem dolor</a></li>
										<li><a href="#">Magna phasellus</a></li>
										<li><a href="#">Etiam sed tempus</a></li>
										<li>
											<a href="#">Submenu</a>
											<ul>
												<li><a href="#">Lorem dolor</a></li>
												<li><a href="#">Phasellus magna</a></li>
												<li><a href="#">Magna phasellus</a></li>
												<li><a href="#">Etiam nisl</a></li>
												<li><a href="#">Veroeros feugiat</a></li>
											</ul>
										</li>
										<li><a href="#">Veroeros feugiat</a></li>
									</ul>
								</li>
								<li><a href="left-sidebar.html">Left Sidebar</a></li>
								<li><a href="right-sidebar.html">Right Sidebar</a></li>
								<li><a href="two-sidebar.html">Two Sidebar</a></li>
								<li><a href="no-sidebar.html">No Sidebar</a></li>
							</ul>
						</nav>
				</div>

			<!-- Banner -->
				<section id="banner">
					<header>
						<h2>Arcana: <em>A responsive site template freebie by <a href="http://html5up.net">HTML5 UP</a></em></h2>
						<a href="#" class="button">Learn More</a>
					</header>
				</section>

			<!-- Posts -->
				<section class="wrapper style1">
					<div class="container">
						<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>请登录</h3>
										<p><form method="POST" action="index.php">
									<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
									  <tr>
										<td width="30%">用户名</td>
										<td width="70%"><input type="text" name="cell" size="20"></td>
									  </tr>
									  <tr>
										<td width="30%">密码</td>
										<td width="70%"><input type="password" name="logincode" size="20"></td>
									  </tr>
									  <tr>
										<td width="30%"><button name="B1" type="reset">重置</button></td>
										<td width="70%"><button name="login_submit" type="submit">提交</button></td>
									  </tr>
									</table></form>
									</p>
									</div>
								</div>
							</section>
						</div>
					</div>
				</section>

			<!-- CTA -->
				<section id="cta" class="wrapper style3">
					<div class="container">
						<header>
							<h2>Are you ready to continue your quest?</h2>
							<a href="#" class="button">Insert Coin</a>
						</header>
					</div>
				</section>

			<!-- Footer -->
				<div id="footer">
					<div class="container">
						<div class="row">
							<section class="3u 6u(narrower) 12u$(mobilep)">
								<h3>Links to Stuff</h3>
								<ul class="links">
									<li><a href="#">Mattis et quis rutrum</a></li>
									<li><a href="#">Suspendisse amet varius</a></li>
									<li><a href="#">Sed et dapibus quis</a></li>
									<li><a href="#">Rutrum accumsan dolor</a></li>
									<li><a href="#">Mattis rutrum accumsan</a></li>
									<li><a href="#">Suspendisse varius nibh</a></li>
									<li><a href="#">Sed et dapibus mattis</a></li>
								</ul>
							</section>
							<section class="3u 6u$(narrower) 12u$(mobilep)">
								<h3>More Links to Stuff</h3>
								<ul class="links">
									<li><a href="#">Duis neque nisi dapibus</a></li>
									<li><a href="#">Sed et dapibus quis</a></li>
									<li><a href="#">Rutrum accumsan sed</a></li>
									<li><a href="#">Mattis et sed accumsan</a></li>
									<li><a href="#">Duis neque nisi sed</a></li>
									<li><a href="#">Sed et dapibus quis</a></li>
									<li><a href="#">Rutrum amet varius</a></li>
								</ul>
							</section>
							<section class="6u 12u(narrower)">
								<h3>Get In Touch</h3>
								<form>
									<div class="row 50%">
										<div class="6u 12u(mobilep)">
											<input type="text" name="name" id="name" placeholder="Name" size="20" />
										</div>
										<div class="6u 12u(mobilep)">
											<input type="email" name="email" id="email" placeholder="Email" size="20" />
										</div>
									</div>
									<div class="row 50%">
										<div class="12u">
											<textarea name="message" id="message" placeholder="Message" rows="5" cols="20"></textarea>
										</div>
									</div>
									<div class="row 50%">
										<div class="12u">
											<ul class="actions">
												<li><input type="submit" class="button alt" value="Send Message" /></li>
											</ul>
										</div>
									</div>
								</form>
							</section>
						</div>
					</div>

					<!-- Icons -->
						<ul class="icons">
							<li><a href="#" class="icon fa-twitter"><span class="label">Twitter</span></a></li>
							<li><a href="#" class="icon fa-facebook"><span class="label">Facebook</span></a></li>
							<li><a href="#" class="icon fa-github"><span class="label">GitHub</span></a></li>
							<li><a href="#" class="icon fa-linkedin"><span class="label">LinkedIn</span></a></li>
							<li><a href="#" class="icon fa-google-plus"><span class="label">Google+</span></a></li>
						</ul>

					<!-- Copyright -->
						<div class="copyright">
							<ul class="menu">
								<li>&copy; Untitled. All rights reserved</li><li>Design: <a href="http://html5up.net">HTML5 UP</a></li>
							</ul>
						</div>

				</div>

		</div>
         <? } if ($login == 1) { ?>
			<div id="page-wrapper">
			<!-- Header -->
				<div id="header">
                
					 <!-- Logo -->
						<h1>Let's Party <em> 我们嗨吧！</em></h1> <? echo "<font size='2'>".$cell."</font>";?>

					<!-- Nav -->
						<nav id="nav">
							<ul>
							    <? for ($j=0; $j<count($itemid); $j++) { ?>
								<li>
									<a href="index.php?menucode=<? echo $item[$j][2]; ?>"><? echo $item[$j][1]; ?></a>
									<? if (!empty($item[$j][3])) {?>
									<ul>
									 <? $subitem = explode("*", $item[$j][3]); 
									 for ($i=0; $i<count($subitem); $i++) {?>  
										<li><a href="index.php?subcode=<? echo ($item[$j][2]+$i+1); ?>"><? echo $subitem[$i]; ?></a></li>
									 <? } ?>
									</ul>
									<? } ?>
								</li>
								<? } ?>
							</ul>
						</nav>
				</div>

			<!-- Posts -->
				<section class="wrapper style1">
					<div class="container">
					<? if ($menucode == 0&&$subcode == 0) {
						$appt = Appt_List($userid, $link, 0);
						for ($i=0; $i<count($appt); $i++) { ?>
								<div class="row">
								<section class="6u 12u(narrower)">
										<div class="box post">
										<div class="inner">
											<h3><? if (!empty($appt[$i][0])) { echo $appt[$i][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="10%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">状态</font></td>
												<? if ($is_worker == 1) {?>
												<td width="25%" <font size="2">输入收款</font></td> <? } else {?>
												<td width="25%"></td> <? }?>
												<td width="15%"></td>
											  </tr>
											  <tr><? $q = "SELECT grade FROM blacklist WHERE cell='".$appt[$i][2]."'";
											         $re = mysqli_query($link, $q) ;
	                                                 $info = mysqli_fetch_array($re);  
													 if (empty($info[0])||$info[0] == 2) $clr = "black";
													 else {
														 if ($info[0] == 1) $clr = "green";
														 if ($info[0] == 3) $clr = "yellow";
														 if ($info[0] == 4) $clr = "red";
													 }?>
												<td width="10%"><? echo "<font color='".$clr."'>".substr($appt[$i][2], -4);?></font><input type="hidden" name="cell" value="<? echo $appt[$i][2];?>">　</td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i][3])); ?> <input type="hidden" name="intime" value="<? echo $appt[$i][3];?>">　</td>
												<td width="15%"><? if ($appt[$i][4] == 0) echo "<font size='2'>还未到</font>"; else echo "<font size='2'>已到达</font>";?>　</td>
												 <? if ($is_worker == 1) {?>
												 <td width="15%"><input type="text" name="pay" size="3"></td>
												 <td width="10%"><button name="appt_submit" type="submit" value="<? echo $appt[$i][1]; ?>">确认</button></td> <? } else {?>
												 <td width="15%"></td>
												 <td width="15%"></td> <? } ?>
											  </tr>
											  <tr>
											    <td width="10%" ><font size="2">联络他</font></td>
											    <td width="40%" colspan="3"><select size="1" name="message" style="font-size: 8pt">
												<option value="1">这个时间可以，来吧！</option>
												<option value="2a">对不起，请稍等一下</option>
												<option value="2b">请再按门铃一次，谢谢</option>
												<option value="2c">你到了吗？门铃号已经发送给你</option>
												<option value="3a">可以了，请进来吧</option>
												<option value="4a">抱歉，请推迟一个小时到</option>
												<option value="5a">抱歉，请推迟半个小时到</option>
												<option value="6">请站到门钟旁边来/请到我的地址来</option>
												<? $q ="SELECT buzz, suite FROM store WHERE id=(SELECT storeid FROM appt WHERE id='".$appt[$i][1]."')";
												   $re = mysqli_query($link, $q) ;
	                                               $buzzinfo = mysqli_fetch_array($re); 
												   $buzzinfo[0] = str_replace("*", "", $buzzinfo[0]);
												   $buzzinfo[1] = str_replace("*", "", $buzzinfo[1]);
												   if (strpos($buzzinfo[0], "||") !== false){
													   $entrybuzz = explode("||", $buzzinfo[0]);
													   $entrysuite = explode("||", $buzzinfo[1]);
												?>
												<option value="7">发出门钟号码<? echo $entrybuzz[0];?></option>
												<option value="8">发出房间号码<? echo $entrysuite[0];?></option>
												<option value="9">发出门钟号码<? echo $entrybuzz[1];?></option>
												<option value="10">发出房间号码<? echo $entrysuite[1];?></option>
												   <? } else {?>
												<option value="7">发出门钟号码<? echo $buzzinfo[0]; ?></option>
												<option value="8">发出房间号码<? echo $buzzinfo[1]; ?></option> <? }?>
												</select></td>
												<td width="25%" align="left"><button name="send_message" type="submit" value="1">发出</button></td>
											  </tr>
											  <tr><td colspan="4">或者<a href="girlmessagesend.php?id=<? echo $appt[$i][1]; ?>">点击此处</a>自写信息发给他。</td></tr>
											</table>
											</form><? } else { ?> 暂无 </h3> <p> 暂无 <? } ?></p>
										</div>
									</div>
								</section>
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? if (!empty($appt[$i+1][0])) { echo $appt[$i+1][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="10%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">状态</font></td>
												<? if ($is_worker == 1) {?>
												<td width="25%"><font size="2">输入收款</font></td> <? } else {?>
												<td width="25%"></td> <? }?>
												<td width="25%"></td>
											  </tr>
											  <tr><? $q = "SELECT grade FROM blacklist WHERE cell='".$appt[$i+1][2]."'";
											         $re = mysqli_query($link, $q) ;
	                                                 $info = mysqli_fetch_array($re);  
													 if (empty($info[0])||$info[0] == 2) $clr = "black";
													 else {
														 if ($info[0] == 1) $clr = "green";
														 if ($info[0] == 3) $clr = "yellow";
														 if ($info[0] == 4) $clr = "red";
													 }?>
												<td width="10%"><? echo "<font color='".$clr."'>".substr($appt[$i+1][2], -4);?>　</font><input type="hidden" name="cell" value="<? echo $appt[$i+1][2];?>"></td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i+1][3])); ?>　<input type="hidden" name="intime" value="<? echo $appt[$i+1][3];?>"></td>
												<td width="15%"><? if ($appt[$i+1][4] == 0) echo "<font size='2'>还未到</font>"; else echo "<font size='2'>已到达</font>";?>　</td>
												<? if ($is_worker == 1) {?>
												 <td width="15%"><input type="text" name="pay" size="3"></td>
												<td width="10%"><button name="appt_submit" type="submit" value="<? echo $appt[$i+1][1];?>">确认</button></td> <? } else {?>
												<td width="15%"></td>
												<td width="10%"></td> <? } ?>
											  </tr>
											  <tr>
											    <td width="10%" ><font size="2">联络他</font></td>
											    <td width="40%" colspan="3"><select size="1" name="message" style="font-size: 8pt">
												<option value="1">这个时间可以，来吧！</option>
												<option value="2a">对不起，请稍等一下</option>
												<option value="2b">请再按门铃一次，谢谢</option>
												<option value="2c">你到了吗？门铃号已经发送给你</option>
												<option value="3a">可以了，请进来吧</option>
												<option value="4a">抱歉，请推迟一个小时到</option>
												<option value="5a">抱歉，请推迟半个小时到</option>
												<option value="6">请站到门钟旁边来/请到我的地址来</option>
												<? $q ="SELECT buzz, suite FROM store WHERE id=(SELECT storeid FROM appt WHERE id='".$appt[$i+1][1]."')";
												   $re = mysqli_query($link, $q) ;
	                                               $buzzinfo = mysqli_fetch_array($re); 
												   $buzzinfo[0] = str_replace("*", "", $buzzinfo[0]);
												   $buzzinfo[1] = str_replace("*", "", $buzzinfo[1]);
												   if (strpos($buzzinfo[0], "||") !== false){
													   $entrybuzz = explode("||", $buzzinfo[0]);
													   $entrysuite = explode("||", $buzzinfo[1]);
												?>
												<option value="7">发出门钟号码<? echo $entrybuzz[0];?></option>
												<option value="8">发出房间号码<? echo $entrysuite[0];?></option>
												<option value="9">发出门钟号码<? echo $entrybuzz[1];?></option>
												<option value="10">发出房间号码<? echo $entrysuite[1];?></option>
												   <? } else {?>
												<option value="7">发出门钟号码<? echo $buzzinfo[0]; ?></option>
												<option value="8">发出房间号码<? echo $buzzinfo[1]; ?></option> <? }?>
												</select></td>
												<td width="25%" align="left"><button name="send_message" value="1" type="submit">发出</button></td>
											  </tr>
											   <tr><td colspan="4">或者<a href="girlmessagesend.php?id=<? echo $appt[$i+1][1]; ?>">点击此处</a>自写信息发给他。</td></tr>
											</table>
											</form><? } else {?> 暂无 </h3> <p> 暂无 <? }?></p>
										</div>
									</div>
								</section> </div> <?
								 $i++;
							}
						  
					} else if ($subcode == 101) { 
					     $q = "SELECT * FROM store WHERE managerid='".$userid."'";
						 $re = mysqli_query($link, $q) ;
				         while ( $rw = mysqli_fetch_row($re) ){ 
						       $info[] = array($rw[0], $rw[1], $rw[3], $rw[4], $rw[5], $rw[6], $rw[7]); 
							  }
						 for ($i=0; $i<count($info); $i++){
							   ?> 
							<div class="row">
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? echo $info[$i][1];?></h3>
											<p><form method="POST" action="index.php">
												<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" height="102">
												  <tr>
													<td width="20%" height="16"><font size="1">地址</font></td>
													<td width="80%" height="16"><input type="text" name="address" size="20" value="<? echo $info[$i][2];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1">城市</font></td>
													<td width="80%" height="16"><input type="text" name="city" size="20" value="<? echo $info[$i][3];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="17"><font size="1">门铃</font></td>
													<td width="80%" height="17"><input type="text" name="buzz" size="20" value="<? echo $info[$i][4];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1">房间号</font></td>
													<td width="80%" height="16"><input type="text" name="suite" size="20" value="<? echo $info[$i][5];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1">最近的十字路</font></td>
													<td width="80%" height="16"><input type="text" name="cross" size="20" value="<? echo $info[$i][6];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1"><select size="1" name="operation">
													<option value="1" selected>修改</option>
													<option value="2">删除</option>
													</select></font></td>
													<td width="80%" height="16"><input type="hidden" name="name" value="<? echo $info[$i][1]; ?>"><button name="store_submit" type="submit" value="<? echo $info[$i][0];?>">提交</button></td>
												  </tr>
												</table></form>
</p>
										</div>
									</div>
								</section>
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? echo $info[$i+1][1]; ?></h3>
											<p><form method="POST" action="index.php">
												<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" height="102">
												  <tr>
													<td width="20%" height="16"><font size="1">地址</font></td>
													<td width="80%" height="16"><input type="text" name="address" size="20" value="<? echo $info[$i+1][2];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1">城市</font></td>
													<td width="80%" height="16"><input type="text" name="city" size="20" value="<? echo $info[$i+1][3];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="17"><font size="1">门铃</font></td>
													<td width="80%" height="17"><input type="text" name="buzz" size="20" value="<? echo $info[$i+1][4];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1">房间号</font></td>
													<td width="80%" height="16"><input type="text" name="suite" size="20" value="<? echo $info[$i+1][5];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1">最近的十字路</font></td>
													<td width="80%" height="16"><input type="text" name="cross" size="20" value="<? echo $info[$i+1][6];?>"></td>
												  </tr>
												  <tr>
													<td width="20%" height="16"><font size="1"><select size="1" name="operation">
													<option value="1" selected>修改</option>
													<option value="2">删除</option>
													</select></font></td>
													<td width="80%" height="16"><input type="hidden" name="name" value="<? echo $info[$i+1][1]; ?>"><button name="store_submit" type="submit" value="<? echo $info[$i+1][0];?>">提交</button></td>
												  </tr>
												</table></form></p>
										</div>
									</div>
								</section>
							</div>
						 <? $i++; }
					} else if ($subcode == 102){			 ?>
							<div class="row">
									<section class="6u 12u(narrower)">
										<div class="box post">
											
											<div class="inner">
												<h3>增加新店</h3>
												<p><form method="POST" action="index.php">
												<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
												  <tr>
													<td width="30%"><span lang="zh-cn"><font size="2">名字</font></span></td>
													<td width="70%"><input type="text" name="name" size="20"></td>
												  </tr>
												  <tr>
													<td width="30%"><font size="2">地址</font></td>
													<td width="70%"><input type="text" name="address" size="20"></td>
												  </tr>
												  <tr>
													<td width="30%"><font size="2">城市</font></td>
													<td width="70%"><input type="text" name="city" size="20"></td>
												  </tr>
												</table>
												</p>
											</div>
										</div>
									</section>
									<section class="6u 12u(narrower)">
										<div class="box post">
											
											<div class="inner">
												<h3>增加新店</h3>
												<p><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
												  <tr>
													<td width="30%"><font size="2">门铃</font></td>
													<td width="70%"><input type="text" name="buzz" size="20"></td>
												  </tr>
												  <tr>
													<td width="30%"><font size="2">房间号</font></td>
													<td width="70%"><input type="text" name="suite" size="20"></td>
												  </tr>
												  <tr>
													<td width="30%"><font size="2">房型及最近十字路口</font></td>
													<td width="70%"><input type="text" name="cross" size="38"></td>
												  </tr>
												  <tr>
													<td width="30%">&nbsp;</td>
													<td width="70%"><button name="add_store_submit" type="submit" value="1"><span lang="zh-cn">提交</span>
													</button></td>
												  </tr>
												</table></form>
												</p>
											</div>
										</div>
									</section>
							</div> 
					<? } else if ($subcode == 201) { 
					    if (empty($_POST['girlprofileid'])){
												$q = "SELECT id, name FROM store WHERE managerid ='".$userid."'";
												 $re = mysqli_query($link, $q) ;
												 while ( $rw = mysqli_fetch_row($re) ){ 
													 $q = "SELECT id, name FROM girlprofile WHERE storeid='".$rw[0]."'";
													 $res = mysqli_query($link, $q) ;
													 while ( $rw1 = mysqli_fetch_row($res) ){ 
														 $girl[] = array($rw[1], $rw1[0], $rw1[1]); 
													 }
						                          } 
												  if ($is_worker == 1){
													  $q = "SELECT id, name, storeid FROM girlprofile WHERE userid='".$userid."'";
													  $re = mysqli_query($link, $q) ;
													  $info = mysqli_fetch_array($re);
													  $q = "SELECT name FROM store WHERE id='".$info[2]."'";
													  $re = mysqli_query($link, $q) ;
													  $info1 = mysqli_fetch_array($re);
													  $girl[0] = array($info1[0], $info[0], $info[1]);
												  }
						?>
					   <div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>技师管理</h3>
										<p><form method="post" action="index.php?subcode=201">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="30%">选择技师</td>
											<td width="70%"><select size="1" name="girlprofileid">
											<? for ($i=0; $i<count($girl); $i++){
												echo "<option value='".$girl[$i][1]."'>".$girl[$i][2]."---".$girl[$i][0]." </option>";
											} ?></select></td>
										  </tr>
										  <tr>
											<td width="30%">选择操作</td>
											<td width="70%"><select size="1" name="operation">
											<option selected value="1">修改或移动</option>
											<option value="2">删除</option>
											</select></td>
										  </tr>
										  <tr>
											<td width="30%"></td>
											<td width="70%"><button name="girl1_submit" type="submit" value="1">提交</button></td>
										  </tr>
										</table>
										</form>
										</p>
									</div>
								</div>
							</section>
					</div> 
					<? } else { 
					   $q = "SELECT * FROM girlprofile WHERE id='".$_POST['girlprofileid']."'";
					   $re = mysqli_query($link, $q) ;
	                   $girlinfo = mysqli_fetch_assoc($re);
					   $q = "SELECT name FROM store WHERE id='".$girlinfo['storeid']."'";
					   $re = mysqli_query($link, $q) ;
					   $currentstore = mysqli_fetch_array($re);
					   $q = "SELECT id, name FROM store WHERE managerid='".$userid."'";
					   $re = mysqli_query($link, $q) ;
					   while ( $rw = mysqli_fetch_row($re) ){ 
					      $storeinfo[] = array($rw[0], $rw[1]);
					   }
					   
					   ?>
					    <div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $girlinfo['name']."---".$currentstore[0];?></h3>
										<p><form method="POST" action="index.php" enctype="multipart/form-data">
									<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="39%" id="AutoNumber1">
									  <tr>
										<td width="49%"><span lang="zh-cn"><font size="1">名字</font></span></td>
										<td width="51%"><input type="text" name="name" size="20" value="<? echo $girlinfo['name'];?>"></td>
									  </tr>
									  <tr>
										<td width="49%"><font size="1">价格（15分钟*30*45*60*90*120*外卖60分钟*外卖90分钟）</font></td>
										<td width="51%"><input type="text" name="rate" size="20" value="<? echo $girlinfo['rate'];?>"></td>
									  </tr>
									  <tr>
										<td width="49%"><font size="1">给接线生支出（incall*outcall）</font></td>
										<td width="51%"><input type="text" name="cut2p" size="20" value="<? echo $girlinfo['cut2p'];?>"></td>
									  </tr>
									  <tr>
										<td width="49%"><font size="1">给店经理支出（15分钟*30*45*60*90*120*外卖60分钟*外卖90分钟）</font></td>
										<td width="51%"><input type="text" name="cut2m" size="20" value="<? echo $girlinfo['cut2m'];?>"></td>
									  </tr>
									  <tr>
										<td width="49%"><font size="1">三围*体重*身高*年龄</font></td>
										<td width="51%"><input type="text" name="measurement" size="20" value="<? echo $girlinfo['measurement'];?>"></td>
									  </tr>
									  <tr>
										<td width="49%"><font size="1">出生地</font></td>
										<td width="51%"><input type="text" name="birthpl" size="20" value="<? echo $girlinfo['birthpl'];?>"></td>
									  </tr>
									  <tr>
										<td width="49%"><font size="1">价格包含的服务</font></td>
										<td width="51%"><input type="text" name="dos" size="20" value="<? echo $girlinfo['dos'];?>"></td>
									  </tr>
									</table>

									</p>
									</div>
								</div>
							</section>
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $girlinfo['name']."---".$currentstore[0];?></h3>
										<p> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="39%" id="AutoNumber1">
								  <tr>
									<td width="49%"><span lang="zh-cn"><font size="1">不能提供的服务</font></span></td>
									<td width="51%"><input type="text" name="notdos" size="20" value="<? echo $girlinfo['notdos'];?>"></td>
								  </tr>
								  <tr>
									<td width="49%"><font size="1">额外收费的服务</font></td>
									<td width="51%"><input type="text" name="extras" size="20" value="<? echo $girlinfo['extras'];?>"></td>
								  </tr>
								  <tr>
									<td width="49%"><font size="1">工作时间（格式为00：00--23：00）</font></td>
									<td width="51%"><input type="text" name="workhours" size="20" value="<? echo $girlinfo['workhours'];?>"></td>
								  </tr>
								  	<tr>
									<td width="49%"><font size="1">工作的店名</font></td>
									<td width="51%"><select size="1" name="storeid">
											<option selected value="<? echo $girlinfo['storeid'];?>"><? echo $currentstore[0];?></option>
											<? for ($i=0; $i<count($storeinfo); $i++){
											echo "<option value='".$storeinfo[$i][0]."'>".$storeinfo[$i][1]."</option>"; }
											?></select></td>
								  </tr>
								  <tr>
									<td width="49%"><font size="1">相片1(小于10M)</font><img src="data:image/jpeg;base64, <? echo base64_encode($girlinfo['photo1']);?>" alt="photo1" width="100" height="100"></td>
									<td width="51%"><input type="hidden" name="MAX_FILE_SIZE" value="10000000"><input type="file" name="photo1" size="20" id="photo1"></td>
								  </tr>
								  <tr>
									<td width="49%"><font size="1">相片2(小于10M)</font><img src="data:image/jpeg;base64, <? echo base64_encode($girlinfo['photo2']);?>" alt="photo2" width="100" height="100"></td>
									<td width="51%"><input type="hidden" name="MAX_FILE_SIZE" value="10000000"><input type="file" name="photo2" size="20" id="photo2"></td>
								  </tr>
								  <tr>
									<td width="49%"><font size="1">相片3(小于10M)</font><img src="data:image/jpeg;base64, <? echo base64_encode($girlinfo['photo3']);?>"  alt="photo3" width="100" height="100"></td>
									<td width="51%"><input type="hidden" name="MAX_FILE_SIZE" value="10000000"><input type="file" name="photo3" size="20" id="photo3"></td>
								  </tr>
								  <tr>
									<td width="51%"><button name="girl2_submit" type="submit" value="<? echo $girlinfo['id'];?>">提交</button></td>
								  </tr>
								</table> </form>
                                </p>
									</div>
								</div>
							</section>
						</div>
					<?} } else if ($subcode == 202&&$is_worker == 0) { ?>
						<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>增加新技师</h3>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="30%">名字</td>
											<td width="70%"><input type="text" name="name" size="20"></td>
										  </tr>
										  <tr>
											<td width="30%">手机号</td>
											<td width="70%"><input type="text" name="cell" size="20"></td>
										  </tr>
										  <tr>
											<td width="30%">微信号</td>
											<td width="70%"><input type="text" name="wechat" size="20"></td>
										  </tr>
										  <tr>
											<td width="30%">　</td>
											<td width="70%"><button name="new_girl_submit" type="submit" value="1">提交</button></td>
										  </tr>
										</table></form>
										</p>
									</div>
								</div>
							</section>
						</div>
					<? } else if ($subcode == 203) { ?>
						<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>改变临时上工或放工状态</h3>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										<? $q = "SELECT id, name, status FROM girlprofile WHERE userid=(SELECT id FROM users WHERE cell='".$cell."')"; 
										   $re = mysqli_query($link, $q) ;
										   $info = mysqli_fetch_array($re);
										?>
										  <tr>
											<td width="30%">名字</td>
											<td width="70%"><?  echo $info[1]; ?> <font size='1'>当前状态是： <? if ($info[2] == 0) echo "放工"; else echo "上工";?></font></td>
										  </tr>
										  <tr>
											<td width="30%">选择状态:</td>
											<td width="70%"><select size="1" name="status">
												<option selected value="1">上工</option>
												<option value="0">放工</option>
												</select></td>
										  </tr>
										  <tr>
											<td width="30%">　</td>
											<td width="70%"><button name="girlstatus_submit" type="submit" value="<? echo $info[0]; ?>">提交</button></td>
										  </tr>
										</table></form>
										</p>
									</div>
								</div>
							</section>
						</div>
				
					<? }else if ($menucode == 300) { 
					        $q = "SELECT id, name FROM store WHERE managerid='".$userid."'";
						    $re = mysqli_query($link, $q) ;
							 while ( $rw = mysqli_fetch_row($re) ){ 
								 $q = "SELECT id, userid, name FROM girlprofile WHERE storeid='".$rw[0]."'";
								 $res = mysqli_query($link, $q) ;
								 while ($row = mysqli_fetch_row($res)) {
									 $q = "SELECT name, cell FROM users WHERE id='".$row[1]."'";
									 $res1 = mysqli_query($link, $q) ;
									 $info1 = mysqli_fetch_array($res1);
									 $income = Income_Cal($row[1],0, $link, 1);                 //0 -----today's income
									 $income7 = Income_Cal($row[1],7, $link, 1);                 //7 ----- last seven days
									 $income15 = Income_Cal($row[1],15, $link, 1);                 //15 ----- last 15 days
									 $incomeall = Income_Cal($row[1], -1, $link, 1);               // all ---- all income
									 $q = "SELECT amount FROM payment WHERE senderid='".$row[1]."'&&receiverid='".$userid."'";
									 $res2 = mysqli_query($link, $q) ;
									 $pay = 0;  
									 while ( $rw1 = mysqli_fetch_row($res2) ){
										 $pay += $rw1[0];
									 }
									 $q = "SELECT amount FROM payment WHERE senderid='".$userid."'&&receiverid='".$row[1]."'";
									 $res2 = mysqli_query($link, $q) ;  
									 while ( $rw1 = mysqli_fetch_row($res2) ){
										 $pay -= $rw1[0];
									 }
									 $girl[] = array($rw[1], $row[1], $info1[0], $info1[1], $income, $income7, $income15, $incomeall-$pay);  //(store name, userid, girlname, cell, today's, 7days, 15days, balance)
								 } }  
							  if (empty($girl)){
								  $q = "SELECT storeid FROM girlprofile WHERE userid='".$userid."'";
								  $re = mysqli_query($link, $q) ;
								  $info = mysqli_fetch_array($re);
								  $q = "SELECT name, managerid FROM store WHERE id='".$info[0]."'";
								  $re = mysqli_query($link, $q) ;
								  $info = mysqli_fetch_array($re);
								  $income = Income_Cal($userid,0, $link, 1);                 //0 -----today's income
								 $income7 = Income_Cal($userid,7, $link, 1);                 //7 ----- last seven days
								 $income15 = Income_Cal($userid,15, $link, 1);                 //15 ----- last 15 days
								 $incomeall = Income_Cal($userid, -1, $link, 1);               // all ---- all income
								 $q = "SELECT amount FROM payment WHERE senderid='".$userid."'&&receiverid='".$info[1]."'";
								 $res = mysqli_query($link, $q) ;
								 $pay = 0;
							     while ( $rw1 = mysqli_fetch_row($res) ){
									 $pay += $rw1[0];
								 }
								 $q = "SELECT amount FROM payment WHERE senderid='".$info[1]."'&&receiverid='".$userid."'";
								 $res = mysqli_query($link, $q) ;
							     while ( $rw1 = mysqli_fetch_row($res) ){
									 $pay -= $rw1[0];
								 }
								 $girl1 = array($info[0], $income, $income7, $income15, $incomeall-$pay);
							  }
							if (empty($girl)){
						   ?>
						   
											<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $girl1[0]; ?></h3>
										<p>
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">今天</td>
											<td width="60%"><? echo $girl1[1]; ?></td>
										  </tr>
										  <tr>
											<td width="40%">过去7天</td>
											<td width="60%"><? echo $girl1[2]; ?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去15天</td>
											<td width="60%"><? echo $girl1[3]; ?>　</td>
										  </tr>
										  <tr>
											<td width="40%">余额</td>
											<td width="60%"><? echo $girl1[4]; ?>　</td>
										  </tr>
										</table>
										</p>
									</div>
								</div>
							</section>
							</div> <? } else { 
							for ($i=0; $i<count($girl); $i++) {?> 
							<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $girl[$i][2]."---".$girl[$i][0];?></h3>
										<p><font size="2"> <? echo $girl[$i][3];?></font></p>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">今天</td>
											<td width="60%"><? echo $girl[$i][4];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去7天</td>
											<td width="60%"><? echo $girl[$i][5];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去15天</td>
											<td width="60%"><? echo $girl[$i][6];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">余额</td>
											<td width="60%"><? echo $girl[$i][7];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">结算</td>
											<td width="60%"><input type="text" name="amount" size="20"></td>
										  </tr>
										  <tr>
											<td width="40%">　</td>
											<td width="60%"><button name="amount_submit" type="submit" value="<? echo $girl[$i][1];?>">提交</button></td>
										  </tr>
										</table>
										</form>
										</p>
									</div>
								</div>
							</section>
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $girl[$i+1][2]."---".$girl[$i+1][0];?></h3>
										<p><font size="2"> <? echo $girl[$i+1][3];?></font></p>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">今天</td>
											<td width="60%"><? echo $girl[$i+1][4];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去7天</td>
											<td width="60%"><? echo $girl[$i+1][5];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去15天</td>
											<td width="60%"><? echo $girl[$i+1][6];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">余额</td>
											<td width="60%"><? echo $girl[$i+1][7];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">结算</td>
											<td width="60%"><input type="text" name="amount" size="20"></td>
										  </tr>
										  <tr>
											<td width="40%">　</td>
											<td width="60%"><button name="amount_submit" type="submit" value="<? echo $girl[$i+1][1];?>">提交</button></td>
										  </tr>
										</table>
										</form>
										</p>
									</div>
								</div>
							</section>
						</div>
							<? $i++; }}}
							else if ($menucode == 400) {
								$q = "SELECT id, name FROM store WHERE managerid='".$userid."'";
								$re = mysqli_query($link, $q) ;
								$x1 = 0; $x2 = 0; $x3 = 0; $x4 = 0;
				                while ( $rw = mysqli_fetch_row($re) ){
									$q = "SELECT userid FROM girlprofile WHERE storeid='".$rw[0]."'";
									$res = mysqli_query($link, $q) ;
									$income = 0; $income7 = 0; $income15 = 0; $incomeall = 0;
				                    while ( $rw1 = mysqli_fetch_row($res) ){
									    $income += Income_Cal($rw1[0],0, $link, 2);                 //0 -----today's income
								        $income7 += Income_Cal($rw1[0],7, $link, 2);                 //7 ----- last seven days
								        $income15 += Income_Cal($rw1[0],15, $link, 2);                 //15 ----- last 15 days
								        $incomeall += Income_Cal($rw1[0], -1, $link, 2);               // all ---- all income	
									}
									$storepay[] = array($rw[1], $income, $income7, $income15, $incomeall);
									$x1 += $income;
									$x2 += $income7;
									$x3 += $income15;
									$x4 += $incomeall;
								}
								$q = "SELECT amount FROM payment WHERE senderid='".$userid."'&&receiverid='1'";
								 $res = mysqli_query($link, $q) ;
								 $pay = 0;
							     while ( $rw1 = mysqli_fetch_row($res) ){
									 $pay += $rw1[0];
								 }
								 $q = "SELECT amount FROM payment WHERE senderid='1'&&receiverid='".$userid."'";
								 $res = mysqli_query($link, $q) ;
							     while ( $rw1 = mysqli_fetch_row($res) ){
									 $pay -= $rw1[0];
								 }
								$x = count($storepay); 
								$storepay[$x] = array("总计", $x1, $x2, $x3, $x4-$pay);
                                
								for ($i=0; $i<count($storepay); $i++){
								?>
								<div class="row">
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? echo $storepay[$i][0]; ?></h3>
											<p><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">今天</td>
											<td width="60%"><? echo $storepay[$i][1];  ?></td>
										  </tr>
										  <tr>
											<td width="40%">过去7天</td>
											<td width="60%"><? echo $storepay[$i][2];  ?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去15天</td>
											<td width="60%"><? echo $storepay[$i][3];  ?>　</td>
										  </tr>
										  <tr>
											<td width="40%"><? if ($i == $x) echo "余额"; else echo "所有";?></td>
											<td width="60%"><? echo $storepay[$i][4];  ?>　</td>
										  </tr>
										</table></p>
										</div>
									</div>
								</section> <? if ($i+1 < count($storepay)) {?>
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? echo $storepay[$i+1][0]; ?></h3>
											<p><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">今天</td>
											<td width="60%"><? echo $storepay[$i+1][1];  ?></td>
										  </tr>
										  <tr>
											<td width="40%">过去7天</td>
											<td width="60%"><? echo $storepay[$i+1][2];  ?>　</td>
										  </tr>
										  <tr>
											<td width="40%">过去15天</td>
											<td width="60%"><? echo $storepay[$i+1][3];  ?>　</td>
										  </tr>
										  <tr>
											<td width="40%"><? if ($i == $x) echo "余额"; else echo "所有";?></td>
											<td width="60%"><? echo $storepay[$i+1][4];  ?>　</td>
										  </tr>
										</table></p>
										</div>
									</div>
								</section> <? } ?>
									</div> <?  $i++; }
									} else if ($menucode == 500) {
                                      $q = "SELECT managerid FROM store WHERE managerid !='1' GROUP BY managerid";
                                      $re = mysqli_query($link, $q) ;
									  $incomeall = 0;
				                      while ( $rw = mysqli_fetch_row($re) ){	
                                                $q = "SELECT id FROM store WHERE managerid='".$rw[0]."'";	
                                                $res = mysqli_query($link, $q) ;
				                                while ( $rw1 = mysqli_fetch_row($res) ){	
												       $q = "SELECT userid FROM appt WHERE storeid='".$rw1[0]."'&&status='2' GROUP BY userid";
													   $res1 = mysqli_query($link, $q) ;
				                                       while ( $rw2 = mysqli_fetch_row($res1) ){	
													        $incomeall += Income_Cal($rw2[0], -1, $link, 2); 
													   }
                                                }
										    $payout = 0; $owing = 0;
										    $q = "SELECT amount FROM payment WHERE senderid='".$rw[0]."'&&receiverid='1'";
											$res = mysqli_query($link, $q) ;
				                            while ( $rw1 = mysqli_fetch_row($res) ){	$payout += $rw1[0]; }
											
											$q = "SELECT amount FROM payment WHERE receiverid='".$rw[0]."'&&senderid='1'";
											$res = mysqli_query($link, $q) ;
				                            while ( $rw1 = mysqli_fetch_row($res) ){	$owing += $rw1[0]; }
											
                                            $q = "SELECT name, cell FROM users WHERE id='".$rw[0]."'";	
											$res = mysqli_query($link, $q) ;
											$manager = mysqli_fetch_array($res);
											$managerinfo[] = array($rw[0], $manager[0], $manager[1], $incomeall-$payout+$owing);
									    }									  
									  for ($i=0; $i<count($managerinfo); $i++){
                                       									  ?>
										<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $managerinfo[$i][1];?></h3>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">手机号</td>
											<td width="60%"><? echo $managerinfo[$i][2];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">余额</td>
											<td width="60%"><? echo $managerinfo[$i][3];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">结算</td>
											<td width="60%"><input type="text" name="amount" size="20"></td>
										  </tr>
										  <tr>
											<td width="40%">　</td>
											<td width="60%"><button name="phonepay_submit" type="submit" value="<? echo $managerinfo[$i][0];?>">提交</button></td>
										  </tr>
										</table>
										</form></p>
									</div>
								</div>
							</section>
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3><? echo $managerinfo[$i+1][1];?></h3>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="40%">手机号</td>
											<td width="60%"><? echo $managerinfo[$i+1][2];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">余额</td>
											<td width="60%"><? echo $managerinfo[$i+1][3];?>　</td>
										  </tr>
										  <tr>
											<td width="40%">结算</td>
											<td width="60%"><input type="text" name="amount" size="20"></td>
										  </tr>
										  <tr>
											<td width="40%">　</td>
											<td width="60%"><button name="phonepay_submit" type="submit" value="<? echo $managerinfo[$i+1][0];?>">提交</button></td>
										  </tr>
										</table>
										</form></p>
									</div>
								</div>
							</section>
									</div> <? $i++; } } else if ($subcode == 601) {
										$appt = Appt_List($userid, $link, 600);
						        for ($i=0; $i<count($appt); $i++) { ?>
								       <div class="row">
								       <section class="6u 12u(narrower)">
										<div class="box post">
										<div class="inner">
											<h3><? if (!empty($appt[$i][0])) { echo $appt[$i][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="10%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">状态</font></td>
												<? if ($is_worker == 1) {?>
												<td width="25%" <font size="2">输入收款</font></td> <? } else {?>
												<td width="25%"></td> <? }?>
												<td width="15%"></td>
											  </tr>
											  <tr><? $q = "SELECT grade FROM blacklist WHERE cell='".$appt[$i][2]."'";
											         $re = mysqli_query($link, $q) ;
	                                                 $info = mysqli_fetch_array($re);  
													 if (empty($info[0])||$info[0] == 2) $clr = "black";
													 else {
														 if ($info[0] == 1) $clr = "green";
														 if ($info[0] == 3) $clr = "yellow";
														 if ($info[0] == 4) $clr = "red";
													 }?>
												<td width="10%"><? echo "<font color='".$clr."'>".substr($appt[$i][2], -4);?></font><input type="hidden" name="cell" value="<? echo $appt[$i][2];?>">　</td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i][3])); ?> <input type="hidden" name="intime" value="<? echo $appt[$i][3];?>">　</td>
												<td width="15%"><? if ($appt[$i][4] == 0) echo "<font size='2'>还未到</font>"; else echo "<font size='2'>已到达</font>";?>　</td>
												 <? if ($is_worker == 1) {?>
												 <td width="15%"><input type="text" name="pay" size="3"></td>
												 <td width="10%"><button name="appt_submit" type="submit" value="<? echo $appt[$i][1]; ?>">确认</button></td> <? } else {?>
												 <td width="15%"></td>
												 <td width="15%"></td> <? } ?>
											  </tr>
											  <tr>
											    <td width="10%" ><font size="2">联络他</font></td>
											    <td width="40%" colspan="3"><select size="1" name="message" style="font-size: 8pt">
												<option value="1">这个时间可以，来吧！</option>
												<option value="2">对不起，请稍等一下</option>
												<option value="3">可以了，请进来吧</option>
												<option value="4">抱歉，请推迟一个小时到</option>
												<option value="5">抱歉，请推迟半个小时到</option>
												<option value="6">请站到门钟旁边来/请到我的地址来</option>
												<option value="7">发出门钟号码</option>
												<option value="8">发出房间号码</option>
												</select></td>
												<td width="25%" align="left"><button name="send_message" type="submit" value="1">发出</button></td>
											  </tr>
											</table>
											</form><? } else { ?> 暂无 </h3> <p> 暂无 <? }?>

											</p>
										</div>
									</div>
								</section>
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? if (!empty($appt[$i+1][0])) { echo $appt[$i+1][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="10%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">状态</font></td>
												<? if ($is_worker == 1) {?>
												<td width="25%"><font size="2">输入收款</font></td> <? } else {?>
												<td width="25%"></td> <? }?>
												<td width="25%"></td>
											  </tr>
											  <tr><? $q = "SELECT grade FROM blacklist WHERE cell='".$appt[$i+1][2]."'";
											         $re = mysqli_query($link, $q) ;
	                                                 $info = mysqli_fetch_array($re);  
													 if (empty($info[0])||$info[0] == 2) $clr = "black";
													 else {
														 if ($info[0] == 1) $clr = "green";
														 if ($info[0] == 3) $clr = "yellow";
														 if ($info[0] == 4) $clr = "red";
													 }?>
												<td width="10%"><? echo "<font color='".$clr."'>".substr($appt[$i+1][2], -4);?>　</font><input type="hidden" name="cell" value="<? echo $appt[$i+1][2];?>"></td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i+1][3])); ?>　<input type="hidden" name="intime" value="<? echo $appt[$i+1][3];?>"></td>
												<td width="15%"><? if ($appt[$i+1][4] == 0) echo "<font size='2'>还未到</font>"; else echo "<font size='2'>已到达</font>";?>　</td>
												<? if ($is_worker == 1) {?>
												 <td width="15%"><input type="text" name="pay" size="3"></td>
												<td width="10%"><button name="appt_submit" type="submit" value="<? echo $appt[$i+1][1];?>">确认</button></td> <? } else {?>
												<td width="15%"></td>
												<td width="10%"></td> <? } ?>
											  </tr>
											  <tr>
											    <td width="10%" ><font size="2">联络他</font></td>
											    <td width="40%" colspan="3"><select size="1" name="message" style="font-size: 8pt">
												<option value="1">这个时间可以，来吧！</option>
												<option value="2">对不起，请稍等一下</option>
												<option value="3">可以了，请进来吧</option>
												<option value="4">抱歉，请推迟一个小时到</option>
												<option value="5">抱歉，请推迟半个小时到</option>
												<option value="6">请站到门钟旁边来/请到我的地址来</option>
												<option value="7">发出门钟号码</option>
												<option value="8">发出房间号码</option>
												</select></td>
												<td width="25%" align="left"><button name="send_message" value="1" type="submit">发出</button></td>
											  </tr>
											</table>
											</form><? } else {?> 暂无 </h3> <p> 暂无 <? }?></p>
										</div>
									</div>
								</section> </div> <?
								 $i++;
									}	}  else if ($subcode == 602) {
										$appt = Appt_List($userid, $link, -1);
						               for ($i=0; $i<count($appt); $i++) { ?>
										   <div class="row"> <?  if (!empty($appt[$i][4])) { ?>
										   <section class="6u 12u(narrower)">
											<div class="box post">
											<div class="inner">
											<h3><? echo $appt[$i][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="15%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">技师</font></td>
												<td width="30%" ><font size="2">收款</font></td>
												<td width="25%" ><font size="2">修改</font></td>
											  </tr>
											  <tr>
												<td width="15%"><? echo substr($appt[$i][2], -4);?>　</td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i][5])); ?>　</td>
												<td width="15%"><? $q = "SELECT name FROM girlprofile WHERE userid='".$appt[$i][3]."'";
												 $re = mysqli_query($link, $q) ;
	                                             $name = mysqli_fetch_array($re); echo $name[0];?>　</td>
												<td width="20%"><? echo $appt[$i][4];?></td>
												 <td width="15%"><input type="text" name="pay" size="11"></td>
												<td width="10%"><button name="appt_submit" type="submit" value="<? echo $appt[$i][1]; ?>">确认</button></td>
											  </tr>
											</table>
											</form>

											</p>
										</div>
									</div>
										   </section> <? }   if (!empty($appt[$i+1][4])) { ?>
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? echo $appt[$i+1][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="15%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">技师</font></td>
												<td width="30%" ><font size="2">收款</font></td>
												<td width="25%" ><font size="2">修改</font></td>
											  </tr>
											  <tr>
												<td width="15%"><? echo substr($appt[$i+1][2], -4);?>　</td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i+1][5])); ?>　</td>
												<td width="15%"><? $q = "SELECT name FROM girlprofile WHERE userid='".$appt[$i+1][3]."'";
												 $re = mysqli_query($link, $q) ;
	                                             $name = mysqli_fetch_array($re); echo $name[0];?>　</td>
												<td width="20%"><? echo $appt[$i+1][4];?></td>
												 <td width="15%"><input type="text" name="pay" size="11"></td>
												<td width="10%"><button name="appt_submit" type="submit" value="<? echo $appt[$i+1][1]; ?>">确认</button></td>
											  </tr>
											</table>
									</form></p>
										</div>
									</div>
										   </section><? } ?> </div> <?
								 $i++;
									}}  else if ($subcode == 603) {
										$appt = Appt_List($userid, $link, -1);
						               for ($i=0; $i<count($appt); $i++) { ?>
										   <div class="row"> <?  if (!empty($appt[$i][4])) { ?>
										   <section class="6u 12u(narrower)">
											<div class="box post">
											<div class="inner">
											<h3><? echo $appt[$i][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="15%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">技师</font></td>
												<td width="30%" ><font size="2">客人评级</font></td>
											  </tr>
											  <tr>
												<td width="15%"><? echo substr($appt[$i][2], -4);?>　</td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i][5])); ?>　</td>
												<td width="15%"><? $q = "SELECT name FROM girlprofile WHERE userid='".$appt[$i][3]."'";
												 $re = mysqli_query($link, $q) ;
	                                             $name = mysqli_fetch_array($re); echo $name[0];?>　</td>
												 <td width="15%"><select size="1" name="grade">
												<option selected value="2">一般</option>
												<option value="1">良好</option>
												<option value="3">不好</option>
												<option value="4">很坏</option>
												</select></td>
												<td width="10%"><button name="comment_submit" type="submit" value="<? echo $appt[$i][2]; ?>">确认</button></td>
											  </tr>
											</table>
											</form>

											</p>
										</div>
									</div>
										   </section> <? }   if (!empty($appt[$i+1][4])) { ?>
								<section class="6u 12u(narrower)">
									<div class="box post">
										<div class="inner">
											<h3><? echo $appt[$i+1][0];?></h3>
											<p><form method="POST" action="index.php">
											<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
											  <tr>
												<td width="15%" ><font size="2">电话尾号</font></td>
												<td width="15%"><font size="2">预约时间 </font></td>
												<td width="15%"><font size="2">技师</font></td>
												<td width="30%" ><font size="2">客人评级</font></td>
											  </tr>
											  <tr>
												<td width="15%"><? echo substr($appt[$i+1][2], -4);?>　</td>
												<td width="15%"><? echo date('m-d H:i', strtotime($appt[$i+1][5])); ?>　</td>
												<td width="15%"><? $q = "SELECT name FROM girlprofile WHERE userid='".$appt[$i+1][3]."'";
												 $re = mysqli_query($link, $q) ;
	                                             $name = mysqli_fetch_array($re); echo $name[0];?>　</td>
												 <td width="15%"><select size="1" name="grade">
												<option selected value="2">一般</option>
												<option value="1">良好</option>
												<option value="3">不好</option>
												<option value="4">很坏</option>
												</select></td>
												<td width="10%"><button name="comment_submit" type="submit" value="<? echo $appt[$i+1][2]; ?>">确认</button></td>
											  </tr>
											</table>
									</form></p>
										</div>
									</div>
										   </section><? } ?> </div> <?
								 $i++;
									}} else if ($menucode == 700) { 
									$q = "SELECT id, name FROM store WHERE managerid='".$userid."'";
									$re = mysqli_query($link, $q) ;
									$num = mysqli_num_rows($re);
									if ($num == 0){
										$q = "SELECT name, storeid FROM girlprofile WHERE userid='".$userid."'";
										$re = mysqli_query($link, $q) ;
										$info = mysqli_fetch_array($re);
										$q = "SELECT name FROM store WHERE id='".$info[1]."'";
										$re = mysqli_query($link, $q) ;
										$info1 = mysqli_fetch_array($re);
										$girlinfo = array($info[0], $info1[0], $info[1]);
									} else {
				                       while ( $rw = mysqli_fetch_row($re) ){	
									     $q = "SELECT name, userid FROM girlprofile WHERE storeid='".$rw[0]."'";
										 $res = mysqli_query($link, $q) ;
				                         while ( $rw1 = mysqli_fetch_row($res) ){
											 $girlinfo[] = array($rw1[0], $rw1[1], $rw[1], $rw[0]);
										 }											 
									  }
									}
									?>
									
									<div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>Incall</h3>
										<p> <? if ($num == 0) {?><form method="POST" action="index.php">
									<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
									  <tr>
										<td width="50%"><font size="2">店名</font></td>
										<td width="50%"><? echo $girlinfo[1];?>　</td>
									  </tr>
									  <tr>
										<td width="50%"><font size="2">技师名</font></td>
										<td width="50%"><? echo $girlinfo[0];?>　</td>
									  </tr>
									  <tr>
										<td width="50%"><font size="2">收款金额</font></td>
										<td width="50%"><input type="text" name="pay" size="20"></td>
									  </tr>
									  <tr>
										<td width="50%">　</td>
										<td width="50%"><button name="add_appt_submit" type="submit" value="<? echo $userid; ?>">提交</button></td>
									  </tr>
										</table></form> <? } else {?>
										<form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="50%"><font size="2">店名<span lang="en-us">*</span>技师名</font></td>
											<td width="50%"><select size="1" name="girlid">
											<? for ($i=0; $i<count($girlinfo); $i++) { echo "<option value='".$girlinfo[$i][1]."'>".$girlinfo[$i][2]."--".$girlinfo[$i][0]."</option>"; }?></select></td>
										  </tr>
										  <tr>
											<td width="50%"><font size="2">收款金额</font></td>
											<td width="50%"><input type="text" name="pay" size="20"></td>
										  </tr>
										  <tr>
											<td width="50%">　</td>
											<td width="50%"><button name="manager_submit" type="submit" value="1">提交</button></td>
										  </tr>
										</table></form> <? } ?>

									</p>
									</div>
								</div>
							</section>
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>Outcall或特定预约</h3>
										<p> <? if ($num == 0) {?><form method="POST" action="index.php">
									<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
									  <tr>
										<td width="50%"><font size="2">店名</font></td>
										<td width="50%"><? echo $girlinfo[1];?>　</td>
									  </tr>
									  <tr>
										<td width="50%"><font size="2">技师名</font></td>
										<td width="50%"><? echo $girlinfo[0];?>　</td>
									  </tr>
									  <tr>
										<td width="50%"><font size="2">地址或4位电话尾号</font></td>
										<td width="50%"><input type="text" name="addr" size="20"></td>
									  </tr>
									  <tr>
										<td width="50%"><font size="2">收款金额</font></td>
										<td width="50%"><input type="text" name="pay" size="20"></td>
									  </tr>
									  <tr>
										<td width="50%"><font size="2">钟费</font></td>
										<td width="50%"><input type="text" name="mpay" size="20"></td>
									  </tr>
									  <tr>
										<td width="50%">　</td>
										<td width="50%"><button name="outcall_submit" type="submit">提交</button></td>
									  </tr>
										</table></form> <? } else {?>
										<form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="50%"><font size="2">店名<span lang="en-us">*</span>技师名</font></td>
											<td width="50%"><select size="1" name="girlid">
											<? for ($i=0; $i<count($girlinfo); $i++) { echo "<option value='".$girlinfo[$i][1]."'>".$girlinfo[$i][2]."--".$girlinfo[$i][0]."</option>"; }?></select></td>
										  </tr>
										  <tr>
										<td width="50%"><font size="2">地址或4位电话尾号</font></td>
										<td width="50%"><input type="text" name="addr" size="20"></td>
									  </tr>
										  <tr>
											<td width="50%"><font size="2">收款金额</font></td>
											<td width="50%"><input type="text" name="pay" size="20"></td>
										  </tr>
										  <tr>
										<td width="50%"><font size="2">钟费</font></td>
										<td width="50%"><input type="text" name="mpay" size="20"></td>
									  </tr>
										  <tr>
											<td width="50%">　</td>
											<td width="50%"><button name="outcall_submit" type="submit" value="1">提交</button></td>
										  </tr>
										</table></form> <? } ?>

									</p>
									</div>
								</div>
							</section>
									</div> <? } else if ($subcode == 801) { ?>	
                                    <div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>增加店经理</h3>
										<p><form method="POST" action="index.php">
										<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="30%">名字</td>
											<td width="70%"><input type="text" name="name" size="20"></td>
										  </tr>
										  <tr>
											<td width="30%">手机号</td>
											<td width="70%"><input type="text" name="cell" size="20"></td>
										  </tr>
										  <tr>
											<td width="30%">微信号</td>
											<td width="70%"><input type="text" name="wechat" size="20"></td>
										  </tr>
										  <tr>
											<td width="30%">　</td>
											<td width="70%"><button name="new_manager_submit" type="submit" value="1">提交</button></td>
										  </tr>
										</table></form>
										</p>
									</div>
								</div>
							</section>
									</div> <? } else if ($subcode == 802) { 
									$q = "SELECT id, name, cell FROM users WHERE id != '1'";
									$res = mysqli_query($link, $q) ;
									?>	
                                     <div class="row">
							<section class="6u 12u(narrower)">
								<div class="box post">
									<div class="inner">
										<h3>其他身份登录</h3>
										<p><form method="POST" action="index.php">
										 <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
										  <tr>
											<td width="30%">选择</td>
											<td width="70%"><select size="1" name="userid"><? while ( $rw = mysqli_fetch_row($res) ){ 
											 echo "<option value='".$rw[0]."'>".$rw[1]."--".$rw[2]."</option>"; }?> </select></td>
										  </tr>
										  <tr>
											<td width="30%">&nbsp;</td>
											<td width="70%"><button name="change_login_submit" type="submit">登录</button></td>
										  </tr>
										</table></form>
										</p>
									</div>
								</div>
							</section>
									</div> <? } ?>									
					</div>
				</section>
      
			<!-- CTA -->
				<section id="cta" class="wrapper style3">
					<div class="container">
                    <p> <? if (!empty($msg)) echo "<script type='text/javascript'>alert('$msg');</script>"; ?></p>
					</div>
				</section>

		 </div> <? }?>
		<!-- Scripts -->
			<script src="assets/js/jquery.min.js"></script>
			<script src="assets/js/jquery.dropotron.min.js"></script>
			<script src="assets/js/skel.min.js"></script>
			<script src="assets/js/util.js"></script>
			<!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script>
        <![endif]-->
			<script src="assets/js/main.js"></script>

	</body>
</html>