grid report 多条数据连打印

1、     获取数据:

          @RequestMapping("/electronicSheet")
@ResponseBody
public String electronicSheet() {
Map<String, Object> map = new HashMap<String, Object>();
try{
map.put("Master", reportService.findElectronicSheetDetail(col));
}catch(Exception e){
Log.getLogger(getClass()).error("打印电子面单(单个)异常(ReportController——>electronicSheet):" + e.getMessage());
}
return toJson(map);
}


2、 sql:

<select id="findElectronicSheetDetail" parameterType="com.wlyd.fmcgwms.util.CondOrderLimit" resultType="java.util.Map">
select distinct 
o.WMOO_ID,
o.WMOO_CODE,
o.WMOO_WAREHOUSE_CODE,
o.WMOO_WASS_CODE,
o.WMOO_SOURCE,
o.WMOO_REMARK,
o.WMOO_ELECTRONIC_SHEET_NO,
c.CDST_CUSTOMER_CODE wmooCustomerCode,
o.WMOO_RECEIVER,
o.WMOO_RECEIVER_PHONE,
o.WMOO_RECEIVER_ADDRESS,
ca.EB_CARRIER_SHORTNAME wmooModelName,
o.WMOO_SENDER,
o.WMOO_SENDER_ADDRESS,
o.WMOO_SENDER_CONTACT,
o.WMOO_SENDER_PROVINCE,
o.WMOO_SENDER_CITY,
o.WMOO_SENDER_COUNT,
o.WMOO_RECEIVER_PROVINCE,
o.WMOO_RECEIVER_CITY,
o.WMOO_RECEIVER_COUNT,
   case when o.WMOO_PRINT_COUNT is null then 1
else o.WMOO_PRINT_COUNT+1
end as wmooPrintCount,
case when (o.WMOO_RECEIVER_CITY like '%重庆%' or o.WMOO_RECEIVER_CITY like '%北京%' or o.WMOO_RECEIVER_CITY like '%上海%' or o.WMOO_RECEIVER_CITY like '%天津%') then o.WMOO_RECEIVER_CITY
else CONCAT(o.WMOO_RECEIVER_PROVINCE,' ',o.WMOO_RECEIVER_CITY)
end as destination,
o.WMOO_SOURCE_ORDERNO,
o.WMOO_SOURCE_STORE
  from wm_out_order_${conditions.companyCode} o
  left join eb_carrier_${conditions.companyCode} ca on ca.EB_CARRIER_CODE = o.WMOO_ACTUALLY_CARRIER_CODE
left join cd_customer_${conditions.companyCode} c on c.CDST_CUSTOMER_NAME = o.WMOO_CUSTOMER_NAME
where 1=1 
<if test="conditions.wmooCode!=null and conditions.wmooCode!=''">
and o.WMOO_CODE = #{conditions.wmooCode,jdbcType=VARHR}
</if>
</select>

3、模板设计:

grid report 多条数据连打印

4、分组头设置分组字段:

grid report 多条数据连打印

5、分组设置分页:

grid report 多条数据连打印

6、面单纸张的高度和内容行的高度一致,否则可能会导致面单纸张打印的内容不全

如面单纸张是10*15,则页面设置为

grid report 多条数据连打印

内容行高度也设置为15

grid report 多条数据连打印

内容行中的表格填满整个内容行,这样就不会显示不全了