index.php

   1 <?php
   2
   3 include_once("auth.php");
   4 include_once("header.php");
   5 include_once("time.php");
   6 include_once("detail_lib.php");
   7 include_once("user_details.php");
   8
   9 // files that have been line commented by faculty
  10 if($role == 0) { // faculty sees list of students names and assignments
  11
  12         //$sql = 'select sched_id, title, type_name,  chapter, section_id, ava_date, due_date, graded, NOW()-due_date as due, NOW()-ava_date as ava from schedule, types where (schedule.assign_type = types.assign_type) and sched_id = ANY (select sched_id from sched_details where fac_viewed = 0 or help_me != 0 and user_id = '.$user_id.' group by sched_id) order by due_date desc, ava_date desc, title desc, chapter desc, section_id desc';
  13
  14         $sql ='select sched_details.sched_id, schedule.title, schedule.chapter, schedule.section_id, sched_details.user_id, users.name, help_me, sched_details.timeposted, late, NOW()-due_date as due, NOW()-ava_date as ava, graded from sched_details, schedule, users where (sched_details.sched_id = schedule.sched_id) and (sched_details.user_id = users.user_id) and (fac_viewed = 0 or help_me != 0) group by sched_id order by help_me desc, sched_details.timeposted limit 50';
  15
  16         $html = '<table class="gridtable">
  17                         <tr>
  18                                 <th>#</th><th>Stauts</th><th>Student</th><th>Title</th><th>Chapter</th><th>Section</th>
  19                                 <th>Posted</th><th>Human Time</th><th>Mark<br>As<br>Read</th>
  20                         </tr>';
  21
  22 } else { // students see list of assignments
  23         //$sql = 'select sched_id, title, type_name,  chapter, section_id, graded, timeposted from schedule, types where (schedule.assign_type = types.assign_type) and sched_id = ANY (select sched_id from sched_details where user_viewed = 0 and user_id = '.$user_id.' group by sched_id) order by due_date desc, ava_date desc, title desc, chapter desc, section_id desc';
  24
  25         $sql ='select sched_details.sched_id, schedule.title, schedule.chapter, schedule.section_id, sched_details.user_id, users.name, help_me, sched_details.timeposted,  late, NOW()-due_date as due, NOW()-ava_date as ava, graded from sched_details, schedule, users where (sched_details.sched_id = schedule.sched_id) and (sched_details.user_id = users.user_id) and (user_viewed = 0 and sched_details.user_id = '.$user_id.') group by sched_id order by help_me desc, sched_details.timeposted limit 50';
  26
  27         $html = '<table class="gridtable">
  28                         <tr>
  29                                 <th>#</th><th>Status</th><th>Title</th><th>Type</th><th>Chapter</th><th>Section</th>
  30                                 <th>Posted</th><th>Human Time</th><th>Mark<br>As<br>Read</th>
  31                         </tr>';
  32 }
  33
  34 //echo $sql;
  35
  36 $result = mysql_query($sql);
  37
  38 if (!$result) { die("SQL ERROR"); }
  39 $count = 0;
  40 while($row = mysql_fetch_array($result))
  41 {
  42         $random = rand();
  43         $random .= time();
  44         if($role == 0) {
  45                 $html .= '<tr><td>'.$row['sched_id'].'</td>';
  46                 // assignment open?
  47                 if($row['due'] > 0 || $row['ava'] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
  48
  49
  50 //              if($row[8] > 0 || $row[10] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
  51
  52
  53                 // assignment graded?
  54                 if($row['graded']) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
  55
  56                 if($row['help_me']) { $html .= '<img src=gfx/flag_red.png>'; } else { $html .= '<img src=gfx/flag_white.png>'; }
  57
  58                 $html .= $help_icon;
  59
  60                 if($row['late']) {
  61                         $html .= '<img src=gfx/tick_off.png></td>';
  62                 } else {
  63                         if(file_count($row['user_id'], $row['sched_id'])) {
  64                                 $html .= '<img src=gfx/star.png></td>';
  65                                 } else { $html .= '<img src=gfx/error.png></td>'; }
  66                 }
  67
  68                 $html .= '<td>'.$row['name'].'</td>';
  69
  70                 $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'&user='.$row['user_id'].'">'.$row['title'].'</a></td><td>'.$row['chapter'].'</td>';
  71
  72                 $html .= '<td>'.$row['section_id'].'</td><td>'.$row['timeposted'].'</td>';
  73
  74                 $html .= '<td>'.absHumanTiming($row['timeposted']).'</td>';
  75
  76                 $html .= '<td><a href="index.php?sched='.$row['sched_id'].'&user='.$row['user_id'].'&action=mark&random='.$random.'">Mark as Read</a></td>';
  77
  78                 $html .= '</tr>';
  79
  80         } else {
  81                 $html .= '<tr><td>'.$row['sched_id'].'</td>';
  82
  83                 // assignment open?
  84                 if($row['due'] > 0 || $row['ava'] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
  85
  86                 // assignment graded?
  87                 if($row['graded']) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
  88
  89                 if($row['help_me']) { $html .= '<img src=gfx/flag_red.png>'; } else { $html .= '<img src=gfx/flag_white.png>'; }
  90
  91                 $html .= $help_icon;
  92
  93                 if($row['late']) {
  94                         $html .= '<img src=gfx/tick_off.png></td>';
  95                 } else {
  96                         if(file_count($user_id, $row['sched_id'])) {
  97                                 $html .= '<img src=gfx/star.png></td>';
  98                                 } else { $html .= '<img src=gfx/error.png></td>'; }
  99                 }
 100
 101                 $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'">'.$row['title'].'</a></td><td>'.$row['type_name'].'</td><td>'.$row['chapter'].'</td>';
 102
 103                 $html .= '<td>'.$row['section_id'].'</td><td>'.$row['timeposted'].'</td>';
 104
 105                 $html .= '<td>'.absHumanTiming($row['timeposted']).'</td>';
 106
 107                 $html .= '<td><a href="index.php?sched='.$row['sched_id'].'&action=mark&random='.$random.'">Mark as Read</a></td>';
 108
 109                 $html .= '</tr>';
 110         }
 111         $count++;
 112 }
 113
 114 if($count == 0) { $html = "<center><h3>No New Messages At This Time</h3></center>"; }
 115
 116 // set assignment to graded if link on page is clicked
 117 if(isset($_GET['action']) && isset($_GET['sched']))
 118 {
 119         if($role == 0) {
 120                 detail_viewed_update($_GET['user'], $_GET['sched'], 1, "fac");
 121                 helpme_viewed_update($_GET['user'], $_GET['sched'], 0);
 122         } else {
 123                 detail_viewed_update($user_id, $_GET['sched'], 1, "std");
 124         }
 125         echo '<html><meta http-equiv="refresh" content="0;url=index.php" /></html>';
 126         exit();
 127 }
 128 ?>
 129
 130 <h3>Recent Assignment Messages</h3>
 131
 132         <?php echo $html; ?>
 133         <?php if($count > 0) { include("legend.php"); } ?>
 134 </table>
 135
 136
 137