nsinject.js
[app.wkmirror] / nsinject.js
1 NS = {
2     timeout : 30,
3     varscheck : false,
4     
5     /*
6     rungrabAccounts : function(id)
7     {
8         //id = 282;
9         this.id = id;
10         var timeout = 10;
11         var frameload = function()
12         {
13              
14             
15             
16             
17         }
18         console.log("document.location" + document.location);
19         
20         if (!(window.location + '').match(/netsuite/)) {
21             // try
22             window.location = "https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=" + id;
23             return;
24         }
25         // do stuff..
26         // we really just want to send a series of download requests..
27         //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
28         
29         
30         
31         var chk = document.getElementById('lines');
32         console.log("lines element?");
33         console.log(chk)
34         console.log('checking form values');
35         
36         
37         if (chk.value !='T') {
38             console.log('SETTING VALUES:chk');
39             chk.value= 'T';
40             console.log('SETTING VALUES:daterange');
41             document.forms[0].daterange.value = 'CUSTOM';
42             console.log('SETTING VALUES:date1');
43             document.getElementById('date1').value = '1/1/2008';
44             console.log('SETTING VALUES:date2');
45             document.getElementById('date2').value = '1/1/2013';
46             console.log('SUBMIT');
47             document.forms[0].submit();
48             
49             return;
50         }
51         
52         console.log('form values - ok - checking if empty');
53         
54          if (   reportTable.oContentProvider.bRequestPending
55                 || !reportTable.isInLoadedState()) {
56                 console.log('report not ready?');
57                 NS.timeout--;
58                 if (NS.timeout < 0) {
59                     console.log('SENDING EMTPY..?');
60                     console.log(
61                          JSON.stringify ({
62                             requesturl : '',
63                             method: 'nsdownloadpage',
64                             filename : NS.id + '.csv',
65                             headers : '',
66                             contentType: '',
67                             data: []
68                         }));
69                     return;
70                     
71                     
72                 }
73                 
74                  window.setTimeout( function() {  NS.rungrab(id); } ,1000);
75                 
76                 return;
77                 
78             }
79         console.log('no empty - trying download');
80             
81         var ar = document.forms[0].elements;
82         var data= {};
83         for(var i =0; i < ar.length; i++) {
84             var e = ar[i];
85             data[e.name] = e.value;
86         }
87         console.log(JSON.stringify(data));
88         console.log(reportTable.getTotalRowCount());
89          NS.downloaddata(
90             'https://system.netsuite.com/app/reporting/reportrunner.nl',
91             {
92                 id: data.id,
93                 reportaction: 'exportcsv',
94                 apptype: 'html',
95                 visibleranges: '0,' +  reportTable.getTotalRowCount()
96             }
97             
98         );
99         
100         
101         
102         return;
103         
104         
105          
106         
107     },
108     
109     */
110     rungrabAccounts  : function(id)
111     {
112         //id = 282;
113         this.id = id;
114         var timeout = 10;
115         
116         console.log("document.location= " + document.location);
117          
118         if (!(window.location + '').match(/netsuite/)) {
119             // try
120             console.log("REDIRECT");
121             window.location = "https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=52"; // empty account register..
122             return;
123         }
124         
125         
126         // we really just want to send a series of download requests..
127         //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
128         
129          
130         NS.downloadgetdata(
131             'https://system.netsuite.com/app/common/search/searchresults.csv' +
132             '?searchtype=Transaction' + 
133             '&Transaction_ACCOUNT=' + id +
134             '&sortcol=Transaction_TRANDATE_raw' +
135             '&sortdir=ASC'+
136             '&csv=Export'+
137             '&OfficeXML=F'+
138             '&pdf='+
139             '&style=NORMAL'+
140             '&report='+
141             '&grid='+
142             '&searchid=118'+
143             '&dle=F',
144             {
145                 id: id,
146                 //reportaction: 'exportcsv',
147                 //apptype: 'html',
148                 //visibleranges: '0,' +  reportTable.getTotalRowCount()
149             }
150             
151         );
152         
153         
154         
155         return;
156         
157         
158          
159         
160     },
161     
162     rungrab : function (id) {
163         //NS.rungrabInventory(id);
164         NS.rungrabAccounts(id);
165     },
166     rungrabInventory : function(id)
167     {
168         //id = 282;
169         this.id = id;
170         var timeout = 10;
171         var frameload = function()
172         {
173              
174             
175             
176             
177         }
178         console.log("document.location" + document.location);
179         
180         if (!(window.location + '').match(/netsuite/)) {
181             // try
182             window.location = "https://system.netsuite.com/app/reporting/reportrunner.nl?cr=425&customized=T&whence=";
183             return;
184         }
185         // do stuff..
186         // we really just want to send a series of download requests..
187         //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
188         
189         document.getElementById('filt1').style = '';
190         
191         var set = {
192                 crit_4_displayField : '',
193                 hddn_crit_41  : '',
194                 crit_2_from : '1/1/2007',
195                 crit_2_to: '1/1/2014',
196                 hddn_crit_32 :getDropdown(document.getElementById('inpt_crit_32')).valueArray[id],
197                 inpt_crit_32 :getDropdown(document.getElementById('inpt_crit_32')).valueArray[id],
198                 indx_crit_32 : id
199
200         }
201         
202         var rneed = false;
203         if (!NS.varscheck ) {
204             
205             for (var  k in set) {
206                 if (k == 'inpt_crit_32') {
207                     continue; // this gets abbreivated..
208                 }
209                 
210                 try { 
211                     var cur = document.getElementById(k).value;
212                 } catch(e) {
213                     console.log("Can not find " + k);
214                     continue;
215                 }
216                 console.log("CUR : " + k + '=' + cur + ' ?= ' + set[k]);
217                 if (cur != set[k]) {
218                     console.log("DOE NOT MATCH?");
219                     rneed = true;
220                     //document.forms.main_form.elements[k].value = set[k];
221                     document.getElementById(k).value = set[k];
222                     continue;
223                 }
224                 
225                 
226             }
227         }
228                
229         if (rneed ) {
230             
231             console.log('SUBMIT');
232             document.forms.main_form.submit();
233             
234             return;
235         }
236         NS.varscheck = true;
237         console.log('form values - ok - checking if empty');
238         
239          if (   reportTable.oContentProvider.bRequestPending
240                 || !reportTable.isInLoadedState()) {
241                 console.log('report not ready?');
242                 NS.timeout--;
243                 if (NS.timeout < 0) {
244                     console.log('SENDING EMTPY..?');
245                     console.log(
246                          JSON.stringify ({
247                             requesturl : '',
248                             method: 'nsdownloadpage',
249                             filename : NS.id + '.csv',
250                             headers : '',
251                             contentType: '',
252                             data: []
253                         }));
254                     return;
255                     
256                     
257                 }
258                 
259                 window.setTimeout( function() {  NS.rungrab(id); } ,1000);
260                 
261                 return;
262                 
263             }
264         console.log('no empty - trying download');
265             
266         
267        
268         console.log(reportTable.getTotalRowCount());
269          NS.downloaddata(
270             'https://system.netsuite.com/app/reporting/reportrunner.nl',
271             {
272                 id: document.forms.main_form.elements.id.value,
273                 reportaction: 'exportcsv',
274                 apptype: 'html',
275                 visibleranges: '0,' +  reportTable.getTotalRowCount()
276             }
277             
278         );
279         
280        
281         
282         return;
283          
284         
285         
286     },
287     
288     
289     downloadgetdata : function (url,data) {
290         
291        
292         var xmlhttp = new XMLHttpRequest();
293                     
294         xmlhttp.open("GET", url,true);
295         xmlhttp.responseType = 'arraybuffer';
296         //xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
297         //var kv = [];
298         //for(var i in data) {
299         //    kv.push(i +'=' + encodeURIComponent(  data[i]));
300         //}
301         
302
303         xmlhttp.onload=function() {
304            
305             var ar= [];
306              
307             var r = new Uint8Array(xmlhttp.response);
308             for (i=0;i<r.byteLength;i++) {
309                 ar.push(r[i]);
310             }
311             
312             // location name for location download.
313             var pref = 'SG-Account';
314             
315             console.log(
316                 JSON.stringify ({
317                     requesturl : url,
318                     method: 'nsdownloadpage',
319                     filename : pref+ '-' + NS.id + '.csv',
320                     headers : xmlhttp.getAllResponseHeaders(),
321                     contentType:xmlhttp.getResponseHeader("Content-Type"),
322                     data: ar
323                 }));
324            
325         }
326         
327         xmlhttp.send();
328            
329     },
330     
331     
332     
333     downloaddata : function (url,data) {
334         
335        
336         var xmlhttp = new XMLHttpRequest();
337                     
338         xmlhttp.open("POST", url,true);
339         xmlhttp.responseType = 'arraybuffer';
340         xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
341         var kv = [];
342         for(var i in data) {
343             kv.push(i +'=' + encodeURIComponent(  data[i]));
344         }
345         
346
347         xmlhttp.onload=function() {
348            
349             var ar= [];
350              
351             var r = new Uint8Array(xmlhttp.response);
352             for (i=0;i<r.byteLength;i++) {
353                 ar.push(r[i]);
354             }
355             
356             // location name for location download.
357             var pref = '';
358             if (document.getElementById('hddn_crit_32')) {
359                 //stock.
360                 pref =  document.getElementById('hddn_crit_32').value ;
361             } else {
362                 // accounts.
363                 pref = document.getElementsByClassName('pt_title')[0].innerText.replace(/\s+$/,'').replace(/\//g, '');
364             }
365             
366             console.log(
367                 JSON.stringify ({
368                     requesturl : url,
369                     method: 'nsdownloadpage',
370                     filename : pref+ '-' + NS.id + '.csv',
371                     headers : xmlhttp.getAllResponseHeaders(),
372                     contentType:xmlhttp.getResponseHeader("Content-Type"),
373                     data: ar
374                 }));
375            
376         }
377         
378         xmlhttp.send(kv.join('&'));
379            
380     },
381     login : function(u,p,id)
382     {
383         
384         try {
385             document.forms[0].email.value = u;
386             document.forms[0].password.value = p;
387             
388             
389             
390             document.forms[0].elements['jsenabled'].value = 'T';
391             setLoginCookie(document.forms[0].elements['rememberme'].checked);
392             
393             document.forms[0].submit();
394             
395             
396             
397         } catch( e) {
398             this.rungrab(id);
399             
400         }
401     }
402     
403     
404     
405 }