Subversion Repositories SmartDukaan

Rev

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

Rev 20247 Rev 20257
Line 595... Line 595...
595 
		weightStyle.setDataFormat(createHelper.createDataFormat().getFormat("0.000"));
 595 
		weightStyle.setDataFormat(createHelper.createDataFormat().getFormat("0.000"));
596
596
597
597
598 
 
 598 
 
599 
		Row headerRow = sheet.createRow((short)0);
 599 
		Row headerRow = sheet.createRow((short)0);
- 
 
 600 
		int i = -1;
600 
		headerRow.createCell(0).setCellValue("Airwaybill");
 601 
		headerRow.createCell(i++).setCellValue("Airwaybill");
601 
		headerRow.createCell(1).setCellValue("Type"); //Values : "COD" / "NONCOD"
 602 
		headerRow.createCell(i++).setCellValue("Type"); //Values : "COD" / "NONCOD"
602 
		headerRow.createCell(2).setCellValue("Master Order Id");
 - 
 
603 
		headerRow.createCell(3).setCellValue("Reference Number"); //OrderId
 603 
		headerRow.createCell(i++).setCellValue("Reference Number"); //OrderId
604 
		headerRow.createCell(4).setCellValue("Sender / Store name"); //"Spice Online retail pvt ltd"
 604 
		headerRow.createCell(i++).setCellValue("Sender / Store name"); //"Spice Online retail pvt ltd"
605 
		headerRow.createCell(5).setCellValue("attention"); //Customer name
 605 
		headerRow.createCell(i++).setCellValue("attention"); //Customer name
606 
		headerRow.createCell(6).setCellValue("address1"); //Line 1
 606 
		headerRow.createCell(i++).setCellValue("address1"); //Line 1
607 
		headerRow.createCell(7).setCellValue("address2"); //Line 2
 607 
		headerRow.createCell(i++).setCellValue("address2"); //Line 2
608 
		headerRow.createCell(8).setCellValue("address3"); //city + state
 608 
		headerRow.createCell(i++).setCellValue("address3"); //city + state
609 
		headerRow.createCell(9).setCellValue("pincode");
 609 
		headerRow.createCell(i++).setCellValue("pincode");
610 
		headerRow.createCell(10).setCellValue("tel number"); //Empty
 610 
		headerRow.createCell(i++).setCellValue("tel number"); //Empty
611 
		headerRow.createCell(11).setCellValue("mobile number"); //Empty
 611 
		headerRow.createCell(i++).setCellValue("mobile number"); //Empty
612 
		headerRow.createCell(12).setCellValue("Prod/SKU code");  //ItemId
 612 
		headerRow.createCell(i++).setCellValue("Prod/SKU code");  //ItemId
613 
		headerRow.createCell(13).setCellValue("contents"); //Product name
 613 
		headerRow.createCell(i++).setCellValue("contents"); //Product name
614 
		headerRow.createCell(14).setCellValue("weight");  //In Kgs
 614 
		headerRow.createCell(i++).setCellValue("weight");  //In Kgs
615 
		headerRow.createCell(15).setCellValue("Declared Value");
615 
		headerRow.createCell(i++).setCellValue("Declared Value");
616 
		headerRow.createCell(16).setCellValue("Collectable Value");
 616 
		headerRow.createCell(i++).setCellValue("Collectable Value");
617 
		headerRow.createCell(17).setCellValue("Vendor Code");
 617 
		headerRow.createCell(i++).setCellValue("Vendor Code");
618 
		headerRow.createCell(18).setCellValue("Shipper Name");
618 
		headerRow.createCell(i++).setCellValue("Shipper Name");
619 
		headerRow.createCell(19).setCellValue("Return Address1");
 619 
		headerRow.createCell(i++).setCellValue("Return Address1");
620 
		headerRow.createCell(20).setCellValue("Return Address2");
 620 
		headerRow.createCell(i++).setCellValue("Return Address2");
621 
		headerRow.createCell(21).setCellValue("Return Address3");
 621 
		headerRow.createCell(i++).setCellValue("Return Address3");
622 
		headerRow.createCell(22).setCellValue("Return Pin");
 622 
		headerRow.createCell(i++).setCellValue("Return Pin");
623 
		headerRow.createCell(23).setCellValue("Length ( Cms )");
 623 
		headerRow.createCell(i++).setCellValue("Length ( Cms )");
624 
		headerRow.createCell(24).setCellValue("Bredth ( Cms )");
 624 
		headerRow.createCell(i++).setCellValue("Bredth ( Cms )");
625 
		headerRow.createCell(25).setCellValue("Height ( Cms )");
 625 
		headerRow.createCell(i++).setCellValue("Height ( Cms )");
626 
		headerRow.createCell(26).setCellValue("Pieces");
626 
		headerRow.createCell(i++).setCellValue("Pieces");
627 
		headerRow.createCell(27).setCellValue("Area_customer_code");
 627 
		headerRow.createCell(i++).setCellValue("Area_customer_code");
628 
		headerRow.createCell(28).setCellValue("Handover Date ( DD/MM/YYYY )");
 628 
		headerRow.createCell(i++).setCellValue("Handover Date ( DD/MM/YYYY )");
629 
		headerRow.createCell(29).setCellValue("Handover Time ( 24 hrs format )");
 629 
		headerRow.createCell(i++).setCellValue("Handover Time ( 24 hrs format )");
630 
 
 630 
 
631 
		int serialNo = 0;
 631 
		int serialNo = 0;
632 
 
 632 
 
633 
		for(AwbDetails awbDetail : awbDetailList) {
 633 
		for(AwbDetails awbDetail : awbDetailList) {
634 
			//          0  Airwaybill   1 Type    2 Reference Number  3 Sender / Store name 4 attention   5 address1    6 address2    7 address3
634 
			//          0  Airwaybill   1 Type    2 Reference Number  3 Sender / Store name 4 attention   5 address1    6 address2    7 address3
Line 638... Line 638...
638 
			//          22 Length ( Cms )   23 Breadth ( Cms )      24 Height ( Cms )
638 
			//          22 Length ( Cms )   23 Breadth ( Cms )      24 Height ( Cms )
639 
			//          25 Pieces  26 Area_customer_code  27 Handover Date ( DD/MM/YYYY )   28 Handover Time ( 24 hrs format )
639 
			//          25 Pieces  26 Area_customer_code  27 Handover Date ( DD/MM/YYYY )   28 Handover Time ( 24 hrs format )
640 
 
 640 
 
641 
			serialNo++;
 641 
			serialNo++;
642 
			Row contentRow = sheet.createRow((short)serialNo);
 642 
			Row contentRow = sheet.createRow((short)serialNo);
643 
 
 643 
			i=-1;
644 
			contentRow.createCell(0).setCellValue(awbDetail.getAwbNumber());
 644 
			contentRow.createCell(i++).setCellValue(awbDetail.getAwbNumber());
645 
			contentRow.createCell(1).setCellValue(awbDetail.getPaymentMode().equals("COD") ? "COD" : "NONCOD");
 645 
			contentRow.createCell(i++).setCellValue(awbDetail.getPaymentMode().equals("COD") ? "COD" : "NONCOD");
646 
			contentRow.createCell(2).setCellValue(awbDetail.getMasterOrderId());
 646 
			contentRow.createCell(i++).setCellValue(awbDetail.getMasterOrderId());
647 
			contentRow.createCell(3).setCellValue(awbDetail.getOrderId());
 - 
 
648 
			contentRow.createCell(4).setCellValue("Hotspot Sales & Solutions Pvt Ltd");
 647 
			contentRow.createCell(i++).setCellValue("Hotspot Sales & Solutions Pvt Ltd");
649 
			contentRow.createCell(5).setCellValue(awbDetail.getCustomerName());
 648 
			contentRow.createCell(i++).setCellValue(awbDetail.getCustomerName());
650 
			contentRow.createCell(6).setCellValue(awbDetail.getAddress1());
 649 
			contentRow.createCell(i++).setCellValue(awbDetail.getAddress1());
651 
			contentRow.createCell(7).setCellValue(awbDetail.getAddress2());
 650 
			contentRow.createCell(i++).setCellValue(awbDetail.getAddress2());
652 
			contentRow.createCell(8).setCellValue(awbDetail.getCity() + ", " + awbDetail.getState());
 651 
			contentRow.createCell(i++).setCellValue(awbDetail.getCity() + ", " + awbDetail.getState());
653 
			contentRow.createCell(9).setCellValue(awbDetail.getPinCode());
 652 
			contentRow.createCell(i++).setCellValue(awbDetail.getPinCode());
654 
			contentRow.createCell(10).setCellValue(awbDetail.getPhoneNumber());
 653 
			contentRow.createCell(i++).setCellValue(awbDetail.getPhoneNumber());
655 
			contentRow.createCell(11).setCellValue(awbDetail.getPhoneNumber());
 654 
			contentRow.createCell(i++).setCellValue(awbDetail.getPhoneNumber());
656 
			contentRow.createCell(12).setCellValue(awbDetail.getItemId());
 655 
			contentRow.createCell(i++).setCellValue(awbDetail.getItemId());
657 
			contentRow.createCell(13).setCellValue(awbDetail.getProductName());
 656 
			contentRow.createCell(i++).setCellValue(awbDetail.getProductName());
658 
			contentRow.createCell(14).setCellValue(awbDetail.getPacketWeight());
 657 
			contentRow.createCell(i++).setCellValue(awbDetail.getPacketWeight());
659 
			contentRow.createCell(15).setCellValue(awbDetail.getShipmentValue());
 658 
			contentRow.createCell(i++).setCellValue(awbDetail.getShipmentValue());
660 
			contentRow.createCell(16).setCellValue(awbDetail.getAmountToCollect());
 659 
			contentRow.createCell(i++).setCellValue(awbDetail.getAmountToCollect());
661 
			contentRow.createCell(17).setCellValue(awbDetail.getVendorCode());
 660 
			contentRow.createCell(i++).setCellValue(awbDetail.getVendorCode());
662 
			contentRow.createCell(18).setCellValue("Hotspot Sales & Solutions Pvt Ltd");
661 
			contentRow.createCell(i++).setCellValue("Hotspot Sales & Solutions Pvt Ltd");
663 
			contentRow.createCell(19).setCellValue(awbDetail.getReturnAddress1());
 662 
			contentRow.createCell(i++).setCellValue(awbDetail.getReturnAddress1());
664 
			contentRow.createCell(20).setCellValue(awbDetail.getReturnAddress2());
 663 
			contentRow.createCell(i++).setCellValue(awbDetail.getReturnAddress2());
665 
			contentRow.createCell(21).setCellValue(awbDetail.getReturnAddress3());
 664 
			contentRow.createCell(i++).setCellValue(awbDetail.getReturnAddress3());
666 
			contentRow.createCell(22).setCellValue(awbDetail.getReturnPin());
 665 
			contentRow.createCell(i++).setCellValue(awbDetail.getReturnPin());
667 
			contentRow.createCell(23).setCellValue(CourierDetailsController.EMPTY_STRING);
 666 
			contentRow.createCell(i++).setCellValue(CourierDetailsController.EMPTY_STRING);
668 
			contentRow.createCell(24).setCellValue(CourierDetailsController.EMPTY_STRING);
 667 
			contentRow.createCell(i++).setCellValue(CourierDetailsController.EMPTY_STRING);
669 
			contentRow.createCell(25).setCellValue(CourierDetailsController.EMPTY_STRING);
 668 
			contentRow.createCell(i++).setCellValue(CourierDetailsController.EMPTY_STRING);
670 
			contentRow.createCell(26).setCellValue("1");
 669 
			contentRow.createCell(i++).setCellValue("1");
671 
			contentRow.createCell(27).setCellValue(awbDetail.getAccountCode());
 670 
			contentRow.createCell(i++).setCellValue(awbDetail.getAccountCode());
672 
 
 671 
 
673 
			Date date = null;
 672 
			Date date = null;
674 
			SimpleDateFormat sdf4Date = new SimpleDateFormat("dd/MM/yyyy");
673 
			SimpleDateFormat sdf4Date = new SimpleDateFormat("dd/MM/yyyy");
675 
			SimpleDateFormat sdf4Time = new SimpleDateFormat("HHmm");
 674 
			SimpleDateFormat sdf4Time = new SimpleDateFormat("HHmm");
676 
 
 675