mods/ecomm/index_instructor.php

   1 <?php\r
   2 define('AT_INCLUDE_PATH', '../../include/');\r
   3 require (AT_INCLUDE_PATH.'vitals.inc.php');\r
   4 authenticate(AT_PRIV_ECOMM);\r
   5 \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
  10         exit;\r
  11 }\r
  12 \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
  17 \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
  21         }else{\r
  22                 $msg->addError('EC_COURSE_PAYMENT_SETTINGS_NOT_SAVED');\r
  23         }\r
  24 \r
  25         header('Location: '.$_SERVER['PHP_SELF']);\r
  26         exit;\r
  27 }\r
  28 \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
  34 \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
  38 }\r
  39 \r
  40 \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
  47 }\r
  48 \r
  49 require (AT_INCLUDE_PATH.'header.inc.php');\r
  50 ?>\r
  51 \r
  52 <form action="<?php  $_SERVER['PHP_SELF']; ?>" method="post">\r
  53         <div class="input-form">\r
  54                 <div class="row">\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
  57                 </div>\r
  58                 <div class="row">\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
  62                 </div>\r
  63                 <div class="row">\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
  67                 </div>\r
  68                 \r
  69                 <div class="row buttons">\r
  70                         <input type="submit" name="submit" value="<?php echo _AT('save'); ?>"  class="button"/>\r
  71                 </div>\r
  72         </div>\r
  73 </form>\r
  74 \r
  75 <?php\r
  76 \r
  77 \r
  78 \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
  84         <thead>\r
  85         <tr>\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
  89         </tr>\r
  90         </thead>\r
  91         <?php\r
  92                 while($row = mysql_fetch_assoc($result)){\r
  93                         echo '<tr>';\r
  94                         echo '<td align="center"><a href="profile.php?id='.$row['member_id'].'">'.$row['login'].'</a></td>';\r
  95         \r
  96                         echo '<td align="center">'.$_config['ec_currency_symbol'].number_format($row['amount'],2).' '.$_config['ec_currency'].'</td>';\r
  97                         \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
 102         \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
 105                                                 }else{\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
 107                                                 }\r
 108                                         }\r
 109                                 }else{\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
 111                                 }\r
 112                         } else {\r
 113                                 echo '<td align="center">'._AT('no').'</td>';\r
 114                         }\r
 115                 }\r
 116                 echo '</tr></table>';\r
 117 } else {\r
 118         $msg->printInfos('EC_NO_STUDENTS_ENROLLED');\r
 119 }\r
 120 \r
 121 require (AT_INCLUDE_PATH.'footer.inc.php'); ?>