// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd561=['hasOwnProperty','isNumeric','match','^[0-9]*$','isEmail','getFullTextValue','forEach','push','join','split','filters','isEmpty','find','type','isPlainObject','format','utc','$lte','YYYY-MM-DD','subtract','isArray','parse','limit','offset','sort','map','indexOf','priority','cast','col','unsigned','substr','DESC','ASC','omit','length','isObject','unset'];(function(_0x5ac0f0,_0xee4d98){var _0x4aceec=function(_0x3a9044){while(--_0x3a9044){_0x5ac0f0['push'](_0x5ac0f0['shift']());}};_0x4aceec(++_0xee4d98);}(_0xd561,0xc7));var _0x1d56=function(_0x2e22e6,_0xf87db9){_0x2e22e6=_0x2e22e6-0x0;var _0x17eb32=_0xd561[_0x2e22e6];return _0x17eb32;};'use strict';var _=require('lodash');var sequelize=require('sequelize');var moment=require('moment');var LIMIT_VALUE=0xfa;exports['fields']=function(_0x2aad12){var _0x55fe14=null;if(_0x2aad12){_0x55fe14=_0x2aad12[_0x1d56('0x0')](',');}return _0x55fe14;};exports[_0x1d56('0x1')]=function(_0x2af6ba,_0x58dce5){var _0x2e4deb={};if(!_[_0x1d56('0x2')](_0x2af6ba)){_['forOwn'](_0x2af6ba,function(_0xfea21a,_0x33d591){try{if(_0x58dce5){var _0x424e82=_[_0x1d56('0x3')](_0x58dce5,{'name':_0x33d591})||{};if(_0x424e82[_0x1d56('0x4')]==='DATE'&&_[_0x1d56('0x5')](_0xfea21a)){var _0x9fc00d=JSON['parse'](_0xfea21a);var _0xd3382e={'$gte':moment(moment(_0x9fc00d['$gte'])[_0x1d56('0x6')]('YYYY-MM-DD'))[_0x1d56('0x7')]()[_0x1d56('0x6')](),'$lte':moment(moment(_0x9fc00d[_0x1d56('0x8')])['format'](_0x1d56('0x9')))[_0x1d56('0x7')]()[_0x1d56('0xa')](0x1,'s')[_0x1d56('0x6')]()};_0x2e4deb[_0x33d591]=_0xd3382e;}else{_0x2e4deb[_0x33d591]=_[_0x1d56('0xb')](_0xfea21a)?_0xfea21a:JSON[_0x1d56('0xc')](_0xfea21a);}}else{_0x2e4deb[_0x33d591]=_[_0x1d56('0xb')](_0xfea21a)?_0xfea21a:JSON[_0x1d56('0xc')](_0xfea21a);}}catch(_0x1c4f87){_0x2e4deb[_0x33d591]=_0xfea21a[_0x1d56('0x0')](',');}});}return _0x2e4deb;};exports[_0x1d56('0xd')]=function(_0x16e92e){_0x16e92e=parseInt(_0x16e92e,0xa);if(!_0x16e92e||_0x16e92e<0x0){_0x16e92e=LIMIT_VALUE;}return _0x16e92e;};exports[_0x1d56('0xe')]=function(_0x3d2633){_0x3d2633=parseInt(_0x3d2633,0xa);if(!_0x3d2633||_0x3d2633<0x0){_0x3d2633=0x0;}return _0x3d2633;};exports[_0x1d56('0xf')]=function(_0x5aa80c){var _0xf51c78,_0x5f51b0=null;if(_0x5aa80c){_0xf51c78=_0x5aa80c['split'](',');_0x5f51b0=_[_0x1d56('0x10')](_0xf51c78,function(_0x3cec3d){if(_0x3cec3d[_0x1d56('0x11')]('-')===0x0){return[_0x3cec3d===_0x1d56('0x12')?sequelize[_0x1d56('0x13')](sequelize[_0x1d56('0x14')]('priority'),_0x1d56('0x15')):_0x3cec3d[_0x1d56('0x16')](0x1),_0x1d56('0x17')];}else{return[_0x3cec3d==='priority'?sequelize[_0x1d56('0x13')](sequelize[_0x1d56('0x14')](_0x1d56('0x12')),_0x1d56('0x15')):_0x3cec3d,_0x1d56('0x18')];}});}return _0x5f51b0;};exports[_0x1d56('0x19')]=function(_0x4d171d,_0xa28d74){if(_[_0x1d56('0x2')](_0x4d171d)){return _0x4d171d;}if(_['isArray'](_0x4d171d)){for(var _0x21ef36=0x0;_0x21ef36<_0x4d171d[_0x1d56('0x1a')];_0x21ef36+=0x1){_0x4d171d[_0x21ef36]=this[_0x1d56('0x19')](_0x4d171d[_0x21ef36],_0xa28d74);}return _0x4d171d;}if(!_[_0x1d56('0x1b')](_0x4d171d)){return _0x4d171d;}if(_['isString'](_0xa28d74)){_0xa28d74=[_0xa28d74];}if(!_[_0x1d56('0xb')](_0xa28d74)){return _0x4d171d;}for(var _0x4c9d31=0x0;_0x4c9d31<_0xa28d74[_0x1d56('0x1a')];_0x4c9d31+=0x1){_[_0x1d56('0x1c')](_0x4d171d,_0xa28d74[_0x4c9d31]);}for(var _0x47a303 in _0x4d171d){if(_0x4d171d[_0x1d56('0x1d')](_0x47a303)){_0x4d171d[_0x47a303]=this[_0x1d56('0x19')](_0x4d171d[_0x47a303],_0xa28d74);}}return _0x4d171d;};exports[_0x1d56('0x1e')]=function(_0x5bcab4){return _0x5bcab4[_0x1d56('0x1f')](RegExp(_0x1d56('0x20')))?!![]:![];};exports[_0x1d56('0x21')]=function(_0x5d2532){return _0x5d2532[_0x1d56('0x1f')](/^\S+@\S+$/)?!![]:![];};exports[_0x1d56('0x22')]=function(_0x1eae55){var _0x38b580=[];_0x1eae55['split']('\x20')[_0x1d56('0x23')](function(_0x1f28b0){_0x38b580[_0x1d56('0x24')]('+'+_0x1f28b0['toString']()+'*');});return _0x38b580[_0x1d56('0x25')]('\x20');};
\ No newline at end of file
+var _0x5fa2=['subtract','name','uniqueid','isArray','offset','sort','map','indexOf','priority','cast','unsigned','col','ASC','omit','length','hasOwnProperty','isNumeric','match','isEmail','\x22{EXPR}\x22','{EXPR}','forEach','replace','push','join','getOptions','query','$id','intersection','attributes','limit','order','where','pick','filter','object','includes','columns','value','merge','VIRTUAL','lower','options','include','lodash','sequelize','moment','../../mysqldb','parse','keys','model','alias','fields','raw','split','filters','isEmpty','forOwn','find','type','isPlainObject','$gte','format','YYYY-MM-DD','$lte'];(function(_0x156b75,_0x2778d7){var _0x472179=function(_0x4fddb7){while(--_0x4fddb7){_0x156b75['push'](_0x156b75['shift']());}};_0x472179(++_0x2778d7);}(_0x5fa2,0x1b2));var _0x25fa=function(_0x52585d,_0x374045){_0x52585d=_0x52585d-0x0;var _0x40a190=_0x5fa2[_0x52585d];return _0x40a190;};'use strict';var _=require(_0x25fa('0x0'));var sequelize=require(_0x25fa('0x1'));var moment=require(_0x25fa('0x2'));var db=require(_0x25fa('0x3'))['db'];var LIMIT_VALUE=0xfa;function hasSequelizeOperator(_0x86535c){var _0xaa3d2c=['ne'];try{var _0x355e1a=JSON[_0x25fa('0x4')](_0x86535c);var _0x53b6d6=Object[_0x25fa('0x5')](_0x355e1a)[0x0];return _0xaa3d2c['includes'](_0x53b6d6);}catch(_0x20635e){return![];}}function getOperatorValue(_0x45cd7d){var _0x2d15c5=JSON[_0x25fa('0x4')](_0x45cd7d);var _0x439099=Object[_0x25fa('0x5')](_0x2d15c5)[0x0];var _0x4bd050=_0x2d15c5[_0x439099];return{['$'+_0x439099]:_0x4bd050};}function parseIncludeModel(_0xbca1c2){var _0x1560ef=JSON[_0x25fa('0x4')](_0xbca1c2);return{'model':db[_0x1560ef[_0x25fa('0x6')]],'as':_0x1560ef[_0x25fa('0x7')],'attributes':_0x1560ef[_0x25fa('0x8')],'raw':_0x1560ef[_0x25fa('0x9')]};}exports[_0x25fa('0x8')]=function(_0xf5168){var _0x313f18=null;if(_0xf5168){_0x313f18=_0xf5168[_0x25fa('0xa')](',');}return _0x313f18;};exports[_0x25fa('0xb')]=function(_0xee9876,_0x249297){var _0xd9a32e={};if(!_[_0x25fa('0xc')](_0xee9876)){_[_0x25fa('0xd')](_0xee9876,function(_0x4dbb40,_0x285917){try{if(_0x249297){var _0x46c8a9=_[_0x25fa('0xe')](_0x249297,{'name':_0x285917})||{};if(hasSequelizeOperator(_0x4dbb40)){_0xd9a32e[_0x285917]=getOperatorValue(_0x4dbb40);}else if(_0x46c8a9[_0x25fa('0xf')]==='DATE'&&_[_0x25fa('0x10')](_0x4dbb40)){var _0x2badab=JSON['parse'](_0x4dbb40);var _0xd09f4e={'$gte':moment(moment(_0x2badab[_0x25fa('0x11')])[_0x25fa('0x12')](_0x25fa('0x13')))['utc']()[_0x25fa('0x12')](),'$lte':moment(moment(_0x2badab[_0x25fa('0x14')])[_0x25fa('0x12')](_0x25fa('0x13')))['utc']()[_0x25fa('0x15')](0x1,'s')[_0x25fa('0x12')]()};_0xd9a32e[_0x285917]=_0xd09f4e;}else if(_0x46c8a9[_0x25fa('0x16')]===_0x25fa('0x17')){_0xd9a32e[_0x285917]=_0x4dbb40;}else{_0xd9a32e[_0x285917]=_['isArray'](_0x4dbb40)?_0x4dbb40:JSON['parse'](_0x4dbb40);}}else{_0xd9a32e[_0x285917]=_[_0x25fa('0x18')](_0x4dbb40)?_0x4dbb40:JSON[_0x25fa('0x4')](_0x4dbb40);}}catch(_0x2e16f0){_0xd9a32e[_0x285917]=_0x4dbb40[_0x25fa('0xa')](',');}});}return _0xd9a32e;};exports['limit']=function(_0x49b4f6){_0x49b4f6=parseInt(_0x49b4f6,0xa);if(!_0x49b4f6||_0x49b4f6<0x0){_0x49b4f6=LIMIT_VALUE;}return _0x49b4f6;};exports[_0x25fa('0x19')]=function(_0x299193){_0x299193=parseInt(_0x299193,0xa);if(!_0x299193||_0x299193<0x0){_0x299193=0x0;}return _0x299193;};exports[_0x25fa('0x1a')]=function(_0x2b82f1){var _0x19bc7,_0x1d31e1=null;if(_0x2b82f1){_0x19bc7=_0x2b82f1[_0x25fa('0xa')](',');_0x1d31e1=_[_0x25fa('0x1b')](_0x19bc7,function(_0x188929){if(_0x188929[_0x25fa('0x1c')]('-')===0x0){return[_0x188929===_0x25fa('0x1d')?sequelize[_0x25fa('0x1e')](sequelize['col'](_0x25fa('0x1d')),_0x25fa('0x1f')):_0x188929['substr'](0x1),'DESC'];}else{return[_0x188929===_0x25fa('0x1d')?sequelize[_0x25fa('0x1e')](sequelize[_0x25fa('0x20')](_0x25fa('0x1d')),'unsigned'):_0x188929,_0x25fa('0x21')];}});}return _0x1d31e1;};exports[_0x25fa('0x22')]=function(_0x4db885,_0x4a2e62){if(_[_0x25fa('0xc')](_0x4db885)){return _0x4db885;}if(_[_0x25fa('0x18')](_0x4db885)){for(var _0x1894ae=0x0;_0x1894ae<_0x4db885[_0x25fa('0x23')];_0x1894ae+=0x1){_0x4db885[_0x1894ae]=this[_0x25fa('0x22')](_0x4db885[_0x1894ae],_0x4a2e62);}return _0x4db885;}if(!_['isObject'](_0x4db885)){return _0x4db885;}if(_['isString'](_0x4a2e62)){_0x4a2e62=[_0x4a2e62];}if(!_['isArray'](_0x4a2e62)){return _0x4db885;}for(var _0xf2db70=0x0;_0xf2db70<_0x4a2e62['length'];_0xf2db70+=0x1){_['unset'](_0x4db885,_0x4a2e62[_0xf2db70]);}for(var _0x1e8775 in _0x4db885){if(_0x4db885[_0x25fa('0x24')](_0x1e8775)){_0x4db885[_0x1e8775]=this[_0x25fa('0x22')](_0x4db885[_0x1e8775],_0x4a2e62);}}return _0x4db885;};exports[_0x25fa('0x25')]=function(_0x1b9ad0){return _0x1b9ad0[_0x25fa('0x26')](RegExp('^[+]?[0-9]*$'))?!![]:![];};exports[_0x25fa('0x27')]=function(_0x372614){return _0x372614[_0x25fa('0x26')](/^\S+@\S+$/)?!![]:![];};exports['getFullTextValue']=function(_0x1d77a1,_0xc66d94){var _0x498619=[];var _0x107cff=/[ `!@#$%^&*()_\-?~]/;var _0x112b98=_0xc66d94?_0x25fa('0x28'):_0x25fa('0x29');_0x1d77a1[_0x25fa('0xa')](/[ ,]+/)[_0x25fa('0x2a')](function(_0x357843){_0x357843=_0x357843[_0x25fa('0x2b')](/([^:]")"+/g,'$1');_0x357843='+'+_0x357843+'*';var _0x3ae39b=_0x357843['match'](_0x107cff);if(_0x3ae39b){_0x357843='\x22'+_0x357843+'\x22';}_0x498619[_0x25fa('0x2c')](_0x357843);});_0x112b98=_0x112b98['replace'](_0x25fa('0x29'),_0x498619[_0x25fa('0x2d')]('\x20'));return _0x112b98;};exports[_0x25fa('0x2e')]=function(_0x3c40bc,_0x181a8f,_0x95579d){var _0x5a90c2={},_0x569e42={};if(_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x30')]){_0x181a8f[_0x25fa('0x2f')]['id']=_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x30')];delete _0x181a8f['query'][_0x25fa('0x30')];}_0x5a90c2[_0x25fa('0x6')]=_[_0x25fa('0x1b')](_0x3c40bc,'name');_0x5a90c2[_0x25fa('0x2f')]=_[_0x25fa('0x5')](_0x181a8f[_0x25fa('0x2f')]);_0x5a90c2[_0x25fa('0xb')]=_[_0x25fa('0x31')](_0x5a90c2[_0x25fa('0x6')],_0x5a90c2['query']);_0x569e42[_0x25fa('0x32')]=_[_0x25fa('0x31')](_0x5a90c2['model'],this[_0x25fa('0x8')](_0x181a8f[_0x25fa('0x2f')]['fields']));_0x569e42[_0x25fa('0x32')]=_0x569e42[_0x25fa('0x32')][_0x25fa('0x23')]?_0x569e42[_0x25fa('0x32')]:_0x5a90c2['model'];if(!_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x24')]('nolimit')){_0x569e42[_0x25fa('0x33')]=this[_0x25fa('0x33')](_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x33')]);_0x569e42[_0x25fa('0x19')]=this[_0x25fa('0x19')](_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x19')]);}_0x569e42[_0x25fa('0x34')]=this[_0x25fa('0x1a')](_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x1a')]);_0x569e42[_0x25fa('0x35')]=this[_0x25fa('0xb')](_[_0x25fa('0x36')](_0x181a8f[_0x25fa('0x2f')],_0x5a90c2['filters']),_0x3c40bc);if(_0x181a8f[_0x25fa('0x2f')]['filter']){var _0x331c4e=_0x3c40bc;var _0xd462a7=_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x37')];if(typeof _0xd462a7===_0x25fa('0x38')){_0x331c4e=_[_0x25fa('0x37')](_0x3c40bc,function(_0x54ee12){return _[_0x25fa('0x39')](_0xd462a7[_0x25fa('0x3a')],_0x54ee12['name']);});_0xd462a7=_0xd462a7[_0x25fa('0x3b')];}_0x569e42[_0x25fa('0x35')]=_[_0x25fa('0x3c')](_0x569e42['where'],{'$or':_[_0x25fa('0x1b')](_0x331c4e,function(_0x55bda4){if(_0x55bda4[_0x25fa('0xf')]!==_0x25fa('0x3d')){if(_0x95579d){return sequelize[_0x25fa('0x35')](sequelize['fn'](_0x25fa('0x3e'),sequelize[_0x25fa('0x20')](_0x55bda4[_0x25fa('0x16')])),{'$like':sequelize['fn'](_0x25fa('0x3e'),'%'+_0x181a8f[_0x25fa('0x2f')][_0x25fa('0x37')]+'%')});}else{var _0x4fcdfc={};_0x4fcdfc[_0x55bda4[_0x25fa('0x16')]]={'$like':'%'+_0x181a8f[_0x25fa('0x2f')]['filter']+'%'};return _0x4fcdfc;}}})});}_0x569e42=_[_0x25fa('0x3c')]({},_0x569e42,_0x181a8f[_0x25fa('0x3f')]);return _0x569e42;};exports[_0x25fa('0x40')]=function(_0x1f1935){var _0x5e4c50=[];if(_0x1f1935['includeAll']){_0x5e4c50['push']({'all':!![]});}else if(_0x1f1935[_0x25fa('0x40')]){if(Array[_0x25fa('0x18')](_0x1f1935[_0x25fa('0x40')])){_0x5e4c50=Object['keys'](_0x1f1935['include'])['map'](function(_0x21b3fa){return parseIncludeModel(_0x1f1935[_0x25fa('0x40')][_0x21b3fa]);});}else{var _0x9d610=parseIncludeModel(_0x1f1935[_0x25fa('0x40')]);_0x5e4c50[_0x25fa('0x2c')](_0x9d610);}}return _0x5e4c50;};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff