Built motion from commit (unavailable).|2.4.4
[motion2.git] / server / components / export / csv.js
index 01e52fa..018309b 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xed0b=['zip','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','util','path','lodash','to-csv','rimraf','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','splitSizeCsv','then','sequelize','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','length','join','each','csv','%s.%s','writeFileSync','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed'];(function(_0x38857c,_0x52e367){var _0x4a93f8=function(_0x3ca7ac){while(--_0x3ca7ac){_0x38857c['push'](_0x38857c['shift']());}};_0x4a93f8(++_0x52e367);}(_0xed0b,0xca));var _0xbed0=function(_0x217c2e,_0x358f06){_0x217c2e=_0x217c2e-0x0;var _0x22b7d8=_0xed0b[_0x217c2e];return _0x22b7d8;};'use strict';var util=require(_0xbed0('0x0'));var path=require(_0xbed0('0x1'));var _=require(_0xbed0('0x2'));var csv=require(_0xbed0('0x3'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require(_0xbed0('0x4'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')[_0xbed0('0x5')];var logger=require(_0xbed0('0x6'))(_0xbed0('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0xbed0('0x8')][0x4];function analyticExtractedReport(_0x1025d7,_0x2a41df){var _0x503b77={'status':_0x1025d7};var _0x1cc195={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2a41df){_0x503b77[_0xbed0('0x9')]=_0x2a41df;}return db[_0xbed0('0xa')]['update'](_0x503b77,_0x1cc195);}function main(){var _0x1339eb=0x1388;var _0x3683ba;logger[_0xbed0('0xb')](util['format'](_0xbed0('0xc'),EXTRACTED_REPORT_ID,_0xbed0('0xd')));return db[_0xbed0('0xe')][_0xbed0('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xbed0('0x10'),_0xbed0('0x11')]})[_0xbed0('0x12')](function(_0x161c22){if(_0x161c22){_0x3683ba=_0x161c22;_0x1339eb=_0x3683ba[_0xbed0('0x11')]||0x1388;}})[_0xbed0('0x12')](function(){return dbH[_0xbed0('0x13')][_0xbed0('0x14')](util[_0xbed0('0x15')](_0xbed0('0x16'),QUERY),{'type':dbH[_0xbed0('0x13')][_0xbed0('0x17')]['SELECT']});})[_0xbed0('0x12')](function(_0x2635d1){if(!_0x2635d1[0x0][_0xbed0('0x18')]){return analyticExtractedReport(_0xbed0('0x19'));}var _0x67143e=[];var _0xea1248=0x0;var _0x17e12f=!![];if(_0x2635d1&&_0x2635d1['length']){var _0x333a33=_0x2635d1[0x0][_0xbed0('0x18')]%(_0xea1248+_0x1339eb);if(_0x3683ba[_0xbed0('0x10')]){for(;_0x17e12f;_0xea1248+=_0x1339eb,_0x333a33=_0x2635d1[0x0]['num']%(_0xea1248+_0x1339eb)){if(_0x333a33==0x0||_0x333a33==_0x2635d1[0x0][_0xbed0('0x18')]){_0x17e12f=![];}_0x67143e[_0xbed0('0x1a')](dbH['sequelize'][_0xbed0('0x14')](util['format'](_0xbed0('0x1b'),QUERY,_0x1339eb,_0xea1248),{'type':dbH[_0xbed0('0x13')][_0xbed0('0x17')]['SELECT']}));}}else{_0x67143e[_0xbed0('0x1a')](dbH[_0xbed0('0x13')][_0xbed0('0x14')](QUERY,{'type':dbH[_0xbed0('0x13')]['QueryTypes']['SELECT']}));}}var _0x19c3bf=path[_0xbed0('0x1c')](PATH);var _0x119694=path[_0xbed0('0x1d')](PATH,'.csv');var _0x3b94ad=_0x3683ba[_0xbed0('0x10')]&&_0x67143e[_0xbed0('0x1e')]>0x1;var _0x42bb17=[];if(!fs['existsSync'](path[_0xbed0('0x1f')](_0x19c3bf,_0x119694))&&_0x3b94ad){fs['mkdirSync'](path['join'](_0x19c3bf,_0x119694));}return BPromise[_0xbed0('0x20')](_0x67143e,function(_0x5a81da){_0x42bb17[_0xbed0('0x1a')](_0x5a81da);})['then'](function(){for(var _0x2fc56c=0x0;_0x2fc56c<_0x42bb17[_0xbed0('0x1e')];_0x2fc56c+=0x1){var _0x20061c;var _0x3de793=_0x42bb17[_0x2fc56c];if(_0x3b94ad){_0x20061c=path[_0xbed0('0x1f')](_0x19c3bf,_0x119694,util['format']('%s%d.%s',_0x119694,_0x2fc56c,_0xbed0('0x21')));}else{_0x20061c=path[_0xbed0('0x1f')](_0x19c3bf,util[_0xbed0('0x15')](_0xbed0('0x22'),_0x119694,_0xbed0('0x21')));}fs[_0xbed0('0x23')](_0x20061c,csv(_0x3de793));}})['then'](function(){if(_0x3b94ad){zipdir(path[_0xbed0('0x1f')](_0x19c3bf,_0x119694),{'saveTo':path[_0xbed0('0x1f')](_0x19c3bf,util[_0xbed0('0x15')]('%s.%s',_0x119694,'zip'))},function(_0x25da79,_0x5c394a){});rimraf(path[_0xbed0('0x1f')](_0x19c3bf,_0x119694),function(){});}})[_0xbed0('0x12')](function(){logger['info'](util[_0xbed0('0x15')](_0xbed0('0x24'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0xbed0('0x25'),_0x3b94ad?util['format'](_0xbed0('0x22'),_0x119694,_0x3b94ad?_0xbed0('0x26'):'csv'):null);});})['catch'](function(_0x4a46a9){logger[_0xbed0('0xb')](util[_0xbed0('0x15')](_0xbed0('0x27'),EXTRACTED_REPORT_ID,'CSV'),util['inspect'](_0x4a46a9,{'showHidden':![],'depth':null}));return analyticExtractedReport('Failed');});}main();
\ No newline at end of file
+var _0x3829=['writeFileSync','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch','info','inspect','Failed','util','path','lodash','to-csv','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','CSV','Setting','find','splitSizeCsv','then','sequelize','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','Empty','length','num','split','query','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','existsSync','mkdirSync','join','each','push','csv','%s.%s'];(function(_0x127783,_0x258715){var _0x14f298=function(_0x32090e){while(--_0x32090e){_0x127783['push'](_0x127783['shift']());}};_0x14f298(++_0x258715);}(_0x3829,0x143));var _0x9382=function(_0x587377,_0x3dbc20){_0x587377=_0x587377-0x0;var _0x17d29b=_0x3829[_0x587377];return _0x17d29b;};'use strict';var util=require(_0x9382('0x0'));var path=require(_0x9382('0x1'));var _=require(_0x9382('0x2'));var csv=require(_0x9382('0x3'));var fs=require('fs');var BPromise=require('bluebird');var zipdir=require(_0x9382('0x4'));var rimraf=require(_0x9382('0x5'));var db=require(_0x9382('0x6'))['db'];var dbH=require('../../mysqldb')[_0x9382('0x7')];var logger=require(_0x9382('0x8'))(_0x9382('0x9'));var EXTRACTED_REPORT_ID=Number(process[_0x9382('0xa')][0x2]);var QUERY=process[_0x9382('0xa')][0x3];var PATH=process[_0x9382('0xa')][0x4];function analyticExtractedReport(_0x10af0d,_0x5d10e7){var _0x3c66ee={'status':_0x10af0d};var _0x56dbcb={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5d10e7){_0x3c66ee[_0x9382('0xb')]=_0x5d10e7;}return db[_0x9382('0xc')][_0x9382('0xd')](_0x3c66ee,_0x56dbcb);}function main(){var _0x2c4c47=0x1388;var _0x2f2a0f;logger['info'](util['format']('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x9382('0xe')));return db[_0x9382('0xf')][_0x9382('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x9382('0x11')]})[_0x9382('0x12')](function(_0x1ff002){if(_0x1ff002){_0x2f2a0f=_0x1ff002;_0x2c4c47=_0x2f2a0f[_0x9382('0x11')]||0x1388;}})[_0x9382('0x12')](function(){return dbH[_0x9382('0x13')]['query'](util[_0x9382('0x14')](_0x9382('0x15'),QUERY),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0x9382('0x12')](function(_0x5cc7ec){if(!_0x5cc7ec[0x0]['num']){return analyticExtractedReport(_0x9382('0x16'));}var _0x48857e=[];var _0x332df9=0x0;var _0xd73cf1=!![];if(_0x5cc7ec&&_0x5cc7ec[_0x9382('0x17')]){var _0x42ceca=_0x5cc7ec[0x0][_0x9382('0x18')]%(_0x332df9+_0x2c4c47);if(_0x2f2a0f[_0x9382('0x19')]){for(;_0xd73cf1;_0x332df9+=_0x2c4c47,_0x42ceca=_0x5cc7ec[0x0][_0x9382('0x18')]%(_0x332df9+_0x2c4c47)){if(_0x42ceca==0x0||_0x42ceca==_0x5cc7ec[0x0][_0x9382('0x18')]){_0xd73cf1=![];}_0x48857e['push'](dbH[_0x9382('0x13')][_0x9382('0x1a')](util[_0x9382('0x14')](_0x9382('0x1b'),QUERY,_0x2c4c47,_0x332df9),{'type':dbH['sequelize'][_0x9382('0x1c')]['SELECT']}));}}else{_0x48857e['push'](dbH[_0x9382('0x13')][_0x9382('0x1a')](QUERY,{'type':dbH[_0x9382('0x13')][_0x9382('0x1c')][_0x9382('0x1d')]}));}}var _0x26d019=path['dirname'](PATH);var _0x5c2bd2=path['basename'](PATH,'.csv');var _0x70f1c6=_0x2f2a0f[_0x9382('0x19')]&&_0x48857e['length']>0x1;var _0x24cf8d=[];if(!fs[_0x9382('0x1e')](path['join'](_0x26d019,_0x5c2bd2))&&_0x70f1c6){fs[_0x9382('0x1f')](path[_0x9382('0x20')](_0x26d019,_0x5c2bd2));}return BPromise[_0x9382('0x21')](_0x48857e,function(_0x24f9f3){_0x24cf8d[_0x9382('0x22')](_0x24f9f3);})[_0x9382('0x12')](function(){for(var _0x628263=0x0;_0x628263<_0x24cf8d[_0x9382('0x17')];_0x628263+=0x1){var _0x29be83;var _0x1d6351=_0x24cf8d[_0x628263];if(_0x70f1c6){_0x29be83=path[_0x9382('0x20')](_0x26d019,_0x5c2bd2,util[_0x9382('0x14')]('%s%d.%s',_0x5c2bd2,_0x628263,_0x9382('0x23')));}else{_0x29be83=path['join'](_0x26d019,util[_0x9382('0x14')](_0x9382('0x24'),_0x5c2bd2,_0x9382('0x23')));}fs[_0x9382('0x25')](_0x29be83,csv(_0x1d6351));}})[_0x9382('0x12')](function(){if(_0x70f1c6){zipdir(path[_0x9382('0x20')](_0x26d019,_0x5c2bd2),{'saveTo':path[_0x9382('0x20')](_0x26d019,util[_0x9382('0x14')](_0x9382('0x24'),_0x5c2bd2,_0x9382('0x26')))},function(_0x125eab,_0x38bba0){});rimraf(path[_0x9382('0x20')](_0x26d019,_0x5c2bd2),function(){});}})[_0x9382('0x12')](function(){logger['info'](util[_0x9382('0x14')](_0x9382('0x27'),EXTRACTED_REPORT_ID,_0x9382('0xe')));return analyticExtractedReport(_0x9382('0x28'),_0x70f1c6?util[_0x9382('0x14')]('%s.%s',_0x5c2bd2,_0x70f1c6?_0x9382('0x26'):_0x9382('0x23')):null);});})[_0x9382('0x29')](function(_0x12eb6c){logger[_0x9382('0x2a')](util[_0x9382('0x14')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x9382('0xe')),util[_0x9382('0x2b')](_0x12eb6c,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x9382('0x2c'));});}main();
\ No newline at end of file