php/app/controller/api/store/merchant/Taskorderguquan.php

<?php
/**
 * @package merchant
 * @Author: Qinii
 * @Date: 2020/5/28
 */
namespace app\controller\api\store\merchant;

use think\App;
use crmeb\basic\BaseController;
use app\common\repositories\system\merchant\MerchantRepository as repository;
use think\facade\Db;
use think\facade\Log;
use function Symfony\Component\VarDumper\Dumper\esc;

class Taskorderguquan extends BaseController
{




    public function lst6()
    {

       return;

        // return;

        // $store_product_datas = Db::name('old_user_of_goods_old')->select();

        //$week_record = 45500 + 60000 + 1400;

        //$week_record = 23800 + 60000;//20250222

       // $week_record = 64400;//20250303

       


    }

       //添加复购金
       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);
    }

    //添加平台分佣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'=>'',//结算时间
            'district_id'=>'',//
            'street_id'=>'',//
            'month'=>'',//月份


        ];

        Db::name('user_bill')->insert($bill);
    }

    
    //发放佣金 示例: $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);
    }



}