本文整理匯總了PHP中DrawLogo函數的典型用法代碼示例。如果您正苦於以下問題：PHP DrawLogo函數的具體用法？PHP DrawLogo怎麽用？PHP DrawLogo使用的例子？那麽, 這裏精選的函數代碼示例或許可以為您提供幫助。
在下文中一共展示了DrawLogo函數的11個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: 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>';示例2: UserCoursePeriod
}
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 :') . '';示例3: DrawLogo
} 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';示例4: 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} >";示例5: foreach
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}";示例6: Widgets
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% >";示例7: foreach
}
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']) {示例8: cov_date
$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) {示例9: 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>";
}示例10: cov_date
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} )"));示例11: DBGet
// 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>';