public static function getFromTo($group)
{
$DB = new Database();
$sql = "SELECT session_from, session_to FROM panelmembers WHERE session_group ='" . $group . "'";
$result = $DB->query($sql);
$row = $DB->fetch($result);
self::$from = $row['session_from'];
self::$to = $row['session_to'];
}
<div class="row">
<?php
$DB = new Database();
foreach (PanelMember::$Designations as $key => $value) {
if (isset($_GET['from']) && isset($_GET['to'])) {
$sql = "SELECT UID FROM panelmembers WHERE Responsibility = '" . $key . "' AND session_from = '" . pure_it($_GET['from']) . "' AND session_to = '" . pure_it($_GET['to']) . "'";
$result = $DB->query($sql);
$row = $DB->fetch($result);
$PanelMember = new Member($row['UID']);
} elseif (isset($_GET['group'])) {
$sql = "SELECT UID FROM panelmembers WHERE Responsibility = '" . $key . "' AND session_group = '" . pure_it($_GET['group']) . "'";
$result = $DB->query($sql);
$row = $DB->fetch($result);
$PanelMember = new Member($row['UID']);
} else {
$PanelMember = new PanelMember($key);
}
?>
<div class="columns three">
<div class="person">
<div class="img" style="background: url('<?php
echo $PanelMember->getImage();
?>
') no-repeat; background-size: 100% 100%;"></div>
<p class="info italic"><?php
echo $PanelMember->getTotalFullName();
?>
</p>
<p class="highlight"><?php
echo $value;
?>
?>
<?php
if (isset($_GET['archiveError']) && $_GET['archiveError']) {
?>
<h3 class="warning warnc">Sorry! Archiving can not be completed. One or some members are already in the archive.</h3>
<?php
}
?>
<main class="panelmemberview">
<section class="panel">
<div class="container">
<form method="post" action="actions/PanelUpdateAction.php">
<div class="row">
<?php
foreach (PanelMember::$Designations as $key => $value) {
$PanelMember = new PanelMember($key);
?>
<div class="columns two">
<div class="person">
<div class="img" style="background: url('<?php
echo $PanelMember->getImage();
?>
') no-repeat; background-size: 100% 100%;"></div>
<p class="info italic"><?php
echo $PanelMember->getFullName();
?>
</p>
<p class="highlight"><?php
echo $value;
?>
</p>
<?php
require_once "../includes/config.php";
require_once "../classes/Member.php";
require_once "../classes/PanelMember.php";
if (isset($_POST['update_panel'])) {
foreach (PanelMember::$Designations as $key => $value) {
$Member = new Member($_POST[$key]);
if ($Member->isPanelMember() && $Member->getPosition() != $key) {
header("Location: ../admin/panelmember.php?updateError=1");
exit;
}
}
foreach (PanelMember::$Designations as $key => $value) {
$Panel = new PanelMember($key);
$memberid = pure_it($_POST[$key]);
$Panel->updateResponsibility($key, $memberid);
}
header("Location: ../admin/panelmember.php?updateSuccess=1");
exit;
}
<?php
require_once "../includes/config.php";
require_once "../classes/Member.php";
require_once "../classes/PanelMember.php";
if (isset($_POST['archive_panel'])) {
$DB = new Database();
$session_group = PanelMember::count() + 1;
foreach (PanelMember::$Designations as $key => $value) {
$PanelMember = new PanelMember($key);
if ($PanelMember->isArchived()) {
header("Location: ../admin/panelmember.php?archiveError=1");
exit;
}
}
if (!$archiveError) {
foreach (PanelMember::$Designations as $key => $value) {
$PanelMember = new PanelMember($key);
$data = array();
$data['UID'] = $PanelMember->getUserID();
$data['Responsibility'] = $PanelMember->getPosition();
$data['session_from'] = pure_it($_POST['session_from']);
$data['session_to'] = pure_it($_POST['session_to']);
$data['session_group'] = $session_group;
$DB->insert('panelmembers', $data);
}
$DB->close();
header("Location: ../admin/panelmember.php?archiveSuccess=1");
exit;
}
}
