// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6333=['join','mkdirSync','each','%s%d.%s','csv','%s.%s','writeFileSync','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','util','lodash','to-csv','bluebird','rimraf','../../mysqldb','../../config/logger','analytics','argv','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','range','%s\x20limit\x20%d\x20OFFSET\x20%d','push','basename','.csv','length','existsSync'];(function(_0x31734f,_0xf8b720){var _0x2d1200=function(_0x25f03d){while(--_0x25f03d){_0x31734f['push'](_0x31734f['shift']());}};_0x2d1200(++_0xf8b720);}(_0x6333,0x187));var _0x3633=function(_0xe5438b,_0x7a6e5b){_0xe5438b=_0xe5438b-0x0;var _0x2d3ae0=_0x6333[_0xe5438b];return _0x2d3ae0;};'use strict';var util=require(_0x3633('0x0'));var path=require('path');var _=require(_0x3633('0x1'));var csv=require(_0x3633('0x2'));var fs=require('fs');var BPromise=require(_0x3633('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0x3633('0x4'));var db=require(_0x3633('0x5'))['db'];var dbH=require(_0x3633('0x5'))['dbH'];var logger=require(_0x3633('0x6'))(_0x3633('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x3633('0x8')][0x2]);var QUERY=process[_0x3633('0x8')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x3e5d67,_0x2b9344){var _0x51e4ac={'status':_0x3e5d67};var _0x526ccc={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2b9344){_0x51e4ac['savename']=_0x2b9344;}return db[_0x3633('0x9')]['update'](_0x51e4ac,_0x526ccc);}function main(){var _0x29a5d9=0x1388;var _0x22173f;logger[_0x3633('0xa')](util[_0x3633('0xb')](_0x3633('0xc'),EXTRACTED_REPORT_ID,_0x3633('0xd')));return db[_0x3633('0xe')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x3633('0xf'),_0x3633('0x10')]})['then'](function(_0x3442dd){if(_0x3442dd){_0x22173f=_0x3442dd;_0x29a5d9=_0x22173f['splitSizeCsv']||0x1388;}})[_0x3633('0x11')](function(){return dbH[_0x3633('0x12')][_0x3633('0x13')](util['format'](_0x3633('0x14'),QUERY),{'type':dbH[_0x3633('0x12')][_0x3633('0x15')][_0x3633('0x16')]});})['then'](function(_0x3825a1){if(!_0x3825a1[0x0][_0x3633('0x17')]){return analyticExtractedReport(_0x3633('0x18'));}var _0x1c5fee=[];var _0x23c293=0x0;if(_0x22173f[_0x3633('0xf')]){if(_0x3825a1&&_0x3825a1['length']){var _0xa4ad8=_[_0x3633('0x19')](_0x3825a1[0x0][_0x3633('0x17')]/_0x29a5d9);var _0x285891=Number['isInteger'](_0x3825a1[0x0]['num']/_0x29a5d9)?_0x3825a1[0x0][_0x3633('0x17')]%_0x29a5d9:0x0;_0xa4ad8['forEach'](function(_0x3ac9f7){if(_0x3ac9f7>0x0){_0x23c293+=_0x29a5d9;}_0x1c5fee['push'](dbH[_0x3633('0x12')][_0x3633('0x13')](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x29a5d9,_0x23c293),{'type':dbH[_0x3633('0x12')][_0x3633('0x15')][_0x3633('0x16')]}));});if(_0x285891>0x0){_0x23c293+=_0x29a5d9;_0x1c5fee['push'](dbH[_0x3633('0x12')][_0x3633('0x13')](util[_0x3633('0xb')](_0x3633('0x1a'),QUERY,_0x285891,_0x23c293),{'type':dbH[_0x3633('0x12')][_0x3633('0x15')][_0x3633('0x16')]}));}}}else{_0x1c5fee[_0x3633('0x1b')](dbH[_0x3633('0x12')][_0x3633('0x13')](QUERY,{'type':dbH[_0x3633('0x12')][_0x3633('0x15')]['SELECT']}));}var _0x26a6ca=path['dirname'](PATH);var _0x3084b4=path[_0x3633('0x1c')](PATH,_0x3633('0x1d'));var _0x59b7e7=_0x22173f['split']&&_0x1c5fee[_0x3633('0x1e')]>0x1;var _0x238d0d=[];if(!fs[_0x3633('0x1f')](path[_0x3633('0x20')](_0x26a6ca,_0x3084b4))&&_0x59b7e7){fs[_0x3633('0x21')](path[_0x3633('0x20')](_0x26a6ca,_0x3084b4));}return BPromise[_0x3633('0x22')](_0x1c5fee,function(_0x49019e){_0x238d0d[_0x3633('0x1b')](_0x49019e);})[_0x3633('0x11')](function(){for(var _0x25ddca=0x0;_0x25ddca<_0x238d0d[_0x3633('0x1e')];_0x25ddca+=0x1){var _0x3593d4;var _0x465efb=_0x238d0d[_0x25ddca];if(_0x59b7e7){_0x3593d4=path[_0x3633('0x20')](_0x26a6ca,_0x3084b4,util[_0x3633('0xb')](_0x3633('0x23'),_0x3084b4,_0x25ddca,_0x3633('0x24')));}else{_0x3593d4=path[_0x3633('0x20')](_0x26a6ca,util['format'](_0x3633('0x25'),_0x3084b4,_0x3633('0x24')));}fs[_0x3633('0x26')](_0x3593d4,csv(_0x465efb));}})[_0x3633('0x11')](function(){if(_0x59b7e7){return new Promise(function(_0x487166){zipdir(path['join'](_0x26a6ca,_0x3084b4),{'saveTo':path[_0x3633('0x20')](_0x26a6ca,util[_0x3633('0xb')](_0x3633('0x25'),_0x3084b4,_0x3633('0x27')))},function(_0xd4864b,_0x2a2ac6){rimraf(path['join'](_0x26a6ca,_0x3084b4),function(){});_0x487166('zip\x20finished');});});}})[_0x3633('0x11')](function(){logger[_0x3633('0xa')](util[_0x3633('0xb')](_0x3633('0x28'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x3633('0x29'),_0x59b7e7?util[_0x3633('0xb')](_0x3633('0x25'),_0x3084b4,_0x59b7e7?'zip':_0x3633('0x24')):null);});})[_0x3633('0x2a')](function(_0x503eca){logger[_0x3633('0xa')](util[_0x3633('0xb')](_0x3633('0x2b'),EXTRACTED_REPORT_ID,_0x3633('0xd')),util[_0x3633('0x2c')](_0x503eca,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x3633('0x2d'));})[_0x3633('0x2e')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xb4d4=['length','range','push','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','dirname','basename','existsSync','join','mkdirSync','each','%s%d.%s','csv','%s.%s','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','catch','inspect','exit','lodash','bluebird','zip-dir','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','num','Empty'];(function(_0x29c084,_0x4fdbd7){var _0x2c3639=function(_0x4f4e03){while(--_0x4f4e03){_0x29c084['push'](_0x29c084['shift']());}};_0x2c3639(++_0x4fdbd7);}(_0xb4d4,0x148));var _0x4b4d=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xb4d4[_0x3dd15e];return _0x231fd0;};'use strict';var util=require('util');var path=require('path');var _=require(_0x4b4d('0x0'));var csv=require('to-csv');var fs=require('fs');var BPromise=require(_0x4b4d('0x1'));var zipdir=require(_0x4b4d('0x2'));var rimraf=require('rimraf');var db=require('../../mysqldb')['db'];var dbH=require(_0x4b4d('0x3'))[_0x4b4d('0x4')];var logger=require(_0x4b4d('0x5'))(_0x4b4d('0x6'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x4b4d('0x7')][0x3];var PATH=process[_0x4b4d('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2aed1b,_0x26f761){var _0x4cf682={'status':_0x2aed1b};var _0x4daaad={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x26f761){_0x4cf682[_0x4b4d('0x8')]=_0x26f761;}return db['AnalyticExtractedReport'][_0x4b4d('0x9')](_0x4cf682,_0x4daaad);}function main(){var _0x36c010=0x1388;var _0x4f7e62;logger[_0x4b4d('0xa')](util[_0x4b4d('0xb')](_0x4b4d('0xc'),EXTRACTED_REPORT_ID,'CSV'));return db[_0x4b4d('0xd')][_0x4b4d('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x4b4d('0xf'),'splitSizeCsv']})['then'](function(_0x286ea6){if(_0x286ea6){_0x4f7e62=_0x286ea6;_0x36c010=_0x4f7e62[_0x4b4d('0x10')]||0x1388;}})[_0x4b4d('0x11')](function(){return dbH[_0x4b4d('0x12')][_0x4b4d('0x13')](util['format'](_0x4b4d('0x14'),QUERY),{'type':dbH['sequelize']['QueryTypes'][_0x4b4d('0x15')]});})[_0x4b4d('0x11')](function(_0x5d50d7){if(!_0x5d50d7[0x0][_0x4b4d('0x16')]){return analyticExtractedReport(_0x4b4d('0x17'));}var _0x260ab7=[];var _0x20c4ac=0x0;if(_0x4f7e62[_0x4b4d('0xf')]){if(_0x5d50d7&&_0x5d50d7[_0x4b4d('0x18')]){var _0x4aae02=_[_0x4b4d('0x19')](_0x5d50d7[0x0][_0x4b4d('0x16')]/_0x36c010);var _0x32cee5=Number['isInteger'](_0x5d50d7[0x0]['num']/_0x36c010)?_0x5d50d7[0x0][_0x4b4d('0x16')]%_0x36c010:0x0;_0x4aae02['forEach'](function(_0x165472){if(_0x165472>0x0){_0x20c4ac+=_0x36c010;}_0x260ab7[_0x4b4d('0x1a')](dbH[_0x4b4d('0x12')][_0x4b4d('0x13')](util[_0x4b4d('0xb')](_0x4b4d('0x1b'),QUERY,_0x36c010,_0x20c4ac),{'type':dbH[_0x4b4d('0x12')]['QueryTypes']['SELECT']}));});if(_0x32cee5>0x0){_0x20c4ac+=_0x36c010;_0x260ab7[_0x4b4d('0x1a')](dbH['sequelize'][_0x4b4d('0x13')](util['format'](_0x4b4d('0x1b'),QUERY,_0x32cee5,_0x20c4ac),{'type':dbH[_0x4b4d('0x12')][_0x4b4d('0x1c')][_0x4b4d('0x15')]}));}}}else{_0x260ab7['push'](dbH['sequelize'][_0x4b4d('0x13')](QUERY,{'type':dbH[_0x4b4d('0x12')]['QueryTypes']['SELECT']}));}var _0x31fc6a=path[_0x4b4d('0x1d')](PATH);var _0x5853cb=path[_0x4b4d('0x1e')](PATH,'.csv');var _0x41d3c1=_0x4f7e62['split']&&_0x260ab7[_0x4b4d('0x18')]>0x1;var _0x30b4e6=[];if(!fs[_0x4b4d('0x1f')](path[_0x4b4d('0x20')](_0x31fc6a,_0x5853cb))&&_0x41d3c1){fs[_0x4b4d('0x21')](path['join'](_0x31fc6a,_0x5853cb));}return BPromise[_0x4b4d('0x22')](_0x260ab7,function(_0x54c630){_0x30b4e6[_0x4b4d('0x1a')](_0x54c630);})[_0x4b4d('0x11')](function(){for(var _0x50506b=0x0;_0x50506b<_0x30b4e6['length'];_0x50506b+=0x1){var _0x28844d;var _0x389948=_0x30b4e6[_0x50506b];if(_0x41d3c1){_0x28844d=path[_0x4b4d('0x20')](_0x31fc6a,_0x5853cb,util[_0x4b4d('0xb')](_0x4b4d('0x23'),_0x5853cb,_0x50506b,_0x4b4d('0x24')));}else{_0x28844d=path[_0x4b4d('0x20')](_0x31fc6a,util[_0x4b4d('0xb')](_0x4b4d('0x25'),_0x5853cb,_0x4b4d('0x24')));}fs['writeFileSync'](_0x28844d,csv(_0x389948));}})[_0x4b4d('0x11')](function(){if(_0x41d3c1){return new Promise(function(_0x661565){zipdir(path[_0x4b4d('0x20')](_0x31fc6a,_0x5853cb),{'saveTo':path[_0x4b4d('0x20')](_0x31fc6a,util[_0x4b4d('0xb')]('%s.%s',_0x5853cb,_0x4b4d('0x26')))},function(_0x32f53b,_0x4fefd1){rimraf(path[_0x4b4d('0x20')](_0x31fc6a,_0x5853cb),function(){});_0x661565('zip\x20finished');});});}})[_0x4b4d('0x11')](function(){logger['info'](util['format'](_0x4b4d('0x27'),EXTRACTED_REPORT_ID,_0x4b4d('0x28')));return analyticExtractedReport('Completed',_0x41d3c1?util[_0x4b4d('0xb')](_0x4b4d('0x25'),_0x5853cb,_0x41d3c1?'zip':_0x4b4d('0x24')):null);});})[_0x4b4d('0x29')](function(_0x4f77ba){logger[_0x4b4d('0xa')](util['format']('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x4b4d('0x28')),util[_0x4b4d('0x2a')](_0x4f77ba,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})['finally'](function(){process[_0x4b4d('0x2b')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff