基于Java语言的zk-sys系统设计源码

package com.byh.sys.web.service.impl; import cn.hutool.core.util.ArrayUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.excel.EasyExcelFactory; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.byh.sys.api.dto.treatmentItem.SysTreatmentChargeDto; import com.byh.sys.api.dto.treatmentItem.SysTreatmentItemDto; import com.byh.sys.api.enums.ApplyGenderEnum; import com.byh.sys.api.enums.ChargeItemSourceEnum; import com.byh.sys.api.enums.MedicalInsuranceCheckStatusEnum; import com.byh.sys.api.enums.StatusEnum; import com.byh.sys.api.excel.CustomMergeStrategy; import com.byh.sys.api.exception.BusinessException; import com.byh.sys.api.model.SysCategorySettingEntity; import com.byh.sys.api.model.chargeCategory.SysChargeCategoryEntity; import com.byh.sys.api.model.chargeItem.SysChargeItemEntity; import com.byh.sys.api.model.department.SysDepartmentEntity; import com.byh.sys.api.model.dict.SysDictValueEntity; import com.byh.sys.api.model.templateManage.SysTemplateManageDetailEntity; import com.byh.sys.api.model.templateManage.SysTemplateManageEntity; import com.byh.sys.api.model.treatmentItem.SysTreatmentChargeEntity; import com.byh.sys.api.model.treatmentItem.SysTreatmentItemEntity; import com.byh.sys.api.util.ExceptionUtils; import com.byh.sys.api.util.StringPinYinUtil; import com.byh.sys.api.util.StringWubiUtil; import com.byh.sys.api.util.UUIDUtils; import com.byh.sys.api.vo.chargeItem.ExportChargeItem; import com.byh.sys.api.vo.treatmentItem.ExportTreatmentCharge; import com.byh.sys.api.vo.treatmentItem.ExportTreatmentItem; import com.byh.sys.api.vo.treatmentItem.SysTreatmentChargeVo; import com.byh.sys.api.vo.treatmentItem.SysTreatmentItemVo; import com.byh.sys.data.repository.*; import com.byh.sys.web.service.SysChargeItemService; import com.byh.sys.web.service.SysTreatmentItemService; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.bouncycastle.jcajce.provider.symmetric.TEA; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.io.InputStream; import java.io.OutputStream; import java.math.BigDecimal; import java.net.URLEncoder; import java.time.LocalDateTime; import java.time.ZoneOffset; import java.time.format.DateTimeFormatter; import java.util.*; import java.util.function.Function; import java.util.stream.Collectors; /** * 诊疗项目 * * @author 魏志俊 * @since 2024-01-25 */ @Service public class SysTreatmentItemServiceImpl extends ServiceImpl<SysTreatmentItemMapper, SysTreatmentItemEntity> implements SysTreatmentItemService { @Resource private SysTreatmentItemMapper sysTreatmentItemMapper; @Resource private SysTreatmentChargeMapper sysTreatmentChargeMapper; @Resource private SysChargeItemMapper sysChargeItemMapper; @Resource private SysTemplateManageMapper sysTemplateManageMapper; @Resource private SysTemplateManageDetailMapper sysTemplateManageDetailMapper; @Resource private SysDictValueMapper sysDictValueMapper; @Resource private SysDepartmentMapper sysDepartmentMapper; @Resource private SysCategorySettingMapper sysCategorySettingMapper; @Autowired private SysChargeItemService sysChargeItemService; private Logger logger = LoggerFactory.getLogger(SysTreatmentItemServiceImpl.class); /** * 导出诊疗项目、诊疗收费关联 * * @param response * @param tenantId * @author 魏志俊 */ @Override public void exportTreatmentItemExcel(HttpServletResponse response, Integer tenantId) { //导出诊疗项目集合 List<ExportTreatmentItem> exportTreatmentItemList = sysTreatmentItemMapper.selectExportList(tenantId); //诊疗项目编号集合 List<Integer> treatmentIds = exportTreatmentItemList.stream() .map(ExportTreatmentItem::getId) .distinct() .collect(Collectors.toList()); //根据诊疗项目编号集合查询导出诊疗、收费项目集合 List<ExportTreatmentCharge> exportTreatmentChargeList = sysTreatmentChargeMapper.selectExportList(treatmentIds); try (OutputStream out = response.getOutputStream()) { response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); //yyyy年MM月dd日HH时mm分ss秒 DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy年MM月dd日HH时mm分ss秒"); String format = LocalDateTime.now(ZoneOffset.ofHours(8)).format(dateTimeFormatter); String fileName = URLEncoder.encode("诊疗项目" + format, "UTF-8").replaceAll("\\+", "%20"); response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); try (ExcelWriter excelWriter = EasyExcelFactory.write(out).build()) { //导出诊疗项目sheet操作 WriteSheet writeSheet1 = EasyExcelFactory.writerSheet(0, "诊疗项目").head(ExportTreatmentItem.class) .build(); excelWriter.write(exportTreatmentItemList, writeSheet1); //导出诊疗收费关联sheet操作（诊疗项目名称、诊疗项目金额，进行单元格合并） WriteSheet writeSheet2 = EasyExcelFactory.writerSheet(1, "诊疗收费关联").head(ExportTreatmentCharge.class) .registerWriteHandler(new CustomMergeStrategy(exportTreatmentChargeList.size(), 0)) .registerWriteHandler(new CustomMergeStrategy(exportTreatmentChargeList.size(), 5)) .build(); excelWriter.write(exportTreatmentChargeList, writeSheet2); } out.flush(); } catch (Exception e) { ExceptionUtils.createException(logger, true, "500", e.getMessage()); } } private static List<String> getTypeList() { List<String> typeList = new ArrayList<>(); //诊疗类别 typeList.add("diagnosis_treatment_type"); //计价单位 typeList.add("charge_unit"); //执行科室标识 typeList.add("execute_dept_flag"); //医保类型编码 typeList.add("medical_insurance_type"); //项目类型 typeList.add("project_type"); //检查类型 typeList.add("examine_type"); //检验类型 typeList.add("inspect_type"); //治疗性质 typeList.add("therapeutic_nature"); //巡诊车（检查类型） typeList.add("patrol_car_examine_type"); //检查部位 typeList.add("examine_position"); //检验标本 typeList.add("specimen"); //关联巡诊车项目 typeList.add("patrol_car_item"); //收费类别 typeList.add("fee_category"); return typeList; } /** * 导入诊疗项目Excel * * @param file * @param tenantId * @param userId * @param userName * @author 魏志俊 */ @Transactional(rollbackFor = BusinessException.class) @Override public void