UserService.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: hp
  5. * Date: 2017/11/21
  6. * Time: 10:42
  7. */
  8. namespace App\Modules\User\Services;
  9. use App\Consts\QuickConst;
  10. use App\Modules\Book\Models\BookGiftsSend;
  11. use App\Modules\Book\Models\UserShelfBooks;
  12. use App\Modules\Subscribe\Models\BookOrder;
  13. use App\Modules\Subscribe\Models\ChapterOrder;
  14. use App\Modules\Subscribe\Services\ChapterOrderService;
  15. use App\Modules\User\Models\User;
  16. use App\Modules\User\Models\UserEnv;
  17. use DB;
  18. use App\Jobs\ActionTrigger;
  19. use App\Jobs\UserAddDeskJob;
  20. use App\Modules\OfficialAccount\Models\DistributionSelfDefineConfig;
  21. use App\Modules\Channel\Models\Channel;
  22. use App\Modules\Trade\Models\Order;
  23. use App\Modules\User\Models\QappUserAddDestop;
  24. use App\Modules\UserTask\Services\BaseTask;
  25. use App\Modules\UserTask\Services\UserTaskService;
  26. use Redis;
  27. class UserService
  28. {
  29. public static function setUserSendOrder(int $uid, int $send_order_id)
  30. {
  31. if (empty($uid) || empty($send_order_id)) {
  32. return false;
  33. }
  34. Redis::hmset('book_read:' . $uid,'send_order_id',$send_order_id,'soid_time',time());
  35. //return Redis::hset('book_read:' . $uid, 'send_order_id', $send_order_id);
  36. }
  37. public static function getUserSendOrderTime($uid)
  38. {
  39. $send_order_id_time = Redis::hGet('book_read:' . $uid, 'soid_time');
  40. $send_order_id_time = (int)($send_order_id_time);
  41. return $send_order_id_time;
  42. }
  43. public static function getUserSendOrder(int $uid)
  44. {
  45. $send_order_id = Redis::hGet('book_read:' . $uid, 'send_order_id');
  46. $send_order_id = (int)($send_order_id ? $send_order_id : 0);
  47. return $send_order_id;
  48. }
  49. public static function qappAddDesktop(int $uid, int $status)
  50. {
  51. myLog('incrAddDeskTop')->info('qappAddDesktop', compact('uid', 'status'));
  52. $log = QappUserAddDestop::where('uid', $uid)->orderBy('id', 'desc')->first();
  53. if (!$log) {
  54. //第一次加桌 没有任何记录,加桌状态为1
  55. if($status == 1){
  56. $job = new UserAddDeskJob($uid);
  57. dispatch($job)->onConnection('rabbitmq')->onQueue('qapp_user_add_desk')->delay(now()->addMinutes(3));
  58. }
  59. //第一次加桌 没有任何记录,加桌状态为0
  60. if($status == 0){
  61. QappUserAddDestop::create([
  62. 'uid' => $uid,
  63. 'status' => $status,
  64. ]);
  65. }
  66. }else{
  67. //如果有记录,但是都是0 没有1的记录
  68. $oneexists = QappUserAddDestop::where('uid', $uid)->where('status', 1)->exists();
  69. if(!$oneexists && $status == 1){
  70. $job = new UserAddDeskJob($uid);
  71. dispatch($job)->onConnection('rabbitmq')->onQueue('qapp_user_add_desk')->delay(now()->addMinutes(3));
  72. }
  73. //有加桌记录 最近一次加桌状态和和此次状态是否相等
  74. if($log->status != $status){
  75. //不相等 插入记录
  76. QappUserAddDestop::create([
  77. 'uid' => $uid,
  78. 'status' => $status,
  79. ]);
  80. }
  81. //相等 不做处理
  82. return false;
  83. }
  84. // 加桌统计
  85. if (!$log && $status === 1) {
  86. QappAddDeskTopService::incrAddDeskTop($uid, QuickConst::FIELD_ADD_DESKTOP);
  87. UserTaskService::addUserTaskQueue($uid, BaseTask::add_desk, UserTaskService::add_trigger);
  88. }
  89. }
  90. /**
  91. * 创建用户
  92. * $params
  93. * 必穿参数 openid、unionid、distribution_channel_id
  94. * 可传 province、city、country、headimgurl、send_order_id、sex、register_ip
  95. */
  96. static function addUser($params)
  97. {
  98. return User::addUser($params);
  99. }
  100. static function getUserList($limit, $offset)
  101. {
  102. return User::getUserList($limit, $offset);
  103. }
  104. static function getUserByNickAndChannelId($distribution_channel_id, $nickname)
  105. {
  106. return User::getUserByNickAndChannelId($distribution_channel_id, $nickname);
  107. }
  108. /**
  109. * 获取用户信息列表
  110. * @param $pageSize 每页显示的条数
  111. */
  112. static function getPaginationList($pageSize = 20)
  113. {
  114. return User::getPaginationList($pageSize);
  115. }
  116. /**
  117. * 获取用户信息列表
  118. * @param $pageSize 每页显示的条数
  119. */
  120. static function getUsers($pageSize = 20, $careStatus)
  121. {
  122. return User::getPaginationList($pageSize, $careStatus);
  123. }
  124. /**
  125. * 根据id获取用户信息
  126. * @return user object
  127. */
  128. static function getById($id)
  129. {
  130. return User::getById($id);
  131. }
  132. /**
  133. * 根据id获取用户信息
  134. * @return user object
  135. */
  136. static function getUserDataById($id)
  137. {
  138. return User::getUserDataById($id);
  139. }
  140. /**
  141. * 根据id获取用户信息
  142. * @return user object
  143. */
  144. static function getUserDataDetailById($id)
  145. {
  146. return User::getUserDataDetailById($id);
  147. }
  148. /**
  149. * 根据id获取用户名称
  150. * @return string [用户昵称]
  151. */
  152. static function getNicknameById($id)
  153. {
  154. return User::getById($id)->nickname;
  155. }
  156. /**
  157. * 更新用户信息
  158. * @param int $id 用户ID
  159. * @param array $params 可传 province、city、country、headimgurl、sex
  160. * @return boolen
  161. */
  162. static function updateInfo($id, $params)
  163. {
  164. \Log::info('~~~~~~~~~~~~~~~~~====update User====~~~~~~~~~~~~~~~~' . "\n");
  165. \Log::info($id);
  166. \Log::info($params);
  167. return User::updateInfo($id, $params);
  168. }
  169. /**
  170. * 根据union和分销id获取用户信息
  171. * @param $union
  172. * @param $channel_id
  173. * @return mixed
  174. */
  175. static function getUserByUnionAndChannelId($openid, $channel_id)
  176. {
  177. return User::where('openid', $openid)->where('distribution_channel_id', $channel_id)->select('id', 'openid', 'unionid', 'balance', 'charge_balance', 'reward_balance')->first();
  178. }
  179. static function getUserByOpenidAndChannelId($openid, $channel_id)
  180. {
  181. return User::where('openid', $openid)->where('distribution_channel_id', $channel_id)->first();
  182. }
  183. /**
  184. * 用户余额充值
  185. * @param $uid
  186. * @param $fee
  187. * @return mixed
  188. */
  189. static function addBalance($uid, $fee, $charge, $given)
  190. {
  191. return User::addBalance($uid, $fee, $charge, $given);
  192. }
  193. /**
  194. * 查询推广注册用户总数
  195. * @param $send_order_id
  196. * @return mixed
  197. */
  198. static function getPromotionTotal($send_order_id)
  199. {
  200. return User::getPromotionTotal($send_order_id);
  201. }
  202. /**
  203. * 查询渠道某天注册用户总数
  204. * @param $channel_id
  205. * @param $date
  206. * @return mixed
  207. */
  208. static function getChannelDayTotal($channel_id, $date)
  209. {
  210. return User::getChannelDayTotal($channel_id, $date);
  211. }
  212. /**
  213. * 查询渠道注册用户总数
  214. * @param $channel_id
  215. * @return mixed
  216. */
  217. static function getChannelTotal($channel_id)
  218. {
  219. return User::getChannelTotal($channel_id);
  220. }
  221. /**
  222. * 查询渠道某段时间注册用户总数
  223. * @param $channel_id
  224. * @param $startDate
  225. * @param $endDate
  226. * @return mixed
  227. */
  228. static function getChannelDayToDayTotal($channel_id, $startDate = '', $endDate = '')
  229. {
  230. return User::getChannelDayToDayTotal($channel_id, $startDate, $endDate);
  231. }
  232. /**
  233. * 查询渠道某段时间注册用户总数
  234. * @param array $channelIds
  235. * @param $startDate
  236. * @param $endDate
  237. * @return mixed
  238. */
  239. static function getChannelsDayToDayTotal($channelIds, $startDate = '', $endDate = '')
  240. {
  241. return User::getChannelsDayToDayTotal($channelIds, $startDate, $endDate);
  242. }
  243. /**
  244. * 查询注册用户总数
  245. * @param $params
  246. */
  247. static function getTotalCount($params)
  248. {
  249. return User::getTotalCount($params);
  250. }
  251. /**
  252. * 查询渠道是否有登录
  253. * @param $channelId
  254. * @param $start_time
  255. * @param $end_time
  256. * @return int
  257. */
  258. static function judgeUserYesterdayLogin($channelId, $start_time, $end_time)
  259. {
  260. $user_behavior = DB::table('channel_operate_record')
  261. ->where([
  262. ['distribution_channel_id', '=', $channelId],
  263. ['created_at', '>=', $start_time],
  264. ['created_at', '<=', $end_time]
  265. ])
  266. ->first();
  267. if ($user_behavior) return 1;
  268. return 0;
  269. }
  270. /**
  271. * @param $date
  272. * @param $company_id
  273. * @return mixed
  274. */
  275. static function getCompanyDayTotal($date, $company_id)
  276. {
  277. $end_date = date('Y-m-d', strtotime($date) + 86400);
  278. $info = User::leftjoin('distribution_channels', 'distribution_channels.id', '=', 'users.distribution_channel_id')
  279. ->leftjoin('channel_users', 'channel_users.id', '=', 'distribution_channels.channel_user_id')
  280. ->where([
  281. ['users.created_at', '>=', $date],
  282. ['users.created_at', '<', $end_date],
  283. ['channel_users.company_id', '=', $company_id]
  284. ])
  285. ->groupBy('channel_users.company_id')
  286. ->select(DB::raw("count(users.id) as register_sum"))
  287. ->first();
  288. if ($info) return $info->register_sum;
  289. //\Log::info('getCompanyDayTotal error:' . $company_id);
  290. return $info;
  291. }
  292. static function getCompanyTotal($company_id)
  293. {
  294. $info = User::leftjoin('distribution_channels', 'distribution_channels.id', '=', 'users.distribution_channel_id')
  295. ->leftjoin('channel_users', 'channel_users.id', '=', 'distribution_channels.channel_user_id')
  296. ->where('channel_users.company_id', $company_id)
  297. ->groupBy('channel_users.company_id')
  298. ->select(DB::raw("count(users.id) as register_sum"))
  299. ->first();
  300. if ($info) return $info->register_sum;
  301. //\Log::error('getCompanyTotal error:' . $company_id);
  302. return $info;
  303. }
  304. static function transfromBalanceByUser($from_uid, $to_uid)
  305. {
  306. $add_balance_sql = "update users,(select * from users where id =" . $from_uid . ") as u2
  307. set users.balance = users.balance + u2.balance,
  308. users.reward_balance = users.reward_balance +u2.reward_balance,
  309. users.charge_balance = users.charge_balance +u2.charge_balance where users.id =" . $to_uid;
  310. $res = DB::update($add_balance_sql);
  311. return User::updateInfo($from_uid, ['balance' => 0, 'reward_balance' => 0, 'charge_balance' => 0]);
  312. }
  313. // 扔用户一些动作到队列,异步处理一些额外逻辑
  314. static function PushUserActionToQueue($action_type, $distribution_channel_id, $param)
  315. {
  316. try {
  317. // \Log::info('PushUserActionToQueue_param_start:'.$distribution_channel_id.' action_type:'.$action_type. ' param:'.json_encode($param));
  318. // 判断站点是否需要额外逻辑
  319. $distribution_self_define_config = DistributionSelfDefineConfig::getDistributionSelfDefineConfig($distribution_channel_id, 'action_call_ycsd');
  320. if (empty($distribution_self_define_config)) {
  321. // \Log::info('not_action_call_ycsd:'.$distribution_channel_id);
  322. return '';
  323. } else {
  324. \Log::info('PushUserActionToQueue_param:' . $distribution_channel_id . ' action_type:' . $action_type . ' param:' . json_encode($param));
  325. // 如果支付通道已经切换回去,则不推送了
  326. // $pay_merchant_id = env('YCSD_CALL_PAY_MERCHANT_ID');
  327. // 当前默认
  328. $pay_merchant_id = Redis::get('YCSD_CALL_PAY_MERCHANT_ID');
  329. $channel = Channel::getById($distribution_channel_id);
  330. $current_pay_merchant_id = isset($channel->pay_merchant_id) ? $channel->pay_merchant_id : '';
  331. \Log::info('action_call_ycsd:' . $distribution_channel_id . ' $pay_merchant_id:' . $pay_merchant_id . ' $current_pay_merchant_id:' . $current_pay_merchant_id);
  332. if ($current_pay_merchant_id != $pay_merchant_id) {
  333. // 判断订单是否是默认支付,放行,切换期间的bug
  334. if ($action_type == 'CallBackOrder') {
  335. $order = Order::getByTradeNo($distribution_channel_id, $param['order_sn']);
  336. if (isset($order->pay_merchant_id) && $order->pay_merchant_id == $pay_merchant_id) {
  337. \Log::info('action_call_ycsd_old_order_continue:' . $param['order_sn']);
  338. } else {
  339. \Log::info('action_call_ycsd_has_change_pay_return:' . $distribution_channel_id);
  340. return '';
  341. }
  342. } else {
  343. \Log::info('action_call_ycsd_has_change_pay_return:' . $distribution_channel_id);
  344. return '';
  345. }
  346. }
  347. \Log::info('action_call_ycsd:' . $distribution_channel_id);
  348. }
  349. $data = [];
  350. $data['send_time'] = date("Y-m-d H:i:s");
  351. $data['action_type'] = $action_type;
  352. if ($action_type == 'Register') {
  353. $data['openid'] = $param['openid'];
  354. $data['uid'] = $param['uid'];
  355. } elseif ($action_type == 'CreateOrder') {
  356. $data['orderSn'] = $param['order_sn'];
  357. $data['amount'] = $param['amount'];
  358. $data['openid'] = $param['openid'];
  359. $data['uid'] = $param['uid'];
  360. } elseif ($action_type == 'CallBackOrder') {
  361. $data['orderSn'] = $param['order_sn'];
  362. $data['openid'] = $param['openid'];
  363. }
  364. $send_data = array(
  365. 'send_time' => date("Y-m-d H:i:s"),
  366. 'data' => $data
  367. );
  368. \Log::info('PushUserActionToQueue_openid:' . $data['openid'] . ' action_type:' . $action_type);
  369. \Log::info('$send_data');
  370. \Log::info($send_data);
  371. $delay = 0;
  372. $job = (new ActionTrigger($send_data))->onConnection('rabbitmq')->delay($delay)->onQueue('action_trigger_list');
  373. dispatch($job);
  374. } catch (\Exception $e) {
  375. \Log::info('ept:' . $e->getMessage());
  376. }
  377. }
  378. public static function isCpcUser($uid)
  379. {
  380. //openid下所有强关超过三天的uid都无充值,对强关后的uid进行曝光
  381. //openid下有一个强关超过三天的uid,都无充值,对强关后的uid进行曝光
  382. $sql_format = "SELECT u.id,f.subscribe_time,(SELECT id from orders where uid = u.id and `status` = 'PAID' LIMIT 1)as oid FROM users u
  383. JOIN force_subscribe_users f on u.id = f.uid and f.is_subscribed= 1
  384. WHERE u.openid in (SELECT openid from users WHERE id = %s)";
  385. $result = DB::select(sprintf($sql_format, $uid));
  386. if (!$result) return false;
  387. $is_has_force_subscribe_three_days = false;
  388. foreach ($result as $item) {
  389. //有充值
  390. if ($item->oid) return false;
  391. //强关没超过超过三天
  392. //if(time()-strtotime($item->subscribe_time) < 86400*3) return false;
  393. if (time() - strtotime($item->subscribe_time) > 86400 * 3) $is_has_force_subscribe_three_days = true;
  394. }
  395. return $is_has_force_subscribe_three_days;
  396. }
  397. public static function recordUA($ua, $uid)
  398. {
  399. return UserEnv::recordUA($ua, $uid);
  400. }
  401. public static function transfer(int $from, int $to, int $distribution_channel_id)
  402. {
  403. $transfer_record = DB::table('crm_transfer')->where('from_uid', $from)->first();
  404. if ($transfer_record) {
  405. return;
  406. }
  407. $from_user = self::getById($from);
  408. $to_user = self::getById($to);
  409. if (!$from_user) return;
  410. if (!$to_user) return;
  411. //阅读记录迁移***************************************
  412. $record = Redis::hgetall('book_read:' . $from);
  413. $not_uid_key = ['last_read', 'sign_counts', 'sign_info', 'sign_day'];
  414. $data = [];
  415. foreach ($record as $k => $item) {
  416. if (is_numeric($k) || in_array($k, $not_uid_key)) {
  417. $data[$k] = $item;
  418. }
  419. }
  420. //\Log::info('read record is');
  421. //\Log::info($data);
  422. if ($data) Redis::hmset('book_read:' . $to, $data);
  423. //签到记录
  424. /*$user_sign_model = new UserSign();
  425. $user_sign_model->setCurrentTable(date('Ym'));
  426. $sign_record = $user_sign_model->where('uid',$from)->select('price','sign_time','day','created_at')->orderBy('sign_time','desc')->get();
  427. $temp = [];
  428. if($sign_record){
  429. foreach ($sign_record as $item){
  430. $temp[] = [
  431. 'uid'=>$to,
  432. 'price'=>$item->price,
  433. 'day'=>$item->day,
  434. 'sign_time'=>$item->sign_time,
  435. 'created_at'=>$item->created_at,
  436. 'updated_at'=>date('Y-m-d H:i:s'),
  437. ];
  438. }
  439. //\Log::info('user_sign is');
  440. //\Log::info($temp);
  441. DB::table('user_sign'.date('Ym'))->insert($temp);
  442. }*/
  443. //订阅记录(按本)
  444. $book_order = BookOrder::where('uid', $from)->where('bid', '>', 0)->get();
  445. if ($book_order) {
  446. $temp = [];
  447. foreach ($book_order as $book) {
  448. $temp[] = [
  449. 'distribution_channel_id' => $distribution_channel_id,
  450. 'bid' => $book->bid,
  451. 'book_name' => $book->book_name,
  452. 'uid' => $to,
  453. 'u' => $book->u,
  454. 'fee' => 0,
  455. 'created_at' => $book->created_at,
  456. 'updated_at' => date('Y-m-d H:i:s'),
  457. ];
  458. }
  459. //\Log::info('book_order is');
  460. //\Log::info($temp);
  461. DB::table('book_orders')->insert($temp);
  462. }
  463. //订阅记录(按章)
  464. $chapter_order_record = ChapterOrderService::getRecordByUid($from, '', '', true);
  465. if ($chapter_order_record) {
  466. $temp = [];
  467. $i = 1;
  468. $chapter_model = new ChapterOrder();
  469. $chapter_model->setCurrentTable($to);
  470. foreach ($chapter_order_record as $chapter_order) {
  471. $temp[] = [
  472. 'distribution_channel_id' => $distribution_channel_id,
  473. 'bid' => $chapter_order->bid,
  474. 'cid' => $chapter_order->cid,
  475. 'chapter_name' => $chapter_order->chapter_name,
  476. 'book_name' => $chapter_order->book_name,
  477. 'uid' => $to,
  478. 'send_order_id' => 0,
  479. 'fee' => 0,
  480. 'created_at' => $chapter_order->created_at,
  481. 'updated_at' => date('Y-m-d H:i:s')
  482. ];
  483. if ($i % 100 == 0) {
  484. $chapter_model->insert($temp);
  485. $temp = [];
  486. }
  487. $i++;
  488. }
  489. //\Log::info('chapter order is');
  490. //\Log::info($temp);
  491. $chapter_model->insert($temp);
  492. }
  493. //打赏记录
  494. $gift_result = BookGiftsSend::where('uid', $from)->get();
  495. if ($gift_result) {
  496. $tmp = [];
  497. foreach ($gift_result as $g) {
  498. $tmp[] = [
  499. 'uid' => $to,
  500. 'gift_id' => $g->gift_id,
  501. 'bid' => $g->bid,
  502. 'icon' => $g->icon,
  503. 'name_desc' => $g->name_desc,
  504. 'cost' => 0,
  505. 'cost_reward' => $g->cost_reward,
  506. 'cost_recharge' => $g->cost_recharge,
  507. 'created_at' => $g->created_at,
  508. 'updated_at' => date('Y-m-d H:i:s')
  509. ];
  510. }
  511. //\Log::info('book gift is');
  512. //\Log::info($temp);
  513. DB::table('book_gifts_send')->insert($tmp);
  514. }
  515. //书架
  516. $result = UserShelfBooks::where('uid', $from)->get();
  517. if ($result) {
  518. $tmp = [];
  519. foreach ($result as $s) {
  520. $tmp[] = [
  521. 'uid' => $to,
  522. 'distribution_channel_id' => $distribution_channel_id,
  523. 'bid' => $s->bid,
  524. 'created_at' => $s->created_at,
  525. 'updated_at' => date('Y-m-d H:i:s')
  526. ];
  527. }
  528. //\Log::info('user book shelf is');
  529. //\Log::info($temp);
  530. DB::table('user_shelf_books')->insert($tmp);
  531. }
  532. //包年
  533. $result = DB::table('year_orders')->where('uid', $from)->where('end_time', '>=', date('Y-m-d H:i:s'))->first();
  534. if ($result) {
  535. DB::table('year_orders')->insert([
  536. 'uid' => $to,
  537. 'begin_time' => $result->begin_time,
  538. 'end_time' => $result->end_time,
  539. 'distribution_channel_id' => $distribution_channel_id,
  540. 'send_order_id' => $result->send_order_id,
  541. 'fee' => $result->fee,
  542. 'created_at' => date('Y-m-d H:i:s'),
  543. 'updated_at' => $result->updated_at,
  544. ]);
  545. //\Log::info('year_orders is');
  546. //print_r($result);
  547. }
  548. //书币
  549. $to_user->balance += $from_user->balance;
  550. $to_user->reward_balance += $from_user->balance;
  551. $to_user->nickname = $from_user->nickname;
  552. $to_user->sex = $from_user->sex;
  553. $to_user->head_img = $from_user->head_img;
  554. $to_user->country = $from_user->country;
  555. $to_user->city = $from_user->city;
  556. $to_user->province = $from_user->province;
  557. $to_user->save();
  558. DB::table('crm_transfer')->insert([
  559. 'from_uid' => $from,
  560. 'to_uid' => $to,
  561. 'is_enable' => 1,
  562. 'created_at' => date('Y-m-d H:i:s'),
  563. 'updated_at' => date('Y-m-d H:i:s')
  564. ]);
  565. }
  566. public static function getUserByOpenid($openid)
  567. {
  568. return User::where('openid', $openid)->get();
  569. }
  570. }