// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5d5d=['join','csv','%s.%s','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','zip','inspect','Failed','finally','exit','util','lodash','to-csv','bluebird','../../mysqldb','dbH','../../config/logger','analytics','argv','update','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','find','split','splitSizeCsv','then','sequelize','num','length','forEach','push','query','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','basename','existsSync','mkdirSync'];(function(_0xed574d,_0x242c08){var _0x32bbd7=function(_0x372c4f){while(--_0x372c4f){_0xed574d['push'](_0xed574d['shift']());}};_0x32bbd7(++_0x242c08);}(_0x5d5d,0xf5));var _0xd5d5=function(_0x2fdea0,_0x35dbe3){_0x2fdea0=_0x2fdea0-0x0;var _0x19db1e=_0x5d5d[_0x2fdea0];return _0x19db1e;};'use strict';var util=require(_0xd5d5('0x0'));var path=require('path');var _=require(_0xd5d5('0x1'));var csv=require(_0xd5d5('0x2'));var fs=require('fs');var BPromise=require(_0xd5d5('0x3'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0xd5d5('0x4'))['db'];var dbH=require(_0xd5d5('0x4'))[_0xd5d5('0x5')];var logger=require(_0xd5d5('0x6'))(_0xd5d5('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0xd5d5('0x8')][0x3];var PATH=process[_0xd5d5('0x8')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x4b75d8,_0x16431d){var _0x1fd131={'status':_0x4b75d8};var _0x285efd={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x16431d){_0x1fd131['savename']=_0x16431d;}return db['AnalyticExtractedReport'][_0xd5d5('0x9')](_0x1fd131,_0x285efd);}function main(){var _0x377589=0x1388;var _0x54b0be;logger['info'](util[_0xd5d5('0xa')](_0xd5d5('0xb'),EXTRACTED_REPORT_ID,'CSV'));return db['Setting'][_0xd5d5('0xc')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xd5d5('0xd'),'splitSizeCsv']})['then'](function(_0x5179b5){if(_0x5179b5){_0x54b0be=_0x5179b5;_0x377589=_0x54b0be[_0xd5d5('0xe')]||0x1388;}})[_0xd5d5('0xf')](function(){return dbH[_0xd5d5('0x10')]['query'](util[_0xd5d5('0xa')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0xd5d5('0x10')]['QueryTypes']['SELECT']});})['then'](function(_0x3c4b66){if(!_0x3c4b66[0x0][_0xd5d5('0x11')]){return analyticExtractedReport('Empty');}var _0x2ad8cb=[];var _0x465e4b=0x0;if(_0x54b0be[_0xd5d5('0xd')]){if(_0x3c4b66&&_0x3c4b66[_0xd5d5('0x12')]){var _0x11f6a4=_['range'](_0x3c4b66[0x0][_0xd5d5('0x11')]/_0x377589);var _0xc2922=Number['isInteger'](_0x3c4b66[0x0][_0xd5d5('0x11')]/_0x377589)?_0x3c4b66[0x0][_0xd5d5('0x11')]%_0x377589:0x0;_0x11f6a4[_0xd5d5('0x13')](function(_0x989af7){if(_0x989af7>0x0){_0x465e4b+=_0x377589;}_0x2ad8cb[_0xd5d5('0x14')](dbH[_0xd5d5('0x10')][_0xd5d5('0x15')](util['format'](_0xd5d5('0x16'),QUERY,_0x377589,_0x465e4b),{'type':dbH['sequelize'][_0xd5d5('0x17')][_0xd5d5('0x18')]}));});if(_0xc2922>0x0){_0x465e4b+=_0x377589;_0x2ad8cb[_0xd5d5('0x14')](dbH[_0xd5d5('0x10')][_0xd5d5('0x15')](util[_0xd5d5('0xa')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0xc2922,_0x465e4b),{'type':dbH[_0xd5d5('0x10')][_0xd5d5('0x17')][_0xd5d5('0x18')]}));}}}else{_0x2ad8cb[_0xd5d5('0x14')](dbH['sequelize'][_0xd5d5('0x15')](QUERY,{'type':dbH['sequelize'][_0xd5d5('0x17')][_0xd5d5('0x18')]}));}var _0x3c25c2=path['dirname'](PATH);var _0x3225ed=path[_0xd5d5('0x19')](PATH,'.csv');var _0x1d6e38=_0x54b0be['split']&&_0x2ad8cb[_0xd5d5('0x12')]>0x1;var _0x41a1a2=[];if(!fs[_0xd5d5('0x1a')](path['join'](_0x3c25c2,_0x3225ed))&&_0x1d6e38){fs[_0xd5d5('0x1b')](path[_0xd5d5('0x1c')](_0x3c25c2,_0x3225ed));}return BPromise['each'](_0x2ad8cb,function(_0xc5c36e){_0x41a1a2['push'](_0xc5c36e);})[_0xd5d5('0xf')](function(){for(var _0x188375=0x0;_0x188375<_0x41a1a2[_0xd5d5('0x12')];_0x188375+=0x1){var _0x34e727;var _0xa0405d=_0x41a1a2[_0x188375];if(_0x1d6e38){_0x34e727=path[_0xd5d5('0x1c')](_0x3c25c2,_0x3225ed,util[_0xd5d5('0xa')]('%s%d.%s',_0x3225ed,_0x188375,_0xd5d5('0x1d')));}else{_0x34e727=path[_0xd5d5('0x1c')](_0x3c25c2,util['format'](_0xd5d5('0x1e'),_0x3225ed,_0xd5d5('0x1d')));}fs['writeFileSync'](_0x34e727,csv(_0xa0405d));}})[_0xd5d5('0xf')](function(){if(_0x1d6e38){return new Promise(function(_0x3270db){zipdir(path[_0xd5d5('0x1c')](_0x3c25c2,_0x3225ed),{'saveTo':path[_0xd5d5('0x1c')](_0x3c25c2,util[_0xd5d5('0xa')](_0xd5d5('0x1e'),_0x3225ed,'zip'))},function(_0x52959d,_0x350e35){rimraf(path[_0xd5d5('0x1c')](_0x3c25c2,_0x3225ed),function(){});_0x3270db('zip\x20finished');});});}})[_0xd5d5('0xf')](function(){logger['info'](util[_0xd5d5('0xa')](_0xd5d5('0x1f'),EXTRACTED_REPORT_ID,_0xd5d5('0x20')));return analyticExtractedReport(_0xd5d5('0x21'),_0x1d6e38?util['format'](_0xd5d5('0x1e'),_0x3225ed,_0x1d6e38?_0xd5d5('0x22'):'csv'):null);});})['catch'](function(_0x446774){logger['info'](util['format']('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xd5d5('0x20')),util[_0xd5d5('0x23')](_0x446774,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xd5d5('0x24'));})[_0xd5d5('0x25')](function(){process[_0xd5d5('0x26')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xfb53=['argv','update','info','format','CSV','find','split','splitSizeCsv','then','sequelize','QueryTypes','SELECT','num','length','isInteger','forEach','query','%s\x20limit\x20%d\x20OFFSET\x20%d','push','dirname','basename','existsSync','join','mkdirSync','each','%s%d.%s','csv','%s.%s','zip\x20finished','zip','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','exit','util','path','lodash','bluebird','rimraf','../../mysqldb','../../config/logger','analytics'];(function(_0x5bf8b5,_0x38ff2a){var _0x2991cd=function(_0x2f19a8){while(--_0x2f19a8){_0x5bf8b5['push'](_0x5bf8b5['shift']());}};_0x2991cd(++_0x38ff2a);}(_0xfb53,0xcf));var _0x3fb5=function(_0x12f1fc,_0x49ff81){_0x12f1fc=_0x12f1fc-0x0;var _0x9e308e=_0xfb53[_0x12f1fc];return _0x9e308e;};'use strict';var util=require(_0x3fb5('0x0'));var path=require(_0x3fb5('0x1'));var _=require(_0x3fb5('0x2'));var csv=require('to-csv');var fs=require('fs');var BPromise=require(_0x3fb5('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0x3fb5('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x3fb5('0x5'))['dbH'];var logger=require(_0x3fb5('0x6'))(_0x3fb5('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x3fb5('0x8')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x33b2c5,_0x39ec3a){var _0x37ba04={'status':_0x33b2c5};var _0x283831={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x39ec3a){_0x37ba04['savename']=_0x39ec3a;}return db['AnalyticExtractedReport'][_0x3fb5('0x9')](_0x37ba04,_0x283831);}function main(){var _0xe219dc=0x1388;var _0x151d3b;logger[_0x3fb5('0xa')](util[_0x3fb5('0xb')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x3fb5('0xc')));return db['Setting'][_0x3fb5('0xd')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x3fb5('0xe'),_0x3fb5('0xf')]})['then'](function(_0x1cac24){if(_0x1cac24){_0x151d3b=_0x1cac24;_0xe219dc=_0x151d3b[_0x3fb5('0xf')]||0x1388;}})[_0x3fb5('0x10')](function(){return dbH[_0x3fb5('0x11')]['query'](util[_0x3fb5('0xb')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x3fb5('0x11')][_0x3fb5('0x12')][_0x3fb5('0x13')]});})['then'](function(_0x16443d){if(!_0x16443d[0x0][_0x3fb5('0x14')]){return analyticExtractedReport('Empty');}var _0x4fbeb7=[];var _0x18b81a=0x0;if(_0x151d3b['split']){if(_0x16443d&&_0x16443d[_0x3fb5('0x15')]){var _0x517b6c=_['range'](_0x16443d[0x0][_0x3fb5('0x14')]/_0xe219dc);var _0x102092=Number[_0x3fb5('0x16')](_0x16443d[0x0][_0x3fb5('0x14')]/_0xe219dc)?_0x16443d[0x0][_0x3fb5('0x14')]%_0xe219dc:0x0;_0x517b6c[_0x3fb5('0x17')](function(_0x5eae03){if(_0x5eae03>0x0){_0x18b81a+=_0xe219dc;}_0x4fbeb7['push'](dbH[_0x3fb5('0x11')][_0x3fb5('0x18')](util[_0x3fb5('0xb')](_0x3fb5('0x19'),QUERY,_0xe219dc,_0x18b81a),{'type':dbH['sequelize'][_0x3fb5('0x12')][_0x3fb5('0x13')]}));});if(_0x102092>0x0){_0x18b81a+=_0xe219dc;_0x4fbeb7['push'](dbH[_0x3fb5('0x11')][_0x3fb5('0x18')](util[_0x3fb5('0xb')](_0x3fb5('0x19'),QUERY,_0x102092,_0x18b81a),{'type':dbH[_0x3fb5('0x11')][_0x3fb5('0x12')][_0x3fb5('0x13')]}));}}}else{_0x4fbeb7[_0x3fb5('0x1a')](dbH[_0x3fb5('0x11')][_0x3fb5('0x18')](QUERY,{'type':dbH[_0x3fb5('0x11')][_0x3fb5('0x12')][_0x3fb5('0x13')]}));}var _0xed8c44=path[_0x3fb5('0x1b')](PATH);var _0x405b9b=path[_0x3fb5('0x1c')](PATH,'.csv');var _0x4a3f75=_0x151d3b[_0x3fb5('0xe')]&&_0x4fbeb7['length']>0x1;var _0x5ce569=[];if(!fs[_0x3fb5('0x1d')](path[_0x3fb5('0x1e')](_0xed8c44,_0x405b9b))&&_0x4a3f75){fs[_0x3fb5('0x1f')](path[_0x3fb5('0x1e')](_0xed8c44,_0x405b9b));}return BPromise[_0x3fb5('0x20')](_0x4fbeb7,function(_0x336fc1){_0x5ce569[_0x3fb5('0x1a')](_0x336fc1);})[_0x3fb5('0x10')](function(){for(var _0x39ac8d=0x0;_0x39ac8d<_0x5ce569[_0x3fb5('0x15')];_0x39ac8d+=0x1){var _0x3b5a16;var _0x2e4df8=_0x5ce569[_0x39ac8d];if(_0x4a3f75){_0x3b5a16=path['join'](_0xed8c44,_0x405b9b,util['format'](_0x3fb5('0x21'),_0x405b9b,_0x39ac8d,_0x3fb5('0x22')));}else{_0x3b5a16=path['join'](_0xed8c44,util[_0x3fb5('0xb')]('%s.%s',_0x405b9b,_0x3fb5('0x22')));}fs['writeFileSync'](_0x3b5a16,csv(_0x2e4df8));}})['then'](function(){if(_0x4a3f75){return new Promise(function(_0x451240){zipdir(path['join'](_0xed8c44,_0x405b9b),{'saveTo':path[_0x3fb5('0x1e')](_0xed8c44,util[_0x3fb5('0xb')](_0x3fb5('0x23'),_0x405b9b,'zip'))},function(_0x5d9da9,_0x3abdd7){rimraf(path[_0x3fb5('0x1e')](_0xed8c44,_0x405b9b),function(){});_0x451240(_0x3fb5('0x24'));});});}})[_0x3fb5('0x10')](function(){logger[_0x3fb5('0xa')](util[_0x3fb5('0xb')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x3fb5('0xc')));return analyticExtractedReport('Completed',_0x4a3f75?util[_0x3fb5('0xb')](_0x3fb5('0x23'),_0x405b9b,_0x4a3f75?_0x3fb5('0x25'):'csv'):null);});})[_0x3fb5('0x26')](function(_0xe15701){logger[_0x3fb5('0xa')](util[_0x3fb5('0xb')](_0x3fb5('0x27'),EXTRACTED_REPORT_ID,_0x3fb5('0xc')),util[_0x3fb5('0x28')](_0xe15701,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x3fb5('0x29'));})['finally'](function(){process[_0x3fb5('0x2a')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff