Built motion from commit (unavailable).|2.5.26
[motion2.git] / server / components / parsers / advancedSearch.js
index ebdffc1..b509ba3 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x9b42=['$between','start','DATE','utcOffset','add','hours','minutes','seconds','lodash','moment','parseSearch','sqlOperator','startsWith','[$or]','and','replace','split','length','forEach','shift','match','filter','indexOf','map','conditions','push','buildExpression','operator','value','includes','$gt','$lte','format','YYYY-MM-DD','castTo','CAST(','field','\x20AS\x20','$notIn','text','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','$eq','=\x20?','<>\x20?','$startsWith','$endsWith','LIKE\x20?','<\x20?','<=\x20?','$gte','>=\x20?'];(function(_0x23a093,_0x43e7eb){var _0x4b58b0=function(_0x239a7a){while(--_0x239a7a){_0x23a093['push'](_0x23a093['shift']());}};_0x4b58b0(++_0x43e7eb);}(_0x9b42,0x74));var _0x29b4=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0x9b42[_0x20a584];return _0x4b41a8;};'use strict';var _=require(_0x29b4('0x0'));var moment=require(_0x29b4('0x1'));exports[_0x29b4('0x2')]=function(_0x2424f1){var _0x252710={'conditions':[]};_0x252710[_0x29b4('0x3')]=_[_0x29b4('0x4')](_0x2424f1,_0x29b4('0x5'))?'or':_0x29b4('0x6');var _0x125a16=_0x2424f1[_0x29b4('0x7')]('[$and]','')[_0x29b4('0x7')](_0x29b4('0x5'),'')[_0x29b4('0x8')]('||');for(var _0x6ef27f=0x0;_0x6ef27f<_0x125a16[_0x29b4('0x9')];_0x6ef27f++){var _0x4b3dba=_0x125a16[_0x6ef27f][_0x29b4('0x8')](':=');var _0x3dd01c=_0x4b3dba[0x0];var _0x2b7cf3=_0x4b3dba['slice'](0x1);_0x2b7cf3[_0x29b4('0xa')](function(_0x1cb170){var _0x4d5991=_0x1cb170[_0x29b4('0x8')]('[')[_0x29b4('0xb')]();var _0x11ff68=_0x1cb170[_0x29b4('0xc')](/\[(.*?)\]/g);_0x11ff68[_0x29b4('0xa')](function(_0x1a2cc1){var _0x1ecaca=_0x1a2cc1[_0x29b4('0x8')]('[')[_0x29b4('0xd')](function(_0x265ee3){return _0x265ee3[_0x29b4('0xe')](']')>-0x1;})[_0x29b4('0xf')](function(_0x2ba0a1){return _0x2ba0a1[_0x29b4('0x8')](']')[0x0];})[0x0];_0x252710[_0x29b4('0x10')][_0x29b4('0x11')]({'field':_0x3dd01c,'operator':_0x4d5991,'value':_0x1ecaca});});});}return _0x252710;};exports[_0x29b4('0x12')]=function(_0x2f2476,_0x31172b,_0xb89093){var _0xf4e124={};if(_0x31172b==='DATE'){if(_0xb89093['operator']==='$eq'){_0xb89093[_0x29b4('0x13')]='$between';_0xb89093[_0x29b4('0x14')]+=','+_0xb89093[_0x29b4('0x14')];}else if(_[_0x29b4('0x15')]([_0x29b4('0x16'),_0x29b4('0x17')],_0xb89093['operator'])){_0xb89093[_0x29b4('0x14')]=moment(_0xb89093[_0x29b4('0x14')])['add'](0x1,'days')[_0x29b4('0x18')](_0x29b4('0x19'));}}if(_0xb89093['castTo']){_0x31172b=_0xb89093[_0x29b4('0x1a')];_0xf4e124['text']=_0x29b4('0x1b')+_0x2f2476+'.'+_0xb89093[_0x29b4('0x1c')]+_0x29b4('0x1d')+_0xb89093[_0x29b4('0x1a')]+')\x20'+parseOperator(_0xb89093[_0x29b4('0x13')]);}else{_0xf4e124['text']=_0x2f2476+'.'+_0xb89093['field']+'\x20'+parseOperator(_0xb89093[_0x29b4('0x13')]);}if(_[_0x29b4('0x15')](['$ne',_0x29b4('0x1e')],_0xb89093['operator']))_0xf4e124[_0x29b4('0x1f')]='('+_0xf4e124[_0x29b4('0x1f')]+'\x20OR\x20'+_0x2f2476+'.'+_0xb89093['field']+_0x29b4('0x20');_0xf4e124[_0x29b4('0x14')]=parseValue(_0x31172b,_0xb89093[_0x29b4('0x13')],_0xb89093[_0x29b4('0x14')]);return _0xf4e124;};function parseOperator(_0x3776d0){var _0x2916c5;switch(_0x3776d0){case _0x29b4('0x21'):_0x2916c5=_0x29b4('0x22');break;case _0x29b4('0x1e'):_0x2916c5=_0x29b4('0x23');break;case _0x29b4('0x24'):_0x2916c5=_0x29b4('0x25');break;case'$ne':_0x2916c5=_0x29b4('0x26');break;case'$substring':case _0x29b4('0x27'):case _0x29b4('0x28'):_0x2916c5=_0x29b4('0x29');break;case'$lt':_0x2916c5=_0x29b4('0x2a');break;case _0x29b4('0x16'):_0x2916c5='>\x20?';break;case _0x29b4('0x17'):_0x2916c5=_0x29b4('0x2b');break;case _0x29b4('0x2c'):_0x2916c5=_0x29b4('0x2d');break;case _0x29b4('0x2e'):_0x2916c5='BETWEEN\x20?\x20AND\x20?';break;}return _0x2916c5;}function parseValue(_0x4ddcdd,_0x1f6cbd,_0x569fd3){var _0x14bd45={'start':undefined,'end':undefined};switch(_0x1f6cbd){case _0x29b4('0x21'):case _0x29b4('0x1e'):_0x14bd45[_0x29b4('0x2f')]=_0x569fd3[_0x29b4('0x8')](',');break;case'$substring':_0x14bd45[_0x29b4('0x2f')]='%'+_0x569fd3+'%';break;case'$startsWith':_0x14bd45[_0x29b4('0x2f')]=_0x569fd3+'%';break;case'$endsWith':_0x14bd45[_0x29b4('0x2f')]='%'+_0x569fd3;break;case _0x29b4('0x2e'):var _0x581f13=_0x569fd3['split'](',');var _0x569fd3=_0x581f13['shift']();var _0x33a40d=_0x581f13['pop']();if(_0x4ddcdd===_0x29b4('0x30')){_0x569fd3=moment(_0x569fd3)[_0x29b4('0x31')](0x0,!![])[_0x29b4('0x18')]();_0x33a40d=moment(_0x33a40d)[_0x29b4('0x31')](0x0,!![])[_0x29b4('0x32')](0x17,_0x29b4('0x33'))[_0x29b4('0x32')](0x3b,_0x29b4('0x34'))[_0x29b4('0x32')](0x3b,_0x29b4('0x35'))['format']();}_0x14bd45={'start':_0x569fd3,'end':_0x33a40d};break;default:_0x14bd45[_0x29b4('0x2f')]=_0x569fd3;break;}return _0x14bd45;}
\ No newline at end of file
+var _0x2269=['start','$endsWith','shift','pop','utcOffset','format','minutes','seconds','lodash','parseSearch','sqlOperator','startsWith','[$or]','and','[$and]','split','length','match','forEach','filter','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','$gt','add','days','YYYY-MM-DD','castTo','text','field','\x20AS\x20','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','NOT\x20IN\x20?','<>\x20?','$substring','$startsWith','LIKE\x20?','$lte','<=\x20?','$gte','>=\x20?'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x2269,0xa1));var _0x9226=function(_0x1f16de,_0x548eb9){_0x1f16de=_0x1f16de-0x0;var _0x36cd80=_0x2269[_0x1f16de];return _0x36cd80;};'use strict';var _=require(_0x9226('0x0'));var moment=require('moment');exports[_0x9226('0x1')]=function(_0x41991a){var _0x409c8f={'conditions':[]};_0x409c8f[_0x9226('0x2')]=_[_0x9226('0x3')](_0x41991a,_0x9226('0x4'))?'or':_0x9226('0x5');var _0x239d27=_0x41991a['replace'](_0x9226('0x6'),'')['replace'](_0x9226('0x4'),'')[_0x9226('0x7')]('||');for(var _0x529eaa=0x0;_0x529eaa<_0x239d27[_0x9226('0x8')];_0x529eaa++){var _0x4c47e3=_0x239d27[_0x529eaa][_0x9226('0x7')](':=');var _0x415446=_0x4c47e3[0x0];var _0x941cb2=_0x4c47e3['slice'](0x1);_0x941cb2['forEach'](function(_0x1b31f9){var _0x4c4462=_0x1b31f9[_0x9226('0x7')]('[')['shift']();var _0x3eb2a0=_0x1b31f9[_0x9226('0x9')](/\[(.*?)\]/g);_0x3eb2a0[_0x9226('0xa')](function(_0x3a3947){var _0x58d7f3=_0x3a3947[_0x9226('0x7')]('[')[_0x9226('0xb')](function(_0x4ba530){return _0x4ba530['indexOf'](']')>-0x1;})[_0x9226('0xc')](function(_0x2da9ae){return _0x2da9ae[_0x9226('0x7')](']')[0x0];})[0x0];_0x409c8f[_0x9226('0xd')][_0x9226('0xe')]({'field':_0x415446,'operator':_0x4c4462,'value':_0x58d7f3});});});}return _0x409c8f;};exports[_0x9226('0xf')]=function(_0x135e13,_0x429e25,_0x3ae404){var _0x571171={};if(_0x429e25===_0x9226('0x10')){if(_0x3ae404[_0x9226('0x11')]===_0x9226('0x12')){_0x3ae404[_0x9226('0x11')]=_0x9226('0x13');_0x3ae404[_0x9226('0x14')]+=','+_0x3ae404[_0x9226('0x14')];}else if(_['includes']([_0x9226('0x15'),'$lte'],_0x3ae404[_0x9226('0x11')])){_0x3ae404[_0x9226('0x14')]=moment(_0x3ae404[_0x9226('0x14')])[_0x9226('0x16')](0x1,_0x9226('0x17'))['format'](_0x9226('0x18'));}}if(_0x3ae404[_0x9226('0x19')]){_0x429e25=_0x3ae404[_0x9226('0x19')];_0x571171[_0x9226('0x1a')]='CAST('+_0x135e13+'.'+_0x3ae404[_0x9226('0x1b')]+_0x9226('0x1c')+_0x3ae404['castTo']+')\x20'+parseOperator(_0x3ae404[_0x9226('0x11')]);}else{_0x571171[_0x9226('0x1a')]=_0x135e13+'.'+_0x3ae404[_0x9226('0x1b')]+'\x20'+parseOperator(_0x3ae404['operator']);}if(_['includes']([_0x9226('0x1d'),_0x9226('0x1e')],_0x3ae404[_0x9226('0x11')]))_0x571171[_0x9226('0x1a')]='('+_0x571171[_0x9226('0x1a')]+_0x9226('0x1f')+_0x135e13+'.'+_0x3ae404[_0x9226('0x1b')]+_0x9226('0x20');_0x571171[_0x9226('0x14')]=parseValue(_0x429e25,_0x3ae404[_0x9226('0x11')],_0x3ae404[_0x9226('0x14')]);return _0x571171;};function parseOperator(_0x464113){var _0x56ff98;switch(_0x464113){case _0x9226('0x21'):_0x56ff98='IN\x20?';break;case _0x9226('0x1e'):_0x56ff98=_0x9226('0x22');break;case _0x9226('0x12'):_0x56ff98='=\x20?';break;case _0x9226('0x1d'):_0x56ff98=_0x9226('0x23');break;case _0x9226('0x24'):case _0x9226('0x25'):case'$endsWith':_0x56ff98=_0x9226('0x26');break;case'$lt':_0x56ff98='<\x20?';break;case'$gt':_0x56ff98='>\x20?';break;case _0x9226('0x27'):_0x56ff98=_0x9226('0x28');break;case _0x9226('0x29'):_0x56ff98=_0x9226('0x2a');break;case _0x9226('0x13'):_0x56ff98='BETWEEN\x20?\x20AND\x20?';break;}return _0x56ff98;}function parseValue(_0x3adc3a,_0x4dd04a,_0x39ced7){var _0x2b4e9d={'start':undefined,'end':undefined};switch(_0x4dd04a){case _0x9226('0x21'):case _0x9226('0x1e'):_0x2b4e9d[_0x9226('0x2b')]=_0x39ced7[_0x9226('0x7')](',');break;case _0x9226('0x24'):_0x2b4e9d['start']='%'+_0x39ced7+'%';break;case _0x9226('0x25'):_0x2b4e9d[_0x9226('0x2b')]=_0x39ced7+'%';break;case _0x9226('0x2c'):_0x2b4e9d[_0x9226('0x2b')]='%'+_0x39ced7;break;case'$between':var _0x43c7f8=_0x39ced7['split'](',');var _0x39ced7=_0x43c7f8[_0x9226('0x2d')]();var _0x460b66=_0x43c7f8[_0x9226('0x2e')]();if(_0x3adc3a==='DATE'){_0x39ced7=moment(_0x39ced7)[_0x9226('0x2f')](0x0,!![])[_0x9226('0x30')]();_0x460b66=moment(_0x460b66)[_0x9226('0x2f')](0x0,!![])['add'](0x17,'hours')[_0x9226('0x16')](0x3b,_0x9226('0x31'))[_0x9226('0x16')](0x3b,_0x9226('0x32'))[_0x9226('0x30')]();}_0x2b4e9d={'start':_0x39ced7,'end':_0x460b66};break;default:_0x2b4e9d[_0x9226('0x2b')]=_0x39ced7;break;}return _0x2b4e9d;}
\ No newline at end of file