ForceSubscribeService.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797
  1. <?php
  2. /**
  3. * Created by sublime.
  4. * User: wosinC
  5. * Date: 2017/12/2
  6. * Time: 上午11:39
  7. */
  8. namespace App\Modules\OfficialAccount\Services;
  9. use App\Modules\OfficialAccount\Models\ForceSubscribeUsers;
  10. use App\Modules\OfficialAccount\Models\TempForceSubscribeUsers;
  11. use App\Modules\OfficialAccount\Models\OfficialAccount;
  12. use App\Modules\SendOrder\Services\SendOrderService;
  13. use App\Modules\User\Services\UserService;
  14. use App\Modules\Subscribe\Services\OrderService;
  15. use App\Modules\Subscribe\Services\YearOrderService;
  16. use App\Modules\User\Models\YqMove;
  17. use App\Libs\OSS;
  18. use Redis;
  19. use App\Jobs\SendTemplate;
  20. use App\Jobs\SendStatisticsList;
  21. use GuzzleHttp\Client;
  22. class ForceSubscribeService
  23. {
  24. //-----------强关用户---------------
  25. /**
  26. * 通过appid和openid获取强关用户
  27. */
  28. static function forceSubscribeUsersByAppidAndOpenId($forceSubscribeUsersPrams)
  29. {
  30. \Log::info('forceSubscribeUsersByAppidAndOpenId:'.$forceSubscribeUsersPrams['openid']);
  31. $officialAccount = OfficialAccount::officialAccountByAppid($forceSubscribeUsersPrams['appid']);
  32. if (!empty($officialAccount)) {
  33. $distribution_channel_id = $officialAccount['distribution_channel_id'];
  34. return ForceSubscribeUsers::forceSubscribeUsersByOpenidAndChannelId($forceSubscribeUsersPrams['openid'],$officialAccount['distribution_channel_id']);
  35. }
  36. }
  37. /**
  38. * 通过distribution_channel_id和openid获取素材强关映射关系
  39. */
  40. static function getMaterialForceSubscribeMapping($distribution_channel_id,$openid)
  41. {
  42. $result = array();
  43. $result['uid'] = Redis::hget('book:linksubscribe:openid:'.$openid.':channelid:'.$distribution_channel_id,'uid');
  44. $result['time'] = Redis::hget('book:linksubscribe:openid:'.$openid.':channelid:'.$distribution_channel_id,'time');
  45. \Log::info('key:'.'book:linksubscribe:openid:'.$openid.':channelid:'.$distribution_channel_id);
  46. \Log::info('getMaterialForceSubscribeMapping:distribution_channel_id:'.$distribution_channel_id.' openid:'.$openid.' uid:'.$result['uid'].' time:'.$result['time']);
  47. return $result;
  48. }
  49. /**
  50. * 获取所有强关用户
  51. */
  52. static function forceSubscribeUsersAllOf()
  53. {
  54. return ForceSubscribeUsers::forceSubscribeUsersAllOf();
  55. }
  56. /**
  57. * 修改切换的
  58. */
  59. static function updateSubscribeUserTransfer($distribution_channel_id,$uid,$from_appid,$to_appid,$to_openid)
  60. {
  61. return ForceSubscribeUsers::updateSubscribeUserTransfer($distribution_channel_id,$uid,$from_appid,$to_appid,$to_openid);
  62. }
  63. /**
  64. * 通过uid获取强关用户
  65. */
  66. static function forceSubscribeUsersByUid($forceSubscribeUsersPrams)
  67. {
  68. return ForceSubscribeUsers::forceSubscribeUsersByUid($forceSubscribeUsersPrams['uid']);
  69. }
  70. static function allForceSubscribeUsersByUid($forceSubscribeUsersPrams)
  71. {
  72. return ForceSubscribeUsers::allForceSubscribeUsersByUid($forceSubscribeUsersPrams['uid']);
  73. }
  74. /**
  75. * 根据distribution_channel_id获取强关用户
  76. */
  77. static function forceSubscribeUsersByChannelidAndTimeset($forceSubscribeUsersPrams)
  78. {
  79. return ForceSubscribeUsers::forceSubscribeUsersByChannelidAndTimeset($forceSubscribeUsersPrams['distribution_channel_id'],$forceSubscribeUsersPrams['timeset']);
  80. }
  81. /**
  82. * 获取关注12小时的新用户
  83. */
  84. static function forceSubscribeNewUsersByTimeset($forceSubscribeUsersPrams)
  85. {
  86. return ForceSubscribeUsers::forceSubscribeNewUsersByTimeset($forceSubscribeUsersPrams['distribution_channel_id'],$forceSubscribeUsersPrams['timeset']);
  87. }
  88. /**
  89. * 获取未付费的新关用户24-48小时
  90. */
  91. static function forceSubscribeNewUnpaidUsersByTime($forceSubscribeUsersPrams)
  92. {
  93. return ForceSubscribeUsers::forceSubscribeNewUnpaidUsersByTime($forceSubscribeUsersPrams['distribution_channel_id'],$forceSubscribeUsersPrams['start_time'],$forceSubscribeUsersPrams['end_time']);
  94. }
  95. /**
  96. * 通过uid和appid获取强关用户
  97. */
  98. static function forceSubscribeUsersByUidAndAppidAndChannelId($forceSubscribeUsersPrams)
  99. {
  100. return ForceSubscribeUsers::forceSubscribeUsersByUidAndAppidAndChannelId($forceSubscribeUsersPrams['uid'],$forceSubscribeUsersPrams['appid'],$forceSubscribeUsersPrams['distribution_channel_id']);
  101. }
  102. /**
  103. * 通过openid获取强关用户
  104. */
  105. static function forceSubscribeUsersByOpenid($forceSubscribeUsersPrams)
  106. {
  107. return ForceSubscribeUsers::forceSubscribeUsersByOpenid($forceSubscribeUsersPrams['openid']);
  108. }
  109. /**
  110. * 通过openid获取性别
  111. */
  112. static function getSexByOpenid($distribution_channel_id,$openid)
  113. {
  114. return ForceSubscribeUsers::getSexByOpenid($distribution_channel_id,$openid);
  115. }
  116. /**
  117. * 通过openid获取性别,只根据强关书的性别
  118. */
  119. static function getSimpleSexByOpenid($distribution_channel_id,$openid)
  120. {
  121. return ForceSubscribeUsers::getSimpleSexByOpenid($distribution_channel_id,$openid);
  122. }
  123. /**
  124. * 通过uid获取性别,只根据强关书的性别
  125. */
  126. static function getSimpleSexByUid($uid)
  127. {
  128. return ForceSubscribeUsers::getSimpleSexByUid($uid);
  129. }
  130. /**
  131. * 通过uid获取性别,真正的性别
  132. */
  133. static function getUserRealSexByUid($uid)
  134. {
  135. return ForceSubscribeUsers::getUserRealSexByUid($uid);
  136. }
  137. /**
  138. * 通过uid获取强关用户 包括取关用户
  139. */
  140. static function forceSubscribeUsersByUidIncludeCancel($forceSubscribeUsersPrams){
  141. return ForceSubscribeUsers::forceSubscribeUsersByUidIncludeCancel($forceSubscribeUsersPrams['uid']);
  142. }
  143. /**
  144. * 通过openid,appid,distribution_channel_id获取强关用户
  145. */
  146. static function forceSubscribeUsersByOpenidAndAppidAndChannelId($forceSubscribeUsersPrams)
  147. {
  148. return ForceSubscribeUsers::forceSubscribeUsersByOpenidAndAC($forceSubscribeUsersPrams['openid'],$forceSubscribeUsersPrams['appid'],$forceSubscribeUsersPrams['distribution_channel_id']);
  149. }
  150. /**
  151. * 增加强关用户
  152. */
  153. static function addForceSubscribeUsers($forceSubscribeUsersPrams) {
  154. try {
  155. \Log::info('~~~~~~~~~~~~~~~~~~~addForceSubscribeUsers~~~~~~~~~~~~~~~~~~~~'."\n");
  156. $officialAccount = OfficialAccount::officialAccountByAppid($forceSubscribeUsersPrams['appid']);
  157. if (!empty($officialAccount)) {
  158. # code...
  159. $forceSubscribeUsers = ForceSubscribeUsers::forceSubscribeUsersByOpenidAndAC($forceSubscribeUsersPrams['openid'],$forceSubscribeUsersPrams['appid'],$officialAccount['distribution_channel_id']);
  160. // dd($forceSubscribeUsers);
  161. if(empty($forceSubscribeUsers)) {
  162. // $data = $request->all();
  163. $bid = Redis::hget('force_subscribe_from_bid',$forceSubscribeUsersPrams['appid'].'_'.$forceSubscribeUsersPrams['uid']);
  164. if (empty($bid)) {
  165. # code...
  166. $bid = '0';
  167. }
  168. $sendOrderId = Redis::hget('force_subscribe_from_send_order_id',$forceSubscribeUsersPrams['appid'].'_'.$forceSubscribeUsersPrams['uid']);
  169. if (empty($sendOrderId)) {
  170. # code...
  171. $sendOrderId = '0';
  172. }
  173. if($bid && $sendOrderId){
  174. $send_order_bid = Redis::hget('sendOrderIdToBid',$sendOrderId);
  175. if(!$send_order_bid){
  176. $send_order_info = SendOrderService::getById($sendOrderId);
  177. if($send_order_info){
  178. $send_order_bid = $send_order_info->book_id;
  179. Redis::hset('sendOrderIdToBid',$sendOrderId,$send_order_bid);
  180. }
  181. }
  182. if($send_order_bid && $bid == $send_order_bid){
  183. $key = 'accurateSendOrderSubscribeNum:bid:%s:send_order_id:'.$sendOrderId;
  184. Redis::sadd(sprintf($key,$bid),$forceSubscribeUsersPrams['uid']);
  185. }
  186. }
  187. $data['is_subscribed'] = 1;
  188. $data['subscribe_time'] = date("Y-m-d H:i:s");
  189. $data['last_interactive_time'] = $forceSubscribeUsersPrams['last_interactive_time'];
  190. $data['uid'] = $forceSubscribeUsersPrams['uid'];
  191. $data['appid'] = $forceSubscribeUsersPrams['appid'];
  192. $data['openid'] = $forceSubscribeUsersPrams['openid'];
  193. $data['distribution_channel_id'] = $forceSubscribeUsersPrams['distribution_channel_id'];
  194. $data['bid'] = $bid;
  195. $data['send_order_id'] = $sendOrderId;
  196. $data['official_account_id'] = isset($forceSubscribeUsersPrams['official_account_id'])?$forceSubscribeUsersPrams['official_account_id']:0;
  197. $forceSubscribeUsers = ForceSubscribeUsers::create($data);
  198. //Redis::hset('www.zhuishuyun.com'.'force_subscribe:scene:'.$forceSubscribeUsersPrams['uid'].':'.$forceSubscribeUsersPrams['appid'], 'is_subscribe', '[{is_subscribed:1},{subscribe_time:'.date("Y-m-d H:i:s").'}]');
  199. //在Redis中记录一个appid下每天的强关用户数量
  200. Redis::hincrby('day_appid_fans_nums_appid:add:'.$forceSubscribeUsersPrams['appid'],date("Y-m-d"),1);
  201. Redis::hincrby('day_appid_fans_nums_appid:add:'.$forceSubscribeUsersPrams['appid'],'total',1);
  202. // $user['openid'] = $forceSubscribeUsersPrams['openid'];
  203. // $user['unionid'] = $forceSubscribeUsersPrams['unionid'];
  204. // $user['distribution_channel_id'] = $forceSubscribeUsersPrams['distribution_channel_id'];
  205. $user['province'] = isset($forceSubscribeUsersPrams['province']) ? $forceSubscribeUsersPrams['province'] : '';
  206. $user['nickname'] = isset($forceSubscribeUsersPrams['nick_name']) ? $forceSubscribeUsersPrams['nick_name'] : '';
  207. $user['city'] = isset($forceSubscribeUsersPrams['city']) ? $forceSubscribeUsersPrams['city'] : '';
  208. $user['country'] = isset($forceSubscribeUsersPrams['country']) ? $forceSubscribeUsersPrams['country'] : '';
  209. $user['head_img'] = isset($forceSubscribeUsersPrams['headimgurl']) ? $forceSubscribeUsersPrams['headimgurl'] : '';
  210. $user['sex'] = isset($forceSubscribeUsersPrams['sex']) ? $forceSubscribeUsersPrams['sex'] : '';
  211. $user['id'] = isset($forceSubscribeUsersPrams['uid']) ? $forceSubscribeUsersPrams['uid'] : '';
  212. \Log::info('~~~~~~~~~~~~~~~~~~~addForceSubscribeUsers~~~~~~~~~~~~~~~~~~~~'."\n");
  213. \Log::info($user);
  214. UserService::updateInfo($user['id'],$user);
  215. // UserService::addUser($user);
  216. return 1;
  217. } else {
  218. $forceSubscribeUsers['is_subscribed'] = 1;
  219. $forceSubscribeUsers['subscribe_time'] = date("Y-m-d H:i:s");
  220. $forceSubscribeUsers->save();
  221. //Redis::hset('www.zhuishuyun.com'.'force_subscribe:scene:'.$forceSubscribeUsersPrams['uid'].':'.$forceSubscribeUsersPrams['appid'], 'is_subscribe', '[{is_subscribed:1},{subscribe_time:'.date("Y-m-d H:i:s").'}]');
  222. Redis::hincrby('day_appid_fans_nums_appid:add:'.$forceSubscribeUsersPrams['appid'],date("Y-m-d"),1);
  223. Redis::hincrby('day_appid_fans_nums_appid:add:'.$forceSubscribeUsersPrams['appid'],'total',1);
  224. // $user['openid'] = $forceSubscribeUsersPrams['openid'];
  225. // $user['unionid'] = $forceSubscribeUsersPrams['unionid'];
  226. // $user['distribution_channel_id'] = $forceSubscribeUsersPrams['distribution_channel_id'];
  227. $user['province'] = isset($forceSubscribeUsersPrams['province']) ? $forceSubscribeUsersPrams['province'] : '';
  228. $user['nickname'] = isset($forceSubscribeUsersPrams['nick_name']) ? $forceSubscribeUsersPrams['nick_name'] : '';
  229. $user['city'] = isset($forceSubscribeUsersPrams['city']) ? $forceSubscribeUsersPrams['city'] : '';
  230. $user['country'] = isset($forceSubscribeUsersPrams['country']) ? $forceSubscribeUsersPrams['country'] : '';
  231. $user['head_img'] = isset($forceSubscribeUsersPrams['headimgurl']) ? $forceSubscribeUsersPrams['headimgurl'] : '';
  232. $user['sex'] = isset($forceSubscribeUsersPrams['sex']) ? $forceSubscribeUsersPrams['sex'] : '';
  233. $user['id'] = isset($forceSubscribeUsersPrams['uid']) ? $forceSubscribeUsersPrams['uid'] : '';
  234. \Log::info('~~~~~~~~~~~~~~~~~addForceSubscribeUsers~~~~~~~~~~~~~~~~'."\n");
  235. //\Log::info($user);
  236. UserService::updateInfo($user['id'],$user);
  237. return 1;
  238. }
  239. }
  240. } catch (\Exception $e) {
  241. // \Log($e);
  242. return 0;
  243. }
  244. }
  245. /**
  246. * 更新强关用户uid
  247. */
  248. static function updateSubscribeUsersUid($forceSubscribeUsersPrams) {
  249. try {
  250. $forceSubscribeUsers = ForceSubscribeUsers::getOneForceSubscribeUsersByOpenid($forceSubscribeUsersPrams['openid']);
  251. if(empty($forceSubscribeUsers)) {
  252. return 2;
  253. } else {
  254. \Log::info('updateSubscribeUsersUid,openid'. $forceSubscribeUsersPrams['openid']. ' old_uid:'.$forceSubscribeUsers->uid.' new_uid:'.$forceSubscribeUsersPrams['uid']);
  255. $forceSubscribeUsers['uid'] = $forceSubscribeUsersPrams['uid'];
  256. $forceSubscribeUsers->save();
  257. return 1;
  258. }
  259. } catch (\Exception $e) {
  260. \Log::info($e->getMessage());
  261. return 0;
  262. }
  263. }
  264. /**
  265. * 更新强关用户最后交互时间
  266. */
  267. static function forceSubscribeUsersLastTimeUpdate($forceSubscribeUsersPrams) {
  268. try {
  269. \Log::info('forceSubscribeUsersLastTimeUpdate:'.$forceSubscribeUsersPrams['openid']);
  270. $forceSubscribeUsers = ForceSubscribeUsers::forceSubscribeUsersByOpenidAndAC($forceSubscribeUsersPrams['openid'],$forceSubscribeUsersPrams['appid'],$forceSubscribeUsersPrams['distribution_channel_id']);
  271. if(empty($forceSubscribeUsers)) {
  272. return 2;
  273. } else {
  274. $forceSubscribeUsers['last_interactive_time'] = $forceSubscribeUsersPrams['last_interactive_time'];
  275. $forceSubscribeUsers->save();
  276. return 1;
  277. }
  278. } catch (\Exception $e) {
  279. \Log::info('forceSubscribeUsersLastTimeUpdate_ept:'.$e->getMessage());
  280. return 0;
  281. }
  282. }
  283. /**
  284. * 更新强关用户最后交互时间
  285. */
  286. static function tempForceSubscribeUsersLastTimeUpdate($forceSubscribeUsersPrams) {
  287. try {
  288. \Log::info('tempForceSubscribeUsersLastTimeUpdate:'.$forceSubscribeUsersPrams['openid']);
  289. $forceSubscribeUsers = ForceSubscribeUsers::forceSubscribeUsersByOpenidAndAC($forceSubscribeUsersPrams['openid'],$forceSubscribeUsersPrams['appid'],$forceSubscribeUsersPrams['distribution_channel_id']);
  290. // \Log::info('tempForceSubscribeUsersLastTimeUpdate:'.json_encode($forceSubscribeUsers));
  291. if(empty($forceSubscribeUsers)) {
  292. \Log::info('empty_origin_update_temp_force_subscribe_user:'.$forceSubscribeUsersPrams['openid']);
  293. return 2;
  294. } else {
  295. $tempForceSubscribeUsers = TempForceSubscribeUsers::forceSubscribeUsersByOpenidAndAC($forceSubscribeUsersPrams['openid'],$forceSubscribeUsersPrams['appid'],$forceSubscribeUsersPrams['distribution_channel_id']);
  296. if(!empty($tempForceSubscribeUsers)){
  297. \Log::info('exist_update_temp_force_subscribe_user2:'.$forceSubscribeUsersPrams['openid']);
  298. $tempForceSubscribeUsers->last_interactive_time = $forceSubscribeUsers->last_interactive_time;
  299. $tempForceSubscribeUsers->bid = $forceSubscribeUsers->bid;
  300. $tempForceSubscribeUsers->is_subscribed = $forceSubscribeUsers->is_subscribed;
  301. $tempForceSubscribeUsers->subscribe_time = $forceSubscribeUsers->subscribe_time;
  302. $tempForceSubscribeUsers->unsubscribe_time = $forceSubscribeUsers->unsubscribe_time;
  303. // 跨渠道迁移的bug
  304. $tempForceSubscribeUsers->distribution_channel_id = $forceSubscribeUsers->distribution_channel_id;
  305. $tempForceSubscribeUsers->uid = $forceSubscribeUsers->uid;
  306. // \Log::info('$tempForceSubscribeUsers:'.json_encode($tempForceSubscribeUsers));
  307. $tempForceSubscribeUsers->save();
  308. } else{
  309. $tempForceSubscribeUsers = [
  310. 'uid'=>$forceSubscribeUsers->uid,
  311. 'openid'=>$forceSubscribeUsers->openid,
  312. 'appid'=>$forceSubscribeUsers->appid,
  313. 'bid'=>$forceSubscribeUsers->bid,
  314. 'is_subscribed'=>$forceSubscribeUsers->is_subscribed,
  315. 'subscribe_time'=>$forceSubscribeUsers->subscribe_time,
  316. 'unsubscribe_time'=>$forceSubscribeUsers->unsubscribe_time,
  317. 'distribution_channel_id'=>$forceSubscribeUsers->distribution_channel_id,
  318. 'last_interactive_time'=>$forceSubscribeUsersPrams['last_interactive_time'],
  319. ];
  320. \Log::info('not_exist_create_temp_force_subscribe_user:'.$forceSubscribeUsersPrams['openid']);
  321. TempForceSubscribeUsers::firstOrCreate($tempForceSubscribeUsers);
  322. }
  323. return 1;
  324. }
  325. } catch (\Exception $e) {
  326. \Log::info('tempForceSubscribeUsersLastTimeUpdate_ept:'.$e->getMessage());
  327. return 0;
  328. }
  329. }
  330. static function getOfficalAccountNickName($uid)
  331. {
  332. return ForceSubscribeUsers::getOfficalAccountNickName($uid);
  333. }
  334. /**
  335. * 强关用户取关
  336. */
  337. static function cancelForceSubscribeUsers($forceSubscribeUsersPrams) {
  338. try {
  339. // $forceSubscribeUsers = ForceSubscribeUsers::forceSubscribeUsersByOpenid($forceSubscribeUsersPrams['openid']);
  340. // if(empty($forceSubscribeUsers)) {
  341. // return 2;
  342. // } else {
  343. // # code...
  344. // $forceSubscribeUsers['is_subscribed'] = 0;
  345. // $forceSubscribeUsers['unsubscribe_time'] = date("Y-m-d H:i:s");
  346. // $forceSubscribeUsers->save();
  347. // Redis::hset('www.zhuishuyun.com'.'force_subscribe:scene:'.$forceSubscribeUsers['uid'].':'.$forceSubscribeUsersPrams['appid'], 'is_subscribe', '[{is_subscribed:0},{unsubscribe_time:'.date("Y-m-d H:i:s").'}]');
  348. // return 1;
  349. // }
  350. $forceSubscribeUsers = ForceSubscribeUsers::forceAllSubscribeUsersByOpenid($forceSubscribeUsersPrams['openid']);
  351. if(count($forceSubscribeUsers)>0) {
  352. for ($i=0; $i < count($forceSubscribeUsers); $i++) {
  353. # code...
  354. $cancelforceSubscribeUsers = $forceSubscribeUsers[$i];
  355. $cancelforceSubscribeUsers['is_subscribed'] = 0;
  356. $cancelforceSubscribeUsers['unsubscribe_time'] = date("Y-m-d H:i:s");
  357. $cancelforceSubscribeUsers->save();
  358. //Redis::hset('www.zhuishuyun.com'.'force_subscribe:scene:'.$cancelforceSubscribeUsers['uid'].':'.$forceSubscribeUsersPrams['appid'], 'is_subscribe', '[{is_subscribed:0},{unsubscribe_time:'.date("Y-m-d H:i:s").'}]');
  359. Redis::hincrby('day_appid_fans_nums_appid:cancel:'.$forceSubscribeUsersPrams['appid'],date("Y-m-d"),1);
  360. Redis::hincrby('day_appid_fans_nums_appid:cancel:'.$forceSubscribeUsersPrams['appid'],'total',1);
  361. $theCancelForceSubscribeUserArray = $cancelforceSubscribeUsers->toArray();
  362. $send_data=array(
  363. 'type'=>'unsubscribe_user',
  364. 'data' => $theCancelForceSubscribeUserArray
  365. );
  366. $delay = 0;
  367. $job = (new SendStatisticsList($send_data))->onConnection('rabbitmq')->delay($delay)->onQueue('send_statistics_list');
  368. dispatch($job);
  369. }
  370. return 1;
  371. } else {
  372. return 2;
  373. }
  374. } catch (\Exception $e) {
  375. // \Log($e);
  376. return 0;
  377. }
  378. }
  379. /**
  380. * 强制关注
  381. */
  382. static function subscribeForceSubscribeUsers($forceSubscribeUsersPrams) {
  383. try {
  384. $forceSubscribeUsers = ForceSubscribeUsers::forceAllUnSubscribeUsersByOpenid($forceSubscribeUsersPrams['openid']);
  385. // \Log::info($forceSubscribeUsers);
  386. if(count($forceSubscribeUsers)>0) {
  387. // \Log::info(count($forceSubscribeUsers));
  388. for ($i=0; $i < count($forceSubscribeUsers); $i++) {
  389. # code...
  390. // \Log::info($forceSubscribeUsers[$i]['is_subscribed']);
  391. // \Log::info($forceSubscribeUsers[$i]['subscribe_time']);
  392. $forceSubscribeUsers[$i]['is_subscribed'] = 1;
  393. $forceSubscribeUsers[$i]['subscribe_time'] = date("Y-m-d H:i:s");
  394. $forceSubscribeUsers[$i]['last_interactive_time'] = date("Y-m-d H:i:s");
  395. $forceSubscribeUsers[$i]->save();
  396. Redis::hincrby('day_appid_fans_nums_appid:add:'.$forceSubscribeUsersPrams['appid'],date("Y-m-d"),1);
  397. Redis::hincrby('day_appid_fans_nums_appid:add:'.$forceSubscribeUsersPrams['appid'],'total',1);
  398. //Redis::hset('www.zhuishuyun.com'.'force_subscribe:scene:'.$forceSubscribeUsers[$i]['uid'].':'.$forceSubscribeUsersPrams['appid'], 'is_subscribe', '[{is_subscribed:1},{subscribe_time:'.date("Y-m-d H:i:s").'}]');
  399. }
  400. return 1;
  401. } else {
  402. return 2;
  403. }
  404. } catch (\Exception $e) {
  405. // \Log($e);
  406. return 0;
  407. }
  408. }
  409. /**
  410. * temp表强制关注
  411. */
  412. static function tempSubscribeForceSubscribeUsers($forceSubscribeUsersPrams) {
  413. try {
  414. \Log::info('tempSubscribeForceSubscribeUsers2:'.$forceSubscribeUsersPrams['openid']);
  415. $forceSubscribeUsers = TempForceSubscribeUsers::forceAllUnSubscribeUsersByOpenid($forceSubscribeUsersPrams['openid']);
  416. if(count($forceSubscribeUsers)>0) {
  417. for ($i=0; $i < count($forceSubscribeUsers); $i++) {
  418. $forceSubscribeUsers[$i]['is_subscribed'] = 1;
  419. $forceSubscribeUsers[$i]['subscribe_time'] = date("Y-m-d H:i:s");
  420. $forceSubscribeUsers[$i]['last_interactive_time'] = date("Y-m-d H:i:s");
  421. $forceSubscribeUsers[$i]->save();
  422. }
  423. return 1;
  424. } else {
  425. return 2;
  426. }
  427. } catch (\Exception $e) {
  428. return 0;
  429. }
  430. }
  431. //获取推广带来的净关粉丝总数
  432. static function getFansNum($send_order_id)
  433. {
  434. return ForceSubscribeUsers::getFansNum($send_order_id);
  435. }
  436. //获取推广带来的新关粉丝总数
  437. static function getNewFansNum($send_order_id)
  438. {
  439. return ForceSubscribeUsers::getNewFansNum($send_order_id);
  440. }
  441. //根据模板消息传的各项条件检索用户
  442. static function forceUserCountByTemplatePrams($appids,$distribution_channel_id,$subscribe_time,$sex,$balance,$category_id,$order_type,$skip){
  443. $forceSubscribes = ForceSubscribeUsers::forceUserCountByTemplatePrams($appids,$distribution_channel_id,$subscribe_time,$sex,$balance,$category_id,$order_type,$skip);
  444. return $forceSubscribes;
  445. }
  446. //根据客服消息传的各项条件检索用户
  447. static function forceUserCountByCustomPrams($appids,$distribution_channel_id,$subscribe_time,$sex,$balance,$category_id,$order_type,$sign_time,$skip){
  448. $forceSubscribes = ForceSubscribeUsers::forceUserCountByCustomPrams($appids,$distribution_channel_id,$subscribe_time,$sex,$balance,$category_id,$order_type,$sign_time,$skip);
  449. return $forceSubscribes;
  450. }
  451. //根据批量微信素材客服消息传的各项条件检索用户
  452. static function forceUserCountByBatchWechatCustomPrams($appids,$distribution_channel_id,$subscribe_time,$sex,$balance,$category_id,$order_type,$sign_time,$interaction_time,$skip){
  453. $forceSubscribes = ForceSubscribeUsers::forceUserCountByBatchWechatCustomPrams($appids,$distribution_channel_id,$subscribe_time,$sex,$balance,$category_id,$order_type,$sign_time,$interaction_time,$skip);
  454. return $forceSubscribes;
  455. }
  456. // 指定用户的基础信息获取
  457. static function simpleForceUserCountByPrams($uids, $param,$skip){
  458. $forceSubscribes = ForceSubscribeUsers::simpleForceUserCountByPrams($uids, $param,$skip);
  459. return $forceSubscribes;
  460. }
  461. // 根据渠道号和日期获取强关用户数量
  462. /**
  463. * startTime endTime 如果两个参数都传会查询这两个时间段内的的强关用户数量
  464. * startTime endTime 如果只传一个,则会查询当天的强关用户数量,传哪个都可以
  465. * startTime endTime 如果都不传, 则会获取该渠道下的所有强关用户数量
  466. */
  467. static function forceSubscribeUserCountByChannelIdAndDate($distribution_channel_id,$startTime,$endTime){
  468. return ForceSubscribeUsers::forceSubscribeUserCountByChannelIdAndDate($distribution_channel_id,$startTime,$endTime);
  469. }
  470. /**
  471. * 获取全服务号粉丝
  472. */
  473. static function getFullOfficialAccountUsers($appid,$next_openid){
  474. // \Log::info('getFullOfficialAccountUsers_start,appid:'.$appid.' next_openid:'.$next_openid);
  475. $result = array();
  476. try {
  477. $timestamp = time();
  478. $params = array("next_openid"=>$next_openid,'gzh_app_id'=>$appid,"timestamp"=>$timestamp);
  479. $sign = get_sign($params);
  480. $res = self::getUserClient()->request("GET","get_full_official_account_users",
  481. ['query'=>['next_openid'=>$next_openid,'gzh_app_id'=>$appid,'timestamp'=>$timestamp,'sign'=>$sign],'connect_timeout' => 10]
  482. )->getBody()->getContents();
  483. // \Log::info($res);
  484. $res = object_to_array(json_decode($res));
  485. // 组装格式,方便后面统一处理
  486. $openids= isset($res['data']['data']['openid'])?$res['data']['data']['openid']:array();
  487. $result['openids'] = array();
  488. if(!empty($openids)){
  489. foreach($openids as $key=> $openid){
  490. $result['openids'][$key]['openid'] = $openid;
  491. }
  492. }
  493. $result['next_openid'] = isset($res['data']['next_openid'])?$res['data']['next_openid']:'';
  494. $result['count'] = isset($res['data']['count'])?$res['data']['count']:0;
  495. $result['total'] = isset($res['data']['total'])?$res['data']['total']:0;
  496. //\Log::info('getFullOfficialAccountUsers_end,appid:'.$appid.' next_openid:'.$result['next_openid'].' count:'.$result['count'].' total:'.$result['total'].' num:'.count($result['openids']));
  497. } catch (\Exception $e) {
  498. \Log::info($e);
  499. }
  500. return $result;
  501. }
  502. /**
  503. * 获取单个粉丝信息
  504. */
  505. static function getUserInfo($appid,$openid){
  506. \Log::info('getUserInfo_start,appid:'.$appid.' openid:'.$openid);
  507. $result = array();
  508. try {
  509. $timestamp = time();
  510. $params = array("openid"=>$openid,'gzh_app_id'=>$appid,"timestamp"=>$timestamp);
  511. $sign = get_sign($params);
  512. $res = self::getUserClient()->request("GET","get_userinfo",
  513. ['query'=>['openid'=>$openid,'gzh_app_id'=>$appid,'timestamp'=>$timestamp,'sign'=>$sign],'connect_timeout' => 10]
  514. )->getBody()->getContents();
  515. $res = object_to_array(json_decode($res));
  516. $result['nickname'] = isset($res['data']['nickname'])?$res['data']['nickname']:0;
  517. \Log::info('getUserInfo_end,appid:'.$appid.' openid:'.$openid.' nickname:'.$result['nickname']);
  518. } catch (\Exception $e) {
  519. \Log::info('getUserInfo_ept:'.$e->getMessage());
  520. }
  521. return $result;
  522. }
  523. static function getUserInfoAll($appid,$openid){
  524. \Log::info('getUserInfo_start,appid:'.$appid.' openid:'.$openid);
  525. $result = array();
  526. try {
  527. $timestamp = time();
  528. $params = array("openid"=>$openid,'gzh_app_id'=>$appid,"timestamp"=>$timestamp);
  529. $sign = get_sign($params);
  530. $res = self::getUserClient()->request("GET","get_userinfo",
  531. ['query'=>['openid'=>$openid,'gzh_app_id'=>$appid,'timestamp'=>$timestamp,'sign'=>$sign],'connect_timeout' => 10]
  532. )->getBody()->getContents();
  533. $res = object_to_array(json_decode($res));
  534. if(isset($res['data']) && !empty($res['data'])){
  535. return $res['data'];
  536. }
  537. } catch (\Exception $e) {
  538. \Log::info('getUserInfo_ept:'.$e->getMessage());
  539. }
  540. return $result;
  541. }
  542. /**
  543. * 占位符替换
  544. * @param unknown_type $content
  545. * @param unknown_type $type
  546. * @return string
  547. */
  548. static public function change_placeholder($content,$params){
  549. \Log::info('change_placeholder_before:'.$content);
  550. $wx_name = isset($params['nickname'])?$params['nickname']:'';
  551. $content = str_replace('{wx_name}',$wx_name,$content);
  552. \Log::info('change_placeholder_end:'.$content);
  553. return $content;
  554. }
  555. static public function getUserClient(){
  556. return new Client(['base_uri' => env('MEDIA_API_BASE_URI')]);
  557. }
  558. /**
  559. * 获取派单的枪管用户
  560. * @param int $send_order_id
  561. * @param int $distribution_channel_id
  562. * @return mixed
  563. */
  564. static public function getUidByParam(int $send_order_id,int $distribution_channel_id){
  565. return ForceSubscribeUsers::where('send_order_id',$send_order_id)->where('distribution_channel_id',$distribution_channel_id)->select('uid')->limit(100)->get();
  566. }
  567. /**
  568. * @param $distribution_channel
  569. * 获取老用户关注数
  570. */
  571. public static function getOldUserNewSubsribeNum($params){
  572. return ForceSubscribeUsers::getOldUserNewSubsribeNum($params);
  573. }
  574. /**
  575. * 更新公众号用户有效交互时间
  576. */
  577. static function updateGzhUserCustomActive($params)
  578. {
  579. //更新temp_force_subscribe_users
  580. $openid = $params['openid'];
  581. $appid = $params['appid'];
  582. $distribution_channel_id = $params['distribution_channel_id'];
  583. $is_subscribed = 1;
  584. $last_interactive_time = date('Y-m-d H:i:s');
  585. $force_user = $params['force_user'];
  586. $uid = $force_user ? $force_user->uid : 0;
  587. $subscribe_time = $force_user ? $force_user->subscribe_time : $last_interactive_time;
  588. $temp_user = TempForceSubscribeUsers::forceSubscribeUsersByOpenidAndAC($openid, $appid, $distribution_channel_id);
  589. if($temp_user)
  590. {
  591. $temp_user->last_interactive_time = $last_interactive_time;
  592. $temp_user->save();
  593. }else{
  594. $insert_data = compact('appid','openid','distribution_channel_id','is_subscribed','subscribe_time','last_interactive_time');
  595. $uid && $insert_data['uid'] = $uid;
  596. TempForceSubscribeUsers::create($insert_data);
  597. //推到获取昵称队列
  598. $job = (new \App\Jobs\ForceUserProperty(compact('appid','openid')))->onConnection('rabbitmq')->delay(0)->onQueue('force_user_property');
  599. dispatch($job);
  600. }
  601. //更新force_subscribe_users
  602. if($force_user)
  603. {
  604. $force_user->last_interactive_time = $last_interactive_time;
  605. $force_user->save();
  606. }
  607. }
  608. }