SharedProsperityUserRepository.php 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912
  1. <?php
  2. namespace app\common\repositories\shared;
  3. use app\common\dao\shared\SharedProsperityGroupUserDao;
  4. use app\common\dao\shared\SharedProsperityUserDao;
  5. use app\common\dao\user\UserDao;
  6. use app\common\enum\CommonEnum;
  7. use app\common\enum\shared\SharedProsperityRewardRecordEnum;
  8. use app\common\enum\shared\SharedProsperityUserEnum;
  9. use app\common\repositories\BaseRepository;
  10. use app\common\repositories\store\order\StoreOrderRepository;
  11. use app\entity\data\shared\SharedProsperityGroupUserEntity;
  12. use app\entity\data\shared\SharedProsperityRecommendConfigEntity;
  13. use app\entity\data\shared\SharedProsperityUserEntity;
  14. use think\db\exception\DbException;
  15. class SharedProsperityUserRepository extends BaseRepository
  16. {
  17. protected $dao;
  18. /**
  19. * SharedProsperityUserRepository constructor.
  20. * @param SharedProsperityUserDao $dao
  21. */
  22. public function __construct(SharedProsperityUserDao $dao)
  23. {
  24. $this->dao = $dao;
  25. }
  26. /**
  27. * @param int $id
  28. * @return SharedProsperityUserEntity
  29. */
  30. public function getSharedProsperityUserEntityById(int $id): SharedProsperityUserEntity
  31. {
  32. $entityList = $this->getSharedProsperityUserEntityListByIdList([$id]);
  33. $entity = array_shift($entityList);
  34. if ($entity instanceof SharedProsperityUserEntity) {
  35. return $entity;
  36. } else {
  37. /** @var SharedProsperityUserEntity */
  38. return SharedProsperityUserEntity::newInstance();
  39. }
  40. }
  41. /**
  42. * @param array $idList
  43. * @return SharedProsperityUserEntity[]
  44. */
  45. public function getSharedProsperityUserEntityListByIdList(array $idList): array
  46. {
  47. return $this->dao->getSharedProsperityUserEntityListByIdList($idList);
  48. }
  49. /**
  50. * @param int $userId
  51. * @return SharedProsperityUserEntity
  52. */
  53. public function getSharedProsperityUserEntityByUserId(int $userId): SharedProsperityUserEntity
  54. {
  55. $entityList = $this->getSharedProsperityUserEntityListByUserIdList([$userId]);
  56. $entity = array_shift($entityList);
  57. if ($entity instanceof SharedProsperityUserEntity) {
  58. return $entity;
  59. } else {
  60. /** @var SharedProsperityUserEntity */
  61. return SharedProsperityUserEntity::newInstance();
  62. }
  63. }
  64. /**
  65. * @param array $userIdList
  66. * @return SharedProsperityUserEntity[]
  67. */
  68. public function getSharedProsperityUserEntityListByUserIdList(array $userIdList): array
  69. {
  70. return $this->dao->getSharedProsperityUserEntityListByUserIdList($userIdList);
  71. }
  72. /**
  73. * 获取直接下级用户ID列表
  74. * @param int $parentId 用户ID
  75. * @return SharedProsperityUserEntity[] 直接下级用户ID列表
  76. */
  77. public function getSharedProsperityUserEntityListByParentId(int $parentId): array
  78. {
  79. return $this->dao->getSharedProsperityUserEntityListByParentId($parentId);
  80. }
  81. /**
  82. * @param array $userIdList
  83. * @return SharedProsperityUserEntity[]
  84. */
  85. public function getSharedProsperityUserEntityMapByUserIdList(array $userIdList): array
  86. {
  87. $sharedProsperityUserEntityList = $this->dao->getSharedProsperityUserEntityListByUserIdList($userIdList);
  88. /** @var SharedProsperityUserEntity[] $sharedProsperityUserEntityMapByUserId */
  89. $sharedProsperityUserEntityMapByUserId = array_column($sharedProsperityUserEntityList, null, 'userId');
  90. return $sharedProsperityUserEntityMapByUserId;
  91. }
  92. public function create($data)
  93. {
  94. return $this->dao->create($data);
  95. }
  96. /**
  97. * @param SharedProsperityUserEntity $sharedProsperityUserEntity
  98. * @return SharedProsperityUserEntity
  99. */
  100. public function createByEntity(SharedProsperityUserEntity $sharedProsperityUserEntity): SharedProsperityUserEntity
  101. {
  102. $result = $this->create($sharedProsperityUserEntity->toUnderlineArray())->toArray();
  103. /** @var SharedProsperityUserEntity $entity */
  104. $entity = SharedProsperityUserEntity::newInstance($result);
  105. return $entity;
  106. }
  107. /**
  108. * @param $id
  109. * @param $data
  110. * @return int
  111. */
  112. public function update($id, $data): int
  113. {
  114. try {
  115. return $this->dao->update($id, $data);
  116. } catch (DbException $e) {
  117. return 0;
  118. }
  119. }
  120. public function updateByUserId($userId, $data): int
  121. {
  122. try {
  123. return $this->dao->updateByUserId($userId, $data);
  124. } catch (DbException $e) {
  125. return 0;
  126. }
  127. }
  128. /**
  129. * @param SharedProsperityUserEntity $sharedProsperityUserEntity
  130. * @return SharedProsperityUserEntity
  131. */
  132. public function updateByEntity(SharedProsperityUserEntity $sharedProsperityUserEntity): SharedProsperityUserEntity
  133. {
  134. if (empty($sharedProsperityUserEntity->getId())) {
  135. return SharedProsperityUserEntity::newInstance();
  136. }
  137. $result = $this->update($sharedProsperityUserEntity->getId(), $sharedProsperityUserEntity->toUnderlineArray());
  138. if ($result > 0) {
  139. return $this->getSharedProsperityUserEntityById($sharedProsperityUserEntity->getId());
  140. }
  141. return SharedProsperityUserEntity::newInstance();
  142. }
  143. /**
  144. * 绑定 上级
  145. * @param int $userId
  146. * @param int $parentId
  147. * @return bool
  148. */
  149. public function bindParentId(int $userId, int $parentId): bool
  150. {
  151. $sharedProsperityUserEntity = $this->getSharedProsperityUserEntityByUserId($userId);
  152. if (empty($sharedProsperityUserEntity->getUserId())) {
  153. return false;
  154. }
  155. $sharedProsperityUserEntityByParentId = $this->getSharedProsperityUserEntityByUserId($parentId);
  156. if (empty($sharedProsperityUserEntityByParentId->getUserId())) {
  157. return false;
  158. }
  159. $sharedProsperityUserEntity = $this->updateByEntity($sharedProsperityUserEntity->setParentId($sharedProsperityUserEntityByParentId->getUserId()));
  160. if (empty($sharedProsperityUserEntity->getId())) {
  161. return false;
  162. }
  163. return true;
  164. }
  165. /**
  166. * 获取直推用户列表,并计算每个直推用户的团队总人数和团队总业绩(包含自己)
  167. * 返回三个列表:全部直推、大部门(团队业绩最大的直推用户)、小部门(其余直推用户)
  168. * 同时返回统计数据:我的部门总人数、总业绩、小部门业绩总和、大部门业绩总和
  169. * @param int $userId
  170. * @return array
  171. */
  172. public function getTeam(int $userId): array
  173. {
  174. // 获取直推用户
  175. $list = $this->dao->getDirectByUserId($userId);
  176. if (empty($list)) {
  177. // 没有直推用户,仍然返回统计数据(我的部门总人数和总业绩)
  178. $myTeamUserIds = $this->dao->getAllSubordinateUserIds($userId);
  179. $myTeamTotalCount = count($myTeamUserIds);
  180. $myTeamPvSum = $this->dao->getTeamPvSumWithSelf($userId);
  181. return [
  182. 'all_direct' => [],
  183. 'big_department' => [],
  184. 'small_department' => [],
  185. 'stats' => [
  186. 'my_team_total_count' => $myTeamTotalCount,
  187. 'my_team_pv_sum' => $myTeamPvSum,
  188. 'small_department_pv_sum' => 0,
  189. 'big_department_pv_sum' => 0,
  190. ]
  191. ];
  192. }
  193. // 收集所有直推用户ID
  194. $userIds = array_column($list, 'user_id');
  195. // 获取用户详细信息(昵称、头像、注册时间)
  196. /** @var UserDao $userDao */
  197. $userDao = app()->make(UserDao::class);
  198. $userEntities = $userDao->getUserEntityListByUidList($userIds);
  199. $userMap = [];
  200. foreach ($userEntities as $userEntity) {
  201. $userMap[$userEntity->getUid()] = [
  202. 'nickname' => $userEntity->getNickname(),
  203. 'avatar' => $userEntity->getAvatar(),
  204. 'create_time' => $userEntity->getCreateTime(),
  205. ];
  206. }
  207. // 计算每个直推用户的团队总人数和团队总业绩
  208. $maxPv = 0;
  209. $maxPvIndex = -1;
  210. foreach ($list as $index => &$item) {
  211. $teamUserIds = $this->dao->getAllSubordinateUserIds($item['user_id'], false, 4);
  212. $teamTotalCount = count($teamUserIds);
  213. $teamPvSum = $this->dao->getTeamPvSum($item['user_id'], 4);
  214. $item['team_total_count'] = $teamTotalCount;
  215. $item['team_pv_sum'] = $teamPvSum;
  216. // 补充用户信息
  217. if (isset($userMap[$item['user_id']])) {
  218. $item['nickname'] = $userMap[$item['user_id']]['nickname'];
  219. $item['avatar'] = $userMap[$item['user_id']]['avatar'];
  220. $item['create_time'] = $userMap[$item['user_id']]['create_time'];
  221. } else {
  222. $item['nickname'] = '';
  223. $item['avatar'] = '';
  224. $item['create_time'] = '';
  225. }
  226. // 找出团队业绩最大的直推用户
  227. if ($teamPvSum > $maxPv) {
  228. $maxPv = $teamPvSum;
  229. $maxPvIndex = $index;
  230. }
  231. }
  232. unset($item);
  233. // 分割大部门和小部门
  234. $bigDepartment = [];
  235. $smallDepartment = [];
  236. if ($maxPvIndex >= 0) {
  237. $bigDepartment[] = $list[$maxPvIndex];
  238. foreach ($list as $index => $item) {
  239. if ($index !== $maxPvIndex) {
  240. $smallDepartment[] = $item;
  241. }
  242. }
  243. } else {
  244. // 没有直推用户(理论上不会发生)
  245. $smallDepartment = $list;
  246. }
  247. // 计算统计数据
  248. $myTeamUserIds = $this->dao->getAllSubordinateUserIds($userId);
  249. $myTeamTotalCount = count($myTeamUserIds);
  250. $myTeamPvSum = $this->dao->getTeamPvSum($userId);
  251. $smallDepartmentPvSum = 0;
  252. foreach ($smallDepartment as $item) {
  253. $smallDepartmentPvSum += $item['team_pv_sum'];
  254. }
  255. $bigDepartmentPvSum = 0;
  256. foreach ($bigDepartment as $item) {
  257. $bigDepartmentPvSum += $item['team_pv_sum'];
  258. }
  259. return [
  260. 'all_direct' => $list,
  261. 'big_department' => $bigDepartment,
  262. 'small_department' => $smallDepartment,
  263. 'stats' => [
  264. 'my_team_total_count' => $myTeamTotalCount,
  265. 'my_team_pv_sum' => $myTeamPvSum,
  266. 'small_department_pv_sum' => floor($smallDepartmentPvSum * 100) / 100,
  267. 'big_department_pv_sum' => $bigDepartmentPvSum,
  268. ]
  269. ];
  270. }
  271. /**
  272. * 批量更新
  273. * @param $dataList
  274. * @return array
  275. */
  276. public function batchUpdateSharedProsperityUserDataByDataList($dataList): array
  277. {
  278. return $this->dao->saveAll($dataList);
  279. }
  280. /**
  281. * 用户身份升级
  282. * @param array $userIdList
  283. * @return void
  284. */
  285. public function identityUpgrade(array $userIdList)
  286. {
  287. if (empty($userIdList)) {
  288. return;
  289. }
  290. /** @var SharedProsperityRecommendConfigRepository $sharedProsperityRecommendConfigRepository */
  291. $sharedProsperityRecommendConfigRepository = app()->make(SharedProsperityRecommendConfigRepository::class);
  292. $sharedProsperityRecommendConfigEntityList = $sharedProsperityRecommendConfigRepository->getList();
  293. usort($sharedProsperityRecommendConfigEntityList, function (SharedProsperityRecommendConfigEntity $a, SharedProsperityRecommendConfigEntity $b) {
  294. return $a->getPv() <=> $b->getPv(); // 从小到大排序
  295. });
  296. $sharedProsperityUserEntityList = $this->getSharedProsperityUserEntityListByUserIdList($userIdList);
  297. // 批量更新用户等级
  298. $this->batchUpgradeUsers($sharedProsperityUserEntityList, $sharedProsperityRecommendConfigEntityList);
  299. // foreach ($sharedProsperityUserEntityList as $sharedProsperityUserEntity) {
  300. // $partnerLevel = 0;
  301. // foreach ($sharedProsperityRecommendConfigEntityList as $sharedProsperityRecommendConfigEntity) {
  302. // if ($sharedProsperityUserEntity->getPv() >= $sharedProsperityRecommendConfigEntity->getPv()) {
  303. // $partnerLevel = $sharedProsperityRecommendConfigEntity->getLevel();
  304. // } else {
  305. // // 如果本次验证的等级结果大于 之前的等级,说明用户升级了 需要更新等级
  306. // if ($partnerLevel > $sharedProsperityUserEntity->getPartnerLevel()) {
  307. // $this->updateByEntity(
  308. // SharedProsperityUserEntity::newInstance()
  309. // ->setId($sharedProsperityUserEntity->getId())
  310. // ->setPartnerLevel($partnerLevel)
  311. // );
  312. // }
  313. // break;
  314. // }
  315. // }
  316. // }
  317. }
  318. /**
  319. * 批量更新用户等级
  320. * @param SharedProsperityUserEntity[] $sharedProsperityUserEntityList 用户实体列表
  321. * @param SharedProsperityRecommendConfigEntity[] $sharedProsperityRecommendConfigEntityList 等级配置列表
  322. * @return void
  323. */
  324. private function batchUpgradeUsers(array $sharedProsperityUserEntityList, array $sharedProsperityRecommendConfigEntityList)
  325. {
  326. foreach ($sharedProsperityUserEntityList as $sharedProsperityUserEntity) {
  327. // // 计算用户的团队业绩(向下5级)
  328. // $teamPv = $this->calculateTeamPv($sharedProsperityUserEntity->getId());
  329. // 根据团队业绩确定等级
  330. // $newLevel = $this->calculateLevelByTeamPv($teamPv, $sharedProsperityRecommendConfigEntityList);
  331. //
  332. // // 如果新等级大于当前等级,则更新
  333. // if ($newLevel > $sharedProsperityUserEntity->getPartnerLevel()) {
  334. // $this->updateByEntity(
  335. // SharedProsperityUserEntity::newInstance()
  336. // ->setId($sharedProsperityUserEntity->getId())
  337. // ->setPartnerLevel($newLevel)
  338. // );
  339. // }
  340. // 暂时新增加逻辑 用户购买 298 商品后,自动升级为1星合伙人,目前只有消费者 能够获得PV值,在奖励结算时,判断订单金额 是否大于 298 并且 用户身份为 用户,则升级为一星合伙人
  341. // 逻辑修改,如果用户的身份 是普通用户,则统计他在共富区内 所有消费的金额,是否超 每天自增的 升级限制金额,如果超过则升级为1星合伙人
  342. if ($sharedProsperityUserEntity->getPartnerLevel() == 0) {
  343. /** @var StoreOrderRepository $storeOrderRepository */
  344. $storeOrderRepository = app()->make(StoreOrderRepository::class);
  345. $sumTotalPrice = $storeOrderRepository->getSumTotalPriceByUidAndMerId($sharedProsperityUserEntity->getUserId(), CommonEnum::DESIGN_MERCHANT_ID['SharedProsperity']['code']);
  346. if (!empty($sumTotalPrice)) {
  347. $partnerLevel = $sharedProsperityUserEntity->getPartnerLevel();
  348. /** @var SharedProsperityRecommendConfigRepository $sharedProsperityRecommendConfigRepository */
  349. $sharedProsperityRecommendConfigRepository = app()->make(SharedProsperityRecommendConfigRepository::class);
  350. $sharedProsperityRecommendConfigEntityList = $sharedProsperityRecommendConfigRepository->getList();
  351. usort($sharedProsperityRecommendConfigEntityList, function (SharedProsperityRecommendConfigEntity $a, SharedProsperityRecommendConfigEntity $b) {
  352. return $a->getLevel() <=> $b->getLevel(); // 从小到大排序
  353. });
  354. foreach ($sharedProsperityRecommendConfigEntityList as $sharedProsperityRecommendConfigEntity) {
  355. if (is_null($sharedProsperityRecommendConfigEntity->getConsume())) {
  356. continue;
  357. }
  358. if ($sumTotalPrice >= $sharedProsperityRecommendConfigEntity->getConsume() && $sharedProsperityUserEntity->getPartnerLevel() < $sharedProsperityRecommendConfigEntity->getLevel()) {
  359. // 修改用户的等级
  360. $sharedProsperityUserEntity->setPartnerLevel($sharedProsperityRecommendConfigEntity->getLevel());
  361. }
  362. }
  363. // 也就是说 升级了 保存到数据库
  364. if ($partnerLevel != $sharedProsperityUserEntity->getPartnerLevel()) {
  365. $this->updateByEntity(
  366. SharedProsperityUserEntity::newInstance()
  367. ->setId($sharedProsperityUserEntity->getId())
  368. ->setPartnerLevel($sharedProsperityUserEntity->getPartnerLevel())
  369. );
  370. }
  371. }
  372. }
  373. // 根据原来的团队升级规则,去升级推荐人等级
  374. $this->upgradeUpperLevels($sharedProsperityUserEntity->getUserId(), $sharedProsperityRecommendConfigEntityList);
  375. // 新的升级规则
  376. // 如果当前用户升级了 那要看一下他的上级 是否也需要升级
  377. if (!empty($sharedProsperityUserEntity->getParentId())) {
  378. $sharedProsperityUserEntityByParent = $this->getSharedProsperityUserEntityByUserId($sharedProsperityUserEntity->getParentId());
  379. if (!empty($sharedProsperityUserEntityByParent->getId()) && $sharedProsperityUserEntityByParent->getPartnerLevel() < 2) {
  380. $this->upgradeUpperLevelsByPromotionOne($sharedProsperityUserEntityByParent);
  381. }
  382. }
  383. }
  384. }
  385. /**
  386. * 向上追溯更新上级身份等级(最多向上5层)
  387. * @param int $userId 当前用户ID
  388. * @param SharedProsperityRecommendConfigEntity[] $sharedProsperityRecommendConfigEntityList 等级配置列表
  389. * @return void
  390. */
  391. private function upgradeUpperLevels(int $userId, array $sharedProsperityRecommendConfigEntityList)
  392. {
  393. $maxLevels = SharedProsperityUserEnum::TEAM_DEPTH;
  394. $currentUserId = $userId;
  395. for ($i = 0; $i < $maxLevels; $i++) {
  396. // 获取上级用户ID
  397. $sharedProsperityUserEntity = $this->getSharedProsperityUserEntityByUserId($currentUserId);
  398. $parentId = $sharedProsperityUserEntity->getParentId();
  399. if (empty($parentId)) {
  400. break; // 没有上级,停止追溯
  401. }
  402. // 重新计算上级的团队业绩和等级
  403. $this->upgradeSingleUser($parentId, $sharedProsperityRecommendConfigEntityList);
  404. // 继续向上追溯
  405. $currentUserId = $parentId;
  406. }
  407. }
  408. /**
  409. * 升级单个用户身份
  410. * @param int $userId 用户ID
  411. * @param SharedProsperityRecommendConfigEntity[] $sharedProsperityRecommendConfigEntityList 等级配置列表
  412. * @return void
  413. */
  414. private function upgradeSingleUser(int $userId, array $sharedProsperityRecommendConfigEntityList)
  415. {
  416. // 获取用户实体
  417. $sharedProsperityUserEntity = $this->getSharedProsperityUserEntityByUserId($userId);
  418. if (empty($sharedProsperityUserEntity->getId())) {
  419. return;
  420. }
  421. // 计算团队业绩
  422. $teamPvMap = $this->calculateTeamPv($userId);
  423. // 当前只计算团队业绩的 小团队业绩
  424. $maxKey = array_keys($teamPvMap, max($teamPvMap))[0];
  425. unset($teamPvMap[$maxKey]);
  426. $teamPvBySmallSum = array_sum($teamPvMap);
  427. // 计算新等级
  428. $newLevel = $this->calculateLevelByTeamPv($teamPvBySmallSum, $sharedProsperityRecommendConfigEntityList);
  429. // 如果新等级大于当前等级,则更新
  430. if ($newLevel > $sharedProsperityUserEntity->getPartnerLevel()) {
  431. $this->updateByEntity(
  432. SharedProsperityUserEntity::newInstance()
  433. ->setId($sharedProsperityUserEntity->getId())
  434. ->setPartnerLevel($newLevel)
  435. );
  436. }
  437. }
  438. /**
  439. * 计算用户的团队业绩(向下5级)
  440. * @param int $userId 用户ID
  441. * @return array 团队业绩
  442. */
  443. private function calculateTeamPv(int $userId): array
  444. {
  445. $teamPvMap = [];
  446. // 获取所有下级用户ID(向下5级)
  447. // 第一层级在这里查询 因为要统计大小区
  448. $sharedProsperityUserEntityListByParentId = $this->getSharedProsperityUserEntityListByParentId($userId);
  449. // 循环 直属下级
  450. foreach ($sharedProsperityUserEntityListByParentId as $sharedProsperityUserEntityByUnderling) {
  451. $departmentTeamUserIdList = $this->getUserIdListByParentIdForDepth($sharedProsperityUserEntityByUnderling->getUserId(), SharedProsperityUserEnum::TEAM_DEPTH - 1);
  452. $departmentTeamUserIdList[] = $sharedProsperityUserEntityByUnderling->getUserId();
  453. // 直属团队的 业绩总和
  454. $teamPv = '0.00';
  455. if (!empty($departmentTeamUserIdList)) {
  456. // 批量获取下级用户的个人业绩并求和
  457. // 假设有方法批量获取用户的PV
  458. $sharedProsperityUserEntityListByTeam = $this->getSharedProsperityUserEntityListByUserIdList($departmentTeamUserIdList);
  459. foreach ($sharedProsperityUserEntityListByTeam as $sharedProsperityUserEntityByTeam) {
  460. $teamPv = bcadd($teamPv, (string)$sharedProsperityUserEntityByTeam->getPv(), 2);
  461. }
  462. }
  463. $teamPvMap[$sharedProsperityUserEntityByUnderling->getUserId()] = $teamPv;
  464. }
  465. return $teamPvMap;
  466. }
  467. /**
  468. * 根据团队业绩计算等级
  469. * @param float $teamPv 团队业绩
  470. * @param array $configEntityList 等级配置列表
  471. * @return int 等级
  472. */
  473. private function calculateLevelByTeamPv(float $teamPv, array $configEntityList): int
  474. {
  475. $level = 0;
  476. foreach ($configEntityList as $configEntity) {
  477. if ($teamPv >= $configEntity->getPv()) {
  478. $level = $configEntity->getLevel();
  479. } else {
  480. break;
  481. }
  482. }
  483. return $level;
  484. }
  485. /**
  486. * 获取下级用户ID列表(向下指定层级)
  487. * @param int $parentId 用户ID
  488. * @param int $maxLevel 最大层级数
  489. * @param int $currentLevel 当前层级(内部递归使用)
  490. * @return array 下级用户ID列表
  491. */
  492. private function getUserIdListByParentIdForDepth(int $parentId, int $maxLevel, int $currentLevel = 1): array
  493. {
  494. if ($currentLevel > $maxLevel) {
  495. return [];
  496. }
  497. $subordinateIds = [];
  498. // 获取直接下级用户ID列表(假设有方法获取直接下级)
  499. $sharedProsperityUserEntityListByParentId = $this->getSharedProsperityUserEntityListByParentId($parentId);
  500. if (empty($sharedProsperityUserEntityListByParentId)) {
  501. return [];
  502. }
  503. // 添加直接下级
  504. $subordinateIds = array_merge($subordinateIds, array_column($sharedProsperityUserEntityListByParentId, 'userId'));
  505. // 递归获取下级的下级
  506. foreach ($sharedProsperityUserEntityListByParentId as $sharedProsperityUserEntity) {
  507. $nestedSubordinateIds = $this->getUserIdListByParentIdForDepth($sharedProsperityUserEntity->getUserId(), $maxLevel, $currentLevel + 1);
  508. if (!empty($nestedSubordinateIds)) {
  509. $subordinateIds = array_merge($subordinateIds, $nestedSubordinateIds);
  510. }
  511. }
  512. return array_unique($subordinateIds);
  513. }
  514. /**
  515. * 获取用户树
  516. * @param int $userId 用户ID
  517. * @return array 用户树,格式:[{name: '张三', parent: null, children: [...]}]
  518. */
  519. public function getUserTree($userId)
  520. {
  521. /** @var SharedProsperityUserDao $shareUserDao */
  522. $shareUserDao = app()->make(SharedProsperityUserDao::class);
  523. // 获取所有下级用户ID(包括自己)
  524. $subordinateIds = $shareUserDao->getAllSubordinateUserIds($userId, true);
  525. if (empty($subordinateIds)) {
  526. return [];
  527. }
  528. // 获取这些共富用户的基本信息(包含parent_id)
  529. $sharedUsers = $shareUserDao->getSharedProsperityUserEntityListByUserIdList($subordinateIds);
  530. if (empty($sharedUsers)) {
  531. return [];
  532. }
  533. // 用户身份
  534. $partnerLevel = [
  535. 0 => '用户',
  536. 1 => '一星合伙人',
  537. 2 => '二星合伙人',
  538. 3 => '三星合伙人',
  539. 4 => '钻石合伙人',
  540. 5 => '总裁合伙人',
  541. 6 => '联席主席团',
  542. ];
  543. // 获取用户昵称映射
  544. $userIds = array_map(function ($entity) {
  545. return $entity->getUserId();
  546. }, $sharedUsers);
  547. /** @var UserDao $userDao */
  548. $userDao = app()->make(UserDao::class);
  549. $userInfos = $userDao->getUserEntityListByUidList($userIds);
  550. $idToName = [];
  551. foreach ($userInfos as $userInfo) {
  552. $sharedUserInfo = $shareUserDao->getSharedProsperityUserEntityListByUserIdList([$userInfo->getUid()]);
  553. $idToName[$userInfo->getUid()] = $userInfo->getNickname() . '(' . $userInfo->account . ')(身份:' . $partnerLevel[$sharedUserInfo[0]->getPartnerLevel()] . ')' ?? ('用户' . $userInfo->getUid());
  554. }
  555. // 构建节点数组
  556. $nodes = [];
  557. foreach ($sharedUsers as $sharedUser) {
  558. $nodes[] = [
  559. 'user_id' => $sharedUser->getUserId(),
  560. 'parent_id' => $sharedUser->getParentId(),
  561. 'name' => $idToName[$sharedUser->getUserId()] ?? ('用户' . $sharedUser->getUserId()),
  562. ];
  563. }
  564. // 构建树,以传入的用户为根节点
  565. $rootNode = $this->findNode($nodes, $userId);
  566. if (!$rootNode) {
  567. return [];
  568. }
  569. $tree = [
  570. 'name' => $rootNode['name'],
  571. 'parent' => null,
  572. 'children' => $this->buildSharedTree($nodes, $userId)
  573. ];
  574. return [$tree];
  575. }
  576. /**
  577. * 递归构建共富用户树
  578. * @param array $nodes 节点数组,每个节点包含 user_id, parent_id, name
  579. * @param int $parentId 父ID
  580. * @return array
  581. */
  582. private function buildSharedTree($nodes, $parentId)
  583. {
  584. $branch = [];
  585. foreach ($nodes as $node) {
  586. if ($node['parent_id'] == $parentId) {
  587. $children = $this->buildSharedTree($nodes, $node['user_id']);
  588. $branch[] = [
  589. 'name' => $node['name'],
  590. 'parent' => $this->findNodeName($nodes, $parentId) ?? null,
  591. 'children' => $children
  592. ];
  593. }
  594. }
  595. return $branch;
  596. }
  597. /**
  598. * 根据user_id查找节点名称
  599. * @param array $nodes
  600. * @param int $userId
  601. * @return string|null
  602. */
  603. private function findNodeName($nodes, $userId)
  604. {
  605. foreach ($nodes as $node) {
  606. if ($node['user_id'] == $userId) {
  607. return $node['name'];
  608. }
  609. }
  610. return null;
  611. }
  612. /**
  613. * 根据user_id查找节点
  614. * @param array $nodes
  615. * @param int $userId
  616. * @return array|null
  617. */
  618. private function findNode($nodes, $userId)
  619. {
  620. foreach ($nodes as $node) {
  621. if ($node['user_id'] == $userId) {
  622. return $node;
  623. }
  624. }
  625. return null;
  626. }
  627. public function adminList($params)
  628. {
  629. $page = $params['page'] ?? 1;
  630. $where = [];
  631. /** @var UserDao $userDao */
  632. $userDao = app()->make(UserDao::class);
  633. // 手机号搜索
  634. if (isset($params['account']) && $params['account']) {
  635. $params['account'] = '%' . $params['account'] . '%';
  636. $userData = $userDao->accountLikeByUser($params['account']);
  637. $uids = [];
  638. if ($userData) {
  639. $uids = array_column($userData, 'uid');
  640. }
  641. $where[] = ['a.user_id', 'in', $uids];
  642. }
  643. // 昵称搜索
  644. if (isset($params['nickname']) && $params['nickname']) {
  645. $params['nickname'] = '%' . $params['nickname'] . '%';
  646. $userData = $userDao->nicknameLikeByUser($params['nickname']);
  647. $uids = [];
  648. if ($userData) {
  649. $uids = array_column($userData, 'uid');
  650. }
  651. $where[] = ['a.user_id', 'in', $uids];
  652. }
  653. // 合伙人等级搜索
  654. if (isset($params['partner_level']) && $params['partner_level']) {
  655. $where[] = ['a.partner_level', '=', $params['partner_level']];
  656. }
  657. // 共富团等级搜索
  658. if (isset($params['user_group']) && $params['user_group']) {
  659. // /** @var SharedProsperityGroupUserDao $groupUserDao */
  660. // $groupUserDao = app()->make(SharedProsperityGroupUserDao::class);
  661. // $groupUserData = $groupUserDao->getUserByLevel($params['user_group']);
  662. // $uids = array_column($groupUserData['data'], 'user_id');
  663. // $where[] = ['user_id', 'in', $uids];
  664. // $page = 1;
  665. $where[] = ['b.group_id', '=', $params['user_group']];
  666. }
  667. $list = $this->dao->adminList($where, $page);
  668. return $list;
  669. }
  670. /**
  671. * @param $userId
  672. * @param $level
  673. * @return int
  674. * @author 史晨
  675. * @date 2026/2/27 14:23
  676. * 更新用户等级
  677. */
  678. public function updateLevel($userId, $level)
  679. {
  680. return $this->dao->updateByUserId($userId, ['partner_level' => $level]);
  681. }
  682. /**
  683. * @param $userId
  684. * @param $type
  685. * @param $number
  686. * @return bool
  687. * @author 史晨
  688. * @date 2026/2/27 15:16
  689. * 更新用户奖励
  690. */
  691. public function updateReward($userId, $type, $number)
  692. {
  693. $map = [
  694. 1001 => 'consumer_stocks',
  695. 1002 => 'withdrawal_limit',
  696. 1003 => 'pv'
  697. ];
  698. try {
  699. Db::startTrans();
  700. $pm = 1;
  701. $remark = '后台操作增加' . $number;
  702. if ($number < 0) {
  703. $pm = 0;
  704. $remark = '后台操作减少' . abs($number);
  705. }
  706. if (isset($map[$type])) {
  707. // 更新数据
  708. $this->dao->updateRewardByUserId($userId, $map[$type], $number);
  709. // 记录日志
  710. $insertData = [
  711. 'user_id' => $userId,
  712. 'type' => $type,
  713. 'pm' => $pm,
  714. 'number' => abs($number),
  715. 'balance' => 0,
  716. 'status' => SharedProsperityRewardRecordEnum::STATUS['VALID']['code'],
  717. 'type_shop' => SharedProsperityRewardRecordEnum::TYPE_SHOP['Platform']['code'],
  718. 'order_sn' => 0,
  719. 'take_time' => date('Y-m-d H:i:s', time()),
  720. 'remark' => $remark,
  721. 'create_time' => date('Y-m-d H:i:s', time()),
  722. 'update_time' => date('Y-m-d H:i:s', time()),
  723. ];
  724. /** @var SharedProsperityRewardRecordDao $rewardRecordDao */
  725. $rewardRecordDao = app()->make(SharedProsperityRewardRecordDao::class);
  726. $rewardRecordDao->insertAll([$insertData]);
  727. } else {
  728. // 更新数据
  729. /** @var UserDao $userDao */
  730. $userDao = app()->make(UserDao::class);
  731. $userDao->updateBrokeragePriceByUid($userId, $number);;
  732. // 记录日志
  733. $bill = [
  734. 'uid' => $userId,
  735. 'link_id' => 0,
  736. 'pm' => $pm,
  737. 'title' => $remark,
  738. 'category' => 'now_money',
  739. 'type' => 'commission',
  740. 'number' => abs($number),
  741. 'balance' => 0,
  742. 'mark' => $remark,
  743. 'create_time' => date('Y-m-d H:i:s'),
  744. 'status' => 1,
  745. 'commission_type' => CommonEnum::COMMISSION_TYPE['SHARED_PROSPERITY_PARTNER_COMMISSION']['code'],
  746. 'order_sn' => 0,
  747. 'tripartite' => 0,
  748. 'type_shop' => 0,
  749. 'mer_id' => 0,
  750. 'source' => 0,
  751. 'order_type' => 1,
  752. 'is_red_brokerage' => 0,
  753. 'gzc' => 3,
  754. 'take_time' => time(),
  755. 'district_id' => '',
  756. 'street_id' => '',
  757. 'month' => '',
  758. ];
  759. Db::name('user_bill')->insert($bill);
  760. }
  761. Db::commit();
  762. return true;
  763. } catch (\Exception $e) {
  764. Db::rollback();
  765. return false;
  766. }
  767. }
  768. /**
  769. * 第一次促销的 身份 升级方法
  770. * @param SharedProsperityUserEntity $sharedProsperityUserEntity
  771. * @return void
  772. */
  773. public function upgradeUpperLevelsByPromotionOne(SharedProsperityUserEntity $sharedProsperityUserEntity)
  774. {
  775. // 判断当前用户 是否在共富区的消费值 > 298,如果不满足则不能升级
  776. /** @var StoreOrderRepository $storeOrderRepository */
  777. $storeOrderRepository = app()->make(StoreOrderRepository::class);
  778. $sumTotalPrice = $storeOrderRepository->getSumTotalPriceByUidAndMerId($sharedProsperityUserEntity->getUserId(), CommonEnum::DESIGN_MERCHANT_ID['SharedProsperity']['code']);
  779. if ($sumTotalPrice < 298) {
  780. return;
  781. }
  782. // 查询当前用户的直属下级
  783. $sharedProsperityUserEntityListByChild = $this->getSharedProsperityUserEntityListByParentId($sharedProsperityUserEntity->getUserId());
  784. // 一星合伙人数量
  785. $oneStarPartner = 0;
  786. // 二星合伙人数量
  787. $twoStarPartner = 0;
  788. foreach ($sharedProsperityUserEntityListByChild as $sharedProsperityUserEntityByChild) {
  789. if ($sharedProsperityUserEntityByChild->getPartnerLevel() >= 1) {
  790. $oneStarPartner++;
  791. if ($sharedProsperityUserEntityByChild->getPartnerLevel() >= 2) {
  792. $twoStarPartner++;
  793. }
  794. }
  795. }
  796. // 推荐 6 个 2星以上的合伙人 增加万人团身份
  797. if ($twoStarPartner >= 6) {
  798. /** @var SharedProsperityGroupUserRepository $sharedProsperityGroupUserRepository */
  799. $sharedProsperityGroupUserRepository = app()->make(SharedProsperityGroupUserRepository::class);
  800. $sharedProsperityGroupUserEntity = $sharedProsperityGroupUserRepository->getSharedProsperityGroupUserEntityByUserId($sharedProsperityUserEntity->getUserId());
  801. if (empty($sharedProsperityGroupUserEntity->getId())) {
  802. // 如果没有共富团身份 则增加共富团 万人团身份
  803. $sharedProsperityGroupUserRepository->createByEntity(
  804. SharedProsperityGroupUserEntity::newInstance()
  805. ->setUserId($sharedProsperityUserEntity->getUserId())
  806. ->setGroupId(1)
  807. ->setStatus(1)
  808. );
  809. }
  810. }
  811. // 推荐 6 个 1星以上的合伙人 则升级为 2 星合伙人
  812. if ($sharedProsperityUserEntity->getPartnerLevel() < 2 && $oneStarPartner >= 6) {
  813. $this->updateByEntity(
  814. SharedProsperityUserEntity::newInstance()
  815. ->setId($sharedProsperityUserEntity->getId())
  816. ->setPartnerLevel(2)
  817. );
  818. // 如果当前用户升级了 那要看一下他的上级 是否也需要升级
  819. if (!empty($sharedProsperityUserEntity->getParentId())) {
  820. $sharedProsperityUserEntityByParent = $this->getSharedProsperityUserEntityByUserId($sharedProsperityUserEntity->getParentId());
  821. if (!empty($sharedProsperityUserEntityByParent->getId()) && $sharedProsperityUserEntityByParent->getPartnerLevel() < 2) {
  822. $this->upgradeUpperLevelsByPromotionOne($sharedProsperityUserEntityByParent);
  823. }
  824. }
  825. }
  826. }
  827. }