PHP DBManager::insert方法代码示例

 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) {
//.........这里部分代码省略.........

//.........这里部分代码省略.........
         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;
 }