// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xffa8=['.csv','existsSync','join','mkdirSync','%s%d.%s','csv','%s.%s','writeFileSync','zip','zip\x20finished','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','exit','path','lodash','to-csv','bluebird','rimraf','../../mysqldb','dbH','analytics','argv','savename','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','splitSizeCsv','then','sequelize','SELECT','split','length','range','num','isInteger','push','query','format','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','basename'];(function(_0x1a6976,_0x25b544){var _0x1743e6=function(_0x14fd6d){while(--_0x14fd6d){_0x1a6976['push'](_0x1a6976['shift']());}};_0x1743e6(++_0x25b544);}(_0xffa8,0x1cb));var _0x8ffa=function(_0x14add3,_0x13ce8d){_0x14add3=_0x14add3-0x0;var _0x4a174f=_0xffa8[_0x14add3];return _0x4a174f;};'use strict';var util=require('util');var path=require(_0x8ffa('0x0'));var _=require(_0x8ffa('0x1'));var csv=require(_0x8ffa('0x2'));var fs=require('fs');var BPromise=require(_0x8ffa('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0x8ffa('0x4'));var db=require(_0x8ffa('0x5'))['db'];var dbH=require(_0x8ffa('0x5'))[_0x8ffa('0x6')];var logger=require('../../config/logger')(_0x8ffa('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x8ffa('0x8')][0x2]);var QUERY=process[_0x8ffa('0x8')][0x3];var PATH=process[_0x8ffa('0x8')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2a8d23,_0x5a6a00){var _0x85759f={'status':_0x2a8d23};var _0x2c5d13={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5a6a00){_0x85759f[_0x8ffa('0x9')]=_0x5a6a00;}return db['AnalyticExtractedReport'][_0x8ffa('0xa')](_0x85759f,_0x2c5d13);}function main(){var _0x4cfeb9=0x1388;var _0x35b39b;logger[_0x8ffa('0xb')](util['format'](_0x8ffa('0xc'),EXTRACTED_REPORT_ID,_0x8ffa('0xd')));return db[_0x8ffa('0xe')][_0x8ffa('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x8ffa('0x10')]})[_0x8ffa('0x11')](function(_0x4a19aa){if(_0x4a19aa){_0x35b39b=_0x4a19aa;_0x4cfeb9=_0x35b39b[_0x8ffa('0x10')]||0x1388;}})[_0x8ffa('0x11')](function(){return dbH[_0x8ffa('0x12')]['query'](util['format']('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x8ffa('0x12')]['QueryTypes'][_0x8ffa('0x13')]});})[_0x8ffa('0x11')](function(_0xd0f60d){if(!_0xd0f60d[0x0]['num']){return analyticExtractedReport('Empty');}var _0x4e8af3=[];var _0x5c6f5c=0x0;if(_0x35b39b[_0x8ffa('0x14')]){if(_0xd0f60d&&_0xd0f60d[_0x8ffa('0x15')]){var _0x7b697e=_[_0x8ffa('0x16')](_0xd0f60d[0x0][_0x8ffa('0x17')]/_0x4cfeb9);var _0x513ae1=Number[_0x8ffa('0x18')](_0xd0f60d[0x0]['num']/_0x4cfeb9)?_0xd0f60d[0x0][_0x8ffa('0x17')]%_0x4cfeb9:0x0;_0x7b697e['forEach'](function(_0x17aa7a){if(_0x17aa7a>0x0){_0x5c6f5c+=_0x4cfeb9;}_0x4e8af3[_0x8ffa('0x19')](dbH[_0x8ffa('0x12')][_0x8ffa('0x1a')](util[_0x8ffa('0x1b')](_0x8ffa('0x1c'),QUERY,_0x4cfeb9,_0x5c6f5c),{'type':dbH['sequelize'][_0x8ffa('0x1d')][_0x8ffa('0x13')]}));});if(_0x513ae1>0x0){_0x5c6f5c+=_0x4cfeb9;_0x4e8af3[_0x8ffa('0x19')](dbH[_0x8ffa('0x12')][_0x8ffa('0x1a')](util[_0x8ffa('0x1b')](_0x8ffa('0x1c'),QUERY,_0x513ae1,_0x5c6f5c),{'type':dbH[_0x8ffa('0x12')][_0x8ffa('0x1d')][_0x8ffa('0x13')]}));}}}else{_0x4e8af3[_0x8ffa('0x19')](dbH[_0x8ffa('0x12')][_0x8ffa('0x1a')](QUERY,{'type':dbH['sequelize'][_0x8ffa('0x1d')][_0x8ffa('0x13')]}));}var _0x2160e6=path['dirname'](PATH);var _0x4c4280=path[_0x8ffa('0x1e')](PATH,_0x8ffa('0x1f'));var _0x3ea2fe=_0x35b39b[_0x8ffa('0x14')]&&_0x4e8af3['length']>0x1;var _0x3bba3b=[];if(!fs[_0x8ffa('0x20')](path[_0x8ffa('0x21')](_0x2160e6,_0x4c4280))&&_0x3ea2fe){fs[_0x8ffa('0x22')](path[_0x8ffa('0x21')](_0x2160e6,_0x4c4280));}return BPromise['each'](_0x4e8af3,function(_0x14d9aa){_0x3bba3b[_0x8ffa('0x19')](_0x14d9aa);})[_0x8ffa('0x11')](function(){for(var _0xdf1b81=0x0;_0xdf1b81<_0x3bba3b[_0x8ffa('0x15')];_0xdf1b81+=0x1){var _0x2d7934;var _0x37341e=_0x3bba3b[_0xdf1b81];if(_0x3ea2fe){_0x2d7934=path['join'](_0x2160e6,_0x4c4280,util[_0x8ffa('0x1b')](_0x8ffa('0x23'),_0x4c4280,_0xdf1b81,_0x8ffa('0x24')));}else{_0x2d7934=path[_0x8ffa('0x21')](_0x2160e6,util[_0x8ffa('0x1b')](_0x8ffa('0x25'),_0x4c4280,_0x8ffa('0x24')));}fs[_0x8ffa('0x26')](_0x2d7934,csv(_0x37341e));}})['then'](function(){if(_0x3ea2fe){return new Promise(function(_0x1b849e){zipdir(path[_0x8ffa('0x21')](_0x2160e6,_0x4c4280),{'saveTo':path[_0x8ffa('0x21')](_0x2160e6,util[_0x8ffa('0x1b')](_0x8ffa('0x25'),_0x4c4280,_0x8ffa('0x27')))},function(_0x2af47b,_0x4fba11){rimraf(path['join'](_0x2160e6,_0x4c4280),function(){});_0x1b849e(_0x8ffa('0x28'));});});}})[_0x8ffa('0x11')](function(){logger[_0x8ffa('0xb')](util[_0x8ffa('0x1b')](_0x8ffa('0x29'),EXTRACTED_REPORT_ID,_0x8ffa('0xd')));return analyticExtractedReport(_0x8ffa('0x2a'),_0x3ea2fe?util[_0x8ffa('0x1b')]('%s.%s',_0x4c4280,_0x3ea2fe?_0x8ffa('0x27'):_0x8ffa('0x24')):null);});})[_0x8ffa('0x2b')](function(_0x2185a4){logger[_0x8ffa('0xb')](util[_0x8ffa('0x1b')](_0x8ffa('0x2c'),EXTRACTED_REPORT_ID,_0x8ffa('0xd')),util[_0x8ffa('0x2d')](_0x2185a4,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x8ffa('0x2e'));})[_0x8ffa('0x2f')](function(){process[_0x8ffa('0x30')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x2aa7=['%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','dirname','.csv','join','mkdirSync','csv','%s.%s','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','inspect','Failed','exit','path','lodash','to-csv','bluebird','zip-dir','../../mysqldb','dbH','analytics','argv','savename','AnalyticExtractedReport','info','format','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','num','Empty','length','range','forEach','push'];(function(_0x4a6cf8,_0x5534ef){var _0x22205e=function(_0x3f4d0d){while(--_0x3f4d0d){_0x4a6cf8['push'](_0x4a6cf8['shift']());}};_0x22205e(++_0x5534ef);}(_0x2aa7,0xdf));var _0x72aa=function(_0x59e1b5,_0x33e56e){_0x59e1b5=_0x59e1b5-0x0;var _0x30e9ab=_0x2aa7[_0x59e1b5];return _0x30e9ab;};'use strict';var util=require('util');var path=require(_0x72aa('0x0'));var _=require(_0x72aa('0x1'));var csv=require(_0x72aa('0x2'));var fs=require('fs');var BPromise=require(_0x72aa('0x3'));var zipdir=require(_0x72aa('0x4'));var rimraf=require('rimraf');var db=require(_0x72aa('0x5'))['db'];var dbH=require(_0x72aa('0x5'))[_0x72aa('0x6')];var logger=require('../../config/logger')(_0x72aa('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x72aa('0x8')][0x2]);var QUERY=process[_0x72aa('0x8')][0x3];var PATH=process[_0x72aa('0x8')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x512a43,_0x3753bd){var _0x1a34fc={'status':_0x512a43};var _0x35c6c8={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x3753bd){_0x1a34fc[_0x72aa('0x9')]=_0x3753bd;}return db[_0x72aa('0xa')]['update'](_0x1a34fc,_0x35c6c8);}function main(){var _0x460bff=0x1388;var _0x593a43;logger[_0x72aa('0xb')](util[_0x72aa('0xc')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x72aa('0xd')));return db[_0x72aa('0xe')][_0x72aa('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x72aa('0x10'),_0x72aa('0x11')]})[_0x72aa('0x12')](function(_0x39fc02){if(_0x39fc02){_0x593a43=_0x39fc02;_0x460bff=_0x593a43[_0x72aa('0x11')]||0x1388;}})[_0x72aa('0x12')](function(){return dbH[_0x72aa('0x13')][_0x72aa('0x14')](util['format'](_0x72aa('0x15'),QUERY),{'type':dbH['sequelize']['QueryTypes'][_0x72aa('0x16')]});})['then'](function(_0x537bed){if(!_0x537bed[0x0][_0x72aa('0x17')]){return analyticExtractedReport(_0x72aa('0x18'));}var _0x83b2c5=[];var _0x305b59=0x0;if(_0x593a43['split']){if(_0x537bed&&_0x537bed[_0x72aa('0x19')]){var _0x4b75c7=_[_0x72aa('0x1a')](_0x537bed[0x0]['num']/_0x460bff);var _0x2d1c9a=Number['isInteger'](_0x537bed[0x0][_0x72aa('0x17')]/_0x460bff)?_0x537bed[0x0][_0x72aa('0x17')]%_0x460bff:0x0;_0x4b75c7[_0x72aa('0x1b')](function(_0xb152e5){if(_0xb152e5>0x0){_0x305b59+=_0x460bff;}_0x83b2c5[_0x72aa('0x1c')](dbH[_0x72aa('0x13')]['query'](util[_0x72aa('0xc')](_0x72aa('0x1d'),QUERY,_0x460bff,_0x305b59),{'type':dbH[_0x72aa('0x13')][_0x72aa('0x1e')][_0x72aa('0x16')]}));});if(_0x2d1c9a>0x0){_0x305b59+=_0x460bff;_0x83b2c5[_0x72aa('0x1c')](dbH[_0x72aa('0x13')][_0x72aa('0x14')](util[_0x72aa('0xc')](_0x72aa('0x1d'),QUERY,_0x2d1c9a,_0x305b59),{'type':dbH[_0x72aa('0x13')][_0x72aa('0x1e')][_0x72aa('0x16')]}));}}}else{_0x83b2c5[_0x72aa('0x1c')](dbH[_0x72aa('0x13')][_0x72aa('0x14')](QUERY,{'type':dbH[_0x72aa('0x13')][_0x72aa('0x1e')]['SELECT']}));}var _0x13b5bf=path[_0x72aa('0x1f')](PATH);var _0x4ce6b4=path['basename'](PATH,_0x72aa('0x20'));var _0x1a1ea5=_0x593a43[_0x72aa('0x10')]&&_0x83b2c5['length']>0x1;var _0x40d643=[];if(!fs['existsSync'](path[_0x72aa('0x21')](_0x13b5bf,_0x4ce6b4))&&_0x1a1ea5){fs[_0x72aa('0x22')](path[_0x72aa('0x21')](_0x13b5bf,_0x4ce6b4));}return BPromise['each'](_0x83b2c5,function(_0x1a1e8d){_0x40d643[_0x72aa('0x1c')](_0x1a1e8d);})[_0x72aa('0x12')](function(){for(var _0x312c65=0x0;_0x312c65<_0x40d643[_0x72aa('0x19')];_0x312c65+=0x1){var _0x13b27e;var _0x3fc068=_0x40d643[_0x312c65];if(_0x1a1ea5){_0x13b27e=path[_0x72aa('0x21')](_0x13b5bf,_0x4ce6b4,util[_0x72aa('0xc')]('%s%d.%s',_0x4ce6b4,_0x312c65,_0x72aa('0x23')));}else{_0x13b27e=path[_0x72aa('0x21')](_0x13b5bf,util['format'](_0x72aa('0x24'),_0x4ce6b4,_0x72aa('0x23')));}fs['writeFileSync'](_0x13b27e,csv(_0x3fc068));}})[_0x72aa('0x12')](function(){if(_0x1a1ea5){return new Promise(function(_0x4a6131){zipdir(path[_0x72aa('0x21')](_0x13b5bf,_0x4ce6b4),{'saveTo':path[_0x72aa('0x21')](_0x13b5bf,util[_0x72aa('0xc')](_0x72aa('0x24'),_0x4ce6b4,_0x72aa('0x25')))},function(_0x36af80,_0x2e5d74){rimraf(path[_0x72aa('0x21')](_0x13b5bf,_0x4ce6b4),function(){});_0x4a6131('zip\x20finished');});});}})[_0x72aa('0x12')](function(){logger[_0x72aa('0xb')](util[_0x72aa('0xc')](_0x72aa('0x26'),EXTRACTED_REPORT_ID,_0x72aa('0xd')));return analyticExtractedReport('Completed',_0x1a1ea5?util['format'](_0x72aa('0x24'),_0x4ce6b4,_0x1a1ea5?_0x72aa('0x25'):_0x72aa('0x23')):null);});})['catch'](function(_0x2c0ffc){logger[_0x72aa('0xb')](util[_0x72aa('0xc')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'CSV'),util[_0x72aa('0x27')](_0x2c0ffc,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x72aa('0x28'));})['finally'](function(){process[_0x72aa('0x29')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff