本文整理汇总了PHP中GetSchool函数的典型用法代码示例。如果您正苦于以下问题：PHP GetSchool函数的具体用法？PHP GetSchool怎么用？PHP GetSchool使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了GetSchool函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: _makeNextSchool
function _makeNextSchool($value, $column)
{
global $THIS_RET, $_CENTRE;
if ($value == '0') {
return 'Retain';
} elseif ($value == '-1') {
return 'Do not enroll after this school year';
} elseif ($value == $THIS_RET['SCHOOL_ID']) {
return 'Next Grade at ' . GetSchool($value);
} else {
return GetSchool($value);
}
}示例2: GetSchool
# See license.txt.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'print') {
echo '<style type="text/css">.print_wrapper{font-family:arial;font-size:12px;}.print_wrapper table table{border-right:1px solid #666;border-bottom:1px solid #666;}.print_wrapper table td{font-size:12px;}</style>';
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:10px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('List of Events') . "</div></td><td align=right style=\"padding-top:10px;\">" . ProperDate(DBDate()) . "<br />" . _('Powered by openSIS') . "</td></tr><tr><td colspan=2 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo "<div class=print_wrapper>";
ListOutputFloat($_SESSION['events_RET'], array('SCHOOL_DATE' => _('Date'), 'TITLE' => _('Event'), 'DESCRIPTION' => _('Description')), _('Event'), _('Events'), '', '', array('search' => false, 'count' => false));
echo "</div>";
#ListOutput($_SESSION['events_RET'],array('SCHOOL_DATE'=>'Date','TITLE'=>'Event','DESCRIPTION'=>'Description'),'Event','Events');
}
if (!$_REQUEST['month']) {
$_REQUEST['month'] = date("n");
} else {
$_REQUEST['month'] = MonthNWSwitch($_REQUEST['month'], 'tonum') * 1;
}
if (!$_REQUEST['year']) {
$_REQUEST['year'] = date("Y");
}
$time = mktime(0, 0, 0, $_REQUEST['month'], 1, $_REQUEST['year']);
DrawBC("" . _('School Setup') . ">> " . ProgramTitle());示例3: CONCAT
(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>';示例4: GetStuList
$RET = GetStuList($extra);
if (count($RET)) {
include 'modules/Students/includes/functions.php';
//------------Comment Heading -----------------------------------------------------
//$categories_RET = DBGet(DBQuery("SELECT ID,TITLE,INCLUDE FROM STUDENT_FIELD_CATEGORIES ORDER BY SORT_ORDER,TITLE"),array(),array('ID'));
// get the address and contacts custom fields, create the select lists and expand select and codeds options
$address_categories_RET = DBGet(DBQuery("SELECT c.ID AS CATEGORY_ID,c.TITLE AS CATEGORY_TITLE,c.RESIDENCE,c.MAILING,c.BUS,f.ID,f.TITLE,f.TYPE,f.SELECT_OPTIONS,f.DEFAULT_SELECTION,f.REQUIRED FROM ADDRESS_FIELD_CATEGORIES c,ADDRESS_FIELDS f WHERE f.CATEGORY_ID=c.ID ORDER BY c.SORT_ORDER,c.TITLE,f.SORT_ORDER,f.TITLE"), array(), array('CATEGORY_ID'));
$people_categories_RET = DBGet(DBQuery("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"), array(), array('CATEGORY_ID'));
explodeCustom($address_categories_RET, $address_custom, 'a');
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 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()) . "<br />Powered by openSIS</td></tr><tr><td colspan=2 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 . UserSyear() . '/' . UserStudentID() . '.JPG', 'r')) || ($file = @fopen($picture_path = $StudentPicturesPath . (UserSyear() - 1) . '/' . 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=DBGet(DBQuery("SELECT s.CUSTOM_200000000 AS GENDER, s.CUSTOM_200000001 AS ETHNICITY, s.CUSTOM_200000002 AS COMMON_NAME, s.CUSTOM_200000003 AS SOCIAL_SEC_NO, s.CUSTOM_200000004 AS BIRTHDAY, s.CUSTOM_200000005 AS LANGUAGE, s.CUSTOM_200000006 AS PHYSICIAN_NAME, s.CUSTOM_200000007 AS PHYSICIAN_PHONO,s.custom_200000008 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 WHERE s.STUDENT_ID='".$_SESSION['student_id']."' AND s.STUDENT_ID=se.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
# ---------------- Sql Including Comment ------------------------------- #
#$sql=DBGet(DBQuery("SELECT s.CUSTOM_200000000 AS GENDER, s.CUSTOM_200000001 AS ETHNICITY, s.CUSTOM_200000002 AS COMMON_NAME, s.CUSTOM_200000003 AS SOCIAL_SEC_NO, s.CUSTOM_200000004 AS BIRTHDAY, s.CUSTOM_200000005 AS LANGUAGE, s.CUSTOM_200000006 AS PHYSICIAN_NAME, s.CUSTOM_200000007 AS PHYSICIAN_PHONO,s.custom_200000008 AS HOSPITAL,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING, smc.comment AS COMMENT FROM STUDENTS s, STUDENT_ENROLLMENT se,STUDENT_ENROLLMENT_CODES sec, STUDENT_MP_COMMENTS smc WHERE s.STUDENT_ID='".$_SESSION['student_id']."' AND s.STUDENT_ID=se.STUDENT_ID AND s.STUDENT_ID=smc.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
#$sql=DBGet(DBQuery("SELECT s.CUSTOM_200000000 AS GENDER, s.CUSTOM_200000001 AS ETHNICITY, s.CUSTOM_200000002 AS COMMON_NAME, s.CUSTOM_200000003 AS SOCIAL_SEC_NO, s.CUSTOM_200000004 AS BIRTHDAY, s.CUSTOM_200000005 AS LANGUAGE, s.CUSTOM_200000006 AS PHYSICIAN_NAME, s.CUSTOM_200000007 AS PHYSICIAN_PHONO,s.custom_200000008 AS HOSPITAL,s.custom_200000009 AS MCOMNT,s.custom_200000011 AS DNOTE,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING, smc.comment AS COMMENT FROM STUDENTS s, STUDENT_ENROLLMENT se,STUDENT_ENROLLMENT_CODES sec, STUDENT_MP_COMMENTS smc WHERE s.STUDENT_ID='".$_SESSION['student_id']."' AND s.STUDENT_ID=se.STUDENT_ID AND s.STUDENT_ID=smc.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
$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, s.physician AS PHYSICIAN_NAME, s.physician_phone AS PHYSICIAN_PHONO,s.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 WHERE s.STUDENT_ID='" . $_SESSION['student_id'] . "' AND s.STUDENT_ID=se.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
$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'] . "' "));示例5: PrintCatalog
//.........这里部分代码省略.........
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} >";示例6: unset
}
}
}
unset($_REQUEST['food_service']);
unset($_SESSION['_REQUEST_vars']['food_service']);
}
if ($_REQUEST['submit']['print']) {
$events_RET = DBGet(DBQuery("SELECT TITLE,DESCRIPTION,to_char(SCHOOL_DATE,'dd-MON-yy') AS SCHOOL_DATE FROM CALENDAR_EVENTS WHERE SCHOOL_DATE BETWEEN '" . date('d-M-y', $time) . "' AND '" . date('d-M-y', $time_last) . "' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND (TITLE='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' OR TITLE='No School')"), array(), array('SCHOOL_DATE'));
$skip = date("w", $time);
echo '<!-- MEDIA TOP 1in --><P><span class="center">';
echo '<TABLE style="border: solid 2px; background-color: #fff;" class="cellpadding-3">' . "\n";
if ($_REQUEST['_ROSARIO_PDF']) {
if (is_file('assets/dailymenu' . UserSchool() . '.jpg')) {
echo '<TR class="center"><TD colspan="7"><img src="assets/dailymenu' . UserSchool() . '.jpg"></TD></TR>' . "\n";
} else {
echo '<TR class="center"><TD colspan="7"><span style="color:black" class="sizep2"><b>' . GetSchool(UserSchool()) . '</b></span></TD></TR>' . "\n";
}
}
//modif Francois: display locale with strftime()
echo '<TR class="center"><TD colspan="2">' . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . '</TD><TD colspan="3"><span style="color:black" class="sizep2"><b>' . ProperDate(date('Y.m.d', mktime(0, 0, 0, $_REQUEST['month'], 1, $_REQUEST['year']))) . '</b></span></TD><TD colspan="2">' . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . '</TD></TR>' . "\n";
echo '<TR style="text-align:center; background-color:#808080">' . "\n";
echo '<TD style="width:100px;"><span style="color:white"><b>' . _('Sunday') . '</b></span></TD><TD style="width:100px;"><span style="color:white"><b>' . _('Monday') . '</b></span></TD><TD style="width:100px;"><span style="color:white"><b>' . _("Tuesday") . '</b></span></TD><TD style="width:100px;"><span style="color:white"><b>' . _("Wednesday") . '</b></span></TD><TD style="width:100px;"><span style="color:white"><b>' . _("Thursday") . '</b></span></TD><TD style="width:100px;"><span style="color:white"><b>' . _("Friday") . '</b></span></TD><TD style="width:100px;"><span style="color:white"><b>' . _("Saturday") . '</b></span></TD>' . "\n";
echo '</TR>';
if ($skip) {
echo '<TR style="height:100px;"><TD style="background-color:#C0C0C0;" colspan="' . $skip . '"> </TD>' . "\n";
}
for ($i = 1; $i <= $last; $i++) {
if ($skip % 7 == 0) {
echo '<TR style="height:0px;">';
}
$day_time = mktime(0, 0, 0, $_REQUEST['month'], $i, $_REQUEST['year']);示例7: UserSchool
$where = ' AND MARKING_PERIOD_ID=' . $_REQUEST['marking_period_id'];
}
$sql = 'select distinct
(select title from course_subjects where subject_id=(select subject_id from courses where course_id=course_periods.course_id)) as subject,
(select title from courses where course_id=course_periods.course_id) as COURSE_TITLE,course_id
from course_periods where school_id=\'' . UserSchool() . '\' and syear=\'' . UserSyear() . '\' ' . $where . ' order by subject,COURSE_TITLE';
$ret = DBGet(DBQuery($sql));
if (count($ret)) {
foreach ($ret as $s_id) {
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
$mark_name_rp = DBGet(DBQuery('SELECT TITLE,SHORT_NAME,\'2\' FROM school_quarters WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['marking_period_id'] . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' UNION SELECT TITLE,SHORT_NAME,\'1\' FROM school_semesters WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['marking_period_id'] . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' UNION SELECT TITLE,SHORT_NAME,\'0\' FROM school_years WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['marking_period_id'] . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY 3'));
$mark_name_rpt = $mark_name_rp[1]['TITLE'];
if ($mark_name_rpt != '') {
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Course catalog by Term: " . $mark_name_rpt . "</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>";
} else {
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Course catalog by Term: All</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 '<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>';
if (!$_REQUEST['marking_period_id']) {
$sql_periods = 'SELECT cp.SHORT_NAME,(SELECT TITLE FROM school_periods WHERE period_id=cpv.period_id) AS PERIOD,r.TITLE as ROOM,cpv.DAYS,(SELECT CONCAT(LAST_NAME,\' \',FIRST_NAME,\' \') from staff where staff_id=cp.TEACHER_ID) as TEACHER from course_periods cp,course_period_var cpv,rooms r where cp.course_id=' . $s_id['COURSE_ID'] . ' and cp.syear=\'' . UserSyear() . '\' and cp.course_period_id=cpv.course_period_id and cpv.room_id=r.room_id and cp.school_id=\'' . UserSchool() . '\'';
} else {
$sql_periods = 'SELECT distinct cp.SHORT_NAME,(select CONCAT(START_TIME,\' - \',END_TIME,\' \') from school_periods where period_id=cpv.period_id) as PERIOD,r.TITLE as ROOM,cpv.DAYS,(select CONCAT(LAST_NAME,\' \',FIRST_NAME,\' \') from staff where staff_id=cp.TEACHER_ID) as TEACHER from course_periods cp,course_period_var cpv,rooms r where cp.course_id=' . $s_id['COURSE_ID'] . ' and cp.syear=\'' . UserSyear() . '\' and cp.course_period_id=cpv.course_period_id and cpv.room_id=r.room_id and cp.school_id=\'' . UserSchool() . '\' and cp.marking_period_id=\'' . $_REQUEST['marking_period_id'] . '\'';
}
$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>';示例8: date
$gd['DURATION'] = date("g:i A", strtotime($time[0])) . ' to ' . date("g:i A", strtotime($time[1]));
unset($time);
$temp_duration[$gd['DURATION']] = $gd['DURATION'];
$temp_room[$gd['ROOM']] = $gd['ROOM'];
}
$RET[$ri][$rdi]['DAYS'] = _makeDays(implode('', $temp_days));
$RET[$ri][$rdi]['DURATION'] = implode(',', $temp_duration);
$RET[$ri][$rdi]['ROOM'] = implode(',', $temp_room);
}
}
}
if (count($RET)) {
$handle = PDFStart();
foreach ($RET as $student_id => $courses) {
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Student Schedules 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>";
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>' . $courses[1]['FULL_NAME'] . '</td></tr>';
echo '<tr><td>Student Grade:</td>';
echo '<td>' . $courses[1]['GRADE_ID'] . '</td></tr>';
if ($_REQUEST['mailing_labels'] == 'Y') {
$mail_address = DBGet(DBQuery('SELECT STREET_ADDRESS_1,STREET_ADDRESS_2,CITY,STATE,ZIPCODE FROM student_address WHERE TYPE=\'Mail\' AND STUDENT_ID=' . $courses[1]['STUDENT_ID']));
$mail_address = $mail_address[1]['STREET_ADDRESS_1'] . ($mail_address[1]['STREET_ADDRESS_2'] != '' ? ' ' . $mail_address[1]['STREET_ADDRESS_2'] : ' ') . '<br>' . $mail_address[1]['CITY'] . ', ' . $mail_address[1]['STATE'] . ' ' . $mail_address[1]['ZIPCODE'];
echo '<tr><td>Malling Details:</td>';
echo '<td>' . ($mail_address != '' ? $mail_address : 'N/A') . '</td></tr>';
}示例9: array
<?php
$tables = array('SCHOOL_PERIODS' => _('School Periods'), 'SCHOOL_MARKING_PERIODS' => _('Marking Periods'), 'REPORT_CARD_GRADES' => _('Report Card Grade Codes'), 'REPORT_CARD_COMMENTS' => _('Report Card Comment Codes'), 'ELIGIBILITY_ACTIVITIES' => _('Eligibility Activity Codes'), 'ATTENDANCE_CODES' => _('Attendance Codes'), 'SCHOOL_GRADELEVELS' => _('Grade Levels'));
$table_list = '<TABLE align=left>';
foreach ($tables as $table => $name) {
$table_list .= '<TR><TD><INPUT type=checkbox value=Y name=tables[' . $table . '] CHECKED></TD><TD>' . $name . '</TD></TR>';
}
$table_list .= '</TABLE></CENTER><BR><small>' . _('New School\'s Title') . '</small> <INPUT type=text name=title value="' . _('New School') . '"><CENTER>';
DrawHeader(ProgramTitle());
if (Prompt(_('Confirm Copy School'), sprintf(_('Are you sure you want to copy the data for %s to a new school?'), GetSchool(UserSchool())), $table_list)) {
if (count($_REQUEST['tables'])) {
$id = DBGet(DBQuery("SELECT " . db_seq_nextval('SCHOOLS_SEQ') . " AS ID" . FROM_DUAL));
$id = $id[1]['ID'];
DBQuery("INSERT INTO SCHOOLS (ID,SYEAR,TITLE) values('{$id}','" . UserSyear() . "','" . str_replace("\\'", "''", $_REQUEST['title']) . "')");
DBQuery("UPDATE STAFF SET SCHOOLS=rtrim(SCHOOLS,',')||',{$id},' WHERE STAFF_ID='" . User('STAFF_ID') . "' AND SCHOOLS IS NOT NULL");
foreach ($_REQUEST['tables'] as $table => $value) {
_rollover($table);
}
}
echo '<FORM action=Modules.php?modname=' . $_REQUEST['modname'] . ' method=POST>';
echo '<script language=JavaScript>parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
DrawHeader('<IMG SRC=assets/check.gif>' . sprintf(_('The data have been copied to a new school called "%s".'), $_REQUEST['title']), '<INPUT type=submit value="' . _('OK') . '>"');
echo '</FORM>';
unset($_SESSION['_REQUEST_vars']['tables']);
unset($_SESSION['_REQUEST_vars']['delete_ok']);
}
function _rollover($table)
{
global $id;
switch ($table) {
case 'SCHOOL_PERIODS':示例10: cov_date
if ($row_mp_detail['grandparent_id'] != -1) {
$mp_string .= ' or s.marking_period_id=' . $row_mp_detail[1]['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 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()) . "</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) {示例11: array
$extra['SELECT'] .= ',r.' . $column;
}
$extra['FROM'] .= ',DISCIPLINE_REFERRALS r ';
$extra['WHERE'] .= " AND r.STUDENT_ID=ssm.STUDENT_ID AND r.SYEAR=ssm.SYEAR ";
if (strpos($extra['FROM'], 'DISCIPLINE_REFERRALS dr') !== false) {
$extra['WHERE'] .= ' AND r.ID=dr.ID';
}
$extra['group'] = array('STUDENT_ID');
$extra['ORDER'] = ',r.ENTRY_DATE';
$RET = GetStuList($extra);
if (count($RET)) {
foreach ($RET as $student_id => $referrals) {
unset($_FOCUS['DrawHeader']);
DrawHeader(Config('TITLE') . ' ' . _('Discipline Log'));
DrawHeader($referrals[1]['FULL_NAME'], $referrals[1]['STUDENT_ID']);
DrawHeader(GetSchool(UserSchool()), $courses[1]['GRADE_ID']);
if ($start_date && $end_date) {
DrawHeader(ProperDate($start_date) . ' - ' . ProperDate($end_date));
} else {
DrawHeader(_('School Year') . ': ' . UserSyear() . ' - ' . (UserSyear() + 1));
}
echo '<BR>';
foreach ($referrals as $referral) {
echo '<TABLE cellpadding=5><TR>';
if ($_REQUEST['elements']['ENTRY_DATE']) {
echo '<TD><small><font color=gray>' . _('Date') . ': </font></small><b>' . ProperDate($referral['ENTRY_DATE']) . '</b></TD>';
}
if ($_REQUEST['elements']['STAFF_ID']) {
echo '<TD><small><font color=gray>' . _('Reporter') . ': </font></small><b>' . GetTeacher($referral['STAFF_ID']) . '</b></TD>';
}
$end_tr = false;示例12: UserSchool
$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>";
}示例13: db_seq_nextval
$_REQUEST['syear'] = $defined[SYEAR];
$_REQUEST['title'] = $defined[TITLE];
$_REQUEST['account_id'] = $defined[ACCOUNT_ID];
$_REQUEST['amount'] = $defined[AMOUNT];
$_REQUEST['date'] = $defined[DUE_DATE];
}
$sql = "INSERT INTO STU_BILLING_FEES \n\t\t\t\t\t(ID,GLOBAL_ID,ACCOUNT_ID,STUDENT_ID,TITLE,AMOUNT,EFFECTIVE_DATE,DUE_DATE,SYEAR,SCHOOL,GRADE) \n\t\t\t\t\t(SELECT " . db_seq_nextval('STU_BILLING_FEES_SEQ') . "," . $global_id[1][GLOBAL_ID] . ",'" . $_REQUEST['account_id'] . "',ssm.STUDENT_ID,\n\t\t\t\t\t\t'" . $_REQUEST['title'] . "','" . $_REQUEST['amount'] . "','{$effective_date}',\n\t\t\t\t\t\t'" . $_REQUEST['date'] . "','" . $_REQUEST['syear'] . "',\n\t\t\t\t\t\t'" . $_REQUEST['school'] . "','" . $_REQUEST['grade'] . "'\n\t\t\t\t\tFROM STU_SCHOOL_MEETS ssm \n\t\t\t\t\tWHERE\n\t\t\t\t\t\tssm.SYEAR='{$_REQUEST['syear']}' AND ssm.ACTIVE='A' ";
if ($_REQUEST[grade]) {
$sql .= "AND ssm.GRADE='{$_REQUEST['grade']}' ";
}
if ($_REQUEST[school]) {
$sql .= "AND ssm.SCHOOL='{$_REQUEST['school']}' ";
}
$sql .= ')';
DBQuery($sql);
$note[] = 'The Student Billing Fee ' . $title . ' has been Applied to all students ' . ($_REQUEST[grade] ? 'in ' . GetGrade($_REQUEST[grade]) : '') . ' ' . ($_REQUEST[school] ? 'at ' . GetSchool($_REQUEST[school]) : '');
unset($_REQUEST[modfunc]);
}
}
if ($_REQUEST[modfunc] == 'delete') {
if (DeletePrompt('fee for all applicable students')) {
DBQuery("DELETE FROM STU_BILLING_FEES WHERE GLOBAL_ID={$_REQUEST['id']}");
$note[] = "That Fee has been Deleted for All Applicable Students";
unset($_REQUEST[modfunc]);
}
}
if (!$_REQUEST[modfunc]) {
// LIST
if ($note) {
echo '<TABLE width=100%><TR><TD bgcolor=#E8E8E9><font size=-1>';
ErrorMessage($note, 'note');示例14: DBQuery
} else {
DBQuery("UPDATE TEMPLATES SET TEMPLATE = '" . $REQUEST_letter_text . "' WHERE MODNAME = '" . $_REQUEST['modname'] . "' AND STAFF_ID = '" . User('STAFF_ID') . "'");
}
$REQUEST_letter_text = nl2br(str_replace("''", "'", str_replace(' ', ' ', $REQUEST_letter_text)));
$css = true;
$handle = PDFStart($css);
foreach ($RET as $student) {
$student_points = $total_points = 0;
unset($_ROSARIO['DrawHeader']);
if ($_REQUEST['mailing_labels'] == 'Y') {
echo '<BR /><BR /><BR />';
}
//DrawHeader(ParseMLField(Config('TITLE')).' Letter');
DrawHeader(' ');
DrawHeader($student['FULL_NAME'], $student['STUDENT_ID']);
DrawHeader($student['GRADE_ID'], GetSchool(UserSchool()));
//DrawHeader('',GetMP(GetCurrentMP('QTR',DBDate(),false)));
DrawHeader(ProperDate(DBDate()));
if ($_REQUEST['mailing_labels'] == 'Y') {
echo '<BR /><BR /><TABLE class="width-100p"><TR><TD style="width:50px;"> </TD><TD>' . $student['MAILING_LABEL'] . '</TD></TR></TABLE><BR />';
}
$letter_text = $REQUEST_letter_text;
foreach ($student as $column => $value) {
$letter_text = str_replace('__' . $column . '__', $value, $letter_text);
}
echo '<BR />' . $letter_text;
echo '<div style="page-break-after: always;"></div>';
}
PDFStop($handle);
} else {
BackPrompt(_('No Students were found.'));示例15: strip_tags
echo '
<SCRIPT language="JavaScript">
window.location="Side.php?school_id=new&modcat=' . strip_tags(trim($_REQUEST['modcat'])) . '";
</SCRIPT>
';
}
}
}
if (clean_param($_REQUEST['copy'], PARAM_ALPHAMOD) == 'done') {
echo '<br><strong>School has been created successfully.</strong>';
} else {
if (!$_REQUEST['modfunc']) {
if (!$_REQUEST['new_school']) {
$schooldata = DBGet(DBQuery('SELECT * FROM schools WHERE ID=\'' . UserSchool() . '\''));
$schooldata = $schooldata[1];
$school_name = GetSchool(UserSchool());
} else {
$school_name = 'Add a School';
}
echo "<FORM name=school id=school enctype='multipart/form-data' METHOD='POST' ACTION='Modules.php?modname=" . strip_tags(trim($_REQUEST['modname'])) . "&modfunc=update&btn=" . $_REQUEST['button'] . "&new_school={$_REQUEST['new_school']}'>";
PopTable_wo_header('header');
echo "<table border=0 align=center><tr><td>";
echo "<TABLE align=center>";
echo "<TR><TD class='label'><b>School Name:<font color=red>*</font></b></td><td>" . TextInput($schooldata['TITLE'], 'values[TITLE]', '', 'class=cell_floating size=24 onKeyUp=checkDuplicateName(1,this,' . $schooldata['ID'] . '); onBlur=checkDuplicateName(1,this,' . $schooldata['ID'] . ');') . "</td></TR>";
echo "<input type=hidden id=checkDuplicateNameTable1 value='schools'/>";
echo "<input type=hidden id=checkDuplicateNameField1 value='title'/>";
echo "<input type=hidden id=checkDuplicateNameMsg1 value='school name'/>";
echo "<TR ALIGN=LEFT><TD class='label'><b>Address:<font color=red>*</font></b></TD><td>" . TextInput($schooldata['ADDRESS'], 'values[ADDRESS]', '', 'class=cell_floating maxlength=100 size=24') . "</td></TR>";
echo "<TR ALIGN=LEFT><TD class='label'><b>City:<font color=red>*</font></b></TD><td>" . TextInput($schooldata['CITY'], 'values[CITY]', '', 'maxlength=100, class=cell_floating size=24') . "</td></TR>";
echo "<TR ALIGN=LEFT><TD class='label'><b>State:<font color=red>*</font></b></TD><td>" . TextInput($schooldata['STATE'], 'values[STATE]', '', 'maxlength=10 class=cell_floating size=24') . "</td></TR>";
echo "<TR ALIGN=LEFT><TD class='label'><b>Zip/Postal Code:<font color=red>*</font></b></TD><td>" . TextInput($schooldata['ZIPCODE'], 'values[ZIPCODE]', '', 'maxlength=10 class=cell_floating size=24') . "</td></TR>";