function printEmployees2()
{
global $employee;
global $admin;
global $area;
global $db;
$text = "";
if ($admin) {
$text .= "<select id='employees' name='employees' onchange><option value=''>Select Employee</option>";
try {
$employeeQuery = $db->prepare("SELECT * FROM `employee` WHERE `active`=1 AND `area`=:area ORDER BY `lastName`");
$employeeQuery->execute(array(':area' => $area));
} catch (PDOException $e) {
exit("error in query");
}
while ($row = $employeeQuery->fetch(PDO::FETCH_ASSOC)) {
if ($employee == $row['netID']) {
$text .= "<option value='{$row['netID']}' selected> {$row['lastName']}, {$row['firstName']}</option>";
} else {
$text .= "<option value='{$row['netID']}'> {$row['lastName']}, {$row['firstName']}</option>";
}
}
$employees = getEmployeesNotDefaultedToCurArea();
foreach ($employees as $curEmployee) {
try {
$employeeQuery = $db->prepare("SELECT firstName, lastName, netID FROM employee WHERE netID=:netId");
$employeeQuery->execute(array(':netId' => $curEmployee));
} catch (PDOException $e) {
exit("error in query");
}
$info = $employeeQuery->fetch(PDO::FETCH_ASSOC);
if ($employee == $curEmployee) {
$text .= "<option value='" . $info['netID'] . "' selected>*" . $info['lastName'] . ", " . $info['firstName'] . "</option>";
} else {
$text .= "<option value='" . $info['netID'] . "'>*" . $info['lastName'] . ", " . $info['firstName'] . "</option>";
}
}
$text .= "</select>";
} else {
$text .= nameByNetId($employee);
}
return $text;
}
function fillNondefaultedEmployeesSelected($netID)
{
global $db;
$employees = getEmployeesNotDefaultedToCurArea();
$employeeFiller = "";
foreach ($employees as $curEmployee) {
try {
$employeeQuery = $db->prepare("SELECT firstName, lastName, netID FROM employee WHERE netID=:netID");
$employeeQuery->execute(array(':netID' => $curEmployee));
} catch (PDOException $e) {
exit("error in query");
}
$info = $employeeQuery->fetch();
if ($netID == $curEmployee) {
$employeeFiller .= "<option value='" . $info->netID . "' selected>" . $info->firstName . ", " . $info->lastName . "*</option>";
} else {
$employeeFiller .= "<option value='" . $info->netID . "'>" . $info->firstName . ", " . $info->lastName . "*</option>";
}
}
echo $employeeFiller;
}
