if (isset($_GET['key'])) {
$view_election_id = $_GET['key'];
$election_id = unwrap($view_election_id);
$_SESSION['election_id_view'] = $election_id;
}
//querying for news
$view_posted_news = "";
$row1 = getAllMembers("users", ["fname", "lname", "picture_name"], ["user_id", "=", $user_id])[0];
$view_news_query = $connection1->prepare("SELECT * FROM news WHERE election_id = '{$election_id}' ORDER BY date_created DESC");
$view_news_query->execute();
$view_news_query->setFetchMode(PDO::FETCH_ASSOC);
$row = $view_news_query->fetchAll();
for ($i = 0; $i < count($row); $i++) {
$adminPhoto = $images_dir . $row1['picture_name'];
$date_time1 = explode(" ", $row[$i]['date_created']);
$date1 = getDateInterval($date_time1[0]);
$time1 = timeString($date_time1[1]);
$view_posted_news .= "<div class='me' style='margin-bottom:10px; ' >" . "<br>\n <label style='overflow:hidden;text-overflow:ellipsis;'>" . $row[$i]['news'] . "</label>\n <br>" . $date1 . " " . $time1 . "<br></div>";
}
//querying for election name
$election_name = $election_details_test = "";
$row = getElectionDetails($election_id)[0];
$election_name .= $row['election_name'];
$_SESSION['election_name'] = $election_name;
$election_details_test .= "<label>Start Date:</label> " . dateString($row['election_start_date']) . "<br>\n <label>Start Time:</label> " . timeString($row['election_time_from']) . "<br><label>End Date:</label>  " . dateString($row['election_end_date']) . "<br><label>End Time:</label> " . timeString($row['election_time_to']) . "<br>\n <label>Number of Voters: </label> " . count(getAllMembers("joined", ['election_id'], ['election_id', '=', $election_id])) . "<br><label>Number of Contestants: </label> " . count(getAllMembers("contestants", ['contestant_id'], ['election_id', '=', $election_id]));
//getting the user_id for a particular election
$election_admin_details = $election_admin_detail = "";
$images_dir = "../images/users/";
$user_id_result = $row["user_id"];
//querying to get the admin email
$row = getAllMembers("users", ["*"], ["user_id", "=", $user_id_result])[0];
function getEndTime($startDateTime, $p_files)
{
foreach ($p_files as $file) {
$startDateTime->add(getDateInterval($file['length']));
}
return $startDateTime;
}
