site_id = :selectedSiteId
ORDER BY dateTime DESC
LIMIT 25
MYSQL;
$availableFilesParams['selectedSiteId'] = $siteId;
$availableFilesResult = DatabaseHelper::query($DBH, $availableFilesQuery, $availableFilesParams);
$availableFiles = $availableFilesResult->fetchAll(PDO::FETCH_ASSOC);
if (empty($availableFiles)) {
exit;
}
$fileId = filter_input(INPUT_GET, 'selectedFileId', FILTER_VALIDATE_INT);
if (empty($fileId)) {
$latestFileData = TwlFile::getLatestFileData($siteName);
$fileId = $latestFileData['file_id'];
} else {
$fileData = TwlFile::getDateTimeFromId($fileId);
if (empty($fileData)) {
exit;
}
}
$duneQuery = <<<MYSQL
SELECT
dune_id AS dId,
latitude AS la,
longitude AS lo,
toe,
crest
FROM
dunes
WHERE
site_id = :selectedSiteId
