//selection des champs a afficher
cCondition="Select T_COMMUNE.code_cp_commune AS code_postal , T_COMMUNE.libelle_commune AS ville , T_RESPONSABLE.raison_social_resp AS raison_social ,T_MANIF.jour_debut_manif AS jour_debut"
cCondition+=" , T_MANIF.jour_fin_manif AS jour_fin ,T_RESPONSABLE.tel_resp AS tel_resp , T_COMMUNE.tel_commune AS tel_commune , T_MANIF.type_exposant_manif AS type_exposant "
cCondition+=", T_MANIF.date_ante_manif AS date_ante FROM T_MANIF,T_COMMUNE,T_RESPONSABLE WHERE "
//date debut et date fin	
SI DateDebut<>"" ET DateFin<>"" ALORS
	cCondition+="jour_debut_manif between '"
	cCondition+=DateDebut 
	cCondition+= "' AND '"  
	cCondition+=DateFin 
	cCondition+="' AND " 
	cCondition+="jour_fin_manif between '" 
	cCondition+=DateDebut
	cCondition+="' AND '"
	cCondition+=DateFin
	cCondition+="'"
	ElementRequete=Vrai
SINON SI DateDebut<>""
	cCondition+="jour_debut_manif ='"
	cCondition+=DateDebut
	cCondition+="'"
	ElementRequete=Vrai 
SINON SI DateFin <>""
	cCondition+="jour_fin_manif = "
	cCondition+=DateFin
	cCondition+="'"
	ElementRequete=Vrai	
FIN
//date definie
SI ComboDateDefinie..ValeurAffichée="non" ALORS
	ElementRequete=Vrai
	SI cCondition<>"" ALORS cCondition+= " AND "
	cCondition+="jour_debut_manif ='01/01/****'" 
FIN

//type d'exposant
SI ComboTypeExposant <> "" ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	cCondition+="type_exposant_manif ='"
	cCondition+=ComboTypeExposant..ValeurAffichée
	cCondition+="'"
FIN
//commune de manifestation
SI LieuManif<>"" ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	ElementRequete=Vrai
	cCondition+="libele_commune LIKE '*"
	cCondition+=LieuManif
	cCondition+="'"
FIN
//tel du responsable
SI TelResp<>"" ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	ElementRequete=Vrai
	cCondition+="tel_resp ='"
	cCondition+=TelResp
	cCondition+="'"  
FIN
//code postal ville manif
SI CodePostalManif<>"" ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	ElementRequete=Vrai
	cCondition+="code_cp_commune like '*"
	cCondition+=CodePostalManif
	cCondition+="'"
FIN
//nom du responsable
SI ResponManif<>"" ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	ElementRequete=Vrai
	cCondition+="nom_resp like '*"
	cCondition+=ResponManif
	cCondition+="*'"
FIN
//raison social
SI RaisonSocial<>"" ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	ElementRequete=Vrai
	cCondition+="raison_social_resp like '*"
	cCondition+=RaisonSocial
	cCondition+="*'"
FIN
//execution de la reqete
SI ElementRequete=Vrai ALORS
	SI cCondition<>"" ALORS cCondition+= " AND "
	cCondition+="T_MANIF.id_manif=T_COMMUNE.code_insee_commune AND T_MANIF.id_resp_manif=T_RESPONSABLE.id_resp"
	HExécuteRequêteSQL(ReqRechercheManif,hRequêteDéfaut,cCondition)
	ElementRequete=Faux
FIN