+++ /dev/null
-<?php\r
-$_user_location = 'users';\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require (AT_INCLUDE_PATH.'vitals.inc.php');\r
-require ('include/payments.lib.php');\r
-\r
-require (AT_INCLUDE_PATH.'header.inc.php');\r
-\r
-function is_enrolled($member_id, $course_id) {\r
- global $db;\r
- $sql = "SELECT approved FROM ".TABLE_PREFIX."course_enrollment WHERE course_id=$course_id AND member_id=$member_id AND approved<>'n'";\r
- $result = mysql_query($sql, $db);\r
- return (boolean) mysql_fetch_assoc($result);\r
-}\r
-\r
-/// Get a list of enrolled courses or pending enrollments, and display their fee payment status \r
-\r
-$payment_count = 0; // num listed courses\r
-\r
-$sql = "SELECT course_id, approved FROM ".TABLE_PREFIX."course_enrollment WHERE member_id=$_SESSION[member_id]";\r
-$result = mysql_query($sql,$db);\r
-\r
-\r
-if (mysql_num_rows($result)) { ?>\r
- <table class="data static" rules="rows" summary="">\r
- <thead>\r
- <tr>\r
- <th scope="col"><?php echo _AT('course'); ?></th>\r
- <th scope="col"><?php echo _AT('ec_this_course_fee'); ?></th>\r
- <th scope="col"><?php echo _AT('ec_payment_made'); ?></th>\r
- <th scope="col"><?php echo _AT('ec_enroll_approved'); ?></th>\r
- <th scope="col"><?php echo _AT('ec_action'); ?></th>\r
- </tr>\r
- </thead>\r
- <?php\r
- while ($row = mysql_fetch_assoc($result)){\r
- if ($_SESSION['member_id'] == $system_courses[$row['course_id']]['member_id']) {\r
- continue; // this member is an instructor\r
- }\r
-\r
- $sql2 = "SELECT course_fee FROM ".TABLE_PREFIX."ec_course_fees WHERE course_id=$row[course_id] AND course_fee>0";\r
- $result2 = mysql_query($sql2,$db);\r
- if ($this_course_fee = mysql_fetch_assoc($result2)) {\r
- $this_course_fee = $this_course_fee['course_fee'];\r
- } else {\r
- continue;\r
- }\r
-\r
- $payment_count++;\r
-\r
- echo '<tr>';\r
- if(is_enrolled($_SESSION['member_id'], $row['course_id'])){\r
- echo '<td><a href="bounce.php?course='.$row['course_id'].'">'.$system_courses[$row['course_id']]['title'].'</a></td>';\r
-\r
- }else{\r
- echo '<td>'.$system_courses[$row['course_id']]['title'].'</td>';\r
- }\r
- echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($this_course_fee, 2).' '.$_config['ec_currency'].'</td>';\r
-\r
- $sql4 = "SELECT SUM(amount) AS total_amount FROM ".TABLE_PREFIX."payments WHERE course_id='$row[course_id]' AND member_id = '$_SESSION[member_id]' AND approved=1";\r
- $result4 = mysql_query($sql4,$db);\r
- \r
- $row4 = mysql_fetch_assoc($result4);\r
- $amount_paid = $row4['total_amount'];\r
-\r
- echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($amount_paid, 2).'</td>';\r
- \r
- if ($row['approved'] == 'y'){\r
- echo '<td align="center">'._AT('yes').'</td>';\r
- } else {\r
- echo '<td align="center">'._AT('no').'</td>';\r
- }\r
- if ($amount_paid >= $this_course_fee){\r
- echo '<td align="center">'._AT('ec_full_payment_recieved').'</td>';\r
- }else{\r
- echo '<td align="center"><a href="mods/ecomm/payment.php?course_id='.$row['course_id'].'">'._AT('ec_make_payment').'</a></td>';\r
- }\r
- } \r
- echo '</table>';\r
- if($payment_count == 0){\r
- $msg->printInfos('EC_NO_PAID_COURSES');\r
- }\r
-} else {\r
- $msg->printInfos('EC_NO_PAID_COURSES');\r
-}\r
-\r
-require (AT_INCLUDE_PATH.'footer.inc.php'); ?>
\ No newline at end of file