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         return;
155         
156         
157          
158         
159     },
160     
161     rungrab : function (id) {
162         //NS.rungrabInventory(id);
163         NS.rungrabAccounts(id);
164     },
165     rungrabInventory : function(id)
166     {
167         //id = 282;
168         this.id = id;
169         var timeout = 10;
170         var frameload = function()
171         {
172              
173             
174             
175             
176         }
177         console.log("document.location" + document.location);
178         
179         if (!(window.location + '').match(/netsuite/)) {
180             // try
181             window.location = "https://system.netsuite.com/app/reporting/reportrunner.nl?cr=425&customized=T&whence=";
182             return;
183         }
184         // do stuff..
185         // we really just want to send a series of download requests..
186         //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
187         
188         document.getElementById('filt1').style = '';
189         
190         var set = {
191                 crit_4_displayField : '',
192                 hddn_crit_41  : '',
193                 crit_2_from : '1/1/2007',
194                 crit_2_to: '1/1/2014',
195                 hddn_crit_32 :getDropdown(document.getElementById('inpt_crit_32')).valueArray[id],
196                 inpt_crit_32 :getDropdown(document.getElementById('inpt_crit_32')).valueArray[id],
197                 indx_crit_32 : id
198
199         }
200         
201         var rneed = false;
202         if (!NS.varscheck ) {
203             
204             for (var  k in set) {
205                 if (k == 'inpt_crit_32') {
206                     continue; // this gets abbreivated..
207                 }
208                 
209                 try { 
210                     var cur = document.getElementById(k).value;
211                 } catch(e) {
212                     console.log("Can not find " + k);
213                     continue;
214                 }
215                 console.log("CUR : " + k + '=' + cur + ' ?= ' + set[k]);
216                 if (cur != set[k]) {
217                     console.log("DOE NOT MATCH?");
218                     rneed = true;
219                     //document.forms.main_form.elements[k].value = set[k];
220                     document.getElementById(k).value = set[k];
221                     continue;
222                 }
223                 
224                 
225             }
226         }
227                
228         if (rneed ) {
229             
230             console.log('SUBMIT');
231             document.forms.main_form.submit();
232             
233             return;
234         }
235         NS.varscheck = true;
236         console.log('form values - ok - checking if empty');
237         
238          if (   reportTable.oContentProvider.bRequestPending
239                 || !reportTable.isInLoadedState()) {
240                 console.log('report not ready?');
241                 NS.timeout--;
242                 if (NS.timeout < 0) {
243                     console.log('SENDING EMTPY..?');
244                     console.log(
245                          JSON.stringify ({
246                             requesturl : '',
247                             method: 'nsdownloadpage',
248                             filename : NS.id + '.csv',
249                             headers : '',
250                             contentType: '',
251                             data: []
252                         }));
253                     return;
254                     
255                     
256                 }
257                 
258                 window.setTimeout( function() {  NS.rungrab(id); } ,1000);
259                 
260                 return;
261                 
262             }
263         console.log('no empty - trying download');
264             
265         
266        
267         console.log(reportTable.getTotalRowCount());
268          NS.downloaddata(
269             'https://system.netsuite.com/app/reporting/reportrunner.nl',
270             {
271                 id: document.forms.main_form.elements.id.value,
272                 reportaction: 'exportcsv',
273                 apptype: 'html',
274                 visibleranges: '0,' +  reportTable.getTotalRowCount()
275             }
276             
277         );
278         
279        
280         
281         return;
282          
283         
284         
285     },
286     
287     
288     downloadgetdata : function (url,data) {
289         
290        
291         var xmlhttp = new XMLHttpRequest();
292                     
293         xmlhttp.open("GET", url,true);
294         xmlhttp.responseType = 'arraybuffer';
295         //xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
296         //var kv = [];
297         //for(var i in data) {
298         //    kv.push(i +'=' + encodeURIComponent(  data[i]));
299         //}
300         
301
302         xmlhttp.onload=function() {
303            
304             var ar= [];
305              
306             var r = new Uint8Array(xmlhttp.response);
307             for (i=0;i<r.byteLength;i++) {
308                 ar.push(r[i]);
309             }
310             
311             // location name for location download.
312             var pref = 'HK-Account';
313             
314             console.log(
315                 JSON.stringify ({
316                     requesturl : url,
317                     method: 'nsdownloadpage',
318                     filename : pref+ '-' + NS.id + '.csv',
319                     headers : xmlhttp.getAllResponseHeaders(),
320                     contentType:xmlhttp.getResponseHeader("Content-Type"),
321                     data: ar
322                 }));
323            
324         }
325         
326         xmlhttp.send();
327            
328     },
329     
330     
331     
332     downloaddata : function (url,data) {
333         
334        
335         var xmlhttp = new XMLHttpRequest();
336                     
337         xmlhttp.open("POST", url,true);
338         xmlhttp.responseType = 'arraybuffer';
339         xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
340         var kv = [];
341         for(var i in data) {
342             kv.push(i +'=' + encodeURIComponent(  data[i]));
343         }
344         
345
346         xmlhttp.onload=function() {
347            
348             var ar= [];
349              
350             var r = new Uint8Array(xmlhttp.response);
351             for (i=0;i<r.byteLength;i++) {
352                 ar.push(r[i]);
353             }
354             
355             // location name for location download.
356             var pref = '';
357             if (document.getElementById('hddn_crit_32')) {
358                 //stock.
359                 pref =  document.getElementById('hddn_crit_32').value ;
360             } else {
361                 // accounts.
362                 pref = document.getElementsByClassName('pt_title')[0].innerText.replace(/\s+$/,'').replace(/\//g, '');
363             }
364             
365             console.log(
366                 JSON.stringify ({
367                     requesturl : url,
368                     method: 'nsdownloadpage',
369                     filename : pref+ '-' + NS.id + '.csv',
370                     headers : xmlhttp.getAllResponseHeaders(),
371                     contentType:xmlhttp.getResponseHeader("Content-Type"),
372                     data: ar
373                 }));
374            
375         }
376         
377         xmlhttp.send(kv.join('&'));
378            
379     },
380     login : function(u,p,id)
381     {
382         
383         try {
384             document.forms[0].email.value = u;
385             document.forms[0].password.value = p;
386             
387             
388             
389             document.forms[0].elements['jsenabled'].value = 'T';
390             setLoginCookie(document.forms[0].elements['rememberme'].checked);
391             
392             document.forms[0].submit();
393             
394             
395             
396         } catch( e) {
397             this.rungrab(id);
398             
399         }
400     }
401     
402     
403     
404 }