// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x41f6=['info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','split','splitSizeXlsx','then','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','SELECT','num','length','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','.xlsx','existsSync','mkdirSync','join','each','%s%d.%s','xlsx','writeFileSync','binary','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','%s.%s','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','finally','exit','util','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update'];(function(_0x3711ef,_0x59f137){var _0x287bcb=function(_0x5e8d68){while(--_0x5e8d68){_0x3711ef['push'](_0x3711ef['shift']());}};_0x287bcb(++_0x59f137);}(_0x41f6,0x8e));var _0x641f=function(_0xbb14db,_0x3ee8c6){_0xbb14db=_0xbb14db-0x0;var _0x36bed7=_0x41f6[_0xbb14db];return _0x36bed7;};'use strict';var util=require(_0x641f('0x0'));var path=require('path');var _=require(_0x641f('0x1'));var fs=require('fs');var json2xls=require(_0x641f('0x2'));var BPromise=require(_0x641f('0x3'));var zipdir=require(_0x641f('0x4'));var rimraf=require(_0x641f('0x5'));var db=require(_0x641f('0x6'))['db'];var dbH=require(_0x641f('0x6'))[_0x641f('0x7')];var logger=require(_0x641f('0x8'))(_0x641f('0x9'));var EXTRACTED_REPORT_ID=Number(process[_0x641f('0xa')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x641f('0xa')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x48c950,_0x5448f0){var _0x3425ca={'status':_0x48c950};var _0x116a33={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5448f0){_0x3425ca[_0x641f('0xb')]=_0x5448f0;}return db[_0x641f('0xc')][_0x641f('0xd')](_0x3425ca,_0x116a33);}function main(){var _0xba086a=0x1388;var _0x58a75b;logger[_0x641f('0xe')](util[_0x641f('0xf')](_0x641f('0x10'),EXTRACTED_REPORT_ID,_0x641f('0x11')));return db[_0x641f('0x12')][_0x641f('0x13')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x641f('0x14'),'splitSizeXlsx']})['then'](function(_0x589ac5){if(_0x589ac5){_0x58a75b=_0x589ac5;_0xba086a=_0x58a75b[_0x641f('0x15')]||0x1388;}})[_0x641f('0x16')](function(){return dbH['sequelize'][_0x641f('0x17')](util[_0x641f('0xf')](_0x641f('0x18'),QUERY),{'type':dbH[_0x641f('0x19')][_0x641f('0x1a')][_0x641f('0x1b')]});})[_0x641f('0x16')](function(_0x5b0660){if(!_0x5b0660[0x0][_0x641f('0x1c')]){return analyticExtractedReport('Empty');}var _0x5a1b7f=[];var _0x4fa8d7=0x0;if(_0x58a75b[_0x641f('0x14')]){if(_0x5b0660&&_0x5b0660[_0x641f('0x1d')]){var _0x2c1312=_['range'](_0x5b0660[0x0]['num']/_0xba086a);var _0x33bd72=Number[_0x641f('0x1e')](_0x5b0660[0x0]['num']/_0xba086a)?_0x5b0660[0x0][_0x641f('0x1c')]%_0xba086a:0x0;_0x2c1312[_0x641f('0x1f')](function(_0x58f8df){if(_0x58f8df>0x0){_0x4fa8d7+=_0xba086a;}_0x5a1b7f[_0x641f('0x20')](dbH[_0x641f('0x19')][_0x641f('0x17')](util['format'](_0x641f('0x21'),QUERY,_0xba086a,_0x4fa8d7),{'type':dbH[_0x641f('0x19')][_0x641f('0x1a')][_0x641f('0x1b')]}));});if(_0x33bd72>0x0){_0x4fa8d7+=_0xba086a;_0x5a1b7f[_0x641f('0x20')](dbH[_0x641f('0x19')]['query'](util[_0x641f('0xf')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x33bd72,_0x4fa8d7),{'type':dbH['sequelize'][_0x641f('0x1a')]['SELECT']}));}}}else{_0x5a1b7f[_0x641f('0x20')](dbH[_0x641f('0x19')][_0x641f('0x17')](QUERY,{'type':dbH[_0x641f('0x19')][_0x641f('0x1a')][_0x641f('0x1b')]}));}var _0x4a3d2a=path['dirname'](PATH);var _0x2b2452=path['basename'](PATH,_0x641f('0x22'));var _0x85a549=_0x58a75b[_0x641f('0x14')]&&_0x5a1b7f[_0x641f('0x1d')]>0x1;var _0x2e69bd=[];if(!fs[_0x641f('0x23')](path['join'](_0x4a3d2a,_0x2b2452))&&_0x85a549){fs[_0x641f('0x24')](path[_0x641f('0x25')](_0x4a3d2a,_0x2b2452));}return BPromise[_0x641f('0x26')](_0x5a1b7f,function(_0x5d7774){_0x2e69bd[_0x641f('0x20')](_0x5d7774);})['then'](function(){for(var _0x346bda=0x0;_0x346bda<_0x2e69bd['length'];_0x346bda+=0x1){var _0x2ec67b;var _0x4a4b9f=_0x2e69bd[_0x346bda];if(_0x85a549){_0x2ec67b=path[_0x641f('0x25')](_0x4a3d2a,_0x2b2452,util[_0x641f('0xf')](_0x641f('0x27'),_0x2b2452,_0x346bda,_0x641f('0x28')));}else{_0x2ec67b=path['join'](_0x4a3d2a,util[_0x641f('0xf')]('%s.%s',_0x2b2452,_0x641f('0x28')));}fs[_0x641f('0x29')](_0x2ec67b,json2xls(_0x4a4b9f),_0x641f('0x2a'));}})[_0x641f('0x16')](function(){if(_0x85a549){return new Promise(function(_0x2967a4){zipdir(path['join'](_0x4a3d2a,_0x2b2452),{'saveTo':path[_0x641f('0x25')](_0x4a3d2a,util['format']('%s.%s',_0x2b2452,_0x641f('0x2b')))},function(_0x2a2070,_0x41088b){rimraf(path[_0x641f('0x25')](_0x4a3d2a,_0x2b2452),function(){});_0x2967a4('zip\x20finished');});});}})[_0x641f('0x16')](function(){logger['info'](util['format'](_0x641f('0x2c'),EXTRACTED_REPORT_ID,_0x641f('0x11')));return analyticExtractedReport(_0x641f('0x2d'),_0x85a549?util[_0x641f('0xf')](_0x641f('0x2e'),_0x2b2452,_0x85a549?_0x641f('0x2b'):_0x641f('0x28')):null);});})[_0x641f('0x2f')](function(_0x160ad8){logger[_0x641f('0xe')](util[_0x641f('0xf')](_0x641f('0x30'),EXTRACTED_REPORT_ID,_0x641f('0x11')),util[_0x641f('0x31')](_0x160ad8,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0x641f('0x32')](function(){process[_0x641f('0x33')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xacf7=['SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','range','num','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','dirname','basename','length','existsSync','join','mkdirSync','%s%d.%s','xlsx','%s.%s','writeFileSync','zip','zip\x20finished','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','finally','exit','util','path','lodash','json2xls','bluebird','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','split','splitSizeXlsx','then','query'];(function(_0x175e29,_0x149222){var _0x21f8ec=function(_0x2503a1){while(--_0x2503a1){_0x175e29['push'](_0x175e29['shift']());}};_0x21f8ec(++_0x149222);}(_0xacf7,0x1bd));var _0x7acf=function(_0x4b369d,_0x265eb8){_0x4b369d=_0x4b369d-0x0;var _0x571a98=_0xacf7[_0x4b369d];return _0x571a98;};'use strict';var util=require(_0x7acf('0x0'));var path=require(_0x7acf('0x1'));var _=require(_0x7acf('0x2'));var fs=require('fs');var json2xls=require(_0x7acf('0x3'));var BPromise=require(_0x7acf('0x4'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0x7acf('0x5'))['db'];var dbH=require(_0x7acf('0x5'))[_0x7acf('0x6')];var logger=require(_0x7acf('0x7'))(_0x7acf('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0x7acf('0x9')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x7acf('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x156128,_0x124cb4){var _0x489b23={'status':_0x156128};var _0x219e8c={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x124cb4){_0x489b23[_0x7acf('0xa')]=_0x124cb4;}return db[_0x7acf('0xb')][_0x7acf('0xc')](_0x489b23,_0x219e8c);}function main(){var _0x35e2e8=0x1388;var _0x3e1ab9;logger[_0x7acf('0xd')](util[_0x7acf('0xe')](_0x7acf('0xf'),EXTRACTED_REPORT_ID,_0x7acf('0x10')));return db[_0x7acf('0x11')][_0x7acf('0x12')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x7acf('0x13'),_0x7acf('0x14')]})[_0x7acf('0x15')](function(_0x2e4fae){if(_0x2e4fae){_0x3e1ab9=_0x2e4fae;_0x35e2e8=_0x3e1ab9['splitSizeXlsx']||0x1388;}})[_0x7acf('0x15')](function(){return dbH['sequelize'][_0x7acf('0x16')](util['format'](_0x7acf('0x17'),QUERY),{'type':dbH[_0x7acf('0x18')][_0x7acf('0x19')]['SELECT']});})[_0x7acf('0x15')](function(_0x1ab1a3){if(!_0x1ab1a3[0x0]['num']){return analyticExtractedReport('Empty');}var _0x41c1ef=[];var _0x482c9f=0x0;if(_0x3e1ab9['split']){if(_0x1ab1a3&&_0x1ab1a3['length']){var _0x337d2c=_[_0x7acf('0x1a')](_0x1ab1a3[0x0][_0x7acf('0x1b')]/_0x35e2e8);var _0xbd4cb8=Number[_0x7acf('0x1c')](_0x1ab1a3[0x0][_0x7acf('0x1b')]/_0x35e2e8)?_0x1ab1a3[0x0][_0x7acf('0x1b')]%_0x35e2e8:0x0;_0x337d2c[_0x7acf('0x1d')](function(_0x588279){if(_0x588279>0x0){_0x482c9f+=_0x35e2e8;}_0x41c1ef[_0x7acf('0x1e')](dbH['sequelize']['query'](util['format'](_0x7acf('0x1f'),QUERY,_0x35e2e8,_0x482c9f),{'type':dbH[_0x7acf('0x18')][_0x7acf('0x19')][_0x7acf('0x20')]}));});if(_0xbd4cb8>0x0){_0x482c9f+=_0x35e2e8;_0x41c1ef['push'](dbH[_0x7acf('0x18')][_0x7acf('0x16')](util['format'](_0x7acf('0x1f'),QUERY,_0xbd4cb8,_0x482c9f),{'type':dbH[_0x7acf('0x18')][_0x7acf('0x19')][_0x7acf('0x20')]}));}}}else{_0x41c1ef['push'](dbH[_0x7acf('0x18')]['query'](QUERY,{'type':dbH[_0x7acf('0x18')]['QueryTypes'][_0x7acf('0x20')]}));}var _0x4fc93f=path[_0x7acf('0x21')](PATH);var _0xf8fe81=path[_0x7acf('0x22')](PATH,'.xlsx');var _0x3e1fd1=_0x3e1ab9[_0x7acf('0x13')]&&_0x41c1ef[_0x7acf('0x23')]>0x1;var _0x23ab5a=[];if(!fs[_0x7acf('0x24')](path[_0x7acf('0x25')](_0x4fc93f,_0xf8fe81))&&_0x3e1fd1){fs[_0x7acf('0x26')](path[_0x7acf('0x25')](_0x4fc93f,_0xf8fe81));}return BPromise['each'](_0x41c1ef,function(_0xdeb7f8){_0x23ab5a[_0x7acf('0x1e')](_0xdeb7f8);})[_0x7acf('0x15')](function(){for(var _0x272867=0x0;_0x272867<_0x23ab5a[_0x7acf('0x23')];_0x272867+=0x1){var _0x48a9f7;var _0x16c0c9=_0x23ab5a[_0x272867];if(_0x3e1fd1){_0x48a9f7=path[_0x7acf('0x25')](_0x4fc93f,_0xf8fe81,util[_0x7acf('0xe')](_0x7acf('0x27'),_0xf8fe81,_0x272867,_0x7acf('0x28')));}else{_0x48a9f7=path[_0x7acf('0x25')](_0x4fc93f,util[_0x7acf('0xe')](_0x7acf('0x29'),_0xf8fe81,_0x7acf('0x28')));}fs[_0x7acf('0x2a')](_0x48a9f7,json2xls(_0x16c0c9),'binary');}})[_0x7acf('0x15')](function(){if(_0x3e1fd1){return new Promise(function(_0x4abb2b){zipdir(path[_0x7acf('0x25')](_0x4fc93f,_0xf8fe81),{'saveTo':path[_0x7acf('0x25')](_0x4fc93f,util[_0x7acf('0xe')]('%s.%s',_0xf8fe81,_0x7acf('0x2b')))},function(_0x1370b5,_0xc72e07){rimraf(path[_0x7acf('0x25')](_0x4fc93f,_0xf8fe81),function(){});_0x4abb2b(_0x7acf('0x2c'));});});}})[_0x7acf('0x15')](function(){logger[_0x7acf('0xd')](util[_0x7acf('0xe')](_0x7acf('0x2d'),EXTRACTED_REPORT_ID,_0x7acf('0x10')));return analyticExtractedReport(_0x7acf('0x2e'),_0x3e1fd1?util[_0x7acf('0xe')](_0x7acf('0x29'),_0xf8fe81,_0x3e1fd1?'zip':_0x7acf('0x28')):null);});})['catch'](function(_0x5250f0){logger[_0x7acf('0xd')](util['format'](_0x7acf('0x2f'),EXTRACTED_REPORT_ID,_0x7acf('0x10')),util[_0x7acf('0x30')](_0x5250f0,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x7acf('0x31'));})[_0x7acf('0x32')](function(){process[_0x7acf('0x33')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff