function create_query_from_relationship($field, &$query, &$list_value, &$list_items)
{
foreach ($this->relations as $id => $rel) {
if (back_quote_smart($rel['link_child']) == back_quote_smart($field)) {
$list_value = 'queried_' . strip_back_quote_smart($rel['link_parent']);
$list_items = array();
foreach ($rel['link_subtext'] as $subtext) {
$list_items[] = strip_back_quote_smart($subtext);
}
//**************************************
//Create the query:
require_once 'Subclasses/' . strip_back_quote_smart($rel['table']) . '.php';
$class = strip_back_quote_smart($rel['table']);
$objDB = new $class();
$database = $objDB->DB_USE;
$objDB->close_DB();
$value_field = back_quote_smart($rel['link_parent']) . ' as `Queried_' . strip_back_quote_smart($rel['link_parent']) . '`';
$items_field = '';
foreach ($rel['link_subtext'] as $subtext) {
if (back_quote_smart($subtext) != back_quote_smart($rel['link_parent'])) {
make_list($items_field, strip_back_quote_smart($subtext), $delimiter = ',', $quotes = TRUE, '`', '`');
}
}
$query = "SELECT {$value_field}";
if ($items_field != '') {
$query .= ', ' . $items_field;
}
$query .= ' FROM ' . back_quote_smart($database) . '.' . back_quote_smart($rel['table']);
if ($rel['where_clause'] != '') {
$query .= ' WHERE ' . $rel['Where_clause'];
}
if ($items_field != '') {
$query .= " ORDER BY {$items_field}";
} else {
$query .= ' ORDER BY ' . back_quote_smart($rel['link_parent']);
}
}
}
return $this;
}
function get_listview_fields()
{
$table_name = $this->table_name;
$this->arr_subtext_separators = array();
foreach ($this->fields as $field_name => $field_struct) {
if ($field_struct['in_listview'] == TRUE) {
$make_filter_label = TRUE;
if ($field_struct['attribute'] == 'foreign key' || $field_struct['attribute'] == 'primary&foreign key') {
$has_no_defined_relationship = TRUE;
//find the relationship information for this field; only 1-1
foreach ($this->relations as $key => $rel) {
if (strip_back_quote_smart($rel['link_child']) == $field_name && $rel['type'] == '1-1') {
$has_no_defined_relationship = FALSE;
require_once 'subclasses/' . strip_back_quote_smart($rel['table']) . '.php';
$class = strip_back_quote_smart($rel['table']);
$data_con = new $class();
$database = $data_con->db_use;
$temp_field_name = '';
$filter_field_name = '';
$arr_subtexts = array();
$arr_subtext_labels = array();
$subtext_cntr = 0;
foreach ($rel['link_subtext'] as $subtext) {
if ($temp_field_name != '') {
$temp_field_name .= ', ';
}
if ($filter_field_name != '') {
$filter_field_name .= ', ';
}
if (isset($rel['alias']) && $rel['alias'] != '') {
$temp_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['alias']) . '.' . back_quote_smart($subtext) . ' AS ' . back_quote_smart($database . '_' . $rel['alias'] . '_' . $subtext);
$filter_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['alias']) . '.' . back_quote_smart($subtext);
$arr_subtexts[] = $database . '_' . $rel['alias'] . '_' . $subtext;
} else {
$temp_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['table']) . '.' . back_quote_smart($subtext) . ' AS ' . back_quote_smart($database . '_' . $rel['table'] . '_' . $subtext);
$filter_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['table']) . '.' . back_quote_smart($subtext);
$arr_subtexts[] = $database . '_' . $rel['table'] . '_' . $subtext;
}
$arr_subtext_labels[] = $data_con->fields[$subtext]['label'];
++$subtext_cntr;
}
if ($subtext_cntr > 1) {
foreach ($arr_subtext_labels as $new_filter_label) {
make_list_array($this->arr_filter_field_labels, $new_filter_label);
}
$make_filter_label = FALSE;
}
if (isset($this->fields[$field_name]['list_settings']['list_separators'])) {
$this->arr_subtext_separators[] = $this->fields[$field_name]['list_settings']['list_separators'];
}
$related_field_name = $temp_field_name;
make_list($this->lst_fields, back_quote_smart($related_field_name), ',', FALSE);
make_list($this->lst_filter_fields, back_quote_smart($filter_field_name), ',', FALSE);
$this->arr_fields[] = $arr_subtexts;
if ($field_struct['attribute'] == 'primary&foreign key') {
//if foreign key is also a primary key, we also need the original field aside from the subtext field
$orig_field_name = back_quote_smart($table_name) . '.' . back_quote_smart($field_name);
make_list($this->lst_fields, back_quote_smart($orig_field_name), ',', FALSE);
}
}
}
if ($has_no_defined_relationship) {
error_handler('Cannot render ListView, incorrect configuration.', ' Missing relationship information for foreign-key column "' . $field_name . '".');
}
} else {
make_list($this->lst_fields, back_quote_smart($table_name) . '.' . back_quote_smart($field_name), ',', FALSE);
make_list($this->lst_filter_fields, back_quote_smart($table_name) . '.' . back_quote_smart($field_name), ',', FALSE);
make_list_array($this->arr_fields, $field_name);
}
make_list($this->lst_field_labels, $field_struct['label'], ',');
make_list_array($this->arr_field_labels, $field_struct['label']);
if ($make_filter_label) {
make_list_array($this->arr_filter_field_labels, $field_struct['label']);
}
} elseif ($field_struct['attribute'] == 'primary key') {
make_list($this->lst_fields, back_quote_smart($table_name) . '.' . back_quote_smart($field_name), ',', FALSE);
}
}
return $this;
}
