// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x02e6=['i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','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','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','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','toString','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','lodash','squel','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','getAccountFK','agent','search','select','field','name','color','tools_tags','u.id','u.fullname','ui.','from','left_join','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionFK','interactions','o.id\x20=\x20i.UserId','messages','me.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','escapeLIKESpecialChars','isNumeric','sms','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','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','conditions','find','buildExpression','type','text','value','end','unreadMessages','read','and','Contact','split','contact','ContactId','start','Tag','tags','ids','user','body','plainBody','some','compact','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','resolve','then','fields','tag','clause','filter','capitalize','chat','Websites','Accounts','role','\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','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','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'];(function(_0x171a62,_0x303a59){var _0x13e4c1=function(_0x433474){while(--_0x433474){_0x171a62['push'](_0x171a62['shift']());}};_0x13e4c1(++_0x303a59);}(_0x02e6,0x180));var _0x602e=function(_0x20a714,_0x5ee64a){_0x20a714=_0x20a714-0x0;var _0x3b3f8c=_0x02e6[_0x20a714];return _0x3b3f8c;};'use strict';var _=require(_0x602e('0x0'));var squel=require(_0x602e('0x1'));var as=require('../parsers/advancedSearch');var qs=require(_0x602e('0x2'));var updateInteraction=require(_0x602e('0x3'))[_0x602e('0x4')];var utils=require(_0x602e('0x5'));var db=require(_0x602e('0x6'))['db'];function skipInteractionsQuery(_0x30119f,_0xfeccc1,_0x542b5d){var _0x510764=![];var _0x3a6f31=utils[_0x602e('0x7')](_0x30119f);if(_0xfeccc1['role']===_0x602e('0x8')&&!_0x542b5d[_0x602e('0x9')]&&!_0x542b5d[_0x3a6f31]){_0x510764=!![];}return _0x510764;}function getTagsQuery(){return squel[_0x602e('0xa')]()['field']('id')[_0x602e('0xb')](_0x602e('0xc'))[_0x602e('0xb')](_0x602e('0xd'))['from'](_0x602e('0xe'));}function getUsersQuery(_0x5b4e52,_0x11e1d2){var _0x15736f=utils['getInteractionFK'](_0x5b4e52);var _0x20d728='user_has_'+_0x5b4e52+'_interactions';var _0x515e48=squel[_0x602e('0xa')]()[_0x602e('0xb')](_0x602e('0xf'))['field'](_0x602e('0x10'))['field'](_0x602e('0x11')+_0x15736f)[_0x602e('0x12')](_0x20d728,'ui')[_0x602e('0x13')](_0x602e('0x14'),'u',_0x602e('0x15'));if(_0x11e1d2[_0x602e('0x16')]>0x0){_0x515e48[_0x602e('0x17')](_0x602e('0x11')+_0x15736f+_0x602e('0x18'),_[_0x602e('0x19')](_0x11e1d2,'id'));}return _0x515e48;}function getInteractionsQuery(_0xfb7bc0){var _0x1745ff=utils['getInteractionsTables'](_0xfb7bc0);var _0x1119a9=utils[_0x602e('0x7')](_0xfb7bc0);var _0x5572fc=utils[_0x602e('0x1a')](_0xfb7bc0);return squel[_0x602e('0xa')]()[_0x602e('0x12')](_0x1745ff[_0x602e('0x1b')],'i')[_0x602e('0x13')]('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x602e('0x13')]('users','o',_0x602e('0x1c'))[_0x602e('0x13')](_0x1745ff['accounts'],'a','a.id\x20=\x20i.'+_0x1119a9)[_0x602e('0x13')](_0x1745ff[_0x602e('0x1d')],'me',_0x602e('0x1e')+_0x5572fc+_0x602e('0x1f'))[_0x602e('0x13')](_0x1745ff[_0x602e('0x20')],'it',_0x602e('0x21')+_0x5572fc+'\x20=\x20i.id')[_0x602e('0x13')](_0x602e('0xe'),'t',_0x602e('0x22'));}function getSqlClauses(){var _0xf4d8a1={'body':squel[_0x602e('0x23')](),'contact':squel['expr'](),'default':squel['expr'](),'fields':squel[_0x602e('0x23')](),'filter':squel[_0x602e('0x23')](),'read':squel['expr'](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x602e('0x23')]()};return _0xf4d8a1;}function parseTagParameter(_0x1682a5){var _0x2b48c0=squel[_0x602e('0x23')]();if(_0x1682a5){var _0x33793f=utils[_0x602e('0x24')](_0x1682a5);_0x33793f[_0x602e('0x25')](function(_0x4a6b5f){_0x2b48c0['or'](_0x602e('0x26'),'%,'+_0x4a6b5f+',%');});}return _0x2b48c0;}function parseReadParameter(_0x5686b4){var _0x4795b1='';if(_0x5686b4){_0x4795b1='unreadMessages\x20{OPERATOR}\x200';if(_0x5686b4==='1'){_0x4795b1=_0x4795b1[_0x602e('0x27')](_0x602e('0x28'),'=');}else{_0x4795b1=_0x4795b1[_0x602e('0x27')](_0x602e('0x28'),'>');}}return _0x4795b1;}function parseSearchFilter(_0x3a6605,_0x19bb1a){var _0x44f4a8=squel['expr']();if(_0x19bb1a){var _0x55db33=_0x19bb1a[_0x602e('0x27')]('\x5c','\x5c\x5c')[_0x602e('0x27')](/'/g,'\x27\x27');var _0x5452d8=qs[_0x602e('0x29')](_0x55db33);if(qs[_0x602e('0x2a')](_0x55db33)){_0x44f4a8['or']('i.id\x20LIKE\x20?',_0x5452d8+'%');if([_0x602e('0x2b'),'whatsapp'][_0x602e('0x2c')](_0x3a6605)){_0x44f4a8['or'](_0x602e('0x2d'),_0x5452d8+'%');}else if(_0x3a6605===_0x602e('0x2e')){_0x44f4a8['or'](_0x602e('0x2f'),_0x5452d8+'%');}else if(_0x3a6605===_0x602e('0x30')){_0x44f4a8['or'](_0x602e('0x31'),_0x5452d8+'%');}}else if(_0x3a6605===_0x602e('0x32')&&qs[_0x602e('0x33')](_0x55db33)){_0x44f4a8['or'](_0x602e('0x34'),_0x5452d8+'%');}else{if(_0x3a6605===_0x602e('0x32')){_0x44f4a8['or'](_0x602e('0x35'),qs[_0x602e('0x36')](_0x55db33,!![]))['or'](_0x602e('0x37'),qs['getFullTextValue'](_0x55db33));}else if(_0x3a6605!==_0x602e('0x2e')){_0x44f4a8['or'](_0x602e('0x38'),qs[_0x602e('0x36')](_0x55db33));}_0x44f4a8['or'](_0x602e('0x39'),qs[_0x602e('0x36')](_0x55db33,!![]),null);}}return _0x44f4a8;}function parseAdvancedSearchFilter(_0xc207a0,_0x35bb3e){var _0x13e2bc=getSqlClauses();var _0x513ba8=as[_0x602e('0x3a')](_0xc207a0);var _0x30e6e7=_0x513ba8['sqlOperator'];for(var _0x4516bd=0x0;_0x4516bd<_0x513ba8['conditions'][_0x602e('0x16')];_0x4516bd++){var _0x2a30eb=_0x513ba8[_0x602e('0x3b')][_0x4516bd];var _0x1e1219='i';var _0x1d4584=_[_0x602e('0x3c')](_0x35bb3e,[_0x602e('0xc'),_0x2a30eb[_0x602e('0xb')]]);if(_0x1d4584){var _0x363d47=as[_0x602e('0x3d')](_0x1e1219,_0x1d4584[_0x602e('0x3e')],_0x2a30eb);_0x13e2bc['default'][_0x30e6e7](_0x363d47[_0x602e('0x3f')],_0x363d47['value']['start'],_0x363d47[_0x602e('0x40')][_0x602e('0x41')]);}else{switch(_0x2a30eb[_0x602e('0xb')]){case _0x602e('0x42'):var _0x19ddc1=parseReadParameter(_0x2a30eb['value']);_0x13e2bc[_0x602e('0x43')][_0x602e('0x44')](_0x19ddc1);break;case _0x602e('0x45'):if(_0x2a30eb['operator']==='$substring'){if(_0x2a30eb[_0x602e('0x40')][_0x602e('0x46')]('\x20')[_0x602e('0x16')]>0x1){_0x13e2bc[_0x602e('0x47')][_0x30e6e7](_0x602e('0x39'),qs[_0x602e('0x36')](_0x2a30eb[_0x602e('0x40')],!![]),null);}else{var _0x5deeb4='%'+_0x2a30eb[_0x602e('0x40')]+'%';_0x13e2bc[_0x602e('0x47')][_0x30e6e7]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x5deeb4,_0x5deeb4,_0x5deeb4);}}else{_0x1d4584=_['find'](_0x35bb3e,[_0x602e('0xc'),_0x602e('0x48')]);_0x2a30eb[_0x602e('0xb')]=_0x602e('0x48');_0x363d47=as[_0x602e('0x3d')](_0x1e1219,_0x1d4584[_0x602e('0x3e')],_0x2a30eb);_0x13e2bc[_0x602e('0x47')][_0x30e6e7](_0x363d47['text'],_0x363d47[_0x602e('0x40')][_0x602e('0x49')],_0x363d47[_0x602e('0x40')]['end']);}break;case _0x602e('0x4a'):var _0x59e454=_0x2a30eb['value'][_0x602e('0x46')](',')[_0x602e('0x19')](function(_0x26dda2){return Number(_0x26dda2);});var _0x5bee32=parseTagParameter(_0x59e454);_0x13e2bc[_0x602e('0x4b')]['clause'][_0x602e('0x44')](_0x5bee32);_0x13e2bc['tags'][_0x602e('0x4c')]=_0x59e454;break;case'User':if(_0x2a30eb['operator']==='$substring'){_0x13e2bc[_0x602e('0x4d')][_0x30e6e7]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x2a30eb[_0x602e('0x40')]+'%',null);}else{_0x1d4584=_[_0x602e('0x3c')](_0x35bb3e,['name','UserId']);_0x2a30eb[_0x602e('0xb')]='UserId';_0x363d47=as['buildExpression'](_0x1e1219,_0x1d4584[_0x602e('0x3e')],_0x2a30eb);_0x13e2bc[_0x602e('0x4d')][_0x30e6e7](_0x363d47[_0x602e('0x3f')],_0x363d47[_0x602e('0x40')][_0x602e('0x49')],_0x363d47[_0x602e('0x40')][_0x602e('0x41')]);}break;case _0x602e('0x4e'):case _0x602e('0x4f'):_0x363d47=as[_0x602e('0x3d')]('me',null,_0x2a30eb);_0x13e2bc[_0x602e('0x4e')][_0x30e6e7](_0x363d47['text'],_0x363d47[_0x602e('0x40')][_0x602e('0x49')],_0x363d47[_0x602e('0x40')][_0x602e('0x41')]);break;}}}return _0x13e2bc;}function parseModelFields(_0x2bee95,_0x3cb9b6,_0x56c6ae){var _0x353fea=utils[_0x602e('0x7')](_0x2bee95);var _0x371e99=squel[_0x602e('0x23')]();var _0x26b5e7=_(_0x3cb9b6)['keys']()['map'](function(_0x634bd4){return _[_0x602e('0x50')](_0x56c6ae,[_0x602e('0xc'),_0x634bd4])?_0x634bd4:undefined;})[_0x602e('0x51')]()['value']();if(_0x26b5e7[_0x602e('0x16')]>0x0){_0x26b5e7[_0x602e('0x25')](function(_0x2ad69c){if(_0x2ad69c===_0x353fea){_0x371e99['and']('i.'+_0x353fea+_0x602e('0x18'),[]['concat'](_0x3cb9b6[_0x2ad69c]));}else if(_0x2ad69c===_0x602e('0x52')){var _0x59a69e=JSON[_0x602e('0x53')](_0x3cb9b6[_0x2ad69c])[_0x602e('0x54')];var _0x3aad20=JSON['parse'](_0x3cb9b6[_0x2ad69c])['$lte'];_0x371e99[_0x602e('0x44')](_0x602e('0x55'),_0x59a69e,_0x3aad20);}else{if(_0x3cb9b6[_0x2ad69c]===_0x602e('0x56')){_0x371e99['and']('i.'+_0x2ad69c+'\x20IS\x20NULL');}else{_0x371e99[_0x602e('0x44')]('i.'+_0x2ad69c+_0x602e('0x57'),_0x3cb9b6[_0x2ad69c]);}}});}return _0x371e99;}function parseQueryParameters(_0x5eba6b,_0x4aadd2,_0x3c97fd){var _0x638ffb=getSqlClauses();return Promise[_0x602e('0x58')]()['then'](function(){return parseModelFields(_0x5eba6b,_0x4aadd2,_0x3c97fd);})[_0x602e('0x59')](function(_0x960032){_0x638ffb[_0x602e('0x5a')]['and'](_0x960032);return parseReadParameter(_0x4aadd2[_0x602e('0x43')]);})[_0x602e('0x59')](function(_0x59e954){_0x638ffb[_0x602e('0x43')][_0x602e('0x44')](_0x59e954);return parseTagParameter(_0x4aadd2[_0x602e('0x5b')]);})[_0x602e('0x59')](function(_0x50c511){_0x638ffb['tags'][_0x602e('0x5c')][_0x602e('0x44')](_0x50c511);return parseSearchFilter(_0x5eba6b,_0x4aadd2[_0x602e('0x5d')]);})[_0x602e('0x59')](function(_0x562c99){_0x638ffb[_0x602e('0x5d')]=_0x562c99;return _0x638ffb;});}function checkAccountsRestrictions(_0x527224,_0x3bc72b,_0x20c9b3){var _0x12ec74=utils[_0x602e('0x7')](_0x527224);var _0x55d7e2='get'+_[_0x602e('0x5e')](_0x527224)+(_0x527224===_0x602e('0x5f')?_0x602e('0x60'):_0x602e('0x61'));var _0x33ed84=squel[_0x602e('0x23')]();return Promise[_0x602e('0x58')]()[_0x602e('0x59')](function(){if(_0x20c9b3[_0x602e('0x9')]&&_0x3bc72b[_0x602e('0x62')]===_0x602e('0x8')){return _0x3bc72b[_0x55d7e2]({'attributes':['id'],'raw':!![]});}})[_0x602e('0x59')](function(_0x483b76){if(_0x483b76){if(_0x483b76[_0x602e('0x16')]===0x0){_0x33ed84['and']('i.'+_0x12ec74+'\x20IS\x20NULL');}else{_0x33ed84[_0x602e('0x44')]('i.'+_0x12ec74+_0x602e('0x18'),_[_0x602e('0x19')](_0x483b76,'id'));}}else if(!_0x20c9b3[_0x12ec74]){_0x33ed84[_0x602e('0x44')]('i.'+_0x12ec74+_0x602e('0x63'));}})[_0x602e('0x59')](function(){return _0x33ed84;});}function getClosedOrderClause(_0x226a3e,_0xfe67bc){var _0x287fa5='';var _0xa8c307=[_0x602e('0x64'),_0x602e('0x65'),_0x602e('0x66')];if(_0x226a3e==='mail'){_0xa8c307[_0x602e('0x67')](_0x602e('0x68'));}if(_0xfe67bc[_0x602e('0x69')]==='0'&&_0x226a3e===_0x602e('0x32')){_0x287fa5=_0x602e('0x68');}else{if(_0xfe67bc[_0x602e('0x69')]==='1'){_0xa8c307[_0x602e('0x6a')]();}_0x287fa5=_0x602e('0x6b')+_0xa8c307[_0x602e('0x6c')](',\x20')+')';}return _0x287fa5;}function getFilteredInteractions(_0x358573,_0x5c1541,_0x24249a,_0x3691f0){var _0x5e6a81=utils[_0x602e('0x1a')](_0x358573);var _0xc400b2=_[_0x602e('0x5e')](_0x358573)+_0x602e('0x6d');var _0x3a3f8a=[];var _0x14bea6=getTagsQuery();var _0x10149c={'type':db[_0x602e('0x6e')][_0x602e('0x6f')][_0x602e('0x70')],'raw':!![]};var _0x5012e8=[];var _0x444d3c=[];return db[_0x602e('0x71')][_0x602e('0x72')](_0x14bea6['toString'](),_0x10149c)['then'](function(_0x2177f3){_0x3a3f8a=_[_0x602e('0x73')](_0x2177f3,'id');_0x10149c=_[_0x602e('0x74')](_0x10149c,{'model':db[_0xc400b2],'mapToModel':!![],'nest':!![]});if(_0x24249a[_0x602e('0x5a')]){_0x3691f0[_0x602e('0x75')]['forEach'](function(_0x125b93){_0x5c1541[_0x602e('0xb')]('i.'+_0x125b93);});}else{_0x5c1541[_0x602e('0xb')](_0x602e('0x76'),'unreadMessages');_0x5c1541[_0x602e('0xb')](_0x602e('0x77'),_0x602e('0x78'));_0x5c1541[_0x602e('0xb')](_0x602e('0x79'),_0x602e('0x7a'));if(_0x358573===_0x602e('0x32')){_0x5c1541[_0x602e('0xb')]('a.email',_0x602e('0x7b'));_0x5c1541[_0x602e('0xb')](_0x602e('0x7c'),_0x602e('0x7d'));_0x5c1541[_0x602e('0xb')](_0x602e('0x7e'));_0x5c1541['field'](_0x602e('0x7f'));_0x5c1541[_0x602e('0xb')](_0x602e('0x80'));_0x5c1541[_0x602e('0xb')](_0x602e('0x81'));_0x5c1541[_0x602e('0xb')](_0x602e('0x82'));_0x5c1541[_0x602e('0xb')](_0x602e('0x83'));_0x5c1541[_0x602e('0xb')](_0x602e('0x84'));_0x5c1541[_0x602e('0xb')](_0x602e('0x85'));_0x5c1541['field']('i.subject');_0x5c1541[_0x602e('0xb')]('i.disposition');_0x5c1541['field']('i.secondDisposition');_0x5c1541[_0x602e('0xb')](_0x602e('0x64'));_0x5c1541[_0x602e('0xb')](_0x602e('0x68'));_0x5c1541['field'](_0x602e('0x86'));_0x5c1541['field'](_0x602e('0x87'));_0x5c1541[_0x602e('0xb')](_0x602e('0x88'));_0x5c1541[_0x602e('0xb')](_0x602e('0x89'));}else if(_0x358573===_0x602e('0x30')){_0x5c1541[_0x602e('0xb')](_0x602e('0x8a'),_0x602e('0x7d'));}else{_0x5c1541['field'](_0x602e('0x8b'),_0x602e('0x7d'));}if(_0x358573!==_0x602e('0x32')){_0x5c1541[_0x602e('0xb')](_0x602e('0x8c'));}_0x5c1541[_0x602e('0xb')](_0x602e('0x8d'),_0x602e('0x8e'));_0x5c1541[_0x602e('0xb')](_0x602e('0x8f'),_0x602e('0x90'));_0x5c1541[_0x602e('0xb')](_0x602e('0x91'),_0x602e('0x92'));_0x5c1541['field'](_0x602e('0x93'),_0x602e('0x94'));_0x5c1541['field'](_0x602e('0x95'),_0x602e('0x96'));_0x5c1541[_0x602e('0xb')](_0x602e('0x97'),_0x602e('0x98'));_0x5c1541['field']('o.fullname',_0x602e('0x99'));_0x5c1541[_0x602e('0xb')](_0x602e('0x9a'),'Owner.internal');_0x5c1541[_0x602e('0xb')](_0x602e('0x9b'),_0x602e('0x9c'));}if(_0x3691f0['limit']){_0x5c1541['limit'](_0x3691f0[_0x602e('0x9d')]);}if(_0x3691f0[_0x602e('0x9e')]){_0x5c1541['offset'](_0x3691f0[_0x602e('0x9e')]);}return db[_0x602e('0x71')]['query'](_0x5c1541[_0x602e('0x9f')](),_0x10149c);})[_0x602e('0x59')](function(_0x446616){_0x5012e8=_0x446616;var _0x511666=getUsersQuery(_0x358573,_0x5012e8);return db[_0x602e('0x71')]['query'](_0x511666[_0x602e('0x9f')](),_0x10149c);})['then'](function(_0xb336b6){_0x444d3c=_[_0x602e('0xa0')](_0xb336b6,_0x5e6a81);if(_0x358573===_0x602e('0x32')){return db[_0x602e('0xa1')][_0x602e('0xa2')]({'attributes':['enableEmailPreview'],'raw':!![]});}})['then'](function(_0x593285){var _0x1a51bc=_0x593285?_0x593285[_0x602e('0xa3')]:undefined;var _0x2891d6=_0x5012e8[_0x602e('0x19')](function(_0x1c2456){return updateInteraction(_0x1c2456,_0x3a3f8a,_0x444d3c,_0x1a51bc);});return Promise[_0x602e('0xa4')](_0x2891d6);});}function countFilteredInteractions(_0x464e0d,_0x2e249b){var _0x3df745=_0x464e0d[_0x602e('0xa5')]();_0x3df745[_0x602e('0xb')](_0x602e('0xa6'));_0x3df745[_0x602e('0xb')](_0x602e('0x76'),_0x602e('0x42'));var _0x4051e9=utils[_0x602e('0x24')](_0x2e249b);if(!_[_0x602e('0xa7')](_0x4051e9)){_0x3df745[_0x602e('0x17')](_0x602e('0xa8'),_0x4051e9);}var _0x405fa9={'type':db[_0x602e('0x6e')][_0x602e('0x6f')][_0x602e('0x70')],'raw':!![]};return db['sequelize'][_0x602e('0x72')](_0x3df745[_0x602e('0x9f')](),_0x405fa9);}module[_0x602e('0xa9')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x105c=['c.firstName','Contact.firstName','c.lastName','Contact.lastName','Contact.email','Contact.phone','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','TagIds','limit','offset','query','groupBy','findOne','enableEmailPreview','t.id\x20IN\x20?','exports','lodash','../parsers/advancedSearch','./utils','../../mysqldb','getAccountFK','role','agent','search','select','field','name','color','from','tools_tags','user_has_','u.id','u.fullname','ui.','left_join','length','\x20IN\x20?','map','getInteractionsTables','getInteractionFK','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','a.id\x20=\x20i.','messages','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','{OPERATOR}','replace','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','includes','i.phone\x20LIKE\x20?','i.from\x20LIKE\x20?','c.email\x20LIKE\x20?','mail','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)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','buildExpression','type','default','start','value','unreadMessages','read','and','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','find','ContactId','text','end','split','clause','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','keys','some','compact','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','then','fields','capitalize','chat','Accounts','resolve','\x20IS\x20NOT\x20NULL','i.thirdDisposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','Interaction','Sequelize','QueryTypes','SELECT','sequelize','toString','keyBy','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.email','contactName','i.id','i.createdAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','i.disposition','i.secondDisposition','i.to','i.ContactId','i.MailAccountId','i.UserId','openchannel','i.*'];(function(_0x391a6c,_0x3c7945){var _0x2a60b6=function(_0x213307){while(--_0x213307){_0x391a6c['push'](_0x391a6c['shift']());}};_0x2a60b6(++_0x3c7945);}(_0x105c,0x1e6));var _0xc105=function(_0x1e6659,_0x1f860c){_0x1e6659=_0x1e6659-0x0;var _0x4d16e4=_0x105c[_0x1e6659];return _0x4d16e4;};'use strict';var _=require(_0xc105('0x0'));var squel=require('squel');var as=require(_0xc105('0x1'));var qs=require('../parsers/qs');var updateInteraction=require('./update-interaction')['updateInteraction'];var utils=require(_0xc105('0x2'));var db=require(_0xc105('0x3'))['db'];function skipInteractionsQuery(_0x1cca98,_0x4e2f92,_0x991594){var _0x4d386a=![];var _0x121db1=utils[_0xc105('0x4')](_0x1cca98);if(_0x4e2f92[_0xc105('0x5')]===_0xc105('0x6')&&!_0x991594[_0xc105('0x7')]&&!_0x991594[_0x121db1]){_0x4d386a=!![];}return _0x4d386a;}function getTagsQuery(){return squel[_0xc105('0x8')]()['field']('id')[_0xc105('0x9')](_0xc105('0xa'))[_0xc105('0x9')](_0xc105('0xb'))[_0xc105('0xc')](_0xc105('0xd'));}function getUsersQuery(_0x5c1256,_0x23cda5){var _0x14b8de=utils['getInteractionFK'](_0x5c1256);var _0x44203d=_0xc105('0xe')+_0x5c1256+'_interactions';var _0x3f2c41=squel[_0xc105('0x8')]()['field'](_0xc105('0xf'))['field'](_0xc105('0x10'))[_0xc105('0x9')](_0xc105('0x11')+_0x14b8de)[_0xc105('0xc')](_0x44203d,'ui')[_0xc105('0x12')]('users','u','u.id\x20=\x20ui.UserId');if(_0x23cda5[_0xc105('0x13')]>0x0){_0x3f2c41['where'](_0xc105('0x11')+_0x14b8de+_0xc105('0x14'),_[_0xc105('0x15')](_0x23cda5,'id'));}return _0x3f2c41;}function getInteractionsQuery(_0x355ba2){var _0x303d17=utils[_0xc105('0x16')](_0x355ba2);var _0xc6840e=utils[_0xc105('0x4')](_0x355ba2);var _0x1f7909=utils[_0xc105('0x17')](_0x355ba2);return squel[_0xc105('0x8')]()['from'](_0x303d17['interactions'],'i')[_0xc105('0x12')](_0xc105('0x18'),'c',_0xc105('0x19'))[_0xc105('0x12')](_0xc105('0x1a'),'o',_0xc105('0x1b'))[_0xc105('0x12')](_0x303d17['accounts'],'a',_0xc105('0x1c')+_0xc6840e)[_0xc105('0x12')](_0x303d17[_0xc105('0x1d')],'me','me.'+_0x1f7909+_0xc105('0x1e'))['left_join'](_0x303d17[_0xc105('0x1f')],'it',_0xc105('0x20')+_0x1f7909+_0xc105('0x1e'))[_0xc105('0x12')](_0xc105('0xd'),'t',_0xc105('0x21'));}function getSqlClauses(){var _0x42ff49={'body':squel[_0xc105('0x22')](),'contact':squel[_0xc105('0x22')](),'default':squel['expr'](),'fields':squel[_0xc105('0x22')](),'filter':squel[_0xc105('0x22')](),'read':squel['expr'](),'tags':{'clause':squel[_0xc105('0x22')](),'ids':null},'user':squel[_0xc105('0x22')]()};return _0x42ff49;}function parseTagParameter(_0x1dcbc0){var _0x144339=squel[_0xc105('0x22')]();if(_0x1dcbc0){var _0x457ba1=utils[_0xc105('0x23')](_0x1dcbc0);_0x457ba1[_0xc105('0x24')](function(_0x43f33d){_0x144339['or'](_0xc105('0x25'),'%,'+_0x43f33d+',%');});}return _0x144339;}function parseReadParameter(_0xd47f1d){var _0x299c06='';if(_0xd47f1d){_0x299c06='unreadMessages\x20{OPERATOR}\x200';if(_0xd47f1d==='1'){_0x299c06=_0x299c06['replace'](_0xc105('0x26'),'=');}else{_0x299c06=_0x299c06[_0xc105('0x27')]('{OPERATOR}','>');}}return _0x299c06;}function parseSearchFilter(_0x12e77f,_0x2fcd98){var _0x2aadc0=squel['expr']();if(_0x2fcd98){var _0x2a014a=_0x2fcd98[_0xc105('0x27')]('\x5c','\x5c\x5c')[_0xc105('0x27')](/'/g,'\x27\x27');var _0x27b373=qs[_0xc105('0x28')](_0x2a014a);if(qs[_0xc105('0x29')](_0x2a014a)){_0x2aadc0['or'](_0xc105('0x2a'),_0x27b373+'%');if([_0xc105('0x2b'),_0xc105('0x2c')][_0xc105('0x2d')](_0x12e77f)){_0x2aadc0['or'](_0xc105('0x2e'),_0x27b373+'%');}else if(_0x12e77f==='fax'){_0x2aadc0['or']('i.fax\x20LIKE\x20?',_0x27b373+'%');}else if(_0x12e77f==='openchannel'){_0x2aadc0['or'](_0xc105('0x2f'),_0x27b373+'%');}}else if(_0x12e77f==='mail'&&qs['isEmail'](_0x2a014a)){_0x2aadc0['or'](_0xc105('0x30'),_0x27b373+'%');}else{if(_0x12e77f===_0xc105('0x31')){_0x2aadc0['or'](_0xc105('0x32'),qs[_0xc105('0x33')](_0x2a014a,!![]))['or'](_0xc105('0x34'),qs[_0xc105('0x33')](_0x2a014a));}else if(_0x12e77f!==_0xc105('0x35')){_0x2aadc0['or'](_0xc105('0x36'),qs[_0xc105('0x33')](_0x2a014a));}_0x2aadc0['or'](_0xc105('0x37'),qs[_0xc105('0x33')](_0x2a014a,!![]),null);}}return _0x2aadc0;}function parseAdvancedSearchFilter(_0x1122e7,_0x3971e5){var _0x283050=getSqlClauses();var _0x2c3d5e=as[_0xc105('0x38')](_0x1122e7);var _0x44bf4d=_0x2c3d5e[_0xc105('0x39')];for(var _0x303784=0x0;_0x303784<_0x2c3d5e[_0xc105('0x3a')][_0xc105('0x13')];_0x303784++){var _0x3bf87a=_0x2c3d5e[_0xc105('0x3a')][_0x303784];var _0x59c958='i';var _0x4e11dc=_['find'](_0x3971e5,[_0xc105('0xa'),_0x3bf87a[_0xc105('0x9')]]);if(_0x4e11dc){var _0x2633e4=as[_0xc105('0x3b')](_0x59c958,_0x4e11dc[_0xc105('0x3c')],_0x3bf87a);_0x283050[_0xc105('0x3d')][_0x44bf4d](_0x2633e4['text'],_0x2633e4['value'][_0xc105('0x3e')],_0x2633e4[_0xc105('0x3f')]['end']);}else{switch(_0x3bf87a[_0xc105('0x9')]){case _0xc105('0x40'):var _0x2b2397=parseReadParameter(_0x3bf87a[_0xc105('0x3f')]);_0x283050[_0xc105('0x41')][_0xc105('0x42')](_0x2b2397);break;case'Contact':if(_0x3bf87a[_0xc105('0x43')]===_0xc105('0x44')){if(_0x3bf87a['value']['split']('\x20')[_0xc105('0x13')]>0x1){_0x283050['contact'][_0x44bf4d](_0xc105('0x37'),qs['getFullTextValue'](_0x3bf87a[_0xc105('0x3f')],!![]),null);}else{var _0x5afe1c='%'+_0x3bf87a[_0xc105('0x3f')]+'%';_0x283050[_0xc105('0x45')][_0x44bf4d](_0xc105('0x46'),_0x5afe1c,_0x5afe1c,_0x5afe1c);}}else{_0x4e11dc=_[_0xc105('0x47')](_0x3971e5,[_0xc105('0xa'),_0xc105('0x48')]);_0x3bf87a['field']=_0xc105('0x48');_0x2633e4=as[_0xc105('0x3b')](_0x59c958,_0x4e11dc[_0xc105('0x3c')],_0x3bf87a);_0x283050[_0xc105('0x45')][_0x44bf4d](_0x2633e4[_0xc105('0x49')],_0x2633e4[_0xc105('0x3f')][_0xc105('0x3e')],_0x2633e4['value'][_0xc105('0x4a')]);}break;case'Tag':var _0x2e4f76=_0x3bf87a['value'][_0xc105('0x4b')](',')[_0xc105('0x15')](function(_0x27c4f6){return Number(_0x27c4f6);});var _0x45254e=parseTagParameter(_0x2e4f76);_0x283050['tags'][_0xc105('0x4c')][_0xc105('0x42')](_0x45254e);_0x283050['tags']['ids']=_0x2e4f76;break;case _0xc105('0x4d'):if(_0x3bf87a[_0xc105('0x43')]===_0xc105('0x44')){_0x283050[_0xc105('0x4e')][_0x44bf4d](_0xc105('0x4f'),'%'+_0x3bf87a['value']+'%',null);}else{_0x4e11dc=_[_0xc105('0x47')](_0x3971e5,['name','UserId']);_0x3bf87a[_0xc105('0x9')]=_0xc105('0x50');_0x2633e4=as[_0xc105('0x3b')](_0x59c958,_0x4e11dc[_0xc105('0x3c')],_0x3bf87a);_0x283050['user'][_0x44bf4d](_0x2633e4[_0xc105('0x49')],_0x2633e4[_0xc105('0x3f')][_0xc105('0x3e')],_0x2633e4[_0xc105('0x3f')][_0xc105('0x4a')]);}break;case _0xc105('0x51'):case'plainBody':_0x2633e4=as[_0xc105('0x3b')]('me',null,_0x3bf87a);_0x283050[_0xc105('0x51')][_0x44bf4d](_0x2633e4[_0xc105('0x49')],_0x2633e4[_0xc105('0x3f')]['start'],_0x2633e4[_0xc105('0x3f')]['end']);break;}}}return _0x283050;}function parseModelFields(_0x3c59c5,_0x2af247,_0x37447a){var _0x12d79f=utils[_0xc105('0x4')](_0x3c59c5);var _0x1678de=squel[_0xc105('0x22')]();var _0x4c8c2e=_(_0x2af247)[_0xc105('0x52')]()[_0xc105('0x15')](function(_0x1b2b6d){return _[_0xc105('0x53')](_0x37447a,[_0xc105('0xa'),_0x1b2b6d])?_0x1b2b6d:undefined;})[_0xc105('0x54')]()[_0xc105('0x3f')]();if(_0x4c8c2e[_0xc105('0x13')]>0x0){_0x4c8c2e['forEach'](function(_0x5876e3){if(_0x5876e3===_0x12d79f){_0x1678de['and']('i.'+_0x12d79f+_0xc105('0x14'),[][_0xc105('0x55')](_0x2af247[_0x5876e3]));}else if(_0x5876e3===_0xc105('0x56')){var _0x37d89b=JSON[_0xc105('0x57')](_0x2af247[_0x5876e3])[_0xc105('0x58')];var _0xcc78dd=JSON['parse'](_0x2af247[_0x5876e3])[_0xc105('0x59')];_0x1678de['and'](_0xc105('0x5a'),_0x37d89b,_0xcc78dd);}else{if(_0x2af247[_0x5876e3]===_0xc105('0x5b')){_0x1678de['and']('i.'+_0x5876e3+_0xc105('0x5c'));}else{_0x1678de[_0xc105('0x42')]('i.'+_0x5876e3+'\x20=\x20?',_0x2af247[_0x5876e3]);}}});}return _0x1678de;}function parseQueryParameters(_0x3b60bc,_0x38e580,_0x5c9499){var _0x2606df=getSqlClauses();return Promise['resolve']()[_0xc105('0x5d')](function(){return parseModelFields(_0x3b60bc,_0x38e580,_0x5c9499);})[_0xc105('0x5d')](function(_0x3b6bc3){_0x2606df[_0xc105('0x5e')]['and'](_0x3b6bc3);return parseReadParameter(_0x38e580[_0xc105('0x41')]);})[_0xc105('0x5d')](function(_0x2d837a){_0x2606df[_0xc105('0x41')][_0xc105('0x42')](_0x2d837a);return parseTagParameter(_0x38e580['tag']);})['then'](function(_0x47291e){_0x2606df['tags'][_0xc105('0x4c')]['and'](_0x47291e);return parseSearchFilter(_0x3b60bc,_0x38e580['filter']);})[_0xc105('0x5d')](function(_0x513a9b){_0x2606df['filter']=_0x513a9b;return _0x2606df;});}function checkAccountsRestrictions(_0x447475,_0x3ff6a6,_0x58f559){var _0x72fe6b=utils[_0xc105('0x4')](_0x447475);var _0xc7afc5='get'+_[_0xc105('0x5f')](_0x447475)+(_0x447475===_0xc105('0x60')?'Websites':_0xc105('0x61'));var _0x158985=squel[_0xc105('0x22')]();return Promise[_0xc105('0x62')]()[_0xc105('0x5d')](function(){if(_0x58f559[_0xc105('0x7')]&&_0x3ff6a6[_0xc105('0x5')]===_0xc105('0x6')){return _0x3ff6a6[_0xc7afc5]({'attributes':['id'],'raw':!![]});}})[_0xc105('0x5d')](function(_0x3088fd){if(_0x3088fd){if(_0x3088fd[_0xc105('0x13')]===0x0){_0x158985[_0xc105('0x42')]('i.'+_0x72fe6b+_0xc105('0x5c'));}else{_0x158985[_0xc105('0x42')]('i.'+_0x72fe6b+_0xc105('0x14'),_[_0xc105('0x15')](_0x3088fd,'id'));}}else if(!_0x58f559[_0x72fe6b]){_0x158985[_0xc105('0x42')]('i.'+_0x72fe6b+_0xc105('0x63'));}})[_0xc105('0x5d')](function(){return _0x158985;});}function getClosedOrderClause(_0x6bf83c,_0x32e275){var _0x3091d5='';var _0x4e7060=[_0xc105('0x64'),'i.secondDisposition','i.disposition'];if(_0x6bf83c==='mail'){_0x4e7060[_0xc105('0x65')](_0xc105('0x66'));}if(_0x32e275[_0xc105('0x67')]==='0'&&_0x6bf83c===_0xc105('0x31')){_0x3091d5=_0xc105('0x66');}else{if(_0x32e275['closed']==='1'){_0x4e7060[_0xc105('0x68')]();}_0x3091d5=_0xc105('0x69')+_0x4e7060['join'](',\x20')+')';}return _0x3091d5;}function getFilteredInteractions(_0x1f5ba2,_0x2884f6,_0xa3159d,_0x1ad029){var _0x1d8c06=utils[_0xc105('0x17')](_0x1f5ba2);var _0x42a355=_[_0xc105('0x5f')](_0x1f5ba2)+_0xc105('0x6a');var _0x5a5a4a=[];var _0x474471=getTagsQuery();var _0x2ae1b9={'type':db[_0xc105('0x6b')][_0xc105('0x6c')][_0xc105('0x6d')],'raw':!![]};var _0x228cf4=[];var _0x588b9c=[];return db[_0xc105('0x6e')]['query'](_0x474471[_0xc105('0x6f')](),_0x2ae1b9)[_0xc105('0x5d')](function(_0x3ff4ad){_0x5a5a4a=_[_0xc105('0x70')](_0x3ff4ad,'id');_0x2ae1b9=_['merge'](_0x2ae1b9,{'model':db[_0x42a355],'mapToModel':!![],'nest':!![]});if(_0xa3159d[_0xc105('0x5e')]){_0x1ad029[_0xc105('0x71')][_0xc105('0x24')](function(_0x1f18f4){_0x2884f6['field']('i.'+_0x1f18f4);});}else{_0x2884f6[_0xc105('0x9')](_0xc105('0x72'),_0xc105('0x40'));_0x2884f6[_0xc105('0x9')](_0xc105('0x73'),_0xc105('0x74'));_0x2884f6[_0xc105('0x9')](_0xc105('0x75'),'Account.mandatoryDisposition');if(_0x1f5ba2===_0xc105('0x31')){_0x2884f6['field']('a.email',_0xc105('0x76'));_0x2884f6[_0xc105('0x9')]('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',_0xc105('0x77'));_0x2884f6[_0xc105('0x9')](_0xc105('0x78'));_0x2884f6[_0xc105('0x9')](_0xc105('0x79'));_0x2884f6['field']('i.updatedAt');_0x2884f6['field'](_0xc105('0x7a'));_0x2884f6['field'](_0xc105('0x7b'));_0x2884f6['field'](_0xc105('0x7c'));_0x2884f6[_0xc105('0x9')]('i.lastMsgAt');_0x2884f6[_0xc105('0x9')](_0xc105('0x7d'));_0x2884f6[_0xc105('0x9')]('i.subject');_0x2884f6[_0xc105('0x9')](_0xc105('0x7e'));_0x2884f6[_0xc105('0x9')](_0xc105('0x7f'));_0x2884f6[_0xc105('0x9')](_0xc105('0x64'));_0x2884f6[_0xc105('0x9')](_0xc105('0x66'));_0x2884f6[_0xc105('0x9')](_0xc105('0x80'));_0x2884f6[_0xc105('0x9')](_0xc105('0x81'));_0x2884f6[_0xc105('0x9')](_0xc105('0x82'));_0x2884f6[_0xc105('0x9')](_0xc105('0x83'));}else if(_0x1f5ba2===_0xc105('0x84')){_0x2884f6[_0xc105('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',_0xc105('0x77'));}else{_0x2884f6['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',_0xc105('0x77'));}if(_0x1f5ba2!==_0xc105('0x31')){_0x2884f6[_0xc105('0x9')](_0xc105('0x85'));}_0x2884f6[_0xc105('0x9')](_0xc105('0x86'),_0xc105('0x87'));_0x2884f6[_0xc105('0x9')](_0xc105('0x88'),_0xc105('0x89'));_0x2884f6[_0xc105('0x9')]('c.email',_0xc105('0x8a'));_0x2884f6[_0xc105('0x9')]('c.phone',_0xc105('0x8b'));_0x2884f6[_0xc105('0x9')]('c.mobile',_0xc105('0x8c'));_0x2884f6[_0xc105('0x9')](_0xc105('0x8d'),_0xc105('0x8e'));_0x2884f6[_0xc105('0x9')](_0xc105('0x8f'),_0xc105('0x90'));_0x2884f6[_0xc105('0x9')](_0xc105('0x91'),'Owner.internal');_0x2884f6['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0xc105('0x92'));}if(_0x1ad029['limit']){_0x2884f6[_0xc105('0x93')](_0x1ad029[_0xc105('0x93')]);}if(_0x1ad029[_0xc105('0x94')]){_0x2884f6[_0xc105('0x94')](_0x1ad029[_0xc105('0x94')]);}return db['sequelize'][_0xc105('0x95')](_0x2884f6[_0xc105('0x6f')](),_0x2ae1b9);})[_0xc105('0x5d')](function(_0x2e0e0b){_0x228cf4=_0x2e0e0b;var _0x48b5c4=getUsersQuery(_0x1f5ba2,_0x228cf4);return db['sequelize'][_0xc105('0x95')](_0x48b5c4[_0xc105('0x6f')](),_0x2ae1b9);})['then'](function(_0xd32f05){_0x588b9c=_[_0xc105('0x96')](_0xd32f05,_0x1d8c06);if(_0x1f5ba2==='mail'){return db['Setting'][_0xc105('0x97')]({'attributes':[_0xc105('0x98')],'raw':!![]});}})['then'](function(_0x4bee97){var _0x16fa9b=_0x4bee97?_0x4bee97[_0xc105('0x98')]:undefined;var _0x38e422=_0x228cf4[_0xc105('0x15')](function(_0x4e9b07){return updateInteraction(_0x4e9b07,_0x5a5a4a,_0x588b9c,_0x16fa9b);});return Promise['all'](_0x38e422);});}function countFilteredInteractions(_0x227dd,_0x9044fd){var _0x585a64=_0x227dd['clone']();_0x585a64[_0xc105('0x9')]('COUNT(*)');_0x585a64[_0xc105('0x9')](_0xc105('0x72'),_0xc105('0x40'));var _0x597bc1=utils[_0xc105('0x23')](_0x9044fd);if(!_['isEmpty'](_0x597bc1)){_0x585a64['where'](_0xc105('0x99'),_0x597bc1);}var _0x34136b={'type':db[_0xc105('0x6b')]['QueryTypes'][_0xc105('0x6d')],'raw':!![]};return db['sequelize'][_0xc105('0x95')](_0x585a64['toString'](),_0x34136b);}module[_0xc105('0x9a')]={'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