Renewal Rate/term In Service Table On Client Profile

[Jonathan]

I'd like to see the renewal rate/term of a package listed on the client profile in the services table.  This would make it very handy at a glance to tell which overdue invoices match a given service, etc.  See screenshot.

 

 

[Paul]

I like the suggestion, it saves a few steps in finding out. I would be hesitant to add another permanent column though, I wonder if it would make sense in the "Term" column, ie "1 Year @ $123.00 USD". It may take up less room.

 

Also another reason to do what I wanted to do before the initial 3.0 launch, which is an icon / drop down selector for selecting which columns you want to display and in what order. Would allow us to add a lot of column options, while maintaining a clean UI by default.

[Jonathan]

I like your combined column approach.  I'd be perfectly fine with that.

[Paul]

I like your combined column approach.  I'd be perfectly fine with that.

 

Cool, any thoughts from anyone else? (Can I get a PLUS ONE?) lol

[Joseph H]

Cool, any thoughts from anyone else? (Can I get a PLUS ONE?) lol

 

+1 

[PauloV]

@Paul +1

[WebHostCentral UK - Dean]

+1

[Blesta Addons]

1+, i preffer also separate culumn to adlin and client view . Some column i want to be viewed by staff only .

[Darin]

+1

Or replace the existing date created column with a rate column. For my purposes, seeing the rate, term and renewal date at a glance is far more important than the date created. I can always drill down if I need to find the date created (which is almost never).

[a.daniello]

@Paul +1

[Jonathan]

I was hoping this would just be a template issue and could be added in easily and it almost can be.  The base package price is available on

$services[$i]['package_pricing']['price']

but this doesn't include configurable options, so it's not an accurate total renewal price.  I'm not sure if coupons are taken into account here or not either.

 

The configurable options output within their respective template are done so with this code:

function packageOptions() {
   var pricing_id = $('#pricing_id').val();
   if (pricing_id) {
    var params = 'service_id=<?php echo $this->Html->_($service->id);?>&' + $('[name^="configoptions"]', $('.package_options').closest('form')).serialize();
    $(this).blestaRequest('GET', '<?php echo $this->Html->safe($this->base_uri . "clients/packageoptions/");?>' + pricing_id, params, function(data) {
     $('.package_options').html(data);
    },
    null,
    {dataType: 'json'});
   }
  }

but I'm no javascript guy and this is a bit over my head to decipher into something usable to do the math to get the correct total.

[Tyson]

Renewal pricing has to be derived from each service separately. In the case of one-time services, there would be no renewal pricing. Also if we were to create a table column for listing expected renewal pricing, it would not be a sortable field.

[Jonathan]

Renewal pricing has to be derived from each service separately. In the case of one-time services, there would be no renewal pricing. Also if we were to create a table column for listing expected renewal pricing, it would not be a sortable field.

 

Sounds exactly like what I'd hope for and expect.  Sorting by this column would be useless anyway.

[Jonathan]

Has anyone by chance deciphered that javascript yet?

 

If I can just get it into workable PHP then I'm in business but I have no idea how to interface with pulling what I need out of that JS.

[Tyson]

The javascript you included above is for fetching and displaying package options as form fields. There's really nothing you can do with that to aid in creating a new column for service renewal price under the Services table. If you need the combined pricing of the service and configurable options, then you would need to update the controller for that view to fetch and include this information for each service. You can fetch configurable options by calling Services::getOptions, and simply sum up the package price and config option prices to come to a total renew pricing that you can include on a new column in the view.

[Tyson]

@Jonathan,

 

Are you only looking to display the service/package price as the "Renewal Rate", or are you wanting this to be the exact total amount that should be charged (considering config options, taxes, and any coupon) upon renewal? Including the package price is fairly simple, but the latter is not.

[Jonathan]

The latter is what I'm after.  The package price isn't a big deal since we already see the plan listed there.  It's the total that we need.

 

Perhaps adding another DB column to store a "cached"? copy of this might make it easier to deal with so there's not so much logic involved in making this total available in the template?