screen/application/admin/controller/seller/MyTeam.php

<?php

namespace app\admin\controller\seller;

use app\admin\model\AdminMoneyLog;
use app\admin\model\OrderGoods;
use app\admin\model\OrderInfo;
use app\admin\model\Orders;
use app\common\controller\Backend;

/**
 * 会员组管理
 *
 * @icon fa fa-users
 */
class MyTeam extends Backend
{
    public function cate_check(){
        list($date,$dateArr)=$this->rangeTime('date');
        if($this->request->isAjax()){
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $type=input('type',1);
            if($type==1){
                $list=OrderGoods::filterDate($dateArr)
                    ->filterAdmin($this->admin('id'))
                    ->group('order_goods.goods_id')
                    ->join('order_info','order_info.order_id=order_goods.order_id and order_info.goods_id=order_goods.goods_id')
                    ->field('count(order_goods.order_id) as num,order_info.category_name as category_name')
                    ->order('num','desc')
                    ->select();
            }else{
                $list=OrderInfo::filterAdmin($this->admin('id'))
                    ->payed()
                    ->filterDate($dateArr)
                    ->group('category_id')
                    ->field('sum(amount_pay) as num,category_name,category_id')
                    ->order('num','desc')
                    ->select();
            }
            $all=0;
            foreach ($list as $k=>&$item){
                $item['rank']=$k+1;
                $all+=$item['num'];
            }
            return json([
                'rows'=>$list,
                'total'=>count($list),
                'all'=>$all,
            ]);
        }
        $this->assign('date',$date);
        return $this->fetch();
    }

    public function profit_static(){
        list($date,$dateArr)=$this->rangeTime('date');
        $sale=AdminMoneyLog::filterDate($dateArr)
            ->filterTypeCommission()
            ->where('admin_id',$this->admin('id'))
            ->sum('amount');
        $goods=OrderInfo::whereExists(
            AdminMoneyLog::whereRaw("admin_money_log.target_id=order_info.order_id")->where('admin_id',$this->admin('id'))->filterDate($dateArr)->buildSql()
        )
            ->group('goods_id')
            ->field('sum(amount_cmn) as num,goods_name')
            ->select();
        $this->assign('goods',$goods);
        $this->assign('date',$date);
        $this->assign('sale',$sale);
        return $this->fetch();
    }
    public function order_num_amount_rank(){
        list($date,$dateArr)=$this->rangeTime('date');
        if($this->request->isAjax()){
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $type=input('type',1);
            if($type==1){
                $list=Orders::filterDate($dateArr)
                    ->where('admin_id',$this->admin('id'))
                    ->group('user_id')
                    ->field('count(id) as num,user_id')
                    ->order('num','desc')
                    ->paginate($limit);
            }elseif($type==2){
                $list=Orders::filterDate($dateArr)
                    ->where('admin_id',$this->admin('id'))
                    ->group('user_id')
                    ->field('sum(amount_pay) as num,user_id')
                    ->order('num','desc')
                    ->paginate($limit);
            }elseif($type==3){
                $list=OrderGoods::filterDate($dateArr)
                    ->filterAdmin($this->admin('id'))
                    ->group('order_goods.goods_id')
                    ->join('order_info','order_info.order_id=order_goods.order_id and order_info.goods_id=order_goods.goods_id')
                    ->field('count(order_goods.order_id) as num,order_info.goods_name as name')
                    ->order('num','desc')
                    ->paginate($limit);
            }else{
                $list=Orders::filterDate($dateArr)
                    ->where('admin_id',$this->admin('id'))
                    ->field('amount_pay as num,order_no as name')
                    ->order('amount_pay','desc')
                    ->paginate($limit);
            }
            $all=0;
            foreach ($list as $k=>&$item){
                if(!empty($item['user_id'])) {
                    $item['nickname'] = \app\admin\model\User::where('id', $item['user_id'])->value('nickname');
                }
                $all+=$item['num'];
            }
            $this->addRank($list);
            return json([
                'rows'=>$list->items(),
                'total'=>$list->total(),
                'all'=>$all,
            ]);
        }
        $orderNum=Orders::filterDate($dateArr)->where('admin_id',$this->admin('id'))->count();
        $this->assign('orderNum',$orderNum);
        $orderAmount=Orders::filterDate($dateArr)->where('admin_id',$this->admin('id'))->sum('amount_pay');
        $this->assign('orderAmount',$orderAmount);
        $this->assign('date',$date);
        return $this->fetch();
    }
    public function members(){
        $this->assign('levels',\app\admin\model\User::getLevels());
        if($this->request->isAjax()){
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $list = $this->model
                ->where('admin_id',$this->admin('id'))
                ->where($where)
                ->order($sort, $order)
                ->paginate($limit);
            foreach ($list as $k => $v) {
                $v->hidden(['password', 'salt']);
            }
            $result = array("total" => $list->total(), "rows" => $list->items());

            return json($result);
        }
        return $this->fetch();
    }
    public function member_detail($ids){
        list($date,$dateArr)=$this->rangeTime('date');
        $this->assign('date',$date);
        $sale=Orders::where('user_id',$ids)->filterDate($dateArr)->sum('amount_pay');
        $this->assign('sale',$sale);
        $orderNum=Orders::where('user_id',$ids)->filterDate($dateArr)->count();
        $this->assign('orderNum',$orderNum);
        return $this->fetch();
    }
}