<php

class Request {
    private $conn;
    private $table_name = "requests";

    public $id;
    public $pessoa_id;
    public $item_id;
    public $campaign_id;
    public $qtd;
    public $status;
    public $motivo_negativa;
    public $created_by;
    public $created_at;
    public $updated_at;

    public function __construct($db) {
        $this->conn = $db;
    }

    function create() {
        $query = "INSERT INTO " . $this->table_name . " SET pessoa_id=:pessoa_id, item_id=:item_id, campaign_id=:campaign_id, qtd=:qtd, status=:status, created_by=:created_by";
        $stmt = $this->conn->prepare($query);

        $this->pessoa_id = htmlspecialchars(strip_tags($this->pessoa_id));
        $this->item_id = htmlspecialchars(strip_tags($this->item_id));
        $this->campaign_id = htmlspecialchars(strip_tags($this->campaign_id));
        $this->qtd = htmlspecialchars(strip_tags($this->qtd));
        $this->status = htmlspecialchars(strip_tags($this->status));
        $this->created_by = htmlspecialchars(strip_tags($this->created_by));

        $stmt->bindParam(":pessoa_id", $this->pessoa_id);
        $stmt->bindParam(":item_id", $this->item_id);
        $stmt->bindParam(":campaign_id", $this->campaign_id);
        $stmt->bindParam(":qtd", $this->qtd);
        $stmt->bindParam(":status", $this->status);
        $stmt->bindParam(":created_by", $this->created_by);

        if ($stmt->execute()) {
            return true;
        }
        return false;
    }

    function update() {
        $query = "UPDATE " . $this->table_name . " SET qtd=:qtd, status=:status, motivo_negativa=:motivo_negativa WHERE id=:id";
        $stmt = $this->conn->prepare($query);

        $this->qtd = htmlspecialchars(strip_tags($this->qtd));
        $this->status = htmlspecialchars(strip_tags($this->status));
        $this->motivo_negativa = htmlspecialchars(strip_tags($this->motivo_negativa));
        $this->id = htmlspecialchars(strip_tags($this->id));

        $stmt->bindParam(":qtd", $this->qtd);
        $stmt->bindParam(":status", $this->status);
        $stmt->bindParam(":motivo_negativa", $this->motivo_negativa);
        $stmt->bindParam(":id", $this->id);

        if ($stmt->execute()) {
            return true;
        }
        return false;
    }
}