// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa7a4=['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','CSV','inspect','Failed','util','path','lodash','to-csv','bluebird','zip-dir','rimraf','../../mysqldb','dbH','../../config/logger','analytics','argv','update','info','format','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','Setting','find','split','splitSizeCsv','then','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','length','range','isInteger','%s\x20limit\x20%d\x20OFFSET\x20%d','SELECT','push','dirname','basename','.csv','existsSync','join','mkdirSync','each','%s%d.%s','csv','%s.%s','writeFileSync'];(function(_0x3bcc46,_0x3dc099){var _0x481cc3=function(_0x173bb2){while(--_0x173bb2){_0x3bcc46['push'](_0x3bcc46['shift']());}};_0x481cc3(++_0x3dc099);}(_0xa7a4,0x1a8));var _0x4a7a=function(_0x296754,_0x5befe9){_0x296754=_0x296754-0x0;var _0x1d9f1d=_0xa7a4[_0x296754];return _0x1d9f1d;};'use strict';var util=require(_0x4a7a('0x0'));var path=require(_0x4a7a('0x1'));var _=require(_0x4a7a('0x2'));var csv=require(_0x4a7a('0x3'));var fs=require('fs');var BPromise=require(_0x4a7a('0x4'));var zipdir=require(_0x4a7a('0x5'));var rimraf=require(_0x4a7a('0x6'));var db=require('../../mysqldb')['db'];var dbH=require(_0x4a7a('0x7'))[_0x4a7a('0x8')];var logger=require(_0x4a7a('0x9'))(_0x4a7a('0xa'));var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x4a7a('0xb')][0x3];var PATH=process[_0x4a7a('0xb')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x4cdab7,_0x1cb7d1){var _0x895c09={'status':_0x4cdab7};var _0x395df9={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x1cb7d1){_0x895c09['savename']=_0x1cb7d1;}return db['AnalyticExtractedReport'][_0x4a7a('0xc')](_0x895c09,_0x395df9);}function main(){var _0x2d6f81=0x1388;var _0x17ee43;logger[_0x4a7a('0xd')](util[_0x4a7a('0xe')](_0x4a7a('0xf'),EXTRACTED_REPORT_ID,'CSV'));return db[_0x4a7a('0x10')][_0x4a7a('0x11')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x4a7a('0x12'),_0x4a7a('0x13')]})[_0x4a7a('0x14')](function(_0x1ebb03){if(_0x1ebb03){_0x17ee43=_0x1ebb03;_0x2d6f81=_0x17ee43[_0x4a7a('0x13')]||0x1388;}})['then'](function(){return dbH[_0x4a7a('0x15')][_0x4a7a('0x16')](util['format'](_0x4a7a('0x17'),QUERY),{'type':dbH[_0x4a7a('0x15')][_0x4a7a('0x18')]['SELECT']});})[_0x4a7a('0x14')](function(_0x18db6f){if(!_0x18db6f[0x0][_0x4a7a('0x19')]){return analyticExtractedReport(_0x4a7a('0x1a'));}var _0x7e8567=[];var _0x58afdb=0x0;if(_0x17ee43['split']){if(_0x18db6f&&_0x18db6f[_0x4a7a('0x1b')]){var _0x175ff1=_[_0x4a7a('0x1c')](_0x18db6f[0x0]['num']/_0x2d6f81);var _0x491377=Number[_0x4a7a('0x1d')](_0x18db6f[0x0][_0x4a7a('0x19')]/_0x2d6f81)?_0x18db6f[0x0]['num']%_0x2d6f81:0x0;_0x175ff1['forEach'](function(_0x4402b8){if(_0x4402b8>0x0){_0x58afdb+=_0x2d6f81;}_0x7e8567['push'](dbH[_0x4a7a('0x15')]['query'](util[_0x4a7a('0xe')](_0x4a7a('0x1e'),QUERY,_0x2d6f81,_0x58afdb),{'type':dbH[_0x4a7a('0x15')][_0x4a7a('0x18')][_0x4a7a('0x1f')]}));});if(_0x491377>0x0){_0x58afdb+=_0x2d6f81;_0x7e8567[_0x4a7a('0x20')](dbH[_0x4a7a('0x15')]['query'](util[_0x4a7a('0xe')](_0x4a7a('0x1e'),QUERY,_0x491377,_0x58afdb),{'type':dbH[_0x4a7a('0x15')][_0x4a7a('0x18')]['SELECT']}));}}}else{_0x7e8567[_0x4a7a('0x20')](dbH[_0x4a7a('0x15')]['query'](QUERY,{'type':dbH['sequelize'][_0x4a7a('0x18')][_0x4a7a('0x1f')]}));}var _0x3d9bf4=path[_0x4a7a('0x21')](PATH);var _0x3825a9=path[_0x4a7a('0x22')](PATH,_0x4a7a('0x23'));var _0x1242bf=_0x17ee43['split']&&_0x7e8567[_0x4a7a('0x1b')]>0x1;var _0x5c5cd2=[];if(!fs[_0x4a7a('0x24')](path[_0x4a7a('0x25')](_0x3d9bf4,_0x3825a9))&&_0x1242bf){fs[_0x4a7a('0x26')](path['join'](_0x3d9bf4,_0x3825a9));}return BPromise[_0x4a7a('0x27')](_0x7e8567,function(_0x228728){_0x5c5cd2[_0x4a7a('0x20')](_0x228728);})['then'](function(){for(var _0x5c900b=0x0;_0x5c900b<_0x5c5cd2[_0x4a7a('0x1b')];_0x5c900b+=0x1){var _0x3b2066;var _0x46ab3b=_0x5c5cd2[_0x5c900b];if(_0x1242bf){_0x3b2066=path[_0x4a7a('0x25')](_0x3d9bf4,_0x3825a9,util[_0x4a7a('0xe')](_0x4a7a('0x28'),_0x3825a9,_0x5c900b,_0x4a7a('0x29')));}else{_0x3b2066=path[_0x4a7a('0x25')](_0x3d9bf4,util[_0x4a7a('0xe')](_0x4a7a('0x2a'),_0x3825a9,'csv'));}fs[_0x4a7a('0x2b')](_0x3b2066,csv(_0x46ab3b));}})['then'](function(){if(_0x1242bf){return new Promise(function(_0x107034){zipdir(path[_0x4a7a('0x25')](_0x3d9bf4,_0x3825a9),{'saveTo':path[_0x4a7a('0x25')](_0x3d9bf4,util[_0x4a7a('0xe')](_0x4a7a('0x2a'),_0x3825a9,_0x4a7a('0x2c')))},function(_0xcf2a8b,_0x303264){rimraf(path[_0x4a7a('0x25')](_0x3d9bf4,_0x3825a9),function(){});_0x107034('zip\x20finished');});});}})[_0x4a7a('0x14')](function(){logger[_0x4a7a('0xd')](util['format'](_0x4a7a('0x2d'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport(_0x4a7a('0x2e'),_0x1242bf?util[_0x4a7a('0xe')]('%s.%s',_0x3825a9,_0x1242bf?'zip':'csv'):null);});})[_0x4a7a('0x2f')](function(_0x44bdf6){logger[_0x4a7a('0xd')](util['format'](_0x4a7a('0x30'),EXTRACTED_REPORT_ID,_0x4a7a('0x31')),util[_0x4a7a('0x32')](_0x44bdf6,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x4a7a('0x33'));})['finally'](function(){process['exit'](EXIT_CODE);});}main();
\ No newline at end of file
+var _0x0742=['SELECT','dirname','basename','.csv','join','mkdirSync','each','csv','%s.%s','writeFileSync','zip\x20finished','Extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format\x20completed','catch','inspect','Failed','exit','util','path','to-csv','bluebird','zip-dir','rimraf','../../mysqldb','dbH','analytics','argv','AnalyticExtractedReport','info','Start\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format','CSV','Setting','find','split','then','splitSizeCsv','sequelize','query','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','QueryTypes','num','Empty','length','range','isInteger','forEach','push','format','%s\x20limit\x20%d\x20OFFSET\x20%d'];(function(_0x3ebfa0,_0x4b3209){var _0x28908f=function(_0x4d9002){while(--_0x4d9002){_0x3ebfa0['push'](_0x3ebfa0['shift']());}};_0x28908f(++_0x4b3209);}(_0x0742,0x190));var _0x2074=function(_0x581f8e,_0x5617cb){_0x581f8e=_0x581f8e-0x0;var _0x18aec=_0x0742[_0x581f8e];return _0x18aec;};'use strict';var util=require(_0x2074('0x0'));var path=require(_0x2074('0x1'));var _=require('lodash');var csv=require(_0x2074('0x2'));var fs=require('fs');var BPromise=require(_0x2074('0x3'));var zipdir=require(_0x2074('0x4'));var rimraf=require(_0x2074('0x5'));var db=require(_0x2074('0x6'))['db'];var dbH=require(_0x2074('0x6'))[_0x2074('0x7')];var logger=require('../../config/logger')(_0x2074('0x8'));var EXTRACTED_REPORT_ID=Number(process[_0x2074('0x9')][0x2]);var QUERY=process[_0x2074('0x9')][0x3];var PATH=process[_0x2074('0x9')][0x4];var EXIT_CODE=0x0;function analyticExtractedReport(_0x230a6c,_0x2e5197){var _0x1ded0f={'status':_0x230a6c};var _0x56180e={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x2e5197){_0x1ded0f['savename']=_0x2e5197;}return db[_0x2074('0xa')]['update'](_0x1ded0f,_0x56180e);}function main(){var _0x3f41e2=0x1388;var _0x23a31d;logger[_0x2074('0xb')](util['format'](_0x2074('0xc'),EXTRACTED_REPORT_ID,_0x2074('0xd')));return db[_0x2074('0xe')][_0x2074('0xf')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x2074('0x10'),'splitSizeCsv']})[_0x2074('0x11')](function(_0x3eb249){if(_0x3eb249){_0x23a31d=_0x3eb249;_0x3f41e2=_0x23a31d[_0x2074('0x12')]||0x1388;}})[_0x2074('0x11')](function(){return dbH[_0x2074('0x13')][_0x2074('0x14')](util['format'](_0x2074('0x15'),QUERY),{'type':dbH[_0x2074('0x13')][_0x2074('0x16')]['SELECT']});})[_0x2074('0x11')](function(_0x1e31e1){if(!_0x1e31e1[0x0][_0x2074('0x17')]){return analyticExtractedReport(_0x2074('0x18'));}var _0x1becdd=[];var _0x45b908=0x0;if(_0x23a31d[_0x2074('0x10')]){if(_0x1e31e1&&_0x1e31e1[_0x2074('0x19')]){var _0x2c788d=_[_0x2074('0x1a')](_0x1e31e1[0x0][_0x2074('0x17')]/_0x3f41e2);var _0x19d3ca=Number[_0x2074('0x1b')](_0x1e31e1[0x0][_0x2074('0x17')]/_0x3f41e2)?_0x1e31e1[0x0][_0x2074('0x17')]%_0x3f41e2:0x0;_0x2c788d[_0x2074('0x1c')](function(_0x163c44){if(_0x163c44>0x0){_0x45b908+=_0x3f41e2;}_0x1becdd[_0x2074('0x1d')](dbH[_0x2074('0x13')]['query'](util[_0x2074('0x1e')]('%s\x20limit\x20%d\x20OFFSET\x20%d',QUERY,_0x3f41e2,_0x45b908),{'type':dbH[_0x2074('0x13')]['QueryTypes']['SELECT']}));});if(_0x19d3ca>0x0){_0x45b908+=_0x3f41e2;_0x1becdd[_0x2074('0x1d')](dbH['sequelize'][_0x2074('0x14')](util['format'](_0x2074('0x1f'),QUERY,_0x19d3ca,_0x45b908),{'type':dbH[_0x2074('0x13')][_0x2074('0x16')][_0x2074('0x20')]}));}}}else{_0x1becdd['push'](dbH['sequelize'][_0x2074('0x14')](QUERY,{'type':dbH[_0x2074('0x13')][_0x2074('0x16')][_0x2074('0x20')]}));}var _0x10e369=path[_0x2074('0x21')](PATH);var _0x3a8c69=path[_0x2074('0x22')](PATH,_0x2074('0x23'));var _0x342393=_0x23a31d[_0x2074('0x10')]&&_0x1becdd[_0x2074('0x19')]>0x1;var _0x3d9931=[];if(!fs['existsSync'](path[_0x2074('0x24')](_0x10e369,_0x3a8c69))&&_0x342393){fs[_0x2074('0x25')](path[_0x2074('0x24')](_0x10e369,_0x3a8c69));}return BPromise[_0x2074('0x26')](_0x1becdd,function(_0x435011){_0x3d9931[_0x2074('0x1d')](_0x435011);})[_0x2074('0x11')](function(){for(var _0x1ea100=0x0;_0x1ea100<_0x3d9931['length'];_0x1ea100+=0x1){var _0x2d3222;var _0x357338=_0x3d9931[_0x1ea100];if(_0x342393){_0x2d3222=path[_0x2074('0x24')](_0x10e369,_0x3a8c69,util[_0x2074('0x1e')]('%s%d.%s',_0x3a8c69,_0x1ea100,_0x2074('0x27')));}else{_0x2d3222=path[_0x2074('0x24')](_0x10e369,util[_0x2074('0x1e')](_0x2074('0x28'),_0x3a8c69,_0x2074('0x27')));}fs[_0x2074('0x29')](_0x2d3222,csv(_0x357338));}})[_0x2074('0x11')](function(){if(_0x342393){return new Promise(function(_0x2cb920){zipdir(path[_0x2074('0x24')](_0x10e369,_0x3a8c69),{'saveTo':path[_0x2074('0x24')](_0x10e369,util[_0x2074('0x1e')](_0x2074('0x28'),_0x3a8c69,'zip'))},function(_0x196d62,_0x489572){rimraf(path[_0x2074('0x24')](_0x10e369,_0x3a8c69),function(){});_0x2cb920(_0x2074('0x2a'));});});}})[_0x2074('0x11')](function(){logger['info'](util[_0x2074('0x1e')](_0x2074('0x2b'),EXTRACTED_REPORT_ID,'CSV'));return analyticExtractedReport('Completed',_0x342393?util[_0x2074('0x1e')]('%s.%s',_0x3a8c69,_0x342393?'zip':_0x2074('0x27')):null);});})[_0x2074('0x2c')](function(_0x57ab43){logger[_0x2074('0xb')](util[_0x2074('0x1e')]('Error\x20during\x20extraction\x20report\x20with\x20id\x20%d\x20in\x20%s\x20format',EXTRACTED_REPORT_ID,_0x2074('0xd')),util[_0x2074('0x2d')](_0x57ab43,{'showHidden':![],'depth':null}));EXIT_CODE=0x1;return analyticExtractedReport(_0x2074('0x2e'));})['finally'](function(){process[_0x2074('0x2f')](EXIT_CODE);});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff