//get user_id
$user_id = user_id($myemail);
//check if user is in anyway attached to the election
if (concluded($election["election_end_date"], $election["election_time_to"], 0)) {
echo 'This election has been concluded.';
} elseif ($openness == 1 && concluded($election["election_start_date"], $election["election_time_from"], 0)) {
echo 'Voting for this election has commenced.';
} elseif ($openness == 1 && concluded($election["election_start_date"], $election["election_time_from"], 3600)) {
echo 'Voting for this election will commence in less an hour.Therefore your request cannot be processed.';
} elseif (attached("request", $user_id, $election["election_id"]) === "request") {
echo 'You have already sent a request to the admin of this election.Just hold on till your request is granted.Thank you.';
} elseif (attached("election", $user_id, $election["election_id"]) == "election") {
echo 'You are the admin of this election.You cannot send a request to yourself.';
} elseif (attached("invites", $user_id, $election["election_id"]) === "invites") {
echo 'You are already invited for this election.';
} elseif (attached("joined", $user_id, $election["election_id"]) === "joined") {
echo '<span >You have joined this election.There is no need to send request.Thank you.</span>';
} else {
#if open,add to joined. if closed,add to request
$election_id = $election["election_id"];
if ($openness == 1) {
$query = "INSERT INTO request (user_id,election_id) VALUES ('{$user_id}','{$election_id}')";
$success_message = '<p style="color: #008000">Request has been passed to the admin successfully.</p>';
} elseif ($openness == 2) {
$query = "INSERT INTO joined (user_id,election_id) VALUES ('{$user_id}','{$election_id}')";
$success_message = '<p style="color: #008000">You have successfully joined this open election.</p>';
}
if ($connection1->query($query)) {
echo $success_message;
} else {
echo 'Request processing not successful.The problem will be fixed soon.Contact the admin to add you up.';
$check->execute();
$check->setFetchMode(PDO::FETCH_ASSOC);
$this_election = $check->fetchAll();
if (empty($this_election) && $error_msg == '') {
//redirect to maindashboard
header("Location:maindashboard.php");
} else {
$this_election = $this_election[0];
$privacy_degree = $this_election['privacy'];
$_SESSION['election_id'] = $this_election['election_id'];
//get user_id
$user_id = user_id($myemail);
$_SESSION['user_id'] = $user_id;
$attachment = ['joined', 'request'];
for ($i = 0; $i < 2; $i++) {
$attach = attached($attachment[$i], $user_id, $_SESSION['election_id']);
if ($attach != null) {
break;
}
}
if ($attach == 'joined') {
$error_msg = '<span class="error">You have already joined this election. Reload your main
browser to see the effect.
</span>';
} elseif ($attach == 'request') {
$error_msg = '<span class="error">Your request has been processed. Reload your main
browser to see the effect.
</span>';
}
//get admin details
$admin_id = $this_election['user_id'];
$admin->execute();
$admin->setFetchMode(PDO::FETCH_ASSOC);
$admin = $admin->fetchAll()[0];
$election_name = $admin['election_name'];
$sender_name = strtoupper($admin['admin_fname']) . " " . $admin['admin_lname'];
//get recipient
$recipient = getAllMembers('users', ['*'], ['user_id', '=', $sender_id])[0];
$recipient_address = $recipient['email'];
$recipient_name = strtoupper($recipient['fname']) . " " . $recipient['lname'];
$mail_subject = "Your request to join " . $election_name . " has been ";
//delete request
$delete_request_query = "DELETE FROM request WHERE user_id='{$sender_id}' AND election_id='{$election_id}'";
if ($connection1->query($delete_request_query)) {
if ($_POST["action"] === "accept") {
//check if user has not been added to the election before
if (attached('joined', $sender_id, $election_id) != 'joined') {
//add sender to joined
$adding_sender_query = "INSERT INTO joined(user_id,election_id) VALUES ('{$sender_id}','{$election_id}')";
if ($connection1->query($adding_sender_query)) {
//send notification
$mail_subject .= "granted.";
$mail_body = "Hello " . $recipient['username'] . ".<br>\n This is to notify you that " . $sender_name . "; the administrator of " . $election_name . "\n has granted your request to join " . $election_name . ". Therefore, you are\n now a valid voter in the election. <a href='http://evoting.oauife.edu.ng'>Login into your account.</a>\n now to view the latest about the election.<br><br> We will like to remind\n you that, at <a href='http://evoting.oauife.edu.ng'>OAU E-voting system</a>, it\n is our responsibility to provide a reliable and trustworthy one-man-one-vote\n online voting system for you always. Thank you.";
sendEmail($recipient_address, $recipient_name, $mail_subject, $mail_body);
echo 'user has been successfully added to election.';
}
}
} elseif ($_POST["action"] == "reject") {
//send notification
$mail_subject .= "rejected.";
$mail_body = "Hello " . $recipient['username'] . ".<br>\n This is to notify you that " . $sender_name . "; the administrator of " . $election_name . "\n has rejected your request to join " . $election_name . ". The possible cause\n of this might be either you are not meant to be a voter in this election\n or you did not meet-up to the necessary requirements, as stated by the\n administrator of this election, needed to be a valid voter in this election.\n Whatever the case may be, the administrators best understands why your\n request was rejected.<br><br> We will like to remind you that, at\n <a href='http://evoting.oauife.edu.ng'>OAU E-voting system</a>, it is our\n responsibility to provide a reliable and trustworthy one-man-one-vote\n online voting system for you always. Thank you.\n <a href='http://evoting.oauife.edu.ng'>Login into your account.</a>";
sendEmail($recipient_address, $recipient_name, $mail_subject, $mail_body);
include_once '../php/post_news.php';
include_once '../php/view_contestant.php';
include_once "../php/vote.php";
include_once "../php/database.php";
//check if election exists
$election_id = $_SESSION["election_id"];
$user_id = user_id($myemail);
$election = getElectionDetails($election_id);
$joined = getAllMembers("joined", ["*"], ["user_id", "=", $user_id], 0, "AND", ["election_id", "=", $election_id]);
if (count($election) == 0 | count($joined) == 0) {
//that means the election does not exist or the user is not joined to the election
header("Location:maindashboard.php");
}
// check if contestant or voter
$adekagun = "Voter";
if (attached("contestants", user_id($myemail), $_SESSION["election_id"]) === "contestants") {
$adekagun = 'Contestant';
}
$_SESSION['adek_link'] = 'election_detailsNews.php?key=' . $_SESSION['election_key'];
$_SESSION['adek_status'] = $adekagun;
?>
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/html">
<head>
<style type="text/css">
.numbers {
/* border-style: ridge;*/
border-width: 2px;
//session_start();
//include_once("connection.php");
$error_msg = '';
if (isset($_POST['join']) || isset($_POST['request'])) {
$user_id = $_SESSION['user_id'];
$election_id = $_SESSION['election_id'];
if (isset($_POST['join'])) {
//prevent this user from doing this the second time
if (attached('joined', $user_id, $election_id) == 'joined') {
$error_msg = '<span class="error">You have already joined this election. Reload your main
browser to see the effect.
</span>';
} else {
$connection1->query("INSERT INTO joined(user_id,election_id) VALUES ('{$user_id}','{$election_id}')");
header("Location:status_accept.php");
}
} elseif (isset($_POST['request'])) {
//prevent this user from doing this the second time
if (attached('request', $user_id, $election_id) == 'request') {
$error_msg = '<span class="error">Your request has been processed. Reload your main
browser to see the effect.
</span>';
} else {
$connection1->query("INSERT INTO request(user_id,election_id) VALUES ('{$user_id}','{$election_id}')");
header("Location:request_sent.php");
}
}
if ($error_msg == '') {
die;
}
}
function publicDisplayable($user_id, $election_id)
{
$table_lists = array('election', 'joined', 'invites', 'request');
$publicity = 'totally';
for ($i = 0; $i < count($table_lists); $i++) {
$attached = attached($table_lists[$i], $user_id, $election_id);
if (!empty($attached)) {
$publicity = 'partially';
break;
}
}
return $publicity;
}
