Inventory.php

Go to the documentation of this file.

<?php

namespace Combu;

class Inventory extends DataClass {

    const TABLE_NAME = "Inventory";

    public $Id = 0;
    public $IdAccount = 0;
    public $IdApp = 0;
    public $Name = "";
    public $Quantity = 0;
    public $CustomData = "";

    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));
        } else {
            // Load by Name
            $this->_loadFilter(self::GetTableName(__CLASS__), "Name = '" . $Database->Escape($src) . "' ORDER BY Id");
        }
    }

    public static function Load ($idAccount, $returnArray = false) {
        global $AppId;
        $where = sprintf("IdAccount = %d", $idAccount);
        if ($AppId->IsValid()) {
            $where .= sprintf(" AND IdApp = %d", $AppId->Id);
        }
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where);
    }
    
    public static function LoadOrCreate ($idAccount, $itemName, $returnArray = false) {
        global $Database, $AppId;
        // Load the existing record
        $where = sprintf("IdAccount = %d AND Name = '%s'", $idAccount, $Database->Escape($itemName));
        if ($AppId->IsValid()) {
            $where .= sprintf(" AND IdApp = %d", $AppId->Id);
        }
        $recs = self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where);
        if (count($recs) > 0) {
            return $recs[0];
        }
        // If no record was found, then create new instance
        $rec = new self();
        $rec->IdAccount = $idAccount;
        $rec->Name = $itemName;
        return $rec;
    }

    public function Save() {
        global $Database, $AppId;
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET Quantity = %d, CustomData = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $this->Quantity,
                    $Database->Escape($this->CustomData),
                    $this->Id);
        } else {
            $query = sprintf("INSERT INTO %s (IdAccount, IdApp, Name, Quantity, CustomData) VALUES (%d, %d, '%s', %d, '%s')",
                    self::GetTableName(__CLASS__),
                    $this->IdAccount,
                    $AppId->Id,
                    $Database->Escape($this->Name),
                    $this->Quantity,
                    $Database->Escape($this->CustomData));
        }
        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;
    }
    
    public static function Prune() {
        self::TruncateClass(__CLASS__);
    }
}