MessageService.php 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Api;
  12. use App\Models\ImChatModel;
  13. use App\Models\MerchantModel;
  14. use App\Models\MessageModel;
  15. use App\Services\BaseService;
  16. use App\Services\ConfigService;
  17. use App\Services\RedisService;
  18. /**
  19. * 站内消息服务管理-服务类
  20. * @author laravel开发员
  21. * @since 2020/11/11
  22. * Class MessageService
  23. * @package App\Services\Api
  24. */
  25. class MessageService extends BaseService
  26. {
  27. // 静态对象
  28. protected static $instance = null;
  29. /**
  30. * 构造函数
  31. * @author laravel开发员
  32. * @since 2020/11/11
  33. * MessageService constructor.
  34. */
  35. public function __construct()
  36. {
  37. $this->model = new MessageModel();
  38. }
  39. /**
  40. * 静态入口
  41. * @return static|null
  42. */
  43. public static function make()
  44. {
  45. if (!self::$instance) {
  46. self::$instance = (new static());
  47. }
  48. return self::$instance;
  49. }
  50. /**
  51. * 消息列表
  52. * @param $userId
  53. * @param $params
  54. * @param int $pageSize
  55. * @return array
  56. */
  57. public function getDataList($userId, $params, $pageSize = 0)
  58. {
  59. $page = request()->post('page', 1);
  60. $cacheKey = "caches:messages:history_{$page}_" . md5($userId . json_encode($params) . $pageSize);
  61. $datas = RedisService::get($cacheKey);
  62. if ($datas) {
  63. return $datas;
  64. }
  65. $where = ['a.status' => 1, 'a.mark' => 1];
  66. $field = ['a.id', 'a.title', 'a.type', 'a.msg_type', 'a.chat_type', 'a.description', 'a.content', 'a.from_user_name', 'a.from_user_avatar', 'a.from_uid', 'a.to_user_name', 'a.to_user_avatar', 'a.to_uid', 'a.create_time', 'a.is_read', 'a.pages', 'a.status'];
  67. $datas = $this->model->from('message as a')
  68. ->leftJoin('member as b', 'b.id', '=', 'a.from_uid')
  69. ->leftJoin('member as c', 'c.id', '=', 'a.to_uid')
  70. ->where($where)
  71. ->where(function ($query) use ($params, $userId) {
  72. $fromUid = isset($params['from_uid']) ? intval($params['from_uid']) : 0;
  73. if ($fromUid) {
  74. $query->where('a.from_uid', $fromUid);
  75. }
  76. $type = isset($params['type']) ? intval($params['type']) : 0;
  77. if ($type) {
  78. $query->where('a.type', $type);
  79. }
  80. if ($type != 9) {
  81. $query->where('a.to_uid', $userId);
  82. }
  83. $chatType = isset($params['chat_type']) ? intval($params['chat_type']) : 0;
  84. if ($chatType) {
  85. $query->where('a.chat_type', $chatType);
  86. }
  87. $chatKey = isset($params['chat_key']) ? trim($params['chat_key']) : '';
  88. if ($chatKey) {
  89. $query->where('a.chat_key', $chatKey);
  90. }
  91. })->select($field)
  92. ->orderBy('a.create_time', 'desc')
  93. ->orderBy('a.id', 'desc')
  94. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  95. $datas = $datas ? $datas->toArray() : [];
  96. if ($datas) {
  97. $ids = [];
  98. foreach ($datas['data'] as &$item) {
  99. $ids[] = $item['id'];
  100. $item['time_text'] = isset($item['create_time']) && $item['create_time'] ? dateForWeek($item['create_time']) : '';
  101. $item['content'] = $item['msg_type'] == 2 ? get_images_preview(json_decode($item['content'], true), '') : $item['content'];
  102. $item['from_user_avatar'] = $item['from_user_avatar'] ? get_image_url($item['from_user_avatar']) : get_image_url('/images/member/logo.png');
  103. $item['to_user_avatar'] = $item['to_user_avatar'] ? get_image_url($item['to_user_avatar']) : get_image_url('/images/member/logo.png');
  104. }
  105. unset($item);
  106. // 更新已读
  107. if ($ids) {
  108. $this->model->whereIn('id', $ids)->update(['is_read' => 1, 'update_time' => time()]);
  109. }
  110. arsort($datas['data'], true);
  111. $datas['data'] = array_reverse($datas['data'], false);
  112. RedisService::set($cacheKey, $datas, rand(3, 5));
  113. }
  114. return [
  115. 'list' => isset($datas['data']) ? $datas['data'] : [],
  116. 'total' => isset($datas['total']) ? $datas['total'] : 0,
  117. 'pageSize' => $pageSize
  118. ];
  119. }
  120. /**
  121. * 获取站内消息窗口列表
  122. * @param $userId
  123. * @return array|mixed
  124. */
  125. public function getGroupList($userId, $cache = false)
  126. {
  127. $cachekey = "caches:message:topList_{$userId}";
  128. $datas = RedisService::get($cachekey);
  129. if ($datas && $cache) {
  130. $datas['cache'] = true;
  131. return $datas;
  132. }
  133. $types = [1, 4, 5];
  134. $setting = MemberSettingService::make()->getSetting($userId);
  135. $pushStatus = false;
  136. if ($setting) {
  137. foreach ($setting as $k => $v) {
  138. if ($v == 1) {
  139. if ($k == 'receive_app') {
  140. $pushStatus = true;
  141. } else if ($k == 'receive_order') {
  142. $types[] = 2;
  143. } else if ($k == 'receive_account') {
  144. $types[] = 3;
  145. }
  146. }
  147. }
  148. asort($types);
  149. } else {
  150. $pushStatus = true;
  151. $types = [1, 2, 3, 4, 5];
  152. }
  153. // 关闭系统APP消息
  154. if (!$pushStatus) {
  155. return ['list' => [], 'total' => 0, 'types' => []];
  156. }
  157. $field = ['title', 'type', 'to_uid', 'description', 'is_read', 'create_time'];
  158. $datas = $this->model->where(['to_uid' => $userId, 'status' => 1, 'mark' => 1])
  159. ->whereIn('type', $types)
  160. ->groupBy('type')
  161. ->orderBy('type', 'asc')
  162. ->orderBy('is_read', 'desc')
  163. ->orderBy('create_time', 'desc')
  164. ->select($field)
  165. ->get();
  166. $datas = $datas ? $datas->toArray() : [];
  167. $total = 0;
  168. if ($datas) {
  169. $titles = [1 => '公告通知', 2 => '订单通知', 3 => '账户通知', 4 => '客服通知', 5 => '互动消息'];
  170. foreach ($datas as &$item) {
  171. $item['title'] = isset($titles[$item['type']]) ? $titles[$item['type']] : '消息通知';
  172. $data = $this->getNewMessage($item['type'], 0, $userId);
  173. $item['description'] = isset($data['description']) && $data['description'] ? $data['description'] : (isset($data['content']) ? mb_substr($data['content'], 0, 56, 'utf-8') . '...' : lang('有新消息'));
  174. $item['create_time'] = isset($data['create_time']) && $data['create_time'] ? $data['create_time'] : '';
  175. $item['time_text'] = isset($item['create_time']) && $item['create_time'] ? dateFormat($item['create_time']) : '';
  176. $item['create_time'] = isset($item['create_time']) ? datetime($item['create_time'], 'Y-m-d H.i.s') : '';
  177. $unread = $this->getUnreadCount($userId, 0, $item['type']);
  178. $item['unread'] = intval($unread);
  179. $total += intval($unread);
  180. }
  181. RedisService::set($cachekey, ['list' => $datas, 'total' => $total, 'types' => $types], rand(2, 3));
  182. }
  183. return ['list' => $datas, 'total' => $total, 'types' => $types];
  184. }
  185. /**
  186. * 聊天分组消息
  187. * @param $userId
  188. * @param $params
  189. * @param int $pageSize
  190. * @return array
  191. */
  192. public function getDataListFromatKey($userId, $params, $pageSize = 0)
  193. {
  194. $page = request()->post('page', 1);
  195. $cacheKey = "caches:m_chat:{$page}_" . md5($userId . json_encode($params) . $pageSize);
  196. $datas = RedisService::get($cacheKey);
  197. $data = isset($datas['data']) ? $datas['data'] : [];
  198. if ($datas && $data) {
  199. return [
  200. 'unread' => isset($datas['unReadCount']) ? $datas['unReadCount'] : 0,
  201. 'total' => isset($datas['total']) ? $datas['total'] : 0,
  202. 'list' => $data,
  203. 'pageSize' => $pageSize,
  204. 'cache' => true,
  205. ];
  206. }
  207. // 不接收则不显示聊天消息
  208. $receiveCustom = MemberSettingService::make()->getSetting($userId, 'receive_custom', 1);
  209. if ($receiveCustom != 1) {
  210. return [
  211. 'unread' => 0,
  212. 'total' => 0,
  213. 'list' => [],
  214. 'pageSize' => $pageSize,
  215. 'close' => true,
  216. ];
  217. }
  218. $where = ['a.type' => 9, 'a.status' => 1, 'a.mark' => 1];
  219. $expire = ConfigService::make()->getConfigByCode('chat_log_expire');
  220. $expire = $expire ? $expire * 86400 : 60 * 86400;
  221. $field = ['a.id', 'a.title', 'a.type', 'a.msg_type','a.to_show', 'a.chat_key', 'a.chat_type', 'a.description', 'a.content', 'a.from_user_name', 'a.from_user_avatar', 'a.from_uid', 'a.to_user_name', 'a.to_user_avatar', 'a.to_uid', 'a.create_time', 'a.is_read', 'a.status'];
  222. $datas = $this->model->from('message as a')
  223. ->where($where)
  224. ->where('a.chat_key', '>', 0)
  225. ->where('a.create_time', '>=', time() - $expire)
  226. ->where(function ($query) use ($params, $userId) {
  227. $chatKey = isset($params['chat_key']) ? trim($params['chat_key']) : '';
  228. if ($chatKey) {
  229. $query->where('a.chat_key', $chatKey);
  230. }
  231. $isRead = isset($params['is_read']) ? intval($params['is_read']) : 0;
  232. if ($isRead) {
  233. $query->where('a.is_read', $isRead);
  234. }
  235. $chatType = isset($params['chat_type']) ? intval($params['chat_type']) : 0;
  236. if ($chatType) {
  237. $query->where('a.chat_type', $chatType);
  238. }
  239. if ($userId) {
  240. $query->where(function ($query) use ($userId) {
  241. $query->where(function($query) use($userId){
  242. $query->where(['a.from_uid' => $userId,'a.from_show'=>1]);
  243. })->orWhere(function($query) use($userId){
  244. $query->where(['a.to_uid' => $userId,'a.to_show'=>1]);
  245. });
  246. });
  247. }
  248. })
  249. ->select($field)
  250. ->groupBy('chat_key')
  251. ->orderBy('a.create_time', 'desc')
  252. ->orderBy('a.id', 'desc')
  253. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  254. $datas = $datas ? $datas->toArray() : [];
  255. $unReadCount = 0;
  256. if ($datas) {
  257. foreach ($datas['data'] as &$item) {
  258. $item['from_user_avatar'] = isset($item['from_user_avatar']) && $item['from_user_avatar'] ? get_image_url($item['from_user_avatar']) : get_image_url('/images/member/logo.png');
  259. $item['to_user_avatar'] = isset($item['to_user_avatar']) && $item['to_user_avatar'] ? get_image_url($item['to_user_avatar']) : get_image_url('/images/member/logo.png');
  260. $data = $this->getNewMessage(0, $item['chat_key']);
  261. $item['description'] = isset($data['description']) && $data['description'] ? $data['description'] : (isset($data['content']) ? mb_substr($data['content'], 0, 30, 'utf-8') : lang('有新消息'));
  262. $item['create_time'] = isset($data['create_time']) && $data['create_time'] ? $data['create_time'] : '';
  263. $item['time_text'] = isset($item['create_time']) && $item['create_time'] ? dateFormat($item['create_time']) : '';
  264. $item['create_time'] = isset($item['create_time']) ? datetime($item['create_time'], 'Y-m-d H.i.s') : '';
  265. $item['unread'] = $this->getUnreadCount($userId, $item['chat_key'], 0);
  266. if ($item['from_uid'] == $userId) {
  267. $item['from_user_name'] = $item['to_user_name'];
  268. $item['from_user_avatar'] = $item['to_user_avatar'];
  269. $item['tuid'] = $item['to_uid'];
  270. } else {
  271. $item['tuid'] = $item['from_uid'];
  272. }
  273. $unReadCount += intval($item['unread']);
  274. }
  275. unset($item);
  276. $datas['unReadCount'] = $unReadCount;
  277. RedisService::set($cacheKey, $datas, rand(3, 5));
  278. }
  279. return [
  280. 'unread' => $unReadCount,
  281. 'total' => isset($datas['total']) ? $datas['total'] : 0,
  282. 'list' => isset($datas['data']) ? $datas['data'] : [],
  283. 'pageSize' => $pageSize,
  284. 'cache' => false,
  285. ];
  286. }
  287. /**
  288. * 获取最新消息
  289. * @param $chatKey
  290. * @return mixed
  291. */
  292. public function getNewMessage($type = 0, $chatKey = 0, $userId = 0)
  293. {
  294. $cacheKey = "caches:messages:new_{$type}_{$chatKey}_{$userId}";
  295. $data = RedisService::get($cacheKey);
  296. if ($data) {
  297. return $data;
  298. }
  299. $where = ['status' => 1, 'mark' => 1];
  300. if ($type) {
  301. $where['type'] = $type;
  302. }
  303. if ($chatKey) {
  304. $where['chat_key'] = $chatKey;
  305. }
  306. if ($userId) {
  307. $where['to_uid'] = $userId;
  308. }
  309. $data = $this->model->where($where)->select('id', 'title', 'description', 'msg_type', 'content', 'create_time')
  310. ->orderBy('create_time', 'desc')
  311. ->orderBy('id', 'desc')
  312. ->first();
  313. $data = $data ? $data->toArray() : [];
  314. if ($data) {
  315. if ($data['msg_type'] == 2) {
  316. $data['description'] = '[图片]';
  317. } else if ($data['msg_type'] == 3) {
  318. $data['description'] = '[视频聊天]';
  319. } else if ($data['msg_type'] == 4) {
  320. $data['description'] = '[直播间分享]';
  321. }
  322. RedisService::set($cacheKey, $data, rand(3, 5));
  323. }
  324. return $data;
  325. }
  326. /**
  327. * 获取未读消息数量
  328. * @param $userId
  329. * @return array|mixed
  330. */
  331. public function getBarCount($userId, $type = 0)
  332. {
  333. $cacheKey = "caches:barCount:{$userId}_{$type}";
  334. $data = RedisService::get($cacheKey);
  335. if ($data) {
  336. return $data;
  337. }
  338. $data = $this->getUnreadCount($userId, 0, $type);
  339. RedisService::set($cacheKey, $data, rand(3, 5));
  340. return $data;
  341. }
  342. /**
  343. * 推送站内消息
  344. * @param $userId 用户ID
  345. * @param $title 标题
  346. * @param $message 消息内容
  347. * @param int $type 类型:1-公告,2-订单,3-账户,4-客服,5-动态
  348. * @return false
  349. */
  350. public function pushMessage($userId, $title, $message, $type = 1, $fromUid = 0)
  351. {
  352. $types = [4, 5];
  353. $pushStatus = false;
  354. $datas = MemberSettingService::make()->getSetting($userId);
  355. if ($datas) {
  356. foreach ($datas as $k => $v) {
  357. if ($v == 1) {
  358. if ($k == 'receive_app') {
  359. $pushStatus = true;
  360. $types[] = 1;
  361. } else if ($k == 'receive_order') {
  362. $types[] = 2;
  363. } else if ($k == 'receive_account') {
  364. $types[] = 3;
  365. }
  366. }
  367. }
  368. } else {
  369. $pushStatus = true;
  370. $types = [1, 2, 3, 4, 5];
  371. }
  372. if ($userId && $pushStatus && in_array($type, $types)) {
  373. $appName = ConfigService::make()->getConfigByCode('app_name', '星链社交');
  374. $log = [
  375. 'from_uid' => $fromUid,
  376. 'to_uid' => $userId,
  377. 'from_user_name' => $appName,
  378. 'chat_type' => 0,
  379. 'msg_type' => 1,
  380. 'type' => $type,
  381. 'title' => $title,
  382. 'description' => $title,
  383. 'content' => $message,
  384. 'chat_key' => "0{$userId}",
  385. 'create_time' => time(),
  386. 'status' => 1,
  387. 'mark' => 1,
  388. ];
  389. return MessageModel::insert($log);
  390. }
  391. return false;
  392. }
  393. /**
  394. * 获取
  395. * @param $userId
  396. * @return array|mixed
  397. */
  398. public function getUnreadCount($userId, $chatKey = 0, $type = 0)
  399. {
  400. $cacheKey = "caches:messages:un_{$userId}_{$chatKey}_{$type}";
  401. $data = RedisService::get($cacheKey);
  402. if (RedisService::exists($cacheKey)) {
  403. return $data;
  404. }
  405. $where = ['to_uid' => $userId,'to_show'=>1, 'status' => 1, 'is_read' => 2, 'mark' => 1];
  406. if ($type > 0) {
  407. $where['type'] = $type;
  408. }
  409. if ($chatKey) {
  410. $where['chat_key'] = $chatKey;
  411. }
  412. $data = $this->model->where($where)->count('id');
  413. RedisService::set($cacheKey, $data, rand(3, 5));
  414. return $data;
  415. }
  416. /**
  417. * 验证发送消息或者内容是否有屏蔽词
  418. * @param $message 消息或内容
  419. * @param $type 是否返回屏蔽后内容:1-是
  420. * @return bool
  421. */
  422. public function filterMessage($message, $type = 1)
  423. {
  424. $filter = ConfigService::make()->getConfigByCode('chat_sensitive');
  425. $filter = !empty($filter) ? explode('、', $filter) : [];
  426. $filter = array_filter($filter);
  427. if ($filter) {
  428. if ($type != 2) {
  429. foreach ($filter as $kw) {
  430. $message = preg_replace("/{$kw}/", '***', $message);
  431. }
  432. } else {
  433. foreach ($filter as $kw) {
  434. if (preg_match("/{$kw}/", $message)) {
  435. return false;
  436. }
  437. }
  438. }
  439. // 手机号、邮箱、网址
  440. if ($type == 1) {
  441. $message = preg_replace("/^(1[3-9][0-9]{9})$/", '***', $message);
  442. $message = preg_replace("/([a-z0-9&\-_.]+@[\w\-_]+([\w\-.]+)?\.[\w\-]+)/is", '***', $message);
  443. $message = str_replace(['https:', 'http:', '.com', '.cn', '.net', '.top', 'www.'], '***', $message);
  444. $message = preg_replace("/([a-zA-Z0-9][a-zA-Z0-9\_]{6,20})/", '***', $message);
  445. $message = preg_replace("/\*{3}\*{1,}/", '***', $message);
  446. }
  447. }
  448. return $type == 3 && $message === '***' ? '' : $message;
  449. }
  450. /**
  451. * 已读
  452. * @param $userId 用户ID
  453. * @param $chatKey 聊天窗口ID
  454. * @return bool
  455. */
  456. public function setRead($userId, $type = 0, $chatKey = '')
  457. {
  458. $where = ['to_uid' => $userId];
  459. if ($type) {
  460. $where['type'] = $type;
  461. }
  462. if ($chatKey) {
  463. $where['chat_key'] = $chatKey;
  464. }
  465. $this->model->where($where)->update(['is_read' => 1, 'update_time' => time()]);
  466. // 清除缓存
  467. RedisService::keyDel("caches:messages:bar*");
  468. RedisService::keyDel("caches:messages:new_*");
  469. RedisService::keyDel("caches:messages:un_*");
  470. RedisService::keyDel("caches:messages:topList_{$userId}");
  471. return true;
  472. }
  473. /**
  474. * 隐藏
  475. * @param $userId
  476. * @param int $expire
  477. * @return mixed
  478. */
  479. public function setHide($userId, $type)
  480. {
  481. $this->model->where(['to_uid' => $userId, 'type' => $type, 'status' => 1, 'mark' => 1])
  482. ->update(['update_time' => time(),'to_show'=>2, 'is_read' => 1, 'status' => 3]);
  483. // 清除缓存
  484. RedisService::keyDel("caches:messages:bar*");
  485. RedisService::keyDel("caches:messages:new_*");
  486. RedisService::keyDel("caches:messages:un_*");
  487. RedisService::keyDel("caches:messages:topList_{$userId}");
  488. return true;
  489. }
  490. /**
  491. * 清除历史
  492. * @param $userId
  493. * @param int $expire
  494. * @return mixed
  495. */
  496. public function clear($userId, $chatKey = 0, $type = 0)
  497. {
  498. $where = ['to_uid' => $userId, 'mark' => 1];
  499. if ($type) {
  500. $where['type'] = $type;
  501. }
  502. if ($chatKey) {
  503. $where['chat_key'] = $chatKey;
  504. }
  505. $this->model->where($where)
  506. ->update(['update_time' => time(), 'mark' => 0]);
  507. // 清除缓存
  508. RedisService::keyDel("caches:messages:bar*");
  509. RedisService::keyDel("caches:messages:new_*");
  510. RedisService::keyDel("caches:messages:un_*");
  511. RedisService::keyDel("caches:messages:topList_{$userId}");
  512. return true;
  513. }
  514. /**
  515. * 清除历史
  516. * @param $userId
  517. * @param int $expire
  518. * @return mixed
  519. */
  520. public function clearAll($userId, $type=0)
  521. {
  522. $expire = ConfigService::make()->getConfigByCode('chat_log_expire');
  523. $expire = $expire > 0 ? $expire : 60;
  524. $this->model->where(['to_uid' => $userId, 'mark' => 0])
  525. ->where('update_time', '<', time() - $expire * 86400)
  526. ->delete();
  527. // 清除缓存
  528. RedisService::keyDel("caches:messages:bar*");
  529. RedisService::keyDel("caches:messages:new_*");
  530. RedisService::keyDel("caches:messages:topList_{$userId}");
  531. // 站内消息发给我的全删
  532. $this->model->whereNotIn('type',[9])->where(function($query) use($userId, $type){
  533. $query->where(['to_uid'=> $userId,'mark'=>1]);
  534. if($type>0){
  535. $query->where('type', $type);
  536. }
  537. })->update(['update_time' => time(), 'mark' => 0]);
  538. if($type==9 || !$type){
  539. // 聊天消息我发的全删
  540. $this->model->where(function($query) use($userId){
  541. $query->where(['type'=>9,'from_uid'=> $userId,'mark'=>1]);
  542. })->update(['update_time' => time(), 'mark' => 0]);
  543. // 聊天消息发给我的,接收方全隐藏
  544. $this->model->where(function($query) use($userId){
  545. $query->where(['type'=>9,'to_uid'=> $userId,'mark'=>1]);
  546. })->update(['update_time' => time(),'is_read'=>1, 'to_show' => 2]);
  547. }
  548. return true;
  549. }
  550. }