CLASSE DE NEWS PHP5

<?php
/**
 * Classe de gestion de news
 * 
 * Cette classe permet de gerer simplement un
 * systeme de news.
 * Cette classe necessite pour fonctionner correctement :
 * - la classe MySQL : http://www.phpcs.com/code.aspx?id=28055
 * - la classe MyException : http://www.phpcs.com/code.aspx?id=28249
 * 
 * <code>
 * <?php
 * $news = new News($mysql, "table_header", "table_content", "table_comment");
 * 
 * // Pour le premiere utilisation, on creer les tables
 * $news->BuildTables();
 * 
 * // On recupere la liste des news
 * $list = $news->GetNewsList();
 * ?>
 * </code>
 * 
 * @author Gorrk
 */
class News
{
   /**
    * Instance de la classe MySQL
    * 
    * @var MySQL
    */
    protected $MySQL;

   /**
    * Nom de la table des en-tetes
    * 
    * @var string
    */
    protected $TableHeader = "";

   /**
    * Nom de la table des contenus
    * 
    * @var string
    */
    protected $TableContent = "";

   /**
    * Nom de la table des commentaires
    * 
    * @var string
    */
    protected $TableComment = "";

   /**
    * TRUE si la liste des news a ete construite, FALSE sinon
    * 
    * @var boolean
    */
    protected $NewsListIsBuilt = FALSE;

   /**
    * Liste des news
    * 
    * @var array
    */
    protected $NewsList = array();

    /**
     * Construit l'objet News
     * 
     * @param MySQL $MySQL Instance de la classe MySQL
     * @param string $TableHeader Nom de la table des en-têtes
     * @param string $TableContent Nom de la table des contenus
     * @param string $TableComment Nom de la table des commentaires
     * @return void
     */
    public function __construct(MySQL $MySQL, $TableHeader, $TableContent, $TableComment)
    {
        $this->MySQL        = $MySQL;
        $this->TableHeader  = $TableHeader;
        $this->TableContent = $TableContent;
        $this->TableComment = $TableComment;
    }

    /**
     * Construit les tables $TableHeader, $TableContent et $TableComment
     * 
     * @return void
     */
    public function BuildTables()
    {
        $this->MySQL->Query("CREATE TABLE `news_headers` (`news_id` smallint(5) unsigned NOT NULL auto_increment, `date` timestamp(14) NOT NULL, `title` char(50) NOT NULL default '', `description` char(200) NOT NULL default '', PRIMARY KEY  (`date`), UNIQUE KEY `news_id` (`news_id`)) TYPE=MyISAM AUTO_INCREMENT=1;");
        $this->MySQL->Query("CREATE TABLE `news_comments` (`news_id` smallint(5) unsigned NOT NULL default '0', `comment_id` smallint(5) unsigned NOT NULL auto_increment, `date` timestamp(14) NOT NULL, `author` varchar(50) NOT NULL default '', `comment` text NOT NULL, UNIQUE KEY `comment_id` (`comment_id`), KEY `date` (`date`)) TYPE=MyISAM AUTO_INCREMENT=1;");
        $this->MySQL->Query("CREATE TABLE `news_contents` (`news_id` smallint(5) unsigned NOT NULL default '0', `content` text NOT NULL, KEY `news_id` (`news_id`)) TYPE=MyISAM;");
    }

    /**
     * Construit la liste des news
     * 
     * @return void
     */
    private function BuildNewsList()
    {
        $this->MySQL->Query("SELECT * FROM `".$this->TableHeader."` ORDER BY `date` DESC;");
        while (FALSE !== ($News = $this->MySQL->NextRecord(MYSQL_ASSOC)))
            $this->NewsList[] = $News;
    }

    /**
     * Retourne la liste des news
     * 
     * @return array
     */
    public function GetNewsList()
    {
        if (FALSE === $this->NewsListIsBuilt)
            $this->BuildNewsList();
        return $this->NewsList;
    }

    /**
     * Retourne une news
     * 
     * @param integer $id identifiant de la news
     * @return array
     */
    public function GetNews($id)
    {
        $News            = $this->GetNewsList();
        $News            = $News[0];
        $News['content'] = $this->GetNewsContent($id);
        return  $News;
    }

    /**
     * Retourne le contenu d'une news
     * 
     * @param integer $id identifiant de la news
     * @return array
     */
    protected function GetNewsContent($id)
    {
        $this->MySQL->Query("SELECT `content` FROM `".$this->TableContent."` WHERE `news_id` = ".$id.";");
        $News = $this->MySQL->NextRecord(MYSQL_ASSOC);
        return $News['content'];
    }

    /**
     * Insere une news
     * 
     * @param string $title titre de la news
     * @param string $description courte description de la news
     * @param string $content contenu de la news
     * @return void
     */
    public function InsertNews($title, $description, $content)
    {
        $this->MySQL->Query("INSERT INTO `".$this->TableHeader."` (`date`, `title`, `description`) VALUES (NOW(), '".$title."', '".$description."');");
        $this->MySQL->Query("INSERT INTO `".$this->TableContent."` (`news_id`, `content`) VALUES ('".$this->MySQL->GetInsertId()."', '".$content."');");
    }

    /**
     * Met a jour une news
     * 
     * @param integer $id identifiant de la news
     * @param string $title titre de la news
     * @param string $description courte description de la news
     * @param string $content contenu de la news
     * @return void
     */
    public function UpdateNews($id, $title, $description, $content)
    {
        $this->MySQL->Query("UPDATE `".$this->TableHeader."` SET `date` = NOW(), `title` ='".$title."', `description` = '".$description."' WHERE `news_id` = '".$id."';");
        $this->MySQL->Query("UPDATE `".$this->TableHeader."` SET `content` = '".$content."' WHERE `news_id` = '".$id."';");
    }

    /**
     * Supprime une ou plusieurs news
     * 
     * @param integer $id,... identifiants de la ou des news
     * @return void
     */
    public function RemoveNews()
    {
        foreach (func_get_args() as $id)
        {
            $this->MySQL->Query("DELETE FROM `".$this->TableHeader."` WHERE `news_id` = ".$id.";");
            $this->MySQL->Query("DELETE FROM `".$this->TableContent."` WHERE `news_id` = ".$id.";");
            $this->MySQL->Query("DELETE FROM `".$this->TableComment."` WHERE `news_id` = ".$id.";");
        }
    }

    /**
     * Retourne la liste des commentaires d'une news
     * 
     * @return array
     */
    public function GetComments($id)
    {
        $comments = array();
        $this->MySQL->Query("SELECT * FROM `".$this->TableComment."` WHERE `news_id` = '".$id."' ORDER BY `date` ASC;");
        while (FALSE !== ($comment = $this->MySQL->NextRecord(MYSQL_ASSOC)))
            $this->comments[] = $comment;
        return $comments;
    }


    /**
     * Insere un commentaire d'une news
     * 
     * @param integer $id identifiant de la news
     * @param string $author auteur du commentaire
     * @param string $comment commentaire
     * @return void
     */
    public function InsertComment($id, $author, $comment)
    {
        $this->MySQL->Query("INSERT INTO `".$this->TableComment."` (`date`, `author`, `comment`) VALUES (NOW(), '".$author."', '".$comment."');");
    }

    /**
     * Supprime un ou plusieurs commentaires
     * 
     * @param integer $id,... identifiants du ou des commentaires
     * @return void
     */
    public function RemoveComment()
    {
        foreach (func_get_args() as $id)
            $this->MySQL->Query("DELETE FROM `".$this->TableComment."` WHERE `comment_id` = ".$id.";");
    }
}
?>