Built motion from commit cb845558.|2.6.34
[motion2.git] / server / components / interaction / sql-utils.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0xcccd=['query','toString','groupBy','Setting','findOne','enableEmailPreview','all','clone','t.id\x20IN\x20?','lodash','squel','../parsers/advancedSearch','updateInteraction','./utils','getAccountFK','search','select','field','name','color','from','tools_tags','getInteractionFK','user_has_','_interactions','ui.','left_join','u.id\x20=\x20ui.UserId','where','\x20IN\x20?','map','interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','accounts','messages','me.','\x20=\x20i.id','interactionsTags','it.','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','whatsapp','i.phone\x20LIKE\x20?','fax','openchannel','i.from\x20LIKE\x20?','mail','isEmail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','sqlOperator','conditions','length','buildExpression','type','text','start','value','unreadMessages','read','and','Contact','operator','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','end','Tag','tags','ids','$substring','user','find','UserId','body','plainBody','some','compact','concat','createdAt','parse','$gte','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','clause','filter','get','capitalize','Websites','role','agent','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','keyBy','merge','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','a.email','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.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','i.subject','i.to','i.MailAccountId','i.UserId','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset'];(function(_0x29ecae,_0x4673fa){var _0x2b18cb=function(_0x4e7425){while(--_0x4e7425){_0x29ecae['push'](_0x29ecae['shift']());}};_0x2b18cb(++_0x4673fa);}(_0xcccd,0x147));var _0xdccc=function(_0x6afc9c,_0xf6b755){_0x6afc9c=_0x6afc9c-0x0;var _0x195d68=_0xcccd[_0x6afc9c];return _0x195d68;};'use strict';var _=require(_0xdccc('0x0'));var squel=require(_0xdccc('0x1'));var as=require(_0xdccc('0x2'));var qs=require('../parsers/qs');var updateInteraction=require('./update-interaction')[_0xdccc('0x3')];var utils=require(_0xdccc('0x4'));var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0x24f8b2,_0x205c55,_0x21adc3){var _0xf81ffe=![];var _0x3fd6d6=utils[_0xdccc('0x5')](_0x24f8b2);if(_0x205c55['role']==='agent'&&!_0x21adc3[_0xdccc('0x6')]&&!_0x21adc3[_0x3fd6d6]){_0xf81ffe=!![];}return _0xf81ffe;}function getTagsQuery(){return squel[_0xdccc('0x7')]()[_0xdccc('0x8')]('id')[_0xdccc('0x8')](_0xdccc('0x9'))[_0xdccc('0x8')](_0xdccc('0xa'))[_0xdccc('0xb')](_0xdccc('0xc'));}function getUsersQuery(_0x2fc2e9,_0x55c990){var _0x1b16c0=utils[_0xdccc('0xd')](_0x2fc2e9);var _0x388ee2=_0xdccc('0xe')+_0x2fc2e9+_0xdccc('0xf');var _0x2f6f44=squel[_0xdccc('0x7')]()['field']('u.id')[_0xdccc('0x8')]('u.fullname')['field'](_0xdccc('0x10')+_0x1b16c0)[_0xdccc('0xb')](_0x388ee2,'ui')[_0xdccc('0x11')]('users','u',_0xdccc('0x12'));if(_0x55c990['length']>0x0){_0x2f6f44[_0xdccc('0x13')](_0xdccc('0x10')+_0x1b16c0+_0xdccc('0x14'),_[_0xdccc('0x15')](_0x55c990,'id'));}return _0x2f6f44;}function getInteractionsQuery(_0x16fda9){var _0x5e77cb=utils['getInteractionsTables'](_0x16fda9);var _0x5d9d5b=utils[_0xdccc('0x5')](_0x16fda9);var _0x187daa=utils[_0xdccc('0xd')](_0x16fda9);return squel[_0xdccc('0x7')]()[_0xdccc('0xb')](_0x5e77cb[_0xdccc('0x16')],'i')[_0xdccc('0x11')](_0xdccc('0x17'),'c',_0xdccc('0x18'))[_0xdccc('0x11')](_0xdccc('0x19'),'o',_0xdccc('0x1a'))[_0xdccc('0x11')](_0x5e77cb[_0xdccc('0x1b')],'a','a.id\x20=\x20i.'+_0x5d9d5b)[_0xdccc('0x11')](_0x5e77cb[_0xdccc('0x1c')],'me',_0xdccc('0x1d')+_0x187daa+_0xdccc('0x1e'))[_0xdccc('0x11')](_0x5e77cb[_0xdccc('0x1f')],'it',_0xdccc('0x20')+_0x187daa+_0xdccc('0x1e'))[_0xdccc('0x11')](_0xdccc('0xc'),'t','t.id\x20=\x20it.TagId');}function getSqlClauses(){var _0x3d8629={'body':squel[_0xdccc('0x21')](),'contact':squel[_0xdccc('0x21')](),'default':squel['expr'](),'fields':squel[_0xdccc('0x21')](),'filter':squel['expr'](),'read':squel[_0xdccc('0x21')](),'tags':{'clause':squel[_0xdccc('0x21')](),'ids':null},'user':squel[_0xdccc('0x21')]()};return _0x3d8629;}function parseTagParameter(_0x4fbc44){var _0x4c192a=squel['expr']();if(_0x4fbc44){var _0x4ef99e=utils[_0xdccc('0x22')](_0x4fbc44);_0x4ef99e[_0xdccc('0x23')](function(_0x49cd5e){_0x4c192a['or'](_0xdccc('0x24'),'%,'+_0x49cd5e+',%');});}return _0x4c192a;}function parseReadParameter(_0x12c0fd){var _0x5b5f8b='';if(_0x12c0fd){_0x5b5f8b='unreadMessages\x20{OPERATOR}\x200';if(_0x12c0fd==='1'){_0x5b5f8b=_0x5b5f8b[_0xdccc('0x25')]('{OPERATOR}','=');}else{_0x5b5f8b=_0x5b5f8b[_0xdccc('0x25')](_0xdccc('0x26'),'>');}}return _0x5b5f8b;}function parseSearchFilter(_0x37c2ab,_0x509f96){var _0x33f699=squel[_0xdccc('0x21')]();if(_0x509f96){var _0x3ed1f7=_0x509f96[_0xdccc('0x25')]('\x5c','\x5c\x5c')[_0xdccc('0x25')](/'/g,'\x27\x27');var _0x36f9ef=qs['escapeLIKESpecialChars'](_0x3ed1f7);if(qs[_0xdccc('0x27')](_0x3ed1f7)){_0x33f699['or'](_0xdccc('0x28'),_0x36f9ef+'%');if(['sms',_0xdccc('0x29')]['includes'](_0x37c2ab)){_0x33f699['or'](_0xdccc('0x2a'),_0x36f9ef+'%');}else if(_0x37c2ab===_0xdccc('0x2b')){_0x33f699['or']('i.fax\x20LIKE\x20?',_0x36f9ef+'%');}else if(_0x37c2ab===_0xdccc('0x2c')){_0x33f699['or'](_0xdccc('0x2d'),_0x36f9ef+'%');}}else if(_0x37c2ab===_0xdccc('0x2e')&&qs[_0xdccc('0x2f')](_0x3ed1f7)){_0x33f699['or']('c.email\x20LIKE\x20?',_0x36f9ef+'%');}else{if(_0x37c2ab===_0xdccc('0x2e')){_0x33f699['or'](_0xdccc('0x30'),qs[_0xdccc('0x31')](_0x3ed1f7,!![]))['or'](_0xdccc('0x32'),qs[_0xdccc('0x31')](_0x3ed1f7));}else if(_0x37c2ab!=='fax'){_0x33f699['or'](_0xdccc('0x33'),qs['getFullTextValue'](_0x3ed1f7));}_0x33f699['or'](_0xdccc('0x34'),qs['getFullTextValue'](_0x3ed1f7,!![]),null);}}return _0x33f699;}function parseAdvancedSearchFilter(_0x33e9f0,_0x3ace54){var _0x1a5eb5=getSqlClauses();var _0x42245f=as['parseSearch'](_0x33e9f0);var _0x120998=_0x42245f[_0xdccc('0x35')];for(var _0x58468e=0x0;_0x58468e<_0x42245f[_0xdccc('0x36')][_0xdccc('0x37')];_0x58468e++){var _0x1162c3=_0x42245f['conditions'][_0x58468e];var _0x119dd8='i';var _0x8a74b6=_['find'](_0x3ace54,[_0xdccc('0x9'),_0x1162c3[_0xdccc('0x8')]]);if(_0x8a74b6){var _0x58ca45=as[_0xdccc('0x38')](_0x119dd8,_0x8a74b6[_0xdccc('0x39')],_0x1162c3);_0x1a5eb5['default'][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45['value'][_0xdccc('0x3b')],_0x58ca45[_0xdccc('0x3c')]['end']);}else{switch(_0x1162c3[_0xdccc('0x8')]){case _0xdccc('0x3d'):var _0x58b082=parseReadParameter(_0x1162c3[_0xdccc('0x3c')]);_0x1a5eb5[_0xdccc('0x3e')][_0xdccc('0x3f')](_0x58b082);break;case _0xdccc('0x40'):if(_0x1162c3[_0xdccc('0x41')]==='$substring'){if(_0x1162c3[_0xdccc('0x3c')][_0xdccc('0x42')]('\x20')['length']>0x1){_0x1a5eb5[_0xdccc('0x43')][_0x120998](_0xdccc('0x34'),qs[_0xdccc('0x31')](_0x1162c3[_0xdccc('0x3c')],!![]),null);}else{var _0x1def0d='%'+_0x1162c3[_0xdccc('0x3c')]+'%';_0x1a5eb5[_0xdccc('0x43')][_0x120998](_0xdccc('0x44'),_0x1def0d,_0x1def0d,_0x1def0d);}}else{_0x8a74b6=_['find'](_0x3ace54,['name',_0xdccc('0x45')]);_0x1162c3[_0xdccc('0x8')]=_0xdccc('0x45');_0x58ca45=as['buildExpression'](_0x119dd8,_0x8a74b6[_0xdccc('0x39')],_0x1162c3);_0x1a5eb5['contact'][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45['value']['start'],_0x58ca45['value'][_0xdccc('0x46')]);}break;case _0xdccc('0x47'):var _0x4f941e=_0x1162c3[_0xdccc('0x3c')][_0xdccc('0x42')](',')[_0xdccc('0x15')](function(_0x14855b){return Number(_0x14855b);});var _0x5417bf=parseTagParameter(_0x4f941e);_0x1a5eb5[_0xdccc('0x48')]['clause'][_0xdccc('0x3f')](_0x5417bf);_0x1a5eb5[_0xdccc('0x48')][_0xdccc('0x49')]=_0x4f941e;break;case'User':if(_0x1162c3[_0xdccc('0x41')]===_0xdccc('0x4a')){_0x1a5eb5[_0xdccc('0x4b')][_0x120998]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','%'+_0x1162c3[_0xdccc('0x3c')]+'%',null);}else{_0x8a74b6=_[_0xdccc('0x4c')](_0x3ace54,['name','UserId']);_0x1162c3[_0xdccc('0x8')]=_0xdccc('0x4d');_0x58ca45=as[_0xdccc('0x38')](_0x119dd8,_0x8a74b6['type'],_0x1162c3);_0x1a5eb5[_0xdccc('0x4b')][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45['value'][_0xdccc('0x3b')],_0x58ca45[_0xdccc('0x3c')]['end']);}break;case _0xdccc('0x4e'):case _0xdccc('0x4f'):_0x58ca45=as['buildExpression']('me',null,_0x1162c3);_0x1a5eb5[_0xdccc('0x4e')][_0x120998](_0x58ca45[_0xdccc('0x3a')],_0x58ca45[_0xdccc('0x3c')][_0xdccc('0x3b')],_0x58ca45[_0xdccc('0x3c')][_0xdccc('0x46')]);break;}}}return _0x1a5eb5;}function parseModelFields(_0x3eeae2,_0x1a45c8,_0x470b03){var _0x2873a5=utils[_0xdccc('0x5')](_0x3eeae2);var _0x55062a=squel[_0xdccc('0x21')]();var _0x4a3fbd=_(_0x1a45c8)['keys']()[_0xdccc('0x15')](function(_0x5743dd){return _[_0xdccc('0x50')](_0x470b03,[_0xdccc('0x9'),_0x5743dd])?_0x5743dd:undefined;})[_0xdccc('0x51')]()[_0xdccc('0x3c')]();if(_0x4a3fbd['length']>0x0){_0x4a3fbd[_0xdccc('0x23')](function(_0x41a32e){if(_0x41a32e===_0x2873a5){_0x55062a['and']('i.'+_0x2873a5+'\x20IN\x20?',[][_0xdccc('0x52')](_0x1a45c8[_0x41a32e]));}else if(_0x41a32e===_0xdccc('0x53')){var _0x221973=JSON[_0xdccc('0x54')](_0x1a45c8[_0x41a32e])[_0xdccc('0x55')];var _0x4673ba=JSON[_0xdccc('0x54')](_0x1a45c8[_0x41a32e])['$lte'];_0x55062a[_0xdccc('0x3f')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x221973,_0x4673ba);}else{if(_0x1a45c8[_0x41a32e]===_0xdccc('0x56')){_0x55062a[_0xdccc('0x3f')]('i.'+_0x41a32e+_0xdccc('0x57'));}else{_0x55062a[_0xdccc('0x3f')]('i.'+_0x41a32e+_0xdccc('0x58'),_0x1a45c8[_0x41a32e]);}}});}return _0x55062a;}function parseQueryParameters(_0x35bcff,_0x423264,_0x1a5727){var _0x569e57=getSqlClauses();return Promise[_0xdccc('0x59')]()[_0xdccc('0x5a')](function(){return parseModelFields(_0x35bcff,_0x423264,_0x1a5727);})[_0xdccc('0x5a')](function(_0x4b2bd6){_0x569e57[_0xdccc('0x5b')][_0xdccc('0x3f')](_0x4b2bd6);return parseReadParameter(_0x423264[_0xdccc('0x3e')]);})[_0xdccc('0x5a')](function(_0x3b0d81){_0x569e57['read'][_0xdccc('0x3f')](_0x3b0d81);return parseTagParameter(_0x423264[_0xdccc('0x5c')]);})[_0xdccc('0x5a')](function(_0x469441){_0x569e57[_0xdccc('0x48')][_0xdccc('0x5d')][_0xdccc('0x3f')](_0x469441);return parseSearchFilter(_0x35bcff,_0x423264[_0xdccc('0x5e')]);})[_0xdccc('0x5a')](function(_0x4673ed){_0x569e57['filter']=_0x4673ed;return _0x569e57;});}function checkAccountsRestrictions(_0x4d54f0,_0x50c91d,_0x30e5ed){var _0x2cc71e=utils[_0xdccc('0x5')](_0x4d54f0);var _0xe5fabe=_0xdccc('0x5f')+_[_0xdccc('0x60')](_0x4d54f0)+(_0x4d54f0==='chat'?_0xdccc('0x61'):'Accounts');var _0x1bcd47=squel['expr']();return Promise[_0xdccc('0x59')]()['then'](function(){if(_0x30e5ed[_0xdccc('0x6')]&&_0x50c91d[_0xdccc('0x62')]===_0xdccc('0x63')){return _0x50c91d[_0xe5fabe]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x3047a7){if(_0x3047a7){if(_0x3047a7[_0xdccc('0x37')]===0x0){_0x1bcd47[_0xdccc('0x3f')]('i.'+_0x2cc71e+'\x20IS\x20NULL');}else{_0x1bcd47['and']('i.'+_0x2cc71e+_0xdccc('0x14'),_[_0xdccc('0x15')](_0x3047a7,'id'));}}else if(!_0x30e5ed[_0x2cc71e]){_0x1bcd47[_0xdccc('0x3f')]('i.'+_0x2cc71e+_0xdccc('0x64'));}})[_0xdccc('0x5a')](function(){return _0x1bcd47;});}function getClosedOrderClause(_0x11089f,_0x4f5c20){var _0x2103c='';var _0x18ff34=[_0xdccc('0x65'),_0xdccc('0x66'),_0xdccc('0x67')];if(_0x11089f==='mail'){_0x18ff34[_0xdccc('0x68')]('i.substatus');}if(_0x4f5c20['closed']==='0'&&_0x11089f===_0xdccc('0x2e')){_0x2103c=_0xdccc('0x69');}else{if(_0x4f5c20['closed']==='1'){_0x18ff34[_0xdccc('0x6a')]();}_0x2103c=_0xdccc('0x6b')+_0x18ff34[_0xdccc('0x6c')](',\x20')+')';}return _0x2103c;}function getFilteredInteractions(_0x3c7e88,_0x4ec1d1,_0x15d177,_0x2822a4){var _0x372e19=utils['getInteractionFK'](_0x3c7e88);var _0x2b44b5=_[_0xdccc('0x60')](_0x3c7e88)+_0xdccc('0x6d');var _0x4829ba=[];var _0x169f55=getTagsQuery();var _0x1cfe26={'type':db[_0xdccc('0x6e')][_0xdccc('0x6f')][_0xdccc('0x70')],'raw':!![]};var _0xa0d620=[];var _0x2c62fc=[];return db[_0xdccc('0x71')]['query'](_0x169f55['toString'](),_0x1cfe26)[_0xdccc('0x5a')](function(_0x306542){_0x4829ba=_[_0xdccc('0x72')](_0x306542,'id');_0x1cfe26=_[_0xdccc('0x73')](_0x1cfe26,{'model':db[_0x2b44b5],'mapToModel':!![],'nest':!![]});if(_0x15d177['fields']){_0x2822a4[_0xdccc('0x74')][_0xdccc('0x23')](function(_0x4b51ed){_0x4ec1d1[_0xdccc('0x8')]('i.'+_0x4b51ed);});}else{_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x75'),_0xdccc('0x3d'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x76'),_0xdccc('0x77'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x78'),_0xdccc('0x79'));if(_0x3c7e88===_0xdccc('0x2e')){_0x4ec1d1['field'](_0xdccc('0x7a'),_0xdccc('0x7b'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x7c'),_0xdccc('0x7d'));_0x4ec1d1[_0xdccc('0x8')]('i.id');_0x4ec1d1['field']('i.createdAt');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x7e'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x7f'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x80'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x81'));_0x4ec1d1[_0xdccc('0x8')]('i.lastMsgAt');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x82'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x83'));_0x4ec1d1['field'](_0xdccc('0x67'));_0x4ec1d1[_0xdccc('0x8')]('i.secondDisposition');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x65'));_0x4ec1d1['field'](_0xdccc('0x69'));_0x4ec1d1['field'](_0xdccc('0x84'));_0x4ec1d1[_0xdccc('0x8')]('i.ContactId');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x85'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x86'));}else if(_0x3c7e88===_0xdccc('0x2c')){_0x4ec1d1[_0xdccc('0x8')]('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',_0xdccc('0x7d'));}else{_0x4ec1d1[_0xdccc('0x8')]('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',_0xdccc('0x7d'));}if(_0x3c7e88!==_0xdccc('0x2e')){_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x87'));}_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x88'),_0xdccc('0x89'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x8a'),_0xdccc('0x8b'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x8c'),'Contact.email');_0x4ec1d1['field']('c.phone','Contact.phone');_0x4ec1d1['field'](_0xdccc('0x8d'),'Contact.mobile');_0x4ec1d1['field'](_0xdccc('0x8e'),_0xdccc('0x8f'));_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x90'),_0xdccc('0x91'));_0x4ec1d1[_0xdccc('0x8')]('o.internal','Owner.internal');_0x4ec1d1[_0xdccc('0x8')](_0xdccc('0x92'),_0xdccc('0x93'));}if(_0x2822a4[_0xdccc('0x94')]){_0x4ec1d1[_0xdccc('0x94')](_0x2822a4[_0xdccc('0x94')]);}if(_0x2822a4[_0xdccc('0x95')]){_0x4ec1d1[_0xdccc('0x95')](_0x2822a4['offset']);}return db[_0xdccc('0x71')][_0xdccc('0x96')](_0x4ec1d1[_0xdccc('0x97')](),_0x1cfe26);})[_0xdccc('0x5a')](function(_0x4a509e){_0xa0d620=_0x4a509e;var _0x509cfc=getUsersQuery(_0x3c7e88,_0xa0d620);return db[_0xdccc('0x71')][_0xdccc('0x96')](_0x509cfc[_0xdccc('0x97')](),_0x1cfe26);})[_0xdccc('0x5a')](function(_0x2e108d){_0x2c62fc=_[_0xdccc('0x98')](_0x2e108d,_0x372e19);if(_0x3c7e88===_0xdccc('0x2e')){return db[_0xdccc('0x99')][_0xdccc('0x9a')]({'attributes':[_0xdccc('0x9b')],'raw':!![]});}})[_0xdccc('0x5a')](function(_0x389576){var _0x683170=_0x389576?_0x389576['enableEmailPreview']:undefined;var _0x5a5885=_0xa0d620[_0xdccc('0x15')](function(_0x2ba896){return updateInteraction(_0x2ba896,_0x4829ba,_0x2c62fc,_0x683170);});return Promise[_0xdccc('0x9c')](_0x5a5885);});}function countFilteredInteractions(_0x1ccec4,_0x1f01ea){var _0x34785e=_0x1ccec4[_0xdccc('0x9d')]();_0x34785e['field']('COUNT(*)');_0x34785e['field'](_0xdccc('0x75'),_0xdccc('0x3d'));var _0x130458=utils['getSelectedTags'](_0x1f01ea);if(!_['isEmpty'](_0x130458)){_0x34785e[_0xdccc('0x13')](_0xdccc('0x9e'),_0x130458);}var _0x27216e={'type':db[_0xdccc('0x6e')][_0xdccc('0x6f')][_0xdccc('0x70')],'raw':!![]};return db[_0xdccc('0x71')][_0xdccc('0x96')](_0x34785e['toString'](),_0x27216e);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};