/**
* @NApiVersion 2.x
* @NScriptType ScheduledScript
* @NModuleScope SameAccount
*/
define(["N/file","N/search","N/email"],
function(file, search, email) {
/**
* Definition of the Scheduled script trigger point.
*
* @param {Object} scriptContext
* @param {string} scriptContext.type - The context in which the script is executed. It is one of the values from the scriptContext.InvocationType enum.
* @Since 2015.2
*/
function execute(scriptContext) {
var columns = new Array();
var csvString = '';
columns[0] = search.createColumn({name: "internalid", label: "Internal ID"});
columns[1] = search.createColumn({name: "item", label: "Item"});
columns[2] = search.createColumn({name: "quantity", label: "Quantity"})
columns[3] = search.createColumn({name: "quantityshiprecv", label: "Quantity Fulfilled/Received"});
columns[4] = search.createColumn({
name: "formulanumeric",
formula: "{quantity}-{quantityshiprecv}",
label: "Quantity to be Fulfilled"
})
for(var i = 0; i < columns.length;i++){
if(i != columns.length-1){
csvString += columns[i].label + ","
} else {
csvString += columns[i].label + '\n';
}
}
var salesOrdSearch = search.create({
type: "salesorder",
filters:
[
["type","anyof","SalesOrd"],
"AND",
["mainline","is","F"],
"AND",
["taxline","is","F"],
"AND",
["item.type","anyof","Assembly","InvtPart","Group","Kit","NonInvtPart","Service"],
"AND",
["status","anyof","SalesOrd:D","SalesOrd:E","SalesOrd:B"]
],
columns: columns
});
var searchResultCount = salesOrdSearch.runPaged().count;
var resultSet = salesOrdSearch.run()
resultSet.each(function(result){
for (var i = 0; i < salesOrdSearch.columns.length;i++){
var searchResult = result.getText({
name: salesOrdSearch.columns[i].name
});
if (searchResult == null){
var searchResult = result.getValue({
name: salesOrdSearch.columns[i].name
});
}
if(i != columns.length-1){
csvString += searchResult + ',';
} else {
csvString += searchResult + '\n';
}
}
return true;
});
var csvFile = file.create({
name: 'search_csv_file.csv',
fileType: file.Type.CSV,
contents: csvString,
folder: '1255' // Folder ID where the file should be saved in the File Cabinet
});
var csvFileID = csvFile.save();
var csvFileObj = file.load({
id: csvFileID
})
var recipientsID = [2];
email.send({
author: 2,
recipients: recipientsID,
subject: 'List of Item with Pending Fulfillment',
body: 'Hello, Human.',
attachment: [csvFileObj]
});
log.debug("Completed")
}
return {
execute: execute
};
});