Example #1
0
function PopTable($action, $title = 'Search', $table_att = '', $cell_padding = '5')
{
    global $_ROSARIO;
    if ($action == 'header') {
        //modif Francois: css WPadmin
        if (!empty($_REQUEST['_ROSARIO_PDF'])) {
            echo '<TABLE class="cellpadding-6" ' . $table_att . '>';
            echo '<TR><TD class="width-100p center" style="background-color:' . Preferences('HEADER') . ';">';
        } else {
            echo '<TABLE class="postbox cellspacing-0 cellpadding-0" ' . $table_att . '>';
            echo '<TR><TD class="center">';
        }
        if (is_array($title)) {
            echo WrapTabs($title, $_ROSARIO['selected_tab']);
        } else {
            echo DrawTab($title);
        }
        echo '</TD></TR>
		<TR><TD>';
        // Start content table.
        echo '<TABLE style="padding:' . $cell_padding . 'px;" class="width-100p cellspacing-0"><tr><td>';
    } elseif ($action == 'footer') {
        // Close embeded table.
        echo '</td></tr></TABLE>';
        echo '</TD>
		</TR>
		</TABLE>';
    }
}
Example #2
0
function PopTableCustom($action, $title = 'Search', $table_att = '', $cell_padding = '5')
{
    global $_CENTRE;
    if ($action == 'header') {
        echo "<CENTER>\n\t\t\t<TABLE cellpadding=0 cellspacing=0 {$table_att}>";
        echo "<TR><TD align=center colspan=3>";
        if (is_array($title)) {
            echo WrapTabs($title, $_CENTRE['selected_tab']);
        } else {
            echo DrawTab($title);
        }
        echo "</TD></TR>\n\t\t\t<TR><TD background=assets/left_shadow.gif width=4  rowspan=2>&nbsp;</TD><TD background=assets/bottom.gif height=7></TD><TD background=assets/right_shadow.gif width=4  rowspan=2></TD></TR><TR><TD bgcolor=white>";
        // Start content table.
        echo "<TABLE cellpadding=" . $cell_padding . " cellspacing=0 width=100%><tr><td bgcolor=white>";
    } elseif ($action == 'footer') {
        // Close embeded table.
        echo "</td></tr></TABLE>";
        // 2nd cell is for shadow.....
        echo "</TD>\n\t\t</TR>\n\t\t<TR>\n\t\t\t<TD background=assets/left_corner_shadow.gif height=6 width=4></TD>\n\t\t\t<TD background=assets/bottom_shadow.gif height=6></TD>\n\t\t\t<TD height=6 width=4 background=assets/right_corner_shadow.gif></TD>\n\t\t</TR></TABLE></CENTER>";
    }
}
Example #3
0
        DrawHeader(DateInputAY($date, 'date', 4) . $date_note);
        echo '</div>';
    }
}
//echo '<input type=hidden name=period value='.$_REQUEST['period'].' />';
echo "<div style='padding-left:10px; padding-top:8px; float:left;'><input type='button' value='Go' class='btn_medium' onClick='document.location.href=\"Modules.php?modname=users/TeacherPrograms.php?include=attendance/TakeAttendance.php&amp;period=" . strip_tags(trim($_REQUEST[period])) . "&amp;include=attendance/TakeAttendance.php&amp;day_date=\"+this.form.day_date.value+\"&amp;year_date=\"+this.form.year_date.value+\"&amp;table=0&amp;month_date=\"+this.form.month_date.value;' /></div><div style='clear:both;'></div>";
DrawHeader($note, $note1);
$LO_columns = array('FULL_NAME' => 'Student', 'STUDENT_ID' => 'Student ID', 'GRADE_ID' => 'Grade') + $columns;
$tabs[] = array('title' => 'Attendance', 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=0&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}");
$categories_RET = DBGet(DBQuery('SELECT ID,TITLE FROM attendance_code_categories WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
foreach ($categories_RET as $category) {
    $tabs[] = array('title' => $category['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&table={$category['ID']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}");
}
echo '<BR>';
if (count($categories_RET)) {
    echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&table={$_REQUEST['table']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}") . '</CENTER>';
    $extra = array('download' => true, 'search' => true);
    $singular = 'Student';
    $plural = 'Students';
} else {
    $extra = array();
    $singular = 'Student';
    $plural = 'Students';
}
if (!$mp_id) {
    echo "<table align=center><tr><td class=note></td><td class=note_msg>The selected date is not in a school quarter.</td></tr></table>";
} else {
    if (count($course_RET) != 0) {
        echo '<div style="overflow:auto; width:840px;">';
        $posted_date2 = ucfirst(strtolower($_REQUEST['month_date'])) . '-' . $_REQUEST['day_date'] . '-' . $_REQUEST['year_date'];
        if ($_REQUEST['month_date'] && $_REQUEST['day_date'] && $_REQUEST['year_date']) {
Example #4
0
        }
        $LO_columns += array('SORT_ORDER' => _('Sort Order'), 'COLOR' => _('Color'));
        $link['add']['html'] = array('TITLE' => _makeTypeInput('', 'TITLE'), 'SORT_ORDER' => _makeTypeInput('', 'SORT_ORDER'), 'COLOR' => _makeColorInput('', 'COLOR'));
        if (Preferences('WEIGHT', 'Gradebook') == 'Y') {
            $link['add']['html']['FINAL_GRADE_PERCENT'] = _makeTypeInput('', 'FINAL_GRADE_PERCENT');
        }
        $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new&allow_edit={$_REQUEST['allow_edit']}";
        $link['remove']['variables'] = array('id' => 'ASSIGNMENT_TYPE_ID');
        $link['add']['html']['remove'] = button('add');
        $tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new&allow_edit={$_REQUEST['allow_edit']}");
        $subject = 'Assignmemt Types';
    }
    echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>";
    DrawHeader(CheckBoxOnclick('allow_edit') . ' ' . _('Edit'), SubmitButton(_('Save')));
    echo '<BR>';
    $LO_options = array('save' => false, 'search' => false, 'header_color' => $types_RET[$_REQUEST['tab_id']][1]['COLOR'], 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}&allow_edit={$_REQUEST['allow_edit']}"));
    if ($subject == 'Assignments') {
        ListOutput($LO_ret, $LO_columns, _('Assignment'), _('Assignments'), $link, array(), $LO_options);
    } else {
        ListOutput($LO_ret, $LO_columns, _('Assignment Type'), _('Assignment Types'), $link, array(), $LO_options);
    }
    echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
    echo '</FORM>';
}
function _makeAssnInput($value, $name)
{
    global $THIS_RET, $type_options;
    if ($THIS_RET['ASSIGNMENT_ID']) {
        $id = $THIS_RET['ASSIGNMENT_ID'];
    } else {
        $id = 'new';
Example #5
0
}
if (!$_REQUEST['modfunc']) {
    $sql = 'SELECT TITLE,VALUE, id as ID FROM honor_roll WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY VALUE';
    $functions = array('TITLE' => '_makeTextInput', 'VALUE' => 'makeTextInputt');
    $LO_columns = array('TITLE' => 'Honor Roll', 'VALUE' => 'Breakoff');
    $link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'VALUE' => makeTextInputt('', 'VALUE'));
    $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
    $link['remove']['variables'] = array('id' => 'ID');
    $link['add']['html']['remove'] = button('add');
    $LO_ret = DBGet(DBQuery($sql), $functions);
    $tabs = array();
    $tabs[] = array('title' => 'Honor Roll Setup');
    echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
    echo '<BR>';
    echo '<style type="text/css">#div_margin { margin-top:-20px; _margin-top:-1px; }</style>';
    echo WrapTabs($tabs, "");
    echo '<div id="div_margin">';
    PopTable_wo_header('header');
    ListOutputMod($LO_ret, $LO_columns, '', '', $link, array(), array('count' => false, 'download' => false, 'search' => false));
    echo '<BR>';
    echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_honor_roll();"') . '</CENTER>';
    PopTable('footer');
    echo '</div>';
    echo '</FORM>';
}
function _makeTextInput($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ID']) {
        $id = $THIS_RET['ID'];
    } else {
function PopTableforWindow($action, $title = 'Search', $table_att = '', $cell_padding = '0')
{
    global $_openSIS;
    if ($action == 'header') {
        echo "<CENTER>\r\n\t\t\t<TABLE align=left cellpadding=0 cellspacing=0 {$table_att}>";
        echo "<TR><TD >";
        if (is_array($title)) {
            echo WrapTabs($title, $_openSIS['selected_tab']);
        } else {
            echo "</TD></TR>\r\n\t\t\t<TR><TD>";
        }
        // Start content table.
        echo "<TABLE cellpadding=" . $cell_padding . " cellspacing=0 ><tr><td width=10></td><td >\r\n\t\t<div class='inside_block_top'></div>\r\n        <div class='content_block'>";
    } elseif ($action == 'footer') {
        // Close embeded table.
        echo "</div><div class='content_bottom'></div>";
        echo "</td></tr></TABLE>";
        // 2nd cell is for shadow.....
        echo "</TD></TR></TABLE></CENTER>";
    }
}
if ($meal_RET) {
    echo '<TABLE class="width-100p">';
    echo '<TR><TD class="center">';
    echo '<B>Today\'s ' . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . ':</B> ' . $meal_RET[1]['DESCRIPTION'];
    echo '</TD></TR></TABLE><HR>';
}
$items_RET = DBGet(DBQuery('SELECT fsi.ITEM_ID,fsi.DESCRIPTION,fsmi.DOES_COUNT,(SELECT COUNT FROM FOOD_SERVICE_COMPLETED WHERE STAFF_ID=\'' . User('STAFF_ID') . '\' AND SCHOOL_DATE=\'' . $date . '\' AND PERIOD_ID=\'' . UserPeriod() . '\' AND ITEM_ID=fsi.ITEM_ID AND MENU_ID=fsmi.MENU_ID) AS COUNT FROM FOOD_SERVICE_ITEMS fsi,FOOD_SERVICE_MENU_ITEMS fsmi WHERE fsmi.MENU_ID=\'' . $_REQUEST['menu_id'] . '\' AND fsi.ITEM_ID=fsmi.ITEM_ID AND fsmi.DOES_COUNT IS NOT NULL ORDER BY fsmi.SORT_ORDER'), array('COUNT' => 'makeTextInput'));
echo '<TABLE class="width-100p"><TR><TD style="width:50%;">';
$LO_columns = array('DESCRIPTION' => _('Item'), 'COUNT' => _('Count'));
if (count($menus_RET) > 1) {
    $tabs = array();
    foreach ($menus_RET as $id => $meal) {
        $tabs[] = array('title' => $meal[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}&day_date={$_REQUEST['day_date']}&month_date={$_REQUEST['month_date']}&year_date={$_REQUEST['year_date']}");
    }
    echo '<BR />';
    echo '<span class="center">' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}&day_date={$_REQUEST['day_date']}&month_date={$_REQUEST['month_date']}&year_date={$_REQUEST['year_date']}") . '</span>';
    $extra = array('count' => false, 'download' => false, 'search' => false);
} else {
    $extra = array('search' => false);
    $plural = $menus_RET[1][1]['TITLE'] . ' ' . _('Items');
    $singular = $menus_RET[1][1]['TITLE'] . ' ' . _('Item');
}
ListOutput($items_RET, $LO_columns, $singular, $plural, false, false, $extra);
echo '<span class="center">' . SubmitButton(_('Save')) . '</CENTRE>';
echo '</TD><TD style="width:50%;">';
$extra['SELECT'] .= ',fsa.BALANCE,fssa.STATUS';
$extra['FROM'] .= ',FOOD_SERVICE_ACCOUNTS fsa,FOOD_SERVICE_STUDENT_ACCOUNTS fssa';
$extra['WHERE'] .= ' AND fssa.STUDENT_ID=s.STUDENT_ID AND fsa.ACCOUNT_ID=fssa.ACCOUNT_ID AND fssa.STATUS IS NOT NULL';
if (!$extra['functions']) {
    $extra['functions'] = array();
}
Example #8
0
        $link['remove']['variables'] = array('id' => 'ID');
        $tabs[] = array('title' => button('add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=new");
    } else {
        $sql = "SELECT ID,TITLE,SORT_ORDER FROM ATTENDANCE_CODE_CATEGORIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER,TITLE";
        $functions = array('TITLE' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput');
        $LO_columns = array('TITLE' => 'Title', 'SORT_ORDER' => 'Sort Order');
        $link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'));
        $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&table=new";
        $link['remove']['variables'] = array('id' => 'ID');
        $tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=new");
    }
    $LO_ret = DBGet(DBQuery($sql), $functions);
    echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&table={$_REQUEST['table']} method=POST>";
    DrawHeader('', SubmitButton(_('Save')));
    echo '<BR>';
    echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&table={$_REQUEST['table']}") . '</CENTER>';
    ListOutput($LO_ret, $LO_columns, '.', '.', $link, array(), array('count' => false, 'download' => false, 'search' => false));
    echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
    echo '</FORM>';
}
function _makeTextInput($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ID']) {
        $id = $THIS_RET['ID'];
    } else {
        $id = 'new';
    }
    if ($name == 'SHORT_NAME' || $name == 'SORT_ORDER') {
        $extra = 'size=5 maxlength=10';
    }
        $link['add']['html']['remove'] = button('add');
    } else {
        $sql = 'SELECT * FROM REPORT_CARD_COMMENTS WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' AND COURSE_ID IS NULL ORDER BY SORT_ORDER';
        $functions = array('SORT_ORDER' => 'makeTextInput', 'TITLE' => 'makeTextInput');
        $LO_columns = array('SORT_ORDER' => 'ID', 'TITLE' => 'Comment');
        $link['add']['html'] = array('SORT_ORDER' => makeTextInput('', 'SORT_ORDER'), 'TITLE' => makeTextInput('', 'TITLE'));
        $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new";
        $link['remove']['variables'] = array('id' => 'ID');
        $link['add']['html']['remove'] = button('add');
    }
    $LO_ret = DBGet(DBQuery($sql), $functions);
    echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&course_id={$_REQUEST['course_id']}&tab_id={$_REQUEST['tab_id']} method=POST>";
    DrawHeaderHome($course_select, SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_grade_comment();"'));
    #echo '<BR>';
    echo '<style type="text/css">#div_margin { margin-top:-20px; _margin-top:-1px; }</style>';
    echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&course_id={$_REQUEST['course_id']}&tab_id={$_REQUEST['tab_id']}") . '</CENTER>';
    echo '<div id="div_margin">';
    PopTable_wo_header('header');
    echo "<table width=300px height=120px><tr><td>";
    //hack for an empty poptable
    ListOutputMod($LO_ret, $LO_columns, '', '', $link, array(), array('count' => false, 'download' => false, 'search' => false));
    echo "</td></tr></table>";
    PopTable('footer');
    echo '</div>';
    echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_grade_comment();"') . '</CENTER>';
    echo '</FORM>';
}
function makeGradesInput($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ID']) {
Example #10
0
    }
}
$columns = array('FULL_NAME' => 'Teacher');
if (!$_REQUEST['period']) {
    foreach ($periods_RET as $period) {
        $columns[$period['PERIOD_ID']] = $period['TITLE'];
    }
}
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
DrawHeader(PrepareDate($date, '_date') . ' : ' . $period_select . ' : <INPUT type=submit value=' . _('Go') . '>');
echo '</FORM>';
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=add&menu_id={$_REQUEST['menu_id']} method=POST>";
if (count($menus_RET) > 1) {
    $tabs = array();
    foreach ($menus_RET as $id => $menu) {
        $tabs[] = array('title' => $menu[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}");
    }
    echo '<BR>';
    echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}") . '</CENTER>';
}
echo '<TABLE width=100%><TR><TD>';
$singular = sprintf(_('Teacher who takes %s counts'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
$plural = sprintf(_('Teachers who take %s counts'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
ListOutput($staff_RET, $columns, $singular, $plural);
echo '</TD></TR>';
$totals = array_values($totals);
unset($totals[0]);
echo '<TR><TD>';
ListOutput($totals, array('DESCRIPTION' => _('Item'), 'COUNT' => _('Total Count')), _('Item Total'), _('Item Totals'));
echo '</TD></TR></TABLE>';
echo '</FORM>';
         PopTable_grade_header('header');
         echo "<TABLE align=center><TR><TD>";
         echo SelectInput(null, 'new_sms', 'New Marking Period', $mpoptions, false, null);
         echo "</TD>";
         echo "<TD WIDTH=14%></TD>";
         echo "<TD>";
         echo $sms_grade_level;
         echo "</TD></TR></TABLE>";
         PopTable('footer');
     }
 } else {
     echo '<tr><td align=right width=50% valign=top>Grade:</td><td width=50% valign=top>' . $sms_grade_level . '</td></tr><tr><td class=clear></td></tr></table>';
     $tabs = array();
     $tabs[] = array('title' => 'grades', 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=grades&mp_id={$mp_id}");
     $tabs[] = array('title' => 'Credits', 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=credits&mp_id={$mp_id}");
     echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$tab_id}&mp_id={$mp_id}") . '</CENTER>';
     $sql = 'SELECT ID,COURSE_TITLE,GRADE_PERCENT,GRADE_LETTER,
             IF(ISNULL(UNWEIGHTED_GP),  WEIGHTED_GP,UNWEIGHTED_GP ) AS GP,WEIGHTED_GP as WEIGHTED_GP,
             GP_SCALE,CREDIT_ATTEMPTED,CREDIT_EARNED,CREDIT_CATEGORY
                FROM student_report_card_grades WHERE STUDENT_ID = ' . $student_id . ' AND MARKING_PERIOD_ID = ' . $mp_id . ' ORDER BY ID';
     //build forms based on tab selected
     if ($_REQUEST['tab_id'] == 'grades' || $_REQUEST['tab_id'] == '') {
         $functions = array('COURSE_TITLE' => 'makeTextInput', 'GRADE_PERCENT' => 'makeTextInput', 'GRADE_LETTER' => 'makeTextInput', 'GP' => 'makeTextInput', 'WEIGHTED_GP' => 'makeCheckboxInput', 'GP_SCALE' => 'makeTextInput');
         $LO_columns = array('COURSE_TITLE' => 'Course Name', 'GRADE_PERCENT' => 'Percentage', 'GRADE_LETTER' => 'Letter Grade', 'GP' => 'GP Value', 'WEIGHTED_GP' => 'Weighted GP', 'GP_SCALE' => 'Grade Scale');
         $link['add']['html'] = array('COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'GRADE_PERCENT' => makeTextInput('', 'GRADE_PERCENT'), 'GRADE_LETTER' => makeTextInput('', 'GRADE_LETTER'), 'GP' => makeTextInput('', 'GP'), 'WEIGHTED_GP' => makeCheckboxInput('', 'WEIGHTED_GP'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'));
     } else {
         $functions = array('COURSE_TITLE' => 'makeTextInput', 'CREDIT_ATTEMPTED' => 'makeTextInput', 'CREDIT_EARNED' => 'makeTextInput', 'CREDIT_CATEGORY' => 'makeTextInput');
         $LO_columns = array('COURSE_TITLE' => 'Course Name', 'CREDIT_ATTEMPTED' => 'Credit Attempted', 'CREDIT_EARNED' => 'Credit Earned', 'CREDIT_CATEGORY' => 'Credit Category');
         $link['add']['html'] = array('COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'CREDIT_ATTEMPTED' => makeTextInput('', 'CREDIT_ATTEMPTED'), 'CREDIT_EARNED' => makeTextInput('', 'CREDIT_EARNED'), 'CREDIT_CATEGORY' => makeTextInput('', 'CREDIT_CATEGORY'));
     }
     $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&mp_id={$mp_id}";
Example #12
0
        $sql = 'SELECT * FROM REPORT_CARD_GRADE_SCALES WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER,ID';
        $functions = array('TITLE' => 'makeTextInput', 'GP_SCALE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'HHR_GPA_VALUE' => 'makeGradesInput', 'HR_GPA_VALUE' => 'makeGradesInput', 'SORT_ORDER' => 'makeTextInput');
        $LO_columns = array('TITLE' => _('Gradescale'), 'GP_SCALE' => _('Scale Value'), 'COMMENT' => _('Comment'), 'HHR_GPA_VALUE' => _('High Honor Roll GPA Min'), 'HR_GPA_VALUE' => _('Honor Roll GPA Min'), 'SORT_ORDER' => _('Sort Order'));
        $link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'), 'COMMENT' => makeTextInput('', 'COMMENT'), 'HHR_GPA_VALUE' => makeGradesInput('', 'HHR_GPA_VALUE'), 'HR_GPA_VALUE' => makeGradesInput('', 'HR_GPA_VALUE'), 'SORT_ORDER' => makeTextInput('', 'SORT_ORDER'));
        $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new";
        $link['remove']['variables'] = array('id' => 'ID');
        $link['add']['html']['remove'] = button('add');
        $tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
        $singular = 'Grade Scale';
        $plural = 'Grade Scales';
    }
    $LO_ret = DBGet(DBQuery($sql), $functions);
    echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>";
    DrawHeader('', SubmitButton(_('Save')));
    echo '<BR>';
    $LO_options = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}"));
    ListOutput($LO_ret, $LO_columns, $singular, $plural, $link, array(), $LO_options);
    echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
    echo '</FORM>';
}
function makeGradesInput($value, $name)
{
    global $THIS_RET, $grade_scale_select, $teacher_id, $config_RET;
    if ($THIS_RET['ID']) {
        $id = $THIS_RET['ID'];
    } else {
        $id = 'new';
    }
    if ($name == 'GRADE_SCALE_ID') {
        return SelectInput($value, "values[{$id}][{$name}]", '', $grade_scale_select, false);
    } elseif ($name == 'COMMENT') {
Example #13
0
    for ($i = 1; $i <= $max_current_commentsB; $i++) {
        $LO_columns += array('CB' . $i => sprintf(_('Comment %d'), $i));
    }
    if (count($commentsB_select) && AllowEdit() && !isset($_REQUEST['_CENTRE_PDF'])) {
        $LO_columns += array('CB' . $i => _('Add Comment'));
    }
}
if (!$hide_non_attendance_comment || $course_RET[1]['ATTENDANCE'] == 'Y') {
    $LO_columns += array('COMMENT' => _('Comment'));
}
foreach ($categories_RET as $id => $category) {
    $tabs[] = array('title' => $category[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&mp={$_REQUEST['mp']}&tab_id={$id}") + ($category[1]['COLOR'] ? array('color' => $category[1]['COLOR']) : array());
}
$LO_options = array('yscroll' => true, 'save' => false, 'search' => false);
if (count($categories_RET) && GetMP($_REQUEST['mp'], 'DOES_COMMENTS') == 'Y') {
    $LO_options['header'] = WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&mp={$_REQUEST['mp']}&tab_id={$_REQUEST['tab_id']}");
    if ($categories_RET[$_REQUEST['tab_id']][1]['COLOR']) {
        $LO_options['header_color'] = $categories_RET[$_REQUEST['tab_id']][1]['COLOR'];
    }
}
ListOutput($stu_RET, $LO_columns, 'Student', 'Students', false, array(), $LO_options);
echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
echo "</FORM>";
function _makeLetterPercent($student_id, $column)
{
    global $THIS_RET, $current_RET, $import_RET, $grades_select, $student_count, $tabindex, $grade_scale_id, $does_letter_percent;
    if ($import_RET[$student_id]) {
        $select_percent = $import_RET[$student_id][1]['GRADE_PERCENT'];
        $select_grade = $import_RET[$student_id][1]['REPORT_CARD_GRADE_ID'];
        $div = false;
    } else {
Example #14
0
}
//modif Francois: add label on checkbox
DrawHeader($type_select . $assignment_select, $_REQUEST['assignment_id'] ? SubmitButton(_('Save')) : '', '<label>' . CheckBoxOnclick('include_inactive') . '&nbsp;' . _('Include Inactive Students') . '</label> &nbsp;<label>' . CheckBoxOnclick('include_all') . '&nbsp;' . _('Include Inactive Assignments') . '</label>');
if ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'all') {
    $assigned_date = $assignments_RET[$_REQUEST['assignment_id']][1]['ASSIGNED_DATE'];
    $due_date = $assignments_RET[$_REQUEST['assignment_id']][1]['DUE_DATE'];
    $due = $assignments_RET[$_REQUEST['assignment_id']][1]['DUE'];
    DrawHeader('<b>' . Localize('colon', _('Assigned Date')) . '</b> ' . ($assigned_date ? ProperDate($assigned_date) : _('N/A')) . ', <b>' . Localize('colon', _('Due Date')) . '</b> ' . ($due_date ? ProperDate($due_date) : _('N/A')) . ($due ? ' - <b>' . _('Assignment is Due') . '</b>' : ''));
}
if ($_REQUEST['type_id'] && $types_RET[$_REQUEST['type_id']][1]['COLOR']) {
    $LO_options['header_color'] = $types_RET[$_REQUEST['type_id']][1]['COLOR'];
}
if (!UserStudentID() && $_REQUEST['assignment_id'] == 'all') {
    $LO_options['yscroll'] = true;
}
$LO_options['header'] = WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&type_id=" . ($_REQUEST['type_id'] ? $_REQUEST['type_id'] : ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'all' ? $assignments_RET[$_REQUEST['assignment_id']][1]['ASSIGNMENT_TYPE_ID'] : '')) . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}");
ListOutput($stu_RET, $LO_columns, $item, $items, $link, array(), $LO_options);
echo $_REQUEST['assignment_id'] ? '<span class="center">' . SubmitButton(_('Save')) . '</span>' : '';
echo '</FORM>';
function _makeExtraAssnCols($assignment_id, $column)
{
    global $THIS_RET, $assignments_RET, $current_RET, $points_RET, $tabindex, $max_allowed, $total, $programconfig;
    switch ($column) {
        case 'POINTS':
            $tabindex++;
            if (!$assignment_id) {
                $total = $total_points = 0;
                if (count($points_RET[$THIS_RET['STUDENT_ID']])) {
                    foreach ($points_RET[$THIS_RET['STUDENT_ID']] as $partial_points) {
                        if ($partial_points['PARTIAL_TOTAL'] != 0 || $programconfig[User('STAFF_ID')]['WEIGHT'] != 'Y') {
                            $total += $partial_points['PARTIAL_POINTS'];
        $link['add']['html'] = array('TITLE' => makeCommentsInput('', 'TITLE'), 'SCALE_ID' => makeCommentsInput('', 'SCALE_ID'), 'SORT_ORDER' => makeCommentsInput('', 'SORT_ORDER'));
        $link['remove']['link'] = 'Modules.php?modname=' . $_REQUEST['modname'] . '&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id'] . '&tab_id=' . $_REQUEST['tab_id'];
        $link['remove']['variables'] = array('id' => 'ID');
        $link['add']['html']['remove'] = button('add');
        if (User('PROFILE') == 'admin') {
            $tabs[] = array('title' => button('add', '', '', 14), 'link' => 'Modules.php?modname=' . $_REQUEST['modname'] . '&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id'] . '&tab_id=new');
        }
    }
    $LO_ret = DBGet(DBQuery($sql), $functions);
    echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=update&course_id=' . $_REQUEST['course_id'] . '&tab_id=' . $_REQUEST['tab_id'] . '" method="POST">';
    DrawHeader($subject_select . ' : ' . $course_select, SubmitButton(_('Save')));
    //modif Francois: fix SQL bug invalid sort order
    if (isset($error)) {
        echo $error;
    }
    $LO_options = array('save' => false, 'search' => false, 'header_color' => $categories_RET[$_REQUEST['tab_id']][1]['COLOR'], 'header' => WrapTabs($tabs, 'Modules.php?modname=' . $_REQUEST['modname'] . '&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id'] . '&tab_id=' . $_REQUEST['tab_id']));
    //ListOutput($LO_ret,$LO_columns,$singular,$plural,$link,array(),$LO_options);
    if ($_REQUEST['tab_id'] == 'new') {
        ListOutput($LO_ret, $LO_columns, 'Category', 'Categories', $link, array(), $LO_options);
    } else {
        ListOutput($LO_ret, $LO_columns, 'Comment', 'Comments', $link, array(), $LO_options);
    }
    echo '<span class="center">' . SubmitButton(_('Save')) . '</span>';
    echo '</FORM>';
}
function makeTextInput($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ID']) {
        $id = $THIS_RET['ID'];
    } else {
Example #16
0
foreach ($menus_RET as $id => $menu) {
    $meals[] = array('title' => $menu[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}");
}
$cats = array();
foreach ($categories_RET[$_REQUEST['menu_id']] as $category_id => $category) {
    $cats[] = array('title' => $category[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&cat_id={$category_id}");
}
$items_RET = DBGet(DBQuery("SELECT *,(SELECT ICON FROM FOOD_SERVICE_ITEMS WHERE ITEM_ID=fsmi.ITEM_ID) AS ICON FROM FOOD_SERVICE_MENU_ITEMS fsmi WHERE MENU_ID='{$_REQUEST['menu_id']}' AND CATEGORY_ID='{$_REQUEST['cat_id']}' ORDER BY (SELECT SORT_ORDER FROM FOOD_SERVICE_CATEGORIES WHERE CATEGORY_ID=fsmi.CATEGORY_ID),SORT_ORDER"));
echo '<BR>';
echo '<CENTER>' . WrapTabs($meals, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}") . '</CENTER>';
if (count($items_RET)) {
    $per_row = ceil(sqrt(count($items_RET)));
    echo '<CENTER><TABLE border=1 bgcolor=white>';
    foreach ($items_RET as $item) {
        if (!$i) {
            echo '<TR bgcolor=red>';
            $i = $per_row;
        }
        echo '<TD><IMG src=' . $FS_IconsPath . '/' . $item['ICON'] . ' width=125></TD>';
        $i--;
        if (!$i) {
            echo '</TR>';
        }
    }
    if ($i) {
        echo '</TR>';
    }
    echo '</TABLE></CENTER>';
}
echo '<CENTER>' . WrapTabs($cats, "Modules.php?modname={$_REQUEST['modname']}&cat_id={$_REQUEST['cat_id']}", '', false, '_lower') . '</CENTER>';
Example #17
0
        if ($value == 0) {
            unset($types_columns[$key]);
        }
    }
    $LO_types[] = array(array('TYPE' => '<b>' . _('Totals') . '</b>', 'ELLIGIBLE' => '<b>' . number_format($users_totals['']['ELLIGIBLE'], 1) . '</b>', 'DAYS_POSSIBLE' => '<b>' . number_format(empty($users_totals['']['ELLIGIBLE']) ? 0 : $users_totals['']['DAYS'] / $users_totals['']['ELLIGIBLE'], 1) . '</b>', 'TOTAL_ELLIGIBLE' => '<b>' . $users_totals['']['DAYS'] . '</b>', 'PARTICIPATED' => '<b>' . $users_totals['']['PARTICIPATED'] . '</b>') + array_map('bold', $types_totals['']));
    unset($LO_types[0]);
    $LO_columns = array('TYPE' => _('Type'), 'DISCOUNT' => _('Discount')) + $users_columns + $types_columns;
}
$PHP_tmp_SELF = PreparePHP_SELF();
echo '<FORM action="' . $PHP_tmp_SELF . '" method="POST">';
DrawHeader(_('Timeframe') . ':' . PrepareDate($start_date, '_start') . ' ' . _('to') . ' ' . PrepareDate($end_date, '_end') . ' : <INPUT type=submit value=' . _('Go') . '>', $type_select);
$tabs = array();
foreach ($menus_RET as $id => $menu) {
    $tabs[] = array('title' => $menu[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}&day_start={$_REQUEST['day_start']}&month_start={$_REQUEST['month_start']}&year_start={$_REQUEST['year_start']}&day_end={$_REQUEST['day_end']}&month_end={$_REQUEST['month_end']}&year_end={$_REQUEST['year_end']}&type_select={$_REQUEST['type_select']}");
}
$LO_options = array('count' => false, 'download' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}&day_start={$_REQUEST['day_start']}&month_start={$_REQUEST['month_start']}&year_start={$_REQUEST['year_start']}&day_end={$_REQUEST['day_end']}&month_end={$_REQUEST['month_end']}&year_end={$_REQUEST['year_end']}&type_select={$_REQUEST['type_select']}"));
ListOutput($LO_types, $LO_columns, '.', '.', array(), array(array('')), $LO_options);
echo '</FORM>';
function format($item)
{
    return number_format($item, 2);
}
function bold($item)
{
    return '<b>' . $item . '</b>';
}
function bold_format($item)
{
    return '<b>' . number_format($item, 2) . '</b>';
}
// days, elligibile, participated
if (count($completed_RET)) {
    $note = ErrorMessage(array('<IMG SRC="assets/check.png" class="alignImg" />&nbsp;' . _('You already have taken attendance today for this period.')), 'note');
}
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&table=' . $_REQUEST['table'] . '" method="POST">';
DrawHeader(PrepareDate($date, '_date', false, array('submit' => true)) . $date_note, SubmitButton(_('Save')));
//DrawHeader($note);
echo $note;
$LO_columns = array('FULL_NAME' => _('Student'), 'STUDENT_ID' => _('RosarioSIS ID'), 'GRADE_ID' => _('Grade Level')) + $columns;
//$tabs[] = array('title'=>'Attendance','link'=>"Modules.php?modname=$_REQUEST[modname]&table=0&month_date=$_REQUEST[month_date]&day_date=$_REQUEST[day_date]&year_date=$_REQUEST[year_date]");
//$categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM ATTENDANCE_CODE_CATEGORIES WHERE SYEAR='".UserSyear()."' AND SCHOOL_ID='".UserSchool()."'"));
foreach ($categories_RET as $category) {
    $tabs[] = array('title' => ParseMLField($category['TITLE']), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table={$category['ID']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}");
}
echo '<BR />';
if (count($categories_RET)) {
    $LO_options = array('download' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&table={$_REQUEST['table']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}"));
} else {
    $LO_options = array();
}
ListOutput($stu_RET, $LO_columns, 'Student', 'Students', false, array(), $LO_options);
echo '<span class="center">' . SubmitButton(_('Save')) . '</span>';
echo '</FORM>';
function _makeRadio($value, $title)
{
    global $THIS_RET, $current_RET;
    $colors = array('P' => '#00FF00', 'A' => '#FF0000', 'H' => '#FFCC00', 'T' => '#0000FF');
    if ($current_RET[$THIS_RET['STUDENT_ID']][1]['ATTENDANCE_TEACHER_CODE'] == mb_substr($title, 5)) {
        return '<TABLE style="margin:0 auto; ' . ($current_RET[$THIS_RET['STUDENT_ID']][1]['COURSE_PERIOD_ID'] == UserCoursePeriod() ? $colors[$value] ? ' background-color:' . $colors[$value] . ';' : '' : ' background-color:#000000;') . '"><TR><TD><INPUT type="radio" name="attendance[' . $THIS_RET['STUDENT_ID'] . ']" value="' . $title . '" checked /></TD></TR></TABLE>';
    } else {
        return '<TABLE style="margin:0 auto;"><TR><TD><INPUT type="radio" name="attendance[' . $THIS_RET['STUDENT_ID'] . ']" value="' . $title . '"' . (AllowEdit() ? '' : ' disabled') . '></TD></TR></TABLE>';
    }
Example #19
0
if (isset($categories_RET[$_REQUEST['menu_id']])) {
    foreach ($categories_RET[$_REQUEST['menu_id']] as $category_id => $category) {
        $cats[] = array('title' => $category[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&cat_id={$category_id}");
    }
}
$items_RET = DBGet(DBQuery("SELECT *,(SELECT ICON FROM FOOD_SERVICE_ITEMS WHERE ITEM_ID=fsmi.ITEM_ID) AS ICON FROM FOOD_SERVICE_MENU_ITEMS fsmi WHERE MENU_ID='{$_REQUEST['menu_id']}' AND CATEGORY_ID='{$_REQUEST['cat_id']}' ORDER BY (SELECT SORT_ORDER FROM FOOD_SERVICE_CATEGORIES WHERE CATEGORY_ID=fsmi.CATEGORY_ID),SORT_ORDER"));
echo '<BR />';
echo '<span class="center">' . WrapTabs($meals, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}") . '</span>';
if (count($items_RET)) {
    $per_row = ceil(sqrt(count($items_RET)));
    //modif Francois: css WPadmin
    echo '<TABLE style="padding:4px; margin:0 auto;">';
    foreach ($items_RET as $item) {
        if (!$i) {
            echo '<TR>';
            $i = $per_row;
        }
        echo '<TD style="border: 1px solid black"><IMG src="' . $FS_IconsPath . '/' . $item['ICON'] . '" width="128"></TD>';
        $i--;
        if (!$i) {
            echo '</TR>';
        }
    }
    if ($i) {
        echo '</TR>';
    }
    echo '</TABLE>';
}
//modif Francois: remove WrapTabs params
echo '<span class="center">' . WrapTabs($cats, "Modules.php?modname={$_REQUEST['modname']}&cat_id={$_REQUEST['cat_id']}") . '</span>';
Example #20
0
        }
        echo '</TD></TR>';
        echo '<TR><TD width=100% valign=top>';
        $items_RET = DBGet(DBQuery("SELECT fsi.SHORT_NAME,fsi.DESCRIPTION,fsi.PRICE_STAFF,fsi.ICON FROM FOOD_SERVICE_ITEMS fsi,FOOD_SERVICE_MENU_ITEMS fsmi WHERE fsmi.MENU_ID='" . $_REQUEST['menu_id'] . "' AND fsi.ITEM_ID=fsmi.ITEM_ID AND fsmi.CATEGORY_ID IS NOT NULL AND fsi.SCHOOL_ID='" . UserSchool() . "' ORDER BY fsi.SORT_ORDER"), array('ICON' => 'makeIcon'), array('SHORT_NAME'));
        $items = array();
        foreach ($items_RET as $sn => $item) {
            $items += array($sn => $item[1]['DESCRIPTION']);
        }
        $LO_ret = array(array());
        foreach ($_SESSION['FSA_sale'] as $id => $item_sn) {
            $price = $items_RET[$item_sn][1]['PRICE_STAFF'];
            $LO_ret[] = array('SALE_ID' => $id, 'PRICE' => $price, 'DESCRIPTION' => $items_RET[$item_sn][1]['DESCRIPTION'], 'ICON' => $items_RET[$item_sn][1]['ICON']);
        }
        unset($LO_ret[0]);
        $link['remove'] = array('link' => "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&menu_id={$_REQUEST['menu_id']}", 'variables' => array('id' => 'SALE_ID'));
        $link['add']['html'] = array('DESCRIPTION' => '<TABLE border=0 cellpadding=0 cellspacing=0><TR><TD>' . SelectInput('', 'item_sn', '', $items) . '</TD></TR></TABLE>', 'ICON' => '<TABLE border=0 cellpadding=0 cellspacing=0><TR><TD><INPUT type=submit value=' . _('Add') . '></TD></TR></TABLE>', 'remove' => button('add'));
        $columns = array('DESCRIPTION' => _('Item'), 'ICON' => _('Icon'), 'PRICE' => _('Price'));
        $tabs = array();
        foreach ($menus_RET as $id => $menu) {
            $tabs[] = array('title' => $menu[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}");
        }
        $extra = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}"));
        echo '<BR>';
        echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=add&menu_id={$_REQUEST['menu_id']} method=POST>";
        ListOutput($LO_ret, $columns, _('Item'), _('Items'), $link, array(), $extra);
        echo '</FORM>';
        echo '</TD></TR></TABLE>';
    } else {
        ErrorMessage(array(_('This user does not have a Food Service Account.')), 'fatal');
    }
}
         }
         //$mpselect .= '</SELECT>';
         //echo $mpselect;
         echo '<TABLE class="postbox" style="padding:8px;"><TR><TD>';
         echo SelectInput(null, 'new_sms', _('New Marking Period'), $mpoptions, false, null);
         echo '</TD><TD>';
         echo $sms_grade_level;
         echo '</TD></TR></TABLE>';
     }
 } else {
     echo $sms_grade_level;
     $tabs = array();
     $tabs[] = array('title' => 'Grades', 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=grades&mp_id={$mp_id}");
     $tabs[] = array('title' => 'Credits', 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=credits&mp_id={$mp_id}");
     //modif Francois: css WPadmin
     $LO_options = array('count' => false, 'download' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$tab_id}&mp_id={$mp_id}"));
     //modif Francois: SQL error fix: operator does not exist: character varying = integer, add explicit type casts
     //                $sql = 'SELECT * FROM student_report_card_grades WHERE STUDENT_ID = '.$student_id.' AND MARKING_PERIOD_ID = '.$mp_id.' ORDER BY ID';
     $sql = "SELECT * FROM student_report_card_grades WHERE STUDENT_ID='" . $student_id . "' AND cast(MARKING_PERIOD_ID as integer)='" . $mp_id . "' ORDER BY ID";
     //build forms based on tab selected
     if ($_REQUEST['tab_id'] == 'grades' || $_REQUEST['tab_id'] == '') {
         $functions = array('COURSE_TITLE' => 'makeTextInput', 'GRADE_PERCENT' => 'makeTextInput', 'GRADE_LETTER' => 'makeTextInput', 'WEIGHTED_GP' => 'makeTextInput', 'UNWEIGHTED_GP' => 'makeTextInput', 'GP_SCALE' => 'makeTextInput');
         $LO_columns = array('COURSE_TITLE' => _('Course'), 'GRADE_PERCENT' => _('Percentage'), 'GRADE_LETTER' => _('Grade'), 'WEIGHTED_GP' => _('Grade Points'), 'UNWEIGHTED_GP' => _('Unweighted Grade Points'), 'GP_SCALE' => _('Grade Scale'));
         $link['add']['html'] = array('COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'GRADE_PERCENT' => makeTextInput('', 'GRADE_PERCENT'), 'GRADE_LETTER' => makeTextInput('', 'GRADE_LETTER'), 'WEIGHTED_GP' => makeTextInput('', 'WEIGHTED_GP'), 'UNWEIGHTED_GP' => makeTextInput('', 'UNWEIGHTED_GP'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'));
     } else {
         $functions = array('COURSE_TITLE' => 'makeTextInput', 'CREDIT_ATTEMPTED' => 'makeTextInput', 'CREDIT_EARNED' => 'makeTextInput', 'CREDIT_CATEGORY' => 'makeTextInput', 'CLASS_RANK' => 'makeCheckBoxInput');
         $LO_columns = array('COURSE_TITLE' => _('Course'), 'CREDIT_ATTEMPTED' => _('Credit Attempted'), 'CREDIT_EARNED' => _('Credit Earned'), 'CREDIT_CATEGORY' => _('Credit Category'), 'CLASS_RANK' => _('Affects Class Rank'));
         $link['add']['html'] = array('COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'CREDIT_ATTEMPTED' => makeTextInput('', 'CREDIT_ATTEMPTED'), 'CREDIT_EARNED' => makeTextInput('', 'CREDIT_EARNED'), 'CREDIT_CATEGORY' => makeTextInput('', 'CREDIT_CATEGORY'), 'CLASS_RANK' => makeTextInput('', 'CLASS_RANK'));
     }
     //$link['remove']['link'] = "Modules.php?modname=$_REQUEST[modname]&modfunc=remove&table=student_report_card_grades";
     //$link['remove']['variables'] = array('id'=>'ID');