private function content_group_query($controller, $format, $group, $params)
{
if (isset($params['id'])) {
$tables = $controller . ', ' . $controller . '_lookup, ' . $controller . '_group, ' . $controller . '_type';
$columns = $controller . '.*';
$where = 'content_lookup.content_id=content.contentid AND content_lookup.content_type_id=content_type.content_type_id AND content_lookup.content_group_id=content_group.content_group_id AND content_type.content_type_name=? AND content_group.content_group_name=? AND content_lookup.taxa_id=?';
$fields = array($format, $group, $params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields);
self::$db_content_group = $db_results;
}
}
private function content_group_query($controller, $format, $group, $params)
{
if (isset($params['id'])) {
$tables = $controller . ', ' . $controller . '_lookup, ' . $controller . '_group, ' . $controller . '_type';
$columns = $controller . '.*';
$where = DB_CONTENT_LOOKUP . '.content_id=' . DB_CONTENT . '.contentid AND ' . DB_CONTENT_LOOKUP . '.content_type_id=' . DB_CONTENT_TYPE . '.content_type_id AND ' . DB_CONTENT_LOOKUP . '.content_group_id=' . DB_CONTENT_GROUP . '.content_group_id AND ' . DB_CONTENT_TYPE . '.content_type_name=? AND ' . DB_CONTENT_GROUP . '.content_group_name=? AND ' . DB_CONTENT_LOOKUP . '.taxa_id=? ORDER BY ' . DB_CONTENT . '.contentid';
$fields = array($format, $group, $params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields);
self::$db_content_group = $db_results;
}
}
