// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x937a=['keys','some','concat','createdAt','parse','$lte','null','\x20IS\x20NULL','\x20=\x20?','then','tag','filter','get','chat','Websites','Accounts','resolve','role','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','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','a.email','Account.email','contactName','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','i.MailAccountId','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','c.lastName','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Owner.fullname','o.internal','Owner.internal','TagIds','limit','offset','groupBy','Setting','findOne','enableEmailPreview','all','COUNT(*)','t.id\x20IN\x20?','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','../../mysqldb','getAccountFK','agent','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','where','\x20IN\x20?','map','getInteractionsTables','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','messages','\x20=\x20i.id','interactionsTags','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','isEmail','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)','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','length','find','buildExpression','type','default','text','value','start','end','read','and','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','split','tags','clause','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId'];(function(_0x4c59e0,_0x4ce660){var _0xc69b7a=function(_0x56f400){while(--_0x56f400){_0x4c59e0['push'](_0x4c59e0['shift']());}};_0xc69b7a(++_0x4ce660);}(_0x937a,0xe7));var _0xa937=function(_0x345a1b,_0x189c9e){_0x345a1b=_0x345a1b-0x0;var _0x1b24ec=_0x937a[_0x345a1b];return _0x1b24ec;};'use strict';var _=require(_0xa937('0x0'));var squel=require(_0xa937('0x1'));var as=require(_0xa937('0x2'));var qs=require(_0xa937('0x3'));var updateInteraction=require(_0xa937('0x4'))['updateInteraction'];var utils=require('./utils');var db=require(_0xa937('0x5'))['db'];function skipInteractionsQuery(_0x34091b,_0x496c47,_0x3f6403){var _0x55e286=![];var _0x545e12=utils[_0xa937('0x6')](_0x34091b);if(_0x496c47['role']===_0xa937('0x7')&&!_0x3f6403[_0xa937('0x8')]&&!_0x3f6403[_0x545e12]){_0x55e286=!![];}return _0x55e286;}function getTagsQuery(){return squel[_0xa937('0x9')]()[_0xa937('0xa')]('id')[_0xa937('0xa')](_0xa937('0xb'))[_0xa937('0xa')](_0xa937('0xc'))[_0xa937('0xd')](_0xa937('0xe'));}function getUsersQuery(_0x117426,_0x3ed614){var _0x2d42ec=utils[_0xa937('0xf')](_0x117426);var _0x121a98=_0xa937('0x10')+_0x117426+_0xa937('0x11');var _0x52434a=squel['select']()['field'](_0xa937('0x12'))['field'](_0xa937('0x13'))[_0xa937('0xa')](_0xa937('0x14')+_0x2d42ec)[_0xa937('0xd')](_0x121a98,'ui')[_0xa937('0x15')](_0xa937('0x16'),'u',_0xa937('0x17'));if(_0x3ed614['length']>0x0){_0x52434a[_0xa937('0x18')](_0xa937('0x14')+_0x2d42ec+_0xa937('0x19'),_[_0xa937('0x1a')](_0x3ed614,'id'));}return _0x52434a;}function getInteractionsQuery(_0x2daf76){var _0x3ecd3b=utils[_0xa937('0x1b')](_0x2daf76);var _0x4eb3da=utils[_0xa937('0x6')](_0x2daf76);var _0x273df2=utils[_0xa937('0xf')](_0x2daf76);return squel[_0xa937('0x9')]()[_0xa937('0xd')](_0x3ecd3b['interactions'],'i')['left_join'](_0xa937('0x1c'),'c',_0xa937('0x1d'))['left_join'](_0xa937('0x16'),'o',_0xa937('0x1e'))[_0xa937('0x15')](_0x3ecd3b['accounts'],'a','a.id\x20=\x20i.'+_0x4eb3da)[_0xa937('0x15')](_0x3ecd3b[_0xa937('0x1f')],'me','me.'+_0x273df2+_0xa937('0x20'))[_0xa937('0x15')](_0x3ecd3b[_0xa937('0x21')],'it',_0xa937('0x22')+_0x273df2+_0xa937('0x20'))[_0xa937('0x15')]('tools_tags','t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x5c2cf6={'body':squel['expr'](),'contact':squel['expr'](),'default':squel[_0xa937('0x23')](),'fields':squel['expr'](),'filter':squel[_0xa937('0x23')](),'read':squel[_0xa937('0x23')](),'tags':{'clause':squel[_0xa937('0x23')](),'ids':null},'user':squel[_0xa937('0x23')]()};return _0x5c2cf6;}function parseTagParameter(_0x25d609){var _0x2880e1=squel[_0xa937('0x23')]();if(_0x25d609){var _0x4526b0=utils[_0xa937('0x24')](_0x25d609);_0x4526b0[_0xa937('0x25')](function(_0xf92ff1){_0x2880e1['or'](_0xa937('0x26'),'%,'+_0xf92ff1+',%');});}return _0x2880e1;}function parseReadParameter(_0x5412e4){var _0x31bf22='';if(_0x5412e4){_0x31bf22='unreadMessages\x20{OPERATOR}\x200';if(_0x5412e4==='1'){_0x31bf22=_0x31bf22[_0xa937('0x27')](_0xa937('0x28'),'=');}else{_0x31bf22=_0x31bf22[_0xa937('0x27')](_0xa937('0x28'),'>');}}return _0x31bf22;}function parseSearchFilter(_0x170fcf,_0x25677b){var _0x3f533a=squel[_0xa937('0x23')]();if(_0x25677b){var _0x3164ee=_0x25677b[_0xa937('0x27')]('\x5c','\x5c\x5c')[_0xa937('0x27')](/'/g,'\x27\x27');if(qs[_0xa937('0x29')](_0x3164ee)){_0x3f533a['or'](_0xa937('0x2a'),_0x3164ee+'%');if([_0xa937('0x2b'),_0xa937('0x2c')]['includes'](_0x170fcf)){_0x3f533a['or']('i.phone\x20LIKE\x20?',_0x3164ee+'%');}else if(_0x170fcf==='fax'){_0x3f533a['or'](_0xa937('0x2d'),_0x3164ee+'%');}else if(_0x170fcf===_0xa937('0x2e')){_0x3f533a['or'](_0xa937('0x2f'),_0x3164ee+'%');}}else if(_0x170fcf==='mail'&&qs[_0xa937('0x30')](_0x3164ee)){_0x3f533a['or'](_0xa937('0x31'),_0x3164ee+'%');}else{if(_0x170fcf===_0xa937('0x32')){_0x3f533a['or'](_0xa937('0x33'),qs[_0xa937('0x34')](_0x3164ee,!![]))['or'](_0xa937('0x35'),qs[_0xa937('0x34')](_0x3164ee));}else if(_0x170fcf!=='fax'){_0x3f533a['or'](_0xa937('0x36'),qs[_0xa937('0x34')](_0x3164ee));}_0x3f533a['or'](_0xa937('0x37'),qs[_0xa937('0x34')](_0x3164ee,!![]),null);}}return _0x3f533a;}function parseAdvancedSearchFilter(_0x4b2744,_0x2f01e4){var _0xf73629=getSqlClauses();var _0x48ae12=as[_0xa937('0x38')](_0x4b2744);var _0x5567e1=_0x48ae12[_0xa937('0x39')];for(var _0x528fc4=0x0;_0x528fc4<_0x48ae12[_0xa937('0x3a')][_0xa937('0x3b')];_0x528fc4++){var _0x12351d=_0x48ae12[_0xa937('0x3a')][_0x528fc4];var _0x4fd30e='i';var _0x4e67f9=_[_0xa937('0x3c')](_0x2f01e4,[_0xa937('0xb'),_0x12351d['field']]);if(_0x4e67f9){var _0x201809=as[_0xa937('0x3d')](_0x4fd30e,_0x4e67f9[_0xa937('0x3e')],_0x12351d);_0xf73629[_0xa937('0x3f')][_0x5567e1](_0x201809[_0xa937('0x40')],_0x201809[_0xa937('0x41')][_0xa937('0x42')],_0x201809[_0xa937('0x41')][_0xa937('0x43')]);}else{switch(_0x12351d[_0xa937('0xa')]){case'unreadMessages':var _0x11d89e=parseReadParameter(_0x12351d[_0xa937('0x41')]);_0xf73629[_0xa937('0x44')][_0xa937('0x45')](_0x11d89e);break;case'Contact':if(_0x12351d[_0xa937('0x46')]===_0xa937('0x47')){if(_0x12351d['value']['split']('\x20')[_0xa937('0x3b')]>0x1){_0xf73629['contact'][_0x5567e1](_0xa937('0x37'),qs['getFullTextValue'](_0x12351d[_0xa937('0x41')],!![]),null);}else{var _0x125bee='%'+_0x12351d[_0xa937('0x41')]+'%';_0xf73629[_0xa937('0x48')][_0x5567e1](_0xa937('0x49'),_0x125bee,_0x125bee,_0x125bee);}}else{_0x4e67f9=_[_0xa937('0x3c')](_0x2f01e4,[_0xa937('0xb'),_0xa937('0x4a')]);_0x12351d[_0xa937('0xa')]=_0xa937('0x4a');_0x201809=as[_0xa937('0x3d')](_0x4fd30e,_0x4e67f9[_0xa937('0x3e')],_0x12351d);_0xf73629[_0xa937('0x48')][_0x5567e1](_0x201809[_0xa937('0x40')],_0x201809[_0xa937('0x41')][_0xa937('0x42')],_0x201809[_0xa937('0x41')][_0xa937('0x43')]);}break;case'Tag':var _0x4ac822=_0x12351d[_0xa937('0x41')][_0xa937('0x4b')](',')[_0xa937('0x1a')](function(_0x90f9a5){return Number(_0x90f9a5);});var _0x190609=parseTagParameter(_0x4ac822);_0xf73629[_0xa937('0x4c')][_0xa937('0x4d')][_0xa937('0x45')](_0x190609);_0xf73629[_0xa937('0x4c')][_0xa937('0x4e')]=_0x4ac822;break;case _0xa937('0x4f'):if(_0x12351d[_0xa937('0x46')]===_0xa937('0x47')){_0xf73629[_0xa937('0x50')][_0x5567e1](_0xa937('0x51'),'%'+_0x12351d[_0xa937('0x41')]+'%',null);}else{_0x4e67f9=_[_0xa937('0x3c')](_0x2f01e4,['name',_0xa937('0x52')]);_0x12351d['field']=_0xa937('0x52');_0x201809=as['buildExpression'](_0x4fd30e,_0x4e67f9[_0xa937('0x3e')],_0x12351d);_0xf73629[_0xa937('0x50')][_0x5567e1](_0x201809['text'],_0x201809['value'][_0xa937('0x42')],_0x201809[_0xa937('0x41')]['end']);}break;case'body':case'plainBody':_0x201809=as[_0xa937('0x3d')]('me',null,_0x12351d);_0xf73629['body'][_0x5567e1](_0x201809[_0xa937('0x40')],_0x201809[_0xa937('0x41')][_0xa937('0x42')],_0x201809[_0xa937('0x41')]['end']);break;}}}return _0xf73629;}function parseModelFields(_0x11d903,_0x1a926a,_0x19a8ba){var _0x1a2e20=utils[_0xa937('0x6')](_0x11d903);var _0x452c49=squel[_0xa937('0x23')]();var _0x3fe9ab=_(_0x1a926a)[_0xa937('0x53')]()[_0xa937('0x1a')](function(_0x52bfa5){return _[_0xa937('0x54')](_0x19a8ba,[_0xa937('0xb'),_0x52bfa5])?_0x52bfa5:undefined;})['compact']()[_0xa937('0x41')]();if(_0x3fe9ab[_0xa937('0x3b')]>0x0){_0x3fe9ab[_0xa937('0x25')](function(_0x5714a6){if(_0x5714a6===_0x1a2e20){_0x452c49[_0xa937('0x45')]('i.'+_0x1a2e20+_0xa937('0x19'),[][_0xa937('0x55')](_0x1a926a[_0x5714a6]));}else if(_0x5714a6===_0xa937('0x56')){var _0x51ae7a=JSON['parse'](_0x1a926a[_0x5714a6])['$gte'];var _0x3eaa90=JSON[_0xa937('0x57')](_0x1a926a[_0x5714a6])[_0xa937('0x58')];_0x452c49[_0xa937('0x45')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x51ae7a,_0x3eaa90);}else{if(_0x1a926a[_0x5714a6]===_0xa937('0x59')){_0x452c49['and']('i.'+_0x5714a6+_0xa937('0x5a'));}else{_0x452c49[_0xa937('0x45')]('i.'+_0x5714a6+_0xa937('0x5b'),_0x1a926a[_0x5714a6]);}}});}return _0x452c49;}function parseQueryParameters(_0x5c8912,_0x830dd4,_0x318aa1){var _0x168cdb=getSqlClauses();return Promise['resolve']()[_0xa937('0x5c')](function(){return parseModelFields(_0x5c8912,_0x830dd4,_0x318aa1);})[_0xa937('0x5c')](function(_0x3a9195){_0x168cdb['fields']['and'](_0x3a9195);return parseReadParameter(_0x830dd4[_0xa937('0x44')]);})['then'](function(_0x223946){_0x168cdb[_0xa937('0x44')][_0xa937('0x45')](_0x223946);return parseTagParameter(_0x830dd4[_0xa937('0x5d')]);})['then'](function(_0x786229){_0x168cdb[_0xa937('0x4c')][_0xa937('0x4d')][_0xa937('0x45')](_0x786229);return parseSearchFilter(_0x5c8912,_0x830dd4[_0xa937('0x5e')]);})[_0xa937('0x5c')](function(_0x439c2b){_0x168cdb['filter']=_0x439c2b;return _0x168cdb;});}function checkAccountsRestrictions(_0x2e0236,_0x1cd41a,_0x485edc){var _0x41e64e=utils['getAccountFK'](_0x2e0236);var _0x4403c5=_0xa937('0x5f')+_['capitalize'](_0x2e0236)+(_0x2e0236===_0xa937('0x60')?_0xa937('0x61'):_0xa937('0x62'));var _0x37adbd=squel['expr']();return Promise[_0xa937('0x63')]()[_0xa937('0x5c')](function(){if(_0x485edc[_0xa937('0x8')]&&_0x1cd41a[_0xa937('0x64')]===_0xa937('0x7')){return _0x1cd41a[_0x4403c5]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x4c928f){if(_0x4c928f){if(_0x4c928f[_0xa937('0x3b')]===0x0){_0x37adbd['and']('i.'+_0x41e64e+_0xa937('0x5a'));}else{_0x37adbd['and']('i.'+_0x41e64e+_0xa937('0x19'),_[_0xa937('0x1a')](_0x4c928f,'id'));}}else if(!_0x485edc[_0x41e64e]){_0x37adbd[_0xa937('0x45')]('i.'+_0x41e64e+'\x20IS\x20NOT\x20NULL');}})[_0xa937('0x5c')](function(){return _0x37adbd;});}function getClosedOrderClause(_0x319ed8,_0x595781){var _0x5cc310='';var _0x3c39b6=[_0xa937('0x65'),_0xa937('0x66'),_0xa937('0x67')];if(_0x319ed8===_0xa937('0x32')){_0x3c39b6[_0xa937('0x68')](_0xa937('0x69'));}if(_0x595781[_0xa937('0x6a')]==='0'&&_0x319ed8===_0xa937('0x32')){_0x5cc310=_0xa937('0x69');}else{if(_0x595781['closed']==='1'){_0x3c39b6['shift']();}_0x5cc310=_0xa937('0x6b')+_0x3c39b6[_0xa937('0x6c')](',\x20')+')';}return _0x5cc310;}function getFilteredInteractions(_0x546f9f,_0x381a5f,_0x2ca2dd,_0x385fa3){var _0x4674cc=utils['getInteractionFK'](_0x546f9f);var _0x3a359c=_['capitalize'](_0x546f9f)+_0xa937('0x6d');var _0x4722b2=[];var _0x3cb5de=getTagsQuery();var _0x1c562a={'type':db[_0xa937('0x6e')][_0xa937('0x6f')][_0xa937('0x70')],'raw':!![]};var _0x188337=[];var _0x4e53d2=[];return db[_0xa937('0x71')][_0xa937('0x72')](_0x3cb5de[_0xa937('0x73')](),_0x1c562a)[_0xa937('0x5c')](function(_0x9734a9){_0x4722b2=_[_0xa937('0x74')](_0x9734a9,'id');_0x1c562a=_[_0xa937('0x75')](_0x1c562a,{'model':db[_0x3a359c],'mapToModel':!![],'nest':!![]});if(_0x2ca2dd[_0xa937('0x76')]){_0x385fa3[_0xa937('0x77')][_0xa937('0x25')](function(_0x160f11){_0x381a5f['field']('i.'+_0x160f11);});}else{_0x381a5f[_0xa937('0xa')](_0xa937('0x78'),_0xa937('0x79'));_0x381a5f[_0xa937('0xa')]('a.key',_0xa937('0x7a'));_0x381a5f[_0xa937('0xa')](_0xa937('0x7b'),'Account.mandatoryDisposition');if(_0x546f9f===_0xa937('0x32')){_0x381a5f[_0xa937('0xa')](_0xa937('0x7c'),_0xa937('0x7d'));_0x381a5f[_0xa937('0xa')]('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',_0xa937('0x7e'));_0x381a5f['field']('i.id');_0x381a5f[_0xa937('0xa')]('i.createdAt');_0x381a5f['field'](_0xa937('0x7f'));_0x381a5f[_0xa937('0xa')](_0xa937('0x80'));_0x381a5f[_0xa937('0xa')](_0xa937('0x81'));_0x381a5f[_0xa937('0xa')](_0xa937('0x82'));_0x381a5f['field']('i.lastMsgAt');_0x381a5f[_0xa937('0xa')](_0xa937('0x83'));_0x381a5f['field']('i.subject');_0x381a5f['field'](_0xa937('0x67'));_0x381a5f[_0xa937('0xa')](_0xa937('0x66'));_0x381a5f['field'](_0xa937('0x65'));_0x381a5f[_0xa937('0xa')](_0xa937('0x69'));_0x381a5f[_0xa937('0xa')]('i.to');_0x381a5f[_0xa937('0xa')]('i.ContactId');_0x381a5f[_0xa937('0xa')](_0xa937('0x84'));_0x381a5f[_0xa937('0xa')]('i.UserId');}else if(_0x546f9f===_0xa937('0x2e')){_0x381a5f[_0xa937('0xa')](_0xa937('0x85'),'contactName');}else{_0x381a5f['field'](_0xa937('0x86'),_0xa937('0x7e'));}if(_0x546f9f!==_0xa937('0x32')){_0x381a5f['field'](_0xa937('0x87'));}_0x381a5f[_0xa937('0xa')](_0xa937('0x88'),'Contact.firstName');_0x381a5f[_0xa937('0xa')](_0xa937('0x89'),'Contact.lastName');_0x381a5f[_0xa937('0xa')]('c.email',_0xa937('0x8a'));_0x381a5f[_0xa937('0xa')](_0xa937('0x8b'),_0xa937('0x8c'));_0x381a5f[_0xa937('0xa')](_0xa937('0x8d'),_0xa937('0x8e'));_0x381a5f[_0xa937('0xa')](_0xa937('0x8f'),'Contact.fax');_0x381a5f[_0xa937('0xa')]('o.fullname',_0xa937('0x90'));_0x381a5f[_0xa937('0xa')](_0xa937('0x91'),_0xa937('0x92'));_0x381a5f['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0xa937('0x93'));}if(_0x385fa3['limit']){_0x381a5f['limit'](_0x385fa3[_0xa937('0x94')]);}if(_0x385fa3[_0xa937('0x95')]){_0x381a5f[_0xa937('0x95')](_0x385fa3[_0xa937('0x95')]);}return db[_0xa937('0x71')][_0xa937('0x72')](_0x381a5f[_0xa937('0x73')](),_0x1c562a);})[_0xa937('0x5c')](function(_0x557d6c){_0x188337=_0x557d6c;var _0x3b817f=getUsersQuery(_0x546f9f,_0x188337);return db[_0xa937('0x71')][_0xa937('0x72')](_0x3b817f[_0xa937('0x73')](),_0x1c562a);})[_0xa937('0x5c')](function(_0x1da7e2){_0x4e53d2=_[_0xa937('0x96')](_0x1da7e2,_0x4674cc);if(_0x546f9f===_0xa937('0x32')){return db[_0xa937('0x97')][_0xa937('0x98')]({'attributes':[_0xa937('0x99')],'raw':!![]});}})[_0xa937('0x5c')](function(_0x5c7bf7){var _0x4dab7b=_0x5c7bf7?_0x5c7bf7['enableEmailPreview']:undefined;var _0x4a9be8=_0x188337[_0xa937('0x1a')](function(_0x30a8bf){return updateInteraction(_0x30a8bf,_0x4722b2,_0x4e53d2,_0x4dab7b);});return Promise[_0xa937('0x9a')](_0x4a9be8);});}function countFilteredInteractions(_0x56cc53,_0x1caa71){var _0x2aa256=_0x56cc53['clone']();_0x2aa256['field'](_0xa937('0x9b'));_0x2aa256['field'](_0xa937('0x78'),_0xa937('0x79'));var _0x10008c=utils[_0xa937('0x24')](_0x1caa71);if(!_['isEmpty'](_0x10008c)){_0x2aa256[_0xa937('0x18')](_0xa937('0x9c'),_0x10008c);}var _0x4320e9={'type':db[_0xa937('0x6e')][_0xa937('0x6f')][_0xa937('0x70')],'raw':!![]};return db['sequelize'][_0xa937('0x72')](_0x2aa256['toString'](),_0x4320e9);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0xc963=['Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','groupBy','Setting','all','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','isEmpty','t.id\x20IN\x20?','Sequelize','QueryTypes','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','updateInteraction','./utils','../../mysqldb','getAccountFK','role','search','select','field','name','color','tools_tags','user_has_','_interactions','u.id','u.fullname','ui.','from','length','where','\x20IN\x20?','map','getInteractionsTables','getInteractionFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','left_join','users','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','me.','\x20=\x20i.id','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','isEmail','mail','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)','sqlOperator','conditions','find','default','value','end','unreadMessages','read','and','operator','$substring','split','contact','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','ContactId','buildExpression','type','text','Tag','tags','clause','ids','User','user','UserId','start','body','plainBody','keys','some','compact','concat','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','tag','filter','get','capitalize','chat','Websites','agent','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','SELECT','sequelize','query','toString','merge','fields','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','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','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','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.phone','c.mobile'];(function(_0x35d4e9,_0x298c61){var _0x5c2770=function(_0x2f326a){while(--_0x2f326a){_0x35d4e9['push'](_0x35d4e9['shift']());}};_0x5c2770(++_0x298c61);}(_0xc963,0xbf));var _0x3c96=function(_0x36f243,_0x188505){_0x36f243=_0x36f243-0x0;var _0x426436=_0xc963[_0x36f243];return _0x426436;};'use strict';var _=require(_0x3c96('0x0'));var squel=require(_0x3c96('0x1'));var as=require(_0x3c96('0x2'));var qs=require(_0x3c96('0x3'));var updateInteraction=require('./update-interaction')[_0x3c96('0x4')];var utils=require(_0x3c96('0x5'));var db=require(_0x3c96('0x6'))['db'];function skipInteractionsQuery(_0x535b5b,_0x232c50,_0x12da48){var _0x5b1a5e=![];var _0x148c37=utils[_0x3c96('0x7')](_0x535b5b);if(_0x232c50[_0x3c96('0x8')]==='agent'&&!_0x12da48[_0x3c96('0x9')]&&!_0x12da48[_0x148c37]){_0x5b1a5e=!![];}return _0x5b1a5e;}function getTagsQuery(){return squel[_0x3c96('0xa')]()[_0x3c96('0xb')]('id')[_0x3c96('0xb')](_0x3c96('0xc'))['field'](_0x3c96('0xd'))['from'](_0x3c96('0xe'));}function getUsersQuery(_0x4429e3,_0x1ae4c0){var _0x280651=utils['getInteractionFK'](_0x4429e3);var _0x3bdccb=_0x3c96('0xf')+_0x4429e3+_0x3c96('0x10');var _0xeb9026=squel[_0x3c96('0xa')]()[_0x3c96('0xb')](_0x3c96('0x11'))[_0x3c96('0xb')](_0x3c96('0x12'))[_0x3c96('0xb')](_0x3c96('0x13')+_0x280651)[_0x3c96('0x14')](_0x3bdccb,'ui')['left_join']('users','u','u.id\x20=\x20ui.UserId');if(_0x1ae4c0[_0x3c96('0x15')]>0x0){_0xeb9026[_0x3c96('0x16')](_0x3c96('0x13')+_0x280651+_0x3c96('0x17'),_[_0x3c96('0x18')](_0x1ae4c0,'id'));}return _0xeb9026;}function getInteractionsQuery(_0x4776e4){var _0x77aa3b=utils[_0x3c96('0x19')](_0x4776e4);var _0x24229a=utils[_0x3c96('0x7')](_0x4776e4);var _0x21f18a=utils[_0x3c96('0x1a')](_0x4776e4);return squel[_0x3c96('0xa')]()['from'](_0x77aa3b[_0x3c96('0x1b')],'i')['left_join'](_0x3c96('0x1c'),'c',_0x3c96('0x1d'))[_0x3c96('0x1e')](_0x3c96('0x1f'),'o',_0x3c96('0x20'))[_0x3c96('0x1e')](_0x77aa3b[_0x3c96('0x21')],'a',_0x3c96('0x22')+_0x24229a)[_0x3c96('0x1e')](_0x77aa3b['messages'],'me',_0x3c96('0x23')+_0x21f18a+_0x3c96('0x24'))['left_join'](_0x77aa3b['interactionsTags'],'it',_0x3c96('0x25')+_0x21f18a+'\x20=\x20i.id')['left_join'](_0x3c96('0xe'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x15ea9e={'body':squel[_0x3c96('0x26')](),'contact':squel[_0x3c96('0x26')](),'default':squel[_0x3c96('0x26')](),'fields':squel[_0x3c96('0x26')](),'filter':squel[_0x3c96('0x26')](),'read':squel[_0x3c96('0x26')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x3c96('0x26')]()};return _0x15ea9e;}function parseTagParameter(_0x41d174){var _0x1069b0=squel[_0x3c96('0x26')]();if(_0x41d174){var _0xa510f7=utils[_0x3c96('0x27')](_0x41d174);_0xa510f7[_0x3c96('0x28')](function(_0x9a403){_0x1069b0['or'](_0x3c96('0x29'),'%,'+_0x9a403+',%');});}return _0x1069b0;}function parseReadParameter(_0x3d3094){var _0x11d60f='';if(_0x3d3094){_0x11d60f=_0x3c96('0x2a');if(_0x3d3094==='1'){_0x11d60f=_0x11d60f[_0x3c96('0x2b')]('{OPERATOR}','=');}else{_0x11d60f=_0x11d60f[_0x3c96('0x2b')](_0x3c96('0x2c'),'>');}}return _0x11d60f;}function parseSearchFilter(_0xdbef53,_0x5a4fc0){var _0x51bffd=squel[_0x3c96('0x26')]();if(_0x5a4fc0){var _0x484683=_0x5a4fc0[_0x3c96('0x2b')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs['isNumeric'](_0x484683)){_0x51bffd['or'](_0x3c96('0x2d'),_0x484683+'%');if([_0x3c96('0x2e'),_0x3c96('0x2f')]['includes'](_0xdbef53)){_0x51bffd['or'](_0x3c96('0x30'),_0x484683+'%');}else if(_0xdbef53===_0x3c96('0x31')){_0x51bffd['or'](_0x3c96('0x32'),_0x484683+'%');}else if(_0xdbef53===_0x3c96('0x33')){_0x51bffd['or'](_0x3c96('0x34'),_0x484683+'%');}}else if(_0xdbef53==='mail'&&qs[_0x3c96('0x35')](_0x484683)){_0x51bffd['or']('c.email\x20LIKE\x20?',_0x484683+'%');}else{if(_0xdbef53===_0x3c96('0x36')){_0x51bffd['or'](_0x3c96('0x37'),qs[_0x3c96('0x38')](_0x484683,!![]))['or'](_0x3c96('0x39'),qs[_0x3c96('0x38')](_0x484683));}else if(_0xdbef53!==_0x3c96('0x31')){_0x51bffd['or'](_0x3c96('0x3a'),qs[_0x3c96('0x38')](_0x484683));}_0x51bffd['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x3c96('0x38')](_0x484683,!![]),null);}}return _0x51bffd;}function parseAdvancedSearchFilter(_0x21542e,_0x2b09ab){var _0x3de53b=getSqlClauses();var _0x2f1145=as['parseSearch'](_0x21542e);var _0x1265bb=_0x2f1145[_0x3c96('0x3b')];for(var _0x546b97=0x0;_0x546b97<_0x2f1145[_0x3c96('0x3c')][_0x3c96('0x15')];_0x546b97++){var _0x38600e=_0x2f1145[_0x3c96('0x3c')][_0x546b97];var _0x7c0852='i';var _0x4215e8=_[_0x3c96('0x3d')](_0x2b09ab,['name',_0x38600e[_0x3c96('0xb')]]);if(_0x4215e8){var _0x7cb0d7=as['buildExpression'](_0x7c0852,_0x4215e8['type'],_0x38600e);_0x3de53b[_0x3c96('0x3e')][_0x1265bb](_0x7cb0d7['text'],_0x7cb0d7[_0x3c96('0x3f')]['start'],_0x7cb0d7[_0x3c96('0x3f')][_0x3c96('0x40')]);}else{switch(_0x38600e[_0x3c96('0xb')]){case _0x3c96('0x41'):var _0x41092f=parseReadParameter(_0x38600e[_0x3c96('0x3f')]);_0x3de53b[_0x3c96('0x42')][_0x3c96('0x43')](_0x41092f);break;case'Contact':if(_0x38600e[_0x3c96('0x44')]===_0x3c96('0x45')){if(_0x38600e[_0x3c96('0x3f')][_0x3c96('0x46')]('\x20')[_0x3c96('0x15')]>0x1){_0x3de53b[_0x3c96('0x47')][_0x1265bb](_0x3c96('0x48'),qs['getFullTextValue'](_0x38600e[_0x3c96('0x3f')],!![]),null);}else{var _0x22c6b8='%'+_0x38600e['value']+'%';_0x3de53b[_0x3c96('0x47')][_0x1265bb]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x22c6b8,_0x22c6b8,_0x22c6b8);}}else{_0x4215e8=_[_0x3c96('0x3d')](_0x2b09ab,[_0x3c96('0xc'),_0x3c96('0x49')]);_0x38600e[_0x3c96('0xb')]='ContactId';_0x7cb0d7=as[_0x3c96('0x4a')](_0x7c0852,_0x4215e8[_0x3c96('0x4b')],_0x38600e);_0x3de53b[_0x3c96('0x47')][_0x1265bb](_0x7cb0d7[_0x3c96('0x4c')],_0x7cb0d7[_0x3c96('0x3f')]['start'],_0x7cb0d7['value'][_0x3c96('0x40')]);}break;case _0x3c96('0x4d'):var _0x25da80=_0x38600e[_0x3c96('0x3f')]['split'](',')[_0x3c96('0x18')](function(_0x798b96){return Number(_0x798b96);});var _0x1826b3=parseTagParameter(_0x25da80);_0x3de53b[_0x3c96('0x4e')][_0x3c96('0x4f')][_0x3c96('0x43')](_0x1826b3);_0x3de53b[_0x3c96('0x4e')][_0x3c96('0x50')]=_0x25da80;break;case _0x3c96('0x51'):if(_0x38600e[_0x3c96('0x44')]===_0x3c96('0x45')){_0x3de53b[_0x3c96('0x52')][_0x1265bb]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x38600e['value']+'%',null);}else{_0x4215e8=_[_0x3c96('0x3d')](_0x2b09ab,[_0x3c96('0xc'),'UserId']);_0x38600e[_0x3c96('0xb')]=_0x3c96('0x53');_0x7cb0d7=as[_0x3c96('0x4a')](_0x7c0852,_0x4215e8[_0x3c96('0x4b')],_0x38600e);_0x3de53b['user'][_0x1265bb](_0x7cb0d7[_0x3c96('0x4c')],_0x7cb0d7['value'][_0x3c96('0x54')],_0x7cb0d7['value'][_0x3c96('0x40')]);}break;case _0x3c96('0x55'):case _0x3c96('0x56'):_0x7cb0d7=as[_0x3c96('0x4a')]('me',null,_0x38600e);_0x3de53b[_0x3c96('0x55')][_0x1265bb](_0x7cb0d7[_0x3c96('0x4c')],_0x7cb0d7[_0x3c96('0x3f')][_0x3c96('0x54')],_0x7cb0d7['value'][_0x3c96('0x40')]);break;}}}return _0x3de53b;}function parseModelFields(_0x5613a4,_0x500db2,_0x24ed49){var _0xb86b9f=utils[_0x3c96('0x7')](_0x5613a4);var _0x2334d1=squel[_0x3c96('0x26')]();var _0x39140f=_(_0x500db2)[_0x3c96('0x57')]()[_0x3c96('0x18')](function(_0x5b1c9e){return _[_0x3c96('0x58')](_0x24ed49,['name',_0x5b1c9e])?_0x5b1c9e:undefined;})[_0x3c96('0x59')]()[_0x3c96('0x3f')]();if(_0x39140f[_0x3c96('0x15')]>0x0){_0x39140f['forEach'](function(_0x2c9245){if(_0x2c9245===_0xb86b9f){_0x2334d1['and']('i.'+_0xb86b9f+'\x20IN\x20?',[][_0x3c96('0x5a')](_0x500db2[_0x2c9245]));}else if(_0x2c9245==='createdAt'){var _0x4fa6e4=JSON[_0x3c96('0x5b')](_0x500db2[_0x2c9245])[_0x3c96('0x5c')];var _0x30a885=JSON[_0x3c96('0x5b')](_0x500db2[_0x2c9245])[_0x3c96('0x5d')];_0x2334d1[_0x3c96('0x43')](_0x3c96('0x5e'),_0x4fa6e4,_0x30a885);}else{if(_0x500db2[_0x2c9245]===_0x3c96('0x5f')){_0x2334d1[_0x3c96('0x43')]('i.'+_0x2c9245+_0x3c96('0x60'));}else{_0x2334d1[_0x3c96('0x43')]('i.'+_0x2c9245+_0x3c96('0x61'),_0x500db2[_0x2c9245]);}}});}return _0x2334d1;}function parseQueryParameters(_0x3eeca3,_0x42ca1f,_0x4353a0){var _0x14e37b=getSqlClauses();return Promise[_0x3c96('0x62')]()[_0x3c96('0x63')](function(){return parseModelFields(_0x3eeca3,_0x42ca1f,_0x4353a0);})[_0x3c96('0x63')](function(_0x20a724){_0x14e37b['fields'][_0x3c96('0x43')](_0x20a724);return parseReadParameter(_0x42ca1f[_0x3c96('0x42')]);})[_0x3c96('0x63')](function(_0x4911ac){_0x14e37b['read']['and'](_0x4911ac);return parseTagParameter(_0x42ca1f[_0x3c96('0x64')]);})[_0x3c96('0x63')](function(_0x2ad71c){_0x14e37b[_0x3c96('0x4e')][_0x3c96('0x4f')][_0x3c96('0x43')](_0x2ad71c);return parseSearchFilter(_0x3eeca3,_0x42ca1f[_0x3c96('0x65')]);})[_0x3c96('0x63')](function(_0x597637){_0x14e37b[_0x3c96('0x65')]=_0x597637;return _0x14e37b;});}function checkAccountsRestrictions(_0x3d15e0,_0x41951d,_0x1dfea7){var _0x1c6897=utils[_0x3c96('0x7')](_0x3d15e0);var _0x16c337=_0x3c96('0x66')+_[_0x3c96('0x67')](_0x3d15e0)+(_0x3d15e0===_0x3c96('0x68')?_0x3c96('0x69'):'Accounts');var _0x2f7570=squel[_0x3c96('0x26')]();return Promise[_0x3c96('0x62')]()[_0x3c96('0x63')](function(){if(_0x1dfea7['search']&&_0x41951d[_0x3c96('0x8')]===_0x3c96('0x6a')){return _0x41951d[_0x16c337]({'attributes':['id'],'raw':!![]});}})[_0x3c96('0x63')](function(_0x2cbd8a){if(_0x2cbd8a){if(_0x2cbd8a[_0x3c96('0x15')]===0x0){_0x2f7570[_0x3c96('0x43')]('i.'+_0x1c6897+_0x3c96('0x60'));}else{_0x2f7570[_0x3c96('0x43')]('i.'+_0x1c6897+'\x20IN\x20?',_['map'](_0x2cbd8a,'id'));}}else if(!_0x1dfea7[_0x1c6897]){_0x2f7570[_0x3c96('0x43')]('i.'+_0x1c6897+'\x20IS\x20NOT\x20NULL');}})[_0x3c96('0x63')](function(){return _0x2f7570;});}function getClosedOrderClause(_0x57e90f,_0x920341){var _0x3cc284='';var _0x1e3461=[_0x3c96('0x6b'),_0x3c96('0x6c'),_0x3c96('0x6d')];if(_0x57e90f==='mail'){_0x1e3461[_0x3c96('0x6e')](_0x3c96('0x6f'));}if(_0x920341[_0x3c96('0x70')]==='0'&&_0x57e90f===_0x3c96('0x36')){_0x3cc284='i.substatus';}else{if(_0x920341[_0x3c96('0x70')]==='1'){_0x1e3461[_0x3c96('0x71')]();}_0x3cc284=_0x3c96('0x72')+_0x1e3461[_0x3c96('0x73')](',\x20')+')';}return _0x3cc284;}function getFilteredInteractions(_0x3c3c16,_0xbfd684,_0x33928b,_0x4506a6){var _0x24c224=utils[_0x3c96('0x1a')](_0x3c3c16);var _0x39d0ea=_[_0x3c96('0x67')](_0x3c3c16)+_0x3c96('0x74');var _0x4cad93=[];var _0x27feb3=getTagsQuery();var _0x162e1a={'type':db['Sequelize']['QueryTypes'][_0x3c96('0x75')],'raw':!![]};var _0x155ef6=[];var _0x130d90=[];return db[_0x3c96('0x76')][_0x3c96('0x77')](_0x27feb3[_0x3c96('0x78')](),_0x162e1a)[_0x3c96('0x63')](function(_0x481b88){_0x4cad93=_['keyBy'](_0x481b88,'id');_0x162e1a=_[_0x3c96('0x79')](_0x162e1a,{'model':db[_0x39d0ea],'mapToModel':!![],'nest':!![]});if(_0x33928b[_0x3c96('0x7a')]){_0x4506a6['attributes'][_0x3c96('0x28')](function(_0x26471d){_0xbfd684['field']('i.'+_0x26471d);});}else{_0xbfd684[_0x3c96('0xb')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x3c96('0x41'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x7b'),_0x3c96('0x7c'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x7d'),_0x3c96('0x7e'));if(_0x3c3c16==='mail'){_0xbfd684[_0x3c96('0xb')]('a.email',_0x3c96('0x7f'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x80'),_0x3c96('0x81'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x82'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x83'));_0xbfd684['field'](_0x3c96('0x84'));_0xbfd684['field'](_0x3c96('0x85'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x86'));_0xbfd684['field'](_0x3c96('0x87'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x88'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x89'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8a'));_0xbfd684['field'](_0x3c96('0x6d'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x6c'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x6b'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x6f'));_0xbfd684[_0x3c96('0xb')]('i.to');_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8b'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8c'));_0xbfd684['field'](_0x3c96('0x8d'));}else if(_0x3c3c16===_0x3c96('0x33')){_0xbfd684[_0x3c96('0xb')](_0x3c96('0x8e'),_0x3c96('0x81'));}else{_0xbfd684[_0x3c96('0xb')]('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',_0x3c96('0x81'));}if(_0x3c3c16!=='mail'){_0xbfd684[_0x3c96('0xb')]('i.*');}_0xbfd684[_0x3c96('0xb')]('c.firstName',_0x3c96('0x8f'));_0xbfd684['field'](_0x3c96('0x90'),_0x3c96('0x91'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x92'),'Contact.email');_0xbfd684[_0x3c96('0xb')]('c.phone',_0x3c96('0x93'));_0xbfd684['field'](_0x3c96('0x94'),_0x3c96('0x95'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x96'),_0x3c96('0x97'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x98'),_0x3c96('0x99'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x9a'),_0x3c96('0x9b'));_0xbfd684[_0x3c96('0xb')](_0x3c96('0x9c'),_0x3c96('0x9d'));}if(_0x4506a6[_0x3c96('0x9e')]){_0xbfd684['limit'](_0x4506a6[_0x3c96('0x9e')]);}if(_0x4506a6[_0x3c96('0x9f')]){_0xbfd684[_0x3c96('0x9f')](_0x4506a6['offset']);}return db[_0x3c96('0x76')]['query'](_0xbfd684[_0x3c96('0x78')](),_0x162e1a);})[_0x3c96('0x63')](function(_0x1023ea){_0x155ef6=_0x1023ea;var _0x5a5b9b=getUsersQuery(_0x3c3c16,_0x155ef6);return db['sequelize']['query'](_0x5a5b9b[_0x3c96('0x78')](),_0x162e1a);})['then'](function(_0x40a2f5){_0x130d90=_[_0x3c96('0xa0')](_0x40a2f5,_0x24c224);if(_0x3c3c16===_0x3c96('0x36')){return db[_0x3c96('0xa1')]['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x3c96('0x63')](function(_0x34782e){var _0x524d10=_0x34782e?_0x34782e['enableEmailPreview']:undefined;var _0x5eb71=_0x155ef6[_0x3c96('0x18')](function(_0x62a461){return updateInteraction(_0x62a461,_0x4cad93,_0x130d90,_0x524d10);});return Promise[_0x3c96('0xa2')](_0x5eb71);});}function countFilteredInteractions(_0x558309,_0x586703){var _0x30a5bb=_0x558309['clone']();_0x30a5bb[_0x3c96('0xb')](_0x3c96('0xa3'));_0x30a5bb[_0x3c96('0xb')](_0x3c96('0xa4'),_0x3c96('0x41'));var _0x2319ba=utils[_0x3c96('0x27')](_0x586703);if(!_[_0x3c96('0xa5')](_0x2319ba)){_0x30a5bb['where'](_0x3c96('0xa6'),_0x2319ba);}var _0x11fcab={'type':db[_0x3c96('0xa7')][_0x3c96('0xa8')][_0x3c96('0x75')],'raw':!![]};return db[_0x3c96('0x76')][_0x3c96('0x77')](_0x30a5bb[_0x3c96('0x78')](),_0x11fcab);}module[_0x3c96('0xa9')]={'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