<?php

#TODO: implement search filter (e.g. 'contains the words', for microblogs)

#TODO: implement weighting, so that high-volume feeds (libre.fm, delicious) don't

#        drown out important things like blog posts and videos

#TODO: store table names as variables

#TODO: XSLT output (can this handle inheritance? A little formatting still needed, I think)

#TODO: multiple links -- combine timeSince if they're all the same...

#TODO: it'd be cool to combine Delicious, Google Reader and StumbleUpon stories...

#			and Facebook Posted Items... because sometimes that happens for the same link

#TODO: need to query for more if not enough retrieved (LIMIT estimated)

//function __autoload($class_name){

//	require_once 'modules/' . strtolower($class_name) . '.class.php';

//}

require('entry.class.php');

require('settings.php');

require('modules.php');

define('ABS_PATH', dirname(__FILE__));

define('DEFAULT_ENTRY_ICON', '/default_icon.png');

/**

 * Load db settings and connect.

 * @return database handling

 */

function db_connect() {

  $dbh = @mysql_connect(DB_HOST, DB_USER, DB_PASS);

  if(!$dbh)

  	die('Could not connect: ' . mysql_error());

  if(!mysql_select_db(DB_NAME, $dbh))

  	die('Could not select database: ' . mysql_error());

 return $dbh;

}

/**

 * Load entries from the database, return as array.

 * @param $dbh -- database link identifier

 * @param $filter_query -- WHERE clauses, if any

 * @param $max -- number of desired entries to load.

 * @param $more -- used as a pager so that, if this function is called multiple

 *                times with other parameters constant but $more increment, it

 *                will return the next entries from the same query...

 */

function load_entries($dbh, $filter_query, $limit, $more = 0) {

  $limit = (int)($limit);

  $entries = array();

  // Load entries  

  $sql = "SELECT e.*, f.type as feed_type, f.title as feed_title, f.link as feed_link, f.id as feed_id FROM entries e 

            LEFT OUTER JOIN feeds f ON f.id=e.feed_id 

            $filter_query

            ORDER BY e.rec_updated DESC

            LIMIT ".$more*$limit .', '. $limit;

  $result = mysql_query($sql, $dbh);

  if(!$result)

  	die('Query failed: ' . mysql_error($dbh));

  while ($row = mysql_fetch_assoc($result)) {

    $class = class_exists($row['feed_type']) ? $row['feed_type'] : 'Entry';

  	$entries[] = new $class($row);

  }

  // TODO: look for a more elegant way to express this

  // Join any duplicate entries

  for($i = 0; $i < count($entries); $i++){

  	while(is_callable(array($entries[$i], 'equals')) and

  		$i+1 < count($entries) and

  		is_callable(array($entries[$i+1], 'equals')) and

  		$entries[$i]->equals($entries[$i+1])){

  		$entries[$i]->merge($entries[$i+1]);

  		if($i+2 < count($entries))

  			$entries = array_merge(

  				array_slice($entries, 0, $i+1),

  				array_slice($entries, $i+2));

  		else

  			$entries = array_slice($entries, 0, $i+1);

    }

  }

  return $entries;

}

/**

 * Return an unordered list of the entries from the database

 * which match the following criteria.

 */

function get_entries($filters = array(), $max = 20, $with_like = array()) {

  $dbh = db_connect();

  // Build query filters

  $filter_query = "";

  if ($filters) {

    $fields = array('tag' => 't.name', 'feed' => 'f.id');

    // Load filters

    foreach ($filters as $key => $value) {

      if ($value) {

        $key = $fields[$key];

        // If string, add check for this single value

        if (!is_array($value)) {

          $value = mysql_real_escape_string($value);

          $this_filter_query = "$key='$value'";

        }

        // If array, match any of the values

        else {

          $this_filter_query = '';

          foreach ($value as $this_value) {

            $this_value = mysql_real_escape_string($this_value);

            $this_filter_query .= ($this_filter_query ? ' OR ' : '') ."$key='$this_value'";

          }

        }

        $filter_query .= (!$filter_query ? ' WHERE ' : ' AND ') ."($this_filter_query)";

      }

      if ($with_like) {

        $filter_query .= " OR e.title LIKE '%$with_like%' ";

      }

      // If filtering by tag, join tag tables

      if (isset($filters['tag']) && $filters['tag']) {

        $filter_query = 'LEFT OUTER JOIN tag_relationships x ON e.id=x.entry_id

                         LEFT OUTER JOIN tags t ON x.tag_id=t.id '. $filter_query;

      }

    }

  }

  $entries = load_entries($dbh, $filter_query, $max*2);

  if (!$entries) {

    return '<p>No activity.</p>'; //nothing to show

  }

  $more = 0; //used later if we need to load more

  $ul = "\n<ul>";

  // Add entries to list

  for($i = 0; $i < count($entries); $i++){

  	// Get more entries if we're on the last one

  	if ($i == count($entries)-1) {

  	  $more++;

      $entries = array_merge($entries, load_entries($dbh, $filter_query, $max*2, $more));

  	}

  	$entry = $entries[$i];

  	// Check for a series of events

  	$multiple = array();

  	if($entry->canHaveMultiples()) {

  		while($i+1 < count($entries) && $entry->groupTogether($entries[$i+1])){

  			$multiple[] = $entries[$i+1];

  			$i++;

      	// Get more entries if we're on the last one TODO: this will never stop if whole query is multiples

      	if ($i == count($entries)-1) {

      	  $more++;

          $entries = array_merge($entries, load_entries($dbh, $filter_query, $max*2, $more));

      	}

  		}

  	}

  	if(empty($multiple))

  		$item = $entry->single();

  	else

  	  if (!$filter_query)

    		$item = $entry->multiple( $multiple );

      else

        $item = $entry->multiple( $multiple, 10 );

    // Bail if entry display returned false

    if (!$item) {

      continue;

    }

    $ul .= "\n\t<li class='$entry->feed_type feed$entry->feed_id'>$item</li>";

  	#TODO: this is temporary

  	if(!isset($count)) $count = 0;

  	$count++;

  	if($count > $max)

  		break;  		

  }

  $ul .= "\n</ul>";

  return $ul;

}