| Line 9... |
Line 9... |
| 9 |
import java.util.Calendar;
|
9 |
import java.util.Calendar;
|
| 10 |
import java.util.Date;
|
10 |
import java.util.Date;
|
| 11 |
import java.util.HashMap;
|
11 |
import java.util.HashMap;
|
| 12 |
import java.util.List;
|
12 |
import java.util.List;
|
| 13 |
import java.util.Map;
|
13 |
import java.util.Map;
|
| 14 |
import java.util.SortedSet;
|
- |
|
| 15 |
import java.util.TimeZone;
|
14 |
import java.util.TimeZone;
|
| 16 |
|
15 |
|
| 17 |
import javax.servlet.ServletOutputStream;
|
16 |
import javax.servlet.ServletOutputStream;
|
| 18 |
import javax.servlet.http.HttpServletRequest;
|
17 |
import javax.servlet.http.HttpServletRequest;
|
| 19 |
import javax.servlet.http.HttpServletResponse;
|
18 |
import javax.servlet.http.HttpServletResponse;
|
| Line 232... |
Line 231... |
| 232 |
long diffDays = -99;
|
231 |
long diffDays = -99;
|
| 233 |
affSerialNo++;
|
232 |
affSerialNo++;
|
| 234 |
Row commContentRow = sheet1.createRow(affSerialNo);
|
233 |
Row commContentRow = sheet1.createRow(affSerialNo);
|
| 235 |
|
234 |
|
| 236 |
commContentRow.createCell(0).setCellValue(order.getId());
|
235 |
commContentRow.createCell(0).setCellValue(order.getId());
|
| 237 |
commContentRow.createCell(1).setCellValue(order.isCod() ? "COD" : "PREPAID");
|
236 |
commContentRow.createCell(1).setCellValue(order.isLogisticsCod() ? "COD" : "PREPAID");
|
| 238 |
|
237 |
|
| 239 |
List<LineItem> items = order.getLineitems();
|
238 |
List<LineItem> items = order.getLineitems();
|
| 240 |
String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
|
239 |
String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
|
| 241 |
commContentRow.createCell(2).setCellValue(product);
|
240 |
commContentRow.createCell(2).setCellValue(product);
|
| 242 |
|
241 |
|
| Line 381... |
Line 380... |
| 381 |
for(Order order : orders) {
|
380 |
for(Order order : orders) {
|
| 382 |
affSerialNo++;
|
381 |
affSerialNo++;
|
| 383 |
Row commContentRow = sheet2.createRow(affSerialNo);
|
382 |
Row commContentRow = sheet2.createRow(affSerialNo);
|
| 384 |
|
383 |
|
| 385 |
commContentRow.createCell(0).setCellValue(order.getId());
|
384 |
commContentRow.createCell(0).setCellValue(order.getId());
|
| 386 |
commContentRow.createCell(1).setCellValue(order.isCod() ? "COD" : "PREPAID");
|
385 |
commContentRow.createCell(1).setCellValue(order.isLogisticsCod() ? "COD" : "PREPAID");
|
| 387 |
|
386 |
|
| 388 |
List<LineItem> items = order.getLineitems();
|
387 |
List<LineItem> items = order.getLineitems();
|
| 389 |
String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
|
388 |
String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
|
| 390 |
commContentRow.createCell(2).setCellValue(product);
|
389 |
commContentRow.createCell(2).setCellValue(product);
|
| 391 |
|
390 |
|