Elep

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

/*********************************************************************************
 * Description:
 ********************************************************************************/

use Sugarcrm\Sugarcrm\Security\InputValidation\InputValidation;

$base_module = InputValidation::getService()->getValidInputPost('base_module', 'Assert\Mvc\ModuleName');
$record = InputValidation::getService()->getValidInputPost('record', 'Assert\Guid');
$type = InputValidation::getService()->getValidInputPost('type');

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

if (!empty($record)) {
    $focus->retrieve($record);
    $is_new = false;
} else {
    $is_new = true;
}

//check if we need to remove the old stuff
if (!$is_new && (
    (!empty($base_module) && $base_module != $focus->base_module) ||
        (!empty($type) && $type != $focus->type)
)) {
    $focus->delete_workflow_on_cascade = false;
    $focus->mark_deleted($record);
    $focus->deleted = 0;
}

foreach ($focus->column_fields as $field) {
    if (isset($_POST[$field])) {
        $focus->$field = $_POST[$field];
    }
}

foreach ($focus->additional_column_fields as $field) {
    if (isset($_POST[$field])) {
        $value = $_POST[$field];
        $focus->$field = $value;
    }
}

if ($focus->status == 'Active') {
    $focus->status = 1;
} else {
    $focus->status = 0;
}

//If this is new, set the initial process order
if ($is_new == true) {
    $controller = new Controller();
    $controller->init($focus, 'New');
    $controller->change_component_order('', '', $_REQUEST['base_module']);
}

$focus->save();

if (!empty($_POST['is_duplicate']) && $_POST['is_duplicate'] == 'true') {
    $old_workflow = BeanFactory::getBean('WorkFlow', $_POST['old_record_id']);
    $alerts_list =& $old_workflow->get_linked_beans('alerts', 'WorkFlowAlertShell');
    $actions_list =& $old_workflow->get_linked_beans('actions', 'WorkFlowActionShell');
    $triggers_list = &$old_workflow->get_linked_beans('triggers', 'WorkFlowTriggerShell');
    $filters_list = &$old_workflow->get_linked_beans('trigger_filters', 'WorkFlowTriggerShell');

foreach ($alerts_list as $alert) {
        $alert->copy($focus->id);
    }

$connection = $focus->db->getConnection();
    foreach ($actions_list as $action) {
        $newActionId = $action->copy($focus->id);

// BUG 44500 Duplicating workflow does not duplicate invitees for created activites
        $query = "SELECT id FROM workflow WHERE parent_id = ?";
        $rows = $connection->fetchAllAssociative($query, [$action->id]);

foreach ($rows as $row) {
            $copyWorkflow = BeanFactory::getBean('WorkFlow', $row['id']);
            $copyWorkflow->id = '';
            $copyWorkflow->parent_id = $newActionId;
            $copyWorkflowId = $copyWorkflow->save();

$query = "SELECT id FROM workflow_alertshells WHERE parent_id = ?";
            $alertshells = $connection->fetchAllAssociative($query, [$row['id']]);

foreach ($alertshells as $alertshell) {
                $copyAlertshell = BeanFactory::getBean('WorkFlowAlertShells', $alertshell['id']);
                $copyAlertshell->id = '';
                $copyAlertshell->parent_id = $copyWorkflowId;
                $copyAlertshellId = $copyAlertshell->save();

$query = "SELECT id FROM workflow_alerts WHERE parent_id = ? ";
                $alerts = $connection->fetchAllAssociative($query, [$alertshell['id']]);
                foreach ($alerts as $alert) {
                    $copyAlert = BeanFactory::getBean('WorkFlowAlerts', $alert['id']);
                    $copyAlert->id = '';
                    $copyAlert->parent_id = $copyAlertshellId;
                    $copyAlertId = $copyAlert->save();
                }
            }
        }
    }

foreach ($triggers_list as $trigger) {
        $trigger->copy($focus->id);
    }

foreach ($filters_list as $filter) {
        $filter->copy($focus->id);
    }
}

//Add or Build Logic File if necessary
$focus->check_logic_hook_file();

//write the workflow into the workflow files
$focus->write_workflow();

$return_module = InputValidation::getService()->getValidInputPost('return_module', 'Assert\Mvc\ModuleName', 'WorkFlow');

// This looks into the POST array for a value... while an edit of a record will have a value here, a new record won't.
// As such, if $return_id is empty but $focus->id is not, we should lean on $focus->id as our $return_id.
$return_id = InputValidation::getService()->getValidInputPost('return_id', 'Assert\Guid', $focus->id);

// If return_id is empty but we have a focus->id then we just created this record, so use the focus->id value instead
if (empty($return_id) && !empty($focus->id)) {
    $return_id = $focus->id;
}

// For security, urlencode the return_id and return_module
$return_id = urlencode($return_id);
$return_module = urlencode($return_module);

$GLOBALS['log']->debug('Saved record with id of ' . $return_id);
//exit;

//Redirect to DetailView, not listview for the workflow object.
header("Location: index.php?action=DetailView&module=$return_module&record=$return_id");