server/components/parsers/advancedSearch.js

   1 const a834_0x679e=['lodash','$lt','$ne','includes','hours','DATE','$startsWith','and','push','map','filter','castTo','slice','replace','pop','utcOffset','shift','operator','[$or]','field','=\x20?','forEach','minutes','\x20AS\x20','NOT\x20IN\x20?','value','$substring','IN\x20?','match','$between','split','$gt','days','$endsWith','conditions','seconds','$in','YYYY-MM-DD','start','$gte','indexOf','<=\x20?','LIKE\x20?','startsWith','$lte','add','<>\x20?','text','\x20OR\x20','format','$notIn','$eq','>=\x20?','CAST(','length'];(function(_0x3fe6e8,_0x679ee){const _0x5c943e=function(_0x2eea2a){while(--_0x2eea2a){_0x3fe6e8['push'](_0x3fe6e8['shift']());}};_0x5c943e(++_0x679ee);}(a834_0x679e,0x7d));const a834_0x5c94=function(_0x3fe6e8,_0x679ee){_0x3fe6e8=_0x3fe6e8-0x0;let _0x5c943e=a834_0x679e[_0x3fe6e8];return _0x5c943e;};const _0x1bb3be=a834_0x5c94;'use strict';const _=require(_0x1bb3be('0x28')),moment=require('moment');exports['parseSearch']=function(_0x2eea2a){const _0x1cb7cd=_0x1bb3be,_0x29913d={'conditions':[]};_0x29913d['sqlOperator']=_[_0x1cb7cd('0x1c')](_0x2eea2a,'[$or]')?'or':_0x1cb7cd('0x2f');const _0x2d902b=_0x2eea2a[_0x1cb7cd('0x35')]('[$and]','')[_0x1cb7cd('0x35')](_0x1cb7cd('0x3'),'')['split']('||');for(let _0x2eb92e=0x0;_0x2eb92e<_0x2d902b[_0x1cb7cd('0x27')];_0x2eb92e++){const _0x56a610=_0x2d902b[_0x2eb92e][_0x1cb7cd('0xf')](':='),_0x5f0a35=_0x56a610[0x0],_0x3fd1f5=_0x56a610[_0x1cb7cd('0x34')](0x1);_0x3fd1f5[_0x1cb7cd('0x6')](function(_0x2b870e){const _0xa65276=_0x1cb7cd,_0x5c88ef=_0x2b870e[_0xa65276('0xf')]('[')[_0xa65276('0x1')](),_0x1ed523=_0x2b870e[_0xa65276('0xd')](/\[(.*?)\]/g);_0x1ed523[_0xa65276('0x6')](function(_0x18d112){const _0x83e670=_0xa65276,_0x27199e=_0x18d112[_0x83e670('0xf')]('[')[_0x83e670('0x32')](function(_0x370947){const _0x1a24b2=_0x83e670;return _0x370947[_0x1a24b2('0x19')](']')>-0x1;})[_0x83e670('0x31')](function(_0x25457b){const _0xa8802f=_0x83e670;return _0x25457b[_0xa8802f('0xf')](']')[0x0];})[0x0];_0x29913d[_0x83e670('0x13')][_0x83e670('0x30')]({'field':_0x5f0a35,'operator':_0x5c88ef,'value':_0x27199e});});});}return _0x29913d;},exports['buildExpression']=function(_0x164895,_0x5a4a20,_0x50c717){const _0x2a4fe9=_0x1bb3be,_0x42c1f2={};if(_0x5a4a20===_0x2a4fe9('0x2d')){if(_0x50c717[_0x2a4fe9('0x2')]===_0x2a4fe9('0x24'))_0x50c717[_0x2a4fe9('0x2')]='$between',_0x50c717[_0x2a4fe9('0xa')]+=','+_0x50c717[_0x2a4fe9('0xa')];else _[_0x2a4fe9('0x2b')]([_0x2a4fe9('0x10'),_0x2a4fe9('0x1d')],_0x50c717['operator'])&&(_0x50c717[_0x2a4fe9('0xa')]=moment(_0x50c717['value'])[_0x2a4fe9('0x1e')](0x1,_0x2a4fe9('0x11'))[_0x2a4fe9('0x22')](_0x2a4fe9('0x16')));}_0x50c717[_0x2a4fe9('0x33')]?(_0x5a4a20=_0x50c717[_0x2a4fe9('0x33')],_0x42c1f2[_0x2a4fe9('0x20')]=_0x2a4fe9('0x26')+_0x164895+'.'+_0x50c717[_0x2a4fe9('0x4')]+_0x2a4fe9('0x8')+_0x50c717[_0x2a4fe9('0x33')]+')\x20'+parseOperator(_0x50c717[_0x2a4fe9('0x2')])):_0x42c1f2[_0x2a4fe9('0x20')]=_0x164895+'.'+_0x50c717[_0x2a4fe9('0x4')]+'\x20'+parseOperator(_0x50c717[_0x2a4fe9('0x2')]);if(_[_0x2a4fe9('0x2b')](['$ne',_0x2a4fe9('0x23')],_0x50c717[_0x2a4fe9('0x2')]))_0x42c1f2[_0x2a4fe9('0x20')]='('+_0x42c1f2[_0x2a4fe9('0x20')]+_0x2a4fe9('0x21')+_0x164895+'.'+_0x50c717[_0x2a4fe9('0x4')]+'\x20IS\x20NULL)';return _0x42c1f2[_0x2a4fe9('0xa')]=parseValue(_0x5a4a20,_0x50c717[_0x2a4fe9('0x2')],_0x50c717[_0x2a4fe9('0xa')]),_0x42c1f2;};function parseOperator(_0x1750e1){const _0x48dabb=_0x1bb3be;let _0x13c1c8;switch(_0x1750e1){case _0x48dabb('0x15'):_0x13c1c8=_0x48dabb('0xc');break;case'$notIn':_0x13c1c8=_0x48dabb('0x9');break;case'$eq':_0x13c1c8=_0x48dabb('0x5');break;case _0x48dabb('0x2a'):_0x13c1c8=_0x48dabb('0x1f');break;case _0x48dabb('0xb'):case _0x48dabb('0x2e'):case'$endsWith':_0x13c1c8=_0x48dabb('0x1b');break;case _0x48dabb('0x29'):_0x13c1c8='<\x20?';break;case _0x48dabb('0x10'):_0x13c1c8='>\x20?';break;case _0x48dabb('0x1d'):_0x13c1c8=_0x48dabb('0x1a');break;case _0x48dabb('0x18'):_0x13c1c8=_0x48dabb('0x25');break;case _0x48dabb('0xe'):_0x13c1c8='BETWEEN\x20?\x20AND\x20?';break;}return _0x13c1c8;}function parseValue(_0x13e060,_0x395901,_0x2be396){const _0x59ceef=_0x1bb3be;let _0x12d589={'start':undefined,'end':undefined};switch(_0x395901){case _0x59ceef('0x15'):case _0x59ceef('0x23'):_0x12d589[_0x59ceef('0x17')]=_0x2be396[_0x59ceef('0xf')](',');break;case _0x59ceef('0xb'):_0x12d589[_0x59ceef('0x17')]='%'+_0x2be396+'%';break;case _0x59ceef('0x2e'):_0x12d589[_0x59ceef('0x17')]=_0x2be396+'%';break;case _0x59ceef('0x12'):_0x12d589[_0x59ceef('0x17')]='%'+_0x2be396;break;case'$between':{const _0x589764=_0x27311b[_0x59ceef('0xf')](',');let _0x27311b=_0x589764[_0x59ceef('0x1')](),_0x5f411f=_0x589764[_0x59ceef('0x36')]();_0x13e060===_0x59ceef('0x2d')&&(_0x27311b=moment(_0x27311b)[_0x59ceef('0x0')](0x0,!![])[_0x59ceef('0x22')](),_0x5f411f=moment(_0x5f411f)[_0x59ceef('0x0')](0x0,!![])[_0x59ceef('0x1e')](0x17,_0x59ceef('0x2c'))[_0x59ceef('0x1e')](0x3b,_0x59ceef('0x7'))[_0x59ceef('0x1e')](0x3b,_0x59ceef('0x14'))[_0x59ceef('0x22')]()),_0x12d589={'start':_0x27311b,'end':_0x5f411f};}break;default:_0x12d589['start']=_0x2be396;break;}return _0x12d589;}