aepnat / simhelpdesk

core/classes/Customers.php

Indentation +191 added lines, -191 removed lines

@@ -2,195 +2,195 @@
 
 class Customers
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function customer_exists($customername)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `customername`= ?');
-        $query->bindValue(1, $customername);
-
-        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 `customers` 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 add_customer($namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $query = $this->db->prepare('INSERT INTO `customers` (`namacustomer`, `alamat`, `Telp`, `email`, `PIC`,`selesperson`, `customerproduct`, `time`, `ip`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)');
-        $query->bindValue(1, $namacustomer);
-        $query->bindValue(2, $alamat);
-        $query->bindValue(3, $Telp);
-        $query->bindValue(4, $email);
-        $query->bindValue(5, $PIC);
-        $query->bindValue(6, $selesperson);
-        $query->bindValue(7, $customerproduct);
-        $query->bindValue(8, $time);
-        $query->bindValue(9, $ip);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_customer($idcustomer, $namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
-    {
-        $time = time();
-        $ip = $_SERVER['REMOTE_ADDR'];
-        $query = $this->db->prepare('UPDATE `customers` SET `namacustomer` = ? , `alamat` = ? , `Telp` = ? , `email` = ? , `PIC` = ? , `selesperson` = ? ,`customerproduct` = ? ,`ip` = ? , `time` = ? WHERE `idcustomer` = ?');
-        $query->bindValue(1, $namacustomer);
-        $query->bindValue(2, $alamat);
-        $query->bindValue(3, $Telp);
-        $query->bindValue(4, $email);
-        $query->bindValue(5, $PIC);
-        $query->bindValue(6, $selesperson);
-        $query->bindValue(7, $customerproduct);
-        $query->bindValue(8, $ip);
-        $query->bindValue(9, $time);
-        $query->bindValue(10, $idcustomer);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `customers` WHERE `idcustomer` = ?';
-        $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 `customers` 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 `customers` 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 `customers` 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_customer($username, $password)
-    {
-        $query = $this->db->prepare('SELECT `email`, `ticket_id` FROM `customers` WHERE `email` = ?');
-        $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 customer_data($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `customers` WHERE `idcustomer`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_customers()
-    {
-        $query = $this->db->prepare('SELECT * FROM `customers` ORDER BY `namacustomer` ASC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function customer_exists($customername)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `customers` WHERE `customername`= ?');
+		$query->bindValue(1, $customername);
+
+		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 `customers` 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 add_customer($namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$query = $this->db->prepare('INSERT INTO `customers` (`namacustomer`, `alamat`, `Telp`, `email`, `PIC`,`selesperson`, `customerproduct`, `time`, `ip`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)');
+		$query->bindValue(1, $namacustomer);
+		$query->bindValue(2, $alamat);
+		$query->bindValue(3, $Telp);
+		$query->bindValue(4, $email);
+		$query->bindValue(5, $PIC);
+		$query->bindValue(6, $selesperson);
+		$query->bindValue(7, $customerproduct);
+		$query->bindValue(8, $time);
+		$query->bindValue(9, $ip);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_customer($idcustomer, $namacustomer, $alamat, $Telp, $email, $PIC, $selesperson, $customerproduct)
+	{
+		$time = time();
+		$ip = $_SERVER['REMOTE_ADDR'];
+		$query = $this->db->prepare('UPDATE `customers` SET `namacustomer` = ? , `alamat` = ? , `Telp` = ? , `email` = ? , `PIC` = ? , `selesperson` = ? ,`customerproduct` = ? ,`ip` = ? , `time` = ? WHERE `idcustomer` = ?');
+		$query->bindValue(1, $namacustomer);
+		$query->bindValue(2, $alamat);
+		$query->bindValue(3, $Telp);
+		$query->bindValue(4, $email);
+		$query->bindValue(5, $PIC);
+		$query->bindValue(6, $selesperson);
+		$query->bindValue(7, $customerproduct);
+		$query->bindValue(8, $ip);
+		$query->bindValue(9, $time);
+		$query->bindValue(10, $idcustomer);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `customers` WHERE `idcustomer` = ?';
+		$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 `customers` 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 `customers` 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 `customers` 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_customer($username, $password)
+	{
+		$query = $this->db->prepare('SELECT `email`, `ticket_id` FROM `customers` WHERE `email` = ?');
+		$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 customer_data($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `customers` WHERE `idcustomer`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_customers()
+	{
+		$query = $this->db->prepare('SELECT * FROM `customers` ORDER BY `namacustomer` ASC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
 }

Spacing +15 added lines, -15 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());
         }
     }
@@ -62,7 +62,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -85,7 +85,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -98,7 +98,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -120,10 +120,10 @@ 
                 $query_2->execute();
 
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -139,10 +139,10 @@ 
             $rows = $query->fetchColumn();
             if ($rows == 1) {
                 return true;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -159,10 +159,10 @@ 
             $id = $data['id'];
             if ($stored_password === sha1($password)) {
                 return $id;
-            } else {
+            }else {
                 return false;
             }
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -176,7 +176,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -187,7 +187,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

core/classes/Users.php

Indentation +270 added lines, -270 removed lines

@@ -2,274 +2,274 @@
 
 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_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_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 +20 added lines, -20 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());
         }
 
@@ -234,7 +234,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -255,7 +255,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -266,7 +266,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 

core/classes/Projects.php

Indentation +129 added lines, -129 removed lines

@@ -2,133 +2,133 @@
 
 class Projects
 {
-    private $db;
-
-    public function __construct($database)
-    {
-        $this->db = $database;
-    }
-
-    public function project_exists($projectid)
-    {
-        $query = $this->db->prepare('SELECT COUNT(`id`) FROM `projects` WHERE `projectid`= ?');
-        $query->bindValue(1, $projectid);
-
-        try {
-            $query->execute();
-            $rows = $query->fetchColumn();
-            if ($rows == 1) {
-                return true;
-            } else {
-                return false;
-            }
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function add_project($projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
-    {
-        $querystring = 'INSERT INTO `projects` (`projectname`,`idcustomer`, `deliverybegin`, `deliveryend`, `installbegin`, `installend`,`uatbegin`,`uatend`,`billstartdate`, `billduedate`, `warrantyperiod`, `contractstartdate`, `contractperiod`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $projectname);
-        $query->bindValue(2, $idcustomer);
-        $query->bindValue(3, $deliverybegin);
-        $query->bindValue(4, $deliveryend);
-        $query->bindValue(5, $installbegin);
-        $query->bindValue(6, $installend);
-        $query->bindValue(7, $uatbegin);
-        $query->bindValue(8, $uatend);
-        $query->bindValue(9, $billstartdate);
-        $query->bindValue(10, $billduedate);
-        $query->bindValue(11, $warrantyperiod);
-        $query->bindValue(12, $contractstartdate);
-        $query->bindValue(13, $contractperiod);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function update_project($projectid, $projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
-    {
-        $querystring = 'UPDATE `projects` SET `projectname` = ? , `idcustomer` = ? , `deliverybegin` = ? , `deliveryend` = ? , `installbegin` = ? ,`installend` = ? , `uatbegin` = ? , `uatend` = ? ,`billstartdate` = ?, `billduedate` = ? , `warrantyperiod` = ? ,`contractstartdate` = ?,`contractperiod` = ? WHERE `projectid` = ?';
-        $query = $this->db->prepare($querystring);
-        $query->bindValue(1, $projectname);
-        $query->bindValue(2, $idcustomer);
-        $query->bindValue(3, $deliverybegin);
-        $query->bindValue(4, $deliveryend);
-        $query->bindValue(5, $installbegin);
-        $query->bindValue(6, $installend);
-        $query->bindValue(7, $uatbegin);
-        $query->bindValue(8, $uatend);
-        $query->bindValue(9, $billstartdate);
-        $query->bindValue(10, $billduedate);
-        $query->bindValue(11, $warrantyperiod);
-        $query->bindValue(12, $contractstartdate);
-        $query->bindValue(13, $contractperiod);
-        $query->bindValue(14, $projectid);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function delete($id)
-    {
-        $sql = 'DELETE FROM `projects` WHERE `projectid` = ?';
-        $query = $this->db->prepare($sql);
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function project_data($id)
-    {
-        $query = $this->db->prepare('SELECT * FROM `projects` WHERE `projectid`= ?');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
-
-    public function get_projects()
-    {
-        $query = $this->db->prepare('SELECT * FROM `projects` ORDER BY `projectid` DESC');
-
-        try {
-            $query->execute();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-
-        return $query->fetchAll();
-    }
-
-    public function get_project_customer($id) //get project_data by idcustomer
-    {
-        $query = $this->db->prepare('SELECT * FROM `projects` WHERE `idcustomer`= ? ORDER BY `contractstartdate` DESC LIMIT 1');
-        $query->bindValue(1, $id);
-
-        try {
-            $query->execute();
-
-            return $query->fetch();
-        } catch (PDOException $e) {
-            die($e->getMessage());
-        }
-    }
+	private $db;
+
+	public function __construct($database)
+	{
+		$this->db = $database;
+	}
+
+	public function project_exists($projectid)
+	{
+		$query = $this->db->prepare('SELECT COUNT(`id`) FROM `projects` WHERE `projectid`= ?');
+		$query->bindValue(1, $projectid);
+
+		try {
+			$query->execute();
+			$rows = $query->fetchColumn();
+			if ($rows == 1) {
+				return true;
+			} else {
+				return false;
+			}
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function add_project($projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
+	{
+		$querystring = 'INSERT INTO `projects` (`projectname`,`idcustomer`, `deliverybegin`, `deliveryend`, `installbegin`, `installend`,`uatbegin`,`uatend`,`billstartdate`, `billduedate`, `warrantyperiod`, `contractstartdate`, `contractperiod`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $projectname);
+		$query->bindValue(2, $idcustomer);
+		$query->bindValue(3, $deliverybegin);
+		$query->bindValue(4, $deliveryend);
+		$query->bindValue(5, $installbegin);
+		$query->bindValue(6, $installend);
+		$query->bindValue(7, $uatbegin);
+		$query->bindValue(8, $uatend);
+		$query->bindValue(9, $billstartdate);
+		$query->bindValue(10, $billduedate);
+		$query->bindValue(11, $warrantyperiod);
+		$query->bindValue(12, $contractstartdate);
+		$query->bindValue(13, $contractperiod);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function update_project($projectid, $projectname, $idcustomer, $deliverybegin, $deliveryend, $installbegin, $installend, $uatbegin, $uatend, $billstartdate, $billduedate, $warrantyperiod, $contractstartdate, $contractperiod)
+	{
+		$querystring = 'UPDATE `projects` SET `projectname` = ? , `idcustomer` = ? , `deliverybegin` = ? , `deliveryend` = ? , `installbegin` = ? ,`installend` = ? , `uatbegin` = ? , `uatend` = ? ,`billstartdate` = ?, `billduedate` = ? , `warrantyperiod` = ? ,`contractstartdate` = ?,`contractperiod` = ? WHERE `projectid` = ?';
+		$query = $this->db->prepare($querystring);
+		$query->bindValue(1, $projectname);
+		$query->bindValue(2, $idcustomer);
+		$query->bindValue(3, $deliverybegin);
+		$query->bindValue(4, $deliveryend);
+		$query->bindValue(5, $installbegin);
+		$query->bindValue(6, $installend);
+		$query->bindValue(7, $uatbegin);
+		$query->bindValue(8, $uatend);
+		$query->bindValue(9, $billstartdate);
+		$query->bindValue(10, $billduedate);
+		$query->bindValue(11, $warrantyperiod);
+		$query->bindValue(12, $contractstartdate);
+		$query->bindValue(13, $contractperiod);
+		$query->bindValue(14, $projectid);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function delete($id)
+	{
+		$sql = 'DELETE FROM `projects` WHERE `projectid` = ?';
+		$query = $this->db->prepare($sql);
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function project_data($id)
+	{
+		$query = $this->db->prepare('SELECT * FROM `projects` WHERE `projectid`= ?');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
+
+	public function get_projects()
+	{
+		$query = $this->db->prepare('SELECT * FROM `projects` ORDER BY `projectid` DESC');
+
+		try {
+			$query->execute();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+
+		return $query->fetchAll();
+	}
+
+	public function get_project_customer($id) //get project_data by idcustomer
+	{
+		$query = $this->db->prepare('SELECT * FROM `projects` WHERE `idcustomer`= ? ORDER BY `contractstartdate` DESC LIMIT 1');
+		$query->bindValue(1, $id);
+
+		try {
+			$query->execute();
+
+			return $query->fetch();
+		} catch (PDOException $e) {
+			die($e->getMessage());
+		}
+	}
 }

Spacing +8 added lines, -8 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());
         }
     }
@@ -47,7 +47,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -73,7 +73,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -86,7 +86,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -100,7 +100,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }
@@ -111,7 +111,7 @@ 
 
         try {
             $query->execute();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
 
@@ -127,7 +127,7 @@ 
             $query->execute();
 
             return $query->fetch();
-        } catch (PDOException $e) {
+        }catch (PDOException $e) {
             die($e->getMessage());
         }
     }

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

core/init.php

Indentation +11 added lines, -11 removed lines

@@ -5,20 +5,20 @@
 require_once 'connect/database.php';
 function my_autoload($class)
 {
-    $filename = 'classes/'.$class.'.php';
-    include_once $filename;
+	$filename = 'classes/'.$class.'.php';
+	include_once $filename;
 }
 spl_autoload_register('my_autoload');
 
 try {
-    $general = new General();
-    $users = new Users($db);
-    $customers = new Customers($db);
-    $projects = new Projects($db);
-    $tickets = new Tickets($db);
-    $hdnews = new HDNews($db);
-    $slas = new SLA($db);
-    $emails = new Emails($db);
+	$general = new General();
+	$users = new Users($db);
+	$customers = new Customers($db);
+	$projects = new Projects($db);
+	$tickets = new Tickets($db);
+	$hdnews = new HDNews($db);
+	$slas = new SLA($db);
+	$emails = new Emails($db);
 } catch (Exception $e) {
-    echo 'Caught exception: ',  $e->getMessage(), "\n";
+	echo 'Caught exception: ',  $e->getMessage(), "\n";
 }

Spacing +2 added lines, -2 removed lines

@@ -19,6 +19,6 @@
     $hdnews = new HDNews($db);
     $slas = new SLA($db);
     $emails = new Emails($db);
-} catch (Exception $e) {
-    echo 'Caught exception: ',  $e->getMessage(), "\n";
+}catch (Exception $e) {
+    echo 'Caught exception: ', $e->getMessage(), "\n";
 }

emailqueue.php

Indentation +23 added lines, -23 removed lines

@@ -4,16 +4,16 @@ 
 $general->logged_out_protect();
 $user = $users->userdata($_SESSION['loginid']);
 if ($user['level'] != 'Admin') {
-    exit("You don't have permission to access this page!");
+	exit("You don't have permission to access this page!");
 }
 
 if (isset($_POST['submit'])) {
-    echo 'Sending email queue... Please wait!';
-    //$result=$emails->send_new_ticket();
-    //$result=$emails->send_sla_remainder();
-    //header('Location: emailqueue.php?process');
-    //sleep(5);
-    header('Location: emailqueue.php?success');
+	echo 'Sending email queue... Please wait!';
+	//$result=$emails->send_new_ticket();
+	//$result=$emails->send_sla_remainder();
+	//header('Location: emailqueue.php?process');
+	//sleep(5);
+	header('Location: emailqueue.php?success');
 }
 $logs = $emails->get_email_queue();
 $emailqueue_count = count($logs);
@@ -60,13 +60,13 @@ 
 	</form>

 	<span class="textmsg">

 	<?php 
-        if (isset($_GET['process']) && empty($_GET['process'])) {
-            echo 'Sending email queue... Please wait!';
-        }
-        if (isset($_GET['success']) && empty($_GET['success'])) {
-            echo 'Sending email queue is done!';
-        }
-    ?></span>

+		if (isset($_GET['process']) && empty($_GET['process'])) {
+			echo 'Sending email queue... Please wait!';
+		}
+		if (isset($_GET['success']) && empty($_GET['success'])) {
+			echo 'Sending email queue is done!';
+		}
+	?></span>

 	</p>

 	<table id="datatables" class="display">

     <thead>

@@ -80,15 +80,15 @@ 
     </thead>

     <tbody>

 		<?php 
-        foreach ($logs as $log) {
-            $idemail = $log['idemail'];
-            echo '<tr><td><a href="emailsend.php?id='.$idemail.'">'.date('d-M-Y H:i', $log['senddate']).'</a></td>'.
-                 '<td>'.$log['emailto'].'</td>'.
-                 '<td>'.$log['emailcc'].'</td>'.
-                 '<td>'.$log['emailsubject'].'</td>'.
-                 '<td>'.$log['emailstatus'].'</td></tr>';
-        }
-        ?>

+		foreach ($logs as $log) {
+			$idemail = $log['idemail'];
+			echo '<tr><td><a href="emailsend.php?id='.$idemail.'">'.date('d-M-Y H:i', $log['senddate']).'</a></td>'.
+				 '<td>'.$log['emailto'].'</td>'.
+				 '<td>'.$log['emailcc'].'</td>'.
+				 '<td>'.$log['emailsubject'].'</td>'.
+				 '<td>'.$log['emailstatus'].'</td></tr>';
+		}
+		?>

     </tbody>

 	</table>

 </body>

popularsolution.php

Indentation +11 added lines, -11 removed lines

@@ -49,17 +49,17 @@
     </thead>

     <tbody>

 		<?php 
-        foreach ($tickets as $ticket) {
-            $sla = $slas->sla_data($ticket['sla']);
-            $customer = $customers->customer_data($ticket['idcustomer']);
-            echo '<tr><td>'.$customer['namacustomer'].'</td>'.
-                 '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.
-                 '<td>'.$ticket['problemsummary'].'</td>'.
-                 '<td>'.$ticket['problemdetail'].'</td>'.
-                 '<td>'.$ticket['resolution'].'</td>'.
-                 '<td>'.$ticket['resolvedby'].'</td></tr>';
-        }
-        ?>

+		foreach ($tickets as $ticket) {
+			$sla = $slas->sla_data($ticket['sla']);
+			$customer = $customers->customer_data($ticket['idcustomer']);
+			echo '<tr><td>'.$customer['namacustomer'].'</td>'.
+				 '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.
+				 '<td>'.$ticket['problemsummary'].'</td>'.
+				 '<td>'.$ticket['problemdetail'].'</td>'.
+				 '<td>'.$ticket['resolution'].'</td>'.
+				 '<td>'.$ticket['resolvedby'].'</td></tr>';
+		}
+		?>

     </tbody>

 	</table>

 	<p>&nbsp;</p>

customerlist.php

Indentation +18 added lines, -18 removed lines

@@ -3,7 +3,7 @@ 
 $general->logged_out_protect();
 $user = $users->userdata($_SESSION['loginid']);
 if ($user['level'] != 'Admin') {
-    exit("You don't have permission to access this page!");
+	exit("You don't have permission to access this page!");
 }
 
 $members = $customers->get_customers();
@@ -62,23 +62,23 @@ 
     </thead>

     <tbody>

 		<?php 
-        foreach ($members as $member) {
-            if (@$member['confirmed'] == '1') {
-                $locked = 'No';
-            } else {
-                $locked = 'Yes';
-            }
-            $disp_id_customer = sprintf('%04s', $member['idcustomer']);
-            echo '<tr><td><a href=customeredit.php?id='.$member['idcustomer'].'>'.$disp_id_customer.'</a></td>'.
-                 '<td>'.$member['namacustomer'].'</td>'.
-                 '<td>'.$member['alamat'].'</td>'.
-                 '<td>'.$member['Telp'].'</td>'.
-                 '<td>'.$member['PIC'].'</td>'.
-                 '<td>'.$member['selesperson'].'</td>'.
-                 '<td>'.$member['customerproduct'].'</td>'.
-                 '<td><a href=customerdel.php?id='.$member['idcustomer'].' onclick="return delete_confirm();">del</a></td></tr>';
-        }
-        ?>

+		foreach ($members as $member) {
+			if (@$member['confirmed'] == '1') {
+				$locked = 'No';
+			} else {
+				$locked = 'Yes';
+			}
+			$disp_id_customer = sprintf('%04s', $member['idcustomer']);
+			echo '<tr><td><a href=customeredit.php?id='.$member['idcustomer'].'>'.$disp_id_customer.'</a></td>'.
+				 '<td>'.$member['namacustomer'].'</td>'.
+				 '<td>'.$member['alamat'].'</td>'.
+				 '<td>'.$member['Telp'].'</td>'.
+				 '<td>'.$member['PIC'].'</td>'.
+				 '<td>'.$member['selesperson'].'</td>'.
+				 '<td>'.$member['customerproduct'].'</td>'.
+				 '<td><a href=customerdel.php?id='.$member['idcustomer'].' onclick="return delete_confirm();">del</a></td></tr>';
+		}
+		?>

     </tbody>

 	</table>

 	<p>&nbsp;</p>

Spacing +1 added lines, -1 removed lines

@@ -65,7 +65,7 @@
         foreach ($members as $member) {
             if (@$member['confirmed'] == '1') {
                 $locked = 'No';
-            } else {
+            }else {
                 $locked = 'Yes';
             }
             $disp_id_customer = sprintf('%04s', $member['idcustomer']);