<?php
require_once "../../includes/initialize.php";
if (!$session->is_logged_in()) {
redirect_to("login.php");
}
// must have an ID
if (empty($_GET['id'])) {
$session->message("No request ID was provided.");
redirect_to('index.php');
}
$request = Request::find_by_id($_GET['id']);
if ($request && $request->delete()) {
$rq_subject = ucfirst($request->subject);
if (empty($rq_subjectq)) {
$rq_subject = "No subject";
}
//delete the notificaiton if request is deleted
$notification = Notification::find_by_id($request->id);
if ($notification->delete() == true) {
$session->message("The request \"{$rq_subject}\" was deleted.");
redirect_to('list_requests.php');
}
} else {
$session->message("The request could not be deleted.");
redirect_to('list_requests.php');
}
if (isset($database)) {
$database->close_connection();
}
<!--End of the log out form-->
</ul>
</div>
</div>
</nav>
<!-- End of the navigation bar -->
<?php
require_once "includes/initialize.php";
$r_id = $_GET['id'];
$find_req = Request::find_by_id($r_id);
if (isset($_POST['submit'])) {
$fer_type = trim(mysql_prep($_POST['fer_type']));
$name = trim(mysql_prep($_POST['name']));
$quantity = trim(mysql_prep($_POST['quantity']));
$date = trim(mysql_prep($_POST['date']));
if (empty($errors)) {
$new_req = new Request();
$new_req->req_id = $r_id;
$new_req->fer_type = $fer_type;
$new_req->name = $name;
$new_req->quantity = $quantity;
$new_req->date = $date;
$rslt = $new_req->update();
if ($rslt) {
echo "<div class=\"container\">\n\t\t\t\t\t\t<div class=\"row\">\n\t\t\t\t\t\t\t<div class=\"col-md-7\">\n\t\t\t\t\t\t\t\t<div class=\"panel panel-default\">\n\t\t\t\t\t\t\t\t\t<div class=\"panel-body\">\n\t\t\t\t\t\t\t\t\t\t<h4>Your request has been successfully updated<h4><br>\n\t\t\t\t\t\t\t\t\t\t<h4>Thank You!<h4><br>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t";
<?php
require_once "../../includes/initialize.php";
if (!$session->is_logged_in() || $_SESSION['role'] != "admin" && $_SESSION['role'] != "moderator") {
redirect_to("login.php");
}
// must have an ID
if (empty($_GET['id'])) {
$session->message("No notification ID was provided.");
redirect_to('index.php');
}
$notification = Notification::find_by_id($_GET['id']);
if ($notification && $notification->delete()) {
//to get the username for the notification
$request = Request::find_by_id($notification->request_id);
$user = User::find_by_id($request->user_id);
$first_name = $user->first_name;
$session->message("Notification by {$first_name} was deleted.");
redirect_to('index.php');
} else {
$session->message("Notification could not be deleted.");
redirect_to('index.php');
}
if (isset($database)) {
$database->close_connection();
}
//creating a new request
$request = new Request();
$request->department = strtolower($_POST['department']);
$request->subject = $_POST['subject'];
$request->description = $_POST['description'];
$request->expected_solution = $_POST['expected_solution'];
$request->priority = $_POST['priority'];
$request->user_id = $_SESSION['user_id'];
$request->created = strftime("%Y-%m-%d %H:%M:%S", time());
if ($request->save()) {
// Success
//Create a Notfication for each new request
$notification = new Notification();
$notification->request_id = $request->id;
//to get the username for the notification
$request = Request::find_by_id($request->id);
$user = User::find_by_id($request->user_id);
$first_name = $user->first_name;
$notification->body = "A new request has been created by {$first_name}.";
$notification->department = $request->department;
$notification->created = strftime("%Y-%m-%d %H:%M:%S", time());
$notification->save();
//sucess message
$session->message("Request created successfully.");
redirect_to('index.php');
} else {
// Failure
$session->message("Request failed.");
redirect_to('index.php');
}
}
