SLA

Complexity

Total Complexity

14

Size/Duplication

Total Lines	99
Duplicated Lines	0 %

Importance

Changes	1
Bugs	1	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	sla_data()	0	11	2
A	sla_exists()	0	15	3
A	delete()	0	10	2
A	get_sla()	0	11	2
A	__construct()	0	3	1
A	add_sla()	0	14	2
A	update_sla()	0	14	2

<?php

class SLA
{
    private $db;

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

    public function sla_exists($slaid)
    {
        $query = $this->db->prepare('SELECT COUNT(`slaid`) FROM `sla` WHERE `slaid`= ?');
        $query->bindValue(1, $slaid);

        try {
            $query->execute();
            $rows = $query->fetchColumn();
            if ($rows == 1) {
                return true;
            } else {
                return false;
            }
        } catch (PDOException $e) {
            die($e->getMessage());

Using exit here is not recommended.

        }
    }

    public function add_sla($slaid, $namasla, $responsetime, $resolutiontime, $slawarning)
    {
        $querystring = 'INSERT INTO `sla` (`slaid`,`namasla`,`responsetime`, `resolutiontime`, `slawarning`) VALUES (?, ?, ?, ?, ?)';
        $query = $this->db->prepare($querystring);
        $query->bindValue(1, $slaid);
        $query->bindValue(2, $namasla);
        $query->bindValue(3, $responsetime);
        $query->bindValue(4, $resolutiontime);
        $query->bindValue(5, $slawarning);

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

Using exit here is not recommended.

        }
    }

    public function update_sla($slaid, $namasla, $responsetime, $resolutiontime, $slawarning)
    {
        $querystring = 'UPDATE `sla` SET `namasla` = ? , `responsetime` = ? , `resolutiontime` = ?, `slawarning` = ?  WHERE `slaid` = ?';
        $query = $this->db->prepare($querystring);
        $query->bindValue(1, $namasla);
        $query->bindValue(2, $responsetime);
        $query->bindValue(3, $resolutiontime);
        $query->bindValue(4, $slawarning);
        $query->bindValue(5, $slaid);

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

Using exit here is not recommended.

        }
    }

    public function delete($id)
    {
        $sql = 'DELETE FROM `sla` WHERE `slaid` = ?';
        $query = $this->db->prepare($sql);
        $query->bindValue(1, $id);

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

Using exit here is not recommended.

        }
    }

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

        try {
            $query->execute();

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

Using exit here is not recommended.

        }
    }

    public function get_sla()
    {
        $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();
    }
}