/**
* Build SQL tables list, based on calculated joins for where array properties paths
*
* @return string
*/
public function build()
{
$tables = BQ . Dao::current()->storeNameOf($this->class_name) . BQ . SP . 't0';
foreach ($this->joins->getJoins() as $join) {
if ($join) {
$tables .= $join->toSql();
}
}
return $tables;
}
/**
* Build the columns list, based on properties paths
*
* @return string
* @todo factorize
*/
public function build()
{
if (isset($this->properties)) {
$sql_columns = '';
$first_property = true;
foreach ($this->properties as $key_path => $path) {
if ($path instanceof Func\Column) {
$sql_columns .= $this->buildDaoSelectFunction($key_path, $path, $first_property);
} else {
$join = $this->joins->add($path);
$sql_columns .= $join && $join->type !== Join::LINK ? $this->buildObjectColumns($path, $join, $first_property) : $this->buildNextColumn($path, $join, $first_property);
}
$sql_columns .= $this->append(is_numeric($key_path) ? $path : $key_path);
}
} elseif ($this->joins->getJoins()) {
$class_name = $this->joins->getStartingClassName();
/** @var $properties Reflection_Property[] */
$properties = [];
$column_names = [];
foreach ((new Reflection_Class($class_name))->getProperties([T_EXTENDS, T_USE]) as $property) {
$storage = $property->getAnnotation('storage')->value;
$type = $property->getType();
if (!$property->isStatic() && !($type->isClass() && $type->isMultiple())) {
$column_names[$property->name] = $storage;
$properties[$property->name] = $property;
if ($storage !== $property->name) {
$has_storage = true;
}
}
}
$sql_columns = '';
foreach ($this->joins->getLinkedJoins() as $join) {
if (isset($has_storage)) {
foreach ((new Reflection_Class($join->foreign_class))->getProperties([T_EXTENDS, T_USE]) as $property) {
if (!$property->isStatic() && isset($column_names[$property->name]) && !isset($already[$property->name])) {
if (!$sql_columns) {
$sql_columns .= $join->foreign_alias . '.id, ';
}
$column_name = $column_names[$property->name];
$id = $property->getType()->isClass() ? 'id_' : '';
$already[$property->name] = true;
$sql_columns .= $join->foreign_alias . DOT . BQ . $id . $column_name . BQ;
if ($column_name !== $property->name && $this->resolve_aliases) {
$sql_columns .= ' AS ' . BQ . $id . $property->name . BQ;
}
$sql_columns .= ', ';
}
}
} else {
$sql_columns .= $join->foreign_alias . '.*, ';
}
}
// the main table comes last, as fields with the same name must have the main value (ie 'id')
if (isset($has_storage)) {
if (!(new Link_Class($this->joins->getStartingClassName()))->getAnnotation('link')->value) {
$sql_columns .= 't0.id, ';
}
foreach ($column_names as $property_name => $column_name) {
if (!isset($already[$property_name])) {
$already[$property_name] = true;
$id = $properties[$property_name]->getType()->isClass() ? 'id_' : '';
$sql_columns .= 't0.' . BQ . $id . $column_name . BQ;
if ($column_name !== $property_name && $this->resolve_aliases) {
$sql_columns .= ' AS ' . BQ . $id . $property_name . BQ;
}
$sql_columns .= ', ';
}
}
$sql_columns = substr($sql_columns, 0, -2);
} else {
$sql_columns .= 't0.*';
}
} else {
$sql_columns = '*';
}
return $sql_columns;
}