// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x57ff=['join','%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','inspect','Failed','util','path','json2xls','bluebird','zip-dir','../../mysqldb','dbH','analytics','argv','savename','AnalyticExtractedReport','info','format','XLSX','find','splitSizeXlsx','query','sequelize','QueryTypes','SELECT','then','Empty','length','isInteger','num','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','split','existsSync','mkdirSync'];(function(_0x4a4fa3,_0x370daf){var _0x4393a=function(_0x547a1b){while(--_0x547a1b){_0x4a4fa3['push'](_0x4a4fa3['shift']());}};_0x4393a(++_0x370daf);}(_0x57ff,0x127));var _0xf57f=function(_0x4119a1,_0x57b111){_0x4119a1=_0x4119a1-0x0;var _0xd80389=_0x57ff[_0x4119a1];return _0xd80389;};'use strict';var util=require(_0xf57f('0x0'));var path=require(_0xf57f('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0xf57f('0x2'));var BPromise=require(_0xf57f('0x3'));var zipdir=require(_0xf57f('0x4'));var rimraf=require('rimraf');var db=require(_0xf57f('0x5'))['db'];var dbH=require('../../mysqldb')[_0xf57f('0x6')];var logger=require('../../config/logger')(_0xf57f('0x7'));var EXTRACTED_REPORT_ID=Number(process[_0xf57f('0x8')][0x2]);var QUERY=process[_0xf57f('0x8')][0x3];var PATH=process['argv'][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0xa72510,_0x4e3354){var _0x31afea={'status':_0xa72510};var _0x54bf95={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4e3354){_0x31afea[_0xf57f('0x9')]=_0x4e3354;}return db[_0xf57f('0xa')]['update'](_0x31afea,_0x54bf95);}function main(){var _0x53ed49=0x1388;var _0x2a412a;logger[_0xf57f('0xb')](util[_0xf57f('0xc')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xf57f('0xd')));return db['Setting'][_0xf57f('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xf57f('0xf')]})['then'](function(_0x3ae94f){if(_0x3ae94f){_0x2a412a=_0x3ae94f;_0x53ed49=_0x2a412a[_0xf57f('0xf')]||0x1388;}})['then'](function(){return dbH['sequelize'][_0xf57f('0x10')](util[_0xf57f('0xc')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0xf57f('0x11')][_0xf57f('0x12')][_0xf57f('0x13')]});})[_0xf57f('0x14')](function(_0x379e40){if(!_0x379e40[0x0]['num']){return analyticExtractedReport(_0xf57f('0x15'));}var _0x4d1b34=[];var _0xec9b22=0x0;if(_0x2a412a['split']){if(_0x379e40&&_0x379e40[_0xf57f('0x16')]){var _0x4618a5=_['range'](_0x379e40[0x0]['num']/_0x53ed49);var _0x5bb03a=Number[_0xf57f('0x17')](_0x379e40[0x0][_0xf57f('0x18')]/_0x53ed49)?_0x379e40[0x0]['num']%_0x53ed49:0x0;_0x4618a5[_0xf57f('0x19')](function(_0x39320b){if(_0x39320b>0x0){_0xec9b22+=_0x53ed49;}_0x4d1b34[_0xf57f('0x1a')](dbH[_0xf57f('0x11')][_0xf57f('0x10')](util['format'](_0xf57f('0x1b'),QUERY,_0x53ed49,_0xec9b22),{'type':dbH[_0xf57f('0x11')][_0xf57f('0x12')][_0xf57f('0x13')]}));});if(_0x5bb03a>0x0){_0xec9b22+=_0x53ed49;_0x4d1b34['push'](dbH[_0xf57f('0x11')]['query'](util['format'](_0xf57f('0x1b'),QUERY,_0x5bb03a,_0xec9b22),{'type':dbH[_0xf57f('0x11')][_0xf57f('0x12')][_0xf57f('0x13')]}));}}}else{_0x4d1b34[_0xf57f('0x1a')](dbH[_0xf57f('0x11')]['query'](QUERY,{'type':dbH[_0xf57f('0x11')][_0xf57f('0x12')]['SELECT']}));}var _0x346fe4=path[_0xf57f('0x1c')](PATH);var _0x4cec31=path[_0xf57f('0x1d')](PATH,_0xf57f('0x1e'));var _0x176c47=_0x2a412a[_0xf57f('0x1f')]&&_0x4d1b34[_0xf57f('0x16')]>0x1;var _0x3b687f=[];if(!fs[_0xf57f('0x20')](path['join'](_0x346fe4,_0x4cec31))&&_0x176c47){fs[_0xf57f('0x21')](path[_0xf57f('0x22')](_0x346fe4,_0x4cec31));}return BPromise['each'](_0x4d1b34,function(_0x40cd05){_0x3b687f[_0xf57f('0x1a')](_0x40cd05);})['then'](function(){for(var _0x38e4a0=0x0;_0x38e4a0<_0x3b687f[_0xf57f('0x16')];_0x38e4a0+=0x1){var _0x5d59c3;var _0x4964e6=_0x3b687f[_0x38e4a0];if(_0x176c47){_0x5d59c3=path[_0xf57f('0x22')](_0x346fe4,_0x4cec31,util[_0xf57f('0xc')](_0xf57f('0x23'),_0x4cec31,_0x38e4a0,_0xf57f('0x24')));}else{_0x5d59c3=path[_0xf57f('0x22')](_0x346fe4,util[_0xf57f('0xc')](_0xf57f('0x25'),_0x4cec31,'xlsx'));}fs[_0xf57f('0x26')](_0x5d59c3,json2xls(_0x4964e6),_0xf57f('0x27'));}})[_0xf57f('0x14')](function(){if(_0x176c47){return new Promise(function(_0xa11a57){zipdir(path[_0xf57f('0x22')](_0x346fe4,_0x4cec31),{'saveTo':path[_0xf57f('0x22')](_0x346fe4,util['format'](_0xf57f('0x25'),_0x4cec31,_0xf57f('0x28')))},function(_0x3717eb,_0x18d75a){rimraf(path[_0xf57f('0x22')](_0x346fe4,_0x4cec31),function(){});_0xa11a57('zip\x20finished');});});}})[_0xf57f('0x14')](function(){logger['info'](util[_0xf57f('0xc')](_0xf57f('0x29'),EXTRACTED_REPORT_ID,'XLSX'));return analyticExtractedReport(_0xf57f('0x2a'),_0x176c47?util[_0xf57f('0xc')](_0xf57f('0x25'),_0x4cec31,_0x176c47?_0xf57f('0x28'):_0xf57f('0x24')):null);});})[_0xf57f('0x2b')](function(_0x3b9e9d){logger[_0xf57f('0xb')](util[_0xf57f('0xc')](_0xf57f('0x2c'),EXTRACTED_REPORT_ID,'XLSX'),util[_0xf57f('0x2d')](_0x3b9e9d,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xf57f('0x2e'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xb2ed=['analytics','argv','savename','AnalyticExtractedReport','update','info','format','XLSX','Setting','find','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','split','length','isInteger','forEach','%s\x20limit\x20%d\x20OFFSET\x20%d','push','dirname','basename','.xlsx','existsSync','join','mkdirSync','each','%s%d.%s','%s.%s','writeFileSync','binary','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','Completed','zip','xlsx','Failed','finally','exit','path','json2xls','bluebird','../../mysqldb','dbH','../../config/logger'];(function(_0x779c84,_0x395143){var _0x408e6b=function(_0x22230d){while(--_0x22230d){_0x779c84['push'](_0x779c84['shift']());}};_0x408e6b(++_0x395143);}(_0xb2ed,0x120));var _0xdb2e=function(_0x3cfb0d,_0x4df584){_0x3cfb0d=_0x3cfb0d-0x0;var _0x3486b4=_0xb2ed[_0x3cfb0d];return _0x3486b4;};'use strict';var util=require('util');var path=require(_0xdb2e('0x0'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0xdb2e('0x1'));var BPromise=require(_0xdb2e('0x2'));var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0xdb2e('0x3'))['db'];var dbH=require(_0xdb2e('0x3'))[_0xdb2e('0x4')];var logger=require(_0xdb2e('0x5'))(_0xdb2e('0x6'));var EXTRACTED_REPORT_ID=Number(process[_0xdb2e('0x7')][0x2]);var QUERY=process[_0xdb2e('0x7')][0x3];var PATH=process[_0xdb2e('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x1a9ad4,_0x5a4e5d){var _0x225d9a={'status':_0x1a9ad4};var _0x31ff3e={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5a4e5d){_0x225d9a[_0xdb2e('0x8')]=_0x5a4e5d;}return db[_0xdb2e('0x9')][_0xdb2e('0xa')](_0x225d9a,_0x31ff3e);}function main(){var _0x138a83=0x1388;var _0x12c76c;logger[_0xdb2e('0xb')](util[_0xdb2e('0xc')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xdb2e('0xd')));return db[_0xdb2e('0xe')][_0xdb2e('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xdb2e('0x10')]})['then'](function(_0x2b3784){if(_0x2b3784){_0x12c76c=_0x2b3784;_0x138a83=_0x12c76c[_0xdb2e('0x10')]||0x1388;}})[_0xdb2e('0x11')](function(){return dbH[_0xdb2e('0x12')][_0xdb2e('0x13')](util[_0xdb2e('0xc')](_0xdb2e('0x14'),QUERY),{'type':dbH[_0xdb2e('0x12')][_0xdb2e('0x15')][_0xdb2e('0x16')]});})['then'](function(_0x39fd4a){if(!_0x39fd4a[0x0][_0xdb2e('0x17')]){return analyticExtractedReport('Empty');}var _0x16e416=[];var _0x5a4f4d=0x0;if(_0x12c76c[_0xdb2e('0x18')]){if(_0x39fd4a&&_0x39fd4a[_0xdb2e('0x19')]){var _0x5903cb=_['range'](_0x39fd4a[0x0][_0xdb2e('0x17')]/_0x138a83);var _0x1eaa89=Number[_0xdb2e('0x1a')](_0x39fd4a[0x0]['num']/_0x138a83)?_0x39fd4a[0x0][_0xdb2e('0x17')]%_0x138a83:0x0;_0x5903cb[_0xdb2e('0x1b')](function(_0x54884d){if(_0x54884d>0x0){_0x5a4f4d+=_0x138a83;}_0x16e416['push'](dbH['sequelize'][_0xdb2e('0x13')](util[_0xdb2e('0xc')](_0xdb2e('0x1c'),QUERY,_0x138a83,_0x5a4f4d),{'type':dbH[_0xdb2e('0x12')][_0xdb2e('0x15')][_0xdb2e('0x16')]}));});if(_0x1eaa89>0x0){_0x5a4f4d+=_0x138a83;_0x16e416[_0xdb2e('0x1d')](dbH[_0xdb2e('0x12')][_0xdb2e('0x13')](util[_0xdb2e('0xc')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x1eaa89,_0x5a4f4d),{'type':dbH['sequelize']['QueryTypes']['SELECT']}));}}}else{_0x16e416['push'](dbH[_0xdb2e('0x12')][_0xdb2e('0x13')](QUERY,{'type':dbH[_0xdb2e('0x12')][_0xdb2e('0x15')][_0xdb2e('0x16')]}));}var _0x2c85e7=path[_0xdb2e('0x1e')](PATH);var _0x5ba45c=path[_0xdb2e('0x1f')](PATH,_0xdb2e('0x20'));var _0x366212=_0x12c76c[_0xdb2e('0x18')]&&_0x16e416[_0xdb2e('0x19')]>0x1;var _0x419083=[];if(!fs[_0xdb2e('0x21')](path[_0xdb2e('0x22')](_0x2c85e7,_0x5ba45c))&&_0x366212){fs[_0xdb2e('0x23')](path['join'](_0x2c85e7,_0x5ba45c));}return BPromise[_0xdb2e('0x24')](_0x16e416,function(_0x3b393b){_0x419083[_0xdb2e('0x1d')](_0x3b393b);})[_0xdb2e('0x11')](function(){for(var _0xaf4631=0x0;_0xaf4631<_0x419083[_0xdb2e('0x19')];_0xaf4631+=0x1){var _0x4fe762;var _0x8e76e5=_0x419083[_0xaf4631];if(_0x366212){_0x4fe762=path[_0xdb2e('0x22')](_0x2c85e7,_0x5ba45c,util[_0xdb2e('0xc')](_0xdb2e('0x25'),_0x5ba45c,_0xaf4631,'xlsx'));}else{_0x4fe762=path[_0xdb2e('0x22')](_0x2c85e7,util['format'](_0xdb2e('0x26'),_0x5ba45c,'xlsx'));}fs[_0xdb2e('0x27')](_0x4fe762,json2xls(_0x8e76e5),_0xdb2e('0x28'));}})['then'](function(){if(_0x366212){return new Promise(function(_0x19ae3b){zipdir(path[_0xdb2e('0x22')](_0x2c85e7,_0x5ba45c),{'saveTo':path[_0xdb2e('0x22')](_0x2c85e7,util[_0xdb2e('0xc')](_0xdb2e('0x26'),_0x5ba45c,'zip'))},function(_0x3ed8fb,_0x522f68){rimraf(path[_0xdb2e('0x22')](_0x2c85e7,_0x5ba45c),function(){});_0x19ae3b(_0xdb2e('0x29'));});});}})['then'](function(){logger['info'](util['format'](_0xdb2e('0x2a'),EXTRACTED_REPORT_ID,'XLSX'));return analyticExtractedReport(_0xdb2e('0x2b'),_0x366212?util['format']('%s.%s',_0x5ba45c,_0x366212?_0xdb2e('0x2c'):_0xdb2e('0x2d')):null);});})['catch'](function(_0x30bbfb){logger[_0xdb2e('0xb')](util[_0xdb2e('0xc')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0xdb2e('0xd')),util['inspect'](_0x30bbfb,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xdb2e('0x2e'));})[_0xdb2e('0x2f')](function(){process[_0xdb2e('0x30')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff