1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| ....
$login=$_GET["login"];
$password2=$_GET["pass"];
$nondf=$_GET["nondf"];
$pageec=$_GET["pageaf"];
$classlign=$_GET["classlign"];
$big_request1="SELECT PERSONNEL.NOM, PERSONNEL.PRENOM, PERSONNEL.MATRI, PERSONNEL.SECTION, ENTETE_Histo.NUMNDF, MODALITE.MODALITE_DEP, MOIS.MOIS, ENTETE_Histo.MONTANT, ENTETE_Histo.AVANCE, ENTETE_Histo.APAYER, ENTETE_Histo.CUMUL_KM_EnCours, ENTETE_Histo.DATE_VALIDATION
FROM (MOIS INNER JOIN (MODALITE INNER JOIN (PERSONNEL INNER JOIN ENTETE_Histo ON PERSONNEL.MATRI = ENTETE_Histo.MATRICULE) ON MODALITE.codeModalite = ENTETE_Histo.codeModalite) ON MOIS.numMois = ENTETE_Histo.NumMois) INNER JOIN (TYPE_FRAIS INNER JOIN DETAIL_Histo ON TYPE_FRAIS.codeTypeFrais = DETAIL_Histo.codeTypeFrais) ON (ENTETE_Histo.DATE_CREATION = DETAIL_Histo.DATE_CREATION) AND (ENTETE_Histo.NUMNDF = DETAIL_Histo.NUMNDF) AND (ENTETE_Histo.MATRICULE = DETAIL_Histo.MATRICULE)
WHERE (((ENTETE_Histo.NUMNDF)=$nondf))";
$qbig_request1=odbc_exec ($connect4,$big_request1) or die ("Query requête birequest1 impossible");
$rowbig_request1=odbc_fetch_array($qbig_request1);
$big_nom1=$rowbig_request1["NOM"];
$big_nom2=$rowbig_request1["PRENOM"];
$big_nom3=$rowbig_request1["MATRI"];
$big_nom4=$rowbig_request1["SECTION"];
$big_nom5=$rowbig_request1["NUMNDF"];
$big_nom6=$rowbig_request1["MODALITE_DEP"];
$big_nom7=$rowbig_request1["MOIS"];
$big_nom8=round ($rowbig_request1["MONTANT"],2);
$big_nom9=$rowbig_request1["AVANCE"];
$big_nom10=round ($rowbig_request1["APAYER"],2);
$big_nom11=$rowbig_request1["CUMUL_KM_ENCOURS"];
$pieces4=explode(" ",$rowbig_request1["DATE_VALIDATION"]);
$dformat4=explode("-",$pieces4[0]); |
Partager