/* 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"];