WebSVN – Applications.bazar – Diff – //branches/v3.0_(aha)/bibliotheque/bazar.fonct.rss.php



				$requete = 'UPDATE bazar_fiche SET bf_nb_consultations=bf_nb_consultations+1 WHERE bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];
				$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
			}
		}
	}
	
	$requete = 'SELECT * FROM bazar_fiche,bazar_nature WHERE bf_ce_nature=bn_id_nature and bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];

 
	if (isset($GLOBALS['_BAZAR_']['langue'])) $requete .= ' and bn_ce_i18n like "'.$GLOBALS['_BAZAR_']['langue'].'"';
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;

	if (isset ($GLOBALS['_BAZAR_']['image_titre']) && $GLOBALS['_BAZAR_']['image_titre']!='') {
		$res .= '<img class="BAZ_img_titre" src="client/bazar/images/'.$GLOBALS['_BAZAR_']['image_titre'].'" alt="'.$ligne['bn_label_nature'].'" />'.'<br />'."\n";
	}
	//affiche le texte sinon
	else {
		$res .= '<h1 class="BAZ_titre BAZ_titre_'.$GLOBALS['_BAZAR_']['class'].'">'.$ligne['bn_label_nature'].'</h1>'."\n";
	}
	$GLOBALS['_BAZAR_']['annonceur'] = $ligne['bf_ce_utilisateur'] ;
	//si le template existe, on genere le template
	if ((file_exists(BAZ_CHEMIN_APPLI.'templates/'.$GLOBALS['_BAZAR_']['typeannonce'].'-fiche.php'))) {
		include_once(BAZ_CHEMIN_APPLI.'templates/'.$GLOBALS['_BAZAR_']['typeannonce'].'-fiche.php');

			$res .= '<div class="BAZ_fiche_image BAZ_fiche_image_'.$GLOBALS['_BAZAR_']['class'].'">'."\n";
			$res .= '<img class="BAZ_image" src="client/bazar/images/'.$GLOBALS['_BAZAR_']['image_logo'].'" border=0 alt="'.BAZ_TEXTE_IMG_ALTERNATIF.'" width="130" height="130" />'."\n";
			$res .= '</div>'."\n";
		}

		
		//$res .= '<div class="BAZ_description BAZ_description_'.$GLOBALS['_BAZAR_']['class'].'">'.nl2br($ligne['bf_description']).'</div>'."\n";

		$tableau=baz_valeurs_template($GLOBALS['_BAZAR_']['template']);
		
		/** Boucle d affichage des resultats

* @return  string Le code du flux RSS
*/
function gen_RSS($typeannonce='', $nbitem='', $emetteur='', $valide=1, $requeteSQL='', $requeteSQLFrom = '', $requeteWhereListe = '', $categorie_nature='', $order = '') {
	// generation de la requete MySQL personnalisee
	$req_where=0;
	$requete = 'SELECT DISTINCT bf_id_fiche, bf_titre, bf_date_debut_validite_fiche, bf_description,bf_date_debut_evenement, bn_label_nature, bf_date_creation_fiche, bf_ce_utilisateur '.
				'FROM bazar_fiche, bazar_nature '.$requeteSQLFrom.' WHERE '.$requeteWhereListe;
	if ($valide!=2) {
		$requete .= 'bf_statut_fiche='.$valide;
		$req_where=1;
	}

				$xml .= XML_Util::createCDataSection(encoder_en_utf8($ligne['bf_description']));
			}
			$xml .= "\r\n        ";
			$xml .= XML_Util::createEndElement ('description');
			$xml .= "\r\n        ";
			/*if ($ligne['bf_date_debut_validite_fiche'] != '0000-00-00' && 
			$ligne['bf_date_debut_validite_fiche']>$ligne['bf_date_creation_fiche']) {
				$date_pub =  $ligne['bf_date_debut_validite_fiche'];	
			} else $date_pub = $ligne['bf_date_creation_fiche'] ;*/
			$date_pub = $ligne['bf_date_debut_evenement'] ;
			$xml .= XML_Util::createTag ('pubDate', null, strftime('%a, %d %b %Y %H:%M:%S GMT',strtotime($date_pub)));
			$xml .= "\r\n      ";
			$xml .= XML_Util::createEndElement ('item');
		}
	}

Subversion Repositories Applications.bazar

(root)//branches/v3.0_(aha)/bibliotheque/bazar.fonct.rss.php – Rev 411 → 417

Rev 411		Rev 417
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
165	`$requete = 'SELECT * FROM bazar_fiche,bazar_nature WHERE bf_ce_nature=bn_id_nature and bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];`	166	`$requete = 'SELECT * FROM bazar_fiche,bazar_nature WHERE bf_ce_nature=bn_id_nature and bf_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'];`
Line 166...		Line 167...
166		167
167	`if (isset($GLOBALS['_BAZAR_']['langue'])) $requete .= ' and bn_ce_i18n like "'.$GLOBALS['_BAZAR_']['langue'].'"';`	168	`if (isset($GLOBALS['_BAZAR_']['langue'])) $requete .= ' and bn_ce_i18n like "'.$GLOBALS['_BAZAR_']['langue'].'"';`
168	`$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;`	169	`$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;`
Line 195...		Line 196...
195	`if (isset ($GLOBALS['_BAZAR_']['image_titre']) && $GLOBALS['_BAZAR_']['image_titre']!='') {`	196	`if (isset ($GLOBALS['_BAZAR_']['image_titre']) && $GLOBALS['_BAZAR_']['image_titre']!='') {`
196	`$res .= '<img class="BAZ_img_titre" src="client/bazar/images/'.$GLOBALS['_BAZAR_']['image_titre'].'" alt="'.$ligne['bn_label_nature'].'" />'.'<br />'."\n";`	197	`$res .= '<img class="BAZ_img_titre" src="client/bazar/images/'.$GLOBALS['_BAZAR_']['image_titre'].'" alt="'.$ligne['bn_label_nature'].'" />'.'<br />'."\n";`
197	`}`	198	`}`
198	`//affiche le texte sinon`	199	`//affiche le texte sinon`
199	`else {`	200	`else {`
200	`$res .= '<h2 class="BAZ_titre BAZ_titre_'.$GLOBALS['_BAZAR_']['class'].'">'.$ligne['bn_label_nature'].'</h2>'."\n";`	201	`$res .= '<h1 class="BAZ_titre BAZ_titre_'.$GLOBALS['_BAZAR_']['class'].'">'.$ligne['bn_label_nature'].'</h1>'."\n";`
201	`}`	202	`}`
202	`$GLOBALS['_BAZAR_']['annonceur'] = $ligne['bf_ce_utilisateur'] ;`	203	`$GLOBALS['_BAZAR_']['annonceur'] = $ligne['bf_ce_utilisateur'] ;`
203	`//si le template existe, on genere le template`	204	`//si le template existe, on genere le template`
204	`if ((file_exists(BAZ_CHEMIN_APPLI.'templates/'.$GLOBALS['_BAZAR_']['typeannonce'].'-fiche.php'))) {`	205	`if ((file_exists(BAZ_CHEMIN_APPLI.'templates/'.$GLOBALS['_BAZAR_']['typeannonce'].'-fiche.php'))) {`
205	`include_once(BAZ_CHEMIN_APPLI.'templates/'.$GLOBALS['_BAZAR_']['typeannonce'].'-fiche.php');`	206	`include_once(BAZ_CHEMIN_APPLI.'templates/'.$GLOBALS['_BAZAR_']['typeannonce'].'-fiche.php');`
Line 220...		Line 221...
220	`$res .= '<div class="BAZ_fiche_image BAZ_fiche_image_'.$GLOBALS['_BAZAR_']['class'].'">'."\n";`	221	`$res .= '<div class="BAZ_fiche_image BAZ_fiche_image_'.$GLOBALS['_BAZAR_']['class'].'">'."\n";`
221	`$res .= '<img class="BAZ_image" src="client/bazar/images/'.$GLOBALS['_BAZAR_']['image_logo'].'" border=0 alt="'.BAZ_TEXTE_IMG_ALTERNATIF.'" width="130" height="130" />'."\n";`	222	`$res .= '<img class="BAZ_image" src="client/bazar/images/'.$GLOBALS['_BAZAR_']['image_logo'].'" border=0 alt="'.BAZ_TEXTE_IMG_ALTERNATIF.'" width="130" height="130" />'."\n";`
222	`$res .= '</div>'."\n";`	223	`$res .= '</div>'."\n";`
223	`}`	224	`}`
Line 224...		Line 225...
224		225
225	`$res .= '<div class="BAZ_description BAZ_description_'.$GLOBALS['_BAZAR_']['class'].'">'.nl2br($ligne['bf_description']).'</div>'."\n";`	226	`//$res .= '<div class="BAZ_description BAZ_description_'.$GLOBALS['_BAZAR_']['class'].'">'.nl2br($ligne['bf_description']).'</div>'."\n";`
Line 226...		Line 227...
226	`$tableau=baz_valeurs_template($GLOBALS['_BAZAR_']['template']);`	227	`$tableau=baz_valeurs_template($GLOBALS['_BAZAR_']['template']);`
227		228
228	`/** Boucle d affichage des resultats`	229	`/** Boucle d affichage des resultats`
Line 615...		Line 616...
615	`* @return string Le code du flux RSS`	616	`* @return string Le code du flux RSS`
616	`*/`	617	`*/`
617	`function gen_RSS($typeannonce='', $nbitem='', $emetteur='', $valide=1, $requeteSQL='', $requeteSQLFrom = '', $requeteWhereListe = '', $categorie_nature='', $order = '') {`	618	`function gen_RSS($typeannonce='', $nbitem='', $emetteur='', $valide=1, $requeteSQL='', $requeteSQLFrom = '', $requeteWhereListe = '', $categorie_nature='', $order = '') {`
618	`// generation de la requete MySQL personnalisee`	619	`// generation de la requete MySQL personnalisee`
619	`$req_where=0;`	620	`$req_where=0;`
620	`$requete = 'SELECT DISTINCT bf_id_fiche, bf_titre, bf_date_debut_validite_fiche, bf_description, bn_label_nature, bf_date_creation_fiche, bf_ce_utilisateur '.`	621	`$requete = 'SELECT DISTINCT bf_id_fiche, bf_titre, bf_date_debut_validite_fiche, bf_description,bf_date_debut_evenement, bn_label_nature, bf_date_creation_fiche, bf_ce_utilisateur '.`
621	`'FROM bazar_fiche, bazar_nature '.$requeteSQLFrom.' WHERE '.$requeteWhereListe;`	622	`'FROM bazar_fiche, bazar_nature '.$requeteSQLFrom.' WHERE '.$requeteWhereListe;`
622	`if ($valide!=2) {`	623	`if ($valide!=2) {`
623	`$requete .= 'bf_statut_fiche='.$valide;`	624	`$requete .= 'bf_statut_fiche='.$valide;`
624	`$req_where=1;`	625	`$req_where=1;`
625	`}`	626	`}`
Line 766...		Line 767...
766	`$xml .= XML_Util::createCDataSection(encoder_en_utf8($ligne['bf_description']));`	767	`$xml .= XML_Util::createCDataSection(encoder_en_utf8($ligne['bf_description']));`
767	`}`	768	`}`
768	`$xml .= "\r\n ";`	769	`$xml .= "\r\n ";`
769	`$xml .= XML_Util::createEndElement ('description');`	770	`$xml .= XML_Util::createEndElement ('description');`
770	`$xml .= "\r\n ";`	771	`$xml .= "\r\n ";`
771	`if ($ligne['bf_date_debut_validite_fiche'] != '0000-00-00' &&`	772	`/*if ($ligne['bf_date_debut_validite_fiche'] != '0000-00-00' &&`
772	`$ligne['bf_date_debut_validite_fiche']>$ligne['bf_date_creation_fiche']) {`	773	`$ligne['bf_date_debut_validite_fiche']>$ligne['bf_date_creation_fiche']) {`
773	`$date_pub = $ligne['bf_date_debut_validite_fiche'];`	774	`$date_pub = $ligne['bf_date_debut_validite_fiche'];`
774	`} else $date_pub = $ligne['bf_date_creation_fiche'] ;`	775	`} else $date_pub = $ligne['bf_date_creation_fiche'] ;*/`
-		776	`$date_pub = $ligne['bf_date_debut_evenement'] ;`
775	`$xml .= XML_Util::createTag ('pubDate', null, strftime('%a, %d %b %Y %H:%M:%S GMT',strtotime($date_pub)));`	777	`$xml .= XML_Util::createTag ('pubDate', null, strftime('%a, %d %b %Y %H:%M:%S GMT',strtotime($date_pub)));`
776	`$xml .= "\r\n ";`	778	`$xml .= "\r\n ";`
777	`$xml .= XML_Util::createEndElement ('item');`	779	`$xml .= XML_Util::createEndElement ('item');`
778	`}`	780	`}`
779	`}`	781	`}`