package report_package;

import java.io.Serializable;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
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.InstallmentInfo;
import main_package.TrialInfo;
import main_package.UserInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="trialBalance")
@ViewScoped
public class TrialBalanceBean implements Serializable
{
	Date startDate=new Date(),endDate=new Date();
	String strEndDate;
	ArrayList<TrialInfo> listShareCapital, list, list1, list2, list3, list4, list5, list6, list7, list8, list9, list10, list11, list12, listMix, list13, list14, listSaving, listInvest, listAdvance;
	double totalDr, totalLedgerDebit, totalLedgerCredit, totalCr, balanceDr, balanceCr, openingDr, openingCr;
	String totalDebit, totalCredit, closingBalance, openingDebit, openingCredit, balanceDebit, balanceCredit;
	
	double shareCapital=0,rdSum=0,fdSum=0,rdInterest=0,fdInterest=0,savingsAmount=0,savingsDeposit=0,savingsWithdrawl=0,savingsInterest=0,
			bankBalance=0,cashBalance=0,goodsAmount=0,fdrAmount=0,loanAmount=0,fdrInterestAmount=0;
	ArrayList<UserInfo> rdFdList,particularList;
	ArrayList<InstallmentInfo> paidInstallmentList,interestList;
	ArrayList<InstallmentInfo>finalList;
	Date tdyDate,standard,date1,date2,date3,date4,date5,date6,date7,date8;
	Timestamp tdydt,stndrd,dt1,dt2,dt3,dt4,dt5,dt6,dt7,dt8;
	boolean show,disEndDate;
	TrialInfo selectedRow;
	ArrayList<MembersOdInfo> ledgerDataList;
	DecimalFormat dc=new DecimalFormat("##.##");
	DataBaseMethods db=new DataBaseMethods();
	
	public TrialBalanceBean() throws ParseException 
	{
		/*startDate.setMonth(startDate.getMonth()-21);
		startDate.setDate(1);
		endDate.setDate(31);
		endDate.setMonth(endDate.getMonth()-10);*/

		HeaderBean hh=new HeaderBean();
		
		
		String sDate="01-04-"+hh.getStartFinYear();
		//String eDate="31-03-2016";
		
		SimpleDateFormat f = new SimpleDateFormat("dd-MM-yyyy");
		startDate=f.parse(sDate);
		//startDate.setMonth(startDate.getMonth()-1);
		
		/*String sDate="01-04-2016";
		String eDate="31-03-2017";
		
		SimpleDateFormat f = new SimpleDateFormat("dd-MM-yyyy");
		startDate=f.parse(sDate);
		endDate=f.parse(eDate);*/
		
		if(!hh.getSelectedSession().equals(hh.getCurrentSession()))
		{
			disEndDate=true;
			String eDate="31-03-"+hh.getEndFinYear();
			endDate=f.parse(eDate);
		}
		else
		{
			disEndDate=false;
		}
	}
	
	
	
	public void viewTrial()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		
		Connection conn=DataBaseConnection.JAVAConnection();
		openingCr=openingDr=balanceCr=balanceDr=totalCr=totalDr=0;
		show=true;
		list=new ArrayList<>();
		
		//rdInterest=view("RD");
		//fdInterest=view("FD");
		
		listShareCapital=db.trialBalanceShareCapital(-1, startDate, endDate,conn);
		list1=db.trialBalanceFdRd(-1,startDate, endDate, "DD",conn);
		list2=db.trialBalanceFdRd(-1,startDate, endDate, "RD",conn);
		list3=db.trialBalanceFdRd(-1,startDate, endDate, "FD",conn);
		list4=db.trialBalancePromotorCapital(startDate, endDate,-1,conn);
		list5=db.trialBalanceFixedAssetsExpense(-1,startDate, endDate,conn);
		list6=db.trialBalanceFixedDeposit(-1,startDate, endDate,conn);
		list7=db.trialBalanceBankAccount(-1,endDate, startDate,conn);
		list9=db.trialBalanceAllLoanPayementAndReceipt(-1,startDate, endDate,conn);
		list14=db.trialBalanceOdLoanPayementAndReceipt(-1,startDate, endDate,conn);
		list10=db.trialBalanceInstantLoan(startDate, endDate,-1,conn);
		list11=db.trialBalanceInstantBorrow(startDate, endDate,-1,conn);
		list12=db.trialBalanceAllIncome(startDate, endDate,-1,conn);
		listSaving=db.trialBalanceSavingAccountList(startDate, endDate,-1,conn);
		listInvest=db.dataFromTrialBalanceTable("Investment", "2016-2017",-1,conn);
		listAdvance=db.dataFromTrialBalanceTable("Advance", "2016-2017",-1,conn);
		list8=db.trialBalanceOtherExpense(-1,startDate, endDate,conn);
		list13=db.trialBalanceAllRemainingExpense(startDate, endDate,-1,conn);
		
		
		
		listMix=db.trialBalanceRemainingEntry(-1,startDate, endDate, rdInterest, fdInterest);
		
		list.addAll(listShareCapital);
		list.addAll(list1);
		list.addAll(list2);
		list.addAll(list3);
		list.addAll(listSaving);
		list.addAll(listInvest);
		list.addAll(list4);
		list.addAll(list5);
		list.addAll(list6);
		list.addAll(list7);
		list.addAll(list9);
		list.addAll(list14);
		list.addAll(list10);
		list.addAll(list11);
		list.addAll(list12);
		list.addAll(listMix);
		list.addAll(list8);
		list.addAll(list13);
		
		/*TrialInfo newList=new TrialInfo();
		for(int i=0;i<list.size();i++)
		{
			if(list.get(i).getBalanceCr()>0 || list.get(i).getBalanceDr()>0)
			{
				newList.setBalanceCr(i);
			}
		}*/
		
		/*ArrayList<TrialInfo> templist=new ArrayList<>();
		for(int i=0;i<list.size();i++)
		{
			if(list.get(i).getOpeningCr()>0 || list.get(i).getOpeningDr()>0 || list.get(i).getDebit()>0 || list.get(i).getCredit()>0)
			{
				templist.add(list.get(i));
			}
			
		}
		list=new ArrayList<>();
		list=templist;
		templist=new ArrayList<>();*/
		
		for(TrialInfo tt: list)
		{
			double amt=(tt.getOpeningDr()+tt.getDebit())-(tt.getOpeningCr()+tt.getCredit());
			if(amt>0)
			{
				tt.setBalanceDr(Math.abs(Double.parseDouble(dc.format((amt)))));
			}
			else
			{
				tt.setBalanceCr(Math.abs(Double.parseDouble(dc.format((amt)))));
			}
			
			// OPENING BALANCE DR/CR SET 24 MARCH 2022
			double openingAmt=tt.getOpeningDr()-tt.getOpeningCr();
			if(openingAmt>0)
			{
				tt.setOpeningDr(Math.abs(Double.parseDouble(dc.format((openingAmt)))));
				tt.setOpeningCr(0);
			}
			else
			{
				tt.setOpeningCr(Math.abs(Double.parseDouble(dc.format((openingAmt)))));
				tt.setOpeningDr(0);
			}
			
			tt.setDisLedgerBtn(true);
			
			if(tt.getCategory()==null)
			{
				
			}
			else
			{
				if(tt.getCategory().equalsIgnoreCase("DD") || tt.getCategory().equalsIgnoreCase("RD") || tt.getCategory().equalsIgnoreCase("FD") || 
						tt.getCategory().equalsIgnoreCase("Loan") || tt.getCategory().equalsIgnoreCase("Saving Accounts"))
				{
					tt.setDisLedgerBtn(false);
				}
			}
			
			
			
			totalDr+=tt.getDebit();
			totalCr+=tt.getCredit();
		}
		
		ArrayList<TrialInfo> templist=new ArrayList<>();
		String cat="";
		for(int i=0;i<list.size();i++)
		{
			if(Math.round(list.get(i).getBalanceCr())>0 || Math.round(list.get(i).getBalanceDr())>0 || list.get(i).getOpeningCr()>0 || list.get(i).getOpeningDr()>0 ||
					list.get(i).getDebit()>0 || list.get(i).getCredit()>0)
			{
				templist.add(list.get(i));
			}
		}
		list=new ArrayList<>();
		list=templist;
		templist=new ArrayList<>();
		
