| Line 339... |
Line 339... |
| 339 |
if ( $est_admin ) {
|
339 |
if ( $est_admin ) {
|
| 340 |
$lien_publie = &$GLOBALS['_BAZAR_']['url'];
|
340 |
$lien_publie = &$GLOBALS['_BAZAR_']['url'];
|
| 341 |
$lien_publie->addQueryString(BAZ_VARIABLE_ACTION, BAZ_VOIR_FICHE);
|
341 |
$lien_publie->addQueryString(BAZ_VARIABLE_ACTION, BAZ_VOIR_FICHE);
|
| 342 |
$lien_publie->addQueryString('id_fiche', $GLOBALS['_BAZAR_']['id_fiche']);
|
342 |
$lien_publie->addQueryString('id_fiche', $GLOBALS['_BAZAR_']['id_fiche']);
|
| 343 |
$lien_publie->addQueryString('typeannonce', $ligne['bf_ce_nature']);
|
343 |
$lien_publie->addQueryString('typeannonce', $ligne['bf_ce_nature']);
|
| - |
|
344 |
|
| 344 |
if ($GLOBALS['_BAZAR_']['fiche_valide']==0||$GLOBALS['_BAZAR_']['fiche_valide']==2) {
|
345 |
if ($GLOBALS['_BAZAR_']['fiche_valide']==0||$GLOBALS['_BAZAR_']['fiche_valide']==2) {
|
| 345 |
$lien_publie->addQueryString('publiee', 1);
|
346 |
$lien_publie->addQueryString('publiee', 1);
|
| 346 |
$label_publie=BAZ_VALIDER_LA_FICHE;
|
347 |
$label_publie=BAZ_VALIDER_LA_FICHE;
|
| 347 |
$class_publie='_valider';
|
348 |
$class_publie='_valider';
|
| - |
|
349 |
$res .= '<form method="post" action="'.$lien_publie->getURL().'" ><li><label class="BAZ_label" id="label_validite" for="date_validite"> Date de validité :</label><input id="date_validite" name="date_validite" type="text" value="'.$ligne['bf_date_debut_validite_fiche'].'" /></li> <li><input class="bouton_valider" type="submit" value="Valider la fiche" /></li></form>';
|
| 348 |
} elseif ($GLOBALS['_BAZAR_']['fiche_valide']==1) {
|
350 |
} elseif ($GLOBALS['_BAZAR_']['fiche_valide']==1) {
|
| - |
|
351 |
$lien_publie->addQueryString('publiee', 1);
|
| - |
|
352 |
$res .= '<form method="post" action="'.$lien_publie->getURL().'" ><li><label class="BAZ_label" id="label_validite" for="date_validite"> Date de validité :</label><input id="date_validite" name="date_validite" type="text" value="'.$ligne['bf_date_debut_validite_fiche'].'" /> <input type="submit" class="bouton_valider" value="Modifier" /></form>';
|
| - |
|
353 |
$lien_publie->removeQueryString('publiee');
|
| 349 |
$lien_publie->addQueryString('publiee', 0);
|
354 |
$lien_publie->addQueryString('publiee', 0);
|
| 350 |
$label_publie=BAZ_INVALIDER_LA_FICHE;
|
355 |
$label_publie=BAZ_INVALIDER_LA_FICHE;
|
| 351 |
$class_publie='_invalider';
|
356 |
$class_publie='_invalider';
|
| - |
|
357 |
$res .= '<li class="BAZ_liste'.$class_publie.'"><a href="'.$lien_publie->getURL().'">'.$label_publie.'</a></li>'."\n";
|
| 352 |
}
|
358 |
}
|
| 353 |
$res .= '<li class="BAZ_liste'.$class_publie.'"><a href="'.$lien_publie->getURL().'">'.$label_publie.'</a></li>'."\n";
|
- |
|
| 354 |
$lien_publie->removeQueryString('publiee');
|
- |
|
| 355 |
}
|
359 |
}
|
| 356 |
$lien_modifier=$GLOBALS['_BAZAR_']['url'];
|
360 |
$lien_modifier=$GLOBALS['_BAZAR_']['url'];
|
| 357 |
$lien_modifier->addQueryString(BAZ_VARIABLE_ACTION, BAZ_ACTION_MODIFIER);
|
361 |
$lien_modifier->addQueryString(BAZ_VARIABLE_ACTION, BAZ_ACTION_MODIFIER);
|
| 358 |
$lien_modifier->addQueryString('id_fiche', $GLOBALS['_BAZAR_']['id_fiche']);
|
362 |
$lien_modifier->addQueryString('id_fiche', $GLOBALS['_BAZAR_']['id_fiche']);
|
| 359 |
$lien_modifier->addQueryString('typeannonce', $ligne['bf_ce_nature']);
|
363 |
$lien_modifier->addQueryString('typeannonce', $ligne['bf_ce_nature']);
|
| Line 372... |
Line 376... |
| 372 |
|
376 |
|
| Line 373... |
Line 377... |
| 373 |
}
|
377 |
}
|
| 374 |
|
378 |
|
| - |
|
379 |
// Nous vérifions comment est appelé la fonction
|
| - |
|
380 |
if ($danslappli == 0) {
|
| - |
|
381 |
$lien_voir=$GLOBALS['_BAZAR_']['url'];
|
| - |
|
382 |
$lien_voir->addQueryString(BAZ_VARIABLE_VOIR, BAZ_VOIR_CONSULTER);
|
| - |
|
383 |
$lien_voir->addQueryString('id_fiche', $GLOBALS['_BAZAR_']['id_fiche']);
|
| - |
|
384 |
$lien_voir->addQueryString(BAZ_VARIABLE_ACTION, BAZ_VOIR_FICHE);
|
| 375 |
// Nous vérifions comment est appelé la fonction
|
385 |
|
| 376 |
if ($danslappli == 0) {
|
386 |
$res .= '<div class="BAZ_lien_fiche"><a href="'.str_replace('carte_','',$lien_voir->getURL()).'" class="BAZ_lien">'.BAZ_VOIR_LA_FICHE.'</a></div>'."\n";
|
| Line 377... |
Line 387... |
| 377 |
$res .= '</div>'."\n";
|
387 |
$res .= '</div>'."\n";
|
| 378 |
} else if ($danslappli == 1 ) {
|
388 |
} else if ($danslappli == 1 ) {
|
| 379 |
|
389 |
|
| Line 422... |
Line 432... |
| 422 |
$res .='</p>'."\n";
|
432 |
$res .='</p>'."\n";
|
| 423 |
$res .= '</div>'."\n";
|
433 |
$res .= '</div>'."\n";
|
| 424 |
}
|
434 |
}
|
| Line 425... |
Line 435... |
| 425 |
|
435 |
|
| 426 |
// Ajout des commentaires, s'il le faut
|
436 |
// Ajout des commentaires, s'il le faut
|
| 427 |
if ($GLOBALS['_BAZAR_']['commentaire'] == 1) {
|
437 |
//if ($GLOBALS['_BAZAR_']['commentaire'] == 1) {
|
| 428 |
$res .= '<br />'."\n".'<div class="BAZ_cadre_fiche BAZ_cadre_fiche_'.$GLOBALS['_BAZAR_']['class'].'">'."\n";
|
438 |
$res .= '<br />'."\n".'<div class="BAZ_cadre_fiche BAZ_cadre_fiche_'.$GLOBALS['_BAZAR_']['class'].'">'."\n";
|
| 429 |
$res .= '<h2 class="BAZ_titre BAZ_titre_'.$GLOBALS['_BAZAR_']['class'].'">'.BAZ_LES_COMMENTAIRES.'</h2>'."\n";
|
439 |
$res .= '<h2 class="BAZ_titre BAZ_titre_'.$GLOBALS['_BAZAR_']['class'].'">'.BAZ_LES_COMMENTAIRES.'</h2>'."\n";
|
| 430 |
$requete = 'SELECT * FROM bazar_commentaires WHERE bc_ce_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'].' ORDER BY bc_date ASC';
|
440 |
$requete = 'SELECT * FROM bazar_commentaires WHERE bc_ce_id_fiche='.$GLOBALS['_BAZAR_']['id_fiche'].' ORDER BY bc_date ASC';
|
| 431 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
|
441 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
|
| Line 462... |
Line 472... |
| 462 |
$res .= '</p>'."\n";
|
472 |
$res .= '</p>'."\n";
|
| 463 |
}
|
473 |
}
|
| 464 |
} else {
|
474 |
} else {
|
| 465 |
$res .= BAZ_PAS_DE_COMMENTAIRES.'<br /><br />'."\n";
|
475 |
$res .= BAZ_PAS_DE_COMMENTAIRES.'<br /><br />'."\n";
|
| 466 |
}
|
476 |
}
|
| - |
|
477 |
//}
|
| Line 467... |
Line 478... |
| 467 |
|
478 |
|
| 468 |
//formulaire des commentaires
|
479 |
//formulaire des commentaires
|
| 469 |
if ($GLOBALS['AUTH']->getAuth()) {
|
480 |
if ($GLOBALS['AUTH']->getAuth()) {
|
| 470 |
$form_commentaire = new HTML_QuickForm('bazar_commentaire', 'post', $url);
|
481 |
$form_commentaire = new HTML_QuickForm('bazar_commentaire', 'post', $url);
|
| 471 |
$squelette =& $form_commentaire->defaultRenderer();
|
482 |
$squelette =& $form_commentaire->defaultRenderer();
|
| 472 |
$squelette->setFormTemplate("\n".'<form {attributes}>'."\n".'{content}'."\n".'</form>'."\n");
|
483 |
$squelette->setFormTemplate("\n".'<form {attributes}>'."\n".'{content}'."\n".'</form>'."\n");
|
| 473 |
$squelette->setElementTemplate( '<label style="width:200px;">{label}'.
|
484 |
$squelette->setElementTemplate( '<label style="width:200px;">{label}'.
|
| 474 |
'<!-- BEGIN required --><span class="symbole_obligatoire"> *</span><!-- END required -->'."\n".
|
485 |
'<!-- BEGIN required --><span class="symbole_obligatoire"> *</span><!-- END required -->'."\n".
|
| 475 |
'</label><br />'."\n".'{element}<br />'."\n");
|
486 |
'</label><br />'."\n".'{element}<br />'."\n");
|
| 476 |
$squelette->setRequiredNoteTemplate("\n".'<span class="symbole_obligatoire"> *{requiredNote}</span>'."\n");
|
487 |
$squelette->setRequiredNoteTemplate("\n".'<span class="symbole_obligatoire"> *{requiredNote}</span>'."\n");
|
| 477 |
$option=array('style'=>'width:300px;border:1px solid #000;', 'maxlength'=>100);
|
488 |
$option=array('style'=>'width:300px;border:1px solid #000;', 'maxlength'=>100);
|
| 478 |
$form_commentaire->addElement('text', 'Nom', BAZ_ENTREZ_VOTRE_NOM, $option);
|
489 |
$form_commentaire->addElement('text', 'Nom', BAZ_ENTREZ_VOTRE_NOM, $option);
|
| 479 |
$option=array('style'=>'width:95%;height:100px;white-space: pre;padding:3px;border:1px solid #000;');
|
490 |
$option=array('style'=>'width:95%;height:100px;white-space: pre;padding:3px;border:1px solid #000;');
|
| 480 |
require_once PAP_CHEMIN_API_PEAR.'HTML/QuickForm/textarea.php';
|
491 |
require_once PAP_CHEMIN_API_PEAR.'HTML/QuickForm/textarea.php';
|
| 481 |
$formtexte= new HTML_QuickForm_textarea('Commentaire', BAZ_ENTREZ_VOTRE_COMMENTAIRE, $option);
|
492 |
$formtexte= new HTML_QuickForm_textarea('Commentaire', BAZ_ENTREZ_VOTRE_COMMENTAIRE, $option);
|
| 482 |
$form_commentaire->addElement($formtexte) ;
|
493 |
$form_commentaire->addElement($formtexte) ;
|
| 483 |
$option=array('style'=>'border:1px solid #000;');
|
494 |
$option=array('style'=>'border:1px solid #000;');
|
| 484 |
$form_commentaire->addElement('submit', 'Envoyer', BAZ_ENVOYER, $option);
|
495 |
$form_commentaire->addElement('submit', 'Envoyer', BAZ_ENVOYER, $option);
|
| 485 |
$form_commentaire->addRule('Nom', BAZ_NOM_REQUIS, 'required', '', 'client') ;
|
496 |
$form_commentaire->addRule('Nom', BAZ_NOM_REQUIS, 'required', '', 'client') ;
|
| 486 |
$form_commentaire->addRule('Commentaire', BAZ_COMMENTAIRE_REQUIS, 'required', '', 'client') ;
|
497 |
$form_commentaire->addRule('Commentaire', BAZ_COMMENTAIRE_REQUIS, 'required', '', 'client') ;
|
| 487 |
$form_commentaire->setRequiredNote(BAZ_CHAMPS_REQUIS) ;
|
498 |
$form_commentaire->setRequiredNote(BAZ_CHAMPS_REQUIS) ;
|
| 488 |
$res .= $form_commentaire->toHTML();
|
- |
|
| 489 |
}
|
- |
|
| 490 |
$res .= '</div>'."\n";
|
499 |
$res .= $form_commentaire->toHTML();
|
| - |
|
500 |
}
|
| 491 |
}
|
501 |
$res .= '</div>'."\n";
|
| Line 492... |
Line 502... |
| 492 |
}
|
502 |
}
|
| 493 |
|
503 |
|
| 494 |
// Nettoyage de l'url avant les return : apparement inutile sinon pose pb dans Papyrus (url applette deconnexion et moteur de recherche) [jpm le 17 mars 2008]
|
504 |
// Nettoyage de l'url avant les return : apparement inutile sinon pose pb dans Papyrus (url applette deconnexion et moteur de recherche) [jpm le 17 mars 2008]
|
| Line 644... |
Line 654... |
| 644 |
$req_where=1;
|
654 |
$req_where=1;
|
| 645 |
//le nom du flux devient le type d'annonce
|
655 |
//le nom du flux devient le type d'annonce
|
| 646 |
$requete_nom_flux = 'select bn_label_nature from bazar_nature where bn_id_nature = '.$typeannonce;
|
656 |
$requete_nom_flux = 'select bn_label_nature from bazar_nature where bn_id_nature = '.$typeannonce;
|
| 647 |
$nomflux = $GLOBALS['_BAZAR_']['db']->getOne($requete_nom_flux) ;
|
657 |
$nomflux = $GLOBALS['_BAZAR_']['db']->getOne($requete_nom_flux) ;
|
| 648 |
}
|
658 |
}
|
| - |
|
659 |
|
| - |
|
660 |
// cas où on veut toutes les annonces
|
| - |
|
661 |
if ($typeannonce == 'toutes') {
|
| - |
|
662 |
if ($req_where==1) {$requete .= ' AND ';}
|
| - |
|
663 |
$requete .= 'bf_ce_nature IN (1,2,3,4' ;
|
| - |
|
664 |
$chaine = '';
|
| - |
|
665 |
$requete .= ') and bf_ce_nature=bn_id_nature ';
|
| - |
|
666 |
}
|
| - |
|
667 |
|
| 649 |
// Cas ou il y plusieurs type d annonce demande
|
668 |
// Cas ou il y plusieurs type d annonce demande
|
| 650 |
if (is_array ($typeannonce)) {
|
669 |
if (is_array ($typeannonce)) {
|
| 651 |
if ($req_where==1) {$requete .= ' AND ';}
|
670 |
if ($req_where==1) {$requete .= ' AND ';}
|
| 652 |
$requete .= 'bf_ce_nature IN (' ;
|
671 |
$requete .= 'bf_ce_nature IN (' ;
|
| 653 |
$chaine = '';
|
672 |
$chaine = '';
|
| Line 1084... |
Line 1103... |
| 1084 |
}
|
1103 |
}
|
| 1085 |
if (isset($_REQUEST['liste31']) && $_REQUEST['liste31'] != '0' && $_REQUEST['nature']!='toutes') {
|
1104 |
if (isset($_REQUEST['liste31']) && $_REQUEST['liste31'] != '0' && $_REQUEST['nature']!='toutes') {
|
| 1086 |
$requeteWhere = 'bf_ce_nature="'.$_REQUEST['nature'].'" AND '.$requeteWhere;
|
1105 |
$requeteWhere = 'bf_ce_nature="'.$_REQUEST['nature'].'" AND '.$requeteWhere;
|
| 1087 |
}
|
1106 |
}
|
| Line 1088... |
Line 1107... |
| 1088 |
|
1107 |
|
| 1089 |
if (BAZ_UTILISE_TEMPLATE) {
|
1108 |
/*if (BAZ_UTILISE_TEMPLATE) {
|
| 1090 |
// Appel du template n 1
|
1109 |
// Appel du template n 1
|
| Line 1091... |
Line 1110... |
| 1091 |
include_once BAZ_CHEMIN_APPLI.'bibliotheque/bazarTemplate.class.php' ;
|
1110 |
include_once BAZ_CHEMIN_APPLI.'bibliotheque/bazarTemplate.class.php' ;
|
| 1092 |
|
1111 |
|
| Line 1096... |
Line 1115... |
| 1096 |
ob_start();
|
1115 |
ob_start();
|
| 1097 |
eval ($chaine) ;
|
1116 |
eval ($chaine) ;
|
| 1098 |
$res .= ob_get_contents();
|
1117 |
$res .= ob_get_contents();
|
| 1099 |
ob_end_clean() ;
|
1118 |
ob_end_clean() ;
|
| Line 1100... |
Line 1119... |
| 1100 |
|
1119 |
|
| 1101 |
} else {
|
1120 |
} else {*/
|
| 1102 |
$res .= $formtemplate->toHTML();
|
1121 |
$res .= $formtemplate->toHTML();
|
| 1103 |
if (!isset($_REQUEST['recherche_effectuee'])) {
|
1122 |
if (!isset($_REQUEST['recherche_effectuee'])) {
|
| 1104 |
$res .= '<p class="zone_info">'.BAZ_ENTRER_VOS_CRITERES_DE_RECHERCHE.'</p>'."\n";
|
- |
|
| 1105 |
$GLOBALS['_BAZAR_']['url']->addQueryString(BAZ_VARIABLE_ACTION,BAZ_VOIR_FLUX_RSS);
|
- |
|
| 1106 |
$GLOBALS['_BAZAR_']['url']->addQueryString('annonce',$GLOBALS['_BAZAR_']['id_typeannonce']);
|
- |
|
| 1107 |
if ($GLOBALS['_BAZAR_']['categorie_nature']!=0) {
|
- |
|
| 1108 |
$GLOBALS['_BAZAR_']['url']->addQueryString('categorie_nature',$GLOBALS['_BAZAR_']['categorie_nature']);
|
- |
|
| 1109 |
}
|
- |
|
| 1110 |
// $res .= '{{Syndication titre="'.BAZ_DERNIERES_FICHES.'" url="'.$GLOBALS['_BAZAR_']['url']->getURL().'" nb=10 nouvellefenetre=0 formatdate="'.BAZ_TYPE_AFFICHAGE_LISTE.'"}}';
|
- |
|
| 1111 |
$requete = 'SELECT DISTINCT bf_id_fiche, bf_titre, bf_date_debut_validite_fiche, bf_description, bn_label_nature, bf_date_creation_fiche FROM bazar_fiche, bazar_nature WHERE bn_id_nature=bf_ce_nature ' ;
|
- |
|
| 1112 |
if($GLOBALS['_BAZAR_']['categorie_nature'] != 'toutes')
|
- |
|
| 1113 |
{
|
- |
|
| 1114 |
$requete .= ' AND bn_ce_id_menu="'.$GLOBALS['_BAZAR_']['categorie_nature'].'"' ;
|
- |
|
| 1115 |
}
|
- |
|
| 1116 |
|
- |
|
| 1117 |
if (isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '') {
|
- |
|
| 1118 |
$requete .= ' AND ((bf_date_debut_evenement <= "'.date('Y-m-d', strtotime($_POST['date_fin'])).'" and bf_date_debut_evenement >="'.date('Y-m-d', strtotime($_POST['date_debut'])).'" )' .
|
- |
|
| 1119 |
' or (bf_date_fin_evenement >="'.date('Y-m-d', strtotime($_POST['date_debut'])).'" and bf_date_fin_evenement <="'.date('Y-m-d', strtotime($_POST['date_fin'])).'")' .
|
- |
|
| 1120 |
' or bf_date_debut_evenement <= "'.date('Y-m-d', strtotime($_POST['date_debut'])).'" and bf_date_fin_evenement >= "'.date('Y-m-d', strtotime($_POST['date_fin'])).'") ';
|
- |
|
| Line 1121... |
Line 1123... |
| 1121 |
} else {
|
1123 |
$res .= '<p class="zone_info">'.BAZ_ENTRER_VOS_CRITERES_DE_RECHERCHE.'</p>'."\n";
|
| - |
|
1124 |
|
| - |
|
1125 |
$requete = 'SELECT DISTINCT bf_id_fiche, '.BAZ_CHAMPS_PRENOM.', '.BAZ_CHAMPS_NOM.', bf_titre, bf_date_debut_validite_fiche, bf_date_debut_evenement, bf_description, bn_label_nature, bf_date_creation_fiche
|
| - |
|
1126 |
FROM bazar_fiche, bazar_nature, '.BAZ_ANNUAIRE.'
|
| - |
|
1127 |
WHERE bn_id_nature=bn_id_nature
|
| - |
|
1128 |
AND bf_ce_utilisateur = '.BAZ_CHAMPS_ID.'
|
| 1122 |
|
1129 |
AND bf_statut_fiche = 1
|
| 1123 |
$requete .= ' AND (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") ' ;
|
1130 |
AND bf_date_debut_evenement >= NOW()
|
| - |
|
1131 |
GROUP BY bf_titre
|
| - |
|
1132 |
ORDER BY bf_date_debut_evenement DESC,
|
| - |
|
1133 |
bf_date_creation_fiche DESC,
|
| - |
|
1134 |
bf_date_fin_validite_fiche DESC,
|
| Line 1124... |
Line 1135... |
| 1124 |
}
|
1135 |
bf_date_maj_fiche DESC
|
| 1125 |
$requete .= 'GROUP BY bf_id_fiche ORDER BY bf_date_debut_validite_fiche DESC, bf_date_creation_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
|
1136 |
LIMIT 0 , 12';
|
| 1126 |
|
1137 |
|
| 1127 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete);
|
1138 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete);
|
| Line 1132... |
Line 1143... |
| 1132 |
$res .= '<h2>'.BAZ_DERNIERES_FICHES.'</h2>';
|
1143 |
$res .= '<h2>'.BAZ_DERNIERES_FICHES.'</h2>';
|
| 1133 |
$res .= '<ul class="liste_rss">';
|
1144 |
$res .= '<ul class="liste_rss">';
|
| 1134 |
while($ligne = $resultat->fetchRow(DB_FETCHMODE_ASSOC)) {
|
1145 |
while($ligne = $resultat->fetchRow(DB_FETCHMODE_ASSOC)) {
|
| 1135 |
$GLOBALS['_BAZAR_']['url']->addQueryString(BAZ_VARIABLE_ACTION, BAZ_VOIR_FICHE);
|
1146 |
$GLOBALS['_BAZAR_']['url']->addQueryString(BAZ_VARIABLE_ACTION, BAZ_VOIR_FICHE);
|
| 1136 |
$GLOBALS['_BAZAR_']['url']->addQueryString('id_fiche', $ligne['bf_id_fiche']);
|
1147 |
$GLOBALS['_BAZAR_']['url']->addQueryString('id_fiche', $ligne['bf_id_fiche']);
|
| - |
|
1148 |
|
| - |
|
1149 |
$res .= '<div class="menu_titre">
|
| 1137 |
$res .= '<li class="titre_rss"><a class="lien_rss" href="'. $GLOBALS['_BAZAR_']['url']->getURL() .'" alt="lire la fiche">'. $ligne['bf_titre'].'</a></li>';
|
1150 |
<h1 class="intituler_rubrique"><a class="lien_rss" href="'.$GLOBALS['_BAZAR_']['url']->getURL() .'" alt="lire la fiche"> '.$ligne['bf_titre'].'</a></h1>
|
| - |
|
1151 |
<p class="date">'.baz_valeur_champs(31,$ligne['bf_id_fiche']).' début le '.$GLOBALS['jours'][date ('w', strtotime ($ligne['bf_date_debut_evenement']))].' '.date('d', strtotime($ligne['bf_date_debut_evenement'])).
|
| - |
|
1152 |
' '.$GLOBALS['mois'][date('n', strtotime ($ligne['bf_date_debut_evenement']))].' '.date ('Y', strtotime ($ligne['bf_date_debut_evenement'])).' par '.$ligne[BAZ_CHAMPS_PRENOM].' '.$ligne[BAZ_CHAMPS_NOM].' </p>
|
| - |
|
1153 |
<p class="descriptif_contenu">'.substr($ligne['bf_description'], 0, 400).'</p>
|
| - |
|
1154 |
</div>
|
| - |
|
1155 |
<hr />';
|
| - |
|
1156 |
|
| 1138 |
}
|
1157 |
}
|
| 1139 |
$res .= '</ul>';
|
1158 |
$res .= '</ul>';
|
| 1140 |
}
|
1159 |
}
|
| 1141 |
}
|
1160 |
}
|
| 1142 |
}
|
1161 |
//}
|
| Line 1143... |
Line 1162... |
| 1143 |
|
1162 |
|
| 1144 |
//affichage des resultats de la recherche si le formulaire a ete envoye
|
1163 |
//affichage des resultats de la recherche si le formulaire a ete envoye
|
| 1145 |
$requeteSQL='';
|
1164 |
$requeteSQL='';
|
| 1146 |
if (isset($_REQUEST['recherche_effectuee'])) {
|
1165 |
if (isset($_REQUEST['recherche_effectuee'])) {
|
| Line 1181... |
Line 1200... |
| 1181 |
else {$valides=1;}
|
1200 |
else {$valides=1;}
|
| 1182 |
//generation de la liste de flux a afficher
|
1201 |
//generation de la liste de flux a afficher
|
| 1183 |
if (!isset($_REQUEST['personnes'])) {
|
1202 |
if (!isset($_REQUEST['personnes'])) {
|
| 1184 |
$_REQUEST['personnes']='tous';
|
1203 |
$_REQUEST['personnes']='tous';
|
| 1185 |
}
|
1204 |
}
|
| 1186 |
if (isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '') {
|
- |
|
| 1187 |
$requeteWhere .= ' ((bf_date_debut_evenement <= "'.date('Y-m-d', strtotime($_POST['date_fin'])).'" and bf_date_debut_evenement >="'.date('Y-m-d', strtotime($_POST['date_debut'])).'" )' .
|
- |
|
| 1188 |
' or (bf_date_fin_evenement >="'.date('Y-m-d', strtotime($_POST['date_debut'])).'" and bf_date_fin_evenement <="'.date('Y-m-d', strtotime($_POST['date_fin'])).'")' .
|
- |
|
| 1189 |
' or bf_date_debut_evenement <= "'.date('Y-m-d', strtotime($_POST['date_debut'])).'" and bf_date_fin_evenement >= "'.date('Y-m-d', strtotime($_POST['date_fin'])).'") AND ';
|
- |
|
| 1190 |
} else {
|
- |
|
| Line 1191... |
Line 1205... |
| 1191 |
|
1205 |
|
| 1192 |
$requeteWhere .= ' (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 ' ;
|
- |
|
| Line 1193... |
Line 1206... |
| 1193 |
}
|
1206 |
if ((isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '') || (isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '')) {
|
| - |
|
1207 |
|
| - |
|
1208 |
if (isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '' && isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '') {
|
| - |
|
1209 |
$requeteWhere .= ' (bf_date_debut_evenement >="'.date('Y-m-d', strtotime($_REQUEST['date_debut'])).'"
|
| - |
|
1210 |
and bf_date_fin_evenement <="'.date('Y-m-d', strtotime($_REQUEST['date_fin'])).'") AND ';
|
| - |
|
1211 |
}
|
| - |
|
1212 |
else {
|
| - |
|
1213 |
if (isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '') {
|
| - |
|
1214 |
$requeteWhere .= ' (bf_date_debut_evenement >="'.date('Y-m-d', strtotime($_REQUEST['date_debut'])).'"
|
| - |
|
1215 |
) AND ';
|
| - |
|
1216 |
}
|
| - |
|
1217 |
|
| - |
|
1218 |
if(isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '') {
|
| - |
|
1219 |
$requeteWhere .= ' (bf_date_fin_evenement >="'.date('Y-m-d', strtotime($_REQUEST['date_fin'])).'"
|
| - |
|
1220 |
) AND ';
|
| - |
|
1221 |
}
|
| - |
|
1222 |
}
|
| - |
|
1223 |
}
|
| - |
|
1224 |
else {
|
| Line -... |
Line 1225... |
| - |
|
1225 |
$requeteWhere .= '(bf_date_fin_evenement >= NOW() AND (bf_date_fin_evenement >= NOW() OR bf_date_fin_evenement="0000-00-00")) AND ' ;
|
| 1194 |
|
1226 |
}
|
| Line 1195... |
Line 1227... |
| 1195 |
$res .= baz_liste_pagine_HTML($typedefiches, '', $_REQUEST['personnes'], $valides, $requeteSQL, $requeteFrom, $requeteWhere);
|
1227 |
|
| 1196 |
|
1228 |
$res .= baz_liste_pagine_HTML($typedefiches, '', $_REQUEST['personnes'], $valides, $requeteSQL, $requeteFrom, $requeteWhere);
|
| 1197 |
}
|
1229 |
}
|
| Line 1238... |
Line 1270... |
| 1238 |
$requete = ' AND ' ;
|
1270 |
$requete = ' AND ' ;
|
| 1239 |
}
|
1271 |
}
|
| Line 1240... |
Line 1272... |
| 1240 |
|
1272 |
|
| 1241 |
$requete .= 'bf_statut_fiche=1';
|
1273 |
$requete .= 'bf_statut_fiche=1';
|
| 1242 |
}
|
- |
|
| 1243 |
if($utilisateur->isSuperAdmin()) {
|
- |
|
| 1244 |
if ($valide!=0) {
|
- |
|
| 1245 |
if ($utilisateur->isSuperAdmin()) {
|
- |
|
| 1246 |
$req_where=1;
|
- |
|
| 1247 |
} else {
|
- |
|
| 1248 |
if ($req_where==1) {$requete .= ' AND ';}
|
- |
|
| 1249 |
$requete .= '(bf_date_debut_validite_fiche<=NOW() or bf_date_debut_validite_fiche="0000-00-00")'.
|
- |
|
| 1250 |
' AND (bf_date_fin_validite_fiche>=NOW() or bf_date_fin_validite_fiche="0000-00-00") AND bn_id_nature=bf_ce_nature';
|
- |
|
| 1251 |
$req_where=1;
|
- |
|
| 1252 |
}
|
- |
|
| 1253 |
}
|
1274 |
}
|
| - |
|
1275 |
|
| Line 1254... |
Line 1276... |
| 1254 |
}
|
1276 |
$requete .= ' AND bn_id_nature=bf_ce_nature ';
|
| 1255 |
|
1277 |
|
| 1256 |
if ($emetteur!='' && $emetteur!='tous') {
|
1278 |
if ($emetteur!='' && $emetteur!='tous') {
|
| 1257 |
if ($req_where==1) {$requete .= ' AND ';}
|
1279 |
if ($req_where==1) {$requete .= ' AND ';}
|
| 1258 |
$requete .= 'bf_ce_utilisateur='.$emetteur;
|
1280 |
$requete .= 'bf_ce_utilisateur='.$emetteur;
|
| 1259 |
$req_where=1;
|
1281 |
$req_where=1;
|
| 1260 |
}
|
1282 |
}
|
| 1261 |
if ($requeteSQL!='') {
|
1283 |
if ($requeteSQL!='') {
|
| 1262 |
if ($req_where==1) {$requete .= ' AND ';}
|
1284 |
$requete .= ' AND ';
|
| 1263 |
$requete .= '('.$requeteSQL.')';
|
1285 |
$requete .= '('.$requeteSQL.')';
|
| 1264 |
$req_where=1;
|
1286 |
$req_where=1;
|
| 1265 |
}
|
1287 |
}
|
| - |
|
1288 |
$requete .= ' ORDER BY bf_date_debut_evenement DESC, bf_date_debut_validite_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
|
| 1266 |
$requete .= ' ORDER BY bf_date_debut_validite_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
|
1289 |
if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
|
| 1267 |
if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
|
1290 |
|
| 1268 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
|
1291 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
|
| 1269 |
if (DB::isError($resultat)) {
|
1292 |
if (DB::isError($resultat)) {
|
| Line 1344... |
Line 1367... |
| 1344 |
}
|
1367 |
}
|
| Line 1345... |
Line 1368... |
| 1345 |
|
1368 |
|
| 1346 |
function encoder_en_utf8($txt) {
|
1369 |
function encoder_en_utf8($txt) {
|
| 1347 |
// Nous remplaçons l'apostrophe de type RIGHT SINGLE QUOTATION MARK et les & isolées qui n'auraient pas été
|
1370 |
// Nous remplaçons l'apostrophe de type RIGHT SINGLE QUOTATION MARK et les & isolées qui n'auraient pas été
|
| 1348 |
// remplacées par une entitée HTML et les autres caractères incompatibles provenant de cp1252 sous Windows
|
1371 |
// remplacées par une entitée HTML et les autres caractères incompatibles provenant de cp1252 sous Windows
|
| 1349 |
$cp1252_map = array (
|
1372 |
/*$cp1252_map = array (
|
| 1350 |
"\xc2\x80" => "\xe2\x82\xac", /* EURO SIGN */
|
1373 |
"\xc2\x80" => "\xe2\x82\xac", /* EURO SIGN */
|
| 1351 |
"\xc2\x82" => "\xe2\x80\x9a", /* SINGLE LOW-9 QUOTATION MARK */
|
1374 |
"\xc2\x82" => "\xe2\x80\x9a", /* SINGLE LOW-9 QUOTATION MARK */
|
| 1352 |
"\xc2\x83" => "\xc6\x92", /* LATIN SMALL LETTER F WITH HOOK */
|
1375 |
"\xc2\x83" => "\xc6\x92", /* LATIN SMALL LETTER F WITH HOOK */
|
| 1353 |
"\xc2\x84" => "\xe2\x80\x9e", /* DOUBLE LOW-9 QUOTATION MARK */
|
1376 |
"\xc2\x84" => "\xe2\x80\x9e", /* DOUBLE LOW-9 QUOTATION MARK */
|
| Line 1372... |
Line 1395... |
| 1372 |
"\xc2\x9a" => "\xc5\xa1", /* LATIN SMALL LETTER S WITH CARON */
|
1395 |
"\xc2\x9a" => "\xc5\xa1", /* LATIN SMALL LETTER S WITH CARON */
|
| 1373 |
"\xc2\x9b" => "\xe2\x80\xba", /* SINGLE RIGHT-POINTING ANGLE QUOTATION*/
|
1396 |
"\xc2\x9b" => "\xe2\x80\xba", /* SINGLE RIGHT-POINTING ANGLE QUOTATION*/
|
| 1374 |
"\xc2\x9c" => "\xc5\x93", /* LATIN SMALL LIGATURE OE */
|
1397 |
"\xc2\x9c" => "\xc5\x93", /* LATIN SMALL LIGATURE OE */
|
| 1375 |
"\xc2\x9e" => "\xc5\xbe", /* LATIN SMALL LETTER Z WITH CARON */
|
1398 |
"\xc2\x9e" => "\xc5\xbe", /* LATIN SMALL LETTER Z WITH CARON */
|
| 1376 |
"\xc2\x9f" => "\xc5\xb8" /* LATIN CAPITAL LETTER Y WITH DIAERESIS*/
|
1399 |
"\xc2\x9f" => "\xc5\xb8" /* LATIN CAPITAL LETTER Y WITH DIAERESIS*/
|
| 1377 |
);
|
1400 |
);*/
|
| - |
|
1401 |
|
| - |
|
1402 |
$badlatin1_cp1252_to_htmlent =
|
| - |
|
1403 |
array(
|
| - |
|
1404 |
'\x80'=>'€', '\x81'=>'?', '\x82'=>'‚', '\x83'=>'ƒ',
|
| - |
|
1405 |
'\x84'=>'„', '\x85'=>'…', '\x86'=>'†', '\x87'=>'‡',
|
| - |
|
1406 |
'\x88'=>'ˆ', '\x89'=>'‰', '\x8A'=>'Š', '\x8B'=>'‹',
|
| - |
|
1407 |
'\x8C'=>'Œ', '\x8D'=>'?', '\x8E'=>'Ž', '\x8F'=>'?',
|
| - |
|
1408 |
'\x90'=>'?', '\x91'=>'‘', '\x92'=>'’', '\x93'=>'“',
|
| - |
|
1409 |
'\x94'=>'”', '\x95'=>'•', '\x96'=>'–', '\x97'=>'—',
|
| - |
|
1410 |
'\x98'=>'˜', '\x99'=>'™', '\x9A'=>'š', '\x9B'=>'›',
|
| - |
|
1411 |
'\x9C'=>'œ', '\x9D'=>'?', '\x9E'=>'ž', '\x9F'=>'Ÿ'
|
| - |
|
1412 |
);
|
| - |
|
1413 |
$txt = strtr($txt, $badlatin1_cp1252_to_htmlent);
|
| - |
|
1414 |
|
| - |
|
1415 |
return utf8_encode($txt);
|
| Line 1378... |
Line 1416... |
| 1378 |
|
1416 |
|
| 1379 |
//return strtr(preg_replace('/ \x{0026} /u', ' & ', mb_convert_encoding($txt, 'UTF-8','HTML-ENTITIES')), $cp1252_map);
|
1417 |
//return strtr(preg_replace('/ \x{0026} /u', ' & ', mb_convert_encoding($txt, 'UTF-8','HTML-ENTITIES')), $cp1252_map);
|
| Line 1380... |
Line 1418... |
| 1380 |
return strtr(preg_replace('/ \x{0026} /u', ' & ', utf8_encode($txt)), $cp1252_map);
|
1418 |
//return strtr(preg_replace('/ \x{0026} /u', ' & ', utf8_encode($txt)), $cp1252_map);
|
| Line 1381... |
Line 1419... |
| 1381 |
|
1419 |
|
| 1382 |
}
|
1420 |
}
|