addHTMLHeadJs(array("../js/script.js")); $condition='where'; function entre2dates($zone){ echo "

"; echo "

\n"; echo ""; echo ""._($zone).""; echo ""; echo "\t

\n"; echo ""._("Debut")." : "; echo "\n"; echo "
"._("Fin")."..... : "; echo "\n"; echo "

"; echo"

"; echo "

"; } function rtext($zone){ echo "

"; echo "

\n"; echo ""; echo ""._($zone)."
"; echo ""; echo "\t

\n"; //echo "
"; echo ""; //echo "

"; echo "

"; echo"

"; echo "

"; } function ouinon($zone){ echo "

"; echo "

\n"; echo ""; echo ""._($zone)."
"; echo ""; echo "\t

\n"; echo ""; echo "

"; echo"

"; echo "

"; } function rselect($zone,$sql,&$db){ echo "

"; echo "

\n"; echo ""; echo ""._($zone)."
"; echo ""; echo "\t

\n"; //echo "
"; echo "
"; echo "

"; echo"

"; echo "

"; } // validation ==1 function rtext1($zone,$condition){ global $condition; $req= ""; if($_POST[$zone]!=""){ //$req=" ".$condition." "." ".$zone." like '%".$_POST[$zone]."%'"; $req=" ".$condition." "." upper(".$zone.") like upper('".$_POST[$zone]."')"; $condition = "and"; } return $req; } function rselect1($zone,$condition){ global $condition; $req= ""; if($_POST[$zone]!=""){ $req=" ".$condition." "." ".$zone." = '".$_POST[$zone]."'"; $condition = "and"; } return $req; } function entre2dates1($zone,$condition){ global $condition; $req= ""; if($_POST[$zone."_debut"]!=""){ // substr($_POST['date_envoi_debut'],6,4).'-'.substr($_POST['date_envoi_debut'],3,2).'-'.substr($_POST['date_envoi_debut'],0,2); $req=" ".$condition." "." ".$zone." >= '".substr($_POST[$zone."_debut"],6,4)."-" .substr($_POST[$zone."_debut"],3,2)."-" .substr($_POST[$zone."_debut"],0,2).""."'"; $condition = "and"; } if($_POST[$zone."_fin"]!=""){ $req.=" ".$condition." "." ".$zone." <= '".substr($_POST[$zone."_fin"],6,4)."-" .substr($_POST[$zone."_fin"],3,2)."-" .substr($_POST[$zone."_fin"],0,2).""."'"; $condition = "and"; } return $req; } // variables $DEBUG=0; $annee = (int)date("Y"); //----> retourne l'annee actuelle // GET if (isset ($_GET['validation'])){ $validation=$_GET['validation']; }else{ $validation=0; } if($validation==0){ $validation=1; // requete sur table $sql_instructeur=" SELECT om_utilisateur,nom from ".DB_PREFIXE."om_utilisateur where instructeur='Oui' order by nom"; $sql_nature=" SELECT nature,libelle FROM ".DB_PREFIXE."nature order by libelle"; $sql_destination=" SELECT destination,libelle FROM ".DB_PREFIXE."destination order by libelle"; $sql_architecte=" SELECT architecte,nom,prenom FROM ".DB_PREFIXE."architecte order by nom,prenom"; $sql_travaux=" SELECT travaux,substring(libelle,0,30) FROM ".DB_PREFIXE."travaux order by libelle"; $sql_avis=" SELECT avis,libelle FROM ".DB_PREFIXE."avis order by libelle"; $sql_etat=" SELECT etat,libelle FROM ".DB_PREFIXE."etat order by libelle"; echo "

"; echo ""; echo ""; echo ""; echo "

"; rtext("dossier"); rtext("delegataire_nom"); rtext("demandeur_nom"); rtext("demandeur_societe"); rtext("parcelle"); rtext("rivoli"); rtext("terrain_adresse"); rtext("terrain_adresse_complement"); echo "	"; rselect("nature",$sql_nature,$f->db); rselect("etat",$sql_etat,$f->db); ouinon("accord_tacite"); rselect("travaux",$sql_travaux,$f->db); entre2dates('date_depot'); entre2dates('date_validite'); entre2dates('date_complet'); echo " "; echo "	"; entre2dates('date_rejet'); entre2dates('date_decision'); entre2dates('date_limite'); entre2dates('date_chantier'); entre2dates('date_achevement'); entre2dates('date_conformite'); rselect("instructeur",$sql_instructeur,$f->db); rselect("architecte",$sql_architecte,$f->db); echo "
"; // commentaires echo " "; // pas de float a gauche et a droite echo ""._("Utilisation de % pour zones de saisie")." : "; //echo ""; echo" "; echo " %BAS "._("finit par 'BAS'").""; echo" "; echo " BAS% "._("commence par 'BAS'").""; echo" "; echo " %BAS% "._("contient 'BAS'").""; echo ""; echo "

"; echo "

"; }else { $sql = "select * from ".DB_PREFIXE."dossier "; $sql.=rtext1("dossier", $condition); $sql.=rselect1("etat", $condition); $sql.=rtext1("parcelle", $condition); $sql.=rtext1("rivoli", $condition); $sql.=rselect1("nature", $condition); $sql.=rtext1("delegataire_nom", $condition); $sql.=rtext1("demandeur_nom", $condition); $sql.=rtext1("demandeur_societe", $condition); $sql.=rselect1("accord_tacite", $condition); $sql.=rtext1("terrain_adresse", $condition); $sql.=rtext1("terrain_adresse_complement", $condition); $sql.=rselect1("instructeur", $condition); $sql.=rselect1("travaux", $condition); $sql.=rselect1("architecte", $condition); $sql.=entre2dates1('date_depot', $condition); $sql.=entre2dates1('date_complet', $condition); $sql.=entre2dates1('date_achevement', $condition); $sql.=entre2dates1('date_rejet', $condition); $sql.=entre2dates1('date_decision', $condition); $sql.=entre2dates1('date_conformite', $condition); $sql.=entre2dates1('date_chantier', $condition); $sql.=entre2dates1('date_limite', $condition); $res= $f -> db->query($sql); $f->isDatabaseError($res); echo "

\n"; echo ""; echo _("Nombre de dossier ")." ".$res->numrows()."
"; echo ""; echo "\t

\n"; echo "requete : ".$sql; echo "

"; echo"

"; if($res->numrows() < 100){ while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ echo "

"; echo "

\n"; echo ""; echo "".$row['dossier']."
"; echo ""; echo "\t

\n"; echo $row['demandeur_nom']."
"; echo $row['demandeur_societe']."
"; echo $row['terrain_numero']." ".$row['terrain_adresse']." ".$row['terrain_cp']." ". $row['terrain_ville']."
"; echo "

"; echo"

"; echo "

"; } }else echo _("Precisez votre question, resltat superieur a 100 dossiers"); echo "

"; // pas de float a gauche et a droite } //echo ""; ?>