show last note modification date

diff --git a/controller/guicontroller.php b/controller/guicontroller.php
index d186207105d82879332503e8a77f61a507b26cab..6fffcb2f7377db128d076d395e94d10156661c5b 100644 (file)
--- 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 6802e2f88a481d8e18ef331f672ec2998b5b8f9d..621d12062979c35ed2e193b82903d47f6f853a7b 100644 (file)
--- 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 850b03450289f7ea992ca7046368b36d497fa26d..b2cab023431375b005384020beb270bd9a125cb0 100644 (file)
--- 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 } ?>