Changeset 2663

Timestamp:

03/01/2016 10:46:06 PM (11 years ago)

Author:

ocean90

Message:

Translate: Display contributors and editors on project pages of a locale.

See #1388.

Location:

sites/trunk

Files:

• translate.wordpress.org/public_html/gp-templates-new/locale-project.php (modified) (1 diff)
• translate.wordpress.org/public_html/gp-templates-new/style.css (modified) (3 diffs)
• wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/routes/locale.php (modified) (3 diffs)
• wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/routes/wp-plugins.php (modified) (2 diffs)

sites/trunk/translate.wordpress.org/public_html/gp-templates-new/locale-project.php

@@ -179 +179 @@
 </div>
 
+<div class="locale-project-contributors">
+        <div class="locale-project-contributors-group locale-project-contributors-contributors">
+                <h3>Translation Contributors</h3>
+                <?php if ( $locale_contributors['contributors'] ) : ?>
+                <ul>
+                        <?php
+                        foreach ( $locale_contributors['contributors'] as $contributor ) {
+                                printf(
+                                        '<li><a href="https://profiles.wordpress.org/%s/">%s %s</a></li>',
+                                        $contributor->nicename,
+                                        get_avatar( $contributor->email, 30 ),
+                                        $contributor->display_name ? $contributor->display_name : $contributor->nicename
+                                );
+                        }
+                        ?>
+                </ul>
+                <?php else : ?>
+                        <p>None, be the first?</p>
+                <?php endif; ?>
+        </div>
+        <div class="locale-project-contributors-group locale-project-contributors-editors">
+                <h3>Translation Editors</h3>
+                <?php if ( $locale_contributors['editors'] ) : ?>
+                <ul>
+                        <?php
+                        foreach ( $locale_contributors['editors'] as $editor ) {
+                                printf(
+                                        '<li><a href="https://profiles.wordpress.org/%s/">%s %s</a></li>',
+                                        $editor->nicename,
+                                        get_avatar( $editor->email, 40 ),
+                                        $editor->display_name ? $editor->display_name : $editor->nicename
+                                );
+                        }
+                        ?>
+                </ul>
+                <?php else : ?>
+                        <p>None, be the first?</p>
+                <?php endif; ?>
+        </div>
+</div>
+
 <script>
         jQuery( document ).ready( function( $ ) {

sites/trunk/translate.wordpress.org/public_html/gp-templates-new/style.css

@@ -344 +344 @@
 .project-status:before,
 .project-status:after,
+.locale-project-contributors:before,
+.locale-project-contributors:after,
 .locales:before,
 .locales:after {
@@ -355 +357 @@
 .project-box-header:after,
 .project-status:after,
+.locale-project-contributors:after,
 .locales:after {
         clear: both;
@@ -1279 +1282 @@
         display: none !important;
 }
+
+.locale-project-contributors-group {
+        width: 50%;
+        float: left;
+}
+
+.locale-project-contributors-group ul {
+        padding: 0;
+        margin: 0;
+        list-style: none;
+}
+
+.locale-project-contributors-group li {
+        margin: 0 0 10px;
+}
+
+.locale-project-contributors-group li img {
+        vertical-align: middle;
+        margin-right: 10px;
+}

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/routes/locale.php

@@ -167 +167 @@
                         $variants = $this->get_locale_variants( $locale_slug, array( $sub_project->id ) );
                 }
+
+                $locale_contributors = $this->get_locale_contributors( $sub_project, $locale_slug, $set_slug );
 
                 $this->tmpl( 'locale-project', get_defined_vars() );
@@ -258 +260 @@
 
                 return $slugs;
+        }
+
+        /**
+         * Retrieves contributors of a project.
+         *
+         * @param GP_Project $project     A GlotPress project.
+         * @param string     $locale_slug Slug of the locale.
+         * @param string     $set_slug    Slug of the translation set.
+         * @return array Contributors.
+         */
+        private function get_locale_contributors( $project, $locale_slug, $set_slug ) {
+                global $wpdb;
+
+                $locale_contributors = array(
+                        'editors'      => array(),
+                        'contributors' => array(),
+                );
+
+                // Get the translation editors of the project.
+                $editors = $wpdb->get_col( $wpdb->prepare( "
+                        SELECT
+                                `user_id`
+                        FROM {$wpdb->wporg_translation_editors}
+                        WHERE
+                                `project_id` = %d
+                                AND `locale` = %s
+                ", $project->id, $locale_slug ) );
+
+                // Get the names of the translation editors.
+                foreach ( $editors as $editor_id ) {
+                        $user = get_user_by( 'id', $editor_id );
+                        if ( ! $user ) {
+                                continue;
+                        }
+
+                        $locale_contributors['editors'][ $editor_id ] = (object) array(
+                                'nicename'     => $user->user_nicename,
+                                'display_name' => $this->_encode( $user->display_name ),
+                                'email'        => $user->user_email,
+                        );
+                }
+                unset( $editors );
+
+                // Get the contributors of the project.
+                $contributors = array();
+
+                // In case the project has a translation set, like /wp-themes/twentysixteen.
+                $translation_set = GP::$translation_set->by_project_id_slug_and_locale( $project->id, $set_slug, $locale_slug );
+                if ( $translation_set ) {
+                        $contributors = array_merge(
+                                $contributors,
+                                $this->get_locale_contributors_by_translation_set( $translation_set )
+                        );
+                }
+
+                // Check if the project has sub-projects, like /wp-plugins/wordpress-importer.
+                $sub_projects = $wpdb->get_col( $wpdb->prepare( "
+                        SELECT id
+                        FROM {$wpdb->gp_projects}
+                        WHERE parent_project_id = %d
+                ", $project->id ) );
+
+                foreach ( $sub_projects as $sub_project ) {
+                        $translation_set = GP::$translation_set->by_project_id_slug_and_locale( $sub_project, $set_slug, $locale_slug );
+                        if ( ! $translation_set ) {
+                                continue;
+                        }
+
+                        $contributors = array_merge(
+                                $contributors,
+                                $this->get_locale_contributors_by_translation_set( $translation_set )
+                        );
+                }
+
+                // Get the names of the contributors.
+                foreach ( $contributors as $contributor_id ) {
+                        if ( isset( $locale_contributors['editors'][ $contributor_id ] ) ) {
+                                continue;
+                        }
+
+                        if ( isset( $locale_contributors['contributors'][ $contributor_id ] ) ) {
+                                continue;
+                        }
+
+                        $user = get_user_by( 'id', $contributor_id );
+                        if ( ! $user ) {
+                                continue;
+                        }
+
+                        $locale_contributors['contributors'][ $contributor_id ] = (object) array(
+                                'nicename'     => $user->user_nicename,
+                                'display_name' => $this->_encode( $user->display_name ),
+                                'email'        => $user->user_email,
+                        );
+                }
+                unset( $contributors );
+
+                return $locale_contributors;
+        }
+
+        /**
+         * Retrieves contributors of a translation set.
+         *
+         * @param GP_Translation_Set $translation_set A translation set.
+         * @return array List of user IDs.
+         */
+        private function get_locale_contributors_by_translation_set( $translation_set ) {
+                global $wpdb;
+
+                $user_ids = $wpdb->get_col( $wpdb->prepare( "
+                        SELECT DISTINCT( `user_id` )
+                        FROM `{$wpdb->gp_translations}`
+                        WHERE
+                                `translation_set_id` = %d
+                                AND `user_id` IS NOT NULL AND `user_id` != 0
+                                AND `status` <> 'rejected'
+                                AND `date_modified` > %s
+                ", $translation_set->id, date( 'Y-m-d', time() - YEAR_IN_SECONDS ) ) );
+
+                return $user_ids;
         }
 
@@ -620 +742 @@
                 return strcasecmp( $a->name, $b->name );
         }
+
+        private function _encode( $raw ) {
+                $raw = mb_convert_encoding( $raw, 'UTF-8', 'ASCII, JIS, UTF-8, Windows-1252, ISO-8859-1' );
+                return ent2ncr( htmlspecialchars_decode( htmlentities( $raw, ENT_NOQUOTES, 'UTF-8' ), ENT_NOQUOTES ) );
+        }
 }

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/routes/wp-plugins.php

@@ -264 +264 @@
                 }
 
-
                 $labels = array_keys( $data );
                 array_pop( $labels );
@@ -311 +310 @@
                 $json = file_get_contents( "https://api.wordpress.org/translations/plugins/1.0/?slug={$project_slug}", null, $http_context );
                 $language_packs = $json && '{' == $json[0] ? json_decode( $json ) : null;
-
 
                 $this->tmpl( 'projects-wp-plugins-language-packs', get_defined_vars() );