// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf1a2=['dirname','basename','.xlsx','join','mkdirSync','each','xlsx','%s.%s','writeFileSync','zip\x20finished','Completed','zip','catch','Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','inspect','Failed','util','path','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','../../config/logger','analytics','argv','savename','update','info','format','XLSX','Setting','find','split','splitSizeXlsx','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','SELECT','num','Empty','length','range','isInteger','push'];(function(_0x21a9d9,_0x4d5ac8){var _0x46adce=function(_0xfdd336){while(--_0xfdd336){_0x21a9d9['push'](_0x21a9d9['shift']());}};_0x46adce(++_0x4d5ac8);}(_0xf1a2,0x1f0));var _0x2f1a=function(_0x3624b2,_0x3d8b1e){_0x3624b2=_0x3624b2-0x0;var _0x299a02=_0xf1a2[_0x3624b2];return _0x299a02;};'use strict';var util=require(_0x2f1a('0x0'));var path=require(_0x2f1a('0x1'));var _=require(_0x2f1a('0x2'));var fs=require('fs');var json2xls=require(_0x2f1a('0x3'));var BPromise=require(_0x2f1a('0x4'));var zipdir=require(_0x2f1a('0x5'));var rimraf=require(_0x2f1a('0x6'));var db=require(_0x2f1a('0x7'))['db'];var dbH=require(_0x2f1a('0x7'))['dbH'];var logger=require(_0x2f1a('0x8'))(_0x2f1a('0x9'));var EXTRACTED_REPORT_ID=Number(process[_0x2f1a('0xa')][0x2]);var QUERY=process[_0x2f1a('0xa')][0x3];var PATH=process[_0x2f1a('0xa')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x460898,_0x50fa39){var _0x3fef11={'status':_0x460898};var _0x54d94c={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x50fa39){_0x3fef11[_0x2f1a('0xb')]=_0x50fa39;}return db['AnalyticExtractedReport'][_0x2f1a('0xc')](_0x3fef11,_0x54d94c);}function main(){var _0x14a6f5=0x1388;var _0x2dba44;logger[_0x2f1a('0xd')](util[_0x2f1a('0xe')]('Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x2f1a('0xf')));return db[_0x2f1a('0x10')][_0x2f1a('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x2f1a('0x12'),_0x2f1a('0x13')]})[_0x2f1a('0x14')](function(_0x1083e9){if(_0x1083e9){_0x2dba44=_0x1083e9;_0x14a6f5=_0x2dba44[_0x2f1a('0x13')]||0x1388;}})['then'](function(){return dbH[_0x2f1a('0x15')][_0x2f1a('0x16')](util[_0x2f1a('0xe')](_0x2f1a('0x17'),QUERY),{'type':dbH[_0x2f1a('0x15')][_0x2f1a('0x18')][_0x2f1a('0x19')]});})['then'](function(_0x458929){if(!_0x458929[0x0][_0x2f1a('0x1a')]){return analyticExtractedReport(_0x2f1a('0x1b'));}var _0x57467e=[];var _0x1b9787=0x0;if(_0x2dba44[_0x2f1a('0x12')]){if(_0x458929&&_0x458929[_0x2f1a('0x1c')]){var _0x6be30b=_[_0x2f1a('0x1d')](_0x458929[0x0][_0x2f1a('0x1a')]/_0x14a6f5);var _0x2cb7af=Number[_0x2f1a('0x1e')](_0x458929[0x0][_0x2f1a('0x1a')]/_0x14a6f5)?_0x458929[0x0][_0x2f1a('0x1a')]%_0x14a6f5:0x0;_0x6be30b['forEach'](function(_0x12f24e){if(_0x12f24e>0x0){_0x1b9787+=_0x14a6f5;}_0x57467e[_0x2f1a('0x1f')](dbH[_0x2f1a('0x15')]['query'](util[_0x2f1a('0xe')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x14a6f5,_0x1b9787),{'type':dbH[_0x2f1a('0x15')][_0x2f1a('0x18')][_0x2f1a('0x19')]}));});if(_0x2cb7af>0x0){_0x1b9787+=_0x14a6f5;_0x57467e[_0x2f1a('0x1f')](dbH['sequelize'][_0x2f1a('0x16')](util[_0x2f1a('0xe')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x2cb7af,_0x1b9787),{'type':dbH[_0x2f1a('0x15')]['QueryTypes']['SELECT']}));}}}else{_0x57467e[_0x2f1a('0x1f')](dbH[_0x2f1a('0x15')][_0x2f1a('0x16')](QUERY,{'type':dbH[_0x2f1a('0x15')]['QueryTypes']['SELECT']}));}var _0x4572ba=path[_0x2f1a('0x20')](PATH);var _0x2bf848=path[_0x2f1a('0x21')](PATH,_0x2f1a('0x22'));var _0x526d28=_0x2dba44[_0x2f1a('0x12')]&&_0x57467e['length']>0x1;var _0x182357=[];if(!fs['existsSync'](path[_0x2f1a('0x23')](_0x4572ba,_0x2bf848))&&_0x526d28){fs[_0x2f1a('0x24')](path['join'](_0x4572ba,_0x2bf848));}return BPromise[_0x2f1a('0x25')](_0x57467e,function(_0x3d3894){_0x182357['push'](_0x3d3894);})['then'](function(){for(var _0x2ab0ed=0x0;_0x2ab0ed<_0x182357[_0x2f1a('0x1c')];_0x2ab0ed+=0x1){var _0x22d28d;var _0x109a47=_0x182357[_0x2ab0ed];if(_0x526d28){_0x22d28d=path['join'](_0x4572ba,_0x2bf848,util[_0x2f1a('0xe')]('%s%d.%s',_0x2bf848,_0x2ab0ed,_0x2f1a('0x26')));}else{_0x22d28d=path[_0x2f1a('0x23')](_0x4572ba,util['format'](_0x2f1a('0x27'),_0x2bf848,_0x2f1a('0x26')));}fs[_0x2f1a('0x28')](_0x22d28d,json2xls(_0x109a47),'binary');}})[_0x2f1a('0x14')](function(){if(_0x526d28){return new Promise(function(_0x2cb525){zipdir(path[_0x2f1a('0x23')](_0x4572ba,_0x2bf848),{'saveTo':path[_0x2f1a('0x23')](_0x4572ba,util[_0x2f1a('0xe')]('%s.%s',_0x2bf848,'zip'))},function(_0x208664,_0x2b88c5){rimraf(path[_0x2f1a('0x23')](_0x4572ba,_0x2bf848),function(){});_0x2cb525(_0x2f1a('0x29'));});});}})[_0x2f1a('0x14')](function(){logger[_0x2f1a('0xd')](util['format']('Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed',EXTRACTED_REPORT_ID,_0x2f1a('0xf')));return analyticExtractedReport(_0x2f1a('0x2a'),_0x526d28?util[_0x2f1a('0xe')](_0x2f1a('0x27'),_0x2bf848,_0x526d28?_0x2f1a('0x2b'):_0x2f1a('0x26')):null);});})[_0x2f1a('0x2c')](function(_0x278c9a){logger[_0x2f1a('0xd')](util['format'](_0x2f1a('0x2d'),EXTRACTED_REPORT_ID,_0x2f1a('0xf')),util[_0x2f1a('0x2e')](_0x278c9a,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x2f1a('0x2f'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x8bd6=['length','isInteger','forEach','push','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','basename','.xlsx','existsSync','join','%s.%s','xlsx','writeFileSync','binary','zip','zip\x20finished','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','finally','exit','util','path','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','XLSX','find','split','splitSizeXlsx','then','sequelize','query','QueryTypes','num','Empty'];(function(_0x118e70,_0x5877f0){var _0x3226af=function(_0x203041){while(--_0x203041){_0x118e70['push'](_0x118e70['shift']());}};_0x3226af(++_0x5877f0);}(_0x8bd6,0x144));var _0x68bd=function(_0x479a84,_0x985e03){_0x479a84=_0x479a84-0x0;var _0xe5837a=_0x8bd6[_0x479a84];return _0xe5837a;};'use strict';var util=require(_0x68bd('0x0'));var path=require(_0x68bd('0x1'));var _=require(_0x68bd('0x2'));var fs=require('fs');var json2xls=require(_0x68bd('0x3'));var BPromise=require(_0x68bd('0x4'));var zipdir=require(_0x68bd('0x5'));var rimraf=require(_0x68bd('0x6'));var db=require(_0x68bd('0x7'))['db'];var dbH=require(_0x68bd('0x7'))[_0x68bd('0x8')];var logger=require(_0x68bd('0x9'))(_0x68bd('0xa'));var EXTRACTED_REPORT_ID=Number(process[_0x68bd('0xb')][0x2]);var QUERY=process[_0x68bd('0xb')][0x3];var PATH=process[_0x68bd('0xb')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0xd5c43,_0x4166c7){var _0x242c81={'status':_0xd5c43};var _0x5165a6={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x4166c7){_0x242c81['savename']=_0x4166c7;}return db['AnalyticExtractedReport'][_0x68bd('0xc')](_0x242c81,_0x5165a6);}function main(){var _0x4d6eac=0x1388;var _0x33b53f;logger[_0x68bd('0xd')](util[_0x68bd('0xe')](_0x68bd('0xf'),EXTRACTED_REPORT_ID,_0x68bd('0x10')));return db['Setting'][_0x68bd('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x68bd('0x12'),_0x68bd('0x13')]})[_0x68bd('0x14')](function(_0x266b78){if(_0x266b78){_0x33b53f=_0x266b78;_0x4d6eac=_0x33b53f[_0x68bd('0x13')]||0x1388;}})['then'](function(){return dbH[_0x68bd('0x15')][_0x68bd('0x16')](util[_0x68bd('0xe')]('SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t',QUERY),{'type':dbH[_0x68bd('0x15')][_0x68bd('0x17')]['SELECT']});})[_0x68bd('0x14')](function(_0x1c78ec){if(!_0x1c78ec[0x0][_0x68bd('0x18')]){return analyticExtractedReport(_0x68bd('0x19'));}var _0x437c=[];var _0x3013a3=0x0;if(_0x33b53f['split']){if(_0x1c78ec&&_0x1c78ec[_0x68bd('0x1a')]){var _0x47d994=_['range'](_0x1c78ec[0x0][_0x68bd('0x18')]/_0x4d6eac);var _0x4b25bf=Number[_0x68bd('0x1b')](_0x1c78ec[0x0][_0x68bd('0x18')]/_0x4d6eac)?_0x1c78ec[0x0]['num']%_0x4d6eac:0x0;_0x47d994[_0x68bd('0x1c')](function(_0x372a34){if(_0x372a34>0x0){_0x3013a3+=_0x4d6eac;}_0x437c[_0x68bd('0x1d')](dbH[_0x68bd('0x15')]['query'](util[_0x68bd('0xe')](_0x68bd('0x1e'),QUERY,_0x4d6eac,_0x3013a3),{'type':dbH[_0x68bd('0x15')][_0x68bd('0x17')][_0x68bd('0x1f')]}));});if(_0x4b25bf>0x0){_0x3013a3+=_0x4d6eac;_0x437c[_0x68bd('0x1d')](dbH[_0x68bd('0x15')]['query'](util[_0x68bd('0xe')](_0x68bd('0x1e'),QUERY,_0x4b25bf,_0x3013a3),{'type':dbH[_0x68bd('0x15')][_0x68bd('0x17')][_0x68bd('0x1f')]}));}}}else{_0x437c[_0x68bd('0x1d')](dbH[_0x68bd('0x15')]['query'](QUERY,{'type':dbH[_0x68bd('0x15')][_0x68bd('0x17')]['SELECT']}));}var _0x34d67d=path['dirname'](PATH);var _0x4c0362=path[_0x68bd('0x20')](PATH,_0x68bd('0x21'));var _0x2ec2e9=_0x33b53f['split']&&_0x437c[_0x68bd('0x1a')]>0x1;var _0x48566d=[];if(!fs[_0x68bd('0x22')](path[_0x68bd('0x23')](_0x34d67d,_0x4c0362))&&_0x2ec2e9){fs['mkdirSync'](path[_0x68bd('0x23')](_0x34d67d,_0x4c0362));}return BPromise['each'](_0x437c,function(_0x2cc7e6){_0x48566d['push'](_0x2cc7e6);})[_0x68bd('0x14')](function(){for(var _0x182b50=0x0;_0x182b50<_0x48566d[_0x68bd('0x1a')];_0x182b50+=0x1){var _0x63f96a;var _0x35b449=_0x48566d[_0x182b50];if(_0x2ec2e9){_0x63f96a=path[_0x68bd('0x23')](_0x34d67d,_0x4c0362,util[_0x68bd('0xe')]('%s%d.%s',_0x4c0362,_0x182b50,'xlsx'));}else{_0x63f96a=path[_0x68bd('0x23')](_0x34d67d,util[_0x68bd('0xe')](_0x68bd('0x24'),_0x4c0362,_0x68bd('0x25')));}fs[_0x68bd('0x26')](_0x63f96a,json2xls(_0x35b449),_0x68bd('0x27'));}})[_0x68bd('0x14')](function(){if(_0x2ec2e9){return new Promise(function(_0x5adc2b){zipdir(path[_0x68bd('0x23')](_0x34d67d,_0x4c0362),{'saveTo':path[_0x68bd('0x23')](_0x34d67d,util['format'](_0x68bd('0x24'),_0x4c0362,_0x68bd('0x28')))},function(_0x314ac5,_0x5a4444){rimraf(path[_0x68bd('0x23')](_0x34d67d,_0x4c0362),function(){});_0x5adc2b(_0x68bd('0x29'));});});}})[_0x68bd('0x14')](function(){logger[_0x68bd('0xd')](util[_0x68bd('0xe')](_0x68bd('0x2a'),EXTRACTED_REPORT_ID,_0x68bd('0x10')));return analyticExtractedReport(_0x68bd('0x2b'),_0x2ec2e9?util[_0x68bd('0xe')]('%s.%s',_0x4c0362,_0x2ec2e9?_0x68bd('0x28'):_0x68bd('0x25')):null);});})[_0x68bd('0x2c')](function(_0x4f49a6){logger[_0x68bd('0xd')](util['format'](_0x68bd('0x2d'),EXTRACTED_REPORT_ID,_0x68bd('0x10')),util[_0x68bd('0x2e')](_0x4f49a6,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x68bd('0x2f'));})[_0x68bd('0x30')](function(){process[_0x68bd('0x31')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff