/**
*
* @param SQLQuery $query
*/
function addToQuery(&$query)
{
parent::addToQuery($query);
$query->selectField("AsText({$this->name})", "{$this->name}");
// $query->addSelect("AsText({$this->name}) AS {$this->name}_AsText");
// $query->select[] = "AsText({$this->name}) AS {$this->name}_AsText";
}
public function addToQuery(&$query)
{
parent::addToQuery($query);
$fields = $this->compositeDatabaseFields();
foreach ($fields as $name => $type) {
$query->selectField($this->name . $name);
}
}
public function addToQuery(&$query)
{
parent::addToQuery($query);
$query->selectField(sprintf('"%sPostcode"', $this->name));
$query->selectField(sprintf('"%sCountry"', $this->name));
$query->selectField(sprintf('"%sLatitude"', $this->name));
$query->selectField(sprintf('"%sLongditude"', $this->name));
}
/**
* Add all columns which are defined through {@link requireField()}
* and {@link $composite_db}, or any additional SQL that is required
* to get to these columns. Will mostly just write to the {@link SQLSelect->select}
* array.
*
* @param SQLSelect $query
*/
public function addToQuery(&$query)
{
parent::addToQuery($query);
foreach ($this->compositeDatabaseFields() as $field => $spec) {
$table = $this->getTable();
$key = $this->getName() . $field;
if ($table) {
$query->selectField("\"{$table}\".\"{$key}\"");
} else {
$query->selectField("\"{$key}\"");
}
}
}
public function addToQuery(&$query)
{
parent::addToQuery($query);
$query->selectField(sprintf('"%sAmount"', $this->name));
$query->selectField(sprintf('"%sCurrency"', $this->name));
}
/**
* Add all columns which are defined through {@link requireField()}
* and {@link $composite_db}, or any additional SQL that is required
* to get to these columns. Will mostly just write to the {@link SQLQuery->select}
* array.
*
* @param SQLQuery $query
*/
public function addToQuery(&$query)
{
parent::addToQuery($query);
}
function addToQuery(&$query)
{
parent::addToQuery($query);
$name = sprintf('%sValue', $this->name);
$val = sprintf('"%sValue"', $this->name);
$select = $query->getSelect();
if (!isset($select[$name])) {
$query->addSelect(array($name => $val));
}
}
public function addToQuery(&$query)
{
parent::addToQuery($query);
$query->selectField(sprintf('"%sType"', $this->name));
$query->selectField(sprintf('"%sValue"', $this->name));
}
function addToQuery(&$query)
{
parent::addToQuery($query);
$query->select[] = "AsText({$this->name}) AS {$this->name}_AsText";
}
