问题描述
我已经完成了使用PHP和MySQL的客户记录系统，但是我在解决如何从合同结束时建立警告系统方面遇到困难.
1.客户可以签订1-5年的合同(int)
2.合同开始日期和创建日期存储在数据库中(日期)
3.通知必须在合同终止前的3个月(或90天)内.
4.需要最终支付一笔总价以完成合同，否则客户可以延长合同.
5.在合同到期后的90天之内，将有一封电子邮件通知可用(最终允许单击链接来发送电子邮件，以讨论存储在数据库中的客户电子邮件详细信息，以讨论合同的延期)
6.发送电子邮件后，需要有一个标记，表明不再需要显示电子邮件.
有没有人对如何做到这一点有任何建议，甚至给我指出了可能会有所帮助的文章
非常感谢
Al
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
Al
推荐答案
这篇关于PHP日期问题(PHP新手)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！