// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd8b0=['format','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','existsSync','join','mkdirSync','each','Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s','name','endDate','landscape','black','body','toString','/fonts/Roboto-Medium.ttf','/fonts/Roboto-Italic.ttf','/fonts/Roboto-MediumItalic.ttf','createPdfKitDocument','%s%d.%s','pdf','pipe','finish','error','log','err','%s.%s','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','PDF','findOne','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','lodash','bluebird','pdfmake/src/printer','zip-dir','rimraf','../../mysqldb','analytics','argv','MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a','savename','AnalyticExtractedReport','update','hasOwnProperty','tableHeader','num','Empty','dirname','basename','.pdf','Setting','find','split','splitSizePdf','then','length','push','sequelize','query'];(function(_0x617658,_0xacbbc9){var _0x4ce445=function(_0x593a65){while(--_0x593a65){_0x617658['push'](_0x617658['shift']());}};_0x4ce445(++_0xacbbc9);}(_0xd8b0,0xad));var _0x0d8b=function(_0xa464c9,_0x7c86d8){_0xa464c9=_0xa464c9-0x0;var _0x3d73c4=_0xd8b0[_0xa464c9];return _0x3d73c4;};'use strict';var _=require(_0x0d8b('0x0'));var fs=require('fs');var BPromise=require(_0x0d8b('0x1'));var util=require('util');var path=require('path');var moment=require('moment');var PdfPrinter=require(_0x0d8b('0x2'));var zipdir=require(_0x0d8b('0x3'));var rimraf=require(_0x0d8b('0x4'));var db=require(_0x0d8b('0x5'))['db'];var dbH=require(_0x0d8b('0x5'))['dbH'];var logger=require('../../config/logger')(_0x0d8b('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x0d8b('0x7')][0x2]);var QUERY=process[_0x0d8b('0x7')][0x3];var PATH=process['argv'][0x4];var NAME=process[_0x0d8b('0x7')][0x5];var FORMAT=_0x0d8b('0x8');var _extractedReport;function analyticExtractedReport(_0x58e4e2,_0x129310){var _0x348e65={'status':_0x58e4e2};var _0x3b027f={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x129310){_0x348e65[_0x0d8b('0x9')]=_0x129310;}return db[_0x0d8b('0xa')][_0x0d8b('0xb')](_0x348e65,_0x3b027f);}function getHeader(_0x2c5e9e){var _0x28f87c=[];for(var _0x48fa16 in _0x2c5e9e){if(_0x2c5e9e[_0x0d8b('0xc')](_0x48fa16)){_0x28f87c['push']({'text':_0x48fa16,'style':_0x0d8b('0xd')});}}return _0x28f87c;}function extractReport(_0xc574a3){var _0x340cc4=0x1388;var _0x92cdd8;if(!_0xc574a3[0x0][_0x0d8b('0xe')]){return analyticExtractedReport(_0x0d8b('0xf'));}var _0x15dd0f=[];var _0x31a8cc=0x0;var _0x1d4bbc=!![];var _0x2ce75e=path[_0x0d8b('0x10')](PATH);var _0xe65334=path[_0x0d8b('0x11')](PATH,_0x0d8b('0x12'));var _0x4f6f21=![];var _0x23eb7b=[];return db[_0x0d8b('0x13')][_0x0d8b('0x14')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x0d8b('0x15'),_0x0d8b('0x16')]})['then'](function(_0x106a01){if(_0x106a01){_0x92cdd8=_0x106a01;_0x340cc4=_0x92cdd8[_0x0d8b('0x16')]||0x3e8;}})[_0x0d8b('0x17')](function(){if(_0xc574a3&&_0xc574a3[_0x0d8b('0x18')]){var _0x333674=_0xc574a3[0x0][_0x0d8b('0xe')]%(_0x31a8cc+_0x340cc4);if(_0x92cdd8[_0x0d8b('0x15')]){for(;_0x1d4bbc;_0x31a8cc+=_0x340cc4,_0x333674=_0xc574a3[0x0][_0x0d8b('0xe')]%(_0x31a8cc+_0x340cc4)){if(_0x333674==0x0||_0x333674==_0xc574a3[0x0]['num']){_0x1d4bbc=![];}_0x15dd0f[_0x0d8b('0x19')](dbH[_0x0d8b('0x1a')][_0x0d8b('0x1b')](util[_0x0d8b('0x1c')](_0x0d8b('0x1d'),QUERY,_0x340cc4,_0x31a8cc),{'type':dbH[_0x0d8b('0x1a')][_0x0d8b('0x1e')][_0x0d8b('0x1f')]}));}}else{_0x15dd0f['push'](dbH['sequelize'][_0x0d8b('0x1b')](QUERY,{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}}_0x4f6f21=_0x92cdd8[_0x0d8b('0x15')]&&_0x15dd0f[_0x0d8b('0x18')]>0x1;if(!fs[_0x0d8b('0x20')](path[_0x0d8b('0x21')](_0x2ce75e,_0xe65334))&&_0x4f6f21){fs[_0x0d8b('0x22')](path[_0x0d8b('0x21')](_0x2ce75e,_0xe65334));}return BPromise[_0x0d8b('0x23')](_0x15dd0f,function(_0x4562cb){_0x23eb7b[_0x0d8b('0x19')](_0x4562cb);});})['then'](function(){return BPromise[_0x0d8b('0x23')](_0x15dd0f,function(_0x4463ee,_0x5363e3){var _0xe1ef20;var _0x4a0ae4=util[_0x0d8b('0x1c')](_0x0d8b('0x24'),NAME,_extractedReport[_0x0d8b('0x25')],moment(_extractedReport['startDate'])['format'](FORMAT),moment(_extractedReport[_0x0d8b('0x26')])[_0x0d8b('0x1c')](FORMAT));var _0x4c05ee={'pageSize':'A4','pageOrientation':_0x0d8b('0x27'),'content':[{'text':_0x4a0ae4,'style':'header'}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0x0d8b('0x28')}}};var _0x4b59e5={'headerRows':0x1,'body':[]};_0x4b59e5[_0x0d8b('0x29')]['push'](getHeader(_0x4463ee[0x0]));var _0x2ab00d;for(var _0x546bf6=0x0;_0x546bf6<_0x4463ee[_0x0d8b('0x18')];_0x546bf6+=0x1){_0x2ab00d=[];for(var _0x544735 in _0x4463ee[_0x546bf6]){if(_0x4463ee[_0x546bf6][_0x0d8b('0xc')](_0x544735)){_0x2ab00d[_0x0d8b('0x19')](_0x4463ee[_0x546bf6][_0x544735]?_[_0x0d8b('0x2a')](_0x4463ee[_0x546bf6][_0x544735]):'');}}_0x4b59e5['body']['push'](_0x2ab00d);}_0x4c05ee['content'][_0x0d8b('0x19')]({'table':_0x4b59e5});return new BPromise(function(_0x5515d2,_0x3cdf3c){var _0x54f6f3=new PdfPrinter({'Roboto':{'normal':__dirname+'/fonts/Roboto-Regular.ttf','bold':__dirname+_0x0d8b('0x2b'),'italics':__dirname+_0x0d8b('0x2c'),'bolditalics':__dirname+_0x0d8b('0x2d')}});var _0xdeee5d=_0x54f6f3[_0x0d8b('0x2e')](_0x4c05ee);if(_0x4f6f21){_0xe1ef20=path[_0x0d8b('0x21')](_0x2ce75e,_0xe65334,util[_0x0d8b('0x1c')](_0x0d8b('0x2f'),_0xe65334,_0x5363e3,'pdf'));}else{_0xe1ef20=path[_0x0d8b('0x21')](_0x2ce75e,util[_0x0d8b('0x1c')]('%s.%s',_0xe65334,_0x0d8b('0x30')));}var _0x23f7f6=_0xdeee5d[_0x0d8b('0x31')](fs['createWriteStream'](_0xe1ef20));_0x23f7f6['on'](_0x0d8b('0x32'),function(){_0x5515d2();});_0x23f7f6['on'](_0x0d8b('0x33'),function(_0x206157){console[_0x0d8b('0x34')](_0x0d8b('0x35'),_0x206157);_0x3cdf3c(_0x206157);});_0xdeee5d['end']();});});})[_0x0d8b('0x17')](function(){if(_0x4f6f21){return new BPromise(function(_0x1649fc,_0x5ad0fe){zipdir(path[_0x0d8b('0x21')](_0x2ce75e,_0xe65334),{'saveTo':path[_0x0d8b('0x21')](_0x2ce75e,util[_0x0d8b('0x1c')](_0x0d8b('0x36'),_0xe65334,_0x0d8b('0x37')))},function(_0x519088){if(_0x519088){_0x5ad0fe(_0x519088);}else{_0x1649fc();}});});}})['then'](function(){if(_0x4f6f21){rimraf(path[_0x0d8b('0x21')](_0x2ce75e,_0xe65334),function(){});}})['then'](function(){logger['info'](util[_0x0d8b('0x1c')](_0x0d8b('0x38'),EXTRACTED_REPORT_ID,_0x0d8b('0x39')));return analyticExtractedReport(_0x0d8b('0x3a'),_0x4f6f21?util[_0x0d8b('0x1c')](_0x0d8b('0x36'),_0xe65334,_0x4f6f21?'zip':_0x0d8b('0x30')):null);});}function main(){logger[_0x0d8b('0x3b')](util[_0x0d8b('0x1c')](_0x0d8b('0x3c'),EXTRACTED_REPORT_ID,_0x0d8b('0x3d')));return db[_0x0d8b('0xa')][_0x0d8b('0x3e')]({'where':{'id':EXTRACTED_REPORT_ID}})['then'](function(_0x1d06b6){_extractedReport=_0x1d06b6;return dbH[_0x0d8b('0x1a')][_0x0d8b('0x1b')](util[_0x0d8b('0x1c')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x0d8b('0x1a')]['QueryTypes'][_0x0d8b('0x1f')]});})[_0x0d8b('0x17')](extractReport)[_0x0d8b('0x3f')](function(_0x26ac10){logger[_0x0d8b('0x3b')](util[_0x0d8b('0x1c')](_0x0d8b('0x40'),EXTRACTED_REPORT_ID,_0x0d8b('0x3d')),util[_0x0d8b('0x41')](_0x26ac10,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x0d8b('0x42'));});}main();
\ No newline at end of file
+var _0xeb81=['%s.%s','pipe','createWriteStream','finish','error','log','end','zip','info','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','PDF','findOne','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','bluebird','util','moment','pdfmake/src/printer','../../mysqldb','dbH','../../config/logger','analytics','argv','MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a','savename','AnalyticExtractedReport','update','hasOwnProperty','push','tableHeader','num','Empty','dirname','basename','Setting','find','split','splitSizePdf','then','length','SELECT','sequelize','query','existsSync','mkdirSync','join','each','format','Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s','name','startDate','header','black','toString','body','content','/fonts/arial-italic.ttf','/fonts/arial-bold-italic.ttf','createPdfKitDocument','%s%d.%s','pdf'];(function(_0x513491,_0x3bf1f0){var _0x1408ad=function(_0x1afcf7){while(--_0x1afcf7){_0x513491['push'](_0x513491['shift']());}};_0x1408ad(++_0x3bf1f0);}(_0xeb81,0x157));var _0x1eb8=function(_0x4ed72e,_0x3cbb92){_0x4ed72e=_0x4ed72e-0x0;var _0x16cc9a=_0xeb81[_0x4ed72e];return _0x16cc9a;};'use strict';var _=require('lodash');var fs=require('fs');var BPromise=require(_0x1eb8('0x0'));var util=require(_0x1eb8('0x1'));var path=require('path');var moment=require(_0x1eb8('0x2'));var PdfPrinter=require(_0x1eb8('0x3'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0x1eb8('0x4'))['db'];var dbH=require('../../mysqldb')[_0x1eb8('0x5')];var logger=require(_0x1eb8('0x6'))(_0x1eb8('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x1eb8('0x8')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x1eb8('0x8')][0x4];var NAME=process[_0x1eb8('0x8')][0x5];var FORMAT=_0x1eb8('0x9');var _extractedReport;function analyticExtractedReport(_0x39416c,_0x5c96bc){var _0x361468={'status':_0x39416c};var _0x2ea4c4={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5c96bc){_0x361468[_0x1eb8('0xa')]=_0x5c96bc;}return db[_0x1eb8('0xb')][_0x1eb8('0xc')](_0x361468,_0x2ea4c4);}function getHeader(_0x1e5d3b){var _0x531228=[];for(var _0x19e600 in _0x1e5d3b){if(_0x1e5d3b[_0x1eb8('0xd')](_0x19e600)){_0x531228[_0x1eb8('0xe')]({'text':_0x19e600,'style':_0x1eb8('0xf')});}}return _0x531228;}function extractReport(_0x719433){var _0x15a0ff=0x1388;var _0x1d67b3;if(!_0x719433[0x0][_0x1eb8('0x10')]){return analyticExtractedReport(_0x1eb8('0x11'));}var _0x2f8222=[];var _0x3d49bf=0x0;var _0x5d8659=!![];var _0x5f6fd9=path[_0x1eb8('0x12')](PATH);var _0x400045=path[_0x1eb8('0x13')](PATH,'.pdf');var _0x24bab=![];var _0x2fc31d=[];return db[_0x1eb8('0x14')][_0x1eb8('0x15')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x1eb8('0x16'),_0x1eb8('0x17')]})[_0x1eb8('0x18')](function(_0xf45c9f){if(_0xf45c9f){_0x1d67b3=_0xf45c9f;_0x15a0ff=_0x1d67b3[_0x1eb8('0x17')]||0x3e8;}})[_0x1eb8('0x18')](function(){if(_0x719433&&_0x719433[_0x1eb8('0x19')]){var _0x11c4e6=_0x719433[0x0][_0x1eb8('0x10')]%(_0x3d49bf+_0x15a0ff);if(_0x1d67b3[_0x1eb8('0x16')]){for(;_0x5d8659;_0x3d49bf+=_0x15a0ff,_0x11c4e6=_0x719433[0x0][_0x1eb8('0x10')]%(_0x3d49bf+_0x15a0ff)){if(_0x11c4e6==0x0||_0x11c4e6==_0x719433[0x0][_0x1eb8('0x10')]){_0x5d8659=![];}_0x2f8222[_0x1eb8('0xe')](dbH['sequelize']['query'](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x15a0ff,_0x3d49bf),{'type':dbH['sequelize']['QueryTypes'][_0x1eb8('0x1a')]}));}}else{_0x2f8222[_0x1eb8('0xe')](dbH[_0x1eb8('0x1b')][_0x1eb8('0x1c')](QUERY,{'type':dbH['sequelize']['QueryTypes'][_0x1eb8('0x1a')]}));}}_0x24bab=_0x1d67b3['split']&&_0x2f8222[_0x1eb8('0x19')]>0x1;if(!fs[_0x1eb8('0x1d')](path['join'](_0x5f6fd9,_0x400045))&&_0x24bab){fs[_0x1eb8('0x1e')](path[_0x1eb8('0x1f')](_0x5f6fd9,_0x400045));}return BPromise[_0x1eb8('0x20')](_0x2f8222,function(_0x5d7844){_0x2fc31d[_0x1eb8('0xe')](_0x5d7844);});})['then'](function(){return BPromise[_0x1eb8('0x20')](_0x2f8222,function(_0x3006d6,_0x375859){var _0x57b135;var _0x551988=util[_0x1eb8('0x21')](_0x1eb8('0x22'),NAME,_extractedReport[_0x1eb8('0x23')],moment(_extractedReport[_0x1eb8('0x24')])[_0x1eb8('0x21')](FORMAT),moment(_extractedReport['endDate'])['format'](FORMAT));var _0x47a15e={'pageSize':'A4','pageOrientation':'landscape','content':[{'text':_0x551988,'style':_0x1eb8('0x25')}],'defaultStyle':{'font':'Arial'},'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0x1eb8('0x26')}}};var _0x2e601c={'headerRows':0x1,'body':[]};_0x2e601c['body'][_0x1eb8('0xe')](getHeader(_0x3006d6[0x0]));var _0x1e26aa;for(var _0x3bcc21=0x0;_0x3bcc21<_0x3006d6[_0x1eb8('0x19')];_0x3bcc21+=0x1){_0x1e26aa=[];for(var _0x46a389 in _0x3006d6[_0x3bcc21]){if(_0x3006d6[_0x3bcc21][_0x1eb8('0xd')](_0x46a389)){_0x1e26aa[_0x1eb8('0xe')](_0x3006d6[_0x3bcc21][_0x46a389]?_[_0x1eb8('0x27')](_0x3006d6[_0x3bcc21][_0x46a389]):'');}}_0x2e601c[_0x1eb8('0x28')]['push'](_0x1e26aa);}_0x47a15e[_0x1eb8('0x29')][_0x1eb8('0xe')]({'table':_0x2e601c});return new BPromise(function(_0x1b052a,_0x5d8b4e){var _0x3f12cb=new PdfPrinter({'Arial':{'normal':__dirname+'/fonts/arial-regular.ttf','bold':__dirname+'/fonts/arial-bold.ttf','italics':__dirname+_0x1eb8('0x2a'),'bolditalics':__dirname+_0x1eb8('0x2b')}});var _0x3039a3=_0x3f12cb[_0x1eb8('0x2c')](_0x47a15e);if(_0x24bab){_0x57b135=path[_0x1eb8('0x1f')](_0x5f6fd9,_0x400045,util[_0x1eb8('0x21')](_0x1eb8('0x2d'),_0x400045,_0x375859,_0x1eb8('0x2e')));}else{_0x57b135=path[_0x1eb8('0x1f')](_0x5f6fd9,util[_0x1eb8('0x21')](_0x1eb8('0x2f'),_0x400045,_0x1eb8('0x2e')));}var _0x3102f3=_0x3039a3[_0x1eb8('0x30')](fs[_0x1eb8('0x31')](_0x57b135));_0x3102f3['on'](_0x1eb8('0x32'),function(){_0x1b052a();});_0x3102f3['on'](_0x1eb8('0x33'),function(_0x50ac19){console[_0x1eb8('0x34')]('err',_0x50ac19);_0x5d8b4e(_0x50ac19);});_0x3039a3[_0x1eb8('0x35')]();});});})[_0x1eb8('0x18')](function(){if(_0x24bab){return new BPromise(function(_0x1624e9,_0x2ddc59){zipdir(path[_0x1eb8('0x1f')](_0x5f6fd9,_0x400045),{'saveTo':path[_0x1eb8('0x1f')](_0x5f6fd9,util[_0x1eb8('0x21')](_0x1eb8('0x2f'),_0x400045,_0x1eb8('0x36')))},function(_0x8347e9){if(_0x8347e9){_0x2ddc59(_0x8347e9);}else{_0x1624e9();}});});}})['then'](function(){if(_0x24bab){rimraf(path[_0x1eb8('0x1f')](_0x5f6fd9,_0x400045),function(){});}})[_0x1eb8('0x18')](function(){logger[_0x1eb8('0x37')](util[_0x1eb8('0x21')](_0x1eb8('0x38'),EXTRACTED_REPORT_ID,_0x1eb8('0x39')));return analyticExtractedReport(_0x1eb8('0x3a'),_0x24bab?util[_0x1eb8('0x21')](_0x1eb8('0x2f'),_0x400045,_0x24bab?_0x1eb8('0x36'):_0x1eb8('0x2e')):null);});}function main(){logger[_0x1eb8('0x37')](util[_0x1eb8('0x21')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x1eb8('0x3b')));return db[_0x1eb8('0xb')][_0x1eb8('0x3c')]({'where':{'id':EXTRACTED_REPORT_ID}})[_0x1eb8('0x18')](function(_0x5455b0){_extractedReport=_0x5455b0;return dbH[_0x1eb8('0x1b')][_0x1eb8('0x1c')](util[_0x1eb8('0x21')](_0x1eb8('0x3d'),QUERY),{'type':dbH[_0x1eb8('0x1b')][_0x1eb8('0x3e')]['SELECT']});})[_0x1eb8('0x18')](extractReport)['catch'](function(_0x249088){logger[_0x1eb8('0x37')](util['format'](_0x1eb8('0x3f'),EXTRACTED_REPORT_ID,_0x1eb8('0x3b')),util[_0x1eb8('0x40')](_0x249088,{'showHidden':![],'depth':null}));return analyticExtractedReport('Failed');});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff