Slig
12/09/2021, 7:24 PM/**
*@NApiVersion 2.x
*@NScriptType MapReduceScript
*/
var status = {
disponivel: 1,
gerado: 2,
confirmado: 3,
rejeitado: 4
}
define(['N/search','N/record'], function(search, record) {
function getInputData() {
return search.create({
type: 'invoice',
filters:
[
["mainline","is","T"],
//"AND",
//["trandate","within","12/09/2020","13/09/2020"],
"AND",
["installment.custrecord_rsc_cnab_inst_status_ls", "anyof", [status.disponivel]],
"AND",
['internalid', 'anyof',
[
4694248,
4722798
]
]
],
columns:
[
search.createColumn({ name: 'internalid', label: 'Internal Id' })
]
})
}
function map(context) {
var contextValue = JSON.parse(context.value)
var invoiceId = contextValue.id
var invoice = record.load({
type: record.Type.INVOICE,
id: invoiceId
})
const lineCount = invoice.getLineCount({
sublistId: 'installment'
})
for (var i = 0; i < lineCount; i++) {
var currStatus = invoice.getSublistValue({
sublistId: 'installment',
fieldId: 'custrecord_rsc_cnab_inst_status_ls',
line: i
})
if (currStatus == 1) {
continue
}
invoice.setSublistValue({
sublistId: 'installment',
fieldId: 'custrecord_rsc_cnab_inst_status_ls',
line: i,
value: status.disponivel
})
}
invoice.save()
log.audit({ title: 'Registro atualizado', details: invoiceId })
}
function reduce(context) {
}
function summarize(summary) {
log.debug('Summary Time','Total Seconds: ' + summary.seconds)
log.debug('Summary Usage', 'Total Usage: ' + summary.usage)
log.debug('Summary Yields', 'Total Yields: ' + summary.yields)
log.debug('Input Summary: ', JSON.stringify(summary.inputSummary))
log.debug('Map Summary: ', JSON.stringify(summary.mapSummary))
log.debug('Reduce Summary: ', JSON.stringify(summary.reduceSummary))
//Grab Map errors
summary.mapSummary.errors.iterator().each(function(key, value) {
log.error(key, 'ERROR String: ' + value)
return true
})
}
return {
getInputData: getInputData,
map: map,
reduce: reduce,
summarize: summarize
}
})
Juliano Oliveira
12/09/2021, 7:43 PMSlig
12/09/2021, 7:50 PMSandii
12/09/2021, 7:51 PMSandii
12/09/2021, 7:51 PMSlig
12/09/2021, 7:53 PMSlig
12/09/2021, 7:56 PMscottvonduhn
12/09/2021, 9:22 PM