		for(int i=0; i<list.size();i++)
		{
			list.get(i).setDebit(Double.parseDouble(dc.format(list.get(i).getDebit())));
			list.get(i).setCredit(Double.parseDouble(dc.format(list.get(i).getCredit())));
			
			list.get(i).setOpeningDrStr(BigDecimal.valueOf(list.get(i).getOpeningDr()).toPlainString());
			list.get(i).setOpeningCrStr(BigDecimal.valueOf(list.get(i).getOpeningCr()).toPlainString());
			list.get(i).setDebitStr(BigDecimal.valueOf(list.get(i).getDebit()).toPlainString());
			list.get(i).setCreditStr(BigDecimal.valueOf(list.get(i).getCredit()).toPlainString());
			list.get(i).setBalanceDrStr(BigDecimal.valueOf(list.get(i).getBalanceDr()).toPlainString());
			list.get(i).setBalanceCrStr(BigDecimal.valueOf(list.get(i).getBalanceCr()).toPlainString());
			
			openingCr+=list.get(i).getOpeningCr();
			openingDr+=list.get(i).getOpeningDr();
			balanceCr+=list.get(i).getBalanceCr();
			balanceDr+=list.get(i).getBalanceDr();
		}
		
		// System.out.println("size list 6: "+list6.size());
		//// System.out.println("size list 7: "+list7.size());
		//// System.out.println("size: "+list.size());
		
		openingCr=Math.round(openingCr);
		openingDr=Math.round(openingDr);
		totalCr=Double.parseDouble(new DecimalFormat("##.####").format(totalCr));
		totalDr=Double.parseDouble(new DecimalFormat("##.####").format(totalDr));
		balanceDr=Double.parseDouble(new DecimalFormat("##.####").format(balanceDr));
		balanceCr=Double.parseDouble(new DecimalFormat("##.####").format(balanceCr));
		
		// System.out.println("Cr: "+balanceCr);
		// System.out.println("DR. "+balanceDr);
		
		totalCredit=BigDecimal.valueOf(totalCr).toPlainString();
		totalDebit=BigDecimal.valueOf(totalDr).toPlainString();
		openingCredit=BigDecimal.valueOf(openingCr).toPlainString();
		openingDebit=BigDecimal.valueOf(openingDr).toPlainString();
		balanceCredit=BigDecimal.valueOf(balanceCr).toPlainString();
		balanceDebit=BigDecimal.valueOf(balanceDr).toPlainString();
		//closingBalance=BigDecimal.valueOf(balance).toPlainString();
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void viewLedger()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		totalLedgerCredit=totalLedgerDebit=0;
		if(selectedRow.getCategory().equalsIgnoreCase("Loan"))
		{
			String arr[]=selectedRow.getParticular().split("/");
			ledgerDataList=new DataBaseReportMethods().loanPrincipalLedgerListByLoanNo(arr[0], startDate, endDate, selectedRow, arr[1], conn);
		}
		else if(selectedRow.getCategory().equalsIgnoreCase("Saving Accounts"))
		{
			String arr[]=selectedRow.getParticular().split("/");
			ledgerDataList=new DataBaseReportMethods().savingLedgerListBySavingAccNo(arr[0], startDate, endDate, selectedRow, arr[1], conn);
		}
		else
		{
			String arr[]=selectedRow.getParticular().split("/");
			//System.out.println(arr[0]);
			ledgerDataList=new DataBaseReportMethods().ddRdFdLedgerListByDepositNo(arr[0], startDate, endDate, selectedRow, arr[1], conn);
		}
		
		for(MembersOdInfo ll: ledgerDataList)
		{
			totalLedgerCredit+=ll.getCredit();
			totalLedgerDebit+=ll.getDebit();
		}
		
		MembersOdInfo cs= new MembersOdInfo();
		
		cs.setSno(ledgerDataList.size()+1);
		cs.setCreditDate(endDate);
		cs.setStrPayCreditDate(new SimpleDateFormat("dd-MM-yyyy").format(endDate));
		double amt=(totalLedgerDebit-totalLedgerCredit);
		if(amt>0)
		{
			cs.setDebit(Math.abs(Double.parseDouble(dc.format((amt)))));
		}
		else
		{
			cs.setCredit(Math.abs(Double.parseDouble(dc.format((amt)))));
		}
		
		cs.setDescription("Closing Balance");
		cs.setPayMode("");
		ledgerDataList.add(cs);
		
		
		Collections.sort(ledgerDataList);
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void printWhole()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("list", list);
		ss.setAttribute("openingCredit", openingCredit);
		ss.setAttribute("openingDebit", openingDebit);
		ss.setAttribute("totalDebit", totalDebit);
		ss.setAttribute("totalCredit", totalCredit);
		ss.setAttribute("balanceDebit", balanceDebit);
		ss.setAttribute("balanceCredit", balanceCredit);
		ss.setAttribute("startDate", startDate);
		ss.setAttribute("endDate", endDate);

		RequestContext.getCurrentInstance().execute("window.open('printTrialBalance.xhtml')");
	}
	
	
	
	public Date getEndDate() {
		return endDate;
	}
	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}
	public String getStrEndDate() {
		return strEndDate;
	}
	public void setStrEndDate(String strEndDate) {
		this.strEndDate = strEndDate;
	}





	public Date getStartDate() {
		return startDate;
	}





	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}





	public ArrayList<TrialInfo> getList() {
		return list;
	}





	public void setList(ArrayList<TrialInfo> list) {
		this.list = list;
	}



	public double getTotalDr() {
		return totalDr;
	}



	public void setTotalDr(double totalDr) {
		this.totalDr = totalDr;
	}



	public double getTotalCr() {
		return totalCr;
	}



	public void setTotalCr(double totalCr) {
		this.totalCr = totalCr;
	}



	public String getTotalDebit() {
		return totalDebit;
	}



	public void setTotalDebit(String totalDebit) {
		this.totalDebit = totalDebit;
	}



	public String getTotalCredit() {
		return totalCredit;
	}



	public void setTotalCredit(String totalCredit) {
		this.totalCredit = totalCredit;
	}



	public boolean isShow() {
		return show;
	}



	public void setShow(boolean show) {
		this.show = show;
	}



	


	public double getBalanceDr() {
		return balanceDr;
	}



	public void setBalanceDr(double balanceDr) {
		this.balanceDr = balanceDr;
	}



	public double getBalanceCr() {
		return balanceCr;
	}



	public void setBalanceCr(double balanceCr) {
		this.balanceCr = balanceCr;
	}



	public double getOpeningDr() {
		return openingDr;
	}



	public void setOpeningDr(double openingDr) {
		this.openingDr = openingDr;
	}



	public double getOpeningCr() {
		return openingCr;
	}



	public void setOpeningCr(double openingCr) {
		this.openingCr = openingCr;
	}



	public String getClosingBalance() {
		return closingBalance;
	}



	public void setClosingBalance(String closingBalance) {
		this.closingBalance = closingBalance;
	}



	public String getOpeningDebit() {
		return openingDebit;
	}



	public void setOpeningDebit(String openingDebit) {
		this.openingDebit = openingDebit;
	}



	public String getOpeningCredit() {
		return openingCredit;
	}



	public void setOpeningCredit(String openingCredit) {
		this.openingCredit = openingCredit;
	}



	public String getBalanceDebit() {
		return balanceDebit;
	}



	public void setBalanceDebit(String balanceDebit) {
		this.balanceDebit = balanceDebit;
	}



	public String getBalanceCredit() {
		return balanceCredit;
	}



	public void setBalanceCredit(String balanceCredit) {
		this.balanceCredit = balanceCredit;
	}



	public boolean isDisEndDate() {
		return disEndDate;
	}



	public void setDisEndDate(boolean disEndDate) {
		this.disEndDate = disEndDate;
	}



	public TrialInfo getSelectedRow() {
		return selectedRow;
	}



	public void setSelectedRow(TrialInfo selectedRow) {
		this.selectedRow = selectedRow;
	}



	public double getTotalLedgerDebit() {
		return totalLedgerDebit;
	}



	public void setTotalLedgerDebit(double totalLedgerDebit) {
		this.totalLedgerDebit = totalLedgerDebit;
	}



	public double getTotalLedgerCredit() {
		return totalLedgerCredit;
	}



	public void setTotalLedgerCredit(double totalLedgerCredit) {
		this.totalLedgerCredit = totalLedgerCredit;
	}



	public ArrayList<MembersOdInfo> getLedgerDataList() {
		return ledgerDataList;
	}



	public void setLedgerDataList(ArrayList<MembersOdInfo> ledgerDataList) {
		this.ledgerDataList = ledgerDataList;
	}



	
}
