inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/HomeController.java
@@ -1,19 +1,18 @@ package com.yuanchu.limslaboratory.controller; import com.yuanchu.limslaboratory.pojo.ProjectNum; import com.yuanchu.limslaboratory.pojo.vo.ProjectNumVo; import com.yuanchu.limslaboratory.service.HomeService; 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.stereotype.Service; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; import java.util.List; import java.util.Map; /** * é¦é¡µ @@ -31,7 +30,14 @@ @ApiOperation("è®¡ç®æ£éªä¸æªæ£éªçååä¸é¡¹ç®çæ°éæ¥å£") @GetMapping("/checkProjectNum") public Result checkProjectNum() { ProjectNum projectNum=homeService.checkProjectNum(); return Result.success(projectNum); ProjectNumVo projectNumVo =homeService.checkProjectNum(); return Result.success(projectNumVo); } @ApiOperation("å·²æ£éªtop3") @GetMapping("/checktop3") public Result checktop3() { List<Map<String, Object>> checktop3s =homeService.checktop3(); return Result.success(checktop3s); } } inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java
@@ -4,6 +4,8 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.limslaboratory.pojo.Inspection; import java.util.List; import java.util.Map; /** @@ -28,5 +30,11 @@ //è®¡ç®æªæ£éªçæ°é Integer seleCountUnIns(); //è·åæ£éªåæ»æ° Integer getcount(); //è·åæ£éªç»è®º,æ£éªæ°é List<Map<String, Object>> getResultNum(); } inspection-server/src/main/java/com/yuanchu/limslaboratory/pojo/vo/ProjectNumVo.java
ÎļþÃû´Ó inspection-server/src/main/java/com/yuanchu/limslaboratory/pojo/ProjectNum.java ÐÞ¸Ä @@ -1,9 +1,9 @@ package com.yuanchu.limslaboratory.pojo; package com.yuanchu.limslaboratory.pojo.vo; import lombok.Data; @Data public class ProjectNum { public class ProjectNumVo { private int insNum; //å·²æ£éªçæ£éªåæ°é private int insUnNum; //æªæ£éªçæ£éªåæ°é inspection-server/src/main/java/com/yuanchu/limslaboratory/service/HomeService.java
@@ -1,6 +1,9 @@ package com.yuanchu.limslaboratory.service; import com.yuanchu.limslaboratory.pojo.ProjectNum; import com.yuanchu.limslaboratory.pojo.vo.ProjectNumVo; import java.util.List; import java.util.Map; public interface HomeService { @@ -8,6 +11,12 @@ * è®¡ç®æ£éªä¸æªæ£éªçååä¸é¡¹ç®çæ°éæ¥å£ * @return */ ProjectNum checkProjectNum(); ProjectNumVo checkProjectNum(); /** * å·²æ£éªtop3 * @return */ List<Map<String, Object>> checktop3(); } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/HomeServiceImpl.java
@@ -1,14 +1,15 @@ package com.yuanchu.limslaboratory.service.impl; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.yuanchu.limslaboratory.mapper.InspectionMapper; import com.yuanchu.limslaboratory.mapper.InspectionProductMapper; import com.yuanchu.limslaboratory.pojo.Inspection; import com.yuanchu.limslaboratory.pojo.ProjectNum; import com.yuanchu.limslaboratory.pojo.vo.ProjectNumVo; import com.yuanchu.limslaboratory.service.HomeService; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.math.BigDecimal; import java.util.List; import java.util.Map; @Service @@ -23,16 +24,43 @@ //è®¡ç®æ£éªä¸æªæ£éªçååä¸é¡¹ç®çæ°éæ¥å£ @Override public ProjectNum checkProjectNum() { ProjectNum projectNum = new ProjectNum(); public ProjectNumVo checkProjectNum() { ProjectNumVo projectNumVo = new ProjectNumVo(); //å·²æ£éªçæ£éªåæ°é projectNum.setInsNum(inspectionMapper.seleCountIns()); projectNumVo.setInsNum(inspectionMapper.seleCountIns()); //æªæ£éªçæ£éªåæ°é projectNum.setInsUnNum(inspectionMapper.seleCountUnIns()); projectNumVo.setInsUnNum(inspectionMapper.seleCountUnIns()); //å·²æ£éªçæ£éªé¡¹ç®æ°é projectNum.setInsproNum(inspectionProductMapper.seleCountInspro()); projectNumVo.setInsproNum(inspectionProductMapper.seleCountInspro()); //æªæ£éªçæ£éªé¡¹ç®æ°é projectNum.setInsproUnNum(inspectionProductMapper.seleCountUnInspro()); return projectNum; projectNumVo.setInsproUnNum(inspectionProductMapper.seleCountUnInspro()); return projectNumVo; } //å·²æ£éªtop3 @Override public List<Map<String, Object>> checktop3() { //è·åæ£éªåæ»æ° Integer allIns = inspectionMapper.getcount(); //æ£éªç»è®º,æ£éªæ°é List<Map<String, Object>> mapList = inspectionMapper.getResultNum(); for (Map<String, Object> map : mapList) { //éåè·åæ°é Long num = (Long) map.get("num"); //计ç®ç¾åæ¯å¹¶åå ¥mapä¸ map.put("chact",getRadio(allIns,num)); } return mapList; } /*计ç®ç¾åæ¯*/ private BigDecimal getRadio(Integer all, Long num) { if (all.intValue() == 0) { return new BigDecimal(0); } BigDecimal numBigDecimal = new BigDecimal(num); BigDecimal allBigDecimal = new BigDecimal(all); BigDecimal divide = numBigDecimal.divide(allBigDecimal, 4, BigDecimal.ROUND_HALF_UP); return divide.multiply(new BigDecimal(100)); } } inspection-server/src/main/resources/mapper/InspectionMapper.xml
@@ -42,4 +42,21 @@ where state = 1 and inspection_status is null </select> <!--è·åæ£éªåæ»æ°--> <select id="getcount" resultType="java.lang.Integer"> select count(id) from lims_laboratory.inspection where state = 1 </select> <!--æ£éªç»è®º,æ£éªæ°é--> <select id="getResultNum" resultType="java.util.Map"> select inspection_status result, count(id) num from lims_laboratory.inspection where state=1 group by result order by num desc </select> </mapper> standard-server/src/main/java/com/yuanchu/limslaboratory/controller/ProductModelController.java
@@ -33,11 +33,7 @@ @Autowired private ProductModelService productModelService; @ApiOperation(value = "éæ©æ ·ååç§°") @GetMapping("/selectmater") public Result selectmater() { return Result.success(productModelService.selectmater()); } @ApiOperation(value = "æ·»å æ å-->鿩项ç®åç»") @GetMapping("/selectfather") standard-server/src/main/java/com/yuanchu/limslaboratory/service/ProductModelService.java
@@ -17,11 +17,7 @@ */ public interface ProductModelService extends IService<ProductModel> { /** * éæ©æ ·ååç§° * @return */ List<String> selectmater(); /** * æ·»å æ å-->鿩项ç®åç» standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java
@@ -1,10 +1,9 @@ package com.yuanchu.limslaboratory.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.toolkit.IdWorker; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.yuanchu.limslaboratory.mapper.ProductModelMapper; import com.yuanchu.limslaboratory.pojo.Material; import com.yuanchu.limslaboratory.mapper.MaterialMapper; @@ -17,14 +16,11 @@ import com.yuanchu.limslaboratory.service.ProductService; import com.yuanchu.limslaboratory.service.SpecificationsService; import com.yuanchu.limslaboratory.service.StandardService; import com.yuanchu.limslaboratory.utils.MyUtil; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.stream.Collectors; @@ -106,8 +102,12 @@ List<Product> productList = productModel.stream().map(stringObjectMap -> { Product product = new Product(); product.setName(stringObjectMap.get("name").toString()); product.setFather(stringObjectMap.get("father").toString()); product.setUnit(stringObjectMap.get("unit").toString()); if (ObjectUtils.isNotEmpty(stringObjectMap.get("father"))) { product.setFather(stringObjectMap.get("father").toString()); } if (ObjectUtils.isNotEmpty(stringObjectMap.get("unit"))) { product.setUnit(stringObjectMap.get("unit").toString()); } product.setSpecifications_id(specifications.getId()); return product; }).collect(Collectors.toList()); standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductModelServiceImpl.java
@@ -28,11 +28,6 @@ @Resource ProductModelMapper productModelMapper; //éæ©æ ·å @Override public List<String> selectmater() { return productModelMapper.selectmater(); } //æ·»å æ å-->鿩项ç®åç» @Override standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/SpecificationsServiceImpl.java
@@ -2,6 +2,7 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.yuanchu.limslaboratory.mapper.ProductModelMapper; import com.yuanchu.limslaboratory.pojo.Product; import com.yuanchu.limslaboratory.pojo.Specifications; @@ -14,7 +15,6 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; import javax.annotation.Resource; import java.util.ArrayList; @@ -87,8 +87,12 @@ List<Product> productList = productModel.stream().map(stringObjectMap -> { Product product = new Product(); product.setName(stringObjectMap.get("name").toString()); product.setFather(stringObjectMap.get("father").toString()); product.setUnit(stringObjectMap.get("unit").toString()); if (ObjectUtils.isNotEmpty(stringObjectMap.get("father"))) { product.setFather(stringObjectMap.get("father").toString()); } if (ObjectUtils.isNotEmpty(stringObjectMap.get("unit"))) { product.setUnit(stringObjectMap.get("unit").toString()); } product.setSpecifications_id(specifications.getId()); return product; }).collect(Collectors.toList()); standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/StandardServiceImpl.java
@@ -107,8 +107,12 @@ List<Product> productList = productModel.stream().map(stringObjectMap -> { Product product = new Product(); product.setName(stringObjectMap.get("name").toString()); product.setFather(stringObjectMap.get("father").toString()); product.setUnit(stringObjectMap.get("unit").toString()); if (ObjectUtils.isNotEmpty(stringObjectMap.get("father"))) { product.setFather(stringObjectMap.get("father").toString()); } if (ObjectUtils.isNotEmpty(stringObjectMap.get("unit"))) { product.setUnit(stringObjectMap.get("unit").toString()); } product.setSpecifications_id(specifications.getId()); return product; }).collect(Collectors.toList());