// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xaed7=['csv','%s.%s','writeFileSync','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','zip','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','path','lodash','to-csv','bluebird','zip-dir','../../mysqldb','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','splitSizeCsv','then','sequelize','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','num','Empty','length','range','isInteger','forEach','push','format','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','query','dirname','existsSync','join','mkdirSync','each'];(function(_0x337133,_0x46646d){var _0x1bfed5=function(_0x2fb293){while(--_0x2fb293){_0x337133['push'](_0x337133['shift']());}};_0x1bfed5(++_0x46646d);}(_0xaed7,0x75));var _0x7aed=function(_0x3c5909,_0x2324bd){_0x3c5909=_0x3c5909-0x0;var _0x28f828=_0xaed7[_0x3c5909];return _0x28f828;};'use strict';var util=require('util');var path=require(_0x7aed('0x0'));var _=require(_0x7aed('0x1'));var csv=require(_0x7aed('0x2'));var fs=require('fs');var BPromise=require(_0x7aed('0x3'));var zipdir=require(_0x7aed('0x4'));var rimraf=require('rimraf');var db=require('../../mysqldb')['db'];var dbH=require(_0x7aed('0x5'))['dbH'];var logger=require(_0x7aed('0x6'))(_0x7aed('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x7aed('0x8')][0x2]);var QUERY=process[_0x7aed('0x8')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x3b6dc3,_0x56732b){var _0x28b567={'status':_0x3b6dc3};var _0x224d8b={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x56732b){_0x28b567[_0x7aed('0x9')]=_0x56732b;}return db[_0x7aed('0xa')][_0x7aed('0xb')](_0x28b567,_0x224d8b);}function main(){var _0x3043d3=0x1388;var _0x5c3987;logger[_0x7aed('0xc')](util['format'](_0x7aed('0xd'),EXTRACTED_REPORT_ID,_0x7aed('0xe')));return db[_0x7aed('0xf')][_0x7aed('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x7aed('0x11'),_0x7aed('0x12')]})[_0x7aed('0x13')](function(_0x4c8692){if(_0x4c8692){_0x5c3987=_0x4c8692;_0x3043d3=_0x5c3987[_0x7aed('0x12')]||0x1388;}})[_0x7aed('0x13')](function(){return dbH[_0x7aed('0x14')]['query'](util['format'](_0x7aed('0x15'),QUERY),{'type':dbH[_0x7aed('0x14')]['QueryTypes']['SELECT']});})[_0x7aed('0x13')](function(_0x320788){if(!_0x320788[0x0][_0x7aed('0x16')]){return analyticExtractedReport(_0x7aed('0x17'));}var _0x3a075=[];var _0x4b2c75=0x0;if(_0x5c3987[_0x7aed('0x11')]){if(_0x320788&&_0x320788[_0x7aed('0x18')]){var _0x4bdf5f=_[_0x7aed('0x19')](_0x320788[0x0][_0x7aed('0x16')]/_0x3043d3);var _0x1073e2=Number[_0x7aed('0x1a')](_0x320788[0x0][_0x7aed('0x16')]/_0x3043d3)?_0x320788[0x0][_0x7aed('0x16')]%_0x3043d3:0x0;_0x4bdf5f[_0x7aed('0x1b')](function(_0x13931d){if(_0x13931d>0x0){_0x4b2c75+=_0x3043d3;}_0x3a075[_0x7aed('0x1c')](dbH[_0x7aed('0x14')]['query'](util[_0x7aed('0x1d')](_0x7aed('0x1e'),QUERY,_0x3043d3,_0x4b2c75),{'type':dbH['sequelize'][_0x7aed('0x1f')][_0x7aed('0x20')]}));});if(_0x1073e2>0x0){_0x4b2c75+=_0x3043d3;_0x3a075[_0x7aed('0x1c')](dbH['sequelize'][_0x7aed('0x21')](util[_0x7aed('0x1d')](_0x7aed('0x1e'),QUERY,_0x1073e2,_0x4b2c75),{'type':dbH[_0x7aed('0x14')][_0x7aed('0x1f')][_0x7aed('0x20')]}));}}}else{_0x3a075[_0x7aed('0x1c')](dbH['sequelize'][_0x7aed('0x21')](QUERY,{'type':dbH[_0x7aed('0x14')][_0x7aed('0x1f')][_0x7aed('0x20')]}));}var _0x42f60d=path[_0x7aed('0x22')](PATH);var _0x2a8b31=path['basename'](PATH,'.csv');var _0x587629=_0x5c3987[_0x7aed('0x11')]&&_0x3a075[_0x7aed('0x18')]>0x1;var _0x46ac30=[];if(!fs[_0x7aed('0x23')](path[_0x7aed('0x24')](_0x42f60d,_0x2a8b31))&&_0x587629){fs[_0x7aed('0x25')](path[_0x7aed('0x24')](_0x42f60d,_0x2a8b31));}return BPromise[_0x7aed('0x26')](_0x3a075,function(_0x42b02a){_0x46ac30[_0x7aed('0x1c')](_0x42b02a);})[_0x7aed('0x13')](function(){for(var _0x4da380=0x0;_0x4da380<_0x46ac30[_0x7aed('0x18')];_0x4da380+=0x1){var _0x40ccd8;var _0xc543dc=_0x46ac30[_0x4da380];if(_0x587629){_0x40ccd8=path[_0x7aed('0x24')](_0x42f60d,_0x2a8b31,util['format']('%s%d.%s',_0x2a8b31,_0x4da380,_0x7aed('0x27')));}else{_0x40ccd8=path['join'](_0x42f60d,util[_0x7aed('0x1d')](_0x7aed('0x28'),_0x2a8b31,_0x7aed('0x27')));}fs[_0x7aed('0x29')](_0x40ccd8,csv(_0xc543dc));}})[_0x7aed('0x13')](function(){if(_0x587629){return new Promise(function(_0x9c5bd8){zipdir(path[_0x7aed('0x24')](_0x42f60d,_0x2a8b31),{'saveTo':path[_0x7aed('0x24')](_0x42f60d,util[_0x7aed('0x1d')](_0x7aed('0x28'),_0x2a8b31,'zip'))},function(_0x154323,_0x25d609){rimraf(path['join'](_0x42f60d,_0x2a8b31),function(){});_0x9c5bd8(_0x7aed('0x2a'));});});}})['then'](function(){logger['info'](util[_0x7aed('0x1d')](_0x7aed('0x2b'),EXTRACTED_REPORT_ID,_0x7aed('0xe')));return analyticExtractedReport(_0x7aed('0x2c'),_0x587629?util[_0x7aed('0x1d')](_0x7aed('0x28'),_0x2a8b31,_0x587629?_0x7aed('0x2d'):_0x7aed('0x27')):null);});})[_0x7aed('0x2e')](function(_0x20d73d){logger[_0x7aed('0xc')](util['format'](_0x7aed('0x2f'),EXTRACTED_REPORT_ID,_0x7aed('0xe')),util[_0x7aed('0x30')](_0x20d73d,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x7aed('0x31'));})[_0x7aed('0x32')](function(){process[_0x7aed('0x33')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xa7e4=['update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','then','splitSizeCsv','sequelize','query','format','SELECT','num','length','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','.csv','existsSync','join','mkdirSync','each','csv','%s.%s','zip\x20finished','Completed','zip','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','exit','util','path','lodash','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','savename','AnalyticExtractedReport'];(function(_0x40e282,_0x249007){var _0x1254e5=function(_0x5affca){while(--_0x5affca){_0x40e282['push'](_0x40e282['shift']());}};_0x1254e5(++_0x249007);}(_0xa7e4,0xd0));var _0x4a7e=function(_0x255d5b,_0x4f6f35){_0x255d5b=_0x255d5b-0x0;var _0x3e141a=_0xa7e4[_0x255d5b];return _0x3e141a;};'use strict';var util=require(_0x4a7e('0x0'));var path=require(_0x4a7e('0x1'));var _=require(_0x4a7e('0x2'));var csv=require('to-csv');var fs=require('fs');var BPromise=require(_0x4a7e('0x3'));var zipdir=require(_0x4a7e('0x4'));var rimraf=require(_0x4a7e('0x5'));var db=require(_0x4a7e('0x6'))['db'];var dbH=require('../../mysqldb')[_0x4a7e('0x7')];var logger=require(_0x4a7e('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x4a7e('0x9')][0x2]);var QUERY=process[_0x4a7e('0x9')][0x3];var PATH=process[_0x4a7e('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x5d72b0,_0x4932fb){var _0x489444={'status':_0x5d72b0};var _0x485ed9={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4932fb){_0x489444[_0x4a7e('0xa')]=_0x4932fb;}return db[_0x4a7e('0xb')][_0x4a7e('0xc')](_0x489444,_0x485ed9);}function main(){var _0x3ef4b3=0x1388;var _0x4117a8;logger[_0x4a7e('0xd')](util['format'](_0x4a7e('0xe'),EXTRACTED_REPORT_ID,'CSV'));return db[_0x4a7e('0xf')][_0x4a7e('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x4a7e('0x11'),'splitSizeCsv']})[_0x4a7e('0x12')](function(_0x20ea26){if(_0x20ea26){_0x4117a8=_0x20ea26;_0x3ef4b3=_0x4117a8[_0x4a7e('0x13')]||0x1388;}})[_0x4a7e('0x12')](function(){return dbH[_0x4a7e('0x14')][_0x4a7e('0x15')](util[_0x4a7e('0x16')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x4a7e('0x14')]['QueryTypes'][_0x4a7e('0x17')]});})[_0x4a7e('0x12')](function(_0x11acba){if(!_0x11acba[0x0][_0x4a7e('0x18')]){return analyticExtractedReport('Empty');}var _0x1303f3=[];var _0x3fb666=0x0;if(_0x4117a8[_0x4a7e('0x11')]){if(_0x11acba&&_0x11acba[_0x4a7e('0x19')]){var _0x38bc41=_['range'](_0x11acba[0x0]['num']/_0x3ef4b3);var _0x2f034a=Number[_0x4a7e('0x1a')](_0x11acba[0x0][_0x4a7e('0x18')]/_0x3ef4b3)?_0x11acba[0x0][_0x4a7e('0x18')]%_0x3ef4b3:0x0;_0x38bc41[_0x4a7e('0x1b')](function(_0x3867c8){if(_0x3867c8>0x0){_0x3fb666+=_0x3ef4b3;}_0x1303f3[_0x4a7e('0x1c')](dbH[_0x4a7e('0x14')][_0x4a7e('0x15')](util[_0x4a7e('0x16')](_0x4a7e('0x1d'),QUERY,_0x3ef4b3,_0x3fb666),{'type':dbH[_0x4a7e('0x14')]['QueryTypes']['SELECT']}));});if(_0x2f034a>0x0){_0x3fb666+=_0x3ef4b3;_0x1303f3[_0x4a7e('0x1c')](dbH[_0x4a7e('0x14')][_0x4a7e('0x15')](util['format'](_0x4a7e('0x1d'),QUERY,_0x2f034a,_0x3fb666),{'type':dbH[_0x4a7e('0x14')][_0x4a7e('0x1e')][_0x4a7e('0x17')]}));}}}else{_0x1303f3['push'](dbH[_0x4a7e('0x14')]['query'](QUERY,{'type':dbH[_0x4a7e('0x14')][_0x4a7e('0x1e')][_0x4a7e('0x17')]}));}var _0x393e97=path['dirname'](PATH);var _0x59955c=path['basename'](PATH,_0x4a7e('0x1f'));var _0x2e7edb=_0x4117a8[_0x4a7e('0x11')]&&_0x1303f3['length']>0x1;var _0x3d5d08=[];if(!fs[_0x4a7e('0x20')](path[_0x4a7e('0x21')](_0x393e97,_0x59955c))&&_0x2e7edb){fs[_0x4a7e('0x22')](path['join'](_0x393e97,_0x59955c));}return BPromise[_0x4a7e('0x23')](_0x1303f3,function(_0x48102f){_0x3d5d08[_0x4a7e('0x1c')](_0x48102f);})[_0x4a7e('0x12')](function(){for(var _0x53450c=0x0;_0x53450c<_0x3d5d08[_0x4a7e('0x19')];_0x53450c+=0x1){var _0x456071;var _0x19b55d=_0x3d5d08[_0x53450c];if(_0x2e7edb){_0x456071=path[_0x4a7e('0x21')](_0x393e97,_0x59955c,util[_0x4a7e('0x16')]('%s%d.%s',_0x59955c,_0x53450c,_0x4a7e('0x24')));}else{_0x456071=path[_0x4a7e('0x21')](_0x393e97,util[_0x4a7e('0x16')](_0x4a7e('0x25'),_0x59955c,_0x4a7e('0x24')));}fs['writeFileSync'](_0x456071,csv(_0x19b55d));}})[_0x4a7e('0x12')](function(){if(_0x2e7edb){return new Promise(function(_0x500030){zipdir(path['join'](_0x393e97,_0x59955c),{'saveTo':path[_0x4a7e('0x21')](_0x393e97,util['format']('%s.%s',_0x59955c,'zip'))},function(_0x50e992,_0x1d623c){rimraf(path[_0x4a7e('0x21')](_0x393e97,_0x59955c),function(){});_0x500030(_0x4a7e('0x26'));});});}})[_0x4a7e('0x12')](function(){logger[_0x4a7e('0xd')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x4a7e('0x27'),_0x2e7edb?util[_0x4a7e('0x16')](_0x4a7e('0x25'),_0x59955c,_0x2e7edb?_0x4a7e('0x28'):'csv'):null);});})['catch'](function(_0x4af9c7){logger[_0x4a7e('0xd')](util[_0x4a7e('0x16')](_0x4a7e('0x29'),EXTRACTED_REPORT_ID,'CSV'),util['inspect'](_0x4af9c7,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x4a7e('0x2a'));})['finally'](function(){process[_0x4a7e('0x2b')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff