package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;

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 group_head_package.DataBaseIncomeExpense;

@ManagedBean(name = "advanceSalaryPay")
@ViewScoped
public class AdvanceSalaryPayBean implements Serializable {
	private static final long serialVersionUID = 1L;

	String selectedYear, selectedMonth, selectEmployee;
	Date payDate = new Date();

	String amount, description;

	String lableEmpCode;
	public String employeeName, panNumber, designation, branch, state, bankName, bankAccountNo, dateOfJoining;
	String paymentMode, bankBranch, chequeNo, label;
	String paymentBankName;
	Date chequeDate;
	int branchId;
	boolean showDetails = false;
	boolean showCheque = false;
	boolean showBank = false;
	ArrayList<SelectItem> monthList, yearList, employeeList, bankList;
	ArrayList<AdvanceSalaryPayInfo> advanceSalaryList = new ArrayList<>();

	BankInfo bank_info;

	DataBaseMethodsSalary dbms = new DataBaseMethodsSalary();
	DbYashwant dby = new DbYashwant();
	DataBaseMethods dbm = new DataBaseMethods();
	DataBaseMethodsRavi dbr = new DataBaseMethodsRavi();

	public AdvanceSalaryPayBean() {
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");

		yearList = dbms.allYearList();
		monthList = dbms.allMonths();
		Connection conn = DataBaseConnection.JAVAConnection();
		bankList = new DataBaseIncomeExpense().allBankList(conn);

		String dd = "";
		employeeList = dbms.employeeListForSalary(branchId, dd);
	}

	public void search() {

		showDetails = false;

		if (selectEmployee == null || selectEmployee.trim().isEmpty()) {
			return;
		}

		String type = "employeeCode";
		String employeeCode = dby.fetchEmployeeDetail(selectEmployee, type);

		lableEmpCode = dby.manageEmployeeId(employeeCode);

		type = "employeeName";
		employeeName = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "panNo";
		panNumber = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "designation";
		designation = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "branch";
		branch = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "state";
		state = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "bankName1";
		bankName = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "bankAccNo";
		bankAccountNo = dby.fetchEmployeeDetail(selectEmployee, type);

		type = "dateOfJoin";
		dateOfJoining = dby.fetchEmployeeDetail(selectEmployee, type);

		showDetails = true;
		loadAdvanceSalaryList();

	}

	public void checkPaymentMode() {

		showCheque = false;
		showBank = false;

		if (paymentMode == null || paymentMode.trim().isEmpty()) {
			return;
		}

		if (paymentMode.equalsIgnoreCase("Cash")) {

			showCheque = false;
			showBank = false;

		} else if (paymentMode.equalsIgnoreCase("Bank Deduction")) {

			showBank = true;
			showCheque = false;

		} else {

			label = paymentMode;
			showCheque = true;
			showBank = false;
		}
	}

	public void checkBank() {

		Connection conn = DataBaseConnection.JAVAConnection();

		try {
			bank_info = dbm.obtainBankInfoById(paymentBankName, conn);

			if (bank_info != null) {
				bankBranch = bank_info.getBank_branch();
			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (conn != null) {
					conn.close();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	public void pay() {

		// 1. Employee, Month and Year Validation
		if (selectEmployee == null || selectEmployee.trim().isEmpty() || selectedMonth == null
				|| selectedYear == null) {

			FacesContext.getCurrentInstance().addMessage(null,
					new FacesMessage("Please Select Employee, Month and Year"));
			return;
		}

		// 2. Get Employee Code
		String employeeCode = dby.fetchEmployeeDetail(selectEmployee, "employeeCode");

		if (employeeCode == null || employeeCode.trim().isEmpty()) {
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Employee Code Not Found"));
			return;
		}

		// 3. Check Salary Payment Status
		int salaryStatus = 0;

		try (Connection conn = DataBaseConnection.JAVAConnection()) {

			salaryStatus = dby.checkSalaryStatus(conn, employeeCode, selectedMonth, selectedYear);

		} catch (Exception e) {
			e.printStackTrace();

			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Unable to Check Salary Status"));
			return;
		}

		// 4. Stop Advance Payment If Salary Already Paid
		if (salaryStatus > 0) {

			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR,
					"Salary already paid for selected month. Advance Salary cannot be paid.", null));

			return;
		}

		// 5. Pay Date and Amount Validation
		if (payDate == null || amount == null || amount.trim().isEmpty()) {

			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Enter Pay Date and Amount"));
			return;
		}

		double payAmount;

		try {
			payAmount = Double.parseDouble(amount.trim());

			if (payAmount <= 0) {
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Enter Valid Amount"));
				return;
			}

		} catch (NumberFormatException e) {

			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Invalid Amount"));
			return;
		}

		// 6. Payment Mode Validation
		if (paymentMode == null || paymentMode.trim().isEmpty()) {
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select Payment Mode"));
			return;
		}

		if (paymentMode.equalsIgnoreCase("Cash")) {

			paymentBankName = null;
			bankBranch = null;
			chequeNo = null;
			chequeDate = null;

		} else if (paymentMode.equalsIgnoreCase("Bank Deduction")) {

			bankBranch = null;
			chequeNo = null;
			chequeDate = null;
		}

		// 7. Insert Advance Salary Payment
		int result = dbr.addAdvanceSalaryPay(selectEmployee, selectedMonth, selectedYear, String.valueOf(payAmount),
				branchId, payDate, paymentMode, paymentBankName, bankBranch, description, chequeNo, chequeDate);

		// 8. Payment Success / Failure
		if (result > 0) {

			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Advance Salary Paid Successfully"));

			amount = "";
			description = "";
			paymentMode = "";
			paymentBankName = "";
			bankBranch = "";
			chequeNo = "";
			chequeDate = null;
			payDate = new Date();

			showCheque = false;
			showBank = false;

			loadAdvanceSalaryList();

		} else {

			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Failed. Please Try Again."));
		}
	}

	
	
	
	
	public void deleteAdvanceSalary(AdvanceSalaryPayInfo row) {

	    try {

	        String employeeCode = dby.fetchEmployeeDetail(
	                row.getEmpId(), "employeeCode");

	        int result = dbr.deleteAdvanceSalaryPay(
	                row.getId(),
	                employeeCode,
	                row.getMonth(),
	                row.getYear(),
	                branchId
	        );

	        if (result == 1) {

	            FacesContext.getCurrentInstance().addMessage(null,
	                    new FacesMessage(
	                            FacesMessage.SEVERITY_INFO,
	                            "Success",
	                            "Advance Salary Payment Deleted Successfully"
	                    ));

	        } else if (result == -1) {

	            FacesContext.getCurrentInstance().addMessage(null,
	                    new FacesMessage(
	                            FacesMessage.SEVERITY_ERROR,
	                            "Not Allowed",
	                            "Salary already paid. Advance Salary cannot be deleted."
	                    ));

	        } else {

	            FacesContext.getCurrentInstance().addMessage(null,
	                    new FacesMessage(
	                            FacesMessage.SEVERITY_ERROR,
	                            "Error",
	                            "Unable to delete Advance Salary Payment"
	                    ));
	        }

	        loadAdvanceSalaryList();

	    } catch (Exception e) {
	        e.printStackTrace();
	    }
	}
	
	public void loadAdvanceSalaryList() {

		advanceSalaryList = dbr.getAdvanceSalaryPayList(selectEmployee, selectedMonth, selectedYear, branchId);
	}

	public ArrayList<AdvanceSalaryPayInfo> getAdvanceSalaryList() {
		return advanceSalaryList;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public boolean isShowCheque() {
		return showCheque;
	}

	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}

	public boolean isShowBank() {
		return showBank;
	}

	public void setShowBank(boolean showBank) {
		this.showBank = showBank;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public boolean isShowDetails() {
		return showDetails;
	}

	public void setShowDetails(boolean showDetails) {
		this.showDetails = showDetails;
	}

	public DbYashwant getDby() {
		return dby;
	}

	public void setDby(DbYashwant dby) {
		this.dby = dby;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public String getSelectedYear() {
		return selectedYear;
	}

	public void setSelectedYear(String selectedYear) {
		this.selectedYear = selectedYear;
	}

	public String getSelectedMonth() {
		return selectedMonth;
	}

	public void setSelectedMonth(String selectedMonth) {
		this.selectedMonth = selectedMonth;
	}

	public String getSelectEmployee() {
		return selectEmployee;
	}

	public void setSelectEmployee(String selectEmployee) {
		this.selectEmployee = selectEmployee;
	}

	public DataBaseMethodsSalary getDbms() {
		return dbms;
	}

	public void setDbms(DataBaseMethodsSalary dbms) {
		this.dbms = dbms;
	}

	public ArrayList<SelectItem> getMonthList() {
		return monthList;
	}

	public void setMonthList(ArrayList<SelectItem> monthList) {
		this.monthList = monthList;
	}

	public ArrayList<SelectItem> getYearList() {
		return yearList;
	}

	public void setYearList(ArrayList<SelectItem> yearList) {
		this.yearList = yearList;
	}

	public ArrayList<SelectItem> getEmployeeList() {
		return employeeList;
	}

	public void setEmployeeList(ArrayList<SelectItem> employeeList) {
		this.employeeList = employeeList;
	}

	public String getLableEmpCode() {
		return lableEmpCode;
	}

	public void setLableEmpCode(String lableEmpCode) {
		this.lableEmpCode = lableEmpCode;
	}

	public String getEmployeeName() {
		return employeeName;
	}

	public void setEmployeeName(String employeeName) {
		this.employeeName = employeeName;
	}

	public String getPanNumber() {
		return panNumber;
	}

	public void setPanNumber(String panNumber) {
		this.panNumber = panNumber;
	}

	public String getDesignation() {
		return designation;
	}

	public void setDesignation(String designation) {
		this.designation = designation;
	}

	public String getBranch() {
		return branch;
	}

	public void setBranch(String branch) {
		this.branch = branch;
	}

	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getBankAccountNo() {
		return bankAccountNo;
	}

	public void setBankAccountNo(String bankAccountNo) {
		this.bankAccountNo = bankAccountNo;
	}

	public String getDateOfJoining() {
		return dateOfJoining;
	}

	public void setDateOfJoining(String dateOfJoining) {
		this.dateOfJoining = dateOfJoining;
	}

	public String getBankBranch() {
		return bankBranch;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}

	public String getPaymentBankName() {
		return paymentBankName;
	}

	public void setPaymentBankName(String paymentBankName) {
		this.paymentBankName = paymentBankName;
	}

	public DataBaseMethods getDbm() {
		return dbm;
	}

	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}

	public Date getPayDate() {
		return payDate;
	}

	public void setPayDate(Date payDate) {
		this.payDate = payDate;
	}

	public String getAmount() {
		return amount;
	}

	public void setAmount(String amount) {
		this.amount = amount;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

}
