Built motion from commit 56a37f2a.|2.6.21
[motion2.git] / server / components / interaction / sql-utils.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 _0x0749=['offset','enableEmailPreview','clone','COUNT(*)','isEmpty','query','exports','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','./utils','role','agent','search','field','from','tools_tags','user_has_','_interactions','u.id','ui.','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionsTables','select','left_join','cm_contacts','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','sms','whatsapp','includes','fax','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','mail','isEmail','c.email\x20LIKE\x20?','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','sqlOperator','conditions','find','buildExpression','type','default','text','value','start','end','unreadMessages','and','Contact','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','Tag','split','clause','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','user','body','getAccountFK','keys','some','name','compact','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','read','tag','tags','filter','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','join','getInteractionFK','QueryTypes','SELECT','sequelize','toString','keyBy','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.subject','i.ContactId','i.UserId','contactName','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.*','c.firstName','c.lastName','c.email','Contact.email','c.phone','c.mobile','Contact.mobile','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit'];(function(_0x3e0cf2,_0x53e381){var _0x55444a=function(_0x137c1a){while(--_0x137c1a){_0x3e0cf2['push'](_0x3e0cf2['shift']());}};_0x55444a(++_0x53e381);}(_0x0749,0x141));var _0x9074=function(_0x2be8c2,_0x14a4b5){_0x2be8c2=_0x2be8c2-0x0;var _0x97f531=_0x0749[_0x2be8c2];return _0x97f531;};'use strict';var _=require('lodash');var squel=require(_0x9074('0x0'));var as=require(_0x9074('0x1'));var qs=require(_0x9074('0x2'));var updateInteraction=require(_0x9074('0x3'))['updateInteraction'];var utils=require(_0x9074('0x4'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x411e43,_0x13bfb8,_0x2f8be3){var _0x225cc2=![];var _0x50e977=utils['getAccountFK'](_0x411e43);if(_0x13bfb8[_0x9074('0x5')]===_0x9074('0x6')&&!_0x2f8be3[_0x9074('0x7')]&&!_0x2f8be3[_0x50e977]){_0x225cc2=!![];}return _0x225cc2;}function getTagsQuery(){return squel['select']()[_0x9074('0x8')]('id')['field']('name')[_0x9074('0x8')]('color')[_0x9074('0x9')](_0x9074('0xa'));}function getUsersQuery(_0x41db41,_0x59e05f){var _0x11f95d=utils['getInteractionFK'](_0x41db41);var _0x11faaf=_0x9074('0xb')+_0x41db41+_0x9074('0xc');var _0x3403ca=squel['select']()[_0x9074('0x8')](_0x9074('0xd'))[_0x9074('0x8')]('u.fullname')[_0x9074('0x8')](_0x9074('0xe')+_0x11f95d)[_0x9074('0x9')](_0x11faaf,'ui')['left_join'](_0x9074('0xf'),'u',_0x9074('0x10'));if(_0x59e05f[_0x9074('0x11')]>0x0){_0x3403ca[_0x9074('0x12')](_0x9074('0xe')+_0x11f95d+_0x9074('0x13'),_[_0x9074('0x14')](_0x59e05f,'id'));}return _0x3403ca;}function getInteractionsQuery(_0x549cc3){var _0x4385dd=utils[_0x9074('0x15')](_0x549cc3);var _0x55a77c=utils['getAccountFK'](_0x549cc3);var _0x21df1c=utils['getInteractionFK'](_0x549cc3);return squel[_0x9074('0x16')]()[_0x9074('0x9')](_0x4385dd['interactions'],'i')[_0x9074('0x17')](_0x9074('0x18'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x9074('0x17')](_0x9074('0xf'),'o',_0x9074('0x19'))['left_join'](_0x4385dd[_0x9074('0x1a')],'a',_0x9074('0x1b')+_0x55a77c)[_0x9074('0x17')](_0x4385dd[_0x9074('0x1c')],'me',_0x9074('0x1d')+_0x21df1c+_0x9074('0x1e'))['left_join'](_0x4385dd['interactionsTags'],'it',_0x9074('0x1f')+_0x21df1c+_0x9074('0x1e'))[_0x9074('0x17')](_0x9074('0xa'),'t',_0x9074('0x20'));}function getSqlClauses(){var _0x126cd8={'body':squel['expr'](),'contact':squel[_0x9074('0x21')](),'default':squel[_0x9074('0x21')](),'fields':squel['expr'](),'filter':squel[_0x9074('0x21')](),'read':squel[_0x9074('0x21')](),'tags':{'clause':squel[_0x9074('0x21')](),'ids':null},'user':squel[_0x9074('0x21')]()};return _0x126cd8;}function parseTagParameter(_0x1ccc83){var _0x18de12=squel['expr']();if(_0x1ccc83){var _0x43637f=utils[_0x9074('0x22')](_0x1ccc83);_0x43637f[_0x9074('0x23')](function(_0x2c9005){_0x18de12['or'](_0x9074('0x24'),'%,'+_0x2c9005+',%');});}return _0x18de12;}function parseReadParameter(_0x1ba727){var _0xa034ac='';if(_0x1ba727){_0xa034ac=_0x9074('0x25');if(_0x1ba727==='1'){_0xa034ac=_0xa034ac[_0x9074('0x26')](_0x9074('0x27'),'=');}else{_0xa034ac=_0xa034ac[_0x9074('0x26')](_0x9074('0x27'),'>');}}return _0xa034ac;}function parseSearchFilter(_0x3a6891,_0x384e04){var _0x1990c6=squel[_0x9074('0x21')]();if(_0x384e04){var _0x140fc2=_0x384e04[_0x9074('0x26')]('\x5c','\x5c\x5c')[_0x9074('0x26')](/'/g,'\x27\x27');if(qs[_0x9074('0x28')](_0x140fc2)){_0x1990c6['or']('i.id\x20LIKE\x20?',_0x140fc2+'%');if([_0x9074('0x29'),_0x9074('0x2a')][_0x9074('0x2b')](_0x3a6891)){_0x1990c6['or']('i.phone\x20LIKE\x20?',_0x140fc2+'%');}else if(_0x3a6891===_0x9074('0x2c')){_0x1990c6['or'](_0x9074('0x2d'),_0x140fc2+'%');}else if(_0x3a6891===_0x9074('0x2e')){_0x1990c6['or'](_0x9074('0x2f'),_0x140fc2+'%');}}else if(_0x3a6891===_0x9074('0x30')&&qs[_0x9074('0x31')](_0x140fc2)){_0x1990c6['or'](_0x9074('0x32'),_0x140fc2+'%');}else{if(_0x3a6891===_0x9074('0x30')){_0x1990c6['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x9074('0x33')](_0x140fc2,!![]))['or'](_0x9074('0x34'),qs['getFullTextValue'](_0x140fc2));}else if(_0x3a6891!==_0x9074('0x2c')){_0x1990c6['or'](_0x9074('0x35'),qs['getFullTextValue'](_0x140fc2));}_0x1990c6['or'](_0x9074('0x36'),qs[_0x9074('0x33')](_0x140fc2,!![]),null);}}return _0x1990c6;}function parseAdvancedSearchFilter(_0x517f62,_0x739509){var _0x339c68=getSqlClauses();var _0x14c9b8=as['parseSearch'](_0x517f62);var _0x510bfa=_0x14c9b8[_0x9074('0x37')];for(var _0x4fa3b2=0x0;_0x4fa3b2<_0x14c9b8[_0x9074('0x38')]['length'];_0x4fa3b2++){var _0x36e4d7=_0x14c9b8[_0x9074('0x38')][_0x4fa3b2];var _0x24845a='i';var _0x350fcc=_[_0x9074('0x39')](_0x739509,['name',_0x36e4d7[_0x9074('0x8')]]);if(_0x350fcc){var _0x2e4883=as[_0x9074('0x3a')](_0x24845a,_0x350fcc[_0x9074('0x3b')],_0x36e4d7);_0x339c68[_0x9074('0x3c')][_0x510bfa](_0x2e4883[_0x9074('0x3d')],_0x2e4883[_0x9074('0x3e')][_0x9074('0x3f')],_0x2e4883['value'][_0x9074('0x40')]);}else{switch(_0x36e4d7['field']){case _0x9074('0x41'):var _0x5b8646=parseReadParameter(_0x36e4d7['value']);_0x339c68['read'][_0x9074('0x42')](_0x5b8646);break;case _0x9074('0x43'):if(_0x36e4d7[_0x9074('0x44')]===_0x9074('0x45')){if(_0x36e4d7[_0x9074('0x3e')]['split']('\x20')[_0x9074('0x11')]>0x1){_0x339c68['contact'][_0x510bfa](_0x9074('0x36'),qs['getFullTextValue'](_0x36e4d7['value'],!![]),null);}else{var _0x2dde87='%'+_0x36e4d7['value']+'%';_0x339c68[_0x9074('0x46')][_0x510bfa](_0x9074('0x47'),_0x2dde87,_0x2dde87,_0x2dde87);}}else{_0x350fcc=_[_0x9074('0x39')](_0x739509,['name','ContactId']);_0x36e4d7[_0x9074('0x8')]='ContactId';_0x2e4883=as[_0x9074('0x3a')](_0x24845a,_0x350fcc[_0x9074('0x3b')],_0x36e4d7);_0x339c68['contact'][_0x510bfa](_0x2e4883['text'],_0x2e4883[_0x9074('0x3e')][_0x9074('0x3f')],_0x2e4883[_0x9074('0x3e')][_0x9074('0x40')]);}break;case _0x9074('0x48'):var _0x20c680=_0x36e4d7['value'][_0x9074('0x49')](',')[_0x9074('0x14')](function(_0xbf7907){return Number(_0xbf7907);});var _0x9de4dd=parseTagParameter(_0x20c680);_0x339c68['tags'][_0x9074('0x4a')][_0x9074('0x42')](_0x9de4dd);_0x339c68['tags']['ids']=_0x20c680;break;case _0x9074('0x4b'):if(_0x36e4d7[_0x9074('0x44')]===_0x9074('0x45')){_0x339c68['user'][_0x510bfa](_0x9074('0x4c'),'%'+_0x36e4d7[_0x9074('0x3e')]+'%',null);}else{_0x350fcc=_[_0x9074('0x39')](_0x739509,['name',_0x9074('0x4d')]);_0x36e4d7[_0x9074('0x8')]=_0x9074('0x4d');_0x2e4883=as[_0x9074('0x3a')](_0x24845a,_0x350fcc[_0x9074('0x3b')],_0x36e4d7);_0x339c68[_0x9074('0x4e')][_0x510bfa](_0x2e4883[_0x9074('0x3d')],_0x2e4883[_0x9074('0x3e')][_0x9074('0x3f')],_0x2e4883[_0x9074('0x3e')]['end']);}break;case _0x9074('0x4f'):case'plainBody':_0x2e4883=as['buildExpression']('me',null,_0x36e4d7);_0x339c68[_0x9074('0x4f')][_0x510bfa](_0x2e4883[_0x9074('0x3d')],_0x2e4883[_0x9074('0x3e')][_0x9074('0x3f')],_0x2e4883[_0x9074('0x3e')]['end']);break;}}}return _0x339c68;}function parseModelFields(_0x4d85ac,_0x34d105,_0x1539ba){var _0x3a075f=utils[_0x9074('0x50')](_0x4d85ac);var _0x56f732=squel[_0x9074('0x21')]();var _0x24c6dd=_(_0x34d105)[_0x9074('0x51')]()['map'](function(_0x535ca4){return _[_0x9074('0x52')](_0x1539ba,[_0x9074('0x53'),_0x535ca4])?_0x535ca4:undefined;})[_0x9074('0x54')]()[_0x9074('0x3e')]();if(_0x24c6dd['length']>0x0){_0x24c6dd[_0x9074('0x23')](function(_0x363968){if(_0x363968===_0x3a075f){_0x56f732[_0x9074('0x42')]('i.'+_0x3a075f+'\x20IN\x20?',[][_0x9074('0x55')](_0x34d105[_0x363968]));}else if(_0x363968===_0x9074('0x56')){var _0x1fe4a1=JSON['parse'](_0x34d105[_0x363968])['$gte'];var _0x32c01d=JSON[_0x9074('0x57')](_0x34d105[_0x363968])[_0x9074('0x58')];_0x56f732[_0x9074('0x42')](_0x9074('0x59'),_0x1fe4a1,_0x32c01d);}else{if(_0x34d105[_0x363968]==='null'){_0x56f732[_0x9074('0x42')]('i.'+_0x363968+_0x9074('0x5a'));}else{_0x56f732[_0x9074('0x42')]('i.'+_0x363968+_0x9074('0x5b'),_0x34d105[_0x363968]);}}});}return _0x56f732;}function parseQueryParameters(_0x36c207,_0x3e995d,_0x34003a){var _0x46851f=getSqlClauses();return Promise[_0x9074('0x5c')]()[_0x9074('0x5d')](function(){return parseModelFields(_0x36c207,_0x3e995d,_0x34003a);})[_0x9074('0x5d')](function(_0x5694cc){_0x46851f[_0x9074('0x5e')][_0x9074('0x42')](_0x5694cc);return parseReadParameter(_0x3e995d[_0x9074('0x5f')]);})['then'](function(_0x2f31d3){_0x46851f[_0x9074('0x5f')][_0x9074('0x42')](_0x2f31d3);return parseTagParameter(_0x3e995d[_0x9074('0x60')]);})[_0x9074('0x5d')](function(_0x2d6fcc){_0x46851f[_0x9074('0x61')]['clause']['and'](_0x2d6fcc);return parseSearchFilter(_0x36c207,_0x3e995d[_0x9074('0x62')]);})[_0x9074('0x5d')](function(_0x1a7031){_0x46851f[_0x9074('0x62')]=_0x1a7031;return _0x46851f;});}function checkAccountsRestrictions(_0x529d6b,_0x10d914,_0xabecf2){var _0x468454=utils['getAccountFK'](_0x529d6b);var _0x3b2354='get'+_[_0x9074('0x63')](_0x529d6b)+(_0x529d6b===_0x9074('0x64')?_0x9074('0x65'):_0x9074('0x66'));var _0x56b318=squel[_0x9074('0x21')]();return Promise[_0x9074('0x5c')]()['then'](function(){if(_0xabecf2['search']&&_0x10d914[_0x9074('0x5')]===_0x9074('0x6')){return _0x10d914[_0x3b2354]({'attributes':['id'],'raw':!![]});}})[_0x9074('0x5d')](function(_0x418e47){if(_0x418e47){if(_0x418e47['length']===0x0){_0x56b318[_0x9074('0x42')]('i.'+_0x468454+'\x20IS\x20NULL');}else{_0x56b318['and']('i.'+_0x468454+_0x9074('0x13'),_['map'](_0x418e47,'id'));}}else if(!_0xabecf2[_0x468454]){_0x56b318[_0x9074('0x42')]('i.'+_0x468454+_0x9074('0x67'));}})[_0x9074('0x5d')](function(){return _0x56b318;});}function getClosedOrderClause(_0x531fe1,_0x22b15e){var _0x24e64b='';var _0x35a834=[_0x9074('0x68'),_0x9074('0x69'),_0x9074('0x6a')];if(_0x531fe1==='mail'){_0x35a834[_0x9074('0x6b')](_0x9074('0x6c'));}if(_0x22b15e['closed']==='0'&&_0x531fe1==='mail'){_0x24e64b=_0x9074('0x6c');}else{if(_0x22b15e[_0x9074('0x6d')]==='1'){_0x35a834[_0x9074('0x6e')]();}_0x24e64b='CONCAT_WS(\x27\x27,\x20'+_0x35a834[_0x9074('0x6f')](',\x20')+')';}return _0x24e64b;}function getFilteredInteractions(_0x545752,_0x559078,_0x3338ae,_0x124a98){var _0xbd04b5=utils[_0x9074('0x70')](_0x545752);var _0x5b127d=_['capitalize'](_0x545752)+'Interaction';var _0x40d7bd=[];var _0x56d996=getTagsQuery();var _0x334928={'type':db['Sequelize'][_0x9074('0x71')][_0x9074('0x72')],'raw':!![]};var _0x1ce666=[];var _0x1d0334=[];return db[_0x9074('0x73')]['query'](_0x56d996[_0x9074('0x74')](),_0x334928)[_0x9074('0x5d')](function(_0x3af759){_0x40d7bd=_[_0x9074('0x75')](_0x3af759,'id');_0x334928=_['merge'](_0x334928,{'model':db[_0x5b127d],'mapToModel':!![],'nest':!![]});if(_0x3338ae['fields']){_0x124a98[_0x9074('0x76')][_0x9074('0x23')](function(_0x24a962){_0x559078[_0x9074('0x8')]('i.'+_0x24a962);});}else{_0x559078[_0x9074('0x8')](_0x9074('0x77'),_0x9074('0x41'));_0x559078[_0x9074('0x8')]('a.key',_0x9074('0x78'));_0x559078[_0x9074('0x8')](_0x9074('0x79'),_0x9074('0x7a'));if(_0x545752===_0x9074('0x30')){_0x559078[_0x9074('0x8')](_0x9074('0x7b'),'Account.email');_0x559078[_0x9074('0x8')](_0x9074('0x7c'),'contactName');_0x559078[_0x9074('0x8')]('i.id');_0x559078[_0x9074('0x8')](_0x9074('0x7d'));_0x559078[_0x9074('0x8')](_0x9074('0x7e'));_0x559078[_0x9074('0x8')](_0x9074('0x7f'));_0x559078[_0x9074('0x8')](_0x9074('0x80'));_0x559078[_0x9074('0x8')](_0x9074('0x81'));_0x559078[_0x9074('0x8')](_0x9074('0x82'));_0x559078[_0x9074('0x8')]('i.lastMsgDirection');_0x559078[_0x9074('0x8')](_0x9074('0x83'));_0x559078[_0x9074('0x8')](_0x9074('0x6a'));_0x559078[_0x9074('0x8')](_0x9074('0x69'));_0x559078['field'](_0x9074('0x68'));_0x559078['field'](_0x9074('0x6c'));_0x559078[_0x9074('0x8')]('i.to');_0x559078['field'](_0x9074('0x84'));_0x559078[_0x9074('0x8')]('i.MailAccountId');_0x559078['field'](_0x9074('0x85'));}else if(_0x545752===_0x9074('0x2e')){_0x559078[_0x9074('0x8')]('CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END',_0x9074('0x86'));}else{_0x559078[_0x9074('0x8')](_0x9074('0x87'),_0x9074('0x86'));}if(_0x545752!==_0x9074('0x30')){_0x559078['field'](_0x9074('0x88'));}_0x559078[_0x9074('0x8')](_0x9074('0x89'),'Contact.firstName');_0x559078[_0x9074('0x8')](_0x9074('0x8a'),'Contact.lastName');_0x559078[_0x9074('0x8')](_0x9074('0x8b'),_0x9074('0x8c'));_0x559078[_0x9074('0x8')](_0x9074('0x8d'),'Contact.phone');_0x559078[_0x9074('0x8')](_0x9074('0x8e'),_0x9074('0x8f'));_0x559078[_0x9074('0x8')]('c.fax','Contact.fax');_0x559078[_0x9074('0x8')](_0x9074('0x90'),_0x9074('0x91'));_0x559078[_0x9074('0x8')](_0x9074('0x92'),_0x9074('0x93'));_0x559078[_0x9074('0x8')](_0x9074('0x94'),'TagIds');}if(_0x124a98[_0x9074('0x95')]){_0x559078['limit'](_0x124a98[_0x9074('0x95')]);}if(_0x124a98[_0x9074('0x96')]){_0x559078['offset'](_0x124a98[_0x9074('0x96')]);}return db[_0x9074('0x73')]['query'](_0x559078[_0x9074('0x74')](),_0x334928);})[_0x9074('0x5d')](function(_0x62d477){_0x1ce666=_0x62d477;var _0x38f438=getUsersQuery(_0x545752,_0x1ce666);return db[_0x9074('0x73')]['query'](_0x38f438[_0x9074('0x74')](),_0x334928);})[_0x9074('0x5d')](function(_0x37bc9f){_0x1d0334=_['groupBy'](_0x37bc9f,_0xbd04b5);if(_0x545752===_0x9074('0x30')){return db['Setting']['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x9074('0x5d')](function(_0x5cb833){var _0x3cf4bd=_0x5cb833?_0x5cb833[_0x9074('0x97')]:undefined;var _0x1921e8=_0x1ce666['map'](function(_0x6d2b46){return updateInteraction(_0x6d2b46,_0x40d7bd,_0x1d0334,_0x3cf4bd);});return Promise['all'](_0x1921e8);});}function countFilteredInteractions(_0x4c197c,_0x5f03a6){var _0x17cdc3=_0x4c197c[_0x9074('0x98')]();_0x17cdc3[_0x9074('0x8')](_0x9074('0x99'));_0x17cdc3[_0x9074('0x8')](_0x9074('0x77'),_0x9074('0x41'));var _0x3382dc=utils['getSelectedTags'](_0x5f03a6);if(!_[_0x9074('0x9a')](_0x3382dc)){_0x17cdc3[_0x9074('0x12')]('t.id\x20IN\x20?',_0x3382dc);}var _0x7068d={'type':db['Sequelize'][_0x9074('0x71')][_0x9074('0x72')],'raw':!![]};return db[_0x9074('0x73')][_0x9074('0x9b')](_0x17cdc3[_0x9074('0x74')](),_0x7068d);}module[_0x9074('0x9c')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};