--- /dev/null
+#include <infocon.style>
+#include <shop.inc>
+
+<page title="InfoCon - Online-Shop">
+
+<h1 align=center>Bestellungskontrolle</h1>
+
+<form method=post action=order.php3>
+ <table width=100% border=0 cellpadding=0 cellspacing=0>
+
+<?
+ # So werden 1 Pixel dicke Rahmen erzeugt
+ $la = "<tr><td width=\"2\" bgcolor=\"#000000\"></td><td bgcolor=\"#000000\"><table cellpadding=\"0\" cellspacing=\"1\" width=\"100%\" border=\"0\" summary=\"\"><tr><td bgcolor=\"#ffffff\">";
+ $le = "</td></tr></table></td></tr>";
+# $ch = "#5dbbf9";
+# $cd = "#9bd4fa";
+# $ch = "#85c5f0";
+# $cd = "#abdcfc";
+ $ch = "#abdcfc";
+ $cd = "#eff0f1";
+
+ $tind = "<tr bgcolor=\"$ch\"><th><font face=\"Helvetica,Arial\">Anzahl</font></th>"
+ ."<th align=\"left\"><font face=\"Helvetica,Arial\">Artikel</font></th>"
+ ."<th align=\"right\"><font face=\"Helvetica,Arial\">Einzel</font></th>"
+ ."<th align=\"right\"><font face=\"Helvetica,Arial\">Gesamt</font></th></tr>";
+
+ $dbh = dbconnect();
+
+ // WHERE spool > 0
+ $sth = dbquery ($dbh, "SELECT article.name,article.article,offer.subname,offer.price,offer.articleid "
+ ."FROM article,offer WHERE article.article = offer.article ORDER BY offer.articleid");
+
+ $sum = 0.0;
+ echo ($la);
+ echo ("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\">");
+
+ $color = $cd;
+ for ($i=0; $i < pg_NumRows ($sth); $i++) {
+ $row = pg_fetch_array ($sth, $i);
+
+ if (${$row['articleid']} > 0) {
+ if ($sum == 0.0) {
+ echo ($tind);
+ }
+ $color = $color == $cd?"#ffffff":$cd;
+ printf ("<tr bgcolor=\"%s\">", $color);
+ printf ("<td width=\"10%%\" align=\"center\"><font face=\"Helvetica,Arial\">"
+ ."<input name=\"%s\" size=\"3\" maxlength=\"3\" value=\"%d\"></font></td>",
+ $row['articleid'], ${$row['articleid']});
+
+ printf ("<td width=\"70%%\" align=\"left\"><font face=\"Helvetica,Arial\">"
+ ."<a href=\"show.php3?article=%s\">%s, %s</a></font></td>",
+ $row['article'], $row['name'], $row['subname']);
+
+ printf ("<td width=\"10%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td>",
+ $row['price']);
+
+ printf ("<td width=\"10%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>",
+ $row['price'] * ${$row['articleid']});
+ $sum += $row['price'] * ${$row['articleid']};
+ }
+ }
+ if ($sum == 0.0) {
+ printf ("<tr bgcolor=\"%s\"><th colspan=\"4\" align=\"left\"><font face=\"Helvetica,Arial\">%s</font></th>",
+ $ch, "Sie haben vergessen, Waren auszuwählen");
+ } else {
+ printf ("<tr bgcolor=\"%s\"><th colspan=\"3\" align=\"left\"><font face=\"Helvetica,Arial\">Summe</font></th>", $ch);
+ printf ("<th align=\"right\"><font face=\"Helvetica,Arial\">%7.2f</font></th></tr>", $sum);
+ }
+ echo ("</table>");
+ echo ($le);
+?>
+
+</table>
+<? if ($sum > 0.0) { ?>
+<p><center><input type=submit value="Bestellen"> . <input type=reset value="Reset"></center>
+<? } ?>
+</form><p>
+
+</page>
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# mode-: iso-accents
+# end:
."<font face=\"Helvetica,Arial\"><a href=\"show.php3?article=%s\">%s</a></font></th></tr>",
$ch, $row['article'], $row['name']);
- $sthi = dbquery ($dbh, sprintf ("SELECT name,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
+ $sthi = dbquery ($dbh, sprintf ("SELECT subname,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
$row['article']));
for ($ii=0; $ii < pg_NumRows ($sthi); $ii++) {
$rowi = pg_fetch_array ($sthi, $ii);
- printf ("<tr bgcolor=\"%s\"><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\">%s</font></td>", $cd, $rowi['name']);
+ printf ("<tr bgcolor=\"%s\"><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\">%s</font></td>", $cd, $rowi['subname']);
printf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM</font></td>", $rowi['price']);
printf ("<td align=\"center\" width=\"10%%\"><font face=\"Helvetica,Arial\"><input name=\"%s\" size=\"3\" maxlength=\"3\">"
."</font></td></tr>", $rowi['articleid']);
--- /dev/null
+#include <infocon.style>
+#include <shop.inc>
+
+<define-tag la><p><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\"><tr><td width=\"2\" bgcolor=\"#000000\"></td><td bgcolor=\"#000000\"><table cellpadding=\"0\" cellspacing=\"1\" width=\"100%\" border=\"0\" summary=\"\"><tr><td bgcolor=\"#ffffff\"><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\"></define-tag>
+<define-tag le></table></td></tr></table></td></tr></table></define-tag>
+
+<page title="InfoCon - Online-Shop">
+
+<h1 align=center>Bestellung aufgeben</h1>
+
+<form method=post action=orderit.php3>
+
+<?
+ # So werden 1 Pixel dicke Rahmen erzeugt
+ $la = "<la>";
+ $le = "<le>";
+# $ch = "#5dbbf9";
+# $cd = "#9bd4fa";
+# $ch = "#85c5f0";
+# $cd = "#abdcfc";
+ $ch = "#abdcfc";
+ $cd = "#eff0f1";
+
+ $tind = "<tr bgcolor=\"$ch\"><th><font face=\"Helvetica,Arial\">Anzahl</font></th>"
+ ."<th align=\"left\"><font face=\"Helvetica,Arial\">Artikel</font></th>"
+ ."<th align=\"right\"><font face=\"Helvetica,Arial\">Einzel</font></th>"
+ ."<th align=\"right\"><font face=\"Helvetica,Arial\">Gesamt</font></th></tr>";
+
+ $dbh = dbconnect();
+
+ // WHERE spool > 0
+ $sth = dbquery ($dbh, "SELECT article.name,article.article,offer.subname,offer.price,offer.articleid "
+ ."FROM article,offer WHERE article.article = offer.article ORDER BY offer.articleid");
+
+ $sum = 0.0;
+ echo ($la);
+
+ $color = $cd;
+ for ($i=0; $i < pg_NumRows ($sth); $i++) {
+ $row = pg_fetch_array ($sth, $i);
+
+ if (${$row['articleid']} > 0) {
+ if ($sum == 0.0) {
+ echo ($tind);
+ }
+ $color = $color == $cd?"#ffffff":$cd;
+ printf ("<tr bgcolor=\"%s\">", $color);
+ printf ("<td width=\"10%%\" align=\"center\"><font face=\"Helvetica,Arial\">"
+ ."<input type=\"hidden\" name=\"%s\" value=\"%d\">%d</font></td>",
+ $row['articleid'], ${$row['articleid']}, ${$row['articleid']});
+
+ printf ("<td width=\"70%%\" align=\"left\"><font face=\"Helvetica,Arial\">"
+ ."<a href=\"show.php3?article=%s\">%s, %s</a></font></td>",
+ $row['article'], $row['name'], $row['subname']);
+
+ printf ("<td width=\"10%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td>",
+ $row['price']);
+
+ printf ("<td width=\"10%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>",
+ $row['price'] * ${$row['articleid']});
+ $sum += $row['price'] * ${$row['articleid']};
+ }
+ }
+ if ($sum == 0.0) {
+ printf ("<tr bgcolor=\"%s\"><th colspan=\"4\" align=\"left\"><font face=\"Helvetica,Arial\">%s</font></th>",
+ $ch, "Sie haben vergessen, Waren auszuwählen");
+ } else {
+ printf ("<tr bgcolor=\"%s\"><th colspan=\"3\" align=\"left\"><font face=\"Helvetica,Arial\">Summe</font></th>", $ch);
+ printf ("<th align=\"right\"><font face=\"Helvetica,Arial\">%7.2f</font></th></tr>", $sum);
+ }
+ echo ($le);
+?>
+
+<? if ($sum > 0.0) { ?>
+<p><b>Bitte geben Sie Ihre Kundennummer oder Ihre Anschrift ein.</b>
+
+<: print "<la>"; :>
+<tr>
+<td align=right><font face="Helvetica,Arial"><b>Kundennr.</b></font></td>
+<td width=5></td>
+<td align=left><font face="Helvetica,Arial"><input name=customer size=30 maxlength=10></font></td>
+<td align=right><font face="Helvetica,Arial"><b>Paßwort</b></font></td>
+<td width=5></td>
+<td align=left><font face="Helvetica,Arial"><input name=passwd type=password size=30 maxlength=10></font></td>
+</tr>
+<: print "<le>"; :>
+
+<define-tag field>
+<set-var %attributes>
+<tr>
+<td align=right width=15%><font face="Helvetica,Arial"><b><get-var n></b></font></td>
+<td width=5></td>
+<td align=left><font face="Helvetica,Arial"><input name=<get-var f> size=50 maxlength=<get-var s>></font></td>
+</tr>
+</define-tag>
+
+<: print "<la>"; :>
+<field n=Firma f=company s=60>
+<field n=Name f=lastname s=60>
+<field n=Vorname f=firstname s=60>
+<field n=Zusatz f=appendix s=60>
+<field n=Straße f=street s=60>
+
+<tr>
+<td align=right width=15%><font face="Helvetica,Arial"><b>PLZ</b></font></td>
+<td width=5></td>
+<td align=left><font face="Helvetica,Arial"><input name=plz size=5 maxlength=5></font>
+ <font face="Helvetica,Arial"><b>Stadt</b></font>
+ <font face="Helvetica,Arial"><input name=city size=37 maxlength=60></font></td>
+</tr>
+
+<tr>
+<td align=right width=15%><font face="Helvetica,Arial"><b>Land</b></font></td>
+<td width=5></td>
+<td align=left><font face="Helvetica,Arial">Deutschland<input type=hidden name=country value=Germany size=50 maxlength=60></font></td>
+</tr>
+
+<: print "<le>"; :>
+
+
+<p><center><input type=submit value="Bestellen"> . <input type=reset value="Reset"></center>
+<? } ?>
+</form><p>
+
+</page>
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# mode-: iso-accents
+# end:
}
# Sub-Query
- $sthi = dbquery ($dbh, sprintf ("SELECT name,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
+ $sthi = dbquery ($dbh, sprintf ("SELECT subname,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
$row['article']));
if (pg_NumRows ($sthi) > 0) {
<protect>
for ($ii=0; $ii < pg_NumRows ($sthi); $ii++) {
$rowi = pg_fetch_array ($sthi, $ii);
$table .= sprintf ("<tr><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\"> %s</font></td>",
- $rowi['name']);
+ $rowi['subname']);
$table .= sprintf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM </font></td></tr>",
$rowi['price']);
}
</protect>
printf ("<tr><td width=\60%%\" align=\"left\" valign=\"bottom\">%s</td></tr>", $table);
-# $sthi = dbquery ($dbh, sprintf ("SELECT name,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
-# $row['article']));
-# for ($ii=0; $ii < pg_NumRows ($sthi); $ii++) {
-# $rowi = pg_fetch_array ($sthi, $ii);
-# printf ("<tr bgcolor=\"%s\"><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\"> %s</font></td>", $cd, $rowi['name']);
-# printf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM </font></td></tr>", $rowi['price']);
-# }
-#
echo ("</table>");
echo ($le);
}