Role.php
3.11 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
<?php
declare(strict_types=1);
namespace app\controller\admin;
use app\BaseController;
use think\facade\Db;
class Role extends BaseController
{
public function list()
{
$rows = Db::name('sys_role')->order('id', 'asc')->select()->toArray();
$list = [];
foreach ($rows as $r) {
$list[] = [
'id' => (int) $r['id'],
'name' => $r['name'],
'code' => $r['code'],
'remark' => $r['remark'],
'status' => (int) $r['status'],
];
}
return json(['code' => 0, 'msg' => 'ok', 'data' => ['list' => $list]]);
}
public function save()
{
$id = (int) $this->request->post('id', 0);
$name = trim((string) $this->request->post('name', ''));
$code = trim((string) $this->request->post('code', ''));
$remark = trim((string) $this->request->post('remark', ''));
$status = (int) $this->request->post('status', 1);
if ($name === '') {
return json(['code' => 400, 'msg' => '名称必填', 'data' => []]);
}
$now = date('Y-m-d H:i:s');
if ($id <= 0) {
Db::name('sys_role')->insert([
'name' => $name,
'code' => $code,
'remark' => $remark,
'status' => $status,
'create_time' => $now,
'update_time' => $now,
]);
} else {
Db::name('sys_role')->where('id', $id)->update([
'name' => $name,
'code' => $code,
'remark' => $remark,
'status' => $status,
'update_time' => $now,
]);
}
return json(['code' => 0, 'msg' => '已保存', 'data' => []]);
}
public function delete(int $id)
{
if ($id === 1) {
return json(['code' => 400, 'msg' => '不能删除超级角色', 'data' => []]);
}
Db::name('sys_role_menu')->where('role_id', $id)->delete();
Db::name('sys_role')->where('id', $id)->delete();
return json(['code' => 0, 'msg' => '已删除', 'data' => []]);
}
/** 某角色已选菜单 id */
public function menuIds(int $id)
{
$ids = Db::name('sys_role_menu')->where('role_id', $id)->column('menu_id');
return json(['code' => 0, 'msg' => 'ok', 'data' => ['menu_ids' => array_map('intval', $ids)]]);
}
/** 保存角色-菜单 */
public function saveMenus(int $id)
{
$menuIds = $this->request->post('menu_ids', []);
if (!is_array($menuIds)) {
return json(['code' => 400, 'msg' => 'menu_ids 须为数组', 'data' => []]);
}
Db::name('sys_role_menu')->where('role_id', $id)->delete();
foreach ($menuIds as $mid) {
$mid = (int) $mid;
if ($mid <= 0) {
continue;
}
Db::name('sys_role_menu')->insert(['role_id' => $id, 'menu_id' => $mid]);
}
return json(['code' => 0, 'msg' => '已保存权限', 'data' => []]);
}
}