InfoHandler.php 18 KB

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