package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
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;

import other_package.DataBaseMethodsOther;
import other_package.ReportInfo;

@ManagedBean(name = "userDeposit")
@ViewScoped
public class UserDepositBean implements Serializable 
{
	private static final long serialVersionUID = 1L;
	UserInfo user_info,selectedUser;
	String accno, chequeNo, amount, bankName,submittedBankName,transfer="No", paymentMode, app_firstName,app_middleName, app_lastName, gender,mob,addrs,label,pageName;
	boolean value,showDetail,showTransfer,showTransferSelect;
	List<String> list;
	ArrayList<SelectItem> bankList;
	Date chequeDate, currentDate=new Date();
	double totalDebit,totalCredit,closingBalance,opBalance;
	ArrayList<ReportInfo> rlist;
	Date startDate=new Date(),endDate=new Date();
	DataBaseMethods obj=new DataBaseMethods();
	DecimalFormat dc=new DecimalFormat("##.##");
	int branchId;
	String remark;
	
	public UserDepositBean()
	{
		startDate.setDate(1);
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		pageName=(String) ss.getAttribute("pageName");
		System.out.println("page name : "+pageName);
		if(pageName!=null && pageName.equals("particularSaveAccount"))
		{
			accno=((UserInfo) ss.getAttribute("selectedUser")).getAccountNo();
			userInfo();
			ss.removeAttribute("selectedUser");
		}
		else
		{
			pageName="cashInOutFlow";
		}
		Connection  conn=DataBaseConnection.JAVAConnection();
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().userAccountNoForSavingAccount(branchId,name, obj.userId());
     	return list;
	}
	
	public void userInfo() 
	{
		//obj.calculateSavingAmountDetails(accno);
		
		Connection conn=DataBaseConnection.JAVAConnection();
		if(accno.contains("/"))
		{
			accno=accno.substring(0,accno.indexOf("/"));
		}
		String shareHolderNo = obj.shareHolderNoBySavingAccountNO(accno);
		
		if (shareHolderNo!= "")
		{
			user_info=obj.userInfoByShareHolderNo(shareHolderNo, conn);
			selectedUser=new DataBaseMethodsOther().particularSavingAccountBean(shareHolderNo);
			rlist=new DataBaseMethodsOther().savingAccountReport(selectedUser.getAccountNo(),startDate,endDate);
			opBalance=new DataBaseMethodsOther().openingBalance(selectedUser.getAccountNo(),startDate);
			Collections.sort(rlist);
			calculate();

			value = true;
		}	
		else
		{
			value = false;
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Account No. Does Not Exists"));
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void printMiniStatement()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedUser", selectedUser);
		ss.setAttribute("svStartDate", startDate);
		ss.setAttribute("svEndDate", endDate);
		
		RequestContext.getCurrentInstance().execute("window.open('printParticularSavingAccountReport.xhtml')");
	}
	
	public void checkTransferMode()
	{
		if(transfer.equals("Yes"))
		{
			showTransfer=true;
		}
		else
		{
			showTransfer=false;
		}
	}
	
	public void forPaymentMode()
	{
		
		if(paymentMode.equalsIgnoreCase("cash"))
		{
			showDetail = false;
			showTransfer=false;
			showTransferSelect=true;
			bankName=chequeNo="";
			chequeDate=null;
		}
		else
		{
			label=paymentMode;
			showDetail=true;
			showTransferSelect=false;
			showTransfer=true;
			bankName=chequeNo="";
			chequeDate=null;
			if(paymentMode.equalsIgnoreCase("NACH"))
			{
				Connection conn=DataBaseConnection.JAVAConnection();
				chequeNo=obj.nachDetailByColumnNameAndShareHolderNo("umrn_no", user_info.getShareHolderNo(), conn);
				bankName=obj.nachDetailByColumnNameAndShareHolderNo("bank_name", user_info.getShareHolderNo(), conn);
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}
	
	public String backButton()
	{
		return pageName;
	}
	
	public String Transaction() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
		{
			submittedBankName="N/A";
		}
		
		Timestamp openDate=new Timestamp(obj.checkAccountOpeningDate(accno).getTime());
		Timestamp curr=new Timestamp(currentDate.getTime());
		curr.setHours(0);curr.setMinutes(0);curr.setSeconds(0);curr.setNanos(0);
		
		if(openDate.after(curr))
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Date can't be before account opening date. Account Opening Date is : "+String.valueOf(openDate).substring(0, 10)));
			return "";
		}
		
		
		boolean status=obj.depositPayStatus(accno);
		if(status==true)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Approve Your Previous Transaction To Make Further Transaction"));
		}
		else
		{
			String app_status="pending",message="Payment Done SuccessFully... Please Approve Your Payment";
			if(paymentMode.equalsIgnoreCase("Cash"))
			{
				app_status="approved";
				message="Payment Done SuccessFully.";
			}
			int	n = obj.userDeposit(branchId,accno, amount, currentDate,paymentMode, chequeNo, chequeDate, bankName,app_status,submittedBankName,remark,selectedUser.getDsaCode());
			if (n >= 1) 
			{
				Connection conn =DataBaseConnection.JAVAConnection();
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
				printVoucherDetail();
				if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
				{
					
					double preAmount=obj.acconuntHolderAmountByAccountNo(accno);
					Double newAmount=preAmount+Double.parseDouble(amount);
					obj.updateSavingAmountByAccountNo(accno,newAmount);
					obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(amount),conn);
					
					sendMessage(newAmount, conn);
					
				}
				else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
				{
				
					double preAmount=obj.acconuntHolderAmountByAccountNo(accno);
					Double newAmount=preAmount+Double.parseDouble(amount);
					obj.updateSavingAmountByAccountNo(accno,newAmount);
					obj.increaseBankBalance(submittedBankName, Double.valueOf(amount),conn);
				}
				try {
					conn.close();
				} catch (Exception e) {
					// TODO: handle exception
				}
				sessionRemove();
				return "userDeposit";
			} 
			else
			{
				FacesContext fc = FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			}
		}
		return "";
	}
	
	private void sendMessage(Double newAmount, Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		String dt=new SimpleDateFormat("dd-MM-yyyy").format(currentDate);
		String userId=obj.userId();
		String check=obj.checkStatusInMessageSettingTable("Saving Deposit");
		if(check.equals("active"))
		{
			String typeMessage="Your SB A/c "+accno+" is Credited by Rs. "+amount+" on "+dt+" By Deposit. Avbl Bal Rs. "+newAmount +". Thanks... If any Query Please Contact At Branch. " ;
			obj.runMessageUrl(branchId,user_info.getContactNo(), typeMessage, userId,"1207161799212319872", conn);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Message For This Module is not Active. Please Go to In User Block and Active Message For This Module."));
		}
	}

	
	public void searchReport()
	{
		rlist=new DataBaseMethodsOther().savingAccountReport(selectedUser.getAccountNo(),startDate,endDate);
		opBalance=new DataBaseMethodsOther().openingBalance(selectedUser.getAccountNo(),startDate);
		Collections.sort(rlist);
		calculate();
	}
	
	public void calculate()
	{
		totalCredit=totalDebit=closingBalance=0;
		for(ReportInfo ll:rlist)
		{
			//if(ll.getStatus().equalsIgnoreCase("Withdrawal"))
			{
				totalCredit+=ll.getCreditAmount();
			}
			//else if(ll.getStatus().equalsIgnoreCase("Deposit") || ll.getStatus().equalsIgnoreCase("Interest"))
			{
				totalDebit+=ll.getDebitAmount();
			}
		}
		totalDebit+=opBalance;
		closingBalance=totalDebit-totalCredit;
		totalCredit=Double.parseDouble(dc.format(totalCredit));
		totalDebit=Double.parseDouble(dc.format(totalDebit));
		closingBalance=Double.parseDouble(dc.format(closingBalance));
	}
	
	private void sessionRemove() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.removeAttribute("selectedUser");
		ss.removeAttribute("pageName");
	}

	public void printVoucherDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", "");
		ss.setAttribute("expDate", currentDate);
		ss.setAttribute("amount", amount);
		ss.setAttribute("vchtype", "Credit");
		ss.setAttribute("payTo", accno+" - "+user_info.getFirst_applicantName());
		ss.setAttribute("being", "Saving Deposit");
		ss.setAttribute("payMode", paymentMode);
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}
	
	public String getPageName() {
		return pageName;
	}

	public void setPageName(String pageName) {
		this.pageName = pageName;
	}

	public List<String> getList() {
		return list;
	}

	public void setList(List<String> list) {
		this.list = list;
	}

	public UserInfo getSelectedUser() {
		return selectedUser;
	}

	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}

	public double getTotalDebit() {
		return totalDebit;
	}

	public void setTotalDebit(double totalDebit) {
		this.totalDebit = totalDebit;
	}

	public double getTotalCredit() {
		return totalCredit;
	}

	public void setTotalCredit(double totalCredit) {
		this.totalCredit = totalCredit;
	}

	public double getClosingBalance() {
		return closingBalance;
	}

	public void setClosingBalance(double closingBalance) {
		this.closingBalance = closingBalance;
	}

	public double getOpBalance() {
		return opBalance;
	}

	public void setOpBalance(double opBalance) {
		this.opBalance = opBalance;
	}

	public ArrayList<ReportInfo> getRlist() {
		return rlist;
	}

	public void setRlist(ArrayList<ReportInfo> rlist) {
		this.rlist = rlist;
	}

	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 UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public String getApp_firstName() {
		return app_firstName;
	}
	public void setApp_firstName(String app_firstName) {
		this.app_firstName = app_firstName;
	}
	public String getApp_middleName() {
		return app_middleName;
	}
	public void setApp_middleName(String app_middleName) {
		this.app_middleName = app_middleName;
	}
	public String getApp_lastName() {
		return app_lastName;
	}
	public void setApp_lastName(String app_lastName) {
		this.app_lastName = app_lastName;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public String getMob() {
		return mob;
	}
	public void setMob(String mob) {
		this.mob = mob;
	}
	public String getAddrs() {
		return addrs;
	}
	public void setAddrs(String addrs) {
		this.addrs = addrs;
	}
	public Date getCurrentDate() {
		return currentDate;
	}
	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}
	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	public String getAccno() {
		return accno;
	}
	public void setAccno(String accno) {
		this.accno = accno;
	}
	public String getChequeNo() {
		return chequeNo;
	}
	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}
	public String getAmount() {
		return amount;
	}
	public void setAmount(String amount) {
		this.amount = amount;
	}
	public String getBankName() {
		return bankName;
	}
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}
	public String getPaymentMode() {
		return paymentMode;
	}
	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}
	public boolean isValue() {
		return value;
	}
	public void setValue(boolean value) {
		this.value = value;
	}
	public boolean isShowDetail() {
		return showDetail;
	}
	public void setShowDetail(boolean showDetail) {
		this.showDetail = showDetail;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	public String getTransfer() {
		return transfer;
	}

	public void setTransfer(String transfer) {
		this.transfer = transfer;
	}

	public boolean isShowTransfer() {
		return showTransfer;
	}

	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}

	public boolean isShowTransferSelect() {
		return showTransferSelect;
	}

	public void setShowTransferSelect(boolean showTransferSelect) {
		this.showTransferSelect = showTransferSelect;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}
	
}
