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 _0x24a8=['where','ui.UserId\x20=\x20?','sequelize','query','toString','define','UserProfile','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','UserProfileSection','find','params','all','ignore','union','push','autoAssociation','model','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','merge','key','VIRTUAL','foreignKey','forEach','options','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','extraQueryConditions','includeAll','include','Tags','color','tag','ThroughTags','openTabs','true','dataValues','sms','fax','mail','whatsapp','../../components/parsers/qs','squel','exports','models','filter','field','value','findAll','then','map','catch','associatedResources','name','UserProfileResource','AnalyticExtractedReport','resourceId','squareprojects','SquareProject','odbc','childModel','SquareOdbc','SquareRecording','parentSections','SquareProjects','projects','JscriptyProject','contacts','CmContact','ListId','lists','CmList','CmCompany','chatqueues','ChatQueue','chatwebsites','ChatWebsite','faxqueues','faxaccounts','internalroutes','VoiceExtension','contexts','VoiceContext','VoiceMail','voicerecordings','Agents','membername','User','role','agent','Telephones','VoiceQueues','queue','type','inbound','QueueCampaigns','VoiceQueue','outbound','musiconholds','VoiceMusicOnHold','VoiceChanSpy','VoicePrefix','ivrcampaigns','MailQueue','MailAccount','mailsubstatuses','openchannelqueues','OpenchannelQueue','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappaccounts','teams','Team','voicequeues','queuecampaigns','users','agents','telephones','admin','user','zendeskaccounts','salesforceaccounts','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','cannedanswers','CannedAnswer','dispositions','Disposition','Dashboard','intervals','pauses','Pause','Schedule','sounds','Sound','tags','Tag','templates','triggers','trunks','Trunk','variables','plugins','Plugin','Reports','reportId','charAt','toUpperCase','slice','Sequelize','QueryTypes','SELECT','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions'];(function(_0x339d3c,_0x1a9760){var _0xc5f118=function(_0x54cb02){while(--_0x54cb02){_0x339d3c['push'](_0x339d3c['shift']());}};_0xc5f118(++_0x1a9760);}(_0x24a8,0xf9));var _0x824a=function(_0x5730d5,_0x44fea4){_0x5730d5=_0x5730d5-0x0;var _0x27abe7=_0x24a8[_0x5730d5];return _0x27abe7;};'use strict';var _=require('lodash');var attributes=require('./userProfile.attributes');var qs=require(_0x824a('0x0'));var squel=require(_0x824a('0x1'));module[_0x824a('0x2')]=function(_0x51848e){var _0x3806ac=_0x51848e[_0x824a('0x3')];function _0x4407ab(_0x385dea,_0x237a27){return new Promise(function(_0x3fcfc5,_0x5aad7a){if(!_0x237a27)return _0x3fcfc5(null);var _0x55abd3=_0x237a27[_0x824a('0x4')]?{[_0x237a27[_0x824a('0x4')][_0x824a('0x5')]]:_0x237a27[_0x824a('0x4')][_0x824a('0x6')]}:undefined;return _0x3806ac[_0x385dea][_0x824a('0x7')]({'where':_0x55abd3,'raw':!![]})[_0x824a('0x8')](function(_0x3ee472){_0x237a27['associatedResources']=_[_0x824a('0x9')](_0x3ee472,'id');_0x3fcfc5(_0x237a27);})[_0x824a('0xa')](function(_0x470625){_0x5aad7a(_0x470625);});});}function _0x54c153(_0x3d5515,_0x26d1fe){return new Promise(function(_0x22a70c,_0x5065a2){var _0x4e1625=_0x3d5515[_0x824a('0x4')]?{[_0x3d5515[_0x824a('0x4')][_0x824a('0x5')]]:_0x3d5515[_0x824a('0x4')][_0x824a('0x6')]}:undefined;return _0x3806ac[_0x3d5515['model']]['findAll']({'where':_0x4e1625,'raw':!![]})['then'](function(_0x44c887){_0x26d1fe[_0x824a('0xb')]=_['map'](_0x44c887,function(_0x34c164){return _0x34c164[_0x824a('0xc')];});_0x22a70c(_0x26d1fe);})['catch'](function(_0x269b88){_0x5065a2(_0x269b88);});});}function _0xd51c05(_0x381ab1,_0x317c5c,_0xe5f224){if(!_0x317c5c)return Promise['resolve'](null);return new Promise(function(_0x4ed02c,_0x171533){return _0x3806ac[_0x824a('0xd')]['findAll']({'where':{'sectionId':_0x317c5c['id']},'raw':!![]})[_0x824a('0x8')](function(_0x44c506){if(_0x381ab1[_0x824a('0x5')]&&_0x381ab1[_0x824a('0x5')]!=='id'){_0x317c5c[_0x824a('0xb')]=_['map'](_0x44c506,function(_0x3169bb){return _0x3169bb[_0x381ab1['field']];});}else{if(_0xe5f224===_0x824a('0xe')){_0x317c5c['associatedResources']=_['map'](_0x44c506,function(_0x39e77c){return{'id':_0x39e77c[_0x824a('0xf')],'type':_0x39e77c['type']};});}else{_0x317c5c[_0x824a('0xb')]=_['map'](_0x44c506,function(_0x35cddb){return _0x35cddb[_0x824a('0xf')];});}}_0x4ed02c(_0x317c5c);})['catch'](function(_0xaba491){_0x171533(_0xaba491);});});}function _0xac75d(_0x1c3bab,_0x35bb09){var _0x58c65c={'parentSections':[]};switch(_0x1c3bab['toLowerCase']()){case _0x824a('0x10'):_0x58c65c['childModel']=_0x824a('0x11');break;case _0x824a('0x12'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x14');break;case'squarerecordings':_0x58c65c[_0x824a('0x13')]=_0x824a('0x15');_0x58c65c[_0x824a('0x16')]=[{'name':_0x824a('0x17'),'field':'name','foreignKey':'projectName'}];break;case _0x824a('0x18'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x19');break;case _0x824a('0x1a'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x1b');_0x58c65c[_0x824a('0x16')]=[{'name':'Lists','field':'id','foreignKey':_0x824a('0x1c')}];break;case _0x824a('0x1d'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x1e');break;case'companies':_0x58c65c[_0x824a('0x13')]=_0x824a('0x1f');break;case'globalcustomfields':_0x58c65c[_0x824a('0x13')]='CmCustomField';break;case _0x824a('0x20'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x21');break;case _0x824a('0x22'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x23');break;case _0x824a('0x24'):_0x58c65c[_0x824a('0x13')]='FaxQueue';break;case _0x824a('0x25'):_0x58c65c[_0x824a('0x13')]='FaxAccount';break;case'inboundroutes':case _0x824a('0x26'):case'outboundroutes':_0x58c65c['childModel']=_0x824a('0x27');break;case _0x824a('0x28'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x29');break;case'voicemails':_0x58c65c['childModel']=_0x824a('0x2a');break;case _0x824a('0x2b'):_0x58c65c['childModel']='VoiceRecording';_0x58c65c[_0x824a('0x16')]=[{'name':_0x824a('0x2c'),'field':_0x824a('0xc'),'foreignKey':_0x824a('0x2d'),'model':_0x824a('0x2e'),'filter':{'field':_0x824a('0x2f'),'value':[_0x824a('0x30')]}},{'name':_0x824a('0x31'),'field':'name','foreignKey':_0x824a('0x2d'),'model':_0x824a('0x2e'),'filter':{'field':_0x824a('0x2f'),'value':['telephone']}},{'name':_0x824a('0x32'),'field':'name','foreignKey':_0x824a('0x33'),'model':'VoiceQueue','filter':{'field':_0x824a('0x34'),'value':[_0x824a('0x35')]}},{'name':_0x824a('0x36'),'field':_0x824a('0xc'),'foreignKey':_0x824a('0x33'),'model':_0x824a('0x37'),'filter':{'field':_0x824a('0x34'),'value':[_0x824a('0x38')]}}];break;case _0x824a('0x39'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x3a');break;case'chanspies':_0x58c65c[_0x824a('0x13')]=_0x824a('0x3b');break;case'voiceprefixes':_0x58c65c['childModel']=_0x824a('0x3c');break;case _0x824a('0x3d'):_0x58c65c[_0x824a('0x13')]='Campaign';break;case'mailqueues':_0x58c65c[_0x824a('0x13')]=_0x824a('0x3e');break;case'mailaccounts':_0x58c65c[_0x824a('0x13')]=_0x824a('0x3f');break;case _0x824a('0x40'):_0x58c65c[_0x824a('0x13')]='MailSubstatus';break;case _0x824a('0x41'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x42');break;case'openchannelaccounts':_0x58c65c[_0x824a('0x13')]=_0x824a('0x43');break;case _0x824a('0x44'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x45');break;case _0x824a('0x46'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x47');break;case'whatsappqueues':_0x58c65c['childModel']='WhatsappQueue';break;case _0x824a('0x48'):_0x58c65c['childModel']='WhatsappAccount';break;case _0x824a('0x49'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x4a');break;case _0x824a('0x4b'):case _0x824a('0x4c'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x37');if(_0x35bb09){_0x58c65c[_0x824a('0x16')]=[{'name':_0x824a('0x32')},{'name':_0x824a('0x36')}];}break;case _0x824a('0x4d'):case _0x824a('0x4e'):case _0x824a('0x4f'):_0x58c65c['childModel']=_0x824a('0x2e');if(_0x35bb09){_0x58c65c[_0x824a('0x16')]=[{'name':'Users','filter':{'field':_0x824a('0x2f'),'value':[_0x824a('0x50'),_0x824a('0x51')]},'ignore':!![]},{'name':_0x824a('0x2c')},{'name':_0x824a('0x31')}];}break;case _0x824a('0x52'):_0x58c65c[_0x824a('0x13')]='ZendeskAccount';break;case _0x824a('0x53'):_0x58c65c[_0x824a('0x13')]='SalesforceAccount';break;case _0x824a('0x54'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x55');break;case _0x824a('0x56'):_0x58c65c['childModel']=_0x824a('0x57');break;case _0x824a('0x58'):_0x58c65c['childModel']=_0x824a('0x59');break;case _0x824a('0x5a'):_0x58c65c[_0x824a('0x13')]='ZohoAccount';break;case'vtigeraccounts':_0x58c65c[_0x824a('0x13')]=_0x824a('0x2e');break;case _0x824a('0x5b'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x5c');break;case _0x824a('0x5d'):_0x58c65c['childModel']=_0x824a('0x5e');break;case'customdashboards':_0x58c65c[_0x824a('0x13')]=_0x824a('0x5f');break;case _0x824a('0x60'):_0x58c65c[_0x824a('0x13')]='Interval';break;case _0x824a('0x61'):_0x58c65c['childModel']=_0x824a('0x62');break;case'scheduler':_0x58c65c[_0x824a('0x13')]=_0x824a('0x63');break;case _0x824a('0x64'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x65');break;case _0x824a('0x66'):_0x58c65c[_0x824a('0x13')]=_0x824a('0x67');break;case _0x824a('0x68'):_0x58c65c['childModel']='Template';break;case _0x824a('0x69'):_0x58c65c['childModel']='Trigger';break;case _0x824a('0x6a'):_0x58c65c['childModel']=_0x824a('0x6b');break;case _0x824a('0x6c'):_0x58c65c[_0x824a('0x13')]='Variable';break;case _0x824a('0x6d'):_0x58c65c['childModel']=_0x824a('0x6e');break;case'extractedreports':_0x58c65c['childModel']=_0x824a('0xe');_0x58c65c['parentSections']=[{'name':_0x824a('0x6f'),'field':'id','foreignKey':_0x824a('0x70')}];break;case'metrics':_0x58c65c[_0x824a('0x13')]='AnalyticMetric';break;}return _0x58c65c;}function _0x2aaadc(_0x48d9fb,_0x1c3078){var _0x3d9e2c=_0x48d9fb[_0x824a('0x71')](0x0)[_0x824a('0x72')]()+_0x48d9fb[_0x824a('0x73')](0x1);var _0x4a2ab1={'type':_0x3806ac[_0x824a('0x74')][_0x824a('0x75')][_0x824a('0x76')],'raw':!![]};return new Promise(function(_0x494dab,_0x37ff48){var _0x579086=squel['select']()[_0x824a('0x5')](_0x824a('0x77')+_0x3d9e2c+_0x824a('0x78'),'id')[_0x824a('0x5')](_0x824a('0x79'))[_0x824a('0x7a')](_0x824a('0x7b')+_0x48d9fb+_0x824a('0x7c'),'ui')[_0x824a('0x7d')](_0x824a('0x7e'),_0x1c3078['id']);return _0x3806ac[_0x824a('0x7f')][_0x824a('0x80')](_0x579086[_0x824a('0x81')](),_0x4a2ab1)[_0x824a('0x8')](function(_0x4a87a4){_0x1c3078[_0x3d9e2c+'OpenTabs']=_0x4a87a4;_0x494dab(_0x4a87a4);})[_0x824a('0xa')](function(_0x327bcb){_0x37ff48(_0x327bcb);});});}return _0x51848e[_0x824a('0x82')](_0x824a('0x83'),attributes,{'tableName':_0x824a('0x84'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x4110ab){var _0x51058b={'raw':_0x4110ab[_0x824a('0x80')][_0x824a('0x85')],'where':{}};var _0x30b4e0={};var _0x5498eb={'count':0x0,'rows':[]};var _0x58447a=_0x4110ab[_0x824a('0x80')][_0x824a('0x86')];var _0x1afbca=_0x4110ab[_0x824a('0x80')][_0x824a('0x87')]||![];var _0x5459ff=_0xac75d(_0x58447a,_0x1afbca);if(!_0x5459ff[_0x824a('0x13')])throw new Error(_0x824a('0x88')+_0x58447a+'\x27');var _0x2e8417=[{'name':_0x58447a}];if(!_[_0x824a('0x89')](_0x5459ff[_0x824a('0x16')]))_0x2e8417=_0x5459ff[_0x824a('0x16')];var _0x35a56d=[];for(var _0x301dd9=0x0;_0x301dd9<_0x2e8417[_0x824a('0x8a')];_0x301dd9++){_0x35a56d['push'](_0x3806ac[_0x824a('0x8b')][_0x824a('0x8c')]({'where':{'userProfileId':_0x4110ab[_0x824a('0x8d')]['id'],'name':_0x2e8417[_0x301dd9][_0x824a('0xc')]},'raw':!![]}));}return Promise[_0x824a('0x8e')](_0x35a56d)['then'](function(_0x46c684){var _0x8ad4dc=_['filter'](_0x46c684,function(_0x190328){return _0x190328?_0x190328:undefined;});var _0x358d9b=_['filter'](_0x2e8417,[_0x824a('0x8f'),!![]]);var _0x2ec809=_[_0x824a('0x89')](_0x8ad4dc)&&_[_0x824a('0x89')](_0x358d9b)?null:_[_0x824a('0x90')](_0x358d9b,_0x8ad4dc);if(!_0x2ec809)return null;var _0x37bd64=[];for(var _0x3b8cd9=0x0;_0x3b8cd9<_0x2ec809[_0x824a('0x8a')];_0x3b8cd9++){var _0x26cd1b=_[_0x824a('0x8c')](_0x2e8417,function(_0x2ed28c){return _0x2ec809[_0x3b8cd9]?_0x2ed28c[_0x824a('0xc')]===_0x2ec809[_0x3b8cd9][_0x824a('0xc')]:null;});if(_0x26cd1b){if(_0x2ec809[_0x3b8cd9][_0x824a('0x8f')]){_0x37bd64[_0x824a('0x91')](_0x4407ab(_0x5459ff['childModel'],_0x2ec809[_0x3b8cd9]));}else{if(!_0x2ec809[_0x3b8cd9][_0x824a('0x92')]){_0x37bd64['push'](_0xd51c05(_0x26cd1b,_0x2ec809[_0x3b8cd9],_0x5459ff[_0x824a('0x13')]));}else{if(_0x26cd1b[_0x824a('0x93')]){_0x37bd64[_0x824a('0x91')](_0x54c153(_0x26cd1b,_0x2ec809[_0x3b8cd9]));}}}}}return Promise['all'](_0x37bd64);})['then'](function(_0x195d71){var _0x16be70=_0x195d71;var _0x299942=null;if(_0x16be70){_0x299942=_0x16be70[_0x824a('0x8a')]===0x1?_0x16be70[0x0]:null;}if(!_0x299942&&!_0x16be70)return _0x5498eb;var _0x32f66f=_0x3806ac[_0x5459ff['childModel']][_0x824a('0x94')];_0x30b4e0[_0x824a('0x93')]=_[_0x824a('0x95')](_0x32f66f);_0x30b4e0[_0x824a('0x80')]=_[_0x824a('0x95')](_0x4110ab[_0x824a('0x80')]);_0x30b4e0[_0x824a('0x96')]=_[_0x824a('0x97')](_0x30b4e0['model'],_0x30b4e0[_0x824a('0x80')]);_0x51058b[_0x824a('0x98')]=_[_0x824a('0x97')](_0x30b4e0[_0x824a('0x93')],qs['fields'](_0x4110ab[_0x824a('0x80')][_0x824a('0x99')]));_0x51058b[_0x824a('0x98')]=_0x51058b[_0x824a('0x98')][_0x824a('0x8a')]?_0x51058b[_0x824a('0x98')]:_0x30b4e0[_0x824a('0x93')];if(!_0x4110ab[_0x824a('0x80')][_0x824a('0x9a')](_0x824a('0x9b'))){_0x51058b[_0x824a('0x9c')]=qs['limit'](_0x4110ab[_0x824a('0x80')][_0x824a('0x9c')]);_0x51058b['offset']=qs[_0x824a('0x9d')](_0x4110ab[_0x824a('0x80')]['offset']);}_0x51058b[_0x824a('0x9e')]=qs['sort'](_0x4110ab[_0x824a('0x80')][_0x824a('0x9f')]);_0x51058b[_0x824a('0x7d')]=qs['filters'](_['pick'](_0x4110ab['query'],_0x30b4e0[_0x824a('0x96')]));if(_0x4110ab['query']['filter']){_0x51058b[_0x824a('0x7d')]=_[_0x824a('0xa0')](_0x51058b[_0x824a('0x7d')],{'$or':_[_0x824a('0x9')](_0x32f66f,function(_0xc2cdcb){if(_0xc2cdcb[_0x824a('0x34')][_0x824a('0xa1')]!==_0x824a('0xa2')){var _0x5f44a8={};_0x5f44a8[_0xc2cdcb[_0x824a('0x5')]]={'$like':'%'+_0x4110ab[_0x824a('0x80')][_0x824a('0x4')]+'%'};return _0x5f44a8;}})});}var _0x2fd767=[];var _0x6f44af=null;var _0x563190={};if(_0x299942){_0x6f44af=_[_0x824a('0x8c')](_0x2e8417,[_0x824a('0xc'),_0x299942[_0x824a('0xc')]]);if(_0x6f44af[_0x824a('0x5')]){_0x563190={};if(_0x5459ff[_0x824a('0x13')]==='AnalyticExtractedReport'){_0x563190[_0x6f44af[_0x824a('0xa3')]]=_[_0x824a('0x9')](_0x299942[_0x824a('0xb')],'id');}else{_0x563190[_0x6f44af[_0x824a('0xa3')]]=_0x299942[_0x824a('0xb')];}_0x2fd767['push'](_0x563190);}else{_0x51058b[_0x824a('0x7d')]['id']=_0x299942[_0x824a('0xb')];}}else{for(var _0x79b255=0x0;_0x79b255<_0x16be70['length'];_0x79b255++){_0x6f44af=_['find'](_0x2e8417,[_0x824a('0xc'),_0x16be70[_0x79b255]['name']]);if(_0x6f44af['field']){_0x563190={};_0x563190[_0x6f44af[_0x824a('0xa3')]]=_0x16be70[_0x79b255]['associatedResources'];_0x2fd767['push'](_0x563190);}else{if(!_0x51058b['where']['id'])_0x51058b[_0x824a('0x7d')]['id']=[];_0x16be70[_0x79b255]['associatedResources'][_0x824a('0xa4')](function(_0x5e9127){_0x51058b[_0x824a('0x7d')]['id'][_0x824a('0x91')](_0x5e9127);});}}}if(!_[_0x824a('0x89')](_0x2fd767)){_0x51058b[_0x824a('0x7d')]=_[_0x824a('0xa0')](_0x51058b[_0x824a('0x7d')],{'$and':{'$or':_0x2fd767}});}_0x51058b=_[_0x824a('0xa0')]({},_0x51058b,_0x4110ab[_0x824a('0xa5')]);if(_0x299942&&!_0x299942[_0x824a('0x92')]&&_0x5459ff['childModel']===_0x824a('0xe')){if(_0x4110ab[_0x824a('0x80')]['includeAll']){_0x51058b['include']=[{'all':!![]}];}return _0x3806ac[_0x5459ff['childModel']][_0x824a('0x7')](_0x51058b)[_0x824a('0x8')](function(_0x3e6959){var _0x27ec4c=[];_0x3e6959[_0x824a('0xa4')](function(_0x255791){var _0x5b194f;switch(_0x255791['reportType']){case'default':_0x5b194f=_['find'](_0x299942[_0x824a('0xb')],function(_0x4c8e3a){return _0x4c8e3a['id']===_0x255791[_0x824a('0x70')]&&_0x4c8e3a[_0x824a('0x34')]===_0x824a('0xa6');});break;case _0x824a('0xa7'):_0x5b194f=_['find'](_0x299942[_0x824a('0xb')],function(_0x4619f0){return _0x4619f0['id']===_0x255791[_0x824a('0x70')]&&_0x4619f0[_0x824a('0x34')]===_0x824a('0xa8');});break;}if(_0x5b194f)_0x27ec4c[_0x824a('0x91')](_0x255791);});_0x5498eb[_0x824a('0xa9')]=_0x27ec4c[_0x824a('0x8a')];_0x5498eb[_0x824a('0xaa')]=_0x27ec4c;return _0x5498eb;});}else{if(!_[_0x824a('0x89')](_0x4110ab[_0x824a('0x80')][_0x824a('0xab')])){_0x51058b[_0x824a('0x7d')]['id']=_0x51058b[_0x824a('0x7d')]['id']?_[_0x824a('0x97')](_0x51058b['where']['id'],_0x4110ab[_0x824a('0x80')][_0x824a('0xab')]):_0x4110ab[_0x824a('0x80')][_0x824a('0xab')];if(_0x4110ab[_0x824a('0x80')][_0x824a('0xac')]){_0x51058b['order']=_0x4110ab[_0x824a('0x80')][_0x824a('0xac')];}}if(_0x4110ab[_0x824a('0x80')]['extraQueryConditions']){_0x51058b['where']=_[_0x824a('0xa0')](_0x51058b[_0x824a('0x7d')],{'$and':_0x4110ab[_0x824a('0x80')][_0x824a('0xad')]});}return _0x3806ac[_0x5459ff[_0x824a('0x13')]][_0x824a('0xa9')]({'where':_0x51058b[_0x824a('0x7d')]})[_0x824a('0x8')](function(_0x5c8042){_0x5498eb[_0x824a('0xa9')]=_0x5c8042;if(_0x4110ab[_0x824a('0x80')][_0x824a('0xae')]){if(_0x5459ff[_0x824a('0x13')]==='CmContact'){_0x51058b[_0x824a('0xaf')]=[{'model':_0x3806ac[_0x824a('0x67')],'as':_0x824a('0xb0'),'attributes':['id','name',_0x824a('0xb1')],'required':_0x4110ab['query'][_0x824a('0xb2')]?!![]:![]},{'model':_0x3806ac['Tag'],'as':_0x824a('0xb3'),'attributes':['id',_0x824a('0xc'),_0x824a('0xb1')],'through':_0x4110ab[_0x824a('0x80')]['tag']?{'attributes':[],'where':{'TagId':_0x4110ab['query']['tag']||undefined}}:{},'required':_0x4110ab[_0x824a('0x80')][_0x824a('0xb2')]?!![]:![]}];}else{_0x51058b['include']=[{'all':!![]}];}}return _0x3806ac[_0x5459ff[_0x824a('0x13')]][_0x824a('0x7')](_0x51058b);})['then'](function(_0x66c588){_0x5498eb[_0x824a('0xaa')]=_0x66c588;if(_0x58447a===_0x824a('0x2c')&&_0x4110ab['query'][_0x824a('0xb4')]===_0x824a('0xb5')){var _0x1d1bca=[];for(var _0x23f047=0x0;_0x23f047<_0x5498eb[_0x824a('0xaa')][_0x824a('0x8a')];_0x23f047++){_0x1d1bca[_0x824a('0x91')](_0x2aaadc('chat',_0x5498eb[_0x824a('0xaa')][_0x23f047][_0x824a('0xb6')]));_0x1d1bca[_0x824a('0x91')](_0x2aaadc(_0x824a('0xb7'),_0x5498eb[_0x824a('0xaa')][_0x23f047][_0x824a('0xb6')]));_0x1d1bca[_0x824a('0x91')](_0x2aaadc(_0x824a('0xb8'),_0x5498eb['rows'][_0x23f047]['dataValues']));_0x1d1bca[_0x824a('0x91')](_0x2aaadc(_0x824a('0xb9'),_0x5498eb[_0x824a('0xaa')][_0x23f047]['dataValues']));_0x1d1bca[_0x824a('0x91')](_0x2aaadc('openchannel',_0x5498eb[_0x824a('0xaa')][_0x23f047]['dataValues']));_0x1d1bca[_0x824a('0x91')](_0x2aaadc(_0x824a('0xba'),_0x5498eb['rows'][_0x23f047][_0x824a('0xb6')]));}return Promise[_0x824a('0x8e')](_0x1d1bca)[_0x824a('0x8')](function(){return _0x5498eb;});}return _0x5498eb;});}});}}});};