@RequestMapping(value = "product-exportPart")
public void exportProductLittleList(@RequestParam("ids[]")List<Long> ids, Model model, HttpServletResponse response) {
final String productTemplate = "template/product_template.xls";
try {
final String procuctAllExcelFileName = java.net.URLEncoder.encode("productPart", Constants.DEFAULT_ENCODING);
response.setContentType("application/vnd.ms-excel");
response.setHeader("content-disposition", "attachment;filename=" + procuctAllExcelFileName + ".xls");
List<ProductExportExcelDto> productExcelDataListPart = Lists.newArrayList();
List<Sku> list = skuService.findSkuWithProdAndSupplierByIdIn(ids);
if (list != null && Collections3.isNotEmpty(list)) {
for (final Sku sku : list) {
ProductExportExcelDto productExportExcelDto=new ProductExportExcelDto();
//商品编码
productExportExcelDto.setProdCode(sku.getProduct().getId());
//Sku编码
productExportExcelDto.setSkuCode(sku.getCode());//sku编码
//供应商
productExportExcelDto.setSupplierName(sku.getSupplierName());
//专区名称
if (sku.getProduct().getRegion() != null) {
productExportExcelDto.setRegionName(sku.getProduct().getRegion().getName());//专区名称
}
//商品名称
if(sku.getProduct()!=null) {
productExportExcelDto.setProdName(sku.getProduct().getName());
}
//SKU对应的skuName
productExportExcelDto.setSkuName(sku.getAttribute1()+sku.getAttribute2()+sku.getAttribute3());
//积分
productExportExcelDto.setCent(sku.getCent());
//现金
productExportExcelDto.setUnitPrice(sku.getUnitPrice());
//成本价
productExportExcelDto.setCostPrice(sku.getProPrice());
productExcelDataListPart.add(productExportExcelDto);
}
}
ExcelUtil.getInstance().exportObj2ExcelByTemplate((Map<String, String>) null, productTemplate, response.getOutputStream(), productExcelDataListPart, ProductExportExcelDto.class, Boolean.TRUE);
} catch (Exception ex) {
ex.printStackTrace();
}
}
//导出选中商品
item.on('click', '[data-handle="exportSelectedProd_search"]', function (event) {
var ids = [];
var rows = self.dataGrid.datagrid('getSelections');
if(rows.length<1){
$.messager.alert("提示","请选择至少一项进行提交",'error');
return;
}
for(var i=0; i<rows.length; i++){
ids.push(rows[i].id);
}
$.ajax({
type: 'GET',
url: location.href = ctx+'/admin/sku/product-exportPart?ids[]='+ids+'&_=' + new Date().getTime(),
success:function(data){
},error:function(data){
}
});
});
