package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

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.CenterInfo;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import report_package.BranchReportBean.DynamicColumnInfo;

@ManagedBean(name="roChart")
@ViewScoped
public class RoChartBean implements Serializable
{
	Date endDate=new Date(),startDate=new Date();
	ArrayList<SelectItem> dsaList;
	String dsaCode;
	DataBaseMethods dbm=new DataBaseMethods();
	ArrayList<CenterInfo> list;
	ArrayList<DynamicColumnInfo> columns;
	ArrayList<SelectItem> dateList;
	SimpleDateFormat sf=new SimpleDateFormat("dd/MM/yyyy");
	SimpleDateFormat sdfForDb=new SimpleDateFormat("yyyy-MM-dd"); 
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	
	public RoChartBean() 
	{
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		//branchUserId = (String) ss.getAttribute("branchUserId");
		int branchId = (int) ss.getAttribute("branchId");
		//branchList = new DataBaseMethods().branchList(branchUserId,con);
		//centerList=new DataBaseMethods().allcenter(branchId,"all",con);
		
		dsaList=dbm.allDsaList(branchId,"Loan",con);
		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void searchData()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		list=new ArrayList<>();
		
		for(int i=0;i<10;i++)
		{
			list.get(i).setSno(i);
		}
		
		
		
		dateList=new ArrayList<>();
		
		while(!startDate.equals(endDate))
		{
			SelectItem ss=new SelectItem();
			ss.setLabel(sf.format(startDate));
			ss.setValue(sdfForDb.format(startDate));
			dateList.add(ss);
			
			startDate.setDate(startDate.getDate()+1);
			System.out.println("date: "+startDate);
		}
		
		//System.out.println(itemList.size()+"========="+list.size());
		columns = new ArrayList<DynamicColumnInfo>(); 
		
		//db.calculateDailyLoanAndDDReceiveAmount(dateList, list, conn);
		
		//dbmr.centerDetailForRoChart(dateList, list, conn);
		
		for(SelectItem tt: dateList)
		{
			DynamicColumnInfo cc=new DynamicColumnInfo();
			
			//System.out.println("Label: "+tt.getLabel());
			cc.setLabel(tt.getLabel());
			cc.setValue(String.valueOf(tt.getValue()));
			
			columns.add(cc);
		}
		
		
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public ArrayList<CenterInfo> getList() {
		return list;
	}

	public void setList(ArrayList<CenterInfo> list) {
		this.list = list;
	}

	public ArrayList<DynamicColumnInfo> getColumns() {
		return columns;
	}

	public void setColumns(ArrayList<DynamicColumnInfo> columns) {
		this.columns = columns;
	}

	public ArrayList<SelectItem> getDateList() {
		return dateList;
	}

	public void setDateList(ArrayList<SelectItem> dateList) {
		this.dateList = dateList;
	}
}
