Using Computed Fields inside and outside of Unlimited Value Multigroups

Here is a working code example that contains computed fields in
unlimited type multigroups and a computed field outside of the
multigroup. It is for a work order system. The user enters
in hours and hourly rate for labor and they enter qty and unit price
for parts. The materials and labor costs all get totalled up:

I have a content type called Work Order that contains two
unlimited value multigroups, Labor and Parts.
The Labor multigroup contains four
fields:

Hours - Decimal - field_hours_work_order
Description - Text
Per Hour - Decimal - field_per_hour_work_order
Total - Computed - field_total_labor_work_order

Computed Code that multiplies hours and hourly rate

foreach (array_keys($node->field_hours_work_order) as $delta) {
  if (isset($node->field_hours_work_order[$delta]['value']) && isset($node->field_per_hour_work_order[$delta]['value'])) {
    $node_field[$delta]['value'] = $node->field_hours_work_order[$delta]['value'] * $node->field_per_hour_work_order[$delta]['value'];
  }
};

Data Type

Decimal

Not Null

The Parts multigroup also contains four fields:

Qty - Decimal - field_quantity_parts_work_order
Description - Text
Unit Price - Decimal - field_unit_price_work_order
Total - Computed - field_total_parts_work_order

Computed Code that multiplies Qty and Price

foreach (array_keys($node->field_quantity_parts_work_order) as $delta) {
  if (isset($node->field_quantity_parts_work_order[$delta]['value']) && isset($node->field_unit_price_work_order[$delta]['value'])) {
    $node_field[$delta]['value'] = $node->field_quantity_parts_work_order[$delta]['value'] * $node->field_unit_price_work_order[$delta]['value'];
  }
};

Data Type

Decimal

Not Null

Next, I have a field called Total
that adds up all the Labor and Parts totals:

Computed Code that adds up all Labor and Parts totals for a grand total

$laborpartstotal = 0;
foreach (array_keys($node->field_total_labor_work_order) as $delta) {
  if (isset($node->field_total_labor_work_order[$delta]['value'])) {
    global $laborpartstotal;
    $laborpartstotal += $node->field_total_labor_work_order[$delta]['value'];
  }
};

foreach (array_keys($node->field_total_parts_work_order) as $delta) {
  if (isset($node->field_total_parts_work_order[$delta]['value'])) {
    global $laborpartstotal;
    $laborpartstotal += $node->field_total_parts_work_order[$delta]['value'];
  }
};

$node_field[0]['value'] = $laborpartstotal;

Data Type

Decimal

Not Null

As a final step, I load up the Manage Fields page of my Work Order in a
browser with javascript turned off so I can make sure the field weights
are ok as they determine the order which the calculations take
place. I use a Firefox plugin called QuickJava to switch
javascript off. Then I make sure that the computed fields have
higher number weights than the fields they reference or the
calculations will require multiple node saves to calculate everything
(Which is unacceptable for accounting stuff.)

Hope this helps someone. Let me know if I need to
clarify anything by sending me a PM here on drupal.org.

Peace, Jeff aka loopduplicate

Comments

Thanks!

tomsm commented 25 October 2011 at 10:19

This example helped me a lot. Thank you !

Cheers for this

mautumn commented 10 November 2011 at 00:13

This very clear example saved me the trouble of figuring it out myself. Much appreciated.

GlossyIbis

Your welcome

loopduplicate

she/her

Burning Token, California

commented 19 November 2011 at 21:48

Glad it helped you. It took me awhile to figure out myself. I learn everything from people who share so I thought I'd do the same.
Jeff Mahoney aka loopduplicate

problem when editing and previewing existing node

tomsm commented 8 January 2014 at 22:41

When I edit and preview an existing node, I get the following error:

number_format() expects parameter 1 to be double, string given in /home/fysiomed/domains/fysiomed.com/public_html/sites/all/modules/computed_field/computed_field.module(362) : eval()'d code on line 1.

Any idea how to solve this?

Update: Fixed, I changed my Display Format code from:
$display = '€ '.number_format($node_field_item['value'],2,",",".");

to:

if ($node_field_item['value'] != NULL)
{$display = '€ '.number_format($node_field_item['value'],2,",",".");
};

Thanks, great example of

krisrobinson commented 27 December 2011 at 11:04

Thanks, great example of Computed fields and multigroups - was a big help to me.

Filter by taxonomy term

kaizerking commented 17 January 2012 at 12:01

I have a field collection which has computed field with a value, it works fine,How ever i have another field in the field collection which will determine category and it is a user selectable taxonomy term, i require another two computed fields out side the field collection which will have the total of each category ,how this can be achieved?

Tanks for this

one_hoopy_frood commented 6 April 2012 at 01:53

Fantastic documentation. It demonstrates the 2 things one is likely to do with multigroup and computed fields. Thanks for taking the time to write it out. -Chris

Rewritten for Drupal 7

albert9000 commented 20 May 2013 at 02:01

Example of a subtotal:

$how_many = field_get_items($entity_type, $entity, 'field_hours_work_order');
$how_much = field_get_items($entity_type, $entity, 'field_per_hour_work_order');

foreach (array_keys($how_many) as $delta) {
  if (isset($how_many[$delta]['value']) && isset($how_much[$delta]['value'])) {
    $entity_field[$delta]['value'] = $how_many[$delta]['value'] * $how_much[$delta]['value'];
  }
};

Example of getting a grand total:

$subtotal = field_get_items($entity_type, $entity, 'field_total_labor_work_order');

$laborpartstotal = 0;
foreach (array_keys($subtotal) as $delta) {
  if (isset($subtotal[$delta]['value'])) {
    global $laborpartstotal;
    $laborpartstotal += $subtotal[$delta]['value'];
  }
};

$entity_field[0]['value'] = $laborpartstotal;