// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x39c5=['QueryTypes','SELECT','sequelize','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','Account.email','contactName','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.thirdDisposition','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','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','o.fullname','o.internal','Owner.internal','TagIds','limit','offset','groupBy','Setting','enableEmailPreview','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','../../mysqldb','getAccountFK','role','agent','search','field','name','color','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionsTables','select','interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','a.id\x20=\x20i.','me.','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}','whatsapp','includes','i.phone\x20LIKE\x20?','fax','openchannel','i.from\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','mail','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','find','buildExpression','type','default','text','value','end','and','Contact','operator','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','Tag','clause','tags','ids','$substring','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','start','body','keys','some','compact','concat','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','then','fields','read','filter','get','capitalize','chat','Websites','Accounts','resolve','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Sequelize'];(function(_0x2d2919,_0x572aec){var _0x49cd11=function(_0x2df841){while(--_0x2df841){_0x2d2919['push'](_0x2d2919['shift']());}};_0x49cd11(++_0x572aec);}(_0x39c5,0x193));var _0x539c=function(_0x51ed62,_0x574379){_0x51ed62=_0x51ed62-0x0;var _0x34aee3=_0x39c5[_0x51ed62];return _0x34aee3;};'use strict';var _=require('lodash');var squel=require(_0x539c('0x0'));var as=require(_0x539c('0x1'));var qs=require(_0x539c('0x2'));var updateInteraction=require(_0x539c('0x3'))[_0x539c('0x4')];var utils=require('./utils');var db=require(_0x539c('0x5'))['db'];function skipInteractionsQuery(_0x56521f,_0x8b63e1,_0x101731){var _0x586acc=![];var _0x28ca57=utils[_0x539c('0x6')](_0x56521f);if(_0x8b63e1[_0x539c('0x7')]===_0x539c('0x8')&&!_0x101731[_0x539c('0x9')]&&!_0x101731[_0x28ca57]){_0x586acc=!![];}return _0x586acc;}function getTagsQuery(){return squel['select']()[_0x539c('0xa')]('id')['field'](_0x539c('0xb'))[_0x539c('0xa')](_0x539c('0xc'))['from'](_0x539c('0xd'));}function getUsersQuery(_0x29190e,_0xb9f860){var _0x4c7d74=utils[_0x539c('0xe')](_0x29190e);var _0x20a41e=_0x539c('0xf')+_0x29190e+_0x539c('0x10');var _0x8d2726=squel['select']()[_0x539c('0xa')](_0x539c('0x11'))[_0x539c('0xa')](_0x539c('0x12'))[_0x539c('0xa')](_0x539c('0x13')+_0x4c7d74)['from'](_0x20a41e,'ui')['left_join'](_0x539c('0x14'),'u',_0x539c('0x15'));if(_0xb9f860[_0x539c('0x16')]>0x0){_0x8d2726[_0x539c('0x17')](_0x539c('0x13')+_0x4c7d74+_0x539c('0x18'),_[_0x539c('0x19')](_0xb9f860,'id'));}return _0x8d2726;}function getInteractionsQuery(_0x5171fc){var _0x3fa841=utils[_0x539c('0x1a')](_0x5171fc);var _0x3ce906=utils['getAccountFK'](_0x5171fc);var _0x5b9c24=utils[_0x539c('0xe')](_0x5171fc);return squel[_0x539c('0x1b')]()['from'](_0x3fa841[_0x539c('0x1c')],'i')[_0x539c('0x1d')](_0x539c('0x1e'),'c',_0x539c('0x1f'))[_0x539c('0x1d')](_0x539c('0x14'),'o',_0x539c('0x20'))[_0x539c('0x1d')](_0x3fa841['accounts'],'a',_0x539c('0x21')+_0x3ce906)[_0x539c('0x1d')](_0x3fa841['messages'],'me',_0x539c('0x22')+_0x5b9c24+'\x20=\x20i.id')['left_join'](_0x3fa841[_0x539c('0x23')],'it','it.'+_0x5b9c24+_0x539c('0x24'))[_0x539c('0x1d')](_0x539c('0xd'),'t',_0x539c('0x25'));}function getSqlClauses(){var _0x223ca6={'body':squel['expr'](),'contact':squel[_0x539c('0x26')](),'default':squel[_0x539c('0x26')](),'fields':squel['expr'](),'filter':squel[_0x539c('0x26')](),'read':squel[_0x539c('0x26')](),'tags':{'clause':squel[_0x539c('0x26')](),'ids':null},'user':squel[_0x539c('0x26')]()};return _0x223ca6;}function parseTagParameter(_0x2732e0){var _0x7e9739=squel[_0x539c('0x26')]();if(_0x2732e0){var _0xde2cb6=utils[_0x539c('0x27')](_0x2732e0);_0xde2cb6[_0x539c('0x28')](function(_0x8ff4c2){_0x7e9739['or'](_0x539c('0x29'),'%,'+_0x8ff4c2+',%');});}return _0x7e9739;}function parseReadParameter(_0x956c9e){var _0x4c01e8='';if(_0x956c9e){_0x4c01e8=_0x539c('0x2a');if(_0x956c9e==='1'){_0x4c01e8=_0x4c01e8[_0x539c('0x2b')](_0x539c('0x2c'),'=');}else{_0x4c01e8=_0x4c01e8[_0x539c('0x2b')](_0x539c('0x2c'),'>');}}return _0x4c01e8;}function parseSearchFilter(_0x4afb61,_0x523097){var _0x45df2c=squel[_0x539c('0x26')]();if(_0x523097){var _0x4ae45d=_0x523097[_0x539c('0x2b')]('\x5c','\x5c\x5c')[_0x539c('0x2b')](/'/g,'\x27\x27');if(qs['isNumeric'](_0x4ae45d)){_0x45df2c['or']('i.id\x20LIKE\x20?',_0x4ae45d+'%');if(['sms',_0x539c('0x2d')][_0x539c('0x2e')](_0x4afb61)){_0x45df2c['or'](_0x539c('0x2f'),_0x4ae45d+'%');}else if(_0x4afb61===_0x539c('0x30')){_0x45df2c['or']('i.fax\x20LIKE\x20?',_0x4ae45d+'%');}else if(_0x4afb61===_0x539c('0x31')){_0x45df2c['or'](_0x539c('0x32'),_0x4ae45d+'%');}}else if(_0x4afb61==='mail'&&qs[_0x539c('0x33')](_0x4ae45d)){_0x45df2c['or'](_0x539c('0x34'),_0x4ae45d+'%');}else{if(_0x4afb61===_0x539c('0x35')){_0x45df2c['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x4ae45d,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x539c('0x36')](_0x4ae45d));}else if(_0x4afb61!==_0x539c('0x30')){_0x45df2c['or'](_0x539c('0x37'),qs[_0x539c('0x36')](_0x4ae45d));}_0x45df2c['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x4ae45d,!![]),null);}}return _0x45df2c;}function parseAdvancedSearchFilter(_0x4a7f63,_0x4621e9){var _0x5894fa=getSqlClauses();var _0x557fb3=as[_0x539c('0x38')](_0x4a7f63);var _0x1be20f=_0x557fb3[_0x539c('0x39')];for(var _0x5146d1=0x0;_0x5146d1<_0x557fb3[_0x539c('0x3a')]['length'];_0x5146d1++){var _0xa8cbf2=_0x557fb3[_0x539c('0x3a')][_0x5146d1];var _0x252e10='i';var _0x5bca8d=_[_0x539c('0x3b')](_0x4621e9,['name',_0xa8cbf2[_0x539c('0xa')]]);if(_0x5bca8d){var _0x533d60=as[_0x539c('0x3c')](_0x252e10,_0x5bca8d[_0x539c('0x3d')],_0xa8cbf2);_0x5894fa[_0x539c('0x3e')][_0x1be20f](_0x533d60[_0x539c('0x3f')],_0x533d60[_0x539c('0x40')]['start'],_0x533d60[_0x539c('0x40')][_0x539c('0x41')]);}else{switch(_0xa8cbf2[_0x539c('0xa')]){case'unreadMessages':var _0x2c5ba0=parseReadParameter(_0xa8cbf2[_0x539c('0x40')]);_0x5894fa['read'][_0x539c('0x42')](_0x2c5ba0);break;case _0x539c('0x43'):if(_0xa8cbf2[_0x539c('0x44')]==='$substring'){if(_0xa8cbf2[_0x539c('0x40')][_0x539c('0x45')]('\x20')[_0x539c('0x16')]>0x1){_0x5894fa['contact'][_0x1be20f](_0x539c('0x46'),qs[_0x539c('0x36')](_0xa8cbf2[_0x539c('0x40')],!![]),null);}else{var _0x56c0bc='%'+_0xa8cbf2[_0x539c('0x40')]+'%';_0x5894fa[_0x539c('0x47')][_0x1be20f](_0x539c('0x48'),_0x56c0bc,_0x56c0bc,_0x56c0bc);}}else{_0x5bca8d=_['find'](_0x4621e9,[_0x539c('0xb'),_0x539c('0x49')]);_0xa8cbf2[_0x539c('0xa')]='ContactId';_0x533d60=as[_0x539c('0x3c')](_0x252e10,_0x5bca8d[_0x539c('0x3d')],_0xa8cbf2);_0x5894fa['contact'][_0x1be20f](_0x533d60['text'],_0x533d60[_0x539c('0x40')]['start'],_0x533d60[_0x539c('0x40')][_0x539c('0x41')]);}break;case _0x539c('0x4a'):var _0x4b2148=_0xa8cbf2[_0x539c('0x40')][_0x539c('0x45')](',')[_0x539c('0x19')](function(_0x4f9d06){return Number(_0x4f9d06);});var _0x3b9e41=parseTagParameter(_0x4b2148);_0x5894fa['tags'][_0x539c('0x4b')]['and'](_0x3b9e41);_0x5894fa[_0x539c('0x4c')][_0x539c('0x4d')]=_0x4b2148;break;case'User':if(_0xa8cbf2['operator']===_0x539c('0x4e')){_0x5894fa[_0x539c('0x4f')][_0x1be20f](_0x539c('0x50'),'%'+_0xa8cbf2[_0x539c('0x40')]+'%',null);}else{_0x5bca8d=_[_0x539c('0x3b')](_0x4621e9,[_0x539c('0xb'),_0x539c('0x51')]);_0xa8cbf2['field']='UserId';_0x533d60=as['buildExpression'](_0x252e10,_0x5bca8d[_0x539c('0x3d')],_0xa8cbf2);_0x5894fa[_0x539c('0x4f')][_0x1be20f](_0x533d60[_0x539c('0x3f')],_0x533d60['value'][_0x539c('0x52')],_0x533d60['value']['end']);}break;case _0x539c('0x53'):case'plainBody':_0x533d60=as['buildExpression']('me',null,_0xa8cbf2);_0x5894fa['body'][_0x1be20f](_0x533d60[_0x539c('0x3f')],_0x533d60[_0x539c('0x40')]['start'],_0x533d60[_0x539c('0x40')]['end']);break;}}}return _0x5894fa;}function parseModelFields(_0x4bc6ca,_0x5ba263,_0xa68453){var _0x5439af=utils['getAccountFK'](_0x4bc6ca);var _0x3e0d84=squel[_0x539c('0x26')]();var _0x5ef596=_(_0x5ba263)[_0x539c('0x54')]()[_0x539c('0x19')](function(_0x28282c){return _[_0x539c('0x55')](_0xa68453,['name',_0x28282c])?_0x28282c:undefined;})[_0x539c('0x56')]()[_0x539c('0x40')]();if(_0x5ef596[_0x539c('0x16')]>0x0){_0x5ef596[_0x539c('0x28')](function(_0x34ffa9){if(_0x34ffa9===_0x5439af){_0x3e0d84[_0x539c('0x42')]('i.'+_0x5439af+_0x539c('0x18'),[][_0x539c('0x57')](_0x5ba263[_0x34ffa9]));}else if(_0x34ffa9==='createdAt'){var _0x4f866d=JSON[_0x539c('0x58')](_0x5ba263[_0x34ffa9])[_0x539c('0x59')];var _0xb3c5f4=JSON[_0x539c('0x58')](_0x5ba263[_0x34ffa9])['$lte'];_0x3e0d84[_0x539c('0x42')](_0x539c('0x5a'),_0x4f866d,_0xb3c5f4);}else{if(_0x5ba263[_0x34ffa9]===_0x539c('0x5b')){_0x3e0d84['and']('i.'+_0x34ffa9+'\x20IS\x20NULL');}else{_0x3e0d84['and']('i.'+_0x34ffa9+_0x539c('0x5c'),_0x5ba263[_0x34ffa9]);}}});}return _0x3e0d84;}function parseQueryParameters(_0xb1d99d,_0x3c51d3,_0x513553){var _0x388047=getSqlClauses();return Promise['resolve']()[_0x539c('0x5d')](function(){return parseModelFields(_0xb1d99d,_0x3c51d3,_0x513553);})[_0x539c('0x5d')](function(_0x4d5adb){_0x388047[_0x539c('0x5e')][_0x539c('0x42')](_0x4d5adb);return parseReadParameter(_0x3c51d3[_0x539c('0x5f')]);})[_0x539c('0x5d')](function(_0x2aa324){_0x388047['read']['and'](_0x2aa324);return parseTagParameter(_0x3c51d3['tag']);})['then'](function(_0x5a88af){_0x388047[_0x539c('0x4c')][_0x539c('0x4b')][_0x539c('0x42')](_0x5a88af);return parseSearchFilter(_0xb1d99d,_0x3c51d3[_0x539c('0x60')]);})[_0x539c('0x5d')](function(_0x13b354){_0x388047[_0x539c('0x60')]=_0x13b354;return _0x388047;});}function checkAccountsRestrictions(_0x2b68c2,_0x54c598,_0x30382a){var _0x1691d7=utils[_0x539c('0x6')](_0x2b68c2);var _0x49dd1f=_0x539c('0x61')+_[_0x539c('0x62')](_0x2b68c2)+(_0x2b68c2===_0x539c('0x63')?_0x539c('0x64'):_0x539c('0x65'));var _0x501d5c=squel[_0x539c('0x26')]();return Promise[_0x539c('0x66')]()[_0x539c('0x5d')](function(){if(_0x30382a[_0x539c('0x9')]&&_0x54c598[_0x539c('0x7')]==='agent'){return _0x54c598[_0x49dd1f]({'attributes':['id'],'raw':!![]});}})[_0x539c('0x5d')](function(_0x1d62f8){if(_0x1d62f8){if(_0x1d62f8[_0x539c('0x16')]===0x0){_0x501d5c[_0x539c('0x42')]('i.'+_0x1691d7+'\x20IS\x20NULL');}else{_0x501d5c[_0x539c('0x42')]('i.'+_0x1691d7+_0x539c('0x18'),_['map'](_0x1d62f8,'id'));}}else if(!_0x30382a[_0x1691d7]){_0x501d5c['and']('i.'+_0x1691d7+_0x539c('0x67'));}})[_0x539c('0x5d')](function(){return _0x501d5c;});}function getClosedOrderClause(_0x497870,_0x18b1c1){var _0x31f2bb='';var _0x5550f9=['i.thirdDisposition',_0x539c('0x68'),_0x539c('0x69')];if(_0x497870===_0x539c('0x35')){_0x5550f9[_0x539c('0x6a')](_0x539c('0x6b'));}if(_0x18b1c1[_0x539c('0x6c')]==='0'&&_0x497870===_0x539c('0x35')){_0x31f2bb='i.substatus';}else{if(_0x18b1c1[_0x539c('0x6c')]==='1'){_0x5550f9[_0x539c('0x6d')]();}_0x31f2bb=_0x539c('0x6e')+_0x5550f9[_0x539c('0x6f')](',\x20')+')';}return _0x31f2bb;}function getFilteredInteractions(_0x5ba91c,_0x299ce1,_0x48966d,_0x48fb32){var _0x44278c=utils[_0x539c('0xe')](_0x5ba91c);var _0x307702=_[_0x539c('0x62')](_0x5ba91c)+'Interaction';var _0x20053a=[];var _0xd6d292=getTagsQuery();var _0x4801b0={'type':db[_0x539c('0x70')][_0x539c('0x71')][_0x539c('0x72')],'raw':!![]};var _0x2abbad=[];var _0x5f3b2e=[];return db[_0x539c('0x73')][_0x539c('0x74')](_0xd6d292[_0x539c('0x75')](),_0x4801b0)[_0x539c('0x5d')](function(_0x19e754){_0x20053a=_[_0x539c('0x76')](_0x19e754,'id');_0x4801b0=_[_0x539c('0x77')](_0x4801b0,{'model':db[_0x307702],'mapToModel':!![],'nest':!![]});if(_0x48966d[_0x539c('0x5e')]){_0x48fb32[_0x539c('0x78')]['forEach'](function(_0x331d6b){_0x299ce1[_0x539c('0xa')]('i.'+_0x331d6b);});}else{_0x299ce1['field'](_0x539c('0x79'),_0x539c('0x7a'));_0x299ce1[_0x539c('0xa')]('a.key',_0x539c('0x7b'));_0x299ce1['field'](_0x539c('0x7c'),_0x539c('0x7d'));if(_0x5ba91c===_0x539c('0x35')){_0x299ce1[_0x539c('0xa')](_0x539c('0x7e'),_0x539c('0x7f'));_0x299ce1[_0x539c('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',_0x539c('0x80'));_0x299ce1[_0x539c('0xa')](_0x539c('0x81'));_0x299ce1[_0x539c('0xa')](_0x539c('0x82'));_0x299ce1[_0x539c('0xa')](_0x539c('0x83'));_0x299ce1[_0x539c('0xa')](_0x539c('0x84'));_0x299ce1[_0x539c('0xa')](_0x539c('0x85'));_0x299ce1[_0x539c('0xa')](_0x539c('0x86'));_0x299ce1[_0x539c('0xa')](_0x539c('0x87'));_0x299ce1[_0x539c('0xa')](_0x539c('0x88'));_0x299ce1[_0x539c('0xa')](_0x539c('0x89'));_0x299ce1['field'](_0x539c('0x69'));_0x299ce1[_0x539c('0xa')](_0x539c('0x68'));_0x299ce1[_0x539c('0xa')](_0x539c('0x8a'));_0x299ce1[_0x539c('0xa')](_0x539c('0x6b'));_0x299ce1[_0x539c('0xa')](_0x539c('0x8b'));_0x299ce1[_0x539c('0xa')](_0x539c('0x8c'));_0x299ce1['field'](_0x539c('0x8d'));_0x299ce1['field'](_0x539c('0x8e'));}else if(_0x5ba91c==='openchannel'){_0x299ce1[_0x539c('0xa')](_0x539c('0x8f'),_0x539c('0x80'));}else{_0x299ce1['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',_0x539c('0x80'));}if(_0x5ba91c!==_0x539c('0x35')){_0x299ce1[_0x539c('0xa')](_0x539c('0x90'));}_0x299ce1['field'](_0x539c('0x91'),_0x539c('0x92'));_0x299ce1[_0x539c('0xa')](_0x539c('0x93'),_0x539c('0x94'));_0x299ce1['field'](_0x539c('0x95'),_0x539c('0x96'));_0x299ce1[_0x539c('0xa')](_0x539c('0x97'),_0x539c('0x98'));_0x299ce1['field'](_0x539c('0x99'),_0x539c('0x9a'));_0x299ce1[_0x539c('0xa')](_0x539c('0x9b'),_0x539c('0x9c'));_0x299ce1[_0x539c('0xa')](_0x539c('0x9d'),'Owner.fullname');_0x299ce1[_0x539c('0xa')](_0x539c('0x9e'),_0x539c('0x9f'));_0x299ce1['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0x539c('0xa0'));}if(_0x48fb32[_0x539c('0xa1')]){_0x299ce1[_0x539c('0xa1')](_0x48fb32[_0x539c('0xa1')]);}if(_0x48fb32[_0x539c('0xa2')]){_0x299ce1[_0x539c('0xa2')](_0x48fb32[_0x539c('0xa2')]);}return db[_0x539c('0x73')]['query'](_0x299ce1[_0x539c('0x75')](),_0x4801b0);})[_0x539c('0x5d')](function(_0x476944){_0x2abbad=_0x476944;var _0x1e8513=getUsersQuery(_0x5ba91c,_0x2abbad);return db[_0x539c('0x73')][_0x539c('0x74')](_0x1e8513['toString'](),_0x4801b0);})[_0x539c('0x5d')](function(_0x39029f){_0x5f3b2e=_[_0x539c('0xa3')](_0x39029f,_0x44278c);if(_0x5ba91c==='mail'){return db[_0x539c('0xa4')]['findOne']({'attributes':[_0x539c('0xa5')],'raw':!![]});}})[_0x539c('0x5d')](function(_0x1cd5a4){var _0x5ae654=_0x1cd5a4?_0x1cd5a4[_0x539c('0xa5')]:undefined;var _0x2e1513=_0x2abbad[_0x539c('0x19')](function(_0x54efbf){return updateInteraction(_0x54efbf,_0x20053a,_0x5f3b2e,_0x5ae654);});return Promise[_0x539c('0xa6')](_0x2e1513);});}function countFilteredInteractions(_0x46dd3,_0x5f10ba){var _0x1cc5e1=_0x46dd3[_0x539c('0xa7')]();_0x1cc5e1[_0x539c('0xa')](_0x539c('0xa8'));_0x1cc5e1[_0x539c('0xa')](_0x539c('0x79'),_0x539c('0x7a'));var _0x27b9f3=utils[_0x539c('0x27')](_0x5f10ba);if(!_[_0x539c('0xa9')](_0x27b9f3)){_0x1cc5e1[_0x539c('0x17')](_0x539c('0xaa'),_0x27b9f3);}var _0x38751a={'type':db[_0x539c('0x70')][_0x539c('0x71')][_0x539c('0x72')],'raw':!![]};return db['sequelize'][_0x539c('0x74')](_0x1cc5e1[_0x539c('0x75')](),_0x38751a);}module[_0x539c('0xab')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion2.git / blobdiff