| | |
| | | import com.deepoove.poi.plugin.table.LoopRowTableRenderPolicy; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import lombok.RequiredArgsConstructor; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.core.io.ClassPathResource; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | |
| | | .eq(ContractSubjectMatter::getContractId,id)); |
| | | |
| | | if (ArrayUtil.isNotEmpty(subjectMatterList.toArray())) { |
| | | subjectMatterList.stream().forEach(contractSubjectMatter -> { |
| | | for (ContractSubjectMatter contractSubjectMatter: subjectMatterList) { |
| | | if (StrUtil.equals(contract.getExecFrequency(), "1")) { |
| | | Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfWeek(contract.getEffectiveDate()), |
| | | DateUtil.endOfWeek(contract.getExpirationDate()), true); |
| | | DateUtil.endOfWeek(contract.getExpirationDate()), true)+1; |
| | | //循环日期 |
| | | Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfWeek(contract.getEffectiveDate()), contract.getExecDay()); |
| | | for (int i = 0; i < weeksTrue.intValue(); i++) { |
| | |
| | | } |
| | | if (StrUtil.equals(contract.getExecFrequency(), "2")) { |
| | | Long weeksTrue = DateUtil.betweenMonth(DateUtil.beginOfMonth(contract.getEffectiveDate()), |
| | | DateUtil.endOfMonth(contract.getExpirationDate()), true); |
| | | DateUtil.endOfMonth(contract.getExpirationDate()), true)+1; |
| | | //循环日期 |
| | | Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfMonth(contract.getEffectiveDate()), contract.getExecDay()); |
| | | for (int i = 0; i < weeksTrue.intValue(); i++) { |
| | |
| | | } |
| | | } |
| | | if (StrUtil.equals(contract.getExecFrequency(), "3")) { |
| | | Long weeksTrue = DateUtil.betweenMonth(DateUtil.beginOfQuarter(contract.getEffectiveDate()), |
| | | DateUtil.endOfQuarter(contract.getExpirationDate()), true)/3; |
| | | Long weeksTrue = (DateUtil.betweenMonth(DateUtil.beginOfQuarter(contract.getEffectiveDate()), |
| | | DateUtil.endOfQuarter(contract.getExpirationDate()), true)+1)/3; |
| | | |
| | | //循环日期 |
| | | Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfWeek(contract.getExpirationDate()), contract.getExecDay()); |
| | | Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfQuarter(contract.getEffectiveDate()), contract.getExecDay()); |
| | | for (int i = 0; i < weeksTrue.intValue(); i++) { |
| | | Date execDatei = DateUtil.offsetMonth(execDate0, i*3); |
| | | ContractExecDate execDate = new ContractExecDate(); |
| | |
| | | if (7<=endMonth&&endMonth<=12){ |
| | | endDate = DateUtil.endOfYear(endDate); |
| | | } |
| | | Long weeksTrue = DateUtil.betweenMonth(startDate,endDate, true)/6; |
| | | Long weeksTrue = (DateUtil.betweenMonth(startDate,endDate, true)+1)/6; |
| | | //循环日期 |
| | | Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfWeek(contract.getExpirationDate()), contract.getExecDay()); |
| | | Date execDate0 = DateUtil.offsetDay(startDate, contract.getExecDay()); |
| | | for (int i = 0; i < weeksTrue.intValue(); i++) { |
| | | Date execDatei = DateUtil.offsetMonth(execDate0, i*6); |
| | | ContractExecDate execDate = new ContractExecDate(); |
| | |
| | | } |
| | | if (StrUtil.equals(contract.getExecFrequency(), "5")) { |
| | | Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfYear(contract.getEffectiveDate()), |
| | | DateUtil.endOfYear(contract.getExpirationDate()), true); |
| | | DateUtil.endOfYear(contract.getExpirationDate()), true)+1; |
| | | //循环日期 |
| | | Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfYear(contract.getEffectiveDate()), contract.getExecDay()); |
| | | for (int i = 0; i < weeksTrue.intValue(); i++) { |
| | |
| | | } |
| | | } |
| | | |
| | | }); |
| | | } |
| | | } |
| | | } else { |
| | | ContractPaymentSchedule fitstSchedule = contractPaymentScheduleMapper.selectOne(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId()) |
| | |
| | | map.put("items", items); |
| | | //定制方 |
| | | BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId()); |
| | | map.put("companyName", customer.getCompanyName()); |
| | | map.put("companyName", customer.getRegisterName()); |
| | | map.put("legalPerson", customer.getLegalPerson()); |
| | | map.put("contactPhone", customer.getContactPhone()); |
| | | map.put("bankName", customer.getBankName()); |
| | |
| | | map.put("items", items); |
| | | //定制方 |
| | | BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId()); |
| | | map.put("companyName", customer.getCompanyName()); |
| | | map.put("companyName", customer.getRegisterName()); |
| | | map.put("legalPerson", customer.getLegalPerson()); |
| | | map.put("contactPhone", customer.getContactPhone()); |
| | | map.put("bankName", customer.getBankName()); |
| | |
| | | map.put("items", items); |
| | | //定制方 |
| | | BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId()); |
| | | map.put("companyName", customer.getCompanyName()); |
| | | map.put("companyName", customer.getRegisterName()); |
| | | map.put("legalPerson", customer.getLegalPerson()); |
| | | map.put("contactPhone", customer.getContactPhone()); |
| | | map.put("bankName", customer.getBankName()); |
| | |
| | | map.put("items", items); |
| | | //定制方 |
| | | BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId()); |
| | | map.put("companyName", customer.getCompanyName()); |
| | | map.put("companyName", customer.getRegisterName()); |
| | | map.put("legalPerson", customer.getLegalPerson()); |
| | | map.put("contactPhone", customer.getContactPhone()); |
| | | map.put("bankName", customer.getBankName()); |
| | |
| | | Map<String,Object> map = new HashMap<>(); |
| | | map.put("contractId",contract.getId()); |
| | | map.put("contractName",contract.getContractName()); |
| | | map.put("partyA",contract.getPartyA()); |
| | | map.put("partyB",contract.getPartyB()); |
| | | map.put("delayDay",dto.getDelayDay()); |
| | | map.put("applyName",SecurityUtils.getUser().getUsername()); |
| | | map.put("applyTime",DateUtil.format(delayOut.getApplyTime(),DatePattern.NORM_DATETIME_FORMAT)); |
| | |
| | | |
| | | @Override |
| | | public Page pageScope(Page page, ContracQueryDTO queryDTO) { |
| | | |
| | | return baseMapper.pageScope(page,queryDTO, DataScope.of("comp_id")); |
| | | } |
| | | |
| | | @Override |
| | | public void exportContractTFGSGYPMMWord(Long id, HttpServletResponse response) { |
| | | Contract contract = baseMapper.selectById(id); |
| | | List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery() |
| | | .eq(ContractSubjectMatter::getContractId, id).orderByAsc(ContractSubjectMatter::getCreateTime)); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | //合同基本信息 |
| | | map.put("partyA", contract.getPartyA()); |
| | | map.put("partyB", contract.getPartyB()); |
| | | map.put("contractNo", contract.getContractNo()); |
| | | map.put("signPlace", contract.getSignPlace()); |
| | | map.put("signDate", DateUtil.formatDate(contract.getSignDate())); |
| | | map.put("signDateYMD", DateUtil.format(contract.getSignDate(), DatePattern.CHINESE_DATE_PATTERN)); |
| | | map.put("total", contract.getAmount()); |
| | | map.put("amountWords", Convert.digitToChinese(contract.getAmount())); |
| | | //标的物 |
| | | List<Map<String, Object>> items = new ArrayList<>(); |
| | | List<RowRenderData> dataList = new ArrayList<>(); |
| | | AtomicReference<Integer> no = new AtomicReference<>(0); |
| | | subjectMatterList.stream().forEach(contractSubjectMatter -> { |
| | | Map<String, Object> item = new HashMap<>(); |
| | | item.put("materialName", contractSubjectMatter.getMaterialName()); |
| | | item.put("guige", contractSubjectMatter.getSpecification()); |
| | | item.put("unit", contractSubjectMatter.getUnit()); |
| | | item.put("quantity", contractSubjectMatter.getQuantity()); |
| | | item.put("unitPrice", contractSubjectMatter.getUnitPrice()); |
| | | item.put("price", contractSubjectMatter.getTotalAmount()); |
| | | |
| | | items.add(item); |
| | | no.updateAndGet(v -> v + 1); |
| | | }); |
| | | map.put("items", items); |
| | | //定制方 |
| | | BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId()); |
| | | map.put("companyName", customer.getRegisterName()); |
| | | map.put("legalPerson", customer.getLegalPerson()); |
| | | map.put("contactPhone", customer.getContactPhone()); |
| | | map.put("bankName", customer.getBankName()); |
| | | map.put("bankAccount", customer.getBankAccount()); |
| | | |
| | | //承揽方 |
| | | R<SysDept> r = remoteDeptService.getById(contract.getPartyBId()); |
| | | SysDept dept = r.getData(); |
| | | map.put("orgName", dept.getOrgName()); |
| | | map.put("legalPerson1", StrUtil.isNotEmpty(dept.getLegalPerson()) ? dept.getLegalPerson() : ""); |
| | | map.put("entrustedAgent", StrUtil.isNotEmpty(dept.getLegalPerson()) ? "" : dept.getEntrustedAgent()); |
| | | map.put("orgContact", dept.getOrgContact()); |
| | | map.put("orgBank", dept.getOrgBank()); |
| | | map.put("orgBankAccount", dept.getOrgBankAccount()); |
| | | |
| | | //生成文件名 |
| | | Long time = new Date().getTime(); |
| | | // 生成的word格式 |
| | | String formatSuffix = ".docx"; |
| | | // 拼接后的文件名 |
| | | String fileName = time + formatSuffix;//文件名 带后缀 |
| | | //导出word |
| | | try { |
| | | // 1. 加载模版 |
| | | // 假设模版在 resources/templates/template.docx |
| | | ClassPathResource resource = new ClassPathResource("template/tfgs/tfgsgypmmht.docx"); |
| | | // 配置列表策略 |
| | | Configure config = Configure.builder() |
| | | .bind("items", new LoopRowTableRenderPolicy()) // 将 items 绑定到行循环策略 |
| | | .build(); |
| | | // 2. 编译并渲染数据 |
| | | XWPFTemplate xwpfTemplate = XWPFTemplate.compile(resource.getInputStream(), config).render(map); |
| | | |
| | | // 3. 设置响应头 |
| | | response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document"); |
| | | response.setCharacterEncoding("utf-8"); |
| | | response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".docx"); |
| | | |
| | | // 4. 写入输出流 |
| | | OutputStream out = response.getOutputStream(); |
| | | xwpfTemplate.write(out); |
| | | out.flush(); |
| | | out.close(); |
| | | xwpfTemplate.close(); // 重要:关闭模版释放资源 |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | |
| | | } |