// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf3c3=['c.email','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','query','enableEmailPreview','all','clone','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','isEmpty','t.id\x20IN\x20?','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','role','agent','search','select','field','name','color','from','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionsTables','getAccountFK','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','it.','tools_tags','t.id\x20=\x20it.TagId','expr','getSelectedTags','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','isNumeric','i.id\x20LIKE\x20?','sms','fax','i.from\x20LIKE\x20?','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isEmail','c.email\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','find','buildExpression','default','text','value','end','read','Contact','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','type','start','Tag','tags','clause','and','ids','User','user','UserId','body','keys','some','concat','createdAt','$gte','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','filter','capitalize','Websites','Accounts','i.thirdDisposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','toString','keyBy','merge','forEach','unreadMessages','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.closed','i.closedAt','i.attach','i.lastMsgAt','i.subject','i.disposition','i.secondDisposition','i.MailAccountId','i.UserId','openchannel','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'];(function(_0x49efa5,_0x2a8c59){var _0x247079=function(_0x46460c){while(--_0x46460c){_0x49efa5['push'](_0x49efa5['shift']());}};_0x247079(++_0x2a8c59);}(_0xf3c3,0x15c));var _0x3f3c=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xf3c3[_0x3dd15e];return _0x231fd0;};'use strict';var _=require(_0x3f3c('0x0'));var squel=require(_0x3f3c('0x1'));var as=require(_0x3f3c('0x2'));var qs=require(_0x3f3c('0x3'));var updateInteraction=require(_0x3f3c('0x4'))[_0x3f3c('0x5')];var utils=require(_0x3f3c('0x6'));var db=require(_0x3f3c('0x7'))['db'];function skipInteractionsQuery(_0x50a294,_0x4209e8,_0xcf83e6){var _0x24571f=![];var _0x497dc0=utils['getAccountFK'](_0x50a294);if(_0x4209e8[_0x3f3c('0x8')]===_0x3f3c('0x9')&&!_0xcf83e6[_0x3f3c('0xa')]&&!_0xcf83e6[_0x497dc0]){_0x24571f=!![];}return _0x24571f;}function getTagsQuery(){return squel[_0x3f3c('0xb')]()[_0x3f3c('0xc')]('id')[_0x3f3c('0xc')](_0x3f3c('0xd'))['field'](_0x3f3c('0xe'))[_0x3f3c('0xf')]('tools_tags');}function getUsersQuery(_0x44fd0d,_0x7cdbac){var _0x369a15=utils[_0x3f3c('0x10')](_0x44fd0d);var _0x2f3b49=_0x3f3c('0x11')+_0x44fd0d+_0x3f3c('0x12');var _0x3bbab9=squel[_0x3f3c('0xb')]()[_0x3f3c('0xc')](_0x3f3c('0x13'))[_0x3f3c('0xc')](_0x3f3c('0x14'))[_0x3f3c('0xc')](_0x3f3c('0x15')+_0x369a15)[_0x3f3c('0xf')](_0x2f3b49,'ui')[_0x3f3c('0x16')](_0x3f3c('0x17'),'u',_0x3f3c('0x18'));if(_0x7cdbac[_0x3f3c('0x19')]>0x0){_0x3bbab9[_0x3f3c('0x1a')](_0x3f3c('0x15')+_0x369a15+_0x3f3c('0x1b'),_[_0x3f3c('0x1c')](_0x7cdbac,'id'));}return _0x3bbab9;}function getInteractionsQuery(_0x4d958c){var _0x15790c=utils[_0x3f3c('0x1d')](_0x4d958c);var _0x4fe8ab=utils[_0x3f3c('0x1e')](_0x4d958c);var _0x18b0b1=utils['getInteractionFK'](_0x4d958c);return squel['select']()[_0x3f3c('0xf')](_0x15790c['interactions'],'i')['left_join']('cm_contacts','c',_0x3f3c('0x1f'))[_0x3f3c('0x16')]('users','o',_0x3f3c('0x20'))['left_join'](_0x15790c['accounts'],'a',_0x3f3c('0x21')+_0x4fe8ab)['left_join'](_0x15790c[_0x3f3c('0x22')],'me',_0x3f3c('0x23')+_0x18b0b1+_0x3f3c('0x24'))[_0x3f3c('0x16')](_0x15790c[_0x3f3c('0x25')],'it',_0x3f3c('0x26')+_0x18b0b1+_0x3f3c('0x24'))[_0x3f3c('0x16')](_0x3f3c('0x27'),'t',_0x3f3c('0x28'));}function getSqlClauses(){var _0x19969b={'body':squel[_0x3f3c('0x29')](),'contact':squel['expr'](),'default':squel[_0x3f3c('0x29')](),'fields':squel[_0x3f3c('0x29')](),'filter':squel[_0x3f3c('0x29')](),'read':squel['expr'](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x3f3c('0x29')]()};return _0x19969b;}function parseTagParameter(_0x9ab74b){var _0xf4d13a=squel[_0x3f3c('0x29')]();if(_0x9ab74b){var _0x4cc456=utils[_0x3f3c('0x2a')](_0x9ab74b);_0x4cc456['forEach'](function(_0x4ebf73){_0xf4d13a['or'](_0x3f3c('0x2b'),'%,'+_0x4ebf73+',%');});}return _0xf4d13a;}function parseReadParameter(_0x214a52){var _0x16d825='';if(_0x214a52){_0x16d825=_0x3f3c('0x2c');if(_0x214a52==='1'){_0x16d825=_0x16d825[_0x3f3c('0x2d')]('{OPERATOR}','=');}else{_0x16d825=_0x16d825['replace']('{OPERATOR}','>');}}return _0x16d825;}function parseSearchFilter(_0x4e66b1,_0x5033e2){var _0xbd87b2=squel[_0x3f3c('0x29')]();if(_0x5033e2){var _0xc6f812=_0x5033e2['replace']('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x3f3c('0x2e')](_0xc6f812)){_0xbd87b2['or'](_0x3f3c('0x2f'),_0xc6f812+'%');switch(_0x4e66b1){case _0x3f3c('0x30'):case'whatsapp':_0xbd87b2['or']('i.phone\x20LIKE\x20?',_0xc6f812+'%');break;case _0x3f3c('0x31'):_0xbd87b2['or']('i.fax\x20LIKE\x20?',_0xc6f812+'%');break;case'openchannel':_0xbd87b2['or'](_0x3f3c('0x32'),_0xc6f812+'%');break;case _0x3f3c('0x33'):_0xbd87b2['or'](_0x3f3c('0x34'),qs[_0x3f3c('0x35')](_0xc6f812,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x3f3c('0x35')](_0xc6f812));break;}}else if(_0x4e66b1===_0x3f3c('0x33')&&qs[_0x3f3c('0x36')](_0xc6f812)){_0xbd87b2['or'](_0x3f3c('0x37'),_0xc6f812+'%');}else{if(_0x4e66b1==='mail'){_0xbd87b2['or'](_0x3f3c('0x34'),qs['getFullTextValue'](_0xc6f812,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x3f3c('0x35')](_0xc6f812));}else if(_0x4e66b1!=='fax'){_0xbd87b2['or'](_0x3f3c('0x38'),qs[_0x3f3c('0x35')](_0xc6f812));}_0xbd87b2['or'](_0x3f3c('0x39'),qs[_0x3f3c('0x35')](_0xc6f812,!![]),null);}}return _0xbd87b2;}function parseAdvancedSearchFilter(_0x591b17,_0x388859){var _0xcdcd4=getSqlClauses();var _0x3c4dc2=as[_0x3f3c('0x3a')](_0x591b17);var _0x44798e=_0x3c4dc2[_0x3f3c('0x3b')];for(var _0x49038f=0x0;_0x49038f<_0x3c4dc2['conditions']['length'];_0x49038f++){var _0x3a8565=_0x3c4dc2[_0x3f3c('0x3c')][_0x49038f];var _0x57c1b7='i';var _0x4b9346=_[_0x3f3c('0x3d')](_0x388859,[_0x3f3c('0xd'),_0x3a8565[_0x3f3c('0xc')]]);if(_0x4b9346){var _0x15264b=as[_0x3f3c('0x3e')](_0x57c1b7,_0x4b9346['type'],_0x3a8565);_0xcdcd4[_0x3f3c('0x3f')][_0x44798e](_0x15264b[_0x3f3c('0x40')],_0x15264b[_0x3f3c('0x41')]['start'],_0x15264b['value'][_0x3f3c('0x42')]);}else{switch(_0x3a8565[_0x3f3c('0xc')]){case'unreadMessages':var _0x10a841=parseReadParameter(_0x3a8565['value']);_0xcdcd4[_0x3f3c('0x43')]['and'](_0x10a841);break;case _0x3f3c('0x44'):if(_0x3a8565[_0x3f3c('0x45')]===_0x3f3c('0x46')){if(_0x3a8565[_0x3f3c('0x41')][_0x3f3c('0x47')]('\x20')[_0x3f3c('0x19')]>0x1){_0xcdcd4[_0x3f3c('0x48')][_0x44798e]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x3a8565['value'],!![]),null);}else{var _0x57ece5='%'+_0x3a8565[_0x3f3c('0x41')]+'%';_0xcdcd4[_0x3f3c('0x48')][_0x44798e](_0x3f3c('0x49'),_0x57ece5,_0x57ece5,_0x57ece5);}}else{_0x4b9346=_[_0x3f3c('0x3d')](_0x388859,[_0x3f3c('0xd'),'ContactId']);_0x3a8565[_0x3f3c('0xc')]=_0x3f3c('0x4a');_0x15264b=as[_0x3f3c('0x3e')](_0x57c1b7,_0x4b9346[_0x3f3c('0x4b')],_0x3a8565);_0xcdcd4[_0x3f3c('0x48')][_0x44798e](_0x15264b[_0x3f3c('0x40')],_0x15264b[_0x3f3c('0x41')][_0x3f3c('0x4c')],_0x15264b[_0x3f3c('0x41')][_0x3f3c('0x42')]);}break;case _0x3f3c('0x4d'):var _0x5357b0=_0x3a8565['value'][_0x3f3c('0x47')](',')['map'](function(_0x40e4d6){return Number(_0x40e4d6);});var _0x3df65c=parseTagParameter(_0x5357b0);_0xcdcd4[_0x3f3c('0x4e')][_0x3f3c('0x4f')][_0x3f3c('0x50')](_0x3df65c);_0xcdcd4[_0x3f3c('0x4e')][_0x3f3c('0x51')]=_0x5357b0;break;case _0x3f3c('0x52'):if(_0x3a8565['operator']===_0x3f3c('0x46')){_0xcdcd4[_0x3f3c('0x53')][_0x44798e]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x3a8565[_0x3f3c('0x41')]+'%',null);}else{_0x4b9346=_['find'](_0x388859,[_0x3f3c('0xd'),_0x3f3c('0x54')]);_0x3a8565[_0x3f3c('0xc')]=_0x3f3c('0x54');_0x15264b=as[_0x3f3c('0x3e')](_0x57c1b7,_0x4b9346[_0x3f3c('0x4b')],_0x3a8565);_0xcdcd4[_0x3f3c('0x53')][_0x44798e](_0x15264b[_0x3f3c('0x40')],_0x15264b[_0x3f3c('0x41')][_0x3f3c('0x4c')],_0x15264b[_0x3f3c('0x41')][_0x3f3c('0x42')]);}break;case'body':case'plainBody':_0x15264b=as[_0x3f3c('0x3e')]('me',null,_0x3a8565);_0xcdcd4[_0x3f3c('0x55')][_0x44798e](_0x15264b[_0x3f3c('0x40')],_0x15264b['value'][_0x3f3c('0x4c')],_0x15264b[_0x3f3c('0x41')][_0x3f3c('0x42')]);break;}}}return _0xcdcd4;}function parseModelFields(_0x3d0a16,_0x4caa90,_0x266889){var _0x355286=utils['getAccountFK'](_0x3d0a16);var _0x2632d1=squel[_0x3f3c('0x29')]();var _0x21fff8=_(_0x4caa90)[_0x3f3c('0x56')]()[_0x3f3c('0x1c')](function(_0x59a821){return _[_0x3f3c('0x57')](_0x266889,[_0x3f3c('0xd'),_0x59a821])?_0x59a821:undefined;})['compact']()[_0x3f3c('0x41')]();if(_0x21fff8[_0x3f3c('0x19')]>0x0){_0x21fff8['forEach'](function(_0x1c785e){if(_0x1c785e===_0x355286){_0x2632d1[_0x3f3c('0x50')]('i.'+_0x355286+_0x3f3c('0x1b'),[][_0x3f3c('0x58')](_0x4caa90[_0x1c785e]));}else if(_0x1c785e===_0x3f3c('0x59')){var _0x57a3a4=JSON['parse'](_0x4caa90[_0x1c785e])[_0x3f3c('0x5a')];var _0x3c0f18=JSON[_0x3f3c('0x5b')](_0x4caa90[_0x1c785e])[_0x3f3c('0x5c')];_0x2632d1[_0x3f3c('0x50')](_0x3f3c('0x5d'),_0x57a3a4,_0x3c0f18);}else{if(_0x4caa90[_0x1c785e]===_0x3f3c('0x5e')){_0x2632d1['and']('i.'+_0x1c785e+_0x3f3c('0x5f'));}else{_0x2632d1[_0x3f3c('0x50')]('i.'+_0x1c785e+_0x3f3c('0x60'),_0x4caa90[_0x1c785e]);}}});}return _0x2632d1;}function parseQueryParameters(_0x27a6d7,_0x5d0276,_0x2e89d7){var _0x3a37a9=getSqlClauses();return Promise[_0x3f3c('0x61')]()[_0x3f3c('0x62')](function(){return parseModelFields(_0x27a6d7,_0x5d0276,_0x2e89d7);})[_0x3f3c('0x62')](function(_0x316284){_0x3a37a9[_0x3f3c('0x63')]['and'](_0x316284);return parseReadParameter(_0x5d0276[_0x3f3c('0x43')]);})[_0x3f3c('0x62')](function(_0x5a3aac){_0x3a37a9['read'][_0x3f3c('0x50')](_0x5a3aac);return parseTagParameter(_0x5d0276[_0x3f3c('0x64')]);})[_0x3f3c('0x62')](function(_0x3defd6){_0x3a37a9[_0x3f3c('0x4e')]['clause'][_0x3f3c('0x50')](_0x3defd6);return parseSearchFilter(_0x27a6d7,_0x5d0276['filter']);})[_0x3f3c('0x62')](function(_0x141efe){_0x3a37a9[_0x3f3c('0x65')]=_0x141efe;return _0x3a37a9;});}function checkAccountsRestrictions(_0x5b593f,_0x9ba6fb,_0x43a2c7){var _0x2eb12b=utils[_0x3f3c('0x1e')](_0x5b593f);var _0xa4391d='get'+_[_0x3f3c('0x66')](_0x5b593f)+(_0x5b593f==='chat'?_0x3f3c('0x67'):_0x3f3c('0x68'));var _0x5c8b08=squel[_0x3f3c('0x29')]();return Promise[_0x3f3c('0x61')]()['then'](function(){if(_0x43a2c7[_0x3f3c('0xa')]&&_0x9ba6fb[_0x3f3c('0x8')]===_0x3f3c('0x9')){return _0x9ba6fb[_0xa4391d]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x41c30e){if(_0x41c30e){if(_0x41c30e[_0x3f3c('0x19')]===0x0){_0x5c8b08[_0x3f3c('0x50')]('i.'+_0x2eb12b+'\x20IS\x20NULL');}else{_0x5c8b08[_0x3f3c('0x50')]('i.'+_0x2eb12b+_0x3f3c('0x1b'),_[_0x3f3c('0x1c')](_0x41c30e,'id'));}}else if(!_0x43a2c7[_0x2eb12b]){_0x5c8b08[_0x3f3c('0x50')]('i.'+_0x2eb12b+'\x20IS\x20NOT\x20NULL');}})['then'](function(){return _0x5c8b08;});}function getClosedOrderClause(_0x56e0bf,_0x490048){var _0x1e1aca='';var _0x1bdb42=[_0x3f3c('0x69'),'i.secondDisposition','i.disposition'];if(_0x56e0bf==='mail'){_0x1bdb42[_0x3f3c('0x6a')](_0x3f3c('0x6b'));}if(_0x490048[_0x3f3c('0x6c')]==='0'&&_0x56e0bf===_0x3f3c('0x33')){_0x1e1aca=_0x3f3c('0x6b');}else{if(_0x490048['closed']==='1'){_0x1bdb42[_0x3f3c('0x6d')]();}_0x1e1aca=_0x3f3c('0x6e')+_0x1bdb42[_0x3f3c('0x6f')](',\x20')+')';}return _0x1e1aca;}function getFilteredInteractions(_0x8fe2e9,_0x4b3dd9,_0x29fcb0,_0x3215ae){var _0x11cdae=utils[_0x3f3c('0x10')](_0x8fe2e9);var _0x1a4c6f=_['capitalize'](_0x8fe2e9)+_0x3f3c('0x70');var _0x309122=[];var _0x210a4b=getTagsQuery();var _0x310596={'type':db[_0x3f3c('0x71')][_0x3f3c('0x72')][_0x3f3c('0x73')],'raw':!![]};var _0x335e24=[];var _0x556efb=[];return db[_0x3f3c('0x74')]['query'](_0x210a4b[_0x3f3c('0x75')](),_0x310596)[_0x3f3c('0x62')](function(_0x305afd){_0x309122=_[_0x3f3c('0x76')](_0x305afd,'id');_0x310596=_[_0x3f3c('0x77')](_0x310596,{'model':db[_0x1a4c6f],'mapToModel':!![],'nest':!![]});if(_0x29fcb0[_0x3f3c('0x63')]){_0x3215ae['attributes'][_0x3f3c('0x78')](function(_0x1e0949){_0x4b3dd9[_0x3f3c('0xc')]('i.'+_0x1e0949);});}else{_0x4b3dd9['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x3f3c('0x79'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x7a'),_0x3f3c('0x7b'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x7c'),_0x3f3c('0x7d'));if(_0x8fe2e9===_0x3f3c('0x33')){_0x4b3dd9[_0x3f3c('0xc')]('a.email',_0x3f3c('0x7e'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x7f'),_0x3f3c('0x80'));_0x4b3dd9[_0x3f3c('0xc')]('i.id');_0x4b3dd9[_0x3f3c('0xc')]('i.createdAt');_0x4b3dd9[_0x3f3c('0xc')]('i.updatedAt');_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x81'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x82'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x83'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x84'));_0x4b3dd9[_0x3f3c('0xc')]('i.lastMsgDirection');_0x4b3dd9['field'](_0x3f3c('0x85'));_0x4b3dd9['field'](_0x3f3c('0x86'));_0x4b3dd9['field'](_0x3f3c('0x87'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x69'));_0x4b3dd9['field'](_0x3f3c('0x6b'));_0x4b3dd9[_0x3f3c('0xc')]('i.to');_0x4b3dd9['field']('i.ContactId');_0x4b3dd9['field'](_0x3f3c('0x88'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x89'));}else if(_0x8fe2e9===_0x3f3c('0x8a')){_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x8b'),_0x3f3c('0x80'));}else{_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x8c'),_0x3f3c('0x80'));}if(_0x8fe2e9!==_0x3f3c('0x33')){_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x8d'));}_0x4b3dd9['field'](_0x3f3c('0x8e'),'Contact.firstName');_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x8f'),'Contact.lastName');_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x90'),'Contact.email');_0x4b3dd9['field']('c.phone','Contact.phone');_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x91'),_0x3f3c('0x92'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x93'),_0x3f3c('0x94'));_0x4b3dd9[_0x3f3c('0xc')]('o.fullname',_0x3f3c('0x95'));_0x4b3dd9[_0x3f3c('0xc')](_0x3f3c('0x96'),'Owner.internal');_0x4b3dd9['field'](_0x3f3c('0x97'),_0x3f3c('0x98'));}if(_0x3215ae[_0x3f3c('0x99')]){_0x4b3dd9[_0x3f3c('0x99')](_0x3215ae[_0x3f3c('0x99')]);}if(_0x3215ae['offset']){_0x4b3dd9['offset'](_0x3215ae[_0x3f3c('0x9a')]);}return db[_0x3f3c('0x74')][_0x3f3c('0x9b')](_0x4b3dd9['toString'](),_0x310596);})[_0x3f3c('0x62')](function(_0x23ffdd){_0x335e24=_0x23ffdd;var _0x334662=getUsersQuery(_0x8fe2e9,_0x335e24);return db[_0x3f3c('0x74')][_0x3f3c('0x9b')](_0x334662['toString'](),_0x310596);})[_0x3f3c('0x62')](function(_0x3d2f35){_0x556efb=_['groupBy'](_0x3d2f35,_0x11cdae);if(_0x8fe2e9===_0x3f3c('0x33')){return db['Setting']['findOne']({'attributes':[_0x3f3c('0x9c')],'raw':!![]});}})['then'](function(_0x29bc11){var _0x2cd0e6=_0x29bc11?_0x29bc11[_0x3f3c('0x9c')]:undefined;var _0x5321f2=_0x335e24['map'](function(_0x7bbc94){return updateInteraction(_0x7bbc94,_0x309122,_0x556efb,_0x2cd0e6);});return Promise[_0x3f3c('0x9d')](_0x5321f2);});}function countFilteredInteractions(_0x5d207a,_0x1e87f6){var _0x4d95a7=_0x5d207a[_0x3f3c('0x9e')]();_0x4d95a7[_0x3f3c('0xc')](_0x3f3c('0x9f'));_0x4d95a7[_0x3f3c('0xc')](_0x3f3c('0xa0'),_0x3f3c('0x79'));var _0x3ca5fa=utils[_0x3f3c('0x2a')](_0x1e87f6);if(!_[_0x3f3c('0xa1')](_0x3ca5fa)){_0x4d95a7[_0x3f3c('0x1a')](_0x3f3c('0xa2'),_0x3ca5fa);}var _0x28fef7={'type':db['Sequelize']['QueryTypes'][_0x3f3c('0x73')],'raw':!![]};return db['sequelize']['query'](_0x4d95a7[_0x3f3c('0x75')](),_0x28fef7);}module[_0x3f3c('0xa3')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x4caf=['unreadMessages\x20{OPERATOR}\x200','{OPERATOR}','replace','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','i.from\x20LIKE\x20?','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','mail','c.email\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch','sqlOperator','conditions','buildExpression','text','start','value','end','unreadMessages','read','and','Contact','operator','$substring','split','contact','find','ContactId','type','Tag','tags','clause','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','user','body','plainBody','keys','some','compact','concat','parse','$gte','$lte','null','\x20=\x20?','then','tag','filter','capitalize','chat','Websites','Accounts','resolve','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.disposition','i.substatus','closed','shift','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','keyBy','merge','attributes','a.mandatoryDisposition','Account.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.closed','i.attach','i.lastMsgAt','i.subject','i.secondDisposition','i.to','i.ContactId','i.MailAccountId','i.UserId','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.*','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','limit','offset','toString','groupBy','Setting','findOne','enableEmailPreview','clone','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','t.id\x20IN\x20?','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','getAccountFK','role','search','select','field','name','from','tools_tags','getInteractionFK','_interactions','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','interactions','o.id\x20=\x20i.UserId','accounts','messages','me.','\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?'];(function(_0x5e859e,_0x4a4607){var _0x3fa5d5=function(_0x5972c0){while(--_0x5972c0){_0x5e859e['push'](_0x5e859e['shift']());}};_0x3fa5d5(++_0x4a4607);}(_0x4caf,0x7c));var _0xf4ca=function(_0x4897f3,_0x46d20c){_0x4897f3=_0x4897f3-0x0;var _0x596165=_0x4caf[_0x4897f3];return _0x596165;};'use strict';var _=require(_0xf4ca('0x0'));var squel=require(_0xf4ca('0x1'));var as=require(_0xf4ca('0x2'));var qs=require(_0xf4ca('0x3'));var updateInteraction=require(_0xf4ca('0x4'))[_0xf4ca('0x5')];var utils=require(_0xf4ca('0x6'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x416c94,_0x2d284b,_0x1f524e){var _0x2b48ea=![];var _0x3c6d86=utils[_0xf4ca('0x7')](_0x416c94);if(_0x2d284b[_0xf4ca('0x8')]==='agent'&&!_0x1f524e[_0xf4ca('0x9')]&&!_0x1f524e[_0x3c6d86]){_0x2b48ea=!![];}return _0x2b48ea;}function getTagsQuery(){return squel[_0xf4ca('0xa')]()[_0xf4ca('0xb')]('id')['field'](_0xf4ca('0xc'))['field']('color')[_0xf4ca('0xd')](_0xf4ca('0xe'));}function getUsersQuery(_0x4884b7,_0x322f67){var _0x52dea9=utils[_0xf4ca('0xf')](_0x4884b7);var _0x59873e='user_has_'+_0x4884b7+_0xf4ca('0x10');var _0x5b319c=squel[_0xf4ca('0xa')]()[_0xf4ca('0xb')]('u.id')[_0xf4ca('0xb')](_0xf4ca('0x11'))['field'](_0xf4ca('0x12')+_0x52dea9)[_0xf4ca('0xd')](_0x59873e,'ui')[_0xf4ca('0x13')](_0xf4ca('0x14'),'u',_0xf4ca('0x15'));if(_0x322f67[_0xf4ca('0x16')]>0x0){_0x5b319c[_0xf4ca('0x17')](_0xf4ca('0x12')+_0x52dea9+_0xf4ca('0x18'),_[_0xf4ca('0x19')](_0x322f67,'id'));}return _0x5b319c;}function getInteractionsQuery(_0x645ad4){var _0x4c4fb6=utils['getInteractionsTables'](_0x645ad4);var _0x9f5e98=utils[_0xf4ca('0x7')](_0x645ad4);var _0x8e9e89=utils[_0xf4ca('0xf')](_0x645ad4);return squel[_0xf4ca('0xa')]()[_0xf4ca('0xd')](_0x4c4fb6[_0xf4ca('0x1a')],'i')[_0xf4ca('0x13')]('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0xf4ca('0x13')]('users','o',_0xf4ca('0x1b'))[_0xf4ca('0x13')](_0x4c4fb6[_0xf4ca('0x1c')],'a','a.id\x20=\x20i.'+_0x9f5e98)[_0xf4ca('0x13')](_0x4c4fb6[_0xf4ca('0x1d')],'me',_0xf4ca('0x1e')+_0x8e9e89+_0xf4ca('0x1f'))[_0xf4ca('0x13')](_0x4c4fb6['interactionsTags'],'it','it.'+_0x8e9e89+_0xf4ca('0x1f'))['left_join'](_0xf4ca('0xe'),'t',_0xf4ca('0x20'));}function getSqlClauses(){var _0x4b046a={'body':squel[_0xf4ca('0x21')](),'contact':squel[_0xf4ca('0x21')](),'default':squel[_0xf4ca('0x21')](),'fields':squel[_0xf4ca('0x21')](),'filter':squel[_0xf4ca('0x21')](),'read':squel[_0xf4ca('0x21')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0xf4ca('0x21')]()};return _0x4b046a;}function parseTagParameter(_0x256424){var _0x3b0db9=squel[_0xf4ca('0x21')]();if(_0x256424){var _0x1f5ed0=utils[_0xf4ca('0x22')](_0x256424);_0x1f5ed0[_0xf4ca('0x23')](function(_0x480616){_0x3b0db9['or'](_0xf4ca('0x24'),'%,'+_0x480616+',%');});}return _0x3b0db9;}function parseReadParameter(_0xeef30e){var _0x59e7db='';if(_0xeef30e){_0x59e7db=_0xf4ca('0x25');if(_0xeef30e==='1'){_0x59e7db=_0x59e7db['replace'](_0xf4ca('0x26'),'=');}else{_0x59e7db=_0x59e7db['replace']('{OPERATOR}','>');}}return _0x59e7db;}function parseSearchFilter(_0x5d6333,_0x4cc91e){var _0x57cc12=squel[_0xf4ca('0x21')]();if(_0x4cc91e){var _0x3a6a84=_0x4cc91e['replace']('\x5c','\x5c\x5c')[_0xf4ca('0x27')](/'/g,'\x27\x27');if(qs[_0xf4ca('0x28')](_0x3a6a84)){_0x57cc12['or'](_0xf4ca('0x29'),_0x3a6a84+'%');switch(_0x5d6333){case _0xf4ca('0x2a'):case _0xf4ca('0x2b'):_0x57cc12['or'](_0xf4ca('0x2c'),_0x3a6a84+'%');break;case _0xf4ca('0x2d'):_0x57cc12['or'](_0xf4ca('0x2e'),_0x3a6a84+'%');break;case'openchannel':_0x57cc12['or'](_0xf4ca('0x2f'),_0x3a6a84+'%');break;case'mail':_0x57cc12['or'](_0xf4ca('0x30'),qs['getFullTextValue'](_0x3a6a84,!![]))['or'](_0xf4ca('0x31'),qs[_0xf4ca('0x32')](_0x3a6a84));break;}}else if(_0x5d6333===_0xf4ca('0x33')&&qs['isEmail'](_0x3a6a84)){_0x57cc12['or'](_0xf4ca('0x34'),_0x3a6a84+'%');}else{if(_0x5d6333===_0xf4ca('0x33')){_0x57cc12['or'](_0xf4ca('0x30'),qs['getFullTextValue'](_0x3a6a84,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xf4ca('0x32')](_0x3a6a84));}else if(_0x5d6333!==_0xf4ca('0x2d')){_0x57cc12['or'](_0xf4ca('0x35'),qs['getFullTextValue'](_0x3a6a84));}_0x57cc12['or'](_0xf4ca('0x36'),qs['getFullTextValue'](_0x3a6a84,!![]),null);}}return _0x57cc12;}function parseAdvancedSearchFilter(_0x48db5d,_0x10e2de){var _0x545af2=getSqlClauses();var _0x117af9=as[_0xf4ca('0x37')](_0x48db5d);var _0x440d9d=_0x117af9[_0xf4ca('0x38')];for(var _0x4bdca3=0x0;_0x4bdca3<_0x117af9['conditions'][_0xf4ca('0x16')];_0x4bdca3++){var _0x450125=_0x117af9[_0xf4ca('0x39')][_0x4bdca3];var _0x494799='i';var _0x1195c8=_['find'](_0x10e2de,[_0xf4ca('0xc'),_0x450125['field']]);if(_0x1195c8){var _0x98b3cd=as[_0xf4ca('0x3a')](_0x494799,_0x1195c8['type'],_0x450125);_0x545af2['default'][_0x440d9d](_0x98b3cd[_0xf4ca('0x3b')],_0x98b3cd['value'][_0xf4ca('0x3c')],_0x98b3cd[_0xf4ca('0x3d')][_0xf4ca('0x3e')]);}else{switch(_0x450125[_0xf4ca('0xb')]){case _0xf4ca('0x3f'):var _0x3b9e70=parseReadParameter(_0x450125[_0xf4ca('0x3d')]);_0x545af2[_0xf4ca('0x40')][_0xf4ca('0x41')](_0x3b9e70);break;case _0xf4ca('0x42'):if(_0x450125[_0xf4ca('0x43')]===_0xf4ca('0x44')){if(_0x450125[_0xf4ca('0x3d')][_0xf4ca('0x45')]('\x20')[_0xf4ca('0x16')]>0x1){_0x545af2['contact'][_0x440d9d](_0xf4ca('0x36'),qs['getFullTextValue'](_0x450125['value'],!![]),null);}else{var _0x37b9f5='%'+_0x450125[_0xf4ca('0x3d')]+'%';_0x545af2[_0xf4ca('0x46')][_0x440d9d]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x37b9f5,_0x37b9f5,_0x37b9f5);}}else{_0x1195c8=_[_0xf4ca('0x47')](_0x10e2de,[_0xf4ca('0xc'),_0xf4ca('0x48')]);_0x450125[_0xf4ca('0xb')]=_0xf4ca('0x48');_0x98b3cd=as[_0xf4ca('0x3a')](_0x494799,_0x1195c8[_0xf4ca('0x49')],_0x450125);_0x545af2[_0xf4ca('0x46')][_0x440d9d](_0x98b3cd['text'],_0x98b3cd[_0xf4ca('0x3d')][_0xf4ca('0x3c')],_0x98b3cd[_0xf4ca('0x3d')][_0xf4ca('0x3e')]);}break;case _0xf4ca('0x4a'):var _0x4e8281=_0x450125['value'][_0xf4ca('0x45')](',')[_0xf4ca('0x19')](function(_0x26bc65){return Number(_0x26bc65);});var _0x25d3dc=parseTagParameter(_0x4e8281);_0x545af2[_0xf4ca('0x4b')][_0xf4ca('0x4c')][_0xf4ca('0x41')](_0x25d3dc);_0x545af2[_0xf4ca('0x4b')]['ids']=_0x4e8281;break;case _0xf4ca('0x4d'):if(_0x450125[_0xf4ca('0x43')]==='$substring'){_0x545af2['user'][_0x440d9d](_0xf4ca('0x4e'),'%'+_0x450125[_0xf4ca('0x3d')]+'%',null);}else{_0x1195c8=_['find'](_0x10e2de,[_0xf4ca('0xc'),'UserId']);_0x450125[_0xf4ca('0xb')]=_0xf4ca('0x4f');_0x98b3cd=as[_0xf4ca('0x3a')](_0x494799,_0x1195c8['type'],_0x450125);_0x545af2[_0xf4ca('0x50')][_0x440d9d](_0x98b3cd[_0xf4ca('0x3b')],_0x98b3cd[_0xf4ca('0x3d')][_0xf4ca('0x3c')],_0x98b3cd['value'][_0xf4ca('0x3e')]);}break;case _0xf4ca('0x51'):case _0xf4ca('0x52'):_0x98b3cd=as[_0xf4ca('0x3a')]('me',null,_0x450125);_0x545af2['body'][_0x440d9d](_0x98b3cd[_0xf4ca('0x3b')],_0x98b3cd['value']['start'],_0x98b3cd[_0xf4ca('0x3d')][_0xf4ca('0x3e')]);break;}}}return _0x545af2;}function parseModelFields(_0x48ba63,_0x561145,_0x5741cd){var _0x50908d=utils['getAccountFK'](_0x48ba63);var _0x1bc6eb=squel['expr']();var _0x277415=_(_0x561145)[_0xf4ca('0x53')]()[_0xf4ca('0x19')](function(_0x2fce67){return _[_0xf4ca('0x54')](_0x5741cd,['name',_0x2fce67])?_0x2fce67:undefined;})[_0xf4ca('0x55')]()[_0xf4ca('0x3d')]();if(_0x277415[_0xf4ca('0x16')]>0x0){_0x277415[_0xf4ca('0x23')](function(_0x583ae1){if(_0x583ae1===_0x50908d){_0x1bc6eb['and']('i.'+_0x50908d+_0xf4ca('0x18'),[][_0xf4ca('0x56')](_0x561145[_0x583ae1]));}else if(_0x583ae1==='createdAt'){var _0x5b721c=JSON[_0xf4ca('0x57')](_0x561145[_0x583ae1])[_0xf4ca('0x58')];var _0x4f4cfd=JSON[_0xf4ca('0x57')](_0x561145[_0x583ae1])[_0xf4ca('0x59')];_0x1bc6eb[_0xf4ca('0x41')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x5b721c,_0x4f4cfd);}else{if(_0x561145[_0x583ae1]===_0xf4ca('0x5a')){_0x1bc6eb[_0xf4ca('0x41')]('i.'+_0x583ae1+'\x20IS\x20NULL');}else{_0x1bc6eb['and']('i.'+_0x583ae1+_0xf4ca('0x5b'),_0x561145[_0x583ae1]);}}});}return _0x1bc6eb;}function parseQueryParameters(_0x2e18c5,_0x2562c7,_0x4c89da){var _0x372651=getSqlClauses();return Promise['resolve']()[_0xf4ca('0x5c')](function(){return parseModelFields(_0x2e18c5,_0x2562c7,_0x4c89da);})[_0xf4ca('0x5c')](function(_0x51b840){_0x372651['fields'][_0xf4ca('0x41')](_0x51b840);return parseReadParameter(_0x2562c7[_0xf4ca('0x40')]);})[_0xf4ca('0x5c')](function(_0x5d8638){_0x372651[_0xf4ca('0x40')]['and'](_0x5d8638);return parseTagParameter(_0x2562c7[_0xf4ca('0x5d')]);})['then'](function(_0x35185f){_0x372651['tags'][_0xf4ca('0x4c')][_0xf4ca('0x41')](_0x35185f);return parseSearchFilter(_0x2e18c5,_0x2562c7[_0xf4ca('0x5e')]);})[_0xf4ca('0x5c')](function(_0x5ba3b8){_0x372651[_0xf4ca('0x5e')]=_0x5ba3b8;return _0x372651;});}function checkAccountsRestrictions(_0x205625,_0xf25200,_0x4e72ff){var _0x2b1a50=utils[_0xf4ca('0x7')](_0x205625);var _0x1d0a8a='get'+_[_0xf4ca('0x5f')](_0x205625)+(_0x205625===_0xf4ca('0x60')?_0xf4ca('0x61'):_0xf4ca('0x62'));var _0x292c22=squel[_0xf4ca('0x21')]();return Promise[_0xf4ca('0x63')]()[_0xf4ca('0x5c')](function(){if(_0x4e72ff[_0xf4ca('0x9')]&&_0xf25200[_0xf4ca('0x8')]===_0xf4ca('0x64')){return _0xf25200[_0x1d0a8a]({'attributes':['id'],'raw':!![]});}})[_0xf4ca('0x5c')](function(_0x5ae859){if(_0x5ae859){if(_0x5ae859[_0xf4ca('0x16')]===0x0){_0x292c22['and']('i.'+_0x2b1a50+'\x20IS\x20NULL');}else{_0x292c22['and']('i.'+_0x2b1a50+_0xf4ca('0x18'),_[_0xf4ca('0x19')](_0x5ae859,'id'));}}else if(!_0x4e72ff[_0x2b1a50]){_0x292c22[_0xf4ca('0x41')]('i.'+_0x2b1a50+_0xf4ca('0x65'));}})[_0xf4ca('0x5c')](function(){return _0x292c22;});}function getClosedOrderClause(_0x7172e1,_0x4ae044){var _0x3f8809='';var _0x1a38a5=[_0xf4ca('0x66'),'i.secondDisposition',_0xf4ca('0x67')];if(_0x7172e1===_0xf4ca('0x33')){_0x1a38a5['unshift'](_0xf4ca('0x68'));}if(_0x4ae044['closed']==='0'&&_0x7172e1===_0xf4ca('0x33')){_0x3f8809=_0xf4ca('0x68');}else{if(_0x4ae044[_0xf4ca('0x69')]==='1'){_0x1a38a5[_0xf4ca('0x6a')]();}_0x3f8809='CONCAT_WS(\x27\x27,\x20'+_0x1a38a5[_0xf4ca('0x6b')](',\x20')+')';}return _0x3f8809;}function getFilteredInteractions(_0x2818d7,_0x2bd56a,_0x7b72f3,_0x11ab1a){var _0x5a5bb0=utils[_0xf4ca('0xf')](_0x2818d7);var _0x2b7219=_[_0xf4ca('0x5f')](_0x2818d7)+_0xf4ca('0x6c');var _0x383c3e=[];var _0x33c7b2=getTagsQuery();var _0x50eb6a={'type':db[_0xf4ca('0x6d')][_0xf4ca('0x6e')][_0xf4ca('0x6f')],'raw':!![]};var _0x241a95=[];var _0x340b16=[];return db[_0xf4ca('0x70')][_0xf4ca('0x71')](_0x33c7b2['toString'](),_0x50eb6a)['then'](function(_0x2b3fe3){_0x383c3e=_[_0xf4ca('0x72')](_0x2b3fe3,'id');_0x50eb6a=_[_0xf4ca('0x73')](_0x50eb6a,{'model':db[_0x2b7219],'mapToModel':!![],'nest':!![]});if(_0x7b72f3['fields']){_0x11ab1a[_0xf4ca('0x74')][_0xf4ca('0x23')](function(_0x1d4e61){_0x2bd56a[_0xf4ca('0xb')]('i.'+_0x1d4e61);});}else{_0x2bd56a[_0xf4ca('0xb')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xf4ca('0x3f'));_0x2bd56a[_0xf4ca('0xb')]('a.key','Account.key');_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x75'),_0xf4ca('0x76'));if(_0x2818d7==='mail'){_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x77'),_0xf4ca('0x78'));_0x2bd56a['field'](_0xf4ca('0x79'),_0xf4ca('0x7a'));_0x2bd56a[_0xf4ca('0xb')]('i.id');_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x7b'));_0x2bd56a[_0xf4ca('0xb')]('i.updatedAt');_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x7c'));_0x2bd56a[_0xf4ca('0xb')]('i.closedAt');_0x2bd56a['field'](_0xf4ca('0x7d'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x7e'));_0x2bd56a[_0xf4ca('0xb')]('i.lastMsgDirection');_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x7f'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x67'));_0x2bd56a['field'](_0xf4ca('0x80'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x66'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x68'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x81'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x82'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x83'));_0x2bd56a['field'](_0xf4ca('0x84'));}else if(_0x2818d7==='openchannel'){_0x2bd56a[_0xf4ca('0xb')]('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',_0xf4ca('0x7a'));}else{_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x85'),_0xf4ca('0x7a'));}if(_0x2818d7!==_0xf4ca('0x33')){_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x86'));}_0x2bd56a[_0xf4ca('0xb')]('c.firstName',_0xf4ca('0x87'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x88'),_0xf4ca('0x89'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x8a'),_0xf4ca('0x8b'));_0x2bd56a[_0xf4ca('0xb')]('c.phone',_0xf4ca('0x8c'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x8d'),_0xf4ca('0x8e'));_0x2bd56a['field'](_0xf4ca('0x8f'),_0xf4ca('0x90'));_0x2bd56a[_0xf4ca('0xb')](_0xf4ca('0x91'),_0xf4ca('0x92'));_0x2bd56a['field'](_0xf4ca('0x93'),_0xf4ca('0x94'));_0x2bd56a[_0xf4ca('0xb')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x11ab1a[_0xf4ca('0x95')]){_0x2bd56a[_0xf4ca('0x95')](_0x11ab1a[_0xf4ca('0x95')]);}if(_0x11ab1a[_0xf4ca('0x96')]){_0x2bd56a[_0xf4ca('0x96')](_0x11ab1a[_0xf4ca('0x96')]);}return db[_0xf4ca('0x70')]['query'](_0x2bd56a[_0xf4ca('0x97')](),_0x50eb6a);})[_0xf4ca('0x5c')](function(_0x462c02){_0x241a95=_0x462c02;var _0x3f43fa=getUsersQuery(_0x2818d7,_0x241a95);return db[_0xf4ca('0x70')][_0xf4ca('0x71')](_0x3f43fa['toString'](),_0x50eb6a);})[_0xf4ca('0x5c')](function(_0x279c39){_0x340b16=_[_0xf4ca('0x98')](_0x279c39,_0x5a5bb0);if(_0x2818d7===_0xf4ca('0x33')){return db[_0xf4ca('0x99')][_0xf4ca('0x9a')]({'attributes':[_0xf4ca('0x9b')],'raw':!![]});}})[_0xf4ca('0x5c')](function(_0xf323f){var _0x324ac5=_0xf323f?_0xf323f[_0xf4ca('0x9b')]:undefined;var _0x4f675a=_0x241a95[_0xf4ca('0x19')](function(_0x79682e){return updateInteraction(_0x79682e,_0x383c3e,_0x340b16,_0x324ac5);});return Promise['all'](_0x4f675a);});}function countFilteredInteractions(_0x4e1c5f,_0x3c599f){var _0x40d5ad=_0x4e1c5f[_0xf4ca('0x9c')]();_0x40d5ad['field'](_0xf4ca('0x9d'));_0x40d5ad[_0xf4ca('0xb')](_0xf4ca('0x9e'),_0xf4ca('0x3f'));var _0x53e47a=utils[_0xf4ca('0x22')](_0x3c599f);if(!_['isEmpty'](_0x53e47a)){_0x40d5ad[_0xf4ca('0x17')](_0xf4ca('0x9f'),_0x53e47a);}var _0x56ddf5={'type':db[_0xf4ca('0x6d')][_0xf4ca('0x6e')][_0xf4ca('0x6f')],'raw':!![]};return db[_0xf4ca('0x70')][_0xf4ca('0x71')](_0x40d5ad['toString'](),_0x56ddf5);}module[_0xf4ca('0xa0')]={'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