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 _0x62c2=['$gte','>=\x20?','$between','BETWEEN\x20?\x20AND\x20?','start','utcOffset','format','hours','minutes','lodash','moment','sqlOperator','startsWith','[$or]','and','replace','[$and]','split','length','slice','forEach','shift','filter','indexOf','map','conditions','DATE','$eq','operator','value','includes','$gt','$lte','add','YYYY-MM-DD','text','CAST(','field','castTo','$ne','$notIn','\x20IS\x20NULL)','$in','NOT\x20IN\x20?','=\x20?','<>\x20?','$substring','$startsWith','$endsWith','LIKE\x20?','$lt','<\x20?','>\x20?','<=\x20?'];(function(_0x4d6ac0,_0x201628){var _0x5296c4=function(_0x3d0b3d){while(--_0x3d0b3d){_0x4d6ac0['push'](_0x4d6ac0['shift']());}};_0x5296c4(++_0x201628);}(_0x62c2,0x1b9));var _0x262c=function(_0x32baff,_0xb9efea){_0x32baff=_0x32baff-0x0;var _0x7a752a=_0x62c2[_0x32baff];return _0x7a752a;};'use strict';var _=require(_0x262c('0x0'));var moment=require(_0x262c('0x1'));exports['parseSearch']=function(_0x7bb810){var _0x722d4d={'conditions':[]};_0x722d4d[_0x262c('0x2')]=_[_0x262c('0x3')](_0x7bb810,_0x262c('0x4'))?'or':_0x262c('0x5');var _0x9afa04=_0x7bb810[_0x262c('0x6')](_0x262c('0x7'),'')[_0x262c('0x6')](_0x262c('0x4'),'')[_0x262c('0x8')]('||');for(var _0x22498a=0x0;_0x22498a<_0x9afa04[_0x262c('0x9')];_0x22498a++){var _0x2b96d5=_0x9afa04[_0x22498a][_0x262c('0x8')](':=');var _0x3ecc0b=_0x2b96d5[0x0];var _0x164b8d=_0x2b96d5[_0x262c('0xa')](0x1);_0x164b8d[_0x262c('0xb')](function(_0x5c175d){var _0x269470=_0x5c175d[_0x262c('0x8')]('[')[_0x262c('0xc')]();var _0x380bd9=_0x5c175d['match'](/\[(.*?)\]/g);_0x380bd9[_0x262c('0xb')](function(_0x278397){var _0x16ab28=_0x278397[_0x262c('0x8')]('[')[_0x262c('0xd')](function(_0x2d9cb4){return _0x2d9cb4[_0x262c('0xe')](']')>-0x1;})[_0x262c('0xf')](function(_0x5b293e){return _0x5b293e[_0x262c('0x8')](']')[0x0];})[0x0];_0x722d4d[_0x262c('0x10')]['push']({'field':_0x3ecc0b,'operator':_0x269470,'value':_0x16ab28});});});}return _0x722d4d;};exports['buildExpression']=function(_0x2b161f,_0x273d80,_0x5713c5){var _0x428631={};if(_0x273d80===_0x262c('0x11')){if(_0x5713c5['operator']===_0x262c('0x12')){_0x5713c5[_0x262c('0x13')]='$between';_0x5713c5[_0x262c('0x14')]+=','+_0x5713c5[_0x262c('0x14')];}else if(_[_0x262c('0x15')]([_0x262c('0x16'),_0x262c('0x17')],_0x5713c5[_0x262c('0x13')])){_0x5713c5['value']=moment(_0x5713c5[_0x262c('0x14')])[_0x262c('0x18')](0x1,'days')['format'](_0x262c('0x19'));}}if(_0x5713c5['castTo']){_0x273d80=_0x5713c5['castTo'];_0x428631[_0x262c('0x1a')]=_0x262c('0x1b')+_0x2b161f+'.'+_0x5713c5[_0x262c('0x1c')]+'\x20AS\x20'+_0x5713c5[_0x262c('0x1d')]+')\x20'+parseOperator(_0x5713c5[_0x262c('0x13')]);}else{_0x428631[_0x262c('0x1a')]=_0x2b161f+'.'+_0x5713c5[_0x262c('0x1c')]+'\x20'+parseOperator(_0x5713c5[_0x262c('0x13')]);}if(_[_0x262c('0x15')]([_0x262c('0x1e'),_0x262c('0x1f')],_0x5713c5[_0x262c('0x13')]))_0x428631[_0x262c('0x1a')]='('+_0x428631[_0x262c('0x1a')]+'\x20OR\x20'+_0x2b161f+'.'+_0x5713c5[_0x262c('0x1c')]+_0x262c('0x20');_0x428631['value']=parseValue(_0x273d80,_0x5713c5[_0x262c('0x13')],_0x5713c5[_0x262c('0x14')]);return _0x428631;};function parseOperator(_0x1ccbd9){var _0x24c83f;switch(_0x1ccbd9){case _0x262c('0x21'):_0x24c83f='IN\x20?';break;case _0x262c('0x1f'):_0x24c83f=_0x262c('0x22');break;case _0x262c('0x12'):_0x24c83f=_0x262c('0x23');break;case _0x262c('0x1e'):_0x24c83f=_0x262c('0x24');break;case _0x262c('0x25'):case _0x262c('0x26'):case _0x262c('0x27'):_0x24c83f=_0x262c('0x28');break;case _0x262c('0x29'):_0x24c83f=_0x262c('0x2a');break;case _0x262c('0x16'):_0x24c83f=_0x262c('0x2b');break;case _0x262c('0x17'):_0x24c83f=_0x262c('0x2c');break;case _0x262c('0x2d'):_0x24c83f=_0x262c('0x2e');break;case _0x262c('0x2f'):_0x24c83f=_0x262c('0x30');break;}return _0x24c83f;}function parseValue(_0x4439d8,_0x31c6e1,_0x257fdc){var _0x16d9fb={'start':undefined,'end':undefined};switch(_0x31c6e1){case _0x262c('0x21'):case _0x262c('0x1f'):_0x16d9fb['start']=_0x257fdc['split'](',');break;case'$substring':_0x16d9fb[_0x262c('0x31')]='%'+_0x257fdc+'%';break;case _0x262c('0x26'):_0x16d9fb[_0x262c('0x31')]=_0x257fdc+'%';break;case _0x262c('0x27'):_0x16d9fb[_0x262c('0x31')]='%'+_0x257fdc;break;case _0x262c('0x2f'):var _0x3b7836=_0x257fdc[_0x262c('0x8')](',');var _0x257fdc=_0x3b7836[_0x262c('0xc')]();var _0x3249ca=_0x3b7836['pop']();if(_0x4439d8==='DATE'){_0x257fdc=moment(_0x257fdc)[_0x262c('0x32')](0x0,!![])[_0x262c('0x33')]();_0x3249ca=moment(_0x3249ca)['utcOffset'](0x0,!![])[_0x262c('0x18')](0x17,_0x262c('0x34'))[_0x262c('0x18')](0x3b,_0x262c('0x35'))['add'](0x3b,'seconds')[_0x262c('0x33')]();}_0x16d9fb={'start':_0x257fdc,'end':_0x3249ca};break;default:_0x16d9fb[_0x262c('0x31')]=_0x257fdc;break;}return _0x16d9fb;}