|
EOF
print "
Flight Summary";
print "";
while($hash_ref = $sth->fetchrow_hashref){
print "";
print "| Flight: | $hash_ref->{ID} | ";
print " \n";
print "";
print "Remarks/
Procedures: | $hash_ref->{remarks} | ";
print " \n";
print "";
print "| Date | A/C Type | A/C ID | From | To | # Day Lndgs | # Night Lndgs | Training Time | Solo Time | Cross-country Time | Total Time | ";
print " ";
print "";
print "| $hash_ref->{date} | $hash_ref->{make} | $hash_ref->{ident} | $hash_ref->{apt_from} | $hash_ref->{apt_to} | $hash_ref->{dayland} | $hash_ref->{nightland} | $hash_ref->{hrs_training} | $hash_ref->{hrs_pic} | $hash_ref->{hrs_xc} | $hash_ref->{hrs_total} | ";
print " ";
print "
| ";
$total_day_landings = $total_day_landings + $hash_ref->{dayland};
$total_night_landings = $total_night_landings + $hash_ref->{nightland};
$total_night_time = $total_night_time + $hash_ref->{hrs_night};
$total_training_time = $total_training_time + $hash_ref->{hrs_training};
$total_solo_time = $total_solo_time + $hash_ref->{hrs_pic};
$total_xc_time = $total_xc_time + $hash_ref->{hrs_xc};
$total_hood_time = $total_hood_time + $hash_ref->{hrs_hood};
$total_time = $total_time + $hash_ref->{hrs_total};
}
print " ";
$total_landings = $total_day_landings + $total_night_landings;
print "Total Day Landings: $total_day_landings
";
print "Total Night Landings: $total_night_landings
";
print "Total Landings: $total_landings
";
print "Total Training Time: $total_training_time
";
print "Total Night Time: $total_night_time
";
print "Total Solo/PIC Time: $total_solo_time
";
print "Total Cross-country Time: $total_xc_time
";
print "Total Hood Time: $total_hood_time
";
print "
";
print "Total Time: $total_time
";
print " |
![[Title] AC's Flight Line](./images/title.gif)
![[Link] Home](./images/home150x31-off.gif){kind=small}
![[Link]Flight Log](./images/flightlog148x31-gray.gif){kind=small}
![[Link]Pictures](./images/pictures152x31-off.gif){kind=small}
![[Link]Links](./images/links154x31-off.gif){kind=small}