InfoHandler.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539
  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. $response->setStarLevel(0); // 设置达人等级为0
  118. // 设置空的奖励对象
  119. $emptyReward = $this->createEmptyReward();
  120. $response->setTodayReward($emptyReward);
  121. $response->setTotalReward($emptyReward);
  122. return $response;
  123. }
  124. /**
  125. * 创建空的奖励对象
  126. *
  127. * @return Reward
  128. */
  129. private function createEmptyReward(): Reward
  130. {
  131. $reward = new Reward();
  132. // 设置空的奖励列表
  133. $reward->setItems([]);
  134. $reward->setCoins([]);
  135. $reward->setGods([]);
  136. $reward->setLands([]);
  137. $reward->setPets([]);
  138. $reward->setPetPowers([]);
  139. $reward->setSkins([]);
  140. return $reward;
  141. }
  142. /**
  143. * 获取今日统计数据
  144. *
  145. * @param int $ursUserId URS用户ID
  146. * @return array
  147. */
  148. private function getTodayStats(int $ursUserId): array
  149. {
  150. try {
  151. $teamMembers = UrsReferralService::getTeamMembers($ursUserId);
  152. $directNewCount = 0;
  153. $teamNewCount = 0;
  154. // 统计今日新增的直推用户
  155. if (!empty($teamMembers[1])) {
  156. foreach ($teamMembers[1] as $directMember) {
  157. $farmUserId = UrsUserMappingService::getFarmUserId($directMember);
  158. if ($farmUserId) {
  159. // 检查用户映射创建时间是否为今日
  160. $mapping = UrsUserMappingService::getMappingDetail($directMember);
  161. if ($mapping && $mapping->mappingTime &&
  162. Carbon::parse($mapping->mappingTime)->isToday()) {
  163. $directNewCount++;
  164. $teamNewCount++;
  165. }
  166. }
  167. }
  168. }
  169. // 统计今日新增的间推和三推用户
  170. foreach ([2, 3] as $level) {
  171. if (!empty($teamMembers[$level])) {
  172. foreach ($teamMembers[$level] as $member) {
  173. $farmUserId = UrsUserMappingService::getFarmUserId($member);
  174. if ($farmUserId) {
  175. $mapping = UrsUserMappingService::getMappingDetail($member);
  176. if ($mapping && $mapping->mappingTime &&
  177. Carbon::parse($mapping->mappingTime)->isToday()) {
  178. $teamNewCount++;
  179. }
  180. }
  181. }
  182. }
  183. }
  184. return [
  185. 'direct_new_count' => $directNewCount,
  186. 'team_new_count' => $teamNewCount
  187. ];
  188. } catch (\Exception $e) {
  189. Log::error('获取今日统计数据失败', [
  190. 'urs_user_id' => $ursUserId,
  191. 'error' => $e->getMessage()
  192. ]);
  193. return [
  194. 'direct_new_count' => 0,
  195. 'team_new_count' => 0
  196. ];
  197. }
  198. }
  199. /**
  200. * 获取活跃用户统计
  201. *
  202. * @param int $ursUserId URS用户ID
  203. * @return array
  204. */
  205. private function getActiveStats(int $ursUserId): array
  206. {
  207. try {
  208. $teamMembers = UrsReferralService::getTeamMembers($ursUserId);
  209. $activeThreshold = Carbon::now()->subHours(24); // 24小时内活跃
  210. $directActiveCount = 0;
  211. $teamActiveCount = 0;
  212. // 统计直推活跃用户
  213. if (!empty($teamMembers[1])) {
  214. foreach ($teamMembers[1] as $directMember) {
  215. $farmUserId = UrsUserMappingService::getFarmUserId($directMember);
  216. if ($farmUserId) {
  217. $lastActivity = UserActivityService::getLastActivityTime($farmUserId);
  218. if ($lastActivity && $lastActivity->gt($activeThreshold)) {
  219. $directActiveCount++;
  220. $teamActiveCount++;
  221. }
  222. }
  223. }
  224. }
  225. // 统计间推和三推活跃用户
  226. foreach ([2, 3] as $level) {
  227. if (!empty($teamMembers[$level])) {
  228. foreach ($teamMembers[$level] as $member) {
  229. $farmUserId = UrsUserMappingService::getFarmUserId($member);
  230. if ($farmUserId) {
  231. $lastActivity = UserActivityService::getLastActivityTime($farmUserId);
  232. if ($lastActivity && $lastActivity->gt($activeThreshold)) {
  233. $teamActiveCount++;
  234. }
  235. }
  236. }
  237. }
  238. }
  239. return [
  240. 'direct_active_count' => $directActiveCount,
  241. 'team_active_count' => $teamActiveCount
  242. ];
  243. } catch (\Exception $e) {
  244. Log::error('获取活跃用户统计失败', [
  245. 'urs_user_id' => $ursUserId,
  246. 'error' => $e->getMessage()
  247. ]);
  248. return [
  249. 'direct_active_count' => 0,
  250. 'team_active_count' => 0
  251. ];
  252. }
  253. }
  254. /**
  255. * 获取收益统计
  256. *
  257. * @param int $ursUserId URS用户ID
  258. * @return array
  259. */
  260. private function getRewardStats(int $ursUserId): array
  261. {
  262. try {
  263. // 获取对应的农场用户ID
  264. $farmUserId = UrsUserMappingService::getFarmUserId($ursUserId);
  265. if (!$farmUserId) {
  266. Log::info('URS用户未映射到农场用户', ['urs_user_id' => $ursUserId]);
  267. return [
  268. 'today_reward' => null,
  269. 'total_reward' => null
  270. ];
  271. }
  272. // 获取今日收益统计
  273. $today = Carbon::today()->format('Y-m-d');
  274. $tomorrow = Carbon::tomorrow()->format('Y-m-d');
  275. $todayStats = $this->getRewardStatsFromLogs($farmUserId, $today, $tomorrow);
  276. // 获取总收益统计
  277. $totalStats = $this->getRewardStatsFromLogs($farmUserId);
  278. // 构建今日收益Reward对象
  279. $todayReward = null;
  280. if ($todayStats['total_count'] > 0) {
  281. $todayReward = $this->buildRewardFromStats($todayStats);
  282. }
  283. // 构建总收益Reward对象
  284. $totalReward = null;
  285. if ($totalStats['total_count'] > 0) {
  286. $totalReward = $this->buildRewardFromStats($totalStats);
  287. }
  288. return [
  289. 'today_reward' => $todayReward,
  290. 'total_reward' => $totalReward
  291. ];
  292. } catch (\Exception $e) {
  293. Log::error('获取收益统计失败', [
  294. 'urs_user_id' => $ursUserId,
  295. 'error' => $e->getMessage()
  296. ]);
  297. return [
  298. 'today_reward' => null,
  299. 'total_reward' => null
  300. ];
  301. }
  302. }
  303. /**
  304. * 从物品模块和资金模块的日志中获取收益统计
  305. *
  306. * @param int $farmUserId 农场用户ID
  307. * @param string|null $startDate 开始日期
  308. * @param string|null $endDate 结束日期
  309. * @return array
  310. */
  311. private function getRewardStatsFromLogs(int $farmUserId, ?string $startDate = null, ?string $endDate = null): array
  312. {
  313. $stats = [
  314. 'total_amount' => 0,
  315. 'total_count' => 0,
  316. 'items' => [], // 物品奖励列表
  317. 'coins' => [], // 代币奖励列表
  318. 'by_source_type' => []
  319. ];
  320. try {
  321. // URS推广相关的收益来源类型
  322. $ursPromotionSourceTypes = [
  323. REWARD_SOURCE_TYPE::URSPROMOTION_HAVEST->value,
  324. REWARD_SOURCE_TYPE::URSPROMOTION_BACKFILL->value,
  325. REWARD_SOURCE_TYPE::URSPROMOTION_REWARD->value,
  326. REWARD_SOURCE_TYPE::URSPROMOTION_REGISTER->value,
  327. REWARD_SOURCE_TYPE::URSPROMOTION_LEVEL->value,
  328. ];
  329. // 1.1. 从物品交易日志表中统计URS推广奖励(补充查询)
  330. $itemQuery = \App\Module\GameItems\Models\ItemTransactionLog::where('user_id', $farmUserId)
  331. ->where('transaction_type', 1) // 收入类型
  332. ->whereIn('source_type', $ursPromotionSourceTypes);
  333. if ($startDate) {
  334. $itemQuery->where('created_at', '>=', $startDate);
  335. }
  336. if ($endDate) {
  337. $itemQuery->where('created_at', '<=', $endDate);
  338. }
  339. $itemLogs = $itemQuery->get();
  340. foreach ($itemLogs as $log) {
  341. $stats['total_count']++;
  342. $itemId = $log->item_id;
  343. $quantity = $log->quantity;
  344. if ($itemId > 0) {
  345. // 累加相同物品的数量
  346. if (isset($stats['items'][$itemId])) {
  347. $stats['items'][$itemId] += $quantity;
  348. } else {
  349. $stats['items'][$itemId] = $quantity;
  350. }
  351. }
  352. // 按来源类型统计
  353. $sourceType = $log->source_type;
  354. if (!isset($stats['by_source_type'][$sourceType])) {
  355. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  356. }
  357. $stats['by_source_type'][$sourceType]['count']++;
  358. }
  359. // 2. 从资金日志表中统计钻石奖励
  360. $fundQuery = FundLogModel::where('user_id', $farmUserId)
  361. ->where('fund_id', FUND_TYPE::FUND2->value) // 钻石类型
  362. ->where('amount', '>', 0) // 只统计收入
  363. ->where('remark', 'like', '%推广%'); // 包含推广关键词的备注
  364. if ($startDate) {
  365. $fundQuery->where('create_time', '>=', strtotime($startDate));
  366. }
  367. if ($endDate) {
  368. $fundQuery->where('create_time', '<=', strtotime($endDate));
  369. }
  370. $fundLogs = $fundQuery->get();
  371. foreach ($fundLogs as $log) {
  372. $stats['total_count']++;
  373. $amount = (float)$log->amount;
  374. // 累加钻石数量
  375. $fundType = FUND_TYPE::FUND2->value;
  376. if (isset($stats['coins'][$fundType])) {
  377. $stats['coins'][$fundType] += $amount;
  378. } else {
  379. $stats['coins'][$fundType] = $amount;
  380. }
  381. $stats['total_amount'] += $amount;
  382. // 按备注内容推断来源类型
  383. $sourceType = $this->inferSourceTypeFromRemark($log->remark);
  384. if (!isset($stats['by_source_type'][$sourceType])) {
  385. $stats['by_source_type'][$sourceType] = ['amount' => 0, 'count' => 0];
  386. }
  387. $stats['by_source_type'][$sourceType]['amount'] += $amount;
  388. $stats['by_source_type'][$sourceType]['count']++;
  389. }
  390. } catch (\Exception $e) {
  391. Log::error('从日志获取收益统计失败', [
  392. 'farm_user_id' => $farmUserId,
  393. 'start_date' => $startDate,
  394. 'end_date' => $endDate,
  395. 'error' => $e->getMessage()
  396. ]);
  397. }
  398. return $stats;
  399. }
  400. /**
  401. * 从备注推断收益来源类型
  402. *
  403. * @param string $remark 备注内容
  404. * @return string
  405. */
  406. private function inferSourceTypeFromRemark(string $remark): string
  407. {
  408. if (strpos($remark, '收获') !== false) {
  409. return REWARD_SOURCE_TYPE::URSPROMOTION_HAVEST->value;
  410. }
  411. if (strpos($remark, '补发') !== false) {
  412. return REWARD_SOURCE_TYPE::URSPROMOTION_BACKFILL->value;
  413. }
  414. if (strpos($remark, '注册') !== false) {
  415. return REWARD_SOURCE_TYPE::URSPROMOTION_REGISTER->value;
  416. }
  417. if (strpos($remark, '等级') !== false) {
  418. return REWARD_SOURCE_TYPE::URSPROMOTION_LEVEL->value;
  419. }
  420. return REWARD_SOURCE_TYPE::URSPROMOTION_REWARD->value; // 默认推广奖励
  421. }
  422. /**
  423. * 从统计数据构建Reward对象
  424. *
  425. * @param array $stats 统计数据
  426. * @return Reward
  427. */
  428. private function buildRewardFromStats(array $stats): Reward
  429. {
  430. $reward = new Reward();
  431. // 创建物品奖励列表
  432. $items = [];
  433. if (!empty($stats['items'])) {
  434. foreach ($stats['items'] as $itemId => $quantity) {
  435. $rewardItem = new RewardItem();
  436. $rewardItem->setItemId($itemId);
  437. $rewardItem->setInstanceId(0); // 默认为0,表示不指定实例
  438. $rewardItem->setQuantity($quantity);
  439. $items[] = $rewardItem;
  440. }
  441. }
  442. // 创建代币奖励列表
  443. $coins = [];
  444. if (!empty($stats['coins'])) {
  445. foreach ($stats['coins'] as $fundType => $amount) {
  446. $rewardCoin = new RewardCoin();
  447. $rewardCoin->setType($fundType);
  448. $rewardCoin->setQuantity((float)$amount);
  449. $coins[] = $rewardCoin;
  450. }
  451. }
  452. $reward->setItems($items);
  453. $reward->setCoins($coins);
  454. // 其他奖励类型暂时为空
  455. $reward->setGods([]);
  456. $reward->setLands([]);
  457. $reward->setPets([]);
  458. $reward->setPetPowers([]);
  459. $reward->setSkins([]);
  460. return $reward;
  461. }
  462. }