package report_package;

import java.io.Serializable;
import java.sql.Connection;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.UserInfo;

@ManagedBean(name="matured_rd_fd_report")
@ViewScoped
public class MaturedRD_FD_ReportBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	UserInfo selectedUser;
	ArrayList<UserInfo> list;
	String user_no;
	Date startDate=new Date(),endDate=new Date();
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	
	public void maturedRD()
	{
		if(branchId != 0)
		{
			list=obj1.maturedDdRdFdList(branchId,startDate,endDate);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
		
	}
	
	public MaturedRD_FD_ReportBean() 
	{
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		startDate.setDate(1);
		list=obj1.maturedDdRdFdList(branchId,startDate,endDate);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String checkInstallmentStatus()
	{
		user_no=selectedUser.getUser_no();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selected", selectedUser);
		int n=new DataBaseMethods().showInstallmentStatus(user_no);
		if(n>=1)
		{
			return "returnMaturedAmount";
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("User "+user_no+" Has Pending Installments. Unable To Receive Maturity Amount."));
			return "";
		}
	}
	
	public String getUser_no() {
		return user_no;
	}
	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	public ArrayList<UserInfo> getList() {
		return list;
	}
	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}
	public Date getStartDate() {
		return startDate;
	}
	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}
	public Date getEndDate() {
		return endDate;
	}
	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}
	
}
