4daf61ab91c7397a108ba518b9cdb971426a190b
[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 _0x8a0d=['OpenTabs','define','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','find','params','all','ignore','union','length','autoAssociation','rawAttributes','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','offset','sort','pick','merge','key','foreignKey','options','includeAll','include','forEach','default','DefaultReports','custom','count','rows','Tags','color','ThroughTags','tag','openTabs','true','chat','dataValues','sms','fax','mail','./userProfile.attributes','squel','exports','models','filter','value','findAll','associatedResources','map','catch','field','model','then','name','resolve','UserProfileResource','AnalyticExtractedReport','type','resourceId','SquareProject','odbc','childModel','squarerecordings','SquareRecording','parentSections','SquareProjects','projectName','projects','JscriptyProject','contacts','CmContact','Lists','ListId','lists','CmList','CmCompany','globalcustomfields','chatqueues','chatwebsites','ChatWebsite','faxqueues','FaxQueue','FaxAccount','inboundroutes','internalroutes','VoiceExtension','voicemails','voicerecordings','Agents','membername','User','role','agent','Telephones','telephone','VoiceQueues','queue','inbound','QueueCampaigns','VoiceQueue','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappaccounts','WhatsappAccount','voicequeues','queuecampaigns','users','telephones','Users','admin','user','zendeskaccounts','ZendeskAccount','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','SugarcrmAccount','deskaccounts','zohoaccounts','vtigeraccounts','cannedanswers','customdashboards','intervals','pauses','Pause','scheduler','Schedule','sounds','Sound','Tag','triggers','Trigger','trunks','variables','Variable','plugins','Reports','reportId','metrics','charAt','toUpperCase','slice','Sequelize','InteractionId','ui.createdAt','user_has_','_interactions','where','sequelize','query','toString'];(function(_0x311766,_0x208790){var _0x2c0199=function(_0x156bc8){while(--_0x156bc8){_0x311766['push'](_0x311766['shift']());}};_0x2c0199(++_0x208790);}(_0x8a0d,0xe8));var _0xd8a0=function(_0x4be09b,_0x13ad61){_0x4be09b=_0x4be09b-0x0;var _0x3fbcaf=_0x8a0d[_0x4be09b];return _0x3fbcaf;};'use strict';var _=require('lodash');var attributes=require(_0xd8a0('0x0'));var qs=require('../../components/parsers/qs');var squel=require(_0xd8a0('0x1'));module[_0xd8a0('0x2')]=function(_0x1f49aa){var _0x38d2d1=_0x1f49aa[_0xd8a0('0x3')];function _0x4a6324(_0x93910b,_0x41da72){return new Promise(function(_0x32deb6,_0x45431c){if(!_0x41da72)return _0x32deb6(null);var _0x1e9974=_0x41da72['filter']?{[_0x41da72[_0xd8a0('0x4')]['field']]:_0x41da72[_0xd8a0('0x4')][_0xd8a0('0x5')]}:undefined;return _0x38d2d1[_0x93910b][_0xd8a0('0x6')]({'where':_0x1e9974,'raw':!![]})['then'](function(_0x73f343){_0x41da72[_0xd8a0('0x7')]=_[_0xd8a0('0x8')](_0x73f343,'id');_0x32deb6(_0x41da72);})[_0xd8a0('0x9')](function(_0xf1f07d){_0x45431c(_0xf1f07d);});});}function _0x2ce50e(_0x2679c7,_0x2eea02){return new Promise(function(_0x200668,_0x1f616f){var _0x5b5c32=_0x2679c7[_0xd8a0('0x4')]?{[_0x2679c7[_0xd8a0('0x4')][_0xd8a0('0xa')]]:_0x2679c7[_0xd8a0('0x4')][_0xd8a0('0x5')]}:undefined;return _0x38d2d1[_0x2679c7[_0xd8a0('0xb')]][_0xd8a0('0x6')]({'where':_0x5b5c32,'raw':!![]})[_0xd8a0('0xc')](function(_0x2e3062){_0x2eea02[_0xd8a0('0x7')]=_['map'](_0x2e3062,function(_0x4db7a6){return _0x4db7a6[_0xd8a0('0xd')];});_0x200668(_0x2eea02);})[_0xd8a0('0x9')](function(_0x2a5177){_0x1f616f(_0x2a5177);});});}function _0x26b89d(_0x30ca95,_0x44e429,_0x331508){if(!_0x44e429)return Promise[_0xd8a0('0xe')](null);return new Promise(function(_0x533d96,_0x2953af){return _0x38d2d1[_0xd8a0('0xf')][_0xd8a0('0x6')]({'where':{'sectionId':_0x44e429['id']},'raw':!![]})[_0xd8a0('0xc')](function(_0x560697){if(_0x30ca95[_0xd8a0('0xa')]&&_0x30ca95[_0xd8a0('0xa')]!=='id'){_0x44e429[_0xd8a0('0x7')]=_[_0xd8a0('0x8')](_0x560697,function(_0x4892d8){return _0x4892d8[_0x30ca95['field']];});}else{if(_0x331508===_0xd8a0('0x10')){_0x44e429['associatedResources']=_[_0xd8a0('0x8')](_0x560697,function(_0x345b98){return{'id':_0x345b98['resourceId'],'type':_0x345b98[_0xd8a0('0x11')]};});}else{_0x44e429[_0xd8a0('0x7')]=_[_0xd8a0('0x8')](_0x560697,function(_0x3b9691){return _0x3b9691[_0xd8a0('0x12')];});}}_0x533d96(_0x44e429);})[_0xd8a0('0x9')](function(_0x490815){_0x2953af(_0x490815);});});}function _0x265273(_0x5b6c90,_0x4a335d){var _0x4f978e={'parentSections':[]};switch(_0x5b6c90['toLowerCase']()){case'squareprojects':_0x4f978e['childModel']=_0xd8a0('0x13');break;case _0xd8a0('0x14'):_0x4f978e[_0xd8a0('0x15')]='SquareOdbc';break;case _0xd8a0('0x16'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x17');_0x4f978e[_0xd8a0('0x18')]=[{'name':_0xd8a0('0x19'),'field':'name','foreignKey':_0xd8a0('0x1a')}];break;case _0xd8a0('0x1b'):_0x4f978e['childModel']=_0xd8a0('0x1c');break;case _0xd8a0('0x1d'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x1e');_0x4f978e[_0xd8a0('0x18')]=[{'name':_0xd8a0('0x1f'),'field':'id','foreignKey':_0xd8a0('0x20')}];break;case _0xd8a0('0x21'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x22');break;case'companies':_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x23');break;case _0xd8a0('0x24'):_0x4f978e[_0xd8a0('0x15')]='CmCustomField';break;case _0xd8a0('0x25'):_0x4f978e['childModel']='ChatQueue';break;case _0xd8a0('0x26'):_0x4f978e['childModel']=_0xd8a0('0x27');break;case _0xd8a0('0x28'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x29');break;case'faxaccounts':_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x2a');break;case _0xd8a0('0x2b'):case _0xd8a0('0x2c'):case'outboundroutes':_0x4f978e['childModel']=_0xd8a0('0x2d');break;case'contexts':_0x4f978e[_0xd8a0('0x15')]='VoiceContext';break;case _0xd8a0('0x2e'):_0x4f978e['childModel']='VoiceMail';break;case _0xd8a0('0x2f'):_0x4f978e[_0xd8a0('0x15')]='VoiceRecording';_0x4f978e[_0xd8a0('0x18')]=[{'name':_0xd8a0('0x30'),'field':'name','foreignKey':_0xd8a0('0x31'),'model':_0xd8a0('0x32'),'filter':{'field':_0xd8a0('0x33'),'value':[_0xd8a0('0x34')]}},{'name':_0xd8a0('0x35'),'field':_0xd8a0('0xd'),'foreignKey':'membername','model':_0xd8a0('0x32'),'filter':{'field':_0xd8a0('0x33'),'value':[_0xd8a0('0x36')]}},{'name':_0xd8a0('0x37'),'field':'name','foreignKey':_0xd8a0('0x38'),'model':'VoiceQueue','filter':{'field':_0xd8a0('0x11'),'value':[_0xd8a0('0x39')]}},{'name':_0xd8a0('0x3a'),'field':'name','foreignKey':'queue','model':_0xd8a0('0x3b'),'filter':{'field':_0xd8a0('0x11'),'value':['outbound']}}];break;case'musiconholds':_0x4f978e[_0xd8a0('0x15')]='VoiceMusicOnHold';break;case _0xd8a0('0x3c'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x3d');break;case _0xd8a0('0x3e'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x3f');break;case _0xd8a0('0x40'):_0x4f978e['childModel']='Campaign';break;case _0xd8a0('0x41'):_0x4f978e['childModel']=_0xd8a0('0x42');break;case _0xd8a0('0x43'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x44');break;case _0xd8a0('0x45'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x46');break;case _0xd8a0('0x47'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x48');break;case _0xd8a0('0x49'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x4a');break;case _0xd8a0('0x4b'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x4c');break;case _0xd8a0('0x4d'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x4e');break;case'whatsappqueues':_0x4f978e[_0xd8a0('0x15')]='WhatsappQueue';break;case _0xd8a0('0x4f'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x50');break;case'teams':_0x4f978e[_0xd8a0('0x15')]='Team';break;case _0xd8a0('0x51'):case _0xd8a0('0x52'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x3b');if(_0x4a335d){_0x4f978e[_0xd8a0('0x18')]=[{'name':'VoiceQueues'},{'name':_0xd8a0('0x3a')}];}break;case _0xd8a0('0x53'):case'agents':case _0xd8a0('0x54'):_0x4f978e['childModel']=_0xd8a0('0x32');if(_0x4a335d){_0x4f978e['parentSections']=[{'name':_0xd8a0('0x55'),'filter':{'field':_0xd8a0('0x33'),'value':[_0xd8a0('0x56'),_0xd8a0('0x57')]},'ignore':!![]},{'name':_0xd8a0('0x30')},{'name':_0xd8a0('0x35')}];}break;case _0xd8a0('0x58'):_0x4f978e['childModel']=_0xd8a0('0x59');break;case'salesforceaccounts':_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x5a');break;case _0xd8a0('0x5b'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x5c');break;case'sugarcrmaccounts':_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x5d');break;case _0xd8a0('0x5e'):_0x4f978e[_0xd8a0('0x15')]='DeskAccount';break;case _0xd8a0('0x5f'):_0x4f978e[_0xd8a0('0x15')]='ZohoAccount';break;case _0xd8a0('0x60'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x32');break;case _0xd8a0('0x61'):_0x4f978e[_0xd8a0('0x15')]='CannedAnswer';break;case'dispositions':_0x4f978e[_0xd8a0('0x15')]='Disposition';break;case _0xd8a0('0x62'):_0x4f978e[_0xd8a0('0x15')]='Dashboard';break;case _0xd8a0('0x63'):_0x4f978e[_0xd8a0('0x15')]='Interval';break;case _0xd8a0('0x64'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x65');break;case _0xd8a0('0x66'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x67');break;case _0xd8a0('0x68'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x69');break;case'tags':_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x6a');break;case'templates':_0x4f978e[_0xd8a0('0x15')]='Template';break;case _0xd8a0('0x6b'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x6c');break;case _0xd8a0('0x6d'):_0x4f978e[_0xd8a0('0x15')]='Trunk';break;case _0xd8a0('0x6e'):_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x6f');break;case _0xd8a0('0x70'):_0x4f978e['childModel']='Plugin';break;case'extractedreports':_0x4f978e[_0xd8a0('0x15')]=_0xd8a0('0x10');_0x4f978e[_0xd8a0('0x18')]=[{'name':_0xd8a0('0x71'),'field':'id','foreignKey':_0xd8a0('0x72')}];break;case _0xd8a0('0x73'):_0x4f978e['childModel']='AnalyticMetric';break;}return _0x4f978e;}function _0x354ebd(_0x1ee2a5,_0x5cfd40){var _0x5727f8=_0x1ee2a5[_0xd8a0('0x74')](0x0)[_0xd8a0('0x75')]()+_0x1ee2a5[_0xd8a0('0x76')](0x1);var _0x564f73={'type':_0x38d2d1[_0xd8a0('0x77')]['QueryTypes']['SELECT'],'raw':!![]};return new Promise(function(_0x266c26,_0x204da3){var _0x515986=squel['select']()['field']('ui.'+_0x5727f8+_0xd8a0('0x78'),'id')[_0xd8a0('0xa')](_0xd8a0('0x79'))['from'](_0xd8a0('0x7a')+_0x1ee2a5+_0xd8a0('0x7b'),'ui')[_0xd8a0('0x7c')]('ui.UserId\x20=\x20?',_0x5cfd40['id']);return _0x38d2d1[_0xd8a0('0x7d')][_0xd8a0('0x7e')](_0x515986[_0xd8a0('0x7f')](),_0x564f73)[_0xd8a0('0xc')](function(_0x4244db){_0x5cfd40[_0x5727f8+_0xd8a0('0x80')]=_0x4244db;_0x266c26(_0x4244db);})[_0xd8a0('0x9')](function(_0x5bae8e){_0x204da3(_0x5bae8e);});});}return _0x1f49aa[_0xd8a0('0x81')]('UserProfile',attributes,{'tableName':_0xd8a0('0x82'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x3a6be9){var _0x3b830e={'raw':_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0x83')],'where':{}};var _0x1c96fb={};var _0x52e66f={'count':0x0,'rows':[]};var _0x282c06=_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0x84')];var _0x47bd8a=_0x3a6be9['query'][_0xd8a0('0x85')]||![];var _0x5a9dac=_0x265273(_0x282c06,_0x47bd8a);if(!_0x5a9dac[_0xd8a0('0x15')])throw new Error(_0xd8a0('0x86')+_0x282c06+'\x27');var _0x3b325f=[{'name':_0x282c06}];if(!_[_0xd8a0('0x87')](_0x5a9dac[_0xd8a0('0x18')]))_0x3b325f=_0x5a9dac['parentSections'];var _0x19e319=[];for(var _0x2f7ed9=0x0;_0x2f7ed9<_0x3b325f['length'];_0x2f7ed9++){_0x19e319[_0xd8a0('0x88')](_0x38d2d1[_0xd8a0('0x89')][_0xd8a0('0x8a')]({'where':{'userProfileId':_0x3a6be9[_0xd8a0('0x8b')]['id'],'name':_0x3b325f[_0x2f7ed9][_0xd8a0('0xd')]},'raw':!![]}));}return Promise[_0xd8a0('0x8c')](_0x19e319)['then'](function(_0x242390){var _0x2c3037=_[_0xd8a0('0x4')](_0x242390,function(_0x2d0b91){return _0x2d0b91?_0x2d0b91:undefined;});var _0x798a52=_[_0xd8a0('0x4')](_0x3b325f,[_0xd8a0('0x8d'),!![]]);var _0x433ac2=_['isEmpty'](_0x2c3037)&&_[_0xd8a0('0x87')](_0x798a52)?null:_[_0xd8a0('0x8e')](_0x798a52,_0x2c3037);if(!_0x433ac2)return null;var _0x3960dc=[];for(var _0x5e4d65=0x0;_0x5e4d65<_0x433ac2[_0xd8a0('0x8f')];_0x5e4d65++){var _0x2ac1f5=_[_0xd8a0('0x8a')](_0x3b325f,function(_0x1b4264){return _0x433ac2[_0x5e4d65]?_0x1b4264['name']===_0x433ac2[_0x5e4d65][_0xd8a0('0xd')]:null;});if(_0x2ac1f5){if(_0x433ac2[_0x5e4d65][_0xd8a0('0x8d')]){_0x3960dc[_0xd8a0('0x88')](_0x4a6324(_0x5a9dac['childModel'],_0x433ac2[_0x5e4d65]));}else{if(!_0x433ac2[_0x5e4d65][_0xd8a0('0x90')]){_0x3960dc[_0xd8a0('0x88')](_0x26b89d(_0x2ac1f5,_0x433ac2[_0x5e4d65],_0x5a9dac['childModel']));}else{if(_0x2ac1f5[_0xd8a0('0xb')]){_0x3960dc[_0xd8a0('0x88')](_0x2ce50e(_0x2ac1f5,_0x433ac2[_0x5e4d65]));}}}}}return Promise[_0xd8a0('0x8c')](_0x3960dc);})[_0xd8a0('0xc')](function(_0x3b8b00){var _0x32bd99=_0x3b8b00;var _0x12942d=null;if(_0x32bd99){_0x12942d=_0x32bd99[_0xd8a0('0x8f')]===0x1?_0x32bd99[0x0]:null;}if(!_0x12942d&&!_0x32bd99)return _0x52e66f;var _0x555708=_0x38d2d1[_0x5a9dac['childModel']][_0xd8a0('0x91')];_0x1c96fb[_0xd8a0('0xb')]=_[_0xd8a0('0x92')](_0x555708);_0x1c96fb[_0xd8a0('0x7e')]=_['keys'](_0x3a6be9[_0xd8a0('0x7e')]);_0x1c96fb[_0xd8a0('0x93')]=_['intersection'](_0x1c96fb['model'],_0x1c96fb[_0xd8a0('0x7e')]);_0x3b830e[_0xd8a0('0x94')]=_[_0xd8a0('0x95')](_0x1c96fb[_0xd8a0('0xb')],qs['fields'](_0x3a6be9['query'][_0xd8a0('0x96')]));_0x3b830e[_0xd8a0('0x94')]=_0x3b830e[_0xd8a0('0x94')][_0xd8a0('0x8f')]?_0x3b830e[_0xd8a0('0x94')]:_0x1c96fb['model'];if(!_0x3a6be9['query'][_0xd8a0('0x97')](_0xd8a0('0x98'))){_0x3b830e[_0xd8a0('0x99')]=qs['limit'](_0x3a6be9[_0xd8a0('0x7e')]['limit']);_0x3b830e[_0xd8a0('0x9a')]=qs['offset'](_0x3a6be9['query'][_0xd8a0('0x9a')]);}_0x3b830e['order']=qs[_0xd8a0('0x9b')](_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0x9b')]);_0x3b830e[_0xd8a0('0x7c')]=qs[_0xd8a0('0x93')](_[_0xd8a0('0x9c')](_0x3a6be9['query'],_0x1c96fb[_0xd8a0('0x93')]));if(_0x3a6be9['query'][_0xd8a0('0x4')]){_0x3b830e[_0xd8a0('0x7c')]=_[_0xd8a0('0x9d')](_0x3b830e['where'],{'$or':_['map'](_0x555708,function(_0x44fc0f){if(_0x44fc0f[_0xd8a0('0x11')][_0xd8a0('0x9e')]!=='VIRTUAL'){var _0x347663={};_0x347663[_0x44fc0f[_0xd8a0('0xa')]]={'$like':'%'+_0x3a6be9[_0xd8a0('0x7e')]['filter']+'%'};return _0x347663;}})});}var _0x5db47d=[];var _0x4a6534=null;var _0x227721={};if(_0x12942d){_0x4a6534=_[_0xd8a0('0x8a')](_0x3b325f,[_0xd8a0('0xd'),_0x12942d[_0xd8a0('0xd')]]);if(_0x4a6534[_0xd8a0('0xa')]){_0x227721={};if(_0x5a9dac[_0xd8a0('0x15')]===_0xd8a0('0x10')){_0x227721[_0x4a6534['foreignKey']]=_[_0xd8a0('0x8')](_0x12942d[_0xd8a0('0x7')],'id');}else{_0x227721[_0x4a6534['foreignKey']]=_0x12942d[_0xd8a0('0x7')];}_0x5db47d[_0xd8a0('0x88')](_0x227721);}else{_0x3b830e[_0xd8a0('0x7c')]['id']=_0x12942d[_0xd8a0('0x7')];}}else{for(var _0x4cfa1c=0x0;_0x4cfa1c<_0x32bd99[_0xd8a0('0x8f')];_0x4cfa1c++){_0x4a6534=_[_0xd8a0('0x8a')](_0x3b325f,[_0xd8a0('0xd'),_0x32bd99[_0x4cfa1c][_0xd8a0('0xd')]]);if(_0x4a6534[_0xd8a0('0xa')]){_0x227721={};_0x227721[_0x4a6534[_0xd8a0('0x9f')]]=_0x32bd99[_0x4cfa1c]['associatedResources'];_0x5db47d['push'](_0x227721);}else{if(!_0x3b830e[_0xd8a0('0x7c')]['id'])_0x3b830e[_0xd8a0('0x7c')]['id']=[];_0x32bd99[_0x4cfa1c]['associatedResources']['forEach'](function(_0x2a1154){_0x3b830e[_0xd8a0('0x7c')]['id'][_0xd8a0('0x88')](_0x2a1154);});}}}if(!_[_0xd8a0('0x87')](_0x5db47d)){_0x3b830e[_0xd8a0('0x7c')]=_[_0xd8a0('0x9d')](_0x3b830e[_0xd8a0('0x7c')],{'$and':{'$or':_0x5db47d}});}_0x3b830e=_[_0xd8a0('0x9d')]({},_0x3b830e,_0x3a6be9[_0xd8a0('0xa0')]);if(_0x12942d&&!_0x12942d['autoAssociation']&&_0x5a9dac[_0xd8a0('0x15')]===_0xd8a0('0x10')){if(_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0xa1')]){_0x3b830e[_0xd8a0('0xa2')]=[{'all':!![]}];}return _0x38d2d1[_0x5a9dac['childModel']][_0xd8a0('0x6')](_0x3b830e)[_0xd8a0('0xc')](function(_0x5a5772){var _0xbe3d05=[];_0x5a5772[_0xd8a0('0xa3')](function(_0x3ac7f7){var _0x3bba48;switch(_0x3ac7f7['reportType']){case _0xd8a0('0xa4'):_0x3bba48=_[_0xd8a0('0x8a')](_0x12942d[_0xd8a0('0x7')],function(_0x11c416){return _0x11c416['id']===_0x3ac7f7[_0xd8a0('0x72')]&&_0x11c416[_0xd8a0('0x11')]===_0xd8a0('0xa5');});break;case _0xd8a0('0xa6'):_0x3bba48=_[_0xd8a0('0x8a')](_0x12942d[_0xd8a0('0x7')],function(_0x40b4fa){return _0x40b4fa['id']===_0x3ac7f7[_0xd8a0('0x72')]&&_0x40b4fa[_0xd8a0('0x11')]==='CustomReports';});break;}if(_0x3bba48)_0xbe3d05['push'](_0x3ac7f7);});_0x52e66f[_0xd8a0('0xa7')]=_0xbe3d05[_0xd8a0('0x8f')];_0x52e66f[_0xd8a0('0xa8')]=_0xbe3d05;return _0x52e66f;});}else{return _0x38d2d1[_0x5a9dac[_0xd8a0('0x15')]][_0xd8a0('0xa7')]({'where':_0x3b830e['where']})['then'](function(_0x52f601){_0x52e66f[_0xd8a0('0xa7')]=_0x52f601;if(_0x3a6be9['query'][_0xd8a0('0xa1')]){if(_0x5a9dac[_0xd8a0('0x15')]==='CmContact'){_0x3b830e['include']=[{'model':_0x38d2d1[_0xd8a0('0x6a')],'as':_0xd8a0('0xa9'),'attributes':['id','name',_0xd8a0('0xaa')],'required':_0x3a6be9['query']['tag']?!![]:![]},{'model':_0x38d2d1['Tag'],'as':_0xd8a0('0xab'),'attributes':['id',_0xd8a0('0xd'),_0xd8a0('0xaa')],'through':_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0xac')]?{'attributes':[],'where':{'TagId':_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0xac')]||undefined}}:{},'required':_0x3a6be9['query'][_0xd8a0('0xac')]?!![]:![]}];}else{_0x3b830e[_0xd8a0('0xa2')]=[{'all':!![]}];}}return _0x38d2d1[_0x5a9dac['childModel']][_0xd8a0('0x6')](_0x3b830e);})['then'](function(_0x5390fc){_0x52e66f['rows']=_0x5390fc;if(_0x282c06===_0xd8a0('0x30')&&_0x3a6be9[_0xd8a0('0x7e')][_0xd8a0('0xad')]===_0xd8a0('0xae')){var _0x56220f=[];for(var _0x20b270=0x0;_0x20b270<_0x52e66f[_0xd8a0('0xa8')][_0xd8a0('0x8f')];_0x20b270++){_0x56220f[_0xd8a0('0x88')](_0x354ebd(_0xd8a0('0xaf'),_0x52e66f[_0xd8a0('0xa8')][_0x20b270][_0xd8a0('0xb0')]));_0x56220f[_0xd8a0('0x88')](_0x354ebd(_0xd8a0('0xb1'),_0x52e66f['rows'][_0x20b270][_0xd8a0('0xb0')]));_0x56220f[_0xd8a0('0x88')](_0x354ebd(_0xd8a0('0xb2'),_0x52e66f[_0xd8a0('0xa8')][_0x20b270][_0xd8a0('0xb0')]));_0x56220f['push'](_0x354ebd(_0xd8a0('0xb3'),_0x52e66f['rows'][_0x20b270]['dataValues']));_0x56220f[_0xd8a0('0x88')](_0x354ebd('openchannel',_0x52e66f['rows'][_0x20b270][_0xd8a0('0xb0')]));_0x56220f[_0xd8a0('0x88')](_0x354ebd('whatsapp',_0x52e66f['rows'][_0x20b270][_0xd8a0('0xb0')]));}return Promise[_0xd8a0('0x8c')](_0x56220f)['then'](function(){return _0x52e66f;});}return _0x52e66f;});}});}}});};