Context Navigation

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

Revision 1000, 27.3 KB checked in by rafaelraymundo, 15 years ago (diff)
Ticket #550 - Unificação de funcionalidade do SERPRO referentes ao arquivamento local.

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 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	retorno['from'] = connector.unserialize(rs.field(2));
145	retorno['subject'] = rs.field(3);
146	retorno['body'] = rs.field(4);
147	//Codigo que as imagens embutidas em emails (com multipart/related ou multipart/mixed) sejam corretamente mostradas em emails arquivados. Os links do
148	//tipo "./inc/show_embedded_attach.php?msg_folder=[folder]&msg_num=[msg_num]&msg_part=[part]"
149	//são substituidos pelos links dos anexos capturados pelo gears.
150
151	var thumbs= retorno.thumbs;
152	var anexos= retorno.array_attach;
153	for (i in anexos)
154	{
155	nomeArquivo = anexos[i]['name'].substring(0,anexos[i]['name'].length - 4);
156	if(nomeArquivo.match('jpg')\|\|anexos[i]['name'].match('gif')\|\|anexos[i]['name'].match('png'))
157	{
158	var er_imagens = new RegExp("\\.\\/inc\\/show_embedded_attach.php\\?msg_folder=[\\w/]+\\&msg_num=[0-9]+\\&msg_part="+anexos[i]['pid']);
159	var Result_imagens = er_imagens.exec(retorno['body']);
160	retorno['body'] = retorno['body'].replace(Result_imagens,anexos[i]['url']);
161	if(thumbs && thumbs[i]){
162	er_imagens = new RegExp("\\.\\/inc\\/show_thumbs.php\\?file_type=image\\/[\\w]+\\&msg_num=[0-9]+\\&msg_folder=[\\w/%]+\\&msg_part="+anexos[i]['pid']);
163	Result_imagens = er_imagens.exec(thumbs[i]);
164	thumbs[i] = thumbs[i].replace(Result_imagens,"'"+anexos[i]['url']+"'");
165	er_imagens = new RegExp("\\.\\/inc\\/show_img.php\\?msg_num=[0-9]+\\&msg_folder=[\\w/%]+\\&msg_part="+anexos[i]['pid']);
166	Result_imagens = er_imagens.exec(thumbs[i]);
167	thumbs[i] = thumbs[i].replace(Result_imagens,"'"+anexos[i]['url']+"'");
168	thumbs[i] = thumbs[i].replace(/<IMG/i,'<img width="120"');
169	}
170	}
171	}
172
173	retorno['to'] = connector.unserialize(rs.field(5));
174	retorno['cc'] = connector.unserialize(rs.field(6));
175
176	retorno['local_message'] = true;
177	retorno['msg_folder'] = "local_"+rs.field(7); //Now it's a local folder
178	retorno['msg_number'] = rs.field(0); //the message number is the rowid
179	this.finalize();
180	return retorno;
181	}
182
183	local_messages.prototype.insert_attachments = function(id_msg,anexos) {
184	//insert_mail already close and open gears.
185	for (var i = 0; i < anexos.length; i++) {
186	this.dbGears.execute("insert into anexo (id_mail,nome_anexo,url,pid) values (?,?,?,?)", [id_msg, anexos[i]['name'],anexos[i]['url'],anexos[i]['pid']]);
187	this.save_anexos(anexos[i]['url']);
188	}
189	}
190
191	local_messages.prototype.save_anexos = function (url) {
192	//insert_mail already close and open gears.
193	var call_back = function(url,success,captureId) {
194	//alert("Capturado: " + url);
195	}
196	//alert(url);
197	this.store.capture(url,call_back);
198	}
199
200	local_messages.prototype.get_local_range_msgs = function(folder,msg_range_begin,emails_per_page,sort,sort_reverse,search) {
201	this.init_local_messages();
202	var retorno = new Array();
203	msg_range_begin--;
204
205	filter = " ";
206	if(search=="FLAGGED") {
207	filter = "and (header like '%\"Flagged\";s:1:\"F%' or header like '%\"Importance\";s:5:\"High%') ";
208	}
209	if(search=="UNSEEN") {
210	filter = "and unseen = 1 ";
211	}
212	if(search=="SEEN") {
213	filter = "and unseen = 0 ";
214	}
215	if (search=="ANSWERED") {
216	filter = "and header like '%\"Answered\";s:1:\"A%' ";
217	}
218	sql = 'select rowid,header,size,timestamp,unseen from (';
219	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(?) ';
220	sql += filter;
221	sql += 'union ';
222	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(?) ';
223	sql += filter;
224	sql += ') order by '
225
226	if(sort == 'SORTFROM') {
227	sql += 'order_from ';
228	}
229	if(sort == 'SORTARRIVAL') {
230	sql += 'timestamp ';
231	}
232	if(sort == 'SORTSIZE') {
233	sql += 'size ';
234	}
235	if(sort == 'SORTSUBJECT') {
236	sql += 'UPPER(subject) ';
237	}
238
239
240	sql+= sort_reverse==0?"ASC ":"DESC ";
241	sql +='limit ?,? ';
242
243
244	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]);
245	var cont = 0;
246
247	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]);
248
249	while (rs.isValidRow()) {
250	//var email = rs.field(1);
251	var head = rs.field(1);
252	var codigoMail = rs.field(0);
253	var rs2 = this.dbGears.execute('select count(*) from anexo where id_mail = '+codigoMail);
254	var head_unserialized = connector.unserialize(head);
255	head_unserialized.Size = rs.field(2);
256	if(rs.field(4)==1)
257	head_unserialized.Unseen = 'U';
258
259	//var email_unserialized = connector.unserialize(email);
260	retorno[cont] = head_unserialized;
261	retorno[cont]['msg_number'] = codigoMail;
262
263	cont++;
264	rs.next();
265	}
266	retorno['num_msgs'] = rs3.field(0);
267	rs3.close();
268	rs.close();
269	if(cont>0)
270	rs2.close();
271	this.finalize();
272	return retorno;
273	}
274
275	local_messages.prototype.get_url_anexo = function(msg_number,pid) {
276	this.init_local_messages();
277
278	var retorno;
279	var rs = this.dbGears.execute("select url from anexo where id_mail="+msg_number+" and pid = '"+pid+"'");
280	retorno = rs.field(0)
281	this.finalize();
282
283	return retorno;
284	}
285
286	local_messages.prototype.getInputFileFromAnexo = function (element,url) {
287	this.init_local_messages();
288	this.fileSubmitter.setFileInputElement(element,url);
289	this.finalize();
290	}
291
292	local_messages.prototype.finalize = function() {
293	this.dbGears.close();
294	this.dbGears = null;
295	}
296
297	local_messages.prototype.delete_msgs = function(msgs_number,border_ID) {
298	this.init_local_messages();
299	var rs = this.dbGears.execute("select url from anexo where id_mail in ("+msgs_number+")");
300	while(rs.isValidRow()) {
301	this.store.remove(rs.field(0));
302	rs.next();
303	}
304	this.dbGears.execute("delete from anexo where id_mail in ("+msgs_number+")");
305	this.dbGears.execute("delete from mail where rowid in ("+msgs_number+")");
306	this.finalize();
307	if (msgs_number.length == 1)
308	write_msg(get_lang("The message was deleted."));
309	else
310	write_msg(get_lang("The messages were deleted."));
311
312	mail_msg = Element("tbody_box");
313
314	try {
315	msgs_exploded = msgs_number.split(",");
316	}catch(error) {
317	msgs_exploded = new Array();
318	msgs_exploded[0] = msgs_number;
319	}
320	var msg_to_delete;
321	for (var i=0; i<msgs_exploded.length; i++){
322	msg_to_delete = Element(msgs_exploded[i]);
323	if (msg_to_delete){
324	if ( (msg_to_delete.style.backgroundColor != '') && (preferences.use_shortcuts == '1') )
325	select_msg('null', 'down');
326	mail_msg.removeChild(msg_to_delete);
327	}
328	}
329	Element('chk_box_select_all_messages').checked = false;
330	if (border_ID != 'null')
331	delete_border(border_ID,'false');
332
333	}
334
335	local_messages.prototype.get_source_msg = function(id_msg) {
336	this.init_local_messages();
337	var rs = this.dbGears.execute("select mail from mail where rowid="+id_msg);
338
339
340	mail = connector.unserialize(rs.field(0));
341	download_local_attachment(mail.url_export_file)
342
343	this.finalize();
344	}
345
346	local_messages.prototype.set_messages_flag = function(msgs_number, flag) {
347	this.init_local_messages();
348	var msgs_to_set;
349	if (msgs_number == 'get_selected_messages') {
350	var msgs_to_set = get_selected_messages();
351	msgs_to_set= msgs_to_set.split(",");
352	}
353	else { //Just one message
354	msgs_to_set = new Array();
355	msgs_to_set[0] = msgs_number;
356	}
357	for (var i in msgs_to_set) {
358
359	var rs = this.dbGears.execute("select header,unseen from mail where rowid=" + msgs_to_set[i]);
360	header = connector.unserialize(rs.field(0));
361	unseen = rs.field(1);
362	if (flag == "unseen") {
363	set_msg_as_unread(msgs_to_set[i]);
364	header["Unseen"] = "U";
365	unseen = 1;
366	}
367	else
368	if (flag == "flagged") {
369	set_msg_as_flagged(msgs_to_set[i]);
370	header["Flagged"] = "F";
371	}
372	else
373	if (flag == "unflagged")
374	if (header["Importance"].indexOf("High") != -1)
375	write_msg(get_lang("At least one of selected message cant be marked as normal"));
376	else {
377	set_msg_as_unflagged(msgs_to_set[i]);
378	header["Flagged"] = "N";
379	}
380	else
381	if (flag == "seen") {
382	header["Unseen"] = "N";
383	set_msg_as_read(msgs_to_set[i],true);
384	unseen = 0;
385	}
386	rs.close();
387
388	if(Element("check_box_message_" + msgs_to_set[i]))
389	Element("check_box_message_" + msgs_to_set[i]).checked = false;
390
391	this.dbGears.execute("update mail set header='"+connector.serialize(header)+"',unseen="+unseen+" where rowid="+msgs_to_set[i]);
392	}
393	if(Element('chk_box_select_all_messages'))
394	Element('chk_box_select_all_messages').checked = false;
395	this.finalize();
396
397	}
398
399	local_messages.prototype.get_unseen_msgs_number = function() {
400	this.init_local_messages();
401	var rs = this.dbGears.execute("select count(*) from mail where unseen=1");
402	var retorno = rs.field(0);
403	rs.close();
404	this.finalize();
405	return retorno;
406	}
407
408	local_messages.prototype.create_folder = function(folder) {
409
410	if (folder.indexOf("local_") != -1)
411	return false; //can't create folder with string local_
412
413	this.init_local_messages();
414	try {
415	this.dbGears.execute("insert into folder (folder,uid_usuario) values (?,?)",[folder,account_id]);
416	} catch (error) {
417	this.finalize();
418	throw error;
419	return false;
420	}
421	this.finalize();
422	return true;
423	}
424
425	local_messages.prototype.list_local_folders = function(folder) {
426	this.init_local_messages();
427	var retorno = new Array();
428	rs = this.dbGears.execute("select folder.folder,sum(mail.unseen) from folder left join mail on "+
429	"folder.rowid=mail.id_folder where folder.uid_usuario=? group by folder.folder",[account_id]);
430	while(rs.isValidRow()) {
431	var temp = new Array();
432	temp[0] = rs.field(0);
433	temp[1] = rs.field(1);
434	retorno.push(temp);
435	rs.next();
436	}
437
438	rs.close();
439	this.finalize();
440	return retorno;
441	}
442
443	local_messages.prototype.rename_folder = function(folder,old_folder) {
444	if (folder.indexOf("local_") != -1)
445	return false; //can't create folder with string local_
446	this.init_local_messages();
447	try {
448	this.dbGears.execute("update folder set folder=? where folder=? and uid_usuario=?",[folder,old_folder,account_id]);
449	} catch (error) {
450	this.finalize();
451	return false;
452	}
453	this.finalize();
454	return true;
455	}
456
457	local_messages.prototype.remove_folder = function(folder) {
458	this.init_local_messages();
459	var rs = this.dbGears.execute("select rowid from folder where folder=? and uid_usuario=?",[folder,account_id]);
460	var folder_id = rs.field(0);
461	rs.close();
462	this.dbGears.execute("delete from folder where rowid=?",[folder_id]);
463	rs = this.dbGears.execute("select rowid,mail from mail where id_folder=?",[folder_id]);
464	while(rs.isValidRow()) {
465	var rs2 = this.dbGears.execute("select url from anexo where id_mail=?",[rs.field(0)]);
466	while(rs2.isValidRow()) {
467	this.store.remove(rs2.field(0));
468	rs2.next();
469	}
470	rs2.close();
471	this.dbGears.execute("delete from anexo where id_mail=?",[rs.field(0)]);
472	var mail = connector.unserialize(rs.field(1));
473	this.store.remove(mail.url_export_file);
474	rs.next();
475	}
476	rs.close();
477	this.dbGears.execute("delete from mail where id_folder=?",[folder_id]);
478	this.finalize();
479	}
480
481	local_messages.prototype.move_messages = function(new_folder,msgs_number) {
482	this.init_local_messages();
483	var rs = this.dbGears.execute("select rowid from folder where folder=? and uid_usuario=?",[new_folder,account_id]);
484	var id_folder = rs.field(0);
485	rs.close();
486	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...
487	this.finalize();
488	}
489
490	local_messages.prototype.search = function(folders,filter) {
491	this.init_local_messages();
492	var filters = filter.replace(/##/g," ");
493	filters = filters.replace(/^ +\| +$/g,"");
494	filters = filters.split("<=>");
495	var friendly_filters = new Array();
496	if (filters[0].indexOf('ALL') != -1) { //all filters...
497	friendly_filters.push("SUBJECT");
498	friendly_filters.push(filters[1]);
499	friendly_filters.push("BODY");
500	friendly_filters.push(filters[1]);
501	friendly_filters.push("FROM");
502	friendly_filters.push(filters[1]);
503	friendly_filters.push("TO");
504	friendly_filters.push(filters[1]);
505	friendly_filters.push("CC");
506	friendly_filters.push(filters[1]);
507	}
508	else {
509	friendly_filters[0] = filters[0];
510	for (var i in filters) {
511	if (i != 0) {
512	var temp = filters[i].split(" ");
513	friendly_filters.push(temp[0]);
514	friendly_filters.push(temp[1]);
515	}
516	}
517	}
518	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 (";
519	for(var fnum in folders) {
520	sql+="'"+folders[fnum]+"'";
521	if(fnum<folders.length-1)
522	sql+=",";
523	}
524	sql += ") and (";
525	for (var z=0;z<friendly_filters.length-1;z++) {
526	if(z%2==0) {
527	if (z != 0) {
528	if (filters[0].indexOf('ALL') != -1)
529	sql += " or";
530	else
531	sql += " and";
532	}
533	sql+=" mail."+this.aux_convert_filter_field(friendly_filters[z])+" like '%"+url_decode(friendly_filters[z+1])+"%'";
534	}
535	}
536	sql += ")";
537	var rs = this.dbGears.execute(sql);
538	var retorno = "";
539	while(rs.isValidRow()) {
540	var header = connector.unserialize(rs.field(0));
541	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)+"##";
542	rs.next();
543	}
544
545	this.finalize();
546	return retorno==""?false:retorno;
547
548	}
549
550	local_messages.prototype.aux_convert_size = function(size) {
551	var tmp = Math.floor(size/1024);
552	if(tmp >= 1){
553	return tmp + " kb";
554	}else{
555	return size + " b";
556	}
557
558	}
559
560	local_messages.prototype.aux_convert_filter_field = function(filter) {
561	if((filter=="SUBJECT ") \|\| (filter=="SUBJECT"))
562	return "subject";
563	else if((filter=="BODY ") \|\| (filter=="BODY"))
564	return "body";
565	else if((filter=="FROM ") \|\| (filter=="FROM"))
566	return "ffrom";
567	else if((filter=="TO ") \|\| (filter=="TO"))
568	return "fto";
569	else if((filter=="CC ") \|\| (filter=="CC"))
570	return "cc";
571	}
572
573	local_messages.prototype.has_local_mails = function() {
574	this.init_local_messages();
575	var rs = this.dbGears.execute("select rowid from folder limit 0,1");
576	var retorno;
577	if(rs.isValidRow())
578	retorno = true;
579	else
580	retorno = false;
581	this.finalize();
582	return retorno;
583	}
584
585	//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).
586	local_messages.prototype.get_src = function(url){
587	AJAX = false;
588	if (window.XMLHttpRequest) { // Mozilla, Safari,...
589	AJAX = new XMLHttpRequest();
590	if (AJAX.overrideMimeType) {
591	AJAX.overrideMimeType('text/xml');
592	}
593	} else if (window.ActiveXObject) { // IE
594	try {
595	AJAX = new ActiveXObject("Msxml2.XMLHTTP");
596	} catch (e) {
597	try {
598	AJAX = new ActiveXObject("Microsoft.XMLHTTP");
599	} catch (e) {}
600	}
601	}
602
603	if (!AJAX) {
604	alert('ERRO :(Seu navegador não suporta a aplicação usada neste site');
605	return false;
606	}
607
608	AJAX.onreadystatechange = function() {
609	if (AJAX.readyState == 4) {
610	AJAX.src=AJAX.responseText;
611	if (AJAX.status == 200) {
612	return AJAX.responseText;
613	} else {
614	return false;
615	}
616	}
617	}
618
619	AJAX.open('get', url, false);
620	AJAX.send(null);
621	return AJAX.responseText;
622	};
623
624	//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
625	//para que elas sejam inseridas no imap pela função imap_functions.unarchive_mail.
626	local_messages.prototype.unarchive_msgs = function (folder,new_folder,msgs_number){
627
628	if(!new_folder)
629	new_folder='INBOX';
630	this.init_local_messages();
631	// alert(folder+new_folder+msgs_number);
632	var handler_unarchive = function(data)
633	{
634	if(data.error == '')
635	write_msg(get_lang('All messages are successfully unarchived'));
636	else
637	alert(data.error);
638	}
639	if(msgs_number =='selected' \|\| !msgs_number)
640	{
641	msgs_number = get_selected_messages()
642	if (!msgs_number){
643	write_msg(get_lang('No selected message.'));
644	return;
645	}
646	var rs = this.dbGears.execute("select mail,timestamp from mail where rowid in ("+msgs_number+")");
647	var source="";
648	var timestamp="";
649	while(rs.isValidRow()) {
650	mail=connector.unserialize(rs.field(0));
651	source_tmp=escape(this.get_src(mail.url_export_file));
652	source+="#@#@#@"+source_tmp;
653	timestamp+="#@#@#@"+rs.field(1);
654	rs.next();
655	}
656	rs.close();
657	this.finalize();
658	}
659	else
660	{
661	var rs = this.dbGears.execute("select mail,timestamp from mail where rowid="+msgs_number);
662	mail=connector.unserialize(rs.field(0));
663	var source ="";
664	source = this.get_src(mail.url_export_file);
665	timestamp=rs.field(1);
666	rs.close();
667	this.finalize();
668	}
669	params="&folder="+new_folder+"&source="+source+"&timestamp="+timestamp;
670	cExecute ("$this.imap_functions.unarchive_mail&", handler_unarchive, params);
671	}
672
673
674	local_messages.prototype.download_all_local_attachments = function(folder,id){
675	this.init_local_messages();
676	var rs = this.dbGears.execute("select mail from mail where rowid="+id);
677	var tmp = connector.unserialize(rs.field(0));
678	rs.close();
679	this.finalize();
680	source = this.get_src(tmp.url_export_file);
681	source = escape(source);
682	var handler_source = function(data){
683	download_attachments(null, null, data, null,null,'anexos.zip');
684	}
685	cExecute("$this.imap_functions.download_all_local_attachments",handler_source,"source="+source);
686	}
687
688	/*************************************************************************/
689	/* Funcao usada para exportar mensagens arquivadas localmente.
690	* Rommel de Brito Cysne (rommel.cysne@serpro.gov.br)
691	* em 22/12/2008.
692	*/
693	local_messages.prototype.local_messages_to_export = function(){
694
695	if (openTab.type[currentTab] > 1){
696	var msgs_to_export_id = currentTab.substring(0,currentTab.length-2,currentTab);
697	}else{
698	var msgs_to_export_id = get_selected_messages();
699	}
700	var handler_local_mesgs_to_export = function(data){
701	download_attachments(null, null, data, null,null,'mensagens.zip');
702	}
703	if(msgs_to_export_id){
704	this.init_local_messages();
705	var l_msg = "t";
706	var mesgs ="";
707	var subjects ="";
708	var rs = this.dbGears.execute("select mail,subject from mail where rowid in ("+msgs_to_export_id+")");
709	while(rs.isValidRow()){
710	mail = connector.unserialize(rs.field(0));
711	src = this.get_src(mail.url_export_file);
712	subject = rs.field(1);
713	mesgs += src;
714	mesgs += "@@";
715	subjects += subject;
716	subjects += "@@";
717	rs.next();
718	}
719	rs.close();
720	this.finalize();
721	mesgs = escape(mesgs);
722	subjects = escape(subjects);
723	params = "subjects="+subjects+"&mesgs="+mesgs+"&l_msg="+l_msg+"&msgs_to_export="+msgs_to_export_id;
724	cExecute ("$this.exporteml.makeAll&", handler_local_mesgs_to_export, params);
725	}
726	return true;
727	}
728
729	local_messages.prototype.get_all_local_folder_messages= function(folder_name){
730
731
732	var mesgs = new Array();
733	var subjects = new Array();
734	var hoje = new Date();
735	var msgs_to_export = new Array();
736	var l_msg="t";
737
738	this.init_local_messages();
739	var query = "select mail,subject,mail.rowid from mail inner join folder on (mail.id_folder=folder.rowid) where folder.folder='" + folder_name + "'";
740
741	var rs = this.dbGears.execute(" "+query)
742
743	var handler_local_mesgs_to_export = function(data){
744	//alert("data - " + data + " - tipo - " + typeof(data));
745	download_attachments(null, null, data, null,null,'mensagens.zip');
746	}
747	var j=0;
748	while (rs.isValidRow()){
749	msgs_to_export[j]=rs.field(2)
750	mail = connector.unserialize(rs.field(0));
751	msg=this.get_src(mail.url_export_file);
752	subject = rs.field(1);
753	mesgs += msg;
754	mesgs += "@@";
755	subjects += subject;
756	subjects += "@@";
757	rs.next();
758	j++;
759
760	}
761	rs.close();
762	this.finalize();
763	source = escape(mesgs);
764	subjects = escape(subjects);
765	params = "folder="+folder_name+"&subjects="+subjects+"&mesgs="+source+"&l_msg="+l_msg+"&msgs_to_export="+msgs_to_export;
766	cExecute ("$this.exporteml.makeAll&", handler_local_mesgs_to_export, params);
767
768
769	}
770
771
772	/*************************************************************************/
773
774
775	var expresso_local_messages;
776	expresso_local_messages = new local_messages();

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

Download in other formats: