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

/**
 * Data access layer for the project table
 */
class Project extends SugarBean
{
    // database table columns
    public $id;
    public $date_entered;
    public $date_modified;
    public $assigned_user_id;
    public $modified_user_id;
    public $created_by;
    public $team_id;
    public $name;
    public $description;
    public $deleted;

public $is_template;

// related information
    public $assigned_user_name;
    public $modified_by_name;
    public $created_by_name;
    public $team_name;

public $account_id;
    public $contact_id;
    public $opportunity_id;
    public $quote_id;
    public $email_id;
    public $estimated_start_date;

// calculated information
    public $total_estimated_effort;
    public $total_actual_effort;

public $object_name = 'Project';
    public $module_dir = 'Project';
    public $new_schema = true;
    public $table_name = 'project';

// This is used to retrieve related fields from form posts.
    public $additional_column_fields = [
        'account_id',
        'contact_id',
        'quote_id',
        'opportunity_id',
    ];

public $relationship_fields = [
        'account_id' => 'accounts',
        'contact_id' => 'contacts',
        'quote_id' => 'quotes',
        'opportunity_id' => 'opportunities',
        'email_id' => 'emails',
        'holiday_id' => 'holidays',
    ];

//////////////////////////////////////////////////////////////////
    // METHODS
    //////////////////////////////////////////////////////////////////

/**
     * Save changes that have been made to a relationship.
     *
     * @param $is_update true if this save is an update.
     */
    public function save_relationship_changes($is_update, $exclude = [])
    {
        parent::save_relationship_changes($is_update, $exclude);
        $new_rel_id = false;
        $new_rel_link = false;
        //this allows us to dynamically relate modules without adding it to the relationship_fields array
        if (!empty($_REQUEST['relate_id']) && !safeInArray($_REQUEST['relate_to'], $exclude) && $_REQUEST['relate_id'] != $this->id) {
            $new_rel_id = $_REQUEST['relate_id'];
            $new_rel_relname = $_REQUEST['relate_to'];
            if (!empty($this->in_workflow) && !empty($this->not_use_rel_in_req)) {
                $new_rel_id = $this->new_rel_id;
                $new_rel_relname = $this->new_rel_relname;
            }
            $new_rel_link = $new_rel_relname;
            //Try to find the link in this bean based on the relationship
            foreach ($this->field_defs as $key => $def) {
                if (isset($def['type']) && $def['type'] == 'link'
                    && isset($def['relationship']) && $def['relationship'] == $new_rel_relname) {
                    $new_rel_link = $key;
                }
            }
            if ($new_rel_link == 'contacts') {
                $accountId = $this->db->getOne('SELECT account_id FROM accounts_contacts WHERE contact_id=' . $this->db->quoted($new_rel_id));
                if ($accountId !== false) {
                    if ($this->load_relationship('accounts')) {
                        $this->accounts->add($accountId);
                    }
                }
            }
        }
    }
    /**
     *
     */
    // @codingStandardsIgnoreLine PSR2.Methods.MethodDeclaration.Underscore
    public function _get_total_estimated_effort($project_id)
    {
        $return_value = '';

$query = 'SELECT SUM(' . $this->db->convert('estimated_effort', 'IFNULL', ['0']) . ') total_estimated_effort';
        $query .= ' FROM project_task';
        $query .= " WHERE project_id='{$project_id}' AND deleted=0";

$result = $this->db->query($query, true, ' Error filling in additional detail fields: ');
        $row = $this->db->fetchByAssoc($result);
        if ($row != null) {
            $return_value = $row['total_estimated_effort'];
        }

return $return_value;
    }

/**
     *
     */
    // @codingStandardsIgnoreLine PSR2.Methods.MethodDeclaration.Underscore
    public function _get_total_actual_effort($project_id)
    {
        $return_value = '';

$query = 'SELECT SUM(' . $this->db->convert('actual_effort', 'IFNULL', ['0']) . ') total_actual_effort';
        $query .= ' FROM project_task';
        $query .= " WHERE project_id='{$project_id}' AND deleted=0";

return $return_value;
    }

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

/**
     *
     */
    public function build_generic_where_clause($the_query_string)
    {
        $where_clauses = [];
        $the_query_string = $GLOBALS['db']->quote($the_query_string);
        array_push($where_clauses, "project.name LIKE '%$the_query_string%'");

$the_where = '';
        foreach ($where_clauses as $clause) {
            if ($the_where != '') {
                $the_where .= ' OR ';
            }
            $the_where .= $clause;
        }

return $the_where;
    }

public function get_list_view_data($filter_fields = [])
    {
        $field_list = $this->get_list_view_array();
        $field_list['USER_NAME'] = empty($this->user_name) ? '' : $this->user_name;
        $field_list['ASSIGNED_USER_NAME'] = $this->assigned_user_name;
        return $field_list;
    }

public function bean_implements($interface)
    {
        switch ($interface) {
            case 'ACL':
                return true;
        }
        return false;
    }

/** {@inheritDoc} */
    public function mark_deleted($id)
    {
        $this->markTasksDeleted($id);

parent::mark_deleted($id);
    }

/**
     * Marks project tasks deleted
     *
     * @param string $id
     */
    protected function markTasksDeleted($id)
    {
        if ($this->id != $id) {
            $bean = BeanFactory::getBean($this->module_name, $id);
            $bean->id = $id;
        } else {
            $bean = $this;
        }

if (!$bean->load_relationship('projecttask')) {
            return;
        }

foreach ($bean->projecttask->getBeans() as $task) {
            $task->mark_deleted($task->id);
        }
    }

public function getProjectHolidays()
    {
        $firstName = $this->db->convert($this->db->convert('users.first_name', 'IFNULL', ['contacts.first_name']), 'IFNULL', ["''"]);
        $lastName = ["' '", $this->db->convert($this->db->convert('users.last_name', 'IFNULL', ['contacts.last_name']), 'IFNULL', ["''"])];
        $resource_select = 'LTRIM(RTRIM(' . $this->db->convert($firstName, 'CONCAT', $lastName) . '))';

$query = 'SELECT holidays.id, holidays.holiday_date, holidays.description as description, '
            . $resource_select . ' as resource_name ' .
            ' FROM holidays LEFT JOIN users on users.id = holidays.person_id' .
            ' LEFT JOIN contacts on contacts.id = holidays.person_id' .
            " WHERE related_module_id = '" . $this->id . "'" .
            " AND holidays.related_module like 'Project'" .
            ' AND holidays.deleted = 0';
        return $query;
    }

public function isTemplate()
    {
        if (!empty($this->is_template) && $this->is_template == '1') {
            return true;
        } else {
            return false;
        }
    }

public function getAllProjectTasks()
    {
        $projectTasks = [];

$query = "SELECT * FROM project_task WHERE project_id = '" . $this->id . "' AND deleted = 0 ORDER BY project_task_id";
        $result = $this->db->query($query, true, 'Error retrieving project tasks');
        while (($row = $this->db->fetchByAssoc($result)) != null) {
            $projectTaskBean = BeanFactory::retrieveBean('ProjectTask', $row['id']);
            if (empty($projectTaskBean)) {
                continue;
            }
            array_push($projectTasks, $projectTaskBean);
        }

return $projectTasks;
    }

/* helper function for UserHoliday subpanel -- display javascript that cannot be achieved through AJAX call */
    public function resourceSelectJS()
    {
        $userBean = BeanFactory::newBean('Users');
        $contactBean = BeanFactory::newBean('Contacts');

$this->load_relationship('user_resources');
        $userResources = $this->user_resources->getBeans($userBean);
        $this->load_relationship('contact_resources');
        $contactResources = $this->contact_resources->getBeans($contactBean);

ksort($userResources);
        ksort($contactResources);

$userResourceOptions = '';
        $contactResourceOptions = '';

$i = 0;
        $userResourceArr = "var userResourceArr = document.getElementById('person_id').options;\n";
        //set the dropdown to '-none', or retrieve User Resources
        if (empty($userResources)) {
            $userResourceOptions .= "var userResource$i = new Option('" . $GLOBALS['app_strings']['LBL_NONE'] . "', '');\n";
            $userResourceOptions .= "userResourceArr[userResourceArr.length] = userResource$i;\n";
        } else {
            foreach ($userResources as $userResource) {
                $userResourceOptions .= "var userResource$i = new Option('$userResource->full_name', '$userResource->id');\n";
                $userResourceOptions .= "userResourceArr[userResourceArr.length] = userResource$i;\n";
                $i = $i + 1;
            }
        }

$i = 0;
        $contactResourceArr = "var contactResourceArr = document.getElementById('person_id').options;\n";
        //set the dropdown to '-none', or retrieve Contact Resources
        if (empty($contactResources)) {
            $contactResourceOptions .= "var contactResource$i = new Option('" . $GLOBALS['app_strings']['LBL_NONE'] . "', '');\n";
            $contactResourceOptions .= "contactResourceArr[contactResourceArr.length] = contactResource$i;\n";
        } else {
            foreach ($contactResources as $contactResource) {
                $contactResourceOptions .= "var contactResource$i = new Option('$contactResource->full_name', '$contactResource->id');\n";
                $contactResourceOptions .= "contactResourceArr[contactResourceArr.length] = contactResource$i;\n";
                $i = $i + 1;
            }
        }

return "
function showResourceSelect(){
	if (document.getElementById('person_type').value=='Users') {
		constructUserSelect();
	}
	else if (document.getElementById('person_type').value=='Contacts') {
		constructContactSelect();
	}
	else{
		if (document.getElementById('person_id') != null){
			document.getElementById('resourceSelector').removeChild(document.getElementById('person_id'));
		}
	}
}
function constructSelect(){
	document.getElementById('resourceSelector').innerHTML = '<select id=\"person_id\" name=\"person_id\"></select>'
}

function constructUserSelect(){
	if (document.getElementById('person_id') != null){
		document.getElementById('resourceSelector').removeChild(document.getElementById('person_id'));
	}

constructSelect();
	$userResourceArr
	$userResourceOptions
}

function constructContactSelect(){
	if (document.getElementById('person_id') != null){
		document.getElementById('resourceSelector').removeChild(document.getElementById('person_id'));
	}

constructSelect();
	$contactResourceArr
	$contactResourceOptions
}
";
    }
}