\n"; /** * */ if ($step == 0) { // $validation = 1; $cptemp = 0; $cpts=0; $cptsel=0; /** * Ouverture du formulaire */ // Ouverture de la balise formulaire echo "

\n"; // Ouverture de la balise table echo "\n"; // echo "\n"; // echo "\n"; // Fermeture de la balise table echo "

"; // echo " \n"; // echo "\t "; echo _("Criteres de la requete"); echo " \n"; // echo ""; // echo ""; // On separe tous les champs entre crochets dans la requête $temp = explode ("[", $reqmo ["sql"]); // for ($i = 1; $i < sizeof($temp); $i++) { // On vire le crochet de la fin $temp1 = explode("]", $temp[$i]); // On check si alias $temp4 = explode (" as ", $temp1[0]); if (isset($temp4[1])) { $temp1[0] = $temp4[1]; } // $temp6 = $temp1[0]; if (!isset($reqmo[$temp1[0]])) { // saisie criteres where // if ($cpts == 0) { echo "\n"; } elseif ($cpts == 4) { echo "\n\n"; $cpts = 0; } // echo "\t\n"; // $cpts++; } else { // if ($reqmo[$temp1[0]] == "checked") { // if ($cptemp == 0) { echo "\n"; echo "\t\n"; echo "\n"; } elseif ($cptemp == 4) { echo "\n\n"; $cptemp = 0; } // echo "\t\n"; // $cptemp++; } else { // $temp3 = ""; $temp3 = $reqmo[$temp1[0]]; if(!is_array($temp3)) { $temp3 = substr($temp3, 0, 6); } // if ($temp3 == "select") { // if ($cptsel == 0) { echo "\n"; echo "\t\n"; echo "\n"; } elseif ($cptsel == 4) { echo "\n\n"; $cptsel = 0; } // echo "\t\n"; // $cptsel++; } else { // if ($cptsel == 0) { echo "\n"; echo "\t\n"; echo "\n"; } elseif ($cptsel == 4) { echo "\n\n"; $cptsel = 0; } // echo "\t\n"; // $cptsel++; } } } // re initialisation $temp1[0] = ""; } echo ""; echo " "; echo " "._($temp6)." "; echo " "; echo _("Choix des champs a afficher"); echo " "; echo ""; echo "  "._($temp6)." "; echo " "; echo _("Choix des criteres de tri"); echo " "; echo _($temp6)." "; echo ""; $res1 = $f->db->query($reqmo[$temp1[0]]); $f->isDatabaseError($res); while ($row1 =& $res1->fetchRow()) { echo "".$row1[1].""; } echo ""; echo " "; echo _("Choix des criteres de tri"); echo " "; echo _($temp6)." "; echo ""; foreach ($reqmo [$temp1 [0]] as $elem) { echo "".$elem.""; } echo ""; echo " "; // echo " \n"; // echo "

"; // echo " \n"; // echo "\t "; echo _("Parametres de sortie"); echo " \n"; // echo ""; // echo ""; // echo ""; // echo ""; echo ""; // echo ""; // echo ""; echo ""; // echo ""; echo ""; echo " "._("Choix du format de sortie")." "; echo ""; echo ""._("Tableau - Affichage a l'ecran").""; echo ""._("CSV - Export vers logiciel tableur").""; echo ""; echo " "._("Separateur de champs (pour le format CSV)")." "; echo ""; echo ";"; echo "|"; echo ","; echo ""; echo " "._("Nombre limite d'enregistrements a afficher (pour le format Tableau)")." "; echo ""; echo " "; // echo " \n"; // echo "

\n"; // Affichage des actions de controles du formulaire echo "

"; // Bouton de validation du formulaire echo ""; // Lien retour echo ""; echo _("Retour"); echo ""; // Fermeture du conteneur des actions de controles du formulaire echo "

"; // Fermeture de la balise formulaire echo "\n

\n"; } else { // On affiche le csv ou le tableau $temp = explode ("[",$reqmo["sql"]); for($i = 1; $i < sizeof ($temp); $i++) { $temp1 = explode ("]", $temp [$i]); $temp4 = explode (" as ", $temp1 [0]); if (isset ($temp4 [1])) $temp5 = $temp4 [1]; // uniquement as else $temp5 = $temp1 [0]; // en entier if (isset ($_POST [$temp5])) $temp2 = $_POST [$temp5]; else $temp2 = ""; // **** if(isset($reqmo[$temp5])){ if($reqmo[$temp5]=="checked") { if ($temp2 == 'Oui') { $reqmo ['sql'] = str_replace ("[".$temp1[0]."]",$temp1[0],$reqmo['sql']); } else { $reqmo['sql']=str_replace("[".$temp1[0]."],",'',$reqmo['sql']); $reqmo['sql']=str_replace(",[".$temp1[0]."]",'',$reqmo['sql']); $reqmo['sql']=str_replace(", [".$temp1[0]."]",'',$reqmo['sql']); $reqmo['sql']=str_replace("[".$temp1[0]."]",'',$reqmo['sql']); } } else { $reqmo['sql']=str_replace("[".$temp1[0]."]",$temp2,$reqmo['sql']); } //**** }else { $reqmo['sql']=str_replace("[".$temp1[0]."]",$temp2,$reqmo['sql']); }//**** $temp1[0]=""; } $blanc = 0; $temp = ""; for($i=0;$i db -> query ($reqmo['sql']); $f->isDatabaseError($res); $info = $res -> tableInfo (); if ($sortie =='tableau') { // echo "\n"; // echo ""; foreach($info as $elem) { echo "\t\n"; } echo "\n"; // $cptenr = 0; while ($row=& $res->fetchRow()) { // echo "\n"; // $cptenr = $cptenr + 1; $i = 0; foreach ($row as $elem) { if (is_numeric($elem)) echo ""; $i++; } echo "\n"; } // echo "

"._($elem['name'])."
"; else echo "	"; $tmp=""; $tmp=str_replace(chr(13).chr(10),' ', $elem); echo $tmp."

\n"; if ($cptenr==0){ echo "
"._('aucun')." "._('enregistrement')."
"; } } else { $inf=""; foreach ($info as $elem) { //echo $elem['name'].$separateur; $inf=$inf.$elem['name'].$separateur; } //echo "
"; $inf .= "\n"; $cptenr=0; while ($row=& $res->fetchRow()) { $cptenr=$cptenr+1; $i=0; foreach($row as $elem) { //echo $elem.$separateur; //**** $tmp=""; $tmp=str_replace(chr(13).chr(10),' / ', $elem); $tmp=str_replace(';',' ', $tmp); //***** $inf .= $tmp.$separateur; $i++; } //echo "
"; $inf .= "\n"; } if ($cptenr==0){ $inf .="\n"._('aucun')." "._('enregistrement')."\n"; } $nom_fichier="export_".$obj.".csv"; $fic = fopen ("../tmp/".$nom_fichier,"w"); fwrite ($fic, $inf); fclose ($fic); $msg = "
"; $msg .= _("Le fichier a ete exporte, vous pouvez l'ouvrir immediatement en cliquant sur : "); $msg .= ""; $msg .= _("Telecharger le fichier")." [".$nom_fichier."]"; $msg .= ""; $msg .= "
"; echo $msg; } // Affichage des actions de controles du formulaire echo "

"; // Lien retour echo ""; echo _("Retour"); echo ""; // Fermeture du conteneur des actions de controles du formulaire echo "

"; } /** * Fermeture du conteneur de la page */ // echo "