package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
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;


@ManagedBean(name="formSalary")
@ViewScoped
public class SalaryFormation implements Serializable {
	
	private static final long serialVersionUID = 1L;
	String selectedYear,selectedMonth,type,monthName,selectedEmployee;
	ArrayList<SelectItem> monthList,yearList,employeeList;
	EmployeeInfo employeeInfo;
	SalaryInfo salInfo;
	boolean showDescription;
	double grossSalaryDay=0,finalSalaryDay=0,salaryday=0;
	double fullDay,halfDay,leave,absent,holiday,suddenLeave,leaveAllowed,LMLF,NMLF,relaxation,totalSalaryDay,
	finalSalary,salary,suddenPenalty,absentPenalty,extraWork,allowance,p_f,salaryDay,esi,tds,pf;
	String bankName,accountNo,branch,paymentMode,salaryStatus,comment;
	int monthDay,month,year,lastFinalSalary;
	DataBaseMethods obj=new DataBaseMethods();
	DataBaseMethodsSalary dbms=new DataBaseMethodsSalary();
	
	@SuppressWarnings("deprecation")
	public SalaryFormation()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		/*HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		type=(String) ss.getAttribute("type");*/
		yearList=dbms.allYearList();
		monthList=dbms.allMonths();
		
		Date date=obj.uniqueDate();
		StringBuffer temp=new StringBuffer(String.valueOf(date));
		selectedYear=temp.substring(temp.length()-4);
		selectedMonth=String.valueOf(date.getMonth()+1);
		
		int dayMonth=dbms.calculateDayInMonth(Integer.parseInt(selectedMonth),Integer.parseInt(selectedYear));
		String dd=selectedYear+"-"+selectedMonth+"-"+dayMonth;
		employeeList=dbms.employeeListForSalary(branchId,dd);
		//// System.out.println(date+"....."+selectedMonth);
		//calculateSalary();
	}
	
	public void checkSalaryOfMonth()
    {
        String tempMonth="",tempYear="";
        if(selectedMonth.equals("12"))
        {
          tempMonth="12";
            tempYear=String.valueOf(Integer.parseInt(selectedYear));
        }
        else
        {
            tempMonth=String.valueOf(Integer.parseInt(selectedMonth));
            tempYear=selectedYear;
        }
        
        monthName=dbms.monthList(Integer.parseInt(selectedMonth));
       
        boolean sal=dbms.checkSalaryPreparation(selectedEmployee,selectedMonth,selectedYear);
        String checkAvailiableyear=dbms.checkSalaryofYear(tempMonth,tempYear,selectedEmployee);
       Date registrationDate=null;
       registrationDate=dbms.checkSalaryofEmployeeUsingRegistrationDate(selectedEmployee);
       int regMonth=registrationDate.getMonth();
       int regYear=registrationDate.getYear();
       
       //System.out.println("1111111111");
        if(Integer.parseInt(selectedMonth) >= (regMonth+1) || Integer.parseInt(selectedYear) > (regYear+1900))
        {
        	//System.out.println("22222222222222");
        	//System.out.println("sal"+sal);
            if(sal==true)
            {
              // System.out.println("333333333333333");
	            ////  System.out.println(tempMonth+"....."+tempYear);
	            boolean check=dbms.checkSalaryOfParticularMonth(tempMonth,tempYear,selectedEmployee);
	            ////  System.out.println(check);
	            String checkAvailiableMonth=dbms.checkSalaryofMonth(tempMonth,tempYear,selectedEmployee);
	          //  System.out.println(checkAvailiableMonth+"====="+tempMonth);
	          //  System.out.println(checkAvailiableyear+"====="+selectedYear);
	            if(checkAvailiableMonth.equals(tempMonth) && checkAvailiableyear.equalsIgnoreCase(selectedYear))
	            {
	                calculateSalary();
	                LMLF=dbms.checkNMLFOfLastMonth(tempMonth,tempYear,selectedEmployee);
	            }
	            else
	            {
		            if(check==true)
		            {
		                showDescription=false;
		                FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("You Can't Create Salary Of This Month Again"));
		            }
		            else
		            {
		                String selMnth=selectedMonth;
		                if(!selectedMonth.equals("1"))
		                {
		                    tempMonth=String.valueOf(Integer.parseInt(selectedMonth)-1);
		                    tempYear=selectedYear;
		                }
		                else
		                {
		                  selectedMonth="13";
		                    tempMonth=String.valueOf(Integer.parseInt(selectedMonth)-1);
		                    tempYear=String.valueOf(Integer.parseInt(selectedYear)-1);
		                }
		               
		                check=dbms.checkSalaryOfParticularEmployee(selectedEmployee);
		                if(check==true)
		                {
		                    //  System.out.println("kfldkslfksdklfkksdf"+checkAvailiableyear);
		                    //  System.out.println("kfldkslfksdklfkksdf"+selectedYear);
		                     if(Integer.parseInt(selectedYear) >= Integer.parseInt(checkAvailiableyear))
		                     {
		                         if((Integer.parseInt(selMnth)+Integer.parseInt(selectedYear)) > (Integer.parseInt(checkAvailiableMonth)+Integer.parseInt(checkAvailiableyear)))
		                         {
		                        check=dbms.checkSalaryOfParticularMonth(tempMonth,tempYear,selectedEmployee);
		                        if(check==false)
		                        {
		                            showDescription=false;
		                            FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Calculate Salary Of Previous Months First"));
		                        }
		                        else
		                        {
		                            calculateSalary();
		                            LMLF=dbms.checkNMLFOfLastMonth(tempMonth,tempYear,selectedEmployee);
		                        }
		                         }
		                         else
		                         {
		                             showDescription=false;
		                            FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Can't Create Salary Of this Month"));
		                         }
		                         }
		                         else
		                         {
		                             showDescription=false;
		                            FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Can't Create Salary Of this Month"));
		                         }
		                }
		                else
		                {
		                	//System.out.println("4444");
		                    calculateSalary();
		                    LMLF=dbms.checkNMLFOfLastMonth(tempMonth,tempYear,selectedEmployee);
		                }
		            }
	            }
	        }
            else
            {
               //System.out.println("55555555");
                calculateSalary();
            }
        }
        else
        {
            showDescription=false;
            FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select Different Month To Create Salary Your Date Of Joining Is :"+new SimpleDateFormat("dd-MM-YYYY").format(registrationDate)));
        }
    }



	public void calculateSalary()
	{
		showDescription=true;
		employeeInfo=dbms.employeeInfoByUserName(selectedEmployee);
		leaveAllowed=employeeInfo.getTotalLeave();
		/*dbms.salaryPromotionInMonth(selectedMonth,selectedYear);
		monthName=new DataBaseMethodsHRMModule().monthList(Integer.parseInt(selectedMonth));
		employeeInfo=new DataBaseMethodsHRMModule().employeeInfoByUserName(selectedEmployee);
		
		dbms.calculateSalary(employeeInfo,Integer.parseInt(selectedMonth),Integer.parseInt(selectedYear));*/
		
		
		salInfo=dbms.viewPreparedSalary(selectedEmployee,selectedMonth,selectedYear);
		fullDay=salInfo.getFullDay();
		halfDay=salInfo.getHalfDay();
		leave=salInfo.getLeave();
		holiday=salInfo.getHoliday();
		salaryDay=salInfo.getSalaryDay();
		suddenLeave=salInfo.getSuddenLeave();
		absent=salInfo.getAbsent();
		suddenPenalty=salInfo.getSuddenPenalty();
		suddenLeave=salInfo.getSuddenLeave();
		absentPenalty=salInfo.getAbsentPenalty();
		extraWork=salInfo.getExtraWork();
		relaxation=salInfo.getRelaxation();
		NMLF=salInfo.getNMLF();
		allowance=salInfo.getAllowance();
		tds=salInfo.getTds();
		pf=salInfo.getPf();
		esi=salInfo.getEsi();
		finalSalaryDay=salInfo.getFinalSalaryDay();
		finalSalary=salInfo.getSalary();
		comment=salInfo.getComment();
		lastFinalSalary=(int)(salInfo.getFinalSalary());
	}
	
	public void calculateFinalSalary()
	{
		finalSalary=totalSalaryDay=lastFinalSalary=0;
		grossSalaryDay=finalSalaryDay=salaryday=0;
		//totalSalaryDay=0;relaxation=0;suddenPenalty=0;absentPenalty=0;NMLF=0;extraWork=0;finalSalary=0;
		salaryday=fullDay+halfDay/2 +LMLF+ holiday + leaveAllowed;
		
		//employeeInfo.getSalaryList().setLeaveAllowed(employeeInfo.getTotalLeave());
		//salaryday=employeeInfo.getSalaryList().getSalaryDay();
		//relaxation=employeeInfo.getSalaryList().getRelaxation();
		//suddenPenalty=employeeInfo.getSalaryList().getSuddenPenalty();
		//absentPenalty=employeeInfo.getSalaryList().getAbsentPenalty();
		//NMLF=employeeInfo.getSalaryList().getNMLF();
		//extraWork=employeeInfo.getSalaryList().getExtraWork();
		
		totalSalaryDay=salaryday-suddenPenalty-absentPenalty;
		grossSalaryDay=totalSalaryDay+relaxation+extraWork;
		finalSalaryDay=grossSalaryDay-NMLF;
		
		
		//employeeInfo.getSalaryList().setTotalSalaryDay(totalSalaryDay);
		//employeeInfo.getSalaryList().setGrossSalaryDay(grossSalaryDay);
		//employeeInfo.getSalaryList().setFinalSalaryDay(finalSalaryDay);
		
		finalSalary=finalSalaryDay * employeeInfo.getSalary()/30;
		finalSalary=(double) Math.round(finalSalary * 100) / 100;
		//employeeInfo.getSalaryList().setSalary(finalSalary);
		
		int salaryfinal=(int) ((int)finalSalary+allowance);
		/*int esi=(int) employeeInfo.getSalaryList().getEsi();
		int tds=(int) employeeInfo.getSalaryList().getTds();
		int pf=(int) employeeInfo.getSalaryList().getPf();*/
		lastFinalSalary=(int) (salaryfinal-(esi+tds+pf));
		//employeeInfo.getSalaryList().setFinalSalary((double)(lastFinalSalary));
	}
	
	public void submitSalary()
	{
		detailsToSet();
		
		int i=dbms.updateSalaryTable(employeeInfo);
		if(i>=1)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Salary Calculated Sucessfully."));
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("An Error Occured.... Please Try Again"));
		}
		// System.out.println("hello");
	}
	
	public void detailsToSet()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		int empBranchId = new DataBaseMethods().empBranchIdByEmpId(employeeInfo.getUname(),con);
		
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		salInfo=new SalaryInfo();
		salInfo.setFullDay(fullDay);
		salInfo.setHalfDay(halfDay);
		salInfo.setLeave(leave);
		salInfo.setSuddenLeave(suddenLeave);
		salInfo.setAbsent(absent);
		salInfo.setHoliday(holiday);
		salInfo.setLMLF(LMLF);
		salInfo.setSuddenPenalty(suddenPenalty);
		salInfo.setAbsentPenalty(absentPenalty);
		salInfo.setNMLF(NMLF);
		salInfo.setRelaxation(relaxation);
		salInfo.setExtraWork(extraWork);
		salInfo.setFinalSalaryDay(finalSalaryDay);
		salInfo.setFinalSalary(lastFinalSalary);
		salInfo.setComment(comment);
		salInfo.setAllowance(allowance);
		salInfo.setSalary(finalSalary);
		salInfo.setP_f(0);
		salInfo.setLeaveAllowed(leaveAllowed);
		salInfo.setEsi(esi);
		salInfo.setTds(tds);
		salInfo.setPf(pf);
		salInfo.setMonth(Integer.valueOf(selectedMonth));
		salInfo.setYear(Integer.valueOf(selectedYear));
		salInfo.setEmpBranchId(String.valueOf(empBranchId));
		employeeInfo.setSalaryList(salInfo);
		
		
	}
	
	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 getMonthName() {
		return monthName;
	}
	public void setMonthName(String monthName) {
		this.monthName = monthName;
	}
	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 String getSelectedEmployee() {
		return selectedEmployee;
	}
	public void setSelectedEmployee(String selectedEmployee) {
		this.selectedEmployee = selectedEmployee;
	}
	public EmployeeInfo getEmployeeInfo() {
		return employeeInfo;
	}
	public void setEmployeeInfo(EmployeeInfo employeeInfo) {
		this.employeeInfo = employeeInfo;
	}
	public ArrayList<SelectItem> getEmployeeList() {
		return employeeList;
	}
	public void setEmployeeList(ArrayList<SelectItem> employeeList) {
		this.employeeList = employeeList;
	}
	public boolean isShowDescription() {
		return showDescription;
	}
	public void setShowDescription(boolean showDescription) {
		this.showDescription = showDescription;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public double getFullDay() {
		return fullDay;
	}

	public void setFullDay(double fullDay) {
		this.fullDay = fullDay;
	}

	public double getHalfDay() {
		return halfDay;
	}

	public void setHalfDay(double halfDay) {
		this.halfDay = halfDay;
	}

	public double getLeave() {
		return leave;
	}

	public void setLeave(double leave) {
		this.leave = leave;
	}

	public double getAbsent() {
		return absent;
	}

	public void setAbsent(double absent) {
		this.absent = absent;
	}

	public double getHoliday() {
		return holiday;
	}

	public void setHoliday(double holiday) {
		this.holiday = holiday;
	}

	public double getSuddenLeave() {
		return suddenLeave;
	}

	public void setSuddenLeave(double suddenLeave) {
		this.suddenLeave = suddenLeave;
	}

	public double getLeaveAllowed() {
		return leaveAllowed;
	}

	public void setLeaveAllowed(double leaveAllowed) {
		this.leaveAllowed = leaveAllowed;
	}

	public double getLMLF() {
		return LMLF;
	}

	public void setLMLF(double lMLF) {
		LMLF = lMLF;
	}

	public double getNMLF() {
		return NMLF;
	}

	public void setNMLF(double nMLF) {
		NMLF = nMLF;
	}

	public double getRelaxation() {
		return relaxation;
	}

	public void setRelaxation(double relaxation) {
		this.relaxation = relaxation;
	}

	public double getTotalSalaryDay() {
		return totalSalaryDay;
	}

	public void setTotalSalaryDay(double totalSalaryDay) {
		this.totalSalaryDay = totalSalaryDay;
	}

	public double getFinalSalary() {
		return finalSalary;
	}

	public void setFinalSalary(double finalSalary) {
		this.finalSalary = finalSalary;
	}

	public double getSalary() {
		return salary;
	}

	public void setSalary(double salary) {
		this.salary = salary;
	}

	public double getSuddenPenalty() {
		return suddenPenalty;
	}

	public void setSuddenPenalty(double suddenPenalty) {
		this.suddenPenalty = suddenPenalty;
	}

	public double getAbsentPenalty() {
		return absentPenalty;
	}

	public void setAbsentPenalty(double absentPenalty) {
		this.absentPenalty = absentPenalty;
	}

	public double getExtraWork() {
		return extraWork;
	}

	public void setExtraWork(double extraWork) {
		this.extraWork = extraWork;
	}

	public double getAllowance() {
		return allowance;
	}

	public void setAllowance(double allowance) {
		this.allowance = allowance;
	}

	public double getP_f() {
		return p_f;
	}

	public void setP_f(double p_f) {
		this.p_f = p_f;
	}

	public double getSalaryDay() {
		return salaryDay;
	}

	public void setSalaryDay(double salaryDay) {
		this.salaryDay = salaryDay;
	}

	public double getEsi() {
		return esi;
	}

	public void setEsi(double esi) {
		this.esi = esi;
	}

	public double getTds() {
		return tds;
	}

	public void setTds(double tds) {
		this.tds = tds;
	}

	public double getPf() {
		return pf;
	}

	public void setPf(double pf) {
		this.pf = pf;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getAccountNo() {
		return accountNo;
	}

	public void setAccountNo(String accountNo) {
		this.accountNo = accountNo;
	}

	public String getBranch() {
		return branch;
	}

	public void setBranch(String branch) {
		this.branch = branch;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getSalaryStatus() {
		return salaryStatus;
	}

	public void setSalaryStatus(String salaryStatus) {
		this.salaryStatus = salaryStatus;
	}

	public String getComment() {
		return comment;
	}

	public void setComment(String comment) {
		this.comment = comment;
	}

	public int getMonthDay() {
		return monthDay;
	}

	public void setMonthDay(int monthDay) {
		this.monthDay = monthDay;
	}

	public int getMonth() {
		return month;
	}

	public void setMonth(int month) {
		this.month = month;
	}

	public int getYear() {
		return year;
	}

	public void setYear(int year) {
		this.year = year;
	}

	public int getLastFinalSalary() {
		return lastFinalSalary;
	}

	public void setLastFinalSalary(int lastFinalSalary) {
		this.lastFinalSalary = lastFinalSalary;
	}

	public double getSalaryday() {
		return salaryday;
	}

	public void setSalaryday(double salaryday) {
		this.salaryday = salaryday;
	}

	public double getGrossSalaryDay() {
		return grossSalaryDay;
	}

	public void setGrossSalaryDay(double grossSalaryDay) {
		this.grossSalaryDay = grossSalaryDay;
	}

	public double getFinalSalaryDay() {
		return finalSalaryDay;
	}

	public void setFinalSalaryDay(double finalSalaryDay) {
		this.finalSalaryDay = finalSalaryDay;
	}
	
}
