public static function get_relationship_class_where(moojon_base_relationship $relationship, moojon_base_model $accessor)
{
$accessor_class = get_class($accessor);
$table = $accessor->get_table(false);
$key = $relationship->get_key();
$foreign_table = $relationship->get_foreign_table();
$foreign_key = $relationship->get_foreign_key();
$return = '';
switch (get_class($relationship)) {
case 'moojon_has_one_relationship':
$return = "`{$foreign_table}`.`{$key}` = `{$table}`.`{$foreign_key}`";
break;
case 'moojon_has_many_relationship':
$foreign_key = moojon_primary_key::get_foreign_key($accessor_class);
$return = "`{$table}`.`{$key}` = `{$foreign_table}`.`{$foreign_key}`";
break;
case 'moojon_has_many_to_many_relationship':
$return = 'many_to_many';
break;
case 'moojon_belongs_to_relationship':
$return = "`{$table}`.`{$key}` = `{$foreign_table}`.`{$foreign_key}`";
break;
}
return $return;
}
