Example #1
0
 public function retrieveReferenced(IRecord $record)
 {
     if ($record->getState() === IRecord::STATE_NEW) {
         return array();
     }
     $cls = $this->referencedEntity;
     return $cls::findAll(array($this->column => $record->getPrimary()));
 }
Example #2
0
 public function saveReferenced(IRecord $record, $data)
 {
     $db = $this->mapper->getDb();
     $ids = $db->delete($this->connectingTable)->where("%n = %i", $this->localKey, $record->getPrimary())->execute();
     if (count($data)) {
         $q[] = "insert into [{$this->connectingTable}]";
         foreach ($data as $referencedRecord) {
             $referencedRecord->save();
             $q[] = array($this->localKey => $record->getPrimary(), $this->referencedKey => $referencedRecord->getPrimary());
         }
         $db->query($q);
     }
 }
Example #3
0
 /**
  * Fix order before update
  * @param IRecord record
  */
 public function fixOrderBeforeUpdate(IRecord $record)
 {
     if ($record->isValueModified($this->orderColumn) || isset($this->groupColumn) && $record->isValueModified($this->groupColumn)) {
         $original = $record->find($record->getPrimary());
         $columns[] = $this->orderColumn;
         if (isset($this->groupColumn)) {
             $columns[] = $this->groupColumn;
         }
         $original->loadValues($columns);
         $db = $record->getMapper()->getDb();
         $fluent = $db->update($record->getMapper()->getTable(), array($this->orderColumn . "%sql" => array("%n - 1", $this->orderColumn)))->where("%n > %i", $this->orderColumn, $original->{$this->orderColumn});
         if (isset($this->groupColumn)) {
             $type = $record->getConfig()->getType($this->groupColumn);
             $fluent->where("%n = %{$type}", $this->groupColumn, $original->{$this->groupColumn});
         }
         $fluent->execute();
         $fluent = $db->update($record->getMapper()->getTable(), array($this->orderColumn . "%sql" => array("%n + 1", $this->orderColumn)))->where("%n >= %i", $this->orderColumn, $record->{$this->orderColumn});
         if (isset($this->groupColumn)) {
             $fluent->where("%n = %" . $record->getConfig()->getType($this->groupColumn), $this->groupColumn, $record->{$this->groupColumn});
         }
         $fluent->execute();
     }
 }
Example #4
0
 /**
  * Hash specified column with specified hash function
  * @param IRecord $record
  */
 public function hashColumn(IRecord $record)
 {
     if ($record->isValueModified($this->column)) {
         $record->{$this->column} = call_user_func($this->hashFunction, $record->{$this->column});
     }
 }
Example #5
0
 /**
  * Remove cached html from cache if source is modified
  * @param IRecord record
  */
 public function clearCacheIfModified(IRecord $record)
 {
     if ($record->isValueModified($this->source)) {
         $this->clearCache($record);
     }
 }
Example #6
0
 /**
  * Delete record
  * @param IRecord record
  */
 public function delete(IRecord $record)
 {
     try {
         $record->onBeforeDelete($record);
         $this->getDb()->delete($this->table)->where($record->getValues($this->getConfig()->getPrimaryColumns()))->execute();
         // set state
         $record->setState(IRecord::STATE_DELETED);
         $record->onAfterDelete($record);
     } catch (Exception $e) {
         throw new \ModelException("Delete failed. " . $e->getMessage(), $e->getCode(), $e);
     }
 }