Esempio n. 1
0
File: leg.lib.php Progetto: mmr/b1n
function b1n_regLoadLeg($sql, &$ret_msgs, &$reg_data, &$reg_config)
{
    $d = date('Y');
    $reg_config['KeepTrack'] = array('reg_data' => 'leg_keeptrack_dt', 'db' => 'leg_keeptrack_dt', 'check' => 'none', 'type' => 'select', 'extra' => array('seltype' => 'date_hour', 'year_start' => $d, 'year_end' => $d + b1n_DEFAULT_DATE_INC), 'load' => 'true');
    $ret = b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "leg");
    unset($reg_config["KeepTrack"]);
    $reg_data["paxs"] = array();
    // Pax List
    $query = "SELECT DISTINCT pax_id FROM \"leg_pax\" WHERE leg_id = '" . b1n_inBd($reg_data['id']) . "'";
    $rs = $sql->query($query);
    if ($rs && is_array($rs)) {
        foreach ($rs as $i) {
            array_push($reg_data['paxs'], $i['pax_id']);
        }
    }
    // ETD = KeepTrack
    $reg_data["leg_etd_dt"] = $reg_data["leg_keeptrack_dt"];
    // ETE
    $reg_data["leg_ete_i"] = b1n_formatHourFromDb($reg_data["leg_ete_i"]);
    return $ret;
}
Esempio n. 2
0
File: add.php Progetto: mmr/b1n
            }
            // Default GroundTime is 45 minutes
            $reg_data['leg_groundtime_i'] = '00:45';
            // 'No Break' on purpose to get throught and get similar leg data :)
            // break;
        // 'No Break' on purpose to get throught and get similar leg data :)
        // break;
        case 'similarleg':
            if ($reg_data['apt_id_depart'] && $reg_data['apt_id_arrive']) {
                $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)
{
Esempio n. 3
0
File: reg.lib.php Progetto: mmr/b1n
function b1n_regChange($sql, &$ret_msgs, $reg_data, $reg_config, $table, $msg, $module_function = "")
{
    $rs = $sql->query("BEGIN TRANSACTION");
    if ($rs) {
        $query = "SELECT * FROM \"" . $table . "\" WHERE " . $reg_config["ID"]["db"] . " = '" . b1n_inBd($reg_data['id']) . "'";
        $update = "";
        $old_values = $sql->singleQuery($query);
        foreach ($reg_config as $t => $r) {
            $value = $reg_data[$r['reg_data']];
            $aux = "";
            // Fields
            if ($r['db'] == 'none') {
                continue;
            }
            // Values
            switch ($r['type']) {
                case "select":
                    switch ($r['extra']['seltype']) {
                        case "date":
                        case "date_check_exp":
                        case "date_check_dob":
                            $aux = b1n_formatDate($value);
                            $old_values[$r['db']] = b1n_formatDate(b1n_formatDateFromDb($old_values[$r['db']]));
                            break;
                        case "date_hour":
                            $aux = b1n_formatDateHour($value);
                            $old_values[$r['db']] = b1n_formatDateHour(b1n_formatDateHourFromDb($old_values[$r['db']]));
                            break;
                        case "hour":
                            $aux = b1n_formatHour($value);
                            $old_values[$r['db']] = b1n_formatHour(b1n_formatHourFromDb($old_values[$r['db']]));
                            break;
                        default:
                            $aux = $value;
                            break;
                    }
                    break;
                case "password":
                    if (empty($value)) {
                        // For some reason, switch counts as a loop, so we need to use 'continue(2)' instead of just 'continue'
                        continue 2;
                    }
                    $aux = b1n_crypt($value);
                    break;
                default:
                    $aux = $value;
                    break;
            }
            // Only update if the values changed ($aux != $old...)
            if ($aux != $old_values[$r['db']]) {
                if (b1n_checkFilled($aux)) {
                    $aux = $r['db'] . " = '" . b1n_inBd($aux) . "'";
                } else {
                    $aux = $r['db'] . " = NULL";
                }
                // Setting update array
                $update[] = $aux;
            }
        }
        if (is_array($update)) {
            $update = implode(", ", $update);
            $query = "UPDATE \"" . $table . "\" SET " . $update . " WHERE " . $reg_config['ID']['db'] . " = '" . b1n_inBd($reg_data['id']) . "'";
            $rs = $sql->query($query);
        } else {
            $rs = true;
        }
        if ($rs) {
            $aux = true;
            if (!empty($module_function)) {
                $reg_data['old_values'] = $old_values;
                $aux = $module_function($sql, $ret_msgs, $reg_data, $reg_config);
            }
            if ($aux) {
                b1n_retMsg($ret_msgs, b1n_SUCCESS, $msg . ' changed successfully!');
                return $sql->query('COMMIT TRANSACTION');
            }
        }
    } else {
        b1n_retMsg($ret_msgs, b1n_FIZZLES, 'Could not begin transaction.');
    }
    $sql->query('ROLLBACK TRANSACTION');
    return false;
}