Built motion from commit 538092ac.|2.6.10
[motion2.git] / server / components / export / csv.js
index 3545d85..915c242 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x8ca2=['sequelize','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','range','isInteger','push','query','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.csv','existsSync','join','each','csv','%s.%s','zip','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','inspect','Failed','finally','exit','path','lodash','to-csv','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','find','split','then','splitSizeCsv'];(function(_0x589222,_0x1cfc0c){var _0x167251=function(_0x2e2d71){while(--_0x2e2d71){_0x589222['push'](_0x589222['shift']());}};_0x167251(++_0x1cfc0c);}(_0x8ca2,0x80));var _0x28ca=function(_0x3947c9,_0x4d6c97){_0x3947c9=_0x3947c9-0x0;var _0x2e7871=_0x8ca2[_0x3947c9];return _0x2e7871;};'use strict';var util=require('util');var path=require(_0x28ca('0x0'));var _=require(_0x28ca('0x1'));var csv=require(_0x28ca('0x2'));var fs=require('fs');var BPromise=require(_0x28ca('0x3'));var zipdir=require(_0x28ca('0x4'));var rimraf=require(_0x28ca('0x5'));var db=require('../../mysqldb')['db'];var dbH=require(_0x28ca('0x6'))[_0x28ca('0x7')];var logger=require(_0x28ca('0x8'))(_0x28ca('0x9'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x28ca('0xa')][0x3];var PATH=process[_0x28ca('0xa')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2977b8,_0x4b5367){var _0x533374={'status':_0x2977b8};var _0x31e408={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4b5367){_0x533374[_0x28ca('0xb')]=_0x4b5367;}return db[_0x28ca('0xc')][_0x28ca('0xd')](_0x533374,_0x31e408);}function main(){var _0x5accaa=0x1388;var _0x28cdb2;logger[_0x28ca('0xe')](util[_0x28ca('0xf')](_0x28ca('0x10'),EXTRACTED_REPORT_ID,_0x28ca('0x11')));return db['Setting'][_0x28ca('0x12')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x28ca('0x13'),'splitSizeCsv']})[_0x28ca('0x14')](function(_0x5b32d4){if(_0x5b32d4){_0x28cdb2=_0x5b32d4;_0x5accaa=_0x28cdb2[_0x28ca('0x15')]||0x1388;}})[_0x28ca('0x14')](function(){return dbH[_0x28ca('0x16')]['query'](util[_0x28ca('0xf')](_0x28ca('0x17'),QUERY),{'type':dbH[_0x28ca('0x16')][_0x28ca('0x18')][_0x28ca('0x19')]});})[_0x28ca('0x14')](function(_0x525292){if(!_0x525292[0x0][_0x28ca('0x1a')]){return analyticExtractedReport(_0x28ca('0x1b'));}var _0x505bb2=[];var _0x2baa9b=0x0;if(_0x28cdb2[_0x28ca('0x13')]){if(_0x525292&&_0x525292[_0x28ca('0x1c')]){var _0x2f7e2c=_[_0x28ca('0x1d')](_0x525292[0x0][_0x28ca('0x1a')]/_0x5accaa);var _0x3ffe0c=Number[_0x28ca('0x1e')](_0x525292[0x0][_0x28ca('0x1a')]/_0x5accaa)?_0x525292[0x0][_0x28ca('0x1a')]%_0x5accaa:0x0;_0x2f7e2c['forEach'](function(_0x43548c){if(_0x43548c>0x0){_0x2baa9b+=_0x5accaa;}_0x505bb2[_0x28ca('0x1f')](dbH[_0x28ca('0x16')][_0x28ca('0x20')](util['format'](_0x28ca('0x21'),QUERY,_0x5accaa,_0x2baa9b),{'type':dbH['sequelize']['QueryTypes'][_0x28ca('0x19')]}));});if(_0x3ffe0c>0x0){_0x2baa9b+=_0x5accaa;_0x505bb2['push'](dbH[_0x28ca('0x16')][_0x28ca('0x20')](util[_0x28ca('0xf')](_0x28ca('0x21'),QUERY,_0x3ffe0c,_0x2baa9b),{'type':dbH[_0x28ca('0x16')][_0x28ca('0x18')][_0x28ca('0x19')]}));}}}else{_0x505bb2[_0x28ca('0x1f')](dbH[_0x28ca('0x16')][_0x28ca('0x20')](QUERY,{'type':dbH[_0x28ca('0x16')][_0x28ca('0x18')][_0x28ca('0x19')]}));}var _0x187a26=path[_0x28ca('0x22')](PATH);var _0x2bc265=path[_0x28ca('0x23')](PATH,_0x28ca('0x24'));var _0x4db224=_0x28cdb2[_0x28ca('0x13')]&&_0x505bb2[_0x28ca('0x1c')]>0x1;var _0x4b1360=[];if(!fs[_0x28ca('0x25')](path[_0x28ca('0x26')](_0x187a26,_0x2bc265))&&_0x4db224){fs['mkdirSync'](path[_0x28ca('0x26')](_0x187a26,_0x2bc265));}return BPromise[_0x28ca('0x27')](_0x505bb2,function(_0x3f8c17){_0x4b1360['push'](_0x3f8c17);})[_0x28ca('0x14')](function(){for(var _0x591211=0x0;_0x591211<_0x4b1360[_0x28ca('0x1c')];_0x591211+=0x1){var _0x21dbe9;var _0x534ecb=_0x4b1360[_0x591211];if(_0x4db224){_0x21dbe9=path[_0x28ca('0x26')](_0x187a26,_0x2bc265,util['format']('%s%d.%s',_0x2bc265,_0x591211,_0x28ca('0x28')));}else{_0x21dbe9=path[_0x28ca('0x26')](_0x187a26,util[_0x28ca('0xf')](_0x28ca('0x29'),_0x2bc265,'csv'));}fs['writeFileSync'](_0x21dbe9,csv(_0x534ecb));}})['then'](function(){if(_0x4db224){return new Promise(function(_0x5255f9){zipdir(path[_0x28ca('0x26')](_0x187a26,_0x2bc265),{'saveTo':path[_0x28ca('0x26')](_0x187a26,util[_0x28ca('0xf')]('%s.%s',_0x2bc265,_0x28ca('0x2a')))},function(_0x28743a,_0x35ddb4){rimraf(path[_0x28ca('0x26')](_0x187a26,_0x2bc265),function(){});_0x5255f9(_0x28ca('0x2b'));});});}})[_0x28ca('0x14')](function(){logger[_0x28ca('0xe')](util[_0x28ca('0xf')](_0x28ca('0x2c'),EXTRACTED_REPORT_ID,_0x28ca('0x11')));return analyticExtractedReport(_0x28ca('0x2d'),_0x4db224?util[_0x28ca('0xf')](_0x28ca('0x29'),_0x2bc265,_0x4db224?_0x28ca('0x2a'):_0x28ca('0x28')):null);});})['catch'](function(_0x1d041a){logger[_0x28ca('0xe')](util[_0x28ca('0xf')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'CSV'),util[_0x28ca('0x2e')](_0x1d041a,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x28ca('0x2f'));})[_0x28ca('0x30')](function(){process[_0x28ca('0x31')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x9836=['%s.%s','writeFileSync','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','Failed','finally','util','path','lodash','to-csv','zip-dir','../../mysqldb','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','info','format','CSV','Setting','find','split','then','sequelize','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','range','num','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','query','QueryTypes','dirname','.csv','existsSync','join','mkdirSync','each','length','%s%d.%s','csv'];(function(_0x49930e,_0x1a088e){var _0x2bcc2f=function(_0x15b7e5){while(--_0x15b7e5){_0x49930e['push'](_0x49930e['shift']());}};_0x2bcc2f(++_0x1a088e);}(_0x9836,0x152));var _0x6983=function(_0x42e8a6,_0xc5c6f3){_0x42e8a6=_0x42e8a6-0x0;var _0xd1b0c5=_0x9836[_0x42e8a6];return _0xd1b0c5;};'use strict';var util=require(_0x6983('0x0'));var path=require(_0x6983('0x1'));var _=require(_0x6983('0x2'));var csv=require(_0x6983('0x3'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x6983('0x4'));var rimraf=require('rimraf');var db=require(_0x6983('0x5'))['db'];var dbH=require(_0x6983('0x5'))['dbH'];var logger=require(_0x6983('0x6'))(_0x6983('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x6983('0x8')][0x2]);var QUERY=process[_0x6983('0x8')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x3e79ba,_0x5cf218){var _0x313fb6={'status':_0x3e79ba};var _0x3c5f52={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5cf218){_0x313fb6[_0x6983('0x9')]=_0x5cf218;}return db[_0x6983('0xa')]['update'](_0x313fb6,_0x3c5f52);}function main(){var _0x4338eb=0x1388;var _0x47e2c0;logger[_0x6983('0xb')](util[_0x6983('0xc')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x6983('0xd')));return db[_0x6983('0xe')][_0x6983('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x6983('0x10'),'splitSizeCsv']})[_0x6983('0x11')](function(_0x233a43){if(_0x233a43){_0x47e2c0=_0x233a43;_0x4338eb=_0x47e2c0['splitSizeCsv']||0x1388;}})['then'](function(){return dbH[_0x6983('0x12')]['query'](util['format'](_0x6983('0x13'),QUERY),{'type':dbH['sequelize']['QueryTypes'][_0x6983('0x14')]});})[_0x6983('0x11')](function(_0x3e79c5){if(!_0x3e79c5[0x0]['num']){return analyticExtractedReport('Empty');}var _0x1ef8cf=[];var _0x2e047d=0x0;if(_0x47e2c0[_0x6983('0x10')]){if(_0x3e79c5&&_0x3e79c5['length']){var _0xb76b9e=_[_0x6983('0x15')](_0x3e79c5[0x0][_0x6983('0x16')]/_0x4338eb);var _0x5e66e9=Number[_0x6983('0x17')](_0x3e79c5[0x0][_0x6983('0x16')]/_0x4338eb)?_0x3e79c5[0x0][_0x6983('0x16')]%_0x4338eb:0x0;_0xb76b9e[_0x6983('0x18')](function(_0x13558a){if(_0x13558a>0x0){_0x2e047d+=_0x4338eb;}_0x1ef8cf[_0x6983('0x19')](dbH['sequelize']['query'](util['format'](_0x6983('0x1a'),QUERY,_0x4338eb,_0x2e047d),{'type':dbH[_0x6983('0x12')]['QueryTypes'][_0x6983('0x14')]}));});if(_0x5e66e9>0x0){_0x2e047d+=_0x4338eb;_0x1ef8cf[_0x6983('0x19')](dbH[_0x6983('0x12')][_0x6983('0x1b')](util[_0x6983('0xc')](_0x6983('0x1a'),QUERY,_0x5e66e9,_0x2e047d),{'type':dbH[_0x6983('0x12')][_0x6983('0x1c')][_0x6983('0x14')]}));}}}else{_0x1ef8cf[_0x6983('0x19')](dbH[_0x6983('0x12')][_0x6983('0x1b')](QUERY,{'type':dbH[_0x6983('0x12')][_0x6983('0x1c')][_0x6983('0x14')]}));}var _0x3b5349=path[_0x6983('0x1d')](PATH);var _0x36f473=path['basename'](PATH,_0x6983('0x1e'));var _0x3c72fc=_0x47e2c0[_0x6983('0x10')]&&_0x1ef8cf['length']>0x1;var _0x5f579a=[];if(!fs[_0x6983('0x1f')](path[_0x6983('0x20')](_0x3b5349,_0x36f473))&&_0x3c72fc){fs[_0x6983('0x21')](path['join'](_0x3b5349,_0x36f473));}return BPromise[_0x6983('0x22')](_0x1ef8cf,function(_0x433ed6){_0x5f579a[_0x6983('0x19')](_0x433ed6);})[_0x6983('0x11')](function(){for(var _0xa40ff5=0x0;_0xa40ff5<_0x5f579a[_0x6983('0x23')];_0xa40ff5+=0x1){var _0x15bfc3;var _0xedce4f=_0x5f579a[_0xa40ff5];if(_0x3c72fc){_0x15bfc3=path[_0x6983('0x20')](_0x3b5349,_0x36f473,util[_0x6983('0xc')](_0x6983('0x24'),_0x36f473,_0xa40ff5,_0x6983('0x25')));}else{_0x15bfc3=path[_0x6983('0x20')](_0x3b5349,util[_0x6983('0xc')](_0x6983('0x26'),_0x36f473,_0x6983('0x25')));}fs[_0x6983('0x27')](_0x15bfc3,csv(_0xedce4f));}})[_0x6983('0x11')](function(){if(_0x3c72fc){return new Promise(function(_0x1ffe6c){zipdir(path[_0x6983('0x20')](_0x3b5349,_0x36f473),{'saveTo':path['join'](_0x3b5349,util[_0x6983('0xc')](_0x6983('0x26'),_0x36f473,_0x6983('0x28')))},function(_0x1934d3,_0x21bffb){rimraf(path[_0x6983('0x20')](_0x3b5349,_0x36f473),function(){});_0x1ffe6c(_0x6983('0x29'));});});}})[_0x6983('0x11')](function(){logger[_0x6983('0xb')](util[_0x6983('0xc')](_0x6983('0x2a'),EXTRACTED_REPORT_ID,_0x6983('0xd')));return analyticExtractedReport(_0x6983('0x2b'),_0x3c72fc?util['format'](_0x6983('0x26'),_0x36f473,_0x3c72fc?_0x6983('0x28'):_0x6983('0x25')):null);});})['catch'](function(_0x12cc9c){logger[_0x6983('0xb')](util[_0x6983('0xc')](_0x6983('0x2c'),EXTRACTED_REPORT_ID,_0x6983('0xd')),util['inspect'](_0x12cc9c,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x6983('0x2d'));})[_0x6983('0x2e')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file