<h2>File Contents: /home/planet5/www/4xpips.net/secure/application/aff/controllers/AdminCommissionController.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/4xpips.net/secure/application/aff/controllers/AdminCommissionController.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
// @todo : remove rules within UI

class Am_Grid_Action_AddTier extends Am_Grid_Action_Abstract
{
    protected $type = Am_Grid_Action_Abstract::NORECORD;
    protected $title = &#039;Add Tier&#039;;

    public function run()
    {
        $max_tier = $this-&gt;getDi()-&gt;affCommissionRuleTable-&gt;getMaxTier();
        $next_tier = ++$max_tier;

        $comm = $this-&gt;getDi()-&gt;affCommissionRuleRecord;
        $comm-&gt;tier = $next_tier;
        $comm-&gt;type = AffCommissionRule::TYPE_GLOBAL;
        $comm-&gt;sort_order = ($next_tier + 1) * 10000;
        $comm-&gt;comment = ($next_tier + 1) . &#039;-Tier Affiliates Commission&#039;;
        $comm-&gt;save();

        $this-&gt;grid-&gt;redirectBack();
    }
    /**
     *
     * @return Am_Di
     */
    protected function getDi()
    {
        return $this-&gt;grid-&gt;getDi();
    }
}

class Am_Grid_Action_RemoveLastTier extends Am_Grid_Action_Abstract
{
    protected $type = Am_Grid_Action_Abstract::NORECORD;
    protected $title = &#039;Remove Last Tier&#039;;

    public function run()
    {
        $max_tier = $this-&gt;getDi()-&gt;affCommissionRuleTable-&gt;getMaxTier();
        if ($max_tier) {
            $this-&gt;getDi()-&gt;affCommissionRuleTable-&gt;findFirstByTier($max_tier)-&gt;delete();
        }
        $this-&gt;grid-&gt;redirectBack();
    }
    /**
     *
     * @return Am_Di
     */
    protected function getDi()
    {
        return $this-&gt;grid-&gt;getDi();
    }
}

class Am_Grid_Action_TestAffCommissionRule extends Am_Grid_Action_Abstract
{
    protected $type = Am_Grid_Action_Abstract::NORECORD;
    protected $title = &#039;Test Rules&#039;;
    
    public function run()
    {
        $f = $this-&gt;createForm();
        echo &#039;&lt;h1&gt;&#039; . ___(&#039;Test Commission Rules&#039;) . &#039;&lt;/h1&gt;&#039;;
        if ($f-&gt;isSubmitted() &amp;&amp; $f-&gt;validate() &amp;&amp; $this-&gt;process($f-&gt;getValue())) 
            return;
        echo $f;
    }
    function process(array $vars)
    {
        $vars[&#039;user&#039;] = filterId($vars[&#039;user&#039;]);
        $vars[&#039;aff&#039;]  = filterId($vars[&#039;aff&#039;]);
        $user = Am_Di::getInstance()-&gt;userTable-&gt;findFirstByLogin($vars[&#039;user&#039;]);
        if (!$user)
            throw new Am_Exception_InputError(&quot;User {$vars[&#039;user&#039;]} not found&quot;);
        $aff  = Am_Di::getInstance()-&gt;userTable-&gt;findFirstByLogin($vars[&#039;aff&#039;]);
        if (!$aff)
            throw new Am_Exception_InputError(&quot;Affiliate {$vars[&#039;aff&#039;]} not found&quot;);
        /* @var $invoice Invoice */
        $invoice = Am_Di::getInstance()-&gt;invoiceTable-&gt;createRecord();
        $invoice-&gt;setUser($user);
        if ($vars[&#039;coupon&#039;]) {
            $invoice-&gt;setCouponCode($vars[&#039;coupon&#039;]);
            $error = $invoice-&gt;validateCoupon();
            if ($error) throw new Am_Exception_InputError($error);
        }
        $user-&gt;aff_id = $aff-&gt;pk();
        foreach (Am_Di::getInstance()-&gt;productTable-&gt;loadIds($vars[&#039;product_ids&#039;]) as $pr)
            $invoice-&gt;add($pr);
        $invoice-&gt;paysys_id = &#039;manual&#039;;
        $invoice-&gt;calculate();

        $invoice-&gt;invoice_id = &#039;00000&#039;;
        $invoice-&gt;public_id = &#039;TEST&#039;;
        $invoice-&gt;tm_added = sqlTime(&#039;now&#039;);

        echo &quot;&lt;pre&gt;&quot;;
        echo $invoice-&gt;render();
        echo
            &quot;\nBilling Terms: &quot; . $invoice-&gt;getTerms() . 
            &quot;\n&quot;.str_repeat(&quot;-&quot;, 70).&quot;\n&quot;;
        
        $helper = new Am_View_Helper_UserUrl();
        $helper-&gt;setView(new Am_View);
        printf(&quot;User Ordering the subscription: &lt;a target=&#039;_blank&#039; href=&#039;%s&#039;&gt;%d/%s &amp;quot;%s&amp;quot; &amp;lt;%s&amp;gt&lt;/a&gt;\n&quot;,
            $helper-&gt;userUrl($user-&gt;pk()),
            $user-&gt;pk(), Am_Controller::escape($user-&gt;login), 
            Am_Controller::escape($user-&gt;name_f . &#039; &#039; . $user-&gt;name_l),
            Am_Controller::escape($user-&gt;email));
        printf(&quot;Reffered Affiliate: &lt;a target=&#039;_blank&#039; href=&#039;%s&#039;&gt;%d/%s &amp;quot;%s&amp;quot; &amp;lt;%s&amp;gt&lt;/a&gt;\n&quot;,
            $helper-&gt;userUrl($aff-&gt;pk()),
            $aff-&gt;pk(), 
            Am_Controller::escape($aff-&gt;login), 
            Am_Controller::escape($aff-&gt;name_f . &#039; &#039; . $aff-&gt;name_l),
            Am_Controller::escape($aff-&gt;email));
        
        //COMMISSION FOR FREE SIGNUP
        if (!(float)$invoice-&gt;first_total
            &amp;&amp; !(float)$invoice-&gt;second_total
            &amp;&amp; $vars[&#039;is_first&#039;]) {

            echo &quot;\n&lt;strong&gt;FREE SIGNUP&lt;/strong&gt;:\n&quot;;
            list($item,) = $invoice-&gt;getItems();

            echo sprintf(&quot;* ITEM: %s\n&quot;, Am_Controller::escape($item-&gt;item_title));
            foreach (Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;findRules($invoice, $item, $aff, 0, 0) as $rule)
            {
                echo $rule-&gt;render(&#039;*   &#039;);
            }
            echo &quot;* AFFILIATE WILL GET FOR THIS ITEM: &quot; . Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;calculate($invoice, $item, $aff, 0, 0) . &quot; $invoice-&gt;currency \n&quot;;
            echo &quot;* &quot; . str_repeat(&quot;-&quot;, 70) . &quot;\n&quot;;
        }

        //COMMISSION FOR FIRST PAYMENT
        $price_field = (float)$invoice-&gt;first_total ? &#039;first_total&#039; : &#039;second_total&#039;;
        if ((float)($invoice-&gt;$price_field)) {
            echo &quot;\n&lt;strong&gt;FIRST PAYMENT ($invoice-&gt;currency {$invoice-&gt;$price_field})&lt;/strong&gt;:\n&quot;;

            $payment = Am_Di::getInstance()-&gt;invoicePaymentTable-&gt;createRecord();
            $payment-&gt;invoice_id = @$invoice-&gt;invoice_id;
            $payment-&gt;dattm = sqlTime(&#039;now&#039;);
            $payment-&gt;amount = $invoice-&gt;$price_field;
            echo str_repeat(&quot;-&quot;, 70) . &quot;\n&quot;;
            foreach ($invoice-&gt;getItems() as $item)
            {
                if (!(float)($item-&gt;$price_field)) continue; //do not calculate commission for free items within invoice
                echo sprintf(&quot;* ITEM: %s ($invoice-&gt;currency {$item-&gt;$price_field})\n&quot;, Am_Controller::escape($item-&gt;item_title));
                foreach (Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;findRules($invoice, $item, $aff, 1, 0, $payment-&gt;dattm) as $rule)
                {
                    echo $rule-&gt;render(&#039;*   &#039;);
                }
                echo &quot;* AFFILIATE WILL GET FOR THIS ITEM: &quot; . Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;calculate($invoice, $item, $aff, 1, 0, $payment-&gt;amount, $payment-&gt;dattm) . &quot; $invoice-&gt;currency \n&quot;;
                echo &quot;* &quot; . str_repeat(&quot;-&quot;, 70) . &quot;\n&quot;;
            }
        }
        //COMMISSION FOR SECOND AND SUBSEQUENT PAYMENTS
        if ($invoice-&gt;second_total)
        {
            echo &quot;\n&lt;strong&gt;SECOND AND SUBSEQUENT PAYMENTS ($invoice-&gt;second_total $invoice-&gt;currency)&lt;/strong&gt;:\n&quot;;
            $payment = Am_Di::getInstance()-&gt;invoicePaymentTable-&gt;createRecord();
            $payment-&gt;invoice_id = @$invoice-&gt;invoice_id;
            $payment-&gt;dattm = sqlTime(&#039;now&#039;);
            $payment-&gt;amount = $invoice-&gt;second_total;
            echo str_repeat(&quot;-&quot;, 70) . &quot;\n&quot;;
            foreach ($invoice-&gt;getItems() as $item)
            {
                if (!(float)$item-&gt;second_total) continue; //do not calculate commission for free items within invoice
                echo sprintf(&quot;* ITEM:  %s ($item-&gt;second_total $invoice-&gt;currency)\n&quot;, Am_Controller::escape($item-&gt;item_title));
                foreach (Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;findRules($invoice, $item, $aff, 2, 0, $payment-&gt;dattm) as $rule)
                { 
                    echo $rule-&gt;render(&#039;*   &#039;);
                }
                echo &quot;* AFFILIATE WILL GET FOR THIS ITEM: &quot; . 
                    Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;calculate($invoice, $item, $aff, 2, 0, $payment-&gt;amount, $payment-&gt;dattm).
                    &quot; $invoice-&gt;currency \n&quot;;
                echo &quot;* &quot; . str_repeat(&quot;-&quot;, 70) . &quot;\n&quot;;
            }
        }
        echo &quot;&lt;/pre&gt;&quot;;
        return true;
    }
    protected function createForm()
    {
        $f = new Am_Form_Admin;
        $f-&gt;addText(&#039;user&#039;)-&gt;setLabel(&#039;Enter username of existing user&#039;)
            -&gt;addRule(&#039;required&#039;, &#039;This field is required&#039;);
        $f-&gt;addText(&#039;aff&#039;)-&gt;setLabel(&#039;Enter username of existing affiliate&#039;)
            -&gt;addRule(&#039;required&#039;, &#039;This field is required&#039;);
        $f-&gt;addText(&#039;coupon&#039;)-&gt;setLabel(&#039;Enter coupon code or leave field empty&#039;);
        $f-&gt;addCheckbox(&#039;is_first&#039;)-&gt;setLabel(&#039;Is first user invoice?&#039;);
        $f-&gt;addMagicSelect(&#039;product_ids&#039;)-&gt;setLabel(&#039;Choose products to include into test invoice&#039;)
                -&gt;loadOptions(Am_Di::getInstance()-&gt;productTable-&gt;getOptions())
                -&gt;addRule(&#039;required&#039;, &#039;This field is required&#039;);
        $f-&gt;addSubmit(&#039;&#039;, array(&#039;value&#039; =&gt; &#039;Test&#039;));
        $f-&gt;addScript()-&gt;setScript(&lt;&lt;&lt;CUT
$(function(){
    $(&quot;#user-0, #aff-0&quot; ).autocomplete({
        minLength: 2,
        source: window.rootUrl + &quot;/admin-users/autocomplete&quot;
    });
});            
CUT
        );
        foreach ($this-&gt;grid-&gt;getVariablesList() as $k)
        {
            $kk = $this-&gt;grid-&gt;getId() . &#039;_&#039; . $k;
            if ($v = @$_REQUEST[$kk])
                $f-&gt;addHidden($kk)-&gt;setValue($v);
        }
        return $f;
    }
}

class Am_Grid_Editable_AffCommissionRule extends Am_Grid_Editable 
{
    protected $permissionId = &#039;affiliates&#039;;
    public function renderTable()
    {
        $root = REL_ROOT_URL;
        return parent::renderTable() . 
            &lt;&lt;&lt;CUT
&lt;div class=&#039;comment&#039;&gt;
For each item in purchase, aMember will look through all rules, from top to bottom.
If it finds a matching multiplier, it will be remembered.
If it finds a matching custom rule, it takes commission rates from it.
If no matching custom rule was found, it uses &quot;Default&quot; commission settings.

For n-tier affiliates, no rules are used, you can just define percentage.
&lt;/div&gt;

&lt;p&gt;&lt;br /&gt;
&lt;a target=&#039;_top&#039; href=&#039;$root/admin-setup/aff&#039;&gt;Check other Affiliate Program Settings&lt;/a&gt;
&lt;/p&gt;
CUT;
    }
    public function __construct(Am_Request $request, Am_View $view)
    {
        parent::__construct(&#039;_affcommconf&#039;, 
            &#039;Affiliate Commission Config&#039;, Am_Di::getInstance()-&gt;affCommissionRuleTable-&gt;createQuery(),
            $request, $view);
        
        $this-&gt;setRecordTitle(&#039;Commission Rule&#039;);
        $this-&gt;addField(&#039;comment&#039;, &#039;Comment&#039;)-&gt;setRenderFunction(array($this, &#039;renderComment&#039;));
        $this-&gt;addField(&#039;sort_order&#039;, &#039;Sort&#039;)-&gt;setRenderFunction(array($this, &#039;renderSort&#039;));
        $this-&gt;addField(&#039;_commission&#039;, &#039;Commission&#039;, false)-&gt;setRenderFunction(array($this, &#039;renderCommission&#039;));
        $this-&gt;addField(&#039;_conditions&#039;, &#039;Conditions&#039;, false)-&gt;setRenderFunction(array($this, &#039;renderConditions&#039;));
        
        $this-&gt;actionGet(&#039;edit&#039;)-&gt;setTarget(&#039;_top&#039;);
        $this-&gt;actionGet(&#039;insert&#039;)-&gt;setTitle(&#039;New Custom %s&#039;)-&gt;setTarget(&#039;_top&#039;);
        $this-&gt;actionAdd(new Am_Grid_Action_AddTier());
        if ($this-&gt;getDi()-&gt;affCommissionRuleTable-&gt;getMaxTier()) {
            $this-&gt;actionAdd(new Am_Grid_Action_RemoveLastTier());
        }
        $this-&gt;actionAdd(new Am_Grid_Action_TestAffCommissionRule());
        
        $this-&gt;setForm(array($this,&#039;createConfigForm&#039;));
        $this-&gt;addCallback(Am_Grid_Editable::CB_VALUES_TO_FORM, array($this, &#039;_valuesToForm&#039;));
        $this-&gt;addCallback(Am_Grid_Editable::CB_VALUES_FROM_FORM, array($this, &#039;_valuesFromForm&#039;));
    }
    public function renderSort(AffCommissionRule $rule)
    {
        $v = $rule-&gt;isGlobal() ? &#039;-&#039; : $rule-&gt;sort_order;
        return $this-&gt;renderTd($v);
    }
    public function renderCommission(AffCommissionRule $rule, $fieldName)
    {
        return $this-&gt;renderTd($rule-&gt;renderCommission(), false);
    }
    public function renderConditions(AffCommissionRule $rule, $fieldName)
    {
        return $this-&gt;renderTd($rule-&gt;renderConditions(), true);
    }
    public function renderComment(AffCommissionRule $rule)
    {
        if ($rule-&gt;isGlobal()) 
            $text = &#039;&lt;strong&gt;&#039;.$rule-&gt;comment.&#039;&lt;/strong&gt;&#039;;
        else
            $text = $this-&gt;escape($rule-&gt;comment);
        return &quot;&lt;td&gt;$text&lt;/td&gt;\n&quot;;
    }
    public function _valuesToForm(&amp; $values, AffCommissionRule $record)
    {
        $values[&#039;_conditions&#039;] = json_decode(@$values[&#039;conditions&#039;], true);
        foreach ((array)$values[&#039;_conditions&#039;] as $k =&gt; $v) {
            $values[&#039;_conditions_status&#039;][$k] = 1; //enabled
        }
    }
    public function _valuesFromForm(&amp; $values, AffCommissionRule $record)
    {
        $values[&#039;free_signup_t&#039;] = &#039;$&#039;;
        $conditions = array();
        foreach ($values[&#039;_conditions_status&#039;] as $k =&gt; $v) {
            if ($v) {
                $conditions[$k] = $values[&#039;_conditions&#039;][$k];
            }
        }
        $this-&gt;cleanUpConditions($conditions);
        if (!empty($conditions)) {
            $values[&#039;conditions&#039;] = json_encode($conditions);
        }
    }

    /**
     * Remove incomplete conditions
     *
     * @param array $conditions
     */
    protected function cleanUpConditions(&amp; $conditions)
    {
        foreach ($conditions as $type =&gt; $vars) {
            switch ($type) {
                case AffCommissionRule::COND_PRODUCT_ID :
                case AffCommissionRule::COND_PRODUCT_CATEGORY_ID :
                    if (empty($vars)) unset($conditions[$type]);
                    break;
                case AffCommissionRule::COND_AFF_SALES_AMOUNT:
                case AffCommissionRule::COND_AFF_SALES_COUNT:
                    if (empty($vars[&#039;count&#039;]) || empty($vars[&#039;days&#039;]))
                        unset($conditions[$type]);
                    break;
                case AffCommissionRule::COND_COUPON :
                    if (($vars[&#039;type&#039;] == &#039;batch&#039; &amp;&amp; !$vars[&#039;batch_id&#039;])
                        || ($vars[&#039;type&#039;] == &#039;coupon&#039; &amp;&amp; !$vars[&#039;code&#039;]))
                        unset($conditions[$type]);
                    break;
            }
        }
    }

    public function createConfigForm(Am_Grid_Editable $grid)
    {
        $form = new Am_Form_Admin;
        
        $record = $grid-&gt;getRecord($grid-&gt;getCurrentAction());
        
        if (empty($record-&gt;type)) $record-&gt;type = null;
        if (empty($record-&gt;tier)) $record-&gt;tier = 0;
        
        $globalOptions = AffCommissionRule::getTypes();
        ($record-&gt;type &amp;&amp; !isset($globalOptions[$record-&gt;type])) &amp;&amp; $globalOptions[$record-&gt;type] = $record-&gt;getTypeTitle();

        $cb = $form-&gt;addSelect(&#039;type&#039;)-&gt;setLabel(&#039;Type&#039;)-&gt;loadOptions($globalOptions);
        if ($record-&gt;isGlobal())
            $cb-&gt;toggleFrozen(true);
        
        $form-&gt;addScript()-&gt;setScript(&lt;&lt;&lt;CUT
$(function(){
    $(&quot;select#type-0&quot;).change(function(){
        var val = $(this).val();
        $(&quot;fieldset#multiplier&quot;).toggle(val == &#039;multi&#039;);
        $(&quot;fieldset#commission&quot;).toggle(val != &#039;multi&#039;);
        var checked = val.match(/^global-/);
        $(&quot;#conditions&quot;).toggle(!checked);
        $(&quot;#sort_order-0&quot;).closest(&quot;.row&quot;).toggle(!checked);
    }).change();
    
    $(&quot;#condition-select&quot;).change(function(){
        var val = $(this).val();
        $(this.options[this.selectedIndex]).prop(&quot;disabled&quot;, true);
        this.selectedIndex = 0;
        $(&#039;input[name=&quot;_conditions_status[&#039; + val + &#039;]&quot;]&#039;).val(1);
        $(&#039;#row-&#039;+val).show();
    });

    $(&quot;#conditions .row&quot;).not(&quot;#row-condition-select&quot;).each(function(){
        var val = /row-(.*)/i.exec(this.id).pop();
        if (!$(&#039;input[name=&quot;_conditions_status[&#039; + val + &#039;]&quot;]&#039;).val()) {
            $(this).hide();
        } else {
            $(&quot;#condition-select option[value=&#039;&quot;+val+&quot;&#039;]&quot;).prop(&quot;disabled&quot;, true);
        }
        $(this).find(&quot;.element-title&quot;).append(&quot;&amp;nbsp;&lt;a href=&#039;javascript:&#039; class=&#039;hide-row&#039;&gt;X&lt;/a&gt;&amp;nbsp;&quot;);
    });

    $(&quot;a.hide-row&quot;).live(&#039;click&#039;,function(){
        var row = $(this).closest(&quot;.row&quot;);
        var id = row.hide().attr(&quot;id&quot;);
        var val = /row-(.*)/i.exec(id).pop();
        $(&#039;input[name=&quot;_conditions_status[&#039; + val + &#039;]&quot;]&#039;).val(0);
        $(&quot;#condition-select option[value=&#039;&quot;+val+&quot;&#039;]&quot;).prop(&quot;disabled&quot;, false);
    });

    $(&#039;#used-type&#039;).change(function(){
        $(&#039;#used-batch_id, #used-code&#039;).hide();
        switch ($(this).val()) {
            case &#039;batch&#039; :
                $(&#039;#used-batch_id&#039;).show();
                break;
            case &#039;coupon&#039; :
                $(&#039;#used-code&#039;).show();
                break;
        }

    }).change()
});
CUT
);
        
        $comment = $form-&gt;addText(&#039;comment&#039;, array(&#039;size&#039; =&gt; 40))
            -&gt;setLabel(&#039;Rule title - for your own reference&#039;);
        if ($record-&gt;isGlobal()) {
            $comment-&gt;toggleFrozen(true);
        } else {
            $comment-&gt;addRule(&#039;required&#039;, &#039;This field is required&#039;);
        }

        if (!$record-&gt;isGlobal())
            $form-&gt;addInteger(&#039;sort_order&#039;)
                -&gt;setLabel(&#039;Sort order - rules with lesser values executed first&#039;);

        if (!$record-&gt;isGlobal()) // add conditions
        {
            $set = $form-&gt;addFieldset(&#039;&#039;, array(&#039;id&#039;=&gt;&#039;conditions&#039;))-&gt;setLabel(&#039;Conditions&#039;);
            $set-&gt;addSelect(&#039;&#039;, array(&#039;id&#039; =&gt; &#039;condition-select&#039;))-&gt;setLabel(&#039;Add Condition&#039;)-&gt;loadOptions(array(
                &#039;&#039; =&gt; &#039;Select Condition...&#039;,
                &#039;product_id&#039; =&gt; &#039;By Product&#039;,
                &#039;product_category_id&#039; =&gt; &#039;By Product Category&#039;,
                &#039;aff_group_id&#039; =&gt; &#039;By Affiliate Group Id&#039;,
                &#039;aff_sales_count&#039; =&gt; &#039;By Affiliate Sales Count&#039;,
                &#039;aff_sales_amount&#039; =&gt; &#039;By Affiliate Sales Amount&#039;,
                &#039;coupon&#039; =&gt; &#039;By Used Coupon&#039;
            ));

            $set-&gt;addHidden(&#039;_conditions_status[product_id]&#039;);

            $set-&gt;addMagicSelect(&#039;_conditions[product_id]&#039;, array(&#039;id&#039; =&gt; &#039;product_id&#039;))
                -&gt;setLabel(array(&#039;This rule is for particular products&#039;, 
                    &#039;if none specified, rule works for all products&#039;))
               -&gt;loadOptions(Am_Di::getInstance()-&gt;productTable-&gt;getOptions());

            $set-&gt;addHidden(&#039;_conditions_status[product_category_id]&#039;);

            $el = $set-&gt;addMagicSelect(&#039;_conditions[product_category_id]&#039;, array(&#039;id&#039; =&gt; &#039;product_category_id&#039;))
                -&gt;setLabel(array(&#039;This rule is for particular product categories&#039;, 
                    &#039;if none specified, rule works for all product categories&#039;));
            $el-&gt;loadOptions(Am_Di::getInstance()-&gt;productCategoryTable-&gt;getAdminSelectOptions());

            $set-&gt;addHidden(&#039;_conditions_status[aff_group_id]&#039;);

            $el = $set-&gt;addMagicSelect(&#039;_conditions[aff_group_id]&#039;, array(&#039;id&#039; =&gt; &#039;aff_group_id&#039;))
                -&gt;setLabel(array(&#039;This rule is for particular affiliate groups&#039;, 
                    &#039;you can add user groups and assign it to customers in User editing form&#039;));
            $el-&gt;loadOptions(Am_Di::getInstance()-&gt;userGroupTable-&gt;getSelectOptions());

            $set-&gt;addHidden(&#039;_conditions_status[aff_sales_count]&#039;);

            $gr = $set-&gt;addGroup(&#039;_conditions[aff_sales_count]&#039;, array(&#039;id&#039; =&gt; &#039;aff_sales_count&#039;))
                -&gt;setLabel(array(&#039;Affiliate sales count&#039;, 
                &#039;trigger this commission if affiliate made more than ... sales within ... days before the current date&#039; . PHP_EOL .
                &#039;(recurring: affiliate sales count will be recalculated on each rebill)&#039;
                ));
            $gr-&gt;addStatic()-&gt;setContent(&#039;use only if affiliate made &#039;);
            $gr-&gt;addInteger(&#039;count&#039;, array(&#039;size&#039;=&gt;4));
            $gr-&gt;addStatic()-&gt;setContent(&#039; commissions within last &#039;);
            $gr-&gt;addInteger(&#039;days&#039;, array(&#039;size&#039;=&gt;4));
            $gr-&gt;addStatic()-&gt;setContent(&#039; days&#039;);

            $set-&gt;addHidden(&#039;_conditions_status[aff_sales_amount]&#039;);

            $gr = $set-&gt;addGroup(&#039;_conditions[aff_sales_amount]&#039;, array(&#039;id&#039; =&gt; &#039;aff_sales_amount&#039;))
                -&gt;setLabel(array(&#039;Affiliate sales amount&#039;, 
                &#039;trigger this commission if affiliate made more than ... sales within ... days before the current date&#039; . PHP_EOL .
                &#039;(recurring: affiliate sales count will be recalculated on each rebill)&#039;
                ));
            $gr-&gt;addStatic()-&gt;setContent(&#039;use only if affiliate made &#039;);
            $gr-&gt;addInteger(&#039;count&#039;, array(&#039;size&#039;=&gt;4));
            $gr-&gt;addStatic()-&gt;setContent(&#039; &#039; .Am_Currency::getDefault(). &#039; in commissions within last &#039;);
            $gr-&gt;addInteger(&#039;days&#039;, array(&#039;size&#039;=&gt;4));
            $gr-&gt;addStatic()-&gt;setContent(&#039; days&#039;);

            $set-&gt;addHidden(&#039;_conditions_status[coupon]&#039;);

            $gr = $set-&gt;addGroup(&#039;_conditions[coupon]&#039;, array(&#039;id&#039; =&gt; &#039;coupon&#039;))
                -&gt;setLabel(array(&#039;Used coupon&#039;));
            $gr-&gt;addSelect(&#039;used&#039;)
                -&gt;loadOptions(array(
                   &#039;1&#039; =&gt; &#039;Used&#039;,
                   &#039;0&#039; =&gt; &quot;Didn&#039;t Use&quot;
                ));
            $gr-&gt;addSelect(&#039;type&#039;)
                -&gt;setId(&#039;used-type&#039;)
                -&gt;loadOptions(array(
                   &#039;any&#039; =&gt; &#039;Any Coupon&#039;,
                   &#039;batch&#039; =&gt; &quot;Coupon From Batch&quot;,
                   &#039;coupon&#039; =&gt; &quot;Specific Coupon&quot;
                ));
            $gr-&gt;addSelect(&#039;batch_id&#039;)
                -&gt;setId(&#039;used-batch_id&#039;)
                -&gt;loadOptions(
                $this-&gt;getDi()-&gt;couponBatchTable-&gt;getOptions()
            );
            $gr-&gt;addText(&#039;code&#039;, array(&#039;size&#039;=&gt;10))
                -&gt;setId(&#039;used-code&#039;);
            
            
        }

        $set = $form-&gt;addFieldset(&#039;&#039;, array(&#039;id&#039; =&gt; &#039;commission&#039;))-&gt;setLabel(&#039;Commission&#039;);
        
        if ($record-&gt;tier == 0)
        {
            $set-&gt;addElement(new Am_Form_Element_AffCommissionSize(null, null, &#039;first_payment&#039;))
                -&gt;setLabel(___(&quot;Commission for First Payment\ncalculated for first payment in each invoice&quot;));
            $set-&gt;addElement(new Am_Form_Element_AffCommissionSize(null, null, &#039;recurring&#039;))
                -&gt;setLabel(___(&quot;Commission for Rebills&quot;));
            $group = $set-&gt;addGroup(&#039;&#039;)
                -&gt;setLabel(___(&quot;Commission for Free Signup\ncalculated for first customer invoice only&quot;));
            $group-&gt;addText(&#039;free_signup_c&#039;, array(&#039;size&#039;=&gt;5));
            $group-&gt;addStatic()-&gt;setContent(&#039;&amp;nbsp;&amp;nbsp;&#039; . Am_Currency::getDefault());
                ;//-&gt;addRule(&#039;gte&#039;, &#039;Value must be a valid number &gt; 0, or empty (no text)&#039;, 0);
        } else {
            $set-&gt;addText(&#039;first_payment_c&#039;)
                -&gt;setLabel(___(&quot;Commission\n% of commission received by referred affiliate&quot;));
        }
        if (!$record-&gt;isGlobal())
        {
            $set = $form-&gt;addFieldset(&#039;&#039;, array(&#039;id&#039; =&gt; &#039;multiplier&#039;))-&gt;setLabel(&#039;Multipier&#039;);
            $set-&gt;addText(&#039;multi&#039;, array(&#039;size&#039; =&gt; 5, &#039;placeholder&#039; =&gt; &#039;1.0&#039;))
                -&gt;setLabel(array(___(&quot;Multiply commission calculated by the following rules
                    to number specified in this field. To keep commission untouched, enter 1 or delete this rule&quot;)))
                ;//-&gt;addRule(&#039;gt&#039;, &#039;Values must be greater than 0.0&#039;, 0.0);
        }
        return $form;
    }
}

class Aff_AdminCommissionController extends Am_Controller_Pages
{
    public function initPages()
    {
        $this-&gt;addPage(array($this, &#039;createGrid&#039;), &#039;grid&#039;, ___(&#039;Commissions&#039;));
        $this-&gt;addPage(array($this, &#039;createClicksGrid&#039;), &#039;clicks&#039;, ___(&#039;Clicks&#039;));
        $this-&gt;addPage(array($this, &#039;createLeadsGrid&#039;), &#039;leads&#039;, ___(&#039;Leads&#039;));
        $this-&gt;addPage(&#039;Am_Grid_Editable_AffCommissionRule&#039;, &#039;config&#039;, ___(&#039;Commission Configuration&#039;));
    }
    
    public function createGrid()
    {
        $ds = new Am_Query($this-&gt;getDi()-&gt;affCommissionTable);
        $ds-&gt;leftJoin(&#039;?_invoice&#039;, &#039;i&#039;, &#039;i.invoice_id=t.invoice_id&#039;);
        $ds-&gt;leftJoin(&#039;?_user&#039;, &#039;u&#039;, &#039;u.user_id=i.user_id&#039;);
        $ds-&gt;leftJoin(&#039;?_user&#039;, &#039;a&#039;, &#039;t.aff_id=a.user_id&#039;);
        $ds-&gt;leftJoin(&#039;?_product&#039;, &#039;p&#039;, &#039;t.product_id=p.product_id&#039;);
        $ds-&gt;addField(&#039;CONCAT(a.name_f, \&#039; \&#039;, a.name_l,\&#039; [#\&#039;, a.user_id, \&#039;] \&#039;)&#039;, &#039;aff_name&#039;)
           -&gt;addField(&#039;u.user_id&#039;, &#039;user_id&#039;)
           -&gt;addField(&#039;CONCAT(u.name_f, \&#039; \&#039;,u.name_l,\&#039; [#\&#039;, u.user_id, \&#039;] \&#039;)&#039;, &#039;user_name&#039;)
           -&gt;addField(&#039;u.email&#039;, &#039;user_email&#039;)
           -&gt;addField(&#039;p.title&#039;, &#039;product_title&#039;)
           -&gt;addField(&#039;IF(payout_detail_id IS NULL, \&#039;no\&#039;, \&#039;yes\&#039;)&#039;, &#039;is_paid&#039;);
        $ds-&gt;setOrder(&#039;commission_id&#039;, &#039;desc&#039;);
        
        $grid = new Am_Grid_ReadOnly(&#039;_affcomm&#039;, ___(&quot;Affiliate Commission&quot;), $ds, $this-&gt;_request, $this-&gt;view);
        $grid-&gt;setPermissionId(&#039;affiliates&#039;);
        
        $userUrl = new Am_View_Helper_UserUrl();
        $grid-&gt;addField(new Am_Grid_Field_Date(&#039;date&#039;, ___(&#039;Date&#039;)))-&gt;setFormatDate();
        $grid-&gt;addField(&#039;aff_name&#039;, ___(&#039;Affiliate&#039;))
            -&gt;addDecorator(new Am_Grid_Field_Decorator_Link($userUrl-&gt;userUrl(&#039;{aff_id}&#039;), &#039;_blank&#039;));
        $grid-&gt;addField(&#039;user_name&#039;, ___(&#039;User&#039;))
            -&gt;addDecorator(new Am_Grid_Field_Decorator_Link($userUrl-&gt;userUrl(&#039;{user_id}&#039;), &#039;_blank&#039;));
        $grid-&gt;addField(&#039;product_title&#039;, ___(&#039;Product&#039;));
        $grid-&gt;addField(&#039;record_type&#039;, ___(&#039;Type&#039;));
        $grid-&gt;addField(&#039;amount&#039;, ___(&#039;Commission&#039;));
        $grid-&gt;addField(&#039;is_paid&#039;, ___(&#039;Paid&#039;));
        $grid-&gt;addField(&#039;tier&#039;, ___(&#039;Tier&#039;));
        return $grid;
    }
    public function createClicksGrid()
    {
        $ds = new Am_Query($this-&gt;getDi()-&gt;affClickTable);

        $ds-&gt;leftJoin(&#039;?_user&#039;, &#039;a&#039;, &#039;t.aff_id=a.user_id&#039;);
        $ds-&gt;addField(&#039;CONCAT(a.name_f, \&#039; \&#039;, a.name_l)&#039;, &#039;aff_name&#039;);

        $ds-&gt;leftJoin(&#039;?_aff_banner&#039;, &#039;b&#039;, &#039;t.banner_id=b.banner_id&#039;);
        $ds-&gt;addField(&#039;b.title&#039;, &#039;banner&#039;);
        
        $grid = new Am_Grid_ReadOnly(&#039;_affclicks&#039;, ___(&quot;Clicks&quot;), $ds, $this-&gt;_request, $this-&gt;view);
        $grid-&gt;setPermissionId(&#039;affiliates&#039;);
        $userUrl = new Am_View_Helper_UserUrl();
        $grid-&gt;addField(&#039;time&#039;, ___(&#039;Time&#039;))-&gt;setFormatFunction(&#039;amDateTime&#039;);
        $grid-&gt;addField(&#039;remote_addr&#039;, ___(&#039;IP Address&#039;));
        $grid-&gt;addField(&#039;banner&#039;, &#039;Banner&#039;);
        $grid-&gt;addField(new Am_Grid_Field_Expandable(&#039;referer&#039;, ___(&#039;Referer&#039;)));
        
        $grid
            -&gt;addField(&#039;aff_name&#039;, ___(&#039;Affiliate&#039;))
            -&gt;addDecorator(new Am_Grid_Field_Decorator_Link($userUrl-&gt;userUrl(&#039;{aff_id}&#039;), &#039;_blank&#039;));
        
        return $grid;
    }
    public function createLeadsGrid()
    {
        $ds = new Am_Query($this-&gt;getDi()-&gt;affLeadTable);
        $ds-&gt;leftJoin(&#039;?_user&#039;, &#039;a&#039;, &#039;t.aff_id=a.user_id&#039;);
        $ds-&gt;addField(&#039;CONCAT(a.name_f, \&#039; \&#039;, a.name_l)&#039;, &#039;aff_name&#039;);

        $ds-&gt;leftJoin(&#039;?_aff_banner&#039;, &#039;b&#039;, &#039;t.banner_id=b.banner_id&#039;);
        $ds-&gt;addField(&#039;b.title&#039;, &#039;banner&#039;);
        
        $ds-&gt;leftJoin(&#039;?_user&#039;, &#039;u&#039;, &#039;u.user_id=t.user_id&#039;);
        $ds-&gt;addField(&#039;CONCAT(u.name_f, \&#039; \&#039;,u.name_l)&#039;, &#039;user_name&#039;)
            -&gt;addField(&#039;u.email&#039;, &#039;user_email&#039;);
        
        $grid = new Am_Grid_ReadOnly(&#039;_affclicks&#039;, ___(&quot;Leads&quot;), $ds, $this-&gt;_request, $this-&gt;view);
        $grid-&gt;setPermissionId(&#039;affiliates&#039;);
        
        $userUrl = new Am_View_Helper_UserUrl();
        $grid-&gt;addField(&#039;aff_name&#039;, ___(&#039;Affiliate&#039;))
            -&gt;addDecorator(new Am_Grid_Field_Decorator_Link($userUrl-&gt;userUrl(&#039;{aff_id}&#039;), &#039;_blank&#039;));
        $grid-&gt;addField(&#039;user_name&#039;, ___(&#039;User&#039;))
            -&gt;addDecorator(new Am_Grid_Field_Decorator_Link($userUrl-&gt;userUrl(&#039;{user_id}&#039;), &#039;_blank&#039;));
        $grid-&gt;addField(&#039;banner&#039;, ___(&#039;Banner&#039;));
        $grid-&gt;addField(&#039;time&#039;, ___(&#039;Time&#039;))-&gt;setFormatFunction(&#039;amDateTime&#039;);
        $grid-&gt;addField(&#039;first_visited&#039;, ___(&#039;First visited&#039;))-&gt;setFormatFunction(&#039;amDateTime&#039;);
        return $grid;
    }
    public function checkAdminPermissions(Admin $admin)
    {
        return $admin-&gt;hasPermission(&#039;affiliates&#039;);
    }
}

</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2F4xpips.net%2Fsecure%2Fapplication%2Faff%2Fcontrollers'>⬅ Back to Directory</a>