aepnat / simhelpdesk

statistic/pdftable/font/vni_timesbi.php

Indentation +12 added lines, -12 removed lines

@@ -6,18 +6,18 @@
 $up = -100;
 $ut = 50;
 $cw = [
-    chr(0)  => 792, chr(1)=>792, chr(2)=>792, chr(3)=>792, chr(4)=>792, chr(5)=>792, chr(6)=>792, chr(7)=>792, chr(8)=>792, chr(9)=>792, chr(10)=>792, chr(11)=>792, chr(12)=>792, chr(13)=>792, chr(14)=>792, chr(15)=>792, chr(16)=>792, chr(17)=>792, chr(18)=>792, chr(19)=>792, chr(20)=>792, chr(21)=>792,
-    chr(22) => 792, chr(23)=>792, chr(24)=>792, chr(25)=>792, chr(26)=>792, chr(27)=>792, chr(28)=>792, chr(29)=>792, chr(30)=>792, chr(31)=>792, ' '=>250, '!'=>398, '"'=>566, '#'=>504, '$'=>504, '%'=>838, '&'=>786, '\''=>284, '('=>336, ')'=>336, '*'=>504, '+'=>576,
-    ','     => 252, '-'=>336, '.'=>252, '/'=>284, '0'=>504, '1'=>504, '2'=>504, '3'=>504, '4'=>504, '5'=>504, '6'=>504, '7'=>504, '8'=>504, '9'=>504, ':'=>336, ';'=>336, '<'=>576, '='=>576, '>'=>576, '?'=>504, '@'=>838, 'A'=>654,
-    'B'     => 670, 'C'=>670, 'D'=>724, 'E'=>670, 'F'=>670, 'G'=>724, 'H'=>786, 'I'=>398, 'J'=>504, 'K'=>670, 'L'=>618, 'M'=>902, 'N'=>724, 'O'=>724, 'P'=>618, 'Q'=>724, 'R'=>670, 'S'=>566, 'T'=>618, 'U'=>724, 'V'=>670, 'W'=>902,
-    'X'     => 670, 'Y'=>670, 'Z'=>618, '['=>336, '\\'=>284, ']'=>336, '^'=>576, '_'=>504, '`'=>336, 'a'=>504, 'b'=>504, 'c'=>452, 'd'=>504, 'e'=>429, 'f'=>336, 'g'=>504, 'h'=>566, 'i'=>284, 'j'=>284, 'k'=>504, 'l'=>284, 'm'=>786,
-    'n'     => 566, 'o'=>480, 'p'=>504, 'q'=>504, 'r'=>398, 's'=>398, 't'=>284, 'u'=>524, 'v'=>452, 'w'=>670, 'x'=>504, 'y'=>417, 'z'=>398, '{'=>356, '|'=>232, '}'=>356, '~'=>576, chr(127)=>792, chr(128)=>792, chr(129)=>792, chr(130)=>944, chr(131)=>508,
-    chr(132)=> 722, chr(133)=>670, chr(134)=>430, chr(135)=>430, chr(136)=>250, chr(137)=>1226, chr(138)=>40, chr(139)=>316, chr(140)=>40, chr(141)=>792, chr(142)=>792, chr(143)=>792, chr(144)=>792, chr(145)=>336, chr(146)=>336, chr(147)=>525, chr(148)=>648, chr(149)=>250, chr(150)=>576, chr(151)=>1100, chr(152)=>250, chr(153)=>980,
-    chr(154)=> 40, chr(155)=>316, chr(156)=>40, chr(157)=>792, chr(158)=>792, chr(159)=>670, chr(160)=>250, chr(161)=>389, chr(162)=>504, chr(163)=>504, chr(164)=>504, chr(165)=>504, chr(166)=>232, chr(167)=>504, chr(168)=>40, chr(169)=>754, chr(170)=>624, chr(171)=>504, chr(172)=>944, chr(173)=>336, chr(174)=>754, chr(175)=>336,
-    chr(176)=> 882, chr(177)=>576, chr(178)=>304, chr(179)=>304, chr(180)=>40, chr(181)=>588, chr(182)=>500, chr(183)=>40, chr(184)=>40, chr(185)=>304, chr(186)=>664, chr(187)=>504, chr(188)=>754, chr(189)=>754, chr(190)=>754, chr(191)=>500, chr(192)=>40, chr(193)=>40, chr(194)=>40, chr(195)=>40, chr(196)=>40, chr(197)=>40,
-    chr(198)=> 398, chr(199)=>670, chr(200)=>40, chr(201)=>40, chr(202)=>40, chr(203)=>40, chr(204)=>398, chr(205)=>398, chr(206)=>670, chr(207)=>40, chr(208)=>398, chr(209)=>724, chr(210)=>398, chr(211)=>398, chr(212)=>724, chr(213)=>40, chr(214)=>724, chr(215)=>576, chr(216)=>40, chr(217)=>40, chr(218)=>40, chr(219)=>40,
-    chr(220)=> 40, chr(221)=>398, chr(222)=>722, chr(223)=>500, chr(224)=>40, chr(225)=>40, chr(226)=>40, chr(227)=>40, chr(228)=>40, chr(229)=>40, chr(230)=>284, chr(231)=>452, chr(232)=>40, chr(233)=>40, chr(234)=>40, chr(235)=>40, chr(236)=>284, chr(237)=>284, chr(238)=>452, chr(239)=>40, chr(240)=>284, chr(241)=>504,
-    chr(242)=> 284, chr(243)=>284, chr(244)=>474, chr(245)=>40, chr(246)=>519, chr(247)=>576, chr(248)=>40, chr(249)=>40, chr(250)=>40, chr(251)=>40, chr(252)=>40, chr(253)=>284, chr(254)=>500, chr(255)=>452, ];
+	chr(0)  => 792, chr(1)=>792, chr(2)=>792, chr(3)=>792, chr(4)=>792, chr(5)=>792, chr(6)=>792, chr(7)=>792, chr(8)=>792, chr(9)=>792, chr(10)=>792, chr(11)=>792, chr(12)=>792, chr(13)=>792, chr(14)=>792, chr(15)=>792, chr(16)=>792, chr(17)=>792, chr(18)=>792, chr(19)=>792, chr(20)=>792, chr(21)=>792,
+	chr(22) => 792, chr(23)=>792, chr(24)=>792, chr(25)=>792, chr(26)=>792, chr(27)=>792, chr(28)=>792, chr(29)=>792, chr(30)=>792, chr(31)=>792, ' '=>250, '!'=>398, '"'=>566, '#'=>504, '$'=>504, '%'=>838, '&'=>786, '\''=>284, '('=>336, ')'=>336, '*'=>504, '+'=>576,
+	','     => 252, '-'=>336, '.'=>252, '/'=>284, '0'=>504, '1'=>504, '2'=>504, '3'=>504, '4'=>504, '5'=>504, '6'=>504, '7'=>504, '8'=>504, '9'=>504, ':'=>336, ';'=>336, '<'=>576, '='=>576, '>'=>576, '?'=>504, '@'=>838, 'A'=>654,
+	'B'     => 670, 'C'=>670, 'D'=>724, 'E'=>670, 'F'=>670, 'G'=>724, 'H'=>786, 'I'=>398, 'J'=>504, 'K'=>670, 'L'=>618, 'M'=>902, 'N'=>724, 'O'=>724, 'P'=>618, 'Q'=>724, 'R'=>670, 'S'=>566, 'T'=>618, 'U'=>724, 'V'=>670, 'W'=>902,
+	'X'     => 670, 'Y'=>670, 'Z'=>618, '['=>336, '\\'=>284, ']'=>336, '^'=>576, '_'=>504, '`'=>336, 'a'=>504, 'b'=>504, 'c'=>452, 'd'=>504, 'e'=>429, 'f'=>336, 'g'=>504, 'h'=>566, 'i'=>284, 'j'=>284, 'k'=>504, 'l'=>284, 'm'=>786,
+	'n'     => 566, 'o'=>480, 'p'=>504, 'q'=>504, 'r'=>398, 's'=>398, 't'=>284, 'u'=>524, 'v'=>452, 'w'=>670, 'x'=>504, 'y'=>417, 'z'=>398, '{'=>356, '|'=>232, '}'=>356, '~'=>576, chr(127)=>792, chr(128)=>792, chr(129)=>792, chr(130)=>944, chr(131)=>508,
+	chr(132)=> 722, chr(133)=>670, chr(134)=>430, chr(135)=>430, chr(136)=>250, chr(137)=>1226, chr(138)=>40, chr(139)=>316, chr(140)=>40, chr(141)=>792, chr(142)=>792, chr(143)=>792, chr(144)=>792, chr(145)=>336, chr(146)=>336, chr(147)=>525, chr(148)=>648, chr(149)=>250, chr(150)=>576, chr(151)=>1100, chr(152)=>250, chr(153)=>980,
+	chr(154)=> 40, chr(155)=>316, chr(156)=>40, chr(157)=>792, chr(158)=>792, chr(159)=>670, chr(160)=>250, chr(161)=>389, chr(162)=>504, chr(163)=>504, chr(164)=>504, chr(165)=>504, chr(166)=>232, chr(167)=>504, chr(168)=>40, chr(169)=>754, chr(170)=>624, chr(171)=>504, chr(172)=>944, chr(173)=>336, chr(174)=>754, chr(175)=>336,
+	chr(176)=> 882, chr(177)=>576, chr(178)=>304, chr(179)=>304, chr(180)=>40, chr(181)=>588, chr(182)=>500, chr(183)=>40, chr(184)=>40, chr(185)=>304, chr(186)=>664, chr(187)=>504, chr(188)=>754, chr(189)=>754, chr(190)=>754, chr(191)=>500, chr(192)=>40, chr(193)=>40, chr(194)=>40, chr(195)=>40, chr(196)=>40, chr(197)=>40,
+	chr(198)=> 398, chr(199)=>670, chr(200)=>40, chr(201)=>40, chr(202)=>40, chr(203)=>40, chr(204)=>398, chr(205)=>398, chr(206)=>670, chr(207)=>40, chr(208)=>398, chr(209)=>724, chr(210)=>398, chr(211)=>398, chr(212)=>724, chr(213)=>40, chr(214)=>724, chr(215)=>576, chr(216)=>40, chr(217)=>40, chr(218)=>40, chr(219)=>40,
+	chr(220)=> 40, chr(221)=>398, chr(222)=>722, chr(223)=>500, chr(224)=>40, chr(225)=>40, chr(226)=>40, chr(227)=>40, chr(228)=>40, chr(229)=>40, chr(230)=>284, chr(231)=>452, chr(232)=>40, chr(233)=>40, chr(234)=>40, chr(235)=>40, chr(236)=>284, chr(237)=>284, chr(238)=>452, chr(239)=>40, chr(240)=>284, chr(241)=>504,
+	chr(242)=> 284, chr(243)=>284, chr(244)=>474, chr(245)=>40, chr(246)=>519, chr(247)=>576, chr(248)=>40, chr(249)=>40, chr(250)=>40, chr(251)=>40, chr(252)=>40, chr(253)=>284, chr(254)=>500, chr(255)=>452, ];
 $enc = 'cp1252';
 $diff = '';
 $file = 'vni_timesbi.z';

ticketedituser.php

Indentation +51 added lines, -51 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 = $_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'];

-    $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);

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

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

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

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

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

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

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

+	$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);

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

 }

 ?>

 <!DOCTYPE HTML>

@@ -136,8 +136,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>

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

ticketread.php

Indentation +14 added lines, -14 removed lines

@@ -43,9 +43,9 @@ 
 			<td> Urgency (SLA)</td><td> : </td>

 			<td> 

 			<?php 

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

-                echo $sladata['namasla'];

-            ?>

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

+				echo $sladata['namasla'];

+			?>

 			</td>

 		</tr>

 		<tr>

@@ -63,9 +63,9 @@ 
 			<td width="120"> Assign to </td><td> : </td>

 			<td> 

 			<?php

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

-                echo $userassignee['fullname'];

-            ?>

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

+				echo $userassignee['fullname'];

+			?>

 			</td>

 		</tr>

 		<tr>

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

navigator.php

Indentation +3 added lines, -3 removed lines

@@ -26,15 +26,15 @@
 </ul>

 </div>

 <?php

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

-        echo '<div id="leftmenu">

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

+		echo '<div id="leftmenu">

 				<div id="headleftmenu">Helpdesk Statistic</div>

 					<ul>

 					<li><a href="pivot/hdpivot.php" target="contentFrame">Pivot Table</a></li>

 					<li><a href="statistic/chart.php" target="contentFrame">SLA Chart</a></li>

 					</ul>

 			 </div>';

-    }

+	}

 ?>

 </body>

 </html>

core/classes/Users.php

Indentation +284 added lines, -284 removed lines

@@ -2,288 +2,288 @@
 
 class Users
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function user_exists($username)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `users` WHERE `username`= ?');
-        $query->bindValue(1, $username);
-
-        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 `users` 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 register($username, $password, $email, $fullname, $Telp, $level, $locked)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $email_code = sha1($username + microtime());
-        $password = sha1($password);
-        $query = $this->db->prepare('INSERT INTO `users` (`username`,`level`, `password`, `fullname`, `email`, `Telp`,`ip`, `time`, `email_code`, `confirmed`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,?)');
-        $query->bindValue(1, $username);
-        $query->bindValue(2, $level);
-        $query->bindValue(3, $password);
-        $query->bindValue(4, $fullname);
-        $query->bindValue(5, $email);
-        $query->bindValue(6, $Telp);
-        $query->bindValue(7, $ip);
-        $query->bindValue(8, $time);
-        $query->bindValue(9, $email_code);
-        $query->bindValue(10, 1);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update($id, $username, $password, $email, $fullname, $Telp, $level, $locked)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $email_code = sha1($username + microtime());
-        $password = sha1($password);
-        $query = $this->db->prepare('UPDATE `users` SET `level` = ? , `password` = ? , `fullname` = ? , `email` = ? , `Telp` = ? ,`ip` = ? , `time` = ? , `email_code` = ? ,`confirmed` = ? WHERE `id` = ?');
-        $query->bindValue(1, $level);
-        $query->bindValue(2, $password);
-        $query->bindValue(3, $fullname);
-        $query->bindValue(4, $email);
-        $query->bindValue(5, $Telp);
-        $query->bindValue(6, $ip);
-        $query->bindValue(7, $time);
-        $query->bindValue(8, $email_code);
-        $query->bindValue(9, $locked);
-        $query->bindValue(10, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function changepwd($id, $password)
-    {
-        $password = sha1($password);
-        $query = $this->db->prepare('UPDATE `users` SET `password` = ? WHERE `id` = ?');
-        $query->bindValue(1, $password);
-        $query->bindValue(2, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `users` WHERE `id` = ?';
-        $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 `users` 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 `users` 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 `users` 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($username, $password)
-    {
-        $query = $this->db->prepare('SELECT `password`, `id` FROM `users` WHERE `username` = ?');
-        $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 userdata($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `users` WHERE `id`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_user_by_id($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `users` WHERE `id`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_user_by_level($level)
-    {
-        $query = $this->db->prepare('SELECT * FROM `users` WHERE `level`= ?');
-        $query->bindValue(1, $level);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_user_random_by_level($level)
-    {
-        $query = $this->db->prepare('SELECT * FROM `users` WHERE `level`= ? ORDER BY RAND() LIMIT 1');
-        $query->bindValue(1, $level);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetch();
-    }
-
-    public function get_users()
-    {
-        $query = $this->db->prepare('SELECT * FROM `users` ORDER BY `time` DESC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function log_users($iduser, $log)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $browser = $_SERVER['HTTP_USER_AGENT'];
-        $query = $this->db->prepare('INSERT INTO `log_users` (`iduser`,`time`,`ip`,`browser`,`log`) VALUES (?, ?, ?, ?, ?)');
-        $query->bindValue(1, $iduser);
-        $query->bindValue(2, $time);
-        $query->bindValue(3, $ip);
-        $query->bindValue(4, $browser);
-        $query->bindValue(5, $log);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_users_log()
-    {
-        $query = $this->db->prepare('SELECT * FROM `log_users` ORDER BY `time` DESC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function user_exists($username)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `users` WHERE `username`= ?');
+		$query->bindValue(1, $username);
+
+		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 `users` 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 register($username, $password, $email, $fullname, $Telp, $level, $locked)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$email_code = sha1($username + microtime());
+		$password = sha1($password);
+		$query = $this->db->prepare('INSERT INTO `users` (`username`,`level`, `password`, `fullname`, `email`, `Telp`,`ip`, `time`, `email_code`, `confirmed`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,?)');
+		$query->bindValue(1, $username);
+		$query->bindValue(2, $level);
+		$query->bindValue(3, $password);
+		$query->bindValue(4, $fullname);
+		$query->bindValue(5, $email);
+		$query->bindValue(6, $Telp);
+		$query->bindValue(7, $ip);
+		$query->bindValue(8, $time);
+		$query->bindValue(9, $email_code);
+		$query->bindValue(10, 1);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update($id, $username, $password, $email, $fullname, $Telp, $level, $locked)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$email_code = sha1($username + microtime());
+		$password = sha1($password);
+		$query = $this->db->prepare('UPDATE `users` SET `level` = ? , `password` = ? , `fullname` = ? , `email` = ? , `Telp` = ? ,`ip` = ? , `time` = ? , `email_code` = ? ,`confirmed` = ? WHERE `id` = ?');
+		$query->bindValue(1, $level);
+		$query->bindValue(2, $password);
+		$query->bindValue(3, $fullname);
+		$query->bindValue(4, $email);
+		$query->bindValue(5, $Telp);
+		$query->bindValue(6, $ip);
+		$query->bindValue(7, $time);
+		$query->bindValue(8, $email_code);
+		$query->bindValue(9, $locked);
+		$query->bindValue(10, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function changepwd($id, $password)
+	{
+		$password = sha1($password);
+		$query = $this->db->prepare('UPDATE `users` SET `password` = ? WHERE `id` = ?');
+		$query->bindValue(1, $password);
+		$query->bindValue(2, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `users` WHERE `id` = ?';
+		$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 `users` 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 `users` 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 `users` 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($username, $password)
+	{
+		$query = $this->db->prepare('SELECT `password`, `id` FROM `users` WHERE `username` = ?');
+		$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 userdata($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `users` WHERE `id`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_user_by_id($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `users` WHERE `id`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_user_by_level($level)
+	{
+		$query = $this->db->prepare('SELECT * FROM `users` WHERE `level`= ?');
+		$query->bindValue(1, $level);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_user_random_by_level($level)
+	{
+		$query = $this->db->prepare('SELECT * FROM `users` WHERE `level`= ? ORDER BY RAND() LIMIT 1');
+		$query->bindValue(1, $level);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetch();
+	}
+
+	public function get_users()
+	{
+		$query = $this->db->prepare('SELECT * FROM `users` ORDER BY `time` DESC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function log_users($iduser, $log)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$browser = $_SERVER['HTTP_USER_AGENT'];
+		$query = $this->db->prepare('INSERT INTO `log_users` (`iduser`,`time`,`ip`,`browser`,`log`) VALUES (?, ?, ?, ?, ?)');
+		$query->bindValue(1, $iduser);
+		$query->bindValue(2, $time);
+		$query->bindValue(3, $ip);
+		$query->bindValue(4, $browser);
+		$query->bindValue(5, $log);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_users_log()
+	{
+		$query = $this->db->prepare('SELECT * FROM `log_users` ORDER BY `time` DESC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

myticketbyresolver.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>

ticketlistuser.php

Indentation +31 added lines, -31 removed lines

@@ -4,12 +4,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!");

 }

 $tickets = $tickets->get_opened_tickets();

 $tickets_count = count($tickets);

@@ -63,34 +63,34 @@ 
     </thead>

     <tbody>

 		<?php 

-        $currenttime = time();

-        foreach ($tickets 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=ticketedituser.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', $ticket['reporteddate']).'</td>'.

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

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

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

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

-        }

-        ?>

+		$currenttime = time();

+		foreach ($tickets 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=ticketedituser.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', $ticket['reporteddate']).'</td>'.

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

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

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

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

+		}

+		?>

     </tbody>

 	</table>

 </body>

pivot/json.php

Indentation +5 added lines, -5 removed lines

@@ -8,10 +8,10 @@
 $tickets = $tickets->get_tickets();
 $json = '[';
 foreach ($tickets as $ticket) {
-    $userassignee = $users->userdata($ticket['assignee']);
-    $json .= '{"Product": "",'.
-    '"Company": "",'.
-    '"Assignee": "'.$userassignee['fullname'].'",'.
-    '"Status": "'.$ticket['ticketstatus'].'"},';
+	$userassignee = $users->userdata($ticket['assignee']);
+	$json .= '{"Product": "",'.
+	'"Company": "",'.
+	'"Assignee": "'.$userassignee['fullname'].'",'.
+	'"Status": "'.$ticket['ticketstatus'].'"},';
 }
 echo substr($json, 0, -1).']';

myticketbyassignee.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>