[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "service_log.php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   4   exit;
   5  }
   6  
   7  $sql = mysql_query("select first_name,last_name from tbl_scout where record_key=$rowid");
   8  extract(mysql_fetch_assoc($sql));
   9  mysql_free_result($sql);
  10  
  11  $sql = mysql_query("select position from tbl_scout_leadership where scout_key=$rowid and enddate='0000-00-00'");
  12  extract(mysql_fetch_assoc($sql));
  13  mysql_free_result($sql);
  14  
  15  print "<center><h2>$position $first_name $last_name</h2>
  16  <p><h3>Service Log</h3></center>";
  17  
  18  if ($add_service == "Y" && $user_group <2 ) {
  19   foreach ($service_activity as $service_key => $activity_data) {
  20    $check_date = $service_date[$service_key];
  21    if ($check_date != '0000-00-00') {
  22     if ($service_key == '000' && $activity_data != '') {
  23      $sql_insert = mysql_query("insert into tbl_scout_service
  24                                 (scout_key
  25                                 ,date
  26                                 ,service
  27                                 ,hours
  28                                 ) values
  29                                 (\"$rowid\"
  30                                 ,\"$check_date\"
  31                                 ,\"$activity_data\"
  32                                 ,\"" . $service_hours[$service_key] . "\"
  33                                 )
  34                                 ");
  35     }
  36     if ($service_key != '000') {
  37      if ($delete[$service_key] == "Y") {
  38       mysql_query("delete from tbl_scout_service where record_key = \"$service_key\"");
  39      } else {
  40       mysql_query("update tbl_scout_service
  41                    set  service=\"$activity_data\"
  42                    ,date=\"$check_date\"
  43                    ,hours=\"" . $service_hours[$service_key] . "\"
  44                    where record_key=\"$service_key\"
  45                    ");
  46      }
  47     }
  48    }
  49   }
  50  }
  51  if ($user_group < 2 && $print != "Y") {
  52   print "<form method=POST action=./index.php>
  53    <input type=hidden name=service_log value=Y>
  54    <input type=hidden name=add_service value=Y>
  55    <input type=hidden name=rowid value=$rowid>
  56    <input type=submit value=Submit><p>";
  57    $i = 3;
  58  }
  59  
  60  print "<table class=white align=center border=1><tr align=center><td><b>Service</td><td><b>Date</td><td><b>Hours</td>";
  61  if ($user_group <2) {
  62   print "<td><b>Delete</td>";
  63  }
  64  print "</tr>";
  65  
  66  $total_hours = 0;
  67  
  68  $sql = mysql_query("select record_key as service_key,date as service_date,service as service_activity,hours as service_hours from tbl_scout_service where scout_key=$rowid order by date");
  69  
  70  while ($row = mysql_fetch_assoc($sql)) {
  71   extract($row);
  72   $total_hours = $total_hours + $service_hours;
  73   if ($user_group < 2 && $print != "Y" ) {
  74    $i = $i + 2;
  75    print "<tr>
  76            <td><input type=text size=20 maxlength=20 name=service_activity[$service_key] value=\"$service_activity\"></td>
  77            <td><input type=text size=10 maxlength=10 name=service_date[$service_key] value='$service_date'
  78                   onChange=\"var box=document.forms[0].elements[$i];var d=parseDate(box.value);
  79                           if(d==null){
  80                            alert('Date string not recognizable!');
  81                            box.value='';
  82                            box.focus();
  83                           } else {
  84                            box.value=formatDate(d,'yyyy-MM-dd');
  85                           }\"></td>
  86            <td><input type=text size=2 maxlength=2 name=service_hours[$service_key] value=\"$service_hours\"></td>
  87        <td align=center><input type=checkbox name=delete[$service_key] value=Y></td>
  88           </tr>";
  89    $i = $i + 2;
  90   } else {
  91    print "<tr>
  92            <td>$service_activity</td>
  93            <td>$service_date</td>
  94            <td align=center><b>$service_hours</td>
  95           </tr>";
  96   }
  97   
  98  }
  99  mysql_free_result($sql);
 100  
 101  if ($user_group <2 && $print != "Y") {
 102   $i = $i + 2;
 103   print "<tr>
 104           <td><input type=text size=20 maxlength=20 name=service_activity[000]></td>
 105           <td><input type=text size=10 maxlength=10 name=service_date[000]
 106                            onChange=\"var box=document.forms[0].elements[$i];var d=parseDate(box.value);
 107                           if(d==null){
 108                            alert('Date string not recognizable!');
 109                            box.value='';
 110                            box.focus();
 111                           } else {
 112                            box.value=formatDate(d,'yyyy-MM-dd');
 113                           }\"></td>
 114           <td><input type=text size=2 maxlength=2 name=service_hours[000]></td></tr>";
 115  }
 116  
 117  print "<tr><td colspan=4 align=center><b>Total: $total_hours</td><td></td>";
 118  
 119  print "</table>";
 120  if ($user_group <2 && $print != "Y") {
 121   print "<center><input type=submit value=Submit></center></form>";
 122  }
 123  ?>