Built motion from commit (unavailable).|2.5.31
[motion2.git] / server / components / parsers / advancedSearch.js
index 5d7f2ef..5633624 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x8000=['$eq','$between','value','$gt','$lte','add','days','format','YYYY-MM-DD','castTo','field','\x20AS\x20','text','includes','$notIn','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','=\x20?','<>\x20?','$startsWith','$endsWith','<\x20?','>\x20?','<=\x20?','$gte','BETWEEN\x20?\x20AND\x20?','start','$substring','shift','hours','minutes','seconds','lodash','moment','sqlOperator','[$or]','and','replace','[$and]','split','length','slice','forEach','match','filter','indexOf','push','DATE','operator'];(function(_0x485e0b,_0x5eb3e3){var _0x12283c=function(_0x12b84b){while(--_0x12b84b){_0x485e0b['push'](_0x485e0b['shift']());}};_0x12283c(++_0x5eb3e3);}(_0x8000,0x121));var _0x0800=function(_0x2aa4b9,_0x39044f){_0x2aa4b9=_0x2aa4b9-0x0;var _0x10ba69=_0x8000[_0x2aa4b9];return _0x10ba69;};'use strict';var _=require(_0x0800('0x0'));var moment=require(_0x0800('0x1'));exports['parseSearch']=function(_0x5e9ad5){var _0x1e0156={'conditions':[]};_0x1e0156[_0x0800('0x2')]=_['startsWith'](_0x5e9ad5,_0x0800('0x3'))?'or':_0x0800('0x4');var _0x556362=_0x5e9ad5[_0x0800('0x5')](_0x0800('0x6'),'')[_0x0800('0x5')](_0x0800('0x3'),'')[_0x0800('0x7')]('||');for(var _0x503ce8=0x0;_0x503ce8<_0x556362[_0x0800('0x8')];_0x503ce8++){var _0x40cff3=_0x556362[_0x503ce8][_0x0800('0x7')](':=');var _0x12e03a=_0x40cff3[0x0];var _0x18f1e0=_0x40cff3[_0x0800('0x9')](0x1);_0x18f1e0[_0x0800('0xa')](function(_0x126fb4){var _0x13b54a=_0x126fb4['split']('[')['shift']();var _0xf59b00=_0x126fb4[_0x0800('0xb')](/\[(.*?)\]/g);_0xf59b00['forEach'](function(_0x1e05b3){var _0x5dc7c6=_0x1e05b3[_0x0800('0x7')]('[')[_0x0800('0xc')](function(_0x2179ad){return _0x2179ad[_0x0800('0xd')](']')>-0x1;})['map'](function(_0x367993){return _0x367993[_0x0800('0x7')](']')[0x0];})[0x0];_0x1e0156['conditions'][_0x0800('0xe')]({'field':_0x12e03a,'operator':_0x13b54a,'value':_0x5dc7c6});});});}return _0x1e0156;};exports['buildExpression']=function(_0x46d3a1,_0xea6834,_0xe3a3e){var _0x298dff={};if(_0xea6834===_0x0800('0xf')){if(_0xe3a3e[_0x0800('0x10')]===_0x0800('0x11')){_0xe3a3e[_0x0800('0x10')]=_0x0800('0x12');_0xe3a3e['value']+=','+_0xe3a3e[_0x0800('0x13')];}else if(_['includes']([_0x0800('0x14'),_0x0800('0x15')],_0xe3a3e['operator'])){_0xe3a3e['value']=moment(_0xe3a3e[_0x0800('0x13')])[_0x0800('0x16')](0x1,_0x0800('0x17'))[_0x0800('0x18')](_0x0800('0x19'));}}if(_0xe3a3e['castTo']){_0xea6834=_0xe3a3e[_0x0800('0x1a')];_0x298dff['text']='CAST('+_0x46d3a1+'.'+_0xe3a3e[_0x0800('0x1b')]+_0x0800('0x1c')+_0xe3a3e[_0x0800('0x1a')]+')\x20'+parseOperator(_0xe3a3e[_0x0800('0x10')]);}else{_0x298dff[_0x0800('0x1d')]=_0x46d3a1+'.'+_0xe3a3e[_0x0800('0x1b')]+'\x20'+parseOperator(_0xe3a3e[_0x0800('0x10')]);}if(_[_0x0800('0x1e')](['$ne',_0x0800('0x1f')],_0xe3a3e[_0x0800('0x10')]))_0x298dff[_0x0800('0x1d')]='('+_0x298dff[_0x0800('0x1d')]+'\x20OR\x20'+_0x46d3a1+'.'+_0xe3a3e['field']+_0x0800('0x20');_0x298dff['value']=parseValue(_0xea6834,_0xe3a3e['operator'],_0xe3a3e[_0x0800('0x13')]);return _0x298dff;};function parseOperator(_0x14353c){var _0x1a3903;switch(_0x14353c){case _0x0800('0x21'):_0x1a3903=_0x0800('0x22');break;case _0x0800('0x1f'):_0x1a3903=_0x0800('0x23');break;case _0x0800('0x11'):_0x1a3903=_0x0800('0x24');break;case'$ne':_0x1a3903=_0x0800('0x25');break;case'$substring':case _0x0800('0x26'):case _0x0800('0x27'):_0x1a3903='LIKE\x20?';break;case'$lt':_0x1a3903=_0x0800('0x28');break;case _0x0800('0x14'):_0x1a3903=_0x0800('0x29');break;case _0x0800('0x15'):_0x1a3903=_0x0800('0x2a');break;case _0x0800('0x2b'):_0x1a3903='>=\x20?';break;case _0x0800('0x12'):_0x1a3903=_0x0800('0x2c');break;}return _0x1a3903;}function parseValue(_0x210d13,_0x3c5276,_0x3b0c23){var _0x3f4f13={'start':undefined,'end':undefined};switch(_0x3c5276){case _0x0800('0x21'):case'$notIn':_0x3f4f13[_0x0800('0x2d')]=_0x3b0c23[_0x0800('0x7')](',');break;case _0x0800('0x2e'):_0x3f4f13[_0x0800('0x2d')]='%'+_0x3b0c23+'%';break;case _0x0800('0x26'):_0x3f4f13[_0x0800('0x2d')]=_0x3b0c23+'%';break;case _0x0800('0x27'):_0x3f4f13[_0x0800('0x2d')]='%'+_0x3b0c23;break;case _0x0800('0x12'):var _0x5e51b9=_0x3b0c23[_0x0800('0x7')](',');var _0x3b0c23=_0x5e51b9[_0x0800('0x2f')]();var _0x406870=_0x5e51b9['pop']();if(_0x210d13===_0x0800('0xf')){_0x3b0c23=moment(_0x3b0c23)['utcOffset'](0x0,!![])[_0x0800('0x18')]();_0x406870=moment(_0x406870)['utcOffset'](0x0,!![])[_0x0800('0x16')](0x17,_0x0800('0x30'))['add'](0x3b,_0x0800('0x31'))['add'](0x3b,_0x0800('0x32'))[_0x0800('0x18')]();}_0x3f4f13={'start':_0x3b0c23,'end':_0x406870};break;default:_0x3f4f13[_0x0800('0x2d')]=_0x3b0c23;break;}return _0x3f4f13;}
\ No newline at end of file
+var _0x3c5c=['includes','$gt','$lte','add','days','format','YYYY-MM-DD','castTo','text','CAST(','field','$ne','$notIn','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','=\x20?','<>\x20?','$substring','$startsWith','LIKE\x20?','$lt','<\x20?','>\x20?','<=\x20?','>=\x20?','$between','start','$endsWith','utcOffset','hours','minutes','lodash','moment','parseSearch','sqlOperator','startsWith','[$or]','and','replace','split','length','slice','forEach','shift','match','filter','indexOf','conditions','push','DATE','operator','$eq','value'];(function(_0x587dd0,_0x273922){var _0x56f153=function(_0x27fb33){while(--_0x27fb33){_0x587dd0['push'](_0x587dd0['shift']());}};_0x56f153(++_0x273922);}(_0x3c5c,0xc6));var _0xc3c5=function(_0x28947d,_0x4cc9c6){_0x28947d=_0x28947d-0x0;var _0x12d2ee=_0x3c5c[_0x28947d];return _0x12d2ee;};'use strict';var _=require(_0xc3c5('0x0'));var moment=require(_0xc3c5('0x1'));exports[_0xc3c5('0x2')]=function(_0x152d13){var _0x24e4b9={'conditions':[]};_0x24e4b9[_0xc3c5('0x3')]=_[_0xc3c5('0x4')](_0x152d13,_0xc3c5('0x5'))?'or':_0xc3c5('0x6');var _0x4d368f=_0x152d13['replace']('[$and]','')[_0xc3c5('0x7')](_0xc3c5('0x5'),'')[_0xc3c5('0x8')]('||');for(var _0x2d9d45=0x0;_0x2d9d45<_0x4d368f[_0xc3c5('0x9')];_0x2d9d45++){var _0x4ed9ea=_0x4d368f[_0x2d9d45][_0xc3c5('0x8')](':=');var _0xcbfe8b=_0x4ed9ea[0x0];var _0x4df6a2=_0x4ed9ea[_0xc3c5('0xa')](0x1);_0x4df6a2[_0xc3c5('0xb')](function(_0xce9a67){var _0x43265f=_0xce9a67[_0xc3c5('0x8')]('[')[_0xc3c5('0xc')]();var _0x1d9592=_0xce9a67[_0xc3c5('0xd')](/\[(.*?)\]/g);_0x1d9592[_0xc3c5('0xb')](function(_0x5c57ed){var _0x4ef9fb=_0x5c57ed[_0xc3c5('0x8')]('[')[_0xc3c5('0xe')](function(_0x25c641){return _0x25c641[_0xc3c5('0xf')](']')>-0x1;})['map'](function(_0x1893e9){return _0x1893e9['split'](']')[0x0];})[0x0];_0x24e4b9[_0xc3c5('0x10')][_0xc3c5('0x11')]({'field':_0xcbfe8b,'operator':_0x43265f,'value':_0x4ef9fb});});});}return _0x24e4b9;};exports['buildExpression']=function(_0x2954be,_0x4433d0,_0x3365f7){var _0x5db55d={};if(_0x4433d0===_0xc3c5('0x12')){if(_0x3365f7[_0xc3c5('0x13')]===_0xc3c5('0x14')){_0x3365f7[_0xc3c5('0x13')]='$between';_0x3365f7[_0xc3c5('0x15')]+=','+_0x3365f7[_0xc3c5('0x15')];}else if(_[_0xc3c5('0x16')]([_0xc3c5('0x17'),_0xc3c5('0x18')],_0x3365f7[_0xc3c5('0x13')])){_0x3365f7[_0xc3c5('0x15')]=moment(_0x3365f7[_0xc3c5('0x15')])[_0xc3c5('0x19')](0x1,_0xc3c5('0x1a'))[_0xc3c5('0x1b')](_0xc3c5('0x1c'));}}if(_0x3365f7[_0xc3c5('0x1d')]){_0x4433d0=_0x3365f7[_0xc3c5('0x1d')];_0x5db55d[_0xc3c5('0x1e')]=_0xc3c5('0x1f')+_0x2954be+'.'+_0x3365f7['field']+'\x20AS\x20'+_0x3365f7[_0xc3c5('0x1d')]+')\x20'+parseOperator(_0x3365f7[_0xc3c5('0x13')]);}else{_0x5db55d['text']=_0x2954be+'.'+_0x3365f7[_0xc3c5('0x20')]+'\x20'+parseOperator(_0x3365f7[_0xc3c5('0x13')]);}if(_['includes']([_0xc3c5('0x21'),_0xc3c5('0x22')],_0x3365f7[_0xc3c5('0x13')]))_0x5db55d[_0xc3c5('0x1e')]='('+_0x5db55d['text']+'\x20OR\x20'+_0x2954be+'.'+_0x3365f7[_0xc3c5('0x20')]+_0xc3c5('0x23');_0x5db55d[_0xc3c5('0x15')]=parseValue(_0x4433d0,_0x3365f7[_0xc3c5('0x13')],_0x3365f7[_0xc3c5('0x15')]);return _0x5db55d;};function parseOperator(_0xe476bc){var _0x11666a;switch(_0xe476bc){case _0xc3c5('0x24'):_0x11666a=_0xc3c5('0x25');break;case _0xc3c5('0x22'):_0x11666a=_0xc3c5('0x26');break;case'$eq':_0x11666a=_0xc3c5('0x27');break;case _0xc3c5('0x21'):_0x11666a=_0xc3c5('0x28');break;case _0xc3c5('0x29'):case _0xc3c5('0x2a'):case'$endsWith':_0x11666a=_0xc3c5('0x2b');break;case _0xc3c5('0x2c'):_0x11666a=_0xc3c5('0x2d');break;case _0xc3c5('0x17'):_0x11666a=_0xc3c5('0x2e');break;case _0xc3c5('0x18'):_0x11666a=_0xc3c5('0x2f');break;case'$gte':_0x11666a=_0xc3c5('0x30');break;case _0xc3c5('0x31'):_0x11666a='BETWEEN\x20?\x20AND\x20?';break;}return _0x11666a;}function parseValue(_0x5df3fa,_0x1e0855,_0x13e805){var _0x552db3={'start':undefined,'end':undefined};switch(_0x1e0855){case _0xc3c5('0x24'):case _0xc3c5('0x22'):_0x552db3[_0xc3c5('0x32')]=_0x13e805['split'](',');break;case _0xc3c5('0x29'):_0x552db3['start']='%'+_0x13e805+'%';break;case _0xc3c5('0x2a'):_0x552db3[_0xc3c5('0x32')]=_0x13e805+'%';break;case _0xc3c5('0x33'):_0x552db3[_0xc3c5('0x32')]='%'+_0x13e805;break;case _0xc3c5('0x31'):var _0x539f9e=_0x13e805[_0xc3c5('0x8')](',');var _0x13e805=_0x539f9e[_0xc3c5('0xc')]();var _0x9e8f95=_0x539f9e['pop']();if(_0x5df3fa==='DATE'){_0x13e805=moment(_0x13e805)[_0xc3c5('0x34')](0x0,!![])['format']();_0x9e8f95=moment(_0x9e8f95)[_0xc3c5('0x34')](0x0,!![])['add'](0x17,_0xc3c5('0x35'))[_0xc3c5('0x19')](0x3b,_0xc3c5('0x36'))[_0xc3c5('0x19')](0x3b,'seconds')['format']();}_0x552db3={'start':_0x13e805,'end':_0x9e8f95};break;default:_0x552db3['start']=_0x13e805;break;}return _0x552db3;}
\ No newline at end of file