// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x95b9=['lodash','to-csv','bluebird','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','find','split','then','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','range','isInteger','forEach','push','sequelize','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.csv','existsSync','join','mkdirSync','each','%s.%s','writeFileSync','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','zip','csv','inspect','Failed','finally','util','path'];(function(_0x57d740,_0x50be99){var _0x6607ef=function(_0x908bd0){while(--_0x908bd0){_0x57d740['push'](_0x57d740['shift']());}};_0x6607ef(++_0x50be99);}(_0x95b9,0xee));var _0x995b=function(_0x197f0a,_0x391726){_0x197f0a=_0x197f0a-0x0;var _0x1256d0=_0x95b9[_0x197f0a];return _0x1256d0;};'use strict';var util=require(_0x995b('0x0'));var path=require(_0x995b('0x1'));var _=require(_0x995b('0x2'));var csv=require(_0x995b('0x3'));var fs=require('fs');var BPromise=require(_0x995b('0x4'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0x995b('0x5'))['db'];var dbH=require(_0x995b('0x5'))[_0x995b('0x6')];var logger=require(_0x995b('0x7'))(_0x995b('0x8'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x995b('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x5d10ac,_0xf20004){var _0x391a5d={'status':_0x5d10ac};var _0x3e55b1={'where':{'id':EXTRACTED_REPORT_ID}};if(_0xf20004){_0x391a5d[_0x995b('0xa')]=_0xf20004;}return db['AnalyticExtractedReport'][_0x995b('0xb')](_0x391a5d,_0x3e55b1);}function main(){var _0x5e7155=0x1388;var _0x330345;logger[_0x995b('0xc')](util['format'](_0x995b('0xd'),EXTRACTED_REPORT_ID,_0x995b('0xe')));return db['Setting'][_0x995b('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x995b('0x10'),'splitSizeCsv']})['then'](function(_0xd0380b){if(_0xd0380b){_0x330345=_0xd0380b;_0x5e7155=_0x330345['splitSizeCsv']||0x1388;}})[_0x995b('0x11')](function(){return dbH['sequelize'][_0x995b('0x12')](util[_0x995b('0x13')](_0x995b('0x14'),QUERY),{'type':dbH['sequelize'][_0x995b('0x15')][_0x995b('0x16')]});})['then'](function(_0x3040c8){if(!_0x3040c8[0x0][_0x995b('0x17')]){return analyticExtractedReport(_0x995b('0x18'));}var _0x1986c8=[];var _0x5bfe48=0x0;if(_0x330345[_0x995b('0x10')]){if(_0x3040c8&&_0x3040c8[_0x995b('0x19')]){var _0x78af5f=_[_0x995b('0x1a')](_0x3040c8[0x0]['num']/_0x5e7155);var _0x42e0c2=Number[_0x995b('0x1b')](_0x3040c8[0x0]['num']/_0x5e7155)?_0x3040c8[0x0]['num']%_0x5e7155:0x0;_0x78af5f[_0x995b('0x1c')](function(_0x2977a5){if(_0x2977a5>0x0){_0x5bfe48+=_0x5e7155;}_0x1986c8[_0x995b('0x1d')](dbH[_0x995b('0x1e')]['query'](util[_0x995b('0x13')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x5e7155,_0x5bfe48),{'type':dbH[_0x995b('0x1e')]['QueryTypes'][_0x995b('0x16')]}));});if(_0x42e0c2>0x0){_0x5bfe48+=_0x5e7155;_0x1986c8[_0x995b('0x1d')](dbH[_0x995b('0x1e')][_0x995b('0x12')](util[_0x995b('0x13')](_0x995b('0x1f'),QUERY,_0x42e0c2,_0x5bfe48),{'type':dbH[_0x995b('0x1e')][_0x995b('0x15')][_0x995b('0x16')]}));}}}else{_0x1986c8['push'](dbH[_0x995b('0x1e')][_0x995b('0x12')](QUERY,{'type':dbH[_0x995b('0x1e')]['QueryTypes']['SELECT']}));}var _0x329fa2=path[_0x995b('0x20')](PATH);var _0x34a999=path[_0x995b('0x21')](PATH,_0x995b('0x22'));var _0x10ee70=_0x330345[_0x995b('0x10')]&&_0x1986c8[_0x995b('0x19')]>0x1;var _0xaeadaa=[];if(!fs[_0x995b('0x23')](path[_0x995b('0x24')](_0x329fa2,_0x34a999))&&_0x10ee70){fs[_0x995b('0x25')](path[_0x995b('0x24')](_0x329fa2,_0x34a999));}return BPromise[_0x995b('0x26')](_0x1986c8,function(_0x4efcdb){_0xaeadaa['push'](_0x4efcdb);})[_0x995b('0x11')](function(){for(var _0x1c9376=0x0;_0x1c9376<_0xaeadaa[_0x995b('0x19')];_0x1c9376+=0x1){var _0x1f8f3a;var _0x1ebe60=_0xaeadaa[_0x1c9376];if(_0x10ee70){_0x1f8f3a=path[_0x995b('0x24')](_0x329fa2,_0x34a999,util[_0x995b('0x13')]('%s%d.%s',_0x34a999,_0x1c9376,'csv'));}else{_0x1f8f3a=path[_0x995b('0x24')](_0x329fa2,util['format'](_0x995b('0x27'),_0x34a999,'csv'));}fs[_0x995b('0x28')](_0x1f8f3a,csv(_0x1ebe60));}})[_0x995b('0x11')](function(){if(_0x10ee70){return new Promise(function(_0x1dcdad){zipdir(path['join'](_0x329fa2,_0x34a999),{'saveTo':path[_0x995b('0x24')](_0x329fa2,util['format'](_0x995b('0x27'),_0x34a999,'zip'))},function(_0x296630,_0x423acc){rimraf(path['join'](_0x329fa2,_0x34a999),function(){});_0x1dcdad(_0x995b('0x29'));});});}})[_0x995b('0x11')](function(){logger[_0x995b('0xc')](util['format'](_0x995b('0x2a'),EXTRACTED_REPORT_ID,_0x995b('0xe')));return analyticExtractedReport('Completed',_0x10ee70?util['format'](_0x995b('0x27'),_0x34a999,_0x10ee70?_0x995b('0x2b'):_0x995b('0x2c')):null);});})['catch'](function(_0x5a648a){logger[_0x995b('0xc')](util[_0x995b('0x13')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x995b('0xe')),util[_0x995b('0x2d')](_0x5a648a,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x995b('0x2e'));})[_0x995b('0x2f')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xc338=['Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','finally','exit','util','lodash','to-csv','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','savename','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','length','range','num','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','basename','existsSync','join','%s%d.%s','csv','writeFileSync','%s.%s','zip','zip\x20finished'];(function(_0x59f7c5,_0x2c7eec){var _0x1dd1f7=function(_0x383760){while(--_0x383760){_0x59f7c5['push'](_0x59f7c5['shift']());}};_0x1dd1f7(++_0x2c7eec);}(_0xc338,0x91));var _0x8c33=function(_0x3ddade,_0x361021){_0x3ddade=_0x3ddade-0x0;var _0x5e279a=_0xc338[_0x3ddade];return _0x5e279a;};'use strict';var util=require(_0x8c33('0x0'));var path=require('path');var _=require(_0x8c33('0x1'));var csv=require(_0x8c33('0x2'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x8c33('0x3'));var rimraf=require(_0x8c33('0x4'));var db=require(_0x8c33('0x5'))['db'];var dbH=require('../../mysqldb')[_0x8c33('0x6')];var logger=require(_0x8c33('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x8c33('0x8')][0x2]);var QUERY=process[_0x8c33('0x8')][0x3];var PATH=process[_0x8c33('0x8')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x97a2d9,_0x2e0f03){var _0x3a1eff={'status':_0x97a2d9};var _0x1b7448={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2e0f03){_0x3a1eff[_0x8c33('0x9')]=_0x2e0f03;}return db['AnalyticExtractedReport'][_0x8c33('0xa')](_0x3a1eff,_0x1b7448);}function main(){var _0x24ea1e=0x1388;var _0x597c08;logger[_0x8c33('0xb')](util[_0x8c33('0xc')](_0x8c33('0xd'),EXTRACTED_REPORT_ID,'CSV'));return db[_0x8c33('0xe')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x8c33('0xf'),_0x8c33('0x10')]})[_0x8c33('0x11')](function(_0x4c118d){if(_0x4c118d){_0x597c08=_0x4c118d;_0x24ea1e=_0x597c08[_0x8c33('0x10')]||0x1388;}})[_0x8c33('0x11')](function(){return dbH[_0x8c33('0x12')][_0x8c33('0x13')](util[_0x8c33('0xc')](_0x8c33('0x14'),QUERY),{'type':dbH[_0x8c33('0x12')][_0x8c33('0x15')][_0x8c33('0x16')]});})[_0x8c33('0x11')](function(_0x2edea6){if(!_0x2edea6[0x0]['num']){return analyticExtractedReport('Empty');}var _0x58fc70=[];var _0x1e888e=0x0;if(_0x597c08['split']){if(_0x2edea6&&_0x2edea6[_0x8c33('0x17')]){var _0x2c4c99=_[_0x8c33('0x18')](_0x2edea6[0x0][_0x8c33('0x19')]/_0x24ea1e);var _0x31c03a=Number[_0x8c33('0x1a')](_0x2edea6[0x0]['num']/_0x24ea1e)?_0x2edea6[0x0][_0x8c33('0x19')]%_0x24ea1e:0x0;_0x2c4c99[_0x8c33('0x1b')](function(_0x2d4598){if(_0x2d4598>0x0){_0x1e888e+=_0x24ea1e;}_0x58fc70[_0x8c33('0x1c')](dbH[_0x8c33('0x12')]['query'](util[_0x8c33('0xc')](_0x8c33('0x1d'),QUERY,_0x24ea1e,_0x1e888e),{'type':dbH['sequelize'][_0x8c33('0x15')]['SELECT']}));});if(_0x31c03a>0x0){_0x1e888e+=_0x24ea1e;_0x58fc70[_0x8c33('0x1c')](dbH['sequelize'][_0x8c33('0x13')](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x31c03a,_0x1e888e),{'type':dbH[_0x8c33('0x12')][_0x8c33('0x15')]['SELECT']}));}}}else{_0x58fc70['push'](dbH['sequelize'][_0x8c33('0x13')](QUERY,{'type':dbH['sequelize']['QueryTypes'][_0x8c33('0x16')]}));}var _0x501e57=path['dirname'](PATH);var _0x2142f6=path[_0x8c33('0x1e')](PATH,'.csv');var _0x9c1b83=_0x597c08[_0x8c33('0xf')]&&_0x58fc70[_0x8c33('0x17')]>0x1;var _0x1e46e0=[];if(!fs[_0x8c33('0x1f')](path[_0x8c33('0x20')](_0x501e57,_0x2142f6))&&_0x9c1b83){fs['mkdirSync'](path[_0x8c33('0x20')](_0x501e57,_0x2142f6));}return BPromise['each'](_0x58fc70,function(_0x1443b8){_0x1e46e0[_0x8c33('0x1c')](_0x1443b8);})[_0x8c33('0x11')](function(){for(var _0xdf5279=0x0;_0xdf5279<_0x1e46e0[_0x8c33('0x17')];_0xdf5279+=0x1){var _0x116447;var _0x1717a4=_0x1e46e0[_0xdf5279];if(_0x9c1b83){_0x116447=path[_0x8c33('0x20')](_0x501e57,_0x2142f6,util['format'](_0x8c33('0x21'),_0x2142f6,_0xdf5279,_0x8c33('0x22')));}else{_0x116447=path[_0x8c33('0x20')](_0x501e57,util['format']('%s.%s',_0x2142f6,_0x8c33('0x22')));}fs[_0x8c33('0x23')](_0x116447,csv(_0x1717a4));}})[_0x8c33('0x11')](function(){if(_0x9c1b83){return new Promise(function(_0x230779){zipdir(path['join'](_0x501e57,_0x2142f6),{'saveTo':path[_0x8c33('0x20')](_0x501e57,util[_0x8c33('0xc')](_0x8c33('0x24'),_0x2142f6,_0x8c33('0x25')))},function(_0x2f95d4,_0x12e295){rimraf(path[_0x8c33('0x20')](_0x501e57,_0x2142f6),function(){});_0x230779(_0x8c33('0x26'));});});}})[_0x8c33('0x11')](function(){logger[_0x8c33('0xb')](util[_0x8c33('0xc')](_0x8c33('0x27'),EXTRACTED_REPORT_ID,_0x8c33('0x28')));return analyticExtractedReport(_0x8c33('0x29'),_0x9c1b83?util[_0x8c33('0xc')](_0x8c33('0x24'),_0x2142f6,_0x9c1b83?_0x8c33('0x25'):_0x8c33('0x22')):null);});})['catch'](function(_0x45868b){logger[_0x8c33('0xb')](util[_0x8c33('0xc')](_0x8c33('0x2a'),EXTRACTED_REPORT_ID,_0x8c33('0x28')),util['inspect'](_0x45868b,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x8c33('0x2b'));})[_0x8c33('0x2c')](function(){process[_0x8c33('0x2d')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff