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; }