// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5df5=['range','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','basename','.csv','split','length','existsSync','join','%s%d.%s','%s.%s','zip','zip\x20finished','Completed','csv','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','lodash','to-csv','bluebird','rimraf','../../mysqldb','analytics','argv','savename','AnalyticExtractedReport','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','splitSizeCsv','then','sequelize','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty'];(function(_0x411017,_0x4a8117){var _0x2adeea=function(_0x545222){while(--_0x545222){_0x411017['push'](_0x411017['shift']());}};_0x2adeea(++_0x4a8117);}(_0x5df5,0xfc));var _0x55df=function(_0x1b2e10,_0x1bb63e){_0x1b2e10=_0x1b2e10-0x0;var _0x161f9e=_0x5df5[_0x1b2e10];return _0x161f9e;};'use strict';var util=require('util');var path=require('path');var _=require(_0x55df('0x0'));var csv=require(_0x55df('0x1'));var fs=require('fs');var BPromise=require(_0x55df('0x2'));var zipdir=require('zip-dir');var rimraf=require(_0x55df('0x3'));var db=require(_0x55df('0x4'))['db'];var dbH=require('../../mysqldb')['dbH'];var logger=require('../../config/logger')(_0x55df('0x5'));var EXTRACTED_REPORT_ID=Number(process[_0x55df('0x6')][0x2]);var QUERY=process[_0x55df('0x6')][0x3];var PATH=process[_0x55df('0x6')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x27d322,_0x395129){var _0x314591={'status':_0x27d322};var _0x1dd1d5={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x395129){_0x314591[_0x55df('0x7')]=_0x395129;}return db[_0x55df('0x8')]['update'](_0x314591,_0x1dd1d5);}function main(){var _0x3ec1ea=0x1388;var _0x24379b;logger[_0x55df('0x9')](util['format'](_0x55df('0xa'),EXTRACTED_REPORT_ID,_0x55df('0xb')));return db[_0x55df('0xc')][_0x55df('0xd')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x55df('0xe')]})['then'](function(_0x4649d2){if(_0x4649d2){_0x24379b=_0x4649d2;_0x3ec1ea=_0x24379b['splitSizeCsv']||0x1388;}})[_0x55df('0xf')](function(){return dbH[_0x55df('0x10')][_0x55df('0x11')](util[_0x55df('0x12')](_0x55df('0x13'),QUERY),{'type':dbH[_0x55df('0x10')][_0x55df('0x14')][_0x55df('0x15')]});})['then'](function(_0x4633a0){if(!_0x4633a0[0x0][_0x55df('0x16')]){return analyticExtractedReport(_0x55df('0x17'));}var _0x49a0a2=[];var _0x4a831c=0x0;if(_0x24379b['split']){if(_0x4633a0&&_0x4633a0['length']){var _0x29886c=_[_0x55df('0x18')](_0x4633a0[0x0][_0x55df('0x16')]/_0x3ec1ea);var _0x52a5e7=Number['isInteger'](_0x4633a0[0x0][_0x55df('0x16')]/_0x3ec1ea)?_0x4633a0[0x0][_0x55df('0x16')]%_0x3ec1ea:0x0;_0x29886c[_0x55df('0x19')](function(_0x146b5b){if(_0x146b5b>0x0){_0x4a831c+=_0x3ec1ea;}_0x49a0a2[_0x55df('0x1a')](dbH[_0x55df('0x10')]['query'](util[_0x55df('0x12')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x3ec1ea,_0x4a831c),{'type':dbH[_0x55df('0x10')]['QueryTypes'][_0x55df('0x15')]}));});if(_0x52a5e7>0x0){_0x4a831c+=_0x3ec1ea;_0x49a0a2[_0x55df('0x1a')](dbH['sequelize']['query'](util['format'](_0x55df('0x1b'),QUERY,_0x52a5e7,_0x4a831c),{'type':dbH[_0x55df('0x10')][_0x55df('0x14')][_0x55df('0x15')]}));}}}else{_0x49a0a2[_0x55df('0x1a')](dbH[_0x55df('0x10')][_0x55df('0x11')](QUERY,{'type':dbH[_0x55df('0x10')][_0x55df('0x14')]['SELECT']}));}var _0x33d4d7=path['dirname'](PATH);var _0x19404c=path[_0x55df('0x1c')](PATH,_0x55df('0x1d'));var _0x18df3e=_0x24379b[_0x55df('0x1e')]&&_0x49a0a2[_0x55df('0x1f')]>0x1;var _0x33f2bb=[];if(!fs[_0x55df('0x20')](path[_0x55df('0x21')](_0x33d4d7,_0x19404c))&&_0x18df3e){fs['mkdirSync'](path[_0x55df('0x21')](_0x33d4d7,_0x19404c));}return BPromise['each'](_0x49a0a2,function(_0x2df304){_0x33f2bb[_0x55df('0x1a')](_0x2df304);})[_0x55df('0xf')](function(){for(var _0x19c722=0x0;_0x19c722<_0x33f2bb[_0x55df('0x1f')];_0x19c722+=0x1){var _0x239e09;var _0x3b5fa1=_0x33f2bb[_0x19c722];if(_0x18df3e){_0x239e09=path['join'](_0x33d4d7,_0x19404c,util[_0x55df('0x12')](_0x55df('0x22'),_0x19404c,_0x19c722,'csv'));}else{_0x239e09=path[_0x55df('0x21')](_0x33d4d7,util[_0x55df('0x12')](_0x55df('0x23'),_0x19404c,'csv'));}fs['writeFileSync'](_0x239e09,csv(_0x3b5fa1));}})['then'](function(){if(_0x18df3e){return new Promise(function(_0x363804){zipdir(path['join'](_0x33d4d7,_0x19404c),{'saveTo':path[_0x55df('0x21')](_0x33d4d7,util[_0x55df('0x12')]('%s.%s',_0x19404c,_0x55df('0x24')))},function(_0xced88,_0x5339c5){rimraf(path[_0x55df('0x21')](_0x33d4d7,_0x19404c),function(){});_0x363804(_0x55df('0x25'));});});}})[_0x55df('0xf')](function(){logger[_0x55df('0x9')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x55df('0xb')));return analyticExtractedReport(_0x55df('0x26'),_0x18df3e?util[_0x55df('0x12')](_0x55df('0x23'),_0x19404c,_0x18df3e?'zip':_0x55df('0x27')):null);});})[_0x55df('0x28')](function(_0x4c5554){logger[_0x55df('0x9')](util['format'](_0x55df('0x29'),EXTRACTED_REPORT_ID,_0x55df('0xb')),util[_0x55df('0x2a')](_0x4c5554,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x55df('0x2b'));})[_0x55df('0x2c')](function(){process[_0x55df('0x2d')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xf712=['splitSizeCsv','sequelize','query','QueryTypes','num','Empty','length','isInteger','push','SELECT','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.csv','existsSync','join','mkdirSync','each','csv','%s.%s','writeFileSync','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','finally','exit','util','path','to-csv','zip-dir','rimraf','../../mysqldb','dbH','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','split','then'];(function(_0x34bc6c,_0x10d089){var _0x168820=function(_0xb058d9){while(--_0xb058d9){_0x34bc6c['push'](_0x34bc6c['shift']());}};_0x168820(++_0x10d089);}(_0xf712,0x15e));var _0x2f71=function(_0x213e02,_0x2c6d6d){_0x213e02=_0x213e02-0x0;var _0x24c8a4=_0xf712[_0x213e02];return _0x24c8a4;};'use strict';var util=require(_0x2f71('0x0'));var path=require(_0x2f71('0x1'));var _=require('lodash');var csv=require(_0x2f71('0x2'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x2f71('0x3'));var rimraf=require(_0x2f71('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x2f71('0x5'))[_0x2f71('0x6')];var logger=require('../../config/logger')('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x2f71('0x7')][0x2]);var QUERY=process[_0x2f71('0x7')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x347077,_0x4a2cf7){var _0x5eeb80={'status':_0x347077};var _0xc24a2c={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4a2cf7){_0x5eeb80[_0x2f71('0x8')]=_0x4a2cf7;}return db[_0x2f71('0x9')][_0x2f71('0xa')](_0x5eeb80,_0xc24a2c);}function main(){var _0x1ddeff=0x1388;var _0x5a2cb0;logger[_0x2f71('0xb')](util[_0x2f71('0xc')](_0x2f71('0xd'),EXTRACTED_REPORT_ID,_0x2f71('0xe')));return db[_0x2f71('0xf')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x2f71('0x10'),'splitSizeCsv']})[_0x2f71('0x11')](function(_0x342355){if(_0x342355){_0x5a2cb0=_0x342355;_0x1ddeff=_0x5a2cb0[_0x2f71('0x12')]||0x1388;}})[_0x2f71('0x11')](function(){return dbH[_0x2f71('0x13')][_0x2f71('0x14')](util[_0x2f71('0xc')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x2f71('0x13')][_0x2f71('0x15')]['SELECT']});})[_0x2f71('0x11')](function(_0x3e7abc){if(!_0x3e7abc[0x0][_0x2f71('0x16')]){return analyticExtractedReport(_0x2f71('0x17'));}var _0x2e67e4=[];var _0x6dce4e=0x0;if(_0x5a2cb0[_0x2f71('0x10')]){if(_0x3e7abc&&_0x3e7abc[_0x2f71('0x18')]){var _0x2d6b1a=_['range'](_0x3e7abc[0x0][_0x2f71('0x16')]/_0x1ddeff);var _0x2a568f=Number[_0x2f71('0x19')](_0x3e7abc[0x0][_0x2f71('0x16')]/_0x1ddeff)?_0x3e7abc[0x0]['num']%_0x1ddeff:0x0;_0x2d6b1a['forEach'](function(_0x2a5cfa){if(_0x2a5cfa>0x0){_0x6dce4e+=_0x1ddeff;}_0x2e67e4[_0x2f71('0x1a')](dbH[_0x2f71('0x13')][_0x2f71('0x14')](util[_0x2f71('0xc')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x1ddeff,_0x6dce4e),{'type':dbH[_0x2f71('0x13')][_0x2f71('0x15')][_0x2f71('0x1b')]}));});if(_0x2a568f>0x0){_0x6dce4e+=_0x1ddeff;_0x2e67e4[_0x2f71('0x1a')](dbH[_0x2f71('0x13')]['query'](util['format'](_0x2f71('0x1c'),QUERY,_0x2a568f,_0x6dce4e),{'type':dbH[_0x2f71('0x13')]['QueryTypes'][_0x2f71('0x1b')]}));}}}else{_0x2e67e4[_0x2f71('0x1a')](dbH[_0x2f71('0x13')][_0x2f71('0x14')](QUERY,{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}var _0x56db4f=path[_0x2f71('0x1d')](PATH);var _0x58cf69=path[_0x2f71('0x1e')](PATH,_0x2f71('0x1f'));var _0x3dc0fe=_0x5a2cb0[_0x2f71('0x10')]&&_0x2e67e4['length']>0x1;var _0x4dc44a=[];if(!fs[_0x2f71('0x20')](path[_0x2f71('0x21')](_0x56db4f,_0x58cf69))&&_0x3dc0fe){fs[_0x2f71('0x22')](path[_0x2f71('0x21')](_0x56db4f,_0x58cf69));}return BPromise[_0x2f71('0x23')](_0x2e67e4,function(_0x58a681){_0x4dc44a[_0x2f71('0x1a')](_0x58a681);})['then'](function(){for(var _0x2e960a=0x0;_0x2e960a<_0x4dc44a[_0x2f71('0x18')];_0x2e960a+=0x1){var _0x594855;var _0x15ef7c=_0x4dc44a[_0x2e960a];if(_0x3dc0fe){_0x594855=path['join'](_0x56db4f,_0x58cf69,util[_0x2f71('0xc')]('%s%d.%s',_0x58cf69,_0x2e960a,_0x2f71('0x24')));}else{_0x594855=path[_0x2f71('0x21')](_0x56db4f,util[_0x2f71('0xc')](_0x2f71('0x25'),_0x58cf69,_0x2f71('0x24')));}fs[_0x2f71('0x26')](_0x594855,csv(_0x15ef7c));}})[_0x2f71('0x11')](function(){if(_0x3dc0fe){return new Promise(function(_0xa2e9ab){zipdir(path[_0x2f71('0x21')](_0x56db4f,_0x58cf69),{'saveTo':path[_0x2f71('0x21')](_0x56db4f,util['format'](_0x2f71('0x25'),_0x58cf69,_0x2f71('0x27')))},function(_0x467ebb,_0x1bfc34){rimraf(path[_0x2f71('0x21')](_0x56db4f,_0x58cf69),function(){});_0xa2e9ab('zip\x20finished');});});}})[_0x2f71('0x11')](function(){logger['info'](util[_0x2f71('0xc')](_0x2f71('0x28'),EXTRACTED_REPORT_ID,_0x2f71('0xe')));return analyticExtractedReport('Completed',_0x3dc0fe?util[_0x2f71('0xc')](_0x2f71('0x25'),_0x58cf69,_0x3dc0fe?_0x2f71('0x27'):_0x2f71('0x24')):null);});})[_0x2f71('0x29')](function(_0x515355){logger[_0x2f71('0xb')](util[_0x2f71('0xc')](_0x2f71('0x2a'),EXTRACTED_REPORT_ID,'CSV'),util[_0x2f71('0x2b')](_0x515355,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0x2f71('0x2c')](function(){process[_0x2f71('0x2d')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff