function getEmployees()
{
if (isset($_GET['name'])) {
return getEmployeesByName($_GET['name']);
} else {
if (isset($_GET['modifiedSince'])) {
return getModifiedEmployees($_GET['modifiedSince']);
}
}
$sql = "select e.id, e.firstName, e.lastName, e.title, count(r.id) reportCount " . "from employee e left join employee r on r.managerId = e.id " . "group by e.id order by e.lastName, e.firstName";
try {
$db = getConnection();
$stmt = $db->query($sql);
$employees = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
// Include support for JSONP requests
if (!isset($_GET['callback'])) {
echo json_encode($employees);
} else {
echo $_GET['callback'] . '(' . json_encode($employees) . ');';
}
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
echo "go";
}
function getEmployees()
{
if (isset($_GET['modifiedSince'])) {
getModifiedEmployees($_GET['modifiedSince']);
return;
}
$employees = $_SESSION['employees'];
$result = array();
foreach ($employees as $employee) {
if (!$employee->deleted) {
$result[] = $employee;
}
}
echo json_encode($result);
}
