search

mohanjith / web-invoice

Automatically exported from code.google.com/p/web-invoice
GNU General Public License v3.0
0 stars 2 forks source link

Persistent Invoice Sorting #20

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Not sure, possibly delete an existing invoice.
2.
3.

What is the expected output? What do you see instead?

Invoices should be ordered on the admin page according to the date they were 
created.

What version of the product are you using? On what operating system?

2.0.3 but is same in 2.0.5

Please provide any additional information below.

There should be an option to sort the invoices, default ordering should be by 
the date creation of each invoice.

Original issue reported on code.google.com by david.pa...@gmail.com on 9 Jul 2010 at 12:39

GoogleCodeExporter commented 9 years ago

Original comment by sh.mohanjith on 9 Jul 2010 at 1:27

GoogleCodeExporter commented 9 years ago

Original comment by sh.mohanjith on 9 Jul 2010 at 6:41

GoogleCodeExporter commented 9 years ago

Original comment by sh.mohanjith on 9 Jul 2010 at 8:37

GoogleCodeExporter commented 9 years ago 
It's too expensive (CPU wise) to sort based on the invoice date because of the 
way Web Invoice stores the invoice date.

However the invoice internal id (not the id users see) is an autoincrement ID. 
Sorting by this id should get the same effect as sorting by invoice creation 
date. Also sorting by primary key is lot less expensive.

Original comment by sh.mohanjith on 9 Jul 2010 at 8:58

GoogleCodeExporter commented 9 years ago 
Fixed in r19

Original comment by sh.mohanjith on 9 Jul 2010 at 8:59