function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); if (empty($this->id)) { return; } global $locale, $app_list_strings, $current_user; // retrieve the account information and the information about the person the contact reports to. $query = "SELECT acc.id, acc.name, con_reports_to.first_name, con_reports_to.last_name\n\t\tfrom contacts\n\t\tleft join accounts_contacts a_c on a_c.contact_id = '" . $this->id . "' and a_c.deleted=0\n\t\tleft join accounts acc on a_c.account_id = acc.id and acc.deleted=0\n\t\tleft join contacts con_reports_to on con_reports_to.id = contacts.reports_to_id\n\t\twhere contacts.id = '" . $this->id . "'"; // Bug 43196 - If a contact is related to multiple accounts, make sure we pull the one we are looking for // Bug 44730 was introduced due to this, fix is to simply clear any whitespaces around the account_id first $clean_account_id = trim($this->account_id); if (!empty($clean_account_id)) { $query .= " and acc.id = '{$this->account_id}'"; } $query .= " ORDER BY a_c.date_modified DESC"; $result = $this->db->query($query, true, " Error filling in additional detail fields: "); // Get the id and the name. $row = $this->db->fetchByAssoc($result); if ($row != null) { $this->account_name = $row['name']; $this->account_id = $row['id']; $this->report_to_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name'], '', '', '', null, true); } else { $this->account_name = ''; $this->account_id = ''; $this->report_to_name = ''; } $this->load_contacts_users_relationship(); /** concating this here because newly created Contacts do not have a * 'name' attribute constructed to pass onto related items, such as Tasks * Notes, etc. */ $this->name = $locale->getLocaleFormattedName($this->first_name, $this->last_name); if (!empty($this->contacts_users_id)) { $this->sync_contact = true; } if (!empty($this->portal_active) && $this->portal_active == 1) { $this->portal_active = true; } // Set campaign name if there is a campaign id if (!empty($this->campaign_id)) { $camp = new Campaign(); $where = "campaigns.id='{$this->campaign_id}'"; $campaign_list = $camp->get_full_list("campaigns.name", $where, true); $this->campaign_name = $campaign_list[0]->name; } }
function fill_in_additional_detail_fields() { //Fill in the assigned_user_name //if(!empty($this->status)) //$this->status = translate('lead_status_dom', '', $this->status); parent::fill_in_additional_detail_fields(); $this->_create_proper_name_field(); $this->get_contact(); $this->get_opportunity(); $this->get_account(); if (!empty($this->campaign_id)) { $camp = new Campaign(); $where = "campaigns.id='{$this->campaign_id}'"; $campaign_list = $camp->get_full_list("campaigns.name", $where, true); if (!empty($campaign_list)) { $this->campaign_name = $campaign_list[0]->name; } } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); //rrs bug: 28184 - instead of removing this code altogether just adding this check to ensure that if the parent_name //is empty then go ahead and fill it. if (empty($this->parent_name) && !empty($this->id)) { $query = "SELECT a1.name from accounts a1, accounts a2 where a1.id = a2.parent_id and a2.id = '{$this->id}' and a1.deleted=0"; $result = $this->db->query($query, true, " Error filling in additional detail fields: "); // Get the id and the name. $row = $this->db->fetchByAssoc($result); if ($row != null) { $this->parent_name = $row['name']; } else { $this->parent_name = ''; } } // Set campaign name if there is a campaign id if (!empty($this->campaign_id)) { $camp = new Campaign(); $where = "campaigns.id='{$this->campaign_id}'"; $campaign_list = $camp->get_full_list("campaigns.name", $where, true); $this->campaign_name = $campaign_list[0]->name; } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); global $locale, $app_list_strings, $current_user; // retrieve the account information and the information about the person the contact reports to. $query = "SELECT acc.id, acc.name, con_reports_to.first_name, con_reports_to.last_name\n\t\tfrom contacts\n\t\tleft join accounts_contacts a_c on a_c.contact_id = '" . $this->id . "' and a_c.deleted=0\n\t\tleft join accounts acc on a_c.account_id = acc.id and acc.deleted=0\n\t\tleft join contacts con_reports_to on con_reports_to.id = contacts.reports_to_id\n\t\twhere contacts.id = '" . $this->id . "'"; $result = $this->db->query($query, true, " Error filling in additional detail fields: "); // Get the id and the name. $row = $this->db->fetchByAssoc($result); if ($row != null) { $this->account_name = $row['name']; $this->account_id = $row['id']; $this->report_to_name = $row['first_name'] . ' ' . $row['last_name']; } else { $this->account_name = ''; $this->account_id = ''; $this->report_to_name = ''; } $this->load_contacts_users_relationship(); /** concating this here because newly created Contacts do not have a * 'name' attribute constructed to pass onto related items, such as Tasks * Notes, etc. */ $this->name = $locale->getLocaleFormattedName($this->first_name, $this->last_name); if (!empty($this->contacts_users_id)) { $this->sync_contact = true; } if (!empty($this->portal_active) && $this->portal_active == 1) { $this->portal_active = true; } // Set campaign name if there is a campaign id if (!empty($this->campaign_id)) { $camp = new Campaign(); $where = "campaigns.id='{$this->campaign_id}'"; $campaign_list = $camp->get_full_list("campaigns.name", $where, true); $this->campaign_name = $campaign_list[0]->name; } }