Admin Order Sort

[homewetbar]

This contribution adds the ability to sort your orders in admin in various ways, by customer name, status, and date.

[Guest]

Which Contribution??

Edited December 1, 2004 by al090187

[homewetbar]

You can download the contribution here:

 

 

http://www.oscommerce.com/community/contributions,2681

 

 

Enjoy!

[iantates]

I have install this contrib as it will be very useful however the Title bar layout is out of format with the contents. See below.

 

As you can see the order ID is missing so the order total is above ID column this then causes the date purchased and staus title to also be out.

 

I copied and pasted the new code so I know its not a typo however I guess I have modded the orders.php at sometime which is why this has happened.

 

This is how it looked before mod.

 

Any ideas of sorting this out?

[homewetbar]

I have install this contrib as it will be very useful however the Title bar layout is out of format with the contents. See below.

 

As you can see the order ID is missing so the order total is above ID column this then causes the date purchased and staus title to also be out.

 

I copied and pasted the new code so I know its not a typo however I guess I have modded the orders.php at sometime which is why this has happened.

 

This is how it looked before mod.

 

Any ideas of sorting this out?

<{POST_SNAPBACK}>

 

 

Yeah it looks like you have modded your orders.php to include the order id as well at some point.

 

You just need to insert another row in the headings to make it look right

 

Try inserting

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_ORDERS_ID; ?></td>

 

right before

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>

 

 

I'm just guessing whatever mod you installed called the heading for orders id:

TABLE_HEADING_ORDERS_ID if it is something different you will need to change that it whatever the mod called the heading or you can just put 'Orders ID' instead if you don't want to mess with it.

[iantates]

I have fixed the format problem but am getting the following error.

1064 - You have an error in your SQL syntax near 'limit 0, 12' at line 1

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit 0, 12

This only happens on the first visit to orders page if I use the - or + it is fine of if I re-visit!

 

Any ideas?

[PopTheTop]

I have the Order ID showing as well. This mod works great and I love it! I do have two questions though...

 

1) Can I sort by Order ID number too? If so, how?

 

2) Can I sort by Order Total too? If so, how?

[Guest]

I added this a while back and realized that the order numbers would sort the same as the dates so I just hacked in more arrows over the order number that are copies of the ones that do the date.

OK, how about this: Can a sort be generated by the Shipping Method? I keep looking for this in various forms (I really want it for the Orderlist Contribution the most). I'm really surprised that more isn't done with this already. The logistics of pulling a list or just working with a batch for all one shipping company just makes sense. In my case, I've warped shipping methods into a Delivery Date choice and the need to sort is obvious. anyone out there want to take a shot at this? :huh:

[Bazkaz]

I just added this to a new install and it takes away all of the color formatting on my page. Any ideas?

[azer]

1. can you guys provide a solution for the order id ?

 

2. is there any way to change the + and - by up and down arrows ?