// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc2c4=['info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','splitSizeCsv','then','sequelize','query','format','QueryTypes','num','split','length','range','isInteger','push','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','dirname','basename','join','mkdirSync','%s%d.%s','csv','writeFileSync','%s.%s','zip','zip\x20finished','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','util','path','lodash','../../mysqldb','dbH','../../config/logger','argv','savename','AnalyticExtractedReport','update'];(function(_0x9ddbdb,_0x559bb1){var _0x7a4a74=function(_0x2a053d){while(--_0x2a053d){_0x9ddbdb['push'](_0x9ddbdb['shift']());}};_0x7a4a74(++_0x559bb1);}(_0xc2c4,0x156));var _0x4c2c=function(_0x5deff9,_0x4cb0ad){_0x5deff9=_0x5deff9-0x0;var _0x42edf6=_0xc2c4[_0x5deff9];return _0x42edf6;};'use strict';var util=require(_0x4c2c('0x0'));var path=require(_0x4c2c('0x1'));var _=require(_0x4c2c('0x2'));var csv=require('to-csv');var fs=require('fs');var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0x4c2c('0x3'))['db'];var dbH=require(_0x4c2c('0x3'))[_0x4c2c('0x4')];var logger=require(_0x4c2c('0x5'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x4c2c('0x6')][0x2]);var QUERY=process[_0x4c2c('0x6')][0x3];var PATH=process[_0x4c2c('0x6')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x5efe5d,_0x3da816){var _0x1b046d={'status':_0x5efe5d};var _0x4af717={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x3da816){_0x1b046d[_0x4c2c('0x7')]=_0x3da816;}return db[_0x4c2c('0x8')][_0x4c2c('0x9')](_0x1b046d,_0x4af717);}function main(){var _0x32f7be=0x1388;var _0x150b67;logger[_0x4c2c('0xa')](util['format'](_0x4c2c('0xb'),EXTRACTED_REPORT_ID,_0x4c2c('0xc')));return db['Setting']['find']({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x4c2c('0xd')]})[_0x4c2c('0xe')](function(_0x828d14){if(_0x828d14){_0x150b67=_0x828d14;_0x32f7be=_0x150b67[_0x4c2c('0xd')]||0x1388;}})[_0x4c2c('0xe')](function(){return dbH[_0x4c2c('0xf')][_0x4c2c('0x10')](util[_0x4c2c('0x11')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x4c2c('0xf')][_0x4c2c('0x12')]['SELECT']});})[_0x4c2c('0xe')](function(_0x475e5){if(!_0x475e5[0x0][_0x4c2c('0x13')]){return analyticExtractedReport('Empty');}var _0x5e64b3=[];var _0x32ba17=0x0;if(_0x150b67[_0x4c2c('0x14')]){if(_0x475e5&&_0x475e5[_0x4c2c('0x15')]){var _0x4df83a=_[_0x4c2c('0x16')](_0x475e5[0x0]['num']/_0x32f7be);var _0x5ce05a=Number[_0x4c2c('0x17')](_0x475e5[0x0]['num']/_0x32f7be)?_0x475e5[0x0]['num']%_0x32f7be:0x0;_0x4df83a['forEach'](function(_0x2aac6b){if(_0x2aac6b>0x0){_0x32ba17+=_0x32f7be;}_0x5e64b3[_0x4c2c('0x18')](dbH['sequelize'][_0x4c2c('0x10')](util['format'](_0x4c2c('0x19'),QUERY,_0x32f7be,_0x32ba17),{'type':dbH[_0x4c2c('0xf')][_0x4c2c('0x12')][_0x4c2c('0x1a')]}));});if(_0x5ce05a>0x0){_0x32ba17+=_0x32f7be;_0x5e64b3[_0x4c2c('0x18')](dbH[_0x4c2c('0xf')]['query'](util[_0x4c2c('0x11')](_0x4c2c('0x19'),QUERY,_0x5ce05a,_0x32ba17),{'type':dbH[_0x4c2c('0xf')][_0x4c2c('0x12')][_0x4c2c('0x1a')]}));}}}else{_0x5e64b3[_0x4c2c('0x18')](dbH['sequelize'][_0x4c2c('0x10')](QUERY,{'type':dbH[_0x4c2c('0xf')][_0x4c2c('0x12')][_0x4c2c('0x1a')]}));}var _0x201451=path[_0x4c2c('0x1b')](PATH);var _0x1ae06e=path[_0x4c2c('0x1c')](PATH,'.csv');var _0x4b3a3b=_0x150b67['split']&&_0x5e64b3[_0x4c2c('0x15')]>0x1;var _0x5b9882=[];if(!fs['existsSync'](path[_0x4c2c('0x1d')](_0x201451,_0x1ae06e))&&_0x4b3a3b){fs[_0x4c2c('0x1e')](path[_0x4c2c('0x1d')](_0x201451,_0x1ae06e));}return BPromise['each'](_0x5e64b3,function(_0x55be25){_0x5b9882[_0x4c2c('0x18')](_0x55be25);})['then'](function(){for(var _0x22afaa=0x0;_0x22afaa<_0x5b9882[_0x4c2c('0x15')];_0x22afaa+=0x1){var _0x4b9a8d;var _0x4000c9=_0x5b9882[_0x22afaa];if(_0x4b3a3b){_0x4b9a8d=path[_0x4c2c('0x1d')](_0x201451,_0x1ae06e,util[_0x4c2c('0x11')](_0x4c2c('0x1f'),_0x1ae06e,_0x22afaa,_0x4c2c('0x20')));}else{_0x4b9a8d=path['join'](_0x201451,util[_0x4c2c('0x11')]('%s.%s',_0x1ae06e,'csv'));}fs[_0x4c2c('0x21')](_0x4b9a8d,csv(_0x4000c9));}})[_0x4c2c('0xe')](function(){if(_0x4b3a3b){return new Promise(function(_0x4a3027){zipdir(path[_0x4c2c('0x1d')](_0x201451,_0x1ae06e),{'saveTo':path[_0x4c2c('0x1d')](_0x201451,util[_0x4c2c('0x11')](_0x4c2c('0x22'),_0x1ae06e,_0x4c2c('0x23')))},function(_0x38310e,_0x8267e1){rimraf(path['join'](_0x201451,_0x1ae06e),function(){});_0x4a3027(_0x4c2c('0x24'));});});}})[_0x4c2c('0xe')](function(){logger[_0x4c2c('0xa')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x4c2c('0x25'),_0x4b3a3b?util[_0x4c2c('0x11')](_0x4c2c('0x22'),_0x1ae06e,_0x4b3a3b?'zip':_0x4c2c('0x20')):null);});})[_0x4c2c('0x26')](function(_0x1d3a3c){logger['info'](util[_0x4c2c('0x11')](_0x4c2c('0x27'),EXTRACTED_REPORT_ID,_0x4c2c('0xc')),util[_0x4c2c('0x28')](_0x1d3a3c,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x4c2c('0x29'));})[_0x4c2c('0x2a')](function(){process[_0x4c2c('0x2b')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x7afb=['CSV','Setting','find','split','then','splitSizeCsv','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','range','isInteger','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','.csv','existsSync','mkdirSync','each','csv','join','%s.%s','writeFileSync','info','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','zip','inspect','Failed','util','path','bluebird','zip-dir','../../mysqldb','../../config/logger','argv','savename','AnalyticExtractedReport','update','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format'];(function(_0x19dcec,_0x17ec91){var _0x16c21e=function(_0x3b22c5){while(--_0x3b22c5){_0x19dcec['push'](_0x19dcec['shift']());}};_0x16c21e(++_0x17ec91);}(_0x7afb,0xd5));var _0xb7af=function(_0x4c89e6,_0xa48bd5){_0x4c89e6=_0x4c89e6-0x0;var _0x45126f=_0x7afb[_0x4c89e6];return _0x45126f;};'use strict';var util=require(_0xb7af('0x0'));var path=require(_0xb7af('0x1'));var _=require('lodash');var csv=require('to-csv');var fs=require('fs');var BPromise=require(_0xb7af('0x2'));var zipdir=require(_0xb7af('0x3'));var rimraf=require('rimraf');var db=require('../../mysqldb')['db'];var dbH=require(_0xb7af('0x4'))['dbH'];var logger=require(_0xb7af('0x5'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0xb7af('0x6')][0x2]);var QUERY=process[_0xb7af('0x6')][0x3];var PATH=process[_0xb7af('0x6')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x357c0b,_0x455a07){var _0x1bee1c={'status':_0x357c0b};var _0x4d6397={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x455a07){_0x1bee1c[_0xb7af('0x7')]=_0x455a07;}return db[_0xb7af('0x8')][_0xb7af('0x9')](_0x1bee1c,_0x4d6397);}function main(){var _0x594d84=0x1388;var _0xa4baa3;logger['info'](util[_0xb7af('0xa')](_0xb7af('0xb'),EXTRACTED_REPORT_ID,_0xb7af('0xc')));return db[_0xb7af('0xd')][_0xb7af('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xb7af('0xf'),'splitSizeCsv']})[_0xb7af('0x10')](function(_0x2e3530){if(_0x2e3530){_0xa4baa3=_0x2e3530;_0x594d84=_0xa4baa3[_0xb7af('0x11')]||0x1388;}})['then'](function(){return dbH[_0xb7af('0x12')][_0xb7af('0x13')](util[_0xb7af('0xa')](_0xb7af('0x14'),QUERY),{'type':dbH[_0xb7af('0x12')][_0xb7af('0x15')][_0xb7af('0x16')]});})['then'](function(_0x2e2132){if(!_0x2e2132[0x0][_0xb7af('0x17')]){return analyticExtractedReport(_0xb7af('0x18'));}var _0x3fd2ff=[];var _0x11a0e2=0x0;if(_0xa4baa3[_0xb7af('0xf')]){if(_0x2e2132&&_0x2e2132[_0xb7af('0x19')]){var _0x2b43ea=_[_0xb7af('0x1a')](_0x2e2132[0x0][_0xb7af('0x17')]/_0x594d84);var _0x39edcf=Number[_0xb7af('0x1b')](_0x2e2132[0x0][_0xb7af('0x17')]/_0x594d84)?_0x2e2132[0x0][_0xb7af('0x17')]%_0x594d84:0x0;_0x2b43ea['forEach'](function(_0xb8205c){if(_0xb8205c>0x0){_0x11a0e2+=_0x594d84;}_0x3fd2ff[_0xb7af('0x1c')](dbH[_0xb7af('0x12')][_0xb7af('0x13')](util[_0xb7af('0xa')](_0xb7af('0x1d'),QUERY,_0x594d84,_0x11a0e2),{'type':dbH[_0xb7af('0x12')][_0xb7af('0x15')][_0xb7af('0x16')]}));});if(_0x39edcf>0x0){_0x11a0e2+=_0x594d84;_0x3fd2ff[_0xb7af('0x1c')](dbH[_0xb7af('0x12')][_0xb7af('0x13')](util[_0xb7af('0xa')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x39edcf,_0x11a0e2),{'type':dbH[_0xb7af('0x12')][_0xb7af('0x15')][_0xb7af('0x16')]}));}}}else{_0x3fd2ff['push'](dbH[_0xb7af('0x12')][_0xb7af('0x13')](QUERY,{'type':dbH[_0xb7af('0x12')]['QueryTypes'][_0xb7af('0x16')]}));}var _0x2045bb=path[_0xb7af('0x1e')](PATH);var _0x465f17=path['basename'](PATH,_0xb7af('0x1f'));var _0x468bc3=_0xa4baa3[_0xb7af('0xf')]&&_0x3fd2ff['length']>0x1;var _0x357aa3=[];if(!fs[_0xb7af('0x20')](path['join'](_0x2045bb,_0x465f17))&&_0x468bc3){fs[_0xb7af('0x21')](path['join'](_0x2045bb,_0x465f17));}return BPromise[_0xb7af('0x22')](_0x3fd2ff,function(_0x49dcb8){_0x357aa3[_0xb7af('0x1c')](_0x49dcb8);})[_0xb7af('0x10')](function(){for(var _0x21cd2f=0x0;_0x21cd2f<_0x357aa3[_0xb7af('0x19')];_0x21cd2f+=0x1){var _0x1a335f;var _0xa227ef=_0x357aa3[_0x21cd2f];if(_0x468bc3){_0x1a335f=path['join'](_0x2045bb,_0x465f17,util[_0xb7af('0xa')]('%s%d.%s',_0x465f17,_0x21cd2f,_0xb7af('0x23')));}else{_0x1a335f=path[_0xb7af('0x24')](_0x2045bb,util[_0xb7af('0xa')](_0xb7af('0x25'),_0x465f17,_0xb7af('0x23')));}fs[_0xb7af('0x26')](_0x1a335f,csv(_0xa227ef));}})[_0xb7af('0x10')](function(){if(_0x468bc3){return new Promise(function(_0xb5a252){zipdir(path[_0xb7af('0x24')](_0x2045bb,_0x465f17),{'saveTo':path['join'](_0x2045bb,util[_0xb7af('0xa')]('%s.%s',_0x465f17,'zip'))},function(_0x32360c,_0x56037f){rimraf(path['join'](_0x2045bb,_0x465f17),function(){});_0xb5a252('zip\x20finished');});});}})[_0xb7af('0x10')](function(){logger[_0xb7af('0x27')](util[_0xb7af('0xa')](_0xb7af('0x28'),EXTRACTED_REPORT_ID,_0xb7af('0xc')));return analyticExtractedReport(_0xb7af('0x29'),_0x468bc3?util[_0xb7af('0xa')](_0xb7af('0x25'),_0x465f17,_0x468bc3?_0xb7af('0x2a'):_0xb7af('0x23')):null);});})['catch'](function(_0x2fa276){logger[_0xb7af('0x27')](util['format']('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xb7af('0xc')),util[_0xb7af('0x2b')](_0x2fa276,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xb7af('0x2c'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff