-const a828_0x176a=['xlsx','json2xls','SELECT','Completed','%s.%s','update','%s%d.%s','join','zip-dir','info','Empty','dirname','sequelize','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','binary','path','splitSizeXlsx','XLSX','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','each','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','AnalyticExtractedReport','split','%s\x20limit\x20%d\x20OFFSET\x20%d','catch','rimraf','findOne','existsSync','Failed','QueryTypes','then','../../config/logger','query','dbH','length','push','num','writeFileSync','zip','argv','format','../../mysqldb','basename','util'];(function(_0x772b95,_0x176a3a){const _0x5dea12=function(_0x436723){while(--_0x436723){_0x772b95['push'](_0x772b95['shift']());}};_0x5dea12(++_0x176a3a);}(a828_0x176a,0x1c6));const a828_0x5dea=function(_0x772b95,_0x176a3a){_0x772b95=_0x772b95-0x0;let _0x5dea12=a828_0x176a[_0x772b95];return _0x5dea12;};const _0xceb7ea=a828_0x5dea;'use strict';const util=require(_0xceb7ea('0x5')),path=require(_0xceb7ea('0x15')),fs=require('fs'),json2xls=require(_0xceb7ea('0x7')),zipdir=require(_0xceb7ea('0xe')),rimraf=require(_0xceb7ea('0x21')),db=require(_0xceb7ea('0x3'))['db'],dbH=require(_0xceb7ea('0x3'))[_0xceb7ea('0x29')],logger=require(_0xceb7ea('0x27'))('analytics'),EXTRACTED_REPORT_ID=Number(process[_0xceb7ea('0x1')][0x2]),QUERY=process[_0xceb7ea('0x1')][0x3],PATH=process[_0xceb7ea('0x1')][0x4];function analyticExtractedReport(_0x436723,_0x3a9ce8){const _0x2ab2b6=_0xceb7ea,_0xea5739={'status':_0x436723},_0x4d532f={'where':{'id':EXTRACTED_REPORT_ID}};return _0x3a9ce8&&(_0xea5739['savename']=_0x3a9ce8),db[_0x2ab2b6('0x1d')][_0x2ab2b6('0xb')](_0xea5739,_0x4d532f);}function main(){const _0x2d6554=_0xceb7ea;let _0x3c33c1=0x1388,_0x3ac665;return logger['info'](util[_0x2d6554('0x2')](_0x2d6554('0x18'),EXTRACTED_REPORT_ID,_0x2d6554('0x17'))),db[_0x2d6554('0x19')][_0x2d6554('0x22')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x2d6554('0x1e'),_0x2d6554('0x16')]})[_0x2d6554('0x26')](function(_0x15f379){const _0x360019=_0x2d6554;_0x15f379&&(_0x3ac665=_0x15f379,_0x3c33c1=_0x3ac665[_0x360019('0x16')]||0x1388);})[_0x2d6554('0x26')](function(){const _0x2e1b55=_0x2d6554;return dbH[_0x2e1b55('0x12')]['query'](util['format'](_0x2e1b55('0x1c'),QUERY),{'type':dbH['sequelize'][_0x2e1b55('0x25')][_0x2e1b55('0x8')]});})[_0x2d6554('0x26')](function(_0xbc6ef1){const _0x3a4a15=_0x2d6554;if(!_0xbc6ef1[0x0][_0x3a4a15('0x2c')])return analyticExtractedReport(_0x3a4a15('0x10'));const _0x42d1a7=[];let _0x3b2663=0x0,_0x308435=!![];if(_0x3ac665[_0x3a4a15('0x1e')]){if(_0xbc6ef1&&_0xbc6ef1['length']){let _0x58f04c=_0xbc6ef1[0x0][_0x3a4a15('0x2c')]%(_0x3b2663+_0x3c33c1);for(;_0x308435;_0x3b2663+=_0x3c33c1,_0x58f04c=_0xbc6ef1[0x0][_0x3a4a15('0x2c')]%(_0x3b2663+_0x3c33c1)){(_0x58f04c==0x0||_0x58f04c==_0xbc6ef1[0x0][_0x3a4a15('0x2c')])&&(_0x308435=![]),_0x42d1a7[_0x3a4a15('0x2b')](dbH['sequelize']['query'](util[_0x3a4a15('0x2')](_0x3a4a15('0x1f'),QUERY,_0x3c33c1,_0x3b2663),{'type':dbH[_0x3a4a15('0x12')][_0x3a4a15('0x25')][_0x3a4a15('0x8')]}));}}}else _0x42d1a7[_0x3a4a15('0x2b')](dbH[_0x3a4a15('0x12')][_0x3a4a15('0x28')](QUERY,{'type':dbH[_0x3a4a15('0x12')]['QueryTypes'][_0x3a4a15('0x8')]}));const _0x4e06f8=path[_0x3a4a15('0x11')](PATH),_0x505028=path[_0x3a4a15('0x4')](PATH,'.xlsx'),_0x40e6c9=_0x3ac665[_0x3a4a15('0x1e')]&&_0x42d1a7[_0x3a4a15('0x2a')]>0x1,_0x1c39d5=[];return!fs[_0x3a4a15('0x23')](path[_0x3a4a15('0xd')](_0x4e06f8,_0x505028))&&_0x40e6c9&&fs['mkdirSync'](path[_0x3a4a15('0xd')](_0x4e06f8,_0x505028)),Promise[_0x3a4a15('0x1a')](_0x42d1a7,function(_0x1804bd){const _0x465f4b=_0x3a4a15;_0x1c39d5[_0x465f4b('0x2b')](_0x1804bd);})[_0x3a4a15('0x26')](function(){const _0x4b6511=_0x3a4a15;for(let _0x2a0cd8=0x0;_0x2a0cd8<_0x1c39d5[_0x4b6511('0x2a')];_0x2a0cd8+=0x1){let _0x51b166;const _0x2e145f=_0x1c39d5[_0x2a0cd8];_0x40e6c9?_0x51b166=path[_0x4b6511('0xd')](_0x4e06f8,_0x505028,util[_0x4b6511('0x2')](_0x4b6511('0xc'),_0x505028,_0x2a0cd8,_0x4b6511('0x6'))):_0x51b166=path['join'](_0x4e06f8,util['format'](_0x4b6511('0xa'),_0x505028,_0x4b6511('0x6'))),fs[_0x4b6511('0x2d')](_0x51b166,json2xls(_0x2e145f),_0x4b6511('0x14'));}})[_0x3a4a15('0x26')](function(){const _0x371743=_0x3a4a15;_0x40e6c9&&(zipdir(path[_0x371743('0xd')](_0x4e06f8,_0x505028),{'saveTo':path[_0x371743('0xd')](_0x4e06f8,util[_0x371743('0x2')](_0x371743('0xa'),_0x505028,_0x371743('0x0')))},function(){}),rimraf(path[_0x371743('0xd')](_0x4e06f8,_0x505028),function(){}));})[_0x3a4a15('0x26')](function(){const _0x44fcfd=_0x3a4a15;return logger[_0x44fcfd('0xf')](util[_0x44fcfd('0x2')](_0x44fcfd('0x13'),EXTRACTED_REPORT_ID,_0x44fcfd('0x17'))),analyticExtractedReport(_0x44fcfd('0x9'),_0x40e6c9?util['format'](_0x44fcfd('0xa'),_0x505028,_0x40e6c9?_0x44fcfd('0x0'):_0x44fcfd('0x6')):null);});})[_0x2d6554('0x20')](function(_0x491b46){const _0x6c4c59=_0x2d6554;return logger['info'](util[_0x6c4c59('0x2')](_0x6c4c59('0x1b'),EXTRACTED_REPORT_ID,_0x6c4c59('0x17')),util['inspect'](_0x491b46,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x6c4c59('0x24'));});}main();
\ No newline at end of file
+const a828_0x51df=['update','query','writeFileSync','%s.%s','splitSizeXlsx','zip','argv','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','split','info','each','json2xls','sequelize','path','num','dirname','XLSX','then','findOne','length','xlsx','SELECT','push','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','../../mysqldb','format','../../config/logger','basename','catch','Empty','QueryTypes','Failed','util','Setting','rimraf','zip-dir','AnalyticExtractedReport','join','analytics','binary','savename','inspect','.xlsx'];(function(_0x58dc17,_0x51dfff){const _0x7b4a4d=function(_0xd512ab){while(--_0xd512ab){_0x58dc17['push'](_0x58dc17['shift']());}};_0x7b4a4d(++_0x51dfff);}(a828_0x51df,0x19e));const a828_0x7b4a=function(_0x58dc17,_0x51dfff){_0x58dc17=_0x58dc17-0x0;let _0x7b4a4d=a828_0x51df[_0x58dc17];return _0x7b4a4d;};const _0x53024c=a828_0x7b4a;'use strict';const util=require(_0x53024c('0x5')),path=require(_0x53024c('0x1d')),fs=require('fs'),json2xls=require(_0x53024c('0x1b')),zipdir=require(_0x53024c('0x8')),rimraf=require(_0x53024c('0x7')),db=require(_0x53024c('0x28'))['db'],dbH=require(_0x53024c('0x28'))['dbH'],logger=require(_0x53024c('0x2a'))(_0x53024c('0xb')),EXTRACTED_REPORT_ID=Number(process[_0x53024c('0x16')][0x2]),QUERY=process['argv'][0x3],PATH=process[_0x53024c('0x16')][0x4];function analyticExtractedReport(_0xd512ab,_0x52508a){const _0x27bcb7=_0x53024c,_0x2656f3={'status':_0xd512ab},_0x34e367={'where':{'id':EXTRACTED_REPORT_ID}};return _0x52508a&&(_0x2656f3[_0x27bcb7('0xd')]=_0x52508a),db[_0x27bcb7('0x9')][_0x27bcb7('0x10')](_0x2656f3,_0x34e367);}function main(){const _0x5034bd=_0x53024c;let _0x389609=0x1388,_0x4df3ff;return logger[_0x5034bd('0x19')](util['format'](_0x5034bd('0x17'),EXTRACTED_REPORT_ID,'XLSX')),db[_0x5034bd('0x6')][_0x5034bd('0x22')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x5034bd('0x18'),_0x5034bd('0x14')]})[_0x5034bd('0x21')](function(_0x1fc4e1){const _0x1ccf1d=_0x5034bd;_0x1fc4e1&&(_0x4df3ff=_0x1fc4e1,_0x389609=_0x4df3ff[_0x1ccf1d('0x14')]||0x1388);})[_0x5034bd('0x21')](function(){const _0x563f15=_0x5034bd;return dbH[_0x563f15('0x1c')][_0x563f15('0x11')](util[_0x563f15('0x29')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x563f15('0x1c')][_0x563f15('0x3')][_0x563f15('0x25')]});})[_0x5034bd('0x21')](function(_0x3817f9){const _0x3443c9=_0x5034bd;if(!_0x3817f9[0x0][_0x3443c9('0x1e')])return analyticExtractedReport(_0x3443c9('0x2'));const _0x3a7287=[];let _0x268671=0x0,_0x31a11a=!![];if(_0x4df3ff[_0x3443c9('0x18')]){if(_0x3817f9&&_0x3817f9[_0x3443c9('0x23')]){let _0x3a5b52=_0x3817f9[0x0]['num']%(_0x268671+_0x389609);for(;_0x31a11a;_0x268671+=_0x389609,_0x3a5b52=_0x3817f9[0x0][_0x3443c9('0x1e')]%(_0x268671+_0x389609)){(_0x3a5b52==0x0||_0x3a5b52==_0x3817f9[0x0][_0x3443c9('0x1e')])&&(_0x31a11a=![]),_0x3a7287['push'](dbH[_0x3443c9('0x1c')][_0x3443c9('0x11')](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x389609,_0x268671),{'type':dbH['sequelize'][_0x3443c9('0x3')]['SELECT']}));}}}else _0x3a7287[_0x3443c9('0x26')](dbH[_0x3443c9('0x1c')][_0x3443c9('0x11')](QUERY,{'type':dbH['sequelize'][_0x3443c9('0x3')][_0x3443c9('0x25')]}));const _0x3a720e=path[_0x3443c9('0x1f')](PATH),_0x2e2eff=path[_0x3443c9('0x0')](PATH,_0x3443c9('0xf')),_0x372c86=_0x4df3ff[_0x3443c9('0x18')]&&_0x3a7287['length']>0x1,_0x96afe=[];return!fs['existsSync'](path[_0x3443c9('0xa')](_0x3a720e,_0x2e2eff))&&_0x372c86&&fs['mkdirSync'](path[_0x3443c9('0xa')](_0x3a720e,_0x2e2eff)),Promise[_0x3443c9('0x1a')](_0x3a7287,function(_0x37d878){const _0x52af37=_0x3443c9;_0x96afe[_0x52af37('0x26')](_0x37d878);})[_0x3443c9('0x21')](function(){const _0x5d1357=_0x3443c9;for(let _0x1eb6ff=0x0;_0x1eb6ff<_0x96afe[_0x5d1357('0x23')];_0x1eb6ff+=0x1){let _0x432b48;const _0x3c58e4=_0x96afe[_0x1eb6ff];_0x372c86?_0x432b48=path[_0x5d1357('0xa')](_0x3a720e,_0x2e2eff,util['format']('%s%d.%s',_0x2e2eff,_0x1eb6ff,_0x5d1357('0x24'))):_0x432b48=path[_0x5d1357('0xa')](_0x3a720e,util[_0x5d1357('0x29')]('%s.%s',_0x2e2eff,_0x5d1357('0x24'))),fs[_0x5d1357('0x12')](_0x432b48,json2xls(_0x3c58e4),_0x5d1357('0xc'));}})[_0x3443c9('0x21')](function(){const _0x51729a=_0x3443c9;_0x372c86&&(zipdir(path[_0x51729a('0xa')](_0x3a720e,_0x2e2eff),{'saveTo':path[_0x51729a('0xa')](_0x3a720e,util[_0x51729a('0x29')](_0x51729a('0x13'),_0x2e2eff,_0x51729a('0x15')))},function(){}),rimraf(path['join'](_0x3a720e,_0x2e2eff),function(){}));})['then'](function(){const _0x4a6d45=_0x3443c9;return logger[_0x4a6d45('0x19')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x4a6d45('0x20'))),analyticExtractedReport('Completed',_0x372c86?util[_0x4a6d45('0x29')]('%s.%s',_0x2e2eff,_0x372c86?_0x4a6d45('0x15'):_0x4a6d45('0x24')):null);});})[_0x5034bd('0x1')](function(_0x42a73d){const _0x304a30=_0x5034bd;return logger[_0x304a30('0x19')](util['format'](_0x304a30('0x27'),EXTRACTED_REPORT_ID,_0x304a30('0x20')),util[_0x304a30('0xe')](_0x42a73d,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x304a30('0x4'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff