DataClass.php

Go to the documentation of this file.

<?php

namespace Combu;

abstract class DataClass {

    public static function GetTableName($class) {
        $name = $class::TABLE_NAME;
        if (defined("GAME_DB_PREFIX") && GAME_DB_PREFIX) {
            $name = GAME_DB_PREFIX . $name;
        }
        $quote = "`";
        return $quote . trim(str_replace($quote, "", $name)) . $quote;
    }
    
    protected function _loadFilter($tableName, $filter) {
        global $Database;
        $res = $Database->Query("SELECT * FROM $tableName WHERE $filter");
        if ($res) {
            $row = $Database->FetchAssoc($res);
            if ($row) {
                $this->_loadByRow($row);
            }
        }
    }

    protected function _loadByRow($row, $stripSlashes = false, $callbackOnExists = false) {
        Utils::FillObjectFromRow($this, $row, $stripSlashes, $callbackOnExists);
    }

    protected static function _count($tableName, $filter = null) {
        global $Database;
        $query = "SELECT COUNT(*) FROM (SELECT * FROM " . $tableName;
        if ($filter != null) {
            $query .= " WHERE " . $filter;
        }
        $query .= ") T";
        $res = $Database->Query($query);
        if ($res) {
            $row = $Database->FetchNum($res);
            if ($row) {
                return intval($row[0]);
            }
        }
        return 0;
    }

    protected static function _load($tableName, $returnedClass = "", $where = "", $order = null, $limit = null, $offset = null, &$count = null) {
        return self::_loadEx(null, $tableName, $returnedClass, $where, $order, $limit, $offset, $count);
    }

    protected static function _loadEx($select, $from, $returnedClass = "", $where = "", $order = null, $limit = null, $offset = null, &$count = null, $debug = false) {
        if ($count !== null) {
            // Count the total results
            $count = self::_count($from, $where);
        }

        $query = "SELECT " . ($select ? $select : "*") . " FROM $from";

        if ($where != "") {
            $query .= " WHERE " . $where;
        }

        if ($order != null) {
            $query .= " ORDER BY $order";
        }

        if ($limit != null) {
            $query .= " LIMIT " . ($offset > 0 ? "$offset," : "") . $limit;
        }

        if ($debug === true) {
            AppLog::Info($query);
        }

        return self::_loadQuery($query, $returnedClass);
    }

    protected static function _loadQuery($query, $returnedClass = "") {
        global $Database;
        $rows = array();
        $res = $Database->Query($query);
        if ($res) {
            while ($row = $Database->FetchAssoc($res)) {
                $rows[] = ($returnedClass == "" ? $row : new $returnedClass($row));
            }
        }
        return $rows;
    }

    public static function LoadRecords($query, $returnedClass = "") {
        return self::_loadQuery($query, $returnedClass);
    }

    public static function CountRecords($tableName, $filter = null) {
        return self::_count($tableName, $filter);
    }

    public function Save() {
        return FALSE;
    }

    public function Delete() {
        return FALSE;
    }

    protected function _Delete($tableName, $filter = null) {
        global $Database;
        if ($filter) {
            if ($Database->Query("DELETE FROM $tableName WHERE $filter")) {
                return TRUE;
            }
        }
        return FALSE;
    }

    public function ToJson () {
        return json_encode($this->ToArray());
    }

    public function ToArray() {
        return Utils::ObjectToArray($this);
    }
    
    public static function TruncateTable ($tableName) {
        global $Database;
        $Database->Query("TRUNCATE " . $tableName);
    }
    
    public static function TruncateClass($class) {
        return self::TruncateTable(self::GetTableName($class));
    }
}