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

Timestamp:

06/16/09 18:29:16 (15 years ago)

Author:

rafaelraymundo

Message:

Ticket #550 - Unificação de funcionalidade do SERPRO referentes ao arquivamento local.

File:

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

trunk/expressoMail1_2/js/local_messages.js

@@ -59 +59 @@
         
         local_messages.prototype.insert_mail = function(msg_info,msg_header,anexos,folder) {
-
                 try {
                         this.init_local_messages();
@@ -82 +81 @@
                         msg_info.cc = null;
                         msg_header.Size=null;
-                        
                         //If the mail was archieved in the same date the user received it, the date cames with the time.
                         //here I solved it
@@ -109 +107 @@
                         
                         var rs = this.dbGears.execute("select rowid from folder where folder=? and uid_usuario=?",[folder,account_id]);
-                        
-                        if(rs.isValidRow())
+                        if(rs.isValidRow())
                                 id_folder=rs.field(0);
                         else {
@@ -119 +116 @@
                         if(msg_info.Unseen=="U")
                                 unseen = 1;
-                        this.dbGears.execute("insert into mail (mail,original_id,original_folder,header,timestamp,uid_usuario,unseen,id_folder,ffrom,subject,fto,cc,body,size) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)",[mail,original_id,original_folder,header,timestamp,login,unseen,id_folder,from,subject,to,cc,body,size]);
+            this.dbGears.execute("insert into mail (mail,original_id,original_folder,header,timestamp,uid_usuario,unseen,id_folder,ffrom,subject,fto,cc,body,size) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)",[mail,original_id,original_folder,header,timestamp,login,unseen,id_folder,from,subject,to,cc,body,size]);
                         var call_back = function() {
                         }
@@ -148 +145 @@
                 retorno['subject'] = rs.field(3);
                 retorno['body'] = rs.field(4);
+                //Codigo que as imagens embutidas em emails (com multipart/related ou multipart/mixed) sejam corretamente mostradas em emails arquivados. Os links do
+                //tipo "./inc/show_embedded_attach.php?msg_folder=[folder]&msg_num=[msg_num]&msg_part=[part]"
+                //são substituidos pelos links dos anexos capturados pelo gears.
+
+                var thumbs= retorno.thumbs;
+                var anexos= retorno.array_attach;
+                for (i in anexos)
+                {
+                    nomeArquivo = anexos[i]['name'].substring(0,anexos[i]['name'].length - 4);
+                    if(nomeArquivo.match('jpg')||anexos[i]['name'].match('gif')||anexos[i]['name'].match('png'))
+                        {
+                            var er_imagens = new RegExp("\\.\\/inc\\/show_embedded_attach.php\\?msg_folder=[\\w/]+\\&msg_num=[0-9]+\\&msg_part="+anexos[i]['pid']);
+                            var Result_imagens = er_imagens.exec(retorno['body']);
+                            retorno['body'] = retorno['body'].replace(Result_imagens,anexos[i]['url']);
+                            if(thumbs && thumbs[i]){
+                                er_imagens = new RegExp("\\.\\/inc\\/show_thumbs.php\\?file_type=image\\/[\\w]+\\&msg_num=[0-9]+\\&msg_folder=[\\w/%]+\\&msg_part="+anexos[i]['pid']);
+                                Result_imagens = er_imagens.exec(thumbs[i]);
+                                thumbs[i] = thumbs[i].replace(Result_imagens,"'"+anexos[i]['url']+"'");
+                                er_imagens = new RegExp("\\.\\/inc\\/show_img.php\\?msg_num=[0-9]+\\&msg_folder=[\\w/%]+\\&msg_part="+anexos[i]['pid']);
+                                Result_imagens = er_imagens.exec(thumbs[i]);
+                                thumbs[i] = thumbs[i].replace(Result_imagens,"'"+anexos[i]['url']+"'");
+                                thumbs[i] = thumbs[i].replace(/<IMG/i,'<img width="120"');
+                            }
+                        }
+                }
+
                 retorno['to'] = connector.unserialize(rs.field(5));
                 retorno['cc'] = connector.unserialize(rs.field(6));
@@ -508 +531 @@
                                                 sql += " and";
                                 }
-                                sql+=" mail."+this.aux_convert_filter_field(friendly_filters[z])+" like '%"+friendly_filters[z+1]+"%'";
+                                sql+=" mail."+this.aux_convert_filter_field(friendly_filters[z])+" like '%"+url_decode(friendly_filters[z+1])+"%'";
                         }
                 }
@@ -559 +582 @@
                 return retorno;
         }
+
+     //Por Bruno Costa(bruno.vieira-costa@serpro.gov.br - Essa função é um AJAX simples que serve apenas para pegar o fonte de uma msg local (no formato RFC 822).
+    local_messages.prototype.get_src = function(url){
+        AJAX = false;
+        if (window.XMLHttpRequest) { // Mozilla, Safari,...
+            AJAX = new XMLHttpRequest();
+            if (AJAX.overrideMimeType) {
+                AJAX.overrideMimeType('text/xml');
+            }
+        } else if (window.ActiveXObject) { // IE
+            try {
+                AJAX = new ActiveXObject("Msxml2.XMLHTTP");
+            } catch (e) {
+                try {
+                AJAX = new ActiveXObject("Microsoft.XMLHTTP");
+                } catch (e) {}
+            }
+        }
+
+        if (!AJAX) {
+            alert('ERRO :(Seu navegador não suporta a aplicação usada neste site');
+            return false;
+        }
+
+        AJAX.onreadystatechange = function() {
+            if (AJAX.readyState == 4) {
+                AJAX.src=AJAX.responseText;
+                if (AJAX.status == 200) {
+                    return AJAX.responseText;
+                    } else {
+                    return false;
+                }
+            }
+        }
+
+        AJAX.open('get', url, false);
+        AJAX.send(null);
+        return AJAX.responseText;
+    };
+
+  //Por Bruno Costa(bruno.vieira-costa@serpro.gov.br - Dessarquiva msgs locais pegando o codigo fonte das mesmas e mandando via POST para o servidor
+  //para que elas sejam inseridas no imap pela função  imap_functions.unarchive_mail.
+    local_messages.prototype.unarchive_msgs = function (folder,new_folder,msgs_number){
+
+        if(!new_folder)
+            new_folder='INBOX';
+        this.init_local_messages();
+       // alert(folder+new_folder+msgs_number);
+        var handler_unarchive = function(data)
+        {
+            if(data.error == '')
+                write_msg(get_lang('All messages are successfully unarchived'));
+            else
+                alert(data.error);
+        }
+        if(msgs_number =='selected' || !msgs_number)
+        {
+            msgs_number = get_selected_messages()
+            if (!msgs_number){
+                write_msg(get_lang('No selected message.'));
+                return;
+            }
+            var rs = this.dbGears.execute("select mail,timestamp from mail where rowid in ("+msgs_number+")");
+            var source="";
+            var timestamp="";
+            while(rs.isValidRow()) {
+                mail=connector.unserialize(rs.field(0));
+                source_tmp=escape(this.get_src(mail.url_export_file));
+                    source+="#@#@#@"+source_tmp;
+                    timestamp+="#@#@#@"+rs.field(1);
+                rs.next();
+            }
+            rs.close();
+            this.finalize();
+        }
+        else
+        {
+            var rs = this.dbGears.execute("select mail,timestamp from mail where rowid="+msgs_number);
+            mail=connector.unserialize(rs.field(0));
+            var source ="";
+            source = this.get_src(mail.url_export_file);
+            timestamp=rs.field(1);
+             rs.close();
+             this.finalize();
+        }
+            params="&folder="+new_folder+"&source="+source+"&timestamp="+timestamp;
+            cExecute ("$this.imap_functions.unarchive_mail&", handler_unarchive, params);
+    }
+
+
+    local_messages.prototype.download_all_local_attachments = function(folder,id){
+        this.init_local_messages();
+        var rs = this.dbGears.execute("select mail from mail where rowid="+id);
+        var tmp = connector.unserialize(rs.field(0));
+        rs.close();
+        this.finalize();
+        source = this.get_src(tmp.url_export_file);
+        source = escape(source);
+        var handler_source = function(data){
+            download_attachments(null, null, data, null,null,'anexos.zip');
+        }
+        cExecute("$this.imap_functions.download_all_local_attachments",handler_source,"source="+source);
+    }
+
+    /*************************************************************************/
+/* Funcao usada para exportar mensagens arquivadas localmente.
+ * Rommel de Brito Cysne (rommel.cysne@serpro.gov.br)
+ * em 22/12/2008.
+ */
+    local_messages.prototype.local_messages_to_export = function(){
+
+        if (openTab.type[currentTab] > 1){
+            var msgs_to_export_id = currentTab.substring(0,currentTab.length-2,currentTab);
+        }else{
+            var msgs_to_export_id = get_selected_messages();
+        }
+        var handler_local_mesgs_to_export = function(data){
+            download_attachments(null, null, data, null,null,'mensagens.zip');
+        }
+        if(msgs_to_export_id){
+            this.init_local_messages();
+            var l_msg = "t";
+            var mesgs ="";
+            var subjects ="";
+            var rs = this.dbGears.execute("select mail,subject from mail where rowid in ("+msgs_to_export_id+")");
+            while(rs.isValidRow()){
+                mail = connector.unserialize(rs.field(0));
+                src = this.get_src(mail.url_export_file);
+                subject = rs.field(1);
+                mesgs += src;
+                mesgs += "@@";
+                subjects += subject;
+                subjects += "@@";
+                rs.next();
+            }
+            rs.close();
+            this.finalize();
+            mesgs = escape(mesgs);
+            subjects = escape(subjects);
+            params = "subjects="+subjects+"&mesgs="+mesgs+"&l_msg="+l_msg+"&msgs_to_export="+msgs_to_export_id;
+            cExecute ("$this.exporteml.makeAll&", handler_local_mesgs_to_export, params);
+        }
+        return true;
+    }
+
+    local_messages.prototype.get_all_local_folder_messages= function(folder_name){
+
+
+         var mesgs = new Array();
+         var subjects = new Array();
+         var hoje = new Date();
+         var msgs_to_export = new Array();
+         var l_msg="t";
+
+        this.init_local_messages();
+        var query = "select mail,subject,mail.rowid from mail inner join folder on (mail.id_folder=folder.rowid) where folder.folder='" + folder_name + "'";
+
+        var rs = this.dbGears.execute(" "+query)
+
+            var handler_local_mesgs_to_export = function(data){
+                    //alert("data - " + data + " - tipo - " + typeof(data));
+                    download_attachments(null, null, data, null,null,'mensagens.zip');
+            }
+        var j=0;
+        while (rs.isValidRow()){
+              msgs_to_export[j]=rs.field(2)
+              mail = connector.unserialize(rs.field(0));
+                      msg=this.get_src(mail.url_export_file);
+                      subject = rs.field(1);
+                      mesgs += msg;
+                      mesgs += "@@";
+                      subjects += subject;
+                      subjects += "@@";
+                      rs.next();
+              j++;
+
+        }
+           rs.close();
+           this.finalize();
+           source = escape(mesgs);
+           subjects = escape(subjects);
+           params = "folder="+folder_name+"&subjects="+subjects+"&mesgs="+source+"&l_msg="+l_msg+"&msgs_to_export="+msgs_to_export;
+           cExecute ("$this.exporteml.makeAll&", handler_local_mesgs_to_export, params);
+          
+
+    }
+
+
+    /*************************************************************************/
+
         
         var expresso_local_messages;