ChatController.php 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995
  1. <?php
  2. namespace App\Http\Controllers\Api;
  3. use App\Http\Controllers\Api\Repositories\WxContRepositories;
  4. use App\Jobs\System\ChatExpandTypeCheckJob;
  5. use App\Jobs\UserInputSafeCheckJob;
  6. use App\Models\Circle\WxCircle;
  7. use App\Models\Pets\WxPetsAdoption;
  8. use App\Models\Pets\WxPetsAdoptionApply;
  9. use App\Models\Posts\WxComment;
  10. use App\Models\Posts\WxPost;
  11. use App\Models\Shop\WxShopGoods;
  12. use App\Models\Shop\WxShopOrderGoods;
  13. use App\Models\Shop\WxShopService;
  14. use App\Models\Used\WxUsedGood;
  15. use App\Models\User\WxUserContactApply;
  16. use App\Models\User\WxUserStudentCertify;
  17. use App\Models\Voter\WxVoter;
  18. use App\Models\Voter\WxVoterPlayer;
  19. use App\Models\WxAuthentication;
  20. use App\Models\WxChat;
  21. use App\Models\User\WxUser;
  22. use App\Wen\Utils\CircleUtils;
  23. use App\Wen\Utils\CommentUtils;
  24. use App\Wen\Utils\FieldUtils;
  25. use App\Wen\Utils\GatewayUtils;
  26. use App\Wen\Utils\PetUtils;
  27. use App\Wen\Utils\PostUtils;
  28. use App\Wen\Utils\Settings;
  29. use App\Wen\Utils\ShopUtils;
  30. use App\Wen\Utils\UserUtils;
  31. use App\Wen\Utils\Utils;
  32. use Illuminate\Http\Request;
  33. use Illuminate\Support\Facades\DB;
  34. class ChatController extends BaseController
  35. {
  36. public function massages_process(Request $request) {
  37. $type = _empty_default_($request->type, '');
  38. if($type == 'review_object'){
  39. return $this->review_object($request);
  40. }
  41. }
  42. private function review_object(Request &$request){
  43. $chat_id = _empty_default_($request->chat_id, 0);
  44. if(_empty_($chat_id)){
  45. return $this->fail(200001);
  46. }
  47. $chat = WxChat::find($chat_id);
  48. if(!$chat){
  49. return $this->fail(200003);
  50. }
  51. // 101: 笔记审核 102:评论审核 103:组局审核 104:选票审核 105:选手审核 106:闲置审核 107:圈子审核 108:学生认证审核 109:身份认证审核 110 俱乐部审核
  52. if(!in_array($chat->expand_type, [101, 102, 103, 104, 105, 106, 107, 108, 109, 110])){
  53. return $this->fail(200004);
  54. }
  55. global $__MINI_GLOBAL_IS_ADMIN_SUPER__,$__MINI_GLOBAL_CURRENT_USER_ID__;
  56. if(!$__MINI_GLOBAL_IS_ADMIN_SUPER__){
  57. if($chat->expand_type == 105){
  58. $voter_id = WxVoterPlayer::where('id', $chat->expand_id)->value('voter_id');
  59. if(_empty_($voter_id)){
  60. return $this->fail(200000);
  61. }
  62. if(WxVoter::where('id', $voter_id)->value('user_id') != $__MINI_GLOBAL_CURRENT_USER_ID__){
  63. return $this->fail(200000);
  64. }
  65. }else{
  66. return $this->fail(200000);
  67. }
  68. }
  69. $flag = _empty_default_($request->flag, 0);
  70. if(!in_array($flag, [1, 2])){
  71. return $this->fail(200004);
  72. }
  73. if($chat->expand_type == 101){
  74. //expand_id
  75. $the_object = WxPost::where('is_examine', 0)->where('id', $chat->expand_id)->first();
  76. if($the_object){
  77. PostUtils::post_pass($the_object, $flag);
  78. return $this->success();
  79. }else{
  80. WxChat::where('id', $chat->id)->forceDelete();
  81. return $this->fail(200003);
  82. }
  83. }else if($chat->expand_type == 102){
  84. $the_object = WxComment::where('comment_state', 0)->where('id', $chat->expand_id)->first();
  85. if($the_object){
  86. CommentUtils::comment_pass($the_object, $flag);
  87. return $this->success();
  88. }else{
  89. WxChat::where('id', $chat->id)->forceDelete();
  90. return $this->fail(200003);
  91. }
  92. }else if($chat->expand_type == 104){
  93. $the_object = WxVoter::find($chat->expand_id);
  94. if($the_object){
  95. if($flag == 1){
  96. if($the_object->status == 0){
  97. $the_object->status = 1;
  98. $the_object->save();
  99. UserUtils::add_user_experience($the_object->user_id, 16, 20);
  100. }
  101. }else{
  102. if($the_object->status == 1){
  103. $the_object->status = 0;
  104. $the_object->save();
  105. }
  106. }
  107. return $this->success();
  108. }else{
  109. WxChat::where('id', $chat->id)->forceDelete();
  110. return $this->fail(200003);
  111. }
  112. }else if($chat->expand_type == 105){
  113. $the_object = WxVoterPlayer::find($chat->expand_id);
  114. if($the_object){
  115. if($flag == 1){
  116. if($the_object->status == 0){
  117. $the_object->status = 1;
  118. $the_object->save();
  119. UserUtils::add_user_experience($the_object->user_id, 19, 20);
  120. }
  121. }else{
  122. if($the_object->status == 1){
  123. $the_object->status = 0;
  124. $the_object->save();
  125. }
  126. }
  127. return $this->success();
  128. }else{
  129. WxChat::where('id', $chat->id)->forceDelete();
  130. return $this->fail(200003);
  131. }
  132. }else if($chat->expand_type == 106){
  133. $the_object = WxUsedGood::find($chat->expand_id);
  134. if($the_object){
  135. if($flag == 1){
  136. if($the_object->status == 0){
  137. $the_object->status = 1;
  138. $the_object->save();
  139. UserUtils::add_user_experience($the_object->user_id, 106, 30);
  140. }
  141. }else{
  142. if($the_object->status == 1){
  143. $the_object->status = 99;
  144. $the_object->save();
  145. }
  146. }
  147. return $this->success();
  148. }else{
  149. WxChat::where('id', $chat->id)->forceDelete();
  150. return $this->fail(200003);
  151. }
  152. }else if($chat->expand_type == 107){
  153. $the_object = WxCircle::where('circle_state', 0)->where('id', $chat->expand_id)->first();
  154. if($the_object){
  155. if($flag == 1){
  156. CircleUtils::circle_pass($the_object, 1, '');
  157. }else{
  158. CircleUtils::circle_pass($the_object, 2, '');
  159. }
  160. return $this->success();
  161. }else{
  162. WxChat::where('id', $chat->id)->forceDelete();
  163. return $this->fail(200003);
  164. }
  165. }else if($chat->expand_type == 108){
  166. $the_object = WxUserStudentCertify::find($chat->expand_id);
  167. if($the_object){
  168. if($flag == 1){
  169. if($the_object->status == 0){
  170. $the_object->status = 1;
  171. $the_object->save();
  172. UserUtils::add_user_experience($the_object->user_id, 18, 30);
  173. }
  174. }else{
  175. if($the_object->status == 1){
  176. $the_object->status = 0;
  177. $the_object->save();
  178. }
  179. }
  180. return $this->success();
  181. }else{
  182. WxChat::where('id', $chat->id)->forceDelete();
  183. return $this->fail(200003);
  184. }
  185. }else if($chat->expand_type == 109){
  186. $the_object = WxAuthentication::where('authentication_state', 0)->where('id', $chat->expand_id)->first();
  187. if($the_object){
  188. if($flag == 1){
  189. UserUtils::authenticate_pass($the_object, 1, '');
  190. }else{
  191. UserUtils::authenticate_pass($the_object, 2, '');
  192. }
  193. return $this->success();
  194. }else{
  195. WxChat::where('id', $chat->id)->forceDelete();
  196. return $this->fail(200003);
  197. }
  198. }else if($chat->expand_type == 110){
  199. $the_object = WxClub::find($chat->expand_id);
  200. if($the_object){
  201. if($flag == 1){
  202. if($the_object->status == 0){
  203. $the_object->status = 1;
  204. $the_object->save();
  205. }
  206. }else{
  207. if($the_object->status == 1){
  208. $the_object->status = 0;
  209. $the_object->save();
  210. }
  211. }
  212. return $this->success();
  213. }else{
  214. WxChat::where('id', $chat->id)->forceDelete();
  215. return $this->fail(200003);
  216. }
  217. }
  218. }
  219. private function after_sale_message(Request &$request){
  220. }
  221. /**
  222. * 用户发起聊天
  223. * @param Request $request
  224. * @return \Illuminate\Http\JsonResponse
  225. */
  226. public function addChat(Request $request)
  227. {
  228. $uid = $request->uid;
  229. $oid = $request->oid;
  230. if($uid == $oid){
  231. return $this->fail(200040);
  232. }
  233. _limit_user('chat', $uid, 30);
  234. if(!UserUtils::is_user_can_speak($uid)){
  235. return $this->fail(200043, [
  236. 'title' => '禁言中,无法言论',
  237. 'content' => '是否前往解除限制',
  238. 'confirmText' => '去解除',
  239. 'target_type' => 6,
  240. 'target_id' => '/pagesA/mine/unlock/unlock?user_id='.$uid
  241. ], '您当前处于禁言期间,无法言论');
  242. }
  243. $chat_content = $request->input('chat_content', '');
  244. $chat_image = $request->input('chat_image', '');
  245. $chat_audio_url = $request->input('chat_audio_url', '');
  246. $chat_audio_length = $request->input('chat_audio_length', '');
  247. $refer_id = $request->input('refer_id', 0);
  248. $shop_good_id = $request->input('shop_good_id', 0);
  249. $voter_id = _abs(_empty_default_($request->voter_id, 0));
  250. $ask_order_id = _abs(_empty_default_($request->ask_order_id, 0));
  251. if(_empty_($uid) || _empty_($oid)){
  252. return $this->fail(200001);
  253. }
  254. if(_empty_($shop_good_id)){
  255. $shop_good_id = 0;
  256. }else{
  257. $shop_good_id = _abs($shop_good_id);
  258. }
  259. if($shop_good_id > 0){
  260. // 比较特殊,需要转换身份,由商家发送
  261. $tmp_ = $oid;
  262. $oid = $uid;
  263. $uid = $tmp_;
  264. $last_chat = WxChat::where('user_id', $uid)->where('object_id', $oid)->orderByDesc('id')->first();
  265. if($last_chat && $last_chat->expand_type == 4 && $last_chat->expand_id == $shop_good_id){
  266. return $this->success();
  267. }
  268. }
  269. if(_empty_($refer_id)){
  270. $refer_id = 0;
  271. }else{
  272. $refer_id = _abs($refer_id);
  273. }
  274. if(_empty_($refer_id) && _empty_($shop_good_id) && _empty_($voter_id)){
  275. if(_empty_($chat_content) && _empty_($chat_image) && (_empty_($chat_audio_url) || _empty_($chat_audio_length))){
  276. return $this->fail(200001);
  277. }
  278. }
  279. if(!UserUtils::is_user_can_chat($uid)){
  280. return $this->fail(200000, [], '抱歉,您没有聊天权限');
  281. }
  282. if($ask_order_id){
  283. $ask_order = DB::table('ask_order')->where('status',10)->where('id',$ask_order_id)->first();
  284. if($ask_order && $ask_order->blogger_user_id == $request->uid){
  285. //提示绑定手机号
  286. $userinfo = DB::table('wx_user')->where('id',$request->uid)->first();
  287. if(empty($userinfo->phone)){
  288. return $this->fail(200016,[],'请先绑定手机号');
  289. }
  290. }
  291. }
  292. $model = WxContRepositories::add($uid, $oid, $chat_content, $chat_image, $chat_audio_url, $chat_audio_length, $refer_id, 0, 0, $shop_good_id, null, 0, $voter_id,$ask_order_id); //通用聊天
  293. //付费咨询的逻辑
  294. if($model){
  295. if($ask_order_id){
  296. //如果是答主的第一句话,倒计时开始
  297. // $ask_order = DB::table('ask_order')->where('status',10)->where('id',$ask_order_id)->first();
  298. if($ask_order){
  299. $blogger_chat = DB::table('wx_chat')->where([
  300. ['user_id','=',$ask_order->blogger_user_id],
  301. ['object_id','=',$ask_order->user_id],
  302. ['expand_type','=',9],
  303. ['expand_id','=',$ask_order_id],
  304. ])->count();
  305. if($blogger_chat == 1){
  306. $countdown_time = $ask_order->ask_minute * 60 + time(); //倒计时时间
  307. DB::table('ask_order')->where('status',10)->where('id',$ask_order_id)->update([
  308. 'status' => 15, //已回复
  309. 'countdown_time' => $countdown_time, //倒计时
  310. ]);
  311. //给提问者发短信
  312. $ask_userinfo = DB::table('wx_user')->where('id',$ask_order->user_id)->first();
  313. if($ask_userinfo && $ask_userinfo->phone && $ask_userinfo->country_code){
  314. $idd = $ask_userinfo->country_code;
  315. $phone = $ask_userinfo->phone;
  316. //
  317. //$res = Utils::sendSMS($idd,$phone, $code, 60, 'code:'.$idd.':'.$phone);
  318. }
  319. }
  320. }
  321. }
  322. }
  323. if($model){
  324. $websocket_id = GatewayUtils::uid2client_id($oid);
  325. if($websocket_id){
  326. GatewayUtils::success($websocket_id, 5, ['chat_content'=>_mini_emoji($chat_content, true), 'chat_image'=>$chat_image,
  327. 'from_user'=>UserUtils::get_cached_user($uid) ]);
  328. }
  329. $model->type = 'user';
  330. $imgList = array();
  331. array_push($imgList, ['img_url' => $model->chat_image]);
  332. $model->imgList = $imgList;
  333. $model->user = WxUser::where('id', $model->user_id)->first(FieldUtils::userInfoColums());
  334. $model->datetime = format_datetime($model->created_at);
  335. if($model->chat_audio_url && $model->chat_audio_length){
  336. $model->mode = 'audio';
  337. }else if($model->chat_image){
  338. $model->mode = 'img';
  339. }else if($model->refer_id){
  340. $model->mode = 'refer';
  341. }else{
  342. $model->mode = 'text';
  343. }
  344. if(!_empty_($model->chat_audio_length)){
  345. $min = (int)($model->chat_audio_length / 60);
  346. if($min < 10){
  347. $min = '0'.$min;
  348. }
  349. $sec = $model->chat_audio_length % 60;
  350. if($sec < 10){
  351. $sec = '0'.$sec;
  352. }
  353. $model->chat_audio_length = $min.':'.$sec;
  354. }
  355. }
  356. UserInputSafeCheckJob::dispatch($uid, _mini_emoji($chat_content, true));
  357. if($chat_image || $chat_audio_url){
  358. Utils::image_state_change([$chat_image, $chat_audio_url], 1);
  359. }
  360. return $this->success($model);
  361. }
  362. /**
  363. * 查询用户聊天记录
  364. * @param Request $request
  365. * @return \Illuminate\Http\JsonResponse
  366. */
  367. public function getUserChat(Request $request, $limit = 6)
  368. {
  369. $uid = $request->uid;
  370. $oid = $request->oid;
  371. if(_empty_($uid) || _empty_($oid)){
  372. return $this->fail(200001);
  373. }
  374. $data = WxChat::where(function($query) use ($uid, $oid) {
  375. $query->where(function ($query) use ($uid, $oid) {
  376. $query->where('user_id', $uid)
  377. ->where('object_id', $oid);
  378. })
  379. ->orWhere(function ($query) use ($uid, $oid) {
  380. $query->where('user_id', $oid)
  381. ->where('object_id', $uid);
  382. });
  383. })
  384. ->where('expand_type','!=',9) //排除问答聊天,因为要独立
  385. ->orderByRaw('id DESC')
  386. ->simplePaginate($limit);
  387. $data->map(function ($v) use ($uid){
  388. $v->type = 'user';
  389. $imgList = array();
  390. array_push($imgList, ['img_url' => $v->chat_image]);
  391. $v->imgList = $imgList;
  392. $v->user = WxUser::where('id', $v->user_id)->first(FieldUtils::userInfoColums());
  393. $v->datetime = format_datetime($v->created_at);
  394. if($v->chat_audio_url && $v->chat_audio_length){
  395. $v->mode = 'audio';
  396. }else if($v->chat_image){
  397. $v->mode = 'img';
  398. }else if($v->refer_id){
  399. $v->mode = 'refer';
  400. if($v->expand_type != 1 || $v->expand_id != $v->refer_id){
  401. ChatExpandTypeCheckJob::dispatch();
  402. }
  403. }else if($v->adoption_apply_id){
  404. $v->mode = 'adoption_reply';
  405. if($v->expand_type != 3 || $v->expand_id != $v->adoption_apply_id){
  406. ChatExpandTypeCheckJob::dispatch();
  407. }
  408. }else if($v->contact_apply_id){
  409. $v->mode = 'contact_apply';
  410. if($v->expand_type != 2 || $v->expand_id != $v->contact_apply_id){
  411. ChatExpandTypeCheckJob::dispatch();
  412. }
  413. }else{
  414. if($v->expand_type > 0){
  415. if($v->expand_type == 1){
  416. $v->mode = 'refer';
  417. $v->refer_id = $v->expand_id;
  418. }else if($v->expand_type == 2){
  419. $v->mode = 'contact_apply';
  420. $v->contact_apply_id = $v->expand_id;
  421. }else if($v->expand_type == 3){
  422. $v->mode = 'adoption_reply';
  423. $v->adoption_apply_id = $v->expand_id;
  424. }else if($v->expand_type == 4){
  425. $v->mode = 'shop_good';
  426. $v->shop_good_id = $v->expand_id;
  427. }else if($v->expand_type == 5){
  428. $v->mode = 'used_good';
  429. $v->used_good_id = $v->expand_id;
  430. }else if($v->expand_type == 8){
  431. $v->mode = 'voter';
  432. $v->voter_id = $v->expand_id;
  433. }else if($v->expand_type == 9){
  434. //仅占用
  435. $v->mode = 'ask_order';
  436. $v->ask_order_id = $v->expand_id;
  437. }else if(in_array($v->expand_type, [101, 102, 103, 104, 105, 106, 107, 108, 109, 110])){
  438. $v->mode = 'review';
  439. }else{
  440. // 101: 笔记审核 102:评论审核 103:组局审核 104:选票审核 105:选手审核 106:闲置审核
  441. return $this->fail(200006, [], '数据库expand_type不合法');
  442. }
  443. }else{
  444. $v->mode = 'text';
  445. }
  446. }
  447. if($v->mode == 'review'){
  448. if($v->expand_type == 101){
  449. $the_post = WxPost::find($v->expand_id);
  450. if($the_post){
  451. $posts_content = $the_post->posts_content;
  452. if($posts_content){
  453. $s_content = preg_replace("/<(img|video).*?src[^\'\"]+[\'\"]([^\"\']+)[^>]+>/is", '', $posts_content);
  454. $s_content =trim_all_space(strip_tags(html_entity_decode($s_content)), true);
  455. }
  456. $v->chat_content = $the_post->posts_title ?: PostUtils::get_the_title($s_content, $the_post->id);
  457. PostUtils::mediaProcess($the_post, $uid, 90003, 0, true);
  458. $v->chat_image = Utils::imgWithStyle($the_post->img, 0, false, true);
  459. $v->review = [
  460. 'target_type' => 1,
  461. 'target_id' => $v->expand_id,
  462. 'state' => $the_post->is_examine,
  463. 'title_tip' => '笔记',
  464. 'state_tip' => [0=>'待审核', 1=>'审核通过', 2=>'驳回'][$the_post->is_examine],
  465. 'can_refuse' => 1,
  466. 'user' => UserUtils::get_cached_user($the_post->user_id),
  467. ];
  468. }else{
  469. WxChat::where('id', $v->id)->forceDelete();
  470. }
  471. }else if($v->expand_type == 102){
  472. $the_comment = WxComment::find($v->expand_id);
  473. if($the_comment){
  474. $v->chat_image = $the_comment->comment_img_url;
  475. $v->chat_content = $the_comment->comment_content;
  476. $v->review = [
  477. 'target_type' => 25,
  478. 'target_id' => '评论不可跳转',
  479. 'state' => $the_comment->comment_state,
  480. 'title_tip' => '笔记评论',
  481. 'state_tip' => [0=>'待审核', 1=>'审核通过', 2=>'驳回'][$the_comment->comment_state],
  482. 'can_refuse' => 1,
  483. 'user' => UserUtils::get_cached_user($the_comment->user_id),
  484. ];
  485. }else{
  486. WxChat::where('id', $v->id)->forceDelete();
  487. }
  488. }else if($v->expand_type == 104){
  489. $the_voter = WxVoter::find($v->expand_id);
  490. if($the_voter){
  491. $v->chat_content = $the_voter->title;
  492. if($the_voter->banners){
  493. $v->chat_image = _array_key($the_voter->banners, 0, '');
  494. }
  495. $v->review = [
  496. 'target_type' => 33,
  497. 'target_id' => $v->expand_id,
  498. 'state' => $the_voter->status,
  499. 'title_tip' => '选票',
  500. 'state_tip' => [0=>'审核中', 1=>'推送中', 2=>'驳回'][$the_voter->status],
  501. 'can_refuse' => 0,
  502. 'user' => UserUtils::get_cached_user($the_voter->user_id),
  503. ];
  504. }else{
  505. WxChat::where('id', $v->id)->forceDelete();
  506. }
  507. }else if($v->expand_type == 105){
  508. $player = WxVoterPlayer::find($v->expand_id);
  509. if($player){
  510. $v->chat_content = $player->show_name;
  511. if($player->img_urls){
  512. $v->chat_image = _array_key($player->img_urls, 0, '');
  513. }
  514. $v->review = [
  515. 'target_type' => 6,
  516. 'target_id' => '/pagesV/voter/detail/player?id='.$v->expand_id,
  517. 'state' => $player->status,
  518. 'title_tip' => '选票选手',
  519. 'state_tip' => [0=>'审核中', 1=>'推送中', 2=>'驳回'][$player->status],
  520. 'can_refuse' => 0,
  521. 'user' => UserUtils::get_cached_user($player->user_id),
  522. ];
  523. }else{
  524. WxChat::where('id', $v->id)->forceDelete();
  525. }
  526. }else if($v->expand_type == 106){
  527. $the_used = WxUsedGood::find($v->expand_id);
  528. if($the_used){
  529. $v->chat_content = $the_used->title;
  530. if($the_used->image_urls){
  531. $v->chat_image = _array_key($the_used->image_urls[0], 'url', '');
  532. }
  533. $v->review = [
  534. 'target_type' => 28,
  535. 'target_id' => $v->expand_id,
  536. 'state' => $the_used->status == 99 ? 2 : ($the_used->status === 0 ? 0 : 1),
  537. 'title_tip' => '闲置商品',
  538. 'state_tip' => FieldUtils::usedGoodState()[$the_used->status],
  539. 'can_refuse' => 1,
  540. 'user' => UserUtils::get_cached_user($the_used->user_id),
  541. ];
  542. }else{
  543. WxChat::where('id', $v->id)->forceDelete();
  544. }
  545. }else if($v->expand_type == 107){
  546. $the_circle = WxCircle::find($v->expand_id);
  547. if($the_circle){
  548. $v->chat_content = $the_circle->circle_name;
  549. $v->chat_image = $the_circle->head_portrait;
  550. $v->review = [
  551. 'target_type' => 2,
  552. 'target_id' => $v->expand_id,
  553. 'state' => $the_circle->circle_state,
  554. 'title_tip' => '新建圈子',
  555. 'state_tip' => [0=>'审核中', 1=>'推送中', 2=>'驳回'][$the_circle->circle_state],
  556. 'can_refuse' => 1,
  557. 'user' => UserUtils::get_cached_user($the_circle->user_id),
  558. ];
  559. }else{
  560. WxChat::where('id', $v->id)->forceDelete();
  561. }
  562. }else if($v->expand_type == 108){
  563. $student = WxUserStudentCertify::where('user_id', $v->expand_id)->first();
  564. if($student){
  565. $v->chat_content = $student->school;
  566. $v->chat_image = $student->picture;
  567. $v->review = [
  568. 'target_type' => 25,
  569. 'target_id' => '学生认证暂不可跳转',
  570. 'state' => $student->status,
  571. 'title_tip' => '学生认证',
  572. 'state_tip' => [0=>'待审核', 1=>'已通过', 2=>'驳回'][$student->status],
  573. 'can_refuse' => 0,
  574. 'user' => UserUtils::get_cached_user($student->user_id),
  575. ];
  576. }else{
  577. WxChat::where('id', $v->id)->forceDelete();
  578. }
  579. }else if($v->expand_type == 109){
  580. $authentication = WxAuthentication::find($v->expand_id);
  581. if($authentication){
  582. $v->chat_content = $authentication->name;
  583. $v->chat_image = $authentication->identity_picture;
  584. $v->review = [
  585. 'target_type' => 25,
  586. 'target_id' => '身份认证暂不可跳转',
  587. 'state' => $authentication->authentication_state,
  588. 'title_tip' => '身份认证',
  589. 'state_tip' => [0=>'审核中', 1=>'已通过', 2=>'驳回'][$authentication->authentication_state],
  590. 'can_refuse' => 0,
  591. 'user' => UserUtils::get_cached_user($authentication->user_id),
  592. ];
  593. }else{
  594. WxChat::where('id', $v->id)->forceDelete();
  595. }
  596. }else if($v->expand_type == 110){
  597. $club = WxClub::where('id', $v->expand_id)->first();
  598. if($club){
  599. $v->chat_content = _empty_default_($club->name_tmp, $club->name);
  600. $v->chat_image = _empty_default_($club->avatar_tmp, $club->avatar);
  601. $v->review = [
  602. 'target_type' => 35,
  603. 'target_id' => $v->expand_id,
  604. 'state' => $club->status,
  605. 'title_tip' => '俱乐部审核',
  606. 'state_tip' => [0=>'待审核', 1=>'已通过', 2=>'驳回'][$club->status],
  607. 'can_refuse' => 0,
  608. 'user' => UserUtils::get_cached_user($club->user_id),
  609. ];
  610. }else{
  611. WxChat::where('id', $v->id)->forceDelete();
  612. }
  613. }
  614. if(_empty_($v->chat_image)){
  615. $v->chat_image = Settings::get('img_default', '').'?imageMogr2/thumbnail/200x200/crop/200x200/gravity/center/format/jpg/interlace/0/quality/100';
  616. }else{
  617. $v->chat_image = $v->chat_image.'?imageMogr2/thumbnail/200x200/crop/200x200/gravity/center/format/jpg/interlace/0/quality/100';
  618. }
  619. }
  620. if(!_empty_($v->chat_audio_length)){
  621. $min = (int)($v->chat_audio_length / 60);
  622. if($min < 10){
  623. $min = '0'.$min;
  624. }
  625. $sec = $v->chat_audio_length % 60;
  626. if($sec < 10){
  627. $sec = '0'.$sec;
  628. }
  629. $v->chat_audio_length = $min.':'.$sec;
  630. }
  631. if(!_empty_($v->refer_id)){
  632. if($v->refer_id && $v->refer_id > 0){
  633. $refer_post = WxPost::find($v->refer_id);
  634. if($refer_post){
  635. PostUtils::mediaProcess($refer_post, $uid, 15, 0, true);
  636. if($refer_post->posts_content_raw){
  637. $refer_post->posts_content_raw = strip_tags($refer_post->posts_content_raw);
  638. }
  639. $v->refer = $refer_post;
  640. }else{
  641. WxChat::where('id', $v->id)->delete();
  642. }
  643. }else{
  644. $v->refer = null;
  645. }
  646. }
  647. if(!_empty_($v->adoption_apply_id)){
  648. if($v->adoption_apply_id && $v->adoption_apply_id > 0){
  649. $adoption_reply = WxPetsAdoptionApply::find($v->adoption_apply_id);
  650. if($adoption_reply){
  651. $v->adoption_reply = PetUtils::adoption_apply_process($adoption_reply, $uid);
  652. $v->adoption_reply->adoption = PetUtils::adoption_process(WxPetsAdoption::find($adoption_reply->pet_adoption_id));
  653. }else{
  654. WxChat::where('id', $v->id)->delete();
  655. }
  656. }else{
  657. $v->adoption_reply = null;
  658. }
  659. }
  660. if(!_empty_($v->used_good_id)){
  661. $user_good = WxUsedGood::where('id', $v->used_good_id)->first();
  662. if($user_good){
  663. ShopUtils::used_process($user_good);
  664. if($user_good->pic){
  665. $user_good->pic = $user_good->pic.'?imageMogr2/quality/100/format/webp/interlace/0/crop/200x200/gravity/center/thumbnail/200x';
  666. }
  667. $user_good->servicer_word = '亲,想要可以直接拍';
  668. $v->used_good = $user_good;
  669. }else{
  670. WxChat::where('id', $v->id)->delete();
  671. }
  672. }
  673. if(!_empty_($v->voter_id)){
  674. $voter = WxVoter::where('id', $v->voter_id)->first();
  675. if($voter){
  676. if($voter->banners){
  677. $voter->pic = $voter->banners[0];
  678. }
  679. $v->voter = $voter;
  680. }else{
  681. WxChat::where('id', $v->id)->delete();
  682. }
  683. }
  684. if(!_empty_($v->ask_order_id)){
  685. //仅占用
  686. }
  687. if(!_empty_($v->shop_good_id)){
  688. $data = WxShopGoods::where('id', $v->shop_good_id)->first()->toArray();
  689. if($data) {
  690. // 服务
  691. if (isset($data['service_id'])) {
  692. $service_tip = '';
  693. $data['service'] = WxShopService::whereIn('id', json_decode($data['service_id'], true))->get(['name', 'intro'])->map(function ($s) use (&$service_tip){
  694. if(_empty_($service_tip)){
  695. $service_tip .= '"'.$s->name.'"';
  696. }else{
  697. $service_tip .= ',' . '"'.$s->name.'"';
  698. }
  699. return $s;
  700. });
  701. if($service_tip){
  702. $service_tip = '亲,我们这款商品的服务为' . $service_tip . '~';
  703. }
  704. $data['service_tip'] = $service_tip;
  705. if($data['pic'] && is_array($data['pic']) && count($data['pic']) > 0){
  706. $data['pic'][0] = $data['pic'][0].'?imageMogr2/quality/100/format/webp/interlace/0/crop/200x200/gravity/center/thumbnail/200x';
  707. }
  708. } else {
  709. $data['service'] = null;
  710. $data['service_tip'] = '';
  711. }
  712. $data['user_purchase'] = ShopUtils::user_buy_goods_times($uid, $data['id']);
  713. $v->shop_good = $data;
  714. }
  715. }
  716. if(!_empty_($v->contact_apply_id)){
  717. if($v->contact_apply_id && $v->contact_apply_id > 0){
  718. $contact_apply = WxUserContactApply::find($v->contact_apply_id);
  719. if($contact_apply){
  720. if($contact_apply->user_id == $uid){
  721. // 己方发送
  722. $title = '申请查看对方的';
  723. if($contact_apply->is_phone == 1){
  724. $title .= '手机号';
  725. }
  726. if($contact_apply->is_wechat_account == 1){
  727. if($contact_apply->is_phone == 1){
  728. $title .= '、微信号';
  729. }else{
  730. $title .= '微信号';
  731. }
  732. }
  733. $contact_apply->title = $title;
  734. }else{
  735. $title = '我申请查看你的';
  736. if($contact_apply->is_phone == 1){
  737. $title .= '手机号';
  738. }
  739. if($contact_apply->is_wechat_account == 1){
  740. if($contact_apply->is_phone == 1){
  741. $title .= '、微信号';
  742. }else{
  743. $title .= '微信号';
  744. }
  745. }
  746. $contact_apply->title = $title;
  747. }
  748. $contact_apply->status_tip = '申请中';
  749. if($contact_apply->status == 1){
  750. $contact_apply->status_tip = '已同意';
  751. }else if($contact_apply->status == 2){
  752. $contact_apply->status_tip = '已过期';
  753. }
  754. $v->contact_apply = $contact_apply;
  755. }else{
  756. $v->contact_apply = null;
  757. }
  758. }else{
  759. $v->contact_apply = null;
  760. }
  761. }
  762. $allowable[] = [
  763. 'text' => '复制',
  764. 'type' => 'copy',
  765. 'id' => $v->id,
  766. 'raw' => strip_tags($v->chat_content),
  767. 'icon' => 'mini-icon mini-fuzhi'
  768. ];
  769. $v->allowable = $allowable;
  770. return $v;
  771. });
  772. return $this->success($data);
  773. }
  774. /**
  775. * 查询用户问答订单聊天记录
  776. * @param Request $request
  777. * @return \Illuminate\Http\JsonResponse
  778. */
  779. public function getUserAskOrderChat(Request $request, $limit = 6)
  780. {
  781. $uid = $request->uid;
  782. $oid = $request->oid;
  783. $ask_order_id = $request->ask_order_id;
  784. /*if(_empty_($uid) || _empty_($oid)){
  785. return $this->fail(200001);
  786. }
  787. $data = WxChat::where(function($query) use ($uid, $oid) {
  788. $query->where(function ($query) use ($uid, $oid) {
  789. $query->where('user_id', $uid)
  790. ->where('object_id', $oid);
  791. })
  792. ->orWhere(function ($query) use ($uid, $oid) {
  793. $query->where('user_id', $oid)
  794. ->where('object_id', $uid);
  795. });
  796. })*/
  797. $data = WxChat::where('expand_type',9) //只要问答订单的
  798. ->where('expand_id',$ask_order_id) //只要问答订单的
  799. ->orderByRaw('id DESC')
  800. ->simplePaginate($limit);
  801. //问答订单详情
  802. $ask_order = Db::table('ask_order')->where('id',$ask_order_id)->first();
  803. $data->map(function ($v) use ($uid,$ask_order){
  804. //区分用户和答主
  805. $v->ask_order_role = 'user';
  806. if($ask_order){
  807. if($ask_order->user_id == $v->user_id){
  808. $v->ask_order_role = 'user';
  809. }elseif($ask_order->blogger_user_id == $v->user_id){
  810. $v->ask_order_role = 'blogger';
  811. }
  812. }
  813. $v->type = 'user';
  814. $imgList = array();
  815. array_push($imgList, ['img_url' => $v->chat_image]);
  816. $v->imgList = $imgList;
  817. $v->user = WxUser::where('id', $v->user_id)->first(FieldUtils::userInfoColums());
  818. $v->datetime = format_datetime($v->created_at);
  819. if($v->chat_audio_url && $v->chat_audio_length){
  820. $v->mode = 'audio';
  821. }else if($v->chat_image){
  822. $v->mode = 'img';
  823. }else{
  824. $v->mode = 'text';
  825. }
  826. if(!_empty_($v->chat_audio_length)){
  827. $min = (int)($v->chat_audio_length / 60);
  828. if($min < 10){
  829. $min = '0'.$min;
  830. }
  831. $sec = $v->chat_audio_length % 60;
  832. if($sec < 10){
  833. $sec = '0'.$sec;
  834. }
  835. $v->chat_audio_length = $min.':'.$sec;
  836. }
  837. $allowable[] = [
  838. 'text' => '复制',
  839. 'type' => 'copy',
  840. 'id' => $v->id,
  841. 'raw' => strip_tags($v->chat_content),
  842. 'icon' => 'mini-icon mini-fuzhi'
  843. ];
  844. $v->allowable = $allowable;
  845. return $v;
  846. });
  847. return $this->success($data);
  848. }
  849. /**
  850. * 已读对应用户信息
  851. * @param Request $request
  852. * @return \Illuminate\Http\JsonResponse
  853. */
  854. public function readUserChat(Request $request)
  855. {
  856. $uid = $request->uid;
  857. $oid = $request->oid;
  858. if(_empty_($oid)){
  859. return $this->fail(200001);
  860. }
  861. $data = WxChat::where([['user_id','=', $oid],['object_id', '=', $uid],['expand_type', '!=', 9]])->update(['is_read' => 1]);
  862. return $this->success($data);
  863. }
  864. /**
  865. * 已读对应用户咨询信息
  866. * @param Request $request
  867. * @return \Illuminate\Http\JsonResponse
  868. */
  869. public function readAskOrderChat(Request $request)
  870. {
  871. $uid = $request->uid;
  872. $oid = $request->oid;
  873. $ask_order_id = $request->ask_order_id;
  874. if(_empty_($oid) || _empty_($ask_order_id)){
  875. return $this->fail(200001);
  876. }
  877. $data = WxChat::where([['user_id','=', $oid],['object_id', '=', $uid],['expand_type', '=', 9],['expand_id', '=', $ask_order_id]])->update(['is_read' => 1]);
  878. return $this->success($data);
  879. }
  880. /**
  881. * 用户删除聊天记录
  882. */
  883. public function userDelMessage(Request $request)
  884. {
  885. $uid = $request->uid;
  886. $userid = $request->userid;
  887. $data = WxChat::where(function ($query) use ($uid, $userid) {
  888. $query->where('user_id', $uid)
  889. ->where('object_id', $userid);
  890. })
  891. ->orWhere(function ($query) use ($uid, $userid) {
  892. $query->where('user_id', $userid)
  893. ->where('object_id', $uid);
  894. })->update(['chat_state' => 1]);
  895. return $this->success($data);
  896. }
  897. }