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;
}
