Today's Bus Notes Plugin

Turns out in most of my elementary schools each classroom sends a student down to the office with bus notes each and every morning.
"Susie will be walking today", "Johnny will be dropped off at such and such the rest of the week", etc.
The office then compiles these slips of paper and hands out "Today's Bus Notes" to staff on bus duty and the drivers.
One of my front office friends explained this process to me and asked "Can you streamline this awful thing!"
This may not apply to your district. However, I still think this would serve as a good example for PS admins looking to build something similar with database extensions and the ~[DirectTable.Select...] tag.

Today's Bus Notes plugin adds a new bus icon to the PowerTeacher home page for each section listing. This new Bus Notes page allows you to add/edit/delete one or more bus notes for each student in the class. Notes default to being for "today", but you can change their duration and start date.
On the admin side of PS these notes can be added/edited/deleted from the student Transportation screen.
A page fragment is used to add a link to the admin start page left navigation called "Bus Notes" (only when in a school). This is the report that lists out all the notes for the current date. And this can be printed by the office as much as it likes.
Simple and effective.

This is my first foray into building plugins. So a couple warnings:
1. This plugin will create a new Database Extension group named U_BUS with the child tables U_BUS and U_BUS_NOTES.
2. Currently Database Extensions cannot be deleted from your PS database once created.
3. Hence, INSTALL THIS ON YOUR TEST SERVER AND SEE IF YOU ACTUALLY WANT TO USE IT FIRST!

If updating from version 1.1 or earlier remove the page /admin/students/transportation.html before installing the new version. In version 1.2 and later, a page fragment is used to alter the built in transportation page.

Installation:

  1. Go to System - System Settings - Plugin Management Configuration
  2. Upload the Zip file
  3. Enable the Plugin (THIS WILL CREATE DATABASE EXTENSIONS ON YOUR PS SERVER)

Version History:

1.2 - Removed the /admin/student/transportation.html page and added a page fragment in it's place. Added home_room to the "today's bus notes" report.
1.1 - Removed the teachers/home.html page and added a page fragment to create the bus icon for teachers
1.0 - Initial release.

Screenshots:



ADMIN SIDE...

Download: 

Powerschool Type: