mirror of
https://gh.wpcy.net/https://github.com/fairpm/server.git
synced 2026-06-20 03:02:27 +08:00
235 lines
9.3 KiB
PHP
235 lines
9.3 KiB
PHP
<?php
|
|
/**
|
|
* Discarded warning stats.
|
|
*
|
|
* Originally from https://github.com/WordPress/wordpress.org/blob/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-custom-stats/stats/project.php
|
|
* Used under the GPLv2 license. Copyright 2025 authors.
|
|
*/
|
|
|
|
namespace FAIRServer\Translate\Stats;
|
|
|
|
use GP;
|
|
|
|
/**
|
|
* This plugin stores the Translation Count Status into a DB table for querying purposes.
|
|
*
|
|
* The data is pulled from GP_Translation_Set stat functions and updated in the DB whenever
|
|
* a new translation is submitted, or new originals are imported.
|
|
* The datbase update is delayed until shutdown to bulk-update the database during imports.
|
|
*
|
|
* NOTE: The counts includes all sub-projects in the count, as that's more useful for querying (top-level projects excluded)
|
|
* for example, wp-plugins/akismet will include wp-plugins/akismet/stable and wp-plugins/akismet/stable-readme
|
|
* wp-plugins and wp-themes are special top-level projects which are included here, where their string counts are updated
|
|
* on a twice-daily cron task.
|
|
*
|
|
* @author dd32
|
|
*/
|
|
class ProjectStats {
|
|
|
|
public $projects_to_update = array();
|
|
|
|
function __construct() {
|
|
global $wpdb, $gp_table_prefix;
|
|
|
|
add_action( 'gp_translation_created', array( $this, 'translation_edited' ) );
|
|
add_action( 'gp_translation_saved', array( $this, 'translation_edited' ) );
|
|
add_action( 'gp_translation_deleted', array( $this, 'translation_edited' ) );
|
|
add_action( 'gp_originals_imported', array( $this, 'originals_imported' ), 10, 5 );
|
|
|
|
// DB Writes are delayed until shutdown to bulk-update the stats during imports
|
|
add_action( 'shutdown', array( $this, 'shutdown' ) );
|
|
|
|
// Cron task to cache the wp-themes/wp-plugins string counts.
|
|
if ( ! wp_next_scheduled ( 'wporg_gp_stats_cache_waiting_strings' ) ) {
|
|
wp_schedule_event( time(), 'twicedaily', 'wporg_gp_stats_cache_waiting_strings' );
|
|
}
|
|
add_action( 'wporg_gp_stats_cache_waiting_strings', [ $this, 'cache_wp_themes_wp_plugins_strings' ] );
|
|
|
|
$wpdb->project_translation_status = $gp_table_prefix . 'project_translation_status';
|
|
}
|
|
|
|
function translation_edited( $translation ) {
|
|
/** @var \GP_Translation_Set */
|
|
$set = GP::$translation_set->get( $translation->translation_set_id );
|
|
$this->projects_to_update[ $set->project_id ][ $set->locale . '/' . $set->slug ] = true;
|
|
}
|
|
|
|
function originals_imported( $project_id, $originals_added, $originals_existing, $originals_obsoleted, $originals_fuzzied ) {
|
|
if ( $originals_added || $originals_existing || $originals_obsoleted || $originals_fuzzied ) {
|
|
$this->projects_to_update[ $project_id ] = true;
|
|
}
|
|
}
|
|
|
|
// Count up all the strings
|
|
function get_project_translation_counts( $project_id, $locale, $locale_slug, &$counts = array() ) {
|
|
if ( ! $counts ) {
|
|
$counts = array( 'all' => 0, 'current' => 0, 'waiting' => 0, 'fuzzy' => 0, 'warnings' => 0, 'untranslated' => 0 );
|
|
}
|
|
|
|
// Not all projects have translation sets
|
|
/** @var \GP_Translation_Set */
|
|
$set = GP::$translation_set->by_project_id_slug_and_locale( $project_id, $locale_slug, $locale );
|
|
if ( $set ) {
|
|
// Force a refresh of the translation set counts
|
|
wp_cache_delete( $set->id, 'translation_set_status_breakdown' );
|
|
|
|
$counts['all'] += $set->all_count();
|
|
$counts['current'] += $set->current_count();
|
|
$counts['waiting'] += $set->waiting_count();
|
|
$counts['fuzzy'] += $set->fuzzy_count();
|
|
$counts['warnings'] += $set->warnings_count();
|
|
$counts['untranslated'] += $set->untranslated_count();
|
|
}
|
|
|
|
// Fetch the strings from the sub projects too
|
|
/** @var \GP_Project */
|
|
foreach ( GP::$project->get( $project_id )->sub_projects() as $project ) {
|
|
if ( ! $project->active ) {
|
|
continue;
|
|
}
|
|
$this->get_project_translation_counts( $project->id, $locale, $locale_slug, $counts );
|
|
}
|
|
|
|
return $counts;
|
|
}
|
|
|
|
/**
|
|
* Cron task to cache the string counts for the wp-themes and wp-plugins parent categories.
|
|
*
|
|
* These don't have any translation sets, but we need to be able to query the waiting strings for them.
|
|
*/
|
|
public function cache_wp_themes_wp_plugins_strings() {
|
|
global $wpdb;
|
|
|
|
$cached_projects = [
|
|
GP::$project->by_path( 'wp-plugins' ),
|
|
GP::$project->by_path( 'wp-themes' ),
|
|
];
|
|
|
|
// Store the counts for these parent projects as the sum of their children.
|
|
$sql = "INSERT INTO {$wpdb->project_translation_status} ( `project_id`, `locale`, `locale_slug`, `all`, `current`, `waiting`, `fuzzy`, `warnings`, `untranslated`, `date_added`, `date_modified`)
|
|
SELECT
|
|
p.parent_project_id as project_id,
|
|
locale, locale_slug,
|
|
SUM( stats.all ) as `all`, SUM( stats.current ) as `current`, SUM( stats.waiting ) as `waiting`,
|
|
SUM( stats.fuzzy ) as `fuzzy`, SUM( stats.warnings ) as `warnings`, SUM( stats.untranslated ) as `untranslated`,
|
|
NOW() as `date_added`, NOW() as `date_modified`
|
|
FROM {$wpdb->project_translation_status} stats
|
|
LEFT JOIN {$wpdb->gp_projects} p ON stats.project_id = p.id
|
|
WHERE
|
|
p.parent_project_id = %d
|
|
AND p.active = 1
|
|
GROUP BY locale, locale_slug
|
|
ON DUPLICATE KEY UPDATE
|
|
`all` = VALUES(`all`), `current` = VALUES(`current`),
|
|
`waiting` = VALUES(`waiting`), `fuzzy` = VALUES(`fuzzy`),
|
|
`warnings` = VALUES(`warnings`), `untranslated` = VALUES(`untranslated`),
|
|
`date_modified` = VALUES(`date_modified`);
|
|
";
|
|
|
|
foreach ( $cached_projects as $project ) {
|
|
$wpdb->query( $wpdb->prepare( $sql, $project->id ) );
|
|
}
|
|
|
|
}
|
|
|
|
function shutdown() {
|
|
global $wpdb;
|
|
$values = array();
|
|
|
|
// If a project is `true` then we need to fetch all translation sets for it.
|
|
foreach ( $this->projects_to_update as $project_id => $set_data ) {
|
|
if ( true === $set_data ) {
|
|
$this->projects_to_update[ $project_id ] = array();
|
|
/** @var \GP_Translation_Set */
|
|
foreach ( GP::$translation_set->by_project_id( $project_id ) as $set ) {
|
|
$this->projects_to_update[ $project_id ][ $set->locale . '/' . $set->slug ] = true;
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
// Update all parent projects as well.
|
|
// This does NOT update a root parent (ie. ! $parent_project_id) as we use those as grouping categories.
|
|
$projects = $this->projects_to_update;
|
|
foreach ( $projects as $project_id => $data ) {
|
|
// Do all parents
|
|
/** @var \GP_Project */
|
|
$project = GP::$project->get( $project_id );
|
|
while ( $project ) {
|
|
/** @var \GP_Project */
|
|
$project = GP::$project->get( $project->parent_project_id );
|
|
if ( $project->parent_project_id ) {
|
|
$projects[ $project->id ] = $data;
|
|
} else {
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
$this->projects_to_update += $projects;
|
|
unset( $projects );
|
|
|
|
$now = current_time( 'mysql', 1 );
|
|
|
|
foreach ( $this->projects_to_update as $project_id => $locale_sets ) {
|
|
$locale_sets = array_keys( $locale_sets );
|
|
$locale_sets = array_map( function( $set ) { return explode( '/', $set ); }, $locale_sets );
|
|
|
|
foreach ( $locale_sets as $locale_set ) {
|
|
list( $locale, $locale_slug ) = $locale_set;
|
|
$counts = $this->get_project_translation_counts( $project_id, $locale, $locale_slug );
|
|
|
|
$values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d, %d, %d, %d, %d, %s, %s)',
|
|
$project_id,
|
|
$locale,
|
|
$locale_slug,
|
|
$counts['all'],
|
|
$counts['current'],
|
|
$counts['waiting'],
|
|
$counts['fuzzy'],
|
|
$counts['warnings'],
|
|
$counts['untranslated'],
|
|
$now,
|
|
$now
|
|
);
|
|
}
|
|
|
|
// If we're processing a large batch, add them as we go to avoid query lengths & memory limits
|
|
if ( count( $values ) > 50 ) {
|
|
$wpdb->query( "INSERT INTO {$wpdb->project_translation_status} (`project_id`, `locale`, `locale_slug`, `all`, `current`, `waiting`, `fuzzy`, `warnings`, `untranslated`, `date_added`, `date_modified` ) VALUES " . implode( ', ', $values ) . " ON DUPLICATE KEY UPDATE `all`=VALUES(`all`), `current`=VALUES(`current`), `waiting`=VAlUES(`waiting`), `fuzzy`=VALUES(`fuzzy`), `warnings`=VALUES(`warnings`), `untranslated`=VALUES(`untranslated`), `date_modified`=VALUES(`date_modified`)" );
|
|
$values = array();
|
|
}
|
|
}
|
|
$this->projects_to_update = array();
|
|
|
|
if ( $values ) {
|
|
$wpdb->query( "INSERT INTO {$wpdb->project_translation_status} (`project_id`, `locale`, `locale_slug`, `all`, `current`, `waiting`, `fuzzy`, `warnings`, `untranslated`, `date_added`, `date_modified` ) VALUES " . implode( ', ', $values ) . " ON DUPLICATE KEY UPDATE `all`=VALUES(`all`), `current`=VALUES(`current`), `waiting`=VALUES(`waiting`), `fuzzy`=VALUES(`fuzzy`), `warnings`=VALUES(`warnings`), `untranslated`=VALUES(`untranslated`), `date_modified`=VALUES(`date_modified`)" );
|
|
}
|
|
}
|
|
|
|
public static function get_schema() : string {
|
|
global $gp_table_prefix;
|
|
return <<<"END"
|
|
CREATE TABLE `{$gp_table_prefix}project_translation_status` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`project_id` int(10) unsigned NOT NULL,
|
|
`locale` varchar(10) NOT NULL,
|
|
`locale_slug` varchar(255) NOT NULL,
|
|
`all` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`current` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`waiting` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`fuzzy` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`untranslated` int(10) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `project_locale` (`project_id`,`locale`,`locale_slug`),
|
|
KEY `all` (`all`),
|
|
KEY `current` (`current`),
|
|
KEY `waiting` (`waiting`),
|
|
KEY `fuzzy` (`fuzzy`),
|
|
KEY `warnings` (`warnings`),
|
|
KEY `untranslated` (`untranslated`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
END;
|
|
}
|
|
}
|
