agreements.ts

/**
 * @NApiVersion 2.1
 * @NScriptType Suitelet
 * @NModuleScope SameAccount
 */

import { EntryPoints } from 'N/types';
import * as search from 'N/search';
import * as file from 'N/file';
import * as record from 'N/record';
import * as serverWidget from 'N/ui/serverWidget';
import * as message from 'N/ui/message';
import { ServerRequest, ServerResponse } from 'N/https';

/**
 * A Suitelet to attach MAP Agreements to customer records.
 */

export const onRequest: EntryPoints.Suitelet.onRequest = (
  context: EntryPoints.Suitelet.onRequestContext
) => {
  const request = context.request;
  const response = context.response;

  if (request.method === 'GET') {
    onGet(response);
  } else {
    onPost(request, response);
  }
};

/**
 * Handles Get Request and loads the saved search
 */
const onGet = (response: ServerResponse) => {
  const results = getFiles();
  const page = createPage(results);
  response.writePage(page);
};

/**
 * Handles the Post Request
 */
const onPost = (request: ServerRequest, response: ServerResponse) => {
  const folderID = 753;
  const files = request.parameters.custpage_files;
  const customerID = request.parameters.custpage_customer;

  const fileIDs = files.split(',');
  let body =
    '<p>Moving file(s): ' +
    files +
    ' and attaching to customer: ' +
    customerID +
    '</p>';
  fileIDs.forEach((fileID: string) => {
    // load and change dir
    const fileObj = file.load({ id: Number(fileID) });
    body += '<p>Moving file: ' + fileID + '</p>';
    fileObj.folder = Number(folderID);
    fileObj.save();
    // attach to customer
    body += '<p>Attaching file: ' + fileID + ' to ' + customerID + '</p>';
    record.attach({
      record: {
        type: 'file',
        id: Number(fileID),
      },
      to: {
        type: 'customer',
        id: Number(customerID),
      },
    });
  });
  body += '<p>DONE!</p>';
  // updated
  const form = serverWidget.createForm({ title: 'MAP Agremeents' });
  form.addPageInitMessage({
    type: message.Type.CONFIRMATION,
    title: 'SUCCESS!',
    message:
      'File(s): ' +
      files +
      ' have been attached to customer record (' +
      customerID +
      ')',
  });

  form.addField({
    id: 'custpage_main_body',
    type: serverWidget.FieldType.INLINEHTML,
    label: ' ',
  }).defaultValue = body;

  form.addPageLink({
    type: serverWidget.FormPageLinkType.CROSSLINK,
    title: 'Go Back',
    url: '/app/site/hosting/scriptlet.nl?script=1062&deploy=1',
  });

  form.addPageLink({
    type: serverWidget.FormPageLinkType.CROSSLINK,
    title: 'Generate MAP Agreement',
    url: '/app/site/hosting/scriptlet.nl?script=1065&deploy=1',
  });

  response.writePage(form);
};

const getFiles = () => {
  const folder = 32814;
  const fileSearch = search.create({
    type: 'folder',
    columns: [
      search.createColumn({
        name: 'internalid',
      }),
      search.createColumn({
        name: 'name',
        join: 'file',
      }),
      search.createColumn({
        name: 'internalid',
        join: 'file',
      }),
      search.createColumn({
        name: 'url',
        join: 'file',
      }),
    ],
    filters: [
      search.createFilter({
        name: 'internalid',
        operator: search.Operator.IS,
        values: folder,
      }),
    ],
  });

  const pagedData = fileSearch.runPaged({
    pageSize: 100,
  });

  const fileResults = [];
  pagedData.pageRanges.forEach(function (pageRange) {
    var page = pagedData.fetch({ index: pageRange.index });
    page.data.forEach(function (result) {
      if (result.getValue({ name: 'internalid', join: 'file' })) {
        fileResults.push({
          id: result.getValue({ name: 'internalid' }),
          fileid: result.getValue({ name: 'internalid', join: 'file' }),
          filename: result.getValue({ name: 'name', join: 'file' }),
          url: result.getValue({ name: 'url', join: 'file' }),
        });
      }
    });
  });

  if (fileResults.length > 0) {
    return fileResults;
  } else {
    return false;
  }
};

const createPage = (
  results:
    | {
        id: string;
        fileid: string;
        filename: string;
        url: string;
      }[]
    | false
) => {
  const form = serverWidget.createForm({ title: 'MAP Agreements' });
  form.addPageLink({
    type: serverWidget.FormPageLinkType.CROSSLINK,
    title: 'Generate MAP Agreement',
    url: '/app/site/hosting/scriptlet.nl?script=1065&deploy=1',
  });

  if (results) {
    form.clientScriptModulePath = 'SuiteScripts/agreements_client.js';
    form.addSubmitButton({
      label: 'Attach',
    });

    form
      .addField({
        id: 'custpage_message',
        type: serverWidget.FieldType.INLINEHTML,
        label: ' ',
      })
      .updateLayoutType({
        layoutType: serverWidget.FieldLayoutType.OUTSIDEABOVE,
      })
      .updateBreakType({
        breakType: serverWidget.FieldBreakType.STARTROW,
      }).defaultValue =
      'Please add the customers internal id number below and select the file(s) to attach.';

    form
      .addField({
        id: 'custpage_customer',
        label: 'Customer Internal ID',
        type: serverWidget.FieldType.TEXT,
      })
      .updateLayoutType({
        layoutType: serverWidget.FieldLayoutType.OUTSIDEABOVE,
      })
      .updateBreakType({
        breakType: serverWidget.FieldBreakType.STARTROW,
      })
      .setHelpText({
        help: 'You can grab the customers internal id by going to the customer record and getting the id from the url. (ex: id=1102)',
      });

    form
      .addField({
        id: 'custpage_files',
        label: 'Files to Move & Attach',
        type: serverWidget.FieldType.TEXT,
      })
      .updateDisplayType({
        displayType: serverWidget.FieldDisplayType.HIDDEN,
      });

    form
      .addField({
        id: 'custpage_customer_found',
        label: 'Customer Found',
        type: serverWidget.FieldType.CHECKBOX,
      })
      .updateDisplayType({
        displayType: serverWidget.FieldDisplayType.HIDDEN,
      });

    const sublist = form.addSublist({
      id: 'custpage_agreements_sublist',
      type: serverWidget.SublistType.LIST,
      label: 'Sublist',
    });

    sublist.addField({
      id: 'custpage_result_checkbox',
      type: 'checkbox',
      label: 'Select',
    });
    sublist.addField({
      id: 'custpage_result_folderid',
      type: 'text',
      label: 'Folder ID',
    });
    // }).updateDisplayType({
    //   displayType: serverWidget.FieldDisplayType.ENTRY
    // });
    sublist.addField({
      id: 'custpage_result_fileid',
      type: 'text',
      label: 'File ID',
    });
    sublist.addField({
      id: 'custpage_result_filename',
      type: 'text',
      label: 'Filename',
    });
    sublist.addField({
      id: 'custpage_result_url',
      type: 'text',
      label: 'Preview',
    });

    results.forEach(function (result, index) {
      sublist.setSublistValue({
        id: 'custpage_result_folderid',
        line: index,
        value: result.id,
      });
      sublist.setSublistValue({
        id: 'custpage_result_fileid',
        line: index,
        value: result.fileid,
      });
      sublist.setSublistValue({
        id: 'custpage_result_filename',
        line: index,
        value: result.filename,
      });
      sublist.setSublistValue({
        id: 'custpage_result_url',
        line: index,
        value: '<a href="' + result.url + '" target="_blank">Preview</a>',
      });
    });
  } else {
    form.addField({
      id: 'custpage_message',
      type: serverWidget.FieldType.INLINEHTML,
      label: ' ',
    }).defaultValue = 'There are currently no MAP Agreements to attach.';
  }

  return form;
};