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 _0x1a18=['SmsQueue','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','Team','voicequeues','queuecampaigns','users','agents','telephones','admin','user','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','ZohoAccount','vtigeraccounts','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','scheduler','Schedule','sounds','Tag','templates','Template','Trigger','Trunk','variables','Variable','plugins','extractedreports','Reports','reportId','metrics','AnalyticMetric','charAt','slice','Sequelize','QueryTypes','SELECT','ui.','InteractionId','ui.createdAt','from','_interactions','where','sequelize','query','toString','OpenTabs','define','raw','section','Invalid\x20section\x20\x27','isEmpty','length','find','params','all','ignore','push','rawAttributes','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','pick','merge','key','VIRTUAL','AnalyticExtractedReport','foreignKey','forEach','options','autoAssociation','reportType','default','DefaultReports','custom','CustomReports','count','ids','customSorting','extraQueryConditions','includeAll','include','Tags','color','tag','ThroughTags','rows','openTabs','true','sms','dataValues','fax','mail','openchannel','whatsapp','../../components/parsers/qs','exports','models','filter','field','value','findAll','associatedResources','catch','model','then','map','name','resolve','resourceId','type','toLowerCase','childModel','SquareProject','parentSections','SquareProjects','projects','contacts','CmContact','ListId','lists','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','faxqueues','FaxQueue','faxaccounts','inboundroutes','outboundroutes','VoiceExtension','contexts','voicemails','VoiceMail','voicerecordings','Agents','membername','User','role','Telephones','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','musiconholds','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','MailSubstatus','OpenchannelQueue','smsqueues'];(function(_0xea9ef5,_0x3fa05c){var _0x1424db=function(_0x2fa784){while(--_0x2fa784){_0xea9ef5['push'](_0xea9ef5['shift']());}};_0x1424db(++_0x3fa05c);}(_0x1a18,0x7a));var _0x81a1=function(_0x452968,_0x31e391){_0x452968=_0x452968-0x0;var _0xb6f9ae=_0x1a18[_0x452968];return _0xb6f9ae;};'use strict';var _=require('lodash');var attributes=require('./userProfile.attributes');var qs=require(_0x81a1('0x0'));var squel=require('squel');module[_0x81a1('0x1')]=function(_0x1999a0){var _0x11b845=_0x1999a0[_0x81a1('0x2')];function _0x23a249(_0x5a3062,_0x388247){return new Promise(function(_0x33ef2a,_0x45b5e5){if(!_0x388247)return _0x33ef2a(null);var _0x4f2788=_0x388247['filter']?{[_0x388247[_0x81a1('0x3')][_0x81a1('0x4')]]:_0x388247[_0x81a1('0x3')][_0x81a1('0x5')]}:undefined;return _0x11b845[_0x5a3062][_0x81a1('0x6')]({'where':_0x4f2788,'raw':!![]})['then'](function(_0x1e42c5){_0x388247[_0x81a1('0x7')]=_['map'](_0x1e42c5,'id');_0x33ef2a(_0x388247);})[_0x81a1('0x8')](function(_0x1238ed){_0x45b5e5(_0x1238ed);});});}function _0x4ac0f0(_0x2aa312,_0x2b080b){return new Promise(function(_0xc71e53,_0x42985a){var _0x51f042=_0x2aa312[_0x81a1('0x3')]?{[_0x2aa312[_0x81a1('0x3')][_0x81a1('0x4')]]:_0x2aa312[_0x81a1('0x3')][_0x81a1('0x5')]}:undefined;return _0x11b845[_0x2aa312[_0x81a1('0x9')]][_0x81a1('0x6')]({'where':_0x51f042,'raw':!![]})[_0x81a1('0xa')](function(_0x5434dc){_0x2b080b[_0x81a1('0x7')]=_[_0x81a1('0xb')](_0x5434dc,function(_0x14a6ed){return _0x14a6ed[_0x81a1('0xc')];});_0xc71e53(_0x2b080b);})[_0x81a1('0x8')](function(_0x5562c5){_0x42985a(_0x5562c5);});});}function _0x38239f(_0x5a05f6,_0x56c87d,_0x4e372f){if(!_0x56c87d)return Promise[_0x81a1('0xd')](null);return new Promise(function(_0x3a4be7,_0x3f6119){return _0x11b845['UserProfileResource'][_0x81a1('0x6')]({'where':{'sectionId':_0x56c87d['id']},'raw':!![]})[_0x81a1('0xa')](function(_0x5e0eb5){if(_0x5a05f6[_0x81a1('0x4')]&&_0x5a05f6[_0x81a1('0x4')]!=='id'){_0x56c87d['associatedResources']=_['map'](_0x5e0eb5,function(_0x4c30ed){return _0x4c30ed[_0x5a05f6['field']];});}else{if(_0x4e372f==='AnalyticExtractedReport'){_0x56c87d[_0x81a1('0x7')]=_[_0x81a1('0xb')](_0x5e0eb5,function(_0x23c9f1){return{'id':_0x23c9f1[_0x81a1('0xe')],'type':_0x23c9f1[_0x81a1('0xf')]};});}else{_0x56c87d[_0x81a1('0x7')]=_[_0x81a1('0xb')](_0x5e0eb5,function(_0x1c509d){return _0x1c509d[_0x81a1('0xe')];});}}_0x3a4be7(_0x56c87d);})[_0x81a1('0x8')](function(_0x478b8f){_0x3f6119(_0x478b8f);});});}function _0x40fd8c(_0x17c564,_0x1a6e61){var _0x3f4077={'parentSections':[]};switch(_0x17c564[_0x81a1('0x10')]()){case'squareprojects':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x12');break;case'odbc':_0x3f4077[_0x81a1('0x11')]='SquareOdbc';break;case'squarerecordings':_0x3f4077[_0x81a1('0x11')]='SquareRecording';_0x3f4077[_0x81a1('0x13')]=[{'name':_0x81a1('0x14'),'field':_0x81a1('0xc'),'foreignKey':'projectName'}];break;case _0x81a1('0x15'):_0x3f4077['childModel']='JscriptyProject';break;case _0x81a1('0x16'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x17');_0x3f4077[_0x81a1('0x13')]=[{'name':'Lists','field':'id','foreignKey':_0x81a1('0x18')}];break;case _0x81a1('0x19'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x1a');break;case _0x81a1('0x1b'):_0x3f4077['childModel']=_0x81a1('0x1c');break;case _0x81a1('0x1d'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x1e');break;case _0x81a1('0x1f'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x20');break;case _0x81a1('0x21'):_0x3f4077[_0x81a1('0x11')]='ChatWebsite';break;case _0x81a1('0x22'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x23');break;case _0x81a1('0x24'):_0x3f4077[_0x81a1('0x11')]='FaxAccount';break;case _0x81a1('0x25'):case'internalroutes':case _0x81a1('0x26'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x27');break;case _0x81a1('0x28'):_0x3f4077[_0x81a1('0x11')]='VoiceContext';break;case _0x81a1('0x29'):_0x3f4077['childModel']=_0x81a1('0x2a');break;case _0x81a1('0x2b'):_0x3f4077[_0x81a1('0x11')]='VoiceRecording';_0x3f4077[_0x81a1('0x13')]=[{'name':_0x81a1('0x2c'),'field':_0x81a1('0xc'),'foreignKey':_0x81a1('0x2d'),'model':_0x81a1('0x2e'),'filter':{'field':_0x81a1('0x2f'),'value':['agent']}},{'name':_0x81a1('0x30'),'field':_0x81a1('0xc'),'foreignKey':_0x81a1('0x2d'),'model':'User','filter':{'field':_0x81a1('0x2f'),'value':['telephone']}},{'name':_0x81a1('0x31'),'field':_0x81a1('0xc'),'foreignKey':_0x81a1('0x32'),'model':_0x81a1('0x33'),'filter':{'field':_0x81a1('0xf'),'value':[_0x81a1('0x34')]}},{'name':_0x81a1('0x35'),'field':_0x81a1('0xc'),'foreignKey':_0x81a1('0x32'),'model':'VoiceQueue','filter':{'field':_0x81a1('0xf'),'value':['outbound']}}];break;case _0x81a1('0x36'):_0x3f4077[_0x81a1('0x11')]='VoiceMusicOnHold';break;case'chanspies':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x37');break;case _0x81a1('0x38'):_0x3f4077['childModel']=_0x81a1('0x39');break;case _0x81a1('0x3a'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x3b');break;case _0x81a1('0x3c'):_0x3f4077['childModel']=_0x81a1('0x3d');break;case _0x81a1('0x3e'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x3f');break;case'mailsubstatuses':_0x3f4077['childModel']=_0x81a1('0x40');break;case'openchannelqueues':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x41');break;case'openchannelaccounts':_0x3f4077['childModel']='OpenchannelAccount';break;case _0x81a1('0x42'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x43');break;case'smsaccounts':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x44');break;case _0x81a1('0x45'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x46');break;case _0x81a1('0x47'):_0x3f4077['childModel']=_0x81a1('0x48');break;case'teams':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x49');break;case _0x81a1('0x4a'):case _0x81a1('0x4b'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x33');if(_0x1a6e61){_0x3f4077[_0x81a1('0x13')]=[{'name':_0x81a1('0x31')},{'name':_0x81a1('0x35')}];}break;case _0x81a1('0x4c'):case _0x81a1('0x4d'):case _0x81a1('0x4e'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x2e');if(_0x1a6e61){_0x3f4077[_0x81a1('0x13')]=[{'name':'Users','filter':{'field':_0x81a1('0x2f'),'value':[_0x81a1('0x4f'),_0x81a1('0x50')]},'ignore':!![]},{'name':_0x81a1('0x2c')},{'name':_0x81a1('0x30')}];}break;case _0x81a1('0x51'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x52');break;case _0x81a1('0x53'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x54');break;case _0x81a1('0x55'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x56');break;case _0x81a1('0x57'):_0x3f4077['childModel']=_0x81a1('0x58');break;case _0x81a1('0x59'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x5a');break;case _0x81a1('0x5b'):_0x3f4077['childModel']=_0x81a1('0x5c');break;case _0x81a1('0x5d'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x2e');break;case'cannedanswers':_0x3f4077['childModel']=_0x81a1('0x5e');break;case _0x81a1('0x5f'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x60');break;case _0x81a1('0x61'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x62');break;case _0x81a1('0x63'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x64');break;case _0x81a1('0x65'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x66');break;case _0x81a1('0x67'):_0x3f4077['childModel']=_0x81a1('0x68');break;case _0x81a1('0x69'):_0x3f4077[_0x81a1('0x11')]='Sound';break;case'tags':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x6a');break;case _0x81a1('0x6b'):_0x3f4077['childModel']=_0x81a1('0x6c');break;case'triggers':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x6d');break;case'trunks':_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x6e');break;case _0x81a1('0x6f'):_0x3f4077[_0x81a1('0x11')]=_0x81a1('0x70');break;case _0x81a1('0x71'):_0x3f4077[_0x81a1('0x11')]='Plugin';break;case _0x81a1('0x72'):_0x3f4077[_0x81a1('0x11')]='AnalyticExtractedReport';_0x3f4077['parentSections']=[{'name':_0x81a1('0x73'),'field':'id','foreignKey':_0x81a1('0x74')}];break;case _0x81a1('0x75'):_0x3f4077['childModel']=_0x81a1('0x76');break;}return _0x3f4077;}function _0x3d1eb0(_0x279eed,_0xe0c816){var _0x5d77bc=_0x279eed[_0x81a1('0x77')](0x0)['toUpperCase']()+_0x279eed[_0x81a1('0x78')](0x1);var _0x5edd4e={'type':_0x11b845[_0x81a1('0x79')][_0x81a1('0x7a')][_0x81a1('0x7b')],'raw':!![]};return new Promise(function(_0x1b2500,_0x3d0da0){var _0x511cfd=squel['select']()[_0x81a1('0x4')](_0x81a1('0x7c')+_0x5d77bc+_0x81a1('0x7d'),'id')[_0x81a1('0x4')](_0x81a1('0x7e'))[_0x81a1('0x7f')]('user_has_'+_0x279eed+_0x81a1('0x80'),'ui')[_0x81a1('0x81')]('ui.UserId\x20=\x20?',_0xe0c816['id']);return _0x11b845[_0x81a1('0x82')][_0x81a1('0x83')](_0x511cfd[_0x81a1('0x84')](),_0x5edd4e)['then'](function(_0x538de0){_0xe0c816[_0x5d77bc+_0x81a1('0x85')]=_0x538de0;_0x1b2500(_0x538de0);})[_0x81a1('0x8')](function(_0x11807a){_0x3d0da0(_0x11807a);});});}return _0x1999a0[_0x81a1('0x86')]('UserProfile',attributes,{'tableName':'user_profiles','paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x1e2c66){var _0x2d61c5={'raw':_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x87')],'where':{}};var _0xe680f3={};var _0xa7f5ec={'count':0x0,'rows':[]};var _0x5b85ea=_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x88')];var _0x20f443=_0x1e2c66[_0x81a1('0x83')]['mergeResources']||![];var _0x33277b=_0x40fd8c(_0x5b85ea,_0x20f443);if(!_0x33277b[_0x81a1('0x11')])throw new Error(_0x81a1('0x89')+_0x5b85ea+'\x27');var _0x511841=[{'name':_0x5b85ea}];if(!_[_0x81a1('0x8a')](_0x33277b[_0x81a1('0x13')]))_0x511841=_0x33277b[_0x81a1('0x13')];var _0x3c88ee=[];for(var _0x250dc2=0x0;_0x250dc2<_0x511841[_0x81a1('0x8b')];_0x250dc2++){_0x3c88ee['push'](_0x11b845['UserProfileSection'][_0x81a1('0x8c')]({'where':{'userProfileId':_0x1e2c66[_0x81a1('0x8d')]['id'],'name':_0x511841[_0x250dc2]['name']},'raw':!![]}));}return Promise[_0x81a1('0x8e')](_0x3c88ee)[_0x81a1('0xa')](function(_0x165b39){var _0x4d229e=_[_0x81a1('0x3')](_0x165b39,function(_0x28941d){return _0x28941d?_0x28941d:undefined;});var _0x380cda=_[_0x81a1('0x3')](_0x511841,[_0x81a1('0x8f'),!![]]);var _0x4e59b0=_[_0x81a1('0x8a')](_0x4d229e)&&_[_0x81a1('0x8a')](_0x380cda)?null:_['union'](_0x380cda,_0x4d229e);if(!_0x4e59b0)return null;var _0x4580c0=[];for(var _0x26d37b=0x0;_0x26d37b<_0x4e59b0[_0x81a1('0x8b')];_0x26d37b++){var _0x3e49d9=_[_0x81a1('0x8c')](_0x511841,function(_0x5cc3fb){return _0x4e59b0[_0x26d37b]?_0x5cc3fb[_0x81a1('0xc')]===_0x4e59b0[_0x26d37b]['name']:null;});if(_0x3e49d9){if(_0x4e59b0[_0x26d37b][_0x81a1('0x8f')]){_0x4580c0[_0x81a1('0x90')](_0x23a249(_0x33277b[_0x81a1('0x11')],_0x4e59b0[_0x26d37b]));}else{if(!_0x4e59b0[_0x26d37b]['autoAssociation']){_0x4580c0['push'](_0x38239f(_0x3e49d9,_0x4e59b0[_0x26d37b],_0x33277b['childModel']));}else{if(_0x3e49d9[_0x81a1('0x9')]){_0x4580c0[_0x81a1('0x90')](_0x4ac0f0(_0x3e49d9,_0x4e59b0[_0x26d37b]));}}}}}return Promise['all'](_0x4580c0);})[_0x81a1('0xa')](function(_0x26a5dc){var _0x26649b=_0x26a5dc;var _0x1856ca=null;if(_0x26649b){_0x1856ca=_0x26649b['length']===0x1?_0x26649b[0x0]:null;}if(!_0x1856ca&&!_0x26649b)return _0xa7f5ec;var _0x5462f6=_0x11b845[_0x33277b['childModel']][_0x81a1('0x91')];_0xe680f3[_0x81a1('0x9')]=_['keys'](_0x5462f6);_0xe680f3['query']=_['keys'](_0x1e2c66[_0x81a1('0x83')]);_0xe680f3[_0x81a1('0x92')]=_[_0x81a1('0x93')](_0xe680f3['model'],_0xe680f3['query']);_0x2d61c5[_0x81a1('0x94')]=_['intersection'](_0xe680f3[_0x81a1('0x9')],qs[_0x81a1('0x95')](_0x1e2c66['query'][_0x81a1('0x95')]));_0x2d61c5[_0x81a1('0x94')]=_0x2d61c5[_0x81a1('0x94')]['length']?_0x2d61c5['attributes']:_0xe680f3['model'];if(!_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x96')](_0x81a1('0x97'))){_0x2d61c5[_0x81a1('0x98')]=qs[_0x81a1('0x98')](_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x98')]);_0x2d61c5[_0x81a1('0x99')]=qs[_0x81a1('0x99')](_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x99')]);}_0x2d61c5[_0x81a1('0x9a')]=qs[_0x81a1('0x9b')](_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x9b')]);_0x2d61c5[_0x81a1('0x81')]=qs['filters'](_[_0x81a1('0x9c')](_0x1e2c66[_0x81a1('0x83')],_0xe680f3[_0x81a1('0x92')]));if(_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x3')]){_0x2d61c5['where']=_[_0x81a1('0x9d')](_0x2d61c5[_0x81a1('0x81')],{'$or':_[_0x81a1('0xb')](_0x5462f6,function(_0x136910){if(_0x136910['type'][_0x81a1('0x9e')]!==_0x81a1('0x9f')){var _0x17ea55={};_0x17ea55[_0x136910[_0x81a1('0x4')]]={'$like':'%'+_0x1e2c66[_0x81a1('0x83')][_0x81a1('0x3')]+'%'};return _0x17ea55;}})});}var _0x5e5fe2=[];var _0x2c5f85=null;var _0x13df41={};if(_0x1856ca){_0x2c5f85=_[_0x81a1('0x8c')](_0x511841,['name',_0x1856ca[_0x81a1('0xc')]]);if(_0x2c5f85[_0x81a1('0x4')]){_0x13df41={};if(_0x33277b[_0x81a1('0x11')]===_0x81a1('0xa0')){_0x13df41[_0x2c5f85[_0x81a1('0xa1')]]=_['map'](_0x1856ca[_0x81a1('0x7')],'id');}else{_0x13df41[_0x2c5f85[_0x81a1('0xa1')]]=_0x1856ca[_0x81a1('0x7')];}_0x5e5fe2[_0x81a1('0x90')](_0x13df41);}else{_0x2d61c5['where']['id']=_0x1856ca['associatedResources'];}}else{for(var _0x230bad=0x0;_0x230bad<_0x26649b[_0x81a1('0x8b')];_0x230bad++){_0x2c5f85=_['find'](_0x511841,[_0x81a1('0xc'),_0x26649b[_0x230bad][_0x81a1('0xc')]]);if(_0x2c5f85[_0x81a1('0x4')]){_0x13df41={};_0x13df41[_0x2c5f85[_0x81a1('0xa1')]]=_0x26649b[_0x230bad][_0x81a1('0x7')];_0x5e5fe2[_0x81a1('0x90')](_0x13df41);}else{if(!_0x2d61c5['where']['id'])_0x2d61c5[_0x81a1('0x81')]['id']=[];_0x26649b[_0x230bad][_0x81a1('0x7')][_0x81a1('0xa2')](function(_0xcc9e1){_0x2d61c5[_0x81a1('0x81')]['id'][_0x81a1('0x90')](_0xcc9e1);});}}}if(!_['isEmpty'](_0x5e5fe2)){_0x2d61c5[_0x81a1('0x81')]=_[_0x81a1('0x9d')](_0x2d61c5[_0x81a1('0x81')],{'$and':{'$or':_0x5e5fe2}});}_0x2d61c5=_[_0x81a1('0x9d')]({},_0x2d61c5,_0x1e2c66[_0x81a1('0xa3')]);if(_0x1856ca&&!_0x1856ca[_0x81a1('0xa4')]&&_0x33277b[_0x81a1('0x11')]===_0x81a1('0xa0')){if(_0x1e2c66[_0x81a1('0x83')]['includeAll']){_0x2d61c5['include']=[{'all':!![]}];}return _0x11b845[_0x33277b[_0x81a1('0x11')]][_0x81a1('0x6')](_0x2d61c5)['then'](function(_0x1afd69){var _0x5f2c05=[];_0x1afd69[_0x81a1('0xa2')](function(_0x39f4cc){var _0x44e443;switch(_0x39f4cc[_0x81a1('0xa5')]){case _0x81a1('0xa6'):_0x44e443=_[_0x81a1('0x8c')](_0x1856ca[_0x81a1('0x7')],function(_0x5f3a29){return _0x5f3a29['id']===_0x39f4cc[_0x81a1('0x74')]&&_0x5f3a29['type']===_0x81a1('0xa7');});break;case _0x81a1('0xa8'):_0x44e443=_[_0x81a1('0x8c')](_0x1856ca['associatedResources'],function(_0x4a276b){return _0x4a276b['id']===_0x39f4cc[_0x81a1('0x74')]&&_0x4a276b[_0x81a1('0xf')]===_0x81a1('0xa9');});break;}if(_0x44e443)_0x5f2c05[_0x81a1('0x90')](_0x39f4cc);});_0xa7f5ec[_0x81a1('0xaa')]=_0x5f2c05[_0x81a1('0x8b')];_0xa7f5ec['rows']=_0x5f2c05;return _0xa7f5ec;});}else{if(!_[_0x81a1('0x8a')](_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xab')])){_0x2d61c5[_0x81a1('0x81')]['id']=_0x2d61c5[_0x81a1('0x81')]['id']?_[_0x81a1('0x93')](_0x2d61c5[_0x81a1('0x81')]['id'],_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xab')]):_0x1e2c66['query'][_0x81a1('0xab')];if(_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xac')]){_0x2d61c5[_0x81a1('0x9a')]=_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xac')];}}if(_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xad')]){_0x2d61c5[_0x81a1('0x81')]=_[_0x81a1('0x9d')](_0x2d61c5[_0x81a1('0x81')],{'$and':_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xad')]});}return _0x11b845[_0x33277b['childModel']][_0x81a1('0xaa')]({'where':_0x2d61c5['where']})['then'](function(_0x59f039){_0xa7f5ec['count']=_0x59f039;if(_0x1e2c66['query'][_0x81a1('0xae')]){if(_0x33277b[_0x81a1('0x11')]==='CmContact'){_0x2d61c5[_0x81a1('0xaf')]=[{'model':_0x11b845[_0x81a1('0x6a')],'as':_0x81a1('0xb0'),'attributes':['id',_0x81a1('0xc'),_0x81a1('0xb1')],'required':_0x1e2c66['query'][_0x81a1('0xb2')]?!![]:![]},{'model':_0x11b845[_0x81a1('0x6a')],'as':_0x81a1('0xb3'),'attributes':['id',_0x81a1('0xc'),_0x81a1('0xb1')],'through':_0x1e2c66['query'][_0x81a1('0xb2')]?{'attributes':[],'where':{'TagId':_0x1e2c66['query'][_0x81a1('0xb2')]||undefined}}:{},'required':_0x1e2c66[_0x81a1('0x83')]['tag']?!![]:![]}];}else{_0x2d61c5[_0x81a1('0xaf')]=[{'all':!![]}];}}return _0x11b845[_0x33277b[_0x81a1('0x11')]]['findAll'](_0x2d61c5);})[_0x81a1('0xa')](function(_0x183e48){_0xa7f5ec[_0x81a1('0xb4')]=_0x183e48;if(_0x5b85ea===_0x81a1('0x2c')&&_0x1e2c66[_0x81a1('0x83')][_0x81a1('0xb5')]===_0x81a1('0xb6')){var _0x110e3d=[];for(var _0x19f677=0x0;_0x19f677<_0xa7f5ec[_0x81a1('0xb4')]['length'];_0x19f677++){_0x110e3d['push'](_0x3d1eb0('chat',_0xa7f5ec[_0x81a1('0xb4')][_0x19f677]['dataValues']));_0x110e3d['push'](_0x3d1eb0(_0x81a1('0xb7'),_0xa7f5ec[_0x81a1('0xb4')][_0x19f677][_0x81a1('0xb8')]));_0x110e3d[_0x81a1('0x90')](_0x3d1eb0(_0x81a1('0xb9'),_0xa7f5ec['rows'][_0x19f677][_0x81a1('0xb8')]));_0x110e3d[_0x81a1('0x90')](_0x3d1eb0(_0x81a1('0xba'),_0xa7f5ec['rows'][_0x19f677][_0x81a1('0xb8')]));_0x110e3d[_0x81a1('0x90')](_0x3d1eb0(_0x81a1('0xbb'),_0xa7f5ec[_0x81a1('0xb4')][_0x19f677][_0x81a1('0xb8')]));_0x110e3d[_0x81a1('0x90')](_0x3d1eb0(_0x81a1('0xbc'),_0xa7f5ec[_0x81a1('0xb4')][_0x19f677]['dataValues']));}return Promise[_0x81a1('0x8e')](_0x110e3d)[_0x81a1('0xa')](function(){return _0xa7f5ec;});}return _0xa7f5ec;});}});}}});};