// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf23c=['left_join','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','messages','me.','interactionsTags','it.','\x20=\x20i.id','expr','replace','{OPERATOR}','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','mail','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','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','conditions','find','buildExpression','default','text','value','start','unreadMessages','read','operator','$substring','split','contact','name','ContactId','type','end','Tag','map','tags','clause','and','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','keys','some','compact','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','resolve','then','fields','tag','filter','chat','Websites','Accounts','role','\x20IS\x20NOT\x20NULL','i.secondDisposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','capitalize','Sequelize','QueryTypes','SELECT','query','toString','keyBy','attributes','forEach','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','i.id','i.updatedAt','i.closed','i.attach','i.lastMsgAt','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','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.firstName','Contact.firstName','c.lastName','c.email','Contact.email','c.phone','c.mobile','Contact.fax','o.fullname','Owner.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','sequelize','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','getSelectedTags','isEmpty','t.id\x20IN\x20?','exports','lodash','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','getAccountFK','agent','search','select','field','color','tools_tags','getInteractionFK','_interactions','u.id','u.fullname','ui.','from'];(function(_0x202ea3,_0x38ab41){var _0x58787b=function(_0x1dce0b){while(--_0x1dce0b){_0x202ea3['push'](_0x202ea3['shift']());}};_0x58787b(++_0x38ab41);}(_0xf23c,0x13e));var _0xcf23=function(_0x5c6244,_0x112ab8){_0x5c6244=_0x5c6244-0x0;var _0x5800ce=_0xf23c[_0x5c6244];return _0x5800ce;};'use strict';var _=require(_0xcf23('0x0'));var squel=require('squel');var as=require(_0xcf23('0x1'));var qs=require(_0xcf23('0x2'));var updateInteraction=require(_0xcf23('0x3'))[_0xcf23('0x4')];var utils=require('./utils');var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x3dbca5,_0x326c60,_0xcae9e){var _0x2e6457=![];var _0x4d4575=utils[_0xcf23('0x5')](_0x3dbca5);if(_0x326c60['role']===_0xcf23('0x6')&&!_0xcae9e[_0xcf23('0x7')]&&!_0xcae9e[_0x4d4575]){_0x2e6457=!![];}return _0x2e6457;}function getTagsQuery(){return squel[_0xcf23('0x8')]()[_0xcf23('0x9')]('id')['field']('name')[_0xcf23('0x9')](_0xcf23('0xa'))['from'](_0xcf23('0xb'));}function getUsersQuery(_0x518c55,_0x1e2e1b){var _0x375a34=utils[_0xcf23('0xc')](_0x518c55);var _0x4861ca='user_has_'+_0x518c55+_0xcf23('0xd');var _0x45bdcb=squel['select']()[_0xcf23('0x9')](_0xcf23('0xe'))['field'](_0xcf23('0xf'))[_0xcf23('0x9')](_0xcf23('0x10')+_0x375a34)[_0xcf23('0x11')](_0x4861ca,'ui')[_0xcf23('0x12')](_0xcf23('0x13'),'u',_0xcf23('0x14'));if(_0x1e2e1b[_0xcf23('0x15')]>0x0){_0x45bdcb[_0xcf23('0x16')](_0xcf23('0x10')+_0x375a34+_0xcf23('0x17'),_['map'](_0x1e2e1b,'id'));}return _0x45bdcb;}function getInteractionsQuery(_0x37bb7e){var _0x26f968=utils[_0xcf23('0x18')](_0x37bb7e);var _0x56c08f=utils[_0xcf23('0x5')](_0x37bb7e);var _0x1ec837=utils['getInteractionFK'](_0x37bb7e);return squel[_0xcf23('0x8')]()[_0xcf23('0x11')](_0x26f968[_0xcf23('0x19')],'i')[_0xcf23('0x12')](_0xcf23('0x1a'),'c',_0xcf23('0x1b'))[_0xcf23('0x12')](_0xcf23('0x13'),'o',_0xcf23('0x1c'))[_0xcf23('0x12')](_0x26f968[_0xcf23('0x1d')],'a','a.id\x20=\x20i.'+_0x56c08f)[_0xcf23('0x12')](_0x26f968[_0xcf23('0x1e')],'me',_0xcf23('0x1f')+_0x1ec837+'\x20=\x20i.id')['left_join'](_0x26f968[_0xcf23('0x20')],'it',_0xcf23('0x21')+_0x1ec837+_0xcf23('0x22'))['left_join'](_0xcf23('0xb'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0xe02220={'body':squel[_0xcf23('0x23')](),'contact':squel[_0xcf23('0x23')](),'default':squel[_0xcf23('0x23')](),'fields':squel[_0xcf23('0x23')](),'filter':squel[_0xcf23('0x23')](),'read':squel[_0xcf23('0x23')](),'tags':{'clause':squel[_0xcf23('0x23')](),'ids':null},'user':squel[_0xcf23('0x23')]()};return _0xe02220;}function parseTagParameter(_0x56f392){var _0x1dd560=squel[_0xcf23('0x23')]();if(_0x56f392){var _0xd4b243=utils['getSelectedTags'](_0x56f392);_0xd4b243['forEach'](function(_0x52867d){_0x1dd560['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x52867d+',%');});}return _0x1dd560;}function parseReadParameter(_0x3a95bc){var _0x3963cb='';if(_0x3a95bc){_0x3963cb='unreadMessages\x20{OPERATOR}\x200';if(_0x3a95bc==='1'){_0x3963cb=_0x3963cb['replace']('{OPERATOR}','=');}else{_0x3963cb=_0x3963cb[_0xcf23('0x24')](_0xcf23('0x25'),'>');}}return _0x3963cb;}function parseSearchFilter(_0x3c5411,_0x5c7078){var _0x3c117e=squel['expr']();if(_0x5c7078){var _0x5b7429=_0x5c7078[_0xcf23('0x24')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');var _0x21eda5=qs[_0xcf23('0x26')](_0x5b7429);if(qs[_0xcf23('0x27')](_0x5b7429)){_0x3c117e['or'](_0xcf23('0x28'),_0x21eda5+'%');if([_0xcf23('0x29'),_0xcf23('0x2a')][_0xcf23('0x2b')](_0x3c5411)){_0x3c117e['or']('i.phone\x20LIKE\x20?',_0x21eda5+'%');}else if(_0x3c5411==='fax'){_0x3c117e['or'](_0xcf23('0x2c'),_0x21eda5+'%');}else if(_0x3c5411===_0xcf23('0x2d')){_0x3c117e['or'](_0xcf23('0x2e'),_0x21eda5+'%');}}else if(_0x3c5411===_0xcf23('0x2f')&&qs[_0xcf23('0x30')](_0x5b7429)){_0x3c117e['or'](_0xcf23('0x31'),_0x21eda5+'%');}else{if(_0x3c5411===_0xcf23('0x2f')){_0x3c117e['or'](_0xcf23('0x32'),qs['getFullTextValue'](_0x5b7429,!![]))['or'](_0xcf23('0x33'),qs[_0xcf23('0x34')](_0x5b7429));}else if(_0x3c5411!=='fax'){_0x3c117e['or'](_0xcf23('0x35'),qs['getFullTextValue'](_0x5b7429));}_0x3c117e['or'](_0xcf23('0x36'),qs[_0xcf23('0x34')](_0x5b7429,!![]),null);}}return _0x3c117e;}function parseAdvancedSearchFilter(_0x3d4c6f,_0x3967f3){var _0x11a551=getSqlClauses();var _0xaa23e=as[_0xcf23('0x37')](_0x3d4c6f);var _0x3d9133=_0xaa23e['sqlOperator'];for(var _0x2b56ba=0x0;_0x2b56ba<_0xaa23e['conditions']['length'];_0x2b56ba++){var _0x29a59d=_0xaa23e[_0xcf23('0x38')][_0x2b56ba];var _0x46c781='i';var _0x279387=_[_0xcf23('0x39')](_0x3967f3,['name',_0x29a59d[_0xcf23('0x9')]]);if(_0x279387){var _0x10e683=as[_0xcf23('0x3a')](_0x46c781,_0x279387['type'],_0x29a59d);_0x11a551[_0xcf23('0x3b')][_0x3d9133](_0x10e683[_0xcf23('0x3c')],_0x10e683[_0xcf23('0x3d')][_0xcf23('0x3e')],_0x10e683[_0xcf23('0x3d')]['end']);}else{switch(_0x29a59d[_0xcf23('0x9')]){case _0xcf23('0x3f'):var _0xc5019b=parseReadParameter(_0x29a59d[_0xcf23('0x3d')]);_0x11a551[_0xcf23('0x40')]['and'](_0xc5019b);break;case'Contact':if(_0x29a59d[_0xcf23('0x41')]===_0xcf23('0x42')){if(_0x29a59d['value'][_0xcf23('0x43')]('\x20')[_0xcf23('0x15')]>0x1){_0x11a551['contact'][_0x3d9133]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xcf23('0x34')](_0x29a59d[_0xcf23('0x3d')],!![]),null);}else{var _0x2c563d='%'+_0x29a59d['value']+'%';_0x11a551[_0xcf23('0x44')][_0x3d9133]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x2c563d,_0x2c563d,_0x2c563d);}}else{_0x279387=_[_0xcf23('0x39')](_0x3967f3,[_0xcf23('0x45'),_0xcf23('0x46')]);_0x29a59d[_0xcf23('0x9')]=_0xcf23('0x46');_0x10e683=as[_0xcf23('0x3a')](_0x46c781,_0x279387[_0xcf23('0x47')],_0x29a59d);_0x11a551[_0xcf23('0x44')][_0x3d9133](_0x10e683[_0xcf23('0x3c')],_0x10e683['value'][_0xcf23('0x3e')],_0x10e683[_0xcf23('0x3d')][_0xcf23('0x48')]);}break;case _0xcf23('0x49'):var _0x58fa72=_0x29a59d['value'][_0xcf23('0x43')](',')[_0xcf23('0x4a')](function(_0x3b75f5){return Number(_0x3b75f5);});var _0x67d989=parseTagParameter(_0x58fa72);_0x11a551[_0xcf23('0x4b')][_0xcf23('0x4c')][_0xcf23('0x4d')](_0x67d989);_0x11a551['tags'][_0xcf23('0x4e')]=_0x58fa72;break;case _0xcf23('0x4f'):if(_0x29a59d[_0xcf23('0x41')]===_0xcf23('0x42')){_0x11a551[_0xcf23('0x50')][_0x3d9133](_0xcf23('0x51'),'%'+_0x29a59d[_0xcf23('0x3d')]+'%',null);}else{_0x279387=_[_0xcf23('0x39')](_0x3967f3,[_0xcf23('0x45'),'UserId']);_0x29a59d['field']=_0xcf23('0x52');_0x10e683=as[_0xcf23('0x3a')](_0x46c781,_0x279387['type'],_0x29a59d);_0x11a551['user'][_0x3d9133](_0x10e683['text'],_0x10e683[_0xcf23('0x3d')][_0xcf23('0x3e')],_0x10e683['value'][_0xcf23('0x48')]);}break;case _0xcf23('0x53'):case'plainBody':_0x10e683=as['buildExpression']('me',null,_0x29a59d);_0x11a551[_0xcf23('0x53')][_0x3d9133](_0x10e683[_0xcf23('0x3c')],_0x10e683[_0xcf23('0x3d')][_0xcf23('0x3e')],_0x10e683[_0xcf23('0x3d')][_0xcf23('0x48')]);break;}}}return _0x11a551;}function parseModelFields(_0x3710cc,_0x57c573,_0x1cf3cf){var _0x5c4620=utils[_0xcf23('0x5')](_0x3710cc);var _0x1ee2c1=squel[_0xcf23('0x23')]();var _0x4f47c0=_(_0x57c573)[_0xcf23('0x54')]()[_0xcf23('0x4a')](function(_0x32a709){return _[_0xcf23('0x55')](_0x1cf3cf,['name',_0x32a709])?_0x32a709:undefined;})[_0xcf23('0x56')]()['value']();if(_0x4f47c0[_0xcf23('0x15')]>0x0){_0x4f47c0['forEach'](function(_0x541bf2){if(_0x541bf2===_0x5c4620){_0x1ee2c1[_0xcf23('0x4d')]('i.'+_0x5c4620+'\x20IN\x20?',[]['concat'](_0x57c573[_0x541bf2]));}else if(_0x541bf2===_0xcf23('0x57')){var _0xdbcbea=JSON[_0xcf23('0x58')](_0x57c573[_0x541bf2])[_0xcf23('0x59')];var _0x17ff4b=JSON[_0xcf23('0x58')](_0x57c573[_0x541bf2])[_0xcf23('0x5a')];_0x1ee2c1[_0xcf23('0x4d')](_0xcf23('0x5b'),_0xdbcbea,_0x17ff4b);}else{if(_0x57c573[_0x541bf2]===_0xcf23('0x5c')){_0x1ee2c1[_0xcf23('0x4d')]('i.'+_0x541bf2+_0xcf23('0x5d'));}else{_0x1ee2c1['and']('i.'+_0x541bf2+'\x20=\x20?',_0x57c573[_0x541bf2]);}}});}return _0x1ee2c1;}function parseQueryParameters(_0xedb25d,_0xd17854,_0xacaca8){var _0x563916=getSqlClauses();return Promise[_0xcf23('0x5e')]()[_0xcf23('0x5f')](function(){return parseModelFields(_0xedb25d,_0xd17854,_0xacaca8);})[_0xcf23('0x5f')](function(_0x55c546){_0x563916[_0xcf23('0x60')][_0xcf23('0x4d')](_0x55c546);return parseReadParameter(_0xd17854['read']);})[_0xcf23('0x5f')](function(_0x4e07d7){_0x563916[_0xcf23('0x40')][_0xcf23('0x4d')](_0x4e07d7);return parseTagParameter(_0xd17854[_0xcf23('0x61')]);})[_0xcf23('0x5f')](function(_0x536614){_0x563916[_0xcf23('0x4b')][_0xcf23('0x4c')][_0xcf23('0x4d')](_0x536614);return parseSearchFilter(_0xedb25d,_0xd17854[_0xcf23('0x62')]);})[_0xcf23('0x5f')](function(_0x487041){_0x563916['filter']=_0x487041;return _0x563916;});}function checkAccountsRestrictions(_0x380e20,_0x4f74cd,_0xd9e6a9){var _0x488d58=utils[_0xcf23('0x5')](_0x380e20);var _0x5f521d='get'+_['capitalize'](_0x380e20)+(_0x380e20===_0xcf23('0x63')?_0xcf23('0x64'):_0xcf23('0x65'));var _0x54e0cb=squel[_0xcf23('0x23')]();return Promise['resolve']()[_0xcf23('0x5f')](function(){if(_0xd9e6a9[_0xcf23('0x7')]&&_0x4f74cd[_0xcf23('0x66')]===_0xcf23('0x6')){return _0x4f74cd[_0x5f521d]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x84cf56){if(_0x84cf56){if(_0x84cf56['length']===0x0){_0x54e0cb[_0xcf23('0x4d')]('i.'+_0x488d58+_0xcf23('0x5d'));}else{_0x54e0cb[_0xcf23('0x4d')]('i.'+_0x488d58+_0xcf23('0x17'),_[_0xcf23('0x4a')](_0x84cf56,'id'));}}else if(!_0xd9e6a9[_0x488d58]){_0x54e0cb[_0xcf23('0x4d')]('i.'+_0x488d58+_0xcf23('0x67'));}})['then'](function(){return _0x54e0cb;});}function getClosedOrderClause(_0x4582f9,_0x3ce62a){var _0x462542='';var _0x3e871c=['i.thirdDisposition',_0xcf23('0x68'),'i.disposition'];if(_0x4582f9===_0xcf23('0x2f')){_0x3e871c[_0xcf23('0x69')](_0xcf23('0x6a'));}if(_0x3ce62a['closed']==='0'&&_0x4582f9===_0xcf23('0x2f')){_0x462542=_0xcf23('0x6a');}else{if(_0x3ce62a[_0xcf23('0x6b')]==='1'){_0x3e871c[_0xcf23('0x6c')]();}_0x462542=_0xcf23('0x6d')+_0x3e871c[_0xcf23('0x6e')](',\x20')+')';}return _0x462542;}function getFilteredInteractions(_0x54bebf,_0x5563a4,_0x12542c,_0x112487){var _0x7d77f6=utils['getInteractionFK'](_0x54bebf);var _0x5e81db=_[_0xcf23('0x6f')](_0x54bebf)+'Interaction';var _0x369dea=[];var _0x235476=getTagsQuery();var _0x288ac7={'type':db[_0xcf23('0x70')][_0xcf23('0x71')][_0xcf23('0x72')],'raw':!![]};var _0x12132f=[];var _0x3d7d5d=[];return db['sequelize'][_0xcf23('0x73')](_0x235476[_0xcf23('0x74')](),_0x288ac7)[_0xcf23('0x5f')](function(_0x17da19){_0x369dea=_[_0xcf23('0x75')](_0x17da19,'id');_0x288ac7=_['merge'](_0x288ac7,{'model':db[_0x5e81db],'mapToModel':!![],'nest':!![]});if(_0x12542c[_0xcf23('0x60')]){_0x112487[_0xcf23('0x76')][_0xcf23('0x77')](function(_0x5f522f){_0x5563a4['field']('i.'+_0x5f522f);});}else{_0x5563a4[_0xcf23('0x9')](_0xcf23('0x78'),_0xcf23('0x3f'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x79'),_0xcf23('0x7a'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x7b'),_0xcf23('0x7c'));if(_0x54bebf===_0xcf23('0x2f')){_0x5563a4['field'](_0xcf23('0x7d'),'Account.email');_0x5563a4[_0xcf23('0x9')]('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');_0x5563a4['field'](_0xcf23('0x7e'));_0x5563a4[_0xcf23('0x9')]('i.createdAt');_0x5563a4[_0xcf23('0x9')](_0xcf23('0x7f'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x80'));_0x5563a4['field']('i.closedAt');_0x5563a4[_0xcf23('0x9')](_0xcf23('0x81'));_0x5563a4['field'](_0xcf23('0x82'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x83'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x84'));_0x5563a4['field']('i.disposition');_0x5563a4[_0xcf23('0x9')](_0xcf23('0x68'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x85'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x6a'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x86'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x87'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x88'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x89'));}else if(_0x54bebf===_0xcf23('0x2d')){_0x5563a4[_0xcf23('0x9')](_0xcf23('0x8a'),_0xcf23('0x8b'));}else{_0x5563a4[_0xcf23('0x9')](_0xcf23('0x8c'),_0xcf23('0x8b'));}if(_0x54bebf!==_0xcf23('0x2f')){_0x5563a4[_0xcf23('0x9')](_0xcf23('0x8d'));}_0x5563a4['field'](_0xcf23('0x8e'),_0xcf23('0x8f'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x90'),'Contact.lastName');_0x5563a4['field'](_0xcf23('0x91'),_0xcf23('0x92'));_0x5563a4['field'](_0xcf23('0x93'),'Contact.phone');_0x5563a4[_0xcf23('0x9')](_0xcf23('0x94'),'Contact.mobile');_0x5563a4[_0xcf23('0x9')]('c.fax',_0xcf23('0x95'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x96'),_0xcf23('0x97'));_0x5563a4[_0xcf23('0x9')]('o.internal',_0xcf23('0x98'));_0x5563a4[_0xcf23('0x9')](_0xcf23('0x99'),_0xcf23('0x9a'));}if(_0x112487[_0xcf23('0x9b')]){_0x5563a4['limit'](_0x112487[_0xcf23('0x9b')]);}if(_0x112487[_0xcf23('0x9c')]){_0x5563a4[_0xcf23('0x9c')](_0x112487['offset']);}return db[_0xcf23('0x9d')]['query'](_0x5563a4[_0xcf23('0x74')](),_0x288ac7);})[_0xcf23('0x5f')](function(_0x1f58c2){_0x12132f=_0x1f58c2;var _0x352d7c=getUsersQuery(_0x54bebf,_0x12132f);return db[_0xcf23('0x9d')][_0xcf23('0x73')](_0x352d7c[_0xcf23('0x74')](),_0x288ac7);})[_0xcf23('0x5f')](function(_0x17b013){_0x3d7d5d=_['groupBy'](_0x17b013,_0x7d77f6);if(_0x54bebf===_0xcf23('0x2f')){return db[_0xcf23('0x9e')][_0xcf23('0x9f')]({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0xcf23('0x5f')](function(_0x438710){var _0x1a501e=_0x438710?_0x438710[_0xcf23('0xa0')]:undefined;var _0x33b377=_0x12132f[_0xcf23('0x4a')](function(_0x291451){return updateInteraction(_0x291451,_0x369dea,_0x3d7d5d,_0x1a501e);});return Promise[_0xcf23('0xa1')](_0x33b377);});}function countFilteredInteractions(_0x982b4,_0x1a7f6e){var _0x5192ae=_0x982b4[_0xcf23('0xa2')]();_0x5192ae[_0xcf23('0x9')](_0xcf23('0xa3'));_0x5192ae['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');var _0x4ba727=utils[_0xcf23('0xa4')](_0x1a7f6e);if(!_[_0xcf23('0xa5')](_0x4ba727)){_0x5192ae['where'](_0xcf23('0xa6'),_0x4ba727);}var _0x2576ab={'type':db['Sequelize'][_0xcf23('0x71')][_0xcf23('0x72')],'raw':!![]};return db[_0xcf23('0x9d')][_0xcf23('0x73')](_0x5192ae[_0xcf23('0x74')](),_0x2576ab);}module[_0xcf23('0xa7')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x869e=['type','default','text','start','value','unreadMessages','and','Contact','$substring','split','contact','ContactId','end','Tag','tags','clause','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','compact','\x20IN\x20?','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','then','fields','read','filter','get','capitalize','chat','Websites','Accounts','resolve','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','Interaction','Sequelize','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','a.email','contactName','i.id','i.createdAt','i.closed','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.subject','i.to','i.ContactId','i.MailAccountId','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','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','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','Contact.mobile','c.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','groupBy','Setting','findOne','enableEmailPreview','all','COUNT(*)','t.id\x20IN\x20?','QueryTypes','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','name','color','from','tools_tags','user_has_','_interactions','u.id','ui.','left_join','u.id\x20=\x20ui.UserId','map','getInteractionsTables','getInteractionFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','replace','{OPERATOR}','escapeLIKESpecialChars','sms','whatsapp','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','i.from\x20LIKE\x20?','c.email\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','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','conditions','length','find','buildExpression'];(function(_0x5ba206,_0x19ae8b){var _0x52c199=function(_0x5a06a5){while(--_0x5a06a5){_0x5ba206['push'](_0x5ba206['shift']());}};_0x52c199(++_0x19ae8b);}(_0x869e,0x1b0));var _0xe869=function(_0x9ffa53,_0x5d2878){_0x9ffa53=_0x9ffa53-0x0;var _0x5bc2f9=_0x869e[_0x9ffa53];return _0x5bc2f9;};'use strict';var _=require(_0xe869('0x0'));var squel=require(_0xe869('0x1'));var as=require(_0xe869('0x2'));var qs=require(_0xe869('0x3'));var updateInteraction=require(_0xe869('0x4'))[_0xe869('0x5')];var utils=require(_0xe869('0x6'));var db=require(_0xe869('0x7'))['db'];function skipInteractionsQuery(_0x5c1230,_0x5ae504,_0x4ce6af){var _0x30bafb=![];var _0x402ebe=utils[_0xe869('0x8')](_0x5c1230);if(_0x5ae504[_0xe869('0x9')]===_0xe869('0xa')&&!_0x4ce6af[_0xe869('0xb')]&&!_0x4ce6af[_0x402ebe]){_0x30bafb=!![];}return _0x30bafb;}function getTagsQuery(){return squel[_0xe869('0xc')]()[_0xe869('0xd')]('id')[_0xe869('0xd')](_0xe869('0xe'))[_0xe869('0xd')](_0xe869('0xf'))[_0xe869('0x10')](_0xe869('0x11'));}function getUsersQuery(_0x1f16c1,_0x19fc36){var _0x169899=utils['getInteractionFK'](_0x1f16c1);var _0x5b39a0=_0xe869('0x12')+_0x1f16c1+_0xe869('0x13');var _0x9eb474=squel[_0xe869('0xc')]()['field'](_0xe869('0x14'))[_0xe869('0xd')]('u.fullname')['field'](_0xe869('0x15')+_0x169899)[_0xe869('0x10')](_0x5b39a0,'ui')[_0xe869('0x16')]('users','u',_0xe869('0x17'));if(_0x19fc36['length']>0x0){_0x9eb474['where']('ui.'+_0x169899+'\x20IN\x20?',_[_0xe869('0x18')](_0x19fc36,'id'));}return _0x9eb474;}function getInteractionsQuery(_0x5f0a67){var _0x4248b8=utils[_0xe869('0x19')](_0x5f0a67);var _0x238255=utils[_0xe869('0x8')](_0x5f0a67);var _0x52c24c=utils[_0xe869('0x1a')](_0x5f0a67);return squel[_0xe869('0xc')]()[_0xe869('0x10')](_0x4248b8[_0xe869('0x1b')],'i')[_0xe869('0x16')](_0xe869('0x1c'),'c',_0xe869('0x1d'))['left_join'](_0xe869('0x1e'),'o',_0xe869('0x1f'))[_0xe869('0x16')](_0x4248b8[_0xe869('0x20')],'a',_0xe869('0x21')+_0x238255)[_0xe869('0x16')](_0x4248b8[_0xe869('0x22')],'me',_0xe869('0x23')+_0x52c24c+_0xe869('0x24'))[_0xe869('0x16')](_0x4248b8[_0xe869('0x25')],'it',_0xe869('0x26')+_0x52c24c+_0xe869('0x24'))['left_join'](_0xe869('0x11'),'t',_0xe869('0x27'));}function getSqlClauses(){var _0xc4a8a8={'body':squel[_0xe869('0x28')](),'contact':squel[_0xe869('0x28')](),'default':squel['expr'](),'fields':squel[_0xe869('0x28')](),'filter':squel[_0xe869('0x28')](),'read':squel[_0xe869('0x28')](),'tags':{'clause':squel[_0xe869('0x28')](),'ids':null},'user':squel[_0xe869('0x28')]()};return _0xc4a8a8;}function parseTagParameter(_0x111113){var _0x463641=squel[_0xe869('0x28')]();if(_0x111113){var _0x56126c=utils[_0xe869('0x29')](_0x111113);_0x56126c['forEach'](function(_0x4be34b){_0x463641['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x4be34b+',%');});}return _0x463641;}function parseReadParameter(_0x616b40){var _0x4e0a91='';if(_0x616b40){_0x4e0a91='unreadMessages\x20{OPERATOR}\x200';if(_0x616b40==='1'){_0x4e0a91=_0x4e0a91[_0xe869('0x2a')](_0xe869('0x2b'),'=');}else{_0x4e0a91=_0x4e0a91[_0xe869('0x2a')](_0xe869('0x2b'),'>');}}return _0x4e0a91;}function parseSearchFilter(_0x69a3fe,_0x335bd8){var _0x19465a=squel[_0xe869('0x28')]();if(_0x335bd8){var _0x5b2e8e=_0x335bd8[_0xe869('0x2a')]('\x5c','\x5c\x5c')[_0xe869('0x2a')](/'/g,'\x27\x27');var _0x3463e1=qs[_0xe869('0x2c')](_0x5b2e8e);if(qs['isNumeric'](_0x5b2e8e)){_0x19465a['or']('i.id\x20LIKE\x20?',_0x3463e1+'%');if([_0xe869('0x2d'),_0xe869('0x2e')]['includes'](_0x69a3fe)){_0x19465a['or'](_0xe869('0x2f'),_0x3463e1+'%');}else if(_0x69a3fe===_0xe869('0x30')){_0x19465a['or'](_0xe869('0x31'),_0x3463e1+'%');}else if(_0x69a3fe==='openchannel'){_0x19465a['or'](_0xe869('0x32'),_0x3463e1+'%');}}else if(_0x69a3fe==='mail'&&qs['isEmail'](_0x5b2e8e)){_0x19465a['or'](_0xe869('0x33'),_0x3463e1+'%');}else{if(_0x69a3fe===_0xe869('0x34')){_0x19465a['or'](_0xe869('0x35'),qs['getFullTextValue'](_0x5b2e8e,!![]))['or'](_0xe869('0x36'),qs[_0xe869('0x37')](_0x5b2e8e));}else if(_0x69a3fe!==_0xe869('0x30')){_0x19465a['or'](_0xe869('0x38'),qs[_0xe869('0x37')](_0x5b2e8e));}_0x19465a['or'](_0xe869('0x39'),qs[_0xe869('0x37')](_0x5b2e8e,!![]),null);}}return _0x19465a;}function parseAdvancedSearchFilter(_0x3a5878,_0x5aa2b5){var _0x3144e8=getSqlClauses();var _0x53ac03=as[_0xe869('0x3a')](_0x3a5878);var _0x127cef=_0x53ac03['sqlOperator'];for(var _0x283d77=0x0;_0x283d77<_0x53ac03[_0xe869('0x3b')][_0xe869('0x3c')];_0x283d77++){var _0x288cc4=_0x53ac03[_0xe869('0x3b')][_0x283d77];var _0x3552be='i';var _0x37d95c=_[_0xe869('0x3d')](_0x5aa2b5,[_0xe869('0xe'),_0x288cc4['field']]);if(_0x37d95c){var _0xd384ff=as[_0xe869('0x3e')](_0x3552be,_0x37d95c[_0xe869('0x3f')],_0x288cc4);_0x3144e8[_0xe869('0x40')][_0x127cef](_0xd384ff[_0xe869('0x41')],_0xd384ff['value'][_0xe869('0x42')],_0xd384ff[_0xe869('0x43')]['end']);}else{switch(_0x288cc4['field']){case _0xe869('0x44'):var _0x55adcc=parseReadParameter(_0x288cc4[_0xe869('0x43')]);_0x3144e8['read'][_0xe869('0x45')](_0x55adcc);break;case _0xe869('0x46'):if(_0x288cc4['operator']===_0xe869('0x47')){if(_0x288cc4['value'][_0xe869('0x48')]('\x20')[_0xe869('0x3c')]>0x1){_0x3144e8[_0xe869('0x49')][_0x127cef]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xe869('0x37')](_0x288cc4['value'],!![]),null);}else{var _0x4e9559='%'+_0x288cc4['value']+'%';_0x3144e8['contact'][_0x127cef]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x4e9559,_0x4e9559,_0x4e9559);}}else{_0x37d95c=_[_0xe869('0x3d')](_0x5aa2b5,['name',_0xe869('0x4a')]);_0x288cc4['field']=_0xe869('0x4a');_0xd384ff=as['buildExpression'](_0x3552be,_0x37d95c[_0xe869('0x3f')],_0x288cc4);_0x3144e8['contact'][_0x127cef](_0xd384ff[_0xe869('0x41')],_0xd384ff[_0xe869('0x43')]['start'],_0xd384ff[_0xe869('0x43')][_0xe869('0x4b')]);}break;case _0xe869('0x4c'):var _0x2d45ab=_0x288cc4[_0xe869('0x43')][_0xe869('0x48')](',')[_0xe869('0x18')](function(_0x1906ef){return Number(_0x1906ef);});var _0x134050=parseTagParameter(_0x2d45ab);_0x3144e8[_0xe869('0x4d')][_0xe869('0x4e')][_0xe869('0x45')](_0x134050);_0x3144e8[_0xe869('0x4d')]['ids']=_0x2d45ab;break;case _0xe869('0x4f'):if(_0x288cc4['operator']===_0xe869('0x47')){_0x3144e8[_0xe869('0x50')][_0x127cef](_0xe869('0x51'),'%'+_0x288cc4['value']+'%',null);}else{_0x37d95c=_['find'](_0x5aa2b5,[_0xe869('0xe'),_0xe869('0x52')]);_0x288cc4[_0xe869('0xd')]=_0xe869('0x52');_0xd384ff=as['buildExpression'](_0x3552be,_0x37d95c[_0xe869('0x3f')],_0x288cc4);_0x3144e8[_0xe869('0x50')][_0x127cef](_0xd384ff[_0xe869('0x41')],_0xd384ff[_0xe869('0x43')][_0xe869('0x42')],_0xd384ff[_0xe869('0x43')][_0xe869('0x4b')]);}break;case _0xe869('0x53'):case _0xe869('0x54'):_0xd384ff=as['buildExpression']('me',null,_0x288cc4);_0x3144e8[_0xe869('0x53')][_0x127cef](_0xd384ff['text'],_0xd384ff[_0xe869('0x43')][_0xe869('0x42')],_0xd384ff[_0xe869('0x43')][_0xe869('0x4b')]);break;}}}return _0x3144e8;}function parseModelFields(_0x11f840,_0x8b068c,_0x40fb0d){var _0x44b515=utils[_0xe869('0x8')](_0x11f840);var _0x27dd4b=squel[_0xe869('0x28')]();var _0xb53a85=_(_0x8b068c)['keys']()[_0xe869('0x18')](function(_0x4b8734){return _['some'](_0x40fb0d,[_0xe869('0xe'),_0x4b8734])?_0x4b8734:undefined;})[_0xe869('0x55')]()[_0xe869('0x43')]();if(_0xb53a85[_0xe869('0x3c')]>0x0){_0xb53a85['forEach'](function(_0x9b17c9){if(_0x9b17c9===_0x44b515){_0x27dd4b[_0xe869('0x45')]('i.'+_0x44b515+_0xe869('0x56'),[]['concat'](_0x8b068c[_0x9b17c9]));}else if(_0x9b17c9===_0xe869('0x57')){var _0xf79fcc=JSON[_0xe869('0x58')](_0x8b068c[_0x9b17c9])[_0xe869('0x59')];var _0x40f4bb=JSON['parse'](_0x8b068c[_0x9b17c9])['$lte'];_0x27dd4b[_0xe869('0x45')](_0xe869('0x5a'),_0xf79fcc,_0x40f4bb);}else{if(_0x8b068c[_0x9b17c9]==='null'){_0x27dd4b[_0xe869('0x45')]('i.'+_0x9b17c9+_0xe869('0x5b'));}else{_0x27dd4b[_0xe869('0x45')]('i.'+_0x9b17c9+_0xe869('0x5c'),_0x8b068c[_0x9b17c9]);}}});}return _0x27dd4b;}function parseQueryParameters(_0x5d5716,_0x37d65e,_0x108429){var _0x39a4ce=getSqlClauses();return Promise['resolve']()[_0xe869('0x5d')](function(){return parseModelFields(_0x5d5716,_0x37d65e,_0x108429);})[_0xe869('0x5d')](function(_0x93f09e){_0x39a4ce[_0xe869('0x5e')][_0xe869('0x45')](_0x93f09e);return parseReadParameter(_0x37d65e[_0xe869('0x5f')]);})['then'](function(_0x42fdb9){_0x39a4ce[_0xe869('0x5f')][_0xe869('0x45')](_0x42fdb9);return parseTagParameter(_0x37d65e['tag']);})[_0xe869('0x5d')](function(_0x5e6917){_0x39a4ce[_0xe869('0x4d')][_0xe869('0x4e')][_0xe869('0x45')](_0x5e6917);return parseSearchFilter(_0x5d5716,_0x37d65e[_0xe869('0x60')]);})['then'](function(_0x3a2603){_0x39a4ce['filter']=_0x3a2603;return _0x39a4ce;});}function checkAccountsRestrictions(_0x5466a1,_0x388817,_0x477453){var _0x4a1485=utils[_0xe869('0x8')](_0x5466a1);var _0x255f18=_0xe869('0x61')+_[_0xe869('0x62')](_0x5466a1)+(_0x5466a1===_0xe869('0x63')?_0xe869('0x64'):_0xe869('0x65'));var _0x4831cf=squel[_0xe869('0x28')]();return Promise[_0xe869('0x66')]()[_0xe869('0x5d')](function(){if(_0x477453[_0xe869('0xb')]&&_0x388817[_0xe869('0x9')]===_0xe869('0xa')){return _0x388817[_0x255f18]({'attributes':['id'],'raw':!![]});}})[_0xe869('0x5d')](function(_0x403f30){if(_0x403f30){if(_0x403f30['length']===0x0){_0x4831cf[_0xe869('0x45')]('i.'+_0x4a1485+'\x20IS\x20NULL');}else{_0x4831cf[_0xe869('0x45')]('i.'+_0x4a1485+_0xe869('0x56'),_[_0xe869('0x18')](_0x403f30,'id'));}}else if(!_0x477453[_0x4a1485]){_0x4831cf[_0xe869('0x45')]('i.'+_0x4a1485+_0xe869('0x67'));}})[_0xe869('0x5d')](function(){return _0x4831cf;});}function getClosedOrderClause(_0x5888e3,_0xf799e2){var _0x3c8a89='';var _0x1266d9=[_0xe869('0x68'),_0xe869('0x69'),_0xe869('0x6a')];if(_0x5888e3===_0xe869('0x34')){_0x1266d9['unshift'](_0xe869('0x6b'));}if(_0xf799e2['closed']==='0'&&_0x5888e3==='mail'){_0x3c8a89=_0xe869('0x6b');}else{if(_0xf799e2[_0xe869('0x6c')]==='1'){_0x1266d9[_0xe869('0x6d')]();}_0x3c8a89=_0xe869('0x6e')+_0x1266d9['join'](',\x20')+')';}return _0x3c8a89;}function getFilteredInteractions(_0x317ac0,_0x4b722c,_0x9d0b57,_0xe259ce){var _0x9896bc=utils[_0xe869('0x1a')](_0x317ac0);var _0xa1d97d=_[_0xe869('0x62')](_0x317ac0)+_0xe869('0x6f');var _0x51c9cb=[];var _0x26385b=getTagsQuery();var _0x5ab39b={'type':db[_0xe869('0x70')]['QueryTypes']['SELECT'],'raw':!![]};var _0x234679=[];var _0x44e158=[];return db[_0xe869('0x71')][_0xe869('0x72')](_0x26385b[_0xe869('0x73')](),_0x5ab39b)['then'](function(_0x4cdbf6){_0x51c9cb=_[_0xe869('0x74')](_0x4cdbf6,'id');_0x5ab39b=_[_0xe869('0x75')](_0x5ab39b,{'model':db[_0xa1d97d],'mapToModel':!![],'nest':!![]});if(_0x9d0b57[_0xe869('0x5e')]){_0xe259ce[_0xe869('0x76')]['forEach'](function(_0x1b9a54){_0x4b722c[_0xe869('0xd')]('i.'+_0x1b9a54);});}else{_0x4b722c[_0xe869('0xd')](_0xe869('0x77'),_0xe869('0x44'));_0x4b722c['field'](_0xe869('0x78'),_0xe869('0x79'));_0x4b722c['field'](_0xe869('0x7a'),'Account.mandatoryDisposition');if(_0x317ac0===_0xe869('0x34')){_0x4b722c[_0xe869('0xd')](_0xe869('0x7b'),'Account.email');_0x4b722c[_0xe869('0xd')]('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',_0xe869('0x7c'));_0x4b722c[_0xe869('0xd')](_0xe869('0x7d'));_0x4b722c[_0xe869('0xd')](_0xe869('0x7e'));_0x4b722c[_0xe869('0xd')]('i.updatedAt');_0x4b722c['field'](_0xe869('0x7f'));_0x4b722c[_0xe869('0xd')](_0xe869('0x80'));_0x4b722c[_0xe869('0xd')]('i.attach');_0x4b722c['field'](_0xe869('0x81'));_0x4b722c['field'](_0xe869('0x82'));_0x4b722c[_0xe869('0xd')](_0xe869('0x83'));_0x4b722c['field']('i.disposition');_0x4b722c[_0xe869('0xd')](_0xe869('0x69'));_0x4b722c[_0xe869('0xd')]('i.thirdDisposition');_0x4b722c[_0xe869('0xd')](_0xe869('0x6b'));_0x4b722c['field'](_0xe869('0x84'));_0x4b722c[_0xe869('0xd')](_0xe869('0x85'));_0x4b722c[_0xe869('0xd')](_0xe869('0x86'));_0x4b722c[_0xe869('0xd')]('i.UserId');}else if(_0x317ac0===_0xe869('0x87')){_0x4b722c[_0xe869('0xd')](_0xe869('0x88'),_0xe869('0x7c'));}else{_0x4b722c[_0xe869('0xd')](_0xe869('0x89'),_0xe869('0x7c'));}if(_0x317ac0!==_0xe869('0x34')){_0x4b722c[_0xe869('0xd')](_0xe869('0x8a'));}_0x4b722c[_0xe869('0xd')](_0xe869('0x8b'),_0xe869('0x8c'));_0x4b722c['field']('c.lastName',_0xe869('0x8d'));_0x4b722c[_0xe869('0xd')](_0xe869('0x8e'),_0xe869('0x8f'));_0x4b722c['field']('c.phone',_0xe869('0x90'));_0x4b722c['field'](_0xe869('0x91'),_0xe869('0x92'));_0x4b722c[_0xe869('0xd')](_0xe869('0x93'),'Contact.fax');_0x4b722c['field'](_0xe869('0x94'),_0xe869('0x95'));_0x4b722c[_0xe869('0xd')](_0xe869('0x96'),_0xe869('0x97'));_0x4b722c[_0xe869('0xd')](_0xe869('0x98'),_0xe869('0x99'));}if(_0xe259ce[_0xe869('0x9a')]){_0x4b722c[_0xe869('0x9a')](_0xe259ce[_0xe869('0x9a')]);}if(_0xe259ce[_0xe869('0x9b')]){_0x4b722c[_0xe869('0x9b')](_0xe259ce['offset']);}return db[_0xe869('0x71')]['query'](_0x4b722c['toString'](),_0x5ab39b);})[_0xe869('0x5d')](function(_0x188eaa){_0x234679=_0x188eaa;var _0x5b6cb2=getUsersQuery(_0x317ac0,_0x234679);return db[_0xe869('0x71')][_0xe869('0x72')](_0x5b6cb2['toString'](),_0x5ab39b);})[_0xe869('0x5d')](function(_0x55aeb6){_0x44e158=_[_0xe869('0x9c')](_0x55aeb6,_0x9896bc);if(_0x317ac0===_0xe869('0x34')){return db[_0xe869('0x9d')][_0xe869('0x9e')]({'attributes':[_0xe869('0x9f')],'raw':!![]});}})['then'](function(_0x2a32b9){var _0x51cd14=_0x2a32b9?_0x2a32b9['enableEmailPreview']:undefined;var _0x227e13=_0x234679[_0xe869('0x18')](function(_0x464de6){return updateInteraction(_0x464de6,_0x51c9cb,_0x44e158,_0x51cd14);});return Promise[_0xe869('0xa0')](_0x227e13);});}function countFilteredInteractions(_0x14940b,_0x1976a7){var _0x48dfbd=_0x14940b['clone']();_0x48dfbd[_0xe869('0xd')](_0xe869('0xa1'));_0x48dfbd[_0xe869('0xd')](_0xe869('0x77'),_0xe869('0x44'));var _0x3570d6=utils['getSelectedTags'](_0x1976a7);if(!_['isEmpty'](_0x3570d6)){_0x48dfbd['where'](_0xe869('0xa2'),_0x3570d6);}var _0x5ef769={'type':db['Sequelize'][_0xe869('0xa3')]['SELECT'],'raw':!![]};return db[_0xe869('0x71')][_0xe869('0x72')](_0x48dfbd['toString'](),_0x5ef769);}module[_0xe869('0xa4')]={'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