What kind of upgrade?

In crossplan you can set up to subtract price of already purchased subscription from current one. The parameters group is called Price affect.

Unfortunately there is no update option that would recalculate how many days was used and how much in particualr user have to pay for new plan.

Hi, with "upgrade" I mean from Basic to Pro, so Pro price needs to be reduced from the unused amount of the Basic plan.

Example: - User subscribes Basic Plan (during 1 year) - After 6 months the user wants to upgrade to Pro plan - I need to discount 6 month of unused amount of Basic to upgrade Pro Plan

Unfortunately there is no update option that would recalculate how many days was used and how much in particualr user have to pay for new plan.

Some workaround? can you point me on right way to develop some plugin to do this?

fdesanto Some workaround? can you point me on right way to develop some plugin to do this?

The only way is for me to finaly finish this option in cross plan. It is already there. Let me see what i can do.

Great Thanks.

Sergey It is already there. Let me see what i can do.

+1 ;)

Hi, sorry for multiple posts, here a complete code to calculate unutilized amount of previous plans, this works with your parameters into "Cross Plan" section (also with parameter Price recalculation step in days).

You can copy this code in file /site/helpers/emerald.php at line 804 (function getPlanDetails).

NOTE 1 - Missing code to Deactive old plan after upgrade, now I manage this by using "Deactivate plans" in plan parameters. NOTE 2 - I have used "floor" instead "ceil" function (described on "Price recalculation step in days" tip), because with "ceil" your example not work as expected. Now with "floor" function you have expected result.

I hope with this you can release new version with this features in a shot time.

        // Upgrade if not others discounts
        if($plan->params->get('crossplans.ud_plans') && $plan->params->get('crossplans.ud_price_step') && $plan->params->get('crossplans.ud_price_step')>0 && $plan->discount == 0){ 

            $from_plans=$plan->params->get('crossplans.ud_plans');  // From Plans

            $user_plans = self::getUserPlans(NULL,true); // User active subscriptions

            foreach($from_plans as $from_plan){
                if(in_array($from_plan,$user_plans) && !in_array($plan->id,$user_plans)) 
                {
                    // Get active "from plan" subscription 
                    $user_subs = self::getUserActiveSubscriptions(false,0,$from_plan);

                    // Get Days,Days Enable and Price from DB for active Subscription
                    $db = JFactory::getDbo();
                    $query = $db->getQuery(true);

                    $query->select('u.price');
                    $query->select('IF(u.ctime <= NOW(), (TO_DAYS(u.extime) - TO_DAYS(NOW())), (TO_DAYS(u.extime) - TO_DAYS(u.ctime)) ) as days');
                    $query->select('(TO_DAYS(u.extime) - TO_DAYS(u.ctime))  as days_enable');
                    $query->from('#__emerald_subscriptions AS u');

                    $query->where('u.id = '.array_values($user_subs)[0]->id);

                    $db->setQuery($query);

                    $result=$db->loadAssoc();

                    $plan->params->get('crossplans.ud_price_step');

                    // Cast to numeric for operations
                    $days_enable=intval($result['days_enable']);
                    $days=intval($result['days']);
                    $price=floatval($result['price']);

                    // Calculate Discount for Upgrade
                    if($days_enable>0 && $days>0) // To avoid problems
                    {
                        $total_steps=$days_enable/$plan->params->get('crossplans.ud_price_step');
                        $step_price=$price/$total_steps;
                        $passed_steps=floor($days/$plan->params->get('crossplans.ud_price_step'));
                        $discount_upgrade=$step_price*$passed_steps;
                    }
                    else
                    {
                        $discount_upgrade=0;
                    }

                    // Apply Discount
                    $plan->price -= $discount_upgrade;
                    $plan->discount += $discount_upgrade;
                }
            }
        }

Hi, still here a changes to deactive upgraded plans: in file /site/helpers/emerald.php at line 145 replace this:

$unpublish = $plan->params->get('crossplans.plans_deactivate');

with this:

$unpublish = array_unique(array_merge( (array) $plan->params->get('crossplans.plans_deactivate'), (array) $plan->params->get('crossplans.ud_plans')));

simply merge 2 options "crossplans.plans_deactivate" and "crossplans.ud_plans"

fdesanto simply merge 2 options "crossplans.plans_deactivate" and "crossplans.ud_plans"

Why?

hi, because when you upgrade a plan you get a discount of unitilized amount from previous plan, so old plan need to be deactivated.

unutilized amount is like partial refund of previous plan, otherwise user have 2 plans with 2 different expiration date, this not make a sense, because new plan include previous plan as upgrade

OK, I get it. After upgrade previose plan have to be unpublished.

Anyway I do not think your general code is correct. You code asume that $plan->params->get('crossplans.ud_plans') is a list of plans from which your can upgrade. But it is vice versa. It is list of the plans that user may upgrade to. So the logic have to be reversed.

1. We hel list plan _Ds of active user subscritpions
2. We get all those plans
3. We cycle through and see to every plan parameter $plan->params->get('crossplans.ud_plans') and check if this plan in that list and if yes we remember it
4. If there are more than one plan we have to find user subscription that can deduct most amount in favor of end user. So we calculate deduct amount for every user subscritpion of each pland that contain this plan in $plan->params->get('crossplans.ud_plans').

Something like. Anyway, do not worry, I'll try to manage that.

How? Are there no parameters in cross plan section of the plan?