package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
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 org.primefaces.context.RequestContext;

@ManagedBean(name="checkLiability")
@ViewScoped

public class CheckLiabilitiesBean implements Serializable
{DataBaseMethods obj=new DataBaseMethods();
	ArrayList<UserInfo> rdFdList,particularList;
	ArrayList<InstallmentInfo> paidInstallmentList,interestList;
	ArrayList<InstallmentInfo>finalList,lastList;
	String type;
	ArrayList<LoanInfo> loanEMIList;
	Date tdyDate,standard,date1,date2,date3,date4,date5,date6,date7,date8,startDate=new Date(),endDate=new Date();
	Timestamp tdydt,stndrd,dt1,dt2,dt3,dt4,dt5,dt6,dt7,dt8;
	boolean renderRDFDButton,renderSVButton,renderLoanButton, showOther;
	ArrayList<String> loanList;
	DataBaseMethods obj1=new DataBaseMethods();
	DecimalFormat dc=new DecimalFormat("##.##");
	SimpleDateFormat df=new SimpleDateFormat("dd/MM/yyyy");
	
	public CheckLiabilitiesBean() 
	{
		startDate.setMonth(startDate.getMonth()-1);
		date1=new Date();date2=new Date();
		date3=new Date();date4=new Date();
		date5=new Date();date6=new Date();
		date7=new Date();date8=new Date();
		
		dt1=new Timestamp(date1.getTime());dt2=new Timestamp(date2.getTime());
		dt3=new Timestamp(date3.getTime());dt4=new Timestamp(date4.getTime());
		dt5=new Timestamp(date5.getTime());dt6=new Timestamp(date6.getTime());
		dt7=new Timestamp(date7.getTime());dt8=new Timestamp(date8.getTime());
		

		standard=new Date();
		tdyDate=new Date();
		tdydt=new Timestamp(tdyDate.getTime());
		tdydt.setHours(0);tdydt.setMinutes(0);tdydt.setSeconds(0);tdydt.setNanos(0);
		
		// // // System.out.println("tdy : "+tdydt);
		
		stndrd=new Timestamp(standard.getTime());
		stndrd.setDate(30);
		stndrd.setMonth(5);
		stndrd.setYear(tdydt.getYear());
		stndrd.setHours(0);stndrd.setMinutes(0);stndrd.setSeconds(0);stndrd.setNanos(0);
		
		dt1.setDate(1);
		dt1.setMonth(3);
		dt1.setHours(0);dt1.setMinutes(0);dt1.setSeconds(0);dt1.setNanos(0);
		
		dt2.setDate(30);
		dt2.setMonth(5);
		dt2.setHours(0);dt2.setMinutes(0);dt2.setSeconds(0);dt2.setNanos(0);

		dt3.setDate(1);
		dt3.setMonth(6);
		dt3.setHours(0);dt3.setMinutes(0);dt3.setSeconds(0);dt3.setNanos(0);

		dt4.setDate(30);
		dt4.setMonth(8);
		dt4.setHours(0);dt4.setMinutes(0);dt4.setSeconds(0);dt4.setNanos(0);

		dt5.setDate(1);
		dt5.setMonth(9);
		dt5.setHours(0);dt5.setMinutes(0);dt5.setSeconds(0);dt5.setNanos(0);

		dt6.setDate(31);
		dt6.setMonth(11);
		dt6.setHours(0);dt6.setMinutes(0);dt6.setSeconds(0);dt6.setNanos(0);

		dt7.setDate(1);
		dt7.setMonth(0);
		dt7.setHours(0);dt7.setMinutes(0);dt7.setSeconds(0);dt7.setNanos(0);

		dt8.setDate(31);
		dt8.setMonth(2);
		dt8.setHours(0);dt8.setMinutes(0);dt8.setSeconds(0);dt8.setNanos(0);
	}
	
	/*public void checkLiabilityType()
	{
		if(type.equals("SV"))
		{
			renderLoanButton=false;
			renderRDFDButton=false;
			renderSVButton=true;
		}
		else if(type.equals("loan"))
		{
			renderLoanButton=true;
			renderRDFDButton=false;
			renderSVButton=false;
		}
		else
		{
			renderLoanButton=false;
			renderRDFDButton=true;
			renderSVButton=false;
		}
	}*/
	
	public void checkLiabilityType()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		total=0;
		showOther=false;
		if(type.equals("SV"))
		{
			showOther=true;
			viewSavingsReport();
		}
		else if(type.equals("loan"))
		{
			viewLoanReport();
		}
		else if(type.equals("loanAccrued"))
		{
			viewAccruedLoanReport();
		}
		else
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			
			rdFdList=obj1.showUser(branchId,type);
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
			view();
		}
	}
	
	
	private void viewAccruedLoanReport() 
	{
		HttpSession ss1=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss1.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		lastList=new ArrayList<>();
		ArrayList<SelectItem> loanTypeList=new DataBaseMethods().loanTypeList1();
		for(SelectItem ss: loanTypeList)
		{
			loanList=new DataBaseMethods().allActiveLoan(branchId,String.valueOf(ss.getValue()));
			for(String vv: loanList)
			{
				loanEMIList=new DataBaseMethods().loanInstallment(String.valueOf(ss.getValue()), vv, conn);
				for(int l=0;l<loanEMIList.size();l++)
				{
					if(loanEMIList.get(l).getStatus().equalsIgnoreCase("due"))
					{
						if((loanEMIList.get(l).getInstallDate().after(startDate) || loanEMIList.get(l).getInstallDate().equals(startDate)) && (loanEMIList.get(l).getInstallDate().before(endDate) || loanEMIList.get(l).getInstallDate().equals(endDate)))
						{
							if(loanEMIList.get(l).getPaidAmount()<Double.parseDouble(loanEMIList.get(l).getInterestAmount()))
							{
								InstallmentInfo oo=new InstallmentInfo();
								
								oo.setUser_no(vv);
								oo.setInterest(Double.parseDouble(dc.format(Double.parseDouble(loanEMIList.get(l).getInterestAmount())-loanEMIList.get(l).getPaidAmount())));
								oo.setOffice_date(loanEMIList.get(l).getInstallDate());
								oo.setStrPayOutDate(df.format(oo.getOffice_date()));
								
								lastList.add(oo);
							}
						}
					}
				}
			}
		}
		
		int r=0;
		for(InstallmentInfo rr : lastList)
		{
			rr.setSno(++r);
			total+=rr.getInterest();
		}
		total=Double.parseDouble(dc.format(total));
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void viewSavingsReport()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		total=0;
		finalList=new ArrayList<>();
		lastList=new ArrayList<>();

		if(startDate==null || endDate==null)
		{
			lastList=obj.interestListOfCustomerDeposit(branchId);
		}
		else if(startDate.after(endDate))
		{
			lastList=new ArrayList<>();
			finalList=new ArrayList<>();
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please enter dates properly!"));
		}
		else
		{
			Timestamp start=new Timestamp(startDate.getTime());
			Timestamp end=new Timestamp(endDate.getTime());
			lastList=obj.interestListOfCustomerDeposit(branchId,start,end);
		}
		
		int k=0;
		for(InstallmentInfo tt : lastList)
		{
			tt.setSno(++k);
			total+=tt.getInterest();
		}
		total=Double.parseDouble(dc.format(total));
	}
	
	public void viewLoanReport()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		total=0;
		finalList=new ArrayList<>();
		lastList=new ArrayList<>();

		if(startDate==null || endDate==null)
		{
			lastList=obj.interestListOfLoanPayment(branchId);
		}
		else if(startDate.after(endDate))
		{
			lastList=new ArrayList<>();
			finalList=new ArrayList<>();
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please enter dates properly!"));
		}
		else
		{
			Timestamp start=new Timestamp(startDate.getTime());
			Timestamp end=new Timestamp(endDate.getTime());
			lastList=obj.interestListOfLoanPayment(branchId,start,end);
		}
		
		int k=0;
		for(InstallmentInfo tt : lastList)
		{
			tt.setSno(++k);
			total+=tt.getInterest();
		}
		total=Double.parseDouble(dc.format(total));
	}
	
	double total=0;
	public void view()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		total=0;
		interestList=new ArrayList<>();
		particularList=new ArrayList<>();
		paidInstallmentList=new ArrayList<>();
		finalList=new ArrayList<>();
		lastList=new ArrayList<>();

		boolean intfirst=false,intsecond=false,intthird=false,intfourth=false;
		for(UserInfo info : rdFdList)
		{
			UserInfo ii=new UserInfo();
			if(info.getScheme_type().equals(type))
			{
				ii.setScheme_type(info.getScheme_type());
				ii.setUser_no(info.getUser_no());
				ii.setOffice_date(info.getOffice_date());
				ii.setFirst_applicantName(info.getFirst_applicantName());
				ii.setInstallment_amount(info.getInstallment_amount());
				ii.setStrMatDate(info.getStrMatDate());
				
				particularList.add(ii);
				
			}
		}
		for(UserInfo uu : particularList)
		{
			// System.out.println("dsaassssssssssssssssssss"+uu.getUser_no());
			paidInstallmentList=obj.showInstallment(uu.getUser_no(),conn);
			if(paidInstallmentList!=null)
			{
				for(InstallmentInfo ll : paidInstallmentList)
				{
					InstallmentInfo oo=new InstallmentInfo();
					if(ll.getStatus().equals("Paid"))
					{
						// System.out.println(ll.getUser_no());
						oo.setUser_no(ll.getUser_no());
						oo.setCalc_interest(ll.getCalc_interest());
						oo.setOffice_date(uu.getOffice_date());
						oo.setStatus(ll.getStatus());
						oo.setInstlmntDate(ll.getInstlmntDate());
						oo.setIns_date(ll.getIns_date()); 
						interestList.add(oo);
					}
					
				}
			}
			
		}
		int i=0;
		int j=0;
		int year=0;
		for(InstallmentInfo ff : interestList)
		{
			String usercode="";
			
			
			double interest1=0,interest2=0,interest3=0,interest4=0;
			InstallmentInfo ss=new InstallmentInfo();
			Timestamp insdt=new Timestamp(ff.getInstlmntDate().getTime());

			if(i>0)
			{
				usercode=interestList.get(i-1).getUser_no();
			}
			
			if(!(usercode.equals(ff.getUser_no())))
			{
				j=0;
			}
			
			if(j==0)
			{
				//year=cudate.getYear();
				year=ff.getOffice_date().getYear();
			}
			
			dt1.setYear(year);dt2.setYear(year);dt3.setYear(year);
			dt4.setYear(year);dt5.setYear(year);dt6.setYear(year);
			dt7.setYear(year);dt8.setYear(year);
			
			if((insdt.equals(dt1) || insdt.after(dt1)) && (insdt.equals(dt2) || insdt.before(dt2)))
			{
				
				if(intfirst==false || !(usercode.equals(ff.getUser_no())))
				{
				
					for(InstallmentInfo rr : interestList)
					{
				
						Timestamp insdt1=new Timestamp(rr.getInstlmntDate().getTime());
						if(ff.getUser_no()==null)
						{
							// System.out.println("ff null");
						}
						if(rr.getUser_no()==null)
						{
							// System.out.println("rr null");
						}
						
						if((ff.getUser_no().equals(rr.getUser_no()) && (insdt1.equals(dt1) || insdt1.after(dt1)) && (insdt1.equals(dt2) || insdt1.before(dt2)) ))
						{
							interest1=interest1+rr.getCalc_interest();
						}
					}

					intsecond=false;
					intfirst=true;
					intthird=false;
					intfourth=false;
					
					ss.setUser_no(ff.getUser_no());
					ss.setPayoutDate(dt2);
					ss.setInterest(Double.parseDouble(dc.format(interest1)));
					ss.setStrPayOutDate(new SimpleDateFormat("dd/MM/yyyy").format(ss.getPayoutDate()));
				}
				
				
			}
			else if((insdt.equals(dt3) || insdt.after(dt3)) && (insdt.equals(dt4) || insdt.before(dt4)))
			{
				if(intsecond==false || !(usercode.equals(ff.getUser_no())))
				{
					for(InstallmentInfo rr : interestList)
					{
				
						Timestamp insdt1=new Timestamp(rr.getInstlmntDate().getTime());
						if((ff.getUser_no().equals(rr.getUser_no()) && (insdt1.equals(dt3) || insdt1.after(dt3)) && (insdt1.equals(dt4) || insdt1.before(dt4)) ))
						{
							interest2=interest2+rr.getCalc_interest();
						}
					}
					
					intsecond=true;
					intfirst=false;
					intthird=false;
					intfourth=false;
					
					ss.setUser_no(ff.getUser_no());
					ss.setPayoutDate(dt4);
					ss.setInterest(Double.parseDouble(dc.format(interest2)));
					ss.setStrPayOutDate(new SimpleDateFormat("dd/MM/yyyy").format(ss.getPayoutDate()));

				}

			}
			else if((insdt.equals(dt5) || insdt.after(dt5)) && (insdt.equals(dt6) || insdt.before(dt6)))
			{	
				if(intthird==false || !(usercode.equals(ff.getUser_no())))
				{
					for(InstallmentInfo rr : interestList)
					{
				
						Timestamp insdt1=new Timestamp(rr.getInstlmntDate().getTime());
						if((ff.getUser_no().equals(rr.getUser_no()) && (insdt1.equals(dt5) || insdt1.after(dt5)) && (insdt1.equals(dt6) || insdt1.before(dt6)) ))
						{
							interest3=interest3+rr.getCalc_interest();
						}
					}
					
					intsecond=false;
					intfirst=false;
					intthird=true;
					intfourth=false;
					
					ss.setUser_no(ff.getUser_no());
					ss.setPayoutDate(dt6);
					ss.setInterest(Double.parseDouble(dc.format(interest3)));
					ss.setStrPayOutDate(new SimpleDateFormat("dd/MM/yyyy").format(ss.getPayoutDate()));

				}
				year++;

			}
			else if((insdt.equals(dt7) || insdt.after(dt7)) && (insdt.equals(dt8) || insdt.before(dt8)))
			{
				if(intfourth==false || !(usercode.equals(ff.getUser_no())))
				{
					for(InstallmentInfo rr : interestList)
					{
				
						Timestamp insdt1=new Timestamp(rr.getInstlmntDate().getTime());
						if((ff.getUser_no().equals(rr.getUser_no()) && (insdt1.equals(dt7) || insdt1.after(dt7)) && (insdt1.equals(dt8) || insdt1.before(dt8)) ))
						{
							interest4=interest4+rr.getCalc_interest();
						}
					}
					
					intsecond=false;
					intfirst=false;
					intthird=false;
					intfourth=true;
					
					ss.setUser_no(ff.getUser_no());
					ss.setPayoutDate(dt8);
					ss.setInterest(Double.parseDouble(dc.format(interest4)));
					ss.setStrPayOutDate(new SimpleDateFormat("dd/MM/yyyy").format(ss.getPayoutDate()));

				}

			}
				
			//****
			i++;j++;
			if(startDate==null || endDate==null)
			{
				if(ss.getInterest()>0 && (ss.getPayoutDate().before(tdydt) || ss.getPayoutDate().equals(tdydt)))
				{
					lastList.add(ss);
				}
			}
			else if(startDate.after(endDate))
			{
				lastList=new ArrayList<>();
				finalList=new ArrayList<>();
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please enter dates properly!"));
				break;
			}
			else
			{
				Timestamp start=new Timestamp(startDate.getTime());
				Timestamp end=new Timestamp(endDate.getTime());
				if(ss.getInterest()>0 && (ss.getPayoutDate().after(start) || ss.getPayoutDate().equals(start)) && (ss.getPayoutDate().before(end) || ss.getPayoutDate().equals(end)))
				{
					
					lastList.add(ss);
							
				}
				
				
			}
			
		}
		
		int r=0;
		for(InstallmentInfo rr : lastList)
		{
			rr.setSno(++r);
			total+=rr.getInterest();
		}
		total=Double.parseDouble(dc.format(total));
		/*if(startDate==null || endDate==null)
		{
			int k=0;
			finalList.addAll(lastList);
			for(InstallmentInfo tt : finalList)
			{
				tt.setSno(++k);
				total+=tt.getInterest();
			}
			total=Double.parseDouble(dc.format(total));
		}
		else if(startDate.after(endDate))
		{
			lastList=new ArrayList<>();
			finalList=new ArrayList<>();
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please enter dates properly!"));
		}
		else
		{
			int r=0;
			Timestamp start=new Timestamp(startDate.getTime());
			Timestamp end=new Timestamp(endDate.getTime());
			// // // System.out.println("start : "+start);// // // System.out.println("end : "+end);
			for(InstallmentInfo tt : lastList)
			{
				// // // System.out.println("tt : "+tt.getPayoutDate());
				if((tt.getPayoutDate().after(start) || tt.getPayoutDate().equals(start)) && (tt.getPayoutDate().before(end) || tt.getPayoutDate().equals(end)))
				{
					finalList.add(tt);
					
				}
				// // // System.out.println("yes");
			}
			
			for(InstallmentInfo tt : finalList)
			{
				tt.setSno(++r);
				total+=tt.getInterest();
			}
			total=Double.parseDouble(dc.format(total));
		}*/

try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void print()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("list",lastList);
		ss.setAttribute("total",total);
		ss.setAttribute("type",type);
		RequestContext.getCurrentInstance().execute("window.open('printLiabilitiesReport.xhtml')");
		
	}


	public ArrayList<InstallmentInfo> getFinalList() {
		return finalList;
	}

	public void setFinalList(ArrayList<InstallmentInfo> finalList) {
		this.finalList = finalList;
	}
	
	public ArrayList<InstallmentInfo> getInterestList() {
		return interestList;
	}

	public void setInterestList(ArrayList<InstallmentInfo> interestList) {
		this.interestList = interestList;
	}

	public ArrayList<InstallmentInfo> getPaidInstallmentList() {
		return paidInstallmentList;
	}

	public void setPaidInstallmentList(ArrayList<InstallmentInfo> paidInstallmentList) {
		this.paidInstallmentList = paidInstallmentList;
	}

	public ArrayList<UserInfo> getParticularList() {
		return particularList;
	}

	public void setParticularList(ArrayList<UserInfo> particularList) {
		this.particularList = particularList;
	}

	public ArrayList<UserInfo> getRdFdList() {
		return rdFdList;
	}

	public void setRdFdList(ArrayList<UserInfo> rdFdList) {
		this.rdFdList = rdFdList;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public double getTotal() {
		return total;
	}

	public void setTotal(double total) {
		this.total = total;
	}

	public boolean isRenderRDFDButton() {
		return renderRDFDButton;
	}

	public void setRenderRDFDButton(boolean renderRDFDButton) {
		this.renderRDFDButton = renderRDFDButton;
	}

	public boolean isRenderSVButton() {
		return renderSVButton;
	}

	public void setRenderSVButton(boolean renderSVButton) {
		this.renderSVButton = renderSVButton;
	}

	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public boolean isRenderLoanButton() {
		return renderLoanButton;
	}

	public void setRenderLoanButton(boolean renderLoanButton) {
		this.renderLoanButton = renderLoanButton;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public ArrayList<InstallmentInfo> getLastList() {
		return lastList;
	}

	public void setLastList(ArrayList<InstallmentInfo> lastList) {
		this.lastList = lastList;
	}

	public boolean isShowOther() {
		return showOther;
	}

	public void setShowOther(boolean showOther) {
		this.showOther = showOther;
	}
	
	
}
