4 rungrabAccounts : function(id)
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');
30 console.log("lines element?");
32 console.log('checking form values');
35 if (chk.value !='T') {
36 console.log('SETTING VALUES:chk');
38 console.log('SETTING VALUES:daterange');
39 document.forms[0].daterange.value = 'CUSTOM';
40 console.log('SETTING VALUES:date1');
41 document.getElementById('date1').value = '1/1/2008';
42 console.log('SETTING VALUES:date2');
43 document.getElementById('date2').value = '1/1/2013';
44 console.log('SUBMIT');
45 document.forms[0].submit();
50 console.log('form values - ok - checking if empty');
52 if ( reportTable.oContentProvider.bRequestPending
53 || !reportTable.isInLoadedState()) {
54 console.log('report not ready?');
57 console.log('SENDING EMTPY..?');
61 method: 'nsdownloadpage',
62 filename : NS.id + '.csv',
72 window.setTimeout(NS.rungrab,1000);
77 console.log('no empty - trying download');
79 var ar = document.forms[0].elements;
81 for(var i =0; i < ar.length; i++) {
83 data[e.name] = e.value;
85 console.log(JSON.stringify(data));
86 console.log(reportTable.getTotalRowCount());
88 'https://system.netsuite.com/app/reporting/reportrunner.nl',
91 reportaction: 'exportcsv',
93 visibleranges: '0,' + reportTable.getTotalRowCount()
104 var ifr = document.createElement('iframe');
106 ifr.setAttribute('src','https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=' + id);
107 ifr.setAttribute('width','900');
108 ifr.setAttribute('height','700');
109 ifr.addEventListener('load', frameload);
110 document.body.innerHTML = '';
112 document.body.appendChild(ifr);
115 var ifd = ifr.contentWindow.document;
116 ifd.getElementById('lines_chkbox').
118 var ar = ifd.getElementById('footerform').elements;
119 for(var i =0; i < ar.length; i++) {
121 data[e.name] = e.value;
125 data.lines_chkbox = 'T';
126 data.reportaction = 'exportcsv'
127 //data.visibleranges =
128 data.apptype = 'html';
130 'https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403',
137 rungrab : function () {
138 NS.rungrabInventory(id);
140 rungrabInventory : function(id)
145 var frameload = function()
152 console.log("document.location" + document.location);
154 if (!(window.location + '').match(/netsuite/)) {
156 window.location = "https://system.netsuite.com/app/reporting/reportrunner.nl?cr=425&customized=T&whence=';
160 // we really just want to send a series of download requests..
161 //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
165 var chk = document.getElementById('lines');
166 console.log("lines element?");
168 console.log('checking form values');
171 if (chk.value !='T') {
172 console.log('SETTING VALUES:chk');
174 console.log('SETTING VALUES:daterange');
175 document.forms[0].daterange.value = 'CUSTOM';
176 console.log('SETTING VALUES:date1');
177 document.getElementById('date1').value = '1/1/2008';
178 console.log('SETTING VALUES:date2');
179 document.getElementById('date2').value = '1/1/2013';
180 console.log('SUBMIT');
181 document.forms[0].submit();
186 console.log('form values - ok - checking if empty');
188 if ( reportTable.oContentProvider.bRequestPending
189 || !reportTable.isInLoadedState()) {
190 console.log('report not ready?');
192 if (NS.timeout < 0) {
193 console.log('SENDING EMTPY..?');
197 method: 'nsdownloadpage',
198 filename : NS.id + '.csv',
208 window.setTimeout(NS.rungrab,1000);
213 console.log('no empty - trying download');
215 var ar = document.forms[0].elements;
217 for(var i =0; i < ar.length; i++) {
219 data[e.name] = e.value;
221 console.log(JSON.stringify(data));
222 console.log(reportTable.getTotalRowCount());
224 'https://system.netsuite.com/app/reporting/reportrunner.nl',
227 reportaction: 'exportcsv',
229 visibleranges: '0,' + reportTable.getTotalRowCount()
240 var ifr = document.createElement('iframe');
242 ifr.setAttribute('src','https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=' + id);
243 ifr.setAttribute('width','900');
244 ifr.setAttribute('height','700');
245 ifr.addEventListener('load', frameload);
246 document.body.innerHTML = '';
248 document.body.appendChild(ifr);
251 var ifd = ifr.contentWindow.document;
252 ifd.getElementById('lines_chkbox').
254 var ar = ifd.getElementById('footerform').elements;
255 for(var i =0; i < ar.length; i++) {
257 data[e.name] = e.value;
261 data.lines_chkbox = 'T';
262 data.reportaction = 'exportcsv'
263 //data.visibleranges =
264 data.apptype = 'html';
266 'https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403',
275 downloaddata : function (url,data) {
278 var xmlhttp = new XMLHttpRequest();
280 xmlhttp.open("POST", url,true);
281 xmlhttp.responseType = 'arraybuffer';
282 xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
285 kv.push(i +'=' + encodeURIComponent( data[i]));
289 xmlhttp.onload=function() {
293 var r = new Uint8Array(xmlhttp.response);
294 for (i=0;i<r.byteLength;i++) {
301 method: 'nsdownloadpage',
302 filename : NS.id + '.csv',
303 headers : xmlhttp.getAllResponseHeaders(),
304 contentType:xmlhttp.getResponseHeader("Content-Type"),
310 xmlhttp.send(kv.join('&'));
313 login : function(u,p,id)
317 document.forms[0].email.value = u;
318 document.forms[0].password.value = p;
322 document.forms[0].elements['jsenabled'].value = 'T';
323 setLoginCookie(document.forms[0].elements['rememberme'].checked);
325 document.forms[0].submit();