// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf511=['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)','parseSearch','sqlOperator','length','buildExpression','type','default','text','value','start','end','unreadMessages','and','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','find','ContactId','Tag','clause','tags','ids','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','keys','some','compact','concat','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','read','filter','get','capitalize','chat','Accounts','agent','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','fields','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','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','i.updatedAt','i.closed','i.closedAt','i.attach','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','contactName','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','Contact.email','c.phone','Contact.phone','Contact.mobile','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','t.id\x20IN\x20?','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','./utils','../../mysqldb','getAccountFK','role','search','field','name','color','from','tools_tags','getInteractionFK','select','ui.','left_join','users','where','\x20IN\x20?','map','getInteractionsTables','interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','\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','whatsapp','includes','i.phone\x20LIKE\x20?','fax','openchannel','i.from\x20LIKE\x20?','c.email\x20LIKE\x20?','mail'];(function(_0x20a584,_0xe384a5){var _0x4b41a8=function(_0x2127c6){while(--_0x2127c6){_0x20a584['push'](_0x20a584['shift']());}};_0x4b41a8(++_0xe384a5);}(_0xf511,0x1bd));var _0x1f51=function(_0x4cefc3,_0x23f291){_0x4cefc3=_0x4cefc3-0x0;var _0x1cc779=_0xf511[_0x4cefc3];return _0x1cc779;};'use strict';var _=require(_0x1f51('0x0'));var squel=require(_0x1f51('0x1'));var as=require(_0x1f51('0x2'));var qs=require(_0x1f51('0x3'));var updateInteraction=require(_0x1f51('0x4'))['updateInteraction'];var utils=require(_0x1f51('0x5'));var db=require(_0x1f51('0x6'))['db'];function skipInteractionsQuery(_0x3cc0a3,_0x313c8e,_0x2f29c5){var _0x3b7e0b=![];var _0x187795=utils[_0x1f51('0x7')](_0x3cc0a3);if(_0x313c8e[_0x1f51('0x8')]==='agent'&&!_0x2f29c5[_0x1f51('0x9')]&&!_0x2f29c5[_0x187795]){_0x3b7e0b=!![];}return _0x3b7e0b;}function getTagsQuery(){return squel['select']()[_0x1f51('0xa')]('id')['field'](_0x1f51('0xb'))[_0x1f51('0xa')](_0x1f51('0xc'))[_0x1f51('0xd')](_0x1f51('0xe'));}function getUsersQuery(_0x3dc930,_0x4e7894){var _0x12bb68=utils[_0x1f51('0xf')](_0x3dc930);var _0x10d927='user_has_'+_0x3dc930+'_interactions';var _0x4d8e5f=squel[_0x1f51('0x10')]()['field']('u.id')[_0x1f51('0xa')]('u.fullname')[_0x1f51('0xa')](_0x1f51('0x11')+_0x12bb68)[_0x1f51('0xd')](_0x10d927,'ui')[_0x1f51('0x12')](_0x1f51('0x13'),'u','u.id\x20=\x20ui.UserId');if(_0x4e7894['length']>0x0){_0x4d8e5f[_0x1f51('0x14')]('ui.'+_0x12bb68+_0x1f51('0x15'),_[_0x1f51('0x16')](_0x4e7894,'id'));}return _0x4d8e5f;}function getInteractionsQuery(_0x1eb728){var _0x225166=utils[_0x1f51('0x17')](_0x1eb728);var _0x5ae83e=utils['getAccountFK'](_0x1eb728);var _0x566b8c=utils[_0x1f51('0xf')](_0x1eb728);return squel[_0x1f51('0x10')]()[_0x1f51('0xd')](_0x225166[_0x1f51('0x18')],'i')[_0x1f51('0x12')]('cm_contacts','c',_0x1f51('0x19'))[_0x1f51('0x12')](_0x1f51('0x13'),'o',_0x1f51('0x1a'))[_0x1f51('0x12')](_0x225166[_0x1f51('0x1b')],'a',_0x1f51('0x1c')+_0x5ae83e)[_0x1f51('0x12')](_0x225166[_0x1f51('0x1d')],'me','me.'+_0x566b8c+_0x1f51('0x1e'))['left_join'](_0x225166[_0x1f51('0x1f')],'it',_0x1f51('0x20')+_0x566b8c+_0x1f51('0x1e'))[_0x1f51('0x12')](_0x1f51('0xe'),'t',_0x1f51('0x21'));}function getSqlClauses(){var _0x16da07={'body':squel[_0x1f51('0x22')](),'contact':squel[_0x1f51('0x22')](),'default':squel[_0x1f51('0x22')](),'fields':squel['expr'](),'filter':squel[_0x1f51('0x22')](),'read':squel['expr'](),'tags':{'clause':squel[_0x1f51('0x22')](),'ids':null},'user':squel[_0x1f51('0x22')]()};return _0x16da07;}function parseTagParameter(_0x5aebb){var _0x1b73a3=squel[_0x1f51('0x22')]();if(_0x5aebb){var _0x5a9a45=utils[_0x1f51('0x23')](_0x5aebb);_0x5a9a45[_0x1f51('0x24')](function(_0x456a53){_0x1b73a3['or'](_0x1f51('0x25'),'%,'+_0x456a53+',%');});}return _0x1b73a3;}function parseReadParameter(_0x5f25a0){var _0x8a5583='';if(_0x5f25a0){_0x8a5583=_0x1f51('0x26');if(_0x5f25a0==='1'){_0x8a5583=_0x8a5583[_0x1f51('0x27')](_0x1f51('0x28'),'=');}else{_0x8a5583=_0x8a5583[_0x1f51('0x27')](_0x1f51('0x28'),'>');}}return _0x8a5583;}function parseSearchFilter(_0x3e6211,_0x8f4e9f){var _0x2d5a8a=squel[_0x1f51('0x22')]();if(_0x8f4e9f){var _0x5da69a=_0x8f4e9f[_0x1f51('0x27')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');var _0x4e9a5e=qs[_0x1f51('0x29')](_0x5da69a);if(qs[_0x1f51('0x2a')](_0x5da69a)){_0x2d5a8a['or'](_0x1f51('0x2b'),_0x4e9a5e+'%');if([_0x1f51('0x2c'),_0x1f51('0x2d')][_0x1f51('0x2e')](_0x3e6211)){_0x2d5a8a['or'](_0x1f51('0x2f'),_0x4e9a5e+'%');}else if(_0x3e6211===_0x1f51('0x30')){_0x2d5a8a['or']('i.fax\x20LIKE\x20?',_0x4e9a5e+'%');}else if(_0x3e6211===_0x1f51('0x31')){_0x2d5a8a['or'](_0x1f51('0x32'),_0x4e9a5e+'%');}}else if(_0x3e6211==='mail'&&qs['isEmail'](_0x5da69a)){_0x2d5a8a['or'](_0x1f51('0x33'),_0x4e9a5e+'%');}else{if(_0x3e6211===_0x1f51('0x34')){_0x2d5a8a['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x1f51('0x35')](_0x5da69a,!![]))['or'](_0x1f51('0x36'),qs[_0x1f51('0x35')](_0x5da69a));}else if(_0x3e6211!==_0x1f51('0x30')){_0x2d5a8a['or'](_0x1f51('0x37'),qs[_0x1f51('0x35')](_0x5da69a));}_0x2d5a8a['or'](_0x1f51('0x38'),qs[_0x1f51('0x35')](_0x5da69a,!![]),null);}}return _0x2d5a8a;}function parseAdvancedSearchFilter(_0x34d9b4,_0x246548){var _0x249bcc=getSqlClauses();var _0x57f7f7=as[_0x1f51('0x39')](_0x34d9b4);var _0x439f6b=_0x57f7f7[_0x1f51('0x3a')];for(var _0xbf0610=0x0;_0xbf0610<_0x57f7f7['conditions'][_0x1f51('0x3b')];_0xbf0610++){var _0x11cc28=_0x57f7f7['conditions'][_0xbf0610];var _0x5f33bc='i';var _0x458e37=_['find'](_0x246548,[_0x1f51('0xb'),_0x11cc28[_0x1f51('0xa')]]);if(_0x458e37){var _0x92de2=as[_0x1f51('0x3c')](_0x5f33bc,_0x458e37[_0x1f51('0x3d')],_0x11cc28);_0x249bcc[_0x1f51('0x3e')][_0x439f6b](_0x92de2[_0x1f51('0x3f')],_0x92de2[_0x1f51('0x40')][_0x1f51('0x41')],_0x92de2[_0x1f51('0x40')][_0x1f51('0x42')]);}else{switch(_0x11cc28[_0x1f51('0xa')]){case _0x1f51('0x43'):var _0x401a2c=parseReadParameter(_0x11cc28[_0x1f51('0x40')]);_0x249bcc['read'][_0x1f51('0x44')](_0x401a2c);break;case'Contact':if(_0x11cc28[_0x1f51('0x45')]===_0x1f51('0x46')){if(_0x11cc28[_0x1f51('0x40')][_0x1f51('0x47')]('\x20')['length']>0x1){_0x249bcc[_0x1f51('0x48')][_0x439f6b](_0x1f51('0x38'),qs['getFullTextValue'](_0x11cc28['value'],!![]),null);}else{var _0x13a60f='%'+_0x11cc28[_0x1f51('0x40')]+'%';_0x249bcc['contact'][_0x439f6b](_0x1f51('0x49'),_0x13a60f,_0x13a60f,_0x13a60f);}}else{_0x458e37=_[_0x1f51('0x4a')](_0x246548,[_0x1f51('0xb'),_0x1f51('0x4b')]);_0x11cc28[_0x1f51('0xa')]='ContactId';_0x92de2=as[_0x1f51('0x3c')](_0x5f33bc,_0x458e37[_0x1f51('0x3d')],_0x11cc28);_0x249bcc[_0x1f51('0x48')][_0x439f6b](_0x92de2[_0x1f51('0x3f')],_0x92de2['value'][_0x1f51('0x41')],_0x92de2[_0x1f51('0x40')]['end']);}break;case _0x1f51('0x4c'):var _0x45b749=_0x11cc28['value'][_0x1f51('0x47')](',')[_0x1f51('0x16')](function(_0x264bc8){return Number(_0x264bc8);});var _0x57d968=parseTagParameter(_0x45b749);_0x249bcc['tags'][_0x1f51('0x4d')][_0x1f51('0x44')](_0x57d968);_0x249bcc[_0x1f51('0x4e')][_0x1f51('0x4f')]=_0x45b749;break;case _0x1f51('0x50'):if(_0x11cc28[_0x1f51('0x45')]===_0x1f51('0x46')){_0x249bcc['user'][_0x439f6b](_0x1f51('0x51'),'%'+_0x11cc28[_0x1f51('0x40')]+'%',null);}else{_0x458e37=_[_0x1f51('0x4a')](_0x246548,[_0x1f51('0xb'),_0x1f51('0x52')]);_0x11cc28[_0x1f51('0xa')]='UserId';_0x92de2=as[_0x1f51('0x3c')](_0x5f33bc,_0x458e37[_0x1f51('0x3d')],_0x11cc28);_0x249bcc['user'][_0x439f6b](_0x92de2['text'],_0x92de2[_0x1f51('0x40')]['start'],_0x92de2['value']['end']);}break;case _0x1f51('0x53'):case _0x1f51('0x54'):_0x92de2=as['buildExpression']('me',null,_0x11cc28);_0x249bcc['body'][_0x439f6b](_0x92de2[_0x1f51('0x3f')],_0x92de2['value'][_0x1f51('0x41')],_0x92de2[_0x1f51('0x40')][_0x1f51('0x42')]);break;}}}return _0x249bcc;}function parseModelFields(_0x2e2c5e,_0x11751b,_0xc49801){var _0x141083=utils['getAccountFK'](_0x2e2c5e);var _0x2162f3=squel[_0x1f51('0x22')]();var _0x352844=_(_0x11751b)[_0x1f51('0x55')]()[_0x1f51('0x16')](function(_0x1aeb3e){return _[_0x1f51('0x56')](_0xc49801,[_0x1f51('0xb'),_0x1aeb3e])?_0x1aeb3e:undefined;})[_0x1f51('0x57')]()['value']();if(_0x352844[_0x1f51('0x3b')]>0x0){_0x352844['forEach'](function(_0x77c7a4){if(_0x77c7a4===_0x141083){_0x2162f3[_0x1f51('0x44')]('i.'+_0x141083+_0x1f51('0x15'),[][_0x1f51('0x58')](_0x11751b[_0x77c7a4]));}else if(_0x77c7a4==='createdAt'){var _0x4a81ee=JSON['parse'](_0x11751b[_0x77c7a4])['$gte'];var _0x15e126=JSON[_0x1f51('0x59')](_0x11751b[_0x77c7a4])[_0x1f51('0x5a')];_0x2162f3['and'](_0x1f51('0x5b'),_0x4a81ee,_0x15e126);}else{if(_0x11751b[_0x77c7a4]===_0x1f51('0x5c')){_0x2162f3[_0x1f51('0x44')]('i.'+_0x77c7a4+_0x1f51('0x5d'));}else{_0x2162f3[_0x1f51('0x44')]('i.'+_0x77c7a4+_0x1f51('0x5e'),_0x11751b[_0x77c7a4]);}}});}return _0x2162f3;}function parseQueryParameters(_0x268cd0,_0x2ec6cc,_0x35a09a){var _0x1220d1=getSqlClauses();return Promise[_0x1f51('0x5f')]()['then'](function(){return parseModelFields(_0x268cd0,_0x2ec6cc,_0x35a09a);})[_0x1f51('0x60')](function(_0x256afd){_0x1220d1['fields']['and'](_0x256afd);return parseReadParameter(_0x2ec6cc['read']);})['then'](function(_0x318fc7){_0x1220d1[_0x1f51('0x61')][_0x1f51('0x44')](_0x318fc7);return parseTagParameter(_0x2ec6cc['tag']);})[_0x1f51('0x60')](function(_0x52f7be){_0x1220d1[_0x1f51('0x4e')][_0x1f51('0x4d')][_0x1f51('0x44')](_0x52f7be);return parseSearchFilter(_0x268cd0,_0x2ec6cc[_0x1f51('0x62')]);})[_0x1f51('0x60')](function(_0x54654d){_0x1220d1[_0x1f51('0x62')]=_0x54654d;return _0x1220d1;});}function checkAccountsRestrictions(_0x2c8c31,_0x298b70,_0x37eec5){var _0x24b8ad=utils[_0x1f51('0x7')](_0x2c8c31);var _0x19b1c0=_0x1f51('0x63')+_[_0x1f51('0x64')](_0x2c8c31)+(_0x2c8c31===_0x1f51('0x65')?'Websites':_0x1f51('0x66'));var _0x48b081=squel[_0x1f51('0x22')]();return Promise[_0x1f51('0x5f')]()[_0x1f51('0x60')](function(){if(_0x37eec5[_0x1f51('0x9')]&&_0x298b70['role']===_0x1f51('0x67')){return _0x298b70[_0x19b1c0]({'attributes':['id'],'raw':!![]});}})[_0x1f51('0x60')](function(_0xc46201){if(_0xc46201){if(_0xc46201[_0x1f51('0x3b')]===0x0){_0x48b081[_0x1f51('0x44')]('i.'+_0x24b8ad+_0x1f51('0x5d'));}else{_0x48b081[_0x1f51('0x44')]('i.'+_0x24b8ad+_0x1f51('0x15'),_[_0x1f51('0x16')](_0xc46201,'id'));}}else if(!_0x37eec5[_0x24b8ad]){_0x48b081[_0x1f51('0x44')]('i.'+_0x24b8ad+_0x1f51('0x68'));}})[_0x1f51('0x60')](function(){return _0x48b081;});}function getClosedOrderClause(_0x4bf4c9,_0x2c8e58){var _0x1e9dd8='';var _0x5a19d3=['i.thirdDisposition',_0x1f51('0x69'),_0x1f51('0x6a')];if(_0x4bf4c9===_0x1f51('0x34')){_0x5a19d3[_0x1f51('0x6b')](_0x1f51('0x6c'));}if(_0x2c8e58[_0x1f51('0x6d')]==='0'&&_0x4bf4c9==='mail'){_0x1e9dd8=_0x1f51('0x6c');}else{if(_0x2c8e58[_0x1f51('0x6d')]==='1'){_0x5a19d3[_0x1f51('0x6e')]();}_0x1e9dd8=_0x1f51('0x6f')+_0x5a19d3[_0x1f51('0x70')](',\x20')+')';}return _0x1e9dd8;}function getFilteredInteractions(_0x1aebaf,_0x3685a5,_0x2b10a3,_0x1c6776){var _0x29f00f=utils[_0x1f51('0xf')](_0x1aebaf);var _0xdf751c=_['capitalize'](_0x1aebaf)+_0x1f51('0x71');var _0x9b27bf=[];var _0x11308c=getTagsQuery();var _0x384fdf={'type':db[_0x1f51('0x72')][_0x1f51('0x73')][_0x1f51('0x74')],'raw':!![]};var _0x2e8c02=[];var _0x1a0572=[];return db[_0x1f51('0x75')][_0x1f51('0x76')](_0x11308c[_0x1f51('0x77')](),_0x384fdf)[_0x1f51('0x60')](function(_0x5d4bd4){_0x9b27bf=_['keyBy'](_0x5d4bd4,'id');_0x384fdf=_['merge'](_0x384fdf,{'model':db[_0xdf751c],'mapToModel':!![],'nest':!![]});if(_0x2b10a3[_0x1f51('0x78')]){_0x1c6776[_0x1f51('0x79')]['forEach'](function(_0x933a){_0x3685a5[_0x1f51('0xa')]('i.'+_0x933a);});}else{_0x3685a5[_0x1f51('0xa')](_0x1f51('0x7a'),_0x1f51('0x43'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x7b'),_0x1f51('0x7c'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x7d'),_0x1f51('0x7e'));if(_0x1aebaf===_0x1f51('0x34')){_0x3685a5[_0x1f51('0xa')](_0x1f51('0x7f'),_0x1f51('0x80'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x81'),'contactName');_0x3685a5[_0x1f51('0xa')]('i.id');_0x3685a5['field']('i.createdAt');_0x3685a5[_0x1f51('0xa')](_0x1f51('0x82'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x83'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x84'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x85'));_0x3685a5[_0x1f51('0xa')]('i.lastMsgAt');_0x3685a5[_0x1f51('0xa')](_0x1f51('0x86'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x87'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x6a'));_0x3685a5['field'](_0x1f51('0x69'));_0x3685a5['field']('i.thirdDisposition');_0x3685a5[_0x1f51('0xa')](_0x1f51('0x6c'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x88'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x89'));_0x3685a5['field'](_0x1f51('0x8a'));_0x3685a5['field'](_0x1f51('0x8b'));}else if(_0x1aebaf===_0x1f51('0x31')){_0x3685a5[_0x1f51('0xa')](_0x1f51('0x8c'),_0x1f51('0x8d'));}else{_0x3685a5[_0x1f51('0xa')]('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',_0x1f51('0x8d'));}if(_0x1aebaf!==_0x1f51('0x34')){_0x3685a5['field'](_0x1f51('0x8e'));}_0x3685a5[_0x1f51('0xa')](_0x1f51('0x8f'),_0x1f51('0x90'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x91'),_0x1f51('0x92'));_0x3685a5[_0x1f51('0xa')]('c.email',_0x1f51('0x93'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x94'),_0x1f51('0x95'));_0x3685a5[_0x1f51('0xa')]('c.mobile',_0x1f51('0x96'));_0x3685a5[_0x1f51('0xa')]('c.fax',_0x1f51('0x97'));_0x3685a5[_0x1f51('0xa')]('o.fullname',_0x1f51('0x98'));_0x3685a5[_0x1f51('0xa')](_0x1f51('0x99'),_0x1f51('0x9a'));_0x3685a5['field'](_0x1f51('0x9b'),'TagIds');}if(_0x1c6776[_0x1f51('0x9c')]){_0x3685a5['limit'](_0x1c6776[_0x1f51('0x9c')]);}if(_0x1c6776['offset']){_0x3685a5['offset'](_0x1c6776['offset']);}return db['sequelize'][_0x1f51('0x76')](_0x3685a5[_0x1f51('0x77')](),_0x384fdf);})[_0x1f51('0x60')](function(_0x4a35e1){_0x2e8c02=_0x4a35e1;var _0x17adf2=getUsersQuery(_0x1aebaf,_0x2e8c02);return db[_0x1f51('0x75')][_0x1f51('0x76')](_0x17adf2[_0x1f51('0x77')](),_0x384fdf);})[_0x1f51('0x60')](function(_0x4c979c){_0x1a0572=_[_0x1f51('0x9d')](_0x4c979c,_0x29f00f);if(_0x1aebaf==='mail'){return db[_0x1f51('0x9e')][_0x1f51('0x9f')]({'attributes':[_0x1f51('0xa0')],'raw':!![]});}})[_0x1f51('0x60')](function(_0x24296e){var _0x27cd31=_0x24296e?_0x24296e[_0x1f51('0xa0')]:undefined;var _0x905047=_0x2e8c02[_0x1f51('0x16')](function(_0x285600){return updateInteraction(_0x285600,_0x9b27bf,_0x1a0572,_0x27cd31);});return Promise[_0x1f51('0xa1')](_0x905047);});}function countFilteredInteractions(_0x57418b,_0x1eb30f){var _0xda4c4e=_0x57418b[_0x1f51('0xa2')]();_0xda4c4e[_0x1f51('0xa')](_0x1f51('0xa3'));_0xda4c4e['field'](_0x1f51('0x7a'),_0x1f51('0x43'));var _0x34c4bb=utils['getSelectedTags'](_0x1eb30f);if(!_['isEmpty'](_0x34c4bb)){_0xda4c4e[_0x1f51('0x14')](_0x1f51('0xa4'),_0x34c4bb);}var _0x1495d7={'type':db[_0x1f51('0x72')][_0x1f51('0x73')][_0x1f51('0x74')],'raw':!![]};return db[_0x1f51('0x75')][_0x1f51('0x76')](_0xda4c4e[_0x1f51('0x77')](),_0x1495d7);}module[_0x1f51('0xa5')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0xcccd=['query','toString','groupBy','Setting','findOne','enableEmailPreview','all','clone','t.id\x20IN\x20?','lodash','squel','../parsers/advancedSearch','updateInteraction','./utils','getAccountFK','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','ui.','left_join','u.id\x20=\x20ui.UserId','where','\x20IN\x20?','map','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','accounts','messages','me.','\x20=\x20i.id','interactionsTags','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','whatsapp','i.phone\x20LIKE\x20?','fax','openchannel','i.from\x20LIKE\x20?','mail','isEmail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','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','length','buildExpression','type','text','start','value','unreadMessages','read','and','Contact','operator','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','end','Tag','tags','ids','$substring','user','find','UserId','body','plainBody','some','compact','concat','createdAt','parse','$gte','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','clause','filter','get','capitalize','Websites','role','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','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.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','i.subject','i.to','i.MailAccountId','i.UserId','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset'];(function(_0x29ecae,_0x4673fa){var _0x2b18cb=function(_0x4e7425){while(--_0x4e7425){_0x29ecae['push'](_0x29ecae['shift']());}};_0x2b18cb(++_0x4673fa);}(_0xcccd,0x147));var _0xdccc=function(_0x6afc9c,_0xf6b755){_0x6afc9c=_0x6afc9c-0x0;var _0x195d68=_0xcccd[_0x6afc9c];return _0x195d68;};'use strict';var _=require(_0xdccc('0x0'));var squel=require(_0xdccc('0x1'));var as=require(_0xdccc('0x2'));var qs=require('../parsers/qs');var updateInteraction=require('./update-interaction')[_0xdccc('0x3')];var utils=require(_0xdccc('0x4'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x24f8b2,_0x205c55,_0x21adc3){var _0xf81ffe=![];var _0x3fd6d6=utils[_0xdccc('0x5')](_0x24f8b2);if(_0x205c55['role']==='agent'&&!_0x21adc3[_0xdccc('0x6')]&&!_0x21adc3[_0x3fd6d6]){_0xf81ffe=!![];}return _0xf81ffe;}function getTagsQuery(){return squel[_0xdccc('0x7')]()[_0xdccc('0x8')]('id')[_0xdccc('0x8')](_0xdccc('0x9'))[_0xdccc('0x8')](_0xdccc('0xa'))[_0xdccc('0xb')](_0xdccc('0xc'));}function getUsersQuery(_0x2fc2e9,_0x55c990){var _0x1b16c0=utils[_0xdccc('0xd')](_0x2fc2e9);var _0x388ee2=_0xdccc('0xe')+_0x2fc2e9+_0xdccc('0xf');var _0x2f6f44=squel[_0xdccc('0x7')]()['field']('u.id')[_0xdccc('0x8')]('u.fullname')['field'](_0xdccc('0x10')+_0x1b16c0)[_0xdccc('0xb')](_0x388ee2,'ui')[_0xdccc('0x11')]('users','u',_0xdccc('0x12'));if(_0x55c990['length']>0x0){_0x2f6f44[_0xdccc('0x13')](_0xdccc('0x10')+_0x1b16c0+_0xdccc('0x14'),_[_0xdccc('0x15')](_0x55c990,'id'));}return _0x2f6f44;}function getInteractionsQuery(_0x16fda9){var _0x5e77cb=utils['getInteractionsTables'](_0x16fda9);var _0x5d9d5b=utils[_0xdccc('0x5')](_0x16fda9);var _0x187daa=utils[_0xdccc('0xd')](_0x16fda9);return squel[_0xdccc('0x7')]()[_0xdccc('0xb')](_0x5e77cb[_0xdccc('0x16')],'i')[_0xdccc('0x11')](_0xdccc('0x17'),'c',_0xdccc('0x18'))[_0xdccc('0x11')](_0xdccc('0x19'),'o',_0xdccc('0x1a'))[_0xdccc('0x11')](_0x5e77cb[_0xdccc('0x1b')],'a','a.id\x20=\x20i.'+_0x5d9d5b)[_0xdccc('0x11')](_0x5e77cb[_0xdccc('0x1c')],'me',_0xdccc('0x1d')+_0x187daa+_0xdccc('0x1e'))[_0xdccc('0x11')](_0x5e77cb[_0xdccc('0x1f')],'it',_0xdccc('0x20')+_0x187daa+_0xdccc('0x1e'))[_0xdccc('0x11')](_0xdccc('0xc'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x3d8629={'body':squel[_0xdccc('0x21')](),'contact':squel[_0xdccc('0x21')](),'default':squel['expr'](),'fields':squel[_0xdccc('0x21')](),'filter':squel['expr'](),'read':squel[_0xdccc('0x21')](),'tags':{'clause':squel[_0xdccc('0x21')](),'ids':null},'user':squel[_0xdccc('0x21')]()};return _0x3d8629;}function parseTagParameter(_0x4fbc44){var _0x4c192a=squel['expr']();if(_0x4fbc44){var _0x4ef99e=utils[_0xdccc('0x22')](_0x4fbc44);_0x4ef99e[_0xdccc('0x23')](function(_0x49cd5e){_0x4c192a['or'](_0xdccc('0x24'),'%,'+_0x49cd5e+',%');});}return _0x4c192a;}function parseReadParameter(_0x12c0fd){var _0x5b5f8b='';if(_0x12c0fd){_0x5b5f8b='unreadMessages\x20{OPERATOR}\x200';if(_0x12c0fd==='1'){_0x5b5f8b=_0x5b5f8b[_0xdccc('0x25')]('{OPERATOR}','=');}else{_0x5b5f8b=_0x5b5f8b[_0xdccc('0x25')](_0xdccc('0x26'),'>');}}return _0x5b5f8b;}function parseSearchFilter(_0x37c2ab,_0x509f96){var _0x33f699=squel[_0xdccc('0x21')]();if(_0x509f96){var _0x3ed1f7=_0x509f96[_0xdccc('0x25')]('\x5c','\x5c\x5c')[_0xdccc('0x25')](/'/g,'\x27\x27');var _0x36f9ef=qs['escapeLIKESpecialChars'](_0x3ed1f7);if(qs[_0xdccc('0x27')](_0x3ed1f7)){_0x33f699['or'](_0xdccc('0x28'),_0x36f9ef+'%');if(['sms',_0xdccc('0x29')]['includes'](_0x37c2ab)){_0x33f699['or'](_0xdccc('0x2a'),_0x36f9ef+'%');}else if(_0x37c2ab===_0xdccc('0x2b')){_0x33f699['or']('i.fax\x20LIKE\x20?',_0x36f9ef+'%');}else if(_0x37c2ab===_0xdccc('0x2c')){_0x33f699['or'](_0xdccc('0x2d'),_0x36f9ef+'%');}}else if(_0x37c2ab===_0xdccc('0x2e')&&qs[_0xdccc('0x2f')](_0x3ed1f7)){_0x33f699['or']('c.email\x20LIKE\x20?',_0x36f9ef+'%');}else{if(_0x37c2ab===_0xdccc('0x2e')){_0x33f699['or'](_0xdccc('0x30'),qs[_0xdccc('0x31')](_0x3ed1f7,!![]))['or'](_0xdccc('0x32'),qs[_0xdccc('0x31')](_0x3ed1f7));}else if(_0x37c2ab!=='fax'){_0x33f699['or'](_0xdccc('0x33'),qs['getFullTextValue'](_0x3ed1f7));}_0x33f699['or'](_0xdccc('0x34'),qs['getFullTextValue'](_0x3ed1f7,!![]),null);}}return _0x33f699;}function parseAdvancedSearchFilter(_0x33e9f0,_0x3ace54){var _0x1a5eb5=getSqlClauses();var _0x42245f=as['parseSearch'](_0x33e9f0);var _0x120998=_0x42245f[_0xdccc('0x35')];for(var _0x58468e=0x0;_0x58468e<_0x42245f[_0xdccc('0x36')][_0xdccc('0x37')];_0x58468e++){var _0x1162c3=_0x42245f['conditions'][_0x58468e];var _0x119dd8='i';var _0x8a74b6=_['find'](_0x3ace54,[_0xdccc('0x9'),_0x1162c3[_0xdccc('0x8')]]);if(_0x8a74b6){var _0x58ca45=as[_0xdccc('0x38')](_0x119dd8,_0x8a74b6[_0xdccc('0x39')],_0x1162c3);_0x1a5eb5['default'][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45['value'][_0xdccc('0x3b')],_0x58ca45[_0xdccc('0x3c')]['end']);}else{switch(_0x1162c3[_0xdccc('0x8')]){case _0xdccc('0x3d'):var _0x58b082=parseReadParameter(_0x1162c3[_0xdccc('0x3c')]);_0x1a5eb5[_0xdccc('0x3e')][_0xdccc('0x3f')](_0x58b082);break;case _0xdccc('0x40'):if(_0x1162c3[_0xdccc('0x41')]==='$substring'){if(_0x1162c3[_0xdccc('0x3c')][_0xdccc('0x42')]('\x20')['length']>0x1){_0x1a5eb5[_0xdccc('0x43')][_0x120998](_0xdccc('0x34'),qs[_0xdccc('0x31')](_0x1162c3[_0xdccc('0x3c')],!![]),null);}else{var _0x1def0d='%'+_0x1162c3[_0xdccc('0x3c')]+'%';_0x1a5eb5[_0xdccc('0x43')][_0x120998](_0xdccc('0x44'),_0x1def0d,_0x1def0d,_0x1def0d);}}else{_0x8a74b6=_['find'](_0x3ace54,['name',_0xdccc('0x45')]);_0x1162c3[_0xdccc('0x8')]=_0xdccc('0x45');_0x58ca45=as['buildExpression'](_0x119dd8,_0x8a74b6[_0xdccc('0x39')],_0x1162c3);_0x1a5eb5['contact'][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45['value']['start'],_0x58ca45['value'][_0xdccc('0x46')]);}break;case _0xdccc('0x47'):var _0x4f941e=_0x1162c3[_0xdccc('0x3c')][_0xdccc('0x42')](',')[_0xdccc('0x15')](function(_0x14855b){return Number(_0x14855b);});var _0x5417bf=parseTagParameter(_0x4f941e);_0x1a5eb5[_0xdccc('0x48')]['clause'][_0xdccc('0x3f')](_0x5417bf);_0x1a5eb5[_0xdccc('0x48')][_0xdccc('0x49')]=_0x4f941e;break;case'User':if(_0x1162c3[_0xdccc('0x41')]===_0xdccc('0x4a')){_0x1a5eb5[_0xdccc('0x4b')][_0x120998]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x1162c3[_0xdccc('0x3c')]+'%',null);}else{_0x8a74b6=_[_0xdccc('0x4c')](_0x3ace54,['name','UserId']);_0x1162c3[_0xdccc('0x8')]=_0xdccc('0x4d');_0x58ca45=as[_0xdccc('0x38')](_0x119dd8,_0x8a74b6['type'],_0x1162c3);_0x1a5eb5[_0xdccc('0x4b')][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45['value'][_0xdccc('0x3b')],_0x58ca45[_0xdccc('0x3c')]['end']);}break;case _0xdccc('0x4e'):case _0xdccc('0x4f'):_0x58ca45=as['buildExpression']('me',null,_0x1162c3);_0x1a5eb5[_0xdccc('0x4e')][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45[_0xdccc('0x3c')][_0xdccc('0x3b')],_0x58ca45[_0xdccc('0x3c')][_0xdccc('0x46')]);break;}}}return _0x1a5eb5;}function parseModelFields(_0x3eeae2,_0x1a45c8,_0x470b03){var _0x2873a5=utils[_0xdccc('0x5')](_0x3eeae2);var _0x55062a=squel[_0xdccc('0x21')]();var _0x4a3fbd=_(_0x1a45c8)['keys']()[_0xdccc('0x15')](function(_0x5743dd){return _[_0xdccc('0x50')](_0x470b03,[_0xdccc('0x9'),_0x5743dd])?_0x5743dd:undefined;})[_0xdccc('0x51')]()[_0xdccc('0x3c')]();if(_0x4a3fbd['length']>0x0){_0x4a3fbd[_0xdccc('0x23')](function(_0x41a32e){if(_0x41a32e===_0x2873a5){_0x55062a['and']('i.'+_0x2873a5+'\x20IN\x20?',[][_0xdccc('0x52')](_0x1a45c8[_0x41a32e]));}else if(_0x41a32e===_0xdccc('0x53')){var _0x221973=JSON[_0xdccc('0x54')](_0x1a45c8[_0x41a32e])[_0xdccc('0x55')];var _0x4673ba=JSON[_0xdccc('0x54')](_0x1a45c8[_0x41a32e])['$lte'];_0x55062a[_0xdccc('0x3f')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x221973,_0x4673ba);}else{if(_0x1a45c8[_0x41a32e]===_0xdccc('0x56')){_0x55062a[_0xdccc('0x3f')]('i.'+_0x41a32e+_0xdccc('0x57'));}else{_0x55062a[_0xdccc('0x3f')]('i.'+_0x41a32e+_0xdccc('0x58'),_0x1a45c8[_0x41a32e]);}}});}return _0x55062a;}function parseQueryParameters(_0x35bcff,_0x423264,_0x1a5727){var _0x569e57=getSqlClauses();return Promise[_0xdccc('0x59')]()[_0xdccc('0x5a')](function(){return parseModelFields(_0x35bcff,_0x423264,_0x1a5727);})[_0xdccc('0x5a')](function(_0x4b2bd6){_0x569e57[_0xdccc('0x5b')][_0xdccc('0x3f')](_0x4b2bd6);return parseReadParameter(_0x423264[_0xdccc('0x3e')]);})[_0xdccc('0x5a')](function(_0x3b0d81){_0x569e57['read'][_0xdccc('0x3f')](_0x3b0d81);return parseTagParameter(_0x423264[_0xdccc('0x5c')]);})[_0xdccc('0x5a')](function(_0x469441){_0x569e57[_0xdccc('0x48')][_0xdccc('0x5d')][_0xdccc('0x3f')](_0x469441);return parseSearchFilter(_0x35bcff,_0x423264[_0xdccc('0x5e')]);})[_0xdccc('0x5a')](function(_0x4673ed){_0x569e57['filter']=_0x4673ed;return _0x569e57;});}function checkAccountsRestrictions(_0x4d54f0,_0x50c91d,_0x30e5ed){var _0x2cc71e=utils[_0xdccc('0x5')](_0x4d54f0);var _0xe5fabe=_0xdccc('0x5f')+_[_0xdccc('0x60')](_0x4d54f0)+(_0x4d54f0==='chat'?_0xdccc('0x61'):'Accounts');var _0x1bcd47=squel['expr']();return Promise[_0xdccc('0x59')]()['then'](function(){if(_0x30e5ed[_0xdccc('0x6')]&&_0x50c91d[_0xdccc('0x62')]===_0xdccc('0x63')){return _0x50c91d[_0xe5fabe]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x3047a7){if(_0x3047a7){if(_0x3047a7[_0xdccc('0x37')]===0x0){_0x1bcd47[_0xdccc('0x3f')]('i.'+_0x2cc71e+'\x20IS\x20NULL');}else{_0x1bcd47['and']('i.'+_0x2cc71e+_0xdccc('0x14'),_[_0xdccc('0x15')](_0x3047a7,'id'));}}else if(!_0x30e5ed[_0x2cc71e]){_0x1bcd47[_0xdccc('0x3f')]('i.'+_0x2cc71e+_0xdccc('0x64'));}})[_0xdccc('0x5a')](function(){return _0x1bcd47;});}function getClosedOrderClause(_0x11089f,_0x4f5c20){var _0x2103c='';var _0x18ff34=[_0xdccc('0x65'),_0xdccc('0x66'),_0xdccc('0x67')];if(_0x11089f==='mail'){_0x18ff34[_0xdccc('0x68')]('i.substatus');}if(_0x4f5c20['closed']==='0'&&_0x11089f===_0xdccc('0x2e')){_0x2103c=_0xdccc('0x69');}else{if(_0x4f5c20['closed']==='1'){_0x18ff34[_0xdccc('0x6a')]();}_0x2103c=_0xdccc('0x6b')+_0x18ff34[_0xdccc('0x6c')](',\x20')+')';}return _0x2103c;}function getFilteredInteractions(_0x3c7e88,_0x4ec1d1,_0x15d177,_0x2822a4){var _0x372e19=utils['getInteractionFK'](_0x3c7e88);var _0x2b44b5=_[_0xdccc('0x60')](_0x3c7e88)+_0xdccc('0x6d');var _0x4829ba=[];var _0x169f55=getTagsQuery();var _0x1cfe26={'type':db[_0xdccc('0x6e')][_0xdccc('0x6f')][_0xdccc('0x70')],'raw':!![]};var _0xa0d620=[];var _0x2c62fc=[];return db[_0xdccc('0x71')]['query'](_0x169f55['toString'](),_0x1cfe26)[_0xdccc('0x5a')](function(_0x306542){_0x4829ba=_[_0xdccc('0x72')](_0x306542,'id');_0x1cfe26=_[_0xdccc('0x73')](_0x1cfe26,{'model':db[_0x2b44b5],'mapToModel':!![],'nest':!![]});if(_0x15d177['fields']){_0x2822a4[_0xdccc('0x74')][_0xdccc('0x23')](function(_0x4b51ed){_0x4ec1d1[_0xdccc('0x8')]('i.'+_0x4b51ed);});}else{_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x75'),_0xdccc('0x3d'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x76'),_0xdccc('0x77'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x78'),_0xdccc('0x79'));if(_0x3c7e88===_0xdccc('0x2e')){_0x4ec1d1['field'](_0xdccc('0x7a'),_0xdccc('0x7b'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x7c'),_0xdccc('0x7d'));_0x4ec1d1[_0xdccc('0x8')]('i.id');_0x4ec1d1['field']('i.createdAt');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x7e'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x7f'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x80'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x81'));_0x4ec1d1[_0xdccc('0x8')]('i.lastMsgAt');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x82'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x83'));_0x4ec1d1['field'](_0xdccc('0x67'));_0x4ec1d1[_0xdccc('0x8')]('i.secondDisposition');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x65'));_0x4ec1d1['field'](_0xdccc('0x69'));_0x4ec1d1['field'](_0xdccc('0x84'));_0x4ec1d1[_0xdccc('0x8')]('i.ContactId');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x85'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x86'));}else if(_0x3c7e88===_0xdccc('0x2c')){_0x4ec1d1[_0xdccc('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',_0xdccc('0x7d'));}else{_0x4ec1d1[_0xdccc('0x8')]('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',_0xdccc('0x7d'));}if(_0x3c7e88!==_0xdccc('0x2e')){_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x87'));}_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x88'),_0xdccc('0x89'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x8a'),_0xdccc('0x8b'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x8c'),'Contact.email');_0x4ec1d1['field']('c.phone','Contact.phone');_0x4ec1d1['field'](_0xdccc('0x8d'),'Contact.mobile');_0x4ec1d1['field'](_0xdccc('0x8e'),_0xdccc('0x8f'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x90'),_0xdccc('0x91'));_0x4ec1d1[_0xdccc('0x8')]('o.internal','Owner.internal');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x92'),_0xdccc('0x93'));}if(_0x2822a4[_0xdccc('0x94')]){_0x4ec1d1[_0xdccc('0x94')](_0x2822a4[_0xdccc('0x94')]);}if(_0x2822a4[_0xdccc('0x95')]){_0x4ec1d1[_0xdccc('0x95')](_0x2822a4['offset']);}return db[_0xdccc('0x71')][_0xdccc('0x96')](_0x4ec1d1[_0xdccc('0x97')](),_0x1cfe26);})[_0xdccc('0x5a')](function(_0x4a509e){_0xa0d620=_0x4a509e;var _0x509cfc=getUsersQuery(_0x3c7e88,_0xa0d620);return db[_0xdccc('0x71')][_0xdccc('0x96')](_0x509cfc[_0xdccc('0x97')](),_0x1cfe26);})[_0xdccc('0x5a')](function(_0x2e108d){_0x2c62fc=_[_0xdccc('0x98')](_0x2e108d,_0x372e19);if(_0x3c7e88===_0xdccc('0x2e')){return db[_0xdccc('0x99')][_0xdccc('0x9a')]({'attributes':[_0xdccc('0x9b')],'raw':!![]});}})[_0xdccc('0x5a')](function(_0x389576){var _0x683170=_0x389576?_0x389576['enableEmailPreview']:undefined;var _0x5a5885=_0xa0d620[_0xdccc('0x15')](function(_0x2ba896){return updateInteraction(_0x2ba896,_0x4829ba,_0x2c62fc,_0x683170);});return Promise[_0xdccc('0x9c')](_0x5a5885);});}function countFilteredInteractions(_0x1ccec4,_0x1f01ea){var _0x34785e=_0x1ccec4[_0xdccc('0x9d')]();_0x34785e['field']('COUNT(*)');_0x34785e['field'](_0xdccc('0x75'),_0xdccc('0x3d'));var _0x130458=utils['getSelectedTags'](_0x1f01ea);if(!_['isEmpty'](_0x130458)){_0x34785e[_0xdccc('0x13')](_0xdccc('0x9e'),_0x130458);}var _0x27216e={'type':db[_0xdccc('0x6e')][_0xdccc('0x6f')][_0xdccc('0x70')],'raw':!![]};return db[_0xdccc('0x71')][_0xdccc('0x96')](_0x34785e['toString'](),_0x27216e);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff