// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xac7d=['SELECT','dirname','basename','.csv','length','existsSync','mkdirSync','join','%s%d.%s','csv','%s.%s','zip','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','path','to-csv','bluebird','zip-dir','../../mysqldb','dbH','analytics','argv','savename','AnalyticExtractedReport','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','then','splitSizeCsv','sequelize','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','Empty','isInteger','num','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d'];(function(_0x3503e5,_0x490a96){var _0x2059fa=function(_0x6e735f){while(--_0x6e735f){_0x3503e5['push'](_0x3503e5['shift']());}};_0x2059fa(++_0x490a96);}(_0xac7d,0x6f));var _0xdac7=function(_0x2e73e5,_0x2ef23b){_0x2e73e5=_0x2e73e5-0x0;var _0x104540=_0xac7d[_0x2e73e5];return _0x104540;};'use strict';var util=require('util');var path=require(_0xdac7('0x0'));var _=require('lodash');var csv=require(_0xdac7('0x1'));var fs=require('fs');var BPromise=require(_0xdac7('0x2'));var zipdir=require(_0xdac7('0x3'));var rimraf=require('rimraf');var db=require(_0xdac7('0x4'))['db'];var dbH=require(_0xdac7('0x4'))[_0xdac7('0x5')];var logger=require('../../config/logger')(_0xdac7('0x6'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0xdac7('0x7')][0x3];var PATH=process[_0xdac7('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x2e40ce,_0x2d2c87){var _0x38b581={'status':_0x2e40ce};var _0x243ba9={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2d2c87){_0x38b581[_0xdac7('0x8')]=_0x2d2c87;}return db[_0xdac7('0x9')][_0xdac7('0xa')](_0x38b581,_0x243ba9);}function main(){var _0x3b2961=0x1388;var _0x5e23d0;logger[_0xdac7('0xb')](util['format'](_0xdac7('0xc'),EXTRACTED_REPORT_ID,_0xdac7('0xd')));return db[_0xdac7('0xe')][_0xdac7('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xdac7('0x10'),'splitSizeCsv']})[_0xdac7('0x11')](function(_0x1e80db){if(_0x1e80db){_0x5e23d0=_0x1e80db;_0x3b2961=_0x5e23d0[_0xdac7('0x12')]||0x1388;}})[_0xdac7('0x11')](function(){return dbH[_0xdac7('0x13')][_0xdac7('0x14')](util[_0xdac7('0x15')](_0xdac7('0x16'),QUERY),{'type':dbH[_0xdac7('0x13')][_0xdac7('0x17')]['SELECT']});})[_0xdac7('0x11')](function(_0x3edf5f){if(!_0x3edf5f[0x0]['num']){return analyticExtractedReport(_0xdac7('0x18'));}var _0x3ce6fc=[];var _0x1194d4=0x0;if(_0x5e23d0[_0xdac7('0x10')]){if(_0x3edf5f&&_0x3edf5f['length']){var _0x34f6b2=_['range'](_0x3edf5f[0x0]['num']/_0x3b2961);var _0x29db15=Number[_0xdac7('0x19')](_0x3edf5f[0x0][_0xdac7('0x1a')]/_0x3b2961)?_0x3edf5f[0x0][_0xdac7('0x1a')]%_0x3b2961:0x0;_0x34f6b2[_0xdac7('0x1b')](function(_0x583bc5){if(_0x583bc5>0x0){_0x1194d4+=_0x3b2961;}_0x3ce6fc[_0xdac7('0x1c')](dbH['sequelize'][_0xdac7('0x14')](util[_0xdac7('0x15')](_0xdac7('0x1d'),QUERY,_0x3b2961,_0x1194d4),{'type':dbH[_0xdac7('0x13')]['QueryTypes'][_0xdac7('0x1e')]}));});if(_0x29db15>0x0){_0x1194d4+=_0x3b2961;_0x3ce6fc[_0xdac7('0x1c')](dbH['sequelize']['query'](util[_0xdac7('0x15')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x29db15,_0x1194d4),{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}}}else{_0x3ce6fc[_0xdac7('0x1c')](dbH[_0xdac7('0x13')][_0xdac7('0x14')](QUERY,{'type':dbH[_0xdac7('0x13')]['QueryTypes'][_0xdac7('0x1e')]}));}var _0x20e532=path[_0xdac7('0x1f')](PATH);var _0x139a92=path[_0xdac7('0x20')](PATH,_0xdac7('0x21'));var _0x4a3ed5=_0x5e23d0[_0xdac7('0x10')]&&_0x3ce6fc[_0xdac7('0x22')]>0x1;var _0x13a8e=[];if(!fs[_0xdac7('0x23')](path['join'](_0x20e532,_0x139a92))&&_0x4a3ed5){fs[_0xdac7('0x24')](path['join'](_0x20e532,_0x139a92));}return BPromise['each'](_0x3ce6fc,function(_0x483355){_0x13a8e['push'](_0x483355);})['then'](function(){for(var _0x3dd863=0x0;_0x3dd863<_0x13a8e[_0xdac7('0x22')];_0x3dd863+=0x1){var _0x11fc28;var _0x5152fd=_0x13a8e[_0x3dd863];if(_0x4a3ed5){_0x11fc28=path[_0xdac7('0x25')](_0x20e532,_0x139a92,util[_0xdac7('0x15')](_0xdac7('0x26'),_0x139a92,_0x3dd863,_0xdac7('0x27')));}else{_0x11fc28=path[_0xdac7('0x25')](_0x20e532,util[_0xdac7('0x15')](_0xdac7('0x28'),_0x139a92,_0xdac7('0x27')));}fs['writeFileSync'](_0x11fc28,csv(_0x5152fd));}})[_0xdac7('0x11')](function(){if(_0x4a3ed5){return new Promise(function(_0xf1a047){zipdir(path[_0xdac7('0x25')](_0x20e532,_0x139a92),{'saveTo':path[_0xdac7('0x25')](_0x20e532,util[_0xdac7('0x15')]('%s.%s',_0x139a92,_0xdac7('0x29')))},function(_0x5c8126,_0x58b855){rimraf(path[_0xdac7('0x25')](_0x20e532,_0x139a92),function(){});_0xf1a047('zip\x20finished');});});}})[_0xdac7('0x11')](function(){logger[_0xdac7('0xb')](util[_0xdac7('0x15')](_0xdac7('0x2a'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport('Completed',_0x4a3ed5?util[_0xdac7('0x15')]('%s.%s',_0x139a92,_0x4a3ed5?_0xdac7('0x29'):_0xdac7('0x27')):null);});})[_0xdac7('0x2b')](function(_0x461923){logger[_0xdac7('0xb')](util[_0xdac7('0x15')](_0xdac7('0x2c'),EXTRACTED_REPORT_ID,_0xdac7('0xd')),util[_0xdac7('0x2d')](_0x461923,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xdac7('0x2e'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x6341=['bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','splitSizeCsv','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','SELECT','then','num','length','isInteger','push','%s\x20limit\x20%d\x20OFFSET\x20%d','basename','.csv','join','each','csv','%s.%s','zip','zip\x20finished','Completed','catch','inspect','Failed','finally','exit','util','path','to-csv'];(function(_0x4ae1f9,_0x234135){var _0xa72f18=function(_0x33c0dd){while(--_0x33c0dd){_0x4ae1f9['push'](_0x4ae1f9['shift']());}};_0xa72f18(++_0x234135);}(_0x6341,0x165));var _0x1634=function(_0x131d66,_0x3345c9){_0x131d66=_0x131d66-0x0;var _0x3771d7=_0x6341[_0x131d66];return _0x3771d7;};'use strict';var util=require(_0x1634('0x0'));var path=require(_0x1634('0x1'));var _=require('lodash');var csv=require(_0x1634('0x2'));var fs=require('fs');var BPromise=require(_0x1634('0x3'));var zipdir=require(_0x1634('0x4'));var rimraf=require(_0x1634('0x5'));var db=require(_0x1634('0x6'))['db'];var dbH=require(_0x1634('0x6'))[_0x1634('0x7')];var logger=require(_0x1634('0x8'))(_0x1634('0x9'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x1634('0xa')][0x3];var PATH=process[_0x1634('0xa')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0xf9f10f,_0x23c24d){var _0x4372a5={'status':_0xf9f10f};var _0xdf9b8f={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x23c24d){_0x4372a5[_0x1634('0xb')]=_0x23c24d;}return db['AnalyticExtractedReport'][_0x1634('0xc')](_0x4372a5,_0xdf9b8f);}function main(){var _0x564ebe=0x1388;var _0x5f0f31;logger[_0x1634('0xd')](util['format'](_0x1634('0xe'),EXTRACTED_REPORT_ID,_0x1634('0xf')));return db[_0x1634('0x10')][_0x1634('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x1634('0x12')]})['then'](function(_0x1477a2){if(_0x1477a2){_0x5f0f31=_0x1477a2;_0x564ebe=_0x5f0f31[_0x1634('0x12')]||0x1388;}})['then'](function(){return dbH['sequelize'][_0x1634('0x13')](util[_0x1634('0x14')](_0x1634('0x15'),QUERY),{'type':dbH[_0x1634('0x16')][_0x1634('0x17')][_0x1634('0x18')]});})[_0x1634('0x19')](function(_0x2cd92d){if(!_0x2cd92d[0x0][_0x1634('0x1a')]){return analyticExtractedReport('Empty');}var _0x21b350=[];var _0x1435f2=0x0;if(_0x5f0f31['split']){if(_0x2cd92d&&_0x2cd92d[_0x1634('0x1b')]){var _0x3ea66c=_['range'](_0x2cd92d[0x0]['num']/_0x564ebe);var _0x157a19=Number[_0x1634('0x1c')](_0x2cd92d[0x0][_0x1634('0x1a')]/_0x564ebe)?_0x2cd92d[0x0][_0x1634('0x1a')]%_0x564ebe:0x0;_0x3ea66c['forEach'](function(_0x5c0f4f){if(_0x5c0f4f>0x0){_0x1435f2+=_0x564ebe;}_0x21b350[_0x1634('0x1d')](dbH[_0x1634('0x16')]['query'](util[_0x1634('0x14')](_0x1634('0x1e'),QUERY,_0x564ebe,_0x1435f2),{'type':dbH['sequelize'][_0x1634('0x17')][_0x1634('0x18')]}));});if(_0x157a19>0x0){_0x1435f2+=_0x564ebe;_0x21b350[_0x1634('0x1d')](dbH[_0x1634('0x16')][_0x1634('0x13')](util[_0x1634('0x14')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x157a19,_0x1435f2),{'type':dbH[_0x1634('0x16')][_0x1634('0x17')][_0x1634('0x18')]}));}}}else{_0x21b350['push'](dbH['sequelize'][_0x1634('0x13')](QUERY,{'type':dbH[_0x1634('0x16')][_0x1634('0x17')][_0x1634('0x18')]}));}var _0x379f0b=path['dirname'](PATH);var _0xe818c4=path[_0x1634('0x1f')](PATH,_0x1634('0x20'));var _0x36fa08=_0x5f0f31['split']&&_0x21b350[_0x1634('0x1b')]>0x1;var _0x32a1a4=[];if(!fs['existsSync'](path[_0x1634('0x21')](_0x379f0b,_0xe818c4))&&_0x36fa08){fs['mkdirSync'](path[_0x1634('0x21')](_0x379f0b,_0xe818c4));}return BPromise[_0x1634('0x22')](_0x21b350,function(_0x1aa26e){_0x32a1a4[_0x1634('0x1d')](_0x1aa26e);})[_0x1634('0x19')](function(){for(var _0x3d1db8=0x0;_0x3d1db8<_0x32a1a4['length'];_0x3d1db8+=0x1){var _0x3df66c;var _0x1e38a4=_0x32a1a4[_0x3d1db8];if(_0x36fa08){_0x3df66c=path['join'](_0x379f0b,_0xe818c4,util['format']('%s%d.%s',_0xe818c4,_0x3d1db8,_0x1634('0x23')));}else{_0x3df66c=path['join'](_0x379f0b,util[_0x1634('0x14')](_0x1634('0x24'),_0xe818c4,_0x1634('0x23')));}fs['writeFileSync'](_0x3df66c,csv(_0x1e38a4));}})[_0x1634('0x19')](function(){if(_0x36fa08){return new Promise(function(_0x9e0b82){zipdir(path[_0x1634('0x21')](_0x379f0b,_0xe818c4),{'saveTo':path['join'](_0x379f0b,util[_0x1634('0x14')](_0x1634('0x24'),_0xe818c4,_0x1634('0x25')))},function(_0x370fb1,_0x4d51f0){rimraf(path[_0x1634('0x21')](_0x379f0b,_0xe818c4),function(){});_0x9e0b82(_0x1634('0x26'));});});}})[_0x1634('0x19')](function(){logger[_0x1634('0xd')](util[_0x1634('0x14')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x1634('0x27'),_0x36fa08?util[_0x1634('0x14')](_0x1634('0x24'),_0xe818c4,_0x36fa08?'zip':_0x1634('0x23')):null);});})[_0x1634('0x28')](function(_0x5ebe3f){logger[_0x1634('0xd')](util[_0x1634('0x14')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x1634('0xf')),util[_0x1634('0x29')](_0x5ebe3f,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x1634('0x2a'));})[_0x1634('0x2b')](function(){process[_0x1634('0x2c')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff