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:
 ********************************************************************************/

require_once 'include/workflow/workflow_utils.php';

global $process_dictionary;
require_once 'modules/WorkFlowTriggerShells/MetaArray.php';

// WorkFlowTriggerShell is used to store the shell trigger information.
class WorkFlowTriggerShell extends SugarBean
{
    // Stored fields
    public $id;
    public $deleted;
    public $date_entered;
    public $date_modified;
    public $modified_user_id;
    public $created_by;
    public $created_by_name;
    public $modified_by_name;
    public $name;

//construction
    public $eval;
    public $field;
    public $type;
    public $show_past;
    public $parent_id;
    public $parameters;

//Either this is the first trigger or an additional one
    public $frame_type;

//related trigger filters
    public $rel_module;
    public $rel_module_type = 'any';

//used for gathering the trigger components
    public $trigger_id;
    public $trigger_type;

public $table_name = 'workflow_triggershells';
    public $module_dir = 'WorkFlowTriggerShells';
    public $object_name = 'WorkFlowTriggerShell';
    public $rel_trigger_table = 'workflow_triggers';

public $new_schema = true;

public $column_fields = ['id'
        , 'date_entered'
        , 'date_modified'
        , 'modified_user_id'
        , 'created_by'
        , 'eval'
        , 'field'
        , 'type'
        , 'show_past'
        , 'parent_id'
        , 'parameters'
        , 'frame_type'
        , 'rel_module'
        , 'rel_module_type',
    ];

// This is used to retrieve related fields from form posts.
    public $additional_column_fields = [];

// This is the list of fields that are in the lists.
    public $list_fields = ['name', 'eval', 'type', 'field'];

// This is the list of fields that are required
    public $required_fields = [];

public function __construct()
    {
        parent::__construct();

$this->disable_row_level_security = true;
    }

public function get_summary_text()
    {
        return "$this->name";
    }

public function save_relationship_changes($is_update, $exclude = [])
    {
    }

public function mark_relationships_deleted($id)
    {
    }

public function fill_in_additional_list_fields()
    {
    }

public function fill_in_additional_detail_fields()
    {
    }

public function get_list_view_data($filter_fields = [])
    {

global $app_strings, $mod_strings;
        global $app_list_strings;

global $current_user;
        global $current_module_strings;

$temp_array = [];

//BEGIN WFLOW PLUGINS
        global $process_dictionary;
        get_plugin('workflow', 'trigger_createstep1', $this);
        //END WFLOW PLUGINS
        //Grab event
        include_once 'include/ListView/ProcessView.php';
        $ProcessView = new ProcessView($this->get_workflow_type(), $this);
        $ProcessView->local_strings = $current_module_strings;
        $prev_display_text = $ProcessView->get_prev_text('TriggersCreateStep1', $this->type);

// Added a text add to the confirmation of deletes when deleting a primary trigger
        $deleteConfirm = $current_module_strings['NTC_REMOVE_TRIGGER'];

if ($this->frame_type == 'Primary') {
            $statement1 = $current_module_strings['LBL_LIST_STATEMEMT'];
            // Add a notice that deleting the primary deletes all triggers
            $deleteConfirm .= ' ' . $current_module_strings['NTC_REMOVE_TRIGGER_PRIMARY'];
        } else {
            $statement1 = $current_module_strings['LBL_FILTER_LIST_STATEMEMT'];
        }

$temp_array['REMOVE_TRIGGER_CONFIRM'] = $deleteConfirm;
 $temp_array['FRAME_TYPE'] = $this->frame_type;
 $temp_array['STATEMENT'] = '' . $prev_display_text . '';
 $temp_array['STATEMENT1'] = '' . $statement1 . '';
 $trigger_display_text = $ProcessView->get_trigger_display_text('TriggersCreateStep1', $this);
 if (strpos($trigger_display_text, 'class="error"') !== false && empty($this->hasError)) {
 $this->hasError = true;
 echo '' . translate('LBL_TRIGGER_ERRORS') . '';
 }
 $temp_array['STATEMENT2'] = '' . $trigger_display_text . '';
 unset($ProcessView);
 //preset height and width
 $temp_array['POPUP_HEIGHT'] = '500';
 $temp_array['POPUP_WIDTH'] = '400';

$action_processed = false;
        if ($this->type == 'compare_change' || $this->type == 'trigger_record_change') {
            $temp_array['ACTION'] = 'CreateStep1';
            $action_processed = true;
        }
        if ($this->type == 'compare_specific') {
            $temp_array['ACTION'] = 'CreateStepSpecific';
            $action_processed = true;
        }
        if ($this->type == 'compare_count') {
            $temp_array['ACTION'] = 'CreateStepCount';
            $action_processed = true;
        }

if ($this->type == 'compare_any_time') {
            $temp_array['ACTION'] = 'CreateStep1';
            $action_processed = true;
        }

if ($this->type == 'filter_field' || $this->type == 'filter_rel_field') {
            $temp_array['ACTION'] = 'CreateStepFilter';
            $action_processed = true;
        }
        //BEGIN WFLOW PLUGINS
        if ($action_processed == false) {
            $list_data_array = get_plugin('workflow', 'trigger_listview', $this);
            if (!empty($list_data_array['action_processed']) && $list_data_array['action_processed'] == true) {
                //a custom plugin was found with data
                foreach ($list_data_array['list_data'] as $list_key => $list_value) {
                    $temp_array[$list_key] = $list_value;

//loop through and fill the temp_array
                }
            }
        }
        //END WFLOW PLUGINS

$temp_array['PARENT_ID'] = $this->parent_id;
        $temp_array['ID'] = $this->id;
        return $temp_array;
    }

public function clear_deleted($id)
    {

//end function clear_deleted
    }

public function build_generic_where_clause($the_query_string)
    {
    }

////////////////////Glue the trigger components together
    public function glue_triggers($past_object, $future_object)
    {

$glue_object = new WorkFlowGlue();

$workflow_object = $this->get_workflow_type();
        $the_type = $workflow_object->type;

if ($the_type == 'Normal') {
            if ($this->type == 'compare_specific') {
                $this->eval = $glue_object->glue_normal_type($this, $past_object, $future_object);
                //end if compare_specific
            }
            if ($this->type == 'compare_change') {
                $this->eval = $glue_object->glue_normal_compare_change($this);
                //end if compare_change
            }

if ($this->type == 'compare_count') {
                $this->eval = '';

//end if compare_count
            }
        }
        if ($the_type == 'Time') {
            if ($this->type == 'compare_any_time') {
                $this->eval = $glue_object->glue_normal_compare_any_time($this);
                //end if compare_change
            } else {
                $this->eval = $glue_object->glue_time_type($this, $future_object);
            }
        }

return $workflow_object;

//end function glue_triggers
    }

public function glue_trigger_count($base_object, $filter1_object, $filter2_object)
    {

$glue_object = new WorkFlowGlue();
        $workflow_object = $this->get_workflow_type();

return $workflow_object;

//end function glue_trigger_count
    }

public function glue_trigger_filters(&$filter_object)
    {

if ($this->type == 'filter_field') {
            $glue_object = new WorkFlowGlue();
            $glue_object->shell_object = &$this;
            $this->eval = $glue_object->glue_normal_expression($filter_object);
        }

$workflow_object = $this->get_workflow_type();

return $workflow_object;

//end glue_trigger_filters
    }

public function write_workflow($workflow_object)
    {

write_workflow($workflow_object);
    }

public function get_workflow_type()
    {

$workflow_object = BeanFactory::getBean('WorkFlow', $this->parent_id);
        return $workflow_object;

//end function get_workflow_type
    }

public function copy($parent_id)
    {

$orig_id = $this->id;
        $new_trigger_shell = $this;
        $new_trigger_shell->id = '';
        $new_trigger_shell->parent_id = $parent_id;

if (isset($new_trigger_shell->date_entered)) {
            $new_trigger_shell->date_entered = null;
        }
        if (isset($new_trigger_shell->created_by)) {
            $new_trigger_shell->created_by = null;
        }

$new_trigger_shell->save();
        $new_id = $new_trigger_shell->id;
        $this->retrieve($orig_id);
        $expression_list = $this->get_linked_beans('future_triggers', 'Expression');
        foreach ($expression_list as $expression) {
            $new_expression =& $expression;
            $new_expression->id = '';
            $new_expression->parent_id = $new_id;
            if (isset($new_expression->date_entered)) {
                $new_expression->date_entered = null;
            }
            if (isset($new_expression->created_by)) {
                $new_expression->created_by = null;
            }
            $new_expression->save();
        }
        $expression_list = $this->get_linked_beans('past_triggers', 'Expression');
        foreach ($expression_list as $expression) {
            $new_expression =& $expression;
            $new_expression->id = '';
            $new_expression->parent_id = $new_id;
            if (isset($new_expression->date_entered)) {
                $new_expression->date_entered = null;
            }
            if (isset($new_expression->created_by)) {
                $new_expression->created_by = null;
            }
            $new_expression->save();
        }
        $expression_list = $this->get_linked_beans('expressions', 'Expression');
        foreach ($expression_list as $expression) {
            $new_expression =& $expression;
            $new_expression->id = '';
            $new_expression->parent_id = $new_id;
            if (isset($new_expression->date_entered)) {
                $new_expression->date_entered = null;
            }
            if (isset($new_expression->created_by)) {
                $new_expression->created_by = null;
            }
            $new_expression->save();
        }
    }

public function get_time_int($triggershell_id)
    {

$time_int_array = [];
        $row = $this->db
            ->getConnection()
            ->executeQuery(
                'SELECT ext1, exp_type, operator, lhs_field
                FROM expressions
                WHERE expressions.parent_id = ?
                AND expressions.deleted=0',
                [$triggershell_id]
            )->fetchAssociative();

if ($row !== false) {
            //datetime time_int;
            if ($row['exp_type'] == 'datetime' || $row['exp_type'] == 'date' || $row['exp_type'] == 'datetimecombo') {
                $time_int_array['time_int_type'] = 'datetime';
                $time_int_array['target_field'] = $row['lhs_field'];
                if ($row['operator'] == 'More Than') {
                    $time_int_array['time_int'] = $row['ext1'];
                } else {
                    $time_int_array['time_int'] = $row['ext1'] * -1;
                }
            } else {
                $time_int_array['time_int_type'] = 'normal';
                $time_int_array['time_int'] = $row['ext1'];
                $time_int_array['target_field'] = 'none';
                //$time_int_array['target_field'] =$row['lhs_field'];
            }

//normal time_int
            return $time_int_array;
        } else {
            return null;
        }
        //end function get_time_int
    }

/**
     * Deletes the Trigger.
     * If it's the primary Trigger, deletes all the Triggers
     * and Schedules for the parent WorkFlow
     *
     * @param $id - $id of the Trigger to be deleted. If empty use $this->id
     */
    public function mark_deleted($id = null)
    {
        if (!empty($id)) {
            $this->id = $id;
        }

//mark delete trigger components
        mark_delete_components($this->get_linked_beans('future_triggers', 'Expression'));
        mark_delete_components($this->get_linked_beans('past_triggers', 'Expression'));
        mark_delete_components($this->get_linked_beans('expressions', 'Expression'));
        parent::mark_deleted($this->id);
        $workflow_object = $this->get_workflow_type();

if ($this->frame_type == 'Primary') {
            // Deleting a primary means we delete all triggers, and related schedules
            $workflow_object->deleteTriggers();
            $workflow_object->deleteTriggerFilters();
            $workflow_object->deleteSchedules();
        }

//reload $workflow_object to make the trigger changes take effect.
        $workflow_object = $this->get_workflow_type();
        $workflow_object->write_workflow();
    }

///End Class WorkFlowTrigger
}