// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb40d=['each','%s%d.%s','%s.%s','xlsx','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','Failed','util','path','json2xls','bluebird','zip-dir','../../mysqldb','dbH','../../config/logger','argv','AnalyticExtractedReport','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','find','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','split','length','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','.xlsx','existsSync','join','mkdirSync'];(function(_0x39530b,_0x4c5925){var _0x859e0d=function(_0x34e0b0){while(--_0x34e0b0){_0x39530b['push'](_0x39530b['shift']());}};_0x859e0d(++_0x4c5925);}(_0xb40d,0xc8));var _0xdb40=function(_0x29b01f,_0x13e8bb){_0x29b01f=_0x29b01f-0x0;var _0xf7d6c3=_0xb40d[_0x29b01f];return _0xf7d6c3;};'use strict';var util=require(_0xdb40('0x0'));var path=require(_0xdb40('0x1'));var _=require('lodash');var fs=require('fs');var json2xls=require(_0xdb40('0x2'));var BPromise=require(_0xdb40('0x3'));var zipdir=require(_0xdb40('0x4'));var rimraf=require('rimraf');var db=require(_0xdb40('0x5'))['db'];var dbH=require('../../mysqldb')[_0xdb40('0x6')];var logger=require(_0xdb40('0x7'))('analytics');var EXTRACTED_REPORT_ID=Number(process[_0xdb40('0x8')][0x2]);var QUERY=process[_0xdb40('0x8')][0x3];var PATH=process[_0xdb40('0x8')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x196ffd,_0x281f34){var _0x66e4e7={'status':_0x196ffd};var _0x421066={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x281f34){_0x66e4e7['savename']=_0x281f34;}return db[_0xdb40('0x9')]['update'](_0x66e4e7,_0x421066);}function main(){var _0x398d5c=0x1388;var _0x4b1aaa;logger[_0xdb40('0xa')](util[_0xdb40('0xb')](_0xdb40('0xc'),EXTRACTED_REPORT_ID,_0xdb40('0xd')));return db[_0xdb40('0xe')][_0xdb40('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0xdb40('0x10')]})[_0xdb40('0x11')](function(_0x377a50){if(_0x377a50){_0x4b1aaa=_0x377a50;_0x398d5c=_0x4b1aaa['splitSizeXlsx']||0x1388;}})[_0xdb40('0x11')](function(){return dbH[_0xdb40('0x12')][_0xdb40('0x13')](util['format'](_0xdb40('0x14'),QUERY),{'type':dbH[_0xdb40('0x12')][_0xdb40('0x15')][_0xdb40('0x16')]});})['then'](function(_0x3ab6d4){if(!_0x3ab6d4[0x0][_0xdb40('0x17')]){return analyticExtractedReport(_0xdb40('0x18'));}var _0x1238a4=[];var _0x29d37c=0x0;if(_0x4b1aaa[_0xdb40('0x19')]){if(_0x3ab6d4&&_0x3ab6d4[_0xdb40('0x1a')]){var _0xd22e10=_['range'](_0x3ab6d4[0x0][_0xdb40('0x17')]/_0x398d5c);var _0xc37d23=Number[_0xdb40('0x1b')](_0x3ab6d4[0x0][_0xdb40('0x17')]/_0x398d5c)?_0x3ab6d4[0x0][_0xdb40('0x17')]%_0x398d5c:0x0;_0xd22e10[_0xdb40('0x1c')](function(_0x579370){if(_0x579370>0x0){_0x29d37c+=_0x398d5c;}_0x1238a4[_0xdb40('0x1d')](dbH[_0xdb40('0x12')][_0xdb40('0x13')](util[_0xdb40('0xb')](_0xdb40('0x1e'),QUERY,_0x398d5c,_0x29d37c),{'type':dbH[_0xdb40('0x12')][_0xdb40('0x15')][_0xdb40('0x16')]}));});if(_0xc37d23>0x0){_0x29d37c+=_0x398d5c;_0x1238a4[_0xdb40('0x1d')](dbH[_0xdb40('0x12')][_0xdb40('0x13')](util[_0xdb40('0xb')](_0xdb40('0x1e'),QUERY,_0xc37d23,_0x29d37c),{'type':dbH[_0xdb40('0x12')][_0xdb40('0x15')]['SELECT']}));}}}else{_0x1238a4[_0xdb40('0x1d')](dbH[_0xdb40('0x12')][_0xdb40('0x13')](QUERY,{'type':dbH[_0xdb40('0x12')]['QueryTypes'][_0xdb40('0x16')]}));}var _0x52261c=path['dirname'](PATH);var _0x17a409=path['basename'](PATH,_0xdb40('0x1f'));var _0x377172=_0x4b1aaa[_0xdb40('0x19')]&&_0x1238a4[_0xdb40('0x1a')]>0x1;var _0x1e5936=[];if(!fs[_0xdb40('0x20')](path[_0xdb40('0x21')](_0x52261c,_0x17a409))&&_0x377172){fs[_0xdb40('0x22')](path[_0xdb40('0x21')](_0x52261c,_0x17a409));}return BPromise[_0xdb40('0x23')](_0x1238a4,function(_0x3fdc39){_0x1e5936[_0xdb40('0x1d')](_0x3fdc39);})['then'](function(){for(var _0x597ba9=0x0;_0x597ba9<_0x1e5936['length'];_0x597ba9+=0x1){var _0x14f195;var _0x3c9393=_0x1e5936[_0x597ba9];if(_0x377172){_0x14f195=path['join'](_0x52261c,_0x17a409,util[_0xdb40('0xb')](_0xdb40('0x24'),_0x17a409,_0x597ba9,'xlsx'));}else{_0x14f195=path[_0xdb40('0x21')](_0x52261c,util[_0xdb40('0xb')](_0xdb40('0x25'),_0x17a409,_0xdb40('0x26')));}fs[_0xdb40('0x27')](_0x14f195,json2xls(_0x3c9393),_0xdb40('0x28'));}})[_0xdb40('0x11')](function(){if(_0x377172){return new Promise(function(_0x3fff7d){zipdir(path[_0xdb40('0x21')](_0x52261c,_0x17a409),{'saveTo':path[_0xdb40('0x21')](_0x52261c,util[_0xdb40('0xb')]('%s.%s',_0x17a409,_0xdb40('0x29')))},function(_0x17643e,_0x4ba478){rimraf(path[_0xdb40('0x21')](_0x52261c,_0x17a409),function(){});_0x3fff7d('zip\x20finished');});});}})[_0xdb40('0x11')](function(){logger[_0xdb40('0xa')](util[_0xdb40('0xb')](_0xdb40('0x2a'),EXTRACTED_REPORT_ID,_0xdb40('0xd')));return analyticExtractedReport(_0xdb40('0x2b'),_0x377172?util['format'](_0xdb40('0x25'),_0x17a409,_0x377172?_0xdb40('0x29'):_0xdb40('0x26')):null);});})[_0xdb40('0x2c')](function(_0x3e72d0){logger[_0xdb40('0xa')](util[_0xdb40('0xb')](_0xdb40('0x2d'),EXTRACTED_REPORT_ID,_0xdb40('0xd')),util['inspect'](_0x3e72d0,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0xdb40('0x2e'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x8d41=['savename','AnalyticExtractedReport','update','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','Setting','split','splitSizeXlsx','then','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','SELECT','num','Empty','length','range','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','dirname','basename','.xlsx','join','mkdirSync','each','%s%d.%s','%s.%s','xlsx','writeFileSync','zip','zip\x20finished','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','finally','exit','util','path','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv'];(function(_0x58e469,_0x95ee3e){var _0x4c01c5=function(_0x1ef7ae){while(--_0x1ef7ae){_0x58e469['push'](_0x58e469['shift']());}};_0x4c01c5(++_0x95ee3e);}(_0x8d41,0x167));var _0x18d4=function(_0x29f258,_0x559572){_0x29f258=_0x29f258-0x0;var _0x1315c7=_0x8d41[_0x29f258];return _0x1315c7;};'use strict';var util=require(_0x18d4('0x0'));var path=require(_0x18d4('0x1'));var _=require(_0x18d4('0x2'));var fs=require('fs');var json2xls=require(_0x18d4('0x3'));var BPromise=require(_0x18d4('0x4'));var zipdir=require(_0x18d4('0x5'));var rimraf=require(_0x18d4('0x6'));var db=require('../../mysqldb')['db'];var dbH=require(_0x18d4('0x7'))[_0x18d4('0x8')];var logger=require(_0x18d4('0x9'))(_0x18d4('0xa'));var EXTRACTED_REPORT_ID=Number(process[_0x18d4('0xb')][0x2]);var QUERY=process[_0x18d4('0xb')][0x3];var PATH=process[_0x18d4('0xb')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x181e10,_0x51539d){var _0x2e1962={'status':_0x181e10};var _0x4100be={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x51539d){_0x2e1962[_0x18d4('0xc')]=_0x51539d;}return db[_0x18d4('0xd')][_0x18d4('0xe')](_0x2e1962,_0x4100be);}function main(){var _0x50c35b=0x1388;var _0x3f218c;logger[_0x18d4('0xf')](util['format'](_0x18d4('0x10'),EXTRACTED_REPORT_ID,_0x18d4('0x11')));return db[_0x18d4('0x12')]['find']({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x18d4('0x13'),_0x18d4('0x14')]})[_0x18d4('0x15')](function(_0x51a483){if(_0x51a483){_0x3f218c=_0x51a483;_0x50c35b=_0x3f218c[_0x18d4('0x14')]||0x1388;}})['then'](function(){return dbH['sequelize'][_0x18d4('0x16')](util[_0x18d4('0x17')](_0x18d4('0x18'),QUERY),{'type':dbH[_0x18d4('0x19')][_0x18d4('0x1a')][_0x18d4('0x1b')]});})['then'](function(_0x46e042){if(!_0x46e042[0x0][_0x18d4('0x1c')]){return analyticExtractedReport(_0x18d4('0x1d'));}var _0xa62c26=[];var _0x263fa2=0x0;if(_0x3f218c['split']){if(_0x46e042&&_0x46e042[_0x18d4('0x1e')]){var _0x1438fd=_[_0x18d4('0x1f')](_0x46e042[0x0][_0x18d4('0x1c')]/_0x50c35b);var _0xc8ca32=Number[_0x18d4('0x20')](_0x46e042[0x0]['num']/_0x50c35b)?_0x46e042[0x0][_0x18d4('0x1c')]%_0x50c35b:0x0;_0x1438fd[_0x18d4('0x21')](function(_0x5410a7){if(_0x5410a7>0x0){_0x263fa2+=_0x50c35b;}_0xa62c26[_0x18d4('0x22')](dbH[_0x18d4('0x19')]['query'](util['format'](_0x18d4('0x23'),QUERY,_0x50c35b,_0x263fa2),{'type':dbH[_0x18d4('0x19')][_0x18d4('0x1a')][_0x18d4('0x1b')]}));});if(_0xc8ca32>0x0){_0x263fa2+=_0x50c35b;_0xa62c26['push'](dbH['sequelize'][_0x18d4('0x16')](util[_0x18d4('0x17')](_0x18d4('0x23'),QUERY,_0xc8ca32,_0x263fa2),{'type':dbH['sequelize'][_0x18d4('0x1a')]['SELECT']}));}}}else{_0xa62c26['push'](dbH['sequelize'][_0x18d4('0x16')](QUERY,{'type':dbH[_0x18d4('0x19')][_0x18d4('0x1a')]['SELECT']}));}var _0x4355f8=path[_0x18d4('0x24')](PATH);var _0x14722f=path[_0x18d4('0x25')](PATH,_0x18d4('0x26'));var _0xd35410=_0x3f218c[_0x18d4('0x13')]&&_0xa62c26[_0x18d4('0x1e')]>0x1;var _0x2104b2=[];if(!fs['existsSync'](path[_0x18d4('0x27')](_0x4355f8,_0x14722f))&&_0xd35410){fs[_0x18d4('0x28')](path[_0x18d4('0x27')](_0x4355f8,_0x14722f));}return BPromise[_0x18d4('0x29')](_0xa62c26,function(_0x5264c9){_0x2104b2[_0x18d4('0x22')](_0x5264c9);})[_0x18d4('0x15')](function(){for(var _0x3a32dd=0x0;_0x3a32dd<_0x2104b2[_0x18d4('0x1e')];_0x3a32dd+=0x1){var _0x7b8791;var _0x103f58=_0x2104b2[_0x3a32dd];if(_0xd35410){_0x7b8791=path[_0x18d4('0x27')](_0x4355f8,_0x14722f,util[_0x18d4('0x17')](_0x18d4('0x2a'),_0x14722f,_0x3a32dd,'xlsx'));}else{_0x7b8791=path['join'](_0x4355f8,util[_0x18d4('0x17')](_0x18d4('0x2b'),_0x14722f,_0x18d4('0x2c')));}fs[_0x18d4('0x2d')](_0x7b8791,json2xls(_0x103f58),'binary');}})[_0x18d4('0x15')](function(){if(_0xd35410){return new Promise(function(_0x5d7655){zipdir(path['join'](_0x4355f8,_0x14722f),{'saveTo':path[_0x18d4('0x27')](_0x4355f8,util[_0x18d4('0x17')]('%s.%s',_0x14722f,_0x18d4('0x2e')))},function(_0x4c9ac1,_0x937903){rimraf(path['join'](_0x4355f8,_0x14722f),function(){});_0x5d7655(_0x18d4('0x2f'));});});}})[_0x18d4('0x15')](function(){logger[_0x18d4('0xf')](util[_0x18d4('0x17')]('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x18d4('0x11')));return analyticExtractedReport('Completed',_0xd35410?util[_0x18d4('0x17')](_0x18d4('0x2b'),_0x14722f,_0xd35410?_0x18d4('0x2e'):'xlsx'):null);});})[_0x18d4('0x30')](function(_0x1a8244){logger[_0x18d4('0xf')](util[_0x18d4('0x17')](_0x18d4('0x31'),EXTRACTED_REPORT_ID,_0x18d4('0x11')),util[_0x18d4('0x32')](_0x1a8244,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport('Failed');})[_0x18d4('0x33')](function(){process[_0x18d4('0x34')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff