source: trunk/Modules/IS/IS.php@ 873

Last change on this file since 873 was 873, checked in by chronos, 5 years ago
  • Modified: Improved code format.
File size: 39.4 KB
Line 
1<?php
2
3include_once(dirname(__FILE__).'/../../Common/Global.php');
4
5class PageIS extends Page
6{
7 var $FullTitle = 'Správa dat';
8 var $ShortTitle = 'Správa dat';
9 var $ParentClass = 'PagePortal';
10 var $MenuItems;
11 var $HideMenu;
12 var $ShowActionName;
13
14 function __construct($System)
15 {
16 parent::__construct($System);
17 $this->MenuItems = array();
18 $this->HideMenu = false;
19 $this->ShowActionName = false;
20 }
21
22 function Show()
23 {
24 if (!$this->System->User->CheckPermission('IS', 'Manage'))
25 return 'Nemáte oprávnění';
26 $this->System->FormManager->ShowRelation = true;
27
28 // a - action
29 if (array_key_exists('a', $_GET)) $Action = $_GET['a'];
30 else $Action = '';
31 // t - table
32 if (array_key_exists('t', $_GET)) $Table = $_GET['t'];
33 else $Table = '';
34 // i - index of item
35 if (array_key_exists('i', $_GET)) $ItemId = $_GET['i'];
36 else $ItemId = 0;
37 // fc - preset colum
38 if (array_key_exists('fn', $_GET)) $FilterName = $_GET['fn'];
39 else $FilterName = '';
40 if (array_key_exists('fv', $_GET)) $FilterValue = $_GET['fv'];
41 else $FilterValue = '';
42 if (array_key_exists('menutype', $_COOKIE)) $MenuType = $_COOKIE['menutype'];
43 else $MenuType = 0;
44 if (array_key_exists('menutype', $_GET)) $MenuType = $_GET['menutype'] * 1;
45 setcookie('menutype', $MenuType, time() + 60 * 60 * 24 * 365);
46
47 if ($Action == 'list') {
48 if ($FilterName == '') $Content = $this->ShowList($Table);
49 else $Content = $this->ShowList($Table, '', '', $FilterName, $FilterValue);
50 }
51 else if ($Action == 'select') $Content = $this->ShowSelect($Table);
52 else if ($Action == 'mapselect') $Content = $this->ShowMapSelect($Table);
53 else if ($Action == 'edit') $Content = $this->ShowEdit($Table, $ItemId);
54 else if ($Action == 'add') $Content = $this->ShowAdd($Table);
55 else if ($Action == 'addsub') $Content = $this->ShowAddSub($Table);
56 else if ($Action == 'view') $Content = $this->ShowView($Table, $ItemId);
57 else if ($Action == 'delete') $Content = $this->ShowDelete($Table, $ItemId);
58 else if ($Action == 'fav_add') $Content = $this->ShowFavoriteAdd($Table, $ItemId);
59 else if ($Action == 'fav_del') $Content = $this->ShowFavoriteDel($Table, $ItemId);
60 else $Content = $this->Dashboard();
61 if ($this->HideMenu == false)
62 {
63 $Output = '<table style="width: 100%"><tr><td style="width: 20%; vertical-align: top;">';
64 $MenuTypeText = '<a href="?menutype=0">Nabídka</a>';
65 if ($MenuType == 0) $MenuTypeText = '<strong>'.$MenuTypeText.'</strong>';
66 $Output .= $MenuTypeText.' ';
67 $MenuTypeText = '<a href="?menutype=1">Oblíbené</a>';
68 if ($MenuType == 1) $MenuTypeText = '<strong>'.$MenuTypeText.'</strong>';
69 $Output .= $MenuTypeText.' ';
70 if ($MenuType == 0) $Output .= $this->ShowMenu();
71 if ($MenuType == 1) $Output .= $this->ShowFavorites();
72 $Output .= '</td><td style="width: 80%; vertical-align: top;">';
73 $Output .= $Content;
74 $Output .= '</td></tr></table>';
75 } else $Output = $Content;
76
77 return $Output;
78 }
79
80 function Dashboard()
81 {
82 $Output = '<strong>Nástěnka:</strong><br/>';
83 foreach ($this->System->ModuleManager->Modules['IS']->DashboardItems as $Item)
84 {
85 if (is_string($Item['Callback'][0]))
86 {
87 $Class = new $Item['Callback'][0]($this->System);
88 $Method = $Item['Callback'][1];
89 $Output .= $Class->$Method();
90 } else $Output .= call_user_func($Item['Callback']);
91 }
92 return $Output;
93 }
94
95 function ShowFavoriteAdd($Table, $ItemId)
96 {
97 $DbResult = $this->Database->select('MenuItemFavorite', 'Id', '(`MenuItem`='.($_GET['i'] * 1).') AND (`User`='.$this->System->User->User['Id'].')');
98 if ($DbResult->num_rows > 0)
99 {
100 $Output = $this->SystemMessage('Oblíbené', 'Již existuje v oblíbených');
101 } else
102 {
103 $this->Database->insert('MenuItemFavorite', array('MenuItem' => ($_GET['i'] * 1), 'User' => $this->System->User->User['Id']));
104 $Output = $this->SystemMessage('Oblíbené', 'Přidáno do oblíbených');
105 }
106 $Output .= $this->ShowList($Table);
107 return $Output;
108 }
109
110 function ShowFavoriteDel($Table, $ItemId)
111 {
112 $DbResult = $this->Database->select('MenuItemFavorite', 'Id', '(`MenuItem`='.($_GET['i'] * 1).') AND (`User`='.$this->System->User->User['Id'].')');
113 if ($DbResult->num_rows > 0)
114 {
115 $DbRow = $DbResult->fetch_assoc();
116 $this->Database->delete('MenuItemFavorite', '`Id`= '.$DbRow['Id']);
117 $Output = $this->SystemMessage('Oblíbené', 'Odstraněno z oblíbených');
118 } else
119 {
120 $Output = $this->SystemMessage('Oblíbené', 'Nenalezeno v oblíbených');
121 }
122 $Output .= $this->ShowList($Table);
123 return $Output;
124 }
125
126 function LogChange($Form, $Action, $NewId, $OldId)
127 {
128 $Values = $Form->Definition['Table'].' (Id: '.$OldId.' => '.$NewId.'):'."\n";
129 // Compare old values loaded from database with new values in Form variable
130 $NewValues = $Form->Values;
131 if ($OldId != 0)
132 {
133 $FormOld = new Form($this->System->FormManager);
134 $FormOld->SetClass($Form->Definition['Table']);
135 $FormOld->LoadValuesFromDatabase($OldId);
136 $OldValues = $FormOld->Values;
137 // Keep only changes values
138 foreach ($NewValues as $Index => $Value)
139 {
140 if ($OldValues[$Index] != $NewValues[$Index])
141 {
142 $Values .= $Index.': '.$FormOld->GetValue($Index);
143 if ($NewId != 0) $Values .= ' => '.$Form->GetValue($Index);
144 $Values .= "\n";
145 }
146 }
147 } else
148 {
149 foreach ($NewValues as $Index => $Value)
150 {
151 $Values .= $Index.': '.$Form->GetValue($Index)."\n";
152 }
153 }
154 $this->System->ModuleManager->Modules['Log']->NewRecord('IS', $Action, $Values);
155 }
156
157 function ShowEdit($Table, $Id)
158 {
159 $Output = '';
160 if (!array_key_exists($Table, $this->System->FormManager->Classes))
161 return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
162 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Write'))
163 return $this->SystemMessage('Oprávnění', 'Nemáte oprávnění');
164 if (array_key_exists('o', $_GET))
165 {
166 if ($_GET['o'] == 'save')
167 {
168 if (!array_key_exists('submit', $_POST))
169 return $this->SystemMessage('Formulář', 'Formulář nebyl řádně odeslán. Vraťte se zpět a odešlete formulář znovu.');
170 $Form = new Form($this->System->FormManager);
171 $Form->SetClass($Table);
172 $Form->LoadValuesFromForm();
173 $this->ShortTitle .= ' - '.$Form->Definition['Title'].' úprava';
174 try
175 {
176 $Form->Validate();
177 if (array_key_exists('BeforeModify', $Form->Definition))
178 {
179 $Class = $Form->Definition['BeforeModify'][0];
180 $Method = $Form->Definition['BeforeModify'][1];
181 $Form->Values = $Class->$Method($Form, $Id);
182 }
183 $this->LogChange($Form, 'Edit', $Id, $Id);
184 $Form->SaveValuesToDatabase($Id);
185 $Output .= $this->SystemMessage('Úprava položky', 'Položka upravena');
186 $Output .= $this->ShowView($Table, $Id);
187 if (array_key_exists('AfterModify', $Form->Definition))
188 {
189 $Class = $Form->Definition['AfterModify'][0];
190 $Method = $Form->Definition['AfterModify'][1];
191 $Form->Values = $Class->$Method($Form, $Id);
192 }
193 } catch (Exception $E)
194 {
195 $Output .= $this->SystemMessage('Úprava položky', 'Položku se nepodařilo uložit. Opravte problém a opakujte akci.<br/>'.$E->getMessage());
196 $Form->OnSubmit = '?a=edit&amp;t='.$Table.'&amp;i='.$_GET['i'].'&amp;o=save';
197 $Output .= $Form->ShowEditForm();
198 $Output .= '<ul class="ActionMenu">';
199 $Output .= '<li>'.$this->ShowAction('Prohlížet', '?a=view&amp;t='.$Table.'&amp;i='.$Id,
200 $this->System->Link('/images/view.png'));
201 $Output .= '<li>'.$this->ShowAction('Seznam', '?a=list&amp;t='.$Table,
202 $this->System->Link('/images/list.png'));
203 $Output .= '<li>'.$this->ShowAction('Odstranit', '?a=delete&amp;t='.$Table.'&amp;i='.$Id,
204 $this->System->Link('/images/delete.png'), 'Opravdu smazat položku');
205 $Output .= '</ul>';
206 }
207 }
208 } else
209 {
210 $Form = new Form($this->System->FormManager);
211 $Form->SetClass($Table);
212 $Form->LoadValuesFromDatabase($Id);
213 $this->ShortTitle .= ' - '.$Form->Definition['Title'].' úprava';
214 $Form->OnSubmit = '?a=edit&amp;t='.$Table.'&amp;i='.$_GET['i'].'&amp;o=save';
215 $Output .= $Form->ShowEditForm();
216 $Output .= '<ul class="ActionMenu">';
217 $Output .= '<li>'.$this->ShowAction('Prohlížet', '?a=view&amp;t='.$Table.'&amp;i='.$Id,
218 $this->System->Link('/images/view.png'));
219 $Output .= '<li>'.$this->ShowAction('Seznam', '?a=list&amp;t='.$Table,
220 $this->System->Link('/images/list.png'));
221 $Output .= '<li>'.$this->ShowAction('Odstranit', '?a=delete&amp;t='.$Table.'&amp;i='.$Id,
222 $this->System->Link('/images/delete.png'), 'Opravdu smazat položku?');
223 $Output .= '</ul>';
224 }
225 return $Output;
226 }
227
228 function ShowDelete($Table, $Id)
229 {
230 $Output = '';
231 if (!array_key_exists($Table, $this->System->FormManager->Classes))
232 return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
233 $FormClass = $this->System->FormManager->Classes[$Table];
234 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Write'))
235 return 'Nemáte oprávnění';
236 $DbResult = $this->Database->select($Table, '*', '`Id`='.$Id);
237 if ($DbResult->num_rows > 0)
238 {
239 $DbRow = $DbResult->fetch_assoc();
240 try
241 {
242 $Form = new Form($this->System->FormManager);
243 $Form->SetClass($Table);
244 $Form->LoadValuesFromDatabase($Id);
245 $this->ShortTitle .= ' - '.$Form->Definition['Title'].' odstranění';
246 if (array_key_exists('BeforeDelete', $Form->Definition))
247 {
248 call_user_func($Form->Definition['BeforeDelete'], $Form, $Id);
249 }
250 $this->LogChange($Form, 'Delete', 0, $Id);
251 $this->Database->delete($Table, '`Id`='.$Id);
252 $Output .= $this->SystemMessage('Smazání položky', 'Položka odstraněna');
253 if (array_key_exists('AfterDelete', $Form->Definition))
254 {
255 $Class = $Form->Definition['AfterDelete'][0];
256 $Method = $Form->Definition['AfterDelete'][1];
257 $Class->$Method($Form, $Id);
258 }
259 } catch (Exception $E)
260 {
261 $Output .= $this->SystemMessage('Smazání položky', 'Položku se nepodařilo smazat. Pravděpodobně na ni závisejí další položky.<br/>'.$E->getMessage());
262 }
263 } else $Output .= $this->SystemMessage('Smazání položky', 'Položka nenalezena');
264 $Output .= $this->ShowList($Table);
265 return $Output;
266 }
267
268 function ShowAdd($Table, $Actions = array())
269 {
270 $Output = '';
271 if (!array_key_exists($Table, $this->System->FormManager->Classes))
272 return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
273 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Write'))
274 return 'Nemáte oprávnění';
275 if (array_key_exists('o', $_GET))
276 {
277 if ($_GET['o'] == 'save')
278 {
279 $Form = new Form($this->System->FormManager);
280 $Form->SetClass($Table);
281 $Form->LoadValuesFromForm();
282 $this->ShortTitle .= ' - '.$Form->Definition['Title'].' přidání';
283 try
284 {
285 $Form->Validate();
286 if (array_key_exists('BeforeInsert', $Form->Definition))
287 {
288 $Class = $Form->Definition['BeforeInsert'][0];
289 $Method = $Form->Definition['BeforeInsert'][1];
290 $Form->Values = $Class->$Method($Form);
291 }
292 $Form->Validate();
293 $Form->SaveValuesToDatabase(0);
294 $Id = $this->Database->insert_id;
295 $this->LogChange($Form, 'Add', $Id, 0);
296 $Output .= $this->SystemMessage('Přidání položky', 'Nová položka vytvořena');
297 $Output .= $this->ShowView($Table, $Id, $_GET['a'] == 'addsub');
298 if (array_key_exists('AfterInsert', $Form->Definition))
299 {
300 $Class = $Form->Definition['AfterInsert'][0];
301 $Method = $Form->Definition['AfterInsert'][1];
302 $Form->Values = $Class->$Method($Form, $Id);
303 }
304 // Add action to update caller form
305 if ($_GET['a'] == 'addsub')
306 {
307 $Type = $this->System->FormManager->FormTypes[$_GET['rt']];
308 $DbResult = $this->Database->select($Table, '('.$Type['Name'].') AS Name', 'Id='.$Id);
309 $DbRow = $DbResult->fetch_assoc();
310 $Actions[] = '<a href="javascript:window.close();" onclick="add_select_item('.$Id.',&quot;'.$DbRow['Name'].'&quot;,&quot;'.
311 $_GET['r'].'&quot;); set_return ('.$Id.',&quot;'.
312 $_GET['r'].'&quot;);"><img alt="Vybrat" title="Vybrat" src="'.
313 $this->System->Link('/images/select.png').'"/> Vybrat</a>';
314 }
315
316 //$this->Database->update($Table, 'Id='.$Id,
317 // array('UserCreate' => $this->System->User->User['Id'],
318 // 'TimeCreate' => 'NOW()'));
319 } catch (Exception $E)
320 {
321 $Output .= $this->SystemMessage('Přidání položky', 'Položku se nepodařilo přidat. Opravte problém a opakujte akci.<br/>'.$E->getMessage());
322 $Form->OnSubmit = '?a=add&amp;t='.$Table.'&amp;o=save';
323 $Output .= $Form->ShowEditForm();
324 $Actions[] = '<a href="?a=list&amp;t='.$Table.'"><img alt="Seznam" title="Seznam" src="'.
325 $this->System->Link('/images/list.png').'"/>Seznam</a>';
326 }
327 }
328 } else
329 {
330 $Form = new Form($this->System->FormManager);
331 $Form->SetClass($Table);
332 $this->ShortTitle .= ' - '.$Form->Definition['Title'].' přidání';
333 // Load presets from URL
334 foreach ($_GET as $Key => $Value)
335 {
336 if (substr($Key, 0, 6) == 'preset')
337 {
338 $Key = substr($Key, 6);
339 if (($Key != '') and array_key_exists($Key, $Form->Values))
340 $Form->Values[$Key] = $Value;
341 }
342 }
343 if (array_key_exists('r', $_GET)) $URL = '&amp;r='.$_GET['r'].'&amp;rt='.$_GET['rt'];
344 else $URL = '';
345 $Form->OnSubmit = '?a='.$_GET['a'].'&amp;t='.$Table.'&amp;o=save'.$URL;
346 $Output .= $Form->ShowEditForm();
347 $Actions[] = $this->ShowAction('Seznam', '?a=list&amp;t='.$Table,
348 $this->System->Link('/images/list.png'));
349 }
350 $Output .= '<ul class="ActionMenu">';
351 foreach ($Actions as $Action)
352 {
353 $Output .= '<li>'.$Action.'</li>';
354 }
355 $Output .= '</ul>';
356 return $Output;
357 }
358
359 function ShowAddSub($Table, $Filter = '', $Title = '')
360 {
361 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Write'))
362 return 'Nemáte oprávnění';
363 $this->BasicHTML = true;
364 $this->HideMenu = true;
365 $Output = $this->ShowAdd($Table);
366 return $Output;
367 }
368
369 function ShowTabs($Tabs, $QueryParamName, $TabContent)
370 {
371 $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
372 $QueryItems['a'] = 'view';
373
374 if (array_key_exists($QueryParamName, $_GET)) $TabIndex = $_GET[$QueryParamName];
375 else $TabIndex = 0;
376
377 $Output = '<div class="Tab">'.
378 '<ul>';
379 foreach ($Tabs as $Index => $Tab)
380 {
381 $QueryItems[$QueryParamName] = $Index;
382 if ($Index == $TabIndex) $Selected = ' id="selected"';
383 else $Selected = '';
384 $Output .= '<li'.$Selected.'><a href="?'.SetQueryStringArray($QueryItems).'">'.$Tab.'</a></li>';
385 }
386 $Output .= '</ul></div><div class="TabContent">'.$TabContent.'</div>';
387 return $Output;
388 }
389
390 function ShowView($Table, $Id, $WithoutActions = false)
391 {
392 if (!array_key_exists($Table, $this->System->FormManager->Classes))
393 return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
394 $FormClass = $this->System->FormManager->Classes[$Table];
395 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Read'))
396 return 'Nemáte oprávnění';
397
398 $FormClass = $this->System->FormManager->Classes[$Table];
399 if (array_key_exists('BaseTable', $FormClass)) $TableModify = $FormClass['BaseTable'];
400 else $TableModify = $Table;
401
402 $Form = new Form($this->System->FormManager);
403 $Form->SetClass($Table);
404 $this->ShortTitle .= ' - '.$Form->Definition['Title'].' položka';
405 $Form->LoadValuesFromDatabase($Id);
406 $Form->OnSubmit = '?a=view';
407 $Output = $Form->ShowViewForm();
408 if ($WithoutActions == false)
409 {
410 $Actions = array(
411 $this->ShowAction('Upravit', '?a=edit&amp;t='.$TableModify.'&amp;i='.$Id,
412 $this->System->Link('/images/edit.png')),
413 $this->ShowAction('Seznam', '?a=list&amp;t='.$Table,
414 $this->System->Link('/images/list.png')),
415 $this->ShowAction('Odstranit', '?a=delete&amp;t='.$Table.'&amp;i='.$Id,
416 $this->System->Link('/images/delete.png'), 'Opravdu smazat položku?'),
417 $this->ShowAction('Přidat', '?a=add&amp;t='.$TableModify,
418 $this->System->Link('/images/add.png'))
419 );
420 if (array_key_exists('ItemActions', $FormClass))
421 {
422 foreach ($FormClass['ItemActions'] as $Action)
423 {
424 $URL = str_replace('#RowId', $Id, $this->System->Link($Action['URL']));
425 $Actions[] = $this->ShowAction($Action['Caption'], $URL,
426 $this->System->Link('/images/action.png'));
427 }
428 }
429 $Output .= '<ul class="ActionMenu">';
430 foreach ($Actions as $Action)
431 {
432 $Output .= '<li>'.$Action.'</li>';
433 }
434 $Output .= '</ul><br/>';
435 }
436
437 // Show ManyToOne relations
438 $Tabs = array();
439 foreach ($Form->Definition['Items'] as $Index => $Item)
440 if ((array_key_exists($Item['Type'], $this->System->FormManager->FormTypes) and
441 ($this->System->FormManager->FormTypes[$Item['Type']]['Type'] == 'ManyToOne')))
442 {
443 $Tabs[] = $Item['Caption'];
444 }
445 $Tabs[] = 'Vše';
446 if (array_key_exists('tab', $_GET)) $TabIndex = $_GET['tab'];
447 else $TabIndex = 0;
448
449 $TabContent = '';
450 $I = 0;
451 foreach ($Form->Definition['Items'] as $Index => $Item)
452 if ((array_key_exists($Item['Type'], $this->System->FormManager->FormTypes) and
453 ($this->System->FormManager->FormTypes[$Item['Type']]['Type'] == 'ManyToOne')))
454 {
455 $TypeItem = $this->System->FormManager->FormTypes[$Item['Type']];
456 if (($TabIndex == $I) or ($TabIndex == (count($Tabs) - 1)))
457 {
458 if ($TypeItem['Ref'] == null)
459 {
460 $Filter = $TypeItem['Filter'];
461 $Filter = str_replace('#Id', $Id, $Filter);
462 $TabContent .= $this->ShowList($TypeItem['Table'],
463 $Filter, $Item['Caption']).'<br/>';
464 } else $TabContent .= $this->ShowList($TypeItem['Table'], '`'.
465 $TypeItem['Ref'].'`='.$Id, $Item['Caption'],
466 $TypeItem['Ref'], $Id).'<br/>';
467 }
468 $I++;
469 }
470
471 $Output .= $this->ShowTabs($Tabs, 'tab', $TabContent);
472 return $Output;
473 }
474
475 function ShowTable($Table, $Filter = '', $Title = '', $RowActions = array(), $ExcludeColumn = '')
476 {
477 if (!array_key_exists($Table, $this->System->FormManager->Classes))
478 return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
479 $FormClass = $this->System->FormManager->Classes[$Table];
480
481 if (array_key_exists('SQL', $FormClass))
482 $SourceTable = '('.$FormClass['SQL'].') AS `TX`';
483 else $SourceTable = '`'.$FormClass['Table'].'` AS `TX`';
484
485 $WhereFilter = $Filter;
486 $HavingFilter = '';
487
488 // Build form type filter
489 $TypeFilter = '';
490 foreach ($FormClass['Items'] as $ItemIndex => $FormItem)
491 if (!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
492 (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
493 ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne')))
494 if (array_key_exists('Filter', $FormItem) and ($FormItem['Filter'] == true))
495 {
496 if ($TypeFilter != '') $TypeFilter .= ' AND ';
497 $TypeFilter .= '(`'.$ItemIndex.'` = "'.$FormItem['Default'].'")';
498 }
499 if ($TypeFilter != '')
500 {
501 if ($HavingFilter != '') $HavingFilter = ' AND';
502 $HavingFilter .= ' '.$TypeFilter;
503 }
504
505 // Build user filter
506 $UserFilter = '';
507 $Columns = array('Id' => '`Id`');
508 if (array_key_exists('filter', $_GET) and ($_GET['filter'] == 1))
509 {
510 foreach ($FormClass['Items'] as $ItemIndex => $FormItem)
511 if (!array_key_exists('Hidden', $FormItem) or ($FormItem['Hidden'] == false))
512 if (!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
513 (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
514 ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne')))
515 {
516 $UseType = $UseType = $FormItem['Type'];
517 if (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes))
518 {
519 if (!array_key_exists($FormItem['Type'], $this->System->FormManager->Type->TypeDefinitionList))
520 $this->System->FormManager->Type->RegisterType($FormItem['Type'], '',
521 $this->System->FormManager->FormTypes[$FormItem['Type']]);
522 if ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Reference')
523 $UseType = 'OneToMany';
524 else
525 if ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Enumeration')
526 $UseType = 'Enumeration';
527 }
528 $FilterName = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterName',
529 array('Name' => $ItemIndex, 'Type' => $FormItem['Type']));
530 if (array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != ''))
531 {
532 if ($UserFilter != '') $UserFilter .= ' AND ';
533 $UserFilter .= '('.$FilterName.' LIKE "%'.$_POST['Filter'.$ItemIndex].'%")';
534 }
535 }
536 }
537 if ($UserFilter != '')
538 {
539 if ($HavingFilter != '') $HavingFilter .= ' AND';
540 $HavingFilter .= ' '.$UserFilter;
541 }
542 if ($WhereFilter != '') $Filter = ' WHERE '.$WhereFilter;
543 if ($HavingFilter != '') $Filter = ' HAVING '.$HavingFilter;
544
545
546 foreach ($FormClass['Items'] as $ItemIndex => $FormItem)
547 if (!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
548 (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
549 ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne')))
550 {
551 if ($ExcludeColumn != $ItemIndex)
552 if (!array_key_exists('Hidden', $FormItem) or ($FormItem['Hidden'] == false))
553 if (!array_key_exists('NotInList', $FormItem) or ($FormItem['NotInList'] == false))
554 $TableColumns[] = array('Name' => $ItemIndex, 'Title' => $FormItem['Caption']);
555 $UseType = $UseType = $FormItem['Type'];
556 if (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes))
557 {
558 if (!array_key_exists($FormItem['Type'], $this->System->FormManager->Type->TypeDefinitionList))
559 $this->System->FormManager->Type->RegisterType($FormItem['Type'], '',
560 $this->System->FormManager->FormTypes[$FormItem['Type']]);
561 if ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Reference')
562 $UseType = 'OneToMany';
563 else
564 if ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Enumeration')
565 $UseType = 'Enumeration';
566 }
567 if (array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != ''))
568 $Value = $_POST['Filter'.$ItemIndex];
569 else $Value = '';
570 if ($ItemIndex == 'Id') unset($Columns['Id']);
571
572 if (!array_key_exists('SQL', $FormItem)) $FormItem['SQL'] = '';
573 else $FormItem['SQL'] = str_replace('#Id', '`TX`.`Id`', $FormItem['SQL']);
574 $Columns[] = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterNameQuery',
575 array('Value' => $Value, 'Name' => $ItemIndex,
576 'Type' => $FormItem['Type'], 'SQL' => $FormItem['SQL']));
577 }
578
579 // Get total item count in database
580 $Query = 'SELECT COUNT(*) FROM '.$SourceTable;
581 $DbResult = $this->Database->query($Query);
582 $DbRow = $DbResult->fetch_assoc();
583 $TotalCount = $DbRow['COUNT(*)'];
584
585 // Get total filtered item count in database
586 $Columns = implode(',', $Columns);
587 if ($Filter != '')
588 {
589 $Query = 'SELECT COUNT(*) FROM (SELECT '.$Columns.' FROM '.$SourceTable.' '.$Filter.') AS `TS`';
590 $DbResult = $this->Database->query($Query);
591 $DbRow = $DbResult->fetch_row();
592 $TotalFilteredCount = $DbRow[0];
593 } else $TotalFilteredCount = $TotalCount;
594 $PageList = GetPageList($Table, $TotalFilteredCount);
595
596 $Output = $PageList['Output'];
597 $Output .= '<table class="WideTable" style="font-size: small;">';
598
599 $TableColumns[] = array('Name' => '', 'Title' => 'Akce');
600 if (!array_key_exists('DefaultSortColumn', $FormClass))
601 $FormClass['DefaultSortColumn'] = 'Id';
602 if (!array_key_exists('DefaultSortOrder', $FormClass))
603 $FormClass['DefaultSortOrder'] = 0;
604 $Order = GetOrderTableHeader($Table, $TableColumns, $FormClass['DefaultSortColumn'], $FormClass['DefaultSortOrder']);
605 $Output .= $Order['Output'];
606
607 // Show search fields
608 if (array_key_exists('r', $_GET)) $Addition = '&amp;r='.$_GET['r'];
609 else $Addition = '';
610 $Output .= '<tr><form action="?a='.$_GET['a'].'&amp;t='.$Table.'&amp;filter=1'.$Addition.'" method="post">';
611 foreach ($FormClass['Items'] as $ItemIndex => $FormItem)
612 if (!array_key_exists('Hidden', $FormItem) or ($FormItem['Hidden'] == false))
613 if (!array_key_exists('NotInList', $FormItem) or ($FormItem['NotInList'] == false))
614 if ((!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
615 (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
616 ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne'))) and
617 ($ExcludeColumn != $ItemIndex))
618 {
619 if (array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != ''))
620 $Value = $_POST['Filter'.$ItemIndex];
621 else $Value = '';
622 $Output .= '<td><input type="text" name="Filter'.$ItemIndex.'" value="'.$Value.'" style="width: 100%"/></td>';
623 }
624 $Output .= '<td><input type="Submit" value="Hledat"/></td></form></tr>';
625
626 // Load and show items
627 $Query = 'SELECT '.$Columns.' FROM '.$SourceTable.' '.
628 $Filter.' '.$Order['SQL'].$PageList['SQLLimit'];
629 $VisibleItemCount = 0;
630 $DbResult = $this->Database->query($Query);
631 while ($Row = $DbResult->fetch_assoc())
632 {
633 $Output .= '<tr>';
634 foreach ($FormClass['Items'] as $ItemIndex => $FormItem)
635 if (!array_key_exists('Hidden', $FormItem) or ($FormItem['Hidden'] == false))
636 if (!array_key_exists('NotInList', $FormItem) or ($FormItem['NotInList'] == false))
637 if ((!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or
638 (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and
639 ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne'))) and
640 ($ExcludeColumn != $ItemIndex))
641 {
642 //$Output .= '<td>'.$Row[$ItemIndex].'</td>';
643 $UseType = $UseType = $FormItem['Type'];
644 if (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes))
645 {
646 if (!array_key_exists($FormItem['Type'], $this->System->FormManager->Type->TypeDefinitionList))
647 $this->System->FormManager->Type->RegisterType($FormItem['Type'], '',
648 $this->System->FormManager->FormTypes[$FormItem['Type']]);
649 if ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Reference')
650 $UseType = 'OneToMany';
651 else
652 if ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Enumeration')
653 $UseType = 'Enumeration';
654 }
655 $Row[$ItemIndex] = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnLoadDb',
656 array('Value' => $Row[$ItemIndex], 'Name' => $ItemIndex,
657 'Type' => $FormItem['Type']));
658 $Value = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnView',
659 array('Value' => $Row[$ItemIndex], 'Name' => $ItemIndex,
660 'Type' => $FormItem['Type'], 'Filter' => $Row[$ItemIndex.'_Filter']));
661 if ($Value == '') $Value = '&nbsp;';
662 $Output .= '<td>'.$Value.'</td>';
663 }
664 $Output .= '<td>'.str_replace('#RowId', $Row['Id'], $RowActions).'</td></tr>';
665 $VisibleItemCount = $VisibleItemCount + 1;
666 }
667 $Output .= '<tr><td colspan="'.count($TableColumns).'" style="text-align: right;">Zobrazeno <strong>'.$VisibleItemCount.'</strong>';
668 if ($UserFilter != '') $Output .= ' z filtrovaných <strong>'.$TotalFilteredCount.'</strong>';
669 $Output .= ' z celkem <strong>'.$TotalCount.'</strong></td></tr>';
670 $Output .= '</table>';
671 $Output .= $PageList['Output'];
672 return $Output;
673 }
674
675 function ShowSelect($Table, $Filter = '', $Title = '')
676 {
677 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Read'))
678 return 'Nemáte oprávnění';
679 $this->BasicHTML = true;
680 $this->HideMenu = true;
681 $RowActions = '<a href="javascript:window.close();" onclick="set_return (#RowId,&quot;'.
682 $_GET['r'].'&quot;);"><img alt="Vybrat" title="Vybrat" src="'.
683 $this->System->Link('/images/select.png').'"/></a>';
684 $Output = $this->ShowTable($Table, $Filter, $Title, $RowActions);
685 return $Output;
686 }
687
688 function ShowMapSelect($Table, $Filter = '', $Title = '')
689 {
690 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Write'))
691 return 'Nemáte oprávnění';
692 $Map = new MapOpenStreetMaps($this->System);
693 $Map->Position = array('Lat' => $this->System->Config['Map']['DefaultLatitude'],
694 'Lng' => $this->System->Config['Map']['DefaultLongitude']);
695 $Map->Zoom = $this->System->Config['Map']['DefaultZoom'];
696 $Map->Key = $this->System->Config['Map']['GoogleMapsApiKey'];
697 $Map->OnClickObject = $_GET['r'];
698 //$MapApi->ShowMarker = true;
699 $Output = $Map->ShowPage($this);
700 return $Output;
701 }
702
703 function ShowList($Table, $Filter = '', $Title = '', $ExcludeColumn = '', $ExcludeValue = '')
704 {
705 $Output = '';
706 if (defined('NEW_PERMISSION') and !$this->System->User->CheckPermission($this->TableToModule($Table), 'Read'))
707 return 'Nemáte oprávnění';
708 if (!array_key_exists($Table, $this->System->FormManager->Classes))
709 return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
710 $FormClass = $this->System->FormManager->Classes[$Table];
711 if (array_key_exists('BaseTable', $FormClass)) $TableModify = $FormClass['BaseTable'];
712 else $TableModify = $Table;
713
714 $RowActions = '<a href="?a=view&amp;t='.$Table.'&amp;i=#RowId"><img alt="Ukázat" title="Ukázat" src="'.
715 $this->System->Link('/images/view.png').'"/></a>'.
716 '<a href="?a=edit&amp;t='.$TableModify.'&amp;i=#RowId"><img alt="Upravit" title="Upravit" src="'.
717 $this->System->Link('/images/edit.png').'"/></a>'.
718 '<a href="?a=delete&amp;t='.$Table.'&amp;i=#RowId"><img alt="Smazat" title="Smazat" src="'.
719 $this->System->Link('/images/delete.png').'" onclick="return confirmAction(\'Opravdu smazat položku?\');"/></a>';
720 if (($Table != '') and (array_key_exists($Table, $this->System->FormManager->Classes)))
721 $FormClass = $this->System->FormManager->Classes[$Table];
722 else return $this->SystemMessage('Chyba', 'Tabulka '.$Table.' nenalezena');
723 if ($ExcludeColumn == '') $this->ShortTitle .= ' - '.$FormClass['Title'];
724 if (array_key_exists('ItemActions', $FormClass))
725 {
726 foreach ($FormClass['ItemActions'] as $Action)
727 {
728 $URL = $this->System->Link($Action['URL']);
729 $RowActions .= '<a href="'.$URL.'"><img alt="'.$Action['Caption'].'" title="'.$Action['Caption'].'" src="'.
730 $this->System->Link('/images/action.png').'"/></a>';
731 }
732 }
733 $Output .= '<div style="text-align: center;">'.$FormClass['Title'].'</div>';
734 $Output .= '<ul class="ActionMenu">';
735 $Output .= '<li>'.$this->ShowAction('Přidat', '?a=add&amp;t='.$TableModify.'&amp;preset'.$ExcludeColumn.'='.$ExcludeValue, $this->System->Link('/images/add.png')).'</li>';
736 $Output .= '<li>'.$this->ShowAction('Seznam', '?a=list&amp;t='.$Table, $this->System->Link('/images/list.png')).'</li>';
737 $MI = 0;
738 if (array_key_exists('mi', $_GET))
739 {
740 $DbResult = $this->Database->select('MenuItemFavorite', 'Id', '(`MenuItem`='.($_GET['mi'] * 1).') AND (`User`='.$this->System->User->User['Id'].')');
741 if ($DbResult->num_rows > 0)
742 {
743 $DbRow = $DbResult->fetch_assoc();
744 $Fav = $DbRow['Id'];
745 $Output .= '<li>'.$this->ShowAction('Odebrat z oblíbených', '?a=fav_del&amp;t='.$Table.'&amp;i='.$_GET['mi'].'&amp;mi='.$_GET['mi'],
746 $this->System->Link('/images/Favorite-Del.png')).'</li>';
747 } else $Output .= '<li>'.$this->ShowAction('Přidat do oblíbených', '?a=fav_add&amp;t='.$Table.'&amp;i='.$_GET['mi'].'&amp;mi='.$_GET['mi'],
748 $this->System->Link('/images/Favorite-Add.png')).'</li>';
749 }
750 if (array_key_exists('Actions', $FormClass))
751 {
752 foreach ($FormClass['Actions'] as $Action)
753 {
754 $Output .= '<li>'.$this->ShowAction($Action['Caption'], $this->System->Link($Action['URL']),
755 $this->System->Link('/images/action.png')).'</li>';
756 }
757 }
758 $Output .= '</ul>';
759 $Output .= $this->ShowTable($Table, $Filter, $Title, $RowActions, $ExcludeColumn);
760 return $Output;
761 }
762
763 function ShowFavorites()
764 {
765 $this->MenuItems = array();
766 $DbResult = $this->Database->query('SELECT `MenuItem`.`Id`, `MenuItem`.`Name`, `MenuItem`.`Parent`, `Action`.`URL` AS `URL`, `ActionIcon`.`Name` AS `IconName`, `Action`.`PermissionOperation` AS `Permission` FROM `MenuItemFavorite` ' .
767 'LEFT JOIN `MenuItem` ON `MenuItem`.`Id` = `MenuItemFavorite`.`MenuItem` '.
768 'LEFT JOIN `Action` ON `Action`.`Id` = `MenuItem`.`Action` '.
769 'LEFT JOIN `ActionIcon` ON `ActionIcon`.`Id` = `Action`.`Icon` '.
770 'WHERE `MenuItemFavorite`.`User`='.$this->System->User->User['Id'].' '.
771 'ORDER BY `MenuItem`.`Parent`,`MenuItem`.`Name`');
772 while ($DbRow = $DbResult->fetch_assoc())
773 {
774 //if ($DbRow['Permission'] != '')
775 $this->MenuItems[$DbRow['Id']] = $DbRow;
776 }
777 return $this->ShowMenuItem('', true);
778 }
779
780 function ShowMenu()
781 {
782 $this->MenuItems = array();
783 $DbResult = $this->Database->query('SELECT `MenuItem`.`Id`, `MenuItem`.`Name`, `MenuItem`.`Parent`, `Action`.`URL` AS `URL`, `ActionIcon`.`Name` AS `IconName`, `Action`.`PermissionOperation` AS `Permission` FROM `MenuItem` '.
784 'LEFT JOIN `Action` ON `Action`.`Id` = `MenuItem`.`Action` '.
785 'LEFT JOIN `ActionIcon` ON `ActionIcon`.`Id` = `Action`.`Icon` '.
786 'WHERE `MenuItem`.`Menu`=1 '.
787 'ORDER BY `MenuItem`.`Parent`,`MenuItem`.`Name`');
788 while ($DbRow = $DbResult->fetch_assoc())
789 {
790 //if ($DbRow['Permission'] != '')
791 $this->MenuItems[$DbRow['Id']] = $DbRow;
792 }
793 return $this->ShowMenuItem('');
794 }
795
796 function ShowMenuItem($Parent, $All = false)
797 {
798 $Output = '<ul style="list-style: none; margin-left:1em; padding-left:0em;">';
799 foreach ($this->MenuItems as $MenuItem)
800 {
801 if (($MenuItem['Parent'] == $Parent) or $All)
802 {
803 $LinkTitle = $MenuItem['Name'];
804 if ($MenuItem['URL'] != '')
805 {
806 $Icon = 'Device.png';
807 if (substr($MenuItem['URL'], 0, 4) != 'http') $MenuItem['URL'] = $this->System->Link($MenuItem['URL']);
808 $LinkTitle = MakeLink($MenuItem['URL'].'&amp;mi='.$MenuItem['Id'], $LinkTitle);
809 } else $Icon = 'Folder.png';
810 if ($MenuItem['IconName'] != '') $Image = '<img src="'.$this->System->Link('/images/favicons/'.$MenuItem['IconName']).'"/>&nbsp;';
811 else $Image = '<img src="'.$this->System->Link('/images/favicons/'.$Icon).'"/>&nbsp;';
812 //if ($this->System->User->CheckPermission($this->TableToModule($Table), 'Write') or !defined('NEW_PERMISSION'))
813 $Output .= '<li>'.$Image.$LinkTitle.'</li>';
814 if ($All == false) $Output .= $this->ShowMenuItem($MenuItem['Id']);
815 }
816 }
817 $Output .= '</ul>';
818 return $Output;
819 }
820
821 function TableToModule($Table)
822 {
823 $DbResult = $this->Database->query('SELECT (SELECT `Name` FROM `Module` '.
824 'WHERE `Module`.`Id`=`Model`.`Module`) AS `Name` FROM `Model` WHERE `Name`="'.$Table.'"');
825 if ($DbResult->num_rows == 1)
826 {
827 $DbRow = $DbResult->fetch_assoc();
828 return $DbRow['Name'];
829 } else return '';
830 }
831
832 function ShowAction($Name, $Target, $Icon, $Confirm = '')
833 {
834 $Output = '<img alt="'.$Name.'" title="'.$Name.'" src="'.
835 $Icon.'"/>';
836 if ($this->ShowActionName) $Output .= $Name;
837 if ($Confirm != '')
838 $Confirm = ' onclick="return confirmAction(\''.$Confirm.'\');"';
839 $Output = '<a href="'.$Target.'"'.$Confirm.'>'.$Output.'</a>';
840 return $Output;
841 }
842}
843
844class ModuleIS extends AppModule
845{
846 var $DashboardItems;
847
848 function __construct($System)
849 {
850 parent::__construct($System);
851 $this->Name = 'IS';
852 $this->Title = 'Information system';
853 $this->Version = '1.0';
854 $this->Creator = 'Chronos';
855 $this->License = 'GNU/GPLv3';
856 $this->Description = 'User interface for generic information system';
857 $this->Dependencies = array();
858
859 $this->DashboardItems = array();
860 }
861
862 function DoInstall()
863 {
864 }
865
866 function DoUninstall()
867 {
868 }
869
870 function DoStart()
871 {
872 $this->System->RegisterPage('is', 'PageIS');
873 $this->System->FormManager->RegisterClass('MenuItem', array(
874 'Title' => 'Položky nabídky',
875 'Table' => 'MenuItem',
876 'Items' => array(
877 'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''),
878 'Parent' => array('Type' => 'TMenuItem', 'Caption' => 'Rodič', 'Default' => '', 'Null' => true),
879 'Action' => array('Type' => 'TAction', 'Caption' => 'Akce', 'Default' => ''),
880 'Menu' => array('Type' => 'TMenu', 'Caption' => 'Nabídka', 'Default' => ''),
881 'Items' => array('Type' => 'TMenuItemListParent', 'Caption' => 'Položky'),
882 ),
883 ));
884 $this->System->FormManager->RegisterClass('MenuItemFavorite', array(
885 'Title' => 'Oblíbené položky nabídky',
886 'Table' => 'MenuItemFavorite',
887 'Items' => array(
888 'User' => array('Type' => 'TUser', 'Caption' => 'Uživatele', 'Default' => '0'),
889 'MenuItem' => array('Type' => 'TMenuItem', 'Caption' => 'Položka nabídky', 'Default' => '0'),
890 ),
891 ));
892 $this->System->FormManager->RegisterClass('Menu', array(
893 'Title' => 'Nabídky',
894 'Table' => 'Menu',
895 'Items' => array(
896 'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''),
897 'Items' => array('Type' => 'TMenuItemListMenu', 'Caption' => 'Položky'),
898 ),
899 ));
900 $this->System->FormManager->RegisterFormType('TMenuItem', array(
901 'Type' => 'Reference',
902 'Table' => 'MenuItem',
903 'Id' => 'Id',
904 'Name' => 'Name',
905 'Filter' => '1',
906 ));
907 $this->System->FormManager->RegisterFormType('TMenu', array(
908 'Type' => 'Reference',
909 'Table' => 'Menu',
910 'Id' => 'Id',
911 'Name' => 'Name',
912 'Filter' => '1',
913 ));
914 }
915
916 function DoStop()
917 {
918 }
919
920 function RegisterDashboardItem($Name, $Callback)
921 {
922 $this->DashboardItems[$Name] = array('Callback' => $Callback);
923 }
924
925 function UnregisterDashboardItem($Name)
926 {
927 unset($this->DashboardItems[$Name]);
928 }
929}
Note: See TracBrowser for help on using the repository browser.