source: trunk/Modules/OpeningHours/OpeningHours.php@ 524

Last change on this file since 524 was 524, checked in by chronos, 12 years ago
  • Upraveno: Definice třída User přesunuta do modulu User. Existuje aplikační modul System->ModuleManager->ModulesUser a samotná instance třídy System->User.
  • Upraveno: Zbylá inicializace starého modulového systému třídy Module přesunuta do startovní části aplikačních modulů.
  • Upraveno: Třída System přesunuta ze souboru Common/Global do samostatného souboru Common/System.
File size: 10.2 KB
Line 
1<?php
2
3include_once(dirname(__FILE__).'/../../Common/Global.php');
4
5class PageSubjectOpenTime extends Page
6{
7 var $FullTitle = 'Otvírací doby místních subjektů';
8 var $ShortTitle = 'Otvírací doby';
9 var $DaysOfWeek = array('Pondělí', 'Úterý', 'Středa', 'Čtvrtek', 'Pátek', 'Sobota', 'Neděle');
10 var $EventType = array('Žádný', 'Otevřeno', 'Zavřeno');
11
12 function ToHumanTime($Time)
13 {
14 $Hours = floor($Time / 60);
15 $Minutes = $Time - $Hours * 60;
16 if($Minutes < 10) $Minutes = '0'.$Minutes;
17 $Hours = $Hours % 24;
18 return($Hours.':'.$Minutes);
19 }
20
21 function ToHumanTime2($Time)
22 {
23 $Days = floor($Time / 24 / 60);
24 $Time = $Time - $Days * 24 * 60;
25 $Hours = floor($Time / 60);
26 $Time = $Time - $Hours * 60;
27 $Minutes = $Time;
28 $Output = '';
29 if($Days > 0) $Output .= $Days.' dnů, ';
30 if($Hours > 0) $Output .= $Hours.' hodin, ';
31 if($Minutes > 0) $Output .= $Minutes.' minut';
32 return($Output);
33 }
34
35 function EditSubject($Id)
36 {
37 if($this->System->User->CheckPermission('SubjectOpenTime', 'Edit'))
38 {
39 $Output = '<div class="Centred">';
40 $DbResult = $this->Database->select('Subject', 'Name', 'Id='.$Id);
41 $DbRow = $DbResult->fetch_assoc();
42 $Output .= '<form method="post" action="save?Subject='.$Id.'" enctype="multipart/form-data">'.
43 '<strong>'.$DbRow['Name'].'</strong>'.
44 '<table class="WideTable"><tr><th>Den</th><th>Od</th><th>Do</th><th>Od</th><th>Do</th></tr>';
45 $Day = array();
46 $DbResult = $this->Database->query('SELECT * FROM SubjectOpenTimeDay WHERE Subject = '.$Id);
47 while($DbRow = $DbResult->fetch_assoc())
48 $Day[$DbRow['Day']] = $DbRow;
49 foreach($this->DaysOfWeek as $Index => $Name)
50 {
51 if(!array_key_exists($Index, $Day)) $Day[$Index] = array('Open1' => 0, 'Close1' => 0, 'Open2' => 0, 'Close2' => 0);
52 $Output .= '<tr><td>'.$Name.'</td>'.
53 '<td><input type="text" name="day'.$Index.'_open1_h" value="'.floor($Day[$Index]['Open1'] / 60).'" size="2" />'.
54 ':<input type="text" name="day'.$Index.'_open1_m" value="'.($Day[$Index]['Open1'] - floor($Day[$Index]['Open1'] / 60) * 60).'" size="2" /></td>'.
55 '<td><input type="text" name="day'.$Index.'_close1_h" value="'.floor($Day[$Index]['Close1'] / 60).'" size="2" />'.
56 ':<input type="text" name="day'.$Index.'_close1_m" value="'.($Day[$Index]['Close1'] - floor($Day[$Index]['Close1'] / 60) * 60).'" size="2" /></td>'.
57 '<td><input type="text" name="day'.$Index.'_open2_h" value="'.floor($Day[$Index]['Open2'] / 60).'" size="2" />'.
58 ':<input type="text" name="day'.$Index.'_open2_m" value="'.($Day[$Index]['Open2'] - floor($Day[$Index]['Open2'] / 60) * 60).'" size="2" /></td>'.
59 '<td><input type="text" name="day'.$Index.'_close2_h" value="'.floor($Day[$Index]['Close2'] / 60).'" size="2" />'.
60 ':<input type="text" name="day'.$Index.'_close2_m" value="'.($Day[$Index]['Close2'] - floor($Day[$Index]['Close2'] / 60) * 60).'" size="2" /></td>'.
61 '</tr>';
62 }
63 $DbResult = $this->Database->select('SubjectOpenTime', 'Notice', 'Subject='.$Id);
64 $DbRow = $DbResult->fetch_assoc();
65 $Output .= '</table>'.
66 'Poznámka: <input type="text" name="notice" value="'.$DbRow['Notice'].'" size="50" /><br />'.
67 'Fotka: <input type="file" name="photo" size="38" /><br />'.
68 '<input type="submit" value="Uložit" />'.
69 '</form></div>';
70 } else $Output = 'Nemáte oprávnění';
71 return($Output);
72 }
73
74 function SaveSubject($Id)
75 {
76 global $Config;
77
78 $Output = '';
79 if($this->System->User->CheckPermission('SubjectOpenTime', 'Edit'))
80 {
81 $this->Database->delete('SubjectOpenTimeDay', 'Subject='.$Id);
82 foreach($this->DaysOfWeek as $Index => $Name)
83 {
84 if($_POST['day'.$Index.'_open1_h'] > 24) $_POST['day'.$Index.'_open1_h'] = 24;
85 if($_POST['day'.$Index.'_close1_h'] > 24) $_POST['day'.$Index.'_close1_h'] = 24;
86 if($_POST['day'.$Index.'_open2_h'] > 24) $_POST['day'.$Index.'_open2_h'] = 24;
87 if($_POST['day'.$Index.'_close2_h'] > 24) $_POST['day'.$Index.'_close2_h'] = 24;
88 if($_POST['day'.$Index.'_open1_m'] > 59) $_POST['day'.$Index.'_open1_m'] = 59;
89 if($_POST['day'.$Index.'_close1_m'] > 59) $_POST['day'.$Index.'_close1_m'] = 59;
90 if($_POST['day'.$Index.'_open2_m'] > 59) $_POST['day'.$Index.'_open2_m'] = 59;
91 if($_POST['day'.$Index.'_close2_m'] > 59) $_POST['day'.$Index.'_close2_m'] = 59;
92 $Day = array('Subject' => $Id, 'Day' => $Index);
93 $Day['Open1'] = $_POST['day'.$Index.'_open1_m'] + $_POST['day'.$Index.'_open1_h'] * 60;
94 $Day['Close1'] = $_POST['day'.$Index.'_close1_m'] + $_POST['day'.$Index.'_close1_h'] * 60;
95 $Day['Open2'] = $_POST['day'.$Index.'_open2_m'] + $_POST['day'.$Index.'_open2_h'] * 60;
96 $Day['Close2'] = $_POST['day'.$Index.'_close2_m'] + $_POST['day'.$Index.'_close2_h'] * 60;
97 $this->Database->insert('SubjectOpenTimeDay', $Day);
98 }
99 $Output .= 'Uloženo';
100
101 $File = new File($this->Database);
102
103 // Delete old file
104 $DbResult = $this->Database->select('SubjectOpenTime', 'Photo', 'Subject='.$Id);
105 $DbRow = $DbResult->fetch_assoc();
106 $File->Delete($DbRow['Photo']);
107
108 // Create new file
109 $FileId = $File->CreateFromUpload('photo');
110 $this->Database->update('SubjectOpenTime', 'Subject='.$Id, array('UpdateTime' => 'NOW()', 'Notice' => $_POST['notice'], 'Photo' => $FileId));
111 } else $Output = 'Nemáte oprávnění';
112 return($Output);
113 }
114
115 function ShowAll()
116 {
117 $Output = '<div class="Centred">';
118 $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');
119 while($Subject = $DbResult->fetch_assoc())
120 {
121 $Output .= '<strong>'.$Subject['Name'].':</strong><br />';
122
123 // Load time event list
124 $Events = array();
125 $DbResult2 = $this->Database->query('SELECT * FROM `SubjectOpenTimeDay` WHERE Subject='.$Subject['Subject'].' ORDER BY Day ASC');
126 while($DbRow = $DbResult2->fetch_assoc())
127 {
128 if(($DbRow['Open1'] != $DbRow['Close1']) and ($DbRow['Open1'] < $DbRow['Close1']))
129 {
130 $Events[] = array('Time' => $DbRow['Open1'] + $DbRow['Day'] * 24 * 60, 'Type' => 1);
131 $Events[] = array('Time' => $DbRow['Close1'] + $DbRow['Day'] * 24 * 60, 'Type' => 2);
132 }
133 if(($DbRow['Open2'] != $DbRow['Close2']) and ($DbRow['Open2'] < $DbRow['Close2']) and ($DbRow['Close1'] < $DbRow['Open2']))
134 {
135 $Events[] = array('Time' => $DbRow['Open2'] + $DbRow['Day'] * 24 * 60, 'Type' => 1);
136 $Events[] = array('Time' => $DbRow['Close2'] + $DbRow['Day'] * 24 * 60, 'Type' => 2);
137 }
138 }
139 //print_r($Events);
140
141 // Calculate time to next event
142 if(count($Events) > 0)
143 {
144 $CurrentTime = ((date('w') + 6) % 7) * 24 * 60 + date('G') * 60 + date('i');
145
146 $I = 0;
147 while(($I < count($Events)) and ($Events[$I]['Time'] < $CurrentTime))
148 $I++;
149 if($I < count($Events))
150 {
151 $NextTime = $Events[$I]['Time'];
152 $NextEventType = $Events[$I]['Type'];
153 } else
154 {
155 $NextTime = $Events[0]['Time'] + 7 * 24 * 60;
156 $NextEventType = $Events[0]['Type'];
157 }
158
159 $TimeDelta = $NextTime - $CurrentTime;
160 //$Output .= $CurrentTime.' '.$NextTime;
161 if($NextEventType == 2) $Output .= 'Zavírá za '.$this->ToHumanTime2($TimeDelta);
162 else $Output .= 'Otevírá za '.$this->ToHumanTime2($TimeDelta);
163 }
164
165 // Show time inteval table
166 $Output .= '<table class="WideTable"><tr><th>Den</th><th>Čas</th></tr>';
167 foreach($this->DaysOfWeek as $DayIndex => $DayOfWeek)
168 {
169 $DbResult2 = $this->Database->query('SELECT * FROM SubjectOpenTimeDay WHERE Subject = '.$Subject['Subject'].' AND Day='.$DayIndex);
170 $Output .= '<tr><td>'.$DayOfWeek.'</td><td align="center">';
171 if($DbResult2->num_rows)
172 {
173 $DbRow = $DbResult2->fetch_assoc();
174 if(($DbRow['Open1'] != $DbRow['Close1']) and ($DbRow['Open1'] < $DbRow['Close1']))
175 {
176 $Output .= $this->ToHumanTime($DbRow['Open1']).' - '.$this->ToHumanTime($DbRow['Close1']).' &nbsp;&nbsp; ';
177 }
178 if(($DbRow['Open2'] != $DbRow['Close2']) and ($DbRow['Open2'] < $DbRow['Close2']) and ($DbRow['Close1'] < $DbRow['Open2']))
179 {
180 $Output .= $this->ToHumanTime($DbRow['Open2']).' - '.$this->ToHumanTime($DbRow['Close2']).'';
181 }
182 } else
183 $Output .= '&nbsp;';
184 $Output .= '</td></tr>';
185 }
186 $Output .= '</table>Aktualizováno: '.$Subject['UpdateTime'].'<br />';
187 if($Subject['Notice'] != '') $Output .= 'Poznámka: '.$Subject['Notice'].'<br />';
188
189 if($Subject['Photo'] != 0) $Output .= '<a href="file?id='.$Subject['Photo'].'">Fotka</a> ';
190
191 if($this->System->User->CheckPermission('SubjectOpenTime', 'Edit'))
192 $Output .= '<a href="edit?Subject='.$Subject['Id'].'">Editovat</a><br />';
193 $Output .= '<br />';
194 }
195 $Output .= '</div>';
196 return($Output);
197 }
198
199 function Show()
200 {
201 if(count($this->System->PathItems) > 1)
202 {
203 if($this->System->PathItems[1] == 'edit') $Output = $this->EditSubject($_GET['Subject']);
204 else if($this->System->PathItems[1] == 'save')
205 {
206 $Output = $this->SaveSubject($_GET['Subject']);
207 $Output .= $this->ShowAll();
208 } else $Output = PAGE_NOT_FOUND;
209 } else $Output = $this->ShowAll();
210 return($Output);
211 }
212}
213
214class ModuleOpeningHours extends AppModule
215{
216 function __construct($System)
217 {
218 parent::__construct($System);
219 $this->Name = 'OpeningHours';
220 $this->Version = '1.0';
221 $this->Creator = 'Chronos';
222 $this->License = 'GNU/GPL';
223 $this->Description = 'Show subject opening hours with time to open or time to close';
224 $this->Dependencies = array();
225 }
226
227 function Start()
228 {
229 parent::Start();
230 $this->System->Pages['otviraci-doby'] = 'PageSubjectOpenTime';
231 }
232
233 function Install()
234 {
235 parent::Install();
236 }
237
238 function UnInstall()
239 {
240 parent::UnInstall();
241 }
242}
243
244?>
Note: See TracBrowser for help on using the repository browser.