This project requires knowledge in PHP Maker.
Create a calendar list page in PHPMaker eg. replace existing list page with a Calendar page showing all bookings. The view should show a month and all bookings like in MS Outlook Calendar.
Instead of displaying a list of records (default in PHPMaker); a calendar month view with all records according to the fields start_date, end_date and room_id should be shown. When clicking on a item it should open the item (view) like in list view.
It's the <table>[url removed, login to view] that should be replaced.
I can accept two different solutions;
1) Built on [url removed, login to view] and hard coded for this project.
2) Updated generic template which can be used with other projects.
I will pay more for the solution 2!
When bidding please specify which solution you offer!
Example from Outlook see attached file.
Example of database:
CREATE TABLE bookings
(`booking_id` int, `room_id` int, `start_date` date, `end_date` date, `customer_id` int)
INSERT INTO bookings
(`booking_id`, `room_id`, `start_date`, `end_date`, `customer_id`)
(001, 1, '2012-09-12', '2012-09-14', 23),
(002, 2, '2012-09-10', '2012-09-20', 20),
(003, 4, '2012-09-09', '2012-09-21', 43),
(004, 1, '2012-09-22', '2012-09-24', 9),
(005, 3, '2012-09-12', '2012-09-13', 53),
(006, 6, '2012-09-15', '2012-09-19', 27)
CREATE TABLE rooms
(`room_id` int, `room_name` varchar(15))
INSERT INTO ROOMS
(1, 'Room 1'),
(2, 'Room 2'),
(3, 'Room 3'),
Please confirm your knowledge of PHPMaker. Otherwise we will ignore your bid.
11 фрилансеров(-а) в среднем готовы выполнить эту работу за €399
Hello Sir/Mam, "Ready to Start work right now". I guarantee you that I can easily fulfill your needs within the time. you would love to work with professional who believe in long term relationships, Thanks.