// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe2be=['query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','Empty','length','range','num','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','existsSync','join','mkdirSync','%s%d.%s','csv','%s.%s','zip','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','info','inspect','Failed','util','lodash','to-csv','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','savename','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','splitSizeCsv','then','sequelize'];(function(_0x174a72,_0x46034c){var _0x32cecd=function(_0x188a47){while(--_0x188a47){_0x174a72['push'](_0x174a72['shift']());}};_0x32cecd(++_0x46034c);}(_0xe2be,0xd2));var _0xee2b=function(_0x110c3d,_0x12ee06){_0x110c3d=_0x110c3d-0x0;var _0x226d67=_0xe2be[_0x110c3d];return _0x226d67;};'use strict';var util=require(_0xee2b('0x0'));var path=require('path');var _=require(_0xee2b('0x1'));var csv=require(_0xee2b('0x2'));var fs=require('fs');var BPromise=require(_0xee2b('0x3'));var zipdir=require(_0xee2b('0x4'));var rimraf=require(_0xee2b('0x5'));var db=require(_0xee2b('0x6'))['db'];var dbH=require('../../mysqldb')[_0xee2b('0x7')];var logger=require(_0xee2b('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0xee2b('0x9')][0x2]);var QUERY=process[_0xee2b('0x9')][0x3];var PATH=process[_0xee2b('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x5d9e3f,_0x4d59d5){var _0x53e1ba={'status':_0x5d9e3f};var _0x208042={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4d59d5){_0x53e1ba[_0xee2b('0xa')]=_0x4d59d5;}return db['AnalyticExtractedReport']['update'](_0x53e1ba,_0x208042);}function main(){var _0x42070e=0x1388;var _0x387e57;logger['info'](util[_0xee2b('0xb')](_0xee2b('0xc'),EXTRACTED_REPORT_ID,_0xee2b('0xd')));return db[_0xee2b('0xe')][_0xee2b('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xee2b('0x10'),_0xee2b('0x11')]})[_0xee2b('0x12')](function(_0x39dcb4){if(_0x39dcb4){_0x387e57=_0x39dcb4;_0x42070e=_0x387e57[_0xee2b('0x11')]||0x1388;}})[_0xee2b('0x12')](function(){return dbH[_0xee2b('0x13')][_0xee2b('0x14')](util['format'](_0xee2b('0x15'),QUERY),{'type':dbH[_0xee2b('0x13')][_0xee2b('0x16')][_0xee2b('0x17')]});})[_0xee2b('0x12')](function(_0x131205){if(!_0x131205[0x0]['num']){return analyticExtractedReport(_0xee2b('0x18'));}var _0x5cfe7b=[];var _0x1bbc82=0x0;if(_0x387e57[_0xee2b('0x10')]){if(_0x131205&&_0x131205[_0xee2b('0x19')]){var _0x3b47e1=_[_0xee2b('0x1a')](_0x131205[0x0][_0xee2b('0x1b')]/_0x42070e);var _0x5c4d36=Number['isInteger'](_0x131205[0x0][_0xee2b('0x1b')]/_0x42070e)?_0x131205[0x0][_0xee2b('0x1b')]%_0x42070e:0x0;_0x3b47e1[_0xee2b('0x1c')](function(_0x358381){if(_0x358381>0x0){_0x1bbc82+=_0x42070e;}_0x5cfe7b[_0xee2b('0x1d')](dbH[_0xee2b('0x13')][_0xee2b('0x14')](util['format'](_0xee2b('0x1e'),QUERY,_0x42070e,_0x1bbc82),{'type':dbH['sequelize'][_0xee2b('0x16')][_0xee2b('0x17')]}));});if(_0x5c4d36>0x0){_0x1bbc82+=_0x42070e;_0x5cfe7b[_0xee2b('0x1d')](dbH[_0xee2b('0x13')][_0xee2b('0x14')](util['format'](_0xee2b('0x1e'),QUERY,_0x5c4d36,_0x1bbc82),{'type':dbH[_0xee2b('0x13')][_0xee2b('0x16')][_0xee2b('0x17')]}));}}}else{_0x5cfe7b[_0xee2b('0x1d')](dbH[_0xee2b('0x13')][_0xee2b('0x14')](QUERY,{'type':dbH['sequelize'][_0xee2b('0x16')]['SELECT']}));}var _0x51570a=path[_0xee2b('0x1f')](PATH);var _0x4e81f9=path[_0xee2b('0x20')](PATH,'.csv');var _0x428a3e=_0x387e57[_0xee2b('0x10')]&&_0x5cfe7b['length']>0x1;var _0x126561=[];if(!fs[_0xee2b('0x21')](path[_0xee2b('0x22')](_0x51570a,_0x4e81f9))&&_0x428a3e){fs[_0xee2b('0x23')](path[_0xee2b('0x22')](_0x51570a,_0x4e81f9));}return BPromise['each'](_0x5cfe7b,function(_0x55ae52){_0x126561['push'](_0x55ae52);})[_0xee2b('0x12')](function(){for(var _0x158fde=0x0;_0x158fde<_0x126561[_0xee2b('0x19')];_0x158fde+=0x1){var _0x1f4a80;var _0x5f32fe=_0x126561[_0x158fde];if(_0x428a3e){_0x1f4a80=path[_0xee2b('0x22')](_0x51570a,_0x4e81f9,util[_0xee2b('0xb')](_0xee2b('0x24'),_0x4e81f9,_0x158fde,_0xee2b('0x25')));}else{_0x1f4a80=path[_0xee2b('0x22')](_0x51570a,util['format'](_0xee2b('0x26'),_0x4e81f9,_0xee2b('0x25')));}fs['writeFileSync'](_0x1f4a80,csv(_0x5f32fe));}})[_0xee2b('0x12')](function(){if(_0x428a3e){return new Promise(function(_0x358f59){zipdir(path[_0xee2b('0x22')](_0x51570a,_0x4e81f9),{'saveTo':path['join'](_0x51570a,util['format'](_0xee2b('0x26'),_0x4e81f9,_0xee2b('0x27')))},function(_0x237c80,_0x282144){rimraf(path[_0xee2b('0x22')](_0x51570a,_0x4e81f9),function(){});_0x358f59(_0xee2b('0x28'));});});}})[_0xee2b('0x12')](function(){logger['info'](util[_0xee2b('0xb')](_0xee2b('0x29'),EXTRACTED_REPORT_ID,_0xee2b('0xd')));return analyticExtractedReport(_0xee2b('0x2a'),_0x428a3e?util[_0xee2b('0xb')](_0xee2b('0x26'),_0x4e81f9,_0x428a3e?_0xee2b('0x27'):_0xee2b('0x25')):null);});})['catch'](function(_0x2c50a0){logger[_0xee2b('0x2b')](util[_0xee2b('0xb')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xee2b('0xd')),util[_0xee2b('0x2c')](_0x2c50a0,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xee2b('0x2d'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x8df9=['split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','length','range','isInteger','forEach','%s\x20limit\x20%d\x20OFFSET\x20%d','push','existsSync','join','mkdirSync','csv','%s.%s','writeFileSync','zip','zip\x20finished','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','Failed','util','path','zip-dir','../../mysqldb','dbH','../../config/logger','analytics','argv','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find'];(function(_0x2859f2,_0x1e3102){var _0x4974cd=function(_0x13ec65){while(--_0x13ec65){_0x2859f2['push'](_0x2859f2['shift']());}};_0x4974cd(++_0x1e3102);}(_0x8df9,0x174));var _0x98df=function(_0x201b2d,_0xb2146f){_0x201b2d=_0x201b2d-0x0;var _0x3e85d4=_0x8df9[_0x201b2d];return _0x3e85d4;};'use strict';var util=require(_0x98df('0x0'));var path=require(_0x98df('0x1'));var _=require('lodash');var csv=require('to-csv');var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x98df('0x2'));var rimraf=require('rimraf');var db=require(_0x98df('0x3'))['db'];var dbH=require(_0x98df('0x3'))[_0x98df('0x4')];var logger=require(_0x98df('0x5'))(_0x98df('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x98df('0x7')][0x2]);var QUERY=process[_0x98df('0x7')][0x3];var PATH=process[_0x98df('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x239881,_0x248ae9){var _0x414432={'status':_0x239881};var _0x4416d0={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x248ae9){_0x414432['savename']=_0x248ae9;}return db[_0x98df('0x8')]['update'](_0x414432,_0x4416d0);}function main(){var _0x148c75=0x1388;var _0x4eaca9;logger[_0x98df('0x9')](util[_0x98df('0xa')](_0x98df('0xb'),EXTRACTED_REPORT_ID,_0x98df('0xc')));return db[_0x98df('0xd')][_0x98df('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x98df('0xf'),_0x98df('0x10')]})[_0x98df('0x11')](function(_0x300e09){if(_0x300e09){_0x4eaca9=_0x300e09;_0x148c75=_0x4eaca9['splitSizeCsv']||0x1388;}})['then'](function(){return dbH[_0x98df('0x12')][_0x98df('0x13')](util['format'](_0x98df('0x14'),QUERY),{'type':dbH[_0x98df('0x12')][_0x98df('0x15')][_0x98df('0x16')]});})[_0x98df('0x11')](function(_0x29fb19){if(!_0x29fb19[0x0][_0x98df('0x17')]){return analyticExtractedReport('Empty');}var _0x4251ea=[];var _0xa14b81=0x0;if(_0x4eaca9[_0x98df('0xf')]){if(_0x29fb19&&_0x29fb19[_0x98df('0x18')]){var _0x4f46f9=_[_0x98df('0x19')](_0x29fb19[0x0][_0x98df('0x17')]/_0x148c75);var _0x2640f2=Number[_0x98df('0x1a')](_0x29fb19[0x0]['num']/_0x148c75)?_0x29fb19[0x0]['num']%_0x148c75:0x0;_0x4f46f9[_0x98df('0x1b')](function(_0xb9c580){if(_0xb9c580>0x0){_0xa14b81+=_0x148c75;}_0x4251ea['push'](dbH[_0x98df('0x12')][_0x98df('0x13')](util[_0x98df('0xa')](_0x98df('0x1c'),QUERY,_0x148c75,_0xa14b81),{'type':dbH[_0x98df('0x12')][_0x98df('0x15')]['SELECT']}));});if(_0x2640f2>0x0){_0xa14b81+=_0x148c75;_0x4251ea[_0x98df('0x1d')](dbH[_0x98df('0x12')][_0x98df('0x13')](util[_0x98df('0xa')](_0x98df('0x1c'),QUERY,_0x2640f2,_0xa14b81),{'type':dbH[_0x98df('0x12')][_0x98df('0x15')][_0x98df('0x16')]}));}}}else{_0x4251ea['push'](dbH[_0x98df('0x12')][_0x98df('0x13')](QUERY,{'type':dbH[_0x98df('0x12')]['QueryTypes'][_0x98df('0x16')]}));}var _0x5325b1=path['dirname'](PATH);var _0x813740=path['basename'](PATH,'.csv');var _0x28c6e2=_0x4eaca9[_0x98df('0xf')]&&_0x4251ea['length']>0x1;var _0x145632=[];if(!fs[_0x98df('0x1e')](path[_0x98df('0x1f')](_0x5325b1,_0x813740))&&_0x28c6e2){fs[_0x98df('0x20')](path['join'](_0x5325b1,_0x813740));}return BPromise['each'](_0x4251ea,function(_0x36d598){_0x145632[_0x98df('0x1d')](_0x36d598);})[_0x98df('0x11')](function(){for(var _0x3b59b6=0x0;_0x3b59b6<_0x145632[_0x98df('0x18')];_0x3b59b6+=0x1){var _0x17f602;var _0x18bc42=_0x145632[_0x3b59b6];if(_0x28c6e2){_0x17f602=path[_0x98df('0x1f')](_0x5325b1,_0x813740,util[_0x98df('0xa')]('%s%d.%s',_0x813740,_0x3b59b6,_0x98df('0x21')));}else{_0x17f602=path[_0x98df('0x1f')](_0x5325b1,util[_0x98df('0xa')](_0x98df('0x22'),_0x813740,_0x98df('0x21')));}fs[_0x98df('0x23')](_0x17f602,csv(_0x18bc42));}})[_0x98df('0x11')](function(){if(_0x28c6e2){return new Promise(function(_0x48dd88){zipdir(path[_0x98df('0x1f')](_0x5325b1,_0x813740),{'saveTo':path[_0x98df('0x1f')](_0x5325b1,util[_0x98df('0xa')]('%s.%s',_0x813740,_0x98df('0x24')))},function(_0x38f1a3,_0x156e7c){rimraf(path['join'](_0x5325b1,_0x813740),function(){});_0x48dd88(_0x98df('0x25'));});});}})[_0x98df('0x11')](function(){logger[_0x98df('0x9')](util[_0x98df('0xa')](_0x98df('0x26'),EXTRACTED_REPORT_ID,_0x98df('0xc')));return analyticExtractedReport('Completed',_0x28c6e2?util[_0x98df('0xa')](_0x98df('0x22'),_0x813740,_0x28c6e2?_0x98df('0x24'):'csv'):null);});})[_0x98df('0x27')](function(_0x11a2a1){logger[_0x98df('0x9')](util['format'](_0x98df('0x28'),EXTRACTED_REPORT_ID,'CSV'),util[_0x98df('0x29')](_0x11a2a1,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x98df('0x2a'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff