+++ /dev/null
-<?php\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require (AT_INCLUDE_PATH.'vitals.inc.php');\r
-authenticate(AT_PRIV_ECOMM);\r
-\r
-if (!$_config['ec_allow_instructors']){\r
- require (AT_INCLUDE_PATH.'header.inc.php');\r
- $msg->printInfos('EC_PAYMENTS_TURNED_OFF');\r
- require (AT_INCLUDE_PATH.'footer.inc.php'); \r
- exit;\r
-}\r
-\r
-if (isset($_POST['submit'])) {\r
- $_POST['ec_course_fee'] = floatval($_POST['ec_course_fee']);\r
- $_POST['ec_auto_approve'] = intval($_POST['ec_auto_approve']);\r
- $_POST['ec_auto_email'] = intval($_POST['ec_auto_email']);\r
-\r
- $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
- if ($result = mysql_query($sql,$db)) {\r
- $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
- }else{\r
- $msg->addError('EC_COURSE_PAYMENT_SETTINGS_NOT_SAVED');\r
- }\r
-\r
- header('Location: '.$_SERVER['PHP_SELF']);\r
- exit;\r
-}\r
-\r
-if($_GET['func'] == 'enroll'){\r
- $_GET['func'] = $addslashes($_GET['func']);\r
- $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'y' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";\r
- $result = mysql_query($sql,$db);\r
-}else if($_GET['func'] == 'unenroll'){\r
-\r
- $_GET['func'] = $addslashes($_GET['func']);\r
- $sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment SET approved = 'n' WHERE course_id= '$_GET[course_id]' AND member_id = '$_GET[id0]'";\r
- $result = mysql_query($sql,$db);\r
-}\r
-\r
-\r
-$sql = "SELECT * from ".TABLE_PREFIX."ec_course_fees WHERE course_id='$_SESSION[course_id]'";\r
-$result = mysql_query($sql,$db);\r
-if ($row = mysql_fetch_assoc($result)){\r
- $this_course_fee = $row['course_fee'];\r
- $this_auto_approve = $row['auto_approve'];\r
- $this_auto_email = $row['auto_email'];\r
-}\r
-\r
-require (AT_INCLUDE_PATH.'header.inc.php');\r
-?>\r
-\r
-<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">\r
- <div class="input-form">\r
- <div class="row">\r
- <label for="ec_course_fee"><?php echo _AT('ec_course_fee'); ?></label><br/>\r
- <?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
- </div>\r
- <div class="row">\r
- <?php echo _AT('ec_auto_approve'); ?><br/>\r
- <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
- <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
- </div>\r
- <div class="row">\r
- <?php echo _AT('ec_auto_email'); ?><br/>\r
- <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
- <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
- </div>\r
- \r
- <div class="row buttons">\r
- <input type="submit" name="submit" value="<?php echo _AT('save'); ?>" class="button"/>\r
- </div>\r
- </div>\r
-</form>\r
-\r
-<?php\r
-\r
-\r
-\r
-//$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
-$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
-$result = mysql_query($sql2,$db);\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('login_name'); ?></th>\r
- <th scope="col"><?php echo _AT('ec_payment_made'); ?></th>\r
- <th scope="col"><?php echo _AT('enrolled'); ?></th>\r
- </tr>\r
- </thead>\r
- <?php\r
- while($row = mysql_fetch_assoc($result)){\r
- echo '<tr>';\r
- echo '<td align="center"><a href="profile.php?id='.$row['member_id'].'">'.$row['login'].'</a></td>';\r
- \r
- echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($row['amount'],2).' '.$_config['ec_currency'].'</td>';\r
- \r
- $sql4 = "SELECT * from ".TABLE_PREFIX."course_enrollment WHERE course_id = '$_SESSION[course_id]' AND member_id = '$row[member_id]'";\r
- if($result4 = mysql_query($sql4, $db)){\r
- if(mysql_num_rows($result4) >= '1'){\r
- while($row4 = mysql_fetch_assoc($result4)){\r
- \r
- if($row4['approved'] == 'y'){\r
- 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
- }else{\r
- 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
- }\r
- }\r
- }else{\r
- 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
- }\r
- } else {\r
- echo '<td align="center">'._AT('no').'</td>';\r
- }\r
- }\r
- echo '</tr></table>';\r
-} else {\r
- $msg->printInfos('EC_NO_STUDENTS_ENROLLED');\r
-}\r
-\r
-require (AT_INCLUDE_PATH.'footer.inc.php'); ?>
\ No newline at end of file
projects / atutor.git / blobdiff