package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
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.DataBaseMethodsHemant;
import main_package.FixedAssetsInfo;
import main_package.SavingAccountInfo;

@ManagedBean(name="fasr")
@ViewScoped
public class FixedAssetsSaleReportBean implements Serializable
{
	Date startDate=new Date(),endDate=new Date();
	boolean show;
	ArrayList<FixedAssetsInfo> list;
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();

	boolean disAll;
	String userType;
	
	public FixedAssetsSaleReportBean() 
	{
		startDate.setYear(startDate.getYear()-1);

		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		
		String cc=(String) ss.getAttribute("companyName");

		userType= (String) ss.getAttribute("type");
		
	    disAll= dbmh.disAllByCompanyNameUserType(userType,cc);

		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	
	}
	
	public void view()
	{  
		if(branchId != 0)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			list=obj1.fixedAssetsSaleReport(branchId,startDate, endDate,conn);
			
			if(list.size()>0)
			{
				show=true;
			}
			else
			{
				show=false;
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found"));
			}  try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}

	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 boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public ArrayList<FixedAssetsInfo> getList() {
		return list;
	}

	public void setList(ArrayList<FixedAssetsInfo> list) {
		this.list = list;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public boolean isDisAll() {
		return disAll;
	}

	public void setDisAll(boolean disAll) {
		this.disAll = disAll;
	}

	public String getUserType() {
		return userType;
	}

	public void setUserType(String userType) {
		this.userType = userType;
	}

	
	
}
