<?php

/**

 * @file

 * User page callbacks for the Aggregator module.

 */

/**

 * Page callback: Displays the most recent items gathered from any feed.

 *

 * @return

 *   The rendered list of items for the feed.

 */

function aggregator_page_last() {

  drupal_add_feed('aggregator/rss', variable_get('site_name', 'Drupal') . ' ' . t('aggregator'));

  $items = aggregator_feed_items_load('sum');

  return _aggregator_page_list($items, arg(1));

}

/**

 * Page callback: Displays all the items captured from the particular feed.

 *

 * @param $feed

 *   The feed for which to display all items.

 *

 * @return

 *   The rendered list of items for a feed.

 *

 * @see aggregator_menu()

 */

function aggregator_page_source($feed) {

  drupal_set_title($feed->title);

  $feed_source = theme('aggregator_feed_source', array('feed' => $feed));

  // It is safe to include the fid in the query because it's loaded from the

  // database by aggregator_feed_load.

  $items = aggregator_feed_items_load('source', $feed);

  return _aggregator_page_list($items, arg(3), $feed_source);

}

/**

 * Page callback: Displays a form with all items captured from a feed.

 *

 * @param $feed

 *   The feed for which to list all of the aggregated items.

 *

 * @return

 *   The rendered list of items for the feed.

 *

 * @see aggregator_page_source()

 */

function aggregator_page_source_form($form, $form_state, $feed) {

  return aggregator_page_source($feed);

}

/**

 * Page callback: Displays all the items aggregated in a particular category.

 *

 * @param $category

 *   The category for which to list all of the aggregated items.

 *

 * @return

 *   The rendered list of items for the feed.

 */

function aggregator_page_category($category) {

  drupal_add_feed('aggregator/rss/' . $category['cid'], variable_get('site_name', 'Drupal') . ' ' . t('aggregator - @title', array('@title' => $category['title'])));

  // It is safe to include the cid in the query because it's loaded from the

  // database by aggregator_category_load.

  $items = aggregator_feed_items_load('category', $category);

  return _aggregator_page_list($items, arg(3));

}

/**

 * Page callback: Displays a form containing items aggregated in a category.

 *

 * @param $category

 *   The category for which to list all of the aggregated items.

 *

 * @return

 *   The rendered list of items for the feed.

 *

 * @see aggregator_page_category()

 */

function aggregator_page_category_form($form, $form_state, $category) {

  return aggregator_page_category($category);

}

/**

 * Loads and optionally filters feed items.

 *

 * @param $type

 *   The type of filter for the items. Possible values are:

 *   - sum: No filtering.

 *   - source: Filter the feed items, limiting the result to items from a

 *     single source.

 *   - category: Filter the feed items by category.

 * @param $data

 *   Feed or category data used for filtering. The type and value of $data

 *   depends on $type:

 *   - source: $data is an object with $data->fid identifying the feed used to

 *     as filter.

 *   - category: $data is an array with $data['cid'] being the category id to

 *     filter on.

 *   The $data parameter is not used when $type is 'sum'.

 *

 * @return

 *   An array of the feed items.

 */

function aggregator_feed_items_load($type, $data = NULL) {

  $items = array();

  switch ($type) {

    case 'sum':

      $query = db_select('aggregator_item', 'i');

      $query->join('aggregator_feed', 'f', 'i.fid = f.fid');

      $query->fields('i');

      $query->addField('f', 'title', 'ftitle');

      $query->addField('f', 'link', 'flink');

      break;

    case 'source':

      $query = db_select('aggregator_item', 'i');

      $query

        ->fields('i')

        ->condition('i.fid', $data->fid);

      break;

    case 'category':

      $query = db_select('aggregator_category_item', 'c');

      $query->leftJoin('aggregator_item', 'i', 'c.iid = i.iid');

      $query->leftJoin('aggregator_feed', 'f', 'i.fid = f.fid');

      $query

        ->fields('i')

        ->condition('cid', $data['cid']);

      $query->addField('f', 'title', 'ftitle');

      $query->addField('f', 'link', 'flink');

      break;

  }

  $result = $query

    ->extend('PagerDefault')

    ->limit(20)

    ->orderBy('i.timestamp', 'DESC')

    ->orderBy('i.iid', 'DESC')

    ->execute();

  foreach ($result as $item) {

    $item->categories = db_query('SELECT c.title, c.cid FROM {aggregator_category_item} ci LEFT JOIN {aggregator_category} c ON ci.cid = c.cid WHERE ci.iid = :iid ORDER BY c.title', array(':iid' => $item->iid))->fetchAll();

    $items[] = $item;

  }

  return $items;

}

/**

 * Prints an aggregator page listing a number of feed items.

 *

 * Various menu callbacks use this function to print their feeds.

 *

 * @param $items

 *   The items to be listed.

 * @param $op

 *   Which form should be added to the items. Only 'categorize' is now

 *   recognized.

 * @param $feed_source

 *   The feed source URL.

 *

 * @return

 *   The rendered list of items for the feed.

 */

function _aggregator_page_list($items, $op, $feed_source = '') {

  if (user_access('administer news feeds') && ($op == 'categorize')) {

    // Get form data.

    $output = aggregator_categorize_items($items, $feed_source);

  }

  else {

    // Assemble themed output.

    $output = $feed_source;

    foreach ($items as $item) {

      $output .= theme('aggregator_item', array('item' => $item));

    }

    $output = theme('aggregator_wrapper', array('content' => $output));

  }

  return $output;

}

/**

 * Form constructor to build the page list form.

 *

 * @param $items

 *   An array of the feed items.

 * @param $feed_source

 *   (optional) The feed source URL. Defaults to an empty string.

 *

 * @return array

 *   An array of FAPI elements.

 *

 * @see aggregator_categorize_items_submit()

 * @see theme_aggregator_categorize_items()

 * @ingroup forms

 */

function aggregator_categorize_items($items, $feed_source = '') {

  $form['#submit'][] = 'aggregator_categorize_items_submit';

  $form['#theme'] = 'aggregator_categorize_items';

  $form['feed_source'] = array(

    '#value' => $feed_source,

  );

  $categories = array();

  $done = FALSE;

  $form['items'] = array();

  $form['categories'] = array(

    '#tree' => TRUE,

  );

  foreach ($items as $item) {

    $form['items'][$item->iid] = array('#markup' => theme('aggregator_item', array('item' => $item)));

    $form['categories'][$item->iid] = array();

    $categories_result = db_query('SELECT c.cid, c.title, ci.iid FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid AND ci.iid = :iid', array(':iid' => $item->iid));

    $selected = array();

    foreach ($categories_result as $category) {

      if (!$done) {

        $categories[$category->cid] = check_plain($category->title);

      }

      if ($category->iid) {

        $selected[] = $category->cid;

      }

    }

    $done = TRUE;

    $form['categories'][$item->iid] = array(

      '#type' => variable_get('aggregator_category_selector', 'checkboxes'),

      '#default_value' => $selected,

      '#options' => $categories,

      '#size' => 10,

      '#multiple' => TRUE

    );

  }

  $form['actions'] = array('#type' => 'actions');

  $form['actions']['submit'] = array('#type' => 'submit', '#value' => t('Save categories'));

  return $form;

}

/**

 * Form submission handler for aggregator_categorize_items().

 */

function aggregator_categorize_items_submit($form, &$form_state) {

  if (!empty($form_state['values']['categories'])) {

    foreach ($form_state['values']['categories'] as $iid => $selection) {

      db_delete('aggregator_category_item')

        ->condition('iid', $iid)

        ->execute();

      $insert = db_insert('aggregator_category_item')->fields(array('iid', 'cid'));

      $has_values = FALSE;

      foreach ($selection as $cid) {

        if ($cid && $iid) {

          $has_values = TRUE;

          $insert->values(array(

            'iid' => $iid,

            'cid' => $cid,

          ));

        }

      }

      if ($has_values) {

        $insert->execute();

      }

    }

  }

  drupal_set_message(t('The categories have been saved.'));

}

/**

 * Returns HTML for the aggregator page list form for assigning categories.

 *

 * @param $variables

 *   An associative array containing:

 *   - form: A render element representing the form.

 *

 * @ingroup themeable

 */

function theme_aggregator_categorize_items($variables) {

  $form = $variables['form'];

  $output = drupal_render($form['feed_source']);

  $rows = array();

  if (!empty($form['items'])) {

    foreach (element_children($form['items']) as $key) {

      $rows[] = array(

        drupal_render($form['items'][$key]),

        array('data' => drupal_render($form['categories'][$key]), 'class' => array('categorize-item')),

      );

    }

  }

  $output .= theme('table', array('header' => array('', t('Categorize')), 'rows' => $rows));

  $output .= drupal_render($form['submit']);

  $output .= drupal_render_children($form);

  return theme('aggregator_wrapper', array('content' => $output));

}

/**

 * Processes variables for aggregator-wrapper.tpl.php.

 *

 * @see aggregator-wrapper.tpl.php

 */

function template_preprocess_aggregator_wrapper(&$variables) {

  $variables['pager'] = theme('pager');

}

/**

 * Processes variables for aggregator-item.tpl.php.

 *

 * @see aggregator-item.tpl.php

 */

function template_preprocess_aggregator_item(&$variables) {

  $item = $variables['item'];

  $variables['feed_url'] = check_url($item->link);

  $variables['feed_title'] = check_plain($item->title);

  $variables['content'] = aggregator_filter_xss($item->description);

  $variables['source_url'] = '';

  $variables['source_title'] = '';

  if (isset($item->ftitle) && isset($item->fid)) {

    $variables['source_url'] = url("aggregator/sources/$item->fid");

    $variables['source_title'] = check_plain($item->ftitle);

  }

  if (date('Ymd', $item->timestamp) == date('Ymd')) {

    $variables['source_date'] = t('%ago ago', array('%ago' => format_interval(REQUEST_TIME - $item->timestamp)));

  }

  else {

    $variables['source_date'] = format_date($item->timestamp, 'custom', variable_get('date_format_medium', 'D, m/d/Y - H:i'));

  }

  $variables['categories'] = array();

  foreach ($item->categories as $category) {

    $variables['categories'][$category->cid] = l($category->title, 'aggregator/categories/' . $category->cid);

  }

}

/**

 * Page callback: Displays all the feeds used by the aggregator.

 *

 * @return

 *   An HTML-formatted string.

 *

 * @see aggregator_menu()

 */

function aggregator_page_sources() {

  $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title');

  $output = '';

  foreach ($result as $feed) {

    // Most recent items:

    $summary_items = array();

    if (variable_get('aggregator_summary_items', 3)) {

      $items = db_query_range('SELECT i.title, i.timestamp, i.link FROM {aggregator_item} i WHERE i.fid = :fid ORDER BY i.timestamp DESC', 0, variable_get('aggregator_summary_items', 3), array(':fid' => $feed->fid));

      foreach ($items as $item) {

        $summary_items[] = theme('aggregator_summary_item', array('item' => $item));

      }

    }

    $feed->url = url('aggregator/sources/' . $feed->fid);

    $output .= theme('aggregator_summary_items', array('summary_items' => $summary_items, 'source' => $feed));

  }

  $output .= theme('feed_icon', array('url' => 'aggregator/opml', 'title' => t('OPML feed')));

  return theme('aggregator_wrapper', array('content' => $output));

}

/**

 * Page callback: Displays all the categories used by the Aggregator module.

 *

 * @return string

 *   An HTML formatted string.

 *

 * @see aggregator_menu()

 */

function aggregator_page_categories() {

  $result = db_query('SELECT c.cid, c.title, c.description FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid LEFT JOIN {aggregator_item} i ON ci.iid = i.iid GROUP BY c.cid, c.title, c.description');

  $output = '';

  foreach ($result as $category) {

    if (variable_get('aggregator_summary_items', 3)) {

      $summary_items = array();

      $items = db_query_range('SELECT i.title, i.timestamp, i.link, f.title as feed_title, f.link as feed_link FROM {aggregator_category_item} ci LEFT JOIN {aggregator_item} i ON i.iid = ci.iid LEFT JOIN {aggregator_feed} f ON i.fid = f.fid WHERE ci.cid = :cid ORDER BY i.timestamp DESC', 0, variable_get('aggregator_summary_items', 3), array(':cid' => $category->cid));

      foreach ($items as $item) {

        $summary_items[] = theme('aggregator_summary_item', array('item' => $item));

      }

    }

    $category->url = url('aggregator/categories/' . $category->cid);

    $output .= theme('aggregator_summary_items', array('summary_items' => $summary_items, 'source' => $category));

  }

  return theme('aggregator_wrapper', array('content' => $output));

}

/**

 * Page callback: Generates an RSS 0.92 feed of aggregator items or categories.

 *

 * @return string

 *   An HTML formatted string.

 */

function aggregator_page_rss() {

  $result = NULL;

  // arg(2) is the passed cid, only select for that category.

  if (arg(2)) {

    $category = db_query('SELECT cid, title FROM {aggregator_category} WHERE cid = :cid', array(':cid' => arg(2)))->fetchObject();

    $result = db_query_range('SELECT i.*, f.title AS ftitle, f.link AS flink FROM {aggregator_category_item} c LEFT JOIN {aggregator_item} i ON c.iid = i.iid LEFT JOIN {aggregator_feed} f ON i.fid = f.fid WHERE cid = :cid ORDER BY timestamp DESC, i.iid DESC', 0, variable_get('feed_default_items', 10), array(':cid' => $category->cid));

  }

  // Or, get the default aggregator items.

  else {

    $category = NULL;

    $result = db_query_range('SELECT i.*, f.title AS ftitle, f.link AS flink FROM {aggregator_item} i INNER JOIN {aggregator_feed} f ON i.fid = f.fid ORDER BY i.timestamp DESC, i.iid DESC', 0, variable_get('feed_default_items', 10));

  }

  $feeds = $result->fetchAll();