// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1833=['../../config/logger','analytics','argv','savename','AnalyticExtractedReport','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','split','splitSizeXlsx','then','sequelize','query','QueryTypes','SELECT','num','Empty','range','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','existsSync','join','%s%d.%s','%s.%s','xlsx','writeFileSync','binary','zip','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','catch','info','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Failed','finally','exit','util','path','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','dbH'];(function(_0x49a3b7,_0x5d2586){var _0x569e43=function(_0x4ddf94){while(--_0x4ddf94){_0x49a3b7['push'](_0x49a3b7['shift']());}};_0x569e43(++_0x5d2586);}(_0x1833,0x93));var _0x3183=function(_0x4587fe,_0x4b740c){_0x4587fe=_0x4587fe-0x0;var _0x379355=_0x1833[_0x4587fe];return _0x379355;};'use strict';var util=require(_0x3183('0x0'));var path=require(_0x3183('0x1'));var _=require(_0x3183('0x2'));var fs=require('fs');var json2xls=require(_0x3183('0x3'));var BPromise=require(_0x3183('0x4'));var zipdir=require(_0x3183('0x5'));var rimraf=require(_0x3183('0x6'));var db=require(_0x3183('0x7'))['db'];var dbH=require('../../mysqldb')[_0x3183('0x8')];var logger=require(_0x3183('0x9'))(_0x3183('0xa'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x3183('0xb')][0x3];var PATH=process[_0x3183('0xb')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0xf7fc91,_0x3bd649){var _0x18829d={'status':_0xf7fc91};var _0xcb6ace={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x3bd649){_0x18829d[_0x3183('0xc')]=_0x3bd649;}return db[_0x3183('0xd')]['update'](_0x18829d,_0xcb6ace);}function main(){var _0x5e3077=0x1388;var _0x15e8bf;logger['info'](util[_0x3183('0xe')](_0x3183('0xf'),EXTRACTED_REPORT_ID,_0x3183('0x10')));return db[_0x3183('0x11')][_0x3183('0x12')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x3183('0x13'),_0x3183('0x14')]})[_0x3183('0x15')](function(_0xb906d3){if(_0xb906d3){_0x15e8bf=_0xb906d3;_0x5e3077=_0x15e8bf[_0x3183('0x14')]||0x1388;}})[_0x3183('0x15')](function(){return dbH[_0x3183('0x16')][_0x3183('0x17')](util[_0x3183('0xe')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x3183('0x16')][_0x3183('0x18')][_0x3183('0x19')]});})[_0x3183('0x15')](function(_0x382051){if(!_0x382051[0x0][_0x3183('0x1a')]){return analyticExtractedReport(_0x3183('0x1b'));}var _0x3ea34e=[];var _0x5d10d2=0x0;if(_0x15e8bf['split']){if(_0x382051&&_0x382051['length']){var _0xa071fa=_[_0x3183('0x1c')](_0x382051[0x0][_0x3183('0x1a')]/_0x5e3077);var _0x547c70=Number[_0x3183('0x1d')](_0x382051[0x0][_0x3183('0x1a')]/_0x5e3077)?_0x382051[0x0][_0x3183('0x1a')]%_0x5e3077:0x0;_0xa071fa[_0x3183('0x1e')](function(_0x2491c3){if(_0x2491c3>0x0){_0x5d10d2+=_0x5e3077;}_0x3ea34e[_0x3183('0x1f')](dbH[_0x3183('0x16')][_0x3183('0x17')](util[_0x3183('0xe')](_0x3183('0x20'),QUERY,_0x5e3077,_0x5d10d2),{'type':dbH[_0x3183('0x16')][_0x3183('0x18')][_0x3183('0x19')]}));});if(_0x547c70>0x0){_0x5d10d2+=_0x5e3077;_0x3ea34e[_0x3183('0x1f')](dbH[_0x3183('0x16')][_0x3183('0x17')](util[_0x3183('0xe')](_0x3183('0x20'),QUERY,_0x547c70,_0x5d10d2),{'type':dbH[_0x3183('0x16')][_0x3183('0x18')]['SELECT']}));}}}else{_0x3ea34e[_0x3183('0x1f')](dbH[_0x3183('0x16')]['query'](QUERY,{'type':dbH[_0x3183('0x16')][_0x3183('0x18')][_0x3183('0x19')]}));}var _0x252dda=path[_0x3183('0x21')](PATH);var _0x10c7a9=path[_0x3183('0x22')](PATH,_0x3183('0x23'));var _0x22beff=_0x15e8bf['split']&&_0x3ea34e['length']>0x1;var _0x9826a6=[];if(!fs[_0x3183('0x24')](path[_0x3183('0x25')](_0x252dda,_0x10c7a9))&&_0x22beff){fs['mkdirSync'](path[_0x3183('0x25')](_0x252dda,_0x10c7a9));}return BPromise['each'](_0x3ea34e,function(_0x5509c2){_0x9826a6[_0x3183('0x1f')](_0x5509c2);})['then'](function(){for(var _0x256b59=0x0;_0x256b59<_0x9826a6['length'];_0x256b59+=0x1){var _0x239a3a;var _0x1edf98=_0x9826a6[_0x256b59];if(_0x22beff){_0x239a3a=path[_0x3183('0x25')](_0x252dda,_0x10c7a9,util['format'](_0x3183('0x26'),_0x10c7a9,_0x256b59,'xlsx'));}else{_0x239a3a=path['join'](_0x252dda,util[_0x3183('0xe')](_0x3183('0x27'),_0x10c7a9,_0x3183('0x28')));}fs[_0x3183('0x29')](_0x239a3a,json2xls(_0x1edf98),_0x3183('0x2a'));}})[_0x3183('0x15')](function(){if(_0x22beff){return new Promise(function(_0x2b6e6e){zipdir(path[_0x3183('0x25')](_0x252dda,_0x10c7a9),{'saveTo':path[_0x3183('0x25')](_0x252dda,util['format'](_0x3183('0x27'),_0x10c7a9,_0x3183('0x2b')))},function(_0x5f00e8,_0x1a1149){rimraf(path[_0x3183('0x25')](_0x252dda,_0x10c7a9),function(){});_0x2b6e6e(_0x3183('0x2c'));});});}})['then'](function(){logger['info'](util[_0x3183('0xe')](_0x3183('0x2d'),EXTRACTED_REPORT_ID,_0x3183('0x10')));return analyticExtractedReport('Completed',_0x22beff?util[_0x3183('0xe')](_0x3183('0x27'),_0x10c7a9,_0x22beff?_0x3183('0x2b'):'xlsx'):null);});})[_0x3183('0x2e')](function(_0x1afe1c){logger[_0x3183('0x2f')](util['format'](_0x3183('0x30'),EXTRACTED_REPORT_ID,_0x3183('0x10')),util['inspect'](_0x1afe1c,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x3183('0x31'));})[_0x3183('0x32')](function(){process[_0x3183('0x33')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xaa1b=['bluebird','rimraf','../../mysqldb','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','split','splitSizeXlsx','then','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','SELECT','num','Empty','length','range','isInteger','push','query','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','existsSync','join','mkdirSync','each','%s%d.%s','%s.%s','binary','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','xlsx','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','finally','util','path','lodash'];(function(_0xc838b8,_0x2f4309){var _0x18c0be=function(_0x2d81cd){while(--_0x2d81cd){_0xc838b8['push'](_0xc838b8['shift']());}};_0x18c0be(++_0x2f4309);}(_0xaa1b,0x123));var _0xbaa1=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0xaa1b[_0x20a584];return _0x4b41a8;};'use strict';var util=require(_0xbaa1('0x0'));var path=require(_0xbaa1('0x1'));var _=require(_0xbaa1('0x2'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0xbaa1('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0xbaa1('0x4'));var db=require(_0xbaa1('0x5'))['db'];var dbH=require('../../mysqldb')['dbH'];var logger=require('../../config/logger')(_0xbaa1('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0xbaa1('0x7')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0xbaa1('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x56e7ec,_0x364ce9){var _0x15b968={'status':_0x56e7ec};var _0x339e3e={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x364ce9){_0x15b968[_0xbaa1('0x8')]=_0x364ce9;}return db[_0xbaa1('0x9')][_0xbaa1('0xa')](_0x15b968,_0x339e3e);}function main(){var _0x4f8933=0x1388;var _0x39b669;logger[_0xbaa1('0xb')](util[_0xbaa1('0xc')](_0xbaa1('0xd'),EXTRACTED_REPORT_ID,_0xbaa1('0xe')));return db[_0xbaa1('0xf')][_0xbaa1('0x10')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0xbaa1('0x11'),_0xbaa1('0x12')]})[_0xbaa1('0x13')](function(_0x8ce72d){if(_0x8ce72d){_0x39b669=_0x8ce72d;_0x4f8933=_0x39b669[_0xbaa1('0x12')]||0x1388;}})['then'](function(){return dbH['sequelize']['query'](util['format'](_0xbaa1('0x14'),QUERY),{'type':dbH[_0xbaa1('0x15')][_0xbaa1('0x16')][_0xbaa1('0x17')]});})[_0xbaa1('0x13')](function(_0x2e7db5){if(!_0x2e7db5[0x0][_0xbaa1('0x18')]){return analyticExtractedReport(_0xbaa1('0x19'));}var _0x35a3fd=[];var _0x2a0c0b=0x0;if(_0x39b669[_0xbaa1('0x11')]){if(_0x2e7db5&&_0x2e7db5[_0xbaa1('0x1a')]){var _0x449dfc=_[_0xbaa1('0x1b')](_0x2e7db5[0x0][_0xbaa1('0x18')]/_0x4f8933);var _0x155a16=Number[_0xbaa1('0x1c')](_0x2e7db5[0x0][_0xbaa1('0x18')]/_0x4f8933)?_0x2e7db5[0x0][_0xbaa1('0x18')]%_0x4f8933:0x0;_0x449dfc['forEach'](function(_0x10bfd3){if(_0x10bfd3>0x0){_0x2a0c0b+=_0x4f8933;}_0x35a3fd[_0xbaa1('0x1d')](dbH[_0xbaa1('0x15')][_0xbaa1('0x1e')](util[_0xbaa1('0xc')](_0xbaa1('0x1f'),QUERY,_0x4f8933,_0x2a0c0b),{'type':dbH['sequelize'][_0xbaa1('0x16')][_0xbaa1('0x17')]}));});if(_0x155a16>0x0){_0x2a0c0b+=_0x4f8933;_0x35a3fd[_0xbaa1('0x1d')](dbH[_0xbaa1('0x15')][_0xbaa1('0x1e')](util['format']('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x155a16,_0x2a0c0b),{'type':dbH[_0xbaa1('0x15')][_0xbaa1('0x16')][_0xbaa1('0x17')]}));}}}else{_0x35a3fd[_0xbaa1('0x1d')](dbH[_0xbaa1('0x15')][_0xbaa1('0x1e')](QUERY,{'type':dbH['sequelize'][_0xbaa1('0x16')][_0xbaa1('0x17')]}));}var _0x28e508=path[_0xbaa1('0x20')](PATH);var _0x1204f4=path[_0xbaa1('0x21')](PATH,_0xbaa1('0x22'));var _0x2d208e=_0x39b669[_0xbaa1('0x11')]&&_0x35a3fd['length']>0x1;var _0x2b80a4=[];if(!fs[_0xbaa1('0x23')](path[_0xbaa1('0x24')](_0x28e508,_0x1204f4))&&_0x2d208e){fs[_0xbaa1('0x25')](path[_0xbaa1('0x24')](_0x28e508,_0x1204f4));}return BPromise[_0xbaa1('0x26')](_0x35a3fd,function(_0x594578){_0x2b80a4['push'](_0x594578);})[_0xbaa1('0x13')](function(){for(var _0x1e1869=0x0;_0x1e1869<_0x2b80a4[_0xbaa1('0x1a')];_0x1e1869+=0x1){var _0x48cbc0;var _0xf3ff18=_0x2b80a4[_0x1e1869];if(_0x2d208e){_0x48cbc0=path[_0xbaa1('0x24')](_0x28e508,_0x1204f4,util['format'](_0xbaa1('0x27'),_0x1204f4,_0x1e1869,'xlsx'));}else{_0x48cbc0=path[_0xbaa1('0x24')](_0x28e508,util[_0xbaa1('0xc')](_0xbaa1('0x28'),_0x1204f4,'xlsx'));}fs['writeFileSync'](_0x48cbc0,json2xls(_0xf3ff18),_0xbaa1('0x29'));}})[_0xbaa1('0x13')](function(){if(_0x2d208e){return new Promise(function(_0x279b72){zipdir(path[_0xbaa1('0x24')](_0x28e508,_0x1204f4),{'saveTo':path[_0xbaa1('0x24')](_0x28e508,util[_0xbaa1('0xc')]('%s.%s',_0x1204f4,_0xbaa1('0x2a')))},function(_0xe4036e,_0x2cfabc){rimraf(path[_0xbaa1('0x24')](_0x28e508,_0x1204f4),function(){});_0x279b72('zip\x20finished');});});}})[_0xbaa1('0x13')](function(){logger['info'](util[_0xbaa1('0xc')](_0xbaa1('0x2b'),EXTRACTED_REPORT_ID,_0xbaa1('0xe')));return analyticExtractedReport(_0xbaa1('0x2c'),_0x2d208e?util['format'](_0xbaa1('0x28'),_0x1204f4,_0x2d208e?_0xbaa1('0x2a'):_0xbaa1('0x2d')):null);});})['catch'](function(_0x38eeb4){logger[_0xbaa1('0xb')](util['format'](_0xbaa1('0x2e'),EXTRACTED_REPORT_ID,_0xbaa1('0xe')),util[_0xbaa1('0x2f')](_0x38eeb4,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0xbaa1('0x30')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff