getCurrentUser(); if (empty($userInfo['identity'])) { Render([], '2001', lang('Common','Api') -> get('user does login')); } $accountNewsWhere['account_identity'] = $userInfo['identity']; // 查询条件 if (!empty($_POST['read_status'])) { $accountNewsWhere['read_status'] = $_POST['read_status']; } if (!empty($_POST['type'])) { $accountNewsWhere['type'] = $_POST['type']; } // 时间区间 $startTime = isset($_POST['startTime'])? $_POST['startTime'] : '1900-01-01 00:00:00'; $endTime = isset($_POST['endTime'])? $_POST['endTime'] : '3000-12-12 00:00:00'; $accountNewsBetween = ['write_time' => [$startTime, $endTime]]; // 当前页 $currentPage = isset($_POST['currentPage']) ? $_POST['currentPage'] : "1"; // 分页大小 $pageSize = isset($_POST['pageSize']) ? $_POST['pageSize'] : "10"; // 起始查询位置 $begin = ($currentPage - 1) * $pageSize; $accountNewsMdl = lm('account_news', "commons"); // 获取消息 $accountNewsSlt = ['title', 'identity', 'content', 'details', 'write_time', 'read_status', 'type']; $getMoneyBuyStr = $accountNewsMdl -> accountNews($accountNewsSlt, $accountNewsWhere, $accountNewsBetween, $begin, $pageSize, 1); // 获取消息总数 $result['total'] = $accountNewsMdl -> accountNewsTotal($accountNewsWhere, $accountNewsBetween); $result['list'] = $getMoneyBuyStr; // 总页数计算 $result['countPage'] = ceil($result['total'] / $pageSize); $result['currentPage'] = $currentPage; return $result; } //获取用户投注相关消息通知 public static function getUserNews($userInfo){ if (empty($userInfo['identity'])) { Render([], '2001', lang('Common','Api') -> get('user does login')); } $accountNewsWhere['account_identity'] = $userInfo['identity']; // 查询条件 if (!empty($_POST['read_status'])) { $accountNewsWhere['read_status'] = $_POST['read_status']; } if (!empty($_POST['mold'])) { $accountNewsWhere['type'] = $_POST['mold']; } // 时间区间 $startTime = isset($_POST['startTime'])? $_POST['startTime'] : '1900-01-01 00:00:00'; $endTime = isset($_POST['endTime'])? $_POST['endTime'] : '3000-12-12 00:00:00'; $accountNewsBetween = ['write_time' => [$startTime, $endTime]]; // 当前页 $currentPage = isset($_POST['currentPage']) ? $_POST['currentPage'] : "1"; // 分页大小 $pageSize = isset($_POST['pageSize']) ? $_POST['pageSize'] : "10"; // 起始查询位置 $begin = ($currentPage - 1) * $pageSize; $accountNewsMdl = lm('account_news', "commons"); // 获取消息 $accountNewsSlt = ['title', 'identity', 'content', 'details', 'write_time', 'read_status', 'type']; $getMoneyBuyStr = $accountNewsMdl -> accountNews($accountNewsSlt, $accountNewsWhere, $accountNewsBetween, $begin, $pageSize, 1); // 获取消息总数 $result['total'] = $accountNewsMdl -> accountNewsTotal($accountNewsWhere, $accountNewsBetween); $result['list'] = $getMoneyBuyStr; // 总页数计算 $result['countPage'] = ceil($result['total'] / $pageSize); $result['currentPage'] = $currentPage; return $result; } //删除消息 public static function delUserNews(){ //获取消息id $identity = $_REQUEST['identity']; if (empty($identity)) { Render([], '40255', lang('Errors','Api') -> get('error-40255')); } $del = lm('account_news', "commons")::where('identity',$identity)->delete(); return $del; } //修改读取状态 public static function upStatus(){ //获取消息id $identity = $_REQUEST['identity']; if (empty($identity)) { Render([], '40255', lang('Errors','Api') -> get('error-40255')); } $up = [ 'read_status'=>1, ]; $upStatus = lm('account_news', "commons")::where('identity',$identity)->update($up); return $upStatus; } }