Built motion from commit (unavailable).|2.5.4
[motion2.git] / server / components / parsers / advancedSearch.js
index 54a4d4c..020f2c6 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x4a79=['CAST(','\x20AS\x20','field','$ne','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','$notIn','NOT\x20IN\x20?','=\x20?','<>\x20?','$substring','$endsWith','LIKE\x20?','>\x20?','<=\x20?','>=\x20?','start','shift','pop','utcOffset','hours','seconds','lodash','parseSearch','[$or]','and','replace','[$and]','length','slice','match','forEach','split','filter','indexOf','conditions','push','buildExpression','DATE','operator','$eq','$between','value','includes','$gt','$lte','add','days','format','YYYY-MM-DD','castTo','text'];(function(_0x5129dd,_0x564b46){var _0x3110ce=function(_0x5a3215){while(--_0x5a3215){_0x5129dd['push'](_0x5129dd['shift']());}};_0x3110ce(++_0x564b46);}(_0x4a79,0x84));var _0x94a7=function(_0x1a127a,_0x42f6e6){_0x1a127a=_0x1a127a-0x0;var _0x2a724b=_0x4a79[_0x1a127a];return _0x2a724b;};'use strict';var _=require(_0x94a7('0x0'));var moment=require('moment');exports[_0x94a7('0x1')]=function(_0x873c34){var _0x2a434d={'conditions':[]};_0x2a434d['sqlOperator']=_['startsWith'](_0x873c34,_0x94a7('0x2'))?'or':_0x94a7('0x3');var _0xf6698b=_0x873c34[_0x94a7('0x4')](_0x94a7('0x5'),'')[_0x94a7('0x4')](_0x94a7('0x2'),'')['split']('||');for(var _0x45d00b=0x0;_0x45d00b<_0xf6698b[_0x94a7('0x6')];_0x45d00b++){var _0x245239=_0xf6698b[_0x45d00b]['split'](':=');var _0x28de9e=_0x245239[0x0];var _0x4b2107=_0x245239[_0x94a7('0x7')](0x1);_0x4b2107['forEach'](function(_0x15c275){var _0x7d3f10=_0x15c275['split']('[')['shift']();var _0x20036e=_0x15c275[_0x94a7('0x8')](/\[(.*?)\]/g);_0x20036e[_0x94a7('0x9')](function(_0x26eba8){var _0x5e698e=_0x26eba8[_0x94a7('0xa')]('[')[_0x94a7('0xb')](function(_0x456144){return _0x456144[_0x94a7('0xc')](']')>-0x1;})['map'](function(_0x391958){return _0x391958[_0x94a7('0xa')](']')[0x0];})[0x0];_0x2a434d[_0x94a7('0xd')][_0x94a7('0xe')]({'field':_0x28de9e,'operator':_0x7d3f10,'value':_0x5e698e});});});}return _0x2a434d;};exports[_0x94a7('0xf')]=function(_0x4f751e,_0x3869dc,_0x151224){var _0x5ae4ef={};if(_0x3869dc===_0x94a7('0x10')){if(_0x151224[_0x94a7('0x11')]===_0x94a7('0x12')){_0x151224[_0x94a7('0x11')]=_0x94a7('0x13');_0x151224[_0x94a7('0x14')]+=','+_0x151224[_0x94a7('0x14')];}else if(_[_0x94a7('0x15')]([_0x94a7('0x16'),_0x94a7('0x17')],_0x151224['operator'])){_0x151224['value']=moment(_0x151224['value'])[_0x94a7('0x18')](0x1,_0x94a7('0x19'))[_0x94a7('0x1a')](_0x94a7('0x1b'));}}if(_0x151224[_0x94a7('0x1c')]){_0x3869dc=_0x151224['castTo'];_0x5ae4ef[_0x94a7('0x1d')]=_0x94a7('0x1e')+_0x4f751e+'.'+_0x151224['field']+_0x94a7('0x1f')+_0x151224[_0x94a7('0x1c')]+')\x20'+parseOperator(_0x151224[_0x94a7('0x11')]);}else{_0x5ae4ef[_0x94a7('0x1d')]=_0x4f751e+'.'+_0x151224[_0x94a7('0x20')]+'\x20'+parseOperator(_0x151224['operator']);}if(_['includes']([_0x94a7('0x21'),'$notIn'],_0x151224[_0x94a7('0x11')]))_0x5ae4ef[_0x94a7('0x1d')]='('+_0x5ae4ef[_0x94a7('0x1d')]+_0x94a7('0x22')+_0x4f751e+'.'+_0x151224['field']+_0x94a7('0x23');_0x5ae4ef['value']=parseValue(_0x3869dc,_0x151224[_0x94a7('0x11')],_0x151224[_0x94a7('0x14')]);return _0x5ae4ef;};function parseOperator(_0xb6aa98){var _0x375b1c;switch(_0xb6aa98){case _0x94a7('0x24'):_0x375b1c=_0x94a7('0x25');break;case _0x94a7('0x26'):_0x375b1c=_0x94a7('0x27');break;case _0x94a7('0x12'):_0x375b1c=_0x94a7('0x28');break;case _0x94a7('0x21'):_0x375b1c=_0x94a7('0x29');break;case _0x94a7('0x2a'):case'$startsWith':case _0x94a7('0x2b'):_0x375b1c=_0x94a7('0x2c');break;case'$lt':_0x375b1c='<\x20?';break;case'$gt':_0x375b1c=_0x94a7('0x2d');break;case _0x94a7('0x17'):_0x375b1c=_0x94a7('0x2e');break;case'$gte':_0x375b1c=_0x94a7('0x2f');break;case'$between':_0x375b1c='BETWEEN\x20?\x20AND\x20?';break;}return _0x375b1c;}function parseValue(_0xb5ad46,_0x321f9c,_0x411e71){var _0x13d9bc={'start':undefined,'end':undefined};switch(_0x321f9c){case _0x94a7('0x24'):case _0x94a7('0x26'):_0x13d9bc[_0x94a7('0x30')]=_0x411e71[_0x94a7('0xa')](',');break;case _0x94a7('0x2a'):_0x13d9bc[_0x94a7('0x30')]='%'+_0x411e71+'%';break;case'$startsWith':_0x13d9bc[_0x94a7('0x30')]=_0x411e71+'%';break;case _0x94a7('0x2b'):_0x13d9bc[_0x94a7('0x30')]='%'+_0x411e71;break;case _0x94a7('0x13'):var _0x542c6=_0x411e71[_0x94a7('0xa')](',');var _0x411e71=_0x542c6[_0x94a7('0x31')]();var _0x24783c=_0x542c6[_0x94a7('0x32')]();if(_0xb5ad46===_0x94a7('0x10')){_0x411e71=moment(_0x411e71)[_0x94a7('0x33')](0x0,!![])[_0x94a7('0x1a')]();_0x24783c=moment(_0x24783c)['utcOffset'](0x0,!![])['add'](0x17,_0x94a7('0x34'))['add'](0x3b,'minutes')[_0x94a7('0x18')](0x3b,_0x94a7('0x35'))[_0x94a7('0x1a')]();}_0x13d9bc={'start':_0x411e71,'end':_0x24783c};break;default:_0x13d9bc[_0x94a7('0x30')]=_0x411e71;break;}return _0x13d9bc;}
\ No newline at end of file
+var _0x5983=['and','replace','[$and]','[$or]','split','length','slice','shift','match','forEach','filter','indexOf','conditions','push','buildExpression','DATE','$eq','value','$lte','operator','add','days','format','YYYY-MM-DD','castTo','text','CAST(','field','\x20AS\x20','includes','$ne','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','$notIn','=\x20?','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','$lt','>\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','$between','pop','utcOffset','hours','minutes','seconds','moment','sqlOperator','startsWith'];(function(_0x122ef9,_0x451d2a){var _0x42fba0=function(_0x17c9d3){while(--_0x17c9d3){_0x122ef9['push'](_0x122ef9['shift']());}};_0x42fba0(++_0x451d2a);}(_0x5983,0x193));var _0x3598=function(_0x73e40,_0x3bdea1){_0x73e40=_0x73e40-0x0;var _0x4ed4fd=_0x5983[_0x73e40];return _0x4ed4fd;};'use strict';var _=require('lodash');var moment=require(_0x3598('0x0'));exports['parseSearch']=function(_0x1aec8b){var _0x40a3c8={'conditions':[]};_0x40a3c8[_0x3598('0x1')]=_[_0x3598('0x2')](_0x1aec8b,'[$or]')?'or':_0x3598('0x3');var _0x5aa8fc=_0x1aec8b[_0x3598('0x4')](_0x3598('0x5'),'')['replace'](_0x3598('0x6'),'')[_0x3598('0x7')]('||');for(var _0x5eb064=0x0;_0x5eb064<_0x5aa8fc[_0x3598('0x8')];_0x5eb064++){var _0x69eb5f=_0x5aa8fc[_0x5eb064][_0x3598('0x7')](':=');var _0x196723=_0x69eb5f[0x0];var _0xdc2266=_0x69eb5f[_0x3598('0x9')](0x1);_0xdc2266['forEach'](function(_0x4f89ac){var _0x2851ab=_0x4f89ac[_0x3598('0x7')]('[')[_0x3598('0xa')]();var _0x29b73e=_0x4f89ac[_0x3598('0xb')](/\[(.*?)\]/g);_0x29b73e[_0x3598('0xc')](function(_0x431b7c){var _0x39e44=_0x431b7c[_0x3598('0x7')]('[')[_0x3598('0xd')](function(_0x5dec6f){return _0x5dec6f[_0x3598('0xe')](']')>-0x1;})['map'](function(_0x3cf32c){return _0x3cf32c[_0x3598('0x7')](']')[0x0];})[0x0];_0x40a3c8[_0x3598('0xf')][_0x3598('0x10')]({'field':_0x196723,'operator':_0x2851ab,'value':_0x39e44});});});}return _0x40a3c8;};exports[_0x3598('0x11')]=function(_0x561163,_0x2a01be,_0x1355bd){var _0x101d79={};if(_0x2a01be===_0x3598('0x12')){if(_0x1355bd['operator']===_0x3598('0x13')){_0x1355bd['operator']='$between';_0x1355bd[_0x3598('0x14')]+=','+_0x1355bd['value'];}else if(_['includes'](['$gt',_0x3598('0x15')],_0x1355bd[_0x3598('0x16')])){_0x1355bd[_0x3598('0x14')]=moment(_0x1355bd['value'])[_0x3598('0x17')](0x1,_0x3598('0x18'))[_0x3598('0x19')](_0x3598('0x1a'));}}if(_0x1355bd[_0x3598('0x1b')]){_0x2a01be=_0x1355bd[_0x3598('0x1b')];_0x101d79[_0x3598('0x1c')]=_0x3598('0x1d')+_0x561163+'.'+_0x1355bd[_0x3598('0x1e')]+_0x3598('0x1f')+_0x1355bd['castTo']+')\x20'+parseOperator(_0x1355bd[_0x3598('0x16')]);}else{_0x101d79['text']=_0x561163+'.'+_0x1355bd['field']+'\x20'+parseOperator(_0x1355bd[_0x3598('0x16')]);}if(_[_0x3598('0x20')]([_0x3598('0x21'),'$notIn'],_0x1355bd[_0x3598('0x16')]))_0x101d79['text']='('+_0x101d79[_0x3598('0x1c')]+_0x3598('0x22')+_0x561163+'.'+_0x1355bd[_0x3598('0x1e')]+_0x3598('0x23');_0x101d79['value']=parseValue(_0x2a01be,_0x1355bd[_0x3598('0x16')],_0x1355bd[_0x3598('0x14')]);return _0x101d79;};function parseOperator(_0x587c7d){var _0x2eb4f8;switch(_0x587c7d){case _0x3598('0x24'):_0x2eb4f8=_0x3598('0x25');break;case _0x3598('0x26'):_0x2eb4f8='NOT\x20IN\x20?';break;case _0x3598('0x13'):_0x2eb4f8=_0x3598('0x27');break;case _0x3598('0x21'):_0x2eb4f8=_0x3598('0x28');break;case _0x3598('0x29'):case _0x3598('0x2a'):case _0x3598('0x2b'):_0x2eb4f8=_0x3598('0x2c');break;case _0x3598('0x2d'):_0x2eb4f8='<\x20?';break;case'$gt':_0x2eb4f8=_0x3598('0x2e');break;case _0x3598('0x15'):_0x2eb4f8=_0x3598('0x2f');break;case _0x3598('0x30'):_0x2eb4f8=_0x3598('0x31');break;case'$between':_0x2eb4f8=_0x3598('0x32');break;}return _0x2eb4f8;}function parseValue(_0x504fbe,_0x19f79a,_0x181349){var _0x59dda9={'start':undefined,'end':undefined};switch(_0x19f79a){case'$in':case _0x3598('0x26'):_0x59dda9[_0x3598('0x33')]=_0x181349[_0x3598('0x7')](',');break;case _0x3598('0x29'):_0x59dda9[_0x3598('0x33')]='%'+_0x181349+'%';break;case'$startsWith':_0x59dda9[_0x3598('0x33')]=_0x181349+'%';break;case _0x3598('0x2b'):_0x59dda9[_0x3598('0x33')]='%'+_0x181349;break;case _0x3598('0x34'):var _0x5ccf53=_0x181349[_0x3598('0x7')](',');var _0x181349=_0x5ccf53[_0x3598('0xa')]();var _0x433936=_0x5ccf53[_0x3598('0x35')]();if(_0x504fbe===_0x3598('0x12')){_0x181349=moment(_0x181349)[_0x3598('0x36')](0x0,!![])[_0x3598('0x19')]();_0x433936=moment(_0x433936)[_0x3598('0x36')](0x0,!![])[_0x3598('0x17')](0x17,_0x3598('0x37'))[_0x3598('0x17')](0x3b,_0x3598('0x38'))[_0x3598('0x17')](0x3b,_0x3598('0x39'))[_0x3598('0x19')]();}_0x59dda9={'start':_0x181349,'end':_0x433936};break;default:_0x59dda9[_0x3598('0x33')]=_0x181349;break;}return _0x59dda9;}
\ No newline at end of file