// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x99aa=['sequelize','%s\x20limit\x20%d\x20OFFSET\x20%d','query','QueryTypes','SELECT','existsSync','join','each','format','Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s','name','startDate','endDate','landscape','black','body','toString','content','/fonts/Roboto-Regular.ttf','/fonts/Roboto-MediumItalic.ttf','createPdfKitDocument','pdf','pipe','finish','error','log','end','%s.%s','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','zip','info','AnalyticExtractedReport','findOne','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','PDF','inspect','lodash','bluebird','moment','pdfmake/src/printer','zip-dir','../../mysqldb','dbH','../../config/logger','analytics','argv','MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a','savename','hasOwnProperty','push','tableHeader','num','Empty','dirname','basename','.pdf','find','splitSizePdf','then','length','split'];(function(_0x3191f8,_0x17d2db){var _0x462a75=function(_0x3133de){while(--_0x3133de){_0x3191f8['push'](_0x3191f8['shift']());}};_0x462a75(++_0x17d2db);}(_0x99aa,0x1d7));var _0xa99a=function(_0x3c400a,_0x557c21){_0x3c400a=_0x3c400a-0x0;var _0x3fb931=_0x99aa[_0x3c400a];return _0x3fb931;};'use strict';var _=require(_0xa99a('0x0'));var fs=require('fs');var BPromise=require(_0xa99a('0x1'));var util=require('util');var path=require('path');var moment=require(_0xa99a('0x2'));var PdfPrinter=require(_0xa99a('0x3'));var zipdir=require(_0xa99a('0x4'));var rimraf=require('rimraf');var db=require(_0xa99a('0x5'))['db'];var dbH=require(_0xa99a('0x5'))[_0xa99a('0x6')];var logger=require(_0xa99a('0x7'))(_0xa99a('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0xa99a('0x9')][0x2]);var QUERY=process[_0xa99a('0x9')][0x3];var PATH=process['argv'][0x4];var NAME=process[_0xa99a('0x9')][0x5];var FORMAT=_0xa99a('0xa');var _extractedReport;function analyticExtractedReport(_0x541ec7,_0x25836e){var _0x369214={'status':_0x541ec7};var _0x2134c4={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x25836e){_0x369214[_0xa99a('0xb')]=_0x25836e;}return db['AnalyticExtractedReport']['update'](_0x369214,_0x2134c4);}function getHeader(_0x453ab1){var _0x1a6bd0=[];for(var _0x318f36 in _0x453ab1){if(_0x453ab1[_0xa99a('0xc')](_0x318f36)){_0x1a6bd0[_0xa99a('0xd')]({'text':_0x318f36,'style':_0xa99a('0xe')});}}return _0x1a6bd0;}function extractReport(_0x3ae8ea){var _0x55de3f=0x1388;var _0x81c8a9;if(!_0x3ae8ea[0x0][_0xa99a('0xf')]){return analyticExtractedReport(_0xa99a('0x10'));}var _0x10eeff=[];var _0x4b6317=0x0;var _0xa5919b=!![];var _0x15d662=path[_0xa99a('0x11')](PATH);var _0x54ac29=path[_0xa99a('0x12')](PATH,_0xa99a('0x13'));var _0x31888b=![];var _0x1c21f6=[];return db['Setting'][_0xa99a('0x14')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xa99a('0x15')]})[_0xa99a('0x16')](function(_0x5daa60){if(_0x5daa60){_0x81c8a9=_0x5daa60;_0x55de3f=_0x81c8a9[_0xa99a('0x15')]||0x3e8;}})[_0xa99a('0x16')](function(){if(_0x3ae8ea&&_0x3ae8ea[_0xa99a('0x17')]){var _0x3a07d2=_0x3ae8ea[0x0][_0xa99a('0xf')]%(_0x4b6317+_0x55de3f);if(_0x81c8a9[_0xa99a('0x18')]){for(;_0xa5919b;_0x4b6317+=_0x55de3f,_0x3a07d2=_0x3ae8ea[0x0][_0xa99a('0xf')]%(_0x4b6317+_0x55de3f)){if(_0x3a07d2==0x0||_0x3a07d2==_0x3ae8ea[0x0][_0xa99a('0xf')]){_0xa5919b=![];}_0x10eeff['push'](dbH[_0xa99a('0x19')]['query'](util['format'](_0xa99a('0x1a'),QUERY,_0x55de3f,_0x4b6317),{'type':dbH[_0xa99a('0x19')]['QueryTypes']['SELECT']}));}}else{_0x10eeff[_0xa99a('0xd')](dbH['sequelize'][_0xa99a('0x1b')](QUERY,{'type':dbH[_0xa99a('0x19')][_0xa99a('0x1c')][_0xa99a('0x1d')]}));}}_0x31888b=_0x81c8a9[_0xa99a('0x18')]&&_0x10eeff['length']>0x1;if(!fs[_0xa99a('0x1e')](path[_0xa99a('0x1f')](_0x15d662,_0x54ac29))&&_0x31888b){fs['mkdirSync'](path[_0xa99a('0x1f')](_0x15d662,_0x54ac29));}return BPromise['each'](_0x10eeff,function(_0x333ca0){_0x1c21f6[_0xa99a('0xd')](_0x333ca0);});})[_0xa99a('0x16')](function(){return BPromise[_0xa99a('0x20')](_0x10eeff,function(_0x1e748e,_0x5ec6ae){var _0x37cf22;var _0x36fe98=util[_0xa99a('0x21')](_0xa99a('0x22'),NAME,_extractedReport[_0xa99a('0x23')],moment(_extractedReport[_0xa99a('0x24')])[_0xa99a('0x21')](FORMAT),moment(_extractedReport[_0xa99a('0x25')])[_0xa99a('0x21')](FORMAT));var _0x1d0aaa={'pageSize':'A4','pageOrientation':_0xa99a('0x26'),'content':[{'text':_0x36fe98,'style':'header'}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0xa99a('0x27')}}};var _0x41f5b1={'headerRows':0x1,'body':[]};_0x41f5b1[_0xa99a('0x28')][_0xa99a('0xd')](getHeader(_0x1e748e[0x0]));var _0x3172a1;for(var _0x142e76=0x0;_0x142e76<_0x1e748e[_0xa99a('0x17')];_0x142e76+=0x1){_0x3172a1=[];for(var _0x33fe82 in _0x1e748e[_0x142e76]){if(_0x1e748e[_0x142e76][_0xa99a('0xc')](_0x33fe82)){_0x3172a1[_0xa99a('0xd')](_0x1e748e[_0x142e76][_0x33fe82]?_[_0xa99a('0x29')](_0x1e748e[_0x142e76][_0x33fe82]):'');}}_0x41f5b1[_0xa99a('0x28')][_0xa99a('0xd')](_0x3172a1);}_0x1d0aaa[_0xa99a('0x2a')][_0xa99a('0xd')]({'table':_0x41f5b1});return new BPromise(function(_0x976a9e,_0x42807d){var _0x34fffb=new PdfPrinter({'Roboto':{'normal':__dirname+_0xa99a('0x2b'),'bold':__dirname+'/fonts/Roboto-Medium.ttf','italics':__dirname+'/fonts/Roboto-Italic.ttf','bolditalics':__dirname+_0xa99a('0x2c')}});var _0x19f8fa=_0x34fffb[_0xa99a('0x2d')](_0x1d0aaa);if(_0x31888b){_0x37cf22=path['join'](_0x15d662,_0x54ac29,util['format']('%s%d.%s',_0x54ac29,_0x5ec6ae,'pdf'));}else{_0x37cf22=path[_0xa99a('0x1f')](_0x15d662,util[_0xa99a('0x21')]('%s.%s',_0x54ac29,_0xa99a('0x2e')));}var _0x4c204b=_0x19f8fa[_0xa99a('0x2f')](fs['createWriteStream'](_0x37cf22));_0x4c204b['on'](_0xa99a('0x30'),function(){_0x976a9e();});_0x4c204b['on'](_0xa99a('0x31'),function(_0x255de2){console[_0xa99a('0x32')]('err',_0x255de2);_0x42807d(_0x255de2);});_0x19f8fa[_0xa99a('0x33')]();});});})['then'](function(){if(_0x31888b){return new BPromise(function(_0x367b27,_0x17860a){zipdir(path[_0xa99a('0x1f')](_0x15d662,_0x54ac29),{'saveTo':path[_0xa99a('0x1f')](_0x15d662,util[_0xa99a('0x21')](_0xa99a('0x34'),_0x54ac29,'zip'))},function(_0x1bdaf8){if(_0x1bdaf8){_0x17860a(_0x1bdaf8);}else{_0x367b27();}});});}})[_0xa99a('0x16')](function(){if(_0x31888b){rimraf(path[_0xa99a('0x1f')](_0x15d662,_0x54ac29),function(){});}})[_0xa99a('0x16')](function(){logger['info'](util[_0xa99a('0x21')](_0xa99a('0x35'),EXTRACTED_REPORT_ID,_0xa99a('0x36')));return analyticExtractedReport('Completed',_0x31888b?util['format'](_0xa99a('0x34'),_0x54ac29,_0x31888b?_0xa99a('0x37'):'pdf'):null);});}function main(){logger[_0xa99a('0x38')](util[_0xa99a('0x21')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'PDF'));return db[_0xa99a('0x39')][_0xa99a('0x3a')]({'where':{'id':EXTRACTED_REPORT_ID}})[_0xa99a('0x16')](function(_0x16faca){_extractedReport=_0x16faca;return dbH[_0xa99a('0x19')][_0xa99a('0x1b')](util[_0xa99a('0x21')](_0xa99a('0x3b'),QUERY),{'type':dbH[_0xa99a('0x19')]['QueryTypes'][_0xa99a('0x1d')]});})['then'](extractReport)['catch'](function(_0x2606d4){logger[_0xa99a('0x38')](util[_0xa99a('0x21')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xa99a('0x3c')),util[_0xa99a('0x3d')](_0x2606d4,{'showHidden':![],'depth':null}));return analyticExtractedReport('Failed');});}main();
\ No newline at end of file
+var _0xfbae=['length','push','sequelize','query','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','existsSync','join','mkdirSync','each','name','startDate','format','endDate','landscape','header','black','body','hasOwnProperty','toString','content','/fonts/Roboto-Regular.ttf','/fonts/Roboto-Italic.ttf','%s%d.%s','pdf','pipe','createWriteStream','finish','error','log','end','%s.%s','zip','info','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','AnalyticExtractedReport','findOne','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','lodash','bluebird','util','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','tableHeader','num','Empty','dirname','.pdf','Setting','find','split','splitSizePdf','then'];(function(_0x17d9e3,_0x1f969c){var _0x14192d=function(_0x159745){while(--_0x159745){_0x17d9e3['push'](_0x17d9e3['shift']());}};_0x14192d(++_0x1f969c);}(_0xfbae,0xae));var _0xefba=function(_0x14abe9,_0xf47473){_0x14abe9=_0x14abe9-0x0;var _0x3c5455=_0xfbae[_0x14abe9];return _0x3c5455;};'use strict';var _=require(_0xefba('0x0'));var fs=require('fs');var BPromise=require(_0xefba('0x1'));var util=require(_0xefba('0x2'));var path=require('path');var moment=require('moment');var PdfPrinter=require('pdfmake/src/printer');var zipdir=require(_0xefba('0x3'));var rimraf=require(_0xefba('0x4'));var db=require(_0xefba('0x5'))['db'];var dbH=require(_0xefba('0x5'))[_0xefba('0x6')];var logger=require(_0xefba('0x7'))(_0xefba('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0xefba('0x9')][0x2]);var QUERY=process[_0xefba('0x9')][0x3];var PATH=process[_0xefba('0x9')][0x4];var NAME=process[_0xefba('0x9')][0x5];var FORMAT='MMMM\x20Do\x20YYYY,\x20h:mm:ss\x20a';var _extractedReport;function analyticExtractedReport(_0x1ff9e2,_0xc8a253){var _0x199a38={'status':_0x1ff9e2};var _0x89539={'where':{'id':EXTRACTED_REPORT_ID}};if(_0xc8a253){_0x199a38[_0xefba('0xa')]=_0xc8a253;}return db['AnalyticExtractedReport']['update'](_0x199a38,_0x89539);}function getHeader(_0xfe6068){var _0x120d80=[];for(var _0x4b5bdd in _0xfe6068){if(_0xfe6068['hasOwnProperty'](_0x4b5bdd)){_0x120d80['push']({'text':_0x4b5bdd,'style':_0xefba('0xb')});}}return _0x120d80;}function extractReport(_0x386505){var _0x578b68=0x1388;var _0x6ad2cd;if(!_0x386505[0x0][_0xefba('0xc')]){return analyticExtractedReport(_0xefba('0xd'));}var _0x8cab73=[];var _0x34bb5c=0x0;var _0x569028=!![];var _0xa83e8a=path[_0xefba('0xe')](PATH);var _0x37d79b=path['basename'](PATH,_0xefba('0xf'));var _0x3e1e5c=![];var _0x37641c=[];return db[_0xefba('0x10')][_0xefba('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xefba('0x12'),_0xefba('0x13')]})[_0xefba('0x14')](function(_0x1728b2){if(_0x1728b2){_0x6ad2cd=_0x1728b2;_0x578b68=_0x6ad2cd['splitSizePdf']||0x3e8;}})[_0xefba('0x14')](function(){if(_0x386505&&_0x386505[_0xefba('0x15')]){var _0x304ff2=_0x386505[0x0][_0xefba('0xc')]%(_0x34bb5c+_0x578b68);if(_0x6ad2cd[_0xefba('0x12')]){for(;_0x569028;_0x34bb5c+=_0x578b68,_0x304ff2=_0x386505[0x0][_0xefba('0xc')]%(_0x34bb5c+_0x578b68)){if(_0x304ff2==0x0||_0x304ff2==_0x386505[0x0]['num']){_0x569028=![];}_0x8cab73[_0xefba('0x16')](dbH[_0xefba('0x17')][_0xefba('0x18')](util['format'](_0xefba('0x19'),QUERY,_0x578b68,_0x34bb5c),{'type':dbH[_0xefba('0x17')][_0xefba('0x1a')][_0xefba('0x1b')]}));}}else{_0x8cab73[_0xefba('0x16')](dbH['sequelize'][_0xefba('0x18')](QUERY,{'type':dbH[_0xefba('0x17')]['QueryTypes'][_0xefba('0x1b')]}));}}_0x3e1e5c=_0x6ad2cd[_0xefba('0x12')]&&_0x8cab73['length']>0x1;if(!fs[_0xefba('0x1c')](path[_0xefba('0x1d')](_0xa83e8a,_0x37d79b))&&_0x3e1e5c){fs[_0xefba('0x1e')](path['join'](_0xa83e8a,_0x37d79b));}return BPromise[_0xefba('0x1f')](_0x8cab73,function(_0x9c8c14){_0x37641c[_0xefba('0x16')](_0x9c8c14);});})[_0xefba('0x14')](function(){return BPromise['each'](_0x8cab73,function(_0x234104,_0x47dbf9){var _0x39c1b2;var _0x20f0e7=util['format']('Name:\x20%s\x0aReport:\x20%s\x0aFrom:\x20%s\x20To:\x20%s',NAME,_extractedReport[_0xefba('0x20')],moment(_extractedReport[_0xefba('0x21')])[_0xefba('0x22')](FORMAT),moment(_extractedReport[_0xefba('0x23')])[_0xefba('0x22')](FORMAT));var _0x58f046={'pageSize':'A4','pageOrientation':_0xefba('0x24'),'content':[{'text':_0x20f0e7,'style':_0xefba('0x25')}],'styles':{'header':{'fontSize':0x12,'bold':!![],'margin':[0x0,0x0,0x0,0xa]},'tableHeader':{'bold':!![],'fontSize':0xd,'color':_0xefba('0x26')}}};var _0x4014e2={'headerRows':0x1,'body':[]};_0x4014e2[_0xefba('0x27')][_0xefba('0x16')](getHeader(_0x234104[0x0]));var _0x11ffb9;for(var _0x4e8624=0x0;_0x4e8624<_0x234104[_0xefba('0x15')];_0x4e8624+=0x1){_0x11ffb9=[];for(var _0xbed92a in _0x234104[_0x4e8624]){if(_0x234104[_0x4e8624][_0xefba('0x28')](_0xbed92a)){_0x11ffb9['push'](_0x234104[_0x4e8624][_0xbed92a]?_[_0xefba('0x29')](_0x234104[_0x4e8624][_0xbed92a]):'');}}_0x4014e2[_0xefba('0x27')][_0xefba('0x16')](_0x11ffb9);}_0x58f046[_0xefba('0x2a')][_0xefba('0x16')]({'table':_0x4014e2});return new BPromise(function(_0x4b32c0,_0x1154e9){var _0x1e5326=new PdfPrinter({'Roboto':{'normal':__dirname+_0xefba('0x2b'),'bold':__dirname+'/fonts/Roboto-Medium.ttf','italics':__dirname+_0xefba('0x2c'),'bolditalics':__dirname+'/fonts/Roboto-MediumItalic.ttf'}});var _0x4141d9=_0x1e5326['createPdfKitDocument'](_0x58f046);if(_0x3e1e5c){_0x39c1b2=path[_0xefba('0x1d')](_0xa83e8a,_0x37d79b,util['format'](_0xefba('0x2d'),_0x37d79b,_0x47dbf9,_0xefba('0x2e')));}else{_0x39c1b2=path['join'](_0xa83e8a,util[_0xefba('0x22')]('%s.%s',_0x37d79b,_0xefba('0x2e')));}var _0x1ad919=_0x4141d9[_0xefba('0x2f')](fs[_0xefba('0x30')](_0x39c1b2));_0x1ad919['on'](_0xefba('0x31'),function(){_0x4b32c0();});_0x1ad919['on'](_0xefba('0x32'),function(_0x2fce86){console[_0xefba('0x33')]('err',_0x2fce86);_0x1154e9(_0x2fce86);});_0x4141d9[_0xefba('0x34')]();});});})['then'](function(){if(_0x3e1e5c){return new BPromise(function(_0x582e19,_0x236403){zipdir(path['join'](_0xa83e8a,_0x37d79b),{'saveTo':path['join'](_0xa83e8a,util[_0xefba('0x22')](_0xefba('0x35'),_0x37d79b,_0xefba('0x36')))},function(_0x3b3a22){if(_0x3b3a22){_0x236403(_0x3b3a22);}else{_0x582e19();}});});}})['then'](function(){if(_0x3e1e5c){rimraf(path[_0xefba('0x1d')](_0xa83e8a,_0x37d79b),function(){});}})[_0xefba('0x14')](function(){logger[_0xefba('0x37')](util[_0xefba('0x22')](_0xefba('0x38'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0xefba('0x39'),_0x3e1e5c?util['format'](_0xefba('0x35'),_0x37d79b,_0x3e1e5c?'zip':_0xefba('0x2e')):null);});}function main(){logger[_0xefba('0x37')](util[_0xefba('0x22')](_0xefba('0x3a'),EXTRACTED_REPORT_ID,'PDF'));return db[_0xefba('0x3b')][_0xefba('0x3c')]({'where':{'id':EXTRACTED_REPORT_ID}})['then'](function(_0x2000c6){_extractedReport=_0x2000c6;return dbH[_0xefba('0x17')][_0xefba('0x18')](util['format']('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0xefba('0x17')]['QueryTypes'][_0xefba('0x1b')]});})['then'](extractReport)[_0xefba('0x3d')](function(_0x2b5bdc){logger[_0xefba('0x37')](util[_0xefba('0x22')](_0xefba('0x3e'),EXTRACTED_REPORT_ID,'PDF'),util[_0xefba('0x3f')](_0x2b5bdc,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0xefba('0x40'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff