package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

import other_package.ReportInfo;

@ManagedBean(name="rdEmiForward")
@ViewScoped
public class RdEmiForwardBean implements Serializable
{
	UserInfo user_info;
	InstallmentInfo selectedRow;
	String user_no, remark, searchType;
	boolean show;
	Date finalDate=new Date();
	int startRange, endRange;
	ArrayList<ReportInfo> printDepositList;
	List<String> nameList;
	double maturity_value,amount,totalPaid, totalDue;
	ArrayList<InstallmentInfo> list, rdPayList;
	DataBaseMethods obj=new DataBaseMethods();
	DecimalFormat dc=new DecimalFormat("##.##");
	
	public List<String> completeUserNo(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		nameList=new DataBaseAutoCompAndDuplicate().userAccoutnNoFrequencyWise(branchId,name,searchType, obj.userId());
     	return nameList;
	}
	
	public void selectMessage()
	{
		if(searchType.equals("1"))
		{
	    	searchType=null;
	    	user_no=null;
		}
		
	}
	
	public void userInfo() 
	{
		show=true;
		Connection conn=DataBaseConnection.JAVAConnection();
		if(user_no.contains("/"))
		{
			user_no=user_no.substring(0,user_no.indexOf("/"));
		}
		user_info = obj.userInfoDuringTransaction(user_no);
		
        list=obj.showInstallment(user_no,conn);
         //For Color
    	for(int l=0;l<list.size();l++)
		{
			Date dt=new Date();
			if(list.get(l).getStatus().equalsIgnoreCase("Paid"))
			{
				list.get(l).setColorStatus("paid");
			}
			else
			{
				if(list.get(l).getInstlmntDate().before(dt))
				{
					list.get(l).setColorStatus("due");
				}
				else
				{
					list.get(l).setColorStatus("upcoming");
				}
			}
		}
        
        totalPaid=totalDue=0;
        for(InstallmentInfo ii : list)
        {
        	maturity_value=(ii.getTot_sum());
        	totalPaid+=ii.getPaidAmount();
        	totalDue+=ii.getDueAmount();
        }
        
        totalPaid=Double.parseDouble(dc.format(totalPaid));
        totalDue=Double.parseDouble(dc.format(totalDue));
        maturity_value=Math.round(maturity_value);
        
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void printDailyPay()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		
		ArrayList<ReportInfo> dailyPayList= new ArrayList<>();
		// System.out.println(selectedUser.getUser_no());
		// System.out.println(selectedUser.getScheme_type());
		dailyPayList= obj.dailyRDFDReport(user_info.getUser_no(),user_info.getScheme_type(),con);
		try 
		{
			con.close();
		} 
		catch (Exception e) 
		{
			// TODO: handle exception
		}
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("RDFDailyPayList", dailyPayList);
		ss.setAttribute("selectedUserInfo", user_info);
		ss.setAttribute("totalSchDue", totalDue);
		ss.setAttribute("totalSchPaid", totalPaid);
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDateSchemePayment.xhtml')");
		
	}
	
	// Single Loan Emi detail update block due to multiple loan emi udpate on 08 sept 2019 by Garg
	public void updateSingleMeetingDay()
	{
		boolean flag=true;
		for(int i=selectedRow.getSno()-1;i<list.size();i++)
		{
			if(flag==true)
			{
				list.get(i).setIns_date(new SimpleDateFormat("dd/MM/yyyy").format(finalDate));
				flag=false;
			}
			else
			{
				if(user_info.getFrequency()==12 || user_info.getFrequency()==4 || user_info.getFrequency()==2 || user_info.getFrequency()==1)
				{
					finalDate.setMonth(finalDate.getMonth()+1);
				}
				else
				{
					finalDate.setDate(finalDate.getDate()+(365/user_info.getFrequency()));
				}
				list.get(i).setIns_date(new SimpleDateFormat("dd/MM/yyyy").format(finalDate));
			}
		}
		
		int i=obj.insertRdGroupLoanEmi(list, user_no, remark);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Meeting Day Update Sucessfully."));
			finalDate.setDate(finalDate.getDate()+(365/user_info.getFrequency()));
			obj.updateMaturityDate(finalDate, selectedRow.getUser_no());
			finalDate=new Date();
			userInfo();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error in updation ???"));
		}
	}
	
	public void checkPaidDetail()
	{
		rdPayList=obj.checkRdFdPaidDetailByUserNo(user_info.getUser_no());
	}
	
	public void checkPaidDetailForPrint()
	{
		printDepositList=obj.checkRdFdPaidDetailByUserNoForPrint(user_info.getUser_no());
	}

	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	public String getUser_no() {
		return user_no;
	}

	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}

	public int getStartRange() {
		return startRange;
	}

	public void setStartRange(int startRange) {
		this.startRange = startRange;
	}

	public int getEndRange() {
		return endRange;
	}

	public void setEndRange(int endRange) {
		this.endRange = endRange;
	}

	public ArrayList<ReportInfo> getPrintDepositList() {
		return printDepositList;
	}

	public void setPrintDepositList(ArrayList<ReportInfo> printDepositList) {
		this.printDepositList = printDepositList;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	public double getMaturity_value() {
		return maturity_value;
	}

	public void setMaturity_value(double maturity_value) {
		this.maturity_value = maturity_value;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public double getTotalPaid() {
		return totalPaid;
	}

	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}

	public double getTotalDue() {
		return totalDue;
	}

	public void setTotalDue(double totalDue) {
		this.totalDue = totalDue;
	}

	public ArrayList<InstallmentInfo> getList() {
		return list;
	}

	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}

	public ArrayList<InstallmentInfo> getRdPayList() {
		return rdPayList;
	}

	public void setRdPayList(ArrayList<InstallmentInfo> rdPayList) {
		this.rdPayList = rdPayList;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}



	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public Date getFinalDate() {
		return finalDate;
	}

	public void setFinalDate(Date finalDate) {
		this.finalDate = finalDate;
	}

	public InstallmentInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(InstallmentInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}
}
