protected function has_many_through($associated_class_name, $join_class_name = null, $key_to_base_table = null, $key_to_associated_table = null, $key_in_base_table = null, $key_in_associated_table = null, $connection_name = null)
{
// Added: to determine eager load relationship parameters
$this->relating = 'has_many_through';
$base_class_name = get_class($this);
// The class name of the join model, if not supplied, is
// formed by concatenating the names of the base class
// and the associated class, in alphabetical order.
if (is_null($join_class_name)) {
$model = explode('\\', $base_class_name);
$model_name = end($model);
if (substr($model_name, 0, strlen(self::$auto_prefix_models)) == self::$auto_prefix_models) {
$model_name = substr($model_name, strlen(self::$auto_prefix_models), strlen($model_name));
}
$class_names = array($model_name, $associated_class_name);
sort($class_names, SORT_STRING);
$join_class_name = join("", $class_names);
}
// Get table names for each class
$base_table_name = self::_get_table_name($base_class_name);
$associated_table_name = self::_get_table_name(self::$auto_prefix_models . $associated_class_name);
$join_table_name = self::_get_table_name(self::$auto_prefix_models . $join_class_name);
// Get ID column names
$base_table_id_column = is_null($key_in_base_table) ? self::_get_id_column_name($base_class_name) : $key_in_base_table;
$associated_table_id_column = is_null($key_in_associated_table) ? self::_get_id_column_name(self::$auto_prefix_models . $associated_class_name) : $key_in_associated_table;
// Get the column names for each side of the join table
$key_to_base_table = self::_build_foreign_key_name($key_to_base_table, $base_table_name);
$key_to_associated_table = self::_build_foreign_key_name($key_to_associated_table, $associated_table_name);
/*
" SELECT {$associated_table_name}.*
FROM {$associated_table_name} JOIN {$join_table_name}
ON {$associated_table_name}.{$associated_table_id_column} = {$join_table_name}.{$key_to_associated_table}
WHERE {$join_table_name}.{$key_to_base_table} = {$this->$base_table_id_column} ;"
*/
// Added: to determine eager load relationship parameters
$this->relating_key = array($key_to_base_table, $key_to_associated_table);
$this->relating_table = $join_table_name;
return self::factory($associated_class_name, $connection_name)->select("{$associated_table_name}.*")->join($join_table_name, array("{$associated_table_name}.{$associated_table_id_column}", '=', "{$join_table_name}.{$key_to_associated_table}"))->where("{$join_table_name}.{$key_to_base_table}", $this->{$base_table_id_column})->non_associative();
}