导出PDF 空白赋值备份
后台代码
//出货清单
@RequestMapping(params="getBusinessOutDetail")
public void getBusinessOutDetail(HttpServletRequest req,HttpServletResponse response,String id,String codes) throws IOException {
String impTypess = req.getParameter("impTypess");//1、打印 2、预览 3、打印并预览
if("1".equals(impTypess)){
response.setHeader("Expires", "0");
response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode("收货清单.pdf" , "UTF-8"));
response.setHeader("Pragma", "public");
response.setContentType("application/pdf");
}
List<BusinessExpressEntity> expList = new ArrayList<>();
StringBuilder code = new StringBuilder("");
String productAllName = "";
String[] arr = codes.split(",");
for (String s : arr) {
BusinessExpressEntity express = systemService.findByProperty(BusinessExpressEntity.class, "shipmentLabelcode",s).get(0);
expList.add(express);
code.append("'" + s + "',");
productAllName += express.getProductName() + ",";
}
String sql = " SELECT e.id,e.business_serveinvoicecode,e.consignee_country,e.product_name,e.business_pieces,e.business_grossweight,e.business_customervolumnweight,e.cargotype_code,group_concat(i.invoice_name SEPARATOR ';' ) as content,SUM(s.total_price) as totalPrice from business_express e \n" +
"LEFT JOIN business_invoice i on i.business_id = e.id\n" +
" LEFT JOIN wms_expenses_payment s on s.business_id = e.id \n" +
" LEFT JOIN business_shipment a on a.id = e.shipment_id \n" +
" where a.shipment_labelcode in ("+code.substring(0,code.length()-1).toString()+") and e.bpm_status!=0 GROUP BY e.id ";
RowMapper<BusinessPdfDTO> rowMapper = new BeanPropertyRowMapper<BusinessPdfDTO>(BusinessPdfDTO.class);
List<BusinessPdfDTO> list = jdbcTemplate.query(sql, rowMapper);
String typeSql = "SELECT * from t_s_type where typegroupid in (SELECT id from t_s_typegroup where typegroupcode= 'cargo')";
List<Map<String, Object>> typeList = jdbcTemplate.queryForList(typeSql);
HashMap typeMap = new HashMap<String, String>();
for (Map<String,Object> temp : typeList) {
typeMap.put(temp.get("typecode").toString(), temp.get("typename").toString());
}
PdfFont font = PdfFontFactory.createFont("STSong-Light", "UniGB-UCS2-H",true);
PdfDocument pdf = new PdfDocument(new PdfWriter(response.getOutputStream()));
Document document = new Document(pdf);
document.add(new Paragraph("出货交接清单").setVerticalAlignment(VerticalAlignment.MIDDLE).setTextAlignment(TextAlignment.CENTER).setFont(font).setFontSize(14));
for (BusinessExpressEntity express : expList) {
document.add(new Paragraph("出货信息："+express.getShipmentLabelcode()+" "+DateUtils.date2Str(new Date(),DateUtils.time_sdf)+" "+express.getCustomerName()).setVerticalAlignment(VerticalAlignment.MIDDLE).setTextAlignment(TextAlignment.LEFT).setFont(font).setFontSize(12));
}
Table table = new Table(new float[]{30,70,70,70,70,70,70,70,70,70});
table.addCell(new Cell().add(new Paragraph("序号")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("转单号")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("产品名称")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("件数")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("类型")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("国家")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("实重")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("体积重")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
//table.addCell(new Cell().add(new Paragraph("应收费用")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("备注")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
//统计包裹
int bg = 0;
//统计文件
int wj = 0;
double weight = 0;
double price = 0;
for (int i=0;i<list.size();i++) {
table.addCell(new Cell().add(new Paragraph((i+1)+"")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph(list.get(i).getBusinessServeinvoicecode())).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph(list.get(i).getProductName())).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph(list.get(i).getBusinessPieces()+"")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
if (typeMap.containsKey(list.get(i).getCargotypeCode())) {
table.addCell(new Cell().add(new Paragraph(typeMap.get(list.get(i).getCargotypeCode()).toString())).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
} else {
table.addCell(new Cell().add(new Paragraph("")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
}
table.addCell(new Cell().add(new Paragraph(list.get(i).getConsigneeCountry())).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph(list.get(i).getBusinessGrossweight()==null?"": DecimalUtil.subData(list.get(i).getBusinessGrossweight()+""))).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph(list.get(i).getBusinessCustomervolumnweight()==null? "":list.get(i).getBusinessCustomervolumnweight()+"")).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
//table.addCell(new Cell().add(new Paragraph(list.get(i).getTotalPrice()==null? "":list.get(i).getTotalPrice())).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
table.addCell(new Cell().add(new Paragraph("配货："+list.get(i).getContent())).setBorder(com.itextpdf.layout.borders.Border.NO_BORDER).setFont(font).setFontSize(9));
if("P".equals(list.get(i).getCargotypeCode())){
bg++;
}
if("D".equals(list.get(i).getCargotypeCode())){
wj++;
}
if (list.get(i).getBusinessGrossweight() != null) {
weight += java.lang.Double.parseDouble(list.get(i).getBusinessGrossweight().toString());
}
if (list.get(i).getTotalPrice() != null) {
price += java.lang.Double.parseDouble(list.get(i).getTotalPrice().toString());
}
}
document.add(table);
document.add(new Paragraph("合计 总票数："+list.size()+" 总实重："+String.format("%.2f", weight)+" 总费用："+price).setFont(font).setFontSize(9));
document.add(new Paragraph("包裹："+bg+" 文件："+wj).setFont(font).setFontSize(9).setMarginTop(-3));
// document.add(new Paragraph(express.getProductName()+" "+list.size()+" 票").setFont(font).setFontSize(9).setMarginTop(-8));
document.add(new Paragraph(productAllName.substring(0,productAllName.length()-1)+" "+list.size()+" 票").setFont(font).setFontSize(9).setMarginTop(-8));
document.add(new Paragraph("请仔细阅读后确认签字：").setFont(font).setFontSize(9).setMaxHeight(15).setMarginTop(-3));
document.add(new Paragraph("快件交接清单上显示的目的地国家仅供参考，正式录单时会再次确认，最终的目的地国家请以客户账单为准。如果发现快件").setFont(font).setFontSize(9).setMarginTop(-8).setMarginLeft(10));
document.add(new Paragraph("交接清单目的地国家有误，请立即告之快件签入人员或与负责贵司查询事务的客户专员联系，谢谢合作").setFont(font).setFontSize(9).setMarginTop(-8));
document.add(new Paragraph("收货公司签字： _________________ "+" "+"我司出货员： _________________").setFont(font).setFontSize(9).setMarginLeft(10));
document.close();
pdf.close();
}
前台代码：
function printQD() { var rowsData = $('#businessArrivalList').datagrid('getSelections'); if(rowsData.length==0){ tip("请选择数据"); return false; }else if(rowsData.length>1){ tip("只能选择一个数据"); return false; } var xueurl = "fileFormatController.do?getXbDetail_print&id=&codes=" + rowsData[0].arrivalLabelcode; $.messager.defaults = { ok: "确定", cancel: "取消" }; const html = '<p id="p"><label for="r">请选择打印方式</label></p><p id="p">' + ' <label for="r"><input type="radio" id="r" name="impTypess" value="1" checked>' + ' 直接打印</label>' + ' <label for="r1"><input type="radio" id="r1" name="impTypess" value="2">' + ' 预览</label></p> </p>' + ' <label for="r2"><input type="radio" id="r2" name="impTypess" value="3" >' + ' 打印并预览</label></p> </p>' $.messager.confirm("请选择打印方式", html, function (data) { if (data) { var impTypess = $("input[name='impTypess']:checked ").val(); xueurl+='&impTypess='+impTypess; if(impTypess=='2'){//预览 window.open(xueurl); }else if(impTypess=='3'){//预览并打印 window.open(xueurl); window.location.href = 'fileFormatController.do?getXbDetail_print&id=&codes=' + rowsData[0].arrivalLabelcode+'&impTypess=1'; }else if(impTypess=='1'){//打印 window.location.href = 'fileFormatController.do?getXbDetail_print&id=&codes=' + rowsData[0].arrivalLabelcode+'&impTypess=1'; } } }); //window.location.href = "fileFormatController.do?getXbDetail_print&id=&codes=" + rowsData[0].arrivalLabelcode+"&ylFlag=0"; }
效果：
浙公网安备 33010602011771号