mark/application/admin/controller/Protector.php

<?php

namespace app\admin\controller;

use app\admin\model\AuthGroup;
use app\admin\model\AuthGroupAccess;
use app\common\controller\Backend;
use think\Db;
use think\Session;

/**
 * 
 *
 * @icon fa fa-circle-o
 */
class Protector extends Backend
{
    private $status = [
        "PROTECTOR" => 0 , //保护中
        "OVERDUE" => 1, // 已过期
        "SIGN" => 2, // 已签单
        "FREE" => 3, // 冻结中
        "GIVEUP" => 4, // 已放弃
    ];

    //快速搜索的字段
    protected $searchFields = ['unit_name','contacts'];

    /**
     * 无需鉴权的方法,但需要登录
     * @var array
     */
    protected $noNeedRight = ['again','giveup','showfollow','addfollow','testingname','allsearch'];


    /**
     * Protector模型对象
     * @var \app\admin\model\Protector
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = model('Protector');

    }

    /**
     * 查看
     */
    public function index($status = false)
    {
        //设置过滤方法
        $this->request->filter(['strip_tags']);
        if ($this->request->isAjax())
        {
            // 先统一处理过期保护客户
            \app\admin\model\Protector::updateOverdue();

            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField'))
            {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();


            $where_usr_id =  \app\admin\model\Protector::getGroupWhere();


            switch ($status){
                case 'protect':                 //保护中
                    $total = $this->model
                        ->where('status',$this->status['PROTECTOR'])
                        ->where($where_usr_id)
                        ->where($where)
                        ->order($sort, $order)
                        ->count();
                    $list = $this->model
                        ->where('status',$this->status['PROTECTOR'])
                        ->where($where_usr_id)
                        ->where($where)
                        ->order($sort, $order)
                        ->limit($offset, $limit)
                        ->select();
                    break;
                case 'overdue':                 //已过期
                    $total = $this->model
                        ->where('status',$this->status['OVERDUE'])
                        ->where($where)
                        ->order($sort, $order)
                        ->count();
                    $list = $this->model
                        ->where('status',$this->status['OVERDUE'])
                        ->where($where)
                        ->order($sort, $order)
                        ->limit($offset, $limit)
                        ->select();
                    break;
                case 'contract':                 //已签单
                    $total = $this->model
                        ->where('status',$this->status['SIGN'])
                        ->where($where_usr_id)
                        ->where($where)
                        ->order($sort, $order)
                        ->count();
                    $list = $this->model
                        ->where('status',$this->status['SIGN'])
                        ->where($where_usr_id)
                        ->where($where)
                        ->order($sort, $order)
                        ->limit($offset, $limit)
                        ->select();
                    break;
                case 'giveup':                 //已放弃
                    $total = $this->model
                        ->where('status',$this->status['GIVEUP'])
                        ->where($where_usr_id)
                        ->where($where)
                        ->order($sort, $order)
                        ->count();
                    $list = $this->model
                        ->where('status',$this->status['GIVEUP'])
                        ->where($where_usr_id)
                        ->where($where)
                        ->order($sort, $order)
                        ->limit($offset, $limit)
                        ->select();
                    break;
            }


            $list = collection($list)->toArray();
            $result = array("total" => $total, "rows" => $list);

            return json($result);
        }
        return $this->view->fetch('index');
    }

    /**
     * 添加
     */
    public function add()
    {
        if ($this->request->isPost())
        {
            $params = $this->request->post("row/a");
            if ($params)
            {
                if ($this->dataLimit && $this->dataLimitFieldAutoFill)
                {
                    $params[$this->dataLimitField] = $this->auth->id;
                }
                try
                {
                    //是否采用模型验证
                    if ($this->modelValidate)
                    {
                        $name = basename(str_replace('\\', '/', get_class($this->model)));
                        $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.add' : true) : $this->modelValidate;
                        $this->model->validate($validate);
                    }

                    $params['usr_id'] = Session::get('admin')['id'];                //usr id
                    $params['usr_nickname'] = Session::get('admin')['nickname'];      //nickname
                    $protect_count = Session::get('admin')['protect_count'];    //保护个数
                    $protect_day = Session::get('admin')['protect_day'];        //保护天数
                    $free_day = Session::get('admin')['free_day'];              // 冻结天数
                    $params['pro_date'] = date('Y-m-d H:i:s');    //保护时间
                    $params['total'] = ($params['number'] * $params['price']);      //总价


                    //  获取所属组名,id
                    $params['usr_depart'] = Session::get('admin')['usr_depart'];   //获取所属组名
                    $params['depart_id'] = Session::get('admin')['depart_id'];   //获取所属组id

                    //  获取到期时间和冻结到期时间
                    $params['ex_date'] = date('Y-m-d H:i:s',strtotime("+".$protect_day." day"));    //保护到期时间
                    $params['free_date'] = date('Y-m-d H:i:s',strtotime("{$params['ex_date']} "."+".$free_day." day"));    //保护到期时间

                    // 根据单位名称判断是否已经存在（已被保护）
                    $res = \app\admin\model\Protector::unitNameIsExist($params['unit_name']);
                    if($res){
                        $this->error($res);
                    }

                    // 判断是否超出保护个数
                    $res = \app\admin\model\Protector::proCountIsExceed($params['usr_id'], $protect_count);
                    if($res){
                        $this->error($res);
                    }


                    $result = $this->model->allowField(true)->save($params);
                    if ($result !== false)
                    {
                        $this->success();
                    }
                    else
                    {
                        $this->error($this->model->getError());
                    }
                }
                catch (\think\exception\PDOException $e)
                {
                    $this->error($e->getMessage());
                }
            }
            $this->error(__('Parameter %s can not be empty', ''));
        }
        return $this->view->fetch();
    }

    /**
     * 编辑
     */
    public function edit($ids = NULL)
    {
        $row = $this->model->get($ids);
        if (!$row)
            $this->error(__('No Results were found'));
        $adminIds = $this->getDataLimitAdminIds();
        if (is_array($adminIds))
        {
            if (!in_array($row[$this->dataLimitField], $adminIds))
            {
                $this->error(__('You have no permission'));
            }
        }
        if ($this->request->isPost())
        {
            $params = $this->request->post("row/a");
            if ($params)
            {
                try
                {
                    //是否采用模型验证
                    if ($this->modelValidate)
                    {
                        $name = basename(str_replace('\\', '/', get_class($this->model)));
                        $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : true) : $this->modelValidate;
                        $row->validate($validate);
                    }
                    $params['total'] = ($params['number'] * $params['price']);      //总价
                    $result = $row->allowField(true)->save($params);
                    if ($result !== false)
                    {
                        $this->success();
                    }
                    else
                    {
                        $this->error($row->getError());
                    }
                }
                catch (\think\exception\PDOException $e)
                {
                    $this->error($e->getMessage());
                }
            }
            $this->error(__('Parameter %s can not be empty', ''));
        }
        $this->view->assign("row", $row);
        return $this->view->fetch();
    }


    /**
     * 放弃
     */
    public function giveup() {
        try {
            //1.获取id
            $id = $this->request->post("id");

            //2.protector表 通过id 查找出数据
            $protector = \app\admin\model\Protector::get($id);

            //3.获取用户id
            $usr_id = Session::get('admin')['id'];

            //4.判断用户id和 protector的用户id是否一致 保存状态
            if ($usr_id != 1 && $protector['usr_id'] != $usr_id) {
                $this->error('请操作自己的数据！');
            }

            //5.保护到期时间设置现在 冻结算一下
            $free_day = Session::get('admin')['free_day'];
            $param['ex_date'] = date('Y-m-d');
            $param['free_date'] = date('Y-m-d', strtotime("+" . $free_day . " day"));

            $param['status'] = $this->status['GIVEUP'];
            $param['id'] = $id;


            //6.入库
            $res = $this->model->allowField(true)->isUpdate(true)->save($param);
            if ($res) {
                $this->success('放弃成功！');
            }
            $this->error();
        } catch (\think\exception\PDOException $e)
        {
            $this->error($e->getMessage());
        }
    }

    /**
     * 签单
     */
    public function sign($ids = NULL) {
        //1.protector表 通过id 查找出数据
        $protector = \app\admin\model\Protector::get($ids);

        //2.获取用户id
        $usr_id = Session::get('admin')['id'];

        //3.判断用户id和 protector的用户id是否一致 保存状态
//        if($usr_id != 1){
//            $this->error('只有管理员可以签单!');
//        }
//        if ($usr_id != 1 && $protector['usr_id'] != $usr_id) {
//            $this->error('请操作自己的数据！');
//        }
        if($_POST){
            $data = $this->request->post();
            $param['status'] = $this->status['SIGN'];
            $param['again_date'] = $data['row']['again_date'];
            $res = Db::table('protector')->where('id',$data['id'])->update($param);
            if($res){
                $this->success();
            }else{
                $this->error('数据修改失败');
            } 
        }
        $this->view->assign("id", $ids);

        return $this->view->fetch();

    }

    /**
     * 再次保护
     */
    public function again() {
        try{
            //1.获取id
            $id = $this->request->post("id");

            //2.protector表 通过id 查找出数据
            $protector = \app\admin\model\Protector::get($id);

            //3.获取用户id
            $usr_id = Session::get('admin')['id'];

            //4.判断用户保护个数是否达到上限
            $res = \app\admin\model\Protector::proCountIsExceed($usr_id, Session::get('admin')['protect_count']);
            if($res){
                $this->error('用户保护人数已经达到上限('.Session::get('admin')['protect_count'].'个)');
            }

            //5 判断 protector表 状态 如果是已签单返回
            if($protector['status'] == $this->status['SIGN']){
                $this->error('已签单！无法再次保护');
            }

            //6 已过期，已放弃
            if($protector['status'] != $this->status['OVERDUE'] && $protector['status'] != $this->status['GIVEUP']){
                $this->error('已过期或已放弃才可以再次保护！');
            }

             //7.判断用户id和 protector的用户id是否一致 保
             if($protector['usr_id'] == $usr_id) {
                // 同一个人操作,判断是否结束冻结
                 if(strtotime(date('Y-m-d')) < strtotime($protector['free_date'])){
                     $this->error('未过冻结时间('.$protector['free_date'].')！无法再次保护');
                 }
             }

             // 不同的人操作或者已经过了冻结期
            $protect_day = Session::get('admin')['protect_day'];        //保护天数
            $free_day = Session::get('admin')['free_day'];              // 冻结天数
            $params['usr_id'] = $usr_id;                //usr id
            $params['usr_nickname'] = Session::get('admin')['nickname'];      //nickname
            $params['pro_date'] = date('Y-m-d');    //保护时间
            $params['ex_date'] = date('Y-m-d',strtotime("+".$protect_day." day"));    //保护到期时间
            $params['free_date'] = date('Y-m-d',strtotime("{$params['ex_date']} "."+".$free_day." day"));    //保护到期时间
            $params['usr_depart'] = AuthGroupAccess::getGroupName($params['usr_id']);
            $params['id'] = $id;
            $params['status'] = $this->status['PROTECTOR'];

            //5.入库
            $res = $this->model->allowField(true)->isUpdate(true)->save($params);
            if ($res) {
                $this->success('再次保护成功！');
            }
            $this->error();

         } catch (\think\exception\PDOException $e){
            $this->error($e->getMessage());
        }
    }

    public function follow($ids = NULL){
        $info = Db::table('follow')->where('type',0)->where('protect_id',$ids)->field('created_at','main')->select();
        if($_POST){
            $data = $this->request->post();
            $unit = Db::table('protector')->where('id',$data['id'])->field('unit_name')->find();
            $param['protect_id'] = $data['id'];
            $param['usr_id'] = Session::get('admin')['id'];
            $param['usr_nickname'] = $data['nickname'];
            $param['protect_name'] = $unit['unit_name'];
            $param['follow_time'] = $data['row']['follow_time'];
            $param['main'] = $data['row']['main'];
            $param['created_at'] = date('Y-m-d H:i:s');
            $param['type'] = 0;
            $res = Db::table('follow')->insert($param);
            if($res){
                $this->success();
            }else{
                $this->error('数据存储失败');
            } 
        }
        $this->view->assign("info", $info);
        $this->view->assign("id", $ids);
        $this->view->assign("nickname", Session::get('admin')['nickname']);
        return $this->view->fetch();
    }

    /**
     * 查看所有的跟进
     */
    public function showFollow()
    {
        try{
            $p_id = $this->request->post('id');
            $res = Db::table('follow')
                ->where('protect_id', $p_id)
                ->select();
            $html = '';
            if(!empty($res)){
                foreach ($res as $k=>$v){
                    $html .=
                        '        <div class="form-group col-xs-12">' .
                        '            <label for="follow_time" class="control-label col-xs-12 col-sm-3"><span class="text-red"></span>操作人：</label>' .
                        '            <div class="col-xs-12 col-sm-7">' .
                        '<span style="display: inline-block;padding-top: 7px;">'.$v["usr_nickname"] .'</span>'.
                        '            </div>' .
                        '        </div>';
                    $html .=
                        '        <div class="form-group col-xs-12">' .
                        '            <label for="follow_time" class="control-label col-xs-12 col-sm-3">跟进时间：</label>' .
                        '            <div class="col-xs-12 col-sm-7">' .
                        '<span style="display: inline-block;padding-top: 7px;">'.$v['follow_time'].'</span>'.
                        '            </div>' .
                        '        </div>';
                    $html .=
                        '    <div class="form-group col-xs-12" style="border-bottom: 1px solid #eeeeee;">' .
                        '        <label class="control-label col-xs-12 col-sm-3">跟进内容：</label>' .
                        '        <div class="col-xs-12 col-sm-7" style="margin-bottom: 10px;">' .
                        '            <textarea disabled class="form-control " rows="5" name="main" cols="50">'.
                        $v['main'].
                        '            </textarea>' .
                        '        </div>' .
                        '    </div>';
                }
            }
            $html .=
                '        <div class="form-group col-xs-12">' .
                '            <label for="follow_time" class="control-label col-xs-12 col-sm-3">跟进时间：</label>' .
                '            <div class="col-xs-12 col-sm-7">' .
                '                <input id="follow_time" class="form-control datetimepicker" name="follow_time" type="text" data-rule="required">' .
                '            </div>' .
                '        </div>';
            $html .=
                '    <div class="form-group col-xs-12">' .
                '        <label class="control-label col-xs-12 col-sm-3">跟进内容：</label>' .
                '        <div class="col-xs-12 col-sm-7">' .
                '            <textarea  id="main_text" class="form-control " rows="5" name="main" cols="50">'.
                '            </textarea>' .
                '        </div>' .
                '    </div>';
            $this->success('','',$html);


        } catch (\think\exception\PDOException $e){
            $this->error($e->getMessage());
        }

    }

    /**
     * 添加跟进
     */
    public function addFollow()
    {
        try{
            $data = $this->request->post();
            $param['protect_id'] = $data['id'];
            $param['usr_id'] = Session::get('admin')['id'];
            $param['usr_nickname'] = Session::get('admin')['nickname'];
            $param['protect_name'] = $data['unit_name'];
            $param['follow_time'] = $data['follow_time'];
            $param['main'] = $data['main'];
            $param['created_at'] = date('Y-m-d H:i:s');

            $res = Db::table('follow')
                ->insert($param);
            if($res){
                $this->success('跟进成功');
            }
            $this->error();

        } catch (\think\exception\PDOException $e){
            $this->error($e->getMessage());
        }
    }

    /**
     * 测试是否可以添加的单位
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function TestingName()
    {
        $unit_name = $this->request->post('unit_name');
        $res = \app\admin\model\Protector::unitNameIsExist($unit_name);

        if($res){
            $this->error($res);
        }
        $this->success('可以添加的单位名称!');

    }

    /**
     * 全系统搜索
     * @return string
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function allSearch()
    {
        $val = $this->request->post('val');

        $list = $this->model
            ->where('binary `unit_name` LIKE \'%'. $val .'%\'')
            ->select();

        foreach ($list as $k=>&$v){
            $v['unit_name'] = \app\admin\model\Protector::formatUnitName($v['unit_name'],$val);
        }

        $this->assign('list',$list);
        return $this->view->fetch('all_search');
    }







}