// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xdc1c=['\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.disposition','mail','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','QueryTypes','query','keyBy','merge','fields','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','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.createdAt','i.updatedAt','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.secondDisposition','i.to','i.ContactId','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','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','Contact.email','c.phone','Contact.phone','c.mobile','Contact.fax','o.fullname','Owner.fullname','o.internal','TagIds','limit','offset','sequelize','toString','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','where','t.id\x20IN\x20?','SELECT','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','../../mysqldb','getAccountFK','role','agent','field','color','from','tools_tags','getInteractionFK','user_has_','select','u.id','ui.','users','u.id\x20=\x20ui.UserId','length','\x20IN\x20?','getInteractionsTables','interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','it.','expr','getSelectedTags','forEach','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','isEmail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','fax','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','conditions','type','default','text','value','start','end','unreadMessages','read','and','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','name','ContactId','buildExpression','Tag','map','tags','ids','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','user','body','plainBody','keys','some','compact','concat','$gte','$lte','null','\x20IS\x20NULL','\x20=\x20?','then','tag','clause','filter','capitalize','chat','Accounts','resolve','search'];(function(_0x524e23,_0x1e2aa7){var _0x231413=function(_0x22ac35){while(--_0x22ac35){_0x524e23['push'](_0x524e23['shift']());}};_0x231413(++_0x1e2aa7);}(_0xdc1c,0x17d));var _0xcdc1=function(_0xa2ae36,_0x16da61){_0xa2ae36=_0xa2ae36-0x0;var _0x151e7a=_0xdc1c[_0xa2ae36];return _0x151e7a;};'use strict';var _=require('lodash');var squel=require(_0xcdc1('0x0'));var as=require(_0xcdc1('0x1'));var qs=require(_0xcdc1('0x2'));var updateInteraction=require(_0xcdc1('0x3'))['updateInteraction'];var utils=require('./utils');var db=require(_0xcdc1('0x4'))['db'];function skipInteractionsQuery(_0x37c27b,_0x114a4b,_0x4e8f76){var _0x2d30b0=![];var _0x435c0f=utils[_0xcdc1('0x5')](_0x37c27b);if(_0x114a4b[_0xcdc1('0x6')]===_0xcdc1('0x7')&&!_0x4e8f76['search']&&!_0x4e8f76[_0x435c0f]){_0x2d30b0=!![];}return _0x2d30b0;}function getTagsQuery(){return squel['select']()['field']('id')[_0xcdc1('0x8')]('name')[_0xcdc1('0x8')](_0xcdc1('0x9'))[_0xcdc1('0xa')](_0xcdc1('0xb'));}function getUsersQuery(_0x1f1e1b,_0x4c744f){var _0xb291bc=utils[_0xcdc1('0xc')](_0x1f1e1b);var _0x1ca632=_0xcdc1('0xd')+_0x1f1e1b+'_interactions';var _0x1c87cd=squel[_0xcdc1('0xe')]()[_0xcdc1('0x8')](_0xcdc1('0xf'))[_0xcdc1('0x8')]('u.fullname')[_0xcdc1('0x8')](_0xcdc1('0x10')+_0xb291bc)[_0xcdc1('0xa')](_0x1ca632,'ui')['left_join'](_0xcdc1('0x11'),'u',_0xcdc1('0x12'));if(_0x4c744f[_0xcdc1('0x13')]>0x0){_0x1c87cd['where'](_0xcdc1('0x10')+_0xb291bc+_0xcdc1('0x14'),_['map'](_0x4c744f,'id'));}return _0x1c87cd;}function getInteractionsQuery(_0x4a65e5){var _0x294a8e=utils[_0xcdc1('0x15')](_0x4a65e5);var _0x2ebfed=utils['getAccountFK'](_0x4a65e5);var _0x4e8123=utils['getInteractionFK'](_0x4a65e5);return squel['select']()['from'](_0x294a8e[_0xcdc1('0x16')],'i')[_0xcdc1('0x17')](_0xcdc1('0x18'),'c',_0xcdc1('0x19'))[_0xcdc1('0x17')](_0xcdc1('0x11'),'o','o.id\x20=\x20i.UserId')[_0xcdc1('0x17')](_0x294a8e[_0xcdc1('0x1a')],'a',_0xcdc1('0x1b')+_0x2ebfed)['left_join'](_0x294a8e[_0xcdc1('0x1c')],'me',_0xcdc1('0x1d')+_0x4e8123+_0xcdc1('0x1e'))['left_join'](_0x294a8e[_0xcdc1('0x1f')],'it',_0xcdc1('0x20')+_0x4e8123+_0xcdc1('0x1e'))['left_join'](_0xcdc1('0xb'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x5b1e8d={'body':squel[_0xcdc1('0x21')](),'contact':squel[_0xcdc1('0x21')](),'default':squel[_0xcdc1('0x21')](),'fields':squel[_0xcdc1('0x21')](),'filter':squel[_0xcdc1('0x21')](),'read':squel[_0xcdc1('0x21')](),'tags':{'clause':squel[_0xcdc1('0x21')](),'ids':null},'user':squel[_0xcdc1('0x21')]()};return _0x5b1e8d;}function parseTagParameter(_0x45fa4f){var _0x59b2ba=squel[_0xcdc1('0x21')]();if(_0x45fa4f){var _0x1dc54a=utils[_0xcdc1('0x22')](_0x45fa4f);_0x1dc54a[_0xcdc1('0x23')](function(_0x304cc0){_0x59b2ba['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x304cc0+',%');});}return _0x59b2ba;}function parseReadParameter(_0x35ada1){var _0x5eb7fc='';if(_0x35ada1){_0x5eb7fc=_0xcdc1('0x24');if(_0x35ada1==='1'){_0x5eb7fc=_0x5eb7fc[_0xcdc1('0x25')](_0xcdc1('0x26'),'=');}else{_0x5eb7fc=_0x5eb7fc['replace']('{OPERATOR}','>');}}return _0x5eb7fc;}function parseSearchFilter(_0x496569,_0x388b72){var _0x17c272=squel[_0xcdc1('0x21')]();if(_0x388b72){var _0x4132f5=_0x388b72[_0xcdc1('0x25')]('\x5c','\x5c\x5c')[_0xcdc1('0x25')](/'/g,'\x27\x27');var _0x29dd18=qs['escapeLIKESpecialChars'](_0x4132f5);if(qs[_0xcdc1('0x27')](_0x4132f5)){_0x17c272['or'](_0xcdc1('0x28'),_0x29dd18+'%');if([_0xcdc1('0x29'),_0xcdc1('0x2a')][_0xcdc1('0x2b')](_0x496569)){_0x17c272['or']('i.phone\x20LIKE\x20?',_0x29dd18+'%');}else if(_0x496569==='fax'){_0x17c272['or'](_0xcdc1('0x2c'),_0x29dd18+'%');}else if(_0x496569===_0xcdc1('0x2d')){_0x17c272['or'](_0xcdc1('0x2e'),_0x29dd18+'%');}}else if(_0x496569==='mail'&&qs[_0xcdc1('0x2f')](_0x4132f5)){_0x17c272['or']('c.email\x20LIKE\x20?',_0x29dd18+'%');}else{if(_0x496569==='mail'){_0x17c272['or'](_0xcdc1('0x30'),qs[_0xcdc1('0x31')](_0x4132f5,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xcdc1('0x31')](_0x4132f5));}else if(_0x496569!==_0xcdc1('0x32')){_0x17c272['or'](_0xcdc1('0x33'),qs[_0xcdc1('0x31')](_0x4132f5));}_0x17c272['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xcdc1('0x31')](_0x4132f5,!![]),null);}}return _0x17c272;}function parseAdvancedSearchFilter(_0x205190,_0x3a3199){var _0x40417f=getSqlClauses();var _0xcf2dbd=as[_0xcdc1('0x34')](_0x205190);var _0x4e4cb6=_0xcf2dbd['sqlOperator'];for(var _0x2a0445=0x0;_0x2a0445<_0xcf2dbd[_0xcdc1('0x35')][_0xcdc1('0x13')];_0x2a0445++){var _0x2bc607=_0xcf2dbd[_0xcdc1('0x35')][_0x2a0445];var _0x5820ea='i';var _0x1d098f=_['find'](_0x3a3199,['name',_0x2bc607['field']]);if(_0x1d098f){var _0x3c1940=as['buildExpression'](_0x5820ea,_0x1d098f[_0xcdc1('0x36')],_0x2bc607);_0x40417f[_0xcdc1('0x37')][_0x4e4cb6](_0x3c1940[_0xcdc1('0x38')],_0x3c1940[_0xcdc1('0x39')][_0xcdc1('0x3a')],_0x3c1940[_0xcdc1('0x39')][_0xcdc1('0x3b')]);}else{switch(_0x2bc607[_0xcdc1('0x8')]){case _0xcdc1('0x3c'):var _0x19d021=parseReadParameter(_0x2bc607[_0xcdc1('0x39')]);_0x40417f[_0xcdc1('0x3d')][_0xcdc1('0x3e')](_0x19d021);break;case'Contact':if(_0x2bc607[_0xcdc1('0x3f')]===_0xcdc1('0x40')){if(_0x2bc607[_0xcdc1('0x39')][_0xcdc1('0x41')]('\x20')[_0xcdc1('0x13')]>0x1){_0x40417f[_0xcdc1('0x42')][_0x4e4cb6]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x2bc607[_0xcdc1('0x39')],!![]),null);}else{var _0x3a6687='%'+_0x2bc607[_0xcdc1('0x39')]+'%';_0x40417f['contact'][_0x4e4cb6](_0xcdc1('0x43'),_0x3a6687,_0x3a6687,_0x3a6687);}}else{_0x1d098f=_['find'](_0x3a3199,[_0xcdc1('0x44'),_0xcdc1('0x45')]);_0x2bc607[_0xcdc1('0x8')]=_0xcdc1('0x45');_0x3c1940=as[_0xcdc1('0x46')](_0x5820ea,_0x1d098f['type'],_0x2bc607);_0x40417f[_0xcdc1('0x42')][_0x4e4cb6](_0x3c1940[_0xcdc1('0x38')],_0x3c1940[_0xcdc1('0x39')][_0xcdc1('0x3a')],_0x3c1940[_0xcdc1('0x39')][_0xcdc1('0x3b')]);}break;case _0xcdc1('0x47'):var _0x2dedd6=_0x2bc607[_0xcdc1('0x39')]['split'](',')[_0xcdc1('0x48')](function(_0x4174c8){return Number(_0x4174c8);});var _0x15a5ff=parseTagParameter(_0x2dedd6);_0x40417f[_0xcdc1('0x49')]['clause']['and'](_0x15a5ff);_0x40417f['tags'][_0xcdc1('0x4a')]=_0x2dedd6;break;case _0xcdc1('0x4b'):if(_0x2bc607[_0xcdc1('0x3f')]===_0xcdc1('0x40')){_0x40417f['user'][_0x4e4cb6](_0xcdc1('0x4c'),'%'+_0x2bc607['value']+'%',null);}else{_0x1d098f=_['find'](_0x3a3199,['name',_0xcdc1('0x4d')]);_0x2bc607[_0xcdc1('0x8')]=_0xcdc1('0x4d');_0x3c1940=as[_0xcdc1('0x46')](_0x5820ea,_0x1d098f[_0xcdc1('0x36')],_0x2bc607);_0x40417f[_0xcdc1('0x4e')][_0x4e4cb6](_0x3c1940[_0xcdc1('0x38')],_0x3c1940[_0xcdc1('0x39')][_0xcdc1('0x3a')],_0x3c1940[_0xcdc1('0x39')]['end']);}break;case _0xcdc1('0x4f'):case _0xcdc1('0x50'):_0x3c1940=as[_0xcdc1('0x46')]('me',null,_0x2bc607);_0x40417f[_0xcdc1('0x4f')][_0x4e4cb6](_0x3c1940[_0xcdc1('0x38')],_0x3c1940['value'][_0xcdc1('0x3a')],_0x3c1940[_0xcdc1('0x39')]['end']);break;}}}return _0x40417f;}function parseModelFields(_0x39aa45,_0x460ae6,_0x4c8d1f){var _0x4cae22=utils[_0xcdc1('0x5')](_0x39aa45);var _0x354f9f=squel['expr']();var _0x3f65a8=_(_0x460ae6)[_0xcdc1('0x51')]()[_0xcdc1('0x48')](function(_0x5aa080){return _[_0xcdc1('0x52')](_0x4c8d1f,[_0xcdc1('0x44'),_0x5aa080])?_0x5aa080:undefined;})[_0xcdc1('0x53')]()[_0xcdc1('0x39')]();if(_0x3f65a8['length']>0x0){_0x3f65a8[_0xcdc1('0x23')](function(_0x400778){if(_0x400778===_0x4cae22){_0x354f9f[_0xcdc1('0x3e')]('i.'+_0x4cae22+_0xcdc1('0x14'),[][_0xcdc1('0x54')](_0x460ae6[_0x400778]));}else if(_0x400778==='createdAt'){var _0x547d65=JSON['parse'](_0x460ae6[_0x400778])[_0xcdc1('0x55')];var _0xbbe945=JSON['parse'](_0x460ae6[_0x400778])[_0xcdc1('0x56')];_0x354f9f[_0xcdc1('0x3e')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x547d65,_0xbbe945);}else{if(_0x460ae6[_0x400778]===_0xcdc1('0x57')){_0x354f9f[_0xcdc1('0x3e')]('i.'+_0x400778+_0xcdc1('0x58'));}else{_0x354f9f[_0xcdc1('0x3e')]('i.'+_0x400778+_0xcdc1('0x59'),_0x460ae6[_0x400778]);}}});}return _0x354f9f;}function parseQueryParameters(_0x5dd773,_0x1d9165,_0x38b751){var _0x8736a2=getSqlClauses();return Promise['resolve']()['then'](function(){return parseModelFields(_0x5dd773,_0x1d9165,_0x38b751);})[_0xcdc1('0x5a')](function(_0x117fc5){_0x8736a2['fields']['and'](_0x117fc5);return parseReadParameter(_0x1d9165['read']);})[_0xcdc1('0x5a')](function(_0x4dbfe9){_0x8736a2[_0xcdc1('0x3d')][_0xcdc1('0x3e')](_0x4dbfe9);return parseTagParameter(_0x1d9165[_0xcdc1('0x5b')]);})[_0xcdc1('0x5a')](function(_0x4cd2cb){_0x8736a2[_0xcdc1('0x49')][_0xcdc1('0x5c')][_0xcdc1('0x3e')](_0x4cd2cb);return parseSearchFilter(_0x5dd773,_0x1d9165[_0xcdc1('0x5d')]);})[_0xcdc1('0x5a')](function(_0x2fd482){_0x8736a2[_0xcdc1('0x5d')]=_0x2fd482;return _0x8736a2;});}function checkAccountsRestrictions(_0x3d11be,_0x321c4d,_0x2c519c){var _0x25d0e5=utils['getAccountFK'](_0x3d11be);var _0x1026ff='get'+_[_0xcdc1('0x5e')](_0x3d11be)+(_0x3d11be===_0xcdc1('0x5f')?'Websites':_0xcdc1('0x60'));var _0x2bc41c=squel['expr']();return Promise[_0xcdc1('0x61')]()['then'](function(){if(_0x2c519c[_0xcdc1('0x62')]&&_0x321c4d[_0xcdc1('0x6')]==='agent'){return _0x321c4d[_0x1026ff]({'attributes':['id'],'raw':!![]});}})[_0xcdc1('0x5a')](function(_0x36f675){if(_0x36f675){if(_0x36f675['length']===0x0){_0x2bc41c['and']('i.'+_0x25d0e5+'\x20IS\x20NULL');}else{_0x2bc41c['and']('i.'+_0x25d0e5+_0xcdc1('0x14'),_['map'](_0x36f675,'id'));}}else if(!_0x2c519c[_0x25d0e5]){_0x2bc41c[_0xcdc1('0x3e')]('i.'+_0x25d0e5+_0xcdc1('0x63'));}})['then'](function(){return _0x2bc41c;});}function getClosedOrderClause(_0x18db6b,_0x2e92c4){var _0x19c5bf='';var _0x41a6ab=[_0xcdc1('0x64'),'i.secondDisposition',_0xcdc1('0x65')];if(_0x18db6b===_0xcdc1('0x66')){_0x41a6ab[_0xcdc1('0x67')](_0xcdc1('0x68'));}if(_0x2e92c4[_0xcdc1('0x69')]==='0'&&_0x18db6b===_0xcdc1('0x66')){_0x19c5bf=_0xcdc1('0x68');}else{if(_0x2e92c4['closed']==='1'){_0x41a6ab[_0xcdc1('0x6a')]();}_0x19c5bf=_0xcdc1('0x6b')+_0x41a6ab[_0xcdc1('0x6c')](',\x20')+')';}return _0x19c5bf;}function getFilteredInteractions(_0x5ef1c0,_0x523ddc,_0x2fc839,_0x1ae197){var _0x19c288=utils[_0xcdc1('0xc')](_0x5ef1c0);var _0x4c2d2e=_[_0xcdc1('0x5e')](_0x5ef1c0)+_0xcdc1('0x6d');var _0x2758e6=[];var _0x39d251=getTagsQuery();var _0x37c79f={'type':db['Sequelize'][_0xcdc1('0x6e')]['SELECT'],'raw':!![]};var _0x4756b9=[];var _0x17970b=[];return db['sequelize'][_0xcdc1('0x6f')](_0x39d251['toString'](),_0x37c79f)['then'](function(_0x278911){_0x2758e6=_[_0xcdc1('0x70')](_0x278911,'id');_0x37c79f=_[_0xcdc1('0x71')](_0x37c79f,{'model':db[_0x4c2d2e],'mapToModel':!![],'nest':!![]});if(_0x2fc839[_0xcdc1('0x72')]){_0x1ae197['attributes'][_0xcdc1('0x23')](function(_0x460a47){_0x523ddc['field']('i.'+_0x460a47);});}else{_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x73'),_0xcdc1('0x3c'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x74'),'Account.key');_0x523ddc['field']('a.mandatoryDisposition','Account.mandatoryDisposition');if(_0x5ef1c0===_0xcdc1('0x66')){_0x523ddc[_0xcdc1('0x8')]('a.email',_0xcdc1('0x75'));_0x523ddc['field'](_0xcdc1('0x76'),'contactName');_0x523ddc['field']('i.id');_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x77'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x78'));_0x523ddc['field']('i.closed');_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x79'));_0x523ddc['field'](_0xcdc1('0x7a'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x7b'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x7c'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x7d'));_0x523ddc['field'](_0xcdc1('0x65'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x7e'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x64'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x68'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x7f'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x80'));_0x523ddc[_0xcdc1('0x8')]('i.MailAccountId');_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x81'));}else if(_0x5ef1c0==='openchannel'){_0x523ddc['field'](_0xcdc1('0x82'),_0xcdc1('0x83'));}else{_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x84'),_0xcdc1('0x83'));}if(_0x5ef1c0!==_0xcdc1('0x66')){_0x523ddc['field'](_0xcdc1('0x85'));}_0x523ddc[_0xcdc1('0x8')]('c.firstName','Contact.firstName');_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x86'),_0xcdc1('0x87'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x88'),_0xcdc1('0x89'));_0x523ddc['field'](_0xcdc1('0x8a'),_0xcdc1('0x8b'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x8c'),'Contact.mobile');_0x523ddc[_0xcdc1('0x8')]('c.fax',_0xcdc1('0x8d'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x8e'),_0xcdc1('0x8f'));_0x523ddc[_0xcdc1('0x8')](_0xcdc1('0x90'),'Owner.internal');_0x523ddc[_0xcdc1('0x8')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xcdc1('0x91'));}if(_0x1ae197[_0xcdc1('0x92')]){_0x523ddc[_0xcdc1('0x92')](_0x1ae197['limit']);}if(_0x1ae197[_0xcdc1('0x93')]){_0x523ddc['offset'](_0x1ae197[_0xcdc1('0x93')]);}return db[_0xcdc1('0x94')]['query'](_0x523ddc[_0xcdc1('0x95')](),_0x37c79f);})[_0xcdc1('0x5a')](function(_0x488712){_0x4756b9=_0x488712;var _0x35cef9=getUsersQuery(_0x5ef1c0,_0x4756b9);return db[_0xcdc1('0x94')][_0xcdc1('0x6f')](_0x35cef9[_0xcdc1('0x95')](),_0x37c79f);})[_0xcdc1('0x5a')](function(_0x1e5a10){_0x17970b=_[_0xcdc1('0x96')](_0x1e5a10,_0x19c288);if(_0x5ef1c0===_0xcdc1('0x66')){return db[_0xcdc1('0x97')][_0xcdc1('0x98')]({'attributes':['enableEmailPreview'],'raw':!![]});}})['then'](function(_0x1ac109){var _0x504fda=_0x1ac109?_0x1ac109[_0xcdc1('0x99')]:undefined;var _0x297e60=_0x4756b9['map'](function(_0x157a30){return updateInteraction(_0x157a30,_0x2758e6,_0x17970b,_0x504fda);});return Promise[_0xcdc1('0x9a')](_0x297e60);});}function countFilteredInteractions(_0x2489d1,_0x407472){var _0x377924=_0x2489d1[_0xcdc1('0x9b')]();_0x377924['field'](_0xcdc1('0x9c'));_0x377924[_0xcdc1('0x8')](_0xcdc1('0x73'),_0xcdc1('0x3c'));var _0x53855c=utils[_0xcdc1('0x22')](_0x407472);if(!_['isEmpty'](_0x53855c)){_0x377924[_0xcdc1('0x9d')](_0xcdc1('0x9e'),_0x53855c);}var _0x3f681b={'type':db['Sequelize'][_0xcdc1('0x6e')][_0xcdc1('0x9f')],'raw':!![]};return db[_0xcdc1('0x94')]['query'](_0x377924[_0xcdc1('0x95')](),_0x3f681b);}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 _0xd955=['where','\x20IN\x20?','getInteractionsTables','select','interactions','users','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','me.','interactionsTags','it.','\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','i.id\x20LIKE\x20?','includes','fax','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','mail','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','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','buildExpression','default','value','end','read','operator','$substring','split','find','ContactId','type','text','start','Tag','map','clause','and','ids','User','user','UserId','body','plainBody','keys','some','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','tags','filter','get','capitalize','chat','Websites','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','a.key','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','contactName','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.thirdDisposition','i.to','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','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','groupBy','Setting','enableEmailPreview','clone','COUNT(*)','isEmpty','Sequelize','SELECT','exports','lodash','squel','../parsers/qs','./update-interaction','./utils','../../mysqldb','getAccountFK','role','agent','search','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','u.id\x20=\x20ui.UserId','length'];(function(_0x20a584,_0xe384a5){var _0x4b41a8=function(_0x2127c6){while(--_0x2127c6){_0x20a584['push'](_0x20a584['shift']());}};_0x4b41a8(++_0xe384a5);}(_0xd955,0x1e3));var _0x5d95=function(_0x4ea42f,_0x760cda){_0x4ea42f=_0x4ea42f-0x0;var _0x46427a=_0xd955[_0x4ea42f];return _0x46427a;};'use strict';var _=require(_0x5d95('0x0'));var squel=require(_0x5d95('0x1'));var as=require('../parsers/advancedSearch');var qs=require(_0x5d95('0x2'));var updateInteraction=require(_0x5d95('0x3'))['updateInteraction'];var utils=require(_0x5d95('0x4'));var db=require(_0x5d95('0x5'))['db'];function skipInteractionsQuery(_0x56ff7b,_0x432339,_0x3e41eb){var _0x2e3ea3=![];var _0x2a4d77=utils[_0x5d95('0x6')](_0x56ff7b);if(_0x432339[_0x5d95('0x7')]===_0x5d95('0x8')&&!_0x3e41eb[_0x5d95('0x9')]&&!_0x3e41eb[_0x2a4d77]){_0x2e3ea3=!![];}return _0x2e3ea3;}function getTagsQuery(){return squel['select']()[_0x5d95('0xa')]('id')[_0x5d95('0xa')](_0x5d95('0xb'))[_0x5d95('0xa')](_0x5d95('0xc'))[_0x5d95('0xd')](_0x5d95('0xe'));}function getUsersQuery(_0x23eba6,_0x26400c){var _0x41c3ff=utils[_0x5d95('0xf')](_0x23eba6);var _0x539c64=_0x5d95('0x10')+_0x23eba6+_0x5d95('0x11');var _0x2dea48=squel['select']()[_0x5d95('0xa')](_0x5d95('0x12'))[_0x5d95('0xa')](_0x5d95('0x13'))[_0x5d95('0xa')](_0x5d95('0x14')+_0x41c3ff)[_0x5d95('0xd')](_0x539c64,'ui')[_0x5d95('0x15')]('users','u',_0x5d95('0x16'));if(_0x26400c[_0x5d95('0x17')]>0x0){_0x2dea48[_0x5d95('0x18')](_0x5d95('0x14')+_0x41c3ff+_0x5d95('0x19'),_['map'](_0x26400c,'id'));}return _0x2dea48;}function getInteractionsQuery(_0xdf0b01){var _0x19b96f=utils[_0x5d95('0x1a')](_0xdf0b01);var _0x386b90=utils['getAccountFK'](_0xdf0b01);var _0x4c4720=utils[_0x5d95('0xf')](_0xdf0b01);return squel[_0x5d95('0x1b')]()[_0x5d95('0xd')](_0x19b96f[_0x5d95('0x1c')],'i')['left_join']('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x5d95('0x15')](_0x5d95('0x1d'),'o',_0x5d95('0x1e'))[_0x5d95('0x15')](_0x19b96f[_0x5d95('0x1f')],'a',_0x5d95('0x20')+_0x386b90)[_0x5d95('0x15')](_0x19b96f[_0x5d95('0x21')],'me',_0x5d95('0x22')+_0x4c4720+'\x20=\x20i.id')[_0x5d95('0x15')](_0x19b96f[_0x5d95('0x23')],'it',_0x5d95('0x24')+_0x4c4720+_0x5d95('0x25'))['left_join'](_0x5d95('0xe'),'t',_0x5d95('0x26'));}function getSqlClauses(){var _0x381dec={'body':squel[_0x5d95('0x27')](),'contact':squel[_0x5d95('0x27')](),'default':squel[_0x5d95('0x27')](),'fields':squel[_0x5d95('0x27')](),'filter':squel[_0x5d95('0x27')](),'read':squel['expr'](),'tags':{'clause':squel[_0x5d95('0x27')](),'ids':null},'user':squel[_0x5d95('0x27')]()};return _0x381dec;}function parseTagParameter(_0x2a140e){var _0x61e1c2=squel[_0x5d95('0x27')]();if(_0x2a140e){var _0x309db5=utils[_0x5d95('0x28')](_0x2a140e);_0x309db5[_0x5d95('0x29')](function(_0x22ca10){_0x61e1c2['or'](_0x5d95('0x2a'),'%,'+_0x22ca10+',%');});}return _0x61e1c2;}function parseReadParameter(_0xd03df3){var _0x3bc77f='';if(_0xd03df3){_0x3bc77f=_0x5d95('0x2b');if(_0xd03df3==='1'){_0x3bc77f=_0x3bc77f['replace']('{OPERATOR}','=');}else{_0x3bc77f=_0x3bc77f[_0x5d95('0x2c')](_0x5d95('0x2d'),'>');}}return _0x3bc77f;}function parseSearchFilter(_0x55156b,_0x9d8255){var _0x1125dd=squel[_0x5d95('0x27')]();if(_0x9d8255){var _0x59eae1=_0x9d8255[_0x5d95('0x2c')]('\x5c','\x5c\x5c')[_0x5d95('0x2c')](/'/g,'\x27\x27');var _0xb96c3e=qs['escapeLIKESpecialChars'](_0x59eae1);if(qs['isNumeric'](_0x59eae1)){_0x1125dd['or'](_0x5d95('0x2e'),_0xb96c3e+'%');if(['sms','whatsapp'][_0x5d95('0x2f')](_0x55156b)){_0x1125dd['or']('i.phone\x20LIKE\x20?',_0xb96c3e+'%');}else if(_0x55156b===_0x5d95('0x30')){_0x1125dd['or'](_0x5d95('0x31'),_0xb96c3e+'%');}else if(_0x55156b===_0x5d95('0x32')){_0x1125dd['or'](_0x5d95('0x33'),_0xb96c3e+'%');}}else if(_0x55156b==='mail'&&qs[_0x5d95('0x34')](_0x59eae1)){_0x1125dd['or'](_0x5d95('0x35'),_0xb96c3e+'%');}else{if(_0x55156b===_0x5d95('0x36')){_0x1125dd['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x59eae1,!![]))['or'](_0x5d95('0x37'),qs[_0x5d95('0x38')](_0x59eae1));}else if(_0x55156b!=='fax'){_0x1125dd['or'](_0x5d95('0x39'),qs[_0x5d95('0x38')](_0x59eae1));}_0x1125dd['or'](_0x5d95('0x3a'),qs[_0x5d95('0x38')](_0x59eae1,!![]),null);}}return _0x1125dd;}function parseAdvancedSearchFilter(_0x5bc003,_0x36321b){var _0x2a431e=getSqlClauses();var _0x4271d8=as[_0x5d95('0x3b')](_0x5bc003);var _0x3f601e=_0x4271d8[_0x5d95('0x3c')];for(var _0x48de96=0x0;_0x48de96<_0x4271d8[_0x5d95('0x3d')][_0x5d95('0x17')];_0x48de96++){var _0x28ad7c=_0x4271d8[_0x5d95('0x3d')][_0x48de96];var _0x5dd4ec='i';var _0x40586e=_['find'](_0x36321b,[_0x5d95('0xb'),_0x28ad7c['field']]);if(_0x40586e){var _0x221bfc=as[_0x5d95('0x3e')](_0x5dd4ec,_0x40586e['type'],_0x28ad7c);_0x2a431e[_0x5d95('0x3f')][_0x3f601e](_0x221bfc['text'],_0x221bfc[_0x5d95('0x40')]['start'],_0x221bfc[_0x5d95('0x40')][_0x5d95('0x41')]);}else{switch(_0x28ad7c[_0x5d95('0xa')]){case'unreadMessages':var _0x1baed6=parseReadParameter(_0x28ad7c[_0x5d95('0x40')]);_0x2a431e[_0x5d95('0x42')]['and'](_0x1baed6);break;case'Contact':if(_0x28ad7c[_0x5d95('0x43')]===_0x5d95('0x44')){if(_0x28ad7c[_0x5d95('0x40')][_0x5d95('0x45')]('\x20')['length']>0x1){_0x2a431e['contact'][_0x3f601e](_0x5d95('0x3a'),qs[_0x5d95('0x38')](_0x28ad7c[_0x5d95('0x40')],!![]),null);}else{var _0x1a48cd='%'+_0x28ad7c['value']+'%';_0x2a431e['contact'][_0x3f601e]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x1a48cd,_0x1a48cd,_0x1a48cd);}}else{_0x40586e=_[_0x5d95('0x46')](_0x36321b,['name','ContactId']);_0x28ad7c[_0x5d95('0xa')]=_0x5d95('0x47');_0x221bfc=as[_0x5d95('0x3e')](_0x5dd4ec,_0x40586e[_0x5d95('0x48')],_0x28ad7c);_0x2a431e['contact'][_0x3f601e](_0x221bfc[_0x5d95('0x49')],_0x221bfc['value'][_0x5d95('0x4a')],_0x221bfc[_0x5d95('0x40')][_0x5d95('0x41')]);}break;case _0x5d95('0x4b'):var _0x216de8=_0x28ad7c[_0x5d95('0x40')][_0x5d95('0x45')](',')[_0x5d95('0x4c')](function(_0x2820b4){return Number(_0x2820b4);});var _0xbc3eea=parseTagParameter(_0x216de8);_0x2a431e['tags'][_0x5d95('0x4d')][_0x5d95('0x4e')](_0xbc3eea);_0x2a431e['tags'][_0x5d95('0x4f')]=_0x216de8;break;case _0x5d95('0x50'):if(_0x28ad7c[_0x5d95('0x43')]===_0x5d95('0x44')){_0x2a431e[_0x5d95('0x51')][_0x3f601e]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x28ad7c[_0x5d95('0x40')]+'%',null);}else{_0x40586e=_[_0x5d95('0x46')](_0x36321b,['name',_0x5d95('0x52')]);_0x28ad7c[_0x5d95('0xa')]=_0x5d95('0x52');_0x221bfc=as[_0x5d95('0x3e')](_0x5dd4ec,_0x40586e['type'],_0x28ad7c);_0x2a431e['user'][_0x3f601e](_0x221bfc['text'],_0x221bfc[_0x5d95('0x40')]['start'],_0x221bfc[_0x5d95('0x40')][_0x5d95('0x41')]);}break;case _0x5d95('0x53'):case _0x5d95('0x54'):_0x221bfc=as['buildExpression']('me',null,_0x28ad7c);_0x2a431e[_0x5d95('0x53')][_0x3f601e](_0x221bfc[_0x5d95('0x49')],_0x221bfc[_0x5d95('0x40')][_0x5d95('0x4a')],_0x221bfc[_0x5d95('0x40')][_0x5d95('0x41')]);break;}}}return _0x2a431e;}function parseModelFields(_0x18af93,_0x19f987,_0x5ebe47){var _0x40f941=utils['getAccountFK'](_0x18af93);var _0x1d2236=squel[_0x5d95('0x27')]();var _0x42b0a8=_(_0x19f987)[_0x5d95('0x55')]()['map'](function(_0x3016d5){return _[_0x5d95('0x56')](_0x5ebe47,[_0x5d95('0xb'),_0x3016d5])?_0x3016d5:undefined;})['compact']()[_0x5d95('0x40')]();if(_0x42b0a8[_0x5d95('0x17')]>0x0){_0x42b0a8[_0x5d95('0x29')](function(_0x5bffcb){if(_0x5bffcb===_0x40f941){_0x1d2236[_0x5d95('0x4e')]('i.'+_0x40f941+_0x5d95('0x19'),[][_0x5d95('0x57')](_0x19f987[_0x5bffcb]));}else if(_0x5bffcb===_0x5d95('0x58')){var _0x3b7bc2=JSON[_0x5d95('0x59')](_0x19f987[_0x5bffcb])['$gte'];var _0x43d220=JSON[_0x5d95('0x59')](_0x19f987[_0x5bffcb])[_0x5d95('0x5a')];_0x1d2236[_0x5d95('0x4e')](_0x5d95('0x5b'),_0x3b7bc2,_0x43d220);}else{if(_0x19f987[_0x5bffcb]==='null'){_0x1d2236[_0x5d95('0x4e')]('i.'+_0x5bffcb+_0x5d95('0x5c'));}else{_0x1d2236[_0x5d95('0x4e')]('i.'+_0x5bffcb+_0x5d95('0x5d'),_0x19f987[_0x5bffcb]);}}});}return _0x1d2236;}function parseQueryParameters(_0x5d35ea,_0x4ec0f9,_0x5c727c){var _0x1dcdbc=getSqlClauses();return Promise[_0x5d95('0x5e')]()[_0x5d95('0x5f')](function(){return parseModelFields(_0x5d35ea,_0x4ec0f9,_0x5c727c);})[_0x5d95('0x5f')](function(_0x36b2af){_0x1dcdbc[_0x5d95('0x60')][_0x5d95('0x4e')](_0x36b2af);return parseReadParameter(_0x4ec0f9[_0x5d95('0x42')]);})[_0x5d95('0x5f')](function(_0x58e33d){_0x1dcdbc[_0x5d95('0x42')][_0x5d95('0x4e')](_0x58e33d);return parseTagParameter(_0x4ec0f9[_0x5d95('0x61')]);})[_0x5d95('0x5f')](function(_0x384fcf){_0x1dcdbc[_0x5d95('0x62')][_0x5d95('0x4d')]['and'](_0x384fcf);return parseSearchFilter(_0x5d35ea,_0x4ec0f9['filter']);})[_0x5d95('0x5f')](function(_0x14bedf){_0x1dcdbc[_0x5d95('0x63')]=_0x14bedf;return _0x1dcdbc;});}function checkAccountsRestrictions(_0x2afe16,_0x4990fa,_0x154f50){var _0x1e6da0=utils[_0x5d95('0x6')](_0x2afe16);var _0x13e994=_0x5d95('0x64')+_[_0x5d95('0x65')](_0x2afe16)+(_0x2afe16===_0x5d95('0x66')?_0x5d95('0x67'):'Accounts');var _0x3006da=squel['expr']();return Promise[_0x5d95('0x5e')]()['then'](function(){if(_0x154f50[_0x5d95('0x9')]&&_0x4990fa[_0x5d95('0x7')]===_0x5d95('0x8')){return _0x4990fa[_0x13e994]({'attributes':['id'],'raw':!![]});}})[_0x5d95('0x5f')](function(_0x7f1e2a){if(_0x7f1e2a){if(_0x7f1e2a[_0x5d95('0x17')]===0x0){_0x3006da['and']('i.'+_0x1e6da0+_0x5d95('0x5c'));}else{_0x3006da['and']('i.'+_0x1e6da0+_0x5d95('0x19'),_['map'](_0x7f1e2a,'id'));}}else if(!_0x154f50[_0x1e6da0]){_0x3006da[_0x5d95('0x4e')]('i.'+_0x1e6da0+_0x5d95('0x68'));}})[_0x5d95('0x5f')](function(){return _0x3006da;});}function getClosedOrderClause(_0x3e1c0d,_0x10ad48){var _0x4097fc='';var _0x97cadb=['i.thirdDisposition',_0x5d95('0x69'),_0x5d95('0x6a')];if(_0x3e1c0d===_0x5d95('0x36')){_0x97cadb[_0x5d95('0x6b')](_0x5d95('0x6c'));}if(_0x10ad48[_0x5d95('0x6d')]==='0'&&_0x3e1c0d===_0x5d95('0x36')){_0x4097fc=_0x5d95('0x6c');}else{if(_0x10ad48[_0x5d95('0x6d')]==='1'){_0x97cadb[_0x5d95('0x6e')]();}_0x4097fc=_0x5d95('0x6f')+_0x97cadb[_0x5d95('0x70')](',\x20')+')';}return _0x4097fc;}function getFilteredInteractions(_0x47eaf9,_0x2d0f35,_0xc9fe20,_0x1fb9d4){var _0x1e1dfe=utils[_0x5d95('0xf')](_0x47eaf9);var _0x577a77=_[_0x5d95('0x65')](_0x47eaf9)+_0x5d95('0x71');var _0x3980ef=[];var _0x288aef=getTagsQuery();var _0x45cd55={'type':db['Sequelize']['QueryTypes']['SELECT'],'raw':!![]};var _0x196714=[];var _0x2e113a=[];return db[_0x5d95('0x72')][_0x5d95('0x73')](_0x288aef[_0x5d95('0x74')](),_0x45cd55)[_0x5d95('0x5f')](function(_0x5c93d2){_0x3980ef=_[_0x5d95('0x75')](_0x5c93d2,'id');_0x45cd55=_[_0x5d95('0x76')](_0x45cd55,{'model':db[_0x577a77],'mapToModel':!![],'nest':!![]});if(_0xc9fe20[_0x5d95('0x60')]){_0x1fb9d4[_0x5d95('0x77')][_0x5d95('0x29')](function(_0x578846){_0x2d0f35[_0x5d95('0xa')]('i.'+_0x578846);});}else{_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x78'),_0x5d95('0x79'));_0x2d0f35['field'](_0x5d95('0x7a'),'Account.key');_0x2d0f35[_0x5d95('0xa')]('a.mandatoryDisposition','Account.mandatoryDisposition');if(_0x47eaf9==='mail'){_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x7b'),'Account.email');_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x7c'),_0x5d95('0x7d'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x7e'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x7f'));_0x2d0f35['field'](_0x5d95('0x80'));_0x2d0f35['field'](_0x5d95('0x81'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x82'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x83'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x84'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x85'));_0x2d0f35[_0x5d95('0xa')]('i.subject');_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x6a'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x69'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x86'));_0x2d0f35['field'](_0x5d95('0x6c'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x87'));_0x2d0f35[_0x5d95('0xa')]('i.ContactId');_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x88'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x89'));}else if(_0x47eaf9===_0x5d95('0x32')){_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x8a'),_0x5d95('0x7d'));}else{_0x2d0f35['field'](_0x5d95('0x8b'),'contactName');}if(_0x47eaf9!==_0x5d95('0x36')){_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x8c'));}_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x8d'),_0x5d95('0x8e'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x8f'),_0x5d95('0x90'));_0x2d0f35['field'](_0x5d95('0x91'),_0x5d95('0x92'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x93'),_0x5d95('0x94'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x95'),_0x5d95('0x96'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x97'),_0x5d95('0x98'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x99'),_0x5d95('0x9a'));_0x2d0f35[_0x5d95('0xa')](_0x5d95('0x9b'),_0x5d95('0x9c'));_0x2d0f35['field'](_0x5d95('0x9d'),'TagIds');}if(_0x1fb9d4['limit']){_0x2d0f35[_0x5d95('0x9e')](_0x1fb9d4[_0x5d95('0x9e')]);}if(_0x1fb9d4[_0x5d95('0x9f')]){_0x2d0f35[_0x5d95('0x9f')](_0x1fb9d4[_0x5d95('0x9f')]);}return db['sequelize'][_0x5d95('0x73')](_0x2d0f35[_0x5d95('0x74')](),_0x45cd55);})[_0x5d95('0x5f')](function(_0x3a3408){_0x196714=_0x3a3408;var _0x361651=getUsersQuery(_0x47eaf9,_0x196714);return db[_0x5d95('0x72')][_0x5d95('0x73')](_0x361651['toString'](),_0x45cd55);})['then'](function(_0x71ef82){_0x2e113a=_[_0x5d95('0xa0')](_0x71ef82,_0x1e1dfe);if(_0x47eaf9===_0x5d95('0x36')){return db[_0x5d95('0xa1')]['findOne']({'attributes':[_0x5d95('0xa2')],'raw':!![]});}})[_0x5d95('0x5f')](function(_0x128040){var _0x236c5f=_0x128040?_0x128040[_0x5d95('0xa2')]:undefined;var _0x489f93=_0x196714[_0x5d95('0x4c')](function(_0x59aa90){return updateInteraction(_0x59aa90,_0x3980ef,_0x2e113a,_0x236c5f);});return Promise['all'](_0x489f93);});}function countFilteredInteractions(_0x2a1596,_0x150f0b){var _0x198a8f=_0x2a1596[_0x5d95('0xa3')]();_0x198a8f[_0x5d95('0xa')](_0x5d95('0xa4'));_0x198a8f[_0x5d95('0xa')](_0x5d95('0x78'),_0x5d95('0x79'));var _0x366074=utils[_0x5d95('0x28')](_0x150f0b);if(!_[_0x5d95('0xa5')](_0x366074)){_0x198a8f[_0x5d95('0x18')]('t.id\x20IN\x20?',_0x366074);}var _0x467cdb={'type':db[_0x5d95('0xa6')]['QueryTypes'][_0x5d95('0xa7')],'raw':!![]};return db[_0x5d95('0x72')]['query'](_0x198a8f[_0x5d95('0x74')](),_0x467cdb);}module[_0x5d95('0xa8')]={'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