price displayed on admin.php?p=orders-list

Frans123

2008-12-30 11:12

In the admin section under the orders tab (site.com/admin.php?p=orders-list) I would like to have an extra collumn that displays the totalprice of each person that ordered.
It is very usefull for me to quickly cross-check with my bank account to see who paid and who didn't.

What I tried was to paste the following in the table.
but that's probably to simple because it messes up my table.
<td class="price">$sOrderSummary</td>

Hope anyone can point me into the right direction.

happy newyear!

» Quick.Cart v3.x

Frans

beholder

2008-12-30 16:13

I'll check this out in a few coming days, this really seems a good idea, hopefully it is possible and it should be easy enough to implement.

treewood (OpenSolution)

2008-12-31 08:14

it will be not easy because prices are saved in db/orders_products.php and in db/orders.php. in orders list you should count all prices * products quantity from db/orders_products.php and after add to summary price payment and delivery costs from db/orders.php.
when you will have 10-50 orders it will be not problem but when you will have 500 orders then server maybe will be overloaded

beholder

2008-12-31 19:27

Treewood is right, I just checked db/orders.php and it doesn't have price summary, therefore it is quite impossible to display this for many orders at once. If it had, it would be another thing, it would be quite easy to implement.

I don't see a reason why the summary price shouldn't be in db/order.php but there surely was one.

treewood (OpenSolution)

2009-01-02 08:09

beholder - easy not easy ... you know QC well and it is easy for you but i write to peoples who dont know well our tools and if i will give some suggestions (not complete solution) then it will be not easy to create this

Frans123

2009-01-05 11:16

Thanks anyway guys for replying..... even on newyears eve!

ofcourse this feature would be a nice little extra so it's not worth to spend hours on sorting this out.

thanks.

Frans

beholder

2010-05-26 18:41

Hey, I just finished a similar feature for a client of mine. In the process I made it possible to display that summary price in the orders list. I remembered this thread so I am giving info. Let me know if you still need something like this.

beholder

2010-06-02 20:47

please look here for solution:
http://opensolution.org/Quick.Cart/forum/?p=readTopic&nr=6843