// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xde1e=['lodash','json2xls','bluebird','zip-dir','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','num','Empty','split','range','isInteger','forEach','push','QueryTypes','%s\x20limit\x20%d\x20OFFSET\x20%d','basename','.xlsx','length','existsSync','join','mkdirSync','each','%s%d.%s','xlsx','writeFileSync','%s.%s','zip','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','finally','exit','util','path'];(function(_0x5cd253,_0x4162da){var _0x36e179=function(_0x597977){while(--_0x597977){_0x5cd253['push'](_0x5cd253['shift']());}};_0x36e179(++_0x4162da);}(_0xde1e,0x9d));var _0xede1=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0xde1e[_0x321bb2];return _0x9c12ed;};'use strict';var util=require(_0xede1('0x0'));var path=require(_0xede1('0x1'));var _=require(_0xede1('0x2'));var fs=require('fs');var json2xls=require(_0xede1('0x3'));var BPromise=require(_0xede1('0x4'));var zipdir=require(_0xede1('0x5'));var rimraf=require('rimraf');var db=require(_0xede1('0x6'))['db'];var dbH=require(_0xede1('0x6'))[_0xede1('0x7')];var logger=require(_0xede1('0x8'))(_0xede1('0x9'));var EXTRACTED_REPORT_ID=Number(process[_0xede1('0xa')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0xede1('0xa')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0xeeec58,_0x1722c9){var _0x452e74={'status':_0xeeec58};var _0x29fe67={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x1722c9){_0x452e74[_0xede1('0xb')]=_0x1722c9;}return db['AnalyticExtractedReport'][_0xede1('0xc')](_0x452e74,_0x29fe67);}function main(){var _0x4bc1f1=0x1388;var _0x5828f7;logger[_0xede1('0xd')](util[_0xede1('0xe')](_0xede1('0xf'),EXTRACTED_REPORT_ID,_0xede1('0x10')));return db[_0xede1('0x11')][_0xede1('0x12')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xede1('0x13')]})[_0xede1('0x14')](function(_0x21fe95){if(_0x21fe95){_0x5828f7=_0x21fe95;_0x4bc1f1=_0x5828f7['splitSizeXlsx']||0x1388;}})['then'](function(){return dbH[_0xede1('0x15')][_0xede1('0x16')](util[_0xede1('0xe')](_0xede1('0x17'),QUERY),{'type':dbH[_0xede1('0x15')]['QueryTypes'][_0xede1('0x18')]});})[_0xede1('0x14')](function(_0x176828){if(!_0x176828[0x0][_0xede1('0x19')]){return analyticExtractedReport(_0xede1('0x1a'));}var _0x1600ec=[];var _0x225d07=0x0;if(_0x5828f7[_0xede1('0x1b')]){if(_0x176828&&_0x176828['length']){var _0x32048a=_[_0xede1('0x1c')](_0x176828[0x0][_0xede1('0x19')]/_0x4bc1f1);var _0x24f860=Number[_0xede1('0x1d')](_0x176828[0x0][_0xede1('0x19')]/_0x4bc1f1)?_0x176828[0x0][_0xede1('0x19')]%_0x4bc1f1:0x0;_0x32048a[_0xede1('0x1e')](function(_0x131540){if(_0x131540>0x0){_0x225d07+=_0x4bc1f1;}_0x1600ec[_0xede1('0x1f')](dbH[_0xede1('0x15')]['query'](util[_0xede1('0xe')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x4bc1f1,_0x225d07),{'type':dbH['sequelize'][_0xede1('0x20')][_0xede1('0x18')]}));});if(_0x24f860>0x0){_0x225d07+=_0x4bc1f1;_0x1600ec[_0xede1('0x1f')](dbH[_0xede1('0x15')][_0xede1('0x16')](util[_0xede1('0xe')](_0xede1('0x21'),QUERY,_0x24f860,_0x225d07),{'type':dbH[_0xede1('0x15')]['QueryTypes'][_0xede1('0x18')]}));}}}else{_0x1600ec[_0xede1('0x1f')](dbH['sequelize']['query'](QUERY,{'type':dbH[_0xede1('0x15')][_0xede1('0x20')]['SELECT']}));}var _0x50bc2f=path['dirname'](PATH);var _0x12149f=path[_0xede1('0x22')](PATH,_0xede1('0x23'));var _0x1a5569=_0x5828f7[_0xede1('0x1b')]&&_0x1600ec[_0xede1('0x24')]>0x1;var _0x2a8ebb=[];if(!fs[_0xede1('0x25')](path[_0xede1('0x26')](_0x50bc2f,_0x12149f))&&_0x1a5569){fs[_0xede1('0x27')](path[_0xede1('0x26')](_0x50bc2f,_0x12149f));}return BPromise[_0xede1('0x28')](_0x1600ec,function(_0x4bd927){_0x2a8ebb[_0xede1('0x1f')](_0x4bd927);})[_0xede1('0x14')](function(){for(var _0x4ef352=0x0;_0x4ef352<_0x2a8ebb[_0xede1('0x24')];_0x4ef352+=0x1){var _0x20e647;var _0xbf0a98=_0x2a8ebb[_0x4ef352];if(_0x1a5569){_0x20e647=path[_0xede1('0x26')](_0x50bc2f,_0x12149f,util[_0xede1('0xe')](_0xede1('0x29'),_0x12149f,_0x4ef352,_0xede1('0x2a')));}else{_0x20e647=path[_0xede1('0x26')](_0x50bc2f,util[_0xede1('0xe')]('%s.%s',_0x12149f,'xlsx'));}fs[_0xede1('0x2b')](_0x20e647,json2xls(_0xbf0a98),'binary');}})[_0xede1('0x14')](function(){if(_0x1a5569){return new Promise(function(_0x27ab56){zipdir(path[_0xede1('0x26')](_0x50bc2f,_0x12149f),{'saveTo':path[_0xede1('0x26')](_0x50bc2f,util[_0xede1('0xe')](_0xede1('0x2c'),_0x12149f,_0xede1('0x2d')))},function(_0x37237a,_0x3596a1){rimraf(path['join'](_0x50bc2f,_0x12149f),function(){});_0x27ab56(_0xede1('0x2e'));});});}})['then'](function(){logger[_0xede1('0xd')](util['format'](_0xede1('0x2f'),EXTRACTED_REPORT_ID,_0xede1('0x10')));return analyticExtractedReport(_0xede1('0x30'),_0x1a5569?util[_0xede1('0xe')](_0xede1('0x2c'),_0x12149f,_0x1a5569?'zip':_0xede1('0x2a')):null);});})['catch'](function(_0x14967c){logger[_0xede1('0xd')](util[_0xede1('0xe')](_0xede1('0x31'),EXTRACTED_REPORT_ID,_0xede1('0x10')),util['inspect'](_0x14967c,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xede1('0x32'));})[_0xede1('0x33')](function(){process[_0xede1('0x34')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xfaa6=['../../mysqldb','dbH','argv','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','then','splitSizeXlsx','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','num','Empty','isInteger','push','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','dirname','basename','.xlsx','length','existsSync','join','mkdirSync','each','%s%d.%s','%s.%s','writeFileSync','binary','XLSX','xlsx','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','util','path','lodash','json2xls','bluebird','zip-dir','rimraf'];(function(_0x1abb09,_0x18ee91){var _0xea1c07=function(_0x38f42c){while(--_0x38f42c){_0x1abb09['push'](_0x1abb09['shift']());}};_0xea1c07(++_0x18ee91);}(_0xfaa6,0xbd));var _0x6faa=function(_0x469ac7,_0x38e416){_0x469ac7=_0x469ac7-0x0;var _0x22f3b0=_0xfaa6[_0x469ac7];return _0x22f3b0;};'use strict';var util=require(_0x6faa('0x0'));var path=require(_0x6faa('0x1'));var _=require(_0x6faa('0x2'));var fs=require('fs');var json2xls=require(_0x6faa('0x3'));var BPromise=require(_0x6faa('0x4'));var zipdir=require(_0x6faa('0x5'));var rimraf=require(_0x6faa('0x6'));var db=require(_0x6faa('0x7'))['db'];var dbH=require(_0x6faa('0x7'))[_0x6faa('0x8')];var logger=require('../../config/logger')('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x6faa('0x9')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x6faa('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x325fc7,_0x27195c){var _0x874022={'status':_0x325fc7};var _0x23311b={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x27195c){_0x874022['savename']=_0x27195c;}return db[_0x6faa('0xa')][_0x6faa('0xb')](_0x874022,_0x23311b);}function main(){var _0x3af018=0x1388;var _0x31fc9a;logger[_0x6faa('0xc')](util[_0x6faa('0xd')](_0x6faa('0xe'),EXTRACTED_REPORT_ID,'XLSX'));return db[_0x6faa('0xf')][_0x6faa('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x6faa('0x11'),'splitSizeXlsx']})[_0x6faa('0x12')](function(_0x2d06c1){if(_0x2d06c1){_0x31fc9a=_0x2d06c1;_0x3af018=_0x31fc9a[_0x6faa('0x13')]||0x1388;}})[_0x6faa('0x12')](function(){return dbH[_0x6faa('0x14')][_0x6faa('0x15')](util[_0x6faa('0xd')](_0x6faa('0x16'),QUERY),{'type':dbH[_0x6faa('0x14')]['QueryTypes']['SELECT']});})[_0x6faa('0x12')](function(_0xe102e8){if(!_0xe102e8[0x0][_0x6faa('0x17')]){return analyticExtractedReport(_0x6faa('0x18'));}var _0x38b5f9=[];var _0x38f4dd=0x0;if(_0x31fc9a[_0x6faa('0x11')]){if(_0xe102e8&&_0xe102e8['length']){var _0x59c342=_['range'](_0xe102e8[0x0]['num']/_0x3af018);var _0x4b9320=Number[_0x6faa('0x19')](_0xe102e8[0x0][_0x6faa('0x17')]/_0x3af018)?_0xe102e8[0x0][_0x6faa('0x17')]%_0x3af018:0x0;_0x59c342['forEach'](function(_0x24b19f){if(_0x24b19f>0x0){_0x38f4dd+=_0x3af018;}_0x38b5f9[_0x6faa('0x1a')](dbH[_0x6faa('0x14')]['query'](util['format'](_0x6faa('0x1b'),QUERY,_0x3af018,_0x38f4dd),{'type':dbH[_0x6faa('0x14')][_0x6faa('0x1c')][_0x6faa('0x1d')]}));});if(_0x4b9320>0x0){_0x38f4dd+=_0x3af018;_0x38b5f9[_0x6faa('0x1a')](dbH[_0x6faa('0x14')][_0x6faa('0x15')](util[_0x6faa('0xd')](_0x6faa('0x1b'),QUERY,_0x4b9320,_0x38f4dd),{'type':dbH[_0x6faa('0x14')][_0x6faa('0x1c')][_0x6faa('0x1d')]}));}}}else{_0x38b5f9[_0x6faa('0x1a')](dbH[_0x6faa('0x14')][_0x6faa('0x15')](QUERY,{'type':dbH[_0x6faa('0x14')][_0x6faa('0x1c')][_0x6faa('0x1d')]}));}var _0x3b0fae=path[_0x6faa('0x1e')](PATH);var _0x22965f=path[_0x6faa('0x1f')](PATH,_0x6faa('0x20'));var _0x2c6687=_0x31fc9a['split']&&_0x38b5f9[_0x6faa('0x21')]>0x1;var _0x48aad8=[];if(!fs[_0x6faa('0x22')](path[_0x6faa('0x23')](_0x3b0fae,_0x22965f))&&_0x2c6687){fs[_0x6faa('0x24')](path[_0x6faa('0x23')](_0x3b0fae,_0x22965f));}return BPromise[_0x6faa('0x25')](_0x38b5f9,function(_0x4c2e2c){_0x48aad8['push'](_0x4c2e2c);})[_0x6faa('0x12')](function(){for(var _0xf20193=0x0;_0xf20193<_0x48aad8[_0x6faa('0x21')];_0xf20193+=0x1){var _0x2cf427;var _0x19f768=_0x48aad8[_0xf20193];if(_0x2c6687){_0x2cf427=path[_0x6faa('0x23')](_0x3b0fae,_0x22965f,util[_0x6faa('0xd')](_0x6faa('0x26'),_0x22965f,_0xf20193,'xlsx'));}else{_0x2cf427=path[_0x6faa('0x23')](_0x3b0fae,util[_0x6faa('0xd')](_0x6faa('0x27'),_0x22965f,'xlsx'));}fs[_0x6faa('0x28')](_0x2cf427,json2xls(_0x19f768),_0x6faa('0x29'));}})[_0x6faa('0x12')](function(){if(_0x2c6687){return new Promise(function(_0x255caa){zipdir(path[_0x6faa('0x23')](_0x3b0fae,_0x22965f),{'saveTo':path[_0x6faa('0x23')](_0x3b0fae,util[_0x6faa('0xd')](_0x6faa('0x27'),_0x22965f,'zip'))},function(_0x1b7778,_0x1b740e){rimraf(path[_0x6faa('0x23')](_0x3b0fae,_0x22965f),function(){});_0x255caa('zip\x20finished');});});}})[_0x6faa('0x12')](function(){logger[_0x6faa('0xc')](util[_0x6faa('0xd')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x6faa('0x2a')));return analyticExtractedReport('Completed',_0x2c6687?util[_0x6faa('0xd')](_0x6faa('0x27'),_0x22965f,_0x2c6687?'zip':_0x6faa('0x2b')):null);});})['catch'](function(_0x34e20c){logger[_0x6faa('0xc')](util[_0x6faa('0xd')](_0x6faa('0x2c'),EXTRACTED_REPORT_ID,_0x6faa('0x2a')),util[_0x6faa('0x2d')](_0x34e20c,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x6faa('0x2e'));})[_0x6faa('0x2f')](function(){process[_0x6faa('0x30')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff