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

/**
 * Class Bug
 */
class Bug extends Issue
{
    // Stored fields
    public $id;
    public $date_modified;
    public $modified_user_id;
    public $assigned_user_id;
    public $team_id;
    public $bug_number;
    public $description;
    public $name;
    public $priority;

// These are related
    public $resolution;
    public $found_in_release;
    public $release_name;
    public $fixed_in_release_name;
    public $created_by;
    public $created_by_name;
    public $modified_by_name;
    public $account_id;
    public $contact_id;
    public $case_id;
    public $task_id;
    public $note_id;
    public $meeting_id;
    public $call_id;
    public $email_id;
    public $assigned_user_name;
    public $type;
    public $team_name;

//BEGIN Additional fields being added to Bug Tracker

public $fixed_in_release;
    public $work_log;
    public $source;
    public $product_category;
    public $follow_up_datetime;

//END Additional fields being added to Bug Tracker

public $module_dir = 'Bugs';
    public $table_name = 'bugs';
    public $rel_account_table = 'accounts_bugs';
    public $rel_contact_table = 'contacts_bugs';
    public $rel_case_table = 'cases_bugs';
    public $importable = true;
    public $object_name = 'Bug';

// This is used to retrieve related fields from form posts.
    public $additional_column_fields = ['assigned_user_name', 'assigned_user_id', 'case_id', 'account_id', 'contact_id', 'task_id', 'note_id', 'meeting_id', 'call_id', 'email_id'];

public $relationship_fields = ['case_id' => 'cases', 'account_id' => 'accounts', 'contact_id' => 'contacts',
        'task_id' => 'tasks', 'note_id' => 'notes', 'meeting_id' => 'meetings',
        'call_id' => 'calls', 'email_id' => 'emails'];

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

$this->setupCustomFields('Bugs');

foreach ($this->field_defs as $field) {
            if (!isset($field['name'])) {
                continue;
            }
            $this->field_defs[$field['name']] = $field;
        }
    }

public $new_schema = true;

public function create_list_query($order_by, $where, $show_deleted = 0)
    {
        $custom_join = $this->custom_fields->getJOIN();

$custom_join = $this->getCustomJoin();

$query = 'SELECT ';

$query .= '
                               bugs.*

,users.user_name as assigned_user_name, releases.id release_id, releases.name release_name';
        $query .= ', teams.name AS team_name';
        $query .= $custom_join['select'];
        $query .= ' FROM bugs ';

// We need to confirm that the user is a member of the team of the item.
        $this->add_team_security_where_clause($query);
        $query .= '				LEFT JOIN releases ON bugs.found_in_release=releases.id
								LEFT JOIN users
                                ON bugs.assigned_user_id=users.id';
        $query .= ' LEFT JOIN teams ON bugs.team_id=teams.id';
        $query .= '  ';
        $query .= $custom_join['join'];
        $where_auto = '1=1';
        if ($show_deleted == 0) {
            $where_auto = " $this->table_name.deleted=0 ";
        } elseif ($show_deleted == 1) {
            $where_auto = " $this->table_name.deleted=1 ";
        }

if ($where != '') {
            $query .= "where $where AND " . $where_auto;
        } else {
            $query .= 'where ' . $where_auto;
        }
        if (substr_count($order_by, '.') > 0) {
            $query .= " ORDER BY $order_by";
        } elseif ($order_by != '') {
            $query .= " ORDER BY $order_by";
        } else {
            $query .= ' ORDER BY bugs.name';
        }
        return $query;
    }

public function fill_in_additional_detail_fields()
    {
        parent::fill_in_additional_detail_fields();
        $this->set_release();
        $this->set_fixed_in_release();
    }

public function set_release()
    {
        static $releases;

if (empty($this->found_in_release)) {
            return;
        }
        if (isset($releases[$this->found_in_release])) {
            $this->release_name = $releases[$this->found_in_release];
            return;
        }

$query = <<<SQL
SELECT r1.name 
FROM releases r1, {$this->table_name} i1 
WHERE r1.id = i1.found_in_release 
  AND i1.id = ? 
  AND i1.deleted=0 
  AND r1.deleted=0
SQL;

$stmt = $this->db->getConnection()
            ->executeQuery($query, [$this->id]);
        $row = $stmt->fetchAssociative();

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

$releases[$this->found_in_release] = $this->release_name;
    }

public function set_fixed_in_release()
    {
        static $releases;

if (empty($this->fixed_in_release)) {
            return;
        }
        if (isset($releases[$this->fixed_in_release])) {
            $this->fixed_in_release_name = $releases[$this->fixed_in_release];
            return;
        }

$query = <<<SQL
SELECT r1.name FROM
releases r1, {$this->table_name} i1
WHERE r1.id = i1.fixed_in_release 
AND i1.id = ? AND i1.deleted=0 AND r1.deleted=0
SQL;

$row = $this->db->getConnection()
            ->executeQuery(
                $query,
                [$this->id]
            )->fetchAssociative();

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

$releases[$this->fixed_in_release] = $this->fixed_in_release_name;
    }

public function get_list_view_data($filter_fields = [])
    {
        global $current_language;
        $the_array = parent::get_list_view_data();
        $app_list_strings = return_app_list_strings_language($current_language);
        $mod_strings = return_module_language($current_language, 'Bugs');

$this->set_release();

// The new listview code only fetches columns that we're displaying and not all
        // the columns so we need these checks.
        $the_array['NAME'] = (($this->name == '') ? '<em>blank</em>' : $this->name);
        $the_array['PRIORITY'] = empty($this->priority)
            ? ''
            : (!isset($app_list_strings[$this->field_defs['priority']['options']][$this->priority])
                ? $this->priority
                : $app_list_strings[$this->field_defs['priority']['options']][$this->priority]);
        $the_array['STATUS'] = empty($this->status)
            ? ''
            : (!isset($app_list_strings[$this->field_defs['status']['options']][$this->status])
                ? $this->status
                : $app_list_strings[$this->field_defs['status']['options']][$this->status]);
        $the_array['TYPE'] = empty($this->type)
            ? ''
            : (!isset($app_list_strings[$this->field_defs['type']['options']][$this->type])
                ? $this->type
                : $app_list_strings[$this->field_defs['type']['options']][$this->type]);
        $the_array['RELEASE'] = $this->release_name;
        $the_array['BUG_NUMBER'] = $this->bug_number;
        $the_array['ENCODED_NAME'] = $this->name;
        $the_array['BUG_NUMBER'] = format_number_display($this->bug_number);

return $the_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
     */
    public function build_generic_where_clause($the_query_string)
    {
        $where_clauses = [];
        $the_query_string = $this->db->quote($the_query_string);
        array_push($where_clauses, "bugs.name like '$the_query_string%'");
        if (is_numeric($the_query_string)) {
            array_push($where_clauses, "bugs.bug_number 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 set_notification_body($xtpl, $bug)
    {
        global $mod_strings, $app_list_strings;

$bug->set_release();

$xtpl->assign('BUG_SUBJECT', $bug->name);
        $xtpl->assign('BUG_TYPE', $app_list_strings['bug_type_dom'][$bug->type]);
        $xtpl->assign('BUG_PRIORITY', $app_list_strings['bug_priority_dom'][$bug->priority]);
        $xtpl->assign('BUG_STATUS', $app_list_strings['bug_status_dom'][$bug->status]);
        $xtpl->assign('BUG_RESOLUTION', $app_list_strings['bug_resolution_dom'][$bug->resolution]);
        $xtpl->assign('BUG_RELEASE', $bug->release_name);
        $xtpl->assign('BUG_DESCRIPTION', $bug->description);
        $xtpl->assign('BUG_WORK_LOG', $bug->work_log);
        $xtpl->assign('BUG_BUG_NUMBER', $bug->bug_number);
        return $xtpl;
    }

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

function getReleaseDropDown()
{
    static $releases = null;
    if (!$releases) {
        $seedRelease = BeanFactory::newBean('Releases');
        $releases = $seedRelease->get_releases(true, 'Active');
    }
    return $releases;
}