Changeset 491

Timestamp:

08/08/2010 03:42:53 AM (18 months ago)

Author:

ofer

Message:

Add the option in the transposh interface to remove automated translations that are older then 2 weeks (or all of them)

Location:

trunk/WordPress/plugin/transposh

Files:

• js/transposhcontrol.js (modified) (3 diffs)
• wp/transposh_admin.php (modified) (2 diffs)
• wp/transposh_ajax.php (modified) (1 diff)
• wp/transposh_db.php (modified) (2 diffs)

trunk/WordPress/plugin/transposh/js/transposhcontrol.js

@@ -121 +121 @@
     });
 
+    jQuery.ajaxSetup({
+        cache: false
+    });
+
     // backup button
     backupclick = function () {
-        jQuery("#transposh-backup").click(function(){
+        jQuery("#transposh-backup").unbind('click').click(function(){
             return false
-            }).text("Backup In Progress");
-        jQuery.get(t_jp.post_url + "?backup=" + Math.random(),function(data) {
+        }).text("Backup In Progress");
+        jQuery.get(t_jp.post_url + "?backup",function(data) {
             var color = 'red';
             if (data[0] == '2') color = 'green';
             jQuery('#backup_result').html(data).css('color',color);
-            jQuery("#transposh-backup").click(backupclick).text("Do Backup Now");
+            jQuery("#transposh-backup").unbind('click').click(backupclick).text("Do Backup Now");
         });
         return false;
     };
     jQuery("#transposh-backup").click(backupclick);
+
+    // cleanup button
+    cleanautoclick = function (days,button) {
+        if (!confirm("Are you sure you want to do this?")) return false;
+        if (days == 0 && !confirm("Are you REALLY sure you want to do this?")) return false;
+        //var button = jQuery(this);
+        console.log(button);
+        var prevtext = button.text();
+        button.unbind('click').click(function(){
+            return false
+        }).text("Cleanup in progress");
+        jQuery.get(t_jp.post_url + "?nonce="+button.attr('nonce')+"&days="+days+"&cleanup",function(data) {
+            button.unbind('click').click(function() {
+                cleanautoclick(days,button);
+                return false;
+            }).text(prevtext);
+        });
+        return false;
+    };
+    jQuery("#transposh-clean-auto").click(function() {
+        cleanautoclick(0,jQuery(this));
+        return false;
+    });
+    jQuery("#transposh-clean-auto14").click(function() {
+        cleanautoclick(14,jQuery(this));
+        return false;
+    });
 
     // translate all button
@@ -181 +212 @@
         });
         jQuery("#transposh-translate").text("Stop translate")
-        jQuery("#transposh-translate").click(stop_translate);
+        jQuery("#transposh-translate").unbind('click').click(stop_translate);
         return false;
     }
@@ -189 +220 @@
         stop_translate_var = true;
         jQuery("#transposh-translate").text("Translate All Now")
-        jQuery("#transposh-translate").click(do_translate_all);
+        jQuery("#transposh-translate").unbind('click').click(do_translate_all);
         return false;
     }

trunk/WordPress/plugin/transposh/wp/transposh_admin.php

@@ -202 +202 @@
         add_meta_box('transposh-contentbox-autotranslation', 'Automatic translation settings', array(&$this, 'on_contentbox_auto_translation_content'), $this->pagehook, 'normal', 'core');
         add_meta_box('transposh-contentbox-general', 'Generic settings', array(&$this, 'on_contentbox_generic_content'), $this->pagehook, 'normal', 'core');
+        add_meta_box('transposh-contentbox-database', 'Database maintenance', array(&$this, 'on_contentbox_database_content'), $this->pagehook, 'normal', 'core');
     }
 
@@ -535 +536 @@
     }
 
+    function on_contentbox_database_content($data) {
+        /*
+         * Insert two buttons allowing removal of automated translations from database
+         */
+        echo '<div style="margin:10px 0"><a id="transposh-clean-auto" href="#" nonce="'.  wp_create_nonce('transposh-clean').'" class="button">Clean all automated translations</a></div>';
+        echo '<div style="margin:10px 0"><a id="transposh-clean-auto14" href="#" nonce="'.  wp_create_nonce('transposh-clean').'" class="button">Clean automated translations older than 14 days</a></div>';
+    }
+
     function on_contentbox_community_content($data) {
         echo '<h4>Backup service for human translation</h4>';

trunk/WordPress/plugin/transposh/wp/transposh_ajax.php

@@ -101 +101 @@
     $my_transposh_plugin->run_backup();
 }
+// Start cleanup on demand
+elseif (isset($_GET['cleanup'])) {
+    // just make sure the admin started this... recently enough
+    check_ajax_referer('transposh-clean','nonce');
+    $my_transposh_plugin->database->cleanup($_GET['days']);
+}
+
 ?>

trunk/WordPress/plugin/transposh/wp/transposh_db.php

@@ -488 +488 @@
     }
 
+    /**
+     * Provides some stats about our database
+     */
     function db_stats() {
         echo "<h4>Database stats</h4>";
@@ -558 +561 @@
     }
 
+    /**
+     * This function removes translations and translation logs from the database, only
+     * when the last translation is automated
+     * @param int $days
+     */
+    function cleanup($days = 0) {
+        $days = intval($days); // some security
+        $cleanup = 'DELETE ' . $GLOBALS['wpdb']->prefix . TRANSLATIONS_TABLE . ' ,' . $GLOBALS['wpdb']->prefix . TRANSLATIONS_LOG .
+                ' FROM ' . $GLOBALS['wpdb']->prefix . TRANSLATIONS_TABLE .
+                ' INNER JOIN '. $GLOBALS['wpdb']->prefix . TRANSLATIONS_LOG.
+                ' ON '.$GLOBALS['wpdb']->prefix . TRANSLATIONS_TABLE .'.original = '.$GLOBALS['wpdb']->prefix . TRANSLATIONS_LOG .'.original'.
+                ' AND '.$GLOBALS['wpdb']->prefix . TRANSLATIONS_TABLE .'.lang = '.$GLOBALS['wpdb']->prefix . TRANSLATIONS_LOG .'.lang'.
+                ' WHERE '. $GLOBALS['wpdb']->prefix . TRANSLATIONS_TABLE.'.source > 0'.
+                " AND timestamp < SUBDATE(NOW(),$days)";
+        apc_clear_cache('user'); // clean up cache so that results will actually show
+        $result = $GLOBALS['wpdb']->query($cleanup);
+        exit;
+    }
+
 }
 ?>