package com.ltkj.web.controller.system;
|
|
import java.io.*;
|
import java.net.URL;
|
import java.nio.file.Files;
|
import java.nio.file.Paths;
|
import java.text.NumberFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletResponse;
|
|
import cn.hutool.core.date.DateUtil;
|
import cn.hutool.core.io.FileUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
|
import com.itextpdf.text.*;
|
import com.itextpdf.text.pdf.*;
|
import com.itextpdf.text.pdf.draw.LineSeparator;
|
import com.ltkj.common.core.domain.entity.SysDictData;
|
import com.ltkj.common.utils.DateUtils;
|
import com.ltkj.common.utils.PDFDocumentUtil;
|
import com.ltkj.common.utils.SecurityUtils;
|
import com.ltkj.common.utils.StringUtils;
|
import com.ltkj.db.DataSourceContextHolder;
|
import com.ltkj.framework.config.MatchUtils;
|
import com.ltkj.hosp.domain.*;
|
import com.ltkj.hosp.service.*;
|
import com.ltkj.mall.mallOrderUtils.TjConstants;
|
import com.ltkj.system.service.ISysConfigService;
|
import com.ltkj.system.service.ISysDictDataService;
|
import com.ltkj.system.service.ISysUserService;
|
import com.ltkj.web.config.pdfutils.MergePdf;
|
import com.ltkj.web.config.pdfutils.PDFBinaryUtil;
|
import com.ltkj.web.config.pdfutils.PdfUtils;
|
import com.ltkj.web.controller.his.HisPDFUtil;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import jodd.util.StringUtil;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.transaction.annotation.Propagation;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.transaction.interceptor.TransactionAspectSupport;
|
import org.springframework.web.bind.annotation.*;
|
import com.ltkj.common.core.controller.BaseController;
|
import com.ltkj.common.core.domain.AjaxResult;
|
|
import static com.ltkj.web.config.pdfutils.PDFBinaryUtil.getPDFBinary;
|
|
/**
|
* 体检报告存储Controller
|
*
|
* @author ltkj
|
* @date 2022-12-06
|
*/
|
@Slf4j
|
@RestController
|
@RequestMapping("/system/report")
|
@Api(tags = "AAAA_体检报告")
|
@Transactional
|
public class TjReportController extends BaseController {
|
@Resource
|
private ITjReportService tjReportService;
|
@Resource
|
private ITjCustomerService tjCustomerService;
|
@Autowired
|
private ITjOrderService tjOrderService;
|
@Autowired
|
private ITjOrderDetailService tjOrderDetailService;
|
@Resource
|
private ITjProjectService projectService;
|
@Resource
|
private ITjOrderRemarkService tjOrderRemarkService;
|
@Resource
|
private ITjStandardService tjStandardService;
|
@Resource
|
private IDictCompService dictCompService;
|
@Resource
|
private ITjReportTemplateService reportTemplateService;
|
@Value("${path.filePath}")
|
private String value;
|
@Value("${path.reportServer}")
|
private String urlValue;
|
@Resource
|
private ISysUserService userService;
|
@Resource
|
private ITjOrderDetailRulesService detailRulesService;
|
@Resource
|
private ITjRulesService rulesService;
|
@Autowired
|
private ISysConfigService configService;
|
|
@Autowired
|
private ISysDictDataService dictDataService;
|
@Resource
|
private ITbTransitionService transitionService;
|
@Autowired
|
private ITjBigPositiveService tjBigPositiveService;
|
@Autowired
|
private HisPDFUtil hisPDFUtil;
|
@Autowired
|
private IDictHospService dictHospService;
|
@Autowired
|
private ITjReportPrintService printService;
|
@Autowired
|
private TjOrderYcxmService ycxmService;
|
|
@GetMapping("/savePdf")
|
@ApiOperation(value = "从本地存储模板到数据库")
|
public AjaxResult savePdf() {
|
//从文件地址读入PDF文件 仅存储一次
|
String base64String = PDFBinaryUtil.getPDFBinary(configService.selectConfigByKey("default_pdf5Template"));
|
if(StringUtil.isNotBlank(base64String)){
|
reportTemplateService.remove(new LambdaQueryWrapper<TjReportTemplate>().eq(TjReportTemplate::getName,"体检报告模板5"));
|
TjReportTemplate tem = new TjReportTemplate();
|
tem.setName("体检报告模板5");
|
tem.setRemark("体检报告模板5");
|
tem.setTemplate(base64String);
|
tem.setFlag("1");
|
tem.setOpen("0");
|
tem.setCreateTime(DateUtil.date());
|
final boolean save = reportTemplateService.save(tem);
|
if (save) {
|
return AjaxResult.success("保存成功");
|
}
|
}
|
|
return AjaxResult.success("保存失败");
|
// String base64String2 = PDFBinaryUtil.getPDFBinary("D:\\Tjreport\\心电图1.pdf");
|
// TjReport tem2 = new TjReport();
|
// tem2.setTjNumber(tjNumber);
|
// tem2.setReport(base64String2);
|
// tem2.setType("心电图");
|
// tjReportService.save(tem2);
|
//
|
// String base64String1 = PDFBinaryUtil.getPDFBinary("D:\\Tjreport\\附件2.pdf");
|
// TjReport tem1 = new TjReport();
|
// tem1.setTjNumber(tjNumber);
|
// tem1.setReport(base64String1);
|
// tem1.setType("附件");
|
// tjReportService.save(tem1);
|
|
}
|
|
|
// /* *//**
|
// * 查询体检报告存储列表
|
// *//*
|
// @PreAuthorize("@ss.hasPermi('system:report:list')")
|
// @GetMapping("/list")
|
// public TableDataInfo list(TjReport tjReport) {
|
// startPage();
|
// List<TjReport> list = tjReportService.selectTjReportList(tjReport);
|
// return getDataTable(list);
|
// }
|
//
|
// *//**
|
// * 导出体检报告存储列表
|
// *//*
|
// @PreAuthorize("@ss.hasPermi('system:report:export')")
|
// @Log(title = "体检报告存储", businessType = BusinessType.EXPORT)
|
// @PostMapping("/export")
|
// public void export(HttpServletResponse response, TjReport tjReport) {
|
// List<TjReport> list = tjReportService.selectTjReportList(tjReport);
|
// ExcelUtil<TjReport> util = new ExcelUtil<TjReport>(TjReport.class);
|
// util.exportExcel(response, list, "体检报告存储数据");
|
// }
|
//
|
// *//**
|
// * 获取体检报告存储详细信息
|
// *//*
|
// @PreAuthorize("@ss.hasPermi('system:report:query')")
|
// @GetMapping(value = "/{reId}")
|
// public AjaxResult getInfo(@PathVariable("reId") Long reId) {
|
// return success(tjReportService.selectTjReportByReId(reId));
|
// }
|
//
|
// *//**
|
// * 存储体检报告
|
// *//*
|
// @PostMapping
|
// @ApiOperation(value = "生成体检报告给总检审核")
|
// public AjaxResult addReport(@RequestParam @ApiParam(value = "体检号") String tjNumber) {
|
// ReportVO report = new ReportVO();
|
// LambdaQueryWrapper<TjOrder> wq = new LambdaQueryWrapper<>();
|
// wq.eq(TjOrder::getTjNumber, tjNumber);
|
// TjOrder tjOrder = tjOrderService.getOne(wq);
|
// Integer checkStatus = tjOrder.getCheckStatus();
|
// if (checkStatus == 0) {
|
// report.setTjOrder(tjOrder);
|
// LambdaQueryWrapper<TjCustomer> wq1 = new LambdaQueryWrapper<>();
|
// wq1.eq(TjCustomer::getCusId, tjOrder.getUserId());
|
// report.setTjCustomer(tjCustomerService.getOne(wq1));
|
// LambdaQueryWrapper<TjOrderDetail> wq2 = new LambdaQueryWrapper<>();
|
// wq2.eq(TjOrderDetail::getOrderId, tjOrder.getOrderId());
|
// List<TjOrderDetail> list = tjOrderDetailService.list(wq2);
|
// for (TjOrderDetail tjOrderDetail : list) {
|
// TjProject tjProject = projectService.selectTjProjectByProId(tjOrderDetail.getProId());
|
// tjOrderDetail.setProject(tjProject);
|
//
|
// }
|
// LambdaQueryWrapper<TjOrderRemark> wq5 = new LambdaQueryWrapper<>();
|
// wq5.eq(TjOrderRemark::getTjNumber, tjOrder.getTjNumber());
|
// List<TjOrderRemark> list1 = tjOrderRemarkService.list(wq5);
|
// for (TjOrderRemark tjOrderRemark : list1) {
|
// LambdaQueryWrapper<TjProject> wq3 = new LambdaQueryWrapper<>();
|
// wq3.eq(TjProject::getProParentId, tjOrderRemark.getProId());
|
// List<TjProject> list3 = projectService.list(wq3);
|
// List<Long> collect = list3.stream().map(TjProject::getProId).collect(Collectors.toList());
|
// LambdaQueryWrapper<TjOrderDetail> wq4 = new LambdaQueryWrapper<>();
|
// wq4.eq(TjOrderDetail::getOrderId, tjOrder.getOrderId());
|
// wq4.in(TjOrderDetail::getProId, collect);
|
// List<TjOrderDetail> list6 = tjOrderDetailService.list(wq4);
|
// for (TjOrderDetail tjOrderDetail : list6) {
|
// TjProject tjProject = projectService.selectTjProjectByProId(tjOrderDetail.getProId());
|
// tjOrderDetail.setProject(tjProject);
|
// LambdaQueryWrapper<TjAdvice> wq7 = new LambdaQueryWrapper<>();
|
// wq7.eq(TjAdvice::getProId, tjOrderDetail.getProId());
|
// List<TjAdvice> list4 = tjAdviceService.list(wq7);
|
// tjOrderDetail.setAdviceList(list4);
|
// LambdaQueryWrapper<TjStandard> wq6 = new LambdaQueryWrapper<>();
|
// wq6.eq(TjStandard::getProId, tjOrderDetail.getProId());
|
// List<TjStandard> list2 = tjStandardService.list(wq6);
|
// if (list2.size() == 0) {
|
// tjOrderDetail.setStandard(null);
|
// } else if (list2.size() == 1) {
|
// tjOrderDetail.setStandard(list2.get(0));
|
// } else {
|
// Long cusSex = tjCustomerService.getOne(wq1).getCusSex();
|
// Date cusBrithday = tjCustomerService.getOne(wq1).getCusBrithday();
|
// int age = DateUtil.ageOfNow(cusBrithday);
|
// for (TjStandard tjStandard : list2) {
|
// LambdaQueryWrapper<TjStandard> wq8 = new LambdaQueryWrapper<>();
|
// if (tjStandard.getTjSex() != null) {
|
// wq8.eq(TjStandard::getTjSex, cusSex);
|
// }
|
// if (tjStandard.getTjType() != null) {
|
// wq8.eq(TjStandard::getTjType, StringUtils.getAgeType(age));
|
// }
|
// TjStandard one = tjStandardService.getOne(wq8);
|
// tjOrderDetail.setStandard(one);
|
// }
|
// }
|
// }
|
// tjOrderRemark.setTjOrderDetailList(list6);
|
//
|
// }
|
// report.setTjOrderRemark(list1);
|
// } else {
|
// return AjaxResult.success("该报告已审核！");
|
// }
|
// return AjaxResult.success(report);
|
// }
|
//
|
//
|
// *//**
|
// * 修改体检报告存储
|
// *//*
|
// @PreAuthorize("@ss.hasPermi('system:report:edit')")
|
// @Log(title = "体检报告存储", businessType = BusinessType.UPDATE)
|
// @PutMapping
|
// public AjaxResult edit(@RequestBody TjReport tjReport) {
|
// return toAjax(tjReportService.updateTjReport(tjReport));
|
// }
|
//
|
// *//**
|
// * 删除体检报告存储
|
// *//*
|
// @PreAuthorize("@ss.hasPermi('system:report:remove')")
|
// @Log(title = "体检报告存储", businessType = BusinessType.DELETE)
|
// @DeleteMapping("/{reIds}")
|
// public AjaxResult remove(@PathVariable Long[] reIds) {
|
// return toAjax(tjReportService.deleteTjReportByReIds(reIds));
|
// }*/
|
|
@Autowired
|
private TjCheckController tjCheckController;
|
|
@GetMapping("/toPdf/{TjNumber}")
|
@ApiOperation(value = "打印体检报告为pdf")
|
@Transactional
|
public AjaxResult toPdf(@PathVariable("TjNumber") @ApiParam(value = "体检号") String tjNumber) {
|
// AjaxResult error = null;
|
// 之前的代码 优化速度
|
// System.out.println("----------------------------------oldFun开始-------------------------------------------------------");
|
// error = oldFun(tjNumber);
|
// System.out.println("--------------------------------------结束---------------------------------------------------");
|
// 撤销操作
|
// revocationReport(tjNumber);
|
// 根据某人tj号以及ProId进行打印前的请求
|
// tjCheckController.getTjdetailList(tjNumber,null,1);
|
// List<UpdateOrderRemarkVo> updateOrderRemarkVos = new ArrayList<>();
|
// UpdateOrderRemarkVo remarkVo = new UpdateOrderRemarkVo();
|
// remarkVo.setRemarks("未见异常");
|
// remarkVo.setTjNumber("02132240308102232");
|
// remarkVo.setProId("1633660948860522555");
|
// updateOrderRemarkVos.add(remarkVo);
|
// tjCheckController.checkUpdateOrderRemark(updateOrderRemarkVos);
|
// System.out.println("---------------------------------------newFun开始--------------------------------------------------");
|
// 以前测试pdf方法
|
// error = newFun(tjNumber);
|
// System.out.println("-------------------------------------------结束----------------------------------------------");
|
// 撤销
|
// revocationReport(tjNumber);
|
// if (error != null) {
|
// return error;
|
// }
|
// return AjaxResult.success("该用户体检未完成，不能打印报告！！！");
|
|
TjOrder tjOrder = tjOrderService.getOrderByTjNum(tjNumber);
|
if (null != tjOrder) {
|
String config = configService.selectConfigByKey("sfjcwjhyqxm");
|
if(null != config && config.equalsIgnoreCase("Y")){
|
int num = tjOrderRemarkService.getTjYqOrderRemarkByTjNum(tjNumber);
|
if (num > 0) {
|
tjOrder.setReportTime(null);
|
tjOrder.setCheckTime(null);
|
tjOrder.setCheckStatus(0);
|
tjOrder.setPrintLastTime(null);
|
tjOrderService.updateById(tjOrder);
|
return AjaxResult.error("存在未检或延期项目暂不能生成报告!!!");
|
}
|
}
|
//判断表中有没有该体检报告 不能重复生成
|
LambdaQueryWrapper<TjReport> wqa = new LambdaQueryWrapper<>();
|
wqa.eq(TjReport::getTjNumber, tjNumber);
|
wqa.eq(TjReport::getType, "体检报告");
|
Integer count = tjReportService.getSelectCount(wqa);
|
if (tjOrder.getReportTime() !=null || count != 0 ) {
|
// tjOrder.setReportTime(null);
|
// tjOrder.setCheckTime(null);
|
// tjOrder.setCheckStatus(0);
|
// tjOrder.setPrintLastTime(null);
|
// tjOrderService.updateById(tjOrder);
|
return AjaxResult.error("该客户报告已生成！不能重复生成！可直接预览或打印！");
|
}
|
|
LambdaQueryWrapper<TjReportTemplate> tjReportTemplateLambdaQueryWrapper = new LambdaQueryWrapper<>();
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
|
TjReportTemplate reportTemplate = reportTemplateService.getOne(tjReportTemplateLambdaQueryWrapper);
|
// if (tjOrder.getTjCategory() != null) {
|
// //查询字典
|
// LambdaQueryWrapper<SysDictData> wqq = new LambdaQueryWrapper<>();
|
// wqq.eq(SysDictData::getDictType, "dict_tjtype");
|
// wqq.eq(SysDictData::getDictValue, tjOrder.getTjCategory());
|
// SysDictData one = dictDataService.getOne(wqq);
|
// if (one != null) {
|
// //查询字典
|
// LambdaQueryWrapper<SysDictData> wqq1 = new LambdaQueryWrapper<>();
|
// wqq1.eq(SysDictData::getDictType, "report_template_type");
|
// wqq1.eq(SysDictData::getDictLabel, one.getDictLabel());
|
// SysDictData one1 = dictDataService.getOne(wqq1);
|
// if (one1 != null) {
|
// tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, one1.getDictValue());
|
// } else {
|
// tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
|
// }
|
// } else {
|
// tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
|
// }
|
// tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
|
// reportTemplate = reportTemplateService.getOne(tjReportTemplateLambdaQueryWrapper);
|
// } else {
|
// tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
|
// reportTemplate = reportTemplateService.list(tjReportTemplateLambdaQueryWrapper).get(2);
|
// }
|
Integer checkStatus = tjOrder.getCheckStatus();
|
if (checkStatus == 1) {
|
if ("报表".equals(reportTemplate.getPrint())) {
|
TjReport tjReport = new TjReport();
|
tjReport.setTjNumber(String.valueOf(tjNumber));
|
tjReport.setPath(reportTemplate.getUrl() + "?tjNum=" + tjNumber);
|
tjReport.setType("体检报告");
|
tjReport.setPrint("报表");
|
tjReportService.save(tjReport);
|
//修改order表中的打印报告时间为当前时间
|
LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
|
updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
|
updateWrapper.set(TjOrder::getReportTime, new Date());
|
// updateWrapper.set(TjOrder::getPrintLastTime, new Date());
|
// updateWrapper.set(TjOrder::getDownloadLastTime, new Date());
|
updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
|
tjOrderService.update(updateWrapper);
|
return AjaxResult.success("已生成报告！可直接点击预览！");
|
}
|
// String hisRegistrationId = tjOrder.getCardId();
|
// Date createTime = tjOrder.getCreateTime();
|
// SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// String ksrq = dateFormat.format(createTime);
|
// String jsrq = dateFormat.format(new Date());
|
// HashMap<String, Object> params = new HashMap<>();
|
// params.put("his_registration_id", hisRegistrationId);
|
// params.put("ksbm", "");
|
// params.put("pationid", "");
|
// params.put("ksrq", ksrq);
|
// params.put("jsrq", jsrq);
|
// params.put("pagecount", 100);
|
// params.put("page", 1);
|
LambdaQueryWrapper<TjCustomer> wq1 = new LambdaQueryWrapper<>();
|
wq1.eq(TjCustomer::getCusId, tjOrder.getUserId());
|
TjCustomer tjCustomer = tjCustomerService.getOne(wq1);
|
LambdaQueryWrapper<TjReportTemplate> wrapper = new LambdaQueryWrapper<>();
|
wrapper.eq(TjReportTemplate::getFlag,"4");
|
wrapper.eq(TjReportTemplate::getOpen,"1");
|
TjReportTemplate zongJianYiShiQianMing = reportTemplateService.getOne(wrapper);
|
try {
|
return shengchengbgmoban(tjNumber, tjOrder, tjCustomer, reportTemplate,zongJianYiShiQianMing);
|
} catch (Exception e) {
|
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
|
log.error(String.valueOf(e));
|
tjOrder.setReportTime(null);
|
tjOrder.setCheckTime(null);
|
tjOrder.setCheckStatus(0);
|
tjOrder.setPrintLastTime(null);
|
tjOrderService.updateById(tjOrder);
|
|
logger.error(String.valueOf(e));
|
return AjaxResult.error("生成报告失败");
|
}
|
} else {
|
return AjaxResult.error("请先总检");
|
}
|
}
|
return AjaxResult.error();
|
}
|
|
public AjaxResult shengchengbgmoban(String tjNumber, TjOrder tjOrder, TjCustomer tjCustomer, TjReportTemplate reportTemplate,TjReportTemplate zongJianYiShiQianMing) {
|
AjaxResult ajaxResult = null;
|
try {
|
// ajaxResult = hisPDFUtil.hisPDF(tjOrder, tjCustomer, reportTemplate);
|
// ajaxResult = hisPDFUtil.hisPDFNew(tjOrder, tjCustomer, reportTemplate);
|
|
ajaxResult = hisPDFUtil.hisPDFNew2(tjOrder, tjCustomer, reportTemplate,zongJianYiShiQianMing);
|
} catch (Exception e) {
|
e.printStackTrace();
|
log.error(String.valueOf(e));
|
}
|
if (!ajaxResult.get("code").toString().equals("200")) {
|
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
|
} else {
|
Long userId = tjCustomer.getCusId();
|
String outputFileName1 = userId + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
|
TjReport tjReport = new TjReport();
|
tjReport.setTjNumber(String.valueOf(tjNumber));
|
tjReport.setPath(urlValue + outputFileName1);
|
String outputPath1 = value + File.separator;
|
String pdfBinary = getPDFBinary(outputPath1 + outputFileName1);
|
tjReport.setReport(pdfBinary);
|
tjReport.setType("体检报告");
|
tjReport.setPrint("pdf");
|
tjReportService.save(tjReport);
|
Date date = new Date();
|
// LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
|
// updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
|
// updateWrapper.set(TjOrder::getReportTime, date);
|
// updateWrapper.set(TjOrder::getPrintLastTime, date);
|
// updateWrapper.set(TjOrder::getDownloadLastTime,date);
|
// updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
|
tjOrder.setStatus(TjConstants.TJ_END);
|
tjOrder.setReportTime(date);
|
// tjOrder.setPrintLastTime(date);
|
// tjOrder.setDownloadLastTime(date);
|
tjOrderService.updateById(tjOrder);
|
}
|
return ajaxResult;
|
}
|
|
|
/**
|
* 撤销
|
* @param tjNumber
|
*/
|
@Transactional(propagation = Propagation.REQUIRES_NEW)
|
public void backOnlyCheckType(String tjNumber) {
|
QueryWrapper<TjOrder> wq2 = new QueryWrapper<>();
|
wq2.eq("tj_number", tjNumber);
|
TjOrder one = tjOrderService.getOne(wq2);
|
one.setCheckStatus(0);
|
String config = configService.selectConfigByKey("tj_confirm");
|
if ("Y".equals(config)) {
|
one.setStatus(TjConstants.TJ_CHECK);
|
} else {
|
one.setStatus(TjConstants.TJ_CONFIRM);
|
}
|
//将状态改为未审核
|
tjOrderService.updateById(one);
|
}
|
|
private void setUserInfo(String tjNumber, TjOrder tjOrder, TjCustomer tjCustomer, DictComp dictComp, List<TjOrderDetail> list, Map<String, Object> data) {
|
//填充性别：判断男女
|
Long cusSex = tjCustomer.getCusSex();
|
String sex;
|
String name1;
|
String tjtype;
|
if (cusSex == 0) {
|
sex = "男";
|
name1 = tjCustomer.getCusName() + "先生";
|
} else {
|
sex = "女";
|
name1 = tjCustomer.getCusName() + "女士";
|
}
|
data.put("name", tjCustomer.getCusName());
|
data.put("cusId", tjCustomer.getCusId());
|
data.put("name1", name1);
|
if ("1".equals(tjOrder.getTjType())) {
|
tjtype = "团队";
|
data.put("tjtype", tjtype);
|
} else {
|
tjtype = "个人";
|
data.put("tjtype", tjtype);
|
}
|
data.put("dstype", "统一");
|
data.put("sex", sex);
|
data.put("age", DateUtil.ageOfNow(tjCustomer.getCusBrithday()));
|
data.put("tjnumber", tjNumber);
|
data.put("tjdate", DateUtils.parseDateToStr("yyyy/MM/dd", tjOrder.getCreateTime()));
|
data.put("phone", tjCustomer.getCusPhone());
|
data.put("idcard", MatchUtils.hideIdCardNum(tjCustomer.getCusIdcard()));
|
data.put("num1", list.size());
|
data.put("num2", 0);
|
data.put("num3", 4);
|
if (dictComp == null) {
|
data.put("work", "无");
|
} else {
|
data.put("work", dictComp.getCnName());
|
}
|
}
|
|
/**
|
* 根据base64的PDF文件添加一页
|
*
|
* @param copy pdf复制对象
|
* @param base64XinDianTu base64 pdf文件
|
* @throws IOException
|
* @throws BadPdfFormatException
|
*/
|
private void addPageByPDFBase64(PdfCopy copy, String base64XinDianTu) throws IOException, BadPdfFormatException {
|
byte[] pdfBytes = Base64.getDecoder().decode(base64XinDianTu);
|
PdfReader pdfReader = new PdfReader(pdfBytes);
|
int number = pdfReader.getNumberOfPages();
|
for (int i = 1; i <= number; i++) {
|
PdfImportedPage importedPage = copy.getImportedPage(pdfReader, i);
|
copy.addPage(importedPage);
|
}
|
}
|
|
|
private ByteArrayOutputStream setInfoPage(String userId, String tjNumber) throws IOException, DocumentException {
|
ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
|
//文档对象 实现A4纸页面
|
Document document = new Document(PageSize.A4);
|
PdfWriter pdfWriter = PdfWriter.getInstance(document, byteArrayOutputStream);
|
//document.setMarginMirroring(true);
|
//设置文档的页边距就是距离页面边上的距离，分别为：左边距，右边距，上边距，下边距
|
document.setMargins(70, 70, 40, 40);
|
//pdfWriter.setPageEvent(new MyHeaderFooter());// 页眉页脚
|
document.open();
|
document.add(new Header("健康体检结果", "健康体检结果"));
|
Map<TjOrderRemark, List<TjPdfVO>> tjOrderRemarkObjectMap = addTable(tjNumber);
|
Map<TjOrderRemark, List<TjPdfVO>> tjOrderRemarkListMap = addHuaYanTable(tjNumber);
|
tjOrderRemarkObjectMap.putAll(tjOrderRemarkListMap);
|
for (Map.Entry<TjOrderRemark, List<TjPdfVO>> entry : tjOrderRemarkObjectMap.entrySet()) {
|
List<TjPdfVO> value = entry.getValue();
|
LambdaQueryWrapper<TjProject> wqqq = new LambdaQueryWrapper<>();
|
wqqq.eq(TjProject::getProId, entry.getKey().getProId());
|
TjProject one11 = projectService.getOne(wqqq);
|
//判断该项目是否需要打印报告
|
if (null != one11 && "N".equals(one11.getNeedReport())) {
|
continue;
|
}
|
String titleName = null;
|
if (null != one11 && "1".equals(one11.getResultType())) {
|
titleName = one11.getProName();
|
// 设置标题字体样式
|
Font titleFonts = PdfUtils.setFont(9);
|
Paragraph paragraph = PdfUtils.setParagraph(titleFonts, titleName);
|
String[] titles = {"体检项目", "体检结果"};
|
// 获取列表数据
|
//设置表头字体样式
|
Font headFont = PdfUtils.setFont(9);
|
// 设置正文字体样式：12号
|
Font textFont = PdfUtils.setFont(9);
|
//创建表格 将表头字体和正文字体放进去
|
PdfPTable table = PdfUtils.setTable1(headFont, textFont, titles, value);
|
document.add(paragraph);
|
document.add(table);
|
//判断备注是否为空 空不能显示null
|
if (entry.getKey().getRemark() == null) {
|
entry.getKey().setRemark("");
|
}
|
String remark = "备注：" + entry.getKey().getRemark();
|
if (entry.getKey().getRemark().length() > 50) {
|
int j = 0;
|
for (int i = 0; i < remark.length() / 50; i++) {
|
String substring = remark.substring(j, j + 50);
|
Font remarkFonts = PdfUtils.setFont(9);
|
Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
|
document.add(pp);
|
j = j + 50;
|
}
|
if (remark.length() % 50 != 0) {
|
String substring = remark.substring((remark.length() / 50) * 50, remark.length() - 1);
|
Font remarkFonts = PdfUtils.setFont(9);
|
Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
|
document.add(pp);
|
}
|
} else {
|
Font remarkFonts = PdfUtils.setFont(9);
|
Paragraph pp = PdfUtils.setParagraph(remarkFonts, remark);
|
document.add(pp);
|
}
|
//判断主检医师是否为空 空不能显示null
|
if (null != entry.getKey().getDoctorName() && null != userService.getById(entry.getKey().getDoctorName())) {
|
//主检医师
|
String doctorName = "主检医师：" + userService.getById(entry.getKey().getDoctorName()).getNickName();
|
Font doctorFonts = PdfUtils.setFont(9);
|
Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
|
df.setAlignment(Element.ALIGN_RIGHT);
|
document.add(df);
|
} else {
|
String doctorName = "主检医师：" + "无";
|
Font doctorFonts = PdfUtils.setFont(9);
|
Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
|
df.setAlignment(Element.ALIGN_RIGHT);
|
document.add(df);
|
|
}
|
//分割线
|
LineSeparator objectName = new LineSeparator();
|
document.add(objectName);
|
} else {
|
if (null != one11) {
|
titleName = one11.getProName();
|
} else {
|
titleName = entry.getKey().getProName();
|
}
|
// 设置标题字体样式
|
Font titleFonts = PdfUtils.setFont(9);
|
Paragraph paragraph = PdfUtils.setParagraph(titleFonts, titleName);
|
String[] titles = {"体检项目", "体检结果", "单位", "参考范围"};
|
// 获取列表数据
|
//设置表头字体样式
|
Font headFont = PdfUtils.setFont(9);
|
// 设置正文字体样式：12号
|
Font textFont = PdfUtils.setFont(9);
|
//创建表格 将表头字体和正文字体放进去
|
DictHosp dictHosp = dictHospService.list().get(0);
|
PdfPTable table = PdfUtils.setTable(headFont, textFont, titles, value,dictHosp.equals("澄合矿务局中心医院"));
|
document.add(paragraph);
|
document.add(table);
|
//判断备注是否为空 空不能显示null
|
if (entry.getKey().getRemark() == null) {
|
entry.getKey().setRemark("");
|
}
|
String remark = "备注：" + entry.getKey().getRemark();
|
if (entry.getKey().getRemark().length() > 50) {
|
int j = 0;
|
for (int i = 0; i < remark.length() / 50; i++) {
|
String substring = remark.substring(j, j + 50);
|
Font remarkFonts = PdfUtils.setFont(9);
|
Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
|
document.add(pp);
|
j = j + 50;
|
}
|
if (remark.length() % 50 != 0) {
|
String substring = remark.substring((remark.length() / 50) * 50, remark.length() - 1);
|
Font remarkFonts = PdfUtils.setFont(9);
|
Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
|
document.add(pp);
|
}
|
} else {
|
Font remarkFonts = PdfUtils.setFont(9);
|
Paragraph pp = PdfUtils.setParagraph(remarkFonts, remark);
|
document.add(pp);
|
}
|
//判断主检医师是否为空 空不能显示null
|
if (null != entry.getKey().getDoctorName() && null != userService.getById(entry.getKey().getDoctorName())) {
|
//主检医师
|
String doctorName = "主检医师：" + userService.getById(entry.getKey().getDoctorName()).getNickName();
|
Font doctorFonts = PdfUtils.setFont(9);
|
Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
|
df.setAlignment(Element.ALIGN_RIGHT);
|
document.add(df);
|
} else {
|
String doctorName = "主检医师：" + "无";
|
Font doctorFonts = PdfUtils.setFont(9);
|
Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
|
df.setAlignment(Element.ALIGN_RIGHT);
|
document.add(df);
|
}
|
//分割线
|
LineSeparator objectName = new LineSeparator();
|
document.add(objectName);
|
}
|
}
|
document.close();
|
pdfWriter.close();
|
return byteArrayOutputStream;
|
}
|
|
|
//非化验项目报告
|
public Map<TjOrderRemark, List<TjPdfVO>> addTable(String tjNumber) {
|
//创建map 键为父项目 值为子项目集合
|
// 不使用linked
|
Map<TjOrderRemark, List<TjPdfVO>> printReport = new HashMap<>();
|
//查到该客户的体检记录
|
LambdaQueryWrapper<TjOrder> wq1 = new LambdaQueryWrapper<>();
|
wq1.eq(TjOrder::getTjNumber, tjNumber);
|
TjOrder one = tjOrderService.getOne(wq1);
|
/*
|
//拿到体检记录的orderid，查出项目详细信息
|
LambdaQueryWrapper<TjOrderDetail> wq = new LambdaQueryWrapper<>();
|
wq.eq(TjOrderDetail::getOrderId, one.getOrderId());
|
//20230323判断项目已检
|
wq.ne(TjOrderDetail::getTjStatus, 0);
|
wq.ne(TjOrderDetail::getProId,projectService.getHuaYanProId());
|
wq.eq(TjOrderDetail::getProId,projectService.getNotCcCtXdtProId());
|
// wq.notIn(TjOrderDetail::getProId,projectService.getNneedReprotProId());
|
List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.list(wq);
|
|
//遍历体检记录 将项目的具体信息
|
//遍历客户所选的项目(包含子项父项)
|
for (TjOrderDetail tjOrderDetail : tjOrderDetails) {
|
TjProject tjProject = projectService.getById(tjOrderDetail.getProId());
|
if (null != tjProject) {
|
tjOrderDetail.setProject(tjProject);
|
}
|
}
|
*/
|
|
LambdaQueryWrapper<TjCustomer> wq22 = new LambdaQueryWrapper<>();
|
wq22.eq(TjCustomer::getCusId, one.getUserId());
|
TjCustomer customer = tjCustomerService.getOne(wq22);
|
LambdaQueryWrapper<TjOrderRemark> wqq = new LambdaQueryWrapper<>();
|
wqq.eq(TjOrderRemark::getTjNumber, tjNumber);
|
wqq.ne(TjOrderRemark::getDeptId, "241");
|
wqq.in(TjOrderRemark::getDeptId, "269", "270", "253", "254", "255", "257", "251", "271");
|
wqq.notIn(TjOrderRemark::getProId, projectService.getNneedReprotProId());
|
List<TjOrderRemark> tjOrderRemarks = tjOrderRemarkService.list(wqq);
|
|
for (TjOrderRemark tjOrderRemark : tjOrderRemarks) {
|
printReport.put(tjOrderRemark, null);
|
}
|
// extracted(printReport, one, customer);
|
extractedNew(printReport, one, customer);
|
return printReport;
|
}
|
|
|
//化验项目报告
|
public Map<TjOrderRemark, List<TjPdfVO>> addHuaYanTable(String tjNumber) {
|
//创建map 键为父项目 值为子项目集合
|
Map<TjOrderRemark, List<TjPdfVO>> printReport = new LinkedHashMap<>();
|
//查到该客户的体检记录
|
|
//拿到体检记录的orderid，查出项目详细信息
|
|
List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.addHuaYanAndCgTable(tjNumber);
|
|
List<TjOrderRemark> tjOrderRemarks = tjOrderRemarkService.addHuaYanAndCgTable(tjNumber);
|
for (TjOrderRemark tjOrderRemark : tjOrderRemarks) {
|
printReport.put(tjOrderRemark, null);
|
}
|
List<Object> toRemoveKeys = new ArrayList<>();
|
for (Map.Entry<TjOrderRemark, List<TjPdfVO>> entry : printReport.entrySet()) {
|
List<TjPdfVO> tjPdfVOS = new ArrayList<>();
|
for (TjOrderDetail tjOrderDetail : tjOrderDetails) {
|
if (entry.getKey().getProsId().equals(tjOrderDetail.getProsId())) {
|
TjPdfVO tjPdfVO = new TjPdfVO();
|
tjPdfVO.setProName(tjOrderDetail.getProName());
|
if (null != tjOrderDetail.getYcbz() && !tjOrderDetail.getYcbz().equals("")) {
|
tjPdfVO.setProResult(tjOrderDetail.getProResult() + " [" + tjOrderDetail.getYcbz() + "]");
|
} else {
|
tjPdfVO.setProResult(tjOrderDetail.getProResult());
|
}
|
tjPdfVO.setExc(tjOrderDetail.getExceptionDesc());
|
tjPdfVO.setStandardValue(tjOrderDetail.getStanId());
|
tjPdfVO.setCompany(tjOrderDetail.getProAdvice());
|
tjPdfVOS.add(tjPdfVO);
|
}
|
}
|
printReport.put(entry.getKey(), tjPdfVOS);
|
if (tjPdfVOS.isEmpty()) {
|
toRemoveKeys.add(entry.getKey());
|
}
|
}
|
toRemoveKeys.forEach(printReport::remove);
|
return printReport;
|
}
|
|
private void extracted(Map<TjOrderRemark, List<TjPdfVO>> printReport, TjOrder one, TjCustomer customer) {
|
for (Map.Entry<TjOrderRemark, List<TjPdfVO>> entry : printReport.entrySet()) {
|
List<TjPdfVO> tjPdfVOS = new ArrayList<>();
|
// TjOrder one = tjOrderService.getOrderByTjNum(entry.getKey().getTjNumber());
|
System.out.println(one.getOrderId() + " " + entry.getKey().getProId());
|
List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.getDetailByOrderIdAndParId(one.getOrderId(), entry.getKey().getProId());
|
System.out.println("tjOrderDetails = " + tjOrderDetails);
|
for (TjOrderDetail tjOrderDetail : tjOrderDetails) {
|
TjProject tjProject = projectService.getById(tjOrderDetail.getProId());
|
if (null != tjProject) {
|
tjOrderDetail.setProject(tjProject);
|
}
|
if (null == tjOrderDetail.getProject()) {
|
System.out.println("'''''''''''''''''''''''''''''''''''" + tjOrderDetail.getOrderDetailId());
|
}
|
if (tjOrderDetail.getProject().getProParentId().equals(entry.getKey().getProId())) {
|
LambdaQueryWrapper<TjStandard> wq6 = new LambdaQueryWrapper<>();
|
wq6.eq(TjStandard::getProId, tjOrderDetail.getProId());
|
List<TjStandard> list2 = tjStandardService.list(wq6);
|
if (list2.size() == 0) {
|
TjStandard s = new TjStandard();
|
s.setCompany(" ");
|
s.setTjStandardLtValue(" ");
|
s.setTjStandardGtValue(" ");
|
tjOrderDetail.setStandard(s);
|
} else if (list2.size() == 1) {
|
tjOrderDetail.setStandard(list2.get(0));
|
} else {
|
Long cusSex = customer.getCusSex();
|
Date cusBrithday = customer.getCusBrithday();
|
int age = DateUtil.ageOfNow(cusBrithday);
|
for (TjStandard tjStandard : list2) {
|
LambdaQueryWrapper<TjStandard> wq8 = new LambdaQueryWrapper<>();
|
if (tjStandard.getTjSex() != null) {
|
wq8.eq(TjStandard::getTjSex, cusSex);
|
}
|
if (tjStandard.getTjType() != null) {
|
wq8.eq(TjStandard::getTjType, StringUtils.getAgeType(age));
|
}
|
TjStandard standard = tjStandardService.getOne(wq8);
|
tjOrderDetail.setStandard(standard);
|
}
|
}
|
TjPdfVO tjPdfVO = new TjPdfVO();
|
tjPdfVO.setProName(tjOrderDetail.getProject().getProName());
|
tjPdfVO.setProResult(tjOrderDetail.getProResult());
|
tjPdfVO.setExc(tjOrderDetail.getExceptionDesc());
|
if (tjOrderDetail.getStandard() != null) {
|
//单位
|
if (tjOrderDetail.getStandard().getCompany() == null) {
|
tjPdfVO.setCompany(" ");
|
} else {
|
tjPdfVO.setCompany(tjOrderDetail.getStandard().getCompany());
|
}
|
//最大值和最小值
|
String tjStandardGtValue = tjOrderDetail.getStandard().getTjStandardGtValue();
|
String tjStandardLtValue = tjOrderDetail.getStandard().getTjStandardLtValue();
|
if (tjStandardGtValue == null) {
|
tjStandardGtValue = " ";
|
}
|
if (tjStandardLtValue == null) {
|
tjStandardLtValue = " ";
|
}
|
tjPdfVO.setStandardValue(tjStandardLtValue + "-" + tjStandardGtValue);
|
}
|
tjPdfVOS.add(tjPdfVO);
|
}
|
}
|
printReport.put(entry.getKey(), tjPdfVOS);
|
}
|
}
|
|
private void extractedNew(Map<TjOrderRemark, List<TjPdfVO>> printReport, TjOrder one, TjCustomer customer) {
|
List<Long> collect = printReport.entrySet().stream().map(item -> item.getKey().getProId()).collect(Collectors.toList());
|
List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.getDetailByOrderIdAndParIds(one.getOrderId(), collect);
|
Set<String> strings = tjOrderDetails.stream().map(item -> item.getUpdateBy().split(",")[1]).collect(Collectors.toSet());
|
HashMap<Long, List<TjPdfVO>> hashMap = new HashMap<>();
|
strings.forEach(item -> {
|
hashMap.put(Long.parseLong(item), new ArrayList<TjPdfVO>());
|
});
|
List<Long> proIds = tjOrderDetails.stream().map(TjOrderDetail::getProId).collect(Collectors.toList());
|
LambdaQueryWrapper<TjProject> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.in(TjProject::getProId, proIds);
|
List<TjProject> projectList = projectService.list(queryWrapper);
|
for (TjOrderDetail tjOrderDetail : tjOrderDetails) {
|
TjProject tjProject = projectList.stream().filter(item -> item.getProId().equals(tjOrderDetail.getProId())).collect(Collectors.toList()).get(0);
|
if (null != tjProject) {
|
tjOrderDetail.setProject(tjProject);
|
}
|
if (null == tjOrderDetail.getProject()) {
|
System.out.println("'''''''''''''''''''''''''''''''''''" + tjOrderDetail.getOrderDetailId());
|
}
|
// 判断在collect中是否存在
|
if (collect.contains(tjOrderDetail.getProject().getProParentId())) {
|
LambdaQueryWrapper<TjStandard> wq6 = new LambdaQueryWrapper<>();
|
wq6.eq(TjStandard::getProId, tjOrderDetail.getProId());
|
List<TjStandard> list2 = tjStandardService.list(wq6);
|
if (list2.isEmpty()) {
|
TjStandard s = new TjStandard();
|
s.setCompany(" ");
|
s.setTjStandardLtValue(" ");
|
s.setTjStandardGtValue(" ");
|
tjOrderDetail.setStandard(s);
|
} else if (list2.size() == 1) {
|
tjOrderDetail.setStandard(list2.get(0));
|
} else {
|
Long cusSex = customer.getCusSex();
|
Date cusBrithday = customer.getCusBrithday();
|
int age = DateUtil.ageOfNow(cusBrithday);
|
for (TjStandard tjStandard : list2) {
|
LambdaQueryWrapper<TjStandard> wq8 = new LambdaQueryWrapper<>();
|
if (tjStandard.getTjSex() != null) {
|
wq8.eq(TjStandard::getTjSex, cusSex);
|
}
|
if (tjStandard.getTjType() != null) {
|
wq8.eq(TjStandard::getTjType, StringUtils.getAgeType(age));
|
}
|
TjStandard standard = tjStandardService.getOne(wq8);
|
tjOrderDetail.setStandard(standard);
|
}
|
}
|
TjPdfVO tjPdfVO = new TjPdfVO();
|
tjPdfVO.setProName(tjOrderDetail.getProject().getProName());
|
tjPdfVO.setProResult(tjOrderDetail.getProResult());
|
tjPdfVO.setExc(tjOrderDetail.getExceptionDesc());
|
if (tjOrderDetail.getStandard() != null) {
|
//单位
|
if (tjOrderDetail.getStandard().getCompany() == null) {
|
tjPdfVO.setCompany(" ");
|
} else {
|
tjPdfVO.setCompany(tjOrderDetail.getStandard().getCompany());
|
}
|
//最大值和最小值
|
String tjStandardGtValue = tjOrderDetail.getStandard().getTjStandardGtValue();
|
String tjStandardLtValue = tjOrderDetail.getStandard().getTjStandardLtValue();
|
if (tjStandardGtValue == null) {
|
tjStandardGtValue = " ";
|
}
|
if (tjStandardLtValue == null) {
|
tjStandardLtValue = " ";
|
}
|
tjPdfVO.setStandardValue(tjStandardLtValue + "-" + tjStandardGtValue);
|
}
|
List<TjPdfVO> tjPdfVOS = hashMap.get(Long.parseLong(tjOrderDetail.getUpdateBy().split(",")[1]));
|
tjPdfVOS.add(tjPdfVO);
|
}
|
}
|
printReport.entrySet().stream().forEach(item -> {
|
List<TjPdfVO> pdfVOS = hashMap.get(item.getKey().getProId());
|
printReport.put(item.getKey(), pdfVOS);
|
});
|
}
|
|
@GetMapping("/isPdfOrJimu")
|
@ApiOperation(value = "判断报告打开类型")
|
public AjaxResult isPdfOrJimu(String tjNumber) {
|
Map<String, String> res = new HashMap<>();
|
LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
|
we.eq(TjReport::getTjNumber, tjNumber);
|
we.eq(TjReport::getType, "体检报告");
|
TjReport one = tjReportService.getOne(we);
|
if (one == null) {
|
return AjaxResult.error("暂无体检报告,请撤回到总检未审核页面,需总检医生重新审核并生成报告!");
|
}
|
if ("pdf".equals(one.getPrint())) {
|
res.put("flag", "0");
|
return AjaxResult.success(res);
|
} else if ("报表".equals(one.getPrint())) {
|
res.put("flag", "1");
|
res.put("url", one.getPath());
|
return AjaxResult.success(res);
|
} else {
|
return AjaxResult.error("暂无体检报告,请撤回到总检未审核页面,需总检医生重新审核并生成报告!");
|
}
|
|
}
|
|
|
@GetMapping("/preview/{flag}/{TjNumber}")
|
@ApiOperation(value = "下载体检报告")
|
public void preview(HttpServletResponse response, @PathVariable("flag") boolean flag, @PathVariable("TjNumber") String tjNumber) {
|
TjOrder tjOrder = tjOrderService.getOrderByTjNum(tjNumber);
|
TjCustomer tjCustomer = tjCustomerService.getById( tjOrder.getUserId());
|
// LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
|
// we.eq(TjReport::getTjNumber, tjNumber);
|
// we.eq(TjReport::getType, "体检报告");
|
// TjReport one = tjReportService.getOne(we);
|
// if (one == null) {
|
// return;
|
// }
|
String key = DataSourceContextHolder.getDataSourceKey();
|
key = key.replace("ltkjpeis10_","");
|
// String userId = SecurityUtils.getLoginUser().getUsername();
|
// PDFBinaryUtil.base64StringToPDF(one.getReport(), FileUtil.mkdir(value).getPath() + File.separator + key + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf");
|
String filePath = value + File.separator + key + File.separator + tjCustomer.getCusId() + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
|
log.info("预览报告 ->{}",filePath);
|
File f = new File(filePath);
|
BufferedInputStream br = null;
|
OutputStream out = null;
|
FileInputStream fileInputStream = null;
|
try {
|
fileInputStream = new FileInputStream(f);
|
br = new BufferedInputStream(fileInputStream);
|
byte[] bs = new byte[1024];
|
int len = 0;
|
response.reset(); // 非常重要
|
if (flag) {
|
// 在线打开方式
|
URL u = new URL("file:///" + filePath);
|
String contentType = u.openConnection().getContentType();
|
response.setContentType(contentType);
|
response.setHeader("Content-Disposition", "inline;filename="
|
+ tjCustomer.getCusId() + tjNumber + ".pdf");
|
} else {
|
// 纯下载方式
|
response.setContentType("application/x-msdownload");
|
response.setContentType("application/pdf;charset=utf-8");
|
response.setHeader("Content-Disposition", "attachment;filename="
|
+ tjCustomer.getCusId() + tjNumber + ".pdf");
|
}
|
out = response.getOutputStream();
|
while ((len = br.read(bs)) > 0) {
|
out.write(bs, 0, len);
|
}
|
out.flush();
|
out.close();
|
br.close();
|
fileInputStream.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
//System.out.println("pdf处理文件异常" + e);
|
} finally {
|
if (out != null) {
|
try {
|
out.close();
|
br.close();
|
fileInputStream.close();
|
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
}
|
|
@GetMapping("/previewprint/{flag}/{TjNumber}/{sfdy}")
|
@ApiOperation(value = "下载体检报告")
|
public void previewprint(HttpServletResponse response, @PathVariable("flag") boolean flag, @PathVariable("TjNumber") String tjNumber,@PathVariable("sfdy") String sfdy) {
|
|
Date date = new Date();
|
TjOrder tjOrder = tjOrderService.getOrderByTjNum(tjNumber);
|
|
TjCustomer tjCustomer = tjCustomerService.getById( tjOrder.getUserId());
|
|
LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
|
we.eq(TjReport::getTjNumber, tjNumber);
|
we.eq(TjReport::getType, "体检报告");
|
TjReport one = tjReportService.getOne(we);
|
if (one == null) {
|
return;
|
}
|
String key = DataSourceContextHolder.getDataSourceKey();
|
key = key.replace("ltkjpeis10_","");
|
|
// String userId = SecurityUtils.getLoginUser().getUsername();
|
// PDFBinaryUtil.base64StringToPDF(one.getReport(), FileUtil.mkdir(value).getPath() + File.separator + key + File.separator + tjCustomer.getCusId() + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf");
|
String filePath = value + File.separator + key + File.separator + tjCustomer.getCusId() + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
|
File f = new File(filePath);
|
BufferedInputStream br = null;
|
OutputStream out = null;
|
FileInputStream fileInputStream = null;
|
try {
|
fileInputStream = new FileInputStream(f);
|
br = new BufferedInputStream(fileInputStream);
|
byte[] bs = new byte[1024];
|
int len = 0;
|
response.reset(); // 非常重要
|
if (flag) {
|
// 在线打开方式
|
URL u = new URL("file:///" + filePath);
|
//System.out.println(u);
|
String contentType = u.openConnection().getContentType();
|
response.setContentType(contentType);
|
response.setHeader("Content-Disposition", "inline;filename="
|
+ tjCustomer.getCusId() + tjNumber + ".pdf");
|
} else {
|
// 纯下载方式
|
response.setContentType("application/x-msdownload");
|
response.setContentType("application/pdf;charset=utf-8");
|
response.setHeader("Content-Disposition", "attachment;filename="
|
+ tjCustomer.getCusId() + tjNumber + ".pdf");
|
}
|
out = response.getOutputStream();
|
while ((len = br.read(bs)) > 0) {
|
out.write(bs, 0, len);
|
}
|
if(null !=sfdy && sfdy.equals("1")){
|
TjReportPrint print=new TjReportPrint();
|
print.setTjNumber(tjNumber);
|
print.setPrintBy(SecurityUtils.getLoginUser().getUser().getNickName());
|
print.setPrintTime(date);
|
print.setPrintStatus("已打印");
|
if (printService.save(print)) {
|
tjOrder.setPrintLastTime(date);
|
tjOrder.setStatus(TjConstants.TJ_END);
|
tjOrderService.updateById(tjOrder);
|
}
|
}
|
out.flush();
|
out.close();
|
br.close();
|
fileInputStream.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
//System.out.println("pdf处理文件异常" + e);
|
} finally {
|
if (out != null) {
|
try {
|
out.close();
|
br.close();
|
fileInputStream.close();
|
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
}
|
|
@PostMapping("/preview/batch")
|
@ApiOperation(value = "批量体检报告")
|
@Transactional
|
public AjaxResult preview(@RequestBody String data) {
|
String is_batch_report_use_sql = configService.selectConfigByKey("is_batch_report_use_sql");
|
List<String> tjNumbers = Arrays.stream(data.split(",")).collect(Collectors.toList());
|
if ("true".equals(is_batch_report_use_sql)) {
|
return tjReportService.makeBatchReport(tjNumbers);
|
} else {
|
return makeReport(tjNumbers);
|
}
|
}
|
|
/**
|
* 通过sql 重整数据模板 全部重新生成
|
*
|
* @param tjNumbers
|
* @return
|
*/
|
private AjaxResult makeReport(List<String> tjNumbers) {
|
ArrayList<String> base64Pdfs = new ArrayList<>();
|
for (String tjNumber : tjNumbers) {
|
LambdaQueryWrapper<TjOrder> wq = new LambdaQueryWrapper<>();
|
wq.eq(TjOrder::getTjNumber, tjNumber);
|
TjOrder tjOrder = tjOrderService.getOne(wq);
|
if (null != tjOrder) {
|
LambdaQueryWrapper<TjReportTemplate> tjReportTemplateLambdaQueryWrapper = new LambdaQueryWrapper<>();
|
TjReportTemplate reportTemplate = null;
|
if (tjOrder.getTjCategory() != null) {
|
//查询字典
|
LambdaQueryWrapper<SysDictData> wqq = new LambdaQueryWrapper<>();
|
wqq.eq(SysDictData::getDictType, "dict_tjtype");
|
wqq.eq(SysDictData::getDictValue, tjOrder.getTjCategory());
|
SysDictData one = dictDataService.getOne(wqq);
|
if (one != null) {
|
//查询字典
|
LambdaQueryWrapper<SysDictData> wqq1 = new LambdaQueryWrapper<>();
|
wqq1.eq(SysDictData::getDictType, "report_template_type");
|
wqq1.eq(SysDictData::getDictLabel, one.getDictLabel());
|
SysDictData one1 = dictDataService.getOne(wqq1);
|
if (one1 != null) {
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, one1.getDictValue());
|
} else {
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
|
}
|
} else {
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
|
}
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
|
reportTemplate = reportTemplateService.getOne(tjReportTemplateLambdaQueryWrapper);
|
} else {
|
tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
|
reportTemplate = reportTemplateService.list(tjReportTemplateLambdaQueryWrapper).get(2);
|
}
|
|
String template = reportTemplate.getTemplate();
|
String userId = null;
|
if (template == null) {
|
// 没有该模板
|
continue;
|
}
|
// --------以上------- 根据数据库中的模板二进制文件 转pdf 创建文件夹 将pdf放进本地文件夹
|
LambdaQueryWrapper<TjCustomer> wq1 = new LambdaQueryWrapper<>();
|
wq1.eq(TjCustomer::getCusId, tjOrder.getUserId());
|
TjCustomer tjCustomer = tjCustomerService.getOne(wq1);
|
LambdaQueryWrapper<DictComp> wq111 = new LambdaQueryWrapper<>();
|
wq111.eq(DictComp::getDrugManufacturerId, tjOrder.getFirmId());
|
DictComp dictComp = dictCompService.getOne(wq111);
|
LambdaQueryWrapper<TjOrderDetail> wq2 = new LambdaQueryWrapper<>();
|
wq2.eq(TjOrderDetail::getOrderId, tjOrder.getOrderId());
|
wq2.isNotNull(TjOrderDetail::getFlowingWaterId);
|
List<TjOrderDetail> list = tjOrderDetailService.list(wq2);
|
for (TjOrderDetail tjOrderDetail : list) {
|
TjProject tjProject = projectService.selectTjProjectByProId(tjOrderDetail.getProId());
|
tjOrderDetail.setProject(tjProject);
|
}
|
ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
|
PdfStamper ps = null;
|
PdfReader reader = null;
|
try {
|
// 读入pdf表单
|
reader = new PdfReader(new ByteArrayInputStream(Base64.getDecoder().decode(template)));
|
// 根据表单生成一个新的pdf
|
ps = new PdfStamper(reader, byteArrayOutputStream);
|
// 获取pdf表单
|
AcroFields form = ps.getAcroFields();
|
//该字体造成类型不均匀，但是pdf转图片不乱码
|
BaseFont bf = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED);
|
form.addSubstitutionFont(bf);
|
// 填充数据给表格
|
Map<String, Object> data = new HashMap<>();
|
// 设置用户信息
|
setUserInfo(tjNumber, tjOrder, tjCustomer, dictComp, list, data);
|
//封面页下面的总检建议显示
|
if (tjOrder.getCheckAdvice() == null) {
|
data.put("remark", "无");
|
} else {
|
data.put("remark", tjOrder.getCheckAdvice());
|
}
|
//封面页下面的总检建议显示
|
if (tjOrder.getCheckDoctor() == null) {
|
data.put("docname", "无");
|
} else {
|
data.put("docname", tjOrder.getCheckDoctor());
|
}
|
//异常项目
|
//拼接重大阳性结果
|
StringBuffer str = new StringBuffer();
|
str.append("【重大阳性项目】\n");
|
LambdaQueryWrapper<TjBigPositive> bigPositiveLambdaQueryWrapper = new LambdaQueryWrapper<>();
|
bigPositiveLambdaQueryWrapper.eq(TjBigPositive::getTjNumber, tjNumber);
|
final List<TjBigPositive> list1 = tjBigPositiveService.list(bigPositiveLambdaQueryWrapper);
|
if (list1 != null && list1.size() > 0) {
|
for (int i = 0; i < list1.size(); i++) {
|
str.append(i + 1).append("、").append(list1.get(i).getProName()).append(";\n");
|
}
|
} else {
|
str.append(" 无；\n");
|
}
|
//拼接异常项目
|
str.append("【异常情况项目】\n");
|
if (list.size() > 0) {
|
int[] index = {0};
|
List<TjOrderDetail> collect = list.stream()
|
.filter(item -> item.getExceptionDesc() == 1).collect(Collectors.toList());
|
if (collect.isEmpty()) {
|
str.append(" 无；\n");
|
} else {
|
collect.forEach(item -> str.append(index[0]++ + 1).append("、").append(projectService.getById(item.getProId()).getProName()).append(";\n"));
|
}
|
} else {
|
str.append(" 无；\n");
|
}
|
//异常项目
|
data.put("yichang", str.toString());
|
// 遍历data 给pdf表单表格赋值
|
for (String key : data.keySet()) {
|
form.setField(key, data.get(key).toString());
|
}
|
//设置为无法编辑
|
ps.setFormFlattening(true);
|
ps.close();
|
reader.close();
|
// 将修改后的PDF内容写入
|
byte[] bytes = byteArrayOutputStream.toByteArray();
|
// 创建新的PDF文档
|
Document document = new Document(PageSize.A4);
|
ByteArrayOutputStream finalOutPut = new ByteArrayOutputStream();
|
PdfCopy copy = new PdfCopy(document, finalOutPut);
|
document.open();
|
reader = new PdfReader(bytes);
|
int numberOfPages = reader.getNumberOfPages();
|
for (int i = 1; i <= numberOfPages; i++) {
|
PdfImportedPage page = copy.getImportedPage(reader, i);
|
copy.addPage(page);
|
}
|
// 添加详情页
|
document.newPage();
|
reader.close();
|
ByteArrayOutputStream infoByteArrayOutputStream = setInfoPage(userId, tjNumber);
|
reader = new PdfReader(infoByteArrayOutputStream.toByteArray());
|
int numberOfPages1 = reader.getNumberOfPages();
|
for (int i = 1; i <= numberOfPages1; i++) {
|
PdfImportedPage page = copy.getImportedPage(reader, i);
|
copy.addPage(page);
|
}
|
infoByteArrayOutputStream.close();
|
// 心电图以及附件
|
// 因数据库表存放base64导致查询缓慢 这里执行缓慢
|
// 在这里增加一条查询count 对于没有追加附件的 提升速度
|
LambdaQueryWrapper<TjReport> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.eq(TjReport::getTjNumber, tjNumber)
|
.and(item -> item.eq(TjReport::getType, "附件").or().eq(TjReport::getType, "心电图"));
|
Integer selectCount = tjReportService.getSelectCount(queryWrapper);
|
if (selectCount > 0) {
|
String base64XinDianTu = null;
|
String base64FuJian = null;
|
List<TjReport> reportList = tjReportService.list(queryWrapper);
|
TjReport xinDianTu = null;
|
TjReport fuJian = null;
|
if (!reportList.isEmpty()) {
|
for (TjReport tjReport : reportList) {
|
if ("附件".equals(tjReport.getType())) {
|
fuJian = tjReport;
|
base64FuJian = fuJian.getReport();
|
} else {
|
xinDianTu = tjReport;
|
base64XinDianTu = xinDianTu.getReport();
|
}
|
}
|
}
|
if (xinDianTu != null) {
|
if (fuJian != null) {
|
addPageByPDFBase64(copy, base64FuJian);
|
document.newPage();
|
addPageByPDFBase64(copy, base64XinDianTu);
|
} else {
|
addPageByPDFBase64(copy, base64XinDianTu);
|
}
|
} else {
|
if (fuJian != null) {
|
addPageByPDFBase64(copy, base64FuJian);
|
}
|
}
|
}
|
copy.close();
|
base64Pdfs.add(Base64.getEncoder().encodeToString(finalOutPut.toByteArray()));
|
document.close();
|
finalOutPut.close();
|
reader.close();
|
//修改order表中的打印报告时间为当前时间
|
LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
|
updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
|
updateWrapper.set(TjOrder::getReportTime, new Date());
|
updateWrapper.set(TjOrder::getPrintLastTime, new Date());
|
updateWrapper.set(TjOrder::getDownloadLastTime, new Date());
|
updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
|
tjOrderService.update(updateWrapper);
|
} catch (Exception e) {
|
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
|
e.printStackTrace();
|
}
|
}
|
}
|
try {
|
byte[] mergePDFs = PDFDocumentUtil.mergePDFs(base64Pdfs);
|
// 本地生成测试
|
// String PDF_FILE = "d:\\Users\\w\\Desktop\\test.pdf";
|
// BufferedOutputStream outputStream = new BufferedOutputStream(new FileOutputStream(PDF_FILE));
|
// outputStream.write(mergePDFs);
|
// outputStream.flush();
|
// outputStream.close();
|
String s = Base64.getEncoder().encodeToString(mergePDFs);
|
return AjaxResult.success().put("file", s);
|
} catch (DocumentException | IOException e) {
|
e.printStackTrace();
|
return AjaxResult.error("批量生成失败");
|
}
|
}
|
|
@GetMapping("/revocationReport/{TjNumber}")
|
@ApiOperation(value = "撤销生成体检报告")
|
@Transactional
|
public AjaxResult revocationReport(@PathVariable("TjNumber") String tjNumber) {
|
|
TjOrder one = tjOrderService.getOrderByTjNum(tjNumber);
|
if(null !=one){
|
if(null !=one.getHeshouTime() && one.getHeshouStatus()==1)return AjaxResult.error("报告已核收不可撤回!!!");
|
one.setCheckStatus(0);
|
String config = configService.selectConfigByKey("tj_confirm");
|
if ("Y".equals(config)) {
|
one.setStatus(TjConstants.TJ_CHECK);
|
} else {
|
one.setStatus(TjConstants.TJ_CONFIRM);
|
}
|
one.setReportTime(null);
|
one.setCheckTime(null);
|
one.setCheckDoctor(null);
|
one.setHeshouStatus(0);
|
one.setHeshouTime(null);
|
one.setHeshouDoctor(null);
|
one.setPrintLastTime(null);
|
one.setDownloadLastTime(null);
|
if (tjOrderService.updateById(one)) {
|
|
//逻辑删除数据库里的报告
|
QueryWrapper<TjReport> wq1 = new QueryWrapper<>();
|
wq1.select("re_id");
|
wq1.eq("tj_number", tjNumber);
|
wq1.eq("type", "体检报告");
|
TjReport tjReport = tjReportService.getOne(wq1);
|
if (null != tjReport) {
|
// 不在使用逻辑删除 逻辑删除导致打印报告生成 查询sql缓慢
|
int i = tjReportService.deleteTjReportByReId(tjReport.getReId());
|
if (i == 0) {
|
return AjaxResult.error("暂无体检报告,请撤回到总检未审核页面,需总检医生重新审核并生成报告!");
|
}
|
}
|
|
return AjaxResult.success("撤回成功！");
|
}
|
}
|
return AjaxResult.error("该人员体检记录不存在,请核实人员信息!");
|
|
}
|
|
|
@GetMapping("/tuanDuiReport")
|
@ApiOperation(value = "生成团队体检报告——年龄统计")
|
public Map<String, List<Map<String, Object>>> tuanDuiReport(@ApiParam(value = "单位") @RequestParam String firmId,
|
@ApiParam(value = "部门") @RequestParam String firmDeptId) {
|
Map<String, List<Map<String, Object>>> all = new HashMap<>();
|
List<Map<String, Object>> res1 = new ArrayList<>();
|
|
int a = 0;
|
Map<String, Object> resMap1 = new HashMap<>();
|
resMap1.put("name", "0-19岁");
|
resMap1.put("value", a);
|
res1.add(resMap1);
|
Map<String, Object> resMap2 = new HashMap<>();
|
resMap2.put("name", "20-29岁");
|
resMap2.put("value", a);
|
res1.add(resMap2);
|
Map<String, Object> resMap3 = new HashMap<>();
|
resMap3.put("name", "30-39岁");
|
resMap3.put("value", a);
|
res1.add(resMap3);
|
Map<String, Object> resMap4 = new HashMap<>();
|
resMap4.put("name", "40-49岁");
|
resMap4.put("value", a);
|
res1.add(resMap4);
|
Map<String, Object> resMap5 = new HashMap<>();
|
resMap5.put("name", "50-59岁");
|
resMap5.put("value", a);
|
res1.add(resMap5);
|
Map<String, Object> resMap6 = new HashMap<>();
|
resMap6.put("name", "60-69岁");
|
resMap6.put("value", a);
|
res1.add(resMap6);
|
Map<String, Object> resMap7 = new HashMap<>();
|
resMap7.put("name", "70-79岁");
|
resMap7.put("value", a);
|
res1.add(resMap7);
|
Map<String, Object> resMap8 = new HashMap<>();
|
resMap8.put("name", "80岁+");
|
resMap8.put("value", a);
|
res1.add(resMap8);
|
|
|
LambdaQueryWrapper<TjOrder> wq2 = new LambdaQueryWrapper<>();
|
wq2.eq(TjOrder::getFirmId, firmId);
|
wq2.eq(TjOrder::getFirmDeptId, firmDeptId);
|
wq2.ne(TjOrder::getTjType, "2");
|
// wq2.in(TjOrder::getStatus, 401, 402);
|
final List<TjOrder> list = tjOrderService.list(wq2);
|
|
for (TjOrder tjOrder : list) {
|
a = 0;
|
final TjCustomer byId = tjCustomerService.getById(tjOrder.getUserId());
|
final int ageByIdCard = MatchUtils.getAgeByIdCard(byId.getCusIdcard());
|
|
|
if (0 <= ageByIdCard && ageByIdCard <= 19) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("0-19岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else if (20 <= ageByIdCard && ageByIdCard <= 29) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("20-29岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else if (30 <= ageByIdCard && ageByIdCard <= 39) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("30-39岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else if (40 <= ageByIdCard && ageByIdCard <= 49) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("40-49岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else if (50 <= ageByIdCard && ageByIdCard <= 59) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("50-59岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else if (60 <= ageByIdCard && ageByIdCard <= 69) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("60-69岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else if (70 <= ageByIdCard && ageByIdCard <= 79) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("70-79岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
} else {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("80岁+".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
}
|
}
|
}
|
}
|
all.put("data", res1);
|
return all;
|
|
}
|
|
@GetMapping("/tuanDuiReportBySex")
|
@ApiOperation(value = "生成团队体检报告——年龄性别统计")
|
public Map<String, List<Map<String, Object>>> tuanDuiReportBySex(@ApiParam(value = "单位") @RequestParam String firmIds,
|
@ApiParam(value = "部门") @RequestParam String firmDeptIds) {
|
Map<String, List<Map<String, Object>>> all = new HashMap<>();
|
List<Map<String, Object>> res1 = new ArrayList<>();
|
|
int a = 0;
|
int b = 0;
|
int c = 0;
|
Map<String, Object> resMap1 = new HashMap<>();
|
resMap1.put("name", "0-19岁");
|
resMap1.put("value", a);
|
resMap1.put("boy", b);
|
resMap1.put("girl", c);
|
resMap1.put("value1", 0);
|
resMap1.put("boy1", 0);
|
resMap1.put("girl1", 0);
|
res1.add(resMap1);
|
Map<String, Object> resMap2 = new HashMap<>();
|
resMap2.put("name", "20-29岁");
|
resMap2.put("value", a);
|
resMap2.put("boy", b);
|
resMap2.put("girl", c);
|
resMap2.put("value1", 0);
|
resMap2.put("boy1", 0);
|
resMap2.put("girl1", 0);
|
res1.add(resMap2);
|
Map<String, Object> resMap3 = new HashMap<>();
|
resMap3.put("name", "30-39岁");
|
resMap3.put("value", a);
|
resMap3.put("boy", b);
|
resMap3.put("girl", c);
|
resMap3.put("value1", 0);
|
resMap3.put("boy1", 0);
|
resMap3.put("girl1", 0);
|
res1.add(resMap3);
|
Map<String, Object> resMap4 = new HashMap<>();
|
resMap4.put("name", "40-49岁");
|
resMap4.put("value", a);
|
resMap4.put("boy", b);
|
resMap4.put("girl", c);
|
resMap4.put("value1", 0);
|
resMap4.put("boy1", 0);
|
resMap4.put("girl1", 0);
|
res1.add(resMap4);
|
Map<String, Object> resMap5 = new HashMap<>();
|
resMap5.put("name", "50-59岁");
|
resMap5.put("value", a);
|
resMap5.put("boy", b);
|
resMap5.put("girl", c);
|
resMap5.put("value1", 0);
|
resMap5.put("boy1", 0);
|
resMap5.put("girl1", 0);
|
res1.add(resMap5);
|
Map<String, Object> resMap6 = new HashMap<>();
|
resMap6.put("name", "60-69岁");
|
resMap6.put("value", a);
|
resMap6.put("boy", b);
|
resMap6.put("girl", c);
|
resMap6.put("value1", 0);
|
resMap6.put("boy1", 0);
|
resMap6.put("girl1", 0);
|
res1.add(resMap6);
|
Map<String, Object> resMap7 = new HashMap<>();
|
resMap7.put("name", "70-79岁");
|
resMap7.put("value", a);
|
resMap7.put("boy", b);
|
resMap7.put("girl", c);
|
resMap7.put("value1", 0);
|
resMap7.put("boy1", 0);
|
resMap7.put("girl1", 0);
|
res1.add(resMap7);
|
Map<String, Object> resMap8 = new HashMap<>();
|
resMap8.put("name", "80岁+");
|
resMap8.put("value", a);
|
resMap8.put("boy", b);
|
resMap8.put("girl", c);
|
resMap8.put("value1", 0);
|
resMap8.put("boy1", 0);
|
resMap8.put("girl1", 0);
|
res1.add(resMap8);
|
|
|
LambdaQueryWrapper<TjOrder> wq2 = new LambdaQueryWrapper<>();
|
wq2.eq(TjOrder::getFirmId, firmIds);
|
wq2.eq(TjOrder::getFirmDeptId, firmDeptIds);
|
wq2.eq(TjOrder::getTjType, "1");
|
wq2.in(TjOrder::getStatus, 401, 402);
|
final List<TjOrder> list = tjOrderService.list(wq2);
|
|
for (TjOrder tjOrder : list) {
|
a = 0;
|
b = 0;
|
c = 0;
|
final TjCustomer byId = tjCustomerService.getById(tjOrder.getUserId());
|
final int ageByIdCard = MatchUtils.getAgeByIdCard(byId.getCusIdcard());
|
|
if (0 <= ageByIdCard && ageByIdCard <= 19) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("0-19岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else if (20 <= ageByIdCard && ageByIdCard <= 29) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("20-29岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else if (30 <= ageByIdCard && ageByIdCard <= 39) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("30-39岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else if (40 <= ageByIdCard && ageByIdCard <= 49) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("40-49岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else if (50 <= ageByIdCard && ageByIdCard <= 59) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("50-59岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else if (60 <= ageByIdCard && ageByIdCard <= 69) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("60-69岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else if (70 <= ageByIdCard && ageByIdCard <= 79) {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("70-79岁".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
} else {
|
for (int i = 0; i < res1.size(); i++) {
|
if ("80岁+".equals(res1.get(i).get("name"))) {
|
a += 1;
|
res1.get(i).put("value", a);
|
if (byId.getCusSex() == 0) {
|
b += 1;
|
} else if (byId.getCusSex() == 1) {
|
c += 1;
|
}
|
res1.get(i).put("boy", b);
|
res1.get(i).put("girl", c);
|
}
|
}
|
}
|
}
|
//计算百分数
|
for (int i = 0; i < res1.size(); i++) {
|
final int value1 = (int) res1.get(i).get("boy");
|
final int value2 = (int) res1.get(i).get("girl");
|
final int value = (int) res1.get(i).get("value");
|
if (value != 0) {
|
double percentage = (value1 * 1.0 / value) * 100;
|
NumberFormat nf = NumberFormat.getPercentInstance();
|
nf.setMinimumFractionDigits(2);
|
String percent1 = nf.format(percentage / 100);
|
|
double percentage1 = (value2 * 1.0 / value) * 100;
|
NumberFormat nf1 = NumberFormat.getPercentInstance();
|
nf1.setMinimumFractionDigits(2);
|
String percent2 = nf1.format(percentage1 / 100);
|
|
NumberFormat numberFormat = NumberFormat.getInstance();
|
numberFormat.setMaximumFractionDigits(2);
|
String result = numberFormat.format((float) value1 / (float) value2 * 100);
|
res1.get(i).put("boy1", percent1);
|
res1.get(i).put("girl1", percent2);
|
res1.get(i).put("value1", result);
|
|
}
|
|
}
|
all.put("data", res1);
|
return all;
|
|
}
|
|
|
@GetMapping("/tuanDuiYiChang")
|
@ApiOperation(value = "生成团队体检报告——异常结果统计")
|
public Map<String, List<Map<String, Object>>> tuanDuiYiChang(@ApiParam(value = "单位") @RequestParam String firmId,
|
@ApiParam(value = "部门") @RequestParam String firmDeptId) {
|
|
Map<String, List<Map<String, Object>>> all = new HashMap<>();
|
|
LambdaQueryWrapper<TjOrder> wq2 = new LambdaQueryWrapper<>();
|
wq2.eq(TjOrder::getFirmId, firmId);
|
wq2.eq(TjOrder::getFirmDeptId, firmDeptId);
|
wq2.eq(TjOrder::getTjType, "1");
|
wq2.in(TjOrder::getStatus, 401, 402);
|
final List<TjOrder> list = tjOrderService.list(wq2);
|
|
List<TjOrderDetailRules> res11 = new ArrayList<>();
|
for (TjOrder tjOrder : list) {
|
LambdaQueryWrapper<TjOrderDetailRules> wq1 = new LambdaQueryWrapper<>();
|
wq1.eq(TjOrderDetailRules::getTjNumber, tjOrder.getTjNumber());
|
final List<TjOrderDetailRules> list1 = detailRulesService.list(wq1);
|
//放进集合
|
res11.addAll(list1);
|
}
|
//去重收集
|
Map<String, Long> columnCountMap = res11.stream().collect(Collectors.groupingBy(TjOrderDetailRules::getAid, Collectors.counting()));
|
List<Map<String, Object>> aaa = new ArrayList<>();
|
if (columnCountMap != null) {
|
for (Map.Entry<String, Long> entry : columnCountMap.entrySet()) {
|
Map<String, Object> resMap = new HashMap<>();
|
final TjRules byId = rulesService.getById(entry.getKey());
|
if (byId != null) {
|
resMap.put("name", byId.getBingzhong());
|
resMap.put("value", String.valueOf(entry.getValue()));
|
aaa.add(resMap);
|
}
|
}
|
}
|
all.put("data", aaa);
|
return all;
|
|
}
|
|
@GetMapping("/tuanDuiYiChangBySex")
|
@ApiOperation(value = "生成团队体检报告——男女异常结果统计")
|
public Map<String, List<Map<String, Object>>> tuanDuiYiChangBySex(@ApiParam(value = "单位") @RequestParam String dwname) {
|
|
Map<String, List<Map<String, Object>>> all = new HashMap<>();
|
|
LambdaQueryWrapper<TjOrder> wq2 = new LambdaQueryWrapper<>();
|
wq2.eq(TjOrder::getFirmName,dwname);
|
wq2.ne(TjOrder::getTjType, "2");
|
// wq2.in(TjOrder::getStatus, 401, 402);
|
final List<TjOrder> list = tjOrderService.list(wq2);
|
|
List<String> tjNumberList = list.stream().map(TjOrder::getTjNumber).collect(Collectors.toList());
|
|
List<TjOrderDetailRules> res11 = new ArrayList<>();
|
for (TjOrder tjOrder : list) {
|
LambdaQueryWrapper<TjOrderDetailRules> wq1 = new LambdaQueryWrapper<>();
|
wq1.eq(TjOrderDetailRules::getTjNumber, tjOrder.getTjNumber());
|
final List<TjOrderDetailRules> list1 = detailRulesService.list(wq1);
|
//放进集合
|
res11.addAll(list1);
|
}
|
//去重收集
|
Map<String, Long> columnCountMap = res11.stream().collect(Collectors.groupingBy(TjOrderDetailRules::getAid, Collectors.counting()));
|
|
List<Map<String, Object>> aaa = new ArrayList<>();
|
if (columnCountMap != null) {
|
|
for (Map.Entry<String, Long> entry : columnCountMap.entrySet()) {
|
int a = 0;
|
int b = 0;
|
Map<String, Object> resMap = new HashMap<>();
|
final TjRules byId = rulesService.getById(entry.getKey());
|
if (byId != null) {
|
resMap.put("name", byId.getBingzhong());
|
resMap.put("value", entry.getValue().intValue());
|
resMap.put("boy", a);
|
resMap.put("girl", b);
|
resMap.put("value1", 0);
|
resMap.put("boy1", 0);
|
resMap.put("girl1", 0);
|
|
//
|
LambdaQueryWrapper<TjOrderDetailRules> wq11 = new LambdaQueryWrapper<>();
|
wq11.eq(TjOrderDetailRules::getAid, entry.getKey());
|
wq11.in(TjOrderDetailRules::getTjNumber, tjNumberList);
|
final List<TjOrderDetailRules> list1 = detailRulesService.list(wq11);
|
for (TjOrderDetailRules orderDetailRules : list1) {
|
resMap.put("name", orderDetailRules.getBingzhong());
|
if ("0".equals(orderDetailRules.getCusSex())) {
|
a += 1;
|
resMap.put("boy", a);
|
} else if ("1".equals(orderDetailRules.getCusSex())) {
|
b += 1;
|
resMap.put("girl", b);
|
}
|
}
|
aaa.add(resMap);
|
}
|
}
|
}
|
|
//计算百分数
|
for (int i = 0; i < aaa.size(); i++) {
|
final Integer value1 = (Integer) aaa.get(i).get("boy");
|
final Integer value2 = (Integer) aaa.get(i).get("girl");
|
final Integer value = (Integer) aaa.get(i).get("value");
|
if (value != 0) {
|
double percentage = (value1 * 1.0 / value) * 100;
|
NumberFormat nf = NumberFormat.getPercentInstance();
|
nf.setMinimumFractionDigits(2);
|
String percent1 = nf.format(percentage / 100);
|
|
double percentage1 = (value2 * 1.0 / value) * 100;
|
NumberFormat nf1 = NumberFormat.getPercentInstance();
|
nf1.setMinimumFractionDigits(2);
|
String percent2 = nf1.format(percentage1 / 100);
|
|
NumberFormat numberFormat = NumberFormat.getInstance();
|
numberFormat.setMaximumFractionDigits(2);
|
String result = numberFormat.format((float) value1 / (float) value2 * 100);
|
aaa.get(i).put("boy1", percent1);
|
aaa.get(i).put("girl1", percent2);
|
aaa.get(i).put("value1", result);
|
|
}
|
}
|
all.put("data", aaa);
|
return all;
|
|
}
|
|
@GetMapping("/reportHistory")
|
@ApiOperation(value = "历史报告")
|
public AjaxResult reportHistory(Long cusId) {
|
List<TjReport> res = new ArrayList<>();
|
LambdaQueryWrapper<TjOrder> wqq = new LambdaQueryWrapper<>();
|
wqq.like(TjOrder::getUserId, cusId);
|
List<TjOrder> orderList = tjOrderService.list(wqq);
|
if (orderList != null && orderList.size() > 0) {
|
for (TjOrder tjOrder : orderList) {
|
if (tjOrder != null) {
|
LambdaQueryWrapper<TjReport> wq = new LambdaQueryWrapper<>();
|
wq.eq(TjReport::getTjNumber, tjOrder.getTjNumber());
|
wq.eq(TjReport::getType, "体检报告");
|
TjReport one = tjReportService.getOne(wq);
|
if (null != one) {
|
res.add(one);
|
}
|
}
|
}
|
return AjaxResult.success(res);
|
}
|
return AjaxResult.error("暂无历史报告");
|
}
|
}
|
