function views_handler_field_item_node_nid::pre_render in MERCI (Manage Equipment Reservations, Checkout and Inventory) 7.2

Same name and namespace in other branches

1. 6.2 handlers/views_handler_field_item_node_nid.inc \views_handler_field_item_node_nid::pre_render()

Run before any fields are rendered.

This gives the handlers some time to set up before any handler has been rendered.

Parameters

array $values: An array of all objects returned from the query.

Overrides views_handler_field::pre_render

File

handlers/views_handler_field_item_node_nid.inc, line 35

MERCI - Managed Equipment Reservation Checkout and Inventory

Class

views_handler_field_item_node_nid

Field handler for terms.

Code

function pre_render(&$values) {
  $this->field_alias = $this->aliases['vid'];
  $vids = array();
  foreach ($values as $result) {
    if (!empty($result->{$this->aliases['vid']})) {
      $vids[] = $result->{$this->aliases['vid']};
    }
  }
  if ($vids) {

    // TODO Please convert this statement to the D7 database API syntax.
    $result = db_query("SELECT m.vid as node_vid, m.did, m.merci_item_status, pn.nid AS pnid, pn.title AS ptitle, tn.nid AS tnid, tn.title AS ttitle, nt.type, nt.name FROM {merci_reservation_detail} m INNER JOIN {node} pn ON m.merci_placeholder_nid = pn.nid INNER JOIN {node_type} nt ON pn.type = nt.type LEFT JOIN {node} tn ON m.merci_item_nid = tn.nid WHERE m.vid IN (" . implode(', ', $vids) . ")");
    foreach ($result as $item) {
      $this->items[$item->node_vid][$item->pnid]['name'] = check_plain($item->ttitle ? $item->ttitle : $item->name);
    }
  }
}