aepnat / simhelpdesk

core/classes/Tickets.php

Indentation +349 added lines, -349 removed lines

@@ -3,308 +3,308 @@ 
 date_default_timezone_set('Asia/Jakarta');
 class Tickets
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function ticket_exists($projectid)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `tickets` WHERE `ticketnumber`= ?');
-        $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_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro)
-    {
-        $current = time();
-        $querystring = 'INSERT INTO `tickets` (`ticketnumber`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`documentedby`,`documenteddate`,`pro`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $ticketnumber);
-        $query->bindValue(2, $sla);
-        //$query->bindValue(3, $idcustomer);
-        $query->bindValue(3, $reporteddate);
-        $query->bindValue(4, $reportedby);
-        $query->bindValue(5, $telp);
-        $query->bindValue(6, $email);
-        $query->bindValue(7, $problemsummary);
-        $query->bindValue(8, $problemdetail);
-        $query->bindValue(9, $ticketstatus);
-        $query->bindValue(10, $assignee);
-        $query->bindValue(11, $documentedby);
-        $query->bindValue(12, $current);
-        $query->bindValue(13, $pro);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate)
-    {
-        $querystring = 'UPDATE `tickets` SET `sla` = ? , `reporteddate` = ? , `reportedby` = ? , `telp` = ? ,`email` = ? , `problemsummary` = ? , `problemdetail` = ? ,`ticketstatus` = ?, `assignee` = ? , `assigneddate` = ?, `pendingby` = ?,`pendingdate` = ?, `resolution` = ? ,`resolvedby` = ?,`resolveddate` = ?,`closedby` = ?,`closeddate` = ? WHERE `id` = ?';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $sla);
-        $query->bindValue(2, $reporteddate);
-        $query->bindValue(3, $reportedby);
-        $query->bindValue(4, $telp);
-        $query->bindValue(5, $email);
-        $query->bindValue(6, $problemsummary);
-        $query->bindValue(7, $problemdetail);
-        $query->bindValue(8, $ticketstatus);
-        $query->bindValue(9, $assignee);
-        $query->bindValue(10, $assigneddate);
-        $query->bindValue(11, $pendingby);
-        $query->bindValue(12, $pendingdate);
-        $query->bindValue(13, $resolution);
-        $query->bindValue(14, $resolvedby);
-        $query->bindValue(15, $resolveddate);
-        $query->bindValue(16, $closedby);
-        $query->bindValue(17, $closeddate);
-        $query->bindValue(18, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `tickets` WHERE `id` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function ticket_data($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `id`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_tickets()
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY `ticketnumber` DESC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_pro()
-    {
-        $query = $this->db->prepare('SELECT pro FROM `tickets`');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_opened_tickets()
-    {
-        $query = $this->db->prepare("SELECT * FROM `tickets` WHERE `ticketstatus` <> 'Closed' ORDER BY `ticketnumber` DESC");
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_tickets_by_requester($userid)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `documentedby`= ? ORDER BY `ticketnumber` DESC');
-        $query->bindValue(1, $userid);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_tickets_by_assignee($userid)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `assignee`= ? ORDER BY `ticketnumber` DESC');
-        $query->bindValue(1, $userid);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_tickets_by_resolver($username)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`= ? ORDER BY `ticketnumber` DESC');
-        $query->bindValue(1, $username);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_tickets_by_resolver_not_closed($username)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`=? and `ticketstatus` <> ? ORDER BY `ticketnumber` DESC');
-        $query->bindValue(1, $username);
-        $query->bindValue(2, 'Closed');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_tickets_by_status($ticketstatus)
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `ticketstatus`=? ORDER BY `ticketnumber` DESC');
-        $query->bindValue(1, $ticketstatus);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function search_closed_ticket($fromperiod, $toperiod)
-    {
-        $query = $this->db->prepare("SELECT * FROM `tickets` WHERE `documenteddate` >= ? AND `documenteddate` <= ? AND `ticketstatus` = 'Closed' ORDER BY `documenteddate` DESC");
-        $query->bindValue(1, $fromperiod);
-        $query->bindValue(2, $toperiod);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function count_tickets_by_customer()
-    {
-        $query = $this->db->prepare('SELECT `idcustomer`, count(*) as `total` FROM `tickets` GROUP BY `idcustomer` ORDER BY total DESC LIMIT 5');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function count_tickets_by_status()
-    {
-        $query = $this->db->prepare('SELECT ticketstatus, count(*) as total FROM `tickets` GROUP BY ticketstatus');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function count_resolved_tickets_by_month()
-    {
-        $sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Resolved' OR `ticketstatus`='Closed') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))";
-        $query = $this->db->prepare($sql);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function count_inprogress_tickets_by_month()
-    {
-        $sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Assigned' OR `ticketstatus`='Pending') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))";
-        $query = $this->db->prepare($sql);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_last_ticket()
-    {
-        $query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY id DESC LIMIT 1');
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    /*
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function ticket_exists($projectid)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `tickets` WHERE `ticketnumber`= ?');
+		$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_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro)
+	{
+		$current = time();
+		$querystring = 'INSERT INTO `tickets` (`ticketnumber`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`documentedby`,`documenteddate`,`pro`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $ticketnumber);
+		$query->bindValue(2, $sla);
+		//$query->bindValue(3, $idcustomer);
+		$query->bindValue(3, $reporteddate);
+		$query->bindValue(4, $reportedby);
+		$query->bindValue(5, $telp);
+		$query->bindValue(6, $email);
+		$query->bindValue(7, $problemsummary);
+		$query->bindValue(8, $problemdetail);
+		$query->bindValue(9, $ticketstatus);
+		$query->bindValue(10, $assignee);
+		$query->bindValue(11, $documentedby);
+		$query->bindValue(12, $current);
+		$query->bindValue(13, $pro);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate)
+	{
+		$querystring = 'UPDATE `tickets` SET `sla` = ? , `reporteddate` = ? , `reportedby` = ? , `telp` = ? ,`email` = ? , `problemsummary` = ? , `problemdetail` = ? ,`ticketstatus` = ?, `assignee` = ? , `assigneddate` = ?, `pendingby` = ?,`pendingdate` = ?, `resolution` = ? ,`resolvedby` = ?,`resolveddate` = ?,`closedby` = ?,`closeddate` = ? WHERE `id` = ?';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $sla);
+		$query->bindValue(2, $reporteddate);
+		$query->bindValue(3, $reportedby);
+		$query->bindValue(4, $telp);
+		$query->bindValue(5, $email);
+		$query->bindValue(6, $problemsummary);
+		$query->bindValue(7, $problemdetail);
+		$query->bindValue(8, $ticketstatus);
+		$query->bindValue(9, $assignee);
+		$query->bindValue(10, $assigneddate);
+		$query->bindValue(11, $pendingby);
+		$query->bindValue(12, $pendingdate);
+		$query->bindValue(13, $resolution);
+		$query->bindValue(14, $resolvedby);
+		$query->bindValue(15, $resolveddate);
+		$query->bindValue(16, $closedby);
+		$query->bindValue(17, $closeddate);
+		$query->bindValue(18, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `tickets` WHERE `id` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function ticket_data($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `id`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_tickets()
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY `ticketnumber` DESC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_pro()
+	{
+		$query = $this->db->prepare('SELECT pro FROM `tickets`');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_opened_tickets()
+	{
+		$query = $this->db->prepare("SELECT * FROM `tickets` WHERE `ticketstatus` <> 'Closed' ORDER BY `ticketnumber` DESC");
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_tickets_by_requester($userid)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `documentedby`= ? ORDER BY `ticketnumber` DESC');
+		$query->bindValue(1, $userid);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_tickets_by_assignee($userid)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `assignee`= ? ORDER BY `ticketnumber` DESC');
+		$query->bindValue(1, $userid);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_tickets_by_resolver($username)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`= ? ORDER BY `ticketnumber` DESC');
+		$query->bindValue(1, $username);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_tickets_by_resolver_not_closed($username)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`=? and `ticketstatus` <> ? ORDER BY `ticketnumber` DESC');
+		$query->bindValue(1, $username);
+		$query->bindValue(2, 'Closed');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_tickets_by_status($ticketstatus)
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` WHERE `ticketstatus`=? ORDER BY `ticketnumber` DESC');
+		$query->bindValue(1, $ticketstatus);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function search_closed_ticket($fromperiod, $toperiod)
+	{
+		$query = $this->db->prepare("SELECT * FROM `tickets` WHERE `documenteddate` >= ? AND `documenteddate` <= ? AND `ticketstatus` = 'Closed' ORDER BY `documenteddate` DESC");
+		$query->bindValue(1, $fromperiod);
+		$query->bindValue(2, $toperiod);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function count_tickets_by_customer()
+	{
+		$query = $this->db->prepare('SELECT `idcustomer`, count(*) as `total` FROM `tickets` GROUP BY `idcustomer` ORDER BY total DESC LIMIT 5');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function count_tickets_by_status()
+	{
+		$query = $this->db->prepare('SELECT ticketstatus, count(*) as total FROM `tickets` GROUP BY ticketstatus');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function count_resolved_tickets_by_month()
+	{
+		$sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Resolved' OR `ticketstatus`='Closed') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))";
+		$query = $this->db->prepare($sql);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function count_inprogress_tickets_by_month()
+	{
+		$sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Assigned' OR `ticketstatus`='Pending') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))";
+		$query = $this->db->prepare($sql);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_last_ticket()
+	{
+		$query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY id DESC LIMIT 1');
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	/*
         public function notify_assignee($id,$ticketnumber,$email_assignee)
         {	if (substr(php_uname(), 0, 7) == "Windows"){
                 $cmd = "D:\mowes_portable\www\helpdesk\batch\sendemail.bat";
@@ -318,51 +318,51 @@ 
             }
         }*/
 
-    public function log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby)
-    {
-        $changedate = time();
-        $querystring = 'INSERT INTO `log_tickets` (`id`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`assigneddate`,`pendingby`,`pendingdate`,`resolution`,`resolvedby`,`resolveddate`,`closedby`,`closeddate`,`changes`,`changeby`,`changedate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $id);
-        $query->bindValue(2, $sla);
-        $query->bindValue(3, $reporteddate);
-        $query->bindValue(4, $reportedby);
-        $query->bindValue(5, $telp);
-        $query->bindValue(6, $email);
-        $query->bindValue(7, $problemsummary);
-        $query->bindValue(8, $problemdetail);
-        $query->bindValue(9, $ticketstatus);
-        $query->bindValue(10, $assignee);
-        $query->bindValue(11, $assigneddate);
-        $query->bindValue(12, $pendingby);
-        $query->bindValue(13, $pendingdate);
-        $query->bindValue(14, $resolution);
-        $query->bindValue(15, $resolvedby);
-        $query->bindValue(16, $resolveddate);
-        $query->bindValue(17, $closedby);
-        $query->bindValue(18, $closeddate);
-        $query->bindValue(19, $changes);
-        $query->bindValue(20, $changeby);
-        $query->bindValue(21, $changedate);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_audit_trail($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_tickets` WHERE `id`= ? ORDER BY `changedate` DESC');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	public function log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby)
+	{
+		$changedate = time();
+		$querystring = 'INSERT INTO `log_tickets` (`id`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`assigneddate`,`pendingby`,`pendingdate`,`resolution`,`resolvedby`,`resolveddate`,`closedby`,`closeddate`,`changes`,`changeby`,`changedate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $id);
+		$query->bindValue(2, $sla);
+		$query->bindValue(3, $reporteddate);
+		$query->bindValue(4, $reportedby);
+		$query->bindValue(5, $telp);
+		$query->bindValue(6, $email);
+		$query->bindValue(7, $problemsummary);
+		$query->bindValue(8, $problemdetail);
+		$query->bindValue(9, $ticketstatus);
+		$query->bindValue(10, $assignee);
+		$query->bindValue(11, $assigneddate);
+		$query->bindValue(12, $pendingby);
+		$query->bindValue(13, $pendingdate);
+		$query->bindValue(14, $resolution);
+		$query->bindValue(15, $resolvedby);
+		$query->bindValue(16, $resolveddate);
+		$query->bindValue(17, $closedby);
+		$query->bindValue(18, $closeddate);
+		$query->bindValue(19, $changes);
+		$query->bindValue(20, $changeby);
+		$query->bindValue(21, $changedate);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_audit_trail($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_tickets` WHERE `id`= ? ORDER BY `changedate` DESC');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

Spacing +22 added lines, -22 removed lines

@@ -20,10 +20,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -50,7 +50,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -80,7 +80,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -93,7 +93,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -107,7 +107,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -118,7 +118,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -131,7 +131,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -144,7 +144,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -158,7 +158,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -172,7 +172,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -186,7 +186,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -201,7 +201,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -215,7 +215,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -230,7 +230,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -243,7 +243,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -256,7 +256,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -270,7 +270,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -284,7 +284,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -299,7 +299,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -347,7 +347,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -359,7 +359,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

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();
+	}
 }

Spacing +6 added lines, -6 removed lines

@@ -21,7 +21,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -39,7 +39,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -52,7 +52,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -66,7 +66,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -77,7 +77,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -90,7 +90,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

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 &');
+		}
+	}
 }

Spacing +13 added lines, -13 removed lines

@@ -25,7 +25,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -53,7 +53,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -67,7 +67,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -80,7 +80,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -94,7 +94,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -108,7 +108,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -120,7 +120,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -134,7 +134,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -147,7 +147,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -160,7 +160,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -176,7 +176,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -190,7 +190,7 @@ 
             $oExec = $WshShell->Run("cmd /C $cmd", 0, false);
 
             return $oExec == 0 ? true : false;
-        } else {
+        }else {
             $cmd = 'php /batch/sendnewticket.bat';
             exec($cmd.' > /dev/null &');
         }
@@ -205,7 +205,7 @@ 
             $oExec = $WshShell->Run("cmd /C $cmd", 0, false);
 
             return $oExec == 0 ? true : false;
-        } else {
+        }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();
+	}
 }

Spacing +2 added lines, -2 removed lines

@@ -18,7 +18,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -29,7 +29,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

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();
+	}
 }

Spacing +15 added lines, -15 removed lines

@@ -19,10 +19,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -37,10 +37,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -62,7 +62,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -85,7 +85,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -98,7 +98,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -120,10 +120,10 @@ 
                 $query_2->execute();
 
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -139,10 +139,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -159,10 +159,10 @@ 
             $id = $data['id'];
             if ($stored_password === sha1($password)) {
                 return $id;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -176,7 +176,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -187,7 +187,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

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());
+		}
+	}
 }

Spacing +8 added lines, -8 removed lines

@@ -19,10 +19,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -47,7 +47,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -73,7 +73,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -86,7 +86,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -100,7 +100,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -111,7 +111,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -127,7 +127,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }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();
+	}
 }

Spacing +7 added lines, -7 removed lines

@@ -19,10 +19,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -39,7 +39,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -56,7 +56,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -69,7 +69,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -83,7 +83,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -94,7 +94,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

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']);