aepnat / simhelpdesk

core/classes/General.php

Indentation +18 added lines, -18 removed lines

@@ -2,24 +2,24 @@
 
 class General
 {
-    public function logged_in()
-    {
-        return(isset($_SESSION['loginid'])) ? true : false;
-    }
+	public function logged_in()
+	{
+		return(isset($_SESSION['loginid'])) ? true : false;
+	}
 
-    public function logged_in_protect()
-    {
-        if ($this->logged_in() === true) {
-            header('Location: home.php');
-            exit();
-        }
-    }
+	public function logged_in_protect()
+	{
+		if ($this->logged_in() === true) {
+			header('Location: home.php');
+			exit();
+		}
+	}
 
-    public function logged_out_protect()
-    {
-        if ($this->logged_in() === false) {
-            header('Location: index.php');
-            exit();
-        }
-    }
+	public function logged_out_protect()
+	{
+		if ($this->logged_in() === false) {
+			header('Location: index.php');
+			exit();
+		}
+	}
 }

core/classes/SLA.php

Indentation +98 added lines, -98 removed lines

@@ -2,102 +2,102 @@
 
 class SLA
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function sla_exists($slaid)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`slaid`) FROM `sla` WHERE `slaid`= ?');
-        $query->bindValue(1, $slaid);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function add_sla($slaid, $namasla, $responsetime, $resolutiontime, $slawarning)
-    {
-        $querystring = 'INSERT INTO `sla` (`slaid`,`namasla`,`responsetime`, `resolutiontime`, `slawarning`) VALUES (?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $slaid);
-        $query->bindValue(2, $namasla);
-        $query->bindValue(3, $responsetime);
-        $query->bindValue(4, $resolutiontime);
-        $query->bindValue(5, $slawarning);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_sla($slaid, $namasla, $responsetime, $resolutiontime, $slawarning)
-    {
-        $querystring = 'UPDATE `sla` SET `namasla` = ? , `responsetime` = ? , `resolutiontime` = ?, `slawarning` = ?  WHERE `slaid` = ?';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $namasla);
-        $query->bindValue(2, $responsetime);
-        $query->bindValue(3, $resolutiontime);
-        $query->bindValue(4, $slawarning);
-        $query->bindValue(5, $slaid);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `sla` WHERE `slaid` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function sla_data($slaid)
-    {
-        $query = $this->db->prepare('SELECT * FROM `sla` WHERE `slaid`= ?');
-        $query->bindValue(1, $slaid);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_sla()
-    {
-        $query = $this->db->prepare('SELECT * FROM `sla` ORDER BY `slaid` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function sla_exists($slaid)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`slaid`) FROM `sla` WHERE `slaid`= ?');
+		$query->bindValue(1, $slaid);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function add_sla($slaid, $namasla, $responsetime, $resolutiontime, $slawarning)
+	{
+		$querystring = 'INSERT INTO `sla` (`slaid`,`namasla`,`responsetime`, `resolutiontime`, `slawarning`) VALUES (?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $slaid);
+		$query->bindValue(2, $namasla);
+		$query->bindValue(3, $responsetime);
+		$query->bindValue(4, $resolutiontime);
+		$query->bindValue(5, $slawarning);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_sla($slaid, $namasla, $responsetime, $resolutiontime, $slawarning)
+	{
+		$querystring = 'UPDATE `sla` SET `namasla` = ? , `responsetime` = ? , `resolutiontime` = ?, `slawarning` = ?  WHERE `slaid` = ?';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $namasla);
+		$query->bindValue(2, $responsetime);
+		$query->bindValue(3, $resolutiontime);
+		$query->bindValue(4, $slawarning);
+		$query->bindValue(5, $slaid);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `sla` WHERE `slaid` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function sla_data($slaid)
+	{
+		$query = $this->db->prepare('SELECT * FROM `sla` WHERE `slaid`= ?');
+		$query->bindValue(1, $slaid);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_sla()
+	{
+		$query = $this->db->prepare('SELECT * FROM `sla` ORDER BY `slaid` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

Spacing +7 added lines, -7 removed lines

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

core/connect/database.php

Indentation +4 added lines, -4 removed lines

@@ -1,10 +1,10 @@
 <?php
 
 $config = [
-    'host'		    => 'localhost',
-    'username' 	=> 'root',
-    'password' 	=> 'root',
-    'dbname' 	  => 'helpdesk',
+	'host'		    => 'localhost',
+	'username' 	=> 'root',
+	'password' 	=> 'root',
+	'dbname' 	  => 'helpdesk',
 ];
 
 $db = new PDO('mysql:host='.$config['host'].';dbname='.$config['dbname'], $config['username'], $config['password']);

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

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/>

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

             }

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>