提现列表

query($sql2); if($result2->num_rows > 0){ while($row2 = $result2->fetch_assoc()) { $jingli = $jingli.",".$row2["xb_id"]; } } $sql = $sql." and xb_salesman in ($jingli)"; } if($_SESSION['xb_type']==4){ $sql = $sql." and xb_salesman=".$_SESSION["xb_id"].""; } if(!empty($_POST["xb_recharge"])){ $url=$url."&xb_recharge=".$_GET["xb_recharge"]; $sql = $sql." and xb_recharge='".$_GET["xb_recharge"]."' "; } if(!empty($_GET["xb_state"])){ $url=$url."&xb_state=".$_GET["xb_state"]; $sql = $sql." and xb_state=".$_GET["xb_state"]." "; } if(!empty($_GET["xb_username"])){ $url=$url."&xb_username=".$_GET["xb_username"]; $sql1 = "SELECT * FROM xb_user where xb_username='".$_GET["xb_username"]."'"; $rs1 = $conn->query($sql1); $row1 = $rs1->fetch_assoc(); if(!empty($row1["xb_id"])){ $sql = $sql." and xb_uid = ".$row1["xb_id"]." "; }else{ $sql = $sql." and xb_uid = 00000 "; } } if(!empty($_GET["xb_caozuoren"])){ $url=$url."&xb_caozuoren=".$_GET["xb_caozuoren"]; $xb_caozuoren=$_GET["xb_caozuoren"]; $sql = $sql." and xb_caozuoren = '".$xb_caozuoren."' "; } if(!empty($_GET["datemax"])){ $url=$url."&datemax=".$_GET["datemax"]; $datemax=$_GET["datemax"]; $sql = $sql." and DATE_FORMAT(xb_addtime, '%Y-%m-%d') <= '$datemax'"; } if(!empty($_POST["datemin"])){ $url=$url."&datemin=".$_GET["datemin"]; $datemin=$_GET["datemin"]; $sql = $sql." and DATE_FORMAT(xb_addtime, '%Y-%m-%d') >= '$datemin'"; } if(!empty($_GET["xb_number"])){ $xb_number=$_GET["xb_number"]; $url=$url."&xb_number=".$_GET["xb_number"]; $sql = $sql." and xb_number = '".$xb_number."' "; } $sql1=$sql." order by xb_id desc"; $sql=$sql." order by xb_id desc limit $start_from,$num_rec_per_page"; $result = $conn->query($sql1); $rs = $conn->query($sql); $total=$result->num_rows; $total_pages = ceil($total / $num_rec_per_page); ?> 提现列表

共有数据：num_rows;?> 条

num_rows > 0){ while($val = $rs->fetch_assoc()){ ?>

	ID	用户ID	用户	时间	金额	当前金额	业务员	代理	状态	提现类型	订单号	操作人	说明	操作
" name="xb_id">			query($sql1); $row2 = $rs1->fetch_assoc(); echo "".$row2["xb_username"].""; ?>				query($sql2); $row2 = $rs2->fetch_assoc(); echo "".$row2["xb_username"].""; }else{ echo " "; } ?>	query($sql2); $row2 = $rs2->fetch_assoc(); echo "".$row2["xb_username"].""; ?>	提现中";}elseif($val["xb_state"]==5){echo "提现失败";}elseif($val["xb_state"]==6){echo "提现成功";}elseif($val["xb_state"]==16){echo "处理中";}?>	bank				')" href="javascript:;" class='Jinxing'>设为失败 ')" href="javascript:;" class='Jinxing'>设为通过 ')" href="javascript:;" class='Jinxing'>手工转账 ')" href="javascript:;" class='Jinxing'>设为失败 ')" href="javascript:;" class='Jinxing'>设为成功
首页上一页 ">1 ">2 ">3 ">4 ">5 ">1 ">2 ">3 ">4 ">5 ... "> $total_pages){ ?> ">1... "> "> "> "> ">1... ... "> 下一页尾页共条记录，当前显示第页

query($sql2); $row2 = $rs2->fetch_assoc(); $xb_dongjie=$row2["xb_dongjie"]-$xb_price; if($_GET["act"]=="shibai"){ $sql = "UPDATE xb_record set xb_state = 5 where xb_id=".$xb_id; if ($conn->query($sql) === TRUE) { $conn->query("UPDATE xb_user set xb_currencybalance=xb_currencybalance+$xb_price,xb_dongjie=$xb_dongjie where xb_id=".$xb_uid.""); echo ""; die(); } else { echo "Error: " . $sql . "
" . $conn->error; } } } ?>