function fill_in_additional_detail_fields()
{
// jmorais@dri Bug #56269
parent::fill_in_additional_detail_fields();
// ~jmorais@dri
global $locale;
$query = "SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '{$this->id}' and u1.deleted=0";
$result = $this->db->query($query, true, "Error filling in additional detail fields");
$row = $this->db->fetchByAssoc($result);
if ($row != null) {
$this->reports_to_name = stripslashes($row['first_name'] . ' ' . $row['last_name']);
} else {
$this->reports_to_name = '';
}
$this->_create_proper_name_field();
}
function fill_in_additional_detail_fields()
{
global $locale;
$query = "SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '{$this->id}' and u1.deleted=0";
$result = $this->db->query($query, true, "Error filling in additional detail fields");
$row = $this->db->fetchByAssoc($result);
if ($row != null) {
$this->reports_to_name = $locale->formatName($this->module_name, $row);
} else {
$this->reports_to_name = '';
}
parent::fill_in_additional_detail_fields();
}
function fill_in_additional_detail_fields()
{
// jmorais@dri Bug #56269
parent::fill_in_additional_detail_fields();
// ~jmorais@dri
global $locale;
$query = "SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '{$this->id}' and u1.deleted=0";
$result = $this->db->query($query, true, "Error filling in additional detail fields");
$row = $this->db->fetchByAssoc($result);
if ($row != null) {
global $locale;
$this->reports_to_name = $locale->formatName('Users', $row);
} else {
$this->reports_to_name = '';
}
// Must set team_id for team widget purposes (default_team is primary team id)
if (empty($this->team_id)) {
$this->team_id = $this->default_team;
}
//set the team info if the team id has already been set.
//running only if team class exists will prevent breakage during upgrade/flavor conversions
if (class_exists('Team')) {
// Set default_team_name for Campaigns WebToLeadCreation
$this->default_team_name = Team::getTeamName($this->team_id);
} else {
//if no team id exists, set the team info to blank
$this->default_team = '';
$this->default_team_name = '';
$this->team_set_id = '';
}
$this->_create_proper_name_field();
}
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()
{
global $locale;
parent::fill_in_additional_detail_fields();
$full_name = $locale->getLocaleFormattedName($this->first_name, $this->last_name, $this->salutation, $this->title);
$this->name = $full_name;
$this->full_name = $full_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();
$this->_create_proper_name_field();
$this->get_contact();
$this->get_opportunity();
$this->get_account();
if (!empty($this->campaign_id)) {
$camp = BeanFactory::getBean('Campaigns');
$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();
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;
}
}
