' . sprintf( __( 'You can enter calculation equations here using field_x where x is the ID of the field you want to use. For example, %sfield_53 + field_28 + field_65%s.', 'field_ should NOT be translated.', 'ninja-forms' ), '', '' ) . '
'; $desc .= '' . sprintf( __( 'Complex equations can be created by adding parentheses: %s( field_45 * field_2 ) / 2%s.', 'field_ should NOT be translated.', 'ninja-forms' ), '', '' ) . '
'; $desc .= '' .__( 'Please use these operators: + - * /. This is an advanced feature. Watch out for things like division by 0.', 'ninja-forms' ).'
'; $options = array( array( 'name' => __( 'Automatically Total Calculation Values', 'ninja-forms' ), 'value' => 'auto' ), array( 'name' => __( 'Specify Operations And Fields (Advanced)', 'ninja-forms' ), 'value' => 'fields' ), array( 'name' => __( 'Use An Equation (Advanced)', 'ninja-forms' ), 'value' => 'eq' ), ); ninja_forms_edit_field_el_output($field_id, 'select', __( 'Calculation Method', 'ninja-forms' ), 'calc_method', $calc_method, 'wide', $options, 'widefat ninja-forms-calc-method'); ?>
');
ninja_forms_edit_field_el_output($field_id, 'checkbox', __( 'Show Help Text', 'ninja-forms' ), 'show_help', $show_help, 'wide', '', 'ninja-forms-show-help');
?>
';
}
add_action( 'nf_edit_field_advanced', 'nf_field_calc_advanced_settings', 7, 2 );
/**
* Function that outputs the display for our calculation field
*
* @since 2.2.28
* @return void
*/
function ninja_forms_field_calc_display( $field_id, $data, $form_id = '' ){
if ( isset( $data['default_value'] ) ) {
$default_value = $data['default_value'];
} else {
$default_value = 0;
}
if ( $default_value == '' ) {
$default_value = 0;
}
if ( isset ( $data['calc_display_text_disabled'] ) AND $data['calc_display_text_disabled'] == 1 ) {
$disabled = "disabled";
} else {
$disabled = '';
}
if ( isset ( $data['calc_display_type'] ) ) {
$calc_display_type = $data['calc_display_type'];
} else {
$calc_display_type = 'text';
}
if ( isset ( $data['calc_display_html'] ) ) {
$calc_display_html = $data['calc_display_html'];
} else {
$calc_display_html = '';
}
if ( isset ( $data['calc_method'] ) ) {
$calc_method = $data['calc_method'];
} else {
$calc_method = '';
}
$field_class = ninja_forms_get_field_class( $field_id, $form_id );
?>
class="" rel="">
'.$default_value.'', $calc_display_html );
echo $calc_display_html;
break;
}
}
/**
* Function to output specific calculation options for a given field
*
* @param int $field_id - ID of the field being edited.
* @param array $c - Array containing the data.
* @param int $x - Index for this row of the calc array.
* @since 2.2.28
* @returns void
*/
function ninja_forms_output_field_calc_row( $field_id, $c = array(), $x = 0 ){
global $ninja_forms_fields;
$field_row = ninja_forms_get_field_by_id( $field_id );
$field_type = $field_row['type'];
$form_id = $field_row['form_id'];
if ( isset ( $c['field'] ) ) {
$calc_field = $c['field'];
} else {
$calc_field = '';
}
if ( isset ( $c['op'] ) ) {
$op = $c['op'];
} else {
$op = '';
}
?>
get_form_ID();
$all_fields = $ninja_forms_loading->get_all_fields();
} else {
$form_id = $ninja_forms_processing->get_form_ID();
$all_fields = $ninja_forms_processing->get_all_fields();
}
if ( is_array ( $all_fields ) ) {
foreach ( $all_fields as $field_id => $user_value ) {
if ( isset ( $ninja_forms_loading ) ) {
$field_row = $ninja_forms_loading->get_field_settings( $field_id );
} else {
$field_row = $ninja_forms_processing->get_field_settings( $field_id );
}
if ( isset ( $field_row['type'] ) ) {
$field_type = $field_row['type'];
} else {
$field_type = '';
}
if ( $field_type == '_calc' ) {
$field_data = $field_row['data'];
if ( isset ( $field_data['default_value'] ) ){
$default_value = $field_data['default_value'];
} else {
$default_value = 0;
}
$result = $default_value;
// Figure out which method we are using to calculate this field.
if ( isset ( $field_data['calc_method'] ) ) {
$calc_method = $field_data['calc_method'];
} else {
$calc_method = 'auto';
}
// Get our advanced field op settings if they exist.
if ( isset ( $field_data['calc'] ) ) {
$calc_fields = $field_data['calc'];
} else {
$calc_fields = array();
}
// Get our calculation equation if it exists.
if ( isset ( $field_data['calc_eq'] ) ) {
$calc_eq = $field_data['calc_eq'];
} else {
$calc_eq = array();
}
// Get our calculation equation if it exists.
if ( isset ( $field_data['calc_places'] ) ) {
$calc_places = $field_data['calc_places'];
} else {
$calc_places = 0;
}
// Figure out if there is a sub_total and a tax field. If there are, and this is a total field set to calc_method auto, we're using an equation, not auto.
$tax = false;
$sub_total = false;
if ( is_array ( $all_fields ) ) {
foreach ( $all_fields as $f_id => $user_value ) {
if ( isset ( $ninja_forms_loading ) ) {
$field = $ninja_forms_loading->get_field_settings( $f_id );
} else {
$field = $ninja_forms_processing->get_field_settings( $f_id );
}
if ( isset ( $field['type'] ) ) {
$f_type = $field['type'];
} else {
$f_type = '';
}
$data = apply_filters( 'ninja_forms_field', $field['data'], $f_id );
if ( $f_type == '_tax' ) {
// There is a tax field; save its field_id.
$tax = $field['id'];
} else if ( isset ( $data['payment_sub_total'] ) AND $data['payment_sub_total'] == 1 ) {
// There is a sub_total field; save its field_id.
$sub_total = $field['id'];
}
}
}
// If the tax and sub_total have been found, and this is a total field set to auto, change the calc_method and calc_eq.
if ( $tax AND $sub_total AND isset ( $field_data['payment_total'] ) AND $field_data['payment_total'] == 1 AND $calc_method == 'auto' ) {
$calc_method = 'eq';
if ( isset ( $ninja_forms_loading ) ) {
$tax_rate = $ninja_forms_loading->get_field_value( $tax );
} else {
$tax_rate = $ninja_forms_processing->get_field_value( $tax );
}
if ( strpos( $tax_rate, "%" ) !== false ) {
$tax_rate = str_replace( "%", "", $tax_rate );
$tax_rate = $tax_rate / 100;
}
$calc_eq = 'field_'.$sub_total.' + ( field_'.$sub_total.' * '.$tax_rate.' )';
if ( isset ( $ninja_forms_loading ) ) {
$field_settings = $ninja_forms_loading->get_field_settings( $field_id );
} else {
$field_settings = $ninja_forms_processing->get_field_settings( $field_id );
}
$field_settings['data']['calc_method'] = $calc_method;
$field_settings['data']['calc_eq'] = $calc_eq;
if ( isset ( $ninja_forms_loading ) ) {
$ninja_forms_loading->update_field_settings( $field_id, $field_settings );
} else {
$ninja_forms_processing->update_field_settings( $field_id, $field_settings );
}
}
// Loop through our fields and see which ones should be used for calculations.
if ( is_array ( $all_fields ) ) {
foreach ( $all_fields as $f_id => $user_value ) {
if ( isset ( $ninja_forms_loading ) ) {
$field = $ninja_forms_loading->get_field_settings( $f_id );
$field_value = $ninja_forms_loading->get_field_value( $f_id );
} else {
$field = $ninja_forms_processing->get_field_settings( $f_id );
$field_value = $ninja_forms_processing->get_field_value( $f_id );
}
$field_data = $field['data'];
if ( $f_id == $tax ) {
$tax = ninja_forms_field_calc_value( $field['id'], $field_value, 'auto' );;
}
switch ( $calc_method ) {
case 'auto': // We are automatically totalling the fields that have a calc_auto_include set to 1.
if ( isset ( $field_data['calc_auto_include'] ) AND $field_data['calc_auto_include'] == 1 && $field_value ) {
if ( $field['type'] == '_calc' ) {
$calc_value = ninja_forms_calc_field_loop( $field['id'], '', $result );
} else {
$calc_value = ninja_forms_field_calc_value( $field['id'], $field_value, $calc_method );
}
if ( $calc_value !== false ) {
$result = ninja_forms_calc_evaluate( 'add', $result, $calc_value );
}
}
break;
case 'fields': // We are performing a specific set of operations on a set of fields.
if ( is_array ( $calc_fields ) ) {
foreach ( $calc_fields as $c ) {
if ( $c['field'] == $field['id'] ) {
if ( $field['type'] == '_calc' ) {
$calc_value = ninja_forms_calc_field_loop( $field['id'], '', $result );
}
$calc_value = ninja_forms_field_calc_value( $field['id'], $field_value, $calc_method );
if ( $calc_value !== false ) {
$result = ninja_forms_calc_evaluate( $c['op'], $result, $calc_value );
}
}
}
}
break;
case 'eq':
if (preg_match("/\bfield_".$f_id."\b/i", $calc_eq ) ) {
if ( $field['type'] == '_calc' ) {
$calc_value = ninja_forms_calc_field_loop( $field['id'], $calc_eq );
} else {
$calc_value = ninja_forms_field_calc_value( $field['id'], $field_value, $calc_method );
}
if ( $calc_value !== false ) {
$calc_eq = preg_replace('/\bfield_'.$field['id'].'\b/', $calc_value, $calc_eq );
}
}
break;
}
}
}
if ( $calc_method == 'eq' ) {
$eq = new eqEOS();
// Swap out decimal separator
$decimal_point = $wp_locale->number_format['decimal_point'];
$calc_eq = str_replace( $decimal_point, '.', $calc_eq );
$result = $eq->solveIF($calc_eq);
// Swap back decimal separator
$result = str_replace( '.', $decimal_point, $result );
}
if ( isset ( $calc_places ) ) {
if ( empty( $calc_places ) ) {
$calc_places = 0;
}
// Swap out decimal separator
$decimal_point = $wp_locale->number_format['decimal_point'];
$result = str_replace( $decimal_point, '.', $result );
// Round and Format
$result = number_format( round( $result, $calc_places ), $calc_places );
// Swap back decimal separator
$result = str_replace( '.', $decimal_point, $result );
}
$result = str_replace( $wp_locale->number_format['thousands_sep'], '', $result );
if ( isset ( $ninja_forms_loading ) ) {
$ninja_forms_loading->update_field_value( $field_id, $result );
} else {
$ninja_forms_processing->update_field_value( $field_id, $result );
}
}
}
}
}
add_action( 'ninja_forms_pre_process', 'ninja_forms_field_calc_pre_process', 999 );
function ninja_forms_calc_check_load() {
global $ninja_forms_processing;
if ( ! is_object ( $ninja_forms_processing ) ) {
ninja_forms_field_calc_pre_process();
}
}
add_action( 'ninja_forms_display_pre_init', 'ninja_forms_calc_check_load', 999 );
function ninja_forms_calc_field_loop( $field_id, $calc_eq = '', $result = '' ) {
global $ninja_forms_loading, $ninja_forms_processing;
if ( isset ( $ninja_forms_loading ) ) {
$field_settings = $ninja_forms_loading->get_field_settings( $field_id );
} else {
$field_settings = $ninja_forms_processing->get_field_settings( $field_id );
}
$calc_data = $field_settings['data'];
// Figure out which method we are using to calculate this field.
if ( isset ( $calc_data['calc_method'] ) ) {
$calc_method = $calc_data['calc_method'];
} else {
$calc_method = 'auto';
}
// Get our advanced field op settings if they exist.
if ( isset ( $calc_data['calc'] ) ) {
$calc_fields = $calc_data['calc'];
} else {
$calc_fields = array();
}
// Get our calculation equation if it exists.
if ( isset ( $calc_data['calc_eq'] ) ) {
$calc_eq = $calc_data['calc_eq'];
} else {
$calc_eq = array();
}
if ( isset ( $ninja_forms_loading ) ) {
$form_id = $ninja_forms_loading->get_form_ID();
$all_fields = $ninja_forms_loading->get_all_fields();
} else {
$form_id = $ninja_forms_processing->get_form_ID();
$all_fields = $ninja_forms_processing->get_all_fields();
}
// Figure out if there is a sub_total and a tax field. If there are, and this is a total field set to calc_method auto, we're using an equation, not auto.
$tax = false;
$sub_total = false;
foreach ( $all_fields as $f_id => $user_value ) {
if ( isset ( $ninja_forms_loading ) ) {
$field = $ninja_forms_loading->get_field_settings( $f_id );
} else {
$field = $ninja_forms_processing->get_field_settings( $f_id );
}
$field_value = $user_value;
$data = $field['data'];
if ( $field['type'] == '_tax' ) {
// There is a tax field; save its field_id.
$tax = $field['id'];
} else if ( isset ( $data['payment_sub_total'] ) AND $data['payment_sub_total'] == 1 ) {
// There is a sub_total field; save its field_id.
$sub_total = $field['id'];
}
}
// If the tax and sub_total have been found, and this is a total field set to auto, change the calc_method and calc_eq.
if ( $tax AND $sub_total AND isset ( $calc_data['payment_total'] ) AND $calc_data['payment_total'] == 1 AND $calc_method == 'auto' ) {
$calc_method = 'eq';
if ( isset ( $ninja_forms_loading ) ) {
$tax_rate = $ninja_forms_loading->get_field_value( $tax );
} else {
$tax_rate = $ninja_forms_processing->get_field_value( $tax );
}
if ( strpos( $tax_rate, "%" ) !== false ) {
$tax_rate = str_replace( "%", "", $tax_rate );
$tax_rate = $tax_rate / 100;
}
$calc_eq = 'field_'.$sub_total.' + ( field_'.$sub_total.' * '.$tax_rate.' )';
}
// Figure out how many calculation fields we have and run
foreach ( $all_fields as $f_id => $user_value ) {
if ( isset ( $ninja_forms_loading ) ) {
$field = $ninja_forms_loading->get_field_settings( $f_id );
$field_value = $ninja_forms_loading->get_field_value( $f_id );
} else {
$field = $ninja_forms_processing->get_field_settings( $f_id );
$field_value = $ninja_forms_processing->get_field_value( $f_id );
}
$field_data = $field['data'];
if ( $f_id != $field_id ) {
switch ( $calc_method ) {
case 'auto': // We are automatically totalling the fields that have a calc_auto_include set to 1.
if ( isset ( $field_data['calc_auto_include'] ) AND $field_data['calc_auto_include'] == 1 ) {
if ( $field['type'] == '_calc' ) {
$calc_value = ninja_forms_calc_field_loop( $field['id'], '', $result );
} else {
$calc_value = ninja_forms_field_calc_value( $field['id'], $field_value, $calc_method );
}
if ( $calc_value !== false ) {
$result = ninja_forms_calc_evaluate( 'add', $result, $calc_value );
}
}
break;
case 'fields': // We are performing a specific set of operations on a set of fields.
if ( is_array ( $calc_fields ) ) {
foreach ( $calc_fields as $c ) {
if ( $c['field'] == $field['id'] ) {
if ( $field['type'] == '_calc' ) {
$result = ninja_forms_calc_field_loop( $field['id'], '', $result );
} else {
$calc_value = ninja_forms_field_calc_value( $field['id'], $field_value, $calc_method );
if ( $calc_value !== false ) {
$result = ninja_forms_calc_evaluate( $c['op'], $result, $calc_value );
}
}
}
}
}
break;
case 'eq':
if (preg_match("/\bfield_".$field['id']."\b/i", $calc_eq ) ) {
if ( $field['type'] == '_calc' ) {
$calc_value = ninja_forms_calc_field_loop( $field['id'], $calc_eq, $result );
} else {
$calc_value = ninja_forms_field_calc_value( $field['id'], $field_value, $calc_method );
}
if ( $calc_value !== false ) {
$calc_eq = preg_replace('/\bfield_'.$field['id'].'\b/', $calc_value, $calc_eq );
}
}
break;
}
}
}
if ( $calc_method == 'eq' ) {
$eq = new eqEOS();
$result = $eq->solveIF($calc_eq);
}
if ( $result == '' ) {
$result = 0;
}
return $result;
}
/**
* Function that filters the list options span and adds the appropriate listener class if there is a calc needed for the field.
*
* @since 2.2.28
* @return $class
*/
function ninja_forms_calc_filter_list_options_span( $class, $field_id ) {
global $ninja_forms_loading, $ninja_forms_processing;
if ( isset ( $ninja_forms_loading ) ) {
$field_row = $ninja_forms_loading->get_field_settings( $field_id );
} else {
$field_row = $ninja_forms_processing->get_field_settings( $field_id );
}
$add_class = false;
// Check to see if this field has cal_auto_include set to 1. If it does, we want to output a class name.
if ( isset ( $field_row['data']['calc_auto_include'] ) AND !empty ( $field_row['data']['calc_auto_include'] ) ) {
$add_class = true;
}
if ( isset ( $ninja_forms_loading ) ) {
$all_fields = $ninja_forms_loading->get_all_fields();
} else {
$all_fields = $ninja_forms_processing->get_all_fields();
}
foreach ( $all_fields as $f_id => $user_value ) {
if ( isset ( $ninja_forms_loading ) ) {
$field = $ninja_forms_loading->get_field_settings( $f_id );
} else {
$field = $ninja_forms_processing->get_field_settings( $f_id );
}
if ( isset ( $field['type'] ) && $field['type'] == '_calc' ) {
if ( isset ( $field['data']['calc_method'] ) ) {
$calc_method = $field['data']['calc_method'];
} else {
$calc_method = 'auto';
}
switch ( $calc_method ) {
case 'fields':
if ( isset ( $field['data']['calc'] ) ) {
foreach ( $field['data']['calc'] as $calc ) {
if ( $calc['field'] == $field_id ) {
$add_class = true;
break;
}
}
}
break;
case 'eq':
$eq = $field['data']['calc_eq'];
if (preg_match("/\bfield_".$field_id."\b/i", $eq ) ) {
$add_class = true;
break;
}
break;
}
}
}
if ( $add_class ) {
$class .= ' ninja-forms-field-list-options-span-calc-listen';
}
return $class;
}
add_filter( 'ninja_forms_display_list_options_span_class', 'ninja_forms_calc_filter_list_options_span', 10, 2 );
/**
* Function that takes two variables and our calculation string operator and returns the result.
*
* @since 2.2.28
* @return int value
*/
function ninja_forms_calc_evaluate( $op, $value1, $value2 ) {
switch ( $op ) {
case 'add':
return $value1 + $value2;
break;
case 'subtract':
return $value1 - $value2;
break;
case 'multiply':
return $value1 * $value2;
break;
case 'divide':
return $value1 / $value2;
break;
}
}
/**
* Function that returns the calculation value of a field given by field_id if it is to be included in the auto total.
*
* @since 2.2.30
* @return calc_value
*/
function ninja_forms_field_calc_value( $field_id, $field_value = '', $calc_method = 'auto' ) {
global $ninja_forms_loading, $ninja_forms_processing, $wp_locale;
if ( isset ( $ninja_forms_loading ) ) {
$field = $ninja_forms_loading->get_field_settings( $field_id );
} else {
$field = $ninja_forms_processing->get_field_settings( $field_id );
}
$field_data = apply_filters( 'ninja_forms_field', $field['data'], $field_id );
if ( isset ( $field_data['default_value'] ) ) {
$default_value = $field_data['default_value'];
} else {
$default_value = '';
}
if ( $field_value == '' ) {
$field_value = $default_value;
}
$calc_value = 0;
if ( $field['type'] == '_list' ) {
if ( isset ( $field_data['list']['options'] ) ) {
foreach ( $field_data['list']['options'] as $option ) {
if ( isset ( $field_data['list_show_value'] ) AND $field_data['list_show_value'] == 1 ) {
$option_value = $option['value'];
} else {
$option_value = $option['label'];
}
if ( $option_value == $field_value OR ( is_array ( $field_value ) AND in_array ( $option_value, $field_value ) ) ) {
$calc_value += $option['calc'];
}
}
}
} else if ( $field['type'] == '_checkbox' ) {
if ( $field_value == 'checked' ){
$calc_value = $field_data['calc_value']['checked'];
} else {
if ( $calc_method == 'auto' ) {
return false;
} else {
$calc_value = $field_data['calc_value']['unchecked'];
}
}
} else {
if ( !$field_value OR $field_value == '' ) {
$field_value = 0;
}
$decimal_point = $wp_locale->number_format['decimal_point'];
/* Casting to a Float removes decimal */
// $calc_value = (float) preg_replace('/[^0-9' . $decimal_point . '-]*/','',$field_value);
$calc_value = preg_replace('/[^0-9' . $decimal_point . '-]*/','',$field_value);
}
if ( is_string( $calc_value ) AND strpos( $calc_value, "%" ) !== false ) {
$calc_value = str_replace( "%", "", $calc_value );
$calc_value = $calc_value / 100;
}
if ( $calc_value == '' OR !$calc_value ) {
$calc_value = 0;
}
return $calc_value;
}