Built motion from commit bbec7235.|2.6.20
[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 _0x3de3=['_interactions','select','u.id','u.fullname','ui.','u.id\x20=\x20ui.UserId','length','map','getInteractionsTables','interactions','left_join','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','accounts','me.','\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','unreadMessages\x20{OPERATOR}\x200','replace','{OPERATOR}','isNumeric','i.id\x20LIKE\x20?','sms','includes','i.phone\x20LIKE\x20?','fax','i.fax\x20LIKE\x20?','i.from\x20LIKE\x20?','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','buildExpression','default','text','start','value','end','unreadMessages','read','and','operator','$substring','split','contact','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','ContactId','Tag','tags','clause','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','type','body','plainBody','keys','some','compact','forEach','\x20IN\x20?','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','fields','tag','filter','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','toString','merge','attributes','a.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','i.attach','i.lastMsgAt','i.lastMsgDirection','i.to','i.ContactId','i.MailAccountId','i.UserId','openchannel','contactName','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','c.firstName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','c.fax','o.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','findOne','enableEmailPreview','all','clone','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','getSelectedTags','where','t.id\x20IN\x20?','lodash','../parsers/advancedSearch','../parsers/qs','./update-interaction','getAccountFK','role','agent','search','field','name','color','from','getInteractionFK','user_has_'];(function(_0x2359ad,_0x23d661){var _0x1e7ed5=function(_0x4c9de4){while(--_0x4c9de4){_0x2359ad['push'](_0x2359ad['shift']());}};_0x1e7ed5(++_0x23d661);}(_0x3de3,0x132));var _0x33de=function(_0x300af3,_0x16cf33){_0x300af3=_0x300af3-0x0;var _0x28a357=_0x3de3[_0x300af3];return _0x28a357;};'use strict';var _=require(_0x33de('0x0'));var squel=require('squel');var as=require(_0x33de('0x1'));var qs=require(_0x33de('0x2'));var updateInteraction=require(_0x33de('0x3'))['updateInteraction'];var utils=require('./utils');var db=require('../../mysqldb')['db'];function skipInteractionsQuery(_0xf574f9,_0xdf619d,_0x1583da){var _0x29a704=![];var _0x5436e0=utils[_0x33de('0x4')](_0xf574f9);if(_0xdf619d[_0x33de('0x5')]===_0x33de('0x6')&&!_0x1583da[_0x33de('0x7')]&&!_0x1583da[_0x5436e0]){_0x29a704=!![];}return _0x29a704;}function getTagsQuery(){return squel['select']()[_0x33de('0x8')]('id')[_0x33de('0x8')](_0x33de('0x9'))['field'](_0x33de('0xa'))[_0x33de('0xb')]('tools_tags');}function getUsersQuery(_0x551b66,_0x512067){var _0x4348a2=utils[_0x33de('0xc')](_0x551b66);var _0x4040bb=_0x33de('0xd')+_0x551b66+_0x33de('0xe');var _0xcf6f16=squel[_0x33de('0xf')]()[_0x33de('0x8')](_0x33de('0x10'))[_0x33de('0x8')](_0x33de('0x11'))[_0x33de('0x8')](_0x33de('0x12')+_0x4348a2)['from'](_0x4040bb,'ui')['left_join']('users','u',_0x33de('0x13'));if(_0x512067[_0x33de('0x14')]>0x0){_0xcf6f16['where']('ui.'+_0x4348a2+'\x20IN\x20?',_[_0x33de('0x15')](_0x512067,'id'));}return _0xcf6f16;}function getInteractionsQuery(_0xad3623){var _0x3f81f8=utils[_0x33de('0x16')](_0xad3623);var _0x1cf733=utils[_0x33de('0x4')](_0xad3623);var _0x5b3f72=utils[_0x33de('0xc')](_0xad3623);return squel[_0x33de('0xf')]()['from'](_0x3f81f8[_0x33de('0x17')],'i')[_0x33de('0x18')](_0x33de('0x19'),'c',_0x33de('0x1a'))[_0x33de('0x18')](_0x33de('0x1b'),'o',_0x33de('0x1c'))['left_join'](_0x3f81f8[_0x33de('0x1d')],'a','a.id\x20=\x20i.'+_0x1cf733)[_0x33de('0x18')](_0x3f81f8['messages'],'me',_0x33de('0x1e')+_0x5b3f72+'\x20=\x20i.id')[_0x33de('0x18')](_0x3f81f8['interactionsTags'],'it','it.'+_0x5b3f72+_0x33de('0x1f'))['left_join']('tools_tags','t',_0x33de('0x20'));}function getSqlClauses(){var _0x338529={'body':squel['expr'](),'contact':squel['expr'](),'default':squel[_0x33de('0x21')](),'fields':squel[_0x33de('0x21')](),'filter':squel[_0x33de('0x21')](),'read':squel[_0x33de('0x21')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x33de('0x21')]()};return _0x338529;}function parseTagParameter(_0x145c88){var _0x40a580=squel['expr']();if(_0x145c88){var _0x14747a=utils['getSelectedTags'](_0x145c88);_0x14747a['forEach'](function(_0x2dc357){_0x40a580['or'](_0x33de('0x22'),'%,'+_0x2dc357+',%');});}return _0x40a580;}function parseReadParameter(_0x3004be){var _0x8bc0cd='';if(_0x3004be){_0x8bc0cd=_0x33de('0x23');if(_0x3004be==='1'){_0x8bc0cd=_0x8bc0cd[_0x33de('0x24')]('{OPERATOR}','=');}else{_0x8bc0cd=_0x8bc0cd['replace'](_0x33de('0x25'),'>');}}return _0x8bc0cd;}function parseSearchFilter(_0x3c6368,_0x35a115){var _0x5aedc5=squel['expr']();if(_0x35a115){var _0x196e54=_0x35a115[_0x33de('0x24')]('\x5c','\x5c\x5c')[_0x33de('0x24')](/'/g,'\x27\x27');if(qs[_0x33de('0x26')](_0x196e54)){_0x5aedc5['or'](_0x33de('0x27'),_0x196e54+'%');if([_0x33de('0x28'),'whatsapp'][_0x33de('0x29')](_0x3c6368)){_0x5aedc5['or'](_0x33de('0x2a'),_0x196e54+'%');}else if(_0x3c6368===_0x33de('0x2b')){_0x5aedc5['or'](_0x33de('0x2c'),_0x196e54+'%');}else if(_0x3c6368==='openchannel'){_0x5aedc5['or'](_0x33de('0x2d'),_0x196e54+'%');}}else if(_0x3c6368===_0x33de('0x2e')&&qs['isEmail'](_0x196e54)){_0x5aedc5['or'](_0x33de('0x2f'),_0x196e54+'%');}else{if(_0x3c6368===_0x33de('0x2e')){_0x5aedc5['or'](_0x33de('0x30'),qs[_0x33de('0x31')](_0x196e54,!![]))['or'](_0x33de('0x32'),qs[_0x33de('0x31')](_0x196e54));}else if(_0x3c6368!==_0x33de('0x2b')){_0x5aedc5['or'](_0x33de('0x33'),qs[_0x33de('0x31')](_0x196e54));}_0x5aedc5['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x33de('0x31')](_0x196e54,!![]),null);}}return _0x5aedc5;}function parseAdvancedSearchFilter(_0x3ce859,_0x5209d5){var _0x20124c=getSqlClauses();var _0x53312d=as[_0x33de('0x34')](_0x3ce859);var _0x9480ae=_0x53312d[_0x33de('0x35')];for(var _0x192534=0x0;_0x192534<_0x53312d[_0x33de('0x36')][_0x33de('0x14')];_0x192534++){var _0x52133b=_0x53312d[_0x33de('0x36')][_0x192534];var _0x17ea19='i';var _0x1f449b=_[_0x33de('0x37')](_0x5209d5,[_0x33de('0x9'),_0x52133b[_0x33de('0x8')]]);if(_0x1f449b){var _0x3243f0=as[_0x33de('0x38')](_0x17ea19,_0x1f449b['type'],_0x52133b);_0x20124c[_0x33de('0x39')][_0x9480ae](_0x3243f0[_0x33de('0x3a')],_0x3243f0['value'][_0x33de('0x3b')],_0x3243f0[_0x33de('0x3c')][_0x33de('0x3d')]);}else{switch(_0x52133b[_0x33de('0x8')]){case _0x33de('0x3e'):var _0x2791f6=parseReadParameter(_0x52133b['value']);_0x20124c[_0x33de('0x3f')][_0x33de('0x40')](_0x2791f6);break;case'Contact':if(_0x52133b[_0x33de('0x41')]===_0x33de('0x42')){if(_0x52133b[_0x33de('0x3c')][_0x33de('0x43')]('\x20')[_0x33de('0x14')]>0x1){_0x20124c[_0x33de('0x44')][_0x9480ae](_0x33de('0x45'),qs['getFullTextValue'](_0x52133b[_0x33de('0x3c')],!![]),null);}else{var _0x8fc686='%'+_0x52133b[_0x33de('0x3c')]+'%';_0x20124c[_0x33de('0x44')][_0x9480ae]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x8fc686,_0x8fc686,_0x8fc686);}}else{_0x1f449b=_[_0x33de('0x37')](_0x5209d5,[_0x33de('0x9'),'ContactId']);_0x52133b[_0x33de('0x8')]=_0x33de('0x46');_0x3243f0=as['buildExpression'](_0x17ea19,_0x1f449b['type'],_0x52133b);_0x20124c[_0x33de('0x44')][_0x9480ae](_0x3243f0[_0x33de('0x3a')],_0x3243f0[_0x33de('0x3c')][_0x33de('0x3b')],_0x3243f0[_0x33de('0x3c')][_0x33de('0x3d')]);}break;case _0x33de('0x47'):var _0x217ad9=_0x52133b['value'][_0x33de('0x43')](',')['map'](function(_0x4a8f0d){return Number(_0x4a8f0d);});var _0x950b4b=parseTagParameter(_0x217ad9);_0x20124c[_0x33de('0x48')][_0x33de('0x49')][_0x33de('0x40')](_0x950b4b);_0x20124c['tags']['ids']=_0x217ad9;break;case _0x33de('0x4a'):if(_0x52133b['operator']==='$substring'){_0x20124c[_0x33de('0x4b')][_0x9480ae](_0x33de('0x4c'),'%'+_0x52133b[_0x33de('0x3c')]+'%',null);}else{_0x1f449b=_[_0x33de('0x37')](_0x5209d5,['name',_0x33de('0x4d')]);_0x52133b[_0x33de('0x8')]=_0x33de('0x4d');_0x3243f0=as['buildExpression'](_0x17ea19,_0x1f449b[_0x33de('0x4e')],_0x52133b);_0x20124c[_0x33de('0x4b')][_0x9480ae](_0x3243f0['text'],_0x3243f0[_0x33de('0x3c')]['start'],_0x3243f0['value'][_0x33de('0x3d')]);}break;case _0x33de('0x4f'):case _0x33de('0x50'):_0x3243f0=as[_0x33de('0x38')]('me',null,_0x52133b);_0x20124c['body'][_0x9480ae](_0x3243f0['text'],_0x3243f0[_0x33de('0x3c')][_0x33de('0x3b')],_0x3243f0[_0x33de('0x3c')][_0x33de('0x3d')]);break;}}}return _0x20124c;}function parseModelFields(_0x2f8687,_0x3a5a26,_0x145a7a){var _0x3df791=utils[_0x33de('0x4')](_0x2f8687);var _0x2d6e2c=squel['expr']();var _0x32337a=_(_0x3a5a26)[_0x33de('0x51')]()['map'](function(_0x224174){return _[_0x33de('0x52')](_0x145a7a,[_0x33de('0x9'),_0x224174])?_0x224174:undefined;})[_0x33de('0x53')]()[_0x33de('0x3c')]();if(_0x32337a[_0x33de('0x14')]>0x0){_0x32337a[_0x33de('0x54')](function(_0x32c920){if(_0x32c920===_0x3df791){_0x2d6e2c[_0x33de('0x40')]('i.'+_0x3df791+_0x33de('0x55'),[][_0x33de('0x56')](_0x3a5a26[_0x32c920]));}else if(_0x32c920===_0x33de('0x57')){var _0x219f84=JSON[_0x33de('0x58')](_0x3a5a26[_0x32c920])[_0x33de('0x59')];var _0x16a485=JSON['parse'](_0x3a5a26[_0x32c920])[_0x33de('0x5a')];_0x2d6e2c['and'](_0x33de('0x5b'),_0x219f84,_0x16a485);}else{if(_0x3a5a26[_0x32c920]===_0x33de('0x5c')){_0x2d6e2c[_0x33de('0x40')]('i.'+_0x32c920+_0x33de('0x5d'));}else{_0x2d6e2c['and']('i.'+_0x32c920+_0x33de('0x5e'),_0x3a5a26[_0x32c920]);}}});}return _0x2d6e2c;}function parseQueryParameters(_0x3421cd,_0x2bf50b,_0x1368f7){var _0xb53ac9=getSqlClauses();return Promise[_0x33de('0x5f')]()[_0x33de('0x60')](function(){return parseModelFields(_0x3421cd,_0x2bf50b,_0x1368f7);})[_0x33de('0x60')](function(_0xa0819f){_0xb53ac9[_0x33de('0x61')][_0x33de('0x40')](_0xa0819f);return parseReadParameter(_0x2bf50b[_0x33de('0x3f')]);})[_0x33de('0x60')](function(_0x541af6){_0xb53ac9[_0x33de('0x3f')][_0x33de('0x40')](_0x541af6);return parseTagParameter(_0x2bf50b[_0x33de('0x62')]);})[_0x33de('0x60')](function(_0x41db07){_0xb53ac9[_0x33de('0x48')]['clause'][_0x33de('0x40')](_0x41db07);return parseSearchFilter(_0x3421cd,_0x2bf50b[_0x33de('0x63')]);})[_0x33de('0x60')](function(_0x43a450){_0xb53ac9[_0x33de('0x63')]=_0x43a450;return _0xb53ac9;});}function checkAccountsRestrictions(_0x76c784,_0x46069c,_0x13bb18){var _0x252e1f=utils['getAccountFK'](_0x76c784);var _0x4216ae='get'+_[_0x33de('0x64')](_0x76c784)+(_0x76c784===_0x33de('0x65')?_0x33de('0x66'):_0x33de('0x67'));var _0x2f5b89=squel[_0x33de('0x21')]();return Promise[_0x33de('0x5f')]()[_0x33de('0x60')](function(){if(_0x13bb18['search']&&_0x46069c[_0x33de('0x5')]==='agent'){return _0x46069c[_0x4216ae]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x1f5820){if(_0x1f5820){if(_0x1f5820['length']===0x0){_0x2f5b89[_0x33de('0x40')]('i.'+_0x252e1f+_0x33de('0x5d'));}else{_0x2f5b89['and']('i.'+_0x252e1f+_0x33de('0x55'),_['map'](_0x1f5820,'id'));}}else if(!_0x13bb18[_0x252e1f]){_0x2f5b89['and']('i.'+_0x252e1f+_0x33de('0x68'));}})[_0x33de('0x60')](function(){return _0x2f5b89;});}function getClosedOrderClause(_0x3037f8,_0x65e78c){var _0x3671ae='';var _0x389b52=[_0x33de('0x69'),_0x33de('0x6a'),_0x33de('0x6b')];if(_0x3037f8===_0x33de('0x2e')){_0x389b52[_0x33de('0x6c')](_0x33de('0x6d'));}if(_0x65e78c[_0x33de('0x6e')]==='0'&&_0x3037f8===_0x33de('0x2e')){_0x3671ae='i.substatus';}else{if(_0x65e78c[_0x33de('0x6e')]==='1'){_0x389b52[_0x33de('0x6f')]();}_0x3671ae='CONCAT_WS(\x27\x27,\x20'+_0x389b52[_0x33de('0x70')](',\x20')+')';}return _0x3671ae;}function getFilteredInteractions(_0x1a8e29,_0x3fcf26,_0x57170b,_0x1a0547){var _0x426ce5=utils['getInteractionFK'](_0x1a8e29);var _0x2e5f0b=_['capitalize'](_0x1a8e29)+_0x33de('0x71');var _0x481057=[];var _0x24d553=getTagsQuery();var _0x137af4={'type':db[_0x33de('0x72')][_0x33de('0x73')][_0x33de('0x74')],'raw':!![]};var _0xaa1b89=[];var _0x321a1d=[];return db[_0x33de('0x75')][_0x33de('0x76')](_0x24d553[_0x33de('0x77')](),_0x137af4)[_0x33de('0x60')](function(_0xfe00d5){_0x481057=_['keyBy'](_0xfe00d5,'id');_0x137af4=_[_0x33de('0x78')](_0x137af4,{'model':db[_0x2e5f0b],'mapToModel':!![],'nest':!![]});if(_0x57170b['fields']){_0x1a0547[_0x33de('0x79')][_0x33de('0x54')](function(_0x51a6ca){_0x3fcf26[_0x33de('0x8')]('i.'+_0x51a6ca);});}else{_0x3fcf26[_0x33de('0x8')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x3fcf26[_0x33de('0x8')](_0x33de('0x7a'),'Account.key');_0x3fcf26[_0x33de('0x8')](_0x33de('0x7b'),_0x33de('0x7c'));if(_0x1a8e29==='mail'){_0x3fcf26[_0x33de('0x8')](_0x33de('0x7d'),_0x33de('0x7e'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x7f'),'contactName');_0x3fcf26[_0x33de('0x8')]('i.id');_0x3fcf26[_0x33de('0x8')]('i.createdAt');_0x3fcf26[_0x33de('0x8')]('i.updatedAt');_0x3fcf26[_0x33de('0x8')]('i.closed');_0x3fcf26[_0x33de('0x8')]('i.closedAt');_0x3fcf26[_0x33de('0x8')](_0x33de('0x80'));_0x3fcf26['field'](_0x33de('0x81'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x82'));_0x3fcf26['field']('i.subject');_0x3fcf26[_0x33de('0x8')]('i.disposition');_0x3fcf26[_0x33de('0x8')]('i.secondDisposition');_0x3fcf26[_0x33de('0x8')](_0x33de('0x69'));_0x3fcf26[_0x33de('0x8')]('i.substatus');_0x3fcf26[_0x33de('0x8')](_0x33de('0x83'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x84'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x85'));_0x3fcf26['field'](_0x33de('0x86'));}else if(_0x1a8e29===_0x33de('0x87')){_0x3fcf26[_0x33de('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',_0x33de('0x88'));}else{_0x3fcf26[_0x33de('0x8')](_0x33de('0x89'),'contactName');}if(_0x1a8e29!==_0x33de('0x2e')){_0x3fcf26['field']('i.*');}_0x3fcf26[_0x33de('0x8')](_0x33de('0x8a'),'Contact.firstName');_0x3fcf26[_0x33de('0x8')]('c.lastName',_0x33de('0x8b'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x8c'),_0x33de('0x8d'));_0x3fcf26[_0x33de('0x8')]('c.phone',_0x33de('0x8e'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x8f'),'Contact.mobile');_0x3fcf26[_0x33de('0x8')](_0x33de('0x90'),'Contact.fax');_0x3fcf26[_0x33de('0x8')](_0x33de('0x91'),'Owner.fullname');_0x3fcf26[_0x33de('0x8')]('o.internal',_0x33de('0x92'));_0x3fcf26[_0x33de('0x8')](_0x33de('0x93'),_0x33de('0x94'));}if(_0x1a0547[_0x33de('0x95')]){_0x3fcf26[_0x33de('0x95')](_0x1a0547['limit']);}if(_0x1a0547[_0x33de('0x96')]){_0x3fcf26['offset'](_0x1a0547[_0x33de('0x96')]);}return db[_0x33de('0x75')][_0x33de('0x76')](_0x3fcf26[_0x33de('0x77')](),_0x137af4);})[_0x33de('0x60')](function(_0x386add){_0xaa1b89=_0x386add;var _0x4cb685=getUsersQuery(_0x1a8e29,_0xaa1b89);return db[_0x33de('0x75')][_0x33de('0x76')](_0x4cb685[_0x33de('0x77')](),_0x137af4);})[_0x33de('0x60')](function(_0x1dab1e){_0x321a1d=_['groupBy'](_0x1dab1e,_0x426ce5);if(_0x1a8e29===_0x33de('0x2e')){return db['Setting'][_0x33de('0x97')]({'attributes':[_0x33de('0x98')],'raw':!![]});}})['then'](function(_0x1b1e75){var _0x481af0=_0x1b1e75?_0x1b1e75[_0x33de('0x98')]:undefined;var _0x3c63cf=_0xaa1b89[_0x33de('0x15')](function(_0x262189){return updateInteraction(_0x262189,_0x481057,_0x321a1d,_0x481af0);});return Promise[_0x33de('0x99')](_0x3c63cf);});}function countFilteredInteractions(_0x1d58be,_0x23f914){var _0x4882f7=_0x1d58be[_0x33de('0x9a')]();_0x4882f7[_0x33de('0x8')](_0x33de('0x9b'));_0x4882f7['field'](_0x33de('0x9c'),_0x33de('0x3e'));var _0x103aa5=utils[_0x33de('0x9d')](_0x23f914);if(!_['isEmpty'](_0x103aa5)){_0x4882f7[_0x33de('0x9e')](_0x33de('0x9f'),_0x103aa5);}var _0x2902f7={'type':db[_0x33de('0x72')]['QueryTypes'][_0x33de('0x74')],'raw':!![]};return db[_0x33de('0x75')]['query'](_0x4882f7['toString'](),_0x2902f7);}module['exports']={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};