server/components/export/csv.js

   1 const a826_0x1b2e=['.csv','catch','zip','AnalyticExtractedReport','zip-dir','splitSizeCsv','Setting','rimraf','length','csv','query','dirname','sequelize','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','info','argv','existsSync','each','num','SELECT','push','analytics','inspect','update','format','join','util','%s%d.%s','split','%s.%s','../../mysqldb','then','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','path','savename','CSV','Completed'];(function(_0xff7414,_0x1b2e5a){const _0x704c74=function(_0x13b161){while(--_0x13b161){_0xff7414['push'](_0xff7414['shift']());}};_0x704c74(++_0x1b2e5a);}(a826_0x1b2e,0x15d));const a826_0x704c=function(_0xff7414,_0x1b2e5a){_0xff7414=_0xff7414-0x0;let _0x704c74=a826_0x1b2e[_0xff7414];return _0x704c74;};const _0x2e62ab=a826_0x704c;'use strict';const util=require(_0x2e62ab('0x14')),path=require(_0x2e62ab('0x1b')),csv=require('to-csv'),fs=require('fs'),zipdir=require(_0x2e62ab('0x23')),rimraf=require(_0x2e62ab('0x0')),db=require('../../mysqldb')['db'],dbH=require(_0x2e62ab('0x18'))['dbH'],logger=require('../../config/logger')(_0x2e62ab('0xf')),EXTRACTED_REPORT_ID=Number(process[_0x2e62ab('0x9')][0x2]),QUERY=process['argv'][0x3],PATH=process[_0x2e62ab('0x9')][0x4];function analyticExtractedReport(_0x13b161,_0x1e615c){const _0x53c520=_0x2e62ab,_0x4f31ee={'status':_0x13b161},_0x34ab04={'where':{'id':EXTRACTED_REPORT_ID}};return _0x1e615c&&(_0x4f31ee[_0x53c520('0x1c')]=_0x1e615c),db[_0x53c520('0x22')][_0x53c520('0x11')](_0x4f31ee,_0x34ab04);}function main(){const _0x5629ba=_0x2e62ab;let _0x83d056=0x1388,_0x259b5c;return logger['info'](util[_0x5629ba('0x12')](_0x5629ba('0x1a'),EXTRACTED_REPORT_ID,_0x5629ba('0x1d'))),db[_0x5629ba('0x25')]['findOne']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x5629ba('0x16'),_0x5629ba('0x24')]})[_0x5629ba('0x19')](function(_0x4fa163){const _0x2e5a0d=_0x5629ba;_0x4fa163&&(_0x259b5c=_0x4fa163,_0x83d056=_0x259b5c[_0x2e5a0d('0x24')]||0x1388);})[_0x5629ba('0x19')](function(){const _0x52c63e=_0x5629ba;return dbH['sequelize'][_0x52c63e('0x3')](util['format'](_0x52c63e('0x6'),QUERY),{'type':dbH[_0x52c63e('0x5')][_0x52c63e('0x7')]['SELECT']});})[_0x5629ba('0x19')](function(_0x118a42){const _0x453b20=_0x5629ba;if(!_0x118a42[0x0][_0x453b20('0xc')])return analyticExtractedReport('Empty');const _0x958b78=[];let _0x19b4ec=0x0,_0x184d85=!![];if(_0x118a42&&_0x118a42[_0x453b20('0x1')]){let _0x3a32ae=_0x118a42[0x0][_0x453b20('0xc')]%(_0x19b4ec+_0x83d056);if(_0x259b5c[_0x453b20('0x16')])for(;_0x184d85;_0x19b4ec+=_0x83d056,_0x3a32ae=_0x118a42[0x0][_0x453b20('0xc')]%(_0x19b4ec+_0x83d056)){(_0x3a32ae==0x0||_0x3a32ae==_0x118a42[0x0][_0x453b20('0xc')])&&(_0x184d85=![]),_0x958b78['push'](dbH[_0x453b20('0x5')]['query'](util[_0x453b20('0x12')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x83d056,_0x19b4ec),{'type':dbH[_0x453b20('0x5')]['QueryTypes'][_0x453b20('0xd')]}));}else _0x958b78[_0x453b20('0xe')](dbH[_0x453b20('0x5')][_0x453b20('0x3')](QUERY,{'type':dbH[_0x453b20('0x5')][_0x453b20('0x7')][_0x453b20('0xd')]}));}const _0x28dde6=path[_0x453b20('0x4')](PATH),_0x56b34e=path['basename'](PATH,_0x453b20('0x1f')),_0x50cef8=_0x259b5c[_0x453b20('0x16')]&&_0x958b78[_0x453b20('0x1')]>0x1,_0x46bced=[];return!fs[_0x453b20('0xa')](path[_0x453b20('0x13')](_0x28dde6,_0x56b34e))&&_0x50cef8&&fs['mkdirSync'](path['join'](_0x28dde6,_0x56b34e)),Promise[_0x453b20('0xb')](_0x958b78,function(_0x4cf8c6){const _0x4cf2f4=_0x453b20;_0x46bced[_0x4cf2f4('0xe')](_0x4cf8c6);})['then'](function(){const _0x3032d9=_0x453b20;for(let _0x381eb9=0x0;_0x381eb9<_0x46bced['length'];_0x381eb9+=0x1){let _0x5abab1;const _0x108e9a=_0x46bced[_0x381eb9];_0x50cef8?_0x5abab1=path[_0x3032d9('0x13')](_0x28dde6,_0x56b34e,util[_0x3032d9('0x12')](_0x3032d9('0x15'),_0x56b34e,_0x381eb9,'csv')):_0x5abab1=path[_0x3032d9('0x13')](_0x28dde6,util['format'](_0x3032d9('0x17'),_0x56b34e,_0x3032d9('0x2'))),fs['writeFileSync'](_0x5abab1,csv(_0x108e9a));}})[_0x453b20('0x19')](function(){const _0x5d7f04=_0x453b20;_0x50cef8&&(zipdir(path['join'](_0x28dde6,_0x56b34e),{'saveTo':path['join'](_0x28dde6,util[_0x5d7f04('0x12')](_0x5d7f04('0x17'),_0x56b34e,_0x5d7f04('0x21')))},function(){}),rimraf(path[_0x5d7f04('0x13')](_0x28dde6,_0x56b34e),function(){}));})[_0x453b20('0x19')](function(){const _0x22b73c=_0x453b20;return logger[_0x22b73c('0x8')](util[_0x22b73c('0x12')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x22b73c('0x1d'))),analyticExtractedReport(_0x22b73c('0x1e'),_0x50cef8?util[_0x22b73c('0x12')](_0x22b73c('0x17'),_0x56b34e,_0x50cef8?_0x22b73c('0x21'):_0x22b73c('0x2')):null);});})[_0x5629ba('0x20')](function(_0x5a2797){const _0x21104b=_0x5629ba;return logger[_0x21104b('0x8')](util[_0x21104b('0x12')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'CSV'),util[_0x21104b('0x10')](_0x5a2797,{'showHidden':![],'depth':null})),analyticExtractedReport('Failed');});}main();