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.
 */
//Check if current user has admin access
if (is_admin($current_user)) {
 global $mod_strings;

//echo out processing message
 echo ' ' . htmlspecialchars($mod_strings['LBL_REPAIR_FIELD_CASING_PROCESSING'], ENT_COMPAT);

//store the affected entries
    $database_entries = [];
    $module_entries = [];

$query = 'SELECT * FROM fields_meta_data';
    $result = $GLOBALS['db']->query($query);
    while ($row = $GLOBALS['db']->fetchByAssoc($result)) {
        $name = $row['name'];
        $id = $row['id'];
        $module_entries[$row['custom_module']] = true;

//Only run database SQL where the name or id casing does is not lowercased
        if ($name != strtolower($row['name'])) {
            $database_entries[$row['custom_module']][$name] = $row;
        }
    }

//If we have database entries to process
    if (!empty($database_entries)) {
        foreach ($database_entries as $module => $entries) {
            $table_name = strtolower($module) . '_cstm';

foreach ($entries as $original_col_name => $entry) {
 echo ' ' . htmlspecialchars(string_format($mod_strings['LBL_REPAIR_FIELD_CASING_SQL_FIELD_META_DATA'], [$entry['name']]), ENT_COMPAT);
 $GLOBALS['db']->getConnection()
 ->update(
 'fields_meta_data',
 [
 'id' => $entry['custom_module'] . strtolower($entry['name']),
 'name' => strtolower($entry['name']),
 ],
 ['id' => $entry['id']]
 );
 echo ' ' . htmlspecialchars(string_format($mod_strings['LBL_REPAIR_FIELD_CASING_SQL_CUSTOM_TABLE'], [$entry['name'], $table_name]), ENT_COMPAT);

$GLOBALS['db']->query($GLOBALS['db']->renameColumnSQL($table_name, $entry['name'], strtolower($entry['name'])));
            }
        }
    }

//If we have metadata files to alter
    if (!empty($module_entries)) {
        $modules = array_keys($module_entries);
        $views = ['basic_search', 'advanced_search', 'detailview', 'editview', 'quickcreate'];
        $class_names = [];

foreach ($modules as $module) {
            if (isset($GLOBALS['beanList'][$module])) {
                $class_names[] = $GLOBALS['beanList'][$module];
            }

foreach ($views as $view) {
                try {
                    $parser = ParserFactory::getParser($view, $module);
                } catch (Exception $e) {
                    $GLOBALS['log']->fatal('Caught exception in RepairFieldCasing script: ' . $e->getMessage());
                    continue;
                }
                if (isset($parser->_viewdefs['panels'])) {
                    foreach ($parser->_viewdefs['panels'] as $panel_id => $panel) {
                        foreach ($panel as $row_id => $row) {
                            foreach ($row as $entry_id => $entry) {
                                if (is_array($entry) && isset($entry['name'])) {
                                    $parser->_viewdefs['panels'][$panel_id][$row_id][$entry_id]['name'] = is_scalar($entry['name']) ? strtolower($entry['name']) : null;
                                    if (!is_scalar($entry['name'])) {
                                        LoggerManager::getLogger()->warn(
                                            sprintf('scalar expected, "%s" given', gettype($entry['name']))
                                            . PHP_EOL . (new Exception())->getTraceAsString()
                                        );
                                    }
                                }
                            }
                        }
                    }
                } else {
                    //For basic_search and advanced_search views, just process the fields
                    foreach ($parser->_viewdefs as $entry_id => $entry) {
                        if (is_array($entry) && isset($entry['name'])) {
                            $parser->_viewdefs[$entry_id]['name'] = is_scalar($entry['name']) ? strtolower($entry['name']) : null;
                            if (!is_scalar($entry['name'])) {
                                LoggerManager::getLogger()->fatal(
                                    sprintf('scalar expected, "%s" given', gettype($entry['name']))
                                    . PHP_EOL . (new Exception())->getTraceAsString()
                                );
                            }
                        }
                    }
                }

//Save the changes
                $parser->handleSave(false);
            } //foreach

//Now clear the cache of the .tpl files
            TemplateHandler::clearCache($module);
        } //foreach

echo ' ' . htmlspecialchars($mod_strings['LBL_CLEAR_VARDEFS_DATA_CACHE_TITLE'], ENT_COMPAT);
 $repair = new RepairAndClear();
 $repair->show_output = false;
 $repair->module_list = [$class_names];
 $repair->clearVardefs();
 }

echo ' ' . htmlspecialchars($mod_strings['LBL_DIAGNOSTIC_DONE'], ENT_COMPAT);
}