- Last Active
- Preferred Name
Nice work. Does not have to be perfect, as long as it works! If you look at the attached you'll see I have added indents to make it easier to read.
I don't have time to look now, but I think you could make this more efficient by taking the following:
JOIN gibbonStudentEnrolment ON (gibbonFinanceBillingSchedule.gibbonSchoolYearID=gibbonStudentEnrolment.gibbonSchoolYearID AND gibbonStudentEnrolment.gibbonSchoolYearID=(SELECT gibbonSchoolYearID FROM gibbonSchoolYear WHERE status='Current'))
and using a separate JOIN to link to gibbonSchoolYear and then checking for Current in WHERE. There is another similar case in there too. Something to consider!
Thanks for sharing : ))
@sandra this sounds really interesting, and I am keen to see where you end up. Cam Sabo, another Gibbon user who is not registered on the forum yet, shared this video with me, which might provide food for thought in terms of workflow and functionality:
Good luck, and let me know if I can help at all.
Hello jemmyn, we have discussed Bootstrap as one way to move towards responsive design, but rather than relying on a single framework, we are moving towards an inhouse solution. The first stage of this is moving the codebase towards object oriented, which is well underway in v15. Our hope is to have some responsive elements in place in v16 or v17 (see https://docs.gibbonedu.org/developers/getting-started/gibbon-road-map/ for some upcoming dates).
In terms of funds, I am currently working to try and establish a legal entity around Gibbon so that we can undertake such fund raising. For now, this is not something we could centrally coordinate, but I guess you could run a Kickstarter project to look at something like this.
Thanks for your input!
Hi icttech. Sandra is spot on here, and I would only add one thing. If you set a user's end date in advance, the system will stop showing them in most views (e.g. Attendance, Planner, Markbook) once that date is reached. Another step is to use the User Management command line tool and cron to automatically switch such students from status Full to Left. You can see instructions for doing this, and other CLI jobs in Gibbon, using the link below: