18 var _0x6ff6=['and','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','start','Tag','clause','tags','ids','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','find','text','body','keys','compact','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','then','fields','filter','get','capitalize','resolve','search','role','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','Interaction','Sequelize','query','keyBy','attributes','Account.key','a.mandatoryDisposition','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','i.id','i.createdAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.to','i.MailAccountId','i.UserId','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.*','c.firstName','Contact.firstName','Contact.lastName','Contact.email','Contact.phone','c.mobile','Contact.mobile','Contact.fax','Owner.fullname','o.internal','limit','offset','sequelize','toString','groupBy','Setting','findOne','all','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','isEmpty','t.id\x20IN\x20?','QueryTypes','SELECT','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','./utils','../../mysqldb','agent','field','name','color','from','tools_tags','getInteractionFK','user_has_','select','u.id','u.fullname','ui.','users','length','where','\x20IN\x20?','map','getInteractionsTables','getAccountFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','left_join','accounts','a.id\x20=\x20i.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','fax','openchannel','i.from\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.email\x20LIKE\x20?','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','buildExpression','type','default','value','end','unreadMessages','read'];(function(_0x2dae70,_0x321f24){var _0x3fe495=function(_0x456642){while(--_0x456642){_0x2dae70['push'](_0x2dae70['shift']());}};_0x3fe495(++_0x321f24);}(_0x6ff6,0xfa));var _0x66ff=function(_0x3e048d,_0x460b70){_0x3e048d=_0x3e048d-0x0;var _0x175f31=_0x6ff6[_0x3e048d];return _0x175f31;};'use strict';var _=require(_0x66ff('0x0'));var squel=require(_0x66ff('0x1'));var as=require(_0x66ff('0x2'));var qs=require(_0x66ff('0x3'));var updateInteraction=require(_0x66ff('0x4'))['updateInteraction'];var utils=require(_0x66ff('0x5'));var db=require(_0x66ff('0x6'))['db'];function skipInteractionsQuery(_0x373d32,_0x403fb0,_0x3c0fd6){var _0x3da9eb=![];var _0x4ecde7=utils['getAccountFK'](_0x373d32);if(_0x403fb0['role']===_0x66ff('0x7')&&!_0x3c0fd6['search']&&!_0x3c0fd6[_0x4ecde7]){_0x3da9eb=!![];}return _0x3da9eb;}function getTagsQuery(){return squel['select']()[_0x66ff('0x8')]('id')[_0x66ff('0x8')](_0x66ff('0x9'))[_0x66ff('0x8')](_0x66ff('0xa'))[_0x66ff('0xb')](_0x66ff('0xc'));}function getUsersQuery(_0x37b61e,_0x14bc41){var _0x1e1ded=utils[_0x66ff('0xd')](_0x37b61e);var _0x3c42b1=_0x66ff('0xe')+_0x37b61e+'_interactions';var _0x58eea9=squel[_0x66ff('0xf')]()[_0x66ff('0x8')](_0x66ff('0x10'))['field'](_0x66ff('0x11'))[_0x66ff('0x8')](_0x66ff('0x12')+_0x1e1ded)[_0x66ff('0xb')](_0x3c42b1,'ui')['left_join'](_0x66ff('0x13'),'u','u.id\x20=\x20ui.UserId');if(_0x14bc41[_0x66ff('0x14')]>0x0){_0x58eea9[_0x66ff('0x15')]('ui.'+_0x1e1ded+_0x66ff('0x16'),_[_0x66ff('0x17')](_0x14bc41,'id'));}return _0x58eea9;}function getInteractionsQuery(_0x1cca1c){var _0x22349e=utils[_0x66ff('0x18')](_0x1cca1c);var _0x29dffa=utils[_0x66ff('0x19')](_0x1cca1c);var _0x13a147=utils['getInteractionFK'](_0x1cca1c);return squel[_0x66ff('0xf')]()[_0x66ff('0xb')](_0x22349e[_0x66ff('0x1a')],'i')['left_join'](_0x66ff('0x1b'),'c',_0x66ff('0x1c'))[_0x66ff('0x1d')]('users','o','o.id\x20=\x20i.UserId')[_0x66ff('0x1d')](_0x22349e[_0x66ff('0x1e')],'a',_0x66ff('0x1f')+_0x29dffa)['left_join'](_0x22349e['messages'],'me','me.'+_0x13a147+_0x66ff('0x20'))['left_join'](_0x22349e[_0x66ff('0x21')],'it',_0x66ff('0x22')+_0x13a147+'\x20=\x20i.id')[_0x66ff('0x1d')](_0x66ff('0xc'),'t',_0x66ff('0x23'));}function getSqlClauses(){var _0x167fd5={'body':squel[_0x66ff('0x24')](),'contact':squel[_0x66ff('0x24')](),'default':squel[_0x66ff('0x24')](),'fields':squel[_0x66ff('0x24')](),'filter':squel[_0x66ff('0x24')](),'read':squel['expr'](),'tags':{'clause':squel[_0x66ff('0x24')](),'ids':null},'user':squel[_0x66ff('0x24')]()};return _0x167fd5;}function parseTagParameter(_0xedcdd7){var _0x4d0ed9=squel[_0x66ff('0x24')]();if(_0xedcdd7){var _0x171de1=utils[_0x66ff('0x25')](_0xedcdd7);_0x171de1[_0x66ff('0x26')](function(_0x16e4f4){_0x4d0ed9['or'](_0x66ff('0x27'),'%,'+_0x16e4f4+',%');});}return _0x4d0ed9;}function parseReadParameter(_0x37e748){var _0x73964b='';if(_0x37e748){_0x73964b=_0x66ff('0x28');if(_0x37e748==='1'){_0x73964b=_0x73964b[_0x66ff('0x29')](_0x66ff('0x2a'),'=');}else{_0x73964b=_0x73964b[_0x66ff('0x29')](_0x66ff('0x2a'),'>');}}return _0x73964b;}function parseSearchFilter(_0x222977,_0x52b545){var _0x3315a6=squel[_0x66ff('0x24')]();if(_0x52b545){var _0x347853=_0x52b545[_0x66ff('0x29')]('\x5c','\x5c\x5c')[_0x66ff('0x29')](/'/g,'\x27\x27');if(qs[_0x66ff('0x2b')](_0x347853)){_0x3315a6['or'](_0x66ff('0x2c'),_0x347853+'%');switch(_0x222977){case _0x66ff('0x2d'):case _0x66ff('0x2e'):_0x3315a6['or']('i.phone\x20LIKE\x20?',_0x347853+'%');break;case _0x66ff('0x2f'):_0x3315a6['or']('i.fax\x20LIKE\x20?',_0x347853+'%');break;case _0x66ff('0x30'):_0x3315a6['or'](_0x66ff('0x31'),_0x347853+'%');break;case _0x66ff('0x32'):_0x3315a6['or'](_0x66ff('0x33'),qs[_0x66ff('0x34')](_0x347853,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x66ff('0x34')](_0x347853));break;}}else if(_0x222977==='mail'&&qs['isEmail'](_0x347853)){_0x3315a6['or'](_0x66ff('0x35'),_0x347853+'%');}else{if(_0x222977===_0x66ff('0x32')){_0x3315a6['or'](_0x66ff('0x33'),qs[_0x66ff('0x34')](_0x347853,!![]))['or'](_0x66ff('0x36'),qs[_0x66ff('0x34')](_0x347853));}else if(_0x222977!==_0x66ff('0x2f')){_0x3315a6['or'](_0x66ff('0x37'),qs['getFullTextValue'](_0x347853));}_0x3315a6['or'](_0x66ff('0x38'),qs[_0x66ff('0x34')](_0x347853,!![]),null);}}return _0x3315a6;}function parseAdvancedSearchFilter(_0x4d3444,_0x40fa48){var _0x31bffe=getSqlClauses();var _0x148877=as['parseSearch'](_0x4d3444);var _0x73eea8=_0x148877[_0x66ff('0x39')];for(var _0x554c87=0x0;_0x554c87<_0x148877[_0x66ff('0x3a')][_0x66ff('0x14')];_0x554c87++){var _0xcee94f=_0x148877[_0x66ff('0x3a')][_0x554c87];var _0x3d059e='i';var _0x5efa40=_['find'](_0x40fa48,[_0x66ff('0x9'),_0xcee94f[_0x66ff('0x8')]]);if(_0x5efa40){var _0x3a73f9=as[_0x66ff('0x3b')](_0x3d059e,_0x5efa40[_0x66ff('0x3c')],_0xcee94f);_0x31bffe[_0x66ff('0x3d')][_0x73eea8](_0x3a73f9['text'],_0x3a73f9[_0x66ff('0x3e')]['start'],_0x3a73f9['value'][_0x66ff('0x3f')]);}else{switch(_0xcee94f['field']){case _0x66ff('0x40'):var _0x1c8577=parseReadParameter(_0xcee94f['value']);_0x31bffe[_0x66ff('0x41')][_0x66ff('0x42')](_0x1c8577);break;case'Contact':if(_0xcee94f['operator']===_0x66ff('0x43')){if(_0xcee94f[_0x66ff('0x3e')][_0x66ff('0x44')]('\x20')[_0x66ff('0x14')]>0x1){_0x31bffe[_0x66ff('0x45')][_0x73eea8]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0xcee94f[_0x66ff('0x3e')],!![]),null);}else{var _0x47e9ad='%'+_0xcee94f[_0x66ff('0x3e')]+'%';_0x31bffe[_0x66ff('0x45')][_0x73eea8](_0x66ff('0x46'),_0x47e9ad,_0x47e9ad,_0x47e9ad);}}else{_0x5efa40=_['find'](_0x40fa48,[_0x66ff('0x9'),_0x66ff('0x47')]);_0xcee94f['field']=_0x66ff('0x47');_0x3a73f9=as[_0x66ff('0x3b')](_0x3d059e,_0x5efa40[_0x66ff('0x3c')],_0xcee94f);_0x31bffe['contact'][_0x73eea8](_0x3a73f9['text'],_0x3a73f9[_0x66ff('0x3e')][_0x66ff('0x48')],_0x3a73f9[_0x66ff('0x3e')][_0x66ff('0x3f')]);}break;case _0x66ff('0x49'):var _0x50d4c6=_0xcee94f['value'][_0x66ff('0x44')](',')[_0x66ff('0x17')](function(_0x2a12ab){return Number(_0x2a12ab);});var _0x1992cb=parseTagParameter(_0x50d4c6);_0x31bffe['tags'][_0x66ff('0x4a')][_0x66ff('0x42')](_0x1992cb);_0x31bffe[_0x66ff('0x4b')][_0x66ff('0x4c')]=_0x50d4c6;break;case'User':if(_0xcee94f['operator']==='$substring'){_0x31bffe[_0x66ff('0x4d')][_0x73eea8](_0x66ff('0x4e'),'%'+_0xcee94f[_0x66ff('0x3e')]+'%',null);}else{_0x5efa40=_[_0x66ff('0x4f')](_0x40fa48,[_0x66ff('0x9'),'UserId']);_0xcee94f[_0x66ff('0x8')]='UserId';_0x3a73f9=as[_0x66ff('0x3b')](_0x3d059e,_0x5efa40[_0x66ff('0x3c')],_0xcee94f);_0x31bffe['user'][_0x73eea8](_0x3a73f9[_0x66ff('0x50')],_0x3a73f9[_0x66ff('0x3e')][_0x66ff('0x48')],_0x3a73f9['value'][_0x66ff('0x3f')]);}break;case _0x66ff('0x51'):case'plainBody':_0x3a73f9=as[_0x66ff('0x3b')]('me',null,_0xcee94f);_0x31bffe[_0x66ff('0x51')][_0x73eea8](_0x3a73f9['text'],_0x3a73f9['value'][_0x66ff('0x48')],_0x3a73f9['value'][_0x66ff('0x3f')]);break;}}}return _0x31bffe;}function parseModelFields(_0x417b80,_0x2470d4,_0x26ec3c){var _0x134e5d=utils[_0x66ff('0x19')](_0x417b80);var _0x953db0=squel[_0x66ff('0x24')]();var _0x1b45b7=_(_0x2470d4)[_0x66ff('0x52')]()['map'](function(_0x4a8f74){return _['some'](_0x26ec3c,[_0x66ff('0x9'),_0x4a8f74])?_0x4a8f74:undefined;})[_0x66ff('0x53')]()[_0x66ff('0x3e')]();if(_0x1b45b7[_0x66ff('0x14')]>0x0){_0x1b45b7['forEach'](function(_0x8a4ce){if(_0x8a4ce===_0x134e5d){_0x953db0['and']('i.'+_0x134e5d+'\x20IN\x20?',[][_0x66ff('0x54')](_0x2470d4[_0x8a4ce]));}else if(_0x8a4ce===_0x66ff('0x55')){var _0x49a5b8=JSON[_0x66ff('0x56')](_0x2470d4[_0x8a4ce])[_0x66ff('0x57')];var _0x336889=JSON[_0x66ff('0x56')](_0x2470d4[_0x8a4ce])[_0x66ff('0x58')];_0x953db0[_0x66ff('0x42')](_0x66ff('0x59'),_0x49a5b8,_0x336889);}else{if(_0x2470d4[_0x8a4ce]===_0x66ff('0x5a')){_0x953db0[_0x66ff('0x42')]('i.'+_0x8a4ce+_0x66ff('0x5b'));}else{_0x953db0[_0x66ff('0x42')]('i.'+_0x8a4ce+_0x66ff('0x5c'),_0x2470d4[_0x8a4ce]);}}});}return _0x953db0;}function parseQueryParameters(_0x48eef7,_0xdb8277,_0x116b8b){var _0xa57d86=getSqlClauses();return Promise['resolve']()[_0x66ff('0x5d')](function(){return parseModelFields(_0x48eef7,_0xdb8277,_0x116b8b);})[_0x66ff('0x5d')](function(_0x1d8eb1){_0xa57d86[_0x66ff('0x5e')][_0x66ff('0x42')](_0x1d8eb1);return parseReadParameter(_0xdb8277[_0x66ff('0x41')]);})[_0x66ff('0x5d')](function(_0x241973){_0xa57d86[_0x66ff('0x41')]['and'](_0x241973);return parseTagParameter(_0xdb8277['tag']);})['then'](function(_0x2aac18){_0xa57d86[_0x66ff('0x4b')][_0x66ff('0x4a')][_0x66ff('0x42')](_0x2aac18);return parseSearchFilter(_0x48eef7,_0xdb8277[_0x66ff('0x5f')]);})[_0x66ff('0x5d')](function(_0x3e2f47){_0xa57d86[_0x66ff('0x5f')]=_0x3e2f47;return _0xa57d86;});}function checkAccountsRestrictions(_0x13d974,_0x365b39,_0x3ab234){var _0x497810=utils[_0x66ff('0x19')](_0x13d974);var _0x3ee748=_0x66ff('0x60')+_[_0x66ff('0x61')](_0x13d974)+(_0x13d974==='chat'?'Websites':'Accounts');var _0x25c6a3=squel[_0x66ff('0x24')]();return Promise[_0x66ff('0x62')]()[_0x66ff('0x5d')](function(){if(_0x3ab234[_0x66ff('0x63')]&&_0x365b39[_0x66ff('0x64')]===_0x66ff('0x7')){return _0x365b39[_0x3ee748]({'attributes':['id'],'raw':!![]});}})[_0x66ff('0x5d')](function(_0x1b8e42){if(_0x1b8e42){if(_0x1b8e42['length']===0x0){_0x25c6a3[_0x66ff('0x42')]('i.'+_0x497810+'\x20IS\x20NULL');}else{_0x25c6a3[_0x66ff('0x42')]('i.'+_0x497810+_0x66ff('0x16'),_[_0x66ff('0x17')](_0x1b8e42,'id'));}}else if(!_0x3ab234[_0x497810]){_0x25c6a3[_0x66ff('0x42')]('i.'+_0x497810+_0x66ff('0x65'));}})[_0x66ff('0x5d')](function(){return _0x25c6a3;});}function getClosedOrderClause(_0x29d6d5,_0x5670f9){var _0x592f24='';var _0x3988dd=[_0x66ff('0x66'),_0x66ff('0x67'),_0x66ff('0x68')];if(_0x29d6d5===_0x66ff('0x32')){_0x3988dd['unshift'](_0x66ff('0x69'));}if(_0x5670f9[_0x66ff('0x6a')]==='0'&&_0x29d6d5===_0x66ff('0x32')){_0x592f24=_0x66ff('0x69');}else{if(_0x5670f9['closed']==='1'){_0x3988dd[_0x66ff('0x6b')]();}_0x592f24=_0x66ff('0x6c')+_0x3988dd['join'](',\x20')+')';}return _0x592f24;}function getFilteredInteractions(_0x4007f4,_0x5b3882,_0x293d46,_0xaa77a4){var _0x5d2ed=utils[_0x66ff('0xd')](_0x4007f4);var _0x765518=_[_0x66ff('0x61')](_0x4007f4)+_0x66ff('0x6d');var _0x34351b=[];var _0x4950b5=getTagsQuery();var _0x3f9fb9={'type':db[_0x66ff('0x6e')]['QueryTypes']['SELECT'],'raw':!![]};var _0x5ca51b=[];var _0x19e20c=[];return db['sequelize'][_0x66ff('0x6f')](_0x4950b5['toString'](),_0x3f9fb9)[_0x66ff('0x5d')](function(_0x2e031c){_0x34351b=_[_0x66ff('0x70')](_0x2e031c,'id');_0x3f9fb9=_['merge'](_0x3f9fb9,{'model':db[_0x765518],'mapToModel':!![],'nest':!![]});if(_0x293d46[_0x66ff('0x5e')]){_0xaa77a4[_0x66ff('0x71')][_0x66ff('0x26')](function(_0x3f8547){_0x5b3882[_0x66ff('0x8')]('i.'+_0x3f8547);});}else{_0x5b3882[_0x66ff('0x8')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x66ff('0x40'));_0x5b3882[_0x66ff('0x8')]('a.key',_0x66ff('0x72'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x73'),_0x66ff('0x74'));if(_0x4007f4==='mail'){_0x5b3882[_0x66ff('0x8')](_0x66ff('0x75'),_0x66ff('0x76'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x77'),'contactName');_0x5b3882[_0x66ff('0x8')](_0x66ff('0x78'));_0x5b3882['field'](_0x66ff('0x79'));_0x5b3882[_0x66ff('0x8')]('i.updatedAt');_0x5b3882[_0x66ff('0x8')](_0x66ff('0x7a'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x7b'));_0x5b3882['field'](_0x66ff('0x7c'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x7d'));_0x5b3882['field'](_0x66ff('0x7e'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x7f'));_0x5b3882[_0x66ff('0x8')]('i.disposition');_0x5b3882[_0x66ff('0x8')](_0x66ff('0x67'));_0x5b3882[_0x66ff('0x8')]('i.thirdDisposition');_0x5b3882['field']('i.substatus');_0x5b3882[_0x66ff('0x8')](_0x66ff('0x80'));_0x5b3882[_0x66ff('0x8')]('i.ContactId');_0x5b3882[_0x66ff('0x8')](_0x66ff('0x81'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x82'));}else if(_0x4007f4===_0x66ff('0x30')){_0x5b3882[_0x66ff('0x8')](_0x66ff('0x83'),'contactName');}else{_0x5b3882[_0x66ff('0x8')](_0x66ff('0x84'),_0x66ff('0x85'));}if(_0x4007f4!=='mail'){_0x5b3882[_0x66ff('0x8')](_0x66ff('0x86'));}_0x5b3882[_0x66ff('0x8')](_0x66ff('0x87'),_0x66ff('0x88'));_0x5b3882[_0x66ff('0x8')]('c.lastName',_0x66ff('0x89'));_0x5b3882['field']('c.email',_0x66ff('0x8a'));_0x5b3882[_0x66ff('0x8')]('c.phone',_0x66ff('0x8b'));_0x5b3882[_0x66ff('0x8')](_0x66ff('0x8c'),_0x66ff('0x8d'));_0x5b3882[_0x66ff('0x8')]('c.fax',_0x66ff('0x8e'));_0x5b3882['field']('o.fullname',_0x66ff('0x8f'));_0x5b3882['field'](_0x66ff('0x90'),'Owner.internal');_0x5b3882[_0x66ff('0x8')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0xaa77a4['limit']){_0x5b3882[_0x66ff('0x91')](_0xaa77a4[_0x66ff('0x91')]);}if(_0xaa77a4[_0x66ff('0x92')]){_0x5b3882['offset'](_0xaa77a4['offset']);}return db[_0x66ff('0x93')]['query'](_0x5b3882[_0x66ff('0x94')](),_0x3f9fb9);})['then'](function(_0x3cc226){_0x5ca51b=_0x3cc226;var _0xee6d8a=getUsersQuery(_0x4007f4,_0x5ca51b);return db['sequelize'][_0x66ff('0x6f')](_0xee6d8a['toString'](),_0x3f9fb9);})['then'](function(_0x17562b){_0x19e20c=_[_0x66ff('0x95')](_0x17562b,_0x5d2ed);if(_0x4007f4==='mail'){return db[_0x66ff('0x96')][_0x66ff('0x97')]({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x66ff('0x5d')](function(_0x5df2b2){var _0x1e426e=_0x5df2b2?_0x5df2b2['enableEmailPreview']:undefined;var _0x368515=_0x5ca51b[_0x66ff('0x17')](function(_0x32908a){return updateInteraction(_0x32908a,_0x34351b,_0x19e20c,_0x1e426e);});return Promise[_0x66ff('0x98')](_0x368515);});}function countFilteredInteractions(_0xae10d7,_0x167927){var _0x3cdb53=_0xae10d7['clone']();_0x3cdb53[_0x66ff('0x8')]('COUNT(*)');_0x3cdb53[_0x66ff('0x8')](_0x66ff('0x99'),_0x66ff('0x40'));var _0x411e82=utils[_0x66ff('0x25')](_0x167927);if(!_[_0x66ff('0x9a')](_0x411e82)){_0x3cdb53[_0x66ff('0x15')](_0x66ff('0x9b'),_0x411e82);}var _0x140f66={'type':db[_0x66ff('0x6e')][_0x66ff('0x9c')][_0x66ff('0x9d')],'raw':!![]};return db[_0x66ff('0x93')][_0x66ff('0x6f')](_0x3cdb53[_0x66ff('0x94')](),_0x140f66);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
git://repos.xcallymotion.com / motion2.git / blob