In Progress

Small PHP/MySQL Cron Job

I have a Thyme calendar installed which controls booking information for a client. Clients book meeting rooms using the calendar and they're inserted into the database as "tentative" bookings until a deposit is received.

My client would like to automate the process of removing bookings that are not confirmed with a deposit so I need to write a small cron job to do it with the following requirements:

- I would anticipate running the job probably once per day. I would simply like it to query the database, select any events which are still tentative 7 days after they were booked, and change their type to "cancelled". I'd also like the job to then send the calendar owner an email telling her the number of events that were cancelled, as well as the corresponding dates and titles of the events that were cancelled.

- Each event has it's own table row with a unique ID for each event, an "etype" field storing the event type, "title" for the event title, and "added" which is the date the booking was added to the database (stored as a unix timestamp) - so all the information to do the job is already in the database.

- I would like the ability to change the 7 day period easily just in case the client's needs change down the track. No problem for me to edit the code manually though, I don't need any fancy front ends or anything like that.

I would anticipate this is a fairly quick and easy job for an experienced PHP/MySQL coder, but I don't have the time to learn right now so I'm throwing it out there for someone a bit smarter than me to have a go.

Cheers,

Ben

Skills: PHP

See more: mysql cron job, mysql cron, mysql cron jobs, cron jobs mysql, cron php mysql, cron job mysql, cron php mysql problem, mysql query cron, schedule cron job php, cron mysql query, cronjob mysql query, php cron events, tentative event, so ben, s controls, rooms, php per, php owner, php mysql job, learn go, job per, job id, job event, job edit, go learn

About the Employer:
( 1 review ) Norwood, Australia

Project ID: #248611

Awarded to:

AtlanticSoft

Hi please check pmb for details

$30 USD in 1 day
(166 Reviews)
7.8

11 freelancers are bidding on average $32 for this job

NickolaS

Hi, please, check your PM

$30 USD in 0 days
(329 Reviews)
7.5
dboyzhang

Can start to work immediately. Regards Bo Zhang

$30 USD in 0 days
(272 Reviews)
7.1
ventom

Hello, I can deliver Your project in a few hours. Please check PMB for more details.

$30 USD in 0 days
(30 Reviews)
5.7
momark

Hello, please check PM for details. Thanks -Omar

$50 USD in 1 day
(10 Reviews)
5.4
SteeleR

Can do it right away..

$30 USD in 1 day
(14 Reviews)
5.4
bclz

Can be done in 1 hour, Please contact me. Thanks.

$30 USD in 0 days
(5 Reviews)
3.0
feedzh

Hello I have similar project also and I have experience in cron jobs. I can make similar script in one day. Cheers

$30 USD in 2 days
(1 Review)
3.0
pledgedmedia

Can be done today. NP Mike Thomas TheLabWeb

$30 USD in 0 days
(5 Reviews)
2.9
joomlafire

i think i know as much php as i need to solve this problem

$30 USD in 0 days
(2 Reviews)
0.0
urtrivedi

I can do this job for you, i am experienced in php programming

$30 USD in 7 days
(0 Reviews)
0.0