if ($search_from_grade == 'true') { $_SESSION['stu_search']['search_from_grade'] = 'true'; } } PopTable('header', 'Find a Student'); if ($extra['pdf'] != true) { echo "<FORM name=search id=search action=Modules.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&search_modfunc=list&next_modname={$_REQUEST['next_modname']}" . $extra['action'] . " method=POST>"; } else { echo "<FORM name=search id=search action=for_export.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&search_modfunc=list&next_modname={$_REQUEST['next_modname']}" . $extra['action'] . " method=POST target=_blank>"; } echo '<TABLE border=0>'; Search_absence_summary('general_info'); if ($extra['search']) { echo $extra['search']; } Search_absence_summary('student_fields'); # --- Advanced Search Start ---------------------------------------------------------- # echo '<div style="height:10px;"></div>'; echo '<input type=hidden name=sql_save_session value=true />'; echo '<div id="addiv">'; echo '<div><label onclick="show_search_div();" style="cursor:pointer; font-weight:bold; font-size:12px; text-decoration:underline;">Advanced Search</label></div>'; echo '</div>'; echo '<div id="searchdiv" style="display:none; width:410px;">'; echo '<div>« <label onclick="hide_search_div();" style="cursor:pointer; font-weight:bold; font-size:12px; text-decoration:underline;">Back to Basic Search</label></div>'; echo '<div style="height:14px;"></div>'; echo '<div style=text-align:left;padding-left:74px;padding-bottom:14px;>Comments <input type=text name="mp_comment" size=30 class="cell_floating"></div>'; echo '<div style="margin-left:22px; padding-bottom:5px;"><b>Birthday</b></div>'; echo '<div style=text-align:left;padding-left:98px;padding-bottom:4px;>From: ' . SearchDateInput('day_from_birthdate', 'month_from_birthdate', '', 'Y', 'Y', '') . '</div>'; echo '<div style=text-align:left;padding-left:110px;padding-bottom:20px;>To: ' . SearchDateInput('day_to_birthdate', 'month_to_birthdate', '', 'Y', 'Y', '') . '</div>'; echo '<div style="margin-left:22px; padding-bottom:5px;"><b>Goal and Progress</b></div>'; echo '<div style=text-align:left;padding-left:80px;padding-bottom:4px;>Goal Title <input type=text name="goal_title" size=30 class="cell_floating"></div>';
AND ap.SCHOOL_DATE BETWEEN \'' . $start_date . '\' AND \'' . $end_date . '\') AS ABS_' . $code[ID] . ''; } $extra['columns_after']["ABS_" . $code[ID] . ""] = $code['TITLE']; } } } $extra['link']['FULL_NAME']['link'] = "Modules.php?modname={$_REQUEST['modname']}&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']}&period_id={$_REQUEST['period_id']}&myclasses={$_REQUEST['myclasses']}"; $extra['link']['FULL_NAME']['variables'] = array('student_id' => 'STUDENT_ID'); if ((!$_REQUEST['search_modfunc'] || $_openSIS['modules_search']) && !$_REQUEST['student_id']) { $extra['new'] = true; } Widgets('activity'); Widgets('course'); Widgets('absences'); if (!$_SESSION['student_id']) { Search_absence_summary('student_id', $extra); } if (UserStudentID()) { $name_RET = DBGet(DBQuery('SELECT concat(FIRST_NAME, \' \', COALESCE(MIDDLE_NAME,\' \'), LAST_NAME) AS FULL_NAME FROM students WHERE STUDENT_ID=\'' . UserStudentID() . '\'')); DrawHeader($name_RET[1]['FULL_NAME']); $PHP_tmp_SELF = PreparePHP_SELF(); $i = 0; // if($_REQUEST['myclasses']!=''){ // $absences_RET = DBGet(DBQuery('SELECT ap.STUDENT_ID,ap.PERIOD_ID,ap.SCHOOL_DATE,ac.SHORT_NAME,ad.STATE_VALUE,ad.COMMENT AS OFFICE_COMMENT,ap.COMMENT AS TEACHER_COMMENT FROM attendance_period ap,attendance_day ad,attendance_codes ac,course_periods cp WHERE ap.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND '.(($_REQUEST['myclasses']=='my_classes')? '(cp.TEACHER_ID=\''.User('STAFF_ID').'\' OR cp.SECONDARY_TEACHER_ID=\''.User('STAFF_ID').'\')' : 'cp.COURSE_PERIOD_ID=\''.UserCoursePeriod().'\'').' AND ap.STUDENT_ID=ad.STUDENT_ID AND ap.SCHOOL_DATE=ad.SCHOOL_DATE AND ap.ATTENDANCE_CODE=ac.ID AND (ac.DEFAULT_CODE!=\'Y\' OR ac.DEFAULT_CODE IS NULL) AND ap.STUDENT_ID=\''.UserStudentID().'\' AND ap.SCHOOL_DATE BETWEEN \''.$start_date.'\' AND \''.$end_date.'\''),array(),array('SCHOOL_DATE','PERIOD_ID')); // }else{ // $absences_RET = DBGet(DBQuery('SELECT ap.STUDENT_ID,ap.PERIOD_ID,ap.SCHOOL_DATE,ac.SHORT_NAME,ad.STATE_VALUE,ad.COMMENT AS OFFICE_COMMENT,ap.COMMENT AS TEACHER_COMMENT FROM attendance_period ap,attendance_day ad,attendance_codes ac WHERE ap.STUDENT_ID=ad.STUDENT_ID AND ap.SCHOOL_DATE=ad.SCHOOL_DATE AND ap.ATTENDANCE_CODE=ac.ID AND (ac.DEFAULT_CODE!=\'Y\' OR ac.DEFAULT_CODE IS NULL) AND ap.STUDENT_ID=\''.UserStudentID().'\' AND ap.SCHOOL_DATE BETWEEN \''.$start_date.'\' AND \''.$end_date.'\''),array(),array('SCHOOL_DATE','PERIOD_ID')); // } if ($_REQUEST['myclasses'] != '') { $absences_RET = DBGet(DBQuery('SELECT ap.STUDENT_ID,ap.PERIOD_ID,ap.SCHOOL_DATE,ac.SHORT_NAME,ad.STATE_VALUE,ad.COMMENT AS OFFICE_COMMENT,ap.COMMENT AS TEACHER_COMMENT,ac.STATE_CODE FROM attendance_period ap,attendance_day ad,attendance_codes ac,course_periods cp WHERE ap.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND ' . ($_REQUEST['myclasses'] == 'my_classes' ? '(cp.TEACHER_ID=\'' . User('STAFF_ID') . '\' OR cp.SECONDARY_TEACHER_ID=\'' . User('STAFF_ID') . '\')' : 'cp.COURSE_PERIOD_ID=\'' . UserCoursePeriod() . '\'') . ' AND ap.STUDENT_ID=ad.STUDENT_ID AND ap.SCHOOL_DATE=ad.SCHOOL_DATE AND ap.ATTENDANCE_CODE=ac.ID AND ap.STUDENT_ID=\'' . UserStudentID() . '\' AND ap.SCHOOL_DATE BETWEEN \'' . $start_date . '\' AND \'' . $end_date . '\''), array(), array('SCHOOL_DATE', 'PERIOD_ID')); } else { $absences_RET = DBGet(DBQuery('SELECT ap.STUDENT_ID,ap.PERIOD_ID,ap.SCHOOL_DATE,ac.SHORT_NAME,ad.STATE_VALUE,ad.COMMENT AS OFFICE_COMMENT,ap.COMMENT AS TEACHER_COMMENT,ac.STATE_CODE FROM attendance_period ap,attendance_day ad,attendance_codes ac WHERE ap.STUDENT_ID=ad.STUDENT_ID AND ap.SCHOOL_DATE=ad.SCHOOL_DATE AND ap.ATTENDANCE_CODE=ac.ID AND ap.STUDENT_ID=\'' . UserStudentID() . '\' AND ap.SCHOOL_DATE BETWEEN \'' . $start_date . '\' AND \'' . $end_date . '\''), array(), array('SCHOOL_DATE', 'PERIOD_ID'));