$title .= '<br><br> <span align="center">Teacher Re-Assignment Done <a href="#" onclick="load_link(\'Modules.php?modname=' . $_REQUEST['modname'] . '&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id'] . '&course_period_id=' . $_REQUEST['course_period_id'] . '&action=undo\')">Undo</a></span>';
}
echo "<FORM name=F2 id=F2 action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&subject_id=" . strip_tags(trim($_REQUEST[subject_id])) . "&course_id=" . strip_tags(trim($_REQUEST[course_id])) . "&course_period_id=" . strip_tags(trim($_REQUEST[course_period_id])) . " method=POST>";
DrawHeaderHome($title, SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_teacher_reassignment();"'));
$header .= '<TABLE cellpadding=3 width=760 >';
$header .= '<TR>';
$header .= '<TD>Select New Teacher :</TD>';
$teachers_RET = DBGet(DBQuery('SELECT STAFF_ID,LAST_NAME,FIRST_NAME,MIDDLE_NAME FROM staff st INNER JOIN staff_school_relationship ssr USING (staff_id) WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND PROFILE=\'teacher\' AND staff_id <>\'' . $RET['TEACHER_ID'] . '\' AND (IS_DISABLE IS NULL OR IS_DISABLE<>\'Y\') ORDER BY LAST_NAME,FIRST_NAME '));
if (count($teachers_RET)) {
foreach ($teachers_RET as $teacher) {
$teachers[$teacher['STAFF_ID']] = $teacher['LAST_NAME'] . ', ' . $teacher['FIRST_NAME'] . ' ' . $teacher['MIDDLE_NAME'];
}
}
$header .= '<TD>' . SelectInput('', 're_assignment_teacher', '', $teachers) . '</TD>';
$header .= '<TD>Assign Date :</TD>';
$header .= '<TD>' . DateInputAY('', 're_assignment', 1) . '</TD>';
$header .= '<TD><TD><input type=hidden name=course_period_id value=' . $_REQUEST['course_period_id'] . '><input type=hidden name=re_assignment_pre_teacher value=' . $RET['TEACHER_ID'] . '></TD>';
$header .= '</TR></TABLE>';
DrawHeaderHome($header);
echo '</FORM>';
//--------------------------------------------Re Assignment Record-------------------------------------------------------------
$sql = 'SELECT COURSE_PERIOD_ID,(SELECT CONCAT_WS(\' \',last_name,middle_name,first_name) FROM staff WHERE staff_id=teacher_id) AS TEACHER,ASSIGN_DATE,(SELECT CONCAT_WS(\' \',last_name,middle_name,first_name) FROM staff WHERE staff_id=pre_teacher_id) AS PRE_TEACHER_ID,MODIFIED_DATE,(SELECT CONCAT_WS(\' \',last_name,first_name) FROM staff WHERE staff_id=modified_by) AS MODIFIED_BY FROM teacher_reassignment WHERE course_period_id=\'' . $_REQUEST['course_period_id'] . '\' ORDER BY assign_date DESC';
$QI = DBQuery($sql);
$courses_RET = DBGet($QI, array('ASSIGN_DATE' => 'ProperDAte', 'MODIFIED_DATE' => 'ProperDate'));
echo '<TABLE width=100%><TR><TD valign=top>';
$LO_options = array('save' => false, 'search' => false);
$columns = array('TEACHER' => 'Teacher', 'ASSIGN_DATE' => 'Assign Date', 'PRE_TEACHER_ID' => 'Previous Teacher', 'MODIFIED_DATE' => 'Modified Date', 'MODIFIED_BY' => 'Modified By');
$link = array();
$link['TITLE']['variables'] = array('course_id' => 'COURSE_ID');
ListOutput($courses_RET, $columns, 'Re-Assignment Record', 'Re-Assignment Records', $link, array(), $LO_options);
echo '</TD></TR></TABLE>';
echo '<TD style="width:120px">';
echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeAutoSelectInput('CUSTOM_' . $field['ID']);
echo '</TD>';
echo '</TR>';
break;
case 'numeric':
echo '<TR>';
echo '<TD style="width:120px">';
echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeTextInput('CUSTOM_' . $field['ID'], '', 'size=5 maxlength=10 class=cell_floating');
echo '</TD>';
echo '</TR>';
break;
case 'date':
echo '<TR>';
echo '<TD style="width:120px">';
echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . DateInputAY($value['CUSTOM_' . $field['ID']], 'CUSTOM_' . $field['ID'], $field['ID']);
echo '<input type=hidden name=custom_date_id[] value="' . $field['ID'] . '" />';
echo '</TD>';
echo '</TR>';
break;
case 'codeds':
case 'select':
echo '<TR>';
echo '<TD style="width:120px">';
echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeSelectInput('CUSTOM_' . $field['ID'], '');
echo '</TD>';
echo '</TR>';
break;
case 'multiple':
echo '<TR>';
echo '<TD style="width:120px">';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px>Name<font color=red>*</font></td><td>:</td><td>';
if ($_REQUEST['student_id'] == 'new') {
unset($_SESSION['students_order']);
echo '<TABLE ><TR><TD >' . TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '<FONT color=red>First</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', 'Middle', 'class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '<FONT color=red>Last</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD></TR></TABLE>';
} else {
echo '<DIV id=student_name><div style="font-size:14px; font-weight:bold;" onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '<FONT color=red>First</FONT>', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', 'Middle', 'size=3 maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '<FONT color=red>Last</FONT>', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD></TR></TABLE>","student_name",true);\'>' . $student['FIRST_NAME'] . ' ' . $student['MIDDLE_NAME'] . ' ' . $student['LAST_NAME'] . ' </div></DIV>';
}
echo '</td></tr>';
//<TD>'.SelectInput($student['NAME_SUFFIX'],'students[NAME_SUFFIX]','Suffix',array('Jr.'=>'Jr.','Sr.'=>'Sr.'),'','style="font-size:14px; font-weight:bold;"').'</TD>
//<TD>'.str_replace('"','\"',SelectInput($student['NAME_SUFFIX'],'students[NAME_SUFFIX]','Suffix',array('Jr.'=>'Jr.','Sr.'=>'Sr.','II'=>'II','III'=>'III','IV'=>'IV','V'=>'V'),'','style="font-size:14px; font-weight:bold;"',false)).'</TD>
echo '<tr><td>Common Name / 中文名</td><td>:</td><td>' . TextInput($student['COMMON_NAME'], 'students[COMMON_NAME]', '', 'size=10 class=cell_medium maxlength=10') . '</td></tr>';
echo '<tr><td>Gender</td><td>:</td><td>' . SelectInput($student['GENDER'], 'students[GENDER]', '', array('Male' => 'Male', 'Female' => 'Female'), 'N/A', '') . '</td></tr>';
echo '<tr><td>Ethnicity</td><td>:</td><td>' . SelectInput($student['ETHNICITY'], 'students[ETHNICITY]', '', $ethnic_option, 'N/A', '') . '</td></tr>';
echo '<input type=hidden id=current_date value=' . date('Y-m-d') . '>';
echo '<tr><td>Date of Birth<font color="red">*</font></td><td>:</td><td>' . DateInputAY($student['BIRTHDATE'], 'students[BIRTHDATE]', '2') . '</td></tr>';
//echo '<tr><td>Primary Language</td><td>:</td><td>'.SelectInput($student['LANGUAGE'],'students[LANGUAGE]','',$language_option,'N/A','').'</td></tr>';
if ($_REQUEST['student_id'] == 'new') {
$id_sent = 0;
} else {
$id_sent = UserStudentID();
}
echo '<tr><td>Email</td><td>:</td><td>' . TextInput($student['EMAIL'], 'students[EMAIL]', '', 'size=100 class=cell_medium maxlength=100 onkeyup=check_email(this,' . $id_sent . ',3); onblur=check_email(this,' . $id_sent . ',3)') . '<div id=email_error></div></td></tr>';
echo '<tr><td>Phone</td><td>:</td><td>' . TextInput($student['PHONE'], 'students[PHONE]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
echo '<tr><td>Studying at</td><td>:</td><td>' . TextInput($student['LANGUAGE'], 'students[LANGUAGE]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Fees</b></td></tr><tr><td colspan="2">';
echo '<tr><td>Registration Fee </td><td>:</td><td>' . TextInput($student['ESTIMATED_GRAD_DATE'], 'students[ESTIMATED_GRAD_DATE]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
echo '<tr><td>Deposit </td><td>:</td><td>' . TextInput($student['NAME_SUFFIX'], 'students[NAME_SUFFIX]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
#############################################CUSTOM FIELDS###############################
$fields_RET = DBGet(DBQuery('SELECT ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,REQUIRED,HIDE,SORT_ORDER FROM custom_fields WHERE SYSTEM_FIELD=\'N\' AND CATEGORY_ID=\'' . $_REQUEST[category_id] . '\' ORDER BY SORT_ORDER,TITLE'));
if (UserStudentID()) {
# 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';
if (!$_REQUEST['modfunc']) {
$start_date = date('Y-m') . '-01';
$end_date = DBDate('mysql');
echo "<br><FORM name=log id=log action=Modules.php?modname={$_REQUEST['modname']}&modfunc=generate method=POST>";
PopTable('header', 'Log Details');
echo '<div align=center style="padding-top:20px; font-size:12px;"><strong>Please Select Date Range</strong></div><br />
<TABLE border=0 width=100% align=center><tr><TD valign=middle>';
echo '<strong>From :</strong> </TD><TD valign=middle>';
DrawHeader(DateInputAY($start_date, 'start', 1));
echo '</TD><TD valign=middle><strong>To :</strong> </TD><TD valign=middle>';
DrawHeader(DateInputAY($end_date, 'end', 2));
echo '</TD></TR></TABLE><div style=height:10px></div>';
echo '<center><input type="submit" class=btn_medium value="Generate" name="generate"></center>';
PopTable('footer');
echo '</FORM>';
}
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);
}
</tr>
<tr>
<td align="right">I am a :</td><td><input type="hidden" name="user_type_form" id="user_type_form" value="username" disabled="disabled"/><input type="radio" name="uname_user_type" id="uname_student" value="uname_student" checked="checked" disabled="disabled" onclick="uname_show_fields('student')" /><label>Student</label> <input type="radio" name="uname_user_type" id="uname_staff" value="uname_staff" disabled="disabled" onclick="uname_show_fields('staff');forgotpassemail_init('uname_email');" /><label>Staff</label> <input type="radio" name="uname_user_type" id="uname_parent" disabled="disabled" value="uname_parent" onclick="uname_show_fields('parent');forgotpassemail_init('uname_email');" /><label>Parent</label></td>
</tr>
<tr id="uname_stu_id">
<td width="30%" align="right">Student ID :</td>
<td width="70%"><input type="text" name="username_stn_id" id="username_stn_id" disabled="disabled" class="login_txt" onblur="return check_input_val(this.value,'username_stn_id');" onkeydown="return numberOnly(event);"/></td>
</tr>
<tr>
<td width="30%" align="right">Password :</td>
<td width="70%"><input type="password" name="pass" id="pass" class="login_txt" disabled="disabled"/></td>
</tr>
<tr id="uname_stu_dob">
<td width="30%" align="right">Date of Birth :</td>
<td width="70%"><?php
echo DateInputAY('', 'username_dob', 2);
?>
</td>
</tr>
<tr id="uname_stf_email" style="display: none">
<td width="30%" align="right">Email Address :<input type="hidden" name="un_email" id="un_email" value=""/></td>
<td width="70%"><input type="text" name="username_stf_email" id="username_stf_email" disabled="disabled" class="login_txt" onblur="forgotpassemail_init('uname_email');" /><span style="display: none" id="uname_calculating_email"><img src="assets/ajax_loader.gif"/></span><span id="uname_err_msg_email"></span></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="save" class="btn" value="Confirm" onClick="return forgotusername();"/>
</td>
</tr>
<tr>
<td align='center'></td>
<td></td>
}
$enroll_msg = $s . " " . implode(",", $id_array) . " cannot be reenrolled because reenroll date and drop date are same or reenrollment date is before end date. ";
}
}
} else {
$err = "<b><font color=red>No students are selected.</font></b>";
}
unset($_REQUEST['modfunc']);
}
DrawBC("Students > " . ProgramTitle());
if ($_REQUEST['search_modfunc'] == 'list') {
echo "<FORM name=sav id=sav action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save method=POST>";
PopTable_wo_header('header');
$calendar = DBGet(DBQuery('SELECT CALENDAR_ID FROM school_calendars WHERE SCHOOL_ID=\'' . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY DEFAULT_CALENDAR DESC LIMIT 0,1"));
echo '<INPUT TYPE=hidden name=cal_id value=' . $calendar[1]["CALENDAR_ID"] . '>';
echo '<TABLE><TR><TD>Start Date <font color="red">*</font> </TD><TD>: </TD><TD>' . DateInputAY(DBDate('mysql'), 'start', 1) . '</TD></TR>';
echo '<TR><TD>Grade<font color="red">*</font> </TD><TD>: </TD><TD>';
$sel_grade = DBGet(DBQuery('SELECT TITLE,ID FROM school_gradelevels WHERE SCHOOL_ID=\'' . UserSchool() . '\''));
echo '<SELECT name=grade_id id=grade_id><OPTION value="">Select Grade</OPTION>';
foreach ($sel_grade as $g_id) {
echo "<OPTION value={$g_id['ID']}>" . $g_id['TITLE'] . '</OPTION>';
}
echo '</SELECT>';
echo '</TD></TR>';
echo '<TR><TD>Enrollment Code <font color="red">*</font> </TD><TD>: </TD><TD>';
$enroll_code = DBGet(DBQuery('SELECT TITLE,ID FROM student_enrollment_codes WHERE SYEAR=\'' . UserSyear() . '\' AND TYPE IN (\'' . Add . '\',\'' . TrnE . '\',\'' . Roll . '\')'));
echo '<SELECT name=en_code id=en_code><OPTION value="">Select Enroll Code</OPTION>';
foreach ($enroll_code as $enr_code) {
echo "<OPTION value={$enr_code['ID']}>" . $enr_code['TITLE'] . '</OPTION>';
}
echo '</SELECT>';
function _makeDate($value, $column)
{
global $THIS_RET;
static $counter = 0;
//
if ($column == 'START_DATE') {
$allow_na = false;
} else {
$allow_na = true;
}
if ($column == 'END_DATE' && $THIS_RET[END_DATE] != '') {
return date('M/d/Y', strtotime($value));
} else {
$counter++;
return '<div style="white-space: nowrap;">' . DateInputAY($value, "schedule[{$THIS_RET['COURSE_PERIOD_ID']}][{$THIS_RET['START_DATE']}][{$column}]", $counter . $THIS_RET[COURSE_PERIOD_ID]) . '</div>';
}
}
}
}
} else {
$period_select .= '<OPTION value="PERIOD"' . ($_REQUEST['period_id'] ? ' SELECTED' : '') . '>By Period</OPTION>';
}
$period_select .= '</SELECT>';
if (User('PROFILE') == 'teacher') {
$myclasses = '<SELECT name="myclasses" onchange="this.form.submit();">';
$myclasses .= '<OPTION value=""' . ($_REQUEST['myclasses'] == '' ? ' SELECTED' : '') . '>All course periods</OPTION>';
$myclasses .= '<OPTION value="my_classes"' . ($_REQUEST['myclasses'] == 'my_classes' ? ' SELECTED' : '') . '>All my course periods</OPTION>';
$myclasses .= '<OPTION value="selected_class"' . ($_REQUEST['myclasses'] == 'selected_class' ? ' SELECTED' : '') . '>Selected course period</OPTION>';
$myclasses .= '</SELECT>';
}
echo "<FORM action={$PHP_tmp_SELF} method=POST>";
echo "<div>";
DrawHeaderHome('<table><tr><td>' . DateInputAY($start_date, 'start', 1) . '</td><td> - </td><td>' . DateInputAY($end_date, 'end', 2) . '</td><td> : </td><td>' . $period_select . ' : <INPUT type=submit class=btn_medium value=Go>' . ($_REQUEST['period_id'] ? '<td>' . $myclasses . '</td>' : '') . '</tr></table>');
}
$cal_RET = DBGet(DBQuery('SELECT DISTINCT SCHOOL_DATE,CONCAT(\'_\',DATE_FORMAT(SCHOOL_DATE,\'%Y%m%d\')) AS SHORT_DATE FROM attendance_calendar WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SCHOOL_DATE BETWEEN \'' . date('Y-m-d', strtotime($start_date)) . '\' AND \'' . date('Y-m-d', strtotime($end_date)) . '\' ORDER BY SCHOOL_DATE'));
if (UserStudentID() || $_REQUEST['student_id'] || User('PROFILE') == 'parent') {
// JUST TO SET USERSTUDENTID()
Search('student_id');
$MP_TYPE_RET = DBGet(DBQuery('SELECT MP_TYPE FROM marking_periods WHERE MARKING_PERIOD_ID=\'' . UserMP() . '\' LIMIT 1'));
$MP_TYPE = $MP_TYPE_RET[1]['MP_TYPE'];
if ($MP_TYPE == 'year') {
$MP_TYPE = 'FY';
} else {
if ($MP_TYPE == 'semester') {
$MP_TYPE = 'SEM';
} else {
if ($MP_TYPE == 'quarter') {
$MP_TYPE = 'QTR';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px><span class=red>*</span>Name</td><td>:</td><td>';
$_SESSION['staff_selected'] = $staff['STAFF_ID'];
if ($_REQUEST['staff_id'] == 'new') {
echo '<TABLE><TR><TD>' . SelectInput($staff['TITLE'], 'staff[TITLE]', '<span class=red>Salutation</span>', array('Mr.' => 'Mr.', 'Mrs.' => 'Mrs.', 'Ms.' => 'Ms.', 'Miss' => 'Miss', 'Dr' => 'Dr', 'Rev' => 'Rev'), '') . '</TD><TD>' . TextInput($staff['FIRST_NAME'], 'staff[FIRST_NAME]', '<FONT class=red>First</FONT>', 'maxlength=50 class=cell_floating') . '</TD><TD>' . TextInput($staff['MIDDLE_NAME'], 'staff[MIDDLE_NAME]', 'Middle', 'maxlength=50 class=cell_floating') . '</TD><TD>' . TextInput($staff['LAST_NAME'], 'staff[LAST_NAME]', '<FONT color=red>Last</FONT>', 'maxlength=50 class=cell_floating') . '</TD><TD valign=top>' . SelectInput($staff['NAME_SUFFIX'], 'staff[NAME_SUFFIX]', 'Suffix', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"') . '</TD></TR></TABLE>';
} else {
echo '<DIV id=user_name><div onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', SelectInput($staff['TITLE'], 'staff[TITLE]', 'Salutation', array('Mr.' => 'Mr.', 'Mrs.' => 'Mrs.', 'Ms.' => 'Ms.', 'Miss' => 'Miss', 'Dr' => 'Dr', 'Rev' => 'Rev'), '', '', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput(trim($staff['FIRST_NAME']), 'staff[FIRST_NAME]', (!$staff['FIRST_NAME'] ? '<FONT color=red>' : '') . 'First' . (!$staff['FIRST_NAME'] ? '</FONT>' : ''), 'maxlength=50', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($staff['MIDDLE_NAME'], 'staff[MIDDLE_NAME]', 'Middle', 'size=3 maxlength=50', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput(trim($staff['LAST_NAME']), 'staff[LAST_NAME]', (!$staff['LAST_NAME'] ? '<FONT color=red>' : '') . 'Last' . (!$staff['LAST_NAME'] ? '</FONT>' : ''), 'maxlength=50', false)) . '</TD><TD valign=top>' . str_replace('"', '\\"', SelectInput($staff['NAME_SUFFIX'], 'staff[NAME_SUFFIX]', '', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"', false)) . '</TD></TR></TABLE>","user_name",true);\'>' . (!$staff['TITLE'] && !$staff['FIRST_NAME'] && !$staff['MIDDLE_NAME'] && !$staff['LAST_NAME'] && !$staff['NAME_SUFFIX'] ? '-' : $staff['TITLE'] . ' ' . $staff['FIRST_NAME'] . ' ' . $staff['MIDDLE_NAME'] . ' ' . $staff['LAST_NAME']) . ' ' . $staff['NAME_SUFFIX'] . '</div></DIV><small>' . (!$staff['FIRST_NAME'] || !$staff['LAST_NAME'] ? '<FONT color=red>' : '<FONT color=' . Preferences('TITLES') . '>') . '</FONT></small>';
}
echo '</td></tr>';
echo '<tr><td>Staff ID</td><td>:</td><td>' . NoInput($staff['STAFF_ID'], '') . '</td></tr>';
echo '<tr><td>NRIC/Passport ID</td><td>:</td><td>';
echo TextInput($staff['ALTERNATE_ID'], 'staff[ALTERNATE_ID]', '', 'size=12 maxlength=100 class=cell_floating ') . '</td></tr>';
$options = array('Dr.' => 'Dr.', 'Mr.' => 'Mr.', 'Ms.' => 'Ms.', 'Rev.' => 'Rev.', 'Miss.' => 'Miss.');
echo '<tr><td><span class=red></span>Gender</td><td>:</td><td>' . SelectInput($staff['GENDER'], 'staff[GENDER]', '', array('Male' => 'Male', 'Female' => 'Female'), 'N/A', '') . '</td></tr>';
echo '<tr><td><span class=red></span>Date of Birth</td><td>:</td><td>';
echo DateInputAY($staff['BIRTHDATE'], 'staff[BIRTHDATE]', 1) . '</td></tr>';
$ETHNICITY_RET = DBGet(DBQuery("SELECT ETHNICITY_ID,ETHNICITY_NAME FROM ethnicity ORDER BY SORT_ORDER"));
foreach ($ETHNICITY_RET as $ethnicity_array) {
$ethnicity[$ethnicity_array['ETHNICITY_ID']] = $ethnicity_array['ETHNICITY_NAME'];
}
echo '<tr><td><span class=red></span>Ethnicity</td><td>:</td><td>' . SelectInput($staff['ETHNICITY_ID'], 'staff[ETHNICITY_ID]', '', $ethnicity, 'N/A', '') . '</td></tr>';
$LANGUAGE_RET = DBGet(DBQuery("SELECT LANGUAGE_ID,LANGUAGE_NAME FROM language ORDER BY SORT_ORDER"));
foreach ($LANGUAGE_RET as $language_array) {
$language[$language_array['LANGUAGE_ID']] = $language_array['LANGUAGE_NAME'];
}
echo '<tr><td><span class=red></span>Primary Language</td><td>:</td><td>' . SelectInput($staff['PRIMARY_LANGUAGE_ID'], 'staff[PRIMARY_LANGUAGE_ID]', '', $language, 'N/A', '') . '</td></tr>';
echo '<tr><td>Second Language</td><td>:</td><td>' . SelectInput($staff['SECOND_LANGUAGE_ID'], 'staff[SECOND_LANGUAGE_ID]', '', $language, 'N/A', '') . '</td></tr>';
//echo '<tr><td>Third Language</td><td>:</td><td>'.SelectInput($staff['THIRD_LANGUAGE_ID'],'staff[THIRD_LANGUAGE_ID]','',$language,'N/A','').'</td></tr>';
if ($_REQUEST['staff_id'] == 'new') {
$id_sent = 0;
} else {
}
}
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 "<FORM name=sch id=sch action=ForExport.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&head_html=Student+Schedules+Report&modfunc=save&include_inactive={$_REQUEST['include_inactive']}&_openSIS_PDF=true method=POST target=_blank>";
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>' . DateInputAY('', 'include_active_date', 1) . '</TD></TR>';
Widgets('mailing_labels', true);
$extra['extra_header_left'] .= $extra['search'];
$extra['search'] = '';
$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['options']['search'] = false;
$extra['new'] = true;
Widgets('request');
Widgets('course');
Search('student_id', $extra);
if ($_REQUEST['search_modfunc'] == 'list') {
}
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'edit_calendar') {
$colmn = Calender_Id;
$cal_id = paramlib_validation($colmn, $_REQUEST['calendar_id']);
$acs_RET = DBGet(DBQuery('SELECT TITLE, DEFAULT_CALENDAR FROM school_calendars WHERE CALENDAR_ID=\'' . $cal_id . '\''));
$acs_RET = $acs_RET[1];
$ac_RET = DBGet(DBQuery('SELECT MIN(SCHOOL_DATE) AS START_DATE,MAX(SCHOOL_DATE) AS END_DATE FROM attendance_calendar WHERE CALENDAR_ID=\'' . $cal_id . '\''));
$ac_RET = $ac_RET[1];
$day_RET = DBGet(DBQuery('SELECT DAYNAME(SCHOOL_DATE) AS DAY_NAME FROM attendance_calendar WHERE CALENDAR_ID=\'' . $cal_id . '\' ORDER BY SCHOOL_DATE LIMIT 0, 7'));
$i = 0;
foreach ($day_RET as $day) {
$weekdays[$i] = $day['DAY_NAME'];
$i++;
}
$message = '<TABLE cellspacing=0 cellpadding=0 border=0 ><TR><TD colspan=7 align=center>Title <INPUT type=text name=title class=cell_floating id=title value="' . $acs_RET[TITLE] . '"> <INPUT type=checkbox name=default value=Y ' . ($acs_RET['DEFAULT_CALENDAR'] == 'Y' ? 'checked' : '') . '> Default Calendar for this School<BR><BR></TD></TR><TR><TD colspan=7 align=center>From</TD></TR><TR><TD colspan=7 align=center> ' . DateInputAY($ac_RET['START_DATE'], '_min', 1) . '</TD></TR><TR><TD colspan=7 align=center> To </TD></TR><TR><TD colspan=7 align=center >' . DateInputAY($ac_RET['END_DATE'], '_max', 2) . '</TD></TR><TR><TD class=clear></TD></TR><TR><TD><INPUT type=checkbox value=Y name=weekdays[0] ' . (in_array('Sunday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Sunday</TD><TD><INPUT type=checkbox value=Y name=weekdays[1] ' . (in_array('Monday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Monday</TD><TD><INPUT type=checkbox value=Y name=weekdays[2] ' . (in_array('Tuesday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Tuesday</TD><TD><INPUT type=checkbox value=Y name=weekdays[3] ' . (in_array('Wednesday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Wednesday</TD><TD><INPUT type=checkbox value=Y name=weekdays[4] ' . (in_array('Thursday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Thursday</TD><TD><INPUT type=checkbox value=Y name=weekdays[5] ' . (in_array('Friday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Friday</TD><TD><INPUT type=checkbox value=Y name=weekdays[6] ' . (in_array('Saturday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Saturday</TD></TR></TABLE>';
$message .= calendarEventsVisibility();
if (Prompt_Calender('Edit this calendar', '', $message)) {
$col = Calender_Title;
$cal_title = singleQuoteReplace("'", "''", $_REQUEST['title']);
$dup_cal_title = DBGet(DBQuery('SELECT count(*) AS NO FROM school_calendars WHERE TITLE=\'' . $cal_title . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' AND CALENDAR_ID NOT IN(' . $cal_id . ')'));
if (isset($_REQUEST['default']) && $dup_cal_title[1]['NO'] == 0) {
DBQuery('UPDATE school_calendars SET DEFAULT_CALENDAR = NULL WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\'');
}
if ($dup_cal_title[1]['NO'] == 0) {
DBQuery('UPDATE school_calendars SET TITLE = \'' . $cal_title . '\', DEFAULT_CALENDAR = \'' . $_REQUEST['default'] . '\' WHERE CALENDAR_ID=\'' . $cal_id . '\'');
DBQuery('DELETE FROM calendar_events_visibility WHERE calendar_id=\'' . $cal_id . '\'');
}
if (count($_REQUEST['profiles'])) {
$profile_sql = 'INSERT INTO calendar_events_visibility(calendar_id,profile_id,profile) VALUES';
foreach ($_REQUEST['profiles'] as $key => $profile) {
if ($id == "new" || $_REQUEST['tab_id'] == "new" || $RET['POINTS'] == '') {
$extra = ' size=4 maxlength=5 onkeydown="return numberOnlyMod(event,this);" ';
} else {
$extra = ' size=4 maxlength=5 onkeydown=\\"return numberOnlyMod(event,this);\\"';
}
$header .= '<TD>' . TextInput($RET['POINTS'], 'tables[' . $_REQUEST['assignment_id'] . '][POINTS]', ($RET['POINTS'] != '' ? '' : '<FONT color=red>') . 'Points' . ($RET['POINTS'] ? '' : '</FONT>'), $extra) . '</TD>';
if ($_REQUEST['assignment_id'] == 'new') {
$header .= '<TD>' . CheckboxInput($RET['COURSE_ID'], 'tables[' . $_REQUEST['assignment_id'] . '][COURSE_ID]', 'Apply to all Periods for this Course') . '</TD>';
}
foreach ($types_RET as $type) {
$assignment_type_options[$type['ASSIGNMENT_TYPE_ID']] = $type['TITLE'];
}
$header .= '<TD>' . SelectInput($RET['ASSIGNMENT_TYPE_ID'] ? $RET['ASSIGNMENT_TYPE_ID'] : $_REQUEST['assignment_type_id'], 'tables[' . $_REQUEST['assignment_id'] . '][ASSIGNMENT_TYPE_ID]', 'Assignment Type', $assignment_type_options, false) . '</TD>';
$header .= '</TR><TR>';
$header .= '<TD valign=top>' . DateInputAY($new && Preferences('DEFAULT_ASSIGNED', 'Gradebook') == 'Y' ? date('y-m-d') : $RET['ASSIGNED_DATE'], 'tables[' . $_REQUEST['assignment_id'] . '][ASSIGNED_DATE]', 1) . ($_REQUEST['assignment_id'] == 'new' ? '<br><small><font color="gray">Assigned<font color="gray"></font></font></small>' : '<small><font color="gray">Assigned Date<font color="gray"></font></font></small>') . '</TD>';
$header .= '<TD valign=top>' . DateInputAY($new && Preferences('DEFAULT_DUE', 'Gradebook') == 'Y' ? date('y-m-d') : $RET['DUE_DATE'], 'tables[' . $_REQUEST['assignment_id'] . '][DUE_DATE]', 2) . ($_REQUEST['assignment_id'] == 'new' ? '<br><small><font color="gray">Due<font color="gray"></font></font></small>' : '<small><font color="gray">Due Date<font color="gray"></font></font></small>') . '</TD>';
$header .= '<TD rowspan=2 colspan=2><TD></TR>';
} elseif ($_REQUEST['assignment_type_id']) {
echo "<FORM name=F3 action=Modules.php?modname={$_REQUEST['modname']}&table=gradebook_assignment_types";
if ($_REQUEST['assignment_type_id'] != 'new') {
echo "&assignment_type_id={$_REQUEST['assignment_type_id']}";
}
echo " method=POST>";
DrawHeader($title, $delete_button . '<INPUT type=submit value=Save onclick="formcheck_assignments();">');
$header .= '<TABLE cellpadding=3 bgcolor=#F0F0F1 width=100%>';
$header .= '<TR>';
$header .= '<TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['assignment_type_id'] . '][TITLE]', 'Title', 'size=36') . '</TD>';
if ($programconfig['WEIGHT'] == 'Y') {
$header .= '<TD>' . TextInput($RET['FINAL_GRADE_PERCENT'], 'tables[' . $_REQUEST['assignment_type_id'] . '][FINAL_GRADE_PERCENT]', ($RET['FINAL_GRADE_PERCENT'] != 0 ? '' : '<FONT color=red>') . 'Percent of Final Grade' . ($RET['FINAL_GRADE_PERCENT'] != 0 ? '' : '</FONT>')) . '</TD>';
$header .= '<TD>' . NoInput($RET['TOTAL_PERCENT'] == 1 ? '100%' : '<FONT COLOR=red>' . 100 * $RET['TOTAL_PERCENT'] . '%</FONT>', 'Percent Total') . '</TD>';
}
function stafflist($type, $extra = array())
{
global $_openSIS;
switch ($type) {
case 'staff_id':
// convert profile string to array for legacy compatibility
if (!is_array($extra)) {
$extra = array('profile' => $extra);
}
if (!$_REQUEST['staff_id'] && User('PROFILE') != 'admin') {
$_REQUEST['staff_id'] = User('STAFF_ID');
}
if ($_REQUEST['staff_id']) {
if ($_REQUEST['staff_id'] != 'new') {
$_SESSION['staff_id'] = $_REQUEST['staff_id'];
unset($_SESSION['fn']);
$pro = DBGet(DBQuery("SELECT PROFILE_ID FROM staff S WHERE STAFF_ID='" . $_SESSION['staff_id'] . "'"));
if ($pro[1]['PROFILE_ID'] == 4) {
$_SESSION['fn'] = 'user';
} else {
$_SESSION['fn'] = 'staff';
}
if ($_REQUEST['school_id']) {
$_SESSION['UserSchool'] = $_REQUEST['school_id'];
}
}
if (!$_REQUEST['_openSIS_PDF']) {
echo '<script language=JavaScript>parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
}
}
if (!UserStaffID() && $_REQUEST['staff_id'] != 'new' || $extra['new'] == true) {
if (!$_REQUEST['modfunc']) {
$_REQUEST['modfunc'] = 'search_fnc';
}
$_REQUEST['next_modname'] = $_REQUEST['modname'];
if (!$_REQUEST['modname']) {
$_REQUEST['modname'] = 'users/Search.php';
}
include 'modules/attendance/StaffSearch.inc.php';
}
break;
case 'general_info':
$ethnicity_RET = DBGet(DBQuery("SELECT ETHNICITY_ID, ETHNICITY_NAME FROM ethnicity"));
echo '<tr><td align=right width=120>Last Name</td><td><input type=text name="last" size=30 class="cell_floating"></td></tr>';
echo '<tr><td align=right width=120>First Name</td><td><input type=text name="first" size=30 class="cell_floating"></td></tr>';
echo '<tr><td align=right width=120>Staff ID</td><td><input type=text name="staffid" size=30 class="cell_floating"></td></tr>';
echo '<tr><td align=right width=120>Gender</td><td><SELECT name=gender style="max-width:1750;"><OPTION value="">N/A</OPTION><OPTION value="Male">Male</OPTION><OPTION value="Female">Female</OPTION></SELECT></td></tr>';
echo '<tr><td align=right width=120>Ethnicity</td><td><SELECT name=ethnicity style="max-width:1750;"><OPTION value="">N/A</OPTION>';
foreach ($ethnicity_RET as $ethnicity) {
echo "<OPTION value='" . $ethnicity['ETHNICITY_ID'] . "'>'" . $ethnicity['ETHNICITY_NAME'] . "'</OPTION>";
}
echo '</SELECT></td></tr>';
echo '<tr><td align=right width=120>Date of Birth</td><td>' . DateInputAY('', 'search[BIRTHDATE]', 1) . '</td></tr>';
break;
}
}
}
$ERR = "";
if ($_REQUEST['day_From'] == '' && $_REQUEST['day_to']) {
$ERR = "please select from date";
}
if ($date < $start_date) {
$ERR = " From date cannot be before school start date.";
} else {
if ($_REQUEST['day_From'] && $_REQUEST['day_to'] || $From && $to) {
$staff_RET = GetStaffList_Miss_Atn($extra);
}
}
echo '<div><STRONG><FONT color=red>' . $ERR . '</font></strong></DIV>';
echo "<FORM name=missingatten id=missingatten action=Modules.php?modname={$_REQUEST['modname']}&func=save method=POST>";
$header .= '<TD style="width:40px; vertical-align:top; text-align:left; padding-top:8px;"><b>From :</b></TD><td valign="top" style="width:200px;">' . DateInputAY($From, 'From', 1) . '</TD>';
$header .= '<TD style="width:40px; vertical-align:top; text-align:left; padding-top:8px;"><b>To :</b></TD><td valign="top" style="width:150px;">' . DateInputAY($to, 'to', 2) . '</TD>';
$header .= '<td align=left><INPUT type=submit class=btn_medium name=go value=Go ></td>';
$header .= '</tr></table>';
DrawHeaderHome($header);
echo '</form>';
if ($extra['profile']) {
$options = array('admin' => 'Administrator', 'teacher' => 'Teacher', 'parent' => 'Parent', 'none' => 'No Access');
$singular = $options[$extra['profile']];
$plural = $singular . ($options[$extra['profile']] == 'none' ? 'es' : 's');
$columns = array('FULL_NAME' => $singular, 'STAFF_ID' => 'Staff ID');
} else {
$singular = 'User';
$plural = 'users';
$columns = array('FULL_NAME' => 'Staff Member', 'PROFILE' => 'Profile', 'STAFF_ID' => 'Staff ID');
}
if (is_array($extra['columns_before'])) {
$profile_check = DBGet(DBQuery("SELECT PROFILE FROM staff WHERE STAFF_ID=" . UserID()));
$profile_check = $profile_check[1]['PROFILE'];
if ($profile_check == 'admin') {
if (count($stu_RET) != 0 && count($course_RET) != 0) {
DrawHeader(DateInputAY($date, 'date', 1) . $date_note, SubmitButton('Save', '', 'class=btn_medium'));
} else {
echo '<div style="float:left;">';
DrawHeader(DateInputAY($date, 'date', 2) . $date_note);
echo '</div>';
}
} else {
if (count($stu_RET) != 0 && count($course_RET) != 0) {
DrawHeader(DateInputAY($date, 'date', 3) . $date_note, SubmitButton('Save', '', 'class=btn_medium'));
} else {
echo '<div style="float:left;">';
DrawHeader(DateInputAY($date, 'date', 4) . $date_note);
echo '</div>';
}
}
//echo '<input type=hidden name=period value='.$_REQUEST['period'].' />';
echo "<div style='padding-left:10px; padding-top:8px; float:left;'><input type='button' value='Go' class='btn_medium' onClick='document.location.href=\"Modules.php?modname=users/TeacherPrograms.php?include=attendance/TakeAttendance.php&period=" . strip_tags(trim($_REQUEST[period])) . "&include=attendance/TakeAttendance.php&day_date=\"+this.form.day_date.value+\"&year_date=\"+this.form.year_date.value+\"&table=0&month_date=\"+this.form.month_date.value;' /></div><div style='clear:both;'></div>";
DrawHeader($note, $note1);
$LO_columns = array('FULL_NAME' => 'Student', 'STUDENT_ID' => 'Student ID', 'GRADE_ID' => 'Grade') + $columns;
$tabs[] = array('title' => 'Attendance', 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=0&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}");
$categories_RET = DBGet(DBQuery('SELECT ID,TITLE FROM attendance_code_categories WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
foreach ($categories_RET as $category) {
$tabs[] = array('title' => $category['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&table={$category['ID']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}");
}
echo '<BR>';
if (count($categories_RET)) {
echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&table={$_REQUEST['table']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}") . '</CENTER>';
echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>';
echo _makeAutoSelectInput('CUSTOM_' . $field['ID'], '');
echo '</TD>';
echo '</TR>';
break;
case 'numeric':
echo '<TR>';
echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>';
echo _makeTextInput('CUSTOM_' . $field['ID'], '', 'size=5 maxlength=10 class=cell_medium');
echo '</TD>';
echo '</TR>';
break;
case 'date':
echo '<TR>';
echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>';
echo DateInputAY($value['CUSTOM_' . $field['ID']], 'CUSTOM_' . $field['ID'], $field['ID']);
echo '<input type=hidden name=custom_date_id[] value="' . $field['ID'] . '" />';
echo '</TD>';
echo '</TR>';
break;
case 'codeds':
case 'select':
echo '<TR>';
echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>';
echo _makeSelectInput('CUSTOM_' . $field['ID'], '');
echo '</TD>';
echo '</TR>';
break;
case 'multiple':
echo '<TR>';
echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>';
}
if ($_REQUEST['modfunc'] != 'choose_course') {
DrawBC("Scheduling > " . ProgramTitle());
if ($_REQUEST['search_modfunc'] == 'list') {
echo "<FORM id=sav action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=save method=POST>";
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} - " . strip_tags(trim($_REQUEST[course_weight])) . "<BR>{$period_title}";
}
echo '</DIV>' . "<A HREF=# onclick='window.open(\"ForWindow.php?modname=" . strip_tags(trim($_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>' . DateInputAY(date('Y-m-d'), 'start', 1) . '</TD></TR>';
echo '<TR><TD>Marking Period</TD><TD>';
$years_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,NULL AS SEMESTER_ID FROM school_years WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
$semesters_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,NULL AS SEMESTER_ID FROM school_semesters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'));
$quarters_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,SEMESTER_ID FROM school_quarters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'));
echo '<SELECT name=marking_period_id id=marking_period><OPTION value=' . $years_RET[1]['MARKING_PERIOD_ID'] . '>' . $years_RET[1]['TITLE'] . '</OPTION>';
foreach ($semesters_RET as $mp) {
echo "<OPTION value={$mp['MARKING_PERIOD_ID']}>" . $mp['TITLE'] . '</OPTION>';
}
foreach ($quarters_RET as $mp) {
echo "<OPTION value={$mp['MARKING_PERIOD_ID']}>" . $mp['TITLE'] . '</OPTION>';
}
echo '</SELECT>';
echo '</TD></TR>';
echo '</TABLE>';
PopTable('footer');
$month = '08';
} elseif ($month == 'SEP') {
$month = '09';
} elseif ($month == 'OCT') {
$month = '10';
} elseif ($month == 'NOV') {
$month = '11';
} elseif ($month == 'DEC') {
$month = '12';
}
$final_date = $year . "-" . $month . "-" . $day;
$date = $final_date;
}
//--------- if end --------------//
//------------------------------ Date Edit End -------------------------------------------//
DrawHeader('<TABLE><TR><TD>' . DateInputAY($date, 'date', 1) . '</TD><TD> </TD><TD>' . SubmitButton('Go', '', 'class=btn_medium') . '</TD><TR></TABLE>', '<TABLE><TR><TD>' . (count($codes_RET) > 0 ? " <a href=# onclick=toggle_attendance_code()><IMG SRC='assets/add_button.gif'border=0 vspace=0 ></a><a id=click_plus href=# onclick='javascript:addHTML(\"" . str_replace('"', '\\"', _makeCodeSearch()) . "\",\"code_pulldowns\");'></a>" : '') . '</TD><TD><DIV id=code_pulldowns>' . $code_pulldowns . '</DIV></TD></TR></TABLE>');
echo "<input type='hidden' name='p_c' value='" . (isset($_REQUEST['p_c']) ? $_REQUEST['p_c'] : 0) . "' id='p_c'>";
echo "<input type='hidden' value='" . count($codes_RET) . "' id='base'>";
$categories_RET = DBGet(DBQuery('SELECT ID,TITLE FROM attendance_code_categories WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['table']);
unset($tmp_REQUEST['codes']);
$tmp_PHP_SELF = PreparePHP_SELF($tmp_REQUEST);
if (count($categories_RET)) {
echo '<center><div style="margin-bottom:-25px;"><TABLE border=0 cellpadding=0 cellspacing=0 style="border:1;border-style: none none solid none;"><TR><TD>';
echo '<TABLE height=1><TR><TD height=1></TD></TR></TABLE>';
$header = '<TABLE border=0 cellpadding=0 cellspacing=0 height=14><TR>';
if ($_REQUEST['table'] !== '0') {
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
} else {
if (!isset($extra)) {
$extra = array();
}
Widgets('user');
if ($_REQUEST['advanced'] == 'Y') {
Widgets('all');
}
$extra['WHERE'] .= appendSQL('');
$extra['WHERE'] .= CustomFields('where');
echo "<FORM action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&list_by_day=" . strip_tags(trim($_REQUEST[list_by_day])) . " method=POST>";
$advanced_link = "<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=search&list_by_day={$_REQUEST['list_by_day']}&day_start={$_REQUEST['day_start']}&day_end={$_REQUEST['day_end']}&month_start={$_REQUEST['month_start']}&month_end={$_REQUEST['month_end']}&year_start={$_REQUEST['year_start']}&year_end={$_REQUEST['year_end']}>Advanced</A>";
///////////////////////Old Date Picker///////////////////////////////
///////////////////////New Date Picker///////////////////////////////
//jaycee
//DrawHeaderHome('<table><tr><td>'.DateInputAY($start_date,'start',1).'</td><td> - </td><td>'.DateInputAY($end_date,'end',2).'</td><td> - </td><td>'.$advanced_link.'</td><td> All School <input type="checkbox" value="Y" name="all_school" id="all_school" checked /></td><td> : <INPUT type=submit value=Go class=btn_medium></td></tr></table>');
DrawHeaderHome('<table><tr><td>' . DateInputAY($start_date, 'start', 1) . '</td><td> - </td><td>' . DateInputAY($end_date, 'end', 2) . '</td><td> - </td><td> <input type="checkbox" value="Y" name="all_school" id="all_school" checked /></td><td> : <INPUT type=submit value=Go class=btn_medium></td></tr></table>');
echo '</FORM>';
if ($_REQUEST['list_by_day'] == 'true') {
$cal_days = 1;
$student_days_absent = DBGet(DBQuery('SELECT ad.SCHOOL_DATE,ssm.GRADE_ID,COALESCE(sum(ad.STATE_VALUE-1)*-1,0) AS STATE_VALUE FROM attendance_day ad,student_enrollment ssm,students s WHERE s.STUDENT_ID=ssm.STUDENT_ID AND ad.STUDENT_ID=ssm.STUDENT_ID AND ssm.SYEAR=\'' . UserSyear() . '\' AND ad.SYEAR=ssm.SYEAR AND ad.SCHOOL_DATE BETWEEN \'' . $start_date . '\' AND \'' . $end_date . '\' AND (ad.SCHOOL_DATE BETWEEN ssm.START_DATE AND ssm.END_DATE OR (ssm.END_DATE IS NULL AND ssm.START_DATE <= ad.SCHOOL_DATE)) ' . $extra['WHERE'] . ' GROUP BY ad.SCHOOL_DATE,ssm.GRADE_ID'), array(''), array('SCHOOL_DATE', 'GRADE_ID'));
$sql_school = DBGet(DBQuery('SELECT DISTINCT SCHOOL_ID FROM staff_school_relationship WHERE STAFF_ID=' . User('STAFF_ID')));
foreach ($sql_school as $school_key => $school_value) {
$in_schools_raw .= ',' . $school_value['SCHOOL_ID'];
}
$in_schools_raw = $in_schools_raw;
$in_schools = substr($in_schools_raw, 1);
$permited_schools = explode(",", $in_schools);
$sch_count = count($permited_schools);
if ($sch_count == 1) {
$student_days_possible = DBGet(DBQuery('SELECT ap.SCHOOL_DATE, CONCAT(s.FIRST_NAME, \' \', s.LAST_NAME,\' \') as STUDENTS, sg.TITLE as GRADE, sp.TITLE as PERIOD, ac.TITLE as STATUS from attendance_period ap, students s, school_gradelevels sg, attendance_codes ac, student_enrollment ssm, school_periods sp where ssm.syear=\'' . UserSyear() . '\' and ap.attendance_code=ac.id and ssm.grade_id=sg.id and ap.period_id=sp.period_id and ap.student_id=s.student_id and ssm.student_id=ap.student_id AND ssm.school_id in (' . $in_schools . ') AND ap.SCHOOL_DATE BETWEEN \'' . $start_date . '\' AND \'' . $end_date . '\' ' . $extra['WHERE'] . ''), array('SCHOOL_DATE' => 'ProperDate', 'GRADE' => 'GRADE', 'STUDENTS' => 'STUDENTS', 'PRESENT' => '_makeByDay', 'ABSENT' => '_makeByDay', 'ADA' => '_makeByDay'));
$columns = array('SCHOOL_DATE' => 'Date', 'STUDENTS' => 'Student Name', 'GRADE' => 'Grade', 'PERIOD' => 'Period Name', 'STATUS' => 'Attendance Status');
$header .= '</TR><TR>';
//$header .= '<TD>' . CheckboxInput($RET['COURSE_WEIGHT'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][COURSE_WEIGHT]', 'Course is Weighted', $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>',$div) . '</TD>';
//
//$header .= '<TD valign=top>' . CheckboxInput($RET['DOES_HONOR_ROLL'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_HONOR_ROLL]', 'Affects Honor Roll', $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>',$div) . '</TD>';
//$header .= '<TD valign=top>' . CheckboxInput($RET['HALF_DAY'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][HALF_DAY]', 'Half Day', $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>',$div) . '</TD>';
//$header .= '<TD>' . CheckboxInput($RET['DOES_CLASS_RANK'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_CLASS_RANK]', 'Affects Class Rank', $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>',$div) . '</TD>';
$header .= '</TR>';
unset($options);
$mp_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,SHORT_NAME,'2' AS t,SORT_ORDER FROM school_quarters WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' UNION SELECT MARKING_PERIOD_ID,SHORT_NAME,'1' AS t,SORT_ORDER FROM school_semesters WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' UNION SELECT MARKING_PERIOD_ID,SHORT_NAME,'0' AS t,SORT_ORDER FROM school_years WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY 3,4"));
if (count($mp_RET)) {
foreach ($mp_RET as $mp) {
$options[$mp['MARKING_PERIOD_ID']] = $mp['SHORT_NAME'];
}
}
$header .= '<TR><TD colspan=6><BR /><B>Choose Term / 选择学期</B></TD></TR><TR><TD colspan=6><TABLE cellpadding=4 width="100%" style="border:1px dotted #999"><TR><TD colspan=2><TABLE height="60px"><TR><TD><input type=radio name=date_range value=mp id=preset onchange=mp_range_toggle(this); ' . ($RET['MARKING_PERIOD_ID'] ? ' checked' : '') . '></TD><TD><label for=preset id=select_mp style="display:' . ($RET['MARKING_PERIOD_ID'] ? 'none' : 'block') . '"></label><DIV id=mp_range style=float:left;display:' . ($RET['MARKING_PERIOD_ID'] ? 'block' : 'none') . '>' . SelectInput($RET['MARKING_PERIOD_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][MARKING_PERIOD_ID]', 'Marking Period', $options, 'N/A', 'id=marking_period', $div) . '</DIV></TD></TR></TABLE></TD>';
$header .= '<TD colspan=4 width="550px" style="display:none" ><TABLE><TR><TD ><input type=radio name=date_range value=dr id=custom onchange=mp_range_toggle(this); ' . ($RET['BEGIN_DATE'] ? ' checked' : '') . '></TD><TD><label for=custom id=select_range style="display:' . ($RET['BEGIN_DATE'] ? 'none' : 'block') . '">Custom Date Range</label><DIV id=date_range style=display:' . ($RET['BEGIN_DATE'] ? 'block' : 'none') . '><TABLE><TR><TD>' . DateInputAY($RET['BEGIN_DATE'], 'begin', 1) . '</TD><TD> </TD><TD> ' . DateInputAY($RET['END_DATE'], 'end', 2) . '</TD></TR></TABLE> </DIV></TD></TR></TABLE></TD></TR></TABLE></TD></TR>';
$header .= '<TR><TD colspan=6><BR /><B>Set Details / 设置详情</B></TD></TR><TR><TD colspan=6><TABLE cellpadding=4 width="100%" style="border:1px dotted #999"><TR><TD><input type=radio name=schedule_type id=fixed_schedule value=fixed onclick=show_cp_meeting_days(this.value,"' . $_REQUEST[course_period_id] . '"); ' . ($RET['SCHEDULE_TYPE'] == 'FIXED' ? ' checked' : '') . ' ' . disabled() . '><label for=fixed_schedule>Fixed Schedule</label></TD><TD style="display:none" ><input type=radio name=schedule_type id=variable_schedule value=variable onclick=show_cp_meeting_days(this.value,"' . $_REQUEST[course_period_id] . '"); ' . ($RET['SCHEDULE_TYPE'] == 'VARIABLE' ? ' checked' : '') . ' ' . disabled() . '><label for=variable_schedule> Variable Schedule</label></TD><TD style="display:none" colspan=3><input type=radio name=schedule_type id=blocked_schedule value=blocked onclick=show_cp_meeting_days(this.value,"' . $_REQUEST[course_period_id] . '"); ' . ($RET['SCHEDULE_TYPE'] == 'BLOCKED' ? ' checked' : '') . ' ' . disabled() . '><label for=blocked_schedule>Enter by Calendar Days</label></TD>';
$header .= '</TR>';
$header .= '<TR>';
if ($_REQUEST['course_period_id'] != 'new' || $not_pass == true) {
$periods_RET = DBGet(DBQuery("SELECT PERIOD_ID,TITLE FROM school_periods WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY SORT_ORDER"));
if (count($periods_RET)) {
foreach ($periods_RET as $period) {
$periods[$period['PERIOD_ID']] = $period['TITLE'];
}
}
$room_RET = DBGet(DBQuery("SELECT ROOM_ID,TITLE FROM rooms WHERE SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
if (count($room_RET)) {
foreach ($room_RET as $room) {
$rooms[$room['ROOM_ID']] = $room['TITLE'];
}
function _makeEndInputDateenrl($value, $column)
{
global $THIS_RET;
$drop_codes = array();
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
}
if (!$THIS_RET['ID']) {
$id = 'new';
}
if ($value['DROP_CODE'] == '') {
if ($id == 'new') {
$date_field = '<TABLE class=LO_field><TR><TD>' . DateInputAY($value, 'values[student_enrollment][' . $id . '][' . $column . ']', 0) . '</TD></TR></TABLE>';
} else {
$date_field = '<TABLE class=LO_field><TR><TD>' . DateInputAY($value, 'values[student_enrollment][' . $id . '][' . $column . ']', $id) . '</TD></TR></TABLE>';
}
}
if ($value['DROP_CODE'] != '') {
if ($id == 'new') {
$date_field = '<TABLE class=LO_field><TR><TD>' . DateInputAY($value, 'values[student_enrollment][' . $id . '][' . $column . ']', 0) . '</TD></TR></TABLE>';
} else {
$date_field = '<TABLE class=LO_field><TR><TD>' . DateInputAY($value, 'values[student_enrollment][' . $id . '][' . $column . ']', $id) . '</TD></TR></TABLE>';
}
}
if ($THIS_RET['SYEAR'] == UserSyear()) {
return $date_field;
} else {
if ($value == '') {
return "N/A";
} else {
return $r_date = date('F/d/Y', strtotime($value));
}
}
}
function makeDateInput($value, $name, $optional_value = 0, $id = 'new')
{
return DateInputAY($value, 'values[' . $id . '][' . $name . ']', $optional_value);
}
function PrepareDateSchedule($date = '', $title = '', $allow_na = true, $options = '')
{
global $_openSIS;
static $counter = 0;
if ($options == '') {
$options = array();
}
if (!$options['Y'] && !$options['M'] && !$options['D'] && !$options['C']) {
$options += array('Y' => true, 'M' => true, 'D' => true, 'C' => true);
}
if ($options['short'] == true) {
$extraM = "style='width:60;' ";
}
if ($options['submit'] == true) {
$tmp_REQUEST['M'] = $tmp_REQUEST['D'] = $tmp_REQUEST['Y'] = $_REQUEST;
unset($tmp_REQUEST['M']['month' . $title]);
unset($tmp_REQUEST['D']['day' . $title]);
unset($tmp_REQUEST['Y']['year' . $title]);
$extraM .= "onchange='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST['M']) . "&month{$title}=\"+this.form.month{$title}.value;'";
$extraD .= "onchange='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST['D']) . "&day{$title}=\"+this.form.day{$title}.value;'";
$extraY .= "onchange='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST['Y']) . "&year{$title}=\"+this.form.year{$title}.value;'";
}
if ($options['C']) {
$_openSIS['PrepareDate']++;
}
if ($options['C']) {
$return .= '<div style="margin-top:-3px; float:left">' . DateInputAY($date, $title, $counter) . '</div>';
$counter++;
}
if ($_REQUEST['_openSIS_PDF']) {
$return = ProperDateAY($date);
}
return $return;
}
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
$return = '<TABLE width=216><TR><TD class=LO_field align="center"><b>Visible Between:</b></TD></tr><tr><TD align="center">';
if ($id != 'new') {
$return .= DateInputAY($value, "values[{$id}][{$name}]", $id) . '</TD></tr><tr><TD class=LO_field align="center"><b>&</b></TD></tr><tr><TD align="center">';
$return .= DateInputAY($THIS_RET['END_DATE'], "values[{$id}][END_DATE]", $id + 1) . '</TD></TR>';
} else {
$return .= DateInputAY($value, "values[{$id}][{$name}]", 0) . '</TD></tr><tr><TD class=LO_field align="center"><b>&</b></TD></tr><tr><TD align="center">';
$return .= DateInputAY($THIS_RET['END_DATE'], "values[{$id}][END_DATE]", -1) . '</TD></TR>';
}
$return .= '<TR><TD colspan=4 class=break></TD></TR><TR><TD colspan=4>';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM user_profiles ORDER BY ID"));
}
$return .= '<TABLE border=0 cellspacing=0 cellpadding=0 width=96% class=LO_field><TR><TD colspan=4><b>Visible To: </b></TD></TR>';
foreach (array('all' => 'All School', 'admin' => 'Administrator w/Custom', 'teacher' => 'Teacher w/Custom', 'parent' => 'Parent w/Custom') as $profile_id => $profile) {
$return .= "<tr><TD colspan=4><INPUT type=checkbox name=profiles[{$id}][{$profile_id}] value=Y" . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' CHECKED' : '') . "> {$profile}</TD></tr>";
}
$i = 3;
foreach ($profiles_RET as $profile) {
$i++;
$return .= '<tr><TD colspan=4><INPUT type=checkbox name=profiles[' . $id . '][' . $profile['ID'] . '] value=Y' . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' CHECKED' : '') . "> {$profile['TITLE']}</TD></tr>";
if ($i % 4 == 0 && $i != count($profile)) {
$return .= '<TR>';
}
}
for (; $i % 4 != 0; $i++) {
$return .= '<TD></TD>';
}
$return .= '</TR>';
$return .= '</TABLE>';
$return .= '</TD></TR></TABLE>';
return $return;
}
$header .= '<TR><td class=lable>Short Name</td><TD>' . TextInput($RET['SHORT_NAME'], 'tables[' . $_REQUEST['marking_period_id'] . '][SHORT_NAME]', '', 'class=cell_floating') . '</TD></tr>';
if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
$header .= '<TR><td class=lable>Sort Order</td><TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', '', 'class=cell_small onKeyDown="return numberOnlyMod(event,this);"') . '</TD></tr>';
} else {
$header .= '<TR><td class=lable>Sort Order</td><TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', '', 'class=cell_small onKeyDown=\\"return numberOnlyMod(event,this);\\"') . '</TD></tr>';
}
$header .= '<TR><td class=lable>Graded</td><TD>' . CheckboxInput_grade($RET['DOES_GRADES'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_GRADES]', '', $checked, $_REQUEST['marking_period_id'] == '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', 'onclick=show_div("tables[' . $_REQUEST['marking_period_id'] . '][DOES_GRADES]","' . $_REQUEST['marking_period_id'] . '");') . '</TD></tr>';
if ($f == 1) {
$header .= '<TR><td class=lable>Exam</td><TD>' . CheckboxInput_exam($RET['DOES_EXAM'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_EXAM]', '', $checked, $_REQUEST['marking_period_id'] == '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, '' . ($RET['DOES_GRADES'] == "Y" ? '' : 'disabled') . '') . '</TD></tr>';
}
$header .= '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == '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></tr>';
$header .= '<TR><td class=lable>Begins</td><TD>' . DateInputAY($RET['START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][START_DATE]', 1) . '</TD></tr>';
$header .= '<TR><td class=lable>Ends</td><TD>' . DateInputAY($RET['END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][END_DATE]', 2) . '</TD></tr>';
$header .= '<TR><td class=lable colspan=2><div id=grade_div style="' . ($RET['DOES_GRADES'] == 'Y' ? "display:block" : "display:none") . '"><table>';
$header .= '<tr><td class=lable>Grade Posting Begins</td><td>' . DateInputAY($RET['POST_START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_START_DATE]', 3) . '</td></tr>';
$header .= '<tr><td class=lable>Grade Posting Ends</td><td>' . DateInputAY($RET['POST_END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_END_DATE]', 4) . '</td></tr>';
$header .= '</table></div></td></TR>';
$str_srch = '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == '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></tr>';
$header .= '</TABLE>';
DrawHeader($header);
PopTable('footer');
if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit value=Save class="btn_medium" onclick="formcheck_school_setup_marking();">' : '');
} elseif ($_REQUEST['mp_term'] != 'FY') {
DrawHeaderHome('', '', AllowEdit() ? $delete_button . ' <INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">' : '');
} else {
DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium" >' : '');
}
echo '</FORM>';
unset($_SESSION['_REQUEST_vars']['marking_period_id']);
unset($_SESSION['_REQUEST_vars']['mp_term']);
echo '<INPUT type=hidden name=relation>';
Widgets('course');
Widgets('request');
Widgets('activity');
Widgets('absences');
Widgets('gpa');
Widgets('class_rank');
Widgets('letter_grade');
Widgets('eligibility');
$extra['search'] .= '<TR><TD align=right width=120>Include courses active as of </TD><TD>' . DateInputAY('', 'include_active_date', 2) . '</TD></TR>';
$extra['new'] = true;
Search('student_id', $extra);
if ($_SESSION['count_stu'] != '0') {
unset($_SESSION['count_stu']);
echo '<BR><CENTER><INPUT type=submit value=\'Create Report for Selected Students\' class=btn_xxlarge></CENTER>';
}
echo "</FORM>";
} else {
Widgets('course');
Widgets('request');
Widgets('activity');
Widgets('absences');
Widgets('gpa');
Widgets('class_rank');
Widgets('letter_grade');
Widgets('eligibility');
$extra['search'] .= '<TR><TD align=right width=120>Include courses active as of </TD><TD>' . DateInputAY('', 'include_active_date', 3) . '</TD></TR>';
$extra['new'] = true;
Search('student_id', $extra);
}
}
echo '</FORM>';
PopTable('footer');
}
if (!$_REQUEST['modfunc']) {
if (!isset($extra)) {
$extra = array();
}
Widgets('user');
if ($_REQUEST['advanced'] == 'Y') {
Widgets('all');
}
$extra['WHERE'] .= appendSQL('');
$extra['WHERE'] .= CustomFields('where');
echo "<FORM name=ada_from id=ada_from onSubmit='return formcheck_ada_dates();' action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&list_by_day=" . strip_tags(trim($_REQUEST[list_by_day])) . " method=POST>";
$advanced_link = " <A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=search&list_by_day={$_REQUEST['list_by_day']}&day_start={$_REQUEST['day_start']}&day_end={$_REQUEST['day_end']}&month_start={$_REQUEST['month_start']}&month_end={$_REQUEST['month_end']}&year_start={$_REQUEST['year_start']}&year_end={$_REQUEST['year_end']}>Advanced</A>";
DrawHeaderHome('<table><tr><td>' . DateInputAY($start_date, 'start', 1) . '</td><td> - </td><td>' . DateInputAY($end_date, 'end', 2) . '</td><td> - </td><td>' . $advanced_link, ' : <INPUT type=submit value=Go class=btn_medium></td></tr></table>');
echo '</FORM>';
if ($_REQUEST['list_by_day'] == 'true') {
$cal_days = 1;
$search_stu = 0;
if ($_REQUEST['last'] != '' || $_REQUEST['first'] != '' || $_REQUEST['stuid'] != '' || $_REQUEST['altid'] != '') {
$stu_q = 'SELECT GROUP_CONCAT(STUDENT_ID) as STUDENT_ID FROM students WHERE ';
$stu_q .= $_REQUEST['last'] != '' ? ' LAST_NAME=\'' . $_REQUEST['last'] . '\' OR ' : '';
$stu_q .= $_REQUEST['first'] != '' ? ' FIRST_NAME=\'' . $_REQUEST['first'] . '\' OR ' : '';
$stu_q .= $_REQUEST['stuid'] != '' ? ' STUDENT_ID=\'' . $_REQUEST['stuid'] . '\' OR ' : '';
$stu_q .= $_REQUEST['altid'] != '' ? ' ALT_ID=\'' . $_REQUEST['altid'] . '\' OR ' : '';
$stu_q = preg_replace('/ OR $/', '', $stu_q);
$stu_q = DBGet(DBQuery($stu_q));
$search_stu = $stu_q[1]['STUDENT_ID'];
}
if ($_REQUEST['addr'] != '') {
function makeDateInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['MARKING_PERIOD_ID']) {
$id = $THIS_RET['MARKING_PERIOD_ID'];
} else {
$id = 'new';
}
if ($id != 'new') {
return DateInputAY($value, "values[{$id}][{$name}]", $id);
} else {
return DateInputAY($value, "values[{$id}][{$name}]", 0);
}
}
function _makeEndInputDate($value, $column)
{
global $THIS_RET;
if ($_REQUEST['staff_id'] == 'new') {
$date_value = '';
} else {
$sql = 'SELECT ssr.END_DATE FROM staff s,staff_school_relationship ssr WHERE ssr.STAFF_ID=s.STAFF_ID AND ssr.SCHOOL_ID=' . $THIS_RET['SCHOOL_ID'] . ' AND ssr.STAFF_ID=' . $_SESSION['staff_selected'] . ' AND ssr.SYEAR= (SELECT MAX(SYEAR) FROM staff_school_relationship WHERE SCHOOL_ID=' . $THIS_RET['SCHOOL_ID'] . ' AND STAFF_ID=' . $_SESSION['staff_selected'] . ')';
$user_exist_school = DBGet(DBQuery($sql));
if ($user_exist_school[1]['END_DATE'] == '0000-00-00' || $user_exist_school[1]['END_DATE'] == '') {
$date_value = '';
} else {
$date_value = $user_exist_school[1]['END_DATE'];
}
}
return '<TABLE class=LO_field><TR>' . '<TD nowrap="nowrap">' . DateInputAY($date_value, 'values[END_DATE][' . $THIS_RET['ID'] . ']', '2' . $THIS_RET['ID']) . '</TD></TR></TABLE>';
}
} elseif ($month == 'SEP') {
$month = '09';
} elseif ($month == 'OCT') {
$month = '10';
} elseif ($month == 'NOV') {
$month = '11';
} elseif ($month == 'DEC') {
$month = '12';
}
$final_date = $year . "-" . $month . "-" . $day;
$date = $final_date;
}
//echo $date;
//--------- if end --------------//
//------------------------------ Date Edit End -------------------------------------------//
DrawHeader('<TABLE><TR><TD>' . DateInputAY($date, 'date', 1) . '</TD><TD> </TD><TD>' . SubmitButton('Go', '', 'class=btn_medium') . '</TD><TR></TABLE>', '<TABLE><TR><TD>' . $current_student_link . button('add', '', "# onclick='javascript:addHTML(\"" . str_replace('"', '\\"', _makeCodeSearch()) . "\",\"code_pulldowns\"); return false;'") . '</TD><TD><DIV id=code_pulldowns>' . $code_pulldowns . '</DIV></TD></TR></TABLE>');
$categories_RET = DBGet(DBQuery('SELECT ID,TITLE FROM attendance_code_categories WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['table']);
unset($tmp_REQUEST['codes']);
$tmp_PHP_SELF = PreparePHP_SELF($tmp_REQUEST);
if (count($categories_RET)) {
echo '<center><div style="margin-bottom:-25px;"><TABLE border=0 cellpadding=0 cellspacing=0 style="border:1;border-style: none none solid none;"><TR><TD>';
echo '<TABLE height=1><TR><TD height=1></TD></TR></TABLE>';
$header = '<TABLE border=0 cellpadding=0 cellspacing=0 height=14><TR>';
if ($_REQUEST['table'] !== '0') {
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
} else {
$tabcolor = Preferences('HIGHLIGHT');
$textcolor = '#000000';
