Subversion Repositories Applications.bazar

/*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.rss.php,v 1.48 2006-05-17 09:50:13 alexandre_tb Exp $

/**

* 

*@package bazar

//Auteur original :

*@author        Alexandre GRANIER <alexandre@tela-botanica.org>

*@author        Florian Schmitt <florian@ecole-et-nature.org>

//Autres auteurs :

*@copyright     Tela-Botanica 2000-2006

*@version       $Revision: 1.48 $

// +------------------------------------------------------------------------------------------------------+

*/

// +------------------------------------------------------------------------------------------------------+

// |                                            ENTETE du PROGRAMME                                       |

// +------------------------------------------------------------------------------------------------------+

require_once BAZ_CHEMIN_APPLI.'bibliotheque/bazar.fonct.php';

				$xml .= $ligne['bf_description'] ;

			$champs_requete = 'bn_id_nature' ;

				$_REQUEST['nature'] = $GLOBALS['_BAZAR_']['categorie_nature'];

				$champs_requete = 'bn_ce_id_menu' ;

	//affichage du formulaire

						$requeteWhereListe .= ' AND bfvl_ce_liste='.$tableau[$i]['nom_bdd'] ; // Numéro de la liste

					}

				}	

			} else {

					$case_coche = true;

		$requeteFrom = ', bazar_fiche_valeur_liste ' ;

		//$requeteWhereListe .= ' AND bfvl_valeur IN ()' ;

	}

		$res .= baz_liste_pagine_HTML($typedefiche, '', $_REQUEST['personne'], $valides, $requeteSQL, $requeteFrom, $requeteWhere);

		*/

/**

 * Cette fonction renvoie du HTML

 */

function baz_liste_pagine_HTML($typeannonce, $nbitem, $emetteur, $valide, $requeteSQL = '', $requeteFrom = '', $requeteWhere = '') {

	// generation de la requete MySQL personnalisee

	$req_where=0;

	$requete = 'SELECT DISTINCT bf_id_fiche, bf_titre, bf_date_debut_validite_fiche '.

				'FROM bazar_fiche, bazar_nature '.$requeteFrom.' WHERE '.$requeteWhere;

	if ($valide!=2) {

		$requete .= 'bf_statut_fiche='.$valide;

		$req_where=1;

	}

	if (!is_array ($typeannonce) && $typeannonce!='' and $typeannonce!='toutes') {

		if ($req_where==1) {$requete .= ' AND ';}

		$requete .= 'bf_ce_nature='.$typeannonce;

		$req_where=1;

		//le nom du flux devient le type d'annonce

		$nomflux = $typeannonce;

	}

	// Cas où il y plusieurs type d annonce demande

	if (is_array ($typeannonce)) {

		if ($req_where==1) {$requete .= ' AND ';}

		$requete .= 'bf_ce_nature IN (' ;

		$chaine = '';

		foreach ($typeannonce as $valeur) $chaine .= '"'.$valeur.'",' ;

		$requete .= substr ($chaine, 0, strlen ($chaine)-1) ; 

		$requete .= ') ';

	}

	$utilisateur = new Administrateur_bazar ($GLOBALS['AUTH']) ;

	if ($valide!=0) {

		if ($utilisateur->isSuperAdmin()) {

			$req_where=1;

		} else {

			if ($req_where==1) {

				$requete .= ' AND ';

			}

			$requete .= '(bf_date_debut_validite_fiche<=NOW() or bf_date_debut_validite_fiche="0000-00-00")'.

						' AND (bf_date_fin_validite_fiche>=NOW() or bf_date_fin_validite_fiche="0000-00-00") AND bn_id_nature=bf_ce_nature';

		}

	}

	else $nomflux .= BAZ_A_MODERER;

	if ($emetteur!='' && $emetteur!='tous') {

		if ($req_where==1) {$requete .= ' AND ';}

		$requete .= 'bf_ce_utilisateur='.$emetteur;

		$req_where=1;

		//requete pour afficher le nom de la structure

		$requetenom = 'SELECT '.BAZ_CHAMPS_NOM.', '.BAZ_CHAMPS_PRENOM.' FROM '.

						BAZ_ANNUAIRE.' WHERE '.BAZ_CHAMPS_ID.'='.$emetteur;

		$resultat = $GLOBALS['_BAZAR_']['db']->query($requetenom) ;

		if (DB::isError($resultat)) {

			die ($resultat->getMessage().$resultat->getDebugInfo()) ;

		}

		$ligne = $resultat->fetchRow(DB_FETCHMODE_ASSOC);

		$nomflux .= ' ('.$ligne[BAZ_CHAMPS_NOM].' '.$ligne[BAZ_CHAMPS_PRENOM].')';

	}

	if ($requeteSQL!='') {

		if ($req_where==1) {$requete .= ' AND ';}

		$requete .= '('.$requeteSQL.')';

		$req_where=1;

	}

	$requete .= ' ORDER BY  bf_date_debut_validite_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';

	if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}

	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;

	if (DB::isError($resultat)) {

		die ($resultat->getMessage().$resultat->getDebugInfo()) ;

	}

	$res = '<br /><h4>'.BAZ_IL_Y_A.($resultat->numRows()).' '.BAZ_FICHES_CORRESPONDANTES.'</h4><br />'."\n";

	$res .= '<ul>' ;

	$GLOBALS['_BAZAR_']['url']->addQueryString('action', BAZ_VOIR_FICHE);

	$donnees = array();

	while ($ligne = $resultat->fetchRow(DB_FETCHMODE_OBJECT)) {

		$GLOBALS['_BAZAR_']['url']->addQueryString('id_fiche', $ligne->bf_id_fiche) ;

		array_push ($donnees, array ($ligne->bf_id_fiche,$ligne->bf_titre));

		//$res .= '<li><a href="'.$GLOBALS['_BAZAR_']['url']->getURL().'">'.$ligne->bf_titre.'</a></li>'."\n" ;

	}

	// Mise en place du Pager

	include_once 'Pager/Pager.php';

	$params = array(

    'mode'       => BAZ_MODE_DIVISION,

    'perPage'    => BAZ_NOMBRE_RES_PAR_PAGE,

    'delta'      => BAZ_DELTA,

    'httpMethod' => 'GET',

    'extraVars' => $_REQUEST,

    'altNext' => BAZ_SUIVANT,

    'altPrev' => BAZ_PRECEDENT,

    'nextImg' => BAZ_SUIVANT,

    'prevImg' => BAZ_PRECEDENT,

    'itemData'   => $donnees

	);

	$pager = & Pager::factory($params);

	$data  = $pager->getPageData();

	$links = $pager->getLinks();

	foreach ($data as $valeur) {

		$GLOBALS['_BAZAR_']['url']->addQueryString('id_fiche', $valeur[0]) ;

		$res .= '<li><a href="'.$GLOBALS['_BAZAR_']['url']->getURL().'">'.$valeur[1].'</a></li>'."\n" ;

	}

	$res .= '</ul>';

	$res .= $pager->links;

	return $res ;

}

/* +--Fin du code ----------------------------------------------------------------------------------------+

*

* $Log: not supported by cvs2svn $

* +-- Fin du code ----------------------------------------------------------------------------------------+

*/