. offer.name -> offer.subname, damit ich eindeutige Feldbezeichner

   hat, PHP kommst sonst nicht vernünftig damit klar
 . order.wml aufgenommen, die nächste Stufe (ja, man muß mehrfach
   klicken und bestätigen, wenn man was bestellen möchte)

diff --git a/src/shop/calc.wml b/src/shop/calc.wml
new file mode 100644 (file)
index 0000000..16acf53
--- /dev/null
+++ b/src/shop/calc.wml
@@ -0,0 +1,85 @@
+#include <infocon.style>
+#include <shop.inc>
+
+<page title="InfoCon - Online-Shop">
+
+<h1 align=center>Bestellungskontrolle</h1>
+
+<form method=post action=order.php3>
+&nbsp;<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:

diff --git a/src/shop/index.wml b/src/shop/index.wml
index 2c65549..e2f87ac 100644 (file)
--- a/src/shop/index.wml
+++ b/src/shop/index.wml
@@ -35,11 +35,11 @@
           ."<font face=\"Helvetica,Arial\"><a href=\"show.php3?article=%s\">%s</a></font></th></tr>",
            $ch, $row['article'], $row['name']);
 
           ."<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);
                                    $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']);
       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']);

diff --git a/src/shop/order.wml b/src/shop/order.wml
new file mode 100644 (file)
index 0000000..402c6b9
--- /dev/null
+++ b/src/shop/order.wml
@@ -0,0 +1,130 @@
+#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>
+&nbsp;<font face="Helvetica,Arial"><b>Stadt</b></font>
+&nbsp;<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:

diff --git a/src/shop/show.wml b/src/shop/show.wml
index 5b52362..e01aa0d 100644 (file)
--- a/src/shop/show.wml
+++ b/src/shop/show.wml
@@ -44,7 +44,7 @@
     }
 
     # Sub-Query
     }
 
     # 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>
                                      $row['article']));
     if (pg_NumRows ($sthi) > 0) {
       <protect>


@@ -53,7 +53,7 @@
       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\">&nbsp;%s</font></td>",
       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\">&nbsp;%s</font></td>",

-                          $rowi['name']);
+                          $rowi['subname']);

        $table .= sprintf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM&nbsp;</font></td></tr>",
                           $rowi['price']);
       }
        $table .= sprintf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM&nbsp;</font></td></tr>",
                           $rowi['price']);
       }


@@ -71,14 +71,6 @@
     </protect>
     printf ("<tr><td width=\60%%\" align=\"left\" valign=\"bottom\">%s</td></tr>", $table);
   
     </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\">&nbsp;%s</font></td>", $cd, $rowi['name']);
-#     printf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM&nbsp;</font></td></tr>", $rowi['price']);
-#   }
-# 

     echo ("</table>");
     echo ($le);
   }
     echo ("</table>");
     echo ($le);
   }