switch ($r['type']) {
case "text":
case "textarea":
if ($r['check'] == 'email') {
echo " <a href='mailto:" . $v . "'>" . b1n_inHtmlLimit($v) . "</a>";
} else {
echo b1n_inHtmlLimit($v);
}
break;
case "select":
switch ($r['extra']['seltype']) {
case "date":
echo b1n_formatDateShow(b1n_formatDateFromDb($v));
break;
case "date_hour":
echo b1n_formatDateHourShow(b1n_formatDateHourFromDb($v));
break;
case "date_check_exp":
echo b1n_formatDateCheckExpShow(b1n_formatDateFromDb($v));
break;
case "date_check_dob":
echo b1n_formatDateCheckDobShow(b1n_formatDateFromDb($v));
break;
case "defined":
foreach ($r['extra']['options'] as $opt_title => $opt_value) {
if ($v == $opt_value) {
$v = $opt_title;
break;
}
}
echo b1n_inHtmlLimit($v);
function b1n_regUpdateNextLegs($sql, &$ret_msgs, $r)
{
$r['ete_diff'] = strftime('%H:%M', $r['ete_diff_ts']);
$r['groundtime_diff'] = strftime('%H:%M', $r['groundtime_diff_ts']);
// If we are PUSHing we have to check for Overflow
if ($r['ete_signal'] == '+') {
$r['ete_signal'] = '';
if ($r['groundtime_signal'] == '+') {
$r['groundtime_signal'] = '';
}
// Checking for overflow
$rs = $sql->singleQuery("\n SELECT\n func_get_leg_push_overflow(\n '" . $r['trip'] . "',\n '" . $r['keeptrack'] . "',\n '" . $r['ete_diff'] . "', \n '" . $r['groundtime_diff'] . "') AS overflow");
// If we have something from the Function that means we are overlapping someone (hmmm)
if ($rs && !empty($rs['overflow'])) {
// Yep, we are trying to overlap someone, lets warn the user and abort the operation
$msg = 'The leg you are trying to change overlaps a leg with arbitrary ETD in the ';
$aux = explode('|', $rs['overflow']);
if ($r['trip'] != $aux[0]) {
$msg .= $aux[0];
} else {
$msg .= 'current(' . $r['trip'] . ')';
}
$msg .= ' trip at ' . b1n_formatDateHourShow(b1n_formatDateHourFromDb($aux[1])) . '.<br />Process aborted.';
b1n_retMsg($ret_msgs, b1n_FIZZLES, $msg);
return false;
}
} elseif ($r['groundtime_signal'] == '+' && $r['groundtime_diff_ts'] > $r['ete_diff_ts']) {
$r['groundtime_signal'] = '';
// Checking for overflow
$rs = $sql->singleQuery("\n SELECT\n func_get_leg_push_overflow(\n '" . $r['trip'] . "',\n '" . $r['keeptrack'] . "',\n '" . $r['ete_diff'] . "', \n '" . $r['groundtime_diff'] . "') AS overflow");
// If we have something from the Function that means we are overlapping someone (hmmm)
if ($rs && !empty($rs['overflow'])) {
// Yep, we are trying to overlap someone, lets warn the user and abort the operation
$msg = 'The leg you are trying to change overlaps a leg with arbitrary ETD in the ';
$aux = explode('|', $rs['overflow']);
if ($trip != $aux[0]) {
$msg .= $aux[0];
} else {
$msg .= 'current(' . $trip . ')';
}
$msg .= ' trip at ' . b1n_formatDateHourShow(b1n_formatDateHourFromDb($aux[1])) . '.<br />Process aborted.';
b1n_retMsg($ret_msgs, b1n_FIZZLES, $msg);
return false;
}
} elseif ($r['ete_signal'] != '-' && $r['groundtime_signal'] != '-') {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Unknown signal requested.");
return false;
}
$query = "\n UPDATE\n \"leg\"\n SET\n leg_keeptrack_dt = leg_keeptrack_dt::timestamp\n + \n " . $r['ete_signal'] . "'" . b1n_inBd($r['ete_diff']) . "'::interval\n +\n " . $r['groundtime_signal'] . "'" . b1n_inBd($r['groundtime_diff']) . "'::interval\n WHERE\n leg_trip = '" . $r['trip'] . "' AND\n leg_etd_dt IS NULL AND\n leg_keeptrack_dt > '" . $r['keeptrack'] . "'";
$rs = $sql->query($query);
if ($rs) {
$ret = true;
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, 'Could not ' . $action . ' next legs.');
$ret = false;
}
return $ret;
}
$aux = b1n_regDefaultLegSearchSimilar($sql, $reg_data['apt_id_depart'], $reg_data['apt_id_arrive']);
if ($aux) {
list($reg_data['leg_ete_i'], $reg_data['leg_distance'], $reg_data['leg_fuel']) = explode('|', $aux);
if ($reg_data['leg_fuel'] == 0) {
$reg_data['leg_fuel'] = '';
}
$reg_data['leg_ete_i'] = b1n_formatHourFromDb($reg_data['leg_ete_i']);
}
}
break;
}
if ($rs && is_array($rs)) {
// If we do have groundtime in last leg we should disable Depart Date input.
$disable_etd_dt = $rs['leg_groundtime_i'] == 't';
// Default Depart date is keeptrack
$reg_data['leg_etd_dt'] = b1n_formatDateHourFromDb($rs['leg_keeptrack_dt']);
}
}
?>
<script language="JavaScript">
function b1n_verifyAirports(f)
{
var d = f.apt_id_depart.options[f.apt_id_depart.selectedIndex];
var a = f.apt_id_arrive.options[f.apt_id_arrive.selectedIndex];
if(d.value.length > 0 && a.value.length > 0)
{
// Verifying if the airports selected isnt equal to the ones we already have
if(d.value != '<?php
echo $reg_data['apt_id_depart'];
?>
function b1n_regLoad($sql, &$ret_msgs, &$reg_data, $reg_config, $table)
{
foreach ($reg_config as $r) {
if ($r['db'] == 'none' || !$r['load']) {
continue;
}
$fields[] = $r['db'];
}
$fields = implode(", ", $fields);
$query = "SELECT " . $fields . " FROM \"" . $table . "\" WHERE " . $reg_config['ID']['db'] . " = '" . b1n_inBd($reg_data["id"]) . "'";
$rs = $sql->singleQuery($query);
if (is_array($rs)) {
foreach ($reg_config as $r) {
if ($r['db'] == 'none' || !$r['load']) {
continue;
}
if ($r['type'] == 'select') {
switch ($r['extra']['seltype']) {
case 'date':
case 'date_check_exp':
case 'date_check_dob':
$rs[$r['db']] = b1n_formatDateFromDb($rs[$r['db']]);
break;
case 'date_hour':
$rs[$r['db']] = b1n_formatDateHourFromDb($rs[$r['db']]);
break;
}
}
$reg_data[$r['reg_data']] = $rs[$r['db']];
}
$ret = true;
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, 'ID not Registered.');
$ret = false;
}
return $ret;
}
