book_admin/application/admin/controller/Shortdomain.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use app\common\library\Redis;
use think\Exception;

/**
 * 短链域名池
 *
 * @author duanej@dianzhong.com
 * @modify liues@dianzhong.com
 * @date 2018-08-15 17:38:20
 * @icon fa fa-circle-o
 */
class Shortdomain extends Backend
{
    
    /**
     * ShortDomain模型对象
     */
    protected $model = null;

    /**
     * 是否开启Validate验证
     */
    protected $modelValidate = true;

    /**
     * 初始化数据
     */
    public function _initialize()
    {
        parent::_initialize();
        $this->model = model('ShortDomain');
        $this->view->assign("statusList", $this->model->getStatusList());
    }
    
    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个方法
     * 因此在当前控制器中可不用编写增删改查的代码,如果需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */

    /**
     * 添加/支持批量
     *
     * @author liues@dianzhong.com
     * @date 2018-08-17 18:43:13
     * @return html|json
     */
    public function add()
    {
        if ($this->request->isPost())
        {
            $hosts = trim($this->request->post("row.host"));
            $status = $this->request->post("row.status") ?? '1';

            if($hosts)
            {
                $params = array();
                $hosts = explode("\r\n", $hosts);
                $hosts = array_unique(array_filter($hosts));
                if(count($hosts) > 50){
                    $this->error('单次批量添加上限50条');
                }
                foreach($hosts as $key => $host)
                {
                    if(!empty($host))
                    {
                        if(mb_strlen($host) > 150)
                        {
                            $this->error("每条域名长度不能超过150字符\r\n".$host);
                        }
                        $exists = model('ShortDomain')->getByHost($host);
                        if(empty($exists))
                        {
                            $params[] = array('host' => $host, 'status' => $status);
                        }
                    }
                }

                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);
                    }

                    $result = $this->model->allowField(true)->saveAll($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)
            {
                /*
                 * 已经弃用,如果为了兼容老版可取消注释
                  foreach ($params as $k => &$v)
                  {
                  $v = is_array($v) ? implode(',', $v) : $v;
                  }
                 */
                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);
                    }
                    if(!$params['status']){
                        $this->close($row['id']);
                    }
                    $whereMap['host'] = $params['host'];
                    $whereMap['id'] = ['neq',$row['id']];
                    $params['updatetime'] = time();
                    if($this->model->where($whereMap)->find()){
                        $this->error('域名已存在,请保持域名唯一性');
                    }
                    $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();
    }

    /**
     * 删除
     *
     * @author liues@dianzhong.com
     * @date 2018-08-18 10:16:29
     * @param string $ids
     * @return json
     */
    public function del($ids = "")
    {
        //严禁删除
        $this->error(__('No rows were deleted'));
    }

    /**
     * 启用
     *
     * @author liues@dianzhong.com
     * @date 2018-08-17 18:44:02
     * @param null $ids
     * @return html|json
     */
    public function open($ids = NULL){
        if ($ids)
        {
            $pk = $this->model->getPk();
            $adminIds = $this->getDataLimitAdminIds();
            if (is_array($adminIds))
            {
                $count = $this->model->where($this->dataLimitField, 'in', $adminIds);
            }
            $list = $this->model->where($pk, 'in', $ids)->select();
            $count = 0;
            foreach ($list as $k => $v)
            {
                $count += $v->where($pk, $v->id)->update(['status'=>'1','updatetime'=>time()]);
            }
            if ($count)
            {
                $this->success();
            }
            else
            {
                $this->error(__('No rows were updated'));
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }

    /**
     * 关闭
     *
     * @author liues@dianzhong.com
     * @date 2018-08-17 18:44:02
     * @param null $ids
     * @return html|json
     */
    public function close($ids = NULL){
        if ($ids)
        {
            $pk = $this->model->getPk();
            $adminIds = $this->getDataLimitAdminIds();
            if (is_array($adminIds))
            {
                $count = $this->model->where($this->dataLimitField, 'in', $adminIds);
            }
            $list = $this->model->where($pk, 'in', $ids)->select();
            $count = 0;
            foreach ($list as $k => $v)
            {
                try{
                    $count += $v->where($pk, $v->id)->update(['status'=>'0','updatetime'=>time()]);
                    $relations = model('ShortRelation')->where('domain_id',$v->id)->column('admin_id'); //查询当前所有关联
                    if(!empty($relations)){
                        foreach ($relations as $val){
                            if(!model('ShortRelation')->where(['admin_id'=>$val])->where('domain_id','<>',$v['id'])->find()){ //除此短链外，没有任何其他短链了
                                model('AdminConfig')->where(['admin_id'=>$val])->update(['guide_domain'=>'0']);
                                model('AdminConfig')->delAdminInfoAllCache($val);
                            }
                        }
                    }
                    model('ShortRelation')->where('domain_id',$v['id'])->delete(); //禁用后解除绑定关系
                }catch (Exception $e){
                }
            }
            if ($count)
            {
                $this->success();
            }
            else
            {
                $this->error(__('No rows were updated'));
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }

}