// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xfea3=['enableEmailPreview','all','COUNT(*)','t.id\x20IN\x20?','exports','lodash','squel','updateInteraction','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','name','color','from','tools_tags','user_has_','_interactions','u.id','ui.','left_join','users','u.id\x20=\x20ui.UserId','where','\x20IN\x20?','map','getInteractionFK','interactions','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','interactionsTags','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','sms','whatsapp','includes','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)','fax','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','parseSearch','sqlOperator','conditions','length','find','type','default','text','start','value','end','and','Contact','$substring','contact','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','Tag','tags','clause','operator','UserId','user','body','plainBody','keys','some','compact','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','resolve','then','fields','read','tag','filter','get','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','toString','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.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.lastMsgAt','i.lastMsgDirection','i.disposition','i.secondDisposition','i.thirdDisposition','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','contactName','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','query','groupBy'];(function(_0x5de58a,_0x23d58e){var _0x589a6d=function(_0x4069ec){while(--_0x4069ec){_0x5de58a['push'](_0x5de58a['shift']());}};_0x589a6d(++_0x23d58e);}(_0xfea3,0xaa));var _0x3fea=function(_0x57e774,_0x59b603){_0x57e774=_0x57e774-0x0;var _0x400c9f=_0xfea3[_0x57e774];return _0x400c9f;};'use strict';var _=require(_0x3fea('0x0'));var squel=require(_0x3fea('0x1'));var as=require('../parsers/advancedSearch');var qs=require('../parsers/qs');var updateInteraction=require('./update-interaction')[_0x3fea('0x2')];var utils=require(_0x3fea('0x3'));var db=require(_0x3fea('0x4'))['db'];function skipInteractionsQuery(_0x67a3aa,_0x26b851,_0x3ba0c2){var _0x223e0f=![];var _0x3d8ffb=utils[_0x3fea('0x5')](_0x67a3aa);if(_0x26b851[_0x3fea('0x6')]===_0x3fea('0x7')&&!_0x3ba0c2[_0x3fea('0x8')]&&!_0x3ba0c2[_0x3d8ffb]){_0x223e0f=!![];}return _0x223e0f;}function getTagsQuery(){return squel[_0x3fea('0x9')]()['field']('id')[_0x3fea('0xa')](_0x3fea('0xb'))[_0x3fea('0xa')](_0x3fea('0xc'))[_0x3fea('0xd')](_0x3fea('0xe'));}function getUsersQuery(_0x165a31,_0x36c688){var _0x455ee7=utils['getInteractionFK'](_0x165a31);var _0x1fe186=_0x3fea('0xf')+_0x165a31+_0x3fea('0x10');var _0x37b8dd=squel[_0x3fea('0x9')]()[_0x3fea('0xa')](_0x3fea('0x11'))['field']('u.fullname')[_0x3fea('0xa')](_0x3fea('0x12')+_0x455ee7)[_0x3fea('0xd')](_0x1fe186,'ui')[_0x3fea('0x13')](_0x3fea('0x14'),'u',_0x3fea('0x15'));if(_0x36c688['length']>0x0){_0x37b8dd[_0x3fea('0x16')](_0x3fea('0x12')+_0x455ee7+_0x3fea('0x17'),_[_0x3fea('0x18')](_0x36c688,'id'));}return _0x37b8dd;}function getInteractionsQuery(_0x263e15){var _0x235128=utils['getInteractionsTables'](_0x263e15);var _0x421692=utils[_0x3fea('0x5')](_0x263e15);var _0x100722=utils[_0x3fea('0x19')](_0x263e15);return squel[_0x3fea('0x9')]()[_0x3fea('0xd')](_0x235128[_0x3fea('0x1a')],'i')[_0x3fea('0x13')]('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')['left_join'](_0x3fea('0x14'),'o',_0x3fea('0x1b'))[_0x3fea('0x13')](_0x235128[_0x3fea('0x1c')],'a',_0x3fea('0x1d')+_0x421692)['left_join'](_0x235128['messages'],'me',_0x3fea('0x1e')+_0x100722+_0x3fea('0x1f'))[_0x3fea('0x13')](_0x235128[_0x3fea('0x20')],'it','it.'+_0x100722+_0x3fea('0x1f'))[_0x3fea('0x13')](_0x3fea('0xe'),'t',_0x3fea('0x21'));}function getSqlClauses(){var _0x2c92fb={'body':squel[_0x3fea('0x22')](),'contact':squel[_0x3fea('0x22')](),'default':squel['expr'](),'fields':squel[_0x3fea('0x22')](),'filter':squel[_0x3fea('0x22')](),'read':squel[_0x3fea('0x22')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x3fea('0x22')]()};return _0x2c92fb;}function parseTagParameter(_0x3a1814){var _0x3d397e=squel['expr']();if(_0x3a1814){var _0x5989c0=utils[_0x3fea('0x23')](_0x3a1814);_0x5989c0[_0x3fea('0x24')](function(_0x13330d){_0x3d397e['or'](_0x3fea('0x25'),'%,'+_0x13330d+',%');});}return _0x3d397e;}function parseReadParameter(_0x24e7c3){var _0x5c7afb='';if(_0x24e7c3){_0x5c7afb=_0x3fea('0x26');if(_0x24e7c3==='1'){_0x5c7afb=_0x5c7afb[_0x3fea('0x27')](_0x3fea('0x28'),'=');}else{_0x5c7afb=_0x5c7afb[_0x3fea('0x27')](_0x3fea('0x28'),'>');}}return _0x5c7afb;}function parseSearchFilter(_0xa2065c,_0x2f48e7){var _0x314f8d=squel[_0x3fea('0x22')]();if(_0x2f48e7){var _0x3c3ade=_0x2f48e7[_0x3fea('0x27')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x3fea('0x29')](_0x3c3ade)){_0x314f8d['or']('i.id\x20LIKE\x20?',_0x3c3ade+'%');if([_0x3fea('0x2a'),_0x3fea('0x2b')][_0x3fea('0x2c')](_0xa2065c)){_0x314f8d['or']('i.phone\x20LIKE\x20?',_0x3c3ade+'%');}else if(_0xa2065c==='fax'){_0x314f8d['or']('i.fax\x20LIKE\x20?',_0x3c3ade+'%');}}else if(_0xa2065c===_0x3fea('0x2d')&&qs[_0x3fea('0x2e')](_0x3c3ade)){_0x314f8d['or'](_0x3fea('0x2f'),_0x3c3ade+'%');}else{if(_0xa2065c===_0x3fea('0x2d')){_0x314f8d['or'](_0x3fea('0x30'),qs[_0x3fea('0x31')](_0x3c3ade))['or'](_0x3fea('0x32'),qs[_0x3fea('0x31')](_0x3c3ade));}else{if(_0xa2065c!==_0x3fea('0x33')){_0x314f8d['or'](_0x3fea('0x34'),qs[_0x3fea('0x31')](_0x3c3ade));}_0x314f8d['or'](_0x3fea('0x35'),_0x3c3ade+'%');if(_0xa2065c===_0x3fea('0x36')){_0x314f8d['or'](_0x3fea('0x37'),_0x3c3ade+'%');}}}}return _0x314f8d;}function parseAdvancedSearchFilter(_0x29bc09,_0x45168a){var _0x5cf272=getSqlClauses();var _0x5501fa=as[_0x3fea('0x38')](_0x29bc09);var _0x274867=_0x5501fa[_0x3fea('0x39')];for(var _0x20ae5d=0x0;_0x20ae5d<_0x5501fa[_0x3fea('0x3a')][_0x3fea('0x3b')];_0x20ae5d++){var _0x1b8207=_0x5501fa[_0x3fea('0x3a')][_0x20ae5d];var _0x36c0c5='i';var _0x58d531=_[_0x3fea('0x3c')](_0x45168a,['name',_0x1b8207[_0x3fea('0xa')]]);if(_0x58d531){var _0x294bae=as['buildExpression'](_0x36c0c5,_0x58d531[_0x3fea('0x3d')],_0x1b8207);_0x5cf272[_0x3fea('0x3e')][_0x274867](_0x294bae[_0x3fea('0x3f')],_0x294bae['value'][_0x3fea('0x40')],_0x294bae[_0x3fea('0x41')][_0x3fea('0x42')]);}else{switch(_0x1b8207[_0x3fea('0xa')]){case'unreadMessages':var _0x711c92=parseReadParameter(_0x1b8207['value']);_0x5cf272['read'][_0x3fea('0x43')](_0x711c92);break;case _0x3fea('0x44'):if(_0x1b8207['operator']===_0x3fea('0x45')){if(_0x1b8207['value']['split']('\x20')['length']>0x1){_0x5cf272[_0x3fea('0x46')][_0x274867](_0x3fea('0x47'),qs['getFullTextValue'](_0x1b8207[_0x3fea('0x41')]),null);}else{var _0x28ddea='%'+_0x1b8207[_0x3fea('0x41')]+'%';_0x5cf272[_0x3fea('0x46')][_0x274867](_0x3fea('0x48'),_0x28ddea,_0x28ddea,_0x28ddea);}}else{_0x58d531=_[_0x3fea('0x3c')](_0x45168a,['name','ContactId']);_0x1b8207['field']=_0x3fea('0x49');_0x294bae=as[_0x3fea('0x4a')](_0x36c0c5,_0x58d531[_0x3fea('0x3d')],_0x1b8207);_0x5cf272[_0x3fea('0x46')][_0x274867](_0x294bae['text'],_0x294bae[_0x3fea('0x41')]['start'],_0x294bae[_0x3fea('0x41')]['end']);}break;case _0x3fea('0x4b'):var _0x184854=_0x1b8207[_0x3fea('0x41')]['split'](',')[_0x3fea('0x18')](function(_0x341b40){return Number(_0x341b40);});var _0x32d634=parseTagParameter(_0x184854);_0x5cf272[_0x3fea('0x4c')][_0x3fea('0x4d')][_0x3fea('0x43')](_0x32d634);_0x5cf272[_0x3fea('0x4c')]['ids']=_0x184854;break;case'User':if(_0x1b8207[_0x3fea('0x4e')]===_0x3fea('0x45')){_0x5cf272['user'][_0x274867]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x1b8207[_0x3fea('0x41')]+'%',null);}else{_0x58d531=_[_0x3fea('0x3c')](_0x45168a,['name',_0x3fea('0x4f')]);_0x1b8207['field']=_0x3fea('0x4f');_0x294bae=as[_0x3fea('0x4a')](_0x36c0c5,_0x58d531[_0x3fea('0x3d')],_0x1b8207);_0x5cf272[_0x3fea('0x50')][_0x274867](_0x294bae['text'],_0x294bae['value'][_0x3fea('0x40')],_0x294bae[_0x3fea('0x41')][_0x3fea('0x42')]);}break;case _0x3fea('0x51'):case _0x3fea('0x52'):_0x294bae=as[_0x3fea('0x4a')]('me',null,_0x1b8207);_0x5cf272[_0x3fea('0x51')][_0x274867](_0x294bae[_0x3fea('0x3f')],_0x294bae[_0x3fea('0x41')][_0x3fea('0x40')],_0x294bae[_0x3fea('0x41')][_0x3fea('0x42')]);break;}}}return _0x5cf272;}function parseModelFields(_0x3eb5fc,_0x3fb937,_0x59d43f){var _0x23804e=utils[_0x3fea('0x5')](_0x3eb5fc);var _0x1f0f8f=squel['expr']();var _0x49f623=_(_0x3fb937)[_0x3fea('0x53')]()['map'](function(_0xea4cca){return _[_0x3fea('0x54')](_0x59d43f,['name',_0xea4cca])?_0xea4cca:undefined;})[_0x3fea('0x55')]()[_0x3fea('0x41')]();if(_0x49f623[_0x3fea('0x3b')]>0x0){_0x49f623[_0x3fea('0x24')](function(_0x24b350){if(_0x24b350===_0x23804e){_0x1f0f8f[_0x3fea('0x43')]('i.'+_0x23804e+_0x3fea('0x17'),[][_0x3fea('0x56')](_0x3fb937[_0x24b350]));}else if(_0x24b350===_0x3fea('0x57')){var _0x272aef=JSON[_0x3fea('0x58')](_0x3fb937[_0x24b350])[_0x3fea('0x59')];var _0x37e519=JSON[_0x3fea('0x58')](_0x3fb937[_0x24b350])[_0x3fea('0x5a')];_0x1f0f8f[_0x3fea('0x43')](_0x3fea('0x5b'),_0x272aef,_0x37e519);}else{if(_0x3fb937[_0x24b350]===_0x3fea('0x5c')){_0x1f0f8f[_0x3fea('0x43')]('i.'+_0x24b350+_0x3fea('0x5d'));}else{_0x1f0f8f['and']('i.'+_0x24b350+'\x20=\x20?',_0x3fb937[_0x24b350]);}}});}return _0x1f0f8f;}function parseQueryParameters(_0x218e9d,_0xb8bcfb,_0x5003bc){var _0x3d2aad=getSqlClauses();return Promise[_0x3fea('0x5e')]()[_0x3fea('0x5f')](function(){return parseModelFields(_0x218e9d,_0xb8bcfb,_0x5003bc);})[_0x3fea('0x5f')](function(_0x38032e){_0x3d2aad[_0x3fea('0x60')][_0x3fea('0x43')](_0x38032e);return parseReadParameter(_0xb8bcfb[_0x3fea('0x61')]);})[_0x3fea('0x5f')](function(_0x4976e2){_0x3d2aad['read'][_0x3fea('0x43')](_0x4976e2);return parseTagParameter(_0xb8bcfb[_0x3fea('0x62')]);})[_0x3fea('0x5f')](function(_0x24ee26){_0x3d2aad[_0x3fea('0x4c')][_0x3fea('0x4d')][_0x3fea('0x43')](_0x24ee26);return parseSearchFilter(_0x218e9d,_0xb8bcfb[_0x3fea('0x63')]);})[_0x3fea('0x5f')](function(_0x5d8cbb){_0x3d2aad['filter']=_0x5d8cbb;return _0x3d2aad;});}function checkAccountsRestrictions(_0x206fb7,_0x345e00,_0x4814cd){var _0x4a4a50=utils[_0x3fea('0x5')](_0x206fb7);var _0x5e42d7=_0x3fea('0x64')+_[_0x3fea('0x65')](_0x206fb7)+(_0x206fb7===_0x3fea('0x66')?_0x3fea('0x67'):_0x3fea('0x68'));var _0x177ae0=squel[_0x3fea('0x22')]();return Promise[_0x3fea('0x5e')]()[_0x3fea('0x5f')](function(){if(_0x4814cd[_0x3fea('0x8')]&&_0x345e00[_0x3fea('0x6')]==='agent'){return _0x345e00[_0x5e42d7]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x489bd9){if(_0x489bd9){if(_0x489bd9[_0x3fea('0x3b')]===0x0){_0x177ae0[_0x3fea('0x43')]('i.'+_0x4a4a50+_0x3fea('0x5d'));}else{_0x177ae0[_0x3fea('0x43')]('i.'+_0x4a4a50+_0x3fea('0x17'),_['map'](_0x489bd9,'id'));}}else if(!_0x4814cd[_0x4a4a50]){_0x177ae0[_0x3fea('0x43')]('i.'+_0x4a4a50+_0x3fea('0x69'));}})[_0x3fea('0x5f')](function(){return _0x177ae0;});}function getClosedOrderClause(_0x29dfe3,_0xe6c065){var _0x2f91fc='';var _0x5ebae0=['i.thirdDisposition','i.secondDisposition','i.disposition'];if(_0x29dfe3===_0x3fea('0x2d')){_0x5ebae0['unshift'](_0x3fea('0x6a'));}if(_0xe6c065[_0x3fea('0x6b')]==='0'&&_0x29dfe3==='mail'){_0x2f91fc='i.substatus';}else{if(_0xe6c065[_0x3fea('0x6b')]==='1'){_0x5ebae0[_0x3fea('0x6c')]();}_0x2f91fc=_0x3fea('0x6d')+_0x5ebae0[_0x3fea('0x6e')](',\x20')+')';}return _0x2f91fc;}function getFilteredInteractions(_0x3b4fc2,_0x521b0e,_0x518c2f,_0x6f6515){var _0x1b5832=utils[_0x3fea('0x19')](_0x3b4fc2);var _0x493010=_[_0x3fea('0x65')](_0x3b4fc2)+_0x3fea('0x6f');var _0x578f4d=[];var _0x196841=getTagsQuery();var _0x111331={'type':db[_0x3fea('0x70')][_0x3fea('0x71')][_0x3fea('0x72')],'raw':!![]};var _0x99865f=[];var _0x46de09=[];return db[_0x3fea('0x73')]['query'](_0x196841[_0x3fea('0x74')](),_0x111331)[_0x3fea('0x5f')](function(_0x1a626e){_0x578f4d=_['keyBy'](_0x1a626e,'id');_0x111331=_['merge'](_0x111331,{'model':db[_0x493010],'mapToModel':!![],'nest':!![]});if(_0x518c2f[_0x3fea('0x60')]){_0x6f6515[_0x3fea('0x75')][_0x3fea('0x24')](function(_0x5ce8fe){_0x521b0e[_0x3fea('0xa')]('i.'+_0x5ce8fe);});}else{_0x521b0e[_0x3fea('0xa')](_0x3fea('0x76'),_0x3fea('0x77'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x78'),_0x3fea('0x79'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x7a'),_0x3fea('0x7b'));if(_0x3b4fc2===_0x3fea('0x2d')){_0x521b0e[_0x3fea('0xa')](_0x3fea('0x7c'),'Account.email');_0x521b0e[_0x3fea('0xa')](_0x3fea('0x7d'),'contactName');_0x521b0e[_0x3fea('0xa')](_0x3fea('0x7e'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x7f'));_0x521b0e['field']('i.updatedAt');_0x521b0e[_0x3fea('0xa')](_0x3fea('0x80'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x81'));_0x521b0e[_0x3fea('0xa')]('i.attach');_0x521b0e['field'](_0x3fea('0x82'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x83'));_0x521b0e['field']('i.subject');_0x521b0e[_0x3fea('0xa')](_0x3fea('0x84'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x85'));_0x521b0e['field'](_0x3fea('0x86'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x6a'));_0x521b0e[_0x3fea('0xa')]('i.to');_0x521b0e['field'](_0x3fea('0x87'));_0x521b0e[_0x3fea('0xa')]('i.MailAccountId');_0x521b0e[_0x3fea('0xa')](_0x3fea('0x88'));}else if(_0x3b4fc2==='openchannel'){_0x521b0e['field'](_0x3fea('0x89'),'contactName');}else{_0x521b0e[_0x3fea('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',_0x3fea('0x8a'));}if(_0x3b4fc2!==_0x3fea('0x2d')){_0x521b0e[_0x3fea('0xa')]('i.*');}_0x521b0e[_0x3fea('0xa')](_0x3fea('0x8b'),_0x3fea('0x8c'));_0x521b0e['field'](_0x3fea('0x8d'),_0x3fea('0x8e'));_0x521b0e['field'](_0x3fea('0x8f'),_0x3fea('0x90'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x91'),_0x3fea('0x92'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x93'),_0x3fea('0x94'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x95'),_0x3fea('0x96'));_0x521b0e[_0x3fea('0xa')]('o.fullname',_0x3fea('0x97'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x98'),_0x3fea('0x99'));_0x521b0e[_0x3fea('0xa')](_0x3fea('0x9a'),_0x3fea('0x9b'));}if(_0x6f6515[_0x3fea('0x9c')]){_0x521b0e[_0x3fea('0x9c')](_0x6f6515[_0x3fea('0x9c')]);}if(_0x6f6515['offset']){_0x521b0e[_0x3fea('0x9d')](_0x6f6515[_0x3fea('0x9d')]);}return db[_0x3fea('0x73')][_0x3fea('0x9e')](_0x521b0e[_0x3fea('0x74')](),_0x111331);})[_0x3fea('0x5f')](function(_0xc2716a){_0x99865f=_0xc2716a;var _0x507ba3=getUsersQuery(_0x3b4fc2,_0x99865f);return db[_0x3fea('0x73')][_0x3fea('0x9e')](_0x507ba3[_0x3fea('0x74')](),_0x111331);})[_0x3fea('0x5f')](function(_0x44f1d0){_0x46de09=_[_0x3fea('0x9f')](_0x44f1d0,_0x1b5832);if(_0x3b4fc2===_0x3fea('0x2d')){return db['Setting']['findOne']({'attributes':[_0x3fea('0xa0')],'raw':!![]});}})[_0x3fea('0x5f')](function(_0x3aed74){var _0x274d63=_0x3aed74?_0x3aed74[_0x3fea('0xa0')]:undefined;var _0x3ea4b9=_0x99865f['map'](function(_0x2036c9){return updateInteraction(_0x2036c9,_0x578f4d,_0x46de09,_0x274d63);});return Promise[_0x3fea('0xa1')](_0x3ea4b9);});}function countFilteredInteractions(_0x3643cf,_0x37e7f8){var _0x3846f8=_0x3643cf['clone']();_0x3846f8[_0x3fea('0xa')](_0x3fea('0xa2'));_0x3846f8[_0x3fea('0xa')](_0x3fea('0x76'),_0x3fea('0x77'));var _0x56777f=utils[_0x3fea('0x23')](_0x37e7f8);if(!_['isEmpty'](_0x56777f)){_0x3846f8[_0x3fea('0x16')](_0x3fea('0xa3'),_0x56777f);}var _0x3ce4d7={'type':db['Sequelize'][_0x3fea('0x71')][_0x3fea('0x72')],'raw':!![]};return db[_0x3fea('0x73')][_0x3fea('0x9e')](_0x3846f8[_0x3fea('0x74')](),_0x3ce4d7);}module[_0x3fea('0xa4')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0xa086=['merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.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.createdAt','i.updatedAt','i.closed','i.closedAt','i.lastMsgDirection','i.to','i.ContactId','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','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','TagIds','limit','offset','query','groupBy','Setting','all','clone','isEmpty','Sequelize','SELECT','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','color','tools_tags','user_has_','_interactions','u.id','u.fullname','from','users','u.id\x20=\x20ui.UserId','length','where','ui.','\x20IN\x20?','map','getInteractionsTables','getInteractionFK','left_join','o.id\x20=\x20i.UserId','a.id\x20=\x20i.','messages','interactionsTags','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','{OPERATOR}','replace','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','mail','isEmail','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','i.from\x20LIKE\x20?','parseSearch','sqlOperator','conditions','find','name','text','value','start','end','unreadMessages','and','Contact','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','Tag','clause','tags','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','plainBody','body','keys','some','compact','concat','createdAt','$gte','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','resolve','then','read','tag','filter','get','capitalize','chat','Websites','Accounts','\x20IS\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','CONCAT_WS(\x27\x27,\x20','join','Interaction','QueryTypes','sequelize','toString','keyBy'];(function(_0x4683d2,_0x5c26b2){var _0x552b38=function(_0x15952b){while(--_0x15952b){_0x4683d2['push'](_0x4683d2['shift']());}};_0x552b38(++_0x5c26b2);}(_0xa086,0xd2));var _0x6a08=function(_0x5ee5f2,_0x5b979b){_0x5ee5f2=_0x5ee5f2-0x0;var _0x523a24=_0xa086[_0x5ee5f2];return _0x523a24;};'use strict';var _=require(_0x6a08('0x0'));var squel=require(_0x6a08('0x1'));var as=require(_0x6a08('0x2'));var qs=require(_0x6a08('0x3'));var updateInteraction=require(_0x6a08('0x4'))['updateInteraction'];var utils=require(_0x6a08('0x5'));var db=require(_0x6a08('0x6'))['db'];function skipInteractionsQuery(_0x55b1e8,_0x29bbb7,_0x9d002b){var _0x4d9854=![];var _0x553ed1=utils[_0x6a08('0x7')](_0x55b1e8);if(_0x29bbb7[_0x6a08('0x8')]===_0x6a08('0x9')&&!_0x9d002b[_0x6a08('0xa')]&&!_0x9d002b[_0x553ed1]){_0x4d9854=!![];}return _0x4d9854;}function getTagsQuery(){return squel[_0x6a08('0xb')]()[_0x6a08('0xc')]('id')[_0x6a08('0xc')]('name')[_0x6a08('0xc')](_0x6a08('0xd'))['from'](_0x6a08('0xe'));}function getUsersQuery(_0x77ff6d,_0x104913){var _0x331607=utils['getInteractionFK'](_0x77ff6d);var _0x5715a2=_0x6a08('0xf')+_0x77ff6d+_0x6a08('0x10');var _0x386544=squel['select']()[_0x6a08('0xc')](_0x6a08('0x11'))[_0x6a08('0xc')](_0x6a08('0x12'))[_0x6a08('0xc')]('ui.'+_0x331607)[_0x6a08('0x13')](_0x5715a2,'ui')['left_join'](_0x6a08('0x14'),'u',_0x6a08('0x15'));if(_0x104913[_0x6a08('0x16')]>0x0){_0x386544[_0x6a08('0x17')](_0x6a08('0x18')+_0x331607+_0x6a08('0x19'),_[_0x6a08('0x1a')](_0x104913,'id'));}return _0x386544;}function getInteractionsQuery(_0x581606){var _0x3ad15b=utils[_0x6a08('0x1b')](_0x581606);var _0x3bdccf=utils[_0x6a08('0x7')](_0x581606);var _0x3a9a42=utils[_0x6a08('0x1c')](_0x581606);return squel['select']()[_0x6a08('0x13')](_0x3ad15b['interactions'],'i')[_0x6a08('0x1d')]('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x6a08('0x1d')]('users','o',_0x6a08('0x1e'))[_0x6a08('0x1d')](_0x3ad15b['accounts'],'a',_0x6a08('0x1f')+_0x3bdccf)[_0x6a08('0x1d')](_0x3ad15b[_0x6a08('0x20')],'me','me.'+_0x3a9a42+'\x20=\x20i.id')[_0x6a08('0x1d')](_0x3ad15b[_0x6a08('0x21')],'it',_0x6a08('0x22')+_0x3a9a42+'\x20=\x20i.id')['left_join']('tools_tags','t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x1db052={'body':squel[_0x6a08('0x23')](),'contact':squel['expr'](),'default':squel[_0x6a08('0x23')](),'fields':squel[_0x6a08('0x23')](),'filter':squel[_0x6a08('0x23')](),'read':squel[_0x6a08('0x23')](),'tags':{'clause':squel[_0x6a08('0x23')](),'ids':null},'user':squel['expr']()};return _0x1db052;}function parseTagParameter(_0x366d30){var _0x2a099e=squel[_0x6a08('0x23')]();if(_0x366d30){var _0x55874b=utils[_0x6a08('0x24')](_0x366d30);_0x55874b[_0x6a08('0x25')](function(_0x2d0526){_0x2a099e['or'](_0x6a08('0x26'),'%,'+_0x2d0526+',%');});}return _0x2a099e;}function parseReadParameter(_0x380b9d){var _0x7de2cc='';if(_0x380b9d){_0x7de2cc=_0x6a08('0x27');if(_0x380b9d==='1'){_0x7de2cc=_0x7de2cc['replace'](_0x6a08('0x28'),'=');}else{_0x7de2cc=_0x7de2cc[_0x6a08('0x29')]('{OPERATOR}','>');}}return _0x7de2cc;}function parseSearchFilter(_0x19c3c1,_0x2fc159){var _0x1066a0=squel[_0x6a08('0x23')]();if(_0x2fc159){var _0x2e4e7a=_0x2fc159[_0x6a08('0x29')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x6a08('0x2a')](_0x2e4e7a)){_0x1066a0['or'](_0x6a08('0x2b'),_0x2e4e7a+'%');if([_0x6a08('0x2c'),_0x6a08('0x2d')][_0x6a08('0x2e')](_0x19c3c1)){_0x1066a0['or'](_0x6a08('0x2f'),_0x2e4e7a+'%');}else if(_0x19c3c1===_0x6a08('0x30')){_0x1066a0['or'](_0x6a08('0x31'),_0x2e4e7a+'%');}}else if(_0x19c3c1===_0x6a08('0x32')&&qs[_0x6a08('0x33')](_0x2e4e7a)){_0x1066a0['or']('c.email\x20LIKE\x20?',_0x2e4e7a+'%');}else{if(_0x19c3c1==='mail'){_0x1066a0['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x6a08('0x34')](_0x2e4e7a))['or'](_0x6a08('0x35'),qs[_0x6a08('0x34')](_0x2e4e7a));}else{if(_0x19c3c1!==_0x6a08('0x30')){_0x1066a0['or']('MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x6a08('0x34')](_0x2e4e7a));}_0x1066a0['or'](_0x6a08('0x36'),_0x2e4e7a+'%');if(_0x19c3c1==='openchannel'){_0x1066a0['or'](_0x6a08('0x37'),_0x2e4e7a+'%');}}}}return _0x1066a0;}function parseAdvancedSearchFilter(_0xb95193,_0x47c9dd){var _0x46ac15=getSqlClauses();var _0x349adc=as[_0x6a08('0x38')](_0xb95193);var _0x70b59c=_0x349adc[_0x6a08('0x39')];for(var _0x23d2d2=0x0;_0x23d2d2<_0x349adc[_0x6a08('0x3a')][_0x6a08('0x16')];_0x23d2d2++){var _0x5974d8=_0x349adc['conditions'][_0x23d2d2];var _0x2d9cf7='i';var _0x5646e3=_[_0x6a08('0x3b')](_0x47c9dd,[_0x6a08('0x3c'),_0x5974d8['field']]);if(_0x5646e3){var _0x21d8e4=as['buildExpression'](_0x2d9cf7,_0x5646e3['type'],_0x5974d8);_0x46ac15['default'][_0x70b59c](_0x21d8e4[_0x6a08('0x3d')],_0x21d8e4[_0x6a08('0x3e')][_0x6a08('0x3f')],_0x21d8e4[_0x6a08('0x3e')][_0x6a08('0x40')]);}else{switch(_0x5974d8[_0x6a08('0xc')]){case _0x6a08('0x41'):var _0x200655=parseReadParameter(_0x5974d8['value']);_0x46ac15['read'][_0x6a08('0x42')](_0x200655);break;case _0x6a08('0x43'):if(_0x5974d8[_0x6a08('0x44')]===_0x6a08('0x45')){if(_0x5974d8[_0x6a08('0x3e')][_0x6a08('0x46')]('\x20')[_0x6a08('0x16')]>0x1){_0x46ac15[_0x6a08('0x47')][_0x70b59c](_0x6a08('0x48'),qs[_0x6a08('0x34')](_0x5974d8[_0x6a08('0x3e')]),null);}else{var _0x598d74='%'+_0x5974d8[_0x6a08('0x3e')]+'%';_0x46ac15[_0x6a08('0x47')][_0x70b59c]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x598d74,_0x598d74,_0x598d74);}}else{_0x5646e3=_[_0x6a08('0x3b')](_0x47c9dd,[_0x6a08('0x3c'),_0x6a08('0x49')]);_0x5974d8[_0x6a08('0xc')]=_0x6a08('0x49');_0x21d8e4=as[_0x6a08('0x4a')](_0x2d9cf7,_0x5646e3[_0x6a08('0x4b')],_0x5974d8);_0x46ac15[_0x6a08('0x47')][_0x70b59c](_0x21d8e4[_0x6a08('0x3d')],_0x21d8e4[_0x6a08('0x3e')][_0x6a08('0x3f')],_0x21d8e4[_0x6a08('0x3e')][_0x6a08('0x40')]);}break;case _0x6a08('0x4c'):var _0x49d12c=_0x5974d8[_0x6a08('0x3e')][_0x6a08('0x46')](',')[_0x6a08('0x1a')](function(_0x51a834){return Number(_0x51a834);});var _0x417f2b=parseTagParameter(_0x49d12c);_0x46ac15['tags'][_0x6a08('0x4d')]['and'](_0x417f2b);_0x46ac15[_0x6a08('0x4e')]['ids']=_0x49d12c;break;case _0x6a08('0x4f'):if(_0x5974d8[_0x6a08('0x44')]==='$substring'){_0x46ac15[_0x6a08('0x50')][_0x70b59c](_0x6a08('0x51'),'%'+_0x5974d8['value']+'%',null);}else{_0x5646e3=_[_0x6a08('0x3b')](_0x47c9dd,[_0x6a08('0x3c'),_0x6a08('0x52')]);_0x5974d8[_0x6a08('0xc')]=_0x6a08('0x52');_0x21d8e4=as['buildExpression'](_0x2d9cf7,_0x5646e3[_0x6a08('0x4b')],_0x5974d8);_0x46ac15[_0x6a08('0x50')][_0x70b59c](_0x21d8e4[_0x6a08('0x3d')],_0x21d8e4[_0x6a08('0x3e')]['start'],_0x21d8e4['value'][_0x6a08('0x40')]);}break;case'body':case _0x6a08('0x53'):_0x21d8e4=as[_0x6a08('0x4a')]('me',null,_0x5974d8);_0x46ac15[_0x6a08('0x54')][_0x70b59c](_0x21d8e4[_0x6a08('0x3d')],_0x21d8e4[_0x6a08('0x3e')][_0x6a08('0x3f')],_0x21d8e4[_0x6a08('0x3e')][_0x6a08('0x40')]);break;}}}return _0x46ac15;}function parseModelFields(_0x428262,_0x9f13f4,_0x1872eb){var _0x515e58=utils['getAccountFK'](_0x428262);var _0x5ac0ac=squel[_0x6a08('0x23')]();var _0x22ea51=_(_0x9f13f4)[_0x6a08('0x55')]()['map'](function(_0xde423){return _[_0x6a08('0x56')](_0x1872eb,[_0x6a08('0x3c'),_0xde423])?_0xde423:undefined;})[_0x6a08('0x57')]()['value']();if(_0x22ea51['length']>0x0){_0x22ea51[_0x6a08('0x25')](function(_0x195d78){if(_0x195d78===_0x515e58){_0x5ac0ac[_0x6a08('0x42')]('i.'+_0x515e58+_0x6a08('0x19'),[][_0x6a08('0x58')](_0x9f13f4[_0x195d78]));}else if(_0x195d78===_0x6a08('0x59')){var _0x1a72fe=JSON['parse'](_0x9f13f4[_0x195d78])[_0x6a08('0x5a')];var _0x1b6bfe=JSON[_0x6a08('0x5b')](_0x9f13f4[_0x195d78])[_0x6a08('0x5c')];_0x5ac0ac[_0x6a08('0x42')](_0x6a08('0x5d'),_0x1a72fe,_0x1b6bfe);}else{if(_0x9f13f4[_0x195d78]===_0x6a08('0x5e')){_0x5ac0ac[_0x6a08('0x42')]('i.'+_0x195d78+'\x20IS\x20NULL');}else{_0x5ac0ac[_0x6a08('0x42')]('i.'+_0x195d78+_0x6a08('0x5f'),_0x9f13f4[_0x195d78]);}}});}return _0x5ac0ac;}function parseQueryParameters(_0x33acfb,_0x717283,_0x2d27f4){var _0x313903=getSqlClauses();return Promise[_0x6a08('0x60')]()['then'](function(){return parseModelFields(_0x33acfb,_0x717283,_0x2d27f4);})[_0x6a08('0x61')](function(_0x27f3f1){_0x313903['fields']['and'](_0x27f3f1);return parseReadParameter(_0x717283[_0x6a08('0x62')]);})[_0x6a08('0x61')](function(_0x5c2058){_0x313903[_0x6a08('0x62')]['and'](_0x5c2058);return parseTagParameter(_0x717283[_0x6a08('0x63')]);})['then'](function(_0x2629ec){_0x313903['tags'][_0x6a08('0x4d')]['and'](_0x2629ec);return parseSearchFilter(_0x33acfb,_0x717283[_0x6a08('0x64')]);})['then'](function(_0x5d0c76){_0x313903[_0x6a08('0x64')]=_0x5d0c76;return _0x313903;});}function checkAccountsRestrictions(_0x2e9f05,_0x51c531,_0x4c304b){var _0x570754=utils[_0x6a08('0x7')](_0x2e9f05);var _0x4a13a1=_0x6a08('0x65')+_[_0x6a08('0x66')](_0x2e9f05)+(_0x2e9f05===_0x6a08('0x67')?_0x6a08('0x68'):_0x6a08('0x69'));var _0x197f45=squel['expr']();return Promise[_0x6a08('0x60')]()['then'](function(){if(_0x4c304b[_0x6a08('0xa')]&&_0x51c531[_0x6a08('0x8')]==='agent'){return _0x51c531[_0x4a13a1]({'attributes':['id'],'raw':!![]});}})[_0x6a08('0x61')](function(_0x31b60f){if(_0x31b60f){if(_0x31b60f[_0x6a08('0x16')]===0x0){_0x197f45[_0x6a08('0x42')]('i.'+_0x570754+_0x6a08('0x6a'));}else{_0x197f45['and']('i.'+_0x570754+_0x6a08('0x19'),_[_0x6a08('0x1a')](_0x31b60f,'id'));}}else if(!_0x4c304b[_0x570754]){_0x197f45[_0x6a08('0x42')]('i.'+_0x570754+'\x20IS\x20NOT\x20NULL');}})['then'](function(){return _0x197f45;});}function getClosedOrderClause(_0x12b81d,_0x197a3f){var _0x2a4e95='';var _0x50d711=[_0x6a08('0x6b'),_0x6a08('0x6c'),_0x6a08('0x6d')];if(_0x12b81d==='mail'){_0x50d711[_0x6a08('0x6e')](_0x6a08('0x6f'));}if(_0x197a3f['closed']==='0'&&_0x12b81d===_0x6a08('0x32')){_0x2a4e95=_0x6a08('0x6f');}else{if(_0x197a3f[_0x6a08('0x70')]==='1'){_0x50d711['shift']();}_0x2a4e95=_0x6a08('0x71')+_0x50d711[_0x6a08('0x72')](',\x20')+')';}return _0x2a4e95;}function getFilteredInteractions(_0x5124be,_0x277986,_0x149c80,_0x10dc86){var _0x38c0d7=utils[_0x6a08('0x1c')](_0x5124be);var _0x150447=_[_0x6a08('0x66')](_0x5124be)+_0x6a08('0x73');var _0x5505d4=[];var _0x4f6dad=getTagsQuery();var _0x31b557={'type':db['Sequelize'][_0x6a08('0x74')]['SELECT'],'raw':!![]};var _0x4d3f79=[];var _0x3578d2=[];return db[_0x6a08('0x75')]['query'](_0x4f6dad[_0x6a08('0x76')](),_0x31b557)[_0x6a08('0x61')](function(_0x2567d0){_0x5505d4=_[_0x6a08('0x77')](_0x2567d0,'id');_0x31b557=_[_0x6a08('0x78')](_0x31b557,{'model':db[_0x150447],'mapToModel':!![],'nest':!![]});if(_0x149c80['fields']){_0x10dc86['attributes'][_0x6a08('0x25')](function(_0x5a2160){_0x277986[_0x6a08('0xc')]('i.'+_0x5a2160);});}else{_0x277986[_0x6a08('0xc')](_0x6a08('0x79'),_0x6a08('0x41'));_0x277986[_0x6a08('0xc')](_0x6a08('0x7a'),'Account.key');_0x277986['field'](_0x6a08('0x7b'),_0x6a08('0x7c'));if(_0x5124be===_0x6a08('0x32')){_0x277986['field'](_0x6a08('0x7d'),_0x6a08('0x7e'));_0x277986[_0x6a08('0xc')](_0x6a08('0x7f'),_0x6a08('0x80'));_0x277986[_0x6a08('0xc')]('i.id');_0x277986[_0x6a08('0xc')](_0x6a08('0x81'));_0x277986['field'](_0x6a08('0x82'));_0x277986[_0x6a08('0xc')](_0x6a08('0x83'));_0x277986['field'](_0x6a08('0x84'));_0x277986[_0x6a08('0xc')]('i.attach');_0x277986[_0x6a08('0xc')]('i.lastMsgAt');_0x277986['field'](_0x6a08('0x85'));_0x277986['field']('i.subject');_0x277986[_0x6a08('0xc')](_0x6a08('0x6d'));_0x277986['field'](_0x6a08('0x6c'));_0x277986[_0x6a08('0xc')](_0x6a08('0x6b'));_0x277986['field'](_0x6a08('0x6f'));_0x277986[_0x6a08('0xc')](_0x6a08('0x86'));_0x277986[_0x6a08('0xc')](_0x6a08('0x87'));_0x277986['field']('i.MailAccountId');_0x277986['field']('i.UserId');}else if(_0x5124be==='openchannel'){_0x277986[_0x6a08('0xc')]('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','contactName');}else{_0x277986[_0x6a08('0xc')](_0x6a08('0x88'),_0x6a08('0x80'));}if(_0x5124be!==_0x6a08('0x32')){_0x277986[_0x6a08('0xc')](_0x6a08('0x89'));}_0x277986[_0x6a08('0xc')](_0x6a08('0x8a'),_0x6a08('0x8b'));_0x277986[_0x6a08('0xc')](_0x6a08('0x8c'),_0x6a08('0x8d'));_0x277986['field']('c.email',_0x6a08('0x8e'));_0x277986[_0x6a08('0xc')](_0x6a08('0x8f'),_0x6a08('0x90'));_0x277986['field'](_0x6a08('0x91'),_0x6a08('0x92'));_0x277986['field'](_0x6a08('0x93'),_0x6a08('0x94'));_0x277986[_0x6a08('0xc')](_0x6a08('0x95'),_0x6a08('0x96'));_0x277986[_0x6a08('0xc')](_0x6a08('0x97'),_0x6a08('0x98'));_0x277986[_0x6a08('0xc')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x6a08('0x99'));}if(_0x10dc86[_0x6a08('0x9a')]){_0x277986[_0x6a08('0x9a')](_0x10dc86[_0x6a08('0x9a')]);}if(_0x10dc86['offset']){_0x277986[_0x6a08('0x9b')](_0x10dc86[_0x6a08('0x9b')]);}return db[_0x6a08('0x75')][_0x6a08('0x9c')](_0x277986['toString'](),_0x31b557);})[_0x6a08('0x61')](function(_0x4423e3){_0x4d3f79=_0x4423e3;var _0x2caa09=getUsersQuery(_0x5124be,_0x4d3f79);return db['sequelize'][_0x6a08('0x9c')](_0x2caa09[_0x6a08('0x76')](),_0x31b557);})[_0x6a08('0x61')](function(_0x15d0af){_0x3578d2=_[_0x6a08('0x9d')](_0x15d0af,_0x38c0d7);if(_0x5124be===_0x6a08('0x32')){return db[_0x6a08('0x9e')]['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})['then'](function(_0x140b1c){var _0x4ed8fa=_0x140b1c?_0x140b1c['enableEmailPreview']:undefined;var _0x14065a=_0x4d3f79['map'](function(_0x2fd73e){return updateInteraction(_0x2fd73e,_0x5505d4,_0x3578d2,_0x4ed8fa);});return Promise[_0x6a08('0x9f')](_0x14065a);});}function countFilteredInteractions(_0x414d7e,_0x59a95d){var _0x1a6a7d=_0x414d7e[_0x6a08('0xa0')]();_0x1a6a7d[_0x6a08('0xc')]('COUNT(*)');_0x1a6a7d[_0x6a08('0xc')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x6a08('0x41'));var _0x4d6177=utils[_0x6a08('0x24')](_0x59a95d);if(!_[_0x6a08('0xa1')](_0x4d6177)){_0x1a6a7d['where']('t.id\x20IN\x20?',_0x4d6177);}var _0x27d3c8={'type':db[_0x6a08('0xa2')]['QueryTypes'][_0x6a08('0xa3')],'raw':!![]};return db[_0x6a08('0x75')][_0x6a08('0x9c')](_0x1a6a7d[_0x6a08('0x76')](),_0x27d3c8);}module[_0x6a08('0xa4')]={'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