5380477e33539f51f6d4b9420f109d1b7edc0d62
[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 _0x3fc2=['UserProfileSection','find','params','all','ignore','union','model','rawAttributes','keys','filters','attributes','fields','hasOwnProperty','limit','offset','order','sort','pick','key','VIRTUAL','forEach','merge','options','autoAssociation','includeAll','reportType','default','DefaultReports','CustomReports','count','intersection','ids','customSorting','Tag','Tags','color','tag','include','rows','openTabs','true','dataValues','sms','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','../../components/parsers/qs','exports','models','filter','field','findAll','associatedResources','map','catch','value','then','name','resolve','UserProfileResource','AnalyticExtractedReport','type','resourceId','toLowerCase','SquareProject','odbc','childModel','SquareOdbc','squarerecordings','SquareRecording','parentSections','projectName','projects','JscriptyProject','contacts','CmContact','Lists','ListId','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','ChatWebsite','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','VoiceMail','Agents','membername','User','role','agent','Telephones','telephone','VoiceQueues','queue','VoiceQueue','inbound','outbound','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','mailqueues','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','SmsAccount','WhatsappQueue','whatsappaccounts','WhatsappAccount','Team','QueueCampaigns','users','agents','telephones','Users','admin','zendeskaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','deskaccounts','DeskAccount','vtigeraccounts','CannedAnswer','dispositions','Dashboard','Pause','scheduler','Schedule','sounds','Sound','tags','templates','triggers','Trunk','Variable','plugins','Reports','reportId','metrics','AnalyticMetric','Sequelize','QueryTypes','ui.','InteractionId','from','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','define','UserProfile','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','push'];(function(_0x4ef5c3,_0x3c8cda){var _0x263741=function(_0x119cff){while(--_0x119cff){_0x4ef5c3['push'](_0x4ef5c3['shift']());}};_0x263741(++_0x3c8cda);}(_0x3fc2,0x1a5));var _0x23fc=function(_0xaa1154,_0x1a9958){_0xaa1154=_0xaa1154-0x0;var _0x3c08cf=_0x3fc2[_0xaa1154];return _0x3c08cf;};'use strict';var _=require(_0x23fc('0x0'));var attributes=require(_0x23fc('0x1'));var qs=require(_0x23fc('0x2'));var squel=require('squel');module[_0x23fc('0x3')]=function(_0x17578b){var _0x179e49=_0x17578b[_0x23fc('0x4')];function _0x48471c(_0x4dd3e8,_0x2b3963){return new Promise(function(_0x2c5bb5,_0x50ff38){if(!_0x2b3963)return _0x2c5bb5(null);var _0x1c54f9=_0x2b3963['filter']?{[_0x2b3963[_0x23fc('0x5')][_0x23fc('0x6')]]:_0x2b3963['filter']['value']}:undefined;return _0x179e49[_0x4dd3e8][_0x23fc('0x7')]({'where':_0x1c54f9,'raw':!![]})['then'](function(_0x569fe0){_0x2b3963[_0x23fc('0x8')]=_[_0x23fc('0x9')](_0x569fe0,'id');_0x2c5bb5(_0x2b3963);})[_0x23fc('0xa')](function(_0x403b09){_0x50ff38(_0x403b09);});});}function _0x453620(_0x585a9a,_0x37a429){return new Promise(function(_0x429b80,_0x185dcf){var _0x2a86b1=_0x585a9a[_0x23fc('0x5')]?{[_0x585a9a['filter'][_0x23fc('0x6')]]:_0x585a9a['filter'][_0x23fc('0xb')]}:undefined;return _0x179e49[_0x585a9a['model']][_0x23fc('0x7')]({'where':_0x2a86b1,'raw':!![]})[_0x23fc('0xc')](function(_0x1e81b8){_0x37a429[_0x23fc('0x8')]=_['map'](_0x1e81b8,function(_0x3fbf96){return _0x3fbf96[_0x23fc('0xd')];});_0x429b80(_0x37a429);})[_0x23fc('0xa')](function(_0x341ad7){_0x185dcf(_0x341ad7);});});}function _0x295025(_0x16d177,_0x314328,_0x502903){if(!_0x314328)return Promise[_0x23fc('0xe')](null);return new Promise(function(_0x3dc838,_0x5a7225){return _0x179e49[_0x23fc('0xf')][_0x23fc('0x7')]({'where':{'sectionId':_0x314328['id']},'raw':!![]})[_0x23fc('0xc')](function(_0x354893){if(_0x16d177['field']&&_0x16d177[_0x23fc('0x6')]!=='id'){_0x314328[_0x23fc('0x8')]=_['map'](_0x354893,function(_0xbd279b){return _0xbd279b[_0x16d177[_0x23fc('0x6')]];});}else{if(_0x502903===_0x23fc('0x10')){_0x314328['associatedResources']=_[_0x23fc('0x9')](_0x354893,function(_0x540044){return{'id':_0x540044['resourceId'],'type':_0x540044[_0x23fc('0x11')]};});}else{_0x314328[_0x23fc('0x8')]=_[_0x23fc('0x9')](_0x354893,function(_0x5602a6){return _0x5602a6[_0x23fc('0x12')];});}}_0x3dc838(_0x314328);})[_0x23fc('0xa')](function(_0x379b9c){_0x5a7225(_0x379b9c);});});}function _0x2bbf98(_0x78f8af,_0x213980){var _0x32ad38={'parentSections':[]};switch(_0x78f8af[_0x23fc('0x13')]()){case'squareprojects':_0x32ad38['childModel']=_0x23fc('0x14');break;case _0x23fc('0x15'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x17');break;case _0x23fc('0x18'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x19');_0x32ad38[_0x23fc('0x1a')]=[{'name':'SquareProjects','field':_0x23fc('0xd'),'foreignKey':_0x23fc('0x1b')}];break;case _0x23fc('0x1c'):_0x32ad38['childModel']=_0x23fc('0x1d');break;case _0x23fc('0x1e'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x1f');_0x32ad38['parentSections']=[{'name':_0x23fc('0x20'),'field':'id','foreignKey':_0x23fc('0x21')}];break;case'lists':_0x32ad38[_0x23fc('0x16')]='CmList';break;case _0x23fc('0x22'):_0x32ad38['childModel']=_0x23fc('0x23');break;case _0x23fc('0x24'):_0x32ad38['childModel']=_0x23fc('0x25');break;case _0x23fc('0x26'):_0x32ad38['childModel']=_0x23fc('0x27');break;case'chatwebsites':_0x32ad38['childModel']=_0x23fc('0x28');break;case _0x23fc('0x29'):_0x32ad38['childModel']=_0x23fc('0x2a');break;case _0x23fc('0x2b'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x2c');break;case _0x23fc('0x2d'):case _0x23fc('0x2e'):case _0x23fc('0x2f'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x30');break;case _0x23fc('0x31'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x32');break;case _0x23fc('0x33'):_0x32ad38['childModel']=_0x23fc('0x34');break;case'voicerecordings':_0x32ad38[_0x23fc('0x16')]='VoiceRecording';_0x32ad38[_0x23fc('0x1a')]=[{'name':_0x23fc('0x35'),'field':'name','foreignKey':_0x23fc('0x36'),'model':_0x23fc('0x37'),'filter':{'field':_0x23fc('0x38'),'value':[_0x23fc('0x39')]}},{'name':_0x23fc('0x3a'),'field':_0x23fc('0xd'),'foreignKey':_0x23fc('0x36'),'model':_0x23fc('0x37'),'filter':{'field':_0x23fc('0x38'),'value':[_0x23fc('0x3b')]}},{'name':_0x23fc('0x3c'),'field':_0x23fc('0xd'),'foreignKey':_0x23fc('0x3d'),'model':_0x23fc('0x3e'),'filter':{'field':'type','value':[_0x23fc('0x3f')]}},{'name':'QueueCampaigns','field':'name','foreignKey':_0x23fc('0x3d'),'model':_0x23fc('0x3e'),'filter':{'field':_0x23fc('0x11'),'value':[_0x23fc('0x40')]}}];break;case'musiconholds':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x41');break;case _0x23fc('0x42'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x43');break;case _0x23fc('0x44'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x45');break;case _0x23fc('0x46'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x47');break;case _0x23fc('0x48'):_0x32ad38[_0x23fc('0x16')]='MailQueue';break;case _0x23fc('0x49'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x4a');break;case _0x23fc('0x4b'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x4c');break;case'openchannelqueues':_0x32ad38['childModel']=_0x23fc('0x4d');break;case _0x23fc('0x4e'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x4f');break;case _0x23fc('0x50'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x51');break;case'smsaccounts':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x52');break;case'whatsappqueues':_0x32ad38['childModel']=_0x23fc('0x53');break;case _0x23fc('0x54'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x55');break;case'teams':_0x32ad38['childModel']=_0x23fc('0x56');break;case'voicequeues':case'queuecampaigns':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x3e');if(_0x213980){_0x32ad38[_0x23fc('0x1a')]=[{'name':'VoiceQueues'},{'name':_0x23fc('0x57')}];}break;case _0x23fc('0x58'):case _0x23fc('0x59'):case _0x23fc('0x5a'):_0x32ad38['childModel']=_0x23fc('0x37');if(_0x213980){_0x32ad38[_0x23fc('0x1a')]=[{'name':_0x23fc('0x5b'),'filter':{'field':_0x23fc('0x38'),'value':[_0x23fc('0x5c'),'user']},'ignore':!![]},{'name':_0x23fc('0x35')},{'name':_0x23fc('0x3a')}];}break;case _0x23fc('0x5d'):_0x32ad38['childModel']='ZendeskAccount';break;case'salesforceaccounts':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x5e');break;case _0x23fc('0x5f'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x60');break;case _0x23fc('0x61'):_0x32ad38['childModel']='SugarcrmAccount';break;case _0x23fc('0x62'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x63');break;case'zohoaccounts':_0x32ad38[_0x23fc('0x16')]='ZohoAccount';break;case _0x23fc('0x64'):_0x32ad38[_0x23fc('0x16')]='User';break;case'cannedanswers':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x65');break;case _0x23fc('0x66'):_0x32ad38[_0x23fc('0x16')]='Disposition';break;case'customdashboards':_0x32ad38['childModel']=_0x23fc('0x67');break;case'intervals':_0x32ad38[_0x23fc('0x16')]='Interval';break;case'pauses':_0x32ad38['childModel']=_0x23fc('0x68');break;case _0x23fc('0x69'):_0x32ad38['childModel']=_0x23fc('0x6a');break;case _0x23fc('0x6b'):_0x32ad38['childModel']=_0x23fc('0x6c');break;case _0x23fc('0x6d'):_0x32ad38[_0x23fc('0x16')]='Tag';break;case _0x23fc('0x6e'):_0x32ad38[_0x23fc('0x16')]='Template';break;case _0x23fc('0x6f'):_0x32ad38['childModel']='Trigger';break;case'trunks':_0x32ad38['childModel']=_0x23fc('0x70');break;case'variables':_0x32ad38['childModel']=_0x23fc('0x71');break;case _0x23fc('0x72'):_0x32ad38[_0x23fc('0x16')]='Plugin';break;case'extractedreports':_0x32ad38['childModel']=_0x23fc('0x10');_0x32ad38[_0x23fc('0x1a')]=[{'name':_0x23fc('0x73'),'field':'id','foreignKey':_0x23fc('0x74')}];break;case _0x23fc('0x75'):_0x32ad38['childModel']=_0x23fc('0x76');break;}return _0x32ad38;}function _0x451723(_0x5204f8,_0x9223f7){var _0x26c583=_0x5204f8['charAt'](0x0)['toUpperCase']()+_0x5204f8['slice'](0x1);var _0x3da4fc={'type':_0x179e49[_0x23fc('0x77')][_0x23fc('0x78')]['SELECT'],'raw':!![]};return new Promise(function(_0x83fbcb,_0x12e0f4){var _0x53ead9=squel['select']()[_0x23fc('0x6')](_0x23fc('0x79')+_0x26c583+_0x23fc('0x7a'),'id')[_0x23fc('0x6')]('ui.createdAt')[_0x23fc('0x7b')]('user_has_'+_0x5204f8+_0x23fc('0x7c'),'ui')[_0x23fc('0x7d')](_0x23fc('0x7e'),_0x9223f7['id']);return _0x179e49[_0x23fc('0x7f')][_0x23fc('0x80')](_0x53ead9[_0x23fc('0x81')](),_0x3da4fc)[_0x23fc('0xc')](function(_0x1b0254){_0x9223f7[_0x26c583+'OpenTabs']=_0x1b0254;_0x83fbcb(_0x1b0254);})[_0x23fc('0xa')](function(_0x69895e){_0x12e0f4(_0x69895e);});});}return _0x17578b[_0x23fc('0x82')](_0x23fc('0x83'),attributes,{'tableName':_0x23fc('0x84'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x47b355){var _0x1145d0={'raw':_0x47b355['query'][_0x23fc('0x85')],'where':{}};var _0x594cb4={};var _0x244049={'count':0x0,'rows':[]};var _0x353d8c=_0x47b355[_0x23fc('0x80')][_0x23fc('0x86')];var _0x2da0ca=_0x47b355[_0x23fc('0x80')][_0x23fc('0x87')]||![];var _0x331056=_0x2bbf98(_0x353d8c,_0x2da0ca);if(!_0x331056[_0x23fc('0x16')])throw new Error(_0x23fc('0x88')+_0x353d8c+'\x27');var _0x1fab60=[{'name':_0x353d8c}];if(!_[_0x23fc('0x89')](_0x331056[_0x23fc('0x1a')]))_0x1fab60=_0x331056[_0x23fc('0x1a')];var _0x37d3a4=[];for(var _0x3d9edd=0x0;_0x3d9edd<_0x1fab60[_0x23fc('0x8a')];_0x3d9edd++){_0x37d3a4[_0x23fc('0x8b')](_0x179e49[_0x23fc('0x8c')][_0x23fc('0x8d')]({'where':{'userProfileId':_0x47b355[_0x23fc('0x8e')]['id'],'name':_0x1fab60[_0x3d9edd]['name']},'raw':!![]}));}return Promise[_0x23fc('0x8f')](_0x37d3a4)[_0x23fc('0xc')](function(_0x56af64){var _0x5b8821=_[_0x23fc('0x5')](_0x56af64,function(_0x4709d4){return _0x4709d4?_0x4709d4:undefined;});var _0x496036=_['filter'](_0x1fab60,[_0x23fc('0x90'),!![]]);var _0x5e4131=_['isEmpty'](_0x5b8821)&&_['isEmpty'](_0x496036)?null:_[_0x23fc('0x91')](_0x496036,_0x5b8821);if(!_0x5e4131)return null;var _0x48cf12=[];for(var _0x501dce=0x0;_0x501dce<_0x5e4131[_0x23fc('0x8a')];_0x501dce++){var _0x5d9514=_[_0x23fc('0x8d')](_0x1fab60,function(_0x329cb1){return _0x5e4131[_0x501dce]?_0x329cb1[_0x23fc('0xd')]===_0x5e4131[_0x501dce][_0x23fc('0xd')]:null;});if(_0x5d9514){if(_0x5e4131[_0x501dce][_0x23fc('0x90')]){_0x48cf12[_0x23fc('0x8b')](_0x48471c(_0x331056[_0x23fc('0x16')],_0x5e4131[_0x501dce]));}else{if(!_0x5e4131[_0x501dce]['autoAssociation']){_0x48cf12[_0x23fc('0x8b')](_0x295025(_0x5d9514,_0x5e4131[_0x501dce],_0x331056[_0x23fc('0x16')]));}else{if(_0x5d9514[_0x23fc('0x92')]){_0x48cf12[_0x23fc('0x8b')](_0x453620(_0x5d9514,_0x5e4131[_0x501dce]));}}}}}return Promise[_0x23fc('0x8f')](_0x48cf12);})[_0x23fc('0xc')](function(_0x5c07a7){var _0x11b911=_0x5c07a7;var _0x46588a=null;if(_0x11b911){_0x46588a=_0x11b911[_0x23fc('0x8a')]===0x1?_0x11b911[0x0]:null;}if(!_0x46588a&&!_0x11b911)return _0x244049;var _0x25fff6=_0x179e49[_0x331056['childModel']][_0x23fc('0x93')];_0x594cb4['model']=_[_0x23fc('0x94')](_0x25fff6);_0x594cb4[_0x23fc('0x80')]=_[_0x23fc('0x94')](_0x47b355[_0x23fc('0x80')]);_0x594cb4[_0x23fc('0x95')]=_['intersection'](_0x594cb4[_0x23fc('0x92')],_0x594cb4[_0x23fc('0x80')]);_0x1145d0[_0x23fc('0x96')]=_['intersection'](_0x594cb4[_0x23fc('0x92')],qs['fields'](_0x47b355['query'][_0x23fc('0x97')]));_0x1145d0[_0x23fc('0x96')]=_0x1145d0[_0x23fc('0x96')][_0x23fc('0x8a')]?_0x1145d0[_0x23fc('0x96')]:_0x594cb4[_0x23fc('0x92')];if(!_0x47b355[_0x23fc('0x80')][_0x23fc('0x98')]('nolimit')){_0x1145d0[_0x23fc('0x99')]=qs['limit'](_0x47b355['query']['limit']);_0x1145d0[_0x23fc('0x9a')]=qs[_0x23fc('0x9a')](_0x47b355[_0x23fc('0x80')][_0x23fc('0x9a')]);}_0x1145d0[_0x23fc('0x9b')]=qs[_0x23fc('0x9c')](_0x47b355[_0x23fc('0x80')]['sort']);_0x1145d0[_0x23fc('0x7d')]=qs[_0x23fc('0x95')](_[_0x23fc('0x9d')](_0x47b355[_0x23fc('0x80')],_0x594cb4[_0x23fc('0x95')]));if(_0x47b355['query'][_0x23fc('0x5')]){_0x1145d0[_0x23fc('0x7d')]=_['merge'](_0x1145d0['where'],{'$or':_[_0x23fc('0x9')](_0x25fff6,function(_0x404fae){if(_0x404fae[_0x23fc('0x11')][_0x23fc('0x9e')]!==_0x23fc('0x9f')){var _0x5840a2={};_0x5840a2[_0x404fae[_0x23fc('0x6')]]={'$like':'%'+_0x47b355[_0x23fc('0x80')][_0x23fc('0x5')]+'%'};return _0x5840a2;}})});}var _0x32b82e=[];var _0x266ab3=null;var _0x5b6494={};if(_0x46588a){_0x266ab3=_[_0x23fc('0x8d')](_0x1fab60,[_0x23fc('0xd'),_0x46588a[_0x23fc('0xd')]]);if(_0x266ab3['field']){_0x5b6494={};if(_0x331056[_0x23fc('0x16')]===_0x23fc('0x10')){_0x5b6494[_0x266ab3['foreignKey']]=_['map'](_0x46588a[_0x23fc('0x8')],'id');}else{_0x5b6494[_0x266ab3['foreignKey']]=_0x46588a[_0x23fc('0x8')];}_0x32b82e['push'](_0x5b6494);}else{_0x1145d0[_0x23fc('0x7d')]['id']=_0x46588a[_0x23fc('0x8')];}}else{for(var _0x50f14d=0x0;_0x50f14d<_0x11b911[_0x23fc('0x8a')];_0x50f14d++){_0x266ab3=_['find'](_0x1fab60,['name',_0x11b911[_0x50f14d][_0x23fc('0xd')]]);if(_0x266ab3['field']){_0x5b6494={};_0x5b6494[_0x266ab3['foreignKey']]=_0x11b911[_0x50f14d]['associatedResources'];_0x32b82e[_0x23fc('0x8b')](_0x5b6494);}else{if(!_0x1145d0['where']['id'])_0x1145d0['where']['id']=[];_0x11b911[_0x50f14d][_0x23fc('0x8')][_0x23fc('0xa0')](function(_0x17a884){_0x1145d0[_0x23fc('0x7d')]['id'][_0x23fc('0x8b')](_0x17a884);});}}}if(!_[_0x23fc('0x89')](_0x32b82e)){_0x1145d0['where']=_[_0x23fc('0xa1')](_0x1145d0[_0x23fc('0x7d')],{'$and':{'$or':_0x32b82e}});}_0x1145d0=_[_0x23fc('0xa1')]({},_0x1145d0,_0x47b355[_0x23fc('0xa2')]);if(_0x46588a&&!_0x46588a[_0x23fc('0xa3')]&&_0x331056[_0x23fc('0x16')]===_0x23fc('0x10')){if(_0x47b355[_0x23fc('0x80')][_0x23fc('0xa4')]){_0x1145d0['include']=[{'all':!![]}];}return _0x179e49[_0x331056['childModel']][_0x23fc('0x7')](_0x1145d0)[_0x23fc('0xc')](function(_0x381e6a){var _0x4f2a2c=[];_0x381e6a[_0x23fc('0xa0')](function(_0x20e80c){var _0x3760be;switch(_0x20e80c[_0x23fc('0xa5')]){case _0x23fc('0xa6'):_0x3760be=_[_0x23fc('0x8d')](_0x46588a[_0x23fc('0x8')],function(_0x4bd540){return _0x4bd540['id']===_0x20e80c[_0x23fc('0x74')]&&_0x4bd540[_0x23fc('0x11')]===_0x23fc('0xa7');});break;case'custom':_0x3760be=_[_0x23fc('0x8d')](_0x46588a[_0x23fc('0x8')],function(_0xbfb68e){return _0xbfb68e['id']===_0x20e80c[_0x23fc('0x74')]&&_0xbfb68e[_0x23fc('0x11')]===_0x23fc('0xa8');});break;}if(_0x3760be)_0x4f2a2c['push'](_0x20e80c);});_0x244049[_0x23fc('0xa9')]=_0x4f2a2c[_0x23fc('0x8a')];_0x244049['rows']=_0x4f2a2c;return _0x244049;});}else{if(!_[_0x23fc('0x89')](_0x47b355[_0x23fc('0x80')]['ids'])){_0x1145d0[_0x23fc('0x7d')]['id']=_0x1145d0[_0x23fc('0x7d')]['id']?_[_0x23fc('0xaa')](_0x1145d0[_0x23fc('0x7d')]['id'],_0x47b355['query'][_0x23fc('0xab')]):_0x47b355[_0x23fc('0x80')][_0x23fc('0xab')];if(_0x47b355['query']['customSorting']){_0x1145d0[_0x23fc('0x9b')]=_0x47b355[_0x23fc('0x80')][_0x23fc('0xac')];}}if(_0x47b355[_0x23fc('0x80')]['extraQueryConditions']){_0x1145d0[_0x23fc('0x7d')]=_['merge'](_0x1145d0['where'],{'$and':_0x47b355[_0x23fc('0x80')]['extraQueryConditions']});}return _0x179e49[_0x331056[_0x23fc('0x16')]][_0x23fc('0xa9')]({'where':_0x1145d0[_0x23fc('0x7d')]})[_0x23fc('0xc')](function(_0x42bab5){_0x244049[_0x23fc('0xa9')]=_0x42bab5;if(_0x47b355['query']['includeAll']){if(_0x331056[_0x23fc('0x16')]===_0x23fc('0x1f')){_0x1145d0['include']=[{'model':_0x179e49[_0x23fc('0xad')],'as':_0x23fc('0xae'),'attributes':['id',_0x23fc('0xd'),_0x23fc('0xaf')],'required':_0x47b355['query'][_0x23fc('0xb0')]?!![]:![]},{'model':_0x179e49[_0x23fc('0xad')],'as':'ThroughTags','attributes':['id',_0x23fc('0xd'),'color'],'through':_0x47b355[_0x23fc('0x80')]['tag']?{'attributes':[],'where':{'TagId':_0x47b355[_0x23fc('0x80')][_0x23fc('0xb0')]||undefined}}:{},'required':_0x47b355[_0x23fc('0x80')][_0x23fc('0xb0')]?!![]:![]}];}else{_0x1145d0[_0x23fc('0xb1')]=[{'all':!![]}];}}return _0x179e49[_0x331056[_0x23fc('0x16')]][_0x23fc('0x7')](_0x1145d0);})[_0x23fc('0xc')](function(_0x2357ea){_0x244049[_0x23fc('0xb2')]=_0x2357ea;if(_0x353d8c===_0x23fc('0x35')&&_0x47b355[_0x23fc('0x80')][_0x23fc('0xb3')]===_0x23fc('0xb4')){var _0x382fd5=[];for(var _0x3126e2=0x0;_0x3126e2<_0x244049[_0x23fc('0xb2')][_0x23fc('0x8a')];_0x3126e2++){_0x382fd5[_0x23fc('0x8b')](_0x451723('chat',_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb6'),_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb7'),_0x244049[_0x23fc('0xb2')][_0x3126e2]['dataValues']));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb8'),_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb9'),_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5['push'](_0x451723(_0x23fc('0xba'),_0x244049['rows'][_0x3126e2][_0x23fc('0xb5')]));}return Promise[_0x23fc('0x8f')](_0x382fd5)['then'](function(){return _0x244049;});}return _0x244049;});}});}}});};