//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>';
