欢迎来到Doc100.Net免费学习资源知识分享平台!
您的位置:首页 > 程序异常 >

ireport子表格总结

更新时间: 2014-01-05 03:07:32 责任编辑: Author_N1

 

Ireport子报表总结

实现效果:点击导出后弹出下载框


 

入口:

	public ActionForward printVoucher(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws SystemException {
		HttpSession session = request.getSession();
		Hotelbookheader hbh = (Hotelbookheader)session.getAttribute("adminHotelbookheaderDetails");
		String type = request.getParameter("type");
		log.info("Test output !");
		byte[] voucher = null;
		DynaActionForm updateBookingForm = (DynaActionForm)form;
		if(type != null && "agent".equalsIgnoreCase(type)) {
			hbh = (Hotelbookheader)session.getAttribute("HotelbookheaderDetails");
			voucher =  this.initVoucherPDF(hbh,session,response,updateBookingForm);
			if(voucher != null) {
				this.toPdfbytes(response, voucher,  "voucher.pdf");
			}
			request.setAttribute(MyConstants.MARKETS_KEY, "Save voucher success");
			return mapping.findForward("admindetails");
		}
		
		hbh.setVoucherRemarks(updateBookingForm.getString("voucherRemarks"));
		hbh.setIsAllowAgentReprint(new Byte(updateBookingForm.getString("isAllowAgentReprint")));
		hbh.setRemarks(updateBookingForm.getString("voucherRemarks"));
		String voucherno = updateBookingForm.getString("voucherno");
		String agentxonumber = updateBookingForm.getString("agentxonumber");
				
		AmendBookLogUtils logUtils = new AmendBookLogUtils(request);
		logUtils.log("Voucher","Voucher Issued", hbh.getBookingno(), "");
		//生成pdf
		
		if("dataOnly".equals(updateBookingForm.getString("isPdf"))) {
			voucher =  this.initBlankVoucherPDF(hbh,session,response,updateBookingForm);
		} 
		if("withBackground".equals(updateBookingForm.getString("isPdf"))){
			voucher =  this.initVoucherPDF(hbh,session,response,updateBookingForm);
		}
		if(voucher != null) {
			this.toPdfbytes(response, voucher,  "voucher.pdf");
			hbh.setStatus(MyConstants.Guarantee);
		}		
		hotelbookheaderFacade.update(hbh);
		request.setAttribute(MyConstants.MESSAGE_KEY, "Save voucher success");
		return mapping.findForward("admindetails");
	}
 
private void toPdfbytes(HttpServletResponse response,byte[] bb,String filename) throws SystemException {
		response.reset();
		response.setContentType("APPLICATION/OCTET-STREAM");
		response.setHeader("Content-Disposition","attachment; filename=\"" + filename + "\"");
		response.setContentLength(bb.length);
		try {
			ServletOutputStream ouputStream = response.getOutputStream();
			ouputStream.write(bb, 0, bb.length);
			ouputStream.flush();
			ouputStream.close();
        } catch (IOException e) {
        	e.printStackTrace();
        	throw new SystemException(e.getMessage());
        }
}

 关键地方:

private byte[] initBlankVoucherPDF(Hotelbookheader hbh,HttpSession session,HttpServletResponse response,DynaActionForm updateBookingForm) throws SystemException {
		String path = "WebRoot/images";
		if(session != null)
			path = session.getServletContext().getRealPath("images");
		log.info(path);
		Map readMap = updateBookingForm.getMap();
		
		List<Map<Object, Object>> mapList = new ArrayList<Map<Object,Object>>();
		
		Map<Object, Object> map = new HashMap<Object, Object>();
		map.put("neHotelLogo",path + "\\voucher\\NE_hotel_logo.jpg");
		map.put("neVoucherLogo",path + "\\voucher\\booking.jpg");
		map.put("roomMessage", roomMessage);		
		map.put("extraBed", "Nil");	
		
		//构造两个子报表
		map.put("passengerList", paxList(hbh,map));		
		map.put("items", itemsList(hbh,updateBookingForm));
		
		//mapList是fillReport时的数据源 new JRBeanCollectionDataSource(mapList)
		mapList.add(map);
				
		try {			
			byte[] bb = JasperReportUtil.createPdfByXmlName("ServiceVoucher", mapList, session);
			return bb;
		} catch (JRException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return null;
	}
 

数据源是new JRBeanCollectionDataSource(mapList) ,参数是一个List,List中封装了一个Map,基本数据都放在这个Map中
子报表数据分别放入对应的Map中,再将这些Map封装为一个List,传入数据源List的Map,如 map.put("passengerList", paxList(hbh,map))

 

子报表的数据封装:  

private List itemsList(Hotelbookheader hbh,DynaActionForm updateBookingForm) {
		Set priceDetailsSet = hbh.getHotelbookpricedetails();
		List<HotelRoomPriceVO> list = AdminUpdateOrderUtils.initAdminUpdatePriceListVO(updateBookingForm,priceDetailsSet);
		int num1 = 0;
		int num2 = 0;
		int num3 = 0;

		for(int i =0;i<list.size();i++){
			HotelRoomPriceVO vv = list.get(i);
			if (vv.getAdditionalitem1paxno() != null
					&& !vv.getAdditionalitem1paxno().equals("")) {
				num1+=Integer.parseInt(vv.getAdditionalitem1paxno());	
			}
			if (vv.getAdditionalitem2paxno() != null
					&& !vv.getAdditionalitem2paxno().equals("")) {
				num2+=Integer.parseInt(vv.getAdditionalitem2paxno());	
			}
			if (vv.getAdditionalitem3paxno() != null
					&& !vv.getAdditionalitem3paxno().equals("")) {
				num3+=Integer.parseInt(vv.getAdditionalitem3paxno());
			}			
			
		List lt = new ArrayList();
		
		for(int i =0;i<3;i++){
			HashMap m = new HashMap();
			if(i==0){
				m.put("name", list.get(0).getAdditionalitemname1());
				m.put("num", num1);
			}else if(i == 1){
				m.put("name", list.get(0).getAdditionalitemname2());
				m.put("num", num2);
			}else{
				m.put("name", list.get(0).getAdditionalitemname3());
				m.put("num", num3);
			}
			lt.add(m);
		}		
		return lt;
	}
 

 

public static List<Map<Object, Object>> paxList(Hotelbookheader hbh,Map<Object, Object> map) {
		List<Map<Object,Object>> mapList = new ArrayList<Map<Object, Object>>();
		String roomtype = "";
		String roomcount = "";
		Set paxDetailsSet = hbh.getHotelbookpaxdetails();
		
		for (Iterator iter1 = paxDetailsSet.iterator(); iter1.hasNext();) {
			Map<Object, Object> paxMap = new HashMap<Object,Object>();
			Hotelbookpaxdetail pax = (Hotelbookpaxdetail) iter1.next();
			roomtype = pax.getRoomtype().trim();
			paxMap.put("gender", pax.getGender() == null ? "" : pax.getGender());
			paxMap.put("paxname", pax.getGivenname()+"/" + pax.getSurname());
			
			//一排显示两个
			if(iter1.hasNext()) {
				Hotelbookpaxdetail pax1 = (Hotelbookpaxdetail) iter1.next();
				paxMap.put("gender1", pax1.getGender() == null ? "" : pax1.getGender());
				paxMap.put("paxname1", pax1.getGivenname()+"/" + pax1.getSurname());
			}
			mapList.add(paxMap);
		}		
		return mapList;
	}

 真正导出的部分:

导出Excel只需将JRPdfExporter exporter = new JRPdfExporter(); 换为JExcelApiExporter exporter = new JExcelApiExporter();即可!

public static byte[] createPdfByXmlName(String reportName, List<Map<Object,Object>> mapList,HttpSession session) throws JRException, IOException {
		log.warn("enter createPdfByXmlName");
		String path = "WebRoot/reports";
		if (session != null) {
			path = session.getServletContext().getRealPath("reports");
		}
		JasperReport jasperReport;
		JasperPrint jasperPrint;
		JRPdfExporter exporter = new JRPdfExporter();
		ByteArrayOutputStream oStream = new ByteArrayOutputStream();
		try {
			File file = new File(path + "/" + reportName + ".jasper");
			if (!file.exists()) {
				JasperCompileManager.compileReportToFile(path + "/"+ reportName + ".jrxml",path + "/"+ reportName + ".jasper");
				log.info(reportName + ".jrxml");
			}			
			jasperReport = (JasperReport) JRLoader.loadObject(file);
			Map tempMap = new HashMap();
			tempMap.put("SUBREPORT_DIR", path + "/");
			
			jasperPrint = JasperFillManager.fillReport(jasperReport, tempMap, new JRBeanCollectionDataSource(mapList));
			exporter.setParameter(JRPdfExporterParameter.JASPER_PRINT, jasperPrint);
			exporter.setParameter(JRPdfExporterParameter.CHARACTER_ENCODING,"UTF-8");
			exporter.setParameter(JRPdfExporterParameter.OUTPUT_STREAM, oStream);
			exporter.exportReport();
			byte[] bytes = oStream.toByteArray();
			oStream.close();			
			return bytes;
		}catch(JRException e){
			e.printStackTrace();			
			throw new JRException(e);
		}
	}

 Ireprot中:



 

上图指定子报表路径!


 

此处的$F{items}即为数据源List的Map中封装的子报表的List,与上面对应

另:此处必须使用JRBeanCollectionDataSource的全路径,否则会报错!

 

注意此处items字段的类型为java.util.ArrayList,如图:



注意地方:

子报表大小刚刚放下数据即可,不可留太多空白,子报表页面的大小就是它在父报表中所占的大小!


详细子报表还可参考网上的这个例子:

http://hi.baidu.com/q2881818/blog/item/765cefb3d79e13aed9335ab6.html

上一篇:上一篇
下一篇:下一篇

 

随机推荐程序问答结果

 

 

如对文章有任何疑问请提交到问题反馈,或者您对内容不满意,请您反馈给我们DOC100.NET论坛发贴求解。
DOC100.NET资源网,机器学习分类整理更新日期::2014-01-05 03:07:32
如需转载,请注明文章出处和来源网址:http://www.doc100.net/bugs/t/18642/
本文WWW.DOC100.NET DOC100.NET版权所有。