php/app/controller/api/warehouse/Dstributor_commission.php

<?php


namespace app\controller\api\warehouse;
use crmeb\basic\BaseController;
use think\db\Where;
use think\facade\Db;

class Dstributor_commission extends BaseController
{
    public function settlement ()
    {
        $firstDate = date("Y-m-01", time());
        // 上月的第一天和最后一天
        $syFirstDay = date('Y-m-01',strtotime('-1 day', strtotime($firstDate)));
        $syLastDay = date('Y-m-d',strtotime('-1 day', strtotime($firstDate)));
        $channel=Db::name('channel_user')->where('status',1)->select()->toArray();
        foreach ($channel as $k =>$v){
            $mer_id=Db::name('activation_code')
                ->where('uid',$v['uid'])
                ->alias('ac')
                ->where('ac.status',3)
                ->where('ac.use_uid','>','0')
                ->leftJoin('merchant m','ac.use_id=m.uid')
                ->where('uid',$v['use_uid'])
                ->column('m.mer_id');
            $order_where=[
                'paid'=>1,
                'status'=>3,
            ];
            //这个商户订单总可分佣金
            $mer_fanyong=Db::name('store_order')
                ->where($order_where)->whereIn('mer_id',$mer_id)->whereBetweenTime('pay_time',$syFirstDay,$syLastDay)->sum('mer_fanyong');
            //商户总流水
            $mer_pay_price=Db::name('store_order')
                ->where($order_where)->whereIn('mer_id',$mer_id)->whereBetweenTime('pay_time',$syFirstDay,$syLastDay)->sum('pay_price');
            //推荐商家流水返佣=商户订单总可分佣金*0.025
            $recommend_='';
        }
    }
}