// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5cd1=['Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','util','path','bluebird','zip-dir','rimraf','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','find','split','splitSizeXlsx','then','sequelize','QueryTypes','SELECT','num','Empty','length','isInteger','push','query','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','existsSync','join','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch'];(function(_0x513aa5,_0x1fba79){var _0x1a1a7c=function(_0x240e3f){while(--_0x240e3f){_0x513aa5['push'](_0x513aa5['shift']());}};_0x1a1a7c(++_0x1fba79);}(_0x5cd1,0x1cf));var _0x15cd=function(_0x4f8558,_0x73052b){_0x4f8558=_0x4f8558-0x0;var _0x202d81=_0x5cd1[_0x4f8558];return _0x202d81;};'use strict';var util=require(_0x15cd('0x0'));var path=require(_0x15cd('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0x15cd('0x2'));var zipdir=require(_0x15cd('0x3'));var rimraf=require(_0x15cd('0x4'));var db=require('../../mysqldb')['db'];var dbH=require('../../mysqldb')['dbH'];var logger=require(_0x15cd('0x5'))(_0x15cd('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0x15cd('0x7')][0x2]);var QUERY=process[_0x15cd('0x7')][0x3];var PATH=process[_0x15cd('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x24ab27,_0x3b3cf5){var _0x20613c={'status':_0x24ab27};var _0x809152={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x3b3cf5){_0x20613c[_0x15cd('0x8')]=_0x3b3cf5;}return db[_0x15cd('0x9')][_0x15cd('0xa')](_0x20613c,_0x809152);}function main(){var _0x356cae=0x1388;var _0x3b959a;logger[_0x15cd('0xb')](util[_0x15cd('0xc')](_0x15cd('0xd'),EXTRACTED_REPORT_ID,_0x15cd('0xe')));return db['Setting'][_0x15cd('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x15cd('0x10'),_0x15cd('0x11')]})[_0x15cd('0x12')](function(_0x5bfbeb){if(_0x5bfbeb){_0x3b959a=_0x5bfbeb;_0x356cae=_0x3b959a[_0x15cd('0x11')]||0x1388;}})['then'](function(){return dbH[_0x15cd('0x13')]['query'](util[_0x15cd('0xc')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x15cd('0x13')][_0x15cd('0x14')][_0x15cd('0x15')]});})[_0x15cd('0x12')](function(_0x152941){if(!_0x152941[0x0][_0x15cd('0x16')]){return analyticExtractedReport(_0x15cd('0x17'));}var _0x3d89a2=[];var _0x503cca=0x0;if(_0x3b959a[_0x15cd('0x10')]){if(_0x152941&&_0x152941[_0x15cd('0x18')]){var _0x3c9d6a=_['range'](_0x152941[0x0][_0x15cd('0x16')]/_0x356cae);var _0x8b1167=Number[_0x15cd('0x19')](_0x152941[0x0][_0x15cd('0x16')]/_0x356cae)?_0x152941[0x0][_0x15cd('0x16')]%_0x356cae:0x0;_0x3c9d6a['forEach'](function(_0x5a9942){if(_0x5a9942>0x0){_0x503cca+=_0x356cae;}_0x3d89a2[_0x15cd('0x1a')](dbH['sequelize'][_0x15cd('0x1b')](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x356cae,_0x503cca),{'type':dbH[_0x15cd('0x13')][_0x15cd('0x14')][_0x15cd('0x15')]}));});if(_0x8b1167>0x0){_0x503cca+=_0x356cae;_0x3d89a2[_0x15cd('0x1a')](dbH[_0x15cd('0x13')][_0x15cd('0x1b')](util[_0x15cd('0xc')](_0x15cd('0x1c'),QUERY,_0x8b1167,_0x503cca),{'type':dbH[_0x15cd('0x13')][_0x15cd('0x14')][_0x15cd('0x15')]}));}}}else{_0x3d89a2[_0x15cd('0x1a')](dbH[_0x15cd('0x13')][_0x15cd('0x1b')](QUERY,{'type':dbH[_0x15cd('0x13')][_0x15cd('0x14')][_0x15cd('0x15')]}));}var _0x3caf5e=path[_0x15cd('0x1d')](PATH);var _0x311df2=path[_0x15cd('0x1e')](PATH,'.xlsx');var _0x1c99f1=_0x3b959a[_0x15cd('0x10')]&&_0x3d89a2[_0x15cd('0x18')]>0x1;var _0x3964bd=[];if(!fs[_0x15cd('0x1f')](path[_0x15cd('0x20')](_0x3caf5e,_0x311df2))&&_0x1c99f1){fs['mkdirSync'](path[_0x15cd('0x20')](_0x3caf5e,_0x311df2));}return BPromise[_0x15cd('0x21')](_0x3d89a2,function(_0x194a70){_0x3964bd['push'](_0x194a70);})[_0x15cd('0x12')](function(){for(var _0x7657db=0x0;_0x7657db<_0x3964bd['length'];_0x7657db+=0x1){var _0x59a4e5;var _0x4cd3c8=_0x3964bd[_0x7657db];if(_0x1c99f1){_0x59a4e5=path[_0x15cd('0x20')](_0x3caf5e,_0x311df2,util[_0x15cd('0xc')](_0x15cd('0x22'),_0x311df2,_0x7657db,_0x15cd('0x23')));}else{_0x59a4e5=path[_0x15cd('0x20')](_0x3caf5e,util['format'](_0x15cd('0x24'),_0x311df2,'xlsx'));}fs[_0x15cd('0x25')](_0x59a4e5,json2xls(_0x4cd3c8),_0x15cd('0x26'));}})['then'](function(){if(_0x1c99f1){return new Promise(function(_0x39f22e){zipdir(path['join'](_0x3caf5e,_0x311df2),{'saveTo':path[_0x15cd('0x20')](_0x3caf5e,util[_0x15cd('0xc')](_0x15cd('0x24'),_0x311df2,_0x15cd('0x27')))},function(_0x55883f,_0x7bf444){rimraf(path['join'](_0x3caf5e,_0x311df2),function(){});_0x39f22e('zip\x20finished');});});}})[_0x15cd('0x12')](function(){logger[_0x15cd('0xb')](util['format'](_0x15cd('0x28'),EXTRACTED_REPORT_ID,_0x15cd('0xe')));return analyticExtractedReport(_0x15cd('0x29'),_0x1c99f1?util[_0x15cd('0xc')](_0x15cd('0x24'),_0x311df2,_0x1c99f1?_0x15cd('0x27'):_0x15cd('0x23')):null);});})[_0x15cd('0x2a')](function(_0x3dec36){logger['info'](util['format'](_0x15cd('0x2b'),EXTRACTED_REPORT_ID,_0x15cd('0xe')),util[_0x15cd('0x2c')](_0x3dec36,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x15cd('0x2d'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion2.git / blobdiff