I need a Google Calendar & iCalendar (Apple's Version) scripts that would import, update and delete events. Both versions will be as their own PHP script file, but function in the same way. The scripts will use login details or api's keys to access the accounts to add/update events, ie no download csv file and upload to either Google/iCalendar, should be fully automated. You will need to tell me how / what method / you will be using in your bid proposal.
The script you will be writing should allow for it to be included within a MySQL While loop. Each event will have predefined data with use of variables, so basically when you give me the script I change the variables to the correct ones. You just need to highlight where.
I need at least the following:
Event ID, Customer Name, Customer Address, Customer Contact Details (Phone, Email etc), Items Booked (allow for multiples), Booking Date, Booking Time (Start and End), Payment Status, Total Price.
There can be multiple events on the same day!
I should be able to add more if I want to. Perhaps some of this data goes in a description of some sorts?
So the scripts needs to insert too Google & iCalendar:
- Check if event id exists - If exists - Update, If does not exist - add it.
So the scripts needs to update the existing entrée:
- Update the existing event id, by replacing the values with the new.
Both adding and updating needs to check a status of the event.
If event status is cancelled then
- Delete the event from Google & iCalendar
- Proceed with Add or Update
You will be using your own data for this, I will implement this into my code myself, remember that I will include your script ( include([url removed, login to view]); ) within a MySQL while loop that grabs events from a database.
For completion of this project, you will need to provide screenshots of your Google calendar and iCalendar with the data in the date. You will provide your php files with the scripts. You will provide any support implementing the script and any repairing any bugs or missing data.