<?php
-/* This file is part of Syj, Copyright (c) 2010 Arnaud Renevier,
+/* This file is part of Syj, Copyright (c) 2010-2011 Arnaud Renevier,
and is published under the AGPL license. */
class Syj_Model_PathMapper
$db = $this->getDbTable()->getAdapter();
$expr = $db->quoteInto('seq_attained_value(?)', array('paths_id_seq', (int)$id));
$select = $db->select()->from(new Zend_Db_Expr($expr));
- print $select->assemble();
$row = $db->fetchRow($select);
return $row['t'];
}
return $this->_fetchItem($select, $path);
}
- public function fetchAll() {
+ public function fetchByCreator(Syj_Model_User $user) {
$select = $this->_select();
+ $select->where('creator = ?', (int)$user->id)->order('id');
+ return $this->fetchAll($select);
+ }
+
+ public function fetchAll(Zend_Db_Table_Select $select) {
+ if (!isset($select)) {
+ $select = $this->_select();
+ }
+ $table = $this->getDbTable();
$resultSet = $table->fetchAll($select);
$entries = array();
}
}
+ public function delete (Syj_Model_Path $path) {
+ $this->getDbTable()->delete(array('id = ?' => $path->getId()));
+ }
+
protected function _itemFromRow(Syj_Model_Path $item, Zend_Db_Table_Row $row) {
$decoder = new gisconverter\WKT();
$geom = $decoder->geomFromText($row->wkt);