| 469,17 → 469,18 |
|---|
| $chaine = ''; |
| foreach ($typeannonce as $valeur) $chaine .= '"'.$valeur.'",' ; |
| $requete .= substr ($chaine, 0, strlen ($chaine)-1) ; |
| $requete .= ')'; |
| $requete .= ') '; |
| } |
| $utilisateur = new Utilisateur_bazar ($GLOBALS['AUTH']) ; |
| if ($valide!=0) { |
| if ($req_where==1) {$requete .= ' AND ';} |
| if ($GLOBALS['AUTH']->getAuth() && niveau_droit(0,$GLOBALS['AUTH']->getAuthData(BAZ_CHAMPS_ID))!='superadministrateur') { |
| $req_where=1;$requete .= '1' ; |
| if ($req_where==1) { |
| $requete .= ' AND '; |
| } |
| if ($utilisateur->isSuperAdmin()) { |
| $req_where=1; |
| } else { |
| |
| $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; |