Changeset 2 for data_types.php

Timestamp:

Sep 10, 2008, 8:07:24 PM (16 years ago)

Author:

george

Message:

• Upraveno: Uchování a načtení struktury seznamů a položek dynamicky z databáze namísto soubor lists.php, kde zůstaly základní definice tabulek.
• Upraveno: Zobrazení podpoložek typu Pointer podle rodičovského id.
• Přidáno: Stránkování u dlouhých výpisů položek seznamů.
• Přidáno: Vlastnost VisibleInList určující, které vlastnosti položky zobrazovat v přehledovém seznamu a které ne. Zobrazovat vše by bylo nepřehledné a nepraktické.

File:

• data_types.php (modified) (6 diffs)

data_types.php

@@ -3 +3 @@
 include('types.php');
 include('lists.php');
+include('common.php');
 
 function ShowList($List)
 {
-  global $Database, $Types;
+  global $Database, $Types, $Config;
 
   $Output = '<table class="WideTable"><tr>';
   foreach($List['Items'] as $Item)
   {
-    $Output .= '<th>'.$Item['TextBefore'].'</th>';
+    if($Item['VisibleInList'] == 1)
+      $Output .= '<th>'.$Item['TextBefore'].'</th>';
   }
   $Output .= '<th>Akce</th></tr>';
 
-  $DbResult = $Database->select($List['TableName'], '*');
+  if(array_key_exists('ParentTable', $_GET) and array_key_exists('ParentId', $_GET))
+  {
+    //$_SESSION['ParentId'] = $_GET['ParentId'];
+    //$_SESSION['ParentTable'] = $_GET['ParentTable'];
+    $Where = $_GET['ParentTable'].'='.$_GET['ParentId'].' ';
+  }
+  else $Where = '1';
+
+  if(array_key_exists('Page', $_GET)) $Page = $_GET['Page']; else $Page = 0;
+  $DbResult = $Database->select($List['TableName'], 'COUNT(*)', $Where);
+  $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())
   {
@@ -21 +36 @@
     foreach($List['Items'] as $Index => $Item)
     {
-      $Type = $Types[$Item['Type']];
-      if(is_callable($Type['ViewHtml'])) $Value = $Type['ViewHtml']($Type, $DbRow[$Index]);
-      else $Value = $Type['ViewHtml'];
-      $Value = str_replace('%value%', $DbRow[$Index], $Value);
-      $Output .= '<td>'.$Value.'</td>';
+      if($Item['VisibleInList'] == 1)
+      {
+        $Type = $Types[$Item['Type']];
+        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 .= '<td>'.$Value.'</td>';
+      }
     }
     $Output .= '<td><a href="?Action=View&amp;Id='.$DbRow['Id'].'">Zobrazit</a> <a href="?Action=Edit&amp;Id='.$DbRow['Id'].'">Edit</a> <a href="?Action=Delete&amp;Id='.$DbRow['Id'].'">Smazat</a></td></tr>';
   }
   $Output .= '</table>';
+  $Output .= PagesList($Page, $TotalItemCount).'<br />';
   $Output .= '<a href="?Action=Add">Přidat</a>';
   return($Output);
@@ -47 +66 @@
     {
       $Type = $Types[$Item['Type']];
-      if(is_callable($Type['EditHtml'])) $Value = $Type['EditHtml']($Type, $DbRow[$Index]);
+      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);
@@ -84 +103 @@
   {
     $Type = $Types[$Item['Type']];
-    if(is_callable($Type['EditHtml'])) $Value = $Type['EditHtml']($Type, $Type['InitValue']);
+    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);
@@ -123 +142 @@
     {
       $Type = $Types[$Item['Type']];
-      if(is_callable($Type['ViewHtml'])) $Value = $Type['ViewHtml']($Type, $DbRow[$Index]);
+      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);
@@ -199 +218 @@
 }
 
+function LoadListDefinition()
+{
+  global $Database, $Lists;
+
+  $DbResult = $Database->select('List', '*');
+  while($DbRow = $DbResult->fetch_assoc())
+  {
+    $Items = array();
+    $DbResult2 = $Database->select('ListItem', '`Name`, `TextBefore`, `TextAfter`, `Type`, `Default`, `Help`, `Required`, `Editable`, `VisibleInList`', 'List='.$DbRow['Id']);
+    while($DbRow2 = $DbResult2->fetch_assoc())
+    {
+      $Items[$DbRow2['Name']] = $DbRow2;
+    }
+    $List = array(
+     'TableName' => $DbRow['TableName'],
+     'Title' => $DbRow['Title'],
+     'Items' => $Items,
+    );
+    $Lists[] = $List;
+  }
+}
 ?>