c92bbc39b25847eae220c003179b21cbccbbd5e9
[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 _0x9a69=['freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','DeskAccount','vtigeraccounts','cannedanswers','CannedAnswer','Disposition','customdashboards','Interval','pauses','Pause','scheduler','sounds','Sound','tags','Template','Trigger','trunks','Variable','plugins','Plugin','extractedreports','reportId','metrics','charAt','toUpperCase','SELECT','select','ui.','ui.createdAt','from','user_has_','_interactions','where','sequelize','query','toString','OpenTabs','user_profiles','../../components/parsers/qs','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','find','all','union','length','ignore','autoAssociation','rawAttributes','keys','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','filters','pick','key','VIRTUAL','foreignKey','forEach','merge','options','include','DefaultReports','custom','CustomReports','count','ids','extraQueryConditions','includeAll','Tag','color','ThroughTags','tag','rows','openTabs','dataValues','sms','openchannel','whatsapp','lodash','./userProfile.attributes','squel','exports','models','filter','field','findAll','then','associatedResources','map','value','model','name','catch','resolve','AnalyticExtractedReport','type','resourceId','squareprojects','childModel','odbc','SquareOdbc','squarerecordings','SquareRecording','SquareProjects','projectName','JscriptyProject','contacts','parentSections','Lists','ListId','lists','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','faxqueues','FaxQueue','FaxAccount','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceMail','voicerecordings','Agents','membername','User','agent','Telephones','role','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','whatsappqueues','WhatsappQueue','WhatsappAccount','Team','voicequeues','queuecampaigns','users','telephones','Users','admin','user','ZendeskAccount','salesforceaccounts'];(function(_0x3b16e1,_0x3bda3e){var _0x311d1b=function(_0x2a979b){while(--_0x2a979b){_0x3b16e1['push'](_0x3b16e1['shift']());}};_0x311d1b(++_0x3bda3e);}(_0x9a69,0x111));var _0x99a6=function(_0x42cae2,_0x284ef8){_0x42cae2=_0x42cae2-0x0;var _0x5f256f=_0x9a69[_0x42cae2];return _0x5f256f;};'use strict';var _=require(_0x99a6('0x0'));var attributes=require(_0x99a6('0x1'));var squel=require(_0x99a6('0x2'));module[_0x99a6('0x3')]=function(_0x21c139){var _0x288723=_0x21c139[_0x99a6('0x4')];function _0x2f4b01(_0x2b1b15,_0x19b8bf){return new Promise(function(_0x2cface,_0x2b8825){if(!_0x19b8bf)return _0x2cface(null);var _0x4970d4=_0x19b8bf[_0x99a6('0x5')]?{[_0x19b8bf[_0x99a6('0x5')][_0x99a6('0x6')]]:_0x19b8bf['filter']['value']}:undefined;return _0x288723[_0x2b1b15][_0x99a6('0x7')]({'where':_0x4970d4,'raw':!![]})[_0x99a6('0x8')](function(_0x3786b3){_0x19b8bf[_0x99a6('0x9')]=_[_0x99a6('0xa')](_0x3786b3,'id');_0x2cface(_0x19b8bf);})['catch'](function(_0x2059db){_0x2b8825(_0x2059db);});});}function _0xadd092(_0x4706f5,_0x48e3f5){return new Promise(function(_0x244a6e,_0x320824){var _0x59f8f1=_0x4706f5[_0x99a6('0x5')]?{[_0x4706f5['filter']['field']]:_0x4706f5[_0x99a6('0x5')][_0x99a6('0xb')]}:undefined;return _0x288723[_0x4706f5[_0x99a6('0xc')]]['findAll']({'where':_0x59f8f1,'raw':!![]})[_0x99a6('0x8')](function(_0x22b2fd){_0x48e3f5['associatedResources']=_[_0x99a6('0xa')](_0x22b2fd,function(_0x455c49){return _0x455c49[_0x99a6('0xd')];});_0x244a6e(_0x48e3f5);})[_0x99a6('0xe')](function(_0x5891a9){_0x320824(_0x5891a9);});});}function _0xbacd6b(_0x5a97f3,_0xab6ac8,_0x5346cd){if(!_0xab6ac8)return Promise[_0x99a6('0xf')](null);return new Promise(function(_0x5ae6ca,_0x3830a1){return _0x288723['UserProfileResource'][_0x99a6('0x7')]({'where':{'sectionId':_0xab6ac8['id']},'raw':!![]})['then'](function(_0x53a872){if(_0x5a97f3[_0x99a6('0x6')]&&_0x5a97f3[_0x99a6('0x6')]!=='id'){_0xab6ac8[_0x99a6('0x9')]=_[_0x99a6('0xa')](_0x53a872,function(_0x1573bb){return _0x1573bb[_0x5a97f3[_0x99a6('0x6')]];});}else{if(_0x5346cd===_0x99a6('0x10')){_0xab6ac8[_0x99a6('0x9')]=_[_0x99a6('0xa')](_0x53a872,function(_0x42aaec){return{'id':_0x42aaec['resourceId'],'type':_0x42aaec[_0x99a6('0x11')]};});}else{_0xab6ac8[_0x99a6('0x9')]=_[_0x99a6('0xa')](_0x53a872,function(_0x442310){return _0x442310[_0x99a6('0x12')];});}}_0x5ae6ca(_0xab6ac8);})[_0x99a6('0xe')](function(_0x134e5b){_0x3830a1(_0x134e5b);});});}function _0x2099d9(_0x3fd9ac,_0x475bc5){var _0x5c4981={'parentSections':[]};switch(_0x3fd9ac['toLowerCase']()){case _0x99a6('0x13'):_0x5c4981[_0x99a6('0x14')]='SquareProject';break;case _0x99a6('0x15'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x16');break;case _0x99a6('0x17'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x18');_0x5c4981['parentSections']=[{'name':_0x99a6('0x19'),'field':_0x99a6('0xd'),'foreignKey':_0x99a6('0x1a')}];break;case'projects':_0x5c4981['childModel']=_0x99a6('0x1b');break;case _0x99a6('0x1c'):_0x5c4981['childModel']='CmContact';_0x5c4981[_0x99a6('0x1d')]=[{'name':_0x99a6('0x1e'),'field':'id','foreignKey':_0x99a6('0x1f')}];break;case _0x99a6('0x20'):_0x5c4981['childModel']=_0x99a6('0x21');break;case _0x99a6('0x22'):_0x5c4981['childModel']=_0x99a6('0x23');break;case _0x99a6('0x24'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x25');break;case _0x99a6('0x26'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x27');break;case'chatwebsites':_0x5c4981[_0x99a6('0x14')]='ChatWebsite';break;case _0x99a6('0x28'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x29');break;case'faxaccounts':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x2a');break;case _0x99a6('0x2b'):case _0x99a6('0x2c'):case _0x99a6('0x2d'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x2e');break;case _0x99a6('0x2f'):_0x5c4981[_0x99a6('0x14')]='VoiceContext';break;case'voicemails':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x30');break;case _0x99a6('0x31'):_0x5c4981[_0x99a6('0x14')]='VoiceRecording';_0x5c4981[_0x99a6('0x1d')]=[{'name':_0x99a6('0x32'),'field':_0x99a6('0xd'),'foreignKey':_0x99a6('0x33'),'model':_0x99a6('0x34'),'filter':{'field':'role','value':[_0x99a6('0x35')]}},{'name':_0x99a6('0x36'),'field':'name','foreignKey':_0x99a6('0x33'),'model':'User','filter':{'field':_0x99a6('0x37'),'value':['telephone']}},{'name':_0x99a6('0x38'),'field':_0x99a6('0xd'),'foreignKey':_0x99a6('0x39'),'model':_0x99a6('0x3a'),'filter':{'field':_0x99a6('0x11'),'value':[_0x99a6('0x3b')]}},{'name':_0x99a6('0x3c'),'field':_0x99a6('0xd'),'foreignKey':_0x99a6('0x39'),'model':_0x99a6('0x3a'),'filter':{'field':_0x99a6('0x11'),'value':['outbound']}}];break;case _0x99a6('0x3d'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x3e');break;case _0x99a6('0x3f'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x40');break;case'voiceprefixes':_0x5c4981['childModel']=_0x99a6('0x41');break;case _0x99a6('0x42'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x43');break;case _0x99a6('0x44'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x45');break;case'mailaccounts':_0x5c4981[_0x99a6('0x14')]='MailAccount';break;case _0x99a6('0x46'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x47');break;case _0x99a6('0x48'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x49');break;case'openchannelaccounts':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x4a');break;case _0x99a6('0x4b'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x4c');break;case _0x99a6('0x4d'):_0x5c4981[_0x99a6('0x14')]='SmsAccount';break;case _0x99a6('0x4e'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x4f');break;case'whatsappaccounts':_0x5c4981['childModel']=_0x99a6('0x50');break;case'teams':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x51');break;case _0x99a6('0x52'):case _0x99a6('0x53'):_0x5c4981['childModel']=_0x99a6('0x3a');if(_0x475bc5){_0x5c4981['parentSections']=[{'name':_0x99a6('0x38')},{'name':'QueueCampaigns'}];}break;case _0x99a6('0x54'):case'agents':case _0x99a6('0x55'):_0x5c4981[_0x99a6('0x14')]='User';if(_0x475bc5){_0x5c4981[_0x99a6('0x1d')]=[{'name':_0x99a6('0x56'),'filter':{'field':_0x99a6('0x37'),'value':[_0x99a6('0x57'),_0x99a6('0x58')]},'ignore':!![]},{'name':_0x99a6('0x32')},{'name':_0x99a6('0x36')}];}break;case'zendeskaccounts':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x59');break;case _0x99a6('0x5a'):_0x5c4981[_0x99a6('0x14')]='SalesforceAccount';break;case _0x99a6('0x5b'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x5c');break;case _0x99a6('0x5d'):_0x5c4981[_0x99a6('0x14')]='SugarcrmAccount';break;case'deskaccounts':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x5e');break;case'zohoaccounts':_0x5c4981[_0x99a6('0x14')]='ZohoAccount';break;case _0x99a6('0x5f'):_0x5c4981['childModel']=_0x99a6('0x34');break;case _0x99a6('0x60'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x61');break;case'dispositions':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x62');break;case _0x99a6('0x63'):_0x5c4981[_0x99a6('0x14')]='Dashboard';break;case'intervals':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x64');break;case _0x99a6('0x65'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x66');break;case _0x99a6('0x67'):_0x5c4981[_0x99a6('0x14')]='Schedule';break;case _0x99a6('0x68'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x69');break;case _0x99a6('0x6a'):_0x5c4981[_0x99a6('0x14')]='Tag';break;case'templates':_0x5c4981['childModel']=_0x99a6('0x6b');break;case'triggers':_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x6c');break;case _0x99a6('0x6d'):_0x5c4981[_0x99a6('0x14')]='Trunk';break;case'variables':_0x5c4981['childModel']=_0x99a6('0x6e');break;case _0x99a6('0x6f'):_0x5c4981['childModel']=_0x99a6('0x70');break;case _0x99a6('0x71'):_0x5c4981[_0x99a6('0x14')]=_0x99a6('0x10');_0x5c4981['parentSections']=[{'name':'Reports','field':'id','foreignKey':_0x99a6('0x72')}];break;case _0x99a6('0x73'):_0x5c4981[_0x99a6('0x14')]='AnalyticMetric';break;}return _0x5c4981;}function _0x2ff33c(_0x8d93ec,_0x1f5d63){var _0x2ea714=_0x8d93ec[_0x99a6('0x74')](0x0)[_0x99a6('0x75')]()+_0x8d93ec['slice'](0x1);var _0x4da818={'type':_0x288723['Sequelize']['QueryTypes'][_0x99a6('0x76')],'raw':!![]};return new Promise(function(_0x5744bf,_0x4ddc58){var _0x1f1901=squel[_0x99a6('0x77')]()[_0x99a6('0x6')](_0x99a6('0x78')+_0x2ea714+'InteractionId','id')[_0x99a6('0x6')](_0x99a6('0x79'))[_0x99a6('0x7a')](_0x99a6('0x7b')+_0x8d93ec+_0x99a6('0x7c'),'ui')[_0x99a6('0x7d')]('ui.UserId\x20=\x20?',_0x1f5d63['id']);return _0x288723[_0x99a6('0x7e')][_0x99a6('0x7f')](_0x1f1901[_0x99a6('0x80')](),_0x4da818)[_0x99a6('0x8')](function(_0x286152){_0x1f5d63[_0x2ea714+_0x99a6('0x81')]=_0x286152;_0x5744bf(_0x286152);})[_0x99a6('0xe')](function(_0x2ff1b4){_0x4ddc58(_0x2ff1b4);});});}return _0x21c139['define']('UserProfile',attributes,{'tableName':_0x99a6('0x82'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x2c83b1){var _0x36073c=require(_0x99a6('0x83'));var _0x35ef87={'raw':_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0x84')],'where':{}};var _0xd20b2f={};var _0x599138={'count':0x0,'rows':[]};var _0x17e994=_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0x85')];var _0x2b07ae=_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0x86')]||![];var _0x2971dd=_0x2099d9(_0x17e994,_0x2b07ae);if(!_0x2971dd[_0x99a6('0x14')])throw new Error(_0x99a6('0x87')+_0x17e994+'\x27');var _0x5bc97d=[{'name':_0x17e994}];if(!_[_0x99a6('0x88')](_0x2971dd[_0x99a6('0x1d')]))_0x5bc97d=_0x2971dd[_0x99a6('0x1d')];var _0x11323e=[];for(var _0x3dddbd=0x0;_0x3dddbd<_0x5bc97d['length'];_0x3dddbd++){_0x11323e[_0x99a6('0x89')](_0x288723[_0x99a6('0x8a')][_0x99a6('0x8b')]({'where':{'userProfileId':_0x2c83b1['params']['id'],'name':_0x5bc97d[_0x3dddbd][_0x99a6('0xd')]},'raw':!![]}));}return Promise[_0x99a6('0x8c')](_0x11323e)[_0x99a6('0x8')](function(_0x5e1372){var _0x988af4=_[_0x99a6('0x5')](_0x5e1372,function(_0x29952e){return _0x29952e?_0x29952e:undefined;});var _0x569cab=_['filter'](_0x5bc97d,['ignore',!![]]);var _0x1fa9c6=_[_0x99a6('0x88')](_0x988af4)&&_[_0x99a6('0x88')](_0x569cab)?null:_[_0x99a6('0x8d')](_0x569cab,_0x988af4);if(!_0x1fa9c6)return null;var _0x24e033=[];for(var _0x10314b=0x0;_0x10314b<_0x1fa9c6[_0x99a6('0x8e')];_0x10314b++){var _0x5e854c=_['find'](_0x5bc97d,function(_0x3eb7f2){return _0x1fa9c6[_0x10314b]?_0x3eb7f2[_0x99a6('0xd')]===_0x1fa9c6[_0x10314b]['name']:null;});if(_0x5e854c){if(_0x1fa9c6[_0x10314b][_0x99a6('0x8f')]){_0x24e033[_0x99a6('0x89')](_0x2f4b01(_0x2971dd[_0x99a6('0x14')],_0x1fa9c6[_0x10314b]));}else{if(!_0x1fa9c6[_0x10314b][_0x99a6('0x90')]){_0x24e033[_0x99a6('0x89')](_0xbacd6b(_0x5e854c,_0x1fa9c6[_0x10314b],_0x2971dd[_0x99a6('0x14')]));}else{if(_0x5e854c['model']){_0x24e033[_0x99a6('0x89')](_0xadd092(_0x5e854c,_0x1fa9c6[_0x10314b]));}}}}}return Promise[_0x99a6('0x8c')](_0x24e033);})[_0x99a6('0x8')](function(_0xad40fc){var _0x410ba1=_0xad40fc;var _0x236033=null;if(_0x410ba1){_0x236033=_0x410ba1[_0x99a6('0x8e')]===0x1?_0x410ba1[0x0]:null;}if(!_0x236033&&!_0x410ba1)return _0x599138;var _0x4b8240=_0x288723[_0x2971dd[_0x99a6('0x14')]][_0x99a6('0x91')];_0xd20b2f[_0x99a6('0xc')]=_['keys'](_0x4b8240);_0xd20b2f[_0x99a6('0x7f')]=_[_0x99a6('0x92')](_0x2c83b1['query']);_0xd20b2f['filters']=_[_0x99a6('0x93')](_0xd20b2f['model'],_0xd20b2f['query']);_0x35ef87[_0x99a6('0x94')]=_[_0x99a6('0x93')](_0xd20b2f[_0x99a6('0xc')],_0x36073c[_0x99a6('0x95')](_0x2c83b1['query'][_0x99a6('0x95')]));_0x35ef87[_0x99a6('0x94')]=_0x35ef87[_0x99a6('0x94')][_0x99a6('0x8e')]?_0x35ef87['attributes']:_0xd20b2f[_0x99a6('0xc')];if(!_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0x96')](_0x99a6('0x97'))){_0x35ef87[_0x99a6('0x98')]=_0x36073c[_0x99a6('0x98')](_0x2c83b1['query'][_0x99a6('0x98')]);_0x35ef87[_0x99a6('0x99')]=_0x36073c[_0x99a6('0x99')](_0x2c83b1['query'][_0x99a6('0x99')]);}_0x35ef87[_0x99a6('0x9a')]=_0x36073c['sort'](_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0x9b')]);_0x35ef87[_0x99a6('0x7d')]=_0x36073c[_0x99a6('0x9c')](_[_0x99a6('0x9d')](_0x2c83b1[_0x99a6('0x7f')],_0xd20b2f[_0x99a6('0x9c')]));if(_0x2c83b1[_0x99a6('0x7f')]['filter']){_0x35ef87['where']=_['merge'](_0x35ef87[_0x99a6('0x7d')],{'$or':_[_0x99a6('0xa')](_0x4b8240,function(_0x14cece){if(_0x14cece[_0x99a6('0x11')][_0x99a6('0x9e')]!==_0x99a6('0x9f')){var _0x1f7202={};_0x1f7202[_0x14cece[_0x99a6('0x6')]]={'$like':'%'+_0x2c83b1['query'][_0x99a6('0x5')]+'%'};return _0x1f7202;}})});}var _0x483cf4=[];var _0x152b92=null;var _0xc68068={};if(_0x236033){_0x152b92=_[_0x99a6('0x8b')](_0x5bc97d,[_0x99a6('0xd'),_0x236033['name']]);if(_0x152b92[_0x99a6('0x6')]){_0xc68068={};if(_0x2971dd['childModel']==='AnalyticExtractedReport'){_0xc68068[_0x152b92[_0x99a6('0xa0')]]=_[_0x99a6('0xa')](_0x236033[_0x99a6('0x9')],'id');}else{_0xc68068[_0x152b92['foreignKey']]=_0x236033['associatedResources'];}_0x483cf4[_0x99a6('0x89')](_0xc68068);}else{_0x35ef87[_0x99a6('0x7d')]['id']=_0x236033[_0x99a6('0x9')];}}else{for(var _0x1b57b4=0x0;_0x1b57b4<_0x410ba1[_0x99a6('0x8e')];_0x1b57b4++){_0x152b92=_[_0x99a6('0x8b')](_0x5bc97d,['name',_0x410ba1[_0x1b57b4][_0x99a6('0xd')]]);if(_0x152b92[_0x99a6('0x6')]){_0xc68068={};_0xc68068[_0x152b92['foreignKey']]=_0x410ba1[_0x1b57b4][_0x99a6('0x9')];_0x483cf4['push'](_0xc68068);}else{if(!_0x35ef87['where']['id'])_0x35ef87['where']['id']=[];_0x410ba1[_0x1b57b4][_0x99a6('0x9')][_0x99a6('0xa1')](function(_0x35547a){_0x35ef87[_0x99a6('0x7d')]['id'][_0x99a6('0x89')](_0x35547a);});}}}if(!_[_0x99a6('0x88')](_0x483cf4)){_0x35ef87[_0x99a6('0x7d')]=_['merge'](_0x35ef87['where'],{'$and':{'$or':_0x483cf4}});}_0x35ef87=_[_0x99a6('0xa2')]({},_0x35ef87,_0x2c83b1[_0x99a6('0xa3')]);if(_0x236033&&!_0x236033[_0x99a6('0x90')]&&_0x2971dd[_0x99a6('0x14')]===_0x99a6('0x10')){if(_0x2c83b1[_0x99a6('0x7f')]['includeAll']){_0x35ef87[_0x99a6('0xa4')]=[{'all':!![]}];}return _0x288723[_0x2971dd['childModel']][_0x99a6('0x7')](_0x35ef87)[_0x99a6('0x8')](function(_0x54782a){var _0x54ecc7=[];_0x54782a[_0x99a6('0xa1')](function(_0x3549b0){var _0x3e4bd9;switch(_0x3549b0['reportType']){case'default':_0x3e4bd9=_[_0x99a6('0x8b')](_0x236033[_0x99a6('0x9')],function(_0x28acda){return _0x28acda['id']===_0x3549b0[_0x99a6('0x72')]&&_0x28acda[_0x99a6('0x11')]===_0x99a6('0xa5');});break;case _0x99a6('0xa6'):_0x3e4bd9=_[_0x99a6('0x8b')](_0x236033[_0x99a6('0x9')],function(_0x854083){return _0x854083['id']===_0x3549b0[_0x99a6('0x72')]&&_0x854083[_0x99a6('0x11')]===_0x99a6('0xa7');});break;}if(_0x3e4bd9)_0x54ecc7[_0x99a6('0x89')](_0x3549b0);});_0x599138[_0x99a6('0xa8')]=_0x54ecc7['length'];_0x599138['rows']=_0x54ecc7;return _0x599138;});}else{if(!_[_0x99a6('0x88')](_0x2c83b1['query'][_0x99a6('0xa9')])){_0x35ef87[_0x99a6('0x7d')]['id']=_0x35ef87[_0x99a6('0x7d')]['id']?_[_0x99a6('0x93')](_0x35ef87[_0x99a6('0x7d')]['id'],_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xa9')]):_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xa9')];if(_0x2c83b1['query']['customSorting']){_0x35ef87[_0x99a6('0x9a')]=_0x2c83b1[_0x99a6('0x7f')]['customSorting'];}}if(_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xaa')]){_0x35ef87[_0x99a6('0x7d')]=_[_0x99a6('0xa2')](_0x35ef87['where'],{'$and':_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xaa')]});}return _0x288723[_0x2971dd['childModel']][_0x99a6('0xa8')]({'where':_0x35ef87[_0x99a6('0x7d')]})[_0x99a6('0x8')](function(_0x4503d2){_0x599138[_0x99a6('0xa8')]=_0x4503d2;if(_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xab')]){if(_0x2971dd['childModel']==='CmContact'){_0x35ef87[_0x99a6('0xa4')]=[{'model':_0x288723[_0x99a6('0xac')],'as':'Tags','attributes':['id',_0x99a6('0xd'),_0x99a6('0xad')],'required':_0x2c83b1[_0x99a6('0x7f')]['tag']?!![]:![]},{'model':_0x288723[_0x99a6('0xac')],'as':_0x99a6('0xae'),'attributes':['id','name',_0x99a6('0xad')],'through':_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xaf')]?{'attributes':[],'where':{'TagId':_0x2c83b1[_0x99a6('0x7f')]['tag']||undefined}}:{},'required':_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xaf')]?!![]:![]}];}else{_0x35ef87[_0x99a6('0xa4')]=[{'all':!![]}];}}return _0x288723[_0x2971dd[_0x99a6('0x14')]]['findAll'](_0x35ef87);})[_0x99a6('0x8')](function(_0x2c8b1c){_0x599138[_0x99a6('0xb0')]=_0x2c8b1c;if(_0x17e994===_0x99a6('0x32')&&_0x2c83b1[_0x99a6('0x7f')][_0x99a6('0xb1')]==='true'){var _0x34c7e5=[];for(var _0x4da012=0x0;_0x4da012<_0x599138[_0x99a6('0xb0')][_0x99a6('0x8e')];_0x4da012++){_0x34c7e5['push'](_0x2ff33c('chat',_0x599138[_0x99a6('0xb0')][_0x4da012][_0x99a6('0xb2')]));_0x34c7e5[_0x99a6('0x89')](_0x2ff33c(_0x99a6('0xb3'),_0x599138[_0x99a6('0xb0')][_0x4da012]['dataValues']));_0x34c7e5['push'](_0x2ff33c('fax',_0x599138[_0x99a6('0xb0')][_0x4da012][_0x99a6('0xb2')]));_0x34c7e5[_0x99a6('0x89')](_0x2ff33c('mail',_0x599138[_0x99a6('0xb0')][_0x4da012][_0x99a6('0xb2')]));_0x34c7e5[_0x99a6('0x89')](_0x2ff33c(_0x99a6('0xb4'),_0x599138['rows'][_0x4da012][_0x99a6('0xb2')]));_0x34c7e5[_0x99a6('0x89')](_0x2ff33c(_0x99a6('0xb5'),_0x599138[_0x99a6('0xb0')][_0x4da012][_0x99a6('0xb2')]));}return Promise['all'](_0x34c7e5)[_0x99a6('0x8')](function(){return _0x599138;});}return _0x599138;});}});}}});};