Hello everybody ,
I am not an English native speaker, so please forgive my mistakes
I am glad to use Yii framework but I don’t know how to resolve my problem:
My project is a teacher schedule manager website. It stores the list of teachers, classes, subjects, etc.
Then, there are combinations with a teacher, its class, the number of students, how many hours per week…
The website must be able to do calculations to know how many students per teacher there is when they do their internships.
My database look like:
I am able to initialize every tables with the PHP pages generated by Yii but I don’t how to do the calculations I need.
Basically, the caculations use the different tables to check who are the teachers that teach to this class, how many students
should they take care of (based on their teaching ration…), etc.
My final result would be a page with:
Internship date / Class
Teacher list with number of students for each
(In a CGridView for instance)
Should I create another Yii class for this? The results should be dynamic (function to teacher, hoursperweek updates).
I am lost with this object oriented programming approach. Feel free to criticize my technical choices.