Changeset 3236
- Timestamp:
- 09/14/10 10:25:24 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.2/expressoMail1_2/js/local_messages.js
r3018 r3236 442 442 } 443 443 444 sql = 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen, mail.bodyas body,case when lower(mail.ffrom) like ? then ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\') else ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') end as order_from,mail.subject from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=? order by '444 sql = 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen,substr(mail.body,1,300) as body,case when lower(mail.ffrom) like ? then ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\') else ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') end as order_from,mail.subject from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=? order by ' 445 445 446 446 if(sort == 'SORTFROM') { … … 488 488 489 489 //declaracao do array() para receber o body de cada mensagem encontrada na busca sql realizada; 490 msg_body=this.strip_tags(msg_body); 491 msg_body=msg_body.replace(/\ /ig," "); 490 492 491 retorno[cont]['msg_sample'] = new Array(); 493 492 … … 498 497 else 499 498 { 500 retorno[cont]['msg_sample']['body'] = " - " + msg_body.substr(2,300); 499 msg_body += ">"; 500 msg_body=this.strip_tags(msg_body); 501 msg_body=msg_body.replace(/\ /ig," "); 502 retorno[cont]['msg_sample']['body'] = " - " + msg_body.substr(2,msg_body.length-1); 501 503 } 502 504
Note: See TracChangeset
for help on using the changeset viewer.