email msg body

[Hasan Yousef]

Hi Peter..

I'm testing the email in partial, but looks not clear tome how to make the body of the msg, I tried following the same concept in your example, but with no model data, and got the error in the attached.

Kindly advise.

Thanks.

[Peter Širka]

Hi Hasan,

the problem is in:

// render view to string
var msgBody = self.view('email', null, true);
// ...
// ...
// ...
// ... message.send(...)
// prevent timeout
self.empty();

Thanks :-)

[Hasan Yousef]

HiPeter,

I tried the below, still getting the same

   var msgBody = self.view('email',null,true);

   var message = new mail.Message('email subject', msgBody);

    message.send('smtp.gmail.com', { port: 465, secure: true,  timeout: 60000, user: '@gmail.com', password: 'mypswd' });

   self.empty();

[Peter Širka]

Please write me output of:

console.log(typeof(msgBody), msgBody);

Thanks

[Hasan A Yousef]

Kindly see attached.

[Peter Širka]

This must work:

var msgBody = self.view('email', null, true);

Please, check your code again!

[Hasan A Yousef]

I used exact statement!

function view_items_homepage(){

var self = this;

    self.view('itemsIndex');

   

         var msgBody = self.view('email',null,true); 

   var message = new mail.Message('email subject', msgBody);   

   message.to('ha...@gmail.com'); 

   message.reply('ha...@gmail.com'); 

   message.from('ha...@gmail.com','Hasan test');

   message.send('smtp.gmail.com', { port: 465, secure: true,  timeout: 60000, user: 'ha...@gmail.com', password: 'pswd' });

   console.log('type of msgBody: ',typeof(msgBody));

   console.log('msgBody: ',msgBody);

   self.empty();

}

[Hasan A Yousef]

Hi Peter..

I tried creating a model from mySQL, but looks the data is not moving out of the mySQL connect pool, how can I get the data, so I move it to the mail body template, and be able to send the email with the data

function items_json_data() {

  var self = this;

  var SQL="Select * from users";  

  var model={};

  

  var connection = self.database('test');

    connection.connect();

    connection.query(SQL,function (err, rows) {

        if (err) {self.view('~/errors/internalServerError'); return; }

        self.json(rows);

        utils.extend(model,rows,true);

        console.log('model inside connection',model);   //This is OK, same date in rows

    });

    connection.end();

   console.log('model outside connection',model);  //This is empty

  

   var msgBody = self.view('email',model,true);

   var message = new mail.Message('email subject', 'test');

   message.to('email');

   message.reply('email');

   message.from('email','name');

   message.send(...);

   self.empty();

}

[Peter Širka]

I found a bug and I fixed it.

function view_items_homepage(){
   var self = this;

   // HERE IS BUG: self.view('itemsIndex');
   // I FIXED IT IN NEW VERSION
   var msgBody = self.view('email',null,true);
   var message = new mail.Message('email subject', msgBody);  

   message.to('ha...@gmail.com');
   message.reply('ha...@gmail.com');
   message.from('ha...@gmail.com','Hasan test');

   message.send('smtp.gmail.com', { port: 465, secure: true,  timeout: 60000, user: 'ha...@gmail.com', password: 'pswd' });
   console.log('type of msgBody: ',typeof(msgBody));
   console.log('msgBody: ',msgBody);

   // HERE RETURN A RESPONSE
   self.view('itemsIndex');

}

Thanks

[Peter Širka]

Yes because data is returned into the callback.

This is correct:

connection.query(SQL,function (err, rows) {
   
   if (err) {
      self.view('~/errors/internalServerError');
      return;
   }

   self.json(rows);
   utils.extend(model,rows,true);
   console.log('model inside connection',model);

   connection.end();

   var msgBody = self.view('email',model,true);
   var message = new mail.Message('email subject', 'test');

   message.to('email');
   message.reply('email');
   message.from('email','name');
   message.send(...);

   self.empty();  

});

[Hasan Yousef]

even with model data, show the same error.

[Hasan Yousef]

Finally it is done...

the bug is no self.json, or another self.view should appear in the controller.

Thanks Peter

function view_items_homepage(){

  var self = this;

  var SQL="Select * from users";  

  var connection = self.database('test');

 connection.connect(function(err) {

    connection.query(SQL,function (err, rows) {

        if (err) {self.view('~/errors/internalServerError'); return; }

          

        var msgBody = self.view('email',rows,true);

        var message = new mail.Message('email subject', msgBody);

        message.to('ha..@gmail.com');

        message.reply('ha..@gmail.com');

        message.from('ha..@gmail.com','Hasan test');

        message.send('smtp.gmail.com', { port: 465, secure: true,  timeout: 60000, user: 'ha..@gmail.com', password: 'pswd' });

        });

    connection.end();

    }); 

}

[Peter Širka]

Yes, I fixed it in new version.

Thanks!

[Hasan Yousef]

Hi Peter.

Not sue f this question related to framework or something else, anyhow, I'll ask :)

In the mail, I can send html file, is there a way that the sent item be .pdf,

Regards,

Hasan

[Peter Širka]

Hi Hasan,

no :-( ... you can send PDF as attachment. Theoretically is it possible, but you must create own SMTP sender :-) ... and this is complicated.

Thanks :-)

[Hasan A Yousef]

Hi Peter..

Is there an easy way to integrate jsPDF with total.js, so that we can send the email as pdf attachement

https://github.com/MrRio/jsPDF

thanks

[Peter Širka]

Maybe yes. You must create a PDF file in a server side, but this component is a client-side component.

Thanks :-)

[Hasan A Yousef]

Thanks Peter,,

Then this may solve my issue, I was able to create the pdf file by global function, do u have any comments about the methodology I used :)

http://pdfkit.org/docs/getting_started.html

controller -> default.js

self.global.pdfDoc('fname', 'title', 'body', 'author','subject');

definitions -> global.js

var PDFDocument = require ('pdfkit');

framework.global.pdfDoc = function(fname, title, body, author,subject) {

    var doc;

    var output = fname+'.pdf';

    doc = new PDFDocument({

        info: {

            Title: title,

            Author: author,

            Subject: subject

        }

    });

    doc.text('This text is justified. ' + body, {

        width: 410,

        align: 'justify'

    });

    doc.moveDown();

        doc.text('This text is justified. ' + body, {

        width: 410,

        align: 'justify'

    });

    doc.write(output);

};