salesagility_SuiteCRM/tests/unit/phpunit/data/SugarBeanTest.php

<?php
include_once __DIR__ . '/SugarBeanMock.php';
include_once __DIR__ . '/../../../../include/SubPanel/SubPanelDefinitions.php';
include_once __DIR__ . '/../../../../modules/Campaigns/ProspectLink.php';
include_once __DIR__ . '/../../../../modules/AM_ProjectTemplates/AM_ProjectTemplates_sugar.php';

use SuiteCRM\Test\SuitePHPUnitFrameworkTestCase;
use SuiteCRM\Utility\SuiteValidator;

class SugarBeanTest extends SuitePHPUnitFrameworkTestCase
{
    /**
     * @var array
     */
    protected $fieldDefsStore;

    protected function setUp(): void
    {
        parent::setUp();
        $this->fieldDefsStore();
    }

    protected function tearDown(): void
    {
        $this->fieldDefsRestore();
        parent::tearDown();
    }

    /**
     * Store static field_defs per modules
     * @param string $key
     */
    protected function fieldDefsStore($key = 'base'): void
    {
        $this->fieldDefsStore[$key]['Contact'] = BeanFactory::newBean('Contacts')->field_defs;
    }

    /**
     * Restore static field_defs per modules
     * @param string $key
     */
    protected function fieldDefsRestore($key = 'base'): void
    {
        $object = BeanFactory::newBean('Contacts');
        $object->field_defs = $this->fieldDefsStore[$key]['Contact'];
    }

    public function testFactoryGetCachedDeleted(): void
    {
        // Create a lead and cache it
        $lead = BeanFactory::newBean('Leads');
        $lead->save();

        $bean = BeanFactory::getBean($lead->module_dir, $lead->id);
        self::assertNotEmpty($bean);

        // Don't return a cached result if the bean was deleted
        $lead->mark_deleted($lead->id);
        self::assertEmpty(BeanFactory::getBean($lead->module_dir, $lead->id));
        // Unless explicitly specified
        self::assertNotEmpty(BeanFactory::getBean($lead->module_dir, $lead->id, [], false));
    }

    protected function getModuleBean($module)
    {
        $object = BeanFactory::getBean($module);
        if (!$object) {
            if (!class_exists($module)) {
                throw new Exception('Module bean retrieve error: ' . $module);
            }
            $object = new $module();
        }
        return $object;
    }
    /**
     * @see SugarBean::__construct()
     */
    public function testConstruct(): void
    {
        global $dictionary;

        $GLOBALS['reload_vardefs'] = false;

        // test dup3
        include_once __DIR__ . '/../../../../modules/AM_ProjectTemplates/AM_ProjectTemplates_sugar.php';
        $bean = BeanFactory::getBean('AM_ProjectTemplates');
        self::assertInstanceOf(DBManager::class, $bean->db);
        self::assertEquals('AM_ProjectTemplates', $bean->module_name);
        self::assertEquals(array(
            'id' => 1,
            'name' => 1,
        ), $bean->required_fields);
        self::assertInstanceOf(DynamicField::class, $bean->custom_fields);
        self::assertEquals(false, $bean->custom_fields->use_existing_labels);
        self::assertEquals('custom/Extension/modules/AM_ProjectTemplates/Ext/Vardefs', $bean->custom_fields->base_path);
        self::assertSame(DBManagerFactory::getInstance(), $bean->custom_fields->db);
        self::assertSame($bean, $bean->custom_fields->bean);
        self::assertEquals('AM_ProjectTemplates', $bean->custom_fields->module);
        self::assertEquals(array(
            0 => 'id',
            1 => 'name',
            2 => 'date_entered',
            3 => 'date_modified',
            4 => 'modified_user_id',
            5 => 'modified_by_name',
            6 => 'created_by',
            7 => 'created_by_name',
            8 => 'description',
            9 => 'deleted',
            10 => 'created_by_link',
            11 => 'modified_user_link',
            12 => 'assigned_user_id',
            13 => 'assigned_user_name',
            14 => 'assigned_user_link',
            15 => 'status',
            16 => 'priority',
            17 => 'am_projecttemplates_project_1',
            18 => 'am_tasktemplates_am_projecttemplates',
            19 => 'am_projecttemplates_users_1',
            20 => 'am_projecttemplates_contacts_1',
            21 => 'override_business_hours',
        ), $bean->column_fields);

        $keys = array_keys($bean->field_name_map);
        self::assertEquals(array(
            0 => 'id',
            1 => 'name',
            2 => 'date_entered',
            3 => 'date_modified',
            4 => 'modified_user_id',
            5 => 'modified_by_name',
            6 => 'created_by',
            7 => 'created_by_name',
            8 => 'description',
            9 => 'deleted',
            10 => 'created_by_link',
            11 => 'modified_user_link',
            12 => 'assigned_user_id',
            13 => 'assigned_user_name',
            14 => 'assigned_user_link',
            15 => 'status',
            16 => 'priority',
            17 => 'am_projecttemplates_project_1',
            18 => 'am_tasktemplates_am_projecttemplates',
            19 => 'am_projecttemplates_users_1',
            20 => 'am_projecttemplates_contacts_1',
            21 => 'override_business_hours',
        ), $keys);

        self::assertEquals($keys, array_keys($bean->field_defs));
        self::assertEquals(true, $bean->optimistic_lock);
        self::assertEquals(array(), $bean->list_fields);
        self::assertEquals(true, $bean->acl_fields);


        // test

        $bean = BeanFactory::getBean('Users');
        self::assertInstanceOf(DBManager::class, $bean->db);
        self::assertEquals('Users', $bean->module_name);
        self::assertNotTrue(!isset($bean->required_fields));
        self::assertInstanceOf(DynamicField::class, $bean->custom_fields);
        self::assertEquals(false, $bean->custom_fields->use_existing_labels);
        self::assertEquals('custom/Extension/modules/Users/Ext/Vardefs', $bean->custom_fields->base_path);
        self::assertSame(DBManagerFactory::getInstance(), $bean->custom_fields->db);
        self::assertSame($bean, $bean->custom_fields->bean);
        self::assertNotEquals('', $bean->custom_fields->module);
        self::assertNotEquals(array(), $bean->column_fields);
        self::assertNotEquals('', $bean->field_name_map);
        self::assertNotEquals('', $bean->field_defs);
        self::assertEquals('', $bean->optimistic_lock);
        self::assertEquals(array(), $bean->list_fields);
        self::assertTrue(isset($bean->added_custom_field_defs));
        self::assertTrue(isset($bean->acl_fields));

        // test
        $GLOBALS['reload_vardefs'] = false;
        $bean = BeanFactory::getBean('Users');
        self::assertInstanceOf(DBManager::class, $bean->db);
        self::assertNotEquals('', $bean->module_name);
        self::assertTrue(isset($bean->required_fields));
        self::assertInstanceOf(DynamicField::class, $bean->custom_fields);
        self::assertFalse($bean->custom_fields->use_existing_labels);
        self::assertEquals('custom/Extension/modules/Users/Ext/Vardefs', $bean->custom_fields->base_path);
        self::assertSame(DBManagerFactory::getInstance(), $bean->custom_fields->db);
        self::assertSame($bean, $bean->custom_fields->bean);
        self::assertNotEquals('', $bean->custom_fields->module);
        self::assertNotEquals(array(), $bean->column_fields);
        self::assertNotEquals('', $bean->field_name_map);
        self::assertNotEquals('', $bean->field_defs);
        self::assertEquals(array(), $bean->list_fields);
        self::assertTrue($bean->added_custom_field_defs);
        self::assertTrue(isset($bean->acl_fields));

        // test

        $fields = [
            0 => 'id',
            1 => 'user_name',
            2 => 'user_hash',
            3 => 'system_generated_password',
            4 => 'pwd_last_changed',
            5 => 'authenticate_id',
            6 => 'sugar_login',
            7 => 'first_name',
            8 => 'last_name',
            9 => 'full_name',
            10 => 'name',
            11 => 'is_admin',
            12 => 'external_auth_only',
            13 => 'receive_notifications',
            14 => 'description',
            15 => 'date_entered',
            16 => 'date_modified',
            17 => 'modified_user_id',
            18 => 'modified_by_name',
            19 => 'created_by',
            20 => 'created_by_name',
            21 => 'title',
            22 => 'photo',
            23 => 'department',
            24 => 'phone_home',
            25 => 'phone_mobile',
            26 => 'phone_work',
            27 => 'phone_other',
            28 => 'phone_fax',
            29 => 'status',
            30 => 'address_street',
            31 => 'address_city',
            32 => 'address_state',
            33 => 'address_country',
            34 => 'address_postalcode',
            35 => 'UserType',
            36 => 'deleted',
            37 => 'portal_only',
            38 => 'show_on_employees',
            39 => 'employee_status',
            40 => 'messenger_id',
            41 => 'messenger_type',
            42 => 'calls',
            43 => 'meetings',
            44 => 'contacts_sync',
            45 => 'reports_to_id',
            46 => 'reports_to_name',
            47 => 'reports_to_link',
            48 => 'reportees',
            49 => 'email1',
            50 => 'email_addresses',
            51 => 'email_addresses_primary',
            52 => 'email_link_type',
            53 => 'editor_type',
            54 => 'aclroles',
            55 => 'is_group',
            56 => 'c_accept_status_fields',
            57 => 'm_accept_status_fields',
            58 => 'accept_status_id',
            59 => 'accept_status_name',
            60 => 'prospect_lists',
            61 => 'emails_users',
            62 => 'eapm',
            63 => 'oauth_tokens',
            64 => 'project_resource',
            65 => 'project_users_1',
            66 => 'am_projecttemplates_resources',
            67 => 'am_projecttemplates_users_1',
            68 => 'SecurityGroups',
            69 => 'securitygroup_noninher_fields',
            70 => 'securitygroup_noninherit_id',
            71 => 'securitygroup_noninheritable',
            72 => 'securitygroup_primary_group',
            73 => 'factor_auth',
            74 => 'factor_auth_interface',
        ];

        $GLOBALS['reload_vardefs'] = true;
        $dictionary['']['fields'] = $dictionary['User']['fields'];
        $bean = BeanFactory::getBean('Users');
        self::assertInstanceOf(DBManager::class, $bean->db);
        self::assertNotEquals('', $bean->module_name);
        self::assertTrue(isset($bean->required_fields));
        self::assertEquals(array(
            'id' => 1,
            'user_name' => 1,
            'system_generated_password' => 1,
            'last_name' => 1,
            'date_entered' => 1,
            'date_modified' => 1,
            'status' => 1,
            'email1' => 1,
            'email_addresses' => 1,
            'email_addresses_primary' => 1,
        ), $bean->required_fields);
        self::assertInstanceOf(DynamicField::class, $bean->custom_fields);
        self::assertEquals(false, $bean->custom_fields->use_existing_labels);
        self::assertEquals('custom/Extension/modules/Users/Ext/Vardefs', $bean->custom_fields->base_path);
        self::assertSame(DBManagerFactory::getInstance(), $bean->custom_fields->db);
        self::assertSame($bean, $bean->custom_fields->bean);
        self::assertEquals('Users', $bean->custom_fields->module);

        foreach($fields as $field){
            self::assertContains($field, $bean->column_fields);
        }

        $keys = array_keys($bean->field_name_map);
        self::assertEquals($bean->column_fields, $keys);

        $keys = array_keys($bean->field_defs);
        self::assertEquals($bean->column_fields, $keys);

        self::assertEquals('', $bean->optimistic_lock);
        self::assertEquals(array(), $bean->list_fields);
        self::assertNotTrue(isset($bean->added_custom_field_defs));
        self::assertTrue(isset($bean->acl_fields));


        // test
        $GLOBALS['reload_vardefs'] = true;
        $dictionary['']['fields'] = $dictionary['User']['fields'];
        $dictionary['']['optimistic_locking'] = true;
        $bean = BeanFactory::getBean('Users');
        self::assertInstanceOf(DBManager::class, $bean->db);
        self::assertNotEquals('', $bean->module_name);
        self::assertTrue(isset($bean->required_fields));
        self::assertEquals(array(
            'id' => 1,
            'user_name' => 1,
            'system_generated_password' => 1,
            'last_name' => 1,
            'date_entered' => 1,
            'date_modified' => 1,
            'status' => 1,
            'email1' => 1,
            'email_addresses' => 1,
            'email_addresses_primary' => 1,
        ), $bean->required_fields);
        self::assertInstanceOf(DynamicField::class, $bean->custom_fields);
        self::assertEquals(false, $bean->custom_fields->use_existing_labels);
        self::assertEquals('custom/Extension/modules/Users/Ext/Vardefs', $bean->custom_fields->base_path);
        self::assertSame(DBManagerFactory::getInstance(), $bean->custom_fields->db);
        self::assertSame($bean, $bean->custom_fields->bean);
        self::assertEquals('Users', $bean->custom_fields->module);

        foreach($fields as $field){
            self::assertContains($field, $bean->column_fields);
        }

        $keys = array_keys($bean->field_name_map);
        self::assertEquals($bean->column_fields, $keys);

        $keys = array_keys($bean->field_defs);
        self::assertEquals($bean->column_fields, $keys);

        self::assertNotEquals(true, $bean->optimistic_lock);
        self::assertEquals(array(), $bean->list_fields);
        self::assertNotTrue(isset($bean->added_custom_field_defs));
        self::assertTrue(isset($bean->acl_fields));

    }

