package main_package;


import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;

import org.json.simple.JSONObject;

import group_head_package.DataBaseIncomeExpense;
import group_head_package.IncomeList;
import report_package.DailyInfo;
import report_package.DataBaseReportMethods;


@ManagedBean(name = "Dact")
@ViewScoped

public class DailyActivityBean implements Serializable {

	private static final long serialVersionUID = 1L;
	
	private Date valueDate = new Date();
	int totalPl,totalemi, totalGl, totalSl, totalDd, totalRd, grandTotal, branchId , totalExpense , totalIncome , salaryExpense , officeExpense , utilitesExpense , miscExpense;
	boolean checkDl=false;
	
	int totalPaidDemandEmi = 0;
	int totalUnpaidDemandEmi = 0;
	double totalPaidDemandAmount = 0;
	double totalUnpaidDemandAmount = 0;

	private int totalLoan=0,todayLoanDis=0,totalEmiRec=0;
	private double totalEmiAmountCollect;
	
	  DataBaseIncomeExpense dbe=new DataBaseIncomeExpense();
	  ArrayList<DailyInfo> list;
	  ArrayList<IncomeList>iList;
	  ArrayList<IncomeList>inList;
   	 //total loan add 
	 //Total disburshment
	 //total collection
	 //total amount disburshment
	 //total expense amount
	 //total bank amount
	 //total cash amount
	
	
	public DailyActivityBean() {
		
		branchId=4;
		
		totalLoanAdd();
		totalLoanDis();

		todayReceiveEmi();
	   // totalUpcomingEmi();	
		  searchReport();
		  
		  totalExpense();
		  totalIncome();
		
	}   
	
	
	public void executeData() {
		
		System.out.println("trigger");
		totalLoanAdd();
		totalLoanDis();

		todayReceiveEmi();
	   // totalUpcomingEmi();	
       searchReport();
		
       totalExpense();
       totalIncome();
       
	}
	
	
	
	public void totalIncome() {
	    
		totalIncome = 0 ;
		
		inList = new ArrayList<>();
	  
		Connection conn = DataBaseConnection.JAVAConnection();
	 
		inList=new DataBaseIncomeExpense().allIncomeList(branchId,valueDate,valueDate,conn);

		if(inList.size()>0) {
			
			for(IncomeList ii : inList) {
				 
				totalIncome += ii.getAmount();
				
			}
			
		}
		
   }
	
	
	public void totalExpense() {
		
		totalExpense = 0;
		salaryExpense=0;
		officeExpense=0;
		miscExpense=0;
	     
		iList = new ArrayList<>();
	  
		Connection conn = DataBaseConnection.JAVAConnection();
	 
		iList=dbe.allExpenseAndAssetsList(branchId,valueDate,valueDate, "Other_Dr","all",conn);

		if(iList.size()>0) {
			
			for(IncomeList ii : iList) {
				
				totalExpense += ii.getAmount();
				if(ii.getItem_name().equalsIgnoreCase("Salary Expenses")) {
					
					salaryExpense +=ii.getAmount();
					System.out.println("salaryExpense : -> "+salaryExpense);
				}
				
				if(ii.getItem_name().equalsIgnoreCase("Office Exp")) {
					
					officeExpense += ii.getAmount();
					
				}
				                                                               
				if (    
						
						ii.getItem_name().equalsIgnoreCase("Water Expenses") ||
						ii.getItem_name().equalsIgnoreCase("Conveyance Expenses") ||
						ii.getItem_name().equalsIgnoreCase("Fuel Expenses") ||
						ii.getItem_name().equalsIgnoreCase("Tour and Travel Expenses")) {
					    
					    utilitesExpense +=ii.getAmount();
					    
					} 
						
						miscExpense = totalExpense - salaryExpense - officeExpense - utilitesExpense ;
				
			}
			
		}
	  
}
	
	
	
//	public void  searchReport()
//	{   
//		list =new ArrayList<>();
//		
//		System.out.println("Demand");
//		list=new DataBaseReportMethods().dailyDemandMethod(branchId,valueDate,"all", checkDl);
//		
//		System.out.println(branchId+" : "+valueDate+" : "+checkDl);
//		
//		System.out.println("size :"+list.size());
//		if(list.size()>0)
//		{     totalemi = list.size();
//			totalPl=totalGl=totalSl=totalDd=totalRd=grandTotal=0;
//			for(DailyInfo dd: list)
//			{
//				totalPl+=dd.getTotalPl();
//				totalGl+=dd.getTotalGl();
//				totalSl+=dd.getTotalSl();
//				totalDd+=dd.getTotalDd();
//				totalRd+=dd.getTotalRd();
//			    grandTotal+=dd.getTotal();
//			  
//			}
//			
//	      
//		}
//	}
   
	
	
	
	public void searchReport() {

	    list = new ArrayList<>();

	    list = new DataBaseReportMethods().dailyDemandMethod(
	            branchId, valueDate, "all", checkDl);

	    totalemi = 0;
	    totalPl = totalGl = totalSl = totalDd = totalRd = grandTotal = 0;

	    totalPaidDemandEmi = 0;
	    totalUnpaidDemandEmi = 0;

	    totalPaidDemandAmount = 0;
	    totalUnpaidDemandAmount = 0;

	    if (list.size() > 0) {

	        totalemi = list.size();

	        try (Connection conn = DataBaseConnection.JAVAConnection()) {

	            for (DailyInfo dd : list) {

	                totalPl += dd.getTotalPl();
	                totalGl += dd.getTotalGl();
	                totalSl += dd.getTotalSl();
	                totalDd += dd.getTotalDd();
	                totalRd += dd.getTotalRd();
	                grandTotal += dd.getTotal();

	                countStatus(dd.getPlDetail(), valueDate, conn);
	                countStatus(dd.getGlDetail(), valueDate, conn);
	                countStatus(dd.getSlDetail(), valueDate, conn);
	                countStatus(dd.getDdDetail(), valueDate, conn);
	                countStatus(dd.getRdDetail(), valueDate, conn);
	            }

	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	    }
	}
	
   

	  

	private void countStatus(String detail, Date searchDate, Connection conn) {

	    if (detail == null || detail.trim().isEmpty()) {
	        return;
	    }

	    DataBaseMethodsRavi dbr = new DataBaseMethodsRavi();

	    for (String item : detail.split(",")) {

	        String[] data = item.trim().split("=");

	        if (data.length < 2) {
	            continue;
	        }

	        String loanNo = data[0].trim();
	        double emiAmount = Double.parseDouble(data[1].trim());

	        JSONObject paymentData =
	                dbr.checkLoanPaymentSource(loanNo, searchDate, conn);

	        String source = String.valueOf(paymentData.get("source"));

	        String status = "unpaid";

	        if (source.equalsIgnoreCase("Paid by App")) {

	            status = dbr.checkAppLoanPaymentStatus(loanNo, conn);

	        } else if (source.equalsIgnoreCase("Paid by Web")) {

	            status = dbr.checkWebLoanPaymentStatus(loanNo, conn);
	        }

	        if (status.equalsIgnoreCase("paid")) {

	            totalPaidDemandEmi++;
	            totalPaidDemandAmount += emiAmount;

	        } else {

	            totalUnpaidDemandEmi++;
	            totalUnpaidDemandAmount += emiAmount;
	        }
	    }
	}
	
	
	
	public void todayReceiveEmi() {
	    double totalAmount = 0.0;
	    int totalEmi = 0;

	    String query = "SELECT amount FROM loanpayment " +
	                   "WHERE pay_date = ? " +
	                   "AND receipt_status = 'approved' " +
	                   "AND chequeStatus = 'cleared' AND branch_id =? ";

	    try (Connection conn = DataBaseConnection.JAVAConnection();
	         PreparedStatement ps = conn.prepareStatement(query)) {

	        ps.setDate(1, new java.sql.Date(valueDate.getTime()));
	        ps.setInt(2, branchId);

	        try (ResultSet rs = ps.executeQuery()) {
	            while (rs.next()) {
	                totalAmount += rs.getDouble("amount");
	                totalEmi++;
	            }
	        }

	        totalEmiAmountCollect = totalAmount;
	        totalEmiRec = totalEmi;

	    } catch (Exception e) {
	        e.printStackTrace();
	    }
	}

	
	
	public void totalLoanDis() {
		  int g =0 ;
		  try(Connection conn = DataBaseConnection.JAVAConnection()){
			  
			  String query = "SELECT date from debit_loan where date = ? and branch_id = ?"; 
					  

			  try(PreparedStatement ps = conn.prepareStatement(query)){
				  
				  ps.setDate(1, new java.sql.Date(valueDate.getTime()));
				   ps.setInt(2, branchId);
				  
				  ResultSet rs = ps.executeQuery();
				  
				  while(rs.next()) {
					  
					 g++; 
					  
				  }
				  
				  todayLoanDis = g;
				  
			  }catch(Exception e) {
				  
				  e.printStackTrace();
				  
			  }
			  
		  }catch(Exception e) {
			  
			  e.printStackTrace();
			  
		  }
		  
		  
	}
	
  public void totalLoanAdd() {
	  
	  int i = 0;
	  
	  Timestamp tt = new Timestamp(valueDate.getTime());	
	  
	  try(Connection conn = DataBaseConnection.JAVAConnection()){
		  
		  String query = " SELECT requestDate from personalloan where requestDate = ? and branch_id=? "; 
				  

		  try(PreparedStatement ps = conn.prepareStatement(query)){
			  
			  ps.setDate(1, new java.sql.Date(valueDate.getTime()));
			   ps.setInt(2, branchId);
			  
			  System.out.println(query);
			  ResultSet rs = ps.executeQuery();
			  
			  while(rs.next()) {
				  
		     	i++;
				System.out.println(i);  
				  
			  }
			  
			  totalLoan=i;
			  
		  }catch(Exception e) {
			  
			  e.printStackTrace();
			  
		  }
		  
	  }catch(Exception e) {
		  
		  e.printStackTrace();
		  
	  }
	  
	  
  }
  
  
  
  

public Date getValueDate() {
	return valueDate;
}

public void setValueDate(Date valueDate) {
	this.valueDate = valueDate;
}

public int getTotalLoan() {
	return totalLoan;
}

public void setTotalLoan(int totalLoan) {
	this.totalLoan = totalLoan;
}



public int getTodayLoanDis() {
	return todayLoanDis;
}

public void setTodayLoanDis(int todayLoanDis) {
	this.todayLoanDis = todayLoanDis;
}


public int getTotalEmiRec(){
	return totalEmiRec;
	
}


public void setTotalEmiRec(int totalEmiRec) {
	this.totalEmiRec = totalEmiRec;
}


public double getTotalEmiAmountCollect() {
	return totalEmiAmountCollect;
}


public void setTotalEmiAmountCollect(double totalEmiAmountCollect) {
	this.totalEmiAmountCollect = totalEmiAmountCollect;
}

public int getTotalPl() {
	return totalPl;
}

public void setTotalPl(int totalPl) {
	this.totalPl = totalPl;
}

public int getTotalGl() {
	return totalGl;
}

public void setTotalGl(int totalGl) {
	this.totalGl = totalGl;
}

public int getTotalSl() {
	return totalSl;
}

public void setTotalSl(int totalSl) {
	this.totalSl = totalSl;
}

public int getTotalDd() {
	return totalDd;
}

public void setTotalDd(int totalDd) {
	this.totalDd = totalDd;
}

public int getTotalRd() {
	return totalRd;
}

public void setTotalRd(int totalRd) {
	this.totalRd = totalRd;
}

public int getGrandTotal() {
	return grandTotal;
}

public void setGrandTotal(int grandTotal) {
	this.grandTotal = grandTotal;
}

public int getBranchId() {
	return branchId;
}

public void setBranchId(int branchId) {
	this.branchId = branchId;
}

public ArrayList<DailyInfo> getList() {
	return list;
}

public void setList(ArrayList<DailyInfo> list) {
	this.list = list;
}

public boolean isCheckDl() {
	return checkDl;
}

public void setCheckDl(boolean checkDl) {
	this.checkDl = checkDl;
}


public int getTotalemi() {
	return totalemi;
}


public void setTotalemi(int totalemi) {
	this.totalemi = totalemi;
}


public int getTotalExpense() {
	return totalExpense;
}


public void setTotalExpense(int totalExpense) {
	this.totalExpense = totalExpense;
}


public int getTotalIncome() {
	return totalIncome;
}


public void setTotalIncome(int totalIncome) {
	this.totalIncome = totalIncome;
}


public int getSalaryExpense() {
	return salaryExpense;
}


public void setSalaryExpense(int salaryExpense) {
	this.salaryExpense = salaryExpense;
}


public int getOfficeExpense() {
	return officeExpense;
}


public void setOfficeExpense(int officeExpense) {
	this.officeExpense = officeExpense;
}


public int getUtilitesExpense() {
	return utilitesExpense;
}


public void setUtilitesExpense(int utilitesExpense) {
	this.utilitesExpense = utilitesExpense;
}


public int getMiscExpense() {
	return miscExpense;
}


public void setMiscExpense(int miscExpense) {
	this.miscExpense = miscExpense;
}


public int getTotalPaidDemandEmi() {
	return totalPaidDemandEmi;
}


public void setTotalPaidDemandEmi(int totalPaidDemandEmi) {
	this.totalPaidDemandEmi = totalPaidDemandEmi;
}


public int getTotalUnpaidDemandEmi() {
	return totalUnpaidDemandEmi;
}


public void setTotalUnpaidDemandEmi(int totalUnpaidDemandEmi) {
	this.totalUnpaidDemandEmi = totalUnpaidDemandEmi;
}


public double getTotalPaidDemandAmount() {
	return totalPaidDemandAmount;
}


public void setTotalPaidDemandAmount(double totalPaidDemandAmount) {
	this.totalPaidDemandAmount = totalPaidDemandAmount;
}


public double getTotalUnpaidDemandAmount() {
	return totalUnpaidDemandAmount;
}


public void setTotalUnpaidDemandAmount(double totalUnpaidDemandAmount) {
	this.totalUnpaidDemandAmount = totalUnpaidDemandAmount;
}

  

}





//public void totalLoanAdd() {
//	  
//	  try(Connection conn = DataBaseConnection.JAVAConnection()){
//		  
//		  String query = " "; 
//				  
//
//		  try(PreparedStatement ps = conn.prepareStatement(query)){
//			  
//		  }catch(Exception e) {
//			  
//			  e.printStackTrace();
//			  
//		  }
//		  
//	  }catch(Exception e) {
//		  
//		  e.printStackTrace();
//		  
//	  }
//	  
//	  
//}
