InfoHandler.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538
  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.1. 从物品交易日志表中统计URS推广奖励(补充查询)
  329. $itemQuery = \App\Module\GameItems\Models\ItemTransactionLog::where('user_id', $farmUserId)
  330. ->where('transaction_type', 1) // 收入类型
  331. ->whereIn('source_type', $ursPromotionSourceTypes);
  332. if ($startDate) {
  333. $itemQuery->where('created_at', '>=', $startDate);
  334. }
  335. if ($endDate) {
  336. $itemQuery->where('created_at', '<=', $endDate);
  337. }
  338. $itemLogs = $itemQuery->get();
  339. foreach ($itemLogs as $log) {
  340. $stats['total_count']++;
  341. $itemId = $log->item_id;
  342. $quantity = $log->quantity;
  343. if ($itemId > 0) {
  344. // 累加相同物品的数量
  345. if (isset($stats['items'][$itemId])) {
  346. $stats['items'][$itemId] += $quantity;
  347. } else {
  348. $stats['items'][$itemId] = $quantity;
  349. }
  350. }
  351. // 按来源类型统计
  352. $sourceType = $log->source_type;
  353. if (!isset($stats['by_source_type'][$sourceType])) {
  354. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  355. }
  356. $stats['by_source_type'][$sourceType]['count']++;
  357. }
  358. // 2. 从资金日志表中统计钻石奖励
  359. $fundQuery = FundLogModel::where('user_id', $farmUserId)
  360. ->where('fund_id', FUND_TYPE::FUND2->value) // 钻石类型
  361. ->where('amount', '>', 0) // 只统计收入
  362. ->where('remark', 'like', '%推广%'); // 包含推广关键词的备注
  363. if ($startDate) {
  364. $fundQuery->where('create_time', '>=', strtotime($startDate));
  365. }
  366. if ($endDate) {
  367. $fundQuery->where('create_time', '<=', strtotime($endDate));
  368. }
  369. $fundLogs = $fundQuery->get();
  370. foreach ($fundLogs as $log) {
  371. $stats['total_count']++;
  372. $amount = (float)$log->amount;
  373. // 累加钻石数量
  374. $fundType = FUND_TYPE::FUND2->value;
  375. if (isset($stats['coins'][$fundType])) {
  376. $stats['coins'][$fundType] += $amount;
  377. } else {
  378. $stats['coins'][$fundType] = $amount;
  379. }
  380. $stats['total_amount'] += $amount;
  381. // 按备注内容推断来源类型
  382. $sourceType = $this->inferSourceTypeFromRemark($log->remark);
  383. if (!isset($stats['by_source_type'][$sourceType])) {
  384. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  385. }
  386. $stats['by_source_type'][$sourceType]['amount'] += $amount;
  387. $stats['by_source_type'][$sourceType]['count']++;
  388. }
  389. } catch (\Exception $e) {
  390. Log::error('从日志获取收益统计失败', [
  391. 'farm_user_id' => $farmUserId,
  392. 'start_date' => $startDate,
  393. 'end_date' => $endDate,
  394. 'error' => $e->getMessage()
  395. ]);
  396. }
  397. return $stats;
  398. }
  399. /**
  400. * 从备注推断收益来源类型
  401. *
  402. * @param string $remark 备注内容
  403. * @return string
  404. */
  405. private function inferSourceTypeFromRemark(string $remark): string
  406. {
  407. if (strpos($remark, '收获') !== false) {
  408. return REWARD_SOURCE_TYPE::URSPROMOTION_HAVEST->value;
  409. }
  410. if (strpos($remark, '补发') !== false) {
  411. return REWARD_SOURCE_TYPE::URSPROMOTION_BACKFILL->value;
  412. }
  413. if (strpos($remark, '注册') !== false) {
  414. return REWARD_SOURCE_TYPE::URSPROMOTION_REGISTER->value;
  415. }
  416. if (strpos($remark, '等级') !== false) {
  417. return REWARD_SOURCE_TYPE::URSPROMOTION_LEVEL->value;
  418. }
  419. return REWARD_SOURCE_TYPE::URSPROMOTION_REWARD->value; // 默认推广奖励
  420. }
  421. /**
  422. * 从统计数据构建Reward对象
  423. *
  424. * @param array $stats 统计数据
  425. * @return Reward
  426. */
  427. private function buildRewardFromStats(array $stats): Reward
  428. {
  429. $reward = new Reward();
  430. // 创建物品奖励列表
  431. $items = [];
  432. if (!empty($stats['items'])) {
  433. foreach ($stats['items'] as $itemId => $quantity) {
  434. $rewardItem = new RewardItem();
  435. $rewardItem->setItemId($itemId);
  436. $rewardItem->setInstanceId(0); // 默认为0,表示不指定实例
  437. $rewardItem->setQuantity($quantity);
  438. $items[] = $rewardItem;
  439. }
  440. }
  441. // 创建代币奖励列表
  442. $coins = [];
  443. if (!empty($stats['coins'])) {
  444. foreach ($stats['coins'] as $fundType => $amount) {
  445. $rewardCoin = new RewardCoin();
  446. $rewardCoin->setType($fundType);
  447. $rewardCoin->setQuantity((float)$amount);
  448. $coins[] = $rewardCoin;
  449. }
  450. }
  451. $reward->setItems($items);
  452. $reward->setCoins($coins);
  453. // 其他奖励类型暂时为空
  454. $reward->setGods([]);
  455. $reward->setLands([]);
  456. $reward->setPets([]);
  457. $reward->setPetPowers([]);
  458. $reward->setSkins([]);
  459. return $reward;
  460. }
  461. }