PHP SitePress::get_current_user方法代码示例

 public function get_per_domain_counts($status)
 {
     $extra_cond = '';
     $joins = '';
     $current_user = $this->sitepress->get_current_user();
     if ($status !== false) {
         if ($status == ICL_TM_COMPLETE) {
             $extra_cond .= " AND s.status = " . ICL_TM_COMPLETE;
         } else {
             $extra_cond .= " AND s.status IN (" . ICL_STRING_TRANSLATION_PARTIAL . "," . ICL_TM_NEEDS_UPDATE . "," . ICL_TM_NOT_TRANSLATED . ")";
         }
     }
     if (icl_st_is_translator()) {
         $user_langs = get_user_meta($current_user->ID, $this->wpdb->prefix . 'language_pairs', true);
         foreach ($user_langs as $source_lang => $lang_pair) {
             $source_lang = esc_sql($source_lang);
             foreach ($lang_pair as $lang => $one) {
                 $lcode_alias = esc_sql(str_replace('-', '', $source_lang . $lang));
                 $joins[] = $this->wpdb->prepare(" JOIN {$this->wpdb->prefix}icl_string_translations {$lcode_alias}_str\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tON {$lcode_alias}_str.string_id = s.id AND {$lcode_alias}_str.language= %s AND s.language = %s\n\t\t\t                                                  AND ( {$lcode_alias}_str.status = " . ICL_TM_WAITING_FOR_TRANSLATOR . " OR {$lcode_alias}_str.translator_id = %d ) ", $lcode_alias, $source_lang, $current_user->ID);
             }
         }
         $sql = "\n                SELECT s.context, COUNT(s.context) AS c FROM {$this->wpdb->prefix}icl_strings s\n                " . join("\n", $joins) . "\n                WHERE 1 {$extra_cond}  AND TRIM(s.value) != ''\n                GROUP BY context\n                ORDER BY context ASC\n            ";
         $results = $this->wpdb->get_results($sql);
     } else {
         $results = $this->wpdb->get_results("\n            SELECT context, COUNT(context) AS c\n            FROM {$this->wpdb->prefix}icl_strings s\n            WHERE 1 {$extra_cond} AND TRIM(s.value) != ''\n            GROUP BY context\n            ORDER BY context ASC");
     }
     return $results;
 }

 public function get_string_translations()
 {
     $string_translations = array();
     $current_user = $this->sitepress->get_current_user();
     $active_languages = $this->sitepress->get_active_languages();
     //		error_log(serialize($active_languages), 3, WP_CONTENT_DIR . '/debug.log');
     $current_user_can_translate_strings = $this->sitepress->get_wp_helper()->current_user_can_translate_strings();
     $user_lang_pairs = $this->sitepress->get_wp_helper()->get_user_language_pairs($current_user);
     $extra_cond = "";
     if ($current_user_can_translate_strings && isset($_GET['status']) && preg_match("#" . ICL_TM_WAITING_FOR_TRANSLATOR . "-(.+)#", $_GET['status'], $matches)) {
         $status_filter = ICL_TM_WAITING_FOR_TRANSLATOR;
         $status_filter_lang = $matches[1];
         $language_code_alias = str_replace('-', '', $status_filter_lang);
         $extra_cond .= " AND str_{$language_code_alias}.language = '{$status_filter_lang}' ";
     } else {
         $status_filter = isset($_GET['status']) ? intval($_GET['status']) : false;
     }
     $search_filter = isset($_GET['search']) ? $_GET['search'] : false;
     $exact_match = isset($_GET['em']) ? $_GET['em'] == 1 : false;
     if ($status_filter !== false) {
         if ($status_filter == ICL_TM_COMPLETE) {
             $extra_cond .= " AND s.status = " . ICL_TM_COMPLETE;
         } elseif ($status_filter == ICL_TM_WAITING_FOR_TRANSLATOR) {
             // do nothing
         } else {
             $extra_cond .= " AND status IN (" . ICL_STRING_TRANSLATION_PARTIAL . "," . ICL_TM_NEEDS_UPDATE . "," . ICL_TM_NOT_TRANSLATED . "," . ICL_TM_WAITING_FOR_TRANSLATOR . ")";
         }
     }
     if ($search_filter != false) {
         if ($exact_match) {
             $extra_cond .= " AND s.value = '" . esc_sql($search_filter) . "' ";
         } else {
             $extra_cond .= " AND s.value LIKE '%" . esc_sql($search_filter) . "%' ";
         }
     }
     $context_filter = isset($_GET['context']) ? $_GET['context'] : false;
     if ($context_filter !== false) {
         $extra_cond .= " AND s.context = '" . esc_sql($context_filter) . "'";
     }
     if (isset($_GET['show_results']) && $_GET['show_results'] == 'all') {
         $limit = 9999;
         $offset = 0;
     } else {
         $limit = $this->sitepress_settings['st']['strings_per_page'];
         if (!isset($_GET['paged'])) {
             $_GET['paged'] = 1;
         }
         $offset = ($_GET['paged'] - 1) * $limit;
     }
     /* TRANSLATOR - START */
     if ($current_user_can_translate_strings) {
         if (!empty($status_filter_lang)) {
             $_joins = $_sels = $_where = array();
             foreach ($active_languages as $l) {
                 if ($l['code'] == $this->sitepress_settings['st']['strings_language']) {
                     continue;
                 }
                 $language_code_alias = esc_sql(str_replace('-', '', $l['code']));
                 $_sels[] = "str_{$language_code_alias}.id AS id_{$language_code_alias},\n\t                             str_{$language_code_alias}.status AS status_{$language_code_alias},\n\t                             str_{$language_code_alias}.value AS value_{$language_code_alias},\n\t                             str_{$language_code_alias}.translator_id AS translator_{$language_code_alias},\n\t                             str_{$language_code_alias}.translation_date AS date_{$language_code_alias}\n\t                             ";
                 $_joins[] = $this->wpdb->prepare(" LEFT JOIN {$this->wpdb->prefix}icl_string_translations str_{$language_code_alias}\n\t                                                ON str_{$language_code_alias}.string_id = s.id AND str_{$language_code_alias}.language = %s ", $l['code']);
             }
             $sql = "\n\t                SELECT SQL_CALC_FOUND_ROWS s.id AS string_id, s.language AS string_language, s.context, s.gettext_context, s.name, s.value, s.status,\n\t                    " . join(", ", $_sels) . "\n\t                FROM  {$this->wpdb->prefix}icl_strings s \n\t                " . join("\n", $_joins) . "\n\t                WHERE \n\t                    str_{$status_filter_lang}.status = %d AND\n\t                    (str_{$status_filter_lang}.translator_id IS NULL OR str_{$status_filter_lang}.translator_id = %d)\n\t                    {$extra_cond}\n\t                ORDER BY string_id DESC\n\t                LIMIT {$offset},{$limit}\n\t            ";
             $sql_prepared = $this->wpdb->prepare($sql, array(ICL_TM_WAITING_FOR_TRANSLATOR, $current_user->ID));
             $res = $this->wpdb->get_results($sql_prepared, ARRAY_A);
         } else {
             $_joins = $_sels = $_where = array();
             foreach ($active_languages as $l) {
                 if ($l['code'] == $this->sitepress_settings['st']['strings_language'] || empty($user_lang_pairs[$this->sitepress_settings['st']['strings_language']][$l['code']])) {
                     continue;
                 }
                 $language_code_alias = esc_sql(str_replace('-', '', $l['code']));
                 $_sels[] = "str_{$language_code_alias}.id AS id_{$language_code_alias},\n\t                             str_{$language_code_alias}.status AS status_{$language_code_alias},\n\t                             str_{$language_code_alias}.value AS value_{$language_code_alias},\n\t                             str_{$language_code_alias}.translator_id AS translator_{$language_code_alias},\n\t                             str_{$language_code_alias}.translation_date AS date_{$language_code_alias}\n\t                             ";
                 $_joins[] = $this->wpdb->prepare("LEFT JOIN {$this->wpdb->prefix}icl_string_translations str_{$language_code_alias}\n\t                                                ON str_{$language_code_alias}.string_id = s.id AND str_{$language_code_alias}.language = %s ", $l['code']);
                 if ($status_filter == ICL_TM_COMPLETE) {
                     $_where[] .= " AND str_{$language_code_alias}.status = " . ICL_TM_COMPLETE;
                 } else {
                     if (empty($_lwhere)) {
                         $_lwheres = array();
                         $_lwhere = ' AND (';
                         foreach ($active_languages as $l2) {
                             if ($l2['code'] == $this->sitepress_settings['st']['strings_language'] || empty($user_lang_pairs[$this->sitepress_settings['st']['strings_language']][$l2['code']])) {
                                 continue;
                             }
                             $l2code_alias = esc_sql(str_replace('-', '', $l2['code']));
                             $_lwheres[] = $this->wpdb->prepare(" str_{$l2code_alias}.status = %d\n\t                                                          OR str_{$l2code_alias}.translator_id = %d ", ICL_TM_WAITING_FOR_TRANSLATOR, $current_user->ID);
                         }
                         $_lwhere .= join(' OR ', $_lwheres) . ')';
                         $_where[] = $_lwhere;
                     }
                 }
             }
             $sql = "\n\t                SELECT SQL_CALC_FOUND_ROWS s.id AS string_id, s.language AS string_language, s.context, s.gettext_context, s.name, s.value, s.status, " . join(', ', $_sels) . "\n\t                FROM {$this->wpdb->prefix}icl_strings s " . join("\n", $_joins) . "\n\t                WHERE s.language = '{$this->sitepress_settings['st']['strings_language']}' " . join(' ', $_where) . "\n\t                    {$extra_cond}\n\t                ORDER BY s.id DESC\n\t                LIMIT {$offset},{$limit}\n\t                ";
             $res = $this->wpdb->get_results($sql, ARRAY_A);
         }
         $this->wp_query->found_posts = $this->wpdb->get_var("SELECT FOUND_ROWS()");
         $this->wp_query->query_vars['posts_per_page'] = $limit;
         $this->wp_query->max_num_pages = ceil($this->wp_query->found_posts / $limit);
         if ($res) {
             if (!empty($status_filter_lang)) {
                 foreach ($res as $row) {
//.........这里部分代码省略.........