/**
* Get the AutoCode to insert.
*
* @param EcrTable $table A EcrTable object
* @param string $indent The string to indent with
*
* @return string
*/
public function getCode(EcrTable $table, $indent = '')
{
$ret = '';
$fields = array();
$aliases = '';
$relations = '';
$fields = '';
$charCode = 98;
// b
foreach ($table->getFields() as $field) {
if (!$field->display) {
continue;
}
$fields[] = 'a.' . $field->name;
}
//foreach
$fields = implode(', ', $fields);
if (count($table->getRelations())) {
foreach ($table->getRelations() as $relation) {
$relations .= $indent . ".' " . $relation->type . ' #__' . $relation->onTable . ' AS ' . chr($charCode) . ' ON ' . chr($charCode) . '.' . $relation->onField . ' = a.' . $relation->field . "'";
if (count($relation->aliases)) {
foreach ($relation->aliases as $alias) {
$aliases .= ', ' . chr($charCode) . '.' . $alias->aliasField . ' AS ' . $alias->alias;
}
//foreach
}
$charCode++;
}
//foreach
$relations .= NL;
}
$ret .= $indent . '$query = \' SELECT ' . $fields . $aliases . "'" . NL . $indent . '.\' FROM #__' . $table->name . ' AS a \'' . NL . $relations . ';';
$ret .= NL;
return $ret;
}
/**
* Get the AutoCode to insert.
*
* @param EcrTable $table A EcrTable object
* @param string $indent The string to indent with
*
* @return string
*/
public function getCode(EcrTable $table, $indent = '')
{
$ret = '';
$fields = array();
$aliases = '';
$relations = '';
$fields = '';
$charCode = 98;
// b
foreach ($table->getFields() as $field) {
if (!$field->display) {
continue;
}
$fields[] = 'a.' . $field->name;
}
//foreach
$fields = implode(', ', $fields);
if (count($table->getRelations())) {
foreach ($table->getRelations() as $relation) {
$rType = str_replace(' ', '', strtolower($relation->type));
$relations .= $indent . '$query->' . $rType . '(\' #__' . $relation->onTable . ' AS ' . chr($charCode) . ' ON ' . chr($charCode) . '.' . $relation->onField . ' = a.' . $relation->field . '\');';
if (count($relation->aliases)) {
foreach ($relation->aliases as $alias) {
$aliases .= ', ' . chr($charCode) . '.' . $alias->aliasField . ' AS ' . $alias->alias;
}
//foreach
}
$charCode++;
}
//foreach
$relations .= NL;
}
$ret .= $indent . '$query->from(\'#__' . $table->name . ' AS a \');' . NL;
$ret .= $relations;
$ret .= $indent . '$query->select(\'' . $fields . $aliases . '\');' . NL;
return $ret;
}
