Test.php 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. <?php
  2. namespace app\controller\api;
  3. use app\common\dao\shared\SharedProsperityUserDao;
  4. use app\common\enum\CommonEnum;
  5. use app\common\enum\shared\SharedProsperityRewardRecordEnum;
  6. use app\common\model\shared\SharedProsperityUser;
  7. use app\common\repositories\shared\SharedProsperityRecommendConfigRepository;
  8. use app\common\repositories\shared\SharedProsperityUserRepository;
  9. use app\common\repositories\store\order\StoreGroupOrderRepository;
  10. use app\common\repositories\store\order\StoreOrderRepository;
  11. use app\common\repositories\user\UserRepository;
  12. use app\common\repositories\user\UserSignXfbRepository;
  13. use app\traits\GzcApiRequest;
  14. use think\facade\Db;
  15. class Test
  16. {
  17. public function test()
  18. {
  19. /** @var StoreGroupOrderRepository $storeGroupOrderRepository */
  20. $storeGroupOrderRepository = app()->make(StoreGroupOrderRepository::class);
  21. $groupOrderId = '11135';
  22. $res = $storeGroupOrderRepository->storeGroupOrderPaySuccess($groupOrderId);
  23. dd($res);
  24. /** @var UserSignXfbRepository $xfbRepository */
  25. $xfbRepository = app()->make(UserSignXfbRepository::class);
  26. // 结算
  27. $res = $xfbRepository->settlement(['wx177572166462040882']);
  28. dd($res);
  29. $a = bcmul(99, CommonEnum::ORDER_EARNING_ALLOCATION['WonderfulLiving']['Lock']['BrokeragePrice']['Ratio']['code'], CommonEnum::CALCULATE_THE_NUMBER_OF_DECIMAL_PLACES);
  30. $b = bcmul(198, CommonEnum::ORDER_EARNING_ALLOCATION['WonderfulLiving']['Lock']['BrokeragePrice']['Ratio']['code'], CommonEnum::CALCULATE_THE_NUMBER_OF_DECIMAL_PLACES);
  31. dd($a,$b);
  32. // /** @var SharedProsperityRecommendConfigRepository $sharedProsperityRecommendConfigRepository */
  33. // $sharedProsperityRecommendConfigRepository = app()->make(SharedProsperityRecommendConfigRepository::class);
  34. // $sharedProsperityRecommendConfigEntityByMaxRewardRatio = $sharedProsperityRecommendConfigRepository->getSharedProsperityRecommendConfigEntityByMaxRewardRatio();
  35. // // 利润 减去 顶格的直推奖,剩下的是PV值
  36. // $pvProportion = bcsub('1', bcdiv($sharedProsperityRecommendConfigEntityByMaxRewardRatio->getRewardRatio(), '100', 4), 2);
  37. // dd($pvProportion);
  38. // // 1、获取订单数据
  39. // /** @var StoreGroupOrderRepository $storeGroupOrderRepository */
  40. // $storeGroupOrderRepository = app()->make(StoreGroupOrderRepository::class);
  41. // // 获取订单组数据
  42. // $groupOrderSn = 'wx177442719463317087';
  43. // $storeGroupOrderEntity = $storeGroupOrderRepository->getStoreGroupOrderEntityByGroupOrderSn($groupOrderSn);
  44. // /** @var StoreOrderRepository $storeOrderRepository */
  45. // $storeOrderRepository = app()->make(StoreOrderRepository::class);
  46. // // 获取订单集合
  47. // $storeOrderEntityList = $storeOrderRepository->getStoreOrderEntityListByGroupOrderId($storeGroupOrderEntity->getGroupOrderId());
  48. // try {
  49. // Db::transaction(function () use (
  50. // $storeGroupOrderRepository,
  51. // $storeGroupOrderEntity
  52. // ) {
  53. // $storeGroupOrderRepository->storeGroupOrderPaySuccess($storeGroupOrderEntity->getGroupOrderId());
  54. // });
  55. // } catch (\Throwable $e) {
  56. // Db::name("log")
  57. // ->insert([
  58. // 'data' => '【订单支付回调】【结算订单失败】:时间:' . date('Y-m-d H:i:s', time()) . ';订单编号:1111订单失败原因:' . json_encode([
  59. // 'error_message' => $e->getMessage(),
  60. // 'error_file' => $e->getFile(),
  61. // 'error_line' => $e->getLine(),
  62. // 'error_code' => $e->getCode(),
  63. // 'exception_class' => get_class($e),
  64. // 'trace' => $e->getTraceAsString()
  65. // ], JSON_UNESCAPED_UNICODE)
  66. // ]);
  67. // dd($e->getMessage());
  68. // }
  69. //
  70. //
  71. // die;
  72. //
  73. // $title = '系统补贴';
  74. // $map = [
  75. // 294 => 165,
  76. // 186 => 860
  77. // ];
  78. //
  79. // foreach ($map as $uid => $money) {
  80. // $bill = [
  81. // 'uid' => $uid,
  82. // 'link_id' => 0,
  83. // 'pm' => 1,
  84. // 'title' => $title,
  85. // 'category' => 'now_money',
  86. // 'type' => 'commission',
  87. // 'number' => $money,
  88. // 'balance' => 0,
  89. // 'mark' => $title,
  90. // 'create_time' => date('Y-m-d H:i:s'),
  91. // 'status' => 1,
  92. // 'commission_type' => CommonEnum::COMMISSION_TYPE['SYSTEM_SUBSIDY_COMMISSION']['code'],
  93. // 'order_sn' => 0,
  94. // 'tripartite' => 0,
  95. // 'type_shop' => 0,
  96. // 'mer_id' => 0,
  97. // 'source' => 0,
  98. // 'order_type' => 1,
  99. // 'is_red_brokerage' => 0,
  100. // 'gzc' => 3,
  101. // 'take_time' => time(),
  102. // 'district_id' => '',
  103. // 'street_id' => '',
  104. // 'month' => '',
  105. // ];
  106. // $a = Db::name('user_bill')->insert($bill);
  107. //
  108. // $b = Db::name('user')->where('uid', $uid)->inc('brokerage_price', $money)->update();
  109. // }
  110. // die;
  111. // $sharedUserPvCount = Db::name('shared_prosperity_reward_record')
  112. // ->where(['type' => SharedProsperityRewardRecordEnum::TYPE['PV']['code'], 'status' => SharedProsperityRewardRecordEnum::STATUS['VALID']['code'], 'pm' => SharedProsperityRewardRecordEnum::PM['INCOME']['code']])
  113. // ->whereNotIn('user_id',$testUids)
  114. // ->sum('number'); // 共富会员专区总业绩
  115. // dd($sharedUserPvCount);
  116. // die;
  117. //
  118. $total = 2756.48;
  119. $map = [
  120. 1 => 0.3,
  121. 2 => 0.15,
  122. 3 => 0.03,
  123. 4 => 0.015,
  124. ];
  125. $groupMap = [
  126. 1 => 0.1,
  127. 2 => 0.2
  128. ];
  129. $testUids = Db::name('user')->where('test_user', '1')->column('uid');
  130. $users = Db::name('shared_prosperity_user')->whereNotIn('user_id',$testUids)->group('partner_level')->field('partner_level,count(*) as num')->select()->toArray();
  131. $res = [];
  132. foreach ($users as $user) {
  133. if ($user['partner_level'] == 0 || $user['partner_level'] == 5) {
  134. continue;
  135. }
  136. $res[$user['partner_level']] = [
  137. 'num' => $user['num'],
  138. 'money' => $total * $map[$user['partner_level']] / $user['num']
  139. ];
  140. }
  141. $groupRes = [];
  142. $groupUsers = Db::name('shared_prosperity_group_user')->whereNotIn('user_id',$testUids)->group('group_id')->field('group_id,count(*)as num')->select()->toArray();
  143. foreach ($groupUsers as $groupUser) {
  144. $groupRes[$groupUser['group_id']] = [
  145. 'num' => $groupUser['num'],
  146. 'money' => $total * $groupMap[$groupUser['group_id']] / $groupUser['num']
  147. ];
  148. }
  149. dd($res, $groupRes);
  150. // 18201226770 4858下的单 改成 13716268932 5064下单
  151. // 上下级关系正确
  152. // 订单所属已修改
  153. // 订单产生的共富奖励已修改
  154. // 佣金修改
  155. // 查询团队业绩
  156. // $ids = [
  157. // 1213
  158. // ];
  159. // $res = [];
  160. // foreach ($ids as $id) {
  161. // /** @var SharedProsperityUserDao $dao */
  162. // $dao = app()->make(SharedProsperityUserDao::class);
  163. // $userIds = $dao->getAllSubordinateUserIds($id,true,5);
  164. // /** @var SharedProsperityUser $model */
  165. // $sum = SharedProsperityUser::getDB()
  166. // ->whereIn('user_id', $userIds)
  167. // ->sum('pv');
  168. // $res[$id] = $sum;
  169. // }
  170. // dd($res);
  171. /** @var SharedProsperityUserRepository $userRepository */
  172. $userRepository = app()->make(SharedProsperityUserRepository::class);
  173. $list = $userRepository->getUserTree(294);
  174. // var_dump(json_encode($list));
  175. // $field = request()->param('field');
  176. // /** @var UserRepository $userRepository */
  177. // $userRepository = app()->make(UserRepository::class);
  178. // $list = $userRepository->getUserForTree($field, 0);
  179. var_dump(json_encode($list));
  180. // return app('json')->success($list);
  181. }
  182. }