// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc98f=['$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','Tag','tags','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','buildExpression','text','body','keys','some','concat','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','read','clause','filter','capitalize','chat','Accounts','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','i.substatus','closed','shift','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.subject','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','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','c.lastName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','Contact.mobile','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','groupBy','Setting','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','exports','../parsers/advancedSearch','../parsers/qs','updateInteraction','getAccountFK','role','search','select','field','name','getInteractionFK','_interactions','u.id','u.fullname','from','left_join','users','length','where','ui.','\x20IN\x20?','map','interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','interactionsTags','\x20=\x20i.id','tools_tags','expr','getSelectedTags','forEach','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','sms','whatsapp','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','i.from\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','find','type','value','start','end','unreadMessages','and','operator'];(function(_0xd1e166,_0xe8fc79){var _0x4a7544=function(_0x36403b){while(--_0x36403b){_0xd1e166['push'](_0xd1e166['shift']());}};_0x4a7544(++_0xe8fc79);}(_0xc98f,0x189));var _0xfc98=function(_0x427345,_0x4aae84){_0x427345=_0x427345-0x0;var _0x36575a=_0xc98f[_0x427345];return _0x36575a;};'use strict';var _=require('lodash');var squel=require('squel');var as=require(_0xfc98('0x0'));var qs=require(_0xfc98('0x1'));var updateInteraction=require('./update-interaction')[_0xfc98('0x2')];var utils=require('./utils');var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0xe48bf2,_0x271b9f,_0x2331b3){var _0x1b5411=![];var _0x499c17=utils[_0xfc98('0x3')](_0xe48bf2);if(_0x271b9f[_0xfc98('0x4')]==='agent'&&!_0x2331b3[_0xfc98('0x5')]&&!_0x2331b3[_0x499c17]){_0x1b5411=!![];}return _0x1b5411;}function getTagsQuery(){return squel[_0xfc98('0x6')]()['field']('id')[_0xfc98('0x7')](_0xfc98('0x8'))['field']('color')['from']('tools_tags');}function getUsersQuery(_0x5d5e8,_0x8c4c71){var _0x3c80ef=utils[_0xfc98('0x9')](_0x5d5e8);var _0x30ec6b='user_has_'+_0x5d5e8+_0xfc98('0xa');var _0x553bf3=squel[_0xfc98('0x6')]()[_0xfc98('0x7')](_0xfc98('0xb'))[_0xfc98('0x7')](_0xfc98('0xc'))[_0xfc98('0x7')]('ui.'+_0x3c80ef)[_0xfc98('0xd')](_0x30ec6b,'ui')[_0xfc98('0xe')](_0xfc98('0xf'),'u','u.id\x20=\x20ui.UserId');if(_0x8c4c71[_0xfc98('0x10')]>0x0){_0x553bf3[_0xfc98('0x11')](_0xfc98('0x12')+_0x3c80ef+_0xfc98('0x13'),_[_0xfc98('0x14')](_0x8c4c71,'id'));}return _0x553bf3;}function getInteractionsQuery(_0x35f218){var _0xd7500d=utils['getInteractionsTables'](_0x35f218);var _0x2c2912=utils['getAccountFK'](_0x35f218);var _0x2b9a47=utils[_0xfc98('0x9')](_0x35f218);return squel[_0xfc98('0x6')]()['from'](_0xd7500d[_0xfc98('0x15')],'i')[_0xfc98('0xe')]('cm_contacts','c',_0xfc98('0x16'))[_0xfc98('0xe')](_0xfc98('0xf'),'o',_0xfc98('0x17'))[_0xfc98('0xe')](_0xd7500d[_0xfc98('0x18')],'a',_0xfc98('0x19')+_0x2c2912)[_0xfc98('0xe')](_0xd7500d[_0xfc98('0x1a')],'me','me.'+_0x2b9a47+'\x20=\x20i.id')['left_join'](_0xd7500d[_0xfc98('0x1b')],'it','it.'+_0x2b9a47+_0xfc98('0x1c'))[_0xfc98('0xe')](_0xfc98('0x1d'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x53a7cd={'body':squel[_0xfc98('0x1e')](),'contact':squel[_0xfc98('0x1e')](),'default':squel[_0xfc98('0x1e')](),'fields':squel['expr'](),'filter':squel['expr'](),'read':squel['expr'](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0xfc98('0x1e')]()};return _0x53a7cd;}function parseTagParameter(_0xa3636){var _0x512ba0=squel[_0xfc98('0x1e')]();if(_0xa3636){var _0x280200=utils[_0xfc98('0x1f')](_0xa3636);_0x280200[_0xfc98('0x20')](function(_0x4af428){_0x512ba0['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x4af428+',%');});}return _0x512ba0;}function parseReadParameter(_0x274096){var _0x17525d='';if(_0x274096){_0x17525d=_0xfc98('0x21');if(_0x274096==='1'){_0x17525d=_0x17525d[_0xfc98('0x22')](_0xfc98('0x23'),'=');}else{_0x17525d=_0x17525d[_0xfc98('0x22')](_0xfc98('0x23'),'>');}}return _0x17525d;}function parseSearchFilter(_0x46c2b0,_0x8b2d1a){var _0x4752f9=squel[_0xfc98('0x1e')]();if(_0x8b2d1a){var _0x22f5ef=_0x8b2d1a[_0xfc98('0x22')]('\x5c','\x5c\x5c')[_0xfc98('0x22')](/'/g,'\x27\x27');if(qs[_0xfc98('0x24')](_0x22f5ef)){_0x4752f9['or']('i.id\x20LIKE\x20?',_0x22f5ef+'%');if([_0xfc98('0x25'),_0xfc98('0x26')][_0xfc98('0x27')](_0x46c2b0)){_0x4752f9['or'](_0xfc98('0x28'),_0x22f5ef+'%');}else if(_0x46c2b0===_0xfc98('0x29')){_0x4752f9['or'](_0xfc98('0x2a'),_0x22f5ef+'%');}else if(_0x46c2b0==='openchannel'){_0x4752f9['or'](_0xfc98('0x2b'),_0x22f5ef+'%');}}else if(_0x46c2b0==='mail'&&qs[_0xfc98('0x2c')](_0x22f5ef)){_0x4752f9['or'](_0xfc98('0x2d'),_0x22f5ef+'%');}else{if(_0x46c2b0===_0xfc98('0x2e')){_0x4752f9['or'](_0xfc98('0x2f'),qs['getFullTextValue'](_0x22f5ef,!![]))['or'](_0xfc98('0x30'),qs[_0xfc98('0x31')](_0x22f5ef));}else if(_0x46c2b0!=='fax'){_0x4752f9['or'](_0xfc98('0x32'),qs['getFullTextValue'](_0x22f5ef));}_0x4752f9['or'](_0xfc98('0x33'),qs[_0xfc98('0x31')](_0x22f5ef,!![]),null);}}return _0x4752f9;}function parseAdvancedSearchFilter(_0x31ba08,_0x5c7a23){var _0x2f496d=getSqlClauses();var _0x2bc0bd=as[_0xfc98('0x34')](_0x31ba08);var _0x348e18=_0x2bc0bd[_0xfc98('0x35')];for(var _0x49a13e=0x0;_0x49a13e<_0x2bc0bd[_0xfc98('0x36')]['length'];_0x49a13e++){var _0x333a13=_0x2bc0bd['conditions'][_0x49a13e];var _0x2caedb='i';var _0x33a393=_[_0xfc98('0x37')](_0x5c7a23,[_0xfc98('0x8'),_0x333a13[_0xfc98('0x7')]]);if(_0x33a393){var _0x13b0b4=as['buildExpression'](_0x2caedb,_0x33a393[_0xfc98('0x38')],_0x333a13);_0x2f496d['default'][_0x348e18](_0x13b0b4['text'],_0x13b0b4[_0xfc98('0x39')][_0xfc98('0x3a')],_0x13b0b4['value'][_0xfc98('0x3b')]);}else{switch(_0x333a13['field']){case _0xfc98('0x3c'):var _0x379637=parseReadParameter(_0x333a13[_0xfc98('0x39')]);_0x2f496d['read'][_0xfc98('0x3d')](_0x379637);break;case'Contact':if(_0x333a13[_0xfc98('0x3e')]===_0xfc98('0x3f')){if(_0x333a13[_0xfc98('0x39')][_0xfc98('0x40')]('\x20')[_0xfc98('0x10')]>0x1){_0x2f496d['contact'][_0x348e18]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xfc98('0x31')](_0x333a13[_0xfc98('0x39')],!![]),null);}else{var _0x233b8f='%'+_0x333a13['value']+'%';_0x2f496d[_0xfc98('0x41')][_0x348e18](_0xfc98('0x42'),_0x233b8f,_0x233b8f,_0x233b8f);}}else{_0x33a393=_['find'](_0x5c7a23,[_0xfc98('0x8'),'ContactId']);_0x333a13['field']=_0xfc98('0x43');_0x13b0b4=as['buildExpression'](_0x2caedb,_0x33a393[_0xfc98('0x38')],_0x333a13);_0x2f496d[_0xfc98('0x41')][_0x348e18](_0x13b0b4['text'],_0x13b0b4[_0xfc98('0x39')][_0xfc98('0x3a')],_0x13b0b4['value'][_0xfc98('0x3b')]);}break;case _0xfc98('0x44'):var _0x34adc7=_0x333a13[_0xfc98('0x39')][_0xfc98('0x40')](',')[_0xfc98('0x14')](function(_0x588841){return Number(_0x588841);});var _0x40cccd=parseTagParameter(_0x34adc7);_0x2f496d['tags']['clause']['and'](_0x40cccd);_0x2f496d[_0xfc98('0x45')]['ids']=_0x34adc7;break;case'User':if(_0x333a13[_0xfc98('0x3e')]==='$substring'){_0x2f496d[_0xfc98('0x46')][_0x348e18](_0xfc98('0x47'),'%'+_0x333a13[_0xfc98('0x39')]+'%',null);}else{_0x33a393=_[_0xfc98('0x37')](_0x5c7a23,[_0xfc98('0x8'),_0xfc98('0x48')]);_0x333a13[_0xfc98('0x7')]='UserId';_0x13b0b4=as[_0xfc98('0x49')](_0x2caedb,_0x33a393[_0xfc98('0x38')],_0x333a13);_0x2f496d['user'][_0x348e18](_0x13b0b4[_0xfc98('0x4a')],_0x13b0b4[_0xfc98('0x39')][_0xfc98('0x3a')],_0x13b0b4[_0xfc98('0x39')]['end']);}break;case _0xfc98('0x4b'):case'plainBody':_0x13b0b4=as[_0xfc98('0x49')]('me',null,_0x333a13);_0x2f496d['body'][_0x348e18](_0x13b0b4[_0xfc98('0x4a')],_0x13b0b4[_0xfc98('0x39')][_0xfc98('0x3a')],_0x13b0b4[_0xfc98('0x39')][_0xfc98('0x3b')]);break;}}}return _0x2f496d;}function parseModelFields(_0x175f0a,_0x12f392,_0x423cca){var _0x3d36f1=utils[_0xfc98('0x3')](_0x175f0a);var _0x5b19ba=squel[_0xfc98('0x1e')]();var _0x415c96=_(_0x12f392)[_0xfc98('0x4c')]()['map'](function(_0x4c83a8){return _[_0xfc98('0x4d')](_0x423cca,[_0xfc98('0x8'),_0x4c83a8])?_0x4c83a8:undefined;})['compact']()[_0xfc98('0x39')]();if(_0x415c96[_0xfc98('0x10')]>0x0){_0x415c96[_0xfc98('0x20')](function(_0x4f4aa6){if(_0x4f4aa6===_0x3d36f1){_0x5b19ba['and']('i.'+_0x3d36f1+'\x20IN\x20?',[][_0xfc98('0x4e')](_0x12f392[_0x4f4aa6]));}else if(_0x4f4aa6==='createdAt'){var _0x1a046f=JSON[_0xfc98('0x4f')](_0x12f392[_0x4f4aa6])['$gte'];var _0x48d360=JSON[_0xfc98('0x4f')](_0x12f392[_0x4f4aa6])[_0xfc98('0x50')];_0x5b19ba['and'](_0xfc98('0x51'),_0x1a046f,_0x48d360);}else{if(_0x12f392[_0x4f4aa6]==='null'){_0x5b19ba[_0xfc98('0x3d')]('i.'+_0x4f4aa6+_0xfc98('0x52'));}else{_0x5b19ba[_0xfc98('0x3d')]('i.'+_0x4f4aa6+_0xfc98('0x53'),_0x12f392[_0x4f4aa6]);}}});}return _0x5b19ba;}function parseQueryParameters(_0xce7863,_0x10ebca,_0xe4f639){var _0x23a166=getSqlClauses();return Promise[_0xfc98('0x54')]()[_0xfc98('0x55')](function(){return parseModelFields(_0xce7863,_0x10ebca,_0xe4f639);})['then'](function(_0x22f2f0){_0x23a166[_0xfc98('0x56')][_0xfc98('0x3d')](_0x22f2f0);return parseReadParameter(_0x10ebca['read']);})['then'](function(_0x4a22d7){_0x23a166[_0xfc98('0x57')][_0xfc98('0x3d')](_0x4a22d7);return parseTagParameter(_0x10ebca['tag']);})[_0xfc98('0x55')](function(_0x3ecae5){_0x23a166[_0xfc98('0x45')][_0xfc98('0x58')][_0xfc98('0x3d')](_0x3ecae5);return parseSearchFilter(_0xce7863,_0x10ebca[_0xfc98('0x59')]);})[_0xfc98('0x55')](function(_0x1b26ae){_0x23a166[_0xfc98('0x59')]=_0x1b26ae;return _0x23a166;});}function checkAccountsRestrictions(_0x28633c,_0x2b2580,_0x44c01d){var _0x31fa0e=utils[_0xfc98('0x3')](_0x28633c);var _0x575795='get'+_[_0xfc98('0x5a')](_0x28633c)+(_0x28633c===_0xfc98('0x5b')?'Websites':_0xfc98('0x5c'));var _0x113beb=squel[_0xfc98('0x1e')]();return Promise[_0xfc98('0x54')]()['then'](function(){if(_0x44c01d['search']&&_0x2b2580[_0xfc98('0x4')]===_0xfc98('0x5d')){return _0x2b2580[_0x575795]({'attributes':['id'],'raw':!![]});}})[_0xfc98('0x55')](function(_0x4d1945){if(_0x4d1945){if(_0x4d1945[_0xfc98('0x10')]===0x0){_0x113beb['and']('i.'+_0x31fa0e+_0xfc98('0x52'));}else{_0x113beb[_0xfc98('0x3d')]('i.'+_0x31fa0e+_0xfc98('0x13'),_['map'](_0x4d1945,'id'));}}else if(!_0x44c01d[_0x31fa0e]){_0x113beb[_0xfc98('0x3d')]('i.'+_0x31fa0e+_0xfc98('0x5e'));}})['then'](function(){return _0x113beb;});}function getClosedOrderClause(_0x4b7fb8,_0x47a77c){var _0x43eb79='';var _0xaa03cb=[_0xfc98('0x5f'),_0xfc98('0x60'),_0xfc98('0x61')];if(_0x4b7fb8===_0xfc98('0x2e')){_0xaa03cb['unshift'](_0xfc98('0x62'));}if(_0x47a77c[_0xfc98('0x63')]==='0'&&_0x4b7fb8===_0xfc98('0x2e')){_0x43eb79=_0xfc98('0x62');}else{if(_0x47a77c[_0xfc98('0x63')]==='1'){_0xaa03cb[_0xfc98('0x64')]();}_0x43eb79='CONCAT_WS(\x27\x27,\x20'+_0xaa03cb[_0xfc98('0x65')](',\x20')+')';}return _0x43eb79;}function getFilteredInteractions(_0x4d3e26,_0x4b1c70,_0xf7d971,_0x5737aa){var _0x242c25=utils['getInteractionFK'](_0x4d3e26);var _0x1a25a8=_[_0xfc98('0x5a')](_0x4d3e26)+_0xfc98('0x66');var _0x47714b=[];var _0x1aa08a=getTagsQuery();var _0x33ffde={'type':db[_0xfc98('0x67')][_0xfc98('0x68')][_0xfc98('0x69')],'raw':!![]};var _0x510a4a=[];var _0x274a55=[];return db[_0xfc98('0x6a')][_0xfc98('0x6b')](_0x1aa08a[_0xfc98('0x6c')](),_0x33ffde)[_0xfc98('0x55')](function(_0xe01fd){_0x47714b=_[_0xfc98('0x6d')](_0xe01fd,'id');_0x33ffde=_[_0xfc98('0x6e')](_0x33ffde,{'model':db[_0x1a25a8],'mapToModel':!![],'nest':!![]});if(_0xf7d971[_0xfc98('0x56')]){_0x5737aa[_0xfc98('0x6f')]['forEach'](function(_0x344ebd){_0x4b1c70[_0xfc98('0x7')]('i.'+_0x344ebd);});}else{_0x4b1c70['field'](_0xfc98('0x70'),_0xfc98('0x3c'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x71'),_0xfc98('0x72'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x73'),_0xfc98('0x74'));if(_0x4d3e26===_0xfc98('0x2e')){_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x75'),'Account.email');_0x4b1c70[_0xfc98('0x7')]('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');_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x76'));_0x4b1c70['field'](_0xfc98('0x77'));_0x4b1c70['field'](_0xfc98('0x78'));_0x4b1c70['field'](_0xfc98('0x79'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x7a'));_0x4b1c70['field']('i.attach');_0x4b1c70[_0xfc98('0x7')]('i.lastMsgAt');_0x4b1c70[_0xfc98('0x7')]('i.lastMsgDirection');_0x4b1c70['field'](_0xfc98('0x7b'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x61'));_0x4b1c70['field']('i.secondDisposition');_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x5f'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x62'));_0x4b1c70[_0xfc98('0x7')]('i.to');_0x4b1c70[_0xfc98('0x7')]('i.ContactId');_0x4b1c70['field']('i.MailAccountId');_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x7c'));}else if(_0x4d3e26==='openchannel'){_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x7d'),_0xfc98('0x7e'));}else{_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x7f'),_0xfc98('0x7e'));}if(_0x4d3e26!==_0xfc98('0x2e')){_0x4b1c70[_0xfc98('0x7')]('i.*');}_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x80'),'Contact.firstName');_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x81'),_0xfc98('0x82'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x83'),_0xfc98('0x84'));_0x4b1c70[_0xfc98('0x7')]('c.phone',_0xfc98('0x85'));_0x4b1c70['field'](_0xfc98('0x86'),_0xfc98('0x87'));_0x4b1c70['field']('c.fax','Contact.fax');_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x88'),_0xfc98('0x89'));_0x4b1c70['field'](_0xfc98('0x8a'),_0xfc98('0x8b'));_0x4b1c70[_0xfc98('0x7')](_0xfc98('0x8c'),'TagIds');}if(_0x5737aa[_0xfc98('0x8d')]){_0x4b1c70[_0xfc98('0x8d')](_0x5737aa[_0xfc98('0x8d')]);}if(_0x5737aa['offset']){_0x4b1c70[_0xfc98('0x8e')](_0x5737aa[_0xfc98('0x8e')]);}return db[_0xfc98('0x6a')][_0xfc98('0x6b')](_0x4b1c70[_0xfc98('0x6c')](),_0x33ffde);})['then'](function(_0x2dc90d){_0x510a4a=_0x2dc90d;var _0x64e71c=getUsersQuery(_0x4d3e26,_0x510a4a);return db['sequelize'][_0xfc98('0x6b')](_0x64e71c[_0xfc98('0x6c')](),_0x33ffde);})[_0xfc98('0x55')](function(_0x437eb3){_0x274a55=_[_0xfc98('0x8f')](_0x437eb3,_0x242c25);if(_0x4d3e26===_0xfc98('0x2e')){return db[_0xfc98('0x90')][_0xfc98('0x91')]({'attributes':[_0xfc98('0x92')],'raw':!![]});}})[_0xfc98('0x55')](function(_0x7cfa11){var _0x99093c=_0x7cfa11?_0x7cfa11[_0xfc98('0x92')]:undefined;var _0x450cd8=_0x510a4a[_0xfc98('0x14')](function(_0x19ffa9){return updateInteraction(_0x19ffa9,_0x47714b,_0x274a55,_0x99093c);});return Promise[_0xfc98('0x93')](_0x450cd8);});}function countFilteredInteractions(_0x2c3197,_0xaef7a9){var _0x5b09d2=_0x2c3197[_0xfc98('0x94')]();_0x5b09d2[_0xfc98('0x7')](_0xfc98('0x95'));_0x5b09d2['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xfc98('0x3c'));var _0x1deb9=utils[_0xfc98('0x1f')](_0xaef7a9);if(!_[_0xfc98('0x96')](_0x1deb9)){_0x5b09d2[_0xfc98('0x11')]('t.id\x20IN\x20?',_0x1deb9);}var _0x5b8bef={'type':db['Sequelize']['QueryTypes'][_0xfc98('0x69')],'raw':!![]};return db[_0xfc98('0x6a')][_0xfc98('0x6b')](_0x5b09d2[_0xfc98('0x6c')](),_0x5b8bef);}module[_0xfc98('0x97')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0xb422=['fields','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','i.substatus','i.to','i.ContactId','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.*','c.firstName','Contact.firstName','c.email','Contact.email','c.phone','c.mobile','Contact.mobile','c.fax','o.fullname','Owner.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','limit','offset','toString','groupBy','findOne','enableEmailPreview','all','clone','COUNT(*)','isEmpty','where','t.id\x20IN\x20?','QueryTypes','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','../../mysqldb','getAccountFK','role','select','field','color','tools_tags','getInteractionFK','_interactions','ui.','from','left_join','users','u.id\x20=\x20ui.UserId','length','map','getInteractionsTables','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','interactionsTags','\x20=\x20i.id','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','i.id\x20LIKE\x20?','sms','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','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','type','default','text','value','start','end','unreadMessages','read','and','Contact','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','clause','tags','User','operator','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','name','UserId','user','body','keys','some','compact','\x20IN\x20?','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','resolve','then','tag','filter','get','capitalize','Accounts','search','agent','i.thirdDisposition','i.secondDisposition','i.disposition','closed','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','SELECT','sequelize','query','merge'];(function(_0x329197,_0x53d0e8){var _0x59459a=function(_0x289258){while(--_0x289258){_0x329197['push'](_0x329197['shift']());}};_0x59459a(++_0x53d0e8);}(_0xb422,0xce));var _0x2b42=function(_0x418321,_0x52b4f1){_0x418321=_0x418321-0x0;var _0x402cbd=_0xb422[_0x418321];return _0x402cbd;};'use strict';var _=require(_0x2b42('0x0'));var squel=require(_0x2b42('0x1'));var as=require(_0x2b42('0x2'));var qs=require(_0x2b42('0x3'));var updateInteraction=require(_0x2b42('0x4'))[_0x2b42('0x5')];var utils=require('./utils');var db=require(_0x2b42('0x6'))['db'];function skipInteractionsQuery(_0x144b1c,_0x250841,_0x19c05c){var _0x2b7005=![];var _0x4cca3a=utils[_0x2b42('0x7')](_0x144b1c);if(_0x250841[_0x2b42('0x8')]==='agent'&&!_0x19c05c['search']&&!_0x19c05c[_0x4cca3a]){_0x2b7005=!![];}return _0x2b7005;}function getTagsQuery(){return squel[_0x2b42('0x9')]()[_0x2b42('0xa')]('id')[_0x2b42('0xa')]('name')[_0x2b42('0xa')](_0x2b42('0xb'))['from'](_0x2b42('0xc'));}function getUsersQuery(_0x4d3ad6,_0x37d13d){var _0x51d693=utils[_0x2b42('0xd')](_0x4d3ad6);var _0x43ab54='user_has_'+_0x4d3ad6+_0x2b42('0xe');var _0x195be3=squel[_0x2b42('0x9')]()[_0x2b42('0xa')]('u.id')[_0x2b42('0xa')]('u.fullname')[_0x2b42('0xa')](_0x2b42('0xf')+_0x51d693)[_0x2b42('0x10')](_0x43ab54,'ui')[_0x2b42('0x11')](_0x2b42('0x12'),'u',_0x2b42('0x13'));if(_0x37d13d[_0x2b42('0x14')]>0x0){_0x195be3['where'](_0x2b42('0xf')+_0x51d693+'\x20IN\x20?',_[_0x2b42('0x15')](_0x37d13d,'id'));}return _0x195be3;}function getInteractionsQuery(_0x1d1ed8){var _0x4434b5=utils[_0x2b42('0x16')](_0x1d1ed8);var _0x30380b=utils['getAccountFK'](_0x1d1ed8);var _0x4ce33d=utils['getInteractionFK'](_0x1d1ed8);return squel[_0x2b42('0x9')]()[_0x2b42('0x10')](_0x4434b5[_0x2b42('0x17')],'i')[_0x2b42('0x11')](_0x2b42('0x18'),'c',_0x2b42('0x19'))[_0x2b42('0x11')]('users','o',_0x2b42('0x1a'))[_0x2b42('0x11')](_0x4434b5[_0x2b42('0x1b')],'a',_0x2b42('0x1c')+_0x30380b)['left_join'](_0x4434b5[_0x2b42('0x1d')],'me','me.'+_0x4ce33d+'\x20=\x20i.id')[_0x2b42('0x11')](_0x4434b5[_0x2b42('0x1e')],'it','it.'+_0x4ce33d+_0x2b42('0x1f'))['left_join'](_0x2b42('0xc'),'t',_0x2b42('0x20'));}function getSqlClauses(){var _0xb8c23a={'body':squel[_0x2b42('0x21')](),'contact':squel[_0x2b42('0x21')](),'default':squel[_0x2b42('0x21')](),'fields':squel[_0x2b42('0x21')](),'filter':squel[_0x2b42('0x21')](),'read':squel[_0x2b42('0x21')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x2b42('0x21')]()};return _0xb8c23a;}function parseTagParameter(_0x2d2c2b){var _0x501ac5=squel['expr']();if(_0x2d2c2b){var _0x3f556f=utils[_0x2b42('0x22')](_0x2d2c2b);_0x3f556f[_0x2b42('0x23')](function(_0x94351c){_0x501ac5['or'](_0x2b42('0x24'),'%,'+_0x94351c+',%');});}return _0x501ac5;}function parseReadParameter(_0x326431){var _0xcf5ee9='';if(_0x326431){_0xcf5ee9=_0x2b42('0x25');if(_0x326431==='1'){_0xcf5ee9=_0xcf5ee9[_0x2b42('0x26')](_0x2b42('0x27'),'=');}else{_0xcf5ee9=_0xcf5ee9[_0x2b42('0x26')](_0x2b42('0x27'),'>');}}return _0xcf5ee9;}function parseSearchFilter(_0x17af16,_0x7a9318){var _0x39364a=squel[_0x2b42('0x21')]();if(_0x7a9318){var _0x25bc59=_0x7a9318[_0x2b42('0x26')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x2b42('0x28')](_0x25bc59)){_0x39364a['or'](_0x2b42('0x29'),_0x25bc59+'%');if([_0x2b42('0x2a'),'whatsapp'][_0x2b42('0x2b')](_0x17af16)){_0x39364a['or'](_0x2b42('0x2c'),_0x25bc59+'%');}else if(_0x17af16===_0x2b42('0x2d')){_0x39364a['or'](_0x2b42('0x2e'),_0x25bc59+'%');}else if(_0x17af16==='openchannel'){_0x39364a['or'](_0x2b42('0x2f'),_0x25bc59+'%');}}else if(_0x17af16===_0x2b42('0x30')&&qs[_0x2b42('0x31')](_0x25bc59)){_0x39364a['or'](_0x2b42('0x32'),_0x25bc59+'%');}else{if(_0x17af16===_0x2b42('0x30')){_0x39364a['or'](_0x2b42('0x33'),qs[_0x2b42('0x34')](_0x25bc59,!![]))['or'](_0x2b42('0x35'),qs[_0x2b42('0x34')](_0x25bc59));}else if(_0x17af16!=='fax'){_0x39364a['or'](_0x2b42('0x36'),qs['getFullTextValue'](_0x25bc59));}_0x39364a['or'](_0x2b42('0x37'),qs['getFullTextValue'](_0x25bc59,!![]),null);}}return _0x39364a;}function parseAdvancedSearchFilter(_0x5d2d1f,_0x8e8d5a){var _0x2b5ac8=getSqlClauses();var _0x4aed1e=as[_0x2b42('0x38')](_0x5d2d1f);var _0x55e27f=_0x4aed1e[_0x2b42('0x39')];for(var _0x4da26e=0x0;_0x4da26e<_0x4aed1e[_0x2b42('0x3a')]['length'];_0x4da26e++){var _0x23dde4=_0x4aed1e['conditions'][_0x4da26e];var _0x5c2860='i';var _0x4b2e17=_[_0x2b42('0x3b')](_0x8e8d5a,['name',_0x23dde4[_0x2b42('0xa')]]);if(_0x4b2e17){var _0x550059=as[_0x2b42('0x3c')](_0x5c2860,_0x4b2e17[_0x2b42('0x3d')],_0x23dde4);_0x2b5ac8[_0x2b42('0x3e')][_0x55e27f](_0x550059[_0x2b42('0x3f')],_0x550059[_0x2b42('0x40')][_0x2b42('0x41')],_0x550059[_0x2b42('0x40')][_0x2b42('0x42')]);}else{switch(_0x23dde4[_0x2b42('0xa')]){case _0x2b42('0x43'):var _0x5bed62=parseReadParameter(_0x23dde4[_0x2b42('0x40')]);_0x2b5ac8[_0x2b42('0x44')][_0x2b42('0x45')](_0x5bed62);break;case _0x2b42('0x46'):if(_0x23dde4['operator']===_0x2b42('0x47')){if(_0x23dde4['value'][_0x2b42('0x48')]('\x20')['length']>0x1){_0x2b5ac8[_0x2b42('0x49')][_0x55e27f]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x23dde4['value'],!![]),null);}else{var _0x546b35='%'+_0x23dde4[_0x2b42('0x40')]+'%';_0x2b5ac8[_0x2b42('0x49')][_0x55e27f](_0x2b42('0x4a'),_0x546b35,_0x546b35,_0x546b35);}}else{_0x4b2e17=_[_0x2b42('0x3b')](_0x8e8d5a,['name',_0x2b42('0x4b')]);_0x23dde4[_0x2b42('0xa')]=_0x2b42('0x4b');_0x550059=as[_0x2b42('0x3c')](_0x5c2860,_0x4b2e17[_0x2b42('0x3d')],_0x23dde4);_0x2b5ac8['contact'][_0x55e27f](_0x550059[_0x2b42('0x3f')],_0x550059[_0x2b42('0x40')]['start'],_0x550059[_0x2b42('0x40')]['end']);}break;case'Tag':var _0x54316f=_0x23dde4['value'][_0x2b42('0x48')](',')[_0x2b42('0x15')](function(_0x1d6843){return Number(_0x1d6843);});var _0x45d37b=parseTagParameter(_0x54316f);_0x2b5ac8['tags'][_0x2b42('0x4c')][_0x2b42('0x45')](_0x45d37b);_0x2b5ac8[_0x2b42('0x4d')]['ids']=_0x54316f;break;case _0x2b42('0x4e'):if(_0x23dde4[_0x2b42('0x4f')]==='$substring'){_0x2b5ac8['user'][_0x55e27f](_0x2b42('0x50'),'%'+_0x23dde4['value']+'%',null);}else{_0x4b2e17=_[_0x2b42('0x3b')](_0x8e8d5a,[_0x2b42('0x51'),_0x2b42('0x52')]);_0x23dde4[_0x2b42('0xa')]=_0x2b42('0x52');_0x550059=as[_0x2b42('0x3c')](_0x5c2860,_0x4b2e17[_0x2b42('0x3d')],_0x23dde4);_0x2b5ac8[_0x2b42('0x53')][_0x55e27f](_0x550059[_0x2b42('0x3f')],_0x550059[_0x2b42('0x40')]['start'],_0x550059[_0x2b42('0x40')][_0x2b42('0x42')]);}break;case _0x2b42('0x54'):case'plainBody':_0x550059=as[_0x2b42('0x3c')]('me',null,_0x23dde4);_0x2b5ac8[_0x2b42('0x54')][_0x55e27f](_0x550059[_0x2b42('0x3f')],_0x550059[_0x2b42('0x40')][_0x2b42('0x41')],_0x550059[_0x2b42('0x40')]['end']);break;}}}return _0x2b5ac8;}function parseModelFields(_0x2b767a,_0xa46f8c,_0x5c483e){var _0x5e8d8e=utils['getAccountFK'](_0x2b767a);var _0x30abce=squel['expr']();var _0x406781=_(_0xa46f8c)[_0x2b42('0x55')]()[_0x2b42('0x15')](function(_0x5b191a){return _[_0x2b42('0x56')](_0x5c483e,[_0x2b42('0x51'),_0x5b191a])?_0x5b191a:undefined;})[_0x2b42('0x57')]()[_0x2b42('0x40')]();if(_0x406781[_0x2b42('0x14')]>0x0){_0x406781[_0x2b42('0x23')](function(_0x25da66){if(_0x25da66===_0x5e8d8e){_0x30abce['and']('i.'+_0x5e8d8e+_0x2b42('0x58'),[][_0x2b42('0x59')](_0xa46f8c[_0x25da66]));}else if(_0x25da66===_0x2b42('0x5a')){var _0x3000ca=JSON[_0x2b42('0x5b')](_0xa46f8c[_0x25da66])[_0x2b42('0x5c')];var _0x55e361=JSON[_0x2b42('0x5b')](_0xa46f8c[_0x25da66])[_0x2b42('0x5d')];_0x30abce[_0x2b42('0x45')](_0x2b42('0x5e'),_0x3000ca,_0x55e361);}else{if(_0xa46f8c[_0x25da66]===_0x2b42('0x5f')){_0x30abce[_0x2b42('0x45')]('i.'+_0x25da66+_0x2b42('0x60'));}else{_0x30abce[_0x2b42('0x45')]('i.'+_0x25da66+'\x20=\x20?',_0xa46f8c[_0x25da66]);}}});}return _0x30abce;}function parseQueryParameters(_0x2de329,_0x5a8a0a,_0x33cfee){var _0x1095f3=getSqlClauses();return Promise[_0x2b42('0x61')]()[_0x2b42('0x62')](function(){return parseModelFields(_0x2de329,_0x5a8a0a,_0x33cfee);})[_0x2b42('0x62')](function(_0x3b5020){_0x1095f3['fields']['and'](_0x3b5020);return parseReadParameter(_0x5a8a0a['read']);})[_0x2b42('0x62')](function(_0x38f8e5){_0x1095f3[_0x2b42('0x44')][_0x2b42('0x45')](_0x38f8e5);return parseTagParameter(_0x5a8a0a[_0x2b42('0x63')]);})[_0x2b42('0x62')](function(_0x4fb5ed){_0x1095f3[_0x2b42('0x4d')][_0x2b42('0x4c')][_0x2b42('0x45')](_0x4fb5ed);return parseSearchFilter(_0x2de329,_0x5a8a0a[_0x2b42('0x64')]);})[_0x2b42('0x62')](function(_0x3e52f4){_0x1095f3[_0x2b42('0x64')]=_0x3e52f4;return _0x1095f3;});}function checkAccountsRestrictions(_0x3db41f,_0x5a4724,_0xad5896){var _0x36a36d=utils['getAccountFK'](_0x3db41f);var _0x243f29=_0x2b42('0x65')+_[_0x2b42('0x66')](_0x3db41f)+(_0x3db41f==='chat'?'Websites':_0x2b42('0x67'));var _0x212426=squel[_0x2b42('0x21')]();return Promise[_0x2b42('0x61')]()[_0x2b42('0x62')](function(){if(_0xad5896[_0x2b42('0x68')]&&_0x5a4724[_0x2b42('0x8')]===_0x2b42('0x69')){return _0x5a4724[_0x243f29]({'attributes':['id'],'raw':!![]});}})[_0x2b42('0x62')](function(_0x4c3238){if(_0x4c3238){if(_0x4c3238[_0x2b42('0x14')]===0x0){_0x212426[_0x2b42('0x45')]('i.'+_0x36a36d+_0x2b42('0x60'));}else{_0x212426[_0x2b42('0x45')]('i.'+_0x36a36d+'\x20IN\x20?',_[_0x2b42('0x15')](_0x4c3238,'id'));}}else if(!_0xad5896[_0x36a36d]){_0x212426[_0x2b42('0x45')]('i.'+_0x36a36d+'\x20IS\x20NOT\x20NULL');}})[_0x2b42('0x62')](function(){return _0x212426;});}function getClosedOrderClause(_0x12b9bb,_0x4db237){var _0x5b7ded='';var _0x80e081=[_0x2b42('0x6a'),_0x2b42('0x6b'),_0x2b42('0x6c')];if(_0x12b9bb===_0x2b42('0x30')){_0x80e081['unshift']('i.substatus');}if(_0x4db237[_0x2b42('0x6d')]==='0'&&_0x12b9bb==='mail'){_0x5b7ded='i.substatus';}else{if(_0x4db237['closed']==='1'){_0x80e081['shift']();}_0x5b7ded=_0x2b42('0x6e')+_0x80e081[_0x2b42('0x6f')](',\x20')+')';}return _0x5b7ded;}function getFilteredInteractions(_0x1da60a,_0x46e7ce,_0x1424f2,_0xac8e9c){var _0x5d04c2=utils[_0x2b42('0xd')](_0x1da60a);var _0x356edc=_[_0x2b42('0x66')](_0x1da60a)+_0x2b42('0x70');var _0xd8cde7=[];var _0xde618e=getTagsQuery();var _0x16d33a={'type':db[_0x2b42('0x71')]['QueryTypes'][_0x2b42('0x72')],'raw':!![]};var _0xd0bd74=[];var _0x11380d=[];return db[_0x2b42('0x73')][_0x2b42('0x74')](_0xde618e['toString'](),_0x16d33a)[_0x2b42('0x62')](function(_0x1336f9){_0xd8cde7=_['keyBy'](_0x1336f9,'id');_0x16d33a=_[_0x2b42('0x75')](_0x16d33a,{'model':db[_0x356edc],'mapToModel':!![],'nest':!![]});if(_0x1424f2[_0x2b42('0x76')]){_0xac8e9c[_0x2b42('0x77')]['forEach'](function(_0x3d44af){_0x46e7ce[_0x2b42('0xa')]('i.'+_0x3d44af);});}else{_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x78'),_0x2b42('0x43'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x79'),_0x2b42('0x7a'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x7b'),'Account.mandatoryDisposition');if(_0x1da60a===_0x2b42('0x30')){_0x46e7ce[_0x2b42('0xa')]('a.email','Account.email');_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x7c'),_0x2b42('0x7d'));_0x46e7ce[_0x2b42('0xa')]('i.id');_0x46e7ce[_0x2b42('0xa')]('i.createdAt');_0x46e7ce['field'](_0x2b42('0x7e'));_0x46e7ce['field'](_0x2b42('0x7f'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x80'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x81'));_0x46e7ce['field']('i.lastMsgAt');_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x82'));_0x46e7ce[_0x2b42('0xa')]('i.subject');_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x6c'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x6b'));_0x46e7ce['field'](_0x2b42('0x6a'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x83'));_0x46e7ce['field'](_0x2b42('0x84'));_0x46e7ce['field'](_0x2b42('0x85'));_0x46e7ce[_0x2b42('0xa')]('i.MailAccountId');_0x46e7ce[_0x2b42('0xa')]('i.UserId');}else if(_0x1da60a==='openchannel'){_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x86'),_0x2b42('0x7d'));}else{_0x46e7ce['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','contactName');}if(_0x1da60a!==_0x2b42('0x30')){_0x46e7ce['field'](_0x2b42('0x87'));}_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x88'),_0x2b42('0x89'));_0x46e7ce[_0x2b42('0xa')]('c.lastName','Contact.lastName');_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x8a'),_0x2b42('0x8b'));_0x46e7ce['field'](_0x2b42('0x8c'),'Contact.phone');_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x8d'),_0x2b42('0x8e'));_0x46e7ce[_0x2b42('0xa')](_0x2b42('0x8f'),'Contact.fax');_0x46e7ce['field'](_0x2b42('0x90'),_0x2b42('0x91'));_0x46e7ce[_0x2b42('0xa')]('o.internal',_0x2b42('0x92'));_0x46e7ce['field'](_0x2b42('0x93'),'TagIds');}if(_0xac8e9c['limit']){_0x46e7ce[_0x2b42('0x94')](_0xac8e9c[_0x2b42('0x94')]);}if(_0xac8e9c[_0x2b42('0x95')]){_0x46e7ce[_0x2b42('0x95')](_0xac8e9c[_0x2b42('0x95')]);}return db[_0x2b42('0x73')][_0x2b42('0x74')](_0x46e7ce[_0x2b42('0x96')](),_0x16d33a);})[_0x2b42('0x62')](function(_0x3a276e){_0xd0bd74=_0x3a276e;var _0x58e796=getUsersQuery(_0x1da60a,_0xd0bd74);return db[_0x2b42('0x73')]['query'](_0x58e796['toString'](),_0x16d33a);})['then'](function(_0x3b3e39){_0x11380d=_[_0x2b42('0x97')](_0x3b3e39,_0x5d04c2);if(_0x1da60a==='mail'){return db['Setting'][_0x2b42('0x98')]({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x2b42('0x62')](function(_0x3963b1){var _0x4d8217=_0x3963b1?_0x3963b1[_0x2b42('0x99')]:undefined;var _0x3505f4=_0xd0bd74['map'](function(_0x55c581){return updateInteraction(_0x55c581,_0xd8cde7,_0x11380d,_0x4d8217);});return Promise[_0x2b42('0x9a')](_0x3505f4);});}function countFilteredInteractions(_0xbbd96c,_0x25186c){var _0x37d834=_0xbbd96c[_0x2b42('0x9b')]();_0x37d834['field'](_0x2b42('0x9c'));_0x37d834['field'](_0x2b42('0x78'),_0x2b42('0x43'));var _0x5d0190=utils[_0x2b42('0x22')](_0x25186c);if(!_[_0x2b42('0x9d')](_0x5d0190)){_0x37d834[_0x2b42('0x9e')](_0x2b42('0x9f'),_0x5d0190);}var _0x21ddbc={'type':db[_0x2b42('0x71')][_0x2b42('0xa0')][_0x2b42('0x72')],'raw':!![]};return db[_0x2b42('0x73')][_0x2b42('0x74')](_0x37d834[_0x2b42('0x96')](),_0x21ddbc);}module[_0x2b42('0xa1')]={'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