private function getAppointmentCalendar(\DateTime $period, \Application\RoomItem $room, \Core\Database $db, \DBMappers\AppointmentItem $appMapper) { $result = array(); $last_day = \Utility\DateHelper::GetLastDayInMonth($period); for ($i = 1; $i <= $last_day; $i++) { $query_date = \Utility\DateHelper::DateOfDay($period, $i); $result[$i] = $appMapper->getDayAppointments($room->getId(), $query_date, $db); } return $result; }
public function getDayAppointments($roomId, \DateTime $date, \Core\Database $db) { $ds = (new \DateTime())->setDate($date->format('Y'), $date->format('n'), $date->format('j'))->setTime(0, 0, 0); $de = \Utility\DateHelper::GetNextDay($ds); $ds_str = $ds->format('Y-m-d H:i:s'); $de_str = $de->format('Y-m-d H:i:s'); $sql = "select * from appointments where :ds <= time_start and time_start < :de and room_id = :rid order by time_start"; if ($recs = $db->fetchAllAssoc($sql, array(":ds" => $ds_str, ":de" => $de_str, ":rid" => $roomId))) { $result = array(); foreach ($recs as $record) { $result[] = new \Application\AppointmentItem($record); } return $result; } else { return array(); } }
$days_back = $first_day_dow == 7 ? 0 : $first_day_dow; } $first_cell_date = $period_first_date->sub(new DateInterval('P' . $days_back . 'D')); $cell_date = $first_cell_date; $cell_in_row = 0; while ($cell_date->diff($period_last_date)->format('%R%a') >= 0 || $cell_in_row != 7) { //error_log("\nwd:$watchdog cell_in_row=$cell_in_row diff=" . print_r($cell_date->diff($period_last_date)->format('%R%a'), true), 3, 'my_errors.txt'); $cell_in_row = $cell_in_row == 7 ? 0 : $cell_in_row; if ($cell_in_row == 0) { echo "<tr class=\"cal-row\">"; } echo "<td>"; if (\Utility\DateHelper::IsDateInSamePeriod($tpl_browse_period, $cell_date)) { $day_index = $cell_date->format('j'); echo "<div class=\"cal-day\">" . $day_index . "</div><br>"; foreach ($tpl_browse_calendar[$day_index] as $appItem) { echo "<div class=\"cal-entry\"><a href=\"#\" onclick=\"openDetailsWindow(this)\" data-link=\"" . $tpl_site_root . DETAILS_URL . "/edit/" . $appItem->getId() . "\">" . \Utility\DateHelper::FormatTimeAccordingRule($appItem->getTimeStart(), $tpl_browse_hour_mode) . " - " . \Utility\DateHelper::FormatTimeAccordingRule($appItem->getTimeEnd(), $tpl_browse_hour_mode) . "</a></div>"; } } echo "</td>"; if ($cell_in_row == 6) { echo "</tr>"; } $cell_in_row++; $cell_date->add(new \DateInterval('P1D')); } //error_log("\ndayList:" . print_r($dayList, true), 3, 'my_errors.txt'); ?> </tbody> </table>
public static function MakeSuccessAppCreationMessage(\Application\AppointmentItem $leadingApp, $hourMode) { $message = '<span style="font-weight:normal">The event <strong>' . \Utility\DateHelper::FormatTimeAccordingRule($leadingApp->getTimeStart(), $hourMode) . ' - ' . \Utility\DateHelper::FormatTimeAccordingRule($leadingApp->getTimeEnd(), $hourMode) . '</strong> has been added.<br>' . 'The text for this event is: ' . $leadingApp->getNotes() . '</span>'; return $message; }
public function act($urlParameters, \Core\Http $http, \Core\Application $app, \Core\Database $db, \DBMappers\AppointmentItem $appMapper, \DBMappers\EmpItem $empItemMapper) { $appointment = $appMapper->getById($urlParameters[0], $db); $chain = $appMapper->getChain($appointment->getChain(), $db); $full_chain_count = $chain->count(); $chain->applyFilter(new \DateTime()); $can_modify = $chain->count() > 0; $values = $this->getValuesArray($appointment); $values['apply_chain_proxy'] = 0; $detailsErrors = array(); if ($http->getRequestMethod() == 'GET') { $app->setStateDetails(array('details_appointment' => $appointment, 'details_errors' => $detailsErrors, 'details_values' => $values, 'can_modify' => $can_modify, 'is_chain' => $full_chain_count > 1, 'hour_mode' => $app->getHourMode())); } else { //error_log("\npost:" . print_r($http->post(), true), 3, 'my_errors.txt'); $values = array_merge(array(), $http->post()); $bookingData = new \Application\BookingChange(); $this->validateForm($values, $detailsErrors, $bookingData); if ($this->isEmptyValues($detailsErrors)) { //error_log("\nBookData:" . print_r($bookingData, true), 3, 'my_errors.txt'); if ($bookingData->isApplyChain()) { $chain->applyChange($bookingData); } else { $chain->applyChangeToMember($appointment->getId(), $bookingData); } $appMatcher = new \Application\AppointmentMatcher(); $crossings = $appMatcher->getCrossingAppointments($chain, $appMapper, $db); if (count($crossings) > 0) { $message = \Utility\HtmlHelper::MakeCrossingMessage($crossings, $empItemMapper, $db); $app->setStateDetails(array('details_appointment' => $appointment, 'details_errors' => $detailsErrors, 'details_values' => $values, 'can_modify' => $can_modify, 'error_message' => $message, 'is_chain' => $chain->count() > 1, 'hour_mode' => $app->getHourMode())); } else { if ($bookingData->isApplyChain()) { foreach ($chain as $member) { $appMapper->save($member, $db); } $chain->rewind(); if ($chain->count() > 0) { $appointment = $chain->current(); } else { $appointment = null; } } else { $appointment = $chain->get($appointment->getId()); if ($chain->isMeetFilter($appointment)) { $appMapper->save($chain->get($appointment->getId()), $db); } else { $appointment = null; } } if (is_null($appointment)) { $message = "No changes were applied."; } else { $message = '<span style="font-weight:normal">The event has been modified to <strong>' . \Utility\DateHelper::FormatTimeAccordingRule($appointment->getTimeStart(), $app->getHourMode()) . ' - ' . \Utility\DateHelper::FormatTimeAccordingRule($appointment->getTimeEnd(), $app->getHourMode()) . '</strong>.<br>' . 'The text for this event is: ' . $appointment->getNotes() . '</span>'; } $app->setMessage($message); $app->setStateRedirect(DETAILS_RETURN_URL); } } else { $app->setStateDetails(array('details_appointment' => $appointment, 'details_errors' => $detailsErrors, 'details_values' => $values, 'can_modify' => $can_modify, 'is_chain' => $chain->count() > 1, 'hour_mode' => $app->getHourMode())); } } }
<?php $caption = \Utility\DateHelper::FormatTimeAccordingRule($tpl_details_appointment->getTimeStart(), $tpl_hour_mode) . ' - ' . \Utility\DateHelper::FormatTimeAccordingRule($tpl_details_appointment->getTimeEnd(), $tpl_hour_mode); echo $caption;