[Resolved] Code for calculating sum of another group of fields

[Author]

Posts

[JamesS2731]

Hi there,

I've found some code in one of your old support threads to calculate the sum of fields wrapped in [add-to-total][/add-to-total] but I wondered how to duplicate and alter the code to allow me to calculate the total of a separate group of fields (in this case, the first group is the total of the cost out, I'd like a separate total of cost in fields)

Original thread - https://toolset.com/forums/topic/custom-fields-calculations-sum-total-of-two-fields/

I presumed that I could just take this:

global $total;
function add_total_shortcode($atts, $content = '') {
global $total;

$total += wpv_do_shortcode($content);
}

add_shortcode('add-to-total', 'add_total_shortcode');

function show_total_shortcode() {
global $total;
$totalNew = $total;
$total = 0;
return $totalNew;
}

add_shortcode('show-total', 'show_total_shortcode');

and amend it to add a '2' after the shortcode names to give:

global $total;
function add_total_shortcode_2($atts, $content = '') {
global $total;

$total += wpv_do_shortcode($content);
}

add_shortcode('add-to-total-2', 'add_total_shortcode_2');

function show_total_shortcode_2() {
global $total;
$totalNew = $total;
$total = 0;
return $totalNew;
}

add_shortcode('show-total-2', 'show_total_shortcode_2');

And then use [add-to-event-2] and [show-total-2] as the shortcodes, but that didn't work.

Any pointers would be most appreciated.

Best regards
James

[Luo Yang]

Hello,

It is a custom codes issue, here is a sandbox website:
Login URL: hidden link

You can reproduce the same problem in above sandbox website, I need a live website to test and debug the custom PHP codes, thanks

[JamesS2731]

Hi Luo,

Many thanks for your quick response.

I've given you access to the live site (see below). It's a dev site and has been backed up so feel free to check whatever needed.

I've left the second code snippet in the Custom Code section but have deactivated it. However, I removed the two shortcodes [add-to-total-2] and [show-total-2] from the activity view.

URL: hidden link
UN: toolset
PW: xuBfPT^B9v@jPs

Activity View: hidden link

Event page: hidden link

Any thoughts or ideas most welcomed.

Kind regards
James

[Luo Yang]

Thanks for the details, I have done below modifications in your website:
1) modify the custom code snippet as below "calculator-sum":
hidden link

global $total;
function add_total_shortcode($atts, $content = '') {
global $total;
$total[$atts['name']] += wpv_do_shortcode($content);
}
  
add_shortcode('add-to-total', 'add_total_shortcode');
  
function show_total_shortcode($atts) {
global $total;
$totalNew = $total[$atts['name']];
$total[$atts['name']] = 0;
return $totalNew;
}
  
add_shortcode('show-total', 'show_total_shortcode');

2) Edit the post view:
hidden link
In section "Loop item in Activities View", change the shortcodes from:
[add-to-total][types field='activity-price-out' format='FIELD_VALUE' item='@activity-event.parent'][/types][/add-to-total]

To:
[add-to-total name='activity-price-out'][types field='activity-price-out' format='FIELD_VALUE' item='@activity-event.parent'][/types][/add-to-total]

In section "Loop Editor", display the result like this:
[show-total name='activity-price-out'][/show-total]

Test it in frontend:
hidden link

It works fine, for your reference.

[JamesS2731]

That's perfect! I can then use that for other columns and change the name for each. Brilliant.

Many thansk for your help as always.

Have a great weekend!

James