diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2014-10-28 07:52:48 +0100 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2014-10-28 07:52:48 +0100 |
| commit | 35e58ea1056480418d36b08a98f288d583805b23 (patch) | |
| tree | ab13482bc05f7a789da473e21cd9b4894de27dc8 | |
| parent | a08e22a70ba0348be063c999a2cf8a405cba0379 (diff) | |
| download | grauphel-35e58ea1056480418d36b08a98f288d583805b23.tar.gz grauphel-35e58ea1056480418d36b08a98f288d583805b23.zip | |
show last note modification date
| -rw-r--r-- | controller/guicontroller.php | 2 | ||||
| -rw-r--r-- | lib/notestorage.php | 21 | ||||
| -rw-r--r-- | templates/tag.php | 1 |
3 files changed, 16 insertions, 8 deletions
diff --git a/controller/guicontroller.php b/controller/guicontroller.php index d186207..6fffcb2 100644 --- a/controller/guicontroller.php +++ b/controller/guicontroller.php @@ -149,7 +149,7 @@ class GuiController extends Controller */ public function tag($rawtag) { - $notes = $this->getNotes()->loadNotesOverview(null, $rawtag); + $notes = $this->getNotes()->loadNotesOverview(null, $rawtag, true); usort( $notes, function($noteA, $noteB) { diff --git a/lib/notestorage.php b/lib/notestorage.php index 6802e2f..621d120 100644 --- a/lib/notestorage.php +++ b/lib/notestorage.php @@ -386,17 +386,20 @@ class NoteStorage * Load notes for the given user in short form. * Optionally only those changed after $since revision * - * @param integer $since Revision number after which the notes changed - * @param string $rawtag Filter by tag. Special tags: - * - grauphel:special:all - * - grauphel:special:untagged + * @param integer $since Revision number after which the notes changed + * @param string $rawtag Filter by tag. Special tags: + * - grauphel:special:all + * - grauphel:special:untagged + * @param boolean $includeDate Load the last modification date or not * * @return array Array of short note objects */ - public function loadNotesOverview($since = null, $rawtag = null) - { + public function loadNotesOverview( + $since = null, $rawtag = null, $includeDate = false + ) { $result = \OC_DB::executeAudited( 'SELECT `note_guid`, `note_title`, `note_last_sync_revision`, `note_tags`' + . ', `note_last_change_date`' . ' FROM `*PREFIX*grauphel_notes`' . ' WHERE note_user = ?', array($this->username) @@ -417,7 +420,7 @@ class NoteStorage if ($rawtag !== null && strpos($row['note_tags'], $jsRawtag) === false) { continue; } - $notes[] = array( + $note = array( 'guid' => $row['note_guid'], 'ref' => array( 'api-ref' => $this->urlGen->getAbsoluteURL( @@ -433,6 +436,10 @@ class NoteStorage ), 'title' => $row['note_title'], ); + if ($includeDate) { + $note['last-change-date'] = $row['note_last_change_date']; + } + $notes[] = $note; } return $notes; diff --git a/templates/tag.php b/templates/tag.php index 850b034..b2cab02 100644 --- a/templates/tag.php +++ b/templates/tag.php @@ -21,6 +21,7 @@ <a class="cellclick" href="<?php p(OCP\Util::linkToRoute('grauphel.gui.note', array('guid' => $note['guid']))); ?>"><?php echo ($note['title']); ?></a> </td> <td> + <?php p(\OCP\Util::formatDate(strtotime($note['last-change-date']))); ?> </td> </tr> <?php } ?> |