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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
| <head>
<script src="jquery-ui-1.8.16/jquery-1.6.2.js"></script>
<script type="text/javascript" src="script.js"></script>
</head>
<table class="taborder" align="center">
<tr>
<td colspan="4" style="background-color: #999999; font-size:20px; color:#FFF7EE ;">Mes Ordres En Cours</td>
<td colspan="2" style="background-color: #999999; font-size:18px; color:#183152;" align="right">Total Ordres </td>
<td style="background-color: #999999; font-size:18px; color:#3B0405;"><?php echo number_format(str_replace(',', '.', getsommeachat($id, $cnx) + getSommeAchatAtp($id, $cnx)), 3); ?></td>
<td colspan="2" style="background-color: #999999; font-size:18px; color:#183152 ;"align="right">Trésorerie Restante </td>
<td style="background-color: #999999; font-size:18px; color:#3B0405 ;" ><?php echo number_format(str_replace(',', '.', getsolderestante($id, $cnx)), 3); ?></td>
</tr>
<tr class="th">
<td>N° Ordre</td>
<td>Opération</td>
<td>Titres</td>
<td>Statut</td>
<td>Quantité</td>
<td>Prix</td>
<td>Quantité Dévoilée</td>
<td>Date Validité</td>
<td>Modifier</td>
<td>Annuler</td>
<td>Annuler</td>
</tr>
<?php
$sql = "select t.num_ordre, t.sense, ti.libcou, t.statut, t.quantite, t.limite_prix ,t.quantite_dev, t.date_validite, t.num_interface
from ORDRES_WEB t, vclie cl, vcptm cp, vtitr ti
where cl.codcli = '$id'
and cl.codcli = cp.codcli
and cp.NUM_CPT_MAT = t.num_compte
and t.code_titre = ti.codtit
order by NUM_ORDRE";
$st = oci_parse($cnx, $sql);
$res = oci_execute($st, OCI_DEFAULT);
while ($l = oci_fetch_array($st)) {
if(getNumTerface($cnx,$l[8])== true){
echo"<tr class='tr' style='background-color:#77ABD6;'>";
echo"<td class='td'>" . $l[0] . "</td>";
echo"<td class='td'align='center'>Annuler</td>";
echo"<td class='td'align='left'>" . $l[2] . "</td>";
echo"<td class='td'>" . $l[3] . "</td>";
echo"<td class='td'>" . $l[4] . "</td>";
echo"<td class='td'>" . $l[5] . "</td>";
echo"<td class='td'>" . $l[6] . "</td>";
echo"<td class='td'>" . $l[7] . "</td>";
echo"<td class='td'></td>";
echo"<td class='td'></td>";
echo"<tr></tr>";
}else{
if ($l[1] == 1) {
echo"<tr class='tr' style='background-color:#FFDA8C;'>";
echo"<td class='td'>" . $l[0] . "</td>";
echo"<td class='td'align='center'>Achat</td>";
echo"<td class='td'align='left'>" . $l[2] . "</td>";
echo"<td class='td'>" . $l[3] . "</td>";
echo"<td class='td'>" . $l[4] . "</td>";
echo"<td class='td'>" . $l[5] . "</td>";
echo"<td class='td'>" . $l[6] . "</td>";
echo"<td class='td'>" . $l[7] . "</td>";
echo "<form>";
echo "<td class='td'><input type='text' id='numorder' value='$l[8]' hidden='non' /><input type='submit'value='Modifier' style=' background-color:#667882; color:#FCFAE1' /></td>";
echo"<td class='td'><input type='text' id='numorder' value='$l[8]' hidden='non' /><input type='submit' value='$l[8]' style=' background-color:#667882; color:#FCFAE1' onclick=\"annuleordre(this.value);\"/></td>";
echo"</form>";
} else {
echo"<tr class='tr' style='background-color:#B0CC99;'>";
echo"<td class='td'>" . $l[0] . "</td>";
echo "<td class='td'align='center'>Vente</td>";
echo"<td class='td'align='left'>" . $l[2] . "</td>";
echo"<td class='td'>" . $l[3] . "</td>";
echo"<td class='td'>" . $l[4] . "</td>";
echo"<td class='td'>" . $l[5] . "</td>";
echo"<td class='td'>" . $l[6] . "</td>";
echo"<td class='td'>" . $l[7] . "</td>";
}
echo"</tr>";
}
}
oci_close($cnx);
?>
</table> |
Partager