aepnat / simhelpdesk

core/classes/HDNews.php

Indentation +94 added lines, -94 removed lines

@@ -2,98 +2,98 @@
 
 class HDNews
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function add_news($newsdate, $title, $detail, $createdby, $createdon, $expired)
-    {
-        $query = $this->db->prepare('INSERT INTO `news` (`newsdate`,`title`, `detail`, `createdby`, `createdon`, `expired`) VALUES (?, ?, ?, ?, ?, ?)');
-        $query->bindValue(1, $newsdate);
-        $query->bindValue(2, $title);
-        $query->bindValue(3, $detail);
-        $query->bindValue(4, $createdby);
-        $query->bindValue(5, $createdon);
-        $query->bindValue(6, $expired);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_news($id, $newsdate, $title, $detail, $createdby, $createdon, $expired)
-    {
-        $query = $this->db->prepare('UPDATE `news` SET `newsdate` = ? , `title` = ? ,`detail` = ? , `createdby` = ? , `createdon` = ? , `expired` = ? WHERE `id` = ?');
-        $query->bindValue(1, $newsdate);
-        $query->bindValue(2, $title);
-        $query->bindValue(3, $detail);
-        $query->bindValue(4, $createdby);
-        $query->bindValue(5, $createdon);
-        $query->bindValue(6, $expired);
-        $query->bindValue(7, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `news` WHERE `id` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function news_data($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `news` WHERE `id`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_news()
-    {
-        $query = $this->db->prepare('SELECT * FROM `news` ORDER BY `newsdate` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_headline_news()
-    {
-        $query = $this->db->prepare('SELECT * FROM `news` WHERE UNIX_TIMESTAMP( curdate( ) ) < `expired` ORDER BY `newsdate` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function add_news($newsdate, $title, $detail, $createdby, $createdon, $expired)
+	{
+		$query = $this->db->prepare('INSERT INTO `news` (`newsdate`,`title`, `detail`, `createdby`, `createdon`, `expired`) VALUES (?, ?, ?, ?, ?, ?)');
+		$query->bindValue(1, $newsdate);
+		$query->bindValue(2, $title);
+		$query->bindValue(3, $detail);
+		$query->bindValue(4, $createdby);
+		$query->bindValue(5, $createdon);
+		$query->bindValue(6, $expired);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_news($id, $newsdate, $title, $detail, $createdby, $createdon, $expired)
+	{
+		$query = $this->db->prepare('UPDATE `news` SET `newsdate` = ? , `title` = ? ,`detail` = ? , `createdby` = ? , `createdon` = ? , `expired` = ? WHERE `id` = ?');
+		$query->bindValue(1, $newsdate);
+		$query->bindValue(2, $title);
+		$query->bindValue(3, $detail);
+		$query->bindValue(4, $createdby);
+		$query->bindValue(5, $createdon);
+		$query->bindValue(6, $expired);
+		$query->bindValue(7, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `news` WHERE `id` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function news_data($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `news` WHERE `id`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_news()
+	{
+		$query = $this->db->prepare('SELECT * FROM `news` ORDER BY `newsdate` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_headline_news()
+	{
+		$query = $this->db->prepare('SELECT * FROM `news` WHERE UNIX_TIMESTAMP( curdate( ) ) < `expired` ORDER BY `newsdate` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

core/classes/Emails.php

Indentation +201 added lines, -201 removed lines

@@ -3,211 +3,211 @@
 date_default_timezone_set('Asia/Jakarta');
 class Emails
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function add_email($idticket, $senddate, $emailto, $emailcc, $emailbcc, $emailsubject, $message, $emailstatus)
-    {
-        $querystring = 'INSERT INTO `log_emails` (`idticket`,`senddate`,`emailto`,`emailcc`, `emailbcc`,`emailsubject`,`message`, `emailstatus`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $idticket);
-        $query->bindValue(2, $senddate);
-        $query->bindValue(3, $emailto);
-        $query->bindValue(4, $emailcc);
-        $query->bindValue(5, $emailbcc);
-        $query->bindValue(6, $emailsubject);
-        $query->bindValue(7, $message);
-        $query->bindValue(8, $emailstatus);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function add_sla_remainder($idticket, $ticketnumber, $slasenddate, $emailto, $emailcc, $emailbcc, $emailsubject, $message)
-    {
-        $emailsubject = "Ticket No: $ticketnumber has reached 75% of SLA Resolution Goal Time";
-        $message =
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function add_email($idticket, $senddate, $emailto, $emailcc, $emailbcc, $emailsubject, $message, $emailstatus)
+	{
+		$querystring = 'INSERT INTO `log_emails` (`idticket`,`senddate`,`emailto`,`emailcc`, `emailbcc`,`emailsubject`,`message`, `emailstatus`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $idticket);
+		$query->bindValue(2, $senddate);
+		$query->bindValue(3, $emailto);
+		$query->bindValue(4, $emailcc);
+		$query->bindValue(5, $emailbcc);
+		$query->bindValue(6, $emailsubject);
+		$query->bindValue(7, $message);
+		$query->bindValue(8, $emailstatus);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function add_sla_remainder($idticket, $ticketnumber, $slasenddate, $emailto, $emailcc, $emailbcc, $emailsubject, $message)
+	{
+		$emailsubject = "Ticket No: $ticketnumber has reached 75% of SLA Resolution Goal Time";
+		$message =
 "Dear Assignee, \r\n

 We remaind you that your ticket No: $ticketnumber has reached 75% of SLA Resolution Goal Time.\r\n

 Please give resolution for this ticket as soon as posible.\r\n

 Thank you. \r\n

 Regards, \r\n

 Helpdesk";
-        $querystring = 'INSERT INTO `log_emails` (`idticket`,`senddate`,`emailto`,`emailcc`, `emailbcc`,`emailsubject`,`message`, `emailstatus`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $idticket);
-        $query->bindValue(2, $slasenddate);
-        $query->bindValue(3, $emailto);
-        $query->bindValue(4, $emailcc);
-        $query->bindValue(5, $emailbcc);
-        $query->bindValue(6, $emailsubject);
-        $query->bindValue(7, $message);
-        $query->bindValue(8, 'SLA Remainder');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_status_email($idemail, $emailstatus)
-    {
-        $querystring = 'UPDATE `log_emails` SET `emailstatus` = ? WHERE `idemail` = ?';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $emailstatus);
-        $query->bindValue(2, $idemail);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($idemail)
-    {
-        $sql = 'DELETE FROM `log_emails` WHERE `idemail` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $idemail);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_email_by_idemail($idemail)
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `idemail`= ?');
-        $query->bindValue(1, $idemail);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_email_by_idticket($idticket)
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `idticket`= ?');
-        $query->bindValue(1, $idticket);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_email_by_status($emailstatus)
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `emailstatus`= ?');
-        $query->bindValue(1, $emailstatus);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_email_sla_remainder()
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `emailstatus`= ? and senddate <= UNIX_TIMESTAMP(NOW())');
-        $query->bindValue(1, 'SLA Remainder');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_email()
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_emails` ORDER BY `idemail` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_email_queue()
-    {
-        $query = $this->db->prepare("SELECT * FROM `log_emails` WHERE `emailstatus` <> 'Sent' AND senddate <= UNIX_TIMESTAMP(NOW()) ORDER BY `senddate` ASC");
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_email_queue_by_id($idemail)
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `idemail`= ?');
-        $query->bindValue(1, $idemail);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function send_new_ticket()
-    {
-        if (substr(php_uname(), 0, 7) == 'Windows') {
-            //$cmd = "D:\mowes_portable\www\helpdesk\batch\sendnewticket.bat";
-            $cmd = "C:\xampp\htdocs\helpdesk\batch\sendnewticket.bat";
-            $WshShell = new COM('WScript.Shell');
-            $oExec = $WshShell->Run("cmd /C $cmd", 0, false);
-
-            return $oExec == 0 ? true : false;
-        } else {
-            $cmd = 'php /batch/sendnewticket.bat';
-            exec($cmd.' > /dev/null &');
-        }
-    }
-
-    public function send_sla_remainder()
-    {
-        if (substr(php_uname(), 0, 7) == 'Windows') {
-            //$cmd = "D:\mowes_portable\www\helpdesk\batch\sendslaremainder.bat";
-            $cmd = "C:\xampp\htdocs\helpdesk\batch\sendslaremainder.bat";
-            $WshShell = new COM('WScript.Shell');
-            $oExec = $WshShell->Run("cmd /C $cmd", 0, false);
-
-            return $oExec == 0 ? true : false;
-        } else {
-            $cmd = 'php /batch/sendslaremainder.bat';
-            exec($cmd.' > /dev/null &');
-        }
-    }
+		$querystring = 'INSERT INTO `log_emails` (`idticket`,`senddate`,`emailto`,`emailcc`, `emailbcc`,`emailsubject`,`message`, `emailstatus`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $idticket);
+		$query->bindValue(2, $slasenddate);
+		$query->bindValue(3, $emailto);
+		$query->bindValue(4, $emailcc);
+		$query->bindValue(5, $emailbcc);
+		$query->bindValue(6, $emailsubject);
+		$query->bindValue(7, $message);
+		$query->bindValue(8, 'SLA Remainder');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_status_email($idemail, $emailstatus)
+	{
+		$querystring = 'UPDATE `log_emails` SET `emailstatus` = ? WHERE `idemail` = ?';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $emailstatus);
+		$query->bindValue(2, $idemail);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($idemail)
+	{
+		$sql = 'DELETE FROM `log_emails` WHERE `idemail` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $idemail);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_email_by_idemail($idemail)
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `idemail`= ?');
+		$query->bindValue(1, $idemail);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_email_by_idticket($idticket)
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `idticket`= ?');
+		$query->bindValue(1, $idticket);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_email_by_status($emailstatus)
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `emailstatus`= ?');
+		$query->bindValue(1, $emailstatus);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_email_sla_remainder()
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `emailstatus`= ? and senddate <= UNIX_TIMESTAMP(NOW())');
+		$query->bindValue(1, 'SLA Remainder');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_email()
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_emails` ORDER BY `idemail` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_email_queue()
+	{
+		$query = $this->db->prepare("SELECT * FROM `log_emails` WHERE `emailstatus` <> 'Sent' AND senddate <= UNIX_TIMESTAMP(NOW()) ORDER BY `senddate` ASC");
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_email_queue_by_id($idemail)
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_emails` WHERE `idemail`= ?');
+		$query->bindValue(1, $idemail);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function send_new_ticket()
+	{
+		if (substr(php_uname(), 0, 7) == 'Windows') {
+			//$cmd = "D:\mowes_portable\www\helpdesk\batch\sendnewticket.bat";
+			$cmd = "C:\xampp\htdocs\helpdesk\batch\sendnewticket.bat";
+			$WshShell = new COM('WScript.Shell');
+			$oExec = $WshShell->Run("cmd /C $cmd", 0, false);
+
+			return $oExec == 0 ? true : false;
+		} else {
+			$cmd = 'php /batch/sendnewticket.bat';
+			exec($cmd.' > /dev/null &');
+		}
+	}
+
+	public function send_sla_remainder()
+	{
+		if (substr(php_uname(), 0, 7) == 'Windows') {
+			//$cmd = "D:\mowes_portable\www\helpdesk\batch\sendslaremainder.bat";
+			$cmd = "C:\xampp\htdocs\helpdesk\batch\sendslaremainder.bat";
+			$WshShell = new COM('WScript.Shell');
+			$oExec = $WshShell->Run("cmd /C $cmd", 0, false);
+
+			return $oExec == 0 ? true : false;
+		} else {
+			$cmd = 'php /batch/sendslaremainder.bat';
+			exec($cmd.' > /dev/null &');
+		}
+	}
 }

core/classes/Report.php

Indentation +33 added lines, -33 removed lines

@@ -2,37 +2,37 @@
 
 class Reports
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function data_report($idreport)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `slaid`= ?');
-        $query->bindValue(1, $slaid);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    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());
-        }
-
-        return $query->fetchAll();
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function data_report($idreport)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `slaid`= ?');
+		$query->bindValue(1, $slaid);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	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());
+		}
+
+		return $query->fetchAll();
+	}
 }

core/classes/General.php

Indentation +18 added lines, -18 removed lines

@@ -2,24 +2,24 @@
 
 class General
 {
-    public function logged_in()
-    {
-        return(isset($_SESSION['loginid'])) ? true : false;
-    }
+	public function logged_in()
+	{
+		return(isset($_SESSION['loginid'])) ? true : false;
+	}
 
-    public function logged_in_protect()
-    {
-        if ($this->logged_in() === true) {
-            header('Location: home.php');
-            exit();
-        }
-    }
+	public function logged_in_protect()
+	{
+		if ($this->logged_in() === true) {
+			header('Location: home.php');
+			exit();
+		}
+	}
 
-    public function logged_out_protect()
-    {
-        if ($this->logged_in() === false) {
-            header('Location: index.php');
-            exit();
-        }
-    }
+	public function logged_out_protect()
+	{
+		if ($this->logged_in() === false) {
+			header('Location: index.php');
+			exit();
+		}
+	}
 }

core/classes/Customers.php

Indentation +191 added lines, -191 removed lines

@@ -2,195 +2,195 @@
 
 class Customers
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function customer_exists($customername)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `customername`= ?');
-        $query->bindValue(1, $customername);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function email_exists($email)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `email`= ?');
-        $query->bindValue(1, $email);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function add_customer($namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $query = $this->db->prepare('INSERT INTO `customers` (`namacustomer`, `alamat`, `Telp`, `email`, `PIC`,`selesperson`, `customerproduct`, `time`, `ip`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)');
-        $query->bindValue(1, $namacustomer);
-        $query->bindValue(2, $alamat);
-        $query->bindValue(3, $Telp);
-        $query->bindValue(4, $email);
-        $query->bindValue(5, $PIC);
-        $query->bindValue(6, $selesperson);
-        $query->bindValue(7, $customerproduct);
-        $query->bindValue(8, $time);
-        $query->bindValue(9, $ip);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_customer($idcustomer, $namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $query = $this->db->prepare('UPDATE `customers` SET `namacustomer` = ? , `alamat` = ? , `Telp` = ? , `email` = ? , `PIC` = ? , `selesperson` = ? ,`customerproduct` = ? ,`ip` = ? , `time` = ? WHERE `idcustomer` = ?');
-        $query->bindValue(1, $namacustomer);
-        $query->bindValue(2, $alamat);
-        $query->bindValue(3, $Telp);
-        $query->bindValue(4, $email);
-        $query->bindValue(5, $PIC);
-        $query->bindValue(6, $selesperson);
-        $query->bindValue(7, $customerproduct);
-        $query->bindValue(8, $ip);
-        $query->bindValue(9, $time);
-        $query->bindValue(10, $idcustomer);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `customers` WHERE `idcustomer` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function activate($email, $email_code)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `email` = ? AND `email_code` = ? AND `confirmed` = ?');
-        $query->bindValue(1, $email);
-        $query->bindValue(2, $email_code);
-        $query->bindValue(3, 0);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                $query_2 = $this->db->prepare('UPDATE `customers` SET `confirmed` = ? WHERE `email` = ?');
-                $query_2->bindValue(1, 1);
-                $query_2->bindValue(2, $email);
-                $query_2->execute();
-
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function email_confirmed($username)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `username`= ? AND `confirmed` = ?');
-        $query->bindValue(1, $username);
-        $query->bindValue(2, 1);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function login_customer($username, $password)
-    {
-        $query = $this->db->prepare('SELECT `email`, `ticket_id` FROM `customers` WHERE `email` = ?');
-        $query->bindValue(1, $username);
-
-        try {
-            $query->execute();
-            $data = $query->fetch();
-            $stored_password = $data['password'];
-            $id = $data['id'];
-            if ($stored_password === sha1($password)) {
-                return $id;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function customer_data($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `customers` WHERE `idcustomer`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_customers()
-    {
-        $query = $this->db->prepare('SELECT * FROM `customers` ORDER BY `namacustomer` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function customer_exists($customername)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `customername`= ?');
+		$query->bindValue(1, $customername);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function email_exists($email)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `email`= ?');
+		$query->bindValue(1, $email);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function add_customer($namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$query = $this->db->prepare('INSERT INTO `customers` (`namacustomer`, `alamat`, `Telp`, `email`, `PIC`,`selesperson`, `customerproduct`, `time`, `ip`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)');
+		$query->bindValue(1, $namacustomer);
+		$query->bindValue(2, $alamat);
+		$query->bindValue(3, $Telp);
+		$query->bindValue(4, $email);
+		$query->bindValue(5, $PIC);
+		$query->bindValue(6, $selesperson);
+		$query->bindValue(7, $customerproduct);
+		$query->bindValue(8, $time);
+		$query->bindValue(9, $ip);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_customer($idcustomer, $namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$query = $this->db->prepare('UPDATE `customers` SET `namacustomer` = ? , `alamat` = ? , `Telp` = ? , `email` = ? , `PIC` = ? , `selesperson` = ? ,`customerproduct` = ? ,`ip` = ? , `time` = ? WHERE `idcustomer` = ?');
+		$query->bindValue(1, $namacustomer);
+		$query->bindValue(2, $alamat);
+		$query->bindValue(3, $Telp);
+		$query->bindValue(4, $email);
+		$query->bindValue(5, $PIC);
+		$query->bindValue(6, $selesperson);
+		$query->bindValue(7, $customerproduct);
+		$query->bindValue(8, $ip);
+		$query->bindValue(9, $time);
+		$query->bindValue(10, $idcustomer);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `customers` WHERE `idcustomer` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function activate($email, $email_code)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `email` = ? AND `email_code` = ? AND `confirmed` = ?');
+		$query->bindValue(1, $email);
+		$query->bindValue(2, $email_code);
+		$query->bindValue(3, 0);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				$query_2 = $this->db->prepare('UPDATE `customers` SET `confirmed` = ? WHERE `email` = ?');
+				$query_2->bindValue(1, 1);
+				$query_2->bindValue(2, $email);
+				$query_2->execute();
+
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function email_confirmed($username)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `username`= ? AND `confirmed` = ?');
+		$query->bindValue(1, $username);
+		$query->bindValue(2, 1);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function login_customer($username, $password)
+	{
+		$query = $this->db->prepare('SELECT `email`, `ticket_id` FROM `customers` WHERE `email` = ?');
+		$query->bindValue(1, $username);
+
+		try {
+			$query->execute();
+			$data = $query->fetch();
+			$stored_password = $data['password'];
+			$id = $data['id'];
+			if ($stored_password === sha1($password)) {
+				return $id;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function customer_data($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `customers` WHERE `idcustomer`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_customers()
+	{
+		$query = $this->db->prepare('SELECT * FROM `customers` ORDER BY `namacustomer` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

core/classes/Projects.php

Indentation +129 added lines, -129 removed lines

@@ -2,133 +2,133 @@
 
 class Projects
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function project_exists($projectid)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `projects` WHERE `projectid`= ?');
-        $query->bindValue(1, $projectid);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function add_project($projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
-    {
-        $querystring = 'INSERT INTO `projects` (`projectname`,`idcustomer`, `deliverybegin`, `deliveryend`, `installbegin`, `installend`,`uatbegin`,`uatend`,`billstartdate`, `billduedate`, `warrantyperiod`, `contractstartdate`, `contractperiod`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $projectname);
-        $query->bindValue(2, $idcustomer);
-        $query->bindValue(3, $deliverybegin);
-        $query->bindValue(4, $deliveryend);
-        $query->bindValue(5, $installbegin);
-        $query->bindValue(6, $installend);
-        $query->bindValue(7, $uatbegin);
-        $query->bindValue(8, $uatend);
-        $query->bindValue(9, $billstartdate);
-        $query->bindValue(10, $billduedate);
-        $query->bindValue(11, $warrantyperiod);
-        $query->bindValue(12, $contractstartdate);
-        $query->bindValue(13, $contractperiod);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_project($projectid, $projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
-    {
-        $querystring = 'UPDATE `projects` SET `projectname` = ? , `idcustomer` = ? , `deliverybegin` = ? , `deliveryend` = ? , `installbegin` = ? ,`installend` = ? , `uatbegin` = ? , `uatend` = ? ,`billstartdate` = ?, `billduedate` = ? , `warrantyperiod` = ? ,`contractstartdate` = ?,`contractperiod` = ? WHERE `projectid` = ?';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $projectname);
-        $query->bindValue(2, $idcustomer);
-        $query->bindValue(3, $deliverybegin);
-        $query->bindValue(4, $deliveryend);
-        $query->bindValue(5, $installbegin);
-        $query->bindValue(6, $installend);
-        $query->bindValue(7, $uatbegin);
-        $query->bindValue(8, $uatend);
-        $query->bindValue(9, $billstartdate);
-        $query->bindValue(10, $billduedate);
-        $query->bindValue(11, $warrantyperiod);
-        $query->bindValue(12, $contractstartdate);
-        $query->bindValue(13, $contractperiod);
-        $query->bindValue(14, $projectid);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `projects` WHERE `projectid` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function project_data($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `projects` WHERE `projectid`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_projects()
-    {
-        $query = $this->db->prepare('SELECT * FROM `projects` ORDER BY `projectid` DESC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_project_customer($id) //get project_data by idcustomer
-    {
-        $query = $this->db->prepare('SELECT * FROM `projects` WHERE `idcustomer`= ? ORDER BY `contractstartdate` DESC LIMIT 1');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function project_exists($projectid)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `projects` WHERE `projectid`= ?');
+		$query->bindValue(1, $projectid);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function add_project($projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
+	{
+		$querystring = 'INSERT INTO `projects` (`projectname`,`idcustomer`, `deliverybegin`, `deliveryend`, `installbegin`, `installend`,`uatbegin`,`uatend`,`billstartdate`, `billduedate`, `warrantyperiod`, `contractstartdate`, `contractperiod`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $projectname);
+		$query->bindValue(2, $idcustomer);
+		$query->bindValue(3, $deliverybegin);
+		$query->bindValue(4, $deliveryend);
+		$query->bindValue(5, $installbegin);
+		$query->bindValue(6, $installend);
+		$query->bindValue(7, $uatbegin);
+		$query->bindValue(8, $uatend);
+		$query->bindValue(9, $billstartdate);
+		$query->bindValue(10, $billduedate);
+		$query->bindValue(11, $warrantyperiod);
+		$query->bindValue(12, $contractstartdate);
+		$query->bindValue(13, $contractperiod);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_project($projectid, $projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
+	{
+		$querystring = 'UPDATE `projects` SET `projectname` = ? , `idcustomer` = ? , `deliverybegin` = ? , `deliveryend` = ? , `installbegin` = ? ,`installend` = ? , `uatbegin` = ? , `uatend` = ? ,`billstartdate` = ?, `billduedate` = ? , `warrantyperiod` = ? ,`contractstartdate` = ?,`contractperiod` = ? WHERE `projectid` = ?';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $projectname);
+		$query->bindValue(2, $idcustomer);
+		$query->bindValue(3, $deliverybegin);
+		$query->bindValue(4, $deliveryend);
+		$query->bindValue(5, $installbegin);
+		$query->bindValue(6, $installend);
+		$query->bindValue(7, $uatbegin);
+		$query->bindValue(8, $uatend);
+		$query->bindValue(9, $billstartdate);
+		$query->bindValue(10, $billduedate);
+		$query->bindValue(11, $warrantyperiod);
+		$query->bindValue(12, $contractstartdate);
+		$query->bindValue(13, $contractperiod);
+		$query->bindValue(14, $projectid);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `projects` WHERE `projectid` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function project_data($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `projects` WHERE `projectid`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_projects()
+	{
+		$query = $this->db->prepare('SELECT * FROM `projects` ORDER BY `projectid` DESC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_project_customer($id) //get project_data by idcustomer
+	{
+		$query = $this->db->prepare('SELECT * FROM `projects` WHERE `idcustomer`= ? ORDER BY `contractstartdate` DESC LIMIT 1');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
 }

core/classes/SLA.php

Indentation +98 added lines, -98 removed lines

@@ -2,102 +2,102 @@
 
 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());
-        }
-    }
-
-    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());
-        }
-    }
-
-    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());
-        }
-    }
-
-    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());
-        }
-    }
-
-    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());
-        }
-    }
-
-    public function get_sla()
-    {
-        $query = $this->db->prepare('SELECT * FROM `sla` ORDER BY `slaid` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	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());
+		}
+	}
+
+	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());
+		}
+	}
+
+	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());
+		}
+	}
+
+	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());
+		}
+	}
+
+	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());
+		}
+	}
+
+	public function get_sla()
+	{
+		$query = $this->db->prepare('SELECT * FROM `sla` ORDER BY `slaid` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

core/connect/database.php

Indentation +4 added lines, -4 removed lines

@@ -1,10 +1,10 @@
 <?php
 
 $config = [
-    'host'		    => 'localhost',
-    'username' 	=> 'root',
-    'password' 	=> 'root',
-    'dbname' 	  => 'helpdesk',
+	'host'		    => 'localhost',
+	'username' 	=> 'root',
+	'password' 	=> 'root',
+	'dbname' 	  => 'helpdesk',
 ];
 
 $db = new PDO('mysql:host='.$config['host'].';dbname='.$config['dbname'], $config['username'], $config['password']);

core/init.php

Indentation +11 added lines, -11 removed lines

@@ -5,20 +5,20 @@
 require_once 'connect/database.php';
 function my_autoload($class)
 {
-    $filename = 'classes/'.$class.'.php';
-    include_once $filename;
+	$filename = 'classes/'.$class.'.php';
+	include_once $filename;
 }
 spl_autoload_register('my_autoload');
 
 try {
-    $general = new General();
-    $users = new Users($db);
-    $customers = new Customers($db);
-    $projects = new Projects($db);
-    $tickets = new Tickets($db);
-    $hdnews = new HDNews($db);
-    $slas = new SLA($db);
-    $emails = new Emails($db);
+	$general = new General();
+	$users = new Users($db);
+	$customers = new Customers($db);
+	$projects = new Projects($db);
+	$tickets = new Tickets($db);
+	$hdnews = new HDNews($db);
+	$slas = new SLA($db);
+	$emails = new Emails($db);
 } catch (Exception $e) {
-    echo 'Caught exception: ',  $e->getMessage(), "\n";
+	echo 'Caught exception: ',  $e->getMessage(), "\n";
 }