1. Laurence Brevard
  2. Wishlist
  3. Friday, 14 February 2014
  4.  Subscribe via email
When there are multiple notes on a page, the newest is at the bottom.
How can I reverse this order so the newest is on top?
Responses (2)
Accepted Answer Pending Moderation
Ordering of your notes can be accomplished by changing the file mod_cnotes/helper.php .
Change lines 23-25 from
$query->select('*')->from('#__cnotes_notes')
->where('created_by = ' . $db->quote($user->id))
->where('url = ' . $db->quote(self::getUrl()));

to
$query->select('*')->from('#__cnotes_notes')
->where('created_by = ' . $db->quote($user->id))
->where('url = ' . $db->quote(self::getUrl()))
->order('id DESC');


Only drawback: the new ordering only will be visible after a 'hard' page refresh, so not immediately after adding a new note.

Regards
Gerlof
  1. more than a month ago
  2. Wishlist
  3. # 1
Accepted Answer Pending Moderation
Thanks for the pointer.
I had already done the equivalent by traversing the list using [color=#bb0000]array_reverse[/color] when writing the on-page notes list.
This has the same behavior as changing the query, including that a new note is not at the top until revisiting the page.
in .../modules/mod_cnotes/tmpl/default.php

...
<div class="cnotes-notes">
<?php if (count($items)) : ?>
<?php $items = array_reverse( $items ); ?>
<?php foreach ($items as $item) : ?>
<div>
<span class="title">
<a href="/<?php echo JRoute::_('index.php?option=com_cnotes&task=note.edit&id=' . $item->id); ?>">
<?php echo $item->title; ?>
</a>
</span>
<?php echo $item->note; ?>
</div>
<?php endforeach; ?>
<?php else : ?>
<span class="cnotes-nothing">
<?php echo JText::_('MOD_CNOTES_NO_NOTES'); ?>
</span>
<?php endif; ?>
</div>
...


I have made several other changes including a bug fix on the page that writes out all your notes:
components/com_cnotes/views/notes/tmpl/default.php

On that page, I removed an extra ">" that was showing up as a list of one ">" per note and I did some better column headings.

I know this is a free module that was done in a class. Is there a way to submit changes to it?
  1. more than a month ago
  2. Wishlist
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Last questions

J5 compatibility for Hotspots
Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
2 Replies
Posted on Monday, 24 February 2025
  • #Hotspots
  • #hotspots Joomla 5
error message when adding/cofiguring email address
When configuring the email plugin that send a email message to admin when a new ...
0 Replies
Posted on Friday, 09 May 2025
  • New
  • CMigrator: Path from Drupal 6 to J5?
    (Category s/b CMigrator, but didn't see it on the list) I'm interested in usi...
    0 Replies
    Posted on Monday, 28 April 2025
    Dowload all Hotspots entries
    Hi there, I'm looking for a way to dowload all the Hotspots entries. I've got t...
    0 Replies
    Posted on Sunday, 06 April 2025
    • #kml
    • #download
    Set number of hotspots / user groups
    Hi, I'm working with Hotspots for my new website and I love it! After trying ...
    0 Replies
    Posted on Monday, 31 March 2025