Elep

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

use Sugarcrm\Sugarcrm\IdentityProvider\Authentication\Config as IdmConfig;
use Sugarcrm\Sugarcrm\Security\Escaper\Escape;
use Sugarcrm\Sugarcrm\Security\InputValidation\InputValidation;
use Sugarcrm\Sugarcrm\Security\InputValidation\Request;
use Sugarcrm\Sugarcrm\Security\Csrf\CsrfAuthenticator;

use Sugarcrm\Sugarcrm\ProcessManager\Registry;

require_once 'include/EditView/EditView2.php';

/**
 * MassUpdate class for updating multiple records at once
 * @api
 */
class MassUpdate
{
    /**
     * @var bool
     */
    public $use_old_search;
    public $searchFields;
    /*
    * internal sugarbean reference
    */
    public $sugarbean = null;

/**
     * where clauses used to filter rows that have to be updated
     */
    public $where_clauses = '';

/**
     * @var Request
     */
    protected $request;

/**
     * @var IdmConfig
     */
    protected $idmConfig;

/**
     * Constructor for Mass Update
     *
     * @param Request $request
     */
    public function __construct(?Request $request = null)
    {
        //TODO: Creation of Activities are turned off for mass update.
        //TODO: It will be turned on when job queue, asynchronous processing, activity Stream performance has been handled after 7.0
        Activity::disable();
        $this->request = $request ?: InputValidation::getService();
        $this->idmConfig = new IdmConfig(\SugarConfig::getInstance());
    }

/**
     * Restore the activity stream behaviour
     *
     * @access public
     */
    public function __destruct()
    {
        Activity::restoreToPreviousState();
    }

/**
     * set the sugar bean to its internal member
     * @param sugar bean reference
     */
    public function setSugarBean($sugar)
    {
        $this->sugarbean = $sugar;
    }

/**
     * get the massupdate form
     * @param bool boolean need to execute the massupdate form or not
     * @param multi_select_popup booleanif it is a multi-select value
     */
    public function getDisplayMassUpdateForm($bool, $multi_select_popup = false)
    {

require_once 'include/formbase.php';

if (!$multi_select_popup) {
            $form = '<form action="index.php" method="post" name="displayMassUpdate" id="displayMassUpdate">' . "\n";
        } else {
            $form = '<form action="index.php" method="post" name="MassUpdate" id="MassUpdate">' . "\n";
        }

if ($bool) {
            $form .= '<input type="hidden" name="mu" value="false" />' . "\n";
        } else {
            $form .= '<input type="hidden" name="mu" value="true" />' . "\n";
        }

$form .= getAnyToForm('mu', true);
        if (!$multi_select_popup) {
            $form .= "</form>\n";
        }

return $form;
    }

/**
     * returns the mass update's html form header
     * @param multi_select_popup boolean if it is a mult-select or not
     */
    public function getMassUpdateFormHeader($multi_select_popup = false)
    {
        global $sugar_version;
        global $sugar_config;
        global $current_user;

unset($_REQUEST['current_query_by_page']);
        unset($_REQUEST[session_name()]);
        unset($_REQUEST['PHPSESSID']);
        $query = base64_encode(serialize($_REQUEST));

$module = $this->request->getValidInputRequest('module', 'Assert\Bean\ModuleName');
        $action = $this->request->getValidInputRequest('action');
        $bean = BeanFactory::newBean($module);
        $order_by_name = $bean->module_dir . '2_' . strtoupper($bean->object_name) . '_ORDER_BY';
        $lvso = $this->request->getValidInputRequest('lvso');
        $request_order_by_name = $this->request->getValidInputRequest($order_by_name, 'Assert\Sql\OrderBy');
        if ($multi_select_popup) {
            $tempString = '';
        } else {
            $tempString = '<form action="index.php" method="post" name="MassUpdate" id="MassUpdate" onsubmit="return check_form(\'MassUpdate\');">'
                . '<input type="hidden" name="return_action" value="' . htmlspecialchars((string)$action, ENT_QUOTES, 'UTF-8') . '" />'
                . '<input type="hidden" name="return_module" value="' . htmlspecialchars((string)$module, ENT_QUOTES, 'UTF-8') . '" />'
                . '<input type="hidden" name="massupdate" value="true" />'
                . '<input type="hidden" name="delete" value="false" />'
                . '<input type="hidden" name="merge" value="false" />'
                . '<input type="hidden" name="current_query_by_page" value="' . htmlspecialchars((string)$query, ENT_QUOTES, 'UTF-8') . '" />'
                . '<input type="hidden" name="module" value="' . htmlspecialchars((string)$module, ENT_QUOTES, 'UTF-8') . '" />'
                . '<input type="hidden" name="action" value="MassUpdate" />'
                . '<input type="hidden" name="lvso" value="' . htmlspecialchars((string)$lvso, ENT_QUOTES, 'UTF-8') . '" />'
                . '<input type="hidden" name="' . htmlspecialchars($order_by_name, ENT_QUOTES, 'UTF-8') . '" value="' . htmlspecialchars((string)$request_order_by_name, ENT_QUOTES, 'UTF-8') . '" />'
                . '<input type="hidden" name="' . htmlspecialchars(CsrfAuthenticator::FORM_TOKEN_FIELD, ENT_COMPAT) . '" value="' . htmlspecialchars(CsrfAuthenticator::getInstance()->getFormToken(), ENT_COMPAT) . '" />';
        }

// cn: bug 9103 - MU navigation in emails is broken
        if ($module == 'Emails') {
            // determine "type" - inbound, archive, etc.
            $type = $this->request->getValidInputRequest('type');
            // determine owner
            $tempString .= "<input type='hidden' name='type' value='" . htmlspecialchars((string)$type, ENT_QUOTES, 'UTF-8') . "' />\n"
                . "<input type='hidden' name='ie_assigned_user_id' value='" . htmlspecialchars($current_user->id, ENT_QUOTES, 'UTF-8') . "' />";
        }

return $tempString;
    }

/**
     * Executes the massupdate form
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     */
    public function handleMassUpdate($fetch_only = false, $update_blank = false)
    {

require_once 'include/formbase.php';
        global $current_user, $db, $disable_date_format, $timedate, $app_strings;
        $retval = [];

foreach ($_POST as $post => $value) {
            if (is_array($value)) {
                if (empty($value)) {
                    unset($_POST[$post]);
                }
            } elseif (strlen($value) == 0) {
                if (!$update_blank) {
                    if (isset($this->sugarbean->field_defs[$post]) && $this->sugarbean->field_defs[$post]['type'] == 'radioenum' && isset($_POST[$post])) {
                        $_POST[$post] = '';
                    } else {
                        unset($_POST[$post]);
                    }
                }
            }

if (is_string($value) && isset($this->sugarbean->field_defs[$post])) {
                if (($this->sugarbean->field_defs[$post]['type'] == 'bool'
                    || (
                        !empty($this->sugarbean->field_defs[$post]['custom_type']) && $this->sugarbean->field_defs[$post]['custom_type'] == 'bool'
                    ))) {
                    if (strcmp($value, '2') == 0) {
                        $_POST[$post] = 0;
                    }
                    if (!empty($this->sugarbean->field_defs[$post]['dbType']) && strcmp($this->sugarbean->field_defs[$post]['dbType'], 'varchar') == 0) {
                        $_POST[$post] = strcmp($value, '1') == 0 ? 'on' : 'off';
                    }
                }

if (($this->sugarbean->field_defs[$post]['type'] == 'radioenum' && isset($_POST[$post]) && strlen($value) == 0)
                    || ($this->sugarbean->field_defs[$post]['type'] == 'enum' && $value == '__SugarMassUpdateClearField__') // Set to '' if it's an explicit clear
                ) {
                    $_POST[$post] = '';
                }
                if ($this->sugarbean->field_defs[$post]['type'] == 'bool') {
                    $this->checkClearField($post, $value);
                }
                if ($this->sugarbean->field_defs[$post]['type'] == 'date' && !empty($_POST[$post])) {
                    $_POST[$post] = $timedate->to_db_date($_POST[$post], false);
                }
                if ($this->sugarbean->field_defs[$post]['type'] == 'datetime' && !empty($_POST[$post])) {
                    $_POST[$post] = $timedate->to_db($this->date_to_dateTime($post, $value));
                }
                if ($this->sugarbean->field_defs[$post]['type'] == 'datetimecombo' && !empty($_POST[$post])) {
                    $_POST[$post] = $timedate->to_db($_POST[$post]);
                }
            }
        }

//We need to disable_date_format so that date values for the beans remain in database format
        //notice we make this call after the above section since the calls to TimeDate class there could wind up
        //making it's way to the UserPreferences objects in which case we want to enable the global date formatting
        //to correctly retrieve the user's date format preferences
        $old_value = $disable_date_format;
        $disable_date_format = true;

if (!empty($_REQUEST['uid']) && !isset($_REQUEST['entire'])) {
            $_POST['mass'] = $this->request->getValidInputRequest(
                'uid',
                ['Assert\Delimited' => ['constraints' => 'Assert\Guid']]
            );
        } elseif (isset($_REQUEST['entire']) && empty($_POST['mass'])) {
            if (empty($order_by)) {
                $order_by = '';
            }

// TODO: define filter array here to optimize the query
            // by not joining the unneeded tables
            $query = $this->sugarbean->create_new_list_query($order_by, $this->where_clauses, [], [], 0, '', false, $this, true, true);
            $result = $db->query($query, true);
            $new_arr = [];
            while ($val = $db->fetchByAssoc($result, false)) {
                array_push($new_arr, $val['id']);
            }
            $_POST['mass'] = $new_arr;
        }

if ($fetch_only) {
            return;
        }

/*-- Is Request to Add or Delete  one or more Prospects from One or More Prospect Lists ?? --*/
        if (isset($_POST['mass']) && is_array($_POST['mass']) &&
            (!empty($_POST['add_to_prospect_lists']) || !empty($_POST['remove_from_prospect_lists']))) {
            if (!empty($_POST['remove_from_prospect_lists'])) {
                $bean_name = $_POST['module'];
                $prospect_list_ids = explode(',', $_POST['remove_from_prospect_lists']);
                $uids = $_POST['mass'];
                if (safeCount($uids) > 0 && safeCount($prospect_list_ids) > 0) {
                    foreach ($prospect_list_ids as $prospect_list_id) {
                        $this->remove_prospects_from_prospect_list($bean_name, $prospect_list_id, $uids);
                    }
                }
            } elseif (!empty($_POST['add_to_prospect_lists'])) {
                $bean_name = $_POST['module'];
                $prospect_list_ids = explode(',', $_POST['add_to_prospect_lists']);
                $uids = $_POST['mass'];
                if (safeCount($uids) > 0 && safeCount($prospect_list_ids) > 0) {
                    foreach ($prospect_list_ids as $prospect_list_id) {
                        $this->add_prospects_to_prospect_list($bean_name, $prospect_list_id, $uids);
                    }
                }
            }

return;
        }

if (isset($_POST['mass']) && is_array($_POST['mass']) && $_REQUEST['massupdate'] == 'true') {
            $count = 0;

if (isset($_SESSION['REASSIGN_TEAMS'])) {
                unset($_SESSION['REASSIGN_TEAMS']);
            }

// should use 'User Type' to change this field
            if ($this->sugarbean->object_name == 'User' && isset($_POST['is_admin'])) {
                unset($_POST['is_admin']);
            }

foreach ($_POST['mass'] as $id) {
                if (empty($id)) {
                    continue;
                }
                if (isset($_POST['Delete'])) {
                    // disable row level security so that bean can be retrieved for checking ACL access.
                    $this->sugarbean->disable_row_level_security = true;
                    $this->sugarbean->retrieve($id);
                    if ($this->sugarbean->ACLAccess('Delete')) {
                        // Fix for RS-1267 - We should not processing mass delete for global team
                        if ($this->sugarbean->object_name == 'Team' &&
                            $this->sugarbean->id == $this->sugarbean->global_team
                        ) {
                            $retval[] = $id;
                            SugarApplication::appendErrorMessage($app_strings['LBL_MASSUPDATE_DELETE_GLOBAL_TEAM']);
                            continue;
                        }

if ($this->sugarbean->object_name == 'Team' && $this->sugarbean->has_records_in_modules()) {
                            if (!isset($_SESSION['REASSIGN_TEAMS'])) {
                                $_SESSION['REASSIGN_TEAMS'] = [];
                            }
                            $_SESSION['REASSIGN_TEAMS'][] = $this->sugarbean->id;
                            continue;
                        }
                        $this->sugarbean->mark_deleted($id);
                        $this->sugarbean->save(false);
                    } else {
                        $retval[] = $id;
                    }
                } else {
                    if ($this->sugarbean->object_name == 'Contact' && isset($_POST['Sync'])) { // special for contacts module
                        if ($_POST['Sync'] == 'true') {
                            $this->sugarbean->retrieve($id);
                            if ($this->sugarbean->ACLAccess('Save')) {
                                if ($this->sugarbean->object_name == 'Contact') {
                                    $this->sugarbean->contacts_users_id = $current_user->id;
                                    $this->sugarbean->save(false);
                                }
                            }
                        } elseif ($_POST['Sync'] == 'false') {
                            $this->sugarbean->retrieve($id);
                            if ($this->sugarbean->ACLAccess('Save')) {
                                if ($this->sugarbean->object_name == 'Contact') {
                                    if (!isset($this->sugarbean->users)) {
                                        $this->sugarbean->load_relationship('user_sync');
                                    }
                                    $this->sugarbean->contacts_users_id = null;
                                    $this->sugarbean->user_sync->delete($this->sugarbean->id, $current_user->id);
                                }
                            }
                        }
                    } //end if for special Contact handling

if ($count++ != 0) {
                        //Create a new instance to clear values and handle additional updates to bean's 2,3,4...
                        $this->sugarbean = $this->sugarbean->getCleanCopy();
                    }

$this->sugarbean->retrieve($id);

if ($this->sugarbean->ACLAccess('Save', ['massupdate' => true])) {
                        $_POST['record'] = $id;
                        $_GET['record'] = $id;
                        $_REQUEST['record'] = $id;
                        $newbean = $this->sugarbean;

// ACL check above should have blocked non-admin users
                        if ($newbean->object_name == 'User') {
                            //admin can't change his own status and user type
                            if ($current_user->id == $id && (isset($_POST['UserType']) || isset($_POST['status']))) {
                                continue;
                            }
                            if (isset($_POST['UserType'])) {
                                if ($_POST['UserType'] == 'Administrator') {
                                    $newbean->is_admin = 1;
                                } elseif ($_POST['UserType'] == 'RegularUser') {
                                    $newbean->is_admin = 0;
                                }
                            }
                        }

$old_reports_to_id = null;
                        if (!empty($_POST['reports_to_id']) && $newbean->reports_to_id != $_POST['reports_to_id']) {
                            $old_reports_to_id = empty($newbean->reports_to_id) ? 'null' : $newbean->reports_to_id;
                        }

$check_notify = false;

if (isset($this->sugarbean->assigned_user_id)) {
                            $old_assigned_user_id = $this->sugarbean->assigned_user_id;
                            if (!empty($_POST['assigned_user_id'])
                                && ($old_assigned_user_id != $_POST['assigned_user_id'])
                                && ($_POST['assigned_user_id'] != $current_user->id)) {
                                $check_notify = true;
                            }
                        }

//Call include/formbase.php, but do not call retrieve again
                        populateFromPost('', $newbean, true);
                        $newbean->save_from_post = false;

if (!isset($_POST['parent_id'])) {
                            $newbean->parent_type = null;
                        }

$email_address_id = '';
                        if (!empty($_POST['optout_primary'])) {
                            $optout_flag_value = 0;
                            if ($_POST['optout_primary'] == 'true') {
                                $optout_flag_value = 1;
                            } // if
                            if (isset($this->sugarbean->emailAddress)) {
                                if (!empty($this->sugarbean->emailAddress->addresses)) {
                                    foreach ($this->sugarbean->emailAddress->addresses as $key => $emailAddressRow) {
                                        if ($emailAddressRow['primary_address'] == '1') {
                                            $email_address_id = $emailAddressRow['email_address_id'];
                                            break;
                                        } // if
                                    } // foreach
                                } // if
                            } // if
                        } // if
                        // Before calling save, we need to clear out any existing registered AWF
                        // triggered start events so they can continue to trigger.
                        Registry\Registry::getInstance()->drop('triggered_starts');
                        $newbean->save($check_notify);
                        if ($newbean instanceof User && !empty($newbean->error_string)) {
                            SugarApplication::appendErrorMessage($newbean->error_string);
                            return $_POST['mass'];
                        }
                        if (!empty($email_address_id)) {
                            $query = 'UPDATE email_addresses SET opt_out = ? where id = ?';
                            DBManagerFactory::getInstance()->getConnection()->executeStatement(
                                $query,
                                [$optout_flag_value, $emailAddressRow['email_address_id']]
                            );
                        } // if

if (!empty($old_reports_to_id) && method_exists($newbean, 'update_team_memberships')) {
                            $old_id = $old_reports_to_id == 'null' ? '' : $old_reports_to_id;
                            $newbean->update_team_memberships($old_id);
                        }
                    }
                }
            }

if (isset($_SESSION['REASSIGN_TEAMS'])) {
                header('Location: index.php?module=Teams&action=ReassignTeams');
                die();
            }
        }
        $disable_date_format = $old_value;
        return $retval;
    }

public static function setMassUpdateFielddefs(array $fielddefs, $moduleName)
    {
        $banned = ['date_modified' => 1, 'date_entered' => 1, 'created_by' => 1, 'modified_user_id' => 1, 'deleted' => 1, 'modified_by_name' => 1,];

foreach ($fielddefs as $name => $def) {
            // Readonly fields are NOT be massupdatable
            if (!empty($def['readonly'])) {
                $def['massupdate'] = false;
                // Calculated fields that are enforced are NOT massupdatable
            } elseif (isset($def['calculated']) && self::isTrue($def['calculated']) && isset($def['enforced']) && self::isTrue($def['enforced'])) {
                // Then massupdate has to be false
                $def['massupdate'] = false;
            } elseif (isset($def['massupdate'])) {
                // The massupdate value has to be boolean so the client can properly
                // handle it. A "0" false renders as a true to the client.
                if (self::isTrue($def['massupdate'])) {
                    $def['massupdate'] = true;
                } else {
                    $def['massupdate'] = false;
                }
            } elseif (isset($def['type'])) {
                if (!isset($banned[$def['name']]) && (!isset($def['massupdate']) || !empty($def['massupdate']))) {
                    switch ($def['type']) {
                        case 'relate':
                            if (isset($def['id_name'])) {
                                $def['massupdate'] = true;
                            }
                            break;
                        case 'contact_id':
                        case 'assigned_user_name':
                        case 'account_id':
                        case 'account_name':
                        case 'bool':
                        case 'parent':
                        case 'enum':
                        case 'multienum':
                        case 'radioenum':
                        case 'datetime':
                        case 'date':
                        case 'datetimecombo':
                        case 'decimal':
                        case 'float':
                        case 'encrypt':
                        case 'iframe':
                        case 'phone':
                        case 'url':
                        case 'varchar':
                            $def['massupdate'] = true;
                            break;
                        case 'int':
                            if (!empty($field['massupdate']) && empty($field['auto_increment'])) {
                                $def['massupdate'] = true;
                            }
                            break;
                        case 'inbound':
                            if ($moduleName == 'Emails') {
                                //TODO:Archive emails
                            }
                            break;
                    }

if (isset($def['id_name']) && isset($fielddefs[$def['id_name']])) {
                        $fielddefs[$def['id_name']]['massupdate'] = false;
                    }
                }
            }
            $fielddefs[$name] = $def;
        }

if ($moduleName == 'Contacts') {
            $fielddefs['sync_contact']['massupdate'] = true;
        } elseif ($moduleName == 'Employees') {
            $fielddefs['employee_status']['massupdate'] = true;
            $fielddefs['employee_status']['type'] = 'enum';
            $fielddefs['employee_status']['options'] = 'employee_status_dom';
        } elseif ($moduleName == 'InboundEmail') {
            $fielddefs['status']['massupdate'] = true;
            $fielddefs['status']['type'] = 'enum';
            $fielddefs['status']['options'] = 'user_status_dom';
        }

return $fielddefs;
    }

/**
     * Displays the massupdate form
     */
    public function getMassUpdateForm(
        $hideDeleteIfNoFieldsAvailable = false
    ) {

global $app_strings;
        global $current_user;

if (!$this->sugarbean->ACLAccess('edit', true) && !$this->sugarbean->ACLAccess('massupdate', true)) {
            return '';
        }

$lang_delete = translate('LBL_DELETE');
        $lang_update = translate('LBL_UPDATE');
        $lang_confirm = translate('NTC_DELETE_CONFIRMATION_MULTIPLE');
        $lang_sync = translate('LBL_SYNC_CONTACT');
        $lang_unsync = translate('LBL_UNSYNC');
        $lang_archive = translate('LBL_ARCHIVE');
        $lang_optout_primaryemail = $app_strings['LBL_OPT_OUT_FLAG_PRIMARY'];

$field_count = 0;

$html = "<div id='massupdate_form' style='display:none;'><table width='100%' cellpadding='0' cellspacing='0' border='0' class='formHeader h3Row'><tr><td nowrap><h3><span>" . $app_strings['LBL_MASS_UPDATE'] . '</h3></td></tr></table>';
        $html .= "<div id='mass_update_div'><table cellpadding='0' cellspacing='1' border='0' width='100%' class='edit view' id='mass_update_table'>";

$even = true;

if ($this->sugarbean->object_name == 'Contact') {
            $html .= "<tr><td width='15%' scope='row'>$lang_sync</td><td width='35%' class='dataField'><select name='Sync'><option value=''>{$GLOBALS['app_strings']['LBL_NONE']}</option><option value='false'>{$GLOBALS['app_list_strings']['checkbox_dom']['2']}</option><option value='true'>{$GLOBALS['app_list_strings']['checkbox_dom']['1']}</option></select></td>";
            $even = false;
        } elseif ($this->sugarbean->object_name == 'Employee') {
            $this->sugarbean->field_defs['employee_status']['type'] = 'enum';
            $this->sugarbean->field_defs['employee_status']['massupdate'] = true;
            $this->sugarbean->field_defs['employee_status']['options'] = 'employee_status_dom';
        } elseif ($this->sugarbean->object_name == 'InboundEmail') {
            $this->sugarbean->field_defs['status']['type'] = 'enum';
            $this->sugarbean->field_defs['status']['options'] = 'user_status_dom';
        } elseif ($this->sugarbean->object_name == 'User') {
            $this->sugarbean->field_defs['license_type']['type'] = 'enum';
        }

//These fields should never appear on mass update form
        static $banned = ['date_modified' => 1, 'date_entered' => 1, 'created_by' => 1, 'modified_user_id' => 1, 'deleted' => 1, 'modified_by_name' => 1,];

if (in_array($this->sugarbean->module_name, $this->idmConfig->getIDMModeDisabledModules())
            && $this->idmConfig->isIDMModeEnabled()
        ) {
            $banned += $this->idmConfig->getIDMModeDisabledFields();
        }

foreach ($this->sugarbean->field_defs as $field) {
            if (!$this->sugarbean->ACLFieldAccess($field['name'], 'edit')) {
                continue;
            }

if ($this->sugarbean->object_name == 'User' && $field['name'] == 'is_admin') {
                // already have 'User Type'
                continue;
            }
            if ($this->idmConfig->isIDMModeEnabled()
                && $this->sugarbean->object_name == 'User'
                && $field['name'] == 'UserType') {
                // Explicitly disabled for IDM-mode
                continue;
            }
            if (!isset($banned[$field['name']]) && (!isset($field['massupdate']) || !empty($field['massupdate']))) {
                $newhtml = '';

if ($even) {
                    $newhtml .= '<tr>';
                }

if (isset($field['vname'])) {
                    $displayname = translate($field['vname']);
                } else {
                    $displayname = '';
                }

if (isset($field['type']) && $field['type'] == 'relate' && isset($field['id_name']) && $field['id_name'] == 'assigned_user_id') {
                    $field['type'] = 'assigned_user_name';
                }

if (isset($field['custom_type'])) {
                    $field['type'] = $field['custom_type'];
                }

if (isset($field['type'])) {
                    switch ($field['type']) {
                        case 'relate':
                            // bug 14691: avoid laying out an empty cell in the <table>
                            $handleRelationship = $this->handleRelationship($displayname, $field);
                            if ($handleRelationship != '') {
                                $even = !$even;
                                $newhtml .= $handleRelationship;
                            }
                            break;
                        case 'parent':
                            $even = !$even;
                            $newhtml .= $this->addParent($displayname, $field);
                            break;
                        case 'int':
                            if (!empty($field['massupdate']) && empty($field['auto_increment'])) {
                                $even = !$even;
                                $newhtml .= $this->addInputType($displayname, $field['name']);
                            }
                            break;
                        case 'contact_id':
                            $even = !$even;
                            $newhtml .= $this->addContactID($displayname, $field['name']);
                            break;
                        case 'assigned_user_name':
                            $even = !$even;
                            $newhtml .= $this->addAssignedUserID($displayname, $field['name']);
                            break;
                        case 'account_id':
                            $even = !$even;
                            $newhtml .= $this->addAccountID($displayname, $field['name']);
                            break;
                        case 'account_name':
                            $even = !$even;
                            $newhtml .= $this->addAccountID($displayname, $field['id_name']);
                            break;
                        case 'bool':
                            $even = !$even;
                            $newhtml .= $this->addBool($displayname, $field['name']);
                            break;
                        case 'enum':
                        case 'multienum':
                            if (!empty($field['isMultiSelect'])) {
                                if (!empty($field['function'])) {
                                    $functionValue = getFunctionValue(
                                        $field['function_bean'] ?? null,
                                        $field['function'],
                                        [$this->sugarbean, $field['name'], '', 'MassUpdate']
                                    );
                                    $field['options'] = $functionValue;
                                }

// translate the value
                                if (is_string($field['options'])) {
                                    $translatedOptions = translate($field['options']);
                                } else {
                                    foreach ($field['options'] as $key => $value) {
                                        $translatedOptions[$key] = translate($value);
                                    }
                                }
                                $even = !$even;
                                $showNullOption = !(isset($field['showNullOption']) && empty($field['showNullOption']));
                                $newhtml .= $this->addStatusMulti($displayname, $field['name'], $translatedOptions, $showNullOption);
                                break;
                            } elseif (!empty($field['options'])) {
                                $even = !$even;
                                $newhtml .= $this->addStatus($displayname, $field['name'], translate($field['options']));
                                break;
                            } elseif (!empty($field['function'])) {
                                $functionValue = getFunctionValue(
                                    $field['function_bean'] ?? null,
                                    $field['function'],
                                    [$this->sugarbean, $field['name'], '', 'MassUpdate']
                                );
                                $even = !$even;
                                $newhtml .= $this->addStatus($displayname, $field['name'], $functionValue);
                                break;
                            }
                            break;
                        case 'radioenum':
                            $even = !$even;
                            $newhtml .= $this->addRadioenum($displayname, $field['name'], translate($field['options']));
                            break;
                        case 'datetimecombo':
                            $even = !$even;
                            $newhtml .= $this->addDatetime($displayname, $field['name']);
                            break;
                        case 'datetime':
                        case 'date':
                            $even = !$even;
                            $newhtml .= $this->addDate($displayname, $field['name']);
                            break;
                        case 'team_list':
                            $teamhtml = $this->addTeamList(translate('LBL_TEAMS'), $field);
                            break;
                        default:
                            $newhtml .= $this->addDefault($displayname, $field, $even);
                            break;
                            break;
                    }
                }

if ($even) {
                    $newhtml .= '</tr>';
                }

$field_count++;

if (!in_array($newhtml, ['<tr>', '</tr>', '<tr></tr>', '<tr><td></td></tr>'])) {
                    $html .= $newhtml;
                }
            }
        }

if (isset($teamhtml)) {
            if (!$even) {
                $teamhtml .= '</tr>';
            }

if (!in_array($teamhtml, ['<tr>', '</tr>', '<tr></tr>', '<tr><td></td></tr>'])) {
                $html .= $teamhtml;
            }

$field_count++;
        }
        $html .= '</table>';

$html .= "<table cellpadding='0' cellspacing='0' border='0' width='100%'><tr><td class='buttons'><input onclick='return sListView.send_mass_update(\"selected\", \"{$app_strings['LBL_LISTVIEW_NO_SELECTED']}\")' type='submit' id='update_button' name='Update' value='{$lang_update}' class='button'>&nbsp;<input onclick='javascript:toggleMassUpdateForm();' type='button' id='cancel_button' name='Cancel' value='{$GLOBALS['app_strings']['LBL_CANCEL_BUTTON_LABEL']}' class='button'>";

// only for My Inbox views - to allow CSRs to have an "Archive" emails feature to get the email "out" of their inbox.
        if ($this->sugarbean->object_name == 'Email'
            && (isset($_REQUEST['assigned_user_id']) && !empty($_REQUEST['assigned_user_id']))
            && (isset($_REQUEST['type']) && !empty($_REQUEST['type']) && $_REQUEST['type'] == 'inbound')) {
            $html .= <<<eoq
			<input type='button' name='archive' value="{$lang_archive}" class='button' onClick='setArchived();'>
			<input type='hidden' name='ie_assigned_user_id' value="{$current_user->id}">
			<input type='hidden' name='ie_type' value="inbound">
eoq;
        }

if ($this->sugarbean->object_name == 'User' && ($current_user->is_admin || $current_user->isAdminForModule('Users'))) {
            $html .= <<<eoq
            <input type='hidden' name='current_admin_id' value="{$current_user->id}">
eoq;
        }
        $html .= '</td></tr></table></div></div>';

$html .= <<<EOJS
<script>
function toggleMassUpdateForm(){
    document.getElementById('massupdate_form').style.display = 'none';
}
</script>
EOJS;

if ($field_count > 0) {
            return $html;
        } else {
            //If no fields are found, render either a form that still permits Mass Update deletes or just display a message that no fields are available
            $html = "<div id='massupdate_form' style='display:none;'><table width='100%' cellpadding='0' cellspacing='0' border='0' class='formHeader h3Row'><tr><td nowrap><h3><span>" . $app_strings['LBL_MASS_UPDATE'] . '</h3></td></tr></table>';
            if ($this->sugarbean->ACLAccess('Delete', true) && !$hideDeleteIfNoFieldsAvailable) {
                $html .= "<table cellpadding='0' cellspacing='0' border='0' width='100%'><tr><td><input type='submit' name='Delete' value='$lang_delete' onclick=\"return confirm('{$lang_confirm}')\" class='button'></td></tr></table></div>";
            } else {
                $html .= $app_strings['LBL_NO_MASS_UPDATE_FIELDS_AVAILABLE'] . '</div>';
            }
            return $html;
        }
    }

/**
     * Returns end of the massupdate form
     */
    public function endMassUpdateForm()
    {
        return '</form>';
    }

/**
     * Decides which popup HTML code is needed for mass updating
     * @param displayname Name to display in the popup window
     * @param field name of the field to update
     */
    public function handleRelationship($displayname, $field)
    {
        $ret_val = '';
        if (isset($field['module'])) {
            if ($field['name'] == 'reports_to_name' && ($field['module'] == 'Users' || $field['module'] == 'Employee')) {
                return $this->addUserName($displayname, $field['name'], $field['id_name'], $field['module']);
            }

switch ($field['module']) {
                case 'Accounts':
                    $ret_val = $this->addAccountID($displayname, $field['name'], $field['id_name']);
                    break;
                case 'Contacts':
                    $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], 'Contacts');
                    break;
                case 'Users':
                    $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], 'Users');
                    break;
                case 'Employee':
                    $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], 'Employee');
                    break;
                case 'Releases':
                    $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], 'Releases');
                    break;
                default:
                    if (!empty($field['massupdate'])) {
                        $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], $field['module']);
                    }
                    break;
            }
        }

