Custom PHP/MySQL script needs edits and troubleshooting

Before describing what needs to be done on the site let me first include a short summary of how the site currently works.

This is a lead/agent management site. There are two main sections of the site. An Admin portion and an Agent section.

Admin logs in an manually enters a "lead information" to the next agent in queue. A notification via email is sent to the Agent telling them that a lead has been assigned and they have 30 minutes to accept it. Agent can accept the lead by clicking on the link provided in the email or by logging in to their account and accepting there. If they decline or after 30 minutes this lead is emailed to the next agent in rotation.

2nd requirement. In order to keep the lead the Agent needs to set a "next contact date in the field" (screenshot attached) within 8 hours of accepting the lead. Again if this is not done then the lead is deleted from Agent and emailed to the next Agent in rotation.

A reminder is sent via email to the Agent on the date that he/she has set in the "next contact date field"

This project will make sure that the following tasks work.

1. The 30 minute period for Agent to accept a lead seems inconsistent. It appears that when Admin sends a lead at 1;52PM then the lead is moved/expires at 2:00PM instead of 2:22PM.

2. Reminder is sent to Agent on the date that they set the "Next Contact Date"

3. Currently the time is being captured in military format. 16:00 instead of 4:00PM. We'd like the former version.

4. The Next Contact Date calendar shows today's date and not year 1900 (screenshot)

This site is live and being used so any work would need to be done on a copy of the site. Here is the url of the current site although I can not give the credentials until a programmer is chosen.

[url removed, login to view]

Milestone payment released immediately once the work has been complete.

There is quite a bit more work to be done on this site but it will make more sense to request more tasks once these are done and programmer is comfortable in this code.

Thank you.

Skills: HTML, MySQL, PHP, Software Architecture

See more: php code for calendar, order programmer php, milestone management software, how to set a bit, first bit set, calendar code in php, i decline, software troubleshooting, software architecture php mysql, short script, queue management, mysql copy, minute script, military them, live queue, custom field, screenshot url, php calendar reminder, format php code, php mysql include, needs done today, section script, payment released, time today php, mysql time management

About the Employer:
( 10 reviews ) Twin cities, United States

Project ID: #1294151

Awarded to:


Hi! I can help you with these. Can start as soon as awarded. Kind Regards

$40 USD in 0 days
(327 Reviews)

13 freelancers are bidding on average $98 for this job


I am an experienced PHP/MySQL programmer. I can fix your script fast.

$60 USD in 2 days
(91 Reviews)

Dear Hiring Manager I am representing Daccit Pvt. Ltd. We have a team size of 100+ highly experienced developers and professionals having experience of 8+ years in web and software development. We are expertise in HT More

$250 USD in 5 days
(19 Reviews)

Hi. I am ready. Please check your pm. Thanks.

$150 USD in 3 days
(25 Reviews)

Please check PM

$50 USD in 4 days
(16 Reviews)

6 years old Web-Development company. please check our site. please see our portfolio for our work thanks

$100 USD in 7 days
(11 Reviews)

Hi, I'm a skilled professional programmer. I understood what's behind the issues you are facing and I think that I could manage this project easily if you'll choose me. You only have to tell me all the relevant inf More

$150 USD in 3 days
(6 Reviews)

Hi, I can do this exactly as you want. I'm expert in php, mysql, html, jquery. See inbox for more details.

$49 USD in 3 days
(5 Reviews)

Hi! Please check your inbox for my message

$100 USD in 7 days
(5 Reviews)

hi,i wanna do this,thanks.

$35 USD in 2 days
(1 Review)

Hello, 8+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me for any question, Thanks.

$98 USD in 3 days
(0 Reviews)

please cheack my pm

$150 USD in 3 days
(0 Reviews)

I am working as php developer with more than 3 years of experience with smarty, zend, symfony and cakephp frameworks. I am ready to do this task.

$48 USD in 3 days
(0 Reviews)