package main_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.concurrent.TimeUnit;

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 group_head_package.DataBaseIncomeExpense;

@ManagedBean(name = "manageSalaryCreation")
@ViewScoped

public class ManageSalaryCreation implements Serializable
{	
	int count, branchId;
	
	String branchUserId;
	
	String empUserId, selectedName, selectedYear, selectedMonth;
	
	String name, description, paymentMode, chequeNo, savingAccountNo, bankBranch, label, borrowAmount, savingNo, fromBank;
	
	
	double totalAmount;
	
	
	Date startDate, endDate;
	
	Date payDate = new Date(), chequeDate;
	
	
	boolean showPanel, showCheque,showTransfer;
	
	
	public static List<String> savingAccList;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	
	
	ArrayList<SalaryCreationInfo> empList1;
	ArrayList<SelectItem> list, bankList, empList;
	
	
	SalaryCreationInfo selectedRow;
	UserInfo savingDetail;
	BankInfo bank_info;
	
	DataBaseMethods obj = new DataBaseMethods();
	DataBaseMethodsSalary dbms=new DataBaseMethodsSalary();
	DataBaseMethods dbm=new DataBaseMethods();
	DbYashwant dby = new DbYashwant();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
    
    
	
	public ManageSalaryCreation()
	{   
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		Connection con = DataBaseConnection.JAVAConnection();

		startDate = new Date();
		branchUserId = (String) ss.getAttribute("branchUserId");

		long oneDayMillis = TimeUnit.DAYS.toMillis(1);
	 	startDate = new Date(startDate.getTime() - oneDayMillis);
	 	Date date = obj.uniqueDate();
		StringBuffer temp = new StringBuffer(String.valueOf(date));
		selectedYear = temp.substring(temp.length()-4);
		selectedMonth = String.valueOf(date.getMonth()+1);
		endDate = new Date();
		branchList = new DataBaseMethods().branchList(branchUserId,con);
        
		branchId = (int) ss.getAttribute("branchId");	
		
		empList = dbms.allEmployeeList(branchId,con);	
	}
	
	
	
	public void allEmpList()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		empList = dbms.allEmployeeList(branchId,con);	
	}
	
	
	
	public void searchEmployeeSalary()
	{
		empList1 = new ArrayList<>();
		Connection conn = DataBaseConnection.JAVAConnection();
		System.out.println("emp name"+selectedName);
		empList1 = dbmt.manageSalaryList(conn,selectedMonth,selectedYear,selectedName,branchId);
	}
	
	
		
	public void savingAccountDetail()
	{	
		//System.out.println("sv: "+savingAccountNo);
		if(savingAccountNo.contains("/"))
		{
			savingNo = savingAccountNo.substring(0,savingAccountNo.indexOf("/"));
		}
		
		savingDetail = obj.savingAccountDetailByAccountNo(savingNo);
	}
	
	
	
	public void printSlip() throws IOException
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("employeeCode", selectedRow.getLableEmpCode());
		ss.setAttribute("function", selectedRow.getFuntion());
		ss.setAttribute("department",selectedRow.getDepartment());
		ss.setAttribute("city",selectedRow.getCity());
		ss.setAttribute("employeeName", selectedRow.getEmployeeName());
		ss.setAttribute("empName", selectedRow.getName());
		ss.setAttribute("panNo", selectedRow.getPanNumber());
		ss.setAttribute("designation", selectedRow.getDesination());
		ss.setAttribute("pfNo", selectedRow.getPfNumber());
		ss.setAttribute("branch", selectedRow.getBranch());
		ss.setAttribute("uanNo", selectedRow.getUanNo());
		ss.setAttribute("state", selectedRow.getState());
		ss.setAttribute("esicNo", selectedRow.getEsicNo());
		ss.setAttribute("bankName", selectedRow.getBankName());
		ss.setAttribute("bankAccNo", selectedRow.getBankAccountNo());
		ss.setAttribute("dateOfJoining", selectedRow.getDateOfJoining());
		ss.setAttribute("totalDays", selectedRow.getTotalDays());
		ss.setAttribute("workingDays", selectedRow.getWorkingDays());
		ss.setAttribute("lopDays", selectedRow.getLopDays());
		ss.setAttribute("basic", selectedRow.getBasicMonth());
		ss.setAttribute("houseRentAllowance", selectedRow.getHouseRentAllowance());
		ss.setAttribute("specialAllowance", selectedRow.getSpecialAllowance());
		ss.setAttribute("otherAllowanace", selectedRow.getOtherAllowance());
		ss.setAttribute("grossSalary", selectedRow.getGrossSalary());
		ss.setAttribute("totalPfDeduction", selectedRow.getTotalPfDeduction());
		ss.setAttribute("totalEsicDeduction", selectedRow.getTotalEsicDeduction());
		ss.setAttribute("netCash", selectedRow.getNetCashInHand());
		ss.setAttribute("branchNameEmp",selectedRow.getBranch());
		ss.setAttribute("salaryMonth", selectedRow.getSalaryMonth());
		ss.setAttribute("salaryYear", selectedRow.getSalaryYear());
		ss.setAttribute("arrear", selectedRow.getArrear());
		ss.setAttribute("incentive", selectedRow.getIncentive());
		ss.setAttribute("arrearIncentive", selectedRow.getArrearIncentive());
		ss.setAttribute("otherDeduction", selectedRow.getOthersDeduction());
		ss.setAttribute("extraAmountForFuel",selectedRow.getFuelAmount());
		System.out.println("extra amount  fuel is:"+selectedRow.getFuelAmount());
		RequestContext.getCurrentInstance().execute("window.open('printSalarySlipNew.xhtml')");
	}
	
	
	
	public void payout()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		
		dby.salaryPayoutUpdate(conn, selectedRow.getEmployeeName(), selectedRow.getGrossSalary(), "Debit", payDate, paymentMode, 
							   chequeNo, chequeDate, fromBank, bankBranch, description, selectedRow.getId());
		
		int i = obj.addSalaryPayout(selectedRow.getEmployeeName(), selectedRow.getGrossSalary(), "Debit", payDate, paymentMode, 
									chequeNo, chequeDate, fromBank, bankBranch, description, branchId, selectedRow.getSalaryMonth(), 
									selectedRow.getSalaryYear());

		if(i > 0)
		{
			//no=obj.nextNo("borrower");
			if(paymentMode.equalsIgnoreCase("Cash"))
			{
				double netCash = selectedRow.getGrossSalary();
			  	obj.decreaseCapitalCompanyAmount(branchId,netCash);
			  	FacesContext.getCurrentInstance().addMessage(null, 
			  										new FacesMessage("Employee Salary Payout Sucessfully. Transaction Completed."));
			  	searchEmployeeSalary();
			}
			else if(paymentMode.equalsIgnoreCase("Transfer"))
			{
				obj.increaseSavingAccountAmountForOdLoan(selectedRow.getGrossSalary(), savingNo);
				int a = obj.userDeposit(branchId, savingNo,String.valueOf(selectedRow.getGrossSalary()), payDate, paymentMode, chequeNo, 
										chequeDate, fromBank, "approved", "N/A", "Salary Credit", "");
				
				/*new DataBaseIncomeExpense().addExpense(payDate, "Other_Dr", paymentMode, String.valueOf(amount), chequeNo, bankBranch, bankName, chequeDate, 
						"Salary Credit", "Salary Credit", "0", "0", 0,"0");*/
				
				// Comment By Mr. Chetan Garg  4 Feb
				FacesContext.getCurrentInstance().addMessage(null, 
													new FacesMessage("Employee Salary Payout Sucessfully. Transaction Completed."));
				searchEmployeeSalary();
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, 
						new FacesMessage("Employee Salary Payout Sucessfully. Please Approve Cheque to complete the transaction."));
			}
		}
	}
	
	
	
	public void checkPaymentMode()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			showCheque = false;
		}
		else if(paymentMode.equalsIgnoreCase("Transfer"))
		{
			showCheque = false;
			showTransfer = true;
		}
		else
		{
			bankList = new ArrayList<>();
			bankList = new DataBaseIncomeExpense().allBankList(conn);
			label = paymentMode;
			showCheque = true;
		}
		
		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}	
	
	
	
	public List<String> completeText(String name)
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		savingAccList = new DataBaseAutoCompAndDuplicate().savingAccountNo(branchId,name);
		if(savingAccList.size() == 0)
		{
			FacesContext.getCurrentInstance().addMessage(null, 
												new FacesMessage("Saving Account Is not opened till now of Selected Share Holder"));
		}
		return savingAccList;
	}
	
	
	
	public void checkBank()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		bank_info = obj.obtainBankInfoById(fromBank, conn);
		bankBranch = bank_info.getBank_branch();
		
	/*	address=bank_info.address;
		accNo=bank_info.acc_no;*/
		
		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public void deleteData()
	{
		int i = 0;
		Connection conn = DataBaseConnection.JAVAConnection();
		
		i = dbmt.deleteSalaryCreationIIEntry(String.valueOf(selectedRow.getId()));
		
		if(i>0)
		{   
			dbmt.deleteSalaryLedgerEntry(selectedRow.getEmployeeName(), selectedRow.getSalaryMonth(), selectedRow.getSalaryYear());
			
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Entry Delete Sucessfully."));
			searchEmployeeSalary();
		}
		else 
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occurred !!! "));
		}
		try 
		{
			conn.close();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public int getCount() {
		return count;
	}
	public void setCount(int count) {
		this.count = count;
	}
	public int getBranchId() {
		return branchId;
	}
	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}
	public double getTotalAmount() {
		return totalAmount;
	}
	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}
	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 SalaryCreationInfo getSelectedRow() {
		return selectedRow;
	}
	public void setSelectedRow(SalaryCreationInfo selectedRow) {
		this.selectedRow = selectedRow;
	}



	public ArrayList<SalaryCreationInfo> getEmpList1() {
		return empList1;
	}



	public void setEmpList1(ArrayList<SalaryCreationInfo> empList1) {
		this.empList1 = empList1;
	}



	public ArrayList<SelectItem> getEmpList() {
		return empList;
	}



	public void setEmpList(ArrayList<SelectItem> empList) {
		this.empList = empList;
	}



	public boolean isShowPanel() {
		return showPanel;
	}



	public void setShowPanel(boolean showPanel) {
		this.showPanel = showPanel;
	}



	public String getEmpUserId() {
		return empUserId;
	}



	public void setEmpUserId(String empUserId) {
		this.empUserId = empUserId;
	}



	public DataBaseMethodsSalary getDbms() {
		return dbms;
	}



	public void setDbms(DataBaseMethodsSalary dbms) {
		this.dbms = dbms;
	}



	public DataBaseMethods getDbm() {
		return dbm;
	}



	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}



	public String getSelectedName() {
		return selectedName;
	}



	public void setSelectedName(String selectedName) {
		this.selectedName = selectedName;
	}



	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 getName() {
		return name;
	}



	public void setName(String name) {
		this.name = name;
	}



	public String getDescription() {
		return description;
	}



	public void setDescription(String description) {
		this.description = description;
	}



	public String getPaymentMode() {
		return paymentMode;
	}



	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}



	public String getChequeNo() {
		return chequeNo;
	}



	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}



	public String getSavingAccountNo() {
		return savingAccountNo;
	}



	public void setSavingAccountNo(String savingAccountNo) {
		this.savingAccountNo = savingAccountNo;
	}



	public String getBankBranch() {
		return bankBranch;
	}



	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}



	public String getLabel() {
		return label;
	}



	public void setLabel(String label) {
		this.label = label;
	}



	public String getBorrowAmount() {
		return borrowAmount;
	}



	public void setBorrowAmount(String borrowAmount) {
		this.borrowAmount = borrowAmount;
	}



	public String getSavingNo() {
		return savingNo;
	}



	public void setSavingNo(String savingNo) {
		this.savingNo = savingNo;
	}



	public String getFromBank() {
		return fromBank;
	}



	public void setFromBank(String fromBank) {
		this.fromBank = fromBank;
	}



	public ArrayList<SelectItem> getList() {
		return list;
	}



	public void setList(ArrayList<SelectItem> list) {
		this.list = list;
	}



	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}



	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}



	public boolean isShowCheque() {
		return showCheque;
	}



	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}



	public boolean isShowTransfer() {
		return showTransfer;
	}



	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}



	public UserInfo getSavingDetail() {
		return savingDetail;
	}



	public void setSavingDetail(UserInfo savingDetail) {
		this.savingDetail = savingDetail;
	}



	public Date getPayDate() {
		return payDate;
	}



	public void setPayDate(Date payDate) {
		this.payDate = payDate;
	}



	public Date getChequeDate() {
		return chequeDate;
	}



	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}



	public static List<String> getSavingAccList() {
		return savingAccList;
	}



	public static void setSavingAccList(List<String> savingAccList) {
		ManageSalaryCreation.savingAccList = savingAccList;
	}



	public BankInfo getBank_info() {
		return bank_info;
	}



	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}



	public DataBaseMethods getObj() {
		return obj;
	}



	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}



	public DbYashwant getDby() {
		return dby;
	}



	public void setDby(DbYashwant dby) {
		this.dby = dby;
	}



	public DataBaseMethodTaheer getDbmt() {
		return dbmt;
	}



	public void setDbmt(DataBaseMethodTaheer dbmt) {
		this.dbmt = dbmt;
	}



	public List<SelectItem> getBranchList() {
		return branchList;
	}



	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}



	public String getBranchUserId() {
		return branchUserId;
	}



	public void setBranchUserId(String branchUserId) {
		this.branchUserId = branchUserId;
	}
	
	
	

}