/*
    Copyright (C) 2004
   
    This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
   
    This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
   
    You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
    
   Written by St�phane Gauchet
   mail me at : sgauchet@free.fr
   */
  package fr.hyphonem.conges;
  
  import java.awt.Color;
  import java.text.DecimalFormat;
  import java.text.ParseException;
  import java.text.SimpleDateFormat;
  import java.util.ArrayList;
  import java.util.Calendar;
  import java.util.Date;
  import java.util.Enumeration;
  import java.util.Hashtable;
  import java.util.Iterator;
  import java.util.List;
  import java.util.Properties;
  import java.util.Vector;
  
  import javax.mail.Message;
  import javax.mail.Session;
  import javax.mail.Transport;
  import javax.mail.internet.InternetAddress;
  import javax.mail.internet.MimeMessage;
  import javax.servlet.ServletException;
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpSession;
  
  import org.jfree.chart.ChartFactory;
  import org.jfree.chart.JFreeChart;
  import org.jfree.chart.plot.CategoryPlot;
  import org.jfree.chart.renderer.GanttRenderer;
  import org.jfree.data.IntervalCategoryDataset;
  import org.jfree.data.gantt.Task;
  import org.jfree.data.gantt.TaskSeries;
  import org.jfree.data.gantt.TaskSeriesCollection;
  
  import fr.hyphonem.conges.data.CalendarData;
  import fr.hyphonem.conges.data.EmployeeData;
  import fr.hyphonem.conges.data.EmployeeIdCalData;
  import fr.hyphonem.conges.data.GetMaxDaysReturnBean;
  import fr.hyphonem.conges.data.NationalDayData;
  import fr.hyphonem.conges.data.ParamsData;
  import fr.hyphonem.conges.data.PendingEventData;
  import fr.hyphonem.conges.data.PeriodParamsData;
  import fr.hyphonem.conges.data.StatsData;
  import fr.hyphonem.conges.data.UserData;
  import fr.hyphonem.conges.resources.Messages;
  
  /*
   * Copyright (C) 2004-... Stephane Gauchet for Hyphonem
   * 
   * This program is free software; you can redistribute it and/or modify it under
   * the terms of the GNU General Public License as published by the Free Software
   * Foundation; either version 2 of the License, or (at your option) any later
   * version.
   * 
   * This program is distributed in the hope that it will be useful, but WITHOUT
   * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
   * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
   * details.
   * 
   * You should have received a copy of the GNU General Public License along with
   * this program; if not, write to the Free Software Foundation, Inc., 59 Temple
   * Place, Suite 330, Boston, MA 02111-1307 USA
   * 
   * Written by Stephane Gauchet mail me at : sgauchet@free.fr
   */
  /**
   * @author Stephane Gauchet pour Hyphonem
   * 
   * common class for useful stuff
   */
  
  public class CommonCal {
  
  	/**
  	 * Constructor for CommonCal.
  	 */
  	public CommonCal() {
  		super();
  	}
  
  	/**
  	 * retourne le nombre de jours dans le mois de la date pass�e en param�tre
  	 * <br/> return nb of days in the month of the date passed in parameter
  	 * 
  	 * @param date -
  	 *            Calendar
  	 * @return int
 	 */
 	private int getMaxJoursInMonth(Calendar date) {
 		return date.getActualMaximum(Calendar.DAY_OF_MONTH);
 	}
 
 	/**
 	 * retourne le nombre de jours dans les mois suivants la date pass�e en
 	 * param�tre <br/> return nb of days in the nth next months following the
 	 * date in parameter
 	 * 
 	 * @param date
 	 * @param nMonthsForward
 	 * @return bean GetMaxDaysReturnBean
 	 */
 	public GetMaxDaysReturnBean getMaxJoursForNMonthsForwardDate(Calendar date,
 			int nMonthsForward) {
 		GetMaxDaysReturnBean bean = new GetMaxDaysReturnBean();
 		Hashtable ht = new Hashtable(nMonthsForward);
 
 		// les nMonthsForward mois superieurs y compris le mois en cours
 		for (int i = 0; i < nMonthsForward; i++) {
 			Calendar date2 = calculateNthMonth(date, i);
 			SimpleDateFormat sdf = new SimpleDateFormat("MMMMM");
 			String nomMois = sdf.format(date2.getTime());
 			int year = date2.get(Calendar.YEAR);
 			int month = date2.get(Calendar.MONTH) + 1;
 			int daysInMonth = getMaxJoursInMonth(date2);
 
 			// remise � z�ro � la date initiale
 			date = calculateNthMonth(date2, -i);
 			ht.put("" + i, nomMois + "#" + month + " " + year + "|"
 					+ daysInMonth);
 
 			if (i == 0) {
 				bean.setDebper("01/" + month + "/" + year);
 			}
 			if (i == nMonthsForward - 1) {
 				bean.setFinper("" + daysInMonth + "/" + month + "/" + year);
 			}
 		}
 
 		bean.setHt(ht);
 		return bean;
 	}
 
 	/**
 	 * calcule la date en ajoutant ou enlevant n mois � la date pass�e en
 	 * param�tre return date calculated by add or remove nth month to the date
 	 * passec in parameter
 	 * 
 	 * @param date
 	 * @param numMonth
 	 * @return Calendar
 	 */
 	private Calendar calculateNthMonth(Calendar date, int numMonth) {
 		date.add(Calendar.MONTH, numMonth);
 		return date;
 	}
 
 	/**
 	 * do a list of calendarData with only one day in it and no fery days or
 	 * weekend days
 	 * 
 	 * @param vCalendarData
 	 * @param employee
 	 * @param hJF :
 	 *            hashtable des jours feries
 	 * @return Vector
 	 * @throws Exception
 	 */
 	public Vector getDiscretCalData(Vector vCalendarData,
 			EmployeeData employee, Hashtable hJF) throws Exception {
 		Vector lstCalData = new Vector();
 
 		// vCalendarData a des CalendarData contenant une periode
 		// on va creer des CalendarData ne contenant qu'un jour
 		// et on enleve les Samedi et les Dimanche
 		// et les jours feries
 
 		for (Enumeration e = vCalendarData.elements(); e.hasMoreElements();) {
 			CalendarData cd = (CalendarData) e.nextElement();
 			String ddeb = cd.getDatedeb();
 			String dfin = cd.getDatefin();
 			String raison = cd.getRaison();
 			boolean cbmatin = cd.isCbmatin();
 			boolean cbaprem = cd.isCbaprem();
 			int id = new Integer(cd.getId()).intValue();
 
 			if (ddeb != null && dfin != null && raison != null) {
 				try {
 					Date datedeb = new SimpleDateFormat("dd/MM/yyyy")
 							.parse(ddeb);
 					Date datefin = new SimpleDateFormat("dd/MM/yyyy")
 							.parse(dfin);
 
 					if (datedeb.compareTo(datefin) == 0) {
 						CalendarData cda = checkDateForCalendarData(datedeb,
 								cbmatin, cbaprem, raison, employee, "" + id,
 								hJF);
 						if (cda != null) {
 							lstCalData.add(cda);
 						// lstCalData.add(cd);
 						}
 					} else if (datedeb.compareTo(datefin) < 0) {
 						Date date = datedeb;
 						while (date.compareTo(datefin) <= 0) {
 							CalendarData cda = checkDateForCalendarData(date,
 									cbmatin, cbaprem, raison, employee,
 									"" + id, hJF);
 							if (cda != null) {
 								lstCalData.add(cda);
 							}
 							Calendar cal = Calendar.getInstance();
 							cal.setTime(date);
 							cal.add(Calendar.DATE, 1);
 							date = cal.getTime();
 							id += 1;
 						}
 						Calendar.getInstance().clear();
 					} else {
 						throw new Exception("erreur DateDeb " + ddeb
 								+ " > DateFin " + dfin);
 					}
 				} catch (ParseException ex) {
 					throw new Exception(ex.getLocalizedMessage());
 				}
 			}
 		}
 		return lstCalData;
 	}
 
 	/**
 	 * suppress non working day (weekend days and fery days) in the calendarData
 	 * 
 	 * @param date -
 	 *            Date
 	 * @param cbmatin -
 	 *            boolean
 	 * @param cbaprem -
 	 *            boolean
 	 * @param raison
 	 * @param employee -
 	 *            EmployeeDataCal
 	 * @param id
 	 * @param hJF
 	 * @return CalendarData
 	 * @throws ParseException
 	 */
 	private CalendarData checkDateForCalendarData(Date date, boolean cbmatin,
 			boolean cbaprem, String raison, EmployeeData employee, String id,
 			Hashtable hJF) throws ParseException {
 		Calendar cal = Calendar.getInstance();
 		cal.setTime(date);
 		CalendarData cdr = new CalendarData();
 		boolean isAWorkedDay = true;
 
 		List dayoffs = new ArrayList();
 		if (employee.isDayoff1()) {
 			dayoffs.add("" + Calendar.MONDAY);
 		}
 		if (employee.isDayoff2()) {
 			dayoffs.add("" + Calendar.TUESDAY);
 		}
 		if (employee.isDayoff3()) {
 			dayoffs.add("" + Calendar.WEDNESDAY);
 		}
 		if (employee.isDayoff4()) {
 			dayoffs.add("" + Calendar.THURSDAY);
 		}
 		if (employee.isDayoff5()) {
 			dayoffs.add("" + Calendar.FRIDAY);
 		}
 		if (employee.isDayoff6()) {
 			dayoffs.add("" + Calendar.SATURDAY);
 		}
 		if (employee.isDayoff7()) {
 			dayoffs.add("" + Calendar.SUNDAY);
 		}
 
 		// on teste si c un jour de repos / dayoff
 		for (Iterator iter = dayoffs.iterator(); iter.hasNext();) {
 			int day = Integer.parseInt((String) iter.next());
 			if (cal.get(Calendar.DAY_OF_WEEK) == day) {
 				// on ne met pas cette date dans notre nouvelle liste
 				isAWorkedDay = false;
 				break;
 			}
 		}
 
 		if (isAWorkedDay) {
 			// on teste si c un jour ferie
 			// liste des jours feries
 
 			String annee = "" + cal.get(Calendar.YEAR);
 			if (hJF.containsKey(annee)) {
 				Vector vDays = (Vector) hJF.get(annee);
 				Iterator iter = vDays.iterator();
 				String sdate = new java.text.SimpleDateFormat("dd/MM/yyyy")
 						.format(date);
 				while (iter.hasNext()) {
 					NationalDayData ndd = (NationalDayData) iter.next();
 					if (ndd.getDate().equals(sdate)) {
 						isAWorkedDay = false;
 						break;
 					}
 				}
 			}
 
 		}
 
 		if (isAWorkedDay) {
 			String datedf = new SimpleDateFormat("dd/MM/yyyy").format(date);
 			cdr.setDatedeb(datedf);
 			cdr.setDatefin(datedf);
 			cdr.setCbmatin(cbmatin);
 			cdr.setCbaprem(cbaprem);
 			cdr.setRaison(raison);
 			cdr.setEmployee(employee);
 			cdr.setId(id);
 		} else {
 			cdr = null;
 		}
 
 		return cdr;
 	}
 
 	/**
 	 * create a Gantt diagram
 	 * 
 	 * @param dataPlanning
 	 * @return JFreeChart
 	 * @throws ParseException,
 	 *             NoClassDefFoundError, InternalError
 	 * @throws NoClassDefFoundError
 	 * @throws InternalError
 	 */
 	public JFreeChart createGantt(Hashtable dataPlanning)
 			throws ParseException, NoClassDefFoundError, InternalError {
 
 		IntervalCategoryDataset dataset = createDataset(dataPlanning);
 		JFreeChart chart = createChart(dataset);
 		return chart;
 	}
 
 	/**
 	 * @param data
 	 * @return IntervalCategoryDataset
 	 * @throws ParseException
 	 */
 	public IntervalCategoryDataset createDataset(Hashtable data)
 			throws ParseException {
 
 		final TaskSeries s1 = new TaskSeries("Conges");
 		for (Enumeration edata = data.keys(); edata.hasMoreElements();) {
 			String nom = (String) edata.nextElement();
 			Vector list = (Vector) data.get(nom);
 			Date firstDate = new Date();
 			Date lastDate = new Date();
 			for (Enumeration enlist = list.elements(); enlist.hasMoreElements();) {
 				CalendarData cd = (CalendarData) enlist.nextElement();
 
 				String db = cd.getDatedeb();
 				String df = cd.getDatefin();
 				Date ddb = new SimpleDateFormat("dd/MM/yyyy").parse(db);
 				Date ddf = new SimpleDateFormat("dd/MM/yyyy").parse(df);
 				Calendar cal = Calendar.getInstance();
 				cal.setTime(ddf);
 				cal.add(Calendar.DATE, 1);
 				ddf = cal.getTime();
 
 				if (ddb.compareTo(firstDate) < 0) {
 					firstDate = ddb;
 				}
 				if (ddf.compareTo(lastDate) > 0) {
 					lastDate = ddf;
 				}
 			}
 			Task task = new Task(nom, firstDate, lastDate);
 			task.setPercentComplete(1.0);
 
 			for (Enumeration enlist = list.elements(); enlist.hasMoreElements();) {
 				CalendarData cd = (CalendarData) enlist.nextElement();
 				String raison = cd.getRaison();
 				String db = cd.getDatedeb();
 				String df = cd.getDatefin();
 				Date ddb = new SimpleDateFormat("dd/MM/yyyy").parse(db);
 				Date ddf = new SimpleDateFormat("dd/MM/yyyy").parse(df);
 
 				Calendar cal = Calendar.getInstance();
 				cal.setTime(ddf);
 				cal.add(Calendar.DATE, 1);
 				ddf = cal.getTime();
 
 				if (ddb.compareTo(firstDate) < 0) {
 					firstDate = ddb;
 				}
 				if (ddf.compareTo(lastDate) > 0) {
 					lastDate = ddf;
 				}
 				Task subtask = new Task(raison, ddb, ddf);
 				subtask.setPercentComplete(1.0);
 				task.addSubtask(subtask);
 			}
 
 			s1.add(task);
 
 		}
 
 		TaskSeriesCollection collection = new TaskSeriesCollection();
 		collection.add(s1);
 
 		return collection;
 	}
 
 	private JFreeChart createChart(IntervalCategoryDataset dataset)
 			throws NoClassDefFoundError, InternalError {
 		JFreeChart chart = ChartFactory.createGanttChart("Planning", // chart
 				// title
 				"Employé(e)s", // domain axis label
 				"Date", // range axis label
 				dataset, // data
 				false, // include legend
 				false, // tooltips
 				false // urls
 				);
 		// chart.getCategoryPlot().getDomainAxis().setMaxCategoryLabelWidthRatio(10.0f);
 		CategoryPlot plot = (CategoryPlot) chart.getPlot();
 
 		plot.getDomainAxis().setMaxCategoryLabelWidthRatio(1000.0f);
 		plot.getRangeAxis().setAutoRange(true);
 		GanttRenderer renderer = (GanttRenderer) plot.getRenderer();
 
 		renderer.setCompletePaint(Color.blue);
 		renderer.setIncompletePaint(Color.blue);
 		renderer.setSeriesPaint(0, Color.blue);
 
 		return chart;
 	}
 
 	/**
 	 * 
 	 * @param ped
 	 * @param employee
 	 * @param request
 	 * @param httpSession
 	 * @param ad
 	 * @param type
 	 */
 	public void sendEmail(PendingEventData ped, EmployeeData employee,
 			HttpServletRequest request, HttpSession httpSession, AccessData ad,
 			int type) throws Exception {
 		// on envoie un mail contenant les donn�es de l'absence et le demandeur
 		// au responsable hi�rarchique
 		// Get system properties
 
 		if (httpSession.getServletContext().getAttribute("server") != null
 				&& !httpSession.getServletContext().getAttribute("server")
 						.toString().equals("")) {
 
 			String server = (String) httpSession.getServletContext()
 					.getAttribute("server");
 
 			// comme adresse email d'envoi on prend l'email de l'admin
 			UserData adminData = ad.searchUser("ADMIN");
 			String from = adminData.getEmail();
 			// le (ou les) superieur hierarchique est averti de la demande
 			Vector supervisors = ad.searchSupervisor(employee, ad);
 			String toSupervisor = "";
 			if (supervisors != null && supervisors.size() > 1) {
 				Iterator iter = supervisors.iterator();
 				// on verifie si l'employ� est le chef d'�quipe
 				while (iter.hasNext()) {
 					UserData supervisor = (UserData) iter.next();
 					if (supervisor.getNom().equals(employee.getNom())
 							&& supervisor.getPrenom().equals(
 									employee.getPrenom())) {
 						toSupervisor = supervisor.getEmail();
 						break;
 					}
 				}
 
 				if (toSupervisor.equals("")) {
 					// si l'employ� n'est pas le chef d equipe alors on cherche
 					// ce dernier
 					iter = supervisors.iterator();
 					while (iter.hasNext()) {
 						UserData supervisor = (UserData) iter.next();
 						if (supervisor.getTeam().equals(employee.getTeam())) {
 							toSupervisor = supervisor.getEmail();
 							break;
 						}
 					}
 				}
 			} else if (supervisors == null || supervisors.size() == 0) {
 				toSupervisor = "";
 			} else {
 				toSupervisor = ((UserData) supervisors.get(0)).getEmail();
 			}
 
 			if (!toSupervisor.equals("")) {
 				Properties props = System.getProperties();
 
 				// Setup mail server
 				props.put("mail.smtp.host", server);
 
 				// Get session
 				Session session = Session.getDefaultInstance(props, null);
 
 				// Define message
 				MimeMessage message = new MimeMessage(session);
 				message.setFrom(new InternetAddress(from));
 				message.addRecipient(Message.RecipientType.TO,
 						new InternetAddress(toSupervisor));
 
 				message.setSubject(Messages.getString("mail.subject.1"));
 				String text = "";
 				text += Messages.getString("mail.text.event.0")
 						+ ped.getRaison();
 				String mode = "";
 				if (type == 0) {
 					mode = Messages.getString("validating.C");
 				}
 				if (type == 1) {
 					mode = Messages.getString("validating.M");
 				}
 				if (type == 2) {
 					mode = Messages.getString("validating.D");
 				}
 				text += Messages.getString("mail.text.event.1") + " " + mode;
 				text += " " + Messages.getString("mail.text.event.2") + " "
 						+ ped.getPrenom() + " " + ped.getNom();
 				text += " " + Messages.getString("mail.text.event.datedeb")
 						+ " " + ped.getDatedeb();
 				text += " " + Messages.getString("mail.text.event.datefin")
 						+ " " + ped.getDatefin() + ".\n";
 				text += Messages.getString("mail.text.event.confirm")
 						+ " http://" + request.getServerName() + ":"
 						+ request.getServerPort() + request.getContextPath();
 				System.out.println("text email=" + text);
 
 				message.setText(text);
 
 				// Send message
 				Transport.send(message);
 			}
 
 		} else {
 			throw new Exception(Messages.getString("error.no.mail.server"));
 		}
 	}
 
 	/**
 	 * @param ped
 	 * @param eid
 	 * @param request
 	 * @param httpSession
 	 * @param ad
 	 * @param type
 	 */
 	public void sendEmailValidation(PendingEventData ped,
 			EmployeeIdCalData eid, HttpServletRequest request,
 			HttpSession httpSession, AccessData ad, int type) throws Exception {
 		// on envoie un mail contenant la reponse du responsable hi�rarchique
 		// sur les donn�es de l'absence au le demandeur
 
 		if (httpSession.getServletContext().getAttribute("server") != null
 				&& !httpSession.getServletContext().getAttribute("server")
 						.toString().equals("")) {
 
 			String server = (String) httpSession.getServletContext()
 					.getAttribute("server");
 
 			// comme adresse email d'envoi on prend l'email de l'admin
 			UserData adminData = ad.searchUser("ADMIN");
 			String from = adminData.getEmail();
 
 			// l employee est le destinataire
 			String toEmployee = "";
 			EmployeeData employee = new EmployeeData();
 			employee.setNom(eid.getNom());
 			employee.setPrenom(eid.getPrenom());
 			UserData user = ad.searchUser(employee);
 			toEmployee = user.getEmail();
 			if (!toEmployee.equals("")) {
 				Properties props = System.getProperties();
 
 				// Setup mail server
 				props.put("mail.smtp.host", server);
 
 				// Get session
 				Session session = Session.getDefaultInstance(props, null);
 
 				// Define message
 				MimeMessage message = new MimeMessage(session);
 				message.setFrom(new InternetAddress(from));
 				message.addRecipient(Message.RecipientType.TO,
 						new InternetAddress(toEmployee));
 				if (type == 0) {
 					message.setSubject(Messages
 							.getString("mail.subject.accept"));
 				}
 				if (type == 1) {
 					message.setSubject(Messages
 							.getString("mail.subject.refuse"));
 				}
 				String text = "";
 				text += Messages.getString("mail.text.event.10")
 						+ ped.getRaison();
 				text += Messages.getString("mail.text.event.12");
 				text += " " + Messages.getString("mail.text.event.datedeb")
 						+ " " + ped.getDatedeb();
 				text += " " + Messages.getString("mail.text.event.datefin")
 						+ " " + ped.getDatefin();
 				if (type == 0) {
 					text += " " + Messages.getString("mail.text.event.accept");
 				}
 				if (type == 1) {
 					text += " " + Messages.getString("mail.text.event.refuse");
 				}
 				text += "\nhttp://" + request.getServerName() + ":"
 						+ request.getServerPort() + request.getContextPath();
 				System.out.println("text email=" + text);
 
 				message.setText(text);
 
 				// Send message
 				Transport.send(message);
 			}
 
 		} else {
 			throw new Exception(Messages.getString("error.no.mail.server"));
 		}
 	}
 
 	/**
 	 * 
 	 * @param params
 	 * @param reason
 	 * @param employee
 	 * @param fromDate
 	 * @param toDate
 	 * @return maxNBJours
 	 * @throws Exception
 	 */
 	public String getMaxNbDaysForReasonInParams(Vector params, String reason,
 			EmployeeData employee, String fromDate, String toDate)
 			throws Exception {
 		// on cherche le nb max de jours autorises
 		String maxNbJours = "0";
 		Iterator iter = params.iterator();
 		String type = "progressif";
 		while (iter.hasNext()) {
 			ParamsData param = (ParamsData) iter.next();
 			String praison = param.getReason();
 
 			if (praison.equals(reason)) {
 				maxNbJours = param.getNbJours();
 				type = param.getType();
 				break;
 			}
 		}
 
 		// on verifie si le nombre max de jours ne doit pas etre restreint en
 		// fonction de la date d'entr�e de l'employ�(e)
 		String entryDate = employee.getEntryDate();
 		if (entryDate != null && !entryDate.equals("")) {
 			SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
 			Date entryDate_d = sdf.parse(entryDate);
 			Date fromDate_d = sdf.parse(fromDate);
 			Date toDate_d = sdf.parse(toDate);
 
 			if (type.equals("revolu")) {
 				Calendar cal = Calendar.getInstance();
 				cal.setTime(fromDate_d);
 				cal.add(Calendar.YEAR, -1);
 				fromDate_d = cal.getTime();
 				cal.setTime(toDate_d);
 				cal.add(Calendar.YEAR, -1);
 				toDate_d = cal.getTime();
 			}
 
 			if (entryDate_d.after(toDate_d)) {
 				maxNbJours = "0";
 			} else if (entryDate_d.after(fromDate_d)
 					&& entryDate_d.before(toDate_d)) {
 				long difference = entryDate_d.getTime() - fromDate_d.getTime();
 				long msPerDay = 24 * 60 * 60 * 1000;
 				long days = difference / msPerDay;
 				// System.out.println("nb jours de difference " + days);
 				// days = Math.round(days);
 
 				float restdaysPerDay = new Float(maxNbJours).floatValue()
 						/ (12 * 30);
 				// System.out.println("restdaysPerDays " +restdaysPerDay);
 				float decreasingDays = days * restdaysPerDay;
 				// System.out.println("decreasingDays " + decreasingDays);
 
 				float maxNbDays_f = new Float(maxNbJours).floatValue()
 						- decreasingDays;
 				// System.out.println("maxNbDays_f " + maxNbDays_f);
 				DecimalFormat df = (DecimalFormat) DecimalFormat.getInstance();
 				// keep only two decimal
 				df.setMaximumFractionDigits(2);
 				maxNbJours = df.format(maxNbDays_f);
 			}
 		}
 
 		return maxNbJours;
 	}
 
 	/**
 	 * retourne la p�riode de calcul des cong�s � partir de la date du jour
 	 * 
 	 * @param params -
 	 *            Vector des param�tres de cong�s
 	 * @return PeriodParamsData
 	 * @throws Exception
 	 */
 	public PeriodParamsData searchPeriodInParams(Vector params)
 			throws Exception {
 		Date fromDate = new Date();
 		Date endDate = new Date();
 
 		for (Enumeration enumr = params.elements(); enumr.hasMoreElements();) {
 			ParamsData param = (ParamsData) enumr.nextElement();
 			String datedeb = param.getDateDebut();
 			if (datedeb != null && !datedeb.equals("")) {
 				String datefin = param.getDateFin();
 
 				Date dateDeb = new Date();
 				Date dateFin = new Date();
 
 				// format attendu jj/mm
 				int idx = datedeb.indexOf("/");
 				if (idx > -1 && idx < datedeb.length()) {
 					String jjdeb = datedeb.substring(0, idx);
 					String mmdeb = datedeb.substring(idx + 1);
 					String jjfin = datefin.substring(0, idx);
 					String mmfin = datefin.substring(idx + 1);
 
 					int debMonth = new Integer(mmdeb).intValue();
 					int finMonth = new Integer(mmfin).intValue();
 					int debDay = new Integer(jjdeb).intValue();
 					int finDay = new Integer(jjfin).intValue();
 
 					Calendar cal = Calendar.getInstance();
 
 					int currentMonth = cal.get(Calendar.MONTH) + 1;
 
 					if (currentMonth >= debMonth) {
 						// on est dans la meme annee
 						int year = cal.get(Calendar.YEAR);
 						cal.set(year, debMonth - 1, debDay);
 						dateDeb = cal.getTime();
 						cal = Calendar.getInstance();
 					}
 					if (currentMonth < debMonth) {
 						// on est dans l'annee + 1
 						int year = cal.get(Calendar.YEAR) - 1;
 						cal.set(year, debMonth - 1, debDay);
 						dateDeb = cal.getTime();
 						cal = Calendar.getInstance();
 					}
 					if (currentMonth > finMonth) {
 						// on est dans l'annee - 1
 						int year = cal.get(Calendar.YEAR) + 1;
 						cal.set(year, finMonth - 1, finDay);
 						dateFin = cal.getTime();
 						cal = Calendar.getInstance();
 					}
 					if (currentMonth <= finMonth) {
 						// on est dans la meme annee
 						int year = cal.get(Calendar.YEAR);
 						cal.set(year, finMonth - 1, finDay);
 						dateFin = cal.getTime();
 						cal = Calendar.getInstance();
 					}
 
 					if (dateDeb.compareTo(fromDate) < 0) {
 						fromDate = dateDeb;
 					}
 					if (dateFin.compareTo(endDate) > 0) {
 						endDate = dateFin;
 					}
 				}
 			}
 		}
 
 		PeriodParamsData ppd = new PeriodParamsData();
 		ppd.setFromDate(fromDate);
 		ppd.setEndDate(endDate);
 
 		return ppd;
 	}
 
 	/**
 	 * 
 	 * @param params
 	 * @param raison
 	 * @return PeriodParamsData
 	 * @throws Exception
 	 */
 	public PeriodParamsData searchPeriodInParamsForReason(Vector params,
 			String raison) throws Exception {
 		Date debut = new Date();
 		Date fin = new Date();
 
 		for (Enumeration enumeration = params.elements(); enumeration
 				.hasMoreElements();) {
 			ParamsData param = (ParamsData) enumeration.nextElement();
 			String praison = param.getReason();
 
 			if (praison.equals(raison)) {
 				String datedeb = param.getDateDebut();
 				if (datedeb != null && !datedeb.equals("")) {
 					String datefin = param.getDateFin();
 
 					// format attendu jj/mm
 					int idx = datedeb.indexOf("/");
 					if (idx > -1 && idx < datedeb.length()) {
 						String jjdeb = datedeb.substring(0, idx);
 						String mmdeb = datedeb.substring(idx + 1);
 						String jjfin = datefin.substring(0, idx);
 						String mmfin = datefin.substring(idx + 1);
 
 						int debMonth = new Integer(mmdeb).intValue();
 						int finMonth = new Integer(mmfin).intValue();
 						int debDay = new Integer(jjdeb).intValue();
 						int finDay = new Integer(jjfin).intValue();
 
 						Calendar cal = Calendar.getInstance();
 
 						int currentMonth = cal.get(Calendar.MONTH) + 1;
 						if (currentMonth >= debMonth) {
 							// on est dans la meme annee
 							int year = cal.get(Calendar.YEAR);
 							cal.set(year, debMonth - 1, debDay);
 							debut = cal.getTime();
 							cal = Calendar.getInstance();
 						}
 						if (currentMonth < debMonth) {
 							// on est dans l'annee + 1
 							int year = cal.get(Calendar.YEAR) - 1;
 							cal.set(year, debMonth - 1, debDay);
 							debut = cal.getTime();
 							cal = Calendar.getInstance();
 						}
 						if (currentMonth > finMonth) {
 							// on est dans l'annee - 1
 							int year = cal.get(Calendar.YEAR) + 1;
 							cal.set(year, finMonth - 1, finDay);
 							fin = cal.getTime();
 							cal = Calendar.getInstance();
 						}
 						if (currentMonth <= finMonth) {
 							// on est dans la meme annee
 							int year = cal.get(Calendar.YEAR);
 							cal.set(year, finMonth - 1, finDay);
 							fin = cal.getTime();
 							cal = Calendar.getInstance();
 						}
 					}
 				}
 			}
 		}
 
 		PeriodParamsData ppd = new PeriodParamsData();
 		ppd.setFromDate(debut);
 		ppd.setEndDate(fin);
 
 		return ppd;
 	}
 
 	/**
 	 * 
 	 * @param fileDirPath
 	 * @param employee
 	 * @param params
 	 * @return Vector
 	 * @throws Exception
 	 */
 	public Vector getEmployeeStats(String fileDirPath, EmployeeData employee,
 			Vector params) throws Exception {
 		Vector stats = new Vector();
 
 		PeriodParamsData ppd = searchPeriodInParams(params);
 
 		Date fromDate = ppd.getFromDate();
 		Date endDate = ppd.getEndDate();
 
 		String debDate = new SimpleDateFormat("dd/MM/yyyy").format(fromDate);
 		String finDate = new SimpleDateFormat("dd/MM/yyyy").format(endDate);
 
 		AccessData ad = new AccessDataMng().getInstance(employee, fileDirPath,
 				debDate, finDate);
 
 		Vector vCalendarData = new Vector();
 		try {
 			vCalendarData = ad.readCalendarData(employee);
 		} catch (Exception e) {
 			throw new ServletException(e.getMessage());
 		}
 		// System.out.println(vCalendarData.toString());
 		// � pr�sent on cr�� des calendarData ne contenant qu'une seule journ�e
 		// i.e. on discretise les CalendarData pr�c�demment obtenus
 		// CommonCal commonCal = new CommonCal();
 
 		Vector lstCalendarData = getDiscretCalData(vCalendarData, employee,
 				new Hashtable());
 
 		for (Enumeration enumr = lstCalendarData.elements(); enumr
 				.hasMoreElements();) {
 			CalendarData cd = (CalendarData) enumr.nextElement();
 			String raison = cd.getRaison();
 
 			// dans params il y a la periode en fonction de la raison
 			ppd = searchPeriodInParamsForReason(params, raison);
 			Date debut = ppd.getFromDate();
 			Date fin = ppd.getEndDate();
 
 			Date cddeb = new SimpleDateFormat("dd/MM/yyyy").parse(cd
 					.getDatedeb());
 			Date cdfin = new SimpleDateFormat("dd/MM/yyyy").parse(cd
 					.getDatefin());
 
 			if (cddeb.compareTo(debut) >= 0 && cddeb.compareTo(fin) <= 0
 					&& cdfin.compareTo(debut) >= 0 && cdfin.compareTo(fin) <= 0) {
 				double nombreJours = 0;
 				double jourAjout = 0;
 
 				boolean foundSD = false;
 
 				for (Enumeration en = stats.elements(); en.hasMoreElements();) {
 					StatsData stat = (StatsData) en.nextElement();
 					String sraison = stat.getRaison();
 					String nbJours = stat.getNbJours();
 					String ddeb = stat.getDateDebut();
 					String dfin = stat.getDateFin();
 
 					if (sraison.equals(raison)) {
 
 						nombreJours = new Double(nbJours).doubleValue();
 
 						if (cd.isCbaprem() && cd.isCbmatin()) {
 							jourAjout = 1;
 						} else if (cd.isCbaprem() || cd.isCbmatin()) {
 							jourAjout = 0.5;
 						}
 
 						nombreJours += jourAjout;
 
 						stats.remove(stat);
 
 						stat.setDateDebut(ddeb);
 						stat.setDateFin(dfin);
 						stat.setNbJours("" + nombreJours);
 						stat.setRaison(sraison);
 
 						// on cherche le nb max de jours autorises
 						// for(Enumeration enumeration = params.elements();
 						// enumeration.hasMoreElements();)
 						// {
 						// ParamsData param =
 						// (ParamsData)enumeration.nextElement();
 						// String praison = param.getReason();
 						//						
 						// if(praison.equals(raison))
 						// {
 						// stat.setMaxNBJours(""+param.getNbJours());
 						// break;
 						// }
 						// }
 						String maxNbJours = getMaxNbDaysForReasonInParams(
 								params, raison, employee, ddeb, dfin);
 						stat.setMaxNBJours(maxNbJours);
 
 						stats.add(stat);
 						foundSD = true;
 						break;
 					}
 				}
 
 				if (!foundSD) {
 					// on cree le StatsData correspondant a la raison
 					StatsData stat = new StatsData();
 					stat.setDateDebut(new SimpleDateFormat("dd/MM/yyyy")
 							.format(debut));
 					stat.setDateFin(new SimpleDateFormat("dd/MM/yyyy")
 							.format(fin));
 					if (cd.isCbaprem() && cd.isCbmatin()) {
 						jourAjout = 1;
 					} else if (cd.isCbaprem() || cd.isCbmatin()) {
 						jourAjout = 0.5;
 					}
 
 					nombreJours += jourAjout;
 					stat.setNbJours("" + nombreJours);
 					// on cherche le nb max de jours autorises
 					for (Enumeration enumeration = params.elements(); enumeration
 							.hasMoreElements();) {
 						ParamsData param = (ParamsData) enumeration
 								.nextElement();
 						String praison = param.getReason();
 
 						if (praison.equals(raison)) {
 							stat.setMaxNBJours("" + param.getNbJours());
 							break;
 						}
 					}
 					stat.setRaison(raison);
 
 					stats.add(stat);
 				}
 			}
 		}
 
 		return stats;
 	}
 
 }