9 of 9
9
REEOrder Module (Custom ordering of entries)
Posted: 24 February 2010 11:01 AM   [ Ignore ]   [ # 145 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  298
Joined  10-18-2004

I’m happy to announce Low Reorder for EE 2.x is available now for a modest price.

For those of you who missed it, read this announcement about me taking over Cocoaholic’s add-ons.

 Signature 

Low: the Pro Network member who brought you Low Variables, Low Reorder, Low NoSpam, Low Seg2Cat and many more...

Profile
 
 
Posted: 24 February 2010 03:45 PM   [ Ignore ]   [ # 146 ]  
Research Assistant
Avatar
RankRankRank
Total Posts:  484
Joined  08-31-2004

I’m interested and looked over your description, which is clear. But I’m wondering whether you could add any ideas (use cases) on how this might be integrated (?) with other important addons when they come out - if it can be. For instance, Tags, Structure, Playa, your own Variables addon, etc.

For instance, could one approach the flexibility of Seeries? Or do you consider that to be a different species of animal than REEOrder?

Profile
 
 
Posted: 21 April 2010 04:03 AM   [ Ignore ]   [ # 147 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  178
Joined  02-27-2004

Hey Low,

Lovely work you’ve done on this. I was sort of expecting this result since I performed a data migration to a site where we’d like to use ReeOrder, but: we just imported 14000 entries into the weblog where I was using ReeOrder. When I click on the link to start re-ordering, not to my total surprise, I get an out of memory error:

Fatal errorAllowed memory size of 67108864 bytes exhausted (tried to allocate 51 bytesin /www/eh11822/public_html/vueee/modules/reeorder/mcp.reeorder.php on line 837 

I’ve tried turning the module off and on again and re-setting up the preferences, but to no avail.

When Chocaholic first introduced this module, I got the impression that it was really designed for sites with a relatively small number of entries per weblog, so I’m not too disappointed. However, I’m still wondering if it’s possible to work around this out of memory error.

If not, I’ll have to find some other solution (although I have some ideas for how ReeOrder could for a weblog with a lot of records.

Cheers

R o B

Profile
 
 
Posted: 21 April 2010 04:08 AM   [ Ignore ]   [ # 148 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  298
Joined  10-18-2004

You can always try and up the php memory limit in your .htaccess file:

php_value memory_limit 16M 

You can up the 16M to even more if needed.

 Signature 

Low: the Pro Network member who brought you Low Variables, Low Reorder, Low NoSpam, Low Seg2Cat and many more...

Profile
 
 
Posted: 21 April 2010 05:19 AM   [ Ignore ]   [ # 149 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  178
Joined  02-27-2004

Thanks Low. I checked, but memory_limit’s sitting at 64M right now. Also, I’m not even sure if the hosts (EngineHosting, who we really want to use!) let you up your memory.

Profile
 
 
Posted: 21 April 2010 05:26 AM   [ Ignore ]   [ # 150 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  298
Joined  10-18-2004
Oxygen Smith - 21 April 2010 09:19 AM

Thanks Low. I checked, but memory_limit’s sitting at 64M right now. Also, I’m not even sure if the hosts (EngineHosting, who we really want to use!) let you up your memory.

Heh, well I guess 14.000 entries in one go is a bit much anyway. You might want to rethink the strategy; do you really need custom ordering with that amount of entries? Isn’t it more useful to create more structure first, for example by categorizing the entries?

I think the whole point of REEorder is having all relevant entries in a list to reorder. A list of 14.000 entries wouldn’t be manageable, even if the memory limit wasn’t an issue.

 Signature 

Low: the Pro Network member who brought you Low Variables, Low Reorder, Low NoSpam, Low Seg2Cat and many more...

Profile
 
 
Posted: 21 April 2010 05:48 AM   [ Ignore ]   [ # 151 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  178
Joined  02-27-2004

Heh, well I guess 14.000 entries in one go is a bit much anyway. You might want to rethink the strategy; do you really need custom ordering with that amount of entries? Isn’t it more useful to create more structure first, for example by categorizing the entries?

Yes, that’s exactly it. The plan has never been to number them all from 0-15000, though. I just really like your drag and drop interface as opposed to the usual strategy I give to clients, which is to multi-edit the entries they want to re-order, then change part of their entry_date timestamp, to get them in a different sequence.

What I was hoping that, in the near future, Reeorder might let you filter and order ‘groups of entries’ to reorder, much like you use the edit screen to filter down entires through category, status, etc. I think that someone in the discussion on your site had a similar idea. I see that updates have ceased on the 1.6x version, though… totally understandable.

Cheers,

R o B

Profile
 
 
Posted: 30 April 2010 12:41 PM   [ Ignore ]   [ # 152 ]  
Lab Assistant
RankRank
Total Posts:  183
Joined  01-17-2005

Using the pagination sql query code flying around, I’ve got it working, but instead of Next and Previous, I’d prefer to show the title of the item. Anyone care to provide the SQL knowledge on getting access to this.

Here’s the code as it stands:

PREV
{exp
:query sql="SELECT url_title AS ut FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id WHERE ewd.field_id_29 < {reeorder_index} AND ewd.weblog_id = {weblog_id} AND STATUS = 'open' ORDER BY field_id_29 DESC LIMIT 1"}    
<a href="/index.php/exampletemplate/{ut}/">{entry_title}</a>
{/exp:query}

NEXT
{exp
:query sql="SELECT url_title AS ut FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id WHERE ewd.field_id_29 > {reeorder_index} AND ewd.weblog_id = {weblog_id} AND STATUS = 'open' ORDER BY field_id_29 ASC LIMIT 1"}
<a href="/index.php/exampletemplate/{ut}/">{entry_title}</a>
{/exp:query} 

A plus would be some way of working out whether there’s is both a next and previous returned, but I’d be happy to just get a title.

Cheers
Brendan

 Signature 

Brendan Underwood
ipixel web design & development

Profile
 
 
Posted: 04 May 2010 05:52 AM   [ Ignore ]   [ # 153 ]  
Lab Assistant
RankRank
Total Posts:  183
Joined  01-17-2005

OK, managed to get a mate of mine to help me out with the SQL used to fo pagination (paging) with Reeorder including restriction to specific category id. You’ll notice that I’m also checking to make sure that the items returned are a part of a specific category as the weblogs in my case are shared across multiple categories. I’m using LowSeg2Cat to hack the URL in my case to get nice SEO friendly URLs.

Should be relatively easy to modify to your needs.

{exp:weblog:entries weblog="{segment_2}" url_title="{segment_3}" dynamic="off" disable="member_data|trackbacks|pagination|categories|category_fields"}
{if reeorder_index}
  
<div id="productpaging">
    
{exp:query sql="SELECT title AS item_title, url_title AS item_url FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id INNER JOIN exp_category_posts ecp ON ecp.entry_id = ewt.entry_id WHERE ewd.field_id_29 > {reeorder_index} AND ewd.weblog_id = {weblog_id} AND STATUS = 'open' AND ecp.cat_id = {segment_1_category_id} ORDER BY field_id_29 ASC LIMIT 1"}
     
<a href="{site_url}{segment_1}/{segment_2}/{item_url}/" class="page-prev">{item_title}</a>
    
{/exp:query}

    
<!-- show separator only if both next and previous are present -->
    
{exp:query sql="SELECT count(*) AS prev_count FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id INNER JOIN exp_category_posts ecp ON ecp.entry_id = ewt.entry_id WHERE ewd.weblog_id = {weblog_id} AND STATUS = 'open' AND ecp.cat_id = {segment_1_category_id} AND (ewd.field_id_29 < {reeorder_index})"}
    {exp
:query sql="SELECT count(*) AS next_count FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id INNER JOIN exp_category_posts ecp ON ecp.entry_id = ewt.entry_id WHERE ewd.weblog_id = {weblog_id} AND STATUS = 'open' AND ecp.cat_id = {segment_1_category_id} AND (ewd.field_id_29 > {reeorder_index})"}{if {prev_count} AND {next_count} 0} {/if}{/exp:query}{/exp:query}

    {exp
:query sql="SELECT title AS item_title, url_title AS item_url FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id INNER JOIN exp_category_posts ecp ON ecp.entry_id = ewt.entry_id WHERE ewd.field_id_29 < {reeorder_index} AND ewd.weblog_id = {weblog_id} AND STATUS = 'open' AND ecp.cat_id = {segment_1_category_id} ORDER BY field_id_29 DESC LIMIT 1"}    
     
<a href="{site_url}{segment_1}/{segment_2}/{item_url}/" class="page-next">{item_title}</a>
    
{/exp:query}
  
</div>
{/if}
{
/exp:weblog:entries} 

You can see this in action on the following page/s:
http://www.stormwatches.com.au/mens/watches/noxer/

Cheers
Brendan

 Signature 

Brendan Underwood
ipixel web design & development

Profile
 
 
Posted: 06 July 2010 07:29 AM   [ Ignore ]   [ # 154 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  160
Joined  01-04-2008

The module itself works great but im getting an error with the hide in control panel extensions:

document.getElementById("field_pane_off_0"is null
[Break on this error] document
.getElementById('field_pane_off_0')[removed].style.display='none'

Iv disabled it at the moment and also not shown as default but i guess in an ideal world id like to get it working. If anyone has ideas ideas it would be appreciated.

Thanks.

 Signature 

Great EE Podcast

Profile
 
 
   
9 of 9
9