2 define('AT_INCLUDE_PATH', '../../include/');
3 require (AT_INCLUDE_PATH.'vitals.inc.php');
4 authenticate(AT_PRIV_CERTIFY);
6 require 'certify_functions.php';
9 $_custom_css = $_base_path . 'mods/certify/certify.css'; // use a custom stylesheet
11 $GLOBALS['dout'] = '';
14 $GLOBALS['dout'] .= $out . "\n";
18 if (isset($_POST['certify_id'])) {
19 $certify_id = $addslashes($_POST['certify_id']);
20 } else if (isset($_GET['certify_id'])) {
21 $certify_id = $addslashes($_GET['certify_id']);
28 SELECT '.TABLE_PREFIX.'members.*
29 FROM '.TABLE_PREFIX.'course_enrollment
30 INNER JOIN '.TABLE_PREFIX.'members ON '.TABLE_PREFIX.'members.member_id = '.TABLE_PREFIX.'course_enrollment.member_id
31 WHERE '.TABLE_PREFIX.'course_enrollment.course_id = '.$_SESSION['course_id'].'
35 $result = mysql_query($sql, $db) or die(mysql_error());
40 while( $member = mysql_fetch_assoc($result) ) {
41 $member['certificate'] = array();
42 $member['certificate']['progress'] = getCertificateProgress($member['member_id'],$certify_id);
43 $members[$member['member_id']] = $member;
47 function membercmp($a,$b) {
49 if ($a['certificate']['progress'] == $b['certificate']['progress'])
52 return ($a['certificate']['progress'] > $b['certificate']['progress']) ? -1 : 1;
56 usort($members, "membercmp");
58 // -- Certificate update code end --
60 dbug(var_export($members,true));
63 require (AT_INCLUDE_PATH.'header.inc.php');
71 <?php //echo $GLOBALS['dout']; ?>
81 <table class="data" summary="" rules="cols">
84 <!--th align="left"> </th-->
85 <th scope="col"><?php echo _AT('login_name'); ?></th>
86 <th scope="col"><?php echo _AT('full_name'); ?></th>
87 <th scope="col"><?php echo _AT('mark'); ?></th>
92 <td colspan="4"><input type="submit" name="edit" value="Should there be a button here for viewing individual tests?" /></td>
96 <?php if ($members): ?>
97 <?php foreach ($members as &$member): ?>
100 <td><?php echo $member['login']; ?></td>
102 if ($anonymous == 0 && $member['member_id']){
103 echo AT_print(get_display_name($member['member_id']), 'members.full_name'); /*$member['full_name'] */
105 echo $guest_text; // no need in AT_print(): $guest_text is a trusted _AT() output
111 <div class="certify_bar-border">
112 <div class="certify_bar-fill">
113 <div class="certify_bar-bar" style="width: <?php echo floor($member['certificate']['progress']); ?>%;">
114 <span class="test_<?php echo $member['certificate']['progress'] == 100 ? 'passed' : 'failed' ?>" >
115 <?php echo floor($member['certificate']['progress']); ?>%
128 <td colspan="3"><?php echo _AT('none_found'); ?></td>
140 <?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>