Built motion from commit 896e83a8.|2.6.30
[motion2.git] / server / components / parsers / advancedSearch.js
index bca7fe3..0a066c0 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x83c5=['$startsWith','pop','utcOffset','hours','minutes','seconds','lodash','moment','sqlOperator','startsWith','[$or]','and','replace','[$and]','split','slice','forEach','shift','match','indexOf','map','push','buildExpression','$eq','operator','includes','$gt','$lte','value','add','days','format','YYYY-MM-DD','castTo','text','CAST(','field','\x20AS\x20','$ne','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','$notIn','NOT\x20IN\x20?','=\x20?','<>\x20?','$substring','$endsWith','$lt','<\x20?','<=\x20?','$between','start'];(function(_0x24243b,_0x55c567){var _0x1a85ce=function(_0x28c017){while(--_0x28c017){_0x24243b['push'](_0x24243b['shift']());}};_0x1a85ce(++_0x55c567);}(_0x83c5,0x114));var _0x583c=function(_0x3a24b5,_0x313359){_0x3a24b5=_0x3a24b5-0x0;var _0x3c6702=_0x83c5[_0x3a24b5];return _0x3c6702;};'use strict';var _=require(_0x583c('0x0'));var moment=require(_0x583c('0x1'));exports['parseSearch']=function(_0x242287){var _0x54ee49={'conditions':[]};_0x54ee49[_0x583c('0x2')]=_[_0x583c('0x3')](_0x242287,_0x583c('0x4'))?'or':_0x583c('0x5');var _0x5c32b9=_0x242287[_0x583c('0x6')](_0x583c('0x7'),'')[_0x583c('0x6')]('[$or]','')[_0x583c('0x8')]('||');for(var _0x1b6b50=0x0;_0x1b6b50<_0x5c32b9['length'];_0x1b6b50++){var _0x1b6214=_0x5c32b9[_0x1b6b50][_0x583c('0x8')](':=');var _0x300d9f=_0x1b6214[0x0];var _0x102639=_0x1b6214[_0x583c('0x9')](0x1);_0x102639[_0x583c('0xa')](function(_0x21c261){var _0x5c58f0=_0x21c261[_0x583c('0x8')]('[')[_0x583c('0xb')]();var _0x17a703=_0x21c261[_0x583c('0xc')](/\[(.*?)\]/g);_0x17a703[_0x583c('0xa')](function(_0x293e2e){var _0x4a85a2=_0x293e2e[_0x583c('0x8')]('[')['filter'](function(_0x1ba57b){return _0x1ba57b[_0x583c('0xd')](']')>-0x1;})[_0x583c('0xe')](function(_0x4d1cd8){return _0x4d1cd8[_0x583c('0x8')](']')[0x0];})[0x0];_0x54ee49['conditions'][_0x583c('0xf')]({'field':_0x300d9f,'operator':_0x5c58f0,'value':_0x4a85a2});});});}return _0x54ee49;};exports[_0x583c('0x10')]=function(_0x1c183e,_0x9b9e00,_0x35dcda){var _0x38ac29={};if(_0x9b9e00==='DATE'){if(_0x35dcda['operator']===_0x583c('0x11')){_0x35dcda[_0x583c('0x12')]='$between';_0x35dcda['value']+=','+_0x35dcda['value'];}else if(_[_0x583c('0x13')]([_0x583c('0x14'),_0x583c('0x15')],_0x35dcda[_0x583c('0x12')])){_0x35dcda[_0x583c('0x16')]=moment(_0x35dcda['value'])[_0x583c('0x17')](0x1,_0x583c('0x18'))[_0x583c('0x19')](_0x583c('0x1a'));}}if(_0x35dcda[_0x583c('0x1b')]){_0x9b9e00=_0x35dcda[_0x583c('0x1b')];_0x38ac29[_0x583c('0x1c')]=_0x583c('0x1d')+_0x1c183e+'.'+_0x35dcda[_0x583c('0x1e')]+_0x583c('0x1f')+_0x35dcda['castTo']+')\x20'+parseOperator(_0x35dcda[_0x583c('0x12')]);}else{_0x38ac29[_0x583c('0x1c')]=_0x1c183e+'.'+_0x35dcda[_0x583c('0x1e')]+'\x20'+parseOperator(_0x35dcda[_0x583c('0x12')]);}if(_['includes']([_0x583c('0x20'),'$notIn'],_0x35dcda[_0x583c('0x12')]))_0x38ac29[_0x583c('0x1c')]='('+_0x38ac29[_0x583c('0x1c')]+_0x583c('0x21')+_0x1c183e+'.'+_0x35dcda[_0x583c('0x1e')]+_0x583c('0x22');_0x38ac29['value']=parseValue(_0x9b9e00,_0x35dcda[_0x583c('0x12')],_0x35dcda['value']);return _0x38ac29;};function parseOperator(_0xc2f8bf){var _0x243058;switch(_0xc2f8bf){case _0x583c('0x23'):_0x243058=_0x583c('0x24');break;case _0x583c('0x25'):_0x243058=_0x583c('0x26');break;case _0x583c('0x11'):_0x243058=_0x583c('0x27');break;case _0x583c('0x20'):_0x243058=_0x583c('0x28');break;case _0x583c('0x29'):case'$startsWith':case _0x583c('0x2a'):_0x243058='LIKE\x20?';break;case _0x583c('0x2b'):_0x243058=_0x583c('0x2c');break;case _0x583c('0x14'):_0x243058='>\x20?';break;case _0x583c('0x15'):_0x243058=_0x583c('0x2d');break;case'$gte':_0x243058='>=\x20?';break;case _0x583c('0x2e'):_0x243058='BETWEEN\x20?\x20AND\x20?';break;}return _0x243058;}function parseValue(_0x47c318,_0x4f45ac,_0x592d49){var _0x40fa53={'start':undefined,'end':undefined};switch(_0x4f45ac){case _0x583c('0x23'):case _0x583c('0x25'):_0x40fa53[_0x583c('0x2f')]=_0x592d49[_0x583c('0x8')](',');break;case _0x583c('0x29'):_0x40fa53[_0x583c('0x2f')]='%'+_0x592d49+'%';break;case _0x583c('0x30'):_0x40fa53[_0x583c('0x2f')]=_0x592d49+'%';break;case _0x583c('0x2a'):_0x40fa53[_0x583c('0x2f')]='%'+_0x592d49;break;case _0x583c('0x2e'):var _0x337949=_0x592d49['split'](',');var _0x592d49=_0x337949[_0x583c('0xb')]();var _0x110839=_0x337949[_0x583c('0x31')]();if(_0x47c318==='DATE'){_0x592d49=moment(_0x592d49)['utcOffset'](0x0,!![])[_0x583c('0x19')]();_0x110839=moment(_0x110839)[_0x583c('0x32')](0x0,!![])['add'](0x17,_0x583c('0x33'))['add'](0x3b,_0x583c('0x34'))['add'](0x3b,_0x583c('0x35'))[_0x583c('0x19')]();}_0x40fa53={'start':_0x592d49,'end':_0x110839};break;default:_0x40fa53[_0x583c('0x2f')]=_0x592d49;break;}return _0x40fa53;}
\ No newline at end of file
+var _0x9c62=['[$and]','[$or]','split','length','slice','match','forEach','filter','indexOf','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','$gt','add','days','format','castTo','CAST(','field','\x20AS\x20','includes','$ne','$notIn','text','\x20OR\x20','\x20IS\x20NULL)','NOT\x20IN\x20?','=\x20?','<>\x20?','$startsWith','$endsWith','<\x20?','>\x20?','$lte','<=\x20?','$gte','start','shift','utcOffset','hours','minutes','seconds','lodash','parseSearch','and','replace'];(function(_0x2a0738,_0x3c0bc5){var _0x159679=function(_0x9c9ec7){while(--_0x9c9ec7){_0x2a0738['push'](_0x2a0738['shift']());}};_0x159679(++_0x3c0bc5);}(_0x9c62,0x98));var _0x29c6=function(_0x362fa2,_0x42ff83){_0x362fa2=_0x362fa2-0x0;var _0x507057=_0x9c62[_0x362fa2];return _0x507057;};'use strict';var _=require(_0x29c6('0x0'));var moment=require('moment');exports[_0x29c6('0x1')]=function(_0x2bcf7c){var _0x127da7={'conditions':[]};_0x127da7['sqlOperator']=_['startsWith'](_0x2bcf7c,'[$or]')?'or':_0x29c6('0x2');var _0x24f369=_0x2bcf7c[_0x29c6('0x3')](_0x29c6('0x4'),'')[_0x29c6('0x3')](_0x29c6('0x5'),'')[_0x29c6('0x6')]('||');for(var _0x769f89=0x0;_0x769f89<_0x24f369[_0x29c6('0x7')];_0x769f89++){var _0x5a13ed=_0x24f369[_0x769f89][_0x29c6('0x6')](':=');var _0x7c0631=_0x5a13ed[0x0];var _0x3500c5=_0x5a13ed[_0x29c6('0x8')](0x1);_0x3500c5['forEach'](function(_0x2153e0){var _0x460d76=_0x2153e0[_0x29c6('0x6')]('[')['shift']();var _0x252ff5=_0x2153e0[_0x29c6('0x9')](/\[(.*?)\]/g);_0x252ff5[_0x29c6('0xa')](function(_0x20a9ba){var _0x3d3e74=_0x20a9ba[_0x29c6('0x6')]('[')[_0x29c6('0xb')](function(_0x4e1946){return _0x4e1946[_0x29c6('0xc')](']')>-0x1;})[_0x29c6('0xd')](function(_0x17163e){return _0x17163e['split'](']')[0x0];})[0x0];_0x127da7[_0x29c6('0xe')][_0x29c6('0xf')]({'field':_0x7c0631,'operator':_0x460d76,'value':_0x3d3e74});});});}return _0x127da7;};exports[_0x29c6('0x10')]=function(_0x3c2818,_0x4da4d4,_0x3d14be){var _0xa0ee76={};if(_0x4da4d4===_0x29c6('0x11')){if(_0x3d14be[_0x29c6('0x12')]===_0x29c6('0x13')){_0x3d14be['operator']=_0x29c6('0x14');_0x3d14be[_0x29c6('0x15')]+=','+_0x3d14be['value'];}else if(_['includes']([_0x29c6('0x16'),'$lte'],_0x3d14be['operator'])){_0x3d14be[_0x29c6('0x15')]=moment(_0x3d14be[_0x29c6('0x15')])[_0x29c6('0x17')](0x1,_0x29c6('0x18'))[_0x29c6('0x19')]('YYYY-MM-DD');}}if(_0x3d14be[_0x29c6('0x1a')]){_0x4da4d4=_0x3d14be[_0x29c6('0x1a')];_0xa0ee76['text']=_0x29c6('0x1b')+_0x3c2818+'.'+_0x3d14be[_0x29c6('0x1c')]+_0x29c6('0x1d')+_0x3d14be[_0x29c6('0x1a')]+')\x20'+parseOperator(_0x3d14be['operator']);}else{_0xa0ee76['text']=_0x3c2818+'.'+_0x3d14be[_0x29c6('0x1c')]+'\x20'+parseOperator(_0x3d14be[_0x29c6('0x12')]);}if(_[_0x29c6('0x1e')]([_0x29c6('0x1f'),_0x29c6('0x20')],_0x3d14be['operator']))_0xa0ee76[_0x29c6('0x21')]='('+_0xa0ee76['text']+_0x29c6('0x22')+_0x3c2818+'.'+_0x3d14be[_0x29c6('0x1c')]+_0x29c6('0x23');_0xa0ee76[_0x29c6('0x15')]=parseValue(_0x4da4d4,_0x3d14be[_0x29c6('0x12')],_0x3d14be[_0x29c6('0x15')]);return _0xa0ee76;};function parseOperator(_0x50a684){var _0x2cbc81;switch(_0x50a684){case'$in':_0x2cbc81='IN\x20?';break;case _0x29c6('0x20'):_0x2cbc81=_0x29c6('0x24');break;case _0x29c6('0x13'):_0x2cbc81=_0x29c6('0x25');break;case _0x29c6('0x1f'):_0x2cbc81=_0x29c6('0x26');break;case'$substring':case _0x29c6('0x27'):case _0x29c6('0x28'):_0x2cbc81='LIKE\x20?';break;case'$lt':_0x2cbc81=_0x29c6('0x29');break;case _0x29c6('0x16'):_0x2cbc81=_0x29c6('0x2a');break;case _0x29c6('0x2b'):_0x2cbc81=_0x29c6('0x2c');break;case _0x29c6('0x2d'):_0x2cbc81='>=\x20?';break;case'$between':_0x2cbc81='BETWEEN\x20?\x20AND\x20?';break;}return _0x2cbc81;}function parseValue(_0x1f4f9a,_0x5be21a,_0x18c45e){var _0x3de07d={'start':undefined,'end':undefined};switch(_0x5be21a){case'$in':case _0x29c6('0x20'):_0x3de07d[_0x29c6('0x2e')]=_0x18c45e[_0x29c6('0x6')](',');break;case'$substring':_0x3de07d[_0x29c6('0x2e')]='%'+_0x18c45e+'%';break;case'$startsWith':_0x3de07d['start']=_0x18c45e+'%';break;case _0x29c6('0x28'):_0x3de07d[_0x29c6('0x2e')]='%'+_0x18c45e;break;case _0x29c6('0x14'):var _0x4f8365=_0x18c45e[_0x29c6('0x6')](',');var _0x18c45e=_0x4f8365[_0x29c6('0x2f')]();var _0xe18e30=_0x4f8365['pop']();if(_0x1f4f9a===_0x29c6('0x11')){_0x18c45e=moment(_0x18c45e)[_0x29c6('0x30')](0x0,!![])[_0x29c6('0x19')]();_0xe18e30=moment(_0xe18e30)[_0x29c6('0x30')](0x0,!![])[_0x29c6('0x17')](0x17,_0x29c6('0x31'))[_0x29c6('0x17')](0x3b,_0x29c6('0x32'))[_0x29c6('0x17')](0x3b,_0x29c6('0x33'))[_0x29c6('0x19')]();}_0x3de07d={'start':_0x18c45e,'end':_0xe18e30};break;default:_0x3de07d[_0x29c6('0x2e')]=_0x18c45e;break;}return _0x3de07d;}
\ No newline at end of file