<?php

require_once "class/framework.class.php";

/*
 * Base class for Scrott database objects
 */
abstract class Object extends Framework
{
    /*
     * Constructor
     */
    function __construct($childTable, $childCols)
    {
        $this->db = $this->getDbConnection();

        $this->table = "object";
        $this->cols = array(
            "guid",
            "perms",
            "owner",
            "parent",
            "name",
            "timeCreated",
            "timeUpdated",
            "type"
        );

        $this->childTable = $this->db->esc($childTable);
        $this->childCols = array();

        if (is_array($childCols))
        {
            foreach ($childCols as $col)
                $this->childCols[] = $this->db->esc($col);
        }
    }

    /*
     * Populate this object with data from the DB with a given GUID
     */
    function loadObj($guid)
    {
        if (is_null($guid))
            return;

        $escdGuid = $this->db->esc($guid);

        /* Base fields */
        $query = "SELECT * FROM `" . $this->table . "` WHERE `guid` = '" . $escdGuid . "'";
        $result = $this->db->query($query)[0];

        foreach ($this->cols as $col)
        {
            if (isset($result[$col]))
                $this->$col = $result[$col];
        }

        /* Child Table fields */
        $query = "SELECT * FROM `" . $this->childTable . "` WHERE `guid` = '" . $escdGuid . "'";
        $result = $this->db->query($query)[0];

        foreach ($this->childCols as $col)
        {
            if (isset($result[$col]))
                $this->$col = $result[$col];
        }
    }

    /*
     * Write this object to the database
     */
    function saveObj()
    {
        if (isset($this->guid))
        {
            /* Update Base */
            $updateStr = "";

            foreach ($this->cols as $col)
            {
                if (!isset($this->$col))
                    continue;

                $updateStr .= "`" . $col . "` = '" . $this->db->esc($this->$col) . "', ";
            }

            if (strlen($updateStr) > 0)
            {
                $updateStr = substr($updateStr, 0, -2); // remove ", " from the end
                $query = "UPDATE `" . $this->table . "` SET " . $updateStr . " WHERE `guid` = '" . $this->db->esc($this->guid) . "'";
                $this->db->query($query);
            }

            /* Update Child */
            $updateStr = "";

            foreach ($this->childCols as $col)
            {
                if (!isset($this->$col))
                    continue;

                $updateStr .= "`" . $col . "` = '" . $this->db->esc($this->$col) . "', ";
            }

            if (strlen($updateStr) > 0)
            {
                $updateStr = substr($updateStr, 0, -2); // remove ", " from the end
                $query = "UPDATE `" . $this->childTable . "` SET " . $updateStr . " WHERE `guid` = '" . $this->db->esc($this->guid) . "'";
                $this->db->query($query);
            }
        }

        else
        {
            $this->guid = $this->getNewGUID();

            /* Insert Base */
            $colsStr = "";
            $valsStr = "";

            foreach ($this->cols as $col)
            {
                if (!isset($this->$col))
                    continue;

                $colsStr .= "`" . $col . "`, ";
                $valsStr .= "'" . $this->db->esc($this->$col) . "', ";
            }

            if (strlen($colsStr) > 0)
            {
                $colsStr = substr($colsStr, 0, -2); // remove ", "
                $valsStr = substr($valsStr, 0, -2);
                $query = "INSERT INTO `" . $this->table . "` (" . $colsStr . ") VALUES (" . $valsStr . ")";
                $this->db->query($query);
            }

            /* Insert Child */
            $colsStr = "";
            $valsStr = "";

            foreach ($this->childCols as $col)
            {
                if (!isset($this->$col))
                    continue;

                $colsStr .= "`" . $col . "`, ";
                $valsStr .= "'" . $this->db->esc($this->$col) . "', ";
            }

            if (strlen($colsStr) > 0)
            {
                $colsStr = substr($colsStr, 0, -2); // remove ", "
                $valsStr = substr($valsStr, 0, -2);
                $query = "INSERT INTO `" . $this->childTable . "` (" . $colsStr . ") VALUES (" . $valsStr . ")";
                $this->db->query($query);
            }
        }
    }

    /*
     * Remove this object from the database
     */
    function delObj()
    {
        if (!isset($this->guid))
            return;

        /* Delete Base */
        $query = "DELETE FROM `" . $this->table . "` WHERE `guid` = '" . $this->db->esc($this->guid) . "'";
        $this->db->query($query);

        /* Delete Child */
        $query = "DELETE FROM `" . $this->childTable . "` WHERE `guid` = '" . $this->db->esc($this->guid) . "'";
        $this->db->query($query);
    }
}

?>