// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6c11=['query','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','existsSync','mkdirSync','join','each','format','Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s','startDate','endDate','landscape','header','Arial','body','toString','content','/fonts/arial-regular.ttf','/fonts/arial-bold.ttf','/fonts/arial-italic.ttf','/fonts/arial-bold-italic.ttf','%s%d.%s','pdf','%s.%s','pipe','createWriteStream','log','err','end','zip','info','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','PDF','inspect','lodash','bluebird','util','path','pdfmake/src/printer','zip-dir','../../mysqldb','dbH','../../config/logger','argv','savename','AnalyticExtractedReport','update','hasOwnProperty','push','tableHeader','dirname','basename','.pdf','Setting','find','split','splitSizePdf','then','length','num','sequelize'];(function(_0x30ba85,_0x503490){var _0x58b533=function(_0x131acf){while(--_0x131acf){_0x30ba85['push'](_0x30ba85['shift']());}};_0x58b533(++_0x503490);}(_0x6c11,0xf5));var _0x16c1=function(_0xc73a34,_0xc7b9c7){_0xc73a34=_0xc73a34-0x0;var _0x285d38=_0x6c11[_0xc73a34];return _0x285d38;};'use strict';var _=require(_0x16c1('0x0'));var fs=require('fs');var BPromise=require(_0x16c1('0x1'));var util=require(_0x16c1('0x2'));var path=require(_0x16c1('0x3'));var moment=require('moment');var PdfPrinter=require(_0x16c1('0x4'));var zipdir=require(_0x16c1('0x5'));var rimraf=require('rimraf');var db=require(_0x16c1('0x6'))['db'];var dbH=require(_0x16c1('0x6'))[_0x16c1('0x7')];var logger=require(_0x16c1('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x16c1('0x9')][0x2]);var QUERY=process[_0x16c1('0x9')][0x3];var PATH=process[_0x16c1('0x9')][0x4];var NAME=process[_0x16c1('0x9')][0x5];var FORMAT='MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a';var _extractedReport;function analyticExtractedReport(_0xfd2a12,_0x351b8d){var _0x15b3c9={'status':_0xfd2a12};var _0x3a2cd8={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x351b8d){_0x15b3c9[_0x16c1('0xa')]=_0x351b8d;}return db[_0x16c1('0xb')][_0x16c1('0xc')](_0x15b3c9,_0x3a2cd8);}function getHeader(_0x58576b){var _0x47280a=[];for(var _0xd922a6 in _0x58576b){if(_0x58576b[_0x16c1('0xd')](_0xd922a6)){_0x47280a[_0x16c1('0xe')]({'text':_0xd922a6,'style':_0x16c1('0xf')});}}return _0x47280a;}function extractReport(_0x173484){var _0x35f97b=0x1388;var _0x28428d;if(!_0x173484[0x0]['num']){return analyticExtractedReport('Empty');}var _0x4aa738=[];var _0x4917a0=0x0;var _0x48c094=!![];var _0x46f05b=path[_0x16c1('0x10')](PATH);var _0x48a2ab=path[_0x16c1('0x11')](PATH,_0x16c1('0x12'));var _0x26d2d1=![];var _0x361cc1=[];return db[_0x16c1('0x13')][_0x16c1('0x14')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x16c1('0x15'),_0x16c1('0x16')]})[_0x16c1('0x17')](function(_0x272806){if(_0x272806){_0x28428d=_0x272806;_0x35f97b=_0x28428d[_0x16c1('0x16')]||0x3e8;}})[_0x16c1('0x17')](function(){if(_0x173484&&_0x173484[_0x16c1('0x18')]){var _0x39cfde=_0x173484[0x0]['num']%(_0x4917a0+_0x35f97b);if(_0x28428d[_0x16c1('0x15')]){for(;_0x48c094;_0x4917a0+=_0x35f97b,_0x39cfde=_0x173484[0x0][_0x16c1('0x19')]%(_0x4917a0+_0x35f97b)){if(_0x39cfde==0x0||_0x39cfde==_0x173484[0x0]['num']){_0x48c094=![];}_0x4aa738[_0x16c1('0xe')](dbH[_0x16c1('0x1a')][_0x16c1('0x1b')](util['format'](_0x16c1('0x1c'),QUERY,_0x35f97b,_0x4917a0),{'type':dbH[_0x16c1('0x1a')]['QueryTypes']['SELECT']}));}}else{_0x4aa738['push'](dbH[_0x16c1('0x1a')][_0x16c1('0x1b')](QUERY,{'type':dbH[_0x16c1('0x1a')][_0x16c1('0x1d')]['SELECT']}));}}_0x26d2d1=_0x28428d[_0x16c1('0x15')]&&_0x4aa738[_0x16c1('0x18')]>0x1;if(!fs[_0x16c1('0x1e')](path['join'](_0x46f05b,_0x48a2ab))&&_0x26d2d1){fs[_0x16c1('0x1f')](path[_0x16c1('0x20')](_0x46f05b,_0x48a2ab));}return BPromise['each'](_0x4aa738,function(_0x37c140){_0x361cc1[_0x16c1('0xe')](_0x37c140);});})['then'](function(){return BPromise[_0x16c1('0x21')](_0x4aa738,function(_0x4f8b3d,_0x3d498c){var _0x39189e;var _0x47ae86=util[_0x16c1('0x22')](_0x16c1('0x23'),NAME,_extractedReport['name'],moment(_extractedReport[_0x16c1('0x24')])[_0x16c1('0x22')](FORMAT),moment(_extractedReport[_0x16c1('0x25')])[_0x16c1('0x22')](FORMAT));var _0x233be8={'pageSize':'A4','pageOrientation':_0x16c1('0x26'),'content':[{'text':_0x47ae86,'style':_0x16c1('0x27')}],'defaultStyle':{'font':_0x16c1('0x28')},'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':'black'}}};var _0x10ede5={'headerRows':0x1,'body':[]};_0x10ede5[_0x16c1('0x29')][_0x16c1('0xe')](getHeader(_0x4f8b3d[0x0]));var _0x18fa68;for(var _0x5a891e=0x0;_0x5a891e<_0x4f8b3d[_0x16c1('0x18')];_0x5a891e+=0x1){_0x18fa68=[];for(var _0x173c40 in _0x4f8b3d[_0x5a891e]){if(_0x4f8b3d[_0x5a891e][_0x16c1('0xd')](_0x173c40)){_0x18fa68[_0x16c1('0xe')](_0x4f8b3d[_0x5a891e][_0x173c40]?_[_0x16c1('0x2a')](_0x4f8b3d[_0x5a891e][_0x173c40]):'');}}_0x10ede5[_0x16c1('0x29')]['push'](_0x18fa68);}_0x233be8[_0x16c1('0x2b')]['push']({'table':_0x10ede5});return new BPromise(function(_0x5d6ff3,_0x39b981){var _0x771bcf=new PdfPrinter({'Arial':{'normal':__dirname+_0x16c1('0x2c'),'bold':__dirname+_0x16c1('0x2d'),'italics':__dirname+_0x16c1('0x2e'),'bolditalics':__dirname+_0x16c1('0x2f')}});var _0x1e266d=_0x771bcf['createPdfKitDocument'](_0x233be8);if(_0x26d2d1){_0x39189e=path[_0x16c1('0x20')](_0x46f05b,_0x48a2ab,util['format'](_0x16c1('0x30'),_0x48a2ab,_0x3d498c,_0x16c1('0x31')));}else{_0x39189e=path[_0x16c1('0x20')](_0x46f05b,util[_0x16c1('0x22')](_0x16c1('0x32'),_0x48a2ab,'pdf'));}var _0x2fd455=_0x1e266d[_0x16c1('0x33')](fs[_0x16c1('0x34')](_0x39189e));_0x2fd455['on']('finish',function(){_0x5d6ff3();});_0x2fd455['on']('error',function(_0x534d23){console[_0x16c1('0x35')](_0x16c1('0x36'),_0x534d23);_0x39b981(_0x534d23);});_0x1e266d[_0x16c1('0x37')]();});});})[_0x16c1('0x17')](function(){if(_0x26d2d1){return new BPromise(function(_0x3e481c,_0x11a235){zipdir(path[_0x16c1('0x20')](_0x46f05b,_0x48a2ab),{'saveTo':path[_0x16c1('0x20')](_0x46f05b,util[_0x16c1('0x22')](_0x16c1('0x32'),_0x48a2ab,_0x16c1('0x38')))},function(_0x410d19){if(_0x410d19){_0x11a235(_0x410d19);}else{_0x3e481c();}});});}})[_0x16c1('0x17')](function(){if(_0x26d2d1){rimraf(path[_0x16c1('0x20')](_0x46f05b,_0x48a2ab),function(){});}})[_0x16c1('0x17')](function(){logger[_0x16c1('0x39')](util[_0x16c1('0x22')](_0x16c1('0x3a'),EXTRACTED_REPORT_ID,_0x16c1('0x3b')));return analyticExtractedReport(_0x16c1('0x3c'),_0x26d2d1?util['format'](_0x16c1('0x32'),_0x48a2ab,_0x26d2d1?_0x16c1('0x38'):_0x16c1('0x31')):null);});}function main(){logger[_0x16c1('0x39')](util['format'](_0x16c1('0x3d'),EXTRACTED_REPORT_ID,'PDF'));return db[_0x16c1('0xb')]['findOne']({'where':{'id':EXTRACTED_REPORT_ID}})[_0x16c1('0x17')](function(_0x3b6a28){_extractedReport=_0x3b6a28;return dbH['sequelize'][_0x16c1('0x1b')](util['format'](_0x16c1('0x3e'),QUERY),{'type':dbH[_0x16c1('0x1a')]['QueryTypes'][_0x16c1('0x3f')]});})[_0x16c1('0x17')](extractReport)[_0x16c1('0x40')](function(_0x163b32){logger[_0x16c1('0x39')](util[_0x16c1('0x22')](_0x16c1('0x41'),EXTRACTED_REPORT_ID,_0x16c1('0x42')),util[_0x16c1('0x43')](_0x163b32,{'showHidden':![],'depth':null}));return analyticExtractedReport('Failed');});}main();
\ No newline at end of file
+var _0xb10b=['query','format','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','push','SELECT','existsSync','join','mkdirSync','each','name','startDate','endDate','landscape','black','body','content','/fonts/Roboto-Medium.ttf','/fonts/Roboto-Italic.ttf','/fonts/Roboto-MediumItalic.ttf','createPdfKitDocument','pdf','%s.%s','pipe','createWriteStream','finish','log','err','end','zip','info','Completed','PDF','findOne','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','lodash','util','path','moment','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a','savename','AnalyticExtractedReport','hasOwnProperty','tableHeader','num','Empty','dirname','basename','.pdf','Setting','find','split','then','splitSizePdf','length','sequelize'];(function(_0x548047,_0x4d95e0){var _0x58f1b3=function(_0x2be1b2){while(--_0x2be1b2){_0x548047['push'](_0x548047['shift']());}};_0x58f1b3(++_0x4d95e0);}(_0xb10b,0x12a));var _0xbb10=function(_0x185f7f,_0x42aa8b){_0x185f7f=_0x185f7f-0x0;var _0x15d436=_0xb10b[_0x185f7f];return _0x15d436;};'use strict';var _=require(_0xbb10('0x0'));var fs=require('fs');var BPromise=require('bluebird');var util=require(_0xbb10('0x1'));var path=require(_0xbb10('0x2'));var moment=require(_0xbb10('0x3'));var PdfPrinter=require('pdfmake/src/printer');var zipdir=require(_0xbb10('0x4'));var rimraf=require(_0xbb10('0x5'));var db=require(_0xbb10('0x6'))['db'];var dbH=require(_0xbb10('0x6'))[_0xbb10('0x7')];var logger=require(_0xbb10('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0xbb10('0x9')][0x2]);var QUERY=process[_0xbb10('0x9')][0x3];var PATH=process['argv'][0x4];var NAME=process[_0xbb10('0x9')][0x5];var FORMAT=_0xbb10('0xa');var _extractedReport;function analyticExtractedReport(_0x21370f,_0x1c3ee5){var _0x2353ef={'status':_0x21370f};var _0x1ce33e={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x1c3ee5){_0x2353ef[_0xbb10('0xb')]=_0x1c3ee5;}return db[_0xbb10('0xc')]['update'](_0x2353ef,_0x1ce33e);}function getHeader(_0x4e47f8){var _0x20bd61=[];for(var _0x118a74 in _0x4e47f8){if(_0x4e47f8[_0xbb10('0xd')](_0x118a74)){_0x20bd61['push']({'text':_0x118a74,'style':_0xbb10('0xe')});}}return _0x20bd61;}function extractReport(_0x5be7e0){var _0x44fb19=0x1388;var _0x916a32;if(!_0x5be7e0[0x0][_0xbb10('0xf')]){return analyticExtractedReport(_0xbb10('0x10'));}var _0x442548=[];var _0x147230=0x0;var _0x58a612=!![];var _0x26e021=path[_0xbb10('0x11')](PATH);var _0x45b9d6=path[_0xbb10('0x12')](PATH,_0xbb10('0x13'));var _0x2f2ebf=![];var _0x24a57b=[];return db[_0xbb10('0x14')][_0xbb10('0x15')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xbb10('0x16'),'splitSizePdf']})[_0xbb10('0x17')](function(_0x1145f1){if(_0x1145f1){_0x916a32=_0x1145f1;_0x44fb19=_0x916a32[_0xbb10('0x18')]||0x3e8;}})[_0xbb10('0x17')](function(){if(_0x5be7e0&&_0x5be7e0[_0xbb10('0x19')]){var _0x1682a4=_0x5be7e0[0x0][_0xbb10('0xf')]%(_0x147230+_0x44fb19);if(_0x916a32[_0xbb10('0x16')]){for(;_0x58a612;_0x147230+=_0x44fb19,_0x1682a4=_0x5be7e0[0x0][_0xbb10('0xf')]%(_0x147230+_0x44fb19)){if(_0x1682a4==0x0||_0x1682a4==_0x5be7e0[0x0][_0xbb10('0xf')]){_0x58a612=![];}_0x442548['push'](dbH[_0xbb10('0x1a')][_0xbb10('0x1b')](util[_0xbb10('0x1c')](_0xbb10('0x1d'),QUERY,_0x44fb19,_0x147230),{'type':dbH[_0xbb10('0x1a')][_0xbb10('0x1e')]['SELECT']}));}}else{_0x442548[_0xbb10('0x1f')](dbH[_0xbb10('0x1a')]['query'](QUERY,{'type':dbH['sequelize'][_0xbb10('0x1e')][_0xbb10('0x20')]}));}}_0x2f2ebf=_0x916a32[_0xbb10('0x16')]&&_0x442548[_0xbb10('0x19')]>0x1;if(!fs[_0xbb10('0x21')](path[_0xbb10('0x22')](_0x26e021,_0x45b9d6))&&_0x2f2ebf){fs[_0xbb10('0x23')](path[_0xbb10('0x22')](_0x26e021,_0x45b9d6));}return BPromise[_0xbb10('0x24')](_0x442548,function(_0x395404){_0x24a57b[_0xbb10('0x1f')](_0x395404);});})[_0xbb10('0x17')](function(){return BPromise['each'](_0x442548,function(_0x4fedac,_0x4fb5e0){var _0xc93a04;var _0x3c5ae7=util[_0xbb10('0x1c')]('Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s',NAME,_extractedReport[_0xbb10('0x25')],moment(_extractedReport[_0xbb10('0x26')])[_0xbb10('0x1c')](FORMAT),moment(_extractedReport[_0xbb10('0x27')])[_0xbb10('0x1c')](FORMAT));var _0x20d946={'pageSize':'A4','pageOrientation':_0xbb10('0x28'),'content':[{'text':_0x3c5ae7,'style':'header'}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0xbb10('0x29')}}};var _0x21ac54={'headerRows':0x1,'body':[]};_0x21ac54[_0xbb10('0x2a')][_0xbb10('0x1f')](getHeader(_0x4fedac[0x0]));var _0x1d30aa;for(var _0x2ff4c1=0x0;_0x2ff4c1<_0x4fedac['length'];_0x2ff4c1+=0x1){_0x1d30aa=[];for(var _0x221624 in _0x4fedac[_0x2ff4c1]){if(_0x4fedac[_0x2ff4c1]['hasOwnProperty'](_0x221624)){_0x1d30aa[_0xbb10('0x1f')](_0x4fedac[_0x2ff4c1][_0x221624]?_['toString'](_0x4fedac[_0x2ff4c1][_0x221624]):'');}}_0x21ac54[_0xbb10('0x2a')][_0xbb10('0x1f')](_0x1d30aa);}_0x20d946[_0xbb10('0x2b')]['push']({'table':_0x21ac54});return new BPromise(function(_0x518d47,_0x4c3744){var _0x34f65e=new PdfPrinter({'Roboto':{'normal':__dirname+'/fonts/Roboto-Regular.ttf','bold':__dirname+_0xbb10('0x2c'),'italics':__dirname+_0xbb10('0x2d'),'bolditalics':__dirname+_0xbb10('0x2e')}});var _0x1c0b57=_0x34f65e[_0xbb10('0x2f')](_0x20d946);if(_0x2f2ebf){_0xc93a04=path[_0xbb10('0x22')](_0x26e021,_0x45b9d6,util[_0xbb10('0x1c')]('%s%d.%s',_0x45b9d6,_0x4fb5e0,_0xbb10('0x30')));}else{_0xc93a04=path[_0xbb10('0x22')](_0x26e021,util[_0xbb10('0x1c')](_0xbb10('0x31'),_0x45b9d6,_0xbb10('0x30')));}var _0x9de708=_0x1c0b57[_0xbb10('0x32')](fs[_0xbb10('0x33')](_0xc93a04));_0x9de708['on'](_0xbb10('0x34'),function(){_0x518d47();});_0x9de708['on']('error',function(_0x2b5352){console[_0xbb10('0x35')](_0xbb10('0x36'),_0x2b5352);_0x4c3744(_0x2b5352);});_0x1c0b57[_0xbb10('0x37')]();});});})['then'](function(){if(_0x2f2ebf){return new BPromise(function(_0x111762,_0x5de37b){zipdir(path['join'](_0x26e021,_0x45b9d6),{'saveTo':path[_0xbb10('0x22')](_0x26e021,util[_0xbb10('0x1c')](_0xbb10('0x31'),_0x45b9d6,_0xbb10('0x38')))},function(_0x15d895){if(_0x15d895){_0x5de37b(_0x15d895);}else{_0x111762();}});});}})[_0xbb10('0x17')](function(){if(_0x2f2ebf){rimraf(path['join'](_0x26e021,_0x45b9d6),function(){});}})[_0xbb10('0x17')](function(){logger[_0xbb10('0x39')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0xbb10('0x3a'),_0x2f2ebf?util[_0xbb10('0x1c')](_0xbb10('0x31'),_0x45b9d6,_0x2f2ebf?'zip':_0xbb10('0x30')):null);});}function main(){logger[_0xbb10('0x39')](util[_0xbb10('0x1c')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xbb10('0x3b')));return db[_0xbb10('0xc')][_0xbb10('0x3c')]({'where':{'id':EXTRACTED_REPORT_ID}})[_0xbb10('0x17')](function(_0x4f1cdd){_extractedReport=_0x4f1cdd;return dbH[_0xbb10('0x1a')][_0xbb10('0x1b')](util['format'](_0xbb10('0x3d'),QUERY),{'type':dbH[_0xbb10('0x1a')][_0xbb10('0x1e')][_0xbb10('0x20')]});})[_0xbb10('0x17')](extractReport)[_0xbb10('0x3e')](function(_0x5f3d67){logger[_0xbb10('0x39')](util[_0xbb10('0x1c')](_0xbb10('0x3f'),EXTRACTED_REPORT_ID,_0xbb10('0x3b')),util['inspect'](_0x5f3d67,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0xbb10('0x40'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff