// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1827=['SELECT','num','Empty','range','isInteger','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','split','join','each','length','%s%d.%s','csv','%s.%s','zip','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','exit','util','path','to-csv','bluebird','zip-dir','rimraf','dbH','../../config/logger','analytics','update','info','format','Setting','find','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes'];(function(_0x160662,_0x312a35){var _0x53bcf4=function(_0x49da61){while(--_0x49da61){_0x160662['push'](_0x160662['shift']());}};_0x53bcf4(++_0x312a35);}(_0x1827,0x73));var _0x7182=function(_0x3511d3,_0x4107ae){_0x3511d3=_0x3511d3-0x0;var _0x5d6321=_0x1827[_0x3511d3];return _0x5d6321;};'use strict';var util=require(_0x7182('0x0'));var path=require(_0x7182('0x1'));var _=require('lodash');var csv=require(_0x7182('0x2'));var fs=require('fs');var BPromise=require(_0x7182('0x3'));var zipdir=require(_0x7182('0x4'));var rimraf=require(_0x7182('0x5'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')[_0x7182('0x6')];var logger=require(_0x7182('0x7'))(_0x7182('0x8'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x43de9b,_0x2ff77a){var _0x4bcfde={'status':_0x43de9b};var _0x529eec={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2ff77a){_0x4bcfde['savename']=_0x2ff77a;}return db['AnalyticExtractedReport'][_0x7182('0x9')](_0x4bcfde,_0x529eec);}function main(){var _0x2ac536=0x1388;var _0x4bd227;logger[_0x7182('0xa')](util[_0x7182('0xb')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'CSV'));return db[_0x7182('0xc')][_0x7182('0xd')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x7182('0xe')]})[_0x7182('0xf')](function(_0xf259ce){if(_0xf259ce){_0x4bd227=_0xf259ce;_0x2ac536=_0x4bd227[_0x7182('0xe')]||0x1388;}})[_0x7182('0xf')](function(){return dbH[_0x7182('0x10')][_0x7182('0x11')](util[_0x7182('0xb')](_0x7182('0x12'),QUERY),{'type':dbH[_0x7182('0x10')][_0x7182('0x13')][_0x7182('0x14')]});})[_0x7182('0xf')](function(_0x414d39){if(!_0x414d39[0x0][_0x7182('0x15')]){return analyticExtractedReport(_0x7182('0x16'));}var _0x21d311=[];var _0x3c4160=0x0;if(_0x4bd227['split']){if(_0x414d39&&_0x414d39['length']){var _0x21f593=_[_0x7182('0x17')](_0x414d39[0x0][_0x7182('0x15')]/_0x2ac536);var _0x4feabb=Number[_0x7182('0x18')](_0x414d39[0x0][_0x7182('0x15')]/_0x2ac536)?_0x414d39[0x0][_0x7182('0x15')]%_0x2ac536:0x0;_0x21f593['forEach'](function(_0x186ab9){if(_0x186ab9>0x0){_0x3c4160+=_0x2ac536;}_0x21d311[_0x7182('0x19')](dbH['sequelize'][_0x7182('0x11')](util[_0x7182('0xb')](_0x7182('0x1a'),QUERY,_0x2ac536,_0x3c4160),{'type':dbH['sequelize']['QueryTypes'][_0x7182('0x14')]}));});if(_0x4feabb>0x0){_0x3c4160+=_0x2ac536;_0x21d311[_0x7182('0x19')](dbH[_0x7182('0x10')][_0x7182('0x11')](util[_0x7182('0xb')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x4feabb,_0x3c4160),{'type':dbH[_0x7182('0x10')]['QueryTypes'][_0x7182('0x14')]}));}}}else{_0x21d311[_0x7182('0x19')](dbH[_0x7182('0x10')][_0x7182('0x11')](QUERY,{'type':dbH[_0x7182('0x10')][_0x7182('0x13')][_0x7182('0x14')]}));}var _0x36c3cf=path[_0x7182('0x1b')](PATH);var _0x247c41=path['basename'](PATH,'.csv');var _0x37d1d2=_0x4bd227[_0x7182('0x1c')]&&_0x21d311['length']>0x1;var _0x34b0ea=[];if(!fs['existsSync'](path[_0x7182('0x1d')](_0x36c3cf,_0x247c41))&&_0x37d1d2){fs['mkdirSync'](path[_0x7182('0x1d')](_0x36c3cf,_0x247c41));}return BPromise[_0x7182('0x1e')](_0x21d311,function(_0x350fcb){_0x34b0ea[_0x7182('0x19')](_0x350fcb);})[_0x7182('0xf')](function(){for(var _0x36eb87=0x0;_0x36eb87<_0x34b0ea[_0x7182('0x1f')];_0x36eb87+=0x1){var _0x2cd9c0;var _0x44f169=_0x34b0ea[_0x36eb87];if(_0x37d1d2){_0x2cd9c0=path[_0x7182('0x1d')](_0x36c3cf,_0x247c41,util[_0x7182('0xb')](_0x7182('0x20'),_0x247c41,_0x36eb87,_0x7182('0x21')));}else{_0x2cd9c0=path[_0x7182('0x1d')](_0x36c3cf,util['format'](_0x7182('0x22'),_0x247c41,_0x7182('0x21')));}fs['writeFileSync'](_0x2cd9c0,csv(_0x44f169));}})[_0x7182('0xf')](function(){if(_0x37d1d2){return new Promise(function(_0x74a14c){zipdir(path[_0x7182('0x1d')](_0x36c3cf,_0x247c41),{'saveTo':path['join'](_0x36c3cf,util[_0x7182('0xb')](_0x7182('0x22'),_0x247c41,_0x7182('0x23')))},function(_0xdd8281,_0x1f743d){rimraf(path[_0x7182('0x1d')](_0x36c3cf,_0x247c41),function(){});_0x74a14c(_0x7182('0x24'));});});}})[_0x7182('0xf')](function(){logger[_0x7182('0xa')](util[_0x7182('0xb')](_0x7182('0x25'),EXTRACTED_REPORT_ID,_0x7182('0x26')));return analyticExtractedReport(_0x7182('0x27'),_0x37d1d2?util[_0x7182('0xb')](_0x7182('0x22'),_0x247c41,_0x37d1d2?_0x7182('0x23'):_0x7182('0x21')):null);});})[_0x7182('0x28')](function(_0x2d01f5){logger['info'](util[_0x7182('0xb')](_0x7182('0x29'),EXTRACTED_REPORT_ID,_0x7182('0x26')),util[_0x7182('0x2a')](_0x2d01f5,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x7182('0x2b'));})['finally'](function(){process[_0x7182('0x2c')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xbdf0=['Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','util','path','lodash','to-csv','bluebird','zip-dir','rimraf','../../mysqldb','dbH','argv','savename','update','info','format','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','range','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','.csv','existsSync','join','mkdirSync','each','%s%d.%s','csv','writeFileSync','%s.%s','zip'];(function(_0x3658bb,_0x5f460f){var _0x3d4b64=function(_0x3d298d){while(--_0x3d298d){_0x3658bb['push'](_0x3658bb['shift']());}};_0x3d4b64(++_0x5f460f);}(_0xbdf0,0x1c0));var _0x0bdf=function(_0x18b5fb,_0x36862b){_0x18b5fb=_0x18b5fb-0x0;var _0x56f0e2=_0xbdf0[_0x18b5fb];return _0x56f0e2;};'use strict';var util=require(_0x0bdf('0x0'));var path=require(_0x0bdf('0x1'));var _=require(_0x0bdf('0x2'));var csv=require(_0x0bdf('0x3'));var fs=require('fs');var BPromise=require(_0x0bdf('0x4'));var zipdir=require(_0x0bdf('0x5'));var rimraf=require(_0x0bdf('0x6'));var db=require(_0x0bdf('0x7'))['db'];var dbH=require('../../mysqldb')[_0x0bdf('0x8')];var logger=require('../../config/logger')('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x0bdf('0x9')][0x2]);var QUERY=process[_0x0bdf('0x9')][0x3];var PATH=process[_0x0bdf('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x9ff198,_0x237a73){var _0x930edc={'status':_0x9ff198};var _0x3e439a={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x237a73){_0x930edc[_0x0bdf('0xa')]=_0x237a73;}return db['AnalyticExtractedReport'][_0x0bdf('0xb')](_0x930edc,_0x3e439a);}function main(){var _0x103bb4=0x1388;var _0x526608;logger[_0x0bdf('0xc')](util[_0x0bdf('0xd')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x0bdf('0xe')));return db[_0x0bdf('0xf')][_0x0bdf('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x0bdf('0x11'),_0x0bdf('0x12')]})[_0x0bdf('0x13')](function(_0x418900){if(_0x418900){_0x526608=_0x418900;_0x103bb4=_0x526608[_0x0bdf('0x12')]||0x1388;}})[_0x0bdf('0x13')](function(){return dbH[_0x0bdf('0x14')][_0x0bdf('0x15')](util['format'](_0x0bdf('0x16'),QUERY),{'type':dbH['sequelize'][_0x0bdf('0x17')][_0x0bdf('0x18')]});})[_0x0bdf('0x13')](function(_0x39668f){if(!_0x39668f[0x0][_0x0bdf('0x19')]){return analyticExtractedReport(_0x0bdf('0x1a'));}var _0x29e331=[];var _0xc247a8=0x0;if(_0x526608[_0x0bdf('0x11')]){if(_0x39668f&&_0x39668f[_0x0bdf('0x1b')]){var _0x46a5f9=_[_0x0bdf('0x1c')](_0x39668f[0x0][_0x0bdf('0x19')]/_0x103bb4);var _0x39ca01=Number['isInteger'](_0x39668f[0x0][_0x0bdf('0x19')]/_0x103bb4)?_0x39668f[0x0][_0x0bdf('0x19')]%_0x103bb4:0x0;_0x46a5f9[_0x0bdf('0x1d')](function(_0x5887dd){if(_0x5887dd>0x0){_0xc247a8+=_0x103bb4;}_0x29e331[_0x0bdf('0x1e')](dbH[_0x0bdf('0x14')][_0x0bdf('0x15')](util[_0x0bdf('0xd')](_0x0bdf('0x1f'),QUERY,_0x103bb4,_0xc247a8),{'type':dbH[_0x0bdf('0x14')][_0x0bdf('0x17')][_0x0bdf('0x18')]}));});if(_0x39ca01>0x0){_0xc247a8+=_0x103bb4;_0x29e331['push'](dbH[_0x0bdf('0x14')][_0x0bdf('0x15')](util[_0x0bdf('0xd')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x39ca01,_0xc247a8),{'type':dbH[_0x0bdf('0x14')]['QueryTypes']['SELECT']}));}}}else{_0x29e331[_0x0bdf('0x1e')](dbH[_0x0bdf('0x14')][_0x0bdf('0x15')](QUERY,{'type':dbH['sequelize'][_0x0bdf('0x17')][_0x0bdf('0x18')]}));}var _0xf60302=path['dirname'](PATH);var _0x539d45=path['basename'](PATH,_0x0bdf('0x20'));var _0xdcb926=_0x526608['split']&&_0x29e331['length']>0x1;var _0x5c22b4=[];if(!fs[_0x0bdf('0x21')](path[_0x0bdf('0x22')](_0xf60302,_0x539d45))&&_0xdcb926){fs[_0x0bdf('0x23')](path[_0x0bdf('0x22')](_0xf60302,_0x539d45));}return BPromise[_0x0bdf('0x24')](_0x29e331,function(_0x1bb66b){_0x5c22b4['push'](_0x1bb66b);})[_0x0bdf('0x13')](function(){for(var _0x25d52b=0x0;_0x25d52b<_0x5c22b4[_0x0bdf('0x1b')];_0x25d52b+=0x1){var _0x53449e;var _0x4f1c63=_0x5c22b4[_0x25d52b];if(_0xdcb926){_0x53449e=path['join'](_0xf60302,_0x539d45,util[_0x0bdf('0xd')](_0x0bdf('0x25'),_0x539d45,_0x25d52b,_0x0bdf('0x26')));}else{_0x53449e=path[_0x0bdf('0x22')](_0xf60302,util[_0x0bdf('0xd')]('%s.%s',_0x539d45,_0x0bdf('0x26')));}fs[_0x0bdf('0x27')](_0x53449e,csv(_0x4f1c63));}})['then'](function(){if(_0xdcb926){return new Promise(function(_0x45632b){zipdir(path[_0x0bdf('0x22')](_0xf60302,_0x539d45),{'saveTo':path['join'](_0xf60302,util[_0x0bdf('0xd')](_0x0bdf('0x28'),_0x539d45,_0x0bdf('0x29')))},function(_0xdbc2ce,_0x1e6e0c){rimraf(path['join'](_0xf60302,_0x539d45),function(){});_0x45632b('zip\x20finished');});});}})[_0x0bdf('0x13')](function(){logger[_0x0bdf('0xc')](util[_0x0bdf('0xd')](_0x0bdf('0x2a'),EXTRACTED_REPORT_ID,_0x0bdf('0xe')));return analyticExtractedReport(_0x0bdf('0x2b'),_0xdcb926?util['format'](_0x0bdf('0x28'),_0x539d45,_0xdcb926?'zip':_0x0bdf('0x26')):null);});})['catch'](function(_0x2efbde){logger[_0x0bdf('0xc')](util[_0x0bdf('0xd')](_0x0bdf('0x2c'),EXTRACTED_REPORT_ID,_0x0bdf('0xe')),util[_0x0bdf('0x2d')](_0x2efbde,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x0bdf('0x2e'));})[_0x0bdf('0x2f')](function(){process[_0x0bdf('0x30')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff