~[wc:commonscripts] ~[wc:teachers_header_css] ~[wc:teachers_navigation_css] ~[SetPostValue:tabname=home] ~[wc:teachers_nav_css]

~[text:psx.htmlc.teachers.busnotes.editpage.Classroom_Daily_Bus_Notes]  ~[tlist_sql; SELECT sec.course_number, sec.section_number, sec.external_expression FROM sections sec WHERE sec.id =~(gpv.sectionid);] ~(course_number).~(section_number) ~(external_expression) [/tlist_sql]

~[if#save.~(gpv.changesSaved)=true]
~[text:psx.htmlc.teachers.busnotes.editpage.Note_saved]
[/if#save] ~[if#d.~(gpv.changesSaved)=delete]
~[text:psx.htmlc.teachers.busnotes.editpage.Note_Deleted]
[/if#d]
~[tlist_sql; SELECT s.lastfirst, '~[if#new.pref.busnotes_teacher~(curschoolid)=read]hidden[else#new]normalTD[/if#new]', s.dcid, sec.id sectionid, LISTAGG(case when bn.id is not null then chr(60) || 'div class="notesDiv"' || chr(62)~[if#new.pref.busnotes_teacher~(curschoolid)=read][else#new] || chr(60) || 'a href="editBusNote.html?frn=001' || bn.studentsdcid || chr(38) || 'authId=' || bn.id || '" class="dialog dockedDialog button" title="Edit Bus Note"' || chr(62) || 'Edit' || chr(60) || '/a' || chr(62) || ' '[/if#new] || bn.note || ' | Ends' || chr(58) || ' ' || to_char(bn.end_date,'mm/dd/yy') || chr(60) || '/div' || chr(62) end) WITHIN GROUP (ORDER BY bn.end_date) AS prev_notes FROM Students s JOIN CC ON s.id = cc.studentid JOIN sections sec ON cc.sectionid = sec.id LEFT OUTER JOIN u_bus_notes bn ON s.dcid = bn.studentsdcid AND trunc(sysdate) BETWEEN start_date AND end_date WHERE sec.id = ~(gpv.sectionid) AND s.enroll_status = 0 GROUP BY s.lastfirst, s.dcid, sec.id ORDER BY s.lastfirst ;alternatecolor] [/tlist_sql]
~[text:psx.htmlc.teachers.busnotes.editpage.Student_Name] ~[text:psx.htmlc.teachers.busnotes.editpage.Add] ~[text:psx.htmlc.teachers.busnotes.editpage.Todays_Notes]
~(lastfirst) New ~(prev_notes;ReplaceCRLFWithBR)
~[wc:teachers_footer_css]