'; $o .= '
Sorry, you are not allowed to access this page!
'; $o .= ''; wp_die( $o, 403 ); } global $wpdb; $table_name = $wpdb->prefix . 'zacctmgr_acm_commissions_mapping'; $manager_commission_rate = $wpdb->get_results( "SELECT * FROM $table_name WHERE manager_id=$manager_id AND customer_id IS NULL ORDER BY timestamp DESC LIMIT 1;" ); $manager_order_level_commission_rate = $wpdb->get_results( "SELECT * FROM $table_name WHERE manager_id=$manager_id AND order_level=1 AND customer_account_level=0 AND customer_id IS NULL ORDER BY timestamp DESC LIMIT 1;" ); $manager_customer_level_commission_rate = $wpdb->get_results( "SELECT * FROM $table_name WHERE manager_id=$manager_id AND customer_id IS NULL AND customer_account_level=1 ORDER BY timestamp DESC LIMIT 1;" ); $manager_no_commission_rate = $wpdb->get_results( "SELECT * FROM $table_name WHERE manager_id=$manager_id AND customer_id IS NULL AND customer_account_level=0 AND no_commission=1 ORDER BY timestamp DESC LIMIT 1;" ); if ( count( $manager_commission_rate ) != 0 ) { $current_commission_rate = $manager_commission_rate[0]; if ( count( $manager_order_level_commission_rate ) != 0 ) { if ( count( $manager_customer_level_commission_rate ) != 0 ) { if ( $manager_order_level_commission_rate[0]->timestamp > $manager_customer_level_commission_rate[0]->timestamp ) { if ( count( $manager_no_commission_rate ) != 0 ) { if ( $manager_order_level_commission_rate[0]->timestamp > $manager_no_commission_rate[0]->timestamp ) { $commission_rate = $manager_order_level_commission_rate[0]; } else { $commission_rate = $manager_no_commission_rate[0]; } } else { $commission_rate = $manager_order_level_commission_rate[0]; } } else { if ( count( $manager_no_commission_rate ) != 0 ) { if ( $manager_customer_level_commission_rate[0]->timestamp > $manager_no_commission_rate[0]->timestamp ) { $commission_rate = $manager_customer_level_commission_rate[0]; } else { $commission_rate = $manager_no_commission_rate[0]; } } else { $commission_rate = $manager_customer_level_commission_rate[0]; } } } else { if ( count( $manager_no_commission_rate ) != 0 ) { if ( $manager_order_level_commission_rate[0]->timestamp > $manager_no_commission_rate[0]->timestamp ) { $commission_rate = $manager_order_level_commission_rate[0]; } else { $commission_rate = $manager_no_commission_rate[0]; } } else { $commission_rate = $manager_order_level_commission_rate[0]; } } } else { $commission_rate = new StdClass (); $commission_rate->no_commission = 0; $commission_rate->order_level = 1; $commission_rate->customer_account_level = 0; $commission_rate->new_order_commission_percentage_type = 0; $commission_rate->new_order_commission_fixed_type = 1; $commission_rate->new_order_commission_value = 0; $commission_rate->new_order_commission_limit = 1; $commission_rate->new_order_exclude_coupon_amount = 0; $commission_rate->new_order_exclude_taxes_amount = 0; $commission_rate->new_order_exclude_shipping_costs = 0; $commission_rate->new_order_exclude_shipping_tax_amount = 0; $commission_rate->existing_order_commission_percentage_type = 0; $commission_rate->existing_order_commission_fixed_type = 1; $commission_rate->existing_order_commission_value = 0; $commission_rate->existing_order_exclude_coupon_amount = 0; $commission_rate->existing_order_exclude_taxes_amount = 0; $commission_rate->existing_order_exclude_shipping_costs = 0; $commission_rate->existing_order_exclude_shipping_tax_amount = 0; } } else { $commission_rate = new StdClass (); $commission_rate->no_commission = 0; $commission_rate->order_level = 1; $commission_rate->customer_account_level = 0; $commission_rate->new_order_commission_percentage_type = 0; $commission_rate->new_order_commission_fixed_type = 1; $commission_rate->new_order_commission_value = 0; $commission_rate->new_order_commission_limit = 1; $commission_rate->new_order_exclude_coupon_amount = 0; $commission_rate->new_order_exclude_taxes_amount = 0; $commission_rate->new_order_exclude_shipping_costs = 0; $commission_rate->new_order_exclude_shipping_tax_amount = 0; $commission_rate->existing_order_commission_percentage_type = 0; $commission_rate->existing_order_commission_fixed_type = 1; $commission_rate->existing_order_commission_value = 0; $commission_rate->existing_order_exclude_coupon_amount = 0; $commission_rate->existing_order_exclude_taxes_amount = 0; $commission_rate->existing_order_exclude_shipping_costs = 0; $commission_rate->existing_order_exclude_shipping_tax_amount = 0; $current_commission_rate = $commission_rate; } $new_exclude = []; if ( $commission_rate->new_order_commission_percentage_type == 1 ) { if ( $commission_rate->new_order_exclude_coupon_amount == 1 ) { array_push( $new_exclude, 'coupon' ); } if ( $commission_rate->new_order_exclude_taxes_amount == 1 ) { array_push( $new_exclude, 'tax' ); } if ( $commission_rate->new_order_exclude_shipping_costs == 1 ) { array_push( $new_exclude, 'shipping' ); } if ( $commission_rate->new_order_exclude_shipping_tax_amount == 1 ) { array_push( $new_exclude, 'shipping_tax' ); } } $existing_exclude = []; if ( $commission_rate->existing_order_commission_percentage_type == 1 ) { if ( $commission_rate->existing_order_exclude_coupon_amount == 1 ) { array_push( $existing_exclude, 'coupon' ); } if ( $commission_rate->existing_order_exclude_taxes_amount == 1 ) { array_push( $existing_exclude, 'tax' ); } if ( $commission_rate->existing_order_exclude_shipping_costs == 1 ) { array_push( $existing_exclude, 'shipping' ); } if ( $commission_rate->existing_order_exclude_shipping_tax_amount == 1 ) { array_push( $existing_exclude, 'shipping_tax' ); } } if ( $commission_rate->order_level == 1 ) { $commission_type = 'order_level'; } elseif ( $commission_rate->customer_account_level == 1 ) { $commission_type = 'customer_account_level'; } else { $commission_type = 'no_commission'; } if ( $current_commission_rate->order_level == 1 ) { $current_commission_type = 'order_level'; } elseif ( $current_commission_rate->customer_account_level == 1 ) { $current_commission_type = 'customer_account_level'; } else { $current_commission_type = 'no_commission'; } $new_fixed_type = $commission_rate->new_order_commission_fixed_type; $existing_fixed_type = $commission_rate->existing_order_commission_fixed_type; $new_percentage_type = $commission_rate->new_order_commission_percentage_type; $existing_percentage_type = $commission_rate->existing_order_commission_percentage_type; $order_count = $commission_rate->new_order_commission_limit; $new_value = $commission_rate->new_order_commission_value; $existing_value = $commission_rate->existing_order_commission_value; /* order_level, customer_account_level, no_commission */ $zacctmgr_commission_type = $data->zacctmgr_commission_type ? $data->zacctmgr_commission_type : 'order_level'; $value1 = ''; $value2 = ''; $type1 = ''; $type1 .= ''; $type2 = ''; $type2 .= ''; $order1 = ''; /* Apply 1 */ $apply1 = ''; $style_fixed = 'style="display: block;"'; $style_percentage = 'style="display: none;"'; if ( $new_percentage_type == 1 ) { $style_fixed = 'style="display: none;"'; $style_percentage = 'style="display: block;"'; } $zacctmgr_commission_new_exclude_options = $new_exclude; $apply1 .= 'Account Manager commission updated.
← Back to Commission
Accounts
Order Level
Accounts
Customer Account Level
| Order Level Rates | Apply to | Value | Calculated by |
|---|---|---|---|
| New Orders | new_order_commission_limit; ?> | new_order_commission_value . ( $order_level_commission->new_order_commission_percentage_type == 1 ? '%' : '' ); ?> | new_order_commission_percentage_type == 1 ) { $o = ''; if ( $order_level_commission->new_order_exclude_coupon_amount == 1 ) { $o .= 'Exclude Coupon Amount|
| Existing Orders | existing_order_commission_value . ( $order_level_commission->new_order_commission_percentage_type == 1 ? '%' : '' ); ?> | existing_order_commission_percentage_type == 1 ) { $o = ''; if ( $order_level_commission->existing_order_exclude_coupon_amount == 1 ) { $o .= 'Exclude Coupon Amount
| Commission Calculations | '; echo '
|---|
| ';
echo ' ';
echo ' ';
echo '';
echo '';
echo '';
echo ' ';
echo '';
echo '';
echo '';
echo ' ';
echo '';
echo '';
echo '';
echo ' ';
echo ' | ';
echo '
| Commission Rates | '; echo 'Apply to | '; echo 'Value | '; echo 'Type | '; echo 'Calculate By | '; echo '
|---|---|---|---|---|
| New Orders | '; echo '' . $order1 . ' | '; echo '' . $value1 . ' | '; echo '' . $type1 . ' | '; echo '' . $apply1 . ' | '; echo '
| Existing Orders | '; echo ''; echo ' | ' . $value2 . ' | '; echo '' . $type2 . ' | '; echo '' . $apply2 . ' | '; echo '
'; echo ''; echo '
'; echo ''; echo '