server/components/export/csv.js

   1 const a826_0x1d5a=['num','dirname','Setting','%s%d.%s','push','sequelize','../../config/logger','Failed','zip-dir','.csv','dbH','util','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','rimraf','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','QueryTypes','%s.%s','csv','zip','%s\x20limit\x20%d\x20OFFSET\x20%d','argv','join','existsSync','each','catch','../../mysqldb','savename','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','split','then','to-csv','Empty','AnalyticExtractedReport','length','query','analytics','info','SELECT','format','basename','CSV','splitSizeCsv','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','mkdirSync','update'];(function(_0xab7796,_0x1d5afa){const _0x3509d4=function(_0x50256a){while(--_0x50256a){_0xab7796['push'](_0xab7796['shift']());}};_0x3509d4(++_0x1d5afa);}(a826_0x1d5a,0x94));const a826_0x3509=function(_0xab7796,_0x1d5afa){_0xab7796=_0xab7796-0x0;let _0x3509d4=a826_0x1d5a[_0xab7796];return _0x3509d4;};const _0x5b0771=a826_0x3509;'use strict';const util=require(_0x5b0771('0x2b')),path=require('path'),csv=require(_0x5b0771('0x11')),fs=require('fs'),zipdir=require(_0x5b0771('0x28')),rimraf=require(_0x5b0771('0x0')),db=require('../../mysqldb')['db'],dbH=require(_0x5b0771('0xc'))[_0x5b0771('0x2a')],logger=require(_0x5b0771('0x26'))(_0x5b0771('0x16')),EXTRACTED_REPORT_ID=Number(process[_0x5b0771('0x7')][0x2]),QUERY=process[_0x5b0771('0x7')][0x3],PATH=process[_0x5b0771('0x7')][0x4];function analyticExtractedReport(_0x50256a,_0x2e58d8){const _0x53f5f6=_0x5b0771,_0x1b651b={'status':_0x50256a},_0x22da5c={'where':{'id':EXTRACTED_REPORT_ID}};return _0x2e58d8&&(_0x1b651b[_0x53f5f6('0xd')]=_0x2e58d8),db[_0x53f5f6('0x13')][_0x53f5f6('0x1f')](_0x1b651b,_0x22da5c);}function main(){const _0x46fc66=_0x5b0771;let _0x1b3801=0x1388,_0x42021d;return logger[_0x46fc66('0x17')](util[_0x46fc66('0x19')](_0x46fc66('0x2c'),EXTRACTED_REPORT_ID,_0x46fc66('0x1b'))),db[_0x46fc66('0x22')]['findOne']({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x46fc66('0x1c')]})[_0x46fc66('0x10')](function(_0x431bd0){const _0x5e73c1=_0x46fc66;_0x431bd0&&(_0x42021d=_0x431bd0,_0x1b3801=_0x42021d[_0x5e73c1('0x1c')]||0x1388);})[_0x46fc66('0x10')](function(){const _0x1a1d61=_0x46fc66;return dbH[_0x1a1d61('0x25')][_0x1a1d61('0x15')](util[_0x1a1d61('0x19')](_0x1a1d61('0xe'),QUERY),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0x46fc66('0x10')](function(_0x473bed){const _0x9ec7d8=_0x46fc66;if(!_0x473bed[0x0][_0x9ec7d8('0x20')])return analyticExtractedReport(_0x9ec7d8('0x12'));const _0x5ec3e3=[];let _0x387c53=0x0,_0x1be6e0=!![];if(_0x473bed&&_0x473bed['length']){let _0x25812b=_0x473bed[0x0][_0x9ec7d8('0x20')]%(_0x387c53+_0x1b3801);if(_0x42021d[_0x9ec7d8('0xf')])for(;_0x1be6e0;_0x387c53+=_0x1b3801,_0x25812b=_0x473bed[0x0][_0x9ec7d8('0x20')]%(_0x387c53+_0x1b3801)){(_0x25812b==0x0||_0x25812b==_0x473bed[0x0][_0x9ec7d8('0x20')])&&(_0x1be6e0=![]),_0x5ec3e3[_0x9ec7d8('0x24')](dbH[_0x9ec7d8('0x25')][_0x9ec7d8('0x15')](util[_0x9ec7d8('0x19')](_0x9ec7d8('0x6'),QUERY,_0x1b3801,_0x387c53),{'type':dbH[_0x9ec7d8('0x25')]['QueryTypes']['SELECT']}));}else _0x5ec3e3[_0x9ec7d8('0x24')](dbH[_0x9ec7d8('0x25')][_0x9ec7d8('0x15')](QUERY,{'type':dbH[_0x9ec7d8('0x25')][_0x9ec7d8('0x2')][_0x9ec7d8('0x18')]}));}const _0x25fdad=path[_0x9ec7d8('0x21')](PATH),_0x3a0af0=path[_0x9ec7d8('0x1a')](PATH,_0x9ec7d8('0x29')),_0x1f42f4=_0x42021d['split']&&_0x5ec3e3[_0x9ec7d8('0x14')]>0x1,_0x3dd2a5=[];return!fs[_0x9ec7d8('0x9')](path['join'](_0x25fdad,_0x3a0af0))&&_0x1f42f4&&fs[_0x9ec7d8('0x1e')](path[_0x9ec7d8('0x8')](_0x25fdad,_0x3a0af0)),Promise[_0x9ec7d8('0xa')](_0x5ec3e3,function(_0x4febd5){const _0xd10b08=_0x9ec7d8;_0x3dd2a5[_0xd10b08('0x24')](_0x4febd5);})['then'](function(){const _0x14edde=_0x9ec7d8;for(let _0x116c82=0x0;_0x116c82<_0x3dd2a5[_0x14edde('0x14')];_0x116c82+=0x1){let _0x2a6ad8;const _0x4d9848=_0x3dd2a5[_0x116c82];_0x1f42f4?_0x2a6ad8=path[_0x14edde('0x8')](_0x25fdad,_0x3a0af0,util[_0x14edde('0x19')](_0x14edde('0x23'),_0x3a0af0,_0x116c82,_0x14edde('0x4'))):_0x2a6ad8=path[_0x14edde('0x8')](_0x25fdad,util[_0x14edde('0x19')](_0x14edde('0x3'),_0x3a0af0,_0x14edde('0x4'))),fs['writeFileSync'](_0x2a6ad8,csv(_0x4d9848));}})['then'](function(){const _0x403efe=_0x9ec7d8;_0x1f42f4&&(zipdir(path[_0x403efe('0x8')](_0x25fdad,_0x3a0af0),{'saveTo':path[_0x403efe('0x8')](_0x25fdad,util[_0x403efe('0x19')](_0x403efe('0x3'),_0x3a0af0,'zip'))},function(){}),rimraf(path['join'](_0x25fdad,_0x3a0af0),function(){}));})[_0x9ec7d8('0x10')](function(){const _0x36e5d5=_0x9ec7d8;return logger[_0x36e5d5('0x17')](util[_0x36e5d5('0x19')](_0x36e5d5('0x1d'),EXTRACTED_REPORT_ID,_0x36e5d5('0x1b'))),analyticExtractedReport('Completed',_0x1f42f4?util['format'](_0x36e5d5('0x3'),_0x3a0af0,_0x1f42f4?_0x36e5d5('0x5'):_0x36e5d5('0x4')):null);});})[_0x46fc66('0xb')](function(_0x4ef8ca){const _0x1d1eeb=_0x46fc66;return logger[_0x1d1eeb('0x17')](util[_0x1d1eeb('0x19')](_0x1d1eeb('0x1'),EXTRACTED_REPORT_ID,_0x1d1eeb('0x1b')),util['inspect'](_0x4ef8ca,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x1d1eeb('0x27'));});}main();