PHP日期问题(PHP新手) [英] PHP date problem (PHP novice)

问题描述

我已经完成了使用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

推荐答案

如果，您真正需要的是与客户管理合同，并在合同即将到期时向他们发送电子邮件，请购买智能手机并创建一些提醒并自己发送电子邮件.

我当然假设您是一名自由开发人员，实际上是开发用于商业用途的软件.

如果您不是开发人员，并且您是希望轻松完成家庭作业的学生，​​则需要学习一课.一小时的Google翻译可以为您带来所有问题的答案.

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.

这篇关于PHP日期问题(PHP新手)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！