<?php

class HatchTranslation extends BaseClass
{

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

    public $Id;
    public $HatchId;
    public $Lang;
    public $Name;
    public $Created;
    public $Modified;

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

    /**
     * Selects a list of News item translations
     * @param int $HatchId
     * @param string $lang
     * @param int|null $limit
     * @return HatchTranslation[]
     */
    public static function SelectByHatch($HatchId, $lang, $limit = null)
    {
        $limitClause = "";
        if ($limit != null && is_numeric($limit))
            $limitClause = " LIMIT 0, " . $limit;

        return parent::SelectObjects("SELECT *
                                      FROM `HatchTranslation`
                                      WHERE HatchId = '" . intval($HatchId) . "'
                                              AND Lang = '" . parent::_db()->escape($lang) . "'
                                      ORDER BY Created DESC" . $limitClause);
    }

    /**
     * Selects all Hatch Translations
     * @return HatchTranslation[]
     */
    public static function SelectAll()
    {
        return parent::SelectAll();
    }

    /**
     * Selects all HatchTranslation by HatchId
     * @param int $HatchId
     * @return HatchTranslation[]
     */
    public static function SelectAllByHatch($HatchId)
    {
        return parent::SelectObjects("SELECT *
                                      FROM `HatchTranslation`
                                      WHERE HatchId = '" . intval($HatchId) . "'");
    }

    /**
     *
     * @param int[] $HatchIds
     * @param string $lang
     * @return HatchTranslation[]
     */
    public static function SelectRange($HatchIds, $lang = null)
    {
        if (count($HatchIds) > 0) {
            $langClause = "";
            if ($lang != null) {
                $langClause = "AND Lang = '" . parent::_db()->escape($lang) . "'";
            }

            $range = join(",", $HatchIds);

            return parent::SelectObjects("SELECT *
                                          FROM `HatchTranslation`
                                          WHERE HatchId IN (" . $range . ")" . $langClause);
        } else return array();
    }

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

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

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

}

?>