Changeset 5086 for branches/2.2/expressoMail1_2/js/local_messages.js

Timestamp:

09/13/11 10:21:50 (13 years ago)

Author:

diogenesduarte

Message:

Ticket #2234 - Ordenando pesquisa em mensagens locais, igual a ordenação em não locais.

File:

• branches/2.2/expressoMail1_2/js/local_messages.js (modified) (3 diffs)

branches/2.2/expressoMail1_2/js/local_messages.js

@@ -913 +913 @@
 }
 
-local_messages.prototype.search = function(folders,sFilter) {
+local_messages.prototype.search = function(folders,sFilter,sortType) {
     this.init_local_messages();
     this.setFilter(sFilter);
@@ -958 +958 @@
         }
     }
-    var sql = "select mail.header,folder.folder,mail.rowid,size from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario="+account_id + " and folder.folder in (";
+    var sql = "select mail.header,folder.folder,mail.rowid,size";
+    var order;
+    if(sortType) {
+        var sort_splited = sortType.split("_");
+        
+        //Preparando o select caso tenha order from
+        if(sort_splited[0]=="SORTWHO") {
+                sql+=',case when ltrim(ltrim(substr(UPPER(ffrom),21,length(mail.ffrom)),\':\'),\'"\')  like \'5:%\' then ' +
+            'substr(ltrim(ltrim(substr(UPPER(mail.ffrom),21,length(mail.ffrom)),\':\'),\'"\'),17) ' +
+            'else ' +
+            'ltrim(ltrim(substr(UPPER(mail.ffrom),21,length(mail.ffrom)),\':\'),\'"\') ' +
+            'end as order_from';
+            }
+        
+        order=" order by ";
+        switch (sort_splited[0]) {
+                case "SORTBOX":
+                        order+= "folder.folder ";
+                        break;
+                case "SORTWHO":
+                        order+="order_from ";
+                        break;
+                case "SORTSUBJECT":
+                        order+="UPPER(mail.subject) ";
+                        break;
+                case "SORTDATE":
+                        order+="mail.timestamp ";
+                        break;
+                case "SORTSIZE":
+                        order+="mail.size ";
+                        break;
+        }
+        if(sort_splited[1]=='REVERSE')
+                order+="desc";
+    
+    
+
+    }
+    else {
+        order = " ";
+    }
+    sql+=" from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario="+account_id + " and folder.folder in (";
     for(var fnum in folders) {
         sql+="'"+folders[fnum]+"'";
@@ -990 +1031 @@
     }
     sql += ")";
+    sql += order;
+    
+        
     var rs = this.dbGears.execute(sql);
     var retorno = [];