Built motion from commit 00bf23f6.|2.6.16
[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 _0x7573=['slice','Sequelize','SELECT','select','InteractionId','ui.createdAt','from','_interactions','where','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','mergeResources','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','find','params','all','length','ignore','autoAssociation','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','offset','order','key','foreignKey','forEach','includeAll','include','reportType','DefaultReports','reportId','count','rows','ids','customSorting','merge','extraQueryConditions','tag','ThroughTags','true','chat','dataValues','sms','mail','openchannel','whatsapp','./userProfile.attributes','../../components/parsers/qs','exports','filter','field','value','findAll','then','associatedResources','map','model','name','resolve','UserProfileResource','AnalyticExtractedReport','type','catch','toLowerCase','squareprojects','childModel','SquareProject','odbc','squarerecordings','SquareRecording','parentSections','SquareProjects','projectName','projects','JscriptyProject','contacts','CmContact','Lists','ListId','lists','companies','globalcustomfields','CmCustomField','chatqueues','ChatQueue','ChatWebsite','faxqueues','faxaccounts','FaxAccount','inboundroutes','outboundroutes','contexts','VoiceContext','voicemails','VoiceMail','VoiceRecording','Agents','membername','User','role','telephone','VoiceQueues','VoiceQueue','inbound','QueueCampaigns','outbound','VoiceMusicOnHold','VoiceChanSpy','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','mailaccounts','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','Team','voicequeues','queuecampaigns','users','agents','Users','admin','user','Telephones','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','FreshdeskAccount','SugarcrmAccount','DeskAccount','ZohoAccount','vtigeraccounts','cannedanswers','dispositions','Disposition','Dashboard','intervals','Interval','pauses','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Trigger','trunks','Trunk','variables','plugins','Plugin','extractedreports','Reports','metrics','AnalyticMetric','charAt'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x7573,0x1ac));var _0x3757=function(_0x5dae8c,_0x298fac){_0x5dae8c=_0x5dae8c-0x0;var _0xdf2bed=_0x7573[_0x5dae8c];return _0xdf2bed;};'use strict';var _=require('lodash');var attributes=require(_0x3757('0x0'));var qs=require(_0x3757('0x1'));var squel=require('squel');module[_0x3757('0x2')]=function(_0x2804d0){var _0x5b9e64=_0x2804d0['models'];function _0x4fb117(_0x4d4a47,_0x139c5d){return new Promise(function(_0x6d1bb5,_0x431c2f){if(!_0x139c5d)return _0x6d1bb5(null);var _0x3c0a70=_0x139c5d[_0x3757('0x3')]?{[_0x139c5d[_0x3757('0x3')][_0x3757('0x4')]]:_0x139c5d[_0x3757('0x3')][_0x3757('0x5')]}:undefined;return _0x5b9e64[_0x4d4a47][_0x3757('0x6')]({'where':_0x3c0a70,'raw':!![]})[_0x3757('0x7')](function(_0x203b1c){_0x139c5d[_0x3757('0x8')]=_[_0x3757('0x9')](_0x203b1c,'id');_0x6d1bb5(_0x139c5d);})['catch'](function(_0x591ead){_0x431c2f(_0x591ead);});});}function _0x2d6cc8(_0x1dcc23,_0x4d8ce2){return new Promise(function(_0x4de354,_0x5d0c3c){var _0x102ee3=_0x1dcc23[_0x3757('0x3')]?{[_0x1dcc23[_0x3757('0x3')][_0x3757('0x4')]]:_0x1dcc23[_0x3757('0x3')][_0x3757('0x5')]}:undefined;return _0x5b9e64[_0x1dcc23[_0x3757('0xa')]][_0x3757('0x6')]({'where':_0x102ee3,'raw':!![]})[_0x3757('0x7')](function(_0x445916){_0x4d8ce2['associatedResources']=_[_0x3757('0x9')](_0x445916,function(_0x7fe7a4){return _0x7fe7a4[_0x3757('0xb')];});_0x4de354(_0x4d8ce2);})['catch'](function(_0x42dbad){_0x5d0c3c(_0x42dbad);});});}function _0x28414e(_0xced381,_0x3960a7,_0x154792){if(!_0x3960a7)return Promise[_0x3757('0xc')](null);return new Promise(function(_0x3c9afe,_0x181cb6){return _0x5b9e64[_0x3757('0xd')]['findAll']({'where':{'sectionId':_0x3960a7['id']},'raw':!![]})[_0x3757('0x7')](function(_0x4b6c24){if(_0xced381['field']&&_0xced381[_0x3757('0x4')]!=='id'){_0x3960a7[_0x3757('0x8')]=_[_0x3757('0x9')](_0x4b6c24,function(_0x5aae05){return _0x5aae05[_0xced381['field']];});}else{if(_0x154792===_0x3757('0xe')){_0x3960a7[_0x3757('0x8')]=_[_0x3757('0x9')](_0x4b6c24,function(_0x43d4a6){return{'id':_0x43d4a6['resourceId'],'type':_0x43d4a6[_0x3757('0xf')]};});}else{_0x3960a7['associatedResources']=_[_0x3757('0x9')](_0x4b6c24,function(_0x4e5fc5){return _0x4e5fc5['resourceId'];});}}_0x3c9afe(_0x3960a7);})[_0x3757('0x10')](function(_0x5e490b){_0x181cb6(_0x5e490b);});});}function _0x5cebee(_0x4d4384,_0x104586){var _0x2bc734={'parentSections':[]};switch(_0x4d4384[_0x3757('0x11')]()){case _0x3757('0x12'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x14');break;case _0x3757('0x15'):_0x2bc734[_0x3757('0x13')]='SquareOdbc';break;case _0x3757('0x16'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x17');_0x2bc734[_0x3757('0x18')]=[{'name':_0x3757('0x19'),'field':_0x3757('0xb'),'foreignKey':_0x3757('0x1a')}];break;case _0x3757('0x1b'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x1c');break;case _0x3757('0x1d'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x1e');_0x2bc734['parentSections']=[{'name':_0x3757('0x1f'),'field':'id','foreignKey':_0x3757('0x20')}];break;case _0x3757('0x21'):_0x2bc734[_0x3757('0x13')]='CmList';break;case _0x3757('0x22'):_0x2bc734['childModel']='CmCompany';break;case _0x3757('0x23'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x24');break;case _0x3757('0x25'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x26');break;case'chatwebsites':_0x2bc734[_0x3757('0x13')]=_0x3757('0x27');break;case _0x3757('0x28'):_0x2bc734[_0x3757('0x13')]='FaxQueue';break;case _0x3757('0x29'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x2a');break;case _0x3757('0x2b'):case'internalroutes':case _0x3757('0x2c'):_0x2bc734[_0x3757('0x13')]='VoiceExtension';break;case _0x3757('0x2d'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x2e');break;case _0x3757('0x2f'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x30');break;case'voicerecordings':_0x2bc734['childModel']=_0x3757('0x31');_0x2bc734[_0x3757('0x18')]=[{'name':_0x3757('0x32'),'field':'name','foreignKey':_0x3757('0x33'),'model':_0x3757('0x34'),'filter':{'field':_0x3757('0x35'),'value':['agent']}},{'name':'Telephones','field':_0x3757('0xb'),'foreignKey':'membername','model':_0x3757('0x34'),'filter':{'field':'role','value':[_0x3757('0x36')]}},{'name':_0x3757('0x37'),'field':_0x3757('0xb'),'foreignKey':'queue','model':_0x3757('0x38'),'filter':{'field':_0x3757('0xf'),'value':[_0x3757('0x39')]}},{'name':_0x3757('0x3a'),'field':_0x3757('0xb'),'foreignKey':'queue','model':_0x3757('0x38'),'filter':{'field':_0x3757('0xf'),'value':[_0x3757('0x3b')]}}];break;case'musiconholds':_0x2bc734[_0x3757('0x13')]=_0x3757('0x3c');break;case'chanspies':_0x2bc734[_0x3757('0x13')]=_0x3757('0x3d');break;case'voiceprefixes':_0x2bc734[_0x3757('0x13')]=_0x3757('0x3e');break;case _0x3757('0x3f'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x40');break;case _0x3757('0x41'):_0x2bc734['childModel']=_0x3757('0x42');break;case _0x3757('0x43'):_0x2bc734[_0x3757('0x13')]='MailAccount';break;case _0x3757('0x44'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x45');break;case _0x3757('0x46'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x47');break;case _0x3757('0x48'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x49');break;case'smsqueues':_0x2bc734[_0x3757('0x13')]=_0x3757('0x4a');break;case _0x3757('0x4b'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x4c');break;case _0x3757('0x4d'):_0x2bc734['childModel']=_0x3757('0x4e');break;case _0x3757('0x4f'):_0x2bc734['childModel']=_0x3757('0x50');break;case'teams':_0x2bc734['childModel']=_0x3757('0x51');break;case _0x3757('0x52'):case _0x3757('0x53'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x38');if(_0x104586){_0x2bc734[_0x3757('0x18')]=[{'name':_0x3757('0x37')},{'name':'QueueCampaigns'}];}break;case _0x3757('0x54'):case _0x3757('0x55'):case'telephones':_0x2bc734[_0x3757('0x13')]=_0x3757('0x34');if(_0x104586){_0x2bc734[_0x3757('0x18')]=[{'name':_0x3757('0x56'),'filter':{'field':_0x3757('0x35'),'value':[_0x3757('0x57'),_0x3757('0x58')]},'ignore':!![]},{'name':_0x3757('0x32')},{'name':_0x3757('0x59')}];}break;case _0x3757('0x5a'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x5b');break;case _0x3757('0x5c'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x5d');break;case'freshdeskaccounts':_0x2bc734[_0x3757('0x13')]=_0x3757('0x5e');break;case'sugarcrmaccounts':_0x2bc734[_0x3757('0x13')]=_0x3757('0x5f');break;case'deskaccounts':_0x2bc734[_0x3757('0x13')]=_0x3757('0x60');break;case'zohoaccounts':_0x2bc734['childModel']=_0x3757('0x61');break;case _0x3757('0x62'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x34');break;case _0x3757('0x63'):_0x2bc734[_0x3757('0x13')]='CannedAnswer';break;case _0x3757('0x64'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x65');break;case'customdashboards':_0x2bc734[_0x3757('0x13')]=_0x3757('0x66');break;case _0x3757('0x67'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x68');break;case _0x3757('0x69'):_0x2bc734[_0x3757('0x13')]='Pause';break;case _0x3757('0x6a'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x6b');break;case _0x3757('0x6c'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x6d');break;case _0x3757('0x6e'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x6f');break;case _0x3757('0x70'):_0x2bc734[_0x3757('0x13')]='Template';break;case'triggers':_0x2bc734[_0x3757('0x13')]=_0x3757('0x71');break;case _0x3757('0x72'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x73');break;case _0x3757('0x74'):_0x2bc734['childModel']='Variable';break;case _0x3757('0x75'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x76');break;case _0x3757('0x77'):_0x2bc734[_0x3757('0x13')]=_0x3757('0xe');_0x2bc734[_0x3757('0x18')]=[{'name':_0x3757('0x78'),'field':'id','foreignKey':'reportId'}];break;case _0x3757('0x79'):_0x2bc734[_0x3757('0x13')]=_0x3757('0x7a');break;}return _0x2bc734;}function _0x1f8917(_0x387cb1,_0x18e3f4){var _0x27fd6d=_0x387cb1[_0x3757('0x7b')](0x0)['toUpperCase']()+_0x387cb1[_0x3757('0x7c')](0x1);var _0x55e054={'type':_0x5b9e64[_0x3757('0x7d')]['QueryTypes'][_0x3757('0x7e')],'raw':!![]};return new Promise(function(_0x563cdb,_0x921360){var _0x21f40a=squel[_0x3757('0x7f')]()[_0x3757('0x4')]('ui.'+_0x27fd6d+_0x3757('0x80'),'id')[_0x3757('0x4')](_0x3757('0x81'))[_0x3757('0x82')]('user_has_'+_0x387cb1+_0x3757('0x83'),'ui')[_0x3757('0x84')]('ui.UserId\x20=\x20?',_0x18e3f4['id']);return _0x5b9e64[_0x3757('0x85')][_0x3757('0x86')](_0x21f40a[_0x3757('0x87')](),_0x55e054)['then'](function(_0x206f50){_0x18e3f4[_0x27fd6d+_0x3757('0x88')]=_0x206f50;_0x563cdb(_0x206f50);})[_0x3757('0x10')](function(_0x476ea0){_0x921360(_0x476ea0);});});}return _0x2804d0[_0x3757('0x89')](_0x3757('0x8a'),attributes,{'tableName':_0x3757('0x8b'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x5719fe){var _0x5e6d2e={'raw':_0x5719fe[_0x3757('0x86')]['raw'],'where':{}};var _0x5d5153={};var _0x48795e={'count':0x0,'rows':[]};var _0x57c326=_0x5719fe[_0x3757('0x86')]['section'];var _0x5f26b1=_0x5719fe['query'][_0x3757('0x8c')]||![];var _0x57a23b=_0x5cebee(_0x57c326,_0x5f26b1);if(!_0x57a23b[_0x3757('0x13')])throw new Error(_0x3757('0x8d')+_0x57c326+'\x27');var _0x2f22a3=[{'name':_0x57c326}];if(!_[_0x3757('0x8e')](_0x57a23b[_0x3757('0x18')]))_0x2f22a3=_0x57a23b['parentSections'];var _0x21290f=[];for(var _0x54acde=0x0;_0x54acde<_0x2f22a3['length'];_0x54acde++){_0x21290f[_0x3757('0x8f')](_0x5b9e64[_0x3757('0x90')][_0x3757('0x91')]({'where':{'userProfileId':_0x5719fe[_0x3757('0x92')]['id'],'name':_0x2f22a3[_0x54acde][_0x3757('0xb')]},'raw':!![]}));}return Promise[_0x3757('0x93')](_0x21290f)['then'](function(_0x30e9b3){var _0x4d6857=_[_0x3757('0x3')](_0x30e9b3,function(_0x4d9320){return _0x4d9320?_0x4d9320:undefined;});var _0x21e9dd=_['filter'](_0x2f22a3,['ignore',!![]]);var _0x37328b=_[_0x3757('0x8e')](_0x4d6857)&&_[_0x3757('0x8e')](_0x21e9dd)?null:_['union'](_0x21e9dd,_0x4d6857);if(!_0x37328b)return null;var _0x142c53=[];for(var _0x46f4a8=0x0;_0x46f4a8<_0x37328b[_0x3757('0x94')];_0x46f4a8++){var _0x78c811=_[_0x3757('0x91')](_0x2f22a3,function(_0x39b066){return _0x37328b[_0x46f4a8]?_0x39b066[_0x3757('0xb')]===_0x37328b[_0x46f4a8][_0x3757('0xb')]:null;});if(_0x78c811){if(_0x37328b[_0x46f4a8][_0x3757('0x95')]){_0x142c53['push'](_0x4fb117(_0x57a23b['childModel'],_0x37328b[_0x46f4a8]));}else{if(!_0x37328b[_0x46f4a8][_0x3757('0x96')]){_0x142c53[_0x3757('0x8f')](_0x28414e(_0x78c811,_0x37328b[_0x46f4a8],_0x57a23b[_0x3757('0x13')]));}else{if(_0x78c811['model']){_0x142c53[_0x3757('0x8f')](_0x2d6cc8(_0x78c811,_0x37328b[_0x46f4a8]));}}}}}return Promise[_0x3757('0x93')](_0x142c53);})[_0x3757('0x7')](function(_0x5e1016){var _0x22475b=_0x5e1016;var _0x13a226=null;if(_0x22475b){_0x13a226=_0x22475b['length']===0x1?_0x22475b[0x0]:null;}if(!_0x13a226&&!_0x22475b)return _0x48795e;var _0x305a2d=_0x5b9e64[_0x57a23b[_0x3757('0x13')]]['rawAttributes'];_0x5d5153['model']=_[_0x3757('0x97')](_0x305a2d);_0x5d5153[_0x3757('0x86')]=_['keys'](_0x5719fe[_0x3757('0x86')]);_0x5d5153[_0x3757('0x98')]=_['intersection'](_0x5d5153[_0x3757('0xa')],_0x5d5153[_0x3757('0x86')]);_0x5e6d2e['attributes']=_[_0x3757('0x99')](_0x5d5153['model'],qs[_0x3757('0x9a')](_0x5719fe['query'][_0x3757('0x9a')]));_0x5e6d2e[_0x3757('0x9b')]=_0x5e6d2e['attributes']['length']?_0x5e6d2e['attributes']:_0x5d5153[_0x3757('0xa')];if(!_0x5719fe['query'][_0x3757('0x9c')](_0x3757('0x9d'))){_0x5e6d2e[_0x3757('0x9e')]=qs['limit'](_0x5719fe[_0x3757('0x86')][_0x3757('0x9e')]);_0x5e6d2e[_0x3757('0x9f')]=qs[_0x3757('0x9f')](_0x5719fe['query'][_0x3757('0x9f')]);}_0x5e6d2e[_0x3757('0xa0')]=qs['sort'](_0x5719fe[_0x3757('0x86')]['sort']);_0x5e6d2e['where']=qs['filters'](_['pick'](_0x5719fe['query'],_0x5d5153[_0x3757('0x98')]));if(_0x5719fe[_0x3757('0x86')][_0x3757('0x3')]){_0x5e6d2e['where']=_['merge'](_0x5e6d2e[_0x3757('0x84')],{'$or':_[_0x3757('0x9')](_0x305a2d,function(_0x3209b0){if(_0x3209b0[_0x3757('0xf')][_0x3757('0xa1')]!=='VIRTUAL'){var _0x63eda8={};_0x63eda8[_0x3209b0[_0x3757('0x4')]]={'$like':'%'+_0x5719fe[_0x3757('0x86')][_0x3757('0x3')]+'%'};return _0x63eda8;}})});}var _0x23776e=[];var _0x15a942=null;var _0x8ba6ef={};if(_0x13a226){_0x15a942=_[_0x3757('0x91')](_0x2f22a3,['name',_0x13a226[_0x3757('0xb')]]);if(_0x15a942[_0x3757('0x4')]){_0x8ba6ef={};if(_0x57a23b['childModel']==='AnalyticExtractedReport'){_0x8ba6ef[_0x15a942[_0x3757('0xa2')]]=_[_0x3757('0x9')](_0x13a226[_0x3757('0x8')],'id');}else{_0x8ba6ef[_0x15a942[_0x3757('0xa2')]]=_0x13a226[_0x3757('0x8')];}_0x23776e[_0x3757('0x8f')](_0x8ba6ef);}else{_0x5e6d2e[_0x3757('0x84')]['id']=_0x13a226[_0x3757('0x8')];}}else{for(var _0x348d50=0x0;_0x348d50<_0x22475b[_0x3757('0x94')];_0x348d50++){_0x15a942=_['find'](_0x2f22a3,[_0x3757('0xb'),_0x22475b[_0x348d50][_0x3757('0xb')]]);if(_0x15a942[_0x3757('0x4')]){_0x8ba6ef={};_0x8ba6ef[_0x15a942['foreignKey']]=_0x22475b[_0x348d50][_0x3757('0x8')];_0x23776e[_0x3757('0x8f')](_0x8ba6ef);}else{if(!_0x5e6d2e[_0x3757('0x84')]['id'])_0x5e6d2e['where']['id']=[];_0x22475b[_0x348d50][_0x3757('0x8')][_0x3757('0xa3')](function(_0x522963){_0x5e6d2e[_0x3757('0x84')]['id']['push'](_0x522963);});}}}if(!_[_0x3757('0x8e')](_0x23776e)){_0x5e6d2e[_0x3757('0x84')]=_['merge'](_0x5e6d2e[_0x3757('0x84')],{'$and':{'$or':_0x23776e}});}_0x5e6d2e=_['merge']({},_0x5e6d2e,_0x5719fe['options']);if(_0x13a226&&!_0x13a226[_0x3757('0x96')]&&_0x57a23b[_0x3757('0x13')]===_0x3757('0xe')){if(_0x5719fe[_0x3757('0x86')][_0x3757('0xa4')]){_0x5e6d2e[_0x3757('0xa5')]=[{'all':!![]}];}return _0x5b9e64[_0x57a23b[_0x3757('0x13')]][_0x3757('0x6')](_0x5e6d2e)[_0x3757('0x7')](function(_0x2b1659){var _0x5f4df4=[];_0x2b1659[_0x3757('0xa3')](function(_0x1d458b){var _0x24c07c;switch(_0x1d458b[_0x3757('0xa6')]){case'default':_0x24c07c=_['find'](_0x13a226[_0x3757('0x8')],function(_0x43d6dc){return _0x43d6dc['id']===_0x1d458b['reportId']&&_0x43d6dc[_0x3757('0xf')]===_0x3757('0xa7');});break;case'custom':_0x24c07c=_[_0x3757('0x91')](_0x13a226['associatedResources'],function(_0x360c00){return _0x360c00['id']===_0x1d458b[_0x3757('0xa8')]&&_0x360c00[_0x3757('0xf')]==='CustomReports';});break;}if(_0x24c07c)_0x5f4df4[_0x3757('0x8f')](_0x1d458b);});_0x48795e[_0x3757('0xa9')]=_0x5f4df4[_0x3757('0x94')];_0x48795e[_0x3757('0xaa')]=_0x5f4df4;return _0x48795e;});}else{if(!_['isEmpty'](_0x5719fe[_0x3757('0x86')]['ids'])){_0x5e6d2e[_0x3757('0x84')]['id']=_0x5e6d2e[_0x3757('0x84')]['id']?_[_0x3757('0x99')](_0x5e6d2e[_0x3757('0x84')]['id'],_0x5719fe[_0x3757('0x86')][_0x3757('0xab')]):_0x5719fe[_0x3757('0x86')][_0x3757('0xab')];if(_0x5719fe[_0x3757('0x86')][_0x3757('0xac')]){_0x5e6d2e[_0x3757('0xa0')]=_0x5719fe[_0x3757('0x86')][_0x3757('0xac')];}}if(_0x5719fe['query']['extraQueryConditions']){_0x5e6d2e[_0x3757('0x84')]=_[_0x3757('0xad')](_0x5e6d2e[_0x3757('0x84')],{'$and':_0x5719fe[_0x3757('0x86')][_0x3757('0xae')]});}return _0x5b9e64[_0x57a23b['childModel']][_0x3757('0xa9')]({'where':_0x5e6d2e[_0x3757('0x84')]})[_0x3757('0x7')](function(_0x27039f){_0x48795e[_0x3757('0xa9')]=_0x27039f;if(_0x5719fe[_0x3757('0x86')][_0x3757('0xa4')]){if(_0x57a23b['childModel']===_0x3757('0x1e')){_0x5e6d2e[_0x3757('0xa5')]=[{'model':_0x5b9e64['Tag'],'as':'Tags','attributes':['id','name','color'],'required':_0x5719fe[_0x3757('0x86')][_0x3757('0xaf')]?!![]:![]},{'model':_0x5b9e64[_0x3757('0x6f')],'as':_0x3757('0xb0'),'attributes':['id','name','color'],'through':_0x5719fe[_0x3757('0x86')][_0x3757('0xaf')]?{'attributes':[],'where':{'TagId':_0x5719fe[_0x3757('0x86')]['tag']||undefined}}:{},'required':_0x5719fe['query'][_0x3757('0xaf')]?!![]:![]}];}else{_0x5e6d2e[_0x3757('0xa5')]=[{'all':!![]}];}}return _0x5b9e64[_0x57a23b[_0x3757('0x13')]][_0x3757('0x6')](_0x5e6d2e);})[_0x3757('0x7')](function(_0x180ba0){_0x48795e[_0x3757('0xaa')]=_0x180ba0;if(_0x57c326===_0x3757('0x32')&&_0x5719fe[_0x3757('0x86')]['openTabs']===_0x3757('0xb1')){var _0x34cddb=[];for(var _0x15ae5f=0x0;_0x15ae5f<_0x48795e['rows'][_0x3757('0x94')];_0x15ae5f++){_0x34cddb[_0x3757('0x8f')](_0x1f8917(_0x3757('0xb2'),_0x48795e[_0x3757('0xaa')][_0x15ae5f][_0x3757('0xb3')]));_0x34cddb[_0x3757('0x8f')](_0x1f8917(_0x3757('0xb4'),_0x48795e[_0x3757('0xaa')][_0x15ae5f][_0x3757('0xb3')]));_0x34cddb[_0x3757('0x8f')](_0x1f8917('fax',_0x48795e[_0x3757('0xaa')][_0x15ae5f][_0x3757('0xb3')]));_0x34cddb[_0x3757('0x8f')](_0x1f8917(_0x3757('0xb5'),_0x48795e[_0x3757('0xaa')][_0x15ae5f][_0x3757('0xb3')]));_0x34cddb[_0x3757('0x8f')](_0x1f8917(_0x3757('0xb6'),_0x48795e[_0x3757('0xaa')][_0x15ae5f][_0x3757('0xb3')]));_0x34cddb[_0x3757('0x8f')](_0x1f8917(_0x3757('0xb7'),_0x48795e[_0x3757('0xaa')][_0x15ae5f][_0x3757('0xb3')]));}return Promise['all'](_0x34cddb)[_0x3757('0x7')](function(){return _0x48795e;});}return _0x48795e;});}});}}});};