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

Text size in the comment input form
Hello. How can I increase the font size in the comment input field? For examp...
0 Replies
Posted on Wednesday, 26 February 2025
  • #CComment 6
Problem with enlarged image
Hello. When you click on the image in the comments, it does not appear in the ce...
1 Replies
Posted on Wednesday, 26 February 2025
Black square instead of images in comments
Hello. In comments instead of images I see black squares. Here is an example. h...
0 Replies
Posted on Wednesday, 26 February 2025
  • #ccoment pro
Link bug in comment emails
Hello. The site has three languages. For example, a user left a comment on an a...
3 Replies
Posted on Saturday, 15 April 2023
Unable to activate account created during purchase
I purchased CMigrator on compojoom.com but I can't download it. It's not possibl...
0 Replies
Posted on Wednesday, 26 February 2025