<?php 
  //require_once ('html.inc');
  require_once ('db.inc');
  require_once ('cache.inc');
  require_once ('yahoo_quotes.inc');
  require_once ('yahoo_finance_news.inc');
  require_once ('delicious.inc');
  
  global $document;\; function\; setValue($element, $text)\; \{\; global$document;
    if (is_string($element))\; \{$element = $document->getElementById($element);
    }
    while ($element->firstChild)\; \{$element->removeChild($element->firstChild);\; \}\; if\; ($text) {
      $element->appendChild($document->createTextNode($text));\; \}\; \}\; function\; populateMenuGo($db) {
    global $document;$query = queryAllWatches($db);$menuGo = $document->getElementById(\text{'}menu.go\text{'});$menuGoItem = $menuGo->getElementsByTagName(\text{'}li\text{'})->item(0);$i = 0;
    while ($row\; =$query->fetch(SQLITE_ASSOC)) {
      if ($i++\; >\; 0)\; \{$newMenuGoItem = $menuGoItem->cloneNode(TRUE);$menuGo->appendChild($newMenuGoItem);\; \}\; else\; \{$newMenuGoItem = $menuGoItem;\; \}$a = $newMenuGoItem->getElementsByTagName(\text{'}a\text{'})->item(0);$a->setAttribute("href", "?name=" . $row[\text{'}symbol\text{'}]);\; setValue($a, "$\{row[\text{'}title\text{'}]\}\; (${row['symbol']})");
    }
  }
  
  function populateForms($watchRow)\; \{\; global$document;
    if (!$watchRow)\; \{\; return;\; \}\; setValue($document->getElementById('textTitle'), $watchRow[\text{'}title\text{'}]);\; setValue($document->getElementById('textDescription'), $watchRow[\text{'}description\text{'}]);$document->getElementById('symbol')->setAttribute('value', $watchRow[\text{'}symbol\text{'}]);$document->getElementById('tag')->setAttribute('value', $watchRow[\text{'}tag\text{'}]);\; \}\; function\; populateQuotes($watchRow) {
    global $document;\; if\; (!$watchRow) {
      return;
    }
    $quote\; =\; simplexml\_load\_string(\; get\_cached\_data(\; getUrlQuotes($watchRow['symbol']), 
        get_quotes_as_xml, 
        YAHOOFINANCE_QUOTES_LIFETIME
      )
     );
    setValue('yahoofinance.quotes.title', "Quotes ({$quote->name\})");\; setValue(\text{'}yahoofinance.quotes.last\_price\text{'},$quote->lastTrade->price);
    setValue('yahoofinance.quotes.last_time', 
      "{$quote->lastTrade->time\}\; EST\; (\{$quote->lastTrade->date})" );
    setValue('yahoofinance.quotes.change', $quote->change);\; setValue(\text{'}yahoofinance.quotes.open\text{'},$quote->open);
    setValue('yahoofinance.quotes.high', $quote->high);\; setValue(\text{'}yahoofinance.quotes.low\text{'},$quote->low);
    setValue('yahoofinance.quotes.volume', $quote->volume);\; \}\; function\; populateChart($watchRow) {
    global $document;\; if\; (!$watchRow) {
      return;
    }
    $img\; =$document->getElementById('yahoofinance.chart.img');
    $img->setAttribute(\text{'}src\text{'},\; "yahoo\_chart.php?tag=\{$watchRow['symbol']}");
  }
  
  function populateRss($xmlChannel,$name) {
    global $document;$rss = simplexml_load_string($xmlChannel);$channel = $rss->channel;\; if\; ($rss->channel->item) {
      $items\; =$rss->channel->item;
    } else if ($rss->item)\; \{$items = $rss->item;\; \}\; else\; \{\; die\; ("Can\text{'}t\; reckon\; this\; RSS\; format!");\; \}$channelTitle = $document->getElementById($name . '.channel.title');
    setValue($channelTitle,$channel->title);
    $channelTitle->setAttribute("href",$channel->link);
    setValue($name\; .\; \text{'}.channel.description\text{'},$channel->description);
    setValue($name\; .\; \text{'}.channel.copyright\text{'},$channel->copyright);
    $itemElement\; =$document->getElementById($name\; .\; \text{'}.item\text{'});$itemsElement = $itemElement->parentNode;\; while\; ($itemElement->nextSibling) {
      $itemsElement->removeChild($itemElement->nextSibling);
    }
    if ($items)\; \{\; for($i=0; items); $i++\; )\; \{$item = $items[$i];
          //$itemElement\; =$document->getElementById($name\; .\; \text{'}.item\text{'});$
          if (i > 0) {
            $savedItem\; =$itemElement->cloneNode(true);
          }
          $itemDiv\; =$itemElement->getElementsByTagName("div")->item(0);
          $itemTitle\; =$itemDiv->getElementsByTagName("h3")->item(0)->getElementsByTagName("a")->item(0);
          setValue($itemTitle,$item->title);
          //echo " {$item->link\}";$
          attribute = $document->createAttribute(\text{'}href\text{'});$attribute->value=htmlspecialchars($item->link);$itemTitle->setAttributeNode($attribute);$//itemTitle->setAttribute('href', htmlspecialchars($item->link));$
          itemDescription = $itemDiv->getElementsByTagName("div")->item(0);$//itemDescription = $document->getElementById($name . '.item.description');
          setValue($itemDescription,$item->description);
          if ($i\; >\; 0)\; \{$itemElement->removeAttribute("id");
            $itemTitle->removeAttribute("id");$itemDescription->removeAttribute("id");
            $itemsElement->insertBefore($savedItem, $itemsElement->firstChild);$itemsElement->appendChild($itemElement);$itemElement = $savedItem;\; \}\; \}\; \}\; \}\; function\; populateFinancialNews($watchRow) {
    if (!$watchRow)\; \{\; return;\; \}\; populateRss\; (\; get\_cached\_data(\; getUrlFinancialNews($watchRow['symbol']), 
        defaultCacheGet, 
        YAHOOFINANCE_NEWS_LIFETIME
      ),
      'yahoofinance.news'
    );
  }
  
  function populateDelicious($watchRow)\; \{\; if\; (!$watchRow) {
      return;
    }
    populateRss (
      get_cached_data(
        getUrlDelicious($watchRow[\text{'}tag\text{'}]),\; defaultCacheGet,\; DELICIOUS\_LIFETIME\; ),\; \text{'}delicious\text{'}\; );\; \}$// Open the database and fetch the current
  // watch if needed.
  db=openDb();
  $query\; =\; queryOneWatch($db);
  $watchRow\; =$query->fetch(SQLITE_ASSOC);
  // Create a DOM and load the document
  $document\; =\; new\; DOMDocument();$document->validateOnParse = TRUE;
  $document->load("template.html");$// Populate the menu bar and the panels
  populateMenuGo(db);
  populateForms($watchRow);\; populateQuotes($watchRow);
  populateChart($watchRow);\; populateFinancialNews($watchRow);
  populateDelicious($watchRow);$// Send the result
  header("Cache-Control: max-age=60");
  header("Content-type: text/html");
  print document->saveXML();
  
  ?>