18 var _0xc413=['buildExpression','type','default','text','start','value','unreadMessages','read','and','Contact','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','end','Tag','tags','clause','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','keys','some','compact','\x20IN\x20?','createdAt','$gte','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','resolve','then','fields','filter','get','capitalize','chat','\x20IS\x20NULL','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','i.substatus','closed','CONCAT_WS(\x27\x27,\x20','join','Interaction','QueryTypes','SELECT','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','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','contactName','i.id','i.createdAt','i.updatedAt','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.to','i.ContactId','i.MailAccountId','i.UserId','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','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','c.firstName','Contact.firstName','Contact.lastName','c.email','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','Sequelize','exports','lodash','squel','../parsers/qs','./update-interaction','updateInteraction','./utils','getAccountFK','role','agent','search','select','field','name','color','from','getInteractionFK','u.id','u.fullname','ui.','where','map','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','left_join','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','it.','tools_tags','t.id\x20=\x20it.TagId','expr','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','mail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','length','find'];(function(_0x4bd9c5,_0x1017a6){var _0x207d49=function(_0x694f3c){while(--_0x694f3c){_0x4bd9c5['push'](_0x4bd9c5['shift']());}};_0x207d49(++_0x1017a6);}(_0xc413,0x6c));var _0x3c41=function(_0x3bf83f,_0x181cac){_0x3bf83f=_0x3bf83f-0x0;var _0x22c4a9=_0xc413[_0x3bf83f];return _0x22c4a9;};'use strict';var _=require(_0x3c41('0x0'));var squel=require(_0x3c41('0x1'));var as=require('../parsers/advancedSearch');var qs=require(_0x3c41('0x2'));var updateInteraction=require(_0x3c41('0x3'))[_0x3c41('0x4')];var utils=require(_0x3c41('0x5'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0xd032aa,_0x5b214a,_0x1bc69b){var _0x64f18c=![];var _0x14870c=utils[_0x3c41('0x6')](_0xd032aa);if(_0x5b214a[_0x3c41('0x7')]===_0x3c41('0x8')&&!_0x1bc69b[_0x3c41('0x9')]&&!_0x1bc69b[_0x14870c]){_0x64f18c=!![];}return _0x64f18c;}function getTagsQuery(){return squel[_0x3c41('0xa')]()[_0x3c41('0xb')]('id')[_0x3c41('0xb')](_0x3c41('0xc'))[_0x3c41('0xb')](_0x3c41('0xd'))[_0x3c41('0xe')]('tools_tags');}function getUsersQuery(_0x456afc,_0x55306b){var _0x41b692=utils[_0x3c41('0xf')](_0x456afc);var _0x212162='user_has_'+_0x456afc+'_interactions';var _0x159c8f=squel['select']()[_0x3c41('0xb')](_0x3c41('0x10'))['field'](_0x3c41('0x11'))[_0x3c41('0xb')](_0x3c41('0x12')+_0x41b692)[_0x3c41('0xe')](_0x212162,'ui')['left_join']('users','u','u.id\x20=\x20ui.UserId');if(_0x55306b['length']>0x0){_0x159c8f[_0x3c41('0x13')](_0x3c41('0x12')+_0x41b692+'\x20IN\x20?',_[_0x3c41('0x14')](_0x55306b,'id'));}return _0x159c8f;}function getInteractionsQuery(_0x3b5765){var _0x209806=utils[_0x3c41('0x15')](_0x3b5765);var _0x166587=utils[_0x3c41('0x6')](_0x3b5765);var _0x402e38=utils[_0x3c41('0xf')](_0x3b5765);return squel['select']()[_0x3c41('0xe')](_0x209806[_0x3c41('0x16')],'i')['left_join'](_0x3c41('0x17'),'c',_0x3c41('0x18'))['left_join'](_0x3c41('0x19'),'o',_0x3c41('0x1a'))[_0x3c41('0x1b')](_0x209806[_0x3c41('0x1c')],'a',_0x3c41('0x1d')+_0x166587)['left_join'](_0x209806[_0x3c41('0x1e')],'me',_0x3c41('0x1f')+_0x402e38+_0x3c41('0x20'))[_0x3c41('0x1b')](_0x209806[_0x3c41('0x21')],'it',_0x3c41('0x22')+_0x402e38+_0x3c41('0x20'))[_0x3c41('0x1b')](_0x3c41('0x23'),'t',_0x3c41('0x24'));}function getSqlClauses(){var _0x1a64df={'body':squel[_0x3c41('0x25')](),'contact':squel['expr'](),'default':squel['expr'](),'fields':squel[_0x3c41('0x25')](),'filter':squel['expr'](),'read':squel[_0x3c41('0x25')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x3c41('0x25')]()};return _0x1a64df;}function parseTagParameter(_0x28fd16){var _0x417e71=squel[_0x3c41('0x25')]();if(_0x28fd16){var _0x27fb2e=utils['getSelectedTags'](_0x28fd16);_0x27fb2e[_0x3c41('0x26')](function(_0x198e3e){_0x417e71['or'](_0x3c41('0x27'),'%,'+_0x198e3e+',%');});}return _0x417e71;}function parseReadParameter(_0x56180c){var _0x4dd846='';if(_0x56180c){_0x4dd846=_0x3c41('0x28');if(_0x56180c==='1'){_0x4dd846=_0x4dd846[_0x3c41('0x29')]('{OPERATOR}','=');}else{_0x4dd846=_0x4dd846[_0x3c41('0x29')](_0x3c41('0x2a'),'>');}}return _0x4dd846;}function parseSearchFilter(_0x5ec26e,_0x582792){var _0x56eeab=squel[_0x3c41('0x25')]();if(_0x582792){var _0x2596ab=_0x582792[_0x3c41('0x29')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');var _0x5101cf=qs['escapeLIKESpecialChars'](_0x2596ab);if(qs['isNumeric'](_0x2596ab)){_0x56eeab['or'](_0x3c41('0x2b'),_0x5101cf+'%');if([_0x3c41('0x2c'),_0x3c41('0x2d')][_0x3c41('0x2e')](_0x5ec26e)){_0x56eeab['or'](_0x3c41('0x2f'),_0x5101cf+'%');}else if(_0x5ec26e===_0x3c41('0x30')){_0x56eeab['or'](_0x3c41('0x31'),_0x5101cf+'%');}else if(_0x5ec26e===_0x3c41('0x32')){_0x56eeab['or'](_0x3c41('0x33'),_0x5101cf+'%');}}else if(_0x5ec26e===_0x3c41('0x34')&&qs['isEmail'](_0x2596ab)){_0x56eeab['or'](_0x3c41('0x35'),_0x5101cf+'%');}else{if(_0x5ec26e===_0x3c41('0x34')){_0x56eeab['or'](_0x3c41('0x36'),qs['getFullTextValue'](_0x2596ab,!![]))['or'](_0x3c41('0x37'),qs['getFullTextValue'](_0x2596ab));}else if(_0x5ec26e!==_0x3c41('0x30')){_0x56eeab['or'](_0x3c41('0x38'),qs[_0x3c41('0x39')](_0x2596ab));}_0x56eeab['or'](_0x3c41('0x3a'),qs[_0x3c41('0x39')](_0x2596ab,!![]),null);}}return _0x56eeab;}function parseAdvancedSearchFilter(_0xc7bb22,_0x2db7b1){var _0x36d403=getSqlClauses();var _0x219002=as[_0x3c41('0x3b')](_0xc7bb22);var _0xf4ae6c=_0x219002[_0x3c41('0x3c')];for(var _0x5d935e=0x0;_0x5d935e<_0x219002[_0x3c41('0x3d')][_0x3c41('0x3e')];_0x5d935e++){var _0x136c69=_0x219002[_0x3c41('0x3d')][_0x5d935e];var _0x48faaa='i';var _0x128877=_[_0x3c41('0x3f')](_0x2db7b1,['name',_0x136c69['field']]);if(_0x128877){var _0x4786c6=as[_0x3c41('0x40')](_0x48faaa,_0x128877[_0x3c41('0x41')],_0x136c69);_0x36d403[_0x3c41('0x42')][_0xf4ae6c](_0x4786c6[_0x3c41('0x43')],_0x4786c6['value'][_0x3c41('0x44')],_0x4786c6[_0x3c41('0x45')]['end']);}else{switch(_0x136c69[_0x3c41('0xb')]){case _0x3c41('0x46'):var _0x499015=parseReadParameter(_0x136c69[_0x3c41('0x45')]);_0x36d403[_0x3c41('0x47')][_0x3c41('0x48')](_0x499015);break;case _0x3c41('0x49'):if(_0x136c69[_0x3c41('0x4a')]===_0x3c41('0x4b')){if(_0x136c69[_0x3c41('0x45')][_0x3c41('0x4c')]('\x20')['length']>0x1){_0x36d403[_0x3c41('0x4d')][_0xf4ae6c]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x3c41('0x39')](_0x136c69['value'],!![]),null);}else{var _0x1b259d='%'+_0x136c69[_0x3c41('0x45')]+'%';_0x36d403[_0x3c41('0x4d')][_0xf4ae6c](_0x3c41('0x4e'),_0x1b259d,_0x1b259d,_0x1b259d);}}else{_0x128877=_[_0x3c41('0x3f')](_0x2db7b1,['name',_0x3c41('0x4f')]);_0x136c69['field']=_0x3c41('0x4f');_0x4786c6=as[_0x3c41('0x40')](_0x48faaa,_0x128877[_0x3c41('0x41')],_0x136c69);_0x36d403['contact'][_0xf4ae6c](_0x4786c6[_0x3c41('0x43')],_0x4786c6['value']['start'],_0x4786c6[_0x3c41('0x45')][_0x3c41('0x50')]);}break;case _0x3c41('0x51'):var _0x1700af=_0x136c69[_0x3c41('0x45')][_0x3c41('0x4c')](',')[_0x3c41('0x14')](function(_0x29e707){return Number(_0x29e707);});var _0x443aec=parseTagParameter(_0x1700af);_0x36d403[_0x3c41('0x52')][_0x3c41('0x53')]['and'](_0x443aec);_0x36d403[_0x3c41('0x52')][_0x3c41('0x54')]=_0x1700af;break;case _0x3c41('0x55'):if(_0x136c69[_0x3c41('0x4a')]===_0x3c41('0x4b')){_0x36d403[_0x3c41('0x56')][_0xf4ae6c](_0x3c41('0x57'),'%'+_0x136c69[_0x3c41('0x45')]+'%',null);}else{_0x128877=_[_0x3c41('0x3f')](_0x2db7b1,[_0x3c41('0xc'),_0x3c41('0x58')]);_0x136c69[_0x3c41('0xb')]='UserId';_0x4786c6=as[_0x3c41('0x40')](_0x48faaa,_0x128877[_0x3c41('0x41')],_0x136c69);_0x36d403[_0x3c41('0x56')][_0xf4ae6c](_0x4786c6[_0x3c41('0x43')],_0x4786c6['value'][_0x3c41('0x44')],_0x4786c6[_0x3c41('0x45')][_0x3c41('0x50')]);}break;case _0x3c41('0x59'):case _0x3c41('0x5a'):_0x4786c6=as[_0x3c41('0x40')]('me',null,_0x136c69);_0x36d403['body'][_0xf4ae6c](_0x4786c6[_0x3c41('0x43')],_0x4786c6[_0x3c41('0x45')][_0x3c41('0x44')],_0x4786c6[_0x3c41('0x45')][_0x3c41('0x50')]);break;}}}return _0x36d403;}function parseModelFields(_0x1d6aa,_0x3f8ac2,_0x2ab0ae){var _0x33c454=utils[_0x3c41('0x6')](_0x1d6aa);var _0x578699=squel[_0x3c41('0x25')]();var _0x304738=_(_0x3f8ac2)[_0x3c41('0x5b')]()['map'](function(_0x5d76ba){return _[_0x3c41('0x5c')](_0x2ab0ae,[_0x3c41('0xc'),_0x5d76ba])?_0x5d76ba:undefined;})[_0x3c41('0x5d')]()['value']();if(_0x304738[_0x3c41('0x3e')]>0x0){_0x304738[_0x3c41('0x26')](function(_0xe3e766){if(_0xe3e766===_0x33c454){_0x578699['and']('i.'+_0x33c454+_0x3c41('0x5e'),[]['concat'](_0x3f8ac2[_0xe3e766]));}else if(_0xe3e766===_0x3c41('0x5f')){var _0x4cdd03=JSON['parse'](_0x3f8ac2[_0xe3e766])[_0x3c41('0x60')];var _0x3d3751=JSON[_0x3c41('0x61')](_0x3f8ac2[_0xe3e766])[_0x3c41('0x62')];_0x578699['and'](_0x3c41('0x63'),_0x4cdd03,_0x3d3751);}else{if(_0x3f8ac2[_0xe3e766]===_0x3c41('0x64')){_0x578699[_0x3c41('0x48')]('i.'+_0xe3e766+'\x20IS\x20NULL');}else{_0x578699['and']('i.'+_0xe3e766+_0x3c41('0x65'),_0x3f8ac2[_0xe3e766]);}}});}return _0x578699;}function parseQueryParameters(_0x3d8daa,_0x526e62,_0x37b31b){var _0x3b60e1=getSqlClauses();return Promise[_0x3c41('0x66')]()[_0x3c41('0x67')](function(){return parseModelFields(_0x3d8daa,_0x526e62,_0x37b31b);})[_0x3c41('0x67')](function(_0x263308){_0x3b60e1[_0x3c41('0x68')][_0x3c41('0x48')](_0x263308);return parseReadParameter(_0x526e62[_0x3c41('0x47')]);})[_0x3c41('0x67')](function(_0x2efd80){_0x3b60e1[_0x3c41('0x47')][_0x3c41('0x48')](_0x2efd80);return parseTagParameter(_0x526e62['tag']);})[_0x3c41('0x67')](function(_0x3db7fa){_0x3b60e1[_0x3c41('0x52')][_0x3c41('0x53')][_0x3c41('0x48')](_0x3db7fa);return parseSearchFilter(_0x3d8daa,_0x526e62[_0x3c41('0x69')]);})[_0x3c41('0x67')](function(_0x3d4c88){_0x3b60e1[_0x3c41('0x69')]=_0x3d4c88;return _0x3b60e1;});}function checkAccountsRestrictions(_0x5a1868,_0x5dbd0c,_0x84b8d2){var _0x8a99a9=utils[_0x3c41('0x6')](_0x5a1868);var _0x5f1950=_0x3c41('0x6a')+_[_0x3c41('0x6b')](_0x5a1868)+(_0x5a1868===_0x3c41('0x6c')?'Websites':'Accounts');var _0x5ae12a=squel[_0x3c41('0x25')]();return Promise[_0x3c41('0x66')]()[_0x3c41('0x67')](function(){if(_0x84b8d2['search']&&_0x5dbd0c[_0x3c41('0x7')]===_0x3c41('0x8')){return _0x5dbd0c[_0x5f1950]({'attributes':['id'],'raw':!![]});}})[_0x3c41('0x67')](function(_0x37a2be){if(_0x37a2be){if(_0x37a2be[_0x3c41('0x3e')]===0x0){_0x5ae12a[_0x3c41('0x48')]('i.'+_0x8a99a9+_0x3c41('0x6d'));}else{_0x5ae12a['and']('i.'+_0x8a99a9+_0x3c41('0x5e'),_['map'](_0x37a2be,'id'));}}else if(!_0x84b8d2[_0x8a99a9]){_0x5ae12a['and']('i.'+_0x8a99a9+_0x3c41('0x6e'));}})['then'](function(){return _0x5ae12a;});}function getClosedOrderClause(_0x560134,_0x4a9ea1){var _0x55f4e3='';var _0x220a35=[_0x3c41('0x6f'),_0x3c41('0x70'),_0x3c41('0x71')];if(_0x560134===_0x3c41('0x34')){_0x220a35['unshift'](_0x3c41('0x72'));}if(_0x4a9ea1[_0x3c41('0x73')]==='0'&&_0x560134==='mail'){_0x55f4e3=_0x3c41('0x72');}else{if(_0x4a9ea1['closed']==='1'){_0x220a35['shift']();}_0x55f4e3=_0x3c41('0x74')+_0x220a35[_0x3c41('0x75')](',\x20')+')';}return _0x55f4e3;}function getFilteredInteractions(_0x5d2cf8,_0x464955,_0x31039a,_0x149010){var _0xbf05e2=utils[_0x3c41('0xf')](_0x5d2cf8);var _0x54ca5e=_[_0x3c41('0x6b')](_0x5d2cf8)+_0x3c41('0x76');var _0x23375d=[];var _0x4ca631=getTagsQuery();var _0x1fb305={'type':db['Sequelize'][_0x3c41('0x77')][_0x3c41('0x78')],'raw':!![]};var _0x192e27=[];var _0x3a4fcc=[];return db[_0x3c41('0x79')][_0x3c41('0x7a')](_0x4ca631[_0x3c41('0x7b')](),_0x1fb305)['then'](function(_0x31bafd){_0x23375d=_[_0x3c41('0x7c')](_0x31bafd,'id');_0x1fb305=_[_0x3c41('0x7d')](_0x1fb305,{'model':db[_0x54ca5e],'mapToModel':!![],'nest':!![]});if(_0x31039a[_0x3c41('0x68')]){_0x149010[_0x3c41('0x7e')][_0x3c41('0x26')](function(_0x27b6b4){_0x464955['field']('i.'+_0x27b6b4);});}else{_0x464955['field'](_0x3c41('0x7f'),'unreadMessages');_0x464955[_0x3c41('0xb')](_0x3c41('0x80'),_0x3c41('0x81'));_0x464955[_0x3c41('0xb')](_0x3c41('0x82'),_0x3c41('0x83'));if(_0x5d2cf8===_0x3c41('0x34')){_0x464955['field']('a.email','Account.email');_0x464955[_0x3c41('0xb')](_0x3c41('0x84'),_0x3c41('0x85'));_0x464955[_0x3c41('0xb')](_0x3c41('0x86'));_0x464955[_0x3c41('0xb')](_0x3c41('0x87'));_0x464955['field'](_0x3c41('0x88'));_0x464955[_0x3c41('0xb')]('i.closed');_0x464955[_0x3c41('0xb')](_0x3c41('0x89'));_0x464955[_0x3c41('0xb')](_0x3c41('0x8a'));_0x464955[_0x3c41('0xb')](_0x3c41('0x8b'));_0x464955[_0x3c41('0xb')](_0x3c41('0x8c'));_0x464955['field'](_0x3c41('0x8d'));_0x464955[_0x3c41('0xb')](_0x3c41('0x71'));_0x464955[_0x3c41('0xb')](_0x3c41('0x70'));_0x464955['field'](_0x3c41('0x6f'));_0x464955[_0x3c41('0xb')](_0x3c41('0x72'));_0x464955[_0x3c41('0xb')](_0x3c41('0x8e'));_0x464955[_0x3c41('0xb')](_0x3c41('0x8f'));_0x464955[_0x3c41('0xb')](_0x3c41('0x90'));_0x464955[_0x3c41('0xb')](_0x3c41('0x91'));}else if(_0x5d2cf8===_0x3c41('0x32')){_0x464955['field'](_0x3c41('0x92'),_0x3c41('0x85'));}else{_0x464955[_0x3c41('0xb')](_0x3c41('0x93'),'contactName');}if(_0x5d2cf8!==_0x3c41('0x34')){_0x464955[_0x3c41('0xb')]('i.*');}_0x464955['field'](_0x3c41('0x94'),_0x3c41('0x95'));_0x464955[_0x3c41('0xb')]('c.lastName',_0x3c41('0x96'));_0x464955[_0x3c41('0xb')](_0x3c41('0x97'),'Contact.email');_0x464955[_0x3c41('0xb')]('c.phone','Contact.phone');_0x464955[_0x3c41('0xb')]('c.mobile',_0x3c41('0x98'));_0x464955[_0x3c41('0xb')](_0x3c41('0x99'),_0x3c41('0x9a'));_0x464955[_0x3c41('0xb')]('o.fullname',_0x3c41('0x9b'));_0x464955['field'](_0x3c41('0x9c'),_0x3c41('0x9d'));_0x464955[_0x3c41('0xb')](_0x3c41('0x9e'),'TagIds');}if(_0x149010[_0x3c41('0x9f')]){_0x464955[_0x3c41('0x9f')](_0x149010[_0x3c41('0x9f')]);}if(_0x149010[_0x3c41('0xa0')]){_0x464955[_0x3c41('0xa0')](_0x149010[_0x3c41('0xa0')]);}return db[_0x3c41('0x79')]['query'](_0x464955[_0x3c41('0x7b')](),_0x1fb305);})[_0x3c41('0x67')](function(_0x353bdd){_0x192e27=_0x353bdd;var _0x32e68c=getUsersQuery(_0x5d2cf8,_0x192e27);return db[_0x3c41('0x79')][_0x3c41('0x7a')](_0x32e68c['toString'](),_0x1fb305);})[_0x3c41('0x67')](function(_0x2cd10c){_0x3a4fcc=_[_0x3c41('0xa1')](_0x2cd10c,_0xbf05e2);if(_0x5d2cf8===_0x3c41('0x34')){return db[_0x3c41('0xa2')][_0x3c41('0xa3')]({'attributes':[_0x3c41('0xa4')],'raw':!![]});}})[_0x3c41('0x67')](function(_0x403bd9){var _0x3cbed1=_0x403bd9?_0x403bd9[_0x3c41('0xa4')]:undefined;var _0x103ccd=_0x192e27['map'](function(_0x22c2bb){return updateInteraction(_0x22c2bb,_0x23375d,_0x3a4fcc,_0x3cbed1);});return Promise[_0x3c41('0xa5')](_0x103ccd);});}function countFilteredInteractions(_0xcf36c8,_0x29e459){var _0x3db578=_0xcf36c8[_0x3c41('0xa6')]();_0x3db578[_0x3c41('0xb')](_0x3c41('0xa7'));_0x3db578[_0x3c41('0xb')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');var _0x3fe5c3=utils['getSelectedTags'](_0x29e459);if(!_[_0x3c41('0xa8')](_0x3fe5c3)){_0x3db578[_0x3c41('0x13')](_0x3c41('0xa9'),_0x3fe5c3);}var _0x115601={'type':db[_0x3c41('0xaa')][_0x3c41('0x77')]['SELECT'],'raw':!![]};return db['sequelize'][_0x3c41('0x7a')](_0x3db578[_0x3c41('0x7b')](),_0x115601);}module[_0x3c41('0xab')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
git://repos.xcallymotion.com / motion2.git / blob