| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144 |
- <?php
- namespace app\controller\api\store\merchant;
- use app\common\enum\CommonEnum;
- use app\common\enum\dividend\DividendLogEnum;
- use app\common\repositories\dividend\DividendLogRepository;
- use app\entity\data\dividend\DividendLogEntity;
- use think\db\exception\DataNotFoundException;
- use think\db\exception\DbException;
- use think\db\exception\ModelNotFoundException;
- use think\facade\Db;
- use think\facade\Log;
- use think\Request;
- class TaskPartnerProfits
- {
- public function getTime($timePeriod)
- {
- // 定义时间区间
- $now = time();
- $startTime = '';
- $endTime = '';
- if ($timePeriod == 'last_week') {
- // 上周的时间区间
- $startTime = date('Y-m-d', strtotime('monday last week', $now)); // 上周星期一的开始时间
- $endTime = date('Y-m-d', strtotime('sunday last week', $now)); // 上周星期日的结束时间
- } elseif ($timePeriod == 'this_week') {
- // 这周的时间区间
- $startTime = date('Y-m-d', strtotime('monday this week', $now)); // 这周星期一的开始时间
- $endTime = date('Y-m-d', strtotime('sunday this week', $now)); // 这周星期日的结束时间
- }
- // return ['startTime' => '2025-03-10', 'endTime' => '2025-03-23'];
- return ['startTime' => $startTime, 'endTime' => $endTime];
- }
- public function getTeamPvByTime($startTime, $endTime, $removeUserIdList = [])
- {
- // 查询指定时间区间内的所有订单,并排除 pay_time 为 NULL 的订单
- $orders = Db::name("store_order")
- ->alias('a')
- ->where('a.mer_id', 496)
- ->whereNotIn('a.uid', $removeUserIdList)
- ->whereIn('a.status', [0, 1, 2, 3])
- // ->whereIn("a.total_price", [1180, 11800, 10620, 2360, 9440])
- ->whereBetween("a.pay_time", [$startTime, $endTime])
- ->whereNotNull("a.pay_time") // 排除 pay_time 为 NULL 的订单
- ->leftJoin('rrx_store_cart b', 'a.cart_id = b.cart_id')
- ->field('a.mer_id, a.cart_id, a.status, a.pay_time, a.total_price, b.product_id')
- ->select();
- // 计算总业绩
- $totalPv = 0;
- foreach ($orders as $order) {
- switch ($order['product_id']) {
- case in_array($order['product_id'], [15762, 15763]):
- $totalPv += 700;
- break;
- case in_array($order['product_id'], [15813, 15820]):
- $totalPv += 7000;
- break;
- case in_array($order['product_id'], [15814, 15819]):
- $totalPv += 6300;
- break;
- case in_array($order['product_id'], [15815, 15817]):
- $totalPv += 1400;
- break;
- case in_array($order['product_id'], [15816, 15818]):
- $totalPv += 5600;
- break;
- case in_array($order['product_id'], [17610]):
- $totalPv += 35;
- break;
- case in_array($order['product_id'], [17611]):
- $totalPv += 175;
- break;
- case in_array($order['product_id'], [17612]):
- $totalPv += 350;
- break;
- }
- }
- return $totalPv;
- }
- /**
- * 获取周期内 所有 有效的下单人ID列表
- * @param $startTime
- * @param $endTime
- * @param array $removeUserIdList
- * @return array
- */
- public function getOrderUidListByTime($startTime, $endTime, array $removeUserIdList = []): array
- {
- $orderUidMap = [];
- try {
- // 本地订单
- $storeOrder = Db::name("store_order")
- ->where('mer_id', '<>', CommonEnum::DESIGN_MERCHANT_ID['Repurchase']['code'])
- ->whereNotIn('uid', $removeUserIdList)
- ->whereIn('status', [0, 1, 2, 3])
- ->whereBetween("pay_time", [$startTime, $endTime])
- ->whereNotNull("pay_time") // 排除 pay_time 为 NULL 的订单
- ->field('mer_id, status, pay_time, total_price, uid, order_id, order_sn')
- ->select()
- ->toArray();
- foreach ($storeOrder as $order) {
- $orderUidMap[$order['uid']][] = ['orderTable' => 'store_order', 'orderId' => $order['order_id'], 'orderSn' => $order['order_sn']];
- }
- // $storeOrderUidList = array_column($storeOrder, 'uid');
- // $uidList = array_merge($uidList, $storeOrderUidList);
- // 话费订单 order_huafei
- $orderHuafei = Db::name("order_huafei")
- ->whereNotIn('uid', $removeUserIdList)
- ->where('status', '<>', 0) // 只要不是待支付的 即算是有效活跃度
- ->whereBetween("finish_time", [$startTime, $endTime])
- ->field('order_huafei_id, uid, status, finish_time, amount_price, order_sn')
- ->select()
- ->toArray();
- foreach ($orderHuafei as $order) {
- $orderUidMap[$order['uid']][] = ['orderTable' => 'order_huafei', 'orderId' => $order['order_huafei_id'], 'orderSn' => $order['order_sn']];
- }
- // $orderHuafeiUidList = array_column($orderHuafei, 'uid');
- // $uidList = array_merge($uidList, $orderHuafeiUidList);
- // 三方订单
- // 京东
- $orderJd = Db::name("order_jd")
- ->whereNotIn('uid', $removeUserIdList)
- ->where('status', '<>', 15) // 只要不是待支付的 即算是有效活跃度
- ->whereBetween("create_time", [$startTime, $endTime])
- ->field('order_jd_id, uid, status, create_time, price, order_sn')
- ->select()
- ->toArray();
- foreach ($orderJd as $order) {
- $orderUidMap[$order['uid']][] = ['orderTable' => 'order_jd', 'orderId' => $order['order_jd_id'], 'orderSn' => $order['order_sn']];
- }
- // $orderJdUidList = array_column($orderJd, 'uid');
- // $uidList = array_merge($uidList, $orderJdUidList);
- // 淘宝
- $orderTb = Db::name("order_tb")
- ->whereNotIn('uid', $removeUserIdList)
- // ->where('status', '<>', 15) // 只要不是待支付的 即算是有效活跃度 不能明确状态信息
- ->whereBetween("create_time", [$startTime, $endTime])
- ->field('order_tb_id, uid, tk_status, create_time, pay_price, order_sn')
- ->select()
- ->toArray();
- foreach ($orderTb as $order) {
- $orderUidMap[$order['uid']][] = ['orderTable' => 'order_tb', 'orderId' => $order['order_tb_id'], 'orderSn' => $order['order_sn']];
- }
- // $orderTbUidList = array_column($orderTb, 'uid');
- // $uidList = array_merge($uidList, $orderTbUidList);
- // 拼多多
- $orderPdd = Db::name("order_pdd")
- ->whereNotIn('uid', $removeUserIdList)
- ->where('pin_order_status', '<>', -1) // 只要不是待支付的 即算是有效活跃度 不能明确状态信息
- ->whereBetween("group_time", [strtotime($startTime), strtotime($endTime)])
- ->field('order_pdd_id, uid, pin_order_status, create_time, pay_money, order_sn')
- ->select()
- ->toArray();
- foreach ($orderPdd as $order) {
- $orderUidMap[$order['uid']][] = ['orderTable' => 'order_pdd', 'orderId' => $order['order_pdd_id'], 'orderSn' => $order['order_sn']];
- }
- // $orderPddUidList = array_column($orderPdd, 'uid');
- // $uidList = array_merge($uidList, $orderPddUidList);
- // 唯品会
- $orderVip = Db::name("order_vip")
- ->whereNotIn('uid', $removeUserIdList)
- ->where('status', '<>', 0) // 只要不是待支付的 即算是有效活跃度 不能明确状态信息
- ->whereBetween("order_time", [strtotime($startTime), strtotime($endTime)])
- ->field('order_vip_id, uid, status, order_time, pay_money, order_sn')
- ->select()
- ->toArray();
- foreach ($orderVip as $order) {
- $orderUidMap[$order['uid']][] = ['orderTable' => 'order_vip', 'orderId' => $order['order_vip_id'], 'orderSn' => $order['order_sn']];
- }
- // $orderVipUidList = array_column($orderVip, 'uid');
- // $uidList = array_merge($uidList, $orderVipUidList);
- } catch (DataNotFoundException|ModelNotFoundException|DbException $e) {
- Log::error('分红-获取下单用户列表失败:' . json_encode([
- 'error_message' => $e->getMessage(),
- 'error_file' => $e->getFile(),
- 'error_line' => $e->getLine(),
- 'error_code' => $e->getCode(),
- 'exception_class' => get_class($e),
- 'trace' => $e->getTraceAsString()
- ], JSON_UNESCAPED_UNICODE));
- }
- return $orderUidMap;
- }
- public function getRedEnvelopeByTime($startTime, $endTime, $removeUserIdList = [])
- {
- // 查询指定时间区间内的所有订单,并排除 pay_time 为 NULL 的订单
- $redEnvelopeList = Db::name("user_sign_hongbao")
- ->whereNotIn('uid', $removeUserIdList)
- ->where('status', 1)
- ->whereBetween("settlement_time", [$startTime, $endTime])
- ->select()
- ->toArray();
- return floor(array_sum(array_column($redEnvelopeList, 'number')) * 100) / 100;
- }
- public function partnerProfits(Request $request)
- {
- // 由于分红错误 需要对数据进行撤回
- // $user_bill_list = Db::name("user_bill")
- // ->where("title", '合伙人分佣')
- // ->where("status", 1)
- // ->whereBetween('create_time', ['2025-04-07 16:46:56', '2025-04-07 16:47:02'])
- // ->select()
- // ->toArray();
- // $user_bill_uid_list = array_column($user_bill_list, null, 'uid');
- //
- // $user_sign_fugou_list = Db::name("user_sign_fugou")
- // ->where("mark", '复购金')
- // ->where("status", 1)
- // ->whereBetween('settlement_time', ['2025-04-07 16:46:56', '2025-04-07 16:47:02'])
- // ->select()
- // ->toArray();
- // $user_sign_fugou_uid_list = array_column($user_sign_fugou_list, null, 'uid');
- //
- // $old_user_weekaward_list = Db::name("old_user_weekaward")
- //// ->where("mark", '复购金')
- //// ->where("status", 1)
- // ->whereBetween('create_time', [1744015616, 1744015622])
- // ->select()
- // ->toArray();
- // $old_user_weekaward_list = array_column($old_user_weekaward_list, null, 'uid');
- // return json($user_bill_list);
- $startTime = $request->param('startTime', null);
- $endTime = $request->param('endTime', null);
- $remark = $request->param('remark', '');
- $isTest = $request->param('isTest', 1);
- $maxAllocationAmount = $request->param('maxAllocationAmount', null);
- // 查询测试人员账号信息
- //18973958920
- //15186694339
- //18833633835
- //19525470098
- //17756507016
- //18226705337
- $testAccount = ['18973958920', '15186694339', '18833633835', '19525470098', '17756507016', '18226705337', '17855366921'];
- $removeUserList = Db::name("user")
- ->whereIn('account', $testAccount)
- ->where("status", "<>", 0)
- ->where('is_del', '<>', 1)
- ->select()
- ->toArray();
- $removeUserIdList = array_column($removeUserList, 'uid');
- $zeroLineUidList = [1420, 2328, 1720, 3];
- foreach ($zeroLineUidList as $uid) {
- //查询当前团队的用户列表
- $sql = "select getUserLevelId($uid) as uids";
- //\think\facade\Log::info("lplpDB".$sql);
- try {
- $spread_user_list = Db::query($sql);
- } catch (\Exception $exception) {
- return app('json')->fail($exception->getMessage());
- }
- $removeUserIdList = array_merge(explode(",", trim($spread_user_list[0]['uids'], '$,')), $removeUserIdList);
- }
- if (empty($startTime) || empty($endTime)) {
- $timeMap = $this->getTime('last_week');
- $startTime = $timeMap['startTime'] . ' 00:00:00';
- $endTime = $timeMap['endTime'] . ' 23:59:59';
- }
- // 定义分红金额
- $performance = $this->getTeamPvByTime($startTime, $endTime, $removeUserIdList);
- // 分红金额 - 红包金额
- $redEnvelope = $this->getRedEnvelopeByTime($startTime, $endTime, $removeUserIdList);
- $weekRecord = bcsub($performance, $redEnvelope, 2);
- if (!is_null($maxAllocationAmount)) {
- $weekRecord = $maxAllocationAmount;
- }
- if ($weekRecord <= 0) {
- return app('json')->fail('无效分红金额');
- }
- // 1、获取用户星级信息
- //$star_list = Db::name("user_star")->order("statement_all_num desc")->select()->toArray();//旧星级等级
- $starList = Db::name("old_user_starlevel")
- ->whereIn('title', ['初级', '中级', '高级'])
- ->order("statement_all_num desc")
- ->select()
- ->toArray();//星级等级
- // 组装日志信息
- /** @var DividendLogEntity $dividendLogEntity */
- $dividendLogEntity = DividendLogEntity::newInstance();
- $dividendLogEntity->setType(DividendLogEnum::TYPE['PartnerProfit']['code'])
- ->setStartTime($startTime)
- ->setEndTime($endTime)
- ->setPerformance($performance)
- ->setAbatement(json_encode([['code' => 'redEnvelope', 'name' => '红包', 'reason' => '发放的红包金额,需要从赚取的业绩中扣除', 'number' => $redEnvelope]]))
- ->setAllocated($weekRecord)
- ->setRule(json_encode($starList))
- ->setIsTest($isTest)
- ->setRemark($remark);
- // 2、循环星级信息 并分组归类
- $salesArr = array_column($starList, null, 'title');
- // 3、获取 分红用户 信息 (`user_group` tinyint(1) DEFAULT '1' COMMENT '1消费者 2,推广业务员 3,业务经理 4初级合伙人5中级合伙人 6高级合伙人 7.懂事',)
- $list = Db::name("user")
- ->whereNotIn('uid', $removeUserIdList)
- ->where("user_group", "IN", [4, 5, 6])
- ->where("status", "<>", 0)
- ->where('is_del', '<>', 1)
- ->select()
- ->toArray();
- // 4、将用户装载到 星级等级 分红数据中
- foreach ($list as $key => $value) {
- if ($value['user_group'] == 4) {
- $salesArr['初级']['user_group'] = $value['user_group'];
- $salesArr['初级']['divider_people'][] = $value['uid'];
- } else if ($value['user_group'] == 5) {
- $salesArr['中级']['user_group'] = $value['user_group'];
- $salesArr['中级']['divider_people'][] = $value['uid'];
- } else if ($value['user_group'] == 6) {
- $salesArr['高级']['user_group'] = $value['user_group'];
- $salesArr['高级']['divider_people'][] = $value['uid'];
- }
- }
- $salesArr['初级']['divider_people_count'] = count($salesArr['初级']['divider_people']);
- $salesArr['中级']['divider_people_count'] = count($salesArr['中级']['divider_people']);
- $salesArr['高级']['divider_people_count'] = count($salesArr['高级']['divider_people']);
- // 5、移除特定人员
- // 要移动的ID数组
- // $ids_to_remove_from_junior = array(12, 69, 144); // 从初级中移除的ID
- // $ids_to_remove_from_intermediate = array(49); // 从中级中移除的ID
- // // 查找初级并获取其divider_people
- // $junior = &$salesArr['初级']['divider_people']; // 使用引用,以便直接修改数组
- // // 查找中级并获取其divider_people
- // $intermediate = &$salesArr['中级']['divider_people']; // 使用引用,以便直接修改数组
- // // 从初级的divider_people中移除特定的ID
- // foreach ($ids_to_remove_from_junior as $id) {
- // $key = array_search($id, $junior);
- // if ($key !== false) {
- // unset($junior[$key]); // 移除初级中的特定ID
- // }
- // }
- // // 从中级的divider_people中移除特定的ID
- // foreach ($ids_to_remove_from_intermediate as $id) {
- // $key = array_search($id, $intermediate);
- // if ($key !== false) {
- // unset($intermediate[$key]); // 移除中级中的特定ID
- // }
- // }
- // // 重置数组的索引,因为unset会留下空位
- // $salesArr['初级']['divider_people'] = array_values($junior);
- // $salesArr['中级']['divider_people'] = array_values($intermediate);
- // 获取查询合伙人 团队贡献值 最深的到哪一层
- $depth = Db::name("system_config_value")->where(["config_key" => "team_commission_recursion_depth"])->value("value");
- // 6、执行分开发放
- $partnerProfitsPvListByUid = [];
- foreach ($salesArr as $key => $value) {
- // 6.1 计算可分红金额
- //比如这个周的总业绩是 8400
- //周总业绩(8400) * 合伙人级别的分佣比例(15%) = 可分红的佣金(1260)
- // $salesArr[$key]['fs_money_nums'] = round($weekRecord * $value['profit_rate'], 2);
- $salesArr[$key]['fs_money_nums'] = floor(($weekRecord * ($value['profit_rate'] / 100)) * 100) / 100;
- // 日志表 记录应分配金额
- $dividendLogEntity->setExpected(bcadd($dividendLogEntity->getExpected() ?: '0.00', $salesArr[$key]['fs_money_nums'], 2));
- //可分红的业绩(分为两半,各50%,一部分是分给双联盟比例,一部分是小业绩比例)
- //把本周的业绩(8400) * 合伙人级别的分佣比例(15%) * 0.5 = 630(可分红佣金的 50%)
- // $salesArr[$key]['fs_money'] = round($salesArr[$key]['fs_money_nums'] / 2, 2);
- $salesArr[$key]['fs_money'] = floor(($salesArr[$key]['fs_money_nums'] / 2) * 100) / 100;
- // 6.2 计算所有人的 PV值
- $salesArr[$key]['weekRecord'] = $weekRecord;
- $salesArr[$key]['redEnvelope'] = $redEnvelope;
- $salesArr[$key]['maxValueAll'] = 0;
- $salesArr[$key]['sumOfOthersAll'] = 0;
- $salesArr[$key]['dividerPeoplePv'] = [];
- foreach ($value['divider_people'] as $k => $v) {
- // 6.2.1 查出分红人的所有部门 即 下级用户
- $spreadUserUidList = $this->getSpreadUserUidListByUidList([$v]);
- if (empty($spreadUserUidList[$v])) {
- continue;
- }
- // 6.2.2 获取当前分红人的所有部门 内的下级成员,递归获取至最低一级
- $subordinatesBatch = $this->getSubordinatesBatch($spreadUserUidList[$v]);
- // 6.2.3 获取所有部门(下线)的PV值
- foreach ($subordinatesBatch as $k1 => $v1) {
- $partnerProfitsPvListByUid[$v][$k1] = 0;
- // 获取当前下线的PV值, 忽略测试人员的账号
- $pv = $this->getPv(array_merge($v1, [$k1]), $removeUserIdList);
- $partnerProfitsPvListByUid[$v][$k1] += $pv;
- $pvNew = $this->getPvNew(array_merge($v1, [$k1]), $removeUserIdList);
- $partnerProfitsPvListByUid[$v][$k1] += $pvNew;
- }
- // 6.2.4 将PV值进行记录 以便后续计算
- if (!empty($partnerProfitsPvListByUid[$v])) {
- // 获取数组中的最大值
- $maxValue = max($partnerProfitsPvListByUid[$v]);
- // 计算总和
- $totalSum = array_sum($partnerProfitsPvListByUid[$v]);
- // 计算除最大值外其余值的和
- $sumOfOthers = $totalSum - $maxValue;
- $salesArr[$key]['dividerPeoplePv'][$v]['maxValue'] = $maxValue;
- $salesArr[$key]['dividerPeoplePv'][$v]['sumOfOthers'] = $sumOfOthers;
- $salesArr[$key]['maxValueAll'] += $maxValue;
- $salesArr[$key]['sumOfOthersAll'] += $sumOfOthers;
- }
- }
- }
- // 6、记录日志
- // 获取周期内所有符合条件的订单
- $orderUidMap = $this->getOrderUidListByTime($startTime, $endTime, $removeUserIdList);
- $feeUids = array_keys($orderUidMap);
- // 7、执行分红
- $testRecord = [];
- foreach ($salesArr as $key => $value) {
- $amount = $value['fs_money'];//可分红的总佣金,分红佣金的一半,中级合伙61.95
- $fsMoneyNums = $value['fs_money_nums'];//中级合伙人级别,可分红的总佣金
- $maxValueAll = $value['maxValueAll'];//当前级别合伙人下面所有的双联盟业绩
- $sumOfOthersAll = $value['sumOfOthersAll'];//当前级别合伙人下面所有的小区(业绩小的部分)总业绩
- if (count($value['divider_people']) <= 0) {
- continue;
- }
- //每人分红金额
- foreach ($value['divider_people'] as $v) {
- //个人小区(佣金少的一部分) 权重 计算权重
- //返回是数组,下标0是最小的值(业绩小的),下标1是最大的值(业绩大的)
- $userPvSmallNum = $value['dividerPeoplePv'][$v]['sumOfOthers'] ?? 0;
- // $myMixMoney = round($amount * ($userPvSmallNum / $sumOfOthersAll), 2);
- $myMixMoney = floor(($amount * (floor(($userPvSmallNum / $sumOfOthersAll) * 100000) / 100000)) * 100) / 100;
- //个人双区总佣金 权重 计算
- $myBill = $value['dividerPeoplePv'][$v]['maxValue'] ?? 0;
- //中级合伙人。userid=17可以分到双区可分红的金额
- //可分红的佣金 * (中级合伙人个人的双区总业绩 / 当前等级所有合伙人的双联盟业绩) = 当前用户可以获取到的分红佣金(双区联盟总业绩加权佣金),287742 * (61.95/431032)=41.36
- // $myWeightMoney = round($amount * ($myBill / $maxValueAll), 2);
- $myWeightMoney = floor(($amount * (floor((($myBill + $userPvSmallNum) / ($maxValueAll + $sumOfOthersAll)) * 100000) / 100000)) * 100) / 100;
- $salesArr[$key]['dividerPeoplePv'][$v]['myWeightMoney'] = $myWeightMoney;
- $salesArr[$key]['dividerPeoplePv'][$v]['myMixMoney'] = $myMixMoney;
- $salesArr[$key]['dividerPeoplePv'][$v]['maxValueAll'] = $maxValueAll;
- $salesArr[$key]['dividerPeoplePv'][$v]['sumOfOthersAll'] = $sumOfOthersAll;
- # code...
- $allAward = $myWeightMoney + $myMixMoney;
- //90%给佣金,10给复购金
- $yj_90 = floor($allAward * 0.9 * 100) / 100;
- $fg_10 = floor($allAward * 0.1 * 100) / 100;
- // $yj_90 = bcsub($yj_90, $user_bill_uid_list[$v]['number'] ?? 0.00, 2);
- //
- // $fg_10 = bcsub($fg_10, $user_sign_fugou_uid_list[$v]['number'] ?? 0.00, 2);
- //
- // if ($yj_90 < 0) {
- // $testRecord['yj_fushu'][] = ['uid' => $v, 'num' => floor($allAward * 0.9 * 100) / 100, 'exist' => $user_bill_uid_list[$v]['number'] ?? 0.00, 'yj' => $yj_90];
- // }
- // if ($fg_10 < 0) {
- // $testRecord['fg_fushu'][] = ['uid' => $v, 'num' => floor($allAward * 0.1 * 100) / 100, 'exist' => $user_sign_fugou_uid_list[$v]['number'] ?? 0.00, 'fg' => $fg_10];
- // }
- if (!in_array($v, $feeUids)) {
- $feeWaiverUids = $dividendLogEntity->getFeeWaiverUids() ?: [];
- $feeWaiverUids[] = [
- 'uid' => $v,
- 'remark' => '周期内未完成订单任务'
- ];
- $dividendLogEntity->setFeeWaiverUids($feeWaiverUids);
- continue;
- }
- $dividendLogEntity->setArrivalPoint(bcadd($dividendLogEntity->getArrivalPoint() ?: '0.00', $allAward, 2));
- $arrivalInfo = $dividendLogEntity->getArrivalInfo() ?: [];
- $arrivalInfo[$v]['allAward'] = $allAward;
- $arrivalInfo[$v]['orderInfo'] = $orderUidMap[$v];
- $dividendLogEntity->setArrivalInfo($arrivalInfo);
- if ($isTest == 0) {
- $userdatassss = db::name("old_user_jbp")->where("id", $v)->find();
- $datas_log = [
- 'note' => "名称:" . $userdatassss['nick_name'] . " 用户:" . $v . " 双联盟总业绩:" . $maxValueAll . " 我的双区业绩:" . $myBill . " 小区总业绩:" . $userPvSmallNum . " 我的业绩小的:" . $myMixMoney . " 可分红佣金:" . $amount . " 可分红总佣金:" . $fsMoneyNums . " 小区业绩可分红:" . $myMixMoney . " 双区业绩可分红:" . $myWeightMoney . " 实际分得:" . $yj_90,
- 'create_time' => date('Y-m-d H:i:s')
- ];
- Db::name('test_log')->insert($datas_log); //数据存到2.0数据表中
- # code...
- Db::name("user")->where("uid", $v)->inc("total_amount_old", $yj_90)->save();
- Db::name("user")->where("uid", $v)->inc("amount_old", $yj_90)->save();//不用冻结金额和提现额度来限制佣金发放
- Db::name("user")->where("uid", $v)->inc("brokerage_price", $yj_90)->save();
- Db::name("user")->where("uid", $v)->inc("fugou", $fg_10)->save();
- //if($res) {
- $this->change_user_log($v, 'amount_old', 1, $yj_90, "member_award", "星级分红入账" . "-" . $value['title']);//释放佣金
- // //入账星级分红记录表
- // $week_data = [];
- // $week_data['user_id'] = $v;
- // $week_data['user_star_id'] = $value['id'];
- // $week_data['award_num'] = $myWeightMoney;
- // $week_data['award_num_sm'] = $myMixMoney;
- // $week_data['remark'] = "星级分红主动执行:" . $yj_90;
- // $week_data['week_record'] = $weekRecord;
- // $week_data['all_amount'] = $fsMoneyNums;
- // $week_data['radio'] = 2;
- // $week_data['owner_bill'] = $maxValueAll; //总流水金额
- // $week_data['my_bill'] = $myBill; //我的流水
- // $week_data['create_time'] = time();
- // Db::name("old_user_weekaward")->insert($week_data);
- // 入账记录
- $week_data = [];
- $week_data['user_id'] = $v;
- $week_data['user_group'] = $value['user_group'];
- $week_data['start_time'] = $startTime;
- $week_data['end_time'] = $endTime;
- $week_data['performance'] = $performance;
- $week_data['red_envelope'] = $redEnvelope;
- $week_data['reality_performance'] = $weekRecord;
- $week_data['dividend_ratio'] = $value['profit_rate'];
- $week_data['dividend'] = $fsMoneyNums;
- $week_data['performance_part'] = $userPvSmallNum;
- $week_data['performance_part_all'] = $sumOfOthersAll;
- $week_data['part_money'] = $myMixMoney;
- $week_data['performance_total'] = ($myBill + $userPvSmallNum);
- $week_data['performance_total_all'] = ($maxValueAll + $sumOfOthersAll);
- $week_data['total_money'] = $myWeightMoney;
- $week_data['brokerage'] = $yj_90;
- $week_data['fugou'] = $fg_10;
- $week_data['radio'] = 2;
- $week_data['create_time'] = date('Y-m-d H:i:s');
- Db::name("partner_profit_records")->insert($week_data);
- $this->bill_user_log111111($v, "合伙人分佣", $yj_90, "合伙人分佣明细入账", 11);//联创分佣明细2.0系统
- $this->fugou_user_log($v, $fg_10, 16, 1, 1);//复购金明细入账
- }
- }
- $salesArr['cs'] = $testRecord;
- }
- $dividendLogEntity->setResult(json_encode($salesArr, JSON_UNESCAPED_UNICODE));
- /** @var DividendLogRepository $dividendLogRepository */
- $dividendLogRepository = app()->make(DividendLogRepository::class);
- $dividendLogRepository->createByEntity($dividendLogEntity);
- return app('json')->success($salesArr);
- }
- /**
- * 获取该会员的所有下级会员
- */
- public function getSpreadUserUidListByUidList(array $uidList)
- {
- $son_ids = Db::name("user")
- ->whereIn("level_id", $uidList)
- ->field("uid,level_id")
- ->select()
- ->toArray();
- $new_array_ids = [];
- foreach ($son_ids as $key => $value) {
- $new_array_ids[$value['level_id']][] = $value['uid'];
- }
- return $new_array_ids;
- }
- /**
- * 递归查询下级用户并分组
- *
- * @param array $uids 初始用户ID数组
- * @return array 分组后的下级用户ID数组
- */
- public function getSubordinates(array $uids): array
- {
- $result = [];
- foreach ($uids as $uid) {
- $result[$uid] = $this->getSubordinatesRecursively($uid);
- }
- return $result;
- }
- /**
- * 获取该会员的所有下级会员
- */
- public function getSpreadUserUidAccountListByUidList($uid, $account = '')
- {
- $son_ids = Db::name("user")
- ->where("level_id", $uid)
- ->field("uid,level_id,account")
- ->select()
- ->toArray();
- $new_array_ids = [];
- foreach ($son_ids as $key => $value) {
- $childList = $this->getSpreadUserUidAccountListByUidList($value['uid'], $value['account']);
- $new_array_ids[] = [
- '当前用户ID' => $value['uid'],
- '当前用户的上级用户ID' => $value['level_id'],
- '用户账号(手机号)' => $value['account'],
- '当前用户的下级用户列表' => $childList
- ];
- }
- return $new_array_ids;
- }
- /**
- * 递归查询单个用户的下级用户
- *
- * @param int $uid 用户ID
- * @param array $subordinates 用于存储下级用户ID的数组(内部使用, 递归传递)
- * @return array 下级用户ID数组
- */
- private function getSubordinatesRecursively(int $uid, array &$subordinates = []): array
- {
- $subUidList = Db::name("user")
- ->where("level_id", $uid) // 直接使用 $uid, 不需要 whereIn
- ->field("uid") //只需要查询uid
- ->select()
- ->toArray();
- if (!empty($subUidList)) {
- foreach ($subUidList as $subUser) {
- $subUid = $subUser['uid'];
- $subordinates[] = $subUid; // 添加到下级用户数组
- $this->getSubordinatesRecursively($subUid, $subordinates); // 递归查询下级的下级
- }
- }
- return $subordinates;
- }
- /**
- * 递归获取所有下级ID(不分组)
- * @param int $uid
- * @param array $allSubordinates
- * @return array
- */
- public function getAllSubordinates(int $uid, array &$allSubordinates = []): array
- {
- $subUidList = Db::name("user")
- ->where("level_id", $uid)
- ->column("uid"); // 使用 column 方法直接获取 uid 数组
- if (!empty($subUidList)) {
- foreach ($subUidList as $subUid) {
- $allSubordinates[] = $subUid;
- $this->getAllSubordinates($subUid, $allSubordinates);
- }
- }
- return $allSubordinates;
- }
- /**
- * 更高效的获取所有下级 (使用循环代替递归, 避免栈溢出)
- * @param array $uids
- * @return array
- */
- public function getAllSubordinatesIterative(array $uids): array
- {
- $result = [];
- foreach ($uids as $uid) {
- $result[$uid] = [];
- $queue = [$uid]; // 使用队列来存储待处理的 UID
- $processed = []; // 记录已经处理过的
- while (!empty($queue)) {
- $currentUid = array_shift($queue); // 从队列头部取出 UID
- if (in_array($currentUid, $processed)) {
- continue; // 已经处理过
- }
- $processed[] = $currentUid;
- $subUidList = Db::name("user")
- ->where("level_id", $currentUid)
- ->column("uid");
- if (!empty($subUidList)) {
- $result[$uid] = array_merge($result[$uid], $subUidList); //合并
- $queue = array_merge($queue, $subUidList); // 将新找到的下级 UID 加入队列尾部
- }
- }
- $result[$uid] = array_unique($result[$uid]);//去重
- }
- return $result;
- }
- /**
- * 获取多个用户的所有下级, 返回分组后的数组. (更高效, 使用循环, 减少数据库查询次数)
- * @param array $uids
- * @return array 形如 ['A1' => [A11, A12, ...], 'A2' => [...]]
- */
- public function getSubordinatesBatch(array $uids): array
- {
- $result = [];
- $allSubordinates = [];
- $queue = $uids;
- $processed = [];
- //1. 找出所有的下级ID (不去重)
- while (!empty($queue)) {
- $currentUids = array_splice($queue, 0, 500); // 一次最多处理500个,防止in太多. 可以根据实际情况调整.
- $currentUids = array_diff($currentUids, $processed); //去除已经查询过的
- if (empty($currentUids)) continue; //没有新的需要处理的
- $processed = array_merge($processed, $currentUids);//记录
- $subUidList = Db::name("user")
- ->whereIn("level_id", $currentUids)
- ->field("uid,level_id") // 需要查询 level_id 用于后续分组
- ->select()
- ->toArray();
- if (!empty($subUidList)) {
- $allSubordinates = array_merge($allSubordinates, $subUidList); //所有下级
- $nextLevelUids = array_column($subUidList, 'uid');
- $queue = array_merge($queue, $nextLevelUids); //放到队列中
- }
- }
- //2. 分组
- foreach ($uids as $uid) {
- $result[$uid] = []; // 初始化每个用户的下级数组
- }
- $allSubordinatesMap = [];
- foreach ($allSubordinates as $item) {
- $allSubordinatesMap[$item['level_id']][] = $item['uid'];
- }
- //3. 递归的将查到的下级进行分组
- $group = function ($spreadUid) use (&$group, &$allSubordinatesMap, &$result) {
- if (isset($allSubordinatesMap[$spreadUid])) {
- foreach ($allSubordinatesMap[$spreadUid] as $subUid) {
- if (isset($result[$spreadUid])) {
- $result[$spreadUid][] = $subUid; //直接添加到结果中
- } else { //不属于直接上级, 查找上级的上级
- foreach ($result as $rootUid => &$subordinates) {
- if (in_array($spreadUid, $subordinates) || $rootUid == $spreadUid) {
- $subordinates[] = $subUid;
- break;
- }
- }
- }
- $group($subUid); //递归下一层
- }
- }
- };
- foreach ($uids as $uid) {
- $group($uid);
- }
- // 4. 去重 (如果需要)
- foreach ($result as $key => $value) {
- $result[$key] = array_values(array_unique($value));
- }
- return $result;
- }
- // 获取用户PV值
- public function getPv($userIdList, $removeUserIdList = [])
- {
- if (!empty($removeUserIdList)) {
- $userIdList = array_values(array_diff($userIdList, $removeUserIdList));
- }
- // 基础查询构建器
- $user_team_amount = Db::name("old_user_of_goods")
- ->whereIn("user_id", $userIdList)
- ->where('status', 1)
- ->where('money', 1180)
- ->select();
- //$money1180Records = $this->old_user_of_goods->where('status', 1)->where('money', 1180)->select();
- // 计算 status 为 1 且 money 为 1180 的记录总和(减去相应值后)
- $money1180Sum = 0;
- foreach ($user_team_amount as $record) {
- $money1180Sum += $record['money'] - 300 - 180;
- }
- // 获取 status 为 1 且 money 为 11800 的记录集合
- $money11800Records = Db::name("old_user_of_goods")
- ->whereIn("user_id", $userIdList)
- ->where('status', 1)
- ->where('money', 11800)
- ->select();
- // 计算 status 为 1 且 money 为 11800 的记录总和(减去相应值后)
- $money11800Sum = 0;
- foreach ($money11800Records as $record) {
- $money11800Sum += $record['money'] - 3000 - 1800;
- }
- $money10620Records = Db::name("old_user_of_goods")
- ->whereIn("user_id", $userIdList)
- ->where('status', 1)
- ->where('money', 10620)
- ->select();
- // 计算 status 为 1 且 money 为 10620 的记录总和(减去相应值后)
- $money10620Sum = 0;
- foreach ($money10620Records as $record) {
- $money10620Sum += $record['money'] - 2700 - 1620;
- }
- $money9440Records = Db::name("old_user_of_goods")
- ->whereIn("user_id", $userIdList)
- ->where('status', 1)
- ->where('money', 9440)
- ->select();
- // 计算 status 为 1 且 money 为 9440 的记录总和(减去相应值后)
- $money9440Sum = 0;
- foreach ($money9440Records as $record) {
- $money9440Sum += $record['money'] - 2400 - 1440;
- }
- $money2360Records = Db::name("old_user_of_goods")
- ->whereIn("user_id", $userIdList)
- ->where('status', 1)
- ->where('money', 2360)
- ->select();
- // 计算 status 为 1 且 money 为 2360 的记录总和(减去相应值后)
- $money2360Sum = 0;
- foreach ($money2360Records as $record) {
- $money2360Sum += $record['money'] - 600 - 360;
- }
- // 计算除去特定值后的总和
- $otherMoneyRecords = [];
- // $otherMoneyRecords = Db::name("old_user_of_goods")
- // ->whereIn("user_id", $userIdList)
- // ->whereNotIn('money', [1180, 11800, 10620, 9440, 2360])
- // ->select();
- $otherMoneySum = 0;
- foreach ($otherMoneyRecords as $record) {
- $otherMoneySum += $record['money'];
- }
- return $money1180Sum + $money11800Sum + $money10620Sum + $money9440Sum + $money2360Sum + (floor($otherMoneySum * 70) / 100);
- }
- // 获取用户PV值
- public function getPvNew($userIdList, $removeUserIdList = [])
- {
- if (!empty($removeUserIdList)) {
- $userIdList = array_values(array_diff($userIdList, $removeUserIdList));
- }
- // 查询指定时间区间内的所有订单,并排除 pay_time 为 NULL 的订单
- $orders = Db::name("store_order")
- ->where('mer_id', 496)
- ->whereIn('uid', $userIdList)
- ->whereIn('status', [0, 1, 2, 3]) // TODO 之前橙汁先生 这么定义的,感觉有问题,也就是现在 会员专区 下单 不允许退款,不然肯定有问题 注意调整
- ->whereIn("total_price", [1180, 11800, 10620, 2360, 9440, 5900])
- ->whereNotNull("pay_time") // 排除 pay_time 为 NULL 的订单
- ->select();
- // 计算总业绩
- $totalPv = 0;
- foreach ($orders as $order) {
- switch ($order['total_price']) {
- case 1180:
- $totalPv += 700;
- break;
- case 11800:
- $totalPv += 7000;
- break;
- case 10620:
- $totalPv += 6300;
- break;
- case 2360:
- $totalPv += 1400;
- break;
- case 9440:
- $totalPv += 5600;
- break;
- case 5900:
- $totalPv += 3500;
- break;
- }
- }
- return $totalPv;
- }
- //发放佣金 示例: $this->change_user_log($v,'amount',1,$all_award,"member_award","星级分红入账"."-".$value['title']);//释放佣金
- function change_user_log($user_id, $type, $change_status, $money, $routine, $remark = "", $is_admin = 1, $appoint_money = 0)
- {
- $transition = [
- 'pv' => 1,
- "gb" => 2,
- "df" => 3,
- "vr" => 4,
- "bt" => 5,
- "withdraw_quota_old" => 6,//提现
- "unsettled_pension" => 7,
- "amount_old" => 8//发放佣金
- ];
- $routineInfo = Db::name("old_routine_log_of_key")->where("key", $routine)->find();
- if (empty($routineInfo)) {
- return false;
- }
- $key_id = isset($routineInfo['id']) ? $routineInfo['id'] : 0;
- if ($appoint_money > 0) {
- $alter_money = $appoint_money;
- } else {
- //再去查询变更前的 金额
- $alter_money = Db::name("user")->where('uid', $user_id)->value($type);
- }
- if ($change_status == 1) {
- //新增前
- $alter_money = $alter_money - $money;
- } else if ($change_status == 2) {
- //减少前
- $alter_money = $alter_money + $money;
- }
- if ($alter_money < 0) {
- $alter_money = 0;
- }
- $inser_data = [];
- $inser_data['user_id'] = $user_id;
- $inser_data['type'] = $transition[$type];
- $inser_data['change_status'] = $change_status;
- $inser_data['money'] = $money;
- $inser_data['routine_log_of_key_id'] = $key_id;
- $inser_data['remark'] = $remark;
- $inser_data['is_admin'] = $is_admin;
- $inser_data['create_time'] = time();
- $inser_data['alter_money'] = isset($alter_money) ? $alter_money : 0;
- Db::name("old_user_log")->insert($inser_data);
- }
- //添加平台分佣2.0系统收益明细日志(养老金金额)
- public function bill_user_log111111($uid, $name, $num, $mark, $comm)
- {
- $con_data = Db::name('user')->where("uid", $uid)->find();
- //如果是会员专区就即刻到账
- // Db::name('user')->where("uid",$con_data['uid'])->update(['brokerage_price'=> $con_data['brokerage_price'] + $num]);
- $bill = [
- 'uid' => $uid,
- 'link_id' => 0,//关联订单id
- 'pm' => 1,//0:支出,1:获得
- 'title' => $name,//账单标题
- 'category' => 'now_money',//明细种类
- 'type' => 'commission',//明细类型
- 'number' => $num,//明细数字
- 'balance' => 0,//剩余
- 'mark' => $mark,//备注
- 'create_time' => date('Y-m-d H:i:s'),//添加时间
- 'status' => 1,//0待确定,1有效,-1无效
- 'commission_type' => $comm,//佣金类型 1代理费 2 消费佣金 3直推奖√ 4辖区佣金\r\n5 养老金√ 6 广告费
- //7 跨店奖励√ 8平台奖励 9渠道商\r\n10 推荐创客收益√ 11分红奖金√ 12代理区域收益√ 13消费循环佣金
- //14-推荐代理收益√ 15邀请小区团长升级√ 16大v分享奖√ 17创客合伙人√ 18积分奖励√ 19创客补贴√’
- 'order_sn' => 0,//订单号
- 'tripartite' => 0,//
- 'type_shop' => 0,//0平台1多多进宝2唯品会3苏宁易购4网易考拉5淘宝客6京东联盟7饿了么8线上
- 'mer_id' => 0,//商户id
- 'source' => 0,//1线下 0线上
- 'order_type' => 1,//1自营 2 第三方 订单类型
- 'is_red_brokerage' => 0,//1红积分对冲佣金 0正常佣金
- 'gzc' => 3,//养老金是否已进入公证处log表0:未进入。1:已进入
- 'take_time' => time(),//结算时间
- 'district_id' => '',//
- 'street_id' => '',//
- 'month' => '',//月份
- ];
- Db::name('user_bill')->insert($bill);
- }
- //添加复购金
- public function fugou_user_log($uid, $num, $order_id, $type_inc_des, $status = -1)
- {
- $fugou_data = Db::name('user')->where("uid", $uid)->find();
- $bill = [
- 'uid' => $uid,
- 'number' => $num,//数量
- 'status' => $status,//复购金状态1-有效 0-失效 -1待确认
- 'mark' => "复购金",//备注
- 'desc' => "10%复购金",//描述
- 'order_id' => $order_id,//订单id
- 'surplus' => 0,//剩余
- 'order_type' => 11,//关联订单ID
- 'type' => $type_inc_des,//复购金类型 :1赠送,2消耗
- 'settlement_time' => date('Y-m-d H:i:s'),//添加时间,
- 'addtime' => time(),
- ];
- Db::name('user_sign_fugou')->insert($bill);
- }
- /**
- * 补发分红
- * @param Request $request
- * @return mixed
- */
- public function resendUnissued(Request $request)
- {
- $dividendLogId = $request->param('dividendLogId', 0);
- if (empty($dividendLogId)) {
- return app('json')->fail('无效记录ID');
- }
- /** @var DividendLogRepository $dividendLogRepository */
- $dividendLogRepository = app()->make(DividendLogRepository::class);
- $dividendLogEntity = $dividendLogRepository->getDividendLogEntityById($dividendLogId);
- if (empty($dividendLogEntity->getId())) {
- return app('json')->fail('无效记录');
- }
- $dividendLogEntityByResend = DividendLogEntity::newInstance()
- ->setType($dividendLogEntity->getType())
- ->setStartTime($dividendLogEntity->getStartTime())
- ->setEndTime($dividendLogEntity->getEndTime())
- ->setPerformance($dividendLogEntity->getPerformance())
- ->setAbatement($dividendLogEntity->getAbatement())
- ->setAllocated($dividendLogEntity->getAllocated())
- ->setRule($dividendLogEntity->getRule())
- ->setExpected(bcsub($dividendLogEntity->getExpected(), $dividendLogEntity->getArrivalPoint(), 2))
- ->setFeeWaiverUids([])
- ->setResult($dividendLogEntity->getResult())
- ->setIsTest(DividendLogEnum::IS_TEST['No']['code'])
- ->setReissueId($dividendLogEntity->getId());
- $startTime = $dividendLogEntity->getStartTime();
- $endTime = $dividendLogEntity->getEndTime();
- $performance = $dividendLogEntity->getPerformance();
- $weekRecord = $dividendLogEntity->getAllocated();
- $feeWaiverUids = $dividendLogEntity->getFeeWaiverUids();
- $feeWaiverUids = array_column($feeWaiverUids, 'uid');
- $redEnvelope = 0.00;
- if (!empty($dividendLogEntity->getAbatement())) {
- $abatement = json_decode($dividendLogEntity->getAbatement(), true);
- if (is_array($abatement)) {
- foreach ($abatement as $item) {
- if ($item['code'] == 'redEnvelope') {
- $redEnvelope = $item['number'] ?? 0.00;
- }
- }
- }
- }
- $salesArr = $dividendLogEntity->getResult();
- foreach ($salesArr as $key => $value) {
- if (empty($value)) {
- continue;
- }
- if (count($value['dividerPeoplePv']) <= 0) {
- continue;
- }
- $fsMoneyNums = $value['fs_money_nums'];//中级合伙人级别,可分红的总佣金
- $maxValueAll = $value['maxValueAll'];//当前级别合伙人下面所有的双联盟业绩
- $sumOfOthersAll = $value['sumOfOthersAll'];//当前级别合伙人下面所有的小区(业绩小的部分)总业绩
- //每人分红金额
- foreach ($value['dividerPeoplePv'] as $uid => $item) {
- $allAward = bcadd($item['myWeightMoney'], $item['myMixMoney'], 2);
- //90%给佣金,10给复购金
- $yj_90 = floor($allAward * 0.9 * 100) / 100;
- $fg_10 = floor($allAward * 0.1 * 100) / 100;
- if (!in_array($uid, $feeWaiverUids)) {
- // $feeWaiverUids = $dividendLogEntity->getFeeWaiverUids() ?: [];
- // $feeWaiverUids[] = [
- // 'uid' => $uid,
- // 'remark' => '此次发放为补发,只发放上次未发放人员数据'
- // ];
- // $dividendLogEntity->setFeeWaiverUids($feeWaiverUids);
- continue;
- }
- $dividendLogEntity->setArrivalPoint(bcadd($dividendLogEntity->getArrivalPoint() ?: '0.00', $allAward, 2));
- $arrivalInfo = $dividendLogEntity->getArrivalInfo() ?: [];
- $arrivalInfo[$uid]['allAward'] = $allAward;
- $arrivalInfo[$uid]['orderInfo'] = [];
- $dividendLogEntity->setArrivalInfo($arrivalInfo);
- # code...
- Db::name("user")->where("uid", $uid)->inc("total_amount_old", $yj_90)->save();
- Db::name("user")->where("uid", $uid)->inc("amount_old", $yj_90)->save();//不用冻结金额和提现额度来限制佣金发放
- Db::name("user")->where("uid", $uid)->inc("brokerage_price", $yj_90)->save();
- Db::name("user")->where("uid", $uid)->inc("fugou", $fg_10)->save();
- $this->change_user_log($uid, 'amount_old', 1, $yj_90, "member_award", "星级分红入账" . "-" . $value['title']);//释放佣金
- // 入账记录
- $week_data = [];
- $week_data['user_id'] = $uid;
- $week_data['user_group'] = $value['user_group'];
- $week_data['start_time'] = $startTime;
- $week_data['end_time'] = $endTime;
- $week_data['performance'] = $performance;
- $week_data['red_envelope'] = $redEnvelope;
- $week_data['reality_performance'] = $weekRecord;
- $week_data['dividend_ratio'] = $value['profit_rate'];
- $week_data['dividend'] = $fsMoneyNums;
- $week_data['performance_part'] = $item['sumOfOthers'] ?? '0.00';
- $week_data['performance_part_all'] = $sumOfOthersAll;
- $week_data['part_money'] = $item['myMixMoney'];
- $week_data['performance_total'] = bcadd($item['maxValue'] ?? '0.00', $item['sumOfOthers'] ?? '0.00', 2);
- $week_data['performance_total_all'] = ($maxValueAll + $sumOfOthersAll);
- $week_data['total_money'] = $item['myWeightMoney'];
- $week_data['brokerage'] = $yj_90;
- $week_data['fugou'] = $fg_10;
- $week_data['radio'] = 2;
- $week_data['create_time'] = date('Y-m-d H:i:s');
- Db::name("partner_profit_records")->insert($week_data);
- $this->bill_user_log111111($uid, "合伙人分佣", $yj_90, "合伙人分佣明细入账", 11);//联创分佣明细2.0系统
- $this->fugou_user_log($uid, $fg_10, 16, 1, 1);//复购金明细入账
- }
- }
- /** @var DividendLogRepository $dividendLogRepository */
- $dividendLogRepository = app()->make(DividendLogRepository::class);
- $dividendLogRepository->createByEntity($dividendLogEntityByResend);
- return app('json')->success($salesArr);
- }
- }
|