// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc2b4=['format','XLSX','Setting','find','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','split','length','push','SELECT','dirname','.xlsx','existsSync','join','mkdirSync','xlsx','writeFileSync','%s.%s','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch','Failed','util','path','lodash','json2xls','rimraf','../../mysqldb','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info'];(function(_0x2ab3d9,_0x50e716){var _0x210a54=function(_0x24c479){while(--_0x24c479){_0x2ab3d9['push'](_0x2ab3d9['shift']());}};_0x210a54(++_0x50e716);}(_0xc2b4,0xc5));var _0x4c2b=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xc2b4[_0x3dd15e];return _0x231fd0;};'use strict';var util=require(_0x4c2b('0x0'));var path=require(_0x4c2b('0x1'));var _=require(_0x4c2b('0x2'));var fs=require('fs');var json2xls=require(_0x4c2b('0x3'));var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require(_0x4c2b('0x4'));var db=require(_0x4c2b('0x5'))['db'];var dbH=require(_0x4c2b('0x5'))['dbH'];var logger=require(_0x4c2b('0x6'))(_0x4c2b('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x4c2b('0x8')][0x3];var PATH=process[_0x4c2b('0x8')][0x4];function analyticExtractedReport(_0x12c96e,_0xa5c76b){var _0x427f07={'status':_0x12c96e};var _0x9a40c8={'where':{'id':EXTRACTED_REPORT_ID}};if(_0xa5c76b){_0x427f07[_0x4c2b('0x9')]=_0xa5c76b;}return db[_0x4c2b('0xa')][_0x4c2b('0xb')](_0x427f07,_0x9a40c8);}function main(){var _0x557445=0x1388;var _0x28ecd8;logger[_0x4c2b('0xc')](util[_0x4c2b('0xd')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x4c2b('0xe')));return db[_0x4c2b('0xf')][_0x4c2b('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split','splitSizeXlsx']})['then'](function(_0x11cc06){if(_0x11cc06){_0x28ecd8=_0x11cc06;_0x557445=_0x28ecd8[_0x4c2b('0x11')]||0x1388;}})[_0x4c2b('0x12')](function(){return dbH[_0x4c2b('0x13')][_0x4c2b('0x14')](util[_0x4c2b('0xd')](_0x4c2b('0x15'),QUERY),{'type':dbH[_0x4c2b('0x13')][_0x4c2b('0x16')]['SELECT']});})['then'](function(_0x52a7bc){if(!_0x52a7bc[0x0][_0x4c2b('0x17')]){return analyticExtractedReport(_0x4c2b('0x18'));}var _0xbfa649=[];var _0x12c72d=0x0;var _0x153958=!![];if(_0x28ecd8[_0x4c2b('0x19')]){if(_0x52a7bc&&_0x52a7bc[_0x4c2b('0x1a')]){var _0x3dd7d3=_0x52a7bc[0x0][_0x4c2b('0x17')]%(_0x12c72d+_0x557445);for(;_0x153958;_0x12c72d+=_0x557445,_0x3dd7d3=_0x52a7bc[0x0]['num']%(_0x12c72d+_0x557445)){if(_0x3dd7d3==0x0||_0x3dd7d3==_0x52a7bc[0x0][_0x4c2b('0x17')]){_0x153958=![];}_0xbfa649[_0x4c2b('0x1b')](dbH[_0x4c2b('0x13')]['query'](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x557445,_0x12c72d),{'type':dbH[_0x4c2b('0x13')][_0x4c2b('0x16')][_0x4c2b('0x1c')]}));}}}else{_0xbfa649[_0x4c2b('0x1b')](dbH[_0x4c2b('0x13')][_0x4c2b('0x14')](QUERY,{'type':dbH[_0x4c2b('0x13')]['QueryTypes']['SELECT']}));}var _0x2c72ec=path[_0x4c2b('0x1d')](PATH);var _0x305d84=path['basename'](PATH,_0x4c2b('0x1e'));var _0x21016a=_0x28ecd8['split']&&_0xbfa649[_0x4c2b('0x1a')]>0x1;var _0x3eb4fb=[];if(!fs[_0x4c2b('0x1f')](path[_0x4c2b('0x20')](_0x2c72ec,_0x305d84))&&_0x21016a){fs[_0x4c2b('0x21')](path[_0x4c2b('0x20')](_0x2c72ec,_0x305d84));}return BPromise['each'](_0xbfa649,function(_0x393428){_0x3eb4fb['push'](_0x393428);})[_0x4c2b('0x12')](function(){for(var _0x791e55=0x0;_0x791e55<_0x3eb4fb[_0x4c2b('0x1a')];_0x791e55+=0x1){var _0x2d3646;var _0x38773e=_0x3eb4fb[_0x791e55];if(_0x21016a){_0x2d3646=path[_0x4c2b('0x20')](_0x2c72ec,_0x305d84,util[_0x4c2b('0xd')]('%s%d.%s',_0x305d84,_0x791e55,_0x4c2b('0x22')));}else{_0x2d3646=path[_0x4c2b('0x20')](_0x2c72ec,util['format']('%s.%s',_0x305d84,_0x4c2b('0x22')));}fs[_0x4c2b('0x23')](_0x2d3646,json2xls(_0x38773e),'binary');}})[_0x4c2b('0x12')](function(){if(_0x21016a){zipdir(path['join'](_0x2c72ec,_0x305d84),{'saveTo':path[_0x4c2b('0x20')](_0x2c72ec,util['format'](_0x4c2b('0x24'),_0x305d84,_0x4c2b('0x25')))},function(_0x37b7b4,_0x46bc2d){});rimraf(path['join'](_0x2c72ec,_0x305d84),function(){});}})[_0x4c2b('0x12')](function(){logger[_0x4c2b('0xc')](util[_0x4c2b('0xd')](_0x4c2b('0x26'),EXTRACTED_REPORT_ID,_0x4c2b('0xe')));return analyticExtractedReport(_0x4c2b('0x27'),_0x21016a?util[_0x4c2b('0xd')]('%s.%s',_0x305d84,_0x21016a?_0x4c2b('0x25'):_0x4c2b('0x22')):null);});})[_0x4c2b('0x28')](function(_0x35c20a){logger['info'](util[_0x4c2b('0xd')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'XLSX'),util['inspect'](_0x35c20a,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x4c2b('0x29'));});}main();
\ No newline at end of file
+var _0x59f9=['bluebird','rimraf','dbH','../../config/logger','argv','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','then','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','split','push','sequelize','SELECT','basename','.xlsx','mkdirSync','each','length','join','xlsx','%s.%s','writeFileSync','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','XLSX','inspect','Failed','util','path','lodash','json2xls'];(function(_0x46e363,_0x45d7e2){var _0x3fb059=function(_0x5e6274){while(--_0x5e6274){_0x46e363['push'](_0x46e363['shift']());}};_0x3fb059(++_0x45d7e2);}(_0x59f9,0x1ea));var _0x959f=function(_0x49b207,_0x408ade){_0x49b207=_0x49b207-0x0;var _0x2dc8fa=_0x59f9[_0x49b207];return _0x2dc8fa;};'use strict';var util=require(_0x959f('0x0'));var path=require(_0x959f('0x1'));var _=require(_0x959f('0x2'));var fs=require('fs');var json2xls=require(_0x959f('0x3'));var BPromise=require(_0x959f('0x4'));var zipdir=require('zip-dir');var rimraf=require(_0x959f('0x5'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')[_0x959f('0x6')];var logger=require(_0x959f('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x959f('0x8')][0x2]);var QUERY=process['argv'][0x3];var PATH=process['argv'][0x4];function analyticExtractedReport(_0x200f23,_0x17f705){var _0x10245d={'status':_0x200f23};var _0x4fd44a={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x17f705){_0x10245d['savename']=_0x17f705;}return db[_0x959f('0x9')][_0x959f('0xa')](_0x10245d,_0x4fd44a);}function main(){var _0x27be8a=0x1388;var _0x2d9d39;logger[_0x959f('0xb')](util[_0x959f('0xc')](_0x959f('0xd'),EXTRACTED_REPORT_ID,'XLSX'));return db[_0x959f('0xe')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id','split','splitSizeXlsx']})[_0x959f('0xf')](function(_0x621f31){if(_0x621f31){_0x2d9d39=_0x621f31;_0x27be8a=_0x2d9d39['splitSizeXlsx']||0x1388;}})[_0x959f('0xf')](function(){return dbH['sequelize'][_0x959f('0x10')](util['format'](_0x959f('0x11'),QUERY),{'type':dbH['sequelize'][_0x959f('0x12')]['SELECT']});})['then'](function(_0x3dfe89){if(!_0x3dfe89[0x0][_0x959f('0x13')]){return analyticExtractedReport(_0x959f('0x14'));}var _0x2a0063=[];var _0x591894=0x0;var _0x13576d=!![];if(_0x2d9d39[_0x959f('0x15')]){if(_0x3dfe89&&_0x3dfe89['length']){var _0x5f518d=_0x3dfe89[0x0][_0x959f('0x13')]%(_0x591894+_0x27be8a);for(;_0x13576d;_0x591894+=_0x27be8a,_0x5f518d=_0x3dfe89[0x0][_0x959f('0x13')]%(_0x591894+_0x27be8a)){if(_0x5f518d==0x0||_0x5f518d==_0x3dfe89[0x0][_0x959f('0x13')]){_0x13576d=![];}_0x2a0063[_0x959f('0x16')](dbH['sequelize'][_0x959f('0x10')](util[_0x959f('0xc')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x27be8a,_0x591894),{'type':dbH[_0x959f('0x17')][_0x959f('0x12')][_0x959f('0x18')]}));}}}else{_0x2a0063[_0x959f('0x16')](dbH[_0x959f('0x17')][_0x959f('0x10')](QUERY,{'type':dbH['sequelize'][_0x959f('0x12')]['SELECT']}));}var _0x5bc2f5=path['dirname'](PATH);var _0x4ef857=path[_0x959f('0x19')](PATH,_0x959f('0x1a'));var _0x34fedd=_0x2d9d39[_0x959f('0x15')]&&_0x2a0063['length']>0x1;var _0x14cbb5=[];if(!fs['existsSync'](path['join'](_0x5bc2f5,_0x4ef857))&&_0x34fedd){fs[_0x959f('0x1b')](path['join'](_0x5bc2f5,_0x4ef857));}return BPromise[_0x959f('0x1c')](_0x2a0063,function(_0x91a389){_0x14cbb5[_0x959f('0x16')](_0x91a389);})[_0x959f('0xf')](function(){for(var _0x54c623=0x0;_0x54c623<_0x14cbb5[_0x959f('0x1d')];_0x54c623+=0x1){var _0x7df873;var _0x3dcc77=_0x14cbb5[_0x54c623];if(_0x34fedd){_0x7df873=path[_0x959f('0x1e')](_0x5bc2f5,_0x4ef857,util['format']('%s%d.%s',_0x4ef857,_0x54c623,_0x959f('0x1f')));}else{_0x7df873=path[_0x959f('0x1e')](_0x5bc2f5,util[_0x959f('0xc')](_0x959f('0x20'),_0x4ef857,'xlsx'));}fs[_0x959f('0x21')](_0x7df873,json2xls(_0x3dcc77),'binary');}})[_0x959f('0xf')](function(){if(_0x34fedd){zipdir(path[_0x959f('0x1e')](_0x5bc2f5,_0x4ef857),{'saveTo':path[_0x959f('0x1e')](_0x5bc2f5,util[_0x959f('0xc')](_0x959f('0x20'),_0x4ef857,'zip'))},function(_0x112cb4,_0x12d582){});rimraf(path['join'](_0x5bc2f5,_0x4ef857),function(){});}})['then'](function(){logger[_0x959f('0xb')](util[_0x959f('0xc')](_0x959f('0x22'),EXTRACTED_REPORT_ID,_0x959f('0x23')));return analyticExtractedReport('Completed',_0x34fedd?util[_0x959f('0xc')]('%s.%s',_0x4ef857,_0x34fedd?'zip':_0x959f('0x1f')):null);});})['catch'](function(_0x2df540){logger['info'](util[_0x959f('0xc')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'XLSX'),util[_0x959f('0x24')](_0x2df540,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x959f('0x25'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff