Built motion from commit a8c4dd89.|2.6.33
[motion2.git] / server / components / parsers / advancedSearch.js
index d42cd5f..d6cd0a9 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x33a8=['$lt','<\x20?','>\x20?','<=\x20?','>=\x20?','start','pop','utcOffset','format','hours','minutes','seconds','moment','startsWith','[$or]','and','replace','[$and]','length','split','forEach','indexOf','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','includes','$gt','$lte','add','castTo','text','field','$ne','$notIn','\x20IS\x20NULL)','$in','IN\x20?','=\x20?','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?'];(function(_0x3cb474,_0x1e6ff7){var _0x615b3a=function(_0x192f5a){while(--_0x192f5a){_0x3cb474['push'](_0x3cb474['shift']());}};_0x615b3a(++_0x1e6ff7);}(_0x33a8,0x163));var _0x833a=function(_0x51ed21,_0x54b194){_0x51ed21=_0x51ed21-0x0;var _0x1ac433=_0x33a8[_0x51ed21];return _0x1ac433;};'use strict';var _=require('lodash');var moment=require(_0x833a('0x0'));exports['parseSearch']=function(_0x465ac7){var _0x3ecec0={'conditions':[]};_0x3ecec0['sqlOperator']=_[_0x833a('0x1')](_0x465ac7,_0x833a('0x2'))?'or':_0x833a('0x3');var _0x23813b=_0x465ac7[_0x833a('0x4')](_0x833a('0x5'),'')[_0x833a('0x4')](_0x833a('0x2'),'')['split']('||');for(var _0xb24719=0x0;_0xb24719<_0x23813b[_0x833a('0x6')];_0xb24719++){var _0x53b395=_0x23813b[_0xb24719][_0x833a('0x7')](':=');var _0x56c1fb=_0x53b395[0x0];var _0xe478fd=_0x53b395['slice'](0x1);_0xe478fd[_0x833a('0x8')](function(_0x3e51e7){var _0x44bfff=_0x3e51e7[_0x833a('0x7')]('[')['shift']();var _0x56db1c=_0x3e51e7['match'](/\[(.*?)\]/g);_0x56db1c[_0x833a('0x8')](function(_0x118946){var _0x9c5fac=_0x118946['split']('[')['filter'](function(_0x515bb1){return _0x515bb1[_0x833a('0x9')](']')>-0x1;})[_0x833a('0xa')](function(_0x3a4db3){return _0x3a4db3[_0x833a('0x7')](']')[0x0];})[0x0];_0x3ecec0[_0x833a('0xb')][_0x833a('0xc')]({'field':_0x56c1fb,'operator':_0x44bfff,'value':_0x9c5fac});});});}return _0x3ecec0;};exports[_0x833a('0xd')]=function(_0x14279e,_0x5e8d5b,_0x4b6f4b){var _0x5062fd={};if(_0x5e8d5b===_0x833a('0xe')){if(_0x4b6f4b[_0x833a('0xf')]===_0x833a('0x10')){_0x4b6f4b[_0x833a('0xf')]=_0x833a('0x11');_0x4b6f4b['value']+=','+_0x4b6f4b[_0x833a('0x12')];}else if(_[_0x833a('0x13')]([_0x833a('0x14'),_0x833a('0x15')],_0x4b6f4b[_0x833a('0xf')])){_0x4b6f4b[_0x833a('0x12')]=moment(_0x4b6f4b[_0x833a('0x12')])[_0x833a('0x16')](0x1,'days')['format']('YYYY-MM-DD');}}if(_0x4b6f4b['castTo']){_0x5e8d5b=_0x4b6f4b[_0x833a('0x17')];_0x5062fd[_0x833a('0x18')]='CAST('+_0x14279e+'.'+_0x4b6f4b[_0x833a('0x19')]+'\x20AS\x20'+_0x4b6f4b[_0x833a('0x17')]+')\x20'+parseOperator(_0x4b6f4b[_0x833a('0xf')]);}else{_0x5062fd[_0x833a('0x18')]=_0x14279e+'.'+_0x4b6f4b[_0x833a('0x19')]+'\x20'+parseOperator(_0x4b6f4b[_0x833a('0xf')]);}if(_[_0x833a('0x13')]([_0x833a('0x1a'),_0x833a('0x1b')],_0x4b6f4b[_0x833a('0xf')]))_0x5062fd[_0x833a('0x18')]='('+_0x5062fd['text']+'\x20OR\x20'+_0x14279e+'.'+_0x4b6f4b['field']+_0x833a('0x1c');_0x5062fd[_0x833a('0x12')]=parseValue(_0x5e8d5b,_0x4b6f4b[_0x833a('0xf')],_0x4b6f4b[_0x833a('0x12')]);return _0x5062fd;};function parseOperator(_0x10f8a2){var _0x5c6b68;switch(_0x10f8a2){case _0x833a('0x1d'):_0x5c6b68=_0x833a('0x1e');break;case _0x833a('0x1b'):_0x5c6b68='NOT\x20IN\x20?';break;case _0x833a('0x10'):_0x5c6b68=_0x833a('0x1f');break;case _0x833a('0x1a'):_0x5c6b68=_0x833a('0x20');break;case _0x833a('0x21'):case _0x833a('0x22'):case _0x833a('0x23'):_0x5c6b68=_0x833a('0x24');break;case _0x833a('0x25'):_0x5c6b68=_0x833a('0x26');break;case _0x833a('0x14'):_0x5c6b68=_0x833a('0x27');break;case _0x833a('0x15'):_0x5c6b68=_0x833a('0x28');break;case'$gte':_0x5c6b68=_0x833a('0x29');break;case'$between':_0x5c6b68='BETWEEN\x20?\x20AND\x20?';break;}return _0x5c6b68;}function parseValue(_0x4778e2,_0x44babe,_0x32526e){var _0x58d9fc={'start':undefined,'end':undefined};switch(_0x44babe){case _0x833a('0x1d'):case _0x833a('0x1b'):_0x58d9fc['start']=_0x32526e[_0x833a('0x7')](',');break;case _0x833a('0x21'):_0x58d9fc[_0x833a('0x2a')]='%'+_0x32526e+'%';break;case _0x833a('0x22'):_0x58d9fc[_0x833a('0x2a')]=_0x32526e+'%';break;case _0x833a('0x23'):_0x58d9fc[_0x833a('0x2a')]='%'+_0x32526e;break;case _0x833a('0x11'):var _0x29fa92=_0x32526e[_0x833a('0x7')](',');var _0x32526e=_0x29fa92['shift']();var _0x3760f1=_0x29fa92[_0x833a('0x2b')]();if(_0x4778e2===_0x833a('0xe')){_0x32526e=moment(_0x32526e)[_0x833a('0x2c')](0x0,!![])[_0x833a('0x2d')]();_0x3760f1=moment(_0x3760f1)[_0x833a('0x2c')](0x0,!![])[_0x833a('0x16')](0x17,_0x833a('0x2e'))['add'](0x3b,_0x833a('0x2f'))[_0x833a('0x16')](0x3b,_0x833a('0x30'))[_0x833a('0x2d')]();}_0x58d9fc={'start':_0x32526e,'end':_0x3760f1};break;default:_0x58d9fc[_0x833a('0x2a')]=_0x32526e;break;}return _0x58d9fc;}
\ No newline at end of file
+var _0xbb81=['days','format','YYYY-MM-DD','castTo','text','CAST(','field','\x20AS\x20','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','$eq','<>\x20?','$substring','LIKE\x20?','$lt','<\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','$startsWith','$between','utcOffset','hours','seconds','lodash','moment','parseSearch','startsWith','and','replace','[$or]','split','slice','forEach','shift','match','filter','indexOf','map','push','buildExpression','DATE','operator','value','includes','$gt','$lte','add'];(function(_0x489291,_0x3f78a8){var _0x2935f1=function(_0x129be3){while(--_0x129be3){_0x489291['push'](_0x489291['shift']());}};_0x2935f1(++_0x3f78a8);}(_0xbb81,0x126));var _0x1bb8=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xbb81[_0x3dd15e];return _0x231fd0;};'use strict';var _=require(_0x1bb8('0x0'));var moment=require(_0x1bb8('0x1'));exports[_0x1bb8('0x2')]=function(_0x201c28){var _0x192248={'conditions':[]};_0x192248['sqlOperator']=_[_0x1bb8('0x3')](_0x201c28,'[$or]')?'or':_0x1bb8('0x4');var _0x457ac1=_0x201c28[_0x1bb8('0x5')]('[$and]','')[_0x1bb8('0x5')](_0x1bb8('0x6'),'')[_0x1bb8('0x7')]('||');for(var _0x1bf88d=0x0;_0x1bf88d<_0x457ac1['length'];_0x1bf88d++){var _0x127069=_0x457ac1[_0x1bf88d]['split'](':=');var _0x49c5e6=_0x127069[0x0];var _0xb5ea3e=_0x127069[_0x1bb8('0x8')](0x1);_0xb5ea3e[_0x1bb8('0x9')](function(_0x5ac7d2){var _0x2af84b=_0x5ac7d2[_0x1bb8('0x7')]('[')[_0x1bb8('0xa')]();var _0x53b4eb=_0x5ac7d2[_0x1bb8('0xb')](/\[(.*?)\]/g);_0x53b4eb[_0x1bb8('0x9')](function(_0x470693){var _0x39068e=_0x470693[_0x1bb8('0x7')]('[')[_0x1bb8('0xc')](function(_0x31fd11){return _0x31fd11[_0x1bb8('0xd')](']')>-0x1;})[_0x1bb8('0xe')](function(_0x39b200){return _0x39b200[_0x1bb8('0x7')](']')[0x0];})[0x0];_0x192248['conditions'][_0x1bb8('0xf')]({'field':_0x49c5e6,'operator':_0x2af84b,'value':_0x39068e});});});}return _0x192248;};exports[_0x1bb8('0x10')]=function(_0x4d5044,_0x19b81f,_0x45d2b1){var _0x257a6d={};if(_0x19b81f===_0x1bb8('0x11')){if(_0x45d2b1[_0x1bb8('0x12')]==='$eq'){_0x45d2b1[_0x1bb8('0x12')]='$between';_0x45d2b1[_0x1bb8('0x13')]+=','+_0x45d2b1[_0x1bb8('0x13')];}else if(_[_0x1bb8('0x14')]([_0x1bb8('0x15'),_0x1bb8('0x16')],_0x45d2b1[_0x1bb8('0x12')])){_0x45d2b1['value']=moment(_0x45d2b1['value'])[_0x1bb8('0x17')](0x1,_0x1bb8('0x18'))[_0x1bb8('0x19')](_0x1bb8('0x1a'));}}if(_0x45d2b1[_0x1bb8('0x1b')]){_0x19b81f=_0x45d2b1[_0x1bb8('0x1b')];_0x257a6d[_0x1bb8('0x1c')]=_0x1bb8('0x1d')+_0x4d5044+'.'+_0x45d2b1[_0x1bb8('0x1e')]+_0x1bb8('0x1f')+_0x45d2b1['castTo']+')\x20'+parseOperator(_0x45d2b1[_0x1bb8('0x12')]);}else{_0x257a6d[_0x1bb8('0x1c')]=_0x4d5044+'.'+_0x45d2b1[_0x1bb8('0x1e')]+'\x20'+parseOperator(_0x45d2b1[_0x1bb8('0x12')]);}if(_['includes']([_0x1bb8('0x20'),_0x1bb8('0x21')],_0x45d2b1[_0x1bb8('0x12')]))_0x257a6d[_0x1bb8('0x1c')]='('+_0x257a6d[_0x1bb8('0x1c')]+_0x1bb8('0x22')+_0x4d5044+'.'+_0x45d2b1['field']+_0x1bb8('0x23');_0x257a6d[_0x1bb8('0x13')]=parseValue(_0x19b81f,_0x45d2b1[_0x1bb8('0x12')],_0x45d2b1['value']);return _0x257a6d;};function parseOperator(_0x72e5cb){var _0x2bc78a;switch(_0x72e5cb){case _0x1bb8('0x24'):_0x2bc78a='IN\x20?';break;case _0x1bb8('0x21'):_0x2bc78a='NOT\x20IN\x20?';break;case _0x1bb8('0x25'):_0x2bc78a='=\x20?';break;case _0x1bb8('0x20'):_0x2bc78a=_0x1bb8('0x26');break;case _0x1bb8('0x27'):case'$startsWith':case'$endsWith':_0x2bc78a=_0x1bb8('0x28');break;case _0x1bb8('0x29'):_0x2bc78a=_0x1bb8('0x2a');break;case'$gt':_0x2bc78a='>\x20?';break;case _0x1bb8('0x16'):_0x2bc78a=_0x1bb8('0x2b');break;case _0x1bb8('0x2c'):_0x2bc78a=_0x1bb8('0x2d');break;case'$between':_0x2bc78a=_0x1bb8('0x2e');break;}return _0x2bc78a;}function parseValue(_0x6328af,_0x5dee30,_0x39cc28){var _0x39d8b1={'start':undefined,'end':undefined};switch(_0x5dee30){case'$in':case _0x1bb8('0x21'):_0x39d8b1['start']=_0x39cc28[_0x1bb8('0x7')](',');break;case _0x1bb8('0x27'):_0x39d8b1[_0x1bb8('0x2f')]='%'+_0x39cc28+'%';break;case _0x1bb8('0x30'):_0x39d8b1[_0x1bb8('0x2f')]=_0x39cc28+'%';break;case'$endsWith':_0x39d8b1[_0x1bb8('0x2f')]='%'+_0x39cc28;break;case _0x1bb8('0x31'):var _0x48182c=_0x39cc28[_0x1bb8('0x7')](',');var _0x39cc28=_0x48182c[_0x1bb8('0xa')]();var _0x706145=_0x48182c['pop']();if(_0x6328af===_0x1bb8('0x11')){_0x39cc28=moment(_0x39cc28)[_0x1bb8('0x32')](0x0,!![])[_0x1bb8('0x19')]();_0x706145=moment(_0x706145)[_0x1bb8('0x32')](0x0,!![])[_0x1bb8('0x17')](0x17,_0x1bb8('0x33'))['add'](0x3b,'minutes')[_0x1bb8('0x17')](0x3b,_0x1bb8('0x34'))['format']();}_0x39d8b1={'start':_0x39cc28,'end':_0x706145};break;default:_0x39d8b1[_0x1bb8('0x2f')]=_0x39cc28;break;}return _0x39d8b1;}
\ No newline at end of file