crm_hdl/application/admin/controller/Ranking.php

<?php
namespace app\admin\controller;

use app\admin\model\RankingModel;
use app\admin\model\UserModel;
use think\Db;

/**
 * Class Ranking
 * @package app\admin\controller
 * 排行榜
 */
class Ranking extends Base
{
    /**
     * 月度新建客户排名
     */
    public function new_customer()
    {
        if (request()->isAjax()) {
            extract(input());
            $map = [];
            $whereTime = [];
            if (isset($start) && $start != "" && isset($end) && $end != "") {
                $whereTime = [strtotime($start), strtotime($end)];
            } else {
                $ymd = date('Y-m',time());
                $time = strtotime($ymd);
                $whereTime = [$time, time()];
            }

            $Nowpage = input('page') ? input('page') : 1;
            $limits = input("limit") ? input("limit") : 10;// 获取总条数;
            $field = input('field');                       //字段
            $order = input('order');                       //排序方式
            if ($field && $order) {
                $od = "a." . $field . " " . $order;
            } else {
                $od = "a.create_time desc";
            }
            $user = new UserModel();
            $count = $user->getUserCount($map);
            $lists = $user->getURankingByWhere($map, $od, $Nowpage, $limits,0,$whereTime);
            if ($lists) {
                foreach ($lists as $k=>$v) {
                    $id[$k] = $lists[$k]['id'];
                }
                $ids = implode(',',$id); // 把有客户的业务员id拼接成字符串
            } else {
                $ids = 0;
            }
            $other_admin = Db::name('admin')->where('id','not in',$ids)->where('groupid',4)->field('nickname')->select();
            foreach ($other_admin as &$v) {
                $v['num'] = 0;
            }
            $data = array_merge($lists,$other_admin);
            return json(['code' => 220, 'msg' => '', 'count' => $count, 'data' => $data]);
        }
        return $this->fetch();
    }
    /**
     * 月度有效回复客户
     */
    public function reply_customer()
    {
        if (request()->isAjax()) {
            extract(input());
            $map = [];
            $whereTime = [];
            if (isset($start) && $start != "" && isset($end) && $end != "") {
                $whereTime = [strtotime($start), strtotime($end)];
            } else {
                $ymd = date('Y-m',time());
                $time = strtotime($ymd);
                $whereTime = [$time, time()];
            }
            $Nowpage = input('page') ? input('page') : 1;
            $limits = input("limit") ? input("limit") : 10;// 获取总条数;
            $field = input('field');                       //字段
            $order = input('order');                       //排序方式
            if ($field && $order) {
                $od = "a." . $field . " " . $order;
            } else {
                $od = "a.create_time desc";
            }
            $user = new UserModel();
            $count = $user->getUserCount($map);
            $lists = $user->getURankingByWhere($map, $od, $Nowpage, $limits,1,$whereTime);
            if ($lists) {
                foreach ($lists as $k=>$v) {
                    $id[$k] = $lists[$k]['id'];
                }
                $ids = implode(',',$id); // 把有客户的业务员id拼接成字符串
            } else {
                $ids = 0;
            }
            $other_admin = Db::name('admin')->where('id','not in',$ids)->where('groupid',4)->field('nickname')->select();
            foreach ($other_admin as &$v) {
                $v['num'] = 0;
            }
            $data = array_merge($lists,$other_admin);
            return json(['code' => 220, 'msg' => '', 'count' => $count, 'data' => $data]);
        }
        return $this->fetch('reply_customer');
    }
    /**
     * 月度成交客户排行榜
     */
    public function yes_customer()
    {
        if (request()->isAjax()) {
            extract(input());
            $map = [];
            $whereTime = [];
            if (isset($start) && $start != "" && isset($end) && $end != "") {
                $whereTime = [strtotime($start), strtotime($end)];
            } else {
                $ymd = date('Y-m',time());
                $time = strtotime($ymd);
                $whereTime = [$time, time()];
            }
            $Nowpage = input('page') ? input('page') : 1;
            $limits = input("limit") ? input("limit") : 10;// 获取总条数;
            $field = input('field');                       //字段
            $order = input('order');                       //排序方式
            if ($field && $order) {
                $od = "a." . $field . " " . $order;
            } else {
                $od = "a.create_time desc";
            }
            $user = new UserModel();
            $count = $user->getUserCount($map);
            $lists = $user->getURankingByWhere($map, $od, $Nowpage, $limits,2,$whereTime);
            if ($lists) {
                foreach ($lists as $k=>$v) {
                    $id[$k] = $lists[$k]['id'];
                }
                $ids = implode(',',$id); // 把有客户的业务员id拼接成字符串
            } else {
                $ids = 0;
            }
            $other_admin = Db::name('admin')->where('id','not in',$ids)->where('groupid',4)->field('nickname')->select();
            foreach ($other_admin as &$v) {
                $v['num'] = 0;
            }
            $data = array_merge($lists,$other_admin);
            return json(['code' => 220, 'msg' => '', 'count' => $count, 'data' => $data]);
        }
        return $this->fetch();
    }
}