package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.apache.poi.util.TempFile;
import org.primefaces.context.RequestContext;

import report_package.DataBaseReportMethods;

@ViewScoped
@ManagedBean(name="manageMeetingDay")
public class ManageMeetingDayBean implements Serializable
{
	DataBaseMethods db=new DataBaseMethods();
	ArrayList<SelectItem> centerList, centerLoanList;
	ArrayList<LoanInfo> loanEMIList, rdEmiList, loanList, rdList, multiSelectLoanList,  multiSelectRdList;
	UserInfo user_info;
	LoanInfo loan_info, oldLoanInfo, selectedRow;
	String center, loanNo, loanType, remark;
	boolean show, showCenter, showOther,secEmiRequired;
	Date minDate, maxDate, finalDate, secEmiDate;
	int branchId;
	DbYashwant dby = new DbYashwant();
 	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	
	public ManageMeetingDayBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId =(int) ss.getAttribute("branchId");
		
		centerList=db.allcenter(branchId,"all",conn);
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void checkLoanListMethod()
	{
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			showCenter=true;
			showOther=false;
		}
		else
		{
			showCenter=false;
			Connection conn=DataBaseConnection.JAVAConnection();
			centerLoanList=db.loanNoListFreqWise("-1",loanType, conn);
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	public void searchLoan()
	{
		centerLoanList=new DataBaseAutoCompAndDuplicate().groupLoanListCenterWise(branchId,center);
	}
	
	public void searchData()
	{
		finalDate=new Date();
		Connection conn=DataBaseConnection.JAVAConnection();
		if(!loanType.equalsIgnoreCase("grouploan"))
		{
			showOther=true;
		}
		else
		{
			showOther=false;
		}
		user_info=db.userInfoByLoanNoLoanType(loanNo,loanType,conn);
		loan_info=db.loanInfoByLoanNoLoanType(loanNo,loanType, conn);
		oldLoanInfo=new LoanInfo();
		oldLoanInfo=loan_info;
		remark=db.remarkFromGroupLoanEmiForwardTable(loanNo, conn);
		show=true;
		loanEMIList=db.loanInstallment(loanType,loanNo, conn);
		for(int l=0;l<loanEMIList.size();l++)
		{
			Date dt=new Date();
			if(loanEMIList.get(l).getStatus().equalsIgnoreCase("Paid"))
			{
				loanEMIList.get(l).setColorStatus("paid");
				loanEMIList.get(l).setDisBtn(true);
			}
			else
			{
				if(loanEMIList.get(l).getInstallDate().before(dt))
				{
					loanEMIList.get(l).setColorStatus("due");
				}
				else
				{
					loanEMIList.get(l).setColorStatus("upcoming");
				}
				loanEMIList.get(l).setDisBtn(false);
			}
		}
		
		
		
		if(loan_info.getFrequencyVal()==24)
		{
			secEmiRequired=true;
		}
		
		rdEmiList=new ArrayList<>();
		rdEmiList=loanEMIList;
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void manageLoanListData()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		loanList=new ArrayList<>();
		int count=1;
		for(SelectItem ss: centerLoanList)
		{
			LoanInfo ll=new LoanInfo();
			
			ll.setSno(count++);
			ll.setSubLoanNo(String.valueOf(ss.getValue()));
			ll.setStatus(ss.getLabel());
			
			loanList.add(ll);
		}
		
		rdList=new ArrayList<>();
		int countRd=1;
		for(SelectItem ss: centerLoanList)
		{
			String shno=db.shareHolderNoByLoanNo(String.valueOf(ss.getValue()));
			String detail=dbmr.rdDueAmountForCdsReport(shno,selectedRow.getInstallDate(), conn);
			if(detail.contains("#"))
			{
				String arrRd[]=detail.split("\\#");
				
				if(checkRDinList(arrRd[0])==false)
				{
					LoanInfo ll=new LoanInfo();
					
					ll.setSubLoanNo(arrRd[0]);
					ll.setStatus(arrRd[0]+" / "+db.applicantNameByShareHolderNo(shno, conn)+" - "+shno+" EMI Detail: "+arrRd[1]);
					ll.setSno(countRd++);
					
					rdList.add(ll);
				}
			}
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	private boolean checkRDinList(String rdNo) 
	{
		for(LoanInfo ll: rdList)
		{
			System.out.println(ll.getSubLoanNo()+" RD: "+rdNo);
			if(ll.getSubLoanNo().contains(rdNo))
			{
				return true;
			}
		}
		return false;
	}

	// Single Loan Emi detail update block due to multiple loan emi udpate on 08 sept 2019 by Garg
	public void updateSingleMeetingDay()
	{
		int term=1,y=1,z=0;
	
	Date firstemi= new Date(finalDate.getTime());
	
	System.out.println(firstemi+"sd");
	
		boolean flag=true;
		for(int i=selectedRow.getSno()-1;i<loanEMIList.size();i++)
		{y++;
			if(flag==true)
			{
				loanEMIList.get(i).setStrInstlmntDate(new SimpleDateFormat("dd/MM/yyyy").format(finalDate));
				flag=false;
			}
			else
			{
				if(loan_info.getFrequencyVal()==12 || loan_info.getFrequencyVal()==4 || loan_info.getFrequencyVal()==2 || loan_info.getFrequencyVal()==1)
				{
					finalDate.setMonth(finalDate.getMonth()+1);
				}
				else
				{
					finalDate.setDate(finalDate.getDate()+(365/loan_info.getFrequencyVal()));
				}
				term++;
				loanEMIList.get(i).setStrInstlmntDate(new SimpleDateFormat("dd/MM/yyyy").format(finalDate));
			}
		}
		
		int i=0;
		if(loan_info.getFrequencyVal() == 24)
		{
			dby.insertFifteenDayPlanGroupLoanEmi(branchId, loanNo, "Fifteen Days Plan",term,secEmiDate,selectedRow.getSno(),firstemi);
			i=1;

		}
		else
		{
			i=db.insertGroupLoanEmi(branchId,loanEMIList, loanNo, remark);

			
		}
		if(i>0)
		{
			
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Meeting Day Update Sucessfully."));
			searchData();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error in updation ???"));
		}
	}
	
	public void updateMeetingDay() throws ParseException
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		SimpleDateFormat f = new SimpleDateFormat("dd/MM/yyyy");
		String updateDateStr=f.format(finalDate);
		if(multiSelectLoanList.size()>0)
		{
			int updateLoan=0;
			for(LoanInfo ll: multiSelectLoanList)
			{
				loanNo=ll.getSubLoanNo();
				
				boolean flag=true;
				if(loan_info.getTerms()==oldLoanInfo.getTerms() && loan_info.getFrequencyVal()==oldLoanInfo.getFrequencyVal())
				{
					for(int i=selectedRow.getSno()-1;i<loanEMIList.size();i++)
					{
						if(flag==true)
						{loan_info=db.loanInfoByLoanNoLoanType(loanNo,loanType, conn);
							loanEMIList.get(i).setStrInstlmntDate(f.format(finalDate));
							flag=false;
						}
						else
						{
							if(loan_info.getFrequencyVal()==12 || loan_info.getFrequencyVal()==4 || loan_info.getFrequencyVal()==2 || loan_info.getFrequencyVal()==1)
							{
								//System.out.println(finalDate+" before: "+loan_info.getFrequencyVal());
								finalDate.setMonth(finalDate.getMonth()+1);;
								//System.out.println(finalDate+" after: "+finalDate.getMonth());
							}
							else
							{
								finalDate.setDate(finalDate.getDate()+(365/loan_info.getFrequencyVal()));
							}
							loanEMIList.get(i).setStrInstlmntDate(f.format(finalDate));
						}
					}
					updateLoan+=db.insertGroupLoanEmi(branchId,loanEMIList, loanNo, remark);
					finalDate=f.parse(updateDateStr);
				}	
			}
			
			if(updateLoan>0)
			{
				multiSelectLoanList.clear();
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Meeting Day Update Sucessfully Of "+updateLoan+" Loan. Thank You!!!"));
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error in updation ???"));
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select Atleast One Loan No. for Updation ???"));
		}
		
		//////////////// RD Work Start
		
		if(multiSelectRdList.size()>0)
		{
			int updateRd=0;
			UserInfo rdInfo = null;
			for(LoanInfo ll: multiSelectRdList)
			{
				String rdNo=ll.getSubLoanNo();
				rdInfo=db.userInfoDuringTransaction(rdNo);
				if(loan_info.getTerms()==rdInfo.getTerms() && loan_info.getFrequencyVal()==rdInfo.getFrequency())
				{
					boolean flag=true;
					for(int i=selectedRow.getSno()-1;i<loanEMIList.size();i++)
					{
						if(flag==true)
						{
							rdEmiList.get(i).setStrInstlmntDate(f.format(finalDate));
							flag=false;
						}
						else
						{
							if(rdInfo.getFrequency()==12 || rdInfo.getFrequency()==4 || rdInfo.getFrequency()==2 || rdInfo.getFrequency()==1)
							{
								System.out.println(finalDate+" before: "+loan_info.getFrequencyVal());
								finalDate.setMonth(finalDate.getMonth()+1);;
								System.out.println(finalDate+" after: "+finalDate.getMonth());
							}
							else
							{
								finalDate.setDate(finalDate.getDate()+(365/loan_info.getFrequencyVal()));
							}
							rdEmiList.get(i).setStrInstlmntDate(f.format(finalDate));
						}
					}
					updateRd+=db.insertGroupLoanEmi(branchId,rdEmiList, rdNo, remark);
					finalDate=f.parse(updateDateStr);
				}
			}
			
			if(updateRd>0)
			{
				multiSelectRdList.clear();
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Meeting Day Update Sucessfully Of "+updateRd+" Loan. Thank You!!!"));
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error in updation ???"));
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select Atleast One RD No. for Updation ???"));
		}
		
		
		searchData();
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public ArrayList<SelectItem> getCenterLoanList() {
		return centerLoanList;
	}

	public void setCenterLoanList(ArrayList<SelectItem> centerLoanList) {
		this.centerLoanList = centerLoanList;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}

	public ArrayList<LoanInfo> getLoanEMIList() {
		return loanEMIList;
	}

	public void setLoanEMIList(ArrayList<LoanInfo> loanEMIList) {
		this.loanEMIList = loanEMIList;
	}

	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	public LoanInfo getLoan_info() {
		return loan_info;
	}

	public void setLoan_info(LoanInfo loan_info) {
		this.loan_info = loan_info;
	}

	public String getLoanNo() {
		return loanNo;
	}

	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}

	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public LoanInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(LoanInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	public Date getMinDate() {
		return minDate;
	}

	public void setMinDate(Date minDate) {
		this.minDate = minDate;
	}

	public Date getMaxDate() {
		return maxDate;
	}

	public void setMaxDate(Date maxDate) {
		this.maxDate = maxDate;
	}

	public Date getFinalDate() {
		return finalDate;
	}

	public void setFinalDate(Date finalDate) {
		this.finalDate = finalDate;
	}

	public ArrayList<LoanInfo> getLoanList() {
		return loanList;
	}

	public void setLoanList(ArrayList<LoanInfo> loanList) {
		this.loanList = loanList;
	}

	public ArrayList<LoanInfo> getMultiSelectLoanList() {
		return multiSelectLoanList;
	}

	public void setMultiSelectLoanList(ArrayList<LoanInfo> multiSelectLoanList) {
		this.multiSelectLoanList = multiSelectLoanList;
	}

	public boolean isShowCenter() {
		return showCenter;
	}

	public void setShowCenter(boolean showCenter) {
		this.showCenter = showCenter;
	}

	public boolean isShowOther() {
		return showOther;
	}

	public void setShowOther(boolean showOther) {
		this.showOther = showOther;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public ArrayList<LoanInfo> getRdList() {
		return rdList;
	}

	public void setRdList(ArrayList<LoanInfo> rdList) {
		this.rdList = rdList;
	}

	public ArrayList<LoanInfo> getMultiSelectRdList() {
		return multiSelectRdList;
	}

	public void setMultiSelectRdList(ArrayList<LoanInfo> multiSelectRdList) {
		this.multiSelectRdList = multiSelectRdList;
	}

	public Date getSecEmiDate() {
		return secEmiDate;
	}

	public void setSecEmiDate(Date secEmiDate) {
		this.secEmiDate = secEmiDate;
	}

	public boolean isSecEmiRequired() {
		return secEmiRequired;
	}

	public void setSecEmiRequired(boolean secEmiRequired) {
		this.secEmiRequired = secEmiRequired;
	}
	
}
