aepnat / simhelpdesk

core/classes/Report.php

<?php

class Reports
{
    private $db;

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

    public function data_report($idreport)

The parameter $idreport is not used and could be removed.

    {
        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `slaid`= ?');
        $query->bindValue(1, $slaid);

The variable $slaid seems to be never defined.

        try {
            $query->execute();

            return $query->fetch();
        } catch (PDOException $e) {
            die($e->getMessage());

Using exit here is not recommended.

        }
    }

    public function data_report_002()
    {
        $query = $this->db->prepare('SELECT * FROM `sla` ORDER BY `slaid` ASC');

        try {
            $query->execute();
        } catch (PDOException $e) {
            die($e->getMessage());

Using exit here is not recommended.

        }

        return $query->fetchAll();
    }
}