'.$List['Title'].''; foreach($List['Items'] as $Item) { if($Item['VisibleInList'] == 1) $Output .= ''; } $Output .= ''; if(($Column != '') and ($ParentId != 0)) $Where = $Column.'='.$ParentId; else $Where = '1'; // Handle ordering if(array_key_exists('OrderColumn', $_GET)) { if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse orded $_SESSION['OrderDirection'] = ($_SESSION['OrderDirection'] + 1) % 2; if($_SESSION['OrderTable'] != $List['TableName']) // Different table => set ascending order $_SESSION['OrderDirection'] = 0; $_SESSION['OrderColumn'] = $_GET['OrderColumn']; $_SESSION['OrderTable'] = $List['TableName']; } if(array_key_exists('OrderColumn', $_SESSION) and ($_SESSION['OrderTable'] == $List['TableName'])) { $OrderDirection = array('ASC', 'DESC'); $Where .= ' ORDER BY `'.$_SESSION['OrderColumn'].'` '.$OrderDirection[$_SESSION['OrderDirection']]; } if(array_key_exists('Page', $_GET)) $Page = $_GET['Page']; else $Page = 0; $DbResult = $Database->select($List['TableName'], 'COUNT(*)', $Where); //echo($Database->LastQuery); $DbRow = $DbResult->fetch_array(); $TotalItemCount = $DbRow[0]; $DbResult = $Database->select($List['TableName'], '*', $Where.' LIMIT '.($Page * $Config['Web']['ItemsPerPage']).', '.$Config['Web']['ItemsPerPage']); while($DbRow = $DbResult->fetch_array()) { $Output .= ''; foreach($List['Items'] as $Index => $Item) { if($Item['VisibleInList'] == 1) { $ItemType = explode(':', $Item['Type']); $Type = $Types[$ItemType[0]]; if(count($ItemType) > 1) $Type['Parameter'] = $ItemType[1]; if(is_callable($Type['ViewHtml'])) $Value = $Type['ViewHtml']($Type, $DbRow[$Index], $List['TableName'], $DbRow['Id']); else $Value = $Type['ViewHtml']; $Value = str_replace('%value%', $DbRow[$Index], $Value); $Output .= ''; } } $Output .= ''; } $Output .= '

'.$Item['TextBefore'].'	Akce
'.$Value.'	Zobrazit Editovat Smazat

'; $Output .= PagesList($Page, $TotalItemCount); $Output .= 'Přidat'; return($Output); } function ShowEditItem($List, $Id) { global $Database, $Types; $Output = '

'; $Output .= ''; $DbResult = $Database->select($List['TableName'], '*', 'Id='.$Id); while($DbRow = $DbResult->fetch_array()) { foreach($List['Items'] as $Index => $Item) { $ItemType = explode(':', $Item['Type']); if($ItemType[0] != 'PointerOneToMany') { $Type = $Types[$ItemType[0]]; if(count($ItemType) > 1) $Type['Parameter'] = $ItemType[1]; if(is_callable($Type['EditHtml'])) $Value = $Type['EditHtml']($Type, $DbRow[$Index], $List['TableName'], $DbRow['Id']); else $Value = $Type['EditHtml']; $Value = str_replace('%value%', $DbRow[$Index], $Value); $Value = str_replace('%name%', $Index, $Value); if($Item['Required'] == 1) $Required = ' *'; else $Required = ''; $Output .= ''; } } } $Output .= '

Jméno položky	Hodnota
'.$Item['TextBefore'].':'.$Required.'	'.$Value.'

Zpět'; return($Output); } function ShowEditItemFinish($List, $Id) { global $Database, $Types; $Values = array(); foreach($List['Items'] as $Index => $Item) { $ItemType = explode(':', $Item['Type']); if($ItemType[0] != 'PointerOneToMany') { $Values[$Index] = $_POST[$Index]; } } $Database->update($List['TableName'], 'Id='.$Id, $Values); //echo($Database->LastQuery); $Output = 'Změny uloženy.'; $Output .= ShowViewItem($List, $Id); return($Output); } function ShowAddItem($List) { global $Database, $Types; $Output = '

'; $Output .= ''; foreach($List['Items'] as $Index => $Item) { $ItemType = explode(':', $Item['Type']); if($ItemType[0] != 'PointerOneToMany') { $Type = $Types[$ItemType[0]]; if(count($ItemType) > 1) $Type['Parameter'] = $ItemType[1]; if(is_callable($Type['EditHtml'])) $Value = $Type['EditHtml']($Type, $Type['InitValue'], $List['TableName'], 0); else $Value = $Type['EditHtml']; $Value = str_replace('%value%', $Type['InitValue'], $Value); $Value = str_replace('%name%', $Index, $Value); if($Item['Required'] == 1) $Required = ' *'; else $Required = ''; $Output .= ''; } } $Output .= '

