function getBalance($uid = 0, $mobile = "", $previousId = 0, $page = 1, $pageSize = 20)
{
$tblAccount = new DB_Pay_Account();
$tblPay = new DB_Pay();
$userModel = new UserModel();
$where = "where status=0";
if ($uid) {
$where .= " and sso_id = {$uid}";
}
if ($previousId) {
$where .= " and id<{$previousId}";
}
// if(!$mobile){
$balance = $tblAccount->fetchLimit("sso_id,user_name,score,amt,created_time", $where, "order by id desc", $page, $pageSize);
$balanceCount = $tblAccount->queryCount($where);
$newArray = [];
foreach ($balance as $k => $val) {
$balance[$k]['mobile'] = $userModel->getUserName($val['sso_id'])['mobile'];
/*print_r($balance[$k]['mobile']);
//如果不符合mobile条件
if($mobile && $balance[$k]['mobile']!=$mobile){
$balanceCount--;
print_r($balanceCount);
continue;
}*/
array_push($newArray, $balance[$k]);
}
$balance = array("balance" => $newArray, "balanceCount" => $balanceCount);
// }
/* else{
$balance = $tblAccount->fetchAll("sso_id,user_name,score,amt,created_time",$where,"order by id desc");
$result = [];
foreach($balance as $k=>$val){
$balance[$k]['mobile'] = $userModel->getUserName($val['sso_id'])['mobile'];
if(strstr($balance[$k]['mobile'],$mobile)!=""){
array_push($result,$balance[$k]);
}
}
$balanceCount = count($result);
//用数组的方式分页
$balance = array("balance"=>array_slice($result,($page-1)*20,$pageSize),"balanceCount"=>$balanceCount);
}*/
//没有查询到余额信息，返回-1
if (!$balance) {
return -1;
}
//如果有mobile查询条件，返回result
return $balance;
}
