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 _0x8c51=['sqlOperator','conditions','find','buildExpression','default','value','start','unreadMessages','read','and','Contact','operator','$substring','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','type','Tag','split','tags','ids','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','text','plainBody','body','end','keys','some','\x20IN\x20?','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','fields','tag','then','filter','get','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.thirdDisposition','i.secondDisposition','i.disposition','closed','i.substatus','shift','join','Interaction','Sequelize','QueryTypes','sequelize','query','toString','keyBy','merge','attributes','Account.key','Account.mandatoryDisposition','a.email','Account.email','CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','contactName','i.createdAt','i.attach','i.lastMsgAt','i.subject','i.to','i.ContactId','i.MailAccountId','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','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile','Contact.mobile','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','groupBy','Setting','findOne','enableEmailPreview','clone','COUNT(*)','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','t.id\x20IN\x20?','SELECT','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','./update-interaction','./utils','../../mysqldb','getAccountFK','role','agent','search','field','name','color','from','tools_tags','user_has_','select','u.fullname','ui.','left_join','u.id\x20=\x20ui.UserId','length','where','map','getInteractionFK','cm_contacts','users','o.id\x20=\x20i.UserId','accounts','\x20=\x20i.id','interactionsTags','it.','t.id\x20=\x20it.TagId','expr','getSelectedTags','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','{OPERATOR}','replace','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','whatsapp','includes','fax','openchannel','i.from\x20LIKE\x20?','mail','isEmail','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)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','parseSearch'];(function(_0x4e676e,_0x2a7c6d){var _0x336a3c=function(_0x4767c4){while(--_0x4767c4){_0x4e676e['push'](_0x4e676e['shift']());}};_0x336a3c(++_0x2a7c6d);}(_0x8c51,0x10b));var _0x18c5=function(_0x150dfb,_0xcb9836){_0x150dfb=_0x150dfb-0x0;var _0x2f7814=_0x8c51[_0x150dfb];return _0x2f7814;};'use strict';var _=require(_0x18c5('0x0'));var squel=require(_0x18c5('0x1'));var as=require(_0x18c5('0x2'));var qs=require(_0x18c5('0x3'));var updateInteraction=require(_0x18c5('0x4'))['updateInteraction'];var utils=require(_0x18c5('0x5'));var db=require(_0x18c5('0x6'))['db'];function skipInteractionsQuery(_0x8a0394,_0x93f155,_0x1d4ced){var _0xf2c8a2=![];var _0x315b3a=utils[_0x18c5('0x7')](_0x8a0394);if(_0x93f155[_0x18c5('0x8')]===_0x18c5('0x9')&&!_0x1d4ced[_0x18c5('0xa')]&&!_0x1d4ced[_0x315b3a]){_0xf2c8a2=!![];}return _0xf2c8a2;}function getTagsQuery(){return squel['select']()[_0x18c5('0xb')]('id')[_0x18c5('0xb')](_0x18c5('0xc'))[_0x18c5('0xb')](_0x18c5('0xd'))[_0x18c5('0xe')](_0x18c5('0xf'));}function getUsersQuery(_0x2795a4,_0x3e5e7e){var _0x5e11ec=utils['getInteractionFK'](_0x2795a4);var _0x2fa566=_0x18c5('0x10')+_0x2795a4+'_interactions';var _0x553783=squel[_0x18c5('0x11')]()[_0x18c5('0xb')]('u.id')['field'](_0x18c5('0x12'))[_0x18c5('0xb')](_0x18c5('0x13')+_0x5e11ec)[_0x18c5('0xe')](_0x2fa566,'ui')[_0x18c5('0x14')]('users','u',_0x18c5('0x15'));if(_0x3e5e7e[_0x18c5('0x16')]>0x0){_0x553783[_0x18c5('0x17')](_0x18c5('0x13')+_0x5e11ec+'\x20IN\x20?',_[_0x18c5('0x18')](_0x3e5e7e,'id'));}return _0x553783;}function getInteractionsQuery(_0xd4940d){var _0x3437c5=utils['getInteractionsTables'](_0xd4940d);var _0x5c1bbb=utils['getAccountFK'](_0xd4940d);var _0x571d08=utils[_0x18c5('0x19')](_0xd4940d);return squel[_0x18c5('0x11')]()['from'](_0x3437c5['interactions'],'i')[_0x18c5('0x14')](_0x18c5('0x1a'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')['left_join'](_0x18c5('0x1b'),'o',_0x18c5('0x1c'))[_0x18c5('0x14')](_0x3437c5[_0x18c5('0x1d')],'a','a.id\x20=\x20i.'+_0x5c1bbb)[_0x18c5('0x14')](_0x3437c5['messages'],'me','me.'+_0x571d08+_0x18c5('0x1e'))[_0x18c5('0x14')](_0x3437c5[_0x18c5('0x1f')],'it',_0x18c5('0x20')+_0x571d08+'\x20=\x20i.id')[_0x18c5('0x14')](_0x18c5('0xf'),'t',_0x18c5('0x21'));}function getSqlClauses(){var _0x1788ef={'body':squel[_0x18c5('0x22')](),'contact':squel[_0x18c5('0x22')](),'default':squel[_0x18c5('0x22')](),'fields':squel['expr'](),'filter':squel['expr'](),'read':squel['expr'](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel[_0x18c5('0x22')]()};return _0x1788ef;}function parseTagParameter(_0x40b03b){var _0x1abb80=squel[_0x18c5('0x22')]();if(_0x40b03b){var _0x3f1d00=utils[_0x18c5('0x23')](_0x40b03b);_0x3f1d00[_0x18c5('0x24')](function(_0x21f545){_0x1abb80['or'](_0x18c5('0x25'),'%,'+_0x21f545+',%');});}return _0x1abb80;}function parseReadParameter(_0x54182a){var _0xd34e37='';if(_0x54182a){_0xd34e37='unreadMessages\x20{OPERATOR}\x200';if(_0x54182a==='1'){_0xd34e37=_0xd34e37['replace'](_0x18c5('0x26'),'=');}else{_0xd34e37=_0xd34e37['replace'](_0x18c5('0x26'),'>');}}return _0xd34e37;}function parseSearchFilter(_0xd139,_0x55de3c){var _0x29bb08=squel[_0x18c5('0x22')]();if(_0x55de3c){var _0x1afadb=_0x55de3c[_0x18c5('0x27')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');var _0x5c1152=qs[_0x18c5('0x28')](_0x1afadb);if(qs[_0x18c5('0x29')](_0x1afadb)){_0x29bb08['or'](_0x18c5('0x2a'),_0x5c1152+'%');if(['sms',_0x18c5('0x2b')][_0x18c5('0x2c')](_0xd139)){_0x29bb08['or']('i.phone\x20LIKE\x20?',_0x5c1152+'%');}else if(_0xd139===_0x18c5('0x2d')){_0x29bb08['or']('i.fax\x20LIKE\x20?',_0x5c1152+'%');}else if(_0xd139===_0x18c5('0x2e')){_0x29bb08['or'](_0x18c5('0x2f'),_0x5c1152+'%');}}else if(_0xd139===_0x18c5('0x30')&&qs[_0x18c5('0x31')](_0x1afadb)){_0x29bb08['or'](_0x18c5('0x32'),_0x5c1152+'%');}else{if(_0xd139==='mail'){_0x29bb08['or'](_0x18c5('0x33'),qs[_0x18c5('0x34')](_0x1afadb,!![]))['or'](_0x18c5('0x35'),qs[_0x18c5('0x34')](_0x1afadb));}else if(_0xd139!==_0x18c5('0x2d')){_0x29bb08['or'](_0x18c5('0x36'),qs[_0x18c5('0x34')](_0x1afadb));}_0x29bb08['or'](_0x18c5('0x37'),qs[_0x18c5('0x34')](_0x1afadb,!![]),null);}}return _0x29bb08;}function parseAdvancedSearchFilter(_0x460c84,_0x3a3fa3){var _0x5f1328=getSqlClauses();var _0x3fbeb7=as[_0x18c5('0x38')](_0x460c84);var _0x49499e=_0x3fbeb7[_0x18c5('0x39')];for(var _0x1b5065=0x0;_0x1b5065<_0x3fbeb7[_0x18c5('0x3a')][_0x18c5('0x16')];_0x1b5065++){var _0x5caeed=_0x3fbeb7[_0x18c5('0x3a')][_0x1b5065];var _0x50ba32='i';var _0x389f73=_[_0x18c5('0x3b')](_0x3a3fa3,['name',_0x5caeed['field']]);if(_0x389f73){var _0x54f17e=as[_0x18c5('0x3c')](_0x50ba32,_0x389f73['type'],_0x5caeed);_0x5f1328[_0x18c5('0x3d')][_0x49499e](_0x54f17e['text'],_0x54f17e[_0x18c5('0x3e')][_0x18c5('0x3f')],_0x54f17e[_0x18c5('0x3e')]['end']);}else{switch(_0x5caeed['field']){case _0x18c5('0x40'):var _0x119628=parseReadParameter(_0x5caeed['value']);_0x5f1328[_0x18c5('0x41')][_0x18c5('0x42')](_0x119628);break;case _0x18c5('0x43'):if(_0x5caeed[_0x18c5('0x44')]===_0x18c5('0x45')){if(_0x5caeed['value']['split']('\x20')[_0x18c5('0x16')]>0x1){_0x5f1328['contact'][_0x49499e](_0x18c5('0x37'),qs['getFullTextValue'](_0x5caeed[_0x18c5('0x3e')],!![]),null);}else{var _0x10f6d6='%'+_0x5caeed[_0x18c5('0x3e')]+'%';_0x5f1328['contact'][_0x49499e](_0x18c5('0x46'),_0x10f6d6,_0x10f6d6,_0x10f6d6);}}else{_0x389f73=_[_0x18c5('0x3b')](_0x3a3fa3,[_0x18c5('0xc'),'ContactId']);_0x5caeed['field']='ContactId';_0x54f17e=as[_0x18c5('0x3c')](_0x50ba32,_0x389f73[_0x18c5('0x47')],_0x5caeed);_0x5f1328['contact'][_0x49499e](_0x54f17e['text'],_0x54f17e[_0x18c5('0x3e')][_0x18c5('0x3f')],_0x54f17e[_0x18c5('0x3e')]['end']);}break;case _0x18c5('0x48'):var _0x5e4fa2=_0x5caeed[_0x18c5('0x3e')][_0x18c5('0x49')](',')[_0x18c5('0x18')](function(_0x404972){return Number(_0x404972);});var _0x4abf85=parseTagParameter(_0x5e4fa2);_0x5f1328[_0x18c5('0x4a')]['clause']['and'](_0x4abf85);_0x5f1328[_0x18c5('0x4a')][_0x18c5('0x4b')]=_0x5e4fa2;break;case'User':if(_0x5caeed[_0x18c5('0x44')]===_0x18c5('0x45')){_0x5f1328[_0x18c5('0x4c')][_0x49499e](_0x18c5('0x4d'),'%'+_0x5caeed['value']+'%',null);}else{_0x389f73=_['find'](_0x3a3fa3,['name',_0x18c5('0x4e')]);_0x5caeed[_0x18c5('0xb')]=_0x18c5('0x4e');_0x54f17e=as[_0x18c5('0x3c')](_0x50ba32,_0x389f73[_0x18c5('0x47')],_0x5caeed);_0x5f1328['user'][_0x49499e](_0x54f17e[_0x18c5('0x4f')],_0x54f17e[_0x18c5('0x3e')]['start'],_0x54f17e[_0x18c5('0x3e')]['end']);}break;case'body':case _0x18c5('0x50'):_0x54f17e=as[_0x18c5('0x3c')]('me',null,_0x5caeed);_0x5f1328[_0x18c5('0x51')][_0x49499e](_0x54f17e[_0x18c5('0x4f')],_0x54f17e['value'][_0x18c5('0x3f')],_0x54f17e[_0x18c5('0x3e')][_0x18c5('0x52')]);break;}}}return _0x5f1328;}function parseModelFields(_0x2ed949,_0x5970b9,_0x1d95ea){var _0x5ee57e=utils[_0x18c5('0x7')](_0x2ed949);var _0x4edbc3=squel[_0x18c5('0x22')]();var _0x34f472=_(_0x5970b9)[_0x18c5('0x53')]()[_0x18c5('0x18')](function(_0x22a676){return _[_0x18c5('0x54')](_0x1d95ea,['name',_0x22a676])?_0x22a676:undefined;})['compact']()[_0x18c5('0x3e')]();if(_0x34f472['length']>0x0){_0x34f472[_0x18c5('0x24')](function(_0x40f440){if(_0x40f440===_0x5ee57e){_0x4edbc3[_0x18c5('0x42')]('i.'+_0x5ee57e+_0x18c5('0x55'),[][_0x18c5('0x56')](_0x5970b9[_0x40f440]));}else if(_0x40f440===_0x18c5('0x57')){var _0x28e4b6=JSON[_0x18c5('0x58')](_0x5970b9[_0x40f440])['$gte'];var _0x2be368=JSON['parse'](_0x5970b9[_0x40f440])[_0x18c5('0x59')];_0x4edbc3[_0x18c5('0x42')](_0x18c5('0x5a'),_0x28e4b6,_0x2be368);}else{if(_0x5970b9[_0x40f440]===_0x18c5('0x5b')){_0x4edbc3[_0x18c5('0x42')]('i.'+_0x40f440+_0x18c5('0x5c'));}else{_0x4edbc3['and']('i.'+_0x40f440+_0x18c5('0x5d'),_0x5970b9[_0x40f440]);}}});}return _0x4edbc3;}function parseQueryParameters(_0x1b770c,_0x325f85,_0xe0b98){var _0x560cf8=getSqlClauses();return Promise['resolve']()['then'](function(){return parseModelFields(_0x1b770c,_0x325f85,_0xe0b98);})['then'](function(_0x484828){_0x560cf8[_0x18c5('0x5e')]['and'](_0x484828);return parseReadParameter(_0x325f85['read']);})['then'](function(_0x4f9e3b){_0x560cf8[_0x18c5('0x41')][_0x18c5('0x42')](_0x4f9e3b);return parseTagParameter(_0x325f85[_0x18c5('0x5f')]);})[_0x18c5('0x60')](function(_0x4eb814){_0x560cf8[_0x18c5('0x4a')]['clause']['and'](_0x4eb814);return parseSearchFilter(_0x1b770c,_0x325f85['filter']);})[_0x18c5('0x60')](function(_0x3ab37f){_0x560cf8[_0x18c5('0x61')]=_0x3ab37f;return _0x560cf8;});}function checkAccountsRestrictions(_0x517eae,_0x5d21de,_0x50c39a){var _0x3d6254=utils['getAccountFK'](_0x517eae);var _0x1798ab=_0x18c5('0x62')+_[_0x18c5('0x63')](_0x517eae)+(_0x517eae===_0x18c5('0x64')?_0x18c5('0x65'):_0x18c5('0x66'));var _0x28a980=squel[_0x18c5('0x22')]();return Promise['resolve']()[_0x18c5('0x60')](function(){if(_0x50c39a['search']&&_0x5d21de['role']==='agent'){return _0x5d21de[_0x1798ab]({'attributes':['id'],'raw':!![]});}})[_0x18c5('0x60')](function(_0x3c910a){if(_0x3c910a){if(_0x3c910a['length']===0x0){_0x28a980[_0x18c5('0x42')]('i.'+_0x3d6254+_0x18c5('0x5c'));}else{_0x28a980['and']('i.'+_0x3d6254+_0x18c5('0x55'),_[_0x18c5('0x18')](_0x3c910a,'id'));}}else if(!_0x50c39a[_0x3d6254]){_0x28a980[_0x18c5('0x42')]('i.'+_0x3d6254+_0x18c5('0x67'));}})[_0x18c5('0x60')](function(){return _0x28a980;});}function getClosedOrderClause(_0x8b3330,_0x4585f2){var _0x1d6744='';var _0x4f5e5e=[_0x18c5('0x68'),_0x18c5('0x69'),_0x18c5('0x6a')];if(_0x8b3330===_0x18c5('0x30')){_0x4f5e5e['unshift']('i.substatus');}if(_0x4585f2[_0x18c5('0x6b')]==='0'&&_0x8b3330===_0x18c5('0x30')){_0x1d6744=_0x18c5('0x6c');}else{if(_0x4585f2[_0x18c5('0x6b')]==='1'){_0x4f5e5e[_0x18c5('0x6d')]();}_0x1d6744='CONCAT_WS(\x27\x27,\x20'+_0x4f5e5e[_0x18c5('0x6e')](',\x20')+')';}return _0x1d6744;}function getFilteredInteractions(_0x225d4f,_0x3408ab,_0x4eb72b,_0x330fcc){var _0x179a95=utils[_0x18c5('0x19')](_0x225d4f);var _0x2b4e72=_['capitalize'](_0x225d4f)+_0x18c5('0x6f');var _0x53e693=[];var _0x319e3f=getTagsQuery();var _0x104507={'type':db[_0x18c5('0x70')][_0x18c5('0x71')]['SELECT'],'raw':!![]};var _0xb9dd87=[];var _0x2eb9ad=[];return db[_0x18c5('0x72')][_0x18c5('0x73')](_0x319e3f[_0x18c5('0x74')](),_0x104507)[_0x18c5('0x60')](function(_0x4ca178){_0x53e693=_[_0x18c5('0x75')](_0x4ca178,'id');_0x104507=_[_0x18c5('0x76')](_0x104507,{'model':db[_0x2b4e72],'mapToModel':!![],'nest':!![]});if(_0x4eb72b[_0x18c5('0x5e')]){_0x330fcc[_0x18c5('0x77')]['forEach'](function(_0x380e18){_0x3408ab[_0x18c5('0xb')]('i.'+_0x380e18);});}else{_0x3408ab[_0x18c5('0xb')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages');_0x3408ab[_0x18c5('0xb')]('a.key',_0x18c5('0x78'));_0x3408ab[_0x18c5('0xb')]('a.mandatoryDisposition',_0x18c5('0x79'));if(_0x225d4f===_0x18c5('0x30')){_0x3408ab[_0x18c5('0xb')](_0x18c5('0x7a'),_0x18c5('0x7b'));_0x3408ab['field'](_0x18c5('0x7c'),_0x18c5('0x7d'));_0x3408ab[_0x18c5('0xb')]('i.id');_0x3408ab[_0x18c5('0xb')](_0x18c5('0x7e'));_0x3408ab['field']('i.updatedAt');_0x3408ab[_0x18c5('0xb')]('i.closed');_0x3408ab[_0x18c5('0xb')]('i.closedAt');_0x3408ab[_0x18c5('0xb')](_0x18c5('0x7f'));_0x3408ab['field'](_0x18c5('0x80'));_0x3408ab[_0x18c5('0xb')]('i.lastMsgDirection');_0x3408ab[_0x18c5('0xb')](_0x18c5('0x81'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x6a'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x69'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x68'));_0x3408ab['field'](_0x18c5('0x6c'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x82'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x83'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x84'));_0x3408ab['field']('i.UserId');}else if(_0x225d4f===_0x18c5('0x2e')){_0x3408ab[_0x18c5('0xb')](_0x18c5('0x85'),_0x18c5('0x7d'));}else{_0x3408ab[_0x18c5('0xb')]('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',_0x18c5('0x7d'));}if(_0x225d4f!==_0x18c5('0x30')){_0x3408ab[_0x18c5('0xb')](_0x18c5('0x86'));}_0x3408ab[_0x18c5('0xb')](_0x18c5('0x87'),_0x18c5('0x88'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x89'),_0x18c5('0x8a'));_0x3408ab['field'](_0x18c5('0x8b'),_0x18c5('0x8c'));_0x3408ab[_0x18c5('0xb')]('c.phone',_0x18c5('0x8d'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x8e'),_0x18c5('0x8f'));_0x3408ab['field']('c.fax',_0x18c5('0x90'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x91'),'Owner.fullname');_0x3408ab[_0x18c5('0xb')](_0x18c5('0x92'),_0x18c5('0x93'));_0x3408ab[_0x18c5('0xb')](_0x18c5('0x94'),_0x18c5('0x95'));}if(_0x330fcc[_0x18c5('0x96')]){_0x3408ab['limit'](_0x330fcc['limit']);}if(_0x330fcc[_0x18c5('0x97')]){_0x3408ab['offset'](_0x330fcc[_0x18c5('0x97')]);}return db[_0x18c5('0x72')][_0x18c5('0x73')](_0x3408ab['toString'](),_0x104507);})[_0x18c5('0x60')](function(_0x3929cb){_0xb9dd87=_0x3929cb;var _0x14f027=getUsersQuery(_0x225d4f,_0xb9dd87);return db[_0x18c5('0x72')][_0x18c5('0x73')](_0x14f027[_0x18c5('0x74')](),_0x104507);})[_0x18c5('0x60')](function(_0xb9a41a){_0x2eb9ad=_[_0x18c5('0x98')](_0xb9a41a,_0x179a95);if(_0x225d4f===_0x18c5('0x30')){return db[_0x18c5('0x99')][_0x18c5('0x9a')]({'attributes':[_0x18c5('0x9b')],'raw':!![]});}})[_0x18c5('0x60')](function(_0x420abc){var _0x455aa6=_0x420abc?_0x420abc[_0x18c5('0x9b')]:undefined;var _0x630a0e=_0xb9dd87[_0x18c5('0x18')](function(_0x2de2e6){return updateInteraction(_0x2de2e6,_0x53e693,_0x2eb9ad,_0x455aa6);});return Promise['all'](_0x630a0e);});}function countFilteredInteractions(_0x28d82e,_0x3fd147){var _0x3ccf75=_0x28d82e[_0x18c5('0x9c')]();_0x3ccf75[_0x18c5('0xb')](_0x18c5('0x9d'));_0x3ccf75['field'](_0x18c5('0x9e'),_0x18c5('0x40'));var _0x11a8a0=utils[_0x18c5('0x23')](_0x3fd147);if(!_['isEmpty'](_0x11a8a0)){_0x3ccf75['where'](_0x18c5('0x9f'),_0x11a8a0);}var _0x4432cf={'type':db['Sequelize'][_0x18c5('0x71')][_0x18c5('0xa0')],'raw':!![]};return db[_0x18c5('0x72')][_0x18c5('0x73')](_0x3ccf75['toString'](),_0x4432cf);}module[_0x18c5('0xa1')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};