// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf672=['exit','util','path','lodash','json2xls','zip-dir','rimraf','../../mysqldb','../../config/logger','analytics','argv','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','split','splitSizeXlsx','sequelize','QueryTypes','SELECT','num','Empty','length','forEach','query','%s\x20limit\x20%d\x20OFFSET\x20%d','push','dirname','basename','existsSync','mkdirSync','join','each','then','%s%d.%s','xlsx','%s.%s','zip','zip\x20finished','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally'];(function(_0x1f56a1,_0x5842d9){var _0x495399=function(_0x866906){while(--_0x866906){_0x1f56a1['push'](_0x1f56a1['shift']());}};_0x495399(++_0x5842d9);}(_0xf672,0xc5));var _0x2f67=function(_0x45d3f0,_0x4be53f){_0x45d3f0=_0x45d3f0-0x0;var _0x314b79=_0xf672[_0x45d3f0];return _0x314b79;};'use strict';var util=require(_0x2f67('0x0'));var path=require(_0x2f67('0x1'));var _=require(_0x2f67('0x2'));var fs=require('fs');var json2xls=require(_0x2f67('0x3'));var BPromise=require('bluebird');var zipdir=require(_0x2f67('0x4'));var rimraf=require(_0x2f67('0x5'));var db=require(_0x2f67('0x6'))['db'];var dbH=require(_0x2f67('0x6'))['dbH'];var logger=require(_0x2f67('0x7'))(_0x2f67('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0x2f67('0x9')][0x2]);var QUERY=process[_0x2f67('0x9')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2cb46f,_0x4fcb30){var _0x4f0106={'status':_0x2cb46f};var _0x32bda0={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4fcb30){_0x4f0106['savename']=_0x4fcb30;}return db[_0x2f67('0xa')][_0x2f67('0xb')](_0x4f0106,_0x32bda0);}function main(){var _0x2a85ca=0x1388;var _0x398bbb;logger[_0x2f67('0xc')](util[_0x2f67('0xd')](_0x2f67('0xe'),EXTRACTED_REPORT_ID,_0x2f67('0xf')));return db[_0x2f67('0x10')][_0x2f67('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x2f67('0x12'),_0x2f67('0x13')]})['then'](function(_0x12ebb4){if(_0x12ebb4){_0x398bbb=_0x12ebb4;_0x2a85ca=_0x398bbb[_0x2f67('0x13')]||0x1388;}})['then'](function(){return dbH[_0x2f67('0x14')]['query'](util[_0x2f67('0xd')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x2f67('0x14')][_0x2f67('0x15')][_0x2f67('0x16')]});})['then'](function(_0x519931){if(!_0x519931[0x0][_0x2f67('0x17')]){return analyticExtractedReport(_0x2f67('0x18'));}var _0x2b2708=[];var _0x34429e=0x0;if(_0x398bbb[_0x2f67('0x12')]){if(_0x519931&&_0x519931[_0x2f67('0x19')]){var _0x116283=_['range'](_0x519931[0x0]['num']/_0x2a85ca);var _0x493bab=Number['isInteger'](_0x519931[0x0]['num']/_0x2a85ca)?_0x519931[0x0][_0x2f67('0x17')]%_0x2a85ca:0x0;_0x116283[_0x2f67('0x1a')](function(_0x53beeb){if(_0x53beeb>0x0){_0x34429e+=_0x2a85ca;}_0x2b2708['push'](dbH[_0x2f67('0x14')][_0x2f67('0x1b')](util[_0x2f67('0xd')](_0x2f67('0x1c'),QUERY,_0x2a85ca,_0x34429e),{'type':dbH[_0x2f67('0x14')]['QueryTypes']['SELECT']}));});if(_0x493bab>0x0){_0x34429e+=_0x2a85ca;_0x2b2708[_0x2f67('0x1d')](dbH[_0x2f67('0x14')]['query'](util[_0x2f67('0xd')](_0x2f67('0x1c'),QUERY,_0x493bab,_0x34429e),{'type':dbH[_0x2f67('0x14')][_0x2f67('0x15')][_0x2f67('0x16')]}));}}}else{_0x2b2708['push'](dbH[_0x2f67('0x14')][_0x2f67('0x1b')](QUERY,{'type':dbH[_0x2f67('0x14')][_0x2f67('0x15')][_0x2f67('0x16')]}));}var _0x5938e4=path[_0x2f67('0x1e')](PATH);var _0x3b43d7=path[_0x2f67('0x1f')](PATH,'.xlsx');var _0x59f257=_0x398bbb[_0x2f67('0x12')]&&_0x2b2708[_0x2f67('0x19')]>0x1;var _0x109483=[];if(!fs[_0x2f67('0x20')](path['join'](_0x5938e4,_0x3b43d7))&&_0x59f257){fs[_0x2f67('0x21')](path[_0x2f67('0x22')](_0x5938e4,_0x3b43d7));}return BPromise[_0x2f67('0x23')](_0x2b2708,function(_0x3d5d02){_0x109483['push'](_0x3d5d02);})[_0x2f67('0x24')](function(){for(var _0x11a039=0x0;_0x11a039<_0x109483['length'];_0x11a039+=0x1){var _0x113c5e;var _0x35c6ca=_0x109483[_0x11a039];if(_0x59f257){_0x113c5e=path[_0x2f67('0x22')](_0x5938e4,_0x3b43d7,util[_0x2f67('0xd')](_0x2f67('0x25'),_0x3b43d7,_0x11a039,_0x2f67('0x26')));}else{_0x113c5e=path[_0x2f67('0x22')](_0x5938e4,util[_0x2f67('0xd')](_0x2f67('0x27'),_0x3b43d7,'xlsx'));}fs['writeFileSync'](_0x113c5e,json2xls(_0x35c6ca),'binary');}})[_0x2f67('0x24')](function(){if(_0x59f257){return new Promise(function(_0x1a4a56){zipdir(path['join'](_0x5938e4,_0x3b43d7),{'saveTo':path['join'](_0x5938e4,util['format'](_0x2f67('0x27'),_0x3b43d7,_0x2f67('0x28')))},function(_0x4ef8db,_0x4f5d4d){rimraf(path[_0x2f67('0x22')](_0x5938e4,_0x3b43d7),function(){});_0x1a4a56(_0x2f67('0x29'));});});}})[_0x2f67('0x24')](function(){logger['info'](util[_0x2f67('0xd')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x2f67('0xf')));return analyticExtractedReport(_0x2f67('0x2a'),_0x59f257?util[_0x2f67('0xd')](_0x2f67('0x27'),_0x3b43d7,_0x59f257?_0x2f67('0x28'):'xlsx'):null);});})[_0x2f67('0x2b')](function(_0xbbb25b){logger['info'](util['format'](_0x2f67('0x2c'),EXTRACTED_REPORT_ID,_0x2f67('0xf')),util[_0x2f67('0x2d')](_0xbbb25b,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x2f67('0x2e'));})[_0x2f67('0x2f')](function(){process[_0x2f67('0x30')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x2b70=['path','json2xls','bluebird','rimraf','../../mysqldb','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','format','XLSX','Setting','split','splitSizeXlsx','then','sequelize','num','length','range','isInteger','forEach','QueryTypes','SELECT','%s\x20limit\x20%d\x20OFFSET\x20%d','push','query','dirname','basename','.xlsx','existsSync','join','mkdirSync','xlsx','%s.%s','writeFileSync','binary','zip','zip\x20finished','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit'];(function(_0x2c02b1,_0x46e653){var _0x333d21=function(_0x54a38c){while(--_0x54a38c){_0x2c02b1['push'](_0x2c02b1['shift']());}};_0x333d21(++_0x46e653);}(_0x2b70,0xc0));var _0x02b7=function(_0x5637a7,_0x3be357){_0x5637a7=_0x5637a7-0x0;var _0x2646b3=_0x2b70[_0x5637a7];return _0x2646b3;};'use strict';var util=require('util');var path=require(_0x02b7('0x0'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0x02b7('0x1'));var BPromise=require(_0x02b7('0x2'));var zipdir=require('zip-dir');var rimraf=require(_0x02b7('0x3'));var db=require('../../mysqldb')['db'];var dbH=require(_0x02b7('0x4'))['dbH'];var logger=require(_0x02b7('0x5'))(_0x02b7('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x02b7('0x7')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x02b7('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2545d4,_0x36e345){var _0x4de7d1={'status':_0x2545d4};var _0x478e3d={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x36e345){_0x4de7d1[_0x02b7('0x8')]=_0x36e345;}return db[_0x02b7('0x9')][_0x02b7('0xa')](_0x4de7d1,_0x478e3d);}function main(){var _0x9ad044=0x1388;var _0x12e3f6;logger[_0x02b7('0xb')](util[_0x02b7('0xc')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x02b7('0xd')));return db[_0x02b7('0xe')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x02b7('0xf'),_0x02b7('0x10')]})['then'](function(_0x1d7bc3){if(_0x1d7bc3){_0x12e3f6=_0x1d7bc3;_0x9ad044=_0x12e3f6[_0x02b7('0x10')]||0x1388;}})[_0x02b7('0x11')](function(){return dbH[_0x02b7('0x12')]['query'](util[_0x02b7('0xc')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x02b7('0x12')]['QueryTypes']['SELECT']});})['then'](function(_0x436123){if(!_0x436123[0x0][_0x02b7('0x13')]){return analyticExtractedReport('Empty');}var _0x5d5ef3=[];var _0x1afe35=0x0;if(_0x12e3f6[_0x02b7('0xf')]){if(_0x436123&&_0x436123[_0x02b7('0x14')]){var _0x19cc2a=_[_0x02b7('0x15')](_0x436123[0x0][_0x02b7('0x13')]/_0x9ad044);var _0xcef925=Number[_0x02b7('0x16')](_0x436123[0x0][_0x02b7('0x13')]/_0x9ad044)?_0x436123[0x0][_0x02b7('0x13')]%_0x9ad044:0x0;_0x19cc2a[_0x02b7('0x17')](function(_0xbe8356){if(_0xbe8356>0x0){_0x1afe35+=_0x9ad044;}_0x5d5ef3['push'](dbH[_0x02b7('0x12')]['query'](util[_0x02b7('0xc')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x9ad044,_0x1afe35),{'type':dbH[_0x02b7('0x12')][_0x02b7('0x18')][_0x02b7('0x19')]}));});if(_0xcef925>0x0){_0x1afe35+=_0x9ad044;_0x5d5ef3['push'](dbH['sequelize']['query'](util[_0x02b7('0xc')](_0x02b7('0x1a'),QUERY,_0xcef925,_0x1afe35),{'type':dbH[_0x02b7('0x12')]['QueryTypes'][_0x02b7('0x19')]}));}}}else{_0x5d5ef3[_0x02b7('0x1b')](dbH[_0x02b7('0x12')][_0x02b7('0x1c')](QUERY,{'type':dbH[_0x02b7('0x12')][_0x02b7('0x18')][_0x02b7('0x19')]}));}var _0x5bca2a=path[_0x02b7('0x1d')](PATH);var _0x138851=path[_0x02b7('0x1e')](PATH,_0x02b7('0x1f'));var _0x465b22=_0x12e3f6[_0x02b7('0xf')]&&_0x5d5ef3[_0x02b7('0x14')]>0x1;var _0x50f6c9=[];if(!fs[_0x02b7('0x20')](path[_0x02b7('0x21')](_0x5bca2a,_0x138851))&&_0x465b22){fs[_0x02b7('0x22')](path[_0x02b7('0x21')](_0x5bca2a,_0x138851));}return BPromise['each'](_0x5d5ef3,function(_0x2fa2b0){_0x50f6c9[_0x02b7('0x1b')](_0x2fa2b0);})['then'](function(){for(var _0x3c6a6a=0x0;_0x3c6a6a<_0x50f6c9['length'];_0x3c6a6a+=0x1){var _0x277050;var _0x3d3b2f=_0x50f6c9[_0x3c6a6a];if(_0x465b22){_0x277050=path['join'](_0x5bca2a,_0x138851,util['format']('%s%d.%s',_0x138851,_0x3c6a6a,_0x02b7('0x23')));}else{_0x277050=path[_0x02b7('0x21')](_0x5bca2a,util[_0x02b7('0xc')](_0x02b7('0x24'),_0x138851,_0x02b7('0x23')));}fs[_0x02b7('0x25')](_0x277050,json2xls(_0x3d3b2f),_0x02b7('0x26'));}})['then'](function(){if(_0x465b22){return new Promise(function(_0x49727b){zipdir(path[_0x02b7('0x21')](_0x5bca2a,_0x138851),{'saveTo':path[_0x02b7('0x21')](_0x5bca2a,util[_0x02b7('0xc')]('%s.%s',_0x138851,_0x02b7('0x27')))},function(_0x71b014,_0x19d13c){rimraf(path[_0x02b7('0x21')](_0x5bca2a,_0x138851),function(){});_0x49727b(_0x02b7('0x28'));});});}})['then'](function(){logger[_0x02b7('0xb')](util[_0x02b7('0xc')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x02b7('0xd')));return analyticExtractedReport(_0x02b7('0x29'),_0x465b22?util['format'](_0x02b7('0x24'),_0x138851,_0x465b22?_0x02b7('0x27'):_0x02b7('0x23')):null);});})[_0x02b7('0x2a')](function(_0x148e97){logger[_0x02b7('0xb')](util['format'](_0x02b7('0x2b'),EXTRACTED_REPORT_ID,_0x02b7('0xd')),util[_0x02b7('0x2c')](_0x148e97,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x02b7('0x2d'));})[_0x02b7('0x2e')](function(){process[_0x02b7('0x2f')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff