/**
* testing to see that if the aFields are passed by reference do they update the table object?
* @param array containing field sql
* @param array containing field aliases
* @param string table name (depreciated)
* @param array options
*/
function getAsField_html(&$aFields, &$aAsFields, $table = '', $opts = array())
{
if ($this->isJoin()) {
return parent::getAsField_html($aFields, $aAsFields, $table, $opts);
}
$table = $this->actualTableName();
$params =& $this->getParams();
$db =& JFactory::getDBO();
$tableModel =& $this->getTableModel();
$element =& $this->getElement();
$tableRow = $tableModel->getTable();
$joins =& $tableModel->getJoins();
foreach ($joins as $tmpjoin) {
if ($tmpjoin->element_id == $element->id) {
$join =& $tmpjoin;
break;
}
}
$connection =& $tableModel->getConnection();
//make sure same connection as this table
$fullElName = $table . "___" . $element->name;
if ($params->get('join_conn_id') == $connection->_id || $element->plugin != 'fabrikdatabasejoin') {
$join =& $this->getJoin();
$joinTableName = $join->table_join_alias;
$tables = $this->getForm()->getLinkedFabrikTables($params->get('join_db_name'));
// store unjoined values as well (used in non-join group table views)
//this wasnt working for test case:
//events -> (db join) event_artists -> el join (artist)
// $$$ rob in csv import keytable not set
// $$$ hugh - if keytable isn't set, the safeColName blows up!
// Trying to debug issue with linked join elements, which don't get detected by
// getJoins or getJoin 'cos element ID doesn't match element_id in fabrik_joins
//$k = isset($join->keytable ) ? $join->keytable : $join->join_from_table;
//$k = FabrikString::safeColName("`$join->keytable`.`$element->name`");
$keytable = isset($join->keytable) ? $join->keytable : $join->join_from_table;
$k = FabrikString::safeColName("`{$keytable}`.`{$element->name}`");
$k2 = $this->getJoinLabelColumn();
if (JArrayHelper::getValue($opts, 'inc_raw', true)) {
$aFields[] = "{$k} AS " . $db->nameQuote($fullElName . "_raw");
$aAsFields[] = $db->nameQuote($fullElName . "_raw");
}
$aFields[] = "{$k2} AS " . $db->nameQuote($fullElName);
$aAsFields[] = $db->nameQuote($fullElName);
} else {
$aFields[] = $db->nameQuote($table) . '.' . $db->nameQuote($element->name) . ' AS ' . $db->nameQuote($fullElName);
$aAsFields[] = $db->nameQuote($fullElName);
}
}
