(select CONCAT(LAST_NAME,' ',FIRST_NAME,' ',MIDDLE_NAME,' ') from staff where staff_id=course_periods.teacher_id) as teacher, room as location,days,course_period_id,course_id from course_periods where school_id='".UserSchool()."' and syear='".UserSyear()."' ".$where." order by subject,COURSE_TITLE"; $ret = DBGet(DBQuery($sql)); * */ $sql_subject = 'SELECT SUBJECT_ID,TITLE FROM course_subjects WHERE SCHOOL_ID=' . UserSchool() . ' AND SYEAR= ' . UserSyear(); $sql_subject_ret = DBGet(DBQuery($sql_subject)); if (count($sql_subject_ret)) { foreach ($sql_subject_ret as $subject) { echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">All Courses</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; echo '<table border="0" width="100%" align="center"><tr><td><font face=verdana size=-1><b>' . $subject['TITLE'] . '</b></font></td></tr><tr>'; $sql_course = 'SELECT COURSE_ID,TITLE FROM courses WHERE SCHOOL_ID=' . UserSchool() . ' AND SYEAR= ' . UserSyear() . ' AND SUBJECT_ID=' . $subject['SUBJECT_ID']; $sql_course_ret = DBGet(DBQuery($sql_course)); foreach ($sql_course_ret as $course) { echo '<table border="0"><tr><td style=padding-left:40px;><font face=verdana size=-1><b>' . $course['TITLE'] . '</b></font></td></tr></table>'; $sql_course_period = 'SELECT TITLE FROM course_periods WHERE SCHOOL_ID=' . UserSchool() . ' AND SYEAR= ' . UserSyear() . ' AND COURSE_ID=' . $course['COURSE_ID']; $sql_course_period_ret = DBGet(DBQuery($sql_course_period)); foreach ($sql_course_period_ret as $course_period) { echo '<table border="0" width="100%"><tr><td style=padding-left:80px;><font face=verdana size=-1><b>' . $course_period['TITLE'] . '</b></font></td></tr></table>'; } } echo '</tr><tr><td colspan="2" valign="top" align="right">'; echo '</td></tr></table>';
} if ($_REQUEST['room']) { $extra['SELECT'] .= ',(SELECT cp.ROOM FROM course_periods cp WHERE cp.COURSE_PERIOD_ID=\'' . UserCoursePeriod() . '\') AS ROOM'; } } $RET = GetStuList($extra); if (count($RET)) { $skipRET = array(); for ($i = ($_REQUEST['start_row'] - 1) * $max_cols + $_REQUEST['start_col']; $i > 1; $i--) { $skipRET[-$i] = array('LAST_NAME' => ' '); } $handle = PDFstart(); $cols = 0; $rows = 0; echo "<meta charset='UTF-8'><table width=100% border=0 style=\" font-family:Arial; font-size:12px;\" >"; echo "<meta charset='UTF-8'><tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Student Labels') . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br \\>" . _('Powered by openSIS') . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; echo '<table width="100%" border="0" cellspacing="0" cellpadding="0" style=font-family:Arial; font-size:12px;>'; foreach ($skipRET + $RET as $i => $student) { if ($cols < 1) { echo '<tr>'; } echo '<td width="33.3%" height="86" align="center" valign="middle">'; echo '<table border=0 align=center>'; echo '<tr>'; echo '<td align=center>' . $student['NICK_NAME'] . ' ' . $student['LAST_NAME'] . '</td></tr>'; if ($_REQUEST['teacher']) { echo '<tr><td align=center>' . _('Teacher') . ':'; echo '' . $student['TEACHER'] . '</td></tr>'; } if ($_REQUEST['room']) { echo '<tr><td align=center>' . _('Room No :') . '';
} else { $num_parent = $num_parent[1]['TOTAL_PARENTS']; } echo '<br/>'; echo '<div id="d"><TABLE align=center cellpadding=5 cellspacing=5>'; echo '<tr><td><b>Number of Institutions</b></td><td>:</td><td>  ' . $num_schools . '   </td></tr>'; echo '<tr><td><b>Number of Students</b></td><td>:</td><td>  ' . $num_students . '   </td><td>   Male : ' . $male . '  |  Female : ' . $female . '</td></tr>'; echo '<tr><td><b>Number of Teachers</b></td><td>:</td><td colspan=2>  ' . $num_teacher . '</td></tr>'; echo '<tr><td><b>Number of Staff</b></td><td>:</td><td colspan=2>  ' . $num_staff . '</td></tr>'; echo '<tr><td><b>Number of Parents</b></td><td>:</td><td colspan=2>  ' . $num_parent . '</td></tr>'; echo '</TABLE></div>'; } if ($_REQUEST['func'] == 'Ins_r') { if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'save') { echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">Institute Reports</td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; echo "<table >"; $arr = array(); if ($_REQUEST['fields']) { $i = 0; foreach ($_REQUEST['fields'] as $field => $on) { $columns .= $field . ','; $arr[$field] = $field; } $columns = substr($columns, 0, -1); foreach ($arr as $m => $n) { // if($m=='SCH_TYPE') // $arr[$m]='School Type'; // else // if($m=='SCH_CAT_ID') // $arr[$m]='School Category';
function PrintCatalog($result, $column_names, $singular = '', $plural = '', $link = false, $group = false, $options = false) { if (!isset($options['save'])) { $options['save'] = true; } if (!isset($options['print'])) { $options['print'] = true; } if (!isset($options['search'])) { $options['search'] = true; } if (!isset($options['center'])) { $options['center'] = true; } if (!isset($options['count'])) { $options['count'] = true; } if (!isset($options['sort'])) { $options['sort'] = true; } if (!$link) { $link = array(); } if (!isset($options['add'])) { if (!AllowEdit() || $_REQUEST['_openSIS_PDF']) { if ($link) { unset($link['add']); unset($link['remove']); } } } // PREPARE LINKS --- $result_count = $display_count = count($result); $num_displayed = 100000; $extra = "page={$_REQUEST['page']}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']); $tmp_REQUEST = $_REQUEST; unset($tmp_REQUEST['page']); unset($tmp_REQUEST['LO_sort']); unset($tmp_REQUEST['LO_direction']); unset($tmp_REQUEST['LO_search']); unset($tmp_REQUEST['remove_prompt']); unset($tmp_REQUEST['remove_name']); unset($tmp_REQUEST['LO_save']); unset($tmp_REQUEST['PHPSESSID']); #$PHP_tmp_SELF = PreparePHP_SELF($tmp_REQUEST); $PHP_tmp_SELF = str_replace('>', '', PreparePHP_SELF($tmp_REQUEST)); // END PREPARE LINKS --- // UN-GROUPING $group_count = count($group); if (!is_array($group)) { $group_count = false; } //$side_color = Preferences('COLOR'); $side_color = 'bgcolor="#f5f5f5"'; if ($group_count && $result_count) { $color = 'style=" background-color:#fff; padding:3px 4px 3px 4px;"'; $group_result = $result; unset($result); $result[0] = ''; foreach ($group_result as $item1) { if ($group_count == 1) { if ($color == 'bgcolor="#f5f5f5"') { $color = $side_color; } else { $color = 'bgcolor="#f5f5f5"'; } } foreach ($item1 as $item2) { if ($group_count == 1) { $i++; if (count($group[0]) && $i != 1) { foreach ($group[0] as $column) { $item2[$column] = str_replace('<!-- <!--', '<!--', '<!-- ' . str_replace('-->', '--><!--', $item2[$column])) . ' -->'; } } $item2['row_color'] = $color; $result[] = $item2; } else { if ($group_count == 2) { if ($color == 'bgcolor="#ffffff"') { $color = $side_color; } else { $color = 'bgcolor="#ffffff"'; } } foreach ($item2 as $item3) { if ($group_count == 2) { $i++; if (count($group[0]) && $i != 1) { foreach ($group[0] as $column) { $item3[$column] = '<!-- ' . $item3[$column] . ' -->'; } } if (count($group[1]) && $i != 1) { foreach ($group[1] as $column) { $item3[$column] = '<!-- ' . $item3[$column] . ' -->'; } } $item3['row_color'] = $color; $result[] = $item3; } else { if ($group_count == 3) { if ($color == 'bgcolor="#ffffff"') { $color = $side_color; } else { $color = 'bgcolor="#ffffff"'; } } foreach ($item3 as $item4) { if ($group_count == 3) { $i++; if (count($group[2]) && $i != 1) { foreach ($group[2] as $column) { unset($item4[$column]); } } $item4['row_color'] = $color; $result[] = $item4; } } } } } } $i = 0; } unset($result[0]); $result_count = count($result); unset($_REQUEST['LO_sort']); } // END UN-GROUPING $_LIST['output'] = true; // PRINT HEADINGS, PREPARE PDF, AND SORT THE LIST --- if ($_LIST['output'] != false) { if ($result_count != 0) { $count = 0; $remove = count($link['remove']['variables']); $cols = count($column_names); // HANDLE SEARCHES --- if ($result_count && $_REQUEST['LO_search'] && $_REQUEST['LO_search'] != 'Search') { $_REQUEST['LO_search'] = $search_term = str_replace('\\\\"', '"', $_REQUEST['LO_search']); $_REQUEST['LO_search'] = $search_term = ereg_replace('[^a-zA-Z0-9 _"]*', '', strtolower($search_term)); if (substr($search_term, 0, 0) != '"' && substr($search_term, -1) != '"') { $search_term = ereg_replace('"', '', $search_term); while ($space_pos = strpos($search_term, ' ')) { $terms[strtolower(substr($search_term, 0, $space_pos))] = 1; $search_term = substr($search_term, $space_pos + 1); } $terms[trim($search_term)] = 1; } else { $search_term = ereg_replace('"', '', $search_term); $terms[trim($search_term)] = 1; } unset($terms['of']); unset($terms['the']); unset($terms['a']); unset($terms['an']); unset($terms['in']); foreach ($result as $key => $value) { $values[$key] = 0; foreach ($value as $name => $val) { $val = ereg_replace('[^a-zA-Z0-9 _]+', '', strtolower($val)); if (strtolower($_REQUEST['LO_search']) == $val) { $values[$key] += 25; } foreach ($terms as $term => $one) { if (ereg($term, $val)) { $values[$key] += 3; } } } if ($values[$key] == 0) { unset($values[$key]); unset($result[$key]); $result_count--; $display_count--; } } if ($result_count) { array_multisort($values, SORT_DESC, $result); $result = ReindexResults($result); $values = ReindexResults($values); $last_value = 1; $scale = 100 / $values[$last_value]; for ($i = $last_value; $i <= $result_count; $i++) { $result[$i]['RELEVANCE'] = '<!--' . (int) ($values[$i] * $scale) . '--><IMG SRC="assets/pixel_grey.gif" width=' . (int) ($values[$i] * $scale) . ' height=10>'; } } $column_names['RELEVANCE'] = "Relevance"; if (is_array($group) && count($group)) { $options['count'] == false; $display_zero = true; } } // END SEARCHES --- if ($_REQUEST['LO_sort']) { foreach ($result as $sort) { if (substr($sort[$_REQUEST['LO_sort']], 0, 4) != '<!--') { $sort_array[] = $sort[$_REQUEST['LO_sort']]; } else { $sort_array[] = substr($sort[$_REQUEST['LO_sort']], 4, strpos($sort[$_REQUEST['LO_sort']], '-->') - 5); } } if ($_REQUEST['LO_direction'] == -1) { $dir = SORT_DESC; } else { $dir = SORT_ASC; } if ($result_count > 1) { if (is_int($sort_array[1]) || is_double($sort_array[1])) { array_multisort($sort_array, $dir, SORT_NUMERIC, $result); } else { array_multisort($sort_array, $dir, $result); } for ($i = $result_count - 1; $i >= 0; $i--) { $result[$i + 1] = $result[$i]; } unset($result[0]); } } } // HANDLE SAVING THE LIST --- if ($_REQUEST['LO_save'] == '1') { if (!$options['save_delimiter'] && Preferences('DELIMITER') == 'CSV') { $options['save_delimiter'] = 'comma'; } switch ($options['save_delimiter']) { case 'comma': $extension = 'csv'; break; case 'xml': $extension = 'xml'; break; default: $extension = 'xls'; break; } ob_end_clean(); if ($options['save_delimiter'] != 'xml') { foreach ($column_names as $key => $value) { $output .= str_replace(' ', ' ', eregi_replace('<BR>', ' ', ereg_replace('<!--.*-->', '', $value))) . ($options['save_delimiter'] == 'comma' ? ',' : "\t"); } $output .= "\n"; } foreach ($result as $item) { foreach ($column_names as $key => $value) { if ($options['save_delimiter'] == 'comma' && !$options['save_quotes']) { $item[$key] = str_replace(',', ';', $item[$key]); } $item[$key] = eregi_replace('<SELECT.*SELECTED\\>([^<]+)<.*</SELECT\\>', '\\1', $item[$key]); $item[$key] = eregi_replace('<SELECT.*</SELECT\\>', '', $item[$key]); $output .= ($options['save_quotes'] ? '"' : '') . ($options['save_delimiter'] == 'xml' ? '<' . str_replace(' ', '', $value) . '>' : '') . ereg_replace('<[^>]+>', '', ereg_replace("<div onclick='[^']+'>", '', ereg_replace(' +', ' ', ereg_replace('&[^;]+;', '', str_replace('<BR>·', ' : ', str_replace(' ', ' ', $item[$key])))))) . ($options['save_delimiter'] == 'xml' ? '</' . str_replace(' ', '', $value) . '>' . "\n" : '') . ($options['save_quotes'] ? '"' : '') . ($options['save_delimiter'] == 'comma' ? ',' : "\t"); } $output .= "\n"; } header("Cache-Control: public"); header("Pragma: "); header("Content-Type: application/{$extension}"); header("Content-Disposition: inline; filename=\"" . ProgramTitle() . ".{$extension}\"\n"); if ($options['save_eval']) { eval($options['save_eval']); } echo $output; exit; } // END SAVING THE LIST --- if ($options['center']) { #echo '<CENTER>'; if ($result_count > $num_displayed || ($options['count'] || $display_zero) && (($result_count == 0 || $display_count == 0) && $plural || ($result_count == 0 || $display_count == 0))) { #echo "<TABLE border=0 cellspacing=3 cellpadding=6>" ; if (isset($_REQUEST['_openSIS_PDF'])) { #echo " width=98%"; echo " <TR><TD align=center>"; } } } if ($options['count'] || $display_zero) { if (($result_count == 0 || $display_count == 0) && $plural) { echo "<div style=text-align:left><table cellpadding=1 cellspacing=0 ><tr><td ></td><td ><b>No {$plural} were found.</b></td></tr><tr><td colspan=2 ></td></tr></table></div>"; } elseif ($result_count == 0 || $display_count == 0) { echo '<div style=text-align:left><table cellpadding=1 cellspacing=0 ><tr><td ></td><td ><b>None were found.</b></td></tr><tr><td colspan=2></td></tr></table></div>'; } } if ($result_count != 0 || $_REQUEST['LO_search'] && $_REQUEST['LO_search'] != 'Search') { if (!isset($_REQUEST['_openSIS_PDF'])) { if (!$_REQUEST['page']) { $_REQUEST['page'] = 1; } if (!$_REQUEST['LO_direction']) { $_REQUEST['LO_direction'] = 1; } $start = ($_REQUEST['page'] - 1) * $num_displayed + 1; $stop = $start + ($num_displayed - 1); if ($stop > $result_count) { $stop = $result_count; } if ($result_count > $num_displayed) { $where_message = "<SMALL>Displaying {$start} through {$stop}</SMALL>"; echo "" . _('Go to Page') . " "; if (ceil($result_count / $num_displayed) <= 10) { for ($i = 1; $i <= ceil($result_count / $num_displayed); $i++) { if ($i != $_REQUEST['page']) { $pages .= "<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}>{$i}</A>, "; } else { $pages .= "{$i}, "; } } $pages = substr($pages, 0, -2) . "<BR>"; } else { for ($i = 1; $i <= 7; $i++) { if ($i != $_REQUEST['page']) { $pages .= "<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}>{$i}</A>, "; } else { $pages .= "{$i}, "; } } $pages = substr($pages, 0, -2) . " ... "; for ($i = ceil($result_count / $num_displayed) - 2; $i <= ceil($result_count / $num_displayed); $i++) { if ($i != $_REQUEST['page']) { $pages .= "<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}>{$i}</A>, "; } else { $pages .= "{$i}, "; } } $pages = substr($pages, 0, -2) . " <A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page=" . ($_REQUEST['page'] + 1) . ">Next Page</A><BR>"; } echo $pages; echo '</TD></TR></TABLE>'; echo '<BR>'; } } else { $start = 1; $stop = $result_count; if ($cols > 8 || $_REQUEST['expanded_view']) { $_SESSION['orientation'] = 'landscape'; $repeat_headers = 16; } else { $repeat_headers = 26; } if ($options['print']) { $html = explode('', strtolower(ob_get_contents())); $html = $html[count($html) - 1]; echo '</TD></TR></TABLE>'; $br = substr_count($html, '<br>') + substr_count($html, '</p>') + substr_count($html, '</tr>') + substr_count($html, '</h1>') + substr_count($html, '</h2>') + substr_count($html, '</h3>') + substr_count($html, '</h4>') + substr_count($html, '</h5>'); if ($br % 2 != 0) { $br++; echo '<BR>'; } } else { echo '</TD></TR></TABLE>'; } } // END MISC --- // WIDTH = 100% echo '<TABLE width=98% border=0 cellspacing=0 cellpadding=0><TR>'; // SEARCH BOX & MORE HEADERS if ($where_message || $singular && $plural || !isset($_REQUEST['_openSIS_PDF']) && $options['search']) { echo '<TD align=center>'; //echo '<TABLE cellpadding=1 width=100% border=1 style="border-collapse:collapse" >'; //echo "<TR><TD align=left valign=middle>"; //if($singular && $plural && $options['count']) //{ /*f($display_count > 1) echo "<table cellpadding=5 cellspacing=5 class=alert_box align=left ><tr><td class=notice></td><td class=notice_msg ><b>$display_count $plural were found.</b></td></tr></table>"; elseif($display_count==1) echo "<table cellpadding=5 cellspacing=5 class=alert_box align=left ><tr><td class=notice></td><td class=notice_msg ><b>1 $singular was found.</b></td></tr></table>";*/ //if($where_message) //echo '<br>'.$where_message; //} if ($options['save'] && !isset($_REQUEST['_openSIS_PDF']) && $result_count > 0) { //echo str_replace("Modules.php", "for_export.php", $PHP_tmp_SELF); //echo "<table cellpadding=0 cellspacing=0 class=download align=left ><tr><td><A HREF=".str_replace('Modules.php', 'for_export.php', $PHP_tmp_SELF)."&$extra&LO_save=1&_openSIS_PDF=true ><IMG SRC=assets/download.png border=0 alt=\"Download\" title=\"Download\"></a></td></tr></table>"; //echo "<br><br><table class=download ><tr><td><A HREF=".str_replace('Modules.php', 'for_export.php', $PHP_tmp_SELF)."&$extra&_openSIS_PDF=true ><IMG SRC=assets/download.png border=0></a></td><td><A HREF=".str_replace('Modules.php', 'for_export.php', $PHP_tmp_SELF)."&$extra&_openSIS_PDF=true >Download</A></td></tr></table>"; echo '</TD>'; } $colspan = 1; if (!isset($_REQUEST['_openSIS_PDF']) && $options['search']) { $tmp_REQUEST = $_REQUEST; unset($tmp_REQUEST['LO_search']); unset($tmp_REQUEST['page']); echo '<TD height="50" align=right valign=middle>'; echo "<INPUT type=text class='cell_medium' id=LO_search name=LO_search value='" . ($_REQUEST['LO_search'] && $_REQUEST['LO_search'] != 'Search' ? $_REQUEST['LO_search'] : 'Search\' style=\'color:BBBBBB\''), "' onfocus='if(this.value==\"Search\") this.value=\"\"; this.style.color=\"000000\";' onblur='if(this.value==\"\") {this.value=\"Search\"; this.style.color=\"BBBBBB\";}' onkeypress='if(event.keyCode==13){document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&LO_search=\"+this.value; return false;} '> <INPUT type=button class='btn_go' value=Go onclick='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&LO_search=\"+document.getElementById(\"LO_search\").value;'></TD>"; $colspan++; } echo "</TR>"; echo '<TR style="height:0;"><TD width=100% align=center colspan=' . $colspan . '><DIV id=LOx' . (count($column_names) + ($result_count != 0 && $cols && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0) + ($remove && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0)) . ' style="width:0; position: relative; height:0;"></DIV></TD></TR></TABLE>'; } else { echo '<TD width=100% align=right><DIV id=LOx' . (count($column_names) + ($result_count != 0 && $cols && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0) + ($remove && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0)) . ' style="width:0; position: relative; height:0;"></DIV>'; } // END SEARCH BOX ---- echo '</TD></TR><TR><TD>'; // SHADOW if (!isset($_REQUEST['_openSIS_PDF'])) { echo '<TABLE width=100% cellpadding=0 cellspacing=0><TR><TD align=center>'; } echo "<TABLE cellpadding=6 width=100% cellspacing=1 border=\"1px solid #a9d5e9 \" style=\"border-collapse:collapse\" align=center>"; if (!isset($_REQUEST['_openSIS_PDF']) && $stop - $start > 10) { echo '<THEAD>'; } if (!isset($_REQUEST['_openSIS_PDF'])) { echo '<TR>'; } $i = 1; if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $result_count != 0) { //THIS LINE IS FOR COLUMN HEADING echo "<TD class=subtabs><DIV id=LOx{$i} style='position: relative;'></DIV></TD>"; $i++; } if ($result_count != 0 && $cols && !isset($_REQUEST['_openSIS_PDF'])) { foreach ($column_names as $key => $value) { if ($_REQUEST['LO_sort'] == $key) { $direction = -1 * $_REQUEST['LO_direction']; } else { $direction = 1; } //THIS LINE IS FOR COLUMN HEADING echo "<TD class=subtabs><DIV id=LOx{$i} style='position: relative;'></DIV>"; echo "<A "; if ($options['sort']) { echo "HREF={$PHP_tmp_SELF}&page={$_REQUEST['page']}&LO_sort={$key}&LO_direction={$direction}&LO_search=" . urlencode($_REQUEST['LO_search']); } echo " class=column_heading><b>{$value}</b></A>"; if ($i == 1) { echo "<DIV id=LOy0 style='position: relative;'></DIV>"; } echo "</TD>"; $i++; } //echo '<TD width=0><DIV id=LO'.$i.'></DIV></TD>'; echo "</TR>"; } $color = 'bgcolor="#ffffff"'; //style="height: 300px; overflow: auto; padding-right: 16px;" if (!isset($_REQUEST['_openSIS_PDF']) && $stop - $start > 10) { echo '</THEAD><TBODY>'; } // mab - enable add link as first or last if ($result_count != 0 && $link['add']['first'] && $stop - $start >= $link['add']['first']) { //if($remove && !isset($_REQUEST['_openSIS_PDF'])) // $cols++; if ($link['add']['link'] && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add', $link['add']['title'], $link['add']['link']) . "</TD></TR>"; } elseif ($link['add']['span'] && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add') . $link['add']['span'] . "</TD></TR>"; } elseif ($link['add']['html'] && $cols) { echo "<TR {$color}>"; if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $link['add']['html']['remove']) { echo "<TD class=even align=left>" . $link['add']['html']['remove'] . "</TD>"; } elseif ($remove && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TD class=even align=left>" . button('add') . "</TD>"; } foreach ($column_names as $key => $value) { echo "<TD class=even align=left >" . $link['add']['html'][$key] . "</TD>"; } echo "</TR>"; $count++; } } for ($i = $start; $i <= $stop; $i++) { $item = $result[$i]; if (isset($_REQUEST['_openSIS_PDF']) && $options['print'] && count($item)) { foreach ($item as $key => $value) { $value = eregi_replace('<SELECT.*SELECTED\\>([^<]+)<.*</SELECT\\>', '\\1', $value); $value = eregi_replace('<SELECT.*</SELECT\\>', '', $value); if (strpos($value, 'LO_field') === false) { $item[$key] = str_replace(' ', ' ', ereg_replace("<div onclick='[^']+'>", '', $value)); } else { $item[$key] = ereg_replace("<div onclick='[^']+'>", '', $value); } } } if ($item['row_color']) { $color = $item['row_color']; } elseif ($color == 'bgcolor="#ffffff"') { $color = $side_color; } else { $color = 'bgcolor="#ffffff"'; } //$color = '#EDF3FE'; if (isset($_REQUEST['_openSIS_PDF']) && $count % $repeat_headers == 0) { if ($count != 0) { echo '</TABLE>'; echo "<div style=\"page-break-after: always;\"></div>"; echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Student Advanced Report') . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />" . _('Powered by openSIS') . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; echo '<TABLE cellpadding=6 width=100% cellspacing=1 border="1px solid #a9d5e9 " style="border-collapse:collapse" align=center>'; } echo "<TR>"; if ($remove && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TD bgcolor=#d3d3d3></TD>"; } if ($cols) { foreach ($column_names as $key => $value) { echo "<TD bgcolor=#d3d3d3 >" . str_replace(' ', ' ', $value) . "</TD>"; } } echo "</TR>"; } if ($count == 0) { $count = $br; } echo "<TR {$color}>"; $count++; if ($remove && !isset($_REQUEST['_openSIS_PDF'])) { $button_title = $link['remove']['title']; $button_link = $link['remove']['link']; if (count($link['remove']['variables'])) { foreach ($link['remove']['variables'] as $var => $val) { $button_link .= "&{$var}=" . $item[$val]; } } echo "<TD {$color}>" . button('remove', $button_title, $button_link) . "</TD>"; } if ($cols) { foreach ($column_names as $key => $value) { if ($link[$key] && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TD {$color} >"; if ($key == 'FULL_NAME') { echo '<DIV id=LOy' . ($count - $br) . ' style="height: 100%; min-height: 100%; position: relative;">'; } if ($link[$key]['js'] === true) { echo "<A HREF=# onclick='window.open(\"{$link[$key][link]}"; if (count($link[$key]['variables'])) { foreach ($link[$key]['variables'] as $var => $val) { echo "&{$var}=" . urlencode($item[$val]); } } echo "\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'"; if ($link[$key]['extra']) { echo ' ' . $link[$key]['extra']; } echo ">"; } else { echo "<A HREF={$link[$key][link]}"; if (count($link[$key]['variables'])) { foreach ($link[$key]['variables'] as $var => $val) { echo "&{$var}=" . urlencode($item[$val]); } } if ($link[$key]['extra']) { echo ' ' . $link[$key]['extra']; } echo " onclick='grabA(this); return false;'>"; } if ($color == Preferences('HIGHLIGHT')) { echo ''; } else { echo '<b>'; } echo $item[$key]; echo '</b>'; if (!$item[$key]) { echo '***'; } echo "</A>"; if ($key == 'FULL_NAME') { echo '</DIV>'; } echo "</TD>"; } else { echo "<TD {$color} >"; if ($key == 'FULL_NAME') { echo '<DIV id=LOy' . ($count - $br) . ' style="position: relative;">'; } if ($color == Preferences('HIGHLIGHT')) { echo ''; } echo $item[$key]; if (!$item[$key]) { echo ' '; } if ($key == 'FULL_NAME') { echo '<DIV>'; } echo "</TD>"; } } } echo "</TR>"; } if ($result_count != 0 && (!$link['add']['first'] || $link['add']['first'] && $stop - $start < $link['add']['first'])) { if ($link['add']['link'] && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add', $link['add']['title'], $link['add']['link']) . "</TD></TR>"; } elseif ($link['add']['span'] && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add') . $link['add']['span'] . "</TD></TR>"; } elseif ($link['add']['html'] && $cols) { if ($count % 2) { $color = 'bgcolor=#ffffff'; } else { $color = $side_color; } echo "<TR {$color}>"; if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $link['add']['html']['remove']) { echo "<TD bgcolor=#ffffff align=left>" . $link['add']['html']['remove'] . "</TD>"; } elseif ($remove && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TD bgcolor=#ffffff align=left >" . button('add') . "</TD>"; } foreach ($column_names as $key => $value) { echo "<TD bgcolor=#ffffff align=left valign=top>" . $link['add']['html'][$key] . "</TD>"; } echo "</TR>"; } } if ($result_count != 0) { if (!isset($_REQUEST['_openSIS_PDF']) && $stop - $start > 10) { echo '</TBODY>'; } echo "</TABLE>"; if (!isset($_REQUEST['_openSIS_PDF'])) { echo '</TD ></TR></TABLE>'; } echo "</TD ></TR>"; echo "</TABLE>"; if ($options['center']) { echo ''; } } } if ($result_count == 0) { if ($result_count > $num_displayed || ($options['count'] || $display_zero) && (($result_count == 0 || $display_count == 0) && $plural || ($result_count == 0 || $display_count == 0))) { if ($link['add']['link'] && !isset($_REQUEST['_openSIS_PDF'])) { echo '<table width=120px cellspacing=8 cellpadding=6 ><tr><TD align=left class=lone_add >' . button('add', $link['add']['title'], $link['add']['link']) . '</td></tr></table>'; } elseif (($link['add']['html'] || $link['add']['span']) && count($column_names) && !isset($_REQUEST['_openSIS_PDF'])) { $color = $side_color; if ($options['center']) { echo '<TABLE width=100% cellpadding=0 cellspacing=0><TR><TD align=center>'; } if ($link['add']['html']) { echo "<TABLE cellpadding=6 cellspacing=1 width=96% class=\"grid\"><TR><TD class=subtabs></TD>"; foreach ($column_names as $key => $value) { echo "<TD class=subtabs><A><b>" . str_replace(' ', ' ', $value) . "</b></A></TD>"; } echo "</TR>"; echo "<TR class=odd>"; if ($link['add']['html']['remove']) { echo "<TD >" . $link['add']['html']['remove'] . "</TD>"; } else { echo "<TD>" . button('add') . "</TD>"; } foreach ($column_names as $key => $value) { echo "<TD >" . $link['add']['html'][$key] . "</TD>"; } echo "</TR>"; echo "</TABLE>"; } elseif ($link['add']['span'] && !isset($_REQUEST['_openSIS_PDF'])) { echo "<TABLE><TR><TD align=center>" . button('add') . $link['add']['span'] . "</TD></TR></TABLE>"; } echo "</TD></TR></TABLE>"; if ($options['center']) { echo '</CENTER>'; } } } } if ($result_count != 0) { if ($options['yscroll']) { echo '<div id="LOy_layer" style="position: absolute; top: 0; left: 0; visibility:hidden;">'; echo '<TABLE cellpadding=6 id=LOy_table>'; $i = 1; if ($cols && !isset($_REQUEST['_openSIS_PDF'])) { $color = $side_color; foreach ($result as $item) { echo "<TR><TD {$color} id=LO_row{$i}>"; if ($color == Preferences('HIGHLIGHT')) { echo ''; } echo $item['FULL_NAME']; if (!$item['FULL_NAME']) { echo ' '; } if ($color == Preferences('HIGHLIGHT')) { echo ''; } echo "</TD></TR>"; $i++; if ($item['row_color']) { $color = $item['row_color']; } elseif ($color == 'class=even') { $color = $side_color; } else { $color = 'class=even'; } } } echo '</TABLE>'; echo '</div>'; } echo '<div id="LOx_layer" style="position: absolute; top: 0; left: 0; visibility:hidden;">'; echo '<div style="page-break-before: inherit;"> </div>'; echo '<TABLE cellpadding=6 id=LOx_table><TR>'; $i = 1; if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $result_count != 0) { echo "<TD class=grid id=LO_col{$i}></TD>"; $i++; } if ($cols && !isset($_REQUEST['_openSIS_PDF'])) { foreach ($column_names as $key => $value) { echo '<TD class=grid id=LO_col' . $i . '><A class=column_heading><b>' . str_replace('controller', '', $value) . '</b></A></TD>'; $i++; } } echo '</TR></TABLE>'; echo '</div>'; } } }
foreach ($_REQUEST['st_arr'] as $arrkey => $student_id) { $total_QP_transcript = 0; $total_QP_transcript_fy = 0; $total_QP_transcript_qr = 0; $total_CGPA = 0; $total_CGPA_earned = 0; $total_credit_earned = 0; $total_CGPA_earned_fy = 0; $total_CGPA_earned_qr = 0; $total_CGPA_attemted = 0; $tot_qp = 0; if (User('PROFILE') == 'admin' || UserStudentID() == $student_id) { $stu_ret = DBGet(DBQuery($studataquery . $student_id), array('BIRTHDATE' => 'ProperDate')); $sinfo = $stu_ret[1]; $school_html = '<table border="0" align=right style="padding-right:40px"><tr><td align=right><table border="0" cellpadding="4" cellspacing="0"> <tr><td>' . DrawLogo() . '</td></tr> <tr> <td valign="top" ><div style="font-family:Arial; font-size:13px;"> <div style="font-size:18px; font-weight:bold; ">' . $schoolinfo['TITLE'] . '</div> <div>' . $schoolinfo['ADDRESS'] . '</div> <div>' . $schoolinfo['CITY'] . ', ' . $schoolinfo['STATE'] . ' ' . $schoolinfo['ZIPCODE'] . '</div> '; if ($schoolinfo['PHONE']) { $school_html .= '<div>Phone: ' . $schoolinfo['PHONE'] . '</div> '; } $school_html .= '<div style="font-size:15px; ">' . $schoolinfo['PRINCIPAL'] . ', Principal</div></div> </td> </tr> </table></td></tr></table>'; $tquery = "select * from transcript_grades where student_id = {$student_id}";
Widgets('mailing_labels'); } $RET = GetStuList($extra); if (count($RET)) { include 'modules/students/includes/FunctionsInc.php'; //------------Comment Heading ----------------------------------------------------- // echo 'SELECT c.ID AS CATEGORY_ID,c.TITLE AS CATEGORY_TITLE,c.CUSTODY,c.EMERGENCY,f.ID,f.TITLE,f.TYPE,f.SELECT_OPTIONS,f.DEFAULT_SELECTION,f.REQUIRED FROM people_field_categories c,people_fields f WHERE f.CATEGORY_ID=c.ID ORDER BY c.SORT_ORDER,c.TITLE,f.SORT_ORDER,f.TITLE'; // echo"hi";exit; $people_categories_RET = DBGet(DBQuery('SELECT c.ID AS CATEGORY_ID,c.TITLE AS CATEGORY_TITLE,f.ID,f.TITLE,f.TYPE,f.SELECT_OPTIONS,f.DEFAULT_SELECTION,f.REQUIRED FROM people_field_categories c,people_fields f WHERE f.CATEGORY_ID=c.ID ORDER BY c.SORT_ORDER,c.TITLE,f.SORT_ORDER,f.TITLE'), array(), array('CATEGORY_ID')); explodeCustom($people_categories_RET, $people_custom, 'p'); unset($_REQUEST['modfunc']); $handle = PDFStart(); foreach ($RET as $student) { $_SESSION['student_id'] = $student['STUDENT_ID']; echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Student Information Report</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; echo "<table cellspacing=0 border=\"0\" style=\"border-collapse:collapse\">"; echo "<tr><td colspan=3 style=\"height:18px\"></td></tr>"; if ($StudentPicturesPath && (($file = @fopen($picture_path = $StudentPicturesPath . '/' . UserStudentID() . '.JPG', 'r')) || ($file = @fopen($picture_path = $StudentPicturesPath . '/' . UserStudentID() . '.JPG', 'r')))) { echo '<tr><td width=300><IMG SRC="' . $picture_path . '?id=' . rand(6, 100000) . '" width=150 style="padding:4px; background-color:#fff; border:1px solid #333" ></td><td width=12px></td>'; } else { echo '<tr><td width=300><IMG SRC="assets/noimage.jpg?id=' . rand(6, 100000) . '" width=144 style="padding:4px; background-color:#fff; border:1px solid #333"></td><td width=12px></td>'; } fclose($file); # ---------------- Sql Including Comment ------------------------------- # $sql = DBGet(DBQuery('SELECT s.gender AS GENDER, s.ethnicity AS ETHNICITY, s.common_name AS COMMON_NAME, s.social_security AS SOCIAL_SEC_NO, s.birthdate AS BIRTHDAY, s.email AS EMAIL, s.phone AS PHONE, s.language AS LANGUAGE, mi.physician AS PHYSICIAN_NAME, mi.physician_phone AS PHYSICIAN_PHONO,mi.preferred_hospital AS HOSPITAL,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING FROM students s, student_enrollment se,student_enrollment_codes sec,medical_info mi WHERE s.STUDENT_ID=\'' . $_SESSION['student_id'] . '\' AND s.STUDENT_ID=mi.STUDENT_ID AND mi.SCHOOL_ID=\'' . UserSchool() . '\' AND mi.SYEAR=sec.SYEAR AND s.STUDENT_ID=se.STUDENT_ID AND se.SYEAR=sec.SYEAR'), array('BIRTHDAY' => 'ProperDate')); $sql = $sql[1]; $medical_note = DBGet(DBQuery('SELECT doctors_note_date AS MCOMNT,doctors_note_comments AS DNOTE FROM student_medical_notes WHERE STUDENT_ID=\'' . $_SESSION['student_id'] . '\''), array('MCOMNT' => 'ProperDate')); unset($_openSIS['DrawHeader']); echo "<td valign=top width=300>"; echo "<table width=100% >";
} if ($_REQUEST['elements']['comments'] == 'Y') { foreach ($all_commentsA_RET as $comment) { $columns['C' . $comment[1]['ID']] = $comment[1]['TITLE']; } $columns['COMMENT'] = 'Comment'; } if ($_REQUEST['elements']['gpa'] == 'Y') { $columns['GPA'] = 'GPA'; } //start of report card print $handle = PDFStart(); if (!isset($_REQUEST['elements']['percents']) || isset($_REQUEST['elements']['percents']) && $_REQUEST['elements']['percents'] == 'Y') { foreach ($RET as $student_id => $course_periods) { echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . ' (' . $cur_session . ')' . "<div style=\"font-size:12px;\">Student Report Card</div></td><td align=right style=\"padding-top:20px\">" . ProperDate(DBDate()) . "<br \\>Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; echo '<!-- MEDIA SIZE 8.5x11in -->'; if (!isset($_REQUEST['elements']['percents']) || isset($_REQUEST['elements']['percents']) && $_REQUEST['elements']['percents'] == 'Y') { $comments_arr = array(); $comments_arr_key = count($all_commentsA_RET) > 0; unset($grades_RET); $i = 0; $total_grade_point = 0; $Total_Credit_Hr_Attempted = 0; foreach ($course_periods as $course_period_id => $mps) { $i++; $grades_RET[$i]['COURSE_TITLE'] = $mps[key($mps)][1]['COURSE_TITLE']; $grades_RET[$i]['TEACHER'] = $mps[key($mps)][1]['TEACHER']; $grades_RET[$i]['TEACHER_ID'] = $mps[key($mps)][1]['TEACHER_ID']; $grades_RET[$i]['CGPA'] = round($mps[key($mps)][1]['UNWEIGHTED_GPA'], 3); if ($mps[key($mps)][1]['WEIGHTED_GP'] && $mps[key($mps)][1]['COURSE_WEIGHT']) {
$mp_string .= ' or s.marking_period_id=' . $row_mp_detail[1]['GRANDPARENT_ID'] . ''; } $mp_string .= ' or s.marking_period_id is null'; # -------------------------- Date Function Start ------------------------------- # function cov_date($dt) { $temp_date = explode("-", $dt); $final_date = $temp_date[1] . '-' . $temp_date[2] . '-' . $temp_date[0]; return $final_date; } # -------------------------- Date Function End ------------------------------- # if (count($RET_stu)) { $handle = PDFStart(); foreach ($RET_stu as $student_id => $courses) { echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Student Daily Schedule</div></td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\"> Schedule for: " . $row_mp_detail[1]['TITLE'] . " : " . cov_date($row_mp_detail[1]['START_DATE']) . " - " . cov_date($row_mp_detail[1]['END_DATE']) . "</td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=4 style=\"border-top:1px solid #333;\"> </td></tr></table>"; # --------------------------------------- Start Change ------------------------------------------- # $st_data = DBGet(DBQuery("SELECT * FROM students WHERE student_id = " . $courses[1]['STUDENT_ID'])); unset($_openSIS['DrawHeader']); echo '<br>'; echo '<table border=0>'; echo '<tr><td>Student ID:</td>'; echo '<td>' . $courses[1]['STUDENT_ID'] . '</td></tr>'; echo '<tr><td>Student Name:</td>'; echo '<td><b>' . $courses[1]['FULL_NAME'] . '</b></td></tr>'; echo '<tr><td>' . $courses[1]['GRD_LVL'] . '</td>'; echo '<td>' . $st_data[1]['CUSTOM_10'] . '</td></tr>'; echo '</table>'; $sch_exist = DBGet(DBQuery("SELECT COUNT(s.id) AS SCH_COUNT FROM schedule s WHERE s.syear=" . UserSyear() . "\r\n\t\t\t\t\tAND s.student_id='" . $courses[1]['STUDENT_ID'] . "'\r\n\t\t\t\t\tAND s.school_id=" . UserSchool() . "\r\n\t\t\t\t\tAND {$mp_string} )")); $sch_exist_yn = $sch_exist[1]['SCH_COUNT']; if ($sch_exist_yn != 0) {
$where = ' AND c.course_id=cp.course_id AND c.grade_level=' . $_REQUEST['id']; } $sql = 'select distinct (select title from course_subjects where subject_id=(select subject_id from courses where course_id=cp.course_id)) as subject, (select title from courses where course_id=cp.course_id) as COURSE_TITLE,cp.course_id from course_periods cp' . $from . ' where cp.school_id=\'' . UserSchool() . '\' and cp.syear=\'' . UserSyear() . '\' ' . $where . ' order by subject,COURSE_TITLE'; $ret = DBGet(DBQuery($sql)); if (count($ret)) { foreach ($ret as $s_id) { echo "<meta charset='UTF-8'><table width=100% style=\" font-family:Arial; font-size:12px;\" >"; $grade_level_RET = DBGet(DBQuery('SELECT TITLE FROM school_gradelevels WHERE id=\'' . $_REQUEST['id'] . '\'')); $grade_title = $grade_level_RET[1]['TITLE']; if ($grade_title != '') { echo "<meta charset='UTF-8'><tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Course') . "" . _('catalog by Grade Level') . " : " . $grade_title . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; } else { echo "<meta charset='UTF-8'><tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Course') . "" . _('catalog by Grade Level') . "\t: " . _('All') . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>"; } echo '<div align="center">'; echo '<table border="0" width="97%" align="center"><tr><td><font face=verdana size=-1><b>' . $s_id['SUBJECT'] . '</b></font></td></tr>'; echo '<tr><td align="right"><table border="0" width="97%"><tr><td><font face=verdana size=-1><b>' . $s_id['COURSE_TITLE'] . '</b></font></td></tr>'; $sql_periods = 'SELECT cp.SHORT_NAME,(SELECT TITLE FROM school_periods WHERE period_id=cp.period_id) AS PERIOD,cp.ROOM,cp.DAYS,(SELECT CONCAT(LAST_NAME,\' \',FIRST_NAME,\' \') from staff where staff_id=cp.TEACHER_ID) as TEACHER from course_periods cp where cp.course_id=' . $s_id['COURSE_ID'] . ' and cp.syear=\'' . UserSyear() . '\' and cp.school_id=\'' . UserSchool() . '\''; $period_list = DBGet(DBQuery($sql_periods)); ##############################################List Output Generation################################################## $columns = array('SHORT_NAME' => '' . _('Course'), 'PERIOD' => '' . _('Time'), 'DAYS' => '' . _('Days'), 'ROOM' => '' . _('Location'), 'TEACHER' => '' . _('Teacher')); echo '<tr><td colspan="2" valign="top" align="right">'; PrintCatalog($period_list, $columns, _('Course'), _('Courses'), '', '', array('search' => false)); echo '</td></tr></table></td></tr></table></td></tr>'; ###################################################################################################################### echo '</table></div>'; echo "<meta charset='UTF-8'><div style=\"page-break-before: always;\"></div>"; }
if ($row_mp_detail['grandparent_id'] != -1) { $mp_string .= ' or s.marking_period_id=' . $row_mp_detail['grandparent_id'] . ''; } # -------------------------- Date Function Start ------------------------------- # function cov_date($dt) { $temp_date = explode("-", $dt); $final_date = $temp_date[1] . '-' . $temp_date[2] . '-' . $temp_date[0]; return $final_date; } # -------------------------- Date Function End ------------------------------- # if (count($RET_stu)) { $handle = PDFStart(); foreach ($RET_stu as $student_id => $courses) { echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Student Daily Schedule') . "</div></td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\"> " . _('Schedule for') . ": " . $row_mp_detail['title'] . " : " . cov_date($row_mp_detail['start_date']) . " - " . cov_date($row_mp_detail['end_date']) . "</td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />" . _('Powered by openSIS') . "</td></tr><tr><td colspan=4 style=\"border-top:1px solid #333;\"> </td></tr></table>"; # --------------------------------------- Start Change ------------------------------------------- # $st_data = DBGet(DBQuery("SELECT * FROM students WHERE student_id = " . $courses[1]['STUDENT_ID'])); unset($_openSIS['DrawHeader']); echo '<br>'; echo '<table border=0>'; /*echo '<tr><td>Student ID:</td>'; echo '<td>'.$courses[1]['STUDENT_ID'] .'</td></tr>';*/ echo '<tr><td>' . _('Student ID') . ':</td>'; echo '<td>' . $courses[1]['STUDENT_ID'] . '</td></tr>'; echo '<tr><td>' . _('Student Name') . ':</td>'; echo '<td><b>' . $courses[1]['FULL_NAME'] . '</b></td></tr>'; echo '<tr><td>' . $courses[1]['GRD_LVL'] . '</td>'; echo '<td>' . $st_data[1]['CUSTOM_10'] . '</td></tr>'; echo '</table>'; $sch_exist = DBGet(DBQuery("SELECT COUNT(s.id) AS SCH_COUNT FROM schedule s WHERE s.syear=" . UserSyear() . "\n\t\t\t\t\tAND s.student_id='" . $courses[1]['STUDENT_ID'] . "'\n\t\t\t\t\tAND s.school_id=" . UserSchool() . "\n\t\t\t\t\tAND {$mp_string} )"));
// get the fy marking period id, there should be exactly one fy marking period $fy_id = DBGet(DBQuery('SELECT MARKING_PERIOD_ID FROM school_years WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\'')); $fy_id = $fy_id[1]['MARKING_PERIOD_ID']; $course_periods_RET = DBGet(DBQuery('SELECT cp.TITLE,cp.COURSE_PERIOD_ID,cpv.PERIOD_ID,cp.MARKING_PERIOD_ID,cpv.DAYS,c.TITLE AS COURSE_TITLE,cp.TEACHER_ID,(SELECT CONCAT(Trim(LAST_NAME),\', \',FIRST_NAME) FROM staff WHERE STAFF_ID=cp.TEACHER_ID) AS TEACHER FROM course_periods cp,course_period_var cpv,courses c WHERE c.COURSE_ID=cp.COURSE_ID AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND cp.COURSE_PERIOD_ID IN (' . $cp_list . ') GROUP BY cpv.PERIOD_ID,cpv.COURSE_PERIOD_ID ORDER BY TEACHER')); $first_extra = $extra; $handle = PDFStart(); $PCL_UserCoursePeriod = $_SESSION['UserCoursePeriod']; // save/restore for teachers foreach ($course_periods_RET as $teacher_id => $course_period) { unset($_openSIS['DrawHeader']); $_openSIS['User'] = array(1 => array('STAFF_ID' => $course_period['TEACHER_ID'], 'NAME' => 'name', 'PROFILE' => 'teacher', 'SCHOOLS' => ',' . UserSchool() . ',', 'SYEAR' => UserSyear())); $_SESSION['UserCoursePeriod'] = $course_period['COURSE_PERIOD_ID']; echo '<table width="100%" bgcolor="#fff" cellpadding="0" cellspacing="0" border="0"><tbody>'; echo '<tr><td>'; echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >"; echo "<tr><td width=105>" . DrawLogo() . "</td>"; echo "<td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Teacher Class List</div></td>"; echo "<td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr>"; echo "<tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr>"; echo "</table>"; echo '</td></tr>'; echo '<tr><td width="100%">'; echo "<table>"; echo '<tr><td>Teacher Name:</td>'; echo '<td>' . $course_period['TEACHER'] . '</td></tr>'; echo '<tr><td>Course Name:</td>'; echo '<td>' . $course_period['COURSE_TITLE'] . '</td></tr>'; echo '<tr><td>Course Period Name:</td>'; echo '<td>' . GetActualCpName($course_period) . '</td></tr>'; echo '<tr><td>Course Period Occurance:</td>'; echo '<td>' . GetPeriodOcc($course_period['COURSE_PERIOD_ID']) . '</td></tr>';