Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

HTML, CSS, JavaScript, PHP Develop “ONLINE STUDENT - ADVISOR APPOINTMENT SCHEDUL

ID: 3831568 • Letter: H

Question

HTML, CSS, JavaScript, PHP

Develop “ONLINE STUDENT - ADVISOR APPOINTMENT SCHEDULER”

1.Students should be able to schedule advising appointments with their advisor at their convenience.

2.Student should be able log-on and make an appoint 24 hours a day, 7 days a week.

3.Appointment times are available during normal business hours (9:00AM – 4:30PM). Appointment duration is 30 min.

4.Student is assigned to one advisor.

Student should be able:

1)      Log in with the predefine user name and password.

2)      Search for his/her advisor, or the name of the dedicated advisor should be available on the Web page.

3)      Click on the link “See Available Appointments.

4)      Student can view the advisor’s available appointments by day or week. Go to the day on which he/she would like to make appointment, and look for an available appointment time.

5)      Student should be able to provide a “Reason” for his/her appointment

6)      Student must enter a Description (or select a Description) of what he/she would like to discuss with advisor during the appointment.

7)      After submission, student should receive a confirmation of the appointment to email.

8) Email should include: Student name, ID, Advisor name, Advisor title, date, time, and office number.

9) The same information should be available in the database and on the conformation web page.

10) Student should be able to: add, delete, and change an appointment.

11) Student should be able only his/her appointments.

12) Student cannot override existing appointments.

13) Student should Logout from the system.

Note: Use three Database tables: Students, Advisors, and Appointments.

Explanation / Answer

function loadEvents() {
$.post("backend_events.php", // use "backend/events" for ASP.NET MVC
{
start: dp.visibleStart().toString(),
end: dp.visibleEnd().toString()
},
function(data) {
dp.events.list = data;
dp.update();
});
}

We will detect the currently-visible date range using visibleStart() and visibleEnd() methods and send it to backend_events.php as parameters.

The backend_event.php endpoint returns the calendar event data in the following format:

Hide   Copy Code

PHP backend (backend_events.php):

Hide   Copy Code

ASP.NET MVC backend (BackendController.cs)

Hide   Copy Code

The drag and drop user actions (selecting a time range, event moving, event resizing) are enabled by default in the scheduler.

We just need to add custom handler to submit the changes to the server side using an AJAX call.

JavaScript event handler

Hide   Copy Code

PHP backend (backend_move.php)

Hide   Copy Code

ASP.NET MVC backend (BackendController.cs)

Hide   Copy Code

If you want to use a custom CSS theme you need to include the stylesheet:

Hide   Copy Code

And set the theme property during initialization:

Hide   Copy Code

DayPilot also includes a monthly event calendar view. The API of the monthly view control uses the same design as the daily/weekly calendar:

Hide   Copy Code