function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $this->assigned_user_name = get_assigned_user_name($this->assigned_user_id); //$this->total_estimated_effort = $this->_get_total_estimated_effort($this->id); //$this->total_actual_effort = $this->_get_total_actual_effort($this->id); }
/** * @param SugarBean $bean * @param string $user_id * @param string $where * * @return array */ function build_related_list_by_user_id($bean, $user_id, $where) { $bean_id_name = strtolower($bean->object_name) . '_id'; $select = "SELECT {$bean->table_name}.* from {$bean->rel_users_table},{$bean->table_name} "; $auto_where = ' WHERE '; if (!empty($where)) { $auto_where .= $where . ' AND '; } $auto_where .= " {$bean->rel_users_table}.{$bean_id_name}={$bean->table_name}.id AND {$bean->rel_users_table}.user_id='{$user_id}' AND {$bean->table_name}.deleted=0 AND {$bean->rel_users_table}.deleted=0"; $query = $select . $auto_where; $result = $bean->db->query($query, true); $list = []; while ($row = $bean->db->fetchByAssoc($result)) { $row = $bean->convertRow($row); $bean->fetched_row = $row; $bean->fromArray($row); $bean->processed_dates_times = []; $bean->check_date_relationships_load(); $bean->fill_in_additional_detail_fields(); /** * PHP 5+ always treats objects as passed by reference * Need to clone it if we're using 5.0+ * clone() not supported by 4.x */ if (version_compare(phpversion(), "5.0", ">=")) { $newBean = clone $bean; } else { $newBean = $bean; } $list[] = $newBean; } return $list; }
/** * Formats the bean so it is ready to be handed back to the API's client. Certian fields will get extra processing * to make them easier to work with from the client end. * * @param $bean SugarBean The bean you want formatted * @param $fieldList array Which fields do you want formatted and returned (leave blank for all fields) * @param $options array Currently no options are supported * @return array The bean in array format, ready for passing out the API to clients. */ public function formatForApi(SugarBean $bean, array $fieldList = array(), array $options = array()) { // If there was a field list requested and document_revision_id was not // a requested field we will have problems. Set the revision id so that // additional fields like filename get picked up. if (!empty($fieldList) && !in_array('document_revision_id', $fieldList)) { $db = DBManagerFactory::getInstance(); // Get the revision ID so that it can be set into the bean $sql = "SELECT document_revision_id \n FROM {$bean->table_name} \n WHERE id = '{$bean->id}'"; $rs = $db->query($sql); $row = $db->fetchByAssoc($rs); if (isset($row['document_revision_id'])) { // Set the revision and setup everything else for a document that // depends on a revision id, like filename, revision, etc $bean->document_revision_id = $row['document_revision_id']; $bean->fill_in_additional_detail_fields(); } } return parent::formatForApi($bean, $fieldList, $options); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); // Fill in the assigned_user_name $this->assigned_user_name = get_assigned_user_name($this->assigned_user_id); $this->created_by_name = get_assigned_user_name($this->created_by); $this->modified_by_name = get_assigned_user_name($this->modified_user_id); $account_info = $this->getAccount($this->id); $this->account_name = $account_info['account_name']; $this->account_id = $account_info['account_id']; }
function fill_in_additional_detail_fields() { global $locale; parent::fill_in_additional_detail_fields(); if (!empty($this->contact_id)) { $query = "SELECT first_name, last_name FROM contacts "; $query .= "WHERE id='{$this->contact_id}' AND deleted=0"; $result = $this->db->limitQuery($query, 0, 1, true, " Error filling in additional detail fields: "); // Get the contact name. $row = $this->db->fetchByAssoc($result); $GLOBALS['log']->info("additional call fields {$query}"); if ($row != null) { $this->contact_name = $locale->formatName('Contacts', $row); $GLOBALS['log']->debug("Call({$this->id}): contact_name = {$this->contact_name}"); $GLOBALS['log']->debug("Call({$this->id}): contact_id = {$this->contact_id}"); } } if (!isset($this->time_hour_start)) { $this->time_start_hour = intval(substr($this->time_start, 0, 2)); } //if-else if (isset($this->time_minute_start)) { $time_start_minutes = $this->time_minute_start; } else { $time_start_minutes = substr($this->time_start, 3, 5); if ($time_start_minutes > 0 && $time_start_minutes < 15) { $time_start_minutes = "15"; } else { if ($time_start_minutes > 15 && $time_start_minutes < 30) { $time_start_minutes = "30"; } else { if ($time_start_minutes > 30 && $time_start_minutes < 45) { $time_start_minutes = "45"; } else { if ($time_start_minutes > 45) { $this->time_start_hour += 1; $time_start_minutes = "00"; } } } } //if-else } //if-else if (isset($this->time_hour_start)) { $time_start_hour = $this->time_hour_start; } else { $time_start_hour = intval(substr($this->time_start, 0, 2)); } global $timedate; $this->time_meridiem = $timedate->AMPMMenu('', $this->time_start, 'onchange="SugarWidgetScheduler.update_time();"'); $hours_arr = array(); $num_of_hours = 13; $start_at = 1; if (empty($time_meridiem)) { $num_of_hours = 24; $start_at = 0; } //if for ($i = $start_at; $i < $num_of_hours; $i++) { $i = $i . ""; if (strlen($i) == 1) { $i = "0" . $i; } $hours_arr[$i] = $i; } //for if (!isset($this->duration_minutes)) { $this->duration_minutes = $this->minutes_value_default; } //setting default date and time if (is_null($this->date_start)) { $this->date_start = $timedate->now(); } if (is_null($this->time_start)) { $this->time_start = $timedate->to_display_time(TimeDate::getInstance()->nowDb(), true); } if (is_null($this->duration_hours)) { $this->duration_hours = "0"; } if (is_null($this->duration_minutes)) { $this->duration_minutes = "1"; } if (empty($this->id) && !empty($_REQUEST['date_start'])) { $this->date_start = $_REQUEST['date_start']; } if (!empty($this->date_start)) { $td = SugarDateTime::createFromFormat($GLOBALS['timedate']->get_date_time_format(), $this->date_start); if (!empty($td)) { if (!empty($this->duration_hours) && $this->duration_hours != '') { $td = $td->modify("+{$this->duration_hours} hours"); } if (!empty($this->duration_minutes) && $this->duration_minutes != '') { $td = $td->modify("+{$this->duration_minutes} mins"); } $this->date_end = $td->format($GLOBALS['timedate']->get_date_time_format()); } else { $GLOBALS['log']->fatal("Meeting::save: Bad date {$this->date_start} for format " . $GLOBALS['timedate']->get_date_time_format()); } } global $app_list_strings; if (empty($this->reminder_time)) { $this->reminder_time = -1; } if (empty($this->id)) { $reminder_t = $GLOBALS['current_user']->getPreference('reminder_time'); if (isset($reminder_t)) { $this->reminder_time = $reminder_t; } } $this->reminder_checked = $this->reminder_time == -1 ? false : true; if (empty($this->email_reminder_time)) { $this->email_reminder_time = -1; } if (empty($this->id)) { $reminder_t = $GLOBALS['current_user']->getPreference('email_reminder_time'); if (isset($reminder_t)) { $this->email_reminder_time = $reminder_t; } } $this->email_reminder_checked = $this->email_reminder_time == -1 ? false : true; if (isset($_REQUEST['parent_type']) && empty($this->parent_type)) { $this->parent_type = $_REQUEST['parent_type']; } elseif (is_null($this->parent_type)) { $this->parent_type = $app_list_strings['record_type_default_key']; } // Fill in the meeting url for external account types if (!empty($this->id) && !empty($this->type) && $this->type != 'Sugar' && !empty($this->join_url)) { // It's an external meeting global $mod_strings; $meetingLink = ''; if ($GLOBALS['current_user']->id == $this->assigned_user_id) { $meetingLink .= '<a href="index.php?module=Meetings&action=JoinExternalMeeting&meeting_id=' . $this->id . '&host_meeting=1" target="_blank">' . SugarThemeRegistry::current()->getImage("start_meeting_inline", 'border="0" ', 18, 19, ".png", translate('LBL_HOST_EXT_MEETING', $this->module_dir)) . '</a>'; } $meetingLink .= '<a href="index.php?module=Meetings&action=JoinExternalMeeting&meeting_id=' . $this->id . '" target="_blank">' . SugarThemeRegistry::current()->getImage("join_meeting_inline", 'border="0" ', 18, 19, ".png", translate('LBL_JOIN_EXT_MEETING', $this->module_dir)) . '</a>'; $this->displayed_url = $meetingLink; } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); //TODO: Seems odd we need to clear out these values so that list views don't show the previous rows value if current value is blank $this->getRelatedFields('Contacts', $this->contact_id, array('name' => 'contact_name', 'phone_work' => 'contact_phone')); if (!empty($this->contact_name)) { $emailAddress = new SugarEmailAddress(); $this->contact_email = $emailAddress->getPrimaryAddress(false, $this->contact_id, 'Contacts'); } if (isset($this->contact_id) && $this->contact_id != '') { $contact = new Contact(); $contact->retrieve($this->contact_id); if (isset($contact->id)) { $this->contact_name = $contact->full_name; } } }
function fill_in_additional_detail_fields() { global $theme; global $current_language; global $timedate; parent::fill_in_additional_detail_fields(); $mod_strings = return_module_language($current_language, 'KBDocuments'); $query = "SELECT filename,revision,file_ext FROM kbdocument_revisions WHERE id='{$this->kbdocument_revision_id}'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); //popuplate filename $this->filename = $row['filename']; $this->latest_revision = $row['revision']; //populate the file url. //image is selected based on the extension name <ext>_icon_inline, extension is stored in document_revisions. //if file is not found then default image file will be used. global $img_name; global $img_name_bare; if (!empty($row['file_ext'])) { $img_name = SugarThemeRegistry::current()->getImageURL(strtolower($row['file_ext']) . "_image_inline.gif"); $img_name_bare = strtolower($row['file_ext']) . "_image_inline"; } //set default file name. if (!empty($img_name) && file_exists($img_name)) { $img_name = $img_name_bare; } else { $img_name = "def_image_inline"; //todo change the default image. } $this->file_url = "<a href='index.php?entryPoint=download&id={$this->document_revision_id}&type=Documents' target='_blank'>" . SugarThemeRegistry::current()->getImage($img_name, 'border="0"', null, null, '.gif', $mod_strings['LBL_LIST_VIEW_DOCUMENT']) . "</a>"; $this->file_url_noimage = "index.php?entryPoint=download&type=Documents&id={$this->document_revision_id}"; //get last_rev_by user name. $query = "SELECT first_name,last_name, document_revisions.date_entered as rev_date FROM users, document_revisions WHERE users.id = document_revisions.created_by and document_revisions.id = '{$this->document_revision_id}'"; $result = $this->db->query($query, true, "Eror fetching user name: "); $row = $this->db->fetchByAssoc($result); if (!empty($row)) { $this->last_rev_created_name = $row['first_name'] . ' ' . $row['last_name']; $this->last_rev_create_date = $timedate->to_display_date_time($row['rev_date']); } $this->name = $this->kbdocument_name; $this->body = html_entity_decode(KBDocument::get_kbdoc_body_without_incrementing_count($this->id), ENT_COMPAT | ENT_QUOTES, 'UTF-8'); }
function fill_in_additional_detail_fields() { global $theme; global $current_language; global $timedate; global $locale; parent::fill_in_additional_detail_fields(); $mod_strings = return_module_language($current_language, 'Documents'); $query = "SELECT filename,revision,file_ext FROM document_revisions WHERE id='{$this->document_revision_id}'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); //popuplate filename if (isset($row['filename'])) { $this->filename = $row['filename']; } //$this->latest_revision = $row['revision']; if (isset($row['revision'])) { $this->revision = $row['revision']; } //populate the file url. //image is selected based on the extension name <ext>_icon_inline, extension is stored in document_revisions. //if file is not found then default image file will be used. global $img_name; global $img_name_bare; if (!empty($row['file_ext'])) { $img_name = SugarThemeRegistry::current()->getImageURL(strtolower($row['file_ext']) . "_image_inline.gif"); $img_name_bare = strtolower($row['file_ext']) . "_image_inline"; } //set default file name. if (!empty($img_name) && file_exists($img_name)) { $img_name = $img_name_bare; } else { $img_name = "def_image_inline"; //todo change the default image. } if ($this->ACLAccess('DetailView')) { $this->file_url = "<a href='index.php?entryPoint=download&id=" . basename(UploadFile::get_url($this->filename, $this->document_revision_id)) . "&type=Documents' target='_blank'>" . SugarThemeRegistry::current()->getImage($img_name, 'alt="' . $mod_strings['LBL_LIST_VIEW_DOCUMENT'] . '" border="0"') . "</a>"; $this->file_url_noimage = basename(UploadFile::get_url($this->filename, $this->document_revision_id)); } else { $this->file_url = ""; $this->file_url_noimage = ""; } //get last_rev_by user name. $query = "SELECT first_name,last_name, document_revisions.date_entered as rev_date FROM users, document_revisions WHERE users.id = document_revisions.created_by and document_revisions.id = '{$this->document_revision_id}'"; $result = $this->db->query($query, true, "Eror fetching user name: "); $row = $this->db->fetchByAssoc($result); if (!empty($row)) { $this->last_rev_created_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name']); $this->last_rev_create_date = $timedate->to_display_date_time($row['rev_date']); } global $app_list_strings; if (!empty($this->status_id)) { //_pp($this->status_id); $this->status = $app_list_strings['document_status_dom'][$this->status_id]; } $this->related_doc_name = Document::get_document_name($this->related_doc_id); $this->related_doc_rev_number = DocumentRevision::get_document_revision_name($this->related_doc_rev_id); $this->save_file = basename($this->file_url_noimage); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $this->entry_count = $this->get_entry_count(); }
function fill_in_additional_detail_fields() { /* // Fill in the assigned_user_name $this->assigned_user_name = get_assigned_user_name($this->assigned_user_id); */ parent::fill_in_additional_detail_fields(); //$this->created_by_name = get_assigned_user_name($this->created_by); //$this->modified_by_name = get_assigned_user_name($this->modified_user_id); $this->set_release(); $this->set_fixed_in_release(); }
function fill_in_additional_detail_fields() { global $theme; global $current_language; parent::fill_in_additional_detail_fields(); $mod_strings = return_module_language($current_language, 'Documents'); //find the document name and current version. $query = "SELECT document_name, revision, document_revision_id FROM documents, document_revisions where documents.id = '{$this->document_id}' AND document_revisions.id = documents.document_revision_id"; $result = $this->db->query($query, true, "Error fetching document details...:"); $row = $this->db->fetchByAssoc($result); if ($row != null) { $this->document_name = $row['document_name']; $this->latest_revision = $row['revision']; $this->latest_revision_id = $row['document_revision_id']; } //populate the file url. //image is selected based on the extension name <ext>_image_inline, extension is stored in document_revisions. //if file is not found then default image file will be used. global $img_name; global $img_name_bare; if (!empty($this->file_ext)) { $img_name = SugarThemeRegistry::current()->getImageURL("{$this->file_ext}_image_inline.gif"); $img_name_bare = "{$this->file_ext}_image_inline"; } //set default file name. if (!empty($img_name) && file_exists($img_name)) { $img_name = $img_name_bare; } else { $img_name = "def_image_inline"; //todo change the default image. } if ($this->ACLAccess('DetailView')) { $this->file_url = "<a href='" . UploadFile::get_url($this->filename, $this->id) . "' target='_blank'>" . SugarThemeRegistry::current()->getImage($img_name, 'alt="' . $mod_strings['LBL_LIST_VIEW_DOCUMENT'] . '" border="0"') . "</a>"; } else { $this->file_url = ""; } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $this->setCalculatedValues(true); $types = get_bean_select_array(true, 'ContractType', 'name', 'deleted=0', 'list_order'); $this->type_options = get_select_options_with_id($types, $this->type); $currency = BeanFactory::getBean('Currencies'); if (isset($this->currency_id) && !empty($this->currency_id)) { $currency->retrieve($this->currency_id); if ($currency->deleted != 1) { $this->currency_name = $currency->iso4217 . ' ' . $currency->symbol; } else { $this->currency_name = $currency->getDefaultISO4217() . ' ' . $currency->getDefaultCurrencySymbol(); } } else { $this->currency_name = $currency->getDefaultISO4217() . ' ' . $currency->getDefaultCurrencySymbol(); } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); }
/** * Fill in additional details for the detail view */ public function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); //find parent name if parentid is there. if (!empty($this->parent_id) and $this->parent_id != '') { $query = "select name from product_categories where id='{$this->parent_id}'"; $result = $this->db->query($query); if (!empty($result)) { $row = $this->db->fetchByAssoc($result); if (!empty($row)) { $this->parent_name = $row['name']; } } } }
function fill_in_additional_detail_fields() { if ($this->report_type == "Matrix") { $this->report_type = "summary"; } // if parent::fill_in_additional_detail_fields(); $this->get_scheduled_query(); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $query = "SELECT c.first_name, c.last_name, c.phone_work, c.id FROM contacts c, calls_contacts c_c "; $query .= "WHERE c_c.contact_id=c.id AND c_c.call_id='{$this->id}' AND c_c.deleted=0 AND c.deleted=0"; $result = $this->db->limitQuery($query, 0, 1, true, " Error filling in additional detail fields: "); // Get the id and the name. $row = array(); $row = $this->db->fetchByAssoc($result); $GLOBALS['log']->info("additional call fields {$query}"); if ($row != null) { $this->contact_name = return_name($row, 'first_name', 'last_name'); $this->contact_phone = $row['phone_work']; $this->contact_id = $row['id']; $GLOBALS['log']->debug("Call({$this->id}): contact_name = {$this->contact_name}"); $GLOBALS['log']->debug("Call({$this->id}): contact_phone = {$this->contact_phone}"); $GLOBALS['log']->debug("Call({$this->id}): contact_id = {$this->contact_id}"); } else { $this->contact_name = ''; $this->contact_phone = ''; $this->contact_id = ''; $GLOBALS['log']->debug("Call({$this->id}): contact_name = {$this->contact_name}"); $GLOBALS['log']->debug("Call({$this->id}): contact_phone = {$this->contact_phone}"); $GLOBALS['log']->debug("Call({$this->id}): contact_id = {$this->contact_id}"); } if (!isset($this->duration_minutes)) { $this->duration_minutes = $this->minutes_value_default; } global $timedate; //setting default date and time if (is_null($this->date_start)) { $this->date_start = $timedate->to_display_date_time(gmdate($GLOBALS['timedate']->get_db_date_time_format())); } if (is_null($this->duration_hours)) { $this->duration_hours = "0"; } if (is_null($this->duration_minutes)) { $this->duration_minutes = "1"; } $this->fill_in_additional_parent_fields(); global $app_list_strings; $parent_types = $app_list_strings['record_type_display']; $disabled_parent_types = ACLController::disabledModuleList($parent_types, false, 'list'); foreach ($disabled_parent_types as $disabled_parent_type) { if ($disabled_parent_type != $this->parent_type) { unset($parent_types[$disabled_parent_type]); } } $this->parent_type_options = get_select_options_with_id($parent_types, $this->parent_type); if (empty($this->reminder_time)) { $this->reminder_time = -1; } $this->reminder_checked = $this->reminder_time == -1 ? false : true; if (isset($_REQUEST['parent_type'])) { $this->parent_type = $_REQUEST['parent_type']; } elseif (is_null($this->parent_type)) { $this->parent_type = $app_list_strings['record_type_default_key']; } }
public function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); if (!empty($this->id)) { $this->set_account(); $this->set_contact(); $this->set_opportunity(); } if (!empty($this->currency_id)) { $currency = BeanFactory::getBean('Currencies', $this->currency_id); if ($currency->id != $this->currency_id || $currency->deleted == 1) { $this->tax = $this->tax_usdollar; $this->total = $this->total_usdollar; $this->subtotal = $this->subtotal_usdollar; $this->shipping = $this->shipping_usdollar; $this->currency_id = $currency->id; } } if (!empty($this->shipper_id)) { $this->set_shipper(); } if (!empty($this->taxrate_id)) { $this->set_taxrate_info(); } }
function fill_in_additional_detail_fields() { global $theme; global $current_language; global $timedate; global $locale; parent::fill_in_additional_detail_fields(); $mod_strings = return_module_language($current_language, 'Documents'); if (!empty($this->document_revision_id)) { $query = "SELECT users.first_name AS first_name, users.last_name AS last_name, document_revisions.date_entered AS rev_date,\n \t document_revisions.filename AS filename, document_revisions.revision AS revision,\n \t document_revisions.file_ext AS file_ext, document_revisions.file_mime_type AS file_mime_type\n \t FROM users, document_revisions\n \t WHERE users.id = document_revisions.created_by AND document_revisions.id = '{$this->document_revision_id}'"; $result = $this->db->query($query); $row = $this->db->fetchByAssoc($result); //populate name if (isset($this->document_name)) { $this->name = $this->document_name; } if (isset($row['filename'])) { $this->filename = $row['filename']; } //$this->latest_revision = $row['revision']; if (isset($row['revision'])) { $this->revision = $row['revision']; } //image is selected based on the extension name <ext>_icon_inline, extension is stored in document_revisions. //if file is not found then default image file will be used. global $img_name; global $img_name_bare; if (!empty($row['file_ext'])) { $img_name = SugarThemeRegistry::current()->getImageURL(strtolower($row['file_ext']) . "_image_inline.gif"); $img_name_bare = strtolower($row['file_ext']) . "_image_inline"; } } //set default file name. if (!empty($img_name) && file_exists($img_name)) { $img_name = $img_name_bare; } else { $img_name = "def_image_inline"; //todo change the default image. } if ($this->ACLAccess('DetailView')) { if (!empty($this->doc_type) && $this->doc_type != 'Sugar' && !empty($this->doc_url)) { $file_url = "<a href='" . $this->doc_url . "' target='_blank'>" . SugarThemeRegistry::current()->getImage($this->doc_type . '_image_inline', 'border="0"', null, null, '.png', $mod_strings['LBL_LIST_VIEW_DOCUMENT']) . "</a>"; } else { $file_url = "<a href='index.php?entryPoint=download&id={$this->document_revision_id}&type=Documents' target='_blank'>" . SugarThemeRegistry::current()->getImage($img_name, 'border="0"', null, null, '.gif', $mod_strings['LBL_LIST_VIEW_DOCUMENT']) . "</a>"; } $this->file_url = $file_url; $this->file_url_noimage = "index.php?entryPoint=download&type=Documents&id={$this->document_revision_id}"; } else { $this->file_url = ""; $this->file_url_noimage = ""; } //get last_rev_by user name. if (!empty($row)) { $this->last_rev_created_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name']); $this->last_rev_create_date = $timedate->to_display_date_time($this->db->fromConvert($row['rev_date'], 'datetime')); $this->last_rev_mime_type = $row['file_mime_type']; } global $app_list_strings; if (!empty($this->status_id)) { //_pp($this->status_id); $this->status = $app_list_strings['document_status_dom'][$this->status_id]; } if (!empty($this->related_doc_id)) { $this->related_doc_name = Document::get_document_name($this->related_doc_id); $this->related_doc_rev_number = DocumentRevision::get_document_revision_name($this->related_doc_rev_id); } }
/** * Formats the bean so it is ready to be handed back to the API's client. Certain fields will get extra processing * to make them easier to work with from the client end. * * @param $quote SugarBean|Quote The bean you want formatted * @param $fieldList array Which fields do you want formatted and returned (leave blank for all fields) * @param $options array Currently no options are supported * @return array The bean in array format, ready for passing out the API to clients. */ public function formatForApi(SugarBean $quote, array $fieldList = array(), array $options = array()) { // call the legacy method here to load all the data that we need $quote->fill_in_additional_detail_fields(); return parent::formatForApi($quote, $fieldList, $options); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $this->get_custom_query(); $this->get_parent_dataset(); $this->get_report_name(); $this->get_child_dataset(); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); if (!empty($this->currency_id)) { $currency = new Currency(); $currency->retrieve($this->currency_id); if ($currency->id != $this->currency_id || $currency->deleted == 1) { $this->amount = $this->amount_usdollar; $this->currency_id = $currency->id; } } //get campaign name if (!empty($this->campaign_id)) { $camp = new Campaign(); $camp->retrieve($this->campaign_id); $this->campaign_name = $camp->name; } $this->account_name = ''; $this->account_id = ''; if (!empty($this->id)) { $ret_values = Opportunity::get_account_detail($this->id); if (!empty($ret_values)) { $this->account_name = $ret_values['name']; $this->account_id = $ret_values['id']; $this->account_id_owner = $ret_values['assigned_user_id']; } } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $this->project_name = $this->_get_project_name($this->project_id); $this->resource_name = $this->getResourceName(); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); //format numbers. //don't need additional formatting here. //$this->budget=format_number($this->budget); //$this->expected_cost=format_number($this->expected_cost); //$this->actual_cost=format_number($this->actual_cost); //$this->expected_revenue=format_number($this->expected_revenue); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); if ($this->report_module != '') { //$sqlArray = $this->build_sql_string(); //$this->sql_statement = $sqlArray['select'] . ' ' . $sqlArray['from'] . ' ' . $sqlArray['where'] . ' ' . $sqlArray['groupby'] . ' ' . $sqlArray['orderby'] ; } }
function fill_in_additional_detail_fields() { global $locale; parent::fill_in_additional_detail_fields(); if (!empty($this->contact_id)) { $query = "SELECT first_name, last_name FROM contacts "; $query .= "WHERE id='$this->contact_id' AND deleted=0"; $result = $this->db->limitQuery($query,0,1,true," Error filling in additional detail fields: "); // Get the contact name. $row = $this->db->fetchByAssoc($result); $GLOBALS['log']->info("additional call fields $query"); if($row != null) { $this->contact_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name'], '', ''); $GLOBALS['log']->debug("Call($this->id): contact_name = $this->contact_name"); $GLOBALS['log']->debug("Call($this->id): contact_id = $this->contact_id"); } } if (!isset($this->duration_minutes)) { $this->duration_minutes = $this->minutes_value_default; } global $timedate; //setting default date and time if (is_null($this->date_start)) { $this->date_start = $timedate->now(); } if (is_null($this->duration_hours)) $this->duration_hours = "0"; if (is_null($this->duration_minutes)) $this->duration_minutes = "1"; $this->fill_in_additional_parent_fields(); global $app_list_strings; $parent_types = $app_list_strings['record_type_display']; $disabled_parent_types = ACLController::disabledModuleList($parent_types,false, 'list'); foreach($disabled_parent_types as $disabled_parent_type){ if($disabled_parent_type != $this->parent_type){ unset($parent_types[$disabled_parent_type]); } } $this->parent_type_options = get_select_options_with_id($parent_types, $this->parent_type); if (empty($this->reminder_time)) { $this->reminder_time = -1; } if ( empty($this->id) ) { $reminder_t = $GLOBALS['current_user']->getPreference('reminder_time'); if ( isset($reminder_t) ) $this->reminder_time = $reminder_t; } $this->reminder_checked = $this->reminder_time == -1 ? false : true; if (empty($this->email_reminder_time)) { $this->email_reminder_time = -1; } if(empty($this->id)){ $reminder_t = $GLOBALS['current_user']->getPreference('email_reminder_time'); if(isset($reminder_t)) $this->email_reminder_time = $reminder_t; } $this->email_reminder_checked = $this->email_reminder_time == -1 ? false : true; if (isset ($_REQUEST['parent_type']) && (!isset($_REQUEST['action']) || $_REQUEST['action'] != 'SubpanelEdits')) { $this->parent_type = $_REQUEST['parent_type']; } elseif (is_null($this->parent_type)) { $this->parent_type = $app_list_strings['record_type_default_key']; } }
function fill_in_additional_detail_fields() { if (empty($this->body) && !empty($this->body_html)) { global $sugar_config; $this->body = strip_tags(html_entity_decode($this->body_html, ENT_COMPAT, $sugar_config['default_charset'])); } parent::fill_in_additional_detail_fields(); }
function fill_in_additional_detail_fields() { global $theme; global $current_language; parent::fill_in_additional_detail_fields(); if (empty($this->id) && empty($this->document_id) && isset($_REQUEST['return_id']) && !empty($_REQUEST['return_id'])) { $this->document_id = $_REQUEST['return_id']; } //find the document name and current version. $query = "SELECT document_name, revision, document_revision_id FROM documents, document_revisions where documents.id = '" . $this->db->quote($this->document_id) . "' AND document_revisions.id = documents.document_revision_id"; $result = $this->db->query($query, true, "Error fetching document details...:"); $row = $this->db->fetchByAssoc($result); if ($row != null) { $this->document_name = $row['document_name']; $this->document_name = '<a href="index.php?module=Documents&action=DetailView&record=' . $this->document_id . '">' . $row['document_name'] . '</a>'; $this->latest_revision = $row['revision']; $this->latest_revision_id = $row['document_revision_id']; if (empty($this->revision)) { $this->revision = $this->latest_revision + 1; } } }
function fill_in_additional_detail_fields() { global $locale; parent::fill_in_additional_detail_fields(); if (!empty($this->contact_id)) { $query = "SELECT first_name, last_name FROM contacts "; $query .= "WHERE id='{$this->contact_id}' AND deleted=0"; $result = $this->db->limitQuery($query, 0, 1, true, " Error filling in additional detail fields: "); // Get the contact name. $row = $this->db->fetchByAssoc($result); $GLOBALS['log']->info("additional call fields {$query}"); if ($row != null) { $this->contact_name = $locale->formatName('Contacts', $row); $GLOBALS['log']->debug("Call({$this->id}): contact_name = {$this->contact_name}"); $GLOBALS['log']->debug("Call({$this->id}): contact_id = {$this->contact_id}"); } } if (!isset($this->duration_minutes)) { $this->duration_minutes = $this->minutes_value_default; } global $timedate; //setting default date and time if (is_null($this->date_start)) { $this->date_start = $timedate->now(); } if (is_null($this->duration_hours)) { $this->duration_hours = "0"; } if (is_null($this->duration_minutes)) { $this->duration_minutes = "1"; } $this->fill_in_additional_parent_fields(); global $app_list_strings; if (empty($this->reminder_time)) { $this->reminder_time = -1; } if (empty($this->id)) { $reminder_t = $GLOBALS['current_user']->getPreference('reminder_time'); if (isset($reminder_t)) { $this->reminder_time = $reminder_t; } } $this->reminder_checked = $this->reminder_time == -1 ? false : true; if (empty($this->email_reminder_time)) { $this->email_reminder_time = -1; } if (empty($this->id)) { $reminder_t = $GLOBALS['current_user']->getPreference('email_reminder_time'); if (isset($reminder_t)) { $this->email_reminder_time = $reminder_t; } } $this->email_reminder_checked = $this->email_reminder_time == -1 ? false : true; if (isset($_REQUEST['parent_type']) && (!isset($_REQUEST['action']) || $_REQUEST['action'] != 'SubpanelEdits')) { $this->parent_type = $_REQUEST['parent_type']; } elseif (is_null($this->parent_type)) { $this->parent_type = $app_list_strings['record_type_default_key']; } }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); global $app_strings; if (isset($this->contact_id)) { $contact = new Contact(); $contact->retrieve($this->contact_id); if ($contact->id != "") { $this->contact_name = $contact->full_name; $this->contact_name_owner = $contact->assigned_user_id; $this->contact_name_mod = 'Contacts'; $this->contact_phone = $contact->phone_work; $this->contact_email = $contact->emailAddress->getPrimaryAddress($contact); } else { $this->contact_name_mod = ''; $this->contact_name_owner = ''; $this->contact_name = ''; $this->contact_email = ''; $this->contact_id = ''; } } $this->fill_in_additional_parent_fields(); }
function fill_in_additional_detail_fields() { parent::fill_in_additional_detail_fields(); $this->get_scheduled_query(); }