Subversion Repositories SmartDukaan

Rev

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

Rev 34534 Rev 34541
Line 1043... Line 1043...
1043 
		cellBasicRateHeader.setCellValue("Basic_Rate");
 1043 
		cellBasicRateHeader.setCellValue("Basic_Rate");
1044 
 
 1044 
 
1045 
		Cell cellQuantityHeader = rowHeader.createCell(20);
 1045 
		Cell cellQuantityHeader = rowHeader.createCell(20);
1046 
		cellQuantityHeader.setCellValue("Quantity");
 1046 
		cellQuantityHeader.setCellValue("Quantity");
1047 
 
 1047 
 
- 
 
 1048 
		Cell cellInitialQuantityHeader = rowHeader.createCell(21);
- 
 
 1049 
		cellInitialQuantityHeader.setCellValue("Initial_Quantity");
- 
 
 1050 
 
- 
 
 1051 
		Cell cellAmendedQuantityHeader = rowHeader.createCell(22);
- 
 
 1052 
		cellAmendedQuantityHeader.setCellValue("Amended_Quantity");
- 
 
 1053 
 
1048 
		Cell cellTotalBasicValueHeader = rowHeader.createCell(21);
 1054 
		Cell cellTotalBasicValueHeader = rowHeader.createCell(23);
1049 
		cellTotalBasicValueHeader.setCellValue("Total_Basic_Value");
 1055 
		cellTotalBasicValueHeader.setCellValue("Total_Basic_Value");
1050 
 
 1056 
 
1051 
		Cell cellSGSTHeader = rowHeader.createCell(22);
 1057 
		Cell cellSGSTHeader = rowHeader.createCell(24);
1052 
		cellSGSTHeader.setCellValue("SGST%");
 1058 
		cellSGSTHeader.setCellValue("SGST%");
1053 
 
 1059 
 
1054 
		Cell cellSGSTAmountHeader = rowHeader.createCell(23);
 1060 
		Cell cellSGSTAmountHeader = rowHeader.createCell(25);
1055 
		cellSGSTAmountHeader.setCellValue("SGST_Amount");
 1061 
		cellSGSTAmountHeader.setCellValue("SGST_Amount");
1056 
 
 1062 
 
1057 
		Cell cellCGSTHeader = rowHeader.createCell(24);
 1063 
		Cell cellCGSTHeader = rowHeader.createCell(26);
1058 
		cellCGSTHeader.setCellValue("CGST%");
 1064 
		cellCGSTHeader.setCellValue("CGST%");
1059 
 
 1065 
 
1060 
		Cell cellCGSTAmountHeader = rowHeader.createCell(25);
 1066 
		Cell cellCGSTAmountHeader = rowHeader.createCell(27);
1061 
		cellCGSTAmountHeader.setCellValue("CGST_Amount");
 1067 
		cellCGSTAmountHeader.setCellValue("CGST_Amount");
1062 
 
 1068 
 
1063 
		Cell cellIGSTHeader = rowHeader.createCell(26);
 1069 
		Cell cellIGSTHeader = rowHeader.createCell(28);
1064 
		cellIGSTHeader.setCellValue("IGST%");
 1070 
		cellIGSTHeader.setCellValue("IGST%");
1065 
 
 1071 
 
1066 
		Cell cellIGSTAmountHeader = rowHeader.createCell(27);
 1072 
		Cell cellIGSTAmountHeader = rowHeader.createCell(29);
1067 
		cellIGSTAmountHeader.setCellValue("IGST_Amount");
 1073 
		cellIGSTAmountHeader.setCellValue("IGST_Amount");
1068 
 
 1074 
 
1069 
		Cell cellAmountWithGstHeader = rowHeader.createCell(28);
 1075 
		Cell cellAmountWithGstHeader = rowHeader.createCell(30);
1070 
		cellAmountWithGstHeader.setCellValue("Total_Invoice_Value_Amount");
 1076 
		cellAmountWithGstHeader.setCellValue("Total_Invoice_Value_Amount");
1071 
 
 1077 
 
1072 
 
 1078 
 
1073 
		Font font = workbook.createFont();
 1079 
		Font font = workbook.createFont();
1074 
		CellStyle cellStyle = workbook.createCellStyle();
 1080 
		CellStyle cellStyle = workbook.createCellStyle();
Line 1148... Line 1154...
1148 
			cellBasicRate.setCellValue(purchaseInvoiceModel.getBasicRate());
 1154 
			cellBasicRate.setCellValue(purchaseInvoiceModel.getBasicRate());
