WHMCS Free Trials Addon Development

We need to develop a custom free trails module for whmcs.

This module will need to:

1. create an easy interface for the admin to change settings
2. send suspension reminders (with custom email templates) x days before suspension
3. suspend account after x days
4. send termination reminders (with custom email templates) x days before termination
5. terminate service after x days



the suspend/terminate and email reminders can be done on the whmcs cron hook.


in the admin area we need a module page created which will display a table with the options set out above (screenshot provided).


the table should list all saved settings, and a new row where the admin can add another free trial product setting. (there should also be an option to delete a setting from the table, this should have a javascript confirm and then reload the page after deleting from the db).

so here is the workflow:

1. admin logs in.

2. creates free priced product

3. goes to module page and fills in the new row at the bottom of the table with the folowing details:
- product name (selected from dropdown, saved in db table as product id, should be a list of all products in system)
- send suspend email reminder set to 3 (textbox)
- selects an email template from the dropdown to choose the email sent for suspend reminder (should be a list of possible emails from the products section of email templates)
- selects the number of day before suspend to 5 (textbox)
- send terminate email reminder set to 7 (textbox)
- selects an email template from the dropdown to choose the email sent for termination reminder (should be a list of possible emails from the products section of email templates)
- selects the number of day before termination to 10 (textbox)


4. hits the save button





then whenever a client chooses the free product, they will get a suspend reminder after 3 days, the service will be suspended after 5 days, they will get an email for termination at 7 days and it will be terminated at 10 days.




the custom table for the module should be called 'mod_free_trails'. and the structure should be like so:

id - auto increment
'product' - id of product
'email_suspend' - number value
'suspend_email' - id of email tpl from db
'suspend' - number of days to suspend
'email_terminate' - number value
'terminate_email' - id of email tpl from db
'terminate' - number of days to suspend





we sell multiple whmcs modules and have many modules with similar layouts so we could show you the code which should explain better how the display should be setup.


the module page and saving the settings is very easy, and the cron proccessing is done via a hook. also the email templates sent can be done using the buolt in api which is very simple.

the reason we are not doing this ourselves is that we are extremly busy and looking to find a person to help us out long term. we have many projects everyday anmd would like to reduce our load.


whmcs also has some built in mysql query functions which we would like to be used over the normal "mysql_query" as these provide additional security and data sanitation.

If your not familiar with the api, the hooks system, or the mysql helper functions please dont bid, we need this to be completed asap and to our standard (which includes the use of said functions).

also we shouldnt need to explain how to create the tables or the module output, if we need to your not right for the job.

applicat should be able to be provided with one of our current modules, look at how its coded, then create this as we create our other modules (improvements in code optimisation welcomed, but sloppy coding not an option).



if you can work on your own dev system thats fine, if not we have a dev server you can use to develop on.