// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa724=['num','forEach','query','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','dirname','basename','join','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','zip\x20finished','catch','inspect','Failed','finally','exit','util','json2xls','zip-dir','../../mysqldb','dbH','../../config/logger','argv','savename','AnalyticExtractedReport','update','info','format','XLSX','Setting','find','split','then','splitSizeXlsx','sequelize','QueryTypes','Empty','length','range'];(function(_0x41f55e,_0x264009){var _0x922b33=function(_0x510189){while(--_0x510189){_0x41f55e['push'](_0x41f55e['shift']());}};_0x922b33(++_0x264009);}(_0xa724,0xf1));var _0x4a72=function(_0x261056,_0x4c0b51){_0x261056=_0x261056-0x0;var _0x155a5b=_0xa724[_0x261056];return _0x155a5b;};'use strict';var util=require(_0x4a72('0x0'));var path=require('path');var _=require('lodash');var fs=require('fs');var json2xls=require(_0x4a72('0x1'));var BPromise=require('bluebird');var zipdir=require(_0x4a72('0x2'));var rimraf=require('rimraf');var db=require(_0x4a72('0x3'))['db'];var dbH=require(_0x4a72('0x3'))[_0x4a72('0x4')];var logger=require(_0x4a72('0x5'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0x4a72('0x6')][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x4a72('0x6')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x16d588,_0x26978e){var _0x58cb63={'status':_0x16d588};var _0x12bf20={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x26978e){_0x58cb63[_0x4a72('0x7')]=_0x26978e;}return db[_0x4a72('0x8')][_0x4a72('0x9')](_0x58cb63,_0x12bf20);}function main(){var _0x31d686=0x1388;var _0x3e20a6;logger[_0x4a72('0xa')](util[_0x4a72('0xb')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x4a72('0xc')));return db[_0x4a72('0xd')][_0x4a72('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x4a72('0xf'),'splitSizeXlsx']})[_0x4a72('0x10')](function(_0x167046){if(_0x167046){_0x3e20a6=_0x167046;_0x31d686=_0x3e20a6[_0x4a72('0x11')]||0x1388;}})[_0x4a72('0x10')](function(){return dbH['sequelize']['query'](util['format']('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x4a72('0x12')][_0x4a72('0x13')]['SELECT']});})[_0x4a72('0x10')](function(_0x2246e6){if(!_0x2246e6[0x0]['num']){return analyticExtractedReport(_0x4a72('0x14'));}var _0x33885c=[];var _0x141b39=0x0;if(_0x3e20a6[_0x4a72('0xf')]){if(_0x2246e6&&_0x2246e6[_0x4a72('0x15')]){var _0x1428dd=_[_0x4a72('0x16')](_0x2246e6[0x0]['num']/_0x31d686);var _0x15b72a=Number['isInteger'](_0x2246e6[0x0][_0x4a72('0x17')]/_0x31d686)?_0x2246e6[0x0][_0x4a72('0x17')]%_0x31d686:0x0;_0x1428dd[_0x4a72('0x18')](function(_0x193d2f){if(_0x193d2f>0x0){_0x141b39+=_0x31d686;}_0x33885c['push'](dbH['sequelize'][_0x4a72('0x19')](util[_0x4a72('0xb')](_0x4a72('0x1a'),QUERY,_0x31d686,_0x141b39),{'type':dbH[_0x4a72('0x12')][_0x4a72('0x13')][_0x4a72('0x1b')]}));});if(_0x15b72a>0x0){_0x141b39+=_0x31d686;_0x33885c['push'](dbH[_0x4a72('0x12')][_0x4a72('0x19')](util[_0x4a72('0xb')](_0x4a72('0x1a'),QUERY,_0x15b72a,_0x141b39),{'type':dbH[_0x4a72('0x12')][_0x4a72('0x13')][_0x4a72('0x1b')]}));}}}else{_0x33885c['push'](dbH[_0x4a72('0x12')][_0x4a72('0x19')](QUERY,{'type':dbH['sequelize'][_0x4a72('0x13')][_0x4a72('0x1b')]}));}var _0x3b2e3e=path[_0x4a72('0x1c')](PATH);var _0x3fffd1=path[_0x4a72('0x1d')](PATH,'.xlsx');var _0x5192c7=_0x3e20a6[_0x4a72('0xf')]&&_0x33885c[_0x4a72('0x15')]>0x1;var _0x2f778a=[];if(!fs['existsSync'](path[_0x4a72('0x1e')](_0x3b2e3e,_0x3fffd1))&&_0x5192c7){fs['mkdirSync'](path[_0x4a72('0x1e')](_0x3b2e3e,_0x3fffd1));}return BPromise[_0x4a72('0x1f')](_0x33885c,function(_0xc29c67){_0x2f778a['push'](_0xc29c67);})['then'](function(){for(var _0x2407d5=0x0;_0x2407d5<_0x2f778a[_0x4a72('0x15')];_0x2407d5+=0x1){var _0x3f63cf;var _0x366049=_0x2f778a[_0x2407d5];if(_0x5192c7){_0x3f63cf=path[_0x4a72('0x1e')](_0x3b2e3e,_0x3fffd1,util[_0x4a72('0xb')](_0x4a72('0x20'),_0x3fffd1,_0x2407d5,_0x4a72('0x21')));}else{_0x3f63cf=path[_0x4a72('0x1e')](_0x3b2e3e,util[_0x4a72('0xb')](_0x4a72('0x22'),_0x3fffd1,'xlsx'));}fs[_0x4a72('0x23')](_0x3f63cf,json2xls(_0x366049),_0x4a72('0x24'));}})[_0x4a72('0x10')](function(){if(_0x5192c7){return new Promise(function(_0x4548be){zipdir(path[_0x4a72('0x1e')](_0x3b2e3e,_0x3fffd1),{'saveTo':path[_0x4a72('0x1e')](_0x3b2e3e,util['format'](_0x4a72('0x22'),_0x3fffd1,_0x4a72('0x25')))},function(_0x4d5595,_0x40bf64){rimraf(path[_0x4a72('0x1e')](_0x3b2e3e,_0x3fffd1),function(){});_0x4548be(_0x4a72('0x26'));});});}})['then'](function(){logger[_0x4a72('0xa')](util[_0x4a72('0xb')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x4a72('0xc')));return analyticExtractedReport('Completed',_0x5192c7?util[_0x4a72('0xb')](_0x4a72('0x22'),_0x3fffd1,_0x5192c7?_0x4a72('0x25'):_0x4a72('0x21')):null);});})[_0x4a72('0x27')](function(_0x43fe58){logger[_0x4a72('0xa')](util[_0x4a72('0xb')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x4a72('0xc')),util[_0x4a72('0x28')](_0x43fe58,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x4a72('0x29'));})[_0x4a72('0x2a')](function(){process[_0x4a72('0x2b')](EXIT_CODE);});}main();
\ No newline at end of file
+var _0xd873=['zip','XLSX','Completed','inspect','finally','util','path','json2xls','../../mysqldb','dbH','../../config/logger','analytics','argv','savename','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','splitSizeXlsx','then','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','SELECT','num','length','range','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','existsSync','mkdirSync','each','join','%s%d.%s','xlsx','%s.%s','binary'];(function(_0x1ca370,_0x518688){var _0xf0ada9=function(_0x4d7c93){while(--_0x4d7c93){_0x1ca370['push'](_0x1ca370['shift']());}};_0xf0ada9(++_0x518688);}(_0xd873,0xe6));var _0x3d87=function(_0x5a929e,_0x34faae){_0x5a929e=_0x5a929e-0x0;var _0x1ebef3=_0xd873[_0x5a929e];return _0x1ebef3;};'use strict';var util=require(_0x3d87('0x0'));var path=require(_0x3d87('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0x3d87('0x2'));var BPromise=require('bluebird');var zipdir=require('zip-dir');var rimraf=require('rimraf');var db=require(_0x3d87('0x3'))['db'];var dbH=require(_0x3d87('0x3'))[_0x3d87('0x4')];var logger=require(_0x3d87('0x5'))(_0x3d87('0x6'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x3d87('0x7')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x9d937,_0x41b4ed){var _0x48ef36={'status':_0x9d937};var _0x52a908={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x41b4ed){_0x48ef36[_0x3d87('0x8')]=_0x41b4ed;}return db[_0x3d87('0x9')]['update'](_0x48ef36,_0x52a908);}function main(){var _0x3fc9b2=0x1388;var _0x1ad359;logger[_0x3d87('0xa')](util[_0x3d87('0xb')](_0x3d87('0xc'),EXTRACTED_REPORT_ID,'XLSX'));return db[_0x3d87('0xd')][_0x3d87('0xe')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x3d87('0xf')]})[_0x3d87('0x10')](function(_0x4b794e){if(_0x4b794e){_0x1ad359=_0x4b794e;_0x3fc9b2=_0x1ad359['splitSizeXlsx']||0x1388;}})['then'](function(){return dbH['sequelize'][_0x3d87('0x11')](util[_0x3d87('0xb')](_0x3d87('0x12'),QUERY),{'type':dbH[_0x3d87('0x13')][_0x3d87('0x14')][_0x3d87('0x15')]});})[_0x3d87('0x10')](function(_0x251b3c){if(!_0x251b3c[0x0][_0x3d87('0x16')]){return analyticExtractedReport('Empty');}var _0x1f77c0=[];var _0x32d20c=0x0;if(_0x1ad359['split']){if(_0x251b3c&&_0x251b3c[_0x3d87('0x17')]){var _0x2a87d6=_[_0x3d87('0x18')](_0x251b3c[0x0][_0x3d87('0x16')]/_0x3fc9b2);var _0x4a4a14=Number[_0x3d87('0x19')](_0x251b3c[0x0]['num']/_0x3fc9b2)?_0x251b3c[0x0][_0x3d87('0x16')]%_0x3fc9b2:0x0;_0x2a87d6[_0x3d87('0x1a')](function(_0xc3baa){if(_0xc3baa>0x0){_0x32d20c+=_0x3fc9b2;}_0x1f77c0[_0x3d87('0x1b')](dbH['sequelize'][_0x3d87('0x11')](util['format'](_0x3d87('0x1c'),QUERY,_0x3fc9b2,_0x32d20c),{'type':dbH['sequelize'][_0x3d87('0x14')][_0x3d87('0x15')]}));});if(_0x4a4a14>0x0){_0x32d20c+=_0x3fc9b2;_0x1f77c0[_0x3d87('0x1b')](dbH['sequelize'][_0x3d87('0x11')](util[_0x3d87('0xb')](_0x3d87('0x1c'),QUERY,_0x4a4a14,_0x32d20c),{'type':dbH[_0x3d87('0x13')][_0x3d87('0x14')]['SELECT']}));}}}else{_0x1f77c0[_0x3d87('0x1b')](dbH[_0x3d87('0x13')][_0x3d87('0x11')](QUERY,{'type':dbH['sequelize'][_0x3d87('0x14')]['SELECT']}));}var _0x12b2fb=path[_0x3d87('0x1d')](PATH);var _0x2541f4=path[_0x3d87('0x1e')](PATH,_0x3d87('0x1f'));var _0x12beae=_0x1ad359['split']&&_0x1f77c0[_0x3d87('0x17')]>0x1;var _0x8c692=[];if(!fs[_0x3d87('0x20')](path['join'](_0x12b2fb,_0x2541f4))&&_0x12beae){fs[_0x3d87('0x21')](path['join'](_0x12b2fb,_0x2541f4));}return BPromise[_0x3d87('0x22')](_0x1f77c0,function(_0x4d48c1){_0x8c692[_0x3d87('0x1b')](_0x4d48c1);})['then'](function(){for(var _0x2c5e3b=0x0;_0x2c5e3b<_0x8c692[_0x3d87('0x17')];_0x2c5e3b+=0x1){var _0x5db466;var _0x1ee1da=_0x8c692[_0x2c5e3b];if(_0x12beae){_0x5db466=path[_0x3d87('0x23')](_0x12b2fb,_0x2541f4,util['format'](_0x3d87('0x24'),_0x2541f4,_0x2c5e3b,_0x3d87('0x25')));}else{_0x5db466=path[_0x3d87('0x23')](_0x12b2fb,util['format'](_0x3d87('0x26'),_0x2541f4,_0x3d87('0x25')));}fs['writeFileSync'](_0x5db466,json2xls(_0x1ee1da),_0x3d87('0x27'));}})[_0x3d87('0x10')](function(){if(_0x12beae){return new Promise(function(_0x535356){zipdir(path[_0x3d87('0x23')](_0x12b2fb,_0x2541f4),{'saveTo':path[_0x3d87('0x23')](_0x12b2fb,util[_0x3d87('0xb')](_0x3d87('0x26'),_0x2541f4,_0x3d87('0x28')))},function(_0x229d0e,_0x4e7e0d){rimraf(path[_0x3d87('0x23')](_0x12b2fb,_0x2541f4),function(){});_0x535356('zip\x20finished');});});}})[_0x3d87('0x10')](function(){logger[_0x3d87('0xa')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x3d87('0x29')));return analyticExtractedReport(_0x3d87('0x2a'),_0x12beae?util[_0x3d87('0xb')]('%s.%s',_0x2541f4,_0x12beae?'zip':_0x3d87('0x25')):null);});})['catch'](function(_0x4f2096){logger['info'](util[_0x3d87('0xb')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x3d87('0x29')),util[_0x3d87('0x2b')](_0x4f2096,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0x3d87('0x2c')](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff