uc_views_handler_field_order_cost.inc in Ubercart Views 6.3

Ordel total cost field handler

File

views/uc_views_handler_field_order_cost.inc

<?php

/**
 * @file
 * Ordel total cost field handler
 */
class uc_views_handler_field_order_cost extends uc_views_handler_field_money_amount {
  function construct() {
    parent::construct();
    $this->additional_fields['order_id'] = 'order_id';
  }
  function query() {
    $this
      ->ensure_my_table();
    $this
      ->add_additional_fields();

    //do nothing else with the query, we'll be retrieving the information from the db
  }
  function render($values) {
    $this->field_alias = 'order_cost';
    $cost = db_result(db_query("SELECT SUM(qty * cost) FROM {uc_order_products} WHERE order_id = %d", $values->{$this->aliases['order_id']}));
    $values->{$this->field_alias} = $cost;
    return parent::render($values);
  }

}

Classes

Name	Description
uc_views_handler_field_order_cost	@file Ordel total cost field handler