<?php
/*
// Ce module de paramétrage de calendrier est inspiré de celui du logiciel PMB, sous licence CeCILL
// développé par PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
*/

if(isset($_SESSION['user_droits'])) {
	if($_SESSION['user_droits'][4]!="2")
	{
		echo '<p class="noaccess">'.NOMODULE.'<br><a href="../index.php">'.ACCUEIL.'</a>.</p>';
	}
	else {
		
/* ce sélecteur est basé sur le calendrier dont la description et 
   l'auteur initial sont mentionnés ci-dessous.
   Il a été modifié afin d'être utilisable dans notre application */


/***************************************************************************
             ____  _   _ ____  _              _     _  _   _   _
            |  _ \| | | |  _ \| |_ ___   ___ | |___| || | | | | |
            | |_) | |_| | |_) | __/ _ \ / _ \| / __| || |_| | | |
            |  __/|  _  |  __/| || (_) | (_) | \__ \__   _| |_| |
            |_|   |_| |_|_|    \__\___/ \___/|_|___/  |_|  \___/
            
                       calendrier.php  -  A calendar
                             -------------------
    begin                : June 2002
    copyright            : (C) 2002 PHPtools4U.com - Mathieu LESNIAK
    email                : support@phptools4u.com

***************************************************************************/

/***************************************************************************
 *
 *   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.
 *
 ***************************************************************************/

/* 
- $params['calendar_id'] :  Par défaut à 1, incrémenter cette valeur pour utiliser plusieurs calendriers sur la même page.  
- $params['calendar_columns'] :  Par défaut à 7, modifier ce nombre pour diminuer / augmenter le nombres de colonnes. 
- $params['show_day'] :  Par défaut à 1, permet d'afficher les jours (L M M J V S D) 
- $params['show_month'] :  Par défaut à 1, permet d'afficher le nom du mois et l'année en haut 
- $params['nav_link'] :  Par défaut à 1, affiche les liens pour les jours et mois précédents / suivants 
- $params['link_after_date'] :  Par défaut à 0, si activé, affiche les liens de la navigation (cf ci-dessus) pour les dates supérieures au jour en cours 
- $params['link_on_day'] :  Lien à attribuer sur les jours du calendrier. A chaque lien est rajouté la date en argument. Prévoir de mettre '?argument=' en fin de lien 
- $params['font_face'] :  Police a utiliser (par défaut : 'Verdana, Arial, Helvetica') 
- $params['font_size'] :  Taille de la police moyenne en pixels (10 par défaut) 
- $params['bg_color'] :  Couleur du fond des cases des jours (blanc - #FFFFFF par défaut) 
- $params['today_bg_color'] :  Couleur de fond de la case du jour en cours 
- $params['font_today_color'] :  Couleur de la police pour le jour en cours 
- $params['font_color'] :  Couleur de la police 
- $params['font_nav_bg_color'] :  Couleur de fond pour la barre des jours (L M M J V S D) 
- $params['font_nav_color'] :  Couleur de la police pour la barre des jours (L M M J V S D) 
- $params['font_header_color'] :  Couleur de la police pour le nom du mois 
- $params['border_color'] :  Couleur pour les séparation des cases et des bordures 
- $params['use_img'] :  Utilise des fichiers gif à côté du nom du mois et pour la barre de navigation en bas. Si défini à '0', affiche les liens textes. 

*/

$base_url = "./param.php?page=calendrier";
$base_url_mois = "./param.php?categ=calendrier";

$params['calendar_id'] = 1 ; 				
$params['calendar_columns'] = 7 ; 			
$params['show_day'] = 1 ; 				
$params['show_month'] = 1 ; 				
$params['nav_link'] = 0 ; 				
$params['link_on_day'] = "" ; 		
$params['link_after_date'] = 1 ; 			
$params['link_before_date'] = 1 ; 
$params['font_face'] = "Verdana, Arial, Helvetica" ; 	
$params['font_size'] = 10 ; 				
$params['bg_color'] = "#FFFFFF" ; 			
$params['today_bg_color'] = "#FF0000" ; 		
$params['font_today_color'] = "#000000" ; 		
$params['font_color'] = "#000000" ; 			
$params['font_nav_bg_color'] = "#AAAAAA" ; 		
$params['font_nav_color'] = "#000000" ; 		
$params['font_header_color'] = "#00FF00" ; 		
$params['border_color'] = "#000000" ; 			
$params['use_img'] = 1 ; 

function calendar_gestion($date = '', $navbar=0, $url_maj_base='', $base_url_mois="", $form_input_par_jour=0) {
	include('db/idl_connect.php');
	global $link_on_day, $params, $base_url, $caller, $msg, $charset, $date_caller;
	//global $PHP_SELF, $HTTP_POST_VARS, $HTTP_GET_VARS;

	global $dbh ;
	global $style_calendrier ;
	global $admin_calendrier_form_mois_start, $admin_calendrier_form_mois_end, $admin_calendrier_form_mois_commentaire ;
	global $monthes_name;
	$rqt_date_ouverture = "SELECT date, statut FROM ".$prefix."_calendrier WHERE date_format(date, '%Y')='".substr($date,0,4)."' " ;
	$resultatdate_ouverture=mysqli_query($bdd,$rqt_date_ouverture);
	while ($resdate_ouverture=mysqli_fetch_object($resultatdate_ouverture)) {
		$ouvert[$resdate_ouverture->date] = array ("statut" => $resdate_ouverture->statut) ;
	}

	// Default Params
	$param_d['calendar_id']		= 1; // Calendar ID
	$param_d['calendar_columns']= 5; // Nb of columns
	$param_d['show_day'] 		= 1; // Show the day bar
	$param_d['show_month']		= 1; // Show the month bar
	$param_d['nav_link']		= 1; // Add a nav bar below
	$param_d['link_after_date']	= 0; // Enable link on days after the current day
	$param_d['link_before_date']= 0; // Enable link on days before the current day
	$param_d['link_on_day']		= $base_url.'?datem='; // Link to put on each day
	$param_d['font_face']		= 'Verdana, Arial, Helvetica'; // Default font to use
	$param_d['font_size']		= 10; // Font size in px
	$param_d['bg_color']		= '#FFFFFF'; 
	$param_d['today_bg_color']	= '#A0C0C0';
	$param_d['font_today_color']= '#990000';
	$param_d['font_color']		= '#000000';
	$param_d['font_nav_bg_color']= '#A9B4B3';
	
	$param_d['font_nav_color']	= '#FFFFFF';
	$param_d['font_header_color']	= '#FFFFFF';
	$param_d['border_color']	= '#3f6551';
	$param_d['use_img']		= 1; // Use gif for nav bar on the bottom
	
	// /Params
	
	foreach($param_d as $key => $val) {
		if (isset($params[$key])) $param[$key] = $params[$key];
		else $param[$key] = $val;
	}
	$param['calendar_columns'] = ($param['show_day']) ? 7 : $param['calendar_columns'];
	
	//priv_reg_glob_calendar('date');
	if ($date == '') {
		$date_MySQL = " CURDATE() ";
		} else {
			$month 		= substr($date, 4 ,2);
			$day 		= substr($date, 6, 2);
			$year		= substr($date, 0 ,4);
			$date_MySQL = "'$year-$month-$day'";
			}
	$rqt_date = "SELECT date_format(".$date_MySQL.", '%d') as current_day, date_format(".$date_MySQL.", '%m') as current_month_2, date_format(".$date_MySQL.", '%c') as current_month, date_format(".$date_MySQL.", '%Y') as current_year " ;
	$resultatdate=mysqli_query($bdd,$rqt_date);
	$resdate=mysqli_fetch_object($resultatdate);
	
	$current_day 		= $resdate->current_day;
	$current_month 		= $resdate->current_month;
	$current_month_2	= $resdate->current_month_2;
	$current_year 		= $resdate->current_year;
	
	$date_MySQL_firstday = "'$year-$current_month_2-01'";
	$rqt_date = "SELECT date_format(".$date_MySQL_firstday.", '%w') as first_day_pos,
				date_format(DATE_SUB(DATE_ADD(".$date_MySQL_firstday.", INTERVAL 1 MONTH),INTERVAL 1 DAY), '%d') as nb_days_month " ;
	$resultatdate=mysqli_query($bdd,$rqt_date);
	$resdate=mysqli_fetch_object($resultatdate);
	$first_day_pos 		= $resdate->first_day_pos;
	$first_day_pos 		= ($first_day_pos == 0) ? 7 : $first_day_pos;

	$nb_days_month 		= $resdate->nb_days_month ;
	
	$current_month_name = $monthes_name[$current_month];
	
	/* Ajout ER : détection si date en cours du calendrier correspond ou pas à la date de l'appelant 
		Sans ce test, le lien sur tous les jours identiques d'un autre mois n'étaient pas affichés, exemple :
			appelant avec date au 04/10/2003 >> lien du 04/11/2003 absent */
	@$date_MySQL_caller = "'".substr($date_caller, 0 ,4)."-".substr($date_caller, 4 ,2)."-".substr($date_caller, 6 ,2)."'";
	$rqt_date = "SELECT date_format(".$date_MySQL_caller.", '%d') as current_day, date_format(".$date_MySQL_caller.", '%c') as current_month, date_format(".$date_MySQL_caller.", '%Y') as current_year ";
	$resultatdate=mysqli_query($bdd,$rqt_date);
	$resdate=mysqli_fetch_object($resultatdate);
	
	$caller_day 		= $resdate->current_day;
	$caller_month 		= $resdate->current_month;
	$caller_year 		= $resdate->current_year;
	
	if (($caller_month==$current_month) && ($caller_year==$current_year) && ($caller_day==$current_day)) $same_date=1; else $same_date=0;
	
	$style_calendrier = '<style type="text/css">
		<!--
		.calendarNav'.$param['calendar_id'].' 	{  font-family: '.$param['font_face'].'; font-size: '.($param['font_size']-1).'px; font-style: normal; background-color: '.$param['border_color'].'}
		.calendarTop'.$param['calendar_id'].' 	{  font-family: '.$param['font_face'].'; font-size: '.($param['font_size']+1).'px; font-style: normal; color: '.$param['font_header_color'].'; font-weight: bold;  background-color: '.$param['border_color'].'}
		.calendarToday'.$param['calendar_id'].' {  font-family: '.$param['font_face'].'; font-size: '.$param['font_size'].'px; font-weight: bold; color: '.$param['font_today_color'].'; background-color: '.$param_d['today_bg_color'].';}
		.calendarDays'.$param['calendar_id'].' 	{  font-family: '.$param['font_face'].'; font-size: '.$param['font_size'].'px; font-style: normal; color: '.$param['font_color'].'; background-color: '.$param['bg_color'].'; text-align: center}
		.calendarHeader'.$param['calendar_id'].'{  font-family: '.$param['font_face'].'; font-size: '.($param['font_size']-1).'px; background-color: '.$param['font_nav_bg_color'].'; color: '.$param['font_nav_color'].';}
		.calendarTable'.$param['calendar_id'].' {  background-color: '.$param['border_color'].'; border: 1px '.$param['border_color'].' solid}
		-->
		</style>';
	$output = $style_calendrier ;
		
	//if ($form_input_par_jour) $output .= $admin_calendrier_form_mois_start ;  
	
	$output .= '<table border="0"  cellpadding="1" cellspacing="0">'."\n"; // .= ??
	
	// Displaying the current month/year
	if ($param['show_month'] == 1) {
		$output .= '<tr>'."\n";
		$output .= '	<td colspan="'.$param['calendar_columns'].'" align="right" >'."\n";
		$output .= "<a name='".$current_year."-".$current_month_2."' ></a>";
		$output .= $current_month_name.' '.$current_year;
		//if ($base_url_mois) $output .= "</a>";
		$output .= "</td>";
		$output .= "</tr>"."\n";
	}
	
	// Building the table row with the days
	if ($param['show_day'] == 1) {
		$output .= '<tr align="right">'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>L</B></TD>'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>M</B></TD>'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>M</B></TD>'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>J</B></TD>'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>V</B></TD>'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>S</B></TD>'."\n";
		$output .= '<td class="calendarHeader'.$param['calendar_id'].'"><B>D</B></TD>'."\n";
		$output .= '</tr>'."\n";	
	} else {
		$first_day_pos = 1;	
	}
	
	$output .= '<tr align="right">';
	$int_counter = 0;
	for ($i = 1; $i < $first_day_pos; $i++) {
		$output .= '<td>&nbsp;</td>'."\n";
		$int_counter++;
	}
	// Building the table
	for ($i = 1; $i <= $nb_days_month; $i++) {
		$i_2 = ($i < 10) ? '0'.$i : $i;
		//$commentaire=htmlentities($ouvert[$current_year.'-'.$current_month_2.'-'.$i_2]['commentaire'],ENT_QUOTES, $charset) ;	
		if (isset($ouvert[$current_year.'-'.$current_month_2.'-'.$i_2])) {
			if ($ouvert[$current_year.'-'.$current_month_2.'-'.$i_2]['statut']==1) {
				$class=" class='lien_date' ";
				$url_maj = $url_maj_base."&annee=".$_SESSION['annee']."&action=F&datem=" ;
			} else {
				$class = " class='close_date' ";
				$url_maj = $url_maj_base."&annee=".$_SESSION['annee']."&action=O&datem=" ;
			}
		}
		else {
			$class = " class='unexist_date' ";
			$url_maj = $url_maj_base."&annee=".$_SESSION['annee']."&action=O&datem=" ;
		}
		
		### Row start
		if ((($i + $first_day_pos-1) % $param['calendar_columns']) == 1 && $i != 1) {
			$output .= "<tr align='right'>";
			$int_counter = 0;
			}
		/*if ($form_input_par_jour) {
			$input_commentaire = "&nbsp;".str_replace("!!name!!", "comment_".$i_2, $admin_calendrier_form_mois_commentaire) ;
			$input_commentaire = "&nbsp;".str_replace("!!commentaire!!", $commentaire, $input_commentaire) ;
			} else $input_commentaire = "" ; */
		if (($i == $current_day) && ($same_date == 1)) {
			$output .= "<td align='right' $class >$input_commentaire<a href='".$url_maj.$current_year.'-'.$current_month_2.'-'.$i_2."#".$current_year."-".$current_month_2."' alt='$commentaire' title='$commentaire'>$i</a></td>\n";
			} elseif ($param['link_on_day'] != '') {
				
				$date_MySQL_loop = "'".$current_year."-".$current_month_2."-".$i_2."'";
				
				$rqt_date = "SELECT case when CURDATE() <= ".$date_MySQL_loop." then 1 ELSE 0 END as test_loop ";
				$resultatdate=mysqli_query($bdd,$rqt_date);
				$resdate=mysqli_fetch_object($resultatdate);
				$test_loop = $resdate->test_loop;
				
				if ($test_loop) {
					if ($param['link_after_date'] == 0) {
						$output .= "<td align='right' $class>".$i."</td>";
						} else {
							$output .= "<td align='right' $class><a href='".$url_maj.$current_year.'-'.$current_month_2.'-'.$i_2."#".$current_year."-".$current_month_2."'>$i</a></td>\n";
							}
					} else {
						if  ($param['link_before_date'] == 0) {
							$output .= "<td align='right' $class>".$i."</td>";
							} else {
								$output .= "<td align='right' $class><a href='".$url_maj.$current_year.'-'.$current_month_2.'-'.$i_2."#".$current_year."-".$current_month_2."'>$i</a></td>\n";
								}
						}
				} else {
					$output .= "<td align='right' $class>".$i."</td>";
					}	
		$int_counter++;
		
		// Row end
		if ( (($i+$first_day_pos-1) % $param['calendar_columns']) == 0 ) {
			$output .= '</tr>'."\n";	
			}
		}
	$cell_missing = $param['calendar_columns'] - $int_counter;
	
	for ($i = 0; $i < $cell_missing; $i++) {
		$output .= '<td align="right">&nbsp;</td>'."\n";
		}
	$output .= '</tr>'."\n";
	// Display the nav links on the bottom of the table
	if ($param['nav_link'] == 1) {
		
		$date_MySQL = "'$current_year-$current_month-$current_day'";
		$rqt_date = "SELECT 
				date_format(DATE_SUB(".$date_MySQL.", INTERVAL 1 YEAR),'%Y%m%d') as previous_month, 
				date_format(DATE_SUB(".$date_MySQL.", INTERVAL 1 MONTH),'%Y%m%d') as previous_day, 
				date_format(DATE_ADD(".$date_MySQL.", INTERVAL 1 YEAR),'%Y%m%d') as next_month, 
				date_format(DATE_ADD(".$date_MySQL.", INTERVAL 1 MONTH),'%Y%m%d') as next_day, 
				case when CURDATE() < date_format(DATE_ADD(".$date_MySQL.", INTERVAL 1 YEAR),'%Y%m%d') then 1 else 0 END as test_next_year, 
				case when CURDATE() < date_format(DATE_ADD(".$date_MySQL.", INTERVAL 1 MONTH),'%Y%m%d') then 1 else 0 END as test_next_month ";
		$resultatdate=mysqli_query($rqt_date);
		$resdate=mysqli_fetch_object($resultatdate);
	
		$previous_month	= $resdate->previous_month;
		$next_month    	= $resdate->next_month;
		$previous_day  	= $resdate->previous_day;
		$next_day      	= $resdate->next_day;
		$test_next_month = $resdate->test_next_month;
		$test_next_year  = $resdate->test_next_year;
		
		if ($param['use_img']) {
			$g 	= '<img src="./images/g.gif" border="0" title="'.$msg['calendrier_mois_prececent'].'">';
			$gg = '<img src="./images/gg.gif" border="0" title="'.$msg['calendrier_annee_prececente'].'">';
			$d 	= '<img src="./images/d.gif" border="0" title="'.$msg['calendrier_mois_suivant'].'">';
			$dd = '<img src="./images/dd.gif" border="0" title="'.$msg['calendrier_annee_suivante'].'">';
			} else {
				$g 	= '&lt;';
				$gg = '&lt;&lt;';
				$d = '&gt;';
				$dd = '&gt;&gt;';
				}

		if ( ($param['link_after_date'] == 0) && ($test_next_month) ) {
			$next_day_link = '&nbsp;';
			} else {
				$next_day_link 		= '<a href="'.$base_url.'&date='.$next_day.'&loc='.$loc_id.'">'.$d.'</a>'."\n";
				}
		
		if ( ($param['link_after_date'] == 0) && ($test_next_year) ) {
			$next_month_link = '&nbsp;';		
			} else {
				$next_month_link 	= '<a href="'.$base_url.'&date='.$next_month.'&loc='.$loc_id.'">'.$dd.'</a>'."\n";
				}
		
		$output .= '<tr>'."\n";
		$output .= '	<td colspan="'.$param['calendar_columns'].'" class="calendarDays'.$param['calendar_id'].'" align="right">'."\n";
		$output .= "	
						<a href='".$base_url."&date=".$previous_month."&loc=".$loc_id."'>".$gg."</a>
						&nbsp;
						<a href='".$base_url."&date=".$previous_day."&loc=".$loc_id."'>".$g."</a>
						&nbsp;
						$next_day_link
						&nbsp;
						$next_month_link
				";
		$output .= '</td>'."\n";
		$output .= '</tr>'."\n";
		
	}
	$output .= '</table>'."\n";
	if ($form_input_par_jour) {
		$admin_calendrier_form_mois_end = str_replace ("!!annee_mois!!", $current_year.'-'.$current_month_2, $admin_calendrier_form_mois_end) ;
		//$admin_calendrier_form_mois_end = str_replace ("!!book_location_id!!", $loc_id, $admin_calendrier_form_mois_end) ;
		$output .= $admin_calendrier_form_mois_end ;
	}
	return $output;
		}
	}
}
else {
	include('include/noaccess.php');
	echo '<br><a href="../index.php">'.ACCUEIL.'</a>.</p>';
}
