$response["error"] = false;
$response["message"] = "Query Successful";
} else {
// user credentials are wrong
$response['error'] = true;
$response['message'] = "The user vote could not be added to the database";
}
echoResponse(200, $response);
});
$app->get('/updatesfromlocation', function () use($app) {
$response = array();
$sortType = $app->request()->get('sortType');
$locationId = $app->request()->get('locationId');
$db = new DbHandler();
// fetching all user tasks
$result = $db->getUpdatesFromLocation($sortType, $locationId);
if ($result) {
$response["error"] = false;
$response["updates"] = array();
// looping through result and preparing updates array
while ($update = $result->fetch_assoc()) {
$tmp = array();
$tmp["id"] = $update["id"];
$tmp["locationIdFrom"] = $update["locationIdFrom"];
$tmp["locationIdTo"] = $update["locationIdTo"];
$tmp["estTimeToCross"] = $update["estTimeToCross"];
$tmp["situation"] = $update["situation"];
$tmp["description"] = $update["description"];
$tmp["timeOfSituation"] = $update["timeOfSituation"];
$tmp["updaterId"] = $update["updaterId"];
$tmp["updaterName"] = $update["username"];
