For the student schedule display, several classes has been created under the package mecca.student.timetable.
In the timetable, a Slot contains information such as, the day number, the slot number, subject (module) information, teacher id and location (or room).
A quick hack was done to display the time of the slot. I just called this remark, and the method name is simply getRemark(). This method will return a string that represent the time of the slot, as an example: 8.30am – 9.30am.
For this purpose, a new table was created to store the remark information for each slot. The table structure is as below:
For the student schedule display, several classes has been created under the package mecca.student.timetable.
In the timetable, a Slot contains information such as, the day number, the slot number, subject (module) information, teacher id and location (or room).
A quick hack was done to display the time of the slot. I just called this remark, and the method name is simply getRemark(). This method will return a string that represent the time of the slot, as an example: 8.30am – 9.30am.
For this purpose, a new table was created to store the remark information for each slot. The table structure is as below:
CREATE TABLE `tt_slot_remark` (
`slot_id` int,
`remark` varchar(100)
);
and it contains data such as below:
slot_id remark
1 8.30am - 9.30am
2 9.30am - 10.30am
3 10.30am - 11.30am
4 11.30am - 12.30pm
5 12.30pm - 1.30pm
6 1.30pm - 2.30pm
7 2.30pm - 3.30pm
8 3.30pm - 4.30pm
9 4.30pm - 5.30pm
10 5.30pm - 6.30pm