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;
}
