$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);