9 var frameload = function()
16 console.log("document.location" + document.location);
18 if (!(window.location + '').match(/netsuite/)) {
20 window.location = "https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=" + id;
24 // we really just want to send a series of download requests..
25 //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
29 var chk = document.getElementById('lines');
32 console.log('checking form values');
35 if (chk.value !='T') {
37 document.forms[0].daterange.value = 'CUSTOM';
39 document.getElementById('date1').value = '1/1/2008';
40 document.getElementById('date2').value = '1/1/2013';
42 document.getElementById('footerform').submit();
47 console.log('form values - ok - checking if empty');
49 if ( reportTable.oContentProvider.bRequestPending
50 || !reportTable.isInLoadedState()) {
51 console.log('report not ready?');
54 console.log('SENDING EMTPY..?');
58 method: 'nsdownloadpage',
59 filename : NS.id + '.csv',
69 window.setTimeout(rungrab,1000);
74 console.log('no empty - trying download');
76 var ar = document.getElementById('footerform').elements;
78 for(var i =0; i < ar.length; i++) {
80 data[e.name] = e.value;
83 console.log(document.reportTable.getTotalRowCount());
85 'https://system.netsuite.com/app/reporting/reportrunner.nl',
88 reportaction: 'exportcsv',
90 visibleranges: '0,' + document.reportTable.getTotalRowCount()
101 var ifr = document.createElement('iframe');
103 ifr.setAttribute('src','https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=' + id);
104 ifr.setAttribute('width','900');
105 ifr.setAttribute('height','700');
106 ifr.addEventListener('load', frameload);
107 document.body.innerHTML = '';
109 document.body.appendChild(ifr);
112 var ifd = ifr.contentWindow.document;
113 ifd.getElementById('lines_chkbox').
115 var ar = ifd.getElementById('footerform').elements;
116 for(var i =0; i < ar.length; i++) {
118 data[e.name] = e.value;
122 data.lines_chkbox = 'T';
123 data.reportaction = 'exportcsv'
124 //data.visibleranges =
125 data.apptype = 'html';
127 'https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403',
134 downloaddata : function (url,data) {
137 var xmlhttp = new XMLHttpRequest();
139 xmlhttp.open("POST", url,true);
140 xmlhttp.responseType = 'arraybuffer';
141 xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
144 kv.push(i +'=' + encodeURIComponent( data[i]));
148 xmlhttp.onload=function() {
152 var r = new Uint8Array(xmlhttp.response);
153 for (i=0;i<r.byteLength;i++) {
160 method: 'nsdownloadpage',
161 filename : NS.id + '.csv',
162 headers : xmlhttp.getAllResponseHeaders(),
163 contentType:xmlhttp.getResponseHeader("Content-Type"),
169 xmlhttp.send(kv.join('&'));
172 login : function(u,p,id)
176 document.forms[0].email.value = u;
177 document.forms[0].password.value = p;
181 document.forms[0].elements['jsenabled'].value = 'T';
182 setLoginCookie(document.forms[0].elements['rememberme'].checked);
184 document.forms[0].submit();