laravel/system/db/eloquent/relate.php

<?php namespace System\DB\Eloquent;

class Relate {

	/**
	 * Retrieve the query for a 1:1 relationship.
	 *
	 * @param  string  $model
	 * @param  object  $eloquent
	 * @return mixed
	 */
	public static function has_one($model, $eloquent)
	{
		// -----------------------------------------------------
		// Set the relating type.
		// -----------------------------------------------------
		$eloquent->relating = __FUNCTION__;

		// -----------------------------------------------------
		// Return the Eloquent model.
		// -----------------------------------------------------
		return static::has_one_or_many($model, $eloquent);
	}

	/**
	 * Retrieve the query for a 1:* relationship.
	 *
	 * @param  string  $model
	 * @param  object  $eloquent
	 * @return mixed
	 */
	public static function has_many($model, $eloquent)
	{
		// -----------------------------------------------------
		// Set the relating type.
		// -----------------------------------------------------
		$eloquent->relating = __FUNCTION__;

		// -----------------------------------------------------
		// Return the Eloquent model.
		// -----------------------------------------------------
		return static::has_one_or_many($model, $eloquent);
	}

	/**
	 * Retrieve the query for a 1:1 or 1:* relationship.
	 *
	 * @param  string  $model
	 * @param  object  $eloquent
	 * @return mixed
	 */
	private static function has_one_or_many($model, $eloquent)
	{
		// -----------------------------------------------------
		// Set the relating key.
		// -----------------------------------------------------
		$eloquent->relating_key = \System\Str::lower(get_class($eloquent)).'_id';

		return Factory::make($model)->where($eloquent->relating_key, '=', $eloquent->id);
	}

	/**
	 * Retrieve the query for a 1:1 belonging relationship.
	 *
	 * @param  array   $caller
	 * @param  string  $model
	 * @param  object  $eloquent
	 * @return mixed
	 */
	public static function belongs_to($caller, $model, $eloquent)
	{
		// -----------------------------------------------------
		// Set the relating type.
		// -----------------------------------------------------
		$eloquent->relating = __FUNCTION__;

		// -----------------------------------------------------
		// Set the relating key.
		// -----------------------------------------------------
		$eloquent->relating_key = $caller['function'].'_id';

		// -----------------------------------------------------
		// Return the Eloquent model.
		// -----------------------------------------------------
		return Factory::make($model)->where('id', '=', $eloquent->attributes[$eloquent->relating_key]);
	}

	/**
	 * Retrieve the query for a *:* relationship.
	 *
	 * @param  string  $model
	 * @param  object  $eloquent
	 * @return mixed
	 */
	public static function has_many_and_belongs_to($model, $eloquent)
	{
		// -----------------------------------------------------
		// Get the models involved in the relationship.
		// -----------------------------------------------------
		$models = array(\System\Str::lower($model), \System\Str::lower(get_class($eloquent)));

		// -----------------------------------------------------
		// Sort the model names involved in the relationship.
		// -----------------------------------------------------
		sort($models);

		// -----------------------------------------------------
		// Get the intermediate table name, which is the names
		// of the two related models alphabetized.
		// -----------------------------------------------------
		$eloquent->relating_table = implode('_', $models);

		// -----------------------------------------------------
		// Set the relating type.
		// -----------------------------------------------------
		$eloquent->relating = __FUNCTION__;

		// -----------------------------------------------------
		// Set the relating key.
		// -----------------------------------------------------
		$eloquent->relating_key = $eloquent->relating_table.'.'.\System\Str::lower(get_class($eloquent)).'_id';

		// -----------------------------------------------------
		// Return the Eloquent model.
		// -----------------------------------------------------
		return Factory::make($model)
							->select(Meta::table($model).'.*')
							->join($eloquent->relating_table, Meta::table($model).'.id', '=', $eloquent->relating_table.'.'.\System\Str::lower($model).'_id')
							->where($eloquent->relating_key, '=', $eloquent->id);
	}

}