// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x195d=['savename','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','split','then','splitSizeXlsx','sequelize','num','length','query','QueryTypes','SELECT','.xlsx','existsSync','join','mkdirSync','each','xlsx','%s.%s','writeFileSync','binary','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','util','path','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv'];(function(_0x3d9cac,_0x566177){var _0x22fcd4=function(_0x3954cb){while(--_0x3954cb){_0x3d9cac['push'](_0x3d9cac['shift']());}};_0x22fcd4(++_0x566177);}(_0x195d,0x78));var _0xd195=function(_0x25fa5c,_0x421141){_0x25fa5c=_0x25fa5c-0x0;var _0x1bade2=_0x195d[_0x25fa5c];return _0x1bade2;};'use strict';var util=require(_0xd195('0x0'));var path=require(_0xd195('0x1'));var _=require(_0xd195('0x2'));var fs=require('fs');var json2xls=require(_0xd195('0x3'));var BPromise=require(_0xd195('0x4'));var zipdir=require(_0xd195('0x5'));var rimraf=require(_0xd195('0x6'));var db=require(_0xd195('0x7'))['db'];var dbH=require('../../mysqldb')[_0xd195('0x8')];var logger=require(_0xd195('0x9'))(_0xd195('0xa'));var EXTRACTED_REPORT_ID=Number(process[_0xd195('0xb')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0xd195('0xb')][0x4];function analyticExtractedReport(_0x115ff8,_0x2f448d){var _0x498c50={'status':_0x115ff8};var _0x252d05={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2f448d){_0x498c50[_0xd195('0xc')]=_0x2f448d;}return db[_0xd195('0xd')]['update'](_0x498c50,_0x252d05);}function main(){var _0x24f3e3=0x1388;var _0x3964a7;logger[_0xd195('0xe')](util[_0xd195('0xf')](_0xd195('0x10'),EXTRACTED_REPORT_ID,_0xd195('0x11')));return db[_0xd195('0x12')][_0xd195('0x13')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xd195('0x14'),'splitSizeXlsx']})[_0xd195('0x15')](function(_0x56c278){if(_0x56c278){_0x3964a7=_0x56c278;_0x24f3e3=_0x3964a7[_0xd195('0x16')]||0x1388;}})[_0xd195('0x15')](function(){return dbH['sequelize']['query'](util[_0xd195('0xf')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0xd195('0x17')]['QueryTypes']['SELECT']});})['then'](function(_0x5eeb37){if(!_0x5eeb37[0x0][_0xd195('0x18')]){return analyticExtractedReport('Empty');}var _0x46a46c=[];var _0x2c76e3=0x0;var _0x48004b=!![];if(_0x3964a7['split']){if(_0x5eeb37&&_0x5eeb37[_0xd195('0x19')]){var _0x13f59e=_0x5eeb37[0x0]['num']%(_0x2c76e3+_0x24f3e3);for(;_0x48004b;_0x2c76e3+=_0x24f3e3,_0x13f59e=_0x5eeb37[0x0]['num']%(_0x2c76e3+_0x24f3e3)){if(_0x13f59e==0x0||_0x13f59e==_0x5eeb37[0x0][_0xd195('0x18')]){_0x48004b=![];}_0x46a46c['push'](dbH[_0xd195('0x17')][_0xd195('0x1a')](util[_0xd195('0xf')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x24f3e3,_0x2c76e3),{'type':dbH[_0xd195('0x17')][_0xd195('0x1b')][_0xd195('0x1c')]}));}}}else{_0x46a46c['push'](dbH[_0xd195('0x17')]['query'](QUERY,{'type':dbH['sequelize'][_0xd195('0x1b')][_0xd195('0x1c')]}));}var _0x22943d=path['dirname'](PATH);var _0xeeecba=path['basename'](PATH,_0xd195('0x1d'));var _0x598c32=_0x3964a7[_0xd195('0x14')]&&_0x46a46c['length']>0x1;var _0x9ac327=[];if(!fs[_0xd195('0x1e')](path[_0xd195('0x1f')](_0x22943d,_0xeeecba))&&_0x598c32){fs[_0xd195('0x20')](path['join'](_0x22943d,_0xeeecba));}return BPromise[_0xd195('0x21')](_0x46a46c,function(_0x18cc09){_0x9ac327['push'](_0x18cc09);})[_0xd195('0x15')](function(){for(var _0x2ce3e2=0x0;_0x2ce3e2<_0x9ac327[_0xd195('0x19')];_0x2ce3e2+=0x1){var _0x419f7c;var _0x21fe33=_0x9ac327[_0x2ce3e2];if(_0x598c32){_0x419f7c=path[_0xd195('0x1f')](_0x22943d,_0xeeecba,util[_0xd195('0xf')]('%s%d.%s',_0xeeecba,_0x2ce3e2,_0xd195('0x22')));}else{_0x419f7c=path[_0xd195('0x1f')](_0x22943d,util['format'](_0xd195('0x23'),_0xeeecba,_0xd195('0x22')));}fs[_0xd195('0x24')](_0x419f7c,json2xls(_0x21fe33),_0xd195('0x25'));}})['then'](function(){if(_0x598c32){zipdir(path[_0xd195('0x1f')](_0x22943d,_0xeeecba),{'saveTo':path['join'](_0x22943d,util[_0xd195('0xf')](_0xd195('0x23'),_0xeeecba,'zip'))},function(_0x19f5a3,_0x2dc0cc){});rimraf(path[_0xd195('0x1f')](_0x22943d,_0xeeecba),function(){});}})[_0xd195('0x15')](function(){logger[_0xd195('0xe')](util[_0xd195('0xf')](_0xd195('0x26'),EXTRACTED_REPORT_ID,_0xd195('0x11')));return analyticExtractedReport(_0xd195('0x27'),_0x598c32?util['format'](_0xd195('0x23'),_0xeeecba,_0x598c32?'zip':_0xd195('0x22')):null);});})[_0xd195('0x28')](function(_0x51a9ed){logger[_0xd195('0xe')](util[_0xd195('0xf')](_0xd195('0x29'),EXTRACTED_REPORT_ID,_0xd195('0x11')),util[_0xd195('0x2a')](_0x51a9ed,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0xd195('0x2b'));});}main();
\ No newline at end of file
+var _0xe2a1=['mkdirSync','join','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','util','lodash','bluebird','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','splitSizeXlsx','then','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','SELECT','num','Empty','split','length','push','%s\x20limit\x20%d\x20OFFSET\x20%d','sequelize','QueryTypes','dirname','basename','.xlsx','existsSync'];(function(_0x251c55,_0x315c4f){var _0x2f8000=function(_0x5747cc){while(--_0x5747cc){_0x251c55['push'](_0x251c55['shift']());}};_0x2f8000(++_0x315c4f);}(_0xe2a1,0x127));var _0x1e2a=function(_0x39a203,_0x456d3e){_0x39a203=_0x39a203-0x0;var _0x31e162=_0xe2a1[_0x39a203];return _0x31e162;};'use strict';var util=require(_0x1e2a('0x0'));var path=require('path');var _=require(_0x1e2a('0x1'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0x1e2a('0x2'));var zipdir=require('zip-dir');var rimraf=require(_0x1e2a('0x3'));var db=require(_0x1e2a('0x4'))['db'];var dbH=require(_0x1e2a('0x4'))[_0x1e2a('0x5')];var logger=require(_0x1e2a('0x6'))(_0x1e2a('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0x1e2a('0x8')][0x2]);var QUERY=process[_0x1e2a('0x8')][0x3];var PATH=process[_0x1e2a('0x8')][0x4];function analyticExtractedReport(_0x268fd3,_0x2e91a7){var _0x5ac0f7={'status':_0x268fd3};var _0x590da1={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2e91a7){_0x5ac0f7[_0x1e2a('0x9')]=_0x2e91a7;}return db['AnalyticExtractedReport'][_0x1e2a('0xa')](_0x5ac0f7,_0x590da1);}function main(){var _0x4eb74c=0x1388;var _0x120bb0;logger[_0x1e2a('0xb')](util['format'](_0x1e2a('0xc'),EXTRACTED_REPORT_ID,_0x1e2a('0xd')));return db[_0x1e2a('0xe')][_0x1e2a('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x1e2a('0x10')]})[_0x1e2a('0x11')](function(_0x261718){if(_0x261718){_0x120bb0=_0x261718;_0x4eb74c=_0x120bb0[_0x1e2a('0x10')]||0x1388;}})['then'](function(){return dbH['sequelize'][_0x1e2a('0x12')](util[_0x1e2a('0x13')](_0x1e2a('0x14'),QUERY),{'type':dbH['sequelize']['QueryTypes'][_0x1e2a('0x15')]});})[_0x1e2a('0x11')](function(_0x21bf8b){if(!_0x21bf8b[0x0][_0x1e2a('0x16')]){return analyticExtractedReport(_0x1e2a('0x17'));}var _0x473f65=[];var _0xdb666a=0x0;var _0x31d24f=!![];if(_0x120bb0[_0x1e2a('0x18')]){if(_0x21bf8b&&_0x21bf8b[_0x1e2a('0x19')]){var _0x279300=_0x21bf8b[0x0][_0x1e2a('0x16')]%(_0xdb666a+_0x4eb74c);for(;_0x31d24f;_0xdb666a+=_0x4eb74c,_0x279300=_0x21bf8b[0x0][_0x1e2a('0x16')]%(_0xdb666a+_0x4eb74c)){if(_0x279300==0x0||_0x279300==_0x21bf8b[0x0]['num']){_0x31d24f=![];}_0x473f65[_0x1e2a('0x1a')](dbH['sequelize'][_0x1e2a('0x12')](util['format'](_0x1e2a('0x1b'),QUERY,_0x4eb74c,_0xdb666a),{'type':dbH[_0x1e2a('0x1c')][_0x1e2a('0x1d')]['SELECT']}));}}}else{_0x473f65['push'](dbH['sequelize'][_0x1e2a('0x12')](QUERY,{'type':dbH[_0x1e2a('0x1c')][_0x1e2a('0x1d')][_0x1e2a('0x15')]}));}var _0x469479=path[_0x1e2a('0x1e')](PATH);var _0x566d93=path[_0x1e2a('0x1f')](PATH,_0x1e2a('0x20'));var _0x8ae721=_0x120bb0[_0x1e2a('0x18')]&&_0x473f65[_0x1e2a('0x19')]>0x1;var _0x3daf8c=[];if(!fs[_0x1e2a('0x21')](path['join'](_0x469479,_0x566d93))&&_0x8ae721){fs[_0x1e2a('0x22')](path[_0x1e2a('0x23')](_0x469479,_0x566d93));}return BPromise[_0x1e2a('0x24')](_0x473f65,function(_0x4d8cbf){_0x3daf8c[_0x1e2a('0x1a')](_0x4d8cbf);})[_0x1e2a('0x11')](function(){for(var _0xe677c9=0x0;_0xe677c9<_0x3daf8c[_0x1e2a('0x19')];_0xe677c9+=0x1){var _0x510bb3;var _0x10c4d5=_0x3daf8c[_0xe677c9];if(_0x8ae721){_0x510bb3=path[_0x1e2a('0x23')](_0x469479,_0x566d93,util['format'](_0x1e2a('0x25'),_0x566d93,_0xe677c9,_0x1e2a('0x26')));}else{_0x510bb3=path[_0x1e2a('0x23')](_0x469479,util[_0x1e2a('0x13')](_0x1e2a('0x27'),_0x566d93,_0x1e2a('0x26')));}fs[_0x1e2a('0x28')](_0x510bb3,json2xls(_0x10c4d5),_0x1e2a('0x29'));}})[_0x1e2a('0x11')](function(){if(_0x8ae721){zipdir(path[_0x1e2a('0x23')](_0x469479,_0x566d93),{'saveTo':path[_0x1e2a('0x23')](_0x469479,util[_0x1e2a('0x13')](_0x1e2a('0x27'),_0x566d93,_0x1e2a('0x2a')))},function(_0x3d8312,_0x41ee7f){});rimraf(path[_0x1e2a('0x23')](_0x469479,_0x566d93),function(){});}})['then'](function(){logger[_0x1e2a('0xb')](util['format'](_0x1e2a('0x2b'),EXTRACTED_REPORT_ID,_0x1e2a('0xd')));return analyticExtractedReport(_0x1e2a('0x2c'),_0x8ae721?util[_0x1e2a('0x13')](_0x1e2a('0x27'),_0x566d93,_0x8ae721?_0x1e2a('0x2a'):'xlsx'):null);});})[_0x1e2a('0x2d')](function(_0x262bd5){logger[_0x1e2a('0xb')](util[_0x1e2a('0x13')](_0x1e2a('0x2e'),EXTRACTED_REPORT_ID,'XLSX'),util['inspect'](_0x262bd5,{'showHidden':![],'depth':null}));return analyticExtractedReport('Failed');});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff