Changeset 64 for www

Timestamp:

Apr 4, 2008, 8:11:34 AM (17 years ago)

Author:

george

Message:

Uživatelské nastavení zobrazování aktualit na hlavní stránce ukládané do cookie prohlížeče.

Location:

www

Files:

• index.php (modified) (5 diffs)
• index_new.php (deleted)

www/index.php

@@ -6 +6 @@
 
 $Database->select_db('share');
+
+function CategoryItemCompare($Item1, $Item2) 
+{
+  if ($Item1['Index'] == $Item2['Index']) return(0);
+  return ($Item1['Index'] > $Item2['Index']) ? -1 : 1;
+}
+
+// Process cookies
+if(array_key_exists('Action', $_GET))
+{
+  if($_GET['Action'] == 'CustomizeNewsSave')
+  {
+    $Checkbox = array('' => 0, 'on' => 1);
+    // print_r($_POST);
+    $Setting = array();
+    for($I = 0; $I < $_POST['NewsCategoryCount']; $I++)
+    {
+      if(($_POST['NewsCategoryDaysAgo'.$I]*1) < 0) $_POST['NewsCategoryIndex'.$I] = 0;
+      if(($_POST['NewsCategoryCount'.$I]*1) < 0) $_POST['NewsCategoryCount'.$I] = 0;
+      if(!array_key_exists('NewsCategoryEnabled'.$I, $_POST)) $_POST['NewsCategoryEnabled'.$I] = '';
+      $Setting[] = array('CategoryId' => $_POST['NewsCategoryId'.$I], 'Enabled' => $Checkbox[$_POST['NewsCategoryEnabled'.$I]], 'ItemCount' => ($_POST['NewsCategoryCount'.$I]*1), 'DaysAgo' => ($_POST['NewsCategoryDaysAgo'.$I]*1), 'Index' => ($_POST['NewsCategoryIndex'.$I]*1));
+    }
+    // Sort indexes
+    usort($Setting, 'CategoryItemCompare');
+    $Setting = array_reverse($Setting);
+    // Normalize indexes
+    foreach($Setting as $Index => $Item)
+      $Setting[$Index]['Index'] = $Index + 1;
+    
+    // print_r($Setting);
+
+    // Store new cookie value
+    $_COOKIE['NewsSetting'] = serialize($Setting);
+    setcookie('NewsSetting', $_COOKIE['NewsSetting']);
+  }
+}
 
 ?>
@@ -142 +178 @@
 
 // Zobrazení času běhu počítače
-$Data = explode(' ',exec('uptime'));
-$Data = array_slice($Data,3,-8);
-$Uptime = '';
-foreach($Data as $Item)
-{
-  if(strpos($Item,':')) $Uptime .= substr($Item,0,-1).' hodin';
-  else $Uptime .= $Item.' ';
-}
-$Uptime = str_replace('2 days,','2 dny a',$Uptime);
-$Uptime = str_replace('3 days,','3 dny a',$Uptime);
-$Uptime = str_replace('4 days,','4 dny a',$Uptime);
-$Uptime = str_replace('days,','dní a',$Uptime);
-$Uptime = str_replace('day,','den a',$Uptime);
-$Uptime = str_replace('min,','minut',$Uptime);
-echo('Server běží '.$Uptime);
+function GetServerUptime()
+{
+  $Data = explode(' ',exec('uptime'));
+  $Data = array_slice($Data,3,-8);
+  $Uptime = '';
+  foreach($Data as $Item)
+  {
+    if(strpos($Item,':')) $Uptime .= substr($Item,0,-1).' hodin';
+    else $Uptime .= $Item.' ';
+  }
+  $Uptime = str_replace('2 days,','2 dny a',$Uptime);
+  $Uptime = str_replace('3 days,','3 dny a',$Uptime);
+  $Uptime = str_replace('4 days,','4 dny a',$Uptime);
+  $Uptime = str_replace('days,','dní a',$Uptime);
+  $Uptime = str_replace('day,','den a',$Uptime);
+  $Uptime = str_replace('min,','minut',$Uptime);
+  return('Server běží '.$Uptime);
+}
+
+echo(GetServerUptime());
 
 echo('</td><td width="50%" valign="top" style="font-size: smaller;">');
@@ -169 +210 @@
 
 echo('<table width="100%"><tr><td><strong>Aktuálně:</strong></td><td align="right">
-<img alt="Teplomer" width="10" height="18" src="images/teplomer3.png"><a href="statistic/trafficview2.php?type=temp">'.$Teplota
-.'°C (mimo provoz)</a></td></tr></table>');
-
-$NewsCountPerCategory = 3;
+<a href="?Action=CustomizeNews">Upravit</a></td></tr></table>');
+//<img alt="Teplomer" width="10" height="18" src="images/teplomer3.png"><a href="statistic/trafficview2.php?type=temp">'.$Teplota.'°C (mimo provoz)</a></td></tr></table>');
+
 $UploadedFilesFolder = 'aktuality/uploads/';
 
+// Initialize default news setting
+$NewsSetting = array();
+$I = 1;
+$DbResult = $Database->select('news_category', '*');
+while($NewsCategory = $DbResult->fetch_array())
+{
+  $NewsSetting[] = array('CategoryId' => $NewsCategory['id'], 'Index' => $I, 'Enabled' => 1, 'ItemCount' => 5, 'DaysAgo' => 14);
+  $I++;
+}
+// Merge defaults with user setting
+if(array_key_exists('NewsSetting', $_COOKIE))
+{
+  $NewsSettingCookie = unserialize($_COOKIE['NewsSetting']);
+  foreach($NewsSetting as $Index => $NewSetting)
+  {
+    $NewsSetting[$Index] = array_merge($NewSetting, $NewsSettingCookie[$Index]);
+  }
+}
+
+if(array_key_exists('Action', $_GET))
+{
+  // Show news customize menu
+  if($_GET['Action'] == 'CustomizeNews')
+  {
+    echo('<form action="?Action=CustomizeNewsSave" method="post">');
+    echo('<table width="100%" cellspacing="0" border="1"><tr><td><table cellspacing="0" width="100%">');
+    echo('<tr><th>Kategorie</th><th>Pozice</th><th>Zobrazit</th><th>Max. počet</th><th>Posledních dnů</th></tr>');
+    $I = 0;
+    foreach($NewsSetting as $SettingItem)
+    {
+      $DbResult = $Database->select('news_category', '*', 'id='.$SettingItem['CategoryId']);
+      $NewsCategory = $DbResult->fetch_array();
+      echo('<tr><td>'.$NewsCategory['caption'].'</td><td align="center"><input type="text" size="1" name="NewsCategoryIndex'.$I.'" value="'.$SettingItem['Index'].'"></td><td align="center"><input type="checkbox" name="NewsCategoryEnabled'.$I.'"');
+      if($SettingItem['Enabled'] == 1) echo(' CHECKED'); 
+      echo('></td>'.
+      '<td align="center"><input type="text" size="1" name="NewsCategoryCount'.$I.'" value="'.$SettingItem['ItemCount'].'">'.
+      '<input type="hidden" name="NewsCategoryId'.$I.'" value="'.$SettingItem['CategoryId'].'"></td><td align="center"><input type="text" size="1" name="NewsCategoryDaysAgo'.$I.'" value="'.$SettingItem['DaysAgo'].'"></td></tr>');
+      $I++;
+    }
+    echo('</table><input type="hidden" name="NewsCategoryCount" value="'.count($NewsSetting).'"><input type="submit" value="Uložit"></form></td></tr></table>');
+  }
+}
+
 echo('<div onmouseout="skryj(predchozi)">');
 
-function ShowNews($Category)
+function ShowNews($Category, $ItemCount, $DaysAgo)
 {
   global $Database, $NewsCategoryNames, $NewsCountPerCategory, $UploadedFilesFolder;
 
+  $ItemCount = abs($ItemCount);
+  $DaysAgo = abs($DaysAgo);
   $DbResult = $Database->select('news_category', '*', 'id='.$Category);
   $Row = $DbResult->fetch_array();
@@ -189 +274 @@
   echo('</td></tr><tr><td colspan="2">');
   echo('<table cellspacing="0" width="100%" style="padding: 2px 2px 2px 2px; font-size: small; border-style: solid; border-color: red; border-width: 1; background-color: #FFF0F0;">');
-  $DbResult = $Database->select('news', '*', 'category='.$Category.' ORDER BY date DESC LIMIT 0,'.$NewsCountPerCategory);
+  $DbResult = $Database->query('SELECT * FROM `news` WHERE (`category`='.$Category.') AND (DATE_SUB(NOW(), INTERVAL '.$DaysAgo.' DAY) < `date`) ORDER BY `date` DESC LIMIT 0,'.$ItemCount);
+  //echo($Database->error.'<br>');
+  //echo($Database->LastQuery.'<br>');
 //echo('<table cellpadding="0" cellspacing="0" width="100%"><tr><td>');
   $Index = 0;
   $FontSize = 12;
+  if($DbResult->num_rows > 0)
   while($Row = $DbResult->fetch_array())
   {
@@ -212 +300 @@
     echo('</div></td></tr>');
     $Index = $Index + 1;    
-    $FontSize = $FontSize - 2;
+    $FontSize = $FontSize - 1;
   }
   echo('</table></td></tr></table>'."\n\n");
 }
 
-ShowNews(5);
-ShowNews(3);
-ShowNews(1);
-ShowNews(2);
-ShowNews(4);
-ShowNews(6);
-ShowNews(8);
-ShowNews(9);
-ShowNews(10);
+foreach($NewsSetting as $SettingItem)
+  if($SettingItem['Enabled'] == 1) ShowNews($SettingItem['CategoryId'], $SettingItem['ItemCount'], $SettingItem['DaysAgo']);
 
 echo('<a href="aktuality/subscription.php"><img style="margin: 0px 0px 0px 0px;" border="0" src="images/rss20.png" alt="Aktuality přes RSS"></a>  <a href="aktuality/subscription.php">Automatické sledování novinek</a>');