Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */
/*********************************************************************************
 * Description:
 ********************************************************************************/

$focus = BeanFactory::newBean('CustomQueries');

if (!empty($_REQUEST['record']) && $_REQUEST['record'] != '') {
    $focus->retrieve($_REQUEST['record']);
    $temp_select = $focus->repair_column_binding();
    unset($temp_select['Remove']);
}

foreach ($_SESSION['old_column_array'] as $key => $value) {
    //eliminate direct matches
    if (!empty($temp_select[$value])) {
        unset($temp_select[$value]);
        //end eliminate direct matches
    }

//check to see if this post select is available
    $temp_var = 'column_' . $key;
    if (!empty($_POST[$temp_var])) {
        //action exists on this old column name
        //run action on this var
        if ($_POST[$temp_var] == 'Remove') {
            //remove layout data for this old column

$focus->remove_layout($value);
        } else {
            //modify this old_column's layout data into the key column data
            $focus->modify_layout($value, $_POST[$temp_var]);

//remove from the temp_select array
            unset($temp_select[$_POST[$temp_var]]);
            //end ifelse remove or edit old column
        }
        //if this was an option selected.
    }

//end foreach
}

//at this point the temp select should only have new columns that are not mapped.  These columns
//need to then be added as layout records for all data sets that use this query
//with custom_layout enable

foreach ($temp_select as $key => $value) {
    $focus->add_column_to_layouts($value);
}

$return_id = $focus->id;
if (isset($_REQUEST['return_module']) && $_REQUEST['return_module'] != '') {
    $return_module = $_REQUEST['return_module'];
} else {
    $return_module = 'CustomQueries';
}
if (isset($_REQUEST['return_action']) && $_REQUEST['return_action'] != '') {
    $return_action = $_REQUEST['return_action'];
} else {
    $return_action = 'DetailView';
}
if (isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != '') {
    $return_id = $_REQUEST['return_id'];
}

$query_data = [
    'action' => $return_action,
    'module' => $return_module,
    'record' => $return_id,
    'old_column_array' => $_SESSION['old_column_array'],
];
if (!empty($_REQUEST['edit'])) {
    $return_id = '';
    $query_data['edit'] = 'true';
}

//cleanup the session variable we have been using to pass the old_column_array information
unset($_SESSION['old_column_array']);
$GLOBALS['log']->debug('Process Bind record with id of ' . $return_id);

$location = 'index.php?' . http_build_query($query_data);
header("Location: $location");