package trigger_package;

import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.InstallmentInfo;
import main_package.UserInfo;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

public class MisInterestJob implements Job
{
	 public void execute(JobExecutionContext context)throws JobExecutionException
	 {
		
		List<Integer> branchList = new ArrayList<Integer>();
		Connection conn=DataBaseConnection.JAVAConnection();
		ArrayList<InstallmentInfo> list=new ArrayList<>();
		DataBaseMethods dd=new DataBaseMethods();
		SimpleDateFormat dateObj=new SimpleDateFormat("dd/MM/yyyy");
	//	list=dd.dd.misDepositList(user_info);
        branchList = new DataBaseMethods().branchListAll(conn);
    	
    	for(int i=0;i<branchList.size();i++)
		 {
    		    
			    int branchId = branchList.get(i);
				
				list=dd.misPaymentList(branchId,conn);
				int f=0;
				int n=0;
				double remainingAmount=0,currentbalanceOfSavingAccount=0;
				
				UserInfo user_info;
				
				for(InstallmentInfo tt :list)
				{
					
					if(tt.getStatus().equalsIgnoreCase("pending"))
					{
						
						if(tt.getIns_date().equals(dateObj.format(new Date())))
						{						
							{
							user_info = dd.userInfoDuringTransaction(tt.getUser_no());
							String receipt_no=String.valueOf(dd.receiptNo());
							f=dd.paymentReceipt(branchId,tt.getUser_no(), 0, new Date(),"Transfer", "", null, "",0.0,receipt_no,"N/A", "MIS","","",tt.getCalc_interest());
							String savingAccountNo=dd.savingAccountByShareHolderNo(user_info.getShareHolderNo());
							n =dd.userDeposit(branchId,savingAccountNo, String.valueOf(tt.getCalc_interest()), new Date(), 
									"Transfer", "", null, "", "approved", "N/A","Mis Interest Credit","");
							
							if(n >= 1)
							{   
								
								UserInfo info=null;
								info=dd.savingAccountDetailByAccountNo(savingAccountNo);
								remainingAmount=info.getAmount()+tt.getCalc_interest();
								dd.increaseSavingAccountAmount(remainingAmount, savingAccountNo);
								
							}
						}
					}
					}
				}
		 }
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
}

