// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8a3c=['merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','Account.mandatoryDisposition','a.email','Account.email','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.id','i.createdAt','i.updatedAt','i.closedAt','i.lastMsgDirection','i.thirdDisposition','i.ContactId','i.MailAccountId','i.UserId','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','c.phone','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','TagIds','limit','offset','sequelize','toString','findOne','enableEmailPreview','clone','COUNT(*)','getSelectedTags','where','t.id\x20IN\x20?','SELECT','exports','lodash','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','agent','search','field','name','color','from','tools_tags','_interactions','u.id','u.fullname','left_join','users','u.id\x20=\x20ui.UserId','ui.','getInteractionsTables','getAccountFK','getInteractionFK','select','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','interactionsTags','it.','expr','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','escapeLIKESpecialChars','i.id\x20LIKE\x20?','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.from\x20LIKE\x20?','mail','c.email\x20LIKE\x20?','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','sqlOperator','conditions','length','find','buildExpression','type','default','text','value','start','end','unreadMessages','read','and','Contact','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','map','tags','ids','user','UserId','body','keys','some','compact','\x20IN\x20?','createdAt','parse','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','clause','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','query','keyBy'];(function(_0x5b644e,_0x2e5e07){var _0x49c6bf=function(_0x3032d9){while(--_0x3032d9){_0x5b644e['push'](_0x5b644e['shift']());}};_0x49c6bf(++_0x2e5e07);}(_0x8a3c,0xcb));var _0xc8a3=function(_0x3a0614,_0x4b6627){_0x3a0614=_0x3a0614-0x0;var _0x12bba7=_0x8a3c[_0x3a0614];return _0x12bba7;};'use strict';var _=require(_0xc8a3('0x0'));var squel=require('squel');var as=require(_0xc8a3('0x1'));var qs=require(_0xc8a3('0x2'));var updateInteraction=require(_0xc8a3('0x3'))[_0xc8a3('0x4')];var utils=require(_0xc8a3('0x5'));var db=require(_0xc8a3('0x6'))['db'];function skipInteractionsQuery(_0x2a17d8,_0x1f4c7d,_0x5b62ee){var _0x163024=![];var _0x931874=utils['getAccountFK'](_0x2a17d8);if(_0x1f4c7d['role']===_0xc8a3('0x7')&&!_0x5b62ee[_0xc8a3('0x8')]&&!_0x5b62ee[_0x931874]){_0x163024=!![];}return _0x163024;}function getTagsQuery(){return squel['select']()[_0xc8a3('0x9')]('id')[_0xc8a3('0x9')](_0xc8a3('0xa'))['field'](_0xc8a3('0xb'))[_0xc8a3('0xc')](_0xc8a3('0xd'));}function getUsersQuery(_0x134d4f,_0x13704f){var _0x39b679=utils['getInteractionFK'](_0x134d4f);var _0x5410fc='user_has_'+_0x134d4f+_0xc8a3('0xe');var _0x105a7b=squel['select']()[_0xc8a3('0x9')](_0xc8a3('0xf'))['field'](_0xc8a3('0x10'))['field']('ui.'+_0x39b679)[_0xc8a3('0xc')](_0x5410fc,'ui')[_0xc8a3('0x11')](_0xc8a3('0x12'),'u',_0xc8a3('0x13'));if(_0x13704f['length']>0x0){_0x105a7b['where'](_0xc8a3('0x14')+_0x39b679+'\x20IN\x20?',_['map'](_0x13704f,'id'));}return _0x105a7b;}function getInteractionsQuery(_0x3feddd){var _0x124f3a=utils[_0xc8a3('0x15')](_0x3feddd);var _0x573f66=utils[_0xc8a3('0x16')](_0x3feddd);var _0x515afe=utils[_0xc8a3('0x17')](_0x3feddd);return squel[_0xc8a3('0x18')]()[_0xc8a3('0xc')](_0x124f3a[_0xc8a3('0x19')],'i')['left_join'](_0xc8a3('0x1a'),'c',_0xc8a3('0x1b'))['left_join'](_0xc8a3('0x12'),'o','o.id\x20=\x20i.UserId')['left_join'](_0x124f3a[_0xc8a3('0x1c')],'a',_0xc8a3('0x1d')+_0x573f66)[_0xc8a3('0x11')](_0x124f3a['messages'],'me',_0xc8a3('0x1e')+_0x515afe+_0xc8a3('0x1f'))['left_join'](_0x124f3a[_0xc8a3('0x20')],'it',_0xc8a3('0x21')+_0x515afe+_0xc8a3('0x1f'))['left_join'](_0xc8a3('0xd'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x2d132f={'body':squel[_0xc8a3('0x22')](),'contact':squel[_0xc8a3('0x22')](),'default':squel[_0xc8a3('0x22')](),'fields':squel['expr'](),'filter':squel[_0xc8a3('0x22')](),'read':squel[_0xc8a3('0x22')](),'tags':{'clause':squel[_0xc8a3('0x22')](),'ids':null},'user':squel[_0xc8a3('0x22')]()};return _0x2d132f;}function parseTagParameter(_0x4231f3){var _0x3e6650=squel['expr']();if(_0x4231f3){var _0x49849f=utils['getSelectedTags'](_0x4231f3);_0x49849f[_0xc8a3('0x23')](function(_0x39f6d3){_0x3e6650['or'](_0xc8a3('0x24'),'%,'+_0x39f6d3+',%');});}return _0x3e6650;}function parseReadParameter(_0xa25341){var _0x536182='';if(_0xa25341){_0x536182=_0xc8a3('0x25');if(_0xa25341==='1'){_0x536182=_0x536182[_0xc8a3('0x26')](_0xc8a3('0x27'),'=');}else{_0x536182=_0x536182[_0xc8a3('0x26')](_0xc8a3('0x27'),'>');}}return _0x536182;}function parseSearchFilter(_0x83af6b,_0x47a6f3){var _0x46a046=squel['expr']();if(_0x47a6f3){var _0x167195=_0x47a6f3[_0xc8a3('0x26')]('\x5c','\x5c\x5c')[_0xc8a3('0x26')](/'/g,'\x27\x27');var _0x5a982c=qs[_0xc8a3('0x28')](_0x167195);if(qs['isNumeric'](_0x167195)){_0x46a046['or'](_0xc8a3('0x29'),_0x5a982c+'%');if(['sms',_0xc8a3('0x2a')][_0xc8a3('0x2b')](_0x83af6b)){_0x46a046['or'](_0xc8a3('0x2c'),_0x5a982c+'%');}else if(_0x83af6b===_0xc8a3('0x2d')){_0x46a046['or']('i.fax\x20LIKE\x20?',_0x5a982c+'%');}else if(_0x83af6b==='openchannel'){_0x46a046['or'](_0xc8a3('0x2e'),_0x5a982c+'%');}}else if(_0x83af6b===_0xc8a3('0x2f')&&qs['isEmail'](_0x167195)){_0x46a046['or'](_0xc8a3('0x30'),_0x5a982c+'%');}else{if(_0x83af6b==='mail'){_0x46a046['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xc8a3('0x31')](_0x167195,!![]))['or'](_0xc8a3('0x32'),qs[_0xc8a3('0x31')](_0x167195));}else if(_0x83af6b!==_0xc8a3('0x2d')){_0x46a046['or'](_0xc8a3('0x33'),qs[_0xc8a3('0x31')](_0x167195));}_0x46a046['or'](_0xc8a3('0x34'),qs[_0xc8a3('0x31')](_0x167195,!![]),null);}}return _0x46a046;}function parseAdvancedSearchFilter(_0x5cd4ec,_0x5dbc67){var _0x349d76=getSqlClauses();var _0x989711=as['parseSearch'](_0x5cd4ec);var _0x3d0af6=_0x989711[_0xc8a3('0x35')];for(var _0x4ee1bf=0x0;_0x4ee1bf<_0x989711[_0xc8a3('0x36')][_0xc8a3('0x37')];_0x4ee1bf++){var _0x479d3f=_0x989711[_0xc8a3('0x36')][_0x4ee1bf];var _0x2147dd='i';var _0x4e8765=_[_0xc8a3('0x38')](_0x5dbc67,[_0xc8a3('0xa'),_0x479d3f[_0xc8a3('0x9')]]);if(_0x4e8765){var _0x59ffa9=as[_0xc8a3('0x39')](_0x2147dd,_0x4e8765[_0xc8a3('0x3a')],_0x479d3f);_0x349d76[_0xc8a3('0x3b')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9[_0xc8a3('0x3d')][_0xc8a3('0x3e')],_0x59ffa9['value'][_0xc8a3('0x3f')]);}else{switch(_0x479d3f[_0xc8a3('0x9')]){case _0xc8a3('0x40'):var _0x5cfab2=parseReadParameter(_0x479d3f[_0xc8a3('0x3d')]);_0x349d76[_0xc8a3('0x41')][_0xc8a3('0x42')](_0x5cfab2);break;case _0xc8a3('0x43'):if(_0x479d3f[_0xc8a3('0x44')]===_0xc8a3('0x45')){if(_0x479d3f[_0xc8a3('0x3d')][_0xc8a3('0x46')]('\x20')[_0xc8a3('0x37')]>0x1){_0x349d76[_0xc8a3('0x47')][_0x3d0af6](_0xc8a3('0x34'),qs[_0xc8a3('0x31')](_0x479d3f[_0xc8a3('0x3d')],!![]),null);}else{var _0x42029b='%'+_0x479d3f['value']+'%';_0x349d76[_0xc8a3('0x47')][_0x3d0af6](_0xc8a3('0x48'),_0x42029b,_0x42029b,_0x42029b);}}else{_0x4e8765=_['find'](_0x5dbc67,['name',_0xc8a3('0x49')]);_0x479d3f[_0xc8a3('0x9')]=_0xc8a3('0x49');_0x59ffa9=as[_0xc8a3('0x39')](_0x2147dd,_0x4e8765['type'],_0x479d3f);_0x349d76[_0xc8a3('0x47')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9[_0xc8a3('0x3d')]['start'],_0x59ffa9['value'][_0xc8a3('0x3f')]);}break;case'Tag':var _0x260ca5=_0x479d3f[_0xc8a3('0x3d')][_0xc8a3('0x46')](',')[_0xc8a3('0x4a')](function(_0x3b6429){return Number(_0x3b6429);});var _0xe10187=parseTagParameter(_0x260ca5);_0x349d76['tags']['clause'][_0xc8a3('0x42')](_0xe10187);_0x349d76[_0xc8a3('0x4b')][_0xc8a3('0x4c')]=_0x260ca5;break;case'User':if(_0x479d3f[_0xc8a3('0x44')]===_0xc8a3('0x45')){_0x349d76[_0xc8a3('0x4d')][_0x3d0af6]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x479d3f[_0xc8a3('0x3d')]+'%',null);}else{_0x4e8765=_[_0xc8a3('0x38')](_0x5dbc67,[_0xc8a3('0xa'),'UserId']);_0x479d3f['field']=_0xc8a3('0x4e');_0x59ffa9=as[_0xc8a3('0x39')](_0x2147dd,_0x4e8765[_0xc8a3('0x3a')],_0x479d3f);_0x349d76[_0xc8a3('0x4d')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9[_0xc8a3('0x3d')][_0xc8a3('0x3e')],_0x59ffa9[_0xc8a3('0x3d')][_0xc8a3('0x3f')]);}break;case _0xc8a3('0x4f'):case'plainBody':_0x59ffa9=as[_0xc8a3('0x39')]('me',null,_0x479d3f);_0x349d76[_0xc8a3('0x4f')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9['value'][_0xc8a3('0x3e')],_0x59ffa9[_0xc8a3('0x3d')]['end']);break;}}}return _0x349d76;}function parseModelFields(_0x176b24,_0x3c4c35,_0x14bf77){var _0x202314=utils['getAccountFK'](_0x176b24);var _0x248898=squel[_0xc8a3('0x22')]();var _0x48a270=_(_0x3c4c35)[_0xc8a3('0x50')]()[_0xc8a3('0x4a')](function(_0x958cbb){return _[_0xc8a3('0x51')](_0x14bf77,[_0xc8a3('0xa'),_0x958cbb])?_0x958cbb:undefined;})[_0xc8a3('0x52')]()[_0xc8a3('0x3d')]();if(_0x48a270[_0xc8a3('0x37')]>0x0){_0x48a270[_0xc8a3('0x23')](function(_0x3e7579){if(_0x3e7579===_0x202314){_0x248898[_0xc8a3('0x42')]('i.'+_0x202314+_0xc8a3('0x53'),[]['concat'](_0x3c4c35[_0x3e7579]));}else if(_0x3e7579===_0xc8a3('0x54')){var _0x1d42d2=JSON['parse'](_0x3c4c35[_0x3e7579])['$gte'];var _0x5f5e18=JSON[_0xc8a3('0x55')](_0x3c4c35[_0x3e7579])['$lte'];_0x248898[_0xc8a3('0x42')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x1d42d2,_0x5f5e18);}else{if(_0x3c4c35[_0x3e7579]===_0xc8a3('0x56')){_0x248898['and']('i.'+_0x3e7579+_0xc8a3('0x57'));}else{_0x248898[_0xc8a3('0x42')]('i.'+_0x3e7579+_0xc8a3('0x58'),_0x3c4c35[_0x3e7579]);}}});}return _0x248898;}function parseQueryParameters(_0x107798,_0x44c04c,_0x34e556){var _0x1fc2e8=getSqlClauses();return Promise[_0xc8a3('0x59')]()[_0xc8a3('0x5a')](function(){return parseModelFields(_0x107798,_0x44c04c,_0x34e556);})[_0xc8a3('0x5a')](function(_0x18df54){_0x1fc2e8[_0xc8a3('0x5b')][_0xc8a3('0x42')](_0x18df54);return parseReadParameter(_0x44c04c[_0xc8a3('0x41')]);})[_0xc8a3('0x5a')](function(_0x12a22a){_0x1fc2e8[_0xc8a3('0x41')][_0xc8a3('0x42')](_0x12a22a);return parseTagParameter(_0x44c04c[_0xc8a3('0x5c')]);})[_0xc8a3('0x5a')](function(_0x317a4f){_0x1fc2e8[_0xc8a3('0x4b')][_0xc8a3('0x5d')][_0xc8a3('0x42')](_0x317a4f);return parseSearchFilter(_0x107798,_0x44c04c['filter']);})[_0xc8a3('0x5a')](function(_0x3850c3){_0x1fc2e8['filter']=_0x3850c3;return _0x1fc2e8;});}function checkAccountsRestrictions(_0x256912,_0xff7e12,_0x199160){var _0x27cfa2=utils[_0xc8a3('0x16')](_0x256912);var _0x128875='get'+_[_0xc8a3('0x5e')](_0x256912)+(_0x256912===_0xc8a3('0x5f')?_0xc8a3('0x60'):_0xc8a3('0x61'));var _0x273136=squel['expr']();return Promise[_0xc8a3('0x59')]()['then'](function(){if(_0x199160[_0xc8a3('0x8')]&&_0xff7e12['role']===_0xc8a3('0x7')){return _0xff7e12[_0x128875]({'attributes':['id'],'raw':!![]});}})[_0xc8a3('0x5a')](function(_0x2e738a){if(_0x2e738a){if(_0x2e738a[_0xc8a3('0x37')]===0x0){_0x273136[_0xc8a3('0x42')]('i.'+_0x27cfa2+'\x20IS\x20NULL');}else{_0x273136[_0xc8a3('0x42')]('i.'+_0x27cfa2+_0xc8a3('0x53'),_[_0xc8a3('0x4a')](_0x2e738a,'id'));}}else if(!_0x199160[_0x27cfa2]){_0x273136[_0xc8a3('0x42')]('i.'+_0x27cfa2+_0xc8a3('0x62'));}})[_0xc8a3('0x5a')](function(){return _0x273136;});}function getClosedOrderClause(_0xfaaf80,_0x5aacad){var _0x5eb1d1='';var _0x3c931e=['i.thirdDisposition',_0xc8a3('0x63'),_0xc8a3('0x64')];if(_0xfaaf80===_0xc8a3('0x2f')){_0x3c931e[_0xc8a3('0x65')]('i.substatus');}if(_0x5aacad['closed']==='0'&&_0xfaaf80==='mail'){_0x5eb1d1='i.substatus';}else{if(_0x5aacad[_0xc8a3('0x66')]==='1'){_0x3c931e[_0xc8a3('0x67')]();}_0x5eb1d1=_0xc8a3('0x68')+_0x3c931e[_0xc8a3('0x69')](',\x20')+')';}return _0x5eb1d1;}function getFilteredInteractions(_0x525d06,_0x3741be,_0x26e53a,_0x394164){var _0x208887=utils[_0xc8a3('0x17')](_0x525d06);var _0x3a9f84=_[_0xc8a3('0x5e')](_0x525d06)+_0xc8a3('0x6a');var _0xdc6112=[];var _0x28e604=getTagsQuery();var _0xaaebc9={'type':db[_0xc8a3('0x6b')][_0xc8a3('0x6c')]['SELECT'],'raw':!![]};var _0x56e759=[];var _0x429c46=[];return db['sequelize'][_0xc8a3('0x6d')](_0x28e604['toString'](),_0xaaebc9)['then'](function(_0x478eab){_0xdc6112=_[_0xc8a3('0x6e')](_0x478eab,'id');_0xaaebc9=_[_0xc8a3('0x6f')](_0xaaebc9,{'model':db[_0x3a9f84],'mapToModel':!![],'nest':!![]});if(_0x26e53a[_0xc8a3('0x5b')]){_0x394164[_0xc8a3('0x70')]['forEach'](function(_0x42ecb3){_0x3741be[_0xc8a3('0x9')]('i.'+_0x42ecb3);});}else{_0x3741be['field'](_0xc8a3('0x71'),_0xc8a3('0x40'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x72'),_0xc8a3('0x73'));_0x3741be['field']('a.mandatoryDisposition',_0xc8a3('0x74'));if(_0x525d06===_0xc8a3('0x2f')){_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x75'),_0xc8a3('0x76'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x77'),_0xc8a3('0x78'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x79'));_0x3741be['field'](_0xc8a3('0x7a'));_0x3741be['field'](_0xc8a3('0x7b'));_0x3741be[_0xc8a3('0x9')]('i.closed');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7c'));_0x3741be['field']('i.attach');_0x3741be['field']('i.lastMsgAt');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7d'));_0x3741be[_0xc8a3('0x9')]('i.subject');_0x3741be[_0xc8a3('0x9')]('i.disposition');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x63'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7e'));_0x3741be[_0xc8a3('0x9')]('i.substatus');_0x3741be[_0xc8a3('0x9')]('i.to');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7f'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x80'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x81'));}else if(_0x525d06==='openchannel'){_0x3741be[_0xc8a3('0x9')]('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',_0xc8a3('0x78'));}else{_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x82'),_0xc8a3('0x78'));}if(_0x525d06!==_0xc8a3('0x2f')){_0x3741be[_0xc8a3('0x9')]('i.*');}_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x83'),_0xc8a3('0x84'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x85'),_0xc8a3('0x86'));_0x3741be['field'](_0xc8a3('0x87'),'Contact.email');_0x3741be['field'](_0xc8a3('0x88'),'Contact.phone');_0x3741be['field']('c.mobile',_0xc8a3('0x89'));_0x3741be['field'](_0xc8a3('0x8a'),_0xc8a3('0x8b'));_0x3741be[_0xc8a3('0x9')]('o.fullname',_0xc8a3('0x8c'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x8d'),_0xc8a3('0x8e'));_0x3741be['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0xc8a3('0x8f'));}if(_0x394164[_0xc8a3('0x90')]){_0x3741be[_0xc8a3('0x90')](_0x394164[_0xc8a3('0x90')]);}if(_0x394164[_0xc8a3('0x91')]){_0x3741be['offset'](_0x394164['offset']);}return db[_0xc8a3('0x92')][_0xc8a3('0x6d')](_0x3741be[_0xc8a3('0x93')](),_0xaaebc9);})[_0xc8a3('0x5a')](function(_0x319444){_0x56e759=_0x319444;var _0x42dd8c=getUsersQuery(_0x525d06,_0x56e759);return db[_0xc8a3('0x92')]['query'](_0x42dd8c[_0xc8a3('0x93')](),_0xaaebc9);})['then'](function(_0x4c2ca9){_0x429c46=_['groupBy'](_0x4c2ca9,_0x208887);if(_0x525d06===_0xc8a3('0x2f')){return db['Setting'][_0xc8a3('0x94')]({'attributes':[_0xc8a3('0x95')],'raw':!![]});}})['then'](function(_0x4a887d){var _0x2323ba=_0x4a887d?_0x4a887d[_0xc8a3('0x95')]:undefined;var _0x2242f0=_0x56e759[_0xc8a3('0x4a')](function(_0xd761f5){return updateInteraction(_0xd761f5,_0xdc6112,_0x429c46,_0x2323ba);});return Promise['all'](_0x2242f0);});}function countFilteredInteractions(_0x4359a0,_0x1ce813){var _0x1704ad=_0x4359a0[_0xc8a3('0x96')]();_0x1704ad[_0xc8a3('0x9')](_0xc8a3('0x97'));_0x1704ad['field'](_0xc8a3('0x71'),_0xc8a3('0x40'));var _0x25477e=utils[_0xc8a3('0x98')](_0x1ce813);if(!_['isEmpty'](_0x25477e)){_0x1704ad[_0xc8a3('0x99')](_0xc8a3('0x9a'),_0x25477e);}var _0x5d7877={'type':db[_0xc8a3('0x6b')][_0xc8a3('0x6c')][_0xc8a3('0x9b')],'raw':!![]};return db[_0xc8a3('0x92')][_0xc8a3('0x6d')](_0x1704ad[_0xc8a3('0x93')](),_0x5d7877);}module[_0xc8a3('0x9c')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion2.git / blobdiff