-const a988_0x3ae3=['Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','%s.%s','mkdirSync','existsSync','util','format','savename','dbH','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','push','Completed','all','join','QueryTypes','num','CSV','info','sequelize','../../mysqldb','split','zip-dir','.csv','map','argv','csv','zip','length','AnalyticExtractedReport','query','then','inspect','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','path','../../config/logger','splitSizeCsv','SELECT','Failed','writeFileSync','%s%d.%s','Empty','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format'];(function(_0x2e3e27,_0xbf9022){const _0x3ae3ee=function(_0x5dd1ae){while(--_0x5dd1ae){_0x2e3e27['push'](_0x2e3e27['shift']());}};_0x3ae3ee(++_0xbf9022);}(a988_0x3ae3,0x1be));const a988_0x5dd1=function(_0x2e3e27,_0xbf9022){_0x2e3e27=_0x2e3e27-0x1a8;let _0x3ae3ee=a988_0x3ae3[_0x2e3e27];return _0x3ae3ee;};const a988_0xae7024=a988_0x5dd1;'use strict';const util=require(a988_0xae7024(0x1bc)),path=require(a988_0xae7024(0x1af)),csv=require('to-csv'),fs=require('fs'),zipdir=require(a988_0xae7024(0x1cc)),rimraf=require('rimraf'),{db}=require(a988_0xae7024(0x1ca)),dbH=require('../../mysqldb')[a988_0xae7024(0x1bf)],logger=require(a988_0xae7024(0x1b0))('analytics'),EXTRACTED_REPORT_ID=Number(process[a988_0xae7024(0x1cf)][0x2]),QUERY=process[a988_0xae7024(0x1cf)][0x3],PATH=process[a988_0xae7024(0x1cf)][0x4];function analyticExtractedReport(_0x2296b3,_0x2415c4){const _0x2fbeb9=a988_0xae7024,_0x3cde03={'status':_0x2296b3},_0x369375={'where':{'id':EXTRACTED_REPORT_ID}};return _0x2415c4&&(_0x3cde03[_0x2fbeb9(0x1be)]=_0x2415c4),db[_0x2fbeb9(0x1a9)]['update'](_0x3cde03,_0x369375);}function main(){const _0x16bf5d=a988_0xae7024;let _0x3dcd8c=0x1388,_0x21156b;return logger[_0x16bf5d(0x1c8)](util[_0x16bf5d(0x1bd)](_0x16bf5d(0x1b7),EXTRACTED_REPORT_ID,_0x16bf5d(0x1c7))),db['Setting']['findOne']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x16bf5d(0x1cb),_0x16bf5d(0x1b1)]})[_0x16bf5d(0x1ab)](function(_0xee464b){const _0x59d662=_0x16bf5d;_0xee464b&&(_0x21156b=_0xee464b,_0x3dcd8c=_0x21156b[_0x59d662(0x1b1)]||0x1388);})[_0x16bf5d(0x1ab)](function(){const _0x2b2825=_0x16bf5d;return dbH['sequelize'][_0x2b2825(0x1aa)](util[_0x2b2825(0x1bd)](_0x2b2825(0x1ae),QUERY),{'type':dbH['sequelize'][_0x2b2825(0x1c5)][_0x2b2825(0x1b2)]});})[_0x16bf5d(0x1ab)](function(_0x40ab39){const _0xad03b8=_0x16bf5d;if(!_0x40ab39[0x0][_0xad03b8(0x1c6)])return analyticExtractedReport(_0xad03b8(0x1b6));const _0x51fcc8=[];let _0x46ca75=0x0,_0x471816=!![];if(_0x40ab39&&_0x40ab39[_0xad03b8(0x1a8)]){let _0x5d6861=_0x40ab39[0x0][_0xad03b8(0x1c6)]%(_0x46ca75+_0x3dcd8c);if(_0x21156b[_0xad03b8(0x1cb)])for(;_0x471816;_0x46ca75+=_0x3dcd8c,_0x5d6861=_0x40ab39[0x0][_0xad03b8(0x1c6)]%(_0x46ca75+_0x3dcd8c)){(_0x5d6861==0x0||_0x5d6861==_0x40ab39[0x0][_0xad03b8(0x1c6)])&&(_0x471816=![]),_0x51fcc8[_0xad03b8(0x1c1)](dbH[_0xad03b8(0x1c9)][_0xad03b8(0x1aa)](util[_0xad03b8(0x1bd)](_0xad03b8(0x1ad),QUERY,_0x3dcd8c,_0x46ca75),{'type':dbH[_0xad03b8(0x1c9)][_0xad03b8(0x1c5)][_0xad03b8(0x1b2)]}));}else _0x51fcc8['push'](dbH['sequelize'][_0xad03b8(0x1aa)](QUERY,{'type':dbH[_0xad03b8(0x1c9)]['QueryTypes']['SELECT']}));}const _0x551189=path['dirname'](PATH),_0xf1f311=path['basename'](PATH,_0xad03b8(0x1cd)),_0x2bea8a=_0x21156b[_0xad03b8(0x1cb)]&&_0x51fcc8[_0xad03b8(0x1a8)]>0x1,_0x566f75=[];return!fs[_0xad03b8(0x1bb)](path[_0xad03b8(0x1c4)](_0x551189,_0xf1f311))&&_0x2bea8a&&fs[_0xad03b8(0x1ba)](path[_0xad03b8(0x1c4)](_0x551189,_0xf1f311)),Promise[_0xad03b8(0x1c3)](_0x51fcc8[_0xad03b8(0x1ce)](_0x46cffb=>{const _0x12aeba=_0xad03b8;_0x566f75[_0x12aeba(0x1c1)](_0x46cffb);}))[_0xad03b8(0x1ab)](function(){const _0x5d6274=_0xad03b8;for(let _0x1099bf=0x0;_0x1099bf<_0x566f75['length'];_0x1099bf+=0x1){let _0x3646be;const _0x4c0bf7=_0x566f75[_0x1099bf];_0x2bea8a?_0x3646be=path[_0x5d6274(0x1c4)](_0x551189,_0xf1f311,util[_0x5d6274(0x1bd)](_0x5d6274(0x1b5),_0xf1f311,_0x1099bf,_0x5d6274(0x1d0))):_0x3646be=path[_0x5d6274(0x1c4)](_0x551189,util['format'](_0x5d6274(0x1b9),_0xf1f311,_0x5d6274(0x1d0))),fs[_0x5d6274(0x1b4)](_0x3646be,csv(_0x4c0bf7));}})['then'](function(){const _0x3aab37=_0xad03b8;_0x2bea8a&&(zipdir(path[_0x3aab37(0x1c4)](_0x551189,_0xf1f311),{'saveTo':path[_0x3aab37(0x1c4)](_0x551189,util[_0x3aab37(0x1bd)](_0x3aab37(0x1b9),_0xf1f311,_0x3aab37(0x1d1)))},function(){}),rimraf(path[_0x3aab37(0x1c4)](_0x551189,_0xf1f311),function(){}));})[_0xad03b8(0x1ab)](function(){const _0x2d8725=_0xad03b8;return logger[_0x2d8725(0x1c8)](util[_0x2d8725(0x1bd)](_0x2d8725(0x1c0),EXTRACTED_REPORT_ID,_0x2d8725(0x1c7))),analyticExtractedReport(_0x2d8725(0x1c2),_0x2bea8a?util[_0x2d8725(0x1bd)](_0x2d8725(0x1b9),_0xf1f311,_0x2bea8a?_0x2d8725(0x1d1):_0x2d8725(0x1d0)):null);});})['catch'](function(_0x230f3e){const _0x1c00b2=_0x16bf5d;return logger[_0x1c00b2(0x1c8)](util['format'](_0x1c00b2(0x1b8),EXTRACTED_REPORT_ID,'CSV'),util[_0x1c00b2(0x1ac)](_0x230f3e,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x1c00b2(0x1b3));});}main();
\ No newline at end of file
+const a988_0x54e9=['info','splitSizeCsv','query','dirname','then','CSV','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','sequelize','util','../../config/logger','%s%d.%s','csv','length','format','Failed','argv','update','SELECT','split','Empty','../../mysqldb','AnalyticExtractedReport','findOne','QueryTypes','%s.%s','%s\x20limit\x20%d\x20OFFSET\x20%d','num','catch','dbH','existsSync','join','push','inspect','path','to-csv','zip','rimraf'];(function(_0x26cccd,_0x2afc9d){const _0x54e945=function(_0x4d065c){while(--_0x4d065c){_0x26cccd['push'](_0x26cccd['shift']());}};_0x54e945(++_0x2afc9d);}(a988_0x54e9,0x151));const a988_0x4d06=function(_0x26cccd,_0x2afc9d){_0x26cccd=_0x26cccd-0x9f;let _0x54e945=a988_0x54e9[_0x26cccd];return _0x54e945;};const a988_0x14b6ba=a988_0x4d06;'use strict';const util=require(a988_0x14b6ba(0xad)),path=require(a988_0x14b6ba(0xa0)),csv=require(a988_0x14b6ba(0xa1)),fs=require('fs'),zipdir=require('zip-dir'),rimraf=require(a988_0x14b6ba(0xa3)),{db}=require('../../mysqldb'),dbH=require(a988_0x14b6ba(0xb9))[a988_0x14b6ba(0xc1)],logger=require(a988_0x14b6ba(0xae))('analytics'),EXTRACTED_REPORT_ID=Number(process[a988_0x14b6ba(0xb4)][0x2]),QUERY=process[a988_0x14b6ba(0xb4)][0x3],PATH=process['argv'][0x4];function analyticExtractedReport(_0x362098,_0x39d42c){const _0x405944=a988_0x14b6ba,_0x41128d={'status':_0x362098},_0x5e34a4={'where':{'id':EXTRACTED_REPORT_ID}};return _0x39d42c&&(_0x41128d['savename']=_0x39d42c),db[_0x405944(0xba)][_0x405944(0xb5)](_0x41128d,_0x5e34a4);}function main(){const _0x1dbb02=a988_0x14b6ba;let _0x47c93a=0x1388,_0x57f9cb;return logger[_0x1dbb02(0xa4)](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x1dbb02(0xa9))),db[_0x1dbb02(0xab)][_0x1dbb02(0xbb)]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x1dbb02(0xb7),_0x1dbb02(0xa5)]})[_0x1dbb02(0xa8)](function(_0xd2c643){_0xd2c643&&(_0x57f9cb=_0xd2c643,_0x47c93a=_0x57f9cb['splitSizeCsv']||0x1388);})['then'](function(){const _0x41442c=_0x1dbb02;return dbH[_0x41442c(0xac)][_0x41442c(0xa6)](util[_0x41442c(0xb2)]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x41442c(0xac)]['QueryTypes'][_0x41442c(0xb6)]});})['then'](function(_0x4e8955){const _0x3ab528=_0x1dbb02;if(!_0x4e8955[0x0][_0x3ab528(0xbf)])return analyticExtractedReport(_0x3ab528(0xb8));const _0x37b6c9=[];let _0x156869=0x0,_0x16c68f=!![];if(_0x4e8955&&_0x4e8955[_0x3ab528(0xb1)]){let _0x9db356=_0x4e8955[0x0][_0x3ab528(0xbf)]%(_0x156869+_0x47c93a);if(_0x57f9cb[_0x3ab528(0xb7)])for(;_0x16c68f;_0x156869+=_0x47c93a,_0x9db356=_0x4e8955[0x0][_0x3ab528(0xbf)]%(_0x156869+_0x47c93a)){(_0x9db356==0x0||_0x9db356==_0x4e8955[0x0]['num'])&&(_0x16c68f=![]),_0x37b6c9['push'](dbH[_0x3ab528(0xac)][_0x3ab528(0xa6)](util[_0x3ab528(0xb2)](_0x3ab528(0xbe),QUERY,_0x47c93a,_0x156869),{'type':dbH[_0x3ab528(0xac)][_0x3ab528(0xbc)][_0x3ab528(0xb6)]}));}else _0x37b6c9[_0x3ab528(0xc4)](dbH[_0x3ab528(0xac)]['query'](QUERY,{'type':dbH[_0x3ab528(0xac)][_0x3ab528(0xbc)][_0x3ab528(0xb6)]}));}const _0x463fa0=path[_0x3ab528(0xa7)](PATH),_0x14dd84=path['basename'](PATH,'.csv'),_0x3d6fcd=_0x57f9cb[_0x3ab528(0xb7)]&&_0x37b6c9['length']>0x1,_0x498223=[];return!fs[_0x3ab528(0xc2)](path[_0x3ab528(0xc3)](_0x463fa0,_0x14dd84))&&_0x3d6fcd&&fs['mkdirSync'](path[_0x3ab528(0xc3)](_0x463fa0,_0x14dd84)),Promise['all'](_0x37b6c9['map'](_0x34dfd1=>{const _0x485932=_0x3ab528;_0x498223[_0x485932(0xc4)](_0x34dfd1);}))[_0x3ab528(0xa8)](function(){const _0x3fa16e=_0x3ab528;for(let _0xb0ae33=0x0;_0xb0ae33<_0x498223[_0x3fa16e(0xb1)];_0xb0ae33+=0x1){let _0x34a1d6;const _0x2fc799=_0x498223[_0xb0ae33];_0x3d6fcd?_0x34a1d6=path['join'](_0x463fa0,_0x14dd84,util[_0x3fa16e(0xb2)](_0x3fa16e(0xaf),_0x14dd84,_0xb0ae33,_0x3fa16e(0xb0))):_0x34a1d6=path[_0x3fa16e(0xc3)](_0x463fa0,util[_0x3fa16e(0xb2)]('%s.%s',_0x14dd84,_0x3fa16e(0xb0))),fs['writeFileSync'](_0x34a1d6,csv(_0x2fc799));}})[_0x3ab528(0xa8)](function(){const _0x487872=_0x3ab528;_0x3d6fcd&&(zipdir(path[_0x487872(0xc3)](_0x463fa0,_0x14dd84),{'saveTo':path[_0x487872(0xc3)](_0x463fa0,util[_0x487872(0xb2)](_0x487872(0xbd),_0x14dd84,_0x487872(0xa2)))},function(){}),rimraf(path[_0x487872(0xc3)](_0x463fa0,_0x14dd84),function(){}));})[_0x3ab528(0xa8)](function(){const _0x4c2927=_0x3ab528;return logger[_0x4c2927(0xa4)](util[_0x4c2927(0xb2)]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x4c2927(0xa9))),analyticExtractedReport('Completed',_0x3d6fcd?util['format']('%s.%s',_0x14dd84,_0x3d6fcd?_0x4c2927(0xa2):_0x4c2927(0xb0)):null);});})[_0x1dbb02(0xc0)](function(_0x1273f4){const _0x5ef3f6=_0x1dbb02;return logger['info'](util[_0x5ef3f6(0xb2)](_0x5ef3f6(0xaa),EXTRACTED_REPORT_ID,_0x5ef3f6(0xa9)),util[_0x5ef3f6(0x9f)](_0x1273f4,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x5ef3f6(0xb3));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff