Changeset 873 for trunk/Common/VCL/Database.php

Timestamp:

Apr 6, 2020, 11:17:40 PM (5 years ago)

Author:

chronos

Message:

• Modified: Improved code format.

File:

• trunk/Common/VCL/Database.php (modified) (5 diffs)

trunk/Common/VCL/Database.php

@@ -28 +28 @@
 
     $ColumnSQL = array();
-    foreach($this->Columns as $Column)
+    foreach ($this->Columns as $Column)
     {
       $ColumnSQL[] = $Column->Name;
@@ -35 +35 @@
 
     // Get total filtered item count in database
-    if($this->Filter != '')
+    if ($this->Filter != '')
     {
       $Query = 'SELECT COUNT(*) FROM (SELECT '.$ColumnSQL.' FROM '.$this->SQL.') AS `TS` '.$this->Filter;
@@ -46 +46 @@
     $this->Rows = array();
     $VisibleItemCount = 0;
-    if(($this->SortOrder != 0) and ($this->SortOrder != 1)) $this->SortOrder = 0;
-    //if($this->SortColumn)
+    if (($this->SortOrder != 0) and ($this->SortOrder != 1)) $this->SortOrder = 0;
+    //if ($this->SortColumn)
     $this->SortColumn = $this->Columns[0]->Name;
     $this->OrderSQL = ' ORDER BY `'.$this->SortColumn.'` '.$this->OrderDirSQL[$this->SortOrder];
@@ -54 +54 @@
       $this->Filter.' '.$this->OrderSQL.$SQLLimit;
     $DbResult = $this->Database->query($Query);
-    while($DbRow = $DbResult->fetch_assoc())
+    while ($DbRow = $DbResult->fetch_assoc())
     {
-      if(method_exists($this->OnRowDraw[0], $this->OnRowDraw[1]))
+      if (method_exists($this->OnRowDraw[0], $this->OnRowDraw[1]))
         $DbRow = call_user_func($this->OnRowDraw, $DbRow);
       $this->Rows[] = $DbRow;
@@ -62 +62 @@
     }
     $Row = '<td colspan="'.count($this->Columns).'" style="text-align: right;">Zobrazeno <strong>'.$VisibleItemCount.'</strong>';
-    if($this->Filter != '') $Row .= ' z filtrovaných <strong>'.$TotalFilteredCount.'</strong>';
+    if ($this->Filter != '') $Row .= ' z filtrovaných <strong>'.$TotalFilteredCount.'</strong>';
     $Row .= ' z celkem <strong>'.$TotalCount.'</strong>';
     $ListView->Rows[] = $Row;
     $Output = parent::Show();
-    return($Output);
+    return ($Output);
   }
 }