package other_package;

import group_head_package.DataBaseIncomeExpense;

import java.sql.Connection;
import java.util.ArrayList;

import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.DueDebitInfo;

public class Main {

	public static void main(String[] args) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		DataBaseMethods obj=new DataBaseMethods();
		DataBaseIncomeExpense dd=new DataBaseIncomeExpense();
		ArrayList<DueDebitInfo>returnAmountList=new ArrayList<>();
		
		returnAmountList=obj.ReturnAmountRdFdList(branchId);
		Connection conn=DataBaseConnection.JAVAConnection();
		for(DueDebitInfo tt :returnAmountList)
		{
			
			for(int i=1 ; i<=3; i++)
			{
				if(i==1 && tt.getPrematurityCharge() >0)
				{
					String voucherNo=obj.generateVoucherNo(branchId,"income_table", conn);
					dd.addIncome(branchId,tt.getIncomeDate(), "Other_Cr", tt.getPaymentMode(), String.valueOf(tt.getPrematurityCharge()), tt.getChequeNo(), tt.getBankBranch(), tt.getBankName(), tt.getChequeDate(), "Pre Maturity Charge", "Pre Maturity Charge", 0, "N/A", "0", 0, tt.getItem_loan_fdr(), "", voucherNo, "", 0, "active","");
				}
				if(i==2 && tt.getStationaryCharge() >0)
				{
					String voucherNo=obj.generateVoucherNo(branchId,"income_table", conn);
					dd.addIncome(branchId,tt.getIncomeDate(), "Other_Cr", tt.getPaymentMode(), String.valueOf(tt.getStationaryCharge()), tt.getChequeNo(), tt.getBankBranch(), tt.getBankName(), tt.getChequeDate(), "Stationary Charge", "Stationary Charge", 0, "N/A", "0", 0, tt.getItem_loan_fdr(), "", voucherNo, "", 0, "active","");
				}
				if(i==3 && tt.getOtherCharge() >0)
				{
					String voucherNo=obj.generateVoucherNo(branchId,"income_table", conn);
					dd.addIncome(branchId,tt.getIncomeDate(), "Other_Cr", tt.getPaymentMode(), String.valueOf(tt.getOtherCharge()), tt.getChequeNo(), tt.getBankBranch(), tt.getBankName(), tt.getChequeDate(), "Other Charge", "Other Charge", 0, "N/A", "0", 0, tt.getItem_loan_fdr(), "", voucherNo, "", 0, "active","");
				}
				
			}
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		// TODO Auto-generated method stub

	}
	


}
