Add a filter for waiting strings with newest/oldest sorting

[SergeyBiryukov]

On ​https://translate.wordpress.org/locale/ru, two more filters would be helpful:

• Waiting + Fuzzy (Newest first)
• Waiting + Fuzzy (Oldest first)

[ocean90]

Newest/oldest of what?

[SergeyBiryukov]

Replying to ocean90:

Newest/oldest of what?

Date of the suggested translation.

[ocean90]

Okay, that should be easy.

If someone wants to work on a patch: The table translate_project_translation_status would need a new column to track the last updated date. Affected plugins: /wporg-gp-routes/inc/routes/class-locale.php, /wporg-gp-customizations/templates/locale-projects.php and /wporg-gp-custom-stats/stats/project.php.

[SergeyBiryukov]

#2971 was marked as a duplicate.

[tobifjellner]

Ahh. When I searched, I didn't find this one... Anyway, for convenience of other people, I'd like to include my arguments for this enhancement from my duped ticket #2971:

The translate environment has several views where a GTE quickly can find translation projects that have waiting strings.
​https://translate.wordpress.org/locale/[locale-gp-slug]

Through these views, locales with no or very few pending strings can quickly find projects where new strings have been proposed, and then check these.

But for locales with several thousands of pending strings, it's important to capture new contributions and check these quickly:

• During translation events the contributors would be able to see their work online already during the event.
• When some new person starts contributing, a GTE may notice this and offer advice on style, terminology, etc before the contributor has spent too much time doing things wrong. In addition, if these things get noted and corrected quickly, the contributor may soon enough get invited to a local slack team and get promoted to PTE.

Therefore, in additin to the views Waiting + fuzzy – (most first) and Waiting + fuzzy – (least first) I suggest that we add Waiting + fuzzy – (newest first)

[xkon]

UI added - missing db queries

[xkon]

I think I'm off to a good start here. I know that the UI lists work and throw call backs when selected but unfortunately I can't seem to make the translate.wordpressorg.dev work. No matter what I add in the database ( projects / translations etc ) it doesn't show me anything on the website to have an idea on what I'm doing so I don't know how to test the sql queries etc and check what is needed in the database.

Anyway if I make it work somehow I will continue on this until then at least 1874.partial.diff is a start for whoever manages to make the website work locally for tests :) .

---

Note to @ocean90 . Would it be possible to update the VVV databases to have some dummy data in them by default? It would make everybody's life much easier instead of starting blank every time. Take as an example this ticket where there are no translations / projects etc and I can't find a way to add one as I have no clue how the admin etc works. Trying through the database directly got me 0 -.- hahah.

Just a though for the future.

---

Best regards,
Konstantinos

[ocean90]

In 8523:

Translate: Add a filter for waiting strings with newest/oldest sorting.

Props xkon.
Fixes #1874.