mods/ecomm/payments_admin.php

   1 <?php
   2 define('AT_INCLUDE_PATH', '../../include/');
   3 require (AT_INCLUDE_PATH.'vitals.inc.php');
   4 admin_authenticate(AT_ADMIN_PRIV_ECOMM);
   5
   6 function is_enrolled($member_id, $course_id) {
   7         global $db;
   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);
  11 }
  12
  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'];
  18 } else {
  19         require(AT_INCLUDE_PATH.'header.inc.php');
  20         $msg->printInfos('EC_NO_STUDENTS_ENROLLED');
  21         require(AT_INCLUDE_PATH.'footer.inc.php');
  22         exit;
  23 }
  24
  25 $results_per_page = 25;
  26 $num_pages = max(ceil($num_results / $results_per_page), 1);
  27 $page = abs($_GET['p']);
  28
  29 if (!$page) {
  30         $page = 1;
  31 }
  32
  33 $count  = (($page-1) * $results_per_page) + 1;
  34 $offset = ($page-1)*$results_per_page;
  35
  36 // enroll/unenroll students
  37
  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'){
  43
  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);
  47 }
  48
  49 /// Get a list of those who have made payments
  50 if ($_GET['reset_filter']) {
  51         unset($_GET);
  52 }
  53
  54 $page_string = '';
  55
  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";
  58
  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";
  60
  61 $result = mysql_query($sql,$db);
  62
  63 require (AT_INCLUDE_PATH.'header.inc.php'); ?>
  64
  65 <?php print_paginator($page, $num_results, $page_string, $results_per_page); ?>
  66
  67 <table class="data static" summary="">
  68 <thead>
  69 <tr>
  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>
  76 </tr>
  77 </thead>
  78 <?php while($row = mysql_fetch_assoc($result)): ?>
  79 <tr>
  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>
  83         <td align="center">
  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>
  86                 <?php else: ?>
  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>
  88                 <?php endif; ?>
  89         </td>
  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>
  92 </tr>
  93 <?php endwhile; ?>
  94 </table>
  95
  96 <?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>