EVE Technology Lab

//Converts the EVE api XML to a useable array format.



function eveXMLToArray(url) {
  var xml = UrlFetchApp.fetch(url).getContentText();
  var document = XmlService.parse(xml);
  var rowset = document.getRootElement().getChild('result').getChild('rowset');
  var attributes = rowset.getAttribute('columns').getValue().split(',');
  var children = rowset.getChildren();
  var prefill = [];
  var res = [[]]
  while ( res.length < attributes.length + 1 ) {
    res.push([]);
  };
  while ( prefill.length < attributes.length ) {
    prefill.push('#NULL')
  };
  prefill.push(-1);
  res = eveAPICrawler(children,attributes,prefill,res);
  return res
};



//Subfunction of eveXMLToArray().  Converts the raw data to a readable array format.



function eveAPICrawler(children,attributes,prefill,res) {
  prefill[attributes.length] += 1;
  var subchildren = [];
  var subprefill = [];
  var i = 0;
  var value = '';
  while ( i < children.length ) {
    while ( subprefill.length < attributes.length ) {
      try {
        value = children[i].getAttribute(attributes[subprefill.length]).getValue();
        res[subprefill.length].push(value);
        subprefill.push(value)
      } catch (e) {
        res[subprefill.length].push(prefill[subprefill.length]);
        subprefill.push(prefill[subprefill.length])
      }
    };
    res[subprefill.length].push(prefill[attributes.length]);
    subprefill.push(prefill[attributes.length])
    try {
      subchildren = children[i].getChildren()[0].getChildren();
      res = eveAPICrawler(subchildren,attributes,subprefill,res)
    } catch (e) {};
    subchildren = [];
    subprefill = [];
    i += 1
  };
  return res
};

value = children[i].getAttribute(attributes[subprefill.length]).getValue();
value = isNumeric(value)?parseFloat(value):value;

function IsNumeric(input)
{
   return (input - 0) == input && input.length > 0;
}

    for(var i = 0; i < rows.length; i++) {
      runs = +rows[i].getAttribute("runs").getValue();
      blueprint=[rows[i].getAttribute("itemID").getValue(),
                 rows[i].getAttribute("locationID").getValue(),
                 rows[i].getAttribute("typeID").getValue(),
                 rows[i].getAttribute("typeName").getValue(),
                 rows[i].getAttribute("flagID").getValue(),
                 rows[i].getAttribute("quantity").getValue(),
                 rows[i].getAttribute("timeEfficiency").getValue(),
                 rows[i].getAttribute("materialEfficiency").getValue(),
                 runs]
      blueprints.push(blueprint);
    }

Steve Ronuken wrote:

It's a ternary operator

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Conditional_Operator

it does the test before the ?, then returns the first expression afterwards if it's true, or the second if it's false, with the : splitting the expressions.

Just me being lazy

isNaN(Value)

value = isNaN(value)?value:parseFloat(value);

(form id="frm1" name = "mat_add")
(input width="1000" type="text" name="mat" value="Enter Item Here")(br /)
(input type="hidden" id="tab_array" name="tab_array")
(input type="button" value="Submit" name="mat_sub" onclick="document.getElementById('tab_array').value=document.getElementById('spn1').innerHTML; google.script.run.withSuccessHandler(onSuccess).shortlist(this.parentNode)")
(/form)

function shortlist(form) {
  var table = form.tab_array;
  ...