Index: views/uc_views.views.inc =================================================================== RCS file: /cvs/drupal/contributions/modules/uc_views/views/uc_views.views.inc,v retrieving revision 1.13.2.5.2.13 diff -u -r1.13.2.5.2.13 uc_views.views.inc --- views/uc_views.views.inc 27 Feb 2010 00:14:24 -0000 1.13.2.5.2.13 +++ views/uc_views.views.inc 14 Nov 2010 16:59:29 -0000 @@ -302,6 +302,15 @@ 'handler' => 'views_handler_filter_float', ), ); + + $data['uc_orders']['order_balance'] = array( + 'title' => t('Order balance'), + 'help' => ('The total balance of the order.'), + 'field' => array( + 'handler' => 'uc_views_handler_field_order_balance', + 'float' => TRUE, + ), + ); $data['uc_orders']['order_total_cost'] = array( 'title' => t('Order total cost'), @@ -906,6 +915,7 @@ 'uc_views_handler_field_order_status' => array( 'parent' => 'views_handler_field',), 'uc_views_handler_field_order_cc_data' => array( 'parent' => 'views_handler_field',), 'uc_views_handler_field_order_cost' => array( 'parent' => 'uc_views_handler_field_money_amount',), + 'uc_views_handler_field_order_balance' => array( 'parent' => 'uc_views_handler_field_money_amount',), 'uc_views_handler_field_conditional_buyitnow' => array('parent' => 'views_handler_field',), 'uc_views_handler_field_conditional_addtocart' => array('parent' => 'views_handler_field',), 'uc_views_handler_field_money_amount' => array('parent' => 'uc_product_handler_field_price',), Index: views/uc_views_handler_field_order_balance.inc =================================================================== RCS file: views/uc_views_handler_field_order_balance.inc diff -N views/uc_views_handler_field_order_balance.inc --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ views/uc_views_handler_field_order_balance.inc 1 Jan 1970 00:00:00 -0000 @@ -0,0 +1,28 @@ +additional_fields['order_id'] = 'order_id'; + $this->additional_fields['order_total'] = 'order_total'; + } + + function query() { + $this->ensure_my_table(); + $this->add_additional_fields(); + //do nothing else with the query + } + + function render($values) { + $order->order_id = $values->{$this->aliases['order_id']}; + $order->order_total = $values->{$this->aliases['order_total']}; + $balance = uc_payment_balance($order); + $values->{$this->field_alias} = $balance; + return parent::render($values); + } +} \ No newline at end of file