code:
<?php
require("connexion.php");
$Num_f = $_POST['NUM_F'];
$sql = 'SELECT f.NUM_F,f.ANNEE_F,f.NUM_BL,f.DATE_F,c.CODE_CLT,c.SOCIETE,c.NOM_RESP,c.TEL,c.FAX
FROM client c,bl,facture f,commande cde
WHERE c.CODE_CLT=cde.CODE_CLT
AND bl.NUM_BCDE=cde.NUM_BCDE
AND f.NUM_BL=bl.NUM_BL
AND f.NUM_F = '.$Num_f;
$requete = mysql_query( $sql,$conn) or die(mysql_error());
if( $data = mysql_fetch_object( $requete ))
{
?>
<form name="affichefacture1" action="imprimer.php" method="POST">
<input type="hidden" name="NUM_F" value="<?php echo($Num_f) ;?>">
<table border="0" align ="justify" cellspacing="2" cellpadding="2">
<tr>
<td align="LEFT"><b>Num Facture: </b></td><td><?php echo ($data->NUM_F);?></td>
<td align="RIGHT"><b>Annee: </b></td><td><?php echo($data->ANNEE_F) ;?></td>
</tr>
<tr>
<td align="LEFT"><b>Num BL: </b></td><td><?php echo ($data->NUM_BL);?></td>
<td align="RIGHT"><b>Date Facture: </b></td><td><?php echo($data->DATE_F) ;?></td>
</tr>
<tr align="RIGHT">
<td align="RIGHT"><b>Code Client: </b></td><td><?php echo($data->CODE_CLT) ;?></td>
</tr>
<tr align="RIGHT">
<td><b>Societe: </b></td><td><?php echo($data->SOCIETE) ;?> </td>
</tr>
<tr align="RIGHT">
<td><b>Responsable: </b></td><td><?php echo($data->NOM_RESP) ;?></td>
</tr>
<tr align="RIGHT">
<td><b>Tel: </b></td><td><?php echo($data->TEL) ;?></td>
</tr>
<tr align="RIGHT">
<td><b>Fax: </b></td><td><?php echo($data->FAX) ;?></td>
</tr>
<?php
$Qte_cde=$_POST['QTE_CDE'];
$PU=$_POST['PU'];
$Num_f = $_POST['NUM_F'];
$sql1 = 'SELECT p.CODE_PDT,p.DESIGNATION,p.DIMENSSION,p.PU,cder.QTE_CDE
FROM produit p,commander cder,bl,facture f
WHERE p.CODE_PDT=cder.CODE_PDT
AND bl.NUM_BCDE=cder.NUM_BCDE
AND f.NUM_BL=bl.NUM_BL
AND f.NUM_F = '.$Num_f;
$requete1 = mysql_query( $sql1,$conn) or die(mysql_error());
$total = mysql_num_rows($requete1);
if($total) {
echo ('<form name="affichefacture1" method="post">');
echo ('<table border=1 bgcolor="#FFFFFF">'."\n");
echo ('<tr>');
echo ('<td><b>Code produit</b></td>-;');
echo ('<td><b>Désignations</b></td>');
echo ('<td><b>Dimenssion</b></td>;');
echo ('<td><b>Prix unitaire</b></td>;');
echo ('<td><b>Qte_Facturée</b></td>;');
echo ('<td><b>P_HT</b></td>;');
echo ('</tr>'."\n");
$PT_HT=0;
while($data=mysql_fetch_array($requete1))
{
echo"<tr>";
echo"<td>".$data['CODE_PDT']."</td>";
echo"<td>".$data['DESIGNATION']."</td>";
echo"<td>".$data['DIMENSSION']."</td>";
echo"<td>".number_format($data['PU'],2,',',' ')."</td>";
echo"<td>".$data['QTE_CDE']."</td>";
$P_HT=$data['PU'] * $data['QTE_CDE'];
$PT_HT = $PT_HT+ $P_HT ;
echo"<td>". number_format($P_HT, 2, ',', ' ')."</td>";
echo "</tr>";}
echo "</table>";
echo"</form>";}
else
echo 'Pas d\'enregistrements dans cette table...';
mysql_free_result($requete);
echo "<br/>";
echo 'PRIX TOTAL HT EST:<b>' . number_format($PT_HT, 2, ',', ' ').'</b>';
echo "<br/>";
$PT_TTC=1.2 * $PT_HT;
echo 'LA PRESENTE FACTURE EST ARRETEE A LA SOMME DE: <b>' . number_format($PT_TTC, 2, ',', ' ').'</b> DIRHAMS';
echo "<br/>";
echo('<u>TVA = 20%</u>');
echo "<br/>";
mysql_close();
?>
</fieldset>
<hr></hr>
<table>
<tr align="CENTER">
<td colspan="2"><INPUT TYPE="image"name="boutton" src="boutton7.gif" ALT="Imprimer" onCLick="window.print()"></td>
<td><form name="affichefacture" action="affichefacture.php" method="post">
<input type="image" name="boutton" src="boutton9.gif" alt="Page d'affichage"/> </form></td></td>
</tr>
</table>
</form>
<?php
}
?>
</html>
