Merge remote-tracking branch 'origin/master'
| | |
| | | return Result.success(inspectionService.addInspect((Integer) unmarshal.get("id"), inspectionVo)); |
| | | } |
| | | |
| | | @ApiOperation(value = "æ ¹æ®æ£éªåidæ¥è¯¢åæææ£éªå详æ
") |
| | | @ApiOperation(value = "æ ¹æ®æ£éªåidæ¥è¯¢æ£éªå详æ
") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "id", value = "æ£éªåid", dataTypeClass = Integer.class, required = true) |
| | | }) |
| | |
| | | package com.yuanchu.limslaboratory.controller; |
| | | |
| | | import com.yuanchu.limslaboratory.pojo.vo.PlanVo; |
| | | import com.yuanchu.limslaboratory.service.PlanService; |
| | | import com.yuanchu.limslaboratory.vo.Result; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | private PlanService planService; |
| | | |
| | | |
| | | @ApiOperation("æ¥è¯¢æ£éªè®¡å") |
| | | @ApiOperation("æ¥è¯¢æææ£éªè®¡å") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "device", value = "设å¤åç§°Id", dataTypeClass = String.class), |
| | | @ApiImplicitParam(name = "beginTime", value = "æ£éªå¼å§æ¶é´", dataTypeClass = Date.class), |
| | | @ApiImplicitParam(name = "endTime", value = "æ£éªç»ææ¶é´", dataTypeClass = Date.class), |
| | | @ApiImplicitParam(name = "user", value = "æ£éªäºº", dataTypeClass = String.class) |
| | | @ApiImplicitParam(name = "code", value = "ç³è¯·åç¼å·", dataTypeClass = String.class), |
| | | @ApiImplicitParam(name = "beginTime", value = "æ£éªå¼å§æ¶é´", dataTypeClass = String.class), |
| | | @ApiImplicitParam(name = "endTime", value = "æ£éªç»ææ¶é´", dataTypeClass = String.class), |
| | | @ApiImplicitParam(name = "status", value = "æ£éªç»æ", dataTypeClass = Integer.class) |
| | | }) |
| | | @GetMapping("/selectAllPlan") |
| | | public Result selectAllPlan(String device, @DateTimeFormat(pattern = "yyyy-MM-dd") Date beginTime, @DateTimeFormat(pattern = "yyyy-MM-dd") Date endTime, String user) { |
| | | List<PlanVo> planVoList = planService.selectAllPlan(device, beginTime, endTime, user); |
| | | return Result.success(planVoList); |
| | | public Result selectAllPlan(String code, String beginTime, String endTime, Integer status) { |
| | | return Result.success(planService.selectAllPlan(code, beginTime, endTime, status)); |
| | | } |
| | | |
| | | @ApiOperation("åé
-->éæ©æ£éªäºº") |
| | | @GetMapping("/choosecheck") |
| | | public Result choosecheck() { |
| | | return Result.success(planService.choosecheck()); |
| | | } |
| | | |
| | | @ApiOperation("åé
--éæ©è®¾å¤") |
| | | @GetMapping("/chooseinstum") |
| | | public Result chooseinstum() { |
| | | return Result.success(planService.chooseinstum()); |
| | | } |
| | | |
| | | @ApiOperation("åé
") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "id", value = "æ£éªé¡¹ç®id", dataTypeClass = Integer.class, required = true), |
| | | @ApiImplicitParam(name = "userId", value = "æ£éªäººid", dataTypeClass = Integer.class, required = true), |
| | | @ApiImplicitParam(name = "instrumentId", value = "设å¤id", dataTypeClass = Integer.class, required = true) |
| | | }) |
| | | @PostMapping("/distribution") |
| | | public Result distribution(Integer id, Integer userId, Integer instrumentId) { |
| | | return Result.success(planService.distribution(id, userId, instrumentId)); |
| | | } |
| | | } |
| | |
| | | package com.yuanchu.limslaboratory.mapper; |
| | | |
| | | import com.yuanchu.limslaboratory.pojo.vo.PlanVo; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | public interface PlanMapper { |
| | | /** |
| | | * æ¥è¯¢æ£éªè®¡å |
| | | * @return |
| | | */ |
| | | List<PlanVo> selectAllPlan(String device, Date beginTime, Date endTime, String user); |
| | | |
| | | //æ¥è¯¢æ£éªè®¡å |
| | | List<Map<String, Object>> selectAllPlan(String code, String beginTime, String endTime,Integer status); |
| | | } |
| | |
| | | **/ |
| | | private Integer state; |
| | | |
| | | /** |
| | | * ${column.comment} |
| | | **/ |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") |
| | | private Date createTime; |
| | | |
| | | /** |
| | | * ${column.comment} |
| | | **/ |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") |
| | |
| | | */ |
| | | public interface InspectionProductService extends IService<InspectionProduct> { |
| | | |
| | | /** |
| | | * æ´æ°æ£éªé¡¹ç® |
| | | * @param userId |
| | | * @param inspectionProduct |
| | | * @return |
| | | */ |
| | | boolean updateInsProduct(Integer userId, InspectionProduct inspectionProduct); |
| | | |
| | | } |
| | | |
| | |
| | | package com.yuanchu.limslaboratory.service; |
| | | |
| | | import com.yuanchu.limslaboratory.pojo.vo.PlanVo; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | * æ¥è¯¢æ£éªè®¡å |
| | | * @return |
| | | */ |
| | | List<PlanVo> selectAllPlan(String device, Date beginTime, Date endTime, String user); |
| | | List<Map<String,Object>> selectAllPlan(String code , String beginTime, String endTime,Integer status); |
| | | |
| | | /** |
| | | * åé
-->éæ©æ£éªäºº |
| | | * @return |
| | | */ |
| | | List<Map<String,Object>> choosecheck(); |
| | | |
| | | /** |
| | | * åé
-->éæ©è®¾å¤ |
| | | * @return |
| | | */ |
| | | List<Map<String,Object>> chooseinstum(); |
| | | |
| | | /** |
| | | * åé
|
| | | * @return |
| | | */ |
| | | String distribution(Integer id, Integer userId, Integer instrumentId); |
| | | } |
| | |
| | | @Resource |
| | | InspectionProductMapper inspectionProductMapper; |
| | | |
| | | //æ´æ°æ£éªé¡¹ç® |
| | | /* //æ´æ°æ£éªé¡¹ç® |
| | | @Override |
| | | public boolean updateInsProduct(Integer userId, InspectionProduct inspectionProduct) { |
| | | //èµå¼æ£éªåid |
| | |
| | | .eq(InspectionProduct::getName, inspectionProduct.getName()); |
| | | inspectionProductMapper.update(inspectionProduct, updateWrapper); |
| | | return true; |
| | | } |
| | | }*/ |
| | | |
| | | /*å¤ææ£æµå¼æ¯å¦æ»¡è¶³æ åå¼åå
æ§å¼çè¦æ±,妿䏿»¡è¶³åæ£éªç»è®ºä¸ºä¸åæ ¼*/ |
| | | private int checkValues(String standardValueStr, String controlValueStr, String detectionValueStr) { |
| | |
| | | import com.yuanchu.limslaboratory.utils.MyUtil; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.*; |
| | |
| | | * @return |
| | | */ |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public Integer addInspect(Integer id, InspectionVo inspectionVo) { |
| | | /*æ°å¢æ£éªç³è¯·è¡¨*/ |
| | | Inspection inspection = Inspection.builder() |
| | |
| | | |
| | | //æ ¹æ®æ£éªåidæ¥è¯¢åæææ£éªå详æ
|
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public InspectDetailVo selectInspectsListById(Integer id) { |
| | | /*å°æ£éªååºæ¬ä¿¡æ¯æ¥è¯¢åºæ¥å¹¶å°è£
å°RawInspectVo对象ä¸*/ |
| | | Inspection inspection = inspectionMapper.selectById(id); |
| | |
| | | |
| | | //æ´æ°æ£éªåæ£éªç»æ |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean updateInspectsById(Integer id) { |
| | | //æ´æ°æ£éªåéé¢çæ£éªç¶æåæ£éªç»è®º |
| | | InspectDetailVo inspectDetailVo = selectInspectsListById(id); |
| | |
| | | package com.yuanchu.limslaboratory.service.impl; |
| | | |
| | | import com.yuanchu.limslaboratory.mapper.PlanMapper; |
| | | import com.yuanchu.limslaboratory.pojo.vo.PlanVo; |
| | | import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.yuanchu.limslaboratory.mapper.*; |
| | | import com.yuanchu.limslaboratory.pojo.InspectionProduct; |
| | | import com.yuanchu.limslaboratory.pojo.Instrument; |
| | | import com.yuanchu.limslaboratory.pojo.User; |
| | | import com.yuanchu.limslaboratory.service.InstrumentService; |
| | | import com.yuanchu.limslaboratory.service.PlanService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | @Resource |
| | | private PlanMapper planMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢æ£éªè®¡å |
| | | * |
| | | * @return |
| | | */ |
| | | @Resource |
| | | InspectionProductMapper inspectionProductMapper; |
| | | |
| | | @Resource |
| | | UserMapper userMapper; |
| | | |
| | | @Resource |
| | | InstrumentMapper instrumentMapper; |
| | | |
| | | //æ¥è¯¢æ£éªè®¡å |
| | | @Override |
| | | public List<PlanVo> selectAllPlan(String device, Date beginTime, Date endTime, String user) { |
| | | //è·åæ°æ®åºæ°æ® |
| | | List<PlanVo> planVos = planMapper.selectAllPlan(device, beginTime, endTime, user); |
| | | //æ·»å 计åå·¥æåæ£éªè¿åº¦ |
| | | planVos.forEach(planVo -> { |
| | | //æ·»å æ£éªè¿åº¦ |
| | | //夿æ¯å¦æ¯å·²å®æ |
| | | if (planVo.getState() != null) { |
| | | planVo.setProgress(100); |
| | | } |
| | | //夿æ¯å¦æ¯æªåé
|
| | | if (planVo.getCheckproject() == null) { |
| | | planVo.setProgress(0); |
| | | } |
| | | //夿æ¯å¦æ¯è¿è¡ä¸ |
| | | if (planVo.getState() == null && planVo.getCheckproject() != null) { |
| | | planVo.setProgress(50); |
| | | } |
| | | //æ·»å 计åå·¥æ |
| | | if (planVo.getFinishtime() != null && planVo.getStarttime() != null) { |
| | | long startTimeInMillis = planVo.getStarttime().getTime(); |
| | | long endTimeInMillis = planVo.getFinishtime().getTime(); |
| | | long durationInMillis = endTimeInMillis - startTimeInMillis; |
| | | long duration = durationInMillis / (1000 * 60 * 60); |
| | | planVo.setDuration(Integer.valueOf((int) duration)); |
| | | } |
| | | }); |
| | | return planVos; |
| | | public List<Map<String,Object>> selectAllPlan(String code , String beginTime, String endTime,Integer status) { |
| | | return planMapper.selectAllPlan(code,beginTime,endTime,status); |
| | | } |
| | | |
| | | //åé
-->éæ©æ£éªäºº |
| | | @Override |
| | | public List<Map<String, Object>> choosecheck() { |
| | | return userMapper.selectUser(); |
| | | } |
| | | |
| | | //åé
-->éæ©è®¾å¤ |
| | | @Override |
| | | public List<Map<String, Object>> chooseinstum() { |
| | | return null; |
| | | } |
| | | |
| | | //åé
人åä¸è®¾å¤ |
| | | @Override |
| | | public String distribution(Integer id, Integer userId, Integer instrumentId) { |
| | | InspectionProduct inspectionProduct = new InspectionProduct(); |
| | | inspectionProduct.setId(id); |
| | | inspectionProduct.setUserId(userId); |
| | | inspectionProduct.setInstrumentId(instrumentId); |
| | | inspectionProductMapper.updateById(inspectionProduct); |
| | | return "åé
宿!"; |
| | | } |
| | | } |
| | |
| | | <?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.limslaboratory.mapper.PlanMapper"> |
| | | |
| | | <resultMap id="selectAllPlanMap" type="map" > |
| | | <id property="code" column="code"/> |
| | | <result property="inspectionStatus" column="inspectionStatus"/> |
| | | <result property="startTime" column="startTime"/> |
| | | <result property="endTime" column="endTime"/> |
| | | <collection property="father" resultMap="selectAllPlanMapTowMap" javaType="List"/> |
| | | </resultMap> |
| | | <resultMap id="selectAllPlanMapTowMap" type="map"> |
| | | <id property="samplename" column="samplename"/> |
| | | <collection property="chldren" resultMap="selectAllPlanMapTowsMap" javaType="List"/> |
| | | </resultMap> |
| | | <resultMap id="selectAllPlanMapTowsMap" type="map"> |
| | | <id property="id" column="id"/> |
| | | <result property="name" column="name"/> |
| | | <result property="unit" column="unit"/> |
| | | <result property="required" column="required"/> |
| | | <result property="internal" column="internal"/> |
| | | <result property="testState" column="testState"/> |
| | | <result property="checker" column="checker"/> |
| | | <result property="instrumentname" column="instrumentname"/> |
| | | </resultMap> |
| | | <!--æ¥è¯¢æ£éªè®¡å--> |
| | | <select id="selectAllPlan" resultType="com.yuanchu.limslaboratory.pojo.vo.PlanVo"> |
| | | select i.equipment_name device, |
| | | <select id="selectAllPlan" resultMap="selectAllPlanMap"> |
| | | select ip.id, |
| | | i.code, |
| | | inspection_status inspectionStatus, |
| | | DATE_FORMAT(start_time,'%Y-%m-%d') startTime, |
| | | DATE_FORMAT(end_time,'%Y-%m-%d') endTime, |
| | | im.name samplename, |
| | | im.code sampleid, |
| | | im.specifications modelandspecification, |
| | | im.unit unit, |
| | | im.num amount, |
| | | ip.name checkproject, |
| | | ip.name, |
| | | ip.unit, |
| | | required, |
| | | internal, |
| | | test_state testState, |
| | | u.name checker, |
| | | ip.start_time starttime, |
| | | ip.end_time finishtime, |
| | | ip.test_state state |
| | | from instrument i |
| | | left join (select ip.* |
| | | from inspection_product ip |
| | | right join (select instrument_id, max(ip.end_time) t |
| | | from inspection_product ip |
| | | group by instrument_id) it |
| | | on ip.instrument_id = it.instrument_id and ip.end_time = it.t) ip |
| | | on i.id = ip.instrument_id |
| | | left join inspection_material im on im.id = ip.inspection_material_id |
| | | left join user u on u.id = ip.user_id |
| | | equipment_name instrumentname |
| | | from lims_laboratory.inspection_product ip |
| | | left join lims_laboratory.inspection_material im on ip.inspection_material_id = im.id |
| | | left join lims_laboratory.inspection i on im.inspection_id = i.id |
| | | left join lims_laboratory.user u on ip.user_id = u.id |
| | | left join lims_laboratory.instrument isu on ip.instrument_id = isu.id |
| | | <where> |
| | | <if test="device != null and device != null"> |
| | | and i.equipment_name = #{device} |
| | | <if test="code != null and code != null"> |
| | | and i.code like concat('%',#{code},'%') |
| | | </if> |
| | | <if test="user != null and user != null"> |
| | | and u.name = #{user} |
| | | <if test="status != null "> |
| | | and inspection_status = #{status} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and ip.start_time between #{beginTime} and #{endTime} |
| | | and i.start_time between #{beginTime} and #{endTime} |
| | | </if> |
| | | </where> |
| | | </select> |
| | |
| | | <mapper namespace="com.yuanchu.limslaboratory.mapper.ReportMapper"> |
| | | |
| | | <!--æ¥è¯¢æ£éªæ¥å--> |
| | | <select id="selectAllReport" resultType="com.yuanchu.limslaboratory.pojo.vo.ReportVo">select im.code materialCode, |
| | | <select id="selectAllReport" resultType="com.yuanchu.limslaboratory.pojo.vo.ReportVo"> |
| | | select im.code materialCode, |
| | | r.code reportCode, |
| | | i.code inspectionCode, |
| | | r.approver approver, |
| | |
| | | |
| | | IPage<Map<String, Object>> getListInstrumentInformation(Integer conditions,Boolean whetherWhether, String numberOrNameOrSpecifications, Integer classifyId, Page<Objects> page); |
| | | |
| | | //æ¥è¯¢ææè®¾å¤ä¿¡æ¯ |
| | | List<Map> selectInstrument(); |
| | | |
| | | |
| | | } |
| | |
| | | |
| | | Integer updateEquipmentPointInformation(Instrument instrument); |
| | | |
| | | /** |
| | | * æ¥è¯¢ææè®¾å¤ä¿¡æ¯ |
| | | * @return |
| | | */ |
| | | List<Map> selectInstrument(); |
| | | |
| | | |
| | | } |
| | |
| | | return 0; |
| | | } |
| | | |
| | | //æ¥è¯¢ææè®¾å¤ä¿¡æ¯ |
| | | @Override |
| | | public List<Map> selectInstrument() { |
| | | return instrumentMapper.selectInstrument(); |
| | | } |
| | | |
| | | } |
| | |
| | | </if> |
| | | AND i.`user_id` = u.`id` |
| | | </select> |
| | | <select id="selectInstrument" resultType="Map"> |
| | | select id,equipment_name from lims_laboratory.instrument |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | import com.baomidou.mybatisplus.annotation.*; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.AllArgsConstructor; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.NoArgsConstructor; |
| | | import lombok.*; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | |
| | | @AllArgsConstructor |
| | | @NoArgsConstructor |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Builder |
| | | @TableName("product_model") |
| | | public class ProductModel implements Serializable { |
| | | private static final long serialVersionUID = 1L; |
| | |
| | | package com.yuanchu.limslaboratory.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.yuanchu.limslaboratory.mapper.MaterialMapper; |
| | | import com.yuanchu.limslaboratory.mapper.ProductModelMapper; |
| | |
| | | //æ·»å æ å |
| | | @Override |
| | | public void addproductModel(ProductModelDto productModelDto) { |
| | | ProductModel productModel = new ProductModel(); |
| | | BeanUtils.copyProperties(productModelDto,productModel); |
| | | productModelMapper.insert(productModel); |
| | | if (ObjectUtils.isEmpty(productModelDto.getFather())) { |
| | | ProductModel productModel = ProductModel.builder() |
| | | .name(productModelDto.getName()) |
| | | .material(productModelDto.getMaterial()) |
| | | .unit(productModelDto.getUnit()) |
| | | .build(); |
| | | productModelMapper.insert(productModel); |
| | | } else { |
| | | ProductModel productModel = new ProductModel(); |
| | | BeanUtils.copyProperties(productModelDto, productModel); |
| | | productModelMapper.insert(productModel); |
| | | } |
| | | //æ·»å ç©æäº§ååº |
| | | Material material = new Material(); |
| | | material.setName(productModelDto.getName()).setCode(MyUtil.getTimeSixNumberCode("CP","CP")); |
| | | material.setName(productModelDto.getMaterial()).setCode(MyUtil.getTimeSixNumberCode("CP", "CP")); |
| | | materialMapper.insert(material); |
| | | } |
| | | |
| | | //æ¥è¯¢æ 忍¡çå表 |
| | | @Override |
| | | public List<Map<String, Object>> selectproductModel(String name, String father, String material) { |
| | | return productModelMapper.selectproductModel(name,father,material); |
| | | return productModelMapper.selectproductModel(name, father, material); |
| | | } |
| | | |
| | | //æ ¹æ®idæ¥è¯¢è¯¦æ
|
| | |
| | | public ProductModelDto selectproductModelById(Integer id) { |
| | | ProductModel productModel = productModelMapper.selectById(id); |
| | | ProductModelDto productModelDto = new ProductModelDto(); |
| | | BeanUtils.copyProperties(productModel,productModelDto); |
| | | BeanUtils.copyProperties(productModel, productModelDto); |
| | | return productModelDto; |
| | | } |
| | | |
| | |
| | | @Override |
| | | public void writeproductModel(Integer id, ProductModelDto productModelDto) { |
| | | ProductModel productModel = new ProductModel(); |
| | | BeanUtils.copyProperties(productModelDto,productModel); |
| | | BeanUtils.copyProperties(productModelDto, productModel); |
| | | productModel.setId(id); |
| | | productModelMapper.updateById(productModel); |
| | | } |
| | |
| | | and material_id = #{materialId} |
| | | </select> |
| | | |
| | | |
| | | <!--å±ç¤ºè¯¥åå·ä¸çæ£éªé¡¹ç®è¦æ±--> |
| | | <select id="pageProductInformation" resultType="java.util.Map"> |
| | | <resultMap id="pageProductInformationMap" type="map"> |
| | | <id property="father" column="father"/> |
| | | <collection property="children" resultMap="pageProductInformationTowMap" javaType="List"/> |
| | | </resultMap> |
| | | <resultMap id="pageProductInformationTowMap" type="map"> |
| | | <id property="id" column="id"/> |
| | | <result property="name" column="name"/> |
| | | <result property="unit" column="unit"/> |
| | | <result property="required" column="required"/> |
| | | <result property="internal" column="internal"/> |
| | | </resultMap> |
| | | |
| | | <select id="pageProductInformation" resultMap="pageProductInformationMap"> |
| | | select id, |
| | | name, |
| | | father, |
| | |
| | | package com.yuanchu.limslaboratory; |
| | | |
| | | import com.yuanchu.limslaboratory.pojo.vo.PlanVo; |
| | | import com.yuanchu.limslaboratory.service.PlanService; |
| | | import com.yuanchu.limslaboratory.service.UserService; |
| | | import com.yuanchu.limslaboratory.utils.MyUtil; |
| | |
| | | import org.apache.poi.hwpf.extractor.WordExtractor; |
| | | import org.apache.poi.xwpf.extractor.XWPFWordExtractor; |
| | | import org.apache.poi.xwpf.usermodel.XWPFDocument; |
| | | import org.apache.poi.xwpf.usermodel.XWPFParagraph; |
| | | import org.junit.jupiter.api.Test; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.boot.test.context.SpringBootTest; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.io.FileInputStream; |
| | | import java.io.FileNotFoundException; |
| | | import java.io.IOException; |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | | |
| | | @SpringBootTest |
| | | class SysApplicationTests { |
| | |
| | | |
| | | IPage<PagePersonnelVo> getNewPersonnelPage(String name, Page page); |
| | | |
| | | List<Map> selectUser(); |
| | | List<Map<String,Object>> selectUser(); |
| | | |
| | | |
| | | } |
| | |
| | | * æ¥è¯¢ææç¨æ·ä¿¡æ¯ |
| | | * @return |
| | | */ |
| | | List<Map> selectUser(); |
| | | List<Map<String,Object>> selectUser(); |
| | | |
| | | /** |
| | | * è·åææç¨æ·çåç§°ä¸Id |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<Map> selectUser() { |
| | | public List<Map<String,Object>> selectUser() { |
| | | return userMapper.selectUser(); |
| | | } |
| | | |