InfoHandler.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577
  1. <?php
  2. namespace App\Module\AppGame\Handler\Promotion;
  3. use App\Module\AppGame\Handler\BaseHandler;
  4. use App\Module\UrsPromotion\Services\UrsUserMappingService;
  5. use App\Module\UrsPromotion\Services\UrsReferralService;
  6. use App\Module\UrsPromotion\Services\UrsTalentService;
  7. use App\Module\User\Services\UserActivityService;
  8. use App\Module\Fund\Enums\FUND_TYPE;
  9. use App\Module\Game\Enums\REWARD_SOURCE_TYPE;
  10. use App\Module\Game\Models\GameRewardLog;
  11. use App\Module\Fund\Models\FundLogModel;
  12. use App\Module\GameItems\Models\ItemTransactionLog;
  13. use Google\Protobuf\Internal\Message;
  14. use Illuminate\Support\Facades\Log;
  15. use Illuminate\Support\Facades\DB;
  16. use Uraus\Kku\Request\RequestPromotionInfo;
  17. use Uraus\Kku\Response\ResponsePromotionInfo;
  18. use Uraus\Kku\Common\Reward;
  19. use Uraus\Kku\Common\RewardCoin;
  20. use Uraus\Kku\Common\RewardItem;
  21. use Carbon\Carbon;
  22. /**
  23. * 处理推广团队信息请求
  24. *
  25. * 获取用户的推广团队统计信息,包括:
  26. * - 总人数、直推人数、间推人数
  27. * - 今日新增统计
  28. * - 团队活跃人数统计
  29. * - 达人等级信息
  30. */
  31. class InfoHandler extends BaseHandler
  32. {
  33. /**
  34. * 是否需要登录
  35. * @var bool
  36. */
  37. protected bool $need_login = true;
  38. /**
  39. * 处理推广团队信息请求
  40. *
  41. * @param RequestPromotionInfo $data 推广团队信息请求数据
  42. * @return ResponsePromotionInfo 推广团队信息响应
  43. */
  44. public function handle(Message $data): Message
  45. {
  46. // 创建响应对象
  47. $response = new ResponsePromotionInfo();
  48. try {
  49. // 更新用户活动时间
  50. $this->updateUserActivityTime();
  51. // 获取当前农场用户对应的URS用户ID
  52. $ursUserId = UrsUserMappingService::getUrsUserId($this->user_id);
  53. if (!$ursUserId) {
  54. // 用户未进入URS推广系统,返回空数据
  55. Log::info('用户未进入URS推广系统', [
  56. 'user_id' => $this->user_id
  57. ]);
  58. return $this->setEmptyResponse($response);
  59. }
  60. // 获取推广关系统计
  61. $referralStats = UrsReferralService::getReferralStats($ursUserId);
  62. // 获取今日统计数据
  63. $todayStats = $this->getTodayStats($ursUserId);
  64. // 获取活跃用户统计
  65. $activeStats = $this->getActiveStats($ursUserId);
  66. // 获取收益统计
  67. $rewardStats = $this->getRewardStats($ursUserId);
  68. // 获取达人等级信息
  69. $talentInfo = UrsTalentService::getTalentInfo($ursUserId);
  70. $starLevel = $talentInfo ? $talentInfo->talentLevel : 0;
  71. // 设置响应数据
  72. $response->setTotalCount($referralStats['total_team_count'] ?? 0);
  73. $response->setDirectCount($referralStats['direct_count'] ?? 0);
  74. $response->setIndirectCount($referralStats['indirect_count'] ?? 0);
  75. $response->setDayRecentCount($todayStats['team_new_count'] ?? 0);
  76. $response->setDayDirectCount($todayStats['direct_new_count'] ?? 0);
  77. $response->setActiveCount($activeStats['team_active_count'] ?? 0);
  78. $response->setDirectActiveCount($activeStats['direct_active_count'] ?? 0);
  79. $response->setStarLevel($starLevel);
  80. // 设置收益数据 - 始终设置奖励字段,没有数据时使用空奖励对象
  81. $todayReward = $rewardStats['today_reward'] ?? $this->createEmptyReward();
  82. $totalReward = $rewardStats['total_reward'] ?? $this->createEmptyReward();
  83. $response->setTodayReward($todayReward);
  84. $response->setTotalReward($totalReward);
  85. Log::info('推广团队信息获取成功', [
  86. 'user_id' => $this->user_id,
  87. 'urs_user_id' => $ursUserId,
  88. 'total_count' => $referralStats['total_team_count'] ?? 0,
  89. 'direct_count' => $referralStats['direct_count'] ?? 0
  90. ]);
  91. } catch (\Exception $e) {
  92. Log::error('获取推广团队信息失败', [
  93. 'user_id' => $this->user_id,
  94. 'error' => $e->getMessage(),
  95. 'trace' => $e->getTraceAsString()
  96. ]);
  97. // 发生错误时返回空数据
  98. return $this->setEmptyResponse($response);
  99. }
  100. return $response;
  101. }
  102. /**
  103. * 设置空响应数据
  104. *
  105. * @param ResponsePromotionInfo $response
  106. * @return ResponsePromotionInfo
  107. */
  108. private function setEmptyResponse(ResponsePromotionInfo $response): ResponsePromotionInfo
  109. {
  110. $response->setTotalCount(0);
  111. $response->setDirectCount(0);
  112. $response->setIndirectCount(0);
  113. $response->setDayRecentCount(0);
  114. $response->setDayDirectCount(0);
  115. $response->setActiveCount(0);
  116. $response->setDirectActiveCount(0);
  117. // 设置空的奖励对象
  118. $emptyReward = $this->createEmptyReward();
  119. $response->setTodayReward($emptyReward);
  120. $response->setTotalReward($emptyReward);
  121. return $response;
  122. }
  123. /**
  124. * 创建空的奖励对象
  125. *
  126. * @return Reward
  127. */
  128. private function createEmptyReward(): Reward
  129. {
  130. $reward = new Reward();
  131. // 设置空的奖励列表
  132. $reward->setItems([]);
  133. $reward->setCoins([]);
  134. $reward->setGods([]);
  135. $reward->setLands([]);
  136. $reward->setPets([]);
  137. $reward->setPetPowers([]);
  138. $reward->setSkins([]);
  139. return $reward;
  140. }
  141. /**
  142. * 获取今日统计数据
  143. *
  144. * @param int $ursUserId URS用户ID
  145. * @return array
  146. */
  147. private function getTodayStats(int $ursUserId): array
  148. {
  149. try {
  150. $teamMembers = UrsReferralService::getTeamMembers($ursUserId);
  151. $directNewCount = 0;
  152. $teamNewCount = 0;
  153. // 统计今日新增的直推用户
  154. if (!empty($teamMembers[1])) {
  155. foreach ($teamMembers[1] as $directMember) {
  156. $farmUserId = UrsUserMappingService::getFarmUserId($directMember);
  157. if ($farmUserId) {
  158. // 检查用户映射创建时间是否为今日
  159. $mapping = UrsUserMappingService::getMappingDetail($directMember);
  160. if ($mapping && $mapping->mappingTime &&
  161. Carbon::parse($mapping->mappingTime)->isToday()) {
  162. $directNewCount++;
  163. $teamNewCount++;
  164. }
  165. }
  166. }
  167. }
  168. // 统计今日新增的间推和三推用户
  169. foreach ([2, 3] as $level) {
  170. if (!empty($teamMembers[$level])) {
  171. foreach ($teamMembers[$level] as $member) {
  172. $farmUserId = UrsUserMappingService::getFarmUserId($member);
  173. if ($farmUserId) {
  174. $mapping = UrsUserMappingService::getMappingDetail($member);
  175. if ($mapping && $mapping->mappingTime &&
  176. Carbon::parse($mapping->mappingTime)->isToday()) {
  177. $teamNewCount++;
  178. }
  179. }
  180. }
  181. }
  182. }
  183. return [
  184. 'direct_new_count' => $directNewCount,
  185. 'team_new_count' => $teamNewCount
  186. ];
  187. } catch (\Exception $e) {
  188. Log::error('获取今日统计数据失败', [
  189. 'urs_user_id' => $ursUserId,
  190. 'error' => $e->getMessage()
  191. ]);
  192. return [
  193. 'direct_new_count' => 0,
  194. 'team_new_count' => 0
  195. ];
  196. }
  197. }
  198. /**
  199. * 获取活跃用户统计
  200. *
  201. * @param int $ursUserId URS用户ID
  202. * @return array
  203. */
  204. private function getActiveStats(int $ursUserId): array
  205. {
  206. try {
  207. $teamMembers = UrsReferralService::getTeamMembers($ursUserId);
  208. $activeThreshold = Carbon::now()->subHours(24); // 24小时内活跃
  209. $directActiveCount = 0;
  210. $teamActiveCount = 0;
  211. // 统计直推活跃用户
  212. if (!empty($teamMembers[1])) {
  213. foreach ($teamMembers[1] as $directMember) {
  214. $farmUserId = UrsUserMappingService::getFarmUserId($directMember);
  215. if ($farmUserId) {
  216. $lastActivity = UserActivityService::getLastActivityTime($farmUserId);
  217. if ($lastActivity && $lastActivity->gt($activeThreshold)) {
  218. $directActiveCount++;
  219. $teamActiveCount++;
  220. }
  221. }
  222. }
  223. }
  224. // 统计间推和三推活跃用户
  225. foreach ([2, 3] as $level) {
  226. if (!empty($teamMembers[$level])) {
  227. foreach ($teamMembers[$level] as $member) {
  228. $farmUserId = UrsUserMappingService::getFarmUserId($member);
  229. if ($farmUserId) {
  230. $lastActivity = UserActivityService::getLastActivityTime($farmUserId);
  231. if ($lastActivity && $lastActivity->gt($activeThreshold)) {
  232. $teamActiveCount++;
  233. }
  234. }
  235. }
  236. }
  237. }
  238. return [
  239. 'direct_active_count' => $directActiveCount,
  240. 'team_active_count' => $teamActiveCount
  241. ];
  242. } catch (\Exception $e) {
  243. Log::error('获取活跃用户统计失败', [
  244. 'urs_user_id' => $ursUserId,
  245. 'error' => $e->getMessage()
  246. ]);
  247. return [
  248. 'direct_active_count' => 0,
  249. 'team_active_count' => 0
  250. ];
  251. }
  252. }
  253. /**
  254. * 获取收益统计
  255. *
  256. * @param int $ursUserId URS用户ID
  257. * @return array
  258. */
  259. private function getRewardStats(int $ursUserId): array
  260. {
  261. try {
  262. // 获取对应的农场用户ID
  263. $farmUserId = UrsUserMappingService::getFarmUserId($ursUserId);
  264. if (!$farmUserId) {
  265. Log::info('URS用户未映射到农场用户', ['urs_user_id' => $ursUserId]);
  266. return [
  267. 'today_reward' => null,
  268. 'total_reward' => null
  269. ];
  270. }
  271. // 获取今日收益统计
  272. $today = Carbon::today()->format('Y-m-d');
  273. $tomorrow = Carbon::tomorrow()->format('Y-m-d');
  274. $todayStats = $this->getRewardStatsFromLogs($farmUserId, $today, $tomorrow);
  275. // 获取总收益统计
  276. $totalStats = $this->getRewardStatsFromLogs($farmUserId);
  277. // 构建今日收益Reward对象
  278. $todayReward = null;
  279. if ($todayStats['total_count'] > 0) {
  280. $todayReward = $this->buildRewardFromStats($todayStats);
  281. }
  282. // 构建总收益Reward对象
  283. $totalReward = null;
  284. if ($totalStats['total_count'] > 0) {
  285. $totalReward = $this->buildRewardFromStats($totalStats);
  286. }
  287. return [
  288. 'today_reward' => $todayReward,
  289. 'total_reward' => $totalReward
  290. ];
  291. } catch (\Exception $e) {
  292. Log::error('获取收益统计失败', [
  293. 'urs_user_id' => $ursUserId,
  294. 'error' => $e->getMessage()
  295. ]);
  296. return [
  297. 'today_reward' => null,
  298. 'total_reward' => null
  299. ];
  300. }
  301. }
  302. /**
  303. * 从物品模块和资金模块的日志中获取收益统计
  304. *
  305. * @param int $farmUserId 农场用户ID
  306. * @param string|null $startDate 开始日期
  307. * @param string|null $endDate 结束日期
  308. * @return array
  309. */
  310. private function getRewardStatsFromLogs(int $farmUserId, ?string $startDate = null, ?string $endDate = null): array
  311. {
  312. $stats = [
  313. 'total_amount' => 0,
  314. 'total_count' => 0,
  315. 'items' => [], // 物品奖励列表
  316. 'coins' => [], // 代币奖励列表
  317. 'by_source_type' => []
  318. ];
  319. try {
  320. // URS推广相关的收益来源类型
  321. $ursPromotionSourceTypes = [
  322. REWARD_SOURCE_TYPE::URSPROMOTION_HAVEST->value,
  323. REWARD_SOURCE_TYPE::URSPROMOTION_BACKFILL->value,
  324. REWARD_SOURCE_TYPE::URSPROMOTION_REWARD->value,
  325. REWARD_SOURCE_TYPE::URSPROMOTION_REGISTER->value,
  326. REWARD_SOURCE_TYPE::URSPROMOTION_LEVEL->value,
  327. ];
  328. // 1. 从奖励日志表中统计物品奖励
  329. $rewardQuery = GameRewardLog::where('user_id', $farmUserId)
  330. ->whereIn('source_type', $ursPromotionSourceTypes);
  331. if ($startDate) {
  332. $rewardQuery->where('created_at', '>=', $startDate);
  333. }
  334. if ($endDate) {
  335. $rewardQuery->where('created_at', '<=', $endDate);
  336. }
  337. $rewardLogs = $rewardQuery->get();
  338. foreach ($rewardLogs as $log) {
  339. $stats['total_count']++;
  340. // 解析奖励物品
  341. $rewardItems = is_array($log->reward_items) ? $log->reward_items : (json_decode($log->reward_items, true) ?? []);
  342. foreach ($rewardItems as $item) {
  343. $itemId = $item['target_id'] ?? 0;
  344. $quantity = $item['quantity'] ?? 1;
  345. if ($itemId > 0) {
  346. // 累加相同物品的数量
  347. if (isset($stats['items'][$itemId])) {
  348. $stats['items'][$itemId] += $quantity;
  349. } else {
  350. $stats['items'][$itemId] = $quantity;
  351. }
  352. }
  353. }
  354. // 按来源类型统计
  355. $sourceType = $log->source_type;
  356. if (!isset($stats['by_source_type'][$sourceType])) {
  357. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  358. }
  359. $stats['by_source_type'][$sourceType]['count']++;
  360. }
  361. // 1.1. 从物品交易日志表中统计URS推广奖励(补充查询)
  362. $itemQuery = \App\Module\GameItems\Models\ItemTransactionLog::where('user_id', $farmUserId)
  363. ->where('transaction_type', 1) // 收入类型
  364. ->whereIn('source_type', $ursPromotionSourceTypes);
  365. if ($startDate) {
  366. $itemQuery->where('created_at', '>=', $startDate);
  367. }
  368. if ($endDate) {
  369. $itemQuery->where('created_at', '<=', $endDate);
  370. }
  371. $itemLogs = $itemQuery->get();
  372. foreach ($itemLogs as $log) {
  373. $stats['total_count']++;
  374. $itemId = $log->item_id;
  375. $quantity = $log->quantity;
  376. if ($itemId > 0) {
  377. // 累加相同物品的数量
  378. if (isset($stats['items'][$itemId])) {
  379. $stats['items'][$itemId] += $quantity;
  380. } else {
  381. $stats['items'][$itemId] = $quantity;
  382. }
  383. }
  384. // 按来源类型统计
  385. $sourceType = $log->source_type;
  386. if (!isset($stats['by_source_type'][$sourceType])) {
  387. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  388. }
  389. $stats['by_source_type'][$sourceType]['count']++;
  390. }
  391. // 2. 从资金日志表中统计钻石奖励
  392. $fundQuery = FundLogModel::where('user_id', $farmUserId)
  393. ->where('fund_id', FUND_TYPE::FUND2->value) // 钻石类型
  394. ->where('amount', '>', 0) // 只统计收入
  395. ->where('remark', 'like', '%推广%'); // 包含推广关键词的备注
  396. if ($startDate) {
  397. $fundQuery->where('create_time', '>=', strtotime($startDate));
  398. }
  399. if ($endDate) {
  400. $fundQuery->where('create_time', '<=', strtotime($endDate));
  401. }
  402. $fundLogs = $fundQuery->get();
  403. foreach ($fundLogs as $log) {
  404. $stats['total_count']++;
  405. $amount = (float)$log->amount;
  406. // 累加钻石数量
  407. $fundType = FUND_TYPE::FUND2->value;
  408. if (isset($stats['coins'][$fundType])) {
  409. $stats['coins'][$fundType] += $amount;
  410. } else {
  411. $stats['coins'][$fundType] = $amount;
  412. }
  413. $stats['total_amount'] += $amount;
  414. // 按备注内容推断来源类型
  415. $sourceType = $this->inferSourceTypeFromRemark($log->remark);
  416. if (!isset($stats['by_source_type'][$sourceType])) {
  417. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  418. }
  419. $stats['by_source_type'][$sourceType]['amount'] += $amount;
  420. $stats['by_source_type'][$sourceType]['count']++;
  421. }
  422. } catch (\Exception $e) {
  423. Log::error('从日志获取收益统计失败', [
  424. 'farm_user_id' => $farmUserId,
  425. 'start_date' => $startDate,
  426. 'end_date' => $endDate,
  427. 'error' => $e->getMessage()
  428. ]);
  429. }
  430. return $stats;
  431. }
  432. /**
  433. * 从备注推断收益来源类型
  434. *
  435. * @param string $remark 备注内容
  436. * @return string
  437. */
  438. private function inferSourceTypeFromRemark(string $remark): string
  439. {
  440. if (strpos($remark, '收获') !== false) {
  441. return REWARD_SOURCE_TYPE::URSPROMOTION_HAVEST->value;
  442. }
  443. if (strpos($remark, '补发') !== false) {
  444. return REWARD_SOURCE_TYPE::URSPROMOTION_BACKFILL->value;
  445. }
  446. if (strpos($remark, '注册') !== false) {
  447. return REWARD_SOURCE_TYPE::URSPROMOTION_REGISTER->value;
  448. }
  449. if (strpos($remark, '等级') !== false) {
  450. return REWARD_SOURCE_TYPE::URSPROMOTION_LEVEL->value;
  451. }
  452. return REWARD_SOURCE_TYPE::URSPROMOTION_REWARD->value; // 默认推广奖励
  453. }
  454. /**
  455. * 从统计数据构建Reward对象
  456. *
  457. * @param array $stats 统计数据
  458. * @return Reward
  459. */
  460. private function buildRewardFromStats(array $stats): Reward
  461. {
  462. $reward = new Reward();
  463. // 创建物品奖励列表
  464. $items = [];
  465. if (!empty($stats['items'])) {
  466. foreach ($stats['items'] as $itemId => $quantity) {
  467. $rewardItem = new RewardItem();
  468. $rewardItem->setItemId($itemId);
  469. $rewardItem->setInstanceId(0); // 默认为0,表示不指定实例
  470. $rewardItem->setQuantity($quantity);
  471. $items[] = $rewardItem;
  472. }
  473. }
  474. // 创建代币奖励列表
  475. $coins = [];
  476. if (!empty($stats['coins'])) {
  477. foreach ($stats['coins'] as $fundType => $amount) {
  478. $rewardCoin = new RewardCoin();
  479. $rewardCoin->setType($fundType);
  480. $rewardCoin->setQuantity((float)$amount);
  481. $coins[] = $rewardCoin;
  482. }
  483. }
  484. $reward->setItems($items);
  485. $reward->setCoins($coins);
  486. // 其他奖励类型暂时为空
  487. $reward->setGods([]);
  488. $reward->setLands([]);
  489. $reward->setPets([]);
  490. $reward->setPetPowers([]);
  491. $reward->setSkins([]);
  492. return $reward;
  493. }
  494. }