return $ret_val;
    }

/**
     * Add a parent selection popup window
     * @param displayname Name to display in the popup window
     * @param field_name name of the field
     */
    public function addParent($displayname, $field)
    {
        global $app_strings, $app_list_strings;

///////////////////////////////////////
        ///
        /// SETUP POPUP

$popup_request_data = [
            'call_back_function' => 'set_return',
            'form_name' => 'MassUpdate',
            'field_to_name_array' => [
                'id' => 'parent_id',
                'name' => 'parent_name',
            ],
        ];

$json = getJSONobj();
        $encoded_popup_request_data = $json->encode($popup_request_data);

$qsName = [
            'form' => 'MassUpdate',
            'method' => 'query',
            'modules' => ['Accounts'],
            'group' => 'or',
            'field_list' => ['name', 'id'],
            'populate_list' => ['mass_parent_name', 'mass_parent_id'],
            'conditions' => [['name' => 'name', 'op' => 'like_custom', 'end' => '%', 'value' => '']],
            'limit' => '30', 'no_match_text' => $app_strings['ERR_SQS_NO_MATCH']];
        $qsName = $json->encode($qsName);

//
        ///////////////////////////////////////

$change_parent_button = "<span class='id-ff'><button title='" . $app_strings['LBL_SELECT_BUTTON_TITLE'] . "'  type='button' class='button' value='" . $app_strings['LBL_SELECT_BUTTON_LABEL']
            . "' name='button_parent_name' onclick='open_popup(document.MassUpdate.{$field['type_name']}.value, 600, 400, \"\", true, false, {$encoded_popup_request_data});'>
			" . SugarThemeRegistry::current()->getImage('id-ff-select', '', null, null, '.png', $app_strings['LBL_ID_FF_SELECT']) . '
			</button></span>';
        $parent_type = $field['parent_type'];
        $parent_types = $app_list_strings[$parent_type];
        $disabled_parent_types = SugarACL::disabledModuleList($parent_types);
        foreach ($disabled_parent_types as $disabled_parent_type) {
            unset($parent_types[$disabled_parent_type]);
        }
        $types = get_select_options_with_id($parent_types, '');
        //BS Fix Bug 17110
        $pattern = "#\n<OPTION.*" . $app_strings['LBL_NONE'] . '</OPTION>#';
        $types = preg_replace($pattern, '', $types);
        // End Fix

$json = getJSONobj();
        $disabled_parent_types = $json->encode($disabled_parent_types);

return <<<EOHTML
<td width="15%" scope="row">{$displayname} </td>
<td>
    <table width='100%' border='0' cellspacing='0' cellpadding='0'>
    <tr>
        <td valign='top'>
            <select name='{$field['type_name']}' id='mass_{$field['type_name']}'>
                $types
            </select>
        </td>
        <td valign='top'>
			<input name='{$field['id_name']}' id='mass_{$field['id_name']}' type='hidden' value=''>
			<input name='parent_name' id='mass_parent_name' class='sqsEnabled' autocomplete='off'
                type='text' value=''>
            $change_parent_button
        </td>
    </tr>
    </table>
</td>
<script type="text/javascript">
<!--
var disabledModules='{$disabled_parent_types}';
if(typeof sqs_objects == 'undefined'){
    var sqs_objects = new Array;
}
sqs_objects['MassUpdate_parent_name'] = $qsName;
registerSingleSmartInputListener(document.getElementById('mass_parent_name'));
addToValidateBinaryDependency('MassUpdate', 'parent_name', 'alpha', false, '{$app_strings['ERR_SQS_NO_MATCH_FIELD']} {$app_strings['LBL_ASSIGNED_TO']}','parent_id');

document.getElementById('mass_{$field['type_name']}').onchange = function()
{
    document.MassUpdate.parent_name.value="";
    document.MassUpdate.parent_id.value="";

new_module = document.forms["MassUpdate"].elements["parent_type"].value;

if(typeof(disabledModules[new_module]) != 'undefined') {
		sqs_objects["MassUpdate_parent_name"]["disable"] = true;
		document.forms["MassUpdate"].elements["parent_name"].readOnly = true;
	} else {
		sqs_objects["MassUpdate_parent_name"]["disable"] = false;
		document.forms["MassUpdate"].elements["parent_name"].readOnly = false;
	}
	sqs_objects["MassUpdate_parent_name"]["modules"] = new Array(new_module);
    enableQS(false);

checkParentType(document.MassUpdate.parent_type.value, document.MassUpdate.button_parent_name);
}
-->
</script>
EOHTML;
    }

