package trigger_package;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.LoanInfo;
import main_package.UserInfo;

public class InterestBookingScheduler implements Job 
{
	public void execute(JobExecutionContext context)throws JobExecutionException
    {
    	Connection con = DataBaseConnection.JAVAConnection();
    	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
    	DataBaseMethods db = new DataBaseMethods();
    	List<Integer> branchList = new ArrayList<Integer>();
    	branchList = new DataBaseMethods().branchListAll(con);
    	
    	for(int i = 0; i < branchList.size(); i++)
    	{
	    	int branchId = branchList.get(i);
	    	ArrayList<UserInfo> list = dbmt.allDueEMIList(branchId);
	    	
	    	for (UserInfo ui: list)
	    	{
    			ArrayList<LoanInfo> loanEMIList = dbmt.loanInstallmentByStatus(ui.getLoanType(), ui.getLoanNo(), "Due", con);
				for(LoanInfo ll:loanEMIList)
				{
					if(ll.getStatus().equalsIgnoreCase("due") && ui.getEntryDateStr().equals(ll.getStrInstlmntDate()))
					{
						System.out.println("interest booking");
						String voucherNo = db.generateVoucherNo(branchId, "income_booking", con);
						
						boolean duplicate = false;
						duplicate = dbmt.checkDuplicateBooking(ll, ui.getLoanNo(), "Interest", con);
						System.out.println("duplicate : " + duplicate);
						if (!duplicate) 
						{
							if (ll.getPaidAmount() < Double.valueOf(ll.getInterestAmount()))
							{
								int z = dbmt.insertBookingAmountByType(ll, branchId, ui, voucherNo, "Interest", 
			   							   "Interest Receivable", con);
								
								if (z > 0) 
								{
									System.out.println("Interest inserted for : " + ui.getLoanNo());
								}
							}
						}
					}
				}
	    	}
    	}
    }
}