Built motion from commit 994c64e1.|2.6.1
[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 _0x1775=['MailQueue','mailaccounts','MailAccount','mailsubstatuses','openchannelqueues','openchannelaccounts','smsqueues','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','teams','Team','voicequeues','queuecampaigns','users','agents','telephones','Users','user','ZendeskAccount','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','deskaccounts','DeskAccount','ZohoAccount','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','scheduler','Schedule','sounds','Tag','templates','Trigger','trunks','variables','Variable','Plugin','extractedreports','Reports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','SELECT','select','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','UserProfile','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','find','params','all','union','push','autoAssociation','keys','filters','intersection','fields','attributes','nolimit','limit','offset','order','sort','pick','merge','key','VIRTUAL','foreignKey','forEach','includeAll','include','default','DefaultReports','CustomReports','count','rows','ids','CmContact','Tags','color','ThroughTags','tag','true','chat','dataValues','sms','mail','openchannel','whatsapp','./userProfile.attributes','../../components/parsers/qs','squel','exports','models','filter','field','value','findAll','then','associatedResources','model','map','name','catch','resolve','UserProfileResource','AnalyticExtractedReport','resourceId','type','toLowerCase','childModel','SquareOdbc','parentSections','SquareProjects','projectName','projects','JscriptyProject','contacts','Lists','ListId','lists','CmList','companies','CmCompany','CmCustomField','chatwebsites','ChatWebsite','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','contexts','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','membername','User','role','agent','Telephones','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','VoicePrefix','ivrcampaigns','mailqueues'];(function(_0x195aac,_0x10d0b1){var _0x215089=function(_0x4a60e2){while(--_0x4a60e2){_0x195aac['push'](_0x195aac['shift']());}};_0x215089(++_0x10d0b1);}(_0x1775,0x1db));var _0x5177=function(_0x3947c9,_0x4d6c97){_0x3947c9=_0x3947c9-0x0;var _0x2e7871=_0x1775[_0x3947c9];return _0x2e7871;};'use strict';var _=require('lodash');var attributes=require(_0x5177('0x0'));var qs=require(_0x5177('0x1'));var squel=require(_0x5177('0x2'));module[_0x5177('0x3')]=function(_0xaad33e){var _0x38ee08=_0xaad33e[_0x5177('0x4')];function _0x2027bf(_0x359401,_0x51275f){return new Promise(function(_0x159a20,_0x2c5c42){if(!_0x51275f)return _0x159a20(null);var _0x153c1a=_0x51275f[_0x5177('0x5')]?{[_0x51275f[_0x5177('0x5')][_0x5177('0x6')]]:_0x51275f[_0x5177('0x5')][_0x5177('0x7')]}:undefined;return _0x38ee08[_0x359401][_0x5177('0x8')]({'where':_0x153c1a,'raw':!![]})[_0x5177('0x9')](function(_0x2c23d8){_0x51275f[_0x5177('0xa')]=_['map'](_0x2c23d8,'id');_0x159a20(_0x51275f);})['catch'](function(_0x13c7f6){_0x2c5c42(_0x13c7f6);});});}function _0x1d7116(_0xf3ce11,_0x227316){return new Promise(function(_0x301db2,_0x49704c){var _0x18f567=_0xf3ce11[_0x5177('0x5')]?{[_0xf3ce11[_0x5177('0x5')][_0x5177('0x6')]]:_0xf3ce11[_0x5177('0x5')][_0x5177('0x7')]}:undefined;return _0x38ee08[_0xf3ce11[_0x5177('0xb')]][_0x5177('0x8')]({'where':_0x18f567,'raw':!![]})[_0x5177('0x9')](function(_0x1eb9dd){_0x227316[_0x5177('0xa')]=_[_0x5177('0xc')](_0x1eb9dd,function(_0x29cd2c){return _0x29cd2c[_0x5177('0xd')];});_0x301db2(_0x227316);})[_0x5177('0xe')](function(_0x175ca6){_0x49704c(_0x175ca6);});});}function _0x2ab5e5(_0x7dba6f,_0xe6dcf6,_0x50ce2c){if(!_0xe6dcf6)return Promise[_0x5177('0xf')](null);return new Promise(function(_0x41e687,_0x3f5ab5){return _0x38ee08[_0x5177('0x10')]['findAll']({'where':{'sectionId':_0xe6dcf6['id']},'raw':!![]})[_0x5177('0x9')](function(_0x2ebf91){if(_0x7dba6f[_0x5177('0x6')]&&_0x7dba6f['field']!=='id'){_0xe6dcf6[_0x5177('0xa')]=_['map'](_0x2ebf91,function(_0xc2b2b5){return _0xc2b2b5[_0x7dba6f[_0x5177('0x6')]];});}else{if(_0x50ce2c===_0x5177('0x11')){_0xe6dcf6[_0x5177('0xa')]=_[_0x5177('0xc')](_0x2ebf91,function(_0x3314f2){return{'id':_0x3314f2[_0x5177('0x12')],'type':_0x3314f2[_0x5177('0x13')]};});}else{_0xe6dcf6[_0x5177('0xa')]=_[_0x5177('0xc')](_0x2ebf91,function(_0x23dad2){return _0x23dad2[_0x5177('0x12')];});}}_0x41e687(_0xe6dcf6);})['catch'](function(_0x3dcea1){_0x3f5ab5(_0x3dcea1);});});}function _0x556f96(_0x30b60f,_0x2c68d8){var _0x3b39b5={'parentSections':[]};switch(_0x30b60f[_0x5177('0x14')]()){case'squareprojects':_0x3b39b5[_0x5177('0x15')]='SquareProject';break;case'odbc':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x16');break;case'squarerecordings':_0x3b39b5[_0x5177('0x15')]='SquareRecording';_0x3b39b5[_0x5177('0x17')]=[{'name':_0x5177('0x18'),'field':'name','foreignKey':_0x5177('0x19')}];break;case _0x5177('0x1a'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x1b');break;case _0x5177('0x1c'):_0x3b39b5[_0x5177('0x15')]='CmContact';_0x3b39b5['parentSections']=[{'name':_0x5177('0x1d'),'field':'id','foreignKey':_0x5177('0x1e')}];break;case _0x5177('0x1f'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x20');break;case _0x5177('0x21'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x22');break;case'globalcustomfields':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x23');break;case'chatqueues':_0x3b39b5[_0x5177('0x15')]='ChatQueue';break;case _0x5177('0x24'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x25');break;case'faxqueues':_0x3b39b5['childModel']=_0x5177('0x26');break;case _0x5177('0x27'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x28');break;case _0x5177('0x29'):case _0x5177('0x2a'):case _0x5177('0x2b'):_0x3b39b5[_0x5177('0x15')]='VoiceExtension';break;case _0x5177('0x2c'):_0x3b39b5[_0x5177('0x15')]='VoiceContext';break;case _0x5177('0x2d'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x2e');break;case _0x5177('0x2f'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x30');_0x3b39b5['parentSections']=[{'name':_0x5177('0x31'),'field':_0x5177('0xd'),'foreignKey':_0x5177('0x32'),'model':_0x5177('0x33'),'filter':{'field':_0x5177('0x34'),'value':[_0x5177('0x35')]}},{'name':_0x5177('0x36'),'field':'name','foreignKey':_0x5177('0x32'),'model':_0x5177('0x33'),'filter':{'field':'role','value':['telephone']}},{'name':_0x5177('0x37'),'field':_0x5177('0xd'),'foreignKey':_0x5177('0x38'),'model':_0x5177('0x39'),'filter':{'field':_0x5177('0x13'),'value':[_0x5177('0x3a')]}},{'name':_0x5177('0x3b'),'field':_0x5177('0xd'),'foreignKey':_0x5177('0x38'),'model':_0x5177('0x39'),'filter':{'field':_0x5177('0x13'),'value':[_0x5177('0x3c')]}}];break;case _0x5177('0x3d'):_0x3b39b5['childModel']=_0x5177('0x3e');break;case _0x5177('0x3f'):_0x3b39b5['childModel']=_0x5177('0x40');break;case'voiceprefixes':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x41');break;case _0x5177('0x42'):_0x3b39b5['childModel']='Campaign';break;case _0x5177('0x43'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x44');break;case _0x5177('0x45'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x46');break;case _0x5177('0x47'):_0x3b39b5[_0x5177('0x15')]='MailSubstatus';break;case _0x5177('0x48'):_0x3b39b5['childModel']='OpenchannelQueue';break;case _0x5177('0x49'):_0x3b39b5[_0x5177('0x15')]='OpenchannelAccount';break;case _0x5177('0x4a'):_0x3b39b5['childModel']='SmsQueue';break;case _0x5177('0x4b'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x4c');break;case _0x5177('0x4d'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x4e');break;case _0x5177('0x4f'):_0x3b39b5['childModel']='WhatsappAccount';break;case _0x5177('0x50'):_0x3b39b5['childModel']=_0x5177('0x51');break;case _0x5177('0x52'):case _0x5177('0x53'):_0x3b39b5[_0x5177('0x15')]='VoiceQueue';if(_0x2c68d8){_0x3b39b5[_0x5177('0x17')]=[{'name':_0x5177('0x37')},{'name':_0x5177('0x3b')}];}break;case _0x5177('0x54'):case _0x5177('0x55'):case _0x5177('0x56'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x33');if(_0x2c68d8){_0x3b39b5[_0x5177('0x17')]=[{'name':_0x5177('0x57'),'filter':{'field':_0x5177('0x34'),'value':['admin',_0x5177('0x58')]},'ignore':!![]},{'name':'Agents'},{'name':'Telephones'}];}break;case'zendeskaccounts':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x59');break;case'salesforceaccounts':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x5a');break;case _0x5177('0x5b'):_0x3b39b5['childModel']=_0x5177('0x5c');break;case'sugarcrmaccounts':_0x3b39b5['childModel']='SugarcrmAccount';break;case _0x5177('0x5d'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x5e');break;case'zohoaccounts':_0x3b39b5['childModel']=_0x5177('0x5f');break;case'vtigeraccounts':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x33');break;case _0x5177('0x60'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x61');break;case _0x5177('0x62'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x63');break;case _0x5177('0x64'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x65');break;case _0x5177('0x66'):_0x3b39b5[_0x5177('0x15')]='Interval';break;case'pauses':_0x3b39b5[_0x5177('0x15')]='Pause';break;case _0x5177('0x67'):_0x3b39b5['childModel']=_0x5177('0x68');break;case _0x5177('0x69'):_0x3b39b5[_0x5177('0x15')]='Sound';break;case'tags':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x6a');break;case _0x5177('0x6b'):_0x3b39b5[_0x5177('0x15')]='Template';break;case'triggers':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x6c');break;case _0x5177('0x6d'):_0x3b39b5[_0x5177('0x15')]='Trunk';break;case _0x5177('0x6e'):_0x3b39b5[_0x5177('0x15')]=_0x5177('0x6f');break;case'plugins':_0x3b39b5[_0x5177('0x15')]=_0x5177('0x70');break;case _0x5177('0x71'):_0x3b39b5['childModel']=_0x5177('0x11');_0x3b39b5['parentSections']=[{'name':_0x5177('0x72'),'field':'id','foreignKey':_0x5177('0x73')}];break;case _0x5177('0x74'):_0x3b39b5['childModel']=_0x5177('0x75');break;}return _0x3b39b5;}function _0x161e03(_0xea44e,_0xc789e8){var _0xc7a59e=_0xea44e[_0x5177('0x76')](0x0)[_0x5177('0x77')]()+_0xea44e[_0x5177('0x78')](0x1);var _0x5ceed2={'type':_0x38ee08['Sequelize']['QueryTypes'][_0x5177('0x79')],'raw':!![]};return new Promise(function(_0x18222f,_0x35aa22){var _0x75cc0e=squel[_0x5177('0x7a')]()[_0x5177('0x6')]('ui.'+_0xc7a59e+'InteractionId','id')[_0x5177('0x6')](_0x5177('0x7b'))[_0x5177('0x7c')](_0x5177('0x7d')+_0xea44e+_0x5177('0x7e'),'ui')[_0x5177('0x7f')](_0x5177('0x80'),_0xc789e8['id']);return _0x38ee08[_0x5177('0x81')][_0x5177('0x82')](_0x75cc0e['toString'](),_0x5ceed2)[_0x5177('0x9')](function(_0x25a0be){_0xc789e8[_0xc7a59e+'OpenTabs']=_0x25a0be;_0x18222f(_0x25a0be);})[_0x5177('0xe')](function(_0x4481b6){_0x35aa22(_0x4481b6);});});}return _0xaad33e['define'](_0x5177('0x83'),attributes,{'tableName':_0x5177('0x84'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x11a63c){var _0x4be4b2={'raw':_0x11a63c[_0x5177('0x82')][_0x5177('0x85')],'where':{}};var _0x5f5bd5={};var _0x52a6c2={'count':0x0,'rows':[]};var _0x102c27=_0x11a63c['query'][_0x5177('0x86')];var _0x53f599=_0x11a63c[_0x5177('0x82')][_0x5177('0x87')]||![];var _0x5a8ada=_0x556f96(_0x102c27,_0x53f599);if(!_0x5a8ada[_0x5177('0x15')])throw new Error(_0x5177('0x88')+_0x102c27+'\x27');var _0x1975a3=[{'name':_0x102c27}];if(!_[_0x5177('0x89')](_0x5a8ada[_0x5177('0x17')]))_0x1975a3=_0x5a8ada[_0x5177('0x17')];var _0x20d476=[];for(var _0x58ebdd=0x0;_0x58ebdd<_0x1975a3[_0x5177('0x8a')];_0x58ebdd++){_0x20d476['push'](_0x38ee08['UserProfileSection'][_0x5177('0x8b')]({'where':{'userProfileId':_0x11a63c[_0x5177('0x8c')]['id'],'name':_0x1975a3[_0x58ebdd]['name']},'raw':!![]}));}return Promise[_0x5177('0x8d')](_0x20d476)[_0x5177('0x9')](function(_0x43abdd){var _0x9087e0=_[_0x5177('0x5')](_0x43abdd,function(_0x128cab){return _0x128cab?_0x128cab:undefined;});var _0xe22e2a=_[_0x5177('0x5')](_0x1975a3,['ignore',!![]]);var _0x54b28f=_[_0x5177('0x89')](_0x9087e0)&&_[_0x5177('0x89')](_0xe22e2a)?null:_[_0x5177('0x8e')](_0xe22e2a,_0x9087e0);if(!_0x54b28f)return null;var _0x2d24b3=[];for(var _0x3de0b5=0x0;_0x3de0b5<_0x54b28f[_0x5177('0x8a')];_0x3de0b5++){var _0x4fc289=_[_0x5177('0x8b')](_0x1975a3,function(_0x397b75){return _0x54b28f[_0x3de0b5]?_0x397b75[_0x5177('0xd')]===_0x54b28f[_0x3de0b5][_0x5177('0xd')]:null;});if(_0x4fc289){if(_0x54b28f[_0x3de0b5]['ignore']){_0x2d24b3[_0x5177('0x8f')](_0x2027bf(_0x5a8ada[_0x5177('0x15')],_0x54b28f[_0x3de0b5]));}else{if(!_0x54b28f[_0x3de0b5][_0x5177('0x90')]){_0x2d24b3[_0x5177('0x8f')](_0x2ab5e5(_0x4fc289,_0x54b28f[_0x3de0b5],_0x5a8ada[_0x5177('0x15')]));}else{if(_0x4fc289['model']){_0x2d24b3[_0x5177('0x8f')](_0x1d7116(_0x4fc289,_0x54b28f[_0x3de0b5]));}}}}}return Promise['all'](_0x2d24b3);})[_0x5177('0x9')](function(_0x2ac8f0){var _0x5e3554=_0x2ac8f0;var _0x67d605=null;if(_0x5e3554){_0x67d605=_0x5e3554[_0x5177('0x8a')]===0x1?_0x5e3554[0x0]:null;}if(!_0x67d605&&!_0x5e3554)return _0x52a6c2;var _0x367784=_0x38ee08[_0x5a8ada[_0x5177('0x15')]]['rawAttributes'];_0x5f5bd5[_0x5177('0xb')]=_[_0x5177('0x91')](_0x367784);_0x5f5bd5[_0x5177('0x82')]=_[_0x5177('0x91')](_0x11a63c['query']);_0x5f5bd5[_0x5177('0x92')]=_[_0x5177('0x93')](_0x5f5bd5[_0x5177('0xb')],_0x5f5bd5['query']);_0x4be4b2['attributes']=_[_0x5177('0x93')](_0x5f5bd5[_0x5177('0xb')],qs[_0x5177('0x94')](_0x11a63c[_0x5177('0x82')][_0x5177('0x94')]));_0x4be4b2[_0x5177('0x95')]=_0x4be4b2[_0x5177('0x95')][_0x5177('0x8a')]?_0x4be4b2[_0x5177('0x95')]:_0x5f5bd5['model'];if(!_0x11a63c['query']['hasOwnProperty'](_0x5177('0x96'))){_0x4be4b2['limit']=qs[_0x5177('0x97')](_0x11a63c[_0x5177('0x82')][_0x5177('0x97')]);_0x4be4b2[_0x5177('0x98')]=qs[_0x5177('0x98')](_0x11a63c['query'][_0x5177('0x98')]);}_0x4be4b2[_0x5177('0x99')]=qs[_0x5177('0x9a')](_0x11a63c['query'][_0x5177('0x9a')]);_0x4be4b2['where']=qs[_0x5177('0x92')](_[_0x5177('0x9b')](_0x11a63c['query'],_0x5f5bd5[_0x5177('0x92')]));if(_0x11a63c[_0x5177('0x82')]['filter']){_0x4be4b2['where']=_[_0x5177('0x9c')](_0x4be4b2['where'],{'$or':_[_0x5177('0xc')](_0x367784,function(_0x2f4edb){if(_0x2f4edb['type'][_0x5177('0x9d')]!==_0x5177('0x9e')){var _0xcbbb73={};_0xcbbb73[_0x2f4edb[_0x5177('0x6')]]={'$like':'%'+_0x11a63c[_0x5177('0x82')][_0x5177('0x5')]+'%'};return _0xcbbb73;}})});}var _0xbc8f9f=[];var _0x10b062=null;var _0x488c62={};if(_0x67d605){_0x10b062=_[_0x5177('0x8b')](_0x1975a3,['name',_0x67d605[_0x5177('0xd')]]);if(_0x10b062[_0x5177('0x6')]){_0x488c62={};if(_0x5a8ada[_0x5177('0x15')]===_0x5177('0x11')){_0x488c62[_0x10b062['foreignKey']]=_[_0x5177('0xc')](_0x67d605[_0x5177('0xa')],'id');}else{_0x488c62[_0x10b062['foreignKey']]=_0x67d605[_0x5177('0xa')];}_0xbc8f9f[_0x5177('0x8f')](_0x488c62);}else{_0x4be4b2['where']['id']=_0x67d605[_0x5177('0xa')];}}else{for(var _0x5f57bc=0x0;_0x5f57bc<_0x5e3554[_0x5177('0x8a')];_0x5f57bc++){_0x10b062=_['find'](_0x1975a3,['name',_0x5e3554[_0x5f57bc]['name']]);if(_0x10b062[_0x5177('0x6')]){_0x488c62={};_0x488c62[_0x10b062[_0x5177('0x9f')]]=_0x5e3554[_0x5f57bc][_0x5177('0xa')];_0xbc8f9f['push'](_0x488c62);}else{if(!_0x4be4b2[_0x5177('0x7f')]['id'])_0x4be4b2[_0x5177('0x7f')]['id']=[];_0x5e3554[_0x5f57bc][_0x5177('0xa')][_0x5177('0xa0')](function(_0x42446a){_0x4be4b2['where']['id'][_0x5177('0x8f')](_0x42446a);});}}}if(!_[_0x5177('0x89')](_0xbc8f9f)){_0x4be4b2['where']=_[_0x5177('0x9c')](_0x4be4b2['where'],{'$and':{'$or':_0xbc8f9f}});}_0x4be4b2=_[_0x5177('0x9c')]({},_0x4be4b2,_0x11a63c['options']);if(_0x67d605&&!_0x67d605[_0x5177('0x90')]&&_0x5a8ada[_0x5177('0x15')]===_0x5177('0x11')){if(_0x11a63c[_0x5177('0x82')][_0x5177('0xa1')]){_0x4be4b2[_0x5177('0xa2')]=[{'all':!![]}];}return _0x38ee08[_0x5a8ada['childModel']]['findAll'](_0x4be4b2)[_0x5177('0x9')](function(_0x4358e6){var _0x1e9708=[];_0x4358e6['forEach'](function(_0x405b03){var _0x2f2939;switch(_0x405b03['reportType']){case _0x5177('0xa3'):_0x2f2939=_['find'](_0x67d605[_0x5177('0xa')],function(_0x134b2f){return _0x134b2f['id']===_0x405b03[_0x5177('0x73')]&&_0x134b2f['type']===_0x5177('0xa4');});break;case'custom':_0x2f2939=_[_0x5177('0x8b')](_0x67d605[_0x5177('0xa')],function(_0x5a40f1){return _0x5a40f1['id']===_0x405b03['reportId']&&_0x5a40f1['type']===_0x5177('0xa5');});break;}if(_0x2f2939)_0x1e9708['push'](_0x405b03);});_0x52a6c2[_0x5177('0xa6')]=_0x1e9708[_0x5177('0x8a')];_0x52a6c2[_0x5177('0xa7')]=_0x1e9708;return _0x52a6c2;});}else{if(!_['isEmpty'](_0x11a63c['query']['ids'])){_0x4be4b2[_0x5177('0x7f')]['id']=_0x4be4b2[_0x5177('0x7f')]['id']?_[_0x5177('0x93')](_0x4be4b2['where']['id'],_0x11a63c[_0x5177('0x82')][_0x5177('0xa8')]):_0x11a63c['query'][_0x5177('0xa8')];}return _0x38ee08[_0x5a8ada['childModel']][_0x5177('0xa6')]({'where':_0x4be4b2['where']})['then'](function(_0x5910a8){_0x52a6c2[_0x5177('0xa6')]=_0x5910a8;if(_0x11a63c['query'][_0x5177('0xa1')]){if(_0x5a8ada[_0x5177('0x15')]===_0x5177('0xa9')){_0x4be4b2[_0x5177('0xa2')]=[{'model':_0x38ee08[_0x5177('0x6a')],'as':_0x5177('0xaa'),'attributes':['id','name',_0x5177('0xab')],'required':_0x11a63c[_0x5177('0x82')]['tag']?!![]:![]},{'model':_0x38ee08[_0x5177('0x6a')],'as':_0x5177('0xac'),'attributes':['id',_0x5177('0xd'),'color'],'through':_0x11a63c['query']['tag']?{'attributes':[],'where':{'TagId':_0x11a63c[_0x5177('0x82')][_0x5177('0xad')]||undefined}}:{},'required':_0x11a63c[_0x5177('0x82')][_0x5177('0xad')]?!![]:![]}];}else{_0x4be4b2[_0x5177('0xa2')]=[{'all':!![]}];}}return _0x38ee08[_0x5a8ada[_0x5177('0x15')]][_0x5177('0x8')](_0x4be4b2);})[_0x5177('0x9')](function(_0x2dc137){_0x52a6c2[_0x5177('0xa7')]=_0x2dc137;if(_0x102c27===_0x5177('0x31')&&_0x11a63c[_0x5177('0x82')]['openTabs']===_0x5177('0xae')){var _0x5d05e8=[];for(var _0x2f254e=0x0;_0x2f254e<_0x52a6c2[_0x5177('0xa7')][_0x5177('0x8a')];_0x2f254e++){_0x5d05e8['push'](_0x161e03(_0x5177('0xaf'),_0x52a6c2[_0x5177('0xa7')][_0x2f254e][_0x5177('0xb0')]));_0x5d05e8[_0x5177('0x8f')](_0x161e03(_0x5177('0xb1'),_0x52a6c2[_0x5177('0xa7')][_0x2f254e][_0x5177('0xb0')]));_0x5d05e8[_0x5177('0x8f')](_0x161e03('fax',_0x52a6c2['rows'][_0x2f254e][_0x5177('0xb0')]));_0x5d05e8['push'](_0x161e03(_0x5177('0xb2'),_0x52a6c2[_0x5177('0xa7')][_0x2f254e]['dataValues']));_0x5d05e8[_0x5177('0x8f')](_0x161e03(_0x5177('0xb3'),_0x52a6c2['rows'][_0x2f254e][_0x5177('0xb0')]));_0x5d05e8[_0x5177('0x8f')](_0x161e03(_0x5177('0xb4'),_0x52a6c2[_0x5177('0xa7')][_0x2f254e][_0x5177('0xb0')]));}return Promise[_0x5177('0x8d')](_0x5d05e8)[_0x5177('0x9')](function(){return _0x52a6c2;});}return _0x52a6c2;});}});}}});};