/**
     * Add a generic input type='text' field
     * @param displayname Name to display in the popup window
     * @param field_name name of the field
     */
    public function addInputType($displayname, $varname)
    {
        //letrium ltd
        $displayname = addslashes($displayname);
        $html = <<<EOQ
	<td scope="row" width="20%">$displayname</td>
	<td class='dataField' width="30%"><input type="text" name='$varname' size="12" id='{$varname}' maxlength='10' value=""></td>
	<script> addToValidate('MassUpdate','$varname','int',false,'$displayname');</script>
EOQ;
        return $html;
    }

/**
     * Add a generic widget to lookup Users.
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     * @param id_name name of the id in vardef
     * @param mod_type name of the module, either "Contact" or "Releases" currently
     */
    public function addUserName(string $displayname, string $varname, string $id_name, string $mod_type)
    {
        global $app_strings;

if (empty($id_name)) {
            $id_name = strtolower($mod_type) . '_id';
        }

///////////////////////////////////////
        ///
        /// SETUP POPUP
        $reportsDisplayName = showFullName() ? 'name' : 'user_name';
        $popup_request_data = [
            'call_back_function' => 'set_return',
            'form_name' => 'MassUpdate',
            'field_to_name_array' => [
                'id' => "{$id_name}",
                "$reportsDisplayName" => "{$varname}",
            ],
        ];

$json = getJSONobj();
        $encoded_popup_request_data = $json->encode($popup_request_data);

$qsName = [
            'form' => 'MassUpdate',
            'method' => 'get_user_array',
            'modules' => ["{$mod_type}"],
            'group' => 'or',
            'field_list' => ['user_name', 'id'],
            'populate_list' => ["mass_{$varname}", "mass_{$id_name}"],
            'conditions' => [['name' => 'name', 'op' => 'like_custom', 'end' => '%', 'value' => '']],
            'limit' => '30', 'no_match_text' => $app_strings['ERR_SQS_NO_MATCH']];
        $qsName = $json->encode($qsName);
        //
        ///////////////////////////////////////

return <<<EOHTML
<td width='15%'  scope='row' class='dataLabel'>$displayname</td>
<td width='35%' class='dataField'>
    <input name='{$varname}' id='mass_{$varname}' class='sqsEnabled' autocomplete='off' type='text' value=''>
    <input name='{$id_name}' id='mass_{$id_name}' type='hidden' value=''>&nbsp;
    <input title='{$app_strings['LBL_SELECT_BUTTON_TITLE']}'
        type='button' class='button' value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name='button'
        onclick='open_popup("$mod_type", 600, 400, "", true, false, {$encoded_popup_request_data});'
        />
</td>
<script type="text/javascript">

</script>
EOHTML;
    }

/**
     * Add a generic module popup selection popup window HTML code.
     * Currently supports Contact and Releases
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     * @param id_name name of the id in vardef
     * @param mod_type name of the module, either "Contact" or "Releases" currently
     */
    public function addGenericModuleID(string $displayname, string $varname, string $id_name, string $mod_type): string
    {
        global $app_strings;

if (empty($id_name)) {
            $id_name = strtolower($mod_type) . '_id';
        }

///////////////////////////////////////
        ///
        /// SETUP POPUP

$popup_request_data = [
            'call_back_function' => 'set_return',
            'form_name' => 'MassUpdate',
            'field_to_name_array' => [
                'id' => "{$id_name}",
                'name' => "{$varname}",
            ],
        ];

$json = getJSONobj();
        $encoded_popup_request_data = $json->encode($popup_request_data);

$qsName = [
            'form' => 'MassUpdate',
            'method' => 'query',
            'modules' => ["{$mod_type}"],
            'group' => 'or',
            'field_list' => ['name', 'id'],
            'populate_list' => ["mass_{$varname}", "mass_{$id_name}"],
            'conditions' => [['name' => 'name', 'op' => 'like_custom', 'end' => '%', 'value' => '']],
            'limit' => '30', 'no_match_text' => $app_strings['ERR_SQS_NO_MATCH']];
        $qsName = $json->encode($qsName);
        $img = SugarThemeRegistry::current()->getImageURL('id-ff-select.png');
        //
        ///////////////////////////////////////

return <<<EOHTML
<td width='15%'  scope='row' class='dataLabel'>$displayname</td>
<td width='35%' class='dataField'>
    <input name='{$varname}' id='mass_{$varname}' class='sqsEnabled' autocomplete='off' type='text' value=''>
    <input name='{$id_name}' id='mass_{$id_name}' type='hidden' value=''>
	<span class="id-ff multiple">
    <button title='{$app_strings['LBL_SELECT_BUTTON_TITLE']}'
        type='button' class='button' value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name='button'
        onclick='open_popup("$mod_type", 600, 400, "", true, false, {$encoded_popup_request_data});'
        /><img alt="$img" src="$img"></button></span>
</td>
<script type="text/javascript">

</script>
EOHTML;
    }

/**
     * Add Account selection popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     * @param id_name name of the id in vardef
     */
    public function addAccountID($displayname, $varname, $id_name = '')
    {
        global $app_strings;

$json = getJSONobj();

if (empty($id_name)) {
            $id_name = 'account_id';
        }

///////////////////////////////////////
        ///
        /// SETUP POPUP

$encoded_popup_request_data = $json->encode($popup_request_data);

//
        ///////////////////////////////////////

$qsParent = [
            'form' => 'MassUpdate',
            'method' => 'query',
            'modules' => ['Accounts'],
            'group' => 'or',
            'field_list' => ['name', 'id'],
            'populate_list' => ['parent_name', 'parent_id'],
            'conditions' => [['name' => 'name', 'op' => 'like_custom', 'end' => '%', 'value' => '']],
            'order' => 'name',
            'limit' => '30',
            'no_match_text' => $app_strings['ERR_SQS_NO_MATCH'],
        ];
        $qsParent['populate_list'] = ['mass_' . $varname, 'mass_' . $id_name];
        $img = SugarThemeRegistry::current()->getImageURL('id-ff-select.png');
        $html = '<td scope="row">' . Escape::html($displayname) . " </td>\n"
            . '<td><input class="sqsEnabled" type="text" autocomplete="off" id="mass_' . $varname . '" name="' . $varname . '" value="" /><input id="mass_' . $id_name . '" type="hidden" name="'
            . $id_name . '" value="" />&nbsp;<span class="id-ff multiple"><button type="button" name="btn1" class="button" title="'
            . $app_strings['LBL_SELECT_BUTTON_LABEL'] . '"  value="' . $app_strings['LBL_SELECT_BUTTON_LABEL'] . '" onclick='
            . "'open_popup(\"Accounts\",600,400,\"\",true,false,{$encoded_popup_request_data});' /><img alt=\"$img\" src=\"$img\"></button></span></td>\n";
        $html .= '<script type="text/javascript" language="javascript">if(typeof sqs_objects == \'undefined\'){var sqs_objects = new Array;}sqs_objects[\'MassUpdate_' . $varname . '\'] = ' .
            $json->encode($qsParent) . '; registerSingleSmartInputListener(document.getElementById(\'mass_' . $varname . '\'));
					addToValidateBinaryDependency(\'MassUpdate\', \'' . $varname . '\', \'alpha\', false, \'' . $app_strings['ERR_SQS_NO_MATCH_FIELD'] . $app_strings['LBL_ACCOUNT'] . '\',\'' . $id_name . '\');
					</script>';

return $html;
    }

/**
     * Add Team selection popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     */
    public function addTeamList($displayname, $field)
    {
        $sfh = new SugarFieldHandler();
        $field['custom_type'] = 'Teamset';
        $field['name'] = 'team_name';
        $html = "<td width='15%' scope='row'>$displayname</td>";
        $html .= '<td>' . $sfh->displaySmarty('fields', $field, 'MassUpdateView') . '</td>';
        return $html;
    }

/**
     * Add AssignedUser popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     */
    public function addAssignedUserID($displayname, $varname)
    {
        global $app_strings;

$json = getJSONobj();

$popup_request_data = [
            'call_back_function' => 'set_return',
            'form_name' => 'MassUpdate',
            'field_to_name_array' => [
                'id' => 'assigned_user_id',
                'user_name' => 'assigned_user_name',
            ],
        ];
        $encoded_popup_request_data = $json->encode($popup_request_data);
        $qsUser = [
            'form' => 'MassUpdate',
            'method' => 'get_user_array', // special method
            'field_list' => ['user_name', 'id'],
            'populate_list' => ['assigned_user_name', 'assigned_user_id'],
            'conditions' => [['name' => 'user_name', 'op' => 'like_custom', 'end' => '%', 'value' => '']],
            'limit' => '30', 'no_match_text' => $app_strings['ERR_SQS_NO_MATCH']];

$qsUser['populate_list'] = ['mass_assigned_user_name', 'mass_assigned_user_id'];
        $img = SugarThemeRegistry::current()->getImageURL('id-ff-select.png');
        $html = <<<EOQ
		<td width="15%" scope="row">$displayname</td>
		<td ><input class="sqsEnabled" autocomplete="off" id="mass_assigned_user_name" name='assigned_user_name' type="text" value=""><input id='mass_assigned_user_id' name='assigned_user_id' type="hidden" value="" />
		<span class="id-ff multiple"><button id="mass_assigned_user_name_btn" title="{$app_strings['LBL_SELECT_BUTTON_TITLE']}" type="button" class="button" value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name=btn1
				onclick='open_popup("Users", 600, 400, "", true, false, $encoded_popup_request_data);' /><img src="$img"></button></span>
		</td>
EOQ;
        $html .= '<script type="text/javascript" language="javascript">if(typeof sqs_objects == \'undefined\'){var sqs_objects = new Array;}sqs_objects[\'MassUpdate_assigned_user_name\'] = ' .
            $json->encode($qsUser) . '; registerSingleSmartInputListener(document.getElementById(\'mass_assigned_user_name\'));
				addToValidateBinaryDependency(\'MassUpdate\', \'assigned_user_name\', \'alpha\', false, \'' . $app_strings['ERR_SQS_NO_MATCH_FIELD'] . $app_strings['LBL_ASSIGNED_TO'] . '\',\'assigned_user_id\');
				</script>';

return $html;
    }

/**
     * Add Status selection popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     * @param options array of options for status
     */
    public function addStatus($displayname, $varname, $options)
    {
        global $app_strings, $app_list_strings;

// cn: added "mass_" to the id tag to differentiate from the status id in StoreQuery
        $html = '<td scope="row" width="15%">' . $displayname . '</td><td>';
        if (is_array($options)) {
            if (!isset($options['']) && !isset($options['0'])) {
                $emptyval = false;
                $new_options = [];
                $new_options[''] = '';
                foreach ($options as $key => $value) {
                    $new_options[$key] = $value;
                }
                $options = $new_options;
            } else {
                $emptyval = true;
            }
            $options = get_select_options_with_id_separate_key($options, $options, '', $emptyval);
            $html .= '<select id="mass_' . $varname . '" name="' . $varname . '">' . $options . '</select>';
        } else {
            $html .= $options;
        }
        $html .= '</td>';
        return $html;
    }

/**
     * Add Status selection popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     * @param options array of options for status
     */
    public function addBool($displayname, $varname)
    {
        global $app_strings, $app_list_strings;
        return $this->addStatus($displayname, $varname, $app_list_strings['checkbox_dom']);
    }

/**
     * display selection dropdown
     * @param string $displayname
     * @param string $varname
     * @param array $options
     * @param bool $showNullOption , option to show empty option
     * @return string
     */
    public function addStatusMulti($displayname, $varname, $options, $showNullOption = true)
    {
        if (!isset($options['']) && !isset($options['0'])) {
            $new_options = [];
            $new_options[''] = '';
            foreach ($options as $key => $value) {
                $new_options[$key] = $value;
            }
            $options = $new_options;
        }
        $options = get_select_options_with_id_separate_key($options, $options, '', $showNullOption);

// cn: added "mass_" to the id tag to differentiate from the status id in StoreQuery
        $html = '<td scope="row" width="15%">' . $displayname . '</td>
			 <td><select id="mass_' . $varname . '" name="' . $varname . '[]" size="5" MULTIPLE>' . $options . '</select></td>';
        return $html;
    }

/**
     * Add Date selection popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     */
    public function addDate($displayname, $varname)
    {
        global $timedate;
        //letrium ltd
        $displayname = addslashes($displayname);
        $userformat = '(' . $timedate->get_user_date_format() . ')';
        $cal_dateformat = $timedate->get_cal_date_format();
        global $app_strings, $app_list_strings, $theme;
        $calDateformatJs = Escape::js($cal_dateformat);
        $javascriptend = <<<EOQ
		 <script type="text/javascript">
		Calendar.setup ({
			inputField : "{$varname}jscal_field", daFormat : "$calDateformatJs", ifFormat : "$calDateformatJs", showsTime : false, button : "{$varname}jscal_trigger", singleClick : true, step : 1, weekNumbers:false
		});
		</script>
EOQ;
        $jscalendarImage = SugarThemeRegistry::current()->getImageURL('jscalendar.gif');
        $calDateformatJsHtmlAttr = Escape::html($calDateformatJs);
        $userFormatHtml = Escape::html($userformat);
        $html = <<<EOQ
	<td scope="row" width="20%">$displayname</td>
	<td class='dataField' width="30%"><input onblur="parseDate(this, '$calDateformatJsHtmlAttr')" type="text" name='$varname' size="12" id='{$varname}jscal_field' maxlength='10' value="">
    <img src="$jscalendarImage" id="{$varname}jscal_trigger" align="absmiddle" title="{$app_strings['LBL_MASSUPDATE_DATE']}" alt='{$app_strings['LBL_MASSUPDATE_DATE']}'>&nbsp;<span class="dateFormat">$userFormatHtml</span>
	$javascriptend</td>
	<script> addToValidate('MassUpdate','$varname','date',false,'$displayname');</script>
EOQ;
        return $html;
    }

public function addRadioenumItem($name, $value, $output)
    {
        $_output = '';
        $_output .= '<label>';
        $_output .= '<input type="radio" name="'
            . $name . '" value="'
            . $value . '"';

$_output .= ' />' . ($output == '' ? $GLOBALS['app_strings']['LBL_LINK_NONE'] : $output);
        $_output .= '</label><br />';
        return $_output;
    }

public function addRadioenum($displayname, $varname, $options)
    {
        $_html_result = [];
        foreach ($options as $_key => $_val) {
            $_html_result[] = $this->addRadioenumItem($varname, $_key, $_val);
        }

$html = '<td scope="row" width="15%">' . $displayname . '</td>
			 <td>' . implode("\n", $_html_result) . '</td>';
        return $html;
    }

/**
     * Add Datetime selection popup window HTML code
     * @param displayname Name to display in the popup window
     * @param varname name of the variable
     */
    public function addDatetime($displayname, $varname)
    {
        global $timedate;
        $userformat = $timedate->get_user_time_format();
        $cal_dateformat = $timedate->get_cal_date_format();
        global $app_strings, $app_list_strings, $theme;
        $jscalendarImage = SugarThemeRegistry::current()->getImageURL('jscalendar.gif');

$calDateformatJs = Escape::js($cal_dateformat);
        $calDateformatJsHtmlAttr = Escape::html($calDateformatJs);
        $userFormatJs = Escape::js($userformat);

$javascriptend = <<<EOQ
		 <script type="text/javascript">
		Calendar.setup ({
			inputField : "{$varname}_date",
			daFormat : "$calDateformatJs",
			ifFormat : "$calDateformatJs",
			showsTime : false,
			button : "{$varname}_trigger",
			singleClick : true,
			step : 1,
			weekNumbers:false
		});
		</script>
EOQ;
        $dtscript = getVersionedScript('include/SugarFields/Fields/Datetimecombo/Datetimecombo.js');
        $html = <<<EOQ
		<td scope="row" width="20%">$displayname</td>
		<td class='dataField' width="30%"><input onblur="parseDate(this, '$calDateformatJsHtmlAttr')" type="text" name='$varname' size="12" id='{$varname}_date' maxlength='10' value="">
		<img border="0" src="$jscalendarImage" alt='{$app_strings['LBL_MASSUPDATE_DATE']}' id="{$varname}_trigger" title="{$app_strings['LBL_MASSUPDATE_DATE']}"  align="absmiddle">&nbsp;$javascriptend

<span id="{$varname}_time_section"></span>
		</td>
		<input type="hidden" id="{$varname}" name="{$varname}">
		$dtscript
		<script type="text/javascript">
		var combo_{$varname} = new Datetimecombo(" ", "$varname", "$userFormatJs", '','','',1);
		//Render the remaining widget fields
		text = combo_{$varname}.html('');
		document.getElementById('{$varname}_time_section').innerHTML = text;

//Call eval on the update function to handle updates to calendar picker object
		eval(combo_{$varname}.jsscript(''));

function update_{$varname}_available() {
		      YAHOO.util.Event.onAvailable("{$varname}_date", this.handleOnAvailable, this);
		}

update_{$varname}_available.prototype.handleOnAvailable = function(me) {
			Calendar.setup ({
			onClose : update_{$varname},
			inputField : "{$varname}_date",
			daFormat : "$calDateformatJs",
			ifFormat : "$calDateformatJs",
			button : "{$varname}_trigger",
			singleClick : true,
			step : 1,
			weekNumbers:false
			});

//Call update for first time to round hours and minute values
			combo_{$varname}.update(false);
		}

var obj_{$varname} = new update_{$varname}_available();
		</script>

EOQ;
        return $html;
    }

public function date_to_dateTime($field, $value)
    {
        global $timedate;
        //Check if none was set
        if (isset($this->sugarbean->field_defs[$field]['group'])) {
            $group = $this->sugarbean->field_defs[$field]['group'];
            if (isset($this->sugarbean->field_defs[$group . '_flag']) && isset($_POST[$group . '_flag'])
                && $_POST[$group . '_flag'] == 1) {
                return '';
            }
        }

$oldDateTime = $this->sugarbean->$field;
        $oldTime = explode(' ', (string)$oldDateTime);
        if (isset($oldTime[1])) {
            $oldTime = $oldTime[1];
        } else {
            $oldTime = $timedate->now();
        }
        $oldTime = explode(' ', $oldTime);
        if (isset($oldTime[1])) {
            $oldTime = $oldTime[1];
        } else {
            $oldTime = $oldTime[0];
        }
        $value = explode(' ', $value);
        $value = $value[0];
        return $value . ' ' . $oldTime;
    }

public function checkClearField($field, $value)
    {
        if ($value == 1 && strpos($field, '_flag')) {
            $fName = substr($field, -5);
            if (isset($this->sugarbean->field_defs[$field]['group'])) {
                $group = $this->sugarbean->field_defs[$field]['group'];
                if (isset($this->sugarbean->field_defs[$group])) {
                    $_POST[$group] = '';
                }
            }
        }
    }

public function generateSearchWhere($module, $query)
    {
        //this function is similar with function prepareSearchForm() in view.list.php
        $seed = BeanFactory::newBean($module);
        $this->use_old_search = true;
        if (SugarAutoLoader::existing('modules/' . $module . '/SearchForm.html')) {
            if (SugarAutoLoader::existing('modules/' . $module . '/metadata/SearchFields.php')) {
                require_once 'include/SearchForm/SearchForm.php';
                $searchForm = new SearchForm($module, $seed);
            } else {
                $this->where_clauses = '';
                return;
            }
        } else {
            $this->use_old_search = false;

$searchFields = $this->getSearchFields($module);
            $searchdefs = $this->getSearchDefs($module);

if (empty($searchdefs) || empty($searchFields)) {
                $this->where_clauses = ''; //for some modules, such as iframe, it has massupdate, but it doesn't have search function, the where sql should be empty.
                return;
            }

$searchForm = $this->getSearchForm($seed, $module);
            $searchForm->setup($searchdefs, $searchFields, 'SearchFormGeneric.tpl');
        }
        /* bug 31271: using false to not add all bean fields since some beans - like SavedReports
           can have fields named 'module' etc. which may break the query */
        $searchForm->populateFromArray($query, null, true);
        $this->searchFields = $searchForm->searchFields;
        $where_clauses = $searchForm->generateSearchWhere(true, $module);
        if (safeCount($where_clauses) > 0) {
            $this->where_clauses = '(' . implode(' ) AND ( ', $where_clauses) . ')';
            $GLOBALS['log']->info("MassUpdate Where Clause: {$this->where_clauses}");
        } else {
            $this->where_clauses = '';
        }
    }

protected function getSearchDefs($module)
    {
        $searchdefs_file = SugarAutoLoader::loadWithMetafiles($module, 'searchdefs');
        if ($searchdefs_file) {
            require $searchdefs_file;
        }

return $searchdefs ?? [];
    }

protected function getSearchFields($module)
    {
        return SugarAutoLoader::loadSearchFields($module);
    }

/**
     * This is kinda a hack how it is implimented, but will tell us whether or not a focus has
     * fields for Mass Update
     *
     * @return bool
     */
    public function doMassUpdateFieldsExistForFocus()
    {
        static $banned = ['date_modified' => 1, 'date_entered' => 1, 'created_by' => 1, 'modified_user_id' => 1, 'deleted' => 1, 'modified_by_name' => 1,];
        foreach ($this->sugarbean->field_defs as $field) {
            if (!$this->sugarbean->ACLFieldAccess($field['name'], 'edit')) {
                continue;
            }
            if (!isset($banned[$field['name']]) && (!isset($field['massupdate']) || !empty($field['massupdate']))) {
                if (isset($field['type']) && $field['type'] == 'relate' && isset($field['id_name']) && $field['id_name'] == 'assigned_user_id') {
                    $field['type'] = 'assigned_user_name';
                }
                if (isset($field['custom_type'])) {
                    $field['type'] = $field['custom_type'];
                }
                if (isset($field['type'])) {
                    switch ($field['type']) {
                        case 'relate':
                        case 'parent':
                        case 'int':
                        case 'contact_id':
                        case 'assigned_user_name':
                        case 'account_id':
                        case 'account_name':
                        case 'bool':
                        case 'enum':
                        case 'multienum':
                        case 'radioenum':
                        case 'datetimecombo':
                        case 'datetime':
                        case 'date':
                        case 'team_list':
                            return true;
                            break;
                    }
                }
            }
        }

return false;
    }

/**
     * @param $bean_name - Type of 'bean' referenced by $uids
     * @param $prospect_list_id - Prospect List Id
     * @param $uids - Array of records of type '$bean_name' to be added
     */
    public function add_prospects_to_prospect_list($bean_name, $prospect_list_id, $uids)
    {
        $focus = BeanFactory::newBean($bean_name);

$relationship = '';
        foreach ($focus->get_linked_fields() as $field => $def) {
            if ($focus->load_relationship($field)) {
                if ($focus->$field->getRelatedModuleName() == 'ProspectLists') {
                    $relationship = $field;
                    break;
                }
            }
        }

if ($relationship == '') {
            return false;
        }
        foreach ($uids as $id) {
            $focus = BeanFactory::retrieveBean($bean_name, $id);
            $focus->load_relationship($relationship);
            $focus->$relationship->add($prospect_list_id);
        }

return true;
    }

/**
     * @param $bean_name - Type of 'bean' referenced by $uids
     * @param $prospect_list_id - Prospect List Id
     * @param $uids - Array of records of type '$bean_name' to be removed from prospect_list
     */
    public function remove_prospects_from_prospect_list($bean_name, $prospect_list_id, $uids)
    {
        $focus = BeanFactory::newBean($bean_name);

if ($relationship == '') {
            return false;
        }

foreach ($uids as $id) {
            $focus = BeanFactory::retrieveBean($bean_name, $id);
            $focus->load_relationship($relationship);
            $focus->$relationship->delete($id, $prospect_list_id);
        }

return true;
    }

/**
     * Have to be overridden in children
     * @param string $displayname field label
     * @param string $field field name
     * @param bool $even even or odd
     * @return string html field data
     */
    protected function addDefault($displayname, $field, &$even)
    {
        return '';
    }

/**
     * Get search form - module specific, custom or default
     * @param SugarBean $bean
     * @param string $module
     * @return SearchForm
     */
    protected function getSearchForm($bean, $module)
    {
        if (SugarAutoLoader::requireWithCustom("modules/$module/{$module}SearchForm.php")) {
            $searchFormClass = SugarAutoLoader::customClass("{$module}SearchForm");
        } else {
            SugarAutoLoader::requireWithCustom('include/SearchForm/SearchForm2.php');
            $searchFormClass = SugarAutoLoader::customClass('SearchForm');
        }
        return new $searchFormClass($bean, $module);
    }

/**
     * Boolean converter that returns whether the value is boolean true. This is
     * static because it is consumed from internal static methods.
     *
     * @param mixed $val Value to check boolean on
     * @return boolean
     */
    protected static function isTrue($val)
    {
        return $val === true || $val === 1 || $val === 'true' || $val === '1';
    }

/**
     * Boolean converter that returns whether the value is boolean false. This is
     * static because it is consumed from internal static methods.
     *
     * @param mixed $val Value to check boolean on
     * @return boolean
     */
    protected static function isFalse($val)
    {
        return $val === false || $val === 0 || $val === 'false' || $val === '0';
    }
}