SWDB/application/entity/Run.php

<?php
    /**
     * Saved run entity file.
     *
     * Creates the entity and makes it available.
     *
     * @category Entity
     * // TODO Artifact drops.
     */

    /**
     * Require dependent entities if not present.
     */
    require_once(PATH::ENTITY . "Entity.php");
    require_once(PATH::ENTITY . "Unit.php");
    require_once(PATH::ENTITY . "Monster.php");
    require_once(PATH::ENTITY . "Rune.php");
    require_once(PATH::ENTITY . "Enchantment.php");
    require_once(PATH::ENTITY . "Item.php");
    require_once(PATH::ENTITY . "Area.php");
    require_once(PATH::ENTITY . "Rune_Set.php");


    /**
     * A run.
     *
     * Represents an object from the table 'run'.
     *
     * @category Entity
     */
    class Run extends Entity{

        /**
         * @var int Owner's player identifier.
         */
        public $player;

        /**
         * @var int Run identifier.
         */
        public $id;

        /**
         * @var DateTime Run start datestamp.
         */
        public $dtime;

        /**
         * @var Area Area.
         */
        public $area;

        /**
         * @var int Stage.
         */
        public $stage;

        /**
         * @var int Difficulty (only scenario and dimension hole)
         */
        public $difficulty;

        /**
         * @var bool Win or lost run.
         */
        public $win;

        /**
         * @var int Clear time, milliseconds.
         */
        public $time;

        /**
         * @var int Reward mana.
         */
        public $mana = 0;

        /**
         * @var int Reward energy.
         */
        public $energy = 0;

        /**
         * @var int Reward crystal.
         */
        public $crystal = 0;

        /**
         * @var int Reward Honor Points (Arena).
         */
        public $honor_points = 0;

        /**
         * @var int Reward Guild Points.
         */
        public $guild_points = 0;

        /**
         * @var bool Indicates if a frind/mentor helped.
         */
        public $helper;

        /**
         * @var int Score in battles that are rated (WB, rift dungeons...).
         */
        public $score;

        /**
         * @var String Rank in battles that are rated (WB, rift dungeons...).
         */
        public $rank;

        /**
         * @var \Unit[]|\Monster[] Units or monsters used.
         * If the unit is still owned, it will be a instance of Unit.
         * If not, it will be a instance of monster.
         */
        public $party = [];

        /**
         * @var int ID of the leader unit or monster.
         */
        public $leader;

        /**
         * @var int[] List of IDs of the frontline units or monsters.
         */
        public $frontline = [];

        /**
         * @var \Item[] Dropped items.
         */
        public $item = [];

        /**
         * @var \Monster[] Units dropped.
         */
        public $monster = [];

        /**
         * @var int Monster[] Units whose secret dungeons were found on the run.
         */
        public $sd = [];

        /**
         * @var mixed[] List of dropped summon pieces.
         *
         * Formated as:
         *  [@{see Monster}, amount]
         */
        public $unit_piece = [];

        /**
         * @var int Number of shapeshifting stones dropped;
         */
        public $shapeshifting = 0;

        /**
         * @var \Rune[] List of Runes dropped.
         */
        public $rune = [];

        /**
         * @var \Enchantment[] List of Enchantments dropped.
         */
        public $enchantment = [];

        /**
         * Constructor.
         *
         * Searches the database and retrieves the information about the
         * run, populating it and it's items.
         *
         * @param int $id Run identifier.
         * @global resource Database connection.
         */
        public function __construct($id){

            global $db;

            $statement = $db->prepare("
              SELECT
                id,
                player,
                dtime,
                area_type,
                area,
                stage,
                difficulty,
                win,
                time,
                mana,
                energy,
                crystal,
                honor_points,
                guild_points,
                helper,
                score,
                rank
              FROM run
              WHERE id = :id;
            ");
            $statement->bindValue(':id', $id, SQLITE3_TEXT);
            $r = $statement->execute()->fetchArray(SQLITE3_ASSOC);
            if ($r){
                $this->id = $r["id"];
                $this->player = $r["player"];
                $this->dtime = $r["dtime"];
                $this->area = new Area($r["area"], $r["area_type"]);
                $this->stage = $r["stage"];
                $this->difficulty = $r["difficulty"];
                $this->win = $r["win"];
                $this->time = $r["time"];
                $this->mana = $r["mana"];
                $this->energy = $r["energy"];
                $this->crystal = $r["crystal"];
                $this->honor_points = $r["honor_points"];
                $this->guild_points = $r["guild_points"];
                $this->helper = $r["helper"];
                $this->score = $r["score"];
                $this->rank = $r["rank"];
                $statement = $db->prepare("
                    SELECT
                      unit,
                      monster,
                      (SELECT count(id) FROM unit WHERE unit.id = run_party.unit) AS owned,
                      leader,
                      front
                    FROM run_party
                    WHERE run = :run
                    ORDER BY
                      front DESC,
                      leader DESC;
                ");
                $statement->bindValue(':run', $id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    if ($r["owned"] > 0){
                        array_push($this->party, new Unit($r["unit"], false));
                    }
                    else{
                        array_push($this->party, new Monster($r["monster"], false));
                    }
                    if ($r["leader"] == 1){
                        $this->leader = $r["unit"];
                    }
                    if ($r["front"] == 1){
                        array_push($this->frontline, $r["unit"]);
                    }
                }
                $statement = $db->prepare("
                    SELECT
                      item,
                      amount
                    FROM run_drop_item
                    WHERE run = :run;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    $i = new Item($r["item"]);
                    $i->amount =  $r["amount"];
                    array_push($this->item, $i);
                }
                $statement = $db->prepare("
                    SELECT monster
                    FROM run_drop_monster
                    WHERE run = :run;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    array_push($this->monster, new Monster($r["monster"]));
                }
                $statement = $db->prepare("
                    SELECT monster
                    FROM run_drop_sd
                    WHERE run = :run;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    array_push($this->sd, new Monster($r["monster"]));
                }
                $statement = $db->prepare("
                    SELECT
                      monster,
                      amount
                    FROM run_drop_monster_pieces
                    WHERE run = :run;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    $i = [
                        "monster" => new Monster($r["monster"]),
                        "amount" => $r["amount"]
                    ];
                    array_push($this->unit_piece, $i);
                }
                $statement = $db->prepare("
                    SELECT amount
                    FROM run_drop_shapeshifting
                    WHERE run = :run;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                $r = $q->fetchArray(SQLITE3_ASSOC);
                if ($r){
                    $this->shapeshifting = $r["amount"];
                }
                $statement = $db->prepare("
                    SELECT
                      id,
                      type,
                      slot,
                      stars,
                      ancient,
                      quality,
                      value,
                      efficiency,
                      main_stat,
                      main_stat_value,
                      innate_stat,
                      innate_stat_value,
                      substat_1,
                      substat_1_value,
                      substat_2,
                      substat_2_value,
                      substat_3,
                      substat_3_value,
                      substat_4,
                      substat_4_value
                    FROM run_drop_rune
                    WHERE run = :run;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    $rune = new Rune($r["id"]);
                    if (!isset($rune->id)){
                        $rune->id = $r["id"];
                        $rune->level = 0;
                        $rune->assigned_to = null;
                        $rune->type = new Rune_Set($r["type"]);
                        $rune->slot = $r["slot"];
                        $rune->stars = $r["stars"];
                        $rune->ancient = $r["ancient"];
                        $rune->quality = $r["quality"];
                        $rune->original_quality = $r["quality"];
                        $rune->quality_name = $this->get_rune_quality_name($r["quality"]);
                        $rune->original_quality_name = $this->get_rune_quality_name($r["quality"]);
                        $rune->value = $r["value"];
                        $rune->value = 0;
                        $rune->efficiency = $r["efficiency"];
                        // TODO: Calculate?
                        $rune->max_efficiency = $r["efficiency"];
                        $rune->main_stat = new Rune_Stat(null, null);
                        $rune->main_stat->slot = RUNE_STAT_SLOT_ID::MAIN;
                        $rune->main_stat->stat = $r["main_stat"];
                        $rune->main_stat->stat_name = $this->get_stat_name($r["main_stat"]);
                        $rune->main_stat->value = $r["main_stat_value"];
                        if ($r["innate_stat"] != null){
                            $rune->innate_stat = new Rune_Stat(null, null);
                            $rune->innate_stat->slot = RUNE_STAT_SLOT_ID::INNATE;
                            $rune->innate_stat->stat = $r["innate_stat"];
                            $rune->innate_stat->stat_name = $this->get_stat_name($r["innate_stat"]);
                            $rune->innate_stat->value = $r["innate_stat_value"];
                        }
                        if ($r["substat_1"] != null){
                            $substat = new Rune_Stat(null, null);
                            $substat->slot = RUNE_STAT_SLOT_ID::SUBSTAT_1;
                            $substat->stat = $r["substat_1"];
                            $substat->stat_name = $this->get_stat_name($r["substat_1"]);
                            $substat->value = $r["substat_1_value"];
                            array_push($rune->substats, $substat);
                        }
                        if ($r["substat_2"] != null){
                            $substat = new Rune_Stat(null, null);
                            $substat->slot = RUNE_STAT_SLOT_ID::SUBSTAT_2;
                            $substat->stat = $r["substat_2"];
                            $substat->stat_name = $this->get_stat_name($r["substat_2"]);
                            $substat->value = $r["substat_2_value"];
                            array_push($rune->substats, $substat);
                        }
                        if ($r["substat_3"] != null){
                            $substat = new Rune_Stat(null, null);
                            $substat->slot = RUNE_STAT_SLOT_ID::SUBSTAT_3;
                            $substat->stat = $r["substat_3"];
                            $substat->stat_name = $this->get_stat_name($r["substat_3"]);
                            $substat->value = $r["substat_3_value"];
                            array_push($rune->substats, $substat);
                        }
                        if ($r["substat_4"] != null){
                            $substat = new Rune_Stat(null, null);
                            $substat->slot = RUNE_STAT_SLOT_ID::SUBSTAT_4;
                            $substat->stat = $r["substat_4"];
                            $substat->stat_name = $this->get_stat_name($r["substat_4"]);
                            $substat->value = $r["substat_4_value"];
                            array_push($rune->substats, $substat);
                        }
                    }
                    array_push($this->rune, $rune);
                }
                $statement = $db->prepare("
                  SELECT
                    run_drop_enchantment.id AS id,
                    type,
                    run_drop_enchantment.quality AS quality,
                    rune,
                    run_drop_enchantment.stat AS stat,
                    value,
                    enchantment_type.inmemorial AS inmemorial,
                    enchantment_type.ancient AS ancient,
                    enchantment_range.min AS min,
                    enchantment_range.max AS max
                  FROM
                    run_drop_enchantment,
                    enchantment_type,
                    enchantment_range
                  WHERE
                    run = :run AND
                    run_drop_enchantment.type = enchantment_type.id AND
                    enchantment_type.gem = enchantment_range.gem AND
                    enchantment_type.gem = enchantment_range.gem AND
                    enchantment_type.ancient = enchantment_range.ancient AND
                    run_drop_enchantment.quality = enchantment_range.quality AND
                    run_drop_enchantment.stat = enchantment_range.stat;
                ");
                $statement->bindValue(':run', $this->id, SQLITE3_TEXT);
                $q = $statement->execute();
                while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                    $enchantment = new Enchantment($r["id"]);
                    if (!isset($enchantment->id)){
                        $enchantment->id = $r["id"];
                        if ($r["type"] == CRAFT_ID::ENCHANT_GEM || $r["type"] == CRAFT_ID::IMMEMORIAL_GEM){
                                $enchantment->gem = 1;
                        }
                        else{
                                $enchantment->gem = 0;
                        }
                        $enchantment->quality = $r["quality"];
                        $enchantment->value = 0;
                        $enchantment->stat = $r["stat"];
                        $enchantment->ancient = $r["ancient"];
                        $enchantment->inmemorial = $r["inmemorial"];
                        $enchantment->rune = new Rune_Set($r["rune"]);
                        $enchantment->min = $r["min"];
                        $enchantment->max = $r["max"];
                        $enchantment->value = $r["value"];
                        $enchantment->amount = 0;
                        $enchantment->refresh_names();
                    }
                    else{
                        $enchantment->amount = 0;
                    }
                    array_push($this->enchantment, $enchantment);
                }
            }
        }

        /**
         * Gets a quality name frm the mappings.
         *
         * @param int $quality Quality id.
         * @return string Quality name (Uppercase)
         */
        private function get_rune_quality_name($quality){
            switch ($quality){
                case QUALITY_ID::NORMAL:
                    return "NORMAL";
                case QUALITY_ID::MAGIC:
                    return "MAGIC";
                case QUALITY_ID::RARE:
                    return "RARE";
                case QUALITY_ID::HERO:
                    return "HERO";
                case QUALITY_ID::LEGEND:
                    return "LEGEND";
                default:
                    return "";
            }
        }

        /**
         * Gets a stat name from the mappings.
         *
         * @param int $stat Stat id.
         * @return string Stat name (Uppercase)
         */
        private function get_stat_name($stat){
            switch ($stat){
                case RUNE_STAT_ID::HP:
                    return "HP";
                    break;
                case RUNE_STAT_ID::HP_P:
                    return "HP%";
                    break;
                case RUNE_STAT_ID::ATK:
                    return "ATK";
                    break;
                case RUNE_STAT_ID::ATK_P:
                    return "ATK%";
                    break;
                case RUNE_STAT_ID::DEF:
                    return "DEF";
                    break;
                case RUNE_STAT_ID::DEF_P:
                    return "DEF%";
                    break;
                case RUNE_STAT_ID::SPD:
                    return "SPD";
                    break;
                case RUNE_STAT_ID::CRR:
                    return "CRR";
                    break;
                case RUNE_STAT_ID::CRD:
                    return "CRD";
                    break;
                case RUNE_STAT_ID::RES:
                    return "RES";
                    break;
                case RUNE_STAT_ID::ACC:
                    return "ACC";
                    break;
                default:
                    return "";
            }
        }

    }
?>