| | |
| | | import com.yc.sdk.shopping.action.jiazhuang.ExcelColumnInfo; |
| | | import com.yc.sdk.shopping.action.jiazhuang.ExcelUtil; |
| | | import com.yc.sdk.shopping.service.ShoppingImageIfc; |
| | | import com.yc.sdk.shopping.service.panicBuying.PanicBuyingOrderIfc; |
| | | |
| | | |
| | | @Service("ExportOrderToExcel") |
| | |
| | | orderColumns.add(new ExcelColumnInfo("配送费", "TransCosts",centerStyle,ExcelColumnInfo.SUM_FIELD_SUM,ExcelColumnInfo.DATA_TYPE_DOUBLE)); |
| | | orderColumns.add(new ExcelColumnInfo("配送方式", "FreeName",wrapStyle)); |
| | | orderColumns.add(new ExcelColumnInfo("下单时间", "EnterDate",wrapStyle)); |
| | | orderColumns.add(new ExcelColumnInfo("核销状态", "HeXiaoStatusName",wrapStyle)); |
| | | orderColumns.add(new ExcelColumnInfo("核销/退款状态", "HeXiaoStatusName",wrapStyle)); |
| | | //orderColumns.add(new ExcelColumnInfo("退款状态", "ReturnStatusName",wrapStyle)); //暂时不需要,“核销状态”已包含退款状态 |
| | | orderColumns.add(new ExcelColumnInfo("地址", "FullAddress",wrapStyle)); |
| | | //columns.add(new ExcelColumnInfo("详情", "OPERATION_DETAIL",wrapStyle)); |
| | | //columns.add(new ExcelColumnInfo("备注", "REMARK",wrapStyle)); |
| | |
| | | sellerRankingColumns.add(new ExcelColumnInfo("营销人员名称", "SellerName",wrapStyle)); |
| | | sellerRankingColumns.add(new ExcelColumnInfo("营销人员电话", "SellerTelephone",wrapStyle)); |
| | | sellerRankingColumns.add(new ExcelColumnInfo("订单次数", "OrderCount",centerStyle,ExcelColumnInfo.SUM_FIELD_SUM,ExcelColumnInfo.DATA_TYPE_INTEGER)); |
| | | sellerRankingColumns.add(new ExcelColumnInfo("订单数量", "DigitSum",centerStyle,ExcelColumnInfo.SUM_FIELD_SUM,ExcelColumnInfo.DATA_TYPE_DOUBLE)); |
| | | sellerRankingColumns.add(new ExcelColumnInfo("订单金额", "PayableAmountSum",centerStyle,ExcelColumnInfo.SUM_FIELD_SUM,ExcelColumnInfo.DATA_TYPE_DOUBLE)); |
| | | sellerRankingColumns.add(new ExcelColumnInfo("排名", "Ranking",centerStyle)); |
| | | excelInfo.put("业绩排行", sellerRankingColumns); |
| | |
| | | sheet.setColumnWidth(8, 20*256); |
| | | sheet.setColumnWidth(9, 20*256); |
| | | sheet.setColumnWidth(10, 20*256); |
| | | sheet.setColumnWidth(11, 50*256); |
| | | sheet.setColumnWidth(11, 20*256); |
| | | sheet.setColumnWidth(12, 50*256); |
| | | |
| | | //获取导出数据 |
| | | List<Map<String, Object>> orderList=null; |