package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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;

@ViewScoped
@ManagedBean(name="salaryAutoFormation")
public class SalaryAutoFormationBean implements Serializable
{
	DataBaseMethodsSalary dbms=new DataBaseMethodsSalary();
	ArrayList<SelectItem> monthList,yearList,employeeList;
	String selectedYear,selectedMonth;
	DataBaseMethods db=new DataBaseMethods();
	String emloy_name,reson;
	double rate,business,gross_salary,deducation,incentive,final_salary;
	ArrayList<SelectItem> list=new ArrayList<>();
	ArrayList<SelectItem> mlist=new ArrayList<>();
	ArrayList<EmpInfo> showlist=new ArrayList<EmpInfo>();
	ArrayList<EmpInfo> datalist=new ArrayList<EmpInfo>();
	EmpInfo info;
	boolean showTable;
	
	
	int viewemploy ;
	
	
	public SalaryAutoFormationBean() 
	{
		yearList=dbms.allYearList();
		monthList=dbms.allMonths();
		
		Date date=db.uniqueDate();
		StringBuffer temp=new StringBuffer(String.valueOf(date));
		selectedYear=temp.substring(temp.length()-4);
		selectedMonth=String.valueOf(date.getMonth()+1);
	}
	
	public void checkSalaryOfMonth()
	{
		HttpSession ss0=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss0.getAttribute("branchId");
		showTable=true;
		boolean cheksalary=dbms.cheksalarysearch(branchId,selectedMonth,selectedYear);
		if(cheksalary==false)
		{
			int dayMonth=dbms.calculateDayInMonth(Integer.parseInt(selectedMonth),Integer.parseInt(selectedYear));
			String dd=selectedYear+"-"+selectedMonth+"-"+dayMonth;
			employeeList=dbms.employeeListForSalary(branchId,dd);
			
			int count=1;
			for(SelectItem ss: employeeList)
			{
				EmpInfo ee=new EmpInfo();
				ee.setSno(count++);
				ee.setUname(String.valueOf(ss.getValue()));
				showlist.add(ee);
			}
		}
		else
		{
			showlist=dbms.showdataofemply(branchId,selectedMonth,selectedYear);
		}
	}

	public void addsalarybutton()
	{
		
		Connection con = DataBaseConnection.JAVAConnection();
		int empBranchId = new DataBaseMethods().empBranchIdByEmpId(showlist.get(0).getUname(),con);
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		int r=0; 
		boolean cheksalary=dbms.cheksalarysearch(empBranchId,selectedMonth,selectedYear);
		if(cheksalary==false)
		{
			for(EmpInfo info:showlist) 
			{
				r=dbms.addsalary(selectedMonth,selectedYear,info.getUname(),info.getRate(),info.getBusiness(),info.getGrossSalary(),info.getDeduction(),info.getIncentive(),info.getReason(),info.getFinalSalary(),empBranchId);	
			}
			
			if(r>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Salary Add Sucessfully"));
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please check  detail"));
			}
			
		}
		else
		{
			for(EmpInfo info:showlist) 
			{
				r=dbms.updatesalary(info.getName(),info.getRate(),info.getBusiness(),info.getGrossSalary(),info.getDeduction(),info.getIncentive(),info.getReason(),
						info.getFinalSalary(), info.getId(), selectedMonth, selectedYear);	
			}
			
			if(r>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Salary Update Sucessfully"));
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please check  detail"));
			}
		}
		
	}
	
	
	public void gross_salaryCalcu()
	{
		for(EmpInfo info:showlist)
		{
			double gross_amount=info.getBusiness()*info.getRate();
			info.setGrossSalary(gross_amount);
			info.setFinalSalary(gross_amount);
		}
	}
	
	public void deductionCalcu()
	{
		for(EmpInfo info:showlist)
		{
			double deduc=info.getGrossSalary()-info.getDeduction();
			info.setFinalSalary(deduc);
		}
	}

	public void incentiveCalcu()
	{
		for(EmpInfo info:showlist)
		{
			double ince=(info.getGrossSalary()-info.getDeduction())+info.getIncentive();
			info.setFinalSalary(ince);
		}
	}

	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 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 getEmloy_name() {
		return emloy_name;
	}

	public void setEmloy_name(String emloy_name) {
		this.emloy_name = emloy_name;
	}

	public String getReson() {
		return reson;
	}

	public void setReson(String reson) {
		this.reson = reson;
	}

	public double getRate() {
		return rate;
	}

	public void setRate(double rate) {
		this.rate = rate;
	}

	public double getBusiness() {
		return business;
	}

	public void setBusiness(double business) {
		this.business = business;
	}

	public double getGross_salary() {
		return gross_salary;
	}

	public void setGross_salary(double gross_salary) {
		this.gross_salary = gross_salary;
	}

	public double getDeducation() {
		return deducation;
	}

	public void setDeducation(double deducation) {
		this.deducation = deducation;
	}

	public double getIncentive() {
		return incentive;
	}

	public void setIncentive(double incentive) {
		this.incentive = incentive;
	}

	public double getFinal_salary() {
		return final_salary;
	}

	public void setFinal_salary(double final_salary) {
		this.final_salary = final_salary;
	}

	public ArrayList<SelectItem> getList() {
		return list;
	}

	public void setList(ArrayList<SelectItem> list) {
		this.list = list;
	}

	public ArrayList<SelectItem> getMlist() {
		return mlist;
	}

	public void setMlist(ArrayList<SelectItem> mlist) {
		this.mlist = mlist;
	}

	public ArrayList<EmpInfo> getShowlist() {
		return showlist;
	}

	public void setShowlist(ArrayList<EmpInfo> showlist) {
		this.showlist = showlist;
	}

	public ArrayList<EmpInfo> getDatalist() {
		return datalist;
	}

	public void setDatalist(ArrayList<EmpInfo> datalist) {
		this.datalist = datalist;
	}

	public EmpInfo getInfo() {
		return info;
	}

	public void setInfo(EmpInfo info) {
		this.info = info;
	}


	public int getViewemploy() {
		return viewemploy;
	}

	public void setViewemploy(int viewemploy) {
		this.viewemploy = viewemploy;
	}

	public boolean isShowTable() {
		return showTable;
	}

	public void setShowTable(boolean showTable) {
		this.showTable = showTable;
	}
}	
	
