| Line 176... |
Line 176... |
| 176 |
headerRow.createCell(ReportColumn.MODEL_NUMBER.getValue()).setCellValue("Model Number");
|
176 |
headerRow.createCell(ReportColumn.MODEL_NUMBER.getValue()).setCellValue("Model Number");
|
| 177 |
headerRow.createCell(ReportColumn.COLOR.getValue()).setCellValue("Color");
|
177 |
headerRow.createCell(ReportColumn.COLOR.getValue()).setCellValue("Color");
|
| 178 |
headerRow.createCell(ReportColumn.XFER_PRICE.getValue()).setCellValue("Transfer Price");
|
178 |
headerRow.createCell(ReportColumn.XFER_PRICE.getValue()).setCellValue("Transfer Price");
|
| 179 |
headerRow.createCell(ReportColumn.SELLING_PRICE.getValue()).setCellValue("Selling Price");
|
179 |
headerRow.createCell(ReportColumn.SELLING_PRICE.getValue()).setCellValue("Selling Price");
|
| 180 |
|
180 |
|
| - |
|
181 |
sheet.createRow(serialNo ++);
|
| 181 |
double totalTransferPrice = 0.0;
|
182 |
double totalTransferPrice = 0.0;
|
| 182 |
double totalSellingPrice = 0.0;
|
183 |
double totalSellingPrice = 0.0;
|
| 183 |
|
184 |
|
| 184 |
for(int i = 0; i < orders.size(); i ++) {
|
185 |
for(int i = 0; i < orders.size(); i ++) {
|
| 185 |
Order order = orders.get(i);
|
186 |
Order order = orders.get(i);
|
| 186 |
serialNo ++;
|
187 |
|
| 187 |
Row contentRow = sheet.createRow(serialNo);
|
188 |
Row contentRow = sheet.createRow(serialNo++);
|
| 188 |
|
189 |
|
| 189 |
LineItem lineItem = order.getLineitems().get(0);
|
190 |
LineItem lineItem = order.getLineitems().get(0);
|
| 190 |
double transferPrice = lineItem.getTransfer_price();
|
191 |
double transferPrice = lineItem.getTransfer_price();
|
| 191 |
totalTransferPrice += transferPrice;
|
192 |
totalTransferPrice += transferPrice;
|
| 192 |
|
193 |
|
| 193 |
double sellingPrice = lineItem.getTotal_price();
|
194 |
double sellingPrice = lineItem.getTotal_price();
|
| 194 |
totalSellingPrice += sellingPrice;
|
195 |
totalSellingPrice += sellingPrice;
|
| 195 |
|
196 |
|
| 196 |
contentRow.createCell(ReportColumn.BILLING_NUMBER.getValue()).setCellValue(order.getInvoice_number());
|
197 |
contentRow.createCell(ReportColumn.BILLING_NUMBER.getValue()).setCellValue(order.getInvoice_number());
|
| 197 |
contentRow.createCell(ReportColumn.BILLING_DATE.getValue()).setCellValue(dateFormat.format(new Date(order.getBilling_timestamp())));
|
198 |
contentRow.createCell(ReportColumn.BILLING_DATE.getValue()).setCellValue(dateFormat.format(new Date(order.getBilling_timestamp())));
|
| 198 |
contentRow.createCell(ReportColumn.CUSTOMER_NAME.getValue()).setCellValue(order.getCustomer_name());
|
199 |
contentRow.createCell(ReportColumn.CUSTOMER_NAME.getValue()).setCellValue(order.getCustomer_name());
|
| 199 |
contentRow.createCell(ReportColumn.BRAND.getValue()).setCellValue(getValueForEmptyString(lineItem.getBrand()));
|
200 |
contentRow.createCell(ReportColumn.BRAND.getValue()).setCellValue(getValueForEmptyString(lineItem.getBrand()));
|