package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.HeaderBean;
import main_package.UserInfo;

@ManagedBean(name="shareHolderReport")
@ViewScoped

public class ShareHolderReport implements Serializable
{
	private static final long serialVersionUID = 1L;
	Date startdate=new Date(),enddate=new Date();
	ArrayList<UserInfo> list;
	int totalHolders,sno;
	boolean show;
	double totalamount, totalAmt, totalShare;
	String shareType;
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	
	public ShareHolderReport()
	{
		//list = new DataBase().allShareHolders();
		totalAmt=totalShare=0;
		startdate.setMonth(startdate.getMonth()-1);
		/*list = obj1.shareHoldersBtwDate(startdate,enddate);
		totalHolders = list.size();
		sno=1;
		for(UserInfo info:list)
		{
			info.setSno(sno++);
			totalShare+=info.getNoOfShare();
			totalAmt+=info.getTotalAmount();
			//totalamount = totalamount + info.getTotalAmount();
		}
		
		
		totalamount=new DataBase().extractCompanyShareAmount()*new DataBase().extractTotalShares();*/
	}
	
	public void view()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		totalamount=0;
		totalAmt=totalShare=0;
		if(shareType.equalsIgnoreCase("Initial"))
		{
			list = obj1.shareHoldersBtwDate(branchId,startdate,enddate);
		}
		else
		{
			list = obj1.shareHoldersBtwDateFromShareInfo(branchId,startdate,enddate);
		}
	
		show=true;
		totalHolders = list.size();
		sno=1;
		for(UserInfo info:list)
		{
			info.setSno(sno++);
			//totalamount = totalamount + info.getTotalAmount();
			totalShare+=info.getNoOfShare();
			totalAmt+=info.getTotalAmount();
		}
		totalamount=new DataBaseMethods().extractCompanyShareAmount(conn)*new DataBaseMethods().extractTotalShares();
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String print()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("report", "share");
		ss.setAttribute("shareList", list);
		return "printShareHolderReport";
		
	}
	
	public int getTotalHolders() {
		return totalHolders;
	}

	public void setTotalHolders(int totalHolders) {
		this.totalHolders = totalHolders;
	}

	public double getTotalamount() {
		return totalamount;
	}

	public void setTotalamount(double totalamount) {
		this.totalamount = totalamount;
	}

	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 ArrayList<UserInfo> getList() {
		return list;
	}

	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}

	public int getSno() {
		return sno;
	}

	public void setSno(int sno) {
		this.sno = sno;
	}

	public double getTotalAmt() {
		return totalAmt;
	}

	public void setTotalAmt(double totalAmt) {
		this.totalAmt = totalAmt;
	}

	public double getTotalShare() {
		return totalShare;
	}

	public void setTotalShare(double totalShare) {
		this.totalShare = totalShare;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public String getShareType() {
		return shareType;
	}

	public void setShareType(String shareType) {
		this.shareType = shareType;
	}
	
	
}
