Example #1
0
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
$cp_id = $_REQUEST['cp_id'];
if (UserStaffID() || $_REQUEST['staff_id']) {
    echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&dt=1&pr=1 method=POST>";
}
DrawBC(_('Users') . " >" . _('Teacher Programs') . "");
###########################################
if (UserStaffID() || $_REQUEST['staff_id']) {
    if ($_REQUEST['modfunc'] != 'save' && $_REQUEST[modname] != 'Users/TeacherPrograms.php?include=Attendance/Missing_Attendance.php' && $_REQUEST[modname] != 'Users/TeacherPrograms.php?include=Attendance/TakeAttendance.php') {
        //if(UserStudentID())
        //	echo '<IMG SRC=assets/pixel_trans.gif height=2>';
        if ($_REQUEST['staff_id']) {
            $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME FROM staff WHERE STAFF_ID=\'' . $_REQUEST['staff_id'] . '\''));
        } else {
            $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME FROM staff WHERE STAFF_ID=\'' . UserStaffID() . '\''));
        }
        $count_staff_RET = DBGet(DBQuery('SELECT COUNT(*) AS NUM FROM staff'));
        if ($count_staff_RET[1]['NUM'] > 1) {
            DrawHeaderHome('' . _('Selected User') . ': ' . $RET[1]['FIRST_NAME'] . '&nbsp;' . $RET[1]['LAST_NAME'] . ' (<A HREF=Side.php?staff_id=new&modcat=' . $_REQUEST['modcat'] . '><font color=red>' . _('Deselect') . '</font></A>) | <A HREF=Modules.php?modname=' . $_REQUEST['modname'] . '&search_modfunc=list&next_modname=Users/User.php&ajax=true&bottom_back=true&return_session=true target=body>' . _('Back to User List') . '</A>');
        } else {
            DrawHeaderHome('' . _('Selected User') . ': ' . $RET[1]['FIRST_NAME'] . '&nbsp;' . $RET[1]['LAST_NAME'] . ' (<A HREF=Side.php?staff_id=new&modcat=' . $_REQUEST['modcat'] . '><font color=red>' . _('Deselect') . '</font></A>)');
Example #2
0
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../RedirectModulesInc.php';
DrawBC("Extracurricular > " . ProgramTitle());
Widgets('activity');
Widgets('course');
Widgets('eligibility');
Search('student_id', $extra);
if ($_REQUEST['modfunc'] == 'add' || $_REQUEST['student_id']) {
    if ($_REQUEST['student_id']) {
        $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME,MIDDLE_NAME,NAME_SUFFIX FROM students WHERE STUDENT_ID=\'' . $_REQUEST['student_id'] . '\''));
    } else {
        $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME,MIDDLE_NAME,NAME_SUFFIX FROM students WHERE STUDENT_ID=\'' . UserStudentID() . '\''));
    }
    $count_student_RET = DBGet(DBQuery('SELECT COUNT(*) AS NUM FROM students'));
    if ($count_student_RET[1]['NUM'] > 1) {
        DrawHeaderHome('Selected Student: ' . $RET[1]['FIRST_NAME'] . '&nbsp;' . ($RET[1]['MIDDLE_NAME'] ? $RET[1]['MIDDLE_NAME'] . ' ' : '') . $RET[1]['LAST_NAME'] . '&nbsp;' . ' (<A HREF=Side.php?student_id=new&modcat=' . clean_param($_REQUEST['modcat'], PARAM_NOTAGS) . '><font color=red>Search Again</font></A>) | <A HREF=Modules.php?modname=' . clean_param($_REQUEST['modname'], PARAM_NOTAGS) . '&search_modfunc=list&next_modname=Students/Student.php&ajax=true&bottom_back=true&return_session=true target=body>Back to Student List</A>');
    } else {
        if ($count_student_RET[1]['NUM'] == 1) {
Example #3
0
                    echo '<td width="33.3%" height="86" align="center" valign="middle">&nbsp;</td>';
                    $cols++;
                }
                if ($cols == $max_cols) {
                    echo '</tr>';
                }
                echo '</table>';
            }
            PDFstop($handle);
        } else {
            BackPrompt(_('No Students were found.'));
        }
    }
}
if (!$_REQUEST['modfunc']) {
    DrawBC("" . _('Students') . " >> " . ProgramTitle());
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo "<FORM action=for_export.php?modname={$_REQUEST['modname']}&modfunc=save&include_inactive={$_REQUEST['include_inactive']}&_search_all_schools={$_REQUEST['_search_all_schools']}" . (User('PROFILE') == 'admin' ? "&w_course_period_id_which={$_REQUEST['w_course_period_id_which']}&w_course_period_id={$_REQUEST['w_course_period_id']}" : '') . "&_openSIS_PDF=true method=POST target=_blank>";
        //$extra['header_right'] = '<INPUT type=submit value=\'Create Labels for Selected Students\'>';
        $extra['extra_header_left'] = '<TABLE style="margin-top:-30px;">';
        $extra['extra_header_left'] .= '<TR><TD><b>' . _('Include on Labels:') . '</b></TD></TR>';
        if (User('PROFILE') == 'admin') {
            if ($_REQUEST['w_course_period_id_which'] == 'course_period' && $_REQUEST['w_course_period_id']) {
                $course_RET = DBGet(DBQuery('SELECT CONCAT(s.FIRST_NAME,' . ' ' . ',s.LAST_NAME) AS TEACHER,cp.ROOM FROM staff s,course_periods cp WHERE s.STAFF_ID=cp.TEACHER_ID AND cp.COURSE_PERIOD_ID=\'' . $_REQUEST[w_course_period_id] . '\''));
                $extra['extra_header_left'] .= '<TR><TD><INPUT type=checkbox name=teacher value=Y>' . _('Teacher') . ' (' . $course_RET[1]['TEACHER'] . ')</TD></TR>';
                $extra['extra_header_left'] .= '<TR><TD><INPUT type=checkbox name=room value=Y>' . _('Room') . ' (' . $course_RET[1]['ROOM'] . ')</TD></TR>';
            } else {
                $extra['extra_header_left'] .= '<TR><TD><INPUT type=checkbox name=teacher value=Y>' . _('Attendance Teacher') . '</TD></TR>';
                $extra['extra_header_left'] .= '<TR><TD><INPUT type=checkbox name=room value=Y>' . _('Attendance Room') . '</TD></TR>';
            }
        } else {
Example #4
0
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
include 'modules/Grades/config.inc.php';
DrawBC("GradeBook >> " . ProgramTitle());
$mp_RET = DBGet(DBQuery('SELECT MP FROM course_periods WHERE course_period_id = \'' . UserCoursePeriod() . '\''));
if ($mp_RET[1]['MP'] == 'SEM') {
    $sem = GetParentMP('SEM', UserMP());
    $pros = GetChildrenMP('PRO', UserMP());
}
if ($mp_RET[1]['MP'] == 'FY') {
    $sem = GetParentMP('SEM', UserMP());
    if ($sem) {
        $fy = GetParentMP('FY', $sem);
    } else {
        $fy = GetParentMP('FY', UserMP());
    }
    $pros = GetChildrenMP('PRO', UserMP());
}
if ($mp_RET[1]['MP'] == 'QTR') {
Example #5
0
            } else {
                $select_stu = DBGet(DBQuery("SELECT FIRST_NAME,LAST_NAME FROM STUDENTS WHERE STUDENT_ID='" . $student_id . "'"));
                $select_stu = $select_stu[1]['FIRST_NAME'] . "&nbsp;" . $select_stu[1]['LAST_NAME'];
                $clash .= $select_stu . "<br>";
            }
        }
        unset($_REQUEST['modfunc']);
        unset($_SESSION['MassSchedule.php']);
    } else {
        //BackPrompt('You must choose a Course');
        ShowErr('You must choose a Course');
        for_error();
    }
}
if ($_REQUEST['modfunc'] != 'choose_course') {
    DrawBC("Scheduling > " . ProgramTitle());
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo "<FORM name=sav id=sav action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save method=POST>";
        #DrawHeader('',SubmitButton('Add Course to Selected Students'));
        PopTable_wo_header('header');
        echo '<TABLE><TR><TD>Course to Add</TD><TD><DIV id=course_div>';
        if ($_SESSION['MassSchedule.php']) {
            $course_title = DBGet(DBQuery("SELECT TITLE FROM COURSES WHERE COURSE_ID='" . $_SESSION['MassSchedule.php']['course_id'] . "'"));
            $course_title = $course_title[1]['TITLE'];
            $period_title = DBGet(DBQuery("SELECT TITLE FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID='" . $_SESSION['MassSchedule.php']['course_period_id'] . "'"));
            $period_title = $period_title[1]['TITLE'];
            echo "{$course_title} - {$_REQUEST['course_weight']}<BR>{$period_title}";
        }
        echo '</DIV>' . "<A HREF=# onclick='window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=choose_course\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'>Choose a Course</A></TD></TR>";
        echo '<TR><TD>Start Date</TD><TD>' . PrepareDate(DBDate(), '') . '</TD></TR>';
        echo '<TR><TD>Marking Period</TD><TD>';
Example #6
0
        echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">User Advanced Report</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\">&nbsp;</td></tr></table>";
        echo "<table >";
        include 'modules/miscellaneous/UserExport.php';
    }
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'call') {
    $_SESSION['st_arr'] = $_REQUEST['st_arr'];
    echo "<FORM action=ForExport.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&head_html=Staff+Advanced+Report&modfunc=save&search_modfunc=list&_openSIS_PDF=true&_dis_user={$_REQUEST['_dis_user']}&_search_all_schools={$_REQUEST['_search_all_schools']} method=POST target=_blank>";
    echo '<DIV id=fields_div></DIV>';
    echo '<br/>';
    include 'modules/miscellaneous/UserExport.php';
    echo '<BR><CENTER><INPUT type=submit value=\'Create Report for Selected users\' class=btn_xxlarge></CENTER>';
    echo "</FORM>";
}
if (!$_REQUEST['modfunc'] || $_REQUEST['modfunc'] == 'list') {
    DrawBC("users >> " . ProgramTitle());
    if ($_REQUEST['modfunc'] == 'list') {
        $extra['columns_after'] = array('LAST_LOGIN' => 'Last Login');
        $extra['functions'] = array('LAST_LOGIN' => 'makeLogin');
        $extra['SELECT'] = ',LAST_LOGIN,CONCAT(\'<INPUT type=checkbox name=st_arr[] value=\',s.STAFF_ID,\' checked>\') AS CHECKBOX';
        $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['options']['search'] = false;
        echo "<FORM action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=call method=POST>";
        echo '<DIV id=fields_div></DIV>';
        if ($_REQUEST['_dis_user']) {
            echo '<INPUT type=hidden name=_dis_user value=' . strip_tags(trim($_REQUEST['_dis_user'])) . '>';
        }
        if ($_REQUEST['_search_all_schools']) {
            echo '<INPUT type=hidden name=_search_all_schools value=' . strip_tags(trim($_REQUEST['_search_all_schools'])) . '>';
        }
        Search('staff_id', $extra);
Example #7
0
    unset($_REQUEST['modfunc']);
    unset($_SESSION['_REQUEST_vars']['staff']);
    unset($_SESSION['_REQUEST_vars']['modfunc']);
    if (User('STAFF_ID') == $_REQUEST['staff_id']) {
        unset($_openSIS['User']);
        echo '<script language=JavaScript>parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
    }
}
$extra['SELECT'] = ',LAST_LOGIN';
$extra['columns_after'] = array('LAST_LOGIN' => 'Last Login');
$extra['functions'] = array('LAST_LOGIN' => 'makeLogin');
if (basename($_SERVER['PHP_SELF']) != 'index.php') {
    if ($_REQUEST['staff_id'] == 'new') {
        DrawBC("Users > Add a User");
    } else {
        DrawBC("Users > " . ProgramTitle());
    }
    SearchStaff('staff_id', $extra);
} else {
    DrawHeader('Create Account');
}
if ($_REQUEST['modfunc'] == 'delete' && basename($_SERVER['PHP_SELF']) != 'index.php' && AllowEdit()) {
    # ------------------------------------  For Certification Start ------------------------------------------- #
    if (DeletePrompt('certification')) {
        DBQuery("DELETE FROM staff_certification WHERE STAFF_CERTIFICATION_ID='{$_REQUEST['certification_id']}'");
        unset($_REQUEST['modfunc']);
        $_REQUEST['certification_id'] = 'new';
    }
}
if ((UserStaffID() || $_REQUEST['staff_id'] == 'new') && (basename($_SERVER['PHP_SELF']) != 'index.php' || !$_REQUEST['staff']['USERNAME']) && $_REQUEST['modfunc'] != 'delete' && $_SESSION['fn'] != 'user' && $_REQUEST['modfunc'] != 'remove') {
    if ($_REQUEST['modfunc'] != 'delete' || $_REQUEST['delete_ok'] == '1') {
        } else {
            $header .= '<TD><b>' . 'No Parent Course Selected' . '</b><br>Parent Course' . '</TD>';
        }
        $header .= '<TD><b>' . $periods_RET[1]['START_TIME'] . '</b><br>Start Time' . '</TD>';
        $header .= '<TD><b>' . $periods_RET[1]['END_TIME'] . '</b><br>End Time' . '</TD><td></td>';
        $header .= '</TR>';
        $header .= '</TABLE>';
        DrawHeaderHome($header);
    }
    echo "</div></div></div><div class='tab_footer'>";
} else {
    unset($_SESSION['_REQUEST_vars']['subject_id']);
    unset($_SESSION['_REQUEST_vars']['course_id']);
    unset($_SESSION['_REQUEST_vars']['course_weight']);
    unset($_SESSION['_REQUEST_vars']['course_period_id']);
    DrawBC("Courses > " . ProgramTitle());
    if ($_REQUEST['print'] != 'list') {
        echo PopTable('header', 'Quick Search');
    }
    #echo "<FORM id='search' name='search' method=POST action=Modules.php?modname=$_REQUEST[modname]>";
    if ($_REQUEST['print'] != 'list') {
        echo "<FORM name=search id=search action=for_export.php?modname={$_REQUEST['modname']}&modfunc=print&marking_period_id=" . $_REQUEST['marking_period_id'] . "&_openSIS_PDF=true&report=true&print=list method=POST target=_blank>";
        echo '<table width=100%><tr><td align="center"><INPUT type=submit class=btn_medium value=\'Print\'></td></tr></table>';
        echo '<TABLE align=left cellpadding="5" border="0"><TR>';
        echo '<TD valign=top align=left>';
    }
    $mp_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,TITLE,SHORT_NAME,'2'  FROM SCHOOL_QUARTERS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' UNION SELECT MARKING_PERIOD_ID,TITLE,SHORT_NAME,'1' FROM SCHOOL_SEMESTERS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' UNION SELECT MARKING_PERIOD_ID,TITLE,SHORT_NAME,'0' FROM SCHOOL_YEARS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY 3,4"));
    unset($options);
    if (count($mp_RET)) {
        foreach ($mp_RET as $key => $value) {
            if ($value['MARKING_PERIOD_ID'] == $_REQUEST['marking_period_id']) {
Example #9
0
            if (count($RET)) {
                echo '<p><font color=#FF0000><b>Warning!!</b></font> - You have students with food service balance below $5.00 - please deposit at least the Minimum Deposit into you children\'s accounts.';
                ListOutput($RET, array('FULL_NAME' => 'Student', 'GRADE_ID' => 'Grade', 'ACCOUNT_ID' => 'AccountID', 'BALANCE' => 'Balance', 'DEPOSIT' => 'Minimum Deposit'), 'Student', 'Students', array(), array(), array('save' => false, 'search' => false));
                echo '</p>';
            }
            // warn if negative food service balance
            $staff = DBGet(DBQuery('SELECT (SELECT STATUS FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS STATUS,(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS BALANCE FROM STAFF s WHERE s.STAFF_ID=' . User('STAFF_ID')));
            $staff = $staff[1];
            if ($staff['BALANCE'] && $staff['BALANCE'] < 0) {
                echo '<p><font color=#FF0000><b>Warning!!</b></font> - You have a <b>negative</b> food service balance of <font color=#FF0000>' . $staff['BALANCE'] . '</font></p>';
            }
        }
        #echo '<p>&nbsp;Happy parenting...</p>';
        break;
    case 'student':
        DrawBC($welcome . ' | Role: Student');
        $notes_RET = DBGet(DBQuery("SELECT s.TITLE AS SCHOOL,pn.PUBLISHED_DATE,pn.TITLE,pn.CONTENT FROM PORTAL_NOTES pn,SCHOOLS s WHERE pn.SYEAR='" . UserSyear() . "' AND pn.START_DATE<=CURRENT_DATE AND (pn.END_DATE>=CURRENT_DATE OR pn.END_DATE IS NULL) AND pn.SCHOOL_ID='" . UserSchool() . "' AND  position(',0,' IN pn.PUBLISHED_PROFILES)>0 AND s.ID=pn.SCHOOL_ID ORDER BY pn.SORT_ORDER,pn.PUBLISHED_DATE DESC"), array('PUBLISHED_DATE' => 'ProperDate', 'CONTENT' => '_nl2br'));
        if (count($notes_RET)) {
            echo '<p>';
            ListOutput($notes_RET, array('PUBLISHED_DATE' => 'Date Posted', 'TITLE' => 'Title', 'CONTENT' => 'Note'), 'Note', 'Notes', array(), array(), array('save' => false, 'search' => false));
            echo '</p>';
        }
        $events_RET = DBGet(DBQuery("SELECT TITLE,SCHOOL_DATE,DESCRIPTION FROM CALENDAR_EVENTS WHERE SCHOOL_DATE BETWEEN CURRENT_DATE AND CURRENT_DATE+30 AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"), array('SCHOOL_DATE' => 'ProperDate'));
        if (count($events_RET)) {
            echo '<p>';
            ListOutput($events_RET, array('TITLE' => 'Event', 'SCHOOL_DATE' => 'Date', 'DESCRIPTION' => 'Description'), 'Upcoming Event', 'Upcoming Events', array(), array(), array('save' => false, 'search' => false));
            echo '</p>';
        }
        //echo '<p>&nbsp;Happy learning...</p>';
        break;
}
Example #10
0
    echo '<FORM action=Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=' . $_REQUEST['modfunc'] . '&month=' . $_REQUEST['month'] . '&year=' . $_REQUEST['year'] . ' METHOD=POST>';
    DrawHeaderHome(PrepareDateSchedule($start_date, 'start') . ' <div style="float:left;">&nbsp;&nbsp;-&nbsp;&nbsp</div> ' . PrepareDateSchedule($end_date, 'end') . ' <A HREF=Modules.php?modname=' . $_REQUEST['modname'] . '&month=' . $_REQUEST['month'] . '&year=' . $_REQUEST['year'] . '>&nbsp;-Back to Calendar</A>', '<INPUT type=submit class=btn_medium value=Go>');
    $functions = array('SCHOOL_DATE' => 'ProperDate');
    // <A HREF=Modules.php?modname='.$_REQUEST["modname"].'&month='.$_REQUEST["month"].'&year='.$_REQUEST["year"].'>
    $events_RET = DBGet(DBQuery('SELECT ID,SCHOOL_DATE,TITLE,DESCRIPTION FROM calendar_events WHERE SCHOOL_DATE BETWEEN \'' . $start_date . '\' AND \'' . $end_date . '\' AND SYEAR=\'' . UserSyear() . '\'  AND (calendar_id=\'' . $_REQUEST['calendar_id'] . '\' OR calendar_id=\'0\') ORDER BY SCHOOL_DATE'), $functions);
    $_SESSION['events_RET'] = $events_RET;
    echo '<div style="overflow:auto; width:820px;">';
    echo '<div id="students" >';
    ListOutput($events_RET, array('SCHOOL_DATE' => 'Date', 'TITLE' => 'Event', 'DESCRIPTION' => 'Description'), 'Event', 'Events');
    echo '</div></div></FORM>';
}
if (!$_REQUEST['modfunc']) {
    if (User('PROFILE') != 'student') {
        DrawBC("School Setup >> " . ProgramTitle());
    } else {
        DrawBC("School Info >> " . ProgramTitle());
    }
    $last = 31;
    while (!checkdate($_REQUEST['month'], $last, $_REQUEST['year'])) {
        $last--;
    }
    $calendar_RET = DBGet(DBQuery('SELECT DATE_FORMAT(SCHOOL_DATE,\'%d-%b-%y\') as SCHOOL_DATE,MINUTES,BLOCK FROM attendance_calendar WHERE SCHOOL_DATE BETWEEN \'' . date('Y-m-d', $time) . '\' AND \'' . date('Y-m-d', mktime(0, 0, 0, $_REQUEST['month'], $last, $_REQUEST['year'])) . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND CALENDAR_ID=\'' . $_REQUEST['calendar_id'] . '\''), array(), array('SCHOOL_DATE'));
    if ($_REQUEST['minutes']) {
        foreach ($_REQUEST['minutes'] as $date => $minutes) {
            if ($calendar_RET[$date]) {
                if ($minutes != '0' && $minutes != '') {
                    DBQuery('UPDATE attendance_calendar SET MINUTES=\'' . $minutes . '\' WHERE SCHOOL_DATE=\'' . $date . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND CALENDAR_ID=\'' . $_REQUEST['calendar_id'] . '\'');
                } else {
                    DBQuery('DELETE FROM attendance_calendar WHERE SCHOOL_DATE=\'' . $date . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND CALENDAR_ID=\'' . $_REQUEST['calendar_id'] . '\'');
                }
            } elseif ($minutes != '0' && $minutes != '') {
Example #11
0
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
//include("languages/English/$_REQUEST[modname]");
DrawBC(_('Attendance') . " >> " . ProgramTitle());
if ($_REQUEST['codes']) {
    $_SESSION['code'] = $_REQUEST['codes'];
} else {
    $_SESSION['code'] = 'A';
}
if ($_REQUEST['month_date'] && $_REQUEST['day_date'] && $_REQUEST['year_date']) {
    //echo $_REQUEST['year_date'];
    while (!VerifyDate($date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . $_REQUEST['year_date'])) {
        $_REQUEST['day_date']--;
    }
    /*if($_SESSION['Administration.php']['date'] && $_SESSION['Administration.php']['date']!=$date)
    	{
    		unset($_REQUEST['attendance']);
    		unset($_REQUEST['attendance_day']);
    	}*/
Example #12
0
        echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('User Advanced Report') . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />" . _('Powered by openSIS') . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\">&nbsp;</td></tr></table>";
        echo "<table >";
        include 'modules/misc/UserExport.php';
    }
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'call') {
    $_SESSION['st_arr'] = $_REQUEST['st_arr'];
    echo "<meta charset='UTF-8'><FORM action=for_export.php?modname={$_REQUEST['modname']}&head_html=Staff+Advanced+Report&modfunc=save&search_modfunc=list&_openSIS_PDF=true&_dis_user={$_REQUEST['_dis_user']}&_search_all_schools={$_REQUEST['_search_all_schools']} method=POST target=_blank>";
    echo '<DIV id=fields_div></DIV>';
    echo '<br/>';
    include 'modules/misc/UserExport.php';
    echo '<BR><CENTER><INPUT type=submit value=' . _('Create Report for Selected Users') . ' class=btn_xxlarge></CENTER>';
    echo "</FORM>";
}
if (!$_REQUEST['modfunc'] || $_REQUEST['modfunc'] == 'list') {
    DrawBC("" . _('Users') . " >> " . ProgramTitle());
    if ($_REQUEST['modfunc'] == 'list') {
        $extra['columns_after'] = array('LAST_LOGIN' => _('Last Login'));
        $extra['functions'] = array('LAST_LOGIN' => 'makeLogin');
        #$extra['SELECT'] = ",LAST_LOGIN,CONCAT('<INPUT type=checkbox name=st_arr[] value=',s.STAFF_ID,' checked>') AS CHECKBOX";
        $extra['SELECT'] = ',LAST_LOGIN,CONCAT(\'<INPUT type=checkbox name=st_arr[] value=\',s.STAFF_ID,\' checked>\') AS CHECKBOX';
        $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['options']['search'] = false;
        echo "<meta charset='UTF-8'><FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=call method=POST>";
        echo '<DIV id=fields_div></DIV>';
        if ($_REQUEST['_dis_user']) {
            echo '<INPUT type=hidden name=_dis_user value=' . $_REQUEST['_dis_user'] . '>';
        }
        if ($_REQUEST['_search_all_schools']) {
            echo '<INPUT type=hidden name=_search_all_schools value=' . $_REQUEST['_search_all_schools'] . '>';
        }
Example #13
0
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC("Grades >> " . ProgramTitle());
$mp_RET = DBGet(DBQuery('SELECT MP FROM course_periods WHERE course_period_id = \'' . UserCoursePeriod() . '\''));
if ($mp_RET[1]['MP'] == 'SEM') {
    $sem = GetParentMP('SEM', UserMP());
    $pros = GetChildrenMP('PRO', UserMP());
}
if ($mp_RET[1]['MP'] == 'FY') {
    $sem = GetParentMP('SEM', UserMP());
    if ($sem) {
        $fy = GetParentMP('FY', $sem);
    } else {
        $fy = GetParentMP('FY', UserMP());
    }
    $pros = GetChildrenMP('PRO', UserMP());
}
if ($mp_RET[1]['MP'] == 'QTR') {
Example #14
0
                                                AND (ga.POINTS!=\'0\') ORDER BY ga.ASSIGNMENT_ID DESC'));
         }
         if (count($assignments_RET)) {
             $LO_columns = array('TITLE' => '' . _('Title') . '', 'CATEGORY' => '' . _('Category') . '', 'ASSIGNED_DATE' => '' . _('Assigned Date') . '', 'DUE_DATE' => '' . _('Due Date') . '', 'COMMENT' => '' . _('Description') . '');
             $LO_ret = array(0 => array());
             foreach ($assignments_RET as $assignment) {
                 $LO_ret[] = array('TITLE' => $assignment['TITLE'], 'CATEGORY' => $assignment['CATEGORY'], 'ASSIGNED_DATE' => $assignment['ASSIGNED_DATE'], 'DUE_DATE' => $assignment['DUE_DATE'], 'COMMENT' => $assignment['COMMENT']);
             }
             DrawHeader('' . _('Subject') . ' - ' . _(substr($course['TITLE']), strrpos(str_replace(' - ', ' ^ ', _($course['TITLE'])), '^')));
             unset($LO_ret[0]);
             ListOutput($LO_ret, $LO_columns, '' . _('Assignment') . '', '' . _('Assignments') . '', array(), array(), array('center' => false, 'save' => $_REQUEST['id'] != 'all', 'search' => false));
         }
     }
     break;
 case 'student':
     DrawBC(_($welcome) . ' | ' . _('Role') . ' : ' . _('Student') . '');
     $notes_RET = DBGet(DBQuery('SELECT IF(pn.school_id IS NULL,\'All School\',(SELECT TITLE FROM schools WHERE id=pn.school_id)) AS SCHOOL,pn.PUBLISHED_DATE,pn.TITLE,pn.CONTENT 
         FROM portal_notes pn
         WHERE pn.SYEAR=\'' . UserSyear() . '\' 
             AND pn.START_DATE<=CURRENT_DATE AND (pn.END_DATE>=CURRENT_DATE OR pn.END_DATE IS NULL) 
             AND (pn.school_id IS NULL OR pn.SCHOOL_ID=\'' . UserSchool() . '\') 
             AND  position(\',0,\' IN pn.PUBLISHED_PROFILES)>0
             ORDER BY pn.SORT_ORDER,pn.PUBLISHED_DATE DESC'), array('PUBLISHED_DATE' => 'ProperDate', 'CONTENT' => '_nl2br'));
     if (count($notes_RET)) {
         echo '<p>';
         ListOutput($notes_RET, array('PUBLISHED_DATE' => '' . _('Date Posted') . '', 'TITLE' => '' . _('Title') . '', 'CONTENT' => '' . _('Note') . ''), '' . _('Note') . '', '' . _('Notes') . '', array(), array(), array('save' => false, 'search' => false));
         echo '</p>';
     }
     //$events_RET = DBGet(DBQuery("SELECT TITLE,SCHOOL_DATE,DESCRIPTION FROM calendar_events WHERE SCHOOL_DATE BETWEEN CURRENT_DATE AND CURRENT_DATE+30 AND SYEAR='".UserSyear()."' AND SCHOOL_ID='".UserSchool()."'"),array('SCHOOL_DATE'=>'ProperDate'));
     $events_RET = DBGet(DBQuery("SELECT TITLE,SCHOOL_DATE,DESCRIPTION FROM calendar_events ce,calendar_events_visibility cev WHERE ce.calendar_id=cev.calendar_id AND cev.profile_id=0 AND SCHOOL_DATE BETWEEN CURRENT_DATE AND CURRENT_DATE+30 AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"), array('SCHOOL_DATE' => 'ProperDate'));
     $events_RET1 = DBGet(DBQuery('SELECT ce.TITLE,ce.DESCRIPTION,ce.SCHOOL_DATE,s.TITLE AS SCHOOL 
Example #15
0
    $start_time = $start;
    $start_date = strtoupper(date('d-M-y', $start_time));
    $end_date = strtoupper(date('d-M-y', $end));
} else {
    $start_time = $_REQUEST['start_date'];
    $start_date = strtoupper(date('d-M-y', $start_time));
    $end_date = strtoupper(date('d-M-y', $start_time + 60 * 60 * 24 * 7));
}
$QI = DBQuery("SELECT PERIOD_ID,TITLE FROM SCHOOL_PERIODS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY SORT_ORDER ");
$periods_RET = DBGet($QI);
$period_select = "&nbsp;<SELECT name=period><OPTION value=''>All</OPTION>";
foreach ($periods_RET as $period) {
    $period_select .= "<OPTION value={$period['PERIOD_ID']}" . ($_REQUEST['period'] == $period['PERIOD_ID'] ? ' SELECTED' : '') . ">" . $period['TITLE'] . "</OPTION>";
}
$period_select .= "</SELECT>";
DrawBC("Eligibility > " . ProgramTitle());
echo "<FORM name=teach_comp id=teach_comp action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
$begin_year = DBGet(DBQuery("SELECT min(unix_timestamp(SCHOOL_DATE)) as SCHOOL_DATE FROM ATTENDANCE_CALENDAR WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"));
$begin_year = $begin_year[1]['SCHOOL_DATE'];
if ($start && $begin_year) {
    $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' : '') . ">" . date('M d, Y', $i) . ' - ' . date('M d, Y', $i + 1 + ($END_DAY - $START_DAY) * 60 * 60 * 24) . '</OPTION>';
    }
}
DrawHeaderHome('<SELECT name=start_date>' . $date_select . '</SELECT>' . $period_select, '<INPUT type=submit class=btn_medium value=Go onclick=\'formload_ajax("teach_comp");\'>');
echo '</FORM>';
$sql = "SELECT CONCAT(s.LAST_NAME,', ',s.FIRST_NAME) AS FULL_NAME,sp.TITLE,cp.PERIOD_ID,s.STAFF_ID \n\t\tFROM STAFF s,COURSE_PERIODS cp,SCHOOL_PERIODS sp \n\t\tWHERE \n\t\t\tsp.PERIOD_ID = cp.PERIOD_ID\n\t\t\tAND cp.TEACHER_ID=s.STAFF_ID AND cp.MARKING_PERIOD_ID IN (" . GetAllMP('QTR', UserMP()) . ")\n\t\t\tAND cp.SYEAR='" . UserSyear() . "' AND cp.SCHOOL_ID='" . UserSchool() . "' AND s.PROFILE='teacher'\n\t\t\t" . ($_REQUEST['period'] ? " AND cp.PERIOD_ID='{$_REQUEST['period']}'" : '') . "\n\t\t\tAND NOT EXISTS (SELECT '' FROM ELIGIBILITY_COMPLETED ac WHERE ac.STAFF_ID=cp.TEACHER_ID AND ac.PERIOD_ID = sp.PERIOD_ID AND ac.SCHOOL_DATE BETWEEN '" . date('Y-m-d', $start_time) . "' AND '" . date('Y-m-d', $start_time + 60 * 60 * 24 * 7) . "')";
$RET = DBGet(DBQuery($sql), array(), array('STAFF_ID', 'PERIOD_ID'));
$i = 0;
if (count($RET)) {
Example #16
0
    $start_time = $start;
    $start_date = strtoupper(date('d-M-y', $start_time));
    $end_date = strtoupper(date('d-M-y', $end));
} else {
    $start_time = $_REQUEST['start_date'];
    $start_date = strtoupper(date('d-M-y', $start_time));
    $end_date = strtoupper(date('d-M-y', $start_time + 60 * 60 * 24 * 7));
}
$QI = DBQuery('SELECT PERIOD_ID,TITLE FROM school_periods WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER ');
$periods_RET = DBGet($QI);
$period_select = "&nbsp;<SELECT name=period><OPTION value=''>All</OPTION>";
foreach ($periods_RET as $period) {
    $period_select .= "<OPTION value={$period['PERIOD_ID']}" . ($_REQUEST['period'] == $period['PERIOD_ID'] ? ' SELECTED' : '') . ">" . $period['TITLE'] . "</OPTION>";
}
$period_select .= "</SELECT>";
DrawBC(_('Eligibility') . " > " . ProgramTitle());
echo "<FORM name=teach_comp id=teach_comp action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
$begin_year = DBGet(DBQuery('SELECT min(unix_timestamp(SCHOOL_DATE)) as SCHOOL_DATE FROM attendance_calendar WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\''));
$begin_year = $begin_year[1]['SCHOOL_DATE'];
if ($start && $begin_year) {
    $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' : '') . ">" . date('M d, Y', $i) . ' - ' . date('M d, Y', $i + 1 + ($END_DAY - $START_DAY) * 60 * 60 * 24) . '</OPTION>';
    }
}
DrawHeaderHome('<SELECT name=start_date>' . $date_select . '</SELECT>' . $period_select, '<INPUT type=submit class=btn_medium value=' . _('Go') . ' onclick=\'formload_ajax("teach_comp");\'>');
echo '</FORM>';
$mp = GetAllMP('QTR', UserMP());
if (!isset($mp)) {
    $mp = GetAllMP('SEM', UserMP());
}
Example #17
0
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#**************************************************************************
if ($_REQUEST['month_date'] && $_REQUEST['day_date'] && $_REQUEST['year_date']) {
    while (!VerifyDate($date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . $_REQUEST['year_date'])) {
        $_REQUEST['day_date']--;
    }
} else {
    $_REQUEST['day_date'] = date('d');
    $_REQUEST['month_date'] = strtoupper(date('M'));
    $_REQUEST['year_date'] = date('y');
    $date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . $_REQUEST['year_date'];
}
DrawBC("Attendance > " . ProgramTitle());
//$QI = DBQuery("SELECT PERIOD_ID,TITLE FROM SCHOOL_PERIODS WHERE SCHOOL_ID='".UserSchool()."' AND SYEAR='".UserSyear()."' ORDER BY SORT_ORDER ");
$QI = DBQuery("SELECT sp.PERIOD_ID,sp.TITLE FROM SCHOOL_PERIODS sp WHERE sp.SCHOOL_ID='" . UserSchool() . "' AND sp.SYEAR='" . UserSyear() . "' AND EXISTS (SELECT '' FROM COURSE_PERIODS WHERE SYEAR=sp.SYEAR AND PERIOD_ID=sp.PERIOD_ID AND DOES_ATTENDANCE='Y') ORDER BY sp.SORT_ORDER");
$periods_RET = DBGet($QI, array(), array('PERIOD_ID'));
$period_select = "<SELECT name=period><OPTION value=''>All</OPTION>";
foreach ($periods_RET as $id => $period) {
    $period_select .= "<OPTION value={$id}" . ($_REQUEST['period'] == $id ? ' SELECTED' : '') . ">" . $period[1]['TITLE'] . "</OPTION>";
}
$period_select .= "</SELECT>";
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
DrawHeaderHome(PrepareDateSchedule($date, '_date', false, array('submit' => true)) . ' - ' . $period_select . ' : <INPUT type=submit class=btn_medium value=Go>');
echo '</FORM>';
$day = date('D', strtotime($date));
switch ($day) {
    case 'Sun':
        $day = 'U';
Example #18
0
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include 'modules/Grades/DeletePromptX.fnc.php';
//echo '<pre>'; var_dump($_REQUEST); echo '</pre>';
DrawBC("" . _('Gradebook') . " > " . ProgramTitle());
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'update') {
    if (clean_param($_REQUEST['values'], PARAM_NOTAGS) && ($_POST['values'] || $_REQUEST['ajax'])) {
        if ($_REQUEST['tab_id']) {
            foreach ($_REQUEST['values'] as $id => $columns) {
                if (!(isset($columns['TITLE']) && trim($columns['TITLE']) == '')) {
                    if ($id != 'new') {
                        if ($_REQUEST['tab_id'] != 'new') {
                            $sql = 'UPDATE report_card_grades SET ';
                        } else {
                            $sql = 'UPDATE report_card_grade_scales SET ';
                        }
                        foreach ($columns as $column => $value) {
                            #################gcu customization####################
                            if ($column == 'GPA_CAL' && $value == 'Y' && $_REQUEST['tab_id'] == 'new') {
                                $GPA_CAL_selected = true;
Example #19
0
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC("School Setup > " . ProgramTitle());
if (!$_REQUEST['marking_period_id'] && count($fy_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID FROM school_years WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER'))) == 1 && !$_REQUEST['ajax']) {
    $_REQUEST['marking_period_id'] = $fy_RET[1]['MARKING_PERIOD_ID'];
    $_REQUEST['mp_term'] = 'FY';
}
unset($_SESSION['_REQUEST_vars']['marking_period_id']);
unset($_SESSION['_REQUEST_vars']['mp_term']);
//print_r($_POST);
//include 'validation_markingperiods.php';
switch ($_REQUEST['mp_term']) {
    case 'FY':
        $table = 'school_years';
        if ($_REQUEST['marking_period_id'] == 'new') {
            $title = 'New Year';
        }
        break;
Example #20
0
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC(_('Users') . " > " . ProgramTitle());
include 'Menu.php';
if (!UserStaffID()) {
    Search('staff_id');
}
//else
//{
//	$profile = DBGet(DBQuery("SELECT PROFILE FROM staff WHERE STAFF_ID='".UserStaffID()."'"));
//	if(!$profile[1]['PROFILE'] || $profile[1]['PROFILE']=='none')
//	{
//		unset($_SESSION['staff_id']);
//		echo '<script language=JavaScript>parent.side.location="'.$_SESSION['Side_PHP_SELF'].'?modcat="+parent.side.document.forms[0].modcat.value;
//		Search('staff_id');
//	}
//}
$user_id = UserStaffID();
                    }
                }
            }
            PDFStop($handle);
        } else {
            BackPrompt('No Students were found.');
        }
    } else {
        BackPrompt('You must choose at least one student.');
    }
    unset($_SESSION['student_id']);
    //echo '<pre>'; var_dump($_REQUEST['modfunc']); echo '</pre>';
    $_REQUEST['modfunc'] = true;
}
if (!$_REQUEST['modfunc']) {
    DrawBC("Students >> " . ProgramTitle());
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo "<FORM action=for_export.php?modname={$_REQUEST['modname']}&modfunc=save&include_inactive={$_REQUEST['include_inactive']}&_search_all_schools={$_REQUEST['_search_all_schools']}&_openSIS_PDF=true method=POST target=_blank>";
        //$extra['header_right'] = '<INPUT type=submit value=\'Print Info for Selected Students\'>';
        $extra['extra_header_left'] = '<TABLE>';
        //Widgets('mailing_labels',true);
        $extra['extra_header_left'] .= $extra['search'];
        $extra['search'] = '';
        $extra['extra_header_left'] .= '';
        if (User('PROFILE_ID')) {
            $can_use_RET = DBGet(DBQuery("SELECT MODNAME FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='" . User('PROFILE_ID') . "' AND CAN_USE='Y'"), array(), array('MODNAME'));
        } else {
            $can_use_RET = DBGet(DBQuery("SELECT MODNAME FROM STAFF_EXCEPTIONS WHERE USER_ID='" . User('STAFF_ID') . "' AND CAN_USE='Y'"), array(), array('MODNAME'));
        }
        $categories_RET = DBGet(DBQuery("SELECT ID,TITLE,INCLUDE FROM STUDENT_FIELD_CATEGORIES ORDER BY SORT_ORDER,TITLE"));
        $extra['extra_header_left'] .= '';
Example #22
0
                            $sql_up = 'update school_periods set length = ' . $length . ' where period_id=\'' . $period_id . '\' and syear=\'' . UserSyear() . '\' and school_id=\'' . UserSchool() . '\'';
                            $res_up = mysql_query($sql_up);
                            # -------------------------------------------------------------------------- #
                            //                                        }
                            //                                    }
                        }
                    }
                }
            }
        }
    }
    if ($err) {
        echo '<font style="color:red"><b>' . $err . '</b></font>';
    }
}
DrawBC("" . _('School Setup') . " > " . ProgramTitle());
#echo "Modules.php?modname=$_REQUEST[modname]";
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove' && AllowEdit()) {
    $prd_id = paramlib_validation($colmn = PERIOD_ID, $_REQUEST[id]);
    $has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM course_periods WHERE PERIOD_ID=\'' . $prd_id . '\''));
    $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
    if ($has_assigned > 0) {
        UnableDeletePrompt(_('Cannot delete because course periods are created on this period.'));
    } else {
        if (DeletePrompt_Period(_('period'))) {
            DBQuery('DELETE FROM school_periods WHERE PERIOD_ID=\'' . $prd_id . '\'');
            unset($_REQUEST['modfunc']);
        }
    }
}
if ($_REQUEST['modfunc'] != 'remove') {
Example #23
0
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../RedirectModulesInc.php';
$cp_id = $_REQUEST['cp_id'];
if (UserStaffID() || $_REQUEST['staff_id']) {
    echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&dt=1&pr=1 method=POST>";
}
DrawBC("Users > Teacher Programs");
###########################################
if (UserStaffID() || $_REQUEST['staff_id']) {
    if ($_REQUEST['modfunc'] != 'save' && $_REQUEST[modname] != 'users/TeacherPrograms.php?include=attendance/MissingAttendance.php' && $_REQUEST[modname] != 'users/TeacherPrograms.php?include=attendance/TakeAttendance.php') {
        if ($_REQUEST['staff_id']) {
            $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME FROM staff WHERE STAFF_ID=\'' . $_REQUEST['staff_id'] . '\''));
        } else {
            $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME FROM staff WHERE STAFF_ID=\'' . UserStaffID() . '\''));
        }
        $count_staff_RET = DBGet(DBQuery('SELECT COUNT(*) AS NUM FROM staff'));
        if ($count_staff_RET[1]['NUM'] > 1) {
            if (trim($_REQUEST['process']) == "") {
                DrawHeaderHome('Selected User: '******'FIRST_NAME'] . '&nbsp;' . $RET[1]['LAST_NAME'] . ' (<A HREF=Side.php?staff_id=new&modcat=' . $_REQUEST['modcat'] . '><font color=red>Search Again</font></A>) | <A HREF=Modules.php?modname=' . $_REQUEST['modname'] . '&search_modfunc=list&next_modname=users/User.php&ajax=true&bottom_back=true&return_session=true target=body>Back to User List</A>');
            }
            //
        } else {
Example #24
0
    $textcolor_s = '#999999';
    $tabcolor_u = Preferences('HEADER');
    $textcolor_u = '#FFFFFF';
} else {
    $tabcolor_s = Preferences('HEADER');
    $textcolor_s = '#FFFFFF';
    $tabcolor_u = '#DFDFDF';
    $textcolor_u = '#999999';
}
//$header = '<TABLE border=0 cellpadding=0 cellspacing=0 height=14><TR>';
//$header .= '<TD width=10></TD><TD>'.DrawTab('Students',"Modules.php?modname=$_REQUEST[modname]&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=student",$tabcolor_s,$textcolor_s,'_circle',array('tabcolor'=>Preferences('HEADER'),'textcolor'=>'#FFFFFF')).'</TD>';
//$header .= '<TD width=10></TD><TD>'.DrawTab('Users',   "Modules.php?modname=$_REQUEST[modname]&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=staff",  $tabcolor_u,$textcolor_u,'_circle',array('tabcolor'=>Preferences('HEADER'),'textcolor'=>'#FFFFFF')).'</TD>';
//$header .= '<TD width=10></TD></TR></TABLE>';
//$header = "";
//DrawHeader(($_REQUEST['type']=='staff'?'User ':'******').ProgramTitle(),'<TABLE bgcolor=#ffffff><TR><TD>'.$header.'</TD></TR></TABLE>');
DrawBC("Food Service >> " . ProgramTitle());
if ($_REQUEST['modfunc'] == 'delete') {
    require_once 'modules/Food_Service/includes/DeletePromptX.fnc.php';
    if ($_REQUEST['item_id'] != '') {
        if (DeletePromptX('transaction item')) {
            require_once 'modules/Food_Service/includes/DeleteTransactionItem.fnc.php';
            DeleteTransactionItem($_REQUEST['transaction_id'], $_REQUEST['item_id'], $_REQUEST['type']);
            unset($_REQUEST['modfunc']);
            unset($_REQUEST['delete_ok']);
            unset($_SESSION['_REQUEST_vars']['modfunc']);
            unset($_SESSION['_REQUEST_vars']['delete_ok']);
        }
    } else {
        if (DeletePromptX('transaction')) {
            require_once 'modules/Food_Service/includes/DeleteTransaction.fnc.php';
            DeleteTransaction($_REQUEST['transaction_id'], $_REQUEST['type']);
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC("Gradebook > " . ProgramTitle());
if (!$_REQUEST['mp']) {
    $_REQUEST['mp'] = UserMP();
}
$sem = GetParentMP('SEM', UserMP());
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
$mp_select = "<SELECT name=mp onchange='document.forms[0].submit();'><OPTION value=" . UserMP() . ">" . GetMP(UserMP()) . "</OPTION><OPTION value=" . $sem . ($sem == $_REQUEST['mp'] ? ' SELECTED' : '') . ">" . GetMP($sem) . "</OPTION><OPTION value=E" . $sem . ('E' . $sem == $_REQUEST['mp'] ? ' SELECTED' : '') . ">" . GetMP($sem) . ' Exam</OPTION></SELECT>';
DrawHeaderHome($mp_select);
echo '</FORM>';
$sql = "SELECT CONCAT(s.LAST_NAME,', ',s.FIRST_NAME) as FULL_NAME,s.STAFF_ID,g.REPORT_CARD_GRADE_ID FROM STUDENT_REPORT_CARD_GRADES g,STAFF s,COURSE_PERIODS cp WHERE g.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cp.TEACHER_ID=s.STAFF_ID AND cp.SYEAR=s.SYEAR AND cp.SYEAR=g.SYEAR AND cp.SYEAR='" . UserSyear() . "' AND g.MARKING_PERIOD_ID='" . $_REQUEST['mp'] . "'";
$grouped_RET = DBGet(DBQuery($sql), array(), array('STAFF_ID', 'REPORT_CARD_GRADE_ID'));
$grades_RET = DBGet(DBQuery("SELECT rg.ID,rg.TITLE FROM REPORT_CARD_GRADES rg,REPORT_CARD_GRADE_SCALES rs WHERE rg.SCHOOL_ID='" . UserSchool() . "' AND rg.SYEAR='" . UserSyear() . "' AND rs.ID=rg.GRADE_SCALE_ID ORDER BY rs.SORT_ORDER,rs.ID,rg.BREAK_OFF IS NOT NULL DESC,rg.BREAK_OFF DESC,rg.SORT_ORDER"));
if (count($grouped_RET)) {
    foreach ($grouped_RET as $staff_id => $grades) {
        $i++;
        $teachers_RET[$i]['FULL_NAME'] = $grades[key($grades)][1]['FULL_NAME'];
Example #26
0
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC("Tools >> " . ProgramTitle());
if (isset($_REQUEST['del'])) {
    if ($_REQUEST['day_start'] && $_REQUEST['month_start'] && $_REQUEST['year_start']) {
        $start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . substr($_REQUEST['year_start'], 2, 4);
        $org_start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . $_REQUEST['year_start'];
        $conv_st_date = con_date($org_start_date);
    }
    if ($_REQUEST['day_end'] && $_REQUEST['month_end'] && $_REQUEST['year_end']) {
        $end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . substr($_REQUEST['year_end'], 2, 4);
        $org_end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . $_REQUEST['year_end'];
        $conv_end_date = con_date_end($org_end_date);
    }
    # ------------------------------- Deletion Of Log Records ----------------------------- #
    if (isset($conv_st_date) && isset($conv_end_date)) {
        $sql_del = DBQuery('DELETE FROM login_records WHERE LOGIN_TIME >=\'' . $conv_st_date . '\' AND LOGIN_TIME <=\'' . $conv_end_date . '\'');
        echo '<center><font color="red"><b>Log deleted successfully</b></font></center>';
Example #27
0
                    //echo '<div>'.$courses[1]['GRADE_ID'].' Grade</div>';
                    //echo '<div>'.ProperDate($date),$_REQUEST['mp_id']?GetMP($_REQUEST['mp_id']):''.'</div>';
                    ListOutputPrint($courses, $columns, '' . _('Course') . '', '' . _('Courses') . '', array(), array(), array('center' => false, 'print' => false));
                    echo '<div style="page-break-before: always;">&nbsp;</div><!-- NEW PAGE -->';
                }
            }
            PDFStop($handle);
        } else {
            BackPrompt(_('No Students were found.'));
        }
    } else {
        BackPrompt(_('You must choose at least one student.'));
    }
}
if (!$_REQUEST['modfunc']) {
    DrawBC("" . _('Scheduling') . " >> " . ProgramTitle());
    if ($_REQUEST['search_modfunc'] == 'list') {
        $mp_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,SORT_ORDER,1 AS TBL FROM school_years WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' UNION SELECT MARKING_PERIOD_ID,TITLE,SORT_ORDER,2 AS TBL FROM school_semesters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' UNION SELECT MARKING_PERIOD_ID,TITLE,SORT_ORDER,3 AS TBL FROM school_quarters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY TBL,SORT_ORDER'));
        $mp_select = '<SELECT name=mp_id><OPTION value="">' . _('N/A') . '';
        foreach ($mp_RET as $mp) {
            $mp_select .= '<OPTION value=' . $mp['MARKING_PERIOD_ID'] . '>' . $mp['TITLE'];
        }
        $mp_select .= '</SELECT>';
        echo "<meta charset='UTF-8'><FORM name=sch id=sch action=for_export.php?modname={$_REQUEST['modname']}&head_html=Student+Schedules+Report&modfunc=save&include_inactive={$_REQUEST['include_inactive']}&_openSIS_PDF=true method=POST target=_blank>";
        #$extra['header_right'] = '<INPUT type=submit value=\'Create Schedules for Selected Students\'>';
        PopTable_wo_header('header');
        $extra['extra_header_left'] = '<TABLE>';
        $extra['extra_header_left'] .= '<TR><TD align=right width=120>' . _('Marking Period') . '</TD><TD>' . $mp_select . '</TD></TR>';
        $extra['extra_header_left'] .= '<TR><TD align=right width=120>' . _('Include only courses active as of') . '</TD><TD>' . PrepareDate('', '_include_active_date') . '</TD></TR>';
        Widgets('mailing_labels', true);
        $extra['extra_header_left'] .= $extra['search'];
Example #28
0
#
#  This program is released under the terms of the GNU General Public License as
#  published by the Free Software Foundation, version 2 of the License.
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC("" . _('Attendance') . " > " . ProgramTitle());
$message = '<TABLE><TR><TD colspan=7 align=center>' . _('From') . ' ' . PrepareDate(DBDate(), '_min') . ' ' . _('to') . ' ' . PrepareDate(DBDate(), '_max') . '</TD></TR></TABLE>';
if (Prompt_Home(_('Confirm'), _('When do you want to recalculate the daily attendance?'), $message)) {
    $current_RET = DBGet(DBQuery('SELECT DISTINCT DATE_FORMAT(SCHOOL_DATE,\'%d-%m-%Y\') as SCHOOL_DATE FROM attendance_calendar WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\''), array(), array('SCHOOL_DATE'));
    $students_RET = GetStuList();
    $begin = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_min'], 'to_num'), $_REQUEST['day_min'] * 1, $_REQUEST['year_min']) + 43200;
    $end = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_max'], 'to_num'), $_REQUEST['day_max'] * 1, $_REQUEST['year_max']) + 43200;
    for ($i = $begin; $i <= $end; $i += 86400) {
        if ($current_RET[strtoupper(date('d-M-y', $i))]) {
            foreach ($students_RET as $student) {
                UpdateAttendanceDaily($student['STUDENT_ID'], date('d-M-y', $i));
            }
        }
    }
    unset($_REQUEST['modfunc']);
    DrawHeader('<table><tr><td><IMG SRC=assets/check.gif></td><td>' . _('The Daily Attendance for that timeframe has been recalculated.') . '</td></tr></table>');
Example #29
0
<?php

include '../../Redirect_modules.php';
DrawBC(_('School Setup') . " >> " . ProgramTitle());
if ($_REQUEST['page_display']) {
    echo '<style type="text/css">
.back_preference { padding:2px 0px 10px 8px; text-align:left; margin:5px 5px; }
</style>';
    echo "<div class=back_preference><a href=Modules.php?modname={$_REQUEST['modname']}><strong>&laquo;" . _('Back to System Preference') . "</strong>\n</a></div><br/>";
}
if (clean_param($_REQUEST['page_display'], PARAM_ALPHAMOD) == 'system_preference') {
    if (clean_param($_REQUEST['action'], PARAM_ALPHAMOD) == 'update' && clean_param($_REQUEST['button'], PARAM_ALPHAMOD) == _('Save') && clean_param($_REQUEST['values'], PARAM_NOTAGS) && $_POST['values'] && User('PROFILE') == 'admin') {
        $sql = 'UPDATE system_preference SET ';
        foreach ($_REQUEST['values'] as $column => $value) {
            $value = paramlib_validation($column, $value);
            $sql .= $column . '=\'' . str_replace("\\'", "''", $value) . '\',';
        }
        $sql = substr($sql, 0, -1) . ' WHERE SCHOOL_ID=\'' . UserSchool() . '\'';
        DBQuery($sql);
    } elseif (clean_param($_REQUEST['action'], PARAM_ALPHAMOD) == 'insert' && clean_param($_REQUEST['button'], PARAM_ALPHAMOD) == 'Save' && clean_param($_REQUEST['values'], PARAM_NOTAGS) && $_POST['values'] && User('PROFILE') == 'admin') {
        $sql = 'INSERT INTO system_preference SET ';
        foreach ($_REQUEST['values'] as $column => $value) {
            $value = paramlib_validation($column, $value);
            $sql .= $column . '=\'' . str_replace("\\'", "''", $value) . '\',';
        }
        $sql = substr($sql, 0, -1) . ',school_id=\'' . UserSchool() . '\'';
        DBQuery($sql);
    }
    $sys_pref = DBGet(DBQuery('SELECT * FROM system_preference WHERE SCHOOL_ID=' . UserSchool()));
    $sys_pref = $sys_pref[1];
    PopTable('header', _('Half-day and full-day minutes'));
Example #30
0
        } else {
            $header .= '<TD><b>' . '' . _(' No Parent Course Selected') . '' . '</b><br>' . _('Parent Course') . '' . '</TD>';
        }
        $header .= '<TD><b>' . $periods_RET[1]['START_TIME'] . '</b><br>' . _('Start Time') . '' . '</TD>';
        $header .= '<TD><b>' . $periods_RET[1]['END_TIME'] . '</b><br>' . _('End Time') . '' . '</TD><td></td>';
        $header .= '</TR>';
        $header .= '</TABLE>';
        DrawHeaderHome($header);
    }
    echo "</div></div></div><div class='tab_footer'>";
} else {
    unset($_SESSION['_REQUEST_vars']['subject_id']);
    unset($_SESSION['_REQUEST_vars']['course_id']);
    unset($_SESSION['_REQUEST_vars']['course_weight']);
    unset($_SESSION['_REQUEST_vars']['course_period_id']);
    DrawBC("" . _('Courses') . " > " . ProgramTitle());
    if ($_REQUEST['print'] != 'list') {
        echo PopTable('header', _('Quick Search'));
    }
    #echo "<FORM id='search' name='search' method=POST action=Modules.php?modname=$_REQUEST[modname]>";
    if ($_REQUEST['print'] != 'list') {
        echo "<FORM name=search id=search action=for_export.php?modname={$_REQUEST['modname']}&modfunc=print&marking_period_id=" . $_REQUEST['marking_period_id'] . "&_openSIS_PDF=true&report=true&print=list method=POST target=_blank>";
        echo '<table width=100%><tr><td align="center"><INPUT type=submit class=btn_medium value=\'' . _('Print') . '\'></td></tr></table>';
        echo '<TABLE align=left cellpadding="5" border="0"><TR>';
        echo '<TD valign=top align=left>';
    }
    $mp_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,SHORT_NAME,\'2\'  FROM school_quarters WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' UNION SELECT MARKING_PERIOD_ID,TITLE,SHORT_NAME,\'1\' FROM school_semesters WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' UNION SELECT MARKING_PERIOD_ID,TITLE,SHORT_NAME,\'0\' FROM school_years WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY 3,4'));
    unset($options);
    if (count($mp_RET)) {
        foreach ($mp_RET as $key => $value) {
            if ($value['MARKING_PERIOD_ID'] == $_REQUEST['marking_period_id']) {