| | |
| | | @RequestMapping("/tPayHuimin") |
| | | public class TPayHuiminController extends BaseController { |
| | | |
| | | private static final Integer GIFT_PAYMENT_TYPE = 3; |
| | | |
| | | private String PREFIX = "/system/tPayHuimin/"; |
| | | |
| | | @Autowired |
| | |
| | | item.setStoreName(sb.toString()); |
| | | }); |
| | | } |
| | | String[] titleArr = {"玩湃惠民卡名称", "玩湃惠民卡类型", "售卖金额", "所属运营商", "可用门店", "购买用户", "联系电话", "购买时间", "绑定人员", "已用次数", "有效期", "状态"}; |
| | | String[] titleArr = {"玩湃惠民卡名称", "玩湃惠民卡类型", "订单类型", "售卖金额", "所属运营商", "可用门店", "购买用户", "联系电话", "购买时间", "绑定人员", "已用次数", "有效期", "状态"}; |
| | | String[][] values = new String[records.size()][]; |
| | | for (int i = 0; i < records.size(); i++) { |
| | | SalesDetailVO salesDetailVO = records.get(i); |
| | | values[i] = new String[titleArr.length]; |
| | | values[i][0] = salesDetailVO.getHuiMinName(); |
| | | values[i][1] = salesDetailVO.getHuiMinType() == 1 ? "年度卡" : "年内卡"; |
| | | values[i][2] = salesDetailVO.getSalesMoney().toString(); |
| | | values[i][3] = salesDetailVO.getOperatorName(); |
| | | values[i][4] = salesDetailVO.getStoreName(); |
| | | values[i][5] = salesDetailVO.getUserName(); |
| | | values[i][6] = salesDetailVO.getPhone(); |
| | | values[i][7] = DateUtil.format(salesDetailVO.getPaymentTime(), "yyyy-MM-dd HH:mm:ss"); |
| | | values[i][8] = salesDetailVO.getStudentName(); |
| | | values[i][9] = salesDetailVO.getUseTimes().toString(); |
| | | values[i][10] = DateUtil.format(salesDetailVO.getEndTime(), "yyyy-MM-dd HH:mm:ss"); |
| | | values[i][11] = salesDetailVO.getStatus() == 2 ? "使用中" : "已退款"; |
| | | values[i][2] = GIFT_PAYMENT_TYPE.equals(salesDetailVO.getPaymentType()) ? "赠送" : "售卖"; |
| | | values[i][3] = salesDetailVO.getSalesMoney().toString(); |
| | | values[i][4] = salesDetailVO.getOperatorName(); |
| | | values[i][5] = salesDetailVO.getStoreName(); |
| | | values[i][6] = salesDetailVO.getUserName(); |
| | | values[i][7] = salesDetailVO.getPhone(); |
| | | values[i][8] = DateUtil.format(salesDetailVO.getPaymentTime(), "yyyy-MM-dd HH:mm:ss"); |
| | | values[i][9] = salesDetailVO.getStudentName(); |
| | | values[i][10] = salesDetailVO.getUseTimes().toString(); |
| | | values[i][11] = DateUtil.format(salesDetailVO.getEndTime(), "yyyy-MM-dd HH:mm:ss"); |
| | | values[i][12] = salesDetailVO.getStatus() == 2 ? "使用中" : "已退款"; |
| | | } |
| | | try { |
| | | HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook("售卖明细", titleArr, values, null); |