window.location.href='./login.php';"); $sql=" uid=$uid"; if(isset($_GET['kw']) && !empty($_GET['kw'])) { $kw=daddslashes($_GET['kw']); if($_GET['type']==1){ $sql.=" AND `type`='{$kw}'"; }elseif($_GET['type']==2){ $sql.=" AND `money`='{$kw}'"; }elseif($_GET['type']==3){ $sql.=" AND `trade_no`='{$kw}'"; } $numrows=$DB->getColumn("SELECT count(*) from pre_record A WHERE{$sql}"); $con='包含 '.$_GET['value'].' 的共有 '.$numrows.' 条记录'; $link='&type='.$_GET['type'].'&kw='.$_GET['kw']; }else{ $numrows=$DB->getColumn("SELECT count(*) from pre_record A WHERE{$sql}"); $con='共有 '.$numrows.' 条记录'; } ?>
query("SELECT * FROM pre_record WHERE{$sql} order by id desc limit $offset,$pagesize"); while($res = $rs->fetch()) { echo ''; } ?>
操作类型变更金额变更前金额变更后金额时间关联订单号
'.($res['action']==2?''.$res['type'].'':''.$res['type'].'').''.($res['action']==2?'- ':'+ ').$res['money'].''.$res['oldmoney'].''.$res['newmoney'].''.$res['date'].''.($res['trade_no']?''.$res['trade_no'].'':'无').'
';