| | |
| | | values[i][12]=d.get("orderState").toString().equals("1")?"待接单": |
| | | d.get("orderState").toString().equals("2")?"待出发": |
| | | d.get("orderState").toString().equals("3")?"待到达预约地点": |
| | | d.get("orderState").toString().equals("4")?"待取货": |
| | | d.get("orderState").toString().equals("4")?"待乘客上车": |
| | | d.get("orderState").toString().equals("5")?"服务中": |
| | | d.get("orderState").toString().equals("6")?"已送达": |
| | | d.get("orderState").toString().equals("7")?"待支付": |
| | | d.get("orderState").toString().equals("8")?"需补差价": |
| | | d.get("orderState").toString().equals("9")?"已取货": |
| | | d.get("orderState").toString().equals("8")?"待评价": |
| | | d.get("orderState").toString().equals("9")?"已完成": |
| | | d.get("orderState").toString().equals("10")?"已取消": |
| | | d.get("orderState").toString().equals("11")?"改派中": |
| | | d.get("orderState").toString().equals("12")?"已支付差价":""; |
| | | d.get("orderState").toString().equals("12")?"取消待支付":""; |
| | | } |
| | | if(null == d.get("state")){ |
| | | values[i][13]=""; |
| | |
| | | Date date = new Date(); |
| | | DateFormat format = new SimpleDateFormat("yyyyMMdd"); |
| | | String time = format.format(date); |
| | | String fileName = "快车改派"+time+".xls"; |
| | | String fileName = "跨城改派"+time+".xls"; |
| | | String[] title = new String[] {"申请改派时间","申请司机","申请原因","订单编号","下单用户","出发时间","出发地","目的地" |
| | | ,"原服务车辆","改派处罚金","改派服务司机","改派服务车辆","订单当前状态","改派状态"}; |
| | | |
| | |
| | | values[i][12]=d.get("orderState").toString().equals("1")?"待接单": |
| | | d.get("orderState").toString().equals("2")?"待出发": |
| | | d.get("orderState").toString().equals("3")?"待到达预约地点": |
| | | d.get("orderState").toString().equals("4")?"待取货": |
| | | d.get("orderState").toString().equals("4")?"待乘客上车": |
| | | d.get("orderState").toString().equals("5")?"服务中": |
| | | d.get("orderState").toString().equals("6")?"已送达": |
| | | d.get("orderState").toString().equals("7")?"待支付": |
| | | d.get("orderState").toString().equals("8")?"需补差价": |
| | | d.get("orderState").toString().equals("9")?"已取货": |
| | | d.get("orderState").toString().equals("8")?"待评价": |
| | | d.get("orderState").toString().equals("9")?"已完成": |
| | | d.get("orderState").toString().equals("10")?"已取消": |
| | | d.get("orderState").toString().equals("11")?"改派中": |
| | | d.get("orderState").toString().equals("12")?"已支付差价":""; |
| | | d.get("orderState").toString().equals("12")?"取消待支付":""; |
| | | } |
| | | if(null == d.get("state")){ |
| | | values[i][13]=""; |
| | |
| | | } |
| | | |
| | | } |
| | | String fileNameTitle="快车改派"; |
| | | String fileNameTitle="跨城改派"; |
| | | HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime); |
| | | this.setResponseHeader(response, fileName); |
| | | OutputStream os = response.getOutputStream(); |
| | |
| | | Date date = new Date(); |
| | | DateFormat format = new SimpleDateFormat("yyyyMMdd"); |
| | | String time = format.format(date); |
| | | String fileName = "快车改派"+time+".xls"; |
| | | String fileName = "小件物流改派"+time+".xls"; |
| | | String[] title = new String[] {"申请改派时间","申请司机","申请原因","订单编号","下单用户","出发时间","出发地","目的地" |
| | | ,"原服务车辆","改派处罚金","改派服务司机","改派服务车辆","订单当前状态","改派状态"}; |
| | | |
| | |
| | | } |
| | | |
| | | } |
| | | String fileNameTitle="快车改派"; |
| | | String fileNameTitle="小件物流改派"; |
| | | HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime); |
| | | this.setResponseHeader(response, fileName); |
| | | OutputStream os = response.getOutputStream(); |
| | |
| | | Date date = new Date(); |
| | | DateFormat format = new SimpleDateFormat("yyyyMMdd"); |
| | | String time = format.format(date); |
| | | String fileName = "快车改派"+time+".xls"; |
| | | String fileName = "出租车改派"+time+".xls"; |
| | | String[] title = new String[] {"申请改派时间","申请司机","申请原因","订单编号","下单用户","出发时间","出发地","目的地" |
| | | ,"原服务车辆","改派处罚金","改派服务司机","改派服务车辆","订单当前状态","改派状态"}; |
| | | |
| | |
| | | values[i][12]=d.get("orderState").toString().equals("1")?"待接单": |
| | | d.get("orderState").toString().equals("2")?"待出发": |
| | | d.get("orderState").toString().equals("3")?"待到达预约地点": |
| | | d.get("orderState").toString().equals("4")?"待取货": |
| | | d.get("orderState").toString().equals("4")?"待乘客上车": |
| | | d.get("orderState").toString().equals("5")?"服务中": |
| | | d.get("orderState").toString().equals("6")?"已送达": |
| | | d.get("orderState").toString().equals("6")?"完成服务": |
| | | d.get("orderState").toString().equals("7")?"待支付": |
| | | d.get("orderState").toString().equals("8")?"需补差价": |
| | | d.get("orderState").toString().equals("9")?"已取货": |
| | | d.get("orderState").toString().equals("8")?"待评价": |
| | | d.get("orderState").toString().equals("9")?"已完成": |
| | | d.get("orderState").toString().equals("10")?"已取消": |
| | | d.get("orderState").toString().equals("11")?"改派中": |
| | | d.get("orderState").toString().equals("12")?"已支付差价":""; |
| | | d.get("orderState").toString().equals("12")?"取消待支付":""; |
| | | } |
| | | if(null == d.get("state")){ |
| | | values[i][13]=""; |