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 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 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                 // assignment graded?
  50                 if($row['graded']) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
  51
  52                 if($row['help_me']) { $html .= '<img src=gfx/flag_red.png>'; } else { $html .= '<img src=gfx/flag_white.png>'; }
  53
  54                 $html .= $help_icon;
  55
  56                 if(file_count($row[4], $row[0])) {
  57                         $html .= '<img src=gfx/star.png></td>';
  58                         } else { $html .= '<img src=gfx/error.png></td>'; }
  59
  60
  61                 $html .= '<td>'.$row['name'].'</td>';
  62
  63                 $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'&user='.$row['user_id'].'">'.$row['title'].'</a></td><td>'.$row['chapter'].'</td>';
  64
  65                 $html .= '<td>'.$row['section_id'].'</td><td>'.$row['timeposted'].'</td>';
  66
  67                 $html .= '<td>'.absHumanTiming($row['timeposted']).'</td>';
  68
  69                 $html .= '<td><a href="index.php?sched='.$row['sched_id'].'&user='.$row['user_id'].'&action=mark&random='.$random.'">Mark as Read</a></td>';
  70
  71                 $html .= '</tr>';
  72
  73         } else {
  74                 $html .= '<tr><td>'.$row['sched_id'].'</td>';
  75
  76                 // assignment open?
  77                 if($row['due'] > 0 || $row['ava'] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
  78
  79                 // assignment graded?
  80                 if($row['graded']) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
  81
  82                 if($row['help_me']) { $html .= '<img src=gfx/flag_red.png>'; } else { $html .= '<img src=gfx/flag_white.png>'; }
  83
  84                 $html .= $help_icon;
  85
  86                 if(file_count($user_id, $row[0])) {
  87                         $html .= '<img src=gfx/star.png></td>';
  88                         } else { $html .= '<img src=gfx/error.png></td>'; }
  89
  90
  91                 $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'">'.$row['title'].'</a></td><td>'.$row['type_name'].'</td><td>'.$row['chapter'].'</td>';
  92
  93                 $html .= '<td>'.$row['section_id'].'</td><td>'.$row['timeposted'].'</td>';
  94
  95                 $html .= '<td>'.absHumanTiming($row['timeposted']).'</td>';
  96
  97                 $html .= '<td><a href="index.php?sched='.$row['sched_id'].'&action=mark&random='.$random.'">Mark as Read</a></td>';
  98
  99                 $html .= '</tr>';
 100         }
 101         $count++;
 102 }
 103
 104 if($count == 0) { $html = "<center><h3>No New Messages At This Time</h3></center>"; }
 105
 106 // set assignment to graded if link on page is clicked
 107 if(isset($_GET['action']) && isset($_GET['sched']))
 108 {
 109         if($role == 0) {
 110                 detail_viewed_update($_GET['user'], $_GET['sched'], 1, "fac");
 111                 helpme_viewed_update($_GET['user'], $_GET['sched'], 0);
 112         } else {
 113                 detail_viewed_update($user_id, $_GET['sched'], 1, "std");
 114         }
 115         echo '<html><meta http-equiv="refresh" content="0;url=index.php" /></html>';
 116         exit();
 117 }
 118 ?>
 119
 120 <h3>Recent Assignment Messages</h3>
 121
 122         <?php echo $html; ?>
 123         <?php if($count > 0) { include("legend.php"); } ?>
 124 </table>
 125
 126
 127