Subversion Repositories Applications.bazar

Rev

Rev 251 | Rev 263 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 251 Rev 260
Line 17... Line 17...
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.rss.php,v 1.83 2007-06-04 15:26:02 alexandre_tb Exp $
 22 
// CVS : $Id: bazar.fonct.rss.php,v 1.84 2007-06-25 09:56:55 alexandre_tb Exp $
23 
/**
 23 
/**
24 
*
24 
*
25 
*@package bazar
 25 
*@package bazar
26 
//Auteur original :
 26 
//Auteur original :
27 
*@author        Alexandre GRANIER <alexandre@tela-botanica.org>
 27 
*@author        Alexandre GRANIER <alexandre@tela-botanica.org>
28 
*@author        Florian Schmitt <florian@ecole-et-nature.org>
 28 
*@author        Florian Schmitt <florian@ecole-et-nature.org>
29 
//Autres auteurs :
 29 
//Autres auteurs :
30 
*@copyright     Tela-Botanica 2000-2006
 30 
*@copyright     Tela-Botanica 2000-2006
31 
*@version       $Revision: 1.83 $
 31 
*@version       $Revision: 1.84 $
32 
// +------------------------------------------------------------------------------------------------------+
 32 
// +------------------------------------------------------------------------------------------------------+
33 
*/
 33 
*/
Line 34... Line 34...
34 
 
 34 
 
35 
// +------------------------------------------------------------------------------------------------------+
 35 
// +------------------------------------------------------------------------------------------------------+
Line 160... Line 160...
160 
				$requete = 'UPDATE bazar_fiche SET bf_nb_consultations=bf_nb_consultations+1 WHERE bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];
 160 
				$requete = 'UPDATE bazar_fiche SET bf_nb_consultations=bf_nb_consultations+1 WHERE bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];
161 
				$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
 161 
				$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
162 
			}
 162 
			}
163 
		}
 163 
		}
164 
	}
 164 
	}
165 
	$requete = 'SELECT * FROM bazar_fiche WHERE bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];
 165 
	$requete = 'SELECT *,bn_label_nature FROM bazar_fiche,bazar_nature WHERE bf_ce_nature=bn_id_nature and bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];
Line 166... Line 166...
166
166
167 
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
 167 
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
168 
	(DB::isError($resultat)) ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat->getMessage(), $requete))
 168 
	(DB::isError($resultat)) ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat->getMessage(), $requete))
Line 169... Line 169...
169 
	    : '';
 169 
	    : '';
170
170
171 
	$ligne = $resultat->fetchRow(DB_FETCHMODE_ASSOC) ;
 171 
	$ligne = $resultat->fetchRow(DB_FETCHMODE_ASSOC) ;
172 
	if (!isset($GLOBALS['_BAZAR_']['typeannonce'])) $GLOBALS['_BAZAR_']['typeannonce'] = $ligne['bf_ce_nature'];
 172 
	if (!isset($GLOBALS['_BAZAR_']['typeannonce'])) $GLOBALS['_BAZAR_']['typeannonce'] = $ligne['bn_label_nature'];
173 
	if (!isset($GLOBALS['_BAZAR_']['fiche_valide'])) $GLOBALS['_BAZAR_']['fiche_valide'] = $ligne['bf_statut_fiche'];
 173 
	if (!isset($GLOBALS['_BAZAR_']['fiche_valide'])) $GLOBALS['_BAZAR_']['fiche_valide'] = $ligne['bf_statut_fiche'];
- 
 
 174 
	//on verifie si l'utilisateur est administrateur
- 
 
 175 
	$est_admin=0;
- 
 
 176
- 
 
 177 
	// Si on vient de l applette calendrier, $GLOBALS['_BAZAR_']['id_typeannonce'] est vide ...
- 
 
 178 
	// mais on dispose de la constante BAZ_NUM_ANNONCE_CALENDRIER
174 
	//on verifie si l'utilisateur est administrateur
 179 
	if ($GLOBALS['_BAZAR_']['id_typeannonce'] == '' && defined('BAZ_NUM_ANNONCE_CALENDRIER'))  $GLOBALS['_BAZAR_']['id_typeannonce'] = BAZ_NUM_ANNONCE_CALENDRIER;
- 
 
 180
- 
 
 181 
	$requete='SELECT bn_id_nature, bn_template, bn_commentaire, bn_label_class FROM bazar_nature ';
175 
	$est_admin=0;
 182 
	if ($GLOBALS['_BAZAR_']['id_typeannonce'] != 'toutes') $requete .= 'WHERE bn_id_nature='.$GLOBALS['_BAZAR_']['id_typeannonce'];
176 
	$requete='SELECT bn_id_nature, bn_template, bn_commentaire, bn_label_class FROM bazar_nature WHERE bn_id_nature='.$GLOBALS['_BAZAR_']['id_typeannonce'];
 183
177 
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
 184 
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
178 
	if (DB::isError($resultat)) {
 185 
	if (DB::isError($resultat)) {
179 
		return ($resultat->getMessage().$resultat->getDebugInfo()) ;
 186 
		return ($resultat->getMessage().$resultat->getDebugInfo()) ;
Line 954... Line 961...
954 
 
 961 
 
955 
	// Ajout de la table bazar_fiche_liste_valeur dans le from de la requete
 962 
	// Ajout de la table bazar_fiche_liste_valeur dans le from de la requete
956 
	$case_coche = false ;
 963 
	$case_coche = false ;
957 
	$nb_jointures=0;
 964 
	$nb_jointures=0;
- 
 
 965 
	$requeteFrom = '' ;
958 
	$requeteFrom = '' ;
 966 
	$requeteWhere = ' bn_ce_id_menu IN ('.$GLOBALS['_BAZAR_']['categorie_nature'].') ';
- 
 
 967 
	if ($GLOBALS['_BAZAR_']['id_typeannonce'] != 'toutes') $requeteWhere .= 'AND bn_id_nature='.$GLOBALS['_BAZAR_']['id_typeannonce'] ;
- 
 
 968 
	$requeteWhere .= ' AND bn_id_nature=bf_ce_nature AND ' ;
959 
	$requeteWhere = ' bn_ce_id_menu IN ('.$GLOBALS['_BAZAR_']['categorie_nature'].') AND bn_id_nature='.$GLOBALS['_BAZAR_']['id_typeannonce'].' AND bn_id_nature=bf_ce_nature AND ' ;
 969
Line 960... Line 970...
960 
	$requeteWhereListe = '' ;
 970 
	$requeteWhereListe = '' ;
961
971
962 
 	if ( isset($tableau) ) {
 972 
 	if ( isset($tableau) ) {
Line 1146... Line 1156...
1146 
    	foreach ($data as $valeur) {
 1156 
    	foreach ($data as $valeur) {
1147 
	        $res .='<li class="BAZ_'.$valeur['bn_label_class'].'">'."\n";
 1157 
	        $res .='<li class="BAZ_'.$valeur['bn_label_class'].'">'."\n";
1148 
	        $GLOBALS['_BAZAR_']['url']->addQueryString('id_fiche', $valeur['bf_id_fiche']) ;
 1158 
	        $GLOBALS['_BAZAR_']['url']->addQueryString('id_fiche', $valeur['bf_id_fiche']) ;
1149 
	        if ($utilisateur->isSuperAdmin() || $GLOBALS['id_user']==$valeur['bf_ce_utilisateur']) {
 1159 
	        if ($utilisateur->isSuperAdmin() || $GLOBALS['id_user']==$valeur['bf_ce_utilisateur']) {
1150 
	            $GLOBALS['_BAZAR_']['url']->addQueryString('action', BAZ_ACTION_MODIFIER);
 1160 
	            $GLOBALS['_BAZAR_']['url']->addQueryString('action', BAZ_ACTION_MODIFIER);
1151 
	            $GLOBALS['_BAZAR_']['url']->addQueryString('typeannonce', $GLOBALS['_BAZAR_']['id_typeannonce']);
 1161 
	            $GLOBALS['_BAZAR_']['url']->addQueryString('typeannonce', $valeur['bf_ce_nature']);
1152 
	            $GLOBALS['_BAZAR_']['url']->removeQueryString('personnes');
 1162 
	            $GLOBALS['_BAZAR_']['url']->removeQueryString('personnes');
1153 
	            $GLOBALS['_BAZAR_']['url']->removeQueryString('recherche_effectuee');
 1163 
	            $GLOBALS['_BAZAR_']['url']->removeQueryString('recherche_effectuee');
1154 
	            $res .= '<a href="'.$GLOBALS['_BAZAR_']['url']->getURL().'">('.BAZ_MODIFIER.')</a>&nbsp;'."\n";
 1164 
	            $res .= '<a href="'.$GLOBALS['_BAZAR_']['url']->getURL().'">('.BAZ_MODIFIER.')</a>&nbsp;'."\n";
1155 
	            $GLOBALS['_BAZAR_']['url']->removeQueryString('action');
 1165 
	            $GLOBALS['_BAZAR_']['url']->removeQueryString('action');
1156 
	            $GLOBALS['_BAZAR_']['url']->addQueryString('action', BAZ_ACTION_SUPPRESSION);
 1166 
	            $GLOBALS['_BAZAR_']['url']->addQueryString('action', BAZ_ACTION_SUPPRESSION);
Line 1175... Line 1185...
1175 
}
 1185 
}
Line 1176... Line 1186...
1176 
 
 1186 
 
1177 
/* +--Fin du code ----------------------------------------------------------------------------------------+
 1187 
/* +--Fin du code ----------------------------------------------------------------------------------------+
1178 
*
 1188 
*
- 
 
 1189 
* $Log: not supported by cvs2svn $
- 
 
 1190 
* Revision 1.83  2007-06-04 15:26:02  alexandre_tb
- 
 
 1191 
* remplacement d un die en return
1179 
* $Log: not supported by cvs2svn $
 1192 
*
1180 
* Revision 1.82  2007/04/20 12:47:42  florian
 1193 
* Revision 1.82  2007/04/20 12:47:42  florian
1181 
* correction bugs suite au merge
 1194 
* correction bugs suite au merge
1182 
*
 1195 
*
1183 
* Revision 1.81  2007/04/20 09:59:41  florian
 1196 
* Revision 1.81  2007/04/20 09:59:41  florian