I have a custom module which does many things including selling keywords for people to use in communication campaigns. The module checks to see if a keyword is available and then if so, programatically creates a uc_recurring_subscription product type and redirects them to the payment page so they can setup their recurring subscription. It enters details into a custom database table with the keyword being marked as 2 which means Pending.
Problems with the script:
1. Some essential information doesn't' get created when the uc_recurring_subscription product node is programatically created. The information about features isn't there. This is needed to tell the system how often to recur the payments and how much. I need someone to work out what variables to send through along with the node object and include them when creating this node and get it working for me.
2. After the uc_recurring_subscription node is created I need to make some conditional actions to update the database. If the user pays via credit card I need to run a conditional action using custom php to change the keyword from 2 to 1 (from pending to active). If the user pays via bank transfer or check it needs to stay as Pending until manually marked as paid by the site administrator. A second conditional action is needed using custom php to change it from 2 to 1 (Pending to Active) when that happens.
3. Several more conditional actions are required. When the renewal period comes around if the keyword subscription is renewed it should do nothing, but if it fails it should send a reminder and check again in a week. If it fails a second time it should change the keyword from 1 to 0 which means inactive and email user 1 (site administrator) to advise them this has happened.
4. I need a cron script in php which should run once a day and do the following:
- check each keyword and see its status. If it has been on inactive for more than 1 month it should change it to 3 (expired)
- check each keyword which has a billing date (data is in the same table) of the same day as the day the script is running - and email the site administrator to advise them to check for payment. The administrator will need to mark manually paid all direct bank transfers and needs this to check for them.
What is required:
- to save a copy of the module script before working
- to make the changes above and have the issues sorted and working
- to upload the script to the site and setup the conditional rules so it works properly
- to email me a zipped copy of the error free update module working properly
- to create the cron script as a 'page' content type using the php input filter on the site and I will set it up to run daily. I should be able to be run manually by simply visiting the page. This is how it can be tested.
I will provide
- administrator access - used to manage the site
- user access - used to get keywords and pay for them
- ftp access - to upload the latest version of the module script