package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;

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.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.UserInfo;

@ManagedBean(name="dailyCollectionReport")
@ViewScoped
public class DailyCollectionReportBean implements Serializable
{
	double totalAmount, totalCash, totalCheque, totalPenalty, totalDiscount, dealerTotal, diffAmount;
	int totalEntries;
	Date startDate=new Date(), endDate=new Date();
	String searchType="", searchBase, userIdDsa="", payMode;
	boolean show, showLoanField, showPenalty, showReceipt, showDisount, showAll, showUserIdDsa, showDealerColumn;
	ArrayList<UserInfo> list=new ArrayList<>();
	ArrayList<SelectItem> userIdDsaList;
	DataBaseReportMethods obj=new DataBaseReportMethods();
	DecimalFormat df=new DecimalFormat("##.##");
	DataBaseMethodTaheer dbmt= new DataBaseMethodTaheer();
	
	public void searchReport()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		if(startDate.equals(endDate) || startDate.before(endDate))
		{
			if(searchType.equalsIgnoreCase("all"))
			{
				showAll=true;show=false;
				totalAmount=totalCash=totalCheque=totalPenalty=0;
				list=new ArrayList<>();
				
				UserInfo uu1=new UserInfo();
				uu1.setSno(1);
				uu1.setStatus("Loan");
				uu1.setCashInAmount(obj.dailyEmiCollectionBetweenDate(branchId,startDate, endDate, "cash", "both",conn,""));
				uu1.setBankInAmount(obj.dailyEmiCollectionBetweenDate(branchId,startDate, endDate, "bank", "both",conn, "All"));
				uu1.setTotalAmount(uu1.getCashInAmount()+uu1.getBankInAmount());
				list.add(uu1);
				
				UserInfo uu2=new UserInfo();
				uu2.setSno(2);
				uu2.setStatus("DD");
				uu2.setCashInAmount(obj.dailyRdFdCollectionBetweenDate(branchId,startDate, endDate, "cash", "DD",conn, ""));
				uu2.setBankInAmount(obj.dailyRdFdCollectionBetweenDate(branchId,startDate, endDate, "bank", "DD",conn, "All"));
				uu2.setTotalAmount(uu2.getCashInAmount()+uu2.getBankInAmount());
				list.add(uu2);
				
				
				
				UserInfo uu3=new UserInfo();
				uu3.setSno(3);
				uu3.setStatus("RD");
				uu3.setCashInAmount(obj.dailyRdFdCollectionBetweenDate(branchId,startDate, endDate, "cash", "RD",conn, ""));
				uu3.setBankInAmount(obj.dailyRdFdCollectionBetweenDate(branchId,startDate, endDate, "bank", "RD",conn, "All"));
				uu3.setTotalAmount(uu3.getCashInAmount()+uu3.getBankInAmount());
				list.add(uu3);
				
				UserInfo uu4=new UserInfo();
				uu4.setSno(4);
				uu4.setStatus("FD");
				uu4.setCashInAmount(obj.dailyRdFdCollectionBetweenDate(branchId,startDate, endDate, "cash", "FD",conn, ""));
				uu4.setBankInAmount(obj.dailyRdFdCollectionBetweenDate(branchId,startDate, endDate, "bank", "FD",conn, "All"));
				uu4.setTotalAmount(uu4.getCashInAmount()+uu4.getBankInAmount());
				list.add(uu4);
				
				
				
				for(UserInfo uu: list)
				{
					totalCash+=uu.getCashInAmount();
					totalCheque+=uu.getBankInAmount();
					totalAmount+=uu.getTotalAmount();
				}
			}
			else
			{
				showLoanField=false;
				if(searchType.equalsIgnoreCase("personalloan") || searchType.equalsIgnoreCase("grouploan") || searchType.equalsIgnoreCase("secure_loan"))
				{
					double per=new DataBaseMethods().checkDealerPayoutPercent(conn);
					if(per>0)
					{
						showDealerColumn=true;
					}
					list=obj.dailyEmiCollection(branchId,startDate, endDate,searchType,searchBase, userIdDsa, payMode, conn);
					showLoanField=true;
				}
				else if(searchType.equalsIgnoreCase("FD") || searchType.equalsIgnoreCase("RD") || searchType.equalsIgnoreCase("DD"))
				{
					list=obj.dailyRdFdCollection(branchId,startDate, searchType, endDate,searchBase, userIdDsa, conn);
				}
				else if(searchType.equalsIgnoreCase("saving"))
				{
					list=obj.dailySavingCollection(branchId,startDate, endDate,conn);
				}
				else if(searchType.equalsIgnoreCase("penalty"))
				{
					list=obj.dailyPenaltyCollection(branchId,startDate, endDate, payMode,conn);
				}
				else if(searchType.equalsIgnoreCase("bounce"))
				{
					list = dbmt.dailyBounceCollection(branchId, startDate, endDate, payMode, conn);
				}
				
				if(list.size()>0)
				{
					show=true;
					if(searchType.equalsIgnoreCase("loan"))
					{
						showPenalty=true;
					}
					else
					{
						showPenalty=false;
					}
					
					if(searchType.equals("saving") || searchType.equals("penalty"))
					{
						showReceipt=false;
					}
					else
					{
						showReceipt=true;
					}
					
					if(searchType.equals("penalty"))
					{
						showDisount=true;
					}
					else
					{
						showDisount=false;
					}
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No "+searchType+" Collection found on Selected Date."));
				}
				
				totalAmount=totalCash=totalCheque=totalPenalty=dealerTotal=diffAmount=0;
				totalEntries=list.size();
				for(UserInfo uu: list)
				{
					totalDiscount+=uu.getDiscount();
					totalPenalty+=uu.getPenalty();
					totalAmount+=uu.getAmount();
					if(uu.getPayMode().equalsIgnoreCase("cash"))
					{
						totalCash+=uu.getAmount();
					}
					else
					{
						totalCheque+=uu.getAmount();
					}
					dealerTotal+=uu.getPaidAmount();
					diffAmount+=uu.getBalance();
				}
				totalAmount=Double.parseDouble(df.format(totalAmount));
				totalCash=Double.parseDouble(df.format(totalCash));
				totalCheque=Double.parseDouble(df.format(totalCheque));
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Enter Date Properly !!!"));
		}
	}
	
	public void searchUserIdDsa()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		showUserIdDsa=true;
		Connection conn=DataBaseConnection.JAVAConnection();
		if(searchType.equalsIgnoreCase("personalloan") || searchType.equalsIgnoreCase("grouploan") || searchType.equalsIgnoreCase("secure_loan"))
		{
			userIdDsaList=obj.userIdAndDsaList(branchId,searchType, searchBase, conn);
		}
		else if(searchType.equalsIgnoreCase("FD") || searchType.equalsIgnoreCase("RD") || searchType.equalsIgnoreCase("DD"))
		{
			userIdDsaList=obj.userIdAndDsaList(branchId,searchType, searchBase, conn);
		}
		else
		{
			showUserIdDsa=false;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("This option is Available for Loan and Deposit's. Thank You !!!"));
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	public double getTotalPenalty() {
		return totalPenalty;
	}






	public void setTotalPenalty(double totalPenalty) {
		this.totalPenalty = totalPenalty;
	}






	public boolean isShowPenalty() {
		return showPenalty;
	}






	public void setShowPenalty(boolean showPenalty) {
		this.showPenalty = showPenalty;
	}






	public double getTotalAmount() {
		return totalAmount;
	}
	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}
	public int getTotalEntries() {
		return totalEntries;
	}
	public void setTotalEntries(int totalEntries) {
		this.totalEntries = totalEntries;
	}
	public Date getStartDate() {
		return startDate;
	}
	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}
	public String getSearchType() {
		return searchType;
	}
	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}






	public double getTotalCash() {
		return totalCash;
	}






	public void setTotalCash(double totalCash) {
		this.totalCash = totalCash;
	}






	public double getTotalCheque() {
		return totalCheque;
	}






	public void setTotalCheque(double totalCheque) {
		this.totalCheque = totalCheque;
	}






	public ArrayList<UserInfo> getList() {
		return list;
	}






	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}






	public boolean isShowReceipt() {
		return showReceipt;
	}






	public void setShowReceipt(boolean showReceipt) {
		this.showReceipt = showReceipt;
	}






	public Date getEndDate() {
		return endDate;
	}






	public double getTotalDiscount() {
		return totalDiscount;
	}




	public void setTotalDiscount(double totalDiscount) {
		this.totalDiscount = totalDiscount;
	}




	public boolean isShowDisount() {
		return showDisount;
	}




	public void setShowDisount(boolean showDisount) {
		this.showDisount = showDisount;
	}




	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}




	public boolean isShowAll() {
		return showAll;
	}




	public void setShowAll(boolean showAll) {
		this.showAll = showAll;
	}

	public String getSearchBase() {
		return searchBase;
	}

	public void setSearchBase(String searchBase) {
		this.searchBase = searchBase;
	}

	public String getUserIdDsa() {
		return userIdDsa;
	}

	public void setUserIdDsa(String userIdDsa) {
		this.userIdDsa = userIdDsa;
	}

	public boolean isShowUserIdDsa() {
		return showUserIdDsa;
	}

	public void setShowUserIdDsa(boolean showUserIdDsa) {
		this.showUserIdDsa = showUserIdDsa;
	}

	public ArrayList<SelectItem> getUserIdDsaList() {
		return userIdDsaList;
	}

	public void setUserIdDsaList(ArrayList<SelectItem> userIdDsaList) {
		this.userIdDsaList = userIdDsaList;
	}

	public boolean isShowDealerColumn() {
		return showDealerColumn;
	}

	public void setShowDealerColumn(boolean showDealerColumn) {
		this.showDealerColumn = showDealerColumn;
	}

	public double getDealerTotal() {
		return dealerTotal;
	}

	public void setDealerTotal(double dealerTotal) {
		this.dealerTotal = dealerTotal;
	}

	public double getDiffAmount() {
		return diffAmount;
	}

	public void setDiffAmount(double diffAmount) {
		this.diffAmount = diffAmount;
	}

	public String getPayMode() {
		return payMode;
	}

	public void setPayMode(String payMode) {
		this.payMode = payMode;
	}

	public boolean isShowLoanField() {
		return showLoanField;
	}

	public void setShowLoanField(boolean showLoanField) {
		this.showLoanField = showLoanField;
	}
	
	
}
