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); } }