aepnat / simhelpdesk

myticketbyrequester.php

Indentation +12 added lines, -12 removed lines

@@ -50,18 +50,18 @@
     </thead>

     <tbody>

 		<?php 

-        foreach ($tickets as $ticket) {

-            $sla = $slas->sla_data($ticket['sla']);

-            $user = $users->userdata($ticket['assignee']);

-            echo '<tr><td><a href=ticketedituser.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'.

-                 '<td>'.$sla['namasla'].'</td>'.

-                 '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.

-                 '<td>'.$ticket['reportedby'].'</td>'.

-                 '<td>'.$ticket['problemsummary'].'</td>'.

-                 '<td>'.$ticket['ticketstatus'].'</td>'.

-                 '<td>'.$user['fullname'].'</td></tr>';

-        }

-        ?>

+		foreach ($tickets as $ticket) {

+			$sla = $slas->sla_data($ticket['sla']);

+			$user = $users->userdata($ticket['assignee']);

+			echo '<tr><td><a href=ticketedituser.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'.

+				 '<td>'.$sla['namasla'].'</td>'.

+				 '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.

+				 '<td>'.$ticket['reportedby'].'</td>'.

+				 '<td>'.$ticket['problemsummary'].'</td>'.

+				 '<td>'.$ticket['ticketstatus'].'</td>'.

+				 '<td>'.$user['fullname'].'</td></tr>';

+		}

+		?>

     </tbody>

 	</table>

 	<p>&nbsp;</p>

ticketlist.php

Indentation +32 added lines, -32 removed lines

@@ -3,12 +3,12 @@ 
 $general->logged_out_protect();

 $user = $users->userdata($_SESSION['loginid']);

 if ($user['level'] == 'Admin' || $user['level'] == 'Manager') {

-    $akses = true;

+	$akses = true;

 } else {

-    $akses = false;

+	$akses = false;

 }

 if ($akses = false) {

-    exit("You don't have permission to access this page!");

+	exit("You don't have permission to access this page!");

 }

 $ticket_list = $tickets->get_tickets();

 $tickets_count = count($ticket_list);

@@ -70,35 +70,35 @@ 
     </thead>

     <tbody>

 		<?php 

-        foreach ($ticket_list as $ticket) {

-            $sla = $slas->sla_data($ticket['sla']);

-            $documenteddate = $ticket['documenteddate'];

-            $resolutiontime = $sla['resolutiontime'];

-            $slawarning = $sla['slawarning'];

-            $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate);

-            $slawarningtime = strtotime("+$slawarning hours", $documenteddate);

-            if ($currenttime > $slagoaltime) {

-                $slabgcolor = '#FF0000';

-                $slatxtcolor = '#ffffff';

-            } elseif ($currenttime >= $slawarningtime) {

-                $slabgcolor = '#FFFF00';

-                $slatxtcolor = '#000000';

-            } else {

-                $slabgcolor = '#00FF00';

-                $slatxtcolor = '#000000';

-            }

-            $user = $users->userdata($ticket['assignee']);

-            echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'.

-                 '<td style="background-color:'.$slabgcolor.';color:'.$slatxtcolor.';">'.$sla['namasla'].'</td>'.

-                 '<td>'.date('d-M-Y H:i:s', $slagoaltime).'</td>'.

-                 '<td>'.date('d-M-Y H:i:s', $ticket['reporteddate']).'</td>'.

-                 '<td>'.date('d-M-Y H:i:s', $ticket['documenteddate']).'</td>'.

-                 '<td>'.$ticket['problemsummary'].'</td>'.

-                 '<td>'.$ticket['ticketstatus'].'</td>'.

-                 '<td>'.$user['fullname'].'</td>'.

-                 '<td><a href=ticketdel.php?id='.$ticket['id'].' onclick="return delete_confirm();">del</a></td></tr>';

-        }

-        ?>

+		foreach ($ticket_list as $ticket) {

+			$sla = $slas->sla_data($ticket['sla']);

+			$documenteddate = $ticket['documenteddate'];

+			$resolutiontime = $sla['resolutiontime'];

+			$slawarning = $sla['slawarning'];

+			$slagoaltime = strtotime("+$resolutiontime hours", $documenteddate);

+			$slawarningtime = strtotime("+$slawarning hours", $documenteddate);

+			if ($currenttime > $slagoaltime) {

+				$slabgcolor = '#FF0000';

+				$slatxtcolor = '#ffffff';

+			} elseif ($currenttime >= $slawarningtime) {

+				$slabgcolor = '#FFFF00';

+				$slatxtcolor = '#000000';

+			} else {

+				$slabgcolor = '#00FF00';

+				$slatxtcolor = '#000000';

+			}

+			$user = $users->userdata($ticket['assignee']);

+			echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'.

+				 '<td style="background-color:'.$slabgcolor.';color:'.$slatxtcolor.';">'.$sla['namasla'].'</td>'.

+				 '<td>'.date('d-M-Y H:i:s', $slagoaltime).'</td>'.

+				 '<td>'.date('d-M-Y H:i:s', $ticket['reporteddate']).'</td>'.

+				 '<td>'.date('d-M-Y H:i:s', $ticket['documenteddate']).'</td>'.

+				 '<td>'.$ticket['problemsummary'].'</td>'.

+				 '<td>'.$ticket['ticketstatus'].'</td>'.

+				 '<td>'.$user['fullname'].'</td>'.

+				 '<td><a href=ticketdel.php?id='.$ticket['id'].' onclick="return delete_confirm();">del</a></td></tr>';

+		}

+		?>

     </tbody>

 	</table>

 	<p>&nbsp;</p>

core/classes/Tickets.php

Indentation +317 added lines, -317 removed lines

@@ -3,276 +3,276 @@ 
 date_default_timezone_set('Asia/Jakarta');
 class Tickets
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    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, $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_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 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, $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_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";
@@ -286,51 +286,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();
+	}
 }

core/init.php

Indentation +7 added lines, -7 removed lines

@@ -5,16 +5,16 @@
 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);
-    $tickets = new Tickets($db);
-    $slas = new SLA($db);
+	$general = new General();
+	$users = new Users($db);
+	$tickets = new Tickets($db);
+	$slas = new SLA($db);
 } catch (Exception $e) {
-    echo 'Caught exception: ',  $e->getMessage(), "\n";
+	echo 'Caught exception: ',  $e->getMessage(), "\n";
 }

statistic/chart.php

Indentation +10 added lines, -10 removed lines

@@ -7,20 +7,20 @@ 
 $ticket_list = array();

 $i = 0; $color[0] = 'FF0000'; $color[1] = '00FF00'; $color[2] = 'FFFF00'; $color[3] = '0000FF'; $color[4] = 'FF00FF';

 foreach ($ticket_list as $ticket) {

-    @$value .= $ticket['total'].'#';

-    @$name .= '#';

-    //echo $value[i].'<br>'.$name[i].'<br>';

-    //$color[$i++];

+	@$value .= $ticket['total'].'#';

+	@$name .= '#';

+	//echo $value[i].'<br>'.$name[i].'<br>';

+	//$color[$i++];

 }

 $arr_value = explode('#', $value);

 $arr_name = explode('#', $name);

 //echo $arr_name[0].$arr_name[1].$arr_name[2].$arr_name[3].$arr_name[4];

 $ticket_list2 = $tickets->count_tickets_by_status();

 foreach ($ticket_list2 as $ticket2) {

-    @$value2 .= $ticket2['total'].'#';

-    @$name2 .= $ticket2['ticketstatus'].'#';

-    //echo $value[i].'<br>'.$name[i].'<br>';

-    //$color[$i++];

+	@$value2 .= $ticket2['total'].'#';

+	@$name2 .= $ticket2['ticketstatus'].'#';

+	//echo $value[i].'<br>'.$name[i].'<br>';

+	//$color[$i++];

 }

 $arr_value2 = explode('#', $value2);

 $arr_name2 = explode('#', $name2);

@@ -28,12 +28,12 @@ 
 $ResolvedBulan = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];

 $ticket_list3 = $tickets->count_resolved_tickets_by_month();

 foreach ($ticket_list3 as $ticket3) {

-    @$ResolvedBulan[$ticket3['Bulan']] = $ticket3['Total'];

+	@$ResolvedBulan[$ticket3['Bulan']] = $ticket3['Total'];

 }

 $InProgressBulan = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];

 $ticket_list4 = $tickets->count_inprogress_tickets_by_month();

 foreach ($ticket_list4 as $ticket4) {

-    @$InProgressBulan[$ticket4['Bulan']] = $ticket4['Total'];

+	@$InProgressBulan[$ticket4['Bulan']] = $ticket4['Total'];

 }

 ?>

 <!DOCTYPE html>

content.php

Indentation +1 added lines, -1 removed lines

@@ -34,7 +34,7 @@
 			echo "<li><p>Jumlah tiket yang ditugaskan untuk Anda: $tickets_assigned tickets.</p></li> ";
 			echo "<li><p>Anda telah menyelesaikan $tickets_resolved tickets.</p></li>";
 		}
-        ?>
+		?>
 		</ol><br/>
 		</td>
 	</tr>

myticketwaitforclosed.php

Indentation +12 added lines, -12 removed lines

@@ -50,18 +50,18 @@
     </thead>

     <tbody>

 		<?php 

-        foreach ($tickets as $ticket) {

-            $sla = $slas->sla_data($ticket['sla']);

-            $user = $users->userdata($ticket['assignee']);

-            echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'.

-                 '<td>'.$sla['namasla'].'</td>'.

-                 '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.

-                 '<td>'.$ticket['reportedby'].'</td>'.

-                 '<td>'.$ticket['problemsummary'].'</td>'.

-                 '<td>'.$ticket['ticketstatus'].'</td>'.

-                 '<td>'.$user['fullname'].'</td></tr>';

-        }

-        ?>

+		foreach ($tickets as $ticket) {

+			$sla = $slas->sla_data($ticket['sla']);

+			$user = $users->userdata($ticket['assignee']);

+			echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'.

+				 '<td>'.$sla['namasla'].'</td>'.

+				 '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.

+				 '<td>'.$ticket['reportedby'].'</td>'.

+				 '<td>'.$ticket['problemsummary'].'</td>'.

+				 '<td>'.$ticket['ticketstatus'].'</td>'.

+				 '<td>'.$user['fullname'].'</td></tr>';

+		}

+		?>

     </tbody>

 	</table>

 	<p>&nbsp;</p>

ticketedit.php

Indentation +67 added lines, -67 removed lines

@@ -6,50 +6,50 @@ 
 $id = $_GET['id'];

 $ticket = $tickets->ticket_data($id);

 if ($ticket['ticketstatus'] == 'Closed') {

-    header("Location: ticketread.php?id=$id");

-    exit();

+	header("Location: ticketread.php?id=$id");

+	exit();

 }

 if (isset($_POST['submit'])) {

-    $sla = $_POST['sla'];

-    $reporteddate = strtotime($_POST['reporteddate']);

-    $reportedby = $_POST['reportedby'];

-    $telp = $_POST['telp'];

-    $email = $_POST['email'];

-    $problemsummary = $_POST['problemsummary'];

-    $problemdetail = $_POST['problemdetail'];

-    $assignee = $_POST['idassignee'];

-    $type = $_POST['pro'];

-    $ticketstatus = $_POST['ticketstatus'];

-    $resolution = $_POST['resolution'];

-    $pendingby = $_POST['pendingby'];

-    $pendingdate = $_POST['pendingdate'];

-    $resolvedby = $_POST['resolvedby'];

-    $resolveddate = $_POST['resolveddate'];

-    $closedby = $_POST['closedby'];

-    $closeddate = $_POST['closeddate'];

-    $changes = 'Re-assigned the ticket.';

-    if ($ticketstatus == 'Pending') {

-        $pendingby = $user['username'];

-        $pendingdate = strtotime(now);

-        $changes = 'Change Status to Pending.';

-    }

-    if ($ticketstatus == 'Resolved') {

-        $resolvedby = $user['username'];

-        $resolveddate = strtotime(now);

-        $changes = 'Change Status to Resolved.';

-    }

-    if ($ticketstatus == 'Closed') {

-        $closedby = $user['username'];

-        $closeddate = strtotime(now);

-        $changes = 'Change Status to Closed.';

-    }

-    $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate);

-    $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby);

-    if ($user['level'] == 'Admin') {

-        header('Location: ticketlist.php');

-    } else {

-        header('Location: myticketbyassignee.php');

-    }

+	$sla = $_POST['sla'];

+	$reporteddate = strtotime($_POST['reporteddate']);

+	$reportedby = $_POST['reportedby'];

+	$telp = $_POST['telp'];

+	$email = $_POST['email'];

+	$problemsummary = $_POST['problemsummary'];

+	$problemdetail = $_POST['problemdetail'];

+	$assignee = $_POST['idassignee'];

+	$type = $_POST['pro'];

+	$ticketstatus = $_POST['ticketstatus'];

+	$resolution = $_POST['resolution'];

+	$pendingby = $_POST['pendingby'];

+	$pendingdate = $_POST['pendingdate'];

+	$resolvedby = $_POST['resolvedby'];

+	$resolveddate = $_POST['resolveddate'];

+	$closedby = $_POST['closedby'];

+	$closeddate = $_POST['closeddate'];

+	$changes = 'Re-assigned the ticket.';

+	if ($ticketstatus == 'Pending') {

+		$pendingby = $user['username'];

+		$pendingdate = strtotime(now);

+		$changes = 'Change Status to Pending.';

+	}

+	if ($ticketstatus == 'Resolved') {

+		$resolvedby = $user['username'];

+		$resolveddate = strtotime(now);

+		$changes = 'Change Status to Resolved.';

+	}

+	if ($ticketstatus == 'Closed') {

+		$closedby = $user['username'];

+		$closeddate = strtotime(now);

+		$changes = 'Change Status to Closed.';

+	}

+	$tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate);

+	$tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby);

+	if ($user['level'] == 'Admin') {

+		header('Location: ticketlist.php');

+	} else {

+		header('Location: myticketbyassignee.php');

+	}

 }

 ?>

 <!DOCTYPE HTML>

@@ -141,13 +141,13 @@ 
 			<td> Urgency (SLA)*</td><td> : </td>

 			<td><select name="sla">

 				<?php 

-                    $sladata = $slas->sla_data($ticket['sla']);

-                    echo '<option value="'.$ticket['sla'].'" selected="selected">'.$sladata['namasla'].'</option>';

-                    $sla = $slas->get_sla();

-                    foreach ($sla as $slaval) {

-                        echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>';

-                    }

-                ?>

+					$sladata = $slas->sla_data($ticket['sla']);

+					echo '<option value="'.$ticket['sla'].'" selected="selected">'.$sladata['namasla'].'</option>';

+					$sla = $slas->get_sla();

+					foreach ($sla as $slaval) {

+						echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>';

+					}

+				?>

 				</select>

 			</td>

 		</tr>

@@ -155,10 +155,10 @@ 
 			<td> Type</td><td> : </td>

 			<td>

 				<?php 

-                    //$pro = $slas->get_sla();

-                    echo $ticket['pro'];

+					//$pro = $slas->get_sla();

+					echo $ticket['pro'];

 

-                ?>

+				?>

 				

 			</td>

 		</tr>

@@ -178,13 +178,13 @@ 
 			<td width="120"> Assign to* </td><td> : </td>

 			<td> <select name="idassignee">

 			<?php

-                $userassignee = $users->userdata($ticket['assignee']);

-                echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>';

-                $listusers = $users->get_users();

-                foreach ($listusers as $user) {

-                    echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>';

-                }

-            ?>

+				$userassignee = $users->userdata($ticket['assignee']);

+				echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>';

+				$listusers = $users->get_users();

+				foreach ($listusers as $user) {

+					echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>';

+				}

+			?>

 			</select> </td>

 		</tr>

 		<tr>

@@ -229,14 +229,14 @@ 
 	<table class="formtable">

 	<tr bgcolor="#e0e0e0" ><td width="150">Updated On</td><td width="150">Updated By</td><td>Description</td></tr>

 	<?php

-        $list_log_tickets = $tickets->get_audit_trail($id);

-        foreach ($list_log_tickets as $log_ticket) {

-            $changed_by = $users->userdata($log_ticket['changeby']);

-            echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.

-                 '<td>'.$changed_by['fullname'].'</td>'.

-                 '<td>'.$log_ticket['changes'].'</td></tr>';

-        }

-    ?>

+		$list_log_tickets = $tickets->get_audit_trail($id);

+		foreach ($list_log_tickets as $log_ticket) {

+			$changed_by = $users->userdata($log_ticket['changeby']);

+			echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.

+				 '<td>'.$changed_by['fullname'].'</td>'.

+				 '<td>'.$log_ticket['changes'].'</td></tr>';

+		}

+	?>

 	</table>

 	</fieldset>

 	<br/><br/>