Changeset 288 for trunk/includes/global_function.php

Timestamp:

Dec 22, 2009, 1:10:06 PM (14 years ago)

Author:

george

Message:

• Upraveno: Vytovřena funkce pro podporu řazení tabulek. Různé tabulky načítané za databáze mají nyní v hlavičce možnost řazení sestupně/vzestupně podle dostupných sloupců.

File:

• trunk/includes/global_function.php (modified) (1 diff)

trunk/includes/global_function.php

@@ -87 +87 @@
     'Output' => $Result,
   ));
+}
+
+$OrderDirSQL = array('ASC', 'DESC');
+$OrderArrowImage = array('sort_asc.png', 'sort_desc.png');
+
+function GetOrderTableHeader($Columns, $DefaultColumn)
+{
+  global $OrderDirSQL, $OrderArrowImage;
+  
+  if(array_key_exists('OrderCol', $_GET)) $_SESSION['OrderCol'] = $_GET['OrderCol'];
+  if(array_key_exists('OrderDir', $_GET)) $_SESSION['OrderDir'] = $_GET['OrderDir'];
+  if(!array_key_exists('OrderCol', $_SESSION)) $_SESSION['OrderCol'] = $DefaultColumn;
+  if(!array_key_exists('OrderDir', $_SESSION)) $_SESSION['OrderDir'] = 0;
+  
+  // Check OrderCol
+  $Found = false;
+  foreach($Columns as $Column)
+  {
+    if($Column['Name'] == $_SESSION['OrderCol'])
+    {
+      $Found = true;    
+      break;
+    }
+  }
+  if($Found == false) $_SESSION['OrderCol'] = $DefaultColumn;
+  // Check OrderDir
+  if(($_SESSION['OrderDir'] != 0) and ($_SESSION['OrderDir'] != 1)) $_SESSION['OrderDir'] = 0;
+  
+  $Result = '';
+  $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
+  foreach($Columns as $Index => $Column)
+  {
+    $QueryItems['OrderCol'] = $Column['Name'];
+    $QueryItems['OrderDir'] = 1 - $_SESSION['OrderDir'];
+    if($Column['Name'] == $_SESSION['OrderCol']) $ArrowImage = '<img  style="vertical-align: middle; border: 0px;" src="images/'.$OrderArrowImage[$_SESSION['OrderDir']].'" alt="order arrow">';
+      else $ArrowImage = '';
+    if($Column['Name'] == '') $Result .= '<th>'.$Column['Title'].'</th>';
+      else $Result .= '<th><a href="?'.SetQueryStringArray($QueryItems).'">'.$Column['Title'].$ArrowImage.'</a></th>';
+  }
+  return(array(
+    'SQL' => ' ORDER BY '.$_SESSION['OrderCol'].' '.$OrderDirSQL[$_SESSION['OrderDir']],
+    'Output' => '<tr>'.$Result.'</tr>')
+  );
 }