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 _0xd59c=['replace','[$and]','[$or]','split','length','slice','shift','forEach','filter','map','conditions','DATE','operator','$eq','$between','value','includes','$lte','add','days','format','YYYY-MM-DD','castTo','CAST(','field','text','$notIn','\x20OR\x20','\x20IS\x20NULL)','$in','IN\x20?','NOT\x20IN\x20?','=\x20?','$ne','<>\x20?','$substring','$startsWith','LIKE\x20?','$lt','$gt','>\x20?','<=\x20?','$gte','>=\x20?','BETWEEN\x20?\x20AND\x20?','start','$endsWith','pop','utcOffset','hours','seconds','lodash','parseSearch','sqlOperator','startsWith','and'];(function(_0x39ce5a,_0x260622){var _0x46cd9a=function(_0x39fcba){while(--_0x39fcba){_0x39ce5a['push'](_0x39ce5a['shift']());}};_0x46cd9a(++_0x260622);}(_0xd59c,0x113));var _0xcd59=function(_0x3e3557,_0xa9fee9){_0x3e3557=_0x3e3557-0x0;var _0x30e3fd=_0xd59c[_0x3e3557];return _0x30e3fd;};'use strict';var _=require(_0xcd59('0x0'));var moment=require('moment');exports[_0xcd59('0x1')]=function(_0x12ccc0){var _0x2bacc2={'conditions':[]};_0x2bacc2[_0xcd59('0x2')]=_[_0xcd59('0x3')](_0x12ccc0,'[$or]')?'or':_0xcd59('0x4');var _0x1ff0a5=_0x12ccc0[_0xcd59('0x5')](_0xcd59('0x6'),'')[_0xcd59('0x5')](_0xcd59('0x7'),'')[_0xcd59('0x8')]('||');for(var _0x1d3baf=0x0;_0x1d3baf<_0x1ff0a5[_0xcd59('0x9')];_0x1d3baf++){var _0x574870=_0x1ff0a5[_0x1d3baf][_0xcd59('0x8')](':=');var _0x2268e0=_0x574870[0x0];var _0x156445=_0x574870[_0xcd59('0xa')](0x1);_0x156445['forEach'](function(_0x341272){var _0x523a97=_0x341272[_0xcd59('0x8')]('[')[_0xcd59('0xb')]();var _0x262a89=_0x341272['match'](/\[(.*?)\]/g);_0x262a89[_0xcd59('0xc')](function(_0x31ccd6){var _0x1efa19=_0x31ccd6[_0xcd59('0x8')]('[')[_0xcd59('0xd')](function(_0x5b0c57){return _0x5b0c57['indexOf'](']')>-0x1;})[_0xcd59('0xe')](function(_0x43f89a){return _0x43f89a[_0xcd59('0x8')](']')[0x0];})[0x0];_0x2bacc2[_0xcd59('0xf')]['push']({'field':_0x2268e0,'operator':_0x523a97,'value':_0x1efa19});});});}return _0x2bacc2;};exports['buildExpression']=function(_0x2e73df,_0x6b4e25,_0x5f034f){var _0x242f65={};if(_0x6b4e25===_0xcd59('0x10')){if(_0x5f034f[_0xcd59('0x11')]===_0xcd59('0x12')){_0x5f034f[_0xcd59('0x11')]=_0xcd59('0x13');_0x5f034f[_0xcd59('0x14')]+=','+_0x5f034f['value'];}else if(_[_0xcd59('0x15')](['$gt',_0xcd59('0x16')],_0x5f034f['operator'])){_0x5f034f['value']=moment(_0x5f034f['value'])[_0xcd59('0x17')](0x1,_0xcd59('0x18'))[_0xcd59('0x19')](_0xcd59('0x1a'));}}if(_0x5f034f[_0xcd59('0x1b')]){_0x6b4e25=_0x5f034f['castTo'];_0x242f65['text']=_0xcd59('0x1c')+_0x2e73df+'.'+_0x5f034f[_0xcd59('0x1d')]+'\x20AS\x20'+_0x5f034f[_0xcd59('0x1b')]+')\x20'+parseOperator(_0x5f034f[_0xcd59('0x11')]);}else{_0x242f65[_0xcd59('0x1e')]=_0x2e73df+'.'+_0x5f034f['field']+'\x20'+parseOperator(_0x5f034f['operator']);}if(_[_0xcd59('0x15')](['$ne',_0xcd59('0x1f')],_0x5f034f['operator']))_0x242f65['text']='('+_0x242f65['text']+_0xcd59('0x20')+_0x2e73df+'.'+_0x5f034f['field']+_0xcd59('0x21');_0x242f65[_0xcd59('0x14')]=parseValue(_0x6b4e25,_0x5f034f[_0xcd59('0x11')],_0x5f034f[_0xcd59('0x14')]);return _0x242f65;};function parseOperator(_0x5b23fc){var _0x5abb68;switch(_0x5b23fc){case _0xcd59('0x22'):_0x5abb68=_0xcd59('0x23');break;case _0xcd59('0x1f'):_0x5abb68=_0xcd59('0x24');break;case _0xcd59('0x12'):_0x5abb68=_0xcd59('0x25');break;case _0xcd59('0x26'):_0x5abb68=_0xcd59('0x27');break;case _0xcd59('0x28'):case _0xcd59('0x29'):case'$endsWith':_0x5abb68=_0xcd59('0x2a');break;case _0xcd59('0x2b'):_0x5abb68='<\x20?';break;case _0xcd59('0x2c'):_0x5abb68=_0xcd59('0x2d');break;case _0xcd59('0x16'):_0x5abb68=_0xcd59('0x2e');break;case _0xcd59('0x2f'):_0x5abb68=_0xcd59('0x30');break;case'$between':_0x5abb68=_0xcd59('0x31');break;}return _0x5abb68;}function parseValue(_0xf139bb,_0x178e05,_0x1a0a4d){var _0xef4955={'start':undefined,'end':undefined};switch(_0x178e05){case'$in':case _0xcd59('0x1f'):_0xef4955[_0xcd59('0x32')]=_0x1a0a4d[_0xcd59('0x8')](',');break;case'$substring':_0xef4955[_0xcd59('0x32')]='%'+_0x1a0a4d+'%';break;case _0xcd59('0x29'):_0xef4955[_0xcd59('0x32')]=_0x1a0a4d+'%';break;case _0xcd59('0x33'):_0xef4955[_0xcd59('0x32')]='%'+_0x1a0a4d;break;case'$between':var _0x13a6d9=_0x1a0a4d[_0xcd59('0x8')](',');var _0x1a0a4d=_0x13a6d9['shift']();var _0x5ed21a=_0x13a6d9[_0xcd59('0x34')]();if(_0xf139bb==='DATE'){_0x1a0a4d=moment(_0x1a0a4d)[_0xcd59('0x35')](0x0,!![])[_0xcd59('0x19')]();_0x5ed21a=moment(_0x5ed21a)[_0xcd59('0x35')](0x0,!![])[_0xcd59('0x17')](0x17,_0xcd59('0x36'))[_0xcd59('0x17')](0x3b,'minutes')[_0xcd59('0x17')](0x3b,_0xcd59('0x37'))[_0xcd59('0x19')]();}_0xef4955={'start':_0x1a0a4d,'end':_0x5ed21a};break;default:_0xef4955[_0xcd59('0x32')]=_0x1a0a4d;break;}return _0xef4955;}