Backend.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
  1. <?php
  2. namespace app\common\controller;
  3. use app\admin\library\Auth;
  4. use think\Config;
  5. use think\Controller;
  6. use think\Hook;
  7. use think\Lang;
  8. use think\Loader;
  9. use think\Session;
  10. use fast\Tree;
  11. use think\Validate;
  12. /**
  13. * 后台控制器基类
  14. */
  15. class Backend extends Controller
  16. {
  17. /**
  18. * 无需登录的方法,同时也就不需要鉴权了
  19. * @var array
  20. */
  21. protected $noNeedLogin = [];
  22. /**
  23. * 无需鉴权的方法,但需要登录
  24. * @var array
  25. */
  26. protected $noNeedRight = [];
  27. /**
  28. * 布局模板
  29. * @var string
  30. */
  31. protected $layout = 'default';
  32. /**
  33. * 权限控制类
  34. * @var Auth
  35. */
  36. protected $auth = null;
  37. /**
  38. * 模型对象
  39. * @var \think\Model
  40. */
  41. protected $model = null;
  42. /**
  43. * 快速搜索时执行查找的字段
  44. */
  45. protected $searchFields = 'id';
  46. /**
  47. * 是否是关联查询
  48. */
  49. protected $relationSearch = false;
  50. /**
  51. * 是否开启数据限制
  52. * 支持auth/personal
  53. * 表示按权限判断/仅限个人
  54. * 默认为禁用,若启用请务必保证表中存在admin_id字段
  55. */
  56. protected $dataLimit = false;
  57. /**
  58. * 数据限制字段
  59. */
  60. protected $dataLimitField = 'admin_id';
  61. /**
  62. * 数据限制开启时自动填充限制字段值
  63. */
  64. protected $dataLimitFieldAutoFill = true;
  65. /**
  66. * 是否开启Validate验证
  67. */
  68. protected $modelValidate = false;
  69. /**
  70. * 是否开启模型场景验证
  71. */
  72. protected $modelSceneValidate = false;
  73. /**
  74. * Multi方法可批量修改的字段
  75. */
  76. protected $multiFields = 'status';
  77. /**
  78. * Selectpage可显示的字段
  79. */
  80. protected $selectpageFields = '*';
  81. /**
  82. * 前台提交过来,需要排除的字段数据
  83. */
  84. protected $excludeFields = "";
  85. /**
  86. * 导入文件首行类型
  87. * 支持comment/name
  88. * 表示注释或字段名
  89. */
  90. protected $importHeadType = 'comment';
  91. /**
  92. * 引入后台控制器的traits
  93. */
  94. use \app\admin\library\traits\Backend;
  95. public function _initialize()
  96. {
  97. header('Access-Control-Allow-Origin:*');
  98. header("Access-Control-Allow-Methods:GET, POST, OPTIONS");
  99. header('Access-Control-Allow-Headers:*');
  100. header('Access-Control-Allow-Credentials:false');
  101. $modulename = $this->request->module();
  102. $controllername = Loader::parseName($this->request->controller());
  103. $actionname = strtolower($this->request->action());
  104. $path = str_replace('.', '/', $controllername) . '/' . $actionname;
  105. // 定义是否Addtabs请求
  106. !defined('IS_ADDTABS') && define('IS_ADDTABS', input("addtabs") ? true : false);
  107. // 定义是否Dialog请求
  108. !defined('IS_DIALOG') && define('IS_DIALOG', input("dialog") ? true : false);
  109. // 定义是否AJAX请求
  110. !defined('IS_AJAX') && define('IS_AJAX', $this->request->isAjax());
  111. $this->auth = Auth::instance();
  112. // 设置当前请求的URI
  113. $this->auth->setRequestUri($path);
  114. // 检测是否需要验证登录
  115. if (!$this->auth->match($this->noNeedLogin)) {
  116. //检测是否登录
  117. if (!$this->auth->isLogin()) {
  118. Hook::listen('admin_nologin', $this);
  119. $url = Session::get('referer');
  120. $url = $url ? $url : $this->request->url();
  121. if ($url == '/') {
  122. $this->redirect('index/login', [], 302, ['referer' => $url]);
  123. exit;
  124. }
  125. $this->error(__('Please login first'), url('index/login', ['url' => $url]));
  126. }
  127. // 判断是否需要验证权限
  128. if (!$this->auth->match($this->noNeedRight)) {
  129. // 判断控制器和方法判断是否有对应权限
  130. if (!$this->auth->check($path)) {
  131. Hook::listen('admin_nopermission', $this);
  132. $this->error(__('You have no permission'), '');
  133. }
  134. }
  135. }
  136. // 非选项卡时重定向
  137. if (!$this->request->isPost() && !IS_AJAX && !IS_ADDTABS && !IS_DIALOG && input("ref") == 'addtabs') {
  138. $url = preg_replace_callback("/([\?|&]+)ref=addtabs(&?)/i", function ($matches) {
  139. return $matches[2] == '&' ? $matches[1] : '';
  140. }, $this->request->url());
  141. if (Config::get('url_domain_deploy')) {
  142. if (stripos($url, $this->request->server('SCRIPT_NAME')) === 0) {
  143. $url = substr($url, strlen($this->request->server('SCRIPT_NAME')));
  144. }
  145. $url = url($url, '', false);
  146. }
  147. $this->redirect('index/index', [], 302, ['referer' => $url]);
  148. exit;
  149. }
  150. // 设置面包屑导航数据
  151. $breadcrumb = $this->auth->getBreadCrumb($path);
  152. array_pop($breadcrumb);
  153. $this->view->breadcrumb = $breadcrumb;
  154. // 如果有使用模板布局
  155. if ($this->layout) {
  156. $this->view->engine->layout('layout/' . $this->layout);
  157. }
  158. // 语言检测
  159. $lang = strip_tags($this->request->langset());
  160. $site = Config::get("site");
  161. $upload = \app\common\model\Config::upload();
  162. // 上传信息配置后
  163. Hook::listen("upload_config_init", $upload);
  164. // 配置信息
  165. $config = [
  166. 'site' => array_intersect_key($site, array_flip(['name', 'indexurl', 'cdnurl', 'version', 'timezone', 'languages'])),
  167. 'upload' => $upload,
  168. 'modulename' => $modulename,
  169. 'controllername' => $controllername,
  170. 'actionname' => $actionname,
  171. 'jsname' => 'backend/' . str_replace('.', '/', $controllername),
  172. 'moduleurl' => rtrim(url("/{$modulename}", '', false), '/'),
  173. 'language' => $lang,
  174. 'fastadmin' => Config::get('fastadmin'),
  175. 'referer' => Session::get("referer")
  176. ];
  177. $config = array_merge($config, Config::get("view_replace_str"));
  178. Config::set('upload', array_merge(Config::get('upload'), $upload));
  179. // 配置信息后
  180. Hook::listen("config_init", $config);
  181. //加载当前控制器语言包
  182. $this->loadlang($controllername);
  183. //渲染站点配置
  184. $this->assign('site', $site);
  185. //渲染配置信息
  186. $this->assign('config', $config);
  187. //渲染权限对象
  188. $this->assign('auth', $this->auth);
  189. //渲染管理员对象
  190. $this->assign('admin', Session::get('admin'));
  191. }
  192. /**
  193. * 加载语言文件
  194. * @param string $name
  195. */
  196. protected function loadlang($name)
  197. {
  198. Lang::load(APP_PATH . $this->request->module() . '/lang/' . $this->request->langset() . '/' . str_replace('.', '/', $name) . '.php');
  199. }
  200. /**
  201. * 渲染配置信息
  202. * @param mixed $name 键名或数组
  203. * @param mixed $value 值
  204. */
  205. protected function assignconfig($name, $value = '')
  206. {
  207. $this->view->config = array_merge($this->view->config ? $this->view->config : [], is_array($name) ? $name : [$name => $value]);
  208. }
  209. /**
  210. * 生成查询所需要的条件,排序方式
  211. * @param mixed $searchfields 快速查询的字段
  212. * @param boolean $relationSearch 是否关联查询
  213. * @return array
  214. */
  215. protected function buildparams($searchfields = null, $relationSearch = null)
  216. {
  217. $searchfields = is_null($searchfields) ? $this->searchFields : $searchfields;
  218. $relationSearch = is_null($relationSearch) ? $this->relationSearch : $relationSearch;
  219. $search = $this->request->get("search", '');
  220. $filter = $this->request->get("filter", '');
  221. $op = $this->request->get("op", '', 'trim');
  222. $sort = $this->request->get("sort", !empty($this->model) && $this->model->getPk() ? $this->model->getPk() : 'id');
  223. $order = $this->request->get("order", "DESC");
  224. $offset = $this->request->get("offset", 0);
  225. $limit = $this->request->get("limit", 0);
  226. $filter = (array)json_decode($filter, true);
  227. $op = (array)json_decode($op, true);
  228. $filter = $filter ? $filter : [];
  229. $where = [];
  230. $tableName = '';
  231. if ($relationSearch) {
  232. if (!empty($this->model)) {
  233. $name = \think\Loader::parseName(basename(str_replace('\\', '/', get_class($this->model))));
  234. $name = $this->model->getTable();
  235. $tableName = $name . '.';
  236. }
  237. $sortArr = explode(',', $sort);
  238. foreach ($sortArr as $index => & $item) {
  239. $item = stripos($item, ".") === false ? $tableName . trim($item) : $item;
  240. }
  241. unset($item);
  242. $sort = implode(',', $sortArr);
  243. }
  244. $adminIds = $this->getDataLimitAdminIds();
  245. if (is_array($adminIds)) {
  246. $where[] = [$tableName . $this->dataLimitField, 'in', $adminIds];
  247. }
  248. if ($search) {
  249. $searcharr = is_array($searchfields) ? $searchfields : explode(',', $searchfields);
  250. foreach ($searcharr as $k => &$v) {
  251. $v = stripos($v, ".") === false ? $tableName . $v : $v;
  252. }
  253. unset($v);
  254. $where[] = [implode("|", $searcharr), "LIKE", "%{$search}%"];
  255. }
  256. foreach ($filter as $k => $v) {
  257. $sym = isset($op[$k]) ? $op[$k] : '=';
  258. if (stripos($k, ".") === false) {
  259. $k = $tableName . $k;
  260. }
  261. $v = !is_array($v) ? trim($v) : $v;
  262. $sym = strtoupper(isset($op[$k]) ? $op[$k] : $sym);
  263. switch ($sym) {
  264. case '=':
  265. case '<>':
  266. $where[] = [$k, $sym, (string)$v];
  267. break;
  268. case 'LIKE':
  269. case 'NOT LIKE':
  270. case 'LIKE %...%':
  271. case 'NOT LIKE %...%':
  272. $where[] = [$k, trim(str_replace('%...%', '', $sym)), "%{$v}%"];
  273. break;
  274. case '>':
  275. case '>=':
  276. case '<':
  277. case '<=':
  278. $where[] = [$k, $sym, intval($v)];
  279. break;
  280. case 'FINDIN':
  281. case 'FINDINSET':
  282. case 'FIND_IN_SET':
  283. $where[] = "FIND_IN_SET('{$v}', " . ($relationSearch ? $k : '`' . str_replace('.', '`.`', $k) . '`') . ")";
  284. break;
  285. case 'IN':
  286. case 'IN(...)':
  287. case 'NOT IN':
  288. case 'NOT IN(...)':
  289. $where[] = [$k, str_replace('(...)', '', $sym), is_array($v) ? $v : explode(',', $v)];
  290. break;
  291. case 'BETWEEN':
  292. case 'NOT BETWEEN':
  293. $arr = array_slice(explode(',', $v), 0, 2);
  294. if (stripos($v, ',') === false || !array_filter($arr)) {
  295. continue 2;
  296. }
  297. //当出现一边为空时改变操作符
  298. if ($arr[0] === '') {
  299. $sym = $sym == 'BETWEEN' ? '<=' : '>';
  300. $arr = $arr[1];
  301. } elseif ($arr[1] === '') {
  302. $sym = $sym == 'BETWEEN' ? '>=' : '<';
  303. $arr = $arr[0];
  304. }
  305. $where[] = [$k, $sym, $arr];
  306. break;
  307. case 'RANGE':
  308. case 'NOT RANGE':
  309. $v = str_replace(' - ', ',', $v);
  310. $arr = array_slice(explode(',', $v), 0, 2);
  311. if (stripos($v, ',') === false || !array_filter($arr)) {
  312. continue 2;
  313. }
  314. //当出现一边为空时改变操作符
  315. if ($arr[0] === '') {
  316. $sym = $sym == 'RANGE' ? '<=' : '>';
  317. $arr = $arr[1];
  318. } elseif ($arr[1] === '') {
  319. $sym = $sym == 'RANGE' ? '>=' : '<';
  320. $arr = $arr[0];
  321. }
  322. $where[] = [$k, str_replace('RANGE', 'BETWEEN', $sym) . ' time', $arr];
  323. break;
  324. case 'LIKE':
  325. case 'LIKE %...%':
  326. $where[] = [$k, 'LIKE', "%{$v}%"];
  327. break;
  328. case 'NULL':
  329. case 'IS NULL':
  330. case 'NOT NULL':
  331. case 'IS NOT NULL':
  332. $where[] = [$k, strtolower(str_replace('IS ', '', $sym))];
  333. break;
  334. default:
  335. break;
  336. }
  337. }
  338. $where = function ($query) use ($where) {
  339. foreach ($where as $k => $v) {
  340. if (is_array($v)) {
  341. call_user_func_array([$query, 'where'], $v);
  342. } else {
  343. $query->where($v);
  344. }
  345. }
  346. };
  347. return [$where, $sort, $order, $offset, $limit];
  348. }
  349. /**
  350. * 获取数据限制的管理员ID
  351. * 禁用数据限制时返回的是null
  352. * @return mixed
  353. */
  354. protected function getDataLimitAdminIds()
  355. {
  356. if (!$this->dataLimit) {
  357. return null;
  358. }
  359. if ($this->auth->isSuperAdmin()) {
  360. return null;
  361. }
  362. $adminIds = [];
  363. if (in_array($this->dataLimit, ['auth', 'personal'])) {
  364. $adminIds = $this->dataLimit == 'auth' ? $this->auth->getChildrenAdminIds(true) : [$this->auth->id];
  365. }
  366. return $adminIds;
  367. }
  368. /**
  369. * Selectpage的实现方法
  370. *
  371. * 当前方法只是一个比较通用的搜索匹配,请按需重载此方法来编写自己的搜索逻辑,$where按自己的需求写即可
  372. * 这里示例了所有的参数,所以比较复杂,实现上自己实现只需简单的几行即可
  373. *
  374. */
  375. protected function selectpage()
  376. {
  377. //设置过滤方法
  378. $this->request->filter(['strip_tags', 'htmlspecialchars']);
  379. //搜索关键词,客户端输入以空格分开,这里接收为数组
  380. $word = (array)$this->request->request("q_word/a");
  381. //当前页
  382. $page = $this->request->request("pageNumber");
  383. //分页大小
  384. $pagesize = $this->request->request("pageSize");
  385. //搜索条件
  386. $andor = $this->request->request("andOr", "and", "strtoupper");
  387. //排序方式
  388. $orderby = (array)$this->request->request("orderBy/a");
  389. //显示的字段
  390. $field = $this->request->request("showField");
  391. //主键
  392. $primarykey = $this->request->request("keyField");
  393. //主键值
  394. $primaryvalue = $this->request->request("keyValue");
  395. //搜索字段
  396. $searchfield = (array)$this->request->request("searchField/a");
  397. //自定义搜索条件
  398. $custom = (array)$this->request->request("custom/a");
  399. //是否返回树形结构
  400. $istree = $this->request->request("isTree", 0);
  401. $ishtml = $this->request->request("isHtml", 0);
  402. if ($istree) {
  403. $word = [];
  404. $pagesize = 99999;
  405. }
  406. $order = [];
  407. foreach ($orderby as $k => $v) {
  408. $order[$v[0]] = $v[1];
  409. }
  410. $field = $field ? $field : 'name';
  411. //如果有primaryvalue,说明当前是初始化传值
  412. if ($primaryvalue !== null) {
  413. $where = [$primarykey => ['in', $primaryvalue]];
  414. } else {
  415. $where = function ($query) use ($word, $andor, $field, $searchfield, $custom) {
  416. $logic = $andor == 'AND' ? '&' : '|';
  417. $searchfield = is_array($searchfield) ? implode($logic, $searchfield) : $searchfield;
  418. foreach ($word as $k => $v) {
  419. $query->where(str_replace(',', $logic, $searchfield), "like", "%{$v}%");
  420. }
  421. if ($custom && is_array($custom)) {
  422. foreach ($custom as $k => $v) {
  423. if (is_array($v) && 2 == count($v)) {
  424. $query->where($k, trim($v[0]), $v[1]);
  425. } else {
  426. $query->where($k, '=', $v);
  427. }
  428. }
  429. }
  430. };
  431. }
  432. $adminIds = $this->getDataLimitAdminIds();
  433. if (is_array($adminIds)) {
  434. $this->model->where($this->dataLimitField, 'in', $adminIds);
  435. }
  436. $list = [];
  437. $total = $this->model->where($where)->count();
  438. if ($total > 0) {
  439. if (is_array($adminIds)) {
  440. $this->model->where($this->dataLimitField, 'in', $adminIds);
  441. }
  442. $datalist = $this->model->where($where)
  443. ->order($order)
  444. ->page($page, $pagesize)
  445. ->field($this->selectpageFields)
  446. ->select();
  447. foreach ($datalist as $index => $item) {
  448. unset($item['password'], $item['salt']);
  449. $list[] = [
  450. $primarykey => isset($item[$primarykey]) ? $item[$primarykey] : '',
  451. $field => isset($item[$field]) ? $item[$field] : '',
  452. 'pid' => isset($item['pid']) ? $item['pid'] : 0
  453. ];
  454. }
  455. if ($istree && !$primaryvalue) {
  456. $tree = Tree::instance();
  457. $tree->init(collection($list)->toArray(), 'pid');
  458. $list = $tree->getTreeList($tree->getTreeArray(0), $field);
  459. if (!$ishtml) {
  460. foreach ($list as &$item) {
  461. $item = str_replace('&nbsp;', ' ', $item);
  462. }
  463. unset($item);
  464. }
  465. }
  466. }
  467. //这里一定要返回有list这个字段,total是可选的,如果total<=list的数量,则会隐藏分页按钮
  468. return json(['list' => $list, 'total' => $total]);
  469. }
  470. /**
  471. * 刷新Token
  472. */
  473. protected function token()
  474. {
  475. $token = $this->request->post('__token__');
  476. //验证Token
  477. if (!Validate::is($token, "token", ['__token__' => $token])) {
  478. $this->error(__('Token verification error'), '', ['__token__' => $this->request->token()]);
  479. }
  480. //刷新Token
  481. $this->request->token();
  482. }
  483. public function phone_tm($phone)
  484. {
  485. if(empty($phone)){
  486. return '';
  487. }
  488. if((isset($_SERVER['HTTP_ZSKK_CRB_NETWORK']) && $_SERVER['HTTP_ZSKK_CRB_NETWORK'] == 'INNER'))
  489. {
  490. return $phone;
  491. }else{
  492. return substr_replace($phone,'****',3,4);
  493. }
  494. }
  495. public function name_tm($name)
  496. {
  497. if(empty($name)){
  498. return '';
  499. }
  500. if((isset($_SERVER['HTTP_ZSKK_CRB_NETWORK']) && $_SERVER['HTTP_ZSKK_CRB_NETWORK'] == 'INNER'))
  501. {
  502. return $name;
  503. }else{
  504. return substr($name,0,3).'**';
  505. }
  506. }
  507. public function idcard_tm($idCard) {
  508. if(empty($idCard)){
  509. return '';
  510. }
  511. // 对于身份证号码,通常只保留前6位和后1位,中间用星号(*)替换
  512. $desensitizedIdCard = substr($idCard, 0, 6) . str_repeat('*', strlen($idCard) - 8) . substr($idCard, -1);
  513. return $desensitizedIdCard;
  514. }
  515. }