Click here to Skip to main content
15,562,222 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I have completed a customer record system that uses PHP and MySQL, however i am having difficulty working out how to establish a warning system from the end of a contract.
1. The customer can have a contract of 1 - 5 years (int)
2. The contract start date and created date is stored in the database (date)
3. The notification needs to be 3 months (or 90 days) before the end of the contract.
4. a final balloon payment is required to be paid to finalise the contract or the customer can extend the contract.
5. an email notification becomes available 90 days b4 the end of contract (finally enabling a click of a link to send an email to discuss extending the contract, from the customers email details stored in the database)
6. once the email is sent there needs to be a flag that will say that the email does not need to be displayed anymore.

Does anyone have any suggestion how to go about doing this or even point me to articles that may help

Many thanks
Updated 18-Oct-11 0:34am

1 solution

If, what you really need is to manage your contracts with your customers and send them emails when the contracts are about to expire, get a smartphone and create some reminders and send emails yourself.

I'm of course assuming that you're a freelance developer that actually develops software for commercial use.

If you're not a developer, and you're a student who is looking to get your homework done effortlessly, you need to learn a lesson. One hour of Google-ing could have brought you all the answers for your questions.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900