server/components/export/pdf.js

   1 const a827_0x3073=['num','info','createPdfKitDocument','header','query','update','join','%s%d.%s','argv','rimraf','body','AnalyticExtractedReport','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','Setting','zip-dir','pdf','name','Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s','split','Empty','zip','finish','QueryTypes','path','startDate','sequelize','createWriteStream','pdfmake/src/printer','SELECT','content','each','moment','basename','../../mysqldb','tableHeader','splitSizePdf','.pdf','push','length','util','mkdirSync','then','/fonts/Roboto-Medium.ttf','existsSync','findOne','%s.%s','PDF','endDate','error','dbH','analytics','toString','%s\x20limit\x20%d\x20OFFSET\x20%d','savename','end','format','undefined','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','lodash','pipe','landscape','err','dirname'];(function(_0x303036,_0x3073ce){const _0x7bdf=function(_0x39c300){while(--_0x39c300){_0x303036['push'](_0x303036['shift']());}};_0x7bdf(++_0x3073ce);}(a827_0x3073,0x64));const a827_0x7bdf=function(_0x303036,_0x3073ce){_0x303036=_0x303036-0x0;let _0x7bdf=a827_0x3073[_0x303036];return _0x7bdf;};const _0x1293c0=a827_0x7bdf;'use strict';const _=require(_0x1293c0('0x15')),fs=require('fs'),util=require(_0x1293c0('0x2')),path=require(_0x1293c0('0x31')),moment=require(_0x1293c0('0x39')),PdfPrinter=require(_0x1293c0('0x35')),zipdir=require(_0x1293c0('0x28')),rimraf=require(_0x1293c0('0x23')),db=require('../../mysqldb')['db'],dbH=require(_0x1293c0('0x3b'))[_0x1293c0('0xc')],logger=require('../../config/logger')(_0x1293c0('0xd')),EXTRACTED_REPORT_ID=Number(process[_0x1293c0('0x22')][0x2]),QUERY=process[_0x1293c0('0x22')][0x3],PATH=process[_0x1293c0('0x22')][0x4],NAME=process[_0x1293c0('0x22')][0x5],FORMAT='MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a';let _extractedReport;function analyticExtractedReport(_0x39c300,_0x4e28c7){const _0x3138b7=_0x1293c0,_0x4e448d={'status':_0x39c300},_0xc6c2fa={'where':{'id':EXTRACTED_REPORT_ID}};return _0x4e28c7&&(_0x4e448d[_0x3138b7('0x10')]=_0x4e28c7),db[_0x3138b7('0x25')][_0x3138b7('0x1f')](_0x4e448d,_0xc6c2fa);}function getHeader(_0x336e07){const _0x132e47=_0x1293c0,_0x2e1656=[];for(const _0x55ac3b in _0x336e07){typeof _0x336e07[_0x55ac3b]!==_0x132e47('0x13')&&_0x2e1656[_0x132e47('0x0')]({'text':_0x55ac3b,'style':_0x132e47('0x3c')});}return _0x2e1656;}function extractReport(_0x3b4967){const _0x4d574e=_0x1293c0;let _0x4dd4a9=0x1388,_0x2a7131;if(!_0x3b4967[0x0][_0x4d574e('0x1a')])return analyticExtractedReport(_0x4d574e('0x2d'));const _0x23a00=[];let _0x4a4498=0x0,_0x13f08f=!![];const _0x50b826=path[_0x4d574e('0x19')](PATH),_0x3dd6c5=path[_0x4d574e('0x3a')](PATH,_0x4d574e('0x3e'));let _0x248dc5=![];const _0x3d51cf=[];return db[_0x4d574e('0x27')][_0x4d574e('0x7')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x4d574e('0x2c'),_0x4d574e('0x3d')]})['then'](function(_0x1d0d72){const _0x526642=_0x4d574e;_0x1d0d72&&(_0x2a7131=_0x1d0d72,_0x4dd4a9=_0x2a7131[_0x526642('0x3d')]||0x3e8);})['then'](function(){const _0x26e7c7=_0x4d574e;if(_0x3b4967&&_0x3b4967[_0x26e7c7('0x1')]){let _0xb02c30=_0x3b4967[0x0]['num']%(_0x4a4498+_0x4dd4a9);if(_0x2a7131[_0x26e7c7('0x2c')])for(;_0x13f08f;_0x4a4498+=_0x4dd4a9,_0xb02c30=_0x3b4967[0x0][_0x26e7c7('0x1a')]%(_0x4a4498+_0x4dd4a9)){(_0xb02c30==0x0||_0xb02c30==_0x3b4967[0x0][_0x26e7c7('0x1a')])&&(_0x13f08f=![]),_0x23a00[_0x26e7c7('0x0')](dbH[_0x26e7c7('0x33')]['query'](util[_0x26e7c7('0x12')](_0x26e7c7('0xf'),QUERY,_0x4dd4a9,_0x4a4498),{'type':dbH['sequelize']['QueryTypes'][_0x26e7c7('0x36')]}));}else _0x23a00[_0x26e7c7('0x0')](dbH[_0x26e7c7('0x33')][_0x26e7c7('0x1e')](QUERY,{'type':dbH[_0x26e7c7('0x33')]['QueryTypes'][_0x26e7c7('0x36')]}));}return _0x248dc5=_0x2a7131['split']&&_0x23a00[_0x26e7c7('0x1')]>0x1,!fs[_0x26e7c7('0x6')](path['join'](_0x50b826,_0x3dd6c5))&&_0x248dc5&&fs[_0x26e7c7('0x3')](path[_0x26e7c7('0x20')](_0x50b826,_0x3dd6c5)),Promise[_0x26e7c7('0x38')](_0x23a00,function(_0x35fcb7){const _0x2c6c8d=_0x26e7c7;_0x3d51cf[_0x2c6c8d('0x0')](_0x35fcb7);});})['then'](function(){const _0x13fa55=_0x4d574e;return Promise[_0x13fa55('0x38')](_0x23a00,function(_0x234d18,_0x443e03){const _0x3c77e4=_0x13fa55;let _0x11374b;const _0x2b4b92=util[_0x3c77e4('0x12')](_0x3c77e4('0x2b'),NAME,_extractedReport[_0x3c77e4('0x2a')],moment(_extractedReport[_0x3c77e4('0x32')])['format'](FORMAT),moment(_extractedReport[_0x3c77e4('0xa')])[_0x3c77e4('0x12')](FORMAT)),_0x5e86a7={'pageSize':'A4','pageOrientation':_0x3c77e4('0x17'),'content':[{'text':_0x2b4b92,'style':_0x3c77e4('0x1d')}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':'black'}}},_0x23db04={'headerRows':0x1,'body':[]};_0x23db04[_0x3c77e4('0x24')][_0x3c77e4('0x0')](getHeader(_0x234d18[0x0]));let _0x39d98f;for(let _0x39a216=0x0;_0x39a216<_0x234d18[_0x3c77e4('0x1')];_0x39a216+=0x1){_0x39d98f=[];for(const _0x11d741 in _0x234d18[_0x39a216]){typeof _0x234d18[_0x39a216][_0x11d741]!=='undefined'&&_0x39d98f['push'](_0x234d18[_0x39a216][_0x11d741]?_[_0x3c77e4('0xe')](_0x234d18[_0x39a216][_0x11d741]):'');}_0x23db04['body'][_0x3c77e4('0x0')](_0x39d98f);}return _0x5e86a7[_0x3c77e4('0x37')][_0x3c77e4('0x0')]({'table':_0x23db04}),new Promise(function(_0x3a4998,_0x38fc70){const _0x4b2e1d=_0x3c77e4,_0x17f1fd=new PdfPrinter({'Roboto':{'normal':__dirname+'/fonts/Roboto-Regular.ttf','bold':__dirname+_0x4b2e1d('0x5'),'italics':__dirname+'/fonts/Roboto-Italic.ttf','bolditalics':__dirname+'/fonts/Roboto-MediumItalic.ttf'}}),_0x475094=_0x17f1fd[_0x4b2e1d('0x1c')](_0x5e86a7);_0x248dc5?_0x11374b=path[_0x4b2e1d('0x20')](_0x50b826,_0x3dd6c5,util[_0x4b2e1d('0x12')](_0x4b2e1d('0x21'),_0x3dd6c5,_0x443e03,_0x4b2e1d('0x29'))):_0x11374b=path[_0x4b2e1d('0x20')](_0x50b826,util[_0x4b2e1d('0x12')](_0x4b2e1d('0x8'),_0x3dd6c5,'pdf'));const _0x4d1522=_0x475094[_0x4b2e1d('0x16')](fs[_0x4b2e1d('0x34')](_0x11374b));_0x4d1522['on'](_0x4b2e1d('0x2f'),function(){_0x3a4998();}),_0x4d1522['on'](_0x4b2e1d('0xb'),function(_0x36bab5){const _0x34e29d=_0x4b2e1d;console['log'](_0x34e29d('0x18'),_0x36bab5),_0x38fc70(_0x36bab5);}),_0x475094[_0x4b2e1d('0x11')]();});});})[_0x4d574e('0x4')](function(){if(_0x248dc5)return new Promise(function(_0x105193,_0x44ad4f){const _0x540a74=a827_0x7bdf;zipdir(path[_0x540a74('0x20')](_0x50b826,_0x3dd6c5),{'saveTo':path[_0x540a74('0x20')](_0x50b826,util['format'](_0x540a74('0x8'),_0x3dd6c5,_0x540a74('0x2e')))},function(_0x90c865){_0x90c865?_0x44ad4f(_0x90c865):_0x105193();});});})['then'](function(){_0x248dc5&&rimraf(path['join'](_0x50b826,_0x3dd6c5),function(){});})[_0x4d574e('0x4')](function(){const _0x5882df=_0x4d574e;return logger[_0x5882df('0x1b')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,'CSV')),analyticExtractedReport('Completed',_0x248dc5?util[_0x5882df('0x12')](_0x5882df('0x8'),_0x3dd6c5,_0x248dc5?_0x5882df('0x2e'):'pdf'):null);});}function main(){const _0x2e53e1=_0x1293c0;return logger[_0x2e53e1('0x1b')](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x2e53e1('0x9'))),db[_0x2e53e1('0x25')]['findOne']({'where':{'id':EXTRACTED_REPORT_ID}})[_0x2e53e1('0x4')](function(_0x1e5fed){const _0x341d4b=_0x2e53e1;return _extractedReport=_0x1e5fed,dbH[_0x341d4b('0x33')][_0x341d4b('0x1e')](util[_0x341d4b('0x12')](_0x341d4b('0x26'),QUERY),{'type':dbH[_0x341d4b('0x33')][_0x341d4b('0x30')][_0x341d4b('0x36')]});})['then'](extractReport)['catch'](function(_0x157e6c){const _0x3f6fdc=_0x2e53e1;return logger['info'](util[_0x3f6fdc('0x12')](_0x3f6fdc('0x14'),EXTRACTED_REPORT_ID,_0x3f6fdc('0x9')),util['inspect'](_0x157e6c,{'showHidden':![],'depth':null})),analyticExtractedReport('Failed');});}main();