/**
* @param null|int $fileId The database ID for the time-series to load TwlData Points for.
*
* @throws InvalidOperationException If database credentials have not been set.
*/
public final function loadTwlTimeSeries($fileId = NULL)
{
if (is_null(self::$databaseCredentials)) {
throw new InvalidOperationException('Database credentials must be set at the class level to allow this action to take place.');
}
TwlFile::setDatabaseCredentials(self::$databaseCredentials);
TwlTimeSeries::setDatabaseCredentials(self::$databaseCredentials);
if (is_null($fileId)) {
$fileData = TwlFile::getLatestFileData($this->getSiteName());
$fileId = (int) $fileData['file_id'];
}
$timeSeriesId = (int) TwlTimeSeries::findClosestTimeSeries($this->position);
$this->timeSeries = TwlTimeSeries::loadTimeSeries($fileId, $timeSeriesId);
}
FROM
twl_files
WHERE
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
