function for_error()
{
    $css = getCSS();
    echo "<br><br><form action=Modules.php?modname={$_REQUEST['modname']} method=post>";
    echo '<BR><CENTER>' . SubmitButton('Try Again', '', 'class=btn_medium') . '</CENTER>';
    echo "</form>";
    echo "</div>";
    echo "</td>\n                                        </tr>\n                                      </table></td>\n                                  </tr>\n                                </table></td>\n                            </tr>\n                          </table></td>\n                      </tr>\n                    </table></td>\n                </tr>\n              </table></td>\n          </tr>\n\n\t\t\t<tr>\n            <td class=\"footer\">\n\t\t\t<table width=\"100%\" border=\"0\">\n  <tr>\n    <td valign=middle class=\"copyright\">Copyright &copy; 2007-2008 Open Solutions for Education, Inc. (<a href='http://www.os4ed.com' target='_blank'>OS4Ed</a>).</td>\n\t<td valign=bottom class=\"credits\"><a href='http://www.os4ed.com' target='_blank'><img src=\"themes/" . $css . "/os4ed_logo.png\" /></a></td>\n  </tr>\n</table>\n\t\t\t</td>\n          \t</tr>\n        </table></td>\n    </tr>\n  </table>\n</center>\n</body>\n</html>";
    exit;
}
Example #2
0
    #echo '<BR>';
    echo '<CENTER><TABLE cellpadding=6><TR><TD align=right><b>Activity</b></TD>';
    echo '<TD>';
    $activities_RET = DBGet(DBQuery('SELECT ID,TITLE FROM eligibility_activities WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
    echo '<SELECT name=activity_id><OPTION value="">N/A</OPTION>';
    if (count($activities_RET)) {
        foreach ($activities_RET as $activity) {
            echo "<OPTION value={$activity['ID']}>{$activity['TITLE']}</OPTION>";
        }
    }
    echo '</SELECT>';
    echo '</TD>';
    echo '</TR></TABLE><BR>';
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ",NULL AS CHECKBOX";
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type=checkbox value=Y name=controller onclick="checkAll(this.form,this.form.controller.checked,\'student\');"><A>');
    $extra['new'] = true;
}
Widgets('activity');
Widgets('course');
Search('student_id', $extra);
if ($_REQUEST['search_modfunc'] == 'list') {
    //	echo '<BR><CENTER>'.SubmitButton('Add Activity to Selected Students','','class=btn_xlarge onclick=\'formload_ajax("addact");\'')."</CENTER></FORM>";
    echo '<BR><CENTER>' . SubmitButton('Add Activity to Selected Students', '', 'class=btn_xlarge') . "</CENTER></FORM>";
}
function _makeChooseCheckbox($value, $title)
{
    global $THIS_RET;
    return "<INPUT type=checkbox name=student[" . $THIS_RET['STUDENT_ID'] . "] value=Y>";
}
Example #3
0
                                if (count($rank_RET) == 0) {
                                    DBQuery('INSERT INTO program_config (school_id,program,title,value) VALUES(\'' . UserSchool() . '\',\'class_rank\',\'display\',\'Y\')');
                                } else {
                                    DBQuery('UPDATE program_config SET value=\'' . $_REQUEST['display_rank'] . '\' WHERE school_id=\'' . UserSchool() . '\' AND program=\'class_rank\' AND title=\'display\'');
                                }
                                unset($_REQUEST['display_rank']);
                                unset($_SESSION['_REQUEST_vars']['display_rank']);
                            }
                        }
                        $rank_RET = DBGet(DBQuery('SELECT VALUE FROM program_config WHERE school_id=\'' . UserSchool() . '\' AND program=\'class_rank\' AND title=\'display\' LIMIT 0, 1'));
                        $rank = $rank_RET[1];
                        echo "<FORM name=failure id=failure action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&page_display=CLASSRANK method=POST>";
                        echo '<table width="330px;" cellpadding="4">';
                        echo '<tr><td width="92%" align="center">' . _('Display Class Rank') . '?</td><td align="left">' . CheckboxInput($rank['VALUE'], 'display_rank', '', 'class=cell_floating') . '</td></tr>';
                        echo '<tr><td colspan="2"></td></tr>';
                        echo '<tr><td colspan="2"><CENTER>' . SubmitButton(_('Save'), '', 'class=btn_medium') . '</CENTER></td></tr>';
                        echo '</table>';
                        echo '</FORM>';
                        PopTable('footer');
                    } else {
                        echo '
<style type="text/css">
.time_schedule { background:url(assets/time_schedule.png) no-repeat 0px 0px; padding:10px 0px 10px 45px; text-align:left; margin:14px 280px; }
.login_failure { background:url(assets/login_failure.png) no-repeat 0px 0px; padding:10px 0px 10px 45px; text-align:left; margin:14px 280px; }
.user_inactivity { background:url(assets/user_inactivity.png) no-repeat 0px 0px; padding:10px 0px 10px 45px; text-align:left; margin:14px 280px; }
.maintenance { background:url(assets/maintenance.png) no-repeat 0px 0px; padding:10px 0px 10px 45px; text-align:left; margin:14px 280px; }
.currency { background:url(assets/currency.png) no-repeat 0px 0px; padding:10px 0px 10px 45px; text-align:left; margin:14px 280px; }
.class_rank { background:url(assets/class_rank.png) no-repeat 0px 0px; padding:15px 0px 10px 45px; text-align:left; margin:14px 280px; }
</style>

<div style=padding:20px 0px 0px 0px;>';
Example #4
0
    foreach ($schools as $school) {
        $schools_select[$syear][$school['ID']] = $school['TITLE'];
    }
}
//echo '<pre>'; var_dump($schools_select); echo '</pre>';
$students_RET = DBGet(DBQuery("SELECT fst.TRANSACTION_ID,fst.ACCOUNT_ID,fst.SYEAR," . db_case(array('fst.STUDENT_ID', "''", 'NULL', "(SELECT FIRST_NAME||' '||LAST_NAME FROM STUDENTS WHERE STUDENT_ID=fst.STUDENT_ID)")) . " AS FULL_NAME,fst.ACCOUNT_ID AS STUDENTS,fst.SCHOOL_ID FROM FOOD_SERVICE_TRANSACTIONS fst WHERE fst.SCHOOL_ID IS NULL"), array('STUDENTS' => '_students', 'SCHOOL_ID' => '_make_school'));
$staff_RET = DBGet(DBQuery("SELECT fst.TRANSACTION_ID,fst.STAFF_ID,fst.SYEAR,(SELECT FIRST_NAME||' '||LAST_NAME FROM STAFF WHERE STAFF_ID=fst.STAFF_ID) AS FULL_NAME,fst.SCHOOL_ID FROM FOOD_SERVICE_STAFF_TRANSACTIONS fst WHERE fst.SCHOOL_ID IS NULL"), array('SCHOOL_ID' => '_make_staff_school'));
//echo '<pre>'; var_dump($students_RET); echo '</pre>';
//echo '<pre>'; var_dump($users_RET); echo '</pre>';
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
DrawHeader('', SubmitButton(_('Save')));
$columns = array('TRANSACTION_ID' => _('ID'), 'ACCOUNT_ID' => _('Account ID'), 'SYEAR' => _('School Year'), 'FULL_NAME' => _('Student'), 'STUDENTS' => _('Students'), 'SCHOOL_ID' => _('School'));
ListOutput($students_RET, $columns, _('Student Transaction w/o School'), _('Student Transactions w/o School'), false, array(), array('save' => false, 'search' => false));
$columns = array('TRANSACTION_ID' => _('ID'), 'SYEAR' => _('School Year'), 'FULL_NAME' => _('User'), 'SCHOOL_ID' => _('School'));
ListOutput($staff_RET, $columns, _('User Transaction w/o School'), _('User Transactions w/o School'), false, array(), array('save' => false, 'search' => false));
echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
echo '</FORM>';
function _students($value, $column)
{
    $RET = DBGet(DBQuery("SELECT s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fsa WHERE s.STUDENT_ID=fsa.STUDENT_ID AND fsa.ACCOUNT_ID='" . $value . "'"));
    foreach ($RET as $student) {
        $ret .= $student['FULL_NAME'] . '<br>';
    }
    $ret = substr($ret, 0, -4);
    return $ret;
}
function _make_school($value, $column)
{
    global $THIS_RET, $schools_select;
    return SelectInput($value, "student[{$THIS_RET['TRANSACTION_ID']}]", '', $schools_select[$THIS_RET['SYEAR']]);
    //function SelectInput($value,$name,$title='',$options,$allow_na='N/A',$extra='',$div=true)
Example #5
0
        $extra['extra_header_left'] .= '</TABLE>';
    }
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ",s.STUDENT_ID AS CHECKBOX";
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type="checkbox" value="Y" name="controller" checked onclick="checkAll(this.form,this.form.controller.checked,\'st_arr\');"><A>');
    $extra['new'] = true;
    $extra['options']['search'] = false;
    $extra['force_search'] = true;
    //Widgets('course');
    //Widgets('gpa');
    //Widgets('class_rank');
    //Widgets('letter_grade');
    Search('student_id', $extra);
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo '<BR /><span class="center">' . SubmitButton(_('Create Grade Lists for Selected Students')) . '</span>';
        echo "</FORM>";
    }
}
function _makeChooseCheckbox($value, $title)
{
    return '&nbsp;&nbsp;<INPUT type="checkbox" name="st_arr[]" value="' . $value . '" checked />';
}
function _makeTeacher($teacher, $column)
{
    return mb_substr($teacher, mb_strrpos(str_replace(' - ', ' ^ ', $teacher), '^') + 2);
}
function _makeComments($value, $column)
{
    global $THIS_RET;
    return DBGet(DBQuery('SELECT COURSE_PERIOD_ID,REPORT_CARD_COMMENT_ID,COMMENT,(SELECT SORT_ORDER FROM REPORT_CARD_COMMENTS WHERE REPORT_CARD_COMMENT_ID=ID) AS SORT_ORDER FROM STUDENT_REPORT_CARD_COMMENTS WHERE STUDENT_ID=\'' . $THIS_RET['STUDENT_ID'] . '\' AND COURSE_PERIOD_ID=\'' . $THIS_RET['COURSE_PERIOD_ID'] . '\' AND MARKING_PERIOD_ID=\'' . $value . '\' ORDER BY SORT_ORDER'));
Example #6
0
            $columns += array('CB' . $i => 'Comment ' . $i);
        }
        if (count($commentsB_select) && AllowEdit() && !isset($_REQUEST['_openSIS_PDF'])) {
            $columns += array('CB' . $i => 'Add Comment');
        }
        $columns += array('COMMENT' => 'Comment');
    }
    echo "<center>";
    PopTable_wo_header('header');
    echo '<div style="width:800px; overflow-x:scroll;">';
    ListOutput($stu_RET, $columns, 'Student', 'Students', false, false, array('yscroll' => true));
    echo '</div>';
    PopTable('footer');
    echo "</center>";
    if (count($stu_RET) != 0) {
        echo '<CENTER>' . SubmitButton('Save', 'submit[save]', 'class=btn_medium') . '</CENTER>';
    }
    echo "</FORM>";
}
/////////////////sg customization////////
function _makeGrade($value, $column)
{
    global $THIS_RET, $current_RET, $import_RET, $grades_RET, $grades_select, $student_count, $tabindex;
    $tc_grade = 'n';
    if ($column == 'REPORT_CARD_GRADE') {
        if (!isset($_REQUEST['_openSIS_PDF'])) {
            $student_count++;
            $tabindex = $student_count;
            if ($import_RET[$THIS_RET['STUDENT_ID']]) {
                $select = $import_RET[$THIS_RET['STUDENT_ID']][1]['REPORT_CARD_GRADE_ID'];
                $extra_select = array($select => $grades_select[$import_RET[$THIS_RET['STUDENT_ID']][1]['REPORT_CARD_GRADE_ID']]);
Example #7
0
            }
            DrawHeader($extra['extra_header_left'], $extra['extra_header_right']);
            if ($_REQUEST['LO_save'] != '1' && !$extra['suppress_save']) {
                $_SESSION['List_PHP_SELF'] = PreparePHP_SELF($_SESSION['_REQUEST_vars']);
                echo '<script language=JavaScript>parent.help.location.reload();</script>';
            }
            if (!$extra['singular'] || !$extra['plural']) {
                $extra['singular'] = 'Student';
            }
            $extra['plural'] = 'Students';
            echo "<div id='students' >";
            ListOutput($students_RET, $columns, $extra['singular'], $extra['plural'], $link, $extra['LO_group'], $extra['options']);
            echo "</div>";
        }
        if (count($students_RET) > 0) {
            echo '<BR><CENTER>' . SubmitButton('', '', 'class=btn_group_drops onclick=\'formload_ajax("ww");\'') . '</CENTER>';
            echo "</FORM>";
        }
    }
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAEXT) == 'choose_course') {
    if (!clean_param($_REQUEST['course_period_id'], PARAM_INT)) {
        include 'modules/scheduling/CoursesforWindow.php';
    } else {
        $_SESSION['MassDrops.php']['subject_id'] = clean_param($_REQUEST['subject_id'], PARAM_INT);
        $_SESSION['MassDrops.php']['course_id'] = clean_param($_REQUEST['course_id'], PARAM_INT);
        $_SESSION['MassDrops.php']['course_period_id'] = clean_param($_REQUEST['course_period_id'], PARAM_INT);
        $course_title = DBGet(DBQuery('SELECT TITLE FROM courses WHERE COURSE_ID=\'' . $_SESSION['MassDrops.php']['course_id'] . '\''));
        $course_title = $course_title[1]['TITLE'];
        $cp_RET = DBGet(DBQuery('SELECT cp.TITLE,(SELECT TITLE FROM school_periods sp WHERE sp.PERIOD_ID=cpv.PERIOD_ID) AS PERIOD_TITLE,cp.MARKING_PERIOD_ID,(SELECT CONCAT(FIRST_NAME,\'' . ' ' . '\',LAST_NAME) FROM staff st WHERE st.STAFF_ID=cp.TEACHER_ID) AS TEACHER,r.TITLE AS ROOM,cp.TOTAL_SEATS-cp.FILLED_SEATS AS AVAILABLE_SEATS FROM course_periods cp,course_period_var cpv,rooms r WHERE cp.COURSE_PERIOD_ID=\'' . $_SESSION['MassDrops.php']['course_period_id'] . '\' AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND cpv.ROOM_ID=r.ROOM_ID'));
        $cp_title = $cp_RET[1]['TITLE'];
     if ($RET['TYPE'] == 'autos' || $RET['TYPE'] == 'edits' || $RET['TYPE'] == 'select' || $RET['TYPE'] == 'codeds' || $RET['TYPE'] == 'multiple' || $RET['TYPE'] == 'exports' || $_REQUEST['id'] == 'new') {
         $header .= '<TD colspan="2">' . TextAreaInput($RET['SELECT_OPTIONS'], 'tables[' . $_REQUEST['id'] . '][SELECT_OPTIONS]', _('Pull-Down') . '/' . _('Auto Pull-Down') . '/' . _('Coded Pull-Down') . '/' . _('Select Multiple from Options') . '<BR />' . _('* one per line'), 'rows=7 cols=40') . '</TD>';
         $colspan = 1;
     }
     $header .= '<TD style="vertical-align:bottom;" colspan="' . $colspan . '">' . TextInput($RET['DEFAULT_SELECTION'], 'tables[' . $_REQUEST['id'] . '][DEFAULT_SELECTION]', _('Default')) . '<BR />' . _('* for dates: YYYY-MM-DD') . ',<BR />&nbsp;' . _('for checkboxes: Y') . '</TD>';
     $new = $_REQUEST['id'] == 'new';
     $header .= '<TD>' . CheckboxInput($RET['REQUIRED'], 'tables[' . $_REQUEST['id'] . '][REQUIRED]', _('Required'), '', $new) . '</TD>';
     $header .= '</TR>';
     $header .= '</TABLE>';
 } elseif ($_REQUEST['category_id']) {
     echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&table=STUDENT_FIELD_CATEGORIES';
     if ($_REQUEST['category_id'] != 'new') {
         echo '&category_id=' . $_REQUEST['category_id'];
     }
     echo '" method="POST">';
     DrawHeader($title, $delete_button . SubmitButton(_('Save')));
     $header .= '<TABLE class="width-100p cellpadding-3">';
     $header .= '<TR>';
     //modif Francois: title required
     $header .= '<TD>' . MLTextInput($RET['TITLE'], 'tables[' . $_REQUEST['category_id'] . '][TITLE]', (!$RET['TITLE'] ? '<span style="color:red">' : '') . _('Title') . (!$RET['TITLE'] ? '</span>' : ''), 'required') . '</TD>';
     $header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['category_id'] . '][SORT_ORDER]', _('Sort Order'), 'size=5') . '</TD>';
     $header .= '<TD>' . TextInput($RET['COLUMNS'], 'tables[' . $_REQUEST['category_id'] . '][COLUMNS]', _('Display Columns'), 'size=5') . '</TD>';
     $new = $_REQUEST['category_id'] == 'new';
     if ($_REQUEST['category_id'] > 4 || $new) {
         $header .= '<TD>' . TextInput($RET['INCLUDE'], 'tables[' . $_REQUEST['category_id'] . '][INCLUDE]', _('Include (should be left blank for most categories)')) . '</TD>';
     }
     $header .= '</TR>';
     $header .= '</TABLE>';
 } else {
     $header = false;
 }
Example #9
0
function for_error_sch()
{
    $css = getCSS();
    echo "<br><br><form action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . " method=post>";
    echo '<BR><CENTER>' . SubmitButton('Try Again', '', 'class=btn_medium') . '</CENTER>';
    echo "</form>";
    echo "</div>";
    echo "</td>\r\n                                        </tr>\r\n                                      </table></td>\r\n                                  </tr>\r\n                                </table></td>\r\n                            </tr>\r\n                          </table></td>\r\n                      </tr>\r\n                    </table></td>\r\n                </tr>\r\n              </table></td>\r\n          </tr>\r\n\r\n        </table></td>\r\n    </tr>\r\n  </table>\r\n</center>\r\n</body>\r\n</html>";
    exit;
}
Example #10
0
        $extra['extra_header_left'] .= '</TABLE>';
    }
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ",s.STUDENT_ID AS CHECKBOX";
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type=checkbox value=Y name=controller checked onclick="checkAll(this.form,this.form.controller.checked,\'st_arr\');"><A>');
    $extra['new'] = true;
    $extra['options']['search'] = false;
    $extra['force_search'] = true;
    //Widgets('course');
    //Widgets('gpa');
    //Widgets('class_rank');
    //Widgets('letter_grade');
    Search('student_id', $extra);
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo '<BR><CENTER>' . SubmitButton(_('Create Grade Lists for Selected Students')) . '</CENTER>';
        echo "</FORM>";
    }
}
function _makeChooseCheckbox($value, $title)
{
    return '<INPUT type=checkbox name=st_arr[] value=' . $value . ' checked>';
}
function _makeTeacher($teacher, $column)
{
    return substr($teacher, strrpos(str_replace(' - ', ' ^ ', $teacher), '^') + 2);
}
function _makeComments($value, $column)
{
    global $THIS_RET;
    return DBGet(DBQuery('SELECT COURSE_PERIOD_ID,REPORT_CARD_COMMENT_ID,COMMENT,(SELECT SORT_ORDER FROM REPORT_CARD_COMMENTS WHERE REPORT_CARD_COMMENT_ID=ID) AS SORT_ORDER FROM STUDENT_REPORT_CARD_COMMENTS WHERE STUDENT_ID=\'' . $THIS_RET['STUDENT_ID'] . '\' AND COURSE_PERIOD_ID=\'' . $THIS_RET['COURSE_PERIOD_ID'] . '\' AND MARKING_PERIOD_ID=\'' . $value . '\' ORDER BY SORT_ORDER'));
Example #11
0
        unset($_REQUEST['modfunc']);
    }
}
if ($_REQUEST['modfunc'] != 'remove') {
    $sql = 'SELECT ID,SORT_ORDER,TITLE,CONTENT,START_DATE,END_DATE,PUBLISHED_PROFILES,CASE WHEN END_DATE IS NOT NULL AND END_DATE<CURRENT_DATE THEN \'Y\' ELSE NULL END AS EXPIRED FROM portal_notes WHERE (SCHOOL_ID=\'' . UserSchool() . '\' OR SCHOOL_ID IS NULL) AND SYEAR=\'' . UserSyear() . '\' ORDER BY EXPIRED DESC,SORT_ORDER,PUBLISHED_DATE DESC';
    $QI = DBQuery($sql);
    $notes_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'CONTENT' => '_makeContentInput', 'SORT_ORDER' => '_makeTextInput', 'START_DATE' => '_makePublishing'));
    $columns = array('TITLE' => 'Title', 'CONTENT' => 'Note', 'SORT_ORDER' => 'Sort Order', 'START_DATE' => 'Publishing Options');
    //,'START_TIME'=>'Start Time','END_TIME'=>'End Time'
    $link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'CONTENT' => _makeContentInput('', 'CONTENT'), 'SHORT_NAME' => _makeTextInput('', 'SHORT_NAME'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'), 'START_DATE' => _makePublishing('', 'START_DATE'));
    $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
    $link['remove']['variables'] = array('id' => 'ID');
    echo "<FORM name=F2 id=F2 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
    #DrawHeader('',SubmitButton('Save'));
    ListOutput($notes_RET, $columns, 'Note', 'Notes', $link);
    echo '<br><CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_school_setup_portalnotes();"') . '</CENTER>';
    echo '</FORM>';
}
function _makeTextInput($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ID']) {
        $id = $THIS_RET['ID'];
    } else {
        $id = 'new';
    }
    if ($name != 'TITLE') {
        $extra = 'size=5 maxlength=10 class=cell_floating';
    } else {
        $extra = 'class=cell_floating';
    }
Example #12
0
}
if (empty($_REQUEST['modfunc'])) {
    if ($_REQUEST['search_modfunc'] != 'list') {
        unset($_SESSION['MassDrops.php']);
    }
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ",CAST (NULL AS CHAR(1)) AS CHECKBOX";
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type="checkbox" value="Y" name="controller" onclick="checkAll(this.form,this.form.controller.checked,\'student\');"><A>');
    $extra['new'] = true;
    Widgets('course');
    Widgets('request');
    Widgets('activity');
    Search('student_id', $extra);
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo '<BR /><span class="center">' . SubmitButton(_('Drop Course for Selected Students')) . '</span>';
        echo "</FORM>";
    }
}
if ($_REQUEST['modfunc'] == 'choose_course') {
    if (!$_REQUEST['course_period_id']) {
        include 'modules/Scheduling/Courses.php';
    } else {
        $_SESSION['MassDrops.php']['subject_id'] = $_REQUEST['subject_id'];
        $_SESSION['MassDrops.php']['course_id'] = $_REQUEST['course_id'];
        $_SESSION['MassDrops.php']['course_period_id'] = $_REQUEST['course_period_id'];
        $course_title = DBGet(DBQuery("SELECT TITLE FROM COURSES WHERE COURSE_ID='" . $_SESSION['MassDrops.php']['course_id'] . "'"));
        $course_title = $course_title[1]['TITLE'];
        $period_title = DBGet(DBQuery("SELECT TITLE FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID='" . $_SESSION['MassDrops.php']['course_period_id'] . "'"));
        $period_title = $period_title[1]['TITLE'];
        echo '<script type="text/javascript">opener.document.getElementById("course_div").innerHTML = "' . str_replace(array("'", '"'), array('&#39;', '&quot;'), $course_title) . '<BR />' . str_replace(array("'", '"'), array('&#39;', '&quot;'), $period_title) . '"; window.close();</script>';
Example #13
0
    }
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ",s.STUDENT_ID AS CHECKBOX";
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type=checkbox value=Y name=controller checked onclick="checkAll(this.form,this.form.controller.checked,\'st_arr\');"><A>');
    $extra['new'] = true;
    $extra['options']['search'] = false;
    $extra['force_search'] = true;
    Widgets('course');
    Widgets('gpa');
    Widgets('class_rank');
    Widgets('letter_grade');
    Search('student_id', $extra);
    if ($_REQUEST['search_modfunc'] == 'list') {
        PopTable('footer');
        echo '<BR><CENTER>' . SubmitButton('Create Grade Lists for Selected Students', '', 'class=btn_xxlarge') . '</CENTER>';
        echo "</FORM>";
    }
}
function _makeChooseCheckbox($value, $title)
{
    return '<INPUT type=checkbox name=st_arr[] value=' . $value . ' checked>';
}
function _makeTeacher($teacher, $column)
{
    return substr($teacher, strrpos(str_replace(' - ', ' ^ ', $teacher), '^') + 2);
}
function _makeComments($value, $column)
{
    global $THIS_RET;
    return DBGet(DBQuery('SELECT COURSE_PERIOD_ID,REPORT_CARD_COMMENT_ID,COMMENT,(SELECT SORT_ORDER FROM REPORT_CARD_COMMENTS WHERE REPORT_CARD_COMMENT_ID=ID) AS SORT_ORDER FROM STUDENT_REPORT_CARD_COMMENTS WHERE STUDENT_ID=\'' . $THIS_RET['STUDENT_ID'] . '\' AND COURSE_PERIOD_ID=\'' . $THIS_RET['COURSE_PERIOD_ID'] . '\' AND MARKING_PERIOD_ID=\'' . $value . '\' ORDER BY SORT_ORDER'));
Example #14
0
    StaffWidgets('fsa_balance_warning');
    StaffWidgets('fsa_status');
    StaffWidgets('fsa_exists_Y');
    $extra['SELECT'] .= ',coalesce(fsa.STATUS,\'Active\') AS STATUS,fsa.BALANCE';
    $extra['SELECT'] .= ',(SELECT \'Y\' WHERE fsa.BALANCE < \'' . $warning . '\' AND fsa.BALANCE >= 0) AS WARNING';
    $extra['SELECT'] .= ',(SELECT \'Y\' WHERE fsa.BALANCE < 0 AND fsa.BALANCE >= \'' . $minimum . '\') AS NEGATIVE';
    $extra['SELECT'] .= ',(SELECT \'Y\' WHERE fsa.BALANCE < ' . $minimum . ') AS MINIMUM';
    if (!strpos($extra['FROM'], 'fsa')) {
        $extra['FROM'] .= ',FOOD_SERVICE_STAFF_ACCOUNTS fsa';
        $extra['WHERE'] .= ' AND fsa.STAFF_ID=s.STAFF_ID';
    }
    $extra['functions'] += array('BALANCE' => 'red', 'WARNING' => 'x', 'NEGATIVE' => 'x', 'MINIMUM' => 'x');
    $extra['columns_after'] = array('BALANCE' => _('Balance'), 'STATUS' => _('Status'), 'WARNING' => _('Warning') . '<br>' . $warning, 'NEGATIVE' => _('Negative'), 'MINIMUM' => _('Minimum') . '<br>' . $minimum);
    Search('staff_id', $extra);
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo '<BR><CENTER>' . SubmitButton(_('Create Reminders for Selected Users')) . '</CENTER>';
        echo "</FORM>";
    }
}
function reminder($staff, $school, $target, $last_deposit, $note)
{
    $payment = $target - $staff['BALANCE'];
    if ($payment < 0) {
        return;
    }
    $payment = number_format($payment, 2);
    echo '<TABLE width=100%>';
    echo '<TR><TD colspan=3 align=center><FONT size=+1><I><B>' . _('Payment Reminder') . '</B></I></FONT></TD></TR>';
    echo '<TR><TD colspan=3 align=center><B>' . $school . '</B></TD></TR>';
    echo '<TR><TD width=33%>';
    echo $staff['FIRST_NAME'] . ' ' . $staff['MIDDLE_NAME'] . ' ' . $staff['LAST_NAME'] . '<BR>';
Example #15
0
    $end_date = mb_strtoupper(date('d-M-y', $start_time + 60 * 60 * 24 * 7));
}
DrawHeader(ProgramTitle());
if ($_REQUEST['search_modfunc'] || User('PROFILE') == 'parent' || User('PROFILE') == 'student') {
    $tmp_PHP_SELF = PreparePHP_SELF();
    echo '<FORM action="' . $tmp_PHP_SELF . '" method="POST">';
    $begin_year = DBGet(DBQuery("SELECT min(date_part('epoch',SCHOOL_DATE)) as SCHOOL_DATE FROM ATTENDANCE_CALENDAR WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"));
    $begin_year = $begin_year[1]['SCHOOL_DATE'];
    if (is_null($begin_year)) {
        ErrorMessage(array(_('There are no calendars yet setup.')), 'fatal');
    }
    $date_select = '<OPTION value="' . $start . '">' . date('M d, Y', $start) . ' - ' . date('M d, Y', $end) . '</OPTION>';
    for ($i = $start - 60 * 60 * 24 * 7; $i >= $begin_year; $i -= 60 * 60 * 24 * 7) {
        $date_select .= '<OPTION value="' . $i . '"' . ($i + 86400 >= $start_time && $i - 86400 <= $start_time ? ' SELECTED="SELECTED"' : '') . '>' . date('M d, Y', $i) . ' - ' . date('M d, Y', $i + 1 + ($END_DAY - $START_DAY) * 60 * 60 * 24) . '</OPTION>';
    }
    DrawHeader('<SELECT name="start_date">' . $date_select . '</SELECT>' . $period_select, SubmitButton(_('Go')));
    echo '</FORM>';
}
$extra['SELECT'] = ",e.ELIGIBILITY_CODE,c.TITLE as COURSE_TITLE";
$extra['FROM'] = ",ELIGIBILITY e,COURSES c,COURSE_PERIODS cp";
$extra['WHERE'] = "AND e.STUDENT_ID=ssm.STUDENT_ID AND e.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cp.COURSE_ID=c.COURSE_ID AND e.SCHOOL_DATE BETWEEN '{$start_date}' AND '{$end_date}'";
$extra['functions'] = array('ELIGIBILITY_CODE' => '_makeLower');
$extra['group'] = array('STUDENT_ID');
Widgets('eligibility');
Widgets('activity');
Widgets('course');
if (!$_REQUEST['search_modfunc'] && User('PROFILE') != 'parent' && User('PROFILE') != 'student') {
    $extra['new'] = true;
    Search('student_id', $extra);
} else {
    $RET = GetStuList($extra);
Example #16
0
        $LO_columns = array('TITLE' => 'Gradescale', 'GP_SCALE' => 'Scale Value', 'COMMENT' => 'Comment', 'SORT_ORDER' => 'Sort Order');
        $link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'), 'COMMENT' => makeTextInput('', 'COMMENT'), '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");
    }
    $LO_ret = DBGet(DBQuery($sql), $functions);
    echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>";
    #DrawHeader('',SubmitButton('Save'));
    echo '<BR>';
    echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}") . '</CENTER>';
    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_grade_grade();"') . '</CENTER>';
    PopTable('footer');
    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') {
        $extra = 'size=15 maxlength=100';
Example #17
0
    $sql = "SELECT CATEGORY_ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,SORT_ORDER,REQUIRED,REQUIRED,HIDE FROM school_custom_fields WHERE ID='{$_REQUEST['id']}'";
    $RET = DBGet(DBQuery($sql));
    $RET = $RET[1];
    $title = $RET['TITLE'];
} elseif ($_REQUEST['id'] == 'new') {
    $title = 'New School Field';
}
//echo $_REQUEST['id'];
if ($_REQUEST['id'] && !$_REQUEST['modfunc']) {
    $delete_button = "<INPUT type=button value=Delete class=btn_medium onClick='javascript:window.location=\"Modules.php?modname={$_REQUEST['modname']}&modfunc=delete&id={$_REQUEST['id']}\"'>" . "&nbsp;";
    echo "<FORM name=SF1 id=SF1 action=Modules.php?modname={$_REQUEST['modname']}";
    if ($_REQUEST['id'] != 'new') {
        echo "&id={$_REQUEST['id']}";
    }
    echo "&table=school_custom_fields method=POST>";
    DrawHeaderHome($title, $delete_button . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_schoolfields();"'));
    //'<INPUT type=submit value=Save>');
    $header .= '<TABLE cellpadding=3 width=100%>';
    $header .= '<TR>';
    $header .= '<input type=hidden name=tables[' . $_REQUEST['id'] . '][SCHOOL_ID] value=' . UserSchool() . '>';
    $header .= '<TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['id'] . '][TITLE]', 'Field Name') . '</TD>';
    // You can't change a student field type after it has been created
    // mab - allow changing between select and autos and edits and text
    if ($_REQUEST['id'] != 'new') {
        //			if($RET['TYPE']!='select' && $RET['TYPE']!='autos' && $RET['TYPE']!='edits' && $RET['TYPE']!='text')
        //			{
        //				$allow_edit = $_openSIS['allow_edit'];
        //				$AllowEdit = $_openSIS['AllowEdit'][$modname];
        //				$_openSIS['allow_edit'] = false;
        //				$_openSIS['AllowEdit'][$modname] = array();
        //				$type_options = array('select'=>'Pull-Down','autos'=>'Auto Pull-Down','edits'=>'Edit Pull-Down','text'=>'Text','radio'=>'Checkbox','codeds'=>'Coded Pull-Down','numeric'=>'Number','multiple'=>'Select Multiple from Options','date'=>'Date','textarea'=>'Long Text');
Example #18
0
    $room_iv = '';
    $rooms_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'CAPACITY' => '_makeIntInput', 'DESCRIPTION' => '_makeTextInput', 'SORT_ORDER' => '_makeIntInput'));
    $columns = array('TITLE' => 'Title', 'CAPACITY' => 'Capacity', 'DESCRIPTION' => 'Description', 'SORT_ORDER' => 'Sort Order');
    $link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'CAPACITY' => _makeTextInput('', 'CAPACITY'), 'DESCRIPTION' => _makeTextInput('', 'DESCRIPTION'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'));
    $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
    $link['remove']['variables'] = array('id' => 'ROOM_ID');
    echo "<FORM name=F1 id=F1 action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=update method=POST>";
    echo '<input type="hidden" name="h1" id="h1" value="' . $room_id . '">';
    $count_room = count($rooms_RET);
    if ($count_room > 0) {
        $count_room = DBGet(DBQuery("Select max(ROOM_ID) as maxid FROM rooms"));
        $count_room = $count_room[1]['MAXID'];
    }
    echo "<input type=hidden id=count_room value={$count_room} />";
    ListOutput($rooms_RET, $columns, 'Room', 'Rooms', $link);
    echo '<br><CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick="return formcheck_rooms();"') . '</CENTER>';
    echo '</FORM>';
}
function _makeTextInput($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ROOM_ID']) {
        $id = $THIS_RET['ROOM_ID'];
    } else {
        $id = 'new';
    }
    if ($name != 'TITLE') {
        $extra = 'size=5 maxlength=10  class=cell_floating  id=' . $name . '_' . $id . '';
    } else {
        $extra = 'class=cell_floating id=' . $name . '_' . $id . ' ';
        if ($id != "new") {
Example #19
0
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
if ($_REQUEST['modfunc'] == 'update') {
    if ($_REQUEST['activity']) {
        $TOTAL_COUNT = DBGet(DBQuery('SELECT COUNT(ACTIVITY_DAYS) AS TOTAL_COUNT FROM system_preference_misc'));
        $TOTAL_COUNT = $TOTAL_COUNT[1]['TOTAL_COUNT'];
        if ($TOTAL_COUNT == 0 && $_REQUEST['activity']['ACTIVITY_DAYS']) {
            DBQuery('INSERT INTO system_preference_misc (ACTIVITY_DAYS) VALUES(\'' . $_REQUEST['activity']['ACTIVITY_DAYS'] . '\')');
        } else {
            if ($TOTAL_COUNT == 1) {
                $sql = 'UPDATE system_preference_misc SET ';
                foreach ($_REQUEST['activity'] as $column_name => $value) {
                    $sql .= $column_name = '\'' . str_replace("\\'", "''", str_replace("`", "''", $value)) . '\',';
                }
                $sql = substr($sql, 0, -1) . ' WHERE 1=1';
                DBQuery($sql);
            }
        }
    }
    unset($_REQUEST['activity']);
}
$activity_RET = DBGet(DBQuery('SELECT ACTIVITY_DAYS FROM system_preference_misc LIMIT 1'));
$activity = $activity_RET[1];
echo "<FORM name=activity id=activity action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
echo '<table>';
echo '<tr><td>Maximum Inactive Days Allowed:</td><td>' . TextInput($activity['ACTIVITY_DAYS'], 'activity[ACTIVITY_DAYS]', '', 'class=cell_floating') . '</td></tr>';
echo '<tr><td><CENTER>' . SubmitButton('Save', '', 'class=btn_medium') . '</CENTER></td></tr>';
echo '</table>';
echo '</FORM>';
Example #20
0
         $colspan = 1;
     }
     $header .= '<TD valign=bottom colspan=' . $colspan . '>' . TextInput($RET['DEFAULT_SELECTION'], 'tables[' . $_REQUEST['id'] . '][DEFAULT_SELECTION]', 'Default') . '<small><BR>* for dates: YYYY-MM-DD,<BR> for checkboxes: Y</small></TD>';
     if ($_REQUEST['id'] == 'new') {
         $new = true;
     }
     $header .= '<TD>' . CheckboxInput($RET['REQUIRED'], 'tables[' . $_REQUEST['id'] . '][REQUIRED]', 'Required', '', $new) . '</TD>';
     $header .= '</TR>';
     $header .= '</TABLE>';
 } elseif ($_REQUEST['category_id']) {
     echo "<FORM name=F2 id=F2 action=Modules.php?modname={$_REQUEST['modname']}&table=ADDRESS_FIELD_CATEGORIES";
     if ($_REQUEST['category_id'] != 'new') {
         echo "&category_id={$_REQUEST['category_id']}";
     }
     echo " method=POST>";
     DrawHeaderHome($title, $delete_button . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_student_addressField_F2();"'));
     //'<INPUT type=submit value=Save>');
     #PopTable_wo_header('header');
     $header .= '<TABLE cellpadding=3 width=100%>';
     $header .= '<TR>';
     $header .= '<TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['category_id'] . '][TITLE]', 'Title') . '</TD>';
     $header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['category_id'] . '][SORT_ORDER]', 'Sort Order') . '</TD>';
     if ($_REQUEST['category_id'] == 'new') {
         $new = true;
     }
     $header .= '<TD><TABLE><TR>';
     $header .= '<TD>' . CheckboxInput($RET['RESIDENCE'], 'tables[' . $_REQUEST['category_id'] . '][RESIDENCE]', 'Residence', '', $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD>';
     $header .= '<TD>' . CheckboxInput($RET['MAILING'], 'tables[' . $_REQUEST['category_id'] . '][MAILING]', 'Mailing', '', $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD>';
     $header .= '<TD>' . CheckboxInput($RET['BUS'], 'tables[' . $_REQUEST['category_id'] . '][BUS]', 'Bus', '', $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD>';
     $header .= '</TR><TR>';
     $header .= '<TD colspan=3><small><FONT color=' . Preferences('TITLES') . '>Note: All unchecked means applies to all addresses</FONT></small></TD>';
Example #21
0
                 echo '<CENTER>' . SubmitButton('Save & Next', '', 'class=btn_wide onClick="return formcheck_add_staff(0);"') . '</CENTER>';
             }
             if ($_REQUEST['category_id'] == 1 && $username != '' && $password != '' && $this_school['JOINING_DATE'] != '') {
                 echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onClick="return formcheck_add_staff(0);"') . '</CENTER>';
             }
             if ($_REQUEST['category_id'] != 1) {
                 echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onClick="return formcheck_add_staff(0);"') . '</CENTER>';
             }
         } else {
             if ($_REQUEST['category_id'] != 3) {
                 echo '<CENTER>' . SubmitButton('Save & Next', '', 'class=btn_wide onClick="return formcheck_add_staff(0);"') . '</CENTER>';
             } else {
                 if ($_SESSION[staff_school_chkbox_id] != '') {
                     echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onClick="return formcheck_add_staff(' . $_SESSION[staff_school_chkbox_id] . ');"') . '</CENTER>';
                 } else {
                     echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onClick="return formcheck_add_staff(0);"') . '</CENTER>';
                 }
                 unset($_SESSION[staff_school_chkbox_id]);
             }
         }
     }
     echo '</FORM>';
 } else {
     if (!strpos($_REQUEST['include'], '/')) {
         include 'modules/users/includes/' . $_REQUEST['include'] . '.php';
     } else {
         include 'modules/' . $_REQUEST['include'] . '.php';
         $separator = '<div class=break></div>';
         include 'modules/users/includes/OtherInfoInc.php';
     }
 }
