roma-api/src/main/java/com/roma/romaapi/dao/PageDao.java

package com.roma.romaapi.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

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

@Repository
public class PageDao {
    @Autowired
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    // 获取页面json
    public Map dbQueryForMap(String pageCode) {
        try {
            Map<String, Object> paramMap = new HashMap<>();
            paramMap.put("page_code", pageCode);
            Map<String, Object> resMap2 = namedParameterJdbcTemplate.queryForMap(
                    "SELECT `page_json` FROM `page_details` where `page_code` = :page_code", paramMap);

            return resMap2;
        } catch (EmptyResultDataAccessException e) {
            Map<String, Object> resultMap = new HashMap<>();
            resultMap.put("sysErrorCode", "500");
            resultMap.put("sysErrorMessage", "operation failed");

            return resultMap;
        }
    }

    // 获取全部菜单项
    public List<Map<String, Object>> getMenuForList(){
        Map<String, Object> paramMap = new HashMap<>();
        paramMap.put("type_menu", "menu");
        paramMap.put("type_dir", "dir");
        String sql = " SELECT  `rp`.`id`,`rp`.`parent_id`,`rp`.`icon`,`rp`.`type`,`rp`.`value` AS `path`,`pd`.`front_path` AS `url`,`rp`.`display_name` AS `label` " +
                "FROM `roma_permissions` AS `rp` LEFT JOIN `page_details` AS `pd` ON `pd`.`id`=`rp`.`page_id` " +
                "WHERE `rp`.`is_enable`=1 AND (`rp`.`type`=:type_menu OR `rp`.`type`=:type_dir )  ORDER BY `rp`.`sort` ASC ";
        List<Map<String, Object>> resMap2 = namedParameterJdbcTemplate.queryForList(sql, paramMap);

        return resMap2;
    }

    // 获取全部权限
    public List<Map<String, Object>> getAllMenuForList(){
        Map<String, Object> paramMap = new HashMap<>();
        paramMap.put("append_params", "1");
        String sql = " SELECT  `rp`.`is_enable`,`rp`.`id`,`rp`.`parent_id`,`rp`.`icon`,`rp`.`type`,`rp`.`value` AS `path`,`pd`.`front_path` AS `url`,`rp`.`display_name` AS `label` " +
                "FROM `roma_permissions` AS `rp` LEFT JOIN `page_details` AS `pd` ON `pd`.`id`=`rp`.`page_id` " +
                "WHERE  (1=:append_params )  ORDER BY `rp`.`sort` ASC ";
        List<Map<String, Object>> resMap2 = namedParameterJdbcTemplate.queryForList(sql, paramMap);

        return resMap2;
    }

    // 获取全部的页面
//    public List<Map<String, Object>> getAllPageList() {
//
//    }
}