/** * 按考试名称,对成绩进行汇总 * 学生学号,科目。。。,总分,年级排名,年级进退 */ function scoreStatistics($class_code, $prj_id) { //获取考试科目 $subjects = get_subjects($class_code, $prj_id); if (count($subjects) < 1) { return array(); } //获取考试成绩 $sql = "select * FROM " . $GLOBALS['ecs']->table("score") . " WHERE class_code='" . $class_code . "' AND prj_id='" . $prj_id . "' AND student_code='" . $_SESSION['student_code'] . "' "; $scores = $GLOBALS['db']->getAll($sql); //获取年级排名 $sql = "select * FROM " . $GLOBALS['ecs']->table("grade_rank") . " WHERE class_code='" . $class_code . "' AND prj_id='" . $prj_id . "' AND student_code='" . $_SESSION['student_code'] . "' "; $grade_rank = $GLOBALS['db']->getRow($sql); //获取学生 $s = get_student($class_code, $_SESSION['student_code']); $res = array(); //学生学号,科目。。。,总分,年级排名,年级进退 $res[$s['code']]['student_code'] = $s['code']; $res[$s['code']]['student_name'] = $s['name']; $total = 0; foreach ($subjects as $subject) { $hasScore = false; foreach ($scores as $score) { if ($score['subject'] == $subject['subject']) { $res[$s['code']][$score['subject']] = $score['score']; //科目=》成绩 $total += $score['score']; $hasScore = true; break; } } if (!$hasScore) { $res[$s['code']][$subject["subject"]] = ''; //科目=》成绩 } } $res[$s['code']]['total'] = $total; //总分 $res[$s['code']]['grade_rank'] = $grade_rank['grade_rank']; //年级排名 $res[$s['code']]['up_down'] = $grade_rank['up_down']; //年级进退 // print_r($res); return $res; }
exit('No direct script access allowed'); } /** * Edit Student Program * * @license GPLv3 * * @since 3.0.0 * @package eduTrac SIS * @author Joshua Parker <*****@*****.**> */ $app = \Liten\Liten::getInstance(); $app->view->extend('_layouts/dashboard'); $app->view->block('dashboard'); $flash = new \app\src\Core\etsis_Messages(); $stu = get_student(_h($sacp[0]['stuID'])); ?> <script type="text/javascript"> function addMsg(text,element_id) { document.getElementById(element_id).value += text; } $(".panel").show(); setTimeout(function() { $(".panel").hide(); }, 10000); </script> <ul class="breadcrumb"> <li><?php echo _t('You are here'); ?> </li>
* SPRO Record View * * This view is used when viewing a student record via * the SPRO screen. * * @license GPLv3 * * @since 3.0.0 * @package eduTrac SIS * @author Joshua Parker <*****@*****.**> */ $app = \Liten\Liten::getInstance(); $app->view->extend('_layouts/dashboard'); $app->view->block('dashboard'); $flash = new \app\src\Core\etsis_Messages(); $stu = get_student(_h($prog[0]['stuID'])); $list = '"' . implode('","', tagList()) . '"'; ?> <script type="text/javascript"> $(function() { <?php if (strlen($list) >= 3) { ?> $("#select2_5").select2({tags:[<?php echo $list; ?> ]}); <?php } else { ?>
if (!defined('BASE_PATH')) { exit('No direct script access allowed'); } /** * myeduTrac Student Schedule View * * @license GPLv3 * * @since 4.3 * @package eduTrac SIS * @author Joshua Parker <*****@*****.**> */ $app = \Liten\Liten::getInstance(); $app->view->extend('_layouts/myet/' . _h(get_option('myet_layout')) . '.layout'); $app->view->block('myet'); $stu = get_student(get_persondata('personID')); ?> <div class="col-md-12"> <?php get_stu_header($stu->stuID); ?> <div class="separator line bottom"></div> <h3 class="glyphicons calendar"><i></i><?php echo _h($schedule[0]['termCode']); ?> <?php echo _t('Schedule');
<?php include '../view/header.php'; require_once '../model/database.php'; require_once '../model/students_db.php'; $results = get_student(); ?> <div class=""> <ul class="breadcrumb"> <li><a href="index.php">Home</a> <span class="divider">/</span></li> <li class="active">Students</li> </ul> <table class="table table-condensed table-bordered table-striped"> <tr> <th>Student ID</th> <th>First Name</th> <th>Last Name</th> <th>Parent ID</th> </tr> <?php foreach ($results as $student) { ?> <tr> <td><?php echo $student['student_id']; ?> </td> <td><?php echo $student['fname'];
<?php define('IN_ECS', true); require dirname(__FILE__) . '/includes/init.php'; if ($_REQUEST['act'] == 'list') { $student = get_student($class_code, $_SESSION["student_code"]); $smarty->assign("student", $student); $smarty->display('student_list.htm'); exit; } if ($_REQUEST['act'] == 'ajax_list') { $list = student_list(); make_json($list); } elseif ($_REQUEST['act'] == 'ajax_save') { $id = !empty($_REQUEST['student_id']) ? intval($_REQUEST['student_id']) : 0; // print_r($_REQUEST); if ($id > 0) { //insert $sql = "update " . $ecs->table("student") . " set sexuality='" . $_REQUEST["sexuality"] . "',\r\n\t\t\tbirthday='" . $_REQUEST["birthday"] . "',\r\n\t\t\tnational='" . $_REQUEST["national"] . "',\r\n\t\t\tid_card='" . $_REQUEST["id_card"] . "',\r\n\t\t\tphone='" . $_REQUEST["phone"] . "',\r\n\t\t\tqq='" . $_REQUEST["qq"] . "',\r\n\t\t\tdorm='" . $_REQUEST["dorm"] . "',\r\n\t\t\temail='" . $_REQUEST["email"] . "',\r\n\t\t\taddress='" . $_REQUEST["address"] . "',\r\n\t\t\tguardian_relation='" . $_REQUEST["guardian_relation"] . "'\r\n\t\t\twhere student_id=" . $id; $db->query($sql); admin_log(addslashes($class_code . "," . $_SESSION["student_code"]), 'update', $sql); make_json_result("修改个人信息成功!"); } } elseif ($_REQUEST['act'] == 'export') { $list = student_list(); $content = "序号,学号,姓名,性别,出生年月,民族,身份证,电话,邮箱,住址,是否已离校,家长,家长电话,与家长关系,创建日期\n"; foreach ($list["rows"] as $k => $v) { $sexuality = $v["sexuality"] == 1 ? "男" : "女"; $has_left = $v["has_left"] == 1 ? "是" : "否"; $content .= $v["student_id"] . ",'" . $v["code"] . "'," . $v["name"] . "," . $sexuality . "," . $v["birthday"] . "," . $v["national"] . ",'" . $v["id_card"] . "','" . $v["phone"] . "'," . $v["email"] . "," . $v["address"] . "," . $has_left . "," . $v["guardian_name"] . ",'" . $v["guardian_phone"] . "'," . $v["guardian_relation"] . "," . $v["created"] . "\n"; }
$score = $_POST['score']; $_DB->sql_query("SELECT * FROM grades WHERE gradeAssignment='{$assignment}' AND gradeUser='******'"); if ($row = $_DB->sql_fetchrow()) { $gradeID = $row['gradeID']; } else { $_DB->sql_query("INSERT INTO grades (gradeUser, gradeAssignment) VALUES ('{$student}', '{$assignment}');"); $_DB->sql_query("SELECT * FROM grades WHERE gradeAssignment='{$assignment}' AND gradeUser='******'"); $row = $_DB->sql_fetchrow(); $gradeID = $row['gradeID']; } $_DB->sql_query("UPDATE grades SET gradeScore = '{$score}' WHERE gradeAssignment='{$assignment}' AND gradeUser='******'"); } } if (isset($student)) { set_student_template($_DB, $tpl, $course, $student); $stud = get_student($_DB, $student); $tpl->assignGlobal('student', $stud['userName']); $tpl->assignGlobal('student_select_box', gen_student_select_box($_DB, $course)); $tpl->assignGlobal('course_id', $course); } else { if (isset($course)) { set_course_template($_DB, $tpl, $course); $tpl->assignGlobal('student_select_box', gen_student_select_box($_DB, $course)); $tpl->assignGlobal('course_id', $course); } } // add the remaining components to the template $tpl->assignGlobal('course_select_box', gen_course_select_box($_DB)); $tpl->assignGlobal('username', $_SESSION['userName']); } // for all of the pages, put the content into the main template
function get_stu_header($stu_id) { $student = get_student($stu_id); ?> <!-- List Widget --> <div class="relativeWrap"> <div class="widget"> <div class="widget-head"> <h4 class="heading glyphicons user"><i></i><?php echo get_name(_h($student->stuID)); ?> </h4> <?php if (!isset($_COOKIE['SWITCH_USERBACK']) && _h($student->stuID) != get_persondata('personID')) { ?> <span<?php echo ae('login_as_user'); ?> class="label label-inverse"><a href="<?php echo get_base_url(); ?> switchUserTo/<?php echo _h($student->stuID); ?> /"><font color="#FFFFFF"><?php echo _t('Switch To'); ?> </font></a></span> <?php } ?> <?php if (get_persondata('personID') == $student->stuID && !hasPermission('access_dashboard')) { ?> <a href="<?php echo get_base_url(); ?> profile/" class="heading pull-right"><?php echo _h($student->stuID); ?> </a> <?php } else { ?> <a href="<?php echo get_base_url(); ?> stu/<?php echo _h($student->stuID); ?> /" class="heading pull-right"><?php echo _h($student->stuID); ?> </a> <?php } ?> </div> <div class="widget-body"> <!-- 4 Column Grid / One Third --> <div class="row"> <!-- One Fifth's Column --> <div class="col-md-2"> <?php echo getSchoolPhoto($student->stuID, $student->email1, '90'); ?> </div> <!-- // One Fifth's Column END --> <!-- Two Fifth's Column --> <div class="col-md-2"> <p><?php echo _h($student->address1); ?> <?php echo _h($student->address2); ?> </p> <p><?php echo _h($student->city); ?> <?php echo _h($student->state); ?> <?php echo _h($student->zip); ?> </p> <p><strong><?php echo _t('Phone:'); ?> </strong> <?php echo _h($student->phone1); ?> </p> </div> <!-- // Two Fifth's Column END --> <!-- Three Fifth's Column --> <div class="col-md-2"> <p><strong><?php echo _t('Email:'); ?> </strong> <a href="mailto:<?php echo _h($student->email1); ?> "><?php echo _h($student->email1); ?> </a></p> <p><strong><?php echo _t('Birth Date:'); ?> </strong> <?php echo _h($student->dob) > '0000-00-00' ? date('D, M d, o', strtotime(_h($student->dob))) : ''; ?> </p> <p><strong><?php echo _t('Status:'); ?> </strong> <?php echo _h($student->stuStatus) == 'A' ? _t('Active') : _t('Inactive'); ?> </p> </div> <!-- // Three Fifth's Column END --> <!-- Four Fifth's Column --> <div class="col-md-2"> <p><strong><?php echo _t('FERPA:'); ?> </strong> <?php echo is_ferpa(_h($student->stuID)); ?> <?php if (is_ferpa(_h($student->stuID)) == 'Yes') { ?> <a href="#FERPA" data-toggle="modal"><img style="vertical-align:top !important;" src="<?php echo get_base_url(); ?> static/common/theme/images/exclamation.png" /></a> <?php } else { ?> <a href="#FERPA" data-toggle="modal"><img style="vertical-align:top !important;" src="<?php echo get_base_url(); ?> static/common/theme/images/information.png" /></a> <?php } ?> </p> <p><strong><?php echo _t('Restriction(s):'); ?> </strong> <?php $rstr = ''; foreach (get_stu_restriction($student->stuID) as $v) { ?> <?php echo $rstr; ?> <span data-toggle="popover" data-title="<?php echo _h($v['description']); ?> " data-content="Contact: <?php echo _h($v['deptName']); ?> <?php echo _h($v['deptEmail']) != '' ? ' | ' . $v['deptEmail'] : ''; echo _h($v['deptPhone']) != '' ? ' | ' . $v['deptPhone'] : ''; echo _h($v['severity']) == 99 ? _t(' | Restricted from registering for courses.') : ''; ?> " data-placement="bottom"><a href="#"><?php echo _h($v['Restriction']); ?> </a></span> <?php $rstr = ', '; } ?> </p> <p><strong><?php echo _t('Entry Date:'); ?> </strong> <?php echo date('D, M d, o', strtotime(_h($student->stuAddDate))); ?> </p> </div> <!-- // Four Fifth's Column END --> <!-- Five Fifth's Column --> <div class="col-md-2"> <p><strong><?php echo _t('SACP:'); ?> </strong> <?php $sacp = ''; foreach (get_sacp($student->stuID) as $v) { ?> <?php echo $sacp; ?> <span data-toggle="popover" data-title="<?php echo _h($v['acadProgTitle']); ?> (<?php echo _h($v['currStatus']) == 'A' ? _t('Active') : _t('Graduated'); ?> )" data-content="<?php echo _h($v['programDesc']); ?> " data-placement="bottom"><a href="#"><?php echo _h($v['SACP']); ?> </a></span> <?php $sacp = ', '; } ?> </p> <p><strong><?php echo _t('Admit Status:'); ?> </strong> </p> <p><strong><?php echo _t('Hiatus:'); ?> </strong> <span data-toggle="popover" data-title="<?php echo get_shis_name(get_stu_shis(_h($student->stuID), 'shisCode')); ?> " data-content="Start Date: <?php echo get_stu_shis(_h($student->stuID), 'startDate'); ?> | End Date: <?php echo get_stu_shis(_h($student->stuID), 'endDate') <= '0000-00-00' ? '' : get_stu_shis(_h($student->stuID), 'endDate'); ?> " data-placement="bottom"><a href="#"><?php echo get_stu_shis(_h($student->stuID), 'shisCode'); ?> </a></span> </p> </div> <!-- // Five Fifth's Column END --> </div> <!-- // 4 Column Grid / One Third END --> </div> </div> </div> <!-- // List Widget END --> <!-- Modal --> <div class="modal fade" id="FERPA"> <div class="modal-dialog"> <div class="modal-content"> <!-- Modal heading --> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 class="modal-title"><?php echo _t('Family Educational Rights and Privacy Act (FERPA)'); ?> </h3> </div> <!-- // Modal heading END --> <!-- Modal body --> <div class="modal-body"> <p><?php echo _t('"FERPA gives parents certain rights with respect to their children\'s education records. These rights transfer to the student when he or she reaches the age of 18 or attends a school beyond the high school level. Students to whom the rights have transferred are \'eligible students.\'"'); ?> </p> <p><?php echo _t('If the FERPA restriction states "Yes", then the student has requested that none of their information be given out without their permission. To get a better understanding of FERPA, visit the U.S. DOE\'s website @ ') . '<a href="http://www2.ed.gov/policy/gen/guid/fpco/ferpa/index.html">http://www2.ed.gov/policy/gen/guid/fpco/ferpa/index.html</a>.'; ?> </p> </div> <!-- // Modal body END --> <!-- Modal footer --> <div class="modal-footer"> <a href="#" class="btn btn-default" data-dismiss="modal"><?php echo _t('Close'); ?> </a> </div> <!-- // Modal footer END --> </div> </div> </div> <!-- // Modal END --> <?php }
<br /> <div align="center"> <table border="0" cellspacing="0" cellpadding="0" class="table_menu" style="width:200px"> <tr> <td><img src="images/circle_left_top.gif" alt="" width="6" height="6"></td> <td valign="top" class="border_top"><img src="images/border.gif" alt="" width="1" height="1"></td> <td><img src="images/circle_right_top.gif" alt="" width="6" height="6"></td> </tr> <tr> <td class="border_left"> </td> <td class="padding"><table> <tr> <td nowrap="nowrap"> <a href="index.php">Просмотр оценок</a> </td> <td align="center"><img src="../images/dec.png" alt="" width="1" height="51"></td> <td> <a href="index.php?action=logout">Выход</a> </td> </tr> </table></td> <td class="border_right"> </td> </tr> <tr> <td><img src="images/circle_left_bottom.gif" alt="" width="6" height="6"></td> <td width="99%" valign="bottom" class="border_bottom"><img src="images/border.gif" alt="" width="1" height="1"></td> <td><img src="images/circle_right_bottom.gif" alt="" width="6" height="6"></td> </tr> </table> </div> <?php $student = get_student($_SESSION['student_id']); echo "{$student['last_name']} {$student['first_name']} {$student['middle_name']}<br />"; }
if (!defined('BASE_PATH')) { exit('No direct script access allowed'); } /** * Student Terms Summary View * * @license GPLv3 * * @since 4.4 * @package eduTrac SIS * @author Joshua Parker <*****@*****.**> */ $app = \Liten\Liten::getInstance(); $app->view->extend('_layouts/dashboard'); $app->view->block('dashboard'); $stu = get_student(_h($stu)); ?> <ul class="breadcrumb"> <li><?php echo _t('You are here'); ?> </li> <li><a href="<?php echo get_base_url(); ?> dashboard/<?php echo bm(); ?> " class="glyphicons dashboard"><i></i> <?php echo _t('Dashboard');