public function update_user_amount($db, $resultmoney, $uid) { //$sql="select sum(amount) sumamount from income where userid = ".$uid." and left(addtime,10) = date(now()) and states=1"; $sql = "select sum(amount) sumamount from income where userid = " . $uid . " and states=1"; $query_amount = $db->query($sql); $result = $db->fetch_array($query_amount); $sumamount = $result["sumamount"]; if ($sumamount == "") { $sumamount = 0; } $users = new users(); $usersinfo = $users->get_user_byid($uid); $bizset = new bizset(); $bizsetinfo = $bizset->get_bizset_bykey("TOP" . $usersinfo["productcount"]); $topmoney = $bizsetinfo["bizvalue"]; if ($sumamount + $resultmoney > $topmoney) { $resultmoney = $topmoney - $sumamount; } if ($resultmoney > 0) { $sql = "update users set amount = amount + " . $resultmoney . " where id = " . $uid . ""; $db->query($sql); //个人收入扣税 $settlement = new settlement(); $settlement->do_deduction($uid, $resultmoney, 'TAX', '个人收入扣税', ''); return $resultmoney; } else { return 0; } }
$totalPage = ceil($totalNumber / $perNumber); //计算出总页数 if (!isset($page)) { $page = 1; } //如果没有值,则赋值1 if (empty($page)) { $page = 1; } $startCount = ($page - 1) * $perNumber; //分页开始,根据此方法计算出开始的记录 $result = $db->query("select * from shengji where jieuserid='" . $_SESSION["uuserid"] . "' {$sqladd} limit {$startCount},{$perNumber}"); //根据前面的计算出开始的记录和记录数 while ($row = $db->fetch_array($result)) { $users = new users(); $rowu = $users->get_user_byid($db, $row['userid']); if (!empty($rowu)) { ?> <tr class="bg-white"> <td><?php echo $rowu['nickname']; ?> <br><span class="text-yellow"><?php echo $rowu['wechat']; ?> </span><br><span class="text-blue"><?php echo $rowu['loginname']; ?> </span></td> <td><?php