package other_package;

import java.io.Serializable;
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 java.util.concurrent.TimeUnit;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import group_head_package.DataBaseIncomeExpense;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.HeaderBean;
import main_package.SavingAccountInfo;
import report_package.DataBaseReportMethods;

@ViewScoped
@ManagedBean(name="calculateBorrowInterest")
public class CalculateBorrowInterestBean implements Serializable
{
	ArrayList<SavingAccountInfo> dtList, intrList;
	SavingAccountInfo selectedRow;
	double interestRate=12;
	Date startDate=new Date(),endDate=new Date();
	DecimalFormat df=new DecimalFormat("##.##");
	DataBaseMethods db=new DataBaseMethods();
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	
	public CalculateBorrowInterestBean() throws ParseException 
	{
		createDateList();
	}
	
	 public void calculateInterest() throws ParseException
	 {
		 if(interestRate>0)
		 {
			 HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
			 int branchId = (int) ss.getAttribute("branchId");
			 
				Connection conn=DataBaseConnection.JAVAConnection();
				Date startDate=selectedRow.getStartDate();
				Date endDate=selectedRow.getEndDate();
				
				Timestamp dtm1=new Timestamp(startDate.getTime());
				Timestamp dtm2=new Timestamp(endDate.getTime());
				dtm1.setHours(0);dtm1.setMinutes(0);dtm1.setSeconds(0);dtm1.setNanos(0);
				dtm2.setHours(0);dtm2.setMinutes(0);dtm2.setSeconds(0);dtm2.setNanos(0);
				
				ArrayList<SavingAccountInfo> list=dbmr.allBorrowAccounts(branchId,interestRate,conn);
				double grandTotal=0;
				int count=1;
				intrList=new ArrayList<>();
				for(SavingAccountInfo aa: list)
				{
					double amount=0;
					double interestAmount=0;
					double finalAmount=0;
					
					ArrayList<SavingAccountInfo> depositAmount=new ArrayList<>(),withdrwalAmount=new ArrayList<>(),finalList=new ArrayList<>();
					withdrwalAmount=dbmr.borrowBetweenDate(branchId,aa.getAccountNo(), dtm1,dtm2,"debit",conn);                  	
					depositAmount=dbmr.borrowBetweenDate(branchId,aa.getAccountNo(),dtm1,dtm2,"credit",conn);
					
					SavingAccountInfo oo=new SavingAccountInfo();
					oo.setEntryDate(dtm1);
					oo.setAccountNo(aa.getAccountNo());
					oo.setStatus("deposit");
					oo.setFinalAmount(aa.getPaidAmount());
					finalList.add(oo);
				     
					
					
					finalList.addAll(depositAmount);
					finalList.addAll(withdrwalAmount);
					Collections.sort(finalList); 

					SavingAccountInfo ii=new SavingAccountInfo();
					ii.setEntryDate(dtm2);
					ii.setAccountNo(finalList.get(0).getAccountNo());
					ii.setStatus("deposit");
					ii.setFinalAmount(0);
					finalList.add(ii);
					
					
					for(int i=0;i<finalList.size();i++)
					{
						if(i!=0)
						{
							if(finalList.get(i-1).getStatus().equals("withdrwal"))
							{
								amount-=finalList.get(i-1).getFinalAmount();
							}
							else
							{
								amount+=finalList.get(i-1).getFinalAmount();
							}
							
							long day=getDifferenceDays(finalList.get(i-1).getEntryDate(), finalList.get(i).getEntryDate());
							for(long k=1;k<=day;k++)
							{
								interestAmount=(amount*1*aa.getInterest())/36500;
								/*if(intrType.equalsIgnoreCase("Daily Compound"))
								{
									amount=amount+interestAmount;
								}*/
								finalAmount+=interestAmount;
							}
							
							//System.out.println(i+"...."+day+"...."+finalList.get(i-1).getEntryDate()+"...."+finalList.get(i-1).getStatus()+"...."+amount+"...."+finalAmount);
						}
					}
					finalAmount=Double.parseDouble(df.format(finalAmount));
					
					//System.out.println(aa.getFirst_applicant_name()+"==="+finalAmount);
					
					SavingAccountInfo ff=new SavingAccountInfo();
					ff.setSno(count++);
					ff.setFirst_applicant_name(aa.getFirst_applicant_name());
					ff.setAmount(finalAmount);  //calculated interest amount 
					intrList.add(ff);
					
					
					if(finalAmount>0)
					{
						grandTotal+=finalAmount;
//						boolean flag=db.checkPromotorInterestCreditDate(branchId,selectedRow.getEndDate(), aa.getAccountNo(),conn);
//						if(flag==false)
//						{
//							submittedBankName="N/A";
//							String voucherNo=db.generateVoucherNo(branchId,"expense_table", conn);
//							int m=new DataBaseIncomeExpense().addExpense(branchId,selectedRow.getEndDate(), "Other_Dr", "Cash", String.valueOf(finalAmount), chequeNo, bankBranch, submittedBankName, dtm2,
//									description, "Promoter Interest", "0", voucherNo, 0, aa.getAccountNo(),"","");
//							
//							if(m>0)
//							{
//								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Rs. "+finalAmount+"/- Promotor Interest Of "+selectedRow.getBtnName()+" is Submit Sucessfully"));
//								
//								db.increaseSharedCompanyAmount(branchId,finalAmount,conn);   //
//								
//								int n=new DataBaseIncomeExpense().addPromotorCapital(branchId,selectedRow.getEndDate(),"Promoter Interest","Cash",finalAmount,chequeNo,bankBranch,bankName,chequeDate,description,
//										submittedBankName,  aa.getAccountNo(),"interest",conn); 
//								if(n>0)
//								{
//									Double newAmount=aa.getAmount()+finalAmount;
//									db.updatePromotorAmountByID(aa.getAccountNo(),newAmount);
//									db.increaseCompanyCapitalAmount(branchId,finalAmount,conn);
//								}
//								
//								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Rs. "+finalAmount+"/-  Promotor Interest is Deduct From Cash Sucessfully Due To Expense of the Company"));
//								createDateList();
//							}
//							else
//							{
//								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
//							}
//						}
//						else
//						{
//							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(selectedRow.getBtnName()+" Promotor Interest Amount Already Credited... Try Again???"));
//						}
					}
				}
				
				if(grandTotal==0)
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Zero Borrower of the Month "+selectedRow.getBtnName()));
				}
			
				 try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		 }
		 else
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("PLEASE ENTER VALID INTEREST RATE FOR CALCULATION..."));
		 }
		 
	 }
	 
	 public long getDifferenceDays(Date d1, Date d2) 
	{
		long diff = d2.getTime() - d1.getTime();
		return (TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
	}
	 
	 private void createDateList() throws ParseException 
	 {
		 dtList=new ArrayList<>();
		 HeaderBean hh=new HeaderBean();
		 int j=4;
		 String day,year;
		 Date currDate=new Date();
		 year=hh.getStartFinYear();
		Connection  conn=DataBaseConnection.JAVAConnection();	
		 for(int i=1;i<=12; i++)
		 {
			 SavingAccountInfo ss=new SavingAccountInfo();
			 
			  
			 ss.setSno(i);
			 
			String sDate="01-"+j+"-"+year;
			SimpleDateFormat f = new SimpleDateFormat("dd-MM-yyyy");
			SimpleDateFormat ff = new SimpleDateFormat("dd-MMM-yyyy");
			startDate=f.parse(sDate);
				
			ss.setStartDate(startDate);
			ss.setStrStartDate(ff.format(startDate));
			
			
			int days=db.daysInMonth(j, Integer.parseInt(year));
			day=String.valueOf(days);
			String eDate=day+"-"+j+"-"+year;
			endDate=f.parse(eDate);
			
			ss.setEndDate(endDate);
			ss.setStrEndDate(ff.format(endDate));
			ss.setMonthName(db.monthList(j));
			ss.setBtnName(db.monthList(j)+", "+year);
			
			
			//Date lastDate=db.lastPromotorInterestCreditDate(conn);
			if(currDate.after(endDate))
			{
				ss.setDisable(false);
			}
			else
			{
				ss.setDisable(true);
			}
			dtList.add(ss);
			 
			j++;
			
			if(j>12)
			{
				j=1;
				year=String.valueOf(Integer.parseInt(year)+1);
			}
		 }
		 try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	 }

	public ArrayList<SavingAccountInfo> getDtList() {
		return dtList;
	}

	public void setDtList(ArrayList<SavingAccountInfo> dtList) {
		this.dtList = dtList;
	}

	public SavingAccountInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(SavingAccountInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	public double getInterestRate() {
		return interestRate;
	}

	public void setInterestRate(double interestRate) {
		this.interestRate = interestRate;
	}

	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public ArrayList<SavingAccountInfo> getIntrList() {
		return intrList;
	}

	public void setIntrList(ArrayList<SavingAccountInfo> intrList) {
		this.intrList = intrList;
	}
	
	 
}
