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.UserInfo;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import report_package.DataBaseReportMethods;

public class DsaCollectionJob implements Job
{
	int totalEntries;
	UserInfo selected;
	Date startDate=new Date(), endDate=new Date();
	ArrayList<UserInfo> list, ddlistDetail;
	ArrayList<UserInfo>allVal, loanDetail;
	double allDdTotal,allRdTotal,allFdTotal,allPlTotal,allGlTotal;
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	DataBaseMethods db= new DataBaseMethods();
	
	public void execute(JobExecutionContext context)throws JobExecutionException
    {
    	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 i=0;i<branchList.size();i++)
			  {
					int branchId = branchList.get(i);
					allDdTotal=allFdTotal=allGlTotal=allPlTotal=allRdTotal=0.00;
					allVal= new ArrayList<>();
				     String sDate = new SimpleDateFormat("yyyy/MM/dd").format(startDate);
					String eDate = new SimpleDateFormat("yyyy/MM/dd").format(endDate);
					
					list=obj1.allDsaWiseCollection(branchId,conn, sDate, eDate);
					
					
					String dt=new SimpleDateFormat("dd-MMM-yyyy").format(startDate);
					for(UserInfo uu: list)
					{
						String typeMessage="Dear "+uu.getDsaCode()+" "+uu.getDsaName() +", Your Collection Report of "+dt+" is: DD Collection Rs. "+uu.getDdAmount()+",  RD Collection Rs. "+uu.getRdAmount()+", FD Collection Rs. "+uu.getFdAmount()+", PL Collection Rs. "+uu.getPlAmount()+", GL Collection Rs. "+uu.getGlAmount()+", And Total Collection is Rs. "+uu.getTotalAmount()+", "+ "Thanks.";
						
						if(uu.getTotalAmount()>0)
						{
							db.runMessageUrl(branchId,uu.getContactNo(), typeMessage, "System","1207161769175173289", conn);
						}
					}
					
			  }
			}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	    	
}
