I'm currently building an app that includes sales promotions. There is an option in the promotion that allows the manager to have a start and end date. I do not want the manager to have to manually select the winner, but I want my software to read that the end date was reached and auto close the promotion.
This sounds like a job for
These are my options:
- At night, run a single script that pulls all promotions across my entire database and updates promotions that have completed.
- At the creation of the promotion record, queue up a cron to run at the custom end date.
- Force the user to manually update promotion.
Any advice or previous experience would be greatly appreciated!