2 define('AT_INCLUDE_PATH', '../../include/');
\r
3 require (AT_INCLUDE_PATH.'vitals.inc.php');
\r
4 authenticate(AT_PRIV_ECOMM);
\r
6 if (!$_config['ec_allow_instructors']){
\r
7 require (AT_INCLUDE_PATH.'header.inc.php');
\r
8 $msg->printInfos('EC_PAYMENTS_TURNED_OFF');
\r
9 require (AT_INCLUDE_PATH.'footer.inc.php');
\r
13 if (isset($_POST['submit'])) {
\r
14 $_POST['ec_course_fee'] = floatval($_POST['ec_course_fee']);
\r
15 $_POST['ec_auto_approve'] = intval($_POST['ec_auto_approve']);
\r
16 $_POST['ec_auto_email'] = intval($_POST['ec_auto_email']);
\r
18 $sql = "REPLACE INTO ".TABLE_PREFIX."ec_course_fees VALUES ($_SESSION[course_id], '{$_POST['ec_course_fee']}', {$_POST['ec_auto_approve']}, {$_POST['ec_auto_email']})";
\r
19 if ($result = mysql_query($sql,$db)) {
\r
20 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
\r
22 $msg->addError('EC_COURSE_PAYMENT_SETTINGS_NOT_SAVED');
\r
25 header('Location: '.$_SERVER['PHP_SELF']);
\r
29 if($_GET['func'] == 'enroll'){
\r
30 $_GET['func'] = $addslashes($_GET['func']);
\r
31 $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'y' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";
\r
32 $result = mysql_query($sql,$db);
\r
33 }else if($_GET['func'] == 'unenroll'){
\r
35 $_GET['func'] = $addslashes($_GET['func']);
\r
36 $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'n' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";
\r
37 $result = mysql_query($sql,$db);
\r
41 $sql = "SELECT * from ".TABLE_PREFIX."ec_course_fees WHERE course_id='$_SESSION[course_id]'";
\r
42 $result = mysql_query($sql,$db);
\r
43 if ($row = mysql_fetch_assoc($result)){
\r
44 $this_course_fee = $row['course_fee'];
\r
45 $this_auto_approve = $row['auto_approve'];
\r
46 $this_auto_email = $row['auto_email'];
\r
49 require (AT_INCLUDE_PATH.'header.inc.php');
\r
52 <form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
\r
53 <div class="input-form">
\r
55 <label for="ec_course_fee"><?php echo _AT('ec_course_fee'); ?></label><br/>
\r
56 <?php echo $_config['ec_currency_symbol'] ?><input type="text" name="ec_course_fee" size="3" value="<?php echo $this_course_fee; ?>" id="ec_course_fee" size="10" /> (<?php echo $_config['ec_currency'] ?>)
\r
59 <?php echo _AT('ec_auto_approve'); ?><br/>
\r
60 <input type="radio" name="ec_auto_approve" value="1" id="auto1" <?php if($this_auto_approve){ echo 'checked="checked"'; } ?>/><label for="auto1"><?php echo _AT('enable'); ?></label>
\r
61 <input type="radio" name="ec_auto_approve" value="0" id="auto0" <?php if(!$this_auto_approve){ echo 'checked="checked"'; } ?>/><label for="auto0"><?php echo _AT('disable'); ?></label>
\r
64 <?php echo _AT('ec_auto_email'); ?><br/>
\r
65 <input type="radio" name="ec_auto_email" value="1" id="email1" <?php if ($this_auto_email) { echo 'checked="checked"'; } ?>/><label for="email1"><?php echo _AT('enable'); ?></label>
\r
66 <input type="radio" name="ec_auto_email" value="0" id="email0" <?php if (!$this_auto_email) { echo 'checked="checked"'; } ?>/><label for="email0"><?php echo _AT('disable'); ?></label>
\r
69 <div class="row buttons">
\r
70 <input type="submit" name="submit" value="<?php echo _AT('save'); ?>" class="button"/>
\r
79 //$sql2 = "SELECT P.member_id, P.amount, M.login FROM ".TABLE_PREFIX."payments AS P INNER JOIN ".TABLE_PREFIX."members M USING (member_id) WHERE P.course_id=$_SESSION[course_id] AND P.approved=1";
\r
80 $sql2 = "SELECT P.member_id, P.amount, M.login FROM ".TABLE_PREFIX."payments AS P INNER JOIN ".TABLE_PREFIX."members M USING (member_id) WHERE P.course_id=$_SESSION[course_id]";
\r
81 $result = mysql_query($sql2,$db);
\r
82 if (mysql_num_rows($result)) { ?>
\r
83 <table class="data static" rules="rows" summary="">
\r
86 <th scope="col"><?php echo _AT('login_name'); ?></th>
\r
87 <th scope="col"><?php echo _AT('ec_payment_made'); ?></th>
\r
88 <th scope="col"><?php echo _AT('enrolled'); ?></th>
\r
92 while($row = mysql_fetch_assoc($result)){
\r
94 echo '<td align="center"><a href="profile.php?id='.$row['member_id'].'">'.$row['login'].'</a></td>';
\r
96 echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($row['amount'],2).' '.$_config['ec_currency'].'</td>';
\r
98 $sql4 = "SELECT * from ".TABLE_PREFIX."course_enrollment WHERE course_id = '$_SESSION[course_id]' AND member_id = '$row[member_id]'";
\r
99 if($result4 = mysql_query($sql4, $db)){
\r
100 if(mysql_num_rows($result4) >= '1'){
\r
101 while($row4 = mysql_fetch_assoc($result4)){
\r
103 if($row4['approved'] == 'y'){
\r
104 echo '<td align="center">'._AT('yes').'<small> (<a href="tools/enrollment/enroll_edit.php?id0='.$row['member_id'].';func=unenroll;tab=0;course_id='.$_SESSION['course_id'].'">'._AT('unenroll').'</a>)</small></td>';
\r
106 echo '<td align="center">'._AT('no').' <small>( <a href="tools/enrollment/enroll_edit.php?id0='.$row['member_id'].';func=enroll;tab=0;course_id='.$_SESSION['course_id'].'">'._AT('enroll').'</a>)</small>';
\r
110 echo '<td align="center">'._AT('no').'<small> (<a href="tools/enrollment/enroll_edit.php?id0='.$row['member_id'].';func=enroll;tab=0;course_id='.$_SESSION['course_id'].'">'._AT('enroll').'</a>)</small></td>';
\r
113 echo '<td align="center">'._AT('no').'</td>';
\r
116 echo '</tr></table>';
\r
118 $msg->printInfos('EC_NO_STUDENTS_ENROLLED');
\r
121 require (AT_INCLUDE_PATH.'footer.inc.php'); ?>