News.php

Go to the documentation of this file.

<?php

namespace Combu;

class News extends DataClass {

    const TABLE_NAME = "News";

    public $Id = 0;
    public $IdApp = 0;
    public $IdAdminAccount = 0;
    public $PublishDate = "";
    public $Subject = "";
    public $Message = "";
    public $Url = "";

    public function __construct($src = null, $stripSlashes = false) {
        global $Database;
        if ($src == null)
            return;
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        } else if (is_numeric($src) && intval($src) > 0) {
            // Load by Id
            $this->_loadFilter(self::GetTableName(__CLASS__), "Id = " . intval($src));
        }
    }

    public static function Load ($idApp = 0, $limit = null, $offset = null, &$count = null, $returnArray = false) {
        global $AppId;
        $where = "";
        if ($AppId->IsValid()) {
            $where = sprintf("(IdApp = 0 OR IdApp = %d)", $AppId->Id);
        }
        if ($idApp > 0) {
            $where = sprintf("(IdApp = %d)", $idApp);
        }
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where, "PublishDate DESC", $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET Subject = '%s', Message = '%s', Url = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->Subject),
                    $Database->Escape($this->Message),
                    $Database->Escape($this->Url),
                    $this->Id);
        } else {
            $this->PublishDate = Utils::GetCurrentDateTimeFormat();
            $query = sprintf("INSERT INTO %s (IdApp, PublishDate, IdAdminAccount, Subject, Message, Url) VALUES (%d, %s, %d, '%s', '%s', '%s')",
                    self::GetTableName(__CLASS__),
                    $this->IdApp,
                    $Database->EscapeDate($this->PublishDate),
                    $this->IdAdminAccount,
                    $Database->Escape($this->Subject),
                    $Database->Escape($this->Message),
                    $Database->Escape($this->Url));
        }
        if ($Database->Query($query)) {
            if ($this->Id < 1) {
                $this->Id = $Database->InsertedId();
            }
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id > 0) {
            return $this->_Delete(self::GetTableName(__CLASS__), "Id = " . $this->Id);
        }
        return FALSE;
    }
}