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 _0x0a58=['outbound','musiconholds','VoiceMusicOnHold','chanspies','mailqueues','MailQueue','mailaccounts','MailSubstatus','openchannelqueues','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','whatsappqueues','WhatsappQueue','teams','Team','voicequeues','queuecampaigns','telephones','admin','user','Telephones','zendeskaccounts','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','DeskAccount','zohoaccounts','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','Dashboard','intervals','Interval','pauses','Pause','Schedule','Sound','tags','Tag','templates','Template','triggers','Trigger','Trunk','variables','Variable','plugins','Plugin','extractedreports','reportId','metrics','AnalyticMetric','charAt','slice','Sequelize','QueryTypes','SELECT','select','InteractionId','_interactions','where','ui.UserId\x20=\x20?','define','UserProfile','user_profiles','../../components/parsers/qs','query','raw','section','mergeResources','Invalid\x20section\x20\x27','push','all','ignore','isEmpty','union','find','autoAssociation','model','rawAttributes','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','offset','order','sort','pick','merge','key','VIRTUAL','foreignKey','options','includeAll','forEach','reportType','default','custom','CustomReports','count','ids','customSorting','extraQueryConditions','CmContact','include','Tags','color','tag','ThroughTags','openTabs','chat','rows','dataValues','sms','mail','whatsapp','lodash','./userProfile.attributes','squel','exports','filter','field','findAll','map','catch','value','then','associatedResources','resolve','UserProfileResource','AnalyticExtractedReport','resourceId','toLowerCase','squareprojects','childModel','odbc','SquareOdbc','parentSections','name','projects','Lists','ListId','lists','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','chatwebsites','ChatWebsite','faxqueues','FaxQueue','faxaccounts','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','voicerecordings','VoiceRecording','Agents','membername','User','agent','role','telephone','VoiceQueues','queue','VoiceQueue','type','inbound','QueueCampaigns'];(function(_0x20a584,_0xe384a5){var _0x4b41a8=function(_0x2127c6){while(--_0x2127c6){_0x20a584['push'](_0x20a584['shift']());}};_0x4b41a8(++_0xe384a5);}(_0x0a58,0x13a));var _0x80a5=function(_0x42cae2,_0x284ef8){_0x42cae2=_0x42cae2-0x0;var _0x5f256f=_0x0a58[_0x42cae2];return _0x5f256f;};'use strict';var _=require(_0x80a5('0x0'));var attributes=require(_0x80a5('0x1'));var squel=require(_0x80a5('0x2'));module[_0x80a5('0x3')]=function(_0x30997e){var _0x378a94=_0x30997e['models'];function _0x45881a(_0x3b938a,_0x562bb8){return new Promise(function(_0x26e219,_0x155196){if(!_0x562bb8)return _0x26e219(null);var _0x1d7677=_0x562bb8['filter']?{[_0x562bb8[_0x80a5('0x4')][_0x80a5('0x5')]]:_0x562bb8[_0x80a5('0x4')]['value']}:undefined;return _0x378a94[_0x3b938a][_0x80a5('0x6')]({'where':_0x1d7677,'raw':!![]})['then'](function(_0x44a1c0){_0x562bb8['associatedResources']=_[_0x80a5('0x7')](_0x44a1c0,'id');_0x26e219(_0x562bb8);})[_0x80a5('0x8')](function(_0x5f23a9){_0x155196(_0x5f23a9);});});}function _0x59dd1a(_0x287cd9,_0xfce651){return new Promise(function(_0x3427d8,_0x24165f){var _0x2772f2=_0x287cd9['filter']?{[_0x287cd9['filter']['field']]:_0x287cd9[_0x80a5('0x4')][_0x80a5('0x9')]}:undefined;return _0x378a94[_0x287cd9['model']]['findAll']({'where':_0x2772f2,'raw':!![]})[_0x80a5('0xa')](function(_0x275264){_0xfce651[_0x80a5('0xb')]=_['map'](_0x275264,function(_0x1d8cef){return _0x1d8cef['name'];});_0x3427d8(_0xfce651);})[_0x80a5('0x8')](function(_0x425b69){_0x24165f(_0x425b69);});});}function _0x514afd(_0x1ac740,_0x42be15,_0x31fa52){if(!_0x42be15)return Promise[_0x80a5('0xc')](null);return new Promise(function(_0x56af53,_0x2f31b9){return _0x378a94[_0x80a5('0xd')][_0x80a5('0x6')]({'where':{'sectionId':_0x42be15['id']},'raw':!![]})[_0x80a5('0xa')](function(_0x199f7e){if(_0x1ac740[_0x80a5('0x5')]&&_0x1ac740[_0x80a5('0x5')]!=='id'){_0x42be15[_0x80a5('0xb')]=_[_0x80a5('0x7')](_0x199f7e,function(_0x574038){return _0x574038[_0x1ac740['field']];});}else{if(_0x31fa52===_0x80a5('0xe')){_0x42be15['associatedResources']=_[_0x80a5('0x7')](_0x199f7e,function(_0x54e613){return{'id':_0x54e613[_0x80a5('0xf')],'type':_0x54e613['type']};});}else{_0x42be15[_0x80a5('0xb')]=_[_0x80a5('0x7')](_0x199f7e,function(_0x29036d){return _0x29036d[_0x80a5('0xf')];});}}_0x56af53(_0x42be15);})[_0x80a5('0x8')](function(_0x1246db){_0x2f31b9(_0x1246db);});});}function _0x8c64c8(_0x1ee4ce,_0x1314ce){var _0x43989b={'parentSections':[]};switch(_0x1ee4ce[_0x80a5('0x10')]()){case _0x80a5('0x11'):_0x43989b[_0x80a5('0x12')]='SquareProject';break;case _0x80a5('0x13'):_0x43989b['childModel']=_0x80a5('0x14');break;case'squarerecordings':_0x43989b[_0x80a5('0x12')]='SquareRecording';_0x43989b[_0x80a5('0x15')]=[{'name':'SquareProjects','field':_0x80a5('0x16'),'foreignKey':'projectName'}];break;case _0x80a5('0x17'):_0x43989b[_0x80a5('0x12')]='JscriptyProject';break;case'contacts':_0x43989b[_0x80a5('0x12')]='CmContact';_0x43989b['parentSections']=[{'name':_0x80a5('0x18'),'field':'id','foreignKey':_0x80a5('0x19')}];break;case _0x80a5('0x1a'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x1b');break;case _0x80a5('0x1c'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x1d');break;case _0x80a5('0x1e'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x1f');break;case _0x80a5('0x20'):_0x43989b['childModel']='ChatQueue';break;case _0x80a5('0x21'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x22');break;case _0x80a5('0x23'):_0x43989b['childModel']=_0x80a5('0x24');break;case _0x80a5('0x25'):_0x43989b[_0x80a5('0x12')]='FaxAccount';break;case'inboundroutes':case _0x80a5('0x26'):case _0x80a5('0x27'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x28');break;case _0x80a5('0x29'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x2a');break;case _0x80a5('0x2b'):_0x43989b['childModel']='VoiceMail';break;case _0x80a5('0x2c'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x2d');_0x43989b[_0x80a5('0x15')]=[{'name':_0x80a5('0x2e'),'field':'name','foreignKey':_0x80a5('0x2f'),'model':_0x80a5('0x30'),'filter':{'field':'role','value':[_0x80a5('0x31')]}},{'name':'Telephones','field':_0x80a5('0x16'),'foreignKey':_0x80a5('0x2f'),'model':'User','filter':{'field':_0x80a5('0x32'),'value':[_0x80a5('0x33')]}},{'name':_0x80a5('0x34'),'field':'name','foreignKey':_0x80a5('0x35'),'model':_0x80a5('0x36'),'filter':{'field':_0x80a5('0x37'),'value':[_0x80a5('0x38')]}},{'name':_0x80a5('0x39'),'field':_0x80a5('0x16'),'foreignKey':_0x80a5('0x35'),'model':_0x80a5('0x36'),'filter':{'field':_0x80a5('0x37'),'value':[_0x80a5('0x3a')]}}];break;case _0x80a5('0x3b'):_0x43989b['childModel']=_0x80a5('0x3c');break;case _0x80a5('0x3d'):_0x43989b[_0x80a5('0x12')]='VoiceChanSpy';break;case'voiceprefixes':_0x43989b['childModel']='VoicePrefix';break;case'ivrcampaigns':_0x43989b[_0x80a5('0x12')]='Campaign';break;case _0x80a5('0x3e'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x3f');break;case _0x80a5('0x40'):_0x43989b[_0x80a5('0x12')]='MailAccount';break;case'mailsubstatuses':_0x43989b[_0x80a5('0x12')]=_0x80a5('0x41');break;case _0x80a5('0x42'):_0x43989b[_0x80a5('0x12')]='OpenchannelQueue';break;case _0x80a5('0x43'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x44');break;case _0x80a5('0x45'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x46');break;case _0x80a5('0x47'):_0x43989b[_0x80a5('0x12')]='SmsAccount';break;case _0x80a5('0x48'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x49');break;case'whatsappaccounts':_0x43989b['childModel']='WhatsappAccount';break;case _0x80a5('0x4a'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x4b');break;case _0x80a5('0x4c'):case _0x80a5('0x4d'):_0x43989b[_0x80a5('0x12')]='VoiceQueue';if(_0x1314ce){_0x43989b[_0x80a5('0x15')]=[{'name':_0x80a5('0x34')},{'name':'QueueCampaigns'}];}break;case'users':case'agents':case _0x80a5('0x4e'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x30');if(_0x1314ce){_0x43989b['parentSections']=[{'name':'Users','filter':{'field':_0x80a5('0x32'),'value':[_0x80a5('0x4f'),_0x80a5('0x50')]},'ignore':!![]},{'name':_0x80a5('0x2e')},{'name':_0x80a5('0x51')}];}break;case _0x80a5('0x52'):_0x43989b[_0x80a5('0x12')]='ZendeskAccount';break;case'salesforceaccounts':_0x43989b[_0x80a5('0x12')]='SalesforceAccount';break;case _0x80a5('0x53'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x54');break;case _0x80a5('0x55'):_0x43989b['childModel']=_0x80a5('0x56');break;case'deskaccounts':_0x43989b[_0x80a5('0x12')]=_0x80a5('0x57');break;case _0x80a5('0x58'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x59');break;case _0x80a5('0x5a'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x30');break;case _0x80a5('0x5b'):_0x43989b['childModel']=_0x80a5('0x5c');break;case _0x80a5('0x5d'):_0x43989b['childModel']=_0x80a5('0x5e');break;case'customdashboards':_0x43989b[_0x80a5('0x12')]=_0x80a5('0x5f');break;case _0x80a5('0x60'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x61');break;case _0x80a5('0x62'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x63');break;case'scheduler':_0x43989b['childModel']=_0x80a5('0x64');break;case'sounds':_0x43989b[_0x80a5('0x12')]=_0x80a5('0x65');break;case _0x80a5('0x66'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x67');break;case _0x80a5('0x68'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x69');break;case _0x80a5('0x6a'):_0x43989b['childModel']=_0x80a5('0x6b');break;case'trunks':_0x43989b[_0x80a5('0x12')]=_0x80a5('0x6c');break;case _0x80a5('0x6d'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x6e');break;case _0x80a5('0x6f'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x70');break;case _0x80a5('0x71'):_0x43989b['childModel']=_0x80a5('0xe');_0x43989b[_0x80a5('0x15')]=[{'name':'Reports','field':'id','foreignKey':_0x80a5('0x72')}];break;case _0x80a5('0x73'):_0x43989b[_0x80a5('0x12')]=_0x80a5('0x74');break;}return _0x43989b;}function _0x2f99d0(_0x3aab16,_0x3e81ab){var _0x37b85f=_0x3aab16[_0x80a5('0x75')](0x0)['toUpperCase']()+_0x3aab16[_0x80a5('0x76')](0x1);var _0x2ff266={'type':_0x378a94[_0x80a5('0x77')][_0x80a5('0x78')][_0x80a5('0x79')],'raw':!![]};return new Promise(function(_0xf86fa,_0x4f0ddc){var _0x12ebeb=squel[_0x80a5('0x7a')]()['field']('ui.'+_0x37b85f+_0x80a5('0x7b'),'id')[_0x80a5('0x5')]('ui.createdAt')['from']('user_has_'+_0x3aab16+_0x80a5('0x7c'),'ui')[_0x80a5('0x7d')](_0x80a5('0x7e'),_0x3e81ab['id']);return _0x378a94['sequelize']['query'](_0x12ebeb['toString'](),_0x2ff266)[_0x80a5('0xa')](function(_0x5b9d16){_0x3e81ab[_0x37b85f+'OpenTabs']=_0x5b9d16;_0xf86fa(_0x5b9d16);})[_0x80a5('0x8')](function(_0x1548af){_0x4f0ddc(_0x1548af);});});}return _0x30997e[_0x80a5('0x7f')](_0x80a5('0x80'),attributes,{'tableName':_0x80a5('0x81'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x486f71){var _0xdc41f=require(_0x80a5('0x82'));var _0x2a650a={'raw':_0x486f71[_0x80a5('0x83')][_0x80a5('0x84')],'where':{}};var _0x1ea4b3={};var _0x453826={'count':0x0,'rows':[]};var _0x5ea4d9=_0x486f71[_0x80a5('0x83')][_0x80a5('0x85')];var _0x50b48a=_0x486f71[_0x80a5('0x83')][_0x80a5('0x86')]||![];var _0x5e1ffe=_0x8c64c8(_0x5ea4d9,_0x50b48a);if(!_0x5e1ffe[_0x80a5('0x12')])throw new Error(_0x80a5('0x87')+_0x5ea4d9+'\x27');var _0x4d7e4b=[{'name':_0x5ea4d9}];if(!_['isEmpty'](_0x5e1ffe[_0x80a5('0x15')]))_0x4d7e4b=_0x5e1ffe[_0x80a5('0x15')];var _0x2b49f2=[];for(var _0x4b0dc4=0x0;_0x4b0dc4<_0x4d7e4b['length'];_0x4b0dc4++){_0x2b49f2[_0x80a5('0x88')](_0x378a94['UserProfileSection']['find']({'where':{'userProfileId':_0x486f71['params']['id'],'name':_0x4d7e4b[_0x4b0dc4][_0x80a5('0x16')]},'raw':!![]}));}return Promise[_0x80a5('0x89')](_0x2b49f2)[_0x80a5('0xa')](function(_0x13d73c){var _0x34bc66=_[_0x80a5('0x4')](_0x13d73c,function(_0x3cd5f0){return _0x3cd5f0?_0x3cd5f0:undefined;});var _0x7aeb3f=_['filter'](_0x4d7e4b,[_0x80a5('0x8a'),!![]]);var _0x38fcd1=_[_0x80a5('0x8b')](_0x34bc66)&&_[_0x80a5('0x8b')](_0x7aeb3f)?null:_[_0x80a5('0x8c')](_0x7aeb3f,_0x34bc66);if(!_0x38fcd1)return null;var _0x10c0ae=[];for(var _0x43e173=0x0;_0x43e173<_0x38fcd1['length'];_0x43e173++){var _0x549ef3=_[_0x80a5('0x8d')](_0x4d7e4b,function(_0x4d0c7c){return _0x38fcd1[_0x43e173]?_0x4d0c7c[_0x80a5('0x16')]===_0x38fcd1[_0x43e173][_0x80a5('0x16')]:null;});if(_0x549ef3){if(_0x38fcd1[_0x43e173][_0x80a5('0x8a')]){_0x10c0ae[_0x80a5('0x88')](_0x45881a(_0x5e1ffe[_0x80a5('0x12')],_0x38fcd1[_0x43e173]));}else{if(!_0x38fcd1[_0x43e173][_0x80a5('0x8e')]){_0x10c0ae[_0x80a5('0x88')](_0x514afd(_0x549ef3,_0x38fcd1[_0x43e173],_0x5e1ffe[_0x80a5('0x12')]));}else{if(_0x549ef3[_0x80a5('0x8f')]){_0x10c0ae[_0x80a5('0x88')](_0x59dd1a(_0x549ef3,_0x38fcd1[_0x43e173]));}}}}}return Promise[_0x80a5('0x89')](_0x10c0ae);})[_0x80a5('0xa')](function(_0x107258){var _0x167b49=_0x107258;var _0x5859e3=null;if(_0x167b49){_0x5859e3=_0x167b49['length']===0x1?_0x167b49[0x0]:null;}if(!_0x5859e3&&!_0x167b49)return _0x453826;var _0x196f11=_0x378a94[_0x5e1ffe[_0x80a5('0x12')]][_0x80a5('0x90')];_0x1ea4b3[_0x80a5('0x8f')]=_[_0x80a5('0x91')](_0x196f11);_0x1ea4b3[_0x80a5('0x83')]=_['keys'](_0x486f71[_0x80a5('0x83')]);_0x1ea4b3[_0x80a5('0x92')]=_[_0x80a5('0x93')](_0x1ea4b3[_0x80a5('0x8f')],_0x1ea4b3['query']);_0x2a650a[_0x80a5('0x94')]=_[_0x80a5('0x93')](_0x1ea4b3[_0x80a5('0x8f')],_0xdc41f[_0x80a5('0x95')](_0x486f71['query'][_0x80a5('0x95')]));_0x2a650a[_0x80a5('0x94')]=_0x2a650a[_0x80a5('0x94')][_0x80a5('0x96')]?_0x2a650a[_0x80a5('0x94')]:_0x1ea4b3['model'];if(!_0x486f71['query'][_0x80a5('0x97')](_0x80a5('0x98'))){_0x2a650a['limit']=_0xdc41f[_0x80a5('0x99')](_0x486f71[_0x80a5('0x83')]['limit']);_0x2a650a[_0x80a5('0x9a')]=_0xdc41f[_0x80a5('0x9a')](_0x486f71[_0x80a5('0x83')]['offset']);}_0x2a650a[_0x80a5('0x9b')]=_0xdc41f['sort'](_0x486f71[_0x80a5('0x83')][_0x80a5('0x9c')]);_0x2a650a[_0x80a5('0x7d')]=_0xdc41f[_0x80a5('0x92')](_[_0x80a5('0x9d')](_0x486f71[_0x80a5('0x83')],_0x1ea4b3[_0x80a5('0x92')]));if(_0x486f71[_0x80a5('0x83')]['filter']){_0x2a650a[_0x80a5('0x7d')]=_[_0x80a5('0x9e')](_0x2a650a[_0x80a5('0x7d')],{'$or':_[_0x80a5('0x7')](_0x196f11,function(_0x1015dc){if(_0x1015dc[_0x80a5('0x37')][_0x80a5('0x9f')]!==_0x80a5('0xa0')){var _0x195fc0={};_0x195fc0[_0x1015dc[_0x80a5('0x5')]]={'$like':'%'+_0x486f71[_0x80a5('0x83')][_0x80a5('0x4')]+'%'};return _0x195fc0;}})});}var _0x1084ef=[];var _0x4c73b2=null;var _0x27c1a8={};if(_0x5859e3){_0x4c73b2=_['find'](_0x4d7e4b,[_0x80a5('0x16'),_0x5859e3[_0x80a5('0x16')]]);if(_0x4c73b2['field']){_0x27c1a8={};if(_0x5e1ffe[_0x80a5('0x12')]===_0x80a5('0xe')){_0x27c1a8[_0x4c73b2['foreignKey']]=_[_0x80a5('0x7')](_0x5859e3[_0x80a5('0xb')],'id');}else{_0x27c1a8[_0x4c73b2['foreignKey']]=_0x5859e3[_0x80a5('0xb')];}_0x1084ef[_0x80a5('0x88')](_0x27c1a8);}else{_0x2a650a[_0x80a5('0x7d')]['id']=_0x5859e3[_0x80a5('0xb')];}}else{for(var _0x1e1b26=0x0;_0x1e1b26<_0x167b49['length'];_0x1e1b26++){_0x4c73b2=_['find'](_0x4d7e4b,['name',_0x167b49[_0x1e1b26][_0x80a5('0x16')]]);if(_0x4c73b2[_0x80a5('0x5')]){_0x27c1a8={};_0x27c1a8[_0x4c73b2[_0x80a5('0xa1')]]=_0x167b49[_0x1e1b26]['associatedResources'];_0x1084ef['push'](_0x27c1a8);}else{if(!_0x2a650a[_0x80a5('0x7d')]['id'])_0x2a650a['where']['id']=[];_0x167b49[_0x1e1b26][_0x80a5('0xb')]['forEach'](function(_0x5d7972){_0x2a650a[_0x80a5('0x7d')]['id'][_0x80a5('0x88')](_0x5d7972);});}}}if(!_['isEmpty'](_0x1084ef)){_0x2a650a[_0x80a5('0x7d')]=_['merge'](_0x2a650a[_0x80a5('0x7d')],{'$and':{'$or':_0x1084ef}});}_0x2a650a=_[_0x80a5('0x9e')]({},_0x2a650a,_0x486f71[_0x80a5('0xa2')]);if(_0x5859e3&&!_0x5859e3[_0x80a5('0x8e')]&&_0x5e1ffe[_0x80a5('0x12')]==='AnalyticExtractedReport'){if(_0x486f71[_0x80a5('0x83')][_0x80a5('0xa3')]){_0x2a650a['include']=[{'all':!![]}];}return _0x378a94[_0x5e1ffe[_0x80a5('0x12')]]['findAll'](_0x2a650a)['then'](function(_0x23b341){var _0x2889f4=[];_0x23b341[_0x80a5('0xa4')](function(_0x129f4b){var _0x353da3;switch(_0x129f4b[_0x80a5('0xa5')]){case _0x80a5('0xa6'):_0x353da3=_[_0x80a5('0x8d')](_0x5859e3[_0x80a5('0xb')],function(_0x591783){return _0x591783['id']===_0x129f4b[_0x80a5('0x72')]&&_0x591783[_0x80a5('0x37')]==='DefaultReports';});break;case _0x80a5('0xa7'):_0x353da3=_[_0x80a5('0x8d')](_0x5859e3['associatedResources'],function(_0x217dc9){return _0x217dc9['id']===_0x129f4b[_0x80a5('0x72')]&&_0x217dc9[_0x80a5('0x37')]===_0x80a5('0xa8');});break;}if(_0x353da3)_0x2889f4[_0x80a5('0x88')](_0x129f4b);});_0x453826[_0x80a5('0xa9')]=_0x2889f4[_0x80a5('0x96')];_0x453826['rows']=_0x2889f4;return _0x453826;});}else{if(!_[_0x80a5('0x8b')](_0x486f71['query']['ids'])){_0x2a650a[_0x80a5('0x7d')]['id']=_0x2a650a[_0x80a5('0x7d')]['id']?_[_0x80a5('0x93')](_0x2a650a[_0x80a5('0x7d')]['id'],_0x486f71[_0x80a5('0x83')][_0x80a5('0xaa')]):_0x486f71['query'][_0x80a5('0xaa')];if(_0x486f71[_0x80a5('0x83')][_0x80a5('0xab')]){_0x2a650a[_0x80a5('0x9b')]=_0x486f71['query'][_0x80a5('0xab')];}}if(_0x486f71[_0x80a5('0x83')][_0x80a5('0xac')]){_0x2a650a[_0x80a5('0x7d')]=_['merge'](_0x2a650a[_0x80a5('0x7d')],{'$and':_0x486f71['query'][_0x80a5('0xac')]});}return _0x378a94[_0x5e1ffe['childModel']][_0x80a5('0xa9')]({'where':_0x2a650a[_0x80a5('0x7d')]})[_0x80a5('0xa')](function(_0xc87783){_0x453826[_0x80a5('0xa9')]=_0xc87783;if(_0x486f71['query'][_0x80a5('0xa3')]){if(_0x5e1ffe[_0x80a5('0x12')]===_0x80a5('0xad')){_0x2a650a[_0x80a5('0xae')]=[{'model':_0x378a94['Tag'],'as':_0x80a5('0xaf'),'attributes':['id',_0x80a5('0x16'),_0x80a5('0xb0')],'required':_0x486f71[_0x80a5('0x83')][_0x80a5('0xb1')]?!![]:![]},{'model':_0x378a94['Tag'],'as':_0x80a5('0xb2'),'attributes':['id','name','color'],'through':_0x486f71[_0x80a5('0x83')][_0x80a5('0xb1')]?{'attributes':[],'where':{'TagId':_0x486f71[_0x80a5('0x83')][_0x80a5('0xb1')]||undefined}}:{},'required':_0x486f71[_0x80a5('0x83')][_0x80a5('0xb1')]?!![]:![]}];}else{_0x2a650a[_0x80a5('0xae')]=[{'all':!![]}];}}return _0x378a94[_0x5e1ffe[_0x80a5('0x12')]][_0x80a5('0x6')](_0x2a650a);})[_0x80a5('0xa')](function(_0x5d5cf8){_0x453826['rows']=_0x5d5cf8;if(_0x5ea4d9===_0x80a5('0x2e')&&_0x486f71[_0x80a5('0x83')][_0x80a5('0xb3')]==='true'){var _0x581b91=[];for(var _0x47c9e0=0x0;_0x47c9e0<_0x453826['rows']['length'];_0x47c9e0++){_0x581b91[_0x80a5('0x88')](_0x2f99d0(_0x80a5('0xb4'),_0x453826[_0x80a5('0xb5')][_0x47c9e0][_0x80a5('0xb6')]));_0x581b91['push'](_0x2f99d0(_0x80a5('0xb7'),_0x453826[_0x80a5('0xb5')][_0x47c9e0][_0x80a5('0xb6')]));_0x581b91[_0x80a5('0x88')](_0x2f99d0('fax',_0x453826['rows'][_0x47c9e0][_0x80a5('0xb6')]));_0x581b91[_0x80a5('0x88')](_0x2f99d0(_0x80a5('0xb8'),_0x453826['rows'][_0x47c9e0][_0x80a5('0xb6')]));_0x581b91[_0x80a5('0x88')](_0x2f99d0('openchannel',_0x453826[_0x80a5('0xb5')][_0x47c9e0][_0x80a5('0xb6')]));_0x581b91[_0x80a5('0x88')](_0x2f99d0(_0x80a5('0xb9'),_0x453826[_0x80a5('0xb5')][_0x47c9e0][_0x80a5('0xb6')]));}return Promise['all'](_0x581b91)['then'](function(){return _0x453826;});}return _0x453826;});}});}}});};