Example #22
0
     $header .= '</TABLE>';
     DrawHeaderHome($header);
     echo '</FORM>';
 } elseif (clean_param($_REQUEST['subject_id'], PARAM_ALPHANUM)) {
     if ($_REQUEST['subject_id'] != 'new') {
         $sql = "SELECT TITLE\r\n\t\t\t\t\t\tFROM course_subjects\r\n\t\t\t\t\t\tWHERE SUBJECT_ID='{$_REQUEST['subject_id']}'";
         $QI = DBQuery($sql);
         $RET = DBGet($QI);
         $RET = $RET[1];
         $title = $RET['TITLE'];
     } else {
         $title = 'New Subject';
         unset($delete_button);
     }
     echo "<FORM name=F4 id=F4 action=Modules.php?modname={$_REQUEST['modname']}&subject_id={$_REQUEST['subject_id']} method=POST>";
     DrawHeaderHome($title, $delete_button . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_Timetable_course_F4();"'));
     $header .= '<TABLE cellpadding=3 width=100%>';
     $header .= '<TR>';
     $header .= '<TD>' . TextInput($RET['TITLE'], 'tables[course_subjects][' . $_REQUEST['subject_id'] . '][TITLE]', 'Title', 'class=cell_wide') . '</TD>';
     $header .= '</TR>';
     $header .= '</TABLE>';
     DrawHeader($header);
     echo '</FORM>';
 }
 // DISPLAY THE MENU
 $LO_options = array('save' => false, 'search' => false);
 if (!$_REQUEST['subject_id']) {
     #DrawHeader('Courses');
     DrawHeaderHome('Course', "<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&course_modfunc=search>Search</A>");
 }
 echo '<TABLE><TR>';
Example #23
0
    $hour_options[$i] = $i;
}
$hour_options['0'] = '12';
for ($i = 0; $i <= 9; $i++) {
    $minute_options[$i] = '0' . $i;
}
for ($i = 10; $i <= 59; $i++) {
    $minute_options[$i] = $i;
}
$m_options = array('AM' => 'AM', 'PM' => 'PM');
if ($START_HOUR > 12) {
    $START_HOUR -= 12;
    $START_M = 'PM';
} else {
    $START_M = 'AM';
}
if ($END_HOUR > 12) {
    $END_HOUR -= 12;
    $END_M = 'PM';
} else {
    $END_M = 'AM';
}
PopTable('header', _('Allow Eligibility Posting'));
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
echo '<TABLE>';
echo '<TR><TD><B>' . _('From') . '</B></TD><TD>' . SelectInput($START_DAY, 'values[START_DAY]', '', $day_options, false, '', false) . '</TD><TD>' . SelectInput($START_HOUR, 'values[START_HOUR]', '', $hour_options, false, '', false) . ':</TD><TD>' . SelectInput($START_MINUTE, 'values[START_MINUTE]', '', $minute_options, false, '', false) . '</TD><TD>' . SelectInput($START_M, 'values[START_M]', '', $m_options, false, '', false) . '</TD></TR>';
echo '<TR><TD><B>' . _('To') . '</B></TD><TD>' . SelectInput($END_DAY, 'values[END_DAY]', '', $day_options, false, '', false) . '</TD><TD>' . SelectInput($END_HOUR, 'values[END_HOUR]', '', $hour_options, false, '', false) . ':</TD><TD>' . SelectInput($END_MINUTE, 'values[END_MINUTE]', '', $minute_options, false, '', false) . '</TD><TD>' . SelectInput($END_M, 'values[END_M]', '', $m_options, false, '', false) . '</TD></TR>';
echo '<TR><TD colspan=4 align=center>' . SubmitButton(_('Save')) . '</TD></TR>';
echo '</TABLE>';
echo '</FORM>';
PopTable('footer');
Example #24
0
	<TR>
		<TD colspan = 2 align=center><font color=gray>GPA based on a scale of ' . $SCALE_RET[1]['REPORTING_GP_SCALE'] . '</TD>
	</TR>' . '</TABLE></TD><TD width=350><small>GPA calculation modifies existing records.<BR><BR>Weighted and unweighted GPA is calculated by dividing the weighted and unweighted grade points configured for each letter grade (assigned in the Report Card Codes setup program) by the base grading scale specified in the school setup.  </small></TD></TR></TABLE>';
