framework/src/main/java/com/yuanchu/mom/common/GetLook.java
@@ -23,5 +23,4 @@ map.put("look", authMapper.countPower(id, method)); return map; } } inspect-server/src/main/java/com/yuanchu/mom/controller/InsReportController.java
@@ -10,6 +10,7 @@ import com.yuanchu.mom.vo.Result; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.AllArgsConstructor; import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; @@ -22,6 +23,7 @@ @RestController @RequestMapping("/insReport") @AllArgsConstructor @Api("æ£éªæ¥å") public class InsReportController { inspect-server/src/main/java/com/yuanchu/mom/controller/InsUnPassController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,40 @@ package com.yuanchu.mom.controller; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.annotation.ValueAuth; import com.yuanchu.mom.dto.UnPassPageDto; import com.yuanchu.mom.service.InsUnPassService; import com.yuanchu.mom.utils.JackSonUtil; import com.yuanchu.mom.vo.Result; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.AllArgsConstructor; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; import java.util.Map; /** * @author æ±ä½³å * @date 2024/5/8 10:35 */ @RestController @RequestMapping("/unPass") @Api("/ä¸åæ ¼ç®¡ç") @AllArgsConstructor public class InsUnPassController { @Resource private InsUnPassService insUnPassService; @ValueAuth @ApiOperation(value = "æ¥è¯¢ä¸åæ ¼æ ·åæ°æ®") @PostMapping("/pageInsUnPass") public Result pageUnPass(@RequestBody Map<String, Object> data) throws Exception { Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class); UnPassPageDto unPassPageDto = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), UnPassPageDto.class); return Result.success(insUnPassService.pageInsUnPass(page, unPassPageDto)); } } inspect-server/src/main/java/com/yuanchu/mom/dto/UnPassPageDto.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,15 @@ package com.yuanchu.mom.dto; import com.yuanchu.mom.pojo.InsUnPass; import lombok.Data; import java.io.Serializable; /** * @author æ±ä½³å * @date 2024/5/8 12:38 */ @Data public class UnPassPageDto extends InsUnPass implements Serializable { } inspect-server/src/main/java/com/yuanchu/mom/mapper/InsUnPassMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,15 @@ package com.yuanchu.mom.mapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.yuanchu.mom.dto.UnPassPageDto; import com.yuanchu.mom.pojo.InsUnPass; /** * @author æ±ä½³å * @date 2024/5/8 13:05 */ public interface InsUnPassMapper extends BaseMapper<InsUnPass> { IPage<UnPassPageDto> pageInsUnPass(IPage<UnPassPageDto> page, QueryWrapper<UnPassPageDto> ew); } inspect-server/src/main/java/com/yuanchu/mom/pojo/InsUnPass.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,83 @@ package com.yuanchu.mom.pojo; import com.baomidou.mybatisplus.annotation.*; import com.fasterxml.jackson.annotation.JsonFormat; import com.yuanchu.mom.annotation.ValueTableShow; import com.yuanchu.mom.common.OrderBy; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.io.Serializable; import java.time.LocalDateTime; /** * @author æ±ä½³å * @date 2024/5/8 14:11 */ @Data @TableName("ins_un_pass") public class InsUnPass extends OrderBy implements Serializable { /** * ä¸åæ ¼id */ @ApiModelProperty(value = "主é®") @TableId(type = IdType.AUTO) private Integer id; /** * è§æ ¼åå· */ @ValueTableShow(value = 2, name = "è§æ ¼åå·") private String model; /** * æ ·ååç§° */ @ValueTableShow(value = 3, name = "æ ·ååç§°") private String sample; /** * æ£æµé¡¹ */ @ValueTableShow(value = 4, name = "æ£æµé¡¹") private String inspectionItems; /** * æ£æµå项 */ @ValueTableShow(value = 5, name = "æ£æµå项") private String inspectionItemSubclass; /** * æ£æµç»æ */ @ValueTableShow(value = 6, name = "æ£æµç»æ") private String lastValue; /** * å¤çæè§ */ @ValueTableShow(value = 7, name = "å¤çæè§") private String handleSuggestion; /** * å§æç¼å· */ @ValueTableShow(value = 8, name = "å§æç¼å·") private String entrustCode; /** * ç¨æ·å */ @ValueTableShow(value = 9, name = "ç¨æ·å") private String name; @TableField(fill = FieldFill.INSERT) private Integer createUser; @ApiModelProperty("å建æ¶é´") @TableField(fill = FieldFill.INSERT) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime createTime; @TableField(fill = FieldFill.INSERT_UPDATE) private Integer updateUser; @ApiModelProperty("ä¿®æ¹æ¶é´") @TableField(fill = FieldFill.INSERT_UPDATE) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime updateTime; } inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,14 @@ package com.yuanchu.mom.service; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.dto.UnPassPageDto; import java.util.Map; /** * @author æ±ä½³å * @date 2024/5/8 13:00 */ public interface InsUnPassService { Map<String, Object> pageInsUnPass(Page page, UnPassPageDto unPassPageDto); } inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,38 @@ package com.yuanchu.mom.service.impl; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.yuanchu.mom.common.GetLook; import com.yuanchu.mom.common.PrintChina; import com.yuanchu.mom.dto.UnPassPageDto; import com.yuanchu.mom.mapper.InsUnPassMapper; import com.yuanchu.mom.pojo.InsUnPass; import com.yuanchu.mom.service.InsUnPassService; import com.yuanchu.mom.utils.QueryWrappers; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.HashMap; import java.util.Map; /** * @author æ±ä½³å * @date 2024/5/8 13:02 */ @Service public class InsUnPassServiceImpl extends ServiceImpl<InsUnPassMapper, InsUnPass> implements InsUnPassService { @Resource private GetLook getLook; @Resource private InsUnPassMapper insUnPassMapper; @Override public Map<String, Object> pageInsUnPass(Page page, UnPassPageDto unPassPageDto) { Map<String, Object> map = new HashMap<>(); map.put("head", PrintChina.printChina(UnPassPageDto.class)); Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("pageInsUnPass"); if (map1.get("look") == 1) unPassPageDto.setCreateUser(map1.get("userId")); map.put("body", insUnPassMapper.pageInsUnPass(page, QueryWrappers.queryWrappers(unPassPageDto))); return map; } } inspect-server/src/main/resources/mapper/InsUnPassMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,33 @@ <?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.yuanchu.mom.mapper.InsUnPassMapper"> <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.InsUnPass"> <id property="id" column="id" jdbcType="INTEGER"/> <result property="sample" column="sample" jdbcType="VARCHAR"/> <result property="inspectionItems" column="inspection_items" jdbcType="VARCHAR"/> <result property="inspectionItemSubclass" column="inspection_item_subclass" jdbcType="VARCHAR"/> <result property="lastValue" column="last_value" jdbcType="VARCHAR"/> <result property="model" column="model" jdbcType="VARCHAR"/> <result property="handleSuggestion" column="handle_suggestion" jdbcType="VARCHAR"/> <result property="entrustCode" column="entrust_code" jdbcType="VARCHAR"/> <result property="name" column="name" jdbcType="VARCHAR"/> <result property="createUser" column="create_user" jdbcType="INTEGER"/> <result property="updateUser" column="update_user" jdbcType="INTEGER"/> <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/> </resultMap> <select id="pageInsUnPass" resultType="com.yuanchu.mom.dto.UnPassPageDto"> -- select * -- from ( -- select -- iu.*,io.entrust_code,u.name write_user_name -- from ins_un_pass iu -- left join ins_order io on io.id = iu.ins_order_id -- left join user u on u.id = iu.create_user -- ) a select * from ins_un_pass iu </select> </mapper> system-run/src/main/java/com/yuanchu/mom/SystemRunApplication.java
@@ -16,5 +16,4 @@ public static void main(String[] args) { SpringApplication.run(SystemRunApplication.class, args); } }