Server - Revision history

Crmtogether at 09:21, 22 August 2018

2018-08-22T09:21:16Z

← Older revision		Revision as of 10:21, 22 August 2018
Line 62:		Line 62:
	var var visitJSON = params.entitydata;		var var visitJSON = params.entitydata;

	var recId = SQLJSONSerializer.InsertOrUpdateRecord("Entity", recordJSON, "prefix_entityid",		var recId = SQLJSONSerializer.InsertOrUpdateRecord("Entity", recordJSON, "prefix_entityid", entitydata.prefix_entityid? "prefix_entityid" : null);
	entitydata.prefix_entityid? "prefix_entityid" : null);

Crmtogether at 09:20, 22 August 2018

2018-08-22T09:20:58Z

← Older revision		Revision as of 10:20, 22 August 2018
Line 49:		Line 49:

	----		----
	SQLJSONSerializer Object		'''SQLJSONSerializer Object'''

	Method: InsertOrUpdateRecord		'''Method''': InsertOrUpdateRecord

	Params:		'''Params''':
	string tableName, string jsonRecord, string pimaryKeyField, string identifyingFields = null*		string tableName, string jsonRecord, string pimaryKeyField, string identifyingFields = null*

	identifyingFields - is this is null then an insert is done		identifyingFields - is this is null then an insert is done

	Example:		'''Example''':

	var var visitJSON = params.entitydata;		var var visitJSON = params.entitydata;
Line 65:		Line 65:
	entitydata.prefix_entityid? "prefix_entityid" : null);		entitydata.prefix_entityid? "prefix_entityid" : null);

	~~Method: DeleteRecord~~

	Params:		'''Method''': DeleteRecord

			'''Params''':
	string tableName, string whereClause)		string tableName, string whereClause)

	~~Methos~~: ExecSQL		'''Method''': ExecSQL

	Params:		'''Params''':
	string sql		string sql

Crmtogether at 09:20, 22 August 2018

2018-08-22T09:20:04Z

← Older revision		Revision as of 10:20, 22 August 2018
Line 54:		Line 54:

	Params:		Params:
	string tableName, string jsonRecord,		string tableName, string jsonRecord, string pimaryKeyField, string identifyingFields = null*
	string pimaryKeyField, string identifyingFields = null*

	identifyingFields - is this is null then an insert is done		identifyingFields - is this is null then an insert is done
Line 65:		Line 64:
	var recId = SQLJSONSerializer.InsertOrUpdateRecord("Entity", recordJSON, "prefix_entityid",		var recId = SQLJSONSerializer.InsertOrUpdateRecord("Entity", recordJSON, "prefix_entityid",
	entitydata.prefix_entityid? "prefix_entityid" : null);		entitydata.prefix_entityid? "prefix_entityid" : null);

			Method: DeleteRecord

			Params:
			string tableName, string whereClause)

			Methos: ExecSQL

			Params:
			string sql

Crmtogether at 09:18, 22 August 2018

2018-08-22T09:18:06Z

← Older revision		Revision as of 10:18, 22 August 2018
Line 46:		Line 46:

	Server API documentation		Server API documentation


			----
			SQLJSONSerializer Object

			Method: InsertOrUpdateRecord

			Params:
			string tableName, string jsonRecord,
			string pimaryKeyField, string identifyingFields = null*

			identifyingFields - is this is null then an insert is done

			Example:

			var var visitJSON = params.entitydata;

			var recId = SQLJSONSerializer.InsertOrUpdateRecord("Entity", recordJSON, "prefix_entityid",
			entitydata.prefix_entityid? "prefix_entityid" : null);

Crmtogether at 13:08, 28 June 2016

2016-06-28T13:08:11Z

← Older revision		Revision as of 14:08, 28 June 2016
Line 39:		Line 39:
	Response.Write('Email sent to: '+jsonObject[0].pers_emailaddress);		Response.Write('Email sent to: '+jsonObject[0].pers_emailaddress);
	}		}


			The code is run on the server in the context of the IIS app.

			This means that you have no real limits on what it can do. We do provide an API though from the app that is used to access CRM.

			Server API documentation

Crmtogether at 13:06, 28 June 2016

2016-06-28T13:06:11Z

← Older revision		Revision as of 14:06, 28 June 2016
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');		}


	}

Crmtogether: Created page with "The server plugin is stored in "js\\plugins\\PLUGINNAME\\server\\FILENAME.js if (params.EntityId) { var sql = "select pers_emailaddress..."

2016-06-28T13:01:02Z

Created page with "The server plugin is stored in "js\\plugins\\PLUGINNAME\\server\\FILENAME.js if (params.EntityId) { var sql = "select pers_emailaddress..."

New page

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

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);

//Response.Write('alert(\'EntityId='+jsonObject[0].pers_emailaddress+'\');');

var emailBody = email.GetFileContents("C:\\Program Files (x86)\\Sage\\CRM\\CRMDemo\\WWWRoot\\CustomPages\\SageCRMWS\\js\\plugins\\CRMTogether\\server\\email.txt");

var emailSettings = {
to: jsonObject[0].pers_emailaddress,
From: "uname@server.com",
subject: "test subject",
body: emailBody,
host: "smtp.server.com",
port: "123",
UserName: "uname@server.com",
Password: "password",
pIsBodyHtml: true,
pEnableSsl: true
}

//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);

//this is displayed on screen
Response.Write('Email sent');

}