Account_Platform.php

Go to the documentation of this file.

<?php

namespace Combu;

class Account_Platform extends DataClass {
    
    const TABLE_NAME = "Account_Platform";

    public $IdAccount = 0;
    public $PlatformKey = "";
    public $PlatformId = "";

    public function __construct($src = null, $stripSlashes = false) {
        if (!$src)
            return;
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        }
    }

    public static function Load($idAccount) {
        global $Database;
        $where = sprintf("IdAccount = %d", $idAccount);
        return self::_load(self::GetTableName(__CLASS__), __CLASS__, $where);
    }
    
    public static function LoadAccount ($platformKey, $platformId, &$accountPlatform = NULL) {
        global $Database;
        $account = NULL;
        $accountPlatform = NULL;
        $query = sprintf("SELECT IdAccount FROM %s WHERE PlatformKey = '%s' AND PlatformId = '%s'",
                self::GetTableName(__CLASS__),
                $Database->Escape($platformKey),
                $Database->Escape($platformId));
        $rows = self::LoadRecords($query, __CLASS__);
        if (count($rows) > 0) {
            $accountPlatform = $rows[0];
            // We have an account
            $account = new Account($accountPlatform->IdAccount);
            if ($account->Id < 1) {
                $account = NULL;
                
            }
        }
        return $account;
    }
    
    public static function LoadOrCreateAccount ($platformKey, $platformId, &$accountPlatform = NULL, &$justCreated = FALSE) {
        global $Database;
        $justCreated = FALSE;
        $accountPlatform = NULL;
        $account = self::LoadAccount($platformKey, $platformId, $accountPlatform);
        if ($account == NULL) {
            if ($accountPlatform) {
                // Delete this record because the account is invalid
                $accountPlatform->Delete();
                $accountPlatform = NULL;
            } else {
                // Create new account
                $account = new Account();
                $account->Username = $platformKey . "_" . $platformId;
                $account->Enabled = 1;
                if ($account->Save()) {
                    $accountPlatform = new Account_Platform();
                    $accountPlatform->PlatformKey = $platformKey;
                    $accountPlatform->PlatformId = $platformId;
                    $accountPlatform->IdAccount = $account->Id;
                    if ($accountPlatform->Save()) {
                        $justCreated = TRUE;
                    } else {
                        $accountPlatform = NULL;
                        // Delete this record because it didn't save the Account-Platform object
                        $account->Delete();
                        $account = NULL;
                    }
                } else {
                    $account = NULL;
                }
            }
        }
        return $account;
    }

    public function Save() {
        global $Database;
        // Data integrity check
        if ($this->IdAccount < 1 || !$this->PlatformKey || !$this->PlatformId) {
            return FALSE;
        }
        $query = sprintf("REPLACE INTO %s (IdAccount, PlatformKey, PlatformId) VALUES (%d, '%s', '%s')",
                self::GetTableName(__CLASS__),
                $this->IdAccount,
                $Database->Escape($this->PlatformKey),
                $Database->Escape($this->PlatformId));
        return $Database->Query($query);
    }

    public function Delete() {
        global $Database;
        $where = sprintf("IdAccount = %d AND PlatformKey = '%s' AND PlatformId = '%s'",
                $this->IdAccount,
                $Database->Escape($this->PlatformKey),
                $Database->Escape($this->PlatformId));
        return $this->_Delete(self::GetTableName(__CLASS__), $where);
    }
}