1149 
 
 1155 
 
1150 
			Cell cellQuantity = rowValues.createCell(20);
 1156 
			Cell cellQuantity = rowValues.createCell(20);
1151 
			cellQuantity.setCellValue(purchaseInvoiceModel.getQuantity());
 1157 
			cellQuantity.setCellValue(purchaseInvoiceModel.getQuantity());
1152 
 
 1158 
 
- 
 
 1159 
			Cell cellInitialQuantity = rowValues.createCell(21);
- 
 
 1160 
			cellInitialQuantity.setCellValue(purchaseInvoiceModel.getInitialQty());
- 
 
 1161 
 
- 
 
 1162 
			Cell cellAmendedQuantity = rowValues.createCell(22);
- 
 
 1163 
			cellAmendedQuantity.setCellValue(purchaseInvoiceModel.getAmendedQty());
- 
 
 1164 
 
1153 
			Cell cellTotalBasicValue = rowValues.createCell(21);
 1165 
			Cell cellTotalBasicValue = rowValues.createCell(23);
1154 
			cellTotalBasicValue.setCellValue(purchaseInvoiceModel.getTotalBasic());
 1166 
			cellTotalBasicValue.setCellValue(purchaseInvoiceModel.getTotalBasic());
1155 
 
 1167 
 
1156 
			Cell cellSGSTPercent = rowValues.createCell(22);
 1168 
			Cell cellSGSTPercent = rowValues.createCell(24);
1157 
			cellSGSTPercent.setCellValue(purchaseInvoiceModel.getSgstRate());
 1169 
			cellSGSTPercent.setCellValue(purchaseInvoiceModel.getSgstRate());
1158 
 
 1170 
 
1159 
			Cell cellSGSTAmount = rowValues.createCell(23);
 1171 
			Cell cellSGSTAmount = rowValues.createCell(25);
1160 
			cellSGSTAmount.setCellValue(purchaseInvoiceModel.getSgstAmount());
 1172 
			cellSGSTAmount.setCellValue(purchaseInvoiceModel.getSgstAmount());
1161 
 
 1173 
 
1162 
			Cell cellCGSTPercent = rowValues.createCell(24);
 1174 
			Cell cellCGSTPercent = rowValues.createCell(26);
1163 
			cellCGSTPercent.setCellValue(purchaseInvoiceModel.getCgstRate());
 1175 
			cellCGSTPercent.setCellValue(purchaseInvoiceModel.getCgstRate());
1164 
 
 1176 
 
1165 
			Cell cellCGSTAmount = rowValues.createCell(25);
 1177 
			Cell cellCGSTAmount = rowValues.createCell(27);
1166 
			cellCGSTAmount.setCellValue(purchaseInvoiceModel.getCgstAmount());
 1178 
			cellCGSTAmount.setCellValue(purchaseInvoiceModel.getCgstAmount());
1167 
 
 1179 
 
1168 
			Cell cellIGSTPercent = rowValues.createCell(26);
 1180 
			Cell cellIGSTPercent = rowValues.createCell(28);
1169 
			cellIGSTPercent.setCellValue(purchaseInvoiceModel.getIgstRate());
 1181 
			cellIGSTPercent.setCellValue(purchaseInvoiceModel.getIgstRate());
1170 
 
 1182 
 
1171 
			Cell cellIGSTAmount = rowValues.createCell(27);
 1183 
			Cell cellIGSTAmount = rowValues.createCell(29);
1172 
			cellIGSTAmount.setCellValue(purchaseInvoiceModel.getIgstAmount());
 1184 
			cellIGSTAmount.setCellValue(purchaseInvoiceModel.getIgstAmount());
1173 
 
 1185 
 
1174 
			Cell cellAmountWithGst = rowValues.createCell(28);
 1186 
			Cell cellAmountWithGst = rowValues.createCell(30);
1175 
			cellAmountWithGst.setCellValue(purchaseInvoiceModel.getTotalInvoiceValueAmount());
 1187 
			cellAmountWithGst.setCellValue(purchaseInvoiceModel.getTotalInvoiceValueAmount());
1176 
		}
 1188 
		}
1177 
 
 1189 
 
1178 
		for (int index = 0; index < 14; index++) {
 1190 
		for (int index = 0; index < 14; index++) {
1179 
			sheet.autoSizeColumn(index);
 1191 
			sheet.autoSizeColumn(index);