/** * @param $uid * @param $app _id * @param $start _time * @param $end _time * @param $start _page * @param paged Query $limit _page * MongoDB*/ Public Static functionGetuserrevenueinfolist ($uid,$source,$app _id,$start _time,$end _time,$skip,$limit){ $match= [' app_id ' + =$app _id, ' uid ' = = (int)$uid, ' msg_id ' =>1009, ' source ' =intval($source), "timestamp" = [' $gte ' + = (int)$start _time, ' $lt ' + = (int)$end _time], ]; $conditions=Array( Array(' $match ' =$match), ); //parameters for paged query if($skip> 0)$conditions[] =Array(' $skip ' + = (int)$skip); if($limit> 0)$conditions[] =Array(' $limit ' + = (int)$limit); //Specify the fields returned $project= [ ' Miss ' = ' $miss ', ' win ' and ' $miss ', ' bet ' = ' $bet ', ' User_win ' and ' $user _win ', ' Time ' = ' $timestamp ', ]; $conditions[] =Array(' $project ' =$project); $result=self::aggregate ($conditions); $final _data= []; foreach($result[' Result '] as $log){ $temp= []; $temp["Miss"] = (int) \utilities::mongogetnumber ($log[' Miss ']); $temp["Win"] = (int) \utilities::mongogetnumber ($log[' Win ']); $temp["bet"] = (int) \utilities::mongogetnumber ($log[' Bet ']); $temp["User_win"] = (int) \utilities::mongogetnumber ($log[' User_win ']); $temp["Time"] =Date("Y-m-d h:i:s", (int) \utilities::mongogetnumber ($log["Time"])); $final _data[]=$temp; } return $final _data; }
Paging Query in MONGO