Account_App.php

Go to the documentation of this file.

<?php

namespace Combu;

class Account_App extends DataClass {

    const TABLE_NAME = "Account_App";

    public $IdAccount = 0;
    public $IdApp = 0;
    public $DateCreated = "";
    public $DateUpdated = "";

    public function __construct($src = null, $stripSlashes = false) {
        global $Database;
        if (empty($src)) {
            return;
        }
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        }
    }
    
    public static function Exists($idAccount, $idApp, &$record = NULL) {
        global $Database;
        $record = NULL;
        if ($idAccount > 0 && $idApp > 0) {
            $sql = sprintf("SELECT * FROM %s WHERE IdAccount = %d AND IdApp = %d", self::GetTableName(__CLASS__), $idAccount, $idApp);
            $res = $Database->Query($sql);
            $row = $Database->FetchAssoc($res);
            if ($row) {
                $record = new self($row);
                return TRUE;
            }
        }
        return FALSE;
    }

    public static function InsertOrUpdate($idAccount, $idApp) {
        global $Database;
        if ($idAccount > 0 && $idApp > 0) {
            $record = NULL;
            if (!self::Exists($idAccount, $idApp, $record)) {
                $record = new self();
                $record->IdAccount = $idAccount;
                $record->IdApp = $idApp;
            }
            return $record->Save();
        }
        return FALSE;
    }

    public static function Load ($limit = null, $offset = null, &$count = null, $returnArray = false) {
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), NULL, "DateCreated DESC", $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        if (!$this->DateCreated) {
            $this->DateCreated = Utils::GetCurrentDateTimeFormat();
        }
        $this->DateUpdated = Utils::GetCurrentDateTimeFormat();
        $query = sprintf("REPLACE INTO %s (IdAccount, IdApp, DateCreated, DateUpdated) VALUES (%d, %d, %s, %s)",
                self::GetTableName(__CLASS__),
                $this->IdAccount,
                $this->IdApp,
                $Database->EscapeDate($this->DateCreated),
                $Database->EscapeDate($this->DateUpdated));
        return $Database->Query($query);
    }

    public function Delete() {
        if ($this->IdAccount > 0 && $this->IdApp > 0) {
            return $this->_Delete(self::GetTableName(__CLASS__), sprintf("IdAccount = %d AND IdApp = %d", $this->IdAccount, $this->IdApp));
        }
        return FALSE;
    }
}