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
|
<?php /* Date de création: 12/04/2009 */ ?>
<html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
P { FONT-SIZE: 8pt; COLOR: #000000; FONT-FAMILY: Verdana, Tahoma, Arial}
TD { FONT-SIZE: 8pt; COLOR: #000000; FONT-FAMILY: Verdana, Tahoma, Arial}
TH { FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Verdana, Tahoma, Arial}
h2 { FONT-SIZE: 18pt; COLOR: #EF0000; FONT-FAMILY: Verdana, Tahoma, Arial}
h3 { FONT-SIZE: 12pt; COLOR: #CCCCFF; FONT-FAMILY: Verdana, Tahoma, Arial}
body { background-color: #2A13FB }
</style>
</head>
<body>
<?php
$conn=odbc_connect(mabase,'','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM SGCHISTO WHERE SGCHISTO.HTYPE='S' AND SGCHISTO.HPROCSTATUS='X' ORDER BY SGCHISTO.HDOCDATE";
//$sql2="SELECT TRUNC(maDate,'DD') FROM SGCHISTO.HDOCDATE";
//$sql2="select convert(char(10), getDate(), 103)";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<form name='logger' action='update.php' method='post'>" ;
echo "<table width='800' align ='center' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCFF'><tr>";
echo "<th align='center' bgcolor='white'>N° de documents</th>";
echo "<th align='center' bgcolor='white'>Date</th>";
echo "<th align='center' bgcolor='white'>Date d'échéance</th>";
echo "<th align='center' bgcolor='white'>Montants</th>";
echo "<th align='center' bgcolor='white'>Commentaire</th>";
echo "<th align='center' bgcolor='white'>Bloquer</th></tr>";
while (odbc_fetch_row($rs))
{
$HDOCNO=odbc_result($rs,"HDOCNO");
$HDOCDATE=odbc_result($rs,"HDOCDATE");
$HDUEDATE=odbc_result($rs,"HDUEDATE");
$HMOUNTH=odbc_result($rs,"HMOUNTH");
$HREMINT=odbc_result($rs,"HREMINT");
$HPROCSTATUS=odbc_result($rs,"HPROCSTATUS");
echo "<tr>";
echo "<td align='center' bgcolor='white'>$HDOCNO</td>";
echo "<td align='center' bgcolor='white'>$HDOCDATE</td>";
echo "<td align='center' bgcolor='white'>$HDUEDATE</td>";
echo "<td align='center' bgcolor='white'>$HMOUNTH</td>";
echo "<td align='center' bgcolor='white'>$HREMINT</td>";
echo "<td align='center' bgcolor='white'><input type=\"checkbox\" name=\"vartb[]\" value=\"".$val[$HPROCSTATUS]."\"></td></tr><br>";
}
echo "</table><br><br>";
echo "<table align='center'><tr>";
echo "<tr>";
echo "<td align='center'><input type=\"submit\" name=\"valide\" value=\"Update\">";
echo "<input type=\"submit\" value=\"Fermer le programme\" onclick=\"window.close();\" /></td></tr>";
echo "</table><br><br>";
echo "</form>";
odbc_close($conn);
?>
</body>
</html> |
Partager