<?php
require("../../class/connect.php");
include("../../class/config.php");
include("../../class/db_sql.php");
include("../../class/q_functions.php");
include("../../class/user.php");
include "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
//是否登陸
$user=islogin();
$page=(int)$_GET['page'];
$start=(int)$_GET['start'];
$line=16;//每頁顯示條數(shù)
$page_line=18;//每頁顯示鏈接數(shù)
$offset=$start+$page*$line;//總偏移量
$add="";
$query="select ddid,ddno,ddtime,userid,username,outproduct,haveprice,checked,truename,psid,psname,pstotal,alltotal,payfsid,payfsname,payby,alltotalfen,fp,fptotal from {$dbtbpre}enewsshopdd where userid='$user[userid]'";
//搜索
$sear=$_GET['sear'];
if($sear)
{
	$keyboard=RepPostVar($_GET['keyboard']);
	$add=" and ddno like '%$keyboard%'";
	//時(shí)間
	$starttime=RepPostVar($_GET['starttime']);
	$endtime=RepPostVar($_GET['endtime']);
	if($endtime!="")
	{
		$ostarttime=$starttime." 00:00:00";
		$oendtime=$endtime." 23:59:59";
		$add.=" and ddtime>='$ostarttime' and ddtime<='$oendtime'";
	}
	$search="&sear=1&keyboard=$keyboard&starttime=$starttime&endtime=$endtime";
}
$query.=$add;
$num=$empire->num($query);//取得總條數(shù)
$query=$query." order by ddid desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);
$url="<a href=../../../>首頁</a>&nbsp;>&nbsp;<a href=../../member/cp>控制面板</a>&nbsp;>&nbsp;訂單查詢";
@include("../../data/template/cp_1.php");
?>
<script src=../../data/images/setday.js></script>
<form name="form1" method="get" action="index.php">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
    <tr> 
      <td>訂單號(hào)為: 
        <input name="keyboard" type="text" id="keyboard" value="<?=$keyboard?>">
        時(shí)間從 
        <input name="starttime" type="text" id="starttime2" value="<?=$starttime?>" size="12" onclick="setday(this)">
        到 
        <input name="endtime" type="text" id="endtime2" value="<?=$endtime?>" size="12" onclick="setday(this)">
        止的訂單 
        <input type="submit" name="Submit6" value="搜索"> <input name="sear" type="hidden" id="sear2" value="1"> 
      </td>
    </tr>
  </table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class=tableborder>
    <tr class=header> 
      <td width="7%" height="23"> <div align="center">序號(hào)</div></td>
      <td width="21%"><div align="center">編號(hào)(點(diǎn)擊查看)</div></td>
      <td width="16%"><div align="center">訂購時(shí)間</div></td>
      <td width="13%"><div align="center">總金額</div></td>
      <td width="15%"><div align="center">付費(fèi)方式</div></td>
      <td width="28%"><div align="center">狀態(tài)</div></td>
    </tr>
    <?
	$j=0;
	while($r=$empire->fetch($sql))
	{
	$j++;
	//點(diǎn)數(shù)購買
	$total=0;
	if($r[payby]==1)
	{
	$total=$r[alltotalfen]+$r[pstotal];
	$mytotal="<a href=#ecms title='商品額(".$r[alltotalfen].")+運(yùn)費(fèi)(".$r[pstotal].")'>".$total." 點(diǎn)</a>";
	}
	else
	{
	//發(fā)票
	$fpa="";
	if($r[fp])
	{
	$fpa="+發(fā)票費(fèi)(".$r[fptotal].")";
	}
	$total=$r[alltotal]+$r[pstotal]+$r[fptotal];
	$mytotal="<a href=#ecms title='商品額(".$r[alltotal].")+運(yùn)費(fèi)(".$r[pstotal].")".$fpa."'>".$total." 元</a>";
	}
	//支付方式
	if($r[payby]==1)
	{
	$payfsname=$r[payfsname]."<br>(積分購買)";
	}
	elseif($r[payby]==2)
	{
	$payfsname=$r[payfsname]."<br>(余額購買)";
	}
	else
	{
	$payfsname=$r[payfsname];
	}
	//狀態(tài)
	if($r[checked])
	{
	$ch="已確認(rèn)";
	}
	else
	{
	$ch="<font color=red>未確認(rèn)</font>";
	}
	if($r[outproduct])
	{
	$ou="已發(fā)貨";
	}
	else
	{
	$ou="<font color=red>未發(fā)貨</font>";
	}
	if($r[haveprice])
	{
	$ha="已付款";
	}
	else
	{
	$ha="<font color=red>未付款</font>";
	}
	?>
    <tr bgcolor="#FFFFFF"> 
      <td height="25"> <div align="center">
          <?=$j?>
          </div></td>
      <td> <div align="center"><a href="#ecms" onclick="window.open('../ShowDd?ddid=<?=$r[ddid]?>','','width=600,height=500,scrollbars=yes');"> 
          <?=$r[ddno]?>
          </a></div></td>
      <td> <div align="center"> 
          <?=$r[ddtime]?>
        </div></td>
      <td> <div align="center"> 
          <?=$mytotal?>
        </div></td>
      <td><div align="center"> 
          <?=$payfsname?>
        </div></td>
      <td> <div align="center"><strong> 
          <?=$ha?>
          </strong>/<strong> 
          <?=$ou?>
          </strong>/<strong> 
          <?=$ch?>
          </strong></div></td>
    </tr>
    <?
	}
	?>
    <tr bgcolor="#FFFFFF"> 
      <td> <div align="center"></div></td>
      <td colspan="5"> <div align="left">&nbsp; 
          <?=$returnpage?>
        </div></td>
    </tr>
</table>
<?
@include("../../data/template/cp_2.php");
db_close();
$empire=null;
?>