Subversion Repositories SmartDukaan

Rev

Rev 5354 | Rev 5554 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5354 Rev 5428
Line 189... Line 189...
189 
        sheet1.addMergedRegion(new CellRangeAddress(3, 3, 0, 6));
 189 
        sheet1.addMergedRegion(new CellRangeAddress(3, 3, 0, 6));
190
190
191 
        sheet1.createRow(affSerialNo ++);sheet1.createRow(affSerialNo ++);
 191 
        sheet1.createRow(affSerialNo ++);sheet1.createRow(affSerialNo ++);
192
192
193 
        Row affHeaderRow = sheet1.createRow(affSerialNo++);
 193 
        Row affHeaderRow = sheet1.createRow(affSerialNo++);
- 
 
 194
194 
        affHeaderRow.createCell(0).setCellValue("Order Id");
 195 
        affHeaderRow.createCell(0).setCellValue("Order Id");
195 
        affHeaderRow.createCell(1).setCellValue("Payment Type");
 196 
        affHeaderRow.createCell(1).setCellValue("Payment Type");
196 
        affHeaderRow.createCell(2).setCellValue("Pincode");
 197 
        affHeaderRow.createCell(2).setCellValue("Product Name");
197 
        affHeaderRow.createCell(3).setCellValue("City");
 198 
        affHeaderRow.createCell(3).setCellValue("AWB");
198 
        affHeaderRow.createCell(4).setCellValue("Logistics Provider");
 199 
        affHeaderRow.createCell(4).setCellValue("Pincode");
199 
        affHeaderRow.createCell(5).setCellValue("Shipping Date");
 200 
        affHeaderRow.createCell(5).setCellValue("City");
200 
        affHeaderRow.createCell(6).setCellValue("Delivery Date");
 201 
        affHeaderRow.createCell(6).setCellValue("Logistics Provider");
201 
        affHeaderRow.createCell(7).setCellValue("Expected Delivery Date");
 202 
        affHeaderRow.createCell(7).setCellValue("Order Created Date");
202 
        affHeaderRow.createCell(8).setCellValue("Delay");
 203 
        affHeaderRow.createCell(8).setCellValue("Promised Shipping Date");
203
- 
 
204 
        affHeaderRow.createCell(9).setCellValue("First Delivery Attempt");
 204 
        affHeaderRow.createCell(9).setCellValue("Shipping Date");
205 
        affHeaderRow.createCell(10).setCellValue("First Attempt Delay");
 205 
        affHeaderRow.createCell(10).setCellValue("First Delivery Attempt");
206 
 
 - 
 
207 
        affHeaderRow.createCell(11).setCellValue("Promised Delivery Date");
 206 
        affHeaderRow.createCell(11).setCellValue("Promised Delivery Date");
208 
        affHeaderRow.createCell(12).setCellValue("Order Created Date");
 207 
        affHeaderRow.createCell(12).setCellValue("Expected Delivery Date");
209 
        affHeaderRow.createCell(13).setCellValue("Promised Shipping Date");
 208 
        affHeaderRow.createCell(13).setCellValue("RTO Declare date");
210 
        affHeaderRow.createCell(14).setCellValue("Return Receive Date");
 209 
        affHeaderRow.createCell(14).setCellValue("Return Receive Date");
211 
        affHeaderRow.createCell(15).setCellValue("Product Name");
 210 
        affHeaderRow.createCell(15).setCellValue("RTO Refund Date");
212 
        affHeaderRow.createCell(16).setCellValue("AWB");
 211 
        affHeaderRow.createCell(16).setCellValue("RTO Reship Date");
213
212
- 
 
 213 
        affHeaderRow.createCell(17).setCellValue("Shipping to Return Time");
- 
 
 214 
        affHeaderRow.createCell(18).setCellValue("First Attempt Delay");
- 
 
 215
214 
        for (int i=0; i<17 ;i++) {
 216 
        for (int i=0; i<19 ;i++) {
215 
            affHeaderRow.getCell(i).setCellStyle(style);
 217 
            affHeaderRow.getCell(i).setCellStyle(style);
216 
        }
 218 
        }
217
219
218 
        try {
 220 
        try {
219 
            TransactionClient tc = new TransactionClient();
 221 
            TransactionClient tc = new TransactionClient();
Line 225... Line 227...
225 
            // TODO Auto-generated catch block
 227 
            // TODO Auto-generated catch block
226 
            e.printStackTrace();
 228 
            e.printStackTrace();
227 
        }
 229 
        }
228 
 
 230 
 
229 
        for(Order order : orders) {
 231 
        for(Order order : orders) {
230 
            boolean deliveryTimestampSet = false;
 - 
 
231 
            long diffDays = -99;
 232 
            long diffDays = -99;
232
- 
 
233 
            if (order.getDelivery_timestamp() != 0) {
 - 
 
234 
                deliveryTimestampSet = true;
 - 
 
235 
                diffDays = GetDelayinDays(order.getDelivery_timestamp(), order.getExpected_delivery_time());
 - 
 
236 
            }
 - 
 
237
- 
 
238 
            affSerialNo++;
 233 
            affSerialNo++;
239 
            Row commContentRow = sheet1.createRow(affSerialNo);
 234 
            Row commContentRow = sheet1.createRow(affSerialNo);
- 
 
 235
240 
            commContentRow.createCell(0).setCellValue(order.getId());
 236 
            commContentRow.createCell(0).setCellValue(order.getId());
241 
            commContentRow.createCell(1).setCellValue(order.isCod() ? "COD" : "PREPAID");
 237 
            commContentRow.createCell(1).setCellValue(order.isCod() ? "COD" : "PREPAID");
242 
            commContentRow.createCell(2).setCellValue(order.getCustomer_pincode());
 238
243 
            commContentRow.createCell(3).setCellValue(order.getCustomer_city());
 239 
            List<LineItem> items = order.getLineitems();
244 
            commContentRow.createCell(4).setCellValue(logisticProviderMap.get(order.getLogistics_provider_id()));
 240 
            String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
245 
            commContentRow.createCell(5).setCellValue(new Date(order.getShipping_timestamp()));
 241 
            commContentRow.createCell(2).setCellValue(product);
- 
 
 242
246 
            commContentRow.getCell(5).setCellStyle(dateCellStyle);
 243 
            commContentRow.createCell(3).setCellValue(order.getAirwaybill_no());
247 
            if (deliveryTimestampSet) {
 - 
 
248 
                commContentRow.createCell(6).setCellValue(new Date(order.getDelivery_timestamp()));
 244 
            commContentRow.createCell(4).setCellValue(order.getCustomer_pincode());
249 
                commContentRow.getCell(6).setCellStyle(dateCellStyle);
 245 
            commContentRow.createCell(5).setCellValue(order.getCustomer_city());
250 
            } else {
 - 
 
251 
                commContentRow.createCell(6).setCellValue("N/A");
 246 
            commContentRow.createCell(6).setCellValue(logisticProviderMap.get(order.getLogistics_provider_id()));
252 
            }
 247
253 
            commContentRow.createCell(7).setCellValue(new Date(order.getExpected_delivery_time()));
 248 
            commContentRow.createCell(7).setCellValue(new Date(order.getCreated_timestamp()));
254 
            commContentRow.getCell(7).setCellStyle(dateCellStyle);
 249 
            commContentRow.getCell(7).setCellStyle(dateCellStyle);
255 
            if (diffDays == -99) {
 - 
 
256 
                commContentRow.createCell(8).setCellValue("N/A");
 - 
 
257 
            } else {
 - 
 
258 
                commContentRow.createCell(8).setCellValue(diffDays);
 - 
 
259 
            }
 - 
 
260
250
- 
 
 251 
            commContentRow.createCell(8).setCellValue(new Date(order.getPromised_shipping_time()));
- 
 
 252 
            commContentRow.getCell(8).setCellStyle(dateCellStyle);
- 
 
 253
261 
            commContentRow.createCell(9).setCellValue(new Date(order.getFirst_attempt_timestamp()));
 254 
            commContentRow.createCell(9).setCellValue(new Date(order.getShipping_timestamp()));
262 
            commContentRow.getCell(9).setCellStyle(dateCellStyle);
 255 
            commContentRow.getCell(9).setCellStyle(dateCellStyle);
263
256
264 
            if (order.getFirst_attempt_timestamp() != 0) {
 257 
            if (order.getFirst_attempt_timestamp() != 0) {
265 
                commContentRow.createCell(9).setCellValue(new Date(order.getFirst_attempt_timestamp()));
 258 
                commContentRow.createCell(10).setCellValue(new Date(order.getFirst_attempt_timestamp()));
266 
                commContentRow.getCell(9).setCellStyle(dateCellStyle);
 259 
                commContentRow.getCell(10).setCellStyle(dateCellStyle);
267
- 
 
268 
                diffDays = GetDelayinDays(order.getFirst_attempt_timestamp(), order.getExpected_delivery_time());
 - 
 
269 
                commContentRow.createCell(10).setCellValue(diffDays);
 - 
 
270 
            } else {
 260 
            } else {
271 
                commContentRow.createCell(9).setCellValue("N/A");
 - 
 
272 
                commContentRow.createCell(10).setCellValue("N/A");
 261 
                commContentRow.createCell(10).setCellValue("N/A");
273 
            }
 262 
            }
274
263
275 
            commContentRow.createCell(11).setCellValue(new Date(order.getPromised_delivery_time()));
 264 
            commContentRow.createCell(11).setCellValue(new Date(order.getPromised_delivery_time()));
276 
            commContentRow.getCell(11).setCellStyle(dateCellStyle);
 265 
            commContentRow.getCell(11).setCellStyle(dateCellStyle);
- 
 
 266
277 
            commContentRow.createCell(12).setCellValue(new Date(order.getCreated_timestamp()));
 267 
            commContentRow.createCell(12).setCellValue(new Date(order.getExpected_delivery_time()));
278 
            commContentRow.getCell(12).setCellStyle(dateCellStyle);
 268 
            commContentRow.getCell(12).setCellStyle(dateCellStyle);
279 
            commContentRow.createCell(13).setCellValue(new Date(order.getPromised_shipping_time()));
 - 
 
280 
            commContentRow.getCell(13).setCellStyle(dateCellStyle);
 - 
 
281 
            commContentRow.createCell(14).setCellValue(new Date(order.getReceived_return_timestamp()));
 - 
 
282 
            commContentRow.getCell(14).setCellStyle(dateCellStyle);
 - 
 
283
269
284 
            List<LineItem> items = order.getLineitems();
 270 
            if (order.getDelivery_timestamp() != 0) {
- 
 
 271 
                //When our courier partners declare a shipment as RTO we mark that time as delivered timestamp in our DB.
285 
            String product = items.get(0).getBrand() + " " + ((items.get(0).getModel_name() == null)? "" : items.get(0).getModel_name()) + " " + items.get(0).getModel_number();
 272 
                commContentRow.createCell(13).setCellValue(new Date(order.getDelivery_timestamp()));//This is actually RTO Declare date.
- 
 
 273 
                commContentRow.getCell(13).setCellStyle(dateCellStyle);
- 
 
 274 
            } else {
- 
 
 275 
                commContentRow.createCell(13).setCellValue("N/A");
- 
 
 276 
            }
- 
 
 277
- 
 
 278 
            if (order.getReceived_return_timestamp() != 0) {
- 
 
 279 
                commContentRow.createCell(14).setCellValue(new Date(order.getReceived_return_timestamp()));
- 
 
 280 
                commContentRow.getCell(14).setCellStyle(dateCellStyle);
- 
 
 281 
            } else {
- 
 
 282 
                commContentRow.createCell(14).setCellValue("N/A");
- 
 
 283 
            }
- 
 
 284
- 
 
 285 
            if (order.getRefund_timestamp() != 0) {
- 
 
 286 
                commContentRow.createCell(15).setCellValue(new Date(order.getRefund_timestamp()));
- 
 
 287 
                commContentRow.getCell(15).setCellStyle(dateCellStyle);
- 
 
 288 
            } else {
286 
            commContentRow.createCell(15).setCellValue(product);
 289 
                commContentRow.createCell(15).setCellValue("N/A");
- 
 
 290 
            }
- 
 
 291
- 
 
 292 
            if (order.getReship_timestamp() != 0) {
287 
            commContentRow.createCell(16).setCellValue(order.getAirwaybill_no());
 293 
                commContentRow.createCell(16).setCellValue(new Date(order.getReship_timestamp()));
- 
 
 294 
                commContentRow.getCell(16).setCellStyle(dateCellStyle);
- 
 
 295 
            } else {
- 
 
 296 
                commContentRow.createCell(16).setCellValue("N/A");
- 
 
 297 
            }
- 
 
 298
- 
 
 299 
            long delayInShipping = GetDelayinDays(order.getShipping_timestamp(), order.getPromised_shipping_time());
- 
 
 300
- 
 
 301 
            if (order.getReceived_return_timestamp() != 0) {
- 
 
 302 
                diffDays = GetDelayinDays(order.getReceived_return_timestamp(), order.getShipping_timestamp());
- 
 
 303 
                commContentRow.createCell(17).setCellValue(diffDays);
- 
 
 304 
            } else {
- 
 
 305 
                commContentRow.createCell(17).setCellValue("N/A");
- 
 
 306 
            }
- 
 
 307
- 
 
 308 
            if (order.getFirst_attempt_timestamp() != 0) {
- 
 
 309 
                diffDays = GetDelayinDays(order.getFirst_attempt_timestamp(), order.getExpected_delivery_time());
- 
 
 310 
                commContentRow.createCell(18).setCellValue(diffDays - delayInShipping);
- 
 
 311 
            } else {
- 
 
 312 
                commContentRow.createCell(18).setCellValue("N/A");
- 
 
 313 
            }
288 
        }
 314 
        }
289 
        for (int i = 0; i<17; i++) {
 315 
        for (int i = 0; i<19; i++) {
290 
            sheet1.autoSizeColumn(i);
 316 
            sheet1.autoSizeColumn(i);
291 
        }
 317 
        }
292 
    }
 318 
    }
293
319
294 
    private void createDeliveredSheet(Workbook wb,
320 
    private void createDeliveredSheet(Workbook wb,
Line 317... Line 343...
317 
        sheet2.createRow(affSerialNo ++);sheet2.createRow(affSerialNo ++);
 343 
        sheet2.createRow(affSerialNo ++);sheet2.createRow(affSerialNo ++);
318 
 
 344 
 
319 
        Row affHeaderRow = sheet2.createRow(affSerialNo++);
 345 
        Row affHeaderRow = sheet2.createRow(affSerialNo++);
320 
        affHeaderRow.createCell(0).setCellValue("Order Id");
 346 
        affHeaderRow.createCell(0).setCellValue("Order Id");
321 
        affHeaderRow.createCell(1).setCellValue("Payment Type");
 347 
        affHeaderRow.createCell(1).setCellValue("Payment Type");
322 
        affHeaderRow.createCell(2).setCellValue("Pincode");
 348 
        affHeaderRow.createCell(2).setCellValue("Product Name");
323 
        affHeaderRow.createCell(3).setCellValue("City");
 349 
        affHeaderRow.createCell(3).setCellValue("AWB");
324 
        affHeaderRow.createCell(4).setCellValue("Logistics Provider");
 350 
        affHeaderRow.createCell(4).setCellValue("Pincode");
325 
        affHeaderRow.createCell(5).setCellValue("Shipping Date");
 351 
        affHeaderRow.createCell(5).setCellValue("City");
326 
        affHeaderRow.createCell(6).setCellValue("Delivery Date");
 352 
        affHeaderRow.createCell(6).setCellValue("Logistics Provider");
327 
        affHeaderRow.createCell(7).setCellValue("Expected Delivery Date");
 353 
        affHeaderRow.createCell(7).setCellValue("Order Created Date");
328 
        affHeaderRow.createCell(8).setCellValue("Delay");
 354 
        affHeaderRow.createCell(8).setCellValue("Promised Shipping Date");
329
- 
 
330 
        affHeaderRow.createCell(9).setCellValue("First Delivery Attempt");
 355 
        affHeaderRow.createCell(9).setCellValue("Shipping Date");
331 
        affHeaderRow.createCell(10).setCellValue("First Attempt Delay");
 356 
        affHeaderRow.createCell(10).setCellValue("First Delivery Attempt");
332 
 
 - 
 
333
- 
 
334 
        affHeaderRow.createCell(11).setCellValue("Promised Delivery Date");
 357 
        affHeaderRow.createCell(11).setCellValue("Promised Delivery Date");
335 
        affHeaderRow.createCell(12).setCellValue("Order Created Date");
 358 
        affHeaderRow.createCell(12).setCellValue("Expected Delivery Date");
336 
        affHeaderRow.createCell(13).setCellValue("Promised Shipping Date");
 359 
        affHeaderRow.createCell(13).setCellValue("Delivery Date");
- 
 
 360
337 
        affHeaderRow.createCell(14).setCellValue("Product Name");
 361 
        affHeaderRow.createCell(14).setCellValue("Delay");
338 
        affHeaderRow.createCell(15).setCellValue("AWB");
 362 
        affHeaderRow.createCell(15).setCellValue("First Attempt Delay");
339 
 
 363 
 
340 
        for (int i=0; i<16 ;i++) {
 364 
        for (int i=0; i<16 ;i++) {
341 
            affHeaderRow.getCell(i).setCellStyle(style);
 365 
            affHeaderRow.getCell(i).setCellStyle(style);
342 
        }
 366 
        }
343 
 
 367 
 
Line 353... Line 377...
353 
            // TODO Auto-generated catch block
 377 
            // TODO Auto-generated catch block
354 
            e.printStackTrace();
 378 
            e.printStackTrace();
355 
        }
 379 
        }
356 
 
 380 
 
357 
        for(Order order : orders) {
 381 
        for(Order order : orders) {
358 
            long diffDays = GetDelayinDays(order.getDelivery_timestamp(), order.getExpected_delivery_time());
 - 
 
359 
            affSerialNo++;
 382 
            affSerialNo++;
360 
            Row commContentRow = sheet2.createRow(affSerialNo);
 383 
            Row commContentRow = sheet2.createRow(affSerialNo);
- 
 
 384
361 
            commContentRow.createCell(0).setCellValue(order.getId());
 385 
            commContentRow.createCell(0).setCellValue(order.getId());
362 
            commContentRow.createCell(1).setCellValue(order.isCod() ? "COD" : "PREPAID");
 386 
            commContentRow.createCell(1).setCellValue(order.isCod() ? "COD" : "PREPAID");
- 
 
 387
363 
            commContentRow.createCell(2).setCellValue(order.getCustomer_pincode());
 388 
            List<LineItem> items = order.getLineitems();
- 
 
 389 
            String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
364 
            commContentRow.createCell(3).setCellValue(order.getCustomer_city());
 390 
            commContentRow.createCell(2).setCellValue(product);
- 
 
 391
365 
            commContentRow.createCell(4).setCellValue(logisticProviderMap.get(order.getLogistics_provider_id()));
 392 
            commContentRow.createCell(3).setCellValue(order.getAirwaybill_no());
366 
            commContentRow.createCell(5).setCellValue(new Date(order.getShipping_timestamp()));
 393 
            commContentRow.createCell(4).setCellValue(order.getCustomer_pincode());
367 
            commContentRow.getCell(5).setCellStyle(dateCellStyle);
 394 
            commContentRow.createCell(5).setCellValue(order.getCustomer_city());
368 
            commContentRow.createCell(6).setCellValue(new Date(order.getDelivery_timestamp()));
 395 
            commContentRow.createCell(6).setCellValue(logisticProviderMap.get(order.getLogistics_provider_id()));
369 
            commContentRow.getCell(6).setCellStyle(dateCellStyle);
 396
370 
            commContentRow.createCell(7).setCellValue(new Date(order.getExpected_delivery_time()));
 397 
            commContentRow.createCell(7).setCellValue(new Date(order.getCreated_timestamp()));
371 
            commContentRow.getCell(7).setCellStyle(dateCellStyle);
 398 
            commContentRow.getCell(7).setCellStyle(dateCellStyle);
372 
            commContentRow.createCell(8).setCellValue(diffDays);
 - 
 
373
399
- 
 
 400 
            if (order.getPromised_shipping_time() != 0) {
- 
 
 401 
                commContentRow.createCell(8).setCellValue(new Date(order.getPromised_shipping_time()));
- 
 
 402 
                commContentRow.getCell(8).setCellStyle(dateCellStyle);
- 
 
 403 
            } else {
- 
 
 404 
                commContentRow.createCell(8).setCellValue("N/A");
- 
 
 405 
            }
- 
 
 406
374 
            commContentRow.createCell(9).setCellValue(new Date(order.getFirst_attempt_timestamp()));
 407 
            commContentRow.createCell(9).setCellValue(new Date(order.getShipping_timestamp()));
375 
            commContentRow.getCell(9).setCellStyle(dateCellStyle);
 408 
            commContentRow.getCell(9).setCellStyle(dateCellStyle);
376
409
377 
            diffDays = GetDelayinDays(order.getFirst_attempt_timestamp(), order.getExpected_delivery_time());
 410 
            if (order.getFirst_attempt_timestamp() != 0) {
- 
 
 411 
                commContentRow.createCell(10).setCellValue(new Date(order.getFirst_attempt_timestamp()));
- 
 
 412 
                commContentRow.getCell(10).setCellStyle(dateCellStyle);
- 
 
 413 
            } else {
378 
            commContentRow.createCell(10).setCellValue(diffDays);
 414 
                commContentRow.createCell(10).setCellValue("N/A");
379 
 
 415 
            }
380
416
381 
            commContentRow.createCell(11).setCellValue(new Date(order.getPromised_delivery_time()));
 417 
            commContentRow.createCell(11).setCellValue(new Date(order.getPromised_delivery_time()));
382 
            commContentRow.getCell(11).setCellStyle(dateCellStyle);
 418 
            commContentRow.getCell(11).setCellStyle(dateCellStyle);
383 
            commContentRow.createCell(12).setCellValue(new Date(order.getCreated_timestamp()));
 - 
 
384 
            commContentRow.getCell(12).setCellStyle(dateCellStyle);
 - 
 
385 
            commContentRow.createCell(13).setCellValue(new Date(order.getPromised_shipping_time()));
 - 
 
386 
            commContentRow.getCell(13).setCellStyle(dateCellStyle);
 - 
 
387
419
388 
            List<LineItem> items = order.getLineitems();
 420 
            if (order.getDelivery_timestamp() != 0) {
389 
            String product = items.get(0).getBrand() + " " + items.get(0).getModel_name() + " " + items.get(0).getModel_number();
 421 
                commContentRow.createCell(12).setCellValue(new Date(order.getExpected_delivery_time()));
- 
 
 422 
                commContentRow.getCell(12).setCellStyle(dateCellStyle);
- 
 
 423 
            } else {
- 
 
 424 
                commContentRow.createCell(12).setCellValue("N/A");
- 
 
 425 
            }
- 
 
 426
- 
 
 427 
            if (order.getDelivery_timestamp() != 0) {
- 
 
 428 
                commContentRow.createCell(13).setCellValue(new Date(order.getDelivery_timestamp()));
- 
 
 429 
                commContentRow.getCell(13).setCellStyle(dateCellStyle);
- 
 
 430 
            } else {
- 
 
 431 
                commContentRow.createCell(13).setCellValue("N/A");
- 
 
 432 
            }
390
433
- 
 
 434
- 
 
 435 
            //We are subtracting delay due to shipping from delay in delivery as it was not courier's
- 
 
 436 
            //fault that the shipment was delayed
- 
 
 437
- 
 
 438 
            long delayInShipping = 0;
- 
 
 439 
            long diffDays = GetDelayinDays(order.getDelivery_timestamp(), order.getExpected_delivery_time());
- 
 
 440
- 
 
 441 
            if (order.getPromised_shipping_time() != 0) {
- 
 
 442 
                delayInShipping = GetDelayinDays(order.getShipping_timestamp(), order.getPromised_shipping_time());
- 
 
 443 
                commContentRow.createCell(14).setCellValue(diffDays - delayInShipping);
- 
 
 444 
            } else {
391 
            commContentRow.createCell(14).setCellValue(product);
 445 
                commContentRow.createCell(14).setCellValue(diffDays);
- 
 
 446 
            }
- 
 
 447
- 
 
 448 
            diffDays = GetDelayinDays(order.getFirst_attempt_timestamp(), order.getExpected_delivery_time());
- 
 
 449
- 
 
 450 
            if (order.getFirst_attempt_timestamp() != 0) {
- 
 
 451 
                if (order.getPromised_shipping_time() != 0) {
- 
 
 452 
                    delayInShipping = GetDelayinDays(order.getShipping_timestamp(), order.getPromised_shipping_time());
- 
 
 453 
                    commContentRow.createCell(15).setCellValue(diffDays - delayInShipping);
- 
 
 454 
                }
- 
 
 455 
            } else {
392 
            commContentRow.createCell(15).setCellValue(order.getAirwaybill_no());
 456 
                commContentRow.createCell(15).setCellValue("N/A");
- 
 
 457 
            }
393 
        }
 458 
        }
394 
        for (int i = 0; i<16; i++) {
 459 
        for (int i = 0; i<16; i++) {
395 
            sheet2.autoSizeColumn(i);
 460 
            sheet2.autoSizeColumn(i);
396 
        }
 461 
        }
397 
    }
 462 
    }