Built motion from commit (unavailable).|2.5.21
[motion2.git] / server / components / parsers / advancedSearch.js
index b509ba3..f003993 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-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
+var _0x50aa=['replace','[$and]','split','length','slice','shift','match','forEach','filter','indexOf','map','conditions','push','DATE','operator','$eq','$between','value','includes','$gt','$lte','add','format','YYYY-MM-DD','castTo','CAST(','field','$ne','$notIn','text','\x20IS\x20NULL)','$in','IN\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','$lt','<\x20?','>\x20?','<=\x20?','>=\x20?','start','pop','utcOffset','minutes','lodash','parseSearch','sqlOperator','[$or]'];(function(_0x68c979,_0x431cff){var _0x4f0001=function(_0xa7595d){while(--_0xa7595d){_0x68c979['push'](_0x68c979['shift']());}};_0x4f0001(++_0x431cff);}(_0x50aa,0x15a));var _0xa50a=function(_0x2ba740,_0x62a305){_0x2ba740=_0x2ba740-0x0;var _0x358bda=_0x50aa[_0x2ba740];return _0x358bda;};'use strict';var _=require(_0xa50a('0x0'));var moment=require('moment');exports[_0xa50a('0x1')]=function(_0x25160a){var _0x3efdf3={'conditions':[]};_0x3efdf3[_0xa50a('0x2')]=_['startsWith'](_0x25160a,_0xa50a('0x3'))?'or':'and';var _0x40f119=_0x25160a[_0xa50a('0x4')](_0xa50a('0x5'),'')['replace'](_0xa50a('0x3'),'')[_0xa50a('0x6')]('||');for(var _0x379fe2=0x0;_0x379fe2<_0x40f119[_0xa50a('0x7')];_0x379fe2++){var _0x133dfa=_0x40f119[_0x379fe2][_0xa50a('0x6')](':=');var _0x59aebb=_0x133dfa[0x0];var _0xd9c76d=_0x133dfa[_0xa50a('0x8')](0x1);_0xd9c76d['forEach'](function(_0x23aef8){var _0x8b9015=_0x23aef8[_0xa50a('0x6')]('[')[_0xa50a('0x9')]();var _0x3bbf43=_0x23aef8[_0xa50a('0xa')](/\[(.*?)\]/g);_0x3bbf43[_0xa50a('0xb')](function(_0x38cd8c){var _0x2fe76e=_0x38cd8c[_0xa50a('0x6')]('[')[_0xa50a('0xc')](function(_0x4f9fd3){return _0x4f9fd3[_0xa50a('0xd')](']')>-0x1;})[_0xa50a('0xe')](function(_0x510669){return _0x510669[_0xa50a('0x6')](']')[0x0];})[0x0];_0x3efdf3[_0xa50a('0xf')][_0xa50a('0x10')]({'field':_0x59aebb,'operator':_0x8b9015,'value':_0x2fe76e});});});}return _0x3efdf3;};exports['buildExpression']=function(_0x5d5e01,_0x1bb960,_0x1008f4){var _0x2b6744={};if(_0x1bb960===_0xa50a('0x11')){if(_0x1008f4[_0xa50a('0x12')]===_0xa50a('0x13')){_0x1008f4[_0xa50a('0x12')]=_0xa50a('0x14');_0x1008f4['value']+=','+_0x1008f4[_0xa50a('0x15')];}else if(_[_0xa50a('0x16')]([_0xa50a('0x17'),_0xa50a('0x18')],_0x1008f4[_0xa50a('0x12')])){_0x1008f4[_0xa50a('0x15')]=moment(_0x1008f4['value'])[_0xa50a('0x19')](0x1,'days')[_0xa50a('0x1a')](_0xa50a('0x1b'));}}if(_0x1008f4[_0xa50a('0x1c')]){_0x1bb960=_0x1008f4['castTo'];_0x2b6744['text']=_0xa50a('0x1d')+_0x5d5e01+'.'+_0x1008f4[_0xa50a('0x1e')]+'\x20AS\x20'+_0x1008f4[_0xa50a('0x1c')]+')\x20'+parseOperator(_0x1008f4['operator']);}else{_0x2b6744['text']=_0x5d5e01+'.'+_0x1008f4[_0xa50a('0x1e')]+'\x20'+parseOperator(_0x1008f4[_0xa50a('0x12')]);}if(_[_0xa50a('0x16')]([_0xa50a('0x1f'),_0xa50a('0x20')],_0x1008f4[_0xa50a('0x12')]))_0x2b6744[_0xa50a('0x21')]='('+_0x2b6744['text']+'\x20OR\x20'+_0x5d5e01+'.'+_0x1008f4[_0xa50a('0x1e')]+_0xa50a('0x22');_0x2b6744['value']=parseValue(_0x1bb960,_0x1008f4[_0xa50a('0x12')],_0x1008f4['value']);return _0x2b6744;};function parseOperator(_0x46e37a){var _0x5ea56a;switch(_0x46e37a){case _0xa50a('0x23'):_0x5ea56a=_0xa50a('0x24');break;case _0xa50a('0x20'):_0x5ea56a='NOT\x20IN\x20?';break;case _0xa50a('0x13'):_0x5ea56a='=\x20?';break;case'$ne':_0x5ea56a='<>\x20?';break;case _0xa50a('0x25'):case _0xa50a('0x26'):case _0xa50a('0x27'):_0x5ea56a=_0xa50a('0x28');break;case _0xa50a('0x29'):_0x5ea56a=_0xa50a('0x2a');break;case _0xa50a('0x17'):_0x5ea56a=_0xa50a('0x2b');break;case _0xa50a('0x18'):_0x5ea56a=_0xa50a('0x2c');break;case'$gte':_0x5ea56a=_0xa50a('0x2d');break;case _0xa50a('0x14'):_0x5ea56a='BETWEEN\x20?\x20AND\x20?';break;}return _0x5ea56a;}function parseValue(_0x4d3a9c,_0x34e9a1,_0x294b78){var _0x43822a={'start':undefined,'end':undefined};switch(_0x34e9a1){case _0xa50a('0x23'):case _0xa50a('0x20'):_0x43822a[_0xa50a('0x2e')]=_0x294b78[_0xa50a('0x6')](',');break;case _0xa50a('0x25'):_0x43822a[_0xa50a('0x2e')]='%'+_0x294b78+'%';break;case _0xa50a('0x26'):_0x43822a[_0xa50a('0x2e')]=_0x294b78+'%';break;case'$endsWith':_0x43822a['start']='%'+_0x294b78;break;case _0xa50a('0x14'):var _0x45f8a9=_0x294b78[_0xa50a('0x6')](',');var _0x294b78=_0x45f8a9[_0xa50a('0x9')]();var _0x491508=_0x45f8a9[_0xa50a('0x2f')]();if(_0x4d3a9c===_0xa50a('0x11')){_0x294b78=moment(_0x294b78)[_0xa50a('0x30')](0x0,!![])['format']();_0x491508=moment(_0x491508)[_0xa50a('0x30')](0x0,!![])[_0xa50a('0x19')](0x17,'hours')[_0xa50a('0x19')](0x3b,_0xa50a('0x31'))[_0xa50a('0x19')](0x3b,'seconds')[_0xa50a('0x1a')]();}_0x43822a={'start':_0x294b78,'end':_0x491508};break;default:_0x43822a['start']=_0x294b78;break;}return _0x43822a;}
\ No newline at end of file