query("delete from {$dbtbpre}enewspayrecord where".$add); if($sql) { //操作日志 insert_dolog(""); printerror("DelPayRecordSuccess","ListPayRecord.php".hReturnEcmsHashStrHref2(1)); } else { printerror("DbError","history.go(-1)"); } } $enews=$_POST['enews']; if(empty($enews)) {$enews=$_GET['enews'];} if($enews) { hCheckEcmsRHash(); } //批量删除 if($enews=="DelPayRecord_all") { $id=$_POST['id']; DelPayRecord_all($id,$logininid,$loginin); } $line=25;//每页显示条数 $page_line=18;//每页显示链接数 $page=(int)$_GET['page']; $page=RepPIntvar($page); $start=0; $offset=$page*$line;//总偏移量 $query="select id,userid,username,orderid,money,posttime,paybz,type,payip from {$dbtbpre}enewspayrecord"; $totalquery="select count(*) as total from {$dbtbpre}enewspayrecord"; //搜索 $search=''; $search.=$ecms_hashur['ehref']; $where=''; if($_GET['sear']==1) { $search.="&sear=1"; $a=''; $startday=RepPostVar($_GET['startday']); $endday=RepPostVar($_GET['endday']); if($startday&&$endday) { $search.="&startday=$startday&endday=$endday"; $a.="posttime<='".$endday." 23:59:59' and posttime>='".$startday." 00:00:00'"; } $keyboard=RepPostVar($_GET['keyboard']); if($keyboard) { $and=$a?' and ':''; $show=RepPostStr($_GET['show'],1); if($show==1) { $a.=$and."username like '%$keyboard%'"; } elseif($show==2) { $a.=$and."payip like '%$keyboard%'"; } elseif($show==3) { $a.=$and."paybz like '%$keyboard%'"; } else { $a.=$and."orderid like '%$keyboard%'"; } $search.="&keyboard=$keyboard&show=$show"; } if($a) { $where.=" where ".$a; } $query.=$where; $totalquery.=$where; } $num=$empire->gettotal($totalquery);//取得总条数 $query=$query." order by id desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); ?>
位置:在线支付> 管理支付记录 |