package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.DecimalFormat;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

import report_package.DataBaseReportMethods;

@ManagedBean(name="evdSavingAccount")
@ViewScoped
public class EditViewDeleteSavingAccountBean implements Serializable 
{DataBaseMethods obj=new DataBaseMethods();
	private static final long serialVersionUID = 1L;
	String id,status, newDsaCode;
	ArrayList<UserInfo> list,multiSelectList;
	ArrayList<SelectItem> dsaList;
	UserInfo selectedUser;
	Timestamp dt1,dt2,dt3,dt4,dt5,dt6,dt7,dt8,dt9,dt10,dt11,dt12;
	static Timestamp dtm1;
	static Timestamp dtm2;
	static Timestamp dtj1;
	static Timestamp dtj2;
	static Timestamp dts1;
	static Timestamp dts2;
	static Timestamp dtd1;
	static Timestamp dtd2;
	
	public EditViewDeleteSavingAccountBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		dsaList=obj.allDsaList(branchId,"",conn);
		list=obj.allSavingAccountBean(branchId);
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	public void viewDetails()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedUser", selectedUser);
		ss.setAttribute("pageName","editViewDeleteSavingAccount.xhtml");
		
		RequestContext.getCurrentInstance().execute("window.open('viewSavingAccount.xhtml')");
	}
	
	public void updateDsa()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		if(multiSelectList.size()>0)
		{
			int count=0;
			Connection conn=DataBaseConnection.JAVAConnection();
			for(UserInfo uu: multiSelectList)
			{
				if(uu.getDsaCode()==null || !uu.getDsaCode().equals(newDsaCode))
				{
					count+=obj.updateDsaInLoanAccount(uu.getId(), newDsaCode, "savingaccount", conn);
				}
			}
			
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(count+" Account Has been Successfully Tranfer in the Code of "+newDsaCode));
			list=obj.allSavingAccountBean(branchId);
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Dear User, Please Select at least one Loan Account for Transfer"));
		}
	}
	
	public String close()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
			Date todayDate=new Date();
			Timestamp tdyDate=new Timestamp(todayDate.getTime());
			tdyDate.setMinutes(0);tdyDate.setHours(0);tdyDate.setSeconds(0);tdyDate.setNanos(0);
			// System.out.println("today : "+tdyDate);
			Date date1=new Date();Date date2=new Date();
			Date date3=new Date();Date date4=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(date4.getTime());dt6=new Timestamp(date4.getTime());
			dt7=new Timestamp(date4.getTime());dt8=new Timestamp(date4.getTime());
			dt1.setDate(31);
			dt1.setMonth(2);
			dt1.setYear(tdyDate.getYear());
			dt1.setHours(0);dt1.setMinutes(0);dt1.setSeconds(0);dt1.setNanos(0);
			
			dt5.setDate(29);
			dt5.setMonth(5);
			dt5.setYear(tdyDate.getYear());
			dt5.setHours(0);dt5.setMinutes(0);dt5.setSeconds(0);dt5.setNanos(0);
			
			
			dt2.setDate(30);
			dt2.setMonth(5);
			dt2.setYear(tdyDate.getYear());
			dt2.setHours(0);dt2.setMinutes(0);dt2.setSeconds(0);dt2.setNanos(0);
	
			dt6.setDate(29);
			dt6.setMonth(8);
			dt6.setYear(tdyDate.getYear());
			dt6.setHours(0);dt6.setMinutes(0);dt6.setSeconds(0);dt6.setNanos(0);
			
			dt3.setDate(30);
			dt3.setMonth(8);
			dt3.setYear(tdyDate.getYear());
			dt3.setHours(0);dt3.setMinutes(0);dt3.setSeconds(0);dt3.setNanos(0);
			
			dt7.setDate(30);
			dt7.setMonth(11);
			dt7.setYear(tdyDate.getYear());
			dt7.setHours(0);dt7.setMinutes(0);dt7.setSeconds(0);dt7.setNanos(0);
	
			dt4.setDate(31);
			dt4.setMonth(11);
			dt4.setYear(tdyDate.getYear());
			dt4.setHours(0);dt4.setMinutes(0);dt4.setSeconds(0);dt4.setNanos(0);
			
			dt8.setDate(30);
			dt8.setMonth(2);
			dt8.setYear(tdyDate.getYear());
			dt8.setHours(0);dt8.setMinutes(0);dt8.setSeconds(0);dt8.setNanos(0);
			
				Timestamp uDate=null;
				Date updateDate=selectedUser.getPayoutDate();
				if(updateDate!=null)
				{
					uDate=new Timestamp(updateDate.getTime());
				}
				if(!tdyDate.equals(uDate))
				{
					double amount=0;
					double interestAmount=0;
					double finalAmount=0;double finalTotal=0;double accBalance=0;
					ArrayList<SavingAccountInfo> depositAmount=new ArrayList<>(),withdrwalAmount=new ArrayList<>(),finalList=new ArrayList<>();
			   		withdrwalAmount=withdrwalValueBetweenDate(selectedUser.getAccountNo(), uDate,tdyDate);                  	
					depositAmount=depositValueBetweenDate(selectedUser.getAccountNo(),uDate,tdyDate);
					if(withdrwalAmount.size()>0 || depositAmount.size()>0)
					{
						
						SavingAccountInfo oo=new SavingAccountInfo();
						oo.setEntryDate(uDate);
						oo.setAccountNo(selectedUser.getAccountNo());
						oo.setStatus("deposit");
						oo.setFinalAmount(selectedUser.getPaidAmount());
						finalList.add(oo);
						
						finalList.addAll(depositAmount);
						finalList.addAll(withdrwalAmount);
						
						Collections.sort(finalList); 
						SavingAccountInfo ii=new SavingAccountInfo();
						ii.setEntryDate(tdyDate);
						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*selectedUser.getInterest())/36500;
									amount=amount+interestAmount;
									finalAmount+=interestAmount;
								}
								
							}
							
						}
						finalAmount=Double.parseDouble(new DecimalFormat("##.##").format(finalAmount));
						finalTotal=amount;
					}
					
					if(finalAmount>0)
					{
						obj.updateInterestAmountInCustomerDeposit(branchId,selectedUser.getAccountNo(),finalAmount,tdyDate,conn);
						accBalance=finalAmount+selectedUser.getAmount();
						accBalance=Double.parseDouble(new DecimalFormat("##.##").format(accBalance));
						obj.updatePaidAmountAndDateInSavingAccount(selectedUser.getAccountNo(),finalTotal,accBalance,tdyDate,conn);
					}
				}
			status="close";
			int i=obj.deleteSavingsAccount(selectedUser.getId(),status);
			if(i>=1)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Account Closed Successfully!"));
				return "editViewDeleteSavingAccount.xhtml"; 
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error occureed...please check"));
			}
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		
			return "";
	}
	
	
	public static ArrayList<SavingAccountInfo> depositValueBetweenDate(String accountNo, Timestamp date1, Timestamp date2) 
	{
		 ArrayList<SavingAccountInfo> list=new ArrayList<>(); 
		 try(Connection conn=DataBaseConnection.JAVAConnection();) 
         {
			 Statement stt=conn.createStatement();
			 String query="select *,sum(amount) as totalAmount from customer_deposit where type='deposit' and account_no='"+accountNo+"' and date between '"+date1+"' and '"+date2+"' group by date";
			 ResultSet ss=stt.executeQuery(query);
			 while(ss.next())
			 {
				SavingAccountInfo info=new SavingAccountInfo();
			    info.setAccountNo(ss.getString("account_no"));
			    info.setEntryDate(ss.getDate("date"));
			    info.setAmount(ss.getDouble("amount"));
			   	info.setFinalAmount(ss.getDouble("totalAmount"));
			    info.setStatus("deposit");
		        list.add(info);
			 }
         }
         catch (Exception e) 
         {
        	 e.printStackTrace();
         }
		 return list;
	}

	public static ArrayList<SavingAccountInfo> withdrwalValueBetweenDate(String accountNo, Timestamp date1, Timestamp date2) 
	{
		 ArrayList<SavingAccountInfo> list=new ArrayList<>(); 
		 
		 try(Connection conn=DataBaseConnection.JAVAConnection();) 
         {
			 Statement stt=conn.createStatement();
			 String query="select *,sum(amount) as totalAmount from customer_withdrwal where account_no='"+accountNo+"' and date between '"+date1+"' and '"+date2+"' group by date";
			 ResultSet ss=stt.executeQuery(query);
			 
			 while(ss.next())
			 {
				SavingAccountInfo info=new SavingAccountInfo();
			    info.setAccountNo(ss.getString("account_no"));
			    info.setEntryDate(ss.getDate("date"));
			    info.setAmount(ss.getDouble("amount"));
			    info.setFinalAmount(ss.getDouble("totalAmount"));
			    info.setStatus("withdrwal");
		        list.add(info);
			 }
         }
         catch (Exception e) 
         {
        	 e.printStackTrace();
         }
		 return list;
	}
	
	public static long getDifferenceDays(Date d1, Date d2) 
	{
		long diff = d2.getTime() - d1.getTime();
		/*// System.out.println("diff : "+diff);
		// System.out.println("diff : "+TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
		*/
		return (TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
	}
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public ArrayList<UserInfo> getList() {
		return list;
	}
	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}

	public String getNewDsaCode() {
		return newDsaCode;
	}

	public void setNewDsaCode(String newDsaCode) {
		this.newDsaCode = newDsaCode;
	}

	public ArrayList<UserInfo> getMultiSelectList() {
		return multiSelectList;
	}

	public void setMultiSelectList(ArrayList<UserInfo> multiSelectList) {
		this.multiSelectList = multiSelectList;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}
}
