fix：sql查询时间调整

cjl

2025-01-06 8490eb11583ffdc586436f165860de5cfc39f915

 screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java

@@ -2,8 +2,10 @@

import com.moral.api.entity.ManageMenu;
import com.baomidou.mybatisplus.extension.service.IService;
import com.moral.api.entity.ManageRole;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.Map;

/**
@@ -17,12 +19,114 @@
@Transactional
public interface ManageMenuService extends IService<ManageMenu> {

    /**
     * @Description: 添加菜单
     * @Param: [ManageMenu]
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    @Transactional
    Map<String,Object> insertManageMenu(ManageMenu manageMenu);

    /**
     * @Description: 更新菜单
     * @Param: [Map]
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    @Transactional
    Map<String,Object> updateManageMenu(Map map);

    /**
     * @Description: 删除菜单
     * @Param: [Map]
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    @Transactional
    Map<String,Object> deleteManageMenu(Map map);

    /**
     * @Description: 分页查询所有菜单
     * @Param: [Map]
     * @return: List
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    List<Map<String,Object>> getAllWithPagingQuery(Map map);

    /**
     * @Description: 获取所有菜单
     * @Param: []
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    List<ManageMenu> getAllMenus();

    /**
     * @Description: 通过角色ID获取菜单
     * @Param: [Map]
     * @return: int
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    List getManageMenuByRoleId(int roleId);

    /**
     * @Description: 通过角色ID获取子菜单
     * @Param: [Map]
     * @return: int
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    List getManageChildMenuByRoleId(int roleId);

    /**
     * @Description: 通过name模糊查询菜单
     * @Param: [Map]
     * @return: List</Map>
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    List<Map<String,Object>> getManageMenuByNameFuzzy(Map map);

    /**
     * @Description: 通过条件查询菜单
     * @Param: [Map]
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    Map<String,Object> getManageMenuByCondition(Map map);

    /**
     * @Description: 获取父菜单菜单
     * @Param: [Map]
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    Map<String,Object> getManageParentMenu(Map map);

    /**
     * @Description: 通过父菜单ID查询所有子菜单
     * @Param: [Map]
     * @return: Map
     * @Author: 李子杰
     * @Date: 2021/7/26
     */
    List<Map<String,Object>> getManageMenuByParentId(Map map);

    /**
     * @Description: 组合多级菜单
     * @Param: [List</Map>]
     * @return: List</ManageMenu>
     * @Author: 陈凯裕
     * @Date: 2021/7/26
     */
    List<ManageMenu> getParentChildrenMenusByRoles(List<ManageRole> roles);
}