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 _0x978b=['$gt','>\x20?','$gte','BETWEEN\x20?\x20AND\x20?','$in','start','$endsWith','pop','utcOffset','add','seconds','lodash','moment','sqlOperator','startsWith','and','replace','[$and]','length','split','slice','forEach','shift','match','filter','indexOf','map','conditions','push','DATE','operator','$eq','$between','value','includes','$lte','format','YYYY-MM-DD','text','CAST(','field','$notIn','\x20IS\x20NULL)','IN\x20?','NOT\x20IN\x20?','=\x20?','$ne','$startsWith','LIKE\x20?','$lt','<\x20?'];(function(_0x5e4563,_0x3ff918){var _0x8d1bf5=function(_0x3bf7a9){while(--_0x3bf7a9){_0x5e4563['push'](_0x5e4563['shift']());}};_0x8d1bf5(++_0x3ff918);}(_0x978b,0x170));var _0xb978=function(_0x5186b2,_0x3c9f38){_0x5186b2=_0x5186b2-0x0;var _0x19a73c=_0x978b[_0x5186b2];return _0x19a73c;};'use strict';var _=require(_0xb978('0x0'));var moment=require(_0xb978('0x1'));exports['parseSearch']=function(_0x2b04ee){var _0x208b84={'conditions':[]};_0x208b84[_0xb978('0x2')]=_[_0xb978('0x3')](_0x2b04ee,'[$or]')?'or':_0xb978('0x4');var _0x1ec155=_0x2b04ee[_0xb978('0x5')](_0xb978('0x6'),'')[_0xb978('0x5')]('[$or]','')['split']('||');for(var _0x3eb0b4=0x0;_0x3eb0b4<_0x1ec155[_0xb978('0x7')];_0x3eb0b4++){var _0x455ff5=_0x1ec155[_0x3eb0b4][_0xb978('0x8')](':=');var _0x3dbbf8=_0x455ff5[0x0];var _0x416ad3=_0x455ff5[_0xb978('0x9')](0x1);_0x416ad3[_0xb978('0xa')](function(_0xcb50cb){var _0x6c9d79=_0xcb50cb[_0xb978('0x8')]('[')[_0xb978('0xb')]();var _0x509ea0=_0xcb50cb[_0xb978('0xc')](/\[(.*?)\]/g);_0x509ea0[_0xb978('0xa')](function(_0x588a7a){var _0x14dcf7=_0x588a7a['split']('[')[_0xb978('0xd')](function(_0x4c609){return _0x4c609[_0xb978('0xe')](']')>-0x1;})[_0xb978('0xf')](function(_0x14f40c){return _0x14f40c[_0xb978('0x8')](']')[0x0];})[0x0];_0x208b84[_0xb978('0x10')][_0xb978('0x11')]({'field':_0x3dbbf8,'operator':_0x6c9d79,'value':_0x14dcf7});});});}return _0x208b84;};exports['buildExpression']=function(_0x1e96c9,_0x163e30,_0x1181d0){var _0x588b2a={};if(_0x163e30===_0xb978('0x12')){if(_0x1181d0[_0xb978('0x13')]===_0xb978('0x14')){_0x1181d0[_0xb978('0x13')]=_0xb978('0x15');_0x1181d0[_0xb978('0x16')]+=','+_0x1181d0[_0xb978('0x16')];}else if(_[_0xb978('0x17')](['$gt',_0xb978('0x18')],_0x1181d0[_0xb978('0x13')])){_0x1181d0[_0xb978('0x16')]=moment(_0x1181d0[_0xb978('0x16')])['add'](0x1,'days')[_0xb978('0x19')](_0xb978('0x1a'));}}if(_0x1181d0['castTo']){_0x163e30=_0x1181d0['castTo'];_0x588b2a[_0xb978('0x1b')]=_0xb978('0x1c')+_0x1e96c9+'.'+_0x1181d0[_0xb978('0x1d')]+'\x20AS\x20'+_0x1181d0['castTo']+')\x20'+parseOperator(_0x1181d0[_0xb978('0x13')]);}else{_0x588b2a['text']=_0x1e96c9+'.'+_0x1181d0[_0xb978('0x1d')]+'\x20'+parseOperator(_0x1181d0[_0xb978('0x13')]);}if(_[_0xb978('0x17')](['$ne',_0xb978('0x1e')],_0x1181d0[_0xb978('0x13')]))_0x588b2a['text']='('+_0x588b2a[_0xb978('0x1b')]+'\x20OR\x20'+_0x1e96c9+'.'+_0x1181d0[_0xb978('0x1d')]+_0xb978('0x1f');_0x588b2a['value']=parseValue(_0x163e30,_0x1181d0[_0xb978('0x13')],_0x1181d0[_0xb978('0x16')]);return _0x588b2a;};function parseOperator(_0x172e25){var _0x4914ae;switch(_0x172e25){case'$in':_0x4914ae=_0xb978('0x20');break;case _0xb978('0x1e'):_0x4914ae=_0xb978('0x21');break;case _0xb978('0x14'):_0x4914ae=_0xb978('0x22');break;case _0xb978('0x23'):_0x4914ae='<>\x20?';break;case'$substring':case _0xb978('0x24'):case'$endsWith':_0x4914ae=_0xb978('0x25');break;case _0xb978('0x26'):_0x4914ae=_0xb978('0x27');break;case _0xb978('0x28'):_0x4914ae=_0xb978('0x29');break;case _0xb978('0x18'):_0x4914ae='<=\x20?';break;case _0xb978('0x2a'):_0x4914ae='>=\x20?';break;case _0xb978('0x15'):_0x4914ae=_0xb978('0x2b');break;}return _0x4914ae;}function parseValue(_0x4273f9,_0x234b62,_0x26a587){var _0x4087f5={'start':undefined,'end':undefined};switch(_0x234b62){case _0xb978('0x2c'):case _0xb978('0x1e'):_0x4087f5[_0xb978('0x2d')]=_0x26a587['split'](',');break;case'$substring':_0x4087f5[_0xb978('0x2d')]='%'+_0x26a587+'%';break;case'$startsWith':_0x4087f5['start']=_0x26a587+'%';break;case _0xb978('0x2e'):_0x4087f5[_0xb978('0x2d')]='%'+_0x26a587;break;case'$between':var _0x2ae3da=_0x26a587[_0xb978('0x8')](',');var _0x26a587=_0x2ae3da[_0xb978('0xb')]();var _0x21e478=_0x2ae3da[_0xb978('0x2f')]();if(_0x4273f9==='DATE'){_0x26a587=moment(_0x26a587)[_0xb978('0x30')](0x0,!![])[_0xb978('0x19')]();_0x21e478=moment(_0x21e478)[_0xb978('0x30')](0x0,!![])[_0xb978('0x31')](0x17,'hours')[_0xb978('0x31')](0x3b,'minutes')[_0xb978('0x31')](0x3b,_0xb978('0x32'))[_0xb978('0x19')]();}_0x4087f5={'start':_0x26a587,'end':_0x21e478};break;default:_0x4087f5[_0xb978('0x2d')]=_0x26a587;break;}return _0x4087f5;}