PHP QueryBuilder::set方法代码示例

 public function closeSession(ChatSession $session, ChatUser $closerUser, $reason = null)
 {
     $qb = new QueryBuilder();
     $qb->update(Tbl::get('TBL_CHAT_SESSIONS'))->set(new Field('closed'), static::CLOSED_STATUS_YES)->set(new Field('closed_date'), new Func('NOW'))->set(new Field('closed_by'), $closerUser->userId)->where($qb->expr()->equal(new Field('id'), $session->id));
     if ($reason !== null) {
         $qb->set(new Field('closed_reason'), $reason);
         $session->closedReason = $reason;
     }
     $this->query->exec($qb->getSQL());
     $session->closed = static::CLOSED_STATUS_YES;
     $session->closedBy = $closerUser->userId;
 }

 /**
  * Update DB Config
  * @param ConfigDB $oldDBCOnfig
  * @param ConfigDB $newDBConfig
  * @throws InvalidArgumentException
  */
 public static function updateConfigValue(ConfigDB $oldDBCOnfig, ConfigDB $newDBConfig)
 {
     if (empty($oldDBCOnfig) || empty($newDBConfig)) {
         throw new InvalidArgumentException("new or old DB config object is empty");
     }
     if (!isset($oldDBCOnfig->location) or empty($oldDBCOnfig->location)) {
         throw new InvalidArgumentException("odl Location of config should be non empty array");
     }
     if (!isset($newDBConfig->location) or empty($newDBConfig->location)) {
         throw new InvalidArgumentException("New Location of config should be non empty array");
     }
     if (!isset($oldDBCOnfig->name) or empty($oldDBCOnfig->name)) {
         throw new InvalidArgumentException("Old Name of config should be specified");
     }
     if (!isset($newDBConfig->name) or empty($newDBConfig->name)) {
         throw new InvalidArgumentException("New Name of config should be specified");
     }
     if (!isset($newDBConfig->value)) {
         throw new InvalidArgumentException("Value of new config should be specified");
     }
     $odlHostLangid = null;
     if (!empty($oldDBCOnfig->host) && !empty($oldDBCOnfig->language)) {
         $odlHostLangid = HostLanguageManager::getHostLanguageId($oldDBCOnfig->host, $oldDBCOnfig->language);
     }
     $newHostLangId = null;
     if (!empty($newDBConfig->host) && !empty($newDBConfig->language)) {
         $newHostLangId = HostLanguageManager::getHostLanguageId($newDBConfig->host, $newDBConfig->language);
     }
     $sql = MySqlDbManager::getQueryObject();
     $qb = new QueryBuilder();
     $qb->update(Tbl::get("TBL_CONFIGS"))->set(new Field("location"), implode(":", $newDBConfig->location))->set(new Field("name"), $newDBConfig->name)->set(new Field("value"), $newDBConfig->value)->where($qb->expr()->equal(new Field("location"), implode(":", $oldDBCOnfig->location)))->andWhere($qb->expr()->equal(new Field("name"), $oldDBCOnfig->name));
     if ($newHostLangId !== null) {
         $qb->set(new Field("host_lang_id"), $newHostLangId);
     } else {
         $qb->set(new Field("host_lang_id"), new Literal("null"));
     }
     if ($odlHostLangid !== null) {
         $qb->andWhere($qb->expr()->equal(new Field("host_lang_id"), $odlHostLangid));
     } else {
         $qb->andWhere($qb->expr()->isNull(new Field("host_lang_id")));
     }
     $sql->exec($qb->getSQL());
 }

 /**
  * Edit an already created answer option
  *
  * @param integer $profile_id
  * @param string $new_answer
  * @param integer $sort_id
  */
 public function editOptionById($profile_id, $new_answer, $sort_id = null)
 {
     $additional_sql = '';
     $qb = new QueryBuilder();
     $qb->update(Tbl::get('TBL_PROFILE_KEYS'))->set(new Field('value'), $new_answer);
     if (empty($profile_id) or !is_numeric($profile_id)) {
         throw new InvalidArgumentException("\$profile have to be numeric id of the profile");
     }
     if (empty($new_answer)) {
         throw new InvalidArgumentException("\$new_answer have be not null string");
     }
     if (!empty($sort_id) and !is_numeric($sort_id)) {
         throw new InvalidArgumentException("\$sort_id have to have numeric value");
     } else {
         $qb->set(new Field('sort_id'), $sort_id);
         $additional_sql .= ", `sort_id`='{$sort_id}'";
     }
     $qb->where($qb->expr()->equal(new Field('id'), $profile_id));
     $this->query->exec($qb->getSQL());
 }

 /**
  * Change Conversation message deleted status.
  * 
  * Example:
  * 
  * Id1 sends message to Id2
  * Message is not deleted by anyone 	-> deleted = 0
  * Message deleted only by Id1 			-> deleted = Id2
  * Message deleted only by Id2			-> deleted = Id1
  * Message deleted by both				-> deleted = -1
  * 
  * @param integer $conversationMessageId
  * @param integer $myUserId
  * @param integer $status
  * @throws InvalidIntegerArgumentException
  */
 public function changeConversationMessageDeletedStatus($conversationMessageId, $myUserId, $status)
 {
     if (empty($conversationMessageId) or !is_numeric($conversationMessageId)) {
         throw new InvalidIntegerArgumentException("\$conversationMessageId have to be non zero integer.");
     }
     if (!is_numeric($status) or !in_array($status, self::getConstsArray("STATUS_DELETED"))) {
         throw new InvalidIntegerArgumentException("Invalid \$status specified.");
     }
     if (empty($myUserId) or !is_numeric($myUserId)) {
         throw new InvalidIntegerArgumentException("\$myUserId have to be non zero integer.");
     }
     // Get message
     $filter = new ConversationMessagesFilter();
     $filter->setId($conversationMessageId);
     $message = $this->getConversationMessage($filter, true);
     $interlocutorId = null;
     if ($message->senderId == $myUserId) {
         $interlocutorId = $message->receiverId;
     } else {
         $interlocutorId = $message->senderId;
     }
     $finalDeletedStatus = null;
     switch ($status) {
         case self::STATUS_DELETED_YES:
             switch ($message->deleted) {
                 case 0:
                     $finalDeletedStatus = $interlocutorId;
                     break;
                 case -1:
                     $finalDeletedStatus = -1;
                     break;
                 case $myUserId:
                     $finalDeletedStatus = -1;
                     break;
                 case $interlocutorId:
                     $finalDeletedStatus = $interlocutorId;
                     break;
             }
             break;
         case self::STATUS_DELETED_NO:
             switch ($message->deleted) {
                 case 0:
                     $finalDeletedStatus = 0;
                     break;
                 case -1:
                     $finalDeletedStatus = $myUserId;
                     break;
                 case $myUserId:
                     $finalDeletedStatus = $myUserId;
                     break;
                 case $interlocutorId:
                     $finalDeletedStatus = 0;
                     break;
             }
             break;
     }
     // Change read status
     $qb = new QueryBuilder();
     $qb->update(Tbl::get('TBL_CONVERSATION_MESSAGES'))->set(new Field('deleted'), $finalDeletedStatus)->where($qb->expr()->equal(new Field('id'), $message->id));
     if ($status == self::STATUS_DELETED_YES and $message->receiverId == $myUserId) {
         $qb->set(new Field('read'), self::STATUS_READ_READ);
     }
     $affected = $this->query->exec($qb->getSQL())->affected();
     $this->correctConversationReadStatus($message->uuid, $myUserId);
     $this->correctConversationHasAttachment($message->uuid, $myUserId);
     $hookParams = array('type' => 'deletedStatus', 'msgId' => $message->id, 'newStatus' => $finalDeletedStatus);
     HookManager::callHook("ConversationMessageUpdate", $hookParams);
     return $affected;
 }

 /**
  * Updated User Properties
  * 
  * @param UserProperties $properties
  * @return integer Affected
  */
 protected function updateUserProperties(UserProperties $properties)
 {
     if (count($this->config->userPropertiesMap->toArray()) > 0) {
         $qb = new QueryBuilder();
         $qb->update(Tbl::get('TBL_USERS_PROPERTIES'));
         foreach ($this->config->userPropertiesMap as $objectKey => $dbKey) {
             $qb->set(new Field($dbKey), $properties->{$objectKey});
         }
         $qb->where($qb->expr()->equal(new Field('user_id'), $properties->userId));
         return $this->query->exec($qb->getSQL())->affected();
     }
     return 0;
 }