aepnat / simhelpdesk

statistic/pdftable/font/timesi.php

Indentation +12 added lines, -12 removed lines

@@ -1,15 +1,15 @@
 <?php
 
 $fpdf_charwidths['timesI'] = [
-    chr(0)  => 250, chr(1)=>250, chr(2)=>250, chr(3)=>250, chr(4)=>250, chr(5)=>250, chr(6)=>250, chr(7)=>250, chr(8)=>250, chr(9)=>250, chr(10)=>250, chr(11)=>250, chr(12)=>250, chr(13)=>250, chr(14)=>250, chr(15)=>250, chr(16)=>250, chr(17)=>250, chr(18)=>250, chr(19)=>250, chr(20)=>250, chr(21)=>250,
-    chr(22) => 250, chr(23)=>250, chr(24)=>250, chr(25)=>250, chr(26)=>250, chr(27)=>250, chr(28)=>250, chr(29)=>250, chr(30)=>250, chr(31)=>250, ' '=>250, '!'=>333, '"'=>420, '#'=>500, '$'=>500, '%'=>833, '&'=>778, '\''=>214, '('=>333, ')'=>333, '*'=>500, '+'=>675,
-    ','     => 250, '-'=>333, '.'=>250, '/'=>278, '0'=>500, '1'=>500, '2'=>500, '3'=>500, '4'=>500, '5'=>500, '6'=>500, '7'=>500, '8'=>500, '9'=>500, ':'=>333, ';'=>333, '<'=>675, '='=>675, '>'=>675, '?'=>500, '@'=>920, 'A'=>611,
-    'B'     => 611, 'C'=>667, 'D'=>722, 'E'=>611, 'F'=>611, 'G'=>722, 'H'=>722, 'I'=>333, 'J'=>444, 'K'=>667, 'L'=>556, 'M'=>833, 'N'=>667, 'O'=>722, 'P'=>611, 'Q'=>722, 'R'=>611, 'S'=>500, 'T'=>556, 'U'=>722, 'V'=>611, 'W'=>833,
-    'X'     => 611, 'Y'=>556, 'Z'=>556, '['=>389, '\\'=>278, ']'=>389, '^'=>422, '_'=>500, '`'=>333, 'a'=>500, 'b'=>500, 'c'=>444, 'd'=>500, 'e'=>444, 'f'=>278, 'g'=>500, 'h'=>500, 'i'=>278, 'j'=>278, 'k'=>444, 'l'=>278, 'm'=>722,
-    'n'     => 500, 'o'=>500, 'p'=>500, 'q'=>500, 'r'=>389, 's'=>389, 't'=>278, 'u'=>500, 'v'=>444, 'w'=>667, 'x'=>444, 'y'=>444, 'z'=>389, '{'=>400, '|'=>275, '}'=>400, '~'=>541, chr(127)=>350, chr(128)=>500, chr(129)=>350, chr(130)=>333, chr(131)=>500,
-    chr(132)=> 556, chr(133)=>889, chr(134)=>500, chr(135)=>500, chr(136)=>333, chr(137)=>1000, chr(138)=>500, chr(139)=>333, chr(140)=>944, chr(141)=>350, chr(142)=>556, chr(143)=>350, chr(144)=>350, chr(145)=>333, chr(146)=>333, chr(147)=>556, chr(148)=>556, chr(149)=>350, chr(150)=>500, chr(151)=>889, chr(152)=>333, chr(153)=>980,
-    chr(154)=> 389, chr(155)=>333, chr(156)=>667, chr(157)=>350, chr(158)=>389, chr(159)=>556, chr(160)=>250, chr(161)=>389, chr(162)=>500, chr(163)=>500, chr(164)=>500, chr(165)=>500, chr(166)=>275, chr(167)=>500, chr(168)=>333, chr(169)=>760, chr(170)=>276, chr(171)=>500, chr(172)=>675, chr(173)=>333, chr(174)=>760, chr(175)=>333,
-    chr(176)=> 400, chr(177)=>675, chr(178)=>300, chr(179)=>300, chr(180)=>333, chr(181)=>500, chr(182)=>523, chr(183)=>250, chr(184)=>333, chr(185)=>300, chr(186)=>310, chr(187)=>500, chr(188)=>750, chr(189)=>750, chr(190)=>750, chr(191)=>500, chr(192)=>611, chr(193)=>611, chr(194)=>611, chr(195)=>611, chr(196)=>611, chr(197)=>611,
-    chr(198)=> 889, chr(199)=>667, chr(200)=>611, chr(201)=>611, chr(202)=>611, chr(203)=>611, chr(204)=>333, chr(205)=>333, chr(206)=>333, chr(207)=>333, chr(208)=>722, chr(209)=>667, chr(210)=>722, chr(211)=>722, chr(212)=>722, chr(213)=>722, chr(214)=>722, chr(215)=>675, chr(216)=>722, chr(217)=>722, chr(218)=>722, chr(219)=>722,
-    chr(220)=> 722, chr(221)=>556, chr(222)=>611, chr(223)=>500, chr(224)=>500, chr(225)=>500, chr(226)=>500, chr(227)=>500, chr(228)=>500, chr(229)=>500, chr(230)=>667, chr(231)=>444, chr(232)=>444, chr(233)=>444, chr(234)=>444, chr(235)=>444, chr(236)=>278, chr(237)=>278, chr(238)=>278, chr(239)=>278, chr(240)=>500, chr(241)=>500,
-    chr(242)=> 500, chr(243)=>500, chr(244)=>500, chr(245)=>500, chr(246)=>500, chr(247)=>675, chr(248)=>500, chr(249)=>500, chr(250)=>500, chr(251)=>500, chr(252)=>500, chr(253)=>444, chr(254)=>500, chr(255)=>444, ];
+	chr(0)  => 250, chr(1)=>250, chr(2)=>250, chr(3)=>250, chr(4)=>250, chr(5)=>250, chr(6)=>250, chr(7)=>250, chr(8)=>250, chr(9)=>250, chr(10)=>250, chr(11)=>250, chr(12)=>250, chr(13)=>250, chr(14)=>250, chr(15)=>250, chr(16)=>250, chr(17)=>250, chr(18)=>250, chr(19)=>250, chr(20)=>250, chr(21)=>250,
+	chr(22) => 250, chr(23)=>250, chr(24)=>250, chr(25)=>250, chr(26)=>250, chr(27)=>250, chr(28)=>250, chr(29)=>250, chr(30)=>250, chr(31)=>250, ' '=>250, '!'=>333, '"'=>420, '#'=>500, '$'=>500, '%'=>833, '&'=>778, '\''=>214, '('=>333, ')'=>333, '*'=>500, '+'=>675,
+	','     => 250, '-'=>333, '.'=>250, '/'=>278, '0'=>500, '1'=>500, '2'=>500, '3'=>500, '4'=>500, '5'=>500, '6'=>500, '7'=>500, '8'=>500, '9'=>500, ':'=>333, ';'=>333, '<'=>675, '='=>675, '>'=>675, '?'=>500, '@'=>920, 'A'=>611,
+	'B'     => 611, 'C'=>667, 'D'=>722, 'E'=>611, 'F'=>611, 'G'=>722, 'H'=>722, 'I'=>333, 'J'=>444, 'K'=>667, 'L'=>556, 'M'=>833, 'N'=>667, 'O'=>722, 'P'=>611, 'Q'=>722, 'R'=>611, 'S'=>500, 'T'=>556, 'U'=>722, 'V'=>611, 'W'=>833,
+	'X'     => 611, 'Y'=>556, 'Z'=>556, '['=>389, '\\'=>278, ']'=>389, '^'=>422, '_'=>500, '`'=>333, 'a'=>500, 'b'=>500, 'c'=>444, 'd'=>500, 'e'=>444, 'f'=>278, 'g'=>500, 'h'=>500, 'i'=>278, 'j'=>278, 'k'=>444, 'l'=>278, 'm'=>722,
+	'n'     => 500, 'o'=>500, 'p'=>500, 'q'=>500, 'r'=>389, 's'=>389, 't'=>278, 'u'=>500, 'v'=>444, 'w'=>667, 'x'=>444, 'y'=>444, 'z'=>389, '{'=>400, '|'=>275, '}'=>400, '~'=>541, chr(127)=>350, chr(128)=>500, chr(129)=>350, chr(130)=>333, chr(131)=>500,
+	chr(132)=> 556, chr(133)=>889, chr(134)=>500, chr(135)=>500, chr(136)=>333, chr(137)=>1000, chr(138)=>500, chr(139)=>333, chr(140)=>944, chr(141)=>350, chr(142)=>556, chr(143)=>350, chr(144)=>350, chr(145)=>333, chr(146)=>333, chr(147)=>556, chr(148)=>556, chr(149)=>350, chr(150)=>500, chr(151)=>889, chr(152)=>333, chr(153)=>980,
+	chr(154)=> 389, chr(155)=>333, chr(156)=>667, chr(157)=>350, chr(158)=>389, chr(159)=>556, chr(160)=>250, chr(161)=>389, chr(162)=>500, chr(163)=>500, chr(164)=>500, chr(165)=>500, chr(166)=>275, chr(167)=>500, chr(168)=>333, chr(169)=>760, chr(170)=>276, chr(171)=>500, chr(172)=>675, chr(173)=>333, chr(174)=>760, chr(175)=>333,
+	chr(176)=> 400, chr(177)=>675, chr(178)=>300, chr(179)=>300, chr(180)=>333, chr(181)=>500, chr(182)=>523, chr(183)=>250, chr(184)=>333, chr(185)=>300, chr(186)=>310, chr(187)=>500, chr(188)=>750, chr(189)=>750, chr(190)=>750, chr(191)=>500, chr(192)=>611, chr(193)=>611, chr(194)=>611, chr(195)=>611, chr(196)=>611, chr(197)=>611,
+	chr(198)=> 889, chr(199)=>667, chr(200)=>611, chr(201)=>611, chr(202)=>611, chr(203)=>611, chr(204)=>333, chr(205)=>333, chr(206)=>333, chr(207)=>333, chr(208)=>722, chr(209)=>667, chr(210)=>722, chr(211)=>722, chr(212)=>722, chr(213)=>722, chr(214)=>722, chr(215)=>675, chr(216)=>722, chr(217)=>722, chr(218)=>722, chr(219)=>722,
+	chr(220)=> 722, chr(221)=>556, chr(222)=>611, chr(223)=>500, chr(224)=>500, chr(225)=>500, chr(226)=>500, chr(227)=>500, chr(228)=>500, chr(229)=>500, chr(230)=>667, chr(231)=>444, chr(232)=>444, chr(233)=>444, chr(234)=>444, chr(235)=>444, chr(236)=>278, chr(237)=>278, chr(238)=>278, chr(239)=>278, chr(240)=>500, chr(241)=>500,
+	chr(242)=> 500, chr(243)=>500, chr(244)=>500, chr(245)=>500, chr(246)=>500, chr(247)=>675, chr(248)=>500, chr(249)=>500, chr(250)=>500, chr(251)=>500, chr(252)=>500, chr(253)=>444, chr(254)=>500, chr(255)=>444, ];

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

ticketnew.php

Spacing +3 added lines, -3 removed lines

@@ -138,7 +138,7 @@ 
 		</tr>

 		<tr>

 			<td> Reported By* </td><td> : </td>

-			<td> <?php echo $user['fullname'];?> <input type='hidden' size='50' name='reportedby' value="<?php echo $user['fullname'];?>" maxlength="50"> </td>

+			<td> <?php echo $user['fullname']; ?> <input type='hidden' size='50' name='reportedby' value="<?php echo $user['fullname']; ?>" maxlength="50"> </td>

 		</tr>

 		<tr>

 			<td> Urgency (SLA)*</td><td> : </td>

@@ -177,8 +177,8 @@ 
 			<td> </td>

 			<td> </td>

 			<td> <br/>

-			<?php $assignee = $users->get_user_random_by_level('Admin');?>

-			<input type="hidden" name="idassignee" value="<?php echo $assignee['id'];?>"/>

+			<?php $assignee = $users->get_user_random_by_level('Admin'); ?>

+			<input type="hidden" name="idassignee" value="<?php echo $assignee['id']; ?>"/>

 			<input type='submit' name='submit' value=' Submit '>  &nbsp;&nbsp;&nbsp;

 			<input type='reset' name='reset' value=' Reset '> 

 			</td>

Indentation +42 added lines, -42 removed lines

@@ -6,33 +6,33 @@ 
 $documentedby = $_SESSION['loginid'];

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

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

-    $lastticket = $tickets->get_last_ticket();

-    $id = $lastticket['id'] + 1;

-    $ticketnumber = $id.'/SR/'.date('M').'/'.date('Y'); //format nomor tiket

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

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

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

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

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

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

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

-    $ticketstatus = 'Assigned'; //ketika pertama kali dibuat, status="Assigned" ke salah satu teknisi

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

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

-    $changes = 'Create New Ticket';

-    $datasla = $slas->sla_data($sla);

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

-    $tickets->add_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro);

-    $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: ticketread.php?id=$id");

+	$lastticket = $tickets->get_last_ticket();

+	$id = $lastticket['id'] + 1;

+	$ticketnumber = $id.'/SR/'.date('M').'/'.date('Y'); //format nomor tiket

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

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

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

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

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

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

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

+	$ticketstatus = 'Assigned'; //ketika pertama kali dibuat, status="Assigned" ke salah satu teknisi

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

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

+	$changes = 'Create New Ticket';

+	$datasla = $slas->sla_data($sla);

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

+	$tickets->add_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro);

+	$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: ticketread.php?id=$id");

 }

 ?>

 <!DOCTYPE HTML>

@@ -115,12 +115,12 @@ 
 			<td> Urgency (SLA)*</td><td> : </td>

 			<td><select name="sla">

 				<?php 

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

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

-                    foreach ($sla as $slaval) {

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

-                    }

-                ?>

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

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

+					foreach ($sla as $slaval) {

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

+					}

+				?>

 				</select>

 			</td>

 		</tr>

@@ -128,11 +128,11 @@ 
 			<td> Type</td><td> : </td>

 			<td><select name="pro">

 				<?php 

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

-                    echo '<option value=""></option>';

-                    echo '<option value="Hardware">Hardware</option>';

-                    echo '<option value="Software">Software</option>';

-                ?>

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

+					echo '<option value=""></option>';

+					echo '<option value="Hardware">Hardware</option>';

+					echo '<option value="Software">Software</option>';

+				?>

 				</select>

 			</td>

 		</tr>

@@ -159,9 +159,9 @@ 
 	</form>

 

 	<?php 

-    if (empty($errors) === false) {

-        echo '<p class=errormsg>'.implode('</p><p class=errormsg>', $errors).'</p>';

-    }

-    ?>

+	if (empty($errors) === false) {

+		echo '<p class=errormsg>'.implode('</p><p class=errormsg>', $errors).'</p>';

+	}

+	?>

 </body>

 </html>
\ No newline at end of file

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>

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
 		<li><a href="myticketbyresolver.php" target="contentFrame">My Resolution</a></li>

 		<li><a href="myticketwaitforclosed.php" target="contentFrame">Waiting for Close</a></li>

 		<li><a href="ticketlistuser.php" target="contentFrame">View All Opened Tickets</a></li>

-	<?php endif;?>

+	<?php endif; ?>

 </ul>

 </div>

 <?php

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

Spacing +21 added lines, -21 removed lines

@@ -19,10 +19,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -37,10 +37,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -65,7 +65,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -90,7 +90,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -104,7 +104,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -117,7 +117,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -139,10 +139,10 @@ 
                 $query_2->execute();
 
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -158,10 +158,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -178,10 +178,10 @@ 
             $id = $data['id'];
             if ($stored_password === sha1($password)) {
                 return $id;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -195,7 +195,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -209,7 +209,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -221,7 +221,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -235,7 +235,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -248,7 +248,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -269,7 +269,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -280,7 +280,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

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>

Spacing +2 added lines, -2 removed lines

@@ -5,7 +5,7 @@ 
 $user = $users->userdata($_SESSION['loginid']);

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

     $akses = true;

-} else {

+}else {

     $akses = false;

 }

 if ($akses = false) {

@@ -77,7 +77,7 @@ 
             } elseif ($currenttime >= $slawarningtime) {

                 $slabgcolor = '#FFFF00';

                 $slatxtcolor = '#000000';

-            } else {

+            }else {

                 $slabgcolor = '#00FF00';

                 $slatxtcolor = '#000000';

             }