function OpenApp($title)
{
$_retval = false;
if (!OpenDB()) {
return $_retval;
}
if (!empty($title)) {
AppHeader($GLOBALS['appName'] . "-" . $title);
}
$GLOBALS['accessRights'] = "rw";
// CHECK APPLICATION SECURITY HERE (in this example, "r" gives read-only access and "rw" gives read/write access)
if (empty($GLOBALS['accessRights']) || !isset($GLOBALS['accessRights']) || substr($GLOBALS['accessRights'], 0, 1) != "r") {
echo "<p class='error'>You do not have permission to access this application";
} else {
$_retval = true;
}
return $_retval;
}
?>
<div style='float:left;font-size:9pt;width:18%;color:blue;font-family:Verdana, Arial, Helvetica, sans-serif;'>
<p>In this scenario, you are a sales manager and you must assign your sales staff by customer and product category.
<p>Drag over cells to select them (doesn't work in FF if the cell is empty). You can also select using shift-click and ctrl-click.
Ctrl-click cannot be used to select in Safari or Opera because this is the combination to invoke the context menu on those browsers.
<p>Once some cells are selected, right-click (ctrl-click in Opera or Safari) to select an employee from the pop-up menu.
<p>The selection will be filled with the selected employee. Notice that the
employee names and selections scroll with the grid.
</div>
<div class="container">
<?php
if (OpenDB()) {
AppHeader("Sales Assignments By Customer & Product Category");
echo "<p class='ricoBookmark'><span id='emptab_bookmark' style='font-size:10pt;'> </span></p>";
DisplayTable();
}
CloseApp();
function DisplayTable()
{
global $oDB;
echo "<table id='emptab'>";
echo "<thead><tr><th>ID</th><th>Company</th>";
$rsLookup = $oDB->RunQuery("Select CategoryID, CategoryName From categories Order By CategoryName");
while ($oDB->db->FetchRow($rsLookup, $row)) {
echo "<th style='width:100px;'>" . $row[1] . "</th>";
}
$oDB->rsClose($rsLookup);
echo "</tr></thead><tbody>";
