Subversion Repositories SmartDukaan

Rev

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

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