PHP TranslationProxy::get_current_service_id方法代码示例

 /**
  * Returns a WPML readable string that allows to tell translation service and translator id
  * (typically used for translators dropdowns)
  *
  * @param int|bool $translation_service_id
  * @param int|bool $translator_id
  *
  * @return string
  */
 public static function get_wpml_translator_id($translation_service_id = false, $translator_id = false)
 {
     if ($translation_service_id === false) {
         $translation_service_id = TranslationProxy::get_current_service_id();
     }
     $result = 'ts-' . $translation_service_id;
     if ($translator_id !== false) {
         $result .= '-' . $translator_id;
     }
     return $result;
 }

 function ajax_calls($call, $data)
 {
     global $wpdb, $sitepress;
     switch ($call) {
         case 'assign_translator':
             $translator_data = TranslationProxy_Service::get_translator_data_from_wpml($data['translator_id']);
             $service_id = $translator_data['translation_service'];
             $translator_id = $translator_data['translator_id'];
             $assign_translation_job = $this->assign_translation_job($data['job_id'], $translator_id, $service_id, $data['job_type']);
             if ($assign_translation_job) {
                 $translator_edit_link = '';
                 if ($translator_id) {
                     if ($service_id == TranslationProxy::get_current_service_id()) {
                         $job = $this->get_translation_job($data['job_id']);
                         /** @var $ICL_Pro_Translation WPML_Pro_Translation */
                         global $ICL_Pro_Translation;
                         $ICL_Pro_Translation->send_post($job->original_doc_id, array($job->language_code), $translator_id, $data['job_id']);
                         $project = TranslationProxy::get_current_project();
                         $translator_edit_link = TranslationProxy_Popup::get_link($project->translator_contact_iframe_url($translator_id), array('title' => __('Contact the translator', 'sitepress'), 'unload_cb' => 'icl_thickbox_refresh')) . esc_html(TranslationProxy_Translator::get_translator_name($translator_id)) . "</a> ({$project->service}->name)";
                     } else {
                         $translator_edit_link = '<a href="' . TranslationManagement::get_translator_edit_url($data['translator_id']) . '">' . esc_html($wpdb->get_var($wpdb->prepare("SELECT display_name FROM {$wpdb->users} WHERE ID=%d", $data['translator_id']))) . '</a>';
                     }
                 }
                 echo wp_json_encode(array('error' => 0, 'message' => $translator_edit_link, 'status' => TranslationManagement::status2text(ICL_TM_WAITING_FOR_TRANSLATOR), 'service' => $service_id));
             } else {
                 echo wp_json_encode(array('error' => 1));
             }
             break;
         case 'icl_cf_translation':
         case 'icl_tcf_translation':
             if (!empty($data['cf'])) {
                 foreach ($data['cf'] as $k => $v) {
                     $cft[base64_decode($k)] = $v;
                 }
                 if (isset($cft)) {
                     $this->settings[$call === 'icl_tcf_translation' ? WPML_TERM_META_SETTING_INDEX_PLURAL : WPML_POST_META_SETTING_INDEX_PLURAL] = $cft;
                     $this->save_settings();
                 }
             }
             echo '1|';
             break;
         case 'icl_doc_translation_method':
             $this->settings['doc_translation_method'] = intval($data['t_method']);
             $sitepress->set_setting('doc_translation_method', $this->settings['doc_translation_method']);
             $sitepress->save_settings(array('hide_how_to_translate' => empty($data['how_to_translate'])));
             if (isset($data['tm_block_retranslating_terms'])) {
                 $sitepress->set_setting('tm_block_retranslating_terms', $data['tm_block_retranslating_terms']);
             } else {
                 $sitepress->set_setting('tm_block_retranslating_terms', '');
             }
             if (isset($data['tm_block_retranslating_terms'])) {
                 $sitepress->set_setting('tm_block_retranslating_terms', $data['tm_block_retranslating_terms']);
             } else {
                 $sitepress->set_setting('tm_block_retranslating_terms', '');
             }
             $this->save_settings();
             echo '1|';
             break;
         case 'reset_duplication':
             $this->reset_duplicate_flag($_POST['post_id']);
             break;
         case 'set_duplication':
             $new_id = $this->set_duplicate($_POST['wpml_original_post_id'], $_POST['post_lang']);
             wp_send_json_success(array('id' => $new_id));
             break;
         case 'make_duplicates':
             $mdata['iclpost'] = array($data['post_id']);
             $langs = explode(',', $data['langs']);
             foreach ($langs as $lang) {
                 $mdata['duplicate_to'][$lang] = 1;
             }
             $this->make_duplicates($mdata);
             do_action('wpml_new_duplicated_terms', (array) $mdata['iclpost'], false);
             break;
     }
 }

