removed mods directory from the ATutor codebase
[atutor.git] / mods / ecomm / payments_admin.php
diff --git a/mods/ecomm/payments_admin.php b/mods/ecomm/payments_admin.php
deleted file mode 100644 (file)
index 7e57243..0000000
+++ /dev/null
@@ -1,96 +0,0 @@
-<?php
-define('AT_INCLUDE_PATH', '../../include/');
-require (AT_INCLUDE_PATH.'vitals.inc.php');
-admin_authenticate(AT_ADMIN_PRIV_ECOMM);
-
-function is_enrolled($member_id, $course_id) {
-       global $db;
-       $sql = "SELECT approved FROM ".TABLE_PREFIX."course_enrollment WHERE course_id=$course_id AND member_id=$member_id AND approved<>'n'";
-       $result = mysql_query($sql, $db);
-       return (boolean) mysql_fetch_assoc($result);
-}
-
-$sql   = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."payments";
-//$sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."course_enrollment";
-$result = mysql_query($sql, $db);
-if (($row = mysql_fetch_assoc($result)) && $row['cnt']) {
-       $num_results = $row['cnt'];
-} else {
-       require(AT_INCLUDE_PATH.'header.inc.php');
-       $msg->printInfos('EC_NO_STUDENTS_ENROLLED');
-       require(AT_INCLUDE_PATH.'footer.inc.php');
-       exit;
-}
-
-$results_per_page = 25;
-$num_pages = max(ceil($num_results / $results_per_page), 1);
-$page = abs($_GET['p']);
-
-if (!$page) {
-       $page = 1;
-}
-
-$count  = (($page-1) * $results_per_page) + 1;
-$offset = ($page-1)*$results_per_page;
-
-// enroll/unenroll students
-
-if($_GET['func'] == 'enroll'){
-       $_GET['func']   = $addslashes($_GET['func']);
-       $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'y' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";
-       $result = mysql_query($sql,$db);
-}else if($_GET['func'] == 'unenroll'){
-
-       $_GET['func']   = $addslashes($_GET['func']);
-       $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'n' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";
-       $result = mysql_query($sql,$db);
-}
-
-/// Get a list of those who have made payments
-if ($_GET['reset_filter']) {
-       unset($_GET);
-}
-
-$page_string = '';
-
-//$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";
-$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";
-
-//$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";
-
-$result = mysql_query($sql,$db);
-
-require (AT_INCLUDE_PATH.'header.inc.php'); ?>
-
-<?php print_paginator($page, $num_results, $page_string, $results_per_page); ?>
-
-<table class="data static" summary="">
-<thead>
-<tr>
-       <th scope="col"><?php echo _AT('date'); ?></th>
-       <th scope="col"><?php echo _AT('login_name'); ?></th>
-       <th scope="col"><?php echo _AT('course'); ?></th>
-       <th scope="col"><?php echo _AT('enrolled'); ?></th>
-       <th scope="col"><?php echo _AT('ec_payment_made'); ?></th>
-       <th scope="col"><?php echo _AT('ec_transaction_id'); ?></th>
-</tr>
-</thead>
-<?php while($row = mysql_fetch_assoc($result)): ?>
-<tr>
-       <td align="center"><?php echo $row['timestamp']; ?></td>
-       <td align="center"><?php echo $row['login']; ?></td>
-       <td align="center"><?php echo $system_courses[$row['course_id']]['title']; ?></td>
-       <td align="center">
-               <?php if (is_enrolled($row['member_id'], $row['course_id'])): ?>
-                       <?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>
-               <?php else: ?>
-                       <?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>
-               <?php endif; ?>
-       </td>
-       <td align="center"><?php echo $_config['ec_currency_symbol'].number_format($row['amount'], 2); ?> <?php echo $_config['ec_currency']; ?></td>
-       <td align="center"><?php echo $row['transaction_id']; ?></td>
-</tr>
-<?php endwhile; ?>
-</table>
-
-<?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>
\ No newline at end of file