18 var _0x81de=['offset','sequelize','groupBy','Setting','enableEmailPreview','clone','isEmpty','where','t.id\x20IN\x20?','SELECT','query','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','./utils','../../mysqldb','getAccountFK','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','u.id','u.fullname','left_join','users','u.id\x20=\x20ui.UserId','length','ui.','\x20IN\x20?','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','interactionsTags','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}','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','sms','includes','i.fax\x20LIKE\x20?','openchannel','mail','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','fax','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','conditions','find','type','default','text','value','start','end','unreadMessages','read','and','Contact','operator','$substring','split','contact','ContactId','buildExpression','clause','tags','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','keys','map','compact','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','tag','get','capitalize','chat','Accounts','role','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.disposition','unshift','i.substatus','closed','shift','join','Interaction','Sequelize','QueryTypes','toString','keyBy','merge','fields','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','Account.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','contactName','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.subject','i.secondDisposition','i.to','i.MailAccountId','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.*','Contact.firstName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit'];(function(_0x55f8b4,_0x43f30d){var _0x2475f9=function(_0xdd6f4a){while(--_0xdd6f4a){_0x55f8b4['push'](_0x55f8b4['shift']());}};_0x2475f9(++_0x43f30d);}(_0x81de,0x15e));var _0xe81d=function(_0x23cdb9,_0x547936){_0x23cdb9=_0x23cdb9-0x0;var _0x1ea3c1=_0x81de[_0x23cdb9];return _0x1ea3c1;};'use strict';var _=require(_0xe81d('0x0'));var squel=require(_0xe81d('0x1'));var as=require(_0xe81d('0x2'));var qs=require(_0xe81d('0x3'));var updateInteraction=require(_0xe81d('0x4'))['updateInteraction'];var utils=require(_0xe81d('0x5'));var db=require(_0xe81d('0x6'))['db'];function skipInteractionsQuery(_0x3e460f,_0x1f1df2,_0x4105c7){var _0x33962f=![];var _0x54f119=utils[_0xe81d('0x7')](_0x3e460f);if(_0x1f1df2['role']==='agent'&&!_0x4105c7[_0xe81d('0x8')]&&!_0x4105c7[_0x54f119]){_0x33962f=!![];}return _0x33962f;}function getTagsQuery(){return squel[_0xe81d('0x9')]()[_0xe81d('0xa')]('id')[_0xe81d('0xa')](_0xe81d('0xb'))[_0xe81d('0xa')](_0xe81d('0xc'))[_0xe81d('0xd')](_0xe81d('0xe'));}function getUsersQuery(_0x4392e9,_0x41183e){var _0x353dc3=utils[_0xe81d('0xf')](_0x4392e9);var _0x59501a=_0xe81d('0x10')+_0x4392e9+'_interactions';var _0x415b8c=squel[_0xe81d('0x9')]()[_0xe81d('0xa')](_0xe81d('0x11'))[_0xe81d('0xa')](_0xe81d('0x12'))[_0xe81d('0xa')]('ui.'+_0x353dc3)[_0xe81d('0xd')](_0x59501a,'ui')[_0xe81d('0x13')](_0xe81d('0x14'),'u',_0xe81d('0x15'));if(_0x41183e[_0xe81d('0x16')]>0x0){_0x415b8c['where'](_0xe81d('0x17')+_0x353dc3+_0xe81d('0x18'),_['map'](_0x41183e,'id'));}return _0x415b8c;}function getInteractionsQuery(_0x304f03){var _0x5eb5de=utils[_0xe81d('0x19')](_0x304f03);var _0x2d8993=utils[_0xe81d('0x7')](_0x304f03);var _0x1c240d=utils[_0xe81d('0xf')](_0x304f03);return squel['select']()['from'](_0x5eb5de[_0xe81d('0x1a')],'i')[_0xe81d('0x13')](_0xe81d('0x1b'),'c',_0xe81d('0x1c'))[_0xe81d('0x13')](_0xe81d('0x14'),'o',_0xe81d('0x1d'))['left_join'](_0x5eb5de[_0xe81d('0x1e')],'a',_0xe81d('0x1f')+_0x2d8993)[_0xe81d('0x13')](_0x5eb5de['messages'],'me',_0xe81d('0x20')+_0x1c240d+_0xe81d('0x21'))[_0xe81d('0x13')](_0x5eb5de[_0xe81d('0x22')],'it',_0xe81d('0x23')+_0x1c240d+_0xe81d('0x21'))['left_join'](_0xe81d('0xe'),'t',_0xe81d('0x24'));}function getSqlClauses(){var _0x113d09={'body':squel[_0xe81d('0x25')](),'contact':squel['expr'](),'default':squel[_0xe81d('0x25')](),'fields':squel[_0xe81d('0x25')](),'filter':squel['expr'](),'read':squel[_0xe81d('0x25')](),'tags':{'clause':squel[_0xe81d('0x25')](),'ids':null},'user':squel['expr']()};return _0x113d09;}function parseTagParameter(_0x22f9c4){var _0x4b2702=squel[_0xe81d('0x25')]();if(_0x22f9c4){var _0x34f386=utils[_0xe81d('0x26')](_0x22f9c4);_0x34f386[_0xe81d('0x27')](function(_0x162ee9){_0x4b2702['or'](_0xe81d('0x28'),'%,'+_0x162ee9+',%');});}return _0x4b2702;}function parseReadParameter(_0x5a2ece){var _0x2b8c51='';if(_0x5a2ece){_0x2b8c51=_0xe81d('0x29');if(_0x5a2ece==='1'){_0x2b8c51=_0x2b8c51[_0xe81d('0x2a')](_0xe81d('0x2b'),'=');}else{_0x2b8c51=_0x2b8c51['replace'](_0xe81d('0x2b'),'>');}}return _0x2b8c51;}function parseSearchFilter(_0x373eee,_0x1935b6){var _0x1d86ec=squel[_0xe81d('0x25')]();if(_0x1935b6){var _0x33b61b=_0x1935b6[_0xe81d('0x2a')]('\x5c','\x5c\x5c')[_0xe81d('0x2a')](/'/g,'\x27\x27');var _0x2112b4=qs[_0xe81d('0x2c')](_0x33b61b);if(qs[_0xe81d('0x2d')](_0x33b61b)){_0x1d86ec['or'](_0xe81d('0x2e'),_0x2112b4+'%');if([_0xe81d('0x2f'),'whatsapp'][_0xe81d('0x30')](_0x373eee)){_0x1d86ec['or']('i.phone\x20LIKE\x20?',_0x2112b4+'%');}else if(_0x373eee==='fax'){_0x1d86ec['or'](_0xe81d('0x31'),_0x2112b4+'%');}else if(_0x373eee===_0xe81d('0x32')){_0x1d86ec['or']('i.from\x20LIKE\x20?',_0x2112b4+'%');}}else if(_0x373eee===_0xe81d('0x33')&&qs[_0xe81d('0x34')](_0x33b61b)){_0x1d86ec['or'](_0xe81d('0x35'),_0x2112b4+'%');}else{if(_0x373eee===_0xe81d('0x33')){_0x1d86ec['or'](_0xe81d('0x36'),qs[_0xe81d('0x37')](_0x33b61b,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xe81d('0x37')](_0x33b61b));}else if(_0x373eee!==_0xe81d('0x38')){_0x1d86ec['or']('MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xe81d('0x37')](_0x33b61b));}_0x1d86ec['or'](_0xe81d('0x39'),qs[_0xe81d('0x37')](_0x33b61b,!![]),null);}}return _0x1d86ec;}function parseAdvancedSearchFilter(_0x3e4854,_0x47d335){var _0x1ab5f1=getSqlClauses();var _0x1802da=as[_0xe81d('0x3a')](_0x3e4854);var _0x3990ef=_0x1802da['sqlOperator'];for(var _0x2ee05d=0x0;_0x2ee05d<_0x1802da[_0xe81d('0x3b')][_0xe81d('0x16')];_0x2ee05d++){var _0x1d7323=_0x1802da[_0xe81d('0x3b')][_0x2ee05d];var _0x18abad='i';var _0x46e45f=_[_0xe81d('0x3c')](_0x47d335,['name',_0x1d7323[_0xe81d('0xa')]]);if(_0x46e45f){var _0x2f45ca=as['buildExpression'](_0x18abad,_0x46e45f[_0xe81d('0x3d')],_0x1d7323);_0x1ab5f1[_0xe81d('0x3e')][_0x3990ef](_0x2f45ca[_0xe81d('0x3f')],_0x2f45ca[_0xe81d('0x40')][_0xe81d('0x41')],_0x2f45ca[_0xe81d('0x40')][_0xe81d('0x42')]);}else{switch(_0x1d7323[_0xe81d('0xa')]){case _0xe81d('0x43'):var _0x563906=parseReadParameter(_0x1d7323['value']);_0x1ab5f1[_0xe81d('0x44')][_0xe81d('0x45')](_0x563906);break;case _0xe81d('0x46'):if(_0x1d7323[_0xe81d('0x47')]===_0xe81d('0x48')){if(_0x1d7323[_0xe81d('0x40')][_0xe81d('0x49')]('\x20')['length']>0x1){_0x1ab5f1[_0xe81d('0x4a')][_0x3990ef]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xe81d('0x37')](_0x1d7323['value'],!![]),null);}else{var _0xbe4f44='%'+_0x1d7323[_0xe81d('0x40')]+'%';_0x1ab5f1[_0xe81d('0x4a')][_0x3990ef]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0xbe4f44,_0xbe4f44,_0xbe4f44);}}else{_0x46e45f=_[_0xe81d('0x3c')](_0x47d335,[_0xe81d('0xb'),_0xe81d('0x4b')]);_0x1d7323[_0xe81d('0xa')]=_0xe81d('0x4b');_0x2f45ca=as[_0xe81d('0x4c')](_0x18abad,_0x46e45f['type'],_0x1d7323);_0x1ab5f1[_0xe81d('0x4a')][_0x3990ef](_0x2f45ca[_0xe81d('0x3f')],_0x2f45ca[_0xe81d('0x40')][_0xe81d('0x41')],_0x2f45ca[_0xe81d('0x40')][_0xe81d('0x42')]);}break;case'Tag':var _0x13e67d=_0x1d7323['value'][_0xe81d('0x49')](',')['map'](function(_0x568c7a){return Number(_0x568c7a);});var _0x375b69=parseTagParameter(_0x13e67d);_0x1ab5f1['tags'][_0xe81d('0x4d')][_0xe81d('0x45')](_0x375b69);_0x1ab5f1[_0xe81d('0x4e')][_0xe81d('0x4f')]=_0x13e67d;break;case _0xe81d('0x50'):if(_0x1d7323[_0xe81d('0x47')]==='$substring'){_0x1ab5f1[_0xe81d('0x51')][_0x3990ef](_0xe81d('0x52'),'%'+_0x1d7323[_0xe81d('0x40')]+'%',null);}else{_0x46e45f=_[_0xe81d('0x3c')](_0x47d335,[_0xe81d('0xb'),_0xe81d('0x53')]);_0x1d7323[_0xe81d('0xa')]=_0xe81d('0x53');_0x2f45ca=as['buildExpression'](_0x18abad,_0x46e45f[_0xe81d('0x3d')],_0x1d7323);_0x1ab5f1[_0xe81d('0x51')][_0x3990ef](_0x2f45ca['text'],_0x2f45ca[_0xe81d('0x40')]['start'],_0x2f45ca['value'][_0xe81d('0x42')]);}break;case _0xe81d('0x54'):case _0xe81d('0x55'):_0x2f45ca=as[_0xe81d('0x4c')]('me',null,_0x1d7323);_0x1ab5f1[_0xe81d('0x54')][_0x3990ef](_0x2f45ca['text'],_0x2f45ca[_0xe81d('0x40')][_0xe81d('0x41')],_0x2f45ca[_0xe81d('0x40')][_0xe81d('0x42')]);break;}}}return _0x1ab5f1;}function parseModelFields(_0x21c015,_0x219bc1,_0x4aeb49){var _0x3ce4a9=utils[_0xe81d('0x7')](_0x21c015);var _0x4e8288=squel['expr']();var _0x37dd14=_(_0x219bc1)[_0xe81d('0x56')]()[_0xe81d('0x57')](function(_0x2c7552){return _['some'](_0x4aeb49,[_0xe81d('0xb'),_0x2c7552])?_0x2c7552:undefined;})[_0xe81d('0x58')]()['value']();if(_0x37dd14['length']>0x0){_0x37dd14[_0xe81d('0x27')](function(_0x3616b8){if(_0x3616b8===_0x3ce4a9){_0x4e8288[_0xe81d('0x45')]('i.'+_0x3ce4a9+_0xe81d('0x18'),[]['concat'](_0x219bc1[_0x3616b8]));}else if(_0x3616b8===_0xe81d('0x59')){var _0x139370=JSON['parse'](_0x219bc1[_0x3616b8])['$gte'];var _0x14d204=JSON[_0xe81d('0x5a')](_0x219bc1[_0x3616b8])[_0xe81d('0x5b')];_0x4e8288[_0xe81d('0x45')](_0xe81d('0x5c'),_0x139370,_0x14d204);}else{if(_0x219bc1[_0x3616b8]===_0xe81d('0x5d')){_0x4e8288[_0xe81d('0x45')]('i.'+_0x3616b8+_0xe81d('0x5e'));}else{_0x4e8288['and']('i.'+_0x3616b8+_0xe81d('0x5f'),_0x219bc1[_0x3616b8]);}}});}return _0x4e8288;}function parseQueryParameters(_0x5bb6da,_0x4c3afd,_0x279f24){var _0x21d95a=getSqlClauses();return Promise[_0xe81d('0x60')]()[_0xe81d('0x61')](function(){return parseModelFields(_0x5bb6da,_0x4c3afd,_0x279f24);})[_0xe81d('0x61')](function(_0x2d92b0){_0x21d95a['fields'][_0xe81d('0x45')](_0x2d92b0);return parseReadParameter(_0x4c3afd[_0xe81d('0x44')]);})[_0xe81d('0x61')](function(_0x1e98f2){_0x21d95a[_0xe81d('0x44')]['and'](_0x1e98f2);return parseTagParameter(_0x4c3afd[_0xe81d('0x62')]);})[_0xe81d('0x61')](function(_0x3b9969){_0x21d95a[_0xe81d('0x4e')]['clause'][_0xe81d('0x45')](_0x3b9969);return parseSearchFilter(_0x5bb6da,_0x4c3afd['filter']);})[_0xe81d('0x61')](function(_0x43ec32){_0x21d95a['filter']=_0x43ec32;return _0x21d95a;});}function checkAccountsRestrictions(_0xb03aca,_0x1b483d,_0x404f5f){var _0x330a20=utils[_0xe81d('0x7')](_0xb03aca);var _0x1b9ddb=_0xe81d('0x63')+_[_0xe81d('0x64')](_0xb03aca)+(_0xb03aca===_0xe81d('0x65')?'Websites':_0xe81d('0x66'));var _0x417fff=squel[_0xe81d('0x25')]();return Promise[_0xe81d('0x60')]()[_0xe81d('0x61')](function(){if(_0x404f5f[_0xe81d('0x8')]&&_0x1b483d[_0xe81d('0x67')]===_0xe81d('0x68')){return _0x1b483d[_0x1b9ddb]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x340bc7){if(_0x340bc7){if(_0x340bc7[_0xe81d('0x16')]===0x0){_0x417fff[_0xe81d('0x45')]('i.'+_0x330a20+_0xe81d('0x5e'));}else{_0x417fff[_0xe81d('0x45')]('i.'+_0x330a20+'\x20IN\x20?',_[_0xe81d('0x57')](_0x340bc7,'id'));}}else if(!_0x404f5f[_0x330a20]){_0x417fff[_0xe81d('0x45')]('i.'+_0x330a20+_0xe81d('0x69'));}})['then'](function(){return _0x417fff;});}function getClosedOrderClause(_0x3aa764,_0x445a9a){var _0x301ad0='';var _0x9eab39=[_0xe81d('0x6a'),'i.secondDisposition',_0xe81d('0x6b')];if(_0x3aa764===_0xe81d('0x33')){_0x9eab39[_0xe81d('0x6c')](_0xe81d('0x6d'));}if(_0x445a9a[_0xe81d('0x6e')]==='0'&&_0x3aa764===_0xe81d('0x33')){_0x301ad0='i.substatus';}else{if(_0x445a9a['closed']==='1'){_0x9eab39[_0xe81d('0x6f')]();}_0x301ad0='CONCAT_WS(\x27\x27,\x20'+_0x9eab39[_0xe81d('0x70')](',\x20')+')';}return _0x301ad0;}function getFilteredInteractions(_0x5eea72,_0x5d7ad9,_0x12ee1d,_0x5bb64c){var _0x56fa3d=utils['getInteractionFK'](_0x5eea72);var _0x2ce092=_[_0xe81d('0x64')](_0x5eea72)+_0xe81d('0x71');var _0x5023bc=[];var _0x45e893=getTagsQuery();var _0x3422b9={'type':db[_0xe81d('0x72')][_0xe81d('0x73')]['SELECT'],'raw':!![]};var _0x30971f=[];var _0x11c6f2=[];return db['sequelize']['query'](_0x45e893[_0xe81d('0x74')](),_0x3422b9)[_0xe81d('0x61')](function(_0x4e07e1){_0x5023bc=_[_0xe81d('0x75')](_0x4e07e1,'id');_0x3422b9=_[_0xe81d('0x76')](_0x3422b9,{'model':db[_0x2ce092],'mapToModel':!![],'nest':!![]});if(_0x12ee1d[_0xe81d('0x77')]){_0x5bb64c[_0xe81d('0x78')][_0xe81d('0x27')](function(_0x5e3d89){_0x5d7ad9['field']('i.'+_0x5e3d89);});}else{_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x79'),_0xe81d('0x43'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x7a'),_0xe81d('0x7b'));_0x5d7ad9['field'](_0xe81d('0x7c'),_0xe81d('0x7d'));if(_0x5eea72===_0xe81d('0x33')){_0x5d7ad9['field']('a.email',_0xe81d('0x7e'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x7f'),_0xe81d('0x80'));_0x5d7ad9['field'](_0xe81d('0x81'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x82'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x83'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x84'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x85'));_0x5d7ad9[_0xe81d('0xa')]('i.attach');_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x86'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x87'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x88'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x6b'));_0x5d7ad9['field'](_0xe81d('0x89'));_0x5d7ad9['field']('i.thirdDisposition');_0x5d7ad9[_0xe81d('0xa')]('i.substatus');_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x8a'));_0x5d7ad9[_0xe81d('0xa')]('i.ContactId');_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x8b'));_0x5d7ad9[_0xe81d('0xa')]('i.UserId');}else if(_0x5eea72===_0xe81d('0x32')){_0x5d7ad9[_0xe81d('0xa')]('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',_0xe81d('0x80'));}else{_0x5d7ad9['field'](_0xe81d('0x8c'),_0xe81d('0x80'));}if(_0x5eea72!=='mail'){_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x8d'));}_0x5d7ad9[_0xe81d('0xa')]('c.firstName',_0xe81d('0x8e'));_0x5d7ad9[_0xe81d('0xa')]('c.lastName',_0xe81d('0x8f'));_0x5d7ad9['field'](_0xe81d('0x90'),_0xe81d('0x91'));_0x5d7ad9['field'](_0xe81d('0x92'),_0xe81d('0x93'));_0x5d7ad9['field']('c.mobile',_0xe81d('0x94'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x95'),_0xe81d('0x96'));_0x5d7ad9['field'](_0xe81d('0x97'),'Owner.fullname');_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x98'),_0xe81d('0x99'));_0x5d7ad9[_0xe81d('0xa')](_0xe81d('0x9a'),_0xe81d('0x9b'));}if(_0x5bb64c[_0xe81d('0x9c')]){_0x5d7ad9[_0xe81d('0x9c')](_0x5bb64c[_0xe81d('0x9c')]);}if(_0x5bb64c[_0xe81d('0x9d')]){_0x5d7ad9[_0xe81d('0x9d')](_0x5bb64c[_0xe81d('0x9d')]);}return db[_0xe81d('0x9e')]['query'](_0x5d7ad9[_0xe81d('0x74')](),_0x3422b9);})[_0xe81d('0x61')](function(_0x55bbb6){_0x30971f=_0x55bbb6;var _0x3eed5c=getUsersQuery(_0x5eea72,_0x30971f);return db[_0xe81d('0x9e')]['query'](_0x3eed5c[_0xe81d('0x74')](),_0x3422b9);})[_0xe81d('0x61')](function(_0x391692){_0x11c6f2=_[_0xe81d('0x9f')](_0x391692,_0x56fa3d);if(_0x5eea72===_0xe81d('0x33')){return db[_0xe81d('0xa0')]['findOne']({'attributes':[_0xe81d('0xa1')],'raw':!![]});}})['then'](function(_0x531108){var _0x4a2fb8=_0x531108?_0x531108[_0xe81d('0xa1')]:undefined;var _0x2265ba=_0x30971f[_0xe81d('0x57')](function(_0x525a6a){return updateInteraction(_0x525a6a,_0x5023bc,_0x11c6f2,_0x4a2fb8);});return Promise['all'](_0x2265ba);});}function countFilteredInteractions(_0x3b2ed5,_0x280e7a){var _0x3533c8=_0x3b2ed5[_0xe81d('0xa2')]();_0x3533c8[_0xe81d('0xa')]('COUNT(*)');_0x3533c8[_0xe81d('0xa')](_0xe81d('0x79'),'unreadMessages');var _0x31e75a=utils[_0xe81d('0x26')](_0x280e7a);if(!_[_0xe81d('0xa3')](_0x31e75a)){_0x3533c8[_0xe81d('0xa4')](_0xe81d('0xa5'),_0x31e75a);}var _0x13e79d={'type':db[_0xe81d('0x72')]['QueryTypes'][_0xe81d('0xa6')],'raw':!![]};return db['sequelize'][_0xe81d('0xa7')](_0x3533c8[_0xe81d('0x74')](),_0x13e79d);}module[_0xe81d('0xa8')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
git://repos.xcallymotion.com / motion2.git / blob