// +---------------------------------------------------------------------- declare (strict_types = 1); namespace app\api\model; use app\common\model\Imchat as ImchatModel; /** * 聊天消息模型 * Class Imchat * @package app\api\model */ class Imchat extends ImchatModel { /** * 获取列表 * @param array $param 查询条件 * @param int $listRows 分页数量 * @return mixed|\think\model\Collection|\think\Paginator * @throws \think\db\exception\DbException */ public function getList(array $param = [], int $listRows = 15) { // 整理查询参数 $params = array_merge($param, []); // 获取商品列表 $list = parent::getList($params, $listRows); if ($list->isEmpty()) { return $list; } // 整理列表数据并返回 return $this->setListDataFromApi($list); } public function getListByUser(int $userId, array $param = [], int $listRows = 15) { $param = array_merge($param, ['user_id'=> $userId,'data_type'=>'msg']); $list = $this->alias($this->name) ->leftJoin('user u','u.user_id='.$this->name.'.from_user_id') ->leftJoin('user u1','u.user_id='.$this->name.'.to_user_id') ->where(function($query) use($userId){ $query->where($this->name.'.from_user_id','=', $userId) ->whereOr($this->name.'.to_user_id','=', $userId); }) ->where(function($query) use($param){ $keyword = isset($param['keyword'])? $param['keyword'] : ''; if($keyword){ $query->where('u.nick_name','like',"%{$keyword}%") ->whereOr('u1.nick_name','like',"%{$keyword}%"); } }) ->field($this->name.".*") ->group($this->name.'.chat_key') ->order($this->name.'.sendtime','desc') ->order($this->name.'.is_push desc,'.$this->name.'.sendtime','desc') ->paginate($listRows); return $this->setListDataFromApi($list, $param); } /** * 设置展示的数据 api模块 * @param $info * @return mixed */ private function setListDataFromApi($info, $params=[]) { return $this->setListData($info, function ($data) use ($params){ // 统计最新未读消息 $dataType = isset($params['data_type'])? $params['data_type'] : ''; $userId = isset($params['user_id'])? $params['user_id'] : 0; $fromUserId = isset($data['from_user_id'])? $data['from_user_id'] : 0; $toUserId = isset($data['to_user_id'])? $data['to_user_id'] : 0; $data['unread_num'] = 0; $data['user_type'] = 1; if($dataType == 'msg'){ $data['unread_num'] = $userId && $fromUserId && $userId != $fromUserId? Imchat::getUnreadCount($userId, $fromUserId) : 0; } // 收到消息 if($userId == $toUserId) { $data['msg_type'] = 1; $data['show_user_id'] = $fromUserId; $info = User::cacheDetail($fromUserId); $data['nick_name'] = $info['nick_name']; $data['avatar_url'] = $info['avatar_url']; $data['user_type'] = $info['user_type']; $data['user_school_id'] = isset($info['info']['school_id'])? $info['info']['school_id'] : 0; $admissionYear = isset($info['info']['admission_year'])? $info['info']['admission_year'] : ''; $data['user_type_text'] = $data['user_type'] == 3? '招生老师' : ($admissionYear? $admissionYear.'级' : '学生'); } // 发送消息 if($userId == $fromUserId) { $data['msg_type'] = 2; $data['show_user_id'] = $toUserId; $info = User::cacheDetail($toUserId); $info['avatar'] = isset($info['avatar'])? $info['avatar'] : []; $info['info'] = isset($info['info'])? $info['info'] : []; $data['nick_name'] = $info['nick_name']; $data['avatar_url'] = $info['avatar_url']; $data['user_type'] = $info['user_type']; $data['user_school_id'] = isset($info['info']['school_id'])? $info['info']['school_id'] : 0; $admissionYear = isset($info['info']['admission_year'])? $info['info']['admission_year'] : ''; $admissionYear = isset($info['info']['admission_year'])? $info['info']['admission_year'] : ''; $data['user_type_text'] = $data['user_type'] == 3? '招生老师' : ($admissionYear? $admissionYear.'级' : '学生'); } // 用户学校 if($data['user_type'] == 3){ $data['user_school_name'] = $data['user_school_id']? School::getSchoolField($data['user_school_id']) : ''; }else{ $data['user_school_name'] = $data['user_school_id']? SourceShool::getSchoolField($data['user_school_id']) : ''; } // 整理数据 api模块 $this->setDataFromApi($data); // 隐藏冗余的字段 $this->hidden(array_merge($this->hidden, ['chat_key','sendtime'])); }); } /** * 整理数据 api模块 * @param $info * @return mixed */ private function setDataFromApi($info) { return $this->setData($info, function ($data) { $sendTime = $data['sendtime']? intval($data['sendtime']) : 0; $data['sendtime_text'] = $sendTime? getTimeText($sendTime) : ''; }); } /** * 获取未读消息数量 * @param $userId * @return int */ public static function getUnreadCount($userId, $fromUserId) { return self::where(['from_user_id'=> $fromUserId,'to_user_id'=> $userId,'is_push'=>1])->count('id'); } }