实现是实现了。但是点击订单链接有问题 修改了 e/ShopSys/ListDd 里边的index.php文件
<?php require("../../class/connect.php"); require("../../class/db_sql.php"); require("../../class/q_functions.php"); require("../../class/user.php"); require "../".LoadLang("pub/fun.php"); eCheckCloseMods('shop');//关闭模块 $link=db_connect(); $empire=new mysqlquery(); $editor=1; //是否登陆 $user=islogin(); $page=(int)$_GET['page']; $start=0; $line=16;//每页显示条数 $page_line=18;//每页显示链接数 $offset=$page*$line;//总偏移量 $add=""; $search=''; //加入代码实现会员管理订单 $csql=$empire->query("select * from wuliu_ecms_zhuying where userid='$user[userid]'"); while($cr=$empire->fetch($csql)) { $gzwl.="buycar LIKE '%|".$cr[classid].",".$cr[id]."|%' or ";
}
$totalquery="select count(*) as total from {$dbtbpre}enewsshopdd where $gzwl 'a'='a'"; $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 $gzwl 'a'='a'"; //结束 //搜索 $sear=$_GET['sear']; if($sear) { $keyboard=RepPostVar($_GET['keyboard']); $add=" and ddno like '%$keyboard%'"; //时间 $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"; } $totalquery.=$add; $num=$empire->gettotal($totalquery);//取得总条数 $query.=$add; $query=$query." order by ddid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page1($num,$line,$page_line,$start,$page,$search); //导入模板 require(ECMS_PATH.'e/template/ShopSys/ListDd.php'); db_close(); $empire=null; ?>
|