审查视图

application/common/controller/Backend.php 17.5 KB
Karson authored
1 2 3 4 5 6 7 8 9
<?php

namespace app\common\controller;

use app\admin\library\Auth;
use think\Config;
use think\Controller;
use think\Hook;
use think\Lang;
10
use think\Loader;
Karson authored
11
use think\Session;
12
use fast\Tree;
Karson authored
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

/**
 * 后台控制器基类
 */
class Backend extends Controller
{

    /**
     * 无需登录的方法,同时也就不需要鉴权了
     * @var array
     */
    protected $noNeedLogin = [];

    /**
     * 无需鉴权的方法,但需要登录
     * @var array
     */
    protected $noNeedRight = [];

    /**
     * 布局模板
     * @var string
     */
    protected $layout = 'default';

    /**
     * 权限控制类
     * @var Auth
     */
    protected $auth = null;

    /**
45 46 47 48 49 50
     * 模型对象
     * @var \think\Model
     */
    protected $model = null;

    /**
Karson authored
51 52 53 54 55 56 57 58 59 60 61 62
     * 快速搜索时执行查找的字段
     */
    protected $searchFields = 'id';

    /**
     * 是否是关联查询
     */
    protected $relationSearch = false;

    /**
     * 是否开启数据限制
     * 支持auth/personal
63
     * 表示按权限判断/仅限个人
Karson authored
64 65 66 67 68 69 70 71
     * 默认为禁用,若启用请务必保证表中存在admin_id字段
     */
    protected $dataLimit = false;

    /**
     * 数据限制字段
     */
    protected $dataLimitField = 'admin_id';
72
73 74 75 76
    /**
     * 数据限制开启时自动填充限制字段值
     */
    protected $dataLimitFieldAutoFill = true;
Karson authored
77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93

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

    /**
     * 是否开启模型场景验证
     */
    protected $modelSceneValidate = false;

    /**
     * Multi方法可批量修改的字段
     */
    protected $multiFields = 'status';

    /**
94 95 96 97 98
     * Selectpage可显示的字段
     */
    protected $selectpageFields = '*';

    /**
99 100 101 102 103
     * 前台提交过来,需要排除的字段数据
     */
    protected $excludeFields = "";

    /**
104 105 106 107 108 109 110
     * 导入文件首行类型
     * 支持comment/name
     * 表示注释或字段名
     */
    protected $importHeadType = 'comment';

    /**
Karson authored
111 112 113 114 115 116 117
     * 引入后台控制器的traits
     */
    use \app\admin\library\traits\Backend;

