<th>poznamka</th>
</tr>
<?php
$total = 0;
for ($day = 1; checkdate($_GET["month"], $day, $_GET["year"]); $day++) {
$date = date_to_string($_GET["year"], $_GET["month"], $day);
$time = db_get_condition("overtimes", "time", "date='" . $date . "' AND employee='" . $_GET["employee"] . "'");
if (!$time) {
continue;
}
$time = datetime_to_secs($time);
if ($time == 0) {
continue;
}
$daytype = weekdayname($_GET["year"], $_GET["month"], $day);
if (db_get_condition("vacancies", "date", "date='" . $date . "'")) {
$daytype .= " + svatek";
}
$note = db_get_condition("comments", "text", "date='" . $date . "' AND employee='" . $_GET["employee"] . "'");
$total += $time;
echo "<tr>";
echo "<td>" . $day . "." . $_GET["month"] . ". " . $_GET["year"] . "</td>";
echo "<td>" . $daytype . "</td>";
echo "<td>" . secs_to_time($time) . "</td>";
echo "<td>" . $note . "</td>";
echo "</tr>";
echo "\n";
}
?>
</table>
function month_totals($year, $month, $employee, $print)
{
$total["odpracovano"] = 0;
$total["plusminus"] = 0;
$total['overtime'] = 0;
$total["days_nemoc"] = 0;
$total["days_dovolena"] = 0;
$total["stravenky"] = 0;
$total["diety_kc"] = 0;
$total["error"] = false;
if ($print) {
echo "<table class=\"maxwidth\">";
echo "<tr>";
echo "<th colspan=\"2\">den</th>";
echo "<th>průchody</th>";
echo "<th>odprac.</th>";
echo "<th>+/-</th>";
echo "<th>uznaný přesčas</th>";
echo "<th>stav</th>";
echo "<th>diety/strav.</th>";
echo "<th>poznámka</th>";
echo "</tr>";
}
for ($day = 1; checkdate($month, $day, $year); $day++) {
$dt = day_totals($year, $month, $day, $employee);
$total["odpracovano"] += $dt["odpracovano"];
$total["plusminus"] += $dt["plusminus"];
$total["overtime"] += $dt["overtime_time"];
if ($dt["status_type"] == "nemoc") {
$total["days_nemoc"]++;
}
if ($dt["status_type"] == "dovolena") {
$total["days_dovolena"]++;
}
$total["stravenky"] += $dt["stravenky"];
$total["diety_kc"] += $dt["diety_kc"];
if ($dt["error"]) {
$total["error"] = true;
}
if ($print) {
$str_date = $year . "-" . $month . "-" . $day;
if (is_workday($year, $month, $day)) {
echo "<tr class=\"workday\">";
} else {
echo "<tr class=\"noworkday\">";
}
echo "<td>" . $day . "</td>";
echo "<td>" . weekdayname($year, $month, $day) . "</td>";
echo $dt["error"] ? "<td class=\"error\">" : "<td>";
echo $dt["daylog"];
if (auth()) {
echo " <a href=\"list_actions.php?date=" . $str_date . "&employee=" . $_GET["employee"] . "\">(*)</a>";
}
echo "</td>";
echo "<td>" . secs_to_time($dt["odpracovano"]) . "</td>";
echo "<td>" . secs_to_time($dt["plusminus"]) . "</td>";
echo "<td>";
echo secs_to_time($dt["overtime_time"]);
if (auth()) {
if ($dt["overtime_id"]) {
echo " <a href=\"form_overtime_edit.php?from_id=" . $dt["overtime_id"] . "&id=" . $dt["overtime_id"] . "\">(*)</a>";
echo " <a href=\"form_overtime_delete.php?id=" . $dt["overtime_id"] . "\">(-)</a>";
} else {
echo " <a href=\"form_overtime_edit.php?date=" . $str_date . "&employee=" . $_GET["employee"] . "&time=" . secs_to_time($dt["plusminus"]) . "\">(+)</a>";
}
}
echo "</td>";
echo "<td>";
echo $dt["status_type"];
if (strlen($dt["status_type"])) {
echo "/";
}
if (is_holiday($year, $month, $day)) {
echo "svátek";
}
if (auth()) {
if ($dt["status_id"]) {
echo " <a href=\"form_day_edit.php?from_id=" . $dt["status_id"] . "&id=" . $dt["status_id"] . "\">(*)</a>";
echo " <a href=\"form_day_delete.php?id=" . $dt["status_id"] . "\">(-)</a>";
} else {
echo " <a href=\"form_day_edit.php?date=" . $str_date . "&employee=" . $_GET["employee"] . "\">(+)</a>";
}
}
echo "</td>";
echo "<td>";
echo $dt["diety_kc"] . "/" . $dt["stravenky"];
if (auth()) {
if ($dt["diety_id"]) {
echo " <a href=\"form_diety_edit.php?from_id=" . $dt["diety_id"] . "&id=" . $dt["diety_id"] . "\">(*)</a>";
echo " <a href=\"form_diety_delete.php?id=" . $dt["diety_id"] . "\">(-)</a>";
} else {
echo " <a href=\"form_diety_edit.php?date=" . $str_date . "&employee=" . $_GET["employee"] . "\">(+)</a>";
}
}
echo "</td>";
echo "<td>";
echo $dt["comment_text"];
if (auth()) {
if ($dt["comment_id"]) {
echo " <a href=\"form_comment_edit.php?from_id=" . $dt["comment_id"] . "&id=" . $dt["comment_id"] . "\">(*)</a>";
echo " <a href=\"form_comment_delete.php?id=" . $dt["comment_id"] . "\">(-)</a>";
} else {
echo " <a href=\"form_comment_edit.php?date=" . $str_date . "&employee=" . $_GET["employee"] . "\">(+)</a>";
}
}
echo "</td>";
echo "</tr>\n";
}
}
if ($print) {
echo "</table>";
}
return $total;
}
