function testSpeciesExclude() { $t = new FilterQuery(); $result = $t->with(["species_exclude" => [22, 23]])->fetch()->asArray(); foreach ($result as $entry) { $this->assertTrue($entry['species'] != 22 || $entry['species'] != 23); } }
/** * FilterSubQuery constructor. * @param array $values */ public function __construct(array $values = []) { parent::__construct($values); if (isset($values['column'])) { $this->setColumn($values['column']); } }
$q = new RecentQueries(); try { $json = $q->with(["id" => $csv])->fetch(); if ($json instanceof QueryResults) { $json->asArray()[0]["json"]; } else { throw new Exception(); } $params = json_decode($json, true); if (isset($params["page"])) { unset($params["page"]); } if (isset($params["limit"])) { unset($params["limit"]); } $filterQuery = new FilterQuery(); header("Content-Type: text/csv"); header("Content-Disposition: attachment; filename=output.csv"); header("Cache-Control: no-cache, no-store, must-revalidate"); // HTTP 1.1 header("Pragma: no-cache"); // HTTP 1.0 header("Expires: 0"); // Proxies $queryResults = $filterQuery->with($params)->fetch()->asCSV(); } catch (Exception $e) { error("Invalid id"); return; } } else { error("No id provided");
<?php require '../../../core.php'; $query = new FilterQuery(); $query->with(['no_of_species' => 2])->fetch()->asArray();