$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'];