// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6fa4=['length','where','\x20IN\x20?','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','it.','expr','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.fax\x20LIKE\x20?','i.from\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','fax','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','start','value','read','and','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','end','Tag','split','map','tags','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','some','concat','createdAt','$gte','parse','$lte','null','\x20IS\x20NULL','\x20=\x20?','resolve','fields','then','clause','filter','get','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','QueryTypes','SELECT','sequelize','toString','keyBy','merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','a.key','Account.key','a.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.id','i.updatedAt','i.closed','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.to','i.UserId','openchannel','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','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','c.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','TagIds','limit','offset','query','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','getSelectedTags','isEmpty','t.id\x20IN\x20?','Sequelize','exports','lodash','squel','./update-interaction','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','name','color','from','tools_tags','getInteractionFK','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId'];(function(_0x4d01c4,_0x4a9db1){var _0x57219d=function(_0x2d9dcb){while(--_0x2d9dcb){_0x4d01c4['push'](_0x4d01c4['shift']());}};_0x57219d(++_0x4a9db1);}(_0x6fa4,0x1dc));var _0x46fa=function(_0x47a397,_0x267dc6){_0x47a397=_0x47a397-0x0;var _0x36d592=_0x6fa4[_0x47a397];return _0x36d592;};'use strict';var _=require(_0x46fa('0x0'));var squel=require(_0x46fa('0x1'));var as=require('../parsers/advancedSearch');var qs=require('../parsers/qs');var updateInteraction=require(_0x46fa('0x2'))['updateInteraction'];var utils=require(_0x46fa('0x3'));var db=require(_0x46fa('0x4'))['db'];function skipInteractionsQuery(_0x9b7ce0,_0x824306,_0x38ce71){var _0x586cb8=![];var _0x3b2d5f=utils[_0x46fa('0x5')](_0x9b7ce0);if(_0x824306[_0x46fa('0x6')]===_0x46fa('0x7')&&!_0x38ce71[_0x46fa('0x8')]&&!_0x38ce71[_0x3b2d5f]){_0x586cb8=!![];}return _0x586cb8;}function getTagsQuery(){return squel[_0x46fa('0x9')]()[_0x46fa('0xa')]('id')['field'](_0x46fa('0xb'))[_0x46fa('0xa')](_0x46fa('0xc'))[_0x46fa('0xd')](_0x46fa('0xe'));}function getUsersQuery(_0x418c39,_0x3656f3){var _0x30802c=utils[_0x46fa('0xf')](_0x418c39);var _0x165469='user_has_'+_0x418c39+'_interactions';var _0x49f444=squel[_0x46fa('0x9')]()[_0x46fa('0xa')](_0x46fa('0x10'))[_0x46fa('0xa')](_0x46fa('0x11'))['field'](_0x46fa('0x12')+_0x30802c)[_0x46fa('0xd')](_0x165469,'ui')[_0x46fa('0x13')](_0x46fa('0x14'),'u',_0x46fa('0x15'));if(_0x3656f3[_0x46fa('0x16')]>0x0){_0x49f444[_0x46fa('0x17')](_0x46fa('0x12')+_0x30802c+_0x46fa('0x18'),_['map'](_0x3656f3,'id'));}return _0x49f444;}function getInteractionsQuery(_0x130aa9){var _0x1cf600=utils[_0x46fa('0x19')](_0x130aa9);var _0x1e1217=utils[_0x46fa('0x5')](_0x130aa9);var _0x3b50b8=utils[_0x46fa('0xf')](_0x130aa9);return squel[_0x46fa('0x9')]()[_0x46fa('0xd')](_0x1cf600[_0x46fa('0x1a')],'i')[_0x46fa('0x13')]('cm_contacts','c',_0x46fa('0x1b'))['left_join'](_0x46fa('0x14'),'o',_0x46fa('0x1c'))[_0x46fa('0x13')](_0x1cf600[_0x46fa('0x1d')],'a',_0x46fa('0x1e')+_0x1e1217)['left_join'](_0x1cf600[_0x46fa('0x1f')],'me','me.'+_0x3b50b8+_0x46fa('0x20'))[_0x46fa('0x13')](_0x1cf600['interactionsTags'],'it',_0x46fa('0x21')+_0x3b50b8+_0x46fa('0x20'))['left_join'](_0x46fa('0xe'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x3e5343={'body':squel['expr'](),'contact':squel[_0x46fa('0x22')](),'default':squel['expr'](),'fields':squel[_0x46fa('0x22')](),'filter':squel['expr'](),'read':squel['expr'](),'tags':{'clause':squel[_0x46fa('0x22')](),'ids':null},'user':squel[_0x46fa('0x22')]()};return _0x3e5343;}function parseTagParameter(_0x2f9ce1){var _0x3bfcb1=squel[_0x46fa('0x22')]();if(_0x2f9ce1){var _0x5a2dca=utils['getSelectedTags'](_0x2f9ce1);_0x5a2dca[_0x46fa('0x23')](function(_0x227be6){_0x3bfcb1['or'](_0x46fa('0x24'),'%,'+_0x227be6+',%');});}return _0x3bfcb1;}function parseReadParameter(_0xa7bc6f){var _0x25ad4e='';if(_0xa7bc6f){_0x25ad4e=_0x46fa('0x25');if(_0xa7bc6f==='1'){_0x25ad4e=_0x25ad4e[_0x46fa('0x26')](_0x46fa('0x27'),'=');}else{_0x25ad4e=_0x25ad4e[_0x46fa('0x26')](_0x46fa('0x27'),'>');}}return _0x25ad4e;}function parseSearchFilter(_0x339675,_0x1de6ae){var _0x38002d=squel[_0x46fa('0x22')]();if(_0x1de6ae){var _0x338aad=_0x1de6ae[_0x46fa('0x26')]('\x5c','\x5c\x5c')[_0x46fa('0x26')](/'/g,'\x27\x27');var _0x13eede=qs[_0x46fa('0x28')](_0x338aad);if(qs[_0x46fa('0x29')](_0x338aad)){_0x38002d['or'](_0x46fa('0x2a'),_0x13eede+'%');if([_0x46fa('0x2b'),_0x46fa('0x2c')][_0x46fa('0x2d')](_0x339675)){_0x38002d['or']('i.phone\x20LIKE\x20?',_0x13eede+'%');}else if(_0x339675==='fax'){_0x38002d['or'](_0x46fa('0x2e'),_0x13eede+'%');}else if(_0x339675==='openchannel'){_0x38002d['or'](_0x46fa('0x2f'),_0x13eede+'%');}}else if(_0x339675==='mail'&&qs[_0x46fa('0x30')](_0x338aad)){_0x38002d['or'](_0x46fa('0x31'),_0x13eede+'%');}else{if(_0x339675===_0x46fa('0x32')){_0x38002d['or'](_0x46fa('0x33'),qs['getFullTextValue'](_0x338aad,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x46fa('0x34')](_0x338aad));}else if(_0x339675!==_0x46fa('0x35')){_0x38002d['or'](_0x46fa('0x36'),qs['getFullTextValue'](_0x338aad));}_0x38002d['or'](_0x46fa('0x37'),qs[_0x46fa('0x34')](_0x338aad,!![]),null);}}return _0x38002d;}function parseAdvancedSearchFilter(_0x1d6721,_0x3ef32c){var _0x3eaed4=getSqlClauses();var _0x2f0a80=as['parseSearch'](_0x1d6721);var _0x573227=_0x2f0a80[_0x46fa('0x38')];for(var _0x3865f2=0x0;_0x3865f2<_0x2f0a80[_0x46fa('0x39')]['length'];_0x3865f2++){var _0x3a3cdc=_0x2f0a80[_0x46fa('0x39')][_0x3865f2];var _0xdba59='i';var _0x25e301=_[_0x46fa('0x3a')](_0x3ef32c,[_0x46fa('0xb'),_0x3a3cdc[_0x46fa('0xa')]]);if(_0x25e301){var _0x3a84bb=as[_0x46fa('0x3b')](_0xdba59,_0x25e301[_0x46fa('0x3c')],_0x3a3cdc);_0x3eaed4[_0x46fa('0x3d')][_0x573227](_0x3a84bb[_0x46fa('0x3e')],_0x3a84bb['value'][_0x46fa('0x3f')],_0x3a84bb[_0x46fa('0x40')]['end']);}else{switch(_0x3a3cdc['field']){case'unreadMessages':var _0x51c902=parseReadParameter(_0x3a3cdc['value']);_0x3eaed4[_0x46fa('0x41')][_0x46fa('0x42')](_0x51c902);break;case'Contact':if(_0x3a3cdc[_0x46fa('0x43')]===_0x46fa('0x44')){if(_0x3a3cdc[_0x46fa('0x40')]['split']('\x20')[_0x46fa('0x16')]>0x1){_0x3eaed4[_0x46fa('0x45')][_0x573227](_0x46fa('0x37'),qs[_0x46fa('0x34')](_0x3a3cdc['value'],!![]),null);}else{var _0x5008c7='%'+_0x3a3cdc['value']+'%';_0x3eaed4['contact'][_0x573227](_0x46fa('0x46'),_0x5008c7,_0x5008c7,_0x5008c7);}}else{_0x25e301=_[_0x46fa('0x3a')](_0x3ef32c,['name',_0x46fa('0x47')]);_0x3a3cdc['field']=_0x46fa('0x47');_0x3a84bb=as[_0x46fa('0x3b')](_0xdba59,_0x25e301[_0x46fa('0x3c')],_0x3a3cdc);_0x3eaed4['contact'][_0x573227](_0x3a84bb[_0x46fa('0x3e')],_0x3a84bb['value'][_0x46fa('0x3f')],_0x3a84bb[_0x46fa('0x40')][_0x46fa('0x48')]);}break;case _0x46fa('0x49'):var _0x3346a4=_0x3a3cdc[_0x46fa('0x40')][_0x46fa('0x4a')](',')[_0x46fa('0x4b')](function(_0x568549){return Number(_0x568549);});var _0x329a68=parseTagParameter(_0x3346a4);_0x3eaed4[_0x46fa('0x4c')]['clause'][_0x46fa('0x42')](_0x329a68);_0x3eaed4['tags'][_0x46fa('0x4d')]=_0x3346a4;break;case _0x46fa('0x4e'):if(_0x3a3cdc[_0x46fa('0x43')]===_0x46fa('0x44')){_0x3eaed4[_0x46fa('0x4f')][_0x573227](_0x46fa('0x50'),'%'+_0x3a3cdc['value']+'%',null);}else{_0x25e301=_[_0x46fa('0x3a')](_0x3ef32c,[_0x46fa('0xb'),_0x46fa('0x51')]);_0x3a3cdc[_0x46fa('0xa')]=_0x46fa('0x51');_0x3a84bb=as[_0x46fa('0x3b')](_0xdba59,_0x25e301[_0x46fa('0x3c')],_0x3a3cdc);_0x3eaed4[_0x46fa('0x4f')][_0x573227](_0x3a84bb['text'],_0x3a84bb[_0x46fa('0x40')][_0x46fa('0x3f')],_0x3a84bb[_0x46fa('0x40')][_0x46fa('0x48')]);}break;case _0x46fa('0x52'):case _0x46fa('0x53'):_0x3a84bb=as['buildExpression']('me',null,_0x3a3cdc);_0x3eaed4[_0x46fa('0x52')][_0x573227](_0x3a84bb[_0x46fa('0x3e')],_0x3a84bb['value'][_0x46fa('0x3f')],_0x3a84bb['value'][_0x46fa('0x48')]);break;}}}return _0x3eaed4;}function parseModelFields(_0x5edd3d,_0x557020,_0x256c05){var _0x3f757f=utils['getAccountFK'](_0x5edd3d);var _0x915a60=squel['expr']();var _0x2bb4ff=_(_0x557020)['keys']()[_0x46fa('0x4b')](function(_0x4e07e0){return _[_0x46fa('0x54')](_0x256c05,[_0x46fa('0xb'),_0x4e07e0])?_0x4e07e0:undefined;})['compact']()['value']();if(_0x2bb4ff[_0x46fa('0x16')]>0x0){_0x2bb4ff[_0x46fa('0x23')](function(_0x576ace){if(_0x576ace===_0x3f757f){_0x915a60[_0x46fa('0x42')]('i.'+_0x3f757f+_0x46fa('0x18'),[][_0x46fa('0x55')](_0x557020[_0x576ace]));}else if(_0x576ace===_0x46fa('0x56')){var _0x2bd0c7=JSON['parse'](_0x557020[_0x576ace])[_0x46fa('0x57')];var _0x4bca1b=JSON[_0x46fa('0x58')](_0x557020[_0x576ace])[_0x46fa('0x59')];_0x915a60[_0x46fa('0x42')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x2bd0c7,_0x4bca1b);}else{if(_0x557020[_0x576ace]===_0x46fa('0x5a')){_0x915a60['and']('i.'+_0x576ace+_0x46fa('0x5b'));}else{_0x915a60[_0x46fa('0x42')]('i.'+_0x576ace+_0x46fa('0x5c'),_0x557020[_0x576ace]);}}});}return _0x915a60;}function parseQueryParameters(_0x11e9b0,_0x1cd2c4,_0x5a1d0f){var _0x217942=getSqlClauses();return Promise[_0x46fa('0x5d')]()['then'](function(){return parseModelFields(_0x11e9b0,_0x1cd2c4,_0x5a1d0f);})['then'](function(_0x5f1dbd){_0x217942[_0x46fa('0x5e')][_0x46fa('0x42')](_0x5f1dbd);return parseReadParameter(_0x1cd2c4[_0x46fa('0x41')]);})[_0x46fa('0x5f')](function(_0x575e9b){_0x217942['read'][_0x46fa('0x42')](_0x575e9b);return parseTagParameter(_0x1cd2c4['tag']);})[_0x46fa('0x5f')](function(_0x1e482d){_0x217942['tags'][_0x46fa('0x60')][_0x46fa('0x42')](_0x1e482d);return parseSearchFilter(_0x11e9b0,_0x1cd2c4[_0x46fa('0x61')]);})[_0x46fa('0x5f')](function(_0x8b5002){_0x217942['filter']=_0x8b5002;return _0x217942;});}function checkAccountsRestrictions(_0x297a28,_0x56f85e,_0x211a86){var _0x17213a=utils[_0x46fa('0x5')](_0x297a28);var _0x35578a=_0x46fa('0x62')+_[_0x46fa('0x63')](_0x297a28)+(_0x297a28===_0x46fa('0x64')?_0x46fa('0x65'):_0x46fa('0x66'));var _0x58f7f9=squel[_0x46fa('0x22')]();return Promise[_0x46fa('0x5d')]()[_0x46fa('0x5f')](function(){if(_0x211a86[_0x46fa('0x8')]&&_0x56f85e[_0x46fa('0x6')]===_0x46fa('0x7')){return _0x56f85e[_0x35578a]({'attributes':['id'],'raw':!![]});}})[_0x46fa('0x5f')](function(_0x4fff07){if(_0x4fff07){if(_0x4fff07[_0x46fa('0x16')]===0x0){_0x58f7f9[_0x46fa('0x42')]('i.'+_0x17213a+_0x46fa('0x5b'));}else{_0x58f7f9[_0x46fa('0x42')]('i.'+_0x17213a+_0x46fa('0x18'),_[_0x46fa('0x4b')](_0x4fff07,'id'));}}else if(!_0x211a86[_0x17213a]){_0x58f7f9[_0x46fa('0x42')]('i.'+_0x17213a+_0x46fa('0x67'));}})[_0x46fa('0x5f')](function(){return _0x58f7f9;});}function getClosedOrderClause(_0x166276,_0x9aa0b4){var _0x4277a0='';var _0xfd24fd=['i.thirdDisposition',_0x46fa('0x68'),_0x46fa('0x69')];if(_0x166276==='mail'){_0xfd24fd[_0x46fa('0x6a')](_0x46fa('0x6b'));}if(_0x9aa0b4[_0x46fa('0x6c')]==='0'&&_0x166276===_0x46fa('0x32')){_0x4277a0=_0x46fa('0x6b');}else{if(_0x9aa0b4[_0x46fa('0x6c')]==='1'){_0xfd24fd[_0x46fa('0x6d')]();}_0x4277a0=_0x46fa('0x6e')+_0xfd24fd[_0x46fa('0x6f')](',\x20')+')';}return _0x4277a0;}function getFilteredInteractions(_0x2b7d77,_0x8b880a,_0x4a0bed,_0x1cd2d5){var _0x41179d=utils[_0x46fa('0xf')](_0x2b7d77);var _0x52069f=_[_0x46fa('0x63')](_0x2b7d77)+_0x46fa('0x70');var _0x3d9491=[];var _0x3a4839=getTagsQuery();var _0x36fb2d={'type':db['Sequelize'][_0x46fa('0x71')][_0x46fa('0x72')],'raw':!![]};var _0x170b5b=[];var _0x547cb7=[];return db[_0x46fa('0x73')]['query'](_0x3a4839[_0x46fa('0x74')](),_0x36fb2d)['then'](function(_0xd29bfd){_0x3d9491=_[_0x46fa('0x75')](_0xd29bfd,'id');_0x36fb2d=_[_0x46fa('0x76')](_0x36fb2d,{'model':db[_0x52069f],'mapToModel':!![],'nest':!![]});if(_0x4a0bed[_0x46fa('0x5e')]){_0x1cd2d5['attributes'][_0x46fa('0x23')](function(_0x37923c){_0x8b880a[_0x46fa('0xa')]('i.'+_0x37923c);});}else{_0x8b880a[_0x46fa('0xa')](_0x46fa('0x77'),_0x46fa('0x78'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x79'),_0x46fa('0x7a'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x7b'),'Account.mandatoryDisposition');if(_0x2b7d77===_0x46fa('0x32')){_0x8b880a[_0x46fa('0xa')](_0x46fa('0x7c'),'Account.email');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x7d'),'contactName');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x7e'));_0x8b880a['field']('i.createdAt');_0x8b880a['field'](_0x46fa('0x7f'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x80'));_0x8b880a['field'](_0x46fa('0x81'));_0x8b880a[_0x46fa('0xa')]('i.attach');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x82'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x83'));_0x8b880a[_0x46fa('0xa')]('i.subject');_0x8b880a['field'](_0x46fa('0x69'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x68'));_0x8b880a['field']('i.thirdDisposition');_0x8b880a[_0x46fa('0xa')]('i.substatus');_0x8b880a['field'](_0x46fa('0x84'));_0x8b880a[_0x46fa('0xa')]('i.ContactId');_0x8b880a[_0x46fa('0xa')]('i.MailAccountId');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x85'));}else if(_0x2b7d77===_0x46fa('0x86')){_0x8b880a['field'](_0x46fa('0x87'),_0x46fa('0x88'));}else{_0x8b880a[_0x46fa('0xa')](_0x46fa('0x89'),_0x46fa('0x88'));}if(_0x2b7d77!=='mail'){_0x8b880a[_0x46fa('0xa')]('i.*');}_0x8b880a[_0x46fa('0xa')](_0x46fa('0x8a'),_0x46fa('0x8b'));_0x8b880a['field'](_0x46fa('0x8c'),'Contact.lastName');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x8d'),_0x46fa('0x8e'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x8f'),_0x46fa('0x90'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x91'),'Contact.mobile');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x92'),_0x46fa('0x93'));_0x8b880a[_0x46fa('0xa')](_0x46fa('0x94'),'Owner.fullname');_0x8b880a[_0x46fa('0xa')](_0x46fa('0x95'),_0x46fa('0x96'));_0x8b880a[_0x46fa('0xa')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x46fa('0x97'));}if(_0x1cd2d5['limit']){_0x8b880a['limit'](_0x1cd2d5[_0x46fa('0x98')]);}if(_0x1cd2d5[_0x46fa('0x99')]){_0x8b880a[_0x46fa('0x99')](_0x1cd2d5[_0x46fa('0x99')]);}return db[_0x46fa('0x73')][_0x46fa('0x9a')](_0x8b880a[_0x46fa('0x74')](),_0x36fb2d);})['then'](function(_0x57c5a4){_0x170b5b=_0x57c5a4;var _0x2b2db8=getUsersQuery(_0x2b7d77,_0x170b5b);return db['sequelize'][_0x46fa('0x9a')](_0x2b2db8[_0x46fa('0x74')](),_0x36fb2d);})[_0x46fa('0x5f')](function(_0x486b3d){_0x547cb7=_['groupBy'](_0x486b3d,_0x41179d);if(_0x2b7d77===_0x46fa('0x32')){return db[_0x46fa('0x9b')][_0x46fa('0x9c')]({'attributes':[_0x46fa('0x9d')],'raw':!![]});}})['then'](function(_0x1218e3){var _0x12a53d=_0x1218e3?_0x1218e3[_0x46fa('0x9d')]:undefined;var _0x28d82b=_0x170b5b[_0x46fa('0x4b')](function(_0x19bee1){return updateInteraction(_0x19bee1,_0x3d9491,_0x547cb7,_0x12a53d);});return Promise[_0x46fa('0x9e')](_0x28d82b);});}function countFilteredInteractions(_0xc6cede,_0x5c2fdf){var _0x22e35a=_0xc6cede[_0x46fa('0x9f')]();_0x22e35a[_0x46fa('0xa')](_0x46fa('0xa0'));_0x22e35a[_0x46fa('0xa')](_0x46fa('0x77'),_0x46fa('0x78'));var _0xf3e54d=utils[_0x46fa('0xa1')](_0x5c2fdf);if(!_[_0x46fa('0xa2')](_0xf3e54d)){_0x22e35a[_0x46fa('0x17')](_0x46fa('0xa3'),_0xf3e54d);}var _0x563b54={'type':db[_0x46fa('0xa4')][_0x46fa('0x71')][_0x46fa('0x72')],'raw':!![]};return db[_0x46fa('0x73')]['query'](_0x22e35a[_0x46fa('0x74')](),_0x563b54);}module[_0x46fa('0xa5')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x4005=['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.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.subject','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','i.*','c.lastName','Contact.lastName','c.email','c.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','groupBy','findOne','enableEmailPreview','all','clone','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','getAccountFK','select','field','name','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','u.id\x20=\x20ui.UserId','where','map','getInteractionsTables','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','left_join','users','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','i.from\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','mail','isEmail','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','conditions','length','find','buildExpression','type','default','text','value','read','Contact','operator','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','start','end','Tag','clause','and','tags','User','$substring','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','keys','some','compact','\x20IN\x20?','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','filter','get','capitalize','Websites','Accounts','search','role','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','a.key'];(function(_0x299028,_0x4d7e9f){var _0x12154e=function(_0x558d18){while(--_0x558d18){_0x299028['push'](_0x299028['shift']());}};_0x12154e(++_0x4d7e9f);}(_0x4005,0x184));var _0x5400=function(_0x492cf0,_0x2214e1){_0x492cf0=_0x492cf0-0x0;var _0x22ac23=_0x4005[_0x492cf0];return _0x22ac23;};'use strict';var _=require(_0x5400('0x0'));var squel=require(_0x5400('0x1'));var as=require(_0x5400('0x2'));var qs=require(_0x5400('0x3'));var updateInteraction=require(_0x5400('0x4'))[_0x5400('0x5')];var utils=require(_0x5400('0x6'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x3862d8,_0x44d3c9,_0x24e02f){var _0x312070=![];var _0x1edb89=utils[_0x5400('0x7')](_0x3862d8);if(_0x44d3c9['role']==='agent'&&!_0x24e02f['search']&&!_0x24e02f[_0x1edb89]){_0x312070=!![];}return _0x312070;}function getTagsQuery(){return squel[_0x5400('0x8')]()[_0x5400('0x9')]('id')[_0x5400('0x9')](_0x5400('0xa'))[_0x5400('0x9')]('color')[_0x5400('0xb')](_0x5400('0xc'));}function getUsersQuery(_0x2bf275,_0x3666e0){var _0x4aafd4=utils[_0x5400('0xd')](_0x2bf275);var _0x100966=_0x5400('0xe')+_0x2bf275+_0x5400('0xf');var _0x3825d5=squel['select']()['field'](_0x5400('0x10'))[_0x5400('0x9')](_0x5400('0x11'))['field'](_0x5400('0x12')+_0x4aafd4)[_0x5400('0xb')](_0x100966,'ui')['left_join']('users','u',_0x5400('0x13'));if(_0x3666e0['length']>0x0){_0x3825d5[_0x5400('0x14')]('ui.'+_0x4aafd4+'\x20IN\x20?',_[_0x5400('0x15')](_0x3666e0,'id'));}return _0x3825d5;}function getInteractionsQuery(_0xa70446){var _0x14988e=utils[_0x5400('0x16')](_0xa70446);var _0x4d3632=utils[_0x5400('0x7')](_0xa70446);var _0x4c2966=utils[_0x5400('0xd')](_0xa70446);return squel[_0x5400('0x8')]()['from'](_0x14988e['interactions'],'i')['left_join'](_0x5400('0x17'),'c',_0x5400('0x18'))[_0x5400('0x19')](_0x5400('0x1a'),'o',_0x5400('0x1b'))['left_join'](_0x14988e[_0x5400('0x1c')],'a',_0x5400('0x1d')+_0x4d3632)[_0x5400('0x19')](_0x14988e['messages'],'me',_0x5400('0x1e')+_0x4c2966+_0x5400('0x1f'))['left_join'](_0x14988e[_0x5400('0x20')],'it',_0x5400('0x21')+_0x4c2966+_0x5400('0x1f'))[_0x5400('0x19')](_0x5400('0xc'),'t',_0x5400('0x22'));}function getSqlClauses(){var _0x33e91e={'body':squel['expr'](),'contact':squel[_0x5400('0x23')](),'default':squel['expr'](),'fields':squel['expr'](),'filter':squel['expr'](),'read':squel[_0x5400('0x23')](),'tags':{'clause':squel[_0x5400('0x23')](),'ids':null},'user':squel['expr']()};return _0x33e91e;}function parseTagParameter(_0x3fd7e){var _0x3aa9d5=squel['expr']();if(_0x3fd7e){var _0x4f8c37=utils[_0x5400('0x24')](_0x3fd7e);_0x4f8c37[_0x5400('0x25')](function(_0x2fc596){_0x3aa9d5['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x2fc596+',%');});}return _0x3aa9d5;}function parseReadParameter(_0x34e7e0){var _0x22ab67='';if(_0x34e7e0){_0x22ab67=_0x5400('0x26');if(_0x34e7e0==='1'){_0x22ab67=_0x22ab67[_0x5400('0x27')](_0x5400('0x28'),'=');}else{_0x22ab67=_0x22ab67[_0x5400('0x27')](_0x5400('0x28'),'>');}}return _0x22ab67;}function parseSearchFilter(_0x3bea46,_0x5e3f88){var _0x491f13=squel[_0x5400('0x23')]();if(_0x5e3f88){var _0x42e483=_0x5e3f88[_0x5400('0x27')]('\x5c','\x5c\x5c')[_0x5400('0x27')](/'/g,'\x27\x27');if(qs[_0x5400('0x29')](_0x42e483)){_0x491f13['or'](_0x5400('0x2a'),_0x42e483+'%');switch(_0x3bea46){case'sms':case'whatsapp':_0x491f13['or'](_0x5400('0x2b'),_0x42e483+'%');break;case _0x5400('0x2c'):_0x491f13['or'](_0x5400('0x2d'),_0x42e483+'%');break;case'openchannel':_0x491f13['or'](_0x5400('0x2e'),_0x42e483+'%');break;case'mail':_0x491f13['or'](_0x5400('0x2f'),qs[_0x5400('0x30')](_0x42e483,!![]))['or'](_0x5400('0x31'),qs['getFullTextValue'](_0x42e483));break;}}else if(_0x3bea46===_0x5400('0x32')&&qs[_0x5400('0x33')](_0x42e483)){_0x491f13['or']('c.email\x20LIKE\x20?',_0x42e483+'%');}else{if(_0x3bea46==='mail'){_0x491f13['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x42e483,!![]))['or'](_0x5400('0x31'),qs[_0x5400('0x30')](_0x42e483));}else if(_0x3bea46!==_0x5400('0x2c')){_0x491f13['or'](_0x5400('0x34'),qs[_0x5400('0x30')](_0x42e483));}_0x491f13['or'](_0x5400('0x35'),qs[_0x5400('0x30')](_0x42e483,!![]),null);}}return _0x491f13;}function parseAdvancedSearchFilter(_0x27a119,_0x12b620){var _0x4ad46b=getSqlClauses();var _0x471fe4=as[_0x5400('0x36')](_0x27a119);var _0x1d410a=_0x471fe4[_0x5400('0x37')];for(var _0x77ec0=0x0;_0x77ec0<_0x471fe4[_0x5400('0x38')][_0x5400('0x39')];_0x77ec0++){var _0x359ab2=_0x471fe4['conditions'][_0x77ec0];var _0x216fce='i';var _0x4d47bb=_[_0x5400('0x3a')](_0x12b620,[_0x5400('0xa'),_0x359ab2[_0x5400('0x9')]]);if(_0x4d47bb){var _0x26ea68=as[_0x5400('0x3b')](_0x216fce,_0x4d47bb[_0x5400('0x3c')],_0x359ab2);_0x4ad46b[_0x5400('0x3d')][_0x1d410a](_0x26ea68[_0x5400('0x3e')],_0x26ea68[_0x5400('0x3f')]['start'],_0x26ea68[_0x5400('0x3f')]['end']);}else{switch(_0x359ab2['field']){case'unreadMessages':var _0x596125=parseReadParameter(_0x359ab2[_0x5400('0x3f')]);_0x4ad46b[_0x5400('0x40')]['and'](_0x596125);break;case _0x5400('0x41'):if(_0x359ab2[_0x5400('0x42')]==='$substring'){if(_0x359ab2[_0x5400('0x3f')][_0x5400('0x43')]('\x20')[_0x5400('0x39')]>0x1){_0x4ad46b[_0x5400('0x44')][_0x1d410a]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x5400('0x30')](_0x359ab2[_0x5400('0x3f')],!![]),null);}else{var _0x2876fc='%'+_0x359ab2[_0x5400('0x3f')]+'%';_0x4ad46b[_0x5400('0x44')][_0x1d410a](_0x5400('0x45'),_0x2876fc,_0x2876fc,_0x2876fc);}}else{_0x4d47bb=_[_0x5400('0x3a')](_0x12b620,[_0x5400('0xa'),_0x5400('0x46')]);_0x359ab2['field']='ContactId';_0x26ea68=as['buildExpression'](_0x216fce,_0x4d47bb['type'],_0x359ab2);_0x4ad46b[_0x5400('0x44')][_0x1d410a](_0x26ea68[_0x5400('0x3e')],_0x26ea68[_0x5400('0x3f')][_0x5400('0x47')],_0x26ea68['value'][_0x5400('0x48')]);}break;case _0x5400('0x49'):var _0x1989ac=_0x359ab2[_0x5400('0x3f')][_0x5400('0x43')](',')[_0x5400('0x15')](function(_0x4f2be2){return Number(_0x4f2be2);});var _0x53727d=parseTagParameter(_0x1989ac);_0x4ad46b['tags'][_0x5400('0x4a')][_0x5400('0x4b')](_0x53727d);_0x4ad46b[_0x5400('0x4c')]['ids']=_0x1989ac;break;case _0x5400('0x4d'):if(_0x359ab2[_0x5400('0x42')]===_0x5400('0x4e')){_0x4ad46b[_0x5400('0x4f')][_0x1d410a](_0x5400('0x50'),'%'+_0x359ab2[_0x5400('0x3f')]+'%',null);}else{_0x4d47bb=_[_0x5400('0x3a')](_0x12b620,[_0x5400('0xa'),_0x5400('0x51')]);_0x359ab2['field']='UserId';_0x26ea68=as[_0x5400('0x3b')](_0x216fce,_0x4d47bb[_0x5400('0x3c')],_0x359ab2);_0x4ad46b[_0x5400('0x4f')][_0x1d410a](_0x26ea68[_0x5400('0x3e')],_0x26ea68['value'][_0x5400('0x47')],_0x26ea68[_0x5400('0x3f')][_0x5400('0x48')]);}break;case _0x5400('0x52'):case _0x5400('0x53'):_0x26ea68=as[_0x5400('0x3b')]('me',null,_0x359ab2);_0x4ad46b[_0x5400('0x52')][_0x1d410a](_0x26ea68['text'],_0x26ea68['value']['start'],_0x26ea68[_0x5400('0x3f')][_0x5400('0x48')]);break;}}}return _0x4ad46b;}function parseModelFields(_0x4874ff,_0x17dfd8,_0x1070c3){var _0x2707f7=utils[_0x5400('0x7')](_0x4874ff);var _0xcec46d=squel[_0x5400('0x23')]();var _0x31a74a=_(_0x17dfd8)[_0x5400('0x54')]()[_0x5400('0x15')](function(_0x445cdd){return _[_0x5400('0x55')](_0x1070c3,[_0x5400('0xa'),_0x445cdd])?_0x445cdd:undefined;})[_0x5400('0x56')]()[_0x5400('0x3f')]();if(_0x31a74a[_0x5400('0x39')]>0x0){_0x31a74a[_0x5400('0x25')](function(_0x43484b){if(_0x43484b===_0x2707f7){_0xcec46d[_0x5400('0x4b')]('i.'+_0x2707f7+_0x5400('0x57'),[]['concat'](_0x17dfd8[_0x43484b]));}else if(_0x43484b===_0x5400('0x58')){var _0x119ac3=JSON[_0x5400('0x59')](_0x17dfd8[_0x43484b])[_0x5400('0x5a')];var _0x52c0a6=JSON[_0x5400('0x59')](_0x17dfd8[_0x43484b])[_0x5400('0x5b')];_0xcec46d[_0x5400('0x4b')](_0x5400('0x5c'),_0x119ac3,_0x52c0a6);}else{if(_0x17dfd8[_0x43484b]===_0x5400('0x5d')){_0xcec46d[_0x5400('0x4b')]('i.'+_0x43484b+_0x5400('0x5e'));}else{_0xcec46d[_0x5400('0x4b')]('i.'+_0x43484b+_0x5400('0x5f'),_0x17dfd8[_0x43484b]);}}});}return _0xcec46d;}function parseQueryParameters(_0xb2b69e,_0x103d14,_0x5c3eec){var _0x500039=getSqlClauses();return Promise[_0x5400('0x60')]()[_0x5400('0x61')](function(){return parseModelFields(_0xb2b69e,_0x103d14,_0x5c3eec);})['then'](function(_0x316fd3){_0x500039[_0x5400('0x62')][_0x5400('0x4b')](_0x316fd3);return parseReadParameter(_0x103d14['read']);})[_0x5400('0x61')](function(_0x47c749){_0x500039['read']['and'](_0x47c749);return parseTagParameter(_0x103d14[_0x5400('0x63')]);})[_0x5400('0x61')](function(_0x2e5612){_0x500039['tags'][_0x5400('0x4a')]['and'](_0x2e5612);return parseSearchFilter(_0xb2b69e,_0x103d14['filter']);})[_0x5400('0x61')](function(_0x2c0f63){_0x500039[_0x5400('0x64')]=_0x2c0f63;return _0x500039;});}function checkAccountsRestrictions(_0x177f3a,_0x23a600,_0x4e8252){var _0x3e119f=utils[_0x5400('0x7')](_0x177f3a);var _0x3e9f83=_0x5400('0x65')+_[_0x5400('0x66')](_0x177f3a)+(_0x177f3a==='chat'?_0x5400('0x67'):_0x5400('0x68'));var _0x2f058c=squel[_0x5400('0x23')]();return Promise[_0x5400('0x60')]()[_0x5400('0x61')](function(){if(_0x4e8252[_0x5400('0x69')]&&_0x23a600[_0x5400('0x6a')]===_0x5400('0x6b')){return _0x23a600[_0x3e9f83]({'attributes':['id'],'raw':!![]});}})[_0x5400('0x61')](function(_0x2daf53){if(_0x2daf53){if(_0x2daf53[_0x5400('0x39')]===0x0){_0x2f058c['and']('i.'+_0x3e119f+_0x5400('0x5e'));}else{_0x2f058c[_0x5400('0x4b')]('i.'+_0x3e119f+_0x5400('0x57'),_['map'](_0x2daf53,'id'));}}else if(!_0x4e8252[_0x3e119f]){_0x2f058c['and']('i.'+_0x3e119f+_0x5400('0x6c'));}})[_0x5400('0x61')](function(){return _0x2f058c;});}function getClosedOrderClause(_0x524ec2,_0x3af0b7){var _0x209c88='';var _0x3cc67f=[_0x5400('0x6d'),_0x5400('0x6e'),_0x5400('0x6f')];if(_0x524ec2===_0x5400('0x32')){_0x3cc67f[_0x5400('0x70')](_0x5400('0x71'));}if(_0x3af0b7[_0x5400('0x72')]==='0'&&_0x524ec2==='mail'){_0x209c88='i.substatus';}else{if(_0x3af0b7[_0x5400('0x72')]==='1'){_0x3cc67f[_0x5400('0x73')]();}_0x209c88=_0x5400('0x74')+_0x3cc67f[_0x5400('0x75')](',\x20')+')';}return _0x209c88;}function getFilteredInteractions(_0x32bdce,_0x246e9c,_0x18b6d0,_0x343aee){var _0x3fffff=utils['getInteractionFK'](_0x32bdce);var _0x3c0a99=_[_0x5400('0x66')](_0x32bdce)+_0x5400('0x76');var _0xd558c1=[];var _0x2f0b5f=getTagsQuery();var _0x848a4d={'type':db[_0x5400('0x77')][_0x5400('0x78')][_0x5400('0x79')],'raw':!![]};var _0x1aade0=[];var _0x477159=[];return db[_0x5400('0x7a')][_0x5400('0x7b')](_0x2f0b5f[_0x5400('0x7c')](),_0x848a4d)[_0x5400('0x61')](function(_0x1ee588){_0xd558c1=_[_0x5400('0x7d')](_0x1ee588,'id');_0x848a4d=_[_0x5400('0x7e')](_0x848a4d,{'model':db[_0x3c0a99],'mapToModel':!![],'nest':!![]});if(_0x18b6d0['fields']){_0x343aee[_0x5400('0x7f')][_0x5400('0x25')](function(_0xa4ea59){_0x246e9c[_0x5400('0x9')]('i.'+_0xa4ea59);});}else{_0x246e9c['field'](_0x5400('0x80'),_0x5400('0x81'));_0x246e9c[_0x5400('0x9')](_0x5400('0x82'),_0x5400('0x83'));_0x246e9c[_0x5400('0x9')](_0x5400('0x84'),_0x5400('0x85'));if(_0x32bdce===_0x5400('0x32')){_0x246e9c['field'](_0x5400('0x86'),_0x5400('0x87'));_0x246e9c[_0x5400('0x9')](_0x5400('0x88'),_0x5400('0x89'));_0x246e9c['field'](_0x5400('0x8a'));_0x246e9c[_0x5400('0x9')](_0x5400('0x8b'));_0x246e9c[_0x5400('0x9')](_0x5400('0x8c'));_0x246e9c[_0x5400('0x9')](_0x5400('0x8d'));_0x246e9c[_0x5400('0x9')](_0x5400('0x8e'));_0x246e9c[_0x5400('0x9')]('i.attach');_0x246e9c[_0x5400('0x9')](_0x5400('0x8f'));_0x246e9c[_0x5400('0x9')](_0x5400('0x90'));_0x246e9c[_0x5400('0x9')](_0x5400('0x91'));_0x246e9c[_0x5400('0x9')]('i.disposition');_0x246e9c[_0x5400('0x9')]('i.secondDisposition');_0x246e9c[_0x5400('0x9')](_0x5400('0x6d'));_0x246e9c[_0x5400('0x9')](_0x5400('0x71'));_0x246e9c['field']('i.to');_0x246e9c[_0x5400('0x9')](_0x5400('0x92'));_0x246e9c[_0x5400('0x9')](_0x5400('0x93'));_0x246e9c[_0x5400('0x9')](_0x5400('0x94'));}else if(_0x32bdce==='openchannel'){_0x246e9c[_0x5400('0x9')](_0x5400('0x95'),_0x5400('0x89'));}else{_0x246e9c[_0x5400('0x9')](_0x5400('0x96'),_0x5400('0x89'));}if(_0x32bdce!==_0x5400('0x32')){_0x246e9c['field'](_0x5400('0x97'));}_0x246e9c['field']('c.firstName','Contact.firstName');_0x246e9c['field'](_0x5400('0x98'),_0x5400('0x99'));_0x246e9c[_0x5400('0x9')](_0x5400('0x9a'),'Contact.email');_0x246e9c[_0x5400('0x9')](_0x5400('0x9b'),'Contact.phone');_0x246e9c[_0x5400('0x9')](_0x5400('0x9c'),_0x5400('0x9d'));_0x246e9c[_0x5400('0x9')](_0x5400('0x9e'),_0x5400('0x9f'));_0x246e9c[_0x5400('0x9')](_0x5400('0xa0'),_0x5400('0xa1'));_0x246e9c['field'](_0x5400('0xa2'),'Owner.internal');_0x246e9c[_0x5400('0x9')](_0x5400('0xa3'),_0x5400('0xa4'));}if(_0x343aee[_0x5400('0xa5')]){_0x246e9c[_0x5400('0xa5')](_0x343aee['limit']);}if(_0x343aee[_0x5400('0xa6')]){_0x246e9c[_0x5400('0xa6')](_0x343aee[_0x5400('0xa6')]);}return db['sequelize']['query'](_0x246e9c['toString'](),_0x848a4d);})[_0x5400('0x61')](function(_0x12a0d5){_0x1aade0=_0x12a0d5;var _0x1ec92c=getUsersQuery(_0x32bdce,_0x1aade0);return db[_0x5400('0x7a')]['query'](_0x1ec92c[_0x5400('0x7c')](),_0x848a4d);})[_0x5400('0x61')](function(_0x554557){_0x477159=_[_0x5400('0xa7')](_0x554557,_0x3fffff);if(_0x32bdce===_0x5400('0x32')){return db['Setting'][_0x5400('0xa8')]({'attributes':[_0x5400('0xa9')],'raw':!![]});}})[_0x5400('0x61')](function(_0x202848){var _0x4b9526=_0x202848?_0x202848['enableEmailPreview']:undefined;var _0x127ffa=_0x1aade0[_0x5400('0x15')](function(_0x128339){return updateInteraction(_0x128339,_0xd558c1,_0x477159,_0x4b9526);});return Promise[_0x5400('0xaa')](_0x127ffa);});}function countFilteredInteractions(_0x5bba66,_0x1f713e){var _0x16fa1d=_0x5bba66[_0x5400('0xab')]();_0x16fa1d[_0x5400('0x9')]('COUNT(*)');_0x16fa1d['field'](_0x5400('0x80'),'unreadMessages');var _0x16aa60=utils[_0x5400('0x24')](_0x1f713e);if(!_['isEmpty'](_0x16aa60)){_0x16fa1d[_0x5400('0x14')]('t.id\x20IN\x20?',_0x16aa60);}var _0x21c914={'type':db['Sequelize'][_0x5400('0x78')][_0x5400('0x79')],'raw':!![]};return db[_0x5400('0x7a')][_0x5400('0x7b')](_0x16fa1d[_0x5400('0x7c')](),_0x21c914);}module[_0x5400('0xac')]={'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