Beispiel #1
0
function b1n_regCheckDeleteCitizenship($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Crew Member', 'as' => '', 'table' => 'cmb', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'cmb_id', 'col_name' => 'cmb_name'), array('title' => 'Pax', 'as' => '', 'table' => 'pax', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'pax_id', 'col_name' => 'pax_name'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'citizenship', $reg_config['ID']['db'], 'cts_name', 'Citizenship');
    }
    return $ret;
}
Beispiel #2
0
function b1n_regCheckDeleteOccupation($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Crew Member', 'as' => '', 'table' => 'cmb', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'cmb_id', 'col_name' => 'cmb_name'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'occupation', $reg_config['ID']['db'], 'occ_name', 'Occupation');
    }
    return $ret;
}
Beispiel #3
0
function b1n_regCheckDeleteCaterer($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Airport', 'as' => '', 'table' => 'airport', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'apt_id', 'col_name' => 'apt_name'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'caterer', $reg_config['ID']['db'], 'cat_name', 'Caterer');
    }
    return $ret;
}
Beispiel #4
0
function b1n_regCheckDeleteOperator($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Aircraft', 'as' => '', 'table' => 'aircraft', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'acf_id', 'col_name' => 'acf_model'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'operator', $reg_config['ID']['db'], 'opr_name', 'Operator');
    }
    return $ret;
}
Beispiel #5
0
function b1n_regCheckDeleteCmb($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Leg', 'as' => 'PIC', 'table' => 'leg', 'col_ref_id' => 'cmb_id_pic', 'col_id' => 'leg_id', 'col_name' => 'leg_id'), array('title' => 'Leg', 'as' => 'SIC', 'table' => 'leg', 'col_ref_id' => 'cmb_id_sic', 'col_id' => 'leg_id', 'col_name' => 'leg_id'), array('title' => 'Leg', 'as' => 'Extra1', 'table' => 'leg', 'col_ref_id' => 'cmb_id_extra1', 'col_id' => 'leg_id', 'col_name' => 'leg_id'), array('title' => 'Leg', 'as' => 'Extra2', 'table' => 'leg', 'col_ref_id' => 'cmb_id_extra2', 'col_id' => 'leg_id', 'col_name' => 'leg_id'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'cmb', $reg_config['ID']['db'], 'cmb_name', 'Crew Member');
    }
    return $ret;
}
Beispiel #6
0
function b1n_regCheckDeleteCountry($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Airport', 'as' => '', 'table' => 'airport', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'apt_id', 'col_name' => 'apt_name'), array('title' => 'Operator', 'as' => '', 'table' => 'operator', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'opr_id', 'col_name' => 'opr_name'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'country', $reg_config['ID']['db'], 'cty_name', 'Country');
    }
    return $ret;
}
Beispiel #7
0
function b1n_regCheckDeleteAirport($sql, &$ret_msgs, $reg_data, $reg_config)
{
    $ret = b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
    if ($ret) {
        $rel = array(array('title' => 'Aircraft', 'as' => 'HomeBase', 'table' => 'aircraft', 'col_ref_id' => $reg_config['ID']['db'], 'col_id' => 'acf_id', 'col_name' => 'acf_model'), array('title' => 'Leg', 'as' => 'Depart Airport', 'table' => 'leg', 'col_ref_id' => 'apt_id_depart', 'col_id' => 'leg_id', 'col_name' => 'leg_id'), array('title' => 'Leg', 'as' => 'Arrive Airport', 'table' => 'leg', 'col_ref_id' => 'apt_id_arrive', 'col_id' => 'leg_id', 'col_name' => 'leg_id'));
        $ret = b1n_regCheckRelationship($sql, $ret_msgs, $reg_data['ids'], $rel, 'airport', $reg_config['ID']['db'], 'apt_name', 'Airport');
    }
    return $ret;
}
Beispiel #8
0
function b1n_regCheckDeletePax($sql, &$ret_msgs, $reg_data, $reg_config)
{
    return b1n_regCheckDelete($sql, $ret_msgs, $reg_data, $reg_config);
}