<?php
require '../conn/conn.php';
require '../conn/function.php';
require 'admin_check.php';

$page=$_GET["page"];
$action=$_GET["action"];


$type=intval($_REQUEST["type"]);
$keyword=t($_REQUEST["keyword"]);
$start=t($_REQUEST["start"]);
$end=t($_REQUEST["end"]);

$O_id=intval($_GET["O_id"]);
$M_id=intval($_GET["M_id"]);
$state=intval($_GET["state"]);

if($state==0){
	$state_info="";
}else{
	if($state==2){
		$state_info=" and O_state=0";
	}else{
		$state_info=" and O_state>0";
	}
}

if($M_id>0){
	$M_info=" and O_mid=$M_id";
}else{
	$M_info="";
}

if($page==""){
	$page=1;
}

function input_csv($handle) { 
 $out = array (); 
 $n = 0; 
 while ($data = fgetcsv($handle, 10000)) 
 { 
  $num = count($data); 
  for ($i = 0; $i < $num; $i++) 
  { 
   $out[$n][$i] = str_replace("\t","",$data[$i]); 
  } 
  $n++; 
 } 
 return $out; 
} 

if ($action == 'excelin') {
	$excel = $_POST["excel"];
    if ($excel=="") {
        die('请选择要导入的CSV文件！');
    }

    $handle = fopen("../media/".$excel, 'r');
    $result = input_csv($handle);
    $len_result = count($result);
    if ($len_result == 0) {
        die('没有任何数据！');
    }
    for ($i = 1; $i < $len_result; $i++)
    {
        $O_content = iconv('gb2312', 'utf-8', $result[$i][9]);
        $O_title = iconv('gb2312', 'utf-8', $result[$i][10]);
        $O_address = iconv('gb2312', 'utf-8', $result[$i][12]);
        $O_gg = iconv('gb2312', 'utf-8', $result[$i][18]);
        if($result[$i][22]==""){
        	$O_wlinfotime="NULL";
        }else{
        	$O_wlinfotime="'".$result[$i][22].".";
        }
        if($result[$i][23]==""){
        	$O_time2="NULL";
        }else{
        	$O_time2="'".$result[$i][23].".";
        }
        if($result[$i][24]==""){
        	$O_today="NULL";
        }else{
        	$O_today="'".$result[$i][24].".";
        }
        $O_city = iconv('gb2312', 'utf-8', $result[$i][28]);
        $O_bz = iconv('gb2312', 'utf-8', $result[$i][29]);
        $O_client = iconv('gb2312', 'utf-8', $result[$i][30]);

        if(getrs("select * from sl_orders where O_id=".intval($result[$i][0]))==""){
        	mysqli_query($conn,"insert into sl_orders(O_id,O_mid,O_pid,O_num,O_price,O_time,O_del,O_type,O_nid,O_content,O_title,O_pic,O_address,O_state,O_genkey,O_sellmid,O_wl,O_wlno,O_gg,O_paytype,O_wlinfo,O_cid,O_wlinfotime,O_time2,O_today,O_quan,O_postage,O_qid,O_city,O_bz,O_client,O_ip) values(".$result[$i][0].",".$result[$i][1].",".$result[$i][2].",".$result[$i][3].",".$result[$i][4].",'".$result[$i][5]."',".$result[$i][6].",".$result[$i][7].",".$result[$i][8].",'".$O_content."','".$O_title."','".$result[$i][11]."','".$O_address."',".$result[$i][13].",'".$result[$i][14]."',".$result[$i][15].",'".$result[$i][16]."','".$result[$i][17]."','".$O_gg."','".$result[$i][19]."','".$result[$i][20]."',".$result[$i][21].",".$O_wlinfotime.",".$O_time2.",".$O_today.",".$result[$i][25].",".$result[$i][26].",".$result[$i][27].",'".$O_city."','".$O_bz."','".$O_client."','".$result[$i][31]."')");
        }else{
        	mysqli_query($conn,"update sl_orders set 
        		O_mid=".$result[$i][1].",
        		O_pid=".$result[$i][2].",
        		O_num=".$result[$i][3].",
        		O_price=".$result[$i][4].",
        		O_time='".$result[$i][5]."',
        		O_del=".$result[$i][6].",
        		O_type=".$result[$i][7].",
        		O_nid=".$result[$i][8].",
        		O_content='".$O_content."',
        		O_title='".$O_title."',
        		O_pic='".$result[$i][11]."',
        		O_address='".$O_address."',
        		O_state=".$result[$i][13].",
        		O_genkey='".$result[$i][14]."',
        		O_sellmid=".$result[$i][15].",
        		O_wl='".$result[$i][16]."',
        		O_wlno='".$result[$i][17]."',
        		O_gg='".$O_gg."',
        		O_paytype='".$result[$i][19]."',
        		O_wlinfo='".$result[$i][20]."',
        		O_cid=".$result[$i][21].",
        		O_wlinfotime=".$O_wlinfotime.",
        		O_time2=".$O_time2.",
        		O_today=".$O_today.",
        		O_quan=".$result[$i][25].",
        		O_postage=".$result[$i][26].",
        		O_qid=".$result[$i][27].",
        		O_city='".$O_city."',
        		O_bz='".$O_bz."',
        		O_client='".$O_client."',
        		O_ip='".$result[$i][31]."'
        		where O_id=".intval($result[$i][0]));
        }
    }

    fclose($handle);
    die('success');
}

if($action=="del2"){
	mysqli_query($conn,"update sl_orders set O_del=1 where date(O_time) between '".$start."' and '".$end."'");
	die("success");
}

if($action=="save"){
	foreach ($_POST as $x=>$value) {
		if(splitx($x,"_",0)=="bz"){
			mysqli_query($conn,"update sl_orders set O_bz='".$_POST[$x]."' where O_id=".intval(splitx($x,"_",1)));
		}
		if(splitx($x,"_",0)=="state"){
			mysqli_query($conn,"update sl_orders set O_state=".$_POST[$x]." where O_id=".intval(splitx($x,"_",1)));
		}
		if(splitx($x,"_",0)=="time"){
			mysqli_query($conn,"update sl_orders set O_time='".$_POST[$x]."' where O_id=".intval(splitx($x,"_",1)));
		}
	}
	die("success");
}

if($action=="state"){
	$O_id=intval($_GET["O_id"]);
	$state=intval($_GET["state"]);
	mysqli_query($conn,"update sl_orders set O_state=$state where O_id=$O_id");
	die("success");
}

if($action=="excel"){
	if($_GET["id"]==NULL){
		$sql="select M_login,O_time,O_title,O_gg,O_num,O_price,(O_price * O_num) as O_all,O_bz from sl_orders,sl_member where M_id=O_mid";
	}else{
		for($i=0;$i<count($_GET["id"]);$i++){
			$o=$o."O_id=".$_GET["id"][$i]." or ";
		}
		$o=substr($o,0,strlen($o)-4);

		$sql="select M_login,O_time,O_title,O_gg,O_num,O_price,(O_price * O_num) as O_all,O_bz from sl_orders,sl_member where M_id=O_mid and (".$o.")";
	}
	$result = mysqli_query($conn, $sql);
	$arr = array();
	while($row = mysqli_fetch_array($result)) {
	$count=count($row);
	  for($i=0;$i<$count;$i++){ 
	    unset($row[$i]);
	  }
    array_push($arr,$row);
	} 

	exportToCsv(["会员名称","下单日期","商品名称","商品规格","商品数量","商品单价","商品合计","商品备注"] , $arr ,'order_'.date('YmdHis'),[]);
	die();
}

function utfToGbk($data){
    return iconv('utf-8', 'GBK', $data);
}
if($action=="delx"){
	mysqli_query($conn,"update sl_orders set O_del=1 where O_state=0");
	die("success");
}

if($action=="delall"){
	$id=$_POST["id"];
	if(count($id)>0) {
		$shu=0 ;
		for ($i=0 ;$i<count($id);$i++ ) {
			mysqli_query($conn,"update sl_orders set O_del=1 where O_id=".intval($id[$i]));
			$shu=$shu+1 ;
			$ids=$ids.$id[$i].",";
		}
		$ids= substr($ids,0,strlen($ids)-1);
		if($shu>0) {
			mysqli_query($conn, "insert into sl_log(L_aid,L_time,L_add,L_ip,L_title) values(".$_SESSION["A_id"].",'".date('Y-m-d H:i:s')."','".$_SESSION["add"]."','".getip()."','批量删除订单')");
			die("success");
		} else {
			die("删除失败");
		}

	} else {
		die("未选择要删除的内容");
	}
}
switch($action){
	case "search":
	if($type==0){
		$sql="select count(O_id) as O_count from sl_orders,sl_member where O_mid=M_id ".$state_info." and O_del=0 and O_title like '%".$keyword."%' and (not O_bz='虚拟' or ISNULL(O_bz)=1) ".$M_info;
	}
	if($type==1){
		$sql="select count(O_id) as O_count from sl_orders,sl_member where O_mid=M_id ".$state_info." and O_del=0 and M_login like '%".$keyword."%' and (not O_bz='虚拟' or ISNULL(O_bz)=1) ".$M_info;
	}
	if($type==2){
		$sql="select count(O_id) as O_count from sl_orders,sl_product,sl_psort where O_pid=P_id and P_sort=S_id  ".$state_info." and O_del=0 and S_title like '%".$keyword."%' and (not O_bz='虚拟' or ISNULL(O_bz)=1) ".$M_info;
	}
	break;
	case "search2":
	$sql="select count(O_id) as O_count from sl_orders,sl_member where O_mid=M_id ".$state_info." and O_del=0 and date(O_time) between '".$start."' and '".$end."' and (not O_bz='虚拟' or ISNULL(O_bz)=1) ".$M_info;
	break;
	default:
	$sql="select count(O_id) as O_count from sl_orders,sl_member where O_mid=M_id ".$state_info." and O_del=0 and (not O_bz='虚拟' or ISNULL(O_bz)=1) ".$M_info;
	break;
}

$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$O_count=$row["O_count"];
?>

<!DOCTYPE html>
<html lang="en">
	<head>

		<meta charset="UTF-8">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<title>订单管理 - 后台管理</title>

		<!--favicon -->
		<link rel="icon" href="../media/<?php echo $C_ico?>" type="image/x-icon"/>

		<!--Bootstrap.min css-->
		<link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.min.css">

		<!--Icons css-->
		<link rel="stylesheet" href="assets/css/icons.css">

		<!--Style css-->
		<link rel="stylesheet" href="assets/css/style.css">

		<!--mCustomScrollbar css-->
		<link rel="stylesheet" href="assets/plugins/scroll-bar/jquery.mCustomScrollbar.css">

		<!--Sidemenu css-->
		<link rel="stylesheet" href="assets/plugins/toggle-menu/sidemenu.css">

		<!--Toastr css-->
		<link rel="stylesheet" href="assets/plugins/toastr/build/toastr.css">

		<script type="text/javascript" src="../upload/upload.js"></script>
	</head>

	<body class="app ">

		<div id="spinner"></div>

		<div id="app">
			<div class="main-wrapper" >
				
					<?php
					require 'nav.php';
					?>
				<div class="app-content">
					<a href="recycle.php" class="btn btn-sm btn-primary pull-right" style="z-index: 2;position: relative;"><i class="fa fa-recycle"></i> 回收站</a>

					<form class="input-group pull-right" style="width: 300px;z-index: 2;position: relative;margin-right: 5px;" method="post" action="?action=search">
						<select class=" input-sm" name="type">
							<option value="0" <?php if($type==0){echo "selected='selected'";}?>>按关键词</option>
							<option value="1" <?php if($type==1){echo "selected='selected'";}?>>按会员</option>
							<option value="2" <?php if($type==2){echo "selected='selected'";}?>>按商品分类</option>
						</select>
	                    <input type="text" class="form-control input-sm" name="keyword" value="<?php echo $keyword?>" placeholder="搜索订单">
	                    <span class="input-group-btn">
	                        <button class="btn btn-info btn-sm" type="submit"><i class="fa fa-search"></i> 搜索</button>
	                    </span>
	                </form>

	                <form id="form2" class="input-group pull-right" style="width: 410px;z-index: 2;position: relative;margin-right: 5px;" method="post" action="?action=search2">
	                    <input type="date" class="form-control input-sm" name="start" value="<?php echo $start?>" placeholder="起始"> 
	                    <div style="padding: 5px;">-</div>
	                    <input type="date" class="form-control input-sm" name="end" value="<?php echo $end?>" placeholder="截止">
	                    <span class="input-group-btn">
	                        <button class="btn btn-info btn-sm" type="submit"><i class="fa fa-search"></i> 筛选</button>
	                    </span>
	                    <span class="input-group-btn">
	                        <button type="button" class="btn btn-danger btn-sm" onclick="orders_list_del2()"><i class="fa fa-times-circle"></i> 删除</button>
	                    </span>
	                </form>

					<section class="section">
                    	<ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.php">后台管理</a></li>
                            <li class="breadcrumb-item active" aria-current="page">订单管理</li>
                        </ol>

						<div class="section-body ">

							<div class="row">
								<div class="col-lg-12">
									<form id="form">
									<div class="card card-primary">

										<div class="card-header">
											<h4><?php
											if($M_id>0){
												echo "用户：<b>".getrs("select M_login from sl_member where M_id=".$M_id,"M_login")."</b> 的";
											}
											if($action=="search2"){
												echo "<b>".$start." 至 ".$end."</b> 的";
											}
											if($action=="search"){
												echo "<b>搜索“".$keyword."”</b> 的";
											}
											?>订单记录
											<div style="float: right;">
												<a class="btn btn-primary" href="orders_list.php">全部</a> 
												<a class="btn btn-info" href="?state=1">已付</a> 
												<a class="btn btn-danger" href="?state=2">未付</a>												
											</div>
										</h4>

										</div>
										<div class="card-body p-0">
											<div class="table-responsive">
												<table class="table table-striped mb-0">
													<tr>
														<th width="5%">选择</th>
														<th width="25%">订单名称/金额/时间</th>
														<th width="5%">图片</th>
														<th width="25%">会员/邮箱</th>
														<th width="20%">支付方式/交易号</th>
														<th width="20%">发货内容</th>
													</tr>
	<?php
		switch($action){
			case "fh":
			$sql="select * from sl_orders,sl_member where O_mid=M_id and O_del=0 ".$M_info." and (not O_bz='虚拟' or ISNULL(O_bz)=1) and O_state=2 and O_type=0 and O_content='实物商品，由商家手动发货' order by O_id desc";
			break;
			case "search":

				if($type==0){
					$sql="select * from sl_orders,sl_member  where  not O_genkey='' and O_mid=M_id ".$state_info." and O_del=0 and (not O_bz='虚拟' or ISNULL(O_bz)=1) and O_title like '%".$keyword."%' ".$M_info." order by O_id desc limit ".(($page-1)*20).",20";
				}
				if($type==1){
					$sql="select * from sl_orders,sl_member  where  not O_genkey='' and O_mid=M_id ".$state_info." and O_del=0 and (not O_bz='虚拟' or ISNULL(O_bz)=1) and M_login like '%".$keyword."%' ".$M_info." order by O_id desc limit ".(($page-1)*20).",20";
				}
				if($type==2){
					$sql="select * from sl_orders,sl_product,sl_psort  where O_pid=P_id and P_sort=S_id and not O_genkey='' ".$state_info." and O_del=0 and (not O_bz='虚拟' or ISNULL(O_bz)=1) and S_title like '%".$keyword."%' ".$M_info." order by O_id desc limit ".(($page-1)*20).",20";
				}

			break;
			case "search2":
			$sql="select * from sl_orders,sl_member where O_mid=M_id ".$state_info." and O_del=0 and (not O_bz='虚拟' or ISNULL(O_bz)=1) and date(O_time) between '".$start."' and '".$end."' ".$M_info." order by O_id desc limit ".(($page-1)*20).",20";
			break;
			default:
			$sql="select * from sl_orders,sl_member where O_mid=M_id  ".$state_info."  and (not O_bz='虚拟' or ISNULL(O_bz)=1) and O_del=0 ".$M_info." order by O_id desc limit ".(($page-1)*20).",20";
			break;
		}

		$result = mysqli_query($conn, $sql);
		if (mysqli_num_rows($result) > 0) {
		while($row = mysqli_fetch_assoc($result)) {

			if($row["M_viplong"]-(time()-strtotime($row["M_viptime"]))/86400>0){
				$M_vip=" <img src=\"img/vip.png\" height=\"20\">";
			}else{
				$M_vip="";
			}

			if($row["O_state"]==0){
				$state0="selected='selected'";
			}else{
				$state0="";
			}
			if($row["O_state"]==1){
				$state1="selected='selected'";
			}else{
				$state1="";
			}
			if($row["O_state"]==2){
				$state2="selected='selected'";
			}else{
				$state2="";
			}
			if($row["O_state"]==3){
				$state3="selected='selected'";
			}else{
				$state3="";
			}

			$f="<select class=\"form-control\" style=\"width:120px;display:inline-block\" name=\"state_".$row["O_id"]."\" onchange=\"orders_list_save()\">
            <option value=\"0\" ".$state0.">未付款</option>
            <option value=\"2\" ".$state2.">未发货</option>
            <option value=\"1\" ".$state1.">已发货</option>
            <option value=\"3\" ".$state3.">已退款</option>
            </select>";

			if($row["O_state"]==0){
				$th="<span style=\"color:#ff9900\">等待买家付款</span>";
			}
			if($row["O_state"]==3){
				$th="<span style=\"color:#ff9900\">已退款</span>";
			}
			if($row["O_state"]==1){
				if($row["O_type"]==0){
					$th="<a href=\"../member/unlogin.php?type=fahuo&genkey=".$row["O_genkey"]."\" class=\"btn btn-sm btn-primary\" target=\"_blank\">查看发货内容</a>";
				}
				if($row["O_type"]==1){
					$th="<a href=\"../?type=newsinfo&id=".$row["O_nid"]."&genkey=".$row["O_genkey"]."\" class=\"btn btn-sm btn-primary\" target=\"_blank\">查看发货内容</a>";
				}
				if($row["O_type"]==2){
					$th="<a href=\"../?type=courseinfo&id=".$row["O_cid"]."&genkey=".$row["O_genkey"]."\" class=\"btn btn-sm btn-primary\" target=\"_blank\">查看发货内容</a>";
				}
			}
			if($row["O_state"]==2){
				if($row["O_sellmid"]==0){
					$f=$f." <a href=\"send.php?O_id=".$row["O_id"]."\" target=\"_blank\" class=\"btn btn-sm btn-primary\">发货</a>";
				}else{
					//$f="等待商家发货";
				}
				$th="<span style=\"color:#ff9900\">等待商家发货</span>";
			}
			$th="<p><input type=\"text\" value=\"".$row["O_bz"]."\" class=\"form-control\" name=\"bz_".$row["O_id"]."\" placeholder=\"备注\" onblur=\"orders_list_save()\"></p><p>".$th."</p>";

			if($row["O_wl"]!=""){
				if($config->wuliu=="true"){
					$wuliu="<a href=\"send.php?O_id=".$row["O_id"]."\" target=\"_blank\" class=\"btn btn-sm btn-info\">查询物流</a>";
				}
				$wl="<p>快递公司：".$row["O_wl"]." $wuliu <br>快递单号：".$row["O_wlno"]."</p>";
			}else{
				$wl="";
			}

			$L_no2=getrs("select * from sl_list where L_genkey='".$row["O_genkey"]."'","L_no2");
			if($L_no2==""){
				$L_no=getrs("select * from sl_list where L_genkey='".$row["O_genkey"]."'","L_no");
			}else{
				$L_no=$L_no2;
			}
			if($row["O_time2"]!=""){
				if($row["O_time2"]>date('Y-m-d H:i:s')){
					$dq=" <span style=\"color:#009900\">[".round((strtotime($row["O_time2"])-time())/3600/24)."天后到期]</span>";
				}else{
					$dq=" <span style=\"color:#ff0000\">[".date("Y-m-d",strtotime($row["O_time2"]))."已到期]</span>";
				}
				
			}else{
				$dq="";
			}
			if($row["O_quan"]>0){
				$quan=" - ".$row["O_quan"]."(优惠券)";
			}else{
				$quan="";
			}
			if($row["O_postage"]>0){
				$postage=" + ".$row["O_postage"]."(邮费)";
			}else{
				$postage="";
			}

			if($row["O_type"]==0){

				$P=getrs("select * from sl_product where P_id=".$row["O_pid"]);
				if($P==""){
					$P_msg="";
				}else{
					$P_msg=$P["P_msg"];
				}

				if($P_msg!=""){
					$msg=explode("|",$P_msg);
					$add=explode("__",$row["O_address"]);
					for($i=0;$i<count($msg);$i++){
						$O_address=$O_address.splitx($msg[$i],"_",0)."：".$add[$i]."<br>";
					}
				}else{
					$O_address=str_replace("__"," ",$row["O_address"]);
				}

				echo "<tr id='".$row["O_id"]."'><td><input type=\"checkbox\" name=\"id[]\" value=\"".$row["O_id"]."\"></td><td><a href=\"../?type=productinfo&id=".$row["O_pid"]."\" target=\"_blank\"><div style=\"width:100%;max-width:400px;display:block;white-space:normal;\"><p>[商品] ".$row["O_title"]." 【".str_replace("|"," ",$row["O_gg"])."】</p></div></a><p>".$row["O_price"]." × ".$row["O_num"].$quan.$postage." = <b>".($row["O_price"]*$row["O_num"]-$row["O_quan"]+$row["O_postage"])."元</b></p><p><input type=\"text\" value=\"".$row["O_time"]."\" class=\"form-control\" name=\"time_".$row["O_id"]."\" onblur=\"orders_list_save()\">".$dq."</p></td><td><img src=\"".pic2(splitx($row["O_pic"],"|",0))."\" height=\"50\" alt=\"<img src='".pic2(splitx($row["O_pic"],"|",0))."' width='500'>\"></td><td><p><a href=\"member.php?M_id=".$row["M_id"]."\"><i class=\"fa fa-user\"></i> ".$row["M_login"].$M_vip."</a> <a href=\"?M_id=".$row["M_id"]."\" class=\"btn btn-sm btn-info\">查询</a></p><p>".$O_address."</p><p>IP：".$row["O_ip"]."[".$row["O_city"]."]</p></td><td><p>".$row["O_client"]." ".$row["O_paytype"]."</p><p>".$L_no."</p></td><td><p><b>状态：".$f."</b></p>".$th.$wl."</td></tr>";
			}
			if($row["O_type"]==1){
				echo "<tr id='".$row["O_id"]."'><td><input type=\"checkbox\" name=\"id[]\" value=\"".$row["O_id"]."\"></td><td><a href=\"../?type=newsinfo&id=".$row["O_nid"]."\" target=\"_blank\"><div style=\"width:100%;max-width:400px;display:block;white-space:normal;\"><p>[文章] ".$row["O_title"]."</p></div></a><p>".$row["O_price"]." × ".$row["O_num"]." = <b>".($row["O_price"]*$row["O_num"])."元</b></p><p><input type=\"text\" value=\"".$row["O_time"]."\" class=\"form-control\" name=\"time_".$row["O_id"]."\" onblur=\"orders_list_save()\">".$dq."</p></td><td><img src=\"".pic2($row["O_pic"])."\" height=\"50\" alt=\"<img src='".pic2($row["O_pic"])."' width='500'>\"></td><td><p><a href=\"member.php?M_id=".$row["M_id"]."\"><i class=\"fa fa-user\"></i> ".$row["M_login"].$M_vip."</a> <a href=\"?M_id=".$row["M_id"]."\" class=\"btn btn-sm btn-info\">查询</a></p><p>".$row["O_address"]."</p><p>IP：".$row["O_ip"]."[".$row["O_city"]."]</p></td><td><p>".$row["O_client"]." ".$row["O_paytype"]."</p><p>".$L_no."</p></td><td><p><b>状态：".$f."</b></p>".$th.$wl."</td></tr>";
			}
			if($row["O_type"]==2){
				echo "<tr id='".$row["O_id"]."'><td><input type=\"checkbox\" name=\"id[]\" value=\"".$row["O_id"]."\"></td><td><a href=\"../?type=courseintro&id=".$row["O_cid"]."\" target=\"_blank\"><div style=\"width:100%;max-width:400px;display:block;white-space:normal;\"><p>[课程] ".$row["O_title"]."</p></div></a><p>".$row["O_price"]." × ".$row["O_num"]." = <b>".($row["O_price"]*$row["O_num"])."元</b></p><p><input type=\"text\" value=\"".$row["O_time"]."\" class=\"form-control\" name=\"time_".$row["O_id"]."\" onblur=\"orders_list_save()\">".$dq."</p></td><td><img src=\"".pic2($row["O_pic"])."\" height=\"50\" alt=\"<img src='".pic2($row["O_pic"])."' width='500'>\"></td><td><p><a href=\"member.php?M_id=".$row["M_id"]."\"><i class=\"fa fa-user\"></i> ".$row["M_login"].$M_vip."</a> <a href=\"?M_id=".$row["M_id"]."\" class=\"btn btn-sm btn-info\">查询</a></p><p>".$row["O_address"]."</p><p>IP：".$row["O_ip"]."[".$row["O_city"]."]</p></td><td><p>".$row["O_client"]." ".$row["O_paytype"]."</p><p>".$L_no."</p></td><td><p><b>状态：".$f."</b></p>".$th.$wl."</td></tr>";
			}
			$O_address="";
		}
	}
?>

												</table>
											</div>
										</div>
									</div>
									<label><input type="checkbox" id="selectAll" name="selectAll"> 全选</label>
									<button class="btn btn-sm btn-danger" type="button" onclick="orders_list_delall()"><i class="fa fa-times-circle" ></i> 删除所选</button>
									<button class="btn btn-sm btn-warning" type="button" onclick="orders_list_delx()"><i class="fa fa-times-circle" ></i> 清理未付款订单</button>
									<button class="btn btn-sm btn-primary" type="button" onclick="orders_list_excel()"><i class="fa fa-download" ></i> 导出EXCEL</button>
									<button class="btn btn-sm btn-info" type="button" onclick="orders_list_excelin()"><i class="fa fa-upload" ></i> 导入EXCEL</button>
									<input type="hidden" name="e" id="e">
									<ul class="pagination" id="pagination" style="float: right;"></ul>
								</form>
								</div>
								
							</div>
						</div>
					<?php if($action!="fh"){?>
					        <input type="hidden" id="PageCount" runat="server" />
					        <input type="hidden" id="PageSize" runat="server" value="20" />
					        <input type="hidden" id="countindex" runat="server" value="20"/>
					        <!--设置最多显示的页码数 可以手动设置 默认为7-->
					        <input type="hidden" id="visiblePages" runat="server" value="7" />
					<?php }?>
					</section>
				</div>

			</div>
		</div>

		<script src="assets/js/jquery.min.js"></script>
		<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
		<script src="assets/plugins/toggle-menu/sidemenu.js"></script>
		<script src="assets/plugins/scroll-bar/jquery.mCustomScrollbar.concat.min.js"></script>
		<script src="assets/js/scripts.js"></script>
		<script src="assets/js/help.js"></script>
		<script src="assets/plugins/toastr/build/toastr.min.js"></script>
		<script src="assets/js/jqPaginator.min.js" type="text/javascript"></script>
		<script src="ajax.js"></script>
		<script>

function loadData(num) {
            $("#PageCount").val("<?php echo $O_count?>");
        }
function loadpage(id) {
    var myPageCount = parseInt($("#PageCount").val());
    var myPageSize = parseInt($("#PageSize").val());
    var countindex = myPageCount % myPageSize > 0 ? (myPageCount / myPageSize) + 1 : (myPageCount / myPageSize);
    $("#countindex").val(countindex);

    $.jqPaginator('#pagination', {
        totalPages: parseInt($("#countindex").val()),
        visiblePages: parseInt($("#visiblePages").val()),
        currentPage: id,
        first: '<li class="first page-item"><a href="javascript:;" class="page-link">首页</a></li>',
        prev: '<li class="prev page-item"><a href="javascript:;" class="page-link"><i class="arrow arrow2"></i>上一页</a></li>',
        next: '<li class="next page-item"><a href="javascript:;" class="page-link">下一页<i class="arrow arrow3"></i></a></li>',
        last: '<li class="last page-item"><a href="javascript:;" class="page-link">末页</a></li>',
        page: '<li class="page page-item"><a href="javascript:;" class="page-link">{{page}}</a></li>',
        onPageChange: function (num, type) {
            if (type == "change") {
            	<?php
            	switch($action){
            		case "search":
            		$url="&action=search&type=".$type."&keyword=".$keyword;
            		break;
            		case "search2":
            		$url="&action=search2&start=".$start."&end=".$end;
            		break;
            		default:
            		$url="&M_id=".$M_id."&state=".$state;
            		break;
            	}
            	?>
                window.location="?page="+num+"<?php echo $url?>";
            }
        }
    });
}
$(function () {
    loadData(<?php echo $page?>);
    loadpage(<?php echo $page?>);

});


	$('input[name="selectAll"]').on("click",function(){
        if($(this).is(':checked')){
            $('input[name="id[]"]').each(function(){
                $(this).prop("checked",true);
            });
        }else{
            $('input[name="id[]"]').each(function(){
                $(this).prop("checked",false);
            });
        }
    });
			
		</script>
	</body>
</html>