//print_r($custom_RET); if ($custom_RET[substr($field, 7)][1]['TYPE'] == 'date' && !$extra['functions'][$field]) { $extra['functions'][$field] = 'ProperDate'; } elseif ($custom_RET[substr($field, 7)][1]['TYPE'] == 'codeds' && !$extra['functions'][$field]) { $extra['functions'][$field] = 'DeCodeds'; } } //print_r($extra); $RET = GetStuList($extra); //print_r($RET); //print_r($columns); if ($extra['array_function'] && function_exists($extra['array_function'])) { $extra['array_function']($RET); } echo "<html><link rel='stylesheet' type='text/css' href='styles/export.css'><body style=\" font-family:Arial; font-size:12px;\">"; ListOutputPrint_Report($RET, $columns, $extra['singular'] ? $extra['singular'] : 'Student', $extra['plural'] ? $extra['plural'] : 'Students', array(), $extra['LO_group'], $extra['LO_options']); echo "</body></html>"; } } else { if (!$fields_list) { if (AllowUse('Students/Student.php&category_id=1')) { $fields_list['General'] = array('FULL_NAME' => Preferences('NAME') == 'Common' ? 'Last, Common' : 'Last, First M', 'FIRST_NAME' => 'First', 'FIRST_INIT' => 'First Initial', 'LAST_NAME' => 'Last', 'MIDDLE_NAME' => 'Middle', 'NAME_SUFFIX' => 'Suffix', 'STUDENT_ID' => 'Student ID', 'GRADE_ID' => 'Grade', 'SCHOOL_ID' => 'School', 'NEXT_SCHOOL' => 'Rolling / Retention Options', 'CALENDAR_ID' => 'Calendar', 'USERNAME' => 'Username', 'ALT_ID' => 'Alternate ID', 'BIRTHDATE' => 'DOB', 'EMAIL' => 'Email ID', 'PHONE' => 'Phone'); } if (AllowUse('Students/Student.php&category_id=3')) { $fields_list['Address'] = array('ADDRESS' => 'Address', 'CITY' => 'City', 'STATE' => 'State', 'ZIPCODE' => 'Zip Code', 'MAIL_ADDRESS' => 'Mailing Address', 'MAIL_CITY' => 'Mailing City', 'MAIL_STATE' => 'Mailing State', 'MAIL_ZIPCODE' => 'Mailing Zipcode'); $categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM ADDRESS_FIELD_CATEGORIES ORDER BY SORT_ORDER")); $custom_RET = DBGet(DBQuery("SELECT TITLE,ID,TYPE,CATEGORY_ID FROM ADDRESS_FIELDS ORDER BY SORT_ORDER"), array(), array('CATEGORY_ID')); foreach ($categories_RET as $category) { foreach ($custom_RET[$category['ID']] as $field) { $fields_list['Address']['ADDRESS_' . $field['ID']] = str_replace("'", ''', $field['TITLE']); }
$custom_id = str_replace("CUSTOM_", "", $field); $custom_RET = DBGet(DBQuery("SELECT TYPE FROM staff_fields WHERE ID={$custom_id}")); if ($custom_RET[1]['TYPE'] == 'date' && !$extra['functions'][$field]) { $extra['functions'][$field] = 'ProperDate'; } elseif ($custom_RET[1]['TYPE'] == 'codeds' && !$extra['functions'][$field]) { $extra['functions'][$field] = 'DeCodeds'; } } } } $RET = GetStaffList($extra); if ($extra['array_function'] && function_exists($extra['array_function'])) { $extra['array_function']($RET); } echo "<html><link rel='stylesheet' type='text/css' href='styles/export.css'><body style=\" font-family:Arial; font-size:12px;\">"; ListOutputPrint_Report($RET, $columns, $extra['singular'] ? $extra['singular'] : '' . _('User') . '', $extra['plural'] ? $extra['plural'] : 'Users', array(), $extra['LO_group'], $extra['LO_options']); echo "</body></html>"; } } else { if (!$fields_list) { if (AllowUse('Users/User.php&category_id=1')) { $fields_list['General'] = array('FULL_NAME' => Preferences('NAME') == 'Common' ? '' . _('Last, Common') . '' : 'Last, First M', 'FIRST_NAME' => '' . _('First') . '', 'TITLE' => '' . _('Title') . '', 'LAST_NAME' => '' . _('Last') . '', 'MIDDLE_NAME' => '' . _('Middle') . '', 'STAFF_ID' => '' . _('Staff Id') . '', 'ROLLOVER_ID' => '' . _('Last Year Id') . '', 'SCHOOLS' => '' . _('Schools') . '', 'USERNAME' => '' . _('Username') . '', 'IS_DISABLE' => '' . _('Disable') . '', 'EMAIL' => '' . _('Email ID') . '', 'PHONE' => '' . _('Phone') . '', 'LAST_LOGIN' => '' . _('Last Login') . '', 'PROFILE' => '' . _('User Profile') . ''); } // if(AllowUse('Students/Student.php&category_id=2')) // { // $fields_list['Schedule'] = array('ADDRESS'=>'Address','CITY'=>'City','STATE'=>'State','ZIPCODE'=>'Zip Code','MAIL_ADDRESS'=>'Mailing Address','MAIL_CITY'=>'Mailing City','MAIL_STATE'=>'Mailing State','MAIL_ZIPCODE'=>'Mailing Zipcode'); // $categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM address_field_categories ORDER BY SORT_ORDER")); // $custom_RET = DBGet(DBQuery("SELECT TITLE,ID,TYPE,CATEGORY_ID FROM address_fields ORDER BY SORT_ORDER"),array(),array('CATEGORY_ID')); // // foreach($categories_RET as $category) // {
if ($sd['ENROLLMENT_CODE'] != '') { $get_ecode = DBGet(DBQuery('SELECT TITLE as ENROLLMENT_CODE FROM student_enrollment_codes WHERE ID=' . $sd['ENROLLMENT_CODE'])); } if ($sd['DROP_CODE'] != '') { $get_dcode = DBGet(DBQuery('SELECT TITLE as DROP_CODE FROM student_enrollment_codes WHERE ID=' . $sd['DROP_CODE'])); } $stu_enr[$si]['ENROLLMENT_CODE'] = $sd['ENROLLMENT_CODE'] != '' ? $get_ecode[1]['ENROLLMENT_CODE'] : 'N/A'; $stu_enr[$si]['DROP_CODE'] = $sd['DROP_CODE'] != '' ? $get_dcode[1]['DROP_CODE'] : 'N/A'; unset($get_dcode); unset($get_ecode); } if (count($stu_enr) > 0) { echo "<tr><td colspan=2 style=\"border-bottom:1px solid #333; font-size:14px; font-weight:bold;\">Enrollment Info</td></tr>"; } echo '<tr><td><br>'; ListOutputPrint_Report($stu_enr, $stu_enr_col, '', '', false, $group = false, $options, 'ForWindow'); echo '</td></tr>'; } echo "<tr><td colspan=3 valign=top>"; //===NEWLY ADDED==================================================================================== $cus_RET = DBGet(DBQuery("SELECT sfc.ID,cf.ID as ID1,cf.TITLE, sfc.TITLE AS TITLE1, cf.TYPE, cf.SELECT_OPTIONS, cf.DEFAULT_SELECTION, cf.REQUIRED\r\n FROM custom_fields AS cf, student_field_categories AS sfc\r\n WHERE sfc.ID = cf.CATEGORY_ID\r\n AND sfc.ID != '1'\r\n AND sfc.ID != '2'\r\n AND sfc.ID != '3'\r\n AND sfc.ID != '4'\r\n AND sfc.ID != '5'\r\n GROUP BY cf.category_id\r\n ORDER BY cf.ID")); foreach ($cus_RET as $cus) { $fields_RET = DBGet(DBQuery("SELECT ID,TITLE FROM custom_fields where CATEGORY_ID='" . $cus['ID'] . "'")); $b = $cus['ID']; if ($_REQUEST['category'][$b]) { $custom_RET = DBGet(DBQuery("SELECT * FROM students WHERE STUDENT_ID='" . UserStudentID() . "'")); $value = $custom_RET[1]; echo "<table width=100% >"; if ($value['CUSTOM_' . $cus['ID1']] != '') { echo "<tr><td colspan=2 style=\"border-bottom:1px solid #333; font-size:14px; font-weight:bold;\">" . $cus['TITLE1'] . "</td></tr>"; }
and srcg.STUDENT_ID=ssm.STUDENT_ID) order by hr.value asc limit 1),(SELECT hr.VALUE FROM honor_roll hr WHERE hr.VALUE<=(SELECT ROUND(AVG(srcg.grade_percent)) FROM `student_report_card_grades` srcg,course_periods cpp WHERE srcg.MARKING_PERIOD_ID = ' . UserMp() . ' and srcg.course_period_id=cpp.course_period_id and cpp.does_honor_roll="Y" and srcg.STUDENT_ID=ssm.STUDENT_ID) order by hr.value desc limit 1)) FROM `student_report_card_grades`srcg,course_periods cpp WHERE srcg.MARKING_PERIOD_ID = ' . UserMp() . ' and srcg.course_period_id=cpp.course_period_id and cpp.does_honor_roll="Y" and `STUDENT_ID`=ssm.STUDENT_ID) AND hr.SCHOOL_ID=' . UserSchool() . ' )AS HONOR_ROLL'; $extra['SELECT'] .= ',(SELECT CONCAT(st.LAST_NAME,\', \',coalesce(st.FIRST_NAME)) FROM staff st,course_periods cp,course_period_var cpv,school_periods p,schedule ss WHERE st.STAFF_ID=cp.TEACHER_ID AND cpv.PERIOD_id=p.PERIOD_ID AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND p.ATTENDANCE=\'Y\' AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND ss.STUDENT_ID=s.STUDENT_ID AND ss.SYEAR=\'' . UserSyear() . '\' AND ss.MARKING_PERIOD_ID = \'' . UserMp() . '\' AND (ss.START_DATE<=\'' . DBDate() . '\' AND (ss.END_DATE>=\'' . DBDate() . '\' OR ss.END_DATE IS NULL)) ORDER BY p.SORT_ORDER LIMIT 1) AS TEACHER'; $extra['SELECT'] .= ',(SELECT cpv.ROOM_ID AS ROOM FROM course_periods cp,course_period_var cpv,school_periods p,schedule ss WHERE cpv.PERIOD_id=p.PERIOD_ID AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND p.ATTENDANCE=\'Y\' AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND ss.STUDENT_ID=s.STUDENT_ID AND ss.SYEAR=\'' . UserSyear() . '\' AND ss.MARKING_PERIOD_ID = \'' . UserMp() . '\' AND (ss.START_DATE<=\'' . DBDate() . '\' AND (ss.END_DATE>=\'' . DBDate() . '\' OR ss.END_DATE IS NULL)) ORDER BY p.SORT_ORDER LIMIT 1) AS ROOM'; } $extra['ORDER_BY'] = 'HONOR_ROLL,SORT_ORDER DESC,ROOM,FULL_NAME'; } $RET = GetStuList($extra); if ($_REQUEST['list']) { echo '<CENTER>'; echo '<TABLE width=80%>'; echo '<TR align=center><TD colspan=6><B>' . sprintf('%s Honor Roll', $school_info_RET[1]['TITLE']) . ' </B></TD></TR>'; echo '<TR align=center><TD colspan=6> </TD></TR>'; $columns = array('FULL_NAME' => 'Student', 'STUDENT_ID' => 'Student ID', 'ALT_ID' => 'Alternate ID', 'GRADE_ID' => 'Grade', 'PHONE' => 'Phone', 'HONOR_ROLL' => 'Honor Roll'); ListOutputPrint_Report($RET, $columns); } else { $options = '--webpage --quiet -t pdf12 --jpeg --no-links --portrait --footer t --header . --left 0.5in --top 0.5in --bodyimage ' . ($htmldocAssetsPath ? $htmldocAssetsPath : 'assets/') . 'hr_bg.jpg --fontsize 10 --textfont times'; $handle = PDFStart(); echo '<!-- MEDIA SIZE 8.5x11in -->'; echo '<!-- MEDIA LANDSCAPE YES -->'; foreach ($RET as $student) { echo '<CENTER>'; echo '<TABLE>'; echo '<TR align=center><TD><FONT size=1><BR><BR><BR><BR><BR><BR><BR><BR></FONT></TD></TR>'; echo '<TR align=center><TD><FONT size=3>We hereby recognize</FONT></TD><TR>'; echo '<TR align=center ><TD ><div style="font-family:Arial; font-size:13px; padding:0px 12px 0px 12px;"><div style="font-size:18px;">' . $student['NICK_NAME'] . ' ' . $student['LAST_NAME'] . '</div></div></TD><TR>'; echo '<TR align=center><TD><FONT size=3>' . 'Who has completed all the academic<BR>requirements for<BR>' . $school_info_RET[1]['TITLE'] . ' ' . $student['HONOR_ROLL'] . ' Honor Roll</FONT></TD><TR>'; echo '</TABLE>'; echo '<TABLE width=80%>'; echo '<TR><TD width=65%><FONT size=1><BR></TD></TR>';