-const a828_0xdbf2=['Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','rimraf','QueryTypes','length','analytics','map','info','../../config/logger','json2xls','then','../../mysqldb','.xlsx','mkdirSync','num','%s.%s','SELECT','basename','xlsx','binary','join','Setting','format','XLSX','push','splitSizeXlsx','dirname','dbH','all','sequelize','split','util','update','Empty','query','zip','argv','Failed','catch','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','%s\x20limit\x20%d\x20OFFSET\x20%d'];(function(_0xdd655c,_0xdbf25f){const _0x3941ce=function(_0x306e0c){while(--_0x306e0c){_0xdd655c['push'](_0xdd655c['shift']());}};_0x3941ce(++_0xdbf25f);}(a828_0xdbf2,0x1de));const a828_0x3941=function(_0xdd655c,_0xdbf25f){_0xdd655c=_0xdd655c-0x0;let _0x3941ce=a828_0xdbf2[_0xdd655c];return _0x3941ce;};const _0x31ac7a=a828_0x3941;'use strict';const util=require(_0x31ac7a('0x20')),path=require('path'),fs=require('fs'),json2xls=require(_0x31ac7a('0xa')),zipdir=require('zip-dir'),rimraf=require(_0x31ac7a('0x3')),db=require(_0x31ac7a('0xc'))['db'],dbH=require(_0x31ac7a('0xc'))[_0x31ac7a('0x1c')],logger=require(_0x31ac7a('0x9'))(_0x31ac7a('0x6')),EXTRACTED_REPORT_ID=Number(process[_0x31ac7a('0x25')][0x2]),QUERY=process[_0x31ac7a('0x25')][0x3],PATH=process['argv'][0x4];function analyticExtractedReport(_0x306e0c,_0x2b16e8){const _0x561530=_0x31ac7a,_0x36a1c9={'status':_0x306e0c},_0x19a21c={'where':{'id':EXTRACTED_REPORT_ID}};return _0x2b16e8&&(_0x36a1c9['savename']=_0x2b16e8),db['AnalyticExtractedReport'][_0x561530('0x21')](_0x36a1c9,_0x19a21c);}function main(){const _0x143d4e=_0x31ac7a;let _0x528f08=0x1388,_0x3bdb8c;return logger[_0x143d4e('0x8')](util[_0x143d4e('0x17')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x143d4e('0x18'))),db[_0x143d4e('0x16')]['findOne']({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x143d4e('0x1a')]})[_0x143d4e('0xb')](function(_0xfc1b88){const _0x29470b=_0x143d4e;_0xfc1b88&&(_0x3bdb8c=_0xfc1b88,_0x528f08=_0x3bdb8c[_0x29470b('0x1a')]||0x1388);})['then'](function(){const _0x5548ad=_0x143d4e;return dbH[_0x5548ad('0x1e')][_0x5548ad('0x23')](util[_0x5548ad('0x17')](_0x5548ad('0x0'),QUERY),{'type':dbH['sequelize']['QueryTypes'][_0x5548ad('0x11')]});})[_0x143d4e('0xb')](function(_0x25eb9e){const _0x43517f=_0x143d4e;if(!_0x25eb9e[0x0][_0x43517f('0xf')])return analyticExtractedReport(_0x43517f('0x22'));const _0x39b87f=[];let _0x1ad679=0x0,_0x24e00b=!![];if(_0x3bdb8c[_0x43517f('0x1f')]){if(_0x25eb9e&&_0x25eb9e['length']){let _0x32d349=_0x25eb9e[0x0][_0x43517f('0xf')]%(_0x1ad679+_0x528f08);for(;_0x24e00b;_0x1ad679+=_0x528f08,_0x32d349=_0x25eb9e[0x0][_0x43517f('0xf')]%(_0x1ad679+_0x528f08)){(_0x32d349==0x0||_0x32d349==_0x25eb9e[0x0][_0x43517f('0xf')])&&(_0x24e00b=![]),_0x39b87f['push'](dbH['sequelize'][_0x43517f('0x23')](util[_0x43517f('0x17')](_0x43517f('0x1'),QUERY,_0x528f08,_0x1ad679),{'type':dbH[_0x43517f('0x1e')]['QueryTypes'][_0x43517f('0x11')]}));}}}else _0x39b87f[_0x43517f('0x19')](dbH[_0x43517f('0x1e')][_0x43517f('0x23')](QUERY,{'type':dbH[_0x43517f('0x1e')][_0x43517f('0x4')][_0x43517f('0x11')]}));const _0x2de388=path[_0x43517f('0x1b')](PATH),_0x33ea45=path[_0x43517f('0x12')](PATH,_0x43517f('0xd')),_0x2b5fc2=_0x3bdb8c[_0x43517f('0x1f')]&&_0x39b87f[_0x43517f('0x5')]>0x1,_0x26ea50=[];return!fs['existsSync'](path[_0x43517f('0x15')](_0x2de388,_0x33ea45))&&_0x2b5fc2&&fs[_0x43517f('0xe')](path[_0x43517f('0x15')](_0x2de388,_0x33ea45)),Promise[_0x43517f('0x1d')](_0x39b87f[_0x43517f('0x7')](_0x3dfc02=>{_0x26ea50['push'](_0x3dfc02);}))['then'](function(){const _0x4149b0=_0x43517f;for(let _0x4222d1=0x0;_0x4222d1<_0x26ea50[_0x4149b0('0x5')];_0x4222d1+=0x1){let _0xf90fc6;const _0x174202=_0x26ea50[_0x4222d1];_0x2b5fc2?_0xf90fc6=path[_0x4149b0('0x15')](_0x2de388,_0x33ea45,util[_0x4149b0('0x17')]('%s%d.%s',_0x33ea45,_0x4222d1,_0x4149b0('0x13'))):_0xf90fc6=path[_0x4149b0('0x15')](_0x2de388,util['format'](_0x4149b0('0x10'),_0x33ea45,_0x4149b0('0x13'))),fs['writeFileSync'](_0xf90fc6,json2xls(_0x174202),_0x4149b0('0x14'));}})[_0x43517f('0xb')](function(){const _0x489a79=_0x43517f;_0x2b5fc2&&(zipdir(path['join'](_0x2de388,_0x33ea45),{'saveTo':path[_0x489a79('0x15')](_0x2de388,util['format']('%s.%s',_0x33ea45,_0x489a79('0x24')))},function(){}),rimraf(path[_0x489a79('0x15')](_0x2de388,_0x33ea45),function(){}));})['then'](function(){const _0x23b980=_0x43517f;return logger['info'](util[_0x23b980('0x17')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x23b980('0x18'))),analyticExtractedReport('Completed',_0x2b5fc2?util['format'](_0x23b980('0x10'),_0x33ea45,_0x2b5fc2?'zip':_0x23b980('0x13')):null);});})[_0x143d4e('0x27')](function(_0x48819f){const _0x3bf0ff=_0x143d4e;return logger[_0x3bf0ff('0x8')](util[_0x3bf0ff('0x17')](_0x3bf0ff('0x2'),EXTRACTED_REPORT_ID,_0x3bf0ff('0x18')),util['inspect'](_0x48819f,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x3bf0ff('0x26'));});}main();
\ No newline at end of file
+const a828_0x145c=['%s%d.%s','info','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','XLSX','util','then','writeFileSync','findOne','zip','catch','AnalyticExtractedReport','.xlsx','splitSizeXlsx','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','SELECT','Setting','basename','inspect','argv','dirname','map','rimraf','json2xls','split','QueryTypes','Completed','sequelize','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','format','existsSync','Empty','num','path','join','../../config/logger','%s\x20limit\x20%d\x20OFFSET\x20%d','length','analytics','xlsx','../../mysqldb','push','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','dbH','update','binary','query'];(function(_0x4a3906,_0x145cd8){const _0x2bdce7=function(_0x1278cd){while(--_0x1278cd){_0x4a3906['push'](_0x4a3906['shift']());}};_0x2bdce7(++_0x145cd8);}(a828_0x145c,0xb1));const a828_0x2bdc=function(_0x4a3906,_0x145cd8){_0x4a3906=_0x4a3906-0x0;let _0x2bdce7=a828_0x145c[_0x4a3906];return _0x2bdce7;};const _0x1215a4=a828_0x2bdc;'use strict';const util=require(_0x1215a4('0xb')),path=require(_0x1215a4('0x27')),fs=require('fs'),json2xls=require(_0x1215a4('0x1d')),zipdir=require('zip-dir'),rimraf=require(_0x1215a4('0x1c')),db=require(_0x1215a4('0x0'))['db'],dbH=require(_0x1215a4('0x0'))[_0x1215a4('0x3')],logger=require(_0x1215a4('0x29'))(_0x1215a4('0x2c')),EXTRACTED_REPORT_ID=Number(process[_0x1215a4('0x19')][0x2]),QUERY=process[_0x1215a4('0x19')][0x3],PATH=process[_0x1215a4('0x19')][0x4];function analyticExtractedReport(_0x1278cd,_0x5ac745){const _0x50c6f9=_0x1215a4,_0x13e5a1={'status':_0x1278cd},_0x44566a={'where':{'id':EXTRACTED_REPORT_ID}};return _0x5ac745&&(_0x13e5a1['savename']=_0x5ac745),db[_0x50c6f9('0x11')][_0x50c6f9('0x4')](_0x13e5a1,_0x44566a);}function main(){const _0x36b9ca=_0x1215a4;let _0x58a8df=0x1388,_0x297fe2;return logger[_0x36b9ca('0x8')](util[_0x36b9ca('0x23')](_0x36b9ca('0x14'),EXTRACTED_REPORT_ID,_0x36b9ca('0xa'))),db[_0x36b9ca('0x16')][_0x36b9ca('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x36b9ca('0x1e'),_0x36b9ca('0x13')]})[_0x36b9ca('0xc')](function(_0x138ac8){_0x138ac8&&(_0x297fe2=_0x138ac8,_0x58a8df=_0x297fe2['splitSizeXlsx']||0x1388);})[_0x36b9ca('0xc')](function(){const _0x4d7517=_0x36b9ca;return dbH[_0x4d7517('0x21')][_0x4d7517('0x6')](util['format'](_0x4d7517('0x9'),QUERY),{'type':dbH[_0x4d7517('0x21')][_0x4d7517('0x1f')]['SELECT']});})[_0x36b9ca('0xc')](function(_0x15fea5){const _0x26940c=_0x36b9ca;if(!_0x15fea5[0x0]['num'])return analyticExtractedReport(_0x26940c('0x25'));const _0x4b7f0e=[];let _0x10d683=0x0,_0x2893b6=!![];if(_0x297fe2[_0x26940c('0x1e')]){if(_0x15fea5&&_0x15fea5[_0x26940c('0x2b')]){let _0x163619=_0x15fea5[0x0][_0x26940c('0x26')]%(_0x10d683+_0x58a8df);for(;_0x2893b6;_0x10d683+=_0x58a8df,_0x163619=_0x15fea5[0x0][_0x26940c('0x26')]%(_0x10d683+_0x58a8df)){(_0x163619==0x0||_0x163619==_0x15fea5[0x0][_0x26940c('0x26')])&&(_0x2893b6=![]),_0x4b7f0e[_0x26940c('0x1')](dbH[_0x26940c('0x21')][_0x26940c('0x6')](util[_0x26940c('0x23')](_0x26940c('0x2a'),QUERY,_0x58a8df,_0x10d683),{'type':dbH['sequelize'][_0x26940c('0x1f')][_0x26940c('0x15')]}));}}}else _0x4b7f0e[_0x26940c('0x1')](dbH['sequelize'][_0x26940c('0x6')](QUERY,{'type':dbH[_0x26940c('0x21')]['QueryTypes']['SELECT']}));const _0x3c79a8=path[_0x26940c('0x1a')](PATH),_0x1aa8c9=path[_0x26940c('0x17')](PATH,_0x26940c('0x12')),_0x5ab42f=_0x297fe2[_0x26940c('0x1e')]&&_0x4b7f0e['length']>0x1,_0x285dcc=[];return!fs[_0x26940c('0x24')](path[_0x26940c('0x28')](_0x3c79a8,_0x1aa8c9))&&_0x5ab42f&&fs['mkdirSync'](path[_0x26940c('0x28')](_0x3c79a8,_0x1aa8c9)),Promise['all'](_0x4b7f0e[_0x26940c('0x1b')](_0x491ab7=>{const _0x1aa09f=_0x26940c;_0x285dcc[_0x1aa09f('0x1')](_0x491ab7);}))[_0x26940c('0xc')](function(){const _0x63d788=_0x26940c;for(let _0x2da838=0x0;_0x2da838<_0x285dcc[_0x63d788('0x2b')];_0x2da838+=0x1){let _0x250988;const _0x5ce9ef=_0x285dcc[_0x2da838];_0x5ab42f?_0x250988=path[_0x63d788('0x28')](_0x3c79a8,_0x1aa8c9,util[_0x63d788('0x23')](_0x63d788('0x7'),_0x1aa8c9,_0x2da838,_0x63d788('0x2d'))):_0x250988=path[_0x63d788('0x28')](_0x3c79a8,util['format']('%s.%s',_0x1aa8c9,_0x63d788('0x2d'))),fs[_0x63d788('0xd')](_0x250988,json2xls(_0x5ce9ef),_0x63d788('0x5'));}})[_0x26940c('0xc')](function(){const _0x4c7efb=_0x26940c;_0x5ab42f&&(zipdir(path['join'](_0x3c79a8,_0x1aa8c9),{'saveTo':path['join'](_0x3c79a8,util['format']('%s.%s',_0x1aa8c9,'zip'))},function(){}),rimraf(path[_0x4c7efb('0x28')](_0x3c79a8,_0x1aa8c9),function(){}));})[_0x26940c('0xc')](function(){const _0x412eb9=_0x26940c;return logger[_0x412eb9('0x8')](util[_0x412eb9('0x23')](_0x412eb9('0x22'),EXTRACTED_REPORT_ID,_0x412eb9('0xa'))),analyticExtractedReport(_0x412eb9('0x20'),_0x5ab42f?util[_0x412eb9('0x23')]('%s.%s',_0x1aa8c9,_0x5ab42f?_0x412eb9('0xf'):_0x412eb9('0x2d')):null);});})[_0x36b9ca('0x10')](function(_0x5b8db9){const _0x1e8669=_0x36b9ca;return logger[_0x1e8669('0x8')](util[_0x1e8669('0x23')](_0x1e8669('0x2'),EXTRACTED_REPORT_ID,'XLSX'),util[_0x1e8669('0x18')](_0x5b8db9,{'showHidden':![],'depth':null})),analyticExtractedReport('Failed');});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff