Built motion from commit f74363e9.|2.6.34
[motion2.git] / server / components / export / csv.js
index 815140e..5b7ebdb 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x9513=['to-csv','rimraf','../../mysqldb','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','length','range','num','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.csv','split','existsSync','join','each','%s%d.%s','csv','%s.%s','writeFileSync','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','finally','exit','util','path'];(function(_0x28f53b,_0x19f5d8){var _0xf23361=function(_0x180850){while(--_0x180850){_0x28f53b['push'](_0x28f53b['shift']());}};_0xf23361(++_0x19f5d8);}(_0x9513,0x11e));var _0x3951=function(_0x195dba,_0x1dbb14){_0x195dba=_0x195dba-0x0;var _0x1bbc33=_0x9513[_0x195dba];return _0x1bbc33;};'use strict';var util=require(_0x3951('0x0'));var path=require(_0x3951('0x1'));var _=require('lodash');var csv=require(_0x3951('0x2'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require(_0x3951('0x3'));var db=require(_0x3951('0x4'))['db'];var dbH=require(_0x3951('0x4'))['dbH'];var logger=require(_0x3951('0x5'))(_0x3951('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x3951('0x7')][0x2]);var QUERY=process[_0x3951('0x7')][0x3];var PATH=process[_0x3951('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2182fe,_0x560afe){var _0x374dbc={'status':_0x2182fe};var _0x2bccad={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x560afe){_0x374dbc[_0x3951('0x8')]=_0x560afe;}return db[_0x3951('0x9')][_0x3951('0xa')](_0x374dbc,_0x2bccad);}function main(){var _0x267c43=0x1388;var _0x112bfb;logger[_0x3951('0xb')](util[_0x3951('0xc')](_0x3951('0xd'),EXTRACTED_REPORT_ID,_0x3951('0xe')));return db[_0x3951('0xf')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x3951('0x10')]})['then'](function(_0xa9e220){if(_0xa9e220){_0x112bfb=_0xa9e220;_0x267c43=_0x112bfb[_0x3951('0x10')]||0x1388;}})[_0x3951('0x11')](function(){return dbH[_0x3951('0x12')][_0x3951('0x13')](util[_0x3951('0xc')](_0x3951('0x14'),QUERY),{'type':dbH['sequelize'][_0x3951('0x15')][_0x3951('0x16')]});})[_0x3951('0x11')](function(_0x26e700){if(!_0x26e700[0x0]['num']){return analyticExtractedReport('Empty');}var _0x59a29e=[];var _0x75771f=0x0;if(_0x112bfb['split']){if(_0x26e700&&_0x26e700[_0x3951('0x17')]){var _0x48a709=_[_0x3951('0x18')](_0x26e700[0x0][_0x3951('0x19')]/_0x267c43);var _0x4bf405=Number['isInteger'](_0x26e700[0x0][_0x3951('0x19')]/_0x267c43)?_0x26e700[0x0][_0x3951('0x19')]%_0x267c43:0x0;_0x48a709[_0x3951('0x1a')](function(_0x195357){if(_0x195357>0x0){_0x75771f+=_0x267c43;}_0x59a29e[_0x3951('0x1b')](dbH['sequelize']['query'](util[_0x3951('0xc')](_0x3951('0x1c'),QUERY,_0x267c43,_0x75771f),{'type':dbH[_0x3951('0x12')][_0x3951('0x15')][_0x3951('0x16')]}));});if(_0x4bf405>0x0){_0x75771f+=_0x267c43;_0x59a29e[_0x3951('0x1b')](dbH[_0x3951('0x12')][_0x3951('0x13')](util[_0x3951('0xc')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x4bf405,_0x75771f),{'type':dbH['sequelize']['QueryTypes'][_0x3951('0x16')]}));}}}else{_0x59a29e['push'](dbH[_0x3951('0x12')][_0x3951('0x13')](QUERY,{'type':dbH[_0x3951('0x12')]['QueryTypes'][_0x3951('0x16')]}));}var _0x112d17=path[_0x3951('0x1d')](PATH);var _0x28c731=path[_0x3951('0x1e')](PATH,_0x3951('0x1f'));var _0xb7b8b6=_0x112bfb[_0x3951('0x20')]&&_0x59a29e[_0x3951('0x17')]>0x1;var _0x4f3372=[];if(!fs[_0x3951('0x21')](path['join'](_0x112d17,_0x28c731))&&_0xb7b8b6){fs['mkdirSync'](path[_0x3951('0x22')](_0x112d17,_0x28c731));}return BPromise[_0x3951('0x23')](_0x59a29e,function(_0x33114d){_0x4f3372[_0x3951('0x1b')](_0x33114d);})[_0x3951('0x11')](function(){for(var _0x3a9090=0x0;_0x3a9090<_0x4f3372[_0x3951('0x17')];_0x3a9090+=0x1){var _0x2e778a;var _0x512148=_0x4f3372[_0x3a9090];if(_0xb7b8b6){_0x2e778a=path[_0x3951('0x22')](_0x112d17,_0x28c731,util[_0x3951('0xc')](_0x3951('0x24'),_0x28c731,_0x3a9090,_0x3951('0x25')));}else{_0x2e778a=path[_0x3951('0x22')](_0x112d17,util[_0x3951('0xc')](_0x3951('0x26'),_0x28c731,_0x3951('0x25')));}fs[_0x3951('0x27')](_0x2e778a,csv(_0x512148));}})[_0x3951('0x11')](function(){if(_0xb7b8b6){return new Promise(function(_0x2f4f16){zipdir(path['join'](_0x112d17,_0x28c731),{'saveTo':path[_0x3951('0x22')](_0x112d17,util['format'](_0x3951('0x26'),_0x28c731,'zip'))},function(_0x46d39a,_0x3195b6){rimraf(path[_0x3951('0x22')](_0x112d17,_0x28c731),function(){});_0x2f4f16(_0x3951('0x28'));});});}})[_0x3951('0x11')](function(){logger[_0x3951('0xb')](util[_0x3951('0xc')](_0x3951('0x29'),EXTRACTED_REPORT_ID,_0x3951('0xe')));return analyticExtractedReport('Completed',_0xb7b8b6?util['format'](_0x3951('0x26'),_0x28c731,_0xb7b8b6?'zip':_0x3951('0x25')):null);});})[_0x3951('0x2a')](function(_0x46c95c){logger[_0x3951('0xb')](util[_0x3951('0xc')](_0x3951('0x2b'),EXTRACTED_REPORT_ID,_0x3951('0xe')),util[_0x3951('0x2c')](_0x46c95c,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x3951('0x2d'));})[_0x3951('0x2e')](function(){process[_0x3951('0x2f')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x4557=['zip','info','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','exit','util','lodash','to-csv','zip-dir','rimraf','../../mysqldb','analytics','argv','savename','AnalyticExtractedReport','update','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','num','length','range','isInteger','forEach','push','SELECT','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','dirname','basename','.csv','existsSync','mkdirSync','join','%s%d.%s','csv','%s.%s','writeFileSync','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed'];(function(_0xc2b088,_0x359a01){var _0x96b3ed=function(_0x2b79c1){while(--_0x2b79c1){_0xc2b088['push'](_0xc2b088['shift']());}};_0x96b3ed(++_0x359a01);}(_0x4557,0x1bf));var _0x7455=function(_0x14add3,_0x13ce8d){_0x14add3=_0x14add3-0x0;var _0x4a174f=_0x4557[_0x14add3];return _0x4a174f;};'use strict';var util=require(_0x7455('0x0'));var path=require('path');var _=require(_0x7455('0x1'));var csv=require(_0x7455('0x2'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x7455('0x3'));var rimraf=require(_0x7455('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x7455('0x5'))['dbH'];var logger=require('../../config/logger')(_0x7455('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x7455('0x7')][0x2]);var QUERY=process[_0x7455('0x7')][0x3];var PATH=process[_0x7455('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2baab2,_0x1b611c){var _0x33fbbc={'status':_0x2baab2};var _0x3ae0ca={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x1b611c){_0x33fbbc[_0x7455('0x8')]=_0x1b611c;}return db[_0x7455('0x9')][_0x7455('0xa')](_0x33fbbc,_0x3ae0ca);}function main(){var _0x7d15b1=0x1388;var _0x14f61e;logger['info'](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x7455('0xb')));return db[_0x7455('0xc')][_0x7455('0xd')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x7455('0xe'),_0x7455('0xf')]})[_0x7455('0x10')](function(_0x46531a){if(_0x46531a){_0x14f61e=_0x46531a;_0x7d15b1=_0x14f61e[_0x7455('0xf')]||0x1388;}})[_0x7455('0x10')](function(){return dbH[_0x7455('0x11')][_0x7455('0x12')](util[_0x7455('0x13')](_0x7455('0x14'),QUERY),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0x7455('0x10')](function(_0x2dec36){if(!_0x2dec36[0x0][_0x7455('0x15')]){return analyticExtractedReport('Empty');}var _0x208a26=[];var _0xb93783=0x0;if(_0x14f61e['split']){if(_0x2dec36&&_0x2dec36[_0x7455('0x16')]){var _0xc5a21e=_[_0x7455('0x17')](_0x2dec36[0x0][_0x7455('0x15')]/_0x7d15b1);var _0x2501ed=Number[_0x7455('0x18')](_0x2dec36[0x0]['num']/_0x7d15b1)?_0x2dec36[0x0]['num']%_0x7d15b1:0x0;_0xc5a21e[_0x7455('0x19')](function(_0x1d9dce){if(_0x1d9dce>0x0){_0xb93783+=_0x7d15b1;}_0x208a26[_0x7455('0x1a')](dbH[_0x7455('0x11')]['query'](util[_0x7455('0x13')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x7d15b1,_0xb93783),{'type':dbH[_0x7455('0x11')]['QueryTypes'][_0x7455('0x1b')]}));});if(_0x2501ed>0x0){_0xb93783+=_0x7d15b1;_0x208a26[_0x7455('0x1a')](dbH[_0x7455('0x11')][_0x7455('0x12')](util[_0x7455('0x13')](_0x7455('0x1c'),QUERY,_0x2501ed,_0xb93783),{'type':dbH['sequelize'][_0x7455('0x1d')][_0x7455('0x1b')]}));}}}else{_0x208a26[_0x7455('0x1a')](dbH['sequelize'][_0x7455('0x12')](QUERY,{'type':dbH[_0x7455('0x11')][_0x7455('0x1d')][_0x7455('0x1b')]}));}var _0x3dba56=path[_0x7455('0x1e')](PATH);var _0x14d52a=path[_0x7455('0x1f')](PATH,_0x7455('0x20'));var _0x2f7e29=_0x14f61e[_0x7455('0xe')]&&_0x208a26[_0x7455('0x16')]>0x1;var _0x538759=[];if(!fs[_0x7455('0x21')](path['join'](_0x3dba56,_0x14d52a))&&_0x2f7e29){fs[_0x7455('0x22')](path[_0x7455('0x23')](_0x3dba56,_0x14d52a));}return BPromise['each'](_0x208a26,function(_0x5e2275){_0x538759[_0x7455('0x1a')](_0x5e2275);})[_0x7455('0x10')](function(){for(var _0x479131=0x0;_0x479131<_0x538759[_0x7455('0x16')];_0x479131+=0x1){var _0x1bbcb6;var _0x2be90f=_0x538759[_0x479131];if(_0x2f7e29){_0x1bbcb6=path[_0x7455('0x23')](_0x3dba56,_0x14d52a,util[_0x7455('0x13')](_0x7455('0x24'),_0x14d52a,_0x479131,_0x7455('0x25')));}else{_0x1bbcb6=path[_0x7455('0x23')](_0x3dba56,util[_0x7455('0x13')](_0x7455('0x26'),_0x14d52a,_0x7455('0x25')));}fs[_0x7455('0x27')](_0x1bbcb6,csv(_0x2be90f));}})[_0x7455('0x10')](function(){if(_0x2f7e29){return new Promise(function(_0x299a9a){zipdir(path[_0x7455('0x23')](_0x3dba56,_0x14d52a),{'saveTo':path[_0x7455('0x23')](_0x3dba56,util[_0x7455('0x13')](_0x7455('0x26'),_0x14d52a,'zip'))},function(_0x5624b9,_0x57817c){rimraf(path[_0x7455('0x23')](_0x3dba56,_0x14d52a),function(){});_0x299a9a(_0x7455('0x28'));});});}})[_0x7455('0x10')](function(){logger['info'](util['format'](_0x7455('0x29'),EXTRACTED_REPORT_ID,_0x7455('0xb')));return analyticExtractedReport(_0x7455('0x2a'),_0x2f7e29?util[_0x7455('0x13')](_0x7455('0x26'),_0x14d52a,_0x2f7e29?_0x7455('0x2b'):_0x7455('0x25')):null);});})['catch'](function(_0x1825c8){logger[_0x7455('0x2c')](util['format'](_0x7455('0x2d'),EXTRACTED_REPORT_ID,_0x7455('0xb')),util[_0x7455('0x2e')](_0x1825c8,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x7455('0x2f'));})['finally'](function(){process[_0x7455('0x30')](EXIT_CODE);});}main();
\ No newline at end of file