SharedProsperityUserRepository.php 38 KB

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