private function taxonomy_content_query($controller, $params)
{
if (isset($params['id'])) {
$tables = DB_CONTENT . ', ' . DB_CONTENT_LOOKUP;
$columns = DB_CONTENT . '.*';
$where = "content.contentid=content_lookup.content_id and content_lookup.taxa_id=?";
$field = array($params['id']);
$db_results = BuildQuery::all_field_query($tables, $columns, $where, $field);
self::$db_taxonomy_content = $db_results;
}
}
private function taxonomy_row_query($params)
{
if (isset($params['id'])) {
$table = DB_TAXONOMY;
$where = "taxa_id";
$field = array($params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::single_row_query($table, $where, $field);
self::$db_taxonomy_row = $db_results;
}
}
private function taxonomy_content_check($controller, $params)
{
$child_content = array();
if (isset($params['id'])) {
$db_results = $this->taxonomy_content_query($controller, $params);
//check content for passed taxa id
if (empty($db_results)) {
//check for children if no content available
$child_db_results = $this->taxonomy_child_query($params);
foreach ($child_db_results as $key => $val) {
//check values from query
if (is_array($val)) {
//get taxa id for each child
$child_id = $val['taxa_id'];
$params_child['id'] = $child_id;
//check content for each returned child
$db_child_results = $this->taxonomy_content_query($controller, $params_child);
foreach ($db_child_results as $key2 => $val2) {
//push child content
array_push($child_content, $val2);
}
}
}
self::$db_taxonomy_content = $child_content;
} else {
self::$db_taxonomy_content = $db_results;
}
}
}
