// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc963=['Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','groupBy','Setting','all','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','isEmpty','t.id\x20IN\x20?','Sequelize','QueryTypes','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','updateInteraction','./utils','../../mysqldb','getAccountFK','role','search','select','field','name','color','tools_tags','user_has_','_interactions','u.id','u.fullname','ui.','from','length','where','\x20IN\x20?','map','getInteractionsTables','getInteractionFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','left_join','users','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','isEmail','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','sqlOperator','conditions','find','default','value','end','unreadMessages','read','and','operator','$substring','split','contact','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','ContactId','buildExpression','type','text','Tag','tags','clause','ids','User','user','UserId','start','body','plainBody','keys','some','compact','concat','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','tag','filter','get','capitalize','chat','Websites','agent','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','SELECT','sequelize','query','toString','merge','fields','a.key','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.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','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','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.phone','c.mobile'];(function(_0x35d4e9,_0x298c61){var _0x5c2770=function(_0x2f326a){while(--_0x2f326a){_0x35d4e9['push'](_0x35d4e9['shift']());}};_0x5c2770(++_0x298c61);}(_0xc963,0xbf));var _0x3c96=function(_0x36f243,_0x188505){_0x36f243=_0x36f243-0x0;var _0x426436=_0xc963[_0x36f243];return _0x426436;};'use strict';var _=require(_0x3c96('0x0'));var squel=require(_0x3c96('0x1'));var as=require(_0x3c96('0x2'));var qs=require(_0x3c96('0x3'));var updateInteraction=require('./update-interaction')[_0x3c96('0x4')];var utils=require(_0x3c96('0x5'));var db=require(_0x3c96('0x6'))['db'];function skipInteractionsQuery(_0x535b5b,_0x232c50,_0x12da48){var _0x5b1a5e=![];var _0x148c37=utils[_0x3c96('0x7')](_0x535b5b);if(_0x232c50[_0x3c96('0x8')]==='agent'&&!_0x12da48[_0x3c96('0x9')]&&!_0x12da48[_0x148c37]){_0x5b1a5e=!![];}return _0x5b1a5e;}function getTagsQuery(){return squel[_0x3c96('0xa')]()[_0x3c96('0xb')]('id')[_0x3c96('0xb')](_0x3c96('0xc'))['field'](_0x3c96('0xd'))['from'](_0x3c96('0xe'));}function getUsersQuery(_0x4429e3,_0x1ae4c0){var _0x280651=utils['getInteractionFK'](_0x4429e3);var _0x3bdccb=_0x3c96('0xf')+_0x4429e3+_0x3c96('0x10');var _0xeb9026=squel[_0x3c96('0xa')]()[_0x3c96('0xb')](_0x3c96('0x11'))[_0x3c96('0xb')](_0x3c96('0x12'))[_0x3c96('0xb')](_0x3c96('0x13')+_0x280651)[_0x3c96('0x14')](_0x3bdccb,'ui')['left_join']('users','u','u.id\x20=\x20ui.UserId');if(_0x1ae4c0[_0x3c96('0x15')]>0x0){_0xeb9026[_0x3c96('0x16')](_0x3c96('0x13')+_0x280651+_0x3c96('0x17'),_[_0x3c96('0x18')](_0x1ae4c0,'id'));}return _0xeb9026;}function getInteractionsQuery(_0x4776e4){var _0x77aa3b=utils[_0x3c96('0x19')](_0x4776e4);var _0x24229a=utils[_0x3c96('0x7')](_0x4776e4);var _0x21f18a=utils[_0x3c96('0x1a')](_0x4776e4);return squel[_0x3c96('0xa')]()['from'](_0x77aa3b[_0x3c96('0x1b')],'i')['left_join'](_0x3c96('0x1c'),'c',_0x3c96('0x1d'))[_0x3c96('0x1e')](_0x3c96('0x1f'),'o',_0x3c96('0x20'))[_0x3c96('0x1e')](_0x77aa3b[_0x3c96('0x21')],'a',_0x3c96('0x22')+_0x24229a)[_0x3c96('0x1e')](_0x77aa3b['messages'],'me',_0x3c96('0x23')+_0x21f18a+_0x3c96('0x24'))['left_join'](_0x77aa3b['interactionsTags'],'it',_0x3c96('0x25')+_0x21f18a+'\x20=\x20i.id')['left_join'](_0x3c96('0xe'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x15ea9e={'body':squel[_0x3c96('0x26')](),'contact':squel[_0x3c96('0x26')](),'default':squel[_0x3c96('0x26')](),'fields':squel[_0x3c96('0x26')](),'filter':squel[_0x3c96('0x26')](),'read':squel[_0x3c96('0x26')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x3c96('0x26')]()};return _0x15ea9e;}function parseTagParameter(_0x41d174){var _0x1069b0=squel[_0x3c96('0x26')]();if(_0x41d174){var _0xa510f7=utils[_0x3c96('0x27')](_0x41d174);_0xa510f7[_0x3c96('0x28')](function(_0x9a403){_0x1069b0['or'](_0x3c96('0x29'),'%,'+_0x9a403+',%');});}return _0x1069b0;}function parseReadParameter(_0x3d3094){var _0x11d60f='';if(_0x3d3094){_0x11d60f=_0x3c96('0x2a');if(_0x3d3094==='1'){_0x11d60f=_0x11d60f[_0x3c96('0x2b')]('{OPERATOR}','=');}else{_0x11d60f=_0x11d60f[_0x3c96('0x2b')](_0x3c96('0x2c'),'>');}}return _0x11d60f;}function parseSearchFilter(_0xdbef53,_0x5a4fc0){var _0x51bffd=squel[_0x3c96('0x26')]();if(_0x5a4fc0){var _0x484683=_0x5a4fc0[_0x3c96('0x2b')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs['isNumeric'](_0x484683)){_0x51bffd['or'](_0x3c96('0x2d'),_0x484683+'%');if([_0x3c96('0x2e'),_0x3c96('0x2f')]['includes'](_0xdbef53)){_0x51bffd['or'](_0x3c96('0x30'),_0x484683+'%');}else if(_0xdbef53===_0x3c96('0x31')){_0x51bffd['or'](_0x3c96('0x32'),_0x484683+'%');}else if(_0xdbef53===_0x3c96('0x33')){_0x51bffd['or'](_0x3c96('0x34'),_0x484683+'%');}}else if(_0xdbef53==='mail'&&qs[_0x3c96('0x35')](_0x484683)){_0x51bffd['or']('c.email\x20LIKE\x20?',_0x484683+'%');}else{if(_0xdbef53===_0x3c96('0x36')){_0x51bffd['or'](_0x3c96('0x37'),qs[_0x3c96('0x38')](_0x484683,!![]))['or'](_0x3c96('0x39'),qs[_0x3c96('0x38')](_0x484683));}else if(_0xdbef53!==_0x3c96('0x31')){_0x51bffd['or'](_0x3c96('0x3a'),qs[_0x3c96('0x38')](_0x484683));}_0x51bffd['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x3c96('0x38')](_0x484683,!![]),null);}}return _0x51bffd;}function parseAdvancedSearchFilter(_0x21542e,_0x2b09ab){var _0x3de53b=getSqlClauses();var _0x2f1145=as['parseSearch'](_0x21542e);var _0x1265bb=_0x2f1145[_0x3c96('0x3b')];for(var _0x546b97=0x0;_0x546b97<_0x2f1145[_0x3c96('0x3c')][_0x3c96('0x15')];_0x546b97++){var _0x38600e=_0x2f1145[_0x3c96('0x3c')][_0x546b97];var _0x7c0852='i';var _0x4215e8=_[_0x3c96('0x3d')](_0x2b09ab,['name',_0x38600e[_0x3c96('0xb')]]);if(_0x4215e8){var _0x7cb0d7=as['buildExpression'](_0x7c0852,_0x4215e8['type'],_0x38600e);_0x3de53b[_0x3c96('0x3e')][_0x1265bb](_0x7cb0d7['text'],_0x7cb0d7[_0x3c96('0x3f')]['start'],_0x7cb0d7[_0x3c96('0x3f')][_0x3c96('0x40')]);}else{switch(_0x38600e[_0x3c96('0xb')]){case _0x3c96('0x41'):var _0x41092f=parseReadParameter(_0x38600e[_0x3c96('0x3f')]);_0x3de53b[_0x3c96('0x42')][_0x3c96('0x43')](_0x41092f);break;case'Contact':if(_0x38600e[_0x3c96('0x44')]===_0x3c96('0x45')){if(_0x38600e[_0x3c96('0x3f')][_0x3c96('0x46')]('\x20')[_0x3c96('0x15')]>0x1){_0x3de53b[_0x3c96('0x47')][_0x1265bb](_0x3c96('0x48'),qs['getFullTextValue'](_0x38600e[_0x3c96('0x3f')],!![]),null);}else{var _0x22c6b8='%'+_0x38600e['value']+'%';_0x3de53b[_0x3c96('0x47')][_0x1265bb]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x22c6b8,_0x22c6b8,_0x22c6b8);}}else{_0x4215e8=_[_0x3c96('0x3d')](_0x2b09ab,[_0x3c96('0xc'),_0x3c96('0x49')]);_0x38600e[_0x3c96('0xb')]='ContactId';_0x7cb0d7=as[_0x3c96('0x4a')](_0x7c0852,_0x4215e8[_0x3c96('0x4b')],_0x38600e);_0x3de53b[_0x3c96('0x47')][_0x1265bb](_0x7cb0d7[_0x3c96('0x4c')],_0x7cb0d7[_0x3c96('0x3f')]['start'],_0x7cb0d7['value'][_0x3c96('0x40')]);}break;case _0x3c96('0x4d'):var _0x25da80=_0x38600e[_0x3c96('0x3f')]['split'](',')[_0x3c96('0x18')](function(_0x798b96){return Number(_0x798b96);});var _0x1826b3=parseTagParameter(_0x25da80);_0x3de53b[_0x3c96('0x4e')][_0x3c96('0x4f')][_0x3c96('0x43')](_0x1826b3);_0x3de53b[_0x3c96('0x4e')][_0x3c96('0x50')]=_0x25da80;break;case _0x3c96('0x51'):if(_0x38600e[_0x3c96('0x44')]===_0x3c96('0x45')){_0x3de53b[_0x3c96('0x52')][_0x1265bb]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x38600e['value']+'%',null);}else{_0x4215e8=_[_0x3c96('0x3d')](_0x2b09ab,[_0x3c96('0xc'),'UserId']);_0x38600e[_0x3c96('0xb')]=_0x3c96('0x53');_0x7cb0d7=as[_0x3c96('0x4a')](_0x7c0852,_0x4215e8[_0x3c96('0x4b')],_0x38600e);_0x3de53b['user'][_0x1265bb](_0x7cb0d7[_0x3c96('0x4c')],_0x7cb0d7['value'][_0x3c96('0x54')],_0x7cb0d7['value'][_0x3c96('0x40')]);}break;case _0x3c96('0x55'):case _0x3c96('0x56'):_0x7cb0d7=as[_0x3c96('0x4a')]('me',null,_0x38600e);_0x3de53b[_0x3c96('0x55')][_0x1265bb](_0x7cb0d7[_0x3c96('0x4c')],_0x7cb0d7[_0x3c96('0x3f')][_0x3c96('0x54')],_0x7cb0d7['value'][_0x3c96('0x40')]);break;}}}return _0x3de53b;}function parseModelFields(_0x5613a4,_0x500db2,_0x24ed49){var _0xb86b9f=utils[_0x3c96('0x7')](_0x5613a4);var _0x2334d1=squel[_0x3c96('0x26')]();var _0x39140f=_(_0x500db2)[_0x3c96('0x57')]()[_0x3c96('0x18')](function(_0x5b1c9e){return _[_0x3c96('0x58')](_0x24ed49,['name',_0x5b1c9e])?_0x5b1c9e:undefined;})[_0x3c96('0x59')]()[_0x3c96('0x3f')]();if(_0x39140f[_0x3c96('0x15')]>0x0){_0x39140f['forEach'](function(_0x2c9245){if(_0x2c9245===_0xb86b9f){_0x2334d1['and']('i.'+_0xb86b9f+'\x20IN\x20?',[][_0x3c96('0x5a')](_0x500db2[_0x2c9245]));}else if(_0x2c9245==='createdAt'){var _0x4fa6e4=JSON[_0x3c96('0x5b')](_0x500db2[_0x2c9245])[_0x3c96('0x5c')];var _0x30a885=JSON[_0x3c96('0x5b')](_0x500db2[_0x2c9245])[_0x3c96('0x5d')];_0x2334d1[_0x3c96('0x43')](_0x3c96('0x5e'),_0x4fa6e4,_0x30a885);}else{if(_0x500db2[_0x2c9245]===_0x3c96('0x5f')){_0x2334d1[_0x3c96('0x43')]('i.'+_0x2c9245+_0x3c96('0x60'));}else{_0x2334d1[_0x3c96('0x43')]('i.'+_0x2c9245+_0x3c96('0x61'),_0x500db2[_0x2c9245]);}}});}return _0x2334d1;}function parseQueryParameters(_0x3eeca3,_0x42ca1f,_0x4353a0){var _0x14e37b=getSqlClauses();return Promise[_0x3c96('0x62')]()[_0x3c96('0x63')](function(){return parseModelFields(_0x3eeca3,_0x42ca1f,_0x4353a0);})[_0x3c96('0x63')](function(_0x20a724){_0x14e37b['fields'][_0x3c96('0x43')](_0x20a724);return parseReadParameter(_0x42ca1f[_0x3c96('0x42')]);})[_0x3c96('0x63')](function(_0x4911ac){_0x14e37b['read']['and'](_0x4911ac);return parseTagParameter(_0x42ca1f[_0x3c96('0x64')]);})[_0x3c96('0x63')](function(_0x2ad71c){_0x14e37b[_0x3c96('0x4e')][_0x3c96('0x4f')][_0x3c96('0x43')](_0x2ad71c);return parseSearchFilter(_0x3eeca3,_0x42ca1f[_0x3c96('0x65')]);})[_0x3c96('0x63')](function(_0x597637){_0x14e37b[_0x3c96('0x65')]=_0x597637;return _0x14e37b;});}function checkAccountsRestrictions(_0x3d15e0,_0x41951d,_0x1dfea7){var _0x1c6897=utils[_0x3c96('0x7')](_0x3d15e0);var _0x16c337=_0x3c96('0x66')+_[_0x3c96('0x67')](_0x3d15e0)+(_0x3d15e0===_0x3c96('0x68')?_0x3c96('0x69'):'Accounts');var _0x2f7570=squel[_0x3c96('0x26')]();return Promise[_0x3c96('0x62')]()[_0x3c96('0x63')](function(){if(_0x1dfea7['search']&&_0x41951d[_0x3c96('0x8')]===_0x3c96('0x6a')){return _0x41951d[_0x16c337]({'attributes':['id'],'raw':!![]});}})[_0x3c96('0x63')](function(_0x2cbd8a){if(_0x2cbd8a){if(_0x2cbd8a[_0x3c96('0x15')]===0x0){_0x2f7570[_0x3c96('0x43')]('i.'+_0x1c6897+_0x3c96('0x60'));}else{_0x2f7570[_0x3c96('0x43')]('i.'+_0x1c6897+'\x20IN\x20?',_['map'](_0x2cbd8a,'id'));}}else if(!_0x1dfea7[_0x1c6897]){_0x2f7570[_0x3c96('0x43')]('i.'+_0x1c6897+'\x20IS\x20NOT\x20NULL');}})[_0x3c96('0x63')](function(){return _0x2f7570;});}function getClosedOrderClause(_0x57e90f,_0x920341){var _0x3cc284='';var _0x1e3461=[_0x3c96('0x6b'),_0x3c96('0x6c'),_0x3c96('0x6d')];if(_0x57e90f==='mail'){_0x1e3461[_0x3c96('0x6e')](_0x3c96('0x6f'));}if(_0x920341[_0x3c96('0x70')]==='0'&&_0x57e90f===_0x3c96('0x36')){_0x3cc284='i.substatus';}else{if(_0x920341[_0x3c96('0x70')]==='1'){_0x1e3461[_0x3c96('0x71')]();}_0x3cc284=_0x3c96('0x72')+_0x1e3461[_0x3c96('0x73')](',\x20')+')';}return _0x3cc284;}function getFilteredInteractions(_0x3c3c16,_0xbfd684,_0x33928b,_0x4506a6){var _0x24c224=utils[_0x3c96('0x1a')](_0x3c3c16);var _0x39d0ea=_[_0x3c96('0x67')](_0x3c3c16)+_0x3c96('0x74');var _0x4cad93=[];var _0x27feb3=getTagsQuery();var _0x162e1a={'type':db['Sequelize']['QueryTypes'][_0x3c96('0x75')],'raw':!![]};var _0x155ef6=[];var _0x130d90=[];return db[_0x3c96('0x76')][_0x3c96('0x77')](_0x27feb3[_0x3c96('0x78')](),_0x162e1a)[_0x3c96('0x63')](function(_0x481b88){_0x4cad93=_['keyBy'](_0x481b88,'id');_0x162e1a=_[_0x3c96('0x79')](_0x162e1a,{'model':db[_0x39d0ea],'mapToModel':!![],'nest':!![]});if(_0x33928b[_0x3c96('0x7a')]){_0x4506a6['attributes'][_0x3c96('0x28')](function(_0x26471d){_0xbfd684['field']('i.'+_0x26471d);});}else{_0xbfd684[_0x3c96('0xb')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x3c96('0x41'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x7b'),_0x3c96('0x7c'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x7d'),_0x3c96('0x7e'));if(_0x3c3c16==='mail'){_0xbfd684[_0x3c96('0xb')]('a.email',_0x3c96('0x7f'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x80'),_0x3c96('0x81'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x82'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x83'));_0xbfd684['field'](_0x3c96('0x84'));_0xbfd684['field'](_0x3c96('0x85'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x86'));_0xbfd684['field'](_0x3c96('0x87'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x88'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x89'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8a'));_0xbfd684['field'](_0x3c96('0x6d'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x6c'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x6b'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x6f'));_0xbfd684[_0x3c96('0xb')]('i.to');_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8b'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8c'));_0xbfd684['field'](_0x3c96('0x8d'));}else if(_0x3c3c16===_0x3c96('0x33')){_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8e'),_0x3c96('0x81'));}else{_0xbfd684[_0x3c96('0xb')]('CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END',_0x3c96('0x81'));}if(_0x3c3c16!=='mail'){_0xbfd684[_0x3c96('0xb')]('i.*');}_0xbfd684[_0x3c96('0xb')]('c.firstName',_0x3c96('0x8f'));_0xbfd684['field'](_0x3c96('0x90'),_0x3c96('0x91'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x92'),'Contact.email');_0xbfd684[_0x3c96('0xb')]('c.phone',_0x3c96('0x93'));_0xbfd684['field'](_0x3c96('0x94'),_0x3c96('0x95'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x96'),_0x3c96('0x97'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x98'),_0x3c96('0x99'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x9a'),_0x3c96('0x9b'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x9c'),_0x3c96('0x9d'));}if(_0x4506a6[_0x3c96('0x9e')]){_0xbfd684['limit'](_0x4506a6[_0x3c96('0x9e')]);}if(_0x4506a6[_0x3c96('0x9f')]){_0xbfd684[_0x3c96('0x9f')](_0x4506a6['offset']);}return db[_0x3c96('0x76')]['query'](_0xbfd684[_0x3c96('0x78')](),_0x162e1a);})[_0x3c96('0x63')](function(_0x1023ea){_0x155ef6=_0x1023ea;var _0x5a5b9b=getUsersQuery(_0x3c3c16,_0x155ef6);return db['sequelize']['query'](_0x5a5b9b[_0x3c96('0x78')](),_0x162e1a);})['then'](function(_0x40a2f5){_0x130d90=_[_0x3c96('0xa0')](_0x40a2f5,_0x24c224);if(_0x3c3c16===_0x3c96('0x36')){return db[_0x3c96('0xa1')]['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x3c96('0x63')](function(_0x34782e){var _0x524d10=_0x34782e?_0x34782e['enableEmailPreview']:undefined;var _0x5eb71=_0x155ef6[_0x3c96('0x18')](function(_0x62a461){return updateInteraction(_0x62a461,_0x4cad93,_0x130d90,_0x524d10);});return Promise[_0x3c96('0xa2')](_0x5eb71);});}function countFilteredInteractions(_0x558309,_0x586703){var _0x30a5bb=_0x558309['clone']();_0x30a5bb[_0x3c96('0xb')](_0x3c96('0xa3'));_0x30a5bb[_0x3c96('0xb')](_0x3c96('0xa4'),_0x3c96('0x41'));var _0x2319ba=utils[_0x3c96('0x27')](_0x586703);if(!_[_0x3c96('0xa5')](_0x2319ba)){_0x30a5bb['where'](_0x3c96('0xa6'),_0x2319ba);}var _0x11fcab={'type':db[_0x3c96('0xa7')][_0x3c96('0xa8')][_0x3c96('0x75')],'raw':!![]};return db[_0x3c96('0x76')][_0x3c96('0x77')](_0x30a5bb[_0x3c96('0x78')](),_0x11fcab);}module[_0x3c96('0xa9')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x670a=['i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','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','i.*','c.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.mobile','Contact.mobile','c.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','groupBy','Setting','enableEmailPreview','all','clone','COUNT(*)','isEmpty','exports','squel','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','getAccountFK','role','agent','select','field','color','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','getInteractionsTables','interactions','cm_contacts','o.id\x20=\x20i.UserId','a.id\x20=\x20i.','me.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','mail','isEmail','c.email\x20LIKE\x20?','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','find','buildExpression','type','default','value','read','and','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','name','ContactId','text','start','Tag','map','tags','clause','ids','User','user','body','plainBody','end','keys','some','compact','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','resolve','then','fields','tag','filter','get','chat','Websites','Accounts','search','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','capitalize','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','a.key','Account.key','Account.mandatoryDisposition','contactName','i.id','i.createdAt','i.closed'];(function(_0x4792c8,_0x5158a1){var _0x35edb1=function(_0x2472d3){while(--_0x2472d3){_0x4792c8['push'](_0x4792c8['shift']());}};_0x35edb1(++_0x5158a1);}(_0x670a,0x172));var _0xa670=function(_0x5a2be1,_0xca851c){_0x5a2be1=_0x5a2be1-0x0;var _0x1a21e4=_0x670a[_0x5a2be1];return _0x1a21e4;};'use strict';var _=require('lodash');var squel=require(_0xa670('0x0'));var as=require('../parsers/advancedSearch');var qs=require(_0xa670('0x1'));var updateInteraction=require(_0xa670('0x2'))[_0xa670('0x3')];var utils=require(_0xa670('0x4'));var db=require(_0xa670('0x5'))['db'];function skipInteractionsQuery(_0x36ec77,_0x38aa1d,_0x5bd632){var _0x255ccc=![];var _0xc84fe2=utils[_0xa670('0x6')](_0x36ec77);if(_0x38aa1d[_0xa670('0x7')]===_0xa670('0x8')&&!_0x5bd632['search']&&!_0x5bd632[_0xc84fe2]){_0x255ccc=!![];}return _0x255ccc;}function getTagsQuery(){return squel[_0xa670('0x9')]()[_0xa670('0xa')]('id')['field']('name')['field'](_0xa670('0xb'))[_0xa670('0xc')](_0xa670('0xd'));}function getUsersQuery(_0x4ddf84,_0x4761b9){var _0x883faa=utils[_0xa670('0xe')](_0x4ddf84);var _0x137bef=_0xa670('0xf')+_0x4ddf84+_0xa670('0x10');var _0x348520=squel[_0xa670('0x9')]()[_0xa670('0xa')](_0xa670('0x11'))['field'](_0xa670('0x12'))[_0xa670('0xa')](_0xa670('0x13')+_0x883faa)[_0xa670('0xc')](_0x137bef,'ui')[_0xa670('0x14')](_0xa670('0x15'),'u',_0xa670('0x16'));if(_0x4761b9[_0xa670('0x17')]>0x0){_0x348520[_0xa670('0x18')](_0xa670('0x13')+_0x883faa+_0xa670('0x19'),_['map'](_0x4761b9,'id'));}return _0x348520;}function getInteractionsQuery(_0x25b303){var _0x3a0d8f=utils[_0xa670('0x1a')](_0x25b303);var _0x3009b1=utils['getAccountFK'](_0x25b303);var _0x1309a2=utils[_0xa670('0xe')](_0x25b303);return squel['select']()[_0xa670('0xc')](_0x3a0d8f[_0xa670('0x1b')],'i')[_0xa670('0x14')](_0xa670('0x1c'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')['left_join']('users','o',_0xa670('0x1d'))['left_join'](_0x3a0d8f['accounts'],'a',_0xa670('0x1e')+_0x3009b1)['left_join'](_0x3a0d8f['messages'],'me',_0xa670('0x1f')+_0x1309a2+_0xa670('0x20'))['left_join'](_0x3a0d8f[_0xa670('0x21')],'it',_0xa670('0x22')+_0x1309a2+'\x20=\x20i.id')['left_join'](_0xa670('0xd'),'t',_0xa670('0x23'));}function getSqlClauses(){var _0xaaf35a={'body':squel[_0xa670('0x24')](),'contact':squel[_0xa670('0x24')](),'default':squel['expr'](),'fields':squel[_0xa670('0x24')](),'filter':squel[_0xa670('0x24')](),'read':squel['expr'](),'tags':{'clause':squel[_0xa670('0x24')](),'ids':null},'user':squel[_0xa670('0x24')]()};return _0xaaf35a;}function parseTagParameter(_0x7f2b7c){var _0x5066b9=squel['expr']();if(_0x7f2b7c){var _0x28ca08=utils['getSelectedTags'](_0x7f2b7c);_0x28ca08[_0xa670('0x25')](function(_0x8c34c9){_0x5066b9['or'](_0xa670('0x26'),'%,'+_0x8c34c9+',%');});}return _0x5066b9;}function parseReadParameter(_0x43f430){var _0xb218d='';if(_0x43f430){_0xb218d='unreadMessages\x20{OPERATOR}\x200';if(_0x43f430==='1'){_0xb218d=_0xb218d[_0xa670('0x27')]('{OPERATOR}','=');}else{_0xb218d=_0xb218d[_0xa670('0x27')](_0xa670('0x28'),'>');}}return _0xb218d;}function parseSearchFilter(_0x276107,_0xec7d70){var _0x690b72=squel[_0xa670('0x24')]();if(_0xec7d70){var _0x1f4efd=_0xec7d70['replace']('\x5c','\x5c\x5c')[_0xa670('0x27')](/'/g,'\x27\x27');if(qs[_0xa670('0x29')](_0x1f4efd)){_0x690b72['or'](_0xa670('0x2a'),_0x1f4efd+'%');if([_0xa670('0x2b'),_0xa670('0x2c')][_0xa670('0x2d')](_0x276107)){_0x690b72['or'](_0xa670('0x2e'),_0x1f4efd+'%');}else if(_0x276107===_0xa670('0x2f')){_0x690b72['or'](_0xa670('0x30'),_0x1f4efd+'%');}else if(_0x276107===_0xa670('0x31')){_0x690b72['or']('i.from\x20LIKE\x20?',_0x1f4efd+'%');}}else if(_0x276107===_0xa670('0x32')&&qs[_0xa670('0x33')](_0x1f4efd)){_0x690b72['or'](_0xa670('0x34'),_0x1f4efd+'%');}else{if(_0x276107===_0xa670('0x32')){_0x690b72['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x1f4efd,!![]))['or'](_0xa670('0x35'),qs[_0xa670('0x36')](_0x1f4efd));}else if(_0x276107!==_0xa670('0x2f')){_0x690b72['or'](_0xa670('0x37'),qs[_0xa670('0x36')](_0x1f4efd));}_0x690b72['or'](_0xa670('0x38'),qs[_0xa670('0x36')](_0x1f4efd,!![]),null);}}return _0x690b72;}function parseAdvancedSearchFilter(_0x103c86,_0x463e97){var _0x17005c=getSqlClauses();var _0x2ee196=as[_0xa670('0x39')](_0x103c86);var _0x20535e=_0x2ee196[_0xa670('0x3a')];for(var _0x48aadb=0x0;_0x48aadb<_0x2ee196[_0xa670('0x3b')][_0xa670('0x17')];_0x48aadb++){var _0x388136=_0x2ee196['conditions'][_0x48aadb];var _0x5bb1fa='i';var _0x261e7e=_[_0xa670('0x3c')](_0x463e97,['name',_0x388136[_0xa670('0xa')]]);if(_0x261e7e){var _0x25a98f=as[_0xa670('0x3d')](_0x5bb1fa,_0x261e7e[_0xa670('0x3e')],_0x388136);_0x17005c[_0xa670('0x3f')][_0x20535e](_0x25a98f['text'],_0x25a98f[_0xa670('0x40')]['start'],_0x25a98f['value']['end']);}else{switch(_0x388136[_0xa670('0xa')]){case'unreadMessages':var _0x5d546c=parseReadParameter(_0x388136[_0xa670('0x40')]);_0x17005c[_0xa670('0x41')][_0xa670('0x42')](_0x5d546c);break;case'Contact':if(_0x388136[_0xa670('0x43')]===_0xa670('0x44')){if(_0x388136['value'][_0xa670('0x45')]('\x20')[_0xa670('0x17')]>0x1){_0x17005c[_0xa670('0x46')][_0x20535e](_0xa670('0x38'),qs[_0xa670('0x36')](_0x388136[_0xa670('0x40')],!![]),null);}else{var _0x3b6fe3='%'+_0x388136['value']+'%';_0x17005c[_0xa670('0x46')][_0x20535e](_0xa670('0x47'),_0x3b6fe3,_0x3b6fe3,_0x3b6fe3);}}else{_0x261e7e=_[_0xa670('0x3c')](_0x463e97,[_0xa670('0x48'),_0xa670('0x49')]);_0x388136[_0xa670('0xa')]=_0xa670('0x49');_0x25a98f=as[_0xa670('0x3d')](_0x5bb1fa,_0x261e7e[_0xa670('0x3e')],_0x388136);_0x17005c[_0xa670('0x46')][_0x20535e](_0x25a98f[_0xa670('0x4a')],_0x25a98f[_0xa670('0x40')][_0xa670('0x4b')],_0x25a98f['value']['end']);}break;case _0xa670('0x4c'):var _0x5a109b=_0x388136[_0xa670('0x40')]['split'](',')[_0xa670('0x4d')](function(_0x8144e1){return Number(_0x8144e1);});var _0x60fe46=parseTagParameter(_0x5a109b);_0x17005c[_0xa670('0x4e')][_0xa670('0x4f')]['and'](_0x60fe46);_0x17005c['tags'][_0xa670('0x50')]=_0x5a109b;break;case _0xa670('0x51'):if(_0x388136[_0xa670('0x43')]===_0xa670('0x44')){_0x17005c[_0xa670('0x52')][_0x20535e]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x388136[_0xa670('0x40')]+'%',null);}else{_0x261e7e=_['find'](_0x463e97,[_0xa670('0x48'),'UserId']);_0x388136[_0xa670('0xa')]='UserId';_0x25a98f=as[_0xa670('0x3d')](_0x5bb1fa,_0x261e7e[_0xa670('0x3e')],_0x388136);_0x17005c[_0xa670('0x52')][_0x20535e](_0x25a98f[_0xa670('0x4a')],_0x25a98f['value'][_0xa670('0x4b')],_0x25a98f['value']['end']);}break;case _0xa670('0x53'):case _0xa670('0x54'):_0x25a98f=as[_0xa670('0x3d')]('me',null,_0x388136);_0x17005c[_0xa670('0x53')][_0x20535e](_0x25a98f[_0xa670('0x4a')],_0x25a98f[_0xa670('0x40')]['start'],_0x25a98f['value'][_0xa670('0x55')]);break;}}}return _0x17005c;}function parseModelFields(_0x3a65ea,_0x576a1b,_0x492f3f){var _0x23174e=utils['getAccountFK'](_0x3a65ea);var _0x3d9406=squel[_0xa670('0x24')]();var _0x1a6b56=_(_0x576a1b)[_0xa670('0x56')]()[_0xa670('0x4d')](function(_0x2b939c){return _[_0xa670('0x57')](_0x492f3f,['name',_0x2b939c])?_0x2b939c:undefined;})[_0xa670('0x58')]()[_0xa670('0x40')]();if(_0x1a6b56['length']>0x0){_0x1a6b56[_0xa670('0x25')](function(_0x2d4c23){if(_0x2d4c23===_0x23174e){_0x3d9406[_0xa670('0x42')]('i.'+_0x23174e+_0xa670('0x19'),[][_0xa670('0x59')](_0x576a1b[_0x2d4c23]));}else if(_0x2d4c23===_0xa670('0x5a')){var _0x183348=JSON[_0xa670('0x5b')](_0x576a1b[_0x2d4c23])[_0xa670('0x5c')];var _0xf9c3b6=JSON[_0xa670('0x5b')](_0x576a1b[_0x2d4c23])[_0xa670('0x5d')];_0x3d9406[_0xa670('0x42')](_0xa670('0x5e'),_0x183348,_0xf9c3b6);}else{if(_0x576a1b[_0x2d4c23]==='null'){_0x3d9406[_0xa670('0x42')]('i.'+_0x2d4c23+_0xa670('0x5f'));}else{_0x3d9406[_0xa670('0x42')]('i.'+_0x2d4c23+'\x20=\x20?',_0x576a1b[_0x2d4c23]);}}});}return _0x3d9406;}function parseQueryParameters(_0x3781d9,_0x122f1e,_0x3f60c7){var _0x52dafa=getSqlClauses();return Promise[_0xa670('0x60')]()[_0xa670('0x61')](function(){return parseModelFields(_0x3781d9,_0x122f1e,_0x3f60c7);})[_0xa670('0x61')](function(_0x133b3e){_0x52dafa[_0xa670('0x62')][_0xa670('0x42')](_0x133b3e);return parseReadParameter(_0x122f1e[_0xa670('0x41')]);})[_0xa670('0x61')](function(_0x599a2e){_0x52dafa[_0xa670('0x41')][_0xa670('0x42')](_0x599a2e);return parseTagParameter(_0x122f1e[_0xa670('0x63')]);})[_0xa670('0x61')](function(_0x2ed097){_0x52dafa['tags'][_0xa670('0x4f')][_0xa670('0x42')](_0x2ed097);return parseSearchFilter(_0x3781d9,_0x122f1e[_0xa670('0x64')]);})[_0xa670('0x61')](function(_0x5ad0bf){_0x52dafa[_0xa670('0x64')]=_0x5ad0bf;return _0x52dafa;});}function checkAccountsRestrictions(_0xc70561,_0x1fb7bb,_0x387ecd){var _0x25cd6a=utils[_0xa670('0x6')](_0xc70561);var _0x5a9ed6=_0xa670('0x65')+_['capitalize'](_0xc70561)+(_0xc70561===_0xa670('0x66')?_0xa670('0x67'):_0xa670('0x68'));var _0x44b2ba=squel[_0xa670('0x24')]();return Promise[_0xa670('0x60')]()[_0xa670('0x61')](function(){if(_0x387ecd[_0xa670('0x69')]&&_0x1fb7bb[_0xa670('0x7')]===_0xa670('0x8')){return _0x1fb7bb[_0x5a9ed6]({'attributes':['id'],'raw':!![]});}})[_0xa670('0x61')](function(_0x1cbe19){if(_0x1cbe19){if(_0x1cbe19[_0xa670('0x17')]===0x0){_0x44b2ba[_0xa670('0x42')]('i.'+_0x25cd6a+_0xa670('0x5f'));}else{_0x44b2ba[_0xa670('0x42')]('i.'+_0x25cd6a+_0xa670('0x19'),_[_0xa670('0x4d')](_0x1cbe19,'id'));}}else if(!_0x387ecd[_0x25cd6a]){_0x44b2ba['and']('i.'+_0x25cd6a+_0xa670('0x6a'));}})[_0xa670('0x61')](function(){return _0x44b2ba;});}function getClosedOrderClause(_0x45f906,_0xcbf1cd){var _0x31a987='';var _0x1014c0=['i.thirdDisposition',_0xa670('0x6b'),_0xa670('0x6c')];if(_0x45f906===_0xa670('0x32')){_0x1014c0[_0xa670('0x6d')](_0xa670('0x6e'));}if(_0xcbf1cd[_0xa670('0x6f')]==='0'&&_0x45f906==='mail'){_0x31a987=_0xa670('0x6e');}else{if(_0xcbf1cd[_0xa670('0x6f')]==='1'){_0x1014c0[_0xa670('0x70')]();}_0x31a987=_0xa670('0x71')+_0x1014c0['join'](',\x20')+')';}return _0x31a987;}function getFilteredInteractions(_0x33e6d2,_0x31823b,_0xb31a1e,_0x23840b){var _0x28fff8=utils[_0xa670('0xe')](_0x33e6d2);var _0x561649=_[_0xa670('0x72')](_0x33e6d2)+_0xa670('0x73');var _0x4a8816=[];var _0x254598=getTagsQuery();var _0x5b6293={'type':db[_0xa670('0x74')][_0xa670('0x75')][_0xa670('0x76')],'raw':!![]};var _0x37642c=[];var _0x3756be=[];return db[_0xa670('0x77')][_0xa670('0x78')](_0x254598[_0xa670('0x79')](),_0x5b6293)['then'](function(_0x4dee11){_0x4a8816=_[_0xa670('0x7a')](_0x4dee11,'id');_0x5b6293=_[_0xa670('0x7b')](_0x5b6293,{'model':db[_0x561649],'mapToModel':!![],'nest':!![]});if(_0xb31a1e[_0xa670('0x62')]){_0x23840b[_0xa670('0x7c')][_0xa670('0x25')](function(_0x4a8cce){_0x31823b[_0xa670('0xa')]('i.'+_0x4a8cce);});}else{_0x31823b[_0xa670('0xa')](_0xa670('0x7d'),_0xa670('0x7e'));_0x31823b[_0xa670('0xa')](_0xa670('0x7f'),_0xa670('0x80'));_0x31823b[_0xa670('0xa')]('a.mandatoryDisposition',_0xa670('0x81'));if(_0x33e6d2==='mail'){_0x31823b['field']('a.email','Account.email');_0x31823b[_0xa670('0xa')]('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',_0xa670('0x82'));_0x31823b[_0xa670('0xa')](_0xa670('0x83'));_0x31823b[_0xa670('0xa')](_0xa670('0x84'));_0x31823b['field']('i.updatedAt');_0x31823b[_0xa670('0xa')](_0xa670('0x85'));_0x31823b[_0xa670('0xa')](_0xa670('0x86'));_0x31823b[_0xa670('0xa')](_0xa670('0x87'));_0x31823b[_0xa670('0xa')](_0xa670('0x88'));_0x31823b[_0xa670('0xa')](_0xa670('0x89'));_0x31823b[_0xa670('0xa')]('i.subject');_0x31823b[_0xa670('0xa')](_0xa670('0x6c'));_0x31823b['field'](_0xa670('0x6b'));_0x31823b[_0xa670('0xa')](_0xa670('0x8a'));_0x31823b['field'](_0xa670('0x6e'));_0x31823b[_0xa670('0xa')](_0xa670('0x8b'));_0x31823b[_0xa670('0xa')](_0xa670('0x8c'));_0x31823b['field'](_0xa670('0x8d'));_0x31823b[_0xa670('0xa')](_0xa670('0x8e'));}else if(_0x33e6d2===_0xa670('0x31')){_0x31823b['field'](_0xa670('0x8f'),'contactName');}else{_0x31823b[_0xa670('0xa')]('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',_0xa670('0x82'));}if(_0x33e6d2!==_0xa670('0x32')){_0x31823b['field'](_0xa670('0x90'));}_0x31823b[_0xa670('0xa')](_0xa670('0x91'),'Contact.firstName');_0x31823b[_0xa670('0xa')](_0xa670('0x92'),_0xa670('0x93'));_0x31823b[_0xa670('0xa')](_0xa670('0x94'),_0xa670('0x95'));_0x31823b['field']('c.phone','Contact.phone');_0x31823b['field'](_0xa670('0x96'),_0xa670('0x97'));_0x31823b[_0xa670('0xa')](_0xa670('0x98'),'Contact.fax');_0x31823b[_0xa670('0xa')](_0xa670('0x99'),'Owner.fullname');_0x31823b['field'](_0xa670('0x9a'),_0xa670('0x9b'));_0x31823b['field'](_0xa670('0x9c'),_0xa670('0x9d'));}if(_0x23840b['limit']){_0x31823b['limit'](_0x23840b[_0xa670('0x9e')]);}if(_0x23840b[_0xa670('0x9f')]){_0x31823b[_0xa670('0x9f')](_0x23840b[_0xa670('0x9f')]);}return db[_0xa670('0x77')][_0xa670('0x78')](_0x31823b[_0xa670('0x79')](),_0x5b6293);})[_0xa670('0x61')](function(_0x1d1c45){_0x37642c=_0x1d1c45;var _0x12474b=getUsersQuery(_0x33e6d2,_0x37642c);return db[_0xa670('0x77')][_0xa670('0x78')](_0x12474b[_0xa670('0x79')](),_0x5b6293);})[_0xa670('0x61')](function(_0xde563a){_0x3756be=_[_0xa670('0xa0')](_0xde563a,_0x28fff8);if(_0x33e6d2==='mail'){return db[_0xa670('0xa1')]['findOne']({'attributes':[_0xa670('0xa2')],'raw':!![]});}})[_0xa670('0x61')](function(_0x14cc2b){var _0x257ba7=_0x14cc2b?_0x14cc2b[_0xa670('0xa2')]:undefined;var _0x208c9d=_0x37642c[_0xa670('0x4d')](function(_0x2ee0c1){return updateInteraction(_0x2ee0c1,_0x4a8816,_0x3756be,_0x257ba7);});return Promise[_0xa670('0xa3')](_0x208c9d);});}function countFilteredInteractions(_0x40de44,_0x203581){var _0x5e50f0=_0x40de44[_0xa670('0xa4')]();_0x5e50f0[_0xa670('0xa')](_0xa670('0xa5'));_0x5e50f0[_0xa670('0xa')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');var _0x5dca3e=utils['getSelectedTags'](_0x203581);if(!_[_0xa670('0xa6')](_0x5dca3e)){_0x5e50f0['where']('t.id\x20IN\x20?',_0x5dca3e);}var _0x12b924={'type':db[_0xa670('0x74')][_0xa670('0x75')][_0xa670('0x76')],'raw':!![]};return db[_0xa670('0x77')][_0xa670('0x78')](_0x5e50f0[_0xa670('0x79')](),_0x12b924);}module[_0xa670('0xa7')]={'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