views_handler_sort_ncs_last_updated.inc 660 B

123456789101112131415161718192021222324
  1. <?php
  2. /**
  3. * @file
  4. * Definition of views_handler_sort_ncs_last_updated.
  5. */
  6. /**
  7. * Sort handler for the newer of last comment / node updated.
  8. *
  9. * @ingroup views_sort_handlers
  10. */
  11. class views_handler_sort_ncs_last_updated extends views_handler_sort_date {
  12. /**
  13. * {@inheritdoc}
  14. */
  15. public function query() {
  16. $this->ensure_my_table();
  17. $this->node_table = $this->query->ensure_table('node', $this->relationship);
  18. $this->field_alias = $this->query->add_orderby(NULL, "GREATEST(" . $this->node_table . ".changed, " . $this->table_alias . ".last_comment_timestamp)", $this->options['order'], $this->table_alias . '_' . $this->field);
  19. }
  20. }