Built motion from commit 1efd3d96.|2.6.31
[motion2.git] / server / components / parsers / advancedSearch.js
index 67dbca9..9bbec93 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x4b74=['split','length','slice','forEach','shift','match','indexOf','map','conditions','buildExpression','DATE','operator','$eq','$between','value','includes','$lte','add','days','format','YYYY-MM-DD','castTo','text','field','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','=\x20?','$ne','<>\x20?','$substring','$endsWith','<\x20?','<=\x20?','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','pop','utcOffset','hours','minutes','seconds','lodash','moment','parseSearch','[$or]','replace','[$and]'];(function(_0x38c0de,_0x32eb18){var _0x1b4579=function(_0x36827d){while(--_0x36827d){_0x38c0de['push'](_0x38c0de['shift']());}};_0x1b4579(++_0x32eb18);}(_0x4b74,0x192));var _0x44b7=function(_0x57a85b,_0x23c478){_0x57a85b=_0x57a85b-0x0;var _0x1d1082=_0x4b74[_0x57a85b];return _0x1d1082;};'use strict';var _=require(_0x44b7('0x0'));var moment=require(_0x44b7('0x1'));exports[_0x44b7('0x2')]=function(_0x56deac){var _0x385f84={'conditions':[]};_0x385f84['sqlOperator']=_['startsWith'](_0x56deac,_0x44b7('0x3'))?'or':'and';var _0x2bfe66=_0x56deac[_0x44b7('0x4')](_0x44b7('0x5'),'')[_0x44b7('0x4')](_0x44b7('0x3'),'')[_0x44b7('0x6')]('||');for(var _0x4ead02=0x0;_0x4ead02<_0x2bfe66[_0x44b7('0x7')];_0x4ead02++){var _0x53f252=_0x2bfe66[_0x4ead02][_0x44b7('0x6')](':=');var _0x10115a=_0x53f252[0x0];var _0x38f121=_0x53f252[_0x44b7('0x8')](0x1);_0x38f121[_0x44b7('0x9')](function(_0x16f526){var _0x395ee4=_0x16f526[_0x44b7('0x6')]('[')[_0x44b7('0xa')]();var _0x3d7a45=_0x16f526[_0x44b7('0xb')](/\[(.*?)\]/g);_0x3d7a45[_0x44b7('0x9')](function(_0x490df2){var _0x4e600a=_0x490df2[_0x44b7('0x6')]('[')['filter'](function(_0xd3a21d){return _0xd3a21d[_0x44b7('0xc')](']')>-0x1;})[_0x44b7('0xd')](function(_0x4aaef0){return _0x4aaef0[_0x44b7('0x6')](']')[0x0];})[0x0];_0x385f84[_0x44b7('0xe')]['push']({'field':_0x10115a,'operator':_0x395ee4,'value':_0x4e600a});});});}return _0x385f84;};exports[_0x44b7('0xf')]=function(_0x1d98dc,_0xf895e8,_0x21ee03){var _0x106559={};if(_0xf895e8===_0x44b7('0x10')){if(_0x21ee03[_0x44b7('0x11')]===_0x44b7('0x12')){_0x21ee03[_0x44b7('0x11')]=_0x44b7('0x13');_0x21ee03[_0x44b7('0x14')]+=','+_0x21ee03['value'];}else if(_[_0x44b7('0x15')](['$gt',_0x44b7('0x16')],_0x21ee03[_0x44b7('0x11')])){_0x21ee03[_0x44b7('0x14')]=moment(_0x21ee03[_0x44b7('0x14')])[_0x44b7('0x17')](0x1,_0x44b7('0x18'))[_0x44b7('0x19')](_0x44b7('0x1a'));}}if(_0x21ee03[_0x44b7('0x1b')]){_0xf895e8=_0x21ee03[_0x44b7('0x1b')];_0x106559[_0x44b7('0x1c')]='CAST('+_0x1d98dc+'.'+_0x21ee03[_0x44b7('0x1d')]+'\x20AS\x20'+_0x21ee03['castTo']+')\x20'+parseOperator(_0x21ee03['operator']);}else{_0x106559[_0x44b7('0x1c')]=_0x1d98dc+'.'+_0x21ee03['field']+'\x20'+parseOperator(_0x21ee03['operator']);}if(_['includes'](['$ne',_0x44b7('0x1e')],_0x21ee03['operator']))_0x106559[_0x44b7('0x1c')]='('+_0x106559[_0x44b7('0x1c')]+_0x44b7('0x1f')+_0x1d98dc+'.'+_0x21ee03['field']+_0x44b7('0x20');_0x106559[_0x44b7('0x14')]=parseValue(_0xf895e8,_0x21ee03[_0x44b7('0x11')],_0x21ee03[_0x44b7('0x14')]);return _0x106559;};function parseOperator(_0x52aca3){var _0x2171e7;switch(_0x52aca3){case _0x44b7('0x21'):_0x2171e7=_0x44b7('0x22');break;case _0x44b7('0x1e'):_0x2171e7=_0x44b7('0x23');break;case _0x44b7('0x12'):_0x2171e7=_0x44b7('0x24');break;case _0x44b7('0x25'):_0x2171e7=_0x44b7('0x26');break;case _0x44b7('0x27'):case'$startsWith':case _0x44b7('0x28'):_0x2171e7='LIKE\x20?';break;case'$lt':_0x2171e7=_0x44b7('0x29');break;case'$gt':_0x2171e7='>\x20?';break;case _0x44b7('0x16'):_0x2171e7=_0x44b7('0x2a');break;case'$gte':_0x2171e7=_0x44b7('0x2b');break;case _0x44b7('0x13'):_0x2171e7=_0x44b7('0x2c');break;}return _0x2171e7;}function parseValue(_0x2f3b4d,_0x133cb9,_0x101cc8){var _0x3beaac={'start':undefined,'end':undefined};switch(_0x133cb9){case _0x44b7('0x21'):case'$notIn':_0x3beaac[_0x44b7('0x2d')]=_0x101cc8[_0x44b7('0x6')](',');break;case _0x44b7('0x27'):_0x3beaac['start']='%'+_0x101cc8+'%';break;case'$startsWith':_0x3beaac[_0x44b7('0x2d')]=_0x101cc8+'%';break;case _0x44b7('0x28'):_0x3beaac[_0x44b7('0x2d')]='%'+_0x101cc8;break;case'$between':var _0x5c23a4=_0x101cc8[_0x44b7('0x6')](',');var _0x101cc8=_0x5c23a4[_0x44b7('0xa')]();var _0x53ffa2=_0x5c23a4[_0x44b7('0x2e')]();if(_0x2f3b4d===_0x44b7('0x10')){_0x101cc8=moment(_0x101cc8)['utcOffset'](0x0,!![])[_0x44b7('0x19')]();_0x53ffa2=moment(_0x53ffa2)[_0x44b7('0x2f')](0x0,!![])[_0x44b7('0x17')](0x17,_0x44b7('0x30'))['add'](0x3b,_0x44b7('0x31'))[_0x44b7('0x17')](0x3b,_0x44b7('0x32'))['format']();}_0x3beaac={'start':_0x101cc8,'end':_0x53ffa2};break;default:_0x3beaac[_0x44b7('0x2d')]=_0x101cc8;break;}return _0x3beaac;}
\ No newline at end of file
+var _0x7dd2=['shift','match','filter','map','conditions','push','buildExpression','DATE','operator','value','$gt','$lte','add','YYYY-MM-DD','castTo','text','CAST(','field','includes','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','$eq','=\x20?','$substring','$startsWith','LIKE\x20?','<\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','$between','pop','utcOffset','format','hours','minutes','seconds','moment','[$and]','replace','[$or]','split','length','slice','forEach'];(function(_0x14aed7,_0x315935){var _0x26f959=function(_0x1a0293){while(--_0x1a0293){_0x14aed7['push'](_0x14aed7['shift']());}};_0x26f959(++_0x315935);}(_0x7dd2,0xfc));var _0x27dd=function(_0x156aaa,_0x37d421){_0x156aaa=_0x156aaa-0x0;var _0xd2453e=_0x7dd2[_0x156aaa];return _0xd2453e;};'use strict';var _=require('lodash');var moment=require(_0x27dd('0x0'));exports['parseSearch']=function(_0x2778c8){var _0x122396={'conditions':[]};_0x122396['sqlOperator']=_['startsWith'](_0x2778c8,'[$or]')?'or':'and';var _0x26ccf6=_0x2778c8['replace'](_0x27dd('0x1'),'')[_0x27dd('0x2')](_0x27dd('0x3'),'')[_0x27dd('0x4')]('||');for(var _0x12d1a0=0x0;_0x12d1a0<_0x26ccf6[_0x27dd('0x5')];_0x12d1a0++){var _0x53d473=_0x26ccf6[_0x12d1a0][_0x27dd('0x4')](':=');var _0x57df48=_0x53d473[0x0];var _0x14f0c3=_0x53d473[_0x27dd('0x6')](0x1);_0x14f0c3[_0x27dd('0x7')](function(_0x4bb864){var _0x19bc71=_0x4bb864[_0x27dd('0x4')]('[')[_0x27dd('0x8')]();var _0x4f4993=_0x4bb864[_0x27dd('0x9')](/\[(.*?)\]/g);_0x4f4993[_0x27dd('0x7')](function(_0xa17d1e){var _0x3eb35d=_0xa17d1e[_0x27dd('0x4')]('[')[_0x27dd('0xa')](function(_0x431965){return _0x431965['indexOf'](']')>-0x1;})[_0x27dd('0xb')](function(_0x472c2a){return _0x472c2a[_0x27dd('0x4')](']')[0x0];})[0x0];_0x122396[_0x27dd('0xc')][_0x27dd('0xd')]({'field':_0x57df48,'operator':_0x19bc71,'value':_0x3eb35d});});});}return _0x122396;};exports[_0x27dd('0xe')]=function(_0x30c84e,_0xb426e7,_0x3537d1){var _0x32c774={};if(_0xb426e7===_0x27dd('0xf')){if(_0x3537d1[_0x27dd('0x10')]==='$eq'){_0x3537d1[_0x27dd('0x10')]='$between';_0x3537d1[_0x27dd('0x11')]+=','+_0x3537d1[_0x27dd('0x11')];}else if(_['includes']([_0x27dd('0x12'),_0x27dd('0x13')],_0x3537d1[_0x27dd('0x10')])){_0x3537d1[_0x27dd('0x11')]=moment(_0x3537d1[_0x27dd('0x11')])[_0x27dd('0x14')](0x1,'days')['format'](_0x27dd('0x15'));}}if(_0x3537d1[_0x27dd('0x16')]){_0xb426e7=_0x3537d1['castTo'];_0x32c774[_0x27dd('0x17')]=_0x27dd('0x18')+_0x30c84e+'.'+_0x3537d1[_0x27dd('0x19')]+'\x20AS\x20'+_0x3537d1[_0x27dd('0x16')]+')\x20'+parseOperator(_0x3537d1['operator']);}else{_0x32c774[_0x27dd('0x17')]=_0x30c84e+'.'+_0x3537d1[_0x27dd('0x19')]+'\x20'+parseOperator(_0x3537d1[_0x27dd('0x10')]);}if(_[_0x27dd('0x1a')]([_0x27dd('0x1b'),_0x27dd('0x1c')],_0x3537d1[_0x27dd('0x10')]))_0x32c774[_0x27dd('0x17')]='('+_0x32c774[_0x27dd('0x17')]+_0x27dd('0x1d')+_0x30c84e+'.'+_0x3537d1[_0x27dd('0x19')]+_0x27dd('0x1e');_0x32c774[_0x27dd('0x11')]=parseValue(_0xb426e7,_0x3537d1[_0x27dd('0x10')],_0x3537d1[_0x27dd('0x11')]);return _0x32c774;};function parseOperator(_0x34d210){var _0x6ee8a6;switch(_0x34d210){case _0x27dd('0x1f'):_0x6ee8a6=_0x27dd('0x20');break;case _0x27dd('0x1c'):_0x6ee8a6=_0x27dd('0x21');break;case _0x27dd('0x22'):_0x6ee8a6=_0x27dd('0x23');break;case _0x27dd('0x1b'):_0x6ee8a6='<>\x20?';break;case _0x27dd('0x24'):case _0x27dd('0x25'):case'$endsWith':_0x6ee8a6=_0x27dd('0x26');break;case'$lt':_0x6ee8a6=_0x27dd('0x27');break;case'$gt':_0x6ee8a6='>\x20?';break;case'$lte':_0x6ee8a6=_0x27dd('0x28');break;case _0x27dd('0x29'):_0x6ee8a6=_0x27dd('0x2a');break;case'$between':_0x6ee8a6=_0x27dd('0x2b');break;}return _0x6ee8a6;}function parseValue(_0x2597fb,_0x56e297,_0x30869d){var _0x105ce2={'start':undefined,'end':undefined};switch(_0x56e297){case _0x27dd('0x1f'):case _0x27dd('0x1c'):_0x105ce2[_0x27dd('0x2c')]=_0x30869d[_0x27dd('0x4')](',');break;case _0x27dd('0x24'):_0x105ce2[_0x27dd('0x2c')]='%'+_0x30869d+'%';break;case _0x27dd('0x25'):_0x105ce2['start']=_0x30869d+'%';break;case'$endsWith':_0x105ce2[_0x27dd('0x2c')]='%'+_0x30869d;break;case _0x27dd('0x2d'):var _0x2629f9=_0x30869d[_0x27dd('0x4')](',');var _0x30869d=_0x2629f9[_0x27dd('0x8')]();var _0x15a25a=_0x2629f9[_0x27dd('0x2e')]();if(_0x2597fb===_0x27dd('0xf')){_0x30869d=moment(_0x30869d)[_0x27dd('0x2f')](0x0,!![])[_0x27dd('0x30')]();_0x15a25a=moment(_0x15a25a)[_0x27dd('0x2f')](0x0,!![])[_0x27dd('0x14')](0x17,_0x27dd('0x31'))[_0x27dd('0x14')](0x3b,_0x27dd('0x32'))[_0x27dd('0x14')](0x3b,_0x27dd('0x33'))[_0x27dd('0x30')]();}_0x105ce2={'start':_0x30869d,'end':_0x15a25a};break;default:_0x105ce2[_0x27dd('0x2c')]=_0x30869d;break;}return _0x105ce2;}
\ No newline at end of file