/* store as recent query */
if (Utils::getValue($params["query"], false) === true) {
$recentQueries = new RecentQueries();
$lastId = $recentQueries->with(["json" => $_POST['params']])->store();
}
$filterQuery = new FilterQuery();
$queryResults = $filterQuery->with($params)->fetch();
echo json_encode(["id" => $lastId, "results" => $queryResults->asArray()], JSON_PRETTY_PRINT);
} catch (PDOException $e) {
error("Failure in database connection.");
}
} else {
if (isset($_GET['csv'])) {
$csvPath = SettingsStorage::settings()["csv_file_locations"];
$filename = Utils::sanitizeFilename($_GET['csv']);
FileStorage::downloadFile($filename, $csvPath);
} else {
error("No params provided");
}
}
function error($status)
{
echo json_encode(["error" => $status]);
}
/***
* @param $results QueryResults
* @return string
*/
function createCSVFile($results)
{
$csvPath = SettingsStorage::settings()["csv_file_locations"];
