// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa460=['Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','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.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','i.subject','i.thirdDisposition','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','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','length','where','map','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','{OPERATOR}','replace','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','mail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','buildExpression','type','default','text','value','start','read','and','Contact','operator','split','contact','find','ContactId','end','Tag','tags','ids','User','$substring','user','UserId','body','plainBody','some','compact','\x20IN\x20?','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','clause','filter','get','capitalize','chat','Websites','Accounts','i.secondDisposition','i.disposition','unshift','i.substatus','closed','CONCAT_WS(\x27\x27,\x20','join'];(function(_0x51ebad,_0x1e546f){var _0x20f39f=function(_0x4e26e4){while(--_0x4e26e4){_0x51ebad['push'](_0x51ebad['shift']());}};_0x20f39f(++_0x1e546f);}(_0xa460,0xe4));var _0x0a46=function(_0x3dc538,_0x4f7702){_0x3dc538=_0x3dc538-0x0;var _0x72c2fd=_0xa460[_0x3dc538];return _0x72c2fd;};'use strict';var _=require(_0x0a46('0x0'));var squel=require(_0x0a46('0x1'));var as=require(_0x0a46('0x2'));var qs=require(_0x0a46('0x3'));var updateInteraction=require(_0x0a46('0x4'))[_0x0a46('0x5')];var utils=require(_0x0a46('0x6'));var db=require(_0x0a46('0x7'))['db'];function skipInteractionsQuery(_0x352547,_0x160da8,_0x48e5aa){var _0x10b1dc=![];var _0x104127=utils[_0x0a46('0x8')](_0x352547);if(_0x160da8[_0x0a46('0x9')]===_0x0a46('0xa')&&!_0x48e5aa[_0x0a46('0xb')]&&!_0x48e5aa[_0x104127]){_0x10b1dc=!![];}return _0x10b1dc;}function getTagsQuery(){return squel[_0x0a46('0xc')]()['field']('id')[_0x0a46('0xd')](_0x0a46('0xe'))['field'](_0x0a46('0xf'))[_0x0a46('0x10')](_0x0a46('0x11'));}function getUsersQuery(_0x2a2574,_0x40457e){var _0x8e454d=utils[_0x0a46('0x12')](_0x2a2574);var _0xf6f23e=_0x0a46('0x13')+_0x2a2574+_0x0a46('0x14');var _0x4a3ab8=squel[_0x0a46('0xc')]()[_0x0a46('0xd')](_0x0a46('0x15'))['field'](_0x0a46('0x16'))[_0x0a46('0xd')](_0x0a46('0x17')+_0x8e454d)[_0x0a46('0x10')](_0xf6f23e,'ui')[_0x0a46('0x18')](_0x0a46('0x19'),'u',_0x0a46('0x1a'));if(_0x40457e[_0x0a46('0x1b')]>0x0){_0x4a3ab8[_0x0a46('0x1c')](_0x0a46('0x17')+_0x8e454d+'\x20IN\x20?',_[_0x0a46('0x1d')](_0x40457e,'id'));}return _0x4a3ab8;}function getInteractionsQuery(_0x85d4d2){var _0x10ecb1=utils[_0x0a46('0x1e')](_0x85d4d2);var _0x2a0c5b=utils[_0x0a46('0x8')](_0x85d4d2);var _0x35b9a2=utils['getInteractionFK'](_0x85d4d2);return squel[_0x0a46('0xc')]()[_0x0a46('0x10')](_0x10ecb1[_0x0a46('0x1f')],'i')[_0x0a46('0x18')](_0x0a46('0x20'),'c',_0x0a46('0x21'))[_0x0a46('0x18')](_0x0a46('0x19'),'o',_0x0a46('0x22'))['left_join'](_0x10ecb1[_0x0a46('0x23')],'a',_0x0a46('0x24')+_0x2a0c5b)[_0x0a46('0x18')](_0x10ecb1[_0x0a46('0x25')],'me',_0x0a46('0x26')+_0x35b9a2+_0x0a46('0x27'))['left_join'](_0x10ecb1['interactionsTags'],'it',_0x0a46('0x28')+_0x35b9a2+_0x0a46('0x27'))[_0x0a46('0x18')](_0x0a46('0x11'),'t',_0x0a46('0x29'));}function getSqlClauses(){var _0x242ced={'body':squel[_0x0a46('0x2a')](),'contact':squel[_0x0a46('0x2a')](),'default':squel[_0x0a46('0x2a')](),'fields':squel[_0x0a46('0x2a')](),'filter':squel['expr'](),'read':squel[_0x0a46('0x2a')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel['expr']()};return _0x242ced;}function parseTagParameter(_0x3bc952){var _0x26c509=squel[_0x0a46('0x2a')]();if(_0x3bc952){var _0x3fc827=utils[_0x0a46('0x2b')](_0x3bc952);_0x3fc827[_0x0a46('0x2c')](function(_0x101232){_0x26c509['or'](_0x0a46('0x2d'),'%,'+_0x101232+',%');});}return _0x26c509;}function parseReadParameter(_0x45ecb6){var _0x1796e6='';if(_0x45ecb6){_0x1796e6='unreadMessages\x20{OPERATOR}\x200';if(_0x45ecb6==='1'){_0x1796e6=_0x1796e6['replace'](_0x0a46('0x2e'),'=');}else{_0x1796e6=_0x1796e6['replace'](_0x0a46('0x2e'),'>');}}return _0x1796e6;}function parseSearchFilter(_0x34b797,_0xaf843c){var _0x36ed22=squel['expr']();if(_0xaf843c){var _0x110d66=_0xaf843c[_0x0a46('0x2f')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');var _0x24098b=qs[_0x0a46('0x30')](_0x110d66);if(qs[_0x0a46('0x31')](_0x110d66)){_0x36ed22['or'](_0x0a46('0x32'),_0x24098b+'%');if([_0x0a46('0x33'),_0x0a46('0x34')][_0x0a46('0x35')](_0x34b797)){_0x36ed22['or'](_0x0a46('0x36'),_0x24098b+'%');}else if(_0x34b797===_0x0a46('0x37')){_0x36ed22['or'](_0x0a46('0x38'),_0x24098b+'%');}else if(_0x34b797===_0x0a46('0x39')){_0x36ed22['or']('i.from\x20LIKE\x20?',_0x24098b+'%');}}else if(_0x34b797===_0x0a46('0x3a')&&qs['isEmail'](_0x110d66)){_0x36ed22['or'](_0x0a46('0x3b'),_0x24098b+'%');}else{if(_0x34b797==='mail'){_0x36ed22['or'](_0x0a46('0x3c'),qs['getFullTextValue'](_0x110d66,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x0a46('0x3d')](_0x110d66));}else if(_0x34b797!==_0x0a46('0x37')){_0x36ed22['or'](_0x0a46('0x3e'),qs['getFullTextValue'](_0x110d66));}_0x36ed22['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x0a46('0x3d')](_0x110d66,!![]),null);}}return _0x36ed22;}function parseAdvancedSearchFilter(_0x1d02dd,_0x13c385){var _0x203f5d=getSqlClauses();var _0x18d96b=as[_0x0a46('0x3f')](_0x1d02dd);var _0x55050e=_0x18d96b[_0x0a46('0x40')];for(var _0x64a364=0x0;_0x64a364<_0x18d96b[_0x0a46('0x41')][_0x0a46('0x1b')];_0x64a364++){var _0x2b8ce3=_0x18d96b[_0x0a46('0x41')][_0x64a364];var _0xd8728a='i';var _0x440e27=_['find'](_0x13c385,[_0x0a46('0xe'),_0x2b8ce3[_0x0a46('0xd')]]);if(_0x440e27){var _0x347453=as[_0x0a46('0x42')](_0xd8728a,_0x440e27[_0x0a46('0x43')],_0x2b8ce3);_0x203f5d[_0x0a46('0x44')][_0x55050e](_0x347453[_0x0a46('0x45')],_0x347453[_0x0a46('0x46')][_0x0a46('0x47')],_0x347453['value']['end']);}else{switch(_0x2b8ce3[_0x0a46('0xd')]){case'unreadMessages':var _0x2ed64a=parseReadParameter(_0x2b8ce3[_0x0a46('0x46')]);_0x203f5d[_0x0a46('0x48')][_0x0a46('0x49')](_0x2ed64a);break;case _0x0a46('0x4a'):if(_0x2b8ce3[_0x0a46('0x4b')]==='$substring'){if(_0x2b8ce3[_0x0a46('0x46')][_0x0a46('0x4c')]('\x20')[_0x0a46('0x1b')]>0x1){_0x203f5d[_0x0a46('0x4d')][_0x55050e]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x2b8ce3[_0x0a46('0x46')],!![]),null);}else{var _0x189e99='%'+_0x2b8ce3[_0x0a46('0x46')]+'%';_0x203f5d['contact'][_0x55050e]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x189e99,_0x189e99,_0x189e99);}}else{_0x440e27=_[_0x0a46('0x4e')](_0x13c385,[_0x0a46('0xe'),'ContactId']);_0x2b8ce3[_0x0a46('0xd')]=_0x0a46('0x4f');_0x347453=as[_0x0a46('0x42')](_0xd8728a,_0x440e27[_0x0a46('0x43')],_0x2b8ce3);_0x203f5d['contact'][_0x55050e](_0x347453['text'],_0x347453[_0x0a46('0x46')][_0x0a46('0x47')],_0x347453['value'][_0x0a46('0x50')]);}break;case _0x0a46('0x51'):var _0x3d502a=_0x2b8ce3[_0x0a46('0x46')]['split'](',')[_0x0a46('0x1d')](function(_0x268700){return Number(_0x268700);});var _0x397454=parseTagParameter(_0x3d502a);_0x203f5d[_0x0a46('0x52')]['clause']['and'](_0x397454);_0x203f5d[_0x0a46('0x52')][_0x0a46('0x53')]=_0x3d502a;break;case _0x0a46('0x54'):if(_0x2b8ce3[_0x0a46('0x4b')]===_0x0a46('0x55')){_0x203f5d[_0x0a46('0x56')][_0x55050e]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x2b8ce3['value']+'%',null);}else{_0x440e27=_[_0x0a46('0x4e')](_0x13c385,[_0x0a46('0xe'),_0x0a46('0x57')]);_0x2b8ce3['field']='UserId';_0x347453=as[_0x0a46('0x42')](_0xd8728a,_0x440e27[_0x0a46('0x43')],_0x2b8ce3);_0x203f5d['user'][_0x55050e](_0x347453['text'],_0x347453[_0x0a46('0x46')][_0x0a46('0x47')],_0x347453[_0x0a46('0x46')]['end']);}break;case _0x0a46('0x58'):case _0x0a46('0x59'):_0x347453=as[_0x0a46('0x42')]('me',null,_0x2b8ce3);_0x203f5d[_0x0a46('0x58')][_0x55050e](_0x347453['text'],_0x347453[_0x0a46('0x46')][_0x0a46('0x47')],_0x347453[_0x0a46('0x46')]['end']);break;}}}return _0x203f5d;}function parseModelFields(_0x3e9e9a,_0x4efc52,_0x19c207){var _0x33ab3a=utils[_0x0a46('0x8')](_0x3e9e9a);var _0xb9b6bb=squel[_0x0a46('0x2a')]();var _0x4421bb=_(_0x4efc52)['keys']()['map'](function(_0x2bb9b6){return _[_0x0a46('0x5a')](_0x19c207,['name',_0x2bb9b6])?_0x2bb9b6:undefined;})[_0x0a46('0x5b')]()['value']();if(_0x4421bb['length']>0x0){_0x4421bb[_0x0a46('0x2c')](function(_0x243db3){if(_0x243db3===_0x33ab3a){_0xb9b6bb[_0x0a46('0x49')]('i.'+_0x33ab3a+_0x0a46('0x5c'),[]['concat'](_0x4efc52[_0x243db3]));}else if(_0x243db3===_0x0a46('0x5d')){var _0x4e70d1=JSON[_0x0a46('0x5e')](_0x4efc52[_0x243db3])[_0x0a46('0x5f')];var _0x7d75d1=JSON['parse'](_0x4efc52[_0x243db3])[_0x0a46('0x60')];_0xb9b6bb[_0x0a46('0x49')](_0x0a46('0x61'),_0x4e70d1,_0x7d75d1);}else{if(_0x4efc52[_0x243db3]==='null'){_0xb9b6bb['and']('i.'+_0x243db3+_0x0a46('0x62'));}else{_0xb9b6bb['and']('i.'+_0x243db3+_0x0a46('0x63'),_0x4efc52[_0x243db3]);}}});}return _0xb9b6bb;}function parseQueryParameters(_0x3d4101,_0x3502df,_0x12d9b1){var _0x1de156=getSqlClauses();return Promise[_0x0a46('0x64')]()[_0x0a46('0x65')](function(){return parseModelFields(_0x3d4101,_0x3502df,_0x12d9b1);})['then'](function(_0x4c12fc){_0x1de156[_0x0a46('0x66')][_0x0a46('0x49')](_0x4c12fc);return parseReadParameter(_0x3502df[_0x0a46('0x48')]);})[_0x0a46('0x65')](function(_0x511c72){_0x1de156[_0x0a46('0x48')][_0x0a46('0x49')](_0x511c72);return parseTagParameter(_0x3502df[_0x0a46('0x67')]);})['then'](function(_0x350fcc){_0x1de156[_0x0a46('0x52')][_0x0a46('0x68')][_0x0a46('0x49')](_0x350fcc);return parseSearchFilter(_0x3d4101,_0x3502df[_0x0a46('0x69')]);})['then'](function(_0x1d1617){_0x1de156['filter']=_0x1d1617;return _0x1de156;});}function checkAccountsRestrictions(_0x2b3c0f,_0x34265a,_0xf57446){var _0x56176b=utils['getAccountFK'](_0x2b3c0f);var _0x2c739b=_0x0a46('0x6a')+_[_0x0a46('0x6b')](_0x2b3c0f)+(_0x2b3c0f===_0x0a46('0x6c')?_0x0a46('0x6d'):_0x0a46('0x6e'));var _0x29ab85=squel[_0x0a46('0x2a')]();return Promise[_0x0a46('0x64')]()['then'](function(){if(_0xf57446[_0x0a46('0xb')]&&_0x34265a[_0x0a46('0x9')]==='agent'){return _0x34265a[_0x2c739b]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x11609f){if(_0x11609f){if(_0x11609f[_0x0a46('0x1b')]===0x0){_0x29ab85['and']('i.'+_0x56176b+_0x0a46('0x62'));}else{_0x29ab85[_0x0a46('0x49')]('i.'+_0x56176b+_0x0a46('0x5c'),_['map'](_0x11609f,'id'));}}else if(!_0xf57446[_0x56176b]){_0x29ab85[_0x0a46('0x49')]('i.'+_0x56176b+'\x20IS\x20NOT\x20NULL');}})[_0x0a46('0x65')](function(){return _0x29ab85;});}function getClosedOrderClause(_0x354291,_0x56cbdb){var _0x31ac16='';var _0x14c61e=['i.thirdDisposition',_0x0a46('0x6f'),_0x0a46('0x70')];if(_0x354291===_0x0a46('0x3a')){_0x14c61e[_0x0a46('0x71')](_0x0a46('0x72'));}if(_0x56cbdb['closed']==='0'&&_0x354291===_0x0a46('0x3a')){_0x31ac16='i.substatus';}else{if(_0x56cbdb[_0x0a46('0x73')]==='1'){_0x14c61e['shift']();}_0x31ac16=_0x0a46('0x74')+_0x14c61e[_0x0a46('0x75')](',\x20')+')';}return _0x31ac16;}function getFilteredInteractions(_0x2f65ac,_0x3839c9,_0x49d7d3,_0x16ed73){var _0x38d606=utils[_0x0a46('0x12')](_0x2f65ac);var _0x1f65d0=_[_0x0a46('0x6b')](_0x2f65ac)+_0x0a46('0x76');var _0x54de2a=[];var _0x31e2e5=getTagsQuery();var _0xe536b9={'type':db[_0x0a46('0x77')][_0x0a46('0x78')][_0x0a46('0x79')],'raw':!![]};var _0x381588=[];var _0x4abf7d=[];return db[_0x0a46('0x7a')][_0x0a46('0x7b')](_0x31e2e5[_0x0a46('0x7c')](),_0xe536b9)[_0x0a46('0x65')](function(_0x403abe){_0x54de2a=_['keyBy'](_0x403abe,'id');_0xe536b9=_[_0x0a46('0x7d')](_0xe536b9,{'model':db[_0x1f65d0],'mapToModel':!![],'nest':!![]});if(_0x49d7d3[_0x0a46('0x66')]){_0x16ed73[_0x0a46('0x7e')][_0x0a46('0x2c')](function(_0x39e960){_0x3839c9['field']('i.'+_0x39e960);});}else{_0x3839c9[_0x0a46('0xd')](_0x0a46('0x7f'),_0x0a46('0x80'));_0x3839c9[_0x0a46('0xd')]('a.key',_0x0a46('0x81'));_0x3839c9['field'](_0x0a46('0x82'),_0x0a46('0x83'));if(_0x2f65ac===_0x0a46('0x3a')){_0x3839c9[_0x0a46('0xd')]('a.email',_0x0a46('0x84'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x85'),_0x0a46('0x86'));_0x3839c9['field']('i.id');_0x3839c9[_0x0a46('0xd')](_0x0a46('0x87'));_0x3839c9['field'](_0x0a46('0x88'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x89'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x8a'));_0x3839c9['field'](_0x0a46('0x8b'));_0x3839c9[_0x0a46('0xd')]('i.lastMsgAt');_0x3839c9[_0x0a46('0xd')](_0x0a46('0x8c'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x8d'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x70'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x6f'));_0x3839c9['field'](_0x0a46('0x8e'));_0x3839c9[_0x0a46('0xd')]('i.substatus');_0x3839c9['field'](_0x0a46('0x8f'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x90'));_0x3839c9['field'](_0x0a46('0x91'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x92'));}else if(_0x2f65ac===_0x0a46('0x39')){_0x3839c9[_0x0a46('0xd')](_0x0a46('0x93'),'contactName');}else{_0x3839c9[_0x0a46('0xd')](_0x0a46('0x94'),_0x0a46('0x86'));}if(_0x2f65ac!=='mail'){_0x3839c9['field'](_0x0a46('0x95'));}_0x3839c9['field'](_0x0a46('0x96'),_0x0a46('0x97'));_0x3839c9['field'](_0x0a46('0x98'),_0x0a46('0x99'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x9a'),_0x0a46('0x9b'));_0x3839c9['field'](_0x0a46('0x9c'),_0x0a46('0x9d'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0x9e'),_0x0a46('0x9f'));_0x3839c9[_0x0a46('0xd')]('c.fax','Contact.fax');_0x3839c9[_0x0a46('0xd')]('o.fullname',_0x0a46('0xa0'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0xa1'),_0x0a46('0xa2'));_0x3839c9[_0x0a46('0xd')](_0x0a46('0xa3'),'TagIds');}if(_0x16ed73['limit']){_0x3839c9[_0x0a46('0xa4')](_0x16ed73['limit']);}if(_0x16ed73['offset']){_0x3839c9['offset'](_0x16ed73[_0x0a46('0xa5')]);}return db[_0x0a46('0x7a')][_0x0a46('0x7b')](_0x3839c9['toString'](),_0xe536b9);})[_0x0a46('0x65')](function(_0xaca27f){_0x381588=_0xaca27f;var _0x51c883=getUsersQuery(_0x2f65ac,_0x381588);return db[_0x0a46('0x7a')][_0x0a46('0x7b')](_0x51c883[_0x0a46('0x7c')](),_0xe536b9);})['then'](function(_0x492c02){_0x4abf7d=_['groupBy'](_0x492c02,_0x38d606);if(_0x2f65ac==='mail'){return db[_0x0a46('0xa6')][_0x0a46('0xa7')]({'attributes':[_0x0a46('0xa8')],'raw':!![]});}})[_0x0a46('0x65')](function(_0x5c7335){var _0x7a33ec=_0x5c7335?_0x5c7335['enableEmailPreview']:undefined;var _0x4a15c0=_0x381588[_0x0a46('0x1d')](function(_0x4322d3){return updateInteraction(_0x4322d3,_0x54de2a,_0x4abf7d,_0x7a33ec);});return Promise[_0x0a46('0xa9')](_0x4a15c0);});}function countFilteredInteractions(_0x40006f,_0x2b3613){var _0x5d7ade=_0x40006f[_0x0a46('0xaa')]();_0x5d7ade[_0x0a46('0xd')](_0x0a46('0xab'));_0x5d7ade[_0x0a46('0xd')](_0x0a46('0x7f'),_0x0a46('0x80'));var _0xf8bd7=utils[_0x0a46('0x2b')](_0x2b3613);if(!_[_0x0a46('0xac')](_0xf8bd7)){_0x5d7ade[_0x0a46('0x1c')]('t.id\x20IN\x20?',_0xf8bd7);}var _0x99e18d={'type':db[_0x0a46('0x77')]['QueryTypes'][_0x0a46('0x79')],'raw':!![]};return db[_0x0a46('0x7a')][_0x0a46('0x7b')](_0x5d7ade[_0x0a46('0x7c')](),_0x99e18d);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0xd4e7=['select','field','name','from','tools_tags','getInteractionFK','_interactions','u.id','u.fullname','left_join','users','u.id\x20=\x20ui.UserId','where','ui.','\x20IN\x20?','map','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','t.id\x20=\x20it.TagId','expr','getSelectedTags','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','isEmail','c.email\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','length','conditions','find','type','start','value','read','and','Contact','split','contact','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','Tag','tags','clause','ids','User','operator','$substring','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','end','body','plainBody','text','keys','some','compact','forEach','createdAt','parse','$gte','$lte','null','\x20IS\x20NULL','\x20=\x20?','then','fields','tag','filter','capitalize','chat','Accounts','resolve','\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)','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','Account.email','contactName','i.createdAt','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.to','i.MailAccountId','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','i.*','Contact.firstName','Contact.lastName','c.email','c.phone','Contact.phone','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','unreadMessages','isEmpty','t.id\x20IN\x20?','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','getAccountFK','role','search'];(function(_0x549278,_0x450754){var _0x1ea9a1=function(_0x2e559d){while(--_0x2e559d){_0x549278['push'](_0x549278['shift']());}};_0x1ea9a1(++_0x450754);}(_0xd4e7,0x9c));var _0x7d4e=function(_0x57bec8,_0x5b886b){_0x57bec8=_0x57bec8-0x0;var _0x20d7cb=_0xd4e7[_0x57bec8];return _0x20d7cb;};'use strict';var _=require(_0x7d4e('0x0'));var squel=require(_0x7d4e('0x1'));var as=require(_0x7d4e('0x2'));var qs=require(_0x7d4e('0x3'));var updateInteraction=require(_0x7d4e('0x4'))[_0x7d4e('0x5')];var utils=require(_0x7d4e('0x6'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x898a29,_0x580d1d,_0x48ace0){var _0x3d5dbc=![];var _0x1b7063=utils[_0x7d4e('0x7')](_0x898a29);if(_0x580d1d[_0x7d4e('0x8')]==='agent'&&!_0x48ace0[_0x7d4e('0x9')]&&!_0x48ace0[_0x1b7063]){_0x3d5dbc=!![];}return _0x3d5dbc;}function getTagsQuery(){return squel[_0x7d4e('0xa')]()[_0x7d4e('0xb')]('id')[_0x7d4e('0xb')](_0x7d4e('0xc'))[_0x7d4e('0xb')]('color')[_0x7d4e('0xd')](_0x7d4e('0xe'));}function getUsersQuery(_0x15f011,_0x213b7d){var _0x4445cc=utils[_0x7d4e('0xf')](_0x15f011);var _0x727d71='user_has_'+_0x15f011+_0x7d4e('0x10');var _0x22ff2a=squel['select']()[_0x7d4e('0xb')](_0x7d4e('0x11'))[_0x7d4e('0xb')](_0x7d4e('0x12'))[_0x7d4e('0xb')]('ui.'+_0x4445cc)[_0x7d4e('0xd')](_0x727d71,'ui')[_0x7d4e('0x13')](_0x7d4e('0x14'),'u',_0x7d4e('0x15'));if(_0x213b7d['length']>0x0){_0x22ff2a[_0x7d4e('0x16')](_0x7d4e('0x17')+_0x4445cc+_0x7d4e('0x18'),_[_0x7d4e('0x19')](_0x213b7d,'id'));}return _0x22ff2a;}function getInteractionsQuery(_0x171843){var _0x53c93f=utils[_0x7d4e('0x1a')](_0x171843);var _0x465682=utils[_0x7d4e('0x7')](_0x171843);var _0x8fd540=utils[_0x7d4e('0xf')](_0x171843);return squel['select']()['from'](_0x53c93f[_0x7d4e('0x1b')],'i')[_0x7d4e('0x13')](_0x7d4e('0x1c'),'c',_0x7d4e('0x1d'))['left_join']('users','o',_0x7d4e('0x1e'))[_0x7d4e('0x13')](_0x53c93f['accounts'],'a',_0x7d4e('0x1f')+_0x465682)[_0x7d4e('0x13')](_0x53c93f[_0x7d4e('0x20')],'me',_0x7d4e('0x21')+_0x8fd540+_0x7d4e('0x22'))[_0x7d4e('0x13')](_0x53c93f[_0x7d4e('0x23')],'it','it.'+_0x8fd540+_0x7d4e('0x22'))[_0x7d4e('0x13')](_0x7d4e('0xe'),'t',_0x7d4e('0x24'));}function getSqlClauses(){var _0x43372e={'body':squel[_0x7d4e('0x25')](),'contact':squel['expr'](),'default':squel[_0x7d4e('0x25')](),'fields':squel[_0x7d4e('0x25')](),'filter':squel[_0x7d4e('0x25')](),'read':squel[_0x7d4e('0x25')](),'tags':{'clause':squel[_0x7d4e('0x25')](),'ids':null},'user':squel[_0x7d4e('0x25')]()};return _0x43372e;}function parseTagParameter(_0x40de31){var _0x11a923=squel[_0x7d4e('0x25')]();if(_0x40de31){var _0xf3f80a=utils[_0x7d4e('0x26')](_0x40de31);_0xf3f80a['forEach'](function(_0x4bbb0d){_0x11a923['or'](_0x7d4e('0x27'),'%,'+_0x4bbb0d+',%');});}return _0x11a923;}function parseReadParameter(_0x11dfc4){var _0x3c119d='';if(_0x11dfc4){_0x3c119d='unreadMessages\x20{OPERATOR}\x200';if(_0x11dfc4==='1'){_0x3c119d=_0x3c119d[_0x7d4e('0x28')](_0x7d4e('0x29'),'=');}else{_0x3c119d=_0x3c119d[_0x7d4e('0x28')](_0x7d4e('0x29'),'>');}}return _0x3c119d;}function parseSearchFilter(_0x307e92,_0x46440d){var _0x93b851=squel['expr']();if(_0x46440d){var _0x4a3576=_0x46440d['replace']('\x5c','\x5c\x5c')[_0x7d4e('0x28')](/'/g,'\x27\x27');var _0x53cee5=qs[_0x7d4e('0x2a')](_0x4a3576);if(qs[_0x7d4e('0x2b')](_0x4a3576)){_0x93b851['or'](_0x7d4e('0x2c'),_0x53cee5+'%');if([_0x7d4e('0x2d'),_0x7d4e('0x2e')][_0x7d4e('0x2f')](_0x307e92)){_0x93b851['or'](_0x7d4e('0x30'),_0x53cee5+'%');}else if(_0x307e92===_0x7d4e('0x31')){_0x93b851['or'](_0x7d4e('0x32'),_0x53cee5+'%');}else if(_0x307e92===_0x7d4e('0x33')){_0x93b851['or']('i.from\x20LIKE\x20?',_0x53cee5+'%');}}else if(_0x307e92==='mail'&&qs[_0x7d4e('0x34')](_0x4a3576)){_0x93b851['or'](_0x7d4e('0x35'),_0x53cee5+'%');}else{if(_0x307e92===_0x7d4e('0x36')){_0x93b851['or'](_0x7d4e('0x37'),qs['getFullTextValue'](_0x4a3576,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x7d4e('0x38')](_0x4a3576));}else if(_0x307e92!==_0x7d4e('0x31')){_0x93b851['or'](_0x7d4e('0x39'),qs['getFullTextValue'](_0x4a3576));}_0x93b851['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x7d4e('0x38')](_0x4a3576,!![]),null);}}return _0x93b851;}function parseAdvancedSearchFilter(_0x2469f1,_0x144905){var _0x12c5c8=getSqlClauses();var _0x158c14=as[_0x7d4e('0x3a')](_0x2469f1);var _0x5ba336=_0x158c14[_0x7d4e('0x3b')];for(var _0x24c5ba=0x0;_0x24c5ba<_0x158c14['conditions'][_0x7d4e('0x3c')];_0x24c5ba++){var _0x19dbc2=_0x158c14[_0x7d4e('0x3d')][_0x24c5ba];var _0x2d08a1='i';var _0x17ccff=_[_0x7d4e('0x3e')](_0x144905,[_0x7d4e('0xc'),_0x19dbc2[_0x7d4e('0xb')]]);if(_0x17ccff){var _0x3144cd=as['buildExpression'](_0x2d08a1,_0x17ccff[_0x7d4e('0x3f')],_0x19dbc2);_0x12c5c8['default'][_0x5ba336](_0x3144cd['text'],_0x3144cd['value'][_0x7d4e('0x40')],_0x3144cd[_0x7d4e('0x41')]['end']);}else{switch(_0x19dbc2[_0x7d4e('0xb')]){case'unreadMessages':var _0x168fca=parseReadParameter(_0x19dbc2[_0x7d4e('0x41')]);_0x12c5c8[_0x7d4e('0x42')][_0x7d4e('0x43')](_0x168fca);break;case _0x7d4e('0x44'):if(_0x19dbc2['operator']==='$substring'){if(_0x19dbc2['value'][_0x7d4e('0x45')]('\x20')['length']>0x1){_0x12c5c8[_0x7d4e('0x46')][_0x5ba336](_0x7d4e('0x47'),qs[_0x7d4e('0x38')](_0x19dbc2[_0x7d4e('0x41')],!![]),null);}else{var _0x725e68='%'+_0x19dbc2[_0x7d4e('0x41')]+'%';_0x12c5c8[_0x7d4e('0x46')][_0x5ba336](_0x7d4e('0x48'),_0x725e68,_0x725e68,_0x725e68);}}else{_0x17ccff=_[_0x7d4e('0x3e')](_0x144905,[_0x7d4e('0xc'),_0x7d4e('0x49')]);_0x19dbc2[_0x7d4e('0xb')]=_0x7d4e('0x49');_0x3144cd=as[_0x7d4e('0x4a')](_0x2d08a1,_0x17ccff[_0x7d4e('0x3f')],_0x19dbc2);_0x12c5c8['contact'][_0x5ba336](_0x3144cd['text'],_0x3144cd['value'][_0x7d4e('0x40')],_0x3144cd[_0x7d4e('0x41')]['end']);}break;case _0x7d4e('0x4b'):var _0x529b27=_0x19dbc2[_0x7d4e('0x41')][_0x7d4e('0x45')](',')[_0x7d4e('0x19')](function(_0x437507){return Number(_0x437507);});var _0x3dbc58=parseTagParameter(_0x529b27);_0x12c5c8[_0x7d4e('0x4c')][_0x7d4e('0x4d')]['and'](_0x3dbc58);_0x12c5c8[_0x7d4e('0x4c')][_0x7d4e('0x4e')]=_0x529b27;break;case _0x7d4e('0x4f'):if(_0x19dbc2[_0x7d4e('0x50')]===_0x7d4e('0x51')){_0x12c5c8[_0x7d4e('0x52')][_0x5ba336](_0x7d4e('0x53'),'%'+_0x19dbc2[_0x7d4e('0x41')]+'%',null);}else{_0x17ccff=_['find'](_0x144905,[_0x7d4e('0xc'),_0x7d4e('0x54')]);_0x19dbc2[_0x7d4e('0xb')]=_0x7d4e('0x54');_0x3144cd=as[_0x7d4e('0x4a')](_0x2d08a1,_0x17ccff[_0x7d4e('0x3f')],_0x19dbc2);_0x12c5c8[_0x7d4e('0x52')][_0x5ba336](_0x3144cd['text'],_0x3144cd[_0x7d4e('0x41')][_0x7d4e('0x40')],_0x3144cd['value'][_0x7d4e('0x55')]);}break;case _0x7d4e('0x56'):case _0x7d4e('0x57'):_0x3144cd=as[_0x7d4e('0x4a')]('me',null,_0x19dbc2);_0x12c5c8[_0x7d4e('0x56')][_0x5ba336](_0x3144cd[_0x7d4e('0x58')],_0x3144cd[_0x7d4e('0x41')]['start'],_0x3144cd['value'][_0x7d4e('0x55')]);break;}}}return _0x12c5c8;}function parseModelFields(_0x4288cc,_0x3a99bb,_0x44ea7b){var _0x212d2d=utils['getAccountFK'](_0x4288cc);var _0x54268f=squel[_0x7d4e('0x25')]();var _0x2d4160=_(_0x3a99bb)[_0x7d4e('0x59')]()[_0x7d4e('0x19')](function(_0xe7851c){return _[_0x7d4e('0x5a')](_0x44ea7b,['name',_0xe7851c])?_0xe7851c:undefined;})[_0x7d4e('0x5b')]()['value']();if(_0x2d4160['length']>0x0){_0x2d4160[_0x7d4e('0x5c')](function(_0x1bdca4){if(_0x1bdca4===_0x212d2d){_0x54268f[_0x7d4e('0x43')]('i.'+_0x212d2d+_0x7d4e('0x18'),[]['concat'](_0x3a99bb[_0x1bdca4]));}else if(_0x1bdca4===_0x7d4e('0x5d')){var _0x1a1f73=JSON[_0x7d4e('0x5e')](_0x3a99bb[_0x1bdca4])[_0x7d4e('0x5f')];var _0xea55f3=JSON[_0x7d4e('0x5e')](_0x3a99bb[_0x1bdca4])[_0x7d4e('0x60')];_0x54268f[_0x7d4e('0x43')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x1a1f73,_0xea55f3);}else{if(_0x3a99bb[_0x1bdca4]===_0x7d4e('0x61')){_0x54268f['and']('i.'+_0x1bdca4+_0x7d4e('0x62'));}else{_0x54268f[_0x7d4e('0x43')]('i.'+_0x1bdca4+_0x7d4e('0x63'),_0x3a99bb[_0x1bdca4]);}}});}return _0x54268f;}function parseQueryParameters(_0x5e5123,_0x27bb06,_0x3d58d7){var _0x970ff8=getSqlClauses();return Promise['resolve']()[_0x7d4e('0x64')](function(){return parseModelFields(_0x5e5123,_0x27bb06,_0x3d58d7);})[_0x7d4e('0x64')](function(_0x171167){_0x970ff8[_0x7d4e('0x65')][_0x7d4e('0x43')](_0x171167);return parseReadParameter(_0x27bb06['read']);})[_0x7d4e('0x64')](function(_0x3692cd){_0x970ff8[_0x7d4e('0x42')]['and'](_0x3692cd);return parseTagParameter(_0x27bb06[_0x7d4e('0x66')]);})[_0x7d4e('0x64')](function(_0x127163){_0x970ff8[_0x7d4e('0x4c')][_0x7d4e('0x4d')]['and'](_0x127163);return parseSearchFilter(_0x5e5123,_0x27bb06[_0x7d4e('0x67')]);})['then'](function(_0x23999d){_0x970ff8[_0x7d4e('0x67')]=_0x23999d;return _0x970ff8;});}function checkAccountsRestrictions(_0x3d4996,_0x43ecd9,_0x429e73){var _0x22710f=utils[_0x7d4e('0x7')](_0x3d4996);var _0x59d324='get'+_[_0x7d4e('0x68')](_0x3d4996)+(_0x3d4996===_0x7d4e('0x69')?'Websites':_0x7d4e('0x6a'));var _0x5a2ae6=squel[_0x7d4e('0x25')]();return Promise[_0x7d4e('0x6b')]()[_0x7d4e('0x64')](function(){if(_0x429e73['search']&&_0x43ecd9[_0x7d4e('0x8')]==='agent'){return _0x43ecd9[_0x59d324]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x50e0d0){if(_0x50e0d0){if(_0x50e0d0[_0x7d4e('0x3c')]===0x0){_0x5a2ae6[_0x7d4e('0x43')]('i.'+_0x22710f+_0x7d4e('0x62'));}else{_0x5a2ae6[_0x7d4e('0x43')]('i.'+_0x22710f+'\x20IN\x20?',_['map'](_0x50e0d0,'id'));}}else if(!_0x429e73[_0x22710f]){_0x5a2ae6['and']('i.'+_0x22710f+_0x7d4e('0x6c'));}})[_0x7d4e('0x64')](function(){return _0x5a2ae6;});}function getClosedOrderClause(_0x5ad7a8,_0x1e2c87){var _0x43924c='';var _0x401783=[_0x7d4e('0x6d'),_0x7d4e('0x6e'),_0x7d4e('0x6f')];if(_0x5ad7a8===_0x7d4e('0x36')){_0x401783[_0x7d4e('0x70')](_0x7d4e('0x71'));}if(_0x1e2c87[_0x7d4e('0x72')]==='0'&&_0x5ad7a8===_0x7d4e('0x36')){_0x43924c='i.substatus';}else{if(_0x1e2c87['closed']==='1'){_0x401783[_0x7d4e('0x73')]();}_0x43924c=_0x7d4e('0x74')+_0x401783[_0x7d4e('0x75')](',\x20')+')';}return _0x43924c;}function getFilteredInteractions(_0x10498b,_0xc5be21,_0x34ca61,_0x5bd0b9){var _0x2b6311=utils[_0x7d4e('0xf')](_0x10498b);var _0x3180b3=_[_0x7d4e('0x68')](_0x10498b)+_0x7d4e('0x76');var _0x474099=[];var _0x495973=getTagsQuery();var _0x23e344={'type':db[_0x7d4e('0x77')][_0x7d4e('0x78')][_0x7d4e('0x79')],'raw':!![]};var _0x1ec20f=[];var _0x2b2964=[];return db[_0x7d4e('0x7a')][_0x7d4e('0x7b')](_0x495973[_0x7d4e('0x7c')](),_0x23e344)['then'](function(_0x431b93){_0x474099=_[_0x7d4e('0x7d')](_0x431b93,'id');_0x23e344=_[_0x7d4e('0x7e')](_0x23e344,{'model':db[_0x3180b3],'mapToModel':!![],'nest':!![]});if(_0x34ca61[_0x7d4e('0x65')]){_0x5bd0b9[_0x7d4e('0x7f')][_0x7d4e('0x5c')](function(_0x10fafa){_0xc5be21['field']('i.'+_0x10fafa);});}else{_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x80'),'unreadMessages');_0xc5be21['field']('a.key',_0x7d4e('0x81'));_0xc5be21['field'](_0x7d4e('0x82'),_0x7d4e('0x83'));if(_0x10498b==='mail'){_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x84'),_0x7d4e('0x85'));_0xc5be21[_0x7d4e('0xb')]('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',_0x7d4e('0x86'));_0xc5be21[_0x7d4e('0xb')]('i.id');_0xc5be21['field'](_0x7d4e('0x87'));_0xc5be21[_0x7d4e('0xb')]('i.updatedAt');_0xc5be21[_0x7d4e('0xb')]('i.closed');_0xc5be21['field'](_0x7d4e('0x88'));_0xc5be21[_0x7d4e('0xb')]('i.attach');_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x89'));_0xc5be21['field'](_0x7d4e('0x8a'));_0xc5be21['field']('i.subject');_0xc5be21['field'](_0x7d4e('0x6f'));_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x6e'));_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x6d'));_0xc5be21[_0x7d4e('0xb')]('i.substatus');_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x8b'));_0xc5be21[_0x7d4e('0xb')]('i.ContactId');_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x8c'));_0xc5be21['field']('i.UserId');}else if(_0x10498b===_0x7d4e('0x33')){_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x8d'),_0x7d4e('0x86'));}else{_0xc5be21[_0x7d4e('0xb')]('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',_0x7d4e('0x86'));}if(_0x10498b!=='mail'){_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x8e'));}_0xc5be21[_0x7d4e('0xb')]('c.firstName',_0x7d4e('0x8f'));_0xc5be21[_0x7d4e('0xb')]('c.lastName',_0x7d4e('0x90'));_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x91'),'Contact.email');_0xc5be21['field'](_0x7d4e('0x92'),_0x7d4e('0x93'));_0xc5be21[_0x7d4e('0xb')]('c.mobile','Contact.mobile');_0xc5be21[_0x7d4e('0xb')]('c.fax',_0x7d4e('0x94'));_0xc5be21[_0x7d4e('0xb')](_0x7d4e('0x95'),'Owner.fullname');_0xc5be21['field'](_0x7d4e('0x96'),_0x7d4e('0x97'));_0xc5be21['field'](_0x7d4e('0x98'),'TagIds');}if(_0x5bd0b9[_0x7d4e('0x99')]){_0xc5be21['limit'](_0x5bd0b9['limit']);}if(_0x5bd0b9[_0x7d4e('0x9a')]){_0xc5be21[_0x7d4e('0x9a')](_0x5bd0b9['offset']);}return db[_0x7d4e('0x7a')][_0x7d4e('0x7b')](_0xc5be21[_0x7d4e('0x7c')](),_0x23e344);})[_0x7d4e('0x64')](function(_0x2e4631){_0x1ec20f=_0x2e4631;var _0x58c446=getUsersQuery(_0x10498b,_0x1ec20f);return db[_0x7d4e('0x7a')]['query'](_0x58c446[_0x7d4e('0x7c')](),_0x23e344);})[_0x7d4e('0x64')](function(_0x16c464){_0x2b2964=_[_0x7d4e('0x9b')](_0x16c464,_0x2b6311);if(_0x10498b===_0x7d4e('0x36')){return db[_0x7d4e('0x9c')][_0x7d4e('0x9d')]({'attributes':[_0x7d4e('0x9e')],'raw':!![]});}})['then'](function(_0x532539){var _0x18d97d=_0x532539?_0x532539['enableEmailPreview']:undefined;var _0x142d64=_0x1ec20f[_0x7d4e('0x19')](function(_0x20e497){return updateInteraction(_0x20e497,_0x474099,_0x2b2964,_0x18d97d);});return Promise[_0x7d4e('0x9f')](_0x142d64);});}function countFilteredInteractions(_0x490b46,_0x45a99f){var _0x508ef3=_0x490b46[_0x7d4e('0xa0')]();_0x508ef3['field'](_0x7d4e('0xa1'));_0x508ef3['field'](_0x7d4e('0x80'),_0x7d4e('0xa2'));var _0x120327=utils[_0x7d4e('0x26')](_0x45a99f);if(!_[_0x7d4e('0xa3')](_0x120327)){_0x508ef3[_0x7d4e('0x16')](_0x7d4e('0xa4'),_0x120327);}var _0x2b0df2={'type':db[_0x7d4e('0x77')][_0x7d4e('0x78')][_0x7d4e('0x79')],'raw':!![]};return db['sequelize'][_0x7d4e('0x7b')](_0x508ef3[_0x7d4e('0x7c')](),_0x2b0df2);}module[_0x7d4e('0xa5')]={'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