From 4c7495d646028e45c14af403e25c785d44e5dbe5 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Wed, 17 Mar 2021 09:00:22 +0800
Subject: [PATCH] 角色菜单配置
---
screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java | 12 +
screen-manage/src/main/resources/mapper/ManageAccountRoleMapper.xml | 6
screen-manage/src/main/resources/mapper/ManageRoleMapper.xml | 59 +++++
screen-manage/src/main/java/com/moral/api/controller/WebController.java | 170 +++++++++++++++++
screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java | 74 +++++++
screen-manage/src/main/resources/mapper/ManageRoleMenuMapper.xml | 14 +
screen-manage/src/main/java/com/moral/api/service/ManageRoleService.java | 19 +
screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMenuMapper.java | 7
screen-manage/src/main/java/com/moral/api/mapper/ManageMenuMapper.java | 9
screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMapper.java | 13 +
screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java | 105 ++++++++++
screen-manage/src/main/resources/mapper/ManageMenuMapper.xml | 75 +++++++
12 files changed, 563 insertions(+), 0 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/controller/WebController.java b/screen-manage/src/main/java/com/moral/api/controller/WebController.java
new file mode 100644
index 0000000..cf48806
--- /dev/null
+++ b/screen-manage/src/main/java/com/moral/api/controller/WebController.java
@@ -0,0 +1,170 @@
+package com.moral.api.controller;
+
+import com.alibaba.fastjson.JSON;
+import com.moral.api.entity.ManageMenu;
+import com.moral.api.entity.ManageRole;
+import com.moral.api.service.ManageMenuService;
+import com.moral.api.service.ManageRoleService;
+import com.moral.constant.ResultMessage;
+import com.moral.util.WebUtils;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiImplicitParams;
+import io.swagger.annotations.ApiOperation;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.PathVariable;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestMethod;
+import org.springframework.web.bind.annotation.RestController;
+
+import javax.servlet.http.HttpServletRequest;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Map;
+
+import static org.springframework.web.util.WebUtils.getParametersStartingWith;
+
+@Slf4j
+@Api(tags = {"������"})
+@RestController
+@RequestMapping("/manage")
+public class WebController {
+
+ @Autowired
+ private ManageRoleService manageRoleService;
+
+ @Autowired
+ private ManageMenuService manageMenuService;
+
+ @ApiOperation(value = "������������������", notes = "������������������")
+ @ApiImplicitParams({})
+ @RequestMapping(value = "getAllManageRole", method = RequestMethod.GET)
+ public ResultMessage getAllManageRole() {
+ List<ManageRole> re = manageRoleService.getAll();
+ return ResultMessage.ok(re);
+ }
+
+ @ApiOperation(value = "������������", notes = "������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "name", value = "������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "desc", value = "������", required = true, paramType = "query", dataType = "String")
+ })
+ @RequestMapping(value = "insertOneManageRole", method = RequestMethod.POST)
+ public ResultMessage insertOneManageRole(HttpServletRequest request) {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ ManageRole manageRole = JSON.parseObject(JSON.toJSONString(parameters), ManageRole.class);
+ List list = new ArrayList();
+ list.add(1);
+ list.add(2);
+ list.add(3);
+ list.add(4);
+ Map<String,Object> resultMap = manageRoleService.insertOne(manageRole,list);
+ String msg = resultMap.get("msg").toString();
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ return ResultMessage.ok(msg);
+ }
+ return ResultMessage.fail(msg);
+ }
+
+ @ApiOperation(value = "������������", notes = "������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "name", value = "������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "desc", value = "������", required = true, paramType = "query", dataType = "String")
+ })
+ @RequestMapping(value = "updateManageRole", method = RequestMethod.POST)
+ public ResultMessage updateManageRole(HttpServletRequest request) {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ Map<String,Object> resultMap = manageRoleService.updateManageRole(parameters);
+ String msg = resultMap.get("msg").toString();
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ return ResultMessage.ok(msg);
+ }
+ return ResultMessage.fail(msg);
+ }
+
+ @ApiOperation(value = "������������", notes = "������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "id", value = "������", required = true, paramType = "query", dataType = "int")
+ })
+ @RequestMapping(value = "deleteManageRole", method = RequestMethod.POST)
+ public ResultMessage deleteManageRole(HttpServletRequest request) {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ Map<String,Object> resultMap = manageRoleService.deleteManageRole(parameters);
+ String msg = resultMap.get("msg").toString();
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ return ResultMessage.ok(msg);
+ }
+ return ResultMessage.fail(msg);
+ }
+
+ @ApiOperation(value = "������������������", notes = "������������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "name", value = "������", required = true, paramType = "query", dataType = "String")
+ })
+ @RequestMapping(value = "getManageRoleByNameFuzzy", method = RequestMethod.GET)
+ public ResultMessage getManageRoleByNameFuzzy(HttpServletRequest request) {
+ Map<String, Object> parameters = getParametersStartingWith(request, null);
+ ManageRole manageRole = JSON.parseObject(JSON.toJSONString(parameters), ManageRole.class);
+ List<ManageRole> re = manageRoleService.getManageRoleByNameFuzzy(manageRole);
+ return ResultMessage.ok(re);
+ }
+
+ @ApiOperation(value = "������������", notes = "������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "name", value = "������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "url", value = "url������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "icon", value = "������������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "parent_id", value = "���������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "order", value = "������������������", required = true, paramType = "query", dataType = "String")
+ })
+ @RequestMapping(value = "insertOneManageMenu", method = RequestMethod.POST)
+ public ResultMessage insertOneManageMenu(HttpServletRequest request) {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ ManageMenu manageMenu = JSON.parseObject(JSON.toJSONString(parameters), ManageMenu.class);
+ Map<String,Object> resultMap = manageMenuService.insertManageMenu(manageMenu);
+ String msg = resultMap.get("msg").toString();
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ return ResultMessage.ok(msg);
+ }
+ return ResultMessage.fail(msg);
+ }
+
+ @ApiOperation(value = "������������", notes = "������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "id", value = "������", required = true, paramType = "query", dataType = "int"),
+ @ApiImplicitParam(name = "name", value = "������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "url", value = "url������", required = true, paramType = "query", dataType = "String")
+ })
+ @RequestMapping(value = "updateManageMenuById", method = RequestMethod.POST)
+ public ResultMessage updateManageMenuById(HttpServletRequest request) {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ Map<String,Object> resultMap = manageMenuService.updateManageMenu(parameters);
+ String msg = resultMap.get("msg").toString();
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ return ResultMessage.ok(msg);
+ }
+ return ResultMessage.fail(msg);
+ }
+
+ @ApiOperation(value = "������������", notes = "������������")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "id", value = "������", required = true, paramType = "query", dataType = "int")
+ })
+ @RequestMapping(value = "deleteManageMenu", method = RequestMethod.POST)
+ public ResultMessage deleteManageMenu(HttpServletRequest request) {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ Map<String,Object> resultMap = manageMenuService.deleteManageMenu(parameters);
+ String msg = resultMap.get("msg").toString();
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ return ResultMessage.ok(msg);
+ }
+ return ResultMessage.fail(msg);
+ }
+}
diff --git a/screen-manage/src/main/java/com/moral/api/mapper/ManageMenuMapper.java b/screen-manage/src/main/java/com/moral/api/mapper/ManageMenuMapper.java
index a6e1f73..ddb40aa 100644
--- a/screen-manage/src/main/java/com/moral/api/mapper/ManageMenuMapper.java
+++ b/screen-manage/src/main/java/com/moral/api/mapper/ManageMenuMapper.java
@@ -6,6 +6,7 @@
import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -36,4 +37,12 @@
List<ManageMenu> getParentChildrenMenusByRoles(List<ManageRole> roles);
+ ManageMenu getManageMenuByName(String name);
+
+ ManageMenu getManageMenuById(int id);
+
+ void insertOne(ManageMenu manageMenu);
+
+ void updateManageMenuById(Map map);
+
}
diff --git a/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMapper.java b/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMapper.java
index 3f89cfb..22d6c15 100644
--- a/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMapper.java
+++ b/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMapper.java
@@ -5,6 +5,7 @@
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -16,4 +17,16 @@
*/
public interface ManageRoleMapper extends BaseMapper<ManageRole> {
List<ManageRole> getManageRoleByAccountId(Integer accountId);
+
+ List<ManageRole> getAll();
+
+ ManageRole getManageRoleByName(String name);
+
+ ManageRole getManageRoleById(int id);
+
+ void insertOne(ManageRole manageRole);
+
+ void updateManageRoleById(Map map);
+
+ List<ManageRole> getManageRoleByNameFuzzy(ManageRole manageRole);
}
diff --git a/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMenuMapper.java b/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMenuMapper.java
index 630b7a2..0bf2d2e 100644
--- a/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMenuMapper.java
+++ b/screen-manage/src/main/java/com/moral/api/mapper/ManageRoleMenuMapper.java
@@ -2,6 +2,10 @@
import com.moral.api.entity.ManageRoleMenu;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -13,4 +17,7 @@
*/
public interface ManageRoleMenuMapper extends BaseMapper<ManageRoleMenu> {
+ void insertBatch(@Param("list")List<Map> list);
+
+ void updateDeleteStateByMenu_id(Map map);
}
diff --git a/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java b/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java
index 0f7ace3..29dd26a 100644
--- a/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java
@@ -2,6 +2,9 @@
import com.moral.api.entity.ManageMenu;
import com.baomidou.mybatisplus.extension.service.IService;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.Map;
/**
* <p>
@@ -11,6 +14,15 @@
* @author moral
* @since 2021-03-09
*/
+@Transactional
public interface ManageMenuService extends IService<ManageMenu> {
+ @Transactional
+ Map<String,Object> insertManageMenu(ManageMenu manageMenu);
+
+ @Transactional
+ Map<String,Object> updateManageMenu(Map map);
+
+ @Transactional
+ Map<String,Object> deleteManageMenu(Map map);
}
diff --git a/screen-manage/src/main/java/com/moral/api/service/ManageRoleService.java b/screen-manage/src/main/java/com/moral/api/service/ManageRoleService.java
index fee773e..91084c0 100644
--- a/screen-manage/src/main/java/com/moral/api/service/ManageRoleService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/ManageRoleService.java
@@ -2,6 +2,10 @@
import com.moral.api.entity.ManageRole;
import com.baomidou.mybatisplus.extension.service.IService;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -11,6 +15,21 @@
* @author moral
* @since 2021-03-09
*/
+@Transactional
public interface ManageRoleService extends IService<ManageRole> {
+ @Transactional
+ List<ManageRole> getAll();
+
+ @Transactional
+ Map<String,Object> insertOne(ManageRole manageRole,List list);
+
+ @Transactional
+ Map<String,Object> updateManageRole(Map map);
+
+ @Transactional
+ List<ManageRole> getManageRoleByNameFuzzy(ManageRole manageRole);
+
+ @Transactional
+ Map<String,Object> deleteManageRole(Map map);
}
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java
index cebd875..40149bf 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java
@@ -2,9 +2,14 @@
import com.moral.api.entity.ManageMenu;
import com.moral.api.mapper.ManageMenuMapper;
+import com.moral.api.mapper.ManageRoleMenuMapper;
import com.moral.api.service.ManageMenuService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
+
+import javax.annotation.Resource;
+import java.util.HashMap;
+import java.util.Map;
/**
* <p>
@@ -17,4 +22,73 @@
@Service
public class ManageMenuServiceImpl extends ServiceImpl<ManageMenuMapper, ManageMenu> implements ManageMenuService {
+ @Resource
+ private ManageMenuMapper manageMenuMapper;
+
+ @Resource
+ private ManageRoleMenuMapper manageRoleMenuMapper;
+
+ @Override
+ public Map<String,Object> insertManageMenu(ManageMenu manageMenu) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (manageMenu.getName()==null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","���������������");
+ return resultMap;
+ }
+ if (manageMenuMapper.getManageMenuByName(manageMenu.getName()) != null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","���������������������");
+ }else {
+ manageMenuMapper.insertOne(manageMenu);
+ resultMap.put("flag",true);
+ resultMap.put("msg","���������������");
+ }
+ return resultMap;
+ }
+
+ @Override
+ public Map<String,Object> updateManageMenu(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (!map.containsKey("id")){
+ resultMap.put("flag",false);
+ resultMap.put("msg","������������������������");
+ return resultMap;
+ }
+ if (manageMenuMapper.getManageMenuById(Integer.parseInt(map.get("id").toString())) == null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","���������������������");
+ }else {
+ manageMenuMapper.updateManageMenuById(map);
+ resultMap.put("flag",true);
+ resultMap.put("msg","���������������");
+ }
+ return resultMap;
+ }
+
+ @Override
+ public Map<String, Object> deleteManageMenu(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (!map.containsKey("id")){
+ resultMap.put("flag",false);
+ resultMap.put("msg","������������������������");
+ return resultMap;
+ }
+ if (manageMenuMapper.getManageMenuById(Integer.parseInt(map.get("id").toString())) == null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","������������������������������������");
+ }else {
+ Map deleteMap = new HashMap();
+ int id = Integer.parseInt(map.get("id").toString());
+ deleteMap.put("id",id);
+ deleteMap.put("is_delete",1);
+ manageMenuMapper.updateManageMenuById(deleteMap);
+ Map role_menuDeleteMap = new HashMap();
+ role_menuDeleteMap.put("menu_id",id);
+ manageRoleMenuMapper.updateDeleteStateByMenu_id(role_menuDeleteMap);
+ resultMap.put("flag",true);
+ resultMap.put("msg","���������������");
+ }
+ return resultMap;
+ }
}
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java
index 67846e8..3552237 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java
@@ -1,13 +1,20 @@
package com.moral.api.service.impl;
+import com.moral.api.entity.ManageMenu;
import com.moral.api.entity.ManageRole;
import com.moral.api.mapper.ManageRoleMapper;
+import com.moral.api.mapper.ManageRoleMenuMapper;
import com.moral.api.service.ManageRoleService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;
import javax.annotation.Resource;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -28,4 +35,102 @@
return null;
return null;
}
+
+ @Resource
+ private ManageRoleMapper manageRoleMapper;
+
+ @Resource
+ private ManageRoleMenuMapper manageRoleMenuMapper;
+
+ @Override
+ @Transactional
+ public List<ManageRole> getAll() {
+ return manageRoleMapper.getAll();
+ }
+
+ @Override
+ @Transactional
+ public Map<String,Object> insertOne(ManageRole manageRole,List list) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (manageRole.getName()==null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","���������������");
+ return resultMap;
+ }
+ if (manageRoleMapper.getManageRoleByName(manageRole.getName()) != null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","���������������������");
+ }else {
+ manageRoleMapper.insertOne(manageRole);
+ resultMap.put("flag",true);
+ resultMap.put("msg","���������������");
+ }
+ boolean flag = Boolean.parseBoolean(resultMap.get("flag").toString());
+ if (flag){
+ ManageRole manageRoleIns = manageRoleMapper.getManageRoleByName(manageRole.getName());
+ int role_id = manageRoleIns.getId();
+ System.out.println(role_id);
+ List insertList = new ArrayList();
+ for (Object temp: list) {
+ Map<String,Integer> insertMap = new HashMap<>();
+ insertMap.put("role_id",role_id);
+ insertMap.put("menu_id",Integer.parseInt(temp.toString()));
+ insertList.add(insertMap);
+ }
+ System.out.println(insertList);
+ manageRoleMenuMapper.insertBatch(insertList);
+ }
+ return resultMap;
+ }
+
+ @Override
+ @Transactional
+ public Map<String,Object> updateManageRole(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (!map.containsKey("id")){
+ resultMap.put("flag",false);
+ resultMap.put("msg","������������������������");
+ return resultMap;
+ }
+ if (manageRoleMapper.getManageRoleById(Integer.parseInt(map.get("id").toString())) == null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","���������������������");
+ }else {
+ manageRoleMapper.updateManageRoleById(map);
+ resultMap.put("flag",true);
+ resultMap.put("msg","���������������");
+ }
+ return resultMap;
+ }
+
+ @Override
+ @Transactional
+ public List<ManageRole> getManageRoleByNameFuzzy(ManageRole manageRole) {
+ return manageRoleMapper.getManageRoleByNameFuzzy(manageRole);
+ }
+
+ @Override
+ public Map<String, Object> deleteManageRole(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (!map.containsKey("id")){
+ resultMap.put("flag",false);
+ resultMap.put("msg","������������������������");
+ return resultMap;
+ }
+ if (manageRoleMapper.getManageRoleById(Integer.parseInt(map.get("id").toString())) == null){
+ resultMap.put("flag",false);
+ resultMap.put("msg","������������������������������������");
+ }else {
+ ManageRole manageRole = new ManageRole();
+ manageRole.setId(Integer.parseInt(map.get("id").toString()));
+ manageRole.setIsDelete("1");
+ Map deleteMap = new HashMap();
+ deleteMap.put("id",Integer.parseInt(map.get("id").toString()));
+ deleteMap.put("is_delete",1);
+ manageRoleMapper.updateManageRoleById(deleteMap);
+ resultMap.put("flag",true);
+ resultMap.put("msg","���������������");
+ }
+ return resultMap;
+ }
}
diff --git a/screen-manage/src/main/resources/mapper/ManageAccountRoleMapper.xml b/screen-manage/src/main/resources/mapper/ManageAccountRoleMapper.xml
index a5c9f89..4b02947 100644
--- a/screen-manage/src/main/resources/mapper/ManageAccountRoleMapper.xml
+++ b/screen-manage/src/main/resources/mapper/ManageAccountRoleMapper.xml
@@ -12,4 +12,10 @@
<result column="is_delete" property="isDelete" />
</resultMap>
+ <update id="updateDeleteStateByRole_id" parameterType="java.util.Map">
+ update manage_account_role
+ set is_delete = 1
+ where role_id = #{role_id}
+ </update>
+
</mapper>
\ No newline at end of file
diff --git a/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml b/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml
index c1b2261..33dfcee 100644
--- a/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml
+++ b/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml
@@ -89,4 +89,79 @@
mm.`parent_id`=0;
</select>
+ <select id="getManageMenuByName" resultMap="BaseResultMap">
+ select * from manage_menu
+ where name = #{name}
+ and is_delete = 0
+ </select>
+
+ <select id="getManageMenuById" resultMap="BaseResultMap">
+ select * from manage_menu
+ where id = #{id}
+ and is_delete = 0
+ </select>
+
+ <insert id="insertOne" parameterType="java.util.Map">
+ INSERT INTO manage_menu
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="name != null">
+ name,
+ </if>
+ <if test="url != null">
+ url,
+ </if>
+ <if test="icon != null">
+ icon,
+ </if>
+ <if test="parent_id != null">
+ parent_id,
+ </if>
+ <if test="order != null">
+ `order`,
+ </if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="name != null">
+ #{name},
+ </if>
+ <if test="url != null">
+ #{url},
+ </if>
+ <if test="icon != null">
+ #{icon},
+ </if>
+ <if test="parent_id != null">
+ #{parent_id},
+ </if>
+ <if test="order != null">
+ #{order},
+ </if>
+ </trim>
+ </insert>
+
+ <update id="updateManageMenuById" parameterType="java.util.Map">
+ update manage_menu
+ <set>
+ <if test="name != null">
+ name = #{name},
+ </if>
+ <if test="url != null">
+ url = #{url},
+ </if>
+ <if test="icon != null">
+ icon = #{icon},
+ </if>
+ <if test="parent_id != null">
+ parent_id = #{parent_id},
+ </if>
+ <if test="order != null">
+ `order` = #{order},
+ </if>
+ <if test="is_delete != null">
+ is_delete = #{is_delete},
+ </if>
+ </set>
+ where id = #{id}
+ </update>
+
</mapper>
\ No newline at end of file
diff --git a/screen-manage/src/main/resources/mapper/ManageRoleMapper.xml b/screen-manage/src/main/resources/mapper/ManageRoleMapper.xml
index 11266f8..8e3e2a3 100644
--- a/screen-manage/src/main/resources/mapper/ManageRoleMapper.xml
+++ b/screen-manage/src/main/resources/mapper/ManageRoleMapper.xml
@@ -28,4 +28,63 @@
where
mr.is_delete=0
</select>
+
+ <select id="getAll" resultMap="BaseResultMap">
+ select * from manage_role
+ where is_delete = 0
+ </select>
+
+ <select id="getManageRoleByName" resultMap="BaseResultMap">
+ select * from manage_role
+ where name = #{name}
+ and is_delete = 0
+ </select>
+
+ <select id="getManageRoleById" resultMap="BaseResultMap">
+ select * from manage_role
+ where id = #{id}
+ and is_delete = 0
+ </select>
+
+ <select id="getManageRoleByNameFuzzy" resultMap="BaseResultMap">
+ select * from manage_role
+ where name like concat('%',#{name},'%')
+ and is_delete = 0
+ </select>
+
+ <insert id="insertOne" parameterType="com.moral.api.entity.ManageRole">
+ INSERT INTO manage_role
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="name != null">
+ name,
+ </if>
+ <if test="desc != null">
+ `desc`,
+ </if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="name != null">
+ #{name},
+ </if>
+ <if test="desc != null">
+ #{desc},
+ </if>
+ </trim>
+ </insert>
+
+ <update id="updateManageRoleById" parameterType="com.moral.api.entity.ManageRole">
+ update manage_role
+ <set>
+ <if test="name != null">
+ name = #{name},
+ </if>
+ <if test="desc != null">
+ `desc` = #{desc},
+ </if>
+ <if test="is_delete != null">
+ is_delete = #{is_delete},
+ </if>
+ </set>
+ where id = #{id}
+ </update>
</mapper>
\ No newline at end of file
diff --git a/screen-manage/src/main/resources/mapper/ManageRoleMenuMapper.xml b/screen-manage/src/main/resources/mapper/ManageRoleMenuMapper.xml
index 76cd5a0..9c1d1cb 100644
--- a/screen-manage/src/main/resources/mapper/ManageRoleMenuMapper.xml
+++ b/screen-manage/src/main/resources/mapper/ManageRoleMenuMapper.xml
@@ -12,4 +12,18 @@
<result column="is_delete" property="isDelete" />
</resultMap>
+ <insert id="insertBatch" parameterType="java.util.List">
+ INSERT INTO manage_role_menu(role_id,menu_id)
+ values
+ <foreach collection="list" item="item" index="index" separator=",">
+ (#{item.role_id},#{item.menu_id})
+ </foreach>
+ </insert>
+
+ <update id="updateDeleteStateByMenu_id" parameterType="java.util.Map">
+ update manage_role_menu
+ set is_delete = 1
+ where menu_id = #{menu_id}
+ </update>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0