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

Questions on new installation...
Working on getting this set up... https://eastend2024.joepolecheck.com/rumma...
3 Replies
Posted on Wednesday, 17 April 2024
  • Resolved
  • New
  • Changes to the Submission form
    Can you make changes to the Submission form? There are a few fields I'd like to ...
    0 Replies
    Posted on Thursday, 18 April 2024
  • New
  • Error received? Class "XMLReader" not fo
    Just installed the Pro version of Hotspots, but am getting an error when I try t...
    1 Replies
    Posted on Wednesday, 17 April 2024
  • Resolved
  • New
  • Links aus Veranstaltungsübersicht funktionieren ni
    Nach der Migration von Joomla 3.10 auf Joomla 5.0.3 treten folgende Probleme auf...
    2 Replies
    Posted on Monday, 08 April 2024
    Custom Hotspot Marker fails to load
    I just updated from Joomla 3 to Joomla 4.3.4 and Hotspots 6.0.12. I decided to e...
    0 Replies
    Posted on Tuesday, 09 April 2024