Jméno položky	Hodnota
'.$Item['TextBefore'].':'.$Required.'	'.$Value.'

Zpět'; return($Output); } function ShowAddItemFinish($List) { global $Database, $Types; $Values = array(); foreach($List['Items'] as $Index => $Item) { $ItemType = explode(':', $Item['Type']); if($ItemType[0] != 'PointerOneToMany') { $Values[$Index] = $_POST[$Index]; } } $Database->insert($List['TableName'], $Values); //echo($Database->LastQuery); $Output = 'Položka přidána'; $Output .= ShowViewItem($List, $Database->insert_id); return($Output); } function ShowViewItem($List, $Id) { global $Database, $Types, $Lists; $Output = ''; $DbResult = $Database->select($List['TableName'], '*', 'Id='.$Id); while($DbRow = $DbResult->fetch_array()) { $Output = ''; $Output .= ''; foreach($List['Items'] as $Index => $Item) { $ItemType = explode(':', $Item['Type']); if($ItemType[0] != 'PointerOneToMany') { $Type = $Types[$ItemType[0]]; if(count($ItemType) > 1) $Type['Parameter'] = $ItemType[1]; if(is_callable($Type['ViewHtml'])) $Value = $Type['ViewHtml']($Type, $DbRow[$Index], $List['TableName'], $DbRow['Id']); else $Value = $Type['ViewHtml']; $Value = str_replace('%value%', $DbRow[$Index], $Value); $Output .= ''; } } $Output .= '

Jméno položky	Hodnota
'.$Item['TextBefore'].':	'.$Value.'

'; $Output .= 'Editovat'; $Output .= ' Seznam'; $Output .= '

'; foreach($List['Items'] as $Index => $Item) { $ItemType = explode(':', $Item['Type']); if($ItemType[0] == 'PointerOneToMany') { $SubList = $Lists[$ItemType[1]]; $Output .= ShowList($SubList, $ItemType[2], $DbRow['Id']).'

'; } } } return($Output); } function ShowDeleteItem($List, $Id) { global $Database; $Database->delete($List['TableName'], 'Id='.$Id); $Output = 'Položka smazána.'; return($Output); } function TableList($System) { global $Lists; $Type = array('Uživatelské', 'Systémové'); $Output = ''.$Type[$System].' seznamy:
'; foreach($Lists as $Index => $List) { if(($List['System'] == $System) and ($List['VisibleInMenu'] == 1)) $Output .= ''.$List['Title'].'
'; } $Output .= '
'; return($Output); } function Output() { global $Lists; $PermanentVar = array('TableId', 'ItemId', 'ParentTable', 'ParentColumn', 'Action'); foreach($PermanentVar as $Var) { if(array_key_exists($Var, $_GET)) $_SESSION[$Var] = $_GET[$Var]; } $Output = ''; if(array_key_exists('TableId', $_SESSION) and array_key_exists($_SESSION['TableId'], $Lists)) { $List = $Lists[$_SESSION['TableId']]; if(array_key_exists('Action', $_SESSION)) { switch($_SESSION['Action']) { case 'EditItem': $Output = ShowEditItem($List, $_SESSION['ItemId']); break; case 'EditItemFinish': $Output = ShowEditItemFinish($List, $_SESSION['ItemId']); break; case 'DeleteItem': $Output = ShowDeleteItem($List, $_SESSION['ItemId']); break; case 'ViewItem': $Output = ShowViewItem($List, $_SESSION['ItemId']); break; case 'AddItem': $Output = ShowAddItem($List); break; case 'AddItemFinish': $Output = ShowAddItemFinish($List); break; case 'ShowList': default: $Output = ShowList($List); } } else $Output = ShowList($List); } return($Output); } function LoadListDefinition() { global $Database, $Lists; $DbResult = $Database->select('SystemList', '*'); while($DbRow = $DbResult->fetch_assoc()) { $Items = array(); $DbResult2 = $Database->select('SystemListItem', '`Name`, `TextBefore`, `TextAfter`, `Type`, `Default`, `Help`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`', 'List='.$DbRow['Id']); while($DbRow2 = $DbResult2->fetch_assoc()) { $Items[$DbRow2['Name']] = $DbRow2; } $List = array( 'TableName' => $DbRow['TableName'], 'Title' => $DbRow['Title'], 'System' => $DbRow['System'], 'VisibleInMenu' => $DbRow['VisibleInMenu'], 'Items' => $Items, ); $Lists[$List['TableName']] = $List; } } ?>