// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x0d68=['zip-dir','../../mysqldb','dbH','../../config/logger','argv','AnalyticExtractedReport','update','info','format','XLSX','Setting','find','split','splitSizeXlsx','then','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','num','length','push','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','dirname','join','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','zip','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','catch','inspect','Failed','util','path','lodash','json2xls'];(function(_0x18e570,_0x257e84){var _0x2a421e=function(_0x5cb790){while(--_0x5cb790){_0x18e570['push'](_0x18e570['shift']());}};_0x2a421e(++_0x257e84);}(_0x0d68,0x144));var _0x80d6=function(_0x53f2d7,_0x2f4ce8){_0x53f2d7=_0x53f2d7-0x0;var _0x4e252a=_0x0d68[_0x53f2d7];return _0x4e252a;};'use strict';var util=require(_0x80d6('0x0'));var path=require(_0x80d6('0x1'));var _=require(_0x80d6('0x2'));var fs=require('fs');var json2xls=require(_0x80d6('0x3'));var BPromise=require('bluebird');var zipdir=require(_0x80d6('0x4'));var rimraf=require('rimraf');var db=require(_0x80d6('0x5'))['db'];var dbH=require(_0x80d6('0x5'))[_0x80d6('0x6')];var logger=require(_0x80d6('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x80d6('0x8')][0x3];var PATH=process[_0x80d6('0x8')][0x4];function analyticExtractedReport(_0x1558a4,_0x900605){var _0x4e9afa={'status':_0x1558a4};var _0x115749={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x900605){_0x4e9afa['savename']=_0x900605;}return db[_0x80d6('0x9')][_0x80d6('0xa')](_0x4e9afa,_0x115749);}function main(){var _0x40e1dd=0x1388;var _0x4c30a6;logger[_0x80d6('0xb')](util[_0x80d6('0xc')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x80d6('0xd')));return db[_0x80d6('0xe')][_0x80d6('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x80d6('0x10'),_0x80d6('0x11')]})[_0x80d6('0x12')](function(_0x1a00ab){if(_0x1a00ab){_0x4c30a6=_0x1a00ab;_0x40e1dd=_0x4c30a6[_0x80d6('0x11')]||0x1388;}})[_0x80d6('0x12')](function(){return dbH['sequelize'][_0x80d6('0x13')](util[_0x80d6('0xc')](_0x80d6('0x14'),QUERY),{'type':dbH[_0x80d6('0x15')][_0x80d6('0x16')]['SELECT']});})[_0x80d6('0x12')](function(_0x238312){if(!_0x238312[0x0][_0x80d6('0x17')]){return analyticExtractedReport('Empty');}var _0x4fe61f=[];var _0x1aa72f=0x0;var _0x2565f4=!![];if(_0x4c30a6['split']){if(_0x238312&&_0x238312[_0x80d6('0x18')]){var _0x129d61=_0x238312[0x0]['num']%(_0x1aa72f+_0x40e1dd);for(;_0x2565f4;_0x1aa72f+=_0x40e1dd,_0x129d61=_0x238312[0x0][_0x80d6('0x17')]%(_0x1aa72f+_0x40e1dd)){if(_0x129d61==0x0||_0x129d61==_0x238312[0x0][_0x80d6('0x17')]){_0x2565f4=![];}_0x4fe61f[_0x80d6('0x19')](dbH[_0x80d6('0x15')][_0x80d6('0x13')](util[_0x80d6('0xc')](_0x80d6('0x1a'),QUERY,_0x40e1dd,_0x1aa72f),{'type':dbH[_0x80d6('0x15')][_0x80d6('0x16')][_0x80d6('0x1b')]}));}}}else{_0x4fe61f['push'](dbH[_0x80d6('0x15')][_0x80d6('0x13')](QUERY,{'type':dbH[_0x80d6('0x15')]['QueryTypes'][_0x80d6('0x1b')]}));}var _0x3f811f=path[_0x80d6('0x1c')](PATH);var _0x5290b7=path['basename'](PATH,'.xlsx');var _0x2a90fa=_0x4c30a6[_0x80d6('0x10')]&&_0x4fe61f[_0x80d6('0x18')]>0x1;var _0x5c88bf=[];if(!fs['existsSync'](path[_0x80d6('0x1d')](_0x3f811f,_0x5290b7))&&_0x2a90fa){fs['mkdirSync'](path[_0x80d6('0x1d')](_0x3f811f,_0x5290b7));}return BPromise[_0x80d6('0x1e')](_0x4fe61f,function(_0x2634de){_0x5c88bf[_0x80d6('0x19')](_0x2634de);})[_0x80d6('0x12')](function(){for(var _0x3ed1fc=0x0;_0x3ed1fc<_0x5c88bf[_0x80d6('0x18')];_0x3ed1fc+=0x1){var _0xcc204c;var _0x4632bf=_0x5c88bf[_0x3ed1fc];if(_0x2a90fa){_0xcc204c=path[_0x80d6('0x1d')](_0x3f811f,_0x5290b7,util['format'](_0x80d6('0x1f'),_0x5290b7,_0x3ed1fc,_0x80d6('0x20')));}else{_0xcc204c=path['join'](_0x3f811f,util[_0x80d6('0xc')](_0x80d6('0x21'),_0x5290b7,'xlsx'));}fs[_0x80d6('0x22')](_0xcc204c,json2xls(_0x4632bf),_0x80d6('0x23'));}})[_0x80d6('0x12')](function(){if(_0x2a90fa){zipdir(path['join'](_0x3f811f,_0x5290b7),{'saveTo':path[_0x80d6('0x1d')](_0x3f811f,util[_0x80d6('0xc')](_0x80d6('0x21'),_0x5290b7,_0x80d6('0x24')))},function(_0x54d8ce,_0x3d1330){});rimraf(path['join'](_0x3f811f,_0x5290b7),function(){});}})[_0x80d6('0x12')](function(){logger[_0x80d6('0xb')](util[_0x80d6('0xc')](_0x80d6('0x25'),EXTRACTED_REPORT_ID,_0x80d6('0xd')));return analyticExtractedReport('Completed',_0x2a90fa?util[_0x80d6('0xc')]('%s.%s',_0x5290b7,_0x2a90fa?'zip':'xlsx'):null);});})[_0x80d6('0x26')](function(_0x306dd9){logger['info'](util[_0x80d6('0xc')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,'XLSX'),util[_0x80d6('0x27')](_0x306dd9,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x80d6('0x28'));});}main();
\ No newline at end of file
+var _0x3914=['sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','Empty','length','num','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','.xlsx','existsSync','mkdirSync','join','each','%s.%s','xlsx','writeFileSync','info','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','util','path','json2xls','bluebird','rimraf','../../mysqldb','../../config/logger','analytics','argv','update','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','split','splitSizeXlsx','then'];(function(_0xfb0ec4,_0x33037d){var _0x1a2829=function(_0x55550b){while(--_0x55550b){_0xfb0ec4['push'](_0xfb0ec4['shift']());}};_0x1a2829(++_0x33037d);}(_0x3914,0xeb));var _0x4391=function(_0x1cfa0d,_0x4391f2){_0x1cfa0d=_0x1cfa0d-0x0;var _0xe33279=_0x3914[_0x1cfa0d];return _0xe33279;};'use strict';var util=require(_0x4391('0x0'));var path=require(_0x4391('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0x4391('0x2'));var BPromise=require(_0x4391('0x3'));var zipdir=require('zip-dir');var rimraf=require(_0x4391('0x4'));var db=require(_0x4391('0x5'))['db'];var dbH=require(_0x4391('0x5'))['dbH'];var logger=require(_0x4391('0x6'))(_0x4391('0x7'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x4391('0x8')][0x3];var PATH=process['argv'][0x4];function analyticExtractedReport(_0x4733a2,_0x5c32ac){var _0x378c09={'status':_0x4733a2};var _0x17bcfb={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x5c32ac){_0x378c09['savename']=_0x5c32ac;}return db['AnalyticExtractedReport'][_0x4391('0x9')](_0x378c09,_0x17bcfb);}function main(){var _0x1b726e=0x1388;var _0x3539e3;logger['info'](util[_0x4391('0xa')](_0x4391('0xb'),EXTRACTED_REPORT_ID,_0x4391('0xc')));return db[_0x4391('0xd')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x4391('0xe'),_0x4391('0xf')]})[_0x4391('0x10')](function(_0x137902){if(_0x137902){_0x3539e3=_0x137902;_0x1b726e=_0x3539e3[_0x4391('0xf')]||0x1388;}})[_0x4391('0x10')](function(){return dbH[_0x4391('0x11')][_0x4391('0x12')](util['format'](_0x4391('0x13'),QUERY),{'type':dbH[_0x4391('0x11')][_0x4391('0x14')][_0x4391('0x15')]});})['then'](function(_0x62c763){if(!_0x62c763[0x0]['num']){return analyticExtractedReport(_0x4391('0x16'));}var _0x3a1b80=[];var _0x3e4585=0x0;var _0x1c2038=!![];if(_0x3539e3[_0x4391('0xe')]){if(_0x62c763&&_0x62c763[_0x4391('0x17')]){var _0x2b5117=_0x62c763[0x0][_0x4391('0x18')]%(_0x3e4585+_0x1b726e);for(;_0x1c2038;_0x3e4585+=_0x1b726e,_0x2b5117=_0x62c763[0x0]['num']%(_0x3e4585+_0x1b726e)){if(_0x2b5117==0x0||_0x2b5117==_0x62c763[0x0]['num']){_0x1c2038=![];}_0x3a1b80[_0x4391('0x19')](dbH['sequelize'][_0x4391('0x12')](util[_0x4391('0xa')](_0x4391('0x1a'),QUERY,_0x1b726e,_0x3e4585),{'type':dbH[_0x4391('0x11')][_0x4391('0x14')]['SELECT']}));}}}else{_0x3a1b80['push'](dbH[_0x4391('0x11')][_0x4391('0x12')](QUERY,{'type':dbH[_0x4391('0x11')]['QueryTypes'][_0x4391('0x15')]}));}var _0x23fe8c=path[_0x4391('0x1b')](PATH);var _0x3e1e0b=path['basename'](PATH,_0x4391('0x1c'));var _0x2b7a1d=_0x3539e3[_0x4391('0xe')]&&_0x3a1b80[_0x4391('0x17')]>0x1;var _0x24e16c=[];if(!fs[_0x4391('0x1d')](path['join'](_0x23fe8c,_0x3e1e0b))&&_0x2b7a1d){fs[_0x4391('0x1e')](path[_0x4391('0x1f')](_0x23fe8c,_0x3e1e0b));}return BPromise[_0x4391('0x20')](_0x3a1b80,function(_0x333ca6){_0x24e16c['push'](_0x333ca6);})['then'](function(){for(var _0x11c859=0x0;_0x11c859<_0x24e16c[_0x4391('0x17')];_0x11c859+=0x1){var _0x3f2554;var _0x197408=_0x24e16c[_0x11c859];if(_0x2b7a1d){_0x3f2554=path[_0x4391('0x1f')](_0x23fe8c,_0x3e1e0b,util['format']('%s%d.%s',_0x3e1e0b,_0x11c859,'xlsx'));}else{_0x3f2554=path['join'](_0x23fe8c,util[_0x4391('0xa')](_0x4391('0x21'),_0x3e1e0b,_0x4391('0x22')));}fs[_0x4391('0x23')](_0x3f2554,json2xls(_0x197408),'binary');}})[_0x4391('0x10')](function(){if(_0x2b7a1d){zipdir(path[_0x4391('0x1f')](_0x23fe8c,_0x3e1e0b),{'saveTo':path[_0x4391('0x1f')](_0x23fe8c,util[_0x4391('0xa')](_0x4391('0x21'),_0x3e1e0b,'zip'))},function(_0x1a8df0,_0x3edb24){});rimraf(path[_0x4391('0x1f')](_0x23fe8c,_0x3e1e0b),function(){});}})[_0x4391('0x10')](function(){logger[_0x4391('0x24')](util[_0x4391('0xa')](_0x4391('0x25'),EXTRACTED_REPORT_ID,_0x4391('0xc')));return analyticExtractedReport(_0x4391('0x26'),_0x2b7a1d?util[_0x4391('0xa')](_0x4391('0x21'),_0x3e1e0b,_0x2b7a1d?'zip':_0x4391('0x22')):null);});})['catch'](function(_0x122405){logger['info'](util['format'](_0x4391('0x27'),EXTRACTED_REPORT_ID,_0x4391('0xc')),util[_0x4391('0x28')](_0x122405,{'showHidden':![],'depth':null}));return analyticExtractedReport(_0x4391('0x29'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff