File.php
3.81 KB
1
2
3
4
5
6
7
8
9
10
11
12
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
namespace app\admin\controller\exam\file;
use app\common\controller\Backend;
/**
*
*
* @icon fa fa-circle-o
*/
class File extends Backend
{
/**
* File模型对象
* @var \app\admin\model\exam\file\File
*/
protected $model = null;
public function _initialize()
{
parent::_initialize();
$this->model = new \app\admin\model\exam\file\File;
$groupList = collection(\app\admin\model\exam\file\Category::where('id', '>', 0)->select())->toArray();
$channelList = [];
foreach($groupList as &$val){
$val = str_replace(' ','',str_replace('├','',str_replace('└','',str_replace(' ', '', $val))));
$data = [
'id' => $val['id'],
'parent' => $val['s_id'] ? $val['s_id'] : '#',
'text' => $val['name'],
];
$channelList[] = $data;
// if()
}
$lookup = [];
foreach ($channelList as $item) {
$lookup[$item['id']] = $item;
}
// 遍历数组,检查并更新 parent
foreach ($channelList as &$item) {
$parentId = $item['parent'];
// 如果上级不存在,则将上级 ID 改为 #
if (!isset($lookup[$parentId])) {
$item['parent'] = '#';
}
}
//halt($channelList);
$this->assignconfig('channelList', $channelList);
}
/**
* 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
* 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
* 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
*/
/**
* 查看
*/
public function index()
{
//当前是否为关联查询
$this->relationSearch = true;
//设置过滤方法
$this->request->filter(['strip_tags', 'trim']);
if ($this->request->isAjax()) {
//如果发送的来源是Selectpage,则转发到Selectpage
if ($this->request->request('keyField')) {
return $this->selectpage();
}
$filter = $this->request->get("filter", '');
$op=$this->request->get("op", '', 'trim');
$filter = (array)json_decode($filter, true);
$op = (array)json_decode($op, true);
$dateFilter=[];//将筛选的值放在这里
//halt($filter['category.name']);
$wheres = [];
if(isset($filter['category.name'])){
//halt($filter['category.name']);
$ids = explode(',',$filter['category.name']);
$wheres['category_id'] = ['in',$ids];
unset($filter['category.name']);
unset($op['category.name']);
//去掉了createtime 的filter 重新组织到 request中 交给下面 buildparams()方法去构建query 的条件
\think\Request::instance()->get(['filter'=>json_encode($filter)]);
\think\Request::instance()->get(['op'=>json_encode($op)]);
}
//halt($wheres);
list($where, $sort, $order, $offset, $limit) = $this->buildparams();
$list = $this->model
->with(['category'])
->where($where)
->where($wheres)
->order($sort, $order)
->paginate($limit);
foreach ($list as $row) {
$row->getRelation('category')->visible(['name']);
}
$result = array("total" => $list->total(), "rows" => $list->items());
return json($result);
}
return $this->view->fetch();
}
}