inc/indexclients.php

   1 <?php
   2 echo "<p><font color=$colors[link1]>$system_name &gt;&gt;&gt;</font>
   3 Please select an action from the menus at the top of the page, or select
   4 one of the recently modified requests from the list below.<br>
   5 Create a search called 'Home' to replace this default list.</p>";
   6
   7   $query = "SELECT DISTINCT request.request_id, brief, fullname, email, last_activity, status.lookup_desc AS status_desc, ";
   8   $query .= "request.system_id, request_type.lookup_desc AS request_type_desc ";
   9   $query .= "FROM request ";
  10   $query .= "JOIN request_interested USING (request_id) ";
  11   $query .= "JOIN work_system USING (system_id) ";
  12   $query .= "JOIN system_usr ON (work_system.system_id = system_usr.system_id AND system_usr.user_no = $session->user_no) ";
  13   $query .= ", usr, lookup_code AS status, lookup_code AS request_type ";
  14   $query .= "WHERE request.request_id=request_interested.request_id ";
  15   $query .= "AND usr.org_code=$session->org_code ";
  16   $query .= "AND request.requester_id=usr.user_no ";
  17   $query .= "AND status.source_table='request' AND status.source_field='status_code' AND status.lookup_code=request.last_status ";
  18   $query .= "AND request_type.source_table='request' AND request_type.source_field='request_type' AND request.request_type = request_type.lookup_code ";
  19   $query .= "AND request.active AND request.last_status NOT IN ('F','C') ";
  20   $query .= "AND request.request_type != 90 ";
  21   $query .= "ORDER BY last_activity DESC LIMIT 100 ";
  22
  23   $result = awm_pgexec( $dbconn, $query, 'indexpage', false, 7 );
  24   if ( $result ) {
  25     echo "<table border=0 align=center cellspacing=1 cellpadding=1><tr class=cols>\n";
  26     echo "<th class=cols>WR&nbsp;#</th>";
  27     echo "<th class=cols>Requested By</th>";
  28     echo "<th class=cols>Description</th>";
  29     echo "<th class=cols>Status</th>";
  30     echo "<th class=cols>Type</th>";
  31     echo "<th class=cols>System</th>";
  32     echo "<th class=cols>Last&nbsp;Activity</th>";
  33     echo "</tr>\n";
  34     for ( $i=0; $i < pg_NumRows($result); $i++ ) {
  35       $thisrequest = pg_Fetch_Object( $result, $i );
  36
  37       echo "<tr class=row" . ($i % 2) . ">";
  38
  39       echo "<td class=sml align=center><a href=\"wr.php?request_id=$thisrequest->request_id\">$thisrequest->request_id</a></td>\n";
  40       echo "<td class=sml nowrap><a href=\"mailto:$thisrequest->email\">$thisrequest->fullname</a></td>\n";
  41       echo "<td class=sml><a href=\"wr.php?request_id=$thisrequest->request_id\">$thisrequest->brief";
  42       if ( "$thisrequest->brief" == "" ) echo "-- no description --";
  43       echo "</a></td>\n";
  44       echo "<td class=sml>$thisrequest->status_desc</td>\n";
  45       echo "<td class=sml>$thisrequest->request_type_desc</td>\n";
  46       echo "<td class=sml>$thisrequest->system_id</td>\n";
  47       echo "<td class=sml nowrap>" . nice_date($thisrequest->last_activity) . "</td>\n";
  48
  49       echo "</tr>\n";
  50     }
  51     echo "</table>\n";
  52   }