Hi There
I am getting an error on the following
/**
*@NApiVersion 2.x
*@NScriptType MapReduceScript
*/
define([
"N/search",
"N/record",
"N/render",
"N/file",
"N/xml",
"N/email",
"N/runtime",
], function (search, record, render, file, xml, email, runtime) {
function getInputData(context) {
var scriptObj = runtime.getCurrentScript()
var recordId = scriptObj.getParameter("custscript_recordid")
var id = recordId
log.debug("recordid", recordId)
var vendorpaymentSearchObj = search.create({
type: "vendorpayment",
filters: [
["type", "anyof", "VendPymt"],
"AND",
["custbody_9997_pfa_record", "anyof", id],
],
columns: [
//0
search.createColumn({
name: "transactionnumber",
summary: "GROUP",
label: "Transaction Number",
}),
//1
search.createColumn({
name: "formulatext",
summary: "GROUP",
formula: "{entity}",
label: "Vendor",
}),
//2
search.createColumn({
name: "formulatext",
summary: "GROUP",
formula:
"CASE WHEN {vendor.custentity_2663_email_address_notif} IS NULL THEN {vendor.email} ELSE {vendor.custentity_2663_email_address_notif} END",
label: "Email",
}),
//3
search.createColumn({
name: "total",
summary: "SUM",
label: "Amount (Transaction Total)",
}),
//4
search.createColumn({
name: "currency",
summary: "GROUP",
label: "Currency",
}),
//5
search.createColumn({
name: "trandate",
summary: "GROUP",
sort: search.Sort.ASC,
label: "Date",
}),
//6
search.createColumn({
name: "internalid",
join: "vendor",
summary: "GROUP",
label: "vendorId",
}),
//7
search.createColumn({
name: "internalid",
summary: "GROUP",
label: "searchResultId",
}),
],
})
log.debug(
"vendorpaymentSearchObj result count",
vendorpaymentSearchObj.runPaged().count
)
var vendorPayments = []
vendorpaymentSearchObj.run().each(function (result) {
vendorPayments.push({
emailAddress: result.getValue(result.columns[2]),
transactionNumber: result.getValue(result.columns[0]),
amount: result.getValue(result.columns[3]),
date: result.getValue(result.columns[5]),
vendor: result.getValue(result.columns[1]),
resultId: result.getValue(result.columns[7]),
vendorId: result.getValue(result.columns[6]),
id: id,
// transactionId: result.getValue(result.columns[8]),
})
return true
})
return vendorPayments
}
/**
* @param {MapReduceContext.map} context
*/
function map(context) {
try {
log.debug("context", context)
const result = JSON.parse(context.value)
log.debug("result", result)
var emailAddress = result.emailAddress
var transactionNumber = result.transactionNumber
var amount = result.amount
var date = result.date
var vendor = result.vendor
var resultId = result.resultId
var vendorId = result.vendorId
var id = result.id
log.debug(
"emailAddress: ",
emailAddress +
" transaction bumber: " +
transactionNumber +
" amount: " +
amount +
" date: " +
date +
" vendor: " +
vendor +
" resultId " +
resultId +
"vendorId " +
vendorId
)
var pdfFile = render.transaction({
entityId: parseInt(resultId),
printMode: render.PrintMode.PDF,
formId: 109,
})
pdfFile.folder = 1351
var fileId = pdfFile.save()
var pdffile2 = file.load({ id: fileId })
log.debug("fileid: " + fileId + pdfFile + pdffile2)
context.write({
key: resultId,
value: JSON.stringify({
vendorId: vendorId,
vendor: vendor,
fileId: fileId,
emailAddress: emailAddress,
id: id,
}),
})
} catch (ex) {
log.error("Error on map", ex.message + ex.error)
}
}
/**
* @param {MapReduceContext.reduce} context
*/
function reduce(context) {
try {
var reduceResults = context.values //note: context.values and not context.value unlike the earlier stages. Also, this is not JSON.Parse
log.debug("reduceResults", reduceResults)
var pdffile2 = []
for (var i = 0; i < reduceResults.length; i++) {
//note: this is context.value(S)
log.debug("vendorId", JSON.parse(reduceResults[i]).vendorId)
log.debug("key", context.key)
if (reduceResults) {
var mergeResult = render.mergeEmail({
templateId: 8,
entity: {
type: "vendor",
id: parseInt(JSON.parse(reduceResults[i]).vendorId),
},
recipient: {
type: "vendor",
id: parseInt(JSON.parse(reduceResults[i]).vendorId),
},
supportCaseId: null,
transactionId: parseInt(context.key),
customRecord: null,
})
log.debug("mergeResult", mergeResult)
var emailSubject = mergeResult.subject
var emailBody = mergeResult.body
log.debug("email subject", emailSubject)
log.debug("email body", emailBody)
var pdf = file.load({
fileId: JSON.parse(reduceResults[i].fileId),
})
var vendorName = JSON.parse(reduceResults[i].vendor)
log.debug(vendorName)
pdffile2.push(pdf)
//create a placeholder in the original HTML with an element called NLVENDOR. This will replace that with a value that is part of the script
emailSubject = emailSubject.replace("NLVENDOR", vendorName)
var emailString = JSON.parse(reduceResults[i].emailAddress)
log.debug("emailstring", emailString)
email.send({
author: -5,
recipients: emailString,
subject: emailSubject,
body: emailBody,
attachments: [pdffile2],
relatedRecords: {
entity: parseInt(JSON.parse(reduceResults[i]).vendorId),
transactionId: parseInt(context.key),
},
})
}
}
} catch (ex) {
log.error("Error on reduce", ex.message)
}
}
/**
* @param {MapReduceContext.summarize} context
*/
function summarize(summary) {
log.debug("context", summary)
summary.output.iterator().each(function (key, value) {
contents += key + " " + value + "\n"
return true
})
}
return {
getInputData: getInputData,
map: map,
reduce: reduce,
summarize: summarize,
}
})
I am getting the following error message: