System->User->CheckPermission('IS', 'Manage')) return('Nemáte oprávnění'); if(array_key_exists('a', $_GET)) $Action = $_GET['a']; else $Action = ''; if(array_key_exists('t', $_GET)) $Table = $_GET['t']; else $Table = ''; if(array_key_exists('i', $_GET)) $ItemId = $_GET['i']; else $ItemId = 0; if($Action == 'list') $Content = $this->ShowList($Table); else if($Action == 'select') $Content = $this->ShowSelect($Table); else if($Action == 'edit') $Content = $this->ShowEdit($Table, $ItemId); else if($Action == 'add') $Content = $this->ShowAdd($Table); else if($Action == 'view') $Content = $this->ShowView($Table, $ItemId); else if($Action == 'delete') $Content = $this->ShowDelete($Table, $ItemId); else $Content = $this->Dashboard(); if($this->HideMenu == false) { $Output = '
'; $Output .= 'Nabídka:'.$this->ShowMenuItem(''); $Output .= ''; $Output .= $Content; $Output .= '
'; } else $Output = $Content; return($Output); } function Dashboard() { $Output = 'Nástěnka:
'; $DbResult = $this->Database->select('Task', 'COUNT(*)', 'Progress < 100'); $DbRow = $DbResult->fetch_row(); $Output .= 'Nedokončených úkolů: '.$DbRow['0'].'
'; $DbResult = $this->Database->select('Member', 'COUNT(*)', '1'); $DbRow = $DbResult->fetch_row(); $Output .= 'Zákazníků: '.$DbRow['0'].'
'; $DbResult = $this->Database->select('Subject', 'COUNT(*)', '1'); $DbRow = $DbResult->fetch_row(); $Output .= 'Subjektů: '.$DbRow['0'].'
'; $DbResult = $this->Database->select('User', 'COUNT(*)', '1'); $DbRow = $DbResult->fetch_row(); $Output .= 'Uživatelů: '.$DbRow['0'].'
'; $DbResult = $this->Database->select('NetworkDevice', 'COUNT(*)', '1'); $DbRow = $DbResult->fetch_row(); $Output .= 'Registrovaných zařízení: '.$DbRow['0'].'
'; $DbResult = $this->Database->select('FinanceOperation', 'SUM(Value)', '1'); $DbRow = $DbResult->fetch_row(); $Output .= 'Stav placení: '.$DbRow['0'].'
'; return($Output); } function ShowEdit($Table, $Id) { $Output = ''; if(array_key_exists('o', $_GET)) { if($_GET['o'] == 'save') { $Form = new Form($this->System->FormManager); $Form->SetClass($Table); $Form->LoadValuesFromForm(); $Form->SaveValuesToDatabase($Id); $Output .= $this->SystemMessage('Úprava položky', 'Položka upravena'); $Output .= $this->ShowView($Table, $Id); } } else { $Form = new Form($this->System->FormManager); $Form->SetClass($Table); $Form->LoadValuesFromDatabase($Id); $Form->OnSubmit = '?a=edit&t='.$Table.'&i='.$_GET['i'].'&o=save'; $Output .= $Form->ShowEditForm(); $Output .= ''; } return($Output); } function ShowDelete($Table, $Id) { $Output = ''; $this->Database->delete($Table, 'Id='.$Id); $Output .= $this->SystemMessage('Odstranění položky', 'Položka odstraněna'); $Output .= $this->ShowList($Table); return($Output); } function ShowAdd($Table) { $Output = ''; if(array_key_exists('o', $_GET)) { if($_GET['o'] == 'save') { $Form = new Form($this->System->FormManager); $Form->SetClass($Table); $Form->LoadValuesFromForm(); $Form->SaveValuesToDatabase(0); $Output .= $this->SystemMessage('Přidání položky', 'Nová položka vytvořena'); $Id = $this->Database->insert_id; //$this->Database->update($Table, 'Id='.$Id, // array('UserCreate' => $this->System->User->User['Id'], // 'TimeCreate' => 'NOW()')); $Output .= $this->ShowView($Table, $Id); } } else { $Form = new Form($this->System->FormManager); $Form->SetClass($Table); $Form->OnSubmit = '?a=add&t='.$Table.'&o=save'; $Output .= $Form->ShowEditForm(); $Output .= ''; } return($Output); } function ShowView($Table, $Id) { if($Table != '') $FormClass = $this->System->FormManager->Classes[$Table]; else return($this->SystemMessage('Chyba', 'Tabulka nenalezena')); $Form = new Form($this->System->FormManager); $Form->SetClass($Table); $Form->LoadValuesFromDatabase($Id); $Form->OnSubmit = '?a=view'; $Output = $Form->ShowViewForm(); $Output .= '
'; // Show ManyToOne relations foreach($Form->Definition['Items'] as $Index => $Item) if((array_key_exists($Item['Type'], $this->System->FormManager->FormTypes) and ($this->System->FormManager->FormTypes[$Item['Type']]['Type'] == 'ManyToOne'))) { $Output .= $this->ShowList($this->System->FormManager->FormTypes[$Item['Type']]['Table'], '`'. $this->System->FormManager->FormTypes[$Item['Type']]['Ref'].'`='.$Id, $Item['Caption']).'
'; } return($Output); } function ShowTable($Table, $Filter = '', $Title = '', $RowActions = array()) { if($Table != '') $FormClass = $this->System->FormManager->Classes[$Table]; else return($this->SystemMessage('Chyba', 'Tabulka nenalezena')); // Build user filter $UserFilter = ''; $Columns = array('Id' => '`Id`'); if(array_key_exists('filter', $_GET) and ($_GET['filter'] == 1)) { foreach($FormClass['Items'] as $ItemIndex => $FormItem) if(!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne'))) { $UseType = $UseType = $FormItem['Type']; if(array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes)) { if(!array_key_exists($FormItem['Type'], $this->System->FormManager->Type->TypeDefinitionList)) $this->System->FormManager->Type->RegisterType($FormItem['Type'], '', $this->System->FormManager->FormTypes[$FormItem['Type']]); if($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Reference') $UseType = 'OneToMany'; else if($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Enumeration') $UseType = 'Enumeration'; } $FilterName = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterName', array('Name' => $ItemIndex, 'Type' => $FormItem['Type'])); if(array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != '')) $UserFilter .= ' AND ('.$FilterName.' LIKE "%'.$_POST['Filter'.$ItemIndex].'%")'; } } if(($Filter == '') and ($UserFilter != '')) $Filter = '1 '.$UserFilter; if($Filter != '') $Filter = ' WHERE '.$Filter; foreach($FormClass['Items'] as $ItemIndex => $FormItem) if(!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne'))) { $TableColumns[] = array('Name' => $ItemIndex, 'Title' => $FormItem['Caption']); $UseType = $UseType = $FormItem['Type']; if(array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes)) { if(!array_key_exists($FormItem['Type'], $this->System->FormManager->Type->TypeDefinitionList)) $this->System->FormManager->Type->RegisterType($FormItem['Type'], '', $this->System->FormManager->FormTypes[$FormItem['Type']]); if($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Reference') $UseType = 'OneToMany'; else if($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Enumeration') $UseType = 'Enumeration'; } if(array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != '')) $Value = $_POST['Filter'.$ItemIndex]; else $Value = ''; if($ItemIndex == 'Id') unset($Columns['Id']); $Columns[] = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterNameQuery', array('Value' => $Value, 'Name' => $ItemIndex, 'Type' => $FormItem['Type'])); } // Get total item count in database $Query = 'SELECT COUNT(*) FROM `'.$FormClass['Table'].'`'; $DbResult = $this->Database->query($Query); $DbRow = $DbResult->fetch_assoc(); $TotalCount = $DbRow['COUNT(*)']; // Get total filtered item count in database $Columns = implode(',', $Columns); if($UserFilter != '') { $Query = 'SELECT COUNT(*) FROM (SELECT '.$Columns.' FROM `'.$FormClass['Table'].'`) AS `TS` '.$Filter; $DbResult = $this->Database->query($Query); $DbRow = $DbResult->fetch_row(); $TotalFilteredCount = $DbRow[0]; } else $TotalFilteredCount = $TotalCount; $PageList = GetPageList($TotalFilteredCount); $Output = '
'.$FormClass['Title'].'
'; $Output .= $PageList['Output']; $Output .= ''; $TableColumns[] = array('Name' => '', 'Title' => 'Akce'); if(!array_key_exists('DefaultSortColumn', $FormClass)) $FormClass['DefaultSortColumn'] = 'Id'; $Order = GetOrderTableHeader($TableColumns, $FormClass['DefaultSortColumn'], 0); $Output .= $Order['Output']; // Show search fields $Output .= ''; foreach($FormClass['Items'] as $ItemIndex => $FormItem) if(!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne'))) { if(array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != '')) $Value = $_POST['Filter'.$ItemIndex]; else $Value = ''; $Output .= ''; } $Output .= ''; // Load and show items $Query = 'SELECT * FROM (SELECT '.$Columns.' FROM `'.$FormClass['Table'].'`) AS `TS` '.$Filter.' '.$Order['SQL'].$PageList['SQLLimit']; $VisibleItemCount = 0; $DbResult = $this->Database->query($Query); while($Row = $DbResult->fetch_assoc()) { $Output .= ''; foreach($FormClass['Items'] as $ItemIndex => $FormItem) if(!array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) or (array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes) and ($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] != 'ManyToOne'))) { //$Output .= ''; $UseType = $UseType = $FormItem['Type']; if(array_key_exists($FormItem['Type'], $this->System->FormManager->FormTypes)) { if(!array_key_exists($FormItem['Type'], $this->System->FormManager->Type->TypeDefinitionList)) $this->System->FormManager->Type->RegisterType($FormItem['Type'], '', $this->System->FormManager->FormTypes[$FormItem['Type']]); if($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Reference') $UseType = 'OneToMany'; else if($this->System->FormManager->FormTypes[$FormItem['Type']]['Type'] == 'Enumeration') $UseType = 'Enumeration'; } $Row[$ItemIndex] = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnLoadDb', array('Value' => $Row[$ItemIndex], 'Name' => $ItemIndex, 'Type' => $FormItem['Type'])); $Value = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnView', array('Value' => $Row[$ItemIndex], 'Name' => $ItemIndex, 'Type' => $FormItem['Type'], 'Filter' => $Row[$ItemIndex.'_Filter'])); if($Value == '') $Value = ' '; $Output .= ''; } $Output .= ''; $VisibleItemCount = $VisibleItemCount + 1; } $Output .= ''; $Output .= '
'.$Row[$ItemIndex].''.$Value.''.str_replace('#RowId', $Row['Id'], $RowActions).'
Zobrazeno '.$VisibleItemCount.''; if($UserFilter != '') $Output .= ' z filtrovaných '.$TotalFilteredCount.''; $Output .= ' z celkem '.$TotalCount.'
'; $Output .= $PageList['Output']; return($Output); } function ShowSelect($Table, $Filter = '', $Title = '') { $this->BasicHTML = true; $this->HideMenu = true; $RowActions = 'Vybrat'; $Output = $this->ShowTable($Table, $Filter, $Title, $RowActions); return($Output); } function ShowList($Table, $Filter = '', $Title = '') { $RowActions = 'Ukázat'. 'Upravit'. 'Smazat'; if($Table != '') $FormClass = $this->System->FormManager->Classes[$Table]; else return($this->SystemMessage('Chyba', 'Tabulka nenalezena')); if(array_key_exists('ItemActions', $FormClass)) { foreach($FormClass['ItemActions'] as $Action) $RowActions .= ''.$Action['Caption'].''; } $Output = $this->ShowTable($Table, $Filter, $Title, $RowActions); $Output .= ''; return($Output); } function ShowMenuItem($Parent) { if($this->MenuItemsLoaded == false) { $DbResult = $this->Database->query('SELECT `MenuItem`.`Id`, `MenuItem`.`Name`, `MenuItem`.`Parent`, `Action`.`URL` AS `URL`, `ActionIcon`.`Name` AS `IconName` FROM `MenuItem` '. 'LEFT JOIN `Action` ON `Action`.`Id` = `MenuItem`.`Action` '. 'LEFT JOIN `ActionIcon` ON `ActionIcon`.`Id` = `Action`.`Icon` '. 'ORDER BY `MenuItem`.`Parent`,`MenuItem`.`Name`'); while($DbRow = $DbResult->fetch_assoc()) { $this->MenuItems[$DbRow['Id']] = $DbRow; } $this->MenuItemsLoaded = true; } $Output = ''; return($Output); } } class ModuleIS extends AppModule { function __construct($System) { parent::__construct($System); $this->Name = 'Information system'; $this->Version = '1.0'; $this->Creator = 'Chronos'; $this->License = 'GNU/GPLv3'; $this->Description = 'User interface for generic information system'; $this->Dependencies = array(); } function Install() { } function Uninstall() { } function Start() { parent::Start(); $this->System->RegisterPage('is', 'PageIS'); $this->System->FormManager->RegisterClass('MenuItem', array( 'Title' => 'Položky nabídky', 'Table' => 'MenuItem', 'Items' => array( 'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''), 'Parent' => array('Type' => 'TMenuItem', 'Caption' => 'Rodič', 'Default' => '', 'Null' => true), 'Action' => array('Type' => 'TAction', 'Caption' => 'Akce', 'Default' => ''), 'Menu' => array('Type' => 'TMenu', 'Caption' => 'Nabídka', 'Default' => ''), 'Items' => array('Type' => 'TMenuItemListParent', 'Caption' => 'Položky'), ), )); $this->System->FormManager->RegisterClass('Menu', array( 'Title' => 'Nabídky', 'Table' => 'Menu', 'Items' => array( 'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''), 'Items' => array('Type' => 'TMenuItemListMenu', 'Caption' => 'Položky'), ), )); } function Stop() { } } ?>