-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();
\ No newline at end of file
+const a827_0x8d1a=['info','MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a','name','dbH','/fonts/Roboto-Medium.ttf','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','%s%d.%s','.pdf','join','/fonts/Roboto-Regular.ttf','CSV','%s.%s','util','../../mysqldb','Setting','landscape','err','../../config/logger','zip','zip-dir','splitSizePdf','toString','createWriteStream','query','savename','tableHeader','existsSync','update','dirname','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','basename','format','findOne','split','mkdirSync','Empty','SELECT','%s\x20limit\x20%d\x20OFFSET\x20%d','log','/fonts/Roboto-MediumItalic.ttf','error','finish','each','num','argv','length','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','undefined','push','rimraf','QueryTypes','path','sequelize','then','end','pdf','black','body','inspect','/fonts/Roboto-Italic.ttf','PDF','AnalyticExtractedReport','lodash','startDate'];(function(_0x5dfda5,_0x8d1adf){const _0x241130=function(_0x37448b){while(--_0x37448b){_0x5dfda5['push'](_0x5dfda5['shift']());}};_0x241130(++_0x8d1adf);}(a827_0x8d1a,0x1a0));const a827_0x2411=function(_0x5dfda5,_0x8d1adf){_0x5dfda5=_0x5dfda5-0x0;let _0x241130=a827_0x8d1a[_0x5dfda5];return _0x241130;};const _0x3cdcff=a827_0x2411;'use strict';const _=require(_0x3cdcff('0x25')),fs=require('fs'),util=require(_0x3cdcff('0x33')),path=require(_0x3cdcff('0x1a')),moment=require('moment'),PdfPrinter=require('pdfmake/src/printer'),zipdir=require(_0x3cdcff('0x3a')),rimraf=require(_0x3cdcff('0x18')),db=require('../../mysqldb')['db'],dbH=require(_0x3cdcff('0x34'))[_0x3cdcff('0x2a')],logger=require(_0x3cdcff('0x38'))('analytics'),EXTRACTED_REPORT_ID=Number(process[_0x3cdcff('0x13')][0x2]),QUERY=process[_0x3cdcff('0x13')][0x3],PATH=process[_0x3cdcff('0x13')][0x4],NAME=process[_0x3cdcff('0x13')][0x5],FORMAT=_0x3cdcff('0x28');let _extractedReport;function analyticExtractedReport(_0x37448b,_0x28bc88){const _0x50d9a3=_0x3cdcff,_0x110422={'status':_0x37448b},_0x54a856={'where':{'id':EXTRACTED_REPORT_ID}};return _0x28bc88&&(_0x110422[_0x50d9a3('0x3f')]=_0x28bc88),db[_0x50d9a3('0x24')][_0x50d9a3('0x1')](_0x110422,_0x54a856);}function getHeader(_0x175ef9){const _0x241996=_0x3cdcff,_0x451b4a=[];for(const _0x356752 in _0x175ef9){typeof _0x175ef9[_0x356752]!==_0x241996('0x16')&&_0x451b4a[_0x241996('0x17')]({'text':_0x356752,'style':_0x241996('0x40')});}return _0x451b4a;}function extractReport(_0x369a4e){const _0x3380de=_0x3cdcff;let _0x750e18=0x1388,_0x22ad4e;if(!_0x369a4e[0x0][_0x3380de('0x12')])return analyticExtractedReport(_0x3380de('0xa'));const _0x5ae79c=[];let _0x2baa64=0x0,_0x42c0dd=!![];const _0x3890c5=path[_0x3380de('0x2')](PATH),_0x46c946=path[_0x3380de('0x5')](PATH,_0x3380de('0x2e'));let _0x3ae96c=![];const _0x5126dd=[];return db[_0x3380de('0x35')][_0x3380de('0x7')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x3380de('0x8'),_0x3380de('0x3b')]})['then'](function(_0x93ab4a){_0x93ab4a&&(_0x22ad4e=_0x93ab4a,_0x750e18=_0x22ad4e['splitSizePdf']||0x3e8);})[_0x3380de('0x1c')](function(){const _0x4a618f=_0x3380de;if(_0x369a4e&&_0x369a4e[_0x4a618f('0x14')]){let _0x39eb02=_0x369a4e[0x0][_0x4a618f('0x12')]%(_0x2baa64+_0x750e18);if(_0x22ad4e[_0x4a618f('0x8')])for(;_0x42c0dd;_0x2baa64+=_0x750e18,_0x39eb02=_0x369a4e[0x0][_0x4a618f('0x12')]%(_0x2baa64+_0x750e18)){(_0x39eb02==0x0||_0x39eb02==_0x369a4e[0x0]['num'])&&(_0x42c0dd=![]),_0x5ae79c[_0x4a618f('0x17')](dbH[_0x4a618f('0x1b')][_0x4a618f('0x3e')](util[_0x4a618f('0x6')](_0x4a618f('0xc'),QUERY,_0x750e18,_0x2baa64),{'type':dbH[_0x4a618f('0x1b')][_0x4a618f('0x19')][_0x4a618f('0xb')]}));}else _0x5ae79c['push'](dbH[_0x4a618f('0x1b')][_0x4a618f('0x3e')](QUERY,{'type':dbH['sequelize'][_0x4a618f('0x19')][_0x4a618f('0xb')]}));}return _0x3ae96c=_0x22ad4e[_0x4a618f('0x8')]&&_0x5ae79c[_0x4a618f('0x14')]>0x1,!fs[_0x4a618f('0x0')](path[_0x4a618f('0x2f')](_0x3890c5,_0x46c946))&&_0x3ae96c&&fs[_0x4a618f('0x9')](path[_0x4a618f('0x2f')](_0x3890c5,_0x46c946)),Promise[_0x4a618f('0x11')](_0x5ae79c,function(_0x258cd1){const _0x56692c=_0x4a618f;_0x5126dd[_0x56692c('0x17')](_0x258cd1);});})[_0x3380de('0x1c')](function(){return Promise['each'](_0x5ae79c,function(_0x13386a,_0x53e52f){const _0x28dc11=a827_0x2411;let _0x3a7199;const _0x27a03f=util['format']('Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s',NAME,_extractedReport[_0x28dc11('0x29')],moment(_extractedReport[_0x28dc11('0x26')])[_0x28dc11('0x6')](FORMAT),moment(_extractedReport['endDate'])[_0x28dc11('0x6')](FORMAT)),_0x281a48={'pageSize':'A4','pageOrientation':_0x28dc11('0x36'),'content':[{'text':_0x27a03f,'style':'header'}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0x28dc11('0x1f')}}},_0x1f13e6={'headerRows':0x1,'body':[]};_0x1f13e6[_0x28dc11('0x20')][_0x28dc11('0x17')](getHeader(_0x13386a[0x0]));let _0x82768f;for(let _0x560d87=0x0;_0x560d87<_0x13386a[_0x28dc11('0x14')];_0x560d87+=0x1){_0x82768f=[];for(const _0x26ffa9 in _0x13386a[_0x560d87]){typeof _0x13386a[_0x560d87][_0x26ffa9]!==_0x28dc11('0x16')&&_0x82768f[_0x28dc11('0x17')](_0x13386a[_0x560d87][_0x26ffa9]?_[_0x28dc11('0x3c')](_0x13386a[_0x560d87][_0x26ffa9]):'');}_0x1f13e6[_0x28dc11('0x20')][_0x28dc11('0x17')](_0x82768f);}return _0x281a48['content']['push']({'table':_0x1f13e6}),new Promise(function(_0x1657cb,_0xcb9d67){const _0x542daa=_0x28dc11,_0x43d5b5=new PdfPrinter({'Roboto':{'normal':__dirname+_0x542daa('0x30'),'bold':__dirname+_0x542daa('0x2b'),'italics':__dirname+_0x542daa('0x22'),'bolditalics':__dirname+_0x542daa('0xe')}}),_0x1d2efb=_0x43d5b5['createPdfKitDocument'](_0x281a48);_0x3ae96c?_0x3a7199=path[_0x542daa('0x2f')](_0x3890c5,_0x46c946,util[_0x542daa('0x6')](_0x542daa('0x2d'),_0x46c946,_0x53e52f,_0x542daa('0x1e'))):_0x3a7199=path[_0x542daa('0x2f')](_0x3890c5,util[_0x542daa('0x6')](_0x542daa('0x32'),_0x46c946,_0x542daa('0x1e')));const _0x436ca0=_0x1d2efb['pipe'](fs[_0x542daa('0x3d')](_0x3a7199));_0x436ca0['on'](_0x542daa('0x10'),function(){_0x1657cb();}),_0x436ca0['on'](_0x542daa('0xf'),function(_0x2a6ee0){const _0x126235=_0x542daa;console[_0x126235('0xd')](_0x126235('0x37'),_0x2a6ee0),_0xcb9d67(_0x2a6ee0);}),_0x1d2efb[_0x542daa('0x1d')]();});});})[_0x3380de('0x1c')](function(){if(_0x3ae96c)return new Promise(function(_0x1bada0,_0x5306bf){const _0x39e8cb=a827_0x2411;zipdir(path[_0x39e8cb('0x2f')](_0x3890c5,_0x46c946),{'saveTo':path['join'](_0x3890c5,util[_0x39e8cb('0x6')](_0x39e8cb('0x32'),_0x46c946,_0x39e8cb('0x39')))},function(_0x170a5d){_0x170a5d?_0x5306bf(_0x170a5d):_0x1bada0();});});})[_0x3380de('0x1c')](function(){const _0xbaaa6b=_0x3380de;_0x3ae96c&&rimraf(path[_0xbaaa6b('0x2f')](_0x3890c5,_0x46c946),function(){});})[_0x3380de('0x1c')](function(){const _0x18476f=_0x3380de;return logger[_0x18476f('0x27')](util[_0x18476f('0x6')](_0x18476f('0x2c'),EXTRACTED_REPORT_ID,_0x18476f('0x31'))),analyticExtractedReport('Completed',_0x3ae96c?util[_0x18476f('0x6')](_0x18476f('0x32'),_0x46c946,_0x3ae96c?'zip':_0x18476f('0x1e')):null);});}function main(){const _0x4f622e=_0x3cdcff;return logger[_0x4f622e('0x27')](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x4f622e('0x23'))),db[_0x4f622e('0x24')][_0x4f622e('0x7')]({'where':{'id':EXTRACTED_REPORT_ID}})[_0x4f622e('0x1c')](function(_0x3b2a6d){const _0x449e14=_0x4f622e;return _extractedReport=_0x3b2a6d,dbH[_0x449e14('0x1b')][_0x449e14('0x3e')](util[_0x449e14('0x6')](_0x449e14('0x15'),QUERY),{'type':dbH[_0x449e14('0x1b')][_0x449e14('0x19')]['SELECT']});})[_0x4f622e('0x1c')](extractReport)['catch'](function(_0x16c35a){const _0x46e929=_0x4f622e;return logger[_0x46e929('0x27')](util[_0x46e929('0x6')](_0x46e929('0x3'),EXTRACTED_REPORT_ID,_0x46e929('0x23')),util[_0x46e929('0x21')](_0x16c35a,{'showHidden':![],'depth':null})),analyticExtractedReport(_0x46e929('0x4'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff