package trigger_package;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.faces.model.SelectItem;

import main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.UserInfo;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import report_package.DataBaseReportMethods;

// Auto Message sent to the client for upcoming Loan, DD, RD EMI
public class AutoEmiMessageJob implements Job 
{
	String[] selectedCenter;
	
	ArrayList<SelectItem> centerList=new ArrayList<>();
	
	DataBaseMethods db=new DataBaseMethods();
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	
	
	
    public void execute(JobExecutionContext context)throws JobExecutionException
    {
    	List<Integer> branchList = new ArrayList<Integer>();
    	Connection conn=DataBaseConnection.JAVAConnection();
    	String msgStatus=db.checkMessageApiStatus(conn);
    	
		if(msgStatus.equalsIgnoreCase("active"))
		{
			branchList = new DataBaseMethods().branchListAll(conn);
			
			for(int i=0;i<branchList.size();i++)
			{
				int branchId = branchList.get(i);
				centerList=dbmr.allCenter(branchId,conn);
		    	ArrayList<UserInfo> list, emiList;
		    	list=db.dataFromAutoMessageSettingTable();
		    	for(UserInfo uu:list)
		    	{
		    		if(uu.isBooleanStatus()==true)
		    		{
		    			Date currDate=new Date();
		    			emiList=new ArrayList<>();
		    			int dayBefore=uu.getDayBefore();
		    			Date tempdt=currDate;
		    			Calendar cal = Calendar.getInstance();
		    	        cal.setTime(tempdt);
		    	        cal.add(Calendar.DATE, dayBefore);
		    	        tempdt = cal.getTime();
		    	       // String tempDtStr=sdfForDb.format(tempdt.getTime());
		    			
		    	        emiList=dbmr.allUpcomingEMIForAutoMsgReminder(branchId,tempdt,tempdt,uu.getModuleType(),conn);
		    	       // System.out.println(emiList.size()+"========"+tempdt);
		    	        for(UserInfo ll: emiList)
		    	        {
		    	        	if(uu.getFrequency()==ll.getFrequency() && ll.getAmount()>0)
		    	        	{	
		    	        		boolean isDLT = dbmt.isDLTMessageApi(conn);			    	        		
		    	        		
		    	        		if (isDLT) 
		    	        		{
		    	        			Map<String, String> variables = new HashMap<>();
			    	        		
			    	        		variables.put("name", ll.getFirst_applicantName());
			    	        		variables.put("loanType", uu.getModuleType());
			    	        		variables.put("amount", String.valueOf(ll.getAmount()));
			    	        		variables.put("date", ll.getEntryDateStr());
		    	        			
		    	        			System.out.println("DLT MESSAGE API CALLED");
		    	        		    dbmt.sendDLTMessage(ll.getContactNo(), null, variables, conn, "upcoming emi");
								}
		    	        		else
								{
								    System.out.println("OLD MESSAGE API SELECTED");
								    String typeMessage="Dear "+ll.getFirst_applicantName()+", Your "+uu.getModuleType()+" EMI Rs. "+ll.getAmount() +" "
			    	        				+ "is Upcoming On "+ll.getEntryDateStr() ;
								    db.runMessageUrl(branchId, ll.getContactNo(), typeMessage, "admin", "1207166101557460886", conn);
								}	
		    	        	}
		    	        }
		    		}
		    	}	
			}
		}
		
		try 
		{
			conn.close();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
    }
    
}