// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa2af=['i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','getInteractionFK','Interaction','Sequelize','QueryTypes','SELECT','query','toString','keyBy','merge','fields','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','a.email','Account.email','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.createdAt','i.updatedAt','i.closed','i.attach','i.lastMsgAt','i.subject','i.disposition','i.to','i.ContactId','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','c.firstName','Contact.firstName','Contact.lastName','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','sequelize','groupBy','Setting','enableEmailPreview','clone','COUNT(*)','getSelectedTags','isEmpty','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','getAccountFK','agent','search','select','field','name','color','from','tools_tags','user_has_','_interactions','u.fullname','ui.','left_join','users','length','where','\x20IN\x20?','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','messages','me.','\x20=\x20i.id','interactionsTags','t.id\x20=\x20it.TagId','expr','forEach','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','openchannel','mail','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','conditions','find','buildExpression','type','text','start','value','end','unreadMessages','Contact','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','Tag','map','tags','clause','and','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','keys','some','compact','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','read','tag','filter','get','capitalize','Websites','Accounts','role','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','unshift'];(function(_0x21af3a,_0x386e1d){var _0x268a49=function(_0x41a650){while(--_0x41a650){_0x21af3a['push'](_0x21af3a['shift']());}};_0x268a49(++_0x386e1d);}(_0xa2af,0xe0));var _0xfa2a=function(_0x596769,_0x2c273c){_0x596769=_0x596769-0x0;var _0x2635a5=_0xa2af[_0x596769];return _0x2635a5;};'use strict';var _=require(_0xfa2a('0x0'));var squel=require(_0xfa2a('0x1'));var as=require(_0xfa2a('0x2'));var qs=require(_0xfa2a('0x3'));var updateInteraction=require(_0xfa2a('0x4'))[_0xfa2a('0x5')];var utils=require(_0xfa2a('0x6'));var db=require(_0xfa2a('0x7'))['db'];function skipInteractionsQuery(_0x261e0b,_0x462403,_0x4f1731){var _0x4b7984=![];var _0x512087=utils[_0xfa2a('0x8')](_0x261e0b);if(_0x462403['role']===_0xfa2a('0x9')&&!_0x4f1731[_0xfa2a('0xa')]&&!_0x4f1731[_0x512087]){_0x4b7984=!![];}return _0x4b7984;}function getTagsQuery(){return squel[_0xfa2a('0xb')]()[_0xfa2a('0xc')]('id')[_0xfa2a('0xc')](_0xfa2a('0xd'))[_0xfa2a('0xc')](_0xfa2a('0xe'))[_0xfa2a('0xf')](_0xfa2a('0x10'));}function getUsersQuery(_0x533d7d,_0x5134ca){var _0x412afe=utils['getInteractionFK'](_0x533d7d);var _0x4eef64=_0xfa2a('0x11')+_0x533d7d+_0xfa2a('0x12');var _0x38af1e=squel['select']()[_0xfa2a('0xc')]('u.id')[_0xfa2a('0xc')](_0xfa2a('0x13'))[_0xfa2a('0xc')](_0xfa2a('0x14')+_0x412afe)[_0xfa2a('0xf')](_0x4eef64,'ui')[_0xfa2a('0x15')](_0xfa2a('0x16'),'u','u.id\x20=\x20ui.UserId');if(_0x5134ca[_0xfa2a('0x17')]>0x0){_0x38af1e[_0xfa2a('0x18')]('ui.'+_0x412afe+_0xfa2a('0x19'),_['map'](_0x5134ca,'id'));}return _0x38af1e;}function getInteractionsQuery(_0x123ee4){var _0x205a1f=utils['getInteractionsTables'](_0x123ee4);var _0x445078=utils[_0xfa2a('0x8')](_0x123ee4);var _0x5e75d9=utils['getInteractionFK'](_0x123ee4);return squel[_0xfa2a('0xb')]()[_0xfa2a('0xf')](_0x205a1f['interactions'],'i')[_0xfa2a('0x15')]('cm_contacts','c',_0xfa2a('0x1a'))[_0xfa2a('0x15')](_0xfa2a('0x16'),'o',_0xfa2a('0x1b'))[_0xfa2a('0x15')](_0x205a1f[_0xfa2a('0x1c')],'a','a.id\x20=\x20i.'+_0x445078)[_0xfa2a('0x15')](_0x205a1f[_0xfa2a('0x1d')],'me',_0xfa2a('0x1e')+_0x5e75d9+_0xfa2a('0x1f'))[_0xfa2a('0x15')](_0x205a1f[_0xfa2a('0x20')],'it','it.'+_0x5e75d9+_0xfa2a('0x1f'))[_0xfa2a('0x15')]('tools_tags','t',_0xfa2a('0x21'));}function getSqlClauses(){var _0x172454={'body':squel['expr'](),'contact':squel[_0xfa2a('0x22')](),'default':squel[_0xfa2a('0x22')](),'fields':squel[_0xfa2a('0x22')](),'filter':squel[_0xfa2a('0x22')](),'read':squel[_0xfa2a('0x22')](),'tags':{'clause':squel[_0xfa2a('0x22')](),'ids':null},'user':squel[_0xfa2a('0x22')]()};return _0x172454;}function parseTagParameter(_0x4afaa8){var _0x435e39=squel[_0xfa2a('0x22')]();if(_0x4afaa8){var _0x1f4e21=utils['getSelectedTags'](_0x4afaa8);_0x1f4e21[_0xfa2a('0x23')](function(_0x2ee7d5){_0x435e39['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x2ee7d5+',%');});}return _0x435e39;}function parseReadParameter(_0x193670){var _0xfbb07f='';if(_0x193670){_0xfbb07f=_0xfa2a('0x24');if(_0x193670==='1'){_0xfbb07f=_0xfbb07f[_0xfa2a('0x25')](_0xfa2a('0x26'),'=');}else{_0xfbb07f=_0xfbb07f['replace'](_0xfa2a('0x26'),'>');}}return _0xfbb07f;}function parseSearchFilter(_0x4134f2,_0x150513){var _0x3b9c03=squel[_0xfa2a('0x22')]();if(_0x150513){var _0x17917c=_0x150513[_0xfa2a('0x25')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0xfa2a('0x27')](_0x17917c)){_0x3b9c03['or'](_0xfa2a('0x28'),_0x17917c+'%');switch(_0x4134f2){case _0xfa2a('0x29'):case _0xfa2a('0x2a'):_0x3b9c03['or'](_0xfa2a('0x2b'),_0x17917c+'%');break;case _0xfa2a('0x2c'):_0x3b9c03['or'](_0xfa2a('0x2d'),_0x17917c+'%');break;case _0xfa2a('0x2e'):_0x3b9c03['or']('i.from\x20LIKE\x20?',_0x17917c+'%');break;case _0xfa2a('0x2f'):_0x3b9c03['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xfa2a('0x30')](_0x17917c,!![]))['or'](_0xfa2a('0x31'),qs[_0xfa2a('0x30')](_0x17917c));break;}}else if(_0x4134f2===_0xfa2a('0x2f')&&qs['isEmail'](_0x17917c)){_0x3b9c03['or']('c.email\x20LIKE\x20?',_0x17917c+'%');}else{if(_0x4134f2===_0xfa2a('0x2f')){_0x3b9c03['or'](_0xfa2a('0x32'),qs[_0xfa2a('0x30')](_0x17917c,!![]))['or'](_0xfa2a('0x31'),qs['getFullTextValue'](_0x17917c));}else if(_0x4134f2!=='fax'){_0x3b9c03['or'](_0xfa2a('0x33'),qs[_0xfa2a('0x30')](_0x17917c));}_0x3b9c03['or'](_0xfa2a('0x34'),qs['getFullTextValue'](_0x17917c,!![]),null);}}return _0x3b9c03;}function parseAdvancedSearchFilter(_0x57a21a,_0x1218ed){var _0x36ebdb=getSqlClauses();var _0x5a1be0=as[_0xfa2a('0x35')](_0x57a21a);var _0x358145=_0x5a1be0['sqlOperator'];for(var _0x245b04=0x0;_0x245b04<_0x5a1be0['conditions']['length'];_0x245b04++){var _0x43e7b5=_0x5a1be0[_0xfa2a('0x36')][_0x245b04];var _0x320558='i';var _0x359cf5=_[_0xfa2a('0x37')](_0x1218ed,['name',_0x43e7b5['field']]);if(_0x359cf5){var _0x214c71=as[_0xfa2a('0x38')](_0x320558,_0x359cf5[_0xfa2a('0x39')],_0x43e7b5);_0x36ebdb['default'][_0x358145](_0x214c71[_0xfa2a('0x3a')],_0x214c71['value'][_0xfa2a('0x3b')],_0x214c71[_0xfa2a('0x3c')][_0xfa2a('0x3d')]);}else{switch(_0x43e7b5[_0xfa2a('0xc')]){case _0xfa2a('0x3e'):var _0x4f5030=parseReadParameter(_0x43e7b5['value']);_0x36ebdb['read']['and'](_0x4f5030);break;case _0xfa2a('0x3f'):if(_0x43e7b5[_0xfa2a('0x40')]===_0xfa2a('0x41')){if(_0x43e7b5[_0xfa2a('0x3c')][_0xfa2a('0x42')]('\x20')[_0xfa2a('0x17')]>0x1){_0x36ebdb[_0xfa2a('0x43')][_0x358145]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xfa2a('0x30')](_0x43e7b5['value'],!![]),null);}else{var _0x3cd1ac='%'+_0x43e7b5[_0xfa2a('0x3c')]+'%';_0x36ebdb['contact'][_0x358145](_0xfa2a('0x44'),_0x3cd1ac,_0x3cd1ac,_0x3cd1ac);}}else{_0x359cf5=_[_0xfa2a('0x37')](_0x1218ed,['name',_0xfa2a('0x45')]);_0x43e7b5[_0xfa2a('0xc')]='ContactId';_0x214c71=as[_0xfa2a('0x38')](_0x320558,_0x359cf5[_0xfa2a('0x39')],_0x43e7b5);_0x36ebdb['contact'][_0x358145](_0x214c71[_0xfa2a('0x3a')],_0x214c71['value'][_0xfa2a('0x3b')],_0x214c71[_0xfa2a('0x3c')][_0xfa2a('0x3d')]);}break;case _0xfa2a('0x46'):var _0xdb017d=_0x43e7b5[_0xfa2a('0x3c')][_0xfa2a('0x42')](',')[_0xfa2a('0x47')](function(_0x3c45c6){return Number(_0x3c45c6);});var _0x2373de=parseTagParameter(_0xdb017d);_0x36ebdb[_0xfa2a('0x48')][_0xfa2a('0x49')][_0xfa2a('0x4a')](_0x2373de);_0x36ebdb[_0xfa2a('0x48')][_0xfa2a('0x4b')]=_0xdb017d;break;case _0xfa2a('0x4c'):if(_0x43e7b5['operator']===_0xfa2a('0x41')){_0x36ebdb[_0xfa2a('0x4d')][_0x358145](_0xfa2a('0x4e'),'%'+_0x43e7b5[_0xfa2a('0x3c')]+'%',null);}else{_0x359cf5=_[_0xfa2a('0x37')](_0x1218ed,[_0xfa2a('0xd'),_0xfa2a('0x4f')]);_0x43e7b5['field']='UserId';_0x214c71=as[_0xfa2a('0x38')](_0x320558,_0x359cf5[_0xfa2a('0x39')],_0x43e7b5);_0x36ebdb[_0xfa2a('0x4d')][_0x358145](_0x214c71[_0xfa2a('0x3a')],_0x214c71[_0xfa2a('0x3c')][_0xfa2a('0x3b')],_0x214c71[_0xfa2a('0x3c')]['end']);}break;case _0xfa2a('0x50'):case'plainBody':_0x214c71=as[_0xfa2a('0x38')]('me',null,_0x43e7b5);_0x36ebdb[_0xfa2a('0x50')][_0x358145](_0x214c71['text'],_0x214c71[_0xfa2a('0x3c')][_0xfa2a('0x3b')],_0x214c71[_0xfa2a('0x3c')][_0xfa2a('0x3d')]);break;}}}return _0x36ebdb;}function parseModelFields(_0x46770b,_0x3ceeca,_0x44eeda){var _0x11ae96=utils['getAccountFK'](_0x46770b);var _0x10d0a7=squel[_0xfa2a('0x22')]();var _0x44d565=_(_0x3ceeca)[_0xfa2a('0x51')]()[_0xfa2a('0x47')](function(_0x58668f){return _[_0xfa2a('0x52')](_0x44eeda,['name',_0x58668f])?_0x58668f:undefined;})[_0xfa2a('0x53')]()[_0xfa2a('0x3c')]();if(_0x44d565['length']>0x0){_0x44d565[_0xfa2a('0x23')](function(_0x284911){if(_0x284911===_0x11ae96){_0x10d0a7[_0xfa2a('0x4a')]('i.'+_0x11ae96+_0xfa2a('0x19'),[][_0xfa2a('0x54')](_0x3ceeca[_0x284911]));}else if(_0x284911===_0xfa2a('0x55')){var _0x1b1bd7=JSON[_0xfa2a('0x56')](_0x3ceeca[_0x284911])['$gte'];var _0x340b47=JSON[_0xfa2a('0x56')](_0x3ceeca[_0x284911])[_0xfa2a('0x57')];_0x10d0a7['and'](_0xfa2a('0x58'),_0x1b1bd7,_0x340b47);}else{if(_0x3ceeca[_0x284911]===_0xfa2a('0x59')){_0x10d0a7[_0xfa2a('0x4a')]('i.'+_0x284911+_0xfa2a('0x5a'));}else{_0x10d0a7[_0xfa2a('0x4a')]('i.'+_0x284911+_0xfa2a('0x5b'),_0x3ceeca[_0x284911]);}}});}return _0x10d0a7;}function parseQueryParameters(_0x10f2b8,_0x40cbf9,_0x15de6e){var _0xd7a366=getSqlClauses();return Promise[_0xfa2a('0x5c')]()[_0xfa2a('0x5d')](function(){return parseModelFields(_0x10f2b8,_0x40cbf9,_0x15de6e);})['then'](function(_0x1f963b){_0xd7a366['fields'][_0xfa2a('0x4a')](_0x1f963b);return parseReadParameter(_0x40cbf9[_0xfa2a('0x5e')]);})[_0xfa2a('0x5d')](function(_0x3d9758){_0xd7a366[_0xfa2a('0x5e')][_0xfa2a('0x4a')](_0x3d9758);return parseTagParameter(_0x40cbf9[_0xfa2a('0x5f')]);})['then'](function(_0xfffce2){_0xd7a366[_0xfa2a('0x48')]['clause']['and'](_0xfffce2);return parseSearchFilter(_0x10f2b8,_0x40cbf9[_0xfa2a('0x60')]);})[_0xfa2a('0x5d')](function(_0x4e358e){_0xd7a366[_0xfa2a('0x60')]=_0x4e358e;return _0xd7a366;});}function checkAccountsRestrictions(_0x1168bf,_0x12b0c7,_0x2a452c){var _0x230a39=utils[_0xfa2a('0x8')](_0x1168bf);var _0x40e89e=_0xfa2a('0x61')+_[_0xfa2a('0x62')](_0x1168bf)+(_0x1168bf==='chat'?_0xfa2a('0x63'):_0xfa2a('0x64'));var _0x4b3805=squel['expr']();return Promise[_0xfa2a('0x5c')]()[_0xfa2a('0x5d')](function(){if(_0x2a452c[_0xfa2a('0xa')]&&_0x12b0c7[_0xfa2a('0x65')]===_0xfa2a('0x9')){return _0x12b0c7[_0x40e89e]({'attributes':['id'],'raw':!![]});}})[_0xfa2a('0x5d')](function(_0x83f7e9){if(_0x83f7e9){if(_0x83f7e9['length']===0x0){_0x4b3805[_0xfa2a('0x4a')]('i.'+_0x230a39+_0xfa2a('0x5a'));}else{_0x4b3805['and']('i.'+_0x230a39+_0xfa2a('0x19'),_[_0xfa2a('0x47')](_0x83f7e9,'id'));}}else if(!_0x2a452c[_0x230a39]){_0x4b3805['and']('i.'+_0x230a39+_0xfa2a('0x66'));}})[_0xfa2a('0x5d')](function(){return _0x4b3805;});}function getClosedOrderClause(_0xc5bff2,_0x94fbca){var _0x586e5b='';var _0x395985=[_0xfa2a('0x67'),_0xfa2a('0x68'),'i.disposition'];if(_0xc5bff2==='mail'){_0x395985[_0xfa2a('0x69')](_0xfa2a('0x6a'));}if(_0x94fbca[_0xfa2a('0x6b')]==='0'&&_0xc5bff2===_0xfa2a('0x2f')){_0x586e5b=_0xfa2a('0x6a');}else{if(_0x94fbca['closed']==='1'){_0x395985[_0xfa2a('0x6c')]();}_0x586e5b=_0xfa2a('0x6d')+_0x395985[_0xfa2a('0x6e')](',\x20')+')';}return _0x586e5b;}function getFilteredInteractions(_0x4c5e44,_0x18fbf1,_0x4378ce,_0x17a248){var _0x4235a9=utils[_0xfa2a('0x6f')](_0x4c5e44);var _0x9207a7=_['capitalize'](_0x4c5e44)+_0xfa2a('0x70');var _0x2c559b=[];var _0x4a782c=getTagsQuery();var _0x4c29e9={'type':db[_0xfa2a('0x71')][_0xfa2a('0x72')][_0xfa2a('0x73')],'raw':!![]};var _0x46fe3c=[];var _0x37af1f=[];return db['sequelize'][_0xfa2a('0x74')](_0x4a782c[_0xfa2a('0x75')](),_0x4c29e9)['then'](function(_0x95d8c7){_0x2c559b=_[_0xfa2a('0x76')](_0x95d8c7,'id');_0x4c29e9=_[_0xfa2a('0x77')](_0x4c29e9,{'model':db[_0x9207a7],'mapToModel':!![],'nest':!![]});if(_0x4378ce[_0xfa2a('0x78')]){_0x17a248['attributes'][_0xfa2a('0x23')](function(_0x5b2063){_0x18fbf1['field']('i.'+_0x5b2063);});}else{_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x79'),_0xfa2a('0x3e'));_0x18fbf1['field'](_0xfa2a('0x7a'),_0xfa2a('0x7b'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x7c'),'Account.mandatoryDisposition');if(_0x4c5e44===_0xfa2a('0x2f')){_0x18fbf1['field'](_0xfa2a('0x7d'),_0xfa2a('0x7e'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x7f'),_0xfa2a('0x80'));_0x18fbf1[_0xfa2a('0xc')]('i.id');_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x81'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x82'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x83'));_0x18fbf1[_0xfa2a('0xc')]('i.closedAt');_0x18fbf1['field'](_0xfa2a('0x84'));_0x18fbf1['field'](_0xfa2a('0x85'));_0x18fbf1[_0xfa2a('0xc')]('i.lastMsgDirection');_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x86'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x87'));_0x18fbf1[_0xfa2a('0xc')]('i.secondDisposition');_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x67'));_0x18fbf1['field']('i.substatus');_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x88'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x89'));_0x18fbf1['field'](_0xfa2a('0x8a'));_0x18fbf1[_0xfa2a('0xc')]('i.UserId');}else if(_0x4c5e44===_0xfa2a('0x2e')){_0x18fbf1['field'](_0xfa2a('0x8b'),_0xfa2a('0x80'));}else{_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x8c'),_0xfa2a('0x80'));}if(_0x4c5e44!==_0xfa2a('0x2f')){_0x18fbf1[_0xfa2a('0xc')]('i.*');}_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x8d'),_0xfa2a('0x8e'));_0x18fbf1[_0xfa2a('0xc')]('c.lastName',_0xfa2a('0x8f'));_0x18fbf1['field']('c.email',_0xfa2a('0x90'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x91'),_0xfa2a('0x92'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x93'),_0xfa2a('0x94'));_0x18fbf1['field'](_0xfa2a('0x95'),_0xfa2a('0x96'));_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x97'),_0xfa2a('0x98'));_0x18fbf1[_0xfa2a('0xc')]('o.internal','Owner.internal');_0x18fbf1[_0xfa2a('0xc')](_0xfa2a('0x99'),_0xfa2a('0x9a'));}if(_0x17a248[_0xfa2a('0x9b')]){_0x18fbf1['limit'](_0x17a248[_0xfa2a('0x9b')]);}if(_0x17a248[_0xfa2a('0x9c')]){_0x18fbf1['offset'](_0x17a248[_0xfa2a('0x9c')]);}return db['sequelize'][_0xfa2a('0x74')](_0x18fbf1[_0xfa2a('0x75')](),_0x4c29e9);})[_0xfa2a('0x5d')](function(_0x304f50){_0x46fe3c=_0x304f50;var _0x3de171=getUsersQuery(_0x4c5e44,_0x46fe3c);return db[_0xfa2a('0x9d')][_0xfa2a('0x74')](_0x3de171['toString'](),_0x4c29e9);})[_0xfa2a('0x5d')](function(_0x120bda){_0x37af1f=_[_0xfa2a('0x9e')](_0x120bda,_0x4235a9);if(_0x4c5e44===_0xfa2a('0x2f')){return db[_0xfa2a('0x9f')]['findOne']({'attributes':[_0xfa2a('0xa0')],'raw':!![]});}})[_0xfa2a('0x5d')](function(_0x128f0b){var _0x3d39e2=_0x128f0b?_0x128f0b[_0xfa2a('0xa0')]:undefined;var _0x497294=_0x46fe3c[_0xfa2a('0x47')](function(_0x39dc8a){return updateInteraction(_0x39dc8a,_0x2c559b,_0x37af1f,_0x3d39e2);});return Promise['all'](_0x497294);});}function countFilteredInteractions(_0x22fc0d,_0x13bca3){var _0x407eb7=_0x22fc0d[_0xfa2a('0xa1')]();_0x407eb7[_0xfa2a('0xc')](_0xfa2a('0xa2'));_0x407eb7['field'](_0xfa2a('0x79'),_0xfa2a('0x3e'));var _0x34ac23=utils[_0xfa2a('0xa3')](_0x13bca3);if(!_[_0xfa2a('0xa4')](_0x34ac23)){_0x407eb7[_0xfa2a('0x18')]('t.id\x20IN\x20?',_0x34ac23);}var _0x55716a={'type':db['Sequelize'][_0xfa2a('0x72')][_0xfa2a('0x73')],'raw':!![]};return db['sequelize'][_0xfa2a('0x74')](_0x407eb7[_0xfa2a('0x75')](),_0x55716a);}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 _0x0622=['from','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','where','\x20IN\x20?','map','getInteractionsTables','getAccountFK','getInteractionFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','\x20=\x20i.id','interactionsTags','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','sms','whatsapp','i.phone\x20LIKE\x20?','i.fax\x20LIKE\x20?','openchannel','i.from\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.email\x20LIKE\x20?','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','fax','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','length','buildExpression','type','default','text','start','value','end','unreadMessages','read','Contact','operator','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','find','Tag','tags','clause','and','ids','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','user','body','plainBody','some','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','filter','capitalize','chat','Websites','Accounts','search','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.disposition','unshift','closed','i.substatus','shift','join','Interaction','QueryTypes','query','toString','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','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.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.to','i.MailAccountId','i.UserId','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.*','c.firstName','Contact.firstName','Contact.lastName','Contact.email','Contact.phone','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','limit','offset','sequelize','groupBy','Setting','findOne','enableEmailPreview','all','COUNT(*)','isEmpty','Sequelize','SELECT','exports','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','role','agent','select','field','name','color'];(function(_0x3aca11,_0x4c516d){var _0x20002b=function(_0x1b69f0){while(--_0x1b69f0){_0x3aca11['push'](_0x3aca11['shift']());}};_0x20002b(++_0x4c516d);}(_0x0622,0x96));var _0x2062=function(_0x4fb6b6,_0x5eb1c7){_0x4fb6b6=_0x4fb6b6-0x0;var _0x3ea470=_0x0622[_0x4fb6b6];return _0x3ea470;};'use strict';var _=require('lodash');var squel=require(_0x2062('0x0'));var as=require(_0x2062('0x1'));var qs=require(_0x2062('0x2'));var updateInteraction=require(_0x2062('0x3'))[_0x2062('0x4')];var utils=require(_0x2062('0x5'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x242c07,_0x1e2fc6,_0x28de7e){var _0x5585a6=![];var _0x745e96=utils['getAccountFK'](_0x242c07);if(_0x1e2fc6[_0x2062('0x6')]===_0x2062('0x7')&&!_0x28de7e['search']&&!_0x28de7e[_0x745e96]){_0x5585a6=!![];}return _0x5585a6;}function getTagsQuery(){return squel[_0x2062('0x8')]()[_0x2062('0x9')]('id')[_0x2062('0x9')](_0x2062('0xa'))['field'](_0x2062('0xb'))[_0x2062('0xc')]('tools_tags');}function getUsersQuery(_0x4a1b9c,_0x51d8b7){var _0x2429c2=utils['getInteractionFK'](_0x4a1b9c);var _0x47dd45=_0x2062('0xd')+_0x4a1b9c+_0x2062('0xe');var _0x3c3358=squel[_0x2062('0x8')]()[_0x2062('0x9')](_0x2062('0xf'))['field'](_0x2062('0x10'))[_0x2062('0x9')](_0x2062('0x11')+_0x2429c2)['from'](_0x47dd45,'ui')[_0x2062('0x12')](_0x2062('0x13'),'u',_0x2062('0x14'));if(_0x51d8b7['length']>0x0){_0x3c3358[_0x2062('0x15')](_0x2062('0x11')+_0x2429c2+_0x2062('0x16'),_[_0x2062('0x17')](_0x51d8b7,'id'));}return _0x3c3358;}function getInteractionsQuery(_0x52c7e1){var _0x45e9a0=utils[_0x2062('0x18')](_0x52c7e1);var _0x654ae6=utils[_0x2062('0x19')](_0x52c7e1);var _0x5eb990=utils[_0x2062('0x1a')](_0x52c7e1);return squel['select']()[_0x2062('0xc')](_0x45e9a0[_0x2062('0x1b')],'i')[_0x2062('0x12')](_0x2062('0x1c'),'c',_0x2062('0x1d'))[_0x2062('0x12')](_0x2062('0x13'),'o','o.id\x20=\x20i.UserId')[_0x2062('0x12')](_0x45e9a0[_0x2062('0x1e')],'a',_0x2062('0x1f')+_0x654ae6)[_0x2062('0x12')](_0x45e9a0['messages'],'me','me.'+_0x5eb990+_0x2062('0x20'))['left_join'](_0x45e9a0[_0x2062('0x21')],'it','it.'+_0x5eb990+'\x20=\x20i.id')[_0x2062('0x12')]('tools_tags','t',_0x2062('0x22'));}function getSqlClauses(){var _0x17276b={'body':squel[_0x2062('0x23')](),'contact':squel[_0x2062('0x23')](),'default':squel[_0x2062('0x23')](),'fields':squel['expr'](),'filter':squel['expr'](),'read':squel['expr'](),'tags':{'clause':squel[_0x2062('0x23')](),'ids':null},'user':squel['expr']()};return _0x17276b;}function parseTagParameter(_0x2bb50a){var _0x37136a=squel[_0x2062('0x23')]();if(_0x2bb50a){var _0x24cbed=utils[_0x2062('0x24')](_0x2bb50a);_0x24cbed[_0x2062('0x25')](function(_0x80322){_0x37136a['or'](_0x2062('0x26'),'%,'+_0x80322+',%');});}return _0x37136a;}function parseReadParameter(_0x4fd5cf){var _0x438d5b='';if(_0x4fd5cf){_0x438d5b='unreadMessages\x20{OPERATOR}\x200';if(_0x4fd5cf==='1'){_0x438d5b=_0x438d5b[_0x2062('0x27')](_0x2062('0x28'),'=');}else{_0x438d5b=_0x438d5b['replace'](_0x2062('0x28'),'>');}}return _0x438d5b;}function parseSearchFilter(_0x3a26e5,_0x51960c){var _0x4ae848=squel[_0x2062('0x23')]();if(_0x51960c){var _0x28170e=_0x51960c[_0x2062('0x27')]('\x5c','\x5c\x5c')[_0x2062('0x27')](/'/g,'\x27\x27');if(qs['isNumeric'](_0x28170e)){_0x4ae848['or']('i.id\x20LIKE\x20?',_0x28170e+'%');switch(_0x3a26e5){case _0x2062('0x29'):case _0x2062('0x2a'):_0x4ae848['or'](_0x2062('0x2b'),_0x28170e+'%');break;case'fax':_0x4ae848['or'](_0x2062('0x2c'),_0x28170e+'%');break;case _0x2062('0x2d'):_0x4ae848['or'](_0x2062('0x2e'),_0x28170e+'%');break;case _0x2062('0x2f'):_0x4ae848['or'](_0x2062('0x30'),qs['getFullTextValue'](_0x28170e,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x2062('0x31')](_0x28170e));break;}}else if(_0x3a26e5==='mail'&&qs['isEmail'](_0x28170e)){_0x4ae848['or'](_0x2062('0x32'),_0x28170e+'%');}else{if(_0x3a26e5===_0x2062('0x2f')){_0x4ae848['or'](_0x2062('0x30'),qs[_0x2062('0x31')](_0x28170e,!![]))['or'](_0x2062('0x33'),qs[_0x2062('0x31')](_0x28170e));}else if(_0x3a26e5!==_0x2062('0x34')){_0x4ae848['or'](_0x2062('0x35'),qs[_0x2062('0x31')](_0x28170e));}_0x4ae848['or'](_0x2062('0x36'),qs[_0x2062('0x31')](_0x28170e,!![]),null);}}return _0x4ae848;}function parseAdvancedSearchFilter(_0x4715de,_0x1fe544){var _0x3d2f80=getSqlClauses();var _0x514a05=as[_0x2062('0x37')](_0x4715de);var _0x145197=_0x514a05[_0x2062('0x38')];for(var _0x380732=0x0;_0x380732<_0x514a05[_0x2062('0x39')][_0x2062('0x3a')];_0x380732++){var _0x151225=_0x514a05[_0x2062('0x39')][_0x380732];var _0x1748b4='i';var _0x1a38d1=_['find'](_0x1fe544,[_0x2062('0xa'),_0x151225['field']]);if(_0x1a38d1){var _0x412dfc=as[_0x2062('0x3b')](_0x1748b4,_0x1a38d1[_0x2062('0x3c')],_0x151225);_0x3d2f80[_0x2062('0x3d')][_0x145197](_0x412dfc[_0x2062('0x3e')],_0x412dfc['value'][_0x2062('0x3f')],_0x412dfc[_0x2062('0x40')][_0x2062('0x41')]);}else{switch(_0x151225[_0x2062('0x9')]){case _0x2062('0x42'):var _0x4aa9c0=parseReadParameter(_0x151225['value']);_0x3d2f80[_0x2062('0x43')]['and'](_0x4aa9c0);break;case _0x2062('0x44'):if(_0x151225[_0x2062('0x45')]==='$substring'){if(_0x151225[_0x2062('0x40')][_0x2062('0x46')]('\x20')['length']>0x1){_0x3d2f80[_0x2062('0x47')][_0x145197]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x2062('0x31')](_0x151225['value'],!![]),null);}else{var _0x29967c='%'+_0x151225[_0x2062('0x40')]+'%';_0x3d2f80[_0x2062('0x47')][_0x145197](_0x2062('0x48'),_0x29967c,_0x29967c,_0x29967c);}}else{_0x1a38d1=_[_0x2062('0x49')](_0x1fe544,[_0x2062('0xa'),'ContactId']);_0x151225['field']='ContactId';_0x412dfc=as[_0x2062('0x3b')](_0x1748b4,_0x1a38d1[_0x2062('0x3c')],_0x151225);_0x3d2f80['contact'][_0x145197](_0x412dfc[_0x2062('0x3e')],_0x412dfc[_0x2062('0x40')][_0x2062('0x3f')],_0x412dfc['value'][_0x2062('0x41')]);}break;case _0x2062('0x4a'):var _0x5778fd=_0x151225['value'][_0x2062('0x46')](',')[_0x2062('0x17')](function(_0x51f5f4){return Number(_0x51f5f4);});var _0x3e9b8d=parseTagParameter(_0x5778fd);_0x3d2f80[_0x2062('0x4b')][_0x2062('0x4c')][_0x2062('0x4d')](_0x3e9b8d);_0x3d2f80[_0x2062('0x4b')][_0x2062('0x4e')]=_0x5778fd;break;case'User':if(_0x151225[_0x2062('0x45')]==='$substring'){_0x3d2f80['user'][_0x145197](_0x2062('0x4f'),'%'+_0x151225[_0x2062('0x40')]+'%',null);}else{_0x1a38d1=_[_0x2062('0x49')](_0x1fe544,['name',_0x2062('0x50')]);_0x151225[_0x2062('0x9')]=_0x2062('0x50');_0x412dfc=as[_0x2062('0x3b')](_0x1748b4,_0x1a38d1[_0x2062('0x3c')],_0x151225);_0x3d2f80[_0x2062('0x51')][_0x145197](_0x412dfc[_0x2062('0x3e')],_0x412dfc[_0x2062('0x40')][_0x2062('0x3f')],_0x412dfc[_0x2062('0x40')][_0x2062('0x41')]);}break;case _0x2062('0x52'):case _0x2062('0x53'):_0x412dfc=as['buildExpression']('me',null,_0x151225);_0x3d2f80[_0x2062('0x52')][_0x145197](_0x412dfc['text'],_0x412dfc['value'][_0x2062('0x3f')],_0x412dfc[_0x2062('0x40')][_0x2062('0x41')]);break;}}}return _0x3d2f80;}function parseModelFields(_0x3f22b7,_0x45832d,_0x30e6d6){var _0x4c836b=utils[_0x2062('0x19')](_0x3f22b7);var _0xecc8=squel[_0x2062('0x23')]();var _0x374807=_(_0x45832d)['keys']()['map'](function(_0x102240){return _[_0x2062('0x54')](_0x30e6d6,[_0x2062('0xa'),_0x102240])?_0x102240:undefined;})['compact']()[_0x2062('0x40')]();if(_0x374807[_0x2062('0x3a')]>0x0){_0x374807[_0x2062('0x25')](function(_0x95f53c){if(_0x95f53c===_0x4c836b){_0xecc8[_0x2062('0x4d')]('i.'+_0x4c836b+_0x2062('0x16'),[]['concat'](_0x45832d[_0x95f53c]));}else if(_0x95f53c===_0x2062('0x55')){var _0x9478c2=JSON[_0x2062('0x56')](_0x45832d[_0x95f53c])[_0x2062('0x57')];var _0x5963fe=JSON[_0x2062('0x56')](_0x45832d[_0x95f53c])[_0x2062('0x58')];_0xecc8[_0x2062('0x4d')](_0x2062('0x59'),_0x9478c2,_0x5963fe);}else{if(_0x45832d[_0x95f53c]===_0x2062('0x5a')){_0xecc8[_0x2062('0x4d')]('i.'+_0x95f53c+_0x2062('0x5b'));}else{_0xecc8['and']('i.'+_0x95f53c+_0x2062('0x5c'),_0x45832d[_0x95f53c]);}}});}return _0xecc8;}function parseQueryParameters(_0x17ba08,_0x12486e,_0x4b5fba){var _0x6a09aa=getSqlClauses();return Promise[_0x2062('0x5d')]()[_0x2062('0x5e')](function(){return parseModelFields(_0x17ba08,_0x12486e,_0x4b5fba);})[_0x2062('0x5e')](function(_0x4ca13a){_0x6a09aa[_0x2062('0x5f')][_0x2062('0x4d')](_0x4ca13a);return parseReadParameter(_0x12486e[_0x2062('0x43')]);})['then'](function(_0x2ff268){_0x6a09aa[_0x2062('0x43')][_0x2062('0x4d')](_0x2ff268);return parseTagParameter(_0x12486e[_0x2062('0x60')]);})[_0x2062('0x5e')](function(_0x48e293){_0x6a09aa[_0x2062('0x4b')]['clause'][_0x2062('0x4d')](_0x48e293);return parseSearchFilter(_0x17ba08,_0x12486e[_0x2062('0x61')]);})[_0x2062('0x5e')](function(_0x36bf8a){_0x6a09aa[_0x2062('0x61')]=_0x36bf8a;return _0x6a09aa;});}function checkAccountsRestrictions(_0x5adf17,_0x161cb8,_0x48dd00){var _0x2f140c=utils['getAccountFK'](_0x5adf17);var _0x3896f='get'+_[_0x2062('0x62')](_0x5adf17)+(_0x5adf17===_0x2062('0x63')?_0x2062('0x64'):_0x2062('0x65'));var _0x2d1730=squel[_0x2062('0x23')]();return Promise['resolve']()['then'](function(){if(_0x48dd00[_0x2062('0x66')]&&_0x161cb8[_0x2062('0x6')]===_0x2062('0x7')){return _0x161cb8[_0x3896f]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x5ed2d9){if(_0x5ed2d9){if(_0x5ed2d9[_0x2062('0x3a')]===0x0){_0x2d1730['and']('i.'+_0x2f140c+_0x2062('0x5b'));}else{_0x2d1730[_0x2062('0x4d')]('i.'+_0x2f140c+'\x20IN\x20?',_[_0x2062('0x17')](_0x5ed2d9,'id'));}}else if(!_0x48dd00[_0x2f140c]){_0x2d1730[_0x2062('0x4d')]('i.'+_0x2f140c+_0x2062('0x67'));}})[_0x2062('0x5e')](function(){return _0x2d1730;});}function getClosedOrderClause(_0x222a40,_0x4dfab1){var _0xba223d='';var _0x319c3e=[_0x2062('0x68'),'i.secondDisposition',_0x2062('0x69')];if(_0x222a40===_0x2062('0x2f')){_0x319c3e[_0x2062('0x6a')]('i.substatus');}if(_0x4dfab1[_0x2062('0x6b')]==='0'&&_0x222a40===_0x2062('0x2f')){_0xba223d=_0x2062('0x6c');}else{if(_0x4dfab1['closed']==='1'){_0x319c3e[_0x2062('0x6d')]();}_0xba223d='CONCAT_WS(\x27\x27,\x20'+_0x319c3e[_0x2062('0x6e')](',\x20')+')';}return _0xba223d;}function getFilteredInteractions(_0x2e621a,_0x1767e5,_0x4f3472,_0x5d39ac){var _0x308e46=utils[_0x2062('0x1a')](_0x2e621a);var _0x457393=_[_0x2062('0x62')](_0x2e621a)+_0x2062('0x6f');var _0x324e80=[];var _0x53580c=getTagsQuery();var _0x564104={'type':db['Sequelize'][_0x2062('0x70')]['SELECT'],'raw':!![]};var _0x3b1474=[];var _0x295430=[];return db['sequelize'][_0x2062('0x71')](_0x53580c[_0x2062('0x72')](),_0x564104)[_0x2062('0x5e')](function(_0x27c3cf){_0x324e80=_[_0x2062('0x73')](_0x27c3cf,'id');_0x564104=_[_0x2062('0x74')](_0x564104,{'model':db[_0x457393],'mapToModel':!![],'nest':!![]});if(_0x4f3472['fields']){_0x5d39ac[_0x2062('0x75')]['forEach'](function(_0x4692f4){_0x1767e5[_0x2062('0x9')]('i.'+_0x4692f4);});}else{_0x1767e5[_0x2062('0x9')](_0x2062('0x76'),_0x2062('0x42'));_0x1767e5[_0x2062('0x9')](_0x2062('0x77'),_0x2062('0x78'));_0x1767e5['field']('a.mandatoryDisposition',_0x2062('0x79'));if(_0x2e621a===_0x2062('0x2f')){_0x1767e5[_0x2062('0x9')]('a.email',_0x2062('0x7a'));_0x1767e5[_0x2062('0x9')](_0x2062('0x7b'),_0x2062('0x7c'));_0x1767e5[_0x2062('0x9')]('i.id');_0x1767e5[_0x2062('0x9')](_0x2062('0x7d'));_0x1767e5['field'](_0x2062('0x7e'));_0x1767e5[_0x2062('0x9')](_0x2062('0x7f'));_0x1767e5[_0x2062('0x9')](_0x2062('0x80'));_0x1767e5[_0x2062('0x9')](_0x2062('0x81'));_0x1767e5[_0x2062('0x9')](_0x2062('0x82'));_0x1767e5[_0x2062('0x9')](_0x2062('0x83'));_0x1767e5['field']('i.subject');_0x1767e5['field'](_0x2062('0x69'));_0x1767e5[_0x2062('0x9')]('i.secondDisposition');_0x1767e5[_0x2062('0x9')](_0x2062('0x68'));_0x1767e5[_0x2062('0x9')]('i.substatus');_0x1767e5[_0x2062('0x9')](_0x2062('0x84'));_0x1767e5[_0x2062('0x9')]('i.ContactId');_0x1767e5['field'](_0x2062('0x85'));_0x1767e5[_0x2062('0x9')](_0x2062('0x86'));}else if(_0x2e621a===_0x2062('0x2d')){_0x1767e5['field'](_0x2062('0x87'),_0x2062('0x7c'));}else{_0x1767e5[_0x2062('0x9')](_0x2062('0x88'),_0x2062('0x7c'));}if(_0x2e621a!==_0x2062('0x2f')){_0x1767e5[_0x2062('0x9')](_0x2062('0x89'));}_0x1767e5['field'](_0x2062('0x8a'),_0x2062('0x8b'));_0x1767e5[_0x2062('0x9')]('c.lastName',_0x2062('0x8c'));_0x1767e5[_0x2062('0x9')]('c.email',_0x2062('0x8d'));_0x1767e5['field']('c.phone',_0x2062('0x8e'));_0x1767e5[_0x2062('0x9')]('c.mobile',_0x2062('0x8f'));_0x1767e5[_0x2062('0x9')](_0x2062('0x90'),_0x2062('0x91'));_0x1767e5['field']('o.fullname',_0x2062('0x92'));_0x1767e5['field'](_0x2062('0x93'),_0x2062('0x94'));_0x1767e5[_0x2062('0x9')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x5d39ac['limit']){_0x1767e5['limit'](_0x5d39ac[_0x2062('0x95')]);}if(_0x5d39ac[_0x2062('0x96')]){_0x1767e5[_0x2062('0x96')](_0x5d39ac[_0x2062('0x96')]);}return db[_0x2062('0x97')][_0x2062('0x71')](_0x1767e5[_0x2062('0x72')](),_0x564104);})[_0x2062('0x5e')](function(_0x1e5a05){_0x3b1474=_0x1e5a05;var _0x51b17a=getUsersQuery(_0x2e621a,_0x3b1474);return db['sequelize'][_0x2062('0x71')](_0x51b17a['toString'](),_0x564104);})[_0x2062('0x5e')](function(_0x2ac9b6){_0x295430=_[_0x2062('0x98')](_0x2ac9b6,_0x308e46);if(_0x2e621a===_0x2062('0x2f')){return db[_0x2062('0x99')][_0x2062('0x9a')]({'attributes':[_0x2062('0x9b')],'raw':!![]});}})['then'](function(_0x5023e3){var _0x26d133=_0x5023e3?_0x5023e3[_0x2062('0x9b')]:undefined;var _0x511b7c=_0x3b1474['map'](function(_0x458983){return updateInteraction(_0x458983,_0x324e80,_0x295430,_0x26d133);});return Promise[_0x2062('0x9c')](_0x511b7c);});}function countFilteredInteractions(_0x3273ef,_0x331d3e){var _0xc3d53b=_0x3273ef['clone']();_0xc3d53b[_0x2062('0x9')](_0x2062('0x9d'));_0xc3d53b[_0x2062('0x9')](_0x2062('0x76'),_0x2062('0x42'));var _0x14cc90=utils[_0x2062('0x24')](_0x331d3e);if(!_[_0x2062('0x9e')](_0x14cc90)){_0xc3d53b[_0x2062('0x15')]('t.id\x20IN\x20?',_0x14cc90);}var _0x45450d={'type':db[_0x2062('0x9f')]['QueryTypes'][_0x2062('0xa0')],'raw':!![]};return db[_0x2062('0x97')]['query'](_0xc3d53b[_0x2062('0x72')](),_0x45450d);}module[_0x2062('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