622172 - [backend] Build the Editor full/pending/lite queue pages

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Admin/Editor Tools, defect, P1)

Description

[Wil Clouser [:clouserw]]

This bug includes 3 pages:

https://addons.allizom.org/en-US/editors/queue (redirects to /pending)
https://addons.allizom.org/en-US/editors/queue/nominated
https://addons.allizom.org/en-US/editors/queue/pending
https://addons.allizom.org/en-US/editors/queue/preliminary

This is a big chunk of code, but all three pages are very similar so they are getting piled together here.  This bug does not include the search box - that is bug 622171.

This bug does include:
- the table structure with tabs at the top
- pagination at 100 add-ons
- the queue counts in the tabs (also note bug 622169)
- the sortable columns
- the "helpful links" at the bottom of the page

Be aware of slow queries.  The remora code will help with subtleties (like determining waiting time).

Comment 1

[Kumar McMillan [:kumar]]

note to self: left off at extracting SQL query from PHP. See ~/tmp/zamboni-editor-data-grid.sql

Comment 2

[Kumar McMillan [:kumar]]

I'm marking this done so QA can start verifying.  Below are either the features that were completed or a link to a new bug if the feature was *not* completed

> https://addons.allizom.org/en-US/editors/queue (redirects to /pending)
> https://addons.allizom.org/en-US/editors/queue/pending
Done.

> https://addons.allizom.org/en-US/editors/queue/nominated
bug 627502

> https://addons.allizom.org/en-US/editors/queue/preliminary
bug 627512

> - pagination at 100 add-ons
> - the sortable columns
> - the "helpful links" at the bottom of the page
Done

> - the table structure with tabs at the top
The table is there but not the tabs.  See bug 627522

> - the queue counts in the tabs (also note bug 622169)
Bug 627522

Fixed in https://github.com/jbalogh/zamboni/commit/17593c09da01715c07d7d09537b31b2fc269b259