MessageService.php 25 KB

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