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.
 */
require_once('include/workflow/workflow_utils.php');
require_once('include/workflow/time_utils.php');
require_once('include/workflow/alert_utils.php');

/**
 *  WorkFlow is used to store the workflow objects.
 */
class WorkFlow extends SugarBean
{
	// Stored fields
	var $id;
	var $deleted;
	var $date_entered;
	var $date_modified;
	var $modified_user_id;
	var $created_by;
	var $created_by_name;
	var $modified_by_name;

var $name;
	var $description;
	var $type;
	var $status;
	var $base_module;
	var $record_type;
	var $fire_order;

var $parent_id;

var $list_order_y = 0;

//used for the writing of triggers
	var $secondary_count = 0;
    // Used for schedule update for time elapsed workflows
    private $secondary_triggers;

var $table_name = "workflow";
	var $module_dir = "WorkFlow";
	var $object_name = "WorkFlow";

var $rel_triggershells_table = 	"workflow_triggershells";
	var $rel_triggers_table = 		"workflow_triggers";
	var $rel_alertshells_table = 		"workflow_alertshells";
	var $rel_alerts_table = 		"workflow_alerts";
	var $rel_actionshells_table = 		"workflow_actionshells";
	var $rel_actions_table = 		"workflow_actions";

//Glue variables
	var $glue_object;

var $new_schema = true;

var $column_fields = Array("id"
		,"name"
		,"date_entered"
		,"date_modified"
		,"modified_user_id"
		,"created_by"
		,"description"
		,"type"
		,"status"
		,"base_module"
		,"list_order_y"
		,"record_type"
		,"fire_order"
		,"parent_id"
		);

//Controller Array for list_order element
	var $controller_def = Array(
		 "list_x" => "N"
		,"list_y" => "Y"
		,"parent_var" => "base_module"
		,"start_var" => "list_order_y"
		,"start_axis" => "y"
		);

// This is used to retrieve related fields from form posts.
	var $additional_column_fields = Array();

// This is the list of fields that are in the lists.
	var $list_fields = array('id', 'name', 'type', 'status', 'base_module', 'list_order_y');

var $relationship_fields = Array();

// This is the list of fields that are required
	var $required_fields =  array("name"=>1, 'base_module'=>1, 'type'=>1);

// This is a member variable to flag whether or not we really call mark_deleted
    var $delete_workflow_on_cascade = true;

// Flag whether
    var $check_controller = true;

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

$this->disable_row_level_security =false;
	}

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

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

function mark_relationships_deleted($id)
	{
	}

function fill_in_additional_list_fields()
	{

}

function fill_in_additional_detail_fields()
	{

}

function get_custom_query(){

$query = "SELECT cq.name from $this->rel_custom_queries cq, $this->table_name p1 where cq.id = p1.query_id and p1.id = '$this->id' and p1.deleted=0 and cq.deleted=0";
		$result = $this->db->query($query,true," Error filling in additional custom query detail fields: ");

// Get the id and the name.
		$row = $this->db->fetchByAssoc($result);

if($row != null)
		{
			$this->query_name = $row['name'];
		}
		else
		{
			$this->query_name = '';
		}
	}

/** Returns a list of the associated product_templates
     * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc..
     * All Rights Reserved.
     * Contributor(s): ______________________________________..
    */

public function create_new_list_query($order_by, $where, $filter = array(), $params = array(), $show_deleted = 0, $join_type = '', $return_array = false, $parentbean = null, $singleSelect = false, $ifListForExport = false)
    {
    	$ret = array();
    	$custom_join = $this->getCustomJoin();
        $ret['select'] = "SELECT workflow.id, workflow.name, workflow.base_module, workflow.type, workflow.status, workflow.list_order_y ";
        $ret['select'] .= $custom_join['select'];

$ret['from'] = " FROM ".$this->table_name." ";
        $ret['from'] .= $custom_join['join'];
        $this->addVisibilityFrom($ret['from'], array('where_condition' => true));
        $this->addVisibilityWhere($where, array('where_condition' => true));

$where_auto = "deleted=0 AND ( parent_id IS NULL OR parent_id = '' )";

if($where != "")
            $ret['where'] = "where ($where) AND ".$where_auto;
        else
            $ret['where'] = "where ".$where_auto;

if(!empty($order_by))
             $ret['order_by'] = " ORDER BY $order_by";
        else
             $ret['order_by'] = "";

if($return_array)
        {
            return $ret;
        }

return  $ret['select'] . $ret['from'] . $ret['where']. $ret['order_by'];
    }

public function get_list_view_data($filter_fields = [])
    {
		global $app_strings, $mod_strings;
		global $app_list_strings;

global $current_user;

$temp_array = parent::get_list_view_data();
		$temp_array['NAME'] = (($this->name == "") ? "<em>blank</em>" : $this->name);
		$temp_array['TYPE'] = $app_list_strings['wflow_type_dom'][$this->type];
		$temp_array['BASE_MODULE'] = $app_list_strings['moduleList'][$this->base_module];
		$temp_array['LIST_ORDER'] = $this->list_order_y;
		$temp_array['HREF_DELETE'] = "index.php?action=Delete&module=WorkFlow&record=".$this->id."";

if(empty($this->status)) $this->status = "Inactive";
		if($this->status == 1 || $this->status== "checked") $this->status = "Active";

$temp_array['STATUS'] = $app_list_strings['user_status_dom'][$this->status];
		return $temp_array;
	}
	/**
		builds a generic search based on the query string using or
		do not include any $this-> because this is called on without having the class instantiated
	*/
	function build_generic_where_clause ($the_query_string) {
	$where_clauses = Array();
	$the_query_string = addslashes($the_query_string);
	array_push($where_clauses, "name like '$the_query_string%'");

$the_where = "";
	foreach($where_clauses as $clause)
	{
		if($the_where != "") $the_where .= " or ";
		$the_where .= $clause;
	}

return $the_where;
}

function get_module_array($use_object_name=false, $start_none=false){

if($use_object_name == true){
		return convert_module_to_singular(get_module_map($start_none));
	} else {
		return get_module_map();
	}

//end function get_module_array
}

function get_limited_module_array(){

return $this->filter_base_modules();

//end function get_limited_module_array
}

function filter_base_modules(){

global $app_list_strings;
	$module_array = array();

$query = "	SELECT DISTINCT base_module
					FROM workflow
					WHERE workflow.deleted = '0'";

$result = $this->db->query($query,true," Grabbing current list of modules used in workflow: ");

while($row = $this->db->fetchByAssoc($result)){

$module_array[$row['base_module']] = $row['base_module'];
			$module_array[$row['base_module']] = $app_list_strings['moduleList'][$row['base_module']];
		//end while
		}

return $module_array;

//end function filter_base_modules
}

///////////////////////////////////////////////////Aquiring WorkFLow Components Area////////////

function get_relationship_modules($column_module=""){

//convert this to something dynamic based on the new relationship structure - jgreen

$column_select_array = array(

'Contacts' => 'Contacts',
    'Accounts' => 'Accounts',
    'Opportunities' => 'Opportunities',

);

return $column_select_array;

//end function get_relationship_modules
	}

function get_column_data($orderBy="")
	{
		// First, get the list of IDs.
		$query = 	"SELECT $this->rel_dataset.id from $this->rel_dataset
					 where $this->rel_dataset.report_id='$this->id'
					 AND $this->rel_dataset.deleted=0 ".$orderBy;

return $this->build_related_list($query, BeanFactory::newBean('DataSets'));
	}

function get_column_select($drop_down_module="")
	{
    	$this->column_options = array();
    	if(!empty($drop_down_module)){
    		$column_module = $drop_down_module;
    	} else {
    		$column_module = $this->base_module;
    	}

//Get dictionary data for base bean and all connected beans
    	$temp_focus = BeanFactory::newBean($column_module);
    	$this->add_to_column_select($temp_focus, $column_module);
    	return $this->column_options;
	}

function add_to_column_select($temp_focus, $module_name){
		global $dictionary;
		global $current_language;
		global $app_strings;

$temp_module_strings = return_module_language($current_language, $temp_focus->module_dir);

$base_array = $dictionary[$temp_focus->object_name]['fields'];

foreach($base_array as $key => $value){

$label_name = $value['vname'];
		if(!empty($temp_module_strings[$label_name])){
			$label_name = $temp_module_strings[$label_name];
		} else {
			if(!empty($app_strings[$label_name])){
			$label_name = $app_strings[$label_name];
			}
		}
		if(!empty($value['table'])){
			//Custom Field
			$column_table = $value['table'];
		} else {
			//Non-Custom Field
			$column_table = $temp_focus->table_name;
		}

$index = $key;
		$value = "(".$value['name'].")".$label_name;

$this->column_options[$index] = $value;

//end foreach
	}

//end function add_to_column_select
	}

function get_module_info($module_name){

//expand this function to return other types of module information based on the name

//Get dictionary and focus data for module
		return BeanFactory::newBean($module_name);

//end function get_module_info
	}

function get_field_table($module, $field){

$seed_object = BeanFactory::newBean($module);
		$field_table = $this->determine_field_type($seed_object, $field);

return $field_table;

//end function get_module_table
	}

function determine_field_type($seed_object, $field){

global $dictionary;
		if(!empty($dictionary[$seed_object->object_name]['fields'][$field]['custom_type'])){
		//field is present in the module's custom table.  Retrieve this table and use as query
			$field_select = $seed_object->table_name."_cstm.".$field;

} else {
			//field is not custom and present in module table
			$field_select = $seed_object->table_name.".".$field;
		}

return $field_select;
	//end function determine_field_type
	}

////////LABEL DISPLAY FUNCTION

//only call this after the bean has been made and the vardef file exists
	function display_label($focus, $field){
        $current_language = null;
		global $dictionary;

if (!file_exists('modules/'. $focus->module_dir . '/' . $focus->object_name.'.php')) {
			return $field;
		}

$var_name = $dictionary[$focus->object_name]['fields'][$field]['vname'];
		$current_module_strings = return_module_language($current_language, $focus->object_name);

if(!empty($current_module_strings[$var_name])){

return $current_module_strings[$var_name];

} else {
			return $field;
		}

//end function display_label
	}

/////////////////RUN QUERY FUNCTIONS//////////

function run_query(){

//Create the glue object
		$query_glue = new QueryGlue($this);

$query_glue->build_select();

return $query_glue->glue_select(true);

//end function run_query
	}

/////////////////////Build trigger & alerts component pages

function write_workflow(){

write_workflow($this);

//re-run the parent object build also
	if($this->parent_id!=""){
		$parent_object = $this->get_parent_object();
		$parent_object->write_workflow();
	}

}

