public function compile($db = NULL)
{
if ($this->context_model() and $meta = Jam::meta(Jam_Query_Builder::aliased_model($this->context_model()))) {
$db = Database::instance($meta->db());
}
$original_on = $this->_on;
$original_using = $this->_using;
$original_table = $this->_table;
if (!empty($this->_on)) {
foreach ($this->_on as &$condition) {
$condition[0] = Jam_Query_Builder::resolve_attribute_name($condition[0], $this->model() ? $this->model() : $this->_table);
$condition[2] = Jam_Query_Builder::resolve_attribute_name($condition[2], $this->context_model());
}
}
$this->_table = Jam_Query_Builder::resolve_table_alias($this->_table);
if (!empty($this->_using)) {
foreach ($this->_using as &$column) {
$column = Jam_Query_Builder::resolve_attribute_name($column, $this->meta());
}
}
$additional_joins = '';
foreach ($this->_joins as $join) {
$additional_joins .= ' ' . $join->compile($db);
}
$compiled = parent::compile($db) . $additional_joins;
$this->_on = $original_on;
$this->_using = $original_using;
$this->_table = $original_table;
return $compiled;
}
protected function _compile_conditions(Database $db, array $conditions)
{
foreach ($conditions as &$group) {
foreach ($group as &$condition) {
$condition[0] = Jam_Query_Builder::resolve_attribute_name($condition[0], $this->meta()->model(), $condition[2]);
}
}
return parent::_compile_conditions($db, $conditions);
}
public function aggregate_query($function, $column = NULL)
{
if ($column === NULL or $column === '*') {
$column = '*';
} else {
$db = Database::instance($this->meta()->db());
$column = Jam_Query_Builder::resolve_attribute_name($column, $this->meta()->model());
$column = $db->quote_column($column);
}
$count = clone $this;
return $count->select(array(DB::expr("{$function}({$column})"), 'result'));
}
/**
* @dataProvider data_resolve_attribute_name
*/
public function test_resolve_attribute_name($name, $context_model, $expected)
{
$this->assertEquals($expected, Jam_Query_Builder::resolve_attribute_name($name, $context_model));
}
