apicp.ItemVoteList.php
1.04 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php
/**
* 获取用户列表
* 中奖用户列表会多给中奖类型和中奖时间
*/
include "Common/JsonResponse.php";
include "Common/mysqlHelper.php";
include "Common/Encrypter.php";
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Methods:GET,POST");
header("Access-Control-Allow-Headers:Content-Type,token,X-Requested-With");
if(strtoupper($_SERVER['REQUEST_METHOD'])== 'OPTIONS'){
exit;
}
$sql = "select
* ,
(select count(1) from item_vote iv where iv.item_id = i.id) as vote_no
from item i
ORDER BY vote_no desc";
$mysql = new mysqlHelper();
$data = $mysql->fetchAll($sql);
$i = 0;
foreach ($data as $key => &$value){
$value['vote_no_str'] = $value['vote_no']."票";
$lastVote = $data[$key - 1]['vote_no'] ?? 0;
if($value['vote_no'] != $lastVote){
$i++;
}
$value['ranking'] = '第'.$i.'名';
}
JsonResponse::result($data);