Changeset 1518 for trunk/expressoMail1_2/js/local_messages.js

Timestamp:

10/20/09 15:24:08 (15 years ago)

Author:

eduardoalex

Message:

Ticket #656 - funcionalidade de arquivamento programado no expressoMail

File:

• trunk/expressoMail1_2/js/local_messages.js (modified) (3 diffs)

trunk/expressoMail1_2/js/local_messages.js

@@ -31 +31 @@
                 if(this.store==null)
                         this.store = this.localServer.createStore('test-store');                        
-                this.dbGears.open('database-test');
+                
+                var db_in_other_use = true;
+                while (db_in_other_use) {
+                        try {
+                                this.dbGears.open('database-test');
+                                db_in_other_use = false;
+                        } 
+                        catch (ex) {
+                                db_in_other_use=true;
+                        }
+                }
+                
+                /*var db_is_opened = true;
+                while (db_is_opened) {
+                        try {
+                                this.dbGears.open('database-test');
+                                db_is_opened = true;
+                        } 
+                        catch (ex) {
+                                db_is_opened=false;
+                        }
+                }*/
+                
+//              this.dbGears.open('database-test');
                 this.dbGears.execute('create table if not exists folder (folder text,uid_usuario int,unique(folder,uid_usuario))');
                 this.dbGears.execute('create table if not exists mail' +
@@ -38 +61 @@
                 this.dbGears.execute('create table if not exists anexo' +
                 ' (id_mail int,nome_anexo text,url text,pid int)');
+                this.dbGears.execute('create table if not exists folders_sync' +
+                ' (id_folder text,folder_name text,uid_usuario int)');
+                this.dbGears.execute('create table if not exists msgs_to_remove (id_msg int,folder text,uid_usuario int)');
 
                 //some people that used old version of local messages could not have the size column. If it's the first version
@@ -908 +934 @@
         }
         
+        local_messages.prototype.get_folders_to_sync = function() {
+                this.init_local_messages();
+                var rs = this.dbGears.execute("select id_folder,folder_name from folders_sync where uid_usuario="+account_id);
+                var retorno = new Array();
+                while(rs.isValidRow()) {
+                        temp = new Array();
+                        temp[0] = rs.field(0);
+                        temp[1] = rs.field(1);
+                        retorno.push(temp);
+                        rs.next();
+                }
+                this.finalize();
+                return retorno;
+        }
+        
         local_messages.prototype.install_offline = function(urlOffline,urlIcone,uid_usuario,login,pass,redirect) {
                 if (!window.google || !google.gears) {