/htdocs/wp-content/plugins/sitepress-multilingual-cms/inc/translation-management/translation-management.class.php

Large files files are truncated, but you can click here to view the full file

<?php
define ( 'ICL_TM_NOT_TRANSLATED', 0);
define ( 'ICL_TM_WAITING_FOR_TRANSLATOR', 1);
define ( 'ICL_TM_IN_PROGRESS', 2);
define ( 'ICL_TM_NEEDS_UPDATE', 3);  //virt. status code (based on needs_update)
define ( 'ICL_TM_DUPLICATE', 9);
define ( 'ICL_TM_COMPLETE', 10);

define('ICL_TM_NOTIFICATION_NONE', 0);
define('ICL_TM_NOTIFICATION_IMMEDIATELY', 1);
define('ICL_TM_NOTIFICATION_DAILY', 2);    

define('ICL_TM_TMETHOD_MANUAL', 0);    
define('ICL_TM_TMETHOD_EDITOR', 1);    
define('ICL_TM_TMETHOD_PRO', 2);    

define('ICL_TM_DOCS_PER_PAGE', 20);    


$asian_languages = array('ja', 'ko', 'zh-hans', 'zh-hant', 'mn', 'ne', 'hi', 'pa', 'ta', 'th');
  
class TranslationManagement{
    
    private $selected_translator = array('ID'=>0);
    private $current_translator = array('ID'=>0);
    public $messages = array();    
    public $dashboard_select = array();
    public $settings;
    public $admin_texts_to_translate = array();
    
    function __construct(){
        add_action('init', array($this, 'init'), 15);
        
        if(isset($_GET['icl_tm_message'])){
            $this->messages[] = array(
                'type' => isset($_GET['icl_tm_message_type']) ? $_GET['icl_tm_message_type'] : 'updated',
                'text'  => $_GET['icl_tm_message']
            );        
        }
        
        add_action('save_post', array($this, 'save_post_actions'), 11, 2); // calling *after* the Sitepress actions
        
        add_action('delete_post', array($this, 'delete_post_actions'), 1, 1); // calling *before* the Sitepress actions
        
        add_action('icl_ajx_custom_call', array($this, 'ajax_calls'), 10, 2);
        add_action('wp_ajax_show_post_content', array($this, '_show_post_content'));
                
        if(isset($_GET['sm']) && ($_GET['sm'] == 'dashboard' || $_GET['sm'] == 'jobs')){@session_start();}
        elseif(isset($_GET['page']) && preg_match('@/menu/translations-queue\.php$@', $_GET['page'])){@session_start();}
        add_filter('icl_additional_translators', array($this, 'icl_additional_translators'), 99, 3);
        
        add_filter('icl_translators_list', array($this, 'icanlocalize_translators_list'));
        
        add_action('user_register', array($this, 'clear_cache'));
        add_action('profile_update', array($this, 'clear_cache'));
        add_action('delete_user', array($this, 'clear_cache'));
        add_action('added_existing_user', array($this, 'clear_cache'));
        add_action('remove_user_from_blog', array($this, 'clear_cache'));
        
        add_action('admin_print_scripts', array($this, '_inline_js_scripts'));
        
        add_action('wp_ajax_icl_tm_user_search', array($this, '_user_search'));
        
    }
    
    function save_settings(){
        global $sitepress;
        $iclsettings['translation-management'] = $this->settings;
        $sitepress->save_settings($iclsettings);    
    }
    
    function init(){
        
        global $wpdb, $current_user, $sitepress_settings, $sitepress, $pagenow;

        $this->settings =& $sitepress_settings['translation-management'];
        
        //logic for syncing comments
        if($sitepress->get_option('sync_comments_on_duplicates')){
            add_action('delete_comment', array($this, 'duplication_delete_comment'));
            add_action('edit_comment', array($this, 'duplication_edit_comment'));
            add_action('wp_set_comment_status', array($this, 'duplication_status_comment'), 10, 2);
            add_action('wp_insert_comment', array($this, 'duplication_insert_comment'), 100);
        }
        
        $this->initial_custom_field_translate_states();
        
        // defaults
        if(!isset($this->settings['notification']['new-job'])) $this->settings['notification']['new-job'] = ICL_TM_NOTIFICATION_IMMEDIATELY;
        if(!isset($this->settings['notification']['completed'])) $this->settings['notification']['completed'] = ICL_TM_NOTIFICATION_IMMEDIATELY;
        if(!isset($this->settings['notification']['resigned'])) $this->settings['notification']['resigned'] = ICL_TM_NOTIFICATION_IMMEDIATELY;
        if(!isset($this->settings['notification']['dashboard'])) $this->settings['notification']['dashboard'] = true;
        if(!isset($this->settings['notification']['purge-old'])) $this->settings['notification']['purge-old'] = 7;
        
        if(!isset($this->settings['custom_fields_translation'])) $this->settings['custom_fields_translation'] = array();
        if(!isset($this->settings['doc_translation_method'])) $this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
        
        get_currentuserinfo();
        if(isset($current_user->ID)){
            $user = new WP_User($current_user->ID);    
        }
        
        if(empty($user->data)) return;
        
        $ct['translator_id'] =  $current_user->ID;
        $ct['display_name'] =  isset($user->data->display_name) ? $user->data->display_name : $user->data->user_login;
        $ct['user_login'] =  $user->data->user_login;
        $ct['language_pairs'] = get_user_meta($current_user->ID, $wpdb->prefix.'language_pairs', true);    
        if(empty($ct['language_pairs'])) $ct['language_pairs'] = array();
        
        $this->current_translator = (object)$ct;

        $this->load_config_pre_process();            
        $this->load_plugins_wpml_config();
        $this->load_theme_wpml_config();
        $this->load_config_post_process();
                
        if(isset($_POST['icl_tm_action'])){
            $this->process_request($_POST['icl_tm_action'], $_POST);
        }elseif(isset($_GET['icl_tm_action'])){
            $this->process_request($_GET['icl_tm_action'], $_GET);
        }        
        
        //$this->load_plugins_wpml_config();
        //$this->load_theme_wpml_config();
        
        if($GLOBALS['pagenow']=='edit.php'){ // use standard WP admin notices
            add_action('admin_notices', array($this, 'show_messages'));    
        }else{                               // use custom WP admin notices
            add_action('icl_tm_messages', array($this, 'show_messages'));            
        }
        
        if(isset($_GET['page']) && basename($_GET['page']) == 'translations-queue.php' && isset($_GET['job_id'])){
            add_filter('admin_head',array($this, '_show_tinyMCE'));                
        }
                
        
        //if(!isset($this->settings['doc_translation_method'])){        
        if(isset($this->settings['doc_translation_method']) && $this->settings['doc_translation_method'] < 0 ){
            if(isset($_GET['sm']) && $_GET['sm']=='mcsetup' && isset($_GET['src']) && $_GET['src']=='notice'){
                        $this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
                        $this->save_settings();
            }else{
                add_action('admin_notices', array($this, '_translation_method_notice'));    
            }                        
        }
                
        if(defined('WPML_TM_VERSION') && isset($_GET['page']) && $_GET['page'] == WPML_TM_FOLDER. '/menu/main.php' && isset($_GET['sm']) && $_GET['sm'] == 'translators'){
            $iclsettings =& $sitepress_settings;
            $sitepress->get_icl_translator_status($iclsettings);
            $sitepress->save_settings($iclsettings);
        }
        
        // default settings
        if(empty($this->settings['doc_translation_method']) || !defined('WPML_TM_VERSION')){
            $this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
        }        
    }

    function initial_custom_field_translate_states() {
        global $wpdb;
        
        $cf_keys_limit = 1000; // jic
        $custom_keys = $wpdb->get_col( "
            SELECT meta_key
            FROM $wpdb->postmeta
            GROUP BY meta_key
            ORDER BY meta_key
            LIMIT $cf_keys_limit" );

        $changed = false;
        
        foreach($custom_keys as $cfield) {
            if(empty($this->settings['custom_fields_translation'][$cfield]) || $this->settings['custom_fields_translation'][$cfield] == 0) {
                // see if a plugin handles this field
                $override = apply_filters('icl_cf_translate_state', 'nothing', $cfield);
                switch($override) {
                    case 'nothing':
                        break;
                    
                    case 'ignore':
                        $changed = true;
                        $this->settings['custom_fields_translation'][$cfield] = 3;
                        break;
                    
                    case 'translate':
                        $changed = true;
                        $this->settings['custom_fields_translation'][$cfield] = 2;
                        break;
                    
                    case 'copy':
                        $changed = true;
                        $this->settings['custom_fields_translation'][$cfield] = 1;
                        break;
                }

            }
        }
        if ($changed) {
            $this->save_settings();
        }
    }
    
    function _translation_method_notice(){
        echo '<div class="error fade"><p id="icl_side_by_site">'.sprintf(__('New - side-by-site translation editor: <a href="%s">try it</a> | <a href="#cancel">no thanks</a>.', 'sitepress'),
                admin_url('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=mcsetup&src=notice')) . '</p></div>';    
    }
    
    function _show_tinyMCE() {
        wp_print_scripts('editor');
        //add_filter('the_editor', array($this, 'editor_directionality'), 9999);
        add_filter('tiny_mce_before_init', array($this, '_mce_set_direction'), 9999);        
        add_filter('mce_buttons', array($this, '_mce_remove_fullscreen'), 9999);                    
        
        if (version_compare($GLOBALS['wp_version'], '3.1.4', '<=') && function_exists('wp_tiny_mce')) 
        try{
            @wp_tiny_mce();
        } catch(Exception $e) {  /*don't do anything with this */ }
    }    
    
    function _mce_remove_fullscreen($options){
        foreach($options as $k=>$v) if($v == 'fullscreen') unset($options[$k]);
        return $options;
    }
    
    function _inline_js_scripts(){
        // remove fullscreen mode
        if(defined('WPML_TM_FOLDER') && isset($_GET['page']) && $_GET['page'] == WPML_TM_FOLDER . '/menu/translations-queue.php' && isset($_GET['job_id'])){
            ?>
            <script type="text/javascript">addLoadEvent(function(){jQuery('#ed_fullscreen').remove();});</script>
            <?php             
        }
    }
    

    function _mce_set_direction($settings) {
        $job = $this->get_translation_job((int)$_GET['job_id'], false, true);
        if (!empty($job)) {
            $rtl_translation = in_array($job->language_code, array('ar','he','fa'));
            if ($rtl_translation) {
                $settings['directionality'] = 'rtl';
            } else {
                $settings['directionality'] = 'ltr';
            }
        }
        return $settings;
    }

    /*
    function editor_directionality($tag) {
        $job = $this->get_translation_job((int)$_GET['job_id'], false, true);
        $rtl_translation = in_array($job->language_code, array('ar','he','fa'));
        if ($rtl_translation) {
            $dir = 'dir="rtl"';
        } else {
            $dir = 'dir="ltr"';
        }
        return str_replace('<textarea', '<textarea ' . $dir, $tag);
    }
    */
    
    function process_request($action, $data){        
        $data = stripslashes_deep($data);
        switch($action){
            case 'add_translator':
                if(wp_create_nonce('add_translator') == $data['add_translator_nonce']){
                    // Initial adding
                    if (isset($data['from_lang']) && isset($data['to_lang'])) {
                      $data['lang_pairs'] = array();
                      $data['lang_pairs'][$data['from_lang']] = array($data['to_lang'] => 1);
                    }
                    $this->add_translator($data['user_id'], $data['lang_pairs']);
                    $_user = new WP_User($data['user_id']);
                    wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.urlencode(sprintf(__('%s has been added as a translator for this site.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated');                    
                }
                break;
            case 'edit_translator':
                if(wp_create_nonce('edit_translator') == $data['edit_translator_nonce']){
                    $this->edit_translator($data['user_id'], $data['lang_pairs']);
                    $_user = new WP_User($data['user_id']);
                    wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.urlencode(sprintf(__('Language pairs for %s have been edited.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated');
                }
                break;
            case 'remove_translator':
                if(wp_create_nonce('remove_translator') == $data['remove_translator_nonce']){
                    $this->remove_translator($data['user_id']);
                    $_user = new WP_User($data['user_id']);
                    wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.urlencode(sprintf(__('%s has been removed as a translator for this site.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated');
                }                
                break;
            case 'edit':
                $this->selected_translator['ID'] = intval($data['user_id']);
                break;
            case 'dashboard_filter':
                $_SESSION['translation_dashboard_filter'] = $data['filter'];
                wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/main.php&sm=dashboard');
                break;  
           case 'sort':
                if(isset($data['sort_by'])) $_SESSION['translation_dashboard_filter']['sort_by'] = $data['sort_by'];
                if(isset($data['sort_order'])) $_SESSION['translation_dashboard_filter']['sort_order'] = $data['sort_order'];
                break;
           case 'reset_filters':
                unset($_SESSION['translation_dashboard_filter']);
                break;          
           case 'send_jobs':
                if(isset($data['iclnonce']) && wp_verify_nonce($data['iclnonce'], 'pro-translation-icl')){
                    $this->send_jobs($data);                        
                }   
                break; 
           case 'jobs_filter':
                $_SESSION['translation_jobs_filter'] = $data['filter'];                
                wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/main.php&sm=jobs');
                break;                               
           case 'ujobs_filter':
                $_SESSION['translation_ujobs_filter'] = $data['filter'];
                wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/translations-queue.php');
                break;                                               
           case 'save_translation':
                if(!empty($data['resign'])){
                    $this->resign_translator($data['job_id']);
                    wp_redirect(admin_url('admin.php?page='.WPML_TM_FOLDER.'/menu/translations-queue.php&resigned='.$data['job_id']));
                    exit;
                }else{
                    $this->save_translation($data);    
                }                
                break;
           case 'save_notification_settings':
                $this->settings['notification'] = $data['notification'];                                
                $this->save_settings();
                $this->messages[] = array(
                    'type'=>'updated',
                    'text' => __('Preferences saved.', 'sitepress')
                );
                break;
           case 'create_job':
                global $current_user;
                if(!isset($this->current_translator->ID) && isset($current_user->ID)){
                    $this->current_translator->ID  = $current_user->ID;   
                }
                $data['translator'] = $this->current_translator->ID;
                $job_ids = $this->send_jobs($data);
                wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/translations-queue.php&job_id=' . array_pop($job_ids));
                break;
           case 'cancel_jobs':
                $ret = $this->cancel_translation_request($data['icl_translation_id']);
                $this->messages[] = array(
                    'type'=>'updated',
                    'text' => __('Translation requests cancelled.', 'sitepress')
                );
                break;
        }
    }
    
    function ajax_calls($call, $data){
        global $wpdb, $sitepress, $sitepress_settings;        
        switch($call){
            /*
            case 'save_dashboard_setting':
                $iclsettings['dashboard'] = $sitepress_settings['dashboard'];
                if(isset($data['setting']) && isset($data['value'])){
                    $iclsettings['dashboard'][$data['setting']] = $data['value'];
                    $sitepress->save_settings($iclsettings);    
                }
                break;
            */
            case 'assign_translator':
            
                $_exp = explode('-', $data['translator_id']);
                $service = isset($_exp[1]) ? $_exp[1] : 'local';
                $translator_id = $_exp[0];                
                if($this->assign_translation_job($data['job_id'], $translator_id, $service)){
                    if($service == 'icanlocalize'){
                        $job = $this->get_translation_job($data['job_id']);
                        global $ICL_Pro_Translation;
                        $ICL_Pro_Translation->send_post($job->original_doc_id, array($job->language_code), $translator_id);
                        foreach($sitepress_settings['icl_lang_status'] as $lp){
                            if($lp['from'] == $job->source_language_code && $lp['to'] == $job->language_code){
                                $contract_id = $lp['contract_id'];
                                $lang_tr_id =  $lp['id']; 
                                break;
                            }
                        }
                        $translator_edit_link = $sitepress->create_icl_popup_link(ICL_API_ENDPOINT . '/websites/' . $sitepress_settings['site_id']
                        . '/website_translation_offers/' . $lang_tr_id . '/website_translation_contracts/'
                        . $contract_id, array('title' => __('Chat with translator', 'sitepress'), 'unload_cb' => 'icl_thickbox_refresh')) 
                        . esc_html(ICL_Pro_Translation::get_translator_name($translator_id))  . '</a> (ICanLocalize)';                    
                        
                    }else{
                        $translator_edit_link = '<a href="'.$this->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 json_encode(array('error'=>0, 'message'=>$translator_edit_link, 'status'=>$this->status2text(ICL_TM_WAITING_FOR_TRANSLATOR), 'service'=>$service));
                }else{
                    echo json_encode(array('error'=>1));
                }
                break;
            case 'icl_cf_translation':
                if(!empty($data['cf'])){
                    foreach($data['cf'] as $k=>$v){
                        $cft[base64_decode($k)] = $v;
                    }
                    $this->settings['custom_fields_translation'] = $cft;
                    $this->save_settings();                    
                }            
                echo '1|';
                break;
            case 'icl_doc_translation_method':
                $this->settings['doc_translation_method'] = intval($data['t_method']);
                $this->save_settings();
                echo '1|';
                break;
            case 'reset_duplication':
                $this->reset_duplicate_flag($_POST['post_id']);
                break;
            case 'set_duplication':
                $this->set_duplicate($_POST['post_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);
                break;
        }
    }
    
    function show_messages(){
        if(!empty($this->messages)){
            foreach($this->messages as $m){
                echo '<div class="'.$m['type'].' below-h2"><p>' . $m['text'] . '</p></div>';
            }
        }
    }
    
    /* TRANSLATORS */
    /* ******************************************************************************************** */
    function add_translator($user_id, $language_pairs){
        global $wpdb;
        
        $user = new WP_User($user_id);
        $user->add_cap('translate');
        
        $um = get_user_meta($user_id, $wpdb->prefix . 'language_pairs', true);
        if(!empty($um)){
            foreach($um as $fr=>$to){
                if(isset($language_pairs[$fr])){
                    $language_pairs[$fr] = array_merge($language_pairs[$fr], $to);        
                }
                
            }
        }
        
        update_user_meta($user_id, $wpdb->prefix . 'language_pairs',  $language_pairs);
        $this->clear_cache();
    }

    function edit_translator($user_id, $language_pairs){
        global $wpdb;
        $_user = new WP_User($user_id);
        if(empty($language_pairs)){
            $this->remove_translator($user_id);                
            wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.
                urlencode(sprintf(__('%s has been removed as a translator for this site.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated'); exit; 
        }
        else{
            if(!$_user->has_cap('translate')) $_user->add_cap('translate');
            update_user_meta($user_id, $wpdb->prefix . 'language_pairs',  $language_pairs);    
        }
    }
    
    function remove_translator($user_id){
        global $wpdb;
        $user = new WP_User($user_id);
        $user->remove_cap('translate');
        delete_user_meta($user_id, $wpdb->prefix . 'language_pairs');
        $this->clear_cache();
    }
    
    function is_translator($user_id, $args = array()){
        // $lang_from
        // $lang_to
        // $job_id
        
        //$default_args = array(); 
        //extract($default_args);
        extract($args, EXTR_OVERWRITE);
        
        global $wpdb;
        $user = new WP_User($user_id);
        $is_translator = $user->has_cap('translate');
        
        if(isset($lang_from) && isset($lang_to)){
            $um = get_user_meta($user_id, $wpdb->prefix . 'language_pairs', true);            
            $is_translator = $is_translator && isset($um[$lang_from][$lang_to]) && $um[$lang_from][$lang_to];
        }
        if(isset($job_id)){
            $translator_id = $wpdb->get_var($wpdb->prepare("
                    SELECT j.translator_id  
                        FROM {$wpdb->prefix}icl_translate_job j 
                        JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
                    WHERE job_id = %d AND s.translation_service='local'
                ", $job_id));
                                                                
            //$is_translator = $is_translator && ($translator_id == $user_id || ($translator_id === '0'));
            $is_translator = $is_translator && (($translator_id == $user_id) || empty($translator_id));
                
        }
        
        return $is_translator;
    }
    
    function translator_exists($id, $from, $to, $type = 'local'){
        global $sitepress_settings;
        $exists = false;
        if($type == 'icanlocalize' && !empty($sitepress_settings['icl_lang_status'])){
            foreach($sitepress_settings['icl_lang_status'] as $lpair){
                if($lpair['from'] == $from && $lpair['to'] == $to){
                    if(!empty($lpair['translators'])){
                        foreach($lpair['translators'] as $t){
                            if($t['id'] == $id){
                                $exists = true;
                                break(2);
                            }
                        }
                    }
                }
            }
        }elseif($type == 'local'){
            $exists = $this->is_translator($id, array('lang_from'=>$from, 'lang_to'=>$to));    
        }
        return $exists;
    }
    
    function set_default_translator($id, $from, $to, $type = 'local'){
        global $sitepress, $sitepress_settings;
        $iclsettings['default_translators'] = isset($sitepress_settings['default_translators']) ? $sitepress_settings['default_translators'] : array();
        $iclsettings['default_translators'][$from][$to] = array('id'=>$id, 'type'=>$type);
        $sitepress->save_settings($iclsettings);
    } 
    
    function get_default_translator($from, $to){
        global $sitepress_settings;
        if(isset($sitepress_settings['default_translators'][$from][$to])){
            $dt = $sitepress_settings['default_translators'][$from][$to];    
        }else{
            $dt = array();
        }
        return $dt; 
    }   
    
    public function get_blog_not_translators(){
        global $wpdb;
        $cached_translators = get_option($wpdb->prefix . 'icl_non_translators_cached', array());
        if (!empty($cached_translators)) {
            return $cached_translators;
        }
        $sql = "SELECT u.ID, u.user_login, u.display_name, m.meta_value AS caps
            FROM {$wpdb->users} u JOIN {$wpdb->usermeta} m ON u.id=m.user_id AND m.meta_key = '{$wpdb->prefix}capabilities' ORDER BY u.display_name";
        $res = $wpdb->get_results($sql);
        
        $users = array();
        foreach($res as $row){            
            $caps = @unserialize($row->caps);
            if(!isset($caps['translate'])){
                $users[] = $row;    
            }  
        }                                     
        update_option($wpdb->prefix . 'icl_non_translators_cached', $users);
        return $users;
    }

    /**
     * Implementation of 'icl_translators_list' hook
     *
     * @global object $sitepress
     * @param array $array
     * @return array
     */
    public function icanlocalize_translators_list() {  
      global $sitepress_settings, $sitepress;
      
      $lang_status = isset($sitepress_settings['icl_lang_status']) ? $sitepress_settings['icl_lang_status'] : array();
      if (0 != key($lang_status)){
        $buf[] = $lang_status;  
        $lang_status = $buf;    
      }
      
      $translators = array();
      foreach($lang_status as $lpair){
          foreach((array)$lpair['translators'] as $translator){
            $translators[$translator['id']]['name'] = $translator['nickname'];
            $translators[$translator['id']]['langs'][$lpair['from']][] = $lpair['to'];
            $translators[$translator['id']]['type'] = 'ICanLocalize';
            $translators[$translator['id']]['action'] = $sitepress->create_icl_popup_link(ICL_API_ENDPOINT . '/websites/' . $sitepress_settings['site_id']
                . '/website_translation_offers/' . $lpair['id'] . '/website_translation_contracts/'
                . $translator['contract_id'], array('title' => __('Chat with translator', 'sitepress'), 'unload_cb' => 'icl_thickbox_refresh', 'ar'=>1)) . __('Chat with translator', 'sitepress') . '</a>';        
          }
      }

      return $translators;
    }
    
    public function get_blog_translators($args = array()){
        global $wpdb;
        $args_default = array('from'=>false, 'to'=>false);
        extract($args_default);
        extract($args, EXTR_OVERWRITE);

//        $sql = "SELECT u.ID, u.user_login, u.display_name, u.user_email, m.meta_value AS caps
//                    FROM {$wpdb->users} u JOIN {$wpdb->usermeta} m ON u.id=m.user_id AND m.meta_key LIKE '{$wpdb->prefix}capabilities' ORDER BY u.display_name";
//        $res = $wpdb->get_results($sql);

        $cached_translators = get_option($wpdb->prefix . 'icl_translators_cached', array());

        if (empty($cached_translators)) {
            $sql = "SELECT u.ID FROM {$wpdb->users} u JOIN {$wpdb->usermeta} m ON u.id=m.user_id AND m.meta_key = '{$wpdb->prefix}language_pairs' ORDER BY u.display_name";
            $res = $wpdb->get_results($sql);
            update_option($wpdb->prefix . 'icl_translators_cached', $res);
        } else {
            $res = $cached_translators;
        }

        $users = array();
        foreach($res as $row){
            $user = new WP_User($row->ID);
//            $caps = @unserialize($row->caps);
//            $row->language_pairs = (array)get_user_meta($row->ID, $wpdb->prefix.'language_pairs', true);
            $user->language_pairs = (array)get_user_meta($row->ID, $wpdb->prefix.'language_pairs', true);
//            if(!empty($from) && !empty($to) && (!isset($row->language_pairs[$from][$to]) || !$row->language_pairs[$from][$to])){
//                continue;
//            }
            if(!empty($from) && !empty($to) && (!isset($user->language_pairs[$from][$to]) || !$user->language_pairs[$from][$to])){
                continue;
            }
//            if(isset($caps['translate'])){
//                $users[] = $user;
//            }
            if($user->has_cap('translate')){
                $users[] = $user;
            }
        }
        return $users;
    }
    
    function get_selected_translator(){
        global $wpdb;
        if($this->selected_translator['ID']){
            $user = new WP_User($this->selected_translator['ID']);
            $this->selected_translator['display_name'] =  $user->data->display_name;
            $this->selected_translator['user_login'] =  $user->data->user_login;
            $this->selected_translator['language_pairs'] = get_user_meta($this->selected_translator['ID'], $wpdb->prefix.'language_pairs', true);
        }else{
            $this->selected_translator['ID'] = 0;
        }
        return (object)$this->selected_translator;    
    }
    
    function get_current_translator(){
        return $this->current_translator;
    }
    
    public function get_translator_edit_url($translator_id){
        $url = '';
        if(!empty($translator_id)){
            $url = 'admin.php?page='. WPML_TM_FOLDER .'/menu/main.php&amp;sm=translators&icl_tm_action=edit&amp;user_id='. $translator_id;
        }
        return $url;
    }
    
    public function translators_dropdown($args = array()){
        global $sitepress_settings;
        $args_default = array(
            'from'=>false, 'to'=>false,
            'name'          => 'translator_id',
            'selected'      => 0,
            'echo'          => true,
            'services'      => array('local')
        );
        extract($args_default);
        extract($args, EXTR_OVERWRITE);

        $translators = array();
        
        if(in_array('icanlocalize', $services)){
            if(empty($sitepress_settings['icl_lang_status'])) $sitepress_settings['icl_lang_status'] = array();
            foreach((array)$sitepress_settings['icl_lang_status'] as $langpair){
                if($from && $from != $langpair['from']) continue;
                if($to && $to != $langpair['to']) continue;
                
                if(!empty($langpair['translators'])){
                    if (1 < count($langpair['translators'])) {
                        $translators[] = (object) array(
                            'ID' => '0-icanlocalize',
                            'display_name' => __('First available', 'sitepress'),
                            'service'       => 'ICanLocalize'
                        );
                    }
                    foreach($langpair['translators'] as $tr){
                        if(!isset($_icl_translators[$tr['id']])){
                            $translators[] = $_icl_translators[$tr['id']] = (object) array(
                                'ID'=>$tr['id'].'-icanlocalize', 
                                'display_name'=>$tr['nickname'],
                                'service'       => 'ICanLocalize'
                            );            
                        }
                    }
                }    
            }
        }

        if(in_array('local', $services)){
            $translators[] = (object) array(
                'ID' => 0,
                'display_name' => __('First available', 'sitepress'),
            );
            $translators = array_merge($translators, $this->get_blog_translators(array('from'=>$from,'to'=>$to)));
        }
        
        ?>
        <select name="<?php echo $name ?>">
            <?php foreach($translators as $t):?>
            <option value="<?php echo $t->ID ?>" <?php if($selected==$t->ID):?>selected="selected"<?php endif;?>><?php echo esc_html($t->display_name);
                 ?> (<?php if(isset($t->service)) echo $t->service; else _e('Local', 'sitepress'); ?>)</option>
            <?php endforeach; ?>
        </select>
        <?php
    }
    
    public function get_number_of_docs_sent($service = 'icanlocalize'){
        global $wpdb;
        $n = $wpdb->get_var($wpdb->prepare("
            SELECT COUNT(rid) FROM {$wpdb->prefix}icl_translation_status WHERE translation_service=%s
        ", $service));
        return $n;
    }

    public function get_number_of_docs_pending($service = 'icanlocalize'){
        global $wpdb;
        $n = $wpdb->get_var($wpdb->prepare("
            SELECT COUNT(rid) FROM {$wpdb->prefix}icl_translation_status WHERE translation_service=%s AND status < " . ICL_TM_COMPLETE . "
        ", $service));
        return $n;        
    }
    
        
    /* HOOKS */
    /* ******************************************************************************************** */
    function save_post_actions($post_id, $post, $force_set_status = false){
        global $wpdb, $sitepress, $sitepress_settings, $current_user;
        // skip revisions
        if($post->post_type == 'revision'){
            return;
        }
        // skip auto-drafts
        if($post->post_status == 'auto-draft'){
            return;
        }
        // skip autosave
        if(isset($_POST['autosave'])){
            return;
        }

        // is this the original document? 
        if(!empty($_POST['icl_trid'])){
            $is_original = $wpdb->get_var($wpdb->prepare("SELECT source_language_code IS NULL FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND trid=%d", $post_id, $_POST['icl_trid']));
        }
        
        // when a manual translation is added/edited make sure to update translation tables
        if(!empty($_POST['icl_trid']) && !$is_original){        
        
            $trid = $_POST['icl_trid'];
            $lang = $_POST['icl_post_language'];
            
            $res = $wpdb->get_row($wpdb->prepare("
                SELECT element_id, language_code FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL
            ", $trid));
            $original_post_id = $res->element_id;
            $from_lang = $res->language_code;
            $original_post = get_post($original_post_id);
            $translation_id = $wpdb->get_var($wpdb->prepare("
                SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND language_code='%s'
            ", $trid, $lang));
            $md5 = $this->post_md5($original_post);
            
        
            get_currentuserinfo();
            $user_id = $current_user->ID;
            
            if(!$this->is_translator($user_id, array('lang_from'=>$from_lang, 'lang_to'=>$lang))){
                $this->add_translator($user_id, array($from_lang=>array($lang=>1)));
            }
            
            if($translation_id){
                $translation_package = $this->create_translation_package($original_post_id);                    
                
                list($rid, $update) = $this->update_translation_status(array(
                    'translation_id'        => $translation_id,
                    'status'                => isset($force_set_status) && $force_set_status > 0 ? $force_set_status : ICL_TM_COMPLETE,
                    'translator_id'         => $user_id,
                    'needs_update'          => 0,
                    'md5'                   => $md5,
                    'translation_service'   => 'local',
                    'translation_package'   => serialize($translation_package)
                ));
                if(!$update){
                    $job_id = $this->add_translation_job($rid, $user_id , $translation_package);
                }else{
                    $job_id = $wpdb->get_var($wpdb->prepare("SELECT MAX(job_id) FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d GROUP BY rid", $rid));
                }
                
                
                // saving the translation
                $this->save_job_fields_from_post($job_id, $post);
                
                /*    
                $data['complete'] = 1;
                $data['job_id'] = $job_id;
                
                $job = $this->get_translation_job($job_id,1);
                foreach($job->elements as $element){
                    $field_data = '';
                    switch($element->field_type){
                        case 'title':
                            $field_data = $this->encode_field_data($post->post_title, $element->field_format);
                            break;
                        case 'body':
                            $field_data = $this->encode_field_data($post->post_content, $element->field_format);
                            break;
                        case 'excerpt':
                            $field_data = $this->encode_field_data($post->post_excerpt, $element->field_format);
                            break;                           
                        default:
                            if(false !== strpos($element->field_type, 'field-') && !empty($this->settings['custom_fields_translation'])){                                
                                $cf_name = preg_replace('#^field-#', '', $element->field_type);
                                if(isset($this->settings['custom_fields_translation'][$cf_name])){
                                    if($this->settings['custom_fields_translation'][$cf_name] == 1){ //copy
                                        $field_data = get_post_meta($original_post->ID, $cf_name, 1);               
                                        $field_data = $this->encode_field_data($field_data, $element->field_format);                             
                                    }elseif($this->settings['custom_fields_translation'][$cf_name] == 2){ // translate
                                        $field_data = get_post_meta($post->ID, $cf_name, 1);             
                                        $field_data = $this->encode_field_data($field_data, $element->field_format);             
                                    }
                                }
                            }else{
                                // taxonomies                                                 
                                // TBD
                            }
                    }

                    $wpdb->update($wpdb->prefix.'icl_translate', 
                        array('field_data_translated'=>$field_data, 'field_finished'=>1), 
                        array('tid'=>$element->tid)
                    );
                    
                }
                $wpdb->update($wpdb->prefix . 'icl_translate_job', array('translated'=>1), array('job_id'=>$job_id));    
                */
                
            }
        }
        
        // if this is an original post - compute md5 hash and mark for update if neded
        if(!empty($_POST['icl_trid']) && empty($_POST['icl_minor_edit'])){
            $needs_update = false;
            $is_original  = false;
            $translations = $sitepress->get_element_translations($_POST['icl_trid'], 'post_' . $post->post_type);    

            foreach($translations as $lang=>$translation){                
                if($translation->original == 1 && $translation->element_id == $post_id){
                    $is_original = true;
                    break;
                }
            }
            if($is_original){
                $md5 = $this->post_md5($post_id);
                foreach($translations as $lang=>$translation){                
                    if(!$translation->original){
                        $emd5 = $wpdb->get_var($wpdb->prepare("SELECT md5 FROM {$wpdb->prefix}icl_translation_status WHERE translation_id = %d", $translation->translation_id));
                        if($md5 != $emd5){
                            $wpdb->update($wpdb->prefix.'icl_translation_status', array('needs_update'=>1, 'md5'=>$md5), array('translation_id'=>$translation->translation_id));
                        }
                    }
                }
            }
        }
        
        // sync copies/duplicates
        $duplicates = $this->get_duplicates($post_id);
        foreach($duplicates as $lang => $_pid){
            $this->make_duplicate($post_id, $lang);
        }
        
        
        // review?
        /*
        if($_POST['icl_trid']){
            //
            // get original document
            $translations = $sitepress->get_element_translations($_POST['icl_trid'], 'post_' . $post->post_type);
            foreach($translations as $t){
                if($t->original){
                    $origin = $t->language_code;
                }
            }
            
            // remove ?            
            $rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_content_status WHERE nid = %d"), $post_id);
            if(!$rid){                
                $wpdb->insert($wpdb->prefix.'icl_content_status', array('nid' => $post_id, 'md5'=>$this->post_md5($post), 'timestamp'=>date('Y-m-d H:i:s')));                
                $rid = $wpdb->insert_id;
            }else{
                $wpdb->update($wpdb->prefix.'icl_content_status', array('md5'=>$this->post_md5($post)), array('rid'=>$rid));                
            }
            
            // add update icl_core_status entry
            $id = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_core_status WHERE rid = %d AND target= = %s"), $rid, $_POST['icl_post_language']);
            if(!$id){
                $wpdb->insert($wpdb->prefix.'icl_core_status', array('rid' => $rid, 'origin' => $origin, 'target' => $_POST['icl_post_language'], 'status' => 1 ));  //!!!!!!!               
            }else{
                $wpdb->update($wpdb->prefix.'icl_content_status', array('md5'=>$this->post_md5($post)), array('rid'=>$rid));                
            }
            
        }
        */
        
    }
    
    function delete_post_actions($post_id){
        global $wpdb;
        $post_type = $wpdb->get_var("SELECT post_type FROM {$wpdb->posts} WHERE ID={$post_id}");
        if(!empty($post_type)){
            $translation_id = $wpdb->get_var($wpdb->prepare("SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", $post_id, 'post_' . $post_type));                
            if($translation_id){
                $rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation_id));
                $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation_id));     
                if($rid){
                    $jobs = $wpdb->get_col($wpdb->prepare("SELECT job_id FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d", $rid));
                    $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d", $rid));                                 
                    if(!empty($jobs)){
                        $wpdb->query("DELETE FROM {$wpdb->prefix}icl_translate WHERE job_id IN (".join(',', $jobs).")");                                 
                    }
                }
            }
        }
    }
    
    /* TRANSLATIONS */
    /* ******************************************************************************************** */
    /**
    * calculate post md5
    * 
    * @param object|int $post
    * @return string
    * 
    * @todo full support for custom posts and custom taxonomies
    */
    function post_md5($post){
        
        if (isset($post->external_type) && $post->external_type) {
            
            $md5str = '';
            
            foreach ($post->string_data as $key => $value) {
                $md5str .= $key . $value;
            }
            
            
        } else {
        
            $post_tags = $post_categories = $custom_fields_values = array();
            
            if(is_numeric($post)){
                $post = get_post($post);    
            }
            
            $post_type = $post->post_type;
            
            if($post_type=='post'){
                foreach(wp_get_object_terms($post->ID, 'post_tag') as $tag){
                    $post_tags[] = $tag->name;
                }
                if(is_array($post_tags)){
                    sort($post_tags, SORT_STRING);
                }        
                foreach(wp_get_object_terms($post->ID, 'category') as $cat){
                    $post_categories[] = $cat->name;
                }    
                if(is_array($post_categories)){
                    sort($post_categories, SORT_STRING);
                }
                
                global $wpdb, $sitepress_settings;
                // get custom taxonomies
                $taxonomies = $wpdb->get_col("
                    SELECT DISTINCT tx.taxonomy 
                    FROM {$wpdb->term_taxonomy} tx JOIN {$wpdb->term_relationships} tr ON tx.term_taxonomy_id = tr.term_taxonomy_id
                    WHERE tr.object_id = {$post->ID}
                ");
                sort($taxonomies, SORT_STRING);
                foreach($taxonomies as $t){
                    if(@intval($sitepress_settings['taxonomies_sync_option'][$t]) == 1){
                        $taxs = array();
                        foreach(wp_get_object_terms($post->ID, $t) as $trm){
                            $taxs[] = $trm->name;
                        }
                        if($taxs){
                            sort($taxs,SORT_STRING);
                            $all_taxs[] = '['.$t.']:'.join(',',$taxs);
                        }
                    }
                }
            }
            
            $custom_fields_values = array();
            if(is_array($this->settings['custom_fields_translation'])){
                foreach($this->settings['custom_fields_translation'] as $cf => $op){
                    if ($op == 2) {
                        $custom_fields_values[] = get_post_meta($post->ID, $cf, true);
                    }
                }
            }
            
            $md5str =         
                $post->post_title . ';' . 
                $post->post_content . ';' . 
                join(',',$post_tags).';' . 
                join(',',$post_categories) . ';' . 
                join(',', $custom_fields_values);
            if(!empty($all_taxs)){
                $md5str .= ';' . join(';', $all_taxs);
            }
        }
        $md5 = md5($md5str);
                    
        return $md5;        
    }
    
    /**
    * get documents
    * 
    * @param array $args
    */
    function get_documents($args){
        
        extract($args);
        
        global $wpdb, $wp_query, $sitepress;
        
        $t_el_types = array_keys($sitepress->get_translatable_documents());
        
        // SELECT
        $select = " p.ID AS post_id, p.post_title, p.post_content, p.post_type, p.post_status, p.post_date, t.trid, t.source_language_code <> '' AS is_translation";
        if($to_lang){
            $select .= ", iclts.status, iclts.needs_update";
        }else{
            foreach($sitepress->get_active_languages() as $lang){
                if($lang['code'] == $from_lang) continue;
                $tbl_alias_suffix = str_replace('-','_',$lang['code']);                
                $select .= ", iclts_{$tbl_alias_suffix}.status AS status_{$tbl_alias_suffix}, iclts_{$tbl_alias_suffix}.needs_update AS needs_update_{$tbl_alias_suffix}";
            }
        }
        
        // FROM
        $from   = " {$wpdb->posts} p";
        
        // JOIN
        $join = "";        
        $join   .= " LEFT JOIN {$wpdb->prefix}icl_translations t ON t.element_id=p.ID\n";    
        if($to_lang){
            $tbl_alias_suffix = str_replace('-','_',$to_lang);
            $join .= " LEFT JOIN {$wpdb->prefix}icl_translations iclt_{$tbl_alias_suffix} 
                        ON iclt_{$tbl_alias_suffix}.trid=t.trid AND iclt_{$tbl_alias_suffix}.language_code='{$to_lang}'\n";    
            $join   .= " LEFT JOIN {$wpdb->prefix}icl_translation_status iclts ON iclts.translation_id=iclt_{$tbl_alias_suffix}.translati…