#include <infocon.style>
#include <shop.inc>

<page title="Bestellungskontrolle">

<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: