$chck_status = DBGet(DBQuery('SELECT COUNT(1) as DISABLED FROM students s,student_enrollment se WHERE se.STUDENT_ID=s.STUDENT_ID AND s.STUDENT_ID=' . $ud['USER_ID'] . ' AND se.SYEAR=' . UserSyear() . ' AND (s.IS_DISABLE=\'Y\' OR (se.END_DATE<\'' . date('Y-m-d') . '\' AND se.END_DATE IS NOT NULL AND se.END_DATE<>\'0000-00-00\' ))'));
} elseif ($ud['PROFILE_ID'] == 'parent') {
// echo 'parent'.$ud['USER_ID'].'<br>';
$chck_status = DBGet(DBQuery('SELECT COUNT(1) as DISABLED FROM people WHERE STAFF_ID=' . $ud['USER_ID'] . ' AND IS_DISABLE=\'Y\' '));
} else {
// echo 'else'.$ud['USER_ID'].'<br>';
$chck_status = DBGet(DBQuery('SELECT COUNT(1) as DISABLED FROM staff s,staff_school_relationship se WHERE se.STAFF_ID=s.STAFF_ID AND s.STAFF_ID=' . $ud['USER_ID'] . ' AND se.SYEAR=' . UserSyear() . ' AND (s.IS_DISABLE=\'Y\' OR (se.END_DATE<\'' . date('Y-m-d') . '\' AND se.END_DATE IS NOT NULL AND se.END_DATE<>\'0000-00-00\' ))'));
}
if ($chck_status[1]['DISABLED'] != 0) {
$userlist[$ui]['STATUS'] = "<font style='color:red'>Inactive</font>";
} else {
$userlist[$ui]['STATUS'] = "<font style='color:green'>Active</font>";
}
}
}
ListOutputExcel($userlist, $columns, 'Member', 'Members', '', array(), array('search' => false), '');
}
echo "</FORM>";
PopTable('footer');
}
if (isset($_REQUEST['modfunc']) && $_REQUEST['modfunc'] == 'add_group') {
if (!isset($_REQUEST['search'])) {
echo "<FORM name=Group id=Compose action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=group_insert method=POST >";
PopTable('header', 'Group');
echo '<table>
<tr>
<td>Group Name: </td>
<td>' . TextInput_mail('', 'txtGrpName', '', 'onkeyup=groups(this.value) class=cell_medium') . '
</td>
</tr>
<tr>
} elseif (!UserStudentID() && count($students_RET) != 0) {
DrawHeader("<div><A HREF=" . PreparePHP_SELF($tmp_REQUEST) . "&expanded_view=false class=big_font><img src=\"themes/blue/expanded_view.png\" />Original View</A></div><div class=break ></div>", $extra['header_right']);
DrawHeader(str_replace('<BR>', '<BR> ', substr($_openSIS['Search'], 0, -4)));
}
DrawHeader($extra['extra_header_left'], $extra['extra_header_right']);
if ($_REQUEST['LO_save'] != '1' && !$extra['suppress_save']) {
$_SESSION['List_PHP_SELF'] = PreparePHP_SELF($_SESSION['_REQUEST_vars']);
echo '<script language=JavaScript>parent.help.location.reload();</script>';
}
if (!$extra['singular'] || !$extra['plural']) {
$extra['singular'] = 'Student';
$extra['plural'] = 'Students';
}
echo '<div style="overflow:auto; width:820px; overflow-x:scroll;">';
echo "<div id='students' >";
ListOutputExcel($students_RET, $columns, $extra['singular'], $extra['plural'], $link, $extra['LO_group'], $extra['options']);
echo "</div>";
echo "</div>";
} elseif (count($students_RET) == 1) {
if (count($link['FULL_NAME']['variables'])) {
foreach ($link['FULL_NAME']['variables'] as $var => $val) {
$_REQUEST[$var] = $students_RET['1'][$val];
}
}
if (!is_array($students_RET[1]['STUDENT_ID'])) {
$_SESSION['student_id'] = $students_RET[1]['STUDENT_ID'];
if (User('PROFILE') == 'admin') {
$_SESSION['UserSchool'] = $students_RET[1]['LIST_SCHOOL_ID'];
}
if (User('PROFILE') == 'teacher') {
$_SESSION['UserSchool'] = $students_RET[1]['SCHOOL_ID'];
