审查视图

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
        $actionname = strtolower($this->request->action());

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

        // 定义是否Addtabs请求
124
        !defined('IS_ADDTABS') && define('IS_ADDTABS', input("addtabs") ? true : false);
Karson authored
125 126

        // 定义是否Dialog请求
127
        !defined('IS_DIALOG') && define('IS_DIALOG', input("dialog") ? true : false);
Karson authored
128 129 130 131 132 133 134 135 136

        // 定义是否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
     */
    protected function assignconfig($name, $value = '')
    {
        $this->view->config = array_merge($this->view->config ? $this->view->config : [], is_array($name) ? $name : [$name => $value]);
    }

    /**
     * 生成查询所需要的条件,排序方式
246
     * @param mixed   $searchfields   快速查询的字段
Karson authored
247 248 249 250 251 252 253 254 255 256 257 258 259 260
     * @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
                    break;
                case 'BETWEEN':
                case 'NOT BETWEEN':
                    $arr = array_slice(explode(',', $v), 0, 2);
328
                    if (stripos($v, ',') === false || !array_filter($arr)) {
329
                        continue 2;
330
                    }
Karson authored
331
                    //当出现一边为空时改变操作符
332
                    if ($arr[0] === '') {
Karson authored
333 334
                        $sym = $sym == 'BETWEEN' ? '<=' : '>';
                        $arr = $arr[1];
335
                    } elseif ($arr[1] === '') {
Karson authored
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);
345
                    if (stripos($v, ',') === false || !array_filter($arr)) {
346
                        continue 2;
347
                    }
Karson authored
348
                    //当出现一边为空时改变操作符
349
                    if ($arr[0] === '') {
Karson authored
350 351
                        $sym = $sym == 'RANGE' ? '<=' : '>';
                        $arr = $arr[1];
352
                    } elseif ($arr[1] === '') {
Karson authored
353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371
                        $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;
            }
        }
372 373 374
        $where = function ($query) use ($where) {
            foreach ($where as $k => $v) {
                if (is_array($v)) {
Karson authored
375
                    call_user_func_array([$query, 'where'], $v);
376
                } else {
Karson authored
377 378 379 380 381 382 383 384 385 386 387 388 389 390
                    $query->where($v);
                }
            }
        };
        return [$where, $sort, $order, $offset, $limit];
    }

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

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

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

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