[INP-1506] Show translation statistics in "Configuration > Regional" section - In-Portal Issue Tracker

XML

Word

Printable

Change Log Group:
Added
Change Log Message:
The language pack translation statistics in now collected and shown in "Configuration > Website > Regional" section in Admin Console.
Story Points:
1
Copy Issue Key:
Patch Instructions:
Patches must be submitted through Phabricator.
- To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial
- To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial

Plan

show "Translations Synced" column in "Configuration > Regional" section
column would have both filtering and sorting disabled (to speed up implementation)
create "lang:TranslationStatistics" tag, that would:
- accept "prefix" parameter; possible values: "phrases", "email-template"
- make single DB query from DB table associated with given unit (via "prefix" parameter) in which get this from every language (replace "5" with language ID):
```
SUM(IF(l5_TranslateFrom = 0, 0, 1)) / COUNT(l5_TranslateFrom)
```
- cache in a static variable
- return value for currently displayed language (in grid)

—

phrase count, that doesn't require to be synced:
```
SUM(IF(l5_TranslateFrom = 0, 1, 0))
```
total phrase count:
```
COUNT(l5_TranslateFrom)
```

relates to

INP-825 Ability to Keep Language Packs in Sync