//.........这里部分代码省略.........
</th>
                        <th scope="col"><?php 
            _e('Translator', 'wpml-translation-management');
            ?>
</th>
                    </tr>
                    </thead>
                    <tfoot>
                    <tr>
                        <th scope="col"><?php 
            _e('Language', 'wpml-translation-management');
            ?>
</th>
                        <th scope="col"><?php 
            _e('Translator', 'wpml-translation-management');
            ?>
</th>
                    </tr>
                    </tfoot>
                    <?php 
            $basket_languages = TranslationProxy_Basket::get_target_languages();
            if ($basket_languages) {
                ?>
                        <tbody>
                        <?php 
                $target_languages = $sitepress->get_active_languages();
                foreach ($target_languages as $key => $lang) {
                    if (!in_array($lang['code'], $basket_languages)) {
                        unset($target_languages[$key]);
                    }
                }
                foreach ($target_languages as $lang) {
                    if ($lang['code'] === TranslationProxy_Basket::get_source_language()) {
                        continue;
                    }
                    ?>
                            <tr>
                                <td><strong><?php 
                    echo $lang['display_name'];
                    ?>
</strong></td>
                                <td>
                                    <label for="<?php 
                    echo esc_attr('translator[' . $lang['code'] . ']');
                    ?>
">
                                        <?php 
                    _e('Translate by', 'wpml-translation-management');
                    ?>
                                    </label>
                                    <?php 
                    $selected_translator = isset($icl_selected_translators[$lang['code']]) ? $icl_selected_translators[$lang['code']] : false;
                    if ($selected_translator === false) {
                        $selected_translator = TranslationProxy_Service::get_wpml_translator_id();
                    }
                    $args = array('from' => TranslationProxy_Basket::get_source_language(), 'to' => $lang['code'], 'name' => 'translator[' . $lang['code'] . ']', 'selected' => $selected_translator, 'services' => array('local', TranslationProxy::get_current_service_id()));
                    TranslationManagement::translators_dropdown($args);
                    ?>
                                    <a href="admin.php?page=<?php 
                    echo WPML_TM_FOLDER;
                    ?>
/menu/main.php&sm=translators"><?php 
                    _e('Manage translators', 'wpml-translation-management');
                    ?>
</a>
                                </td>
                            </tr>
                        <?php 
                }
                ?>
                        </tbody>
                    <?php 
            }
            ?>
                </table>
                <br>
                <?php 
            echo TranslationProxy_Basket::get_basket_extra_fields_section();
            ?>
                <?php 
            wp_nonce_field('send_basket_items_nonce', '_icl_nonce_send_basket_items');
            ?>
                <?php 
            wp_nonce_field('send_basket_item_nonce', '_icl_nonce_send_basket_item');
            ?>
                <?php 
            wp_nonce_field('send_basket_commit_nonce', '_icl_nonce_send_basket_commit');
            ?>
                <?php 
            wp_nonce_field('check_basket_name_nonce', '_icl_nonce_check_basket_name');
            ?>
                <input type="submit" class="button-primary" name="send-all-jobs-for-translation" value="<?php 
            _e('Send all items for translation', 'wpml-translation-management');
            ?>
">
            </form>
        <?php 
        }
        do_action('wpml_translation_basket_page_after');
    }

 function translation_service_authentication_ajax()
 {
     $translation_service_authentication = false;
     if (isset($_POST['nonce'])) {
         $translation_service_authentication = wp_verify_nonce($_POST['nonce'], 'translation_service_authentication');
     }
     $errors = 0;
     $message = '';
     $invalidate = isset($_POST['invalidate']) ? $_POST['invalidate'] : false;
     if ($translation_service_authentication) {
         if ($invalidate) {
             $result = TranslationProxy::invalidate_service(TranslationProxy::get_current_service_id());
             if (!$result) {
                 $message = __('Unable to invalidate this service. Please contact WPML support.', 'wpml-translation-management');
                 $errors++;
             } else {
                 $message = __('Service invalidated.', 'wpml-translation-management');
             }
         } else {
             if (isset($_POST['custom_fields'])) {
                 $custom_fields_data_serialized = $_POST['custom_fields'];
                 $custom_fields_data = json_decode(stripslashes($custom_fields_data_serialized), true);
                 $result = TranslationProxy::authenticate_service($_POST['service_id'], $custom_fields_data);
                 if (!$result) {
                     $message = __('Unable to activate this service. Please check entered data and try again.', 'wpml-translation-management');
                     $errors++;
                 } else {
                     $message = __('Service activated.', 'wpml-translation-management');
                 }
             }
         }
     } else {
         $message = __('You are not allowed to perform this action.', 'wpml-translation-management');
         $errors++;
     }
     $response = array('errors' => $errors, 'message' => $message, 'reload' => !$errors ? 1 : 0);
     echo wp_json_encode($response);
     die;
 }

 protected function get_translator_html($job)
 {
     $job = (object) $job;
     $current_service_name = TranslationProxy::get_current_service_name();
     $translation_services = array('local', TranslationProxy::get_current_service_id());
     $translator = '';
     if ($job->translation_service && $job->translation_service !== 'local') {
         try {
             $project = TranslationProxy::get_current_project();
             if ($project) {
                 if ($project->service->has_translator_selection) {
                     $translator_contact_iframe_url = $project->translator_contact_iframe_url($job->translator_id);
                     $iframe_args = array('title' => __('Contact the translator', 'wpml-translation-management'), 'unload_cb' => 'icl_thickbox_refresh');
                     $translator .= TranslationProxy_Popup::get_link($translator_contact_iframe_url, $iframe_args);
                     $translator .= esc_html($job->translator_name);
                     $translator .= "</a> (" . $current_service_name . ")";
                 } else {
                     $translator .= $current_service_name;
                 }
             } else {
                 $translator .= esc_html($job->translator_name);
             }
         } catch (Exception $e) {
             // Just doesn't create the output
         }
     } elseif ($job->status == ICL_TM_COMPLETE) {
         $translator_data = get_userdata($job->translator_id);
         $translator_name = $translator_data ? $translator_data->display_name : "";
         $translator = '<span class="icl-finished-local-name">' . $translator_name . '</span>';
     } else {
         $translator .= '<span class="icl_tj_select_translator">';
         $selected_translator = isset($job->translator_id) ? $job->translator_id : false;
         $disabled = false;
         if ($job->translation_service && $job->translation_service !== 'local' && is_numeric($job->translation_service)) {
             $selected_translator = TranslationProxy_Service::get_wpml_translator_id($job->translation_service, $job->translator_id);
             $disabled = true;
         }
         $job_id = isset($job->job_id) ? $job->job_id : $job->id;
         $local_only = isset($job->local_only) ? $job->local_only : true;
         $args = array('id' => 'icl_tj_translator_for_' . $job_id, 'name' => 'icl_tj_translator_for_' . $job_id, 'from' => $job->source_language_code, 'to' => $job->language_code, 'selected' => $selected_translator, 'services' => $translation_services, 'disabled' => $disabled, 'echo' => false, 'local_only' => $local_only);
         $translator .= TranslationManagement::translators_dropdown($args);
         $translator .= '<input type="hidden" id="icl_tj_ov_' . $job_id . '" value="' . (int) $job->translator_id . '" />';
         $translator .= '<input type="hidden" id="icl_tj_ty_' . $job_id . '" value="' . strtolower($this->get_type()) . '" />';
         $translator .= '<span class="icl_tj_select_translator_controls" id="icl_tj_tc_' . $job_id . '">';
         $translator .= '<input type="button" class="button-secondary icl_tj_ok" value="' . __('Send', 'wpml-translation-management') . '" />&nbsp;';
         $translator .= '<input type="button" class="button-secondary icl_tj_cancel" value="' . __('Cancel', 'wpml-translation-management') . '" />';
         $translator .= '</span>';
     }
     return $translator;
 }

 static function sync_cancelled()
 {
     global $wpdb, $sitepress;
     $project = TranslationProxy::get_current_project();
     $requests = $project->cancelled_jobs();
     if ($requests === false) {
         echo wp_json_encode(array('errors' => 1, 'message' => 'Failed fetching jobs list from the server.'));
         exit;
     }
     $cms_ids = array();
     if (!empty($requests)) {
         foreach ($requests as $request) {
             $cms_ids[] = $request->cms_id;
         }
     }
     // get jobs that are in progress
     $translations_sql = "\n                SELECT t.element_id, t.element_type, t.language_code, t.source_language_code, t.trid,\n                    s.rid, s._prevstate, s.translation_id\n                FROM {$wpdb->prefix}icl_translation_status s\n                JOIN {$wpdb->prefix}icl_translations t\n                    ON t.translation_id = s.translation_id\n                WHERE s.translation_service=%s\n                AND s.status = %d\n            ";
     $translations_prepared = $wpdb->prepare($translations_sql, array(TranslationProxy::get_current_service_id(), ICL_TM_IN_PROGRESS));
     $translations = $wpdb->get_results($translations_prepared);
     $jobs2delete = array();
     $translations2cancel = array();
     foreach ($translations as $t) {
         $original_id_sql = "SELECT element_id FROM {$wpdb->prefix}icl_translations\n                                     WHERE trid=%d AND source_language_code IS NULL";
         $original_id_prepared = $wpdb->prepare($original_id_sql, $t->trid);
         $original_id = $wpdb->get_var($original_id_prepared);
         $cms_id = sprintf('%s_%d_%s_%s', preg_replace('#^post_#', '', $t->element_type), $original_id, $t->source_language_code, $t->language_code);
         if (in_array($cms_id, $cms_ids)) {
             $_lang_details = $sitepress->get_language_details($t->source_language_code);
             $lang_from = $_lang_details['english_name'];
             $_lang_details = $sitepress->get_language_details($t->language_code);
             $lang_to = $_lang_details['english_name'];
             $jobs2delete[] = '<a href="' . get_permalink($original_id) . '">' . get_the_title($original_id) . '</a>' . sprintf(' - from %s to %s', $lang_from, $lang_to);
             $translations2cancel[] = $t;
         }
     }
     $response_message = '';
     if ($jobs2delete && $translations2cancel) {
         $response_message .= '<div class="error clear" style="padding-top:5px;font-size:11px;">';
         $response_message .= __('About to cancel these jobs:', 'sitepress');
         $response_message .= '<br />';
         $response_message .= '<ul style="margin-left:10px;">';
         $response_message .= '<li>';
         $response_message .= join('</li><li>', $jobs2delete);
         $response_message .= '</li>';
         $response_message .= '</ul>';
         $response_message .= '<br />';
         $response_message .= '<a id="icl_ts_cancel_ok" href="#" class="button-secondary">';
         $response_message .= __('OK', 'sitepress');
         $response_message .= '</a>&nbsp;';
         $response_message .= '<a id="icl_ts_cancel_cancel" href="#" class="button-secondary">';
         $response_message .= __('Cancel', 'sitepress');
         $response_message .= '</a>';
         $response_message .= '</div>';
         $response_errors = 0;
         $response_data = array('t2c' => serialize($translations2cancel));
     } elseif ($project->errors) {
         $response_message = join('<br/>', $project->errors);
         $response_errors = count($project->errors);
         $response_data = false;
     } else {
         $response_message = __('Nothing to cancel.', 'sitepress');
         $response_errors = 0;
         $response_data = false;
     }
     $response = array('errors' => $response_errors, 'message' => $response_message, 'data' => $response_data);
     echo wp_json_encode($response);
     die;
 }

 public static function translators_dropdown($args = array())
 {
     $dropdown = '';
     /** @var $from string|false */
     /** @var $to string|false */
     /** @var $classes string|false */
     /** @var $id string|false */
     /** @var $name string|false */
     /** @var $selected bool */
     /** @var $echo bool */
     /** @var $add_label bool */
     /** @var $services array */
     /** @var $show_service bool */
     /** @var $disabled bool */
     /** @var $default_name bool|string */
     /** @var $local_only bool */
     //set default value for variables
     $from = false;
     $to = false;
     $id = 'translator_id';
     $name = 'translator_id';
     $selected = 0;
     $echo = true;
     $add_label = false;
     $services = array('local');
     $show_service = true;
     $disabled = false;
     $default_name = false;
     $local_only = false;
     extract($args, EXTR_OVERWRITE);
     $translators = array();
     try {
         $translation_service = TranslationProxy::get_current_service();
         $translation_service_id = TranslationProxy::get_current_service_id();
         $translation_service_name = TranslationProxy::get_current_service_name();
         $is_service_authenticated = TranslationProxy::is_service_authenticated();
         //if translation service does not support translators choice, always shows first available
         if (isset($translation_service->id) && !TranslationProxy::translator_selection_available() && $is_service_authenticated) {
             $translators[] = (object) array('ID' => TranslationProxy_Service::get_wpml_translator_id($translation_service->id), 'display_name' => __('First available', 'sitepress'), 'service' => $translation_service_name);
         } elseif (in_array($translation_service_id, $services) && $is_service_authenticated) {
             $lang_status = TranslationProxy_Translator::get_language_pairs();
             if (empty($lang_status)) {
                 $lang_status = array();
             }
             foreach ((array) $lang_status as $language_pair) {
                 if ($from && $from != $language_pair['from']) {
                     continue;
                 }
                 if ($to && $to != $language_pair['to']) {
                     continue;
                 }
                 if (!empty($language_pair['translators'])) {
                     if (1 < count($language_pair['translators'])) {
                         $translators[] = (object) array('ID' => TranslationProxy_Service::get_wpml_translator_id($translation_service->id), 'display_name' => __('First available', 'sitepress'), 'service' => $translation_service_name);
                     }
                     foreach ($language_pair['translators'] as $tr) {
                         if (!isset($_icl_translators[$tr['id']])) {
                             $translators[] = $_icl_translators[$tr['id']] = (object) array('ID' => TranslationProxy_Service::get_wpml_translator_id($translation_service->id, $tr['id']), 'display_name' => $tr['nickname'], 'service' => $translation_service_name);
                         }
                     }
                 }
             }
         }
         if (in_array('local', $services)) {
             $translators[] = (object) array('ID' => 0, 'display_name' => __('First available', 'sitepress'));
             $translators = array_merge($translators, self::get_blog_translators(array('from' => $from, 'to' => $to)));
         }
         $translators = apply_filters('wpml_tm_translators_list', $translators);
         $dropdown .= '<select id="' . esc_attr($id) . '" name="' . esc_attr($name) . '" ' . ($disabled ? 'disabled="disabled"' : '') . '>';
         if ($default_name) {
             $dropdown_selected = selected($selected, false, false);
             $dropdown .= '<option value="" ' . $dropdown_selected . '>';
             $dropdown .= esc_html($default_name);
             $dropdown .= '</option>';
         }
         foreach ($translators as $t) {
             if ($local_only && isset($t->service)) {
                 continue;
             }
             $current_translator = $t->ID;
             $dropdown_selected = selected($selected, $current_translator, false);
             $dropdown .= '<option value="' . $current_translator . '" ' . $dropdown_selected . '>';
             $dropdown .= esc_html($t->display_name);
             if ($show_service) {
                 $dropdown .= ' (';
                 $dropdown .= isset($t->service) ? $t->service : __('Local', 'sitepress');
                 $dropdown .= ')';
             }
             $dropdown .= '</option>';
         }
         $dropdown .= '</select>';
     } catch (TranslationProxy_Api_Error $ex) {
         $dropdown .= __('Translation Proxy error', 'sitepress') . ': ' . $ex->getMessage();
     } catch (Exception $ex) {
         $dropdown .= __('Error', 'sitepress') . ': ' . $ex->getMessage();
     }
     if ($add_label) {
         $dropdown = '<label for="' . esc_attr($id) . '">' . __('Translation jobs for:', 'wpml-translation-management') . '</label>&nbsp;' . $dropdown;
     }
     if ($echo) {
//.........这里部分代码省略.........

 function get_strings_in_progress()
 {
     global $wpdb;
     $strings_in_progress_snipped = wpml_prepare_in(array(ICL_TM_IN_PROGRESS, ICL_TM_WAITING_FOR_TRANSLATOR), '%d');
     $strings_in_progress_sql = "\tSELECT COUNT(*)\n\t\t\t\t\t\t\t\t\t\t\tFROM {$wpdb->prefix}icl_string_translations\n\t\t\t\t\t\t\t\t\t\t\tWHERE status IN ({$strings_in_progress_snipped})\n\t\t\t\t\t\t\t\t\t\t\t\tAND translation_service = %d";
     $strings_in_progress_prepared = $wpdb->prepare($strings_in_progress_sql, TranslationProxy::get_current_service_id());
     $strings_in_progress = $wpdb->get_var($strings_in_progress_prepared);
     return $strings_in_progress;
 }

 function translation_service_toggle_ajax()
 {
     $translation_service_toggle = false;
     if (isset($_POST['nonce'])) {
         $translation_service_toggle = wp_verify_nonce($_POST['nonce'], 'translation_service_toggle');
     }
     $errors = 0;
     $message = '';
     if ($translation_service_toggle) {
         $service_id = false;
         if (isset($_POST['service_id'])) {
             $service_id = $_POST['service_id'];
         }
         $enable = false;
         if (isset($_POST['enable'])) {
             $enable = $_POST['enable'];
         }
         if (!$service_id) {
             return;
         }
         if ($enable && TranslationProxy::get_current_service_id() != $service_id) {
             $result = TranslationProxy::select_service($service_id);
             if (is_wp_error($result)) {
                 $message = $result->get_error_message();
             }
         }
         if (!$enable && TranslationProxy::get_current_service_id() == $service_id) {
             TranslationProxy::deselect_active_service();
         }
     } else {
         $message = __('You are not allowed to perform this action.', 'wpml-translation-management');
         $errors++;
     }
     $response = array('errors' => $errors, 'message' => $message, 'reload' => !$errors ? 1 : 0);
     echo wp_json_encode($response);
     die;
 }

 /**
  * @return bool
  */
 private function must_show_incomplete_jobs_notice()
 {
     return $this->is_jobs_tab() && TranslationProxy::get_current_service_id() && !$this->service_activation_incomplete() && !$this->service_activation_ajax->get_ignore_local_jobs();
 }

<script type="text/html" id="table-listing-filter">
	<?php 
global $iclTranslationManagement, $sitepress, $wpdb;
$translation_services = array('local', TranslationProxy::get_current_service_id());
$args = array('name' => 'filter[translator_id]', 'default_name' => __('All', 'wpml-translation-management'), 'selected' => isset($icl_translation_filter['translator_id']) ? $icl_translation_filter['translator_id'] : '', 'services' => $translation_services, 'add_label' => true);
$blog_translators = wpml_tm_load_blog_translators();
$translators_dropdown = new WPML_TM_Translators_Dropdown($blog_translators);
$translators_dropdown->render($args);
?>
	&nbsp;	<label for="filter-job-status">
		<?php 
_e('Status', 'wpml-translation-management');
?>
</label>&nbsp;		<select id="filter-job-status" name="filter[status]">
		<option value=""><?php 
_e('All translation jobs', 'wpml-translation-management');
?>
</option>
		<option value="<?php 
echo ICL_TM_WAITING_FOR_TRANSLATOR;
?>
"><?php 
echo TranslationManagement::status2text(ICL_TM_WAITING_FOR_TRANSLATOR);
?>
</option>
		<option value="<?php 
echo ICL_TM_IN_PROGRESS;
?>
"><?php 
echo TranslationManagement::status2text(ICL_TM_IN_PROGRESS);
?>

 private function belongs_to_active_ts()
 {
     global $wpdb;
     $service_id = TranslationProxy::get_current_service_id();
     $batch_id = $this->get_id();
     $result = false;
     if ($service_id) {
         $result = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translation_status WHERE batch_id = %d AND translation_service = %s LIMIT 1", array($batch_id, $service_id)));
         $result |= $wpdb->get_var($wpdb->prepare("SELECT id FROM {$wpdb->prefix}icl_string_translations WHERE batch_id = %d AND translation_service = %s LIMIT 1", array($batch_id, $service_id)));
     }
     return $result;
 }

 /**
  * Get all string jobs sent to remote translation service
  * This function takes the same input array as does $iclTranslationManagement->get_translation_jobs
  * 'from' should contain the language code for the source of the translation job
  * 'to' specifies the target language code
  * 'status' follows the same conventions as for normal jobs so 1 and 2 are waiting for translator and 10 is
  * complete. Other values are not supported for strings at this point and will lead to empty results
  *
  * @param array   $args
  * @param bool    $only_ids
  *
  * @return array Array of jobs, every job is object
  * @global object $wpdb
  * @global object $sitepress
  *
  */
 public function get_strings_jobs($args = array(), $only_ids = false)
 {
     global $wpdb, $sitepress;
     $translator_id = "";
     $from = "";
     $to = "";
     $status = "";
     $service = false;
     extract($args, EXTR_OVERWRITE);
     $where = !empty($from) ? $wpdb->prepare(" AND sc.language = %s ", $from) : '';
     $where .= !empty($to) ? $wpdb->prepare(" AND st.language = %s ", $to) : '';
     $where .= $status ? $where .= $wpdb->prepare(" AND st.status = %d ", $status == ICL_TM_IN_PROGRESS ? ICL_TM_WAITING_FOR_TRANSLATOR : $status) : '';
     $service = is_numeric($translator_id) ? 'local' : $service;
     $service = $service !== 'local' && strpos($translator_id, "ts-") !== false ? substr($translator_id, 3) : $service;
     $where .= $service === 'local' ? $wpdb->prepare(" AND st.translator_id = %s ", $translator_id) : '';
     $where .= $service !== false ? $wpdb->prepare(" AND st.translation_service = %s ", $service) : '';
     $cols = "st.id, tb.id AS batch_id" . ($only_ids === false ? ",\n                         s.language AS source_language_code,\n                         st.language AS language_code,\n                         st.status,\n                         st.string_id,\n                         s.name,\n                         s.value,\n                         tb.id AS batch_id,\n                         st.translation_service,\n                         st.translator_id,\n                         u.display_name as translator_name,\n                         COUNT( st.id ) as strings_count" : "");
     $query = "\tSELECT\n\t\t\t\t\t{$cols}\n\t\t\t\t\tFROM {$wpdb->prefix}icl_string_translations AS st\n\t\t\t\t\tINNER JOIN {$wpdb->prefix}icl_strings AS s\n\t\t\t\t\t\tON st.string_id = s.id\n\t\t\t\t\tINNER JOIN {$wpdb->prefix}icl_translation_batches AS tb\n\t\t\t\t\t\tON tb.id = st.batch_id\n\t\t\t\t\tLEFT JOIN {$wpdb->users} u\n\t\t\t\t      ON st.translator_id = u.ID\n\t\t\t\t\tWHERE 1 {$where}\n\t\t\t\t\tGROUP BY st.id, s.id";
     $result = $wpdb->get_results($query);
     if ($only_ids === false) {
         foreach ($result as $num => $value) {
             $lang_from = $sitepress->get_language_details($value->source_language_code);
             $lang_to = $sitepress->get_language_details($value->language_code);
             $lang_text = $lang_from['display_name'] . ' » ' . $lang_to['display_name'];
             $result[$num]->lang_text = $lang_text;
             if ($value->translation_service == TranslationProxy::get_current_service_id()) {
                 $result[$num]->translator_name = TranslationProxy_Translator::get_translator_name($value->translator_id);
             }
         }
     }
     return $result;
 }