Built motion from commit d69f4380.|2.6.29
[motion2.git] / server / components / parsers / advancedSearch.js
index 38f93d0..ad6530d 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xaf8c=['$startsWith','$endsWith','LIKE\x20?','<\x20?','>\x20?','<=\x20?','$gte','>=\x20?','start','pop','utcOffset','hours','seconds','lodash','moment','parseSearch','sqlOperator','startsWith','[$or]','and','replace','[$and]','split','length','slice','forEach','shift','match','filter','indexOf','map','conditions','push','buildExpression','DATE','operator','$between','value','includes','$gt','$lte','add','format','YYYY-MM-DD','castTo','text','field','\x20AS\x20','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','$eq','=\x20?','$substring'];(function(_0x59d648,_0x2e87bd){var _0x45b2c2=function(_0x59c5eb){while(--_0x59c5eb){_0x59d648['push'](_0x59d648['shift']());}};_0x45b2c2(++_0x2e87bd);}(_0xaf8c,0x1dd));var _0xcaf8=function(_0x3fa8ff,_0x2e3165){_0x3fa8ff=_0x3fa8ff-0x0;var _0x125641=_0xaf8c[_0x3fa8ff];return _0x125641;};'use strict';var _=require(_0xcaf8('0x0'));var moment=require(_0xcaf8('0x1'));exports[_0xcaf8('0x2')]=function(_0x25121b){var _0x469eff={'conditions':[]};_0x469eff[_0xcaf8('0x3')]=_[_0xcaf8('0x4')](_0x25121b,_0xcaf8('0x5'))?'or':_0xcaf8('0x6');var _0x537437=_0x25121b[_0xcaf8('0x7')](_0xcaf8('0x8'),'')[_0xcaf8('0x7')](_0xcaf8('0x5'),'')[_0xcaf8('0x9')]('||');for(var _0x19568b=0x0;_0x19568b<_0x537437[_0xcaf8('0xa')];_0x19568b++){var _0x38db01=_0x537437[_0x19568b][_0xcaf8('0x9')](':=');var _0x1cb426=_0x38db01[0x0];var _0x2f8c35=_0x38db01[_0xcaf8('0xb')](0x1);_0x2f8c35[_0xcaf8('0xc')](function(_0x190b3a){var _0x117965=_0x190b3a[_0xcaf8('0x9')]('[')[_0xcaf8('0xd')]();var _0x1a4d0a=_0x190b3a[_0xcaf8('0xe')](/\[(.*?)\]/g);_0x1a4d0a[_0xcaf8('0xc')](function(_0x3a11af){var _0x436afd=_0x3a11af[_0xcaf8('0x9')]('[')[_0xcaf8('0xf')](function(_0x5fd98b){return _0x5fd98b[_0xcaf8('0x10')](']')>-0x1;})[_0xcaf8('0x11')](function(_0x308cce){return _0x308cce[_0xcaf8('0x9')](']')[0x0];})[0x0];_0x469eff[_0xcaf8('0x12')][_0xcaf8('0x13')]({'field':_0x1cb426,'operator':_0x117965,'value':_0x436afd});});});}return _0x469eff;};exports[_0xcaf8('0x14')]=function(_0x3f9279,_0xdfc285,_0x2c6d19){var _0x4bb048={};if(_0xdfc285===_0xcaf8('0x15')){if(_0x2c6d19['operator']==='$eq'){_0x2c6d19[_0xcaf8('0x16')]=_0xcaf8('0x17');_0x2c6d19[_0xcaf8('0x18')]+=','+_0x2c6d19[_0xcaf8('0x18')];}else if(_[_0xcaf8('0x19')]([_0xcaf8('0x1a'),_0xcaf8('0x1b')],_0x2c6d19[_0xcaf8('0x16')])){_0x2c6d19[_0xcaf8('0x18')]=moment(_0x2c6d19['value'])[_0xcaf8('0x1c')](0x1,'days')[_0xcaf8('0x1d')](_0xcaf8('0x1e'));}}if(_0x2c6d19['castTo']){_0xdfc285=_0x2c6d19[_0xcaf8('0x1f')];_0x4bb048[_0xcaf8('0x20')]='CAST('+_0x3f9279+'.'+_0x2c6d19[_0xcaf8('0x21')]+_0xcaf8('0x22')+_0x2c6d19[_0xcaf8('0x1f')]+')\x20'+parseOperator(_0x2c6d19[_0xcaf8('0x16')]);}else{_0x4bb048['text']=_0x3f9279+'.'+_0x2c6d19[_0xcaf8('0x21')]+'\x20'+parseOperator(_0x2c6d19[_0xcaf8('0x16')]);}if(_['includes']([_0xcaf8('0x23'),_0xcaf8('0x24')],_0x2c6d19[_0xcaf8('0x16')]))_0x4bb048[_0xcaf8('0x20')]='('+_0x4bb048[_0xcaf8('0x20')]+_0xcaf8('0x25')+_0x3f9279+'.'+_0x2c6d19[_0xcaf8('0x21')]+_0xcaf8('0x26');_0x4bb048[_0xcaf8('0x18')]=parseValue(_0xdfc285,_0x2c6d19[_0xcaf8('0x16')],_0x2c6d19[_0xcaf8('0x18')]);return _0x4bb048;};function parseOperator(_0xf1b649){var _0x34a021;switch(_0xf1b649){case _0xcaf8('0x27'):_0x34a021=_0xcaf8('0x28');break;case _0xcaf8('0x24'):_0x34a021=_0xcaf8('0x29');break;case _0xcaf8('0x2a'):_0x34a021=_0xcaf8('0x2b');break;case _0xcaf8('0x23'):_0x34a021='<>\x20?';break;case _0xcaf8('0x2c'):case _0xcaf8('0x2d'):case _0xcaf8('0x2e'):_0x34a021=_0xcaf8('0x2f');break;case'$lt':_0x34a021=_0xcaf8('0x30');break;case _0xcaf8('0x1a'):_0x34a021=_0xcaf8('0x31');break;case _0xcaf8('0x1b'):_0x34a021=_0xcaf8('0x32');break;case _0xcaf8('0x33'):_0x34a021=_0xcaf8('0x34');break;case _0xcaf8('0x17'):_0x34a021='BETWEEN\x20?\x20AND\x20?';break;}return _0x34a021;}function parseValue(_0x1acd80,_0x426d67,_0x379992){var _0x375787={'start':undefined,'end':undefined};switch(_0x426d67){case _0xcaf8('0x27'):case _0xcaf8('0x24'):_0x375787[_0xcaf8('0x35')]=_0x379992['split'](',');break;case'$substring':_0x375787[_0xcaf8('0x35')]='%'+_0x379992+'%';break;case _0xcaf8('0x2d'):_0x375787[_0xcaf8('0x35')]=_0x379992+'%';break;case _0xcaf8('0x2e'):_0x375787[_0xcaf8('0x35')]='%'+_0x379992;break;case _0xcaf8('0x17'):var _0x4232d4=_0x379992['split'](',');var _0x379992=_0x4232d4[_0xcaf8('0xd')]();var _0xaf9cdd=_0x4232d4[_0xcaf8('0x36')]();if(_0x1acd80===_0xcaf8('0x15')){_0x379992=moment(_0x379992)['utcOffset'](0x0,!![])[_0xcaf8('0x1d')]();_0xaf9cdd=moment(_0xaf9cdd)[_0xcaf8('0x37')](0x0,!![])[_0xcaf8('0x1c')](0x17,_0xcaf8('0x38'))['add'](0x3b,'minutes')['add'](0x3b,_0xcaf8('0x39'))[_0xcaf8('0x1d')]();}_0x375787={'start':_0x379992,'end':_0xaf9cdd};break;default:_0x375787[_0xcaf8('0x35')]=_0x379992;break;}return _0x375787;}
\ No newline at end of file
+var _0x18a3=['sqlOperator','startsWith','[$or]','and','[$and]','length','split','shift','match','filter','indexOf','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','$gt','$lte','add','days','format','YYYY-MM-DD','castTo','text','field','includes','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','=\x20?','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','$lt','>\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','pop','utcOffset','hours','minutes','seconds','lodash','moment','parseSearch'];(function(_0x5ee73b,_0x282c4c){var _0x22948a=function(_0x4bb79b){while(--_0x4bb79b){_0x5ee73b['push'](_0x5ee73b['shift']());}};_0x22948a(++_0x282c4c);}(_0x18a3,0x18c));var _0x318a=function(_0x19b938,_0x21bc0f){_0x19b938=_0x19b938-0x0;var _0x530b12=_0x18a3[_0x19b938];return _0x530b12;};'use strict';var _=require(_0x318a('0x0'));var moment=require(_0x318a('0x1'));exports[_0x318a('0x2')]=function(_0x58336a){var _0x2d86af={'conditions':[]};_0x2d86af[_0x318a('0x3')]=_[_0x318a('0x4')](_0x58336a,_0x318a('0x5'))?'or':_0x318a('0x6');var _0x145590=_0x58336a['replace'](_0x318a('0x7'),'')['replace'](_0x318a('0x5'),'')['split']('||');for(var _0x1f1a86=0x0;_0x1f1a86<_0x145590[_0x318a('0x8')];_0x1f1a86++){var _0x220151=_0x145590[_0x1f1a86][_0x318a('0x9')](':=');var _0x51fc9d=_0x220151[0x0];var _0x46e965=_0x220151['slice'](0x1);_0x46e965['forEach'](function(_0xf88ec){var _0x26131b=_0xf88ec[_0x318a('0x9')]('[')[_0x318a('0xa')]();var _0x2d686a=_0xf88ec[_0x318a('0xb')](/\[(.*?)\]/g);_0x2d686a['forEach'](function(_0x26e127){var _0x33125d=_0x26e127[_0x318a('0x9')]('[')[_0x318a('0xc')](function(_0x68e98a){return _0x68e98a[_0x318a('0xd')](']')>-0x1;})[_0x318a('0xe')](function(_0x218548){return _0x218548['split'](']')[0x0];})[0x0];_0x2d86af[_0x318a('0xf')][_0x318a('0x10')]({'field':_0x51fc9d,'operator':_0x26131b,'value':_0x33125d});});});}return _0x2d86af;};exports[_0x318a('0x11')]=function(_0x148a83,_0x250d23,_0x517f64){var _0x16ebda={};if(_0x250d23===_0x318a('0x12')){if(_0x517f64[_0x318a('0x13')]===_0x318a('0x14')){_0x517f64['operator']=_0x318a('0x15');_0x517f64['value']+=','+_0x517f64[_0x318a('0x16')];}else if(_['includes']([_0x318a('0x17'),_0x318a('0x18')],_0x517f64[_0x318a('0x13')])){_0x517f64[_0x318a('0x16')]=moment(_0x517f64[_0x318a('0x16')])[_0x318a('0x19')](0x1,_0x318a('0x1a'))[_0x318a('0x1b')](_0x318a('0x1c'));}}if(_0x517f64[_0x318a('0x1d')]){_0x250d23=_0x517f64[_0x318a('0x1d')];_0x16ebda[_0x318a('0x1e')]='CAST('+_0x148a83+'.'+_0x517f64[_0x318a('0x1f')]+'\x20AS\x20'+_0x517f64[_0x318a('0x1d')]+')\x20'+parseOperator(_0x517f64[_0x318a('0x13')]);}else{_0x16ebda[_0x318a('0x1e')]=_0x148a83+'.'+_0x517f64['field']+'\x20'+parseOperator(_0x517f64[_0x318a('0x13')]);}if(_[_0x318a('0x20')]([_0x318a('0x21'),_0x318a('0x22')],_0x517f64['operator']))_0x16ebda[_0x318a('0x1e')]='('+_0x16ebda['text']+_0x318a('0x23')+_0x148a83+'.'+_0x517f64[_0x318a('0x1f')]+_0x318a('0x24');_0x16ebda[_0x318a('0x16')]=parseValue(_0x250d23,_0x517f64[_0x318a('0x13')],_0x517f64[_0x318a('0x16')]);return _0x16ebda;};function parseOperator(_0x5d9c0b){var _0x3538b9;switch(_0x5d9c0b){case _0x318a('0x25'):_0x3538b9=_0x318a('0x26');break;case'$notIn':_0x3538b9='NOT\x20IN\x20?';break;case _0x318a('0x14'):_0x3538b9=_0x318a('0x27');break;case _0x318a('0x21'):_0x3538b9=_0x318a('0x28');break;case _0x318a('0x29'):case _0x318a('0x2a'):case _0x318a('0x2b'):_0x3538b9=_0x318a('0x2c');break;case _0x318a('0x2d'):_0x3538b9='<\x20?';break;case _0x318a('0x17'):_0x3538b9=_0x318a('0x2e');break;case _0x318a('0x18'):_0x3538b9=_0x318a('0x2f');break;case _0x318a('0x30'):_0x3538b9=_0x318a('0x31');break;case _0x318a('0x15'):_0x3538b9=_0x318a('0x32');break;}return _0x3538b9;}function parseValue(_0x179f41,_0x471cdd,_0x32d461){var _0x1acab7={'start':undefined,'end':undefined};switch(_0x471cdd){case _0x318a('0x25'):case _0x318a('0x22'):_0x1acab7[_0x318a('0x33')]=_0x32d461[_0x318a('0x9')](',');break;case _0x318a('0x29'):_0x1acab7[_0x318a('0x33')]='%'+_0x32d461+'%';break;case'$startsWith':_0x1acab7[_0x318a('0x33')]=_0x32d461+'%';break;case _0x318a('0x2b'):_0x1acab7['start']='%'+_0x32d461;break;case _0x318a('0x15'):var _0x1c0dde=_0x32d461[_0x318a('0x9')](',');var _0x32d461=_0x1c0dde['shift']();var _0x2a4fc9=_0x1c0dde[_0x318a('0x34')]();if(_0x179f41===_0x318a('0x12')){_0x32d461=moment(_0x32d461)[_0x318a('0x35')](0x0,!![])[_0x318a('0x1b')]();_0x2a4fc9=moment(_0x2a4fc9)[_0x318a('0x35')](0x0,!![])[_0x318a('0x19')](0x17,_0x318a('0x36'))['add'](0x3b,_0x318a('0x37'))['add'](0x3b,_0x318a('0x38'))[_0x318a('0x1b')]();}_0x1acab7={'start':_0x32d461,'end':_0x2a4fc9};break;default:_0x1acab7['start']=_0x32d461;break;}return _0x1acab7;}
\ No newline at end of file