[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "req_missing.php" ) {
   4   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   5   exit;
   6  }
   7  
   8  //$db->debug = true;

   9  
  10  print "<center><h2>Missing Rank Requirements</center></h2>";
  11  
  12  if ($print != 'Y') {
  13   print "<center><table><tr><td><b>Patrols:</b></td>\n";
  14   print "<td><a href='./index.php?req_missing=Y&show_print=Y&print_ins=req_missing=Y'>ALL</a></td>";
  15  
  16   $sql = mysql_query("select patrol_name from tbl_patrols order by record_key;");
  17  
  18   while ($row = mysql_fetch_assoc($sql)) {
  19    extract($row);
  20    print "<td><a href='./index.php?req_missing=Y&show_print=Y&print_ins=req_missing=Y&View_Patrol=$patrol_name'>$patrol_name</a></td>\n";
  21   }
  22   mysql_free_result($sql);
  23   print "</tr></table>\n";
  24   
  25   if ($View_Patrol != "") {
  26    $where = " and a.patrol = '$View_Patrol'";
  27   }
  28  }
  29  
  30  $sql = mysql_query("select a.first_name,a.last_name, d.rank_name, c.req_num, c.req_description, a.birthdate as birth, a.record_key as rowid
  31                      from tbl_scout as a
  32                      inner join tbl_scout_rank as b on a.record_key=b.scout_key
  33                      right join tbl_rank_requirements as c on b.rank_key=c.rank_key and b.req_num=c.req_num
  34                      left join tbl_rank as d on c.rank_key=d.record_key
  35                      where b.date is null and !(c.req_description = 'RMB' or c.req_description = 'MB') $where
  36                      group by c.rank_key,c.record_key, a.birthdate, a.last_name,a.first_name;");
  37                      print "<table width=100%>";
  38  while ($row = mysql_fetch_assoc($sql)) {
  39      extract($row);
  40      
  41      if ($rank_name != $rank_name_hold || $req_num != $req_num_hold ) {
  42      if ($rank_name != $rank_name_hold ) {
  43          print "</td></tr>\n<tr><td colspan=20 align=center><h2>$rank_name";
  44      }    
  45      if ($req_num != $req_num_hold ) {
  46          print "</td></tr>\n<tr><td><b>$req_num. $req_description</td><td>";
  47          print "<a href=./index.php?bs_info=Y&show_print=Y&print_ins=bs_info=Y&rowid=$rowid>$first_name $last_name</a>";
  48      }
  49      $rank_name_hold = $rank_name;
  50      $req_num_hold = $req_num;
  51      } else {
  52      print ", <a href=./index.php?bs_info=Y&show_print=Y&print_ins=bs_info=Y&rowid=$rowid>$first_name $last_name</a>";
  53      }
  54      
  55  }
  56  mysql_free_result($sql);
  57  
  58  print "</tr></table>";
  59  
  60  ?>