Project import generated by Copybara.
GitOrigin-RevId: 63746295f1a5ab5a619056791995793d65529e62
diff --git a/src/inc/schedules.php b/src/inc/schedules.php
new file mode 100644
index 0000000..87b5ed6
--- /dev/null
+++ b/src/inc/schedules.php
@@ -0,0 +1,456 @@
+<?php
+class schedules {
+ const STATUS_NO_ACTIVE_SCHEDULE = 0;
+ const STATUS_HALFWAY_CONFIGURED_SCHEDULE = 1;
+ const STATUS_ACTIVE_SCHEDULE = 2;
+
+ public static $allEvents = ["work", "breakfast", "lunch"];
+ public static $otherEvents = ["breakfast", "lunch"];
+ public static $otherEventsDescription = [
+ "breakfast" => "Desayuno",
+ "lunch" => "Comida"
+ ];
+ public static $workerScheduleStatus = [
+ 0 => "No hay ningún calendario activo",
+ 1 => "Hay un calendario activo pero no está completamente configurado",
+ 2 => "Hay un calendario activo completamente configurado"
+ ];
+ public static $workerScheduleStatusShort = [
+ 0 => "No hay un horario activo",
+ 1 => "No está configurado del todo",
+ 2 => "Existe uno configurado"
+ ];
+ public static $workerScheduleStatusColors = [
+ 0 => "red",
+ 1 => "orange",
+ 2 => "green"
+ ];
+
+ public static function time2sec($time) {
+ $e = explode(":", $time);
+ return ((int)$e[0]*60 + (int)$e[1])*60;
+ }
+
+ public static function sec2time($sec, $autoShowSeconds = true) {
+ $min = floor($sec/60);
+ $secr = $sec % 60;
+ return visual::padNum(floor($min/60), 2).":".visual::padNum(($min % 60), 2).($autoShowSeconds && $secr != 0 ? ":".visual::padNum($secr, 2) : "");
+ }
+
+ // TEMPLATES:
+
+ public static function addTemplate($name, $ibegins, $iends) {
+ global $con;
+
+ $sname = db::sanitize($name);
+ $begins = new DateTime($ibegins);
+ $sbegins = (int)$begins->getTimestamp();
+ $ends = new DateTime($iends);
+ $sends = (int)$ends->getTimestamp();
+
+ if (!intervals::wellFormed([$sbegins, $sends])) return 2;
+
+ return (mysqli_query($con, "INSERT INTO scheduletemplates (name, begins, ends) VALUES ('$sname', $sbegins, $sends)") ? 0 : 1);
+ }
+
+ private static function _addDaysToReturn(&$return, $stableDays, $sfieldSchedule, $sid) {
+ global $con;
+
+ $return["days"] = [];
+
+ $query2 = mysqli_query($con, "SELECT * FROM $stableDays WHERE $sfieldSchedule = $sid ORDER BY typeday ASC, day ASC");
+
+ while ($row = mysqli_fetch_assoc($query2)) {
+ if (!isset($return["days"][$row["typeday"]]))
+ $return["days"][$row["typeday"]] = [];
+
+ $return["days"][$row["typeday"]][$row["day"]] = $row;
+ }
+ }
+
+ private static function _get($id, $table, $tableDays, $fieldSchedule) {
+ global $con;
+
+ $sid = (int)$id;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+ $stableDays = preg_replace("/[^A-Za-z0-9 ]/", '', $tableDays);
+ $sfieldSchedule = preg_replace("/[^A-Za-z0-9 ]/", '', $fieldSchedule);
+
+ $query = mysqli_query($con, "SELECT * FROM $stable WHERE id = $sid");
+
+ if ($query === false || !mysqli_num_rows($query)) return false;
+
+ $return = mysqli_fetch_assoc($query);
+
+ self::_addDaysToReturn($return, $stableDays, $sfieldSchedule, $sid);
+
+ return $return;
+ }
+
+ public static function getTemplate($id) {
+ return self::_get($id, "scheduletemplates", "scheduletemplatesdays", "template");
+ }
+
+ public static function getTemplates() {
+ global $con, $conf;
+
+ $query = mysqli_query($con, "SELECT * FROM scheduletemplates ORDER BY ".($conf["debug"] ? "id" : "name")." ASC");
+
+ $templates = [];
+
+ while ($row = mysqli_fetch_assoc($query)) {
+ $templates[] = $row;
+ }
+
+ return $templates;
+ }
+
+ public static function editTemplate($id, $name, $ibegins, $iends) {
+ global $con;
+
+ $sid = (int)$id;
+ $sname = db::sanitize($name);
+ $begins = new DateTime($ibegins);
+ $sbegins = (int)$begins->getTimestamp();
+ $ends = new DateTime($iends);
+ $sends = (int)$ends->getTimestamp();
+
+ if (!intervals::wellFormed([$sbegins, $sends])) return 2;
+
+ return (mysqli_query($con, "UPDATE scheduletemplates SET name = '$sname', begins = $sbegins, ends = $sends WHERE id = $sid LIMIT 1") ? 0 : 1);
+ }
+
+ public static function _remove($id, $table, $tableDays, $fieldSchedule) {
+ global $con;
+
+ $sid = (int)$id;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+ $stableDays = preg_replace("/[^A-Za-z0-9 ]/", '', $tableDays);
+ $sfieldSchedule = preg_replace("/[^A-Za-z0-9 ]/", '', $fieldSchedule);
+
+ return (mysqli_query($con, "DELETE FROM $stable WHERE id = $sid LIMIT 1") && mysqli_query($con, "DELETE FROM $stableDays WHERE $fieldSchedule = $sid"));
+ }
+
+ public static function removeTemplate($id) {
+ return self::_remove($id, "scheduletemplates", "scheduletemplatesdays", "template");
+ }
+
+ private static function _exists($id, $table) {
+ global $con;
+
+ $sid = (int)$id;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+
+ $query = mysqli_query($con, "SELECT id FROM $stable WHERE id = ".(int)$id);
+
+ return (mysqli_num_rows($query) > 0);
+ }
+
+ public static function templateExists($id) {
+ return self::_exists($id, "scheduletemplates");
+ }
+
+ public static function checkAddDayGeneric($begins, $ends, $beginsb, $endsb, $beginsl, $endsl) {
+ global $con;
+
+ $times = [];
+ $times["work"] = [$begins, $ends];
+ $times["breakfast"] = [$beginsb, $endsb];
+ $times["lunch"] = [$beginsl, $endsl];
+
+ foreach ($times as $time) {
+ if (intervals::wellFormed($time) === false) return 1;
+ }
+
+ if (intervals::measure($times["work"]) == 0) return 4;
+
+ if ((!intervals::isSubset($times["breakfast"], $times["work"]) && intervals::measure($times["breakfast"]) != 0) || (!intervals::isSubset($times["lunch"], $times["work"]) && intervals::measure($times["lunch"]) != 0)) return 2;
+
+ if (intervals::overlaps($times["breakfast"], $times["lunch"]) && intervals::measure($times["breakfast"]) != 0 && intervals::measure($times["lunch"]) != 0) return 3;
+
+ return 0;
+ }
+
+ private static function _checkAddDayParticular($id, $dow, $typeday, $table, $fieldSchedule) {
+ global $con;
+
+ $sid = (int)$id;
+ $sdow = (int)$dow;
+ $stypeday = (int)$typeday;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+ $sfieldSchedule = preg_replace("/[^A-Za-z0-9 ]/", '', $fieldSchedule);
+
+ $query = mysqli_query($con, "SELECT id FROM $stable WHERE $fieldSchedule = $sid AND day = $sdow AND typeday = $stypeday");
+
+ return (!mysqli_num_rows($query));
+ }
+
+ public static function checkAddDay2TemplateParticular($id, $dow, $typeday) {
+ return self::_checkAddDayParticular($id, $dow, $typeday, "scheduletemplatesdays", "template");
+ }
+
+ private static function _addDay($id, $dow, $typeday, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl, $table, $fieldSchedule) {
+ global $con;
+
+ $sid = (int)$id;
+ $sdow = (int)$dow;
+ $stypeday = (int)$typeday;
+ $sbegins = (int)$begins;
+ $sends = (int)$ends;
+ $sbeginsb = (int)$beginsb;
+ $sendsb = (int)$endsb;
+ $sbeginsl = (int)$beginsl;
+ $sendsl = (int)$endsl;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+ $sfieldSchedule = preg_replace("/[^A-Za-z0-9 ]/", '', $fieldSchedule);
+
+ return mysqli_query($con, "INSERT INTO $stable ($sfieldSchedule, day, typeday, beginswork, endswork, beginsbreakfast, endsbreakfast, beginslunch, endslunch) VALUES ($sid, $sdow, $stypeday, $sbegins, $sends, $sbeginsb, $sendsb, $sbeginsl, $sendsl)");
+ }
+
+ public static function addDay2Template($id, $dow, $typeday, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl) {
+ return self::_addDay($id, $dow, $typeday, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl, "scheduletemplatesdays", "template");
+ }
+
+ public static function _getDay($id, $table) {
+ global $con;
+
+ $sid = (int)$id;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+
+ $query = mysqli_query($con, "SELECT * FROM $stable WHERE id = $sid");
+
+ if (!mysqli_num_rows($query)) return false;
+
+ return mysqli_fetch_assoc($query);
+ }
+
+ public static function getTemplateDay($id) {
+ return self::_getDay($id, "scheduletemplatesdays");
+ global $con;
+ }
+
+ private static function _editDay($id, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl, $table) {
+ global $con;
+
+ $sid = (int)$id;
+ $sbegins = (int)$begins;
+ $sends = (int)$ends;
+ $sbeginsb = (int)$beginsb;
+ $sendsb = (int)$endsb;
+ $sbeginsl = (int)$beginsl;
+ $sendsl = (int)$endsl;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+
+ return mysqli_query($con, "UPDATE $stable SET beginswork = $sbegins, endswork = $sends, beginsbreakfast = $sbeginsb, endsbreakfast = $sendsb, beginslunch = $sbeginsl, endslunch = $sendsl WHERE id = $sid LIMIT 1");
+ }
+
+ public static function editTemplateDay($id, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl) {
+ return self::_editDay($id, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl, "scheduletemplatesdays");
+ }
+
+ private static function _removeDay($id, $table) {
+ global $con;
+
+ $sid = (int)$id;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+
+ return mysqli_query($con, "DELETE FROM $stable WHERE id = $sid LIMIT 1");
+ }
+
+ public static function removeTemplateDay($id) {
+ return self::_removeDay($id, "scheduletemplatesdays");
+ }
+
+ private static function _dayExists($id, $table) {
+ global $con;
+
+ $sid = (int)$id;
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+
+ $query = mysqli_query($con, "SELECT id FROM $stable WHERE id = $sid");
+
+ return (mysqli_num_rows($query) > 0);
+ }
+
+ public static function templateDayExists($id) {
+ return self::_dayExists($id, "scheduletemplatesdays");
+ }
+
+ // SCHEDULES:
+
+ public static function checkOverlap($worker, $begins, $ends, $sans = 0) {
+ global $con;
+
+ $sworker = (int)$worker;
+ $sbegins = (int)$begins;
+ $sends = (int)$ends;
+ $ssans = (int)$sans;
+
+ $query = mysqli_query($con, "SELECT * FROM schedules WHERE begins <= $sends AND ends >= $sbegins AND worker = $sworker".($sans == 0 ? "" : " AND id <> $ssans")." LIMIT 1");
+
+ return (mysqli_num_rows($query) > 0);
+ }
+
+ public static function get($id) {
+ return self::_get($id, "schedules", "schedulesdays", "schedule");
+ }
+
+ public static function getAll($id, $showNotActive = true) {
+ global $con, $conf;
+
+ $sid = (int)$id;
+
+ $query = mysqli_query($con, "SELECT * FROM schedules WHERE worker = $sid".($showNotActive ? "" : " AND active = 1")." ORDER BY ".($conf["debug"] ? "id ASC" : "begins DESC"));
+
+ $schedules = [];
+
+ while ($row = mysqli_fetch_assoc($query)) {
+ $schedules[] = $row;
+ }
+
+ return $schedules;
+ }
+
+ public static function getCurrent($id = "ME", $isWorker = false) {
+ global $con;
+
+ if ($id == "ME") $id = people::userData("id");
+ $sid = (int)$id;
+
+ $date = new DateTime(date("Y-m-d")."T00:00:00");
+ $timestamp = (int)$date->getTimestamp();
+
+ $query = mysqli_query($con, "SELECT s.* FROM schedules s ".($isWorker ? "WHERE s.worker = $sid" : "LEFT JOIN workers w ON s.worker = w.id WHERE w.person = $sid")." AND s.active = 1 AND s.begins <= $timestamp AND s.ends >= $timestamp");
+
+ $return = [];
+
+ while ($row = mysqli_fetch_assoc($query)) {
+ self::_addDaysToReturn($row, "schedulesdays", "schedule", $row["id"]);
+ $return[] = $row;
+ }
+
+ return $return;
+ }
+
+ public static function getWorkerScheduleStatus($id) {
+ $currentSchedules = self::getCurrent($id, true);
+ if ($currentSchedules === false || !count($currentSchedules)) return ["status" => self::STATUS_NO_ACTIVE_SCHEDULE];
+
+ $schedule =& $currentSchedules[0];
+
+ foreach (calendars::$workingTypes as $type) {
+ if (!isset($schedule["days"][$type]) || !count($schedule["days"][$type])) return ["status" => self::STATUS_HALFWAY_CONFIGURED_SCHEDULE, "schedule" => $schedule["id"]];
+ }
+
+ return ["status" => self::STATUS_ACTIVE_SCHEDULE, "schedule" => $schedule["id"]];
+ }
+
+ public static function add($worker, $ibegins, $iends, $active = 0, $alreadyTimestamp = false) {
+ global $con;
+
+ $sworker = (int)$worker;
+ $sactive = (int)$active;
+ if ($alreadyTimestamp) {
+ $sbegins = (int)$ibegins;
+ $sends = (int)$iends;
+ } else {
+ $begins = new DateTime($ibegins);
+ $sbegins = (int)$begins->getTimestamp();
+ $ends = new DateTime($iends);
+ $sends = (int)$ends->getTimestamp();
+ }
+
+ if (!intervals::wellFormed([$sbegins, $sends])) return 3;
+
+ if (self::checkOverlap($worker, $sbegins, $sends)) {
+ return 1;
+ }
+
+ return (mysqli_query($con, "INSERT INTO schedules (worker, begins, ends, active) VALUES ('$sworker', $sbegins, $sends, $sactive)") ? 0 : 2);
+ }
+
+ public static function edit($id, $ibegins, $iends) {
+ global $con;
+
+ $sid = (int)$id;
+ $begins = new DateTime($ibegins);
+ $sbegins = (int)$begins->getTimestamp();
+ $ends = new DateTime($iends);
+ $sends = (int)$ends->getTimestamp();
+
+ if (!intervals::wellFormed([$sbegins, $sends])) return 3;
+
+ $actual = self::get($sid);
+ if ($actual === false) return 4;
+
+ if (self::checkOverlap($actual["worker"], $sbegins, $sends, $sid)) {
+ return 1;
+ }
+
+ return (mysqli_query($con, "UPDATE schedules SET begins = $sbegins, ends = $sends WHERE id = $sid LIMIT 1") ? 0 : 2);
+ }
+
+ public static function remove($id) {
+ return self::_remove($id, "schedules", "schedulesdays", "schedule");
+ }
+
+ public static function switchActive($id, $value) {
+ global $con;
+
+ $sid = (int)$id;
+ $svalue = (int)$value;
+ if ($svalue > 1 || $svalue < 0) return false;
+
+ return mysqli_query($con, "UPDATE schedules SET active = $svalue WHERE id = $sid LIMIT 1");
+ }
+
+ public static function exists($id) {
+ return self::_exists($id, "schedules");
+ }
+
+ public static function checkAddDay2ScheduleParticular($id, $dow, $typeday) {
+ return self::_checkAddDayParticular($id, $dow, $typeday, "schedulesdays", "schedule");
+ }
+
+ public static function addDay2Schedule($id, $dow, $typeday, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl) {
+ return self::_addDay($id, $dow, $typeday, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl, "schedulesdays", "schedule");
+ }
+
+ public static function getDay($id) {
+ return self::_getDay($id, "schedulesdays");
+ global $con;
+ }
+
+ public static function editDay($id, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl) {
+ return self::_editDay($id, $begins, $ends, $beginsb, $endsb, $beginsl, $endsl, "schedulesdays");
+ }
+
+ public static function dayExists($id) {
+ return self::_dayExists($id, "schedulesdays");
+ }
+
+ public static function removeDay($id) {
+ return self::_removeDay($id, "schedulesdays");
+ }
+
+ public static function copyTemplate($template, $worker, $active) {
+ global $con;
+
+ $template = self::getTemplate($template);
+ if ($template === false) return 1;
+
+ $status = self::add($worker, $template["begins"], $template["ends"], $active, true);
+ if ($status != 0) return ($status + 1);
+
+ $id = mysqli_insert_id($con);
+
+ foreach ($template["days"] as $typeday) {
+ foreach ($typeday as $day) {
+ $status2 = self::addDay2Schedule($id, $day["day"], $day["typeday"], $day["beginswork"], $day["endswork"], $day["beginsbreakfast"], $day["endsbreakfast"], $day["beginslunch"], $day["endslunch"]);
+ if (!$status2) return -1;
+ }
+ }
+
+ return 0;
+ }
+}