<?php if (isset($icl_string['translations'][$lang['code']]) && $icl_string['translations'][$lang['code']]['status'] == ICL_STRING_TRANSLATION_COMPLETE) { $tr_complete_checked = 'checked="checked"'; } else { if (icl_st_is_translator()) { global $current_user; get_currentuserinfo(); $user_lang_pairs = get_user_meta(get_current_user_id(), $wpdb->prefix . 'language_pairs', true); if (empty($user_lang_pairs[$sitepress_settings['st']['strings_language']][$lang['code']])) { continue; } } $tr_complete_checked = ''; } if (icl_st_is_translator()) { $icl_pro_status = $wpdb->get_var($wpdb->prepare("\n SELECT c.status FROM {$wpdb->prefix}icl_core_status c\n JOIN {$wpdb->prefix}icl_string_status s ON s.rid = c.rid\n WHERE s.string_translation_id = %d AND target=%s AND status = %d\n ORDER BY s.id DESC LIMIT 1\n ", $icl_string['string_id'], $lang['code'], CMS_TARGET_LANGUAGE_ASSIGNED)); if (isset($icl_string['translations'][$lang['code']]) && ($icl_string['translations'][$lang['code']]['translator_id'] == get_current_user_id() || is_null($icl_string['translations'][$lang['code']]['translator_id']) && $icl_string['translations'][$lang['code']]['status'] == ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR && !$icl_pro_status)) { $form_disabled = ''; } else { $form_disabled = ' disabled="disabled" '; } } else { $form_disabled = ''; } ?> <form class="icl_st_form" name="icl_st_form_<?php echo $lang['code'] . '_' . $string_id; ?> " action="">
function icl_st_get_contexts($status) { global $wpdb, $sitepress, $sitepress_settings; $extra_cond = ''; $joins = ''; $results = false; $current_user = $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, $wpdb->prefix . 'language_pairs', true); $active_langs = $sitepress->get_active_languages(); if (!empty($user_langs[$sitepress_settings['st']['strings_language']])) { foreach ($user_langs[$sitepress_settings['st']['strings_language']] as $lang => $one) { if (isset($active_langs[$lang])) { $lcode_alias = esc_sql(str_replace('-', '', $lang)); $joins[] = $wpdb->prepare(" JOIN {$wpdb->prefix}icl_string_translations {$lcode_alias}_str\r\n ON {$lcode_alias}_str.string_id = s.id AND {$lcode_alias}_str.language= %s\r\n AND\r\n ( \r\n {$lcode_alias}_str.status = " . ICL_TM_WAITING_FOR_TRANSLATOR . " OR {$lcode_alias}_str.translator_id = %d ) ", $lcode_alias, $current_user->ID); } } $sql = "\r\n SELECT s.context, COUNT(s.context) AS c FROM {$wpdb->prefix}icl_strings s\r\n " . join("\n", $joins) . "\r\n WHERE 1 {$extra_cond} \r\n GROUP BY context\r\n ORDER BY context ASC\r\n "; $results = $wpdb->get_results($sql); } } else { $results = $wpdb->get_results($wpdb->prepare("\r\n SELECT context, COUNT(context) AS c\r\n FROM {$wpdb->prefix}icl_strings s\r\n WHERE language=%s {$extra_cond}\r\n GROUP BY context \r\n ORDER BY context ASC", $sitepress_settings['st']['strings_language'])); } return $results; }
function ajax_calls($call, $data) { global $sitepress; switch ($call) { case 'icl_st_save_translation': $icl_st_complete = isset($data['icl_st_translation_complete']) ? $data['icl_st_translation_complete'] : ICL_STRING_TRANSLATION_NOT_TRANSLATED; if (get_magic_quotes_gpc()) { $data = stripslashes_deep($data); } if (icl_st_is_translator()) { $translator_id = get_current_user_id() > 0 ? get_current_user_id() : null; } else { $translator_id = null; } echo icl_add_string_translation($data['icl_st_string_id'], $data['icl_st_language'], stripslashes($data['icl_st_translation']), $icl_st_complete, $translator_id); echo '|'; global $icl_st_string_translation_statuses; $ts = icl_update_string_status($data['icl_st_string_id']); if (icl_st_is_translator()) { $ts = icl_get_relative_translation_status($data['icl_st_string_id'], $translator_id); } echo $icl_st_string_translation_statuses[$ts]; break; case 'icl_st_delete_strings': $arr = explode(',', $data['value']); __icl_unregister_string_multi($arr); break; /* case 'icl_st_send_strings': $arr = explode(',',$data['strings']); icl_translation_send_strings($arr, explode('#',$data['languages'])); echo '1'; break; case 'icl_st_send_strings_all': icl_translation_send_untranslated_strings(explode(',',$data['languages'])); echo '1'; break; */ // OBSOLETE? /* case 'icl_st_send_strings': $arr = explode(',',$data['strings']); icl_translation_send_strings($arr, explode('#',$data['languages'])); echo '1'; break; case 'icl_st_send_strings_all': icl_translation_send_untranslated_strings(explode(',',$data['languages'])); echo '1'; break; */ // OBSOLETE? case 'icl_st_option_writes_form': if (!empty($data['icl_admin_options'])) { icl_register_admin_options($data['icl_admin_options']); echo '1|'; } else { echo '0' . __('No strings selected', 'wpml-string-translation'); } break; // OBSOLETE? // OBSOLETE? case 'icl_st_ow_export': // filter empty options out do { list($data['icl_admin_options'], $empty_found) = _icl_st_filter_empty_options_out($data['icl_admin_options']); } while ($empty_found); if (!empty($data['icl_admin_options'])) { foreach ($data['icl_admin_options'] as $k => $opt) { if (!$opt) { unset($data['icl_admin_options'][$k]); } } $message = __('Include the following PHP in your code. <em>functions.php</em> would be a good place.', 'wpml-string-translation') . "<textarea wrap=\"soft\"><?php\r\n if (function_exists('wpml_register_admin_strings')) {\r\n wpml_register_admin_strings('" . serialize($data['icl_admin_options']) . "');\r\n }\r\n ?></textarea>"; } else { $error = 1; $message = __('Error: no strings selected', 'wpml-string-translation'); } echo json_encode(array('error' => 0, 'message' => $message)); break; } }
function ajax_calls($call, $data) { require_once WPML_ST_PATH . '/inc/admin-texts/wpml-admin-text-configuration.php'; switch ($call) { case 'icl_st_save_translation': $icl_st_complete = isset($data['icl_st_translation_complete']) && $data['icl_st_translation_complete'] ? ICL_TM_COMPLETE : ICL_TM_NOT_TRANSLATED; if (get_magic_quotes_gpc()) { $data = stripslashes_deep($data); } if (icl_st_is_translator()) { $translator_id = get_current_user_id() > 0 ? get_current_user_id() : null; } else { $translator_id = null; } echo icl_add_string_translation($data['icl_st_string_id'], $data['icl_st_language'], stripslashes($data['icl_st_translation']), $icl_st_complete, $translator_id); echo '|'; $ts = icl_update_string_status($data['icl_st_string_id']); if (icl_st_is_translator()) { $ts = icl_get_relative_translation_status($data['icl_st_string_id']); } echo WPML_ST_String_Statuses::get_status($ts); break; case 'icl_st_delete_strings': $arr = explode(',', $data['value']); __icl_unregister_string_multi($arr); break; case 'icl_st_option_writes_form': if (!empty($data['icl_admin_options'])) { $wpml_admin_text = wpml_st_load_admin_texts(); $wpml_admin_text->icl_register_admin_options($data['icl_admin_options']); echo '1|'; } else { echo '0' . __('No strings selected', 'wpml-string-translation'); } break; case 'icl_st_ow_export': // filter empty options out do { list($data['icl_admin_options'], $empty_found) = _icl_st_filter_empty_options_out($data['icl_admin_options']); } while ($empty_found); if (!empty($data['icl_admin_options'])) { foreach ($data['icl_admin_options'] as $k => $opt) { if (!$opt) { unset($data['icl_admin_options'][$k]); } } $wpml_admin_text_config = new WPML_Admin_Text_Configuration(); $message = __('Save the following to a wpml-config.xml in the root of your theme or plugin.', 'wpml-string-translation') . "<textarea wrap=\"soft\" spellcheck=\"false\">" . htmlentities($wpml_admin_text_config->get_wpml_config_file($data['icl_admin_options'])) . "</textarea>"; } else { $message = __('Error: no strings selected', 'wpml-string-translation'); } echo json_encode(array('error' => 0, 'message' => $message)); break; } }
function icl_st_get_contexts($status) { global $wpdb, $sitepress, $sitepress_settings; $extra_cond = ''; if ($status !== false) { if ($status == ICL_STRING_TRANSLATION_COMPLETE) { $extra_cond .= " AND s.status = " . ICL_STRING_TRANSLATION_COMPLETE; } else { $extra_cond .= " AND s.status IN (" . ICL_STRING_TRANSLATION_PARTIAL . "," . ICL_STRING_TRANSLATION_NEEDS_UPDATE . "," . ICL_STRING_TRANSLATION_NOT_TRANSLATED . ")"; } } if (icl_st_is_translator()) { $user_langs = get_user_meta(get_current_user_id(), $wpdb->prefix . 'language_pairs', true); $active_langs = $sitepress->get_active_languages(); if (!empty($user_langs[$sitepress_settings['st']['strings_language']])) { foreach ($user_langs[$sitepress_settings['st']['strings_language']] as $lang => $one) { if (isset($active_langs[$lang])) { $lcode_alias = str_replace('-', '', $lang); $joins[] = " JOIN {$wpdb->prefix}icl_string_translations {$lcode_alias}_str ON {$lcode_alias}_str.string_id = s.id AND {$lcode_alias}_str.language='{$lcode_alias}'\n"; } } $sql = "\n SELECT s.context, COUNT(s.context) AS c FROM {$wpdb->prefix}icl_strings s\n " . join("\n", $joins) . "\n WHERE 1 {$extra_cond} \n GROUP BY context\n ORDER BY context ASC\n "; $results = $wpdb->get_results($sql); } } else { $results = $wpdb->get_results("\n SELECT context, COUNT(context) AS c \n FROM {$wpdb->prefix}icl_strings s\n WHERE language='{$sitepress->get_current_language()}' {$extra_cond}\n GROUP BY context \n ORDER BY context ASC"); } return $results; }
private function get_translation_form_status($icl_string, $lang) { global $wpdb; $form_disabled = ''; $form_disabled_reason = ''; if (icl_st_is_translator()) { // Determine if string is being translated via Translation Proxy $translation_proxy_status = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\tSELECT c.status FROM {$wpdb->prefix}icl_core_status c \n\t\t\t\t\t\tJOIN {$wpdb->prefix}icl_string_status s ON s.rid = c.rid\n\t\t\t\t\t\tWHERE s.string_translation_id = (SELECT id FROM {$wpdb->prefix}icl_string_translations WHERE string_id=%d AND language=%s) AND c.target=%s AND c.status = %d\n\t\t\t\t\t\tORDER BY s.id DESC LIMIT 1\n\t\t\t\t", $icl_string['string_id'], $lang['code'], $lang['code'], ICL_TM_WAITING_FOR_TRANSLATOR)); $can_translate = isset($icl_string['translations'][$lang['code']]); if (!$can_translate) { $form_disabled_reason = __("You can't translate this string because it hasn't been sent for translation in this language", 'wpml-string-translation'); } $translator_id = $can_translate ? $icl_string['translations'][$lang['code']]['translator_id'] : null; if ($can_translate && $translator_id != 0 && $translator_id != get_current_user_id()) { $can_translate = false; $form_disabled_reason = __("You can't translate this string because it's assigned to another translator", 'wpml-string-translation'); } if ($can_translate && ($translator_id == 0 && $icl_string['translations'][$lang['code']]['status'] == ICL_TM_WAITING_FOR_TRANSLATOR && $translation_proxy_status)) { $can_translate = false; $form_disabled_reason = __("You can't translate this string because it's assigned to another translator", 'wpml-string-translation'); } if (!$can_translate) { $form_disabled = ' disabled="disabled" '; } } return array($form_disabled, $form_disabled_reason); }
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; }