Drag and Drop Calendar Events CRUD

A lot of the work has been done for you. Please see

https://www.jqueryajaxphp.com/fullcalendar-crud-with-jquery-and-php/

We have a database table called deals

dealid
clientid
headline
imageid

We have a database table called dealdates

webnumber
dealid
dealdate

The clientid and webnumber are provided as session variables.

$clientid = $_SESSION['clientid'];
$webnumber = $_SESSION['webnumber'];

The user is shown their calendar with content included selected from their webnumber (uses dealdates & deals tables)

The user is shown a list of deals (selected from their clientid - uses deals table) as a scrollable list to the left of the calendar.

- We want to display the headline and the dealid and the image using the imageid.

We want to be able to order this list by Headline (Alphabetical) and by Deal ID (numeric)

The user then drags the deal to the calendar.

No need for day view, just weekly and monthly.

Only one entry per day in the calendar is allowed.

If an item is dragged to a day where there is already a deal it is replaced by the new deal after a confirmation box request to overwrite (Yes/No).

Please ensure you have read through the web link provided and you know how to do this.

Its only a few hours work so please no 1 week + time frames.

Please only reply if you KNOW you can do this quickly and reliably.

Feel free to ask any follow up questions you need.

Thank you and good luck.