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

PRobleme bei der Kursanmelduing
Hallo zusammen, wir haben seit kurzem das Problem das unsere Anmeldung nicht ...
1 Replies
Posted on Wednesday, 23 June 2021
  • New
  • 2 problems with jcomments import
    Hi, I just installed ccomment pro on my site and imported all comments from jco...
    0 Replies
    Posted on Wednesday, 23 June 2021
  • New
    • #jcomments import
    no emoticons in this comment
    Hello, I have a question about Ccomment free version Why are the emoticons mis...
    5 Replies
    Posted on Saturday, 06 March 2021
    Freezing of system when working on Hotspots
    I am experiencing a "freeze" when I work on Hotspots from the back end...
    3 Replies
    Posted on Monday, 21 June 2021
  • New
  • Captcha image size
    Hi, Is there any way to increase the captcha image size? The image is 103px w...
    1 Replies
    Posted on Sunday, 20 June 2021
  • New