| | |
|---|
| | | List<OrderItemSalesNewListDTO> ls = orderItemSalesMapper.selectItemSalesList(null, dto); |
|---|
| | | codeDecorator.decorate(ls); |
|---|
| | | |
|---|
| | | String[] rowsName = new String[]{"集货站", "商品名称", "商品单位", "商品颜色", "商品等级" |
|---|
| | | String[] rowsName = new String[]{"序号", "集货站", "商品名称", "商品单位", "商品颜色", "商品等级" |
|---|
| | | , "商品分类", "收货人", "收货人手机号码", "收货地址", "商品数量", "供应商名称", "商品售价" |
|---|
| | | , "总金额", "订单号", "售后单号", "标题", "申请数量", "理由", "实际退款", "审核结果" |
|---|
| | | , "申请时间", "平台回复"}; |
|---|
| | | List<Object[]> dataList = new ArrayList<>(); |
|---|
| | | |
|---|
| | | int sn = 1; |
|---|
| | | for (OrderItemSalesNewListDTO d : ls) { |
|---|
| | | Object[] objs = new Object[rowsName.length]; |
|---|
| | | int a = 0; |
|---|
| | | objs[a++] = sn; |
|---|
| | | objs[a++] = d.getStationName(); |
|---|
| | | objs[a++] = d.getFlowerName(); |
|---|
| | | objs[a++] = d.getFlowerUnit(); |
|---|
| | |
|---|
| | | objs[a++] = d.getFlowerCategory(); |
|---|
| | | objs[a++] = d.getCustomer(); |
|---|
| | | objs[a++] = d.getCustomerTel(); |
|---|
| | | objs[a++] = d.getCustomerAddress(); |
|---|
| | | objs[a++] = d.getCustomerProvince() + d.getCustomerCity() + d.getCustomerRegion() + d.getCustomerAddress(); |
|---|
| | | objs[a++] = d.getFlowerNum(); |
|---|
| | | objs[a++] = d.getSupplierName(); |
|---|
| | | objs[a++] = d.getPrice(); |
|---|
| | |
|---|
| | | objs[a++] = d.getRemarks(); |
|---|
| | | |
|---|
| | | dataList.add(objs); |
|---|
| | | |
|---|
| | | sn++; |
|---|
| | | } |
|---|
| | | |
|---|
| | | ExcelExportUtil excelExportUtil = new ExcelExportUtil("售后申请列表", rowsName, dataList, response); |
|---|
