odd_job/app/agent/controller/Partner.php

<?php

namespace app\agent\controller;

use app\agent\BaseController;
use app\common\model\Broker as BrokerModel;
use app\common\model\BrokerIncome as BrokerIncomeModel;
use app\common\model\User as UserModel;

class Partner extends BaseController
{

    public function index()
    {
        return view('partner/index');
    }

    public function listPartner()
    {
        $agentid  = $this->access_agent['id'];
        $limit    = input('limit/d', 20);
        $page     = input('page/d', 1);
        $map      = [];
        $map[]    = ['agentid', '=', $agentid];
        $map[]    = ['is_partner', '=', 1];
        $keywords = input('keywords/s');
        if (!empty($keywords)) {
            $map[] = ['title', 'like', '%' . $keywords . '%'];
        }
        $status = input('status/d');
        if (!empty($status)) {
            $map[] = ['status', '=', $status];
        }
        $list  = BrokerModel::with(['agent', 'muser'])
            ->withCount(['user'])
            ->where($map)
            ->order('id', 'DESC')
            ->limit($limit)
            ->page($page)
            ->append(['status_text'])
            ->select();
        $count = BrokerModel::where($map)->count();
        if ($count == 0) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "未查询到数据",
            ]));
        }
        foreach ($list as $v) {
            $broker_ids = BrokerModel::where('pid', $v['id'])->column('id');
            if (empty($broker_ids)) {
                $broker_ids = [$v['id']];
            } else {
                $broker_ids[] = $v['id'];
            }
            $v['group_income']       = BrokerModel::whereIn('id', $broker_ids)->sum('income');
            $v['group_income_total'] = BrokerModel::whereIn('id', $broker_ids)->sum('income_total');
            $v['user_count']         = UserModel::whereIn('brokerid', $broker_ids)->count();
            $v['below_count']       = BrokerModel::where('pid', $v['id'])->count();
        }
        exit(json_encode([
            'code'  => 0,
            'msg'   => "",
            'count' => $count,
            'data'  => $list,
        ]));
    }

    public function transferFrom()
    {
        $broker_id   = input('broker_id/d, 0');
        $agentid     = $this->access_agent['id'];
        $broker_list = BrokerModel::where('agentid', $agentid)
            ->where('id', '<>', $broker_id)
            ->where('is_partner', '1')
            ->select();
        return view('partner/transferform', [
            'origin_broker_id' => $broker_id,
            'broker_list'      => $broker_list,
        ]);
    }

    public function edittransfer()
    {
        $origin_broker_id = input('origin_broker_id/d, 0');
        $broker_id        = input('broker_id/d, 0');
        if (empty($origin_broker_id) || empty($broker_id)) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "参数错误",
            ]));
        }
        if ($origin_broker_id == $broker_id) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "不可以转移给自己",
            ]));
        }

        $origin_broker = BrokerModel::where('id', $origin_broker_id)->find();
        $broker        = BrokerModel::where('id', $broker_id)->find();
        if (empty($origin_broker) || empty($broker)) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "参数错误",
            ]));
        }
        if ($origin_broker['agentid'] != $broker['agentid']) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "只有相同门店的经纪人才可以转移",
            ]));
        }

        BrokerModel::where('pid', $origin_broker_id)->update(['pid' => $broker_id]);
        exit(json_encode([
            'code' => 0,
        ]));
    }

    public function incomeList()
    {
        $brokerid = input('id');
        if (empty($brokerid)) {
            exit("未查询到数据");
        }

        return view('partner/incomelist', [
            'brokerid' => $brokerid,
        ]);
    }

    public function listIncome()
    {
        $brokerid = input('brokerid');
        if (empty($brokerid)) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "未查询到数据",
            ]));
        }

        $limit      = input('limit/d', 20);
        $page       = input('page/d', 1);
        $broker_ids = BrokerModel::where('pid', $brokerid)->column('id');
        if (empty($broker_ids)) {
            $broker_ids = [$brokerid];
        } else {
            $broker_ids[] = $brokerid;
        }
        $map   = [
            ['brokerid', 'in', $broker_ids],
        ];
        $list  = BrokerIncomeModel::with(['broker'])->where($map)->order('id', 'DESC')->limit($limit)->page($page)->append(['status_text', 'powerreport_text'])->select();
        $count = BrokerIncomeModel::where($map)->count();
        if ($count == 0) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "未查询到数据",
            ]));
        }
        exit(json_encode([
            'code'  => 0,
            'msg'   => "",
            'count' => $count,
            'data'  => $list,
        ]));
    }

    public function below()
    {
        $brokerid = input('broker_id');
        if (empty($brokerid)) {
            exit("未查询到数据");
        }
        $agent = $this->access_agent;
        return view('partner/below', [
            'brokerid' => $brokerid,
            'agent'    => $agent,
        ]);
    }

    public function listbelow()
    {
        $brokerid = input('broker_id');
        if (empty($brokerid)) {
            exit("未查询到数据");
        }

        $agentid  = $this->access_agent['id'];
        $limit    = input('limit/d', 20);
        $page     = input('page/d', 1);
        $map      = [];
        $map[]    = ['agentid', '=', $agentid];
        $map[]    = ['pid', '=', $brokerid];
        $list  = BrokerModel::with(['agent', 'muser'])
            ->withCount(['user'])
            ->where($map)
            ->order('id', 'DESC')
            ->limit($limit)
            ->page($page)
            ->append(['status_text', 'powerreport_text', 'type_text', 'is_partner_text'])
            ->select();
        $count = BrokerModel::where($map)->count();
        if ($count == 0) {
            exit(json_encode([
                'code' => 1,
                'msg'  => "未查询到数据",
            ]));
        }
        exit(json_encode([
            'code'  => 0,
            'msg'   => "",
            'count' => $count,
            'data'  => $list,
        ]));
    }
}