Limit subscriptions to the actual month

  • Marco Antonio Pérez
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 8 months ago #96316 by Marco Antonio Pérez
Limit subscriptions to the actual month was created by Marco Antonio Pérez
We use the subscriptions to control assistance to a class, but they have to renew each month.
If they renew after the first day of the month, for example 15th, the subscription will go from 15th of the current month to the 15th of the next month.
Right now, we have to manually change the date of every subscription to the first day of the month and ask the users to renew before the expiration date, many don't.

It would be very nice if we could limit the renewal to the last day of the month. For example, that user that renewed the 15th would have a subscription from the 15th to the last day of the month.

Thanks.

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #101048 by Calum
Replied by Calum on topic Limit subscriptions to the actual month
We do the same but annually.

We wrote a small script to do it (coz I'm too lazy to do it even once a year!)

So our membership runs to 28 Feb each year. If you join after 1st Se 2017 you should run to 28 Feb 2019!

If all that is needed is:

At a determined period (once a month, once a year etc) to update the expiration date of every plan with a date set this sounds like a plugin could do it. If its more complex (i.e. you have monthly and yearly etc it gets messier!)

The code attached is run on a cron job on 1st Sep for us. It is a simple single line command - but website security in the forum has needed it zipped!

replace username password and database...
your database tables may not begin jos_ so change jos_osembership_plans to match...
Attachments:

Please Log in or Create an account to join the conversation.