function get_trigger_contents(){
        $opt = [];
        $eval = null;
        $timeArray = null;
		$this->glue_object = new WorkFlowGlue();
		$this->glue_object->start_trigger_meta_array();
		$this->glue_object->start_alert_meta_array();
		$this->glue_object->start_action_meta_array();

//BEGIN WFLOW PLUGINS
		$this->glue_object->start_plugin_meta_array();
		//END WFLOW PLUGINS
		$trigger_count = 0;
		$trigger_time_count = 0;

$eval_dump = "";

/*Special note about this query.

This query is designed to only get workflow objects that have at least a primary
		triggershell OR it will get a workflow object that is a bridging object, denoted
		by the fact that their is a parent id.

TODO - jgreen - Need to re-arrange this function a bit and how this write workflow
		functions.

$query = "	SELECT $this->table_name.id id,
					$this->table_name.fire_order fire_order,
					$this->table_name.type type,
					$this->table_name.record_type record_type,
					$this->table_name.parent_id parent_id,
					$this->rel_triggershells_table.eval eval,
					$this->rel_triggershells_table.type trigger_type,
					$this->rel_triggershells_table.id triggershell_id,
					$this->rel_triggershells_table.parameters parameters,
					$this->rel_triggershells_table.field target_field,
					$this->rel_triggershells_table.rel_module rel_module,
					$this->rel_triggershells_table.rel_module_type rel_module_type
					 FROM $this->table_name
					 LEFT JOIN ".$this->rel_triggershells_table."
					 ON ".$this->rel_triggershells_table.".parent_id =
					 ".$this->table_name.".id
					 WHERE ".$this->table_name.".deleted = 0
					 AND ".$this->table_name.".base_module = '".$this->base_module."'
					 AND ".$this->table_name.".status = 1
					 AND (

(".$this->rel_triggershells_table.".frame_type='Primary'
					 AND ".$this->rel_triggershells_table.".deleted=0 )

OR (
					 	$this->table_name.parent_id IS NOT NULL AND
					 	$this->table_name.parent_id !=''
					 	)
					 )

" ;

$query .= " ORDER BY ".$this->table_name.".list_order_y asc
					 ";
					// echo $query;
					 //exit;
		$result = $this->db->query($query,true," Error getting trigger contents for trigger write: ");
//RRS
$alert_file_contents = "";
		// Get the id and the name.
		while($row = $this->db->fetchByAssoc($result, false)){

///BEGIN check to see if this is new, update, or all, then add proper if statement
            $record_type_needed = write_record_type($eval_dump, $row['record_type'], $row);

$trigger_processed=false;
			if($row['trigger_type']=="compare_count"){

$eval = "get_trigger_count_bool(\$focus, \$trigger_meta_array['trigger_count_".$trigger_count."'])===true \n";

//write the meta array
				$this->glue_object->build_trigger_triggers("trigger_count_".$trigger_count, $row['triggershell_id']);
				$trigger_processed=true;
			}
			if($row['trigger_type']=="trigger_record_change"){
				$eval = "true";
				$trigger_processed=true;
			}
			if($row['trigger_type']=="filter_rel_field"){
				$this->glue_object->build_trigger_triggers("trigger_".$trigger_count, $row['triggershell_id']);
				$eval_dump .= "\t \$primary_array = array();\n";
				$eval_dump .= "\t \$primary_array = check_rel_filter(\$focus, \$primary_array, '".$row['rel_module']."', \$trigger_meta_array['trigger_".$trigger_count."'], '".$row['rel_module_type']."'); \n";
				$eval = "(\$primary_array['results']==true)\n";
				$trigger_processed=true;
			}
			//bridging type
			if(!empty($row['parent_id'])){
				//check if this is a bridging object
				$trigger_id = $row['id']; //wdong, bug 25015, the $row['triggershell_id'] maybe empty here. and then $row['id'] is just what we want.
                if(!empty($row['triggershell_id'])){
                    $trigger_id = $row['triggershell_id'];
                }
				$eval = "isset(\$focus->bridge_id) && \$focus->bridge_id == '".$trigger_id."' ";
				$trigger_processed=true;

}

if(	$row['trigger_type']=="compare_specific" ||
				$row['trigger_type']=="compare_change" ||
				$row['trigger_type']=="compare_any_time" ||
				$row['trigger_type']=="filter_field"){

$eval = html_entity_decode($row['eval'], ENT_QUOTES);
				$trigger_processed=true;
			}

//BEGIN WFLOW PLUGINS

//prepare the opt array
				$opt['object'] = $this;
				$opt['row'] = $row;
				$opt['trigger_position'] = "Primary";
				$opt['trigger_count'] = $trigger_count;
				$opt['trigger_time_count'] = $trigger_time_count;
				$opt['array_position_name']= "plugin_".$trigger_count;

if($trigger_processed==false){
					$eval_array = get_plugin("workflow", "trigger_glue", $opt);
					if(!empty($eval_array['trigger_processed']) && $eval_array['trigger_processed']==true){

$eval = $eval_array['eval'];
						$trigger_processed=true;

//end if processed is true
					}
				}

//END WFLOW PLUGINS

if($trigger_processed==false){
				$eval = html_entity_decode($row['eval'], ENT_QUOTES);
				$trigger_processed=true;
			}

$eval_dump .= "\n if(";
			$eval_dump .= $eval;
			$eval_dump .= "){ \n";

$eval_dump .= " \n\n";

//Frame Secondary items
			$eval_dump .= "\t //Frame Secondary \n\n";
			$eval_dump .= $this->get_front_triggers_secondary($row['id'], $trigger_count);

if($row['type']=='Time'){
				$trigger_object = BeanFactory::newBean('WorkFlowTriggerShells');

$time_interval_array = $trigger_object->get_time_int($row['triggershell_id']);

// Set-up the $time_array for Time type triggers
                $timeArray = '';
                if ($row['trigger_type']=="compare_any_time") {
                    $timeArray .= "\t \$time_array['time_int'] = '" . $row['parameters'] . "';\n";
                    $timeArray .= "\t \$time_array['parameters'] = \$focus->" . $row['target_field'] . ";\n";
                    $timeArray .= "\t \$time_array['time_int_type'] = 'normal';\n";
                    $timeArray .= "\t \$time_array['target_field'] = 'none';\n";
                } else {
                    $timeArray .= "\t \$trigger_time_count = '" . $trigger_time_count . "';\n ";
                    $timeArray .= "\t \$time_array['time_int'] = '" . $time_interval_array['time_int'] . "';\n";
                    $timeArray .= "\t \$time_array['time_int_type'] = '" . $time_interval_array['time_int_type'] . "';\n";
                    $timeArray .= "\t \$time_array['target_field'] = '" . $time_interval_array['target_field'] . "';\n";
                }
                $eval_dump .= $timeArray;
                $eval_dump .= "\t \$workflow_id = '" . $row['id'] . "'; \n\n";

$eval_dump .= 'if(!empty($_SESSION["workflow_cron"]) && $_SESSION["workflow_cron"]=="Yes" &&
				!empty($_SESSION["workflow_id_cron"]) && ArrayFunctions::in_array_access($workflow_id, $_SESSION["workflow_id_cron"])){
				';
			//end if type is time
			}

//BEGIN WFLOW PLUGINS
					$eval_dump_array = get_plugin("workflow", "trigger_eval_dump", $opt);
					if(!empty($eval_dump_array['eval_dump']) && $eval_dump_array['eval_dump']!=""){

$eval_dump .= $eval_dump_array['eval_dump'];

//end if eval dump produces plugin output
					}

//END WFLOW PLUGINS
			//Begin Infinit loop catch, check to see if this workflow has already been triggered this save.
			//We need a unique ID composed only of \w characters, Unix Time works pretty well.
			$randID = str_replace('-', '_', create_guid());
			$eval_dump.= "\n\tglobal \$triggeredWorkflows;\n"
					   . "\tif (!isset(\$triggeredWorkflows['{$randID}'])){\n\t\t"
					   . "\$triggeredWorkflows['{$randID}'] = true;\n";

if($row['fire_order']=='alerts_actions'){
				$eval_dump .= "\t" . $this->get_alert_contents($row['id'], $trigger_count, $this->base_module);
				$eval_dump .= "\t" . $this->get_action_contents($row['id'], $trigger_count, $this->base_module, $randID);
			}

if($row['fire_order']=='actions_alerts'){
                $eval_dump .= "\t"
                    . $this->get_action_contents($row['id'], $trigger_count, $this->base_module, $randID);
				$out_data = $this->get_alert_contents_for_file($row['id'], $trigger_count, $this->base_module);
                $eval_dump .= "\t" . $out_data[0];
                $alert_file_contents .= $out_data[1];
            }

//END infinit loop catch
			$eval_dump.= "\t}\n";

// Close braces
            if ($row['type'] == 'Time') {
                $eval_dump .= "}\n\n";
            }

$eval_dump .= " \n\n";

//End Frame Secondary items
			$eval_dump .= "\t //End Frame Secondary \n\n";
			$eval_dump .= $this->get_back_triggers_secondary();

$eval_dump .= " \n\n";
			$eval_dump .= " //End if trigger is true \n";
			$eval_dump .= " } \n\n";

///END check to see if this is new, update, or all
			if($record_type_needed===true){
				$eval_dump .= "\t\t //End if new, update, or all record";
				$eval_dump .= "\n \t\t} \n\n";
			}

++$trigger_count;

// Update date_expired in case it's a new row, or any of the fields got updated
            if ($row['type'] == 'Time') {
                $eval_dump .= "// Hack for skipping the check if field has changed, just check values\n";
                $eval_dump .= "if (!empty(\$_SESSION['workflow_cron'])) {\n";
                $eval_dump .= "\t\$saveWorkflowCron = \$_SESSION['workflow_cron'];\n";
                $eval_dump .= "}\n";

$eval_dump .= "\$_SESSION['workflow_cron'] = 'Yes';\n";
                ++ $trigger_time_count;
                $eval_dump .= "\$secondary_array = array();";
                $eval_dump .= "\$checkFields = array('for' => 'activity', 'excludeType' => array(), ";
                $eval_dump .= "'field_filter' => array(";
                $additionalEval = array();
                $additionalEvalRelated = array();
                $relatedTriggers = '';
                $bean = BeanFactory::newBean($this->base_module);
                $dateTypeFields = array('date', 'datetime', 'datetimecombo');
                if ($row['trigger_type'] != 'compare_any_time'
                	&& !($row['trigger_type'] == 'compare_specific'
                	&& isset($bean->field_defs[$row['target_field']]['type'])
                	&& in_array($bean->field_defs[$row['target_field']]['type'], $dateTypeFields))
                ) {
                    $additionalEval[] = "({$eval})";
                }
                foreach ($this->secondary_triggers as $key => $secondaryTrigger) {
                    $eval_dump .= "'" . $secondaryTrigger['field'] . "', ";

if ($secondaryTrigger['type'] == 'filter_rel_field') {
                        $relatedTriggers .= "\$filter{$key} = " . $secondaryTrigger['eval'] . "; \n";
                        $additionalEval[] = $additionalEvalRelated[] = "\$filter{$key}['results'] === true";
                    } else if (!empty($secondaryTrigger['eval'])
                    	&& $secondaryTrigger['type'] != 'compare_any_time'
                    	&& !($secondaryTrigger['type'] == 'compare_specific'
                    	&& in_array($bean->field_defs[$secondaryTrigger['field']]['type'], $dateTypeFields))
                    ) {
                        $additionalEval[] = $secondaryTrigger['eval'];
                    }
                }
                $eval_dump .= "'" . $row['target_field'] . "'));\n";
                $eval_dump .= $relatedTriggers;
                $eval_dump .= "\$dataChanged = \$GLOBALS['db']->getDataChanges(\$focus, \$checkFields);\n";
                $eval_dump .= "if ((empty(\$focus->fetched_row) ";
                $related = '';
                if (!empty($additionalEvalRelated)) {
                    $related .= "|| (" . implode(' && ', $additionalEvalRelated) . ")";
                }
                $eval_dump .= "|| !empty(\$dataChanged) $related)";
                if (!empty($additionalEval)) {
                    $eval_dump .= ' && (' . implode(' && ', $additionalEval) . ')';
                }
                $eval_dump .= ") {\n";
                // Need to add the $timeArray and $workflow_id here for check_for_schedule() call
                $eval_dump .= $timeArray;
                $eval_dump .= "\$workflow_id = '" . $row['id'] . "'; \n\n";
                $eval_dump .= get_time_contents($row['id']);
                $eval_dump .= "}\n";

$eval_dump .= "// Revert to original value\n";
                $eval_dump .= "if (!empty(\$saveWorkflowCron)) {\n";
                $eval_dump .= "\t\$_SESSION['workflow_cron'] = \$saveWorkflowCron;\n";
                $eval_dump .= "} else {\n";
                $eval_dump .= "\tunset(\$_SESSION['workflow_cron']);\n";
                $eval_dump .= "}\n";
            }
		//end while
		}

$this->glue_object->end_trigger_meta_array();
		$this->glue_object->write_trigger_meta_file($this->base_module);

$this->glue_object->end_alert_meta_array();
		$this->glue_object->write_alert_meta_file($this->base_module);

$this->glue_object->end_action_meta_array();
		$this->glue_object->write_action_meta_file($this->base_module);
		//BEGIN WFLOW PLUGINS
		$this->glue_object->end_plugin_meta_array();
		$this->glue_object->write_plugin_meta_file($this->base_module);
		//END WFLOW PLUGINS

//RRS
        if(!empty($alert_file_contents)){
            $this->glue_object->write_workflow_alerts_file($this->base_module, $alert_file_contents);
        }

return $eval_dump;

//end function get_trigger_contents
}

function get_front_triggers_secondary($workflow_id, & $trigger_count){

$eval = "\t \$secondary_array = array(); \n";

//ORDER BY the related_module and then by the type being all, then any
	//type 'all' must be checked first before the rel_list loses some items, otherwise
	//you can get in-accurate information

$sql = <<<SQL
SELECT *
FROM {$this->rel_triggershells_table}
WHERE parent_id = ?
AND deleted = 0
AND frame_type = 'Secondary'
ORDER BY rel_module, rel_module_type ASC
SQL;

$result = $this->db->getConnection()
            ->executeQuery($sql, [$workflow_id]);

$secondary_count = 0;
        $secondary_triggers = array();
			$eval .= "\t //Secondary Triggers \n";
		// Get the id and the name.
        foreach ($result->iterateAssociative() as $row) {
			$real_secondary = $secondary_count + 1;

$eval .= "\t //Secondary Trigger number #".$real_secondary."\n";

$eval_reached = false;

if($row['type']=="filter_field"){
				$eval .= "\t if(";
				$eval .= html_entity_decode($row['eval'], ENT_QUOTES);
                $secondaryTriggersEval = html_entity_decode($row['eval'], ENT_QUOTES);
				$eval .= "\t ){ \n";
				$eval_reached = true;
			}
			if($row['type']=="filter_rel_field"){
				$this->glue_object->build_trigger_triggers("trigger_".$trigger_count."_secondary_".$secondary_count, $row['id']);
				$secondaryTriggersEval = "check_rel_filter(\$focus, \$secondary_array, '".$row['rel_module']."', \$trigger_meta_array['trigger_".$trigger_count."_secondary_".$secondary_count."'], '".$row['rel_module_type']."')";
				$eval .= "\t \$secondary_array = " . $secondaryTriggersEval . "; \n";
				$eval .= "\t if(";
				$eval .= "(\$secondary_array['results']==true)";
				$eval .= "\t ){ \n";
				$eval_reached = true;
			}
			if($row['type']=="trigger_record_change"){
				$eval .= "\t if(true){ \n";
				$eval_reached = true;
			}
			//BEGIN WFLOW PLUGINS

//prepare the opt array
				$opt['object'] = $this;
				$opt['row'] = $row;
				$opt['trigger_position'] = "Secondary";
				$opt['trigger_count'] = $trigger_count;
				$opt['secondary_count'] = $secondary_count;
				$opt['real_secondary'] = $real_secondary;
				$opt['array_position_name']= "plugin_".$trigger_count."_secondary_".$secondary_count;

if($eval_reached==false){

$eval_array = get_plugin("workflow", "trigger_glue", $opt);
					if(!empty($eval_array['trigger_processed']) && $eval_array['trigger_processed']==true){

$eval .= "\t if(";
						$eval .= $eval_array['eval'];
                        $secondaryTriggersEval = $eval_array['eval'];
						$eval .= "\t ){ \n";
						$eval_reached=true;

//end if processed is true
					}
				}

//END WFLOW PLUGINS

if($eval_reached == false){
				$eval .= "\t if(";
				$eval .= html_entity_decode($row['eval'], ENT_QUOTES);
                $secondaryTriggersEval = html_entity_decode($row['eval'], ENT_QUOTES);
				$eval .= "\t ){ \n";
			}

$eval .= "\t \n\n";

$secondary_triggers[$secondary_count] = array(
                'field' => $row['field'],
                'type' => $row['type'],
                'eval' => !empty($secondaryTriggersEval) ? $secondaryTriggersEval : '',
            );
			++$secondary_count;

//end while
		}

$this->secondary_triggers = $secondary_triggers;
		$this->secondary_count = $secondary_count;
		return $eval;

//end get_front_trigger_flow
}

function get_back_triggers_secondary(){

$eval= "";

for ($i = 0; $i < $this->secondary_count; $i++){

$real_secondary = $i + 1;
			$eval .= "\t // End Secondary Trigger number #".$real_secondary."\n";
			$eval .= " \t } \n\n";

//end the forloop
	}

$eval .= "\t unset(\$secondary_array); \n";

return $eval;

}

function get_alert_contents($workflow_id, $trigger_count, $alert_array_name){

$alert_count = 0;

$alert_string = "";

$sql = <<<SQL
SELECT parent_id parent_id, id, alert_text, source_type, alert_type, custom_template_id
FROM  {$this->rel_alertshells_table}
WHERE deleted = 0
AND parent_id = ?
SQL;

$result = $this->db->getConnection()
            ->executeQuery($sql, [$workflow_id]);

// Get the id and the name.
        foreach ($result->iterateAssociative() as $row) {
            $alert_string .= <<<'PHP'
    $alertshell_array = [];

PHP;

if ($row['source_type'] === 'Custom Template') {
                //use custom msg
                $alert_string .= sprintf(
                    <<<'PHP'
    $alertshell_array['alert_msg'] = '%s';

PHP
                    ,
                    filter_var($row['custom_template_id'], FILTER_SANITIZE_ADD_SLASHES)
                );
            } else {
                //use regular msg
                $alert_string .= sprintf(
                    <<<'PHP'
    $alertshell_array['alert_msg'] = '%s';

PHP
                    ,
                    filter_var($row['alert_text'], FILTER_SANITIZE_ADD_SLASHES)
                );
            }
            $alert_string .= sprintf(
                <<<'PHP'
    $alertshell_array['source_type'] = '%s';
    $alertshell_array['alert_type'] = '%s';

PHP
                ,
                filter_var($row['source_type'], FILTER_SANITIZE_ADD_SLASHES),
                filter_var($row['alert_type'], FILTER_SANITIZE_ADD_SLASHES)
            );

//Check for bridging object.  This is for meetings/calls
            if ($row['alert_type'] == "Invite") {
                $check_for_bridge = 'true';
            } else {
                $check_for_bridge = 'false';
            }

$sanitized_array_position_name = filter_var("{$alert_array_name}{$trigger_count}_alert{$alert_count}", FILTER_SANITIZE_ADD_SLASHES);
            $this->glue_object->build_trigger_alerts($row['id'], $sanitized_array_position_name);
            $alert_string .= sprintf(
                <<<'PHP'
    process_workflow_alerts($focus, $alert_meta_array['%s'], $alertshell_array, %s);

PHP
                ,
                $sanitized_array_position_name,
                $check_for_bridge
            );

++ $alert_count;

//end while statement
		}
        $alert_string .= <<<'PHP'
    unset($alertshell_array);

PHP;

return $alert_string;

//end function get_alert_contents
}

/**
 * Return the contents for the workflow_alerts.php file
 * @param workflow_id - the unique id of this workflow
 * @param trigger_count - the number associated with the trigger for this alert
 * @param alert_array_name - the unique number associated with this alert array
 *
 * @return the contents for the file
 */
function get_alert_contents_for_file($workflow_id, $trigger_count, $alert_array_name){

$alert_count = 0;

$alert_string = "";
    $eval_dump = '$_SESSION[\'WORKFLOW_ALERTS\'] = isset($_SESSION[\'WORKFLOW_ALERTS\']) && ArrayFunctions::is_array_access($_SESSION[\'WORKFLOW_ALERTS\']) ? $_SESSION[\'WORKFLOW_ALERTS\'] : array();'."\n";
	$eval_dump .= "\t\t".'$_SESSION[\'WORKFLOW_ALERTS\'][\''.$alert_array_name.'\'] = isset($_SESSION[\'WORKFLOW_ALERTS\'][\''.$alert_array_name.'\']) '
	            . '&& ArrayFunctions::is_array_access($_SESSION[\'WORKFLOW_ALERTS\'][\''.$alert_array_name.'\']) ? $_SESSION[\'WORKFLOW_ALERTS\'][\''.$alert_array_name.'\'] : array();'."\n";
	$eval_dump .= "\t\t".'$_SESSION[\'WORKFLOW_ALERTS\'][\''.$alert_array_name.'\'] = ArrayFunctions::array_access_merge($_SESSION[\'WORKFLOW_ALERTS\'][\''.$alert_array_name.'\'],array (';
        $sql = <<<SQL
SELECT parent_id, id, alert_text, source_type, alert_type, custom_template_id
FROM {$this->rel_alertshells_table}
WHERE deleted = 0
AND parent_id = ?
SQL;

$result = $this->db->getConnection()
            ->executeQuery($sql, [$workflow_id]);

// Get the id and the name.
        foreach ($result->iterateAssociative() as $row) {
            $array_position_name = $alert_array_name."".$trigger_count."_alert".$alert_count;
            $eval_dump .= '\''.$array_position_name.'\',';

$alert_string .= sprintf(
                <<<'PHP'
function process_wflow_%s(&$focus) {
    include("custom/modules/%s/workflow/alerts_array.php");
    $alertshell_array = [];
PHP
                ,
                $array_position_name,
                $alert_array_name
            );
            if ($row['source_type'] == "Custom Template") {
                //use custom msg
                $alert_string .= sprintf(
                    <<<'PHP'
    $alertshell_array['alert_msg'] = '%s';
PHP
                    ,
                    filter_var($row['custom_template_id'], FILTER_SANITIZE_ADD_SLASHES)
                );
            } else {
                //use regular msg
                $alert_string .= sprintf(
                    <<<'PHP'
$alertshell_array['alert_msg'] = '%s';
PHP
                    ,
                    filter_var($row['alert_text'], FILTER_SANITIZE_ADD_SLASHES)
                );
            }

$alert_string .= sprintf(
                <<<'PHP'
$alertshell_array['source_type'] = '%s';
$alertshell_array['alert_type'] = '%s';
PHP
                ,
                filter_var($row['source_type'], FILTER_SANITIZE_ADD_SLASHES),
                filter_var($row['alert_type'], FILTER_SANITIZE_ADD_SLASHES)
            );

//Check for bridging object.  This is for meetings/calls
            if($row['alert_type']=="Invite"){
                $check_for_bridge = "true";
            } else {
                $check_for_bridge = "false";
            }

$this->glue_object->build_trigger_alerts($row['id'], $array_position_name);

$alert_string .= "\t process_workflow_alerts(\$focus, \$alert_meta_array['".$array_position_name."'], \$alertshell_array, ".$check_for_bridge."); \n ";
            $alert_string .= "\t unset(\$alertshell_array); \n";
            $alert_string .= "\t }\n\n";
        ++ $alert_count;

//end while statement
        }
        $eval_dump .= '));';

return array($eval_dump, $alert_string);

//end function get_alert_contents
}

function get_action_contents($workflow_id, $trigger_count, $action_module_name, $workflow_trigger_id = ''){

$action_count = 0;

$action_string = "";
        $sql = <<<SQL
SELECT *
FROM {$this->rel_actionshells_table}
WHERE deleted = 0
AND parent_id = ?
SQL;

$result = $this->db->getConnection()
            ->executeQuery($sql, [$workflow_id]);

// Get the id and the name.
        foreach ($result->iterateAssociative() as $row) {
			$process=true;

if($row['action_type']=="new" && ($row['action_module']=="Calls" || $row['action_module']=="Meetings" || $row['action_module']=="calls" || $row['action_module']=="meetings")){

$actionshell_object = BeanFactory::newBean('WorkFlowActionShells');
				$process = $actionshell_object->check_for_child_invitee($row['id']);

//end special child check for meetings/calls
			}

if($process==true){

$plugin_process = false;

//BEGIN WFLOW PLUGINS

//prepare the opt array
				$opt['object'] = $this;
				$opt['row'] = $row;
				$opt['array_position_name']= "plugin_".$trigger_count."_action".$action_count;

$action_output_array = get_plugin("workflow", "action_glue", $opt);
					if(!empty($action_output_array['action_processed']) && $action_output_array['action_processed']==true){

$action_string .= $action_output_array['action_string'];
						$plugin_process=true;

++ $action_count;

//end if processed is true
					}

//END WFLOW PLUGINS

if($plugin_process==false){

$array_position_name = $action_module_name."".$trigger_count."_action".$action_count;

$this->glue_object->build_trigger_actions($row['id'], $array_position_name, $row);

// Some processes need to keep track of workflows that have
						// fired while away from the workflow engine. This allows
						// for that.
						if ($workflow_trigger_id) {
                            $action_string .= "\t\$action_meta_array['" .
                                $array_position_name . "']['trigger_id'] = '$workflow_trigger_id';\n";
                            $action_string .= "\t\$action_meta_array['" .
                                $array_position_name . "']['action_id'] = '{$row['id']}';\n";
                            $action_string .= "\t \$action_meta_array['" .
                                $array_position_name . "']['workflow_id'] = '$workflow_id';\n";
						}
						$action_string .= "\t process_workflow_actions(\$focus, \$action_meta_array['".$array_position_name."']); \n ";

++ $action_count;

}
			//end if process is true
			}

//end while statement
		}

return $action_string;

//end function get_alert_contents
}

////////////////GETTING RELATED MODULE PULLDOWNS

function get_field_value_array($base_module=false, $inclusion_type=false, $exclusion_type=false){
        $inclusion_array = null;
	if($base_module==false){
		$base_module = $this->base_module;
	}

if($exclusion_type=="Field"){
			$exclusion_array = array('link' => 'link');
		} else {
			$exclusion_array = "";
		}

if($inclusion_type!=false){

if($inclusion_type=="User"){
			$inclusion_array = array('assigned_user_name' => 'assigned_user_name');
		}
		if($inclusion_type=="Char"){
			$inclusion_array = array('char' => 'char');
			$inclusion_array = array('varchar' => 'varchar');
		}
		if($inclusion_type=="Email"){
			$inclusion_array = array('email' => 'email');
		}
	} else {
		$inclusion_array = null;
	}

$field_option_list = get_column_select($base_module, "", $exclusion_array, $inclusion_array);
	//return the field value array with an inclusion array to only have assigned users

return $field_option_list;
}

/////we should be able to remove the below function!!! replaced by vardefhandler
function get_rel_module_array($include_none=false){

$inclusion_array = array('link' => 'link');

$field_option_list = get_column_select($this->base_module, "", "", $inclusion_array, $include_none);
	//return the field value array with an inclusion array to only have linking vardef elements

return $field_option_list;
}

function get_rel_module($var_rel_name, $get_rel_name = false){

//get the vardef fields relationship name
	//get the base_module bean
	$module_bean = BeanFactory::newBean($this->base_module);
    if (!empty($module_bean->field_defs[$var_rel_name]['type'])
        && $module_bean->field_defs[$var_rel_name]['type'] == "link"
        && $module_bean->load_relationship($var_rel_name)
    ) {
        //Have to set the relationshpip name for this workflow object
        $this->rel_name = $module_bean->$var_rel_name->getRelationshipObject()->name;
        return $module_bean->$var_rel_name->getRelatedModuleName();
    }

$rel_name = Relationship::retrieve_by_modules($var_rel_name, $this->base_module, $GLOBALS['db']);
	if(!empty($module_bean->field_defs[$rel_name])){
		$var_rel_name = $rel_name;
	}
	$var_rel_name = strtolower($var_rel_name);
    if($get_rel_name)
    {
        //bug #46246: should set relationship name instead of related field name
            $this->rel_name = $rel_name ?? $var_rel_name;
    }
	$rel_attribute_name = $module_bean->field_defs[$var_rel_name]['relationship'];
	//use the vardef to retrive the relationship attribute
	unset($module_bean);

return get_rel_module_name($this->base_module, $rel_attribute_name, $this->db);

}

function check_logic_hook_file(){

$module_name = $this->base_module;
$event = "before_save";
$action_array = array('1', 'workflow','include/workflow/WorkFlowHandler.php', 'WorkFlowHandler', 'WorkFlowHandler');

check_logic_hook_file($module_name, $event, $action_array);

}

/**
     * Repair and rebuild all Workflows
     * @param bool $skipDeactivated optional Skip repairing deactivated workflow or not
     */
    public function repair_workflow($skipDeactivated = false)
    {
        $skipWhere = '';
        if ($skipDeactivated) {
            $skipWhere = ' and status = 1';
        }
        $query = "SELECT DISTINCT base_module, id FROM $this->table_name WHERE deleted = 0" . $skipWhere;

$result = $this->db->query($query, true, " Error repairing workflow: ");

// Get the id and the name.
        while ($row = $this->db->fetchByAssoc($result)) {
            $this->retrieve($row['id']);
            $this->rebuildTriggers();
            $this->check_logic_hook_file();
            $this->write_workflow();
        }
    }

/**
     * Rebuild workflow triggers
     */
    public function rebuildTriggers()
    {
        $triggerList = $this->get_linked_beans('triggers', 'WorkFlowTriggerShell');
        if (!empty($triggerList)) {
            foreach ($triggerList as $trigger) {
                $futureTrigger = BeanFactory::newBean('Expressions');
                $futureTriggers = $trigger->get_linked_beans('future_triggers', 'Expression');
                if (!empty($futureTriggers)) {
                    $futureTrigger = $futureTriggers[0];
                }

$pastTrigger = BeanFactory::newBean('Expressions');
                $pastTriggers = $trigger->get_linked_beans('past_triggers', 'Expression');
                if (!empty($pastTriggers)) {
                    $pastTrigger = $pastTriggers[0];
                }

$trigger->glue_triggers($pastTrigger, $futureTrigger);
                $trigger->save();
            }
        }

$triggerFilterList = $this->get_linked_beans('trigger_filters', 'WorkFlowTriggerShell');
        if (!empty($triggerFilterList)) {
            foreach ($triggerFilterList as $triggerFilter) {
                $triggerExpressions = $triggerFilter->get_linked_beans('expressions', 'Expression');
                if (!empty($triggerExpressions)) {
                    $triggerExpression = $triggerExpressions[0];

$triggerFilter->glue_trigger_filters($triggerExpression);
                    $triggerFilter->save();
                }
            }
        }
    }

function get_parent_object(){

//check for parent object, and if it exists, then grab and return.
		//This is used for bridiging workflow objects.  Needed for invite/recipient components

if($this->parent_id!=""){

$action_shell_object = BeanFactory::getBean('WorkFlowActionShells', $this->parent_id);
			$workflow_object = BeanFactory::getBean('WorkFlow', $action_shell_object->parent_id);
			return $workflow_object;
		}
			//parent does not exist so return self
			return $this;

//end function get_parent_object
	}

/**
     * mark_deleted
     * This function handles the management of related workflow components when a workflow is deleted.  The
     * mark_deleted call is also run when the target module of an existing workflow is modified so that the
     * workflow may invalidate the related workflow alerts, actions, etc.
     *
     * @param string $id
     */
    function mark_deleted($id){
		//Completely remove the trigger components////////////////////////
		$trigger_object_list = $this->get_linked_beans('triggers','WorkFlowTriggerShell');
        if(!empty($trigger_object_list)){

foreach($trigger_object_list as $trigger_object){

//mark delete trigger components and sub expression components
				mark_delete_components($trigger_object->get_linked_beans('future_triggers','Expression'));
				mark_delete_components($trigger_object->get_linked_beans('past_triggers','Expression'));
				$trigger_object->mark_deleted($trigger_object->id);
			//end the foreach loop on trigger objects
			}

//end if any alert objects exist
		}

//Completely remove the trigger filter components////////////////////////
		$trigger_object_list = $this->get_linked_beans('trigger_filters','WorkFlowTriggerShell');
		if(!empty($trigger_object_list)){

foreach($trigger_object_list as $trigger_object){

//mark delete trigger filter components and sub expression components
				mark_delete_components($trigger_object->get_linked_beans('expressions','Expression'));
				$trigger_object->mark_deleted($trigger_object->id);
			//end the foreach loop on trigger filter objects
			}

//end if any alert objects exist
		}
		//Completely remove the alert components/////////////////////////
		$alert_object_list = $this->get_linked_beans('alerts','WorkFlowAlertShell');
		if(!empty($alert_object_list)){

foreach($alert_object_list as $alert_object){

//mark delete alert components and sub expression components

//Alert recipient Object///////
					$alert_object_list2 = $alert_object->get_linked_beans('alert_components','WorkFlowAlert');

foreach($alert_object_list2 as $alert_object2){
						mark_delete_components($alert_object2->get_linked_beans('expressions','Expression'));
						mark_delete_components($alert_object2->get_linked_beans('rel1_alert_fil','Expression'));
						mark_delete_components($alert_object2->get_linked_beans('rel2_alert_fil','Expression'));
						$alert_object2->mark_deleted($alert_object2->id);

//end foreach alert_object2
					}

//End Alert recipient Object/////

$alert_object->mark_deleted($alert_object->id);
			//end the forloop on the alert objects
			}

//end if any alert objects exist
		}

//Completely remove the action components////////////////////////
		//mark delete actionshell components, action components and sub expression components
		$action_shell_list = $this->get_linked_beans('actions','WorkFlowActionShell');

foreach($action_shell_list as $action_shell_object){

//check for bridged child (invites for meetings/calls
			$action_shell_object->check_for_child_bridge(true);

//mark delete actionshell sub components and actionshell
			mark_delete_components($action_shell_object->get_linked_beans('actions','WorkFlowAction'));
			mark_delete_components($action_shell_object->get_linked_beans('rel1_action_fil','Expression'));
			$action_shell_object->mark_deleted($action_shell_object->id);
		}

if($this->check_controller==true){
             //Handle re-processing orders
             $controller = new Controller();
             $controller->init($this, "Delete");
             $controller->delete_adjust_order($this->base_module);
         }

// Delete the schedules
        $this->deleteSchedules();

//mark deleted the workflow object if delete_workflow_on_cascade is set to true
        if($this->delete_workflow_on_cascade)
        {
		    parent::mark_deleted($id);
        }
		$this->write_workflow();

//end function mark_deleted
	}

function getActiveWorkFlowCount() {
    $activeCount = 0;
    $query = "SELECT COUNT( * ) as active_count FROM workflow WHERE deleted=0 and status=1";
    $result = $this->db->query($query);
    $row = $this->db->fetchByAssoc($result);
    $activeCount = $row['active_count'];
    return $activeCount;
}

/**
     * Delete all schedules for the workflow
     *
     * @return void
     */
    public function deleteSchedules()
    {
        //@codingStandardsIgnoreStart
        $query =  "SELECT id FROM workflow_schedules WHERE workflow_schedules.workflow_id = " . $this->db->quoted($this->id);
        $result = $this->db->query($query, true, "Error getting workflow_schedules for workflow_id: " . $this->db->quote($this->id));
        //@codingStandardsIgnoreEnd

// Remove each workflow schedule by id
        $removeExpired = array();
        $workflowSchedule = new WorkFlowSchedule();
        while ($row = $this->db->fetchByAssoc($result)) {
            $removeExpired[] = $row['id'];
        }
        $workflowSchedule->remove_expired($removeExpired);
    }

/**
     * Delete all workflow triggers
     *
     * @return void
     */
    public function deleteTriggers()
    {
        $trigger_object_list = $this->get_linked_beans('triggers', 'WorkFlowTriggerShell');

foreach ($trigger_object_list as $trigger_object) {
            //mark delete trigger components and sub expression components
            mark_delete_components($trigger_object->get_linked_beans('future_triggers', 'Expression'));
            mark_delete_components($trigger_object->get_linked_beans('past_triggers', 'Expression'));
            $trigger_object->mark_deleted($trigger_object->id);
        }
    }

/**
     * Deletes all trigger filters from the workflow
     *
     * @return void
     */
    public function deleteTriggerFilters()
    {
        $trigger_object_list = $this->get_linked_beans('trigger_filters', 'WorkFlowTriggerShell');

foreach ($trigger_object_list as $trigger_object) {
            //mark delete trigger filter components and sub expression components
            mark_delete_components($trigger_object->get_linked_beans('expressions', 'Expression'));
            $trigger_object->mark_deleted($trigger_object->id);
        }
    }

/**
     * Deletes all alerts for the workflow
     *
     * @return void
     */
    public function deleteAlerts()
    {
        $alert_object_list = $this->get_linked_beans('alerts', 'WorkFlowAlertShell');

foreach ($alert_object_list as $alert_object) {
            $alert_object_list2 = $alert_object->get_linked_beans('alert_components', 'WorkFlowAlert');
            foreach ($alert_object_list2 as $alert_object2) {
                mark_delete_components($alert_object2->get_linked_beans('expressions', 'Expression'));
                mark_delete_components($alert_object2->get_linked_beans('rel1_alert_fil', 'Expression'));
                mark_delete_components($alert_object2->get_linked_beans('rel2_alert_fil', 'Expression'));
                $alert_object2->mark_deleted($alert_object2->id);
            }

$alert_object->mark_deleted($alert_object->id);
        }
    }

/**
     * Deletes all actions for the workflow
     *
     * @return void
     */
    public function deleteActions()
    {
        $action_shell_list = $this->get_linked_beans('actions', 'WorkFlowActionShell');

foreach ($action_shell_list as $action_shell_object) {
            //check for bridged child (invites for meetings/calls
            $action_shell_object->check_for_child_bridge(true);

//mark delete actionshell sub components and actionshell
            mark_delete_components($action_shell_object->get_linked_beans('actions', 'WorkFlowAction'));
            mark_delete_components($action_shell_object->get_linked_beans('rel1_action_fil', 'Expression'));
            $action_shell_object->mark_deleted($action_shell_object->id);
        }
    }

/**
     * Delete all WorkFlows related to a given set of modules.
     *
     * @param array $modules Names of modules whose related WorkFlows we'll be deleting
     * @throws SugarQueryException
     */
    public static function deleteWorkFlowsByModule($modules)
    {
        $query = new SugarQuery();
        $query->select('id');
        $query->from(BeanFactory::newBean('WorkFlow'));
        $query->where()->in('base_module', $modules);
        $result = $query->execute();
        foreach ($result as $row) {
            // WorkFlow beans override SugarBean::mark_deleted with custom logic that assumes a bean is populated
            // with data. BeanFactory::deleteBean doesn't fetch bean data, so we retrieve and delete the related
            // WorkFlow beans here.
            $workFlow = BeanFactory::retrieveBean('WorkFlow', $row['id']);
            if ($workFlow) {
                $workFlow->mark_deleted($row['id']);
            }
        }
    }

//end class
}