function _makeExtra($value, $title = '')
{
global $THIS_RET;
if ($THIS_RET['WITH_TEACHER_ID']) {
$return .= Localize('colon', _('With')) . ' ' . GetTeacher($THIS_RET['WITH_TEACHER_ID']) . '<BR>';
}
if ($THIS_RET['NOT_TEACHER_ID']) {
$return .= Localize('colon', _('Not With')) . ' ' . GetTeacher($THIS_RET['NOT_TEACHER_ID']) . '<BR>';
}
if ($THIS_RET['WITH_PERIOD_ID']) {
$return .= Localize('colon', _('On')) . ' ' . GetPeriod($THIS_RET['WITH_PERIOD_ID']) . '<BR>';
}
if ($THIS_RET['NOT_PERIOD_ID']) {
$return .= Localize('colon', _('Not On')) . ' ' . GetPeriod($THIS_RET['NOT_PERIOD_ID']) . '<BR>';
}
if ($THIS_RET['PRIORITY']) {
$return .= Localize('colon', _('Priority')) . ' ' . $THIS_RET['PRIORITY'] . '<BR>';
}
if ($THIS_RET['MARKING_PERIOD_ID']) {
$return .= Localize('colon', _('Marking Period')) . ' ' . GetMP($THIS_RET['MARKING_PERIOD_ID']) . '<BR>';
}
return $return;
}
//
$period_select .= "<OPTION value={$period['ID']}" . (CpvId() == $period['ID'] ? ' SELECTED' : '') . ">" . $period['SHORT_NAME'] . ($period['MARKING_PERIOD_ID'] != $fy_id ? ' ' . GetMP($period['MARKING_PERIOD_ID'], 'SHORT_NAME') : '') . (strlen($period['DAYS']) < 5 ? ' ' . $period['DAYS'] : '') . ' - ' . $period['COURSE_TITLE'] . "</OPTION>";
//
if (CpvId() == $period['ID']) {
$_SESSION['UserPeriod'] = $period['PERIOD_ID'];
}
}
$period_select .= "</SELECT>";
}
}
}
$profile = DBGet(DBQuery('SELECT PROFILE FROM staff WHERE STAFF_ID=' . UserID()));
if ($profile[1]['PROFILE'] == "admin") {
DrawHeader($period_select);
}
echo '</FORM><BR>';
unset($_openSIS['DrawHeader']);
$_openSIS['allow_edit'] = AllowEdit($_REQUEST['modname']);
$_openSIS['User'] = array(1 => array('STAFF_ID' => UserStaffID(), 'NAME' => GetTeacher(UserStaffID()), 'USERNAME' => GetTeacher(UserStaffID(), '', 'USERNAME'), 'PROFILE' => 'teacher', 'SCHOOLS' => ',' . UserSchool() . ',', 'SYEAR' => UserSyear()));
echo '<CENTER><TABLE width=100% ><TR><TD>';
include 'modules/' . $_REQUEST['include'];
echo '</TD></TR></TABLE></CENTER>';
}
}
?>
<script type="text/javascript">
function close_window()
{
window.close();
}
</script>
function _makeExtra($value, $title = '')
{
global $THIS_RET;
if ($THIS_RET['WITH_TEACHER_ID']) {
$return .= 'With: ' . GetTeacher($THIS_RET['WITH_TEACHER_ID']) . '<BR>';
}
if ($THIS_RET['NOT_TEACHER_ID']) {
$return .= 'Not With: ' . GetTeacher($THIS_RET['NOT_TEACHER_ID']) . '<BR>';
}
if ($THIS_RET['WITH_PERIOD_ID']) {
$return .= 'On: ' . GetPeriod($THIS_RET['WITH_PERIOD_ID']) . '<BR>';
}
if ($THIS_RET['NOT_PERIOD_ID']) {
$return .= 'Not On: ' . GetPeriod($THIS_RET['NOT_PERIOD_ID']) . '<BR>';
}
if ($THIS_RET['PRIORITY']) {
$return .= 'Priority: ' . $THIS_RET['PRIORITY'] . '<BR>';
}
if ($THIS_RET['MARKING_PERIOD_ID']) {
$return .= 'Marking Period: ' . GetMP($THIS_RET['MARKING_PERIOD_ID']) . '<BR>';
}
return $return;
}
}
}
$select_html[$key] .= "</SELECT></TD>";
$select_html[$key] .= "<TD><SELECT name=course_weights[{$key}][]><OPTION value=''>Not Specified</OPTION>";
if (count($course_weights_RET[$value['COURSE_ID']])) {
foreach ($course_weights_RET[$value['COURSE_ID']] as $weight) {
$select_html[$key] .= "<OPTION value='" . $weight['COURSE_WEIGHT'] . "'" . ($value['COURSE_WEIGHT'] == $weight['COURSE_WEIGHT'] ? ' SELECTED' : '') . ">" . $weight['COURSE_WEIGHT'] . "</OPTION>";
}
}
$select_html[$key] .= "</SELECT></TD>";
$with_teachers = $with_periods = $without_teachers = $without_periods = '';
$teachers_done = $periods_done = array();
foreach ($periods_RET[$value['COURSE_ID']][$value['COURSE_WEIGHT']] as $period) {
if (!$teachers_done[$period['TEACHER_ID']]) {
$with_teachers .= "<OPTION value=" . $period['TEACHER_ID'] . " " . ($value['WITH_TEACHER_ID'] == $period['TEACHER_ID'] ? ' SELECTED' : '') . ">" . GetTeacher($period['TEACHER_ID']) . "</OPTION>";
$without_teachers .= "<OPTION value=" . $period['TEACHER_ID'] . " " . ($value['NOT_TEACHER_ID'] == $period['TEACHER_ID'] ? ' SELECTED' : '') . ">" . GetTeacher($period['TEACHER_ID']) . "</OPTION>";
}
if (!$periods_done[$period['PERIOD_ID']]) {
$with_periods .= "<OPTION value=" . $period['PERIOD_ID'] . " " . ($value['WITH_PERIOD_ID'] == $period['PERIOD_ID'] ? ' SELECTED' : '') . ">" . GetPeriod($period['PERIOD_ID']) . '</OPTION>';
$without_periods .= "<OPTION value=" . $period['PERIOD_ID'] . " " . ($value['NOT_PERIOD_ID'] == $period['PERIOD_ID'] ? ' SELECTED' : '') . ">" . GetPeriod($period['PERIOD_ID']) . '</OPTION>';
}
$periods_done[$period['PERIOD_ID']] = true;
$teachers_done[$period['TEACHER_ID']] = true;
}
$select_html[$key] .= "<TD><TABLE><TR><TD>With</TD><TD><SELECT name=with_teacher[{$key}][]><OPTION value=''>Not Specified</OPTION>" . $with_teachers . "</SELECT></TD><TD><SELECT name=with_period[{$key}][]><OPTION value=''>Not Specified</OPTION>" . $with_periods . "</TD></TR><TR><TR><TD>Without</TD><TD><SELECT name=without_teacher[{$key}][]><OPTION value=''>Not Specified</OPTION>" . $without_teachers . "</SELECT></TD><TD><SELECT name=without_period[{$key}][]><OPTION value=''>Not Specified</OPTION>" . $without_periods . "</TD></TR></TABLE></TD>";
$select_html[$key] .= "</TR></TABLE>";
}
}
}
echo "<BR><TABLE>";
if (count($subjects_RET)) {
unset($_SESSION['_REQUEST_vars']['button']);
}
} else {
if ($_REQUEST['event_id']) {
if ($_REQUEST['event_id'] != 'new') {
$RET = DBGet(DBQuery("SELECT TITLE,DESCRIPTION,DATE_FORMAT(SCHOOL_DATE,'%d-%b-%y') AS SCHOOL_DATE FROM CALENDAR_EVENTS WHERE ID='{$_REQUEST['event_id']}'"));
$title = $RET[1]['TITLE'];
} else {
$title = 'New Event';
$RET[1]['SCHOOL_DATE'] = $_REQUEST['school_date'];
}
echo "<FORM name=popform id=popform action=for_window.php?modname={$_REQUEST['modname']}&dd={$_REQUEST['school_date']}&modfunc=detail&event_id={$_REQUEST['event_id']}&month={$_REQUEST['month']}&year={$_REQUEST['year']} METHOD=POST>";
} else {
$RET = DBGet(DBQuery("SELECT TITLE,STAFF_ID,DATE_FORMAT(DUE_DATE,'%d-%b-%y') AS SCHOOL_DATE,DESCRIPTION FROM GRADEBOOK_ASSIGNMENTS WHERE ASSIGNMENT_ID='{$_REQUEST['assignment_id']}'"));
$title = $RET[1]['TITLE'];
$RET[1]['STAFF_ID'] = GetTeacher($RET[1]['STAFF_ID']);
}
echo '<BR>';
PopTableforWindow('header', $title);
echo '<TABLE>';
echo '<TR><TD>Date</TD><TD>' . DateInput($RET[1]['SCHOOL_DATE'], 'values[SCHOOL_DATE]', '', true) . '</TD></TR>';
echo '<TR><TD>Title</TD><TD>' . TextInput($RET[1]['TITLE'], 'values[TITLE]') . '</TD></TR>';
if ($RET[1]['STAFF_ID']) {
echo '<TR><TD>Teacher</TD><TD>' . TextAreaInput($RET[1]['STAFF_ID'], 'values[STAFF_ID]') . '</TD></TR>';
}
echo '<TR><TD>Notes</TD><TD>' . TextAreaInput($RET[1]['DESCRIPTION'], 'values[DESCRIPTION]') . '</TD></TR>';
if (AllowEdit()) {
echo '<TR><TD colspan=2 align=center><INPUT type=submit class=btn_medium name=button value=Save onclick="formload_ajax(\\"popform\\");">';
echo ' ';
if ($_REQUEST['event_id'] != 'new') {
echo '<INPUT type=submit name=button class=btn_medium value=Delete onclick="formload_ajax(\\"popform\\");">';
function _makeTeacher($value, $column)
{
global $THIS_RET;
return ($value ? Localize('colon', _('With')) . ' ' . GetTeacher($value) : '') . ($THIS_RET['NOT_TEACHER_ID'] ? ($value ? '<BR />' : '') . Localize('colon', _('Without')) . ' ' . GetTeacher($THIS_RET['NOT_TEACHER_ID']) : '');
}
#
# This program is released under the terms of the GNU General Public License as
# published by the Free Software Foundation, version 2 of the License.
# See license.txt.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../../RedirectIncludes.php';
if (GetTeacher(UserStaffID(), '', 'PROFILE', false) == 'teacher') {
$mp_select_RET = DBGet(DBQuery('SELECT DISTINCT cp.MARKING_PERIOD_ID, (SELECT TITLE FROM marking_periods WHERE MARKING_PERIOD_ID=cp.MARKING_PERIOD_ID) AS TITLE FROM course_periods cp,courses c, school_periods sp,course_period_var cpv WHERE cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND cp.COURSE_ID=c.COURSE_ID AND (cp.TEACHER_ID=\'' . UserStaffID() . '\' OR cp.SECONDARY_TEACHER_ID=\'' . UserStaffID() . '\') AND cpv.PERIOD_ID=sp.PERIOD_ID AND cp.MARKING_PERIOD_ID IS NOT NULL AND cp.SYEAR=\'' . UserSyear() . '\' AND cp.SCHOOL_ID=\'' . UserSchool() . '\''));
$print_mp = CreateSelect($mp_select_RET, 'marking_period_id', 'Show All', 'Modules.php?modname=' . $_REQUEST['modname'] . '&include=' . $_REQUEST['include'] . '&category_id=' . $_REQUEST['category_id'] . '&marking_period_id=');
echo '<div style="padding:10px 0px 0px 25px;"><strong>Marking Periods :</strong> ' . $print_mp . '</div>';
if (!$_REQUEST['marking_period_id']) {
$schedule_RET = DBGet(DBQuery('SELECT cp.SCHEDULE_TYPE,cp.course_period_id,\'\' as ROOM,c.TITLE AS COURSE,\'\' as PERIOD,cp.COURSE_WEIGHT,IF(cp.MARKING_PERIOD_ID IS NULL ,\'Custom\',cp.MARKING_PERIOD_ID) AS MARKING_PERIOD_ID, \'\' as DAYS,\'\' AS DURATION from
course_periods cp , courses c WHERE cp.course_id=c.COURSE_ID AND (cp.TEACHER_ID=\'' . UserStaffID() . '\' OR cp.SECONDARY_TEACHER_ID=\'' . UserStaffID() . '\') AND cp.SYEAR=\'' . UserSyear() . '\' AND cp.SCHOOL_ID=' . UserSchool()), array('PERIOD_ID' => 'GetPeriod', 'MARKING_PERIOD_ID' => 'GetMP_teacherschedule'));
} else {
if ($_REQUEST['marking_period_id']) {
$sel_mp_info = DBGet(DBQuery('SELECT * FROM marking_periods WHERE MARKING_PERIOD_ID=' . $_REQUEST['marking_period_id']));
$sel_mp_info = $sel_mp_info[1];
$schedule_RET = DBGet(DBQuery('SELECT cp.SCHEDULE_TYPE,cp.course_period_id,\'\' as ROOM,\'\' as PERIOD,c.TITLE AS COURSE,cp.COURSE_WEIGHT,IF(cp.MARKING_PERIOD_ID IS NULL ,\'Custom\',cp.MARKING_PERIOD_ID) AS MARKING_PERIOD_ID, \'\' as DAYS,\'\' AS DURATION from
course_periods cp , courses c WHERE cp.course_id=c.COURSE_ID AND (cp.MARKING_PERIOD_ID IN (' . GetAllMP(GetMPTable(GetMP($_REQUEST['marking_period_id'], 'TABLE')), $_REQUEST['marking_period_id']) . ') OR (cp.MARKING_PERIOD_ID IS NULL AND (cp.BEGIN_DATE BETWEEN \'' . $sel_mp_info['START_DATE'] . '\' AND \'' . $sel_mp_info['END_DATE'] . '\'))) AND (cp.TEACHER_ID=\'' . UserStaffID() . '\' OR cp.SECONDARY_TEACHER_ID=\'' . UserStaffID() . '\') AND cp.SCHOOL_ID=\'' . UserSchool() . '\' AND cp.SYEAR=' . UserSyear()), array('PERIOD_ID' => 'GetPeriod', 'MARKING_PERIOD_ID' => 'GetMP_teacherschedule'));
}
}
foreach ($schedule_RET as $rdi => $rdd) {
function _makeTeacher($value, $column)
{
global $THIS_RET;
return ($value != '' ? 'With: ' . GetTeacher($value) . '<BR>' : '') . ($THIS_RET['NOT_TEACHER_ID'] != '' ? 'Without: ' . GetTeacher($THIS_RET['NOT_TEACHER_ID']) : '');
}
DrawHeader(Config('TITLE') . ' ' . _('Discipline Log'));
DrawHeader($referrals[1]['FULL_NAME'], $referrals[1]['STUDENT_ID']);
DrawHeader(GetSchool(UserSchool()), $courses[1]['GRADE_ID']);
if ($start_date && $end_date) {
DrawHeader(ProperDate($start_date) . ' - ' . ProperDate($end_date));
} else {
DrawHeader(_('School Year') . ': ' . UserSyear() . ' - ' . (UserSyear() + 1));
}
echo '<BR>';
foreach ($referrals as $referral) {
echo '<TABLE cellpadding=5><TR>';
if ($_REQUEST['elements']['ENTRY_DATE']) {
echo '<TD><small><font color=gray>' . _('Date') . ': </font></small><b>' . ProperDate($referral['ENTRY_DATE']) . '</b></TD>';
}
if ($_REQUEST['elements']['STAFF_ID']) {
echo '<TD><small><font color=gray>' . _('Reporter') . ': </font></small><b>' . GetTeacher($referral['STAFF_ID']) . '</b></TD>';
}
$end_tr = false;
foreach ($_REQUEST['elements'] as $column => $Y) {
if ($column == 'ENTRY_DATE' || $column == 'STAFF_ID') {
continue;
}
if ($categories_RET[substr($column, 9)][1]['DATA_TYPE'] == 'textarea' && !$end_tr) {
$end_tr = true;
echo '</TR></TABLE>';
} elseif ($categories_RET[substr($column, 9)][1]['DATA_TYPE'] == 'textarea') {
echo '<BR>';
}
if ($categories_RET[substr($column, 9)][1]['DATA_TYPE'] != 'textarea') {
echo '<TD><small><font color=gray>' . $categories_RET[substr($column, 9)][1]['TITLE'] . ': </font></small><b> ' . $referral[$column] . '</b></TD>';
} else {
} else {
//modif Francois: school year over one/two calendar years format
//DrawHeader(_('School Year').': '.UserSyear().'-'.(UserSyear()+1));
DrawHeader(_('School Year') . ': ' . FormatSyear(UserSyear(), Config('SCHOOL_SYEAR_OVER_2_YEARS')));
}
//modif Francois: css WPadmin
echo '<BR />';
foreach ($referrals as $referral) {
//echo '<TABLE cellpadding=5><TR>';
if ($_REQUEST['elements']['ENTRY_DATE']) {
// echo '<TD><span style="color:gray">'._('Date').': </span><b>'.ProperDate($referral['ENTRY_DATE']).'</b></TD>';
DrawHeader('<span style="color:gray">' . _('Date') . ': </span><b>' . ProperDate($referral['ENTRY_DATE']) . '</b>');
}
if ($_REQUEST['elements']['STAFF_ID']) {
// echo '<TD><span style="color:gray">'._('Reporter').': </span><b>'.GetTeacher($referral['STAFF_ID']).'</b></TD>';
DrawHeader('<span style="color:gray">' . _('Reporter') . ': </span><b>' . GetTeacher($referral['STAFF_ID']) . '</b>');
}
$end_tr = false;
foreach ($_REQUEST['elements'] as $column => $Y) {
if ($column == 'ENTRY_DATE' || $column == 'STAFF_ID') {
continue;
}
if ($categories_RET[mb_substr($column, 9)][1]['DATA_TYPE'] == 'textarea' && !$end_tr) {
$end_tr = true;
//echo '</TR></TABLE>';
} elseif ($categories_RET[mb_substr($column, 9)][1]['DATA_TYPE'] == 'textarea') {
echo '<BR />';
}
if ($categories_RET[mb_substr($column, 9)][1]['DATA_TYPE'] != 'textarea') {
if ($categories_RET[mb_substr($column, 9)][1]['DATA_TYPE'] == 'checkbox') {
DrawHeader('<span style="color:gray">' . $categories_RET[mb_substr($column, 9)][1]['TITLE'] . ': </span> ' . ($referral[$column] == 'Y' ? '<img src="assets/check.png" class="alignImg" />' : '<img src="assets/x.png" class="alignImg" />'));
