package report_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 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.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.InstallmentInfo;
import main_package.LoanInfo;
import main_package.SavingAccountInfo;
import main_package.UserInfo;

@ManagedBean(name="currentDepositReport")
@ViewScoped
public class CurrentDepositReportBean implements Serializable
{
	String searchType;
	boolean show, showMain;
	ArrayList<UserInfo> list1, list2; 
	DataBaseMethods db=new DataBaseMethods();
	double totalIntr, total, totalInterest, totalDetail, totalDetailInterest;
	DataBaseMethods obj=new DataBaseMethods();
	ArrayList<UserInfo> rdFdList,particularList;
	ArrayList<InstallmentInfo> paidInstallmentList,interestList;
	ArrayList<InstallmentInfo>finalList,lastList;
	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");
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	
	public CurrentDepositReportBean() 
	{
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		
		dateChecking();
	}
	
	public void searchReport()
	{
		showMain=true;
		searchData();
	}
	
	public void searchData() 
	{
		
		if(branchId != 0)
		{
			String sDate=new SimpleDateFormat("yyyy-MM-dd").format(startDate);
			String eDate=new SimpleDateFormat("yyyy-MM-dd").format(endDate);
			list1=new ArrayList<>();
			Connection conn=DataBaseConnection.JAVAConnection();
			UserInfo uu1=new UserInfo();
			uu1.setSno(1);
			uu1.setStatus("DD");
			uu1.setDepositAmt(db.totalActiveDepositAmountTaken(branchId,"DD",conn,sDate, eDate));
			uu1.setReturnAmount(Double.parseDouble(dc.format(db.totalDDRDFDAmountReturnSchemeTypeWise(branchId,startDate, endDate, "DD", conn))));
			uu1.setBalance(uu1.getDepositAmt()-uu1.getReturnAmount());
			searchType="DD";
			double intr=view();
			uu1.setInterest(intr);
			
			list1.add(uu1);
			
			UserInfo uu2=new UserInfo();
			uu2.setSno(2);
			uu2.setStatus("RD");
			uu2.setDepositAmt(db.totalActiveDepositAmountTaken(branchId,"RD",conn,sDate, eDate));
			uu2.setReturnAmount(Double.parseDouble(dc.format(db.totalDDRDFDAmountReturnSchemeTypeWise(branchId,startDate, endDate, "RD", conn))));
			uu2.setBalance(uu2.getDepositAmt()-uu2.getReturnAmount());
			searchType="RD";
			double intrRd=view();
			uu2.setInterest(intrRd);
			
			list1.add(uu2);
			
			UserInfo uu3=new UserInfo();
			uu3.setSno(3);
			uu3.setStatus("FD");
			uu3.setDepositAmt(db.totalActiveDepositAmountTaken(branchId,"FD", conn,sDate, eDate));
			uu3.setReturnAmount(Double.parseDouble(dc.format(db.totalDDRDFDAmountReturnSchemeTypeWise(branchId,startDate, endDate, "FD", conn))));
			uu3.setBalance(uu3.getDepositAmt()-uu3.getReturnAmount());
			searchType="FD";
			double intrFd=view();
			uu3.setInterest(intrFd);
			
			list1.add(uu3);
			
			UserInfo uu4=new UserInfo();
			uu4.setSno(4);
			uu4.setStatus("Saving");
			uu4.setDepositAmt(db.savingTotalCurrentBalance(branchId));
			uu4.setInterest(db.savingAccInterest("all",branchId, conn));
			
			list1.add(uu4);
			
			total=totalInterest=0;
			for(UserInfo uu: list1)
			{
				total+=uu.getDepositAmt();
				totalInterest+=uu.getInterest();
			}
			totalInterest=Double.parseDouble(dc.format(totalInterest));
			
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}

	public void searchDetail()
	{
		String eDate=new SimpleDateFormat("yyyy-MM-dd").format(endDate);
		Connection conn=DataBaseConnection.JAVAConnection();
		totalDetail=totalDetailInterest=0;
		show=true;
		
		if(searchType.equalsIgnoreCase("saving"))
		{
			list2=db.activeSavingAmountDetailList(branchId,conn);
		}
		else
		{
			list2=db.activeDepositAmountDetailList(searchType,conn, eDate,branchId);
			
			view();
			
			for(UserInfo uu: list2)
			{
				double tot=0;
				for(InstallmentInfo ii: lastList)
				{
					if(uu.getAccountNo().equals(ii.getUser_no()))
					{
						tot+=ii.getInterest();
					}
				}
				uu.setInterest(Double.parseDouble(dc.format(tot)));
			}
		}
		
		
		for(UserInfo uu: list2)
		{
			totalDetail+=uu.getDepositAmt();
			totalDetailInterest+=uu.getInterest();
		}
		totalDetailInterest=Double.parseDouble(dc.format(totalDetailInterest));
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	public void dateChecking()
	{
		startDate.setYear(startDate.getYear()-10);
		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 double view()
	{
		HttpSession ss0=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss0.getAttribute("branchId");
		rdFdList=obj.showUser(branchId,searchType);
		Connection conn=DataBaseConnection.JAVAConnection();
		totalIntr=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(searchType))
			{
				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);
		//	System.out.println(rr.getInterest());
			totalIntr+=rr.getInterest();
		}
		totalIntr=Double.parseDouble(dc.format(totalIntr));
		/*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
		}
		return totalIntr;
	}
	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 ArrayList<UserInfo> getList1() {
		return list1;
	}

	public void setList1(ArrayList<UserInfo> list1) {
		this.list1 = list1;
	}

	public ArrayList<UserInfo> getList2() {
		return list2;
	}

	public void setList2(ArrayList<UserInfo> list2) {
		this.list2 = list2;
	}

	public double getTotal() {
		return total;
	}

	public void setTotal(double total) {
		this.total = total;
	}

	public double getTotalDetail() {
		return totalDetail;
	}

	public void setTotalDetail(double totalDetail) {
		this.totalDetail = totalDetail;
	}

	public double getTotalInterest() {
		return totalInterest;
	}

	public void setTotalInterest(double totalInterest) {
		this.totalInterest = totalInterest;
	}

	public double getTotalDetailInterest() {
		return totalDetailInterest;
	}

	public void setTotalDetailInterest(double totalDetailInterest) {
		this.totalDetailInterest = totalDetailInterest;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public boolean isShowMain() {
		return showMain;
	}

	public void setShowMain(boolean showMain) {
		this.showMain = showMain;
	}

	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;
	}

	
	
}
