/**
* 按考试名称，对成绩进行汇总
* 学生学号，科目。。。，总分，年级排名，年级进退
*/
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');
