// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x62b5=['enableEmailPreview','all','clone','t.id\x20IN\x20?','Sequelize','QueryTypes','exports','lodash','squel','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','getAccountFK','agent','search','field','name','color','from','tools_tags','getInteractionFK','_interactions','select','u.id','u.fullname','ui.','left_join','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionsTables','interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','{OPERATOR}','replace','isNumeric','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','openchannel','i.from\x20LIKE\x20?','mail','isEmail','c.email\x20LIKE\x20?','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','find','type','default','text','start','value','end','unreadMessages','read','and','Contact','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','Tag','clause','ids','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','body','keys','some','concat','createdAt','$gte','parse','null','\x20IS\x20NULL','\x20=\x20?','then','fields','tags','filter','chat','Websites','resolve','\x20IS\x20NOT\x20NULL','i.secondDisposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','SELECT','sequelize','query','toString','keyBy','merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.disposition','i.to','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.*','Contact.firstName','c.lastName','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','groupBy','Setting','findOne'];(function(_0x5b9416,_0x1d2b28){var _0x22ec13=function(_0x36e1c9){while(--_0x36e1c9){_0x5b9416['push'](_0x5b9416['shift']());}};_0x22ec13(++_0x1d2b28);}(_0x62b5,0x1f0));var _0x562b=function(_0x183748,_0x3a739b){_0x183748=_0x183748-0x0;var _0x1cb930=_0x62b5[_0x183748];return _0x1cb930;};'use strict';var _=require(_0x562b('0x0'));var squel=require(_0x562b('0x1'));var as=require('../parsers/advancedSearch');var qs=require(_0x562b('0x2'));var updateInteraction=require(_0x562b('0x3'))[_0x562b('0x4')];var utils=require(_0x562b('0x5'));var db=require(_0x562b('0x6'))['db'];function skipInteractionsQuery(_0x590302,_0xb6c9c,_0x1671fa){var _0x497380=![];var _0x3898e3=utils[_0x562b('0x7')](_0x590302);if(_0xb6c9c['role']===_0x562b('0x8')&&!_0x1671fa[_0x562b('0x9')]&&!_0x1671fa[_0x3898e3]){_0x497380=!![];}return _0x497380;}function getTagsQuery(){return squel['select']()[_0x562b('0xa')]('id')[_0x562b('0xa')](_0x562b('0xb'))['field'](_0x562b('0xc'))[_0x562b('0xd')](_0x562b('0xe'));}function getUsersQuery(_0x3c86f2,_0x19c62f){var _0x22afd8=utils[_0x562b('0xf')](_0x3c86f2);var _0x19dd8b='user_has_'+_0x3c86f2+_0x562b('0x10');var _0x37aa6d=squel[_0x562b('0x11')]()[_0x562b('0xa')](_0x562b('0x12'))[_0x562b('0xa')](_0x562b('0x13'))['field'](_0x562b('0x14')+_0x22afd8)[_0x562b('0xd')](_0x19dd8b,'ui')[_0x562b('0x15')]('users','u',_0x562b('0x16'));if(_0x19c62f[_0x562b('0x17')]>0x0){_0x37aa6d[_0x562b('0x18')](_0x562b('0x14')+_0x22afd8+_0x562b('0x19'),_[_0x562b('0x1a')](_0x19c62f,'id'));}return _0x37aa6d;}function getInteractionsQuery(_0x268f4f){var _0x23e369=utils[_0x562b('0x1b')](_0x268f4f);var _0x5c52d6=utils[_0x562b('0x7')](_0x268f4f);var _0x4ac61d=utils['getInteractionFK'](_0x268f4f);return squel[_0x562b('0x11')]()['from'](_0x23e369[_0x562b('0x1c')],'i')[_0x562b('0x15')]('cm_contacts','c',_0x562b('0x1d'))[_0x562b('0x15')](_0x562b('0x1e'),'o','o.id\x20=\x20i.UserId')['left_join'](_0x23e369['accounts'],'a',_0x562b('0x1f')+_0x5c52d6)[_0x562b('0x15')](_0x23e369[_0x562b('0x20')],'me',_0x562b('0x21')+_0x4ac61d+_0x562b('0x22'))[_0x562b('0x15')](_0x23e369[_0x562b('0x23')],'it','it.'+_0x4ac61d+_0x562b('0x22'))[_0x562b('0x15')](_0x562b('0xe'),'t',_0x562b('0x24'));}function getSqlClauses(){var _0x280052={'body':squel[_0x562b('0x25')](),'contact':squel[_0x562b('0x25')](),'default':squel[_0x562b('0x25')](),'fields':squel[_0x562b('0x25')](),'filter':squel['expr'](),'read':squel[_0x562b('0x25')](),'tags':{'clause':squel[_0x562b('0x25')](),'ids':null},'user':squel[_0x562b('0x25')]()};return _0x280052;}function parseTagParameter(_0x59beb3){var _0x21fa47=squel[_0x562b('0x25')]();if(_0x59beb3){var _0x355caa=utils[_0x562b('0x26')](_0x59beb3);_0x355caa[_0x562b('0x27')](function(_0x364f7b){_0x21fa47['or'](_0x562b('0x28'),'%,'+_0x364f7b+',%');});}return _0x21fa47;}function parseReadParameter(_0x1f7204){var _0xbbbf0='';if(_0x1f7204){_0xbbbf0=_0x562b('0x29');if(_0x1f7204==='1'){_0xbbbf0=_0xbbbf0['replace'](_0x562b('0x2a'),'=');}else{_0xbbbf0=_0xbbbf0[_0x562b('0x2b')](_0x562b('0x2a'),'>');}}return _0xbbbf0;}function parseSearchFilter(_0x53f043,_0x41a124){var _0x576343=squel[_0x562b('0x25')]();if(_0x41a124){var _0x22f876=_0x41a124[_0x562b('0x2b')]('\x5c','\x5c\x5c')[_0x562b('0x2b')](/'/g,'\x27\x27');if(qs[_0x562b('0x2c')](_0x22f876)){_0x576343['or']('i.id\x20LIKE\x20?',_0x22f876+'%');if([_0x562b('0x2d'),_0x562b('0x2e')][_0x562b('0x2f')](_0x53f043)){_0x576343['or'](_0x562b('0x30'),_0x22f876+'%');}else if(_0x53f043===_0x562b('0x31')){_0x576343['or']('i.fax\x20LIKE\x20?',_0x22f876+'%');}else if(_0x53f043===_0x562b('0x32')){_0x576343['or'](_0x562b('0x33'),_0x22f876+'%');}}else if(_0x53f043===_0x562b('0x34')&&qs[_0x562b('0x35')](_0x22f876)){_0x576343['or'](_0x562b('0x36'),_0x22f876+'%');}else{if(_0x53f043===_0x562b('0x34')){_0x576343['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x562b('0x37')](_0x22f876,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x562b('0x37')](_0x22f876));}else if(_0x53f043!==_0x562b('0x31')){_0x576343['or'](_0x562b('0x38'),qs['getFullTextValue'](_0x22f876));}_0x576343['or'](_0x562b('0x39'),qs[_0x562b('0x37')](_0x22f876,!![]),null);}}return _0x576343;}function parseAdvancedSearchFilter(_0x24dab1,_0x4b94c2){var _0x443f72=getSqlClauses();var _0x2d667e=as[_0x562b('0x3a')](_0x24dab1);var _0x29bb8b=_0x2d667e[_0x562b('0x3b')];for(var _0x4ad537=0x0;_0x4ad537<_0x2d667e[_0x562b('0x3c')][_0x562b('0x17')];_0x4ad537++){var _0x40c569=_0x2d667e[_0x562b('0x3c')][_0x4ad537];var _0x5b12e3='i';var _0x24495b=_[_0x562b('0x3d')](_0x4b94c2,[_0x562b('0xb'),_0x40c569[_0x562b('0xa')]]);if(_0x24495b){var _0x579aac=as['buildExpression'](_0x5b12e3,_0x24495b[_0x562b('0x3e')],_0x40c569);_0x443f72[_0x562b('0x3f')][_0x29bb8b](_0x579aac[_0x562b('0x40')],_0x579aac['value'][_0x562b('0x41')],_0x579aac[_0x562b('0x42')][_0x562b('0x43')]);}else{switch(_0x40c569['field']){case _0x562b('0x44'):var _0x26157c=parseReadParameter(_0x40c569[_0x562b('0x42')]);_0x443f72[_0x562b('0x45')][_0x562b('0x46')](_0x26157c);break;case _0x562b('0x47'):if(_0x40c569[_0x562b('0x48')]===_0x562b('0x49')){if(_0x40c569[_0x562b('0x42')]['split']('\x20')[_0x562b('0x17')]>0x1){_0x443f72[_0x562b('0x4a')][_0x29bb8b](_0x562b('0x39'),qs[_0x562b('0x37')](_0x40c569[_0x562b('0x42')],!![]),null);}else{var _0x534058='%'+_0x40c569[_0x562b('0x42')]+'%';_0x443f72[_0x562b('0x4a')][_0x29bb8b](_0x562b('0x4b'),_0x534058,_0x534058,_0x534058);}}else{_0x24495b=_[_0x562b('0x3d')](_0x4b94c2,[_0x562b('0xb'),_0x562b('0x4c')]);_0x40c569[_0x562b('0xa')]='ContactId';_0x579aac=as[_0x562b('0x4d')](_0x5b12e3,_0x24495b[_0x562b('0x3e')],_0x40c569);_0x443f72[_0x562b('0x4a')][_0x29bb8b](_0x579aac['text'],_0x579aac['value'][_0x562b('0x41')],_0x579aac[_0x562b('0x42')][_0x562b('0x43')]);}break;case _0x562b('0x4e'):var _0x3794d9=_0x40c569['value']['split'](',')[_0x562b('0x1a')](function(_0xf3277c){return Number(_0xf3277c);});var _0x1d990d=parseTagParameter(_0x3794d9);_0x443f72['tags'][_0x562b('0x4f')][_0x562b('0x46')](_0x1d990d);_0x443f72['tags'][_0x562b('0x50')]=_0x3794d9;break;case'User':if(_0x40c569[_0x562b('0x48')]===_0x562b('0x49')){_0x443f72[_0x562b('0x51')][_0x29bb8b](_0x562b('0x52'),'%'+_0x40c569[_0x562b('0x42')]+'%',null);}else{_0x24495b=_[_0x562b('0x3d')](_0x4b94c2,['name',_0x562b('0x53')]);_0x40c569[_0x562b('0xa')]=_0x562b('0x53');_0x579aac=as[_0x562b('0x4d')](_0x5b12e3,_0x24495b[_0x562b('0x3e')],_0x40c569);_0x443f72[_0x562b('0x51')][_0x29bb8b](_0x579aac[_0x562b('0x40')],_0x579aac[_0x562b('0x42')][_0x562b('0x41')],_0x579aac[_0x562b('0x42')][_0x562b('0x43')]);}break;case'body':case'plainBody':_0x579aac=as[_0x562b('0x4d')]('me',null,_0x40c569);_0x443f72[_0x562b('0x54')][_0x29bb8b](_0x579aac[_0x562b('0x40')],_0x579aac[_0x562b('0x42')][_0x562b('0x41')],_0x579aac['value'][_0x562b('0x43')]);break;}}}return _0x443f72;}function parseModelFields(_0xd18f9c,_0xaea58c,_0xaf0f60){var _0x3623ba=utils[_0x562b('0x7')](_0xd18f9c);var _0x14e3b8=squel['expr']();var _0x42ffce=_(_0xaea58c)[_0x562b('0x55')]()[_0x562b('0x1a')](function(_0x2ad9a2){return _[_0x562b('0x56')](_0xaf0f60,['name',_0x2ad9a2])?_0x2ad9a2:undefined;})['compact']()[_0x562b('0x42')]();if(_0x42ffce['length']>0x0){_0x42ffce[_0x562b('0x27')](function(_0x28ed4a){if(_0x28ed4a===_0x3623ba){_0x14e3b8[_0x562b('0x46')]('i.'+_0x3623ba+_0x562b('0x19'),[][_0x562b('0x57')](_0xaea58c[_0x28ed4a]));}else if(_0x28ed4a===_0x562b('0x58')){var _0x553255=JSON['parse'](_0xaea58c[_0x28ed4a])[_0x562b('0x59')];var _0x28f10c=JSON[_0x562b('0x5a')](_0xaea58c[_0x28ed4a])['$lte'];_0x14e3b8['and']('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x553255,_0x28f10c);}else{if(_0xaea58c[_0x28ed4a]===_0x562b('0x5b')){_0x14e3b8[_0x562b('0x46')]('i.'+_0x28ed4a+_0x562b('0x5c'));}else{_0x14e3b8[_0x562b('0x46')]('i.'+_0x28ed4a+_0x562b('0x5d'),_0xaea58c[_0x28ed4a]);}}});}return _0x14e3b8;}function parseQueryParameters(_0x25df85,_0x9f6805,_0x4ecac2){var _0x321b71=getSqlClauses();return Promise['resolve']()[_0x562b('0x5e')](function(){return parseModelFields(_0x25df85,_0x9f6805,_0x4ecac2);})['then'](function(_0x44c216){_0x321b71[_0x562b('0x5f')][_0x562b('0x46')](_0x44c216);return parseReadParameter(_0x9f6805[_0x562b('0x45')]);})[_0x562b('0x5e')](function(_0x20c993){_0x321b71[_0x562b('0x45')][_0x562b('0x46')](_0x20c993);return parseTagParameter(_0x9f6805['tag']);})[_0x562b('0x5e')](function(_0x5e629b){_0x321b71[_0x562b('0x60')][_0x562b('0x4f')][_0x562b('0x46')](_0x5e629b);return parseSearchFilter(_0x25df85,_0x9f6805[_0x562b('0x61')]);})[_0x562b('0x5e')](function(_0x1964fc){_0x321b71['filter']=_0x1964fc;return _0x321b71;});}function checkAccountsRestrictions(_0x161bf5,_0x311914,_0x5becd2){var _0x2664c9=utils[_0x562b('0x7')](_0x161bf5);var _0x480e22='get'+_['capitalize'](_0x161bf5)+(_0x161bf5===_0x562b('0x62')?_0x562b('0x63'):'Accounts');var _0x6a6cf9=squel['expr']();return Promise[_0x562b('0x64')]()[_0x562b('0x5e')](function(){if(_0x5becd2[_0x562b('0x9')]&&_0x311914['role']===_0x562b('0x8')){return _0x311914[_0x480e22]({'attributes':['id'],'raw':!![]});}})[_0x562b('0x5e')](function(_0x429107){if(_0x429107){if(_0x429107[_0x562b('0x17')]===0x0){_0x6a6cf9[_0x562b('0x46')]('i.'+_0x2664c9+'\x20IS\x20NULL');}else{_0x6a6cf9['and']('i.'+_0x2664c9+_0x562b('0x19'),_[_0x562b('0x1a')](_0x429107,'id'));}}else if(!_0x5becd2[_0x2664c9]){_0x6a6cf9[_0x562b('0x46')]('i.'+_0x2664c9+_0x562b('0x65'));}})[_0x562b('0x5e')](function(){return _0x6a6cf9;});}function getClosedOrderClause(_0x424836,_0x1e737d){var _0x5baba7='';var _0xe31205=['i.thirdDisposition',_0x562b('0x66'),'i.disposition'];if(_0x424836===_0x562b('0x34')){_0xe31205[_0x562b('0x67')](_0x562b('0x68'));}if(_0x1e737d[_0x562b('0x69')]==='0'&&_0x424836===_0x562b('0x34')){_0x5baba7=_0x562b('0x68');}else{if(_0x1e737d[_0x562b('0x69')]==='1'){_0xe31205[_0x562b('0x6a')]();}_0x5baba7=_0x562b('0x6b')+_0xe31205[_0x562b('0x6c')](',\x20')+')';}return _0x5baba7;}function getFilteredInteractions(_0x57f92f,_0xbb1b73,_0x9ac007,_0x41b5eb){var _0x19c24c=utils['getInteractionFK'](_0x57f92f);var _0x432afb=_['capitalize'](_0x57f92f)+_0x562b('0x6d');var _0x2cc807=[];var _0x29ab87=getTagsQuery();var _0x3db2df={'type':db['Sequelize']['QueryTypes'][_0x562b('0x6e')],'raw':!![]};var _0x4f1a48=[];var _0x17e83e=[];return db[_0x562b('0x6f')][_0x562b('0x70')](_0x29ab87[_0x562b('0x71')](),_0x3db2df)[_0x562b('0x5e')](function(_0x92c5bc){_0x2cc807=_[_0x562b('0x72')](_0x92c5bc,'id');_0x3db2df=_[_0x562b('0x73')](_0x3db2df,{'model':db[_0x432afb],'mapToModel':!![],'nest':!![]});if(_0x9ac007[_0x562b('0x5f')]){_0x41b5eb['attributes']['forEach'](function(_0xec0913){_0xbb1b73[_0x562b('0xa')]('i.'+_0xec0913);});}else{_0xbb1b73[_0x562b('0xa')](_0x562b('0x74'),_0x562b('0x44'));_0xbb1b73['field']('a.key',_0x562b('0x75'));_0xbb1b73['field'](_0x562b('0x76'),_0x562b('0x77'));if(_0x57f92f===_0x562b('0x34')){_0xbb1b73[_0x562b('0xa')](_0x562b('0x78'),'Account.email');_0xbb1b73[_0x562b('0xa')](_0x562b('0x79'),_0x562b('0x7a'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x7b'));_0xbb1b73['field'](_0x562b('0x7c'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x7d'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x7e'));_0xbb1b73['field'](_0x562b('0x7f'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x80'));_0xbb1b73['field'](_0x562b('0x81'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x82'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x83'));_0xbb1b73['field'](_0x562b('0x84'));_0xbb1b73['field']('i.secondDisposition');_0xbb1b73['field']('i.thirdDisposition');_0xbb1b73[_0x562b('0xa')](_0x562b('0x68'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x85'));_0xbb1b73[_0x562b('0xa')]('i.ContactId');_0xbb1b73['field']('i.MailAccountId');_0xbb1b73[_0x562b('0xa')](_0x562b('0x86'));}else if(_0x57f92f===_0x562b('0x32')){_0xbb1b73[_0x562b('0xa')](_0x562b('0x87'),_0x562b('0x7a'));}else{_0xbb1b73['field'](_0x562b('0x88'),'contactName');}if(_0x57f92f!=='mail'){_0xbb1b73[_0x562b('0xa')](_0x562b('0x89'));}_0xbb1b73['field']('c.firstName',_0x562b('0x8a'));_0xbb1b73['field'](_0x562b('0x8b'),'Contact.lastName');_0xbb1b73[_0x562b('0xa')]('c.email',_0x562b('0x8c'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x8d'),_0x562b('0x8e'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x8f'),_0x562b('0x90'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x91'),_0x562b('0x92'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x93'),'Owner.fullname');_0xbb1b73['field'](_0x562b('0x94'),_0x562b('0x95'));_0xbb1b73[_0x562b('0xa')](_0x562b('0x96'),'TagIds');}if(_0x41b5eb['limit']){_0xbb1b73[_0x562b('0x97')](_0x41b5eb['limit']);}if(_0x41b5eb[_0x562b('0x98')]){_0xbb1b73['offset'](_0x41b5eb[_0x562b('0x98')]);}return db['sequelize'][_0x562b('0x70')](_0xbb1b73[_0x562b('0x71')](),_0x3db2df);})[_0x562b('0x5e')](function(_0xa0358c){_0x4f1a48=_0xa0358c;var _0x236f75=getUsersQuery(_0x57f92f,_0x4f1a48);return db[_0x562b('0x6f')][_0x562b('0x70')](_0x236f75[_0x562b('0x71')](),_0x3db2df);})['then'](function(_0x26c46c){_0x17e83e=_[_0x562b('0x99')](_0x26c46c,_0x19c24c);if(_0x57f92f===_0x562b('0x34')){return db[_0x562b('0x9a')][_0x562b('0x9b')]({'attributes':[_0x562b('0x9c')],'raw':!![]});}})[_0x562b('0x5e')](function(_0xd9c2a1){var _0x523ac3=_0xd9c2a1?_0xd9c2a1['enableEmailPreview']:undefined;var _0x57f90b=_0x4f1a48[_0x562b('0x1a')](function(_0x3a6cc5){return updateInteraction(_0x3a6cc5,_0x2cc807,_0x17e83e,_0x523ac3);});return Promise[_0x562b('0x9d')](_0x57f90b);});}function countFilteredInteractions(_0x30f363,_0x1dad49){var _0x207477=_0x30f363[_0x562b('0x9e')]();_0x207477['field']('COUNT(*)');_0x207477[_0x562b('0xa')](_0x562b('0x74'),_0x562b('0x44'));var _0x39df3f=utils[_0x562b('0x26')](_0x1dad49);if(!_['isEmpty'](_0x39df3f)){_0x207477[_0x562b('0x18')](_0x562b('0x9f'),_0x39df3f);}var _0x4a21ff={'type':db[_0x562b('0xa0')][_0x562b('0xa1')][_0x562b('0x6e')],'raw':!![]};return db[_0x562b('0x6f')][_0x562b('0x70')](_0x207477['toString'](),_0x4a21ff);}module[_0x562b('0xa2')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x163a=['c.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','sequelize','groupBy','Setting','enableEmailPreview','all','clone','COUNT(*)','unreadMessages','isEmpty','t.id\x20IN\x20?','exports','lodash','squel','../parsers/advancedSearch','./update-interaction','updateInteraction','../../mysqldb','getAccountFK','role','agent','search','field','name','tools_tags','_interactions','select','u.id','u.fullname','from','left_join','users','u.id\x20=\x20ui.UserId','where','\x20IN\x20?','getInteractionsTables','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?','unreadMessages\x20{OPERATOR}\x200','replace','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','length','find','buildExpression','default','text','start','value','read','and','split','contact','ContactId','type','end','Tag','map','tags','User','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','user','plainBody','body','keys','some','compact','concat','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','resolve','then','fields','filter','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','mail','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','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.closed','i.closedAt','i.attach','i.lastMsgDirection','i.disposition','i.to','i.MailAccountId','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.*','Contact.firstName','c.email','Contact.email'];(function(_0x408c5f,_0x82bf5f){var _0x583a97=function(_0x4f8418){while(--_0x4f8418){_0x408c5f['push'](_0x408c5f['shift']());}};_0x583a97(++_0x82bf5f);}(_0x163a,0x14f));var _0xa163=function(_0x1406ae,_0x292395){_0x1406ae=_0x1406ae-0x0;var _0x23a076=_0x163a[_0x1406ae];return _0x23a076;};'use strict';var _=require(_0xa163('0x0'));var squel=require(_0xa163('0x1'));var as=require(_0xa163('0x2'));var qs=require('../parsers/qs');var updateInteraction=require(_0xa163('0x3'))[_0xa163('0x4')];var utils=require('./utils');var db=require(_0xa163('0x5'))['db'];function skipInteractionsQuery(_0xad0995,_0x289c2a,_0x490deb){var _0x41368c=![];var _0x4e66ba=utils[_0xa163('0x6')](_0xad0995);if(_0x289c2a[_0xa163('0x7')]===_0xa163('0x8')&&!_0x490deb[_0xa163('0x9')]&&!_0x490deb[_0x4e66ba]){_0x41368c=!![];}return _0x41368c;}function getTagsQuery(){return squel['select']()[_0xa163('0xa')]('id')['field'](_0xa163('0xb'))['field']('color')['from'](_0xa163('0xc'));}function getUsersQuery(_0x2d76bb,_0x39fbeb){var _0x288e6d=utils['getInteractionFK'](_0x2d76bb);var _0x164e5c='user_has_'+_0x2d76bb+_0xa163('0xd');var _0x39f3fa=squel[_0xa163('0xe')]()[_0xa163('0xa')](_0xa163('0xf'))[_0xa163('0xa')](_0xa163('0x10'))[_0xa163('0xa')]('ui.'+_0x288e6d)[_0xa163('0x11')](_0x164e5c,'ui')[_0xa163('0x12')](_0xa163('0x13'),'u',_0xa163('0x14'));if(_0x39fbeb['length']>0x0){_0x39f3fa[_0xa163('0x15')]('ui.'+_0x288e6d+_0xa163('0x16'),_['map'](_0x39fbeb,'id'));}return _0x39f3fa;}function getInteractionsQuery(_0x13b652){var _0x4e603c=utils[_0xa163('0x17')](_0x13b652);var _0x1b8357=utils[_0xa163('0x6')](_0x13b652);var _0x2c7010=utils['getInteractionFK'](_0x13b652);return squel[_0xa163('0xe')]()[_0xa163('0x11')](_0x4e603c['interactions'],'i')[_0xa163('0x12')]('cm_contacts','c',_0xa163('0x18'))['left_join'](_0xa163('0x13'),'o',_0xa163('0x19'))['left_join'](_0x4e603c[_0xa163('0x1a')],'a',_0xa163('0x1b')+_0x1b8357)['left_join'](_0x4e603c[_0xa163('0x1c')],'me',_0xa163('0x1d')+_0x2c7010+_0xa163('0x1e'))[_0xa163('0x12')](_0x4e603c['interactionsTags'],'it',_0xa163('0x1f')+_0x2c7010+_0xa163('0x1e'))['left_join']('tools_tags','t',_0xa163('0x20'));}function getSqlClauses(){var _0x54b0e1={'body':squel[_0xa163('0x21')](),'contact':squel['expr'](),'default':squel['expr'](),'fields':squel[_0xa163('0x21')](),'filter':squel[_0xa163('0x21')](),'read':squel[_0xa163('0x21')](),'tags':{'clause':squel[_0xa163('0x21')](),'ids':null},'user':squel[_0xa163('0x21')]()};return _0x54b0e1;}function parseTagParameter(_0x183010){var _0xb6f2e=squel[_0xa163('0x21')]();if(_0x183010){var _0x5388ea=utils[_0xa163('0x22')](_0x183010);_0x5388ea[_0xa163('0x23')](function(_0x496d17){_0xb6f2e['or'](_0xa163('0x24'),'%,'+_0x496d17+',%');});}return _0xb6f2e;}function parseReadParameter(_0x5c8aec){var _0x3efe2c='';if(_0x5c8aec){_0x3efe2c=_0xa163('0x25');if(_0x5c8aec==='1'){_0x3efe2c=_0x3efe2c[_0xa163('0x26')]('{OPERATOR}','=');}else{_0x3efe2c=_0x3efe2c[_0xa163('0x26')]('{OPERATOR}','>');}}return _0x3efe2c;}function parseSearchFilter(_0x5bddaa,_0xa0d07){var _0x560144=squel[_0xa163('0x21')]();if(_0xa0d07){var _0x46b4f3=_0xa0d07[_0xa163('0x26')]('\x5c','\x5c\x5c')[_0xa163('0x26')](/'/g,'\x27\x27');if(qs[_0xa163('0x27')](_0x46b4f3)){_0x560144['or'](_0xa163('0x28'),_0x46b4f3+'%');if([_0xa163('0x29'),_0xa163('0x2a')]['includes'](_0x5bddaa)){_0x560144['or'](_0xa163('0x2b'),_0x46b4f3+'%');}else if(_0x5bddaa===_0xa163('0x2c')){_0x560144['or'](_0xa163('0x2d'),_0x46b4f3+'%');}else if(_0x5bddaa===_0xa163('0x2e')){_0x560144['or']('i.from\x20LIKE\x20?',_0x46b4f3+'%');}}else if(_0x5bddaa==='mail'&&qs[_0xa163('0x2f')](_0x46b4f3)){_0x560144['or'](_0xa163('0x30'),_0x46b4f3+'%');}else{if(_0x5bddaa==='mail'){_0x560144['or'](_0xa163('0x31'),qs['getFullTextValue'](_0x46b4f3,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x46b4f3));}else if(_0x5bddaa!==_0xa163('0x2c')){_0x560144['or'](_0xa163('0x32'),qs[_0xa163('0x33')](_0x46b4f3));}_0x560144['or'](_0xa163('0x34'),qs[_0xa163('0x33')](_0x46b4f3,!![]),null);}}return _0x560144;}function parseAdvancedSearchFilter(_0x6dcff3,_0x3dceab){var _0x100d98=getSqlClauses();var _0x5db731=as[_0xa163('0x35')](_0x6dcff3);var _0x43ddc5=_0x5db731[_0xa163('0x36')];for(var _0x7917e0=0x0;_0x7917e0<_0x5db731['conditions'][_0xa163('0x37')];_0x7917e0++){var _0x29149a=_0x5db731['conditions'][_0x7917e0];var _0x1a29a8='i';var _0x1a43aa=_[_0xa163('0x38')](_0x3dceab,[_0xa163('0xb'),_0x29149a[_0xa163('0xa')]]);if(_0x1a43aa){var _0x2b0475=as[_0xa163('0x39')](_0x1a29a8,_0x1a43aa['type'],_0x29149a);_0x100d98[_0xa163('0x3a')][_0x43ddc5](_0x2b0475[_0xa163('0x3b')],_0x2b0475['value'][_0xa163('0x3c')],_0x2b0475[_0xa163('0x3d')]['end']);}else{switch(_0x29149a[_0xa163('0xa')]){case'unreadMessages':var _0x55765f=parseReadParameter(_0x29149a[_0xa163('0x3d')]);_0x100d98[_0xa163('0x3e')][_0xa163('0x3f')](_0x55765f);break;case'Contact':if(_0x29149a['operator']==='$substring'){if(_0x29149a[_0xa163('0x3d')][_0xa163('0x40')]('\x20')['length']>0x1){_0x100d98[_0xa163('0x41')][_0x43ddc5](_0xa163('0x34'),qs[_0xa163('0x33')](_0x29149a[_0xa163('0x3d')],!![]),null);}else{var _0x422efb='%'+_0x29149a[_0xa163('0x3d')]+'%';_0x100d98[_0xa163('0x41')][_0x43ddc5]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x422efb,_0x422efb,_0x422efb);}}else{_0x1a43aa=_[_0xa163('0x38')](_0x3dceab,[_0xa163('0xb'),_0xa163('0x42')]);_0x29149a[_0xa163('0xa')]='ContactId';_0x2b0475=as[_0xa163('0x39')](_0x1a29a8,_0x1a43aa[_0xa163('0x43')],_0x29149a);_0x100d98[_0xa163('0x41')][_0x43ddc5](_0x2b0475[_0xa163('0x3b')],_0x2b0475[_0xa163('0x3d')][_0xa163('0x3c')],_0x2b0475[_0xa163('0x3d')][_0xa163('0x44')]);}break;case _0xa163('0x45'):var _0x248b8a=_0x29149a['value'][_0xa163('0x40')](',')[_0xa163('0x46')](function(_0x351d1d){return Number(_0x351d1d);});var _0x49cb5d=parseTagParameter(_0x248b8a);_0x100d98[_0xa163('0x47')]['clause'][_0xa163('0x3f')](_0x49cb5d);_0x100d98['tags']['ids']=_0x248b8a;break;case _0xa163('0x48'):if(_0x29149a['operator']===_0xa163('0x49')){_0x100d98['user'][_0x43ddc5](_0xa163('0x4a'),'%'+_0x29149a[_0xa163('0x3d')]+'%',null);}else{_0x1a43aa=_[_0xa163('0x38')](_0x3dceab,['name',_0xa163('0x4b')]);_0x29149a[_0xa163('0xa')]=_0xa163('0x4b');_0x2b0475=as[_0xa163('0x39')](_0x1a29a8,_0x1a43aa[_0xa163('0x43')],_0x29149a);_0x100d98[_0xa163('0x4c')][_0x43ddc5](_0x2b0475[_0xa163('0x3b')],_0x2b0475['value'][_0xa163('0x3c')],_0x2b0475[_0xa163('0x3d')]['end']);}break;case'body':case _0xa163('0x4d'):_0x2b0475=as['buildExpression']('me',null,_0x29149a);_0x100d98[_0xa163('0x4e')][_0x43ddc5](_0x2b0475['text'],_0x2b0475[_0xa163('0x3d')][_0xa163('0x3c')],_0x2b0475[_0xa163('0x3d')]['end']);break;}}}return _0x100d98;}function parseModelFields(_0x178ab2,_0x24e98a,_0x92fbab){var _0x14b9be=utils['getAccountFK'](_0x178ab2);var _0x2419f3=squel[_0xa163('0x21')]();var _0x37bebc=_(_0x24e98a)[_0xa163('0x4f')]()[_0xa163('0x46')](function(_0x12a330){return _[_0xa163('0x50')](_0x92fbab,['name',_0x12a330])?_0x12a330:undefined;})[_0xa163('0x51')]()[_0xa163('0x3d')]();if(_0x37bebc[_0xa163('0x37')]>0x0){_0x37bebc['forEach'](function(_0x32c1a6){if(_0x32c1a6===_0x14b9be){_0x2419f3[_0xa163('0x3f')]('i.'+_0x14b9be+_0xa163('0x16'),[][_0xa163('0x52')](_0x24e98a[_0x32c1a6]));}else if(_0x32c1a6==='createdAt'){var _0x4d0678=JSON[_0xa163('0x53')](_0x24e98a[_0x32c1a6])['$gte'];var _0x4a9577=JSON[_0xa163('0x53')](_0x24e98a[_0x32c1a6])[_0xa163('0x54')];_0x2419f3['and'](_0xa163('0x55'),_0x4d0678,_0x4a9577);}else{if(_0x24e98a[_0x32c1a6]===_0xa163('0x56')){_0x2419f3[_0xa163('0x3f')]('i.'+_0x32c1a6+'\x20IS\x20NULL');}else{_0x2419f3['and']('i.'+_0x32c1a6+_0xa163('0x57'),_0x24e98a[_0x32c1a6]);}}});}return _0x2419f3;}function parseQueryParameters(_0x119a47,_0x55f35a,_0x22a8f8){var _0x47830c=getSqlClauses();return Promise[_0xa163('0x58')]()[_0xa163('0x59')](function(){return parseModelFields(_0x119a47,_0x55f35a,_0x22a8f8);})[_0xa163('0x59')](function(_0x48b819){_0x47830c[_0xa163('0x5a')][_0xa163('0x3f')](_0x48b819);return parseReadParameter(_0x55f35a[_0xa163('0x3e')]);})[_0xa163('0x59')](function(_0x485a65){_0x47830c['read'][_0xa163('0x3f')](_0x485a65);return parseTagParameter(_0x55f35a['tag']);})[_0xa163('0x59')](function(_0x244df1){_0x47830c['tags']['clause'][_0xa163('0x3f')](_0x244df1);return parseSearchFilter(_0x119a47,_0x55f35a['filter']);})[_0xa163('0x59')](function(_0x4792c9){_0x47830c[_0xa163('0x5b')]=_0x4792c9;return _0x47830c;});}function checkAccountsRestrictions(_0x341530,_0x9fb73a,_0x2d2bfa){var _0x2f0905=utils[_0xa163('0x6')](_0x341530);var _0x23a3c5='get'+_[_0xa163('0x5c')](_0x341530)+(_0x341530===_0xa163('0x5d')?_0xa163('0x5e'):_0xa163('0x5f'));var _0x43e9f9=squel[_0xa163('0x21')]();return Promise[_0xa163('0x58')]()[_0xa163('0x59')](function(){if(_0x2d2bfa[_0xa163('0x9')]&&_0x9fb73a[_0xa163('0x7')]===_0xa163('0x8')){return _0x9fb73a[_0x23a3c5]({'attributes':['id'],'raw':!![]});}})[_0xa163('0x59')](function(_0x5bcca0){if(_0x5bcca0){if(_0x5bcca0['length']===0x0){_0x43e9f9[_0xa163('0x3f')]('i.'+_0x2f0905+'\x20IS\x20NULL');}else{_0x43e9f9['and']('i.'+_0x2f0905+_0xa163('0x16'),_[_0xa163('0x46')](_0x5bcca0,'id'));}}else if(!_0x2d2bfa[_0x2f0905]){_0x43e9f9['and']('i.'+_0x2f0905+_0xa163('0x60'));}})[_0xa163('0x59')](function(){return _0x43e9f9;});}function getClosedOrderClause(_0x37a4c0,_0x2db670){var _0x187908='';var _0x153269=[_0xa163('0x61'),_0xa163('0x62'),'i.disposition'];if(_0x37a4c0===_0xa163('0x63')){_0x153269[_0xa163('0x64')](_0xa163('0x65'));}if(_0x2db670[_0xa163('0x66')]==='0'&&_0x37a4c0==='mail'){_0x187908=_0xa163('0x65');}else{if(_0x2db670['closed']==='1'){_0x153269[_0xa163('0x67')]();}_0x187908=_0xa163('0x68')+_0x153269[_0xa163('0x69')](',\x20')+')';}return _0x187908;}function getFilteredInteractions(_0x194036,_0xc766d0,_0x1b3955,_0x1541f5){var _0x2a9fc1=utils['getInteractionFK'](_0x194036);var _0x2ff7e9=_[_0xa163('0x5c')](_0x194036)+_0xa163('0x6a');var _0x4a616f=[];var _0x176086=getTagsQuery();var _0x4379d3={'type':db[_0xa163('0x6b')][_0xa163('0x6c')]['SELECT'],'raw':!![]};var _0x5a078f=[];var _0x284977=[];return db['sequelize'][_0xa163('0x6d')](_0x176086[_0xa163('0x6e')](),_0x4379d3)[_0xa163('0x59')](function(_0x438ec6){_0x4a616f=_[_0xa163('0x6f')](_0x438ec6,'id');_0x4379d3=_[_0xa163('0x70')](_0x4379d3,{'model':db[_0x2ff7e9],'mapToModel':!![],'nest':!![]});if(_0x1b3955[_0xa163('0x5a')]){_0x1541f5[_0xa163('0x71')][_0xa163('0x23')](function(_0x323604){_0xc766d0['field']('i.'+_0x323604);});}else{_0xc766d0[_0xa163('0xa')](_0xa163('0x72'),'unreadMessages');_0xc766d0['field']('a.key','Account.key');_0xc766d0[_0xa163('0xa')]('a.mandatoryDisposition',_0xa163('0x73'));if(_0x194036===_0xa163('0x63')){_0xc766d0[_0xa163('0xa')](_0xa163('0x74'),_0xa163('0x75'));_0xc766d0['field'](_0xa163('0x76'),_0xa163('0x77'));_0xc766d0[_0xa163('0xa')](_0xa163('0x78'));_0xc766d0['field']('i.createdAt');_0xc766d0[_0xa163('0xa')]('i.updatedAt');_0xc766d0[_0xa163('0xa')](_0xa163('0x79'));_0xc766d0[_0xa163('0xa')](_0xa163('0x7a'));_0xc766d0[_0xa163('0xa')](_0xa163('0x7b'));_0xc766d0[_0xa163('0xa')]('i.lastMsgAt');_0xc766d0[_0xa163('0xa')](_0xa163('0x7c'));_0xc766d0[_0xa163('0xa')]('i.subject');_0xc766d0[_0xa163('0xa')](_0xa163('0x7d'));_0xc766d0[_0xa163('0xa')](_0xa163('0x62'));_0xc766d0[_0xa163('0xa')](_0xa163('0x61'));_0xc766d0[_0xa163('0xa')]('i.substatus');_0xc766d0[_0xa163('0xa')](_0xa163('0x7e'));_0xc766d0[_0xa163('0xa')]('i.ContactId');_0xc766d0[_0xa163('0xa')](_0xa163('0x7f'));_0xc766d0[_0xa163('0xa')]('i.UserId');}else if(_0x194036===_0xa163('0x2e')){_0xc766d0[_0xa163('0xa')]('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',_0xa163('0x77'));}else{_0xc766d0[_0xa163('0xa')](_0xa163('0x80'),'contactName');}if(_0x194036!==_0xa163('0x63')){_0xc766d0['field'](_0xa163('0x81'));}_0xc766d0[_0xa163('0xa')]('c.firstName',_0xa163('0x82'));_0xc766d0[_0xa163('0xa')]('c.lastName','Contact.lastName');_0xc766d0[_0xa163('0xa')](_0xa163('0x83'),_0xa163('0x84'));_0xc766d0[_0xa163('0xa')](_0xa163('0x85'),'Contact.phone');_0xc766d0[_0xa163('0xa')](_0xa163('0x86'),_0xa163('0x87'));_0xc766d0[_0xa163('0xa')](_0xa163('0x88'),_0xa163('0x89'));_0xc766d0[_0xa163('0xa')](_0xa163('0x8a'),'Owner.fullname');_0xc766d0[_0xa163('0xa')](_0xa163('0x8b'),_0xa163('0x8c'));_0xc766d0[_0xa163('0xa')](_0xa163('0x8d'),_0xa163('0x8e'));}if(_0x1541f5[_0xa163('0x8f')]){_0xc766d0['limit'](_0x1541f5['limit']);}if(_0x1541f5[_0xa163('0x90')]){_0xc766d0[_0xa163('0x90')](_0x1541f5['offset']);}return db[_0xa163('0x91')][_0xa163('0x6d')](_0xc766d0[_0xa163('0x6e')](),_0x4379d3);})[_0xa163('0x59')](function(_0x3411c0){_0x5a078f=_0x3411c0;var _0x668fb8=getUsersQuery(_0x194036,_0x5a078f);return db[_0xa163('0x91')][_0xa163('0x6d')](_0x668fb8[_0xa163('0x6e')](),_0x4379d3);})[_0xa163('0x59')](function(_0x295df2){_0x284977=_[_0xa163('0x92')](_0x295df2,_0x2a9fc1);if(_0x194036===_0xa163('0x63')){return db[_0xa163('0x93')]['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0xa163('0x59')](function(_0x42008e){var _0x3104c7=_0x42008e?_0x42008e[_0xa163('0x94')]:undefined;var _0x5b09bd=_0x5a078f[_0xa163('0x46')](function(_0x11d59c){return updateInteraction(_0x11d59c,_0x4a616f,_0x284977,_0x3104c7);});return Promise[_0xa163('0x95')](_0x5b09bd);});}function countFilteredInteractions(_0xe0a15a,_0x285921){var _0x287cee=_0xe0a15a[_0xa163('0x96')]();_0x287cee['field'](_0xa163('0x97'));_0x287cee['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xa163('0x98'));var _0x488158=utils['getSelectedTags'](_0x285921);if(!_[_0xa163('0x99')](_0x488158)){_0x287cee[_0xa163('0x15')](_0xa163('0x9a'),_0x488158);}var _0x109b64={'type':db[_0xa163('0x6b')][_0xa163('0x6c')]['SELECT'],'raw':!![]};return db[_0xa163('0x91')]['query'](_0x287cee[_0xa163('0x6e')](),_0x109b64);}module[_0xa163('0x9b')]={'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