$SQL = "select * from soubory where id_zprav='$zprav' ";
if(DB_select($SQL, $vystup, $pocet))
{
if($pocet>0)
{
echo "<P>Poèet záznamù: $pocet";
echo "<form method=\"post\">";
echo "<p><table border=0 cellspacing=2 cellpadding=5>";
echo "<tr bgcolor=\"#dddddd\"><td><b><center>mazání</center></b></td><td><center><b>soubor</b></center></td><td><center><b>datum</b></center></td></tr>";
$i=0;
while($zaz=MySQL_fetch_array($vystup))
{
echo "<tr valign=\"top\">";
echo "<td><input type=\"checkbox\" name=\"vymaz[]\" value=\"".$zaz["id"]."\"></td>";
echo "<td><a href=\"sendfile.php?kod=$kod&p_prava=5&p_nazev=".$zaz["nazev"]."&p_adresar=files_kraj/".$zaz["nazev"]."\">".$zaz["popis"]."</a></td>";
echo "<td><small>".Datum($zaz["datum"])."</small></td>";
echo "</tr>";
$i++;
}
echo "<tr><td colspan=\"5\"><input type=\"submit\" name=\"odeslano_vymaz\" value=\"odstranit vybrané soubory\"></td></tr>";
echo "</table>";
echo "</form>";
}
else echo Text_alter("","Vybraný zpravodaj neobsahuje pøílohy.");
}
}
break;
}
}
Konec();
echo "<table border=0 cellspacing=2 cellpadding=5>";
Zahlavi_radek(array("Ètení", "Tøída", "Pøedmìt", "Odesílatel", " ", "Datum", "Platnost do"), "left");
$i=0;
while($zaz=MySQL_fetch_array($vystup))
{
$j=0;
while($zaz["platnost_do"]<>$neplatne[$j] and $j<count($neplatne)) $j++;
if($zaz["platnost_do"]==$neplatne[$j]) $podklad = "bgcolor = \"#ffdddd\"";
$platnost_do = Datum($zaz["platnost_do"], 0);
echo "<tr valign=\"top\" $podklad>";
echo "<td><a href=\"./vzkazy_vsechny.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\"><img src=\"./images/oko.gif\" border=none></a></td>";
echo "<td>".$zaz["trida"]."</td>";
echo "<td>".$zaz["predmet"]."</td>";
echo "<td>".$zaz["jmeno"]." ".$zaz["prijmeni"]."</td>";
echo "<td>(".$zaz["skupina"].")</td>";
echo "<td>".Datum($zaz["datum"])."</td>";
echo "<td>".Text_alter($platnost_do, "neuvedena")."</td>";
echo "</tr>";
$i++;
$podklad = "";
}
echo "<tr><td colspan=\"4\">";
echo "<form action=\"./vzkazy_vsechny.php?kod=$kod\" method=post>";
echo "<input type=\"submit\" name=\"odeslano_promazat\" value = \"vymazat neplatné zprávy\"></td></tr>";
echo "</form>";
echo "</table>";
}
else echo "<p><i>V databázi nejsou ulo¾eny ¾ádné zprávy.</i>";
}
else
{
echo " <input type=submit value=\"zobraz zprávy\" name=\"odeslano\">";
echo "</form>";
echo "<P> </P><P>Poèet záznamù: $pocet";
echo "<form method=\"post\">";
echo "<p><table border=0 cellspacing=0 cellpadding=5>";
Zahlavi_radek(array("Editace", "Mazání", "Tøída", "Pøedmìt", "Datum odeslání", "Platnost do"), "left");
$i=0;
while($zaz=MySQL_fetch_array($vystup))
{
echo "<tr>";
echo "<td><a href=\"./vzkazy_editace.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\"><img src=\"./images/edit.gif\" border=none></a></td>";
echo "<td><input type=\"checkbox\" name=\"vymaz[]\" value=\"".$zaz["id_vzkazu"]."\"></td>";
echo "<td>".$zaz["trida"]."</td>";
echo "<td>".$zaz["predmet"]."</td>";
echo "<td>".Datum($zaz["datum"])."</td>";
echo "<td>".Text_alter(Datum($zaz["platnost_do"], 0), "neuvedena")."</td>";
echo "</tr>";
$i++;
}
echo "<tr><td colspan=\"5\"><input type=\"submit\" name=\"odeslano_vymaz\" value=\"vymazat vybrané zprávy\"></td></tr>";
echo "</table>";
echo "</form>";
}
else echo "<p><i>Neodeslal(a) jste ¾ádnou zprávu.</i>";
}
else
{
if($odeslano_edit)
{
$platnost_do = Datum_datab($platnost_do);
$SQL = "update vzkazy set platnost_do = '$platnost_do' where id = '$id_vzkazu'";
echo "</td></tr>";
} else {
echo "<td><a href=\"viewtask.php?id=" . $tasksrow['taskid'] . "\">" . $tasksrow['taskname'] . "</a>";
echo "</td>";
echo "<td><a href=\"viewproject.php?id=" . $tasksrow['projectid'] . "\">" . getProjectInfoByID($tasksrow['projectid'], 'projectname') . "</a></td>";
echo "<td>" . getTaskStatus($tasksrow['taskid'], $tasksrow['taskstatus']);
if ($tasksrow['is_recurring'] === "1") {
echo "<img title=\"Wiederholende Aufgabe\" style=\"width:21px; margin-left: 5px;\" src=\"img/recur-small.png\">";
}
if ($tasksrow['is_private'] === "1") {
echo "<span class=\"glyphicon glyphicon-lock\" aria-hidden=\"true\"></span>";
}
echo "</td>";
echo "<td>" . Datum($tasksrow['startdate']) . "</td>";
echo "<td>" . Datum($tasksrow['enddate']) . "</td>";
echo "<td>" . Datum($tasksrow['recuruntil']) . "</td>";
echo "</tr>";
}
}
}
}
?>
</tbody>
</table>
</div>
<?php
}
}
?>
</div>
echo "<dl>";
while($zaz=mysql_fetch_array($vystup))
{
echo "<dt><p><small>".Datum($zaz["datum"])."</small></dt>";
echo "<dd><font color=\"red\">".$zaz["text"]."</font></dd>";
}
echo "</dl>";
}
$SQL = "select * from novinky where DATE_ADD(datum, INTERVAL 5 DAY)<Now() order by datum desc";
if(DB_select($SQL, $vystup, $pocet))
{
echo "<dl>";
while($zaz=mysql_fetch_array($vystup))
{
echo "<dt><p><small>".Datum($zaz["datum"])."</small></dt>";
echo "<dd><font color=\"black\">".$zaz["text"]."</font></dd>";
}
echo "</dl>";
}
//****************************************************************
Konec();
endif;
/* funkce pro pricteni libovolneho poctu dni k datumu*/
function day_add_x($datum, $dny)
</tr>
</thead>
<tbody>
<?php
$result = mysqli_query($con, "SELECT * FROM projects");
while ($row = mysqli_fetch_array($result)) {
if (UserIsOwnerOfProject($row['projectid']) || UserCan('show_projects')) {
echo "<tr>";
echo "<td><a href=\"viewproject.php?id=" . $row['projectid'] . "\">" . $row['projectname'] . "</a></td>";
echo "<td>" . getNumberOfOpenTasksinProject($row['projectid']) . "</td>";
echo "<td>" . getNumberOfClosedTasksinProject($row['projectid']) . "</td>";
echo "<td>" . getUserFullName($row['userid'], 'userid') . "</td>";
echo "<td>" . getProjectStatusInPercent($row['projectid']) . "%</td>";
echo "<td>" . getProjectStatus($row['projectid']) . "</td>";
echo "<td>" . Datum($row['startdate']) . "</td>";
echo "<td>" . Datum($row['enddate']) . "</td>";
echo "</tr>";
}
}
?>
</tbody>
</table>
</div>
</div>
<?php
if (UserCan('create_project')) {
?>
<div class="tab-pane" id="newproject">
<form role="form" action="projects.php" method="POST">
<div class="form-group smallform">
<label for="userid"><?php
/**
* Gibt alle Childs für eine Aufgabe aus.
* @param int $id
*/
function RenderChilds($id)
{
require 'config.php';
$sql = "SELECT * FROM tasks WHERE parent = " . $id;
$result = mysqli_query($con, $sql);
echo "<ul>";
while ($row = mysqli_fetch_array($result)) {
echo "<li>";
echo "<a href=\"viewtask.php?id=" . $row['taskid'] . "\">" . $row['taskname'] . "</a> " . getTaskStatus($row['taskid'], $row['taskstatus']) . " — <a href=\"viewuser.php?id=" . $row['userid'] . "\">" . getUserFullName($row['userid']) . "</a> — " . Datum($row['startdate']) . " - " . Datum($row['enddate']);
echo "</li>";
if (TaskHasChilds($row['taskid'])) {
RenderChilds($row['taskid']);
}
}
echo "</ul>";
}
echo "<option value=\"0\" ".$selected[0]."> data ulo¾ení souboru";
echo "<option value=\"1\" ".$selected[1]."> jména odesílatele";
echo "</select>";
echo " <input type=submit value=\"zobraz soubory\" name=\"odeslano\">";
echo "</form>";
echo "<P> </P><P><b>Poèet záznamù:</b> $pocet";
echo "<p><table border=0 cellspacing=0 cellpadding=5>";
Zahlavi_radek(array("Soubor", "Tøída", "Pøedmìt", "Odesílatel", "Velikost", "Datum"), "left");
while($zaz=MySQL_fetch_array($vystup))
{
echo "<tr class=\"tabulka\">";
echo "<td valign=\"top\"><dl><dt>";
$p_adresar="files/".StrToLower($zaz["login_uc"])."/".$zaz["nazev"];
$p_nazev=$zaz["nazev"];
echo "<a class=\"seznam\" href=\"sendfile.php?kod=$kod&p_prava=6&p_nazev=$p_nazev&p_adresar=$p_adresar\">".$zaz["nazev"]."</a></dt>";
echo "<dd><a class=\"vzkaz_small\" href=\"sendfile.php?kod=$kod&p_prava=6&p_adresar=$p_adresar&p_nazev=$p_nazev\"><i>".$zaz["popis"]."</i></a></dd></dl></td>";
echo "<td valign=\"top\"><a class=\"vzkaz_small\" target=\"_new\" href=\"sendfile.php?kod=$kod&p_prava=6&p_nazev=$p_nazev&p_adresar=$p_adresar\">".$zaz["trida"]."</a></td>";
echo "<td valign=\"top\"><a class=\"vzkaz_small\" target=\"_new\" href=\"sendfile.php?kod=$kod&p_prava=6&p_nazev=$p_nazev&p_adresar=$p_adresar\">".$zaz["predmet"]."</a></td>";
echo "<td valign=\"top\"><a class=\"vzkaz_small\" target=\"_new\" href=\"sendfile.php?kod=$kod&p_prava=6&p_nazev=$p_nazev&p_adresar=$p_adresar\">".$zaz["jmeno"]." ".$zaz["prijmeni"]."</a></td>";
echo "<td valign=\"top\"><a class=\"vzkaz_small\" target=\"_new\" href=\"sendfile.php?kod=$kod&p_prava=6&p_nazev=$p_nazev&p_adresar=$p_adresar\">".Prevod($zaz["velikost"])."</a></td>";
echo "<td valign=\"top\"><a class=\"vzkaz_small\" target=\"_new\" href=\"sendfile.php?kod=$kod&p_prava=6&p_nazev=$p_nazev&p_adresar=$p_adresar\">".Datum($zaz["datum"], 0)."</a></td>";
echo "</tr>";
}
echo "</table>";
}
else echo Text_alter("","Nejsou vám urèeny ¾ádné soubory.");
Konec();
}
?>
/* echo "<tr bgcolor=\"#d5d5d5\"><td>termín</td><td>zkratka</td><td>akce</td><td>studium</td></tr>";*/
$radek = "0";
}
$radek++;
if(($radek%2)==1) $pozadi = "#e0e0e0";
else $pozadi = "#efefef";
echo "<tr bgcolor = $pozadi>";
$cas_od = Cas($zaz1["cas_od"]);
$cas_do = Cas($zaz1["cas_do"]);
echo "<td width=\"1\"><a href=\"./plan_kal_editace.php?kod=$kod&vyber=2&odeslano_akce=1&id_akce=".$zaz1["id_kal"]."\"><img src=\"./images/edit.gif\" border=none></a></td>";
echo "<td width=\"1\"><input type=\"checkbox\" name=\"vymaz[]\" value=\"".$zaz1["id_kal"]."\"></td>";
echo "<td><font color=\"$barva_text\">";
echo Datum($zaz1["akce_platnost_od"],0);
if($zaz1["akce_platnost_od"]<>$zaz1["akce_platnost_do"] and $zaz1["akce_platnost_do"]<>"") echo " - ".Datum($zaz1["akce_platnost_do"],0);
if($cas_od<>"")
{
echo " $cas_od";
if($cas_do<>"") echo " - $cas_do";
}
echo "</font></td>";
echo "<td><font color=\"$barva_text\">";
if($zaz1["id_soub"]<>0) echo "<a href=\"sendfile.php?kod=$kod&p_prava=5&p_nazev=".$zaz1["nazev"]."&p_adresar=files_kalendar/".$zaz1["nazev"]."\"><img src=\"./images/doc3.gif\" border=\"0\"></a>";
echo "</font></td>";
echo "<td>";
if($zaz1["zkratky"]<>0) echo $zaz1["zkratky"];
echo "</font></td>";
<input type="text" class="input-sm form-control" name="startdate" placeholder="<?php
echo $message['startdate'];
?>
" value="<?php
echo Datum(getTaskInfobyID($_GET['id'], 'startdate'));
?>
"/>
<span class="input-group-addon"><?php
echo $message['to'];
?>
</span>
<input type="text" class="input-sm form-control" name="enddate" placeholder="<?php
echo $message['enddate'];
?>
" value="<?php
echo Datum(getTaskInfobyID($_GET['id'], 'enddate'));
?>
"/>
</div>
</div>
<br>
<button type="submit" class="btn btn-default" name="addtask"><?php
echo $message['add'];
?>
</button>
</form>
</div>
<?php
}
?>
<div class="tab-pane" id="history">
if($platnost_od<>$platnost_do and Datum($platnost_do,0)<>"") echo " - ".Datum($platnost_do,0);
if($cas_od<>"")
{
echo " $cas_od";
if($cas_do<>"") echo " - $cas_do";
}
if($hod_od<>"")
{
echo " $hod_od.";
if($hod_do<>"") echo " - $hod_do.";
echo " h.";
}
echo "</font></td>";
echo "<td><font color=\"$barva_text\">".$zaz["popis"]."</font></td>";
echo "<td><font color=\"$barva_text\">".Datum($zaz["datum"])."</font></td>";
echo "</tr>";
if($b==0)
{
$barva = "bgcolor=\"#efefef\"";
$b = 1;
}
else
{
$barva = "bgcolor=\"#e0e0e0\"";
$b = 0;
}
}
echo "<tr><td colspan=\"5\"><input type=\"submit\" name=\"odesli\" value=\"vymazat vybrané zprávy\"></td></tr>";
echo "</table>";
echo "</form>";
?>
:</label>
<textarea class="form-control" id="Details" name="taskdetails" maxlength="255"></textarea>
</div>
<div id="sandbox-container" class="smallform">
<div class="input-daterange input-group" id="datepicker">
<input type="text" class="input-sm form-control" name="startdate" value="<?php
echo Datum(getProjectInfoByID($_GET['id'], 'startdate'));
?>
"/>
<span class="input-group-addon"><?php
echo $message['to'];
?>
</span>
<input type="text" class="input-sm form-control" name="enddate" value="<?php
echo Datum(getProjectInfoByID($_GET['id'], 'enddate'));
?>
"/>
</div>
</div>
<button type="submit" class="btn btn-default" name="addtask"><?php
echo $message['add'];
?>
</button>
</form>
</div>
</div>
</div>
else
{
$SQL = "select * from soubory where typ='$typ' order by datum desc";
if($typ=="k_zpravodaj") $bunka = "<td><b><center>pøílohy</center></b></td>";
else $bunka="";
if(DB_select($SQL, $vystup, $pocet))
{
if($pocet>0)
{
echo "<table border=0 cellspacing=2 cellpadding=5>";
echo "<tr bgcolor=\"#dddddd\"><td><b><center>soubor</center></b></td><td><b><center>datum ulo¾ení</center></b></td>$bunka</tr>";
while($zaz=mysql_fetch_array($vystup))
{
echo "<tr class=\"tabulka\"><td><a class=\"seznam\" href=\"sendfile.php?kod=$kod&p_prava=5&p_nazev=".$zaz["nazev"]."&p_adresar=files_kraj/".$zaz["nazev"]."\">".$zaz["popis"]."</a></td>";
echo "<td><span class=\"seznam_text\">".Datum($zaz["datum"])."</span></td>";
if($zaz["typ"]==k_zpravodaj)
{
$SQL2 = "select * from soubory where id_zprav='".$zaz["id"]."'";
if(DB_select($SQL2, $vystup2, $pocet2)) if($pocet2<>0)
echo "<td><a class=\"seznam\" href=\"./k_forms.php?kod=$kod&typ=$typ&zprav=".$zaz["popis"]."&pril=".$zaz["id"]."\">zobrazit pøílohy</a></td>";
else echo "<td></td>";
echo "</tr>";
}
}
echo "</table>";
}
else echo Text_alter("", "®ádný soubor tohoto typu nebyl na server ulo¾en.");
}
Konec();
}
if(DB_select($SQL, $vystup, $pocet))
if($pocet>0)
{
echo "<b>Poèet záznamù:</b> $pocet";
echo "<p><table border=0 cellspacing=0 cellpadding=5>";
Zahlavi_radek(array(" ", "Tøída", "Pøedmìt", "Odesílatel", " ", "Datum"), "left");
$i=0;
while($zaz=MySQL_fetch_array($vystup))
{
echo "<tr class=\"tabulka\">";
echo "<td><a class=\"vzkaz\" href=\"./vzkazy_vedeni.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\"><img src=\"./images/oko.gif\" border=\"none\"></a></td>";
echo "<td><a class=\"vzkaz\" href=\"./vzkazy_vedeni.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\">".$zaz["trida"]."</a></td>";
echo "<td><a class=\"vzkaz\" href=\"./vzkazy_vedeni.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\">".$zaz["predmet"]."</a></td>";
echo "<td><a class=\"vzkaz\" href=\"./vzkazy_vedeni.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\">".$zaz["jmeno"]." ".$zaz["prijmeni"]."</a></td>";
echo "<td><a class=\"vzkaz\" href=\"./vzkazy_vedeni.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\">(".$zaz["skupina"].")</a></td>";
echo "<td><a class=\"vzkaz\" href=\"./vzkazy_vedeni.php?kod=$kod&id_vzkazu=".$zaz["id_vzkazu"]."\">".Datum($zaz["datum"])."</a></td>";
echo "</tr>";
$i++;
}
echo "</table>";
}
else echo Text_alter("","Nemáte ¾ádné zprávy.");
}
else
{
$SQL = "select * from vzkazy v, skupiny s, ucitele u
where v.id = '$id_vzkazu' and s.id = v.id_skup_odesilatel and u.login = v.login_uc";
if(DB_select($SQL, $vystup, $pocet))
{
echo "<table>";
echo "<tr><td><a href=\"./vzkazy_vedeni.php?kod=$kod\"><img src=\"./images/sipka.gif\" border=none></a></td></tr>";
?>
",
calendarWeeks: true,
startDate: "2015.27.08"
});
});
</script>
<script type="text/javascript">
$( document ).ready(function() {
$('#sandbox-container-taskrecurrence .input-group.date').datepicker({
language: "<?php
echo $_COOKIE['lang'];
?>
",
startDate: "<?php
echo Datum(DATE('m-d-Y'));
?>
"
});
});
</script>
<script>
$(document).on("click", ".writereply", function () {
var commentid = $(this).data('id');
$(".modal-body #comment-id").val( commentid );
});
</script>
</body>
</html>
<?php
function Soubory($login_uc)
{
global $kod;
global $skupina;
echo "<p><h3>Odeslané soubory</h3>";
if($skupina>=20) $podminka = "(vs.id_skup = '$skupina' or vs.id_skup = '-1' or vs.id_skup = '-2')";
else $podminka = "(vs.id_skup = '$skupina' or vs.id_skup = '-2')";
$SQL = " select distinct v.id, v.popis popis, v.datum datum,
v.nazev nazev, v.velikost velikost,
v.login_uc login_uc,
u.jmeno jmeno, u.prijmeni prijmeni, v.trida, v.predmet
from soubory_skupiny vs, soubory v, ucitele u
where u.login=v.login_uc and
v.id = vs.id_soub and
v.login_uc = '$login_uc' and
$podminka
order by v.datum ";
if(DB_select($SQL, $vystup, $pocet))
if($pocet>0)
{
echo "<p><table border=0 cellspacing=2 cellpadding=5>";
echo "<tr><td colspan=3><p><b>Poèet záznamù:</b> $pocet</td></tr>";
echo "<tr bgcolor=\"#dddddd\"><td><center><b>soubor</b></center></td><td>
<center><b>tøída</b></center></td><td><center><b>pøedmìt</b></center></td><td><center><b>velikost</b></center></td><td><center><b>datum</b></center></td></tr>";
while($zaz=MySQL_fetch_array($vystup))
{
echo "<tr>";
echo "<td valign=\"top\"><dl><dt><a
href=\"".c_files.StrToLower($zaz["login_uc"])."/".$zaz["nazev"]."\">".$zaz["nazev"]."</a></dt>";
echo "<dd><small><i>".$zaz["popis"]."</i></small></dd></dl></td>";
echo "<td valign=\"top\"><small>".$zaz["trida"]."</small></td>";
echo "<td valign=\"top\"><small>".$zaz["predmet"]."</small></td>";
echo "<td valign=\"top\"><small>".Prevod($zaz["velikost"])."</small></td>";
echo "<td valign=\"top\"><small>".Datum($zaz["datum"], 0)."</small></td>";
echo "</tr>";
}
echo "</table>";
}
else echo "<p>".Text_alter("", "nejsou vám urèeny ¾ádné soubory");
}
$count = $count + $colwidth;
$x = $pdf->GetX();
$array_total[$arraycount] = $array_total[$arraycount] + $fee_weekly;
$array_profit[$arraycount] = $array_profit[$arraycount] + $profit_weekly;
$arraycount++;
}
$pdf->Cell(0, 0, '', 0, 1, L);
}
$pdf->Cell(0, $rowheight, '', 0, 1, L);
//if ((BeginWeek(AssessDays($ts_datum_commence)) + $ts_datum_length) < $ts_fee_conclude) { $color_array = array(255,0,0); } else { unset($color_array); }
if ($array_proj['ts_fee_commence'] != $array_proj['ts_datum_commence'] or $array_proj['ts_fee_time_end'] > $array_proj['ts_datum_length']) {
$color_array = array(225, 0, 0);
} else {
unset($color_array);
}
Datum($ts_datum_commence, $ts_datum_length, $color_array);
$pdf->Cell(0, 1, '', 0, 1, L);
}
$current_proj = $proj_id;
if ($pdf->GetY() > 170) {
$pdf->addPage(L);
DrawGrid();
}
}
$pdf->addPage(L);
DrawGrid();
// Now add the totals at the end
$x = 0;
$pdf->SetFont('Helvetica', 'B', 8);
$pdf->Cell(0, 5, '', 0, 1, L);
$pdf->Cell(40, 5, "TOTAL", 0, 0, L);
