Changeset 69 for trunk/Packages/Common/Common.php

Timestamp:

Feb 28, 2016, 10:54:30 AM (9 years ago)

Author:

chronos

Message:

• Modified: Use object oriented approach for page drawing using Application class.
• Added: SQL updated will be automatic using UpdateTrace.php file.
• Added: Use generic setup page at URL /setup for SQL structure update.
• Modified: Update Common package to newer version.

File:

• trunk/Packages/Common/Common.php (modified) (4 diffs)

trunk/Packages/Common/Common.php

@@ -10 +10 @@
 include_once(dirname(__FILE__).'/VarDumper.php');
 include_once(dirname(__FILE__).'/Error.php');
+include_once(dirname(__FILE__).'/Base.php');
+include_once(dirname(__FILE__).'/Application.php');
+include_once(dirname(__FILE__).'/AppModule.php');
+include_once(dirname(__FILE__).'/Config.php');
+include_once(dirname(__FILE__).'/Page.php');
+include_once(dirname(__FILE__).'/Locale.php');
+include_once(dirname(__FILE__).'/Update.php');
+include_once(dirname(__FILE__).'/Setup.php');
+include_once(dirname(__FILE__).'/Table.php');
 
 class PackageCommon
@@ -15 +24 @@
   var $Name;
   var $Version;
+  var $ReleaseDate;
   var $License;
   var $Creator;
@@ -22 +32 @@
   {
     $this->Name = 'Common';
-    $this->Version = '1.1';
+    $this->Version = '1.2';
+    $this->ReleaseDate = strtotime('2016-01-22');
     $this->Creator = 'Chronos';
     $this->License = 'GNU/GPL';
@@ -28 +39 @@
   }
 }
+
+class Paging
+{
+  var $TotalCount;
+  var $ItemPerPage;
+  var $Around;
+  var $SQLLimit;
+  var $Page;
+
+  function __construct(System $System)
+  {
+    $this->ItemPerPage = $System->Config['Web']['ItemsPerPage'];
+    $this->Around = $System->Config['Web']['VisiblePagingItems'];
+  }
+
+  function Show()
+  {
+    $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
+
+    $Result = '';
+    if(array_key_exists('all', $QueryItems))
+    {
+      $PageCount = 1;
+      $ItemPerPage = $this->TotalCount;
+    } else
+    {
+      $ItemPerPage = $this->ItemPerPage;
+      $Around = round($this->Around / 2);
+      $PageCount = floor($this->TotalCount / $ItemPerPage) + 1;
+    }
+
+    if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 0;
+    if(array_key_exists('page', $_GET)) $_SESSION['Page'] = $_GET['page'] * 1;
+    if($_SESSION['Page'] < 0) $_SESSION['Page'] = 0;
+    if($_SESSION['Page'] >= $PageCount) $_SESSION['Page'] = $PageCount - 1;
+    $CurrentPage = $_SESSION['Page'];
+
+    $Result .= 'Počet položek: <strong>'.$this->TotalCount.'</strong> &nbsp; Stránky: ';
+
+    $Result = '';
+    if($PageCount > 1)
+    {
+      if($CurrentPage > 0)
+      {
+        $QueryItems['page'] = 0;
+        $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&lt;&lt;</a> ';
+        $QueryItems['page'] = ($CurrentPage - 1);
+        $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&lt;</a> ';
+      }
+      $PagesMax = $PageCount - 1;
+      $PagesMin = 0;
+      if($PagesMax > ($CurrentPage + $Around)) $PagesMax = $CurrentPage + $Around;
+      if($PagesMin < ($CurrentPage - $Around))
+      {
+        $Result.= ' ... ';
+        $PagesMin = $CurrentPage - $Around;
+      }
+      for($i = $PagesMin; $i <= $PagesMax; $i++)
+      {
+        if($i == $CurrentPage) $Result.= '<strong>'.($i + 1).'</strong> ';
+        else {
+         $QueryItems['page'] = $i;
+         $Result .= '<a href="?'.SetQueryStringArray($QueryItems).'">'.($i + 1).'</a> ';
+        }
+      }
+      if($PagesMax < ($PageCount - 1)) $Result .= ' ... ';
+      if($CurrentPage < ($PageCount - 1))
+      {
+        $QueryItems['page'] = ($CurrentPage + 1);
+        $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&gt;</a> ';
+        $QueryItems['page'] = ($PageCount - 1);
+        $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&gt;&gt;</a>';
+      }
+    }
+    $QueryItems['all'] = '1';
+    if($PageCount > 1) $Result.= ' <a href="?'.SetQueryStringArray($QueryItems).'">Vše</a>';
+
+    $Result = '<div style="text-align: center">'.$Result.'</div>';
+    $this->SQLLimit = ' LIMIT '.$CurrentPage * $ItemPerPage.', '.$ItemPerPage;
+    $this->Page = $CurrentPage;
+    return($Result);
+  }
+}