Built motion from commit fd055180.|2.6.30
[motion2.git] / server / components / export / csv.js
index acc376c..01e7ce9 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xcaa9=['exit','util','path','lodash','to-csv','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','AnalyticExtractedReport','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','range','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','existsSync','join','mkdirSync','each','%s%d.%s','%s.%s','csv','writeFileSync','zip','info','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','finally'];(function(_0x12387e,_0x4a34f2){var _0x50657c=function(_0x44dfb5){while(--_0x44dfb5){_0x12387e['push'](_0x12387e['shift']());}};_0x50657c(++_0x4a34f2);}(_0xcaa9,0x65));var _0x9caa=function(_0x13a585,_0x3bf10d){_0x13a585=_0x13a585-0x0;var _0x459345=_0xcaa9[_0x13a585];return _0x459345;};'use strict';var util=require(_0x9caa('0x0'));var path=require(_0x9caa('0x1'));var _=require(_0x9caa('0x2'));var csv=require(_0x9caa('0x3'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x9caa('0x4'));var rimraf=require(_0x9caa('0x5'));var db=require(_0x9caa('0x6'))['db'];var dbH=require(_0x9caa('0x6'))[_0x9caa('0x7')];var logger=require(_0x9caa('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x9caa('0x9')][0x2]);var QUERY=process[_0x9caa('0x9')][0x3];var PATH=process[_0x9caa('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x37f928,_0x982a94){var _0x400b6c={'status':_0x37f928};var _0xb72913={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x982a94){_0x400b6c['savename']=_0x982a94;}return db[_0x9caa('0xa')]['update'](_0x400b6c,_0xb72913);}function main(){var _0x5f46fc=0x1388;var _0x47d24b;logger['info'](util[_0x9caa('0xb')](_0x9caa('0xc'),EXTRACTED_REPORT_ID,_0x9caa('0xd')));return db[_0x9caa('0xe')][_0x9caa('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x9caa('0x10'),_0x9caa('0x11')]})[_0x9caa('0x12')](function(_0x5524e6){if(_0x5524e6){_0x47d24b=_0x5524e6;_0x5f46fc=_0x47d24b[_0x9caa('0x11')]||0x1388;}})[_0x9caa('0x12')](function(){return dbH[_0x9caa('0x13')][_0x9caa('0x14')](util[_0x9caa('0xb')](_0x9caa('0x15'),QUERY),{'type':dbH[_0x9caa('0x13')][_0x9caa('0x16')][_0x9caa('0x17')]});})['then'](function(_0xdc3267){if(!_0xdc3267[0x0][_0x9caa('0x18')]){return analyticExtractedReport(_0x9caa('0x19'));}var _0x168a31=[];var _0x5ac9b7=0x0;if(_0x47d24b['split']){if(_0xdc3267&&_0xdc3267[_0x9caa('0x1a')]){var _0x5f13c9=_[_0x9caa('0x1b')](_0xdc3267[0x0][_0x9caa('0x18')]/_0x5f46fc);var _0x5f48f5=Number[_0x9caa('0x1c')](_0xdc3267[0x0][_0x9caa('0x18')]/_0x5f46fc)?_0xdc3267[0x0][_0x9caa('0x18')]%_0x5f46fc:0x0;_0x5f13c9[_0x9caa('0x1d')](function(_0x54fcf1){if(_0x54fcf1>0x0){_0x5ac9b7+=_0x5f46fc;}_0x168a31[_0x9caa('0x1e')](dbH[_0x9caa('0x13')][_0x9caa('0x14')](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x5f46fc,_0x5ac9b7),{'type':dbH[_0x9caa('0x13')][_0x9caa('0x16')]['SELECT']}));});if(_0x5f48f5>0x0){_0x5ac9b7+=_0x5f46fc;_0x168a31[_0x9caa('0x1e')](dbH[_0x9caa('0x13')]['query'](util['format'](_0x9caa('0x1f'),QUERY,_0x5f48f5,_0x5ac9b7),{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}}}else{_0x168a31['push'](dbH[_0x9caa('0x13')][_0x9caa('0x14')](QUERY,{'type':dbH[_0x9caa('0x13')][_0x9caa('0x16')][_0x9caa('0x17')]}));}var _0x137f50=path['dirname'](PATH);var _0x285ce4=path['basename'](PATH,'.csv');var _0x3884ec=_0x47d24b[_0x9caa('0x10')]&&_0x168a31[_0x9caa('0x1a')]>0x1;var _0x210144=[];if(!fs[_0x9caa('0x20')](path[_0x9caa('0x21')](_0x137f50,_0x285ce4))&&_0x3884ec){fs[_0x9caa('0x22')](path[_0x9caa('0x21')](_0x137f50,_0x285ce4));}return BPromise[_0x9caa('0x23')](_0x168a31,function(_0x92978b){_0x210144[_0x9caa('0x1e')](_0x92978b);})[_0x9caa('0x12')](function(){for(var _0xb8441b=0x0;_0xb8441b<_0x210144['length'];_0xb8441b+=0x1){var _0x2f2af5;var _0x53c7f5=_0x210144[_0xb8441b];if(_0x3884ec){_0x2f2af5=path['join'](_0x137f50,_0x285ce4,util[_0x9caa('0xb')](_0x9caa('0x24'),_0x285ce4,_0xb8441b,'csv'));}else{_0x2f2af5=path[_0x9caa('0x21')](_0x137f50,util[_0x9caa('0xb')](_0x9caa('0x25'),_0x285ce4,_0x9caa('0x26')));}fs[_0x9caa('0x27')](_0x2f2af5,csv(_0x53c7f5));}})['then'](function(){if(_0x3884ec){return new Promise(function(_0x43496d){zipdir(path['join'](_0x137f50,_0x285ce4),{'saveTo':path['join'](_0x137f50,util[_0x9caa('0xb')](_0x9caa('0x25'),_0x285ce4,_0x9caa('0x28')))},function(_0xfe6b3f,_0xa067ec){rimraf(path['join'](_0x137f50,_0x285ce4),function(){});_0x43496d('zip\x20finished');});});}})['then'](function(){logger[_0x9caa('0x29')](util[_0x9caa('0xb')](_0x9caa('0x2a'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x9caa('0x2b'),_0x3884ec?util[_0x9caa('0xb')](_0x9caa('0x25'),_0x285ce4,_0x3884ec?_0x9caa('0x28'):_0x9caa('0x26')):null);});})[_0x9caa('0x2c')](function(_0x4e67e0){logger['info'](util['format'](_0x9caa('0x2d'),EXTRACTED_REPORT_ID,_0x9caa('0xd')),util[_0x9caa('0x2e')](_0x4e67e0,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x9caa('0x2f'));})[_0x9caa('0x30')](function(){process[_0x9caa('0x31')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x4b59=['%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','.csv','length','join','mkdirSync','each','csv','%s.%s','zip','zip\x20finished','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','finally','util','path','lodash','to-csv','bluebird','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','range','isInteger','push','SELECT'];(function(_0x4dcfbd,_0x10a2f8){var _0x12c261=function(_0x56420b){while(--_0x56420b){_0x4dcfbd['push'](_0x4dcfbd['shift']());}};_0x12c261(++_0x10a2f8);}(_0x4b59,0x1e6));var _0x94b5=function(_0x4ee9cd,_0xd375b0){_0x4ee9cd=_0x4ee9cd-0x0;var _0x328a5b=_0x4b59[_0x4ee9cd];return _0x328a5b;};'use strict';var util=require(_0x94b5('0x0'));var path=require(_0x94b5('0x1'));var _=require(_0x94b5('0x2'));var csv=require(_0x94b5('0x3'));var fs=require('fs');var BPromise=require(_0x94b5('0x4'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0x94b5('0x5'))['db'];var dbH=require(_0x94b5('0x5'))[_0x94b5('0x6')];var logger=require(_0x94b5('0x7'))(_0x94b5('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0x94b5('0x9')][0x2]);var QUERY=process['argv'][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x287fe4,_0x4e395a){var _0xef9705={'status':_0x287fe4};var _0x1f7e6a={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4e395a){_0xef9705[_0x94b5('0xa')]=_0x4e395a;}return db[_0x94b5('0xb')][_0x94b5('0xc')](_0xef9705,_0x1f7e6a);}function main(){var _0x77edbc=0x1388;var _0x2e7ed4;logger[_0x94b5('0xd')](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x94b5('0xe')));return db[_0x94b5('0xf')][_0x94b5('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x94b5('0x11'),_0x94b5('0x12')]})[_0x94b5('0x13')](function(_0x32649f){if(_0x32649f){_0x2e7ed4=_0x32649f;_0x77edbc=_0x2e7ed4[_0x94b5('0x12')]||0x1388;}})[_0x94b5('0x13')](function(){return dbH[_0x94b5('0x14')][_0x94b5('0x15')](util[_0x94b5('0x16')](_0x94b5('0x17'),QUERY),{'type':dbH[_0x94b5('0x14')][_0x94b5('0x18')]['SELECT']});})[_0x94b5('0x13')](function(_0x417e38){if(!_0x417e38[0x0][_0x94b5('0x19')]){return analyticExtractedReport(_0x94b5('0x1a'));}var _0x3f132b=[];var _0x5d6b7c=0x0;if(_0x2e7ed4['split']){if(_0x417e38&&_0x417e38['length']){var _0xb114b4=_[_0x94b5('0x1b')](_0x417e38[0x0]['num']/_0x77edbc);var _0x2ac96d=Number[_0x94b5('0x1c')](_0x417e38[0x0][_0x94b5('0x19')]/_0x77edbc)?_0x417e38[0x0][_0x94b5('0x19')]%_0x77edbc:0x0;_0xb114b4['forEach'](function(_0x39ce93){if(_0x39ce93>0x0){_0x5d6b7c+=_0x77edbc;}_0x3f132b[_0x94b5('0x1d')](dbH[_0x94b5('0x14')][_0x94b5('0x15')](util[_0x94b5('0x16')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x77edbc,_0x5d6b7c),{'type':dbH[_0x94b5('0x14')][_0x94b5('0x18')][_0x94b5('0x1e')]}));});if(_0x2ac96d>0x0){_0x5d6b7c+=_0x77edbc;_0x3f132b[_0x94b5('0x1d')](dbH[_0x94b5('0x14')][_0x94b5('0x15')](util['format'](_0x94b5('0x1f'),QUERY,_0x2ac96d,_0x5d6b7c),{'type':dbH[_0x94b5('0x14')][_0x94b5('0x18')]['SELECT']}));}}}else{_0x3f132b[_0x94b5('0x1d')](dbH[_0x94b5('0x14')][_0x94b5('0x15')](QUERY,{'type':dbH[_0x94b5('0x14')][_0x94b5('0x18')][_0x94b5('0x1e')]}));}var _0x487879=path[_0x94b5('0x20')](PATH);var _0x2c1d64=path['basename'](PATH,_0x94b5('0x21'));var _0xedd072=_0x2e7ed4[_0x94b5('0x11')]&&_0x3f132b[_0x94b5('0x22')]>0x1;var _0x546716=[];if(!fs['existsSync'](path[_0x94b5('0x23')](_0x487879,_0x2c1d64))&&_0xedd072){fs[_0x94b5('0x24')](path[_0x94b5('0x23')](_0x487879,_0x2c1d64));}return BPromise[_0x94b5('0x25')](_0x3f132b,function(_0xb2f71d){_0x546716[_0x94b5('0x1d')](_0xb2f71d);})['then'](function(){for(var _0xd6986d=0x0;_0xd6986d<_0x546716[_0x94b5('0x22')];_0xd6986d+=0x1){var _0x5a1b29;var _0x5bbf4e=_0x546716[_0xd6986d];if(_0xedd072){_0x5a1b29=path[_0x94b5('0x23')](_0x487879,_0x2c1d64,util['format']('%s%d.%s',_0x2c1d64,_0xd6986d,_0x94b5('0x26')));}else{_0x5a1b29=path['join'](_0x487879,util['format'](_0x94b5('0x27'),_0x2c1d64,_0x94b5('0x26')));}fs['writeFileSync'](_0x5a1b29,csv(_0x5bbf4e));}})[_0x94b5('0x13')](function(){if(_0xedd072){return new Promise(function(_0x4c92dc){zipdir(path[_0x94b5('0x23')](_0x487879,_0x2c1d64),{'saveTo':path[_0x94b5('0x23')](_0x487879,util['format']('%s.%s',_0x2c1d64,_0x94b5('0x28')))},function(_0x50c3ad,_0x445193){rimraf(path[_0x94b5('0x23')](_0x487879,_0x2c1d64),function(){});_0x4c92dc(_0x94b5('0x29'));});});}})[_0x94b5('0x13')](function(){logger[_0x94b5('0xd')](util['format'](_0x94b5('0x2a'),EXTRACTED_REPORT_ID,_0x94b5('0xe')));return analyticExtractedReport(_0x94b5('0x2b'),_0xedd072?util[_0x94b5('0x16')](_0x94b5('0x27'),_0x2c1d64,_0xedd072?_0x94b5('0x28'):_0x94b5('0x26')):null);});})['catch'](function(_0x11c6fc){logger['info'](util[_0x94b5('0x16')](_0x94b5('0x2c'),EXTRACTED_REPORT_ID,_0x94b5('0xe')),util[_0x94b5('0x2d')](_0x11c6fc,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0x94b5('0x2e')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file