当前位置：文江博客话题详情

PHP renewal

php：如何进行汽车高级会员续订？

发布于 2024-08-17 00:58:20 字数 374 浏览 20 评论 0 原文

场景：

有4项：

30day pass
60day pass
180day pass
365day pass

有每月（30天）信用上限。因此，如果您在月底之前用完积分，则需要再购买 30 天通行证，或者等到下一个续订期。

一个人今天购买了 30 天的通行证，购买日期被记录到数据库中。有效期也被记录。

if ($todaysdate >= $expirydate) //DONE.

但是 60 天和 180 天的通行证呢？

我们已经购买了&到期日。每30天，下个月的信用需要重置。

我真的不知道如何最好地解决这个问题。

原文

scenario:

there are 4 items:

30day pass
60day pass
180day pass
365day pass

there is a monthly (30 day) credit cap. so if you use the credit up before the end of the month you need to purchase another 30day pass, or wait till the next renewal period.

A person purchases a 30day pass today, purchase date is recorded to DB. Expiry date is also recorded.

if ($todaysdate >= $expirydate) //DONE.

but whAt about for 60day and 180day passes ?

we have purchasedate & expiry date. every 30days, the credit needs to be reset for the next month.

I am really lost how to best approach this problem.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

盗琴音 2024-08-24 00:58:20

一种方法是使用 cron 和 mysql，

当您每天运行此 cron 时，

定义一个变量

define (DAY_AMOUNT ,30);

，检查当天经过的查询，

SELECT mem_id  DATEDIFF(CURDATE(),mem_date) AS daypass FROM table
 WHERE ((DATEDIFF(CURDATE(),mem_date))=".DAY_AMOUNT."

返回的结果是从该日期起 30 天过去的所有成员。

one way to do that is with cron and mysql

when you run this cron every day

define a variable

define (DAY_AMOUNT ,30);

check the day pass by query

SELECT mem_id  DATEDIFF(CURDATE(),mem_date) AS daypass FROM table
 WHERE ((DATEDIFF(CURDATE(),mem_date))=".DAY_AMOUNT."

the results that return is all the members that pass 30 days from the date.

回复收藏 0 原文

还在原地等你 2024-08-24 00:58:20

您可以每天运行一个任务（或 cron 作业）来检查当前日期是否晚于记录的到期日期，以及是否将用户信用重置为 0，并向他们发送一封电子邮件，让他们知道他们的信用已过期。

当用户购买积分时，您只需将其到期日期添加 30、60 或 90 天。

有关更多信息，请参阅 php + cronjob 标签。

回复收藏 0 原文

陪你到最终 2024-08-24 00:58:20

在您的情况下，您可以有一个像这样的表：

pass: (id, user_id, start_time, end_time, credit)

每天您都可以刷新任何已过期通行证上未使用的积分：

update user join
  (select user_id, sum(credit) as credit from pass
    group by user_id where end_time <= now() and not flushed) b
  set user.credit = max(user.credit - b.credit, 0)
  where user.user_id = b.user_id

update pass set flushed = 1 where end_time <= now() and not flushed

通过使用 end_time <= now() 您确保仅在到期日期过后才重置积分。因为您记得哪些遍被刷新，所以您可以根据需要多次运行它，并且错过一天不是问题（它将在下次运行时检测到）。

这实际上就是预付费电话卡的工作方式 - 您有一定的分钟数，该分钟数在 X（30/60/90 等）天内有效，并且分钟数在结束时重置。

顺便说一句，您可以通过使用易于使用的订阅管理系统（例如 recurly 或 chargify。

in your situation, you could have a table like this:

pass: (id, user_id, start_time, end_time, credit)

every day you can flush the unused credit on any pass that has expired:

update user join
  (select user_id, sum(credit) as credit from pass
    group by user_id where end_time <= now() and not flushed) b
  set user.credit = max(user.credit - b.credit, 0)
  where user.user_id = b.user_id

update pass set flushed = 1 where end_time <= now() and not flushed

by using end_time <= now() you ensure the credit is only reset once the expiration date has passed. since you remember which passes were flushed, you can run this as often as you like and missing a day is not an issue (it will be detected on the next run).

this is effectively how a prepaid calling card would work - you have a certain number of minutes that are valid for X (30/60/90 whatever) days and the minutes are reset at the end.

btw, you can simplify all that stuff by using an easy to use subscription management system like recurly or chargify.