source: trunk/Modules/News/News.php@ 765

<?php

include_once(dirname(__FILE__).'/RSS.php');

class ModuleNews extends AppModule
{
  var $RSSChannels;
 
  function __construct($System)
  {
    parent::__construct($System);
    $this->Name = 'News';
    $this->Version = '1.0';
    $this->Creator = 'Chronos';
    $this->License = 'GNU/GPL';
    $this->Description = 'Web site annoucements management';
    $this->Dependencies = array();
  }
  
  function Start()
  {
        $this->System->RegisterPage('news', 'PageNews');
        $this->System->RegisterPage('rss', 'PageRSS');
        $this->RegisterRSS(array('Title' => T('News'), 'Channel' => 'news', 
          'Callback' => array('PageNews', 'ShowRSS'), 'Permission' => LICENCE_ANONYMOUS));
  }
  
  function ShowBox()
  {
        $Output = '<strong>'.T('System changes').':</strong><div class="NewsBox">';
        $DbResult = $this->Database->query('SELECT `News`.`Time`, `User`.`Name`, `News`.`Text`,`News`.`Title`'.
                ' FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
        while($DbRow = $DbResult->fetch_assoc())
                $Output .= '<div><strong>'.$DbRow['Title'].' ('.HumanDate($DbRow['Time']).')</strong> <br />'.$DbRow['Text'].' ('.$DbRow['Name'].')</div>';
        $Output .= '<a href="'.$this->System->Link('/news/').'">'.T('All news').'</a>';
        $Output .= '</div>';    
        return($Output);
  }
  
  function RegisterRSS($Channel, $Pos = NULL, $Callback = NULL)
  {
    $this->RSSChannels[$Channel['Channel']] = $Channel;
    
    if(is_null($Pos)) $this->RSSChannelsPos[] = $Channel['Channel'];
    else {
      array_splice($this->RSSChannelsPos, $Pos, 0, $Channel['Channel']);
    }
  }
  
  function ShowRSSHeader()
  {
    $Output = ''; 
    foreach($this->RSSChannels as $Channel)
                {
                  if($this->System->User->Licence($Channel['Permission']))
                          $Output .= ' <link rel="alternate" title="'.$Channel['Title'].'" href="'.
                        $this->System->Link('/rss/?channel='.$Channel['Channel']).'" type="application/rss+xml" />';
                }               
    return($Output);
  }
}

class PageNews extends Page
{
        function Show()
        {
                $this->Title = T('News');
                if(array_key_exists('a', $_POST)) $Action = $_POST['a'];
                  else if(array_key_exists('a', $_GET)) $Action = $_GET['a'];
                  else $Action = '';
                if($Action == 'add2') $Output = $this->SaveNew();
                if($Action == 'add') $Output = $this->ShowAddForm();
                else $Output = $this->ShowList();
                return($Output);
        }
        
        function ShowList()
        {
                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `News`');
                $DbRow = $DbResult->fetch_row();
                $PageList = GetPageList($DbRow[0]);
                
                $Output = '<h3>'.T('News').'</h3>'.$PageList['Output'];
                if($this->System->User->Licence(LICENCE_ADMIN)) 
                        $Output .= ' <a href="?a=add">'.T('Add').'</a>';
                $Output .= '<div class="shoutbox">';
                $DbResult = $this->System->Database->query('SELECT `News`.`Time`, `News`.`Text`, `News`.`Title`, '.
                                '`User`.`Name` AS `User` FROM `News` JOIN `User` ON `User`.`Id`=`News`.`User` ORDER BY `News`.`Time` DESC '.$PageList['SQLLimit']);
                while($Line = $DbResult->fetch_assoc())
                        $Output .= '<div><strong>'.$Line['Title'].' ('.HumanDate($Line['Time']).')</strong><br/> '.$Line['Text'].' ('.$Line['User'].')</div>';
                $Output .= '</div>'.$PageList['Output'];
                return($Output);                
        }
        
        function ShowAddForm()
        {
                if($this->System->User->Licence(LICENCE_ADMIN))
                {
                  $Output = '<form action="?" method="POST">'.
                          T('User').': '.$this->System->User->Name.'('.$this->System->User->Id.')<br/> '.
                          T('Title').': <input type="text" name="title" size="40"/><br/>'.
                          T('Content').': <textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="Text" name="text"></textarea><br/>'.
                          '<input type="hidden" name="a" value="add2"/>'.
                          '<input type="submit" value="'.T('Save').'"/><br/>'.
                          '</form>';
                } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
                return($Output);
        }
        
        function SaveNew()
        {
                if($this->System->User->Licence(LICENCE_ADMIN))
                {
                  if(array_key_exists('text', $_POST) and array_key_exists('title', $_POST))
                  {
                        $querty = 'INSERT INTO `News` (`Title`, `Time` ,`User` ,`Text`) VALUES ( "'.$_POST['title'].'", NOW( ) , '.
                                         $this->System->User->Id.', "'.$_POST['text'].'")';
                          $this->System->Database->query($querty);
                          $Output = ShowMessage(T('News added'));
                          $this->System->ModuleManager->Modules['Log']->WriteLog('Vložena nová aktualita', LOG_TYPE_ADMINISTRATION);
                          $Output .= $this->ShowList();
                  } else $Output = ShowMessage(T('Data not specified'), MESSAGE_CRITICAL);
                } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
                return($Output);
        }
        
        function ShowRSS()
        {
                $Items = array();
    $DbResult = $this->Database->query('SELECT UNIX_TIMESTAMP(`News`.`Time`) AS `UnixTime`, '.
            '`News`.`Title`, `News`.`Time`, `User`.`Name`, `News`.`Text` '.
            'FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
          while($DbRow = $DbResult->fetch_assoc())
          {
           $Items[] = array
           (
             'Title' => $DbRow['Title'],
             'Link' =>  'http://'.$this->System->Config['Web']['Host'].$this->System->Link('/news/'),
             'Description' => $DbRow['Text'].' ('.$DbRow['Name'].')',
             'Time' => $DbRow['UnixTime'],
           );
          }
          $Output = GenerateRSS(array
          (
            'Title' => $this->System->Config['Web']['Title'].' - '.T('System changes'),
            'Link' => 'http://'.$this->System->Config['Web']['Host'].$this->System->Link('/news/'),
            'Description' => $this->System->Config['Web']['Description'],
            'WebmasterEmail' => $this->System->Config['Web']['AdminEmail'],
            'Items' => $Items,
          ));
          return($Output);       
        }
}