apicp.LotteryList.php
812 Bytes
<?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";
if(!isset($_GET['prize_id'])){
JsonResponse::error('prize_id参数不能为空');
}
$mysql = new mysqlHelper();
$prize_id = $_GET['prize_id'];
$prizeList = $mysql->fetchAll(
"SELECT l.id,l.user_id,u.realname,u.headimg,u.prize_no FROM lottery as l
LEFT JOIN user as u on u.id = l.user_id
WHERE prize_id = {$prize_id} AND is_cancel = 0");
$prizeList = $prizeList ?? [];
JsonResponse::result(['data' => $prizeList]);