// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x296e=['query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','split','push','dirname','.csv','existsSync','join','mkdirSync','each','csv','%s.%s','info','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','CSV','Completed','zip','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','path','lodash','to-csv','bluebird','zip-dir','../../mysqldb','dbH','../../config/logger','analytics','argv','AnalyticExtractedReport','update','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','splitSizeCsv','then','sequelize'];(function(_0x1d82f5,_0x407644){var _0x1c976c=function(_0x5f2dd0){while(--_0x5f2dd0){_0x1d82f5['push'](_0x1d82f5['shift']());}};_0x1c976c(++_0x407644);}(_0x296e,0x1a5));var _0xe296=function(_0xd199c8,_0x19133b){_0xd199c8=_0xd199c8-0x0;var _0x157b24=_0x296e[_0xd199c8];return _0x157b24;};'use strict';var util=require('util');var path=require(_0xe296('0x0'));var _=require(_0xe296('0x1'));var csv=require(_0xe296('0x2'));var fs=require('fs');var BPromise=require(_0xe296('0x3'));var zipdir=require(_0xe296('0x4'));var rimraf=require('rimraf');var db=require(_0xe296('0x5'))['db'];var dbH=require(_0xe296('0x5'))[_0xe296('0x6')];var logger=require(_0xe296('0x7'))(_0xe296('0x8'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0xe296('0x9')][0x4];function analyticExtractedReport(_0x3804f9,_0x5b4ff8){var _0x2ef090={'status':_0x3804f9};var _0x2ea4d0={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5b4ff8){_0x2ef090['savename']=_0x5b4ff8;}return db[_0xe296('0xa')][_0xe296('0xb')](_0x2ef090,_0x2ea4d0);}function main(){var _0x2cb231=0x1388;var _0x140d40;logger['info'](util[_0xe296('0xc')](_0xe296('0xd'),EXTRACTED_REPORT_ID,'CSV'));return db[_0xe296('0xe')][_0xe296('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xe296('0x10')]})[_0xe296('0x11')](function(_0x3faf2d){if(_0x3faf2d){_0x140d40=_0x3faf2d;_0x2cb231=_0x140d40['splitSizeCsv']||0x1388;}})[_0xe296('0x11')](function(){return dbH[_0xe296('0x12')][_0xe296('0x13')](util[_0xe296('0xc')](_0xe296('0x14'),QUERY),{'type':dbH[_0xe296('0x12')][_0xe296('0x15')][_0xe296('0x16')]});})[_0xe296('0x11')](function(_0x203d2e){if(!_0x203d2e[0x0][_0xe296('0x17')]){return analyticExtractedReport(_0xe296('0x18'));}var _0x157008=[];var _0x309f11=0x0;var _0x18bd28=!![];if(_0x203d2e&&_0x203d2e[_0xe296('0x19')]){var _0x4c5e91=_0x203d2e[0x0]['num']%(_0x309f11+_0x2cb231);if(_0x140d40[_0xe296('0x1a')]){for(;_0x18bd28;_0x309f11+=_0x2cb231,_0x4c5e91=_0x203d2e[0x0][_0xe296('0x17')]%(_0x309f11+_0x2cb231)){if(_0x4c5e91==0x0||_0x4c5e91==_0x203d2e[0x0]['num']){_0x18bd28=![];}_0x157008[_0xe296('0x1b')](dbH['sequelize'][_0xe296('0x13')](util[_0xe296('0xc')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x2cb231,_0x309f11),{'type':dbH[_0xe296('0x12')][_0xe296('0x15')][_0xe296('0x16')]}));}}else{_0x157008['push'](dbH['sequelize'][_0xe296('0x13')](QUERY,{'type':dbH[_0xe296('0x12')]['QueryTypes'][_0xe296('0x16')]}));}}var _0x4b3746=path[_0xe296('0x1c')](PATH);var _0x262cf1=path['basename'](PATH,_0xe296('0x1d'));var _0x152749=_0x140d40[_0xe296('0x1a')]&&_0x157008[_0xe296('0x19')]>0x1;var _0x1fb59a=[];if(!fs[_0xe296('0x1e')](path[_0xe296('0x1f')](_0x4b3746,_0x262cf1))&&_0x152749){fs[_0xe296('0x20')](path[_0xe296('0x1f')](_0x4b3746,_0x262cf1));}return BPromise[_0xe296('0x21')](_0x157008,function(_0x542355){_0x1fb59a['push'](_0x542355);})[_0xe296('0x11')](function(){for(var _0x122125=0x0;_0x122125<_0x1fb59a['length'];_0x122125+=0x1){var _0x161deb;var _0x1ce9af=_0x1fb59a[_0x122125];if(_0x152749){_0x161deb=path[_0xe296('0x1f')](_0x4b3746,_0x262cf1,util[_0xe296('0xc')]('%s%d.%s',_0x262cf1,_0x122125,_0xe296('0x22')));}else{_0x161deb=path[_0xe296('0x1f')](_0x4b3746,util[_0xe296('0xc')](_0xe296('0x23'),_0x262cf1,_0xe296('0x22')));}fs['writeFileSync'](_0x161deb,csv(_0x1ce9af));}})[_0xe296('0x11')](function(){if(_0x152749){zipdir(path['join'](_0x4b3746,_0x262cf1),{'saveTo':path[_0xe296('0x1f')](_0x4b3746,util['format']('%s.%s',_0x262cf1,'zip'))},function(_0x10c4f5,_0x5bf6c1){});rimraf(path[_0xe296('0x1f')](_0x4b3746,_0x262cf1),function(){});}})[_0xe296('0x11')](function(){logger[_0xe296('0x24')](util['format'](_0xe296('0x25'),EXTRACTED_REPORT_ID,_0xe296('0x26')));return analyticExtractedReport(_0xe296('0x27'),_0x152749?util[_0xe296('0xc')]('%s.%s',_0x262cf1,_0x152749?_0xe296('0x28'):_0xe296('0x22')):null);});})[_0xe296('0x29')](function(_0x21433c){logger[_0xe296('0x24')](util[_0xe296('0xc')](_0xe296('0x2a'),EXTRACTED_REPORT_ID,'CSV'),util[_0xe296('0x2b')](_0x21433c,{'showHidden':![],'depth':null}));return analyticExtractedReport('Failed');});}main();
\ No newline at end of file
+var _0xbf26=['dbH','../../config/logger','argv','savename','AnalyticExtractedReport','update','info','format','CSV','Setting','find','splitSizeCsv','then','sequelize','query','QueryTypes','SELECT','num','length','split','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.csv','existsSync','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','Failed','path','lodash','bluebird','zip-dir','rimraf','../../mysqldb'];(function(_0x4243a3,_0x447337){var _0x1b2a33=function(_0x6a8200){while(--_0x6a8200){_0x4243a3['push'](_0x4243a3['shift']());}};_0x1b2a33(++_0x447337);}(_0xbf26,0xdb));var _0x6bf2=function(_0x4ab33e,_0x248170){_0x4ab33e=_0x4ab33e-0x0;var _0x2d0ace=_0xbf26[_0x4ab33e];return _0x2d0ace;};'use strict';var util=require('util');var path=require(_0x6bf2('0x0'));var _=require(_0x6bf2('0x1'));var csv=require('to-csv');var fs=require('fs');var BPromise=require(_0x6bf2('0x2'));var zipdir=require(_0x6bf2('0x3'));var rimraf=require(_0x6bf2('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x6bf2('0x5'))[_0x6bf2('0x6')];var logger=require(_0x6bf2('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x6bf2('0x8')][0x4];function analyticExtractedReport(_0x42dbcc,_0x474f54){var _0x10731d={'status':_0x42dbcc};var _0x2bda8e={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x474f54){_0x10731d[_0x6bf2('0x9')]=_0x474f54;}return db[_0x6bf2('0xa')][_0x6bf2('0xb')](_0x10731d,_0x2bda8e);}function main(){var _0x91c4e3=0x1388;var _0x4e8439;logger[_0x6bf2('0xc')](util[_0x6bf2('0xd')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x6bf2('0xe')));return db[_0x6bf2('0xf')][_0x6bf2('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x6bf2('0x11')]})[_0x6bf2('0x12')](function(_0x4ce318){if(_0x4ce318){_0x4e8439=_0x4ce318;_0x91c4e3=_0x4e8439[_0x6bf2('0x11')]||0x1388;}})[_0x6bf2('0x12')](function(){return dbH[_0x6bf2('0x13')][_0x6bf2('0x14')](util[_0x6bf2('0xd')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x6bf2('0x13')][_0x6bf2('0x15')][_0x6bf2('0x16')]});})[_0x6bf2('0x12')](function(_0x5e5bab){if(!_0x5e5bab[0x0][_0x6bf2('0x17')]){return analyticExtractedReport('Empty');}var _0x33f777=[];var _0x47dc41=0x0;var _0x5bf9c3=!![];if(_0x5e5bab&&_0x5e5bab[_0x6bf2('0x18')]){var _0x3233b4=_0x5e5bab[0x0]['num']%(_0x47dc41+_0x91c4e3);if(_0x4e8439[_0x6bf2('0x19')]){for(;_0x5bf9c3;_0x47dc41+=_0x91c4e3,_0x3233b4=_0x5e5bab[0x0][_0x6bf2('0x17')]%(_0x47dc41+_0x91c4e3)){if(_0x3233b4==0x0||_0x3233b4==_0x5e5bab[0x0][_0x6bf2('0x17')]){_0x5bf9c3=![];}_0x33f777[_0x6bf2('0x1a')](dbH['sequelize'][_0x6bf2('0x14')](util[_0x6bf2('0xd')](_0x6bf2('0x1b'),QUERY,_0x91c4e3,_0x47dc41),{'type':dbH[_0x6bf2('0x13')][_0x6bf2('0x15')][_0x6bf2('0x16')]}));}}else{_0x33f777[_0x6bf2('0x1a')](dbH[_0x6bf2('0x13')][_0x6bf2('0x14')](QUERY,{'type':dbH['sequelize'][_0x6bf2('0x15')]['SELECT']}));}}var _0xa0841e=path[_0x6bf2('0x1c')](PATH);var _0x2e8c48=path[_0x6bf2('0x1d')](PATH,_0x6bf2('0x1e'));var _0x2f2115=_0x4e8439['split']&&_0x33f777[_0x6bf2('0x18')]>0x1;var _0x4176f0=[];if(!fs[_0x6bf2('0x1f')](path[_0x6bf2('0x20')](_0xa0841e,_0x2e8c48))&&_0x2f2115){fs[_0x6bf2('0x21')](path[_0x6bf2('0x20')](_0xa0841e,_0x2e8c48));}return BPromise[_0x6bf2('0x22')](_0x33f777,function(_0x4eefab){_0x4176f0[_0x6bf2('0x1a')](_0x4eefab);})[_0x6bf2('0x12')](function(){for(var _0x2e60c9=0x0;_0x2e60c9<_0x4176f0['length'];_0x2e60c9+=0x1){var _0x114f81;var _0x3a96e3=_0x4176f0[_0x2e60c9];if(_0x2f2115){_0x114f81=path[_0x6bf2('0x20')](_0xa0841e,_0x2e8c48,util['format'](_0x6bf2('0x23'),_0x2e8c48,_0x2e60c9,_0x6bf2('0x24')));}else{_0x114f81=path['join'](_0xa0841e,util[_0x6bf2('0xd')](_0x6bf2('0x25'),_0x2e8c48,_0x6bf2('0x24')));}fs[_0x6bf2('0x26')](_0x114f81,csv(_0x3a96e3));}})[_0x6bf2('0x12')](function(){if(_0x2f2115){zipdir(path[_0x6bf2('0x20')](_0xa0841e,_0x2e8c48),{'saveTo':path[_0x6bf2('0x20')](_0xa0841e,util[_0x6bf2('0xd')](_0x6bf2('0x25'),_0x2e8c48,_0x6bf2('0x27')))},function(_0x4b8c93,_0xb4d7ae){});rimraf(path[_0x6bf2('0x20')](_0xa0841e,_0x2e8c48),function(){});}})[_0x6bf2('0x12')](function(){logger['info'](util[_0x6bf2('0xd')](_0x6bf2('0x28'),EXTRACTED_REPORT_ID,_0x6bf2('0xe')));return analyticExtractedReport(_0x6bf2('0x29'),_0x2f2115?util[_0x6bf2('0xd')](_0x6bf2('0x25'),_0x2e8c48,_0x2f2115?_0x6bf2('0x27'):'csv'):null);});})[_0x6bf2('0x2a')](function(_0x51769b){logger[_0x6bf2('0xc')](util[_0x6bf2('0xd')](_0x6bf2('0x2b'),EXTRACTED_REPORT_ID,_0x6bf2('0xe')),util['inspect'](_0x51769b,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x6bf2('0x2c'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff