public function doBuildQuery(array $values) { $query = parent::doBuildQuery($values); if ($values['taxon_level_ref'] != '') { $query->andWhere('taxon_level_ref = ?', intval($values['taxon_level_ref'])); } $this->addNamingColumnQuery($query, 'taxonomy', 'taxon_name_indexed', $values['taxon_name'], null, 'taxon_name_indexed'); $query->limit($this->getCatalogueRecLimits()); return $query; }
public function getStylesheets() { $items = parent::getStylesheets(); $items['/leaflet/leaflet.css'] = 'all'; $items['/leaflet/MarkerCluster.css'] = 'all'; $items['/Leaflet.draw/dist/leaflet.draw.css'] = 'all'; return $items; }
public function doBuildQuery(array $values) { $query = Doctrine_Query::create()->from('Specimens s'); $this->options['query'] = $query; $query = parent::doBuildQuery($values); if ($values['taxon_level_ref'] != '') { $query->andWhere('taxon_level_ref = ?', intval($values['taxon_level_ref'])); } if ($values['chrono_level_ref'] != '') { $query->andWhere('chrono_level_ref = ?', intval($values['chrono_level_ref'])); } if ($values['litho_level_ref'] != '') { $query->andWhere('litho_level_ref = ?', intval($values['litho_level_ref'])); } if ($values['lithology_level_ref'] != '') { $query->andWhere('lithology_level_ref = ?', intval($values['lithology_level_ref'])); } if ($values['mineral_level_ref'] != '') { $query->andWhere('mineral_level_ref = ?', intval($values['mineral_level_ref'])); } if ($values['taxon_common_name'] != '') { $this->addCommonNamesColumnQuery($query, 'taxonomy', 'taxon_ref', $values['taxon_common_name']); } if ($values['chrono_common_name'] != '') { $this->addCommonNamesColumnQuery($query, 'chronostratigraphy', 'chrono_ref', $values['chrono_common_name']); } if ($values['litho_common_name'] != '') { $this->addCommonNamesColumnQuery($query, 'lithostratigraphy', 'litho_ref', $values['litho_common_name']); } if ($values['lithology_common_name'] != '') { $this->addCommonNamesColumnQuery($query, 'lithology', 'lithology_ref', $values['lithology_common_name']); } if ($values['mineral_common_name'] != '') { $this->addCommonNamesColumnQuery($query, 'mineralogy', 'mineral_ref', $values['mineral_common_name']); } $this->addNamingColumnQuery($query, 'taxonomy', 'taxon_name_indexed', $values['taxon_name'], 's', 'taxon_name_indexed'); $this->addNamingColumnQuery($query, 'chronostratigraphy', 'chrono_name_indexed', $values['chrono_name'], 's', 'chrono_name_indexed'); $this->addNamingColumnQuery($query, 'lithostratigraphy', 'litho_name_indexed', $values['litho_name'], 's', 'litho_name_indexed'); $this->addNamingColumnQuery($query, 'lithology', 'lithology_name_indexed', $values['lithology_name'], 's', 'lithology_name_indexed'); $this->addNamingColumnQuery($query, 'mineralogy', 'mineral_name_indexed', $values['mineral_name'], 's', 'mineral_name_indexed'); $query->andWhere('collection_is_public = true'); if ($values['tags'] != '') { $query->andWhere("gtu_country_tag_indexed && getTagsIndexedAsArray(?)", $values['tags']); } $query->limit($this->getCatalogueRecLimits()); return $query; }