Server: Difference between revisions

From MobileX for SageCRM
(Created page with "The server plugin is stored in "js\\plugins\\PLUGINNAME\\server\\FILENAME.js if (params.EntityId) { var sql = "select pers_emailaddress...")
 
No edit summary
Line 1: Line 1:
The server plugin is stored in "js\\plugins\\PLUGINNAME\\server\\FILENAME.js
The server plugin is stored in "js\\plugins\\PLUGINNAME\\server\\sendOrder.js


In the Client documentation page FILENAME=sendOrder


  EG
  "js\\plugins\\PLUGINNAME\\server\\sendOrder.js"


if (params.EntityId) {
The code in the FILENAME is javscript and is executed.  
 


  EG
  if (params.EntityId) {
     var sql =
     var sql =
         "select pers_emailaddress                              \
         "select pers_emailaddress                              \
         from vsummaryperson                                \
         from vsummaryperson                                \
         where pers_personid={0}";
         where pers_personid={0}";
     sql = clr.System.String.Format(sql, params.EntityId);
     sql = clr.System.String.Format(sql, params.EntityId);
     var jsonResult = SQLJSONSerializer.ExecuteQueryToJSON(sql, false);
     var jsonResult = SQLJSONSerializer.ExecuteQueryToJSON(sql, false);
     var jsonObject = eval(jsonResult);
     var jsonObject = eval(jsonResult);
 
    //jsonObject runs the query and returns data
     //Response.Write('alert(\'EntityId='+jsonObject[0].pers_emailaddress+'\');');
     //to access this data you can reference "jsonObject[0].pers_emailaddress"
 
    //GetFileContents - reads the file into a string
     var emailBody = email.GetFileContents("C:\\Program Files (x86)\\Sage\\CRM\\CRMDemo\\WWWRoot\\CustomPages\\SageCRMWS\\js\\plugins\\CRMTogether\\server\\email.txt");
     var emailBody = email.GetFileContents("C:\\Program Files (x86)\\Sage\\CRM\\CRM\\WWWRoot\\CustomPages\\SageCRMWS\\js\\plugins\\PLUGINNAME\\server\\email.txt");
 
    //create an email object
     var emailSettings = {
     var emailSettings = {
         to: jsonObject[0].pers_emailaddress,
         to: jsonObject[0].pers_emailaddress,
         From: "uname@server.com",
         From: "uname@server.com",
         subject: "test subject",
         subject: "New Order",
         body: emailBody,
         body: emailBody,
         host: "smtp.server.com",
         host: "smtp.server.com",
Line 33: Line 34:
         pEnableSsl: true
         pEnableSsl: true
     }
     }
 
     //sendEmail - sends an email based on the settings
     //Response.Write('alert(\'emailBody='+emailSettings.subject+'\');');
 
     email.SendEmail(emailSettings.to, emailSettings.From, emailSettings.subject, emailSettings.body, emailSettings.host, emailSettings.port, emailSettings.UserName, emailSettings.Password, emailSettings.pIsBodyHtml, emailSettings.pEnableSsl);
     email.SendEmail(emailSettings.to, emailSettings.From, emailSettings.subject, emailSettings.body, emailSettings.host, emailSettings.port, emailSettings.UserName, emailSettings.Password, emailSettings.pIsBodyHtml, emailSettings.pEnableSsl);
 
     //this is displayed on screen by the Factory.msgbox method
     //this is displayed on screen
     Response.Write('Email sent to: '+jsonObject[0].pers_emailaddress);
     Response.Write('Email sent');
  }
 
 
}

Revision as of 13:06, 28 June 2016

The server plugin is stored in "js\\plugins\\PLUGINNAME\\server\\sendOrder.js

In the Client documentation page FILENAME=sendOrder

 EG
 "js\\plugins\\PLUGINNAME\\server\\sendOrder.js"

The code in the FILENAME is javscript and is executed.

 EG
 if (params.EntityId) {
   var sql =
       "select pers_emailaddress                               \
       from vsummaryperson                                \
       where pers_personid={0}";
   sql = clr.System.String.Format(sql, params.EntityId);
   var jsonResult = SQLJSONSerializer.ExecuteQueryToJSON(sql, false);
   var jsonObject = eval(jsonResult);
   //jsonObject runs the query and returns data
   //to access this data you can reference "jsonObject[0].pers_emailaddress"
   //GetFileContents - reads the file into a string
   var emailBody = email.GetFileContents("C:\\Program Files (x86)\\Sage\\CRM\\CRM\\WWWRoot\\CustomPages\\SageCRMWS\\js\\plugins\\PLUGINNAME\\server\\email.txt");
   //create an email object
   var emailSettings = {
       to: jsonObject[0].pers_emailaddress,
       From: "uname@server.com",
       subject: "New Order",
       body: emailBody,
       host: "smtp.server.com",
       port: "123",
       UserName: "uname@server.com",
       Password: "password",
       pIsBodyHtml: true,
       pEnableSsl: true
   }
   //sendEmail - sends an email based on the settings
   email.SendEmail(emailSettings.to, emailSettings.From, emailSettings.subject, emailSettings.body, emailSettings.host, emailSettings.port, emailSettings.UserName, emailSettings.Password, emailSettings.pIsBodyHtml, emailSettings.pEnableSsl);
   //this is displayed on screen by the Factory.msgbox method
   Response.Write('Email sent to: '+jsonObject[0].pers_emailaddress);
 }