Forums › Cached › Customization › Suitescript 1.0

This topic contains 3 replies, has 0 voices, and was last updated by Jordan Manningham 7 years, 9 months ago.

  • Author
    Posts
  • January 26, 2017 at 12:30 pm #21912

    Jordan Manningham

    Hi All,

    I've been working on a project that requires generating a PDF which of course requires some knowledge of HTML and CSS. The part I'm stuck on requires some JavaScript though I'm not sure how to tie both languages together using <script> tags. The intended purpose of this portion of the script is to create a table with X amount of rows where X is the number of members./components that an item record has. I've been trying practically everything that any relevant resource says but still no luck. Right now the script produces an error (TypeError: <script type="text/javascript"> is not a function, it is string. (pef_to_pdf.js$262376#199))

    The part that screws me up is document.getElementById. Every resource I've found indicates some use of it for this purpose. Is this the right function to use and is my <script> in the right place? This is my first attempt at HTML/CSS.

    Code:
    var line1 = [];
    var line2 = [];
    var line3 = [];
    var line4 = [];
    var line5 = [];
    var line6 = [];
    var line7 = [];
    var line8 = [];
    var line9 = [];
    var line10 = [];
    var line11 = [];
    var line12 = [];
    var line13 = [];
    var line14 = [];
    var line15 = [];
    var line16 = [];
    var line17 = [];
    var line18 = [];
    var line19 = [];
    var line20 = [];

    var components = [line1, line2, line3, line4, line5, line6, line7, line8, line9, line10, line11, line12, line13, line14, line15, line16, line17, line18, line19, line20];

    function xyz(){
    var loadSearch = nlapiLoadSearch('customrecord139', 'customsearch710');
    var getData = loadSearch.runSearch();
    var all_results = getData.getResults(0, 1);
    var all_col = all_results[0].getAllColumns();
    var o_id = all_results[0].getValue('custrecord196');
    var o_rt = all_results[0].getValue('custrecord197');

    var o_r = nlapiLoadRecord(o_rt, o_id); // Loads the correct item record

    var lines = o_r.getLineItemCount('member');
    for (var mem = 1; mem <= lines; mem++){
    components[mem – 1][0] = o_r.getLineItemText('member', 'item', mem);
    components[mem – 1][1] = o_r.getLineItemText('member', 'memberdescr', mem);
    components[mem – 1][2] = o_r.getLineItemText('member', 'quantity', mem);
    components[mem – 1][3] = o_r.getLineItemText('member', 'memberunit', mem);
    }

    var xml = '<?xml version="1.0"?>'
    xml += '<!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">'
    xml += '<pdf>'
    xml += '<head>'
    xml += '<script type="text/javascript">' (window.onload = function () { for(var i = 1; i < lines; i++){ var bom = document.getElementById("bom"); var tbody = document.createElement("tbody"); var tr = document.createElement("tr"); var td = document.createElement("td"); var txt = document.createTextNode(components[i][0]); td.appendChild(txt); tr.appendChild(td); } tbody.appendChild(tr); bom.appendChild(tbody); })

    xml += '</script>'< — Style — >
    <– /head — >
    < — body — >
    <– tables — >xml += '<div>'

    xml += '<table id="bom">'
    xml += '<tr>'
    xml += '<th align="center" colspan="4" style="font-size:14px;"><b>Bill of Materials</b></th>'
    xml += '</tr>'
    xml += '<tr>'
    xml += '<th align="center" style="font-size:12px;">Item</th>'
    xml += '<th align="center" style="font-size:12px;">Description</th>'
    xml += '<th align="center" style="font-size:12px;">Quantity</th>'
    xml += '<th align="center" style="font-size:12px;">Units</th>'
    xml += '</tr>'
    xml += '</table>'
    xml += '</div>'
    xml += '</body>'
    xml += '</pdf>';

    response.renderPDF(xml); //TESTING WITH ITEM 6700-55
    }
    else{
    dumpResponse(request,response);
    }

    }
    This is a cached copy. Click here to see the original post.

  • February 2, 2017 at 9:47 am #21913

    david.smith

    I don't think you want to try and put your script into the xml for the PDF. A PDF document is not able to modify itself like this. There are quite a few things here I would change but basically you will want your 'xml' to be the complete before rendering it. So use your 'lines' loop to create the table data as a string and then just insert that into the 'xml'.

  • February 2, 2017 at 2:26 pm #21914

    Jordan Manningham

    david.smith You're a genius. That makes so much sense and I'm jealous I didn't think of it haha. Will make corrections to my code and report back. Thanks!

    david.smith replied on 02/02/2017, 02:54 PM: hahaha – shhhhhh, don’t tell anyone those kinda things.

    Let me know how it goes.

  • February 17, 2017 at 9:29 am #21915

    Jordan Manningham

    david.smith It worked like a charm!

    Code:
    //Components – Bill of Materials
    var lines = o_r.getLineItemCount('member');
    var bom_string;
    for (var mem = 1; mem <= lines; mem++){
    components[mem – 1][0] = o_r.getLineItemText('member', 'item', mem);
    components[mem – 1][1] = o_r.getLineItemValue('member', 'memberdescr', mem);
    components[mem – 1][2] = o_r.getLineItemValue('member', 'quantity', mem);
    components[mem – 1][3] = o_r.getLineItemValue('member', 'memberunit', mem);
    bom_string += '<tr><td class="bom-item">' + components[mem – 1][0] + '</td><td class="bom-description">' + components[mem – 1][1] +
    '</td><td class="bom-quantity">' +components[mem – 1][2] + '</td><td class="bom-units">' + components[mem – 1][3] + '</td></tr>';
    }

    while (bom_string.indexOf(' & ') != -1){
    bom_string = bom_string.replace(' & ', ' &amp; ');
    }

    while (bom_string.indexOf('null') != -1){
    bom_string = bom_string.replace('null', ' ');
    }

    david.smith replied on 02/17/2017, 09:37 AM: You could also try nlapiEscapeXML(bom_string).

  • Author
    Posts

You must be logged in to reply to this topic.