// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x06a6=['Contact','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','type','Tag','clause','tags','ids','operator','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','keys','some','compact','and','concat','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','read','filter','capitalize','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.disposition','unshift','closed','i.substatus','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','keyBy','merge','fields','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','Account.email','i.id','i.createdAt','i.updatedAt','i.closed','i.attach','i.lastMsgDirection','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','contactName','c.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','c.fax','o.internal','limit','offset','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','squel','../parsers/advancedSearch','../parsers/qs','updateInteraction','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','u.id','u.fullname','ui.','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionsTables','interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','accounts','messages','me.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','whatsapp','includes','fax','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)','parseSearch','sqlOperator','conditions','find','buildExpression','default','text','value','start','end'];(function(_0x2bd1ec,_0x3fe65f){var _0x2f7577=function(_0x5234fb){while(--_0x5234fb){_0x2bd1ec['push'](_0x2bd1ec['shift']());}};_0x2f7577(++_0x3fe65f);}(_0x06a6,0xfd));var _0x606a=function(_0x1151fa,_0x2784a7){_0x1151fa=_0x1151fa-0x0;var _0x49da2b=_0x06a6[_0x1151fa];return _0x49da2b;};'use strict';var _=require('lodash');var squel=require(_0x606a('0x0'));var as=require(_0x606a('0x1'));var qs=require(_0x606a('0x2'));var updateInteraction=require('./update-interaction')[_0x606a('0x3')];var utils=require(_0x606a('0x4'));var db=require(_0x606a('0x5'))['db'];function skipInteractionsQuery(_0x21d20d,_0x4654b7,_0x2c0c58){var _0x246296=![];var _0x37b7ca=utils[_0x606a('0x6')](_0x21d20d);if(_0x4654b7[_0x606a('0x7')]===_0x606a('0x8')&&!_0x2c0c58[_0x606a('0x9')]&&!_0x2c0c58[_0x37b7ca]){_0x246296=!![];}return _0x246296;}function getTagsQuery(){return squel[_0x606a('0xa')]()[_0x606a('0xb')]('id')[_0x606a('0xb')](_0x606a('0xc'))[_0x606a('0xb')](_0x606a('0xd'))[_0x606a('0xe')](_0x606a('0xf'));}function getUsersQuery(_0x416b3b,_0x52f7d6){var _0x300f05=utils[_0x606a('0x10')](_0x416b3b);var _0xfd7472=_0x606a('0x11')+_0x416b3b+'_interactions';var _0x3ab565=squel[_0x606a('0xa')]()[_0x606a('0xb')](_0x606a('0x12'))['field'](_0x606a('0x13'))[_0x606a('0xb')](_0x606a('0x14')+_0x300f05)[_0x606a('0xe')](_0xfd7472,'ui')['left_join']('users','u',_0x606a('0x15'));if(_0x52f7d6[_0x606a('0x16')]>0x0){_0x3ab565[_0x606a('0x17')](_0x606a('0x14')+_0x300f05+_0x606a('0x18'),_[_0x606a('0x19')](_0x52f7d6,'id'));}return _0x3ab565;}function getInteractionsQuery(_0x2ed020){var _0x2f122f=utils[_0x606a('0x1a')](_0x2ed020);var _0x579da3=utils[_0x606a('0x6')](_0x2ed020);var _0x2a8d5a=utils[_0x606a('0x10')](_0x2ed020);return squel['select']()[_0x606a('0xe')](_0x2f122f[_0x606a('0x1b')],'i')[_0x606a('0x1c')](_0x606a('0x1d'),'c',_0x606a('0x1e'))[_0x606a('0x1c')](_0x606a('0x1f'),'o',_0x606a('0x20'))[_0x606a('0x1c')](_0x2f122f[_0x606a('0x21')],'a','a.id\x20=\x20i.'+_0x579da3)[_0x606a('0x1c')](_0x2f122f[_0x606a('0x22')],'me',_0x606a('0x23')+_0x2a8d5a+_0x606a('0x24'))['left_join'](_0x2f122f[_0x606a('0x25')],'it',_0x606a('0x26')+_0x2a8d5a+_0x606a('0x24'))[_0x606a('0x1c')]('tools_tags','t',_0x606a('0x27'));}function getSqlClauses(){var _0x4dc77={'body':squel[_0x606a('0x28')](),'contact':squel[_0x606a('0x28')](),'default':squel[_0x606a('0x28')](),'fields':squel[_0x606a('0x28')](),'filter':squel['expr'](),'read':squel[_0x606a('0x28')](),'tags':{'clause':squel[_0x606a('0x28')](),'ids':null},'user':squel[_0x606a('0x28')]()};return _0x4dc77;}function parseTagParameter(_0x34b026){var _0x5d74ef=squel[_0x606a('0x28')]();if(_0x34b026){var _0x4a8cc3=utils[_0x606a('0x29')](_0x34b026);_0x4a8cc3['forEach'](function(_0x14e70c){_0x5d74ef['or'](_0x606a('0x2a'),'%,'+_0x14e70c+',%');});}return _0x5d74ef;}function parseReadParameter(_0x53f742){var _0x3d06f4='';if(_0x53f742){_0x3d06f4='unreadMessages\x20{OPERATOR}\x200';if(_0x53f742==='1'){_0x3d06f4=_0x3d06f4['replace']('{OPERATOR}','=');}else{_0x3d06f4=_0x3d06f4[_0x606a('0x2b')](_0x606a('0x2c'),'>');}}return _0x3d06f4;}function parseSearchFilter(_0x58a9cd,_0x546f82){var _0x385439=squel[_0x606a('0x28')]();if(_0x546f82){var _0x5ed55c=_0x546f82[_0x606a('0x2b')]('\x5c','\x5c\x5c')[_0x606a('0x2b')](/'/g,'\x27\x27');var _0x3c198c=qs[_0x606a('0x2d')](_0x5ed55c);if(qs[_0x606a('0x2e')](_0x5ed55c)){_0x385439['or'](_0x606a('0x2f'),_0x3c198c+'%');if(['sms',_0x606a('0x30')][_0x606a('0x31')](_0x58a9cd)){_0x385439['or']('i.phone\x20LIKE\x20?',_0x3c198c+'%');}else if(_0x58a9cd===_0x606a('0x32')){_0x385439['or']('i.fax\x20LIKE\x20?',_0x3c198c+'%');}else if(_0x58a9cd===_0x606a('0x33')){_0x385439['or'](_0x606a('0x34'),_0x3c198c+'%');}}else if(_0x58a9cd===_0x606a('0x35')&&qs[_0x606a('0x36')](_0x5ed55c)){_0x385439['or'](_0x606a('0x37'),_0x3c198c+'%');}else{if(_0x58a9cd===_0x606a('0x35')){_0x385439['or'](_0x606a('0x38'),qs[_0x606a('0x39')](_0x5ed55c,!![]))['or'](_0x606a('0x3a'),qs[_0x606a('0x39')](_0x5ed55c));}else if(_0x58a9cd!=='fax'){_0x385439['or'](_0x606a('0x3b'),qs[_0x606a('0x39')](_0x5ed55c));}_0x385439['or'](_0x606a('0x3c'),qs[_0x606a('0x39')](_0x5ed55c,!![]),null);}}return _0x385439;}function parseAdvancedSearchFilter(_0x4e95bd,_0x260bb8){var _0xc5f6b4=getSqlClauses();var _0x5d1073=as[_0x606a('0x3d')](_0x4e95bd);var _0x58ee68=_0x5d1073[_0x606a('0x3e')];for(var _0x2ed8fd=0x0;_0x2ed8fd<_0x5d1073[_0x606a('0x3f')]['length'];_0x2ed8fd++){var _0x58e7cc=_0x5d1073['conditions'][_0x2ed8fd];var _0x5dbf4f='i';var _0x471c34=_[_0x606a('0x40')](_0x260bb8,[_0x606a('0xc'),_0x58e7cc[_0x606a('0xb')]]);if(_0x471c34){var _0xba73d3=as[_0x606a('0x41')](_0x5dbf4f,_0x471c34['type'],_0x58e7cc);_0xc5f6b4[_0x606a('0x42')][_0x58ee68](_0xba73d3[_0x606a('0x43')],_0xba73d3[_0x606a('0x44')][_0x606a('0x45')],_0xba73d3[_0x606a('0x44')][_0x606a('0x46')]);}else{switch(_0x58e7cc[_0x606a('0xb')]){case'unreadMessages':var _0x485769=parseReadParameter(_0x58e7cc[_0x606a('0x44')]);_0xc5f6b4['read']['and'](_0x485769);break;case _0x606a('0x47'):if(_0x58e7cc['operator']===_0x606a('0x48')){if(_0x58e7cc[_0x606a('0x44')][_0x606a('0x49')]('\x20')[_0x606a('0x16')]>0x1){_0xc5f6b4[_0x606a('0x4a')][_0x58ee68]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x606a('0x39')](_0x58e7cc[_0x606a('0x44')],!![]),null);}else{var _0x222bd4='%'+_0x58e7cc[_0x606a('0x44')]+'%';_0xc5f6b4[_0x606a('0x4a')][_0x58ee68](_0x606a('0x4b'),_0x222bd4,_0x222bd4,_0x222bd4);}}else{_0x471c34=_[_0x606a('0x40')](_0x260bb8,[_0x606a('0xc'),_0x606a('0x4c')]);_0x58e7cc[_0x606a('0xb')]=_0x606a('0x4c');_0xba73d3=as[_0x606a('0x41')](_0x5dbf4f,_0x471c34[_0x606a('0x4d')],_0x58e7cc);_0xc5f6b4['contact'][_0x58ee68](_0xba73d3['text'],_0xba73d3[_0x606a('0x44')][_0x606a('0x45')],_0xba73d3[_0x606a('0x44')][_0x606a('0x46')]);}break;case _0x606a('0x4e'):var _0x302644=_0x58e7cc[_0x606a('0x44')][_0x606a('0x49')](',')['map'](function(_0x47f09b){return Number(_0x47f09b);});var _0x321014=parseTagParameter(_0x302644);_0xc5f6b4['tags'][_0x606a('0x4f')]['and'](_0x321014);_0xc5f6b4[_0x606a('0x50')][_0x606a('0x51')]=_0x302644;break;case'User':if(_0x58e7cc[_0x606a('0x52')]===_0x606a('0x48')){_0xc5f6b4[_0x606a('0x53')][_0x58ee68](_0x606a('0x54'),'%'+_0x58e7cc['value']+'%',null);}else{_0x471c34=_[_0x606a('0x40')](_0x260bb8,['name',_0x606a('0x55')]);_0x58e7cc[_0x606a('0xb')]=_0x606a('0x55');_0xba73d3=as[_0x606a('0x41')](_0x5dbf4f,_0x471c34[_0x606a('0x4d')],_0x58e7cc);_0xc5f6b4[_0x606a('0x53')][_0x58ee68](_0xba73d3[_0x606a('0x43')],_0xba73d3[_0x606a('0x44')][_0x606a('0x45')],_0xba73d3[_0x606a('0x44')][_0x606a('0x46')]);}break;case _0x606a('0x56'):case'plainBody':_0xba73d3=as[_0x606a('0x41')]('me',null,_0x58e7cc);_0xc5f6b4[_0x606a('0x56')][_0x58ee68](_0xba73d3[_0x606a('0x43')],_0xba73d3[_0x606a('0x44')]['start'],_0xba73d3['value']['end']);break;}}}return _0xc5f6b4;}function parseModelFields(_0x47378b,_0x3da069,_0x5e7702){var _0x3704a9=utils['getAccountFK'](_0x47378b);var _0x25c8e8=squel[_0x606a('0x28')]();var _0x404d5b=_(_0x3da069)[_0x606a('0x57')]()[_0x606a('0x19')](function(_0xd7ee03){return _[_0x606a('0x58')](_0x5e7702,[_0x606a('0xc'),_0xd7ee03])?_0xd7ee03:undefined;})[_0x606a('0x59')]()['value']();if(_0x404d5b[_0x606a('0x16')]>0x0){_0x404d5b['forEach'](function(_0x2039dd){if(_0x2039dd===_0x3704a9){_0x25c8e8[_0x606a('0x5a')]('i.'+_0x3704a9+'\x20IN\x20?',[][_0x606a('0x5b')](_0x3da069[_0x2039dd]));}else if(_0x2039dd==='createdAt'){var _0xd20552=JSON[_0x606a('0x5c')](_0x3da069[_0x2039dd])[_0x606a('0x5d')];var _0x36c315=JSON[_0x606a('0x5c')](_0x3da069[_0x2039dd])[_0x606a('0x5e')];_0x25c8e8['and'](_0x606a('0x5f'),_0xd20552,_0x36c315);}else{if(_0x3da069[_0x2039dd]===_0x606a('0x60')){_0x25c8e8[_0x606a('0x5a')]('i.'+_0x2039dd+_0x606a('0x61'));}else{_0x25c8e8[_0x606a('0x5a')]('i.'+_0x2039dd+_0x606a('0x62'),_0x3da069[_0x2039dd]);}}});}return _0x25c8e8;}function parseQueryParameters(_0x21dfca,_0x54e6af,_0x1d6028){var _0x3e3537=getSqlClauses();return Promise[_0x606a('0x63')]()[_0x606a('0x64')](function(){return parseModelFields(_0x21dfca,_0x54e6af,_0x1d6028);})['then'](function(_0xa9b989){_0x3e3537['fields'][_0x606a('0x5a')](_0xa9b989);return parseReadParameter(_0x54e6af[_0x606a('0x65')]);})[_0x606a('0x64')](function(_0x101186){_0x3e3537[_0x606a('0x65')][_0x606a('0x5a')](_0x101186);return parseTagParameter(_0x54e6af['tag']);})[_0x606a('0x64')](function(_0x1237ad){_0x3e3537[_0x606a('0x50')]['clause'][_0x606a('0x5a')](_0x1237ad);return parseSearchFilter(_0x21dfca,_0x54e6af[_0x606a('0x66')]);})[_0x606a('0x64')](function(_0x10c435){_0x3e3537[_0x606a('0x66')]=_0x10c435;return _0x3e3537;});}function checkAccountsRestrictions(_0x3feb3f,_0xc681d1,_0x8da1f){var _0xbed7f4=utils[_0x606a('0x6')](_0x3feb3f);var _0x191cbf='get'+_[_0x606a('0x67')](_0x3feb3f)+(_0x3feb3f==='chat'?_0x606a('0x68'):_0x606a('0x69'));var _0x302d99=squel[_0x606a('0x28')]();return Promise[_0x606a('0x63')]()[_0x606a('0x64')](function(){if(_0x8da1f[_0x606a('0x9')]&&_0xc681d1[_0x606a('0x7')]==='agent'){return _0xc681d1[_0x191cbf]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x46a81b){if(_0x46a81b){if(_0x46a81b[_0x606a('0x16')]===0x0){_0x302d99['and']('i.'+_0xbed7f4+_0x606a('0x61'));}else{_0x302d99['and']('i.'+_0xbed7f4+_0x606a('0x18'),_['map'](_0x46a81b,'id'));}}else if(!_0x8da1f[_0xbed7f4]){_0x302d99[_0x606a('0x5a')]('i.'+_0xbed7f4+_0x606a('0x6a'));}})[_0x606a('0x64')](function(){return _0x302d99;});}function getClosedOrderClause(_0xbf6bb1,_0x21ef3f){var _0x80333f='';var _0x3ba694=[_0x606a('0x6b'),'i.secondDisposition',_0x606a('0x6c')];if(_0xbf6bb1==='mail'){_0x3ba694[_0x606a('0x6d')]('i.substatus');}if(_0x21ef3f[_0x606a('0x6e')]==='0'&&_0xbf6bb1===_0x606a('0x35')){_0x80333f=_0x606a('0x6f');}else{if(_0x21ef3f[_0x606a('0x6e')]==='1'){_0x3ba694['shift']();}_0x80333f=_0x606a('0x70')+_0x3ba694[_0x606a('0x71')](',\x20')+')';}return _0x80333f;}function getFilteredInteractions(_0x4058e8,_0x3e02e2,_0x2527cb,_0x4602d6){var _0x25ad55=utils[_0x606a('0x10')](_0x4058e8);var _0x3309f7=_['capitalize'](_0x4058e8)+_0x606a('0x72');var _0x4e28a3=[];var _0x5dfcbb=getTagsQuery();var _0x2fa95f={'type':db[_0x606a('0x73')][_0x606a('0x74')][_0x606a('0x75')],'raw':!![]};var _0x53e893=[];var _0x2bb3b8=[];return db[_0x606a('0x76')][_0x606a('0x77')](_0x5dfcbb[_0x606a('0x78')](),_0x2fa95f)[_0x606a('0x64')](function(_0x35e5f2){_0x4e28a3=_[_0x606a('0x79')](_0x35e5f2,'id');_0x2fa95f=_[_0x606a('0x7a')](_0x2fa95f,{'model':db[_0x3309f7],'mapToModel':!![],'nest':!![]});if(_0x2527cb[_0x606a('0x7b')]){_0x4602d6[_0x606a('0x7c')]['forEach'](function(_0x298648){_0x3e02e2[_0x606a('0xb')]('i.'+_0x298648);});}else{_0x3e02e2[_0x606a('0xb')](_0x606a('0x7d'),_0x606a('0x7e'));_0x3e02e2[_0x606a('0xb')]('a.key',_0x606a('0x7f'));_0x3e02e2[_0x606a('0xb')](_0x606a('0x80'),_0x606a('0x81'));if(_0x4058e8==='mail'){_0x3e02e2[_0x606a('0xb')](_0x606a('0x82'),_0x606a('0x83'));_0x3e02e2['field']('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');_0x3e02e2['field'](_0x606a('0x84'));_0x3e02e2[_0x606a('0xb')](_0x606a('0x85'));_0x3e02e2[_0x606a('0xb')](_0x606a('0x86'));_0x3e02e2['field'](_0x606a('0x87'));_0x3e02e2[_0x606a('0xb')]('i.closedAt');_0x3e02e2[_0x606a('0xb')](_0x606a('0x88'));_0x3e02e2[_0x606a('0xb')]('i.lastMsgAt');_0x3e02e2[_0x606a('0xb')](_0x606a('0x89'));_0x3e02e2[_0x606a('0xb')]('i.subject');_0x3e02e2['field']('i.disposition');_0x3e02e2['field']('i.secondDisposition');_0x3e02e2['field'](_0x606a('0x6b'));_0x3e02e2[_0x606a('0xb')]('i.substatus');_0x3e02e2[_0x606a('0xb')](_0x606a('0x8a'));_0x3e02e2[_0x606a('0xb')](_0x606a('0x8b'));_0x3e02e2[_0x606a('0xb')]('i.MailAccountId');_0x3e02e2['field'](_0x606a('0x8c'));}else if(_0x4058e8==='openchannel'){_0x3e02e2['field'](_0x606a('0x8d'),'contactName');}else{_0x3e02e2['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',_0x606a('0x8e'));}if(_0x4058e8!==_0x606a('0x35')){_0x3e02e2[_0x606a('0xb')]('i.*');}_0x3e02e2[_0x606a('0xb')](_0x606a('0x8f'),'Contact.firstName');_0x3e02e2[_0x606a('0xb')](_0x606a('0x90'),_0x606a('0x91'));_0x3e02e2[_0x606a('0xb')](_0x606a('0x92'),_0x606a('0x93'));_0x3e02e2[_0x606a('0xb')](_0x606a('0x94'),'Contact.phone');_0x3e02e2['field']('c.mobile','Contact.mobile');_0x3e02e2[_0x606a('0xb')](_0x606a('0x95'),'Contact.fax');_0x3e02e2[_0x606a('0xb')]('o.fullname','Owner.fullname');_0x3e02e2[_0x606a('0xb')](_0x606a('0x96'),'Owner.internal');_0x3e02e2[_0x606a('0xb')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x4602d6[_0x606a('0x97')]){_0x3e02e2[_0x606a('0x97')](_0x4602d6[_0x606a('0x97')]);}if(_0x4602d6[_0x606a('0x98')]){_0x3e02e2[_0x606a('0x98')](_0x4602d6['offset']);}return db['sequelize']['query'](_0x3e02e2['toString'](),_0x2fa95f);})['then'](function(_0x47e1e2){_0x53e893=_0x47e1e2;var _0x230669=getUsersQuery(_0x4058e8,_0x53e893);return db[_0x606a('0x76')][_0x606a('0x77')](_0x230669[_0x606a('0x78')](),_0x2fa95f);})['then'](function(_0x4d2765){_0x2bb3b8=_['groupBy'](_0x4d2765,_0x25ad55);if(_0x4058e8==='mail'){return db[_0x606a('0x99')][_0x606a('0x9a')]({'attributes':[_0x606a('0x9b')],'raw':!![]});}})[_0x606a('0x64')](function(_0x25d51a){var _0x22e68c=_0x25d51a?_0x25d51a['enableEmailPreview']:undefined;var _0x1d6815=_0x53e893[_0x606a('0x19')](function(_0x2f2218){return updateInteraction(_0x2f2218,_0x4e28a3,_0x2bb3b8,_0x22e68c);});return Promise[_0x606a('0x9c')](_0x1d6815);});}function countFilteredInteractions(_0x5998dc,_0x4e12e5){var _0x3002a0=_0x5998dc[_0x606a('0x9d')]();_0x3002a0[_0x606a('0xb')](_0x606a('0x9e'));_0x3002a0['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x606a('0x7e'));var _0x495bad=utils[_0x606a('0x29')](_0x4e12e5);if(!_[_0x606a('0x9f')](_0x495bad)){_0x3002a0[_0x606a('0x17')](_0x606a('0xa0'),_0x495bad);}var _0x362ad1={'type':db[_0x606a('0x73')][_0x606a('0x74')][_0x606a('0x75')],'raw':!![]};return db[_0x606a('0x76')][_0x606a('0x77')](_0x3002a0[_0x606a('0x78')](),_0x362ad1);}module[_0x606a('0xa1')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x8a3c=['merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','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.id','i.createdAt','i.updatedAt','i.closedAt','i.lastMsgDirection','i.thirdDisposition','i.ContactId','i.MailAccountId','i.UserId','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','c.phone','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','TagIds','limit','offset','sequelize','toString','findOne','enableEmailPreview','clone','COUNT(*)','getSelectedTags','where','t.id\x20IN\x20?','SELECT','exports','lodash','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','agent','search','field','name','color','from','tools_tags','_interactions','u.id','u.fullname','left_join','users','u.id\x20=\x20ui.UserId','ui.','getInteractionsTables','getAccountFK','getInteractionFK','select','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','interactionsTags','it.','expr','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','escapeLIKESpecialChars','i.id\x20LIKE\x20?','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.from\x20LIKE\x20?','mail','c.email\x20LIKE\x20?','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','length','find','buildExpression','type','default','text','value','start','end','unreadMessages','read','and','Contact','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','map','tags','ids','user','UserId','body','keys','some','compact','\x20IN\x20?','createdAt','parse','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','clause','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','query','keyBy'];(function(_0x5b644e,_0x2e5e07){var _0x49c6bf=function(_0x3032d9){while(--_0x3032d9){_0x5b644e['push'](_0x5b644e['shift']());}};_0x49c6bf(++_0x2e5e07);}(_0x8a3c,0xcb));var _0xc8a3=function(_0x3a0614,_0x4b6627){_0x3a0614=_0x3a0614-0x0;var _0x12bba7=_0x8a3c[_0x3a0614];return _0x12bba7;};'use strict';var _=require(_0xc8a3('0x0'));var squel=require('squel');var as=require(_0xc8a3('0x1'));var qs=require(_0xc8a3('0x2'));var updateInteraction=require(_0xc8a3('0x3'))[_0xc8a3('0x4')];var utils=require(_0xc8a3('0x5'));var db=require(_0xc8a3('0x6'))['db'];function skipInteractionsQuery(_0x2a17d8,_0x1f4c7d,_0x5b62ee){var _0x163024=![];var _0x931874=utils['getAccountFK'](_0x2a17d8);if(_0x1f4c7d['role']===_0xc8a3('0x7')&&!_0x5b62ee[_0xc8a3('0x8')]&&!_0x5b62ee[_0x931874]){_0x163024=!![];}return _0x163024;}function getTagsQuery(){return squel['select']()[_0xc8a3('0x9')]('id')[_0xc8a3('0x9')](_0xc8a3('0xa'))['field'](_0xc8a3('0xb'))[_0xc8a3('0xc')](_0xc8a3('0xd'));}function getUsersQuery(_0x134d4f,_0x13704f){var _0x39b679=utils['getInteractionFK'](_0x134d4f);var _0x5410fc='user_has_'+_0x134d4f+_0xc8a3('0xe');var _0x105a7b=squel['select']()[_0xc8a3('0x9')](_0xc8a3('0xf'))['field'](_0xc8a3('0x10'))['field']('ui.'+_0x39b679)[_0xc8a3('0xc')](_0x5410fc,'ui')[_0xc8a3('0x11')](_0xc8a3('0x12'),'u',_0xc8a3('0x13'));if(_0x13704f['length']>0x0){_0x105a7b['where'](_0xc8a3('0x14')+_0x39b679+'\x20IN\x20?',_['map'](_0x13704f,'id'));}return _0x105a7b;}function getInteractionsQuery(_0x3feddd){var _0x124f3a=utils[_0xc8a3('0x15')](_0x3feddd);var _0x573f66=utils[_0xc8a3('0x16')](_0x3feddd);var _0x515afe=utils[_0xc8a3('0x17')](_0x3feddd);return squel[_0xc8a3('0x18')]()[_0xc8a3('0xc')](_0x124f3a[_0xc8a3('0x19')],'i')['left_join'](_0xc8a3('0x1a'),'c',_0xc8a3('0x1b'))['left_join'](_0xc8a3('0x12'),'o','o.id\x20=\x20i.UserId')['left_join'](_0x124f3a[_0xc8a3('0x1c')],'a',_0xc8a3('0x1d')+_0x573f66)[_0xc8a3('0x11')](_0x124f3a['messages'],'me',_0xc8a3('0x1e')+_0x515afe+_0xc8a3('0x1f'))['left_join'](_0x124f3a[_0xc8a3('0x20')],'it',_0xc8a3('0x21')+_0x515afe+_0xc8a3('0x1f'))['left_join'](_0xc8a3('0xd'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x2d132f={'body':squel[_0xc8a3('0x22')](),'contact':squel[_0xc8a3('0x22')](),'default':squel[_0xc8a3('0x22')](),'fields':squel['expr'](),'filter':squel[_0xc8a3('0x22')](),'read':squel[_0xc8a3('0x22')](),'tags':{'clause':squel[_0xc8a3('0x22')](),'ids':null},'user':squel[_0xc8a3('0x22')]()};return _0x2d132f;}function parseTagParameter(_0x4231f3){var _0x3e6650=squel['expr']();if(_0x4231f3){var _0x49849f=utils['getSelectedTags'](_0x4231f3);_0x49849f[_0xc8a3('0x23')](function(_0x39f6d3){_0x3e6650['or'](_0xc8a3('0x24'),'%,'+_0x39f6d3+',%');});}return _0x3e6650;}function parseReadParameter(_0xa25341){var _0x536182='';if(_0xa25341){_0x536182=_0xc8a3('0x25');if(_0xa25341==='1'){_0x536182=_0x536182[_0xc8a3('0x26')](_0xc8a3('0x27'),'=');}else{_0x536182=_0x536182[_0xc8a3('0x26')](_0xc8a3('0x27'),'>');}}return _0x536182;}function parseSearchFilter(_0x83af6b,_0x47a6f3){var _0x46a046=squel['expr']();if(_0x47a6f3){var _0x167195=_0x47a6f3[_0xc8a3('0x26')]('\x5c','\x5c\x5c')[_0xc8a3('0x26')](/'/g,'\x27\x27');var _0x5a982c=qs[_0xc8a3('0x28')](_0x167195);if(qs['isNumeric'](_0x167195)){_0x46a046['or'](_0xc8a3('0x29'),_0x5a982c+'%');if(['sms',_0xc8a3('0x2a')][_0xc8a3('0x2b')](_0x83af6b)){_0x46a046['or'](_0xc8a3('0x2c'),_0x5a982c+'%');}else if(_0x83af6b===_0xc8a3('0x2d')){_0x46a046['or']('i.fax\x20LIKE\x20?',_0x5a982c+'%');}else if(_0x83af6b==='openchannel'){_0x46a046['or'](_0xc8a3('0x2e'),_0x5a982c+'%');}}else if(_0x83af6b===_0xc8a3('0x2f')&&qs['isEmail'](_0x167195)){_0x46a046['or'](_0xc8a3('0x30'),_0x5a982c+'%');}else{if(_0x83af6b==='mail'){_0x46a046['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xc8a3('0x31')](_0x167195,!![]))['or'](_0xc8a3('0x32'),qs[_0xc8a3('0x31')](_0x167195));}else if(_0x83af6b!==_0xc8a3('0x2d')){_0x46a046['or'](_0xc8a3('0x33'),qs[_0xc8a3('0x31')](_0x167195));}_0x46a046['or'](_0xc8a3('0x34'),qs[_0xc8a3('0x31')](_0x167195,!![]),null);}}return _0x46a046;}function parseAdvancedSearchFilter(_0x5cd4ec,_0x5dbc67){var _0x349d76=getSqlClauses();var _0x989711=as['parseSearch'](_0x5cd4ec);var _0x3d0af6=_0x989711[_0xc8a3('0x35')];for(var _0x4ee1bf=0x0;_0x4ee1bf<_0x989711[_0xc8a3('0x36')][_0xc8a3('0x37')];_0x4ee1bf++){var _0x479d3f=_0x989711[_0xc8a3('0x36')][_0x4ee1bf];var _0x2147dd='i';var _0x4e8765=_[_0xc8a3('0x38')](_0x5dbc67,[_0xc8a3('0xa'),_0x479d3f[_0xc8a3('0x9')]]);if(_0x4e8765){var _0x59ffa9=as[_0xc8a3('0x39')](_0x2147dd,_0x4e8765[_0xc8a3('0x3a')],_0x479d3f);_0x349d76[_0xc8a3('0x3b')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9[_0xc8a3('0x3d')][_0xc8a3('0x3e')],_0x59ffa9['value'][_0xc8a3('0x3f')]);}else{switch(_0x479d3f[_0xc8a3('0x9')]){case _0xc8a3('0x40'):var _0x5cfab2=parseReadParameter(_0x479d3f[_0xc8a3('0x3d')]);_0x349d76[_0xc8a3('0x41')][_0xc8a3('0x42')](_0x5cfab2);break;case _0xc8a3('0x43'):if(_0x479d3f[_0xc8a3('0x44')]===_0xc8a3('0x45')){if(_0x479d3f[_0xc8a3('0x3d')][_0xc8a3('0x46')]('\x20')[_0xc8a3('0x37')]>0x1){_0x349d76[_0xc8a3('0x47')][_0x3d0af6](_0xc8a3('0x34'),qs[_0xc8a3('0x31')](_0x479d3f[_0xc8a3('0x3d')],!![]),null);}else{var _0x42029b='%'+_0x479d3f['value']+'%';_0x349d76[_0xc8a3('0x47')][_0x3d0af6](_0xc8a3('0x48'),_0x42029b,_0x42029b,_0x42029b);}}else{_0x4e8765=_['find'](_0x5dbc67,['name',_0xc8a3('0x49')]);_0x479d3f[_0xc8a3('0x9')]=_0xc8a3('0x49');_0x59ffa9=as[_0xc8a3('0x39')](_0x2147dd,_0x4e8765['type'],_0x479d3f);_0x349d76[_0xc8a3('0x47')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9[_0xc8a3('0x3d')]['start'],_0x59ffa9['value'][_0xc8a3('0x3f')]);}break;case'Tag':var _0x260ca5=_0x479d3f[_0xc8a3('0x3d')][_0xc8a3('0x46')](',')[_0xc8a3('0x4a')](function(_0x3b6429){return Number(_0x3b6429);});var _0xe10187=parseTagParameter(_0x260ca5);_0x349d76['tags']['clause'][_0xc8a3('0x42')](_0xe10187);_0x349d76[_0xc8a3('0x4b')][_0xc8a3('0x4c')]=_0x260ca5;break;case'User':if(_0x479d3f[_0xc8a3('0x44')]===_0xc8a3('0x45')){_0x349d76[_0xc8a3('0x4d')][_0x3d0af6]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x479d3f[_0xc8a3('0x3d')]+'%',null);}else{_0x4e8765=_[_0xc8a3('0x38')](_0x5dbc67,[_0xc8a3('0xa'),'UserId']);_0x479d3f['field']=_0xc8a3('0x4e');_0x59ffa9=as[_0xc8a3('0x39')](_0x2147dd,_0x4e8765[_0xc8a3('0x3a')],_0x479d3f);_0x349d76[_0xc8a3('0x4d')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9[_0xc8a3('0x3d')][_0xc8a3('0x3e')],_0x59ffa9[_0xc8a3('0x3d')][_0xc8a3('0x3f')]);}break;case _0xc8a3('0x4f'):case'plainBody':_0x59ffa9=as[_0xc8a3('0x39')]('me',null,_0x479d3f);_0x349d76[_0xc8a3('0x4f')][_0x3d0af6](_0x59ffa9[_0xc8a3('0x3c')],_0x59ffa9['value'][_0xc8a3('0x3e')],_0x59ffa9[_0xc8a3('0x3d')]['end']);break;}}}return _0x349d76;}function parseModelFields(_0x176b24,_0x3c4c35,_0x14bf77){var _0x202314=utils['getAccountFK'](_0x176b24);var _0x248898=squel[_0xc8a3('0x22')]();var _0x48a270=_(_0x3c4c35)[_0xc8a3('0x50')]()[_0xc8a3('0x4a')](function(_0x958cbb){return _[_0xc8a3('0x51')](_0x14bf77,[_0xc8a3('0xa'),_0x958cbb])?_0x958cbb:undefined;})[_0xc8a3('0x52')]()[_0xc8a3('0x3d')]();if(_0x48a270[_0xc8a3('0x37')]>0x0){_0x48a270[_0xc8a3('0x23')](function(_0x3e7579){if(_0x3e7579===_0x202314){_0x248898[_0xc8a3('0x42')]('i.'+_0x202314+_0xc8a3('0x53'),[]['concat'](_0x3c4c35[_0x3e7579]));}else if(_0x3e7579===_0xc8a3('0x54')){var _0x1d42d2=JSON['parse'](_0x3c4c35[_0x3e7579])['$gte'];var _0x5f5e18=JSON[_0xc8a3('0x55')](_0x3c4c35[_0x3e7579])['$lte'];_0x248898[_0xc8a3('0x42')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x1d42d2,_0x5f5e18);}else{if(_0x3c4c35[_0x3e7579]===_0xc8a3('0x56')){_0x248898['and']('i.'+_0x3e7579+_0xc8a3('0x57'));}else{_0x248898[_0xc8a3('0x42')]('i.'+_0x3e7579+_0xc8a3('0x58'),_0x3c4c35[_0x3e7579]);}}});}return _0x248898;}function parseQueryParameters(_0x107798,_0x44c04c,_0x34e556){var _0x1fc2e8=getSqlClauses();return Promise[_0xc8a3('0x59')]()[_0xc8a3('0x5a')](function(){return parseModelFields(_0x107798,_0x44c04c,_0x34e556);})[_0xc8a3('0x5a')](function(_0x18df54){_0x1fc2e8[_0xc8a3('0x5b')][_0xc8a3('0x42')](_0x18df54);return parseReadParameter(_0x44c04c[_0xc8a3('0x41')]);})[_0xc8a3('0x5a')](function(_0x12a22a){_0x1fc2e8[_0xc8a3('0x41')][_0xc8a3('0x42')](_0x12a22a);return parseTagParameter(_0x44c04c[_0xc8a3('0x5c')]);})[_0xc8a3('0x5a')](function(_0x317a4f){_0x1fc2e8[_0xc8a3('0x4b')][_0xc8a3('0x5d')][_0xc8a3('0x42')](_0x317a4f);return parseSearchFilter(_0x107798,_0x44c04c['filter']);})[_0xc8a3('0x5a')](function(_0x3850c3){_0x1fc2e8['filter']=_0x3850c3;return _0x1fc2e8;});}function checkAccountsRestrictions(_0x256912,_0xff7e12,_0x199160){var _0x27cfa2=utils[_0xc8a3('0x16')](_0x256912);var _0x128875='get'+_[_0xc8a3('0x5e')](_0x256912)+(_0x256912===_0xc8a3('0x5f')?_0xc8a3('0x60'):_0xc8a3('0x61'));var _0x273136=squel['expr']();return Promise[_0xc8a3('0x59')]()['then'](function(){if(_0x199160[_0xc8a3('0x8')]&&_0xff7e12['role']===_0xc8a3('0x7')){return _0xff7e12[_0x128875]({'attributes':['id'],'raw':!![]});}})[_0xc8a3('0x5a')](function(_0x2e738a){if(_0x2e738a){if(_0x2e738a[_0xc8a3('0x37')]===0x0){_0x273136[_0xc8a3('0x42')]('i.'+_0x27cfa2+'\x20IS\x20NULL');}else{_0x273136[_0xc8a3('0x42')]('i.'+_0x27cfa2+_0xc8a3('0x53'),_[_0xc8a3('0x4a')](_0x2e738a,'id'));}}else if(!_0x199160[_0x27cfa2]){_0x273136[_0xc8a3('0x42')]('i.'+_0x27cfa2+_0xc8a3('0x62'));}})[_0xc8a3('0x5a')](function(){return _0x273136;});}function getClosedOrderClause(_0xfaaf80,_0x5aacad){var _0x5eb1d1='';var _0x3c931e=['i.thirdDisposition',_0xc8a3('0x63'),_0xc8a3('0x64')];if(_0xfaaf80===_0xc8a3('0x2f')){_0x3c931e[_0xc8a3('0x65')]('i.substatus');}if(_0x5aacad['closed']==='0'&&_0xfaaf80==='mail'){_0x5eb1d1='i.substatus';}else{if(_0x5aacad[_0xc8a3('0x66')]==='1'){_0x3c931e[_0xc8a3('0x67')]();}_0x5eb1d1=_0xc8a3('0x68')+_0x3c931e[_0xc8a3('0x69')](',\x20')+')';}return _0x5eb1d1;}function getFilteredInteractions(_0x525d06,_0x3741be,_0x26e53a,_0x394164){var _0x208887=utils[_0xc8a3('0x17')](_0x525d06);var _0x3a9f84=_[_0xc8a3('0x5e')](_0x525d06)+_0xc8a3('0x6a');var _0xdc6112=[];var _0x28e604=getTagsQuery();var _0xaaebc9={'type':db[_0xc8a3('0x6b')][_0xc8a3('0x6c')]['SELECT'],'raw':!![]};var _0x56e759=[];var _0x429c46=[];return db['sequelize'][_0xc8a3('0x6d')](_0x28e604['toString'](),_0xaaebc9)['then'](function(_0x478eab){_0xdc6112=_[_0xc8a3('0x6e')](_0x478eab,'id');_0xaaebc9=_[_0xc8a3('0x6f')](_0xaaebc9,{'model':db[_0x3a9f84],'mapToModel':!![],'nest':!![]});if(_0x26e53a[_0xc8a3('0x5b')]){_0x394164[_0xc8a3('0x70')]['forEach'](function(_0x42ecb3){_0x3741be[_0xc8a3('0x9')]('i.'+_0x42ecb3);});}else{_0x3741be['field'](_0xc8a3('0x71'),_0xc8a3('0x40'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x72'),_0xc8a3('0x73'));_0x3741be['field']('a.mandatoryDisposition',_0xc8a3('0x74'));if(_0x525d06===_0xc8a3('0x2f')){_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x75'),_0xc8a3('0x76'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x77'),_0xc8a3('0x78'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x79'));_0x3741be['field'](_0xc8a3('0x7a'));_0x3741be['field'](_0xc8a3('0x7b'));_0x3741be[_0xc8a3('0x9')]('i.closed');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7c'));_0x3741be['field']('i.attach');_0x3741be['field']('i.lastMsgAt');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7d'));_0x3741be[_0xc8a3('0x9')]('i.subject');_0x3741be[_0xc8a3('0x9')]('i.disposition');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x63'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7e'));_0x3741be[_0xc8a3('0x9')]('i.substatus');_0x3741be[_0xc8a3('0x9')]('i.to');_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x7f'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x80'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x81'));}else if(_0x525d06==='openchannel'){_0x3741be[_0xc8a3('0x9')]('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',_0xc8a3('0x78'));}else{_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x82'),_0xc8a3('0x78'));}if(_0x525d06!==_0xc8a3('0x2f')){_0x3741be[_0xc8a3('0x9')]('i.*');}_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x83'),_0xc8a3('0x84'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x85'),_0xc8a3('0x86'));_0x3741be['field'](_0xc8a3('0x87'),'Contact.email');_0x3741be['field'](_0xc8a3('0x88'),'Contact.phone');_0x3741be['field']('c.mobile',_0xc8a3('0x89'));_0x3741be['field'](_0xc8a3('0x8a'),_0xc8a3('0x8b'));_0x3741be[_0xc8a3('0x9')]('o.fullname',_0xc8a3('0x8c'));_0x3741be[_0xc8a3('0x9')](_0xc8a3('0x8d'),_0xc8a3('0x8e'));_0x3741be['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0xc8a3('0x8f'));}if(_0x394164[_0xc8a3('0x90')]){_0x3741be[_0xc8a3('0x90')](_0x394164[_0xc8a3('0x90')]);}if(_0x394164[_0xc8a3('0x91')]){_0x3741be['offset'](_0x394164['offset']);}return db[_0xc8a3('0x92')][_0xc8a3('0x6d')](_0x3741be[_0xc8a3('0x93')](),_0xaaebc9);})[_0xc8a3('0x5a')](function(_0x319444){_0x56e759=_0x319444;var _0x42dd8c=getUsersQuery(_0x525d06,_0x56e759);return db[_0xc8a3('0x92')]['query'](_0x42dd8c[_0xc8a3('0x93')](),_0xaaebc9);})['then'](function(_0x4c2ca9){_0x429c46=_['groupBy'](_0x4c2ca9,_0x208887);if(_0x525d06===_0xc8a3('0x2f')){return db['Setting'][_0xc8a3('0x94')]({'attributes':[_0xc8a3('0x95')],'raw':!![]});}})['then'](function(_0x4a887d){var _0x2323ba=_0x4a887d?_0x4a887d[_0xc8a3('0x95')]:undefined;var _0x2242f0=_0x56e759[_0xc8a3('0x4a')](function(_0xd761f5){return updateInteraction(_0xd761f5,_0xdc6112,_0x429c46,_0x2323ba);});return Promise['all'](_0x2242f0);});}function countFilteredInteractions(_0x4359a0,_0x1ce813){var _0x1704ad=_0x4359a0[_0xc8a3('0x96')]();_0x1704ad[_0xc8a3('0x9')](_0xc8a3('0x97'));_0x1704ad['field'](_0xc8a3('0x71'),_0xc8a3('0x40'));var _0x25477e=utils[_0xc8a3('0x98')](_0x1ce813);if(!_['isEmpty'](_0x25477e)){_0x1704ad[_0xc8a3('0x99')](_0xc8a3('0x9a'),_0x25477e);}var _0x5d7877={'type':db[_0xc8a3('0x6b')][_0xc8a3('0x6c')][_0xc8a3('0x9b')],'raw':!![]};return db[_0xc8a3('0x92')][_0xc8a3('0x6d')](_0x1704ad[_0xc8a3('0x93')](),_0x5d7877);}module[_0xc8a3('0x9c')]={'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