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");
}
