// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xec44=['MATCH\x20(i.to,\x20i.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','find','buildExpression','type','default','text','value','unreadMessages','read','and','Contact','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','start','Tag','tags','clause','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','end','body','plainBody','keys','some','compact','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','resolve','then','fields','filter','get','capitalize','chat','Websites','role','\x20IS\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','SELECT','sequelize','toString','keyBy','merge','attributes','a.key','Account.key','a.email','Account.email','contactName','i.id','i.createdAt','i.updatedAt','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.to','i.ContactId','i.UserId','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','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','Contact.email','c.phone','Contact.phone','c.mobile','c.fax','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','query','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','isEmpty','t.id\x20IN\x20?','Sequelize','squel','./update-interaction','./utils','../../mysqldb','getAccountFK','agent','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','length','where','\x20IN\x20?','map','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','messages','me.','interactionsTags','it.','\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','{OPERATOR}','replace','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','i.from\x20LIKE\x20?','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','mail','isEmail','c.email\x20LIKE\x20?'];(function(_0x5054c6,_0x3b703c){var _0x36ccd2=function(_0x22a78d){while(--_0x22a78d){_0x5054c6['push'](_0x5054c6['shift']());}};_0x36ccd2(++_0x3b703c);}(_0xec44,0x118));var _0x4ec4=function(_0x28aea5,_0x3bb12e){_0x28aea5=_0x28aea5-0x0;var _0x6a55f9=_0xec44[_0x28aea5];return _0x6a55f9;};'use strict';var _=require('lodash');var squel=require(_0x4ec4('0x0'));var as=require('../parsers/advancedSearch');var qs=require('../parsers/qs');var updateInteraction=require(_0x4ec4('0x1'))['updateInteraction'];var utils=require(_0x4ec4('0x2'));var db=require(_0x4ec4('0x3'))['db'];function skipInteractionsQuery(_0xc539,_0x35a9d6,_0x5d8a5e){var _0x237b90=![];var _0x112ecf=utils[_0x4ec4('0x4')](_0xc539);if(_0x35a9d6['role']===_0x4ec4('0x5')&&!_0x5d8a5e[_0x4ec4('0x6')]&&!_0x5d8a5e[_0x112ecf]){_0x237b90=!![];}return _0x237b90;}function getTagsQuery(){return squel[_0x4ec4('0x7')]()[_0x4ec4('0x8')]('id')[_0x4ec4('0x8')](_0x4ec4('0x9'))[_0x4ec4('0x8')](_0x4ec4('0xa'))[_0x4ec4('0xb')](_0x4ec4('0xc'));}function getUsersQuery(_0x332949,_0x2cb034){var _0x1681ce=utils[_0x4ec4('0xd')](_0x332949);var _0x5c388d=_0x4ec4('0xe')+_0x332949+_0x4ec4('0xf');var _0x29b7ec=squel[_0x4ec4('0x7')]()[_0x4ec4('0x8')](_0x4ec4('0x10'))[_0x4ec4('0x8')](_0x4ec4('0x11'))[_0x4ec4('0x8')](_0x4ec4('0x12')+_0x1681ce)[_0x4ec4('0xb')](_0x5c388d,'ui')[_0x4ec4('0x13')](_0x4ec4('0x14'),'u','u.id\x20=\x20ui.UserId');if(_0x2cb034[_0x4ec4('0x15')]>0x0){_0x29b7ec[_0x4ec4('0x16')](_0x4ec4('0x12')+_0x1681ce+_0x4ec4('0x17'),_[_0x4ec4('0x18')](_0x2cb034,'id'));}return _0x29b7ec;}function getInteractionsQuery(_0x3e0ac9){var _0x53ca16=utils[_0x4ec4('0x19')](_0x3e0ac9);var _0x59c48=utils[_0x4ec4('0x4')](_0x3e0ac9);var _0x4b6a77=utils[_0x4ec4('0xd')](_0x3e0ac9);return squel[_0x4ec4('0x7')]()[_0x4ec4('0xb')](_0x53ca16[_0x4ec4('0x1a')],'i')['left_join'](_0x4ec4('0x1b'),'c',_0x4ec4('0x1c'))[_0x4ec4('0x13')](_0x4ec4('0x14'),'o','o.id\x20=\x20i.UserId')[_0x4ec4('0x13')](_0x53ca16[_0x4ec4('0x1d')],'a',_0x4ec4('0x1e')+_0x59c48)['left_join'](_0x53ca16[_0x4ec4('0x1f')],'me',_0x4ec4('0x20')+_0x4b6a77+'\x20=\x20i.id')['left_join'](_0x53ca16[_0x4ec4('0x21')],'it',_0x4ec4('0x22')+_0x4b6a77+_0x4ec4('0x23'))['left_join'](_0x4ec4('0xc'),'t',_0x4ec4('0x24'));}function getSqlClauses(){var _0x391f86={'body':squel[_0x4ec4('0x25')](),'contact':squel[_0x4ec4('0x25')](),'default':squel['expr'](),'fields':squel[_0x4ec4('0x25')](),'filter':squel[_0x4ec4('0x25')](),'read':squel[_0x4ec4('0x25')](),'tags':{'clause':squel[_0x4ec4('0x25')](),'ids':null},'user':squel[_0x4ec4('0x25')]()};return _0x391f86;}function parseTagParameter(_0x39c39b){var _0x2b3eb4=squel[_0x4ec4('0x25')]();if(_0x39c39b){var _0x2aea94=utils[_0x4ec4('0x26')](_0x39c39b);_0x2aea94[_0x4ec4('0x27')](function(_0x5c3d36){_0x2b3eb4['or'](_0x4ec4('0x28'),'%,'+_0x5c3d36+',%');});}return _0x2b3eb4;}function parseReadParameter(_0x11df43){var _0x151abf='';if(_0x11df43){_0x151abf='unreadMessages\x20{OPERATOR}\x200';if(_0x11df43==='1'){_0x151abf=_0x151abf['replace'](_0x4ec4('0x29'),'=');}else{_0x151abf=_0x151abf[_0x4ec4('0x2a')](_0x4ec4('0x29'),'>');}}return _0x151abf;}function parseSearchFilter(_0x49a499,_0xe35012){var _0x3c942e=squel[_0x4ec4('0x25')]();if(_0xe35012){var _0x4a9108=_0xe35012[_0x4ec4('0x2a')]('\x5c','\x5c\x5c')[_0x4ec4('0x2a')](/'/g,'\x27\x27');if(qs[_0x4ec4('0x2b')](_0x4a9108)){_0x3c942e['or'](_0x4ec4('0x2c'),_0x4a9108+'%');switch(_0x49a499){case _0x4ec4('0x2d'):case _0x4ec4('0x2e'):_0x3c942e['or'](_0x4ec4('0x2f'),_0x4a9108+'%');break;case'fax':_0x3c942e['or']('i.fax\x20LIKE\x20?',_0x4a9108+'%');break;case'openchannel':_0x3c942e['or'](_0x4ec4('0x30'),_0x4a9108+'%');break;case'mail':_0x3c942e['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x4ec4('0x31')](_0x4a9108,!![]))['or'](_0x4ec4('0x32'),qs[_0x4ec4('0x31')](_0x4a9108));break;}}else if(_0x49a499===_0x4ec4('0x33')&&qs[_0x4ec4('0x34')](_0x4a9108)){_0x3c942e['or'](_0x4ec4('0x35'),_0x4a9108+'%');}else{if(_0x49a499===_0x4ec4('0x33')){_0x3c942e['or'](_0x4ec4('0x36'),qs[_0x4ec4('0x31')](_0x4a9108,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x4ec4('0x31')](_0x4a9108));}else if(_0x49a499!=='fax'){_0x3c942e['or'](_0x4ec4('0x37'),qs['getFullTextValue'](_0x4a9108));}_0x3c942e['or'](_0x4ec4('0x38'),qs[_0x4ec4('0x31')](_0x4a9108,!![]),null);}}return _0x3c942e;}function parseAdvancedSearchFilter(_0x3fc8de,_0x2f797f){var _0x3ada5c=getSqlClauses();var _0x2be4bb=as['parseSearch'](_0x3fc8de);var _0x4ca7b3=_0x2be4bb[_0x4ec4('0x39')];for(var _0x1fc53a=0x0;_0x1fc53a<_0x2be4bb['conditions']['length'];_0x1fc53a++){var _0x448789=_0x2be4bb[_0x4ec4('0x3a')][_0x1fc53a];var _0x38c850='i';var _0xef08a=_[_0x4ec4('0x3b')](_0x2f797f,[_0x4ec4('0x9'),_0x448789[_0x4ec4('0x8')]]);if(_0xef08a){var _0xb8ce6b=as[_0x4ec4('0x3c')](_0x38c850,_0xef08a[_0x4ec4('0x3d')],_0x448789);_0x3ada5c[_0x4ec4('0x3e')][_0x4ca7b3](_0xb8ce6b[_0x4ec4('0x3f')],_0xb8ce6b[_0x4ec4('0x40')]['start'],_0xb8ce6b[_0x4ec4('0x40')]['end']);}else{switch(_0x448789['field']){case _0x4ec4('0x41'):var _0x1003f7=parseReadParameter(_0x448789[_0x4ec4('0x40')]);_0x3ada5c[_0x4ec4('0x42')][_0x4ec4('0x43')](_0x1003f7);break;case _0x4ec4('0x44'):if(_0x448789[_0x4ec4('0x45')]===_0x4ec4('0x46')){if(_0x448789['value']['split']('\x20')[_0x4ec4('0x15')]>0x1){_0x3ada5c[_0x4ec4('0x47')][_0x4ca7b3](_0x4ec4('0x38'),qs[_0x4ec4('0x31')](_0x448789[_0x4ec4('0x40')],!![]),null);}else{var _0x4358ab='%'+_0x448789['value']+'%';_0x3ada5c[_0x4ec4('0x47')][_0x4ca7b3](_0x4ec4('0x48'),_0x4358ab,_0x4358ab,_0x4358ab);}}else{_0xef08a=_[_0x4ec4('0x3b')](_0x2f797f,[_0x4ec4('0x9'),_0x4ec4('0x49')]);_0x448789[_0x4ec4('0x8')]=_0x4ec4('0x49');_0xb8ce6b=as['buildExpression'](_0x38c850,_0xef08a['type'],_0x448789);_0x3ada5c[_0x4ec4('0x47')][_0x4ca7b3](_0xb8ce6b[_0x4ec4('0x3f')],_0xb8ce6b['value'][_0x4ec4('0x4a')],_0xb8ce6b['value']['end']);}break;case _0x4ec4('0x4b'):var _0x376525=_0x448789['value']['split'](',')[_0x4ec4('0x18')](function(_0x1e60b1){return Number(_0x1e60b1);});var _0x24301b=parseTagParameter(_0x376525);_0x3ada5c[_0x4ec4('0x4c')][_0x4ec4('0x4d')]['and'](_0x24301b);_0x3ada5c[_0x4ec4('0x4c')][_0x4ec4('0x4e')]=_0x376525;break;case _0x4ec4('0x4f'):if(_0x448789[_0x4ec4('0x45')]==='$substring'){_0x3ada5c[_0x4ec4('0x50')][_0x4ca7b3](_0x4ec4('0x51'),'%'+_0x448789['value']+'%',null);}else{_0xef08a=_[_0x4ec4('0x3b')](_0x2f797f,['name','UserId']);_0x448789[_0x4ec4('0x8')]=_0x4ec4('0x52');_0xb8ce6b=as['buildExpression'](_0x38c850,_0xef08a[_0x4ec4('0x3d')],_0x448789);_0x3ada5c['user'][_0x4ca7b3](_0xb8ce6b['text'],_0xb8ce6b[_0x4ec4('0x40')][_0x4ec4('0x4a')],_0xb8ce6b[_0x4ec4('0x40')][_0x4ec4('0x53')]);}break;case _0x4ec4('0x54'):case _0x4ec4('0x55'):_0xb8ce6b=as[_0x4ec4('0x3c')]('me',null,_0x448789);_0x3ada5c[_0x4ec4('0x54')][_0x4ca7b3](_0xb8ce6b[_0x4ec4('0x3f')],_0xb8ce6b[_0x4ec4('0x40')][_0x4ec4('0x4a')],_0xb8ce6b[_0x4ec4('0x40')]['end']);break;}}}return _0x3ada5c;}function parseModelFields(_0xc1e50a,_0x28cfc5,_0x2ee624){var _0x229a2a=utils[_0x4ec4('0x4')](_0xc1e50a);var _0x30ff67=squel['expr']();var _0xa04fc7=_(_0x28cfc5)[_0x4ec4('0x56')]()[_0x4ec4('0x18')](function(_0x35796f){return _[_0x4ec4('0x57')](_0x2ee624,[_0x4ec4('0x9'),_0x35796f])?_0x35796f:undefined;})[_0x4ec4('0x58')]()['value']();if(_0xa04fc7[_0x4ec4('0x15')]>0x0){_0xa04fc7[_0x4ec4('0x27')](function(_0x3abcb2){if(_0x3abcb2===_0x229a2a){_0x30ff67['and']('i.'+_0x229a2a+_0x4ec4('0x17'),[][_0x4ec4('0x59')](_0x28cfc5[_0x3abcb2]));}else if(_0x3abcb2===_0x4ec4('0x5a')){var _0x4a46f0=JSON[_0x4ec4('0x5b')](_0x28cfc5[_0x3abcb2])[_0x4ec4('0x5c')];var _0x3f198d=JSON[_0x4ec4('0x5b')](_0x28cfc5[_0x3abcb2])[_0x4ec4('0x5d')];_0x30ff67[_0x4ec4('0x43')](_0x4ec4('0x5e'),_0x4a46f0,_0x3f198d);}else{if(_0x28cfc5[_0x3abcb2]===_0x4ec4('0x5f')){_0x30ff67['and']('i.'+_0x3abcb2+'\x20IS\x20NULL');}else{_0x30ff67[_0x4ec4('0x43')]('i.'+_0x3abcb2+_0x4ec4('0x60'),_0x28cfc5[_0x3abcb2]);}}});}return _0x30ff67;}function parseQueryParameters(_0x49f304,_0x51c98b,_0x295e6f){var _0x1e2828=getSqlClauses();return Promise[_0x4ec4('0x61')]()[_0x4ec4('0x62')](function(){return parseModelFields(_0x49f304,_0x51c98b,_0x295e6f);})[_0x4ec4('0x62')](function(_0x33e24f){_0x1e2828[_0x4ec4('0x63')][_0x4ec4('0x43')](_0x33e24f);return parseReadParameter(_0x51c98b[_0x4ec4('0x42')]);})[_0x4ec4('0x62')](function(_0xfee364){_0x1e2828[_0x4ec4('0x42')]['and'](_0xfee364);return parseTagParameter(_0x51c98b['tag']);})[_0x4ec4('0x62')](function(_0x56289f){_0x1e2828[_0x4ec4('0x4c')]['clause'][_0x4ec4('0x43')](_0x56289f);return parseSearchFilter(_0x49f304,_0x51c98b[_0x4ec4('0x64')]);})['then'](function(_0x1ce4c8){_0x1e2828[_0x4ec4('0x64')]=_0x1ce4c8;return _0x1e2828;});}function checkAccountsRestrictions(_0x1ff3e7,_0x2905d7,_0x387469){var _0x4593f9=utils[_0x4ec4('0x4')](_0x1ff3e7);var _0x170372=_0x4ec4('0x65')+_[_0x4ec4('0x66')](_0x1ff3e7)+(_0x1ff3e7===_0x4ec4('0x67')?_0x4ec4('0x68'):'Accounts');var _0x1355d9=squel['expr']();return Promise['resolve']()[_0x4ec4('0x62')](function(){if(_0x387469[_0x4ec4('0x6')]&&_0x2905d7[_0x4ec4('0x69')]==='agent'){return _0x2905d7[_0x170372]({'attributes':['id'],'raw':!![]});}})[_0x4ec4('0x62')](function(_0x3db5c9){if(_0x3db5c9){if(_0x3db5c9[_0x4ec4('0x15')]===0x0){_0x1355d9[_0x4ec4('0x43')]('i.'+_0x4593f9+_0x4ec4('0x6a'));}else{_0x1355d9[_0x4ec4('0x43')]('i.'+_0x4593f9+_0x4ec4('0x17'),_[_0x4ec4('0x18')](_0x3db5c9,'id'));}}else if(!_0x387469[_0x4593f9]){_0x1355d9[_0x4ec4('0x43')]('i.'+_0x4593f9+'\x20IS\x20NOT\x20NULL');}})[_0x4ec4('0x62')](function(){return _0x1355d9;});}function getClosedOrderClause(_0x303713,_0x51d109){var _0x1faa6e='';var _0x212dce=[_0x4ec4('0x6b'),_0x4ec4('0x6c'),_0x4ec4('0x6d')];if(_0x303713===_0x4ec4('0x33')){_0x212dce['unshift'](_0x4ec4('0x6e'));}if(_0x51d109[_0x4ec4('0x6f')]==='0'&&_0x303713==='mail'){_0x1faa6e=_0x4ec4('0x6e');}else{if(_0x51d109[_0x4ec4('0x6f')]==='1'){_0x212dce[_0x4ec4('0x70')]();}_0x1faa6e=_0x4ec4('0x71')+_0x212dce[_0x4ec4('0x72')](',\x20')+')';}return _0x1faa6e;}function getFilteredInteractions(_0x3ff3cf,_0xb088ea,_0x235cd8,_0x30873a){var _0x24cecb=utils[_0x4ec4('0xd')](_0x3ff3cf);var _0x4374c4=_[_0x4ec4('0x66')](_0x3ff3cf)+_0x4ec4('0x73');var _0x4976ee=[];var _0x4408f9=getTagsQuery();var _0x39cc4f={'type':db['Sequelize']['QueryTypes'][_0x4ec4('0x74')],'raw':!![]};var _0x423011=[];var _0x406d2f=[];return db[_0x4ec4('0x75')]['query'](_0x4408f9[_0x4ec4('0x76')](),_0x39cc4f)[_0x4ec4('0x62')](function(_0x3bfce0){_0x4976ee=_[_0x4ec4('0x77')](_0x3bfce0,'id');_0x39cc4f=_[_0x4ec4('0x78')](_0x39cc4f,{'model':db[_0x4374c4],'mapToModel':!![],'nest':!![]});if(_0x235cd8[_0x4ec4('0x63')]){_0x30873a[_0x4ec4('0x79')]['forEach'](function(_0x54a1fb){_0xb088ea[_0x4ec4('0x8')]('i.'+_0x54a1fb);});}else{_0xb088ea[_0x4ec4('0x8')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x4ec4('0x41'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x7a'),_0x4ec4('0x7b'));_0xb088ea['field']('a.mandatoryDisposition','Account.mandatoryDisposition');if(_0x3ff3cf===_0x4ec4('0x33')){_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x7c'),_0x4ec4('0x7d'));_0xb088ea[_0x4ec4('0x8')]('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',_0x4ec4('0x7e'));_0xb088ea['field'](_0x4ec4('0x7f'));_0xb088ea['field'](_0x4ec4('0x80'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x81'));_0xb088ea[_0x4ec4('0x8')]('i.closed');_0xb088ea['field'](_0x4ec4('0x82'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x83'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x84'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x85'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x86'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x6d'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x6c'));_0xb088ea['field'](_0x4ec4('0x6b'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x6e'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x87'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x88'));_0xb088ea[_0x4ec4('0x8')]('i.MailAccountId');_0xb088ea['field'](_0x4ec4('0x89'));}else if(_0x3ff3cf==='openchannel'){_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x8a'),'contactName');}else{_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x8b'),_0x4ec4('0x7e'));}if(_0x3ff3cf!==_0x4ec4('0x33')){_0xb088ea[_0x4ec4('0x8')]('i.*');}_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x8c'),_0x4ec4('0x8d'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x8e'),_0x4ec4('0x8f'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x90'),_0x4ec4('0x91'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x92'),_0x4ec4('0x93'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x94'),'Contact.mobile');_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x95'),'Contact.fax');_0xb088ea[_0x4ec4('0x8')]('o.fullname','Owner.fullname');_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x96'),_0x4ec4('0x97'));_0xb088ea[_0x4ec4('0x8')](_0x4ec4('0x98'),'TagIds');}if(_0x30873a['limit']){_0xb088ea[_0x4ec4('0x99')](_0x30873a[_0x4ec4('0x99')]);}if(_0x30873a[_0x4ec4('0x9a')]){_0xb088ea[_0x4ec4('0x9a')](_0x30873a[_0x4ec4('0x9a')]);}return db[_0x4ec4('0x75')][_0x4ec4('0x9b')](_0xb088ea[_0x4ec4('0x76')](),_0x39cc4f);})[_0x4ec4('0x62')](function(_0x4dddb8){_0x423011=_0x4dddb8;var _0x155e77=getUsersQuery(_0x3ff3cf,_0x423011);return db[_0x4ec4('0x75')]['query'](_0x155e77[_0x4ec4('0x76')](),_0x39cc4f);})[_0x4ec4('0x62')](function(_0x556fde){_0x406d2f=_[_0x4ec4('0x9c')](_0x556fde,_0x24cecb);if(_0x3ff3cf===_0x4ec4('0x33')){return db[_0x4ec4('0x9d')][_0x4ec4('0x9e')]({'attributes':['enableEmailPreview'],'raw':!![]});}})['then'](function(_0x3e0d13){var _0x25459a=_0x3e0d13?_0x3e0d13[_0x4ec4('0x9f')]:undefined;var _0xde2db1=_0x423011[_0x4ec4('0x18')](function(_0x417c22){return updateInteraction(_0x417c22,_0x4976ee,_0x406d2f,_0x25459a);});return Promise[_0x4ec4('0xa0')](_0xde2db1);});}function countFilteredInteractions(_0x9c19b2,_0x3e7049){var _0x752731=_0x9c19b2[_0x4ec4('0xa1')]();_0x752731[_0x4ec4('0x8')](_0x4ec4('0xa2'));_0x752731[_0x4ec4('0x8')](_0x4ec4('0xa3'),'unreadMessages');var _0x23824d=utils[_0x4ec4('0x26')](_0x3e7049);if(!_[_0x4ec4('0xa4')](_0x23824d)){_0x752731['where'](_0x4ec4('0xa5'),_0x23824d);}var _0x7d961d={'type':db[_0x4ec4('0xa6')]['QueryTypes'][_0x4ec4('0x74')],'raw':!![]};return db[_0x4ec4('0x75')][_0x4ec4('0x9b')](_0x752731[_0x4ec4('0x76')](),_0x7d961d);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0xd632=['expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','{OPERATOR}','replace','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','mail','isEmail','c.email\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','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','name','buildExpression','default','text','value','end','read','and','Contact','operator','split','contact','find','ContactId','start','Tag','map','tags','clause','ids','User','$substring','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','type','user','body','plainBody','compact','\x20IN\x20?','concat','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','resolve','then','fields','tag','filter','get','capitalize','chat','Websites','Accounts','role','i.thirdDisposition','i.disposition','i.substatus','closed','CONCAT_WS(\x27\x27,\x20','Interaction','Sequelize','SELECT','sequelize','toString','keyBy','merge','attributes','unreadMessages','a.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','Account.email','contactName','i.id','i.updatedAt','i.closed','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.subject','i.secondDisposition','i.to','i.ContactId','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','Contact.firstName','c.lastName','Contact.lastName','Contact.email','c.phone','Contact.phone','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','TagIds','limit','offset','query','groupBy','Setting','enableEmailPreview','all','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','isEmpty','where','t.id\x20IN\x20?','QueryTypes','exports','lodash','squel','../parsers/advancedSearch','./update-interaction','updateInteraction','./utils','../../mysqldb','agent','search','field','color','from','getInteractionFK','user_has_','_interactions','select','u.id','ui.','left_join','users','u.id\x20=\x20ui.UserId','length','getAccountFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','messages','interactionsTags','it.','\x20=\x20i.id','tools_tags','t.id\x20=\x20it.TagId'];(function(_0xec2324,_0x539fe7){var _0x1ffdc1=function(_0x53096e){while(--_0x53096e){_0xec2324['push'](_0xec2324['shift']());}};_0x1ffdc1(++_0x539fe7);}(_0xd632,0x12c));var _0x2d63=function(_0x46599d,_0x335ded){_0x46599d=_0x46599d-0x0;var _0x2e111a=_0xd632[_0x46599d];return _0x2e111a;};'use strict';var _=require(_0x2d63('0x0'));var squel=require(_0x2d63('0x1'));var as=require(_0x2d63('0x2'));var qs=require('../parsers/qs');var updateInteraction=require(_0x2d63('0x3'))[_0x2d63('0x4')];var utils=require(_0x2d63('0x5'));var db=require(_0x2d63('0x6'))['db'];function skipInteractionsQuery(_0x30f30a,_0x398c3a,_0x32898f){var _0x2bc98a=![];var _0x3244df=utils['getAccountFK'](_0x30f30a);if(_0x398c3a['role']===_0x2d63('0x7')&&!_0x32898f[_0x2d63('0x8')]&&!_0x32898f[_0x3244df]){_0x2bc98a=!![];}return _0x2bc98a;}function getTagsQuery(){return squel['select']()[_0x2d63('0x9')]('id')[_0x2d63('0x9')]('name')['field'](_0x2d63('0xa'))[_0x2d63('0xb')]('tools_tags');}function getUsersQuery(_0x576aa9,_0x1c9edb){var _0x310bdf=utils[_0x2d63('0xc')](_0x576aa9);var _0x3e35dd=_0x2d63('0xd')+_0x576aa9+_0x2d63('0xe');var _0x58e0a9=squel[_0x2d63('0xf')]()[_0x2d63('0x9')](_0x2d63('0x10'))[_0x2d63('0x9')]('u.fullname')[_0x2d63('0x9')](_0x2d63('0x11')+_0x310bdf)[_0x2d63('0xb')](_0x3e35dd,'ui')[_0x2d63('0x12')](_0x2d63('0x13'),'u',_0x2d63('0x14'));if(_0x1c9edb[_0x2d63('0x15')]>0x0){_0x58e0a9['where'](_0x2d63('0x11')+_0x310bdf+'\x20IN\x20?',_['map'](_0x1c9edb,'id'));}return _0x58e0a9;}function getInteractionsQuery(_0x482889){var _0x4c8879=utils['getInteractionsTables'](_0x482889);var _0xc5420a=utils[_0x2d63('0x16')](_0x482889);var _0xe2c758=utils[_0x2d63('0xc')](_0x482889);return squel[_0x2d63('0xf')]()['from'](_0x4c8879[_0x2d63('0x17')],'i')[_0x2d63('0x12')](_0x2d63('0x18'),'c',_0x2d63('0x19'))[_0x2d63('0x12')](_0x2d63('0x13'),'o','o.id\x20=\x20i.UserId')['left_join'](_0x4c8879[_0x2d63('0x1a')],'a',_0x2d63('0x1b')+_0xc5420a)['left_join'](_0x4c8879[_0x2d63('0x1c')],'me','me.'+_0xe2c758+'\x20=\x20i.id')[_0x2d63('0x12')](_0x4c8879[_0x2d63('0x1d')],'it',_0x2d63('0x1e')+_0xe2c758+_0x2d63('0x1f'))['left_join'](_0x2d63('0x20'),'t',_0x2d63('0x21'));}function getSqlClauses(){var _0x128026={'body':squel[_0x2d63('0x22')](),'contact':squel[_0x2d63('0x22')](),'default':squel[_0x2d63('0x22')](),'fields':squel['expr'](),'filter':squel['expr'](),'read':squel[_0x2d63('0x22')](),'tags':{'clause':squel[_0x2d63('0x22')](),'ids':null},'user':squel[_0x2d63('0x22')]()};return _0x128026;}function parseTagParameter(_0x236a3d){var _0x5fba4=squel['expr']();if(_0x236a3d){var _0x48cf5a=utils[_0x2d63('0x23')](_0x236a3d);_0x48cf5a[_0x2d63('0x24')](function(_0x246785){_0x5fba4['or'](_0x2d63('0x25'),'%,'+_0x246785+',%');});}return _0x5fba4;}function parseReadParameter(_0x1511ee){var _0x2928ef='';if(_0x1511ee){_0x2928ef='unreadMessages\x20{OPERATOR}\x200';if(_0x1511ee==='1'){_0x2928ef=_0x2928ef['replace'](_0x2d63('0x26'),'=');}else{_0x2928ef=_0x2928ef[_0x2d63('0x27')](_0x2d63('0x26'),'>');}}return _0x2928ef;}function parseSearchFilter(_0x27ab7c,_0x77b5d1){var _0x515360=squel['expr']();if(_0x77b5d1){var _0x9f4856=_0x77b5d1[_0x2d63('0x27')]('\x5c','\x5c\x5c')[_0x2d63('0x27')](/'/g,'\x27\x27');var _0x34e34e=qs[_0x2d63('0x28')](_0x9f4856);if(qs[_0x2d63('0x29')](_0x9f4856)){_0x515360['or'](_0x2d63('0x2a'),_0x34e34e+'%');if(['sms',_0x2d63('0x2b')][_0x2d63('0x2c')](_0x27ab7c)){_0x515360['or'](_0x2d63('0x2d'),_0x34e34e+'%');}else if(_0x27ab7c===_0x2d63('0x2e')){_0x515360['or'](_0x2d63('0x2f'),_0x34e34e+'%');}else if(_0x27ab7c===_0x2d63('0x30')){_0x515360['or'](_0x2d63('0x31'),_0x34e34e+'%');}}else if(_0x27ab7c===_0x2d63('0x32')&&qs[_0x2d63('0x33')](_0x9f4856)){_0x515360['or'](_0x2d63('0x34'),_0x34e34e+'%');}else{if(_0x27ab7c==='mail'){_0x515360['or'](_0x2d63('0x35'),qs[_0x2d63('0x36')](_0x9f4856,!![]))['or'](_0x2d63('0x37'),qs['getFullTextValue'](_0x9f4856));}else if(_0x27ab7c!==_0x2d63('0x2e')){_0x515360['or'](_0x2d63('0x38'),qs[_0x2d63('0x36')](_0x9f4856));}_0x515360['or'](_0x2d63('0x39'),qs[_0x2d63('0x36')](_0x9f4856,!![]),null);}}return _0x515360;}function parseAdvancedSearchFilter(_0x353c4f,_0x1d09f3){var _0x433e73=getSqlClauses();var _0x4924ec=as['parseSearch'](_0x353c4f);var _0x4832b3=_0x4924ec[_0x2d63('0x3a')];for(var _0x145917=0x0;_0x145917<_0x4924ec[_0x2d63('0x3b')][_0x2d63('0x15')];_0x145917++){var _0x50c6e9=_0x4924ec[_0x2d63('0x3b')][_0x145917];var _0xaea978='i';var _0x4865e3=_['find'](_0x1d09f3,[_0x2d63('0x3c'),_0x50c6e9[_0x2d63('0x9')]]);if(_0x4865e3){var _0x39fade=as[_0x2d63('0x3d')](_0xaea978,_0x4865e3['type'],_0x50c6e9);_0x433e73[_0x2d63('0x3e')][_0x4832b3](_0x39fade[_0x2d63('0x3f')],_0x39fade[_0x2d63('0x40')]['start'],_0x39fade['value'][_0x2d63('0x41')]);}else{switch(_0x50c6e9['field']){case'unreadMessages':var _0x14e1b6=parseReadParameter(_0x50c6e9[_0x2d63('0x40')]);_0x433e73[_0x2d63('0x42')][_0x2d63('0x43')](_0x14e1b6);break;case _0x2d63('0x44'):if(_0x50c6e9[_0x2d63('0x45')]==='$substring'){if(_0x50c6e9[_0x2d63('0x40')][_0x2d63('0x46')]('\x20')[_0x2d63('0x15')]>0x1){_0x433e73[_0x2d63('0x47')][_0x4832b3](_0x2d63('0x39'),qs[_0x2d63('0x36')](_0x50c6e9['value'],!![]),null);}else{var _0x2a42d9='%'+_0x50c6e9[_0x2d63('0x40')]+'%';_0x433e73[_0x2d63('0x47')][_0x4832b3]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x2a42d9,_0x2a42d9,_0x2a42d9);}}else{_0x4865e3=_[_0x2d63('0x48')](_0x1d09f3,['name',_0x2d63('0x49')]);_0x50c6e9[_0x2d63('0x9')]=_0x2d63('0x49');_0x39fade=as[_0x2d63('0x3d')](_0xaea978,_0x4865e3['type'],_0x50c6e9);_0x433e73[_0x2d63('0x47')][_0x4832b3](_0x39fade[_0x2d63('0x3f')],_0x39fade[_0x2d63('0x40')][_0x2d63('0x4a')],_0x39fade['value'][_0x2d63('0x41')]);}break;case _0x2d63('0x4b'):var _0x36f2c3=_0x50c6e9[_0x2d63('0x40')][_0x2d63('0x46')](',')[_0x2d63('0x4c')](function(_0x998ac8){return Number(_0x998ac8);});var _0x2dab72=parseTagParameter(_0x36f2c3);_0x433e73[_0x2d63('0x4d')][_0x2d63('0x4e')][_0x2d63('0x43')](_0x2dab72);_0x433e73[_0x2d63('0x4d')][_0x2d63('0x4f')]=_0x36f2c3;break;case _0x2d63('0x50'):if(_0x50c6e9[_0x2d63('0x45')]===_0x2d63('0x51')){_0x433e73['user'][_0x4832b3](_0x2d63('0x52'),'%'+_0x50c6e9[_0x2d63('0x40')]+'%',null);}else{_0x4865e3=_[_0x2d63('0x48')](_0x1d09f3,[_0x2d63('0x3c'),'UserId']);_0x50c6e9[_0x2d63('0x9')]='UserId';_0x39fade=as[_0x2d63('0x3d')](_0xaea978,_0x4865e3[_0x2d63('0x53')],_0x50c6e9);_0x433e73[_0x2d63('0x54')][_0x4832b3](_0x39fade[_0x2d63('0x3f')],_0x39fade['value'][_0x2d63('0x4a')],_0x39fade[_0x2d63('0x40')]['end']);}break;case _0x2d63('0x55'):case _0x2d63('0x56'):_0x39fade=as[_0x2d63('0x3d')]('me',null,_0x50c6e9);_0x433e73[_0x2d63('0x55')][_0x4832b3](_0x39fade['text'],_0x39fade[_0x2d63('0x40')][_0x2d63('0x4a')],_0x39fade[_0x2d63('0x40')]['end']);break;}}}return _0x433e73;}function parseModelFields(_0x287207,_0x12dead,_0x5227c2){var _0x27b3c1=utils[_0x2d63('0x16')](_0x287207);var _0x5f0775=squel[_0x2d63('0x22')]();var _0x113a46=_(_0x12dead)['keys']()[_0x2d63('0x4c')](function(_0x2f83a0){return _['some'](_0x5227c2,[_0x2d63('0x3c'),_0x2f83a0])?_0x2f83a0:undefined;})[_0x2d63('0x57')]()[_0x2d63('0x40')]();if(_0x113a46[_0x2d63('0x15')]>0x0){_0x113a46[_0x2d63('0x24')](function(_0x5a479d){if(_0x5a479d===_0x27b3c1){_0x5f0775[_0x2d63('0x43')]('i.'+_0x27b3c1+_0x2d63('0x58'),[][_0x2d63('0x59')](_0x12dead[_0x5a479d]));}else if(_0x5a479d==='createdAt'){var _0x28bb8f=JSON[_0x2d63('0x5a')](_0x12dead[_0x5a479d])[_0x2d63('0x5b')];var _0xe94685=JSON['parse'](_0x12dead[_0x5a479d])[_0x2d63('0x5c')];_0x5f0775['and'](_0x2d63('0x5d'),_0x28bb8f,_0xe94685);}else{if(_0x12dead[_0x5a479d]===_0x2d63('0x5e')){_0x5f0775[_0x2d63('0x43')]('i.'+_0x5a479d+_0x2d63('0x5f'));}else{_0x5f0775[_0x2d63('0x43')]('i.'+_0x5a479d+'\x20=\x20?',_0x12dead[_0x5a479d]);}}});}return _0x5f0775;}function parseQueryParameters(_0x197479,_0x367635,_0xc0b8a9){var _0x59369a=getSqlClauses();return Promise[_0x2d63('0x60')]()['then'](function(){return parseModelFields(_0x197479,_0x367635,_0xc0b8a9);})[_0x2d63('0x61')](function(_0x3e6535){_0x59369a[_0x2d63('0x62')][_0x2d63('0x43')](_0x3e6535);return parseReadParameter(_0x367635[_0x2d63('0x42')]);})[_0x2d63('0x61')](function(_0x5dd2f9){_0x59369a[_0x2d63('0x42')]['and'](_0x5dd2f9);return parseTagParameter(_0x367635[_0x2d63('0x63')]);})[_0x2d63('0x61')](function(_0x33b169){_0x59369a['tags'][_0x2d63('0x4e')][_0x2d63('0x43')](_0x33b169);return parseSearchFilter(_0x197479,_0x367635[_0x2d63('0x64')]);})['then'](function(_0x14d2bb){_0x59369a[_0x2d63('0x64')]=_0x14d2bb;return _0x59369a;});}function checkAccountsRestrictions(_0x26244e,_0xdf9ccc,_0x2476c8){var _0x1a43a0=utils[_0x2d63('0x16')](_0x26244e);var _0x457b8f=_0x2d63('0x65')+_[_0x2d63('0x66')](_0x26244e)+(_0x26244e===_0x2d63('0x67')?_0x2d63('0x68'):_0x2d63('0x69'));var _0x1b30b9=squel[_0x2d63('0x22')]();return Promise[_0x2d63('0x60')]()['then'](function(){if(_0x2476c8[_0x2d63('0x8')]&&_0xdf9ccc[_0x2d63('0x6a')]===_0x2d63('0x7')){return _0xdf9ccc[_0x457b8f]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x2f4ea3){if(_0x2f4ea3){if(_0x2f4ea3[_0x2d63('0x15')]===0x0){_0x1b30b9['and']('i.'+_0x1a43a0+_0x2d63('0x5f'));}else{_0x1b30b9['and']('i.'+_0x1a43a0+_0x2d63('0x58'),_['map'](_0x2f4ea3,'id'));}}else if(!_0x2476c8[_0x1a43a0]){_0x1b30b9['and']('i.'+_0x1a43a0+'\x20IS\x20NOT\x20NULL');}})[_0x2d63('0x61')](function(){return _0x1b30b9;});}function getClosedOrderClause(_0x36eb0b,_0x4b3a3c){var _0x23d2c9='';var _0x43af6a=[_0x2d63('0x6b'),'i.secondDisposition',_0x2d63('0x6c')];if(_0x36eb0b==='mail'){_0x43af6a['unshift'](_0x2d63('0x6d'));}if(_0x4b3a3c[_0x2d63('0x6e')]==='0'&&_0x36eb0b===_0x2d63('0x32')){_0x23d2c9=_0x2d63('0x6d');}else{if(_0x4b3a3c[_0x2d63('0x6e')]==='1'){_0x43af6a['shift']();}_0x23d2c9=_0x2d63('0x6f')+_0x43af6a['join'](',\x20')+')';}return _0x23d2c9;}function getFilteredInteractions(_0x11ef77,_0x109f0e,_0x58443a,_0xe48b55){var _0x1f3fc3=utils['getInteractionFK'](_0x11ef77);var _0x1d2850=_['capitalize'](_0x11ef77)+_0x2d63('0x70');var _0x1c4efd=[];var _0x3d0b6c=getTagsQuery();var _0x5a8f4a={'type':db[_0x2d63('0x71')]['QueryTypes'][_0x2d63('0x72')],'raw':!![]};var _0xc33370=[];var _0x438c66=[];return db[_0x2d63('0x73')]['query'](_0x3d0b6c[_0x2d63('0x74')](),_0x5a8f4a)[_0x2d63('0x61')](function(_0x5810d4){_0x1c4efd=_[_0x2d63('0x75')](_0x5810d4,'id');_0x5a8f4a=_[_0x2d63('0x76')](_0x5a8f4a,{'model':db[_0x1d2850],'mapToModel':!![],'nest':!![]});if(_0x58443a['fields']){_0xe48b55[_0x2d63('0x77')]['forEach'](function(_0x1e3888){_0x109f0e['field']('i.'+_0x1e3888);});}else{_0x109f0e['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x2d63('0x78'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x79'),'Account.key');_0x109f0e[_0x2d63('0x9')](_0x2d63('0x7a'),_0x2d63('0x7b'));if(_0x11ef77===_0x2d63('0x32')){_0x109f0e[_0x2d63('0x9')](_0x2d63('0x7c'),_0x2d63('0x7d'));_0x109f0e[_0x2d63('0x9')]('CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END',_0x2d63('0x7e'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x7f'));_0x109f0e[_0x2d63('0x9')]('i.createdAt');_0x109f0e['field'](_0x2d63('0x80'));_0x109f0e['field'](_0x2d63('0x81'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x82'));_0x109f0e[_0x2d63('0x9')]('i.attach');_0x109f0e['field'](_0x2d63('0x83'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x84'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x85'));_0x109f0e['field'](_0x2d63('0x6c'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x86'));_0x109f0e[_0x2d63('0x9')]('i.thirdDisposition');_0x109f0e[_0x2d63('0x9')](_0x2d63('0x6d'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x87'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x88'));_0x109f0e['field']('i.MailAccountId');_0x109f0e[_0x2d63('0x9')]('i.UserId');}else if(_0x11ef77===_0x2d63('0x30')){_0x109f0e[_0x2d63('0x9')](_0x2d63('0x89'),_0x2d63('0x7e'));}else{_0x109f0e['field']('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',_0x2d63('0x7e'));}if(_0x11ef77!==_0x2d63('0x32')){_0x109f0e[_0x2d63('0x9')](_0x2d63('0x8a'));}_0x109f0e[_0x2d63('0x9')](_0x2d63('0x8b'),_0x2d63('0x8c'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x8d'),_0x2d63('0x8e'));_0x109f0e['field']('c.email',_0x2d63('0x8f'));_0x109f0e['field'](_0x2d63('0x90'),_0x2d63('0x91'));_0x109f0e['field']('c.mobile',_0x2d63('0x92'));_0x109f0e['field'](_0x2d63('0x93'),_0x2d63('0x94'));_0x109f0e[_0x2d63('0x9')](_0x2d63('0x95'),'Owner.fullname');_0x109f0e[_0x2d63('0x9')](_0x2d63('0x96'),_0x2d63('0x97'));_0x109f0e[_0x2d63('0x9')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x2d63('0x98'));}if(_0xe48b55[_0x2d63('0x99')]){_0x109f0e[_0x2d63('0x99')](_0xe48b55['limit']);}if(_0xe48b55[_0x2d63('0x9a')]){_0x109f0e['offset'](_0xe48b55['offset']);}return db['sequelize']['query'](_0x109f0e[_0x2d63('0x74')](),_0x5a8f4a);})[_0x2d63('0x61')](function(_0x754305){_0xc33370=_0x754305;var _0x3e26a0=getUsersQuery(_0x11ef77,_0xc33370);return db[_0x2d63('0x73')][_0x2d63('0x9b')](_0x3e26a0[_0x2d63('0x74')](),_0x5a8f4a);})['then'](function(_0x5ab693){_0x438c66=_[_0x2d63('0x9c')](_0x5ab693,_0x1f3fc3);if(_0x11ef77==='mail'){return db[_0x2d63('0x9d')]['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x2d63('0x61')](function(_0x380d16){var _0x25f15b=_0x380d16?_0x380d16[_0x2d63('0x9e')]:undefined;var _0x1cf204=_0xc33370[_0x2d63('0x4c')](function(_0x22cc61){return updateInteraction(_0x22cc61,_0x1c4efd,_0x438c66,_0x25f15b);});return Promise[_0x2d63('0x9f')](_0x1cf204);});}function countFilteredInteractions(_0x12852e,_0x55fbe4){var _0x2717c6=_0x12852e['clone']();_0x2717c6[_0x2d63('0x9')](_0x2d63('0xa0'));_0x2717c6[_0x2d63('0x9')](_0x2d63('0xa1'),_0x2d63('0x78'));var _0x521ba5=utils[_0x2d63('0x23')](_0x55fbe4);if(!_[_0x2d63('0xa2')](_0x521ba5)){_0x2717c6[_0x2d63('0xa3')](_0x2d63('0xa4'),_0x521ba5);}var _0x59bcce={'type':db[_0x2d63('0x71')][_0x2d63('0xa5')][_0x2d63('0x72')],'raw':!![]};return db[_0x2d63('0x73')][_0x2d63('0x9b')](_0x2717c6[_0x2d63('0x74')](),_0x59bcce);}module[_0x2d63('0xa6')]={'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