public function testRetrieve()
{
$bean = new Contact();
$bean->last_name = 'foobar' . mt_rand();
$bean->id = 'test' . mt_rand();
$this->_db->insert($bean);
$id = $bean->id;
$bean = new Contact();
$result = $this->_db->retrieve($bean, array('id' => $id));
$row = $this->_db->fetchByAssoc($result);
$this->assertEquals($row['id'], $id);
$this->_db->query("delete from contacts where id = '{$id}'");
}
/**
* Save user preference in database
*
* @param array $formParams
* @return boolean
*/
private function saveUserPreference(array $formParams)
{
$preferenceArr = array();
$userID = Utils::getLoggedInUserId();
$preferenceArr[PreferenceKeys::CODE_EDITOR_THEME] = $formParams[PreferenceKeys::CODE_EDITOR_THEME];
$preferenceArr[PreferenceKeys::CODE_EDITOR_SHOW_INVISIBLE] = $formParams[PreferenceKeys::CODE_EDITOR_SHOW_INVISIBLE];
$preferenceArr[PreferenceKeys::PAGINATOR_LIMIT] = (int) $formParams[PreferenceKeys::PAGINATOR_LIMIT];
$content = $this->encodeContents($preferenceArr);
$this->flushAll($userID);
$insertArr = array(UserPreferences_DBTable::RECORD_ID => '', UserPreferences_DBTable::USER_ID => $userID, UserPreferences_DBTable::CONTENTS => $content, UserPreferences_DBTable::CREATED_ON => Utils::getCurrentDatetime(), UserPreferences_DBTable::MODIFIED_ON => Utils::getCurrentDatetime(), UserPreferences_DBTable::IS_DELETED => '0');
$tableName = UserPreferences_DBTable::DB_TABLE_NAME;
if (DBManager::insert($tableName, $insertArr, array())) {
Session::set(Session::SESS_USER_PREF_KEY, $preferenceArr);
return true;
}
return false;
}
/**
* Implements a generic insert and update logic for any SugarBean
* This method only works for subclasses that implement the same variable names.
* This method uses the presence of an id field that is not null to signify and update.
* The id field should not be set otherwise.
*
* @param boolean $check_notify Optional, default false, if set to true assignee of the record is notified via email.
* @todo Add support for field type validation and encoding of parameters.
*/
function save($check_notify = FALSE)
{
$this->in_save = true;
// cn: SECURITY - strip XSS potential vectors
$this->cleanBean();
// This is used so custom/3rd-party code can be upgraded with fewer issues, this will be removed in a future release
$this->fixUpFormatting();
global $timedate;
global $current_user, $action;
$isUpdate = true;
if (empty($this->id)) {
$isUpdate = false;
}
if ($this->new_with_id == true) {
$isUpdate = false;
}
if (empty($this->date_modified) || $this->update_date_modified) {
$this->date_modified = $GLOBALS['timedate']->nowDb();
}
$this->_checkOptimisticLocking($action, $isUpdate);
if (!empty($this->modified_by_name)) {
$this->old_modified_by_name = $this->modified_by_name;
}
if ($this->update_modified_by) {
$this->modified_user_id = 1;
if (!empty($current_user)) {
$this->modified_user_id = $current_user->id;
$this->modified_by_name = $current_user->user_name;
}
}
if ($this->deleted != 1) {
$this->deleted = 0;
}
if (!$isUpdate) {
if (empty($this->date_entered)) {
$this->date_entered = $this->date_modified;
}
if ($this->set_created_by == true) {
// created by should always be this user
$this->created_by = isset($current_user) ? $current_user->id : "";
}
if ($this->new_with_id == false) {
$this->id = create_guid();
}
}
require_once "data/BeanFactory.php";
BeanFactory::registerBean($this->module_name, $this);
if (empty($GLOBALS['updating_relationships']) && empty($GLOBALS['saving_relationships']) && empty($GLOBALS['resavingRelatedBeans'])) {
$GLOBALS['saving_relationships'] = true;
// let subclasses save related field changes
$this->save_relationship_changes($isUpdate);
$GLOBALS['saving_relationships'] = false;
}
if ($isUpdate && !$this->update_date_entered) {
unset($this->date_entered);
}
// call the custom business logic
$custom_logic_arguments['check_notify'] = $check_notify;
$this->call_custom_logic("before_save", $custom_logic_arguments);
unset($custom_logic_arguments);
// If we're importing back semi-colon separated non-primary emails
if ($this->hasEmails() && !empty($this->email_addresses_non_primary) && is_array($this->email_addresses_non_primary)) {
// Add each mail to the account
foreach ($this->email_addresses_non_primary as $mail) {
$this->emailAddress->addAddress($mail);
}
$this->emailAddress->save($this->id, $this->module_dir);
}
if (isset($this->custom_fields)) {
$this->custom_fields->bean = $this;
$this->custom_fields->save($isUpdate);
}
// use the db independent query generator
$this->preprocess_fields_on_save();
//construct the SQL to create the audit record if auditing is enabled.
$auditDataChanges = array();
if ($this->is_AuditEnabled()) {
if ($isUpdate && !isset($this->fetched_row)) {
$GLOBALS['log']->debug('Auditing: Retrieve was not called, audit record will not be created.');
} else {
$auditDataChanges = $this->db->getAuditDataChanges($this);
}
}
$this->_sendNotifications($check_notify);
if ($isUpdate) {
$this->db->update($this);
} else {
$this->db->insert($this);
}
if (!empty($auditDataChanges) && is_array($auditDataChanges)) {
foreach ($auditDataChanges as $change) {
$this->db->save_audit_records($this, $change);
}
}
if (empty($GLOBALS['resavingRelatedBeans'])) {
SugarRelationship::resaveRelatedBeans();
}
// populate fetched row with current bean values
foreach ($auditDataChanges as $change) {
$this->fetched_row[$change['field_name']] = $change['after'];
}
//If we aren't in setup mode and we have a current user and module, then we track
if (isset($GLOBALS['current_user']) && isset($this->module_dir)) {
$this->track_view($current_user->id, $this->module_dir, 'save');
}
$this->call_custom_logic('after_save', '');
//Now that the record has been saved, we don't want to insert again on further saves
$this->new_with_id = false;
$this->in_save = false;
return $this->id;
}
/**
* Implements a generic insert and update logic for any SugarBean
* This method only works for subclasses that implement the same variable names.
* This method uses the presence of an id field that is not null to signify and update.
* The id field should not be set otherwise.
*
* @param boolean $check_notify Optional, default false, if set to true assignee of the record is notified via email.
* @todo Add support for field type validation and encoding of parameters.
*/
function save($check_notify = false)
{
$this->in_save = true;
// cn: SECURITY - strip XSS potential vectors
$this->cleanBean();
// This is used so custom/3rd-party code can be upgraded with fewer issues, this will be removed in a future release
$this->fixUpFormatting();
global $timedate;
global $current_user, $action;
$isUpdate = true;
if (empty($this->id) || !empty($this->new_with_id)) {
$isUpdate = false;
}
if (empty($this->date_modified) || $this->update_date_modified) {
$this->date_modified = $GLOBALS['timedate']->nowDb();
}
$this->_checkOptimisticLocking($action, $isUpdate);
if (!empty($this->modified_by_name)) {
$this->old_modified_by_name = $this->modified_by_name;
}
if ($this->update_modified_by) {
$this->modified_user_id = 1;
if (!empty($current_user)) {
$this->modified_user_id = $current_user->id;
$this->modified_by_name = $current_user->user_name;
}
}
if ($this->deleted != 1) {
$this->deleted = 0;
}
if (!$isUpdate) {
if (empty($this->date_entered)) {
$this->date_entered = $this->date_modified;
}
if ($this->set_created_by == true) {
// created by should always be this user
$this->created_by = isset($current_user) ? $current_user->id : "";
}
if ($this->new_with_id == false) {
$this->id = create_guid();
}
}
// if the module has a team_id field and no team_id is specified, set team_id as the current_user's default team
// currently, the default_team is only enforced in the presentation layer-- this enforces it at the data layer as well
$usedDefaultTeam = false;
if (empty($this->team_id) && isset($this->field_defs['team_id']) && isset($current_user)) {
$this->team_id = $current_user->team_id;
$usedDefaultTeam = true;
}
// if this bean has a currency_id and base_rate, verify that base_rate is set to the correct amount
if (isset($this->field_defs['currency_id']) && isset($this->field_defs['base_rate'])) {
SugarCurrency::verifyCurrencyBaseRateSet($this, $isUpdate);
}
require_once "data/BeanFactory.php";
BeanFactory::registerBean($this);
if (!static::inOperation('saving_related') && static::enterOperation('updating_relationships')) {
// let subclasses save related field changes
$this->save_relationship_changes($isUpdate);
static::leaveOperation('updating_relationships');
}
$this->updateCalculatedFields();
if ($isUpdate && !$this->update_date_entered) {
unset($this->date_entered);
}
// call the custom business logic
$custom_logic_arguments = array('check_notify' => $check_notify, 'isUpdate' => $isUpdate);
$this->call_custom_logic("before_save", $custom_logic_arguments);
unset($custom_logic_arguments);
if (isset($this->custom_fields)) {
$this->custom_fields->bean = $this;
$this->custom_fields->save($isUpdate);
}
//rrs new functionality to check if the team_id is set and the team_set_id is not set,
//then see what we can do about saving to team_set_id. It is important for this code block to be below
//the 'before_save' custom logic hook as that is where workflow is called.
if (isset($this->field_defs['team_id'])) {
if (empty($this->teams)) {
$this->load_relationship('teams');
}
if (!empty($this->teams)) {
//we do not need to the TeamSetLink to update the bean's table here
//since it will be handled below.
$this->teams->save(false, $usedDefaultTeam);
}
}
// use the db independent query generator
$this->preprocess_fields_on_save();
$dataChanges = $this->db->getDataChanges($this);
//construct the SQL to create the audit record if auditing is enabled.
$auditDataChanges = array();
if ($this->is_AuditEnabled()) {
if ($isUpdate && !isset($this->fetched_row)) {
$GLOBALS['log']->debug('Auditing: Retrieve was not called, audit record will not be created.');
} else {
$auditFields = $this->getAuditEnabledFieldDefinitions();
$auditDataChanges = array_intersect_key($dataChanges, $auditFields);
}
}
$this->_sendNotifications($check_notify);
if ($isUpdate) {
$this->db->update($this);
} elseif ($this->db->insert($this)) {
//Now that the record has been saved, we don't want to insert again on further saves
$this->new_with_id = false;
}
if (!empty($auditDataChanges) && is_array($auditDataChanges)) {
foreach ($auditDataChanges as $change) {
$this->db->save_audit_records($this, $change);
}
}
$this->updateRelatedCalcFields();
// populate fetched row with newest changes in the bean
foreach ($dataChanges as $change) {
$this->fetched_row[$change['field_name']] = $change['after'];
}
// the reason we need to skip this is so that any RelatedBeans that are targeted to be saved
// after the delete happens, wait to be saved till them.
if (!static::inOperation('delete')) {
SugarRelationship::resaveRelatedBeans();
}
//rrs - bug 7908
$this->process_workflow_alerts();
//rrs
//If we aren't in setup mode and we have a current user and module, then we track
if (isset($GLOBALS['current_user']) && isset($this->module_dir)) {
$this->track_view($current_user->id, $this->module_dir, 'save');
}
$this->call_custom_logic('after_save', array('isUpdate' => $isUpdate, 'dataChanges' => $dataChanges));
$this->in_save = false;
return $this->id;
}