<th colspan="2">Hours</th>
<th>Flights</th>
<th>Segs</th>
<th colspan="2">Hours</th>
</tr>
<?php
$class = '';
foreach (pax_search("") as $alias) {
if ($class != "odd") {
$class = "odd";
} else {
$class = "even";
}
$status = pax_status($alias, $rvar_pilot, "");
$line = pax_detail($alias, $rvar_pilot, "");
$year = pax_detail($alias, $rvar_pilot, "date >= '{$thisyear}-01-01' and date <= '{$thisyear}-12-31'");
$detaillink = "detail_pax.php?alias={$alias}&pilot={$rvar_pilot}";
$features = " ";
if ($line['image_url']) {
$features = "<img src=\"images/image.gif\" height=\"15\" width=\"64\"/>";
}
$name = $alias;
if ($line['fullname']) {
$name = $line['fullname'] . " (" . $alias . ")";
}
if (strpos($line['detail'], "\n")) {
$line['detail'] = substr($line['detail'], 0, strpos($line['detail'], "\n"));
}
if (strlen($line['detail']) > 60) {
$line['detail'] = substr($line['detail'], 0, 60) . "...";
}
} else {
if ($rvar_id == 0) {
if (!isset($rvar_pilot)) {
$error_title = "No pilot specified";
$error_text = "You must specify a pilot in order to add a new passenger entry.";
}
$title = "passenger: Add";
$alias = $rvar_alias;
} else {
$key = pax_key($rvar_id);
if (isset($key['pilot_id'])) {
$rvar_pilot = $key['pilot_id'];
$alias = $key['alias'];
}
}
$line = pax_detail($alias, $rvar_pilot, "");
}
if (!is_mine()) {
$error_title = "Up To No Good";
$error_text = "I can't edit an entry if you don't own it!";
unset($rvar_fullname);
}
if (isset($rvar_fullname)) {
# I see data, we need to insert/update as required.
if ($rvar_id == 0) {
# new logbook entry
$sql = "INSERT INTO passengers\n (alias, pilot_id, is_pilot, fullname,\n image_url, link_url, detail) VALUES " . "('{$alias}', {$rvar_pilot}, 0, '{$rvar_fullname}', " . "'{$rvar_image_url}','{$rvar_link_url}','{$rvar_detail}')";
} else {
# editing an old entry
$sql = "UPDATE passengers SET " . "fullname='{$rvar_fullname}', " . "image_url='{$rvar_image_url}', link_url='{$rvar_link_url}', detail='{$rvar_detail}' where id = {$rvar_id}";
}
print $yeartotals['segments'];
?>
</td>
<td class="integer"><?php
print $yeartotals['landings'];
?>
</td>
<?php
split_decimal($yeartotals['total_hours']);
?>
<td width="100%"> </td>
</tr>
<?php
}
$yeartotals = pax_detail($alias, $rvar_pilot, '');
?>
<tr>
<td><strong>Total</strong></td>
<td class="integer"><?php
print $yeartotals['flights'];
?>
</td>
<td class="integer"><?php
print $yeartotals['segments'];
?>
</td>
<td class="integer"><?php
print $yeartotals['landings'];
?>
</td>
