18 var _0xc0ee=['tools_tags','getInteractionFK','user_has_','_interactions','u.id','left_join','users','u.id\x20=\x20ui.UserId','where','ui.','map','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','sms','whatsapp','includes','fax','i.fax\x20LIKE\x20?','openchannel','c.email\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','sqlOperator','conditions','length','find','name','buildExpression','type','default','text','value','end','read','Contact','operator','$substring','split','contact','ContactId','start','Tag','tags','clause','and','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','body','some','compact','createdAt','$gte','parse','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','capitalize','chat','Websites','Accounts','\x20IN\x20?','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','keyBy','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','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','contactName','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','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','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','o.fullname','Owner.fullname','Owner.internal','TagIds','limit','offset','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','squel','../parsers/advancedSearch','getAccountFK','role','agent','search','select','field','color','from'];(function(_0x5584aa,_0x3d40f7){var _0xf2ca7f=function(_0x1d1c26){while(--_0x1d1c26){_0x5584aa['push'](_0x5584aa['shift']());}};_0xf2ca7f(++_0x3d40f7);}(_0xc0ee,0x1df));var _0xec0e=function(_0x4099ee,_0x38495a){_0x4099ee=_0x4099ee-0x0;var _0x1b7bfc=_0xc0ee[_0x4099ee];return _0x1b7bfc;};'use strict';var _=require('lodash');var squel=require(_0xec0e('0x0'));var as=require(_0xec0e('0x1'));var qs=require('../parsers/qs');var updateInteraction=require('./update-interaction')['updateInteraction'];var utils=require('./utils');var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x5ee1ad,_0x3c51b7,_0x5a6781){var _0x578a3e=![];var _0x4fdedc=utils[_0xec0e('0x2')](_0x5ee1ad);if(_0x3c51b7[_0xec0e('0x3')]===_0xec0e('0x4')&&!_0x5a6781[_0xec0e('0x5')]&&!_0x5a6781[_0x4fdedc]){_0x578a3e=!![];}return _0x578a3e;}function getTagsQuery(){return squel[_0xec0e('0x6')]()['field']('id')[_0xec0e('0x7')]('name')[_0xec0e('0x7')](_0xec0e('0x8'))[_0xec0e('0x9')](_0xec0e('0xa'));}function getUsersQuery(_0x4762b7,_0x5f19b7){var _0x21c64b=utils[_0xec0e('0xb')](_0x4762b7);var _0x394cea=_0xec0e('0xc')+_0x4762b7+_0xec0e('0xd');var _0x13b08d=squel[_0xec0e('0x6')]()[_0xec0e('0x7')](_0xec0e('0xe'))[_0xec0e('0x7')]('u.fullname')[_0xec0e('0x7')]('ui.'+_0x21c64b)[_0xec0e('0x9')](_0x394cea,'ui')[_0xec0e('0xf')](_0xec0e('0x10'),'u',_0xec0e('0x11'));if(_0x5f19b7['length']>0x0){_0x13b08d[_0xec0e('0x12')](_0xec0e('0x13')+_0x21c64b+'\x20IN\x20?',_[_0xec0e('0x14')](_0x5f19b7,'id'));}return _0x13b08d;}function getInteractionsQuery(_0x475b7f){var _0x58391b=utils[_0xec0e('0x15')](_0x475b7f);var _0x4a6485=utils[_0xec0e('0x2')](_0x475b7f);var _0x1727e9=utils['getInteractionFK'](_0x475b7f);return squel[_0xec0e('0x6')]()['from'](_0x58391b[_0xec0e('0x16')],'i')['left_join'](_0xec0e('0x17'),'c',_0xec0e('0x18'))[_0xec0e('0xf')]('users','o',_0xec0e('0x19'))[_0xec0e('0xf')](_0x58391b[_0xec0e('0x1a')],'a',_0xec0e('0x1b')+_0x4a6485)[_0xec0e('0xf')](_0x58391b[_0xec0e('0x1c')],'me',_0xec0e('0x1d')+_0x1727e9+_0xec0e('0x1e'))[_0xec0e('0xf')](_0x58391b[_0xec0e('0x1f')],'it',_0xec0e('0x20')+_0x1727e9+'\x20=\x20i.id')['left_join'](_0xec0e('0xa'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0xd452de={'body':squel[_0xec0e('0x21')](),'contact':squel[_0xec0e('0x21')](),'default':squel[_0xec0e('0x21')](),'fields':squel['expr'](),'filter':squel['expr'](),'read':squel[_0xec0e('0x21')](),'tags':{'clause':squel[_0xec0e('0x21')](),'ids':null},'user':squel[_0xec0e('0x21')]()};return _0xd452de;}function parseTagParameter(_0xd8c3e9){var _0x2c3dd4=squel[_0xec0e('0x21')]();if(_0xd8c3e9){var _0x55c108=utils[_0xec0e('0x22')](_0xd8c3e9);_0x55c108[_0xec0e('0x23')](function(_0x430266){_0x2c3dd4['or'](_0xec0e('0x24'),'%,'+_0x430266+',%');});}return _0x2c3dd4;}function parseReadParameter(_0x2989b0){var _0x3fc422='';if(_0x2989b0){_0x3fc422=_0xec0e('0x25');if(_0x2989b0==='1'){_0x3fc422=_0x3fc422[_0xec0e('0x26')](_0xec0e('0x27'),'=');}else{_0x3fc422=_0x3fc422[_0xec0e('0x26')](_0xec0e('0x27'),'>');}}return _0x3fc422;}function parseSearchFilter(_0x15ec6d,_0x48c122){var _0x293fc3=squel[_0xec0e('0x21')]();if(_0x48c122){var _0x3f580a=_0x48c122[_0xec0e('0x26')]('\x5c','\x5c\x5c')[_0xec0e('0x26')](/'/g,'\x27\x27');if(qs[_0xec0e('0x28')](_0x3f580a)){_0x293fc3['or']('i.id\x20LIKE\x20?',_0x3f580a+'%');if([_0xec0e('0x29'),_0xec0e('0x2a')][_0xec0e('0x2b')](_0x15ec6d)){_0x293fc3['or']('i.phone\x20LIKE\x20?',_0x3f580a+'%');}else if(_0x15ec6d===_0xec0e('0x2c')){_0x293fc3['or'](_0xec0e('0x2d'),_0x3f580a+'%');}else if(_0x15ec6d===_0xec0e('0x2e')){_0x293fc3['or']('i.from\x20LIKE\x20?',_0x3f580a+'%');}}else if(_0x15ec6d==='mail'&&qs['isEmail'](_0x3f580a)){_0x293fc3['or'](_0xec0e('0x2f'),_0x3f580a+'%');}else{if(_0x15ec6d===_0xec0e('0x30')){_0x293fc3['or'](_0xec0e('0x31'),qs['getFullTextValue'](_0x3f580a,!![]))['or'](_0xec0e('0x32'),qs[_0xec0e('0x33')](_0x3f580a));}else if(_0x15ec6d!=='fax'){_0x293fc3['or'](_0xec0e('0x34'),qs['getFullTextValue'](_0x3f580a));}_0x293fc3['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xec0e('0x33')](_0x3f580a,!![]),null);}}return _0x293fc3;}function parseAdvancedSearchFilter(_0x528a0d,_0x8682b4){var _0x1ac302=getSqlClauses();var _0x54dadc=as['parseSearch'](_0x528a0d);var _0x51e6d1=_0x54dadc[_0xec0e('0x35')];for(var _0x597f1=0x0;_0x597f1<_0x54dadc[_0xec0e('0x36')][_0xec0e('0x37')];_0x597f1++){var _0x5066a0=_0x54dadc[_0xec0e('0x36')][_0x597f1];var _0x5cd071='i';var _0x250795=_[_0xec0e('0x38')](_0x8682b4,[_0xec0e('0x39'),_0x5066a0[_0xec0e('0x7')]]);if(_0x250795){var _0x48711e=as[_0xec0e('0x3a')](_0x5cd071,_0x250795[_0xec0e('0x3b')],_0x5066a0);_0x1ac302[_0xec0e('0x3c')][_0x51e6d1](_0x48711e[_0xec0e('0x3d')],_0x48711e[_0xec0e('0x3e')]['start'],_0x48711e[_0xec0e('0x3e')][_0xec0e('0x3f')]);}else{switch(_0x5066a0[_0xec0e('0x7')]){case'unreadMessages':var _0x4d9f4e=parseReadParameter(_0x5066a0[_0xec0e('0x3e')]);_0x1ac302[_0xec0e('0x40')]['and'](_0x4d9f4e);break;case _0xec0e('0x41'):if(_0x5066a0[_0xec0e('0x42')]===_0xec0e('0x43')){if(_0x5066a0[_0xec0e('0x3e')][_0xec0e('0x44')]('\x20')[_0xec0e('0x37')]>0x1){_0x1ac302[_0xec0e('0x45')][_0x51e6d1]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x5066a0[_0xec0e('0x3e')],!![]),null);}else{var _0x2e89dd='%'+_0x5066a0[_0xec0e('0x3e')]+'%';_0x1ac302[_0xec0e('0x45')][_0x51e6d1]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x2e89dd,_0x2e89dd,_0x2e89dd);}}else{_0x250795=_[_0xec0e('0x38')](_0x8682b4,[_0xec0e('0x39'),_0xec0e('0x46')]);_0x5066a0[_0xec0e('0x7')]=_0xec0e('0x46');_0x48711e=as[_0xec0e('0x3a')](_0x5cd071,_0x250795[_0xec0e('0x3b')],_0x5066a0);_0x1ac302[_0xec0e('0x45')][_0x51e6d1](_0x48711e[_0xec0e('0x3d')],_0x48711e[_0xec0e('0x3e')][_0xec0e('0x47')],_0x48711e[_0xec0e('0x3e')]['end']);}break;case _0xec0e('0x48'):var _0x344022=_0x5066a0[_0xec0e('0x3e')][_0xec0e('0x44')](',')[_0xec0e('0x14')](function(_0x1b04ad){return Number(_0x1b04ad);});var _0x575c00=parseTagParameter(_0x344022);_0x1ac302[_0xec0e('0x49')][_0xec0e('0x4a')][_0xec0e('0x4b')](_0x575c00);_0x1ac302[_0xec0e('0x49')][_0xec0e('0x4c')]=_0x344022;break;case _0xec0e('0x4d'):if(_0x5066a0['operator']===_0xec0e('0x43')){_0x1ac302[_0xec0e('0x4e')][_0x51e6d1](_0xec0e('0x4f'),'%'+_0x5066a0[_0xec0e('0x3e')]+'%',null);}else{_0x250795=_[_0xec0e('0x38')](_0x8682b4,[_0xec0e('0x39'),_0xec0e('0x50')]);_0x5066a0[_0xec0e('0x7')]=_0xec0e('0x50');_0x48711e=as['buildExpression'](_0x5cd071,_0x250795[_0xec0e('0x3b')],_0x5066a0);_0x1ac302[_0xec0e('0x4e')][_0x51e6d1](_0x48711e[_0xec0e('0x3d')],_0x48711e[_0xec0e('0x3e')]['start'],_0x48711e[_0xec0e('0x3e')][_0xec0e('0x3f')]);}break;case _0xec0e('0x51'):case'plainBody':_0x48711e=as['buildExpression']('me',null,_0x5066a0);_0x1ac302['body'][_0x51e6d1](_0x48711e[_0xec0e('0x3d')],_0x48711e[_0xec0e('0x3e')]['start'],_0x48711e['value'][_0xec0e('0x3f')]);break;}}}return _0x1ac302;}function parseModelFields(_0x120ab2,_0x2ee210,_0x50dd3d){var _0x189c29=utils[_0xec0e('0x2')](_0x120ab2);var _0x591325=squel['expr']();var _0x4cbae2=_(_0x2ee210)['keys']()[_0xec0e('0x14')](function(_0x3012eb){return _[_0xec0e('0x52')](_0x50dd3d,[_0xec0e('0x39'),_0x3012eb])?_0x3012eb:undefined;})[_0xec0e('0x53')]()['value']();if(_0x4cbae2[_0xec0e('0x37')]>0x0){_0x4cbae2[_0xec0e('0x23')](function(_0x51fe33){if(_0x51fe33===_0x189c29){_0x591325['and']('i.'+_0x189c29+'\x20IN\x20?',[]['concat'](_0x2ee210[_0x51fe33]));}else if(_0x51fe33===_0xec0e('0x54')){var _0x588ac7=JSON['parse'](_0x2ee210[_0x51fe33])[_0xec0e('0x55')];var _0x5b0a63=JSON[_0xec0e('0x56')](_0x2ee210[_0x51fe33])['$lte'];_0x591325[_0xec0e('0x4b')](_0xec0e('0x57'),_0x588ac7,_0x5b0a63);}else{if(_0x2ee210[_0x51fe33]==='null'){_0x591325[_0xec0e('0x4b')]('i.'+_0x51fe33+_0xec0e('0x58'));}else{_0x591325['and']('i.'+_0x51fe33+_0xec0e('0x59'),_0x2ee210[_0x51fe33]);}}});}return _0x591325;}function parseQueryParameters(_0x3dcf60,_0x4015a9,_0x25f2d7){var _0x539dcc=getSqlClauses();return Promise[_0xec0e('0x5a')]()['then'](function(){return parseModelFields(_0x3dcf60,_0x4015a9,_0x25f2d7);})[_0xec0e('0x5b')](function(_0x687361){_0x539dcc[_0xec0e('0x5c')][_0xec0e('0x4b')](_0x687361);return parseReadParameter(_0x4015a9['read']);})['then'](function(_0x2123a7){_0x539dcc[_0xec0e('0x40')]['and'](_0x2123a7);return parseTagParameter(_0x4015a9[_0xec0e('0x5d')]);})['then'](function(_0xd8747a){_0x539dcc[_0xec0e('0x49')][_0xec0e('0x4a')]['and'](_0xd8747a);return parseSearchFilter(_0x3dcf60,_0x4015a9['filter']);})[_0xec0e('0x5b')](function(_0x29936a){_0x539dcc['filter']=_0x29936a;return _0x539dcc;});}function checkAccountsRestrictions(_0x186ca3,_0x38ab49,_0x2c2a2c){var _0x24f359=utils[_0xec0e('0x2')](_0x186ca3);var _0x3f0bcd='get'+_[_0xec0e('0x5e')](_0x186ca3)+(_0x186ca3===_0xec0e('0x5f')?_0xec0e('0x60'):_0xec0e('0x61'));var _0x249c92=squel[_0xec0e('0x21')]();return Promise[_0xec0e('0x5a')]()[_0xec0e('0x5b')](function(){if(_0x2c2a2c['search']&&_0x38ab49['role']===_0xec0e('0x4')){return _0x38ab49[_0x3f0bcd]({'attributes':['id'],'raw':!![]});}})[_0xec0e('0x5b')](function(_0x429dc8){if(_0x429dc8){if(_0x429dc8[_0xec0e('0x37')]===0x0){_0x249c92[_0xec0e('0x4b')]('i.'+_0x24f359+_0xec0e('0x58'));}else{_0x249c92[_0xec0e('0x4b')]('i.'+_0x24f359+_0xec0e('0x62'),_[_0xec0e('0x14')](_0x429dc8,'id'));}}else if(!_0x2c2a2c[_0x24f359]){_0x249c92['and']('i.'+_0x24f359+_0xec0e('0x63'));}})['then'](function(){return _0x249c92;});}function getClosedOrderClause(_0x15e8d1,_0x2e1eb4){var _0x50d2e7='';var _0x5ad904=[_0xec0e('0x64'),_0xec0e('0x65'),_0xec0e('0x66')];if(_0x15e8d1==='mail'){_0x5ad904[_0xec0e('0x67')](_0xec0e('0x68'));}if(_0x2e1eb4[_0xec0e('0x69')]==='0'&&_0x15e8d1===_0xec0e('0x30')){_0x50d2e7=_0xec0e('0x68');}else{if(_0x2e1eb4[_0xec0e('0x69')]==='1'){_0x5ad904[_0xec0e('0x6a')]();}_0x50d2e7=_0xec0e('0x6b')+_0x5ad904[_0xec0e('0x6c')](',\x20')+')';}return _0x50d2e7;}function getFilteredInteractions(_0x2d3758,_0x1d702c,_0xa894ec,_0x2bded7){var _0xa14ea8=utils['getInteractionFK'](_0x2d3758);var _0x23c2e5=_[_0xec0e('0x5e')](_0x2d3758)+_0xec0e('0x6d');var _0x2b3311=[];var _0x3bb495=getTagsQuery();var _0x141428={'type':db[_0xec0e('0x6e')][_0xec0e('0x6f')][_0xec0e('0x70')],'raw':!![]};var _0x261be1=[];var _0x3bf7c7=[];return db[_0xec0e('0x71')][_0xec0e('0x72')](_0x3bb495[_0xec0e('0x73')](),_0x141428)[_0xec0e('0x5b')](function(_0xb1b449){_0x2b3311=_[_0xec0e('0x74')](_0xb1b449,'id');_0x141428=_['merge'](_0x141428,{'model':db[_0x23c2e5],'mapToModel':!![],'nest':!![]});if(_0xa894ec['fields']){_0x2bded7['attributes'][_0xec0e('0x23')](function(_0x38dff7){_0x1d702c['field']('i.'+_0x38dff7);});}else{_0x1d702c[_0xec0e('0x7')](_0xec0e('0x75'),_0xec0e('0x76'));_0x1d702c['field']('a.key',_0xec0e('0x77'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x78'),_0xec0e('0x79'));if(_0x2d3758===_0xec0e('0x30')){_0x1d702c[_0xec0e('0x7')](_0xec0e('0x7a'),_0xec0e('0x7b'));_0x1d702c['field'](_0xec0e('0x7c'),_0xec0e('0x7d'));_0x1d702c[_0xec0e('0x7')]('i.id');_0x1d702c[_0xec0e('0x7')]('i.createdAt');_0x1d702c[_0xec0e('0x7')](_0xec0e('0x7e'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x7f'));_0x1d702c['field'](_0xec0e('0x80'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x81'));_0x1d702c['field'](_0xec0e('0x82'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x83'));_0x1d702c['field'](_0xec0e('0x84'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x66'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x65'));_0x1d702c[_0xec0e('0x7')]('i.thirdDisposition');_0x1d702c[_0xec0e('0x7')](_0xec0e('0x68'));_0x1d702c['field'](_0xec0e('0x85'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x86'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x87'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x88'));}else if(_0x2d3758==='openchannel'){_0x1d702c[_0xec0e('0x7')](_0xec0e('0x89'),_0xec0e('0x7d'));}else{_0x1d702c[_0xec0e('0x7')]('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');}if(_0x2d3758!==_0xec0e('0x30')){_0x1d702c[_0xec0e('0x7')](_0xec0e('0x8a'));}_0x1d702c['field'](_0xec0e('0x8b'),'Contact.firstName');_0x1d702c[_0xec0e('0x7')]('c.lastName',_0xec0e('0x8c'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x8d'),_0xec0e('0x8e'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x8f'),_0xec0e('0x90'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x91'),_0xec0e('0x92'));_0x1d702c[_0xec0e('0x7')](_0xec0e('0x93'),'Contact.fax');_0x1d702c[_0xec0e('0x7')](_0xec0e('0x94'),_0xec0e('0x95'));_0x1d702c['field']('o.internal',_0xec0e('0x96'));_0x1d702c['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0xec0e('0x97'));}if(_0x2bded7['limit']){_0x1d702c['limit'](_0x2bded7[_0xec0e('0x98')]);}if(_0x2bded7[_0xec0e('0x99')]){_0x1d702c[_0xec0e('0x99')](_0x2bded7[_0xec0e('0x99')]);}return db[_0xec0e('0x71')][_0xec0e('0x72')](_0x1d702c[_0xec0e('0x73')](),_0x141428);})[_0xec0e('0x5b')](function(_0x339205){_0x261be1=_0x339205;var _0x5dbfdb=getUsersQuery(_0x2d3758,_0x261be1);return db['sequelize'][_0xec0e('0x72')](_0x5dbfdb[_0xec0e('0x73')](),_0x141428);})[_0xec0e('0x5b')](function(_0x1d358c){_0x3bf7c7=_['groupBy'](_0x1d358c,_0xa14ea8);if(_0x2d3758==='mail'){return db[_0xec0e('0x9a')][_0xec0e('0x9b')]({'attributes':[_0xec0e('0x9c')],'raw':!![]});}})[_0xec0e('0x5b')](function(_0x1e90bf){var _0x144747=_0x1e90bf?_0x1e90bf[_0xec0e('0x9c')]:undefined;var _0x25f20=_0x261be1[_0xec0e('0x14')](function(_0x2eb61a){return updateInteraction(_0x2eb61a,_0x2b3311,_0x3bf7c7,_0x144747);});return Promise[_0xec0e('0x9d')](_0x25f20);});}function countFilteredInteractions(_0x2a54a4,_0xf66b30){var _0x31b2e7=_0x2a54a4[_0xec0e('0x9e')]();_0x31b2e7['field'](_0xec0e('0x9f'));_0x31b2e7['field'](_0xec0e('0x75'),_0xec0e('0x76'));var _0x609082=utils[_0xec0e('0x22')](_0xf66b30);if(!_[_0xec0e('0xa0')](_0x609082)){_0x31b2e7[_0xec0e('0x12')](_0xec0e('0xa1'),_0x609082);}var _0x268152={'type':db[_0xec0e('0x6e')][_0xec0e('0x6f')][_0xec0e('0x70')],'raw':!![]};return db[_0xec0e('0x71')]['query'](_0x31b2e7[_0xec0e('0x73')](),_0x268152);}module[_0xec0e('0xa2')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
git://repos.xcallymotion.com / motion2.git / blob