tx-lims-after.git

			@@ -5,7 +5,7 @@
			import com.alibaba.excel.EasyExcel;
			import com.alibaba.excel.ExcelWriter;
			import com.alibaba.excel.write.metadata.WriteSheet;
			import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
			import com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy;
			import com.alibaba.fastjson.JSON;
			import com.baomidou.mybatisplus.core.metadata.IPage;
			import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
			@@ -29,20 +29,13 @@
			import org.springframework.stereotype.Service;
			import org.springframework.transaction.annotation.Transactional;

			import javax.servlet.ServletException;
			import javax.servlet.http.HttpServletResponse;
			import java.io.IOException;
			import java.net.URLEncoder;
			import java.time.LocalDate;
			import java.time.LocalDateTime;
			import java.time.format.DateTimeFormatter;
			import java.util.*;
			import java.util.concurrent.ConcurrentHashMap;
			import java.util.concurrent.atomic.AtomicInteger;
			import java.util.function.Function;
			import java.util.function.Predicate;
			import java.util.regex.Matcher;
			import java.util.regex.Pattern;
			import java.util.stream.Collectors;

			/**
			@@ -104,7 +97,7 @@
			}
			}
			//判断是否是全部权限
			Power power = powerMapper.selectOne(Wrappers.<Power>lambdaQuery().eq(Power::getRoleId, roleId).eq(Power::getMenuMethod, "selectAllInsOrder"));
			Power power = powerMapper.selectOne(Wrappers.<Power>lambdaQuery().eq(Power::getRoleId, roleId).eq(Power::getMenuMethod, "selectInsOrderParameter"));
			if (ObjectUtils.isEmpty(power)) {
			if (map1.get("look") == 1) {
			//个人
			@@ -130,9 +123,11 @@
			insOrder.setAppointed(LocalDate.parse(appointed));
			insOrder.setSendTime(LocalDateTime.now());
			insOrderMapper.updateById(insOrder);
			List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId));
			List<InsSample> insSamples =
			insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId));
			List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList());
			List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getState, 1).isNull(InsProduct::getInsFibersId).isNull(InsProduct::getInsFiberId).select(InsProduct::getSonLaboratory).groupBy(InsProduct::getSonLaboratory));
			List<InsProduct> insProducts =
			insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getState, 1).isNull(InsProduct::getInsFibersId).isNull(InsProduct::getInsFiberId).select(InsProduct::getSonLaboratory).groupBy(InsProduct::getSonLaboratory));
			for (InsProduct insProduct : insProducts) {
			InsOrderState insOrderState = new InsOrderState();
			insOrderState.setInsOrderId(orderId);
			@@ -159,8 +154,21 @@
			@Transactional(rollbackFor = Exception.class)
			public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing) {
			insOrder.setState(0);
			String code = customMapper.selectById(insOrder.getCompanyId()).getCode2();
			//insOrder.setEntrustCode(giveCode.giveCode("JCZX-" + code + "-", "ins_order", "", "yyMMdd"));
			//客户代号
			Custom custom = customMapper.selectById(insOrder.getCompanyId());
			String code = custom.getCode2();
			if (!custom.getCompany().equals(insOrder.getCompany())){
			Custom one = customMapper.selectOne(Wrappers.<Custom>lambdaQuery().eq(Custom::getCompany, insOrder.getCompany()));
			insOrder.setCompanyId(one.getId());
			code=one.getCode2();
			}
			//实验室编号
			String code2 = baseMapper.selLaboratoryCode(insOrder.getLaboratory());
			if (StringUtils.isEmpty(code2)) {
			code2 = "";
			}
			//外部委托编号
			insOrder.setOutEntrustCode(giveCode.giveCode3("ZT/" + code2 + "-" + code + "-", insOrder.getCompanyId(), insOrder.getLaboratory(), "ins_order", "", "yyMM"));
			String giveCode = this.giveCode.giveCode("JCZX-" + code + "-", "ins_sample", "", "yyMMdd");
			insOrderMapper.insert(insOrder);
			AtomicInteger count = new AtomicInteger();
			@@ -324,7 +332,7 @@
			throw new ErrorException("温度循环的要求描述格式异常,请参照温度范围：20℃，-40℃，65℃；保温时间：12h；循环次数：2次；光纤（1310nm，1550nm）附加衰减不大于0.03dB/km");
			}
			//拼接
			String s=null;
			String s="";
			for (int i = 0; i < nm.length; i++) {
			s+= "20℃(常温)," + nm[i] + ",null;";
			for (int j = 0; j < message.length; j++) {
			@@ -631,13 +639,25 @@
			// 这里URLEncoder.encode可以防止中文乱码当然和easyexcel没有关系
			String fileName = URLEncoder.encode("样品费用统计导出", "UTF-8");
			response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
			Map<String, List<CostStatisticsDto>> groupByCompany =
			costStatisticsDtos.stream().filter(e -> StrUtil.isNotEmpty(e.getCompany()))
			.collect(Collectors.groupingBy(CostStatisticsDto::getCompany));
			try {
			// 新建ExcelWriter
			ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build();

			WriteSheet mainSheet = EasyExcel.writerSheet("样品费用统计导出").head(CostStatisticsDto.class).build();
			excelWriter.write(costStatisticsDtos, mainSheet);

			// 新建ExcelWriter
			ExcelWriter excelWriter =
			EasyExcel.write(response.getOutputStream())
			.registerWriteHandler(new SimpleColumnWidthStyleStrategy(25))
			.build();
			for (Map.Entry<String, List<CostStatisticsDto>> companyDataEntry : groupByCompany.entrySet()) {
			String sheetName = companyDataEntry.getKey();
			List<CostStatisticsDto> dataList = companyDataEntry.getValue();
			WriteSheet mainSheet = EasyExcel.writerSheet(sheetName)
			.head(CostStatisticsDto.class)
			.registerWriteHandler(new SimpleColumnWidthStyleStrategy(25))
			.build();
			excelWriter.write(dataList, mainSheet);
			}
			// 关闭流
			excelWriter.finish();
			} catch (IOException e) {