PSCB - Customization PowerTeacher (Class Attendance)

View PSCB Plugin Directory

Version 1.3

Description

This plugin adds a student track column to the PowerTeacher and Sub class attendance pages.

This page fragment can easily be modified to display different or additional field values.

Example 1
To add the team field.

$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, s.track, s.team
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(track;t) / ~(team;t)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Team');
for(i=0;i' + track[i].track + '');
}
})

Example 2
To Decode the Track values.

$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, decode(s.Track,'A','Navy','B','Gold','C','All Virtual','') Track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(Track)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

Version Info

1.0 (2020-09-13)
- Initial Release

1.1 (2020-09-24)
- Added student track to the sub class attendance page.

1.2 (2020-10-06)
- Corrected Fill Code issue. Changed Track display format.

1.3 (2020-11-04)
- Student names containing a apostrophe now display correctly in the sub portal
- Tracks now display correctly in the sub portal for students with identical names.

Powerschool Compatible Versions

19.x, 20.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources

Installation

Install in System > System Settings > Plugin Management Configuration

Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Login to PowerTeacher start page.
Click on the chair icon for a selected class.