0) $Output .= $Days.' dnů, '; if ($Hours > 0) $Output .= $Hours.' hodin, '; if ($Minutes > 0) $Output .= $Minutes.' minut'; return $Output; } function EditSubject($Id) { if ($this->System->User->CheckPermission('OpeningHours', 'Edit')) { $Output = '
'; $DbResult = $this->Database->select('Subject', 'Name', 'Id='.$Id); $DbRow = $DbResult->fetch_assoc(); $Output .= '
'. ''.$DbRow['Name'].''. ''; $Day = array(); $DbResult = $this->Database->query('SELECT * FROM SubjectOpenTimeDay WHERE Subject = '.$Id); while ($DbRow = $DbResult->fetch_assoc()) $Day[$DbRow['Day']] = $DbRow; foreach ($this->DaysOfWeek as $Index => $Name) { if (!array_key_exists($Index, $Day)) $Day[$Index] = array('Open1' => 0, 'Close1' => 0, 'Open2' => 0, 'Close2' => 0); $Output .= ''. ''. ''. ''. ''. ''; } $DbResult = $this->Database->select('SubjectOpenTime', 'Notice', 'Subject='.$Id); $DbRow = $DbResult->fetch_assoc(); $Output .= '
DenOdDoOdDo
'.$Name.''. ':'. ':'. ':'. ':
'. 'Poznámka:
'. 'Fotka:
'. ''. '
'; } else $Output = 'Nemáte oprávnění'; return $Output; } function SaveSubject($Id) { global $Config; $Output = ''; if ($this->System->User->CheckPermission('OpeningHours', 'Edit')) { $this->Database->delete('SubjectOpenTimeDay', 'Subject='.$Id); foreach ($this->DaysOfWeek as $Index => $Name) { if ($_POST['day'.$Index.'_open1_h'] > 24) $_POST['day'.$Index.'_open1_h'] = 24; if ($_POST['day'.$Index.'_close1_h'] > 24) $_POST['day'.$Index.'_close1_h'] = 24; if ($_POST['day'.$Index.'_open2_h'] > 24) $_POST['day'.$Index.'_open2_h'] = 24; if ($_POST['day'.$Index.'_close2_h'] > 24) $_POST['day'.$Index.'_close2_h'] = 24; if ($_POST['day'.$Index.'_open1_m'] > 59) $_POST['day'.$Index.'_open1_m'] = 59; if ($_POST['day'.$Index.'_close1_m'] > 59) $_POST['day'.$Index.'_close1_m'] = 59; if ($_POST['day'.$Index.'_open2_m'] > 59) $_POST['day'.$Index.'_open2_m'] = 59; if ($_POST['day'.$Index.'_close2_m'] > 59) $_POST['day'.$Index.'_close2_m'] = 59; $Day = array('Subject' => $Id, 'Day' => $Index); $Day['Open1'] = $_POST['day'.$Index.'_open1_m'] + $_POST['day'.$Index.'_open1_h'] * 60; $Day['Close1'] = $_POST['day'.$Index.'_close1_m'] + $_POST['day'.$Index.'_close1_h'] * 60; $Day['Open2'] = $_POST['day'.$Index.'_open2_m'] + $_POST['day'.$Index.'_open2_h'] * 60; $Day['Close2'] = $_POST['day'.$Index.'_close2_m'] + $_POST['day'.$Index.'_close2_h'] * 60; $this->Database->insert('SubjectOpenTimeDay', $Day); } $Output .= 'Uloženo'; $File = new File($this->Database); // Delete old file $DbResult = $this->Database->select('SubjectOpenTime', 'Photo', 'Subject='.$Id); $DbRow = $DbResult->fetch_assoc(); $File->Delete($DbRow['Photo']); // Create new file $FileId = $File->CreateFromUpload('photo'); $this->Database->update('SubjectOpenTime', 'Subject='.$Id, array('UpdateTime' => 'NOW()', 'Notice' => $_POST['notice'], 'Photo' => $FileId)); } else $Output = 'Nemáte oprávnění'; return $Output; } function ShowAll() { $Output = '
'; $DbResult = $this->Database->query('SELECT SubjectOpenTime.*, DATE_FORMAT(SubjectOpenTime.UpdateTime, "%e.%c.%Y") as UpdateTime, Subject.Id, Subject.Name as Name FROM SubjectOpenTime JOIN Subject ON Subject.Id = SubjectOpenTime.Subject ORDER BY Name'); while ($Subject = $DbResult->fetch_assoc()) { $Output .= ''.$Subject['Name'].':
'; // Load time event list $Events = array(); $DbResult2 = $this->Database->query('SELECT * FROM `SubjectOpenTimeDay` WHERE Subject='.$Subject['Subject'].' ORDER BY Day ASC'); while ($DbRow = $DbResult2->fetch_assoc()) { if (($DbRow['Open1'] != $DbRow['Close1']) and ($DbRow['Open1'] < $DbRow['Close1'])) { $Events[] = array('Time' => $DbRow['Open1'] + $DbRow['Day'] * 24 * 60, 'Type' => 1); $Events[] = array('Time' => $DbRow['Close1'] + $DbRow['Day'] * 24 * 60, 'Type' => 2); } if (($DbRow['Open2'] != $DbRow['Close2']) and ($DbRow['Open2'] < $DbRow['Close2']) and ($DbRow['Close1'] < $DbRow['Open2'])) { $Events[] = array('Time' => $DbRow['Open2'] + $DbRow['Day'] * 24 * 60, 'Type' => 1); $Events[] = array('Time' => $DbRow['Close2'] + $DbRow['Day'] * 24 * 60, 'Type' => 2); } } //print_r($Events); // Calculate time to next event if (count($Events) > 0) { $CurrentTime = ((date('w') + 6) % 7) * 24 * 60 + date('G') * 60 + date('i'); $I = 0; while (($I < count($Events)) and ($Events[$I]['Time'] < $CurrentTime)) $I++; if ($I < count($Events)) { $NextTime = $Events[$I]['Time']; $NextEventType = $Events[$I]['Type']; } else { $NextTime = $Events[0]['Time'] + 7 * 24 * 60; $NextEventType = $Events[0]['Type']; } $TimeDelta = $NextTime - $CurrentTime; //$Output .= $CurrentTime.' '.$NextTime; if ($NextEventType == 2) $Output .= 'Zavírá za '.$this->ToHumanTime2($TimeDelta); else $Output .= 'Otevírá za '.$this->ToHumanTime2($TimeDelta); } // Show time inteval table $Output .= ''; foreach ($this->DaysOfWeek as $DayIndex => $DayOfWeek) { $DbResult2 = $this->Database->query('SELECT * FROM SubjectOpenTimeDay WHERE Subject = '.$Subject['Subject'].' AND Day='.$DayIndex); $Output .= ''; } $Output .= '
DenČas
'.$DayOfWeek.''; if ($DbResult2->num_rows) { $DbRow = $DbResult2->fetch_assoc(); if (($DbRow['Open1'] != $DbRow['Close1']) and ($DbRow['Open1'] < $DbRow['Close1'])) { $Output .= $this->ToHumanTime($DbRow['Open1']).' - '.$this->ToHumanTime($DbRow['Close1']).'    '; } if (($DbRow['Open2'] != $DbRow['Close2']) and ($DbRow['Open2'] < $DbRow['Close2']) and ($DbRow['Close1'] < $DbRow['Open2'])) { $Output .= $this->ToHumanTime($DbRow['Open2']).' - '.$this->ToHumanTime($DbRow['Close2']).''; } } else $Output .= ' '; $Output .= '
Aktualizováno: '.$Subject['UpdateTime'].'
'; if ($Subject['Notice'] != '') $Output .= 'Poznámka: '.$Subject['Notice'].'
'; if ($Subject['Photo'] != 0) $Output .= 'Fotka '; if ($this->System->User->CheckPermission('SubjectOpenTime', 'Edit')) $Output .= 'Editovat
'; $Output .= '
'; } $Output .= '
'; return $Output; } function Show() { if (count($this->System->PathItems) > 1) { if ($this->System->PathItems[1] == 'edit') $Output = $this->EditSubject($_GET['Subject']); else if ($this->System->PathItems[1] == 'save') { $Output = $this->SaveSubject($_GET['Subject']); $Output .= $this->ShowAll(); } else $Output = PAGE_NOT_FOUND; } else $Output = $this->ShowAll(); return $Output; } } class ModuleOpeningHours extends AppModule { function __construct($System) { parent::__construct($System); $this->Name = 'OpeningHours'; $this->Version = '1.0'; $this->Creator = 'Chronos'; $this->License = 'GNU/GPL'; $this->Description = 'Show subject opening hours with time to open or time to close'; $this->Dependencies = array(); } function DoStart() { $this->System->Pages['otviraci-doby'] = 'PageSubjectOpenTime'; } function DoInstall() { } function DoUnInstall() { } }