We have a weekly call that members are subscribing to and I need some help creating an automated a system for two different plans.
The first plan is the 1-week plan where they have access to the article with the call in info on how to access the teleconference as well as a remository mp3 download of the call after the fact if they missed the live call. We would like to keep track of the weeks they sign up for and allow access to just those individual weeks articles that they paid for. Members are going to sign up for some weeks and not others creating gaps in their subscription renewals. Maybe the articles could be listed in their member profile some way or Joomla will only show those articles that they paid for in an article category blog layout? How can I automate this process, maybe with a SQL query so that they only have access to the individual weeks articles and downloads they paid for, maybe using the Created or Start Publishing date of the article?
The second plan is a 4-month plan, which is similar to the 1-week plan but is just for a longer period of time and the integration needs to only give access to the articles for a 4-month block of weeks starting with the week they signed up?
Ideally, I would like to only have to make one new article for each weekly call that could be shared by both plans. I would also like the automation to increment automatically so that as the weeks pass by I don’t have to manually go in every week to adjust the workflow or integration settings for each plan, and it just automatically gives access to the latest article with that current weeks call in info while still retaining the access to the past weeks that members paid for.