HouseLogic.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519
  1. <?php
  2. namespace App\Module\Farm\Logics;
  3. use App\Module\Farm\Dtos\HouseRankDto;
  4. use App\Module\Farm\Dtos\HouseRankItemDto;
  5. use App\Module\Farm\Dtos\WealthRankDto;
  6. use App\Module\Farm\Dtos\WealthRankItemDto;
  7. use App\Module\Farm\Enums\UPGRADE_TYPE;
  8. use App\Module\Farm\Events\HouseUpgradedEvent;
  9. use App\Module\Farm\Models\FarmHouseConfig;
  10. use App\Module\Farm\Models\FarmUpgradeLog;
  11. use App\Module\Farm\Models\FarmUser;
  12. use App\Module\Fund\Enums\FUND_TYPE;
  13. use App\Module\User\Models\User;
  14. use Illuminate\Support\Facades\Cache;
  15. use Illuminate\Support\Facades\DB;
  16. use Illuminate\Support\Facades\Log;
  17. /**
  18. * 房屋管理逻辑
  19. */
  20. class HouseLogic
  21. {
  22. /**
  23. * 缓存键前缀
  24. *
  25. * @var string
  26. */
  27. private $cachePrefix = 'farm:house2:';
  28. /**
  29. * 缓存过期时间(秒)
  30. *
  31. * @var int
  32. */
  33. private $cacheExpiration = 20; // 24小时
  34. /**
  35. * 获取房屋配置
  36. *
  37. * @param int $level
  38. * @return FarmHouseConfig|null
  39. */
  40. public function getHouseConfig(int $level): ?FarmHouseConfig
  41. {
  42. try {
  43. // 尝试从缓存获取
  44. $cacheKey = $this->cachePrefix . 'config:' . $level;
  45. $cachedConfig = Cache::get($cacheKey);
  46. if ($cachedConfig) {
  47. return $cachedConfig;
  48. }
  49. // 从数据库获取
  50. $config = FarmHouseConfig::where('level', $level)->first();
  51. if (!$config) {
  52. return null;
  53. }
  54. // 缓存结果
  55. Cache::put($cacheKey, $config, $this->cacheExpiration);
  56. return $config;
  57. } catch (\Exception $e) {
  58. Log::error('获取房屋配置失败', [
  59. 'level' => $level,
  60. 'error' => $e->getMessage(),
  61. 'trace' => $e->getTraceAsString()
  62. ]);
  63. return null;
  64. }
  65. }
  66. /**
  67. * 获取所有房屋配置
  68. *
  69. * @return array
  70. */
  71. public function getAllHouseConfigs(): array
  72. {
  73. try {
  74. // 尝试从缓存获取
  75. $cacheKey = $this->cachePrefix . 'configs:all';
  76. $cachedConfigs = Cache::get($cacheKey);
  77. if ($cachedConfigs) {
  78. return $cachedConfigs;
  79. }
  80. // 从数据库获取
  81. $configs = FarmHouseConfig::orderBy('level')->get();
  82. $result = [];
  83. foreach ($configs as $config) {
  84. $result[$config->level] = [
  85. 'level' => $config->level,
  86. 'output_bonus' => $config->output_bonus,
  87. 'special_land_limit' => $config->special_land_limit,
  88. 'upgrade_materials' => $config->upgrade_materials,
  89. 'downgrade_days' => $config->downgrade_days,
  90. 'available_lands' => $config->available_lands,
  91. ];
  92. }
  93. // 缓存结果
  94. Cache::put($cacheKey, $result, $this->cacheExpiration);
  95. return $result;
  96. } catch (\Exception $e) {
  97. Log::error('获取所有房屋配置失败', [
  98. 'error' => $e->getMessage(),
  99. 'trace' => $e->getTraceAsString()
  100. ]);
  101. return [];
  102. }
  103. }
  104. /**
  105. * 获取下一级房屋配置
  106. *
  107. * @param int $currentLevel
  108. * @return FarmHouseConfig|null
  109. */
  110. public function getNextLevelConfig(int $currentLevel): ?FarmHouseConfig
  111. {
  112. try {
  113. // 尝试从缓存获取
  114. $cacheKey = $this->cachePrefix . 'config:' . ($currentLevel + 1);
  115. $cachedConfig = Cache::get($cacheKey);
  116. if ($cachedConfig) {
  117. return $cachedConfig;
  118. }
  119. // 从数据库获取
  120. $config = FarmHouseConfig::where('level', $currentLevel + 1)->first();
  121. if (!$config) {
  122. return null;
  123. }
  124. // 缓存结果
  125. Cache::put($cacheKey, $config, $this->cacheExpiration);
  126. return $config;
  127. } catch (\Exception $e) {
  128. Log::error('获取下一级房屋配置失败', [
  129. 'current_level' => $currentLevel,
  130. 'error' => $e->getMessage(),
  131. 'trace' => $e->getTraceAsString()
  132. ]);
  133. return null;
  134. }
  135. }
  136. /**
  137. * 升级房屋
  138. *
  139. * 注意:此方法不处理消耗逻辑,只负责升级房屋等级和记录升级日志
  140. * 消耗处理应在调用此方法前完成,并将消耗的材料信息传入
  141. *
  142. * @param int $userId 用户ID
  143. * @param array $materials 消耗的材料记录(已经消耗完成的)
  144. * @return bool 升级是否成功
  145. */
  146. public function upgradeHouse(int $userId, array $materials): bool
  147. {
  148. try {
  149. // 获取用户农场信息
  150. $farmUser = FarmUser::where('user_id', $userId)->first();
  151. if (!$farmUser) {
  152. throw new \Exception('用户农场不存在');
  153. }
  154. // 获取当前房屋等级
  155. $currentLevel = $farmUser->house_level;
  156. // 获取下一级房屋配置
  157. $nextLevelConfig = $this->getNextLevelConfig($currentLevel);
  158. if (!$nextLevelConfig) {
  159. throw new \Exception('已达到最高等级');
  160. }
  161. // 更新用户房屋等级
  162. $oldLevel = $farmUser->house_level;
  163. $newLevel = $oldLevel + 1;
  164. $farmUser->house_level = $newLevel;
  165. $farmUser->last_upgrade_time = now();
  166. $farmUser->save();
  167. // 创建升级记录
  168. $upgradeLog = new FarmUpgradeLog();
  169. $upgradeLog->user_id = $userId;
  170. $upgradeLog->upgrade_type = UPGRADE_TYPE::HOUSE->value;
  171. $upgradeLog->old_level = $oldLevel;
  172. $upgradeLog->new_level = $newLevel;
  173. $upgradeLog->materials_consumed = $materials;
  174. $upgradeLog->upgrade_time = now();
  175. $upgradeLog->created_at = now();
  176. $upgradeLog->save();
  177. Log::debug('HouseUpgradedEvent', []);
  178. // 触发房屋升级事件
  179. event(new HouseUpgradedEvent($userId, $farmUser, $oldLevel, $newLevel, $upgradeLog));
  180. Log::info('房屋升级成功', [
  181. 'user_id' => $userId,
  182. 'old_level' => $oldLevel,
  183. 'new_level' => $newLevel,
  184. 'upgrade_log_id' => $upgradeLog->id
  185. ]);
  186. return true;
  187. } catch (\Exception $e) {
  188. Log::error('房屋升级失败', [
  189. 'user_id' => $userId,
  190. 'error' => $e->getMessage(),
  191. 'trace' => $e->getTraceAsString()
  192. ]);
  193. return false;
  194. }
  195. }
  196. /**
  197. * 获取房屋等级可用的土地数量
  198. *
  199. * @param int $level 房屋等级
  200. * @return int 可用土地数量
  201. */
  202. public function getAvailableLandsCount(int $level): int
  203. {
  204. try {
  205. $config = $this->getHouseConfig($level);
  206. if (!$config) {
  207. return 0;
  208. }
  209. // 确保返回整数类型
  210. return $config->available_lands ? (int)$config->available_lands : 0;
  211. } catch (\Exception $e) {
  212. Log::error('获取房屋等级可用土地数量失败', [
  213. 'level' => $level,
  214. 'error' => $e->getMessage(),
  215. 'trace' => $e->getTraceAsString()
  216. ]);
  217. return 0;
  218. }
  219. }
  220. /**
  221. * 获取房屋排行榜数据
  222. *
  223. * @param int $userId 当前用户ID
  224. * @param int $page 页码
  225. * @param int $pageSize 每页数量
  226. * @return HouseRankDto
  227. */
  228. public function getHouseRankList(int $userId, int $page = 1, int $pageSize = 20): HouseRankDto
  229. {
  230. // 限制只显示前100名
  231. $maxRankLimit = 100;
  232. $offset = ($page - 1) * $pageSize;
  233. // 如果请求的数据超出前100名,返回空结果
  234. if ($offset >= $maxRankLimit) {
  235. // 先获取缓存数据来计算实际总数
  236. $cachedRankList = $this->getHouseRankListCache();
  237. return new HouseRankDto([], 0, 1, [
  238. 'page' => $page,
  239. 'per_page' => $pageSize,
  240. 'total' => count($cachedRankList)
  241. ]);
  242. }
  243. $cachedRankList = $this->getHouseRankListCache();
  244. // 调整查询限制,确保不超过前100名
  245. $actualLimit = min($pageSize, $maxRankLimit - $offset);
  246. // 从缓存数据中获取当前页的数据
  247. $rankList = array_slice($cachedRankList, $offset, $actualLimit);
  248. // 转换为DTO对象
  249. $rankItems = [];
  250. foreach ($rankList as $index => $item) {
  251. $rank = $offset + $index + 1;
  252. $rankItems[] = HouseRankItemDto::fromArray((array)$item, $rank);
  253. }
  254. // 查询用户自己的排名
  255. $userRank = 0;
  256. foreach ($cachedRankList as $index => $item) {
  257. if ($item->user_id == $userId) {
  258. $userRank = $index + 1; // 用户在整个排行榜中的排名
  259. break; // 找到后立即退出循环
  260. }
  261. }
  262. // 构建分页信息
  263. $pageInfo = [
  264. 'page' => $page,
  265. 'per_page' => $pageSize,
  266. 'total' => count($cachedRankList) // 直接使用缓存数据的行数
  267. ];
  268. return new HouseRankDto($rankItems, $userRank, 1, $pageInfo);
  269. }
  270. /**
  271. * 获取房屋排行榜缓存数据
  272. *
  273. * @return array
  274. */
  275. protected function getHouseRankListCache(): array
  276. {
  277. // 限制只显示前100名
  278. $maxRankLimit = 100;
  279. // 尝试从缓存获取排行榜数据
  280. $cacheKey = $this->cachePrefix . 'house_rank:top100-1';
  281. $cachedRankList = Cache::get($cacheKey);
  282. if (!$cachedRankList) {
  283. // 查询前100名排行榜数据,按房屋等级降序排列,同时获取财富值
  284. $cachedRankList = DB::table('farm_users as fu')
  285. ->join('user_infos as u', 'fu.user_id', '=', 'u.user_id')
  286. ->leftJoin('fund as f', function ($join) {
  287. $join->on('fu.user_id', '=', 'f.user_id')
  288. ->where('f.fund_id', '=', 2); // 钻石资金类型
  289. })
  290. ->select([
  291. 'fu.user_id',
  292. 'fu.house_level',
  293. 'u.nickname as nickname',
  294. 'fu.last_upgrade_time',
  295. 'f.balance'
  296. ])
  297. ->orderBy('fu.house_level', 'desc')
  298. ->orderBy('f.balance', 'desc') // 同等级按升级时间排序
  299. ->limit($maxRankLimit)
  300. ->get()
  301. ->toArray();
  302. // 缓存10分钟
  303. Cache::put($cacheKey, $cachedRankList, 600);
  304. }
  305. return $cachedRankList;
  306. }
  307. /**
  308. * 获取财富排行榜数据
  309. *
  310. * @param int $userId 当前用户ID
  311. * @param int $page 页码
  312. * @param int $pageSize 每页数量
  313. * @return WealthRankDto
  314. */
  315. public function getWealthRankList(int $userId, int $page = 1, int $pageSize = 20): WealthRankDto
  316. {
  317. try {
  318. // 限制只显示前100名
  319. $maxRankLimit = 100;
  320. $offset = ($page - 1) * $pageSize;
  321. // 如果请求的数据超出前100名,返回空结果
  322. if ($offset >= $maxRankLimit) {
  323. // 先获取缓存数据来计算实际总数
  324. $cachedRankList = $this->getWealthRankListCache();
  325. return new WealthRankDto([], 0, 1, [
  326. 'page' => $page,
  327. 'per_page' => $pageSize,
  328. 'total' => count($cachedRankList)
  329. ]);
  330. }
  331. // 从缓存获取前100名数据
  332. $cachedRankList = $this->getWealthRankListCache();
  333. // dd($cachedRankList);
  334. // 调整查询限制,确保不超过前100名
  335. $actualLimit = min($pageSize, $maxRankLimit - $offset);
  336. // 从缓存数据中获取当前页的数据
  337. $rankList = array_slice($cachedRankList, $offset, $actualLimit);
  338. // 转换为DTO对象
  339. $rankItems = [];
  340. foreach ($rankList as $index => $item) {
  341. $rank = $offset + $index + 1;
  342. $rankItems[] = WealthRankItemDto::fromArray((array)$item, $rank);
  343. }
  344. // 查询用户自己的排名
  345. $userRank = 0;
  346. foreach ($cachedRankList as $index => $item) {
  347. if ($item->user_id == $userId) {
  348. $userRank = $index + 1; // 用户在整个排行榜中的排名
  349. break; // 找到后立即退出循环
  350. }
  351. }
  352. // 构建分页信息
  353. $pageInfo = [
  354. 'page' => $page,
  355. 'per_page' => $pageSize,
  356. 'total' => count($cachedRankList) // 直接使用缓存数据的行数
  357. ];
  358. // dd($rankItems);
  359. return new WealthRankDto($rankItems, $userRank, 1, $pageInfo);
  360. } catch (\Exception $e) {
  361. Log::error('获取财富排行榜失败', [
  362. 'user_id' => $userId,
  363. 'page' => $page,
  364. 'page_size' => $pageSize,
  365. 'error' => $e->getMessage(),
  366. 'trace' => $e->getTraceAsString()
  367. ]);
  368. return new WealthRankDto();
  369. }
  370. }
  371. /**
  372. * 获取财富排行榜缓存数据
  373. *
  374. * @return array
  375. */
  376. private function getWealthRankListCache(): array
  377. {
  378. // 限制只显示前100名
  379. $maxRankLimit = 100;
  380. // 尝试从缓存获取排行榜数据
  381. $cacheKey = $this->cachePrefix . 'wealth_rank:top100_2';
  382. $cachedRankList = Cache::get($cacheKey);
  383. if (!$cachedRankList) {
  384. // 查询前100名财富排行榜数据,按钻石余额降序排列,同余额按房屋等级降序排列
  385. $cachedRankList = DB::table('fund as f')
  386. ->join('user_infos as u', 'f.user_id', '=', 'u.user_id')
  387. ->leftJoin('farm_users as fu', 'f.user_id', '=', 'fu.user_id')
  388. ->select([
  389. 'f.user_id',
  390. 'f.balance',
  391. 'u.nickname',
  392. 'fu.house_level'
  393. ])
  394. ->where('f.fund_id', FUND_TYPE::FUND2) // 钻石资金类型
  395. ->where('f.user_id', '>', 10000)
  396. ->orderBy('f.balance', 'desc')
  397. ->orderBy('fu.house_level', 'desc') // 同钻石余额按房屋等级排序
  398. ->limit($maxRankLimit)
  399. ->get()
  400. ->toArray();
  401. // 缓存10分钟
  402. Cache::put($cacheKey, $cachedRankList, 600);
  403. }
  404. return $cachedRankList;
  405. }
  406. /**
  407. * 清除房屋配置缓存
  408. *
  409. * @param int|null $level
  410. * @return bool
  411. */
  412. public function clearHouseConfigCache(?int $level = null): bool
  413. {
  414. try {
  415. if ($level) {
  416. // 清除指定等级的缓存
  417. Cache::forget($this->cachePrefix . 'config:' . $level);
  418. } else {
  419. // 清除所有房屋配置缓存
  420. Cache::forget($this->cachePrefix . 'configs:all');
  421. // 清除各等级缓存
  422. $maxLevel = 12; // 假设最高等级为12
  423. for ($i = 1; $i <= $maxLevel; $i++) {
  424. Cache::forget($this->cachePrefix . 'config:' . $i);
  425. }
  426. }
  427. return true;
  428. } catch (\Exception $e) {
  429. Log::error('清除房屋配置缓存失败', [
  430. 'level' => $level,
  431. 'error' => $e->getMessage(),
  432. 'trace' => $e->getTraceAsString()
  433. ]);
  434. return false;
  435. }
  436. }
  437. }