// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x20d6=['mkdirSync','each','%s%d.%s','xlsx','%s.%s','writeFileSync','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','XLSX','Completed','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','util','path','json2xls','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','argv','savename','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','splitSizeXlsx','then','QueryTypes','num','Empty','length','push','sequelize','query','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','dirname','basename','.xlsx','existsSync','join'];(function(_0x29fd4f,_0x279bfd){var _0x14573a=function(_0x1134d3){while(--_0x1134d3){_0x29fd4f['push'](_0x29fd4f['shift']());}};_0x14573a(++_0x279bfd);}(_0x20d6,0x140));var _0x620d=function(_0x501510,_0x61caa9){_0x501510=_0x501510-0x0;var _0x1e6ee5=_0x20d6[_0x501510];return _0x1e6ee5;};'use strict';var util=require(_0x620d('0x0'));var path=require(_0x620d('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0x620d('0x2'));var BPromise=require('bluebird');var zipdir=require(_0x620d('0x3'));var rimraf=require(_0x620d('0x4'));var db=require(_0x620d('0x5'))['db'];var dbH=require(_0x620d('0x5'))[_0x620d('0x6')];var logger=require(_0x620d('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x620d('0x8')][0x2]);var QUERY=process[_0x620d('0x8')][0x3];var PATH=process[_0x620d('0x8')][0x4];function analyticExtractedReport(_0xf7ef0b,_0x1a74d7){var _0x1bc901={'status':_0xf7ef0b};var _0xde67e6={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x1a74d7){_0x1bc901[_0x620d('0x9')]=_0x1a74d7;}return db['AnalyticExtractedReport']['update'](_0x1bc901,_0xde67e6);}function main(){var _0xde1573=0x1388;var _0x49c3b8;logger[_0x620d('0xa')](util[_0x620d('0xb')](_0x620d('0xc'),EXTRACTED_REPORT_ID,'XLSX'));return db[_0x620d('0xd')][_0x620d('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x620d('0xf'),_0x620d('0x10')]})[_0x620d('0x11')](function(_0x52def9){if(_0x52def9){_0x49c3b8=_0x52def9;_0xde1573=_0x49c3b8[_0x620d('0x10')]||0x1388;}})[_0x620d('0x11')](function(){return dbH['sequelize']['query'](util[_0x620d('0xb')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH['sequelize'][_0x620d('0x12')]['SELECT']});})[_0x620d('0x11')](function(_0x1b9e2c){if(!_0x1b9e2c[0x0][_0x620d('0x13')]){return analyticExtractedReport(_0x620d('0x14'));}var _0x29bc84=[];var _0x3faa18=0x0;var _0x271b2f=!![];if(_0x49c3b8['split']){if(_0x1b9e2c&&_0x1b9e2c[_0x620d('0x15')]){var _0x3516a2=_0x1b9e2c[0x0][_0x620d('0x13')]%(_0x3faa18+_0xde1573);for(;_0x271b2f;_0x3faa18+=_0xde1573,_0x3516a2=_0x1b9e2c[0x0][_0x620d('0x13')]%(_0x3faa18+_0xde1573)){if(_0x3516a2==0x0||_0x3516a2==_0x1b9e2c[0x0][_0x620d('0x13')]){_0x271b2f=![];}_0x29bc84[_0x620d('0x16')](dbH[_0x620d('0x17')][_0x620d('0x18')](util[_0x620d('0xb')](_0x620d('0x19'),QUERY,_0xde1573,_0x3faa18),{'type':dbH[_0x620d('0x17')][_0x620d('0x12')]['SELECT']}));}}}else{_0x29bc84[_0x620d('0x16')](dbH[_0x620d('0x17')][_0x620d('0x18')](QUERY,{'type':dbH[_0x620d('0x17')][_0x620d('0x12')][_0x620d('0x1a')]}));}var _0x4a31dc=path[_0x620d('0x1b')](PATH);var _0x10ee7=path[_0x620d('0x1c')](PATH,_0x620d('0x1d'));var _0x3ce9c0=_0x49c3b8[_0x620d('0xf')]&&_0x29bc84[_0x620d('0x15')]>0x1;var _0x3a8779=[];if(!fs[_0x620d('0x1e')](path[_0x620d('0x1f')](_0x4a31dc,_0x10ee7))&&_0x3ce9c0){fs[_0x620d('0x20')](path[_0x620d('0x1f')](_0x4a31dc,_0x10ee7));}return BPromise[_0x620d('0x21')](_0x29bc84,function(_0xc889a4){_0x3a8779[_0x620d('0x16')](_0xc889a4);})['then'](function(){for(var _0x5c3832=0x0;_0x5c3832<_0x3a8779[_0x620d('0x15')];_0x5c3832+=0x1){var _0x36ca66;var _0x1800d5=_0x3a8779[_0x5c3832];if(_0x3ce9c0){_0x36ca66=path[_0x620d('0x1f')](_0x4a31dc,_0x10ee7,util[_0x620d('0xb')](_0x620d('0x22'),_0x10ee7,_0x5c3832,_0x620d('0x23')));}else{_0x36ca66=path[_0x620d('0x1f')](_0x4a31dc,util[_0x620d('0xb')](_0x620d('0x24'),_0x10ee7,_0x620d('0x23')));}fs[_0x620d('0x25')](_0x36ca66,json2xls(_0x1800d5),'binary');}})[_0x620d('0x11')](function(){if(_0x3ce9c0){zipdir(path[_0x620d('0x1f')](_0x4a31dc,_0x10ee7),{'saveTo':path[_0x620d('0x1f')](_0x4a31dc,util[_0x620d('0xb')](_0x620d('0x24'),_0x10ee7,_0x620d('0x26')))},function(_0x3240a4,_0x14b0ee){});rimraf(path['join'](_0x4a31dc,_0x10ee7),function(){});}})[_0x620d('0x11')](function(){logger['info'](util['format'](_0x620d('0x27'),EXTRACTED_REPORT_ID,_0x620d('0x28')));return analyticExtractedReport(_0x620d('0x29'),_0x3ce9c0?util[_0x620d('0xb')](_0x620d('0x24'),_0x10ee7,_0x3ce9c0?_0x620d('0x26'):_0x620d('0x23')):null);});})['catch'](function(_0x586ded){logger[_0x620d('0xa')](util[_0x620d('0xb')](_0x620d('0x2a'),EXTRACTED_REPORT_ID,_0x620d('0x28')),util['inspect'](_0x586ded,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x620d('0x2b'));});}main();
\ No newline at end of file
+var _0xc2b4=['format','XLSX','Setting','find','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','split','length','push','SELECT','dirname','.xlsx','existsSync','join','mkdirSync','xlsx','writeFileSync','%s.%s','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','catch','Failed','util','path','lodash','json2xls','rimraf','../../mysqldb','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info'];(function(_0x2ab3d9,_0x50e716){var _0x210a54=function(_0x24c479){while(--_0x24c479){_0x2ab3d9['push'](_0x2ab3d9['shift']());}};_0x210a54(++_0x50e716);}(_0xc2b4,0xc5));var _0x4c2b=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xc2b4[_0x3dd15e];return _0x231fd0;};'use strict';var util=require(_0x4c2b('0x0'));var path=require(_0x4c2b('0x1'));var _=require(_0x4c2b('0x2'));var fs=require('fs');var json2xls=require(_0x4c2b('0x3'));var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require(_0x4c2b('0x4'));var db=require(_0x4c2b('0x5'))['db'];var dbH=require(_0x4c2b('0x5'))['dbH'];var logger=require(_0x4c2b('0x6'))(_0x4c2b('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x4c2b('0x8')][0x3];var PATH=process[_0x4c2b('0x8')][0x4];function analyticExtractedReport(_0x12c96e,_0xa5c76b){var _0x427f07={'status':_0x12c96e};var _0x9a40c8={'where':{'id':EXTRACTED_REPORT_ID}};if(_0xa5c76b){_0x427f07[_0x4c2b('0x9')]=_0xa5c76b;}return db[_0x4c2b('0xa')][_0x4c2b('0xb')](_0x427f07,_0x9a40c8);}function main(){var _0x557445=0x1388;var _0x28ecd8;logger[_0x4c2b('0xc')](util[_0x4c2b('0xd')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x4c2b('0xe')));return db[_0x4c2b('0xf')][_0x4c2b('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split','splitSizeXlsx']})['then'](function(_0x11cc06){if(_0x11cc06){_0x28ecd8=_0x11cc06;_0x557445=_0x28ecd8[_0x4c2b('0x11')]||0x1388;}})[_0x4c2b('0x12')](function(){return dbH[_0x4c2b('0x13')][_0x4c2b('0x14')](util[_0x4c2b('0xd')](_0x4c2b('0x15'),QUERY),{'type':dbH[_0x4c2b('0x13')][_0x4c2b('0x16')]['SELECT']});})['then'](function(_0x52a7bc){if(!_0x52a7bc[0x0][_0x4c2b('0x17')]){return analyticExtractedReport(_0x4c2b('0x18'));}var _0xbfa649=[];var _0x12c72d=0x0;var _0x153958=!![];if(_0x28ecd8[_0x4c2b('0x19')]){if(_0x52a7bc&&_0x52a7bc[_0x4c2b('0x1a')]){var _0x3dd7d3=_0x52a7bc[0x0][_0x4c2b('0x17')]%(_0x12c72d+_0x557445);for(;_0x153958;_0x12c72d+=_0x557445,_0x3dd7d3=_0x52a7bc[0x0]['num']%(_0x12c72d+_0x557445)){if(_0x3dd7d3==0x0||_0x3dd7d3==_0x52a7bc[0x0][_0x4c2b('0x17')]){_0x153958=![];}_0xbfa649[_0x4c2b('0x1b')](dbH[_0x4c2b('0x13')]['query'](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x557445,_0x12c72d),{'type':dbH[_0x4c2b('0x13')][_0x4c2b('0x16')][_0x4c2b('0x1c')]}));}}}else{_0xbfa649[_0x4c2b('0x1b')](dbH[_0x4c2b('0x13')][_0x4c2b('0x14')](QUERY,{'type':dbH[_0x4c2b('0x13')]['QueryTypes']['SELECT']}));}var _0x2c72ec=path[_0x4c2b('0x1d')](PATH);var _0x305d84=path['basename'](PATH,_0x4c2b('0x1e'));var _0x21016a=_0x28ecd8['split']&&_0xbfa649[_0x4c2b('0x1a')]>0x1;var _0x3eb4fb=[];if(!fs[_0x4c2b('0x1f')](path[_0x4c2b('0x20')](_0x2c72ec,_0x305d84))&&_0x21016a){fs[_0x4c2b('0x21')](path[_0x4c2b('0x20')](_0x2c72ec,_0x305d84));}return BPromise['each'](_0xbfa649,function(_0x393428){_0x3eb4fb['push'](_0x393428);})[_0x4c2b('0x12')](function(){for(var _0x791e55=0x0;_0x791e55<_0x3eb4fb[_0x4c2b('0x1a')];_0x791e55+=0x1){var _0x2d3646;var _0x38773e=_0x3eb4fb[_0x791e55];if(_0x21016a){_0x2d3646=path[_0x4c2b('0x20')](_0x2c72ec,_0x305d84,util[_0x4c2b('0xd')]('%s%d.%s',_0x305d84,_0x791e55,_0x4c2b('0x22')));}else{_0x2d3646=path[_0x4c2b('0x20')](_0x2c72ec,util['format']('%s.%s',_0x305d84,_0x4c2b('0x22')));}fs[_0x4c2b('0x23')](_0x2d3646,json2xls(_0x38773e),'binary');}})[_0x4c2b('0x12')](function(){if(_0x21016a){zipdir(path['join'](_0x2c72ec,_0x305d84),{'saveTo':path[_0x4c2b('0x20')](_0x2c72ec,util['format'](_0x4c2b('0x24'),_0x305d84,_0x4c2b('0x25')))},function(_0x37b7b4,_0x46bc2d){});rimraf(path['join'](_0x2c72ec,_0x305d84),function(){});}})[_0x4c2b('0x12')](function(){logger[_0x4c2b('0xc')](util[_0x4c2b('0xd')](_0x4c2b('0x26'),EXTRACTED_REPORT_ID,_0x4c2b('0xe')));return analyticExtractedReport(_0x4c2b('0x27'),_0x21016a?util[_0x4c2b('0xd')]('%s.%s',_0x305d84,_0x21016a?_0x4c2b('0x25'):_0x4c2b('0x22')):null);});})[_0x4c2b('0x28')](function(_0x35c20a){logger['info'](util[_0x4c2b('0xd')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'XLSX'),util['inspect'](_0x35c20a,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x4c2b('0x29'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff