// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe423=['SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','Empty','length','range','num','isInteger','forEach','%s\x20limit\x20%d\x20OFFSET\x20%d','push','dirname','basename','.xlsx','join','mkdirSync','%s%d.%s','xlsx','writeFileSync','binary','zip\x20finished','Completed','inspect','exit','util','path','lodash','rimraf','../../mysqldb','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','find','split','then','splitSizeXlsx','sequelize','query'];(function(_0x1d949f,_0x3a914e){var _0x50a59e=function(_0x10ccfb){while(--_0x10ccfb){_0x1d949f['push'](_0x1d949f['shift']());}};_0x50a59e(++_0x3a914e);}(_0xe423,0xf4));var _0x3e42=function(_0x1ba05a,_0x3460fd){_0x1ba05a=_0x1ba05a-0x0;var _0x5b9908=_0xe423[_0x1ba05a];return _0x5b9908;};'use strict';var util=require(_0x3e42('0x0'));var path=require(_0x3e42('0x1'));var _=require(_0x3e42('0x2'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require(_0x3e42('0x3'));var db=require(_0x3e42('0x4'))['db'];var dbH=require('../../mysqldb')['dbH'];var logger=require('../../config/logger')(_0x3e42('0x5'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x3e42('0x6')][0x3];var PATH=process[_0x3e42('0x6')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x1d848a,_0x111edf){var _0x5e1d96={'status':_0x1d848a};var _0x48cd63={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x111edf){_0x5e1d96[_0x3e42('0x7')]=_0x111edf;}return db[_0x3e42('0x8')][_0x3e42('0x9')](_0x5e1d96,_0x48cd63);}function main(){var _0x1dca1e=0x1388;var _0x53a1ad;logger[_0x3e42('0xa')](util[_0x3e42('0xb')](_0x3e42('0xc'),EXTRACTED_REPORT_ID,_0x3e42('0xd')));return db['Setting'][_0x3e42('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x3e42('0xf'),'splitSizeXlsx']})[_0x3e42('0x10')](function(_0x36e3c6){if(_0x36e3c6){_0x53a1ad=_0x36e3c6;_0x1dca1e=_0x53a1ad[_0x3e42('0x11')]||0x1388;}})[_0x3e42('0x10')](function(){return dbH[_0x3e42('0x12')][_0x3e42('0x13')](util[_0x3e42('0xb')](_0x3e42('0x14'),QUERY),{'type':dbH[_0x3e42('0x12')][_0x3e42('0x15')][_0x3e42('0x16')]});})['then'](function(_0x39cc83){if(!_0x39cc83[0x0]['num']){return analyticExtractedReport(_0x3e42('0x17'));}var _0x91c3cf=[];var _0x475c28=0x0;if(_0x53a1ad[_0x3e42('0xf')]){if(_0x39cc83&&_0x39cc83[_0x3e42('0x18')]){var _0x45ef97=_[_0x3e42('0x19')](_0x39cc83[0x0][_0x3e42('0x1a')]/_0x1dca1e);var _0x108f87=Number[_0x3e42('0x1b')](_0x39cc83[0x0][_0x3e42('0x1a')]/_0x1dca1e)?_0x39cc83[0x0][_0x3e42('0x1a')]%_0x1dca1e:0x0;_0x45ef97[_0x3e42('0x1c')](function(_0xdbeb7d){if(_0xdbeb7d>0x0){_0x475c28+=_0x1dca1e;}_0x91c3cf['push'](dbH[_0x3e42('0x12')][_0x3e42('0x13')](util['format'](_0x3e42('0x1d'),QUERY,_0x1dca1e,_0x475c28),{'type':dbH['sequelize'][_0x3e42('0x15')]['SELECT']}));});if(_0x108f87>0x0){_0x475c28+=_0x1dca1e;_0x91c3cf[_0x3e42('0x1e')](dbH[_0x3e42('0x12')][_0x3e42('0x13')](util[_0x3e42('0xb')](_0x3e42('0x1d'),QUERY,_0x108f87,_0x475c28),{'type':dbH[_0x3e42('0x12')][_0x3e42('0x15')]['SELECT']}));}}}else{_0x91c3cf['push'](dbH['sequelize'][_0x3e42('0x13')](QUERY,{'type':dbH['sequelize'][_0x3e42('0x15')][_0x3e42('0x16')]}));}var _0x12b6a5=path[_0x3e42('0x1f')](PATH);var _0x120012=path[_0x3e42('0x20')](PATH,_0x3e42('0x21'));var _0x4cdc10=_0x53a1ad['split']&&_0x91c3cf[_0x3e42('0x18')]>0x1;var _0xbb709a=[];if(!fs['existsSync'](path[_0x3e42('0x22')](_0x12b6a5,_0x120012))&&_0x4cdc10){fs[_0x3e42('0x23')](path[_0x3e42('0x22')](_0x12b6a5,_0x120012));}return BPromise['each'](_0x91c3cf,function(_0x3e5a7f){_0xbb709a[_0x3e42('0x1e')](_0x3e5a7f);})[_0x3e42('0x10')](function(){for(var _0x243a76=0x0;_0x243a76<_0xbb709a[_0x3e42('0x18')];_0x243a76+=0x1){var _0x2e951b;var _0x522128=_0xbb709a[_0x243a76];if(_0x4cdc10){_0x2e951b=path[_0x3e42('0x22')](_0x12b6a5,_0x120012,util['format'](_0x3e42('0x24'),_0x120012,_0x243a76,_0x3e42('0x25')));}else{_0x2e951b=path[_0x3e42('0x22')](_0x12b6a5,util[_0x3e42('0xb')]('%s.%s',_0x120012,'xlsx'));}fs[_0x3e42('0x26')](_0x2e951b,json2xls(_0x522128),_0x3e42('0x27'));}})['then'](function(){if(_0x4cdc10){return new Promise(function(_0x415ca8){zipdir(path['join'](_0x12b6a5,_0x120012),{'saveTo':path['join'](_0x12b6a5,util['format']('%s.%s',_0x120012,'zip'))},function(_0x3a2046,_0x2fe2b8){rimraf(path[_0x3e42('0x22')](_0x12b6a5,_0x120012),function(){});_0x415ca8(_0x3e42('0x28'));});});}})[_0x3e42('0x10')](function(){logger[_0x3e42('0xa')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x3e42('0xd')));return analyticExtractedReport(_0x3e42('0x29'),_0x4cdc10?util[_0x3e42('0xb')]('%s.%s',_0x120012,_0x4cdc10?'zip':_0x3e42('0x25')):null);});})['catch'](function(_0x2e5f55){logger[_0x3e42('0xa')](util['format']('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x3e42('0xd')),util[_0x3e42('0x2a')](_0x2e5f55,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})['finally'](function(){process[_0x3e42('0x2b')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x2d75=['splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','length','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','join','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','zip\x20finished','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','finally','path','lodash','json2xls','zip-dir','../../mysqldb','dbH','../../config/logger','argv','savename','AnalyticExtractedReport','info','format','XLSX','Setting','find','split'];(function(_0x5b9863,_0x59c315){var _0x2e3b07=function(_0xec9e59){while(--_0xec9e59){_0x5b9863['push'](_0x5b9863['shift']());}};_0x2e3b07(++_0x59c315);}(_0x2d75,0xa4));var _0x52d7=function(_0x433439,_0x2483b5){_0x433439=_0x433439-0x0;var _0x4e8348=_0x2d75[_0x433439];return _0x4e8348;};'use strict';var util=require('util');var path=require(_0x52d7('0x0'));var _=require(_0x52d7('0x1'));var fs=require('fs');var json2xls=require(_0x52d7('0x2'));var BPromise=require('bluebird');var zipdir=require(_0x52d7('0x3'));var rimraf=require('rimraf');var db=require(_0x52d7('0x4'))['db'];var dbH=require(_0x52d7('0x4'))[_0x52d7('0x5')];var logger=require(_0x52d7('0x6'))('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x52d7('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x45a1f6,_0xa6001e){var _0x19bbb4={'status':_0x45a1f6};var _0x473e1b={'where':{'id':EXTRACTED_REPORT_ID}};if(_0xa6001e){_0x19bbb4[_0x52d7('0x8')]=_0xa6001e;}return db[_0x52d7('0x9')]['update'](_0x19bbb4,_0x473e1b);}function main(){var _0x5b4002=0x1388;var _0x4b1ecf;logger[_0x52d7('0xa')](util[_0x52d7('0xb')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x52d7('0xc')));return db[_0x52d7('0xd')][_0x52d7('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x52d7('0xf'),_0x52d7('0x10')]})[_0x52d7('0x11')](function(_0x24cbdf){if(_0x24cbdf){_0x4b1ecf=_0x24cbdf;_0x5b4002=_0x4b1ecf[_0x52d7('0x10')]||0x1388;}})[_0x52d7('0x11')](function(){return dbH[_0x52d7('0x12')][_0x52d7('0x13')](util[_0x52d7('0xb')](_0x52d7('0x14'),QUERY),{'type':dbH[_0x52d7('0x12')][_0x52d7('0x15')][_0x52d7('0x16')]});})['then'](function(_0x833c83){if(!_0x833c83[0x0][_0x52d7('0x17')]){return analyticExtractedReport('Empty');}var _0x227d36=[];var _0x25970f=0x0;if(_0x4b1ecf[_0x52d7('0xf')]){if(_0x833c83&&_0x833c83[_0x52d7('0x18')]){var _0x2e7bb9=_['range'](_0x833c83[0x0][_0x52d7('0x17')]/_0x5b4002);var _0x12e948=Number[_0x52d7('0x19')](_0x833c83[0x0][_0x52d7('0x17')]/_0x5b4002)?_0x833c83[0x0][_0x52d7('0x17')]%_0x5b4002:0x0;_0x2e7bb9[_0x52d7('0x1a')](function(_0x5f461f){if(_0x5f461f>0x0){_0x25970f+=_0x5b4002;}_0x227d36[_0x52d7('0x1b')](dbH[_0x52d7('0x12')]['query'](util[_0x52d7('0xb')](_0x52d7('0x1c'),QUERY,_0x5b4002,_0x25970f),{'type':dbH[_0x52d7('0x12')]['QueryTypes'][_0x52d7('0x16')]}));});if(_0x12e948>0x0){_0x25970f+=_0x5b4002;_0x227d36[_0x52d7('0x1b')](dbH[_0x52d7('0x12')][_0x52d7('0x13')](util[_0x52d7('0xb')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x12e948,_0x25970f),{'type':dbH[_0x52d7('0x12')][_0x52d7('0x15')][_0x52d7('0x16')]}));}}}else{_0x227d36[_0x52d7('0x1b')](dbH[_0x52d7('0x12')]['query'](QUERY,{'type':dbH['sequelize'][_0x52d7('0x15')][_0x52d7('0x16')]}));}var _0x4f7822=path[_0x52d7('0x1d')](PATH);var _0x149a1b=path[_0x52d7('0x1e')](PATH,_0x52d7('0x1f'));var _0xd1d982=_0x4b1ecf['split']&&_0x227d36['length']>0x1;var _0x426bcb=[];if(!fs['existsSync'](path[_0x52d7('0x20')](_0x4f7822,_0x149a1b))&&_0xd1d982){fs['mkdirSync'](path['join'](_0x4f7822,_0x149a1b));}return BPromise[_0x52d7('0x21')](_0x227d36,function(_0x116267){_0x426bcb[_0x52d7('0x1b')](_0x116267);})[_0x52d7('0x11')](function(){for(var _0xb23c6d=0x0;_0xb23c6d<_0x426bcb[_0x52d7('0x18')];_0xb23c6d+=0x1){var _0x27b213;var _0x334e45=_0x426bcb[_0xb23c6d];if(_0xd1d982){_0x27b213=path[_0x52d7('0x20')](_0x4f7822,_0x149a1b,util['format'](_0x52d7('0x22'),_0x149a1b,_0xb23c6d,_0x52d7('0x23')));}else{_0x27b213=path['join'](_0x4f7822,util[_0x52d7('0xb')](_0x52d7('0x24'),_0x149a1b,_0x52d7('0x23')));}fs[_0x52d7('0x25')](_0x27b213,json2xls(_0x334e45),_0x52d7('0x26'));}})[_0x52d7('0x11')](function(){if(_0xd1d982){return new Promise(function(_0x4dc58c){zipdir(path[_0x52d7('0x20')](_0x4f7822,_0x149a1b),{'saveTo':path['join'](_0x4f7822,util['format'](_0x52d7('0x24'),_0x149a1b,_0x52d7('0x27')))},function(_0x410cb7,_0x4586d2){rimraf(path[_0x52d7('0x20')](_0x4f7822,_0x149a1b),function(){});_0x4dc58c(_0x52d7('0x28'));});});}})['then'](function(){logger[_0x52d7('0xa')](util[_0x52d7('0xb')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x52d7('0xc')));return analyticExtractedReport('Completed',_0xd1d982?util['format'](_0x52d7('0x24'),_0x149a1b,_0xd1d982?_0x52d7('0x27'):'xlsx'):null);});})[_0x52d7('0x29')](function(_0x142d3f){logger[_0x52d7('0xa')](util[_0x52d7('0xb')](_0x52d7('0x2a'),EXTRACTED_REPORT_ID,'XLSX'),util['inspect'](_0x142d3f,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x52d7('0x2b'));})[_0x52d7('0x2c')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff