18 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};
git://repos.xcallymotion.com / motion2.git / blob