// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x7a2c=['some','compact','parse','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','resolve','then','tag','filter','get','capitalize','chat','Accounts','role','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','join','Interaction','Sequelize','QueryTypes','SELECT','query','keyBy','merge','attributes','forEach','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','Account.key','Account.mandatoryDisposition','a.email','contactName','i.updatedAt','i.closed','i.closedAt','i.lastMsgAt','i.lastMsgDirection','i.subject','i.to','i.ContactId','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.*','c.firstName','c.lastName','Contact.lastName','Contact.email','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','TagIds','limit','offset','sequelize','toString','Setting','findOne','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','lodash','../parsers/advancedSearch','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','search','select','field','color','from','getInteractionFK','_interactions','u.id','u.fullname','ui.','left_join','users','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','map','getInteractionsTables','getAccountFK','cm_contacts','o.id\x20=\x20i.UserId','accounts','a.id\x20=\x20i.','messages','me.','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','{OPERATOR}','replace','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','i.fax\x20LIKE\x20?','mail','getFullTextValue','fax','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','parseSearch','sqlOperator','conditions','find','name','buildExpression','type','text','value','end','unreadMessages','read','and','operator','split','contact','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','start','Tag','tags','ids','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','body','plainBody','keys'];(function(_0x1c2571,_0x4fb247){var _0x51e16a=function(_0x96c1d9){while(--_0x96c1d9){_0x1c2571['push'](_0x1c2571['shift']());}};_0x51e16a(++_0x4fb247);}(_0x7a2c,0x17b));var _0xc7a2=function(_0x52ed40,_0xae19b8){_0x52ed40=_0x52ed40-0x0;var _0x3892eb=_0x7a2c[_0x52ed40];return _0x3892eb;};'use strict';var _=require(_0xc7a2('0x0'));var squel=require('squel');var as=require(_0xc7a2('0x1'));var qs=require(_0xc7a2('0x2'));var updateInteraction=require(_0xc7a2('0x3'))[_0xc7a2('0x4')];var utils=require(_0xc7a2('0x5'));var db=require(_0xc7a2('0x6'))['db'];function skipInteractionsQuery(_0x3f2b0d,_0x34cd60,_0x489232){var _0x3a47c8=![];var _0x1ddbae=utils['getAccountFK'](_0x3f2b0d);if(_0x34cd60['role']==='agent'&&!_0x489232[_0xc7a2('0x7')]&&!_0x489232[_0x1ddbae]){_0x3a47c8=!![];}return _0x3a47c8;}function getTagsQuery(){return squel[_0xc7a2('0x8')]()[_0xc7a2('0x9')]('id')[_0xc7a2('0x9')]('name')[_0xc7a2('0x9')](_0xc7a2('0xa'))[_0xc7a2('0xb')]('tools_tags');}function getUsersQuery(_0x2c3f86,_0x4a44c7){var _0x3e216a=utils[_0xc7a2('0xc')](_0x2c3f86);var _0x1a9b38='user_has_'+_0x2c3f86+_0xc7a2('0xd');var _0x28d414=squel[_0xc7a2('0x8')]()['field'](_0xc7a2('0xe'))[_0xc7a2('0x9')](_0xc7a2('0xf'))[_0xc7a2('0x9')](_0xc7a2('0x10')+_0x3e216a)[_0xc7a2('0xb')](_0x1a9b38,'ui')[_0xc7a2('0x11')](_0xc7a2('0x12'),'u',_0xc7a2('0x13'));if(_0x4a44c7[_0xc7a2('0x14')]>0x0){_0x28d414[_0xc7a2('0x15')](_0xc7a2('0x10')+_0x3e216a+_0xc7a2('0x16'),_[_0xc7a2('0x17')](_0x4a44c7,'id'));}return _0x28d414;}function getInteractionsQuery(_0x2bc321){var _0x506396=utils[_0xc7a2('0x18')](_0x2bc321);var _0x59e8ad=utils[_0xc7a2('0x19')](_0x2bc321);var _0x302d54=utils[_0xc7a2('0xc')](_0x2bc321);return squel[_0xc7a2('0x8')]()['from'](_0x506396['interactions'],'i')[_0xc7a2('0x11')](_0xc7a2('0x1a'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')['left_join']('users','o',_0xc7a2('0x1b'))['left_join'](_0x506396[_0xc7a2('0x1c')],'a',_0xc7a2('0x1d')+_0x59e8ad)['left_join'](_0x506396[_0xc7a2('0x1e')],'me',_0xc7a2('0x1f')+_0x302d54+_0xc7a2('0x20'))[_0xc7a2('0x11')](_0x506396[_0xc7a2('0x21')],'it',_0xc7a2('0x22')+_0x302d54+_0xc7a2('0x20'))['left_join']('tools_tags','t',_0xc7a2('0x23'));}function getSqlClauses(){var _0x1c3fb8={'body':squel['expr'](),'contact':squel[_0xc7a2('0x24')](),'default':squel[_0xc7a2('0x24')](),'fields':squel[_0xc7a2('0x24')](),'filter':squel[_0xc7a2('0x24')](),'read':squel[_0xc7a2('0x24')](),'tags':{'clause':squel[_0xc7a2('0x24')](),'ids':null},'user':squel[_0xc7a2('0x24')]()};return _0x1c3fb8;}function parseTagParameter(_0x429b05){var _0x591860=squel[_0xc7a2('0x24')]();if(_0x429b05){var _0x505fe8=utils[_0xc7a2('0x25')](_0x429b05);_0x505fe8['forEach'](function(_0x20404b){_0x591860['or'](_0xc7a2('0x26'),'%,'+_0x20404b+',%');});}return _0x591860;}function parseReadParameter(_0xd93f19){var _0x3959c9='';if(_0xd93f19){_0x3959c9='unreadMessages\x20{OPERATOR}\x200';if(_0xd93f19==='1'){_0x3959c9=_0x3959c9['replace'](_0xc7a2('0x27'),'=');}else{_0x3959c9=_0x3959c9[_0xc7a2('0x28')](_0xc7a2('0x27'),'>');}}return _0x3959c9;}function parseSearchFilter(_0x305efb,_0x3be88c){var _0x306e99=squel[_0xc7a2('0x24')]();if(_0x3be88c){var _0x5e970e=_0x3be88c[_0xc7a2('0x28')]('\x5c','\x5c\x5c')[_0xc7a2('0x28')](/'/g,'\x27\x27');if(qs['isNumeric'](_0x5e970e)){_0x306e99['or'](_0xc7a2('0x29'),_0x5e970e+'%');if([_0xc7a2('0x2a'),_0xc7a2('0x2b')]['includes'](_0x305efb)){_0x306e99['or'](_0xc7a2('0x2c'),_0x5e970e+'%');}else if(_0x305efb==='fax'){_0x306e99['or'](_0xc7a2('0x2d'),_0x5e970e+'%');}else if(_0x305efb==='openchannel'){_0x306e99['or']('i.from\x20LIKE\x20?',_0x5e970e+'%');}}else if(_0x305efb===_0xc7a2('0x2e')&&qs['isEmail'](_0x5e970e)){_0x306e99['or']('c.email\x20LIKE\x20?',_0x5e970e+'%');}else{if(_0x305efb===_0xc7a2('0x2e')){_0x306e99['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xc7a2('0x2f')](_0x5e970e))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xc7a2('0x2f')](_0x5e970e));}else{if(_0x305efb!==_0xc7a2('0x30')){_0x306e99['or'](_0xc7a2('0x31'),qs[_0xc7a2('0x2f')](_0x5e970e));}_0x306e99['or'](_0xc7a2('0x32'),_0x5e970e+'%');}}}return _0x306e99;}function parseAdvancedSearchFilter(_0x4226e3,_0x1e10fc){var _0x2a3bfb=getSqlClauses();var _0x29771b=as[_0xc7a2('0x33')](_0x4226e3);var _0x4ba53e=_0x29771b[_0xc7a2('0x34')];for(var _0x41a503=0x0;_0x41a503<_0x29771b['conditions'][_0xc7a2('0x14')];_0x41a503++){var _0xf7ed4a=_0x29771b[_0xc7a2('0x35')][_0x41a503];var _0x23187f='i';var _0x178c3e=_[_0xc7a2('0x36')](_0x1e10fc,[_0xc7a2('0x37'),_0xf7ed4a['field']]);if(_0x178c3e){var _0x4124bd=as[_0xc7a2('0x38')](_0x23187f,_0x178c3e[_0xc7a2('0x39')],_0xf7ed4a);_0x2a3bfb['default'][_0x4ba53e](_0x4124bd[_0xc7a2('0x3a')],_0x4124bd[_0xc7a2('0x3b')]['start'],_0x4124bd[_0xc7a2('0x3b')][_0xc7a2('0x3c')]);}else{switch(_0xf7ed4a[_0xc7a2('0x9')]){case _0xc7a2('0x3d'):var _0x2cdef8=parseReadParameter(_0xf7ed4a[_0xc7a2('0x3b')]);_0x2a3bfb[_0xc7a2('0x3e')][_0xc7a2('0x3f')](_0x2cdef8);break;case'Contact':if(_0xf7ed4a[_0xc7a2('0x40')]==='$substring'){if(_0xf7ed4a[_0xc7a2('0x3b')][_0xc7a2('0x41')]('\x20')[_0xc7a2('0x14')]>0x1){_0x2a3bfb[_0xc7a2('0x42')][_0x4ba53e](_0xc7a2('0x43'),qs[_0xc7a2('0x2f')](_0xf7ed4a[_0xc7a2('0x3b')]),null);}else{var _0x36f376='%'+_0xf7ed4a['value']+'%';_0x2a3bfb[_0xc7a2('0x42')][_0x4ba53e](_0xc7a2('0x44'),_0x36f376,_0x36f376,_0x36f376);}}else{_0x178c3e=_[_0xc7a2('0x36')](_0x1e10fc,[_0xc7a2('0x37'),_0xc7a2('0x45')]);_0xf7ed4a[_0xc7a2('0x9')]='ContactId';_0x4124bd=as['buildExpression'](_0x23187f,_0x178c3e['type'],_0xf7ed4a);_0x2a3bfb[_0xc7a2('0x42')][_0x4ba53e](_0x4124bd[_0xc7a2('0x3a')],_0x4124bd[_0xc7a2('0x3b')][_0xc7a2('0x46')],_0x4124bd[_0xc7a2('0x3b')][_0xc7a2('0x3c')]);}break;case _0xc7a2('0x47'):var _0x13d3b4=_0xf7ed4a[_0xc7a2('0x3b')]['split'](',')['map'](function(_0x4bcb42){return Number(_0x4bcb42);});var _0x47696c=parseTagParameter(_0x13d3b4);_0x2a3bfb[_0xc7a2('0x48')]['clause'][_0xc7a2('0x3f')](_0x47696c);_0x2a3bfb[_0xc7a2('0x48')][_0xc7a2('0x49')]=_0x13d3b4;break;case'User':if(_0xf7ed4a[_0xc7a2('0x40')]==='$substring'){_0x2a3bfb[_0xc7a2('0x4a')][_0x4ba53e](_0xc7a2('0x4b'),'%'+_0xf7ed4a['value']+'%',null);}else{_0x178c3e=_['find'](_0x1e10fc,[_0xc7a2('0x37'),_0xc7a2('0x4c')]);_0xf7ed4a['field']=_0xc7a2('0x4c');_0x4124bd=as[_0xc7a2('0x38')](_0x23187f,_0x178c3e[_0xc7a2('0x39')],_0xf7ed4a);_0x2a3bfb[_0xc7a2('0x4a')][_0x4ba53e](_0x4124bd[_0xc7a2('0x3a')],_0x4124bd[_0xc7a2('0x3b')]['start'],_0x4124bd[_0xc7a2('0x3b')][_0xc7a2('0x3c')]);}break;case _0xc7a2('0x4d'):case _0xc7a2('0x4e'):_0x4124bd=as['buildExpression']('me',null,_0xf7ed4a);_0x2a3bfb[_0xc7a2('0x4d')][_0x4ba53e](_0x4124bd[_0xc7a2('0x3a')],_0x4124bd[_0xc7a2('0x3b')][_0xc7a2('0x46')],_0x4124bd[_0xc7a2('0x3b')][_0xc7a2('0x3c')]);break;}}}return _0x2a3bfb;}function parseModelFields(_0x7378ed,_0xdc4644,_0x5f5154){var _0x37bce7=utils[_0xc7a2('0x19')](_0x7378ed);var _0x18b00a=squel[_0xc7a2('0x24')]();var _0x4ef4c1=_(_0xdc4644)[_0xc7a2('0x4f')]()[_0xc7a2('0x17')](function(_0x512375){return _[_0xc7a2('0x50')](_0x5f5154,[_0xc7a2('0x37'),_0x512375])?_0x512375:undefined;})[_0xc7a2('0x51')]()[_0xc7a2('0x3b')]();if(_0x4ef4c1[_0xc7a2('0x14')]>0x0){_0x4ef4c1['forEach'](function(_0x306047){if(_0x306047===_0x37bce7){_0x18b00a[_0xc7a2('0x3f')]('i.'+_0x37bce7+_0xc7a2('0x16'),[]['concat'](_0xdc4644[_0x306047]));}else if(_0x306047==='createdAt'){var _0x223755=JSON['parse'](_0xdc4644[_0x306047])['$gte'];var _0x340154=JSON[_0xc7a2('0x52')](_0xdc4644[_0x306047])['$lte'];_0x18b00a['and'](_0xc7a2('0x53'),_0x223755,_0x340154);}else{if(_0xdc4644[_0x306047]===_0xc7a2('0x54')){_0x18b00a[_0xc7a2('0x3f')]('i.'+_0x306047+_0xc7a2('0x55'));}else{_0x18b00a[_0xc7a2('0x3f')]('i.'+_0x306047+'\x20=\x20?',_0xdc4644[_0x306047]);}}});}return _0x18b00a;}function parseQueryParameters(_0x3754a4,_0x179bc1,_0x581509){var _0x3e7c7e=getSqlClauses();return Promise[_0xc7a2('0x56')]()[_0xc7a2('0x57')](function(){return parseModelFields(_0x3754a4,_0x179bc1,_0x581509);})[_0xc7a2('0x57')](function(_0x1f4c96){_0x3e7c7e['fields'][_0xc7a2('0x3f')](_0x1f4c96);return parseReadParameter(_0x179bc1[_0xc7a2('0x3e')]);})[_0xc7a2('0x57')](function(_0x5f3622){_0x3e7c7e[_0xc7a2('0x3e')][_0xc7a2('0x3f')](_0x5f3622);return parseTagParameter(_0x179bc1[_0xc7a2('0x58')]);})[_0xc7a2('0x57')](function(_0x2f53e9){_0x3e7c7e[_0xc7a2('0x48')]['clause'][_0xc7a2('0x3f')](_0x2f53e9);return parseSearchFilter(_0x3754a4,_0x179bc1[_0xc7a2('0x59')]);})[_0xc7a2('0x57')](function(_0x332e8e){_0x3e7c7e[_0xc7a2('0x59')]=_0x332e8e;return _0x3e7c7e;});}function checkAccountsRestrictions(_0x1f0762,_0x2885fe,_0x50a80a){var _0x2b1bb3=utils['getAccountFK'](_0x1f0762);var _0x4e1efa=_0xc7a2('0x5a')+_[_0xc7a2('0x5b')](_0x1f0762)+(_0x1f0762===_0xc7a2('0x5c')?'Websites':_0xc7a2('0x5d'));var _0x4d2973=squel['expr']();return Promise[_0xc7a2('0x56')]()[_0xc7a2('0x57')](function(){if(_0x50a80a[_0xc7a2('0x7')]&&_0x2885fe[_0xc7a2('0x5e')]===_0xc7a2('0x5f')){return _0x2885fe[_0x4e1efa]({'attributes':['id'],'raw':!![]});}})[_0xc7a2('0x57')](function(_0x4e2d6a){if(_0x4e2d6a){if(_0x4e2d6a['length']===0x0){_0x4d2973['and']('i.'+_0x2b1bb3+_0xc7a2('0x55'));}else{_0x4d2973['and']('i.'+_0x2b1bb3+'\x20IN\x20?',_['map'](_0x4e2d6a,'id'));}}else if(!_0x50a80a[_0x2b1bb3]){_0x4d2973['and']('i.'+_0x2b1bb3+_0xc7a2('0x60'));}})[_0xc7a2('0x57')](function(){return _0x4d2973;});}function getClosedOrderClause(_0xfd65d8,_0x15b8fd){var _0x52c83a='';var _0x160fe3=[_0xc7a2('0x61'),_0xc7a2('0x62'),_0xc7a2('0x63')];if(_0xfd65d8===_0xc7a2('0x2e')){_0x160fe3[_0xc7a2('0x64')](_0xc7a2('0x65'));}if(_0x15b8fd[_0xc7a2('0x66')]==='0'&&_0xfd65d8===_0xc7a2('0x2e')){_0x52c83a=_0xc7a2('0x65');}else{if(_0x15b8fd[_0xc7a2('0x66')]==='1'){_0x160fe3['shift']();}_0x52c83a='CONCAT_WS(\x27\x27,\x20'+_0x160fe3[_0xc7a2('0x67')](',\x20')+')';}return _0x52c83a;}function getFilteredInteractions(_0x5e5466,_0xf8dbd1,_0xe09b54,_0x3dc131){var _0x29f1e7=utils['getInteractionFK'](_0x5e5466);var _0xfe5203=_[_0xc7a2('0x5b')](_0x5e5466)+_0xc7a2('0x68');var _0xc7ce86=[];var _0x20331b=getTagsQuery();var _0x5765f0={'type':db[_0xc7a2('0x69')][_0xc7a2('0x6a')][_0xc7a2('0x6b')],'raw':!![]};var _0x45044a=[];var _0x23d7bc=[];return db['sequelize'][_0xc7a2('0x6c')](_0x20331b['toString'](),_0x5765f0)['then'](function(_0x3c06a8){_0xc7ce86=_[_0xc7a2('0x6d')](_0x3c06a8,'id');_0x5765f0=_[_0xc7a2('0x6e')](_0x5765f0,{'model':db[_0xfe5203],'mapToModel':!![],'nest':!![]});if(_0xe09b54['fields']){_0x3dc131[_0xc7a2('0x6f')][_0xc7a2('0x70')](function(_0x5b82de){_0xf8dbd1[_0xc7a2('0x9')]('i.'+_0x5b82de);});}else{_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x71'),'unreadMessages');_0xf8dbd1['field']('a.key',_0xc7a2('0x72'));_0xf8dbd1[_0xc7a2('0x9')]('a.mandatoryDisposition',_0xc7a2('0x73'));if(_0x5e5466===_0xc7a2('0x2e')){_0xf8dbd1['field'](_0xc7a2('0x74'),'Account.email');_0xf8dbd1[_0xc7a2('0x9')]('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',_0xc7a2('0x75'));_0xf8dbd1[_0xc7a2('0x9')]('i.id');_0xf8dbd1[_0xc7a2('0x9')]('i.createdAt');_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x76'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x77'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x78'));_0xf8dbd1['field']('i.attach');_0xf8dbd1['field'](_0xc7a2('0x79'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x7a'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x7b'));_0xf8dbd1['field']('i.disposition');_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x62'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x61'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x65'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x7c'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x7d'));_0xf8dbd1['field']('i.MailAccountId');_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x7e'));}else if(_0x5e5466==='openchannel'){_0xf8dbd1[_0xc7a2('0x9')]('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',_0xc7a2('0x75'));}else{_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x7f'),_0xc7a2('0x75'));}if(_0x5e5466!=='mail'){_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x80'));}_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x81'),'Contact.firstName');_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x82'),_0xc7a2('0x83'));_0xf8dbd1[_0xc7a2('0x9')]('c.email',_0xc7a2('0x84'));_0xf8dbd1['field']('c.phone','Contact.phone');_0xf8dbd1[_0xc7a2('0x9')]('c.mobile',_0xc7a2('0x85'));_0xf8dbd1['field'](_0xc7a2('0x86'),_0xc7a2('0x87'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x88'),_0xc7a2('0x89'));_0xf8dbd1[_0xc7a2('0x9')](_0xc7a2('0x8a'),_0xc7a2('0x8b'));_0xf8dbd1[_0xc7a2('0x9')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xc7a2('0x8c'));}if(_0x3dc131[_0xc7a2('0x8d')]){_0xf8dbd1[_0xc7a2('0x8d')](_0x3dc131[_0xc7a2('0x8d')]);}if(_0x3dc131[_0xc7a2('0x8e')]){_0xf8dbd1[_0xc7a2('0x8e')](_0x3dc131[_0xc7a2('0x8e')]);}return db[_0xc7a2('0x8f')][_0xc7a2('0x6c')](_0xf8dbd1[_0xc7a2('0x90')](),_0x5765f0);})[_0xc7a2('0x57')](function(_0x2f234f){_0x45044a=_0x2f234f;var _0x18461f=getUsersQuery(_0x5e5466,_0x45044a);return db[_0xc7a2('0x8f')][_0xc7a2('0x6c')](_0x18461f[_0xc7a2('0x90')](),_0x5765f0);})[_0xc7a2('0x57')](function(_0x2f65bd){_0x23d7bc=_['groupBy'](_0x2f65bd,_0x29f1e7);if(_0x5e5466==='mail'){return db[_0xc7a2('0x91')][_0xc7a2('0x92')]({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0xc7a2('0x57')](function(_0x30dca3){var _0x5cdfc8=_0x30dca3?_0x30dca3['enableEmailPreview']:undefined;var _0x31256b=_0x45044a[_0xc7a2('0x17')](function(_0xf25798){return updateInteraction(_0xf25798,_0xc7ce86,_0x23d7bc,_0x5cdfc8);});return Promise[_0xc7a2('0x93')](_0x31256b);});}function countFilteredInteractions(_0x470bf1,_0x259f04){var _0x4c48d9=_0x470bf1[_0xc7a2('0x94')]();_0x4c48d9['field'](_0xc7a2('0x95'));_0x4c48d9['field'](_0xc7a2('0x71'),_0xc7a2('0x3d'));var _0xe9e0fd=utils[_0xc7a2('0x25')](_0x259f04);if(!_[_0xc7a2('0x96')](_0xe9e0fd)){_0x4c48d9[_0xc7a2('0x15')](_0xc7a2('0x97'),_0xe9e0fd);}var _0x267e78={'type':db[_0xc7a2('0x69')]['QueryTypes']['SELECT'],'raw':!![]};return db['sequelize'][_0xc7a2('0x6c')](_0x4c48d9[_0xc7a2('0x90')](),_0x267e78);}module[_0xc7a2('0x98')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
\ No newline at end of file
+var _0x8d9b=['type','default','text','value','start','end','unreadMessages','Contact','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','find','ContactId','map','tags','clause','ids','UserId','user','body','plainBody','keys','compact','concat','createdAt','parse','$gte','and','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','read','tag','filter','capitalize','chat','Websites','Accounts','search','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','closed','i.substatus','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','SELECT','sequelize','query','toString','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','Account.email','contactName','i.createdAt','i.updatedAt','i.closed','i.attach','i.lastMsgDirection','i.subject','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','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','Contact.firstName','c.lastName','Contact.email','c.phone','Contact.phone','c.mobile','c.fax','Owner.fullname','o.internal','Owner.internal','TagIds','limit','offset','Setting','enableEmailPreview','clone','isEmpty','t.id\x20IN\x20?','QueryTypes','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','../../mysqldb','role','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','select','u.id','u.fullname','ui.','left_join','u.id\x20=\x20ui.UserId','length','where','\x20IN\x20?','getInteractionsTables','getAccountFK','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','accounts','a.id\x20=\x20i.','messages','me.','interactionsTags','it.','\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','unreadMessages\x20{OPERATOR}\x200','{OPERATOR}','replace','isNumeric','i.id\x20LIKE\x20?','sms','includes','i.phone\x20LIKE\x20?','fax','openchannel','i.from\x20LIKE\x20?','mail','isEmail','c.email\x20LIKE\x20?','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','parseSearch','sqlOperator','conditions','buildExpression'];(function(_0x550b27,_0x17145b){var _0x2fca00=function(_0x47f1e4){while(--_0x47f1e4){_0x550b27['push'](_0x550b27['shift']());}};_0x2fca00(++_0x17145b);}(_0x8d9b,0x104));var _0xb8d9=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x8d9b[_0x3dd15e];return _0x231fd0;};'use strict';var _=require(_0xb8d9('0x0'));var squel=require(_0xb8d9('0x1'));var as=require(_0xb8d9('0x2'));var qs=require(_0xb8d9('0x3'));var updateInteraction=require(_0xb8d9('0x4'))['updateInteraction'];var utils=require('./utils');var db=require(_0xb8d9('0x5'))['db'];function skipInteractionsQuery(_0x47b650,_0x2192ff,_0x3da7ad){var _0x56deeb=![];var _0x5996e9=utils['getAccountFK'](_0x47b650);if(_0x2192ff[_0xb8d9('0x6')]==='agent'&&!_0x3da7ad['search']&&!_0x3da7ad[_0x5996e9]){_0x56deeb=!![];}return _0x56deeb;}function getTagsQuery(){return squel['select']()[_0xb8d9('0x7')]('id')[_0xb8d9('0x7')](_0xb8d9('0x8'))[_0xb8d9('0x7')](_0xb8d9('0x9'))[_0xb8d9('0xa')](_0xb8d9('0xb'));}function getUsersQuery(_0x48f36d,_0x857f2a){var _0x59f638=utils[_0xb8d9('0xc')](_0x48f36d);var _0x2a60a4=_0xb8d9('0xd')+_0x48f36d+_0xb8d9('0xe');var _0x7f604f=squel[_0xb8d9('0xf')]()[_0xb8d9('0x7')](_0xb8d9('0x10'))[_0xb8d9('0x7')](_0xb8d9('0x11'))[_0xb8d9('0x7')](_0xb8d9('0x12')+_0x59f638)[_0xb8d9('0xa')](_0x2a60a4,'ui')[_0xb8d9('0x13')]('users','u',_0xb8d9('0x14'));if(_0x857f2a[_0xb8d9('0x15')]>0x0){_0x7f604f[_0xb8d9('0x16')](_0xb8d9('0x12')+_0x59f638+_0xb8d9('0x17'),_['map'](_0x857f2a,'id'));}return _0x7f604f;}function getInteractionsQuery(_0x542141){var _0x5b7d5a=utils[_0xb8d9('0x18')](_0x542141);var _0x2d1b34=utils[_0xb8d9('0x19')](_0x542141);var _0x1183e4=utils['getInteractionFK'](_0x542141);return squel[_0xb8d9('0xf')]()['from'](_0x5b7d5a[_0xb8d9('0x1a')],'i')[_0xb8d9('0x13')](_0xb8d9('0x1b'),'c',_0xb8d9('0x1c'))[_0xb8d9('0x13')]('users','o','o.id\x20=\x20i.UserId')['left_join'](_0x5b7d5a[_0xb8d9('0x1d')],'a',_0xb8d9('0x1e')+_0x2d1b34)[_0xb8d9('0x13')](_0x5b7d5a[_0xb8d9('0x1f')],'me',_0xb8d9('0x20')+_0x1183e4+'\x20=\x20i.id')[_0xb8d9('0x13')](_0x5b7d5a[_0xb8d9('0x21')],'it',_0xb8d9('0x22')+_0x1183e4+_0xb8d9('0x23'))[_0xb8d9('0x13')](_0xb8d9('0xb'),'t',_0xb8d9('0x24'));}function getSqlClauses(){var _0x3d1659={'body':squel[_0xb8d9('0x25')](),'contact':squel[_0xb8d9('0x25')](),'default':squel['expr'](),'fields':squel[_0xb8d9('0x25')](),'filter':squel['expr'](),'read':squel['expr'](),'tags':{'clause':squel[_0xb8d9('0x25')](),'ids':null},'user':squel[_0xb8d9('0x25')]()};return _0x3d1659;}function parseTagParameter(_0x43c9f1){var _0x33c75e=squel[_0xb8d9('0x25')]();if(_0x43c9f1){var _0x4885f2=utils[_0xb8d9('0x26')](_0x43c9f1);_0x4885f2[_0xb8d9('0x27')](function(_0x3111aa){_0x33c75e['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x3111aa+',%');});}return _0x33c75e;}function parseReadParameter(_0x2d1439){var _0x1c9bd4='';if(_0x2d1439){_0x1c9bd4=_0xb8d9('0x28');if(_0x2d1439==='1'){_0x1c9bd4=_0x1c9bd4['replace'](_0xb8d9('0x29'),'=');}else{_0x1c9bd4=_0x1c9bd4[_0xb8d9('0x2a')]('{OPERATOR}','>');}}return _0x1c9bd4;}function parseSearchFilter(_0x344e27,_0x6cd7f6){var _0x2694f0=squel[_0xb8d9('0x25')]();if(_0x6cd7f6){var _0x358e4d=_0x6cd7f6[_0xb8d9('0x2a')]('\x5c','\x5c\x5c')[_0xb8d9('0x2a')](/'/g,'\x27\x27');if(qs[_0xb8d9('0x2b')](_0x358e4d)){_0x2694f0['or'](_0xb8d9('0x2c'),_0x358e4d+'%');if([_0xb8d9('0x2d'),'whatsapp'][_0xb8d9('0x2e')](_0x344e27)){_0x2694f0['or'](_0xb8d9('0x2f'),_0x358e4d+'%');}else if(_0x344e27===_0xb8d9('0x30')){_0x2694f0['or']('i.fax\x20LIKE\x20?',_0x358e4d+'%');}else if(_0x344e27===_0xb8d9('0x31')){_0x2694f0['or'](_0xb8d9('0x32'),_0x358e4d+'%');}}else if(_0x344e27===_0xb8d9('0x33')&&qs[_0xb8d9('0x34')](_0x358e4d)){_0x2694f0['or'](_0xb8d9('0x35'),_0x358e4d+'%');}else{if(_0x344e27===_0xb8d9('0x33')){_0x2694f0['or']('MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x358e4d))['or'](_0xb8d9('0x36'),qs[_0xb8d9('0x37')](_0x358e4d));}else{if(_0x344e27!==_0xb8d9('0x30')){_0x2694f0['or'](_0xb8d9('0x38'),qs[_0xb8d9('0x37')](_0x358e4d));}_0x2694f0['or'](_0xb8d9('0x39'),_0x358e4d+'%');}}}return _0x2694f0;}function parseAdvancedSearchFilter(_0x4f11e4,_0x4992a6){var _0x4425f3=getSqlClauses();var _0x3c1503=as[_0xb8d9('0x3a')](_0x4f11e4);var _0x499334=_0x3c1503[_0xb8d9('0x3b')];for(var _0x4fca56=0x0;_0x4fca56<_0x3c1503[_0xb8d9('0x3c')][_0xb8d9('0x15')];_0x4fca56++){var _0x1268ea=_0x3c1503['conditions'][_0x4fca56];var _0x3330e7='i';var _0x1ad60d=_['find'](_0x4992a6,['name',_0x1268ea[_0xb8d9('0x7')]]);if(_0x1ad60d){var _0x1af691=as[_0xb8d9('0x3d')](_0x3330e7,_0x1ad60d[_0xb8d9('0x3e')],_0x1268ea);_0x4425f3[_0xb8d9('0x3f')][_0x499334](_0x1af691[_0xb8d9('0x40')],_0x1af691[_0xb8d9('0x41')][_0xb8d9('0x42')],_0x1af691[_0xb8d9('0x41')][_0xb8d9('0x43')]);}else{switch(_0x1268ea[_0xb8d9('0x7')]){case _0xb8d9('0x44'):var _0x9f11f2=parseReadParameter(_0x1268ea[_0xb8d9('0x41')]);_0x4425f3['read']['and'](_0x9f11f2);break;case _0xb8d9('0x45'):if(_0x1268ea[_0xb8d9('0x46')]===_0xb8d9('0x47')){if(_0x1268ea[_0xb8d9('0x41')]['split']('\x20')['length']>0x1){_0x4425f3[_0xb8d9('0x48')][_0x499334]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xb8d9('0x37')](_0x1268ea['value']),null);}else{var _0x2356c5='%'+_0x1268ea['value']+'%';_0x4425f3[_0xb8d9('0x48')][_0x499334](_0xb8d9('0x49'),_0x2356c5,_0x2356c5,_0x2356c5);}}else{_0x1ad60d=_[_0xb8d9('0x4a')](_0x4992a6,['name',_0xb8d9('0x4b')]);_0x1268ea[_0xb8d9('0x7')]=_0xb8d9('0x4b');_0x1af691=as['buildExpression'](_0x3330e7,_0x1ad60d['type'],_0x1268ea);_0x4425f3['contact'][_0x499334](_0x1af691['text'],_0x1af691['value'][_0xb8d9('0x42')],_0x1af691[_0xb8d9('0x41')][_0xb8d9('0x43')]);}break;case'Tag':var _0x53eb73=_0x1268ea[_0xb8d9('0x41')]['split'](',')[_0xb8d9('0x4c')](function(_0x25ae38){return Number(_0x25ae38);});var _0x1a8498=parseTagParameter(_0x53eb73);_0x4425f3[_0xb8d9('0x4d')][_0xb8d9('0x4e')]['and'](_0x1a8498);_0x4425f3[_0xb8d9('0x4d')][_0xb8d9('0x4f')]=_0x53eb73;break;case'User':if(_0x1268ea[_0xb8d9('0x46')]===_0xb8d9('0x47')){_0x4425f3['user'][_0x499334]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x1268ea[_0xb8d9('0x41')]+'%',null);}else{_0x1ad60d=_[_0xb8d9('0x4a')](_0x4992a6,[_0xb8d9('0x8'),_0xb8d9('0x50')]);_0x1268ea[_0xb8d9('0x7')]='UserId';_0x1af691=as[_0xb8d9('0x3d')](_0x3330e7,_0x1ad60d[_0xb8d9('0x3e')],_0x1268ea);_0x4425f3[_0xb8d9('0x51')][_0x499334](_0x1af691[_0xb8d9('0x40')],_0x1af691[_0xb8d9('0x41')][_0xb8d9('0x42')],_0x1af691['value'][_0xb8d9('0x43')]);}break;case _0xb8d9('0x52'):case _0xb8d9('0x53'):_0x1af691=as[_0xb8d9('0x3d')]('me',null,_0x1268ea);_0x4425f3[_0xb8d9('0x52')][_0x499334](_0x1af691[_0xb8d9('0x40')],_0x1af691['value'][_0xb8d9('0x42')],_0x1af691[_0xb8d9('0x41')]['end']);break;}}}return _0x4425f3;}function parseModelFields(_0x212310,_0x41f38b,_0x4ae9e1){var _0x587bb8=utils[_0xb8d9('0x19')](_0x212310);var _0x423927=squel[_0xb8d9('0x25')]();var _0xca2c82=_(_0x41f38b)[_0xb8d9('0x54')]()[_0xb8d9('0x4c')](function(_0x328d1d){return _['some'](_0x4ae9e1,[_0xb8d9('0x8'),_0x328d1d])?_0x328d1d:undefined;})[_0xb8d9('0x55')]()[_0xb8d9('0x41')]();if(_0xca2c82['length']>0x0){_0xca2c82[_0xb8d9('0x27')](function(_0x1dee5c){if(_0x1dee5c===_0x587bb8){_0x423927['and']('i.'+_0x587bb8+'\x20IN\x20?',[][_0xb8d9('0x56')](_0x41f38b[_0x1dee5c]));}else if(_0x1dee5c===_0xb8d9('0x57')){var _0x4e9a10=JSON[_0xb8d9('0x58')](_0x41f38b[_0x1dee5c])[_0xb8d9('0x59')];var _0x124722=JSON[_0xb8d9('0x58')](_0x41f38b[_0x1dee5c])['$lte'];_0x423927[_0xb8d9('0x5a')](_0xb8d9('0x5b'),_0x4e9a10,_0x124722);}else{if(_0x41f38b[_0x1dee5c]===_0xb8d9('0x5c')){_0x423927[_0xb8d9('0x5a')]('i.'+_0x1dee5c+_0xb8d9('0x5d'));}else{_0x423927[_0xb8d9('0x5a')]('i.'+_0x1dee5c+_0xb8d9('0x5e'),_0x41f38b[_0x1dee5c]);}}});}return _0x423927;}function parseQueryParameters(_0x518bb4,_0x3101da,_0x5c3100){var _0x305d1b=getSqlClauses();return Promise[_0xb8d9('0x5f')]()[_0xb8d9('0x60')](function(){return parseModelFields(_0x518bb4,_0x3101da,_0x5c3100);})['then'](function(_0x181878){_0x305d1b[_0xb8d9('0x61')][_0xb8d9('0x5a')](_0x181878);return parseReadParameter(_0x3101da[_0xb8d9('0x62')]);})[_0xb8d9('0x60')](function(_0x34a11e){_0x305d1b[_0xb8d9('0x62')][_0xb8d9('0x5a')](_0x34a11e);return parseTagParameter(_0x3101da[_0xb8d9('0x63')]);})[_0xb8d9('0x60')](function(_0x24ff63){_0x305d1b['tags'][_0xb8d9('0x4e')][_0xb8d9('0x5a')](_0x24ff63);return parseSearchFilter(_0x518bb4,_0x3101da[_0xb8d9('0x64')]);})[_0xb8d9('0x60')](function(_0x5c1a14){_0x305d1b[_0xb8d9('0x64')]=_0x5c1a14;return _0x305d1b;});}function checkAccountsRestrictions(_0x20e625,_0x1cdc5b,_0x351ac8){var _0x3bb503=utils['getAccountFK'](_0x20e625);var _0x11ccbc='get'+_[_0xb8d9('0x65')](_0x20e625)+(_0x20e625===_0xb8d9('0x66')?_0xb8d9('0x67'):_0xb8d9('0x68'));var _0x24ccf4=squel[_0xb8d9('0x25')]();return Promise[_0xb8d9('0x5f')]()['then'](function(){if(_0x351ac8[_0xb8d9('0x69')]&&_0x1cdc5b[_0xb8d9('0x6')]==='agent'){return _0x1cdc5b[_0x11ccbc]({'attributes':['id'],'raw':!![]});}})[_0xb8d9('0x60')](function(_0x49c6af){if(_0x49c6af){if(_0x49c6af[_0xb8d9('0x15')]===0x0){_0x24ccf4[_0xb8d9('0x5a')]('i.'+_0x3bb503+'\x20IS\x20NULL');}else{_0x24ccf4[_0xb8d9('0x5a')]('i.'+_0x3bb503+_0xb8d9('0x17'),_['map'](_0x49c6af,'id'));}}else if(!_0x351ac8[_0x3bb503]){_0x24ccf4[_0xb8d9('0x5a')]('i.'+_0x3bb503+_0xb8d9('0x6a'));}})['then'](function(){return _0x24ccf4;});}function getClosedOrderClause(_0x8f7212,_0x54b53c){var _0xffeec3='';var _0x31a5e8=[_0xb8d9('0x6b'),_0xb8d9('0x6c'),_0xb8d9('0x6d')];if(_0x8f7212==='mail'){_0x31a5e8['unshift']('i.substatus');}if(_0x54b53c[_0xb8d9('0x6e')]==='0'&&_0x8f7212===_0xb8d9('0x33')){_0xffeec3=_0xb8d9('0x6f');}else{if(_0x54b53c[_0xb8d9('0x6e')]==='1'){_0x31a5e8[_0xb8d9('0x70')]();}_0xffeec3=_0xb8d9('0x71')+_0x31a5e8[_0xb8d9('0x72')](',\x20')+')';}return _0xffeec3;}function getFilteredInteractions(_0x24be60,_0x3cc52a,_0x5f37ae,_0x360b05){var _0x32e58f=utils[_0xb8d9('0xc')](_0x24be60);var _0x15d5ed=_['capitalize'](_0x24be60)+_0xb8d9('0x73');var _0x7a813f=[];var _0x91236=getTagsQuery();var _0x4379ae={'type':db[_0xb8d9('0x74')]['QueryTypes'][_0xb8d9('0x75')],'raw':!![]};var _0x2fb1a9=[];var _0x55e2eb=[];return db[_0xb8d9('0x76')][_0xb8d9('0x77')](_0x91236[_0xb8d9('0x78')](),_0x4379ae)['then'](function(_0x275708){_0x7a813f=_['keyBy'](_0x275708,'id');_0x4379ae=_[_0xb8d9('0x79')](_0x4379ae,{'model':db[_0x15d5ed],'mapToModel':!![],'nest':!![]});if(_0x5f37ae[_0xb8d9('0x61')]){_0x360b05[_0xb8d9('0x7a')][_0xb8d9('0x27')](function(_0x55b547){_0x3cc52a[_0xb8d9('0x7')]('i.'+_0x55b547);});}else{_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x7b'),'unreadMessages');_0x3cc52a['field'](_0xb8d9('0x7c'),'Account.key');_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x7d'),_0xb8d9('0x7e'));if(_0x24be60===_0xb8d9('0x33')){_0x3cc52a['field'](_0xb8d9('0x7f'),_0xb8d9('0x80'));_0x3cc52a['field']('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',_0xb8d9('0x81'));_0x3cc52a['field']('i.id');_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x82'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x83'));_0x3cc52a['field'](_0xb8d9('0x84'));_0x3cc52a[_0xb8d9('0x7')]('i.closedAt');_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x85'));_0x3cc52a[_0xb8d9('0x7')]('i.lastMsgAt');_0x3cc52a['field'](_0xb8d9('0x86'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x87'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x6d'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x6c'));_0x3cc52a['field'](_0xb8d9('0x6b'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x6f'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x88'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x89'));_0x3cc52a['field'](_0xb8d9('0x8a'));_0x3cc52a['field'](_0xb8d9('0x8b'));}else if(_0x24be60===_0xb8d9('0x31')){_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x8c'),_0xb8d9('0x81'));}else{_0x3cc52a['field'](_0xb8d9('0x8d'),'contactName');}if(_0x24be60!==_0xb8d9('0x33')){_0x3cc52a['field']('i.*');}_0x3cc52a[_0xb8d9('0x7')]('c.firstName',_0xb8d9('0x8e'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x8f'),'Contact.lastName');_0x3cc52a[_0xb8d9('0x7')]('c.email',_0xb8d9('0x90'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x91'),_0xb8d9('0x92'));_0x3cc52a['field'](_0xb8d9('0x93'),'Contact.mobile');_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x94'),'Contact.fax');_0x3cc52a[_0xb8d9('0x7')]('o.fullname',_0xb8d9('0x95'));_0x3cc52a[_0xb8d9('0x7')](_0xb8d9('0x96'),_0xb8d9('0x97'));_0x3cc52a[_0xb8d9('0x7')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xb8d9('0x98'));}if(_0x360b05[_0xb8d9('0x99')]){_0x3cc52a[_0xb8d9('0x99')](_0x360b05['limit']);}if(_0x360b05[_0xb8d9('0x9a')]){_0x3cc52a['offset'](_0x360b05[_0xb8d9('0x9a')]);}return db[_0xb8d9('0x76')][_0xb8d9('0x77')](_0x3cc52a[_0xb8d9('0x78')](),_0x4379ae);})[_0xb8d9('0x60')](function(_0x2e8fc1){_0x2fb1a9=_0x2e8fc1;var _0x14b570=getUsersQuery(_0x24be60,_0x2fb1a9);return db[_0xb8d9('0x76')][_0xb8d9('0x77')](_0x14b570[_0xb8d9('0x78')](),_0x4379ae);})[_0xb8d9('0x60')](function(_0x410bf8){_0x55e2eb=_['groupBy'](_0x410bf8,_0x32e58f);if(_0x24be60==='mail'){return db[_0xb8d9('0x9b')]['findOne']({'attributes':[_0xb8d9('0x9c')],'raw':!![]});}})['then'](function(_0x1db29b){var _0x1a8d14=_0x1db29b?_0x1db29b[_0xb8d9('0x9c')]:undefined;var _0x3179af=_0x2fb1a9[_0xb8d9('0x4c')](function(_0x3190f0){return updateInteraction(_0x3190f0,_0x7a813f,_0x55e2eb,_0x1a8d14);});return Promise['all'](_0x3179af);});}function countFilteredInteractions(_0x29173c,_0x3c7b28){var _0x344f10=_0x29173c[_0xb8d9('0x9d')]();_0x344f10[_0xb8d9('0x7')]('COUNT(*)');_0x344f10[_0xb8d9('0x7')](_0xb8d9('0x7b'),_0xb8d9('0x44'));var _0x3356da=utils['getSelectedTags'](_0x3c7b28);if(!_[_0xb8d9('0x9e')](_0x3356da)){_0x344f10[_0xb8d9('0x16')](_0xb8d9('0x9f'),_0x3356da);}var _0x50cb30={'type':db['Sequelize'][_0xb8d9('0xa0')][_0xb8d9('0x75')],'raw':!![]};return db[_0xb8d9('0x76')]['query'](_0x344f10[_0xb8d9('0x78')](),_0x50cb30);}module['exports']={'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