a8cf09b9c917e47ea5b298101b1b621cb396d54a
[motion2.git] / server / api / userProfile / userProfile.model.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 _0x3785=['query','isEmpty','length','push','UserProfileSection','find','params','all','ignore','union','autoAssociation','model','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','pick','where','key','VIRTUAL','foreignKey','forEach','merge','options','includeAll','reportType','default','reportId','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','extraQueryConditions','color','tag','ThroughTags','chat','dataValues','sms','fax','openchannel','lodash','./userProfile.attributes','filter','field','value','findAll','then','associatedResources','map','name','catch','resolve','UserProfileResource','AnalyticExtractedReport','type','resourceId','toLowerCase','squareprojects','childModel','odbc','squarerecordings','SquareRecording','projectName','projects','contacts','CmContact','parentSections','ListId','lists','companies','CmCompany','CmCustomField','chatqueues','ChatQueue','chatwebsites','ChatWebsite','outboundroutes','contexts','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','User','role','Telephones','membername','telephone','VoiceQueues','queue','VoiceQueue','QueueCampaigns','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','mailaccounts','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','OpenchannelAccount','smsqueues','SmsQueue','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','teams','Team','voicequeues','queuecampaigns','users','agents','admin','user','Agents','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','ZohoAccount','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','pauses','Pause','scheduler','Schedule','sounds','Tag','templates','Template','triggers','trunks','Trunk','variables','Plugin','extractedreports','metrics','AnalyticMetric','charAt','toUpperCase','slice','Sequelize','QueryTypes','SELECT','ui.','InteractionId','from','user_has_','_interactions','ui.UserId\x20=\x20?','sequelize','OpenTabs','define','user_profiles','../../components/parsers/qs'];(function(_0x3bd430,_0x52dc94){var _0x45a902=function(_0x3bd504){while(--_0x3bd504){_0x3bd430['push'](_0x3bd430['shift']());}};_0x45a902(++_0x52dc94);}(_0x3785,0xeb));var _0x5378=function(_0x4de586,_0x183427){_0x4de586=_0x4de586-0x0;var _0x46baf5=_0x3785[_0x4de586];return _0x46baf5;};'use strict';var _=require(_0x5378('0x0'));var attributes=require(_0x5378('0x1'));var squel=require('squel');module['exports']=function(_0xd53d5e){var _0x2a797a=_0xd53d5e['models'];function _0x1e52ca(_0x2ff199,_0x51c67b){return new Promise(function(_0x4a80c0,_0x263d70){if(!_0x51c67b)return _0x4a80c0(null);var _0x489ce7=_0x51c67b[_0x5378('0x2')]?{[_0x51c67b['filter'][_0x5378('0x3')]]:_0x51c67b[_0x5378('0x2')][_0x5378('0x4')]}:undefined;return _0x2a797a[_0x2ff199][_0x5378('0x5')]({'where':_0x489ce7,'raw':!![]})[_0x5378('0x6')](function(_0x4aebae){_0x51c67b[_0x5378('0x7')]=_[_0x5378('0x8')](_0x4aebae,'id');_0x4a80c0(_0x51c67b);})['catch'](function(_0x300577){_0x263d70(_0x300577);});});}function _0x31057a(_0xc0829b,_0x5178e0){return new Promise(function(_0xd05da0,_0x382ca6){var _0x34b333=_0xc0829b[_0x5378('0x2')]?{[_0xc0829b['filter'][_0x5378('0x3')]]:_0xc0829b['filter']['value']}:undefined;return _0x2a797a[_0xc0829b['model']][_0x5378('0x5')]({'where':_0x34b333,'raw':!![]})[_0x5378('0x6')](function(_0x20f0ae){_0x5178e0[_0x5378('0x7')]=_[_0x5378('0x8')](_0x20f0ae,function(_0x17cec2){return _0x17cec2[_0x5378('0x9')];});_0xd05da0(_0x5178e0);})[_0x5378('0xa')](function(_0xbb2c2f){_0x382ca6(_0xbb2c2f);});});}function _0x30d636(_0x5b3a9c,_0x1af71b,_0x5772a2){if(!_0x1af71b)return Promise[_0x5378('0xb')](null);return new Promise(function(_0x1b9636,_0x506f0d){return _0x2a797a[_0x5378('0xc')][_0x5378('0x5')]({'where':{'sectionId':_0x1af71b['id']},'raw':!![]})[_0x5378('0x6')](function(_0x2f0853){if(_0x5b3a9c[_0x5378('0x3')]&&_0x5b3a9c[_0x5378('0x3')]!=='id'){_0x1af71b[_0x5378('0x7')]=_[_0x5378('0x8')](_0x2f0853,function(_0x2dbb2c){return _0x2dbb2c[_0x5b3a9c[_0x5378('0x3')]];});}else{if(_0x5772a2===_0x5378('0xd')){_0x1af71b[_0x5378('0x7')]=_[_0x5378('0x8')](_0x2f0853,function(_0x14869d){return{'id':_0x14869d['resourceId'],'type':_0x14869d[_0x5378('0xe')]};});}else{_0x1af71b['associatedResources']=_[_0x5378('0x8')](_0x2f0853,function(_0x1c537d){return _0x1c537d[_0x5378('0xf')];});}}_0x1b9636(_0x1af71b);})[_0x5378('0xa')](function(_0x2fcb11){_0x506f0d(_0x2fcb11);});});}function _0x119e44(_0x5813c9,_0x32901e){var _0x57720c={'parentSections':[]};switch(_0x5813c9[_0x5378('0x10')]()){case _0x5378('0x11'):_0x57720c[_0x5378('0x12')]='SquareProject';break;case _0x5378('0x13'):_0x57720c[_0x5378('0x12')]='SquareOdbc';break;case _0x5378('0x14'):_0x57720c[_0x5378('0x12')]=_0x5378('0x15');_0x57720c['parentSections']=[{'name':'SquareProjects','field':_0x5378('0x9'),'foreignKey':_0x5378('0x16')}];break;case _0x5378('0x17'):_0x57720c[_0x5378('0x12')]='JscriptyProject';break;case _0x5378('0x18'):_0x57720c[_0x5378('0x12')]=_0x5378('0x19');_0x57720c[_0x5378('0x1a')]=[{'name':'Lists','field':'id','foreignKey':_0x5378('0x1b')}];break;case _0x5378('0x1c'):_0x57720c[_0x5378('0x12')]='CmList';break;case _0x5378('0x1d'):_0x57720c['childModel']=_0x5378('0x1e');break;case'globalcustomfields':_0x57720c[_0x5378('0x12')]=_0x5378('0x1f');break;case _0x5378('0x20'):_0x57720c[_0x5378('0x12')]=_0x5378('0x21');break;case _0x5378('0x22'):_0x57720c[_0x5378('0x12')]=_0x5378('0x23');break;case'faxqueues':_0x57720c['childModel']='FaxQueue';break;case'faxaccounts':_0x57720c['childModel']='FaxAccount';break;case'inboundroutes':case'internalroutes':case _0x5378('0x24'):_0x57720c[_0x5378('0x12')]='VoiceExtension';break;case _0x5378('0x25'):_0x57720c[_0x5378('0x12')]=_0x5378('0x26');break;case _0x5378('0x27'):_0x57720c['childModel']=_0x5378('0x28');break;case _0x5378('0x29'):_0x57720c['childModel']=_0x5378('0x2a');_0x57720c[_0x5378('0x1a')]=[{'name':'Agents','field':_0x5378('0x9'),'foreignKey':'membername','model':_0x5378('0x2b'),'filter':{'field':_0x5378('0x2c'),'value':['agent']}},{'name':_0x5378('0x2d'),'field':_0x5378('0x9'),'foreignKey':_0x5378('0x2e'),'model':_0x5378('0x2b'),'filter':{'field':_0x5378('0x2c'),'value':[_0x5378('0x2f')]}},{'name':_0x5378('0x30'),'field':_0x5378('0x9'),'foreignKey':_0x5378('0x31'),'model':_0x5378('0x32'),'filter':{'field':_0x5378('0xe'),'value':['inbound']}},{'name':_0x5378('0x33'),'field':_0x5378('0x9'),'foreignKey':_0x5378('0x31'),'model':_0x5378('0x32'),'filter':{'field':_0x5378('0xe'),'value':['outbound']}}];break;case'musiconholds':_0x57720c[_0x5378('0x12')]=_0x5378('0x34');break;case _0x5378('0x35'):_0x57720c['childModel']=_0x5378('0x36');break;case _0x5378('0x37'):_0x57720c[_0x5378('0x12')]=_0x5378('0x38');break;case _0x5378('0x39'):_0x57720c[_0x5378('0x12')]=_0x5378('0x3a');break;case _0x5378('0x3b'):_0x57720c[_0x5378('0x12')]=_0x5378('0x3c');break;case _0x5378('0x3d'):_0x57720c['childModel']='MailAccount';break;case _0x5378('0x3e'):_0x57720c[_0x5378('0x12')]=_0x5378('0x3f');break;case _0x5378('0x40'):_0x57720c[_0x5378('0x12')]=_0x5378('0x41');break;case'openchannelaccounts':_0x57720c[_0x5378('0x12')]=_0x5378('0x42');break;case _0x5378('0x43'):_0x57720c[_0x5378('0x12')]=_0x5378('0x44');break;case'smsaccounts':_0x57720c[_0x5378('0x12')]=_0x5378('0x45');break;case _0x5378('0x46'):_0x57720c['childModel']=_0x5378('0x47');break;case _0x5378('0x48'):_0x57720c[_0x5378('0x12')]='WhatsappAccount';break;case _0x5378('0x49'):_0x57720c[_0x5378('0x12')]=_0x5378('0x4a');break;case _0x5378('0x4b'):case _0x5378('0x4c'):_0x57720c['childModel']='VoiceQueue';if(_0x32901e){_0x57720c['parentSections']=[{'name':_0x5378('0x30')},{'name':'QueueCampaigns'}];}break;case _0x5378('0x4d'):case _0x5378('0x4e'):case'telephones':_0x57720c[_0x5378('0x12')]=_0x5378('0x2b');if(_0x32901e){_0x57720c[_0x5378('0x1a')]=[{'name':'Users','filter':{'field':_0x5378('0x2c'),'value':[_0x5378('0x4f'),_0x5378('0x50')]},'ignore':!![]},{'name':_0x5378('0x51')},{'name':_0x5378('0x2d')}];}break;case _0x5378('0x52'):_0x57720c['childModel']=_0x5378('0x53');break;case _0x5378('0x54'):_0x57720c['childModel']=_0x5378('0x55');break;case'freshdeskaccounts':_0x57720c['childModel']=_0x5378('0x56');break;case _0x5378('0x57'):_0x57720c[_0x5378('0x12')]=_0x5378('0x58');break;case _0x5378('0x59'):_0x57720c[_0x5378('0x12')]=_0x5378('0x5a');break;case'zohoaccounts':_0x57720c[_0x5378('0x12')]=_0x5378('0x5b');break;case'vtigeraccounts':_0x57720c[_0x5378('0x12')]='User';break;case _0x5378('0x5c'):_0x57720c[_0x5378('0x12')]=_0x5378('0x5d');break;case _0x5378('0x5e'):_0x57720c['childModel']=_0x5378('0x5f');break;case _0x5378('0x60'):_0x57720c[_0x5378('0x12')]=_0x5378('0x61');break;case'intervals':_0x57720c[_0x5378('0x12')]='Interval';break;case _0x5378('0x62'):_0x57720c['childModel']=_0x5378('0x63');break;case _0x5378('0x64'):_0x57720c[_0x5378('0x12')]=_0x5378('0x65');break;case _0x5378('0x66'):_0x57720c[_0x5378('0x12')]='Sound';break;case'tags':_0x57720c[_0x5378('0x12')]=_0x5378('0x67');break;case _0x5378('0x68'):_0x57720c[_0x5378('0x12')]=_0x5378('0x69');break;case _0x5378('0x6a'):_0x57720c[_0x5378('0x12')]='Trigger';break;case _0x5378('0x6b'):_0x57720c[_0x5378('0x12')]=_0x5378('0x6c');break;case _0x5378('0x6d'):_0x57720c['childModel']='Variable';break;case'plugins':_0x57720c[_0x5378('0x12')]=_0x5378('0x6e');break;case _0x5378('0x6f'):_0x57720c[_0x5378('0x12')]=_0x5378('0xd');_0x57720c['parentSections']=[{'name':'Reports','field':'id','foreignKey':'reportId'}];break;case _0x5378('0x70'):_0x57720c[_0x5378('0x12')]=_0x5378('0x71');break;}return _0x57720c;}function _0x1c771a(_0xe610c5,_0xa1d064){var _0x3d68a3=_0xe610c5[_0x5378('0x72')](0x0)[_0x5378('0x73')]()+_0xe610c5[_0x5378('0x74')](0x1);var _0x2122c8={'type':_0x2a797a[_0x5378('0x75')][_0x5378('0x76')][_0x5378('0x77')],'raw':!![]};return new Promise(function(_0x5e219c,_0x2b07ce){var _0xf79b19=squel['select']()['field'](_0x5378('0x78')+_0x3d68a3+_0x5378('0x79'),'id')[_0x5378('0x3')]('ui.createdAt')[_0x5378('0x7a')](_0x5378('0x7b')+_0xe610c5+_0x5378('0x7c'),'ui')['where'](_0x5378('0x7d'),_0xa1d064['id']);return _0x2a797a[_0x5378('0x7e')]['query'](_0xf79b19['toString'](),_0x2122c8)['then'](function(_0x409e92){_0xa1d064[_0x3d68a3+_0x5378('0x7f')]=_0x409e92;_0x5e219c(_0x409e92);})[_0x5378('0xa')](function(_0x15a885){_0x2b07ce(_0x15a885);});});}return _0xd53d5e[_0x5378('0x80')]('UserProfile',attributes,{'tableName':_0x5378('0x81'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x214b18){var _0x44a5bb=require(_0x5378('0x82'));var _0x74dbd1={'raw':_0x214b18[_0x5378('0x83')]['raw'],'where':{}};var _0x336023={};var _0x36342f={'count':0x0,'rows':[]};var _0x506c9e=_0x214b18[_0x5378('0x83')]['section'];var _0x246f38=_0x214b18[_0x5378('0x83')]['mergeResources']||![];var _0x40e5f9=_0x119e44(_0x506c9e,_0x246f38);if(!_0x40e5f9[_0x5378('0x12')])throw new Error('Invalid\x20section\x20\x27'+_0x506c9e+'\x27');var _0x4cdca1=[{'name':_0x506c9e}];if(!_[_0x5378('0x84')](_0x40e5f9[_0x5378('0x1a')]))_0x4cdca1=_0x40e5f9[_0x5378('0x1a')];var _0x3424cc=[];for(var _0x51d9b7=0x0;_0x51d9b7<_0x4cdca1[_0x5378('0x85')];_0x51d9b7++){_0x3424cc[_0x5378('0x86')](_0x2a797a[_0x5378('0x87')][_0x5378('0x88')]({'where':{'userProfileId':_0x214b18[_0x5378('0x89')]['id'],'name':_0x4cdca1[_0x51d9b7][_0x5378('0x9')]},'raw':!![]}));}return Promise[_0x5378('0x8a')](_0x3424cc)[_0x5378('0x6')](function(_0x2404fb){var _0x46ccbf=_[_0x5378('0x2')](_0x2404fb,function(_0x2dd6b3){return _0x2dd6b3?_0x2dd6b3:undefined;});var _0x208047=_[_0x5378('0x2')](_0x4cdca1,[_0x5378('0x8b'),!![]]);var _0x1ff864=_[_0x5378('0x84')](_0x46ccbf)&&_[_0x5378('0x84')](_0x208047)?null:_[_0x5378('0x8c')](_0x208047,_0x46ccbf);if(!_0x1ff864)return null;var _0x1c7d56=[];for(var _0x17f722=0x0;_0x17f722<_0x1ff864['length'];_0x17f722++){var _0x492116=_[_0x5378('0x88')](_0x4cdca1,function(_0x2945e7){return _0x1ff864[_0x17f722]?_0x2945e7[_0x5378('0x9')]===_0x1ff864[_0x17f722][_0x5378('0x9')]:null;});if(_0x492116){if(_0x1ff864[_0x17f722]['ignore']){_0x1c7d56[_0x5378('0x86')](_0x1e52ca(_0x40e5f9[_0x5378('0x12')],_0x1ff864[_0x17f722]));}else{if(!_0x1ff864[_0x17f722][_0x5378('0x8d')]){_0x1c7d56[_0x5378('0x86')](_0x30d636(_0x492116,_0x1ff864[_0x17f722],_0x40e5f9[_0x5378('0x12')]));}else{if(_0x492116[_0x5378('0x8e')]){_0x1c7d56['push'](_0x31057a(_0x492116,_0x1ff864[_0x17f722]));}}}}}return Promise[_0x5378('0x8a')](_0x1c7d56);})[_0x5378('0x6')](function(_0x4933cb){var _0x8a56b=_0x4933cb;var _0x3bbc98=null;if(_0x8a56b){_0x3bbc98=_0x8a56b[_0x5378('0x85')]===0x1?_0x8a56b[0x0]:null;}if(!_0x3bbc98&&!_0x8a56b)return _0x36342f;var _0x4850eb=_0x2a797a[_0x40e5f9[_0x5378('0x12')]][_0x5378('0x8f')];_0x336023[_0x5378('0x8e')]=_[_0x5378('0x90')](_0x4850eb);_0x336023[_0x5378('0x83')]=_[_0x5378('0x90')](_0x214b18[_0x5378('0x83')]);_0x336023[_0x5378('0x91')]=_[_0x5378('0x92')](_0x336023[_0x5378('0x8e')],_0x336023[_0x5378('0x83')]);_0x74dbd1[_0x5378('0x93')]=_['intersection'](_0x336023[_0x5378('0x8e')],_0x44a5bb[_0x5378('0x94')](_0x214b18[_0x5378('0x83')][_0x5378('0x94')]));_0x74dbd1[_0x5378('0x93')]=_0x74dbd1['attributes'][_0x5378('0x85')]?_0x74dbd1[_0x5378('0x93')]:_0x336023[_0x5378('0x8e')];if(!_0x214b18[_0x5378('0x83')][_0x5378('0x95')](_0x5378('0x96'))){_0x74dbd1[_0x5378('0x97')]=_0x44a5bb[_0x5378('0x97')](_0x214b18[_0x5378('0x83')][_0x5378('0x97')]);_0x74dbd1[_0x5378('0x98')]=_0x44a5bb[_0x5378('0x98')](_0x214b18[_0x5378('0x83')]['offset']);}_0x74dbd1[_0x5378('0x99')]=_0x44a5bb[_0x5378('0x9a')](_0x214b18[_0x5378('0x83')]['sort']);_0x74dbd1['where']=_0x44a5bb['filters'](_[_0x5378('0x9b')](_0x214b18[_0x5378('0x83')],_0x336023[_0x5378('0x91')]));if(_0x214b18['query'][_0x5378('0x2')]){_0x74dbd1[_0x5378('0x9c')]=_['merge'](_0x74dbd1[_0x5378('0x9c')],{'$or':_[_0x5378('0x8')](_0x4850eb,function(_0x1c350a){if(_0x1c350a[_0x5378('0xe')][_0x5378('0x9d')]!==_0x5378('0x9e')){var _0x4218af={};_0x4218af[_0x1c350a[_0x5378('0x3')]]={'$like':'%'+_0x214b18[_0x5378('0x83')][_0x5378('0x2')]+'%'};return _0x4218af;}})});}var _0x4450a2=[];var _0x252307=null;var _0x1aac54={};if(_0x3bbc98){_0x252307=_[_0x5378('0x88')](_0x4cdca1,['name',_0x3bbc98[_0x5378('0x9')]]);if(_0x252307[_0x5378('0x3')]){_0x1aac54={};if(_0x40e5f9[_0x5378('0x12')]==='AnalyticExtractedReport'){_0x1aac54[_0x252307['foreignKey']]=_[_0x5378('0x8')](_0x3bbc98['associatedResources'],'id');}else{_0x1aac54[_0x252307[_0x5378('0x9f')]]=_0x3bbc98['associatedResources'];}_0x4450a2[_0x5378('0x86')](_0x1aac54);}else{_0x74dbd1['where']['id']=_0x3bbc98[_0x5378('0x7')];}}else{for(var _0xc6f4ff=0x0;_0xc6f4ff<_0x8a56b[_0x5378('0x85')];_0xc6f4ff++){_0x252307=_[_0x5378('0x88')](_0x4cdca1,[_0x5378('0x9'),_0x8a56b[_0xc6f4ff][_0x5378('0x9')]]);if(_0x252307[_0x5378('0x3')]){_0x1aac54={};_0x1aac54[_0x252307[_0x5378('0x9f')]]=_0x8a56b[_0xc6f4ff][_0x5378('0x7')];_0x4450a2[_0x5378('0x86')](_0x1aac54);}else{if(!_0x74dbd1[_0x5378('0x9c')]['id'])_0x74dbd1[_0x5378('0x9c')]['id']=[];_0x8a56b[_0xc6f4ff]['associatedResources'][_0x5378('0xa0')](function(_0x4a2311){_0x74dbd1[_0x5378('0x9c')]['id'][_0x5378('0x86')](_0x4a2311);});}}}if(!_['isEmpty'](_0x4450a2)){_0x74dbd1['where']=_[_0x5378('0xa1')](_0x74dbd1[_0x5378('0x9c')],{'$and':{'$or':_0x4450a2}});}_0x74dbd1=_[_0x5378('0xa1')]({},_0x74dbd1,_0x214b18[_0x5378('0xa2')]);if(_0x3bbc98&&!_0x3bbc98[_0x5378('0x8d')]&&_0x40e5f9['childModel']===_0x5378('0xd')){if(_0x214b18['query'][_0x5378('0xa3')]){_0x74dbd1['include']=[{'all':!![]}];}return _0x2a797a[_0x40e5f9['childModel']][_0x5378('0x5')](_0x74dbd1)[_0x5378('0x6')](function(_0x182921){var _0x5badc3=[];_0x182921['forEach'](function(_0x503126){var _0x3caad0;switch(_0x503126[_0x5378('0xa4')]){case _0x5378('0xa5'):_0x3caad0=_[_0x5378('0x88')](_0x3bbc98[_0x5378('0x7')],function(_0x2dff63){return _0x2dff63['id']===_0x503126[_0x5378('0xa6')]&&_0x2dff63['type']===_0x5378('0xa7');});break;case _0x5378('0xa8'):_0x3caad0=_['find'](_0x3bbc98[_0x5378('0x7')],function(_0x1383df){return _0x1383df['id']===_0x503126[_0x5378('0xa6')]&&_0x1383df['type']===_0x5378('0xa9');});break;}if(_0x3caad0)_0x5badc3[_0x5378('0x86')](_0x503126);});_0x36342f[_0x5378('0xaa')]=_0x5badc3[_0x5378('0x85')];_0x36342f[_0x5378('0xab')]=_0x5badc3;return _0x36342f;});}else{if(!_[_0x5378('0x84')](_0x214b18['query'][_0x5378('0xac')])){_0x74dbd1['where']['id']=_0x74dbd1[_0x5378('0x9c')]['id']?_[_0x5378('0x92')](_0x74dbd1['where']['id'],_0x214b18[_0x5378('0x83')][_0x5378('0xac')]):_0x214b18[_0x5378('0x83')][_0x5378('0xac')];if(_0x214b18[_0x5378('0x83')][_0x5378('0xad')]){_0x74dbd1[_0x5378('0x99')]=_0x214b18['query'][_0x5378('0xad')];}}if(_0x214b18[_0x5378('0x83')][_0x5378('0xae')]){_0x74dbd1[_0x5378('0x9c')]=_['merge'](_0x74dbd1[_0x5378('0x9c')],{'$and':_0x214b18[_0x5378('0x83')][_0x5378('0xae')]});}return _0x2a797a[_0x40e5f9[_0x5378('0x12')]][_0x5378('0xaa')]({'where':_0x74dbd1['where']})[_0x5378('0x6')](function(_0x2c84fd){_0x36342f[_0x5378('0xaa')]=_0x2c84fd;if(_0x214b18[_0x5378('0x83')]['includeAll']){if(_0x40e5f9['childModel']==='CmContact'){_0x74dbd1['include']=[{'model':_0x2a797a['Tag'],'as':'Tags','attributes':['id',_0x5378('0x9'),_0x5378('0xaf')],'required':_0x214b18[_0x5378('0x83')][_0x5378('0xb0')]?!![]:![]},{'model':_0x2a797a['Tag'],'as':_0x5378('0xb1'),'attributes':['id',_0x5378('0x9'),_0x5378('0xaf')],'through':_0x214b18['query'][_0x5378('0xb0')]?{'attributes':[],'where':{'TagId':_0x214b18['query'][_0x5378('0xb0')]||undefined}}:{},'required':_0x214b18['query'][_0x5378('0xb0')]?!![]:![]}];}else{_0x74dbd1['include']=[{'all':!![]}];}}return _0x2a797a[_0x40e5f9['childModel']][_0x5378('0x5')](_0x74dbd1);})[_0x5378('0x6')](function(_0x17bde0){_0x36342f[_0x5378('0xab')]=_0x17bde0;if(_0x506c9e==='Agents'&&_0x214b18[_0x5378('0x83')]['openTabs']==='true'){var _0x379080=[];for(var _0x48bb22=0x0;_0x48bb22<_0x36342f[_0x5378('0xab')]['length'];_0x48bb22++){_0x379080[_0x5378('0x86')](_0x1c771a(_0x5378('0xb2'),_0x36342f[_0x5378('0xab')][_0x48bb22][_0x5378('0xb3')]));_0x379080['push'](_0x1c771a(_0x5378('0xb4'),_0x36342f[_0x5378('0xab')][_0x48bb22]['dataValues']));_0x379080[_0x5378('0x86')](_0x1c771a(_0x5378('0xb5'),_0x36342f['rows'][_0x48bb22][_0x5378('0xb3')]));_0x379080[_0x5378('0x86')](_0x1c771a('mail',_0x36342f[_0x5378('0xab')][_0x48bb22]['dataValues']));_0x379080[_0x5378('0x86')](_0x1c771a(_0x5378('0xb6'),_0x36342f[_0x5378('0xab')][_0x48bb22][_0x5378('0xb3')]));_0x379080[_0x5378('0x86')](_0x1c771a('whatsapp',_0x36342f[_0x5378('0xab')][_0x48bb22][_0x5378('0xb3')]));}return Promise['all'](_0x379080)[_0x5378('0x6')](function(){return _0x36342f;});}return _0x36342f;});}});}}});};