root/trunk/wifidog-auth/wifidog/hotspot_status.php @ 402

<?php
  /********************************************************************\
   * This program is free software; you can redistribute it and/or    *
   * modify it under the terms of the GNU General Public License as   *
   * published by the Free Software Foundation; either version 2 of   *
   * the License, or (at your option) any later version.              *
   *                                                                  *
   * This program is distributed in the hope that it will be useful,  *
   * but WITHOUT ANY WARRANTY; without even the implied warranty of   *
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the    *
   * GNU General Public License for more details.                     *
   *                                                                  *
   * You should have received a copy of the GNU General Public License*
   * along with this program; if not, contact:                        *
   *                                                                  *
   * Free Software Foundation           Voice:  +1-617-542-5942       *
   * 59 Temple Place - Suite 330        Fax:    +1-617-542-2652       *
   * Boston, MA  02111-1307,  USA       gnu@gnu.org                   *
   *                                                                  *
   \********************************************************************/
  /**@file hotspot_status.php
   * Network status page
   * @author Copyright (C) 2004 Benoit Gr�goire
   */

define('BASEPATH','./');
require_once BASEPATH.'include/common.php';
require_once BASEPATH.'include/common_interface.php';

if(!empty($_REQUEST['format'])) {
    $format = $_REQUEST['format'];
} else {
    $format = null;
}

$db->ExecSql("SELECT *, (NOW()-last_heartbeat_timestamp) AS since_last_heartbeat, EXTRACT(epoch FROM creation_date) as creation_date_epoch, CASE WHEN ((NOW()-last_heartbeat_timestamp) < interval '5 minutes') THEN true ELSE false END AS is_up FROM nodes WHERE node_deployment_status = 'DEPLOYED' OR node_deployment_status = 'NON_WIFIDOG_NODE' ORDER BY creation_date", $node_results, false);

if ($format == 'RSS') {
    Header("Cache-control: private, no-cache, must-revalidate");
    Header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); # Past date
    Header("Pragma: no-cache");
    Header("Content-Type: text/xml; charset=UTF-8");

    $xmldoc = new DOMDocument();
    $xmldoc->formatOutput = true;
    //$xmldoc->encoding="iso-8859-15";
    $rss = $xmldoc->createElement("rss");
    $xmldoc->appendChild($rss);
    $rss->setAttribute('version', '2.0');

    /* channel */
    $channel = $xmldoc->createElement("channel");
    $rss->appendChild($channel);

    /**************** Required channel elements ********************/
    /* title */
    $title = $xmldoc->createElement("title");
    $title = $channel->appendChild($title);

    $textnode = $xmldoc->createTextNode(utf8_encode(_("Newest")." ".HOTSPOT_NETWORK_NAME. " ". _("Hotspots")));
    $title->appendChild($textnode);

    /* link */
    $link = $xmldoc->createElement("link");
    $channel->appendChild($link);
    $textnode = $xmldoc->createTextNode(utf8_encode(HOTSPOT_NETWORK_URL));
    $link->appendChild($textnode);

    /* description */
    $description = $xmldoc->createElement("description");
    $channel->appendChild($description);
    $textnode = $xmldoc->createTextNode(utf8_encode(_("WiFiDog list of the most recent HotSpots opened by ").HOTSPOT_NETWORK_NAME));
    $description->appendChild($textnode);

    /****************** Optional channel elements *******************/
    /* language */
    /**@todo Make language selectable */
    $language = $xmldoc->createElement("language");
    $channel->appendChild($language);
    $textnode = $xmldoc->createTextNode("en-CA");
    $language->appendChild($textnode);

    /* copyright */
    $copyright = $xmldoc->createElement("copyright");
    $channel->appendChild($copyright);
    $textnode = $xmldoc->createTextNode(utf8_encode(_("Copyright ").HOTSPOT_NETWORK_NAME));
    $copyright->appendChild($textnode);

    /* managingEditor */
                
    /* webMaster */
                
    $webMaster = $xmldoc->createElement("webMaster");
    $channel->appendChild($webMaster);
    $textnode = $xmldoc->createTextNode(utf8_encode(TECH_SUPPORT_EMAIL));
    $webMaster->appendChild($textnode);

    /* pubDate */
    $pubDate = $xmldoc->createElement("pubDate");
    $channel->appendChild($pubDate);
    $textnode = $xmldoc->createTextNode(utf8_encode(gmdate("D, d M Y H:i:s \G\M\T", time())));
    $pubDate->appendChild($textnode);

    /* lastBuildDate */
    //<lastBuildDate> -- The date-time the last time the content of the channel changed.
    /* Make a request through the database for the latest modification date of an object.  
     * Maybe it should be an object property? */
    $db->ExecSqlUniqueRes("SELECT EXTRACT(epoch FROM MAX(creation_date)) as date_last_hotspot_opened FROM nodes WHERE node_deployment_status = 'DEPLOYED' OR node_deployment_status = 'NON_WIFIDOG_NODE' ", $last_hotspot_row, false);

    $lastBuildDate = $xmldoc->createElement("lastBuildDate");
    $channel->appendChild($lastBuildDate);
    $textnode = $xmldoc->createTextNode(gmdate("D, d M Y H:i:s \G\M\T", $last_hotspot_row['date_last_hotspot_opened']));
    $lastBuildDate->appendChild($textnode);
                
    /* category */
    /* Specify one or more categories that the channel belongs to.
     *  Follows the same rules as the <item>-level category element.*/
                 
    /* generator */
    $generator = $xmldoc->createElement("generator");
    $channel->appendChild($generator);
    $textnode = $xmldoc->createTextNode(utf8_encode(WIFIDOG_NAME . " " . WIFIDOG_VERSION));
    $generator->appendChild($textnode);
                
    /* docs */
    $docs = $xmldoc->createElement("docs");
    $channel->appendChild($docs);
    $textnode = $xmldoc->createTextNode(utf8_encode("http://blogs.law.harvard.edu/tech/rss"));
    $docs->appendChild($textnode);
                
    /* cloud */
    /* Allows processes to register with a cloud to be notified of updates to the channel, implementing a lightweight publish-subscribe protocol for RSS feeds.*/

    /* ttl */
    /* ttl stands for time to live. It's a number of minutes that indicates how long a channel can be cached before refreshing from the source.*/

    /* image */
    $image = $xmldoc->createElement("image");
    $channel->appendChild($image);
                
    /* title */
    $title = $xmldoc->createElement("title");
    $image->appendChild($title);
    $textnode = $xmldoc->createTextNode(utf8_encode(HOTSPOT_NETWORK_NAME));
    $title->appendChild($textnode);
    /* url */
    $url = $xmldoc->createElement("url");
    $image->appendChild($url);
    $textnode = $xmldoc->createTextNode(utf8_encode(COMMON_CONTENT_URL.NETWORK_LOGO_NAME));
    $url->appendChild($textnode);
    /* link */
    $link = $xmldoc->createElement("link");
    $image->appendChild($link);
    $textnode = $xmldoc->createTextNode(utf8_encode(HOTSPOT_NETWORK_URL));
    $link->appendChild($textnode);
    /* width */
    /*
     $width = $xmldoc->createElement("width");
     $image->appendChild($width);
     $textnode = $xmldoc->createTextNode('135');
     $width->appendChild($textnode);
    */
    /* height */
    /*
     $height = $xmldoc->createElement("height");
     $image->appendChild($height);
     $textnode = $xmldoc->createTextNode('109');
     $height->appendChild($textnode);
    */
    /* description */
    /*
     $description = $xmldoc->createElement("description");
     $image->appendChild($description);
     $textnode = $xmldoc->createTextNode("Le portail des TIC");
     $description->appendChild($textnode);
    */

    /* rating */
    /* textInput */
    /* skipHours */
    /* skipDays */
                
$i=0;

    foreach($node_results as $node_row) {

      $item = $xmldoc->createElement("item");
      $item = $channel->appendChild($item);

      /* title */
      /* lom_1_2_title_langstrings_id */
      $title = $xmldoc->createElement("title");
      $item->appendChild($title);
      $title_str = $node_row['name'];

      if($node_row['is_up']=='t')
      {
      $title_str .= " (Currently Up)";
      }
      else
      {
            $title_str .= " (Currently Down)";
      }
      $textnode = $xmldoc->createTextNode(utf8_encode($title_str));
      $title->appendChild($textnode);

      /* link */
      if(!empty($node_row['home_page_url']))
      {
      $link = $xmldoc->createElement("link");
      $item->appendChild($link);
      $textnode = $xmldoc->createTextNode(utf8_encode($node_row['home_page_url']));
      $link->appendChild($textnode);
      }

      /* description */
      /* lom_1_4_descriptions_has_langstrings */
      $description = $xmldoc->createElement("description");
      $item->appendChild($description);
      $description_text='';
      if(!empty($node_row['description']))
      {
          $description_text.=$node_row['description'];
      }
      if(!empty($node_row['street_address']))
      {
          $description_text.= " "._("Address:")." ".$node_row['street_address'];
      }
      if(!empty($node_row['mass_transit_info']))
      {
          $description_text.=" "._("Mass transit:")." ".$node_row['mass_transit_info'];
      }
      $textnode = $xmldoc->createTextNode(utf8_encode($description_text));
      $description->appendChild($textnode);
      
      /* author */
/*
          $author = $xmldoc->createElement("author");
          $item->appendChild($author);
          $textnode = $xmldoc->createTextNode($author_vcard->GetEmail().' ('.$author_vcard->GetName().')');
          $author->appendChild($textnode);
*/
      /* category */

      /* comments */
      /** Link to page once page is available **/
      /* enclosure */
      /* guid */

          $guid = $xmldoc->createElement("guid");
          $guid->setAttribute('isPermaLink', 'false');
          $item->appendChild($guid);
          $textnode = $xmldoc->createTextNode(utf8_encode(HOTSPOT_NETWORK_URL.$node_row['node_id']));
          $guid->appendChild($textnode);

    /* pubDate */
    $pubDate = $xmldoc->createElement("pubDate");
    $item->appendChild($pubDate);
    $textnode = $xmldoc->createTextNode(utf8_encode(gmdate("D, d M Y H:i:s \G\M\T", $node_row['creation_date_epoch'])));
    $pubDate->appendChild($textnode);

      /* source */
    }

    echo $xmldoc->saveXML();
} else {
    foreach($node_results as $node_row) {
        $node_row['num_online_users'] = $stats->getNumOnlineUsers($node_row['node_id']);
        $smarty->append("nodes", $node_row);
    }

    $smarty->assign("title", "hotspot_status");
    $smarty->display("templates/hotspot_status.html");
}
?>