// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6301=['join','each','%s%d.%s','xlsx','binary','%s.%s','XLSX','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','finally','exit','util','path','lodash','json2xls','bluebird','rimraf','../../mysqldb','dbH','../../config/logger','argv','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','splitSizeXlsx','then','query','sequelize','QueryTypes','SELECT','Empty','length','range','num','isInteger','forEach','%s\x20limit\x20%d\x20OFFSET\x20%d','push','dirname','basename','existsSync'];(function(_0x4f06b,_0x56c71d){var _0x3d6745=function(_0x976207){while(--_0x976207){_0x4f06b['push'](_0x4f06b['shift']());}};_0x3d6745(++_0x56c71d);}(_0x6301,0x9e));var _0x1630=function(_0x3fa479,_0x222259){_0x3fa479=_0x3fa479-0x0;var _0x23feb5=_0x6301[_0x3fa479];return _0x23feb5;};'use strict';var util=require(_0x1630('0x0'));var path=require(_0x1630('0x1'));var _=require(_0x1630('0x2'));var fs=require('fs');var json2xls=require(_0x1630('0x3'));var BPromise=require(_0x1630('0x4'));var zipdir=require('zip-dir');var rimraf=require(_0x1630('0x5'));var db=require('../../mysqldb')['db'];var dbH=require(_0x1630('0x6'))[_0x1630('0x7')];var logger=require(_0x1630('0x8'))('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x1630('0x9')][0x3];var PATH=process[_0x1630('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x1916cc,_0x496099){var _0x374c93={'status':_0x1916cc};var _0x3800b9={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x496099){_0x374c93['savename']=_0x496099;}return db[_0x1630('0xa')]['update'](_0x374c93,_0x3800b9);}function main(){var _0x4eebd5=0x1388;var _0x445d83;logger[_0x1630('0xb')](util[_0x1630('0xc')](_0x1630('0xd'),EXTRACTED_REPORT_ID,'XLSX'));return db[_0x1630('0xe')][_0x1630('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x1630('0x10'),_0x1630('0x11')]})[_0x1630('0x12')](function(_0x4001ba){if(_0x4001ba){_0x445d83=_0x4001ba;_0x4eebd5=_0x445d83[_0x1630('0x11')]||0x1388;}})[_0x1630('0x12')](function(){return dbH['sequelize'][_0x1630('0x13')](util[_0x1630('0xc')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x1630('0x14')][_0x1630('0x15')][_0x1630('0x16')]});})[_0x1630('0x12')](function(_0x17d944){if(!_0x17d944[0x0]['num']){return analyticExtractedReport(_0x1630('0x17'));}var _0x1bb023=[];var _0xd75d92=0x0;if(_0x445d83[_0x1630('0x10')]){if(_0x17d944&&_0x17d944[_0x1630('0x18')]){var _0x3c9008=_[_0x1630('0x19')](_0x17d944[0x0][_0x1630('0x1a')]/_0x4eebd5);var _0x4a7cae=Number[_0x1630('0x1b')](_0x17d944[0x0]['num']/_0x4eebd5)?_0x17d944[0x0][_0x1630('0x1a')]%_0x4eebd5:0x0;_0x3c9008[_0x1630('0x1c')](function(_0x2c6c81){if(_0x2c6c81>0x0){_0xd75d92+=_0x4eebd5;}_0x1bb023['push'](dbH[_0x1630('0x14')][_0x1630('0x13')](util[_0x1630('0xc')](_0x1630('0x1d'),QUERY,_0x4eebd5,_0xd75d92),{'type':dbH[_0x1630('0x14')][_0x1630('0x15')][_0x1630('0x16')]}));});if(_0x4a7cae>0x0){_0xd75d92+=_0x4eebd5;_0x1bb023['push'](dbH['sequelize'][_0x1630('0x13')](util['format'](_0x1630('0x1d'),QUERY,_0x4a7cae,_0xd75d92),{'type':dbH[_0x1630('0x14')][_0x1630('0x15')][_0x1630('0x16')]}));}}}else{_0x1bb023[_0x1630('0x1e')](dbH['sequelize'][_0x1630('0x13')](QUERY,{'type':dbH[_0x1630('0x14')][_0x1630('0x15')][_0x1630('0x16')]}));}var _0x149647=path[_0x1630('0x1f')](PATH);var _0x33cdb2=path[_0x1630('0x20')](PATH,'.xlsx');var _0x380d6e=_0x445d83[_0x1630('0x10')]&&_0x1bb023[_0x1630('0x18')]>0x1;var _0x381db1=[];if(!fs[_0x1630('0x21')](path['join'](_0x149647,_0x33cdb2))&&_0x380d6e){fs['mkdirSync'](path[_0x1630('0x22')](_0x149647,_0x33cdb2));}return BPromise[_0x1630('0x23')](_0x1bb023,function(_0x188399){_0x381db1[_0x1630('0x1e')](_0x188399);})[_0x1630('0x12')](function(){for(var _0xb17c1e=0x0;_0xb17c1e<_0x381db1[_0x1630('0x18')];_0xb17c1e+=0x1){var _0x1490ce;var _0x32a73d=_0x381db1[_0xb17c1e];if(_0x380d6e){_0x1490ce=path[_0x1630('0x22')](_0x149647,_0x33cdb2,util[_0x1630('0xc')](_0x1630('0x24'),_0x33cdb2,_0xb17c1e,_0x1630('0x25')));}else{_0x1490ce=path[_0x1630('0x22')](_0x149647,util[_0x1630('0xc')]('%s.%s',_0x33cdb2,_0x1630('0x25')));}fs['writeFileSync'](_0x1490ce,json2xls(_0x32a73d),_0x1630('0x26'));}})[_0x1630('0x12')](function(){if(_0x380d6e){return new Promise(function(_0xe0a657){zipdir(path[_0x1630('0x22')](_0x149647,_0x33cdb2),{'saveTo':path[_0x1630('0x22')](_0x149647,util[_0x1630('0xc')](_0x1630('0x27'),_0x33cdb2,'zip'))},function(_0x5d3019,_0x57192e){rimraf(path['join'](_0x149647,_0x33cdb2),function(){});_0xe0a657('zip\x20finished');});});}})[_0x1630('0x12')](function(){logger[_0x1630('0xb')](util[_0x1630('0xc')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x1630('0x28')));return analyticExtractedReport(_0x1630('0x29'),_0x380d6e?util[_0x1630('0xc')](_0x1630('0x27'),_0x33cdb2,_0x380d6e?'zip':_0x1630('0x25')):null);});})[_0x1630('0x2a')](function(_0x407910){logger['info'](util[_0x1630('0xc')](_0x1630('0x2b'),EXTRACTED_REPORT_ID,_0x1630('0x28')),util[_0x1630('0x2c')](_0x407910,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x1630('0x2d'));})[_0x1630('0x2e')](function(){process[_0x1630('0x2f')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x72c9=['splitSizeXlsx','then','query','format','sequelize','QueryTypes','SELECT','num','Empty','length','range','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','existsSync','join','each','xlsx','%s.%s','writeFileSync','binary','zip','zip\x20finished','info','Completed','catch','Failed','finally','util','path','json2xls','bluebird','rimraf','../../mysqldb','../../config/logger','argv','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','split'];(function(_0x4da662,_0x323c4b){var _0x590522=function(_0x387267){while(--_0x387267){_0x4da662['push'](_0x4da662['shift']());}};_0x590522(++_0x323c4b);}(_0x72c9,0xcc));var _0x972c=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x72c9[_0x3dd15e];return _0x231fd0;};'use strict';var util=require(_0x972c('0x0'));var path=require(_0x972c('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0x972c('0x2'));var BPromise=require(_0x972c('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0x972c('0x4'));var db=require(_0x972c('0x5'))['db'];var dbH=require(_0x972c('0x5'))['dbH'];var logger=require(_0x972c('0x6'))('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x972c('0x7')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x48afd7,_0x7de477){var _0x4e679c={'status':_0x48afd7};var _0x47a163={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x7de477){_0x4e679c['savename']=_0x7de477;}return db['AnalyticExtractedReport']['update'](_0x4e679c,_0x47a163);}function main(){var _0x728231=0x1388;var _0x75d2c8;logger['info'](util['format'](_0x972c('0x8'),EXTRACTED_REPORT_ID,_0x972c('0x9')));return db['Setting']['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x972c('0xa'),'splitSizeXlsx']})['then'](function(_0x22e6f8){if(_0x22e6f8){_0x75d2c8=_0x22e6f8;_0x728231=_0x75d2c8[_0x972c('0xb')]||0x1388;}})[_0x972c('0xc')](function(){return dbH['sequelize'][_0x972c('0xd')](util[_0x972c('0xe')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x972c('0xf')][_0x972c('0x10')][_0x972c('0x11')]});})[_0x972c('0xc')](function(_0x29cc34){if(!_0x29cc34[0x0][_0x972c('0x12')]){return analyticExtractedReport(_0x972c('0x13'));}var _0x3e3d11=[];var _0x3b685f=0x0;if(_0x75d2c8['split']){if(_0x29cc34&&_0x29cc34[_0x972c('0x14')]){var _0x83f53b=_[_0x972c('0x15')](_0x29cc34[0x0][_0x972c('0x12')]/_0x728231);var _0x5e8fba=Number[_0x972c('0x16')](_0x29cc34[0x0][_0x972c('0x12')]/_0x728231)?_0x29cc34[0x0][_0x972c('0x12')]%_0x728231:0x0;_0x83f53b[_0x972c('0x17')](function(_0x16af55){if(_0x16af55>0x0){_0x3b685f+=_0x728231;}_0x3e3d11[_0x972c('0x18')](dbH[_0x972c('0xf')][_0x972c('0xd')](util[_0x972c('0xe')](_0x972c('0x19'),QUERY,_0x728231,_0x3b685f),{'type':dbH[_0x972c('0xf')]['QueryTypes']['SELECT']}));});if(_0x5e8fba>0x0){_0x3b685f+=_0x728231;_0x3e3d11[_0x972c('0x18')](dbH[_0x972c('0xf')]['query'](util['format'](_0x972c('0x19'),QUERY,_0x5e8fba,_0x3b685f),{'type':dbH[_0x972c('0xf')][_0x972c('0x10')][_0x972c('0x11')]}));}}}else{_0x3e3d11[_0x972c('0x18')](dbH[_0x972c('0xf')][_0x972c('0xd')](QUERY,{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}var _0x1650ff=path[_0x972c('0x1a')](PATH);var _0x4f3b8c=path[_0x972c('0x1b')](PATH,_0x972c('0x1c'));var _0x668c7c=_0x75d2c8[_0x972c('0xa')]&&_0x3e3d11[_0x972c('0x14')]>0x1;var _0x4df20f=[];if(!fs[_0x972c('0x1d')](path['join'](_0x1650ff,_0x4f3b8c))&&_0x668c7c){fs['mkdirSync'](path[_0x972c('0x1e')](_0x1650ff,_0x4f3b8c));}return BPromise[_0x972c('0x1f')](_0x3e3d11,function(_0x435ade){_0x4df20f[_0x972c('0x18')](_0x435ade);})['then'](function(){for(var _0x2a5dc6=0x0;_0x2a5dc6<_0x4df20f[_0x972c('0x14')];_0x2a5dc6+=0x1){var _0x129af8;var _0x17cbb6=_0x4df20f[_0x2a5dc6];if(_0x668c7c){_0x129af8=path[_0x972c('0x1e')](_0x1650ff,_0x4f3b8c,util[_0x972c('0xe')]('%s%d.%s',_0x4f3b8c,_0x2a5dc6,_0x972c('0x20')));}else{_0x129af8=path[_0x972c('0x1e')](_0x1650ff,util['format'](_0x972c('0x21'),_0x4f3b8c,_0x972c('0x20')));}fs[_0x972c('0x22')](_0x129af8,json2xls(_0x17cbb6),_0x972c('0x23'));}})[_0x972c('0xc')](function(){if(_0x668c7c){return new Promise(function(_0x3496f7){zipdir(path[_0x972c('0x1e')](_0x1650ff,_0x4f3b8c),{'saveTo':path[_0x972c('0x1e')](_0x1650ff,util[_0x972c('0xe')](_0x972c('0x21'),_0x4f3b8c,_0x972c('0x24')))},function(_0x1d273a,_0x3cfcb5){rimraf(path[_0x972c('0x1e')](_0x1650ff,_0x4f3b8c),function(){});_0x3496f7(_0x972c('0x25'));});});}})[_0x972c('0xc')](function(){logger[_0x972c('0x26')](util[_0x972c('0xe')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,'XLSX'));return analyticExtractedReport(_0x972c('0x27'),_0x668c7c?util[_0x972c('0xe')](_0x972c('0x21'),_0x4f3b8c,_0x668c7c?_0x972c('0x24'):_0x972c('0x20')):null);});})[_0x972c('0x28')](function(_0x23aa85){logger[_0x972c('0x26')](util[_0x972c('0xe')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x972c('0x9')),util['inspect'](_0x23aa85,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x972c('0x29'));})[_0x972c('0x2a')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff