Subversion Repositories SmartDukaan

Rev

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

Rev 34541 Rev 34574
Line 978... Line 978...
978 
 
 978 
 
979 
		SXSSFSheet sheet = workbook.createSheet("PurchaseInvoicesReport");
 979 
		SXSSFSheet sheet = workbook.createSheet("PurchaseInvoicesReport");
980 
		sheet.trackAllColumnsForAutoSizing();
 980 
		sheet.trackAllColumnsForAutoSizing();
981 
 
 981 
 
982 
		Row rowHeader = sheet.createRow(0);
 982 
		Row rowHeader = sheet.createRow(0);
983 
		Cell cellPoIdHeader = rowHeader.createCell(0);
 - 
 
984 
		cellPoIdHeader.setCellValue("PoId");
 - 
 
985 
 
 983 
 
986 
		Cell cellPoDateHeader = rowHeader.createCell(1);
 984 
		Cell cellPoDateHeader = rowHeader.createCell(1);
987 
		cellPoDateHeader.setCellValue("PoDate");
 985 
		cellPoDateHeader.setCellValue("PoDate");
988 
 
 986 
 
989 
		Cell cellGrnNoHeader = rowHeader.createCell(2);
 - 
 
990 
		cellGrnNoHeader.setCellValue("GRN_No");
 - 
 
991 
 
 - 
 
992 
		Cell cellGrnDateHeader = rowHeader.createCell(3);
 - 
 
993 
		cellGrnDateHeader.setCellValue("GRN_Date");
 - 
 
994 
 
 - 
 
995 
		Cell cellSupplierNameHeader = rowHeader.createCell(4);
 987 
		Cell cellSupplierNameHeader = rowHeader.createCell(2);
996 
		cellSupplierNameHeader.setCellValue("Supplier_Name");
 988 
		cellSupplierNameHeader.setCellValue("Supplier_Name");
997 
 
 989 
 
998 
		Cell cellSupplierStateHeader = rowHeader.createCell(5);
 990 
		Cell cellSupplierStateHeader = rowHeader.createCell(3);
999 
		cellSupplierStateHeader.setCellValue("Supplier_State");
 991 
		cellSupplierStateHeader.setCellValue("Supplier_State");
1000 
 
 992 
 
1001 
		Cell cellSupplierGSTINHeader = rowHeader.createCell(6);
 993 
		Cell cellSupplierGSTINHeader = rowHeader.createCell(4);
1002 
		cellSupplierGSTINHeader.setCellValue("Supplier_GSTIN");
 994 
		cellSupplierGSTINHeader.setCellValue("Supplier_GSTIN");
1003 
 
 995 
 
1004 
 
 996 
 
1005 
		Cell cellInvoiceNumberHeader = rowHeader.createCell(7);
 997 
		Cell cellInvoiceNumberHeader = rowHeader.createCell(5);
1006 
		cellInvoiceNumberHeader.setCellValue("Invoice_Number");
 998 
		cellInvoiceNumberHeader.setCellValue("Invoice_Number");
1007 
 
 999 
 
1008 
		Cell cellInvoiceDateHeader = rowHeader.createCell(8);
 1000 
		Cell cellInvoiceDateHeader = rowHeader.createCell(6);
1009 
		cellInvoiceDateHeader.setCellValue("Invoice_Date");
 1001 
		cellInvoiceDateHeader.setCellValue("Invoice_Date");
1010 
 
 1002 
 
1011 
		Cell cellSupplierWarehouseNameHeader = rowHeader.createCell(9);
 1003 
		Cell cellSupplierWarehouseNameHeader = rowHeader.createCell(7);
1012 
        cellSupplierWarehouseNameHeader.setCellValue("Warehouse_Name");
 1004 
        cellSupplierWarehouseNameHeader.setCellValue("Warehouse_Name");
1013 
 
 1005 
 
1014 
		Cell cellSupplierWarehouseIdHeader = rowHeader.createCell(10);
 1006 
		Cell cellSupplierWarehouseIdHeader = rowHeader.createCell(8);
1015 
        cellSupplierWarehouseIdHeader.setCellValue("Warehouse_Id");
 1007 
        cellSupplierWarehouseIdHeader.setCellValue("Warehouse_Id");
1016 
 
 1008 
 
1017 
		Cell cellReceivedFromHeader = rowHeader.createCell(11);
 1009 
		Cell cellReceivedFromHeader = rowHeader.createCell(9);
1018 
		cellReceivedFromHeader.setCellValue("Received_By");
 1010 
		cellReceivedFromHeader.setCellValue("Received_By");
1019 
 
 1011 
 
1020 
 
 1012 
 
1021 
		Cell cellItemIdHeader = rowHeader.createCell(12);
 1013 
		Cell cellItemIdHeader = rowHeader.createCell(10);
1022 
		cellItemIdHeader.setCellValue("Item_Id");
 1014 
		cellItemIdHeader.setCellValue("Item_Id");
1023 
 
 1015 
 
1024 
		Cell cellBrandHeader = rowHeader.createCell(13);
 1016 
		Cell cellBrandHeader = rowHeader.createCell(11);
1025 
		cellBrandHeader.setCellValue("Brand");
 1017 
		cellBrandHeader.setCellValue("Brand");
1026 
 
 1018 
 
1027 
		Cell cellModelNameHeader = rowHeader.createCell(14);
 1019 
		Cell cellModelNameHeader = rowHeader.createCell(12);
1028 
		cellModelNameHeader.setCellValue("Model_Name");
 1020 
		cellModelNameHeader.setCellValue("Model_Name");
1029 
 
 1021 
 
1030 
		Cell cellModelNumberHeader = rowHeader.createCell(15);
 1022 
		Cell cellModelNumberHeader = rowHeader.createCell(13);
1031 
		cellModelNumberHeader.setCellValue("Model_Number");
 1023 
		cellModelNumberHeader.setCellValue("Model_Number");
1032 
 
 1024 
 
1033 
		Cell cellColorHeader = rowHeader.createCell(16);
 1025 
		Cell cellColorHeader = rowHeader.createCell(14);
1034 
		cellColorHeader.setCellValue("Color");
 1026 
		cellColorHeader.setCellValue("Color");
1035 
 
 1027 
 
1036 
		Cell cellSystemPriceHeader = rowHeader.createCell(17);
 1028 
		Cell cellSystemPriceHeader = rowHeader.createCell(15);
1037 
		cellSystemPriceHeader.setCellValue("System_Price");
 1029 
		cellSystemPriceHeader.setCellValue("System_Price");
1038 
 
 1030 
 
1039 
		Cell cellUnitPriceHeader = rowHeader.createCell(18);
 1031 
		Cell cellUnitPriceHeader = rowHeader.createCell(16);
1040 
		cellUnitPriceHeader.setCellValue("Unit_Price");
 1032 
		cellUnitPriceHeader.setCellValue("Unit_Price");
1041 
 
 1033 
 
1042 
		Cell cellBasicRateHeader = rowHeader.createCell(19);
 1034 
		Cell cellBasicRateHeader = rowHeader.createCell(17);
1043 
		cellBasicRateHeader.setCellValue("Basic_Rate");
 1035 
		cellBasicRateHeader.setCellValue("Basic_Rate");
1044 
 
 1036 
 
1045 
		Cell cellQuantityHeader = rowHeader.createCell(20);
 1037 
		Cell cellQuantityHeader = rowHeader.createCell(18);
1046 
		cellQuantityHeader.setCellValue("Quantity");
 1038 
		cellQuantityHeader.setCellValue("Quantity");
1047 
 
 1039 
 
1048 
		Cell cellInitialQuantityHeader = rowHeader.createCell(21);
 - 
 
1049 
		cellInitialQuantityHeader.setCellValue("Initial_Quantity");
 - 
 
1050 
 
 - 
 
1051 
		Cell cellAmendedQuantityHeader = rowHeader.createCell(22);
 - 
 
1052 
		cellAmendedQuantityHeader.setCellValue("Amended_Quantity");
 - 
 
1053 
 
 - 
 
1054 
		Cell cellTotalBasicValueHeader = rowHeader.createCell(23);
 1040 
		Cell cellTotalBasicValueHeader = rowHeader.createCell(19);
1055 
		cellTotalBasicValueHeader.setCellValue("Total_Basic_Value");
 1041 
		cellTotalBasicValueHeader.setCellValue("Total_Basic_Value");
1056 
 
 1042 
 
1057 
		Cell cellSGSTHeader = rowHeader.createCell(24);
 1043 
		Cell cellSGSTHeader = rowHeader.createCell(20);
1058 
		cellSGSTHeader.setCellValue("SGST%");
 1044 
		cellSGSTHeader.setCellValue("SGST%");
1059 
 
 1045 
 
1060 
		Cell cellSGSTAmountHeader = rowHeader.createCell(25);
 1046 
		Cell cellSGSTAmountHeader = rowHeader.createCell(21);
1061 
		cellSGSTAmountHeader.setCellValue("SGST_Amount");
 1047 
		cellSGSTAmountHeader.setCellValue("SGST_Amount");
1062 
 
 1048 
 
1063 
		Cell cellCGSTHeader = rowHeader.createCell(26);
 1049 
		Cell cellCGSTHeader = rowHeader.createCell(22);
1064 
		cellCGSTHeader.setCellValue("CGST%");
 1050 
		cellCGSTHeader.setCellValue("CGST%");
1065 
 
 1051 
 
1066 
		Cell cellCGSTAmountHeader = rowHeader.createCell(27);
 1052 
		Cell cellCGSTAmountHeader = rowHeader.createCell(23);
1067 
		cellCGSTAmountHeader.setCellValue("CGST_Amount");
 1053 
		cellCGSTAmountHeader.setCellValue("CGST_Amount");
1068 
 
 1054 
 
1069 
		Cell cellIGSTHeader = rowHeader.createCell(28);
 1055 
		Cell cellIGSTHeader = rowHeader.createCell(24);
1070 
		cellIGSTHeader.setCellValue("IGST%");
 1056 
		cellIGSTHeader.setCellValue("IGST%");
1071 
 
 1057 
 
1072 
		Cell cellIGSTAmountHeader = rowHeader.createCell(29);
 1058 
		Cell cellIGSTAmountHeader = rowHeader.createCell(25);
1073 
		cellIGSTAmountHeader.setCellValue("IGST_Amount");
 1059 
		cellIGSTAmountHeader.setCellValue("IGST_Amount");
1074 
 
 1060 
 
1075 
		Cell cellAmountWithGstHeader = rowHeader.createCell(30);
 1061 
		Cell cellAmountWithGstHeader = rowHeader.createCell(26);
1076 
		cellAmountWithGstHeader.setCellValue("Total_Invoice_Value_Amount");
 1062 
		cellAmountWithGstHeader.setCellValue("Total_Invoice_Value_Amount");
1077 
 
 1063 
 
1078 
 
 1064 
 
1079 
		Font font = workbook.createFont();
 1065 
		Font font = workbook.createFont();
1080 
		CellStyle cellStyle = workbook.createCellStyle();
 1066 
		CellStyle cellStyle = workbook.createCellStyle();
Line 1090... Line 1076...
1090 
 
 1076 
 
1091 
		for (int index = 0; index < purchaseInvoiceModels.size(); index++) {
 1077 
		for (int index = 0; index < purchaseInvoiceModels.size(); index++) {
1092 
			PurchaseInvoiceModel purchaseInvoiceModel = purchaseInvoiceModels.get(index);
 1078 
			PurchaseInvoiceModel purchaseInvoiceModel = purchaseInvoiceModels.get(index);
1093 
 
 1079 
 
1094 
			Row rowValues = sheet.createRow(index + 1);
 1080 
			Row rowValues = sheet.createRow(index + 1);
1095 
			Cell cellPoId = rowValues.createCell(0);
 - 
 
1096 
			cellPoId.setCellValue(purchaseInvoiceModel.getPoId());
 - 
 
1097 
 
 1081 
 
1098 
			Cell cellPoDate = rowValues.createCell(1);
 1082 
			Cell cellPoDate = rowValues.createCell(1);
1099 
			cellPoDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedPoDate()));
 1083 
			cellPoDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedPoDate()));
1100 
 
 1084 
 
1101 
			Cell cellGRNNo = rowValues.createCell(2);
 - 
 
1102 
			cellGRNNo.setCellValue(purchaseInvoiceModel.getGrnNo());
 - 
 
1103 
 
 - 
 
1104 
			Cell cellGRNDate = rowValues.createCell(3);
 - 
 
1105 
			cellGRNDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedGrnDate()));
 - 
 
1106 
 
 - 
 
1107 
			Cell cellSupplierName = rowValues.createCell(4);
 1085 
			Cell cellSupplierName = rowValues.createCell(2);
1108 
			cellSupplierName.setCellValue(purchaseInvoiceModel.getSupplierName());
 1086 
			cellSupplierName.setCellValue(purchaseInvoiceModel.getSupplierName());
1109 
 
 1087 
 
1110 
			Cell cellSupplierState = rowValues.createCell(5);
 1088 
			Cell cellSupplierState = rowValues.createCell(3);
1111 
			cellSupplierState.setCellValue(purchaseInvoiceModel.getSupplierState());
 1089 
			cellSupplierState.setCellValue(purchaseInvoiceModel.getSupplierState());
1112 
 
 1090 
 
1113 
			Cell cellSupplierGSTIN = rowValues.createCell(6);
 1091 
			Cell cellSupplierGSTIN = rowValues.createCell(4);
1114 
			cellSupplierGSTIN.setCellValue(purchaseInvoiceModel.getSupplierGstIn());
 1092 
			cellSupplierGSTIN.setCellValue(purchaseInvoiceModel.getSupplierGstIn());
1115 
 
 1093 
 
1116 
			Cell cellInvoiceNumber = rowValues.createCell(7);
 1094 
			Cell cellInvoiceNumber = rowValues.createCell(5);
1117 
			cellInvoiceNumber.setCellValue(purchaseInvoiceModel.getInvoiceNumber());
 1095 
			cellInvoiceNumber.setCellValue(purchaseInvoiceModel.getInvoiceNumber());
1118 
 
 1096 
 
1119 
			Cell cellInvoiceDate = rowValues.createCell(8);
 1097 
			Cell cellInvoiceDate = rowValues.createCell(6);
1120 
			cellInvoiceDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedInvoiceDate()));
 1098 
			cellInvoiceDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedInvoiceDate()));
1121 
 
 1099 
 
1122 
 
 1100 
 
1123 
			Cell cellSupplierWarehouseName = rowValues.createCell(9);
 1101 
			Cell cellSupplierWarehouseName = rowValues.createCell(7);
1124 
            cellSupplierWarehouseName.setCellValue(purchaseInvoiceModel.getWarehouseName());
 1102 
            cellSupplierWarehouseName.setCellValue(purchaseInvoiceModel.getWarehouseName());
1125 
 
 1103 
 
1126 
			Cell cellSupplierWarehouseId = rowValues.createCell(10);
 1104 
			Cell cellSupplierWarehouseId = rowValues.createCell(8);
1127 
            cellSupplierWarehouseId.setCellValue(purchaseInvoiceModel.getWarehouseId());
 1105 
            cellSupplierWarehouseId.setCellValue(purchaseInvoiceModel.getWarehouseId());
1128 
 
 1106 
 
1129 
			Cell cellReceivedFrom = rowValues.createCell(11);
 1107 
			Cell cellReceivedFrom = rowValues.createCell(9);
1130 
			cellReceivedFrom.setCellValue(purchaseInvoiceModel.getReceivedFrom());
 1108 
			cellReceivedFrom.setCellValue(purchaseInvoiceModel.getReceivedFrom());
1131 
 
 1109 
 
1132 
			Cell cellItemId = rowValues.createCell(12);
 1110 
			Cell cellItemId = rowValues.createCell(10);
1133 
			cellItemId.setCellValue(purchaseInvoiceModel.getItemId());
 1111 
			cellItemId.setCellValue(purchaseInvoiceModel.getItemId());
1134 
 
 1112 
 
1135 
			Cell cellBrand = rowValues.createCell(13);
 1113 
			Cell cellBrand = rowValues.createCell(11);
1136 
			cellBrand.setCellValue(purchaseInvoiceModel.getBrand());
 1114 
			cellBrand.setCellValue(purchaseInvoiceModel.getBrand());
1137 
 
 1115 
 
1138 
			Cell cellModelName = rowValues.createCell(14);
 1116 
			Cell cellModelName = rowValues.createCell(12);
1139 
			cellModelName.setCellValue(purchaseInvoiceModel.getModelName());
 1117 
			cellModelName.setCellValue(purchaseInvoiceModel.getModelName());
1140 
 
 1118 
 
1141 
			Cell cellModelNumber = rowValues.createCell(15);
 1119 
			Cell cellModelNumber = rowValues.createCell(13);
1142 
			cellModelNumber.setCellValue(purchaseInvoiceModel.getModelNumber());
 1120 
			cellModelNumber.setCellValue(purchaseInvoiceModel.getModelNumber());
1143 
 
 1121 
 
1144 
			Cell cellColor = rowValues.createCell(16);
 1122 
			Cell cellColor = rowValues.createCell(14);
1145 
			cellColor.setCellValue(purchaseInvoiceModel.getColor());
 1123 
			cellColor.setCellValue(purchaseInvoiceModel.getColor());
1146 
 
 1124 
 
1147 
			Cell cellSystemPrice = rowValues.createCell(17);
 1125 
			Cell cellSystemPrice = rowValues.createCell(15);
1148 
			cellSystemPrice.setCellValue(purchaseInvoiceModel.getSystemPrice());
 1126 
			cellSystemPrice.setCellValue(purchaseInvoiceModel.getSystemPrice());
1149 
 
 1127 
 
1150 
			Cell cellUnitPrice = rowValues.createCell(18);
 1128 
			Cell cellUnitPrice = rowValues.createCell(16);
1151 
			cellUnitPrice.setCellValue(purchaseInvoiceModel.getUnitPrice());
 1129 
			cellUnitPrice.setCellValue(purchaseInvoiceModel.getUnitPrice());
1152 
 
 1130 
 
1153 
			Cell cellBasicRate = rowValues.createCell(19);
 1131 
			Cell cellBasicRate = rowValues.createCell(17);
1154 
			cellBasicRate.setCellValue(purchaseInvoiceModel.getBasicRate());
 1132 
			cellBasicRate.setCellValue(purchaseInvoiceModel.getBasicRate());
1155 
 
 1133 
 
1156 
			Cell cellQuantity = rowValues.createCell(20);
 1134 
			Cell cellQuantity = rowValues.createCell(18);
1157 
			cellQuantity.setCellValue(purchaseInvoiceModel.getQuantity());
 1135 
			cellQuantity.setCellValue(purchaseInvoiceModel.getQuantity());
1158 
 
 1136 
 
1159 
			Cell cellInitialQuantity = rowValues.createCell(21);
 - 
 
1160 
			cellInitialQuantity.setCellValue(purchaseInvoiceModel.getInitialQty());
 - 
 
1161 
 
 - 
 
1162 
			Cell cellAmendedQuantity = rowValues.createCell(22);
 - 
 
1163 
			cellAmendedQuantity.setCellValue(purchaseInvoiceModel.getAmendedQty());
 - 
 
1164 
 
 - 
 
1165 
			Cell cellTotalBasicValue = rowValues.createCell(23);
 1137 
			Cell cellTotalBasicValue = rowValues.createCell(19);
1166 
			cellTotalBasicValue.setCellValue(purchaseInvoiceModel.getTotalBasic());
 1138 
			cellTotalBasicValue.setCellValue(purchaseInvoiceModel.getTotalBasic());
1167 
 
 1139 
 
1168 
			Cell cellSGSTPercent = rowValues.createCell(24);
 1140 
			Cell cellSGSTPercent = rowValues.createCell(20);
1169 
			cellSGSTPercent.setCellValue(purchaseInvoiceModel.getSgstRate());
 1141 
			cellSGSTPercent.setCellValue(purchaseInvoiceModel.getSgstRate());
1170 
 
 1142 
 
1171 
			Cell cellSGSTAmount = rowValues.createCell(25);
 1143 
			Cell cellSGSTAmount = rowValues.createCell(21);
1172 
			cellSGSTAmount.setCellValue(purchaseInvoiceModel.getSgstAmount());
 1144 
			cellSGSTAmount.setCellValue(purchaseInvoiceModel.getSgstAmount());
1173 
 
 1145 
 
1174 
			Cell cellCGSTPercent = rowValues.createCell(26);
 1146 
			Cell cellCGSTPercent = rowValues.createCell(22);
1175 
			cellCGSTPercent.setCellValue(purchaseInvoiceModel.getCgstRate());
 1147 
			cellCGSTPercent.setCellValue(purchaseInvoiceModel.getCgstRate());
1176 
 
 1148 
 
1177 
			Cell cellCGSTAmount = rowValues.createCell(27);
 1149 
			Cell cellCGSTAmount = rowValues.createCell(23);
1178 
			cellCGSTAmount.setCellValue(purchaseInvoiceModel.getCgstAmount());
 1150 
			cellCGSTAmount.setCellValue(purchaseInvoiceModel.getCgstAmount());
1179 
 
 1151 
 
1180 
			Cell cellIGSTPercent = rowValues.createCell(28);
 1152 
			Cell cellIGSTPercent = rowValues.createCell(24);
1181 
			cellIGSTPercent.setCellValue(purchaseInvoiceModel.getIgstRate());
 1153 
			cellIGSTPercent.setCellValue(purchaseInvoiceModel.getIgstRate());
1182 
 
 1154 
 
1183 
			Cell cellIGSTAmount = rowValues.createCell(29);
 1155 
			Cell cellIGSTAmount = rowValues.createCell(25);
1184 
			cellIGSTAmount.setCellValue(purchaseInvoiceModel.getIgstAmount());
 1156 
			cellIGSTAmount.setCellValue(purchaseInvoiceModel.getIgstAmount());
1185 
 
 1157 
 
1186 
			Cell cellAmountWithGst = rowValues.createCell(30);
 1158 
			Cell cellAmountWithGst = rowValues.createCell(26);
1187 
			cellAmountWithGst.setCellValue(purchaseInvoiceModel.getTotalInvoiceValueAmount());
 1159 
			cellAmountWithGst.setCellValue(purchaseInvoiceModel.getTotalInvoiceValueAmount());
1188 
		}
 1160 
		}
1189 
 
 1161 
 
1190 
		for (int index = 0; index < 14; index++) {
 1162 
		for (int index = 0; index < 14; index++) {
1191 
			sheet.autoSizeColumn(index);
 1163 
			sheet.autoSizeColumn(index);