PHP 生成佣金

 使用的是TP框架实现的

数据表

 

 

 

模型层

static public function findIndex($id){
        return self::where('id',$id)->select();
    }

控制器代码 

/*
     * 生成佣金记录
     */
    public function GroupSelect()
    {
        //模拟数据
        try {
            $order = ['id'=>2,'is_o'=>1,'t_id'=>2,'price'=>2000];
            //判断模拟数据是否有值
            if($order['is_o']==1){
                $t_id = $order['t_id'];
                //查询团长表数据
                $data = GroupMaster::where('id',$t_id)->find();
                //查询团长等级表数据
                $datas = GroupMasterGrade::where('id',$data['user_id'])->find();
//            return json(['code'=>200,'msg'=>'查询成功','data'=>$datas]);
                //计算佣金金额
                $commission = $order['price']*($datas['reward_ratio']*0.01);
                //如果有，则进行添加到佣金记录表
                $success = ComAmounts::create([
                    'member_nickname'=>$t_id,
                    'commission_amount'=>$commission
                ]);
                //判断佣金是否添加成功
                if($success){
                    //添加成功返回
                    return json(['code'=>'200','msg'=>'添加佣金成功','data'=>$success]);
                }else{
                    //添加失败返回
                    return json(['code'=>'400','msg'=>'添加佣金失败','data'=>'']);
                }
            }else{
                return json(['code'=>'40004','msg'=>'请传输正确参数','data'=>'']);
            }
        }catch (Exception $exception){
            echo "异常捕获".$exception;
        }

    }


    public function groupList()
    {
        $date = strtotime(date("Y-m-d"),time());

        $starttimes = $date-60*60*24;

        $endtime = date('Y-m-d H:i:s',$date);

        $starttime = date('Y-m-d H:i:s',$starttimes);

        $sum = Db::table('ea_com_amounts')->whereBetweenTime('created_at',$starttime,$endtime)->count();

        //佣金总额
        $commissionsum = Db::table('ea_com_amounts')->whereBetweenTime('created_at',$starttime,$endtime)->sum('commission');

        $data = Db::table('ea_com_statistics')->insert([
            'count'=>$sum,
            'commissionsum'=>$commissionsum,
            'starttime'=>date('Y-m-d',$starttimes),
            'endtime'=>date('Y-m-d',$date),
        ]);

        return json_encode(['code'=>200,'data'=>$data,'msg'=>'成功']);
    }