Built motion from commit 55091a5c.|2.6.30
[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 _0x27dd=['reportId','DefaultReports','custom','count','rows','ids','extraQueryConditions','CmContact','include','Tag','Tags','tag','ThroughTags','true','chat','dataValues','fax','mail','whatsapp','lodash','models','field','filter','value','findAll','then','associatedResources','map','model','name','catch','AnalyticExtractedReport','resourceId','type','toLowerCase','squareprojects','childModel','SquareProject','SquareOdbc','SquareRecording','projectName','projects','contacts','parentSections','ListId','lists','CmList','companies','CmCompany','CmCustomField','ChatQueue','chatwebsites','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','VoiceContext','VoiceMail','Agents','membername','User','agent','Telephones','role','telephone','VoiceQueues','VoiceQueue','inbound','queue','outbound','musiconholds','VoiceMusicOnHold','VoiceChanSpy','voiceprefixes','VoicePrefix','Campaign','mailqueues','MailQueue','mailsubstatuses','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','users','agents','telephones','Users','admin','user','zendeskaccounts','ZendeskAccount','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','cannedanswers','CannedAnswer','Disposition','customdashboards','intervals','Interval','pauses','scheduler','Schedule','sounds','Sound','tags','Template','triggers','Trigger','trunks','Trunk','Variable','plugins','Plugin','extractedreports','Reports','AnalyticMetric','slice','QueryTypes','SELECT','select','ui.','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','OpenTabs','define','UserProfile','user_profiles','../../components/parsers/qs','section','Invalid\x20section\x20\x27','isEmpty','length','push','UserProfileSection','find','params','all','ignore','union','autoAssociation','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','merge','key','VIRTUAL','foreignKey','forEach','options','includeAll','reportType','default'];(function(_0x21b2c8,_0x30afbf){var _0x433d14=function(_0x3ffa6d){while(--_0x3ffa6d){_0x21b2c8['push'](_0x21b2c8['shift']());}};_0x433d14(++_0x30afbf);}(_0x27dd,0x183));var _0xd27d=function(_0x13b8f3,_0x442821){_0x13b8f3=_0x13b8f3-0x0;var _0x1a6d06=_0x27dd[_0x13b8f3];return _0x1a6d06;};'use strict';var _=require(_0xd27d('0x0'));var attributes=require('./userProfile.attributes');var squel=require('squel');module['exports']=function(_0x1cb284){var _0xf7c1cb=_0x1cb284[_0xd27d('0x1')];function _0xbd9c43(_0x23dd57,_0x390cbc){return new Promise(function(_0x253830,_0x153c5d){if(!_0x390cbc)return _0x253830(null);var _0x26e8af=_0x390cbc['filter']?{[_0x390cbc['filter'][_0xd27d('0x2')]]:_0x390cbc[_0xd27d('0x3')][_0xd27d('0x4')]}:undefined;return _0xf7c1cb[_0x23dd57][_0xd27d('0x5')]({'where':_0x26e8af,'raw':!![]})[_0xd27d('0x6')](function(_0x299613){_0x390cbc[_0xd27d('0x7')]=_[_0xd27d('0x8')](_0x299613,'id');_0x253830(_0x390cbc);})['catch'](function(_0x1839e2){_0x153c5d(_0x1839e2);});});}function _0x368473(_0x3b9457,_0x1af7ef){return new Promise(function(_0x5d4463,_0x3508f8){var _0x12e584=_0x3b9457[_0xd27d('0x3')]?{[_0x3b9457[_0xd27d('0x3')]['field']]:_0x3b9457[_0xd27d('0x3')][_0xd27d('0x4')]}:undefined;return _0xf7c1cb[_0x3b9457[_0xd27d('0x9')]][_0xd27d('0x5')]({'where':_0x12e584,'raw':!![]})[_0xd27d('0x6')](function(_0xda4d35){_0x1af7ef['associatedResources']=_[_0xd27d('0x8')](_0xda4d35,function(_0x2b371c){return _0x2b371c[_0xd27d('0xa')];});_0x5d4463(_0x1af7ef);})[_0xd27d('0xb')](function(_0x47b00b){_0x3508f8(_0x47b00b);});});}function _0x55a0be(_0xf3e26f,_0x1d9788,_0x45250a){if(!_0x1d9788)return Promise['resolve'](null);return new Promise(function(_0x2f0534,_0x2f7847){return _0xf7c1cb['UserProfileResource']['findAll']({'where':{'sectionId':_0x1d9788['id']},'raw':!![]})[_0xd27d('0x6')](function(_0x14a449){if(_0xf3e26f['field']&&_0xf3e26f[_0xd27d('0x2')]!=='id'){_0x1d9788['associatedResources']=_[_0xd27d('0x8')](_0x14a449,function(_0x445108){return _0x445108[_0xf3e26f[_0xd27d('0x2')]];});}else{if(_0x45250a===_0xd27d('0xc')){_0x1d9788[_0xd27d('0x7')]=_[_0xd27d('0x8')](_0x14a449,function(_0xd458f1){return{'id':_0xd458f1[_0xd27d('0xd')],'type':_0xd458f1[_0xd27d('0xe')]};});}else{_0x1d9788[_0xd27d('0x7')]=_[_0xd27d('0x8')](_0x14a449,function(_0x393bd2){return _0x393bd2[_0xd27d('0xd')];});}}_0x2f0534(_0x1d9788);})['catch'](function(_0x3faa49){_0x2f7847(_0x3faa49);});});}function _0x13f3c5(_0x508039,_0x208a0d){var _0xcdeb86={'parentSections':[]};switch(_0x508039[_0xd27d('0xf')]()){case _0xd27d('0x10'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x12');break;case'odbc':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x13');break;case'squarerecordings':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x14');_0xcdeb86['parentSections']=[{'name':'SquareProjects','field':_0xd27d('0xa'),'foreignKey':_0xd27d('0x15')}];break;case _0xd27d('0x16'):_0xcdeb86[_0xd27d('0x11')]='JscriptyProject';break;case _0xd27d('0x17'):_0xcdeb86[_0xd27d('0x11')]='CmContact';_0xcdeb86[_0xd27d('0x18')]=[{'name':'Lists','field':'id','foreignKey':_0xd27d('0x19')}];break;case _0xd27d('0x1a'):_0xcdeb86['childModel']=_0xd27d('0x1b');break;case _0xd27d('0x1c'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x1d');break;case'globalcustomfields':_0xcdeb86['childModel']=_0xd27d('0x1e');break;case'chatqueues':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x1f');break;case _0xd27d('0x20'):_0xcdeb86[_0xd27d('0x11')]='ChatWebsite';break;case _0xd27d('0x21'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x22');break;case _0xd27d('0x23'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x24');break;case _0xd27d('0x25'):case _0xd27d('0x26'):case _0xd27d('0x27'):_0xcdeb86[_0xd27d('0x11')]='VoiceExtension';break;case'contexts':_0xcdeb86['childModel']=_0xd27d('0x28');break;case'voicemails':_0xcdeb86['childModel']=_0xd27d('0x29');break;case'voicerecordings':_0xcdeb86['childModel']='VoiceRecording';_0xcdeb86[_0xd27d('0x18')]=[{'name':_0xd27d('0x2a'),'field':_0xd27d('0xa'),'foreignKey':_0xd27d('0x2b'),'model':_0xd27d('0x2c'),'filter':{'field':'role','value':[_0xd27d('0x2d')]}},{'name':_0xd27d('0x2e'),'field':_0xd27d('0xa'),'foreignKey':_0xd27d('0x2b'),'model':_0xd27d('0x2c'),'filter':{'field':_0xd27d('0x2f'),'value':[_0xd27d('0x30')]}},{'name':_0xd27d('0x31'),'field':'name','foreignKey':'queue','model':_0xd27d('0x32'),'filter':{'field':_0xd27d('0xe'),'value':[_0xd27d('0x33')]}},{'name':'QueueCampaigns','field':'name','foreignKey':_0xd27d('0x34'),'model':_0xd27d('0x32'),'filter':{'field':_0xd27d('0xe'),'value':[_0xd27d('0x35')]}}];break;case _0xd27d('0x36'):_0xcdeb86['childModel']=_0xd27d('0x37');break;case'chanspies':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x38');break;case _0xd27d('0x39'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x3a');break;case'ivrcampaigns':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x3b');break;case _0xd27d('0x3c'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x3d');break;case'mailaccounts':_0xcdeb86['childModel']='MailAccount';break;case _0xd27d('0x3e'):_0xcdeb86[_0xd27d('0x11')]='MailSubstatus';break;case'openchannelqueues':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x3f');break;case _0xd27d('0x40'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x41');break;case _0xd27d('0x42'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x43');break;case _0xd27d('0x44'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x45');break;case _0xd27d('0x46'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x47');break;case'whatsappaccounts':_0xcdeb86['childModel']=_0xd27d('0x48');break;case _0xd27d('0x49'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x4a');break;case _0xd27d('0x4b'):case _0xd27d('0x4c'):_0xcdeb86['childModel']=_0xd27d('0x32');if(_0x208a0d){_0xcdeb86[_0xd27d('0x18')]=[{'name':'VoiceQueues'},{'name':'QueueCampaigns'}];}break;case _0xd27d('0x4d'):case _0xd27d('0x4e'):case _0xd27d('0x4f'):_0xcdeb86[_0xd27d('0x11')]='User';if(_0x208a0d){_0xcdeb86[_0xd27d('0x18')]=[{'name':_0xd27d('0x50'),'filter':{'field':_0xd27d('0x2f'),'value':[_0xd27d('0x51'),_0xd27d('0x52')]},'ignore':!![]},{'name':'Agents'},{'name':_0xd27d('0x2e')}];}break;case _0xd27d('0x53'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x54');break;case'salesforceaccounts':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x55');break;case _0xd27d('0x56'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x57');break;case'sugarcrmaccounts':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x58');break;case _0xd27d('0x59'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x5a');break;case _0xd27d('0x5b'):_0xcdeb86[_0xd27d('0x11')]='ZohoAccount';break;case'vtigeraccounts':_0xcdeb86[_0xd27d('0x11')]='User';break;case _0xd27d('0x5c'):_0xcdeb86['childModel']=_0xd27d('0x5d');break;case'dispositions':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x5e');break;case _0xd27d('0x5f'):_0xcdeb86[_0xd27d('0x11')]='Dashboard';break;case _0xd27d('0x60'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x61');break;case _0xd27d('0x62'):_0xcdeb86[_0xd27d('0x11')]='Pause';break;case _0xd27d('0x63'):_0xcdeb86['childModel']=_0xd27d('0x64');break;case _0xd27d('0x65'):_0xcdeb86['childModel']=_0xd27d('0x66');break;case _0xd27d('0x67'):_0xcdeb86['childModel']='Tag';break;case'templates':_0xcdeb86['childModel']=_0xd27d('0x68');break;case _0xd27d('0x69'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x6a');break;case _0xd27d('0x6b'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x6c');break;case'variables':_0xcdeb86['childModel']=_0xd27d('0x6d');break;case _0xd27d('0x6e'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x6f');break;case _0xd27d('0x70'):_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0xc');_0xcdeb86[_0xd27d('0x18')]=[{'name':_0xd27d('0x71'),'field':'id','foreignKey':'reportId'}];break;case'metrics':_0xcdeb86[_0xd27d('0x11')]=_0xd27d('0x72');break;}return _0xcdeb86;}function _0x2759fb(_0x502bf5,_0x5b3a27){var _0x10a5dc=_0x502bf5['charAt'](0x0)['toUpperCase']()+_0x502bf5[_0xd27d('0x73')](0x1);var _0x1fb181={'type':_0xf7c1cb['Sequelize'][_0xd27d('0x74')][_0xd27d('0x75')],'raw':!![]};return new Promise(function(_0x2484e6,_0x4d2321){var _0xc5137a=squel[_0xd27d('0x76')]()['field'](_0xd27d('0x77')+_0x10a5dc+'InteractionId','id')[_0xd27d('0x2')](_0xd27d('0x78'))[_0xd27d('0x79')](_0xd27d('0x7a')+_0x502bf5+_0xd27d('0x7b'),'ui')[_0xd27d('0x7c')](_0xd27d('0x7d'),_0x5b3a27['id']);return _0xf7c1cb[_0xd27d('0x7e')][_0xd27d('0x7f')](_0xc5137a['toString'](),_0x1fb181)[_0xd27d('0x6')](function(_0x493f19){_0x5b3a27[_0x10a5dc+_0xd27d('0x80')]=_0x493f19;_0x2484e6(_0x493f19);})[_0xd27d('0xb')](function(_0x10ffa3){_0x4d2321(_0x10ffa3);});});}return _0x1cb284[_0xd27d('0x81')](_0xd27d('0x82'),attributes,{'tableName':_0xd27d('0x83'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x28acf6){var _0x5bcb8c=require(_0xd27d('0x84'));var _0x112cb1={'raw':_0x28acf6['query']['raw'],'where':{}};var _0x490e05={};var _0x46d9ed={'count':0x0,'rows':[]};var _0x88da3d=_0x28acf6[_0xd27d('0x7f')][_0xd27d('0x85')];var _0x15fc3a=_0x28acf6[_0xd27d('0x7f')]['mergeResources']||![];var _0x3ea2f1=_0x13f3c5(_0x88da3d,_0x15fc3a);if(!_0x3ea2f1[_0xd27d('0x11')])throw new Error(_0xd27d('0x86')+_0x88da3d+'\x27');var _0x24fef2=[{'name':_0x88da3d}];if(!_[_0xd27d('0x87')](_0x3ea2f1[_0xd27d('0x18')]))_0x24fef2=_0x3ea2f1['parentSections'];var _0x5df23e=[];for(var _0x94c94d=0x0;_0x94c94d<_0x24fef2[_0xd27d('0x88')];_0x94c94d++){_0x5df23e[_0xd27d('0x89')](_0xf7c1cb[_0xd27d('0x8a')][_0xd27d('0x8b')]({'where':{'userProfileId':_0x28acf6[_0xd27d('0x8c')]['id'],'name':_0x24fef2[_0x94c94d][_0xd27d('0xa')]},'raw':!![]}));}return Promise[_0xd27d('0x8d')](_0x5df23e)['then'](function(_0x141a3a){var _0x5c50c2=_['filter'](_0x141a3a,function(_0x49586b){return _0x49586b?_0x49586b:undefined;});var _0x2aa85d=_[_0xd27d('0x3')](_0x24fef2,[_0xd27d('0x8e'),!![]]);var _0x50e034=_['isEmpty'](_0x5c50c2)&&_[_0xd27d('0x87')](_0x2aa85d)?null:_[_0xd27d('0x8f')](_0x2aa85d,_0x5c50c2);if(!_0x50e034)return null;var _0x43e7e3=[];for(var _0x31a2f1=0x0;_0x31a2f1<_0x50e034['length'];_0x31a2f1++){var _0x4f4f4a=_[_0xd27d('0x8b')](_0x24fef2,function(_0x100248){return _0x50e034[_0x31a2f1]?_0x100248[_0xd27d('0xa')]===_0x50e034[_0x31a2f1][_0xd27d('0xa')]:null;});if(_0x4f4f4a){if(_0x50e034[_0x31a2f1][_0xd27d('0x8e')]){_0x43e7e3[_0xd27d('0x89')](_0xbd9c43(_0x3ea2f1[_0xd27d('0x11')],_0x50e034[_0x31a2f1]));}else{if(!_0x50e034[_0x31a2f1][_0xd27d('0x90')]){_0x43e7e3['push'](_0x55a0be(_0x4f4f4a,_0x50e034[_0x31a2f1],_0x3ea2f1['childModel']));}else{if(_0x4f4f4a['model']){_0x43e7e3[_0xd27d('0x89')](_0x368473(_0x4f4f4a,_0x50e034[_0x31a2f1]));}}}}}return Promise[_0xd27d('0x8d')](_0x43e7e3);})['then'](function(_0xdf34b1){var _0x2d5396=_0xdf34b1;var _0x3148a3=null;if(_0x2d5396){_0x3148a3=_0x2d5396[_0xd27d('0x88')]===0x1?_0x2d5396[0x0]:null;}if(!_0x3148a3&&!_0x2d5396)return _0x46d9ed;var _0x56a97d=_0xf7c1cb[_0x3ea2f1['childModel']]['rawAttributes'];_0x490e05[_0xd27d('0x9')]=_['keys'](_0x56a97d);_0x490e05[_0xd27d('0x7f')]=_[_0xd27d('0x91')](_0x28acf6[_0xd27d('0x7f')]);_0x490e05[_0xd27d('0x92')]=_[_0xd27d('0x93')](_0x490e05[_0xd27d('0x9')],_0x490e05[_0xd27d('0x7f')]);_0x112cb1[_0xd27d('0x94')]=_[_0xd27d('0x93')](_0x490e05['model'],_0x5bcb8c[_0xd27d('0x95')](_0x28acf6[_0xd27d('0x7f')][_0xd27d('0x95')]));_0x112cb1['attributes']=_0x112cb1[_0xd27d('0x94')][_0xd27d('0x88')]?_0x112cb1[_0xd27d('0x94')]:_0x490e05[_0xd27d('0x9')];if(!_0x28acf6[_0xd27d('0x7f')][_0xd27d('0x96')](_0xd27d('0x97'))){_0x112cb1[_0xd27d('0x98')]=_0x5bcb8c[_0xd27d('0x98')](_0x28acf6[_0xd27d('0x7f')]['limit']);_0x112cb1[_0xd27d('0x99')]=_0x5bcb8c[_0xd27d('0x99')](_0x28acf6['query'][_0xd27d('0x99')]);}_0x112cb1[_0xd27d('0x9a')]=_0x5bcb8c[_0xd27d('0x9b')](_0x28acf6[_0xd27d('0x7f')][_0xd27d('0x9b')]);_0x112cb1[_0xd27d('0x7c')]=_0x5bcb8c[_0xd27d('0x92')](_['pick'](_0x28acf6['query'],_0x490e05['filters']));if(_0x28acf6[_0xd27d('0x7f')][_0xd27d('0x3')]){_0x112cb1[_0xd27d('0x7c')]=_[_0xd27d('0x9c')](_0x112cb1[_0xd27d('0x7c')],{'$or':_['map'](_0x56a97d,function(_0x88449){if(_0x88449['type'][_0xd27d('0x9d')]!==_0xd27d('0x9e')){var _0x231b93={};_0x231b93[_0x88449[_0xd27d('0x2')]]={'$like':'%'+_0x28acf6[_0xd27d('0x7f')][_0xd27d('0x3')]+'%'};return _0x231b93;}})});}var _0x4cb06e=[];var _0x552a17=null;var _0x13a58f={};if(_0x3148a3){_0x552a17=_[_0xd27d('0x8b')](_0x24fef2,['name',_0x3148a3['name']]);if(_0x552a17[_0xd27d('0x2')]){_0x13a58f={};if(_0x3ea2f1['childModel']===_0xd27d('0xc')){_0x13a58f[_0x552a17['foreignKey']]=_['map'](_0x3148a3[_0xd27d('0x7')],'id');}else{_0x13a58f[_0x552a17[_0xd27d('0x9f')]]=_0x3148a3['associatedResources'];}_0x4cb06e[_0xd27d('0x89')](_0x13a58f);}else{_0x112cb1['where']['id']=_0x3148a3['associatedResources'];}}else{for(var _0x46a22b=0x0;_0x46a22b<_0x2d5396['length'];_0x46a22b++){_0x552a17=_[_0xd27d('0x8b')](_0x24fef2,[_0xd27d('0xa'),_0x2d5396[_0x46a22b][_0xd27d('0xa')]]);if(_0x552a17[_0xd27d('0x2')]){_0x13a58f={};_0x13a58f[_0x552a17[_0xd27d('0x9f')]]=_0x2d5396[_0x46a22b]['associatedResources'];_0x4cb06e[_0xd27d('0x89')](_0x13a58f);}else{if(!_0x112cb1['where']['id'])_0x112cb1[_0xd27d('0x7c')]['id']=[];_0x2d5396[_0x46a22b][_0xd27d('0x7')][_0xd27d('0xa0')](function(_0x176599){_0x112cb1['where']['id']['push'](_0x176599);});}}}if(!_[_0xd27d('0x87')](_0x4cb06e)){_0x112cb1['where']=_[_0xd27d('0x9c')](_0x112cb1[_0xd27d('0x7c')],{'$and':{'$or':_0x4cb06e}});}_0x112cb1=_[_0xd27d('0x9c')]({},_0x112cb1,_0x28acf6[_0xd27d('0xa1')]);if(_0x3148a3&&!_0x3148a3[_0xd27d('0x90')]&&_0x3ea2f1[_0xd27d('0x11')]===_0xd27d('0xc')){if(_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xa2')]){_0x112cb1['include']=[{'all':!![]}];}return _0xf7c1cb[_0x3ea2f1[_0xd27d('0x11')]][_0xd27d('0x5')](_0x112cb1)[_0xd27d('0x6')](function(_0x3921a1){var _0x95cf10=[];_0x3921a1[_0xd27d('0xa0')](function(_0x27f654){var _0x2d86bc;switch(_0x27f654[_0xd27d('0xa3')]){case _0xd27d('0xa4'):_0x2d86bc=_[_0xd27d('0x8b')](_0x3148a3[_0xd27d('0x7')],function(_0x3ad8c8){return _0x3ad8c8['id']===_0x27f654[_0xd27d('0xa5')]&&_0x3ad8c8['type']===_0xd27d('0xa6');});break;case _0xd27d('0xa7'):_0x2d86bc=_[_0xd27d('0x8b')](_0x3148a3[_0xd27d('0x7')],function(_0x59616b){return _0x59616b['id']===_0x27f654[_0xd27d('0xa5')]&&_0x59616b[_0xd27d('0xe')]==='CustomReports';});break;}if(_0x2d86bc)_0x95cf10[_0xd27d('0x89')](_0x27f654);});_0x46d9ed[_0xd27d('0xa8')]=_0x95cf10['length'];_0x46d9ed[_0xd27d('0xa9')]=_0x95cf10;return _0x46d9ed;});}else{if(!_[_0xd27d('0x87')](_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xaa')])){_0x112cb1['where']['id']=_0x112cb1[_0xd27d('0x7c')]['id']?_['intersection'](_0x112cb1['where']['id'],_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xaa')]):_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xaa')];if(_0x28acf6[_0xd27d('0x7f')]['customSorting']){_0x112cb1[_0xd27d('0x9a')]=_0x28acf6[_0xd27d('0x7f')]['customSorting'];}}if(_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xab')]){_0x112cb1['where']=_[_0xd27d('0x9c')](_0x112cb1[_0xd27d('0x7c')],{'$and':_0x28acf6['query']['extraQueryConditions']});}return _0xf7c1cb[_0x3ea2f1[_0xd27d('0x11')]][_0xd27d('0xa8')]({'where':_0x112cb1[_0xd27d('0x7c')]})['then'](function(_0x1545cd){_0x46d9ed['count']=_0x1545cd;if(_0x28acf6[_0xd27d('0x7f')]['includeAll']){if(_0x3ea2f1[_0xd27d('0x11')]===_0xd27d('0xac')){_0x112cb1[_0xd27d('0xad')]=[{'model':_0xf7c1cb[_0xd27d('0xae')],'as':_0xd27d('0xaf'),'attributes':['id',_0xd27d('0xa'),'color'],'required':_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xb0')]?!![]:![]},{'model':_0xf7c1cb[_0xd27d('0xae')],'as':_0xd27d('0xb1'),'attributes':['id','name','color'],'through':_0x28acf6[_0xd27d('0x7f')][_0xd27d('0xb0')]?{'attributes':[],'where':{'TagId':_0x28acf6['query'][_0xd27d('0xb0')]||undefined}}:{},'required':_0x28acf6['query'][_0xd27d('0xb0')]?!![]:![]}];}else{_0x112cb1[_0xd27d('0xad')]=[{'all':!![]}];}}return _0xf7c1cb[_0x3ea2f1[_0xd27d('0x11')]][_0xd27d('0x5')](_0x112cb1);})[_0xd27d('0x6')](function(_0x224fa4){_0x46d9ed[_0xd27d('0xa9')]=_0x224fa4;if(_0x88da3d==='Agents'&&_0x28acf6[_0xd27d('0x7f')]['openTabs']===_0xd27d('0xb2')){var _0x5d1746=[];for(var _0x2bf800=0x0;_0x2bf800<_0x46d9ed[_0xd27d('0xa9')][_0xd27d('0x88')];_0x2bf800++){_0x5d1746[_0xd27d('0x89')](_0x2759fb(_0xd27d('0xb3'),_0x46d9ed['rows'][_0x2bf800][_0xd27d('0xb4')]));_0x5d1746[_0xd27d('0x89')](_0x2759fb('sms',_0x46d9ed[_0xd27d('0xa9')][_0x2bf800][_0xd27d('0xb4')]));_0x5d1746[_0xd27d('0x89')](_0x2759fb(_0xd27d('0xb5'),_0x46d9ed['rows'][_0x2bf800][_0xd27d('0xb4')]));_0x5d1746[_0xd27d('0x89')](_0x2759fb(_0xd27d('0xb6'),_0x46d9ed[_0xd27d('0xa9')][_0x2bf800][_0xd27d('0xb4')]));_0x5d1746[_0xd27d('0x89')](_0x2759fb('openchannel',_0x46d9ed['rows'][_0x2bf800][_0xd27d('0xb4')]));_0x5d1746[_0xd27d('0x89')](_0x2759fb(_0xd27d('0xb7'),_0x46d9ed[_0xd27d('0xa9')][_0x2bf800][_0xd27d('0xb4')]));}return Promise[_0xd27d('0x8d')](_0x5d1746)[_0xd27d('0x6')](function(){return _0x46d9ed;});}return _0x46d9ed;});}});}}});};