- Timestamp:
- 12/10/09 15:59:39 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/expressoMail1_2/js/local_messages.js
r1752 r1806 392 392 } 393 393 394 local_messages.prototype.get_local_range_msgs = function(folder,msg_range_begin,emails_per_page,sort,sort_reverse,search) { 394 local_messages.prototype.strip_tags = function (str) { 395 return str.replace(/<\/?[^>]+>/gi, ''); 396 } 397 398 local_messages.prototype.get_local_range_msgs = function(folder,msg_range_begin,emails_per_page,sort,sort_reverse,search,preview_msg_subject,preview_msg_tip) { 399 395 400 this.init_local_messages(); 396 401 var retorno = new Array(); … … 410 415 filter = "and header like '%\"Answered\";s:1:\"A%' "; 411 416 } 412 sql = 'select rowid,header,size,timestamp,unseen from (';413 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(?) ';417 sql = 'select rowid,header,size,timestamp,unseen,body from ('; 418 sql += 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen,mail.body as body,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(?) '; 414 419 sql += filter; 415 420 sql += 'union '; 416 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(?) ';421 sql += 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen,mail.body as body,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(?) '; 417 422 sql += filter; 418 423 sql += ') order by ' … … 472 477 else 473 478 { 474 retorno[cont]['msg_sample']['body'] = " - " + msg_body.substr( 3,300);479 retorno[cont]['msg_sample']['body'] = " - " + msg_body.substr(2,300); 475 480 } 476 481
Note: See TracChangeset
for help on using the changeset viewer.