aepnat / simhelpdesk

ticketedituser.php

Indentation +53 added lines, -53 removed lines

@@ -6,58 +6,58 @@ 
 $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 = $_POST['reporteddate'];

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

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

-    $datetimeStr = $reportedyear.'-'.$reportedmonth.'-'.$reporteddate;

-    $reporteddate = strtotime($datetimeStr);

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

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

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

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

+	$datetimeStr = $reportedyear.'-'.$reportedmonth.'-'.$reporteddate;

+	$reporteddate = strtotime($datetimeStr);

 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+	$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 == 'Process') {

 		$processby = $user['username'];

 		$processdate = strtotime(now);

 		$changes = 'Change Status to Process';

 	}

-    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, $processby, $processdate, $comment);

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

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

+	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, $processby, $processdate, $comment);

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

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

 }

 ?>

 <!DOCTYPE HTML>

@@ -146,8 +146,8 @@ 
 			<td> <input type="hidden" name="oldticketstatus" value="<?php echo $ticket['ticketstatus']; ?>"> 

 			<select name="ticketstatus">

 				<?php

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

-                ?>

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

+				?>

 				<option value="Assigned"> Assigned </option>

 				<option value="Resolved"> Resolved </option>

 				<option value="Pending"> Pending </option>

@@ -189,14 +189,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/>

Spacing +2 added lines, -2 removed lines

@@ -157,11 +157,11 @@
 		</tr>

 		<tr valign="top">

 			<td> Resolution* </td><td> : </td>

-			<td> <textarea name="resolution" rows="3" cols="38" <?php echo ($user['level'] == 'User') ? 'readonly="readonly"' : '';?>><?php echo $ticket['resolution']; ?></textarea> </td>

+			<td> <textarea name="resolution" rows="3" cols="38" <?php echo ($user['level'] == 'User') ? 'readonly="readonly"' : ''; ?>><?php echo $ticket['resolution']; ?></textarea> </td>

 		</tr>

 		<tr valign="top">

 			<td> Comment* </td><td> : </td>

-			<td> <textarea name="comment" rows="3" cols="38" <?php echo ($user['level'] != 'User') ? 'readonly="readonly"' : '';?>><?php echo $ticket['comment']; ?></textarea> </td>

+			<td> <textarea name="comment" rows="3" cols="38" <?php echo ($user['level'] != 'User') ? 'readonly="readonly"' : ''; ?>><?php echo $ticket['comment']; ?></textarea> </td>

 		</tr>

 		<tr>

 			<td> </td><td> </td>

ticketedit.php

Indentation +69 added lines, -69 removed lines

@@ -6,58 +6,58 @@ 
 $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'];

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

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

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

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

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

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

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

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

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

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

+	$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'];

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

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

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

+	$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 == 'Process') {

 		$processby = $user['username'];

 		$processdate = strtotime(now);

 		$changes = 'Change Status to Process';

 	}

 	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, $processby, $processdate, $comment);

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

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

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

-    } else {

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

-    }

+		$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, $processby, $processdate, $comment);

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

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

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

+	} else {

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

+	}

 }

 ?>

 <!DOCTYPE HTML>

@@ -142,13 +142,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>

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

 			<td>

 				<?php 

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

-                    echo $ticket['pro'];

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

+					echo $ticket['pro'];

 

-                ?>

+				?>

 				

 			</td>

 		</tr>

@@ -179,13 +179,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>

@@ -234,14 +234,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/>

Spacing +8 added lines, -8 removed lines

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

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

         header('Location: ticketlist.php');

-    } else {

+    }else {

         header('Location: myticketbyassignee.php');

     }

 }

@@ -192,21 +192,21 @@ 
 			<td> Status* </td><td> : </td>

 			<td> <input type="hidden" name="oldticketstatus" value="<?php echo $ticket['ticketstatus']; ?>"> 

 			<select name="ticketstatus">

-				<option value="Assigned" <?php echo ($ticket['ticketstatus'] == 'Assigned') ? 'selected="selected"' : '';?>>Assigned</option>

-				<option value="Process" <?php echo ($ticket['ticketstatus'] == 'Process') ? 'selected="selected"' : '';?>>Process</option>

-				<option value="Resolved" <?php echo ($ticket['ticketstatus'] == 'Resolved') ? 'selected="selected"' : '';?>>Resolved</option>

-				<option value="Pending" <?php echo ($ticket['ticketstatus'] == 'Pending') ? 'selected="selected"' : '';?>>Pending</option>

-				<option value="Closed" <?php echo ($ticket['ticketstatus'] == 'Closed') ? 'selected="selected"' : '';?>>Closed</option>

+				<option value="Assigned" <?php echo ($ticket['ticketstatus'] == 'Assigned') ? 'selected="selected"' : ''; ?>>Assigned</option>

+				<option value="Process" <?php echo ($ticket['ticketstatus'] == 'Process') ? 'selected="selected"' : ''; ?>>Process</option>

+				<option value="Resolved" <?php echo ($ticket['ticketstatus'] == 'Resolved') ? 'selected="selected"' : ''; ?>>Resolved</option>

+				<option value="Pending" <?php echo ($ticket['ticketstatus'] == 'Pending') ? 'selected="selected"' : ''; ?>>Pending</option>

+				<option value="Closed" <?php echo ($ticket['ticketstatus'] == 'Closed') ? 'selected="selected"' : ''; ?>>Closed</option>

 			</select> 

 			</td>

 		</tr>

 		<tr valign="top">

 			<td> Resolution* </td><td> : </td>

-			<td> <textarea name="resolution" rows="3" cols="38" <?php echo ($user['level'] == 'User') ? 'readonly="readonly"' : '';?>><?php echo $ticket['resolution']; ?></textarea> </td>

+			<td> <textarea name="resolution" rows="3" cols="38" <?php echo ($user['level'] == 'User') ? 'readonly="readonly"' : ''; ?>><?php echo $ticket['resolution']; ?></textarea> </td>

 		</tr>

 		<tr valign="top">

 			<td> Comment* </td><td> : </td>

-			<td> <textarea name="comment" rows="3" cols="38" <?php echo ($user['level'] != 'User') ? 'readonly="readonly"' : '';?>><?php echo $ticket['comment']; ?></textarea> </td>

+			<td> <textarea name="comment" rows="3" cols="38" <?php echo ($user['level'] != 'User') ? 'readonly="readonly"' : ''; ?>><?php echo $ticket['comment']; ?></textarea> </td>

 		</tr>

 		<tr>

 			<td> </td><td> </td>

core/classes/Tickets.php

Indentation +323 added lines, -323 removed lines

@@ -3,279 +3,279 @@ 
 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, $processby, $processdate, $comment)
-    {
-        $querystring = 'UPDATE `tickets` SET `sla` = ? , `reporteddate` = ? , `reportedby` = ? , `telp` = ? ,`email` = ? , `problemsummary` = ? , `problemdetail` = ? ,`ticketstatus` = ?, `assignee` = ? , `assigneddate` = ?, `pendingby` = ?,`pendingdate` = ?, `resolution` = ? ,`resolvedby` = ?,`resolveddate` = ?,`closedby` = ?,`closeddate` = ?, `processby` = ?, `processdate` = ?, `comment` = ? 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, $processby);
-        $query->bindValue(19, $processdate);
-        $query->bindValue(20, $comment);
-        $query->bindValue(21, $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, $processby, $processdate, $comment)
+	{
+		$querystring = 'UPDATE `tickets` SET `sla` = ? , `reporteddate` = ? , `reportedby` = ? , `telp` = ? ,`email` = ? , `problemsummary` = ? , `problemdetail` = ? ,`ticketstatus` = ?, `assignee` = ? , `assigneddate` = ?, `pendingby` = ?,`pendingdate` = ?, `resolution` = ? ,`resolvedby` = ?,`resolveddate` = ?,`closedby` = ?,`closeddate` = ?, `processby` = ?, `processdate` = ?, `comment` = ? 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, $processby);
+		$query->bindValue(19, $processdate);
+		$query->bindValue(20, $comment);
+		$query->bindValue(21, $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";
@@ -289,54 +289,54 @@ 
             }
         }*/
 
-    public function log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby, $processby, $processdate, $comment)
-    {
-        $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`,`processby`,`processdate`,`comment`) 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);
-        $query->bindValue(22, $processby);
-        $query->bindValue(23, $processdate);
-        $query->bindValue(24, $comment);
-
-        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, $processby, $processdate, $comment)
+	{
+		$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`,`processby`,`processdate`,`comment`) 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);
+		$query->bindValue(22, $processby);
+		$query->bindValue(23, $processdate);
+		$query->bindValue(24, $comment);
+
+		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();
+	}
 }