Exemplos de Atomik_Db_Query::join em PHP

Exemplo n.º 1

Arquivo: Extendable.php Projeto: neronen/tsoha-k11p4-atomik

	public function beforeQuery(Atomik_Model_Builder $builder, Atomik_Db_Query $query)
	{
		$tableName = $builder->tableName;
		$primaryKeyName = $builder->getPrimaryKeyField()->name;
		$foreignFieldName = $this->_prefix($tableName . '_' . $primaryKeyName);
		$on = sprintf('%s.%s = %s.%s', $this->_suffix($tableName), $foreignFieldName, $tableName, $primaryKeyName);
		
		// add a join clause to the query
		$query->join($this->_suffix($tableName), $on, null, 'LEFT');
	}