Built motion from commit 37e1ed56.|2.6.29
[motion2.git] / server / components / parsers / advancedSearch.js
index 2a43783..761d539 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x77f1=['$gt','add','format','castTo','CAST(','text','field','includes','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','NOT\x20IN\x20?','$startsWith','$endsWith','LIKE\x20?','$lt','<\x20?','$lte','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','pop','utcOffset','hours','minutes','seconds','lodash','sqlOperator','startsWith','[$or]','and','[$and]','replace','split','length','slice','match','forEach','filter','indexOf','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value'];(function(_0x1b3397,_0x35a196){var _0x5b0125=function(_0x1e39a5){while(--_0x1e39a5){_0x1b3397['push'](_0x1b3397['shift']());}};_0x5b0125(++_0x35a196);}(_0x77f1,0x127));var _0x177f=function(_0x40f140,_0x838efc){_0x40f140=_0x40f140-0x0;var _0x3b8096=_0x77f1[_0x40f140];return _0x3b8096;};'use strict';var _=require(_0x177f('0x0'));var moment=require('moment');exports['parseSearch']=function(_0x1fb721){var _0xe6e97d={'conditions':[]};_0xe6e97d[_0x177f('0x1')]=_[_0x177f('0x2')](_0x1fb721,_0x177f('0x3'))?'or':_0x177f('0x4');var _0x3e2167=_0x1fb721['replace'](_0x177f('0x5'),'')[_0x177f('0x6')](_0x177f('0x3'),'')[_0x177f('0x7')]('||');for(var _0x47e65e=0x0;_0x47e65e<_0x3e2167[_0x177f('0x8')];_0x47e65e++){var _0x19ea6e=_0x3e2167[_0x47e65e][_0x177f('0x7')](':=');var _0x177068=_0x19ea6e[0x0];var _0x36609b=_0x19ea6e[_0x177f('0x9')](0x1);_0x36609b['forEach'](function(_0x1a5a55){var _0x37d079=_0x1a5a55[_0x177f('0x7')]('[')['shift']();var _0x4a9a24=_0x1a5a55[_0x177f('0xa')](/\[(.*?)\]/g);_0x4a9a24[_0x177f('0xb')](function(_0x452861){var _0x143a24=_0x452861[_0x177f('0x7')]('[')[_0x177f('0xc')](function(_0x4c81d1){return _0x4c81d1[_0x177f('0xd')](']')>-0x1;})[_0x177f('0xe')](function(_0x16fc05){return _0x16fc05['split'](']')[0x0];})[0x0];_0xe6e97d[_0x177f('0xf')][_0x177f('0x10')]({'field':_0x177068,'operator':_0x37d079,'value':_0x143a24});});});}return _0xe6e97d;};exports[_0x177f('0x11')]=function(_0x40d3e2,_0x2fbf18,_0x236336){var _0x426eb8={};if(_0x2fbf18===_0x177f('0x12')){if(_0x236336[_0x177f('0x13')]===_0x177f('0x14')){_0x236336[_0x177f('0x13')]=_0x177f('0x15');_0x236336[_0x177f('0x16')]+=','+_0x236336['value'];}else if(_['includes']([_0x177f('0x17'),'$lte'],_0x236336['operator'])){_0x236336[_0x177f('0x16')]=moment(_0x236336['value'])[_0x177f('0x18')](0x1,'days')[_0x177f('0x19')]('YYYY-MM-DD');}}if(_0x236336[_0x177f('0x1a')]){_0x2fbf18=_0x236336[_0x177f('0x1a')];_0x426eb8['text']=_0x177f('0x1b')+_0x40d3e2+'.'+_0x236336['field']+'\x20AS\x20'+_0x236336['castTo']+')\x20'+parseOperator(_0x236336[_0x177f('0x13')]);}else{_0x426eb8[_0x177f('0x1c')]=_0x40d3e2+'.'+_0x236336[_0x177f('0x1d')]+'\x20'+parseOperator(_0x236336[_0x177f('0x13')]);}if(_[_0x177f('0x1e')]([_0x177f('0x1f'),_0x177f('0x20')],_0x236336['operator']))_0x426eb8[_0x177f('0x1c')]='('+_0x426eb8[_0x177f('0x1c')]+_0x177f('0x21')+_0x40d3e2+'.'+_0x236336[_0x177f('0x1d')]+_0x177f('0x22');_0x426eb8[_0x177f('0x16')]=parseValue(_0x2fbf18,_0x236336[_0x177f('0x13')],_0x236336[_0x177f('0x16')]);return _0x426eb8;};function parseOperator(_0xa1d058){var _0x1b63da;switch(_0xa1d058){case _0x177f('0x23'):_0x1b63da='IN\x20?';break;case _0x177f('0x20'):_0x1b63da=_0x177f('0x24');break;case _0x177f('0x14'):_0x1b63da='=\x20?';break;case _0x177f('0x1f'):_0x1b63da='<>\x20?';break;case'$substring':case _0x177f('0x25'):case _0x177f('0x26'):_0x1b63da=_0x177f('0x27');break;case _0x177f('0x28'):_0x1b63da=_0x177f('0x29');break;case _0x177f('0x17'):_0x1b63da='>\x20?';break;case _0x177f('0x2a'):_0x1b63da=_0x177f('0x2b');break;case _0x177f('0x2c'):_0x1b63da=_0x177f('0x2d');break;case'$between':_0x1b63da=_0x177f('0x2e');break;}return _0x1b63da;}function parseValue(_0x1111a0,_0x29b3b9,_0x2b2235){var _0x4218ee={'start':undefined,'end':undefined};switch(_0x29b3b9){case _0x177f('0x23'):case _0x177f('0x20'):_0x4218ee[_0x177f('0x2f')]=_0x2b2235[_0x177f('0x7')](',');break;case'$substring':_0x4218ee[_0x177f('0x2f')]='%'+_0x2b2235+'%';break;case _0x177f('0x25'):_0x4218ee[_0x177f('0x2f')]=_0x2b2235+'%';break;case _0x177f('0x26'):_0x4218ee['start']='%'+_0x2b2235;break;case _0x177f('0x15'):var _0x3623fb=_0x2b2235['split'](',');var _0x2b2235=_0x3623fb['shift']();var _0x56ee8d=_0x3623fb[_0x177f('0x30')]();if(_0x1111a0===_0x177f('0x12')){_0x2b2235=moment(_0x2b2235)['utcOffset'](0x0,!![])['format']();_0x56ee8d=moment(_0x56ee8d)[_0x177f('0x31')](0x0,!![])['add'](0x17,_0x177f('0x32'))[_0x177f('0x18')](0x3b,_0x177f('0x33'))['add'](0x3b,_0x177f('0x34'))['format']();}_0x4218ee={'start':_0x2b2235,'end':_0x56ee8d};break;default:_0x4218ee['start']=_0x2b2235;break;}return _0x4218ee;}
\ No newline at end of file
+var _0x2e52=['match','filter','indexOf','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','$lte','add','days','format','YYYY-MM-DD','castTo','text','CAST(','field','\x20AS\x20','includes','$notIn','\x20OR\x20','$ne','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','$lt','<\x20?','$gt','>\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','$in','start','utcOffset','hours','minutes','seconds','lodash','moment','startsWith','[$or]','replace','[$and]','split','slice','forEach','shift'];(function(_0x4ca2b3,_0x490c1f){var _0x467d59=function(_0x522c72){while(--_0x522c72){_0x4ca2b3['push'](_0x4ca2b3['shift']());}};_0x467d59(++_0x490c1f);}(_0x2e52,0x9b));var _0x22e5=function(_0x243b59,_0x3f9495){_0x243b59=_0x243b59-0x0;var _0x3e1676=_0x2e52[_0x243b59];return _0x3e1676;};'use strict';var _=require(_0x22e5('0x0'));var moment=require(_0x22e5('0x1'));exports['parseSearch']=function(_0x50283d){var _0xd76ab7={'conditions':[]};_0xd76ab7['sqlOperator']=_[_0x22e5('0x2')](_0x50283d,_0x22e5('0x3'))?'or':'and';var _0x4acae2=_0x50283d[_0x22e5('0x4')](_0x22e5('0x5'),'')[_0x22e5('0x4')]('[$or]','')[_0x22e5('0x6')]('||');for(var _0x4a8d05=0x0;_0x4a8d05<_0x4acae2['length'];_0x4a8d05++){var _0x5d8507=_0x4acae2[_0x4a8d05][_0x22e5('0x6')](':=');var _0x2d3994=_0x5d8507[0x0];var _0x28a2d4=_0x5d8507[_0x22e5('0x7')](0x1);_0x28a2d4[_0x22e5('0x8')](function(_0x1ce930){var _0x49a981=_0x1ce930[_0x22e5('0x6')]('[')[_0x22e5('0x9')]();var _0x170305=_0x1ce930[_0x22e5('0xa')](/\[(.*?)\]/g);_0x170305[_0x22e5('0x8')](function(_0x1585d9){var _0x19daf9=_0x1585d9[_0x22e5('0x6')]('[')[_0x22e5('0xb')](function(_0x26b141){return _0x26b141[_0x22e5('0xc')](']')>-0x1;})[_0x22e5('0xd')](function(_0x5b439b){return _0x5b439b[_0x22e5('0x6')](']')[0x0];})[0x0];_0xd76ab7[_0x22e5('0xe')][_0x22e5('0xf')]({'field':_0x2d3994,'operator':_0x49a981,'value':_0x19daf9});});});}return _0xd76ab7;};exports[_0x22e5('0x10')]=function(_0x3a3b4f,_0x4faf07,_0x18f1c6){var _0xa386d6={};if(_0x4faf07===_0x22e5('0x11')){if(_0x18f1c6[_0x22e5('0x12')]===_0x22e5('0x13')){_0x18f1c6[_0x22e5('0x12')]=_0x22e5('0x14');_0x18f1c6[_0x22e5('0x15')]+=','+_0x18f1c6['value'];}else if(_['includes'](['$gt',_0x22e5('0x16')],_0x18f1c6[_0x22e5('0x12')])){_0x18f1c6['value']=moment(_0x18f1c6[_0x22e5('0x15')])[_0x22e5('0x17')](0x1,_0x22e5('0x18'))[_0x22e5('0x19')](_0x22e5('0x1a'));}}if(_0x18f1c6[_0x22e5('0x1b')]){_0x4faf07=_0x18f1c6[_0x22e5('0x1b')];_0xa386d6[_0x22e5('0x1c')]=_0x22e5('0x1d')+_0x3a3b4f+'.'+_0x18f1c6[_0x22e5('0x1e')]+_0x22e5('0x1f')+_0x18f1c6[_0x22e5('0x1b')]+')\x20'+parseOperator(_0x18f1c6[_0x22e5('0x12')]);}else{_0xa386d6[_0x22e5('0x1c')]=_0x3a3b4f+'.'+_0x18f1c6[_0x22e5('0x1e')]+'\x20'+parseOperator(_0x18f1c6[_0x22e5('0x12')]);}if(_[_0x22e5('0x20')](['$ne',_0x22e5('0x21')],_0x18f1c6[_0x22e5('0x12')]))_0xa386d6[_0x22e5('0x1c')]='('+_0xa386d6[_0x22e5('0x1c')]+_0x22e5('0x22')+_0x3a3b4f+'.'+_0x18f1c6['field']+'\x20IS\x20NULL)';_0xa386d6[_0x22e5('0x15')]=parseValue(_0x4faf07,_0x18f1c6[_0x22e5('0x12')],_0x18f1c6['value']);return _0xa386d6;};function parseOperator(_0x5b04d2){var _0x17bd2b;switch(_0x5b04d2){case'$in':_0x17bd2b='IN\x20?';break;case _0x22e5('0x21'):_0x17bd2b='NOT\x20IN\x20?';break;case _0x22e5('0x13'):_0x17bd2b='=\x20?';break;case _0x22e5('0x23'):_0x17bd2b=_0x22e5('0x24');break;case _0x22e5('0x25'):case _0x22e5('0x26'):case _0x22e5('0x27'):_0x17bd2b=_0x22e5('0x28');break;case _0x22e5('0x29'):_0x17bd2b=_0x22e5('0x2a');break;case _0x22e5('0x2b'):_0x17bd2b=_0x22e5('0x2c');break;case'$lte':_0x17bd2b=_0x22e5('0x2d');break;case _0x22e5('0x2e'):_0x17bd2b=_0x22e5('0x2f');break;case _0x22e5('0x14'):_0x17bd2b=_0x22e5('0x30');break;}return _0x17bd2b;}function parseValue(_0xf2d351,_0x4d94e1,_0x2d95cc){var _0x2cbec8={'start':undefined,'end':undefined};switch(_0x4d94e1){case _0x22e5('0x31'):case'$notIn':_0x2cbec8[_0x22e5('0x32')]=_0x2d95cc[_0x22e5('0x6')](',');break;case _0x22e5('0x25'):_0x2cbec8[_0x22e5('0x32')]='%'+_0x2d95cc+'%';break;case _0x22e5('0x26'):_0x2cbec8['start']=_0x2d95cc+'%';break;case _0x22e5('0x27'):_0x2cbec8[_0x22e5('0x32')]='%'+_0x2d95cc;break;case _0x22e5('0x14'):var _0x4e218c=_0x2d95cc[_0x22e5('0x6')](',');var _0x2d95cc=_0x4e218c[_0x22e5('0x9')]();var _0x88a20a=_0x4e218c['pop']();if(_0xf2d351===_0x22e5('0x11')){_0x2d95cc=moment(_0x2d95cc)[_0x22e5('0x33')](0x0,!![])[_0x22e5('0x19')]();_0x88a20a=moment(_0x88a20a)['utcOffset'](0x0,!![])[_0x22e5('0x17')](0x17,_0x22e5('0x34'))[_0x22e5('0x17')](0x3b,_0x22e5('0x35'))[_0x22e5('0x17')](0x3b,_0x22e5('0x36'))[_0x22e5('0x19')]();}_0x2cbec8={'start':_0x2d95cc,'end':_0x88a20a};break;default:_0x2cbec8['start']=_0x2d95cc;break;}return _0x2cbec8;}
\ No newline at end of file