// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3ffd=['dbH','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','find','split','splitSizeXlsx','then','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','Empty','range','num','isInteger','forEach','push','sequelize','QueryTypes','dirname','basename','existsSync','join','mkdirSync','each','length','%s%d.%s','%s.%s','xlsx','writeFileSync','binary','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','XLSX','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','finally','exit','util','lodash','../../mysqldb'];(function(_0x204b2d,_0x4b4175){var _0x8da4bf=function(_0x491736){while(--_0x491736){_0x204b2d['push'](_0x204b2d['shift']());}};_0x8da4bf(++_0x4b4175);}(_0x3ffd,0x84));var _0xd3ff=function(_0x130705,_0x2d266b){_0x130705=_0x130705-0x0;var _0x1fa991=_0x3ffd[_0x130705];return _0x1fa991;};'use strict';var util=require(_0xd3ff('0x0'));var path=require('path');var _=require(_0xd3ff('0x1'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require('../../mysqldb')['db'];var dbH=require(_0xd3ff('0x2'))[_0xd3ff('0x3')];var logger=require('../../config/logger')('analytics');var EXTRACTED_REPORT_ID=Number(process[_0xd3ff('0x4')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0xd3ff('0x4')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x4e3d71,_0x243062){var _0x56dad7={'status':_0x4e3d71};var _0x6370fc={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x243062){_0x56dad7[_0xd3ff('0x5')]=_0x243062;}return db[_0xd3ff('0x6')][_0xd3ff('0x7')](_0x56dad7,_0x6370fc);}function main(){var _0x55b1a6=0x1388;var _0x13c298;logger[_0xd3ff('0x8')](util[_0xd3ff('0x9')](_0xd3ff('0xa'),EXTRACTED_REPORT_ID,'XLSX'));return db['Setting'][_0xd3ff('0xb')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xd3ff('0xc'),_0xd3ff('0xd')]})[_0xd3ff('0xe')](function(_0x56e8b4){if(_0x56e8b4){_0x13c298=_0x56e8b4;_0x55b1a6=_0x13c298[_0xd3ff('0xd')]||0x1388;}})['then'](function(){return dbH['sequelize'][_0xd3ff('0xf')](util[_0xd3ff('0x9')](_0xd3ff('0x10'),QUERY),{'type':dbH['sequelize']['QueryTypes'][_0xd3ff('0x11')]});})[_0xd3ff('0xe')](function(_0x3a55f4){if(!_0x3a55f4[0x0]['num']){return analyticExtractedReport(_0xd3ff('0x12'));}var _0x31f439=[];var _0x4d3eee=0x0;if(_0x13c298['split']){if(_0x3a55f4&&_0x3a55f4['length']){var _0x588e17=_[_0xd3ff('0x13')](_0x3a55f4[0x0][_0xd3ff('0x14')]/_0x55b1a6);var _0x49b2e4=Number[_0xd3ff('0x15')](_0x3a55f4[0x0]['num']/_0x55b1a6)?_0x3a55f4[0x0]['num']%_0x55b1a6:0x0;_0x588e17[_0xd3ff('0x16')](function(_0x4e8f8e){if(_0x4e8f8e>0x0){_0x4d3eee+=_0x55b1a6;}_0x31f439[_0xd3ff('0x17')](dbH[_0xd3ff('0x18')]['query'](util[_0xd3ff('0x9')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x55b1a6,_0x4d3eee),{'type':dbH['sequelize']['QueryTypes'][_0xd3ff('0x11')]}));});if(_0x49b2e4>0x0){_0x4d3eee+=_0x55b1a6;_0x31f439[_0xd3ff('0x17')](dbH['sequelize']['query'](util[_0xd3ff('0x9')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x49b2e4,_0x4d3eee),{'type':dbH[_0xd3ff('0x18')][_0xd3ff('0x19')][_0xd3ff('0x11')]}));}}}else{_0x31f439[_0xd3ff('0x17')](dbH[_0xd3ff('0x18')][_0xd3ff('0xf')](QUERY,{'type':dbH[_0xd3ff('0x18')]['QueryTypes'][_0xd3ff('0x11')]}));}var _0x45e3a0=path[_0xd3ff('0x1a')](PATH);var _0xd6fdfb=path[_0xd3ff('0x1b')](PATH,'.xlsx');var _0x56fdb9=_0x13c298['split']&&_0x31f439['length']>0x1;var _0x117c6a=[];if(!fs[_0xd3ff('0x1c')](path[_0xd3ff('0x1d')](_0x45e3a0,_0xd6fdfb))&&_0x56fdb9){fs[_0xd3ff('0x1e')](path[_0xd3ff('0x1d')](_0x45e3a0,_0xd6fdfb));}return BPromise[_0xd3ff('0x1f')](_0x31f439,function(_0xd6ba1b){_0x117c6a[_0xd3ff('0x17')](_0xd6ba1b);})['then'](function(){for(var _0x24c5f8=0x0;_0x24c5f8<_0x117c6a[_0xd3ff('0x20')];_0x24c5f8+=0x1){var _0x3e2b70;var _0x1a4d92=_0x117c6a[_0x24c5f8];if(_0x56fdb9){_0x3e2b70=path[_0xd3ff('0x1d')](_0x45e3a0,_0xd6fdfb,util[_0xd3ff('0x9')](_0xd3ff('0x21'),_0xd6fdfb,_0x24c5f8,'xlsx'));}else{_0x3e2b70=path[_0xd3ff('0x1d')](_0x45e3a0,util[_0xd3ff('0x9')](_0xd3ff('0x22'),_0xd6fdfb,_0xd3ff('0x23')));}fs[_0xd3ff('0x24')](_0x3e2b70,json2xls(_0x1a4d92),_0xd3ff('0x25'));}})[_0xd3ff('0xe')](function(){if(_0x56fdb9){return new Promise(function(_0x402242){zipdir(path[_0xd3ff('0x1d')](_0x45e3a0,_0xd6fdfb),{'saveTo':path['join'](_0x45e3a0,util[_0xd3ff('0x9')](_0xd3ff('0x22'),_0xd6fdfb,_0xd3ff('0x26')))},function(_0x3475ab,_0x1beec3){rimraf(path[_0xd3ff('0x1d')](_0x45e3a0,_0xd6fdfb),function(){});_0x402242('zip\x20finished');});});}})[_0xd3ff('0xe')](function(){logger[_0xd3ff('0x8')](util[_0xd3ff('0x9')](_0xd3ff('0x27'),EXTRACTED_REPORT_ID,_0xd3ff('0x28')));return analyticExtractedReport('Completed',_0x56fdb9?util[_0xd3ff('0x9')]('%s.%s',_0xd6fdfb,_0x56fdb9?_0xd3ff('0x26'):_0xd3ff('0x23')):null);});})['catch'](function(_0x214e29){logger[_0xd3ff('0x8')](util[_0xd3ff('0x9')](_0xd3ff('0x29'),EXTRACTED_REPORT_ID,_0xd3ff('0x28')),util[_0xd3ff('0x2a')](_0x214e29,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0xd3ff('0x2b')](function(){process[_0xd3ff('0x2c')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x3e49=['existsSync','join','each','%s.%s','xlsx','writeFileSync','binary','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','Failed','finally','exit','util','path','lodash','json2xls','zip-dir','rimraf','analytics','argv','savename','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','split','splitSizeXlsx','then','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','SELECT','num','Empty','range','push','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','basename','.xlsx','length'];(function(_0xc8f777,_0xe9e88f){var _0x28bce1=function(_0x3d4da5){while(--_0x3d4da5){_0xc8f777['push'](_0xc8f777['shift']());}};_0x28bce1(++_0xe9e88f);}(_0x3e49,0xfb));var _0x93e4=function(_0x5cbf7b,_0x34e24b){_0x5cbf7b=_0x5cbf7b-0x0;var _0xc91356=_0x3e49[_0x5cbf7b];return _0xc91356;};'use strict';var util=require(_0x93e4('0x0'));var path=require(_0x93e4('0x1'));var _=require(_0x93e4('0x2'));var fs=require('fs');var json2xls=require(_0x93e4('0x3'));var BPromise=require('bluebird');var zipdir=require(_0x93e4('0x4'));var rimraf=require(_0x93e4('0x5'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')['dbH'];var logger=require('../../config/logger')(_0x93e4('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x93e4('0x7')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x93e4('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x438831,_0x33390d){var _0x195909={'status':_0x438831};var _0x206a64={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x33390d){_0x195909[_0x93e4('0x8')]=_0x33390d;}return db[_0x93e4('0x9')]['update'](_0x195909,_0x206a64);}function main(){var _0x113d53=0x1388;var _0x53a943;logger[_0x93e4('0xa')](util[_0x93e4('0xb')](_0x93e4('0xc'),EXTRACTED_REPORT_ID,_0x93e4('0xd')));return db[_0x93e4('0xe')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x93e4('0xf'),_0x93e4('0x10')]})[_0x93e4('0x11')](function(_0x4d5d66){if(_0x4d5d66){_0x53a943=_0x4d5d66;_0x113d53=_0x53a943[_0x93e4('0x10')]||0x1388;}})[_0x93e4('0x11')](function(){return dbH['sequelize'][_0x93e4('0x12')](util[_0x93e4('0xb')](_0x93e4('0x13'),QUERY),{'type':dbH[_0x93e4('0x14')]['QueryTypes'][_0x93e4('0x15')]});})['then'](function(_0x4ba240){if(!_0x4ba240[0x0][_0x93e4('0x16')]){return analyticExtractedReport(_0x93e4('0x17'));}var _0x5b1a67=[];var _0x123da8=0x0;if(_0x53a943[_0x93e4('0xf')]){if(_0x4ba240&&_0x4ba240['length']){var _0xc5ce72=_[_0x93e4('0x18')](_0x4ba240[0x0]['num']/_0x113d53);var _0x238091=Number['isInteger'](_0x4ba240[0x0][_0x93e4('0x16')]/_0x113d53)?_0x4ba240[0x0][_0x93e4('0x16')]%_0x113d53:0x0;_0xc5ce72['forEach'](function(_0x3dfb94){if(_0x3dfb94>0x0){_0x123da8+=_0x113d53;}_0x5b1a67[_0x93e4('0x19')](dbH[_0x93e4('0x14')][_0x93e4('0x12')](util[_0x93e4('0xb')](_0x93e4('0x1a'),QUERY,_0x113d53,_0x123da8),{'type':dbH['sequelize']['QueryTypes'][_0x93e4('0x15')]}));});if(_0x238091>0x0){_0x123da8+=_0x113d53;_0x5b1a67[_0x93e4('0x19')](dbH[_0x93e4('0x14')]['query'](util['format'](_0x93e4('0x1a'),QUERY,_0x238091,_0x123da8),{'type':dbH[_0x93e4('0x14')][_0x93e4('0x1b')][_0x93e4('0x15')]}));}}}else{_0x5b1a67[_0x93e4('0x19')](dbH[_0x93e4('0x14')][_0x93e4('0x12')](QUERY,{'type':dbH[_0x93e4('0x14')][_0x93e4('0x1b')][_0x93e4('0x15')]}));}var _0x2bca42=path['dirname'](PATH);var _0xd3559e=path[_0x93e4('0x1c')](PATH,_0x93e4('0x1d'));var _0x2f259b=_0x53a943[_0x93e4('0xf')]&&_0x5b1a67[_0x93e4('0x1e')]>0x1;var _0x3761c9=[];if(!fs[_0x93e4('0x1f')](path[_0x93e4('0x20')](_0x2bca42,_0xd3559e))&&_0x2f259b){fs['mkdirSync'](path[_0x93e4('0x20')](_0x2bca42,_0xd3559e));}return BPromise[_0x93e4('0x21')](_0x5b1a67,function(_0x5ede08){_0x3761c9[_0x93e4('0x19')](_0x5ede08);})[_0x93e4('0x11')](function(){for(var _0x11055b=0x0;_0x11055b<_0x3761c9['length'];_0x11055b+=0x1){var _0x3b7701;var _0x1e88b9=_0x3761c9[_0x11055b];if(_0x2f259b){_0x3b7701=path[_0x93e4('0x20')](_0x2bca42,_0xd3559e,util['format']('%s%d.%s',_0xd3559e,_0x11055b,'xlsx'));}else{_0x3b7701=path[_0x93e4('0x20')](_0x2bca42,util[_0x93e4('0xb')](_0x93e4('0x22'),_0xd3559e,_0x93e4('0x23')));}fs[_0x93e4('0x24')](_0x3b7701,json2xls(_0x1e88b9),_0x93e4('0x25'));}})[_0x93e4('0x11')](function(){if(_0x2f259b){return new Promise(function(_0x1cc33a){zipdir(path['join'](_0x2bca42,_0xd3559e),{'saveTo':path[_0x93e4('0x20')](_0x2bca42,util[_0x93e4('0xb')]('%s.%s',_0xd3559e,_0x93e4('0x26')))},function(_0x5af911,_0x173746){rimraf(path['join'](_0x2bca42,_0xd3559e),function(){});_0x1cc33a(_0x93e4('0x27'));});});}})[_0x93e4('0x11')](function(){logger[_0x93e4('0xa')](util[_0x93e4('0xb')](_0x93e4('0x28'),EXTRACTED_REPORT_ID,_0x93e4('0xd')));return analyticExtractedReport(_0x93e4('0x29'),_0x2f259b?util['format']('%s.%s',_0xd3559e,_0x2f259b?_0x93e4('0x26'):_0x93e4('0x23')):null);});})['catch'](function(_0x3e912d){logger[_0x93e4('0xa')](util[_0x93e4('0xb')](_0x93e4('0x2a'),EXTRACTED_REPORT_ID,_0x93e4('0xd')),util[_0x93e4('0x2b')](_0x3e912d,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x93e4('0x2c'));})[_0x93e4('0x2d')](function(){process[_0x93e4('0x2e')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff