// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1d06=['basename','.pdf','Setting','split','splitSizePdf','then','length','sequelize','query','format','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','QueryTypes','existsSync','mkdirSync','each','Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s','name','startDate','endDate','landscape','header','body','toString','/fonts/Roboto-Regular.ttf','/fonts/Roboto-Medium.ttf','/fonts/Roboto-Italic.ttf','/fonts/Roboto-MediumItalic.ttf','pdf','join','%s.%s','pipe','createWriteStream','finish','error','log','end','zip','info','CSV','Completed','PDF','findOne','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','lodash','bluebird','util','path','moment','pdfmake/src/printer','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','hasOwnProperty','push','tableHeader','num','dirname'];(function(_0x483fd7,_0x30dbdc){var _0x2f4244=function(_0x324157){while(--_0x324157){_0x483fd7['push'](_0x483fd7['shift']());}};_0x2f4244(++_0x30dbdc);}(_0x1d06,0x72));var _0x61d0=function(_0x4ff09b,_0x53f67d){_0x4ff09b=_0x4ff09b-0x0;var _0x3f5c2e=_0x1d06[_0x4ff09b];return _0x3f5c2e;};'use strict';var _=require(_0x61d0('0x0'));var fs=require('fs');var BPromise=require(_0x61d0('0x1'));var util=require(_0x61d0('0x2'));var path=require(_0x61d0('0x3'));var moment=require(_0x61d0('0x4'));var PdfPrinter=require(_0x61d0('0x5'));var zipdir=require('zip-dir');var rimraf=require(_0x61d0('0x6'));var db=require(_0x61d0('0x7'))['db'];var dbH=require('../../mysqldb')[_0x61d0('0x8')];var logger=require(_0x61d0('0x9'))(_0x61d0('0xa'));var EXTRACTED_REPORT_ID=Number(process[_0x61d0('0xb')][0x2]);var QUERY=process[_0x61d0('0xb')][0x3];var PATH=process['argv'][0x4];var NAME=process[_0x61d0('0xb')][0x5];var FORMAT='MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a';var _extractedReport;function analyticExtractedReport(_0x173d9b,_0x1ad15c){var _0x3bd342={'status':_0x173d9b};var _0x271d34={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x1ad15c){_0x3bd342[_0x61d0('0xc')]=_0x1ad15c;}return db[_0x61d0('0xd')][_0x61d0('0xe')](_0x3bd342,_0x271d34);}function getHeader(_0x25dfc3){var _0x5c5f2a=[];for(var _0x8d1f6d in _0x25dfc3){if(_0x25dfc3[_0x61d0('0xf')](_0x8d1f6d)){_0x5c5f2a[_0x61d0('0x10')]({'text':_0x8d1f6d,'style':_0x61d0('0x11')});}}return _0x5c5f2a;}function extractReport(_0x4d6040){var _0x462a2e=0x1388;var _0x3da2a4;if(!_0x4d6040[0x0][_0x61d0('0x12')]){return analyticExtractedReport('Empty');}var _0x2ca34c=[];var _0x3e4c86=0x0;var _0x3eebc5=!![];var _0x2422ae=path[_0x61d0('0x13')](PATH);var _0x5cc1b3=path[_0x61d0('0x14')](PATH,_0x61d0('0x15'));var _0x5308b3=![];var _0x4d860d=[];return db[_0x61d0('0x16')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x61d0('0x17'),_0x61d0('0x18')]})['then'](function(_0x4ce410){if(_0x4ce410){_0x3da2a4=_0x4ce410;_0x462a2e=_0x3da2a4[_0x61d0('0x18')]||0x3e8;}})[_0x61d0('0x19')](function(){if(_0x4d6040&&_0x4d6040[_0x61d0('0x1a')]){var _0xd953e7=_0x4d6040[0x0][_0x61d0('0x12')]%(_0x3e4c86+_0x462a2e);if(_0x3da2a4[_0x61d0('0x17')]){for(;_0x3eebc5;_0x3e4c86+=_0x462a2e,_0xd953e7=_0x4d6040[0x0][_0x61d0('0x12')]%(_0x3e4c86+_0x462a2e)){if(_0xd953e7==0x0||_0xd953e7==_0x4d6040[0x0][_0x61d0('0x12')]){_0x3eebc5=![];}_0x2ca34c[_0x61d0('0x10')](dbH[_0x61d0('0x1b')][_0x61d0('0x1c')](util[_0x61d0('0x1d')](_0x61d0('0x1e'),QUERY,_0x462a2e,_0x3e4c86),{'type':dbH[_0x61d0('0x1b')]['QueryTypes'][_0x61d0('0x1f')]}));}}else{_0x2ca34c[_0x61d0('0x10')](dbH[_0x61d0('0x1b')][_0x61d0('0x1c')](QUERY,{'type':dbH[_0x61d0('0x1b')][_0x61d0('0x20')][_0x61d0('0x1f')]}));}}_0x5308b3=_0x3da2a4['split']&&_0x2ca34c[_0x61d0('0x1a')]>0x1;if(!fs[_0x61d0('0x21')](path['join'](_0x2422ae,_0x5cc1b3))&&_0x5308b3){fs[_0x61d0('0x22')](path['join'](_0x2422ae,_0x5cc1b3));}return BPromise[_0x61d0('0x23')](_0x2ca34c,function(_0x5c27d9){_0x4d860d[_0x61d0('0x10')](_0x5c27d9);});})[_0x61d0('0x19')](function(){return BPromise[_0x61d0('0x23')](_0x2ca34c,function(_0x567162,_0x46bb7e){var _0x270589;var _0x40f456=util['format'](_0x61d0('0x24'),NAME,_extractedReport[_0x61d0('0x25')],moment(_extractedReport[_0x61d0('0x26')])[_0x61d0('0x1d')](FORMAT),moment(_extractedReport[_0x61d0('0x27')])[_0x61d0('0x1d')](FORMAT));var _0x2441c8={'pageSize':'A4','pageOrientation':_0x61d0('0x28'),'content':[{'text':_0x40f456,'style':_0x61d0('0x29')}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':'black'}}};var _0x1a766e={'headerRows':0x1,'body':[]};_0x1a766e[_0x61d0('0x2a')][_0x61d0('0x10')](getHeader(_0x567162[0x0]));var _0x32e0bb;for(var _0x1c268a=0x0;_0x1c268a<_0x567162[_0x61d0('0x1a')];_0x1c268a+=0x1){_0x32e0bb=[];for(var _0x155325 in _0x567162[_0x1c268a]){if(_0x567162[_0x1c268a][_0x61d0('0xf')](_0x155325)){_0x32e0bb['push'](_0x567162[_0x1c268a][_0x155325]?_[_0x61d0('0x2b')](_0x567162[_0x1c268a][_0x155325]):'');}}_0x1a766e[_0x61d0('0x2a')][_0x61d0('0x10')](_0x32e0bb);}_0x2441c8['content']['push']({'table':_0x1a766e});return new BPromise(function(_0x198048,_0x6efe1d){var _0x345ddb=new PdfPrinter({'Roboto':{'normal':__dirname+_0x61d0('0x2c'),'bold':__dirname+_0x61d0('0x2d'),'italics':__dirname+_0x61d0('0x2e'),'bolditalics':__dirname+_0x61d0('0x2f')}});var _0xa4909c=_0x345ddb['createPdfKitDocument'](_0x2441c8);if(_0x5308b3){_0x270589=path['join'](_0x2422ae,_0x5cc1b3,util[_0x61d0('0x1d')]('%s%d.%s',_0x5cc1b3,_0x46bb7e,_0x61d0('0x30')));}else{_0x270589=path[_0x61d0('0x31')](_0x2422ae,util['format'](_0x61d0('0x32'),_0x5cc1b3,_0x61d0('0x30')));}var _0x5bf9c7=_0xa4909c[_0x61d0('0x33')](fs[_0x61d0('0x34')](_0x270589));_0x5bf9c7['on'](_0x61d0('0x35'),function(){_0x198048();});_0x5bf9c7['on'](_0x61d0('0x36'),function(_0x3056bf){console[_0x61d0('0x37')]('err',_0x3056bf);_0x6efe1d(_0x3056bf);});_0xa4909c[_0x61d0('0x38')]();});});})['then'](function(){if(_0x5308b3){return new BPromise(function(_0x176aa2,_0x3ffdd4){zipdir(path[_0x61d0('0x31')](_0x2422ae,_0x5cc1b3),{'saveTo':path['join'](_0x2422ae,util[_0x61d0('0x1d')](_0x61d0('0x32'),_0x5cc1b3,_0x61d0('0x39')))},function(_0x12d56d){if(_0x12d56d){_0x3ffdd4(_0x12d56d);}else{_0x176aa2();}});});}})['then'](function(){if(_0x5308b3){rimraf(path['join'](_0x2422ae,_0x5cc1b3),function(){});}})[_0x61d0('0x19')](function(){logger[_0x61d0('0x3a')](util[_0x61d0('0x1d')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x61d0('0x3b')));return analyticExtractedReport(_0x61d0('0x3c'),_0x5308b3?util[_0x61d0('0x1d')](_0x61d0('0x32'),_0x5cc1b3,_0x5308b3?_0x61d0('0x39'):_0x61d0('0x30')):null);});}function main(){logger['info'](util[_0x61d0('0x1d')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x61d0('0x3d')));return db[_0x61d0('0xd')][_0x61d0('0x3e')]({'where':{'id':EXTRACTED_REPORT_ID}})['then'](function(_0x40cd89){_extractedReport=_0x40cd89;return dbH[_0x61d0('0x1b')][_0x61d0('0x1c')](util[_0x61d0('0x1d')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x61d0('0x1b')]['QueryTypes']['SELECT']});})['then'](extractReport)[_0x61d0('0x3f')](function(_0x49b821){logger['info'](util[_0x61d0('0x1d')](_0x61d0('0x40'),EXTRACTED_REPORT_ID,'PDF'),util[_0x61d0('0x41')](_0x49b821,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x61d0('0x42'));});}main();
\ No newline at end of file
+var _0x7b13=['PDF','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','bluebird','util','path','pdfmake/src/printer','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a','savename','AnalyticExtractedReport','hasOwnProperty','num','dirname','.pdf','Setting','find','splitSizePdf','then','length','split','sequelize','query','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','QueryTypes','existsSync','join','mkdirSync','each','push','format','name','startDate','endDate','landscape','header','black','body','/fonts/Roboto-Regular.ttf','/fonts/Roboto-MediumItalic.ttf','createPdfKitDocument','%s%d.%s','pdf','%s.%s','pipe','finish','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'];(function(_0x342700,_0x569f75){var _0x53406f=function(_0x3b3c32){while(--_0x3b3c32){_0x342700['push'](_0x342700['shift']());}};_0x53406f(++_0x569f75);}(_0x7b13,0xc0));var _0x37b1=function(_0x3b380d,_0x4bf247){_0x3b380d=_0x3b380d-0x0;var _0x54502b=_0x7b13[_0x3b380d];return _0x54502b;};'use strict';var _=require('lodash');var fs=require('fs');var BPromise=require(_0x37b1('0x0'));var util=require(_0x37b1('0x1'));var path=require(_0x37b1('0x2'));var moment=require('moment');var PdfPrinter=require(_0x37b1('0x3'));var zipdir=require(_0x37b1('0x4'));var rimraf=require(_0x37b1('0x5'));var db=require(_0x37b1('0x6'))['db'];var dbH=require(_0x37b1('0x6'))[_0x37b1('0x7')];var logger=require(_0x37b1('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x37b1('0x9')][0x4];var NAME=process['argv'][0x5];var FORMAT=_0x37b1('0xa');var _extractedReport;function analyticExtractedReport(_0x27cb91,_0x59e389){var _0x4fc828={'status':_0x27cb91};var _0x2d3a12={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x59e389){_0x4fc828[_0x37b1('0xb')]=_0x59e389;}return db[_0x37b1('0xc')]['update'](_0x4fc828,_0x2d3a12);}function getHeader(_0x10b344){var _0x3e9b73=[];for(var _0x2b4017 in _0x10b344){if(_0x10b344[_0x37b1('0xd')](_0x2b4017)){_0x3e9b73['push']({'text':_0x2b4017,'style':'tableHeader'});}}return _0x3e9b73;}function extractReport(_0xfdbfaf){var _0x56483f=0x1388;var _0x5e1b0e;if(!_0xfdbfaf[0x0][_0x37b1('0xe')]){return analyticExtractedReport('Empty');}var _0x413c37=[];var _0x45d467=0x0;var _0x5cebb2=!![];var _0x6aef6e=path[_0x37b1('0xf')](PATH);var _0x45b917=path['basename'](PATH,_0x37b1('0x10'));var _0x2a292d=![];var _0x3c06fb=[];return db[_0x37b1('0x11')][_0x37b1('0x12')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x37b1('0x13')]})[_0x37b1('0x14')](function(_0x39716f){if(_0x39716f){_0x5e1b0e=_0x39716f;_0x56483f=_0x5e1b0e[_0x37b1('0x13')]||0x3e8;}})[_0x37b1('0x14')](function(){if(_0xfdbfaf&&_0xfdbfaf[_0x37b1('0x15')]){var _0x9ba1b7=_0xfdbfaf[0x0]['num']%(_0x45d467+_0x56483f);if(_0x5e1b0e[_0x37b1('0x16')]){for(;_0x5cebb2;_0x45d467+=_0x56483f,_0x9ba1b7=_0xfdbfaf[0x0][_0x37b1('0xe')]%(_0x45d467+_0x56483f)){if(_0x9ba1b7==0x0||_0x9ba1b7==_0xfdbfaf[0x0][_0x37b1('0xe')]){_0x5cebb2=![];}_0x413c37['push'](dbH[_0x37b1('0x17')][_0x37b1('0x18')](util['format'](_0x37b1('0x19'),QUERY,_0x56483f,_0x45d467),{'type':dbH[_0x37b1('0x17')]['QueryTypes'][_0x37b1('0x1a')]}));}}else{_0x413c37['push'](dbH['sequelize']['query'](QUERY,{'type':dbH[_0x37b1('0x17')][_0x37b1('0x1b')][_0x37b1('0x1a')]}));}}_0x2a292d=_0x5e1b0e[_0x37b1('0x16')]&&_0x413c37['length']>0x1;if(!fs[_0x37b1('0x1c')](path[_0x37b1('0x1d')](_0x6aef6e,_0x45b917))&&_0x2a292d){fs[_0x37b1('0x1e')](path[_0x37b1('0x1d')](_0x6aef6e,_0x45b917));}return BPromise[_0x37b1('0x1f')](_0x413c37,function(_0x501e8f){_0x3c06fb[_0x37b1('0x20')](_0x501e8f);});})[_0x37b1('0x14')](function(){return BPromise[_0x37b1('0x1f')](_0x413c37,function(_0x22db8e,_0x1ae017){var _0x1b3c16;var _0x31146b=util[_0x37b1('0x21')]('Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s',NAME,_extractedReport[_0x37b1('0x22')],moment(_extractedReport[_0x37b1('0x23')])['format'](FORMAT),moment(_extractedReport[_0x37b1('0x24')])['format'](FORMAT));var _0x4717fa={'pageSize':'A4','pageOrientation':_0x37b1('0x25'),'content':[{'text':_0x31146b,'style':_0x37b1('0x26')}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0x37b1('0x27')}}};var _0xf77eb7={'headerRows':0x1,'body':[]};_0xf77eb7[_0x37b1('0x28')][_0x37b1('0x20')](getHeader(_0x22db8e[0x0]));var _0x3cb683;for(var _0x4c24fb=0x0;_0x4c24fb<_0x22db8e['length'];_0x4c24fb+=0x1){_0x3cb683=[];for(var _0x16338c in _0x22db8e[_0x4c24fb]){if(_0x22db8e[_0x4c24fb][_0x37b1('0xd')](_0x16338c)){_0x3cb683['push'](_0x22db8e[_0x4c24fb][_0x16338c]?_['toString'](_0x22db8e[_0x4c24fb][_0x16338c]):'');}}_0xf77eb7['body'][_0x37b1('0x20')](_0x3cb683);}_0x4717fa['content'][_0x37b1('0x20')]({'table':_0xf77eb7});return new BPromise(function(_0x79665d,_0xbb4afd){var _0x497571=new PdfPrinter({'Roboto':{'normal':__dirname+_0x37b1('0x29'),'bold':__dirname+'/fonts/Roboto-Medium.ttf','italics':__dirname+'/fonts/Roboto-Italic.ttf','bolditalics':__dirname+_0x37b1('0x2a')}});var _0x46ddfe=_0x497571[_0x37b1('0x2b')](_0x4717fa);if(_0x2a292d){_0x1b3c16=path['join'](_0x6aef6e,_0x45b917,util[_0x37b1('0x21')](_0x37b1('0x2c'),_0x45b917,_0x1ae017,_0x37b1('0x2d')));}else{_0x1b3c16=path[_0x37b1('0x1d')](_0x6aef6e,util[_0x37b1('0x21')](_0x37b1('0x2e'),_0x45b917,_0x37b1('0x2d')));}var _0x328a86=_0x46ddfe[_0x37b1('0x2f')](fs['createWriteStream'](_0x1b3c16));_0x328a86['on'](_0x37b1('0x30'),function(){_0x79665d();});_0x328a86['on']('error',function(_0x3ad13f){console['log']('err',_0x3ad13f);_0xbb4afd(_0x3ad13f);});_0x46ddfe[_0x37b1('0x31')]();});});})[_0x37b1('0x14')](function(){if(_0x2a292d){return new BPromise(function(_0x3fc013,_0x404f98){zipdir(path[_0x37b1('0x1d')](_0x6aef6e,_0x45b917),{'saveTo':path['join'](_0x6aef6e,util['format'](_0x37b1('0x2e'),_0x45b917,_0x37b1('0x32')))},function(_0x4767fd){if(_0x4767fd){_0x404f98(_0x4767fd);}else{_0x3fc013();}});});}})[_0x37b1('0x14')](function(){if(_0x2a292d){rimraf(path[_0x37b1('0x1d')](_0x6aef6e,_0x45b917),function(){});}})[_0x37b1('0x14')](function(){logger[_0x37b1('0x33')](util[_0x37b1('0x21')](_0x37b1('0x34'),EXTRACTED_REPORT_ID,_0x37b1('0x35')));return analyticExtractedReport(_0x37b1('0x36'),_0x2a292d?util[_0x37b1('0x21')](_0x37b1('0x2e'),_0x45b917,_0x2a292d?_0x37b1('0x32'):_0x37b1('0x2d')):null);});}function main(){logger['info'](util[_0x37b1('0x21')](_0x37b1('0x37'),EXTRACTED_REPORT_ID,_0x37b1('0x38')));return db[_0x37b1('0xc')]['findOne']({'where':{'id':EXTRACTED_REPORT_ID}})[_0x37b1('0x14')](function(_0x23c875){_extractedReport=_0x23c875;return dbH['sequelize'][_0x37b1('0x18')](util[_0x37b1('0x21')](_0x37b1('0x39'),QUERY),{'type':dbH['sequelize'][_0x37b1('0x1b')][_0x37b1('0x1a')]});})[_0x37b1('0x14')](extractReport)[_0x37b1('0x3a')](function(_0x3e3ebd){logger[_0x37b1('0x33')](util[_0x37b1('0x21')](_0x37b1('0x3b'),EXTRACTED_REPORT_ID,'PDF'),util[_0x37b1('0x3c')](_0x3e3ebd,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x37b1('0x3d'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff