Built motion from commit 973e3e332e1c8e2f84c4b0cd2e5af794131724f5. Version 3.0.0...
[motion-next.git] / server / components / export / csv.js
index 022ccd9..0a0316b 100644 (file)
@@ -1 +1 @@
-const a826_0x1f3c=['num','each','AnalyticExtractedReport','inspect','CSV','length','util','to-csv','Setting','splitSizeCsv','info','split','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','%s.%s','Empty','%s\x20limit\x20%d\x20OFFSET\x20%d','%s%d.%s','analytics','dirname','mkdirSync','argv','update','rimraf','findOne','writeFileSync','sequelize','then','query','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','catch','zip-dir','../../mysqldb','Failed','format','dbH','QueryTypes','csv','SELECT','join','push','path'];(function(_0x1f39d1,_0x1f3c6e){const _0x4bca46=function(_0xcbd746){while(--_0xcbd746){_0x1f39d1['push'](_0x1f39d1['shift']());}};_0x4bca46(++_0x1f3c6e);}(a826_0x1f3c,0xa0));const a826_0x4bca=function(_0x1f39d1,_0x1f3c6e){_0x1f39d1=_0x1f39d1-0x0;let _0x4bca46=a826_0x1f3c[_0x1f39d1];return _0x4bca46;};const _0x2a6d68=a826_0x4bca;'use strict';const util=require(_0x2a6d68('0xe')),path=require(_0x2a6d68('0x7')),csv=require(_0x2a6d68('0xf')),fs=require('fs'),zipdir=require(_0x2a6d68('0x27')),rimraf=require(_0x2a6d68('0x1e')),db=require('../../mysqldb')['db'],dbH=require(_0x2a6d68('0x28'))[_0x2a6d68('0x1')],logger=require('../../config/logger')(_0x2a6d68('0x19')),EXTRACTED_REPORT_ID=Number(process[_0x2a6d68('0x1c')][0x2]),QUERY=process[_0x2a6d68('0x1c')][0x3],PATH=process[_0x2a6d68('0x1c')][0x4];function analyticExtractedReport(_0xcbd746,_0x48db8b){const _0x543d74=_0x2a6d68,_0x5d3976={'status':_0xcbd746},_0x1245dc={'where':{'id':EXTRACTED_REPORT_ID}};return _0x48db8b&&(_0x5d3976['savename']=_0x48db8b),db[_0x543d74('0xa')][_0x543d74('0x1d')](_0x5d3976,_0x1245dc);}function main(){const _0x3e2e54=_0x2a6d68;let _0xfe2b58=0x1388,_0x3a6c55;return logger[_0x3e2e54('0x12')](util[_0x3e2e54('0x0')](_0x3e2e54('0x24'),EXTRACTED_REPORT_ID,_0x3e2e54('0xc'))),db[_0x3e2e54('0x10')][_0x3e2e54('0x1f')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x3e2e54('0x13'),'splitSizeCsv']})[_0x3e2e54('0x22')](function(_0x49bdfb){const _0x4eb444=_0x3e2e54;_0x49bdfb&&(_0x3a6c55=_0x49bdfb,_0xfe2b58=_0x3a6c55[_0x4eb444('0x11')]||0x1388);})['then'](function(){const _0x5e2f10=_0x3e2e54;return dbH[_0x5e2f10('0x21')]['query'](util[_0x5e2f10('0x0')](_0x5e2f10('0x14'),QUERY),{'type':dbH[_0x5e2f10('0x21')][_0x5e2f10('0x2')][_0x5e2f10('0x4')]});})[_0x3e2e54('0x22')](function(_0x332a2e){const _0x2add59=_0x3e2e54;if(!_0x332a2e[0x0][_0x2add59('0x8')])return analyticExtractedReport(_0x2add59('0x16'));const _0x2f8701=[];let _0x1f41f7=0x0,_0x49e759=!![];if(_0x332a2e&&_0x332a2e['length']){let _0x5f5259=_0x332a2e[0x0]['num']%(_0x1f41f7+_0xfe2b58);if(_0x3a6c55[_0x2add59('0x13')])for(;_0x49e759;_0x1f41f7+=_0xfe2b58,_0x5f5259=_0x332a2e[0x0][_0x2add59('0x8')]%(_0x1f41f7+_0xfe2b58)){(_0x5f5259==0x0||_0x5f5259==_0x332a2e[0x0][_0x2add59('0x8')])&&(_0x49e759=![]),_0x2f8701[_0x2add59('0x6')](dbH[_0x2add59('0x21')]['query'](util[_0x2add59('0x0')](_0x2add59('0x17'),QUERY,_0xfe2b58,_0x1f41f7),{'type':dbH[_0x2add59('0x21')][_0x2add59('0x2')][_0x2add59('0x4')]}));}else _0x2f8701[_0x2add59('0x6')](dbH[_0x2add59('0x21')][_0x2add59('0x23')](QUERY,{'type':dbH[_0x2add59('0x21')][_0x2add59('0x2')][_0x2add59('0x4')]}));}const _0xb8bee3=path[_0x2add59('0x1a')](PATH),_0x1707c1=path['basename'](PATH,'.csv'),_0x29f451=_0x3a6c55[_0x2add59('0x13')]&&_0x2f8701[_0x2add59('0xd')]>0x1,_0xbad114=[];return!fs['existsSync'](path[_0x2add59('0x5')](_0xb8bee3,_0x1707c1))&&_0x29f451&&fs[_0x2add59('0x1b')](path['join'](_0xb8bee3,_0x1707c1)),Promise[_0x2add59('0x9')](_0x2f8701,function(_0x485a6d){const _0x49cee1=_0x2add59;_0xbad114[_0x49cee1('0x6')](_0x485a6d);})['then'](function(){const _0x3b701e=_0x2add59;for(let _0x22ebca=0x0;_0x22ebca<_0xbad114['length'];_0x22ebca+=0x1){let _0x242b5b;const _0x4cc697=_0xbad114[_0x22ebca];_0x29f451?_0x242b5b=path[_0x3b701e('0x5')](_0xb8bee3,_0x1707c1,util[_0x3b701e('0x0')](_0x3b701e('0x18'),_0x1707c1,_0x22ebca,'csv')):_0x242b5b=path[_0x3b701e('0x5')](_0xb8bee3,util[_0x3b701e('0x0')]('%s.%s',_0x1707c1,_0x3b701e('0x3'))),fs[_0x3b701e('0x20')](_0x242b5b,csv(_0x4cc697));}})[_0x2add59('0x22')](function(){const _0x15eddf=_0x2add59;_0x29f451&&(zipdir(path[_0x15eddf('0x5')](_0xb8bee3,_0x1707c1),{'saveTo':path['join'](_0xb8bee3,util[_0x15eddf('0x0')](_0x15eddf('0x15'),_0x1707c1,'zip'))},function(){}),rimraf(path[_0x15eddf('0x5')](_0xb8bee3,_0x1707c1),function(){}));})[_0x2add59('0x22')](function(){const _0xbc1c1e=_0x2add59;return logger[_0xbc1c1e('0x12')](util[_0xbc1c1e('0x0')](_0xbc1c1e('0x25'),EXTRACTED_REPORT_ID,_0xbc1c1e('0xc'))),analyticExtractedReport('Completed',_0x29f451?util[_0xbc1c1e('0x0')](_0xbc1c1e('0x15'),_0x1707c1,_0x29f451?'zip':_0xbc1c1e('0x3')):null);});})[_0x3e2e54('0x26')](function(_0x42b6ba){const _0x12339f=_0x3e2e54;return logger['info'](util[_0x12339f('0x0')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'CSV'),util[_0x12339f('0xb')](_0x42b6ba,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x12339f('0x29'));});}main();
\ No newline at end of file
+const a826_0xaff6=['../../mysqldb','analytics','%s%d.%s','Completed','splitSizeCsv','format','%s\x20limit\x20%d\x20OFFSET\x20%d','%s.%s','../../config/logger','zip','sequelize','basename','.csv','query','savename','Setting','path','update','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','split','to-csv','AnalyticExtractedReport','then','CSV','QueryTypes','Empty','join','mkdirSync','info','SELECT','push','length','num','argv','Failed','catch','csv','existsSync'];(function(_0x4fab7b,_0xaff6bf){const _0x5abeed=function(_0x1057b2){while(--_0x1057b2){_0x4fab7b['push'](_0x4fab7b['shift']());}};_0x5abeed(++_0xaff6bf);}(a826_0xaff6,0xbc));const a826_0x5abe=function(_0x4fab7b,_0xaff6bf){_0x4fab7b=_0x4fab7b-0x0;let _0x5abeed=a826_0xaff6[_0x4fab7b];return _0x5abeed;};const _0x543740=a826_0x5abe;'use strict';const util=require('util'),path=require(_0x543740('0x12')),csv=require(_0x543740('0x16')),fs=require('fs'),zipdir=require('zip-dir'),rimraf=require('rimraf'),db=require(_0x543740('0x2'))['db'],dbH=require(_0x543740('0x2'))['dbH'],logger=require(_0x543740('0xa'))(_0x543740('0x3')),EXTRACTED_REPORT_ID=Number(process['argv'][0x2]),QUERY=process[_0x543740('0x23')][0x3],PATH=process[_0x543740('0x23')][0x4];function analyticExtractedReport(_0x1057b2,_0x49fd75){const _0x3d379a=_0x543740,_0x6e849f={'status':_0x1057b2},_0x8f514c={'where':{'id':EXTRACTED_REPORT_ID}};return _0x49fd75&&(_0x6e849f[_0x3d379a('0x10')]=_0x49fd75),db[_0x3d379a('0x17')][_0x3d379a('0x13')](_0x6e849f,_0x8f514c);}function main(){const _0x2c3767=_0x543740;let _0x2aa9c3=0x1388,_0x2c800f;return logger[_0x2c3767('0x1e')](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x2c3767('0x19'))),db[_0x2c3767('0x11')]['findOne']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x2c3767('0x15'),_0x2c3767('0x6')]})[_0x2c3767('0x18')](function(_0x663b06){const _0xbece0b=_0x2c3767;_0x663b06&&(_0x2c800f=_0x663b06,_0x2aa9c3=_0x2c800f[_0xbece0b('0x6')]||0x1388);})[_0x2c3767('0x18')](function(){const _0x5531ff=_0x2c3767;return dbH['sequelize'][_0x5531ff('0xf')](util[_0x5531ff('0x7')](_0x5531ff('0x14'),QUERY),{'type':dbH[_0x5531ff('0xc')][_0x5531ff('0x1a')][_0x5531ff('0x1f')]});})[_0x2c3767('0x18')](function(_0x408647){const _0x7ab4c5=_0x2c3767;if(!_0x408647[0x0][_0x7ab4c5('0x22')])return analyticExtractedReport(_0x7ab4c5('0x1b'));const _0x1c1a18=[];let _0x42ff03=0x0,_0x16122d=!![];if(_0x408647&&_0x408647[_0x7ab4c5('0x21')]){let _0x29d5c4=_0x408647[0x0][_0x7ab4c5('0x22')]%(_0x42ff03+_0x2aa9c3);if(_0x2c800f[_0x7ab4c5('0x15')])for(;_0x16122d;_0x42ff03+=_0x2aa9c3,_0x29d5c4=_0x408647[0x0]['num']%(_0x42ff03+_0x2aa9c3)){(_0x29d5c4==0x0||_0x29d5c4==_0x408647[0x0]['num'])&&(_0x16122d=![]),_0x1c1a18[_0x7ab4c5('0x20')](dbH['sequelize'][_0x7ab4c5('0xf')](util[_0x7ab4c5('0x7')](_0x7ab4c5('0x8'),QUERY,_0x2aa9c3,_0x42ff03),{'type':dbH[_0x7ab4c5('0xc')][_0x7ab4c5('0x1a')]['SELECT']}));}else _0x1c1a18['push'](dbH[_0x7ab4c5('0xc')][_0x7ab4c5('0xf')](QUERY,{'type':dbH[_0x7ab4c5('0xc')][_0x7ab4c5('0x1a')][_0x7ab4c5('0x1f')]}));}const _0x220473=path['dirname'](PATH),_0x4e6bd3=path[_0x7ab4c5('0xd')](PATH,_0x7ab4c5('0xe')),_0x125450=_0x2c800f[_0x7ab4c5('0x15')]&&_0x1c1a18[_0x7ab4c5('0x21')]>0x1,_0x48c6b9=[];return!fs[_0x7ab4c5('0x1')](path[_0x7ab4c5('0x1c')](_0x220473,_0x4e6bd3))&&_0x125450&&fs[_0x7ab4c5('0x1d')](path[_0x7ab4c5('0x1c')](_0x220473,_0x4e6bd3)),Promise['each'](_0x1c1a18,function(_0x528fbd){const _0x4af9a9=_0x7ab4c5;_0x48c6b9[_0x4af9a9('0x20')](_0x528fbd);})[_0x7ab4c5('0x18')](function(){const _0x4792ef=_0x7ab4c5;for(let _0x5d12ac=0x0;_0x5d12ac<_0x48c6b9[_0x4792ef('0x21')];_0x5d12ac+=0x1){let _0x2c2d22;const _0x16e3c9=_0x48c6b9[_0x5d12ac];_0x125450?_0x2c2d22=path[_0x4792ef('0x1c')](_0x220473,_0x4e6bd3,util[_0x4792ef('0x7')](_0x4792ef('0x4'),_0x4e6bd3,_0x5d12ac,_0x4792ef('0x0'))):_0x2c2d22=path[_0x4792ef('0x1c')](_0x220473,util[_0x4792ef('0x7')]('%s.%s',_0x4e6bd3,_0x4792ef('0x0'))),fs['writeFileSync'](_0x2c2d22,csv(_0x16e3c9));}})[_0x7ab4c5('0x18')](function(){const _0x461f25=_0x7ab4c5;_0x125450&&(zipdir(path[_0x461f25('0x1c')](_0x220473,_0x4e6bd3),{'saveTo':path[_0x461f25('0x1c')](_0x220473,util['format'](_0x461f25('0x9'),_0x4e6bd3,_0x461f25('0xb')))},function(){}),rimraf(path[_0x461f25('0x1c')](_0x220473,_0x4e6bd3),function(){}));})[_0x7ab4c5('0x18')](function(){const _0x2d89fe=_0x7ab4c5;return logger[_0x2d89fe('0x1e')](util[_0x2d89fe('0x7')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x2d89fe('0x19'))),analyticExtractedReport(_0x2d89fe('0x5'),_0x125450?util[_0x2d89fe('0x7')](_0x2d89fe('0x9'),_0x4e6bd3,_0x125450?_0x2d89fe('0xb'):_0x2d89fe('0x0')):null);});})[_0x2c3767('0x25')](function(_0x3cc94e){const _0x43da52=_0x2c3767;return logger['info'](util[_0x43da52('0x7')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x43da52('0x19')),util['inspect'](_0x3cc94e,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x43da52('0x24'));});}main();
\ No newline at end of file