GameMatch.php

Go to the documentation of this file.

<?php

namespace Combu;

class GameMatch extends DataClass {
    
    const TABLE_NAME = "Match";

    public $Id = 0;
    public $IdTournament = 0;
    public $Title = "";
    public $DateCreation = NULL;
    public $DateExpire = NULL;
    public $Rounds = 0;
    public $Finished = 0;

    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($idTournament = 0, $idUser = 0, $activeOnly = FALSE, $title = "", $customData = array(), $order = NULL, $limit = NULL, $offset = NULL, $count = NULL, $returnArray = FALSE) {
        global $Database;
        $where = "";
        if ($idTournament > 0) {
            $where .= ($where == "" ? "" : " AND ") . sprintf("(IdTournament = %d)", $idTournament);
        } else if ($idTournament == -1) {
            $where .= ($where == "" ? "" : " AND ") . "(IdTournament = 0)";
        }
        if ($idUser > 0) {
            if ($activeOnly) {
                $where .= ($where == "" ? "" : " AND ") . "(DateExpire IS NULL OR DateExpire < CURRENT_DATE())" .
                    sprintf(" AND (Finished = 0 AND Id IN (SELECT IdMatch FROM %s WHERE IdAccount = %d))", self::GetTableName(GameMatch_Account::class), $idUser);
            } else {
                $where .= ($where == "" ? "" : " AND ") . sprintf("(Finished = 1 AND Id IN (SELECT IdMatch FROM %s WHERE IdAccount = %d))", self::GetTableName(GameMatch_Account::class), $idUser);
            }
        }
        if ($title) {
            $where .= sprintf("(Title REGEXP '%s')", $Database->Escape($title));
        }
        if ($customData && is_array($customData)) {
            $whereCustom = "";
            foreach ($customData as $search_row) {
                if (!is_array($search_row)) {
                    continue;
                }
                $key = $search_row["key"];
                $op = $search_row["op"];
                $value = $search_row["value"];
                $whereCustom .= ($whereCustom == "" ? "" : " AND ") . sprintf("(DataKey = '%s' AND DataValue %s '%s')", $Database->Escape($key), $op, $Database->Escape($value));
            }
            if ($whereCustom) {
                $where .= ($where == "" ? "" : " AND ") . sprintf("(Id IN (SELECT IdMatch FROM %s WHERE %s))", self::GetTableName(GameMatch_CustomData::class), $whereCustom);
            }
        }
        if (!$order) {
            $order = "Id";
        }
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where, $order, $limit, $offset, $count);
    }
    
    public function Save() {
        global $Database;
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET Title = '%s', Rounds = %d, DateExpire = %s, Finished = %d WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->Title),
                    $this->Rounds,
                    $Database->EscapeDate($this->DateExpire),
                    $this->Finished,
                    $this->Id);
        } else {
            $this->DateCreation = date("Y-m-d H:i:s");
            $query = sprintf("INSERT INTO %s (IdTournament, Title, Rounds, DateCreation, DateExpire, Finished) VALUES (%d, '%s', %d, %s, %s, 0)",
                    self::GetTableName(__CLASS__),
                    $this->IdTournament,
                    $Database->Escape($this->Title),
                    $this->Rounds,
                    $Database->EscapeDate($this->DateCreation),
                    $Database->EscapeDate($this->DateExpire));
        }
        if ($Database->Query($query)) {
            if ($this->Id < 1) {
                $this->Id = $Database->InsertedId();
            }
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id > 0) {
            if ($this->_Delete(self::GetTableName(__CLASS__), "Id = " . $this->Id)) {
                $this->_Delete(self::GetTableName(GameMatch_CustomData::class), "IdMatch = " . $this->Id);
                // Delete all match accounts and rounds
                $accounts = GameMatch_Account::Load($this->Id);
                foreach ($accounts as $account) {
                    $account->Delete();
                }
                return TRUE;
            }
        }
        return FALSE;
    }
    
    public static function Prune() {
        self::TruncateClass(__CLASS__);
        self::TruncateClass(GameMatch_Account::class);
        self::TruncateClass(GameMatch_CustomData::class);
        self::TruncateClass(GameMatch_Round::class);
    }
    
    public function CheckFinished() {
        $allScores = TRUE;
        $accounts = GameMatch_Account::Load($this->Id);
        foreach ($accounts as $a) {
            $rounds = GameMatch_Round::Load($a->Id);
            foreach ($rounds as $r) {
                if (!$r->DateScore) {
                    $allScores = FALSE;
                    break;
                }
            }
        }
        if ($allScores) {
            $this->Finished = 1;
            if ($this->Save()) {
                // Check if the tournament has finished
                $tournament = new Tournament($this->IdTournament);
                if ($tournament->Id > 0)
                    $tournament->CheckFinished();
            }
        }
    }
    
    public function ToArray() {
        $array = Utils::ObjectToArray($this);
        // Add the Match Custom Data
        $array["CustomData"] = array();
        $customData = GameMatch_CustomData::Load($this->Id);
        foreach ($customData as $data) {
            $array["CustomData"][$data->DataKey] = $data->DataValue;
        }
        // Add the Accounts
        $array["Users"] = array();
        $accounts = GameMatch_Account::Load($this->Id);
        foreach ($accounts as $i) {
            $array["Users"][] = $i->ToArray();
        }
        // Return the full array
        return $array;
    }
    
    public function ToJson() {
        $array = $this->ToArray();
        return json_encode($array);
    }
}