source: trunk/Modules/News/News.php

<?php

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

class ModuleNews extends Module
{
  public array $RSSChannels;
  public array $RSSChannelsPos;

  function __construct(System $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();
    $this->RSSChannels = array();
  }

  function DoStart(): void
  {
    $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));
      Core::Cast($this->System)->RegisterPageHeader('New', array($this, 'ShowRSSHeader'));
  }

  function ShowBox()
  {
    $Count = 10;
    $Output = '<strong><a href="'.$this->System->Link('/news/').'">'.T('News').':</a></strong>'.
    '<div class="box"><div class="NewsBox">';
    $DbResult = $this->Database->query('SELECT `News`.`Time`, `User`.`Name`, `News`.`Text`,`News`.`Title`, `News`.`Id` '.
      ' FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT '.$Count);
    while ($DbRow = $DbResult->fetch_assoc())
    {
      $Output .= '<h4><a href="'.$this->System->Link('/news/?a=item&amp;i='.$DbRow['Id']).'">'.$DbRow['Title'].'</a> ('.HumanDate($DbRow['Time']).')</h4>'.
        '<div>'.$DbRow['Text'].' ('.$DbRow['Name'].')</div>';
    }
    $Output .= '</div></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()
  {
    $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
    $Output = '';
    foreach ($this->RSSChannels as $Channel)
    {
      if ($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(): string
  {
    $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();
    else if ($Action == 'add') $Output = $this->ShowAddForm();
    else if ($Action == 'item') $Output = $this->ShowItem();
    else $Output = $this->ShowList();
    return $Output;
  }

  function ShowList()
  {
    $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `News`');
    $DbRow = $DbResult->fetch_row();
    $PageList = GetPageList($DbRow[0]);

    $Output = '<h3>'.T('News').'</h3>';
    if ($User->Licence(LICENCE_ADMIN))
      $Output .= ' <a href="?a=add">'.T('Add').'</a>';
    $Output .= $PageList['Output'];
    $Output .= '<div class="shoutbox">';
    $DbResult = $this->System->Database->query('SELECT `News`.`Time`, `News`.`Text`, `News`.`Title`, `News`.`Id`, '.
        '`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 .= '<h4><a href="?a=item&amp;i='.$Line['Id'].'">'.$Line['Title'].'</a> ('.HumanDate($Line['Time']).')</h4><div>'.$Line['Text'].' ('.$Line['User'].')</div>';
    }
    $Output .= '</div>'.$PageList['Output'];
    return $Output;
  }

  function ShowItem()
  {
    if (array_key_exists('i', $_GET))
    {
      $Output = '<h3>'.T('News').'</h3>';
      $DbResult = $this->System->Database->query('SELECT `News`.`Time`, `News`.`Text`, `News`.`Title`, `News`.`Id`, '.
        '`User`.`Name` AS `User` FROM `News` JOIN `User` ON `User`.`Id`=`News`.`User` WHERE `News`.`Id` = '.($_GET['i'] * 1));
      if ($DbResult->num_rows == 1)
      {
        $Line = $DbResult->fetch_assoc();
        $Output .= '<h4>'.$Line['Title'].' ('.HumanDate($Line['Time']).')</h4><div>'.$Line['Text'].' ('.$Line['User'].')</div>';
      } else $Output = ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
    } else $Output = ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
    $Output .= '<br/><a href="'.$this->System->Link('/news/').'">'.T('All news').'</a>';
    return $Output;
  }

  function ShowAddForm()
  {
    $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
    if ($User->Licence(LICENCE_ADMIN))
    {
      $Output = '<form action="?" method="POST">'.
        '<fieldset><legend>'.T('New news').'</legend>'.
        T('User').': '.$User->Name.'('.$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/></fieldset>'.
        '</form>';
    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
    $Output .= $this->ShowList();
    return $Output;
  }

  function SaveNew()
  {
    $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
    if ($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( ) , '.
           $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`, `News`.`Id` '.
      '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' =>  'https://'.Core::Cast($this->System)->Config['Web']['Host'].$this->System->Link('/news/?a=item&amp;i='.$DbRow['Id']),
        'Description' => $DbRow['Text'].' ('.$DbRow['Name'].')',
        'Time' => $DbRow['UnixTime'],
      );
    }
    $Output = GenerateRSS(array
    (
      'Title' => Core::Cast($this->System)->Config['Web']['Title'].' - '.T('System changes'),
      'Link' => 'https://'.Core::Cast($this->System)->Config['Web']['Host'].$this->System->Link('/news/'),
      'Description' => Core::Cast($this->System)->Config['Web']['Description'],
      'WebmasterEmail' => Core::Cast($this->System)->Config['Web']['AdminEmail'],
      'Items' => $Items,
    ));
    return $Output;
  }
}