From 5aa6b7d3aa3a5fb28a2f66fb8198730974c1b306 Mon Sep 17 00:00:00 2001 From: Joey Schulze Date: Sun, 3 Dec 2000 11:11:08 +0000 Subject: [PATCH] =?utf8?q?=20.=20offer.name=20->=20offer.subname,=20damit?= =?utf8?q?=20ich=20eindeutige=20Feldbezeichner=20=20=20=20hat,=20PHP=20kom?= =?utf8?q?mst=20sonst=20nicht=20vern=C3=BCnftig=20damit=20klar=20=20.=20or?= =?utf8?q?der.wml=20aufgenommen,=20die=20n=C3=A4chste=20Stufe=20(ja,=20man?= =?utf8?q?=20mu=C3=9F=20mehrfach=20=20=20=20klicken=20und=20best=C3=A4tige?= =?utf8?q?n,=20wenn=20man=20was=20bestellen=20m=C3=B6chte)?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- src/shop/calc.wml | 85 +++++++++++++++++++++++++++++ src/shop/index.wml | 4 +- src/shop/order.wml | 130 +++++++++++++++++++++++++++++++++++++++++++++ src/shop/show.wml | 12 +---- 4 files changed, 219 insertions(+), 12 deletions(-) create mode 100644 src/shop/calc.wml create mode 100644 src/shop/order.wml diff --git a/src/shop/calc.wml b/src/shop/calc.wml new file mode 100644 index 0000000..16acf53 --- /dev/null +++ b/src/shop/calc.wml @@ -0,0 +1,85 @@ +#include +#include + + + +

Bestellungskontrolle

+ +
+  + +"; +# $ch = "#5dbbf9"; +# $cd = "#9bd4fa"; +# $ch = "#85c5f0"; +# $cd = "#abdcfc"; + $ch = "#abdcfc"; + $cd = "#eff0f1"; + + $tind = "" + ."" + ."" + .""; + + $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 ("
"; + $le = "
AnzahlArtikelEinzelGesamt
"); + + $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 ("", $color); + printf ("", + $row['articleid'], ${$row['articleid']}); + + printf ("", + $row['article'], $row['name'], $row['subname']); + + printf ("", + $row['price']); + + printf ("", + $row['price'] * ${$row['articleid']}); + $sum += $row['price'] * ${$row['articleid']}; + } + } + if ($sum == 0.0) { + printf ("", + $ch, "Sie haben vergessen, Waren auszuwählen"); + } else { + printf ("", $ch); + printf ("", $sum); + } + echo ("
" + ."" + ."%s, %s%6.2f%6.2f
%s
Summe%7.2f
"); + echo ($le); +?> + + + 0.0) { ?> +

.
+ +

+ + +# 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 --- a/src/shop/index.wml +++ b/src/shop/index.wml @@ -35,11 +35,11 @@ ."%s", $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 ("%s", $cd, $rowi['name']); + printf ("%s", $cd, $rowi['subname']); printf ("%6.2f DM", $rowi['price']); printf ("" ."", $rowi['articleid']); diff --git a/src/shop/order.wml b/src/shop/order.wml new file mode 100644 index 0000000..402c6b9 --- /dev/null +++ b/src/shop/order.wml @@ -0,0 +1,130 @@ +#include +#include + +

+
+ + + +

Bestellung aufgeben

+ +
+ +"; + $le = ""; +# $ch = "#5dbbf9"; +# $cd = "#9bd4fa"; +# $ch = "#85c5f0"; +# $cd = "#abdcfc"; + $ch = "#abdcfc"; + $cd = "#eff0f1"; + + $tind = "Anzahl" + ."Artikel" + ."Einzel" + ."Gesamt"; + + $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 ("", $color); + printf ("" + ."%d", + $row['articleid'], ${$row['articleid']}, ${$row['articleid']}); + + printf ("" + ."%s, %s", + $row['article'], $row['name'], $row['subname']); + + printf ("%6.2f", + $row['price']); + + printf ("%6.2f", + $row['price'] * ${$row['articleid']}); + $sum += $row['price'] * ${$row['articleid']}; + } + } + if ($sum == 0.0) { + printf ("%s", + $ch, "Sie haben vergessen, Waren auszuwählen"); + } else { + printf ("Summe", $ch); + printf ("%7.2f", $sum); + } + echo ($le); +?> + + 0.0) { ?> +

Bitte geben Sie Ihre Kundennummer oder Ihre Anschrift ein. + +<: print ""; :> + +Kundennr. + + +Paßwort + + + +<: print ""; :> + + + + + + + size=50 maxlength=> + + + +<: print ""; :> + + + + + + + +PLZ + + + Stadt +  + + + +Land + +Deutschland + + +<: print ""; :> + + +

.
+ +

+ + +# 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 --- a/src/shop/show.wml +++ b/src/shop/show.wml @@ -44,7 +44,7 @@ } # 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) { @@ -53,7 +53,7 @@ for ($ii=0; $ii < pg_NumRows ($sthi); $ii++) { $rowi = pg_fetch_array ($sthi, $ii); $table .= sprintf (" %s", - $rowi['name']); + $rowi['subname']); $table .= sprintf ("%6.2f DM ", $rowi['price']); } @@ -71,14 +71,6 @@ printf ("%s", $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 (" %s", $cd, $rowi['name']); -# printf ("%6.2f DM ", $rowi['price']); -# } -# echo (""); echo ($le); } -- 2.20.1