Built motion from commit 9d0783e6.|2.6.13
[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 _0x540a=['toUpperCase','slice','Sequelize','QueryTypes','SELECT','select','InteractionId','ui.createdAt','from','user_has_','_interactions','ui.UserId\x20=\x20?','sequelize','query','OpenTabs','define','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','length','push','UserProfileSection','params','all','isEmpty','union','ignore','autoAssociation','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','where','pick','merge','key','VIRTUAL','find','foreignKey','forEach','options','include','reportType','default','DefaultReports','custom','reportId','CustomReports','count','rows','ids','customSorting','extraQueryConditions','includeAll','CmContact','Tags','color','ThroughTags','tag','true','chat','dataValues','sms','fax','mail','openchannel','whatsapp','./userProfile.attributes','../../components/parsers/qs','squel','exports','models','filter','field','findAll','then','associatedResources','map','value','model','catch','resolve','UserProfileResource','AnalyticExtractedReport','resourceId','toLowerCase','squareprojects','childModel','SquareProject','odbc','SquareOdbc','SquareRecording','parentSections','SquareProjects','projectName','Lists','lists','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','faxqueues','FaxQueue','inboundroutes','outboundroutes','VoiceExtension','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','membername','agent','Telephones','name','User','role','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','type','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','VoicePrefix','ivrcampaigns','Campaign','mailqueues','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','WhatsappAccount','teams','Team','users','agents','telephones','Users','admin','Agents','zendeskaccounts','salesforceaccounts','SalesforceAccount','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','vtigeraccounts','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','Interval','pauses','Pause','scheduler','Schedule','sounds','Tag','templates','triggers','Trunk','variables','Variable','plugins','extractedreports','Reports','metrics','AnalyticMetric','charAt'];(function(_0x2e45db,_0xac82b2){var _0x22310e=function(_0x584881){while(--_0x584881){_0x2e45db['push'](_0x2e45db['shift']());}};_0x22310e(++_0xac82b2);}(_0x540a,0x1dd));var _0xa540=function(_0x3f801e,_0x2b543b){_0x3f801e=_0x3f801e-0x0;var _0x30a9b7=_0x540a[_0x3f801e];return _0x30a9b7;};'use strict';var _=require('lodash');var attributes=require(_0xa540('0x0'));var qs=require(_0xa540('0x1'));var squel=require(_0xa540('0x2'));module[_0xa540('0x3')]=function(_0x550586){var _0x2e22dd=_0x550586[_0xa540('0x4')];function _0x4cf7e8(_0x36215f,_0x151b9a){return new Promise(function(_0x326339,_0x1c9706){if(!_0x151b9a)return _0x326339(null);var _0x1c010b=_0x151b9a[_0xa540('0x5')]?{[_0x151b9a['filter'][_0xa540('0x6')]]:_0x151b9a[_0xa540('0x5')]['value']}:undefined;return _0x2e22dd[_0x36215f][_0xa540('0x7')]({'where':_0x1c010b,'raw':!![]})[_0xa540('0x8')](function(_0x57b460){_0x151b9a[_0xa540('0x9')]=_[_0xa540('0xa')](_0x57b460,'id');_0x326339(_0x151b9a);})['catch'](function(_0x2933e9){_0x1c9706(_0x2933e9);});});}function _0x15399e(_0x46d3d4,_0xaf2a0){return new Promise(function(_0x5e7b89,_0x582963){var _0x5351fe=_0x46d3d4[_0xa540('0x5')]?{[_0x46d3d4[_0xa540('0x5')][_0xa540('0x6')]]:_0x46d3d4[_0xa540('0x5')][_0xa540('0xb')]}:undefined;return _0x2e22dd[_0x46d3d4[_0xa540('0xc')]][_0xa540('0x7')]({'where':_0x5351fe,'raw':!![]})['then'](function(_0x2926ca){_0xaf2a0[_0xa540('0x9')]=_[_0xa540('0xa')](_0x2926ca,function(_0x481e0f){return _0x481e0f['name'];});_0x5e7b89(_0xaf2a0);})[_0xa540('0xd')](function(_0xa2b516){_0x582963(_0xa2b516);});});}function _0x4fa8ba(_0x2b6413,_0x331eb6,_0x5c9c60){if(!_0x331eb6)return Promise[_0xa540('0xe')](null);return new Promise(function(_0x33f5e9,_0x5caeef){return _0x2e22dd[_0xa540('0xf')][_0xa540('0x7')]({'where':{'sectionId':_0x331eb6['id']},'raw':!![]})[_0xa540('0x8')](function(_0x24c2e2){if(_0x2b6413[_0xa540('0x6')]&&_0x2b6413['field']!=='id'){_0x331eb6[_0xa540('0x9')]=_[_0xa540('0xa')](_0x24c2e2,function(_0x558ab8){return _0x558ab8[_0x2b6413[_0xa540('0x6')]];});}else{if(_0x5c9c60===_0xa540('0x10')){_0x331eb6[_0xa540('0x9')]=_[_0xa540('0xa')](_0x24c2e2,function(_0x40c327){return{'id':_0x40c327[_0xa540('0x11')],'type':_0x40c327['type']};});}else{_0x331eb6[_0xa540('0x9')]=_[_0xa540('0xa')](_0x24c2e2,function(_0xa5bb8d){return _0xa5bb8d['resourceId'];});}}_0x33f5e9(_0x331eb6);})['catch'](function(_0x2187ee){_0x5caeef(_0x2187ee);});});}function _0x2fc61e(_0x555020,_0x53fbc8){var _0xd9e1d4={'parentSections':[]};switch(_0x555020[_0xa540('0x12')]()){case _0xa540('0x13'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x15');break;case _0xa540('0x16'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x17');break;case'squarerecordings':_0xd9e1d4['childModel']=_0xa540('0x18');_0xd9e1d4[_0xa540('0x19')]=[{'name':_0xa540('0x1a'),'field':'name','foreignKey':_0xa540('0x1b')}];break;case'projects':_0xd9e1d4[_0xa540('0x14')]='JscriptyProject';break;case'contacts':_0xd9e1d4[_0xa540('0x14')]='CmContact';_0xd9e1d4['parentSections']=[{'name':_0xa540('0x1c'),'field':'id','foreignKey':'ListId'}];break;case _0xa540('0x1d'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x1e');break;case _0xa540('0x1f'):_0xd9e1d4['childModel']=_0xa540('0x20');break;case _0xa540('0x21'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x22');break;case _0xa540('0x23'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x24');break;case'chatwebsites':_0xd9e1d4[_0xa540('0x14')]='ChatWebsite';break;case _0xa540('0x25'):_0xd9e1d4['childModel']=_0xa540('0x26');break;case'faxaccounts':_0xd9e1d4['childModel']='FaxAccount';break;case _0xa540('0x27'):case'internalroutes':case _0xa540('0x28'):_0xd9e1d4['childModel']=_0xa540('0x29');break;case'contexts':_0xd9e1d4['childModel']=_0xa540('0x2a');break;case _0xa540('0x2b'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x2c');break;case _0xa540('0x2d'):_0xd9e1d4['childModel']=_0xa540('0x2e');_0xd9e1d4[_0xa540('0x19')]=[{'name':'Agents','field':'name','foreignKey':_0xa540('0x2f'),'model':'User','filter':{'field':'role','value':[_0xa540('0x30')]}},{'name':_0xa540('0x31'),'field':_0xa540('0x32'),'foreignKey':_0xa540('0x2f'),'model':_0xa540('0x33'),'filter':{'field':_0xa540('0x34'),'value':['telephone']}},{'name':_0xa540('0x35'),'field':_0xa540('0x32'),'foreignKey':_0xa540('0x36'),'model':_0xa540('0x37'),'filter':{'field':'type','value':[_0xa540('0x38')]}},{'name':_0xa540('0x39'),'field':_0xa540('0x32'),'foreignKey':_0xa540('0x36'),'model':'VoiceQueue','filter':{'field':_0xa540('0x3a'),'value':['outbound']}}];break;case _0xa540('0x3b'):_0xd9e1d4['childModel']=_0xa540('0x3c');break;case _0xa540('0x3d'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x3e');break;case'voiceprefixes':_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x3f');break;case _0xa540('0x40'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x41');break;case _0xa540('0x42'):_0xd9e1d4[_0xa540('0x14')]='MailQueue';break;case _0xa540('0x43'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x44');break;case _0xa540('0x45'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x46');break;case _0xa540('0x47'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x48');break;case _0xa540('0x49'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x4a');break;case _0xa540('0x4b'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x4c');break;case _0xa540('0x4d'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x4e');break;case _0xa540('0x4f'):_0xd9e1d4['childModel']=_0xa540('0x50');break;case'whatsappaccounts':_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x51');break;case _0xa540('0x52'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x53');break;case'voicequeues':case'queuecampaigns':_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x37');if(_0x53fbc8){_0xd9e1d4[_0xa540('0x19')]=[{'name':_0xa540('0x35')},{'name':_0xa540('0x39')}];}break;case _0xa540('0x54'):case _0xa540('0x55'):case _0xa540('0x56'):_0xd9e1d4[_0xa540('0x14')]='User';if(_0x53fbc8){_0xd9e1d4[_0xa540('0x19')]=[{'name':_0xa540('0x57'),'filter':{'field':_0xa540('0x34'),'value':[_0xa540('0x58'),'user']},'ignore':!![]},{'name':_0xa540('0x59')},{'name':_0xa540('0x31')}];}break;case _0xa540('0x5a'):_0xd9e1d4[_0xa540('0x14')]='ZendeskAccount';break;case _0xa540('0x5b'):_0xd9e1d4['childModel']=_0xa540('0x5c');break;case'freshdeskaccounts':_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x5d');break;case _0xa540('0x5e'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x5f');break;case _0xa540('0x60'):_0xd9e1d4['childModel']=_0xa540('0x61');break;case _0xa540('0x62'):_0xd9e1d4[_0xa540('0x14')]='ZohoAccount';break;case _0xa540('0x63'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x33');break;case'cannedanswers':_0xd9e1d4['childModel']=_0xa540('0x64');break;case _0xa540('0x65'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x66');break;case _0xa540('0x67'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x68');break;case'intervals':_0xd9e1d4['childModel']=_0xa540('0x69');break;case _0xa540('0x6a'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x6b');break;case _0xa540('0x6c'):_0xd9e1d4['childModel']=_0xa540('0x6d');break;case _0xa540('0x6e'):_0xd9e1d4[_0xa540('0x14')]='Sound';break;case'tags':_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x6f');break;case _0xa540('0x70'):_0xd9e1d4[_0xa540('0x14')]='Template';break;case _0xa540('0x71'):_0xd9e1d4[_0xa540('0x14')]='Trigger';break;case'trunks':_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x72');break;case _0xa540('0x73'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x74');break;case _0xa540('0x75'):_0xd9e1d4[_0xa540('0x14')]='Plugin';break;case _0xa540('0x76'):_0xd9e1d4[_0xa540('0x14')]='AnalyticExtractedReport';_0xd9e1d4['parentSections']=[{'name':_0xa540('0x77'),'field':'id','foreignKey':'reportId'}];break;case _0xa540('0x78'):_0xd9e1d4[_0xa540('0x14')]=_0xa540('0x79');break;}return _0xd9e1d4;}function _0x5540e9(_0x300890,_0x2d25ac){var _0x18cb8d=_0x300890[_0xa540('0x7a')](0x0)[_0xa540('0x7b')]()+_0x300890[_0xa540('0x7c')](0x1);var _0x331c29={'type':_0x2e22dd[_0xa540('0x7d')][_0xa540('0x7e')][_0xa540('0x7f')],'raw':!![]};return new Promise(function(_0x359bdf,_0x5c0ad2){var _0x141e80=squel[_0xa540('0x80')]()[_0xa540('0x6')]('ui.'+_0x18cb8d+_0xa540('0x81'),'id')['field'](_0xa540('0x82'))[_0xa540('0x83')](_0xa540('0x84')+_0x300890+_0xa540('0x85'),'ui')['where'](_0xa540('0x86'),_0x2d25ac['id']);return _0x2e22dd[_0xa540('0x87')][_0xa540('0x88')](_0x141e80['toString'](),_0x331c29)['then'](function(_0x17d4c9){_0x2d25ac[_0x18cb8d+_0xa540('0x89')]=_0x17d4c9;_0x359bdf(_0x17d4c9);})[_0xa540('0xd')](function(_0x42dbad){_0x5c0ad2(_0x42dbad);});});}return _0x550586[_0xa540('0x8a')]('UserProfile',attributes,{'tableName':_0xa540('0x8b'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x534691){var _0x46dafd={'raw':_0x534691[_0xa540('0x88')][_0xa540('0x8c')],'where':{}};var _0x580199={};var _0x18c8b4={'count':0x0,'rows':[]};var _0x2d5965=_0x534691['query'][_0xa540('0x8d')];var _0x4dbafd=_0x534691[_0xa540('0x88')][_0xa540('0x8e')]||![];var _0x187766=_0x2fc61e(_0x2d5965,_0x4dbafd);if(!_0x187766[_0xa540('0x14')])throw new Error(_0xa540('0x8f')+_0x2d5965+'\x27');var _0x10add0=[{'name':_0x2d5965}];if(!_['isEmpty'](_0x187766[_0xa540('0x19')]))_0x10add0=_0x187766[_0xa540('0x19')];var _0x21a598=[];for(var _0x280432=0x0;_0x280432<_0x10add0[_0xa540('0x90')];_0x280432++){_0x21a598[_0xa540('0x91')](_0x2e22dd[_0xa540('0x92')]['find']({'where':{'userProfileId':_0x534691[_0xa540('0x93')]['id'],'name':_0x10add0[_0x280432]['name']},'raw':!![]}));}return Promise[_0xa540('0x94')](_0x21a598)['then'](function(_0x4d5096){var _0x3829c9=_['filter'](_0x4d5096,function(_0x3250d8){return _0x3250d8?_0x3250d8:undefined;});var _0x3e7803=_['filter'](_0x10add0,['ignore',!![]]);var _0xd7eef2=_[_0xa540('0x95')](_0x3829c9)&&_[_0xa540('0x95')](_0x3e7803)?null:_[_0xa540('0x96')](_0x3e7803,_0x3829c9);if(!_0xd7eef2)return null;var _0xbe17cb=[];for(var _0x3c6206=0x0;_0x3c6206<_0xd7eef2['length'];_0x3c6206++){var _0x2a824f=_['find'](_0x10add0,function(_0x1c6518){return _0xd7eef2[_0x3c6206]?_0x1c6518[_0xa540('0x32')]===_0xd7eef2[_0x3c6206][_0xa540('0x32')]:null;});if(_0x2a824f){if(_0xd7eef2[_0x3c6206][_0xa540('0x97')]){_0xbe17cb['push'](_0x4cf7e8(_0x187766[_0xa540('0x14')],_0xd7eef2[_0x3c6206]));}else{if(!_0xd7eef2[_0x3c6206][_0xa540('0x98')]){_0xbe17cb[_0xa540('0x91')](_0x4fa8ba(_0x2a824f,_0xd7eef2[_0x3c6206],_0x187766[_0xa540('0x14')]));}else{if(_0x2a824f[_0xa540('0xc')]){_0xbe17cb[_0xa540('0x91')](_0x15399e(_0x2a824f,_0xd7eef2[_0x3c6206]));}}}}}return Promise[_0xa540('0x94')](_0xbe17cb);})['then'](function(_0x1ad404){var _0x139c2a=_0x1ad404;var _0x528fce=null;if(_0x139c2a){_0x528fce=_0x139c2a['length']===0x1?_0x139c2a[0x0]:null;}if(!_0x528fce&&!_0x139c2a)return _0x18c8b4;var _0x21fa59=_0x2e22dd[_0x187766['childModel']][_0xa540('0x99')];_0x580199['model']=_[_0xa540('0x9a')](_0x21fa59);_0x580199['query']=_[_0xa540('0x9a')](_0x534691['query']);_0x580199[_0xa540('0x9b')]=_[_0xa540('0x9c')](_0x580199[_0xa540('0xc')],_0x580199[_0xa540('0x88')]);_0x46dafd[_0xa540('0x9d')]=_[_0xa540('0x9c')](_0x580199[_0xa540('0xc')],qs['fields'](_0x534691[_0xa540('0x88')][_0xa540('0x9e')]));_0x46dafd[_0xa540('0x9d')]=_0x46dafd[_0xa540('0x9d')][_0xa540('0x90')]?_0x46dafd[_0xa540('0x9d')]:_0x580199['model'];if(!_0x534691[_0xa540('0x88')][_0xa540('0x9f')](_0xa540('0xa0'))){_0x46dafd[_0xa540('0xa1')]=qs['limit'](_0x534691[_0xa540('0x88')][_0xa540('0xa1')]);_0x46dafd[_0xa540('0xa2')]=qs[_0xa540('0xa2')](_0x534691['query'][_0xa540('0xa2')]);}_0x46dafd[_0xa540('0xa3')]=qs[_0xa540('0xa4')](_0x534691[_0xa540('0x88')][_0xa540('0xa4')]);_0x46dafd[_0xa540('0xa5')]=qs[_0xa540('0x9b')](_[_0xa540('0xa6')](_0x534691['query'],_0x580199[_0xa540('0x9b')]));if(_0x534691[_0xa540('0x88')]['filter']){_0x46dafd['where']=_[_0xa540('0xa7')](_0x46dafd[_0xa540('0xa5')],{'$or':_[_0xa540('0xa')](_0x21fa59,function(_0x591e37){if(_0x591e37[_0xa540('0x3a')][_0xa540('0xa8')]!==_0xa540('0xa9')){var _0x433285={};_0x433285[_0x591e37[_0xa540('0x6')]]={'$like':'%'+_0x534691[_0xa540('0x88')]['filter']+'%'};return _0x433285;}})});}var _0x12c024=[];var _0x14ffab=null;var _0x4843f1={};if(_0x528fce){_0x14ffab=_[_0xa540('0xaa')](_0x10add0,[_0xa540('0x32'),_0x528fce[_0xa540('0x32')]]);if(_0x14ffab['field']){_0x4843f1={};if(_0x187766[_0xa540('0x14')]===_0xa540('0x10')){_0x4843f1[_0x14ffab[_0xa540('0xab')]]=_['map'](_0x528fce[_0xa540('0x9')],'id');}else{_0x4843f1[_0x14ffab['foreignKey']]=_0x528fce['associatedResources'];}_0x12c024[_0xa540('0x91')](_0x4843f1);}else{_0x46dafd[_0xa540('0xa5')]['id']=_0x528fce[_0xa540('0x9')];}}else{for(var _0x17d7ac=0x0;_0x17d7ac<_0x139c2a[_0xa540('0x90')];_0x17d7ac++){_0x14ffab=_[_0xa540('0xaa')](_0x10add0,[_0xa540('0x32'),_0x139c2a[_0x17d7ac][_0xa540('0x32')]]);if(_0x14ffab['field']){_0x4843f1={};_0x4843f1[_0x14ffab[_0xa540('0xab')]]=_0x139c2a[_0x17d7ac][_0xa540('0x9')];_0x12c024[_0xa540('0x91')](_0x4843f1);}else{if(!_0x46dafd['where']['id'])_0x46dafd[_0xa540('0xa5')]['id']=[];_0x139c2a[_0x17d7ac][_0xa540('0x9')][_0xa540('0xac')](function(_0x4e2509){_0x46dafd[_0xa540('0xa5')]['id'][_0xa540('0x91')](_0x4e2509);});}}}if(!_[_0xa540('0x95')](_0x12c024)){_0x46dafd[_0xa540('0xa5')]=_[_0xa540('0xa7')](_0x46dafd['where'],{'$and':{'$or':_0x12c024}});}_0x46dafd=_[_0xa540('0xa7')]({},_0x46dafd,_0x534691[_0xa540('0xad')]);if(_0x528fce&&!_0x528fce[_0xa540('0x98')]&&_0x187766[_0xa540('0x14')]===_0xa540('0x10')){if(_0x534691[_0xa540('0x88')]['includeAll']){_0x46dafd[_0xa540('0xae')]=[{'all':!![]}];}return _0x2e22dd[_0x187766['childModel']][_0xa540('0x7')](_0x46dafd)[_0xa540('0x8')](function(_0x42e8ee){var _0x1c08dd=[];_0x42e8ee[_0xa540('0xac')](function(_0x2637ce){var _0x128482;switch(_0x2637ce[_0xa540('0xaf')]){case _0xa540('0xb0'):_0x128482=_[_0xa540('0xaa')](_0x528fce[_0xa540('0x9')],function(_0x3f8e91){return _0x3f8e91['id']===_0x2637ce['reportId']&&_0x3f8e91[_0xa540('0x3a')]===_0xa540('0xb1');});break;case _0xa540('0xb2'):_0x128482=_[_0xa540('0xaa')](_0x528fce[_0xa540('0x9')],function(_0xad6a1a){return _0xad6a1a['id']===_0x2637ce[_0xa540('0xb3')]&&_0xad6a1a[_0xa540('0x3a')]===_0xa540('0xb4');});break;}if(_0x128482)_0x1c08dd[_0xa540('0x91')](_0x2637ce);});_0x18c8b4[_0xa540('0xb5')]=_0x1c08dd[_0xa540('0x90')];_0x18c8b4[_0xa540('0xb6')]=_0x1c08dd;return _0x18c8b4;});}else{if(!_[_0xa540('0x95')](_0x534691['query'][_0xa540('0xb7')])){_0x46dafd[_0xa540('0xa5')]['id']=_0x46dafd['where']['id']?_[_0xa540('0x9c')](_0x46dafd['where']['id'],_0x534691[_0xa540('0x88')][_0xa540('0xb7')]):_0x534691[_0xa540('0x88')][_0xa540('0xb7')];if(_0x534691[_0xa540('0x88')][_0xa540('0xb8')]){_0x46dafd[_0xa540('0xa3')]=_0x534691[_0xa540('0x88')][_0xa540('0xb8')];}}if(_0x534691[_0xa540('0x88')][_0xa540('0xb9')]){_0x46dafd['where']=_[_0xa540('0xa7')](_0x46dafd[_0xa540('0xa5')],{'$and':_0x534691[_0xa540('0x88')][_0xa540('0xb9')]});}return _0x2e22dd[_0x187766['childModel']][_0xa540('0xb5')]({'where':_0x46dafd[_0xa540('0xa5')]})[_0xa540('0x8')](function(_0xc6ce85){_0x18c8b4['count']=_0xc6ce85;if(_0x534691[_0xa540('0x88')][_0xa540('0xba')]){if(_0x187766['childModel']===_0xa540('0xbb')){_0x46dafd[_0xa540('0xae')]=[{'model':_0x2e22dd[_0xa540('0x6f')],'as':_0xa540('0xbc'),'attributes':['id','name',_0xa540('0xbd')],'required':_0x534691['query']['tag']?!![]:![]},{'model':_0x2e22dd['Tag'],'as':_0xa540('0xbe'),'attributes':['id','name',_0xa540('0xbd')],'through':_0x534691[_0xa540('0x88')][_0xa540('0xbf')]?{'attributes':[],'where':{'TagId':_0x534691[_0xa540('0x88')]['tag']||undefined}}:{},'required':_0x534691[_0xa540('0x88')][_0xa540('0xbf')]?!![]:![]}];}else{_0x46dafd[_0xa540('0xae')]=[{'all':!![]}];}}return _0x2e22dd[_0x187766[_0xa540('0x14')]][_0xa540('0x7')](_0x46dafd);})['then'](function(_0x24fd5c){_0x18c8b4[_0xa540('0xb6')]=_0x24fd5c;if(_0x2d5965===_0xa540('0x59')&&_0x534691[_0xa540('0x88')]['openTabs']===_0xa540('0xc0')){var _0x136095=[];for(var _0x22d75b=0x0;_0x22d75b<_0x18c8b4['rows']['length'];_0x22d75b++){_0x136095[_0xa540('0x91')](_0x5540e9(_0xa540('0xc1'),_0x18c8b4[_0xa540('0xb6')][_0x22d75b][_0xa540('0xc2')]));_0x136095['push'](_0x5540e9(_0xa540('0xc3'),_0x18c8b4[_0xa540('0xb6')][_0x22d75b][_0xa540('0xc2')]));_0x136095[_0xa540('0x91')](_0x5540e9(_0xa540('0xc4'),_0x18c8b4[_0xa540('0xb6')][_0x22d75b][_0xa540('0xc2')]));_0x136095['push'](_0x5540e9(_0xa540('0xc5'),_0x18c8b4[_0xa540('0xb6')][_0x22d75b][_0xa540('0xc2')]));_0x136095[_0xa540('0x91')](_0x5540e9(_0xa540('0xc6'),_0x18c8b4['rows'][_0x22d75b][_0xa540('0xc2')]));_0x136095[_0xa540('0x91')](_0x5540e9(_0xa540('0xc7'),_0x18c8b4['rows'][_0x22d75b][_0xa540('0xc2')]));}return Promise[_0xa540('0x94')](_0x136095)[_0xa540('0x8')](function(){return _0x18c8b4;});}return _0x18c8b4;});}});}}});};