function get_list_view_data() { $ret_array = parent::get_list_view_array(); if (!empty($ret_array['STATUS']) && $ret_array['STATUS'] > 0) { $ret_array['STATUS'] = '<input type="checkbox" class="checkbox" style="checkbox" checked disabled>'; } else { $ret_array['STATUS'] = '<input type="checkbox" class="checkbox" style="checkbox" disabled>'; } if (strlen($ret_array['URL']) > 63) { $ret_array['URL'] = substr($ret_array['URL'], 0, 50) . '...' . substr($ret_array['URL'], -10); } $ret_array['CREATED_BY'] = get_assigned_user_name($this->created_by); $ret_array['PLACEMENT'] = translate('DROPDOWN_PLACEMENT', 'iFrames', $ret_array['PLACEMENT']); $ret_array['TYPE'] = translate('DROPDOWN_TYPE', 'iFrames', $ret_array['TYPE']); return $ret_array; }
function get_list_view_data() { global $locale, $current_user; $temp_array = parent::get_list_view_array(); $related_type = $temp_array['RELATED_TYPE']; $related_id = $temp_array['RELATED_ID']; $is_person = SugarModule::get($related_type)->moduleImplements('Person'); if ($is_person) { $query = "SELECT first_name, last_name FROM " . strtolower($related_type) . " WHERE id ='" . $related_id . "'"; } else { $query = "SELECT name FROM " . strtolower($related_type) . " WHERE id ='" . $related_id . "'"; } $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); if ($row) { $temp_array['RECIPIENT_NAME'] = $is_person ? $locale->getLocaleFormattedName($row['first_name'], $row['last_name'], '') : $row['name']; } //also store the recipient_email address $query = "SELECT addr.email_address FROM email_addresses addr,email_addr_bean_rel eb WHERE eb.deleted=0 AND addr.id=eb.email_address_id AND bean_id ='" . $related_id . "' AND primary_address = '1'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); if ($row) { $temp_array['RECIPIENT_EMAIL'] = $row['email_address']; } $this->email1 = $temp_array['RECIPIENT_EMAIL']; $temp_array['EMAIL1_LINK'] = $current_user->getEmailLink('email1', $this, '', '', 'ListView'); return $temp_array; }
function get_list_view_data() { global $locale; $temp_array = parent::get_list_view_array(); $query = "select first_name, last_name from " . strtolower($temp_array['RELATED_TYPE']) . " where id ='" . $temp_array['RELATED_ID'] . "'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); if ($row) { $full_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name'], ''); $temp_array['RECIPIENT_NAME'] = $full_name; } //also store the recipient_email address $query = "select addr.email_address from email_addresses addr,email_addr_bean_rel eb where eb.deleted=0 and addr.id=eb.email_address_id and bean_id ='" . $temp_array['RELATED_ID'] . "' and primary_address = '1'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); if ($row) { $temp_array['RECIPIENT_EMAIL'] = $row['email_address']; } return $temp_array; }
function get_list_view_data() { global $locale, $current_user; $temp_array = parent::get_list_view_array(); $related_type = $temp_array['RELATED_TYPE']; $related_type = strtolower($related_type); $related_type = ucfirst($related_type); $related_id = $temp_array['RELATED_ID']; $related_bean = BeanFactory::getBean($related_type, $related_id); if ($related_bean) { $temp_array['RECIPIENT_NAME'] = $related_bean->get_summary_text(); } //also store the recipient_email address $query = "SELECT addr.email_address FROM email_addresses addr,email_addr_bean_rel eb WHERE eb.deleted=0 AND addr.id=eb.email_address_id AND bean_id ='" . $related_id . "' AND primary_address = '1'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); if ($row) { $temp_array['RECIPIENT_EMAIL'] = $row['email_address']; } $this->email1 = $temp_array['RECIPIENT_EMAIL']; $temp_array['EMAIL_LINK'] = $current_user->getEmailLink('email1', $this, '', '', 'ListView'); return $temp_array; }