2 define('AT_INCLUDE_PATH', '../../include/');
3 require (AT_INCLUDE_PATH.'vitals.inc.php');
4 admin_authenticate(AT_ADMIN_PRIV_ECOMM);
6 function is_enrolled($member_id, $course_id) {
8 $sql = "SELECT approved FROM ".TABLE_PREFIX."course_enrollment WHERE course_id=$course_id AND member_id=$member_id AND approved<>'n'";
9 $result = mysql_query($sql, $db);
10 return (boolean) mysql_fetch_assoc($result);
13 $sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."payments";
14 //$sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."course_enrollment";
15 $result = mysql_query($sql, $db);
16 if (($row = mysql_fetch_assoc($result)) && $row['cnt']) {
17 $num_results = $row['cnt'];
19 require(AT_INCLUDE_PATH.'header.inc.php');
20 $msg->printInfos('EC_NO_STUDENTS_ENROLLED');
21 require(AT_INCLUDE_PATH.'footer.inc.php');
25 $results_per_page = 25;
26 $num_pages = max(ceil($num_results / $results_per_page), 1);
27 $page = abs($_GET['p']);
33 $count = (($page-1) * $results_per_page) + 1;
34 $offset = ($page-1)*$results_per_page;
36 // enroll/unenroll students
38 if($_GET['func'] == 'enroll'){
39 $_GET['func'] = $addslashes($_GET['func']);
40 $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'y' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";
41 $result = mysql_query($sql,$db);
42 }else if($_GET['func'] == 'unenroll'){
44 $_GET['func'] = $addslashes($_GET['func']);
45 $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'n' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";
46 $result = mysql_query($sql,$db);
49 /// Get a list of those who have made payments
50 if ($_GET['reset_filter']) {
56 //$sql = "SELECT P.*, M.login FROM ".TABLE_PREFIX."payments P INNER JOIN ".TABLE_PREFIX."members M USING (member_id) WHERE P.approved=1 ORDER BY timestamp desc LIMIT $offset, $results_per_page";
57 $sql = "SELECT P.*, M.login FROM ".TABLE_PREFIX."payments P INNER JOIN ".TABLE_PREFIX."members M USING (member_id) ORDER BY timestamp desc LIMIT $offset, $results_per_page";
59 //$sql ="SELECT C.*, P.*,M.login FROM ".TABLE_PREFIX."course_enrollment C, ".TABLE_PREFIX."payments P, ".TABLE_PREFIX."members M WHERE M.member_id = E.member_id";
61 $result = mysql_query($sql,$db);
63 require (AT_INCLUDE_PATH.'header.inc.php'); ?>
65 <?php print_paginator($page, $num_results, $page_string, $results_per_page); ?>
67 <table class="data static" summary="">
70 <th scope="col"><?php echo _AT('date'); ?></th>
71 <th scope="col"><?php echo _AT('login_name'); ?></th>
72 <th scope="col"><?php echo _AT('course'); ?></th>
73 <th scope="col"><?php echo _AT('enrolled'); ?></th>
74 <th scope="col"><?php echo _AT('ec_payment_made'); ?></th>
75 <th scope="col"><?php echo _AT('ec_transaction_id'); ?></th>
78 <?php while($row = mysql_fetch_assoc($result)): ?>
80 <td align="center"><?php echo $row['timestamp']; ?></td>
81 <td align="center"><?php echo $row['login']; ?></td>
82 <td align="center"><?php echo $system_courses[$row['course_id']]['title']; ?></td>
84 <?php if (is_enrolled($row['member_id'], $row['course_id'])): ?>
85 <?php echo _AT('yes'); ?> - <a href="admin/enrollment/enroll_edit.php?id0=<?php echo $row['member_id'].SEP.'func=unenroll'.SEP.'tab=0'.SEP.'course_id='.$row['course_id']; ?>"><?php echo _AT('unenroll'); ?></a>
87 <?php echo _AT('no'); ?> - <a href="admin/enrollment/enroll_edit.php?id0=<?php echo $row['member_id'].SEP.'func=enroll'.SEP.'tab=0'.SEP.'course_id='.$row['course_id']; ?>"><?php echo _AT('enroll'); ?></a>
90 <td align="center"><?php echo $_config['ec_currency_symbol'].number_format($row['amount'], 2); ?> <?php echo $_config['ec_currency']; ?></td>
91 <td align="center"><?php echo $row['transaction_id']; ?></td>
96 <?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>