{

$OUTPUT = "

<h3>View current users</h3>

<table ".TMPL_tblDflts.">

<tr>

<th>Username</th>

<th>Employee</th>

<th>Branch</th>

<th colspan='2'>Options</th>

</tr>";

$sql = "SELECT username, div, empnum FROM cubit.users";

$user_rslt = db_exec($sql) or errDie("Unable to retrieve employee.");

while ($row = pg_fetch_array($user_rslt)) {

$sql = "SELECT enum, sname, fnames FROM cubit.employees

WHERE empnum='$row[empnum]'";

$emp_rslt = db_exec($sql) or errDie("Unable to retrieve employee.");

$emp_data = pg_fetch_array($emp_rslt);

$employee = "$emp_data[sname] $emp_data[fnames] - $emp_data[enum]";

$bran = qryBranch($row["div"]);

$OUTPUT .= "

<tr class='".bg_class()."'>

<td>$row[username]</td>

<td>$employee</td>

<td>$bran[branname]</td>

<td><a href='admin-usredit.php?username=$row[username]'>Edit</a></td>

<td><a href='admin-usrrem.php?username=$row[username]'>Remove</a></td>

</tr>";

}

$OUTPUT .= "</table>";

// $OUTPUT .= mkQuickLinks(

// ql ("","Add User")

// );

return $OUTPUT;