mods/ecomm/index.php

   1 <?php\r
   2 $_user_location = 'users';\r
   3 define('AT_INCLUDE_PATH', '../../include/');\r
   4 require (AT_INCLUDE_PATH.'vitals.inc.php');\r
   5 require ('include/payments.lib.php');\r
   6 \r
   7 require (AT_INCLUDE_PATH.'header.inc.php');\r
   8 \r
   9 function is_enrolled($member_id, $course_id) {\r
  10         global $db;\r
  11         $sql = "SELECT approved FROM ".TABLE_PREFIX."course_enrollment WHERE course_id=$course_id AND member_id=$member_id AND approved<>'n'";\r
  12         $result = mysql_query($sql, $db);\r
  13         return (boolean) mysql_fetch_assoc($result);\r
  14 }\r
  15 \r
  16 /// Get a list of enrolled courses or pending enrollments, and display their fee payment status \r
  17 \r
  18 $payment_count = 0; // num listed courses\r
  19 \r
  20 $sql = "SELECT course_id, approved FROM ".TABLE_PREFIX."course_enrollment WHERE member_id=$_SESSION[member_id]";\r
  21 $result = mysql_query($sql,$db);\r
  22 \r
  23 \r
  24 if (mysql_num_rows($result)) { ?>\r
  25         <table class="data static" rules="rows" summary="">\r
  26         <thead>\r
  27                 <tr>\r
  28                         <th scope="col"><?php echo _AT('course'); ?></th>\r
  29                         <th scope="col"><?php echo _AT('ec_this_course_fee'); ?></th>\r
  30                         <th scope="col"><?php echo _AT('ec_payment_made'); ?></th>\r
  31                         <th scope="col"><?php echo _AT('ec_enroll_approved'); ?></th>\r
  32                         <th scope="col"><?php echo _AT('ec_action'); ?></th>\r
  33                 </tr>\r
  34         </thead>\r
  35         <?php\r
  36                 while ($row = mysql_fetch_assoc($result)){\r
  37                         if ($_SESSION['member_id'] == $system_courses[$row['course_id']]['member_id']) {\r
  38                                 continue; // this member is an instructor\r
  39                         }\r
  40 \r
  41                         $sql2 = "SELECT course_fee FROM  ".TABLE_PREFIX."ec_course_fees WHERE course_id=$row[course_id] AND course_fee>0";\r
  42                         $result2 = mysql_query($sql2,$db);\r
  43                         if ($this_course_fee = mysql_fetch_assoc($result2)) {\r
  44                                 $this_course_fee = $this_course_fee['course_fee'];\r
  45                         } else {\r
  46                                 continue;\r
  47                         }\r
  48 \r
  49                         $payment_count++;\r
  50 \r
  51                         echo '<tr>';\r
  52                         if(is_enrolled($_SESSION['member_id'], $row['course_id'])){\r
  53                                 echo '<td><a href="bounce.php?course='.$row['course_id'].'">'.$system_courses[$row['course_id']]['title'].'</a></td>';\r
  54 \r
  55                         }else{\r
  56                                 echo '<td>'.$system_courses[$row['course_id']]['title'].'</td>';\r
  57                         }\r
  58                         echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($this_course_fee, 2).' '.$_config['ec_currency'].'</td>';\r
  59 \r
  60                         $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
  61                         $result4 = mysql_query($sql4,$db);\r
  62                 \r
  63                         $row4 = mysql_fetch_assoc($result4);\r
  64                         $amount_paid = $row4['total_amount'];\r
  65 \r
  66                         echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($amount_paid, 2).'</td>';\r
  67                                 \r
  68                         if ($row['approved'] == 'y'){\r
  69                                 echo '<td align="center">'._AT('yes').'</td>';\r
  70                         } else {\r
  71                                 echo '<td align="center">'._AT('no').'</td>';\r
  72                         }\r
  73                         if ($amount_paid >= $this_course_fee){\r
  74                                 echo '<td align="center">'._AT('ec_full_payment_recieved').'</td>';\r
  75                         }else{\r
  76                                 echo '<td align="center"><a href="mods/ecomm/payment.php?course_id='.$row['course_id'].'">'._AT('ec_make_payment').'</a></td>';\r
  77                         }\r
  78                 }       \r
  79                 echo '</table>';\r
  80                 if($payment_count == 0){\r
  81                         $msg->printInfos('EC_NO_PAID_COURSES');\r
  82                 }\r
  83 } else {\r
  84         $msg->printInfos('EC_NO_PAID_COURSES');\r
  85 }\r
  86 \r
  87 require (AT_INCLUDE_PATH.'footer.inc.php'); ?>