// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2791=['catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','util','path','lodash','json2xls','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','length','range','isInteger','forEach','SELECT','%s\x20limit\x20%d\x20OFFSET\x20%d','push','dirname','basename','.xlsx','join','xlsx','%s.%s','zip','zip\x20finished','XLSX','Completed'];(function(_0x261f3d,_0x175680){var _0x574b9a=function(_0x74376d){while(--_0x74376d){_0x261f3d['push'](_0x261f3d['shift']());}};_0x574b9a(++_0x175680);}(_0x2791,0x100));var _0x1279=function(_0x47f588,_0x2372b5){_0x47f588=_0x47f588-0x0;var _0x4f93a9=_0x2791[_0x47f588];return _0x4f93a9;};'use strict';var util=require(_0x1279('0x0'));var path=require(_0x1279('0x1'));var _=require(_0x1279('0x2'));var fs=require('fs');var json2xls=require(_0x1279('0x3'));var BPromise=require('bluebird');var zipdir=require(_0x1279('0x4'));var rimraf=require(_0x1279('0x5'));var db=require(_0x1279('0x6'))['db'];var dbH=require(_0x1279('0x6'))[_0x1279('0x7')];var logger=require(_0x1279('0x8'))(_0x1279('0x9'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x1279('0xa')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x880f5d,_0x2be205){var _0x1e1e64={'status':_0x880f5d};var _0x1f9ebe={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2be205){_0x1e1e64[_0x1279('0xb')]=_0x2be205;}return db[_0x1279('0xc')][_0x1279('0xd')](_0x1e1e64,_0x1f9ebe);}function main(){var _0x2d4e2e=0x1388;var _0xffc4be;logger[_0x1279('0xe')](util[_0x1279('0xf')](_0x1279('0x10'),EXTRACTED_REPORT_ID,'XLSX'));return db[_0x1279('0x11')][_0x1279('0x12')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x1279('0x13'),_0x1279('0x14')]})[_0x1279('0x15')](function(_0x25291b){if(_0x25291b){_0xffc4be=_0x25291b;_0x2d4e2e=_0xffc4be[_0x1279('0x14')]||0x1388;}})[_0x1279('0x15')](function(){return dbH[_0x1279('0x16')][_0x1279('0x17')](util['format'](_0x1279('0x18'),QUERY),{'type':dbH[_0x1279('0x16')][_0x1279('0x19')]['SELECT']});})[_0x1279('0x15')](function(_0x31125e){if(!_0x31125e[0x0][_0x1279('0x1a')]){return analyticExtractedReport('Empty');}var _0xeebf04=[];var _0x53eaef=0x0;if(_0xffc4be[_0x1279('0x13')]){if(_0x31125e&&_0x31125e[_0x1279('0x1b')]){var _0x1f6fb8=_[_0x1279('0x1c')](_0x31125e[0x0][_0x1279('0x1a')]/_0x2d4e2e);var _0x28234a=Number[_0x1279('0x1d')](_0x31125e[0x0]['num']/_0x2d4e2e)?_0x31125e[0x0][_0x1279('0x1a')]%_0x2d4e2e:0x0;_0x1f6fb8[_0x1279('0x1e')](function(_0x41f6a5){if(_0x41f6a5>0x0){_0x53eaef+=_0x2d4e2e;}_0xeebf04['push'](dbH[_0x1279('0x16')]['query'](util[_0x1279('0xf')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x2d4e2e,_0x53eaef),{'type':dbH[_0x1279('0x16')][_0x1279('0x19')][_0x1279('0x1f')]}));});if(_0x28234a>0x0){_0x53eaef+=_0x2d4e2e;_0xeebf04['push'](dbH[_0x1279('0x16')][_0x1279('0x17')](util[_0x1279('0xf')](_0x1279('0x20'),QUERY,_0x28234a,_0x53eaef),{'type':dbH['sequelize'][_0x1279('0x19')][_0x1279('0x1f')]}));}}}else{_0xeebf04[_0x1279('0x21')](dbH['sequelize'][_0x1279('0x17')](QUERY,{'type':dbH[_0x1279('0x16')]['QueryTypes'][_0x1279('0x1f')]}));}var _0x8b2bf0=path[_0x1279('0x22')](PATH);var _0x45750c=path[_0x1279('0x23')](PATH,_0x1279('0x24'));var _0x49602b=_0xffc4be[_0x1279('0x13')]&&_0xeebf04[_0x1279('0x1b')]>0x1;var _0x52e179=[];if(!fs['existsSync'](path['join'](_0x8b2bf0,_0x45750c))&&_0x49602b){fs['mkdirSync'](path['join'](_0x8b2bf0,_0x45750c));}return BPromise['each'](_0xeebf04,function(_0x546bb2){_0x52e179[_0x1279('0x21')](_0x546bb2);})[_0x1279('0x15')](function(){for(var _0x34b161=0x0;_0x34b161<_0x52e179[_0x1279('0x1b')];_0x34b161+=0x1){var _0x5c0485;var _0x336c06=_0x52e179[_0x34b161];if(_0x49602b){_0x5c0485=path[_0x1279('0x25')](_0x8b2bf0,_0x45750c,util['format']('%s%d.%s',_0x45750c,_0x34b161,_0x1279('0x26')));}else{_0x5c0485=path[_0x1279('0x25')](_0x8b2bf0,util[_0x1279('0xf')](_0x1279('0x27'),_0x45750c,_0x1279('0x26')));}fs['writeFileSync'](_0x5c0485,json2xls(_0x336c06),'binary');}})[_0x1279('0x15')](function(){if(_0x49602b){return new Promise(function(_0x3bff02){zipdir(path[_0x1279('0x25')](_0x8b2bf0,_0x45750c),{'saveTo':path[_0x1279('0x25')](_0x8b2bf0,util[_0x1279('0xf')]('%s.%s',_0x45750c,_0x1279('0x28')))},function(_0x538575,_0x35cf44){rimraf(path[_0x1279('0x25')](_0x8b2bf0,_0x45750c),function(){});_0x3bff02(_0x1279('0x29'));});});}})['then'](function(){logger[_0x1279('0xe')](util[_0x1279('0xf')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x1279('0x2a')));return analyticExtractedReport(_0x1279('0x2b'),_0x49602b?util['format'](_0x1279('0x27'),_0x45750c,_0x49602b?_0x1279('0x28'):'xlsx'):null);});})[_0x1279('0x2c')](function(_0x3847a3){logger[_0x1279('0xe')](util[_0x1279('0xf')](_0x1279('0x2d'),EXTRACTED_REPORT_ID,_0x1279('0x2a')),util[_0x1279('0x2e')](_0x3847a3,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x1279('0x2f'));})[_0x1279('0x30')](function(){process[_0x1279('0x31')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x8a17=['zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','split','length','range','isInteger','forEach','%s\x20limit\x20%d\x20OFFSET\x20%d','push','basename','.xlsx','join','mkdirSync','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','zip','catch','Failed','finally','exit','util','json2xls','bluebird'];(function(_0x434783,_0xff395d){var _0x13efcf=function(_0x235dac){while(--_0x235dac){_0x434783['push'](_0x434783['shift']());}};_0x13efcf(++_0xff395d);}(_0x8a17,0x135));var _0x78a1=function(_0x393d69,_0x3a8c83){_0x393d69=_0x393d69-0x0;var _0x3cee37=_0x8a17[_0x393d69];return _0x3cee37;};'use strict';var util=require(_0x78a1('0x0'));var path=require('path');var _=require('lodash');var fs=require('fs');var json2xls=require(_0x78a1('0x1'));var BPromise=require(_0x78a1('0x2'));var zipdir=require(_0x78a1('0x3'));var rimraf=require(_0x78a1('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x78a1('0x5'))[_0x78a1('0x6')];var logger=require(_0x78a1('0x7'))(_0x78a1('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0x78a1('0x9')][0x2]);var QUERY=process[_0x78a1('0x9')][0x3];var PATH=process[_0x78a1('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x33da2b,_0x5ad6e2){var _0x2fde61={'status':_0x33da2b};var _0x11fb7f={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5ad6e2){_0x2fde61[_0x78a1('0xa')]=_0x5ad6e2;}return db[_0x78a1('0xb')]['update'](_0x2fde61,_0x11fb7f);}function main(){var _0x141fb9=0x1388;var _0x27c9aa;logger[_0x78a1('0xc')](util[_0x78a1('0xd')](_0x78a1('0xe'),EXTRACTED_REPORT_ID,_0x78a1('0xf')));return db[_0x78a1('0x10')][_0x78a1('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x78a1('0x12')]})[_0x78a1('0x13')](function(_0x484fad){if(_0x484fad){_0x27c9aa=_0x484fad;_0x141fb9=_0x27c9aa[_0x78a1('0x12')]||0x1388;}})['then'](function(){return dbH[_0x78a1('0x14')][_0x78a1('0x15')](util['format'](_0x78a1('0x16'),QUERY),{'type':dbH[_0x78a1('0x14')][_0x78a1('0x17')][_0x78a1('0x18')]});})[_0x78a1('0x13')](function(_0x8bb937){if(!_0x8bb937[0x0][_0x78a1('0x19')]){return analyticExtractedReport(_0x78a1('0x1a'));}var _0x23fd49=[];var _0x36a3c4=0x0;if(_0x27c9aa[_0x78a1('0x1b')]){if(_0x8bb937&&_0x8bb937[_0x78a1('0x1c')]){var _0x340f37=_[_0x78a1('0x1d')](_0x8bb937[0x0]['num']/_0x141fb9);var _0x2a1b3b=Number[_0x78a1('0x1e')](_0x8bb937[0x0][_0x78a1('0x19')]/_0x141fb9)?_0x8bb937[0x0][_0x78a1('0x19')]%_0x141fb9:0x0;_0x340f37[_0x78a1('0x1f')](function(_0x2ad9f3){if(_0x2ad9f3>0x0){_0x36a3c4+=_0x141fb9;}_0x23fd49['push'](dbH['sequelize'][_0x78a1('0x15')](util[_0x78a1('0xd')](_0x78a1('0x20'),QUERY,_0x141fb9,_0x36a3c4),{'type':dbH['sequelize'][_0x78a1('0x17')]['SELECT']}));});if(_0x2a1b3b>0x0){_0x36a3c4+=_0x141fb9;_0x23fd49[_0x78a1('0x21')](dbH['sequelize'][_0x78a1('0x15')](util['format'](_0x78a1('0x20'),QUERY,_0x2a1b3b,_0x36a3c4),{'type':dbH['sequelize'][_0x78a1('0x17')][_0x78a1('0x18')]}));}}}else{_0x23fd49[_0x78a1('0x21')](dbH[_0x78a1('0x14')][_0x78a1('0x15')](QUERY,{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}var _0x21c890=path['dirname'](PATH);var _0x53d02a=path[_0x78a1('0x22')](PATH,_0x78a1('0x23'));var _0x37aec5=_0x27c9aa[_0x78a1('0x1b')]&&_0x23fd49['length']>0x1;var _0x42fd0f=[];if(!fs['existsSync'](path[_0x78a1('0x24')](_0x21c890,_0x53d02a))&&_0x37aec5){fs[_0x78a1('0x25')](path[_0x78a1('0x24')](_0x21c890,_0x53d02a));}return BPromise[_0x78a1('0x26')](_0x23fd49,function(_0x4125a4){_0x42fd0f['push'](_0x4125a4);})['then'](function(){for(var _0x44ac64=0x0;_0x44ac64<_0x42fd0f[_0x78a1('0x1c')];_0x44ac64+=0x1){var _0x392c6d;var _0x2b0915=_0x42fd0f[_0x44ac64];if(_0x37aec5){_0x392c6d=path[_0x78a1('0x24')](_0x21c890,_0x53d02a,util['format'](_0x78a1('0x27'),_0x53d02a,_0x44ac64,_0x78a1('0x28')));}else{_0x392c6d=path[_0x78a1('0x24')](_0x21c890,util[_0x78a1('0xd')](_0x78a1('0x29'),_0x53d02a,'xlsx'));}fs[_0x78a1('0x2a')](_0x392c6d,json2xls(_0x2b0915),_0x78a1('0x2b'));}})[_0x78a1('0x13')](function(){if(_0x37aec5){return new Promise(function(_0x59dbdf){zipdir(path[_0x78a1('0x24')](_0x21c890,_0x53d02a),{'saveTo':path['join'](_0x21c890,util[_0x78a1('0xd')]('%s.%s',_0x53d02a,'zip'))},function(_0x28ce6c,_0x4e1d1b){rimraf(path[_0x78a1('0x24')](_0x21c890,_0x53d02a),function(){});_0x59dbdf(_0x78a1('0x2c'));});});}})[_0x78a1('0x13')](function(){logger[_0x78a1('0xc')](util[_0x78a1('0xd')](_0x78a1('0x2d'),EXTRACTED_REPORT_ID,'XLSX'));return analyticExtractedReport(_0x78a1('0x2e'),_0x37aec5?util[_0x78a1('0xd')](_0x78a1('0x29'),_0x53d02a,_0x37aec5?_0x78a1('0x2f'):'xlsx'):null);});})[_0x78a1('0x30')](function(_0x91dab3){logger[_0x78a1('0xc')](util[_0x78a1('0xd')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x78a1('0xf')),util['inspect'](_0x91dab3,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x78a1('0x31'));})[_0x78a1('0x32')](function(){process[_0x78a1('0x33')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff