Jump to content

wordpress plugin help

rajasekaran1965

By rajasekaran1965
in Applications

 Share

Recommended Posts

rajasekaran1965 Newbie

rajasekaran1965

Posted
Posted (edited)

Hi

 

I need to add one more function in my wordpress plugin. below is the sample code working for 2nd tier. Now i need a same function for 3rd and 4th tire.

 

Function explanation

 

I am A and i refer B and if B made any sale means I (A) will get direct commission for that sale.

 

If B refer C and if C made any sale means (B) will get direct commission for that sale. And in this sample code me(A) also get commission for that sale as a 2nd tier.

 

Now C refer D and if D made any sale means © will get direct commission for that sale and (B) will get 2nd tier commission. So here (A) me too should get 3rd tire commission and i need that function.

 

Please help me.

 

 

function wp_aff_award_second_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name='')
{
global $aff_tx_msg;
    $clientdate = (date ("Y-m-d"));
$clienttime = (date ("H:i:s")); 


if (get_option('wp_aff_use_2tier') && !empty($wp_aff_affiliates_db->referrer))
{
$aff_tx_msg .= '<br />Using tier model';
wp_affiliate_log_debug("Using tier model",true);
$award_tier_commission = true; 
$duration = get_option('wp_aff_2nd_tier_duration'); 
if(!empty($duration))
{
$join_date = $wp_aff_affiliates_db->date;
$days_since_joined = round((strtotime(date("Y-m-d")) - strtotime($join_date) ) / (60 * 60 * 24));


if ($days_since_joined > $duration)
{
$aff_tx_msg .= '<br />Tier commission award duration expried';
wp_affiliate_log_debug("Tier commission award duration expried! No tier commission will be awarded for this sale.",true);
$award_tier_commission = false;
}
} 
if ($award_tier_commission)
{
if(!empty($wp_aff_affiliates_db->sec_tier_commissionlevel)){
$second_tier_commission_level = $wp_aff_affiliates_db->sec_tier_commissionlevel;
wp_affiliate_log_debug("Using the affiliate specific 2nd tier commission for this referral. 2nd tier commission level: ".$second_tier_commission_level,true);
}
else{
$second_tier_commission_level = get_option('wp_aff_2nd_tier_commission_level');
wp_affiliate_log_debug("Using global 2nd tier commission for this referral. 2nd tier commission level: ".$second_tier_commission_level,true);
}
if (get_option('wp_aff_use_fixed_commission'))
{
                    $commission_amount = $second_tier_commission_level;
                }
                else
                {
   $commission_amount = round(($second_tier_commission_level * $sale_amount)/100,2);
                }
                $campaign_id = "";
                $is_tier_comm = "yes";
global $wpdb;
$aff_sales_table = WP_AFF_SALES_TBL_NAME;
$updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name,is_tier_comm) VALUES ('$wp_aff_affiliates_db->referrer','$clientdate','$clienttime','','','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$campaign_id','$buyer_name','$is_tier_comm')";
$results = $wpdb->query($updatedb); 
$aff_tx_msg .= '<br />Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount;
wp_affiliate_log_debug('Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount,true); 
} 
} 
return $aff_tx_msg;
}
Edited by Ch0cu3r
Link to comment
Share on other sites
QuickOldCar Regular Member

QuickOldCar

Posted
Posted

I was interested in this so made a function that produces an array of the tier levels, refer letter, amount remaining each tier after commission deducted, percentage used and commission price

 

Maybe not exactly what you were looking for with your current code, but something you should consider versus trying to keep adding more tiers.

If it's something different than you expect, are welcome to modify it.

 

Was interesting to create either way.

<?php
function referPosition($refer_letter, $amount, $percentage)
{
    //check all parameters exist
    if (!$refer_letter || !$amount || !$percentage) {
        return NULL;
    }
   
    //create alphabet array
    $alphabet = range('a', 'z');
   
    //letter check
    $refer_letter = strtolower(trim($refer_letter));
    if ($refer_letter == '' || !in_array($refer_letter, $alphabet)) {
        return NULL;
    }
    //amount check
    $amount = str_replace(array(
        "$",
        ","
    ), array(
        "",
        ""
    ), $amount);
    $amount = number_format($amount, 2, '.', '');
    if (trim($amount) <= 0 || !is_numeric($amount)) {
        return NULL;
    }
    //percentage check
    $percentage = str_replace("%", "", $percentage);
    if (trim($percentage) <= 0 || !is_numeric($percentage)) {
        return NULL;
    }
   
    //find array key position of the letter in array, slice it, reverse it
    $find_key       = array_search($refer_letter, $alphabet);
    $count_position = array_search($find_key, array_keys($alphabet));
   
    //add 1 to count position
    $count_position = $count_position + 1;
   
    $refer_array = array_slice($alphabet, 0, $count_position);
    $refer_array = array_reverse($refer_array);
   
    //loop remaining letters in array and calculate amounts by percentages
    $commission_array = array();
    $deduct           = 0;
    foreach ($refer_array as $key => $value) {
        $amount        = $amount - $deduct;
        $amount        = number_format($amount, 2, '.', '');
        $deduct        = ($percentage / 100) * $amount;
        $deduct        = number_format($deduct, 2);
        $tier          = $key + 1;
        $pretty_amount = number_format($amount, 2, '.', '');
       
        //build an array
        $commission_array[] = array(
            "tier" => $tier,
            "letter" => $value,
            "amount" => $pretty_amount,
            "percentage" => $percentage,
            "commission" => $deduct
        );
       
        //simple single array letter as key and commision_value
        //$commission_array[$value] = number_format($deduct, 2);
    }
   
    return $commission_array;
   
}

/*
Usage
arguments:
letter: works letters a-z upper and lower
amount: $ or not, comma or not
percentage: % or not
all 3 function arguments required or returns null
if any arguments do not meet expectations, returns null
*/

//$payments = referPosition("a", "100", "25%");
//$payments = referPosition("b","$40,000.23","1.5");
//$payments = referPosition("c","$35","5.5");
$payments = referPosition("d","350.20","10%");//letter,amount,percentage


//show the array if commission is due
if (is_array($payments)) {
    echo "<pre>";
    print_r($payments);
    echo "</pre>";
} else {
    echo $payments = 0;
}

?>

This example returns:

Array
(
    [0] => Array
        (
            [tier] => 1
            [letter] => d
            [amount] => 350.20
            [percentage] => 10
            [commission] => 35.02
        )

    [1] => Array
        (
            [tier] => 2
            [letter] => c
            [amount] => 315.18
            [percentage] => 10
            [commission] => 31.52
        )

    [2] => Array
        (
            [tier] => 3
            [letter] => b
            [amount] => 283.66
            [percentage] => 10
            [commission] => 28.37
        )

    [3] => Array
        (
            [tier] => 4
            [letter] => a
            [amount] => 255.29
            [percentage] => 10
            [commission] => 25.53
        )

)

Link to comment
Share on other sites
rajasekaran1965 Newbie

rajasekaran1965

Posted
  • Author
Posted (edited)

Hi  QuickOldCar,

 

Thank you for your interest in this but actually your code not worked in my program. Just check the below functions. first function is awarding commission for direct referral and second function is awarding commission for 2nd tier referral and third function is added by me for 3rd tier commission but it is not worked bcoz it is not getting the parent referral details. So pleas guide me how to get the parent referral function.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

 
function wp_aff_award_commission($referrer,$sale_amount,$txn_id,$item_id,$buyer_email,$clientip='',$comm_rate='',$buyer_name='')
{
global $aff_tx_msg,$aff_error_msg;
$commission_award_result = "";
$debug_data = "";
$debug_data .= "Referrer: ".$referrer. ", Sale Amount: ".$sale_amount.", Transaction ID: ".$txn_id.", ";
$debug_data .= "Item ID: ".$item_id. ", Buyer Email: ".$buyer_email.", Custom Commission Rate: ".$comm_rate;
$aff_tx_msg = $debug_data;
wp_affiliate_log_debug($debug_data,true);
    $clientdate = (date ("Y-m-d"));
$clienttime = (date ("H:i:s"));
if(empty($clientip))
{
$clientip = $_SERVER['REMOTE_ADDR'];
} 
    if(empty($txn_id))
    {
        $txn_id = uniqid();
    }
if (!empty($referrer))
{
global $wpdb;
$affiliates_table_name = $wpdb->prefix . "affiliates_tbl";
$aff_sales_table = $wpdb->prefix . "affiliates_sales_tbl";
$wp_aff_affiliates_db = $wpdb->get_row("SELECT * FROM $affiliates_table_name WHERE refid = '$referrer'", OBJECT);
if(empty($comm_rate)){ 
$commission_level = $wp_aff_affiliates_db->commissionlevel;
}
else{
$commission_level = $comm_rate;
}


if (get_option('wp_aff_use_fixed_commission'))
{
            $commission_amount = $commission_level;
        }
        else
        {
   $commission_amount = ($commission_level * $sale_amount)/100;
        }
   
if(WP_AFFILIATE_NO_COMMISSION_FOR_SELF_PURCHASE == '1'){
if(!empty($buyer_email)){
if(wp_aff_check_if_buyer_is_referrer($referrer,$buyer_email)){
wp_affiliate_log_debug('The buyer ('.$buyer_email.') is the referrer ('.$referrer.') so this sale is NOT ELIGIBLE for generating any commission.',true);
return true;
}
}
else{
wp_affiliate_log_debug("Buyer email data is missing from the request so the plugin cannot verify the WP_AFFILIATE_NO_COMMISSION_FOR_SELF_PURCHASE option",true);
}
}


$commission_amount = round($commission_amount,2);
        $c_id='';
        if(isset($_COOKIE['c_id'])){
         $c_id = $_COOKIE['c_id'];
        }
        
        if(!empty($buyer_name)){
$updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name) VALUES ('$referrer','$clientdate','$clienttime','','$clientip','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$c_id','$buyer_name')";         
        }
        else{
        $updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id) VALUES ('$referrer','$clientdate','$clienttime','','$clientip','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$c_id')";
        } 
        $results = $wpdb->query($updatedb); 
if(!$results)
{
$aff_tx_msg .= "<br />The database update query failed for table: ".$aff_sales_table;
wp_affiliate_log_debug("The database update query failed for table: ".$aff_sales_table,false);
} 
else
{ 
$aff_tx_msg .= '<br />The sale has been registered in the WP Affiliate Platform Database for referrer: '.$referrer.' with amount: '.$commission_amount;
wp_affiliate_log_debug('The sale has been registered in the WP Affiliate Platform Database for referrer: '.$referrer.' with amount: '.$commission_amount,true);
}
wp_aff_send_commission_notification($wp_aff_affiliates_db->email,$txn_id);


// 2nd tier commission
$commission_award_result = wp_aff_award_second_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name);


//This below lines are added by me for tiers 3 to 7
// 3rd tier commission
$commission_award_result = wp_aff_award_third_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name);
// 4th tier commission
$commission_award_result = wp_aff_award_fourth_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name);
// 5th tier commission
$commission_award_result = wp_aff_award_fifth_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name);
// 6th tier commission
$commission_award_result = wp_aff_award_sixth_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name);
// 7th tier commission
$commission_award_result = wp_aff_award_seventh_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name); 
// Up to above i added in this function
}
return $commission_award_result; 
}
This function is existing and working fine for second tier
 
function wp_aff_award_second_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name='')
{
global $aff_tx_msg;
    $clientdate = (date ("Y-m-d"));
$clienttime = (date ("H:i:s")); 


if (get_option('wp_aff_use_2tier') && !empty($wp_aff_affiliates_db->referrer))
{
$aff_tx_msg .= '<br />Using tier model';
wp_affiliate_log_debug("Using tier model",true);
$award_tier_commission = true; 
$duration = get_option('wp_aff_2nd_tier_duration'); 
if(!empty($duration))
{
$join_date = $wp_aff_affiliates_db->date;
$days_since_joined = round((strtotime(date("Y-m-d")) - strtotime($join_date) ) / (60 * 60 * 24));


if ($days_since_joined > $duration)
{
$aff_tx_msg .= '<br />Tier commission award duration expried';
wp_affiliate_log_debug("Tier commission award duration expried! No tier commission will be awarded for this sale.",true);
$award_tier_commission = false;
}
} 
if ($award_tier_commission)
{
if(!empty($wp_aff_affiliates_db->sec_tier_commissionlevel)){
$second_tier_commission_level = $wp_aff_affiliates_db->sec_tier_commissionlevel;
wp_affiliate_log_debug("Using the affiliate specific 2nd tier commission for this referral. 2nd tier commission level: ".$second_tier_commission_level,true);
}
else{
$second_tier_commission_level = get_option('wp_aff_2nd_tier_commission_level');
wp_affiliate_log_debug("Using global 2nd tier commission for this referral. 2nd tier commission level: ".$second_tier_commission_level,true);
}
if (get_option('wp_aff_use_fixed_commission'))
{
                    $commission_amount = $second_tier_commission_level;
                }
                else
                {
   $commission_amount = round(($second_tier_commission_level * $sale_amount)/100,2);
                }
                $campaign_id = "";
                $is_tier_comm = "yes";
global $wpdb;
$aff_sales_table = WP_AFF_SALES_TBL_NAME;
$updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name,is_tier_comm) VALUES ('$wp_aff_affiliates_db->referrer','$clientdate','$clienttime','','','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$campaign_id','$buyer_name','$is_tier_comm')";
$results = $wpdb->query($updatedb); 
$aff_tx_msg .= '<br />Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount;
wp_affiliate_log_debug('Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount,true); 
} 
} 
return $aff_tx_msg;
}
This function added by me for 3rd tier but not working
 
function wp_aff_award_third_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name='')
{
global $aff_tx_msg;
    $clientdate = (date ("Y-m-d"));
$clienttime = (date ("H:i:s")); 


if (get_option('wp_aff_use_3tier') && !empty($wp_aff_affiliates_db->referrer))
{
$aff_tx_msg .= '<br />Using tier model';
wp_affiliate_log_debug("Using tier model",true);
$award_tier_commission = true; 
$duration = get_option('wp_aff_3rd_tier_duration'); 
if(!empty($duration))
{
$join_date = $wp_aff_affiliates_db->date;
$days_since_joined = round((strtotime(date("Y-m-d")) - strtotime($join_date) ) / (60 * 60 * 24));


if ($days_since_joined > $duration)
{
$aff_tx_msg .= '<br />Tier commission award duration expried';
wp_affiliate_log_debug("Tier commission award duration expried! No tier commission will be awarded for this sale.",true);
$award_tier_commission = false;
}
} 
if ($award_tier_commission)
{
{
$third_tier_commission_level = get_option('wp_aff_3rd_tier_commission_level');
wp_affiliate_log_debug("Using global 3rd tier commission for this referral. 3rd tier commission level: ".$third_tier_commission_level,true);
}
if (get_option('wp_aff_use_fixed_commission'))
{
                    $commission_amount = $third_tier_commission_level;
                }
                else
                {
   $commission_amount = round(($third_tier_commission_level * $sale_amount)/100,2);
                }
                $campaign_id = "";
                $is_tier_comm = "yes";
global $wpdb;
$aff_sales_table = WP_AFF_SALES_TBL_NAME;
$updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name,is_tier_comm) VALUES ('$wp_aff_affiliates_db->referrer','$clientdate','$clienttime','','','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$campaign_id','$buyer_name','$is_tier_comm')";
$results = $wpdb->query($updatedb); 
$aff_tx_msg .= '<br />Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount;
wp_affiliate_log_debug('Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount,true); 
} 
} 
return $aff_tx_msg;
}
 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
Please check and find me the solution
Edited by Ch0cu3r
Added code tags
Link to comment
Share on other sites
QuickOldCar Regular Member

QuickOldCar

Posted
Posted

I wrote what I did so maybe you would do things different, modify as you needed.

That's going to be a very large plugin by the time you get to 7 tiers, or even get them to work.

 

I don't see why you can't make the 3rd or any other tier after work similar as in the 2nd tier if that works using similar code.

 

Anyway, my suggestion would be to make everything into one function versus making each tier it's own function.

Link to comment
Share on other sites
  • 3 weeks later...
rajasekaran1965 Newbie

rajasekaran1965

Posted
  • Author
Posted (edited)

Hi

 

I need to modify the below code for multiple tiers. Currently it is working for second tier and i need it to extend up to seven tiers. I attached one file which is having function (function mga_create_tier_commissions($sale_id)) for multiple tiers and i need modify like that function in this below code. Please help me. mga_functions.php 

 

function wp_aff_award_second_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name='')
{
global $aff_tx_msg;


        if (get_option('wp_aff_use_2tier') && !empty($wp_aff_affiliates_db->referrer))
           {
                     $aff_tx_msg .= '<br />Using tier model';
                     wp_affiliate_log_debug("Using tier model",true);
                     $award_tier_commission = true; 
           } 
        if ($award_tier_commission)
           {
                    if(!empty($wp_aff_affiliates_db->sec_tier_commissionlevel)){
                    $second_tier_commission_level = $wp_aff_affiliates_db->sec_tier_commissionlevel;
                    wp_affiliate_log_debug("Using the affiliate specific 2nd tier commission for this referral. 2nd tier commission level:                                                       ".$second_tier_commission_level,true);
            }
      else{
                   $second_tier_commission_level = get_option('wp_aff_2nd_tier_commission_level');
                   wp_affiliate_log_debug("Using global 2nd tier commission for this referral. 2nd tier commission leve                                                                                 ".$second_tier_commission_level,true);
             }
      if (get_option('wp_aff_use_fixed_commission'))
             {
                    $commission_amount = $second_tier_commission_level;
             }
      else
             {
       $commission_amount = round(($second_tier_commission_level * $sale_amount)/100,2);
                }
                $campaign_id = "";
                $is_tier_comm = "yes";
                global $wpdb;
              $aff_sales_table = WP_AFF_SALES_TBL_NAME;
              $updatedb = "INSERT INTO $aff_sales_table                                                                                                                             (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name,is_tier_comm) VALUES ('$wp_aff_affiliates_db-                   >referrer','$clientdate','$clienttime','','','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$campaign_id','$buyer_name','$is_tier_comm')";
$results = $wpdb->query($updatedb); 
$aff_tx_msg .= '<br />Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount;
wp_affiliate_log_debug('Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount,true); 
} 
} 
return $aff_tx_msg;
}
Edited by Ch0cu3r
Link to comment
Share on other sites
QuickOldCar Regular Member

QuickOldCar

Posted
Posted (edited)

So the same issue as this post http://forums.phpfreaks.com/topic/291271-wordpress-plugin-help TOPIC MERGED

 

That's why I suggested a function to handle this better and not trying to duplicate mass amounts of code for additional tiers.

 

If my function is not exactly what you need modify or make one that does work for you.

Edited by Ch0cu3r
Link to comment
Share on other sites
rajasekaran1965 Newbie

rajasekaran1965

Posted
  • Author
Posted (edited)

So the same issue as this post http://forums.phpfreaks.com/topic/291271-wordpress-plugin-help TOPIC MERGED

 

That's why I suggested a function to handle this better and not trying to duplicate mass amounts of code for additional tiers.

 

If my function is not exactly what you need modify or make one that does work for you.

 Hi QuickOldCar

 

I am unable to modify the existing function.

 

Can u please modify the function "function wp_aff_award_second_tier_commission" in the attached file. I need to pay upline commissions for up to 7 levels(7tier). Right now it is paying only 2 levels (2 tier). Please help me. 

 

filewp_aff_includes.php

Edited by rajasekaran1965
Link to comment
Share on other sites
QuickOldCar Regular Member

QuickOldCar

Posted
Posted

I looked through the mga_functions.php and mga_create_tier_commissions()

function mga_create_tier_commissions($sale_id){

	global $wpdb;

	// tiers

	$tier_commissions = mga_get_setting('tier_commissions');	

	$tier_levels      = mga_get_setting('tier_levels');

	// affiliate

	$affiliate = $wpdb->get_row("SELECT * FROM ".TBL_SALES." WHERE `id`='{$sale_id}'");

	// parent 

	$parent_affiliate_id = $wpdb->get_var("SELECT DISTINCT(`parent_affiliate_id`) FROM ".TBL_AFFILITE_TIERS." WHERE `affiliate_id`='{$affiliate->affiliate_id}'");	

	// loop

	$level=1;

	$sub_affiliates=array();

	// loop

	while(intval($parent_affiliate_id)>0){

		// next level

		$level++;

		// gather all subs

		$sub_affiliates[$level]=$parent_affiliate_id;

		// parent 

		$parent_affiliate_id = $wpdb->get_var("SELECT `parent_affiliate_id` FROM ".TBL_AFFILITE_TIERS." WHERE `affiliate_id`='{$parent_affiliate_id}'");

		// break

		if($level==($tier_levels)) break; 

	}	

	

	// set price

	if(count($sub_affiliates)>0){

		$tier=2;

		foreach($sub_affiliates as $level=>$parent_affiliate_id){

			$commission_amount=($tier_commissions[$tier]/100)*$affiliate->totalprice;

			$columns =array('affiliate_id' => $parent_affiliate_id, 'click_id' => $affiliate->click_id, 'purchaseid' => $affiliate->purchaseid , 

			                'totalprice' => $affiliate->totalprice, 'commission_amount' => $commission_amount, 'sale_dt' => $affiliate->sale_dt, 

							'buyer_name' => $affiliate->buyer_name, 'buyer_email' => $affiliate->buyer_email, 'item_type' => 'sales' , 

							'item_id' => $affiliate->item_id, 'transaction_id' => $affiliate->transaction_id, 'pay_status' => $affiliate->pay_status);

			// insert

			$success=$wpdb->insert(TBL_SALES, $columns);

			$sale_id=$wpdb->insert_id;

			$tier++;	

			// mail when processed

			if($affiliate->pay_status=='processed'){

				// mail to affiliate

				mga_mail_notify_affiliate($sale_id);

				// mail to admin

				mga_mail_notify_admin($sale_id,'sale');

			}

		}

	}

}

From what I see these 2 lines are the only thing stopping the function from doing more levels and tiers

 

I assume this is a global plugins option

$tier_levels      = mga_get_setting('tier_levels');

then in the while loop

if($level==($tier_levels)) break;

What happens if comment out those 2 lines?

 

Or make more tier_levels options globally with many additional functions to match.

 

 

After that you still have all the checks looking for second_tier in wp_aff_award_second_tier_commission()

Link to comment
Share on other sites
rajasekaran1965 Newbie

rajasekaran1965

Posted
  • Author
Posted (edited)

I looked through the mga_functions.php and mga_create_tier_commissions()

function mga_create_tier_commissions($sale_id){

	global $wpdb;

	// tiers

	$tier_commissions = mga_get_setting('tier_commissions');	

	$tier_levels      = mga_get_setting('tier_levels');

	// affiliate

	$affiliate = $wpdb->get_row("SELECT * FROM ".TBL_SALES." WHERE `id`='{$sale_id}'");

	// parent 

	$parent_affiliate_id = $wpdb->get_var("SELECT DISTINCT(`parent_affiliate_id`) FROM ".TBL_AFFILITE_TIERS." WHERE `affiliate_id`='{$affiliate->affiliate_id}'");	

	// loop

	$level=1;

	$sub_affiliates=array();

	// loop

	while(intval($parent_affiliate_id)>0){

		// next level

		$level++;

		// gather all subs

		$sub_affiliates[$level]=$parent_affiliate_id;

		// parent 

		$parent_affiliate_id = $wpdb->get_var("SELECT `parent_affiliate_id` FROM ".TBL_AFFILITE_TIERS." WHERE `affiliate_id`='{$parent_affiliate_id}'");

		// break

		if($level==($tier_levels)) break; 

	}	

	

	// set price

	if(count($sub_affiliates)>0){

		$tier=2;

		foreach($sub_affiliates as $level=>$parent_affiliate_id){

			$commission_amount=($tier_commissions[$tier]/100)*$affiliate->totalprice;

			$columns =array('affiliate_id' => $parent_affiliate_id, 'click_id' => $affiliate->click_id, 'purchaseid' => $affiliate->purchaseid , 

			                'totalprice' => $affiliate->totalprice, 'commission_amount' => $commission_amount, 'sale_dt' => $affiliate->sale_dt, 

							'buyer_name' => $affiliate->buyer_name, 'buyer_email' => $affiliate->buyer_email, 'item_type' => 'sales' , 

							'item_id' => $affiliate->item_id, 'transaction_id' => $affiliate->transaction_id, 'pay_status' => $affiliate->pay_status);

			// insert

			$success=$wpdb->insert(TBL_SALES, $columns);

			$sale_id=$wpdb->insert_id;

			$tier++;	

			// mail when processed

			if($affiliate->pay_status=='processed'){

				// mail to affiliate

				mga_mail_notify_affiliate($sale_id);

				// mail to admin

				mga_mail_notify_admin($sale_id,'sale');

			}

		}

	}

}

From what I see these 2 lines are the only thing stopping the function from doing more levels and tiers

 

I assume this is a global plugins option

$tier_levels      = mga_get_setting('tier_levels');

then in the while loop

if($level==($tier_levels)) break;

What happens if comment out those 2 lines?

 

Or make more tier_levels options globally with many additional functions to match.

 

 

After that you still have all the checks looking for second_tier in wp_aff_award_second_tier_commission()

Hi

 

Thanks for your reply

 

File mga_functions.php is for reference purpose only and i am not using that.

 

I am using   wp_aff_includes.php only.

 

I modified the function wp_aff_award_second_tier_commission()  like below but not working. 

 

Just go through the modification and also please make the correction and help me please.

 

If you want i will send full set if files also.

function wp_aff_award_second_tier_commission($txn_id)
{
	global $wpdb;	
	
	// tiers	
	$is_tier_comm = get_option('wp_aff_use_2tier');
	//$tier_levels =  get_option('wp_aff_tier_levels');
	$tier_levels =  "7";
	$second_tier_commission_level = get_option('wp_aff_2nd_tier_commission_level');
	
	// parent referrer
	$parent_referrer = $wpdb->get_var("SELECT DISTINCT(`parent_referrer`) FROM $affiliates_tiers_table_name WHERE `referrer_id`='{$referrer->referrer_id}'");
	
	// loop
	$level = 1;

	$sub_affiliates=array();
	
	// loop
	while(intval($parent_referrer)>0){
	
	// next level
	$level++;
	
	// gather all subs
	$sub_affiliates[$level] = $parent_referrer;
	
	// parent 
	$parent_referrer = $wpdb->get_var("SELECT `parent_referrer` FROM $affiliates_tiers WHERE `referrer_id`='{$parent_referrer}'");
	
	// break
	if($level==($tier_levels)) break; 

	}
	
	// set price
	if(count($sub_affiliates)>0){

		$tier=2;

		foreach($sub_affiliates as $level=>$parent_referrer){
		
		$commission_amount = round(($second_tier_commission_level * $sale_amount)/100,2);
		
		$is_tier_comm = "yes";
		global $wpdb;
		$aff_sales_table = WP_AFF_SALES_TBL_NAME;
		$updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name,is_tier_comm) VALUES ('$wp_aff_affiliates_db->referrer','$clientdate','$clienttime','','','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$campaign_id','$buyer_name','$is_tier_comm')";
		$results = $wpdb->query($updatedb);	
		
	// insert
	$tier++;
	}	
}
}
Edited by rajasekaran1965
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.