server/components/parsers/advancedSearch.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0xcb93=['YYYY-MM-DD','CAST(','field','\x20AS\x20','castTo','text','$ne','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','=\x20?','<>\x20?','$substring','$endsWith','LIKE\x20?','$lt','<\x20?','>\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','$notIn','start','$startsWith','pop','utcOffset','minutes','lodash','moment','parseSearch','sqlOperator','startsWith','and','replace','[$and]','split','length','shift','match','indexOf','map','conditions','push','buildExpression','DATE','operator','$eq','$between','value','includes','$gt','$lte','add','days','format'];(function(_0x4d180c,_0x45c68e){var _0x49b57e=function(_0x264741){while(--_0x264741){_0x4d180c['push'](_0x4d180c['shift']());}};_0x49b57e(++_0x45c68e);}(_0xcb93,0x13a));var _0x3cb9=function(_0x33f11f,_0x501b30){_0x33f11f=_0x33f11f-0x0;var _0x55ef2a=_0xcb93[_0x33f11f];return _0x55ef2a;};'use strict';var _=require(_0x3cb9('0x0'));var moment=require(_0x3cb9('0x1'));exports[_0x3cb9('0x2')]=function(_0x51740e){var _0x57eab0={'conditions':[]};_0x57eab0[_0x3cb9('0x3')]=_[_0x3cb9('0x4')](_0x51740e,'[$or]')?'or':_0x3cb9('0x5');var _0x306f7e=_0x51740e[_0x3cb9('0x6')](_0x3cb9('0x7'),'')['replace']('[$or]','')[_0x3cb9('0x8')]('||');for(var _0x14cc7a=0x0;_0x14cc7a<_0x306f7e[_0x3cb9('0x9')];_0x14cc7a++){var _0x4f02f2=_0x306f7e[_0x14cc7a][_0x3cb9('0x8')](':=');var _0x397e30=_0x4f02f2[0x0];var _0xf0f223=_0x4f02f2['slice'](0x1);_0xf0f223['forEach'](function(_0x480e1f){var _0x519dfd=_0x480e1f['split']('[')[_0x3cb9('0xa')]();var _0xb11015=_0x480e1f[_0x3cb9('0xb')](/\[(.*?)\]/g);_0xb11015['forEach'](function(_0x48934a){var _0x56adfa=_0x48934a['split']('[')['filter'](function(_0x540925){return _0x540925[_0x3cb9('0xc')](']')>-0x1;})[_0x3cb9('0xd')](function(_0x3af813){return _0x3af813[_0x3cb9('0x8')](']')[0x0];})[0x0];_0x57eab0[_0x3cb9('0xe')][_0x3cb9('0xf')]({'field':_0x397e30,'operator':_0x519dfd,'value':_0x56adfa});});});}return _0x57eab0;};exports[_0x3cb9('0x10')]=function(_0x511e6d,_0x46320b,_0x5d11b9){var _0x1d6444={};if(_0x46320b===_0x3cb9('0x11')){if(_0x5d11b9[_0x3cb9('0x12')]===_0x3cb9('0x13')){_0x5d11b9[_0x3cb9('0x12')]=_0x3cb9('0x14');_0x5d11b9['value']+=','+_0x5d11b9[_0x3cb9('0x15')];}else if(_[_0x3cb9('0x16')]([_0x3cb9('0x17'),_0x3cb9('0x18')],_0x5d11b9[_0x3cb9('0x12')])){_0x5d11b9[_0x3cb9('0x15')]=moment(_0x5d11b9[_0x3cb9('0x15')])[_0x3cb9('0x19')](0x1,_0x3cb9('0x1a'))[_0x3cb9('0x1b')](_0x3cb9('0x1c'));}}if(_0x5d11b9['castTo']){_0x46320b=_0x5d11b9['castTo'];_0x1d6444['text']=_0x3cb9('0x1d')+_0x511e6d+'.'+_0x5d11b9[_0x3cb9('0x1e')]+_0x3cb9('0x1f')+_0x5d11b9[_0x3cb9('0x20')]+')\x20'+parseOperator(_0x5d11b9[_0x3cb9('0x12')]);}else{_0x1d6444[_0x3cb9('0x21')]=_0x511e6d+'.'+_0x5d11b9[_0x3cb9('0x1e')]+'\x20'+parseOperator(_0x5d11b9[_0x3cb9('0x12')]);}if(_['includes']([_0x3cb9('0x22'),'$notIn'],_0x5d11b9[_0x3cb9('0x12')]))_0x1d6444[_0x3cb9('0x21')]='('+_0x1d6444[_0x3cb9('0x21')]+_0x3cb9('0x23')+_0x511e6d+'.'+_0x5d11b9[_0x3cb9('0x1e')]+_0x3cb9('0x24');_0x1d6444[_0x3cb9('0x15')]=parseValue(_0x46320b,_0x5d11b9[_0x3cb9('0x12')],_0x5d11b9[_0x3cb9('0x15')]);return _0x1d6444;};function parseOperator(_0x34a39){var _0x337ca4;switch(_0x34a39){case _0x3cb9('0x25'):_0x337ca4=_0x3cb9('0x26');break;case'$notIn':_0x337ca4=_0x3cb9('0x27');break;case _0x3cb9('0x13'):_0x337ca4=_0x3cb9('0x28');break;case'$ne':_0x337ca4=_0x3cb9('0x29');break;case _0x3cb9('0x2a'):case'$startsWith':case _0x3cb9('0x2b'):_0x337ca4=_0x3cb9('0x2c');break;case _0x3cb9('0x2d'):_0x337ca4=_0x3cb9('0x2e');break;case _0x3cb9('0x17'):_0x337ca4=_0x3cb9('0x2f');break;case _0x3cb9('0x18'):_0x337ca4='<=\x20?';break;case _0x3cb9('0x30'):_0x337ca4=_0x3cb9('0x31');break;case _0x3cb9('0x14'):_0x337ca4=_0x3cb9('0x32');break;}return _0x337ca4;}function parseValue(_0x17b18a,_0x1dbaaa,_0x273c9f){var _0x583d27={'start':undefined,'end':undefined};switch(_0x1dbaaa){case'$in':case _0x3cb9('0x33'):_0x583d27[_0x3cb9('0x34')]=_0x273c9f[_0x3cb9('0x8')](',');break;case _0x3cb9('0x2a'):_0x583d27[_0x3cb9('0x34')]='%'+_0x273c9f+'%';break;case _0x3cb9('0x35'):_0x583d27[_0x3cb9('0x34')]=_0x273c9f+'%';break;case _0x3cb9('0x2b'):_0x583d27[_0x3cb9('0x34')]='%'+_0x273c9f;break;case _0x3cb9('0x14'):var _0x2b3986=_0x273c9f[_0x3cb9('0x8')](',');var _0x273c9f=_0x2b3986[_0x3cb9('0xa')]();var _0x3bf854=_0x2b3986[_0x3cb9('0x36')]();if(_0x17b18a==='DATE'){_0x273c9f=moment(_0x273c9f)[_0x3cb9('0x37')](0x0,!![])['format']();_0x3bf854=moment(_0x3bf854)['utcOffset'](0x0,!![])[_0x3cb9('0x19')](0x17,'hours')[_0x3cb9('0x19')](0x3b,_0x3cb9('0x38'))[_0x3cb9('0x19')](0x3b,'seconds')[_0x3cb9('0x1b')]();}_0x583d27={'start':_0x273c9f,'end':_0x3bf854};break;default:_0x583d27[_0x3cb9('0x34')]=_0x273c9f;break;}return _0x583d27;}