root/caffeine/trunk/main.inc.php

<?php

require('funcs.inc.php');

function dump_dispense()
{
   require "main.inc.php";
   mysql_select_db("soda", $db);

   $sodas = mysql_query("SELECT time,acm_integrate.users.netid,sodas.name,price FROM acm_integrate.users left join acm_integrate.vending using(uid) left join sodas using(sid) ORDER BY time", $db);
   echo "<table>\n<tr class=\"header\"><td>time</td><td></td><td></td><td>user</td><td>soda</td><td>price</td></tr>";

   while ($soda = mysql_fetch_row($sodas))
      echo "<tr><td><?=$soda[0]?></td><td></td><td></td><td><?=$soda[1]?></td><td><?=$soda[2]?></td> <td><?=$soda[3]?></td> </tr>";

   echo "</table>";
}

function dump_users()
{
   global $db;
   $users = mysql_query("SELECT * FROM users ORDER BY username", $db);
   echo "<table> <tr class=header><td>cardid</td><td>username</td><td>first</td><td>last</td><td>email</td> <td>balance</td><td>lpbalance</td><td>notify_balance</td><td>calories</td><td>caffeine</td> <td>spent</td><td>sodas</td><td>margin</td><td>admin</td></tr>";

   while ($user = mysql_fetch_row($users))
      echo "<tr><td><?=$user[1]?></td> <td><?=$user[2]?></td><td><?=$user[3]?></td><td><?=$user[4]?></td> <td><?=$user[5]?></td><td><?=$user[7]?></td><td><?=$user[8]?></td><td><?=$user[9]?></td> <td><?=$user[10]?></td><td><?=$user[11]?></td><td><?=$user[12]?></td><td><?=$user[13]?></td> <td><?=$user[14]?></td><td><?=$user[15]?></td> </tr>";
}

function admin_section()
{
   global $db;
   // this is stuff that should only appear for administrators
   echo "<h1>Administrator Options</h1>\n";
   // machine update
   echo "<h2>Machine Update</h2>\n";
   require("status.php");
   machine_update_menu($db);

   
   $a = mysql_fetch_row(mysql_query("SELECT ROUND(SUM(balance),2) FROM acm_integrate.vending WHERE balance >= 0", $db));
   $balance = $a[0];
   echo "<p>Total Outstanding Balance: \$ $balance</p>\n";
  // $a = mysql_fetch_row(mysql_query("SELECT ROUND(SUM(balance),2) FROM acm_integrate.vending WHERE balance < 0", $db));
   $balance = $a[0];
 //  echo "<p>Total Outstanding Negative Balance: \$ $balance</p>\n";
   // change user status

   // add soda
//   echo "<h2>Add Soda Type</h2>";
}

function machine_update_menu()
{
   global $db;

   echo "<form action=\"user_admin.php\" method=\"POST\">";
   echo "<input type=\"hidden\" name=\"op\" value=\"change\">";
   echo "<table border=\"0\" cellspacing=\"5\" cellpadding=\"5\">";
   echo "<tr class=header><td>Tray</td><td>Beverage</td><td>Quantity</td></tr>";
   echo "<tr>";
   echo "<td>";
   echo "<select class=\"dropdown\" name=\"tray\">";
   echo " <option value=\"4\">4 - Left</option>";
   echo " <option value=\"3\">3</option>";
   echo " <option value=\"2\">2</option>";
   echo " <option value=\"1\">1</option>";
   echo " <option value=\"0\">0 - Right</option>";
   echo "</select>";
   echo "</td>";
   echo "<td>";
   echo "<select class=\"dropdown\" name=\"soda\">";

   $slist = mysql_query("SELECT sid,name FROM sodas ORDER BY name", $db);
   while ($s = mysql_fetch_row($slist))
      echo "\t<option value=\"{$s[0]}\">{$s[1]}</option>\n";

   echo "</select></td>\n";
   echo "<td><input type=\"text\" size=\"2\" name=\"qty\"></td>\n";
   echo "<td><input type=\"submit\" name=\"submit\" value=\"Change\"></td>\n";
   echo "</table></form>\n";
}

function show_user()
{
}

?>