package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
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 org.primefaces.context.RequestContext;

@ManagedBean(name="editGroupLoan")
@ViewScoped

public class EditGroupLoanBean implements Serializable
{DataBaseMethods obj=new DataBaseMethods();
	private static final long serialVersionUID = 1L;
	LoanInfo viewGrpLoan;
	String center,shareHolderNo,emiType,guarantor1,id,loanNo,fileCharge="0",oldFilecharge="0", insuranceFee="0", oldInsuranceFee="0",selectedScheme,rd_fdNo;
	UserInfo selectedUser,guarantorUser1,selectedMember,user_info;
	double loanAmount,interst,duration,emiPayment;
	int frequency,discount;
	ArrayList<UserInfo> userList=new ArrayList<>();
	boolean show,showFirst,ShowSecond,showField;
	Date requestDate;
	String[] idProof;
	ArrayList<SelectItem> centerList, loanCategoryList, repaymentFreqList;
	public static List<String> list;
	String appChqNo, appAccNo, appBankName, appBankBranch, g1ChqNo, g1AccNo, g1BankName, g1BankBranch, g2ChqNo, g2AccNo, g2BankName, g2BankBranch;
	ArrayList<SelectItem> dsaList;
	String dsaCode;
	DsaListInfo dsa_info;
	double commission=0, extraAmount;
	boolean loanStatus;
	String loanCategory, loanCycle, loanPurpose, repaymentFreq;
	
	public EditGroupLoanBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		dsaList=obj.allDsaList(branchId,"Loan",conn);
		loanCategoryList=obj.highMarkTableList("Loan Category", conn);
		repaymentFreqList=obj.highMarkTableList("Repayment Frequency", conn);
		
		viewGrpLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		id=viewGrpLoan.getId();
		if(viewGrpLoan.getLoanNo().contains("/"))
		{
			String temp[]=viewGrpLoan.getLoanNo().split(" / ");
			String lno=temp[1];
			loanNo=lno;
		}
		else
		{
			loanNo=viewGrpLoan.getLoanNo();
		}
		
		extraAmount=viewGrpLoan.getExtraAmt();
		dsaCode=viewGrpLoan.getDsacode();
		commission=viewGrpLoan.getCommission();
		shareHolderNo=viewGrpLoan.getShareHolderNo();
		idProof=viewGrpLoan.getIdProof().split(",");
		centerList=obj.allcenter(branchId,"all",conn);
		center=viewGrpLoan.getCenter();
		loanAmount=Double.parseDouble(viewGrpLoan.getLoanAmount());
		interst=Double.parseDouble(viewGrpLoan.getLoanInterest());
		duration=Double.parseDouble(viewGrpLoan.getLoanTerm());
		frequency=Integer.parseInt(viewGrpLoan.getFrequency());
		emiPayment=viewGrpLoan.getInstallAmount();
		emiType=viewGrpLoan.getEmiType();
		fileCharge=viewGrpLoan.getFileCharge();
		insuranceFee=viewGrpLoan.getInsuranceFee();
		oldInsuranceFee=insuranceFee;
		oldFilecharge=fileCharge;
		rd_fdNo=viewGrpLoan.getRd_fdNo();
		selectedScheme=obj.checkSchemeByUserNo(rd_fdNo);
		requestDate=viewGrpLoan.getRequestDate();
		discount=viewGrpLoan.getDiscount();
		
		appAccNo=viewGrpLoan.getAppAccNo();
		appBankBranch=viewGrpLoan.getAppBankBranch();
		appBankName=viewGrpLoan.getAppBankName();
		appChqNo=viewGrpLoan.getAppChqNo();
		
		g1AccNo=viewGrpLoan.getG1AccNo();
		g1BankBranch=viewGrpLoan.getG1BankBranch();
		g1BankName=viewGrpLoan.getG1BankName();
		g1ChqNo=viewGrpLoan.getG1ChqNo();
		
		g2AccNo=viewGrpLoan.getG2AccNo();
		g2BankBranch=viewGrpLoan.getG2BankBranch();
		g2BankName=viewGrpLoan.getG2BankName();
		g2ChqNo=viewGrpLoan.getG2ChqNo();
		
		loanCategory=viewGrpLoan.getLoanCategory();
		loanCycle=viewGrpLoan.getLoanCycle();
		loanPurpose=viewGrpLoan.getLoanPurpose();
		repaymentFreq=viewGrpLoan.getRepaymentFreq();
		
		if(selectedScheme!=null)
		{
			showField=true;
		}
		else
		{
			showField=false;
		}
		if(viewGrpLoan.getStatus().equals("pending"))
		{
			HeaderBean hh=new HeaderBean();
			loanStatus=hh.isDisableEntryDate();
		}
		else
		{
			loanStatus= true;
		}
		
		user_info=obj.userInfoByShareHolderNo(viewGrpLoan.getShareHolderNo(), conn);
		userList=obj.groupMemberInfo(viewGrpLoan.getMembers(), conn);
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void deleteMember()
	{
		int j=0;
		int i=0;
		for(UserInfo ls:userList)
        {
			if(ls.getShareHolderNo().equals(selectedMember.getShareHolderNo()))
       	  	{
       		  j=i;
       	  	}
       	  	i++;
        }
        if(j>=0)
        {
        	userList.remove(j);
        }
	}
	
	public void checkScheme()
	{
		if(!selectedScheme.equals(""))
		{
			showField=true;
		}
		else
		{
			showField=false;
		}
	}

	public List<String> complete_RD_FD_No(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().rd_FD_NoOfUser(branchId,name,selectedScheme,shareHolderNo);
     	return list;
	}

	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().shareHolderAllNo(branchId,name);
     	return list;
	}
	
	public void viewDetails()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		guarantorUser1=obj.userInfoByShareHolderNo(selectedMember.getShareHolderNo(), conn);
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("viewselecteduser", guarantorUser1);
			
	    RequestContext.getCurrentInstance().execute("window.open('viewCompleteDetails.xhtml')");
	}
	
	public void shareHolderDetails()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		selectedUser=obj.userInfoByShareHolderNo(shareHolderNo,conn);
		if(selectedUser!=null)
		{
			show=true;
	        loanNo=obj.groupLoanNo(branchId); 	
	        if(loanNo.equals(""))
	        {
                loanNo="1";	        	
	        }
	        requestDate=new Date(); 
	        centerList=obj.allcenter(branchId,"all",conn);
	        try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		else
		{
			show=false;
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Invalid Share Holder No"));
		}
	}
	public void calculateEMI()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		emiPayment=discount=0;
		if(emiType.equals("reducing"))
		{
			emiPayment=obj.calculateLoanEmi(loanAmount,duration, interst, frequency);  	
			if(loanAmount==0)
			{
				emiPayment=0;discount=0;
			}
			
			if(emiPayment>0)
			{
					double totalPayment=emiPayment*duration;
					double falseInterest=totalPayment-loanAmount;
					double trueInterest=obj.totalInterestForDiscount(loanAmount,duration,interst,frequency,emiPayment);
					trueInterest=Math.round(trueInterest);
					discount=(int) (falseInterest-trueInterest);
					discount=Math.round(discount);
			}
		}
		else
		{
			emiPayment=obj.calculateLoanEmiForCalculator(loanAmount,duration, interst, frequency, "both");  	
			if(loanAmount==0)
			{
				emiPayment=0;discount=0;
			}
			
			if(emiPayment>0)
			{
				double totalPayment=emiPayment*duration;
				double falseInterest=totalPayment-loanAmount;
				double trueInterest=(loanAmount*interst*duration)/(100*frequency);
				trueInterest=Math.round(trueInterest);
				discount=(int) (falseInterest-trueInterest);
				discount=Math.round(discount);	
				
				
			}
		}
		/*emiPayment=obj.calculateLoanEmi(loanAmount,duration, interst, frequency);  	
		if(loanAmount==0)
		{
			emiPayment=0;discount=0;
		}
		
		if(emiPayment>0)
		{
				double totalPayment=emiPayment*duration;
				double falseInterest=totalPayment-loanAmount;
				double trueInterest=obj.totalInterestForDiscount(loanAmount,duration,interst,frequency,emiPayment);
				trueInterest=Math.round(trueInterest);
				discount=(int) (falseInterest-trueInterest);
				discount=Math.round(discount);
		}*/
	}

	public void calculateCommission()
	{
		if(dsaCode !=null)
		{
		dsa_info=obj.dsaInfoByCode(dsaCode,"Loan");
		double loanAmt=loanAmount;
		String commType=dsa_info.getCommission_type();
		double commVal=dsa_info.getCommission_value();
		if(commType.equals("flat"))
		{
			commission=commVal;
		}
		else
		{
			commission=(loanAmt*commVal)/100;
			commission=Double.parseDouble(new DecimalFormat("##.##").format(commission));
		}
	}
	}
	
	public void firstGuantorDetails()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(shareHolderNo.equals(guarantor1))
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Team Leader Already Added In List"));
		}
		else
		{
			int i=obj.checkMemberInList(userList,guarantor1);
			if(i>0)
			{
				FacesContext fc=FacesContext.getCurrentInstance();
			 	fc.addMessage(null, new FacesMessage("Member Already Exist.."));
			}
			else
			{
				guarantorUser1=obj.userInfoByShareHolderNo(guarantor1, conn);
				if(guarantorUser1!=null)
				{
					userList.add(guarantorUser1);
				}
				else
				{
					FacesContext fc=FacesContext.getCurrentInstance();
				 	fc.addMessage(null, new FacesMessage("First Guarantor User Not Valid.."));
				}
			}
		}
		guarantor1="";
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
   public String editRequestLoan()
   {
	   HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
	   calculateEMI();
	   double capital=obj.totalCompanyCapitalAmount(branchId);
	   int limit=obj.checkGroupLoanLimit();
	   if(userList.size()<limit)
	   {
		   FacesContext fc=FacesContext.getCurrentInstance();
		   fc.addMessage(null, new FacesMessage("Minimum "+limit+" Member In Group Inculding Team Leader "));
		   return "";
	   }
	   else
	   {
		   if(fileCharge.trim().equals(""))
		   {
			   fileCharge="0";
		   }
		   if(insuranceFee.trim().equals(""))
		   {
			   insuranceFee="0";
		   }
		   int i=obj.UpdateGroupLoanRequest(id,idProof,fileCharge,loanAmount,interst,duration,frequency,emiPayment,requestDate,userList,center,rd_fdNo,discount, 
				   appChqNo, appAccNo, appBankName, appBankBranch, g1ChqNo, g1AccNo, g1BankName, g1BankBranch, g2ChqNo, g2AccNo, g2BankName, g2BankBranch,dsaCode,
				   commission, insuranceFee,emiType, extraAmount, loanCategory, loanCycle, loanPurpose, repaymentFreq);
	       if(i>=1)
	       {
	    	   Connection conn=DataBaseConnection.JAVAConnection();
	    		capital=obj.totalCompanyCapitalAmount(branchId);
	    	   if(Double.valueOf(fileCharge)!=Double.valueOf(oldFilecharge))
		    	{
	    		   String entryStatus=obj.findFileChargeAndInsFeeEntryStatus(loanNo,"File Charge", conn);
	    		   if(entryStatus.equalsIgnoreCase("active"))
	    		   {
	    			   obj.updateCompanyCapital(branchId,fileCharge,oldFilecharge,capital);
	    		   }
		    		
		    		obj.updateFileChargeAndInsuranceFeeInIncomeTable(loanNo,fileCharge,"File Charge", conn);
			    }
	    		capital=obj.totalCompanyCapitalAmount(branchId);
	    	 	if(Double.valueOf(insuranceFee)!=Double.valueOf(oldInsuranceFee))
		    	{
	    	 		 String entryStatus=obj.findFileChargeAndInsFeeEntryStatus(loanNo,"Insurance Fee", conn);
	    		   if(entryStatus.equalsIgnoreCase("active"))
	    		   {
	    				obj.updateCompanyCapital(branchId,insuranceFee,oldInsuranceFee,capital);
	    		   }
		    		obj.updateFileChargeAndInsuranceFeeInIncomeTable(loanNo,insuranceFee,"Insurance Fee", conn);
			    }
	    	 	FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Loan Request Updated Succesfully"));
				
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				
				return "editViewGroupLoan";
	       }
	        else
	        {
	        	FacesContext fc=FacesContext.getCurrentInstance();
	        	fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
	        	return "";
	        }
	   }
	}
   
	public String getCenter() {
		return center;
	}
	public void setCenter(String center) {
		this.center = center;
	}
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	public String getGuarantor1() {
		return guarantor1;
	}
	public void setGuarantor1(String guarantor1) {
		this.guarantor1 = guarantor1;
	}
	public String getLoanNo() {
		return loanNo;
	}
	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}
	public String getFileCharge() {
		return fileCharge;
	}
	public void setFileCharge(String fileCharge) {
		this.fileCharge = fileCharge;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	public UserInfo getGuarantorUser1() {
		return guarantorUser1;
	}
	public void setGuarantorUser1(UserInfo guarantorUser1) {
		this.guarantorUser1 = guarantorUser1;
	}
	public double getLoanAmount() {
		return loanAmount;
	}
	public void setLoanAmount(double loanAmount) {
		this.loanAmount = loanAmount;
	}
	public double getInterst() {
		return interst;
	}
	public void setInterst(double interst) {
		this.interst = interst;
	}
	public double getDuration() {
		return duration;
	}
	public void setDuration(double duration) {
		this.duration = duration;
	}
	
	public int getFrequency() {
		return frequency;
	}

	public LoanInfo getViewGrpLoan() {
		return viewGrpLoan;
	}

	public void setViewGrpLoan(LoanInfo viewGrpLoan) {
		this.viewGrpLoan = viewGrpLoan;
	}
	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getSelectedScheme() {
		return selectedScheme;
	}

	public void setSelectedScheme(String selectedScheme) {
		this.selectedScheme = selectedScheme;
	}

	public String getRd_fdNo() {
		return rd_fdNo;
	}

	public void setRd_fdNo(String rd_fdNo) {
		this.rd_fdNo = rd_fdNo;
	}
	public boolean isShowField() {
		return showField;
	}

	public void setShowField(boolean showField) {
		this.showField = showField;
	}
	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public void setFrequency(int frequency) {
		this.frequency = frequency;
	}
	public ArrayList<UserInfo> getUserList() {
		return userList;
	}
	public void setUserList(ArrayList<UserInfo> userList) {
		this.userList = userList;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}
	public boolean isShowFirst() {
		return showFirst;
	}
	public void setShowFirst(boolean showFirst) {
		this.showFirst = showFirst;
	}
	public boolean isShowSecond() {
		return ShowSecond;
	}
	public void setShowSecond(boolean showSecond) {
		ShowSecond = showSecond;
	}
	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}
	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}
	public static List<String> getList() {
		return list;
	}
	public static void setList(List<String> list) {
		GroupLoanBean.list = list;
	}
	public UserInfo getSelectedMember() {
		return selectedMember;
	}
	public void setSelectedMember(UserInfo selectedMember) {
		this.selectedMember = selectedMember;
	}
	public Date getRequestDate() {
		return requestDate;
	}
	public void setRequestDate(Date requestDate) {
		this.requestDate = requestDate;
	}
	public String[] getIdProof() {
		return idProof;
	}
	public void setIdProof(String[] idProof) {
		this.idProof = idProof;
	}
	public double getEmiPayment() {
		return emiPayment;
	}
	public void setEmiPayment(double emiPayment) {
		this.emiPayment = emiPayment;
	}

	public int getDiscount() {
		return discount;
	}

	public void setDiscount(int discount) {
		this.discount = discount;
	}

	public String getOldFilecharge() {
		return oldFilecharge;
	}

	public void setOldFilecharge(String oldFilecharge) {
		this.oldFilecharge = oldFilecharge;
	}

	public String getAppChqNo() {
		return appChqNo;
	}

	public void setAppChqNo(String appChqNo) {
		this.appChqNo = appChqNo;
	}

	public String getAppAccNo() {
		return appAccNo;
	}

	public void setAppAccNo(String appAccNo) {
		this.appAccNo = appAccNo;
	}

	public String getAppBankName() {
		return appBankName;
	}

	public void setAppBankName(String appBankName) {
		this.appBankName = appBankName;
	}

	public String getAppBankBranch() {
		return appBankBranch;
	}

	public void setAppBankBranch(String appBankBranch) {
		this.appBankBranch = appBankBranch;
	}

	public String getG1ChqNo() {
		return g1ChqNo;
	}

	public void setG1ChqNo(String g1ChqNo) {
		this.g1ChqNo = g1ChqNo;
	}

	public String getG1AccNo() {
		return g1AccNo;
	}

	public void setG1AccNo(String g1AccNo) {
		this.g1AccNo = g1AccNo;
	}

	public String getG1BankName() {
		return g1BankName;
	}

	public void setG1BankName(String g1BankName) {
		this.g1BankName = g1BankName;
	}

	public String getG1BankBranch() {
		return g1BankBranch;
	}

	public void setG1BankBranch(String g1BankBranch) {
		this.g1BankBranch = g1BankBranch;
	}

	public String getG2ChqNo() {
		return g2ChqNo;
	}

	public void setG2ChqNo(String g2ChqNo) {
		this.g2ChqNo = g2ChqNo;
	}

	public String getG2AccNo() {
		return g2AccNo;
	}

	public void setG2AccNo(String g2AccNo) {
		this.g2AccNo = g2AccNo;
	}

	public String getG2BankName() {
		return g2BankName;
	}

	public void setG2BankName(String g2BankName) {
		this.g2BankName = g2BankName;
	}

	public String getG2BankBranch() {
		return g2BankBranch;
	}

	public void setG2BankBranch(String g2BankBranch) {
		this.g2BankBranch = g2BankBranch;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public double getCommission() {
		return commission;
	}

	public void setCommission(double commission) {
		this.commission = commission;
	}

	public String getInsuranceFee() {
		return insuranceFee;
	}

	public void setInsuranceFee(String insuranceFee) {
		this.insuranceFee = insuranceFee;
	}

	public String getEmiType() {
		return emiType;
	}

	public boolean isLoanStatus() {
		return loanStatus;
	}

	public void setLoanStatus(boolean loanStatus) {
		this.loanStatus = loanStatus;
	}

	public void setEmiType(String emiType) {
		this.emiType = emiType;
	}

	public double getExtraAmount() {
		return extraAmount;
	}

	public void setExtraAmount(double extraAmount) {
		this.extraAmount = extraAmount;
	}

	public String getOldInsuranceFee() {
		return oldInsuranceFee;
	}

	public void setOldInsuranceFee(String oldInsuranceFee) {
		this.oldInsuranceFee = oldInsuranceFee;
	}

	public ArrayList<SelectItem> getLoanCategoryList() {
		return loanCategoryList;
	}

	public void setLoanCategoryList(ArrayList<SelectItem> loanCategoryList) {
		this.loanCategoryList = loanCategoryList;
	}

	public ArrayList<SelectItem> getRepaymentFreqList() {
		return repaymentFreqList;
	}

	public void setRepaymentFreqList(ArrayList<SelectItem> repaymentFreqList) {
		this.repaymentFreqList = repaymentFreqList;
	}

	public DsaListInfo getDsa_info() {
		return dsa_info;
	}

	public void setDsa_info(DsaListInfo dsa_info) {
		this.dsa_info = dsa_info;
	}

	public String getLoanCategory() {
		return loanCategory;
	}

	public void setLoanCategory(String loanCategory) {
		this.loanCategory = loanCategory;
	}

	public String getLoanCycle() {
		return loanCycle;
	}

	public void setLoanCycle(String loanCycle) {
		this.loanCycle = loanCycle;
	}

	public String getLoanPurpose() {
		return loanPurpose;
	}

	public void setLoanPurpose(String loanPurpose) {
		this.loanPurpose = loanPurpose;
	}

	public String getRepaymentFreq() {
		return repaymentFreq;
	}

	public void setRepaymentFreq(String repaymentFreq) {
		this.repaymentFreq = repaymentFreq;
	}
	
	
}
