<?php

class Hatch extends BaseClass
{

    ////////////////
    // Properties //
    ////////////////

    public $Id;
    public $Sort;
    public $Created;
    public $Modified;

    public static $_primaryKey = array("Id");

    ////////////////////
    // Public Methods //
    ////////////////////

    /**
     * Selects a Hatch by Id
     * @param int $Id
     * @return Hatch
     */
    public static function Select($Id)
    {
        return parent::Select($Id);
    }

    /**
     * Selects a hatch by name
     * @param string $Name
     * @return Hatch[]
     */
    public static function SelectByName($Name)
    {
        return parent::SelectObjects("SELECT *
									  FROM Hatch
									  WHERE Name = '" . parent::_db()->escape($Name) . "'");
    }

    /**
     * Selects all addresses
     * @static
     * @param int $limit
     * @param string $sortColumn
     * @param string $sort
     * @return Hatch[]
     */
    public static function SelectAll($limit = null, $sortColumn = null, $sort = null)
    {
        return parent::SelectObjects("SELECT *
                                      FROM `Hatch`
                                      ORDER BY Sort ASC");
    }

    /**
     * Inserts a Hatch
     * @return int
     */
    public function Insert()
    {
        $this->Created = time();
        $this->Modified = time();
        return parent::Insert($this);
    }

    /**
     * Updates a Hatch
     */
    public function Update()
    {
        $this->Modified = time();
        parent::Update();
    }

    /**
     * Deletes a Hatch
     */
    public function Delete()
    {
        parent::Delete();
    }

    /**
     * Selects Last sort
     * @return int
     */
    public static function SelectLastSort()
    {
        return parent::_db()->result(parent::_db()->query("SELECT MAX(Sort)
                                                           FROM `Hatch`"), 0);
    }

    /**
     * Selects a Hatch by sort
     * @param int $sort
     * @return Hatch
     */
    public static function SelectBySort($sort)
    {
        $result = parent::SelectObjects("SELECT *
                                         FROM `Hatch`
                                         WHERE Sort = '" . intval($sort) . "'");
        return reset($result);
    }
}

?>