<?php 

require_once(__DIR__.'/../dao/DBquery.php');

class Config
{
    var $ID          = 0;
    var $type        = "";
    var $description = "";
    var $value       = "";
    var $active      = 0;

    public function __construct($ID, $type, $description, $value, $active)
    {
        $this->ID          = $ID;
        $this->description = $description;
        $this->value       = $value;
        $this->type        = $type;
        $this->active      = $active;
    }

    public function escape(DBquery $db) {
        $this->description = utf8_decode($db->escape($this->description));
        $this->value = utf8_decode($db->escape($this->value));
    }

    public function getInsert() {
        return "INSERT INTO Config (type, description, value, active)
        VALUES ('$this->type', '$this->description', '$this->value', '$this->active');";
    }

    public function getUpdate() {
        return "UPDATE Config
        SET type='$this->type', description='$this->description', value='$this->value', active='$this->active'
        WHERE ID = '$this->ID';";
    }

    public function getDelete() {
        return "DELETE FROM Config WHERE ID = '$this->ID';";
    }


}