'; $sql = 'SELECT id, ' . $layout_def['rname'] . ' title FROM ' . $layout_def['table'] . ' WHERE deleted = 0 ORDER BY title ASC'; $result = $this->reporter->db->query($sql); while ($row = $this->reporter->db->fetchByAssoc($result)) { $html .= ''; } $html .= ''; return $html; } /** * Method returns part of where in style table_alias.id IN (...) because we can't join of relation * * @param array $layout_def definition of a field * @param bool $rename_columns unused * @return string SQL where part */ public function queryFilterStarts_With($layout_def, $rename_columns = true) { $ids = array(); $relation = new Relationship(); $relation->retrieve_by_name($layout_def['link']); global $beanList; $beanClass = $beanList[$relation->lhs_module]; $seed = new $beanClass(); $seed->retrieve($layout_def['input_name0']); $link = new Link2($layout_def['link'], $seed); $sql = $link->getQuery(); $result = $this->reporter->db->query($sql); while ($row = $this->reporter->db->fetchByAssoc($result)) { $ids[] = $row['id']; } $layout_def['name'] = 'id'; return $this->_get_column_select($layout_def) . " IN ('" . implode("', '", $ids) . "')"; } /** * Method returns part of where in style table_alias.id IN (...) because we can't join of relation * * @param array $layout_def definition of a field * @param bool $rename_columns unused * @return string SQL where part */ public function queryFilterone_of($layout_def, $rename_columns = true) { $ids = array(); $relation = new Relationship(); $relation->retrieve_by_name($layout_def['link']); global $beanList; $beanClass = $beanList[$relation->lhs_module]; $seed = new $beanClass(); foreach($layout_def['input_name0'] as $beanId) { $seed->retrieve($beanId); $link = new Link2($layout_def['link'], $seed); $sql = $link->getQuery(); $result = $this->reporter->db->query($sql); while ($row = $this->reporter->db->fetchByAssoc($result)) { $ids[] = $row['id']; } } $ids = array_unique($ids); $layout_def['name'] = 'id'; return $this->_get_column_select($layout_def) . " IN ('" . implode("', '", $ids) . "')"; } //for to_pdf/to_csv function displayListPlain($layout_def) { $reporter = $this->layout_manager->getAttribute("reporter"); $field_def = $reporter->all_fields[$layout_def['column_key']]; $display = strtoupper($field_def['secondary_table'].'_name'); //#31797 , we should get the table alias in a global registered array:selected_loaded_custom_links if(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table']])){ $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table']]['join_table_alias'].'_name'); } elseif(isset($field_def['rep_rel_name']) && isset($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']])) { $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]['join_table_alias'].'_name'); } elseif(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']])){ $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']]['join_table_alias'].'_name'); } $cell = $layout_def['fields'][$display]; return $cell; } function displayList($layout_def) { $reporter = $this->layout_manager->getAttribute("reporter"); $field_def = $reporter->all_fields[$layout_def['column_key']]; $display = strtoupper($field_def['secondary_table'].'_name'); //#31797 , we should get the table alias in a global registered array:selected_loaded_custom_links if(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table']])){ $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table']]['join_table_alias'].'_name'); } elseif(isset($field_def['rep_rel_name']) && isset($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']])) { $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]['join_table_alias'].'_name'); } elseif(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']])){ $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']]['join_table_alias'].'_name'); } $recordField = $this->getTruncatedColumnAlias(strtoupper($layout_def['table_alias']).'_'.strtoupper($layout_def['name'])); $record = $layout_def['fields'][$recordField]; $cell = ""; $cell .= $layout_def['fields'][$display]; $cell .= ""; return $cell; } } ?>