WebSVN – Applications.bazar – Diff – /branches/livraison_menes/bibliotheque/bazar.fonct.cal.php


<?php
/*vim: set expandtab tabstop=4 shiftwidth=4: */
// +------------------------------------------------------------------------------------------------------+
// | PHP version 4.1                                                                                      |
// +------------------------------------------------------------------------------------------------------+
// | Copyright (C) 2004 Tela Botanica (accueil@tela-botanica.org)                                         |
// +------------------------------------------------------------------------------------------------------+
// | This library is free software; you can redistribute it and/or                                        |
// | modify it under the terms of the GNU Lesser General Public                                           |
// | License as published by the Free Software Foundation; either                                         |
// | version 2.1 of the License, or (at your option) any later version.                                   |
// |                                                                                                      |
// | This library 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                                    |
// | Lesser General Public License for more details.                                                      |
// |                                                                                                      |
// | You should have received a copy of the GNU Lesser General Public                                     |
// | License along with this library; if not, write to the Free Software                                  |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                            |
// +------------------------------------------------------------------------------------------------------+
// CVS : $Id: bazar.fonct.cal.php,v 1.10.2.1 2007-02-15 13:42:16 jp_milcent Exp $
/**
*
* Fonctions calendrier du module bazar
*
*@package bazar
//Auteur original :
*@author        David Delon <david.delon@clapas.net>
//Autres auteurs :
*@copyright     Tela-Botanica 2000-2004
*@version       $Revision: 1.10.2.1 $ $Date: 2007-02-15 13:42:16 $
// +------------------------------------------------------------------------------------------------------+
*/
 
// +------------------------------------------------------------------------------------------------------+
// |                                            ENTETE du PROGRAMME                                       |
// +------------------------------------------------------------------------------------------------------+
 
require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Month/Weekdays.php';
require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Day.php';
require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Decorator.php'; 
 
 
// +------------------------------------------------------------------------------------------------------+
// |                                           LISTE de FONCTIONS                                         |
// +------------------------------------------------------------------------------------------------------+
 
 
// Classe Utilitaire pour Calendrier
 
class DiaryEvent extends Calendar_Decorator {
	var $entry=array();
	function DiaryEvent($calendar) {
		Calendar_Decorator::Calendar_Decorator($calendar);
	}
	function setEntry($entry) {
		$this->entry[]=$entry;
		
	}
	function getEntry() {
		return $this->entry;
	}
} 
 
 
// $type : calendrier
// $type : calendrier_appplette
 
function GestionAffichageCalendrier($type='calendrier') {
	
	
	$retour='';
 
	$url = $GLOBALS['_GEN_commun']['url'] ;
	$db = &$GLOBALS['_GEN_commun']['pear_db'] ;
	$auth = &$GLOBALS['_GEN_commun']['pear_auth'] ;
	
	if (!isset($_GET['y'])) { 
		$_GET['y'] = date('Y');
	}
	
	if (!isset($_GET['m'])) { 
		$_GET['m'] = date('m');
	}
	
	
	// 	Construction Mois en Cours 
	$month = new Calendar_Month_Weekdays($_GET['y'],$_GET['m']);
 
	$curStamp=$month->getTimeStamp();
	$url->addQueryString ('y', date('Y',$curStamp));
	$url->addQueryString ('m', date('n',$curStamp));
	$url->addQueryString ('d', date('j',$curStamp));
	$cur = $url->getUrl();
	
	// Navigation 
	$prevStamp = $month->prevMonth(true);
	$url->addQueryString ('y', date('Y',$prevStamp));
	$url->addQueryString ('m', date('n',$prevStamp));
	$url->addQueryString ('d', date('j',$prevStamp));
	$prev = $url->getUrl();
	$nextStamp = $month->nextMonth(true);
	$url->addQueryString ('y', date('Y',$nextStamp));
	$url->addQueryString ('m', date('n',$nextStamp));
	$url->addQueryString ('d', date('j',$nextStamp));
	$next = $url->getUrl();
 
	$fr_month=array("1"=>BAZ_JANVIER,"2"=>BAZ_FEVRIER,"3"=>BAZ_MARS,"4"=>BAZ_AVRIL,"5"=>BAZ_MAI,"6"=>BAZ_JUIN,"7"=>BAZ_JUILLET,"8"=>BAZ_AOUT,"9"=>BAZ_SEPTEMBRE,"10"=>BAZ_OCTOBRE,"11"=>BAZ_NOVEMBRE,"12"=>BAZ_DECEMBRE);
 
	$retour.= "<div class=\"navi\">";
	$retour.= "<a href=\"".$prev."\"> &lt;&lt; </a>"; 
 
	$retour.= "&nbsp;&nbsp;";
	$retour.= "<a href=\"".$cur;
	$retour.= "\"> ";
	$retour.= $fr_month[(date('n',$curStamp))]; 
	$retour.= "&nbsp;";
	$retour.= (date('Y',$curStamp));
	$retour.= "</a>";
	$retour.= "&nbsp;&nbsp;";
	$retour.= "<a href=\"".$next."\"> &gt;&gt; </a>";
 
	$retour.= "</div>";
 
	$retour.="<br></br>";
 
	// Vue Mois calendrier ou vue applette
		
	if ((!isset($_GET['id_fiche']) && ($type=='calendrier')) || ($type=='calendrier_applette')){
			
		// Recherche evenement de la periode selectionnée 
		
	 	// TODO : Selectionner element du mois en cours 
	 	
	    $requete_evenements = 	"SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, DAY(bf_date_debut_evenement) AS bf_jour_debut_evenement , bf_date_fin_evenement, bf_description ".
								"FROM bazar_fiche, bazar_nature ".
								"WHERE YEAR(bf_date_debut_evenement) = ".date('Y',$curStamp)." ".
								"AND month(bf_date_debut_evenement) = ".date('m',$curStamp)." ".
								"AND bf_ce_nature = bn_id_nature ".
 
								"AND bn_id_nature IN (".BAZ_NUM_ANNONCE_CALENDRIER.")";
		
	   	$resultat_evenement = $db->query($requete_evenements);
	   	
	    (DB::isError($resultat_evenement))
	    ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_evenement->getMessage(), $requete_evenements))
	    : '';
	
		$calcom="";
		
		$selection=array();
		$evenements=array();
		 
		$prev_curday_ymd=0;
		
	    while ($ligne_evenements = $resultat_evenement->fetchRow(DB_FETCHMODE_OBJECT)) {
	    	
			$curday_ymd=date('Ym',$curStamp).$ligne_evenements->bf_jour_debut_evenement;
			if ($curday_ymd!=$prev_curday_ymd) {
				$Day = new Calendar_Day(date('Y',$curStamp),date('m',$curStamp), $ligne_evenements->bf_jour_debut_evenement);
				$DiaryEvent = new DiaryEvent($Day);
				$prev_curday_ymd=$curday_ymd;
			}
			
			$DiaryEvent->setEntry($ligne_evenements);
			
			// Add the decorator to the selection
			$selection[] = $DiaryEvent;
				
		}
			
		// Affichage Calendrier
		
		
		$month->build($selection);
	
		if ($type=='calendrier') {
			$retour.= "<table class=\"calendar\">
			 <tr>
			
			  <th> ". BAZ_LUNDI ."</th>
			  <th> ". BAZ_MARDI ."</th>
			  <th> ". BAZ_MERCREDI ."</th>
			  <th> ". BAZ_JEUDI ."</th>
			  <th> ". BAZ_VENDREDI ."</th>
			  <th> ". BAZ_SAMEDI ."</th>
			  <th> ". BAZ_DIMANCHE ."</th>
			 </tr>
			 ";
		}
		else {
			$retour.= "<table class=\"calendar\">
			 <tr>
			
			  <th> ". BAZ_LUNDI_COURT ."</th>
			  <th> ". BAZ_MARDI_COURT ."</th>
			  <th> ". BAZ_MERCREDI_COURT ."</th>
			  <th> ". BAZ_JEUDI_COURT ."</th>
			  <th> ". BAZ_VENDREDI_COURT ."</th>
			  <th> ". BAZ_SAMEDI_COURT ."</th>
			  <th> ". BAZ_DIMANCHE_COURT ."</th>
			 </tr>
			 ";
		}
		
			
		$todayStamp=time();
		
		$today_ymd=date('Ymd',$todayStamp);
	
		// Other month : mois 
		//
		
		while ($day = $month->fetch() ) {
				
				$dayStamp = $day->thisDay(true);
				$day_ymd=date('Ymd',$dayStamp);
				
				if ( $day->isEmpty() ) {
						$class = "other_month";
				}
				else {
					if (($day_ymd < $today_ymd)) {
						$class= "previous_month";
					}
					else {
						 if ($day_ymd == $today_ymd) {
						 	$class= "current_day";
						 }
						 else {
							$class="current_month";
						 }
					}
				}
				
				$url->addQueryString ('y', date('Y',$dayStamp));
				$url->addQueryString ('m', date('n',$dayStamp));
				$url->addQueryString ('d', date('j',$dayStamp));
				
				$link = $url->getUrl();
			
				// isFirst() to find start of week
				if ($day->isFirst())
					$retour.= ( "<tr>\n" );
				
				//$retour.= ( "<td class=\"".$class."\"><a href=\"".$link."\">".$day->thisDay()."</a>\n" );
				
				if ($type=='calendrier') {
					$retour.= "<td class=\"".$class."\">".$day->thisDay()."\n";
					if ($day->isSelected() ) {
						$evenements=$day->getEntry();
						while ($ligne_evenement=array_pop($evenements)) {
							$id_fiches=array();
							$id_fiches[]=$ligne_evenement->bf_id_fiche;
							$url->addQueryString ('id_fiches',$id_fiches);
							$link = $url->getUrl();
							$retour.= "<a href=\"".$link."\">".$ligne_evenement->bf_titre."</a>\n";
							$url->removeQueryString ('id_fiches');
						}
					}
				}
				else {
					$lien_date= "<td class=\"".$class."\">".$day->thisDay()."\n";
					if ($day->isSelected() ) {
						$evenements=$day->getEntry();
						$id_fiches=array();
						while ($ligne_evenement=array_pop($evenements)) {
							$id_fiches[]=$ligne_evenement->bf_id_fiche;
						}
						$url->addQueryString ('id_fiches',$id_fiches);
						$link = $url->getUrl();
						$lien_date= "<td class=\"".$class."\"><a href=\"".$link."\">".$day->thisDay()."</a>\n";
						$url->removeQueryString ('id_fiches');
					}
					$retour.=$lien_date;
				}
				
				$retour.= ( "</td>\n" );
				
				// isLast() to find end of week
				if ( $day->isLast() )
					$retour.= ( "</tr>\n" );
			}
		
			$retour.= "</table>";
			
			
		}
		
		// Vue detail
		
		if ((isset($_GET['id_fiches']))) {
				// Ajout des styles du bazar
				if (defined('PAP_VERSION')) { //si on est dans Papyrus
					GEN_stockerStyleExterne( 'bazar_interne2', 'client/bazar/bazar.interne.css');
				}
			
				// Ajout d'un titre pour la page avec la date
				$jours = array ('lundi', 'mardi', 'mercredi', 'jeudi', 'vendredi', 'samedi', 'dimanche') ;
				$mois = array ('janvier', 'février', 'mars', 'avril', 'mai', 'juin', 'juillet', 'août', 'septembre',
								'octobre', 'novembre', 'décembre') ;
				$timestamp = strtotime ($_GET['y'].'/'.$_GET['m'].'/'.$_GET['d']) ;
				$GLOBALS['_PAPYRUS_']['rendu']['CONTENU_CORPS'] = '<h1>'.$jours[date('w', $timestamp)].
								' '.$_GET['d'].' '.$mois[$_GET['m']-1].' '.$_GET['y'].'</h1>' ;
				$GLOBALS['_PAPYRUS_']['rendu']['CONTENU_CORPS'] .= baz_voir_fiches(0,$_GET['id_fiches'] );
		}
			
		return $retour;
		
	}
 
?>

Rev 161	Rev 183
1	`<?php`	1	`<?php`
2	`/vim: set expandtab tabstop=4 shiftwidth=4: /`	2	`/vim: set expandtab tabstop=4 shiftwidth=4: /`
3	`// +------------------------------------------------------------------------------------------------------+`	3	`// +------------------------------------------------------------------------------------------------------+`
4	`// \| PHP version 4.1 \|`	4	`// \| PHP version 4.1 \|`
5	`// +------------------------------------------------------------------------------------------------------+`	5	`// +------------------------------------------------------------------------------------------------------+`
6	`// \| Copyright (C) 2004 Tela Botanica (accueil@tela-botanica.org) \|`	6	`// \| Copyright (C) 2004 Tela Botanica (accueil@tela-botanica.org) \|`
7	`// +------------------------------------------------------------------------------------------------------+`	7	`// +------------------------------------------------------------------------------------------------------+`
8	`// \| This library is free software; you can redistribute it and/or \|`	8	`// \| This library is free software; you can redistribute it and/or \|`
9	`// \| modify it under the terms of the GNU Lesser General Public \|`	9	`// \| modify it under the terms of the GNU Lesser General Public \|`
10	`// \| License as published by the Free Software Foundation; either \|`	10	`// \| License as published by the Free Software Foundation; either \|`
11	`// \| version 2.1 of the License, or (at your option) any later version. \|`	11	`// \| version 2.1 of the License, or (at your option) any later version. \|`
12	`// \| \|`	12	`// \| \|`
13	`// \| This library is distributed in the hope that it will be useful, \|`	13	`// \| This library is distributed in the hope that it will be useful, \|`
14	`// \| but WITHOUT ANY WARRANTY; without even the implied warranty of \|`	14	`// \| but WITHOUT ANY WARRANTY; without even the implied warranty of \|`
15	`// \| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU \|`	15	`// \| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU \|`
16	`// \| Lesser General Public License for more details. \|`	16	`// \| Lesser General Public License for more details. \|`
17	`// \| \|`	17	`// \| \|`
18	`// \| You should have received a copy of the GNU Lesser General Public \|`	18	`// \| You should have received a copy of the GNU Lesser General Public \|`
19	`// \| License along with this library; if not, write to the Free Software \|`	19	`// \| License along with this library; if not, write to the Free Software \|`
20	`// \| Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA \|`	20	`// \| Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA \|`
21	`// +------------------------------------------------------------------------------------------------------+`	21	`// +------------------------------------------------------------------------------------------------------+`
22	`// CVS : $Id: bazar.fonct.cal.php,v 1.10 2006-09-14 14:15:35 alexandre_tb Exp $`	22	`// CVS : $Id: bazar.fonct.cal.php,v 1.10.2.1 2007-02-15 13:42:16 jp_milcent Exp $`
23	`/**`	23	`/**`
24	`*`	24	`*`
25	`* Fonctions calendrier du module bazar`	25	`* Fonctions calendrier du module bazar`
26	`*`	26	`*`
27	`*@package bazar`	27	`*@package bazar`
28	`//Auteur original :`	28	`//Auteur original :`
29	`*@author David Delon <david.delon@clapas.net>`	29	`*@author David Delon <david.delon@clapas.net>`
30	`//Autres auteurs :`	30	`//Autres auteurs :`
31	`*@copyright Tela-Botanica 2000-2004`	31	`*@copyright Tela-Botanica 2000-2004`
32	`*@version $Revision: 1.10 $ $Date: 2006-09-14 14:15:35 $`	32	`*@version $Revision: 1.10.2.1 $ $Date: 2007-02-15 13:42:16 $`
33	`// +------------------------------------------------------------------------------------------------------+`	33	`// +------------------------------------------------------------------------------------------------------+`
34	`*/`	34	`*/`
35		35
36	`// +------------------------------------------------------------------------------------------------------+`	36	`// +------------------------------------------------------------------------------------------------------+`
37	`// \| ENTETE du PROGRAMME \|`	37	`// \| ENTETE du PROGRAMME \|`
38	`// +------------------------------------------------------------------------------------------------------+`	38	`// +------------------------------------------------------------------------------------------------------+`
39		39
40	`require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Month/Weekdays.php';`	40	`require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Month/Weekdays.php';`
41	`require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Day.php';`	41	`require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Day.php';`
42	`require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Decorator.php';`	42	`require_once PAP_CHEMIN_RACINE.'api/pear/Calendar/Decorator.php';`
43		43
44		44
45	`// +------------------------------------------------------------------------------------------------------+`	45	`// +------------------------------------------------------------------------------------------------------+`
46	`// \| LISTE de FONCTIONS \|`	46	`// \| LISTE de FONCTIONS \|`
47	`// +------------------------------------------------------------------------------------------------------+`	47	`// +------------------------------------------------------------------------------------------------------+`
48		48
49		49
50	`// Classe Utilitaire pour Calendrier`	50	`// Classe Utilitaire pour Calendrier`
51		51
52	`class DiaryEvent extends Calendar_Decorator {`	52	`class DiaryEvent extends Calendar_Decorator {`
53	`var $entry=array();`	53	`var $entry=array();`
54	`function DiaryEvent($calendar) {`	54	`function DiaryEvent($calendar) {`
55	`Calendar_Decorator::Calendar_Decorator($calendar);`	55	`Calendar_Decorator::Calendar_Decorator($calendar);`
56	`}`	56	`}`
57	`function setEntry($entry) {`	57	`function setEntry($entry) {`
58	`$this->entry[]=$entry;`	58	`$this->entry[]=$entry;`
59		59
60	`}`	60	`}`
61	`function getEntry() {`	61	`function getEntry() {`
62	`return $this->entry;`	62	`return $this->entry;`
63	`}`	63	`}`
64	`}`	64	`}`
65		65
66		66
67	`// $type : calendrier`	67	`// $type : calendrier`
68	`// $type : calendrier_appplette`	68	`// $type : calendrier_appplette`
69		69
70	`function GestionAffichageCalendrier($type='calendrier') {`	70	`function GestionAffichageCalendrier($type='calendrier') {`
71		71
72		72
73	`$retour='';`	73	`$retour='';`
74		74
75	`$url = $GLOBALS['_GEN_commun']['url'] ;`	75	`$url = $GLOBALS['_GEN_commun']['url'] ;`
76	`$db = &$GLOBALS['_GEN_commun']['pear_db'] ;`	76	`$db = &$GLOBALS['_GEN_commun']['pear_db'] ;`
77	`$auth = &$GLOBALS['_GEN_commun']['pear_auth'] ;`	77	`$auth = &$GLOBALS['_GEN_commun']['pear_auth'] ;`
78		78
79	`if (!isset($_GET['y'])) {`	79	`if (!isset($_GET['y'])) {`
80	`$_GET['y'] = date('Y');`	80	`$_GET['y'] = date('Y');`
81	`}`	81	`}`
82		82
83	`if (!isset($_GET['m'])) {`	83	`if (!isset($_GET['m'])) {`
84	`$_GET['m'] = date('m');`	84	`$_GET['m'] = date('m');`
85	`}`	85	`}`
86		86
87		87
88	`// Construction Mois en Cours`	88	`// Construction Mois en Cours`
89	`$month = new Calendar_Month_Weekdays($_GET['y'],$_GET['m']);`	89	`$month = new Calendar_Month_Weekdays($_GET['y'],$_GET['m']);`
90		90
91	`$curStamp=$month->getTimeStamp();`	91	`$curStamp=$month->getTimeStamp();`
92	`$url->addQueryString ('y', date('Y',$curStamp));`	92	`$url->addQueryString ('y', date('Y',$curStamp));`
93	`$url->addQueryString ('m', date('n',$curStamp));`	93	`$url->addQueryString ('m', date('n',$curStamp));`
94	`$url->addQueryString ('d', date('j',$curStamp));`	94	`$url->addQueryString ('d', date('j',$curStamp));`
95	`$cur = $url->getUrl();`	95	`$cur = $url->getUrl();`
96		96
97	`// Navigation`	97	`// Navigation`
98	`$prevStamp = $month->prevMonth(true);`	98	`$prevStamp = $month->prevMonth(true);`
99	`$url->addQueryString ('y', date('Y',$prevStamp));`	99	`$url->addQueryString ('y', date('Y',$prevStamp));`
100	`$url->addQueryString ('m', date('n',$prevStamp));`	100	`$url->addQueryString ('m', date('n',$prevStamp));`
101	`$url->addQueryString ('d', date('j',$prevStamp));`	101	`$url->addQueryString ('d', date('j',$prevStamp));`
102	`$prev = $url->getUrl();`	102	`$prev = $url->getUrl();`
103	`$nextStamp = $month->nextMonth(true);`	103	`$nextStamp = $month->nextMonth(true);`
104	`$url->addQueryString ('y', date('Y',$nextStamp));`	104	`$url->addQueryString ('y', date('Y',$nextStamp));`
105	`$url->addQueryString ('m', date('n',$nextStamp));`	105	`$url->addQueryString ('m', date('n',$nextStamp));`
106	`$url->addQueryString ('d', date('j',$nextStamp));`	106	`$url->addQueryString ('d', date('j',$nextStamp));`
107	`$next = $url->getUrl();`	107	`$next = $url->getUrl();`
108		108
109	`$fr_month=array("1"=>BAZ_JANVIER,"2"=>BAZ_FEVRIER,"3"=>BAZ_MARS,"4"=>BAZ_AVRIL,"5"=>BAZ_MAI,"6"=>BAZ_JUIN,"7"=>BAZ_JUILLET,"8"=>BAZ_AOUT,"9"=>BAZ_SEPTEMBRE,"10"=>BAZ_OCTOBRE,"11"=>BAZ_NOVEMBRE,"12"=>BAZ_DECEMBRE);`	109	`$fr_month=array("1"=>BAZ_JANVIER,"2"=>BAZ_FEVRIER,"3"=>BAZ_MARS,"4"=>BAZ_AVRIL,"5"=>BAZ_MAI,"6"=>BAZ_JUIN,"7"=>BAZ_JUILLET,"8"=>BAZ_AOUT,"9"=>BAZ_SEPTEMBRE,"10"=>BAZ_OCTOBRE,"11"=>BAZ_NOVEMBRE,"12"=>BAZ_DECEMBRE);`
110		110
111	`$retour.= "<div class=\"navi\">";`	111	`$retour.= "<div class=\"navi\">";`
112	`$retour.= "<a href=\"".$prev."\"> << </a>";`	112	`$retour.= "<a href=\"".$prev."\"> << </a>";`
113		113
114	`$retour.= "  ";`	114	`$retour.= "  ";`
115	`$retour.= "<a href=\"".$cur;`	115	`$retour.= "<a href=\"".$cur;`
116	`$retour.= "\"> ";`	116	`$retour.= "\"> ";`
117	`$retour.= $fr_month[(date('n',$curStamp))];`	117	`$retour.= $fr_month[(date('n',$curStamp))];`
118	`$retour.= " ";`	118	`$retour.= " ";`
119	`$retour.= (date('Y',$curStamp));`	119	`$retour.= (date('Y',$curStamp));`
120	`$retour.= "</a>";`	120	`$retour.= "</a>";`
121	`$retour.= "  ";`	121	`$retour.= "  ";`
122	`$retour.= "<a href=\"".$next."\"> >> </a>";`	122	`$retour.= "<a href=\"".$next."\"> >> </a>";`
123		123
124	`$retour.= "</div>";`	124	`$retour.= "</div>";`
125		125
126	`$retour.="<br></br>";`	126	`$retour.="<br></br>";`
127		127
128	`// Vue Mois calendrier ou vue applette`	128	`// Vue Mois calendrier ou vue applette`
129		129
130	`if ((!isset($_GET['id_fiche']) && ($type=='calendrier')) \|\| ($type=='calendrier_applette')){`	130	`if ((!isset($_GET['id_fiche']) && ($type=='calendrier')) \|\| ($type=='calendrier_applette')){`
131		131
132	`// Recherche evenement de la periode selectionnée`	132	`// Recherche evenement de la periode selectionnée`
133		133
134	`// TODO : Selectionner element du mois en cours`	134	`// TODO : Selectionner element du mois en cours`
135		135
-		136	`$requete_evenements = "SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, DAY(bf_date_debut_evenement) AS bf_jour_debut_evenement , bf_date_fin_evenement, bf_description ".`
-		137	`"FROM bazar_fiche, bazar_nature ".`
136	`$requete_evenements = "SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, day(bf_date_debut_evenement) as bf_jour_debut_evenement , bf_date_fin_evenement, bf_description FROM bazar_fiche, bazar_nature where year(bf_date_debut_evenement) =".`	138	`"WHERE YEAR(bf_date_debut_evenement) = ".date('Y',$curStamp)." ".`
-		139	`"AND month(bf_date_debut_evenement) = ".date('m',$curStamp)." ".`
137	`date('Y',$curStamp)." and month(bf_date_debut_evenement)=".`	140	`"AND bf_ce_nature = bn_id_nature ".`
138	`date('m',$curStamp)." and bf_ce_nature=bn_id_nature and bn_id_nature='".BAZ_NUM_ANNONCE_CALENDRIER."'";`	-
139		141	`"AND bn_id_nature IN (".BAZ_NUM_ANNONCE_CALENDRIER.")";`
140		142
141	`$resultat_evenement = $db->query($requete_evenements);`	143	`$resultat_evenement = $db->query($requete_evenements);`
142		144
143	`(DB::isError($resultat_evenement))`	145	`(DB::isError($resultat_evenement))`
144	`? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_evenement->getMessage(), $requete_evenements))`	146	`? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_evenement->getMessage(), $requete_evenements))`
145	`: '';`	147	`: '';`
146		148
147	`$calcom="";`	149	`$calcom="";`
148		150
149	`$selection=array();`	151	`$selection=array();`
150	`$evenements=array();`	152	`$evenements=array();`
151		153
152	`$prev_curday_ymd=0;`	154	`$prev_curday_ymd=0;`
153		155
154	`while ($ligne_evenements = $resultat_evenement->fetchRow(DB_FETCHMODE_OBJECT)) {`	156	`while ($ligne_evenements = $resultat_evenement->fetchRow(DB_FETCHMODE_OBJECT)) {`
155		157
156	`$curday_ymd=date('Ym',$curStamp).$ligne_evenements->bf_jour_debut_evenement;`	158	`$curday_ymd=date('Ym',$curStamp).$ligne_evenements->bf_jour_debut_evenement;`
157	`if ($curday_ymd!=$prev_curday_ymd) {`	159	`if ($curday_ymd!=$prev_curday_ymd) {`
158	`$Day = new Calendar_Day(date('Y',$curStamp),date('m',$curStamp), $ligne_evenements->bf_jour_debut_evenement);`	160	`$Day = new Calendar_Day(date('Y',$curStamp),date('m',$curStamp), $ligne_evenements->bf_jour_debut_evenement);`
159	`$DiaryEvent = new DiaryEvent($Day);`	161	`$DiaryEvent = new DiaryEvent($Day);`
160	`$prev_curday_ymd=$curday_ymd;`	162	`$prev_curday_ymd=$curday_ymd;`
161	`}`	163	`}`
162		164
163	`$DiaryEvent->setEntry($ligne_evenements);`	165	`$DiaryEvent->setEntry($ligne_evenements);`
164		166
165	`// Add the decorator to the selection`	167	`// Add the decorator to the selection`
166	`$selection[] = $DiaryEvent;`	168	`$selection[] = $DiaryEvent;`
167		169
168	`}`	170	`}`
169		171
170	`// Affichage Calendrier`	172	`// Affichage Calendrier`
171		173
172		174
173	`$month->build($selection);`	175	`$month->build($selection);`
174		176
175	`if ($type=='calendrier') {`	177	`if ($type=='calendrier') {`
176	`$retour.= "<table class=\"calendar\">`	178	`$retour.= "<table class=\"calendar\">`
177	`<tr>`	179	`<tr>`
178		180
179	`<th> ". BAZ_LUNDI ."</th>`	181	`<th> ". BAZ_LUNDI ."</th>`
180	`<th> ". BAZ_MARDI ."</th>`	182	`<th> ". BAZ_MARDI ."</th>`
181	`<th> ". BAZ_MERCREDI ."</th>`	183	`<th> ". BAZ_MERCREDI ."</th>`
182	`<th> ". BAZ_JEUDI ."</th>`	184	`<th> ". BAZ_JEUDI ."</th>`
183	`<th> ". BAZ_VENDREDI ."</th>`	185	`<th> ". BAZ_VENDREDI ."</th>`
184	`<th> ". BAZ_SAMEDI ."</th>`	186	`<th> ". BAZ_SAMEDI ."</th>`
185	`<th> ". BAZ_DIMANCHE ."</th>`	187	`<th> ". BAZ_DIMANCHE ."</th>`
186	`</tr>`	188	`</tr>`
187	`";`	189	`";`
188	`}`	190	`}`
189	`else {`	191	`else {`
190	`$retour.= "<table class=\"calendar\">`	192	`$retour.= "<table class=\"calendar\">`
191	`<tr>`	193	`<tr>`
192		194
193	`<th> ". BAZ_LUNDI_COURT ."</th>`	195	`<th> ". BAZ_LUNDI_COURT ."</th>`
194	`<th> ". BAZ_MARDI_COURT ."</th>`	196	`<th> ". BAZ_MARDI_COURT ."</th>`
195	`<th> ". BAZ_MERCREDI_COURT ."</th>`	197	`<th> ". BAZ_MERCREDI_COURT ."</th>`
196	`<th> ". BAZ_JEUDI_COURT ."</th>`	198	`<th> ". BAZ_JEUDI_COURT ."</th>`
197	`<th> ". BAZ_VENDREDI_COURT ."</th>`	199	`<th> ". BAZ_VENDREDI_COURT ."</th>`
198	`<th> ". BAZ_SAMEDI_COURT ."</th>`	200	`<th> ". BAZ_SAMEDI_COURT ."</th>`
199	`<th> ". BAZ_DIMANCHE_COURT ."</th>`	201	`<th> ". BAZ_DIMANCHE_COURT ."</th>`
200	`</tr>`	202	`</tr>`
201	`";`	203	`";`
202	`}`	204	`}`
203		205
204		206
205	`$todayStamp=time();`	207	`$todayStamp=time();`
206		208
207	`$today_ymd=date('Ymd',$todayStamp);`	209	`$today_ymd=date('Ymd',$todayStamp);`
208		210
209	`// Other month : mois`	211	`// Other month : mois`
210	`//`	212	`//`
211		213
212	`while ($day = $month->fetch() ) {`	214	`while ($day = $month->fetch() ) {`
213		215
214	`$dayStamp = $day->thisDay(true);`	216	`$dayStamp = $day->thisDay(true);`
215	`$day_ymd=date('Ymd',$dayStamp);`	217	`$day_ymd=date('Ymd',$dayStamp);`
216		218
217	`if ( $day->isEmpty() ) {`	219	`if ( $day->isEmpty() ) {`
218	`$class = "other_month";`	220	`$class = "other_month";`
219	`}`	221	`}`
220	`else {`	222	`else {`
221	`if (($day_ymd < $today_ymd)) {`	223	`if (($day_ymd < $today_ymd)) {`
222	`$class= "previous_month";`	224	`$class= "previous_month";`
223	`}`	225	`}`
224	`else {`	226	`else {`
225	`if ($day_ymd == $today_ymd) {`	227	`if ($day_ymd == $today_ymd) {`
226	`$class= "current_day";`	228	`$class= "current_day";`
227	`}`	229	`}`
228	`else {`	230	`else {`
229	`$class="current_month";`	231	`$class="current_month";`
230	`}`	232	`}`
231	`}`	233	`}`
232	`}`	234	`}`
233		235
234	`$url->addQueryString ('y', date('Y',$dayStamp));`	236	`$url->addQueryString ('y', date('Y',$dayStamp));`
235	`$url->addQueryString ('m', date('n',$dayStamp));`	237	`$url->addQueryString ('m', date('n',$dayStamp));`
236	`$url->addQueryString ('d', date('j',$dayStamp));`	238	`$url->addQueryString ('d', date('j',$dayStamp));`
237		239
238	`$link = $url->getUrl();`	240	`$link = $url->getUrl();`
239		241
240	`// isFirst() to find start of week`	242	`// isFirst() to find start of week`
241	`if ($day->isFirst())`	243	`if ($day->isFirst())`
242	`$retour.= ( "<tr>\n" );`	244	`$retour.= ( "<tr>\n" );`
243		245
244	`//$retour.= ( "<td class=\"".$class."\"><a href=\"".$link."\">".$day->thisDay()."</a>\n" );`	246	`//$retour.= ( "<td class=\"".$class."\"><a href=\"".$link."\">".$day->thisDay()."</a>\n" );`
245		247
246	`if ($type=='calendrier') {`	248	`if ($type=='calendrier') {`
247	`$retour.= "<td class=\"".$class."\">".$day->thisDay()."\n";`	249	`$retour.= "<td class=\"".$class."\">".$day->thisDay()."\n";`
248	`if ($day->isSelected() ) {`	250	`if ($day->isSelected() ) {`
249	`$evenements=$day->getEntry();`	251	`$evenements=$day->getEntry();`
250	`while ($ligne_evenement=array_pop($evenements)) {`	252	`while ($ligne_evenement=array_pop($evenements)) {`
251	`$id_fiches=array();`	253	`$id_fiches=array();`
252	`$id_fiches[]=$ligne_evenement->bf_id_fiche;`	254	`$id_fiches[]=$ligne_evenement->bf_id_fiche;`
253	`$url->addQueryString ('id_fiches',$id_fiches);`	255	`$url->addQueryString ('id_fiches',$id_fiches);`
254	`$link = $url->getUrl();`	256	`$link = $url->getUrl();`
255	`$retour.= "<a href=\"".$link."\">".$ligne_evenement->bf_titre."</a>\n";`	257	`$retour.= "<a href=\"".$link."\">".$ligne_evenement->bf_titre."</a>\n";`
256	`$url->removeQueryString ('id_fiches');`	258	`$url->removeQueryString ('id_fiches');`
257	`}`	259	`}`
258	`}`	260	`}`
259	`}`	261	`}`
260	`else {`	262	`else {`
261	`$lien_date= "<td class=\"".$class."\">".$day->thisDay()."\n";`	263	`$lien_date= "<td class=\"".$class."\">".$day->thisDay()."\n";`
262	`if ($day->isSelected() ) {`	264	`if ($day->isSelected() ) {`
263	`$evenements=$day->getEntry();`	265	`$evenements=$day->getEntry();`
264	`$id_fiches=array();`	266	`$id_fiches=array();`
265	`while ($ligne_evenement=array_pop($evenements)) {`	267	`while ($ligne_evenement=array_pop($evenements)) {`
266	`$id_fiches[]=$ligne_evenement->bf_id_fiche;`	268	`$id_fiches[]=$ligne_evenement->bf_id_fiche;`
267	`}`	269	`}`
268	`$url->addQueryString ('id_fiches',$id_fiches);`	270	`$url->addQueryString ('id_fiches',$id_fiches);`
269	`$link = $url->getUrl();`	271	`$link = $url->getUrl();`
270	`$lien_date= "<td class=\"".$class."\"><a href=\"".$link."\">".$day->thisDay()."</a>\n";`	272	`$lien_date= "<td class=\"".$class."\"><a href=\"".$link."\">".$day->thisDay()."</a>\n";`
271	`$url->removeQueryString ('id_fiches');`	273	`$url->removeQueryString ('id_fiches');`
272	`}`	274	`}`
273	`$retour.=$lien_date;`	275	`$retour.=$lien_date;`
274	`}`	276	`}`
275		277
276	`$retour.= ( "</td>\n" );`	278	`$retour.= ( "</td>\n" );`
277		279
278	`// isLast() to find end of week`	280	`// isLast() to find end of week`
279	`if ( $day->isLast() )`	281	`if ( $day->isLast() )`
280	`$retour.= ( "</tr>\n" );`	282	`$retour.= ( "</tr>\n" );`
281	`}`	283	`}`
282		284
283	`$retour.= "</table>";`	285	`$retour.= "</table>";`
284		286
285		287
286	`}`	288	`}`
287		289
288	`// Vue detail`	290	`// Vue detail`
289		291
290	`if ((isset($_GET['id_fiches']))) {`	292	`if ((isset($_GET['id_fiches']))) {`
291	`// Ajout des styles du bazar`	293	`// Ajout des styles du bazar`
292	`if (defined('PAP_VERSION')) { //si on est dans Papyrus`	294	`if (defined('PAP_VERSION')) { //si on est dans Papyrus`
293	`GEN_stockerStyleExterne( 'bazar_interne', 'client/bazar/bazar.interne.css');`	295	`GEN_stockerStyleExterne( 'bazar_interne2', 'client/bazar/bazar.interne.css');`
294	`}`	296	`}`
295		297
296	`// Ajout d'un titre pour la page avec la date`	298	`// Ajout d'un titre pour la page avec la date`
297	`$jours = array ('lundi', 'mardi', 'mercredi', 'jeudi', 'vendredi', 'samedi', 'dimanche') ;`	299	`$jours = array ('lundi', 'mardi', 'mercredi', 'jeudi', 'vendredi', 'samedi', 'dimanche') ;`
298	`$mois = array ('janvier', 'février', 'mars', 'avril', 'mai', 'juin', 'juillet', 'août', 'septembre',`	300	`$mois = array ('janvier', 'février', 'mars', 'avril', 'mai', 'juin', 'juillet', 'août', 'septembre',`
299	`'octobre', 'novembre', 'décembre') ;`	301	`'octobre', 'novembre', 'décembre') ;`
300	`$timestamp = strtotime ($_GET['y'].'/'.$_GET['m'].'/'.$_GET['d']) ;`	302	`$timestamp = strtotime ($_GET['y'].'/'.$_GET['m'].'/'.$_GET['d']) ;`
301	`$GLOBALS['_PAPYRUS_']['rendu']['CONTENU_CORPS'] = '<h1>'.$jours[date('w', $timestamp)].`	303	`$GLOBALS['_PAPYRUS_']['rendu']['CONTENU_CORPS'] = '<h1>'.$jours[date('w', $timestamp)].`
302	`' '.$_GET['d'].' '.$mois[$_GET['m']-1].' '.$_GET['y'].'</h1>' ;`	304	`' '.$_GET['d'].' '.$mois[$_GET['m']-1].' '.$_GET['y'].'</h1>' ;`
303	`$GLOBALS['_PAPYRUS_']['rendu']['CONTENU_CORPS'] .= baz_voir_fiches(0,$_GET['id_fiches'] );`	305	`$GLOBALS['_PAPYRUS_']['rendu']['CONTENU_CORPS'] .= baz_voir_fiches(0,$_GET['id_fiches'] );`
304	`}`	306	`}`
305		307
306	`return $retour;`	308	`return $retour;`
307		309
308	`}`	310	`}`
309		311
310	`?>`	312	`?>`

Subversion Repositories Applications.bazar

(root)/branches/livraison_menes/bibliotheque/bazar.fonct.cal.php @ 188 – Rev 161 → 183