//$go = Prompt_Home('GPA Calculation','Calculate GPA and Class Rank',$table);
//if($go)
//{
if (!$_REQUEST['modfunc']) {
    echo "<FORM name=sav id=sav action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save method=POST>";
    PopTable_wo_header('header');
    echo '<CENTER><h4>Calculate GPA and Class Rank</CENTER></h4><br/>';
    echo '<center>' . $table . '</center>';
    PopTable('footer');
    //    DBQuery("CREATE TEMPORARY table temp_cum_gpa AS
    //    SELECT  * FROM student_report_card_grades srcg WHERE credit_attempted=
    //    (SELECT MAX(credit_attempted) FROM student_report_card_grades srcg1 WHERE srcg.course_period_id=srcg1.course_period_id and srcg.student_id=srcg1.student_id AND srcg1.course_period_id IS NOT NULL)
    //        GROUP BY course_period_id,student_id,marking_period_id
    //     UNION SELECT * FROM student_report_card_grades WHERE course_period_id IS NULL AND report_card_grade_id IS NULL");
    //
    //                DBQuery("SELECT CALC_CUM_GPA_MP('".$_REQUEST['marking_period_id']."')");
    //                DBQuery("SELECT SET_CLASS_RANK_MP('".$_REQUEST['marking_period_id']."')");
    //	unset($_REQUEST['delete_ok']);
    //	DrawHeader('<table><tr><td><IMG SRC=assets/check.gif></td><td>GPA and class rank for '.GetMP($_REQUEST['marking_period_id']).' has been calculated.</td></tr></table>');
    //	Prompt('GPA Calculation','Calculate GPA and Class Rank',$table);
    //}
    echo '<BR><CENTER>' . SubmitButton('Calculate GPA', '', 'class=btn_re_enroll') . '</CENTER>';
    echo "</FORM>";
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHA) == 'save') {
    unset($_REQUEST['modfunc']);
    echo '<script type=text/javascript>calculate_gpa(\'' . $_REQUEST['marking_period_id'] . '\');</script>';
}
Example #25
0
}
if (!$_REQUEST['modfunc']) {
    if ($_REQUEST['search_modfunc'] != 'list') {
        unset($_SESSION['MassSchedule.php']);
    }
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ",CAST(NULL AS CHAR(1)) AS CHECKBOX";
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type=checkbox value=Y name=controller onclick="checkAll(this.form,this.form.controller.checked,\'student\');"><A>');
    $extra['new'] = true;
    Widgets('course');
    Widgets('request');
    Widgets('activity');
    Search('student_id', $extra);
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo '<BR><CENTER>' . SubmitButton('Add Course to Selected Students', '', 'class=btn_xlarge onclick=\'formload_ajax("sav");\'') . '</CENTER>';
        echo "</FORM>";
    }
}
if ($_REQUEST['modfunc'] == 'choose_course') {
    //	if($_REQUEST['course_id'])
    //	{
    //		$weights_RET = DBGet(DBQuery("SELECT COURSE_WEIGHT,GPA_MULTIPLIER FROM COURSE_WEIGHTS WHERE COURSE_ID='$_REQUEST[course_id]'"));
    //		if(count($weights_RET)==1)
    //			$_REQUEST['course_weight'] = $weights_RET[1]['COURSE_WEIGHT'];
    //	}
    if (!$_REQUEST['course_period_id']) {
        include 'modules/Scheduling/CoursesforWindow.php';
    } else {
        $_SESSION['MassSchedule.php']['subject_id'] = $_REQUEST['subject_id'];
        $_SESSION['MassSchedule.php']['course_id'] = $_REQUEST['course_id'];
Example #26
0
         $header .= '</TABLE>';
         DrawHeaderHome($header);
         echo '</FORM>';
     } elseif ($_REQUEST['subject_id']) {
         if ($_REQUEST['subject_id'] != 'new') {
             $sql = "SELECT TITLE\n\t\t\t\t\t\tFROM course_subjects\n\t\t\t\t\t\tWHERE SUBJECT_ID='{$_REQUEST['subject_id']}'";
             $QI = DBQuery($sql);
             $RET = DBGet($QI);
             $RET = $RET[1];
             $title = $RET['TITLE'];
         } else {
             $title = '' . _('New Subject') . '';
             unset($delete_button);
         }
         echo "<FORM name=F4 id=F4 action=for_window.php?modname={$_REQUEST['modname']}&subject_id={$_REQUEST['subject_id']} method=POST>";
         DrawHeaderHome($title, $delete_button . SubmitButton('' . _('Save') . '', '', 'class=btn_medium onclick="formcheck_scheduling_course_F4();"'));
         $header .= '<TABLE cellpadding=3 width=100%>';
         $header .= '<TR>';
         $header .= '<TD>' . TextInput($RET['TITLE'], 'tables[course_subjects][' . $_REQUEST['subject_id'] . '][TITLE]', '' . _('Title') . '', 'class=cell_floating') . '</TD>';
         $header .= '</TR>';
         $header .= '</TABLE>';
         DrawHeader($header);
         echo '</FORM>';
     }
 }
 // DISPLAY THE MENU
 $LO_options = array('save' => false, 'search' => false);
 if (!$_REQUEST['subject_id'] || $_REQUEST['modfunc'] == 'choose_course') {
     #DrawHeader('Courses');
     DrawHeaderHome('' . _('Courses') . '', "<A HREF=for_window.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&course_modfunc=search>" . _('Search') . "</A>");
 }
Example #27
0
            $values = "'" . $id . "','" . UserStaffID() . "','" . UserSyear() . "','" . UserSchool() . "',(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID='" . UserStaffID() . "'),CURRENT_TIMESTAMP,'" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "','" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . ' - ' . DBDate() . "','" . User('STAFF_ID') . "'";
            $sql2 = 'INSERT INTO FOOD_SERVICE_STAFF_TRANSACTIONS (' . $fields . ') values (' . $values . ')';
            DBQuery('BEGIN; ' . $sql1 . '; ' . $sql2 . '; COMMIT');
            unset($_SESSION['FSA_sale']);
        }
        unset($_REQUEST['modfunc']);
    } else {
        unset($_REQUEST['modfunc']);
    }
    unset($_REQUEST['submit']);
}
if (UserStaffID() && !$_REQUEST['modfunc']) {
    $staff = DBGet(DBQuery("SELECT s.STAFF_ID,s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME,(SELECT STAFF_ID FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS ACCOUNT_ID,(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS BALANCE FROM STAFF s WHERE s.STAFF_ID='" . UserStaffID() . "'"));
    $staff = $staff[1];
    echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=submit&menu_id={$_REQUEST['menu_id']} method=POST>";
    DrawHeader('', SubmitButton(_('Cancel Sale'), 'submit[cancel]') . SubmitButton(_('Complete Sale'), 'submit[save]'));
    echo '</FORM>';
    echo '<TABLE width=100%><TR>';
    echo '<TD valign=top>' . NoInput($staff['FULL_NAME'], $staff['STAFF_ID']) . '</TD>';
    echo '<TD valign=top>' . NoInput(red($staff['BALANCE']), _('Balance')) . '</TD>';
    echo '</TR></TABLE>';
    echo '<HR>';
    if ($staff['ACCOUNT_ID'] && $staff['BALANCE'] != '') {
        echo '<TABLE border=0 width=100%>';
        echo '<TR><TD width=100% valign=top>';
        $RET = DBGet(DBQuery("SELECT fsti.DESCRIPTION,fsti.AMOUNT FROM FOOD_SERVICE_STAFF_TRANSACTIONS fst,FOOD_SERVICE_STAFF_TRANSACTION_ITEMS fsti WHERE fst.STAFF_ID='" . UserStaffID() . "' AND fst.SYEAR='" . UserSyear() . "' AND fst.SHORT_NAME='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' AND fst.TIMESTAMP BETWEEN CURRENT_DATE AND CURRENT_DATE+1 AND fsti.TRANSACTION_ID=fst.TRANSACTION_ID"));
        $columns = array('DESCRIPTION' => _('Item'), 'AMOUNT' => _('Amount'));
        $singular = sprintf(_('Earlier %s Sale'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
        $plural = sprintf(_('Earlier %s Sales'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
        ListOutput($RET, $columns, $singular, $plural, $link, false, array('save' => false, 'search' => false));
        // IMAGE
Example #28
0
            $header .= '<TD>';
            $header .= '<TABLE><TR>';
            foreach ($days as $day => $short_day) {
                if (strpos($RET['DAYS'], $day) !== false || $new && $day != 'S' && $day != 'U') {
                    $value = 'Y';
                } else {
                    $value = '';
                }
                $header .= '<TD>' . str_replace('"', '\\"', CheckboxInput($value, 'tables[course_period_var][' . $course_period_id . '][DAYS][' . $day . ']', $day == 'U' ? 'S' : $day, $checked, false, '', '', false)) . '</TD>';
            }
            $header .= '</TR></TABLE>';
            $header .= '</TD>';
            $header .= '<TD valign=top align="center">' . CheckboxInput($RET['DOES_ATTENDANCE'], 'tables[course_period_var][' . $course_period_id . '][DOES_ATTENDANCE]', 'Takes attendance', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', true, ' id=' . $day . '_does_attendance onclick="formcheck_periods_attendance_F2(' . ($day != '' ? 2 : 1) . ',this);"') . '<br><div id="ajax_output"></div></TD>';
            $header .= '</TR></TABLE>';
            echo '<input type="hidden" name="fixed_day" id="fixed_day" value="' . $day . '" />';
        } elseif ($_REQUEST['sch_type'] == 'blocked') {
            $header = '<input type=hidden name=tables[course_periods][' . $course_period_id . '][SCHEDULE_TYPE] value=BLOCKED />';
            $header .= SubmitButton('Save & Continue', '', 'class=btn_large onclick="validate_course_period();"');
        }
        echo $header;
        break;
    case 'per_time':
        $cpdays_RET = DBGet(DBQuery("SELECT START_TIME,END_TIME FROM school_periods where period_id={$_REQUEST['period_id']}"));
        echo $_REQUEST[day] . "/" . ProperTime($cpdays_RET[1][START_TIME]) . ' To ' . ProperTime($cpdays_RET[1][END_TIME]);
        echo '<input type=hidden name=course_period_variable[' . $course_period_id . '][' . $course_period_var_id . '][START_TIME] value="' . $cpdays_RET[1][START_TIME] . '"><input type=hidden name=course_period_variable[' . $course_period_id . '][' . $course_period_var_id . '][END_TIME] value="' . $cpdays_RET[1][END_TIME] . '">';
}
function conv_day($short_date)
{
    $days = array('U' => 'Sun', 'M' => 'Mon', 'T' => 'Tue', 'W' => 'Wed', 'H' => 'Thu', 'F' => 'Fri', 'S' => 'Sat');
    return $days[$short_date];
}
Example #29
0
            }
            //			if(!$weight)
            //			{
            //				$error[] = "No weight was selectd for ".$courses_RET[$course][1]['TITLE'];
            //				continue;
            //			}
            //			if(!$weights_RET[$course][$weight])
            //			{
            //				$error[] = $courses_RET[$course][1]['TITLE'].' does not have a weight of '.$weight;
            //				unset($courses[$i]);
            //				continue;
            //			}
            $sql = "INSERT INTO SCHEDULE_REQUESTS (SYEAR,SCHOOL_ID,STUDENT_ID,SUBJECT_ID,COURSE_ID,MARKING_PERIOD_ID,WITH_TEACHER_ID,NOT_TEACHER_ID,WITH_PERIOD_ID,NOT_PERIOD_ID)\r\n\t\t\t\t\t\tvalues('" . UserSyear() . "','" . UserSchool() . "','" . UserStudentID() . "','" . $courses_RET[$course][1]['SUBJECT_ID'] . "','" . $course . "',NULL,'" . $_REQUEST['with_teacher'][$subject][$i] . "','" . $_REQUEST['without_teacher'][$subject][$i] . "','" . $_REQUEST['with_period'][$subject][$i] . "','" . $_REQUEST['without_period'][$subject][$i] . "')";
            DBQuery($sql);
        }
    }
    echo ErrorMessage($error, 'Error');
    $_SCHEDULER['student_id'] = UserStudentID();
    $_SCHEDULER['dont_run'] = true;
    include 'modules/Scheduling/Scheduler.php';
    $_REQUEST['modfunc'] = 'choose';
}
if ($_REQUEST['modfunc'] == 'choose') {
    $functions = array('WITH_PERIOD_ID' => '_makeWithSelects', 'NOT_PERIOD_ID' => '_makeWithoutSelects');
    $requests_RET = DBGet(DBQuery("SELECT sr.COURSE_ID,c.COURSE_TITLE,sr.WITH_PERIOD_ID,sr.NOT_PERIOD_ID,sr.WITH_TEACHER_ID,\r\n\t\t\t\t\t\t\t\t\t\tsr.NOT_TEACHER_ID FROM SCHEDULE_REQUESTS sr,COURSES c\r\n\t\t\t\t\t\t\t\t\tWHERE sr.SYEAR='" . UserSyear() . "' AND sr.STUDENT_ID='" . UserStudentID() . "' AND sr.COURSE_ID=c.COURSE_ID"), $functions);
    echo "<FORM name=vary id=vary action=Modules.php?modname={$_REQUEST['modname']}&modfunc=verify method=POST>";
    DrawHeader('', SubmitButton('Save', '', 'class=btn_medium onclick=\'formload_ajax("vary");\''));
    $columns = array('');
    ListOutput($requests_RET, $columns, 'Request', 'Requests');
    echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick=\'formload_ajax("vary");\'') . '</CENTER></FORM>';
}
Example #30
0
unset($tmp_REQUEST['include_inactive']);
//-----------------------------------
//if(($_REQUEST['assignment_id'] == "all") && count($assignments_RET) == '0')
if (count($stu_RET) == 0) {
    DrawHeaderHome($assignment_select, '', '<INPUT type=checkbox name=include_inactive value=Y' . ($_REQUEST['include_inactive'] == 'Y' ? " CHECKED onclick='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&include_inactive=\";'" : " onclick='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&include_inactive=Y\";'") . '>Include Inactive Students');
} else {
    DrawHeaderHome($assignment_select, $_REQUEST['assignment_id'] ? SubmitButton('Save', '', 'class=btn_medium') : '', '<INPUT type=checkbox name=include_inactive value=Y' . ($_REQUEST['include_inactive'] == 'Y' ? " CHECKED onclick='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&include_inactive=\";'" : " onclick='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&include_inactive=Y\";'") . '>Include Inactive Students');
}
if (!$_REQUEST['student_id'] && $_REQUEST['assignment_id'] == 'all') {
    $options = array('yscroll' => true);
}
echo '<div style="overflow:auto; width:850px;">';
ListOutput($stu_RET, $LO_columns, $item, $items, $link, array(), $options);
echo '</div>';
if (count($assignments_RET) != 0) {
    echo $_REQUEST['assignment_id'] ? '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium') . '</CENTER>' : '';
}
echo '</FORM>';
function _makeExtraAssnCols($assignment_id, $column)
{
    global $THIS_RET, $total_points, $current_RET, $points_RET, $tabindex, $max_allowed;
    $rounding = DBGet(DBQuery('SELECT VALUE FROM program_user_config WHERE USER_ID=\'' . User('STAFF_ID') . '\' AND TITLE=\'ROUNDING\' AND PROGRAM=\'Gradebook\' '));
    if (count($rounding)) {
        $_SESSION['ROUNDING'] = $rounding[1]['VALUE'];
    }
    switch ($column) {
        case 'POINTS':
            $tabindex++;
            if ($assignment_id == '' && !$_REQUEST['student_id']) {
                if (count($points_RET[$THIS_RET['STUDENT_ID']])) {
                    $total = $total_points = 0;