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> '."\n";
|
1164 |
$res .= '<a href="'.$GLOBALS['_BAZAR_']['url']->getURL().'">('.BAZ_MODIFIER.')</a> '."\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
|