// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x0841=['format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','Empty','length','num','push','query','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','dirname','basename','.xlsx','existsSync','join','mkdirSync','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','Completed','zip','catch','error','path','lodash','bluebird','rimraf','../../mysqldb','dbH','argv','savename','AnalyticExtractedReport','update','Setting','find','split','splitSizeXlsx','then'];(function(_0x1b6563,_0x3bf0f1){var _0xdea7b8=function(_0x49e6c6){while(--_0x49e6c6){_0x1b6563['push'](_0x1b6563['shift']());}};_0xdea7b8(++_0x3bf0f1);}(_0x0841,0x6f));var _0x1084=function(_0x135332,_0x464ba3){_0x135332=_0x135332-0x0;var _0x2d0b6e=_0x0841[_0x135332];return _0x2d0b6e;};'use strict';var util=require('util');var path=require(_0x1084('0x0'));var _=require(_0x1084('0x1'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0x1084('0x2'));var zipdir=require('zip-dir');var rimraf=require(_0x1084('0x3'));var db=require(_0x1084('0x4'))['db'];var dbH=require('../../mysqldb')[_0x1084('0x5')];var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x1084('0x6')][0x4];function analyticExtractedReport(_0x204972,_0x441e04){var _0x5d24a5={'status':_0x204972};var _0x5cae15={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x441e04){_0x5d24a5[_0x1084('0x7')]=_0x441e04;}return db[_0x1084('0x8')][_0x1084('0x9')](_0x5d24a5,_0x5cae15);}function main(){var _0x5893da=0x1388;var _0xa56e19;return db[_0x1084('0xa')][_0x1084('0xb')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x1084('0xc'),_0x1084('0xd')]})[_0x1084('0xe')](function(_0x1904ec){if(_0x1904ec){_0xa56e19=_0x1904ec;_0x5893da=_0xa56e19[_0x1084('0xd')]||0x1388;}})[_0x1084('0xe')](function(){return dbH['sequelize']['query'](util[_0x1084('0xf')](_0x1084('0x10'),QUERY),{'type':dbH[_0x1084('0x11')]['QueryTypes']['SELECT']});})[_0x1084('0xe')](function(_0x530490){if(!_0x530490[0x0]['num']){return analyticExtractedReport(_0x1084('0x12'));}var _0x36b9f8=[];var _0x593b2b=0x0;var _0x1e6244=!![];if(_0xa56e19[_0x1084('0xc')]){if(_0x530490&&_0x530490[_0x1084('0x13')]){var _0x1b69a4=_0x530490[0x0][_0x1084('0x14')]%(_0x593b2b+_0x5893da);for(;_0x1e6244;_0x593b2b+=_0x5893da,_0x1b69a4=_0x530490[0x0][_0x1084('0x14')]%(_0x593b2b+_0x5893da)){if(_0x1b69a4==0x0||_0x1b69a4==_0x530490[0x0]['num']){_0x1e6244=![];}_0x36b9f8[_0x1084('0x15')](dbH[_0x1084('0x11')][_0x1084('0x16')](util[_0x1084('0xf')](_0x1084('0x17'),QUERY,_0x5893da,_0x593b2b),{'type':dbH[_0x1084('0x11')][_0x1084('0x18')]['SELECT']}));}}}else{_0x36b9f8[_0x1084('0x15')](dbH[_0x1084('0x11')][_0x1084('0x16')](QUERY,{'type':dbH[_0x1084('0x11')][_0x1084('0x18')][_0x1084('0x19')]}));}var _0x44d0a9=path[_0x1084('0x1a')](PATH);var _0x53976b=path[_0x1084('0x1b')](PATH,_0x1084('0x1c'));var _0x55d684=_0xa56e19[_0x1084('0xc')]&&_0x36b9f8[_0x1084('0x13')]>0x1;var _0x20e87f=[];if(!fs[_0x1084('0x1d')](path[_0x1084('0x1e')](_0x44d0a9,_0x53976b))&&_0x55d684){fs[_0x1084('0x1f')](path[_0x1084('0x1e')](_0x44d0a9,_0x53976b));}return BPromise[_0x1084('0x20')](_0x36b9f8,function(_0x32b4ee){_0x20e87f['push'](_0x32b4ee);})[_0x1084('0xe')](function(){for(var _0x4babe7=0x0;_0x4babe7<_0x20e87f['length'];_0x4babe7+=0x1){var _0x5e4c62;var _0x1d8e91=_0x20e87f[_0x4babe7];if(_0x55d684){_0x5e4c62=path[_0x1084('0x1e')](_0x44d0a9,_0x53976b,util[_0x1084('0xf')](_0x1084('0x21'),_0x53976b,_0x4babe7,_0x1084('0x22')));}else{_0x5e4c62=path[_0x1084('0x1e')](_0x44d0a9,util[_0x1084('0xf')](_0x1084('0x23'),_0x53976b,_0x1084('0x22')));}fs[_0x1084('0x24')](_0x5e4c62,json2xls(_0x1d8e91),_0x1084('0x25'));}})[_0x1084('0xe')](function(){if(_0x55d684){zipdir(path[_0x1084('0x1e')](_0x44d0a9,_0x53976b),{'saveTo':path[_0x1084('0x1e')](_0x44d0a9,util['format'](_0x1084('0x23'),_0x53976b,'zip'))},function(_0xa9d9ec,_0x35a11){});rimraf(path[_0x1084('0x1e')](_0x44d0a9,_0x53976b),function(){});}})[_0x1084('0xe')](function(){return analyticExtractedReport(_0x1084('0x26'),_0x55d684?util[_0x1084('0xf')](_0x1084('0x23'),_0x53976b,_0x55d684?_0x1084('0x27'):'xlsx'):null);});})[_0x1084('0x28')](function(_0x509f67){console[_0x1084('0x29')](_0x509f67);return analyticExtractedReport('Error');});}main();
\ No newline at end of file
+var _0xc5e4=['catch','error','Error','util','path','lodash','json2xls','bluebird','zip-dir','rimraf','../../mysqldb','argv','savename','Setting','find','splitSizeXlsx','then','query','format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','QueryTypes','SELECT','num','Empty','split','length','push','%s\x20limit\x20%d\x20OFFSET\x20%d','basename','existsSync','join','%s%d.%s','xlsx','writeFileSync','binary','%s.%s','zip','Completed'];(function(_0x52684f,_0xff73fc){var _0x4a55f0=function(_0x8ce37c){while(--_0x8ce37c){_0x52684f['push'](_0x52684f['shift']());}};_0x4a55f0(++_0xff73fc);}(_0xc5e4,0x189));var _0x4c5e=function(_0x2641f9,_0x26715f){_0x2641f9=_0x2641f9-0x0;var _0x585741=_0xc5e4[_0x2641f9];return _0x585741;};'use strict';var util=require(_0x4c5e('0x0'));var path=require(_0x4c5e('0x1'));var _=require(_0x4c5e('0x2'));var fs=require('fs');var json2xls=require(_0x4c5e('0x3'));var BPromise=require(_0x4c5e('0x4'));var zipdir=require(_0x4c5e('0x5'));var rimraf=require(_0x4c5e('0x6'));var db=require(_0x4c5e('0x7'))['db'];var dbH=require(_0x4c5e('0x7'))['dbH'];var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process[_0x4c5e('0x8')][0x3];var PATH=process[_0x4c5e('0x8')][0x4];function analyticExtractedReport(_0xaddf9e,_0x365a7d){var _0x1f8042={'status':_0xaddf9e};var _0x3b33d6={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x365a7d){_0x1f8042[_0x4c5e('0x9')]=_0x365a7d;}return db['AnalyticExtractedReport']['update'](_0x1f8042,_0x3b33d6);}function main(){var _0x4a69af=0x1388;var _0x32fde4;return db[_0x4c5e('0xa')][_0x4c5e('0xb')]({'where':{'id':0x1},'raw':!![],'attributes':['id','split',_0x4c5e('0xc')]})[_0x4c5e('0xd')](function(_0x2b1311){if(_0x2b1311){_0x32fde4=_0x2b1311;_0x4a69af=_0x32fde4['splitSizeXlsx']||0x1388;}})[_0x4c5e('0xd')](function(){return dbH['sequelize'][_0x4c5e('0xe')](util[_0x4c5e('0xf')](_0x4c5e('0x10'),QUERY),{'type':dbH[_0x4c5e('0x11')][_0x4c5e('0x12')][_0x4c5e('0x13')]});})[_0x4c5e('0xd')](function(_0x2180e2){if(!_0x2180e2[0x0][_0x4c5e('0x14')]){return analyticExtractedReport(_0x4c5e('0x15'));}var _0xb2cfd5=[];var _0xf2c3e0=0x0;var _0x567c77=!![];if(_0x32fde4[_0x4c5e('0x16')]){if(_0x2180e2&&_0x2180e2[_0x4c5e('0x17')]){var _0x89621c=_0x2180e2[0x0][_0x4c5e('0x14')]%(_0xf2c3e0+_0x4a69af);for(;_0x567c77;_0xf2c3e0+=_0x4a69af,_0x89621c=_0x2180e2[0x0]['num']%(_0xf2c3e0+_0x4a69af)){if(_0x89621c==0x0||_0x89621c==_0x2180e2[0x0][_0x4c5e('0x14')]){_0x567c77=![];}_0xb2cfd5[_0x4c5e('0x18')](dbH[_0x4c5e('0x11')][_0x4c5e('0xe')](util[_0x4c5e('0xf')](_0x4c5e('0x19'),QUERY,_0x4a69af,_0xf2c3e0),{'type':dbH[_0x4c5e('0x11')][_0x4c5e('0x12')][_0x4c5e('0x13')]}));}}}else{_0xb2cfd5[_0x4c5e('0x18')](dbH[_0x4c5e('0x11')]['query'](QUERY,{'type':dbH[_0x4c5e('0x11')][_0x4c5e('0x12')][_0x4c5e('0x13')]}));}var _0x3ddfcf=path['dirname'](PATH);var _0x5a1370=path[_0x4c5e('0x1a')](PATH,'.xlsx');var _0x2d63f9=_0x32fde4['split']&&_0xb2cfd5[_0x4c5e('0x17')]>0x1;var _0xf65456=[];if(!fs[_0x4c5e('0x1b')](path[_0x4c5e('0x1c')](_0x3ddfcf,_0x5a1370))&&_0x2d63f9){fs['mkdirSync'](path[_0x4c5e('0x1c')](_0x3ddfcf,_0x5a1370));}return BPromise['each'](_0xb2cfd5,function(_0x2d4ba7){_0xf65456[_0x4c5e('0x18')](_0x2d4ba7);})[_0x4c5e('0xd')](function(){for(var _0x3d8c87=0x0;_0x3d8c87<_0xf65456[_0x4c5e('0x17')];_0x3d8c87+=0x1){var _0x3b87de;var _0x469e79=_0xf65456[_0x3d8c87];if(_0x2d63f9){_0x3b87de=path[_0x4c5e('0x1c')](_0x3ddfcf,_0x5a1370,util[_0x4c5e('0xf')](_0x4c5e('0x1d'),_0x5a1370,_0x3d8c87,_0x4c5e('0x1e')));}else{_0x3b87de=path['join'](_0x3ddfcf,util['format']('%s.%s',_0x5a1370,_0x4c5e('0x1e')));}fs[_0x4c5e('0x1f')](_0x3b87de,json2xls(_0x469e79),_0x4c5e('0x20'));}})[_0x4c5e('0xd')](function(){if(_0x2d63f9){zipdir(path[_0x4c5e('0x1c')](_0x3ddfcf,_0x5a1370),{'saveTo':path[_0x4c5e('0x1c')](_0x3ddfcf,util[_0x4c5e('0xf')](_0x4c5e('0x21'),_0x5a1370,_0x4c5e('0x22')))},function(_0x1d1456,_0x24db7b){});rimraf(path[_0x4c5e('0x1c')](_0x3ddfcf,_0x5a1370),function(){});}})[_0x4c5e('0xd')](function(){return analyticExtractedReport(_0x4c5e('0x23'),_0x2d63f9?util[_0x4c5e('0xf')]('%s.%s',_0x5a1370,_0x2d63f9?_0x4c5e('0x22'):_0x4c5e('0x1e')):null);});})[_0x4c5e('0x24')](function(_0xf0ac4){console[_0x4c5e('0x25')](_0xf0ac4);return analyticExtractedReport(_0x4c5e('0x26'));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff