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