Built motion from commit (unavailable).|2.6.0
[motion2.git] / server / components / parsers / advancedSearch.js
index 9e44213..2a23309 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x731b=['$gt','$lte','add','days','castTo','text','\x20AS\x20','field','\x20IS\x20NULL)','$in','IN\x20?','$notIn','=\x20?','$ne','<>\x20?','$startsWith','$endsWith','<\x20?','>\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','$substring','shift','pop','utcOffset','format','hours','seconds','moment','parseSearch','startsWith','[$or]','and','replace','length','split','slice','forEach','match','filter','push','buildExpression','DATE','operator','$eq','$between','value'];(function(_0x3f3181,_0x47900a){var _0x1db92a=function(_0x59b6c1){while(--_0x59b6c1){_0x3f3181['push'](_0x3f3181['shift']());}};_0x1db92a(++_0x47900a);}(_0x731b,0x1e1));var _0xb731=function(_0x528e14,_0x529d9c){_0x528e14=_0x528e14-0x0;var _0x58ac6b=_0x731b[_0x528e14];return _0x58ac6b;};'use strict';var _=require('lodash');var moment=require(_0xb731('0x0'));exports[_0xb731('0x1')]=function(_0x347ad9){var _0x25e94d={'conditions':[]};_0x25e94d['sqlOperator']=_[_0xb731('0x2')](_0x347ad9,_0xb731('0x3'))?'or':_0xb731('0x4');var _0xd33154=_0x347ad9[_0xb731('0x5')]('[$and]','')[_0xb731('0x5')](_0xb731('0x3'),'')['split']('||');for(var _0x29c906=0x0;_0x29c906<_0xd33154[_0xb731('0x6')];_0x29c906++){var _0x3abb08=_0xd33154[_0x29c906][_0xb731('0x7')](':=');var _0x83093e=_0x3abb08[0x0];var _0x833fad=_0x3abb08[_0xb731('0x8')](0x1);_0x833fad[_0xb731('0x9')](function(_0x36ca20){var _0x225b26=_0x36ca20[_0xb731('0x7')]('[')['shift']();var _0x2b978c=_0x36ca20[_0xb731('0xa')](/\[(.*?)\]/g);_0x2b978c[_0xb731('0x9')](function(_0x43cdca){var _0xf7ad18=_0x43cdca[_0xb731('0x7')]('[')[_0xb731('0xb')](function(_0x543984){return _0x543984['indexOf'](']')>-0x1;})['map'](function(_0x592cc6){return _0x592cc6[_0xb731('0x7')](']')[0x0];})[0x0];_0x25e94d['conditions'][_0xb731('0xc')]({'field':_0x83093e,'operator':_0x225b26,'value':_0xf7ad18});});});}return _0x25e94d;};exports[_0xb731('0xd')]=function(_0x12c08c,_0xcf224e,_0x199957){var _0xaf05ca={};if(_0xcf224e===_0xb731('0xe')){if(_0x199957[_0xb731('0xf')]===_0xb731('0x10')){_0x199957[_0xb731('0xf')]=_0xb731('0x11');_0x199957[_0xb731('0x12')]+=','+_0x199957[_0xb731('0x12')];}else if(_['includes']([_0xb731('0x13'),_0xb731('0x14')],_0x199957['operator'])){_0x199957['value']=moment(_0x199957[_0xb731('0x12')])[_0xb731('0x15')](0x1,_0xb731('0x16'))['format']('YYYY-MM-DD');}}if(_0x199957['castTo']){_0xcf224e=_0x199957[_0xb731('0x17')];_0xaf05ca[_0xb731('0x18')]='CAST('+_0x12c08c+'.'+_0x199957['field']+_0xb731('0x19')+_0x199957['castTo']+')\x20'+parseOperator(_0x199957['operator']);}else{_0xaf05ca[_0xb731('0x18')]=_0x12c08c+'.'+_0x199957[_0xb731('0x1a')]+'\x20'+parseOperator(_0x199957[_0xb731('0xf')]);}if(_['includes'](['$ne','$notIn'],_0x199957[_0xb731('0xf')]))_0xaf05ca[_0xb731('0x18')]='('+_0xaf05ca[_0xb731('0x18')]+'\x20OR\x20'+_0x12c08c+'.'+_0x199957[_0xb731('0x1a')]+_0xb731('0x1b');_0xaf05ca[_0xb731('0x12')]=parseValue(_0xcf224e,_0x199957[_0xb731('0xf')],_0x199957[_0xb731('0x12')]);return _0xaf05ca;};function parseOperator(_0x9c9ff5){var _0x1a85c5;switch(_0x9c9ff5){case _0xb731('0x1c'):_0x1a85c5=_0xb731('0x1d');break;case _0xb731('0x1e'):_0x1a85c5='NOT\x20IN\x20?';break;case _0xb731('0x10'):_0x1a85c5=_0xb731('0x1f');break;case _0xb731('0x20'):_0x1a85c5=_0xb731('0x21');break;case'$substring':case _0xb731('0x22'):case _0xb731('0x23'):_0x1a85c5='LIKE\x20?';break;case'$lt':_0x1a85c5=_0xb731('0x24');break;case _0xb731('0x13'):_0x1a85c5=_0xb731('0x25');break;case _0xb731('0x14'):_0x1a85c5=_0xb731('0x26');break;case _0xb731('0x27'):_0x1a85c5=_0xb731('0x28');break;case'$between':_0x1a85c5=_0xb731('0x29');break;}return _0x1a85c5;}function parseValue(_0x2ca5ed,_0x2c137a,_0x345eb7){var _0x1a7543={'start':undefined,'end':undefined};switch(_0x2c137a){case'$in':case _0xb731('0x1e'):_0x1a7543[_0xb731('0x2a')]=_0x345eb7[_0xb731('0x7')](',');break;case _0xb731('0x2b'):_0x1a7543[_0xb731('0x2a')]='%'+_0x345eb7+'%';break;case _0xb731('0x22'):_0x1a7543[_0xb731('0x2a')]=_0x345eb7+'%';break;case _0xb731('0x23'):_0x1a7543[_0xb731('0x2a')]='%'+_0x345eb7;break;case _0xb731('0x11'):var _0x22b5ef=_0x345eb7[_0xb731('0x7')](',');var _0x345eb7=_0x22b5ef[_0xb731('0x2c')]();var _0x17cd10=_0x22b5ef[_0xb731('0x2d')]();if(_0x2ca5ed===_0xb731('0xe')){_0x345eb7=moment(_0x345eb7)[_0xb731('0x2e')](0x0,!![])[_0xb731('0x2f')]();_0x17cd10=moment(_0x17cd10)['utcOffset'](0x0,!![])[_0xb731('0x15')](0x17,_0xb731('0x30'))[_0xb731('0x15')](0x3b,'minutes')['add'](0x3b,_0xb731('0x31'))[_0xb731('0x2f')]();}_0x1a7543={'start':_0x345eb7,'end':_0x17cd10};break;default:_0x1a7543[_0xb731('0x2a')]=_0x345eb7;break;}return _0x1a7543;}
\ No newline at end of file
+var _0x8ede=['split','slice','match','forEach','filter','map','conditions','push','buildExpression','DATE','operator','value','includes','$gt','$lte','add','days','format','YYYY-MM-DD','castTo','text','CAST(','field','\x20AS\x20','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','$eq','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','<=\x20?','>=\x20?','$between','BETWEEN\x20?\x20AND\x20?','start','shift','pop','utcOffset','hours','minutes','moment','parseSearch','startsWith','[$or]','replace'];(function(_0x4ef885,_0x50a600){var _0x2f386e=function(_0x18be1d){while(--_0x18be1d){_0x4ef885['push'](_0x4ef885['shift']());}};_0x2f386e(++_0x50a600);}(_0x8ede,0x12d));var _0xe8ed=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x8ede[_0x3dd15e];return _0x231fd0;};'use strict';var _=require('lodash');var moment=require(_0xe8ed('0x0'));exports[_0xe8ed('0x1')]=function(_0x1a1fbf){var _0x22b655={'conditions':[]};_0x22b655['sqlOperator']=_[_0xe8ed('0x2')](_0x1a1fbf,_0xe8ed('0x3'))?'or':'and';var _0x5dbbbb=_0x1a1fbf[_0xe8ed('0x4')]('[$and]','')[_0xe8ed('0x4')]('[$or]','')[_0xe8ed('0x5')]('||');for(var _0x38022a=0x0;_0x38022a<_0x5dbbbb['length'];_0x38022a++){var _0x4ac60e=_0x5dbbbb[_0x38022a][_0xe8ed('0x5')](':=');var _0x36b1ce=_0x4ac60e[0x0];var _0x1816ca=_0x4ac60e[_0xe8ed('0x6')](0x1);_0x1816ca['forEach'](function(_0x44b51a){var _0x49a55f=_0x44b51a['split']('[')['shift']();var _0x562ddc=_0x44b51a[_0xe8ed('0x7')](/\[(.*?)\]/g);_0x562ddc[_0xe8ed('0x8')](function(_0x8bd5f2){var _0x51357c=_0x8bd5f2[_0xe8ed('0x5')]('[')[_0xe8ed('0x9')](function(_0x465b8e){return _0x465b8e['indexOf'](']')>-0x1;})[_0xe8ed('0xa')](function(_0x1b9349){return _0x1b9349[_0xe8ed('0x5')](']')[0x0];})[0x0];_0x22b655[_0xe8ed('0xb')][_0xe8ed('0xc')]({'field':_0x36b1ce,'operator':_0x49a55f,'value':_0x51357c});});});}return _0x22b655;};exports[_0xe8ed('0xd')]=function(_0x192d9f,_0x5bda11,_0x26f81f){var _0x4623c3={};if(_0x5bda11===_0xe8ed('0xe')){if(_0x26f81f[_0xe8ed('0xf')]==='$eq'){_0x26f81f['operator']='$between';_0x26f81f[_0xe8ed('0x10')]+=','+_0x26f81f[_0xe8ed('0x10')];}else if(_[_0xe8ed('0x11')]([_0xe8ed('0x12'),_0xe8ed('0x13')],_0x26f81f[_0xe8ed('0xf')])){_0x26f81f['value']=moment(_0x26f81f[_0xe8ed('0x10')])[_0xe8ed('0x14')](0x1,_0xe8ed('0x15'))[_0xe8ed('0x16')](_0xe8ed('0x17'));}}if(_0x26f81f['castTo']){_0x5bda11=_0x26f81f[_0xe8ed('0x18')];_0x4623c3[_0xe8ed('0x19')]=_0xe8ed('0x1a')+_0x192d9f+'.'+_0x26f81f[_0xe8ed('0x1b')]+_0xe8ed('0x1c')+_0x26f81f['castTo']+')\x20'+parseOperator(_0x26f81f['operator']);}else{_0x4623c3[_0xe8ed('0x19')]=_0x192d9f+'.'+_0x26f81f[_0xe8ed('0x1b')]+'\x20'+parseOperator(_0x26f81f[_0xe8ed('0xf')]);}if(_['includes']([_0xe8ed('0x1d'),_0xe8ed('0x1e')],_0x26f81f['operator']))_0x4623c3['text']='('+_0x4623c3['text']+_0xe8ed('0x1f')+_0x192d9f+'.'+_0x26f81f[_0xe8ed('0x1b')]+_0xe8ed('0x20');_0x4623c3['value']=parseValue(_0x5bda11,_0x26f81f[_0xe8ed('0xf')],_0x26f81f[_0xe8ed('0x10')]);return _0x4623c3;};function parseOperator(_0x5634b4){var _0x1bd40f;switch(_0x5634b4){case _0xe8ed('0x21'):_0x1bd40f=_0xe8ed('0x22');break;case'$notIn':_0x1bd40f='NOT\x20IN\x20?';break;case _0xe8ed('0x23'):_0x1bd40f='=\x20?';break;case _0xe8ed('0x1d'):_0x1bd40f=_0xe8ed('0x24');break;case _0xe8ed('0x25'):case _0xe8ed('0x26'):case _0xe8ed('0x27'):_0x1bd40f=_0xe8ed('0x28');break;case'$lt':_0x1bd40f='<\x20?';break;case _0xe8ed('0x12'):_0x1bd40f='>\x20?';break;case _0xe8ed('0x13'):_0x1bd40f=_0xe8ed('0x29');break;case'$gte':_0x1bd40f=_0xe8ed('0x2a');break;case _0xe8ed('0x2b'):_0x1bd40f=_0xe8ed('0x2c');break;}return _0x1bd40f;}function parseValue(_0x348ac9,_0xce0be4,_0x4d49ab){var _0x5d0350={'start':undefined,'end':undefined};switch(_0xce0be4){case _0xe8ed('0x21'):case _0xe8ed('0x1e'):_0x5d0350[_0xe8ed('0x2d')]=_0x4d49ab[_0xe8ed('0x5')](',');break;case _0xe8ed('0x25'):_0x5d0350[_0xe8ed('0x2d')]='%'+_0x4d49ab+'%';break;case'$startsWith':_0x5d0350[_0xe8ed('0x2d')]=_0x4d49ab+'%';break;case'$endsWith':_0x5d0350['start']='%'+_0x4d49ab;break;case'$between':var _0x18b3b2=_0x4d49ab[_0xe8ed('0x5')](',');var _0x4d49ab=_0x18b3b2[_0xe8ed('0x2e')]();var _0x114de6=_0x18b3b2[_0xe8ed('0x2f')]();if(_0x348ac9==='DATE'){_0x4d49ab=moment(_0x4d49ab)[_0xe8ed('0x30')](0x0,!![])[_0xe8ed('0x16')]();_0x114de6=moment(_0x114de6)[_0xe8ed('0x30')](0x0,!![])['add'](0x17,_0xe8ed('0x31'))[_0xe8ed('0x14')](0x3b,_0xe8ed('0x32'))[_0xe8ed('0x14')](0x3b,'seconds')['format']();}_0x5d0350={'start':_0x4d49ab,'end':_0x114de6};break;default:_0x5d0350[_0xe8ed('0x2d')]=_0x4d49ab;break;}return _0x5d0350;}
\ No newline at end of file