package main_package;

import java.io.Serializable;
import java.security.Timestamp;
import java.sql.Connection;
import java.sql.PreparedStatement;
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 report_package.DataBaseReportMethods;

@ManagedBean(name="branchToBranchCashTransfer")
@ViewScoped
public class BranchToBranchCashTransferBean implements Serializable 
{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	String totalCashAvl="0.0", totalCashTra="0.0",branchName, remark;
	int fromBranch, toBranch, searchBranch;
	Date searchDate;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	DataBaseMethods dbObj = new DataBaseMethods();
	DataBaseReportMethods dbmr= new DataBaseReportMethods();
	DecimalFormat df=new DecimalFormat("##.##");
	ArrayList<TrialInfo> list, listGtf,list1;
	TrialInfo selectedCashRow;
	
	
	boolean showGtf,listView = true,listView1=false;
	
	public BranchToBranchCashTransferBean()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		
		branchList = dbObj.branchListAllWithName(con);
		searchDate=new Date();
		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	
	public void updateCashDate() {
		int change = 0;
	   int i = 0;
	 int id = selectedCashRow.getId();
		
		try(Connection conn = DataBaseConnection.JAVAConnection()){
		
			String query ="update cash_transfer_table set transfer_dt = ? where id = ?";
			
			try(PreparedStatement ps = conn.prepareStatement(query)){
				
				while(i<2) {
				
				ps.setDate(1, new java.sql.Date(selectedCashRow.getTrDate().getTime()));
				ps.setInt(2, id);
				System.out.println(query+" :CashQuery" +"Date :"+selectedCashRow.getTrDate()+"! &amp id :"+id);
			    change = ps.executeUpdate();
				id = id-1;
				i++;
				
				}
			
			 if(change>0) {
				 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("New Date Applied Succesfully"));
			 }
				
			}catch(Exception e) {
				
				e.printStackTrace();
				
			}
			
		}catch(Exception e) {
			
			e.printStackTrace();
			
		}
		
		
	}
	
	public void viewData()
	{
		
		
		if(searchBranch==-1)
		{  
			 listView1 =true;
			 listView = false;
		       
		//	list=dbmr.branchToBranchCashTransferList(searchBranch);
			 System.out.println("my method bean hit");
			list1= dbmr.newBranchToBranchCashTransferList();   // RR/15/5
			
			System.out.println("process End!!");
			
			
		}
		else
		{
			
			 listView1 =false;
			 listView = true;
			
			HeaderBean hh=new HeaderBean();
			if(hh.getName().equalsIgnoreCase("GANESHAM TRUELIFE FOUNDATION"))
			{
				listGtf=dbmr.branchToBranchCashTransferAnalysis(searchBranch);
				list=dbmr.branchToBranchCashTransferList(searchBranch);
				showGtf=true;
			}
			else
			{
				list=dbmr.branchToBranchCashTransferList(searchBranch);
			}
		}
	}

	public void updateCash()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		branchName= dbObj.branchNameByBranchId(fromBranch, con);
		double totCashAvl  = dbObj.remainingCompanyCapitalAmount(fromBranch,con);
		/*double absCashTransferCr = dbObj.calculateCashTransferCr(fromBranch,"all",con);
		double absCashTransferDr = dbObj.calculateCashTransferDr(fromBranch,"all",con);*/  
		// Both upper 2 lines comments on 28 nov 2021 due to adding these method in existing code and now don't need these method 
		
		totalCashAvl= String.valueOf(Double.parseDouble(df.format(totCashAvl)));
		 
		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String transferCash()
	{
		totalCashAvl= String.valueOf(Double.valueOf(totalCashAvl)-Double.valueOf(totalCashTra));
		
		if(toBranch==-1 || fromBranch == -1)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch Properly"));
		}
		else
		{
			if(fromBranch==toBranch)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Branch Must be different"));
			}
			else
			{
				if(Double.valueOf(totalCashAvl)>=0)
				{
					if(Double.valueOf(totalCashTra)>0)
					{
						Connection con = DataBaseConnection.JAVAConnection();
						int res = dbObj.decreaseCashAmount(fromBranch,totalCashTra, searchDate, remark,con);
						if(res==1)
						{
							dbObj.decreaseCapitalCompanyAmount(fromBranch, Double.valueOf(totalCashTra));  // add line 16 oct 2022
							int res2 = dbObj.increaseCashAmount(toBranch,totalCashTra, searchDate,remark,con);
							if(res2==1)
							{
								dbObj.increaseCompanyCapitalAmount(toBranch, Double.valueOf(totalCashTra),con);  // add line 16 oct 2022
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Cash Amount Transfer Successfully"));
								fromBranch=toBranch=-1;
								totalCashAvl=totalCashTra="0.00";
							}
							else
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured"));
							}
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured"));
						}
						
						
						
						try {
							con.close();
						} catch (Exception e) {
							// TODO: handle exception
						}
					}
					else
					{
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Transfer amount must be greater than 0"));
					}
					
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Branch Dont have sufficient cash"));
				}
			}
		}
		
		return "branchToBranchCashTransfer.xhtml";
	}
	
	
	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public String getTotalCashAvl() {
		return totalCashAvl;
	}

	public void setTotalCashAvl(String totalCashAvl) {
		this.totalCashAvl = totalCashAvl;
	}

	public String getTotalCashTra() {
		return totalCashTra;
	}

	public void setTotalCashTra(String totalCashTra) {
		this.totalCashTra = totalCashTra;
	}

	public int getFromBranch() {
		return fromBranch;
	}

	public void setFromBranch(int fromBranch) {
		this.fromBranch = fromBranch;
	}

	public int getToBranch() {
		return toBranch;
	}

	public void setToBranch(int toBranch) {
		this.toBranch = toBranch;
	}

	public String getBranchName() {
		return branchName;
	}

	public void setBranchName(String branchName) {
		this.branchName = branchName;
	}

	public Date getSearchDate() {
		return searchDate;
	}

	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}

	public ArrayList<TrialInfo> getList() {
		return list;
	}

	public void setList(ArrayList<TrialInfo> list) {
		this.list = list;
	}

	public int getSearchBranch() {
		return searchBranch;
	}

	public void setSearchBranch(int searchBranch) {
		this.searchBranch = searchBranch;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}


	public ArrayList<TrialInfo> getListGtf() {
		return listGtf;
	}

	public void setListGtf(ArrayList<TrialInfo> listGtf) {
		this.listGtf = listGtf;
	}

	public boolean isShowGtf() {
		return showGtf;
	}

	public void setShowGtf(boolean showGtf) {
		this.showGtf = showGtf;
	}

	public ArrayList<TrialInfo> getList1() {
		return list1;
	}

	public void setList1(ArrayList<TrialInfo> list1) {
		this.list1 = list1;
	}

	public DataBaseMethods getDbObj() {
		return dbObj;
	}

	public void setDbObj(DataBaseMethods dbObj) {
		this.dbObj = dbObj;
	}

	public DataBaseReportMethods getDbmr() {
		return dbmr;
	}

	public void setDbmr(DataBaseReportMethods dbmr) {
		this.dbmr = dbmr;
	}

	public DecimalFormat getDf() {
		return df;
	}

	public void setDf(DecimalFormat df) {
		this.df = df;
	}

	public boolean isListView() {
		return listView;
	}

	public void setListView(boolean listView) {
		this.listView = listView;
	}

	public boolean isListView1() {
		return listView1;
	}

	public void setListView1(boolean listView1) {
		this.listView1 = listView1;
	}

	public TrialInfo getSelectedCashRow() {
		return selectedCashRow;
	}

	public void setSelectedCashRow(TrialInfo selectedCashRow) {
		this.selectedCashRow = selectedCashRow;
	}

	
	
}