    /**
     * @see SugarBean::setupCustomFields()
     */
    public function testSetupCustomFields(): void
    {
        $bean = BeanFactory::getBean('Users');

        // test
        $bean->setupCustomFields('test');
        self::assertEquals('custom/Extension/modules/test/Ext/Vardefs', $bean->custom_fields->base_path);

        // test
        $bean->setupCustomFields('Users');
        self::assertEquals('custom/Extension/modules/Users/Ext/Vardefs', $bean->custom_fields->base_path);
    }

    /**
     * @see SugarBean::bean_implements()
     */
    public function testBeanImplements(): void
    {
        // test
        $results = BeanFactory::getBean('Users')->bean_implements('test');
        self::assertEquals(false, $results);
    }

    /**
     * @see SugarBean::populateDefaultValues()
     */
    public function testPopulateDefaultValues(): void
    {
        $testBean1 = BeanFactory::getBean('Users');
        $origFieldDefs = $testBean1->field_defs;

        $testBean1->field_defs = null;
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $testBean1->populateDefaultValues();
        self::assertEquals(null, $results);
        self::assertEquals(null, $testBean1->field_defs);

        // test
        $bean = BeanFactory::getBean('Users');
        $force = false;
        $fieldDefsBefore = $bean->field_defs;
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->populateDefaultValues($force);
        self::assertEquals(null, $results);
        self::assertEquals($fieldDefsBefore, $bean->field_defs);


        // test
        $bean = BeanFactory::getBean('Users');
        $force = true;
        $bean->field_defs['test'] = array(
            'default' => true,
        );
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->populateDefaultValues($force);
        self::assertEquals(null, $results);
        self::assertEquals(array(
            'test' => array(
                'default' => true,
            ),
        ), $bean->field_defs);


        // test
        $bean = BeanFactory::getBean('Users');
        $force = true;
        $bean->field_defs['test'] = array(
            'default' => true,
        );
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->populateDefaultValues($force);
        self::assertEquals(null, $results);
        self::assertEquals(array(
            'test' => array(
                'default' => true,
            ),
        ), $bean->field_defs);
        $field = 'test';
        self::assertEquals(1, $bean->$field);


        // test
        $bean = BeanFactory::getBean('Users');
        $force = true;
        $bean->field_defs['test'] = array(
            'default' => '',
        );
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->populateDefaultValues($force);
        self::assertEquals(null, $results);
        self::assertEquals(array(
            'test' => array(
                'default' => '',
            ),
        ), $bean->field_defs);
        $field = 'test';
        self::assertEquals('', $bean->$field);

        $bean->field_defs = $origFieldDefs;
    }

    /**
     * @see SugarBean::parseDateDefault()
     */
    public function testParseDateDefault(): void
    {
        $bean = new SugarBeanMock();


        // test
        $results = $bean->publicParseDateDefault('2015-05-05');
        self::assertEquals('05/05/2015', $results);

        // test
        $results = $bean->publicParseDateDefault('2015-05-05', true);
        self::assertNotEquals('05/05/2015', $results);
        self::assertMatchesRegularExpression('/05\/05\/2015 \d{2}:\d{2}/', $results);

        // test
        $results = $bean->publicParseDateDefault('2015-05-05 11:11', true);
        self::assertEquals('05/05/2015 11:11', $results);

        // test
        $results = $bean->publicParseDateDefault('2015-05-05&11:11', true);
        self::assertEquals('05/05/2015 11:11', $results);
    }

    /**
     * @see SugarBean::removeRelationshipMeta()
     */
    public function testRemoveRelationshipMeta(): void
    {
        // test
        $GLOBALS['log']->reset();
        SugarBean::removeRelationshipMeta(null, null, null, null, null);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        SugarBean::removeRelationshipMeta(null, null, null, null, 'Contacts');
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        SugarBean::removeRelationshipMeta('key', null, null, array('key' => 'value'), 'Tests');
        self::assertNotTrue(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        SugarBean::removeRelationshipMeta('key', null, null, array(
            'key' => array(
                'relationships' => true,
            ),
        ), 'Tests');
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::createRelationshipMeta()
     */
    public function testCreateRelationshipMeta(): void
    {
        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta(null, null, null, array(), null);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta(null, null, null, array(), 'Contacts');
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta(null, null, null, array(), 'Contacts', true);
        self::assertCount(1, $GLOBALS['log']->calls['fatal'] ?? []);

        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta('User', null, null, array(), 'Contacts');
        self::assertCount(8, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta('User', $this->db, null, array(), 'Contacts');
        self::assertNotTrue(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta('Nonexists1', $this->db, null, array(), 'Nonexists2');
        self::assertCount(1, $GLOBALS['log']->calls['debug']);

        // test
        $GLOBALS['log']->reset();
        SugarBean::createRelationshipMeta('User', null, null, array(), 'Contacts');
        self::assertCount(8, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::get_union_related_list()
     * @todo need more test coverage and less function complexity
     */
    public function testGetUnionRelatedList(): void
    {
        $request = $_REQUEST;
        self::assertFalse(isset($_SESSION));

        // test
        $GLOBALS['log']->reset();
        $results = SugarBean::get_union_related_list(null);
        self::assertCount(3, $GLOBALS['log']->calls['fatal']);
        self::assertEquals(null, $results);


        // test
        $GLOBALS['log']->reset();
        $_SESSION['show_deleted'] = 1;
        $results = SugarBean::get_union_related_list(null);
        self::assertCount(3, $GLOBALS['log']->calls['fatal']);
        self::assertEquals(null, $results);


        // test
        $GLOBALS['log']->reset();
        $_SESSION['show_deleted'] = 1;
        $parentBean = new SugarBeanMock();
        $subPanelDef = new aSubPanel(null, null, $parentBean);
        $results = SugarBean::get_union_related_list($parentBean, '', '', '', 0, -1, -1, 0, $subPanelDef);
        self::assertEquals(array(
            'list' => array(),
            'parent_data' => array(),
            'row_count' => 0,
            'next_offset' => 10,
            'previous_offset' => -10,
            'current_offset' => 0,
            'query' => '',
        ), $results);


        // test
        $GLOBALS['log']->reset();
        $subPanelDef->_instance_properties['type'] = 'collection';
        $results = SugarBean::get_union_related_list($parentBean, '', '', '', 0, -1, -1, 0, $subPanelDef);
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);
        self::assertEquals(array(
            'list' => array(),
            'parent_data' => array(),
            'row_count' => 0,
            'next_offset' => 10,
            'previous_offset' => -10,
            'current_offset' => 0,
            'query' => '',
        ), $results);


        // test
        $GLOBALS['log']->reset();
        $_SESSION['show_deleted'] = 1;
        $parentBean = new SugarBeanMock();
        $subPanelDef = new aSubPanel(null, null, $parentBean);
        $subPanelDef->_instance_properties['type'] = 'collection';
        $subPanelDef->_instance_properties['collection_list'] = array(
            array('module' => 'Contacts'),
        );
        $subPanelDef->_instance_properties['get_subpanel_data'] = 'function';
        $subPanelDef->_instance_properties['generate_select'] = array();
        $results = SugarBean::get_union_related_list($parentBean, '', '', '', 0, -1, -1, 0, $subPanelDef);

        self::assertEquals(array(
            'list' => array(),
            'parent_data' => array(),
            'row_count' => 0,
            'next_offset' => 10,
            'previous_offset' => -10,
            'current_offset' => 0,
            'query' => '',
        ), $results);

        $_REQUEST = $request;
        unset($_SESSION);
    }

    /**
     * @see SugarBean::build_sub_queries_for_union()
     */
    public function testBuildSubQueriesForUnion(): void
    {
        // test
        $bean = new SugarBeanMock();
        $panel =
            new aSubPanel('Test', array(
                'get_subpanel_data' => 1,
            ), $bean);
        $subpanel_list = array(
            $panel
        );
        $subpanel_def = null;
        $parentBean = new SugarBeanMock();
        $order_by = null;
        $GLOBALS['log']->reset();
        $results = SugarBeanMock::publicBuildSubQueriesForUnion($subpanel_list, $subpanel_def, $parentBean, $order_by);
        self::assertEquals(array(), $results);
        self::assertNotTrue(isset($GLOBALS['log']->calls['fatal']));


        // test
        $subpanel_list = array(
            new aSubPanel('Test', array(), new SugarBeanMock())
        );
        $subpanel_def = null;
        $parentBean = null;
        $order_by = null;
        $GLOBALS['log']->reset();
        $results = SugarBeanMock::publicBuildSubQueriesForUnion($subpanel_list, $subpanel_def, $parentBean, $order_by);
        self::assertEquals(array(
            array(
                'select' => ' , \'Test\' panel_name ',
                'query_array' => null,
                'params' => array(
                    'distinct' => false,
                    'joined_tables' => null,
                    'include_custom_fields' => null,
                    'collection_list' => null,
                ),
            ),
        ), $results);
        self::assertCount(6, $GLOBALS['log']->calls['fatal']);


        // test
        $subpanel_list = array(
            1
        );
        $subpanel_def = null;
        $parentBean = null;
        $order_by = null;
        $GLOBALS['log']->reset();
        $results = SugarBeanMock::publicBuildSubQueriesForUnion($subpanel_list, $subpanel_def, $parentBean, $order_by);
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);


        // test
        $subpanel_list = null;
        $subpanel_def = null;
        $parentBean = null;
        $order_by = null;
        $GLOBALS['log']->reset();
        $results = SugarBeanMock::publicBuildSubQueriesForUnion($subpanel_list, $subpanel_def, $parentBean, $order_by);
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::process_union_list_query()
     */
    public function testProcessUnionListQuery(): void
    {
        self::markTestIncomplete('environment dependency');

        // test
        global $sugar_config;

        $query = "SELECT * FROM aod_index";
        $resource = DBManagerFactory::getInstance()->query($query);
        $rows = [];
        while ($row = $resource->fetch_assoc()) {
            $rows[] = $row;
        }
        $tableAodIndex = $rows;

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang sql */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $tmp = $sugar_config['list_max_entries_per_subpanel'];
        $sugar_config['list_max_entries_per_subpanel'] = 0;
        $results = $bean->process_union_list_query($bean, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, 0, -1, '', $subpanelDefinition);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));

        self::assertEquals(array(), $results['list']);
        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(0, $results['next_offset']);
        self::assertEquals(0, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang sql */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $sugar_config['list_max_entries_per_subpanel'] = $tmp;


        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang sql */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $subpanelDefinition->_instance_properties['type'] = 'collection';
        $results = $bean->process_union_list_query($bean, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));

        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang text */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $subpanelDefinition->_instance_properties['type'] = 'collection';
        $results = $bean->process_union_list_query($bean, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));
        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang text */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $subpanelDefinition->_instance_properties['type'] = 'collection';
        $results = $bean->process_union_list_query($bean, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);

        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang text */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $results = $bean->process_union_list_query($bean, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);

        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang text */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $subpanelDefinition->template_instance = $bean;
        $results = $bean->process_union_list_query($bean, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);

        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang text */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $results = $bean->process_union_list_query(null, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);

        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact1';
        $bean->save();
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $results = $bean->process_union_list_query(null, /** @lang sql */
            'SELECT DISTINCT * FROM contacts', null, -1, -1, '', $subpanelDefinition);
        self::assertEquals(array(), $results['parent_data']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT * FROM contacts',
            $results['query']
        );


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact1';
        $bean->save();
        $results = $bean->process_union_list_query(null, /** @lang sql */
            'SELECT DISTINCT * FROM contacts', null);
        self::assertEquals(array(), $results['parent_data']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT * FROM contacts',
            $results['query']
        );


        // test
        $GLOBALS['log']->reset();
        $bean = new SugarBeanMock();
        try {
            $results = $bean->process_union_list_query(null, 'DISTINCT', null);
            self::assertTrue(false);
        } catch (Exception $e) {
            self::assertTrue(true);
            self::assertEquals(1, $e->getCode());
        }
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));
        self::assertEquals(array(), $results['parent_data']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT * FROM contacts',
            $results['query']
        );


        // test
        $GLOBALS['log']->reset();
        $bean = new SugarBeanMock();
        $results = $bean->process_union_list_query(null, null, null);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));
        self::assertEquals(array(), $results['parent_data']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            null,
            $results['query']
        );


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->retrieve('test_contact1');
        $results = $bean->process_union_list_query(null, /** @lang sql */
            'SELECT DISTINCT * FROM contacts', 'end');

        self::assertEquals(array(), $results['parent_data']);
        self::assertEquals(9.0, $results['next_offset']);
        self::assertEquals(-11.0, $results['previous_offset']);
        self::assertEquals(-1.0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT * FROM contacts',
            $results['query']
        );


        // test
        $sugar_config['disable_count_query'] = 1;
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_0';
        $bean->save();
        $query = /** @lang text */
            "INSERT INTO contacts (id) VALUES ('test_contact_1'), ('test_contact_2'), ('test_contact_3')";
        DBManagerFactory::getInstance()->query($query);
        $subpanelDefinition = new aSubPanel('TestPanel', array(), $bean);
        $results = $bean->process_union_list_query(null, /** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts', null, -1, -1, '', $subpanelDefinition);

        self::assertEquals(array(), $results['parent_data']);
        self::assertNotEquals(0, $results['row_count']);
        self::assertEquals(10, $results['next_offset']);
        self::assertEquals(-10, $results['previous_offset']);
        self::assertEquals(0, $results['current_offset']);
        self::assertEquals(/** @lang sql */
            'SELECT DISTINCT count(*) AS c FROM contacts',
            $results['query']
        );

        $query = /** @lang text */
            "DELETE FROM contacts WHERE id IN ('test_contact_0', 'test_contact_1', 'test_contact_2', 'test_contact_3')";
        DBManagerFactory::getInstance()->query($query);

        // cleanup
        DBManagerFactory::getInstance()->query("DELETE FROM sugarfeed WHERE related_id LIKE 'test_contact%'");
        DBManagerFactory::getInstance()->query("DELETE FROM contacts_cstm WHERE id_c LIKE 'test_contact%'");

        DBManagerFactory::getInstance()->query("DELETE FROM aod_index");
        foreach ($tableAodIndex as $row) {
            $query = "INSERT aod_index INTO (";
            $query .= (implode(',', array_keys($row)) . ') VALUES (');
            foreach ($row as $value) {
                $quoteds[] = "'$value'";
            }
            $query .= (implode(', ', $quoteds)) . ')';
            DBManagerFactory::getInstance()->query($query);
        }
    }

    /**
     * @see SugarBean::retrieve_parent_fields()
     */
    public function testRetrieveParentFields(): void
    {
        $GLOBALS['log']->reset();

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(null);
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(1));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(array(array('type' => 'parent'))));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_type' => 1,
                )
            )
        ));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_type' => 'test',
                )
            )
        ));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_type' => 'test',
                )
            )
        ));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_type' => 'Contacts',
                )
            )
        ));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_id' => 1,
                )
            )
        ));
        self::assertEquals(array(), $results);

        // test
        $bean = new SugarBeanMock();
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_id' => 1,
                    'parent_type' => 'Contacts',
                )
            )
        ));
        self::assertEquals(array(), $results);


        // test
        $bean = new SugarBeanMock();

        $this->db->query(/** @lang sql */
            "INSERT INTO contacts (id, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, salutation, first_name, last_name, title, photo, department, do_not_call, phone_home, phone_mobile, phone_work, phone_other, phone_fax, primary_address_street, primary_address_city, primary_address_state, primary_address_postalcode, primary_address_country, alt_address_street, alt_address_city, alt_address_state, alt_address_postalcode, alt_address_country, assistant, assistant_phone, lead_source, reports_to_id, birthdate, campaign_id, joomla_account_id, portal_account_disabled, portal_user_type) VALUES ('test_parent_contact_1', '2017-08-04 00:00:11', '2017-08-11 00:00:22', 'aaa', 'bbb', 'ccc', '0', 'eee', 'fff', 'ggg', 'hhh', 'jjj', 'kkk', 'lll', '1', 'mmm', 'nnn', 'ooo', 'ppp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Single');"
        );
        $results = $bean->retrieve_parent_fields(array(
            array(
                array(
                    'type' => 'parent',
                    'parent_id' => 'test_parent_contact_1',
                    'parent_type' => 'Contacts',
                )
            )
        ));
        self::assertEquals(array(
            '' => array(
                'id' => 'test_parent_contact_1',
                'parent_name' => 'ggg hhh',
                'parent_name_owner' => 'eee',
                'parent_name_mod' => 'Contacts',
            ),
        ), $results);
        $this->db->query(/** @lang sql */
            "DELETE FROM contacts WHERE id = 'test_parent_contact_1'"
        );
    }

    /**
     * @see SugarBean::getAuditEnabledFieldDefinitions()
     */
    public function testGetAuditEnabledFieldDefinitions(): void
    {
        $GLOBALS['log']->reset();

        // test
        $bean = new SugarBeanMock();
        $results = $bean->getAuditEnabledFieldDefinitions();
        self::assertEquals(array(), $results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getAuditEnabledFieldDefinitions();
        self::assertEquals(array(
            'assigned_user_id' => array(
                'name' => 'assigned_user_id',
                'rname' => 'user_name',
                'id_name' => 'assigned_user_id',
                'vname' => 'LBL_ASSIGNED_TO_ID',
                'group' => 'assigned_user_name',
                'type' => 'relate',
                'table' => 'users',
                'module' => 'Users',
                'reportable' => true,
                'isnull' => 'false',
                'dbType' => 'id',
                'audited' => true,
                'comment' => 'User ID assigned to record',
                'duplicate_merge' => 'disabled',
            ),
            'do_not_call' => array(
                'name' => 'do_not_call',
                'vname' => 'LBL_DO_NOT_CALL',
                'type' => 'bool',
                'default' => '0',
                'audited' => true,
                'comment' => 'An indicator of whether contact can be called',
            ),
            'phone_work' => array(
                'name' => 'phone_work',
                'vname' => 'LBL_OFFICE_PHONE',
                'type' => 'phone',
                'dbType' => 'varchar',
                'len' => 100,
                'audited' => true,
                'unified_search' => true,
                'full_text_search' => array(
                    'boost' => 1
                ),
                'comment' => 'Work phone number of the contact',
                'merge_filter' => 'enabled',
            ),
            'lawful_basis' => array(
                'name' => 'lawful_basis',
                'vname' => 'LBL_LAWFUL_BASIS',
                'type' => 'multienum',
                'massupdate' => true,
                'no_default' => false,
                'comments' => '',
                'inline_edit' => true,
                'reportable' => true,
                'merge_filter' => 'enabled',
                'len' => 100,
                'size' => '20',
                'options' => 'lawful_basis_dom',
                'audited' => true,
                'importable' => true,
            ),
            'date_reviewed' => array(
                'name' => 'date_reviewed',
                'vname' => 'LBL_DATE_REVIEWED',
                'type' => 'date',
                'massupdate' => true,
                'audited' => true,
                'importable' => true,
            ),
            'lawful_basis_source' => array(
                'name' => 'lawful_basis_source',
                'vname' => 'LBL_LAWFUL_BASIS_SOURCE',
                'type' => 'enum',
                'massupdate' => true,
                'no_default' => false,
                'comments' => '',
                'inline_edit' => true,
                'reportable' => true,
                'merge_filter' => 'enabled',
                'len' => 100,
                'size' => '20',
                'options' => 'lawful_basis_source_dom',
                'audited' => true,
                'importable' => true,
            ),
        ), $results);
    }

    /**
     * @see SugarBean::isOwner()
     */
    public function testIsOwner(): void
    {
        // test
        $GLOBALS['log']->reset();
        $bean = new SugarBeanMock();
        $result = $bean->isOwner(null);
        self::assertTrue($result);
        self::assertEquals('', $bean->id);

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_1';
        $result = $bean->isOwner(null);
        self::assertFalse($result);
        self::assertEquals('test_contact_1', $bean->id);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_1';
        $bean->fetched_row['assigned_user_id'] = 1;
        $result = $bean->isOwner(null);
        self::assertFalse($result);
        self::assertEquals('test_contact_1', $bean->id);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_1';
        $bean->fetched_row['assigned_user_id'] = 1;
        $result = $bean->isOwner(1);
        self::assertTrue($result);
        self::assertEquals('test_contact_1', $bean->id);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_1';
        $bean->assigned_user_id = 1;
        $result = $bean->isOwner(1);
        self::assertTrue($result);
        self::assertEquals('test_contact_1', $bean->id);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_1';
        $bean->assigned_user_id = 1;
        $result = $bean->isOwner(2);
        self::assertFalse($result);
        self::assertEquals('test_contact_1', $bean->id);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_1';
        $bean->created_by = 1;
        $result = $bean->isOwner(1);
        self::assertTrue($result);
        self::assertEquals('test_contact_1', $bean->id);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::get_custom_table_name()
     */
    public function testGetCustomTableName(): void
    {
        // test
        $GLOBALS['log']->reset();
        $result = BeanFactory::newBean('Contacts')->get_custom_table_name();
        self::assertEquals('contacts_cstm', $result);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::getTableName()
     */
    public function testGetTableName(): void
    {
        // test
        $GLOBALS['log']->reset();
        $bean = new SugarBeanMock();
        $result = $bean->getTableName();
        self::assertEquals('', $result);

        // test
        $GLOBALS['log']->reset();
        $bean = new SugarBeanMock();
        unset($bean->table_name);
        $result = $bean->getTableName();
        self::assertEquals('', $result);

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $result = $bean->getTableName();
        self::assertEquals('contacts', $result);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::getObjectName()
     */
    public function testGetObjectName(): void
    {
        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $result = $bean->getObjectName();
        self::assertEquals('Contact', $result);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));


        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        unset($bean->table_name);
        $result = $bean->getObjectName();
        self::assertEquals('Contact', $result);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        unset($bean->object_name);
        $result = $bean->getObjectName();
        self::assertEquals(null, $result);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->object_name = false;
        $result = $bean->getObjectName();
        self::assertEquals('contacts', $result);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::getIndices()
     */
    public function testGetIndices(): void
    {
        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $bean->object_name = false;
        $results = $bean->getIndices();
        self::assertEquals(array(), $results);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getIndices();
        self::assertEquals(array(
            'id' => array(
                'name' => 'contactspk',
                'type' => 'primary',
                'fields' => array(
                    0 => 'id',
                ),
            ),
            0 => array(
                'name' => 'idx_cont_last_first',
                'type' => 'index',
                'fields' => array(
                    0 => 'last_name',
                    1 => 'first_name',
                    2 => 'deleted',
                ),
            ),
            1 => array(
                'name' => 'idx_contacts_del_last',
                'type' => 'index',
                'fields' => array(
                    0 => 'deleted',
                    1 => 'last_name',
                ),
            ),
            2 => array(
                'name' => 'idx_cont_del_reports',
                'type' => 'index',
                'fields' => array(
                    0 => 'deleted',
                    1 => 'reports_to_id',
                    2 => 'last_name',
                ),
            ),
            3 => array(
                'name' => 'idx_reports_to_id',
                'type' => 'index',
                'fields' => array(
                    0 => 'reports_to_id',
                ),
            ),
            4 => array(
                'name' => 'idx_del_id_user',
                'type' => 'index',
                'fields' => array(
                    0 => 'deleted',
                    1 => 'id',
                    2 => 'assigned_user_id',
                ),
            ),
            5 => array(
                'name' => 'idx_cont_assigned',
                'type' => 'index',
                'fields' => array(
                    0 => 'assigned_user_id',
                ),
            ),
        ), $results);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::getPrimaryFieldDefinition()
     */
    public function testGetPrimaryFieldDefinition(): void
    {
        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getPrimaryFieldDefinition();
        self::assertEquals(array(
            'name' => 'id',
            'vname' => 'LBL_ID',
            'type' => 'id',
            'required' => true,
            'reportable' => true,
            'comment' => 'Unique identifier',
            'inline_edit' => false,
        ), $results);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::newBean('Contacts');
        unset($bean->field_defs['id']);
        $results = $bean->getPrimaryFieldDefinition();
        self::assertEquals(array(
            'name' => 'name',
            'vname' => 'LBL_NAME',
            'type' => 'name',
            'rname' => 'name',
            'link' => true,
            'fields' => array(
                0 => 'first_name',
                1 => 'last_name',
            ),
            'sort_on' => 'last_name',
            'source' => 'non-db',
            'group' => 'last_name',
            'len' => '255',
            'db_concat_fields' => array(
                0 => 'first_name',
                1 => 'last_name',
            ),
            'importable' => 'false',
        ), $results);
        self::assertFalse(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::getFieldDefinition()
     */
    public function testGetFieldDefinition(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldDefinition(null);
        self::assertFalse($results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldDefinition('undefined');
        self::assertFalse($results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);


        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldDefinition('name');
        self::assertEquals(array(
            'name' => 'name',
            'rname' => 'name',
            'vname' => 'LBL_NAME',
            'type' => 'name',
            'link' => true,
            'fields' => array(
                0 => 'first_name',
                1 => 'last_name',
            ),
            'sort_on' => 'last_name',
            'source' => 'non-db',
            'group' => 'last_name',
            'len' => '255',
            'db_concat_fields' => array(
                0 => 'first_name',
                1 => 'last_name',
            ),
            'importable' => 'false',
        ), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::getFieldValue()
     */
    public function testGetFieldValue(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldValue(null);
        self::assertFalse($results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldValue('importable');
        self::assertEquals(1, $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldValue('in_workflow');
        self::assertEquals(0, $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldValue('portal_user_type');
        self::assertEquals('Single', $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::unPopulateDefaultValues()
     */
    public function testUnPopulateDefaultValues(): void
    {
        // test
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->unPopulateDefaultValues();
        self::assertEquals(null, $results);
        /** @noinspection PhpUndefinedFieldInspection */
        self::assertEquals(null, $bean->portal_user_type ?? null);
        /** @noinspection PhpUndefinedFieldInspection */
        self::assertEquals(null, $bean->jjwg_maps_lat_c ?? null);
        /** @noinspection PhpUndefinedFieldInspection */
        self::assertEquals(null, $bean->jjwg_maps_lng_c ?? null);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = false;
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->unPopulateDefaultValues();
        self::assertEquals(null, $results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = $bean->unPopulateDefaultValues();
        self::assertEquals(null, $results);
    }

    /**
     * @see SugarBean::__clone()
     */
    public function testClone(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $clone = clone $bean;
        self::assertEquals($bean, $clone);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = new SugarBeanMock();
        $bean->foo = 'bar';
        $bean->setLoadedRelationships(array('foo'));
        $clone = clone $bean;
        self::assertEquals('bar', $bean->foo);
        self::assertNotTrue(isset($clone->foo));
        unset($bean->foo);
        self::assertEquals($bean, $clone);
    }

    /**
     * @see SugarBean::get_linked_fields()
     */
    public function testGetLinkedFields(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = array();
        $results = $bean->get_linked_fields();
        self::assertEquals(array(), $results);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = array(1);
        $results = $bean->get_linked_fields();
        self::assertEquals(array(), $results);
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = array(array(1));
        $results = $bean->get_linked_fields();
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = array(array('type' => 'link'));
        $results = $bean->get_linked_fields();
        self::assertEquals(array(
            0 => array(
                'type' => 'link',
            ),
        ), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::getFieldDefinitions()
     */
    public function testGetFieldDefinitions(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getFieldDefinitions();
        self::assertEquals($bean->field_defs, $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::load_relationship()
     */
    public function testLoadRelationship(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->load_relationship(null);
        self::assertEquals(false, $results);
        self::assertCount(1, $GLOBALS['log']->calls['error']);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->load_relationship('test');
        self::assertEquals(false, $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = 'testValue';
        $results = $bean->load_relationship('testKey');
        self::assertEquals(false, $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = 'testValue';
        /** @noinspection PhpUndefinedFieldInspection */
        $bean->testKey = new Link2('test', $bean);
        $results = $bean->load_relationship('testKey');
        self::assertEquals(true, $results);
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = array('type' => 'link');
        $bean->testKey = 'testValue';
        $results = $bean->load_relationship('testKey');
        self::assertEquals(false, $results);
        /** @noinspection MissingIssetImplementationInspection */
        self::assertNotTrue(isset($bean->testKey));
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = array(
            'type' => 'link',
            'link_class' => 'testClass',
            'link_file' => 'testClass.php',
        );
        $bean->testKey = 'testValue';
        $results = $bean->load_relationship('testKey');
        self::assertEquals(false, $results);
        /** @noinspection MissingIssetImplementationInspection */
        self::assertNotTrue(isset($bean->testKey));
        self::assertCount(3, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = array(
            'type' => 'link',
            'link_class' => 'testClass',
            'link_file' => 'modules/Campaigns/ProspectLink.php',
        );
        $bean->testKey = 'testValue';
        $results = $bean->load_relationship('testKey');
        self::assertEquals(true, $results);
        self::assertEquals('testValue', $bean->testKey);
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = array(
            'type' => 'link',
            'link_class' => 'ProspectLink',
            'link_file' => 'modules/Campaigns/ProspectLink.php',
        );
        $bean->testKey = 'testValue';
        $results = $bean->load_relationship('testKey');
        self::assertEquals(true, $results);
        self::assertEquals('testValue', $bean->testKey);
        self::assertCount(2, $GLOBALS['log']->calls['fatal']);


        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testKey'] = array(
            'type' => 'link',
            'link_class' => 'ProspectLink',
            'link_file' => 'modules/Campaigns/ProspectLink.php',
            'relationship' => 'campaign_leads',
        );
        $bean->testKey = 'testValue';
        $results = $bean->load_relationship('testKey');
        self::assertEquals(false, $results);
        /** @noinspection MissingIssetImplementationInspection */
        self::assertNotTrue(isset($bean->testKey));
        self::assertCount(3, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::get_linked_beans()
     */
    public function testGetLinkedBeans(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->get_linked_beans(null);
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->get_linked_beans(null, 'Case');
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpUndefinedFieldInspection */
        $bean->testKey = new ProspectLink('test', $bean);
        $results = $bean->get_linked_beans('testKey', 'Case');
        self::assertEquals(array(), $results);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));

        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->testKey = new ProspectLink('test', $bean);
        $results = $bean->get_linked_beans('testKey', 'Case', '', 0, 1);
        self::assertEquals(array(), $results);
        self::assertTrue(isset($GLOBALS['log']->calls['fatal']));
    }

    /**
     * @see SugarBean::get_import_required_fields()
     */
    public function testGetImportRequiredFields(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = array();
        $results = $bean->get_import_required_fields();
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::get_importable_fields()
     */
    public function testGetImportableFields(): void
    {
        // test
        $GLOBALS['log']->reset();
        $GLOBALS['log']->fatal('test');
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs = array();
        $results = $bean->get_importable_fields();
        self::assertEquals(array(), $results);
        self::assertCount(1, $GLOBALS['log']->calls['fatal']);
    }

    /**
     * @see SugarBean::create_tables()
     */
    public function testCreateTables(): void
    {
        // test
        $bean = BeanFactory::newBean('Contacts');
        ob_start();
        $bean->create_tables();
        $results = ob_get_contents();
        ob_get_clean();
        self::assertEquals(/** @lang text */
            "Table already exists : $bean->table_name<br>",
            $results
        );
    }

    /**
     * @see SugarBean::getACLCategory()
     */
    public function testGetACLCategory(): void
    {
        // test
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->getACLCategory();
        self::assertEquals(null !== $bean->acl_category ? $bean->acl_category : $bean->module_dir, $results);
    }

    /**
     * @see SugarBean::is_AuditEnabled()
     */
    public function testIsAuditEnabled(): void
    {
        // test
        $bean = new SugarBeanMock();
        $results = $bean->is_AuditEnabled();
        self::assertEquals(false, $results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->is_AuditEnabled();
        self::assertEquals(true, $results);
    }

    /**
     * @see SugarBean::get_audit_table_name()
     */
    public function testGetAuditTableNames(): void
    {
        // test
        $results = BeanFactory::newBean('Contacts')->get_audit_table_name();
        self::assertEquals('contacts_audit', $results);
    }

    /**
     * @see SugarBean::create_audit_table()
     */
    public function testCreateAuditTable(): void
    {
        $query = /** @lang sql */
            'DROP TABLE contacts_audit;';
        $this->db->query($query);

        // test
        /** @noinspection PhpVoidFunctionResultUsedInspection */
        $results = BeanFactory::newBean('Contacts')->create_audit_table();
        self::assertEquals(null, $results);
    }

    /**
     * @see SugarBean::save()
     */
    public function testSave(): void
    {
        $userFieldDefs = BeanFactory::getBean('Users')->field_defs;
        $contactFieldDefs = BeanFactory::getBean('Contacts')->field_defs;

        // test

        global $current_user;

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
            self::assertTrue(true);
        }
        $isValidator = new \SuiteCRM\Utility\SuiteValidator();
        self::assertNotTrue($isValidator->isValidId($results));

        self::assertEquals($current_user->id, $bean->modified_user_id);
        self::assertEquals($current_user->user_name, $bean->modified_by_name);
        self::assertEquals(0, $bean->deleted);
        self::assertEquals($bean->date_modified, $bean->date_entered);
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);

        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(false, $bean->new_with_id);



        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $bean->new_with_id = true;
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
        }
        $isValidator = new \SuiteCRM\Utility\SuiteValidator();
        self::assertFalse($isValidator->isValidId($results));

        self::assertEquals(false, $bean->in_save);
        self::assertEquals($current_user->id, $bean->modified_user_id);
        self::assertEquals($current_user->user_name, $bean->modified_by_name);
        self::assertEquals(0, $bean->deleted);
        self::assertEquals($bean->date_modified, $bean->date_entered);
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);
        self::assertFalse($isValidator->isValidId($bean->id));
        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(true, $bean->new_with_id);
        self::assertEquals($bean->modified_by_name, $bean->old_modified_by_name);

        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $bean->new_with_id = true;
        $bean->modified_by_name = 'testing';
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
        }
        self::assertFalse($isValidator->isValidId($results));

        self::assertEquals(false, $bean->in_save);

        self::assertEquals($current_user->id, $bean->modified_user_id);

        self::assertEquals(0, $bean->deleted);
        self::assertEquals($bean->date_modified, $bean->date_entered);
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);
        self::assertFalse($isValidator->isValidId($bean->id));
        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(true, $bean->new_with_id);


        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $bean->id = 'testBean_1';
        $bean->modified_by_name = 'testing';
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
            self::assertTrue(true);
        }
        self::assertFalse($isValidator->isValidId($results));



        self::assertEquals($current_user->id, $bean->modified_user_id);

        self::assertEquals(0, $bean->deleted);
        self::assertFalse(isset($bean->date_entered));
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);

        $GLOBALS['sugar_config']['strict_id_validation'] = false;
        self::assertTrue($isValidator->isValidId($bean->id));
        $GLOBALS['sugar_config']['strict_id_validation'] = true;
        self::assertFalse($isValidator->isValidId($bean->id));

        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(false, $bean->new_with_id);



        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $bean->id = 'testBean_1+!';
        $bean->modified_by_name = 'testing';
        $bean->field_defs = array(
            'email_addresses' => array(
                'type' => 'link',
            ),
            'email_addresses_non_primary' => array(
                'type' => 'email',
            ),
        );
        /** @noinspection PhpUndefinedFieldInspection */
        $bean->email_addresses_non_primary = array(true);
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
            self::assertTrue(true);
        }
        self::assertFalse($isValidator->isValidId($results));

        self::assertEquals(null, $bean->in_save);

        self::assertEquals($current_user->id, $bean->modified_user_id);

        self::assertEquals(null, $current_user->user_name);
        self::assertEquals(0, $bean->deleted);
        self::assertFalse(isset($bean->date_entered));
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);
        self::assertFalse($isValidator->isValidId($bean->id));
        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(false, $bean->new_with_id);


        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $bean->id = 'testBean_1+!';
        $bean->modified_by_name = 'testing';
        $bean->field_defs = array(
            'email_addresses' => array(
                'type' => 'link',
            ),
            'email_addresses_non_primary' => array(
                'type' => 'email',
            ),
        );
        $bean->emailAddress = BeanFactory::newBean('EmailAddresses');
        $bean->email_addresses_non_primary = array(true);
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
        }
        self::assertFalse($isValidator->isValidId($results));

        self::assertEquals(false, $bean->in_save);

        self::assertEquals($current_user->id, $bean->modified_user_id);

        self::assertEquals(null, $current_user->user_name);
        self::assertEquals(0, $bean->deleted);
        self::assertFalse(isset($bean->date_entered));
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);
        self::assertFalse($isValidator->isValidId($bean->id));
        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(false, $bean->new_with_id);



        // test
        $GLOBALS['log']->reset();
        $bean = BeanFactory::getBean('Users');
        $bean->id = 'testBean_1+!';
        $bean->modified_by_name = 'testing';
        $bean->field_defs = array(
            'email_addresses' => array(
                'type' => 'link',
            ),
            'email_addresses_non_primary' => array(
                'type' => 'email',
            ),
        );
        $bean->emailAddress = BeanFactory::newBean('EmailAddresses');
        $bean->email_addresses_non_primary = array(true);
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
        }
        self::assertFalse($isValidator->isValidId($results));

        self::assertEquals(false, $bean->in_save);

        self::assertEquals($current_user->id, $bean->modified_user_id);

        self::assertEquals(null, $current_user->user_name);
        self::assertEquals(0, $bean->deleted);
        self::assertFalse(isset($bean->date_entered));
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);
        self::assertFalse($isValidator->isValidId($bean->id));
        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(false, $bean->new_with_id);


        // test
        $GLOBALS['log']->reset();
        $this->fieldDefsStore('temp1');
        $this->fieldDefsRestore();
        $bean = BeanFactory::getBean('Contacts');
        $bean->id = 'testBean_1+!';
        $bean->modified_by_name = 'testing';
        $bean->createdAuditRecords = false;
        $bean->field_defs = array_merge($bean->field_defs, $bean->field_defs = array(
            'email_addresses' => array(
                'type' => 'link',
            ),
            'email_addresses_non_primary' => array(
                'type' => 'email',
            ),
        ));
        $bean->emailAddress = BeanFactory::newBean('EmailAddresses');
        $bean->email_addresses_non_primary = array('testbean1@email.com');
        $results = null;
        try {
            $results = $bean->save();
            self::assertTrue(false);
        } catch (Exception $e) {
        }
        self::assertFalse($isValidator->isValidId($results));

        self::assertEquals(false, $bean->in_save);
        self::assertEquals($GLOBALS['timedate']->nowDb(), $bean->date_modified);
        self::assertEquals($current_user->id, $bean->modified_user_id);
        self::assertEquals($current_user->user_name, $bean->modified_by_name);
        self::assertEquals(0, $bean->deleted);
        self::assertFalse(isset($bean->date_entered));
        self::assertEquals(isset($current_user) ? $current_user->id : '', $bean->created_by);
        self::assertFalse($isValidator->isValidId($bean->id));
        self::assertEquals($bean, $bean->custom_fields->bean);
        self::assertEquals(false, $bean->new_with_id);
        self::assertEquals('testing', $bean->old_modified_by_name);

        $this->fieldDefsRestore('temp1', true);

        // cleanup
        $this->db->query("DELETE FROM sugarfeed WHERE related_id LIKE 'testBean_1+!'");
        $this->db->query("DELETE FROM contacts_cstm WHERE id_c LIKE 'testBean_1+!'");
        $this->db->query("DELETE FROM email_addr_bean_rel WHERE bean_id LIKE 'testBean_1+!'");
        $this->db->query("DELETE FROM email_addresses WHERE email_address LIKE 'testbean1@email.com'");


        BeanFactory::getBean('Users')->field_defs = $userFieldDefs;
        BeanFactory::getBean('Contacts')->field_defs = $contactFieldDefs;

        $GLOBALS['sugar_config']['strict_id_validation'] = false;
    }

    /**
     * @see SugarBean::cleanBean()
     */
    public function testCleanBean(): void
    {
        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->field_defs['testField'] = array('type' => 'html');
        /** @noinspection PhpUndefinedFieldInspection */
        $bean->testField = '<p>test <b>html</b> value</p>';
        $bean->cleanBean();
        self::assertEquals('&lt;p&gt;test &lt;b&gt;html&lt;/b&gt; value&lt;/p&gt;', $bean->testField);
    }

    /**
     * @see SugarBean::fixUpFormatting()
     */
    public function testFixUpFormatting(): void
    {
        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->fixUpFormatting();

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'datetime');
        /** @noinspection PhpUndefinedFieldInspection */
        $bean->testField1 = 'NULL';
        $bean->fixUpFormatting();
        self::assertEquals('', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'datetime');
        $bean->testField1 = 'invalid-format';
        $bean->fixUpFormatting();
        self::assertEquals('', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'date');
        $bean->testField1 = 'NULL';
        $bean->fixUpFormatting();
        self::assertEquals('', $bean->testField1);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'date');
        $bean->testField1 = 'invalid-format';
        $bean->fixUpFormatting();
        self::assertEquals('', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'time');
        $bean->testField1 = 'NULL';
        $bean->fixUpFormatting();
        self::assertEquals('', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'time');
        $bean->testField1 = 'invalid-format';
        $bean->fixUpFormatting();
        self::assertEquals('invalid-format', $bean->testField1);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'time');
        $bean->testField1 = 'am';
        $bean->fixUpFormatting();
        self::assertEquals('am', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'float');
        $bean->testField1 = 'NULL';
        $bean->fixUpFormatting();
        self::assertEquals('NULL', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'int');
        $bean->testField1 = 'NULL';
        $bean->fixUpFormatting();
        self::assertEquals('NULL', $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'int');
        $bean->testField1 = 'a string here..';
        $bean->fixUpFormatting();
        self::assertEquals(0, $bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = true;
        $bean->fixUpFormatting();
        self::assertTrue($bean->testField1);
        self::assertNotNull($bean->testField1);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = 1;
        $bean->fixUpFormatting();
        self::assertTrue($bean->testField1);
        self::assertNotNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = 'true';
        $bean->fixUpFormatting();
        self::assertTrue($bean->testField1);
        self::assertNotNull($bean->testField1);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = 'TRUE';
        $bean->fixUpFormatting();
        self::assertTrue($bean->testField1);
        self::assertNotNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = 'on';
        $bean->fixUpFormatting();
        self::assertTrue($bean->testField1);
        self::assertNotNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = false;
        $bean->fixUpFormatting();
        self::assertFalse($bean->testField1);
        self::assertNotNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = '';
        $bean->fixUpFormatting();
        self::assertFalse($bean->testField1);
        self::assertNotNull($bean->testField1);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = 0;
        $bean->fixUpFormatting();
        self::assertFalse($bean->testField1);
        self::assertNotNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = '0';
        $bean->fixUpFormatting();
        self::assertFalse($bean->testField1);
        self::assertNotNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = null;
        $bean->fixUpFormatting();
        self::assertNotTrue($bean->testField1);
        self::assertNotFalse($bean->testField1);
        self::assertNull($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'bool');
        $bean->testField1 = 'NULL';
        $bean->fixUpFormatting();
        self::assertTrue($bean->testField1);


        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'encrypt');
        $bean->testField1 = '';
        $bean->fixUpFormatting();
        self::assertNotTrue($bean->testField1);
        self::assertNotFalse($bean->testField1);
        self::assertEquals('', $bean->testField1);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_10';
        $bean->fetched_row['id'] = 'test_contact_10';
        $bean->field_defs['testField1'] = array('type' => 'encrypt');
        $bean->testField1 = 'a test string value';
        $bean->fixUpFormatting();
        self::assertNotTrue($bean->testField1);
        self::assertNotFalse($bean->testField1);
        self::assertNotEquals('', $bean->testField1);
    }

    /**
     * @see SugarBean::encrpyt_before_save()
     */
    public function testEncrpytBeforeSave(): void
    {
        $bean = BeanFactory::newBean('Contacts');

        $fake = new SugarBeanMock();

        $results = $bean->encrpyt_before_save('test value');
        self::assertEquals(blowfishEncode($fake->getEncryptKeyPublic(), 'test value'), $results);
    }

    /**
     * @see SugarBean::getEncryptKey()
     */
    public function testGetEncryptKey(): void
    {
        $results = (new SugarBeanMock())->getEncryptKeyPublic();
        self::assertEquals(blowfishGetKey('encrypt_field'), $results);
    }

    /**
     * @see SugarBean::has_been_modified_since()
     */
    public function testHasBeenModifiedSince(): void
    {
        // test
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->has_been_modified_since(null, null);
        self::assertFalse($results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('wrong1', null);
        self::assertFalse($results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->has_been_modified_since(null, 'wrong1');
        self::assertFalse($results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('wrong1', 'wrong1');
        self::assertFalse($results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('1900-01-01', null);
        self::assertFalse($results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        $results = $bean->has_been_modified_since(null, '1');
        self::assertFalse($results);

        // test
        $bean = BeanFactory::newBean('Contacts');
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('1900-01-01', '1');
        self::assertFalse($results);

        // test
        $query = /** @lang sql */
            "INSERT INTO contacts (id, modified_user_id, date_modified) VALUES ('test_contact_11', 'test_user_11', '2000-01-01')";
        DBManagerFactory::getInstance()->query($query);

        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_11';
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('1999-01-01', 'test_user_12');
        self::assertTrue($results);

        $query = /** @lang sql */
            "DELETE FROM contacts WHERE id = 'test_contact_11'";
        DBManagerFactory::getInstance()->query($query);

        // test
        $query = /** @lang sql */
            "INSERT INTO contacts (id, modified_user_id, date_modified) VALUES ('test_contact_11', 'test_user_11', '2000-01-01')";
        DBManagerFactory::getInstance()->query($query);

        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_11';
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('2001-01-01', 'test_user_12');
        self::assertTrue($results);

        $query = /** @lang sql */
            "DELETE FROM contacts WHERE id = 'test_contact_11'";
        DBManagerFactory::getInstance()->query($query);

        // test
        $query = /** @lang sql */
            "INSERT INTO contacts (id, modified_user_id, date_modified) VALUES ('test_contact_11', 'test_user_11', '2000-01-01')";
        DBManagerFactory::getInstance()->query($query);

        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_11';
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('1999-01-01', 'test_user_11');
        self::assertTrue($results);

        $query = /** @lang sql */
            "DELETE FROM contacts WHERE id = 'test_contact_11'";
        DBManagerFactory::getInstance()->query($query);

        // test
        $query = /** @lang sql */
            "INSERT INTO contacts (id, modified_user_id, date_modified) VALUES ('test_contact_11', 'test_user_11', '2000-01-01')";
        DBManagerFactory::getInstance()->query($query);

        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_11';
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('2001-01-01', 'test_user_11');
        self::assertFalse($results);

        $query = /** @lang sql */
            "DELETE FROM contacts WHERE id = 'test_contact_11'";
        DBManagerFactory::getInstance()->query($query);

        // test
        $query = /** @lang sql */
            "INSERT INTO contacts (id, modified_user_id, date_modified) VALUES ('test_contact_11', 'test_user_11', '2000-01-01')";
        DBManagerFactory::getInstance()->query($query);

        $bean = BeanFactory::newBean('Contacts');
        $bean->id = 'test_contact_11';
        /** @noinspection PhpParamsInspection */
        $results = $bean->has_been_modified_since('2001-01-01', 'test_user_12');
        self::assertTrue($results);

        $query = /** @lang sql */
            "DELETE FROM contacts WHERE id = 'test_contact_11'";
        DBManagerFactory::getInstance()->query($query);
    }

    /**
     * TODO: Tests that need to be written.
     * @see SugarBean::load_relationships()
     * @see SugarBean::toArray()
     * @see SugarBean::save_relationship_changes()
     * @see SugarBean::set_relationship_info()
     * @see SugarBean::handle_preset_relationships()
     * @see SugarBean::handle_remaining_relate_fields()
     * @see SugarBean::update_parent_relationships()
     * @see SugarBean::handle_request_relate()
     * @see SugarBean::call_custom_logic()
     * @see SugarBean::hasEmails()
     * @see SugarBean::preprocess_fields_on_save()
     * @see SugarBean::_sendNotifications()
     * @see SugarBean::get_notification_recipients()
     * @see SugarBean::send_assignment_notifications()
     * @see SugarBean::create_notification_email()
     * @see SugarBean::track_view()
     * @see SugarBean::get_summary_text()
     * @see SugarBean::add_list_count_joins()
     * @see SugarBean::get_list()
     * @see SugarBean::getOwnerWhere()
     * @see SugarBean::create_new_list_query()
     * @see SugarBean::get_relationship_field()
     * @see SugarBean::is_relate_field()
     * @see SugarBean::process_order_by()
     * @see SugarBean::process_list_query()
     * @see SugarBean::create_list_count_query()
     * @see SugarBean::fill_in_additional_list_fields()
     * @see SugarBean::get_detail()
     * @see SugarBean::process_detail_query()
     * @see SugarBean::retrieve()
     * @see SugarBean::getCustomJoin()
     * @see SugarBean::convertRow()
     * @see SugarBean::convertField()
     * @see SugarBean::populateFromRow()
     * @see SugarBean::populateCurrencyFields()
     * @see SugarBean::check_date_relationships_load()
     * @see SugarBean::decrypt_after_retrieve()
     * @see SugarBean::fill_in_additional_detail_fields()
     * @see SugarBean::fill_in_additional_parent_fields()
     * @see SugarBean::getRelatedFields()
     * @see SugarBean::fill_in_relationship_fields()
     * @see SugarBean::fill_in_link_field()
     * @see SugarBean::get_related_fields()
     * @see SugarBean::get_related_list()
     * @see SugarBean::get_full_list()
     * @see SugarBean::process_full_list_query()
     * @see SugarBean::create_index()
     * @see SugarBean::mark_deleted()
     * @see SugarBean::mark_undeleted()
     * @see SugarBean::restoreFiles()
     * @see SugarBean::haveFiles()
     * @see SugarBean::getFiles()
     * @see SugarBean::getFilesFields()
     * @see SugarBean::deleteFileDirectory()
     * @see SugarBean::mark_relationships_deleted()
     * @see SugarBean::delete_linked()
     * @see SugarBean::deleteFiles()
     * @see SugarBean::build_related_list()
     * @see SugarBean::build_related_list_where()
     * @see SugarBean::build_related_in()
     * @see SugarBean::build_related_list2()
     * @see SugarBean::list_view_parse_additional_sections()
     * @see SugarBean::get_list_view_data()
     * @see SugarBean::get_list_view_array()
     * @see SugarBean::retrieve_by_string_fields()
     * @see SugarBean::get_where()
     * @see SugarBean::fromArray()
     * @see SugarBean::process_special_fields()
     * @see SugarBean::build_generic_where_clause()
     * @see SugarBean::parse_additional_headers()
     * @see SugarBean::assign_display_fields()
     * @see SugarBean::set_relationship()
     * @see SugarBean::retrieve_relationships()
     * @see SugarBean::loadLayoutDefs()
     * @see SugarBean::getRealKeyFromCustomFieldAssignedKey()
     * @see SugarBean::getOwnerField()
     * @see SugarBean::listviewACLHelper()
     * @see SugarBean::ACLAccess()
     * @see SugarBean::loadFromRow()
     * @see SugarBean::create_qualified_order_by()
     * @see SugarBean::add_address_streets()
     * @see SugarBean::populateRelatedBean()
     * @see SugarBean::beforeImportSave()
     * @see SugarBean::afterImportSave()
     * @see SugarBean::create_export_query()
     * @see SugarBean::auditBean()
     * @see SugarBean::createAuditRecord()
     * @see SugarBean::_checkOptimisticLocking()
     * @see SugarBean::drop_tables()
     */
}