// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x877c=['splitSizeXlsx','then','sequelize','query','format','QueryTypes','SELECT','num','Empty','length','push','dirname','basename','.xlsx','join','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','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','util','path','lodash','bluebird','zip-dir','../../mysqldb','../../config/logger','analytics','argv','savename','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','split'];(function(_0x1c8a71,_0x3fb3b4){var _0x3048fb=function(_0x568de3){while(--_0x568de3){_0x1c8a71['push'](_0x1c8a71['shift']());}};_0x3048fb(++_0x3fb3b4);}(_0x877c,0xc3));var _0xc877=function(_0x28f27b,_0x1ebf24){_0x28f27b=_0x28f27b-0x0;var _0x49f5d9=_0x877c[_0x28f27b];return _0x49f5d9;};'use strict';var util=require(_0xc877('0x0'));var path=require(_0xc877('0x1'));var _=require(_0xc877('0x2'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0xc877('0x3'));var zipdir=require(_0xc877('0x4'));var rimraf=require('rimraf');var db=require(_0xc877('0x5'))['db'];var dbH=require('../../mysqldb')['dbH'];var logger=require(_0xc877('0x6'))(_0xc877('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0xc877('0x8')][0x3];var PATH=process[_0xc877('0x8')][0x4];function analyticExtractedReport(_0x335001,_0xc2bff0){var _0x55252d={'status':_0x335001};var _0x363d0f={'where':{'id':EXTRACTED_REPORT_ID}};if(_0xc2bff0){_0x55252d[_0xc877('0x9')]=_0xc2bff0;}return db['AnalyticExtractedReport']['update'](_0x55252d,_0x363d0f);}function main(){var _0x2e1aab=0x1388;var _0x2569ae;logger[_0xc877('0xa')](util['format'](_0xc877('0xb'),EXTRACTED_REPORT_ID,_0xc877('0xc')));return db[_0xc877('0xd')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xc877('0xe'),_0xc877('0xf')]})[_0xc877('0x10')](function(_0x5e5495){if(_0x5e5495){_0x2569ae=_0x5e5495;_0x2e1aab=_0x2569ae[_0xc877('0xf')]||0x1388;}})[_0xc877('0x10')](function(){return dbH[_0xc877('0x11')][_0xc877('0x12')](util[_0xc877('0x13')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0xc877('0x11')][_0xc877('0x14')][_0xc877('0x15')]});})['then'](function(_0x121d2e){if(!_0x121d2e[0x0][_0xc877('0x16')]){return analyticExtractedReport(_0xc877('0x17'));}var _0x4b2f11=[];var _0x2e1853=0x0;var _0x1fd46f=!![];if(_0x2569ae[_0xc877('0xe')]){if(_0x121d2e&&_0x121d2e[_0xc877('0x18')]){var _0x4be14f=_0x121d2e[0x0]['num']%(_0x2e1853+_0x2e1aab);for(;_0x1fd46f;_0x2e1853+=_0x2e1aab,_0x4be14f=_0x121d2e[0x0]['num']%(_0x2e1853+_0x2e1aab)){if(_0x4be14f==0x0||_0x4be14f==_0x121d2e[0x0][_0xc877('0x16')]){_0x1fd46f=![];}_0x4b2f11[_0xc877('0x19')](dbH[_0xc877('0x11')]['query'](util[_0xc877('0x13')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x2e1aab,_0x2e1853),{'type':dbH[_0xc877('0x11')]['QueryTypes'][_0xc877('0x15')]}));}}}else{_0x4b2f11[_0xc877('0x19')](dbH[_0xc877('0x11')][_0xc877('0x12')](QUERY,{'type':dbH[_0xc877('0x11')][_0xc877('0x14')]['SELECT']}));}var _0x7b80b=path[_0xc877('0x1a')](PATH);var _0x56cd15=path[_0xc877('0x1b')](PATH,_0xc877('0x1c'));var _0x312667=_0x2569ae[_0xc877('0xe')]&&_0x4b2f11[_0xc877('0x18')]>0x1;var _0xcb6aa6=[];if(!fs['existsSync'](path['join'](_0x7b80b,_0x56cd15))&&_0x312667){fs['mkdirSync'](path[_0xc877('0x1d')](_0x7b80b,_0x56cd15));}return BPromise[_0xc877('0x1e')](_0x4b2f11,function(_0x55f084){_0xcb6aa6[_0xc877('0x19')](_0x55f084);})[_0xc877('0x10')](function(){for(var _0x94620b=0x0;_0x94620b<_0xcb6aa6[_0xc877('0x18')];_0x94620b+=0x1){var _0x1f5eea;var _0xc5e3e8=_0xcb6aa6[_0x94620b];if(_0x312667){_0x1f5eea=path[_0xc877('0x1d')](_0x7b80b,_0x56cd15,util[_0xc877('0x13')](_0xc877('0x1f'),_0x56cd15,_0x94620b,_0xc877('0x20')));}else{_0x1f5eea=path[_0xc877('0x1d')](_0x7b80b,util[_0xc877('0x13')](_0xc877('0x21'),_0x56cd15,_0xc877('0x20')));}fs[_0xc877('0x22')](_0x1f5eea,json2xls(_0xc5e3e8),_0xc877('0x23'));}})[_0xc877('0x10')](function(){if(_0x312667){zipdir(path[_0xc877('0x1d')](_0x7b80b,_0x56cd15),{'saveTo':path[_0xc877('0x1d')](_0x7b80b,util[_0xc877('0x13')](_0xc877('0x21'),_0x56cd15,_0xc877('0x24')))},function(_0x25e424,_0x50b16a){});rimraf(path[_0xc877('0x1d')](_0x7b80b,_0x56cd15),function(){});}})[_0xc877('0x10')](function(){logger[_0xc877('0xa')](util[_0xc877('0x13')](_0xc877('0x25'),EXTRACTED_REPORT_ID,'XLSX'));return analyticExtractedReport(_0xc877('0x26'),_0x312667?util[_0xc877('0x13')]('%s.%s',_0x56cd15,_0x312667?_0xc877('0x24'):_0xc877('0x20')):null);});})['catch'](function(_0x29a037){logger['info'](util['format'](_0xc877('0x27'),EXTRACTED_REPORT_ID,_0xc877('0xc')),util[_0xc877('0x28')](_0x29a037,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0xc877('0x29'));});}main();
\ No newline at end of file
+var _0xfea6=['query','QueryTypes','SELECT','num','length','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','existsSync','join','mkdirSync','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','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','util','lodash','bluebird','zip-dir','rimraf','../../mysqldb','dbH','argv','savename','info','format','XLSX','Setting','split','then','splitSizeXlsx','sequelize'];(function(_0x4ab8af,_0x1b426c){var _0x70272c=function(_0x105d0b){while(--_0x105d0b){_0x4ab8af['push'](_0x4ab8af['shift']());}};_0x70272c(++_0x1b426c);}(_0xfea6,0xb7));var _0x6fea=function(_0x490ac1,_0x1596c0){_0x490ac1=_0x490ac1-0x0;var _0x32066f=_0xfea6[_0x490ac1];return _0x32066f;};'use strict';var util=require(_0x6fea('0x0'));var path=require('path');var _=require(_0x6fea('0x1'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0x6fea('0x2'));var zipdir=require(_0x6fea('0x3'));var rimraf=require(_0x6fea('0x4'));var db=require('../../mysqldb')['db'];var dbH=require(_0x6fea('0x5'))[_0x6fea('0x6')];var logger=require('../../config/logger')('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x6fea('0x7')][0x3];var PATH=process[_0x6fea('0x7')][0x4];function analyticExtractedReport(_0x487d59,_0x19e5fd){var _0x14dfa6={'status':_0x487d59};var _0x48db0e={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x19e5fd){_0x14dfa6[_0x6fea('0x8')]=_0x19e5fd;}return db['AnalyticExtractedReport']['update'](_0x14dfa6,_0x48db0e);}function main(){var _0x48d739=0x1388;var _0x53f6ee;logger[_0x6fea('0x9')](util[_0x6fea('0xa')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x6fea('0xb')));return db[_0x6fea('0xc')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x6fea('0xd'),'splitSizeXlsx']})[_0x6fea('0xe')](function(_0x5d0314){if(_0x5d0314){_0x53f6ee=_0x5d0314;_0x48d739=_0x53f6ee[_0x6fea('0xf')]||0x1388;}})[_0x6fea('0xe')](function(){return dbH[_0x6fea('0x10')][_0x6fea('0x11')](util[_0x6fea('0xa')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x6fea('0x10')][_0x6fea('0x12')][_0x6fea('0x13')]});})[_0x6fea('0xe')](function(_0x4c6b74){if(!_0x4c6b74[0x0][_0x6fea('0x14')]){return analyticExtractedReport('Empty');}var _0x4d1e48=[];var _0x4f625a=0x0;var _0x4d6bae=!![];if(_0x53f6ee[_0x6fea('0xd')]){if(_0x4c6b74&&_0x4c6b74[_0x6fea('0x15')]){var _0x19405e=_0x4c6b74[0x0][_0x6fea('0x14')]%(_0x4f625a+_0x48d739);for(;_0x4d6bae;_0x4f625a+=_0x48d739,_0x19405e=_0x4c6b74[0x0][_0x6fea('0x14')]%(_0x4f625a+_0x48d739)){if(_0x19405e==0x0||_0x19405e==_0x4c6b74[0x0]['num']){_0x4d6bae=![];}_0x4d1e48['push'](dbH[_0x6fea('0x10')][_0x6fea('0x11')](util['format'](_0x6fea('0x16'),QUERY,_0x48d739,_0x4f625a),{'type':dbH[_0x6fea('0x10')][_0x6fea('0x12')][_0x6fea('0x13')]}));}}}else{_0x4d1e48['push'](dbH[_0x6fea('0x10')][_0x6fea('0x11')](QUERY,{'type':dbH[_0x6fea('0x10')][_0x6fea('0x12')][_0x6fea('0x13')]}));}var _0x363321=path[_0x6fea('0x17')](PATH);var _0x17379d=path[_0x6fea('0x18')](PATH,'.xlsx');var _0x458873=_0x53f6ee[_0x6fea('0xd')]&&_0x4d1e48[_0x6fea('0x15')]>0x1;var _0x51e6a3=[];if(!fs[_0x6fea('0x19')](path[_0x6fea('0x1a')](_0x363321,_0x17379d))&&_0x458873){fs[_0x6fea('0x1b')](path[_0x6fea('0x1a')](_0x363321,_0x17379d));}return BPromise[_0x6fea('0x1c')](_0x4d1e48,function(_0x34befc){_0x51e6a3['push'](_0x34befc);})['then'](function(){for(var _0x20b247=0x0;_0x20b247<_0x51e6a3[_0x6fea('0x15')];_0x20b247+=0x1){var _0x1e5277;var _0x487cbe=_0x51e6a3[_0x20b247];if(_0x458873){_0x1e5277=path[_0x6fea('0x1a')](_0x363321,_0x17379d,util['format'](_0x6fea('0x1d'),_0x17379d,_0x20b247,_0x6fea('0x1e')));}else{_0x1e5277=path[_0x6fea('0x1a')](_0x363321,util['format'](_0x6fea('0x1f'),_0x17379d,_0x6fea('0x1e')));}fs[_0x6fea('0x20')](_0x1e5277,json2xls(_0x487cbe),_0x6fea('0x21'));}})[_0x6fea('0xe')](function(){if(_0x458873){zipdir(path[_0x6fea('0x1a')](_0x363321,_0x17379d),{'saveTo':path['join'](_0x363321,util[_0x6fea('0xa')]('%s.%s',_0x17379d,_0x6fea('0x22')))},function(_0x3ab883,_0x563209){});rimraf(path[_0x6fea('0x1a')](_0x363321,_0x17379d),function(){});}})[_0x6fea('0xe')](function(){logger[_0x6fea('0x9')](util['format'](_0x6fea('0x23'),EXTRACTED_REPORT_ID,_0x6fea('0xb')));return analyticExtractedReport(_0x6fea('0x24'),_0x458873?util['format'](_0x6fea('0x1f'),_0x17379d,_0x458873?_0x6fea('0x22'):_0x6fea('0x1e')):null);});})['catch'](function(_0x26a8f8){logger[_0x6fea('0x9')](util['format'](_0x6fea('0x25'),EXTRACTED_REPORT_ID,_0x6fea('0xb')),util[_0x6fea('0x26')](_0x26a8f8,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x6fea('0x27'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff