Context Navigation

source: trunk/expressoMail1_2/js/local_messages.js @ 1035

Revision 1035, 28.5 KB checked in by rafaelraymundo, 15 years ago (diff)
Ticket #558 - Adicionada funcionalidade de assinatura e criptografia de e-mails.

Line
1	/**
2	* @author diogenes
3	*/
4
5	function local_messages() {
6	this.dbGears = null;
7	this.localServer = null;
8	this.store = null;
9	this.fileSubmitter = null;
10	}
11
12	local_messages.prototype.init_local_messages = function(){
13	if(this.dbGears == null)
14	this.dbGears = google.gears.factory.create('beta.database');
15	if(this.localServer==null)
16	this.localServer = google.gears.factory.create('beta.localserver');
17	if(this.store==null)
18	this.store = this.localServer.createStore('test-store');
19	if(this.fileSubmitter == null)
20	this.fileSubmitter = this.store.createFileSubmitter();
21
22	this.dbGears.open('database-test');
23	this.dbGears.execute('create table if not exists folder (folder text,uid_usuario int,unique(folder,uid_usuario))');
24	this.dbGears.execute('create table if not exists mail' +
25	' (mail blob,original_id int,original_folder text,header blob,timestamp int,uid_usuario int,unseen int,id_folder int,' +
26	' ffrom text, subject text, fto text, cc text, body text, size int,unique (original_id,original_folder,uid_usuario))');
27	this.dbGears.execute('create table if not exists anexo' +
28	' (id_mail int,nome_anexo text,url text,pid int)');
29
30	//some people that used old version of local messages could not have the size column. If it's the first version
31	//with local messages you're using in expresso, this part of code can be removed
32	try {
33	this.dbGears.execute('alter table mail add column size int');
34	}catch(Exception) {
35
36	}
37	var rs = this.dbGears.execute('select rowid,header from mail where size is null');
38	while(rs.isValidRow()) {
39	var temp = connector.unserialize(rs.field(1));
40
41	this.dbGears.execute('update mail set size='+temp.Size+' where rowid='+rs.field(0));
42	rs.next();
43	}
44	//end of temporary code
45	}
46
47	local_messages.prototype.drop_tables = function() {
48	this.init_local_messages();
49	var rs = this.dbGears.execute('select url from anexo');
50	while(rs.isValidRow()) {
51	this.store.remove(rs.field(0));
52	rs.next();
53	}
54	this.dbGears.execute('drop table folder');
55	this.dbGears.execute('drop table mail');
56	this.dbGears.execute('drop table anexo');
57	this.finalize();
58	}
59
60	local_messages.prototype.insert_mail = function(msg_info,msg_header,anexos,folder) {
61	try {
62	this.init_local_messages();
63	var unseen = 0;
64	var login = msg_info.login;
65	var original_id = msg_info.msg_number;
66	var original_folder = msg_info.msg_folder;
67
68	//This fields needs to be separeted to search.
69	var from = connector.serialize(msg_info.from);
70	var subject = msg_info.subject;
71	var body = msg_info.body;
72	var to = connector.serialize(msg_info.toaddress2);
73	var cc = connector.serialize(msg_info.cc);
74	var size = msg_header.Size;
75
76	//do not duplicate this information
77	msg_info.from = null;
78	msg_info.subject = null;
79	msg_info.body = null;
80	msg_info.to = null;
81	msg_info.cc = null;
82	msg_header.Size=null;
83	//If the mail was archieved in the same date the user received it, the date cames with the time.
84	//here I solved it
85	if(msg_header.udate.indexOf(":")!=-1) {
86	msg_header.udate = msg_header.aux_date;
87	}
88
89	/**
90	* The importance attribute can be empty, and javascript consider as null causing nullpointer.
91	*/
92	if((msg_header.Importance == null) \|\| (msg_header.Importance == ""))
93	msg_header.Importance = "Normal";
94
95	msg_header.aux_date = null;
96
97	var mail = connector.serialize(msg_info);
98	var header = connector.serialize(msg_header);
99
100	var timestamp = msg_info.timestamp;
101	var id_folder;
102
103	if((folder==null) \|\| (folder=="local_root"))
104	folder = "Inbox";
105	else
106	folder = folder.substr(6);//take off the word "local_"
107
108	var rs = this.dbGears.execute("select rowid from folder where folder=? and uid_usuario=?",[folder,account_id]);
109	if(rs.isValidRow())
110	id_folder=rs.field(0);
111	else {
112	this.dbGears.execute("insert into folder (folder,uid_usuario) values (?,?)",["Inbox",account_id]);
113	id_folder = this.dbGears.lastInsertRowId;
114	}
115
116	if(msg_info.Unseen=="U")
117	unseen = 1;
118	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]);
119	var call_back = function() {
120	}
121	this.store.capture(msg_info.url_export_file,call_back);
122	var id_mail = this.dbGears.lastInsertRowId;
123
124	this.insert_attachments(id_mail,anexos);
125	this.finalize();
126	return true;
127	} catch (error) {
128	this.finalize();
129	return false;
130	}
131
132
133	}
134
135	local_messages.prototype.get_local_mail = function(id_mail) {
136	this.init_local_messages();
137	var rs = this.dbGears.execute("select mail.rowid,mail.mail,mail.ffrom,mail.subject,mail.body,mail.fto,mail.cc,folder.folder,mail.original_id from mail inner join folder on mail.id_folder=folder.rowid where mail.rowid="+id_mail);
138	var retorno = null;
139	if(rs.isValidRow()) {
140	retorno = rs.field(1);
141	}
142	retorno = connector.unserialize(retorno);
143
144	//alert('tipo retorno.source: ' + typeof(retorno.source));
145
146	if (typeof(retorno.source) == 'string')
147	{
148	retorno.msg_number=rs.field(0);
149	retorno.original_ID=rs.field(8);
150	retorno.msg_folder=rs.field(7);
151
152	//alert('tipo retorno: '+typeof(retorno))
153	//show_msg(retorno);
154	}
155	else
156	{
157	retorno['from'] = connector.unserialize(rs.field(2));
158	retorno['subject'] = rs.field(3);
159	retorno['body'] = rs.field(4);
160	//Codigo que as imagens embutidas em emails (com multipart/related ou multipart/mixed) sejam corretamente mostradas em emails arquivados. Os links do
161	//tipo "./inc/show_embedded_attach.php?msg_folder=[folder]&msg_num=[msg_num]&msg_part=[part]"
162	//são substituidos pelos links dos anexos capturados pelo gears.
163
164	var thumbs= retorno.thumbs;
165	var anexos= retorno.array_attach;
166	for (i in anexos)
167	{
168	nomeArquivo = anexos[i]['name'].substring(0,anexos[i]['name'].length - 4);
169	if(nomeArquivo.match('jpg')\|\|anexos[i]['name'].match('gif')\|\|anexos[i]['name'].match('png'))
170	{
171	var er_imagens = new RegExp("\\.\\/inc\\/show_embedded_attach.php\\?msg_folder=[\\w/]+\\&msg_num=[0-9]+\\&msg_part="+anexos[i]['pid']);
172	var Result_imagens = er_imagens.exec(retorno['body']);
173	retorno['body'] = retorno['body'].replace(Result_imagens,anexos[i]['url']);
174	if(thumbs && thumbs[i]){
175	er_imagens = new RegExp("\\.\\/inc\\/show_thumbs.php\\?file_type=image\\/[\\w]+\\&msg_num=[0-9]+\\&msg_folder=[\\w/%]+\\&msg_part="+anexos[i]['pid']);
176	Result_imagens = er_imagens.exec(thumbs[i]);
177	thumbs[i] = thumbs[i].replace(Result_imagens,"'"+anexos[i]['url']+"'");
178	er_imagens = new RegExp("\\.\\/inc\\/show_img.php\\?msg_num=[0-9]+\\&msg_folder=[\\w/%]+\\&msg_part="+anexos[i]['pid']);
179	Result_imagens = er_imagens.exec(thumbs[i]);
180	thumbs[i] = thumbs[i].replace(Result_imagens,"'"+anexos[i]['url']+"'");
181	thumbs[i] = thumbs[i].replace(/<IMG/i,'<img width="120"');
182	}
183	}
184	}
185
186	retorno['to'] = connector.unserialize(rs.field(5));
187	retorno['cc'] = connector.unserialize(rs.field(6));
188
189	retorno['local_message'] = true;
190	retorno['msg_folder'] = "local_"+rs.field(7); //Now it's a local folder
191	retorno['msg_number'] = rs.field(0); //the message number is the rowid
192
193	}
194
195	rs.close();
196	this.finalize();
197	return retorno;
198	}
199
200	local_messages.prototype.insert_attachments = function(id_msg,anexos) {
201	//insert_mail already close and open gears.
202	for (var i = 0; i < anexos.length; i++) {
203	this.dbGears.execute("insert into anexo (id_mail,nome_anexo,url,pid) values (?,?,?,?)", [id_msg, anexos[i]['name'],anexos[i]['url'],anexos[i]['pid']]);
204	this.save_anexos(anexos[i]['url']);
205	}
206	}
207
208	local_messages.prototype.save_anexos = function (url) {
209	//insert_mail already close and open gears.
210	var call_back = function(url,success,captureId) {
211	//alert("Capturado: " + url);
212	}
213	//alert(url);
214	this.store.capture(url,call_back);
215	}
216
217	local_messages.prototype.get_local_range_msgs = function(folder,msg_range_begin,emails_per_page,sort,sort_reverse,search) {
218	this.init_local_messages();
219	var retorno = new Array();
220	msg_range_begin--;
221
222	filter = " ";
223	if(search=="FLAGGED") {
224	filter = "and (header like '%\"Flagged\";s:1:\"F%' or header like '%\"Importance\";s:5:\"High%') ";
225	}
226	if(search=="UNSEEN") {
227	filter = "and unseen = 1 ";
228	}
229	if(search=="SEEN") {
230	filter = "and unseen = 0 ";
231	}
232	if (search=="ANSWERED") {
233	filter = "and header like '%\"Answered\";s:1:\"A%' ";
234	}
235	sql = 'select rowid,header,size,timestamp,unseen from (';
236	sql += 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen,ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\') as order_from,mail.subject from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=? and lower(mail.ffrom) not like lower(?) ';
237	sql += filter;
238	sql += 'union ';
239	sql += 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen,ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') as order_from,mail.subject from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=? and lower(mail.ffrom) like lower(?) ';
240	sql += filter;
241	sql += ') order by '
242
243	if(sort == 'SORTFROM') {
244	sql += 'order_from ';
245	}
246	if(sort == 'SORTARRIVAL') {
247	sql += 'timestamp ';
248	}
249	if(sort == 'SORTSIZE') {
250	sql += 'size ';
251	}
252	if(sort == 'SORTSUBJECT') {
253	sql += 'UPPER(subject) ';
254	}
255
256
257	sql+= sort_reverse==0?"ASC ":"DESC ";
258	sql +='limit ?,? ';
259
260
261	var rs = this.dbGears.execute(sql,[account_id,folder,'%'+Element("user_email").value+'%',account_id,folder,'%'+Element("user_email").value+'%',msg_range_begin,emails_per_page]);
262	var cont = 0;
263
264	var rs3 = this.dbGears.execute('select count(*) from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=?'+filter,[account_id,folder]);
265
266	while (rs.isValidRow()) {
267	//var email = rs.field(1);
268	var head = rs.field(1);
269	var codigoMail = rs.field(0);
270	var rs2 = this.dbGears.execute('select count(*) from anexo where id_mail = '+codigoMail);
271	var head_unserialized = connector.unserialize(head);
272	head_unserialized.Size = rs.field(2);
273	if(rs.field(4)==1)
274	head_unserialized.Unseen = 'U';
275
276	//var email_unserialized = connector.unserialize(email);
277	retorno[cont] = head_unserialized;
278	retorno[cont]['msg_number'] = codigoMail;
279
280	cont++;
281	rs.next();
282	}
283	retorno['num_msgs'] = rs3.field(0);
284	rs3.close();
285	rs.close();
286	if(cont>0)
287	rs2.close();
288	this.finalize();
289	return retorno;
290	}
291
292	local_messages.prototype.get_url_anexo = function(msg_number,pid) {
293	this.init_local_messages();
294
295	var retorno;
296	var rs = this.dbGears.execute("select url from anexo where id_mail="+msg_number+" and pid = '"+pid+"'");
297	retorno = rs.field(0)
298	this.finalize();
299
300	return retorno;
301	}
302
303	local_messages.prototype.getInputFileFromAnexo = function (element,url) {
304	this.init_local_messages();
305	this.fileSubmitter.setFileInputElement(element,url);
306	this.finalize();
307	}
308
309	local_messages.prototype.finalize = function() {
310	this.dbGears.close();
311	this.dbGears = null;
312	}
313
314	local_messages.prototype.delete_msgs = function(msgs_number,border_ID) {
315	this.init_local_messages();
316	var rs = this.dbGears.execute("select url from anexo where id_mail in ("+msgs_number+")");
317	while(rs.isValidRow()) {
318	this.store.remove(rs.field(0));
319	rs.next();
320	}
321	this.dbGears.execute("delete from anexo where id_mail in ("+msgs_number+")");
322	this.dbGears.execute("delete from mail where rowid in ("+msgs_number+")");
323	this.finalize();
324	if (msgs_number.length == 1)
325	write_msg(get_lang("The message was deleted."));
326	else
327	write_msg(get_lang("The messages were deleted."));
328
329	mail_msg = Element("tbody_box");
330
331	try {
332	msgs_exploded = msgs_number.split(",");
333	}catch(error) {
334	msgs_exploded = new Array();
335	msgs_exploded[0] = msgs_number;
336	}
337	var msg_to_delete;
338	for (var i=0; i<msgs_exploded.length; i++){
339	msg_to_delete = Element(msgs_exploded[i]);
340	if (msg_to_delete){
341	if ( (msg_to_delete.style.backgroundColor != '') && (preferences.use_shortcuts == '1') )
342	select_msg('null', 'down');
343	mail_msg.removeChild(msg_to_delete);
344	}
345	}
346	Element('chk_box_select_all_messages').checked = false;
347	if (border_ID != 'null')
348	delete_border(border_ID,'false');
349
350	}
351
352	local_messages.prototype.get_source_msg = function(id_msg) {
353	this.init_local_messages();
354	var rs = this.dbGears.execute("select mail from mail where rowid="+id_msg);
355
356
357	mail = connector.unserialize(rs.field(0));
358	download_local_attachment(mail.url_export_file)
359
360	this.finalize();
361	}
362
363	local_messages.prototype.set_messages_flag = function(msgs_number, flag) {
364	this.init_local_messages();
365	var msgs_to_set;
366	if (msgs_number == 'get_selected_messages') {
367	var msgs_to_set = get_selected_messages();
368	msgs_to_set= msgs_to_set.split(",");
369	}
370	else { //Just one message
371	msgs_to_set = new Array();
372	msgs_to_set[0] = msgs_number;
373	}
374	for (var i in msgs_to_set) {
375
376	var rs = this.dbGears.execute("select header,unseen from mail where rowid=" + msgs_to_set[i]);
377	header = connector.unserialize(rs.field(0));
378	unseen = rs.field(1);
379	if (flag == "unseen") {
380	set_msg_as_unread(msgs_to_set[i]);
381	header["Unseen"] = "U";
382	unseen = 1;
383	}
384	else
385	if (flag == "flagged") {
386	set_msg_as_flagged(msgs_to_set[i]);
387	header["Flagged"] = "F";
388	}
389	else
390	if (flag == "unflagged")
391	if (header["Importance"].indexOf("High") != -1)
392	write_msg(get_lang("At least one of selected message cant be marked as normal"));
393	else {
394	set_msg_as_unflagged(msgs_to_set[i]);
395	header["Flagged"] = "N";
396	}
397	else
398	if (flag == "seen") {
399	header["Unseen"] = "N";
400	set_msg_as_read(msgs_to_set[i],true);
401	unseen = 0;
402	}
403	rs.close();
404
405	if(Element("check_box_message_" + msgs_to_set[i]))
406	Element("check_box_message_" + msgs_to_set[i]).checked = false;
407
408	this.dbGears.execute("update mail set header='"+connector.serialize(header)+"',unseen="+unseen+" where rowid="+msgs_to_set[i]);
409	}
410	if(Element('chk_box_select_all_messages'))
411	Element('chk_box_select_all_messages').checked = false;
412	this.finalize();
413
414	}
415
416	local_messages.prototype.get_unseen_msgs_number = function() {
417	this.init_local_messages();
418	var rs = this.dbGears.execute("select count(*) from mail where unseen=1");
419	var retorno = rs.field(0);
420	rs.close();
421	this.finalize();
422	return retorno;
423	}
424
425	local_messages.prototype.create_folder = function(folder) {
426
427	if (folder.indexOf("local_") != -1)
428	return false; //can't create folder with string local_
429
430	this.init_local_messages();
431	try {
432	this.dbGears.execute("insert into folder (folder,uid_usuario) values (?,?)",[folder,account_id]);
433	} catch (error) {
434	this.finalize();
435	throw error;
436	return false;
437	}
438	this.finalize();
439	return true;
440	}
441
442	local_messages.prototype.list_local_folders = function(folder) {
443	this.init_local_messages();
444	var retorno = new Array();
445	rs = this.dbGears.execute("select folder.folder,sum(mail.unseen) from folder left join mail on "+
446	"folder.rowid=mail.id_folder where folder.uid_usuario=? group by folder.folder",[account_id]);
447	while(rs.isValidRow()) {
448	var temp = new Array();
449	temp[0] = rs.field(0);
450	temp[1] = rs.field(1);
451	retorno.push(temp);
452	rs.next();
453	}
454
455	rs.close();
456	this.finalize();
457	return retorno;
458	}
459
460	local_messages.prototype.rename_folder = function(folder,old_folder) {
461	if (folder.indexOf("local_") != -1)
462	return false; //can't create folder with string local_
463	this.init_local_messages();
464	try {
465	this.dbGears.execute("update folder set folder=? where folder=? and uid_usuario=?",[folder,old_folder,account_id]);
466	} catch (error) {
467	this.finalize();
468	return false;
469	}
470	this.finalize();
471	return true;
472	}
473
474	local_messages.prototype.remove_folder = function(folder) {
475	this.init_local_messages();
476	var rs = this.dbGears.execute("select rowid from folder where folder=? and uid_usuario=?",[folder,account_id]);
477	var folder_id = rs.field(0);
478	rs.close();
479	this.dbGears.execute("delete from folder where rowid=?",[folder_id]);
480	rs = this.dbGears.execute("select rowid,mail from mail where id_folder=?",[folder_id]);
481	while(rs.isValidRow()) {
482	var rs2 = this.dbGears.execute("select url from anexo where id_mail=?",[rs.field(0)]);
483	while(rs2.isValidRow()) {
484	this.store.remove(rs2.field(0));
485	rs2.next();
486	}
487	rs2.close();
488	this.dbGears.execute("delete from anexo where id_mail=?",[rs.field(0)]);
489	var mail = connector.unserialize(rs.field(1));
490	this.store.remove(mail.url_export_file);
491	rs.next();
492	}
493	rs.close();
494	this.dbGears.execute("delete from mail where id_folder=?",[folder_id]);
495	this.finalize();
496	}
497
498	local_messages.prototype.move_messages = function(new_folder,msgs_number) {
499	this.init_local_messages();
500	var rs = this.dbGears.execute("select rowid from folder where folder=? and uid_usuario=?",[new_folder,account_id]);
501	var id_folder = rs.field(0);
502	rs.close();
503	this.dbGears.execute("update mail set id_folder="+id_folder+" where rowid in ("+msgs_number.toString()+")"); //usando statement nï¿œo tava funcionando quando tinha mais de um email...
504	this.finalize();
505	}
506
507	local_messages.prototype.search = function(folders,filter) {
508	this.init_local_messages();
509	var filters = filter.replace(/##/g," ");
510	filters = filters.replace(/^ +\| +$/g,"");
511	filters = filters.split("<=>");
512	var friendly_filters = new Array();
513	if (filters[0].indexOf('ALL') != -1) { //all filters...
514	friendly_filters.push("SUBJECT");
515	friendly_filters.push(filters[1]);
516	friendly_filters.push("BODY");
517	friendly_filters.push(filters[1]);
518	friendly_filters.push("FROM");
519	friendly_filters.push(filters[1]);
520	friendly_filters.push("TO");
521	friendly_filters.push(filters[1]);
522	friendly_filters.push("CC");
523	friendly_filters.push(filters[1]);
524	}
525	else {
526	friendly_filters[0] = filters[0];
527	for (var i in filters) {
528	if (i != 0) {
529	var temp = filters[i].split(" ");
530	friendly_filters.push(temp[0]);
531	friendly_filters.push(temp[1]);
532	}
533	}
534	}
535	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 (";
536	for(var fnum in folders) {
537	sql+="'"+folders[fnum]+"'";
538	if(fnum<folders.length-1)
539	sql+=",";
540	}
541	sql += ") and (";
542	for (var z=0;z<friendly_filters.length-1;z++) {
543	if(z%2==0) {
544	if (z != 0) {
545	if (filters[0].indexOf('ALL') != -1)
546	sql += " or";
547	else
548	sql += " and";
549	}
550	sql+=" mail."+this.aux_convert_filter_field(friendly_filters[z])+" like '%"+url_decode(friendly_filters[z+1])+"%'";
551	}
552	}
553	sql += ")";
554	var rs = this.dbGears.execute(sql);
555	var retorno = "";
556	while(rs.isValidRow()) {
557	var header = connector.unserialize(rs.field(0));
558	retorno+="##"+"local_"+rs.field(1)+"--"+header["from"]["name"]+"--"+header["subject"]+"--"+header["udate"]+"--"+this.aux_convert_size(rs.field(3))+"--"+header["Unseen"]+header["Recent"]+header["Flagged"]+header["Draft"]+"--"+rs.field(2)+"##";
559	rs.next();
560	}
561
562	this.finalize();
563	return retorno==""?false:retorno;
564
565	}
566
567	local_messages.prototype.aux_convert_size = function(size) {
568	var tmp = Math.floor(size/1024);
569	if(tmp >= 1){
570	return tmp + " kb";
571	}else{
572	return size + " b";
573	}
574
575	}
576
577	local_messages.prototype.aux_convert_filter_field = function(filter) {
578	if((filter=="SUBJECT ") \|\| (filter=="SUBJECT"))
579	return "subject";
580	else if((filter=="BODY ") \|\| (filter=="BODY"))
581	return "body";
582	else if((filter=="FROM ") \|\| (filter=="FROM"))
583	return "ffrom";
584	else if((filter=="TO ") \|\| (filter=="TO"))
585	return "fto";
586	else if((filter=="CC ") \|\| (filter=="CC"))
587	return "cc";
588	}
589
590	local_messages.prototype.has_local_mails = function() {
591	this.init_local_messages();
592	var rs = this.dbGears.execute("select rowid from folder limit 0,1");
593	var retorno;
594	if(rs.isValidRow())
595	retorno = true;
596	else
597	retorno = false;
598	this.finalize();
599	return retorno;
600	}
601
602	//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).
603	local_messages.prototype.get_src = function(url){
604	AJAX = false;
605	if (window.XMLHttpRequest) { // Mozilla, Safari,...
606	AJAX = new XMLHttpRequest();
607	if (AJAX.overrideMimeType) {
608	AJAX.overrideMimeType('text/xml');
609	}
610	} else if (window.ActiveXObject) { // IE
611	try {
612	AJAX = new ActiveXObject("Msxml2.XMLHTTP");
613	} catch (e) {
614	try {
615	AJAX = new ActiveXObject("Microsoft.XMLHTTP");
616	} catch (e) {}
617	}
618	}
619
620	if (!AJAX) {
621	alert('ERRO :(Seu navegador não suporta a aplicação usada neste site');
622	return false;
623	}
624
625	AJAX.onreadystatechange = function() {
626	if (AJAX.readyState == 4) {
627	AJAX.src=AJAX.responseText;
628	if (AJAX.status == 200) {
629	return AJAX.responseText;
630	} else {
631	return false;
632	}
633	}
634	}
635
636	AJAX.open('get', url, false);
637	AJAX.send(null);
638	return AJAX.responseText;
639	};
640
641	//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
642	//para que elas sejam inseridas no imap pela função imap_functions.unarchive_mail.
643	local_messages.prototype.unarchive_msgs = function (folder,new_folder,msgs_number){
644
645	if(!new_folder)
646	new_folder='INBOX';
647	this.init_local_messages();
648	// alert(folder+new_folder+msgs_number);
649	var handler_unarchive = function(data)
650	{
651	if(data.error == '')
652	write_msg(get_lang('All messages are successfully unarchived'));
653	else
654	alert(data.error);
655	}
656	if(msgs_number =='selected' \|\| !msgs_number)
657	{
658	msgs_number = get_selected_messages()
659	if (!msgs_number){
660	write_msg(get_lang('No selected message.'));
661	return;
662	}
663	var rs = this.dbGears.execute("select mail,timestamp from mail where rowid in ("+msgs_number+")");
664	var source="";
665	var timestamp="";
666	while(rs.isValidRow()) {
667	mail=connector.unserialize(rs.field(0));
668	source_tmp=escape(this.get_src(mail.url_export_file));
669	source+="#@#@#@"+source_tmp;
670	timestamp+="#@#@#@"+rs.field(1);
671	rs.next();
672	}
673	rs.close();
674	this.finalize();
675	}
676	else
677	{
678	var rs = this.dbGears.execute("select mail,timestamp from mail where rowid="+msgs_number);
679	mail=connector.unserialize(rs.field(0));
680	var source ="";
681	source = this.get_src(mail.url_export_file);
682	timestamp=rs.field(1);
683	rs.close();
684	this.finalize();
685	}
686	params="&folder="+new_folder+"&source="+source+"&timestamp="+timestamp;
687	cExecute ("$this.imap_functions.unarchive_mail&", handler_unarchive, params);
688	}
689
690	local_messages.prototype.get_msg_date = function (original_id, is_local){
691
692	this.init_local_messages();
693
694	if (typeof(is_local) == 'undefined')
695	{
696	is_local = false;
697	}
698
699	var rs;
700
701	if (is_local)
702	{
703	rs = this.dbGears.execute("select mail from mail where rowid="+original_id);
704	}
705	else
706	{
707	rs = this.dbGears.execute("select mail from mail where original_id="+original_id);
708	}
709	var tmp = connector.unserialize(rs.field(0));
710	var ret = new Array();
711	ret.fulldate = tmp.fulldate.substr(0,16);
712	ret.smalldate = tmp.msg_day;
713	ret.msg_day = tmp.msg_day;
714	ret.msg_hour = tmp.msg_day;
715
716	rs.close();
717	this.finalize();
718	return ret;
719	}
720
721
722	local_messages.prototype.download_all_local_attachments = function(folder,id){
723	this.init_local_messages();
724	var rs = this.dbGears.execute("select mail from mail where rowid="+id);
725	var tmp = connector.unserialize(rs.field(0));
726	rs.close();
727	this.finalize();
728	source = this.get_src(tmp.url_export_file);
729	source = escape(source);
730	var handler_source = function(data){
731	download_attachments(null, null, data, null,null,'anexos.zip');
732	}
733	cExecute("$this.imap_functions.download_all_local_attachments",handler_source,"source="+source);
734	}
735
736	/*************************************************************************/
737	/* Funcao usada para exportar mensagens arquivadas localmente.
738	* Rommel de Brito Cysne (rommel.cysne@serpro.gov.br)
739	* em 22/12/2008.
740	*/
741	local_messages.prototype.local_messages_to_export = function(){
742
743	if (openTab.type[currentTab] > 1){
744	var msgs_to_export_id = currentTab.substring(0,currentTab.length-2,currentTab);
745	}else{
746	var msgs_to_export_id = get_selected_messages();
747	}
748	var handler_local_mesgs_to_export = function(data){
749	download_attachments(null, null, data, null,null,'mensagens.zip');
750	}
751	if(msgs_to_export_id){
752	this.init_local_messages();
753	var l_msg = "t";
754	var mesgs ="";
755	var subjects ="";
756	var rs = this.dbGears.execute("select mail,subject from mail where rowid in ("+msgs_to_export_id+")");
757	while(rs.isValidRow()){
758	mail = connector.unserialize(rs.field(0));
759	src = this.get_src(mail.url_export_file);
760	subject = rs.field(1);
761	mesgs += src;
762	mesgs += "@@";
763	subjects += subject;
764	subjects += "@@";
765	rs.next();
766	}
767	rs.close();
768	this.finalize();
769	mesgs = escape(mesgs);
770	subjects = escape(subjects);
771	params = "subjects="+subjects+"&mesgs="+mesgs+"&l_msg="+l_msg+"&msgs_to_export="+msgs_to_export_id;
772	cExecute ("$this.exporteml.makeAll&", handler_local_mesgs_to_export, params);
773	}
774	return true;
775	}
776
777	local_messages.prototype.get_all_local_folder_messages= function(folder_name){
778
779
780	var mesgs = new Array();
781	var subjects = new Array();
782	var hoje = new Date();
783	var msgs_to_export = new Array();
784	var l_msg="t";
785
786	this.init_local_messages();
787	var query = "select mail,subject,mail.rowid from mail inner join folder on (mail.id_folder=folder.rowid) where folder.folder='" + folder_name + "'";
788
789	var rs = this.dbGears.execute(" "+query)
790
791	var handler_local_mesgs_to_export = function(data){
792	//alert("data - " + data + " - tipo - " + typeof(data));
793	download_attachments(null, null, data, null,null,'mensagens.zip');
794	}
795	var j=0;
796	while (rs.isValidRow()){
797	msgs_to_export[j]=rs.field(2)
798	mail = connector.unserialize(rs.field(0));
799	msg=this.get_src(mail.url_export_file);
800	subject = rs.field(1);
801	mesgs += msg;
802	mesgs += "@@";
803	subjects += subject;
804	subjects += "@@";
805	rs.next();
806	j++;
807
808	}
809	rs.close();
810	this.finalize();
811	source = escape(mesgs);
812	subjects = escape(subjects);
813	params = "folder="+folder_name+"&subjects="+subjects+"&mesgs="+source+"&l_msg="+l_msg+"&msgs_to_export="+msgs_to_export;
814	cExecute ("$this.exporteml.makeAll&", handler_local_mesgs_to_export, params);
815
816
817	}
818
819
820	/*************************************************************************/
821
822
823	var expresso_local_messages;
824	expresso_local_messages = new local_messages();

Note: See TracBrowser for help on using the repository browser.

Download in other formats: