Built motion from commit 9e1ec266.|2.6.28
[motion2.git] / server / components / parsers / advancedSearch.js
index 4b5f3d9..bdfb21e 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x9624=['push','DATE','operator','$eq','value','includes','$gt','add','days','format','castTo','text','field','$ne','$notIn','\x20OR\x20','$in','IN\x20?','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','$lt','<\x20?','>\x20?','$lte','<=\x20?','$gte','>=\x20?','$between','BETWEEN\x20?\x20AND\x20?','start','pop','utcOffset','hours','minutes','seconds','lodash','moment','parseSearch','sqlOperator','startsWith','[$or]','replace','[$and]','split','length','slice','forEach','shift','match','filter','indexOf','conditions'];(function(_0x36fc16,_0x3d6e94){var _0xe02e16=function(_0x244371){while(--_0x244371){_0x36fc16['push'](_0x36fc16['shift']());}};_0xe02e16(++_0x3d6e94);}(_0x9624,0xcb));var _0x4962=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x9624[_0x3dd15e];return _0x231fd0;};'use strict';var _=require(_0x4962('0x0'));var moment=require(_0x4962('0x1'));exports[_0x4962('0x2')]=function(_0x3f6143){var _0x31ab6f={'conditions':[]};_0x31ab6f[_0x4962('0x3')]=_[_0x4962('0x4')](_0x3f6143,_0x4962('0x5'))?'or':'and';var _0x361b04=_0x3f6143[_0x4962('0x6')](_0x4962('0x7'),'')[_0x4962('0x6')]('[$or]','')[_0x4962('0x8')]('||');for(var _0x34a249=0x0;_0x34a249<_0x361b04[_0x4962('0x9')];_0x34a249++){var _0xe6c5f1=_0x361b04[_0x34a249][_0x4962('0x8')](':=');var _0x57935d=_0xe6c5f1[0x0];var _0x1a244f=_0xe6c5f1[_0x4962('0xa')](0x1);_0x1a244f[_0x4962('0xb')](function(_0x462376){var _0x3328b6=_0x462376[_0x4962('0x8')]('[')[_0x4962('0xc')]();var _0x20e824=_0x462376[_0x4962('0xd')](/\[(.*?)\]/g);_0x20e824[_0x4962('0xb')](function(_0xd237f3){var _0xd2e189=_0xd237f3[_0x4962('0x8')]('[')[_0x4962('0xe')](function(_0x4079b2){return _0x4079b2[_0x4962('0xf')](']')>-0x1;})['map'](function(_0x2a513c){return _0x2a513c[_0x4962('0x8')](']')[0x0];})[0x0];_0x31ab6f[_0x4962('0x10')][_0x4962('0x11')]({'field':_0x57935d,'operator':_0x3328b6,'value':_0xd2e189});});});}return _0x31ab6f;};exports['buildExpression']=function(_0x50d819,_0x52978d,_0x183419){var _0xff5e41={};if(_0x52978d===_0x4962('0x12')){if(_0x183419[_0x4962('0x13')]===_0x4962('0x14')){_0x183419[_0x4962('0x13')]='$between';_0x183419[_0x4962('0x15')]+=','+_0x183419[_0x4962('0x15')];}else if(_[_0x4962('0x16')]([_0x4962('0x17'),'$lte'],_0x183419[_0x4962('0x13')])){_0x183419[_0x4962('0x15')]=moment(_0x183419[_0x4962('0x15')])[_0x4962('0x18')](0x1,_0x4962('0x19'))[_0x4962('0x1a')]('YYYY-MM-DD');}}if(_0x183419[_0x4962('0x1b')]){_0x52978d=_0x183419['castTo'];_0xff5e41[_0x4962('0x1c')]='CAST('+_0x50d819+'.'+_0x183419[_0x4962('0x1d')]+'\x20AS\x20'+_0x183419['castTo']+')\x20'+parseOperator(_0x183419[_0x4962('0x13')]);}else{_0xff5e41['text']=_0x50d819+'.'+_0x183419['field']+'\x20'+parseOperator(_0x183419[_0x4962('0x13')]);}if(_['includes']([_0x4962('0x1e'),_0x4962('0x1f')],_0x183419[_0x4962('0x13')]))_0xff5e41['text']='('+_0xff5e41[_0x4962('0x1c')]+_0x4962('0x20')+_0x50d819+'.'+_0x183419[_0x4962('0x1d')]+'\x20IS\x20NULL)';_0xff5e41[_0x4962('0x15')]=parseValue(_0x52978d,_0x183419[_0x4962('0x13')],_0x183419[_0x4962('0x15')]);return _0xff5e41;};function parseOperator(_0x3c003a){var _0x4505b1;switch(_0x3c003a){case _0x4962('0x21'):_0x4505b1=_0x4962('0x22');break;case'$notIn':_0x4505b1='NOT\x20IN\x20?';break;case _0x4962('0x14'):_0x4505b1='=\x20?';break;case _0x4962('0x1e'):_0x4505b1=_0x4962('0x23');break;case _0x4962('0x24'):case _0x4962('0x25'):case _0x4962('0x26'):_0x4505b1=_0x4962('0x27');break;case _0x4962('0x28'):_0x4505b1=_0x4962('0x29');break;case'$gt':_0x4505b1=_0x4962('0x2a');break;case _0x4962('0x2b'):_0x4505b1=_0x4962('0x2c');break;case _0x4962('0x2d'):_0x4505b1=_0x4962('0x2e');break;case _0x4962('0x2f'):_0x4505b1=_0x4962('0x30');break;}return _0x4505b1;}function parseValue(_0x1b0c1b,_0x1bb189,_0x2a6874){var _0x3a6818={'start':undefined,'end':undefined};switch(_0x1bb189){case _0x4962('0x21'):case _0x4962('0x1f'):_0x3a6818[_0x4962('0x31')]=_0x2a6874[_0x4962('0x8')](',');break;case _0x4962('0x24'):_0x3a6818['start']='%'+_0x2a6874+'%';break;case _0x4962('0x25'):_0x3a6818[_0x4962('0x31')]=_0x2a6874+'%';break;case'$endsWith':_0x3a6818['start']='%'+_0x2a6874;break;case _0x4962('0x2f'):var _0x2f22f7=_0x2a6874[_0x4962('0x8')](',');var _0x2a6874=_0x2f22f7['shift']();var _0x3b6be6=_0x2f22f7[_0x4962('0x32')]();if(_0x1b0c1b===_0x4962('0x12')){_0x2a6874=moment(_0x2a6874)[_0x4962('0x33')](0x0,!![])['format']();_0x3b6be6=moment(_0x3b6be6)['utcOffset'](0x0,!![])[_0x4962('0x18')](0x17,_0x4962('0x34'))[_0x4962('0x18')](0x3b,_0x4962('0x35'))[_0x4962('0x18')](0x3b,_0x4962('0x36'))[_0x4962('0x1a')]();}_0x3a6818={'start':_0x2a6874,'end':_0x3b6be6};break;default:_0x3a6818['start']=_0x2a6874;break;}return _0x3a6818;}
\ No newline at end of file
+var _0xb72e=['map','conditions','push','$eq','operator','value','$gt','$lte','days','format','castTo','text','CAST(','field','\x20AS\x20','includes','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','$startsWith','$endsWith','LIKE\x20?','<\x20?','>\x20?','>=\x20?','start','$substring','$between','DATE','utcOffset','add','hours','minutes','seconds','lodash','moment','parseSearch','sqlOperator','startsWith','[$or]','and','replace','[$and]','split','length','forEach','shift','match','filter','indexOf'];(function(_0x57fa33,_0x2b8222){var _0x12e724=function(_0x481a33){while(--_0x481a33){_0x57fa33['push'](_0x57fa33['shift']());}};_0x12e724(++_0x2b8222);}(_0xb72e,0xfe));var _0xeb72=function(_0x1a22e9,_0x4b0a43){_0x1a22e9=_0x1a22e9-0x0;var _0x3a0f93=_0xb72e[_0x1a22e9];return _0x3a0f93;};'use strict';var _=require(_0xeb72('0x0'));var moment=require(_0xeb72('0x1'));exports[_0xeb72('0x2')]=function(_0x471fe9){var _0x3d6c98={'conditions':[]};_0x3d6c98[_0xeb72('0x3')]=_[_0xeb72('0x4')](_0x471fe9,_0xeb72('0x5'))?'or':_0xeb72('0x6');var _0x5f237a=_0x471fe9[_0xeb72('0x7')](_0xeb72('0x8'),'')[_0xeb72('0x7')](_0xeb72('0x5'),'')[_0xeb72('0x9')]('||');for(var _0x2586af=0x0;_0x2586af<_0x5f237a[_0xeb72('0xa')];_0x2586af++){var _0x384522=_0x5f237a[_0x2586af][_0xeb72('0x9')](':=');var _0x47b0f0=_0x384522[0x0];var _0x2160dc=_0x384522['slice'](0x1);_0x2160dc[_0xeb72('0xb')](function(_0x475afc){var _0x151022=_0x475afc[_0xeb72('0x9')]('[')[_0xeb72('0xc')]();var _0x402d83=_0x475afc[_0xeb72('0xd')](/\[(.*?)\]/g);_0x402d83[_0xeb72('0xb')](function(_0xf05b22){var _0x3a072e=_0xf05b22[_0xeb72('0x9')]('[')[_0xeb72('0xe')](function(_0x158db3){return _0x158db3[_0xeb72('0xf')](']')>-0x1;})[_0xeb72('0x10')](function(_0x2ef2d8){return _0x2ef2d8[_0xeb72('0x9')](']')[0x0];})[0x0];_0x3d6c98[_0xeb72('0x11')][_0xeb72('0x12')]({'field':_0x47b0f0,'operator':_0x151022,'value':_0x3a072e});});});}return _0x3d6c98;};exports['buildExpression']=function(_0xc2e573,_0x4cb959,_0x3f2b81){var _0x1b43b4={};if(_0x4cb959==='DATE'){if(_0x3f2b81['operator']===_0xeb72('0x13')){_0x3f2b81[_0xeb72('0x14')]='$between';_0x3f2b81[_0xeb72('0x15')]+=','+_0x3f2b81[_0xeb72('0x15')];}else if(_['includes']([_0xeb72('0x16'),_0xeb72('0x17')],_0x3f2b81[_0xeb72('0x14')])){_0x3f2b81[_0xeb72('0x15')]=moment(_0x3f2b81[_0xeb72('0x15')])['add'](0x1,_0xeb72('0x18'))[_0xeb72('0x19')]('YYYY-MM-DD');}}if(_0x3f2b81['castTo']){_0x4cb959=_0x3f2b81[_0xeb72('0x1a')];_0x1b43b4[_0xeb72('0x1b')]=_0xeb72('0x1c')+_0xc2e573+'.'+_0x3f2b81[_0xeb72('0x1d')]+_0xeb72('0x1e')+_0x3f2b81['castTo']+')\x20'+parseOperator(_0x3f2b81[_0xeb72('0x14')]);}else{_0x1b43b4[_0xeb72('0x1b')]=_0xc2e573+'.'+_0x3f2b81['field']+'\x20'+parseOperator(_0x3f2b81[_0xeb72('0x14')]);}if(_[_0xeb72('0x1f')]([_0xeb72('0x20'),_0xeb72('0x21')],_0x3f2b81['operator']))_0x1b43b4['text']='('+_0x1b43b4[_0xeb72('0x1b')]+_0xeb72('0x22')+_0xc2e573+'.'+_0x3f2b81[_0xeb72('0x1d')]+_0xeb72('0x23');_0x1b43b4[_0xeb72('0x15')]=parseValue(_0x4cb959,_0x3f2b81['operator'],_0x3f2b81['value']);return _0x1b43b4;};function parseOperator(_0x23ba39){var _0x754048;switch(_0x23ba39){case _0xeb72('0x24'):_0x754048=_0xeb72('0x25');break;case _0xeb72('0x21'):_0x754048=_0xeb72('0x26');break;case'$eq':_0x754048='=\x20?';break;case _0xeb72('0x20'):_0x754048='<>\x20?';break;case'$substring':case _0xeb72('0x27'):case _0xeb72('0x28'):_0x754048=_0xeb72('0x29');break;case'$lt':_0x754048=_0xeb72('0x2a');break;case _0xeb72('0x16'):_0x754048=_0xeb72('0x2b');break;case'$lte':_0x754048='<=\x20?';break;case'$gte':_0x754048=_0xeb72('0x2c');break;case'$between':_0x754048='BETWEEN\x20?\x20AND\x20?';break;}return _0x754048;}function parseValue(_0x491440,_0x1ad5d9,_0x33f30d){var _0x32dd43={'start':undefined,'end':undefined};switch(_0x1ad5d9){case _0xeb72('0x24'):case'$notIn':_0x32dd43[_0xeb72('0x2d')]=_0x33f30d['split'](',');break;case _0xeb72('0x2e'):_0x32dd43[_0xeb72('0x2d')]='%'+_0x33f30d+'%';break;case _0xeb72('0x27'):_0x32dd43[_0xeb72('0x2d')]=_0x33f30d+'%';break;case _0xeb72('0x28'):_0x32dd43[_0xeb72('0x2d')]='%'+_0x33f30d;break;case _0xeb72('0x2f'):var _0x56d6c5=_0x33f30d[_0xeb72('0x9')](',');var _0x33f30d=_0x56d6c5[_0xeb72('0xc')]();var _0x363ff0=_0x56d6c5['pop']();if(_0x491440===_0xeb72('0x30')){_0x33f30d=moment(_0x33f30d)['utcOffset'](0x0,!![])[_0xeb72('0x19')]();_0x363ff0=moment(_0x363ff0)[_0xeb72('0x31')](0x0,!![])[_0xeb72('0x32')](0x17,_0xeb72('0x33'))[_0xeb72('0x32')](0x3b,_0xeb72('0x34'))['add'](0x3b,_0xeb72('0x35'))[_0xeb72('0x19')]();}_0x32dd43={'start':_0x33f30d,'end':_0x363ff0};break;default:_0x32dd43[_0xeb72('0x2d')]=_0x33f30d;break;}return _0x32dd43;}
\ No newline at end of file