Changeset 350 for trunk/Modules/News/NewsPage.php

Timestamp:

Jan 18, 2012, 7:44:38 AM (13 years ago)

Author:

chronos

Message:

• Upraveno: Aktuality převedeny na systémový modul.

Location:

trunk/Modules/News

Files:

• . (copied) (copied from trunk/aktuality )
• NewsPage.php (copied) (copied from trunk/aktuality/index.php ) (10 diffs)

trunk/Modules/News/NewsPage.php

@@ -1 +1 @@
 <?php
-
-include_once('../global.php');
 
 class NewsPage extends Page
@@ -10 +8 @@
 
   function Show()
+  {
+    if(count($this->System->PathItems) > 1)
+    { 
+      if($this->System->PathItems[1] == 'subscription') return($this->ShowSubscription());
+        else if($this->System->PathItems[1] == 'rss') return($this->ShowRSS());
+        else return(PAGE_NOT_FOUND);
+    } else return($this->ShowMain());
+  }
+  
+  function ShowMain()
   {
     $Output = '';
@@ -30 +38 @@
         else 
         {
-          $News = new News($this->Database);
+          $News = new News($this->Database, $this->System);
           if(array_key_exists('id', $_GET)) $Id = $_GET['id'] * 1;
           $DbResult = $this->Database->query('SELECT `News`.*, `User`.`Name` FROM `News` LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE  `News`.`Id`='.$Id);
@@ -42 +50 @@
             { 
               $Output .= '<div class="Action">';
-              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
-              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
+              $Output .= '&nbsp;<a href="?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
+              $Output .= '&nbsp;<a href="?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
               $Output .= '</div>';
             }
@@ -112 +120 @@
           $this->Database->insert('News', array('Category' => $Category, 'Title' => $_POST['title'], 'Content' => $_POST['content'], 'Date' => 'NOW()', 'IP' => $RemoteAddr, 'Enclosure' => $Enclosures, 'Author' => $this->System->Models['User']->User['Name'], 'User' => $this->System->Models['User']->User['Id'], 'Link' => $_POST['link']));
           $Output .= 'Aktualita přidána!<br />Pokud budete chtít vaši aktualitu smazat, klikněte na odkaz Smazat v seznamu všech aktualit v kategorii.<br /><br />';
-          $Output .= '<a href="index.php?category='.$_POST['category'].'">Zpět na seznam aktualit</a>';
+          $Output .= '<a href="?category='.$_POST['category'].'">Zpět na seznam aktualit</a>';
           $this->System->Modules['Log']->NewRecord('News', 'Aktualita přidána', $this->Database->insert_id);
         } else $Output .= 'Do této kategorie nemůžete vkládat aktuality!';
@@ -123 +131 @@
           $Row['Content'] = str_replace('<br />', '', $Row['Content']);
           $Output .= '<strong>Editace aktuality v kategorii '.$CategoryName.':</strong><br />';
-          $Output .= '<form action="index.php?action=update" method="post">'.
+          $Output .= '<form action="?action=update" method="post">'.
           '<input type="hidden" value="'.$_GET['id'].'" name="id">'.
           'Nadpis:<br /><input type="text" size="54" name="title" value="'.$Row['Title'].'"><br />'.
@@ -164 +172 @@
           }
           $this->Database->query('DELETE FROM News WHERE Id='.$_GET['id']);
-          $Output .= 'Aktualita smazána!<br /><a href="index.php?category='.$Category.'">Zpět na seznam aktualit</a>';
+          $Output .= 'Aktualita smazána!<br /><a href="?category='.$Category.'">Zpět na seznam aktualit</a>';
         } else $Output .= 'Nemáte oprávnění.';
         break;
@@ -170 +178 @@
         if($this->System->Models['User']->CheckPermission('News', 'Display', 'Group', $Category))
         {
-          $News = new News($this->Database);
+          $News = new News($this->Database, $this->System);
           $PerPage = 20;
           $DbResult = $this->Database->select('News', 'COUNT(*)', ' Category='.$Category);
@@ -190 +198 @@
             {
               $Output .= '<div class="Action">';
-              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
-              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
+              $Output .= '&nbsp;<a href="?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
+              $Output .= '&nbsp;<a href="?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
               $Output .= '</div>';
             }
@@ -213 +221 @@
     return($Output);
   }
+  
+  function ShowSubscription()
+  {     
+    if(array_key_exists('build', $_GET))
+    {
+      $Select = '';
+      foreach($_POST as $Index => $Item)
+      {
+        if(substr($Index, 0, 8) == 'category') $Select .= '-'.substr($Index, 8);
+      }
+      $Select = $this->System->Config['Web']['RootFolder'].'/aktuality/rss/?select='.substr($Select, 1);
+      $Output = 'Výsledný RSS kanál: <a href="'.$Select.'">'.$Select.'</a>';
+    } else 
+    {
+      $Output = 'Vytvořte si vlastní RSS kanál, díky kterému budete moci automaticky sledovat novinky pomocí vaší RSS čtečky. Informace o technologii RSS a programech pro čtení kanálů najdete např. <a href="http://www.lupa.cz/clanky/prehled-rss-ctecek/">zde</a><br />'.
+      '<br />Kategorie:<br />';
+      $Output .= '<form action="?build=1" method="post">';
+      $DbResult = $this->Database->select('NewsCategory', '*', '1 ORDER BY Caption');
+      while($Category = $DbResult->fetch_array())
+      {
+        $Output .= '<input type="checkbox" name="category'.$Category['Id'].'" />'.$Category['Caption'].'<br />';
+      }
+      $Output.= '<input type="submit" value="Sestavit " />'.
+        '</form>';
+    }  
+    return($Output);
+  }
+  
+  function ShowRSS()
+  {
+    $this->SimplePage = true;
+    $this->FormatHTML = false;
+    Header('Content-Type: text/xml');
+
+include_once('rss_generator.php');
+
+$NewsCount = 15;
+
+$Items = array();
+$Category = '';
+$CategoryOption = '';
+$CategoryOptionURL = '';
+$CategoryName = '';
+
+// Prepare WHERE condition 
+if(array_key_exists('select', $_GET)) 
+{
+  $Where = '';
+  $Parts = explode('-', $_GET['select']);
+  foreach($Parts as $Part)
+  {
+    $Where .= 'OR (category='.($Part * 1).')'; 
+  }
+  $Where = substr($Where, 2);
+} else $Where = 1;
+
+// Get category names
+$Categories = array();
+$DbResult = $Database->select('NewsCategory', '*');
+while($Category = $DbResult->fetch_array())
+{
+  $Categories[$Category['Id']] = $Category['Caption'];
 }
 
-$System->AddModule(new NewsPage());
-$System->Modules['NewsPage']->GetOutput();
+// Update news from discussion forum
+/*
+$ForumCategory = 4;   
+$Database->select_db('forum');
+$DbResult = $Database->query('SELECT posts.post_time, posts_text.post_subject, posts_text.post_text, users.username, topics.topic_title FROM posts JOIN posts_text ON posts.post_id = posts_text.post_id JOIN users ON users.user_id = posts.poster_id JOIN topics ON topics.topic_id= posts.topic_id ORDER BY post_time DESC LIMIT '.$NewsCount);
+$Index = 0;
+//echo(DB_NumRows().',');
+while($Row = $DbResult->fetch_array())
+{
+  $Row['post_text'] = StrTr($Row['post_text'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
+  $Row['post_text'] = str_replace("\n","<br>", $Row['post_text']); 
+  $Row['post_subject'] = StrTr($Row['post_subject'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
+  $Row['topic_title'] = StrTr($Row['topic_title'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
+  $Index = $Index + 1;    
+  
+  $Title = $Row['topic_title'].'-'.$Row['post_subject'];
+  $Content = $Row['post_text'];
+  $Date = date('Y-m-d H:i:s', $Row['post_time']);
+  $Author = $Row['username'];
+  $Database->select_db('is');
+  //echo('category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
+  $DbResult2 = $Database->select('news', '*', 'category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
+  if($DbResult2->num_rows == 0) //echo('.'); else echo('x'); 
+    $Database->insert('news', array('category' => $ForumCategory, 'title' => $Title, 'content' => $Content, 'author' => $Author, 'date' => $Date));
+    //echo($Date);  
+  $Database->select_db('forum');
+}
+$Database->select_db('is');
+*/
+
+// Get news from database by selected categories
+$UploadedFilesFolder = 'uploads/';
+$DbResult = $Database->query('SELECT *, UNIX_TIMESTAMP(Date) FROM News LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE '.$Where.' ORDER BY News.Date DESC LIMIT 0,'.$NewsCount);
+while($Row = $DbResult->fetch_assoc())
+{
+  $EnclosuresText = '';
+  if($Row['Enclosure'] != '')
+  { 
+    $EnclosuresText .= '<br />Přílohy: ';
+    $Enclosures = explode(';', $Row['Enclosure']);
+    foreach($Enclosures as $Enclosure)
+    {
+      if(file_exists($UploadedFilesFolder.$Enclosure)) $EnclosuresText .= ' <a href="http://centrala.zdechov.net/aktuality/'.$UploadedFilesFolder.$Enclosure.'">'.$Enclosure.'</a>';
+    }
+  }
+  if($Row['Name'] == '') $Author = $Row['Author'];
+    else $Author = $Row['Name'];
+  $Items[] = array(
+    'Title' => $Categories[$Row['Category']].' - '.$Row['Title'],
+    'Link' => 'http://centrala.zdechov.net/aktuality/index.php?category='.$Row['Category'],
+    'Description' => $Row['Content'].' ('.$Author.')'.$EnclosuresText,
+    'Time' => $Row['UNIX_TIMESTAMP(Date)'],
+  );
+}
+
+return(GenerateRSS(array(
+  'Title' => $Config['Web']['Title'].' - Aktuality',
+  'Link' => 'http://'.$Config['Web']['Host'].'/',
+  'Description' => 'Aktuality komunitní počítačové sítě ZděchovNET',
+  'WebmasterEmail' => $Config['Web']['AdminEmail'],
+  'Items' => $Items)));
+      
+  }
+  
+}
 
 ?>