    public function _initialize()
    {
        $modulename = $this->request->module();
118
        $controllername = Loader::parseName($this->request->controller());
Karson authored
119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136
        $actionname = strtolower($this->request->action());

        $path = str_replace('.', '/', $controllername) . '/' . $actionname;

        // 定义是否Addtabs请求
        !defined('IS_ADDTABS') && define('IS_ADDTABS', input("addtabs") ? TRUE : FALSE);

        // 定义是否Dialog请求
        !defined('IS_DIALOG') && define('IS_DIALOG', input("dialog") ? TRUE : FALSE);

        // 定义是否AJAX请求
        !defined('IS_AJAX') && define('IS_AJAX', $this->request->isAjax());

        $this->auth = Auth::instance();

        // 设置当前请求的URI
        $this->auth->setRequestUri($path);
        // 检测是否需要验证登录
137
        if (!$this->auth->match($this->noNeedLogin)) {
Karson authored
138
            //检测是否登录
139
            if (!$this->auth->isLogin()) {
Karson authored
140 141 142
                Hook::listen('admin_nologin', $this);
                $url = Session::get('referer');
                $url = $url ? $url : $this->request->url();
143 144 145 146
                if ($url == '/') {
                    $this->redirect('index/login', [], 302, ['referer' => $url]);
                    exit;
                }
Karson authored
147 148 149
                $this->error(__('Please login first'), url('index/login', ['url' => $url]));
            }
            // 判断是否需要验证权限
150
            if (!$this->auth->match($this->noNeedRight)) {
Karson authored
151
                // 判断控制器和方法判断是否有对应权限
152
                if (!$this->auth->check($path)) {
Karson authored
153 154 155 156 157 158 159
                    Hook::listen('admin_nopermission', $this);
                    $this->error(__('You have no permission'), '');
                }
            }
        }

        // 非选项卡时重定向
160 161
        if (!$this->request->isPost() && !IS_AJAX && !IS_ADDTABS && !IS_DIALOG && input("ref") == 'addtabs') {
            $url = preg_replace_callback("/([\?|&]+)ref=addtabs(&?)/i", function ($matches) {
Karson authored
162 163
                return $matches[2] == '&' ? $matches[1] : '';
            }, $this->request->url());
164 165
            if (Config::get('url_domain_deploy')) {
                if (stripos($url, $this->request->server('SCRIPT_NAME')) === 0) {
166 167 168 169
                    $url = substr($url, strlen($this->request->server('SCRIPT_NAME')));
                }
                $url = url($url, '', false);
            }
Karson authored
170 171 172 173 174 175 176 177 178 179
            $this->redirect('index/index', [], 302, ['referer' => $url]);
            exit;
        }

        // 设置面包屑导航数据
        $breadcrumb = $this->auth->getBreadCrumb($path);
        array_pop($breadcrumb);
        $this->view->breadcrumb = $breadcrumb;

        // 如果有使用模板布局
180
        if ($this->layout) {
Karson authored
181 182 183 184
            $this->view->engine->layout('layout/' . $this->layout);
        }

        // 语言检测
185
        $lang = strip_tags($this->request->langset());
Karson authored
186 187 188 189 190 191 192 193 194 195

        $site = Config::get("site");

        $upload = \app\common\model\Config::upload();

        // 上传信息配置后
        Hook::listen("upload_config_init", $upload);

        // 配置信息
        $config = [
196
            'site'           => array_intersect_key($site, array_flip(['name', 'indexurl', 'cdnurl', 'version', 'timezone', 'languages'])),
Karson authored
197 198 199 200 201 202 203 204 205 206
            'upload'         => $upload,
            'modulename'     => $modulename,
            'controllername' => $controllername,
            'actionname'     => $actionname,
            'jsname'         => 'backend/' . str_replace('.', '/', $controllername),
            'moduleurl'      => rtrim(url("/{$modulename}", '', false), '/'),
            'language'       => $lang,
            'fastadmin'      => Config::get('fastadmin'),
            'referer'        => Session::get("referer")
        ];
207
        $config = array_merge($config, Config::get("view_replace_str"));
208
Karson authored
209
        Config::set('upload', array_merge(Config::get('upload'), $upload));
210
Karson authored
211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230
        // 配置信息后
        Hook::listen("config_init", $config);
        //加载当前控制器语言包
        $this->loadlang($controllername);
        //渲染站点配置
        $this->assign('site', $site);
        //渲染配置信息
        $this->assign('config', $config);
        //渲染权限对象
        $this->assign('auth', $this->auth);
        //渲染管理员对象
        $this->assign('admin', Session::get('admin'));
    }

    /**
     * 加载语言文件
     * @param string $name
     */
    protected function loadlang($name)
    {
231
        Lang::load(APP_PATH . $this->request->module() . '/lang/' . $this->request->langset() . '/' . str_replace('.', '/', $name) . '.php');
Karson authored
232 233 234 235 236
    }

    /**
     * 渲染配置信息
     * @param mixed $name 键名或数组
237
     * @param mixed $value 值
Karson authored
238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260
     */
    protected function assignconfig($name, $value = '')
    {
        $this->view->config = array_merge($this->view->config ? $this->view->config : [], is_array($name) ? $name : [$name => $value]);
    }

    /**
     * 生成查询所需要的条件,排序方式
     * @param mixed $searchfields 快速查询的字段
     * @param boolean $relationSearch 是否关联查询
     * @return array
     */
    protected function buildparams($searchfields = null, $relationSearch = null)
    {
        $searchfields = is_null($searchfields) ? $this->searchFields : $searchfields;
        $relationSearch = is_null($relationSearch) ? $this->relationSearch : $relationSearch;
        $search = $this->request->get("search", '');
        $filter = $this->request->get("filter", '');
        $op = $this->request->get("op", '', 'trim');
        $sort = $this->request->get("sort", "id");
        $order = $this->request->get("order", "DESC");
        $offset = $this->request->get("offset", 0);
        $limit = $this->request->get("limit", 0);
261 262
        $filter = (array)json_decode($filter, TRUE);
        $op = (array)json_decode($op, TRUE);
Karson authored
263 264 265
        $filter = $filter ? $filter : [];
        $where = [];
        $tableName = '';
266 267 268 269 270 271 272 273
        if ($relationSearch) {
            if (!empty($this->model)) {
                $name = \think\Loader::parseName(basename(str_replace('\\', '/', get_class($this->model))));
                $tableName = $name . '.';
            }
            $sortArr = explode(',', $sort);
            foreach ($sortArr as $index => & $item) {
                $item = stripos($item, ".") === false ? $tableName . trim($item) : $item;
Karson authored
274
            }
275 276
            unset($item);
            $sort = implode(',', $sortArr);
Karson authored
277 278
        }
        $adminIds = $this->getDataLimitAdminIds();
279
        if (is_array($adminIds)) {
280
            $where[] = [$tableName . $this->dataLimitField, 'in', $adminIds];
Karson authored
281
        }
282
        if ($search) {
Karson authored
283
            $searcharr = is_array($searchfields) ? $searchfields : explode(',', $searchfields);
284
            foreach ($searcharr as $k => &$v) {
Karson authored
285 286 287 288 289
                $v = stripos($v, ".") === false ? $tableName . $v : $v;
            }
            unset($v);
            $where[] = [implode("|", $searcharr), "LIKE", "%{$search}%"];
        }
290
        foreach ($filter as $k => $v) {
Karson authored
291
            $sym = isset($op[$k]) ? $op[$k] : '=';
292
            if (stripos($k, ".") === false) {
Karson authored
293 294
                $k = $tableName . $k;
            }
295
            $v = !is_array($v) ? trim($v) : $v;
Karson authored
296
            $sym = strtoupper(isset($op[$k]) ? $op[$k] : $sym);
297
            switch ($sym) {
Karson authored
298
                case '=':
299
                case '<>':
300
                    $where[] = [$k, $sym, (string)$v];
Karson authored
301 302 303 304 305 306 307 308 309 310 311 312 313
                    break;
                case 'LIKE':
                case 'NOT LIKE':
                case 'LIKE %...%':
                case 'NOT LIKE %...%':
                    $where[] = [$k, trim(str_replace('%...%', '', $sym)), "%{$v}%"];
                    break;
                case '>':
                case '>=':
                case '<':
                case '<=':
                    $where[] = [$k, $sym, intval($v)];
                    break;
314
                case 'FINDIN':
315
                case 'FINDINSET':
316
                case 'FIND_IN_SET':
317
                    $where[] = "FIND_IN_SET('{$v}', " . ($relationSearch ? $k : '`' . str_replace('.', '`.`', $k) . '`') . ")";
318
                    break;
Karson authored
319 320 321 322
                case 'IN':
                case 'IN(...)':
                case 'NOT IN':
                case 'NOT IN(...)':
323
                    $where[] = [$k, str_replace('(...)', '', $sym), is_array($v) ? $v : explode(',', $v)];
Karson authored
324 325 326 327 328
                    break;
                case 'BETWEEN':
                case 'NOT BETWEEN':
                    $arr = array_slice(explode(',', $v), 0, 2);
                    if (stripos($v, ',') === false || !array_filter($arr))
329
                        continue 2;
Karson authored
330
                    //当出现一边为空时改变操作符
331
                    if ($arr[0] === '') {
Karson authored
332 333
                        $sym = $sym == 'BETWEEN' ? '<=' : '>';
                        $arr = $arr[1];
334
                    } else if ($arr[1] === '') {
Karson authored
335 336 337 338 339 340 341 342 343 344
                        $sym = $sym == 'BETWEEN' ? '>=' : '<';
                        $arr = $arr[0];
                    }
                    $where[] = [$k, $sym, $arr];
                    break;
                case 'RANGE':
                case 'NOT RANGE':
                    $v = str_replace(' - ', ',', $v);
                    $arr = array_slice(explode(',', $v), 0, 2);
                    if (stripos($v, ',') === false || !array_filter($arr))
345
                        continue 2;
Karson authored
346
                    //当出现一边为空时改变操作符
347
                    if ($arr[0] === '') {
Karson authored
348 349
                        $sym = $sym == 'RANGE' ? '<=' : '>';
                        $arr = $arr[1];
350
                    } else if ($arr[1] === '') {
Karson authored
351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369
                        $sym = $sym == 'RANGE' ? '>=' : '<';
                        $arr = $arr[0];
                    }
                    $where[] = [$k, str_replace('RANGE', 'BETWEEN', $sym) . ' time', $arr];
                    break;
                case 'LIKE':
                case 'LIKE %...%':
                    $where[] = [$k, 'LIKE', "%{$v}%"];
                    break;
                case 'NULL':
                case 'IS NULL':
                case 'NOT NULL':
                case 'IS NOT NULL':
                    $where[] = [$k, strtolower(str_replace('IS ', '', $sym))];
                    break;
                default:
                    break;
            }
        }
370 371 372
        $where = function ($query) use ($where) {
            foreach ($where as $k => $v) {
                if (is_array($v)) {
Karson authored
373
                    call_user_func_array([$query, 'where'], $v);
374
                } else {
Karson authored
375 376 377 378 379 380 381 382 383 384 385 386 387 388
                    $query->where($v);
                }
            }
        };
        return [$where, $sort, $order, $offset, $limit];
    }

    /**
     * 获取数据限制的管理员ID
     * 禁用数据限制时返回的是null
     * @return mixed
     */
    protected function getDataLimitAdminIds()
    {
389
        if (!$this->dataLimit) {
Karson authored
390 391
            return null;
        }
392
        if ($this->auth->isSuperAdmin()) {
393 394
            return null;
        }
Karson authored
395
        $adminIds = [];
396
        if (in_array($this->dataLimit, ['auth', 'personal'])) {
Karson authored
397 398 399 400 401 402 403
            $adminIds = $this->dataLimit == 'auth' ? $this->auth->getChildrenAdminIds(true) : [$this->auth->id];
        }
        return $adminIds;
    }

    /**
     * Selectpage的实现方法
404
     *
Karson authored
405 406
     * 当前方法只是一个比较通用的搜索匹配,请按需重载此方法来编写自己的搜索逻辑,$where按自己的需求写即可
     * 这里示例了所有的参数,所以比较复杂,实现上自己实现只需简单的几行即可
407
     *
Karson authored
408 409 410 411 412 413 414
     */
    protected function selectpage()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags', 'htmlspecialchars']);

        //搜索关键词,客户端输入以空格分开,这里接收为数组
415
        $word = (array)$this->request->request("q_word/a");
Karson authored
416
        //当前页
417
        $page = $this->request->request("pageNumber");
Karson authored
418
        //分页大小
419
        $pagesize = $this->request->request("pageSize");
Karson authored
420
        //搜索条件
421
        $andor = $this->request->request("andOr", "and", "strtoupper");
Karson authored
422
        //排序方式
423
        $orderby = (array)$this->request->request("orderBy/a");
Karson authored
424
        //显示的字段
425
        $field = $this->request->request("showField");
Karson authored
426
        //主键
427
        $primarykey = $this->request->request("keyField");
Karson authored
428
        //主键值
429
        $primaryvalue = $this->request->request("keyValue");
Karson authored
430
        //搜索字段
431
        $searchfield = (array)$this->request->request("searchField/a");
Karson authored
432
        //自定义搜索条件
433
        $custom = (array)$this->request->request("custom/a");
434 435 436
        //是否返回树形结构
        $istree = $this->request->request("isTree", 0);
        $ishtml = $this->request->request("isHtml", 0);
437
        if ($istree) {
438 439 440
            $word = [];
            $pagesize = 99999;
        }
Karson authored
441
        $order = [];
442
        foreach ($orderby as $k => $v) {
Karson authored
443 444 445 446 447
            $order[$v[0]] = $v[1];
        }
        $field = $field ? $field : 'name';

        //如果有primaryvalue,说明当前是初始化传值
448
        if ($primaryvalue !== null) {
Karson authored
449
            $where = [$primarykey => ['in', $primaryvalue]];
450 451
        } else {
            $where = function ($query) use ($word, $andor, $field, $searchfield, $custom) {
452 453
                $logic = $andor == 'AND' ? '&' : '|';
                $searchfield = is_array($searchfield) ? implode($logic, $searchfield) : $searchfield;
454
                foreach ($word as $k => $v) {
455
                    $query->where(str_replace(',', $logic, $searchfield), "like", "%{$v}%");
Karson authored
456
                }
457 458
                if ($custom && is_array($custom)) {
                    foreach ($custom as $k => $v) {
459 460 461 462 463
                        if (is_array($v) && 2 == count($v)) {
                            $query->where($k, trim($v[0]), $v[1]);
                        } else {
                            $query->where($k, '=', $v);
                        }
Karson authored
464 465 466 467 468
                    }
                }
            };
        }
        $adminIds = $this->getDataLimitAdminIds();
469
        if (is_array($adminIds)) {
Karson authored
470 471 472 473
            $this->model->where($this->dataLimitField, 'in', $adminIds);
        }
        $list = [];
        $total = $this->model->where($where)->count();
474 475
        if ($total > 0) {
            if (is_array($adminIds)) {
Karson authored
476 477
                $this->model->where($this->dataLimitField, 'in', $adminIds);
            }
478
            $datalist = $this->model->where($where)
479 480
                ->order($order)
                ->page($page, $pagesize)
481
                ->field($this->selectpageFields)
482
                ->select();
483 484 485 486
            foreach ($datalist as $index => $item) {
                unset($item['password'], $item['salt']);
                $list[] = [
                    $primarykey => isset($item[$primarykey]) ? $item[$primarykey] : '',
487 488
                    $field      => isset($item[$field]) ? $item[$field] : '',
                    'pid'       => isset($item['pid']) ? $item['pid'] : 0
489 490
                ];
            }
491 492 493 494 495 496 497 498 499 500 501
            if($istree) {
                $tree = Tree::instance();
                $tree->init(collection($list)->toArray(), 'pid');
                $list = $tree->getTreeList($tree->getTreeArray(0), $field);
                if(!$ishtml){
                    foreach ($list as &$item) {
                        $item = str_replace('&nbsp;', ' ', $item);
                    }
                    unset($item);
                }
            }
Karson authored
502 503 504 505 506 507
        }
        //这里一定要返回有list这个字段,total是可选的,如果total<=list的数量,则会隐藏分页按钮
        return json(['list' => $list, 'total' => $total]);
    }

}