function b1n_regPdfCheckCaterer($sql, &$ret_msgs, $reg_data, $reg_config)
{
$ret = b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
if ($ret) {
$ret = false;
$aux = $reg_data;
if (is_array($aux)) {
// Contacts
array_pop($aux);
// Remarks
array_shift($aux);
foreach ($aux as $x) {
if ($x > 0) {
$ret = true;
break;
}
}
if (!$ret) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "At least, one item must have its quantity greater than 0.");
}
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "No items were found.");
}
}
return $ret;
}
function b1n_regCheckUser($sql, &$ret_msgs, $reg_data, $reg_config)
{
$ret = b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
if ($reg_data["usr_passwd"] != $reg_data["usr_passwd2"]) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, '<b>Password</b> and <b>Confirmation</b> do not match.');
$ret = false;
}
return $ret;
}
function b1n_regCheckPax_vst($sql, &$ret_msgs, $reg_data, $reg_config)
{
$ret = b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
if ($ret) {
$query = "SELECT pvs_id FROM \"pax_vst\" WHERE pax_id = '" . b1n_inBd($reg_data['pax_id']) . "' AND vst_id = '" . b1n_inBd($reg_data['vst_id']) . "'";
$rs = $sql->singleQuery($query);
if (is_array($rs)) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "This combination of <b>Pax</b> and <b>Visa Type</b> already exists.");
$ret = false;
}
}
return $ret;
}
function b1n_regCheckAirport($sql, &$ret_msgs, $reg_data, $reg_config)
{
$ret = b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
if ($ret) {
if ($reg_data['apt_timezone'] > 14 || $reg_data['apt_timezone'] < -12) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, 'Invalid <b>TimeZone</b> (valid values are between +14 and -12).');
$ret = false;
}
$dst_start = mktime(0, 0, 0, $reg_data['apt_dst_start_dt']['month'], $reg_data['apt_dst_start_dt']['day'], $reg_data['apt_dst_start_dt']['year']);
$dst_end = mktime(0, 0, 0, $reg_data['apt_dst_end_dt']['month'], $reg_data['apt_dst_end_dt']['day'], $reg_data['apt_dst_end_dt']['year']);
if ($dst_start > $dst_end) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, '<b>DST Start</b> cannot be bigger than <b>DST End</b>.');
$ret = false;
} elseif (!empty($dst_start['month']) && $dst_start == $dst_end) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, '<b>DST Start</b> cannot be equal to <b>DST End</b>.');
$ret = false;
}
}
return $ret;
}
function b1n_regCheckCitizenship($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckCaterer($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckOccupation($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckService($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckVisatype($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckFile($sql, &$ret_msgs, &$reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config) && b1n_regCheckFileUpload($ret_msgs, $reg_data);
}
function b1n_regCheckOperator($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckGroup($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckLeg($sql, &$ret_msgs, &$reg_data, $reg_config)
{
$ret = b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
// Checking CrewMembers
if ($ret) {
$ret = b1n_regCheckLegCmb($sql, $ret_msgs, $reg_data);
}
if ($ret) {
$ret = false;
// Do we have a valid ETD?
if (b1n_checkDateHour($reg_data['leg_etd_dt']["month"], $reg_data['leg_etd_dt']["day"], $reg_data['leg_etd_dt']["year"], $reg_data['leg_etd_dt']["hour"], $reg_data['leg_etd_dt']["min"], true)) {
// Yes, we do, use it as KeepTrack
$reg_data['leg_keeptrack_dt'] = b1n_formatDateHour($reg_data['leg_etd_dt']);
$ret = true;
} elseif (!empty($reg_data['last_leg_id']) && b1n_checkNumeric($reg_data['last_leg_id'])) {
// The KeepTrack of the current leg is equal to the KeepTrack of the last Leg, Plus its ETE, Plus its groundtime.
$rs = $sql->singleQuery("\n SELECT\n leg_keeptrack_dt::timestamp +\n CASE WHEN (leg_ete_i IS NULL) THEN\n '00:00'::interval\n ELSE\n leg_ete_i::interval\n END +\n CASE WHEN (leg_groundtime_i IS NULL) THEN\n '00:00'::interval\n ELSE\n leg_groundtime_i::interval\n END AS leg_keeptrack_dt\n FROM\n \"leg\"\n WHERE\n leg_id = '" . b1n_inBd($reg_data['last_leg_id']) . "'");
if ($rs && is_array($rs)) {
$reg_data['leg_keeptrack_dt'] = $rs['leg_keeptrack_dt'];
$ret = true;
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, 'Could not keep track of last leg, something really nasty happened here.');
}
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, 'Could not keep track of last leg. Probably this is the very first leg, so, you HAVE to fill the <b>ETD</b> field.');
}
}
return $ret;
}
function b1n_regCheckContact($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
function b1n_regCheckAircraft($sql, &$ret_msgs, $reg_data, $reg_config)
{
return b1n_regCheck($sql, $ret_msgs, $reg_data, $reg_config);
}
