Built motion from commit (unavailable).|2.2.4
[motion2.git] / server / components / export / csv.js
index c65f5f6..bf8583a 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xd84d=['writeFileSync','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','path','to-csv','bluebird','../../mysqldb','argv','savename','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','splitSizeCsv','then','sequelize','query','QueryTypes','SELECT','num','Empty','format','push','basename','.csv','split','existsSync','join','each','length','%s%d.%s','%s.%s','csv'];(function(_0x2cbe09,_0x3df4b3){var _0x3576e0=function(_0x4ae30a){while(--_0x4ae30a){_0x2cbe09['push'](_0x2cbe09['shift']());}};_0x3576e0(++_0x3df4b3);}(_0xd84d,0x13f));var _0xdd84=function(_0x24258d,_0x11ff80){_0x24258d=_0x24258d-0x0;var _0x3ec633=_0xd84d[_0x24258d];return _0x3ec633;};'use strict';var util=require('util');var path=require(_0xdd84('0x0'));var _=require('lodash');var csv=require(_0xdd84('0x1'));var fs=require('fs');var BPromise=require(_0xdd84('0x2'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0xdd84('0x3'))['db'];var dbH=require(_0xdd84('0x3'))['dbH'];var logger=require('../../config/logger')('analytics');var EXTRACTED_REPORT_ID=Number(process[_0xdd84('0x4')][0x2]);var QUERY=process[_0xdd84('0x4')][0x3];var PATH=process[_0xdd84('0x4')][0x4];function analyticExtractedReport(_0x59447c,_0x2240d8){var _0xa93ff2={'status':_0x59447c};var _0x438f59={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2240d8){_0xa93ff2[_0xdd84('0x5')]=_0x2240d8;}return db['AnalyticExtractedReport'][_0xdd84('0x6')](_0xa93ff2,_0x438f59);}function main(){var _0x19e850=0x1388;var _0x138ba0;logger[_0xdd84('0x7')](util['format'](_0xdd84('0x8'),EXTRACTED_REPORT_ID,_0xdd84('0x9')));return db[_0xdd84('0xa')][_0xdd84('0xb')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xdd84('0xc')]})[_0xdd84('0xd')](function(_0x271794){if(_0x271794){_0x138ba0=_0x271794;_0x19e850=_0x138ba0[_0xdd84('0xc')]||0x1388;}})['then'](function(){return dbH[_0xdd84('0xe')][_0xdd84('0xf')](util['format']('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH['sequelize'][_0xdd84('0x10')][_0xdd84('0x11')]});})[_0xdd84('0xd')](function(_0x45ac7e){if(!_0x45ac7e[0x0][_0xdd84('0x12')]){return analyticExtractedReport(_0xdd84('0x13'));}var _0x54bbe6=[];var _0x217e4f=0x0;var _0x291d1d=!![];if(_0x45ac7e&&_0x45ac7e['length']){var _0x139ff6=_0x45ac7e[0x0][_0xdd84('0x12')]%(_0x217e4f+_0x19e850);if(_0x138ba0['split']){for(;_0x291d1d;_0x217e4f+=_0x19e850,_0x139ff6=_0x45ac7e[0x0][_0xdd84('0x12')]%(_0x217e4f+_0x19e850)){if(_0x139ff6==0x0||_0x139ff6==_0x45ac7e[0x0][_0xdd84('0x12')]){_0x291d1d=![];}_0x54bbe6['push'](dbH[_0xdd84('0xe')][_0xdd84('0xf')](util[_0xdd84('0x14')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x19e850,_0x217e4f),{'type':dbH[_0xdd84('0xe')][_0xdd84('0x10')]['SELECT']}));}}else{_0x54bbe6[_0xdd84('0x15')](dbH['sequelize'][_0xdd84('0xf')](QUERY,{'type':dbH[_0xdd84('0xe')][_0xdd84('0x10')]['SELECT']}));}}var _0x51762d=path['dirname'](PATH);var _0x1f8117=path[_0xdd84('0x16')](PATH,_0xdd84('0x17'));var _0xf505c=_0x138ba0[_0xdd84('0x18')]&&_0x54bbe6['length']>0x1;var _0x162103=[];if(!fs[_0xdd84('0x19')](path['join'](_0x51762d,_0x1f8117))&&_0xf505c){fs['mkdirSync'](path[_0xdd84('0x1a')](_0x51762d,_0x1f8117));}return BPromise[_0xdd84('0x1b')](_0x54bbe6,function(_0x9457c0){_0x162103[_0xdd84('0x15')](_0x9457c0);})[_0xdd84('0xd')](function(){for(var _0x56d20d=0x0;_0x56d20d<_0x162103[_0xdd84('0x1c')];_0x56d20d+=0x1){var _0x421593;var _0x1f9a1b=_0x162103[_0x56d20d];if(_0xf505c){_0x421593=path[_0xdd84('0x1a')](_0x51762d,_0x1f8117,util[_0xdd84('0x14')](_0xdd84('0x1d'),_0x1f8117,_0x56d20d,'csv'));}else{_0x421593=path[_0xdd84('0x1a')](_0x51762d,util[_0xdd84('0x14')](_0xdd84('0x1e'),_0x1f8117,_0xdd84('0x1f')));}fs[_0xdd84('0x20')](_0x421593,csv(_0x1f9a1b));}})[_0xdd84('0xd')](function(){if(_0xf505c){zipdir(path[_0xdd84('0x1a')](_0x51762d,_0x1f8117),{'saveTo':path[_0xdd84('0x1a')](_0x51762d,util[_0xdd84('0x14')](_0xdd84('0x1e'),_0x1f8117,_0xdd84('0x21')))},function(_0x4819fd,_0xf31a30){});rimraf(path['join'](_0x51762d,_0x1f8117),function(){});}})['then'](function(){logger[_0xdd84('0x7')](util[_0xdd84('0x14')](_0xdd84('0x22'),EXTRACTED_REPORT_ID,_0xdd84('0x9')));return analyticExtractedReport(_0xdd84('0x23'),_0xf505c?util['format'](_0xdd84('0x1e'),_0x1f8117,_0xf505c?_0xdd84('0x21'):_0xdd84('0x1f')):null);});})['catch'](function(_0x254439){logger[_0xdd84('0x7')](util[_0xdd84('0x14')](_0xdd84('0x24'),EXTRACTED_REPORT_ID,'CSV'),util[_0xdd84('0x25')](_0x254439,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0xdd84('0x26'));});}main();
\ No newline at end of file
+var _0x14d5=['../../mysqldb','dbH','../../config/logger','argv','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','QueryTypes','SELECT','num','Empty','length','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.csv','existsSync','join','mkdirSync','each','%s%d.%s','csv','%s.%s','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','path','lodash','to-csv','bluebird','rimraf'];(function(_0x4b0c3e,_0x50754a){var _0xa99d4e=function(_0x1034a2){while(--_0x1034a2){_0x4b0c3e['push'](_0x4b0c3e['shift']());}};_0xa99d4e(++_0x50754a);}(_0x14d5,0x1bd));var _0x514d=function(_0x29cc56,_0x572e53){_0x29cc56=_0x29cc56-0x0;var _0x816a75=_0x14d5[_0x29cc56];return _0x816a75;};'use strict';var util=require('util');var path=require(_0x514d('0x0'));var _=require(_0x514d('0x1'));var csv=require(_0x514d('0x2'));var fs=require('fs');var BPromise=require(_0x514d('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0x514d('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x514d('0x5'))[_0x514d('0x6')];var logger=require(_0x514d('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x514d('0x8')][0x2]);var QUERY=process[_0x514d('0x8')][0x3];var PATH=process[_0x514d('0x8')][0x4];function analyticExtractedReport(_0x443d1a,_0x51b766){var _0x5a963e={'status':_0x443d1a};var _0x107901={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x51b766){_0x5a963e['savename']=_0x51b766;}return db[_0x514d('0x9')]['update'](_0x5a963e,_0x107901);}function main(){var _0x4d0b95=0x1388;var _0x45b191;logger[_0x514d('0xa')](util[_0x514d('0xb')](_0x514d('0xc'),EXTRACTED_REPORT_ID,_0x514d('0xd')));return db[_0x514d('0xe')][_0x514d('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x514d('0x10'),'splitSizeCsv']})['then'](function(_0x490473){if(_0x490473){_0x45b191=_0x490473;_0x4d0b95=_0x45b191[_0x514d('0x11')]||0x1388;}})[_0x514d('0x12')](function(){return dbH[_0x514d('0x13')][_0x514d('0x14')](util[_0x514d('0xb')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x514d('0x13')][_0x514d('0x15')][_0x514d('0x16')]});})['then'](function(_0x3b829c){if(!_0x3b829c[0x0][_0x514d('0x17')]){return analyticExtractedReport(_0x514d('0x18'));}var _0x2ccdb4=[];var _0x278036=0x0;var _0x10fcb8=!![];if(_0x3b829c&&_0x3b829c[_0x514d('0x19')]){var _0x30255d=_0x3b829c[0x0][_0x514d('0x17')]%(_0x278036+_0x4d0b95);if(_0x45b191['split']){for(;_0x10fcb8;_0x278036+=_0x4d0b95,_0x30255d=_0x3b829c[0x0]['num']%(_0x278036+_0x4d0b95)){if(_0x30255d==0x0||_0x30255d==_0x3b829c[0x0]['num']){_0x10fcb8=![];}_0x2ccdb4[_0x514d('0x1a')](dbH['sequelize']['query'](util['format'](_0x514d('0x1b'),QUERY,_0x4d0b95,_0x278036),{'type':dbH[_0x514d('0x13')]['QueryTypes'][_0x514d('0x16')]}));}}else{_0x2ccdb4[_0x514d('0x1a')](dbH[_0x514d('0x13')][_0x514d('0x14')](QUERY,{'type':dbH[_0x514d('0x13')][_0x514d('0x15')][_0x514d('0x16')]}));}}var _0x386c99=path[_0x514d('0x1c')](PATH);var _0x48657a=path[_0x514d('0x1d')](PATH,_0x514d('0x1e'));var _0x2f3777=_0x45b191['split']&&_0x2ccdb4[_0x514d('0x19')]>0x1;var _0x114040=[];if(!fs[_0x514d('0x1f')](path[_0x514d('0x20')](_0x386c99,_0x48657a))&&_0x2f3777){fs[_0x514d('0x21')](path[_0x514d('0x20')](_0x386c99,_0x48657a));}return BPromise[_0x514d('0x22')](_0x2ccdb4,function(_0x2199ca){_0x114040[_0x514d('0x1a')](_0x2199ca);})[_0x514d('0x12')](function(){for(var _0x165c81=0x0;_0x165c81<_0x114040[_0x514d('0x19')];_0x165c81+=0x1){var _0x2b70c8;var _0xdb9f49=_0x114040[_0x165c81];if(_0x2f3777){_0x2b70c8=path[_0x514d('0x20')](_0x386c99,_0x48657a,util[_0x514d('0xb')](_0x514d('0x23'),_0x48657a,_0x165c81,_0x514d('0x24')));}else{_0x2b70c8=path[_0x514d('0x20')](_0x386c99,util[_0x514d('0xb')](_0x514d('0x25'),_0x48657a,_0x514d('0x24')));}fs['writeFileSync'](_0x2b70c8,csv(_0xdb9f49));}})[_0x514d('0x12')](function(){if(_0x2f3777){zipdir(path[_0x514d('0x20')](_0x386c99,_0x48657a),{'saveTo':path[_0x514d('0x20')](_0x386c99,util[_0x514d('0xb')](_0x514d('0x25'),_0x48657a,_0x514d('0x26')))},function(_0x295474,_0x34f2cd){});rimraf(path[_0x514d('0x20')](_0x386c99,_0x48657a),function(){});}})[_0x514d('0x12')](function(){logger[_0x514d('0xa')](util['format'](_0x514d('0x27'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x514d('0x28'),_0x2f3777?util[_0x514d('0xb')]('%s.%s',_0x48657a,_0x2f3777?'zip':'csv'):null);});})[_0x514d('0x29')](function(_0x5210ba){logger[_0x514d('0xa')](util[_0x514d('0xb')](_0x514d('0x2a'),EXTRACTED_REPORT_ID,'CSV'),util[_0x514d('0x2b')](_0x5210ba,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x514d('0x2c'));});}main();
\ No newline at end of file