ycl-common/src/main/java/com/ycl/entity/platform/dict/DatabaseDictionary.java
New file @@ -0,0 +1,52 @@ package com.ycl.entity.platform.dict; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import lombok.EqualsAndHashCode; import java.io.Serializable; /** * <p> * * </p> * * @author lyq * @since 2022-09-15 */ @Data @EqualsAndHashCode(callSuper = false) @TableName("ums_database_dictionary") public class DatabaseDictionary implements Serializable { private static final long serialVersionUID = 1L; /** * 主键 */ @TableId(value = "id", type = IdType.AUTO) private Long id; /** * 字典值 */ @TableField("dictName") private String dictName; /** * 字典类型 */ @TableField("typeName") private String typeName; /** * 字典类型代码 */ @TableField("typeCode") private String typeCode; } ycl-common/src/main/java/com/ycl/entity/platform/zfreport/EnforcelawReport.java
@@ -9,7 +9,7 @@ import java.io.Serializable; import java.math.BigDecimal; import java.util.Date; import java.time.LocalDateTime; /** * <p> @@ -17,7 +17,7 @@ * </p> * * @author lyq * @since 2022-09-14 * @since 2022-09-15 */ @Data @EqualsAndHashCode(callSuper = false) @@ -35,8 +35,8 @@ /** * 违法/违建信息来源，字典项 */ @TableField("inforesoure") private String inforesoure; @TableField("infoResoure") private String infoResoure; /** * 受理人 @@ -47,8 +47,8 @@ /** * 问题类型 */ @TableField("problemtypes") private String problemtypes; @TableField("problemTypes") private String problemTypes; /** * 违建/违规类别 @@ -71,8 +71,8 @@ /** * 事发地址 */ @TableField("afaddr") private String afaddr; @TableField("afAddr") private String afAddr; /** * 举报人 @@ -95,8 +95,8 @@ /** * 问题描述 */ @TableField("problemdesc") private String problemdesc; @TableField("problemDesc") private String problemDesc; /** * 执法人 @@ -167,8 +167,8 @@ /** * 上传附件(违法照片) */ @TableField("IllegalPhotos") private String IllegalPhotos; @TableField("illegalPhotos") private String illegalPhotos; /** * 整改后照片 @@ -195,26 +195,22 @@ private String inspectors; /** * @Description 状态 * @Param * @return **/ * 状态 */ @TableField("status") private String status; /** * @Description 创建时间 * @Param * @return **/ * 创建时间 */ @TableField("cTime") private Date cTime; private LocalDateTime cTime; /** * @Description 所属街道 * @Param * @return **/ * 所属社区 */ @TableField("community") private Date community; private String community; } ycl-common/src/main/java/com/ycl/mapper/platform/dict/DatabaseDictionaryMapper.java
New file @@ -0,0 +1,16 @@ package com.ycl.mapper.platform.dict; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ycl.entity.platform.dict.DatabaseDictionary; /** * <p> * Mapper 接口 * </p> * * @author lyq * @since 2022-09-15 */ public interface DatabaseDictionaryMapper extends BaseMapper<DatabaseDictionary> { } ycl-common/src/main/java/com/ycl/service/platform/dict/IDatabaseDictionaryService.java
New file @@ -0,0 +1,29 @@ package com.ycl.service.platform.dict; import com.baomidou.mybatisplus.extension.service.IService; import com.ycl.entity.platform.dict.DatabaseDictionary; import java.util.List; /** * <p> * 服务类 * </p> * * @author lyq * @since 2022-09-15 */ public interface IDatabaseDictionaryService extends IService<DatabaseDictionary> { /** * 查询所有字典 * @return */ List<DatabaseDictionary> getAll(); /** * 根据code查询其对应的字典信息 * @param code * @return */ DatabaseDictionary queryByCode(String code); } ycl-common/src/main/java/com/ycl/service/platform/dict/impl/DatabaseDictionaryServiceImpl.java
New file @@ -0,0 +1,60 @@ package com.ycl.service.platform.dict.impl; import cn.hutool.core.collection.CollUtil; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.sql.StringEscape; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ycl.entity.platform.dict.DatabaseDictionary; import com.ycl.mapper.platform.dict.DatabaseDictionaryMapper; import com.ycl.service.platform.dict.IDatabaseDictionaryService; import com.ycl.service.redis.RedisService; import com.ycl.utils.common.LiveTimeMillisecond; import com.ycl.utils.redis.RedisKey; import io.micrometer.core.instrument.util.StringEscapeUtils; import org.apache.commons.lang3.ObjectUtils; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.List; /** * <p> * 服务实现类 * </p> * * @author lyq * @since 2022-09-15 */ @Service public class DatabaseDictionaryServiceImpl extends ServiceImpl<DatabaseDictionaryMapper, DatabaseDictionary> implements IDatabaseDictionaryService { @Resource private DatabaseDictionaryMapper databaseDictionaryMapper; @Resource private RedisService redisService; @Override public List<DatabaseDictionary> getAll() { String key = RedisKey.DICT_LIST_ALL; String result = (String) redisService.get(key); if (StringUtils.isBlank(result)) { List<DatabaseDictionary> dictList = databaseDictionaryMapper.selectList(null); redisService.set(key, JSON.toJSONString(dictList), LiveTimeMillisecond.s86400.time); return dictList; } List<DatabaseDictionary> list = JSONArray.parseArray(result, DatabaseDictionary.class); return list; } @Override public DatabaseDictionary queryByCode(String code) { LambdaQueryWrapper<DatabaseDictionary> queryWrapper = new LambdaQueryWrapper<DatabaseDictionary>().eq(DatabaseDictionary::getTypeCode, code); DatabaseDictionary databaseDictionary = databaseDictionaryMapper.selectOne(queryWrapper); return databaseDictionary; } } ycl-common/src/main/java/com/ycl/service/platform/zfreport/IEnforcelawReportService.java
File was renamed from ycl-common/src/main/java/com/ycl/service/platform/zfreport/EnforcelawReportService.java @@ -11,6 +11,6 @@ * @author lyq * @since 2022-09-14 */ public interface EnforcelawReportService extends IService<EnforcelawReport> { public interface IEnforcelawReportService extends IService<EnforcelawReport> { } ycl-common/src/main/java/com/ycl/utils/redis/RedisKey.java
@@ -11,4 +11,9 @@ * 管理后台 */ public static final String PLATFORM_TOKEN_KEY = "platform-token:"; /** * 字典key */ public static final String DICT_LIST_ALL = "dict-list-all"; } ycl-common/src/main/resources/mapper/platform/dict/DatabaseDictionaryMapper.xml
New file @@ -0,0 +1,18 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.ycl.mapper.platform.dict.DatabaseDictionaryMapper"> <!-- 通用查询映射结果 --> <resultMap id="BaseResultMap" type="com.ycl.entity.platform.dict.DatabaseDictionary"> <id column="id" property="id" /> <result column="dictName" property="dictName" /> <result column="typeName" property="typeName" /> <result column="typeCode" property="typeCode" /> </resultMap> <!-- 通用查询结果列 --> <sql id="Base_Column_List"> id, dictName, typeName, typeCode </sql> </mapper> ycl-common/src/main/resources/mapper/platform/zfreport/EnforcelawReportMapper.xml
@@ -5,17 +5,17 @@ <!-- 通用查询映射结果 --> <resultMap id="BaseResultMap" type="com.ycl.entity.platform.zfreport.EnforcelawReport"> <id column="id" property="id" /> <result column="inforesoure" property="inforesoure" /> <result column="infoResoure" property="infoResoure" /> <result column="acceptor" property="acceptor" /> <result column="problemtypes" property="problemtypes" /> <result column="problemTypes" property="problemTypes" /> <result column="category" property="category" /> <result column="county" property="county" /> <result column="street" property="street" /> <result column="afaddr" property="afaddr" /> <result column="afAddr" property="afAddr" /> <result column="informer" property="informer" /> <result column="contact" property="contact" /> <result column="reason" property="reason" /> <result column="problemdesc" property="problemdesc" /> <result column="problemDesc" property="problemDesc" /> <result column="lawOfficer" property="lawOfficer" /> <result column="partiesName" property="partiesName" /> <result column="partiesID" property="partiesID" /> @@ -27,16 +27,19 @@ <result column="illegalBuildWidth" property="illegalBuildWidth" /> <result column="illegalBuildHigh" property="illegalBuildHigh" /> <result column="illegalBuildMaterials" property="illegalBuildMaterials" /> <result column="IllegalPhotos" property="IllegalPhotos" /> <result column="illegalPhotos" property="illegalPhotos" /> <result column="rectifidPhotos" property="rectifidPhotos" /> <result column="accessory" property="accessory" /> <result column="disposeRemark" property="disposeRemark" /> <result column="inspectors" property="inspectors" /> <result column="status" property="status" /> <result column="cTime" property="cTime" /> <result column="community" property="community" /> </resultMap> <!-- 通用查询结果列 --> <sql id="Base_Column_List"> id, inforesoure, acceptor, problemtypes, category, county, street, afaddr, informer, contact, reason, problemdesc, lawOfficer, partiesName, partiesID, partiesPhone, idPositiveImage, idNegativeImage, illegalBuildLocation, illegalBuildLength, illegalBuildWidth, illegalBuildHigh, illegalBuildMaterials, IllegalPhotos, rectifidPhotos, accessory, disposeRemark, inspectors id, infoResoure, acceptor, problemTypes, category, county, street, afAddr, informer, contact, reason, problemDesc, lawOfficer, partiesName, partiesID, partiesPhone, idPositiveImage, idNegativeImage, illegalBuildLocation, illegalBuildLength, illegalBuildWidth, illegalBuildHigh, illegalBuildMaterials, IllegalPhotos, rectifidPhotos, accessory, disposeRemark, inspectors, status, cTime, community </sql> </mapper> ycl-platform/src/main/java/com/ycl/controller/dict/DatabaseDictionaryController.java
New file @@ -0,0 +1,45 @@ package com.ycl.controller.dict; import com.ycl.api.CommonResult; import com.ycl.controller.BaseController; import com.ycl.entity.platform.dict.DatabaseDictionary; import com.ycl.service.platform.dict.IDatabaseDictionaryService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; import java.util.List; /** * <p> * 前端控制器 * </p> * * @author lyq * @since 2022-09-15 */ @RestController @RequestMapping("/dict") @Api(tags = "字典模块") public class DatabaseDictionaryController extends BaseController { @Resource private IDatabaseDictionaryService iDatabaseDictionaryService; @GetMapping("/listAll") @ApiOperation("获取所有字典") private CommonResult<List<DatabaseDictionary>> listAll() { return CommonResult.success(iDatabaseDictionaryService.getAll()); } @GetMapping("/queryByCode") @ApiOperation(("/根据code获取字段信息")) private CommonResult<DatabaseDictionary> queryByCode(@RequestParam(value = "code") String code){ DatabaseDictionary databaseDictionary = iDatabaseDictionaryService.queryByCode(code); return CommonResult.success(databaseDictionary); } } ycl-platform/src/main/resources/application.yml
@@ -83,3 +83,4 @@ - /**/admin/register - /**/admin/info - /**/admin/logout - /dict/**
