Role.php 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. <?php
  2. declare (strict_types = 1);
  3. namespace app\admin\controller;
  4. use app\admin\BaseController;
  5. use think\App;
  6. use think\facade\Db;
  7. class Role extends BaseController{
  8. public function __construct(App $app) {parent::__construct($app);}
  9. /**角色权限列表分页 page size
  10. * @return \think\response\Json|void
  11. * @throws \think\db\exception\DataNotFoundException
  12. * @throws \think\db\exception\DbException
  13. * @throws \think\db\exception\ModelNotFoundException
  14. */
  15. public function roleList(){
  16. $post=$this->post;
  17. $condition=[];
  18. isset($post['status'])&&$post['status']!=="" ? $condition[]=['a.status',"=",$post['status']]:"";
  19. isset($post['role_name'])&&$post['role_name']!=="" ? $condition[]=['a.role_name',"like","%".$post['role_name']."%"]:"";
  20. isset($post['level'])&&$post['level']!=="" ? $condition[]=["a.level","=",$post['level']]:"";
  21. $roleList = Db::name("role");
  22. $count =$roleList->alias("a")->where($condition)->count();
  23. $page = isset($post['page']) ? intval($post['page']) : 1;
  24. $size = isset($post['size']) ? intval($post['size']) : 10;
  25. $page >=ceil($count/$size) ? $page= (int)ceil($count/$size) :"";
  26. $list=$roleList->alias("a")->leftJoin("cfp_role_action t","a.id=t.role_id")->field("a.*,t.action_conllect as action,t.action_data")->where($condition)->page($page,$size)->select();
  27. return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
  28. }
  29. /** 角色新建
  30. * @role_name 角色名称
  31. * @level 角色等级
  32. * @action 功能权限
  33. * @action_data 操作权限
  34. * @private_data 私有权限
  35. * @return \think\response\Json|void
  36. * @throws \think\db\exception\DataNotFoundException
  37. * @throws \think\db\exception\DbException
  38. * @throws \think\db\exception\ModelNotFoundException
  39. */
  40. public function roleAdd(){
  41. $post=$this->post;
  42. $rolename = isset($post['role_name']) ? trim($post['role_name']) : "";
  43. if($rolename==""){
  44. return error_show(1002,"角色名称不能为空");
  45. }
  46. $isT=Db::name("role")->where(['role_name'=>$rolename])->find();
  47. if($isT){
  48. return error_show(1002,"角色名称已存在");
  49. }
  50. $level = isset($post['level']) ? intval($post['level']) : "";
  51. if($level==""){
  52. return error_show(1003,"角色等级不能为空");
  53. }
  54. $action = isset($post['action'])&&is_array($post['action']) ? implode(",",$post['action']) : "";
  55. if($action==""){
  56. return error_show(1004,"功能权限不能为空");
  57. }
  58. $data = isset($post['action_data']) &&is_array($post['action_data'])?implode(",",$post['action_data']): "";
  59. $private_data = isset($post['private_data']) &&is_array($post['private_data'])?implode(",",$post['private_data']): "";
  60. Db::startTrans();
  61. try {
  62. $list = [
  63. "role_name"=>$rolename,
  64. "status"=>1,
  65. "addtime"=>date("Y-m-d H:i:s"),
  66. "updatetime"=>date("Y-m-d H:i:s"),
  67. "level"=>$level,
  68. ];
  69. $role= Db::name("role")->insert($list,true);
  70. if($role>0){
  71. $role_action = [
  72. "role_id"=>$role,
  73. "action_conllect"=>$action,
  74. "action_data"=>$data,
  75. "private_data"=>$private_data,
  76. "status"=>1,
  77. "addtime"=>date("Y-m-d H:i:s"),
  78. "updatetime"=>date("Y-m-d H:i:s"),
  79. ];
  80. $roleaction= Db::name("role_action")->insert($role_action,true);
  81. if($roleaction){
  82. Db::commit();
  83. return app_show(0,"新建成功");
  84. }else{
  85. Db::rollback();
  86. return app_show(1005,"权限录入失败");
  87. }
  88. }else{
  89. Db::rollback();
  90. return app_show(1006,"角色新建失败");
  91. }
  92. }catch (\Exception $e){
  93. Db::rollback();
  94. return error_show(1008,$e->getMessage());
  95. }
  96. }
  97. /**查询角色信息
  98. * @roleid 角色id
  99. * @return \think\response\Json|void
  100. * @throws \think\db\exception\DataNotFoundException
  101. * @throws \think\db\exception\DbException
  102. * @throws \think\db\exception\ModelNotFoundException
  103. */
  104. public function roleInfo(){
  105. $post=$this->post;
  106. $roleid= isset($post['roleid']) ? trim($post['roleid']) : "";
  107. if($roleid==""){
  108. return error_show(1001,'roleid不能为空');
  109. }
  110. $info =Db::name("role")->alias("a")->leftJoin("cfp_role_action t","a.id=t.role_id")->field("a.*,t.action_conllect,t.action_data,t.private_data")->where("a.id","=",$roleid)->find();
  111. if(!$info){
  112. return error_show(1002,"未找到对应的数据");
  113. }
  114. $info['action'] =explode(",",$info['action_conllect']);
  115. $info['action_data'] =$info['action_data']!=""?explode(",",$info['action_data']):"";
  116. $info['private_data'] =$info['private_data']!=""?explode(",",$info['private_data']) :"";
  117. return app_show(0,"获取成功",$info);
  118. }
  119. /** 角色信息编辑
  120. * @param role_name 角色名称
  121. * @param level 等级
  122. * @param action 功能权限
  123. * @param action_data 操作权限
  124. * @param roleid 角色id
  125. * @param private_data 私有权限
  126. * @return \think\response\Json|void
  127. * @throws \think\db\exception\DataNotFoundException
  128. * @throws \think\db\exception\DbException
  129. * @throws \think\db\exception\ModelNotFoundException
  130. */
  131. public function roleSave(){
  132. $post=$this->post;
  133. $roleid= isset($post['roleid']) ? intval($post['roleid']) : "";
  134. if($roleid==""){
  135. return error_show(1001,'roleid不能为空');
  136. }
  137. $info =Db::name("role")->where("id","=",$roleid)->find();
  138. if(!$info){
  139. return error_show(1002,"未找到对应的数据");
  140. }
  141. $rolename = isset($post['role_name']) ? trim($post['role_name']) : "";
  142. if($rolename==""){
  143. return error_show(1002,"角色名称不能为空");
  144. }
  145. $vers= Db::name("role")->where("id",'<>',$roleid)->where("role_name","=",$rolename)->find();
  146. if($vers){
  147. return error_show(1002,"角色名已存在");
  148. }
  149. $level = isset($post['level']) ? intval($post['level']) : "";
  150. if($level==""){
  151. return error_show(1003,"角色等级不能为空");
  152. }
  153. $action = isset($post['action'])&&is_array($post['action']) ? implode(",",$post['action']) : "";
  154. if($action==""){
  155. return error_show(1004,"功能权限不能为空");
  156. }
  157. $data = isset($post['action_data']) &&is_array($post['action_data'])?implode(",",$post['action_data']): "";
  158. $private_data = isset($post['private_data']) &&is_array($post['private_data'])?implode(",",$post['private_data']): "";
  159. Db::startTrans();
  160. try {
  161. $list = [
  162. "role_name"=>$rolename,
  163. "level"=>$level,
  164. "updatetime"=>date("Y-m-d H:i:s"),
  165. 'id'=>$roleid
  166. ];
  167. $role= Db::name("role")->save($list);
  168. if($role){
  169. $role_action = [
  170. "role_id"=>$roleid,
  171. "action_conllect"=>$action,
  172. "action_data"=>$data,
  173. "private_data"=>$private_data,
  174. "updatetime"=>date("Y-m-d H:i:s")
  175. ];
  176. $roleaction= Db::name("role_action")->where("role_id","=",$roleid)->update($role_action);
  177. if($roleaction){
  178. Db::commit();
  179. return app_show(0,"更新成功");
  180. }else{
  181. Db::rollback();
  182. return app_show(1005,"权限更新失败");
  183. }
  184. }else{
  185. Db::rollback();
  186. return app_show(1006,"角色更新失败");
  187. }
  188. }catch (\Exception $e){
  189. Db::rollback();
  190. return error_show(1008,$e->getMessage());
  191. }
  192. }
  193. /**
  194. * 角色状态更新
  195. * @roleid 角色id
  196. * @status 角色状态 0 /1
  197. * @return \think\response\Json
  198. * @throws \think\exception\DbException
  199. */
  200. public function roleStatus(){
  201. $post=$this->post;
  202. $roleid= isset($post['roleid']) ? intval($post['roleid']) : "";
  203. if($roleid==""){
  204. return error_show(1001,'roleid不能为空');
  205. }
  206. $status = isset($post['status']) ? intval($post['status']) : "";
  207. if($status===""){
  208. return error_show(1001,'status不能为空');
  209. }
  210. if(!in_array($status,[0,1])){
  211. return error_show(1001,'status参数非法');
  212. }
  213. Db::startTrans();
  214. try {
  215. $dat=[
  216. 'status'=>$status,'updatetime'=>date("Y-m-d H:i:s"), 'id'=>$roleid
  217. ];
  218. $re = Db::name("role")->save($dat);
  219. if($re){
  220. $dat2=[
  221. 'status'=>$status,'updatetime'=>date("Y-m-d H:i:s")
  222. ];
  223. $action = Db::name("role_action")->where("role_id","=",$roleid)->update($dat2);
  224. if($action){
  225. Db::commit();
  226. return app_show(0,"状态更新成功");
  227. }
  228. }
  229. Db::rollback();
  230. return error_show(1003,"状态更新失败");
  231. }catch (\Exception $e){
  232. Db::rollback();
  233. return error_show(1002,$e->getMessage());
  234. }
  235. }
  236. /**
  237. * 获取所有角色
  238. * @return \think\response\Json
  239. * @throws \think\exception\DbException
  240. */
  241. public function RoleAll(){
  242. $list =Db::name("role")->select();
  243. return app_show(0,"获取成功",$list);
  244. }
  245. }