Built motion from commit f16df95f.|2.5.40
[motion2.git] / server / components / parsers / advancedSearch.js
index 1ac4d10..8be30a4 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xca1a=['pop','utcOffset','hours','minutes','seconds','lodash','moment','sqlOperator','startsWith','[$or]','replace','split','length','slice','shift','forEach','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','$gt','add','days','format','castTo','text','CAST(','\x20AS\x20','field','includes','$ne','$notIn','\x20OR\x20','\x20IS\x20NULL)','IN\x20?','NOT\x20IN\x20?','=\x20?','$startsWith','$endsWith','$lt','<\x20?','>\x20?','$lte','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','$in','start'];(function(_0xd5ef4d,_0x38ad5d){var _0x67107=function(_0x6f8830){while(--_0x6f8830){_0xd5ef4d['push'](_0xd5ef4d['shift']());}};_0x67107(++_0x38ad5d);}(_0xca1a,0x71));var _0xaca1=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0xca1a[_0x20a584];return _0x4b41a8;};'use strict';var _=require(_0xaca1('0x0'));var moment=require(_0xaca1('0x1'));exports['parseSearch']=function(_0x40b6e6){var _0x3c7c5c={'conditions':[]};_0x3c7c5c[_0xaca1('0x2')]=_[_0xaca1('0x3')](_0x40b6e6,_0xaca1('0x4'))?'or':'and';var _0x17a732=_0x40b6e6['replace']('[$and]','')[_0xaca1('0x5')](_0xaca1('0x4'),'')[_0xaca1('0x6')]('||');for(var _0x49cb2c=0x0;_0x49cb2c<_0x17a732[_0xaca1('0x7')];_0x49cb2c++){var _0x27b126=_0x17a732[_0x49cb2c][_0xaca1('0x6')](':=');var _0x4c1960=_0x27b126[0x0];var _0x3f2f2a=_0x27b126[_0xaca1('0x8')](0x1);_0x3f2f2a['forEach'](function(_0x4f3eda){var _0x431156=_0x4f3eda[_0xaca1('0x6')]('[')[_0xaca1('0x9')]();var _0x332699=_0x4f3eda['match'](/\[(.*?)\]/g);_0x332699[_0xaca1('0xa')](function(_0x16c3f2){var _0x21f115=_0x16c3f2[_0xaca1('0x6')]('[')['filter'](function(_0x3061a2){return _0x3061a2['indexOf'](']')>-0x1;})[_0xaca1('0xb')](function(_0x479a77){return _0x479a77[_0xaca1('0x6')](']')[0x0];})[0x0];_0x3c7c5c[_0xaca1('0xc')][_0xaca1('0xd')]({'field':_0x4c1960,'operator':_0x431156,'value':_0x21f115});});});}return _0x3c7c5c;};exports[_0xaca1('0xe')]=function(_0x5aac65,_0xb9dcf4,_0x1815c8){var _0x5202cd={};if(_0xb9dcf4===_0xaca1('0xf')){if(_0x1815c8[_0xaca1('0x10')]===_0xaca1('0x11')){_0x1815c8[_0xaca1('0x10')]=_0xaca1('0x12');_0x1815c8[_0xaca1('0x13')]+=','+_0x1815c8[_0xaca1('0x13')];}else if(_['includes']([_0xaca1('0x14'),'$lte'],_0x1815c8[_0xaca1('0x10')])){_0x1815c8[_0xaca1('0x13')]=moment(_0x1815c8[_0xaca1('0x13')])[_0xaca1('0x15')](0x1,_0xaca1('0x16'))[_0xaca1('0x17')]('YYYY-MM-DD');}}if(_0x1815c8['castTo']){_0xb9dcf4=_0x1815c8[_0xaca1('0x18')];_0x5202cd[_0xaca1('0x19')]=_0xaca1('0x1a')+_0x5aac65+'.'+_0x1815c8['field']+_0xaca1('0x1b')+_0x1815c8['castTo']+')\x20'+parseOperator(_0x1815c8[_0xaca1('0x10')]);}else{_0x5202cd[_0xaca1('0x19')]=_0x5aac65+'.'+_0x1815c8[_0xaca1('0x1c')]+'\x20'+parseOperator(_0x1815c8[_0xaca1('0x10')]);}if(_[_0xaca1('0x1d')]([_0xaca1('0x1e'),_0xaca1('0x1f')],_0x1815c8[_0xaca1('0x10')]))_0x5202cd[_0xaca1('0x19')]='('+_0x5202cd[_0xaca1('0x19')]+_0xaca1('0x20')+_0x5aac65+'.'+_0x1815c8[_0xaca1('0x1c')]+_0xaca1('0x21');_0x5202cd[_0xaca1('0x13')]=parseValue(_0xb9dcf4,_0x1815c8['operator'],_0x1815c8['value']);return _0x5202cd;};function parseOperator(_0x29a9b1){var _0x8c49c1;switch(_0x29a9b1){case'$in':_0x8c49c1=_0xaca1('0x22');break;case'$notIn':_0x8c49c1=_0xaca1('0x23');break;case _0xaca1('0x11'):_0x8c49c1=_0xaca1('0x24');break;case'$ne':_0x8c49c1='<>\x20?';break;case'$substring':case _0xaca1('0x25'):case _0xaca1('0x26'):_0x8c49c1='LIKE\x20?';break;case _0xaca1('0x27'):_0x8c49c1=_0xaca1('0x28');break;case'$gt':_0x8c49c1=_0xaca1('0x29');break;case _0xaca1('0x2a'):_0x8c49c1=_0xaca1('0x2b');break;case _0xaca1('0x2c'):_0x8c49c1=_0xaca1('0x2d');break;case _0xaca1('0x12'):_0x8c49c1=_0xaca1('0x2e');break;}return _0x8c49c1;}function parseValue(_0x2c637c,_0x46264e,_0x3a6740){var _0x30d86e={'start':undefined,'end':undefined};switch(_0x46264e){case _0xaca1('0x2f'):case _0xaca1('0x1f'):_0x30d86e[_0xaca1('0x30')]=_0x3a6740[_0xaca1('0x6')](',');break;case'$substring':_0x30d86e[_0xaca1('0x30')]='%'+_0x3a6740+'%';break;case'$startsWith':_0x30d86e[_0xaca1('0x30')]=_0x3a6740+'%';break;case'$endsWith':_0x30d86e[_0xaca1('0x30')]='%'+_0x3a6740;break;case _0xaca1('0x12'):var _0x5206b4=_0x3a6740[_0xaca1('0x6')](',');var _0x3a6740=_0x5206b4[_0xaca1('0x9')]();var _0x4a4e70=_0x5206b4[_0xaca1('0x31')]();if(_0x2c637c===_0xaca1('0xf')){_0x3a6740=moment(_0x3a6740)[_0xaca1('0x32')](0x0,!![])[_0xaca1('0x17')]();_0x4a4e70=moment(_0x4a4e70)[_0xaca1('0x32')](0x0,!![])[_0xaca1('0x15')](0x17,_0xaca1('0x33'))[_0xaca1('0x15')](0x3b,_0xaca1('0x34'))[_0xaca1('0x15')](0x3b,_0xaca1('0x35'))['format']();}_0x30d86e={'start':_0x3a6740,'end':_0x4a4e70};break;default:_0x30d86e[_0xaca1('0x30')]=_0x3a6740;break;}return _0x30d86e;}
\ No newline at end of file
+var _0x60ce=['$substring','shift','utcOffset','minutes','seconds','format','lodash','moment','parseSearch','sqlOperator','startsWith','[$or]','[$and]','replace','split','slice','match','forEach','filter','indexOf','map','conditions','push','buildExpression','DATE','operator','$between','value','includes','$lte','add','YYYY-MM-DD','castTo','text','CAST(','field','\x20AS\x20','$notIn','\x20OR\x20','IN\x20?','NOT\x20IN\x20?','$eq','=\x20?','<>\x20?','$startsWith','$endsWith','LIKE\x20?','$lt','<\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','$in','start'];(function(_0x514fa9,_0x4ce580){var _0x2db595=function(_0x1b218d){while(--_0x1b218d){_0x514fa9['push'](_0x514fa9['shift']());}};_0x2db595(++_0x4ce580);}(_0x60ce,0xe2));var _0xe60c=function(_0x304104,_0x5ca62b){_0x304104=_0x304104-0x0;var _0x13a5be=_0x60ce[_0x304104];return _0x13a5be;};'use strict';var _=require(_0xe60c('0x0'));var moment=require(_0xe60c('0x1'));exports[_0xe60c('0x2')]=function(_0x64b2e1){var _0x4cfb7b={'conditions':[]};_0x4cfb7b[_0xe60c('0x3')]=_[_0xe60c('0x4')](_0x64b2e1,_0xe60c('0x5'))?'or':'and';var _0x4095f5=_0x64b2e1['replace'](_0xe60c('0x6'),'')[_0xe60c('0x7')](_0xe60c('0x5'),'')[_0xe60c('0x8')]('||');for(var _0x5e26fa=0x0;_0x5e26fa<_0x4095f5['length'];_0x5e26fa++){var _0x179bd9=_0x4095f5[_0x5e26fa]['split'](':=');var _0x28adef=_0x179bd9[0x0];var _0x10e160=_0x179bd9[_0xe60c('0x9')](0x1);_0x10e160['forEach'](function(_0x2da7a8){var _0x1cf02f=_0x2da7a8[_0xe60c('0x8')]('[')['shift']();var _0x34d6e7=_0x2da7a8[_0xe60c('0xa')](/\[(.*?)\]/g);_0x34d6e7[_0xe60c('0xb')](function(_0x4c5c02){var _0x69e77d=_0x4c5c02[_0xe60c('0x8')]('[')[_0xe60c('0xc')](function(_0x258d6a){return _0x258d6a[_0xe60c('0xd')](']')>-0x1;})[_0xe60c('0xe')](function(_0x5a50ef){return _0x5a50ef[_0xe60c('0x8')](']')[0x0];})[0x0];_0x4cfb7b[_0xe60c('0xf')][_0xe60c('0x10')]({'field':_0x28adef,'operator':_0x1cf02f,'value':_0x69e77d});});});}return _0x4cfb7b;};exports[_0xe60c('0x11')]=function(_0xe419a8,_0x5c8198,_0x256e2b){var _0x167e43={};if(_0x5c8198===_0xe60c('0x12')){if(_0x256e2b[_0xe60c('0x13')]==='$eq'){_0x256e2b['operator']=_0xe60c('0x14');_0x256e2b[_0xe60c('0x15')]+=','+_0x256e2b[_0xe60c('0x15')];}else if(_[_0xe60c('0x16')](['$gt',_0xe60c('0x17')],_0x256e2b[_0xe60c('0x13')])){_0x256e2b['value']=moment(_0x256e2b[_0xe60c('0x15')])[_0xe60c('0x18')](0x1,'days')['format'](_0xe60c('0x19'));}}if(_0x256e2b[_0xe60c('0x1a')]){_0x5c8198=_0x256e2b[_0xe60c('0x1a')];_0x167e43[_0xe60c('0x1b')]=_0xe60c('0x1c')+_0xe419a8+'.'+_0x256e2b[_0xe60c('0x1d')]+_0xe60c('0x1e')+_0x256e2b[_0xe60c('0x1a')]+')\x20'+parseOperator(_0x256e2b['operator']);}else{_0x167e43[_0xe60c('0x1b')]=_0xe419a8+'.'+_0x256e2b['field']+'\x20'+parseOperator(_0x256e2b[_0xe60c('0x13')]);}if(_[_0xe60c('0x16')](['$ne',_0xe60c('0x1f')],_0x256e2b[_0xe60c('0x13')]))_0x167e43[_0xe60c('0x1b')]='('+_0x167e43[_0xe60c('0x1b')]+_0xe60c('0x20')+_0xe419a8+'.'+_0x256e2b[_0xe60c('0x1d')]+'\x20IS\x20NULL)';_0x167e43['value']=parseValue(_0x5c8198,_0x256e2b[_0xe60c('0x13')],_0x256e2b[_0xe60c('0x15')]);return _0x167e43;};function parseOperator(_0x13773d){var _0x3a3045;switch(_0x13773d){case'$in':_0x3a3045=_0xe60c('0x21');break;case _0xe60c('0x1f'):_0x3a3045=_0xe60c('0x22');break;case _0xe60c('0x23'):_0x3a3045=_0xe60c('0x24');break;case'$ne':_0x3a3045=_0xe60c('0x25');break;case'$substring':case _0xe60c('0x26'):case _0xe60c('0x27'):_0x3a3045=_0xe60c('0x28');break;case _0xe60c('0x29'):_0x3a3045=_0xe60c('0x2a');break;case'$gt':_0x3a3045='>\x20?';break;case _0xe60c('0x17'):_0x3a3045=_0xe60c('0x2b');break;case _0xe60c('0x2c'):_0x3a3045=_0xe60c('0x2d');break;case _0xe60c('0x14'):_0x3a3045=_0xe60c('0x2e');break;}return _0x3a3045;}function parseValue(_0x5e7075,_0x3b7434,_0x255956){var _0x1110db={'start':undefined,'end':undefined};switch(_0x3b7434){case _0xe60c('0x2f'):case _0xe60c('0x1f'):_0x1110db[_0xe60c('0x30')]=_0x255956['split'](',');break;case _0xe60c('0x31'):_0x1110db[_0xe60c('0x30')]='%'+_0x255956+'%';break;case _0xe60c('0x26'):_0x1110db[_0xe60c('0x30')]=_0x255956+'%';break;case _0xe60c('0x27'):_0x1110db[_0xe60c('0x30')]='%'+_0x255956;break;case _0xe60c('0x14'):var _0x54a380=_0x255956[_0xe60c('0x8')](',');var _0x255956=_0x54a380[_0xe60c('0x32')]();var _0x35a237=_0x54a380['pop']();if(_0x5e7075===_0xe60c('0x12')){_0x255956=moment(_0x255956)[_0xe60c('0x33')](0x0,!![])['format']();_0x35a237=moment(_0x35a237)[_0xe60c('0x33')](0x0,!![])['add'](0x17,'hours')[_0xe60c('0x18')](0x3b,_0xe60c('0x34'))[_0xe60c('0x18')](0x3b,_0xe60c('0x35'))[_0xe60c('0x36')]();}_0x1110db={'start':_0x255956,'end':_0x35a237};break;default:_0x1110db[_0xe60c('0x30')]=_0x255956;break;}return _0x1110db;}
\ No newline at end of file