cd54a56306aa40753752a1b1e7214cbe8ee55bf5
[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 _0x65b7=['Account.key','Account.mandatoryDisposition','a.email','Account.email','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgDirection','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','contactName','i.*','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.phone','c.mobile','Contact.mobile','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','toString','groupBy','Setting','all','COUNT(*)','where','t.id\x20IN\x20?','SELECT','exports','squel','./update-interaction','./utils','../../mysqldb','getAccountFK','agent','select','field','name','color','user_has_','_interactions','ui.','from','left_join','u.id\x20=\x20ui.UserId','length','\x20IN\x20?','map','getInteractionsTables','getInteractionFK','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','messages','me.','interactionsTags','\x20=\x20i.id','tools_tags','t.id\x20=\x20it.TagId','expr','getSelectedTags','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','i.fax\x20LIKE\x20?','openchannel','mail','c.email\x20LIKE\x20?','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)','parseSearch','sqlOperator','conditions','find','type','default','text','value','start','end','unreadMessages','read','and','Contact','operator','$substring','split','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','buildExpression','Tag','clause','ids','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','body','some','compact','forEach','concat','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','resolve','then','tag','tags','filter','get','capitalize','chat','Websites','Accounts','\x20IS\x20NULL','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','Interaction','Sequelize','QueryTypes','sequelize','query','keyBy','merge','fields','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)'];(function(_0xf32aa5,_0x59f152){var _0x3962e5=function(_0x5703a0){while(--_0x5703a0){_0xf32aa5['push'](_0xf32aa5['shift']());}};_0x3962e5(++_0x59f152);}(_0x65b7,0x166));var _0x765b=function(_0x33ad07,_0x15a999){_0x33ad07=_0x33ad07-0x0;var _0x137145=_0x65b7[_0x33ad07];return _0x137145;};'use strict';var _=require('lodash');var squel=require(_0x765b('0x0'));var as=require('../parsers/advancedSearch');var qs=require('../parsers/qs');var updateInteraction=require(_0x765b('0x1'))['updateInteraction'];var utils=require(_0x765b('0x2'));var db=require(_0x765b('0x3'))['db'];function skipInteractionsQuery(_0x5a0bfe,_0x1782e5,_0x5d5160){var _0x423de3=![];var _0x4232be=utils[_0x765b('0x4')](_0x5a0bfe);if(_0x1782e5['role']===_0x765b('0x5')&&!_0x5d5160['search']&&!_0x5d5160[_0x4232be]){_0x423de3=!![];}return _0x423de3;}function getTagsQuery(){return squel[_0x765b('0x6')]()[_0x765b('0x7')]('id')[_0x765b('0x7')](_0x765b('0x8'))['field'](_0x765b('0x9'))['from']('tools_tags');}function getUsersQuery(_0x456ab3,_0x56d63c){var _0x22e317=utils['getInteractionFK'](_0x456ab3);var _0x4bde88=_0x765b('0xa')+_0x456ab3+_0x765b('0xb');var _0x335c49=squel[_0x765b('0x6')]()[_0x765b('0x7')]('u.id')[_0x765b('0x7')]('u.fullname')['field'](_0x765b('0xc')+_0x22e317)[_0x765b('0xd')](_0x4bde88,'ui')[_0x765b('0xe')]('users','u',_0x765b('0xf'));if(_0x56d63c[_0x765b('0x10')]>0x0){_0x335c49['where'](_0x765b('0xc')+_0x22e317+_0x765b('0x11'),_[_0x765b('0x12')](_0x56d63c,'id'));}return _0x335c49;}function getInteractionsQuery(_0x59ab3f){var _0x3ab2cf=utils[_0x765b('0x13')](_0x59ab3f);var _0x3ae325=utils[_0x765b('0x4')](_0x59ab3f);var _0x3b6526=utils[_0x765b('0x14')](_0x59ab3f);return squel[_0x765b('0x6')]()[_0x765b('0xd')](_0x3ab2cf['interactions'],'i')[_0x765b('0xe')](_0x765b('0x15'),'c',_0x765b('0x16'))['left_join'](_0x765b('0x17'),'o',_0x765b('0x18'))[_0x765b('0xe')](_0x3ab2cf['accounts'],'a','a.id\x20=\x20i.'+_0x3ae325)[_0x765b('0xe')](_0x3ab2cf[_0x765b('0x19')],'me',_0x765b('0x1a')+_0x3b6526+'\x20=\x20i.id')[_0x765b('0xe')](_0x3ab2cf[_0x765b('0x1b')],'it','it.'+_0x3b6526+_0x765b('0x1c'))['left_join'](_0x765b('0x1d'),'t',_0x765b('0x1e'));}function getSqlClauses(){var _0x2839ae={'body':squel['expr'](),'contact':squel[_0x765b('0x1f')](),'default':squel[_0x765b('0x1f')](),'fields':squel[_0x765b('0x1f')](),'filter':squel['expr'](),'read':squel['expr'](),'tags':{'clause':squel[_0x765b('0x1f')](),'ids':null},'user':squel[_0x765b('0x1f')]()};return _0x2839ae;}function parseTagParameter(_0x369aeb){var _0x4dfe8c=squel[_0x765b('0x1f')]();if(_0x369aeb){var _0xbc57df=utils[_0x765b('0x20')](_0x369aeb);_0xbc57df['forEach'](function(_0x3b4899){_0x4dfe8c['or'](_0x765b('0x21'),'%,'+_0x3b4899+',%');});}return _0x4dfe8c;}function parseReadParameter(_0x56b360){var _0x1ffd9d='';if(_0x56b360){_0x1ffd9d=_0x765b('0x22');if(_0x56b360==='1'){_0x1ffd9d=_0x1ffd9d[_0x765b('0x23')]('{OPERATOR}','=');}else{_0x1ffd9d=_0x1ffd9d[_0x765b('0x23')](_0x765b('0x24'),'>');}}return _0x1ffd9d;}function parseSearchFilter(_0x1ea8ac,_0x133900){var _0x4b73f0=squel[_0x765b('0x1f')]();if(_0x133900){var _0x22f9d6=_0x133900[_0x765b('0x23')]('\x5c','\x5c\x5c')[_0x765b('0x23')](/'/g,'\x27\x27');var _0x3f3741=qs['escapeLIKESpecialChars'](_0x22f9d6);if(qs['isNumeric'](_0x22f9d6)){_0x4b73f0['or'](_0x765b('0x25'),_0x3f3741+'%');if([_0x765b('0x26'),_0x765b('0x27')]['includes'](_0x1ea8ac)){_0x4b73f0['or'](_0x765b('0x28'),_0x3f3741+'%');}else if(_0x1ea8ac==='fax'){_0x4b73f0['or'](_0x765b('0x29'),_0x3f3741+'%');}else if(_0x1ea8ac===_0x765b('0x2a')){_0x4b73f0['or']('i.from\x20LIKE\x20?',_0x3f3741+'%');}}else if(_0x1ea8ac===_0x765b('0x2b')&&qs['isEmail'](_0x22f9d6)){_0x4b73f0['or'](_0x765b('0x2c'),_0x3f3741+'%');}else{if(_0x1ea8ac===_0x765b('0x2b')){_0x4b73f0['or'](_0x765b('0x2d'),qs[_0x765b('0x2e')](_0x22f9d6,!![]))['or'](_0x765b('0x2f'),qs[_0x765b('0x2e')](_0x22f9d6));}else if(_0x1ea8ac!=='fax'){_0x4b73f0['or'](_0x765b('0x30'),qs['getFullTextValue'](_0x22f9d6));}_0x4b73f0['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x765b('0x2e')](_0x22f9d6,!![]),null);}}return _0x4b73f0;}function parseAdvancedSearchFilter(_0x4356ef,_0x24afbe){var _0x2feb4d=getSqlClauses();var _0x49a3dc=as[_0x765b('0x31')](_0x4356ef);var _0x5bf003=_0x49a3dc[_0x765b('0x32')];for(var _0x2cca67=0x0;_0x2cca67<_0x49a3dc[_0x765b('0x33')][_0x765b('0x10')];_0x2cca67++){var _0x2a02d8=_0x49a3dc[_0x765b('0x33')][_0x2cca67];var _0x544a65='i';var _0x2bcceb=_[_0x765b('0x34')](_0x24afbe,[_0x765b('0x8'),_0x2a02d8[_0x765b('0x7')]]);if(_0x2bcceb){var _0x45515b=as['buildExpression'](_0x544a65,_0x2bcceb[_0x765b('0x35')],_0x2a02d8);_0x2feb4d[_0x765b('0x36')][_0x5bf003](_0x45515b[_0x765b('0x37')],_0x45515b[_0x765b('0x38')][_0x765b('0x39')],_0x45515b['value'][_0x765b('0x3a')]);}else{switch(_0x2a02d8[_0x765b('0x7')]){case _0x765b('0x3b'):var _0x448ebe=parseReadParameter(_0x2a02d8[_0x765b('0x38')]);_0x2feb4d[_0x765b('0x3c')][_0x765b('0x3d')](_0x448ebe);break;case _0x765b('0x3e'):if(_0x2a02d8[_0x765b('0x3f')]===_0x765b('0x40')){if(_0x2a02d8[_0x765b('0x38')][_0x765b('0x41')]('\x20')['length']>0x1){_0x2feb4d[_0x765b('0x42')][_0x5bf003]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x765b('0x2e')](_0x2a02d8[_0x765b('0x38')],!![]),null);}else{var _0x59d82d='%'+_0x2a02d8[_0x765b('0x38')]+'%';_0x2feb4d['contact'][_0x5bf003](_0x765b('0x43'),_0x59d82d,_0x59d82d,_0x59d82d);}}else{_0x2bcceb=_[_0x765b('0x34')](_0x24afbe,[_0x765b('0x8'),'ContactId']);_0x2a02d8[_0x765b('0x7')]='ContactId';_0x45515b=as[_0x765b('0x44')](_0x544a65,_0x2bcceb['type'],_0x2a02d8);_0x2feb4d[_0x765b('0x42')][_0x5bf003](_0x45515b[_0x765b('0x37')],_0x45515b[_0x765b('0x38')][_0x765b('0x39')],_0x45515b[_0x765b('0x38')][_0x765b('0x3a')]);}break;case _0x765b('0x45'):var _0x2e3579=_0x2a02d8[_0x765b('0x38')]['split'](',')[_0x765b('0x12')](function(_0xa40cc9){return Number(_0xa40cc9);});var _0x41c500=parseTagParameter(_0x2e3579);_0x2feb4d['tags'][_0x765b('0x46')][_0x765b('0x3d')](_0x41c500);_0x2feb4d['tags'][_0x765b('0x47')]=_0x2e3579;break;case'User':if(_0x2a02d8['operator']===_0x765b('0x40')){_0x2feb4d[_0x765b('0x48')][_0x5bf003](_0x765b('0x49'),'%'+_0x2a02d8[_0x765b('0x38')]+'%',null);}else{_0x2bcceb=_[_0x765b('0x34')](_0x24afbe,[_0x765b('0x8'),'UserId']);_0x2a02d8[_0x765b('0x7')]='UserId';_0x45515b=as[_0x765b('0x44')](_0x544a65,_0x2bcceb['type'],_0x2a02d8);_0x2feb4d[_0x765b('0x48')][_0x5bf003](_0x45515b[_0x765b('0x37')],_0x45515b[_0x765b('0x38')][_0x765b('0x39')],_0x45515b[_0x765b('0x38')][_0x765b('0x3a')]);}break;case _0x765b('0x4a'):case'plainBody':_0x45515b=as[_0x765b('0x44')]('me',null,_0x2a02d8);_0x2feb4d[_0x765b('0x4a')][_0x5bf003](_0x45515b[_0x765b('0x37')],_0x45515b[_0x765b('0x38')][_0x765b('0x39')],_0x45515b[_0x765b('0x38')][_0x765b('0x3a')]);break;}}}return _0x2feb4d;}function parseModelFields(_0xaa8514,_0x57d7bd,_0x39ac20){var _0x3133f3=utils['getAccountFK'](_0xaa8514);var _0x280eda=squel[_0x765b('0x1f')]();var _0x341ec9=_(_0x57d7bd)['keys']()[_0x765b('0x12')](function(_0x23ced3){return _[_0x765b('0x4b')](_0x39ac20,[_0x765b('0x8'),_0x23ced3])?_0x23ced3:undefined;})[_0x765b('0x4c')]()[_0x765b('0x38')]();if(_0x341ec9[_0x765b('0x10')]>0x0){_0x341ec9[_0x765b('0x4d')](function(_0xe85955){if(_0xe85955===_0x3133f3){_0x280eda[_0x765b('0x3d')]('i.'+_0x3133f3+'\x20IN\x20?',[][_0x765b('0x4e')](_0x57d7bd[_0xe85955]));}else if(_0xe85955==='createdAt'){var _0x2f52c8=JSON[_0x765b('0x4f')](_0x57d7bd[_0xe85955])['$gte'];var _0x495422=JSON[_0x765b('0x4f')](_0x57d7bd[_0xe85955])[_0x765b('0x50')];_0x280eda[_0x765b('0x3d')](_0x765b('0x51'),_0x2f52c8,_0x495422);}else{if(_0x57d7bd[_0xe85955]===_0x765b('0x52')){_0x280eda['and']('i.'+_0xe85955+'\x20IS\x20NULL');}else{_0x280eda[_0x765b('0x3d')]('i.'+_0xe85955+_0x765b('0x53'),_0x57d7bd[_0xe85955]);}}});}return _0x280eda;}function parseQueryParameters(_0x2b9d25,_0x906f87,_0xdad52a){var _0x6498f8=getSqlClauses();return Promise[_0x765b('0x54')]()[_0x765b('0x55')](function(){return parseModelFields(_0x2b9d25,_0x906f87,_0xdad52a);})[_0x765b('0x55')](function(_0x10b47e){_0x6498f8['fields']['and'](_0x10b47e);return parseReadParameter(_0x906f87[_0x765b('0x3c')]);})['then'](function(_0x5e94cd){_0x6498f8[_0x765b('0x3c')][_0x765b('0x3d')](_0x5e94cd);return parseTagParameter(_0x906f87[_0x765b('0x56')]);})['then'](function(_0x20666a){_0x6498f8[_0x765b('0x57')][_0x765b('0x46')][_0x765b('0x3d')](_0x20666a);return parseSearchFilter(_0x2b9d25,_0x906f87[_0x765b('0x58')]);})[_0x765b('0x55')](function(_0x110e09){_0x6498f8[_0x765b('0x58')]=_0x110e09;return _0x6498f8;});}function checkAccountsRestrictions(_0x8b37ac,_0x33fdb9,_0x5efc08){var _0x34402d=utils[_0x765b('0x4')](_0x8b37ac);var _0x1543b8=_0x765b('0x59')+_[_0x765b('0x5a')](_0x8b37ac)+(_0x8b37ac===_0x765b('0x5b')?_0x765b('0x5c'):_0x765b('0x5d'));var _0x26983e=squel[_0x765b('0x1f')]();return Promise[_0x765b('0x54')]()[_0x765b('0x55')](function(){if(_0x5efc08['search']&&_0x33fdb9['role']===_0x765b('0x5')){return _0x33fdb9[_0x1543b8]({'attributes':['id'],'raw':!![]});}})[_0x765b('0x55')](function(_0x5bf39c){if(_0x5bf39c){if(_0x5bf39c[_0x765b('0x10')]===0x0){_0x26983e[_0x765b('0x3d')]('i.'+_0x34402d+_0x765b('0x5e'));}else{_0x26983e['and']('i.'+_0x34402d+_0x765b('0x11'),_[_0x765b('0x12')](_0x5bf39c,'id'));}}else if(!_0x5efc08[_0x34402d]){_0x26983e[_0x765b('0x3d')]('i.'+_0x34402d+_0x765b('0x5f'));}})['then'](function(){return _0x26983e;});}function getClosedOrderClause(_0x157734,_0xe150de){var _0x23fe5a='';var _0x58e8d8=[_0x765b('0x60'),_0x765b('0x61'),_0x765b('0x62')];if(_0x157734===_0x765b('0x2b')){_0x58e8d8[_0x765b('0x63')](_0x765b('0x64'));}if(_0xe150de[_0x765b('0x65')]==='0'&&_0x157734===_0x765b('0x2b')){_0x23fe5a=_0x765b('0x64');}else{if(_0xe150de[_0x765b('0x65')]==='1'){_0x58e8d8[_0x765b('0x66')]();}_0x23fe5a='CONCAT_WS(\x27\x27,\x20'+_0x58e8d8['join'](',\x20')+')';}return _0x23fe5a;}function getFilteredInteractions(_0x343fb1,_0x13df48,_0x22f79c,_0x45515f){var _0x58e092=utils[_0x765b('0x14')](_0x343fb1);var _0x10bd50=_[_0x765b('0x5a')](_0x343fb1)+_0x765b('0x67');var _0x594e9b=[];var _0x304ed4=getTagsQuery();var _0x4bbf30={'type':db[_0x765b('0x68')][_0x765b('0x69')]['SELECT'],'raw':!![]};var _0x1807d6=[];var _0x40c16b=[];return db[_0x765b('0x6a')][_0x765b('0x6b')](_0x304ed4['toString'](),_0x4bbf30)[_0x765b('0x55')](function(_0x4cb5e0){_0x594e9b=_[_0x765b('0x6c')](_0x4cb5e0,'id');_0x4bbf30=_[_0x765b('0x6d')](_0x4bbf30,{'model':db[_0x10bd50],'mapToModel':!![],'nest':!![]});if(_0x22f79c[_0x765b('0x6e')]){_0x45515f[_0x765b('0x6f')][_0x765b('0x4d')](function(_0x3f2892){_0x13df48[_0x765b('0x7')]('i.'+_0x3f2892);});}else{_0x13df48[_0x765b('0x7')](_0x765b('0x70'),_0x765b('0x3b'));_0x13df48[_0x765b('0x7')]('a.key',_0x765b('0x71'));_0x13df48[_0x765b('0x7')]('a.mandatoryDisposition',_0x765b('0x72'));if(_0x343fb1==='mail'){_0x13df48['field'](_0x765b('0x73'),_0x765b('0x74'));_0x13df48[_0x765b('0x7')]('CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName');_0x13df48[_0x765b('0x7')](_0x765b('0x75'));_0x13df48[_0x765b('0x7')](_0x765b('0x76'));_0x13df48[_0x765b('0x7')](_0x765b('0x77'));_0x13df48[_0x765b('0x7')](_0x765b('0x78'));_0x13df48[_0x765b('0x7')](_0x765b('0x79'));_0x13df48[_0x765b('0x7')](_0x765b('0x7a'));_0x13df48[_0x765b('0x7')]('i.lastMsgAt');_0x13df48[_0x765b('0x7')](_0x765b('0x7b'));_0x13df48['field']('i.subject');_0x13df48[_0x765b('0x7')]('i.disposition');_0x13df48[_0x765b('0x7')](_0x765b('0x61'));_0x13df48[_0x765b('0x7')]('i.thirdDisposition');_0x13df48[_0x765b('0x7')](_0x765b('0x64'));_0x13df48['field'](_0x765b('0x7c'));_0x13df48[_0x765b('0x7')](_0x765b('0x7d'));_0x13df48[_0x765b('0x7')](_0x765b('0x7e'));_0x13df48['field'](_0x765b('0x7f'));}else if(_0x343fb1===_0x765b('0x2a')){_0x13df48[_0x765b('0x7')](_0x765b('0x80'),'contactName');}else{_0x13df48[_0x765b('0x7')](_0x765b('0x81'),_0x765b('0x82'));}if(_0x343fb1!==_0x765b('0x2b')){_0x13df48['field'](_0x765b('0x83'));}_0x13df48['field']('c.firstName',_0x765b('0x84'));_0x13df48[_0x765b('0x7')](_0x765b('0x85'),_0x765b('0x86'));_0x13df48['field'](_0x765b('0x87'),'Contact.email');_0x13df48[_0x765b('0x7')]('c.phone',_0x765b('0x88'));_0x13df48[_0x765b('0x7')](_0x765b('0x89'),_0x765b('0x8a'));_0x13df48[_0x765b('0x7')]('c.fax',_0x765b('0x8b'));_0x13df48[_0x765b('0x7')](_0x765b('0x8c'),_0x765b('0x8d'));_0x13df48[_0x765b('0x7')](_0x765b('0x8e'),_0x765b('0x8f'));_0x13df48['field'](_0x765b('0x90'),_0x765b('0x91'));}if(_0x45515f['limit']){_0x13df48[_0x765b('0x92')](_0x45515f[_0x765b('0x92')]);}if(_0x45515f[_0x765b('0x93')]){_0x13df48[_0x765b('0x93')](_0x45515f['offset']);}return db['sequelize'][_0x765b('0x6b')](_0x13df48[_0x765b('0x94')](),_0x4bbf30);})[_0x765b('0x55')](function(_0x241222){_0x1807d6=_0x241222;var _0x510e9e=getUsersQuery(_0x343fb1,_0x1807d6);return db[_0x765b('0x6a')][_0x765b('0x6b')](_0x510e9e[_0x765b('0x94')](),_0x4bbf30);})[_0x765b('0x55')](function(_0x45eaed){_0x40c16b=_[_0x765b('0x95')](_0x45eaed,_0x58e092);if(_0x343fb1===_0x765b('0x2b')){return db[_0x765b('0x96')]['findOne']({'attributes':['enableEmailPreview'],'raw':!![]});}})[_0x765b('0x55')](function(_0x140027){var _0x4d0f86=_0x140027?_0x140027['enableEmailPreview']:undefined;var _0x21cc4e=_0x1807d6[_0x765b('0x12')](function(_0x148cc7){return updateInteraction(_0x148cc7,_0x594e9b,_0x40c16b,_0x4d0f86);});return Promise[_0x765b('0x97')](_0x21cc4e);});}function countFilteredInteractions(_0x257eac,_0x25aacc){var _0x55aa6b=_0x257eac['clone']();_0x55aa6b[_0x765b('0x7')](_0x765b('0x98'));_0x55aa6b['field'](_0x765b('0x70'),_0x765b('0x3b'));var _0x4a053f=utils[_0x765b('0x20')](_0x25aacc);if(!_['isEmpty'](_0x4a053f)){_0x55aa6b[_0x765b('0x99')](_0x765b('0x9a'),_0x4a053f);}var _0x182269={'type':db[_0x765b('0x68')][_0x765b('0x69')][_0x765b('0x9b')],'raw':!![]};return db['sequelize'][_0x765b('0x6b')](_0x55aa6b[_0x765b('0x94')](),_0x182269);}module[_0x765b('0x9c')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};