function prehlad_zadani($zverejnene)
{
if ($link = db_connect()) {
if ($zverejnene) {
$sql = "SELECT * FROM assignments a INNER JOIN texts t ON a.text_id_name = t.text_id WHERE begin <= NOW() AND end > NOW()";
$nadpis = "published-assignments";
} else {
$sql = "SELECT * FROM assignments a INNER JOIN texts t ON a.text_id_name = t.text_id WHERE begin > NOW() OR begin is NULL";
$nadpis = "unpublished-assignments";
}
$result = mysqli_query($link, $sql);
if ($result) {
?>
<div id="prehlad_zadani">
<p>
<form method="post">
<h2 data-trans-key="<?php
echo $nadpis;
?>
"></h2>
<table>
<?php
while ($row = mysqli_fetch_assoc($result)) {
$eng = is_null($row['eng']) ? $row['sk'] : $row['eng'];
echo "<tr>";
if (isUserTypeLogged("Administrator") || isUserTypeLogged("Jury") && $zverejnene == false) {
echo "<td><input type='radio' name='id' value='{$row['context_id']}'><br></td>\n";
}
echo "<td data-trans-lang='" . SK . "'><a href='assignment.php?id={$row['context_id']}'>{$row['sk']}</a></td>";
echo "<td data-trans-lang='" . ENG . "'><a href='assignment.php?id={$row['context_id']}'>{$eng}</a></td>";
?>
<td> <?php
if (isUserTypeLogged("Administrator") || isUserTypeLogged("Jury") && $zverejnene == false) {
if ($row['begin'] == "") {
echo "---";
} else {
echo $row['begin'];
}
} else {
echo '<span data-trans-key="upload-by"></span>';
}
?>
</td>
<td> <?php
if ($row['end'] == "") {
echo "---";
} else {
echo $row['end'];
}
?>
</td>
<?php
echo "</tr>";
}
if (isUserTypeLogged("Administrator")) {
?>
<tr>
<td> </td>
<td data-trans-key="publish-date"> </td>
<td> <input type='datetime-local' name='start' value="<?php
echo Date("Y-m-d") . "T" . Date("H:i");
?>
"> </td>
</tr>
<tr>
<td> </td>
<td data-trans-key="deadline-date"> </td>
<td> <input type='datetime-local' name='stop' value="<?php
echo date('Y-m-d', strtotime(Date("Y-m-d") . ' + 14 days')) . "T23:59";
?>
"> </td>
<td> <button type="submit" style="width:200px" formaction="prehladZadani.php?action=1" data-trans-key="publish-selected-assignment" id="publishAssignment" /> </td>
</tr>
<?php
if (!$zverejnene) {
?>
<tr>
<td> </td><td> </td><td> </td>
<td> <button type="submit" style="width:200px" formaction="prehladZadani.php?action=2" data-trans-key="delete-selected-assignment" id="deleteAssignment" /> </td>
</tr>
<?php
}
}
if (isUserTypeLogged("Administrator") || isUserTypeLogged("Jury") && $zverejnene == false) {
?>
<tr>
<td> </td><td> </td><td> </td>
<td> <button type="submit" style="width:200px" formaction="prehladZadani.php?action=3" data-trans-key="edit-selected-assignment" id="editAssignment" /> </td>
</tr>
<?php
}
?>
</table>
</form>
</p>
</div>
<?php
mysqli_free_result($result);
} else {
echoError('err-db-query-fail');
}
mysqli_close($link);
} else {
echoError('err-db-connection-fail');
}
}
page_nav();
get_topright_form();
if (!isset($_SESSION["loggedUser"]) || $_SESSION["loggedUser"] == null) {
dieWithError("err-not-logged-in");
}
if (get_class($_SESSION["loggedUser"]) == "Team") {
dieWithError("err-add-assignment-rights");
}
$conn = db_connect();
if (isset($_GET["id"]) && !empty($_GET["id"])) {
$sql_get_assignment = "SELECT * FROM assignments a, contexts c WHERE c.context_id = a.context_id AND c.context_id = " . $_GET["id"];
$flag = false;
$result = mysqli_query($conn, $sql_get_assignment);
if ($result == true && mysqli_num_rows($result) != 0) {
$assignment = new Assignment($conn, $_GET["id"]);
if (!isUserTypeLogged("Administrator") && $_SESSION["loggedUser"]->getId() != $assignment->getAuthor()->getId()) {
dieWithError("err-edit-assignment-rights");
}
} else {
$assignment = new Assignment($conn, 0);
$flag = true;
}
if (isset($_POST['checkbox'])) {
$assignment->deleteAttachments($conn, $_POST['checkbox']);
}
if (isset($_POST['skName']) && $_POST['skName'] != $assignment->getSkName()) {
$assignment->setSkName($conn, $_POST['skName']);
}
if (isset($_POST['engName']) && $_POST['engName'] != $assignment->getEngName()) {
$assignment->setEngName($conn, $_POST['engName']);
}
$result = mysqli_query($link, $sql);
if ($result && mysqli_num_rows($result) != 0 || isUserTypeLogged("Administrator")) {
?>
<meta http-equiv="refresh" content="0;url=addAssignment.php?id=<?php
echo $_POST["id"];
?>
"><?php
} else {
echoError('err-edit-assignment-rights');
}
mysqli_close($link);
} else {
echoError('err-db-connection-fail');
}
}
}
}
}
}
if (isUserTypeLogged("Administrator") || isUserTypeLogged("Jury")) {
prehlad_zadani(false);
?>
<br>
<form action="addAssignment.php">
<input type="submit" data-trans-key="new-assignment">
</form>
<br>
<?php
}
prehlad_zadani(true);
page_footer();