Пример #1
0
 /**
  * Get object by unique field
  *
  * @param string $fieldName
  * @param string $value
  * @param array $fields - optional
  * @throws Exception
  * @return array
  */
 public function getItemByUniqueField($fieldName, $value, $fields = '*')
 {
     if (!$this->_objectConfig->isUnique($fieldName)) {
         $eText = 'getItemByUniqueField field "' . $fieldName . '" [' . $this->_objectConfig->getName() . '] should be unique';
         $this->logError($eText);
         throw new Exception($eText);
     }
     $sql = $this->_dbSlave->select()->from($this->table(), $fields);
     $sql->where($this->_dbSlave->quoteIdentifier($fieldName) . ' = ?', $value);
     return $this->_dbSlave->fetchRow($sql);
 }
Пример #2
0
 /**
  * Remove object
  *
  * @param string $name
  * @return boolean
  */
 public function remove()
 {
     if ($this->_objectConfig->isLocked() || $this->_objectConfig->isReadOnly()) {
         $this->_errors[] = 'Can not remove locked object table ' . $this->_objectConfig->getName();
         return false;
     }
     try {
         $model = Model::factory($this->_objectName);
         if (!$this->tableExists()) {
             return true;
         }
         $sql = 'DROP TABLE `' . $model->table() . '`';
         $model->getDbConnection()->query($sql);
         $this->_logSql($sql);
         return true;
     } catch (Exception $e) {
         $this->_errors[] = $e->getMessage() . ' <br>SQL: ' . $sql;
         return false;
     }
 }
Пример #3
0
 /**
  * Save changes
  * @param boolean $log  - log changes
  * @param boolean $useTransaction — using a transaction when changing data is optional.
  * If data update in your code is carried out within an external transaction
  * set the value to  false,
  * otherwise, the first update will lead to saving the changes
  * @return boolean;
  */
 public function save($log = true, $useTransaction = true)
 {
     if ($this->_acl) {
         try {
             $this->_checkCanEdit();
         } catch (Exception $e) {
             $this->_errors[] = $e->getMessage();
             if (self::$_log) {
                 self::$_log->log($e->getMessage());
             }
             return false;
         }
     }
     $store = $this->_model->getStore();
     if (self::$_log) {
         $store->setLog(self::$_log);
     }
     if ($this->_config->isReadOnly()) {
         $text = 'ORM :: cannot save readonly object ' . $this->_config->getName();
         $this->_errors[] = $text;
         if (self::$_log) {
             self::$_log->log($text);
         }
         return false;
     }
     if ($this->_config->hasEncrypted()) {
         $ivField = $this->_config->getIvField();
         $ivData = $this->get($ivField);
         if (empty($ivData)) {
             $this->set($ivField, base64_encode($this->_config->createIv()));
         }
     }
     $emptyFields = $this->_hasRequired();
     if ($emptyFields !== true) {
         $text = 'ORM :: Fields can not be empty. ' . $this->getName() . ' [' . implode(',', $emptyFields) . ']';
         $this->_errors[] = $text;
         if (self::$_log) {
             self::$_log->log($text);
         }
         return false;
     }
     $values = $this->validateUniqueValues();
     if (!empty($values)) {
         foreach ($values as $k => $v) {
             $text = 'The Field value should be unique ' . $k . ':' . $v;
             $this->_errors[] = $text;
         }
         if (self::$_log) {
             self::$_log->log($this->getName() . ' ' . implode(', ', $this->_errors));
         }
         return false;
     }
     try {
         if (!$this->getId()) {
             if ($this->_config->isRevControl()) {
                 $this->date_created = date('Y-m-d H:i:s');
                 $this->date_updated = date('Y-m-d H:i:s');
                 $this->author_id = User::getInstance()->id;
             }
             $id = $store->insert($this, $log, $useTransaction);
             $this->setId($id);
             $this->commitChanges();
             return (int) $id;
         } else {
             if ($this->_config->isRevControl()) {
                 $this->date_updated = date('Y-m-d H:i:s');
                 $this->editor_id = User::getInstance()->getId();
             }
             $id = (int) $store->update($this, $log, $useTransaction);
             $this->commitChanges();
             return $id;
         }
     } catch (Exception $e) {
         $this->_errors[] = $e->getMessage();
         if (self::$_log) {
             self::$_log->log($e->getMessage());
         }
         return false;
     }
 }