Built motion from commit fe909640.|2.6.8
[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 _0xe283=['role','Telephones','telephone','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','outbound','musiconholds','chanspies','VoiceChanSpy','voiceprefixes','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','whatsappaccounts','WhatsappAccount','Team','voicequeues','queuecampaigns','users','telephones','Users','admin','ZendeskAccount','salesforceaccounts','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','scheduler','Schedule','sounds','Sound','Tag','templates','trunks','Variable','plugins','extractedreports','reportId','metrics','AnalyticMetric','charAt','slice','Sequelize','QueryTypes','SELECT','select','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions','where','sequelize','define','UserProfile','user_profiles','query','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','push','UserProfileSection','find','params','all','ignore','autoAssociation','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','offset','order','sort','merge','key','AnalyticExtractedReport','foreignKey','forEach','includeAll','reportType','CustomReports','count','ids','customSorting','extraQueryConditions','include','Tags','tag','ThroughTags','color','rows','openTabs','true','chat','dataValues','sms','openchannel','whatsapp','./userProfile.attributes','../../components/parsers/qs','models','filter','field','value','findAll','then','associatedResources','catch','model','map','name','resolve','UserProfileResource','resourceId','type','toLowerCase','childModel','SquareProject','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','JscriptyProject','contacts','companies','CmCompany','globalcustomfields','chatqueues','ChatQueue','ChatWebsite','faxqueues','faxaccounts','FaxAccount','inboundroutes','internalroutes','VoiceExtension','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','membername','User'];(function(_0x52be73,_0x1b4cbd){var _0x26f66a=function(_0x4d56e0){while(--_0x4d56e0){_0x52be73['push'](_0x52be73['shift']());}};_0x26f66a(++_0x1b4cbd);}(_0xe283,0x86));var _0x3e28=function(_0x4c70c4,_0x963969){_0x4c70c4=_0x4c70c4-0x0;var _0x437865=_0xe283[_0x4c70c4];return _0x437865;};'use strict';var _=require('lodash');var attributes=require(_0x3e28('0x0'));var qs=require(_0x3e28('0x1'));var squel=require('squel');module['exports']=function(_0x43cf15){var _0xd2cad7=_0x43cf15[_0x3e28('0x2')];function _0x254c04(_0x4a21ac,_0x30d1a3){return new Promise(function(_0x516434,_0x1e6455){if(!_0x30d1a3)return _0x516434(null);var _0x10c0c4=_0x30d1a3['filter']?{[_0x30d1a3[_0x3e28('0x3')][_0x3e28('0x4')]]:_0x30d1a3[_0x3e28('0x3')][_0x3e28('0x5')]}:undefined;return _0xd2cad7[_0x4a21ac][_0x3e28('0x6')]({'where':_0x10c0c4,'raw':!![]})[_0x3e28('0x7')](function(_0x1da348){_0x30d1a3[_0x3e28('0x8')]=_['map'](_0x1da348,'id');_0x516434(_0x30d1a3);})[_0x3e28('0x9')](function(_0x5c5f07){_0x1e6455(_0x5c5f07);});});}function _0x188a74(_0x1d57a5,_0x25b190){return new Promise(function(_0x2ebc8a,_0x397385){var _0x8fa4af=_0x1d57a5[_0x3e28('0x3')]?{[_0x1d57a5[_0x3e28('0x3')][_0x3e28('0x4')]]:_0x1d57a5['filter'][_0x3e28('0x5')]}:undefined;return _0xd2cad7[_0x1d57a5[_0x3e28('0xa')]][_0x3e28('0x6')]({'where':_0x8fa4af,'raw':!![]})[_0x3e28('0x7')](function(_0x669783){_0x25b190[_0x3e28('0x8')]=_[_0x3e28('0xb')](_0x669783,function(_0x1df065){return _0x1df065[_0x3e28('0xc')];});_0x2ebc8a(_0x25b190);})[_0x3e28('0x9')](function(_0x174c9c){_0x397385(_0x174c9c);});});}function _0x338732(_0x2b74bd,_0x246ad7,_0x192b29){if(!_0x246ad7)return Promise[_0x3e28('0xd')](null);return new Promise(function(_0x1c9122,_0x309038){return _0xd2cad7[_0x3e28('0xe')]['findAll']({'where':{'sectionId':_0x246ad7['id']},'raw':!![]})[_0x3e28('0x7')](function(_0x55ef5c){if(_0x2b74bd[_0x3e28('0x4')]&&_0x2b74bd[_0x3e28('0x4')]!=='id'){_0x246ad7[_0x3e28('0x8')]=_[_0x3e28('0xb')](_0x55ef5c,function(_0x1af15b){return _0x1af15b[_0x2b74bd[_0x3e28('0x4')]];});}else{if(_0x192b29==='AnalyticExtractedReport'){_0x246ad7['associatedResources']=_[_0x3e28('0xb')](_0x55ef5c,function(_0x395e5a){return{'id':_0x395e5a[_0x3e28('0xf')],'type':_0x395e5a[_0x3e28('0x10')]};});}else{_0x246ad7['associatedResources']=_['map'](_0x55ef5c,function(_0x4a2f0f){return _0x4a2f0f[_0x3e28('0xf')];});}}_0x1c9122(_0x246ad7);})['catch'](function(_0x12d27c){_0x309038(_0x12d27c);});});}function _0x2d8ede(_0x2c1be1,_0x5ceca4){var _0x6c00b7={'parentSections':[]};switch(_0x2c1be1[_0x3e28('0x11')]()){case'squareprojects':_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x13');break;case'odbc':_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x14');break;case _0x3e28('0x15'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x16');_0x6c00b7[_0x3e28('0x17')]=[{'name':_0x3e28('0x18'),'field':_0x3e28('0xc'),'foreignKey':'projectName'}];break;case'projects':_0x6c00b7['childModel']=_0x3e28('0x19');break;case _0x3e28('0x1a'):_0x6c00b7[_0x3e28('0x12')]='CmContact';_0x6c00b7[_0x3e28('0x17')]=[{'name':'Lists','field':'id','foreignKey':'ListId'}];break;case'lists':_0x6c00b7[_0x3e28('0x12')]='CmList';break;case _0x3e28('0x1b'):_0x6c00b7['childModel']=_0x3e28('0x1c');break;case _0x3e28('0x1d'):_0x6c00b7[_0x3e28('0x12')]='CmCustomField';break;case _0x3e28('0x1e'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x1f');break;case'chatwebsites':_0x6c00b7['childModel']=_0x3e28('0x20');break;case _0x3e28('0x21'):_0x6c00b7['childModel']='FaxQueue';break;case _0x3e28('0x22'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x23');break;case _0x3e28('0x24'):case _0x3e28('0x25'):case'outboundroutes':_0x6c00b7['childModel']=_0x3e28('0x26');break;case'contexts':_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x27');break;case _0x3e28('0x28'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x29');break;case _0x3e28('0x2a'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x2b');_0x6c00b7['parentSections']=[{'name':_0x3e28('0x2c'),'field':_0x3e28('0xc'),'foreignKey':_0x3e28('0x2d'),'model':_0x3e28('0x2e'),'filter':{'field':_0x3e28('0x2f'),'value':['agent']}},{'name':_0x3e28('0x30'),'field':_0x3e28('0xc'),'foreignKey':_0x3e28('0x2d'),'model':_0x3e28('0x2e'),'filter':{'field':'role','value':[_0x3e28('0x31')]}},{'name':_0x3e28('0x32'),'field':'name','foreignKey':_0x3e28('0x33'),'model':_0x3e28('0x34'),'filter':{'field':_0x3e28('0x10'),'value':[_0x3e28('0x35')]}},{'name':_0x3e28('0x36'),'field':'name','foreignKey':_0x3e28('0x33'),'model':_0x3e28('0x34'),'filter':{'field':_0x3e28('0x10'),'value':[_0x3e28('0x37')]}}];break;case _0x3e28('0x38'):_0x6c00b7[_0x3e28('0x12')]='VoiceMusicOnHold';break;case _0x3e28('0x39'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x3a');break;case _0x3e28('0x3b'):_0x6c00b7[_0x3e28('0x12')]='VoicePrefix';break;case'ivrcampaigns':_0x6c00b7['childModel']=_0x3e28('0x3c');break;case _0x3e28('0x3d'):_0x6c00b7['childModel']=_0x3e28('0x3e');break;case _0x3e28('0x3f'):_0x6c00b7['childModel']=_0x3e28('0x40');break;case _0x3e28('0x41'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x42');break;case _0x3e28('0x43'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x44');break;case _0x3e28('0x45'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x46');break;case _0x3e28('0x47'):_0x6c00b7['childModel']=_0x3e28('0x48');break;case _0x3e28('0x49'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x4a');break;case _0x3e28('0x4b'):_0x6c00b7[_0x3e28('0x12')]='WhatsappQueue';break;case _0x3e28('0x4c'):_0x6c00b7['childModel']=_0x3e28('0x4d');break;case'teams':_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x4e');break;case _0x3e28('0x4f'):case _0x3e28('0x50'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x34');if(_0x5ceca4){_0x6c00b7['parentSections']=[{'name':_0x3e28('0x32')},{'name':_0x3e28('0x36')}];}break;case _0x3e28('0x51'):case'agents':case _0x3e28('0x52'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x2e');if(_0x5ceca4){_0x6c00b7[_0x3e28('0x17')]=[{'name':_0x3e28('0x53'),'filter':{'field':_0x3e28('0x2f'),'value':[_0x3e28('0x54'),'user']},'ignore':!![]},{'name':_0x3e28('0x2c')},{'name':'Telephones'}];}break;case'zendeskaccounts':_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x55');break;case _0x3e28('0x56'):_0x6c00b7[_0x3e28('0x12')]='SalesforceAccount';break;case _0x3e28('0x57'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x58');break;case _0x3e28('0x59'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x5a');break;case _0x3e28('0x5b'):_0x6c00b7['childModel']=_0x3e28('0x5c');break;case'zohoaccounts':_0x6c00b7[_0x3e28('0x12')]='ZohoAccount';break;case _0x3e28('0x5d'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x2e');break;case _0x3e28('0x5e'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x5f');break;case _0x3e28('0x60'):_0x6c00b7['childModel']=_0x3e28('0x61');break;case _0x3e28('0x62'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x63');break;case _0x3e28('0x64'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x65');break;case'pauses':_0x6c00b7[_0x3e28('0x12')]='Pause';break;case _0x3e28('0x66'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x67');break;case _0x3e28('0x68'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x69');break;case'tags':_0x6c00b7['childModel']=_0x3e28('0x6a');break;case _0x3e28('0x6b'):_0x6c00b7[_0x3e28('0x12')]='Template';break;case'triggers':_0x6c00b7[_0x3e28('0x12')]='Trigger';break;case _0x3e28('0x6c'):_0x6c00b7['childModel']='Trunk';break;case'variables':_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x6d');break;case _0x3e28('0x6e'):_0x6c00b7[_0x3e28('0x12')]='Plugin';break;case _0x3e28('0x6f'):_0x6c00b7[_0x3e28('0x12')]='AnalyticExtractedReport';_0x6c00b7[_0x3e28('0x17')]=[{'name':'Reports','field':'id','foreignKey':_0x3e28('0x70')}];break;case _0x3e28('0x71'):_0x6c00b7[_0x3e28('0x12')]=_0x3e28('0x72');break;}return _0x6c00b7;}function _0x4c1786(_0x532adc,_0x44aaac){var _0x49a2d0=_0x532adc[_0x3e28('0x73')](0x0)['toUpperCase']()+_0x532adc[_0x3e28('0x74')](0x1);var _0x53375e={'type':_0xd2cad7[_0x3e28('0x75')][_0x3e28('0x76')][_0x3e28('0x77')],'raw':!![]};return new Promise(function(_0x164c5d,_0x37c242){var _0x45190f=squel[_0x3e28('0x78')]()[_0x3e28('0x4')](_0x3e28('0x79')+_0x49a2d0+_0x3e28('0x7a'),'id')[_0x3e28('0x4')](_0x3e28('0x7b'))[_0x3e28('0x7c')](_0x3e28('0x7d')+_0x532adc+_0x3e28('0x7e'),'ui')[_0x3e28('0x7f')]('ui.UserId\x20=\x20?',_0x44aaac['id']);return _0xd2cad7[_0x3e28('0x80')]['query'](_0x45190f['toString'](),_0x53375e)[_0x3e28('0x7')](function(_0x30ff29){_0x44aaac[_0x49a2d0+'OpenTabs']=_0x30ff29;_0x164c5d(_0x30ff29);})['catch'](function(_0x3f4eb0){_0x37c242(_0x3f4eb0);});});}return _0x43cf15[_0x3e28('0x81')](_0x3e28('0x82'),attributes,{'tableName':_0x3e28('0x83'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x321a2f){var _0x1058a7={'raw':_0x321a2f[_0x3e28('0x84')][_0x3e28('0x85')],'where':{}};var _0x2858a3={};var _0x15b042={'count':0x0,'rows':[]};var _0x4288ae=_0x321a2f['query'][_0x3e28('0x86')];var _0x4504f7=_0x321a2f[_0x3e28('0x84')][_0x3e28('0x87')]||![];var _0x10ee57=_0x2d8ede(_0x4288ae,_0x4504f7);if(!_0x10ee57['childModel'])throw new Error(_0x3e28('0x88')+_0x4288ae+'\x27');var _0x3c1048=[{'name':_0x4288ae}];if(!_[_0x3e28('0x89')](_0x10ee57[_0x3e28('0x17')]))_0x3c1048=_0x10ee57[_0x3e28('0x17')];var _0x486266=[];for(var _0x466a43=0x0;_0x466a43<_0x3c1048[_0x3e28('0x8a')];_0x466a43++){_0x486266[_0x3e28('0x8b')](_0xd2cad7[_0x3e28('0x8c')][_0x3e28('0x8d')]({'where':{'userProfileId':_0x321a2f[_0x3e28('0x8e')]['id'],'name':_0x3c1048[_0x466a43][_0x3e28('0xc')]},'raw':!![]}));}return Promise[_0x3e28('0x8f')](_0x486266)[_0x3e28('0x7')](function(_0x3dc539){var _0x6917f3=_[_0x3e28('0x3')](_0x3dc539,function(_0x23863c){return _0x23863c?_0x23863c:undefined;});var _0x4e4ded=_[_0x3e28('0x3')](_0x3c1048,[_0x3e28('0x90'),!![]]);var _0x3a7c8f=_[_0x3e28('0x89')](_0x6917f3)&&_['isEmpty'](_0x4e4ded)?null:_['union'](_0x4e4ded,_0x6917f3);if(!_0x3a7c8f)return null;var _0x3777b7=[];for(var _0x50e2d6=0x0;_0x50e2d6<_0x3a7c8f['length'];_0x50e2d6++){var _0x4fe525=_[_0x3e28('0x8d')](_0x3c1048,function(_0x3c1e1d){return _0x3a7c8f[_0x50e2d6]?_0x3c1e1d['name']===_0x3a7c8f[_0x50e2d6]['name']:null;});if(_0x4fe525){if(_0x3a7c8f[_0x50e2d6]['ignore']){_0x3777b7[_0x3e28('0x8b')](_0x254c04(_0x10ee57[_0x3e28('0x12')],_0x3a7c8f[_0x50e2d6]));}else{if(!_0x3a7c8f[_0x50e2d6][_0x3e28('0x91')]){_0x3777b7['push'](_0x338732(_0x4fe525,_0x3a7c8f[_0x50e2d6],_0x10ee57[_0x3e28('0x12')]));}else{if(_0x4fe525[_0x3e28('0xa')]){_0x3777b7[_0x3e28('0x8b')](_0x188a74(_0x4fe525,_0x3a7c8f[_0x50e2d6]));}}}}}return Promise[_0x3e28('0x8f')](_0x3777b7);})[_0x3e28('0x7')](function(_0x3f4219){var _0x2a45c7=_0x3f4219;var _0x13d1a9=null;if(_0x2a45c7){_0x13d1a9=_0x2a45c7[_0x3e28('0x8a')]===0x1?_0x2a45c7[0x0]:null;}if(!_0x13d1a9&&!_0x2a45c7)return _0x15b042;var _0x32bddb=_0xd2cad7[_0x10ee57['childModel']]['rawAttributes'];_0x2858a3['model']=_['keys'](_0x32bddb);_0x2858a3[_0x3e28('0x84')]=_['keys'](_0x321a2f[_0x3e28('0x84')]);_0x2858a3[_0x3e28('0x92')]=_[_0x3e28('0x93')](_0x2858a3[_0x3e28('0xa')],_0x2858a3['query']);_0x1058a7['attributes']=_[_0x3e28('0x93')](_0x2858a3['model'],qs[_0x3e28('0x94')](_0x321a2f[_0x3e28('0x84')][_0x3e28('0x94')]));_0x1058a7[_0x3e28('0x95')]=_0x1058a7[_0x3e28('0x95')][_0x3e28('0x8a')]?_0x1058a7[_0x3e28('0x95')]:_0x2858a3[_0x3e28('0xa')];if(!_0x321a2f[_0x3e28('0x84')][_0x3e28('0x96')](_0x3e28('0x97'))){_0x1058a7[_0x3e28('0x98')]=qs[_0x3e28('0x98')](_0x321a2f[_0x3e28('0x84')][_0x3e28('0x98')]);_0x1058a7['offset']=qs['offset'](_0x321a2f[_0x3e28('0x84')][_0x3e28('0x99')]);}_0x1058a7[_0x3e28('0x9a')]=qs[_0x3e28('0x9b')](_0x321a2f[_0x3e28('0x84')][_0x3e28('0x9b')]);_0x1058a7[_0x3e28('0x7f')]=qs[_0x3e28('0x92')](_['pick'](_0x321a2f['query'],_0x2858a3[_0x3e28('0x92')]));if(_0x321a2f['query'][_0x3e28('0x3')]){_0x1058a7[_0x3e28('0x7f')]=_[_0x3e28('0x9c')](_0x1058a7['where'],{'$or':_[_0x3e28('0xb')](_0x32bddb,function(_0x44a4b8){if(_0x44a4b8[_0x3e28('0x10')][_0x3e28('0x9d')]!=='VIRTUAL'){var _0x36fed5={};_0x36fed5[_0x44a4b8[_0x3e28('0x4')]]={'$like':'%'+_0x321a2f['query'][_0x3e28('0x3')]+'%'};return _0x36fed5;}})});}var _0x4a3782=[];var _0x3093d5=null;var _0x8d6ef9={};if(_0x13d1a9){_0x3093d5=_[_0x3e28('0x8d')](_0x3c1048,[_0x3e28('0xc'),_0x13d1a9[_0x3e28('0xc')]]);if(_0x3093d5[_0x3e28('0x4')]){_0x8d6ef9={};if(_0x10ee57['childModel']===_0x3e28('0x9e')){_0x8d6ef9[_0x3093d5[_0x3e28('0x9f')]]=_[_0x3e28('0xb')](_0x13d1a9['associatedResources'],'id');}else{_0x8d6ef9[_0x3093d5[_0x3e28('0x9f')]]=_0x13d1a9[_0x3e28('0x8')];}_0x4a3782[_0x3e28('0x8b')](_0x8d6ef9);}else{_0x1058a7[_0x3e28('0x7f')]['id']=_0x13d1a9[_0x3e28('0x8')];}}else{for(var _0x4c6cfc=0x0;_0x4c6cfc<_0x2a45c7['length'];_0x4c6cfc++){_0x3093d5=_[_0x3e28('0x8d')](_0x3c1048,[_0x3e28('0xc'),_0x2a45c7[_0x4c6cfc][_0x3e28('0xc')]]);if(_0x3093d5[_0x3e28('0x4')]){_0x8d6ef9={};_0x8d6ef9[_0x3093d5[_0x3e28('0x9f')]]=_0x2a45c7[_0x4c6cfc][_0x3e28('0x8')];_0x4a3782[_0x3e28('0x8b')](_0x8d6ef9);}else{if(!_0x1058a7[_0x3e28('0x7f')]['id'])_0x1058a7[_0x3e28('0x7f')]['id']=[];_0x2a45c7[_0x4c6cfc][_0x3e28('0x8')][_0x3e28('0xa0')](function(_0xc89861){_0x1058a7[_0x3e28('0x7f')]['id'][_0x3e28('0x8b')](_0xc89861);});}}}if(!_[_0x3e28('0x89')](_0x4a3782)){_0x1058a7[_0x3e28('0x7f')]=_['merge'](_0x1058a7['where'],{'$and':{'$or':_0x4a3782}});}_0x1058a7=_[_0x3e28('0x9c')]({},_0x1058a7,_0x321a2f['options']);if(_0x13d1a9&&!_0x13d1a9[_0x3e28('0x91')]&&_0x10ee57[_0x3e28('0x12')]===_0x3e28('0x9e')){if(_0x321a2f[_0x3e28('0x84')][_0x3e28('0xa1')]){_0x1058a7['include']=[{'all':!![]}];}return _0xd2cad7[_0x10ee57[_0x3e28('0x12')]][_0x3e28('0x6')](_0x1058a7)[_0x3e28('0x7')](function(_0x530752){var _0x350fce=[];_0x530752[_0x3e28('0xa0')](function(_0xe47e1f){var _0x40e0de;switch(_0xe47e1f[_0x3e28('0xa2')]){case'default':_0x40e0de=_['find'](_0x13d1a9[_0x3e28('0x8')],function(_0xdfd2fb){return _0xdfd2fb['id']===_0xe47e1f[_0x3e28('0x70')]&&_0xdfd2fb[_0x3e28('0x10')]==='DefaultReports';});break;case'custom':_0x40e0de=_[_0x3e28('0x8d')](_0x13d1a9[_0x3e28('0x8')],function(_0x494581){return _0x494581['id']===_0xe47e1f[_0x3e28('0x70')]&&_0x494581[_0x3e28('0x10')]===_0x3e28('0xa3');});break;}if(_0x40e0de)_0x350fce[_0x3e28('0x8b')](_0xe47e1f);});_0x15b042[_0x3e28('0xa4')]=_0x350fce[_0x3e28('0x8a')];_0x15b042['rows']=_0x350fce;return _0x15b042;});}else{if(!_[_0x3e28('0x89')](_0x321a2f[_0x3e28('0x84')]['ids'])){_0x1058a7[_0x3e28('0x7f')]['id']=_0x1058a7[_0x3e28('0x7f')]['id']?_[_0x3e28('0x93')](_0x1058a7[_0x3e28('0x7f')]['id'],_0x321a2f['query'][_0x3e28('0xa5')]):_0x321a2f[_0x3e28('0x84')][_0x3e28('0xa5')];if(_0x321a2f[_0x3e28('0x84')][_0x3e28('0xa6')]){_0x1058a7['order']=_0x321a2f['query'][_0x3e28('0xa6')];}}if(_0x321a2f[_0x3e28('0x84')][_0x3e28('0xa7')]){_0x1058a7[_0x3e28('0x7f')]=_[_0x3e28('0x9c')](_0x1058a7[_0x3e28('0x7f')],{'$and':_0x321a2f[_0x3e28('0x84')]['extraQueryConditions']});}return _0xd2cad7[_0x10ee57[_0x3e28('0x12')]][_0x3e28('0xa4')]({'where':_0x1058a7[_0x3e28('0x7f')]})[_0x3e28('0x7')](function(_0x5d88bb){_0x15b042[_0x3e28('0xa4')]=_0x5d88bb;if(_0x321a2f[_0x3e28('0x84')][_0x3e28('0xa1')]){if(_0x10ee57[_0x3e28('0x12')]==='CmContact'){_0x1058a7[_0x3e28('0xa8')]=[{'model':_0xd2cad7['Tag'],'as':_0x3e28('0xa9'),'attributes':['id',_0x3e28('0xc'),'color'],'required':_0x321a2f[_0x3e28('0x84')][_0x3e28('0xaa')]?!![]:![]},{'model':_0xd2cad7['Tag'],'as':_0x3e28('0xab'),'attributes':['id','name',_0x3e28('0xac')],'through':_0x321a2f[_0x3e28('0x84')][_0x3e28('0xaa')]?{'attributes':[],'where':{'TagId':_0x321a2f[_0x3e28('0x84')][_0x3e28('0xaa')]||undefined}}:{},'required':_0x321a2f[_0x3e28('0x84')][_0x3e28('0xaa')]?!![]:![]}];}else{_0x1058a7[_0x3e28('0xa8')]=[{'all':!![]}];}}return _0xd2cad7[_0x10ee57[_0x3e28('0x12')]][_0x3e28('0x6')](_0x1058a7);})[_0x3e28('0x7')](function(_0x32b70a){_0x15b042[_0x3e28('0xad')]=_0x32b70a;if(_0x4288ae===_0x3e28('0x2c')&&_0x321a2f[_0x3e28('0x84')][_0x3e28('0xae')]===_0x3e28('0xaf')){var _0x1808fb=[];for(var _0x164f84=0x0;_0x164f84<_0x15b042['rows'][_0x3e28('0x8a')];_0x164f84++){_0x1808fb['push'](_0x4c1786(_0x3e28('0xb0'),_0x15b042[_0x3e28('0xad')][_0x164f84][_0x3e28('0xb1')]));_0x1808fb['push'](_0x4c1786(_0x3e28('0xb2'),_0x15b042[_0x3e28('0xad')][_0x164f84][_0x3e28('0xb1')]));_0x1808fb[_0x3e28('0x8b')](_0x4c1786('fax',_0x15b042[_0x3e28('0xad')][_0x164f84][_0x3e28('0xb1')]));_0x1808fb[_0x3e28('0x8b')](_0x4c1786('mail',_0x15b042['rows'][_0x164f84][_0x3e28('0xb1')]));_0x1808fb[_0x3e28('0x8b')](_0x4c1786(_0x3e28('0xb3'),_0x15b042[_0x3e28('0xad')][_0x164f84]['dataValues']));_0x1808fb[_0x3e28('0x8b')](_0x4c1786(_0x3e28('0xb4'),_0x15b042[_0x3e28('0xad')][_0x164f84][_0x3e28('0xb1')]));}return Promise['all'](_0x1808fb)['then'](function(){return _0x15b042;});}return _0x15b042;});}});}}});};