--- /dev/null
+<define-tag get_exhibitor_num>
+<?
+ $kosten_pro_kommerzieller_aussteller = 200.00;
+
+ function get_exhibitor_num ($dbh)
+ {
+ $query = "SELECT count(*) FROM exhibitor WHERE type='Sponsor'";
+ $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");
+
+ $row = pg_fetch_array ($sth, 0);
+ return $row[0] -1; # Mindfactory stellt nicht aus.
+ }
+?>
+</define-tag>
+
+<define-tag get_sponsoring>
+<?
+ function get_sponsoring ($dbh)
+ {
+ $query = "SELECT sum(amount) FROM exhibitor WHERE type='Sponsor'";
+ $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");
+
+ $row = pg_fetch_array ($sth, 0);
+ return $row[0];
+ }
+?>
+</define-tag>
+
$cat="exhibition"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Ausstellung");
$cat="pr"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Öffentlichkeitsarbeit");
$cat="talks"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Vorträge");
+ $cat="devel"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Entwicklertreffen");
?> </select><br>
<b>Verwendungszweck:</b> <input name=descr size=40 maxlength=80 value="<? echo $row['descr']; ?>"> <br>
<b>Betrag:</b> <input name=value_dm size=40 maxlength=20 value="<? echo $row['value_dm']; ?>"> (nnn.mm)<br>
#include <lt2k.style>
+#include "costs.inc"
<page title="LinuxTag 2000 - Kostenverteilung">
Kosten sind wie folgt verteilt:<p>
+<get_exhibitor_num>
+<get_sponsoring>
<?
function get_sum ($dbh, $cat, $status)
{
function category ($dbh, $name, $cat, $start)
{
+ global $num_exhibitors;
+ global $kosten_pro_kommerzieller_aussteller;
+ $zug = "Zugewiesen";
+
+ if ($name == "Gesamt") {
+ $zug = "Sponsoring/Austeller";
+ }
+
printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $name);
echo ("<table width=\"100%\" border=\"1\" cellpadding=\"3\" cellspacing=\"0\">");
$sum = $start;
- echo ("<tr><td width=\"70%\" align=\"left\"><font face=\"Helvetica,Arial\">Zugewiesen</font></td>");
+ printf ("<tr><td width=\"70%%\" align=\"left\"><font face=\"Helvetica,Arial\">%s</font></td>", $zug);
printf ("<td width=\"30%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>", $start);
- $val = get_sum ($dbh, $cat, "open"); $sum += $val;
+ $val = -get_sum ($dbh, $cat, "open"); $sum += $val;
echo ("<tr><td width=\"70%\" align=\"left\"><font face=\"Helvetica,Arial\">Offen</font></td>");
printf ("<td width=\"30%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>", $val);
- $val = get_sum ($dbh, $cat, "done"); $sum += $val;
+ $val = -get_sum ($dbh, $cat, "done"); $sum += $val;
echo ("<tr><td width=\"70%\" align=\"left\"><font face=\"Helvetica,Arial\">Getätigt</font></td>");
printf ("<td width=\"30%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>", $val);
- $val = get_sum ($dbh, $cat, "plan"); $sum += $val;
+ $val = -get_sum ($dbh, $cat, "plan"); $sum += $val;
echo ("<tr><td width=\"70%\" align=\"left\"><font face=\"Helvetica,Arial\">Geplant</font></td>");
printf ("<td width=\"30%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>", $val);
+ if ($name == "Ausstellung" || $name == "Gesamt") {
+ $val = - ($num_exhibitors * $kosten_pro_kommerzieller_aussteller); $sum += $val;
+ echo ("<tr><td width=\"70%\" align=\"left\"><font face=\"Helvetica,Arial\">Universität</font></td>");
+ printf ("<td width=\"30%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></td></tr>", $val);
+ }
+
echo ("<tr><th width=\"70%\" align=\"left\"><font face=\"Helvetica,Arial\">Summe</font></th>");
printf ("<th width=\"30%%\" align=\"right\"><font face=\"Helvetica,Arial\">%6.2f</font></th></tr>", $sum);
$dbh = pg_pconnect ("kuolema", "5432", "lt2k")
or die("Unable to connect to SQL server");
- category ($dbh, "Ausstellung", "exhibition", 500.00);
- category ($dbh, "Öffentlichkeitsarbeit", "pr", 1000.00);
+ $num_exhibitors = get_exhibitor_num ($dbh);
+ category ($dbh, "Ausstellung", "exhibition", 1000.00 + ($num_exhibitors * $kosten_pro_kommerzieller_aussteller));
+ category ($dbh, "Öffentlichkeitsarbeit", "pr", 2000.00);
category ($dbh, "Vorträge", "talks", 1000.00);
+ category ($dbh, "Entwicklertreffen", "devel", 700.00);
- category ($dbh, "Gesamt", "", 0.00);
+ # Pro Sponsor 1.000,-- zzgl. MwSt.
+ #
+ category ($dbh, "Gesamt", "", get_sponsoring ($dbh));
?>
<li> <a href="list.php3">Gesamtliste</a>
<li> Detail: <a href="list.php3?category=exhibition">Ausstellung</a> -
<a href="list.php3?category=talks">Vorträge</a> -
- <a href="list.php3?category=pr">Öffentlichkeitsarbeit</a>
+ <a href="list.php3?category=pr">Öffentlichkeitsarbeit</a> -
+ <a href="list.php3?category=devel">Entwicklertreffen</a>
</blockquote>
#include <lt2k.style>
+#include "costs.inc"
<page title="LinuxTag 2000 - Kostenverteilung">
<th width=15%>Betrag</th>
</tr>
+<get_exhibitor_num>
+<get_sponsoring>
<?
$category['pr'] = "Öffentlichkeit";
$category['talks'] = "Vorträge";
$category['exhibition'] = "Ausstellung";
+ $category['devel'] = "Entwicklertreffen";
$dbh = pg_pconnect ("kuolema", "5432", "lt2k")
or die("Unable to connect to SQL server");
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
$sum = 0.0;
+
+ # Sponsoren
+ #
+ $color = "ffff00";
+ $date = "18.8.2000";
+ $cat = "Ausstellung";
+ $descr = "Sponsoreinnahmen";
+ $status = "plan";
+ $val = get_sponsoring ($dbh);
+ printf ("<tr bgcolor=\"#%s\">", $color);
+ printf ("<td width=\"15%%\" align=\"right\">%s</td>", $date);
+ printf ("<td width=\"20%%\">%s</td>", $cat);
+ printf ("<td width=\"50%%\">%s</td>", $descr);
+ printf ("<td width=\"15%%\" align=\"right\">%5.2f</td>", $val);
+ if (strstr ($HTTP_USER_AGENT, "Lynx")) {
+ printf ("<td> %s</td>", $status);
+ }
+ $sum += $val;
+ echo ("</tr>");
+
+
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
}
printf ("<tr bgcolor=\"#%s\">", $color);
- printf ("<td width=\"15%%\">%s</td>", $date);
+ printf ("<td width=\"15%%\" align=\"right\">%s</td>", $date);
printf ("<td width=\"20%%\">%s</td>", $category[$row['category']]);
printf ("<td width=\"50%%\"><a href=\"edit.php3?oid=%d\">%s</a></td>", $row['oid'], $row['descr']);
printf ("<td width=\"15%%\" align=\"right\">%5.2f</td>", $row['value_dm']);
$sum += $row['value_dm'];
echo ("</tr>");
}
- echo ("<tr>");
- echo ("<th width=\"85%\" colspan=\"3\">Summe</th>");
- printf ("<th width=\"15%%\" align=\"right\">%5.2f</th>", $sum);
- echo ("</tr>");
+
+ # Abgabe an die Uni pro Sponsor
+ #
+ $num_exhibitors = get_exhibitor_num ($dbh);
+ $color = "ffff00";
+ $date = "17.10.2000";
+ $cat = "Ausstellung";
+ $descr = "Universität - Ausstellungsgebühren";
+ $status = "plan";
+ $val = - ($num_exhibitors * $kosten_pro_kommerzieller_aussteller);
+ printf ("<tr bgcolor=\"#%s\">", $color);
+ printf ("<td width=\"15%%\" align=\"right\">%s</td>", $date);
+ printf ("<td width=\"20%%\">%s</td>", $cat);
+ printf ("<td width=\"50%%\">%s</td>", $descr);
+ printf ("<td width=\"15%%\" align=\"right\">%5.2f</td>", $val);
+ if (strstr ($HTTP_USER_AGENT, "Lynx")) {
+ printf ("<td> %s</td>", $status);
+ }
+ $sum += $val;
+ echo ("</tr>");
+
+ echo ("<tr>");
+ echo ("<th width=\"85%\" colspan=\"3\">Summe</th>");
+ printf ("<th width=\"15%%\" align=\"right\">%5.2f</th>", $sum);
+ echo ("</tr>");
?>
</table><p>
<li> <a href="list.php3">Gesamtliste</a>
<li> Detail: <a href="list.php3?category=exhibition">Ausstellung</a> -
<a href="list.php3?category=talks">Vorträge</a> -
- <a href="list.php3?category=pr">Öffentlichkeitsarbeit</a>
+ <a href="list.php3?category=pr">Öffentlichkeitsarbeit</a> -
+ <a href="list.php3?category=devel">Entwicklertreffen</a>
</page>
<li> <a href="list.php3">Gesamtliste</a>
<li> Detail: <a href="list.php3?category=exhibition">Ausstellung</a> -
<a href="list.php3?category=talks">Vorträge</a> -
- <a href="list.php3?category=pr">Öffentlichkeitsarbeit</a>
+ <a href="list.php3?category=pr">Öffentlichkeitsarbeit</a> -
+ <a href="list.php3?category=devel">Entwicklertreffen</a>
</page>