apicp.ItemList.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
42
43
44
<?php
/**
* 跨域处理
*/
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Methods:GET,POST");
/**
* 返回节目列表
*/
include "Common/JsonResponse.php";
include "Common/mysqlHelper.php";
include "Common/WechatHelper.php";
include "Common/Encrypter.php";
// id，头像
$user_id = $_GET['user_id'] ?? '';
$mysql = new mysqlHelper();
$data = $mysql->fetchAll("SELECT * FROM item");
foreach ($data as $key => &$value){
$value['id'] = (int)$value['id'];
$value['performer_list'] = json_decode($value['performer_list'],true);
}
$userVote = [];
if(!empty($user_id)){
$userVote = $mysql->fetchAll("SELECT item_id FROM item_vote WHERE user_id = ?", [$user_id]);
if(!empty($userVote)){
$userVote = array_column($userVote,'item_id');
}
}
$res = [
'data' => [
'item' => $data,
'user_vote' => $userVote
]
];
// 返回桌位列表
JsonResponse::result($res);