BUILD JODA-TIME DATE AND TIME MANIPULATION ALGORITHMS FOR A CALENDAR AVAILABILITY AND BOOKING SYSTEM

Project description: implement algorithms that take time availabilities and bookings stored in a database and turns them into lists of meaningful date ranges, start times and booking intervals. Uses Joda-Time, MySQL and Java. Takes a few days to complete. Provided: skeleton classes, database dump, lots of explanations in comments and lots of TODO's Requires knowledge of Maven for deployment and running. Requires good experience with writing JUnit tests Requires knowledge of Spring, JDBC, JdbcTemplate and Data Access Objects Requires creating database dummy data and testing it Requires thinking outside the box and asking questions if any instructions are not clear You will have to understand what to do by reading the source code and completing all the TODO's in the code There are extensive explanations in the comments and Javadoc. You can do this if you are an experienced programmer/developer or if you're a software engineer/computer science student. Knowledge of the Joda-Time library helps alot. ## Deliverables STEPS TO FOLLOW TO BEGIN 1. Restore the database from the SQL dump provided in the project. 2. Run the SQL statements provided in the comments and make sure they work: 3. Run the jetty server using maven. You can use the batch file [login to view URL] for that. 4. Go to the URL http://localhost:9999/[login to view URL] and make sure that you see a calendar. In April days 1 to 15 should be blue and days 345 should be stroked through. Days that are blue or considered available. Days there are stricken through are considered booked. Days that are gray are considered unavailable. Your job will be to develop methods that use the 2 select statements above to draw calendar like this. 5. Open the file docbase\WEB-INF\classes\com\elintegro\calendarapi\[login to view URL] an examine its contents. The method getCalendarAvailabilities is is where you start working. Read the instructions there. 6. Start by undetstanding what the program has to do, studying the Database schema and creating 5 test cases and inserting the data to DB. Please ask any questions if you don't understand :)