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;
}
<?php
// $Id: history.php,v 1.2 2004/04/12 00:34:26 mmr Exp $
if (is_array($history)) {
echo '<table><tr><td> </td><td> </td></tr>';
foreach ($history as $h) {
echo '<tr>';
echo '<td><nobr>' . b1n_formatDateHourShow($h['log_add_dt']) . '</nobr></td>';
$msg = $lang['log_' . $h['log_action']];
$vars = '';
if (!empty($h['log_vars'])) {
$vars = explode(';', $h['log_vars']);
if (is_array($vars)) {
foreach ($vars as $var) {
list($k, $v) = explode(':', $var);
if (b1n_cmp($k, 'money')) {
$v = b1n_formatCurrency($v);
}
$msg = str_replace('{' . $k . '}', $v, $msg);
}
}
}
echo '<td>' . $msg . '</td>';
echo '</tr>';
}
echo "</table>";
}
switch ($reg['type']) {
case "text":
case "textarea":
if ($reg['check'] == 'email' && !empty($reg_data[$reg['reg_data']])) {
echo " <a href='mailto:" . $reg_data[$reg['reg_data']] . "'>" . $reg_data[$reg['reg_data']] . "</a>";
} else {
echo " " . b1n_inHtml($reg_data[$reg['reg_data']]);
}
break;
case "select":
switch ($reg['extra']['seltype']) {
case "date":
echo b1n_formatDateShow($reg_data[$reg['reg_data']]);
break;
case "date_hour":
echo b1n_formatDateHourShow($reg_data[$reg['reg_data']]);
break;
case "defined":
foreach ($reg['extra']['options'] as $opt_title => $opt_value) {
if ($reg_data[$reg['reg_data']] == $opt_value) {
echo $opt_title;
break;
}
}
break;
case "fk":
if (!isset($reg['extra']['params'])) {
echo b1n_viewSelected($sql, $reg['extra']['value'], $reg['extra']['text'], $reg['extra']['table'], $reg_data[$reg['reg_data']]);
} else {
if (!isset($reg['extra']['where'])) {
$reg['extra']['where'] = array();
