/**
* 保存 font 列表
* @param string $data font 列表 数据
*/
function SaveFontList($saveFontListFile, $data = '')
{
SaveData($saveFontListFile, $data . "\n", TRUE);
}
}
$cp_id = implode(',', $cp_id);
$sql = 'SELECT MAX(SCHOOL_DATE) AS SCHOOL_DATE FROM attendance_period WHERE STUDENT_ID=\'' . UserStudentID() . '\' AND COURSE_PERIOD_ID IN (' . $cp_id . ')';
$attendence = DBGet(DBQuery($sql));
$max_at_dt = $attendence[1]['SCHOOL_DATE'];
if (strtotime($_REQUEST['values'][$table][$id][$column]) >= strtotime($max_at_dt)) {
SaveData($iu_extra, '', $field_names);
} else {
echo "<p align='center'><b style='color:red'>Student cannot be dropped because student has got attendance till " . date('m-d-Y', strtotime($max_at_dt)) . "</b></p>";
}
} else {
$get_details = DBGet(DBQuery('SELECT max(START_DATE) AS START_DATE FROM student_enrollment WHERE STUDENT_ID=' . UserStudentID()));
if (strtotime($get_details[1]['START_DATE']) > strtotime($_REQUEST['values'][$table][$id][$column])) {
echo "<p align='center'><b style='color:red'>Student drop date cannot be before student enrollment date </b></p>";
} else {
SaveData($iu_extra, '', $field_names);
}
}
}
} else {
echo "<p align='center'><b style='color:red'>Please enter proper drop date.Drop date must be greater than student enrollment date.</b></p>";
}
}
}
}
}
$functions = array('ENROLLMENT_CODE' => '_makeStartInputCodeenrl', 'DROP_CODE' => '_makeEndInputCodeenrl', 'SCHOOL_ID' => '_makeSchoolInput');
unset($THIS_RET);
$student_RET_qry = 'SELECT e.SYEAR, s.FIRST_NAME,s.LAST_NAME,s.GENDER, e.ID,e.GRADE_ID,e.ENROLLMENT_CODE,e.START_DATE,e.DROP_CODE,e.END_DATE,e.END_DATE AS END,e.SCHOOL_ID,e.NEXT_SCHOOL,e.CALENDAR_ID FROM student_enrollment e,students s WHERE e.STUDENT_ID=\'' . UserStudentID() . '\' AND e.SYEAR=\'' . UserSyear() . '\' AND e.STUDENT_ID=s.STUDENT_ID ORDER BY e.START_DATE';
$RET = DBGet(DBQuery($student_RET_qry));
$not_add = false;
$sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')';
DBQuery($sql);
if ($CentreModules['Food_Service']) {
// create default food service account for this student
$sql = "INSERT INTO FOOD_SERVICE_ACCOUNTS (ACCOUNT_ID,BALANCE,TRANSACTION_ID) values('{$student_id}','0.00','0')";
DBQuery($sql);
// associate with default food service account and assign other defaults
$sql = "INSERT INTO FOOD_SERVICE_STUDENT_ACCOUNTS (STUDENT_ID,DISCOUNT,BARCODE,ACCOUNT_ID) values('{$student_id}','','','{$student_id}')";
DBQuery($sql);
}
$_SESSION['student_id'] = $_REQUEST['student_id'] = $student_id;
$new_student = true;
}
}
if ($_REQUEST['values'] && $_REQUEST['include'] == 'Medical') {
SaveData(array('STUDENT_MEDICAL_ALERTS' => "ID='__ID__'", 'STUDENT_MEDICAL' => "ID='__ID__'", 'STUDENT_MEDICAL_VISITS' => "ID='__ID__'", 'fields' => array('STUDENT_MEDICAL' => 'ID,STUDENT_ID,', 'STUDENT_MEDICAL_ALERTS' => 'ID,STUDENT_ID,', 'STUDENT_MEDICAL_VISITS' => 'ID,STUDENT_ID,'), 'values' => array('STUDENT_MEDICAL' => db_seq_nextval('STUDENT_MEDICAL_SEQ') . ",'" . UserStudentID() . "',", 'STUDENT_MEDICAL_ALERTS' => db_seq_nextval('STUDENT_MEDICAL_ALERTS_SEQ') . ",'" . UserStudentID() . "',", 'STUDENT_MEDICAL_VISITS' => db_seq_nextval('STUDENT_MEDICAL_VISITS_SEQ') . ",'" . UserStudentID() . "',")));
}
if ($_REQUEST['include'] != 'General_Info' && $_REQUEST['include'] != 'Address' && $_REQUEST['include'] != 'Medical' && $_REQUEST['include'] != 'Other_Info') {
if (!strpos($_REQUEST['include'], '/')) {
include 'modules/Students/includes/' . $_REQUEST['include'] . '.inc.php';
} else {
include 'modules/' . $_REQUEST['include'] . '.inc.php';
}
}
unset($_REQUEST['modfunc']);
// SHOULD THIS BE HERE???
if (!UserStudentID()) {
unset($_REQUEST['values']);
}
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_SESSION['_REQUEST_vars']['values']);
}
$data["films"][$_REQUEST["film"]]["name"] = $_REQUEST["film_name"];
$data["films"][$_REQUEST["film"]]["originalname"] = $_REQUEST["film_originalname"];
$data["films"][$_REQUEST["film"]]["image"] = $film_image;
$data["films"][$_REQUEST["film"]]["trailer"] = $film_trailer;
$data["films"][$_REQUEST["film"]]["trailer_label"] = $_REQUEST["film_trailer_label"];
$data["films"][$_REQUEST["film"]]["infourl"] = $_REQUEST["film_infourl"];
$data["films"][$_REQUEST["film"]]["hit"] = $_REQUEST["hit"];
$data["films"][$_REQUEST["film"]]["visible"] = isset($_REQUEST["film_visible"]) ? 1 : 0;
}
break;
}
break;
default:
}
SaveData();
} else {
echo "Логин или пароль не совпадают";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Редактор анонсов</title>
<style>
*{
font-family: Tahoma, Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 8pt;
}
if ($un_chl_res != 'exist' && $pass_chl_res == 'exist') {
echo "<font color=red><b>Password already exist. Please try with a different password.</b></font>";
}
if ($un_chl_res == 'exist' && $pass_chl_res == 'exist') {
echo "<font color=red><b>Username and password already exist. Please try with a different user name and password.</b></font>";
}
}
}
$new_student = true;
}
}
if ($_REQUEST['values'] && $_REQUEST['include'] == 'MedicalInc') {
SaveData(array('student_medical_notes' => "ID='__ID__'", 'student_medical_alerts' => "ID='__ID__'", 'student_immunization' => "ID='__ID__'", 'student_medical_visits' => "ID='__ID__'", 'fields' => array('student_medical_notes' => 'STUDENT_ID,', 'student_immunization' => 'STUDENT_ID,', 'student_medical_alerts' => 'STUDENT_ID,', 'student_medical_visits' => 'STUDENT_ID,'), 'values' => array('student_medical_notes' => "'" . UserStudentID() . "',", 'student_immunization' => "'" . UserStudentID() . "',", 'student_medical_alerts' => "'" . UserStudentID() . "',", 'student_medical_visits' => "'" . UserStudentID() . "',")));
}
if ($_REQUEST['values'] && $_REQUEST['include'] == 'CommentsInc') {
SaveData(array('student_mp_comments' => "ID='__ID__'", 'fields' => array('student_mp_comments' => 'STUDENT_ID,SYEAR,MARKING_PERIOD_ID,STAFF_ID,'), 'values' => array('student_mp_comments' => "'" . UserStudentID() . "','" . UserSyear() . "','" . UserMP() . "','" . User('STAFF_ID') . "',")));
}
if ($_REQUEST['include'] != 'GeneralInfoInc' && $_REQUEST['include'] != 'AddressInc' && $_REQUEST['include'] != 'MedicalInc' && $_REQUEST['include'] != 'GoalInc' && $_REQUEST['include'] != 'OtherInfoInc' && $_REQUEST['include'] != 'EnrollmentInfoInc' && $_REQUEST['include'] != 'FilesInc') {
if (!strpos($_REQUEST['include'], '/')) {
include 'modules/students/includes/' . $_REQUEST['include'] . '.php';
} else {
include 'modules/' . $_REQUEST['include'] . '.php';
}
}
unset($_REQUEST['modfunc']);
// SHOULD THIS BE HERE???
if (!UserStudentID()) {
unset($_REQUEST['values']);
}
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_SESSION['_REQUEST_vars']['values']);
<?php
$semester_comments = 0;
//$_CENTRE['allow_edit'] = true;
if ($_REQUEST['modfunc'] == 'update') {
$existing_RET = DBGet(DBQuery("SELECT STUDENT_ID FROM STUDENT_MP_COMMENTS WHERE STUDENT_ID='" . UserStudentID() . "' AND SYEAR='" . UserSyear() . "' AND MARKING_PERIOD_ID='" . ($semester_comments ? GetParentMP('SEM', UserMP()) : UserMP()) . "'"));
if (!$existing_RET) {
DBQuery("INSERT INTO STUDENT_MP_COMMENTS (SYEAR,STUDENT_ID,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserStudentID() . "','" . ($semester_comments ? GetParentMP('SEM', UserMP()) : UserMP()) . "')");
}
SaveData(array('STUDENT_MP_COMMENTS' => "STUDENT_ID='" . UserStudentID() . "' AND SYEAR='" . UserSyear() . "' AND MARKING_PERIOD_ID='" . ($semester_comments ? GetParentMP('SEM', UserMP()) : UserMP()) . "'"), '', array('COMMENT' => _('Comment')));
//unset($_SESSION['_REQUEST_vars']['modfunc']);
//unset($_SESSION['_REQUEST_vars']['values']);
}
if (!$_REQUEST['modfunc']) {
$comments_RET = DBGet(DBQuery("SELECT COMMENT FROM STUDENT_MP_COMMENTS WHERE STUDENT_ID='" . UserStudentID() . "' AND SYEAR='" . UserSyear() . "' AND MARKING_PERIOD_ID='" . ($semester_comments ? GetParentMP('SEM', UserMP()) : UserMP()) . "'"));
echo '<TABLE>';
echo '<TR>';
echo '<TD valign=bottom>';
echo '<b>' . $mp['TITLE'] . ' ' . _('Comments') . '</b><BR>';
echo '<TEXTAREA id=textarea name=values[STUDENT_MP_COMMENTS][' . UserStudentID() . '][COMMENT] cols=66 rows=22' . (AllowEdit() ? '' : ' readonly') . ' onkeypress="document.getElementById(\'chars_left\').innerHTML=(1121-this.value.length); if(this.value.length>1121) {document.getElementById(\'chars_left\').innerHTML=\'' . _('Fewer than 0') . '\'}">';
echo $comments_RET[1]['COMMENT'];
echo '</TEXTAREA>';
echo '<table><tr><td><IMG SRC=assets/comment_button.gif onload="document.getElementById(\'chars_left\').innerHTML=1121-document.getElementById(\'textarea\').value.length";></td><td><small><div id=chars_left>1121</div></small></td><td><small>' . _('characters remaining.') . '<small></td></tr></table>';
echo '</TD>';
//echo '<TR><TD align=center><INPUT type=submit value=Save></TD></TR>';
echo '</TR></TABLE>';
echo "<br><b>* " . Localize('colon', _('If more than one teacher will be adding comments for this student')) . "</b><br>";
echo "<ul><li>" . _('Type your name above the comments you enter.') . "</li>";
echo "<li>" . _('Leave space for other teachers to enter their comments.') . "</li></ul>";
$_REQUEST['category_id'] = '4';
$separator = '<hr>';
<?php
//modif Francois: add School Configuration
$program_config = DBGet(DBQuery("SELECT * FROM PROGRAM_CONFIG WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' AND PROGRAM='students'"), array(), array('TITLE'));
//$_ROSARIO['allow_edit'] = true;
if ($_REQUEST['modfunc'] == 'update') {
$existing_RET = DBGet(DBQuery("SELECT STUDENT_ID FROM STUDENT_MP_COMMENTS WHERE STUDENT_ID='" . UserStudentID() . "' AND SYEAR='" . UserSyear() . "' AND MARKING_PERIOD_ID='" . ($program_config['STUDENTS_SEMESTER_COMMENTS'][1]['VALUE'] ? GetParentMP('SEM', UserMP()) : UserMP()) . "'"));
if (!$existing_RET) {
DBQuery("INSERT INTO STUDENT_MP_COMMENTS (SYEAR,STUDENT_ID,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserStudentID() . "','" . ($program_config['STUDENTS_SEMESTER_COMMENTS'][1]['VALUE'] ? GetParentMP('SEM', UserMP()) : UserMP()) . "')");
}
SaveData(array('STUDENT_MP_COMMENTS' => "STUDENT_ID='" . UserStudentID() . "' AND SYEAR='" . UserSyear() . "' AND MARKING_PERIOD_ID='" . ($program_config['STUDENTS_SEMESTER_COMMENTS'][1]['VALUE'] ? GetParentMP('SEM', UserMP()) : UserMP()) . "'"), '', array('COMMENT' => _('Comment')));
//unset($_SESSION['_REQUEST_vars']['modfunc']);
//unset($_SESSION['_REQUEST_vars']['values']);
}
if (empty($_REQUEST['modfunc'])) {
$comments_RET = DBGet(DBQuery("SELECT COMMENT FROM STUDENT_MP_COMMENTS WHERE STUDENT_ID='" . UserStudentID() . "' AND SYEAR='" . UserSyear() . "' AND MARKING_PERIOD_ID='" . ($program_config['STUDENTS_SEMESTER_COMMENTS'][1]['VALUE'] ? GetParentMP('SEM', UserMP()) : UserMP()) . "'"));
echo '<TABLE>';
echo '<TR>';
echo '<TD style="vertical-align:bottom;">';
echo '<b>' . $mp['TITLE'] . ' ' . _('Comments') . '</b><BR />';
//modif Francois: remove maxlength limitation as it is not technically needed
echo '<TEXTAREA id="textarea" name="values[STUDENT_MP_COMMENTS][' . UserStudentID() . '][COMMENT]" cols="66" rows="27"' . (AllowEdit() ? '' : ' readonly') . '>';
echo $comments_RET[1]['COMMENT'];
echo '</TEXTAREA>';
echo '</TD>';
echo '</TR></TABLE>';
echo '<BR /><b>* ' . Localize('colon', _('If more than one teacher will be adding comments for this student')) . '</b><BR />';
echo '<ul><li>' . _('Type your name above the comments you enter.') . '</li></ul>';
//echo '<li>'._('Leave space for other teachers to enter their comments.').'</li></ul>';
$_REQUEST['category_id'] = '4';
$separator = '<hr>';
