package trigger_package;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DsaListInfo;
import main_package.UserInfo;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import report_package.DataBaseReportMethods;

public class CenterEmiReminderJob implements Job
{
	DataBaseMethods db=new DataBaseMethods();
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	ArrayList<SelectItem> centerList=new ArrayList<>();
	String[] selectedCenter;
	
    public void execute(JobExecutionContext context)throws JobExecutionException
    {

    	
    	
    	
    	DataBaseMethods db=new DataBaseMethods();
		DataBaseReportMethods dbmr=new DataBaseReportMethods();
		Connection conn=DataBaseConnection.JAVAConnection();
		List<Integer> branchList = new ArrayList<Integer>();
		
		String msgStatus=db.checkMessageApiStatus(conn);
		if(msgStatus.equalsIgnoreCase("active"))
		{
			branchList = new DataBaseMethods().branchListAll(conn);
			for(int j=0;j<branchList.size();j++)
				 {
						int branchId = branchList.get(j);
						ArrayList<UserInfo> emiList;
				    	ArrayList<SelectItem> dsaList;
				    	Date currDate=new Date();
				    	String typeMsg="Dear Sir, Today Loan EMI Upcoming From Following Center's ";
				    	emiList=dbmr.allUpcomingEMIForCenterReminder(branchId,currDate,currDate,"loan","",conn);
				    	
				    	
				    	 
				    	 if(emiList.size()>0)
				    	 {
				    		 int count=1;
				    		 double amt=0;
				    		 for(int i=0;i<emiList.size();i++)
				        	 {
				        		 if(i==0)
				        		 {
				        			 typeMsg+=count+". "+emiList.get(i).getCenterCode()+" - "+emiList.get(i).getCenterName()+", ";
				        			 count++;
				        			 i++;
				        		 }
				        		 
				        		 if(!emiList.get(i).getCenterCode().equalsIgnoreCase(emiList.get(i-1).getCenterCode()))
				        		 {
				        			 typeMsg+=count+". "+emiList.get(i).getCenterCode()+" - "+emiList.get(i).getCenterName()+", ";
				        			 count++;
				        		 }
				        		 amt+=emiList.get(i).getAmount();
				        	 }
				    		 
				    		 typeMsg+=" Total Due Amount Rs. "+amt+" /- .";
				    		 
				    		 String contactNo=db.contactNoForSchedularMsg(branchId,conn);
				    		 db.runMessageUrl(branchId,contactNo, typeMsg, "System","1207161769137065992", conn);
				    		 
				    		 String contactNo2=db.contactNoForSchedularMsgForOtherDirectors(branchId,"mobile_no_two", conn);
							if(contactNo2!=null && !contactNo2.trim().equalsIgnoreCase("") && contactNo2.length()==10)
							{
								 db.runMessageUrl(branchId,contactNo2, typeMsg, "System","1207161769137065992", conn);
							}
							
							String contactNo3=db.contactNoForSchedularMsgForOtherDirectors(branchId,"mobile_no_three", conn);
							if(contactNo3!=null && !contactNo3.trim().equalsIgnoreCase("") && contactNo3.length()==10)
							{
								 db.runMessageUrl(branchId,contactNo3, typeMsg, "System","1207161769137065992", conn);
							}
								
				    	 }
				    	 
				    	 
				    	 dsaList=db.allDsaList(branchId,"",conn);
				    	 if(dsaList.size()>0)
				    	 {
				    		 int count=1;
				    		 double amt=0;
				    		 for(SelectItem ss: dsaList)
				    		 {
				    			 String dsaCode=String.valueOf(ss.getValue());
				    			 String dsaMsg="Dear "+ss.getLabel()+", Today Loan EMI Upcoming From Following Center's ";
				    		     emiList=dbmr.allUpcomingEMIForCenterReminder(branchId,currDate,currDate,"loan",dsaCode,conn);
				    		     if(emiList.size()>0)
				    	    	 {
				    		    	 for(int i=0;i<emiList.size();i++)
				                	 {
				                		 if(i==0)
				                		 {
				                			 dsaMsg+=count+". "+emiList.get(i).getCenterCode()+" - "+emiList.get(i).getCenterName()+", ";
				                			 count++;
				                			 i++;
				                		 }
				                		 
				                		 if(!emiList.get(i).getCenterCode().equalsIgnoreCase(emiList.get(i-1).getCenterCode()))
				                		 {
				                			 dsaMsg+=count+". "+emiList.get(i).getCenterCode()+" - "+emiList.get(i).getCenterName()+", ";
				                			 count++;
				                		 }
				                		 amt+=emiList.get(i).getAmount();
				                	 }
				    		    	 
				    		    	 dsaMsg+=" Total Due Amount Rs. "+amt+" /- .";
				        		     DsaListInfo dsaDetail=db.dsaInfoByCode(dsaCode, "");
				            		 String contactNo=dsaDetail.getMobile();
				            		 db.runMessageUrl(branchId,contactNo, dsaMsg, "System","1207161769137065992", conn);
				            		 
				            		 dsaMsg="";
				    	    	 }
				    		 }
				    	 }
					}
		        }
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    }
}
