function views_handler_sort_mis_last_updated::query in MERCI (Manage Equipment Reservations, Checkout and Inventory) 7.3

Called to add the sort to a query.

Overrides views_handler_sort_date::query

File

merci_inventory/views/handlers/views_handler_sort_mis_last_updated.inc, line 14

Definition of views_handler_sort_ncs_last_updated.

Class

views_handler_sort_mis_last_updated

Sort handler for the newer of last comment / node updated.

Code

function query() {
  $this
    ->ensure_my_table();
  $this->node_table = $this->query
    ->ensure_table('commerce_product', $this->relationship);
  $this->field_alias = $this->query
    ->add_orderby(NULL, "GREATEST(" . $this->node_table . ".changed, " . $this->table_alias . ".last_inventory_timestamp)", $this->options['order'], $this->table_alias . '_' . $this->field);
}