function b1n_regLoadGroup($sql, &$ret_msgs, &$reg_data, $reg_config) { $ret = b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "group"); $reg_data["functions"] = array(); $reg_data["users"] = array(); /* Functions */ $query = "SELECT DISTINCT fnc_id FROM \"grp_fnc\" WHERE grp_id = '" . b1n_inBd($reg_data['id']) . "'"; $rs = $sql->query($query); if ($rs && is_array($rs)) { foreach ($rs as $i) { array_push($reg_data['functions'], $i['fnc_id']); } } else { $ret = false; } /* Users */ $query = "SELECT DISTINCT usr_id FROM \"grp_usr\" WHERE grp_id = '" . b1n_inBd($reg_data['id']) . "'"; $rs = $sql->query($query); if ($rs && is_array($rs)) { foreach ($rs as $i) { array_push($reg_data['users'], $i['usr_id']); } } else { $ret = false; } return $ret; }
function b1n_regLoadLink($sql, &$ret_msgs, &$reg_data, $reg_config) { // Testing if the link really belongs to the current user $rs = $sql->singleQuery("SELECT COUNT(lnk_id) AS c FROM \"link\" WHERE usr_id = '" . b1n_inBd($_SESSION['user']['usr_id']) . "' AND lnk_id = '" . b1n_inBd($reg_data['id']) . "'"); if ($rs['c'] == '1') { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "link"); } else { b1n_retMsg($ret_msgs, b1n_FIZZLES, "This Link does not belongs to you, What are you Trying to Do?"); return false; } }
function b1n_regLoadFoodtype($sql, &$ret_msgs, &$reg_data, $reg_config) { $ret = b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "foodtype"); $reg_data["foods"] = array(); /* Foods */ $query = "SELECT DISTINCT fod_id FROM \"fdt_fod\" WHERE fdt_id = '" . b1n_inBd($reg_data['id']) . "'"; $rs = $sql->query($query); if ($rs) { if (is_array($rs)) { foreach ($rs as $i) { array_push($reg_data['foods'], $i['fod_id']); } } } else { $ret = false; } return $ret; }
function b1n_regLoadCaterer($sql, &$ret_msgs, &$reg_data, $reg_config) { $ret = b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "caterer"); $reg_data["airports"] = array(); $reg_data["contacts"] = array(); /* Contacts */ $query = "SELECT DISTINCT ctc_id FROM \"cat_ctc\" WHERE cat_id = '" . b1n_inBd($reg_data['id']) . "'"; $rs = $sql->query($query); if ($rs) { if (is_array($rs)) { foreach ($rs as $i) { array_push($reg_data['contacts'], $i['ctc_id']); } } } else { $ret = false; } return $ret; }
function b1n_regLoadPax($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "pax"); }
function b1n_regLoadOccupation($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "occupation"); }
function b1n_regLoadService($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "service"); }
function b1n_regLoadVisatype($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "visatype"); }
function b1n_regLoadFile($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "file"); }
function b1n_regLoadAirport($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "airport"); }
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; }
function b1n_regLoadCmb($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "cmb"); }
function b1n_regLoadContact($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "contact"); }
function b1n_regLoadCountry($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "country"); }
function b1n_regLoadUser($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "user"); }
function b1n_regLoadCitizenship($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "citizenship"); }
function b1n_regLoadOperator($sql, &$ret_msgs, &$reg_data, $reg_config) { return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "operator"); }