blob: bb57acb5b9fcce6d992fb7b5f6c3ab6dda88d994 [file] [log] [blame]
<?php
/*
* hores
* Copyright (c) 2023 Adrià Vilanova Martínez
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public
* License along with this program.
* If not, see http://www.gnu.org/licenses/.
*/
require_once("core.php");
security::checkType(security::WORKER);
security::checkWorkerUIEnabled();
$isAdmin = security::isAllowed(security::ADMIN);
$mainURL = (security::isAdminView() ? "export.php" : "export4worker.php");
if (!security::checkParams("GET", [
["begins", security::PARAM_ISDATE],
["ends", security::PARAM_ISDATE],
["workers", security::PARAM_ISARRAY],
["format", security::PARAM_ISINT]
])) {
security::go($mainURL."?msg=empty");
}
$ignoreempty = (isset($_GET["ignoreempty"]) && $_GET["ignoreempty"] == 1);
$labelinvalid = (isset($_GET["labelinvalid"]) && $_GET["labelinvalid"] == 1);
$showvalidated = (isset($_GET["showvalidated"]) && $_GET["showvalidated"] == 1);
$shownotvalidated = (isset($_GET["shownotvalidated"]) && $_GET["shownotvalidated"] == 1);
$begins = new DateTime($_GET["begins"]);
$ends = new DateTime($_GET["ends"]);
$interval = new DateInterval("P1D");
if (!intervals::wellFormed([$begins, $ends])) {
security::go($mainURL."?msg=inverted");
}
$date = new DateTime(date("Y-m-d")."T00:00:00");
$interval = new DateInterval("P1D");
$date->sub($interval);
if ($ends->diff($date)->invert !== 0) {
security::go($mainURL."?msg=forecastingthefutureisimpossible");
}
$companies = companies::getAll(false, true);
if ($companies === false) {
security::go($mainURL."?msg=unexpected");
}
$filenameDate = $begins->format("Ymd")."_".$ends->format("Ymd");
if (!$isAdmin && !in_array($_GET["format"], export::$workerFormats)) {
echo "Todavía no implementado.\n";
exit();
}
switch ($_GET["format"]) {
case export::FORMAT_PDF:
case export::FORMAT_DETAILEDPDF:
require_once("lib/fpdf/fpdf.php");
require_once("lib/fpdf-easytable/exfpdf.php");
require_once("lib/fpdf-easytable/easyTable.php");
$actualTime = time();
class PDF extends exFPDF {
function Footer() {
global $actualTime;
$this->SetFont('Arial','I',10);
$this->SetY(-20);
$this->Cell(0, 10, export::convert("Generado: ".date::getShortDateWithTime($actualTime)), 0, 0, 'L');
$this->SetY(-20);
$this->Cell(0, 10, $this->PageNo().'/{nb}', 0, 0, 'R');
}
}
$pdf = new PDF();
$pdf->SetCompression(true);
$pdf->SetCreator(export::convert($conf["appName"]));
$pdf->SetTitle(export::convert("Registro".($showvalidated && !$shownotvalidated ? " (validados)" : "").(!$showvalidated && $shownotvalidated ? " (no validados)" : "")));
$pdf->SetAutoPageBreak(false, 22);
$pdf->AliasNbPages();
$pdf->SetFont('Arial','',12);
$headerCells = ["Fecha", "Inicio jornada", "Fin jornada", "Desayuno", "Comida", ""];
$headerCells = array_map(function($value) {
return export::convert($value);
}, $headerCells);
$spacingDayRow = "%{18, 18, 18, 19, 19, 8}";
foreach ($_GET["workers"] as $workerid) {
$worker = workers::get($workerid);
if ($worker === false || (!$isAdmin && $worker["person"] != $_SESSION["id"])) continue;
$days = export::getDays($worker["id"], $begins->getTimestamp(), $ends->getTimestamp(), $showvalidated, $shownotvalidated);
if (count($days) || !$ignoreempty) {
$pdf->AddPage();
$pdf->SetMargins(17, 17);
$pdf->SetY(17);
$header = new easyTable($pdf, 1, 'border-width: 0.01; border: 0; align: L;');
$header->easyCell(export::convert($worker["name"].(!empty($worker["dni"]) ? " (".$worker["dni"].")" : "")), 'font-style:B;');
$header->printRow();
$header->easyCell(export::convert($worker["companyname"].(!empty($companies[$worker["company"]]["cif"]) ? " (CIF: ".$companies[$worker["company"]]["cif"].")" : "")));
$header->printRow();
$header->endTable(6);
}
if (count($days)) {
$totalEffectiveTime = 0;
$totalWorkTime = 0;
$incidentsTime = [];
$table = new easyTable($pdf, $spacingDayRow, 'border: "TB"; border-width: 0.15;');
foreach ($headerCells as $i => $cell) {
$table->easyCell($cell, 'font-style: B;'.($i == 0 ? "" : " align: C;"));
}
$table->printRow(true);
$table->endTable(0);
foreach ($days as $timestamp => $day) {
$issetSchedule = isset($day["schedule"]);
$showSchedule = $issetSchedule;
if ($showSchedule && isset($day["incidents"])) {
foreach ($day["incidents"] as $incident) {
if ($incident["allday"] == true && $incident["typepresent"] == 0) {
$showSchedule = false;
break;
}
}
}
$workInt = ($issetSchedule ? [$day["schedule"]["beginswork"], $day["schedule"]["endswork"]] : [incidents::STARTOFDAY, incidents::STARTOFDAY]);
$notWorkIntA = ($issetSchedule ? [incidents::STARTOFDAY, $day["schedule"]["beginswork"]] : [incidents::STARTOFDAY, incidents::ENDOFDAY]);
$notWorkIntB = ($issetSchedule ? [$day["schedule"]["endswork"], incidents::ENDOFDAY] : [incidents::ENDOFDAY, incidents::ENDOFDAY]);
$breakfastInt = ($issetSchedule ? [$day["schedule"]["beginsbreakfast"], $day["schedule"]["endsbreakfast"]] : [incidents::STARTOFDAY, incidents::STARTOFDAY]);
$lunchInt = ($issetSchedule ? [$day["schedule"]["beginslunch"], $day["schedule"]["endslunch"]] : [incidents::STARTOFDAY, incidents::STARTOFDAY]);
$effectiveTime = intervals::measure($workInt) - (intervals::measure($breakfastInt) + intervals::measure($lunchInt));
$totalWorkTime += $effectiveTime;
if (isset($day["incidents"])) {
foreach ($day["incidents"] as &$incident) {
$incidentInt = [$incident["begins"], $incident["ends"]];
$incidentTime = 0;
if ($incident["typepresent"] == 1) {
$incidentTime = intervals::measureIntersection($incidentInt, $notWorkIntA) + intervals::measureIntersection($incidentInt, $notWorkIntB) + intervals::measureIntersection($incidentInt, $breakfastInt) + intervals::measureIntersection($incidentInt, $lunchInt);
$effectiveTime = $effectiveTime + $incidentTime;
$incidentTime = -$incidentTime;
} else {
$incidentTime = intervals::measureIntersection($incidentInt, $workInt) - ($conf["pdfs"]["workersAlwaysHaveBreakfastAndLunch"] ? 0 : (intervals::measureIntersection($incidentInt, $breakfastInt) + intervals::measureIntersection($incidentInt, $lunchInt)));
$effectiveTime = $effectiveTime - $incidentTime;
}
$incidentsTime[$incident["typename"]] = (isset($incidentsTime[$incident["typename"]]) ? $incidentsTime[$incident["typename"]] : 0) + $incidentTime;
}
}
$effectiveTime = max(incidents::STARTOFDAY, min($effectiveTime, incidents::ENDOFDAY));
$totalEffectiveTime += $effectiveTime;
$labelAsInvalid = ($shownotvalidated && isset($day["schedule"]) && $day["schedule"]["state"] === registry::STATE_REGISTERED);
$table = new easyTable($pdf, $spacingDayRow, 'border: "BT";'.(isset($day["incidents"]) ? ' border-width: 0.07; border-color: #555;' : ' border-width: 0.15;').($labelAsInvalid && $labelinvalid ? ' font-color: #F00;' : ''));
$table->easyCell(export::convert(date("d/m/Y", $timestamp).($labelAsInvalid ? " (nv)" : "")));
$table->easyCell(export::convert(($showSchedule ? schedules::sec2time($day["schedule"]["beginswork"]) : "-")), 'align: C;');
$table->easyCell(export::convert(($showSchedule ? schedules::sec2time($day["schedule"]["endswork"]) : "-")), 'align: C;');
$table->easyCell(export::convert(($showSchedule ? (intervals::measure($breakfastInt) == 0 ? "-" : (!$conf["pdfs"]["showExactTimeForBreakfastAndLunch"] ? export::sec2hours(intervals::measure($breakfastInt)) : schedules::sec2time($day["schedule"]["beginsbreakfast"])." - ".schedules::sec2time($day["schedule"]["endsbreakfast"]))) : "-")), 'align: C;');
$table->easyCell(export::convert(($showSchedule ? (intervals::measure($lunchInt) == 0 ? "-" : (!$conf["pdfs"]["showExactTimeForBreakfastAndLunch"] ? export::sec2hours(intervals::measure($lunchInt)) : schedules::sec2time($day["schedule"]["beginslunch"])." - ".schedules::sec2time($day["schedule"]["endslunch"]))) : "-")), 'align: C;');
$table->easyCell(export::convert(export::sec2hours($effectiveTime)), 'font-style: B; align: R;');
$table->printRow();
$table->endTable(0);
if (isset($day["incidents"])) {
$incidentstable = new easyTable($pdf, "%{7, 15, 20, 20, 38}", 'border: "BT"; border-width: 0.15; font-color: #555;');
foreach ($day["incidents"] as &$incident) {
$labelAsInvalid = ($incident["state"] === incidents::STATE_REGISTERED);
if ($labelAsInvalid && $labelinvalid) $incidentstable->rowStyle('font-color: #F00;');
$incidentstable->easyCell("");
$incidentstable->easyCell(export::convert("Incidencia:"), 'font-style: B;');
$incidentstable->easyCell(export::convert($incident["typename"]), 'align: C; font-size: 11;');
$incidentstable->easyCell(export::convert("(".(($incident["begins"] == 0 && $incident["ends"] == incidents::ENDOFDAY) ? "todo el día" : schedules::sec2time($incident["begins"])." - ".schedules::sec2time($incident["ends"])).")"), 'align: C;');
$incidentstable->easyCell(export::convert((!empty($incident["details"]) ? "Obs.: ".$incident["details"] : "").($labelAsInvalid ? "\n(No validada)" : "")), 'font-size: 10;');
$incidentstable->printRow();
}
$incidentstable->endTable(0);
}
}
if ($_GET["format"] == export::FORMAT_DETAILEDPDF) {
$pdf->Ln();
$pdf->Ln();
$table = new easyTable($pdf, "%{77, 23}", 'align: R; width: 100; border: "BT"; border-width: 0.15;');
$table->easyCell(export::convert("Tiempo de trabajo programado"));
$table->easyCell(export::convert(export::sec2hours($totalWorkTime)), 'align: R;');
$table->printRow();
foreach ($incidentsTime as $incidentName => $incidentTime) {
$table->easyCell(export::convert($incidentName));
$table->easyCell(export::convert(($incidentTime <= 0 ? "+" : "\u{2013}")." ".export::sec2hours(abs($incidentTime))), 'align: R;');
$table->printRow();
}
$table->easyCell(export::convert("Tiempo trabajado"), 'font-style: B;');
$table->easyCell(export::convert(export::sec2hours($totalEffectiveTime)), 'align: R; font-style: B;');
$table->printRow();
$table->endTable(0);
}
} elseif (!$ignoreempty) {
$pdf->Cell(0, 0, "No hay datos para este trabajador.", 0, 0, 'C');
}
}
$pdf->Output("I", "registrohorario_".$filenameDate.".pdf");
break;
case export::FORMAT_CSV_SCHEDULES:
case export::FORMAT_CSV_INCIDENTS:
$isSchedules = ($_GET["format"] == export::FORMAT_CSV_SCHEDULES);
$field = ($isSchedules ? "schedule" : "incidents");
header("Content-Type: text/csv");
header("Content-Disposition: attachment;filename=".($isSchedules ? "schedules_".$filenameDate.".csv" : "incidents_".$filenameDate.".csv"));
$array = [];
$array[] = ($isSchedules ? export::$schedulesFields : export::$incidentsFields);
foreach ($_GET["workers"] as $workerid) {
$worker = workers::get($workerid);
if ($worker === false || (!$isAdmin && $worker["person"] != $_SESSION["id"])) continue;
$days = export::getDays($worker["id"], $begins->getTimestamp(), $ends->getTimestamp(), true, true);
foreach ($days as &$day) {
if (isset($day[$field])) {
if ($isSchedules) {
$schedule = [];
foreach (export::$schedulesFields as $i => $key) {
$types = ["breakfast", "lunch"];
$typesNotDefined = [];
foreach ($types as $type) {
if (intervals::measure([$day[$field]["begins".$type], $day[$field]["ends".$type]]) == 0) {
$typesNotDefined[] = "begins".$type;
$typesNotDefined[] = "ends".$type;
}
}
switch ($key) {
case "worker":
$schedule[$i] = $worker["name"];
break;
case "company":
$schedule[$i] = $worker["companyname"];
break;
case "workerid":
$schedule[$i] = $worker["id"];
break;
case "dni":
$schedule[$i] = $worker["dni"];
break;
case "day":
$schedule[$i] = date("d/m/Y", $day[$field][$key]);
break;
case "state":
$schedule[$i] = (registry::$stateTooltips[$day[$field][$key]]);
break;
case "beginswork":
case "endswork":
case "beginsbreakfast":
case "endsbreakfast":
case "beginslunch":
case "endslunch":
$schedule[$i] = (in_array($key, $typesNotDefined) ? "-" : schedules::sec2time($day[$field][$key]));
break;
default:
$schedule[$i] = $day[$field][$key];
}
}
$array[] = $schedule;
} else {
foreach ($day[$field] as &$incident) {
$convIncident = [];
foreach (export::$incidentsFields as $i => $key) {
switch ($key) {
case "worker":
$convIncident[$i] = $worker["name"];
break;
case "company":
$convIncident[$i] = $worker["companyname"];
break;
case "workerid":
$convIncident[$i] = $worker["id"];
break;
case "dni":
$convIncident[$i] = $worker["dni"];
break;
case "creator":
case "updatedby":
case "confirmedby":
$convIncident[$i] = (($key == "updatedby" && $incident["updatestate"] != 1) ? "-" : people::userData("name", $incident[$key]));
break;
case "day":
$convIncident[$i] = date("d/m/Y", $incident[$key]);
break;
case "begins":
case "ends":
$convIncident[$i] = ($incident["allday"] == 1 ? "-" : schedules::sec2time($incident[$key]));
break;
case "updated":
case "verified":
case "typepresent":
case "typepaid":
if ($key == "updated") $key = "updatestate";
$convIncident[$i] = ($incident[$key] == -1 ? "-" : ($incident[$key] == 1 ? visual::YES : visual::NO));
break;
case "allday":
$convIncident[$i] = ($incident[$key] == 1 ? visual::YES : visual::NO);
break;
case "state":
$convIncident[$i] = (incidents::$stateTooltips[$incident[$key]]);
break;
case "type":
$convIncident[$i] = $incident["typename"];
break;
default:
$convIncident[$i] = $incident[$key];
}
}
$array[] = $convIncident;
}
}
}
}
}
if (!count($array)) exit();
$df = fopen("php://output", 'w');
foreach ($array as $row) fputcsv($df, $row);
fclose($df);
break;
default:
header("Content-Type: text/plain;");
echo "Todavía no implementado.\n";
}