<?php
// $Id$
/**
 * @file
 * Draggableviews navigation field handler
 */

/**
 * A handler.
 */
class views_handler_field_draggableviews_navigation extends views_handler_field {
  function render($values) {
    if ($this->field == 'next' || $this->field == 'previous') {
      $operator = ($this->field == 'next') ? '>' : '<';
      $order = ($this->field == 'next') ? 'ASC' : 'DESC';

      $nid = db_result(db_query("SELECT d.nid FROM {draggableviews_structure} d WHERE d.vid = %d AND d.value $operator %d ORDER BY d.value $order LIMIT 1", $this->view->vid, $values->{$this->field_alias}));

      return $nid; 
    }
  }
}