// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x9836=['isEmpty','type','parse','format','YYYY-MM-DD','utc','subtract','name','isArray','limit','offset','sort','map','indexOf','cast','col','priority','unsigned','substr','ASC','omit','length','isObject','isString','unset','hasOwnProperty','match','^[+]?[0-9]*$','getFullTextValue','forEach','push','join','lodash','sequelize','moment','split','filters'];(function(_0x28c4db,_0x2ccd05){var _0x5907ed=function(_0x1d83c2){while(--_0x1d83c2){_0x28c4db['push'](_0x28c4db['shift']());}};_0x5907ed(++_0x2ccd05);}(_0x9836,0x148));var _0x6983=function(_0x40a4ee,_0x515400){_0x40a4ee=_0x40a4ee-0x0;var _0x57c3cc=_0x9836[_0x40a4ee];return _0x57c3cc;};'use strict';var _=require(_0x6983('0x0'));var sequelize=require(_0x6983('0x1'));var moment=require(_0x6983('0x2'));var LIMIT_VALUE=0xfa;exports['fields']=function(_0x9df38c){var _0x39dc7d=null;if(_0x9df38c){_0x39dc7d=_0x9df38c[_0x6983('0x3')](',');}return _0x39dc7d;};exports[_0x6983('0x4')]=function(_0x3d0fb4,_0x35c5bb){var _0x8ec6da={};if(!_[_0x6983('0x5')](_0x3d0fb4)){_['forOwn'](_0x3d0fb4,function(_0x4e2c5f,_0x3fba19){try{if(_0x35c5bb){var _0xcc67fe=_['find'](_0x35c5bb,{'name':_0x3fba19})||{};if(_0xcc67fe[_0x6983('0x6')]==='DATE'&&_['isPlainObject'](_0x4e2c5f)){var _0x1e6762=JSON[_0x6983('0x7')](_0x4e2c5f);var _0x4bf690={'$gte':moment(moment(_0x1e6762['$gte'])[_0x6983('0x8')](_0x6983('0x9')))[_0x6983('0xa')]()['format'](),'$lte':moment(moment(_0x1e6762['$lte'])[_0x6983('0x8')](_0x6983('0x9')))[_0x6983('0xa')]()[_0x6983('0xb')](0x1,'s')['format']()};_0x8ec6da[_0x3fba19]=_0x4bf690;}else if(_0xcc67fe[_0x6983('0xc')]==='uniqueid'){_0x8ec6da[_0x3fba19]=_0x4e2c5f;}else{_0x8ec6da[_0x3fba19]=_['isArray'](_0x4e2c5f)?_0x4e2c5f:JSON[_0x6983('0x7')](_0x4e2c5f);}}else{_0x8ec6da[_0x3fba19]=_[_0x6983('0xd')](_0x4e2c5f)?_0x4e2c5f:JSON[_0x6983('0x7')](_0x4e2c5f);}}catch(_0x5e4fdc){_0x8ec6da[_0x3fba19]=_0x4e2c5f[_0x6983('0x3')](',');}});}return _0x8ec6da;};exports[_0x6983('0xe')]=function(_0x3edea8){_0x3edea8=parseInt(_0x3edea8,0xa);if(!_0x3edea8||_0x3edea8<0x0){_0x3edea8=LIMIT_VALUE;}return _0x3edea8;};exports[_0x6983('0xf')]=function(_0x43f4b9){_0x43f4b9=parseInt(_0x43f4b9,0xa);if(!_0x43f4b9||_0x43f4b9<0x0){_0x43f4b9=0x0;}return _0x43f4b9;};exports[_0x6983('0x10')]=function(_0x5e6822){var _0xc59601,_0x499c95=null;if(_0x5e6822){_0xc59601=_0x5e6822[_0x6983('0x3')](',');_0x499c95=_[_0x6983('0x11')](_0xc59601,function(_0x369b39){if(_0x369b39[_0x6983('0x12')]('-')===0x0){return[_0x369b39==='priority'?sequelize[_0x6983('0x13')](sequelize[_0x6983('0x14')](_0x6983('0x15')),_0x6983('0x16')):_0x369b39[_0x6983('0x17')](0x1),'DESC'];}else{return[_0x369b39===_0x6983('0x15')?sequelize[_0x6983('0x13')](sequelize[_0x6983('0x14')](_0x6983('0x15')),'unsigned'):_0x369b39,_0x6983('0x18')];}});}return _0x499c95;};exports[_0x6983('0x19')]=function(_0x37a52d,_0x132c21){if(_[_0x6983('0x5')](_0x37a52d)){return _0x37a52d;}if(_[_0x6983('0xd')](_0x37a52d)){for(var _0x166ff7=0x0;_0x166ff7<_0x37a52d[_0x6983('0x1a')];_0x166ff7+=0x1){_0x37a52d[_0x166ff7]=this[_0x6983('0x19')](_0x37a52d[_0x166ff7],_0x132c21);}return _0x37a52d;}if(!_[_0x6983('0x1b')](_0x37a52d)){return _0x37a52d;}if(_[_0x6983('0x1c')](_0x132c21)){_0x132c21=[_0x132c21];}if(!_[_0x6983('0xd')](_0x132c21)){return _0x37a52d;}for(var _0x74763=0x0;_0x74763<_0x132c21[_0x6983('0x1a')];_0x74763+=0x1){_[_0x6983('0x1d')](_0x37a52d,_0x132c21[_0x74763]);}for(var _0x1ba170 in _0x37a52d){if(_0x37a52d[_0x6983('0x1e')](_0x1ba170)){_0x37a52d[_0x1ba170]=this[_0x6983('0x19')](_0x37a52d[_0x1ba170],_0x132c21);}}return _0x37a52d;};exports['isNumeric']=function(_0x202e1f){return _0x202e1f[_0x6983('0x1f')](RegExp(_0x6983('0x20')))?!![]:![];};exports['isEmail']=function(_0x24f5ad){return _0x24f5ad[_0x6983('0x1f')](/^\S+@\S+$/)?!![]:![];};exports[_0x6983('0x21')]=function(_0x88f4a0){var _0x4e291d=[];_0x88f4a0[_0x6983('0x3')](/[ ,]+/)[_0x6983('0x22')](function(_0x940d1f){_0x940d1f=_0x940d1f['replace'](/([^:]")"+/g,'$1');_0x940d1f='+'+_0x940d1f+'*';if(_0x940d1f['includes']('@'))_0x940d1f='\x22'+_0x940d1f+'\x22';_0x4e291d[_0x6983('0x23')](_0x940d1f);});return _0x4e291d[_0x6983('0x24')]('\x20');};
\ No newline at end of file
+var _0xdd73=['VIRTUAL','lower','options','include','includeAll','lodash','sequelize','moment','parse','keys','includes','model','alias','fields','raw','split','find','DATE','isPlainObject','$gte','format','YYYY-MM-DD','utc','$lte','name','uniqueid','isArray','limit','offset','map','indexOf','priority','col','substr','DESC','cast','unsigned','ASC','omit','isObject','isString','length','hasOwnProperty','isNumeric','^[+]?[0-9]*$','isEmail','match','getFullTextValue','\x22{EXPR}\x22','{EXPR}','push','$id','query','filters','attributes','intersection','order','sort','where','pick','filter','object','value','merge','type'];(function(_0x16e917,_0x1299a8){var _0x1fba51=function(_0x5dd818){while(--_0x5dd818){_0x16e917['push'](_0x16e917['shift']());}};_0x1fba51(++_0x1299a8);}(_0xdd73,0x14a));var _0x3dd7=function(_0x21046f,_0x51694e){_0x21046f=_0x21046f-0x0;var _0x3f8262=_0xdd73[_0x21046f];return _0x3f8262;};'use strict';var _=require(_0x3dd7('0x0'));var sequelize=require(_0x3dd7('0x1'));var moment=require(_0x3dd7('0x2'));var db=require('../../mysqldb')['db'];var LIMIT_VALUE=0xfa;function hasSequelizeOperator(_0x182349){var _0x1deb14=['ne'];try{var _0x1667b2=JSON[_0x3dd7('0x3')](_0x182349);var _0x527539=Object[_0x3dd7('0x4')](_0x1667b2)[0x0];return _0x1deb14[_0x3dd7('0x5')](_0x527539);}catch(_0x88ce77){return![];}}function getOperatorValue(_0x251289){var _0x29ca21=JSON[_0x3dd7('0x3')](_0x251289);var _0x244c2a=Object[_0x3dd7('0x4')](_0x29ca21)[0x0];var _0x4d3d2c=_0x29ca21[_0x244c2a];return{['$'+_0x244c2a]:_0x4d3d2c};}function parseIncludeModel(_0x21b90e){var _0x195629=JSON[_0x3dd7('0x3')](_0x21b90e);return{'model':db[_0x195629[_0x3dd7('0x6')]],'as':_0x195629[_0x3dd7('0x7')],'attributes':_0x195629[_0x3dd7('0x8')],'raw':_0x195629[_0x3dd7('0x9')]};}exports[_0x3dd7('0x8')]=function(_0x288461){var _0x446682=null;if(_0x288461){_0x446682=_0x288461[_0x3dd7('0xa')](',');}return _0x446682;};exports['filters']=function(_0x4ac6bd,_0x212270){var _0x3bcb7a={};if(!_['isEmpty'](_0x4ac6bd)){_['forOwn'](_0x4ac6bd,function(_0x1fef9a,_0x374da3){try{if(_0x212270){var _0x1c0ad2=_[_0x3dd7('0xb')](_0x212270,{'name':_0x374da3})||{};if(hasSequelizeOperator(_0x1fef9a)){_0x3bcb7a[_0x374da3]=getOperatorValue(_0x1fef9a);}else if(_0x1c0ad2['type']===_0x3dd7('0xc')&&_[_0x3dd7('0xd')](_0x1fef9a)){var _0x29c076=JSON[_0x3dd7('0x3')](_0x1fef9a);var _0x4662b6={'$gte':moment(moment(_0x29c076[_0x3dd7('0xe')])[_0x3dd7('0xf')](_0x3dd7('0x10')))[_0x3dd7('0x11')]()[_0x3dd7('0xf')](),'$lte':moment(moment(_0x29c076[_0x3dd7('0x12')])[_0x3dd7('0xf')](_0x3dd7('0x10')))[_0x3dd7('0x11')]()['subtract'](0x1,'s')[_0x3dd7('0xf')]()};_0x3bcb7a[_0x374da3]=_0x4662b6;}else if(_0x1c0ad2[_0x3dd7('0x13')]===_0x3dd7('0x14')){_0x3bcb7a[_0x374da3]=_0x1fef9a;}else{_0x3bcb7a[_0x374da3]=_[_0x3dd7('0x15')](_0x1fef9a)?_0x1fef9a:JSON[_0x3dd7('0x3')](_0x1fef9a);}}else{_0x3bcb7a[_0x374da3]=_['isArray'](_0x1fef9a)?_0x1fef9a:JSON['parse'](_0x1fef9a);}}catch(_0x56e870){_0x3bcb7a[_0x374da3]=_0x1fef9a['split'](',');}});}return _0x3bcb7a;};exports[_0x3dd7('0x16')]=function(_0x3afcfc){_0x3afcfc=parseInt(_0x3afcfc,0xa);if(!_0x3afcfc||_0x3afcfc<0x0){_0x3afcfc=LIMIT_VALUE;}return _0x3afcfc;};exports[_0x3dd7('0x17')]=function(_0x3e2311){_0x3e2311=parseInt(_0x3e2311,0xa);if(!_0x3e2311||_0x3e2311<0x0){_0x3e2311=0x0;}return _0x3e2311;};exports['sort']=function(_0x40049c){var _0x133db9,_0x191aef=null;if(_0x40049c){_0x133db9=_0x40049c[_0x3dd7('0xa')](',');_0x191aef=_[_0x3dd7('0x18')](_0x133db9,function(_0x3ede5a){if(_0x3ede5a[_0x3dd7('0x19')]('-')===0x0){return[_0x3ede5a===_0x3dd7('0x1a')?sequelize['cast'](sequelize[_0x3dd7('0x1b')](_0x3dd7('0x1a')),'unsigned'):_0x3ede5a[_0x3dd7('0x1c')](0x1),_0x3dd7('0x1d')];}else{return[_0x3ede5a===_0x3dd7('0x1a')?sequelize[_0x3dd7('0x1e')](sequelize[_0x3dd7('0x1b')](_0x3dd7('0x1a')),_0x3dd7('0x1f')):_0x3ede5a,_0x3dd7('0x20')];}});}return _0x191aef;};exports[_0x3dd7('0x21')]=function(_0x5645e1,_0x270c57){if(_['isEmpty'](_0x5645e1)){return _0x5645e1;}if(_[_0x3dd7('0x15')](_0x5645e1)){for(var _0x22f52a=0x0;_0x22f52a<_0x5645e1['length'];_0x22f52a+=0x1){_0x5645e1[_0x22f52a]=this[_0x3dd7('0x21')](_0x5645e1[_0x22f52a],_0x270c57);}return _0x5645e1;}if(!_[_0x3dd7('0x22')](_0x5645e1)){return _0x5645e1;}if(_[_0x3dd7('0x23')](_0x270c57)){_0x270c57=[_0x270c57];}if(!_['isArray'](_0x270c57)){return _0x5645e1;}for(var _0x17f91b=0x0;_0x17f91b<_0x270c57[_0x3dd7('0x24')];_0x17f91b+=0x1){_['unset'](_0x5645e1,_0x270c57[_0x17f91b]);}for(var _0x4dcad8 in _0x5645e1){if(_0x5645e1[_0x3dd7('0x25')](_0x4dcad8)){_0x5645e1[_0x4dcad8]=this[_0x3dd7('0x21')](_0x5645e1[_0x4dcad8],_0x270c57);}}return _0x5645e1;};exports[_0x3dd7('0x26')]=function(_0x519a3e){return _0x519a3e['match'](RegExp(_0x3dd7('0x27')))?!![]:![];};exports[_0x3dd7('0x28')]=function(_0x1b2f13){return _0x1b2f13[_0x3dd7('0x29')](/^\S+@\S+$/)?!![]:![];};exports[_0x3dd7('0x2a')]=function(_0x323387,_0x581890){var _0x657c49=[];var _0x40f92d=/[ `!@#$%^&*()_\-?~]/;var _0x2fe7e6=_0x581890?_0x3dd7('0x2b'):_0x3dd7('0x2c');_0x323387['split'](/[ ,]+/)['forEach'](function(_0x3b71f7){_0x3b71f7=_0x3b71f7['replace'](/([^:]")"+/g,'$1');_0x3b71f7='+'+_0x3b71f7+'*';var _0x294e1a=_0x3b71f7['match'](_0x40f92d);if(_0x294e1a){_0x3b71f7='\x22'+_0x3b71f7+'\x22';}_0x657c49[_0x3dd7('0x2d')](_0x3b71f7);});_0x2fe7e6=_0x2fe7e6['replace'](_0x3dd7('0x2c'),_0x657c49['join']('\x20'));return _0x2fe7e6;};exports['getOptions']=function(_0x432567,_0x288265,_0x49b160){var _0xab58b9={},_0x49dfa9={};if(_0x288265['query'][_0x3dd7('0x2e')]){_0x288265[_0x3dd7('0x2f')]['id']=_0x288265['query'][_0x3dd7('0x2e')];delete _0x288265[_0x3dd7('0x2f')][_0x3dd7('0x2e')];}_0xab58b9['model']=_[_0x3dd7('0x18')](_0x432567,'name');_0xab58b9[_0x3dd7('0x2f')]=_[_0x3dd7('0x4')](_0x288265[_0x3dd7('0x2f')]);_0xab58b9[_0x3dd7('0x30')]=_['intersection'](_0xab58b9[_0x3dd7('0x6')],_0xab58b9[_0x3dd7('0x2f')]);_0x49dfa9[_0x3dd7('0x31')]=_[_0x3dd7('0x32')](_0xab58b9[_0x3dd7('0x6')],this[_0x3dd7('0x8')](_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x8')]));_0x49dfa9['attributes']=_0x49dfa9[_0x3dd7('0x31')][_0x3dd7('0x24')]?_0x49dfa9[_0x3dd7('0x31')]:_0xab58b9[_0x3dd7('0x6')];if(!_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x25')]('nolimit')){_0x49dfa9[_0x3dd7('0x16')]=this['limit'](_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x16')]);_0x49dfa9[_0x3dd7('0x17')]=this[_0x3dd7('0x17')](_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x17')]);}_0x49dfa9[_0x3dd7('0x33')]=this[_0x3dd7('0x34')](_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x34')]);_0x49dfa9[_0x3dd7('0x35')]=this['filters'](_[_0x3dd7('0x36')](_0x288265[_0x3dd7('0x2f')],_0xab58b9[_0x3dd7('0x30')]),_0x432567);if(_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x37')]){var _0x3784cf=_0x432567;var _0x11093f=_0x288265[_0x3dd7('0x2f')][_0x3dd7('0x37')];if(typeof _0x11093f===_0x3dd7('0x38')){_0x3784cf=_[_0x3dd7('0x37')](_0x432567,function(_0x41cfd0){return _['includes'](_0x11093f['columns'],_0x41cfd0[_0x3dd7('0x13')]);});_0x11093f=_0x11093f[_0x3dd7('0x39')];}_0x49dfa9[_0x3dd7('0x35')]=_[_0x3dd7('0x3a')](_0x49dfa9[_0x3dd7('0x35')],{'$or':_[_0x3dd7('0x18')](_0x3784cf,function(_0x37bcfd){if(_0x37bcfd[_0x3dd7('0x3b')]!==_0x3dd7('0x3c')){if(_0x49b160){return sequelize[_0x3dd7('0x35')](sequelize['fn'](_0x3dd7('0x3d'),sequelize['col'](_0x37bcfd[_0x3dd7('0x13')])),{'$like':sequelize['fn']('lower','%'+_0x288265['query'][_0x3dd7('0x37')]+'%')});}else{var _0xb59fe5={};_0xb59fe5[_0x37bcfd[_0x3dd7('0x13')]]={'$like':'%'+_0x288265['query'][_0x3dd7('0x37')]+'%'};return _0xb59fe5;}}})});}_0x49dfa9=_['merge']({},_0x49dfa9,_0x288265[_0x3dd7('0x3e')]);return _0x49dfa9;};exports[_0x3dd7('0x3f')]=function(_0x3541c3){var _0x3f8058=[];if(_0x3541c3[_0x3dd7('0x40')]){_0x3f8058[_0x3dd7('0x2d')]({'all':!![]});}else if(_0x3541c3[_0x3dd7('0x3f')]){if(Array[_0x3dd7('0x15')](_0x3541c3[_0x3dd7('0x3f')])){_0x3f8058=Object[_0x3dd7('0x4')](_0x3541c3[_0x3dd7('0x3f')])['map'](function(_0x33e08f){return parseIncludeModel(_0x3541c3['include'][_0x33e08f]);});}else{var _0x45a63b=parseIncludeModel(_0x3541c3[_0x3dd7('0x3f')]);_0x3f8058['push'](_0x45a63b);}}return _0x3f8058;};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff