Built motion from commit ddca4d0d.|2.5.47
[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 _0x1970=['reportType','DefaultReports','custom','CustomReports','count','Tags','tag','color','rows','openTabs','true','chat','dataValues','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','../../components/parsers/qs','squel','exports','models','filter','field','value','then','associatedResources','map','catch','model','findAll','name','resolve','UserProfileResource','AnalyticExtractedReport','resourceId','toLowerCase','childModel','odbc','SquareOdbc','SquareRecording','parentSections','SquareProjects','projectName','JscriptyProject','CmContact','Lists','ListId','lists','CmList','companies','CmCustomField','chatqueues','ChatQueue','chatwebsites','faxqueues','FaxQueue','faxaccounts','FaxAccount','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','membername','User','role','agent','Telephones','queue','inbound','type','outbound','musiconholds','VoiceMusicOnHold','chanspies','voiceprefixes','VoicePrefix','ivrcampaigns','MailQueue','mailaccounts','MailAccount','openchannelqueues','OpenchannelQueue','openchannelaccounts','SmsQueue','SmsAccount','whatsappqueues','WhatsappQueue','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','VoiceQueue','VoiceQueues','QueueCampaigns','telephones','Users','admin','user','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','sounds','Sound','tags','Tag','templates','Template','triggers','Trigger','Trunk','variables','Variable','plugins','Plugin','extractedreports','Reports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','Sequelize','QueryTypes','SELECT','ui.','ui.createdAt','user_has_','_interactions','where','ui.UserId\x20=\x20?','toString','OpenTabs','define','UserProfile','query','raw','Invalid\x20section\x20\x27','isEmpty','find','params','all','ignore','push','autoAssociation','length','rawAttributes','keys','filters','intersection','attributes','hasOwnProperty','limit','offset','merge','key','VIRTUAL','foreignKey','forEach','options','includeAll','include'];(function(_0x321bb2,_0x202794){var _0x9c12ed=function(_0x263dd3){while(--_0x263dd3){_0x321bb2['push'](_0x321bb2['shift']());}};_0x9c12ed(++_0x202794);}(_0x1970,0xce));var _0x0197=function(_0x1d4802,_0x1f185a){_0x1d4802=_0x1d4802-0x0;var _0x528927=_0x1970[_0x1d4802];return _0x528927;};'use strict';var _=require(_0x0197('0x0'));var attributes=require(_0x0197('0x1'));var qs=require(_0x0197('0x2'));var squel=require(_0x0197('0x3'));module[_0x0197('0x4')]=function(_0xdb9fec){var _0xc7a2b8=_0xdb9fec[_0x0197('0x5')];function _0x40df84(_0xf1cccf,_0x14d24f){return new Promise(function(_0x211d44,_0xbc8fb6){if(!_0x14d24f)return _0x211d44(null);var _0x42f694=_0x14d24f['filter']?{[_0x14d24f[_0x0197('0x6')][_0x0197('0x7')]]:_0x14d24f['filter'][_0x0197('0x8')]}:undefined;return _0xc7a2b8[_0xf1cccf]['findAll']({'where':_0x42f694,'raw':!![]})[_0x0197('0x9')](function(_0x4979b9){_0x14d24f[_0x0197('0xa')]=_[_0x0197('0xb')](_0x4979b9,'id');_0x211d44(_0x14d24f);})[_0x0197('0xc')](function(_0x1b5646){_0xbc8fb6(_0x1b5646);});});}function _0x3f71b2(_0x46863d,_0x58f5ca){return new Promise(function(_0x2875a6,_0x2536bc){var _0x2c462e=_0x46863d[_0x0197('0x6')]?{[_0x46863d[_0x0197('0x6')]['field']]:_0x46863d[_0x0197('0x6')][_0x0197('0x8')]}:undefined;return _0xc7a2b8[_0x46863d[_0x0197('0xd')]][_0x0197('0xe')]({'where':_0x2c462e,'raw':!![]})[_0x0197('0x9')](function(_0x5e6962){_0x58f5ca[_0x0197('0xa')]=_[_0x0197('0xb')](_0x5e6962,function(_0x4a765e){return _0x4a765e[_0x0197('0xf')];});_0x2875a6(_0x58f5ca);})[_0x0197('0xc')](function(_0x50caca){_0x2536bc(_0x50caca);});});}function _0x12f662(_0x2bba8c,_0x452a74,_0x578100){if(!_0x452a74)return Promise[_0x0197('0x10')](null);return new Promise(function(_0x3ac879,_0xe4cbd0){return _0xc7a2b8[_0x0197('0x11')][_0x0197('0xe')]({'where':{'sectionId':_0x452a74['id']},'raw':!![]})['then'](function(_0x610903){if(_0x2bba8c['field']&&_0x2bba8c[_0x0197('0x7')]!=='id'){_0x452a74[_0x0197('0xa')]=_['map'](_0x610903,function(_0x8b6314){return _0x8b6314[_0x2bba8c[_0x0197('0x7')]];});}else{if(_0x578100===_0x0197('0x12')){_0x452a74[_0x0197('0xa')]=_['map'](_0x610903,function(_0x34757e){return{'id':_0x34757e[_0x0197('0x13')],'type':_0x34757e['type']};});}else{_0x452a74[_0x0197('0xa')]=_['map'](_0x610903,function(_0x56517c){return _0x56517c[_0x0197('0x13')];});}}_0x3ac879(_0x452a74);})[_0x0197('0xc')](function(_0x2b180d){_0xe4cbd0(_0x2b180d);});});}function _0x28f606(_0x357133,_0x4810b2){var _0xa3816d={'parentSections':[]};switch(_0x357133[_0x0197('0x14')]()){case'squareprojects':_0xa3816d[_0x0197('0x15')]='SquareProject';break;case _0x0197('0x16'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x17');break;case'squarerecordings':_0xa3816d[_0x0197('0x15')]=_0x0197('0x18');_0xa3816d[_0x0197('0x19')]=[{'name':_0x0197('0x1a'),'field':_0x0197('0xf'),'foreignKey':_0x0197('0x1b')}];break;case'projects':_0xa3816d['childModel']=_0x0197('0x1c');break;case'contacts':_0xa3816d[_0x0197('0x15')]=_0x0197('0x1d');_0xa3816d[_0x0197('0x19')]=[{'name':_0x0197('0x1e'),'field':'id','foreignKey':_0x0197('0x1f')}];break;case _0x0197('0x20'):_0xa3816d['childModel']=_0x0197('0x21');break;case _0x0197('0x22'):_0xa3816d[_0x0197('0x15')]='CmCompany';break;case'globalcustomfields':_0xa3816d[_0x0197('0x15')]=_0x0197('0x23');break;case _0x0197('0x24'):_0xa3816d['childModel']=_0x0197('0x25');break;case _0x0197('0x26'):_0xa3816d[_0x0197('0x15')]='ChatWebsite';break;case _0x0197('0x27'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x28');break;case _0x0197('0x29'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x2a');break;case'inboundroutes':case _0x0197('0x2b'):case _0x0197('0x2c'):_0xa3816d['childModel']=_0x0197('0x2d');break;case _0x0197('0x2e'):_0xa3816d['childModel']=_0x0197('0x2f');break;case _0x0197('0x30'):_0xa3816d['childModel']=_0x0197('0x31');break;case _0x0197('0x32'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x33');_0xa3816d[_0x0197('0x19')]=[{'name':_0x0197('0x34'),'field':'name','foreignKey':_0x0197('0x35'),'model':_0x0197('0x36'),'filter':{'field':_0x0197('0x37'),'value':[_0x0197('0x38')]}},{'name':_0x0197('0x39'),'field':_0x0197('0xf'),'foreignKey':_0x0197('0x35'),'model':_0x0197('0x36'),'filter':{'field':_0x0197('0x37'),'value':['telephone']}},{'name':'VoiceQueues','field':_0x0197('0xf'),'foreignKey':_0x0197('0x3a'),'model':'VoiceQueue','filter':{'field':'type','value':[_0x0197('0x3b')]}},{'name':'QueueCampaigns','field':_0x0197('0xf'),'foreignKey':_0x0197('0x3a'),'model':'VoiceQueue','filter':{'field':_0x0197('0x3c'),'value':[_0x0197('0x3d')]}}];break;case _0x0197('0x3e'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x3f');break;case _0x0197('0x40'):_0xa3816d[_0x0197('0x15')]='VoiceChanSpy';break;case _0x0197('0x41'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x42');break;case _0x0197('0x43'):_0xa3816d[_0x0197('0x15')]='Campaign';break;case'mailqueues':_0xa3816d[_0x0197('0x15')]=_0x0197('0x44');break;case _0x0197('0x45'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x46');break;case'mailsubstatuses':_0xa3816d[_0x0197('0x15')]='MailSubstatus';break;case _0x0197('0x47'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x48');break;case _0x0197('0x49'):_0xa3816d[_0x0197('0x15')]='OpenchannelAccount';break;case'smsqueues':_0xa3816d[_0x0197('0x15')]=_0x0197('0x4a');break;case'smsaccounts':_0xa3816d[_0x0197('0x15')]=_0x0197('0x4b');break;case _0x0197('0x4c'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x4d');break;case'whatsappaccounts':_0xa3816d[_0x0197('0x15')]=_0x0197('0x4e');break;case _0x0197('0x4f'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x50');break;case _0x0197('0x51'):case _0x0197('0x52'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x53');if(_0x4810b2){_0xa3816d['parentSections']=[{'name':_0x0197('0x54')},{'name':_0x0197('0x55')}];}break;case'users':case'agents':case _0x0197('0x56'):_0xa3816d['childModel']='User';if(_0x4810b2){_0xa3816d[_0x0197('0x19')]=[{'name':_0x0197('0x57'),'filter':{'field':_0x0197('0x37'),'value':[_0x0197('0x58'),_0x0197('0x59')]},'ignore':!![]},{'name':'Agents'},{'name':'Telephones'}];}break;case _0x0197('0x5a'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x5b');break;case _0x0197('0x5c'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x5d');break;case _0x0197('0x5e'):_0xa3816d['childModel']='FreshdeskAccount';break;case _0x0197('0x5f'):_0xa3816d['childModel']=_0x0197('0x60');break;case _0x0197('0x61'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x62');break;case'zohoaccounts':_0xa3816d[_0x0197('0x15')]=_0x0197('0x63');break;case _0x0197('0x64'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x36');break;case _0x0197('0x65'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x66');break;case _0x0197('0x67'):_0xa3816d['childModel']=_0x0197('0x68');break;case _0x0197('0x69'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x6a');break;case _0x0197('0x6b'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x6c');break;case _0x0197('0x6d'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x6e');break;case'scheduler':_0xa3816d['childModel']='Schedule';break;case _0x0197('0x6f'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x70');break;case _0x0197('0x71'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x72');break;case _0x0197('0x73'):_0xa3816d['childModel']=_0x0197('0x74');break;case _0x0197('0x75'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x76');break;case'trunks':_0xa3816d[_0x0197('0x15')]=_0x0197('0x77');break;case _0x0197('0x78'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x79');break;case _0x0197('0x7a'):_0xa3816d['childModel']=_0x0197('0x7b');break;case _0x0197('0x7c'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x12');_0xa3816d[_0x0197('0x19')]=[{'name':_0x0197('0x7d'),'field':'id','foreignKey':_0x0197('0x7e')}];break;case _0x0197('0x7f'):_0xa3816d[_0x0197('0x15')]=_0x0197('0x80');break;}return _0xa3816d;}function _0x5e38e4(_0x4c24be,_0x10c8d6){var _0x5f4e9e=_0x4c24be[_0x0197('0x81')](0x0)[_0x0197('0x82')]()+_0x4c24be[_0x0197('0x83')](0x1);var _0x330f95={'type':_0xc7a2b8[_0x0197('0x84')][_0x0197('0x85')][_0x0197('0x86')],'raw':!![]};return new Promise(function(_0x2f4266,_0x250f8b){var _0x1613e1=squel['select']()[_0x0197('0x7')](_0x0197('0x87')+_0x5f4e9e+'InteractionId','id')[_0x0197('0x7')](_0x0197('0x88'))['from'](_0x0197('0x89')+_0x4c24be+_0x0197('0x8a'),'ui')[_0x0197('0x8b')](_0x0197('0x8c'),_0x10c8d6['id']);return _0xc7a2b8['sequelize']['query'](_0x1613e1[_0x0197('0x8d')](),_0x330f95)[_0x0197('0x9')](function(_0x2b2e8b){_0x10c8d6[_0x5f4e9e+_0x0197('0x8e')]=_0x2b2e8b;_0x2f4266(_0x2b2e8b);})[_0x0197('0xc')](function(_0x1f89ed){_0x250f8b(_0x1f89ed);});});}return _0xdb9fec[_0x0197('0x8f')](_0x0197('0x90'),attributes,{'tableName':'user_profiles','paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x9e0161){var _0x5e5a4b={'raw':_0x9e0161[_0x0197('0x91')][_0x0197('0x92')],'where':{}};var _0x41997d={};var _0x3d0c66={'count':0x0,'rows':[]};var _0x4d4771=_0x9e0161[_0x0197('0x91')]['section'];var _0x16795c=_0x9e0161['query']['mergeResources']||![];var _0x382e03=_0x28f606(_0x4d4771,_0x16795c);if(!_0x382e03[_0x0197('0x15')])throw new Error(_0x0197('0x93')+_0x4d4771+'\x27');var _0x4eaa10=[{'name':_0x4d4771}];if(!_[_0x0197('0x94')](_0x382e03['parentSections']))_0x4eaa10=_0x382e03['parentSections'];var _0x4a3c67=[];for(var _0x386e0f=0x0;_0x386e0f<_0x4eaa10['length'];_0x386e0f++){_0x4a3c67['push'](_0xc7a2b8['UserProfileSection'][_0x0197('0x95')]({'where':{'userProfileId':_0x9e0161[_0x0197('0x96')]['id'],'name':_0x4eaa10[_0x386e0f][_0x0197('0xf')]},'raw':!![]}));}return Promise[_0x0197('0x97')](_0x4a3c67)[_0x0197('0x9')](function(_0x2ebcd2){var _0xc06686=_[_0x0197('0x6')](_0x2ebcd2,function(_0x31d010){return _0x31d010?_0x31d010:undefined;});var _0x2f84a1=_[_0x0197('0x6')](_0x4eaa10,['ignore',!![]]);var _0x8fb12d=_['isEmpty'](_0xc06686)&&_[_0x0197('0x94')](_0x2f84a1)?null:_['union'](_0x2f84a1,_0xc06686);if(!_0x8fb12d)return null;var _0x5c89d8=[];for(var _0x160063=0x0;_0x160063<_0x8fb12d['length'];_0x160063++){var _0xb03000=_[_0x0197('0x95')](_0x4eaa10,function(_0xd79527){return _0x8fb12d[_0x160063]?_0xd79527['name']===_0x8fb12d[_0x160063][_0x0197('0xf')]:null;});if(_0xb03000){if(_0x8fb12d[_0x160063][_0x0197('0x98')]){_0x5c89d8[_0x0197('0x99')](_0x40df84(_0x382e03[_0x0197('0x15')],_0x8fb12d[_0x160063]));}else{if(!_0x8fb12d[_0x160063][_0x0197('0x9a')]){_0x5c89d8[_0x0197('0x99')](_0x12f662(_0xb03000,_0x8fb12d[_0x160063],_0x382e03['childModel']));}else{if(_0xb03000['model']){_0x5c89d8[_0x0197('0x99')](_0x3f71b2(_0xb03000,_0x8fb12d[_0x160063]));}}}}}return Promise['all'](_0x5c89d8);})['then'](function(_0x247448){var _0x4cfcac=_0x247448;var _0x2a6203=null;if(_0x4cfcac){_0x2a6203=_0x4cfcac[_0x0197('0x9b')]===0x1?_0x4cfcac[0x0]:null;}if(!_0x2a6203&&!_0x4cfcac)return _0x3d0c66;var _0x4d4e33=_0xc7a2b8[_0x382e03[_0x0197('0x15')]][_0x0197('0x9c')];_0x41997d[_0x0197('0xd')]=_[_0x0197('0x9d')](_0x4d4e33);_0x41997d[_0x0197('0x91')]=_[_0x0197('0x9d')](_0x9e0161[_0x0197('0x91')]);_0x41997d[_0x0197('0x9e')]=_[_0x0197('0x9f')](_0x41997d[_0x0197('0xd')],_0x41997d[_0x0197('0x91')]);_0x5e5a4b[_0x0197('0xa0')]=_[_0x0197('0x9f')](_0x41997d[_0x0197('0xd')],qs['fields'](_0x9e0161['query']['fields']));_0x5e5a4b[_0x0197('0xa0')]=_0x5e5a4b[_0x0197('0xa0')][_0x0197('0x9b')]?_0x5e5a4b[_0x0197('0xa0')]:_0x41997d[_0x0197('0xd')];if(!_0x9e0161[_0x0197('0x91')][_0x0197('0xa1')]('nolimit')){_0x5e5a4b[_0x0197('0xa2')]=qs[_0x0197('0xa2')](_0x9e0161[_0x0197('0x91')][_0x0197('0xa2')]);_0x5e5a4b[_0x0197('0xa3')]=qs[_0x0197('0xa3')](_0x9e0161[_0x0197('0x91')][_0x0197('0xa3')]);}_0x5e5a4b['order']=qs['sort'](_0x9e0161['query']['sort']);_0x5e5a4b[_0x0197('0x8b')]=qs['filters'](_['pick'](_0x9e0161[_0x0197('0x91')],_0x41997d['filters']));if(_0x9e0161[_0x0197('0x91')][_0x0197('0x6')]){_0x5e5a4b[_0x0197('0x8b')]=_[_0x0197('0xa4')](_0x5e5a4b[_0x0197('0x8b')],{'$or':_[_0x0197('0xb')](_0x4d4e33,function(_0x162ba5){if(_0x162ba5[_0x0197('0x3c')][_0x0197('0xa5')]!==_0x0197('0xa6')){var _0x54f94f={};_0x54f94f[_0x162ba5['field']]={'$like':'%'+_0x9e0161[_0x0197('0x91')][_0x0197('0x6')]+'%'};return _0x54f94f;}})});}var _0x36e707=[];var _0x558037=null;var _0x1b0c26={};if(_0x2a6203){_0x558037=_[_0x0197('0x95')](_0x4eaa10,[_0x0197('0xf'),_0x2a6203[_0x0197('0xf')]]);if(_0x558037['field']){_0x1b0c26={};if(_0x382e03[_0x0197('0x15')]==='AnalyticExtractedReport'){_0x1b0c26[_0x558037[_0x0197('0xa7')]]=_[_0x0197('0xb')](_0x2a6203['associatedResources'],'id');}else{_0x1b0c26[_0x558037[_0x0197('0xa7')]]=_0x2a6203[_0x0197('0xa')];}_0x36e707['push'](_0x1b0c26);}else{_0x5e5a4b['where']['id']=_0x2a6203['associatedResources'];}}else{for(var _0x24e801=0x0;_0x24e801<_0x4cfcac[_0x0197('0x9b')];_0x24e801++){_0x558037=_[_0x0197('0x95')](_0x4eaa10,['name',_0x4cfcac[_0x24e801][_0x0197('0xf')]]);if(_0x558037['field']){_0x1b0c26={};_0x1b0c26[_0x558037[_0x0197('0xa7')]]=_0x4cfcac[_0x24e801]['associatedResources'];_0x36e707['push'](_0x1b0c26);}else{if(!_0x5e5a4b['where']['id'])_0x5e5a4b['where']['id']=[];_0x4cfcac[_0x24e801]['associatedResources'][_0x0197('0xa8')](function(_0x36b55e){_0x5e5a4b['where']['id'][_0x0197('0x99')](_0x36b55e);});}}}if(!_['isEmpty'](_0x36e707)){_0x5e5a4b[_0x0197('0x8b')]=_[_0x0197('0xa4')](_0x5e5a4b['where'],{'$and':{'$or':_0x36e707}});}_0x5e5a4b=_[_0x0197('0xa4')]({},_0x5e5a4b,_0x9e0161[_0x0197('0xa9')]);if(_0x2a6203&&!_0x2a6203[_0x0197('0x9a')]&&_0x382e03['childModel']===_0x0197('0x12')){if(_0x9e0161[_0x0197('0x91')][_0x0197('0xaa')]){_0x5e5a4b[_0x0197('0xab')]=[{'all':!![]}];}return _0xc7a2b8[_0x382e03['childModel']][_0x0197('0xe')](_0x5e5a4b)[_0x0197('0x9')](function(_0x48c2b3){var _0x183e8f=[];_0x48c2b3[_0x0197('0xa8')](function(_0x4daf0a){var _0x3c5e95;switch(_0x4daf0a[_0x0197('0xac')]){case'default':_0x3c5e95=_[_0x0197('0x95')](_0x2a6203[_0x0197('0xa')],function(_0x2172e5){return _0x2172e5['id']===_0x4daf0a['reportId']&&_0x2172e5[_0x0197('0x3c')]===_0x0197('0xad');});break;case _0x0197('0xae'):_0x3c5e95=_[_0x0197('0x95')](_0x2a6203[_0x0197('0xa')],function(_0x2262a7){return _0x2262a7['id']===_0x4daf0a[_0x0197('0x7e')]&&_0x2262a7[_0x0197('0x3c')]===_0x0197('0xaf');});break;}if(_0x3c5e95)_0x183e8f[_0x0197('0x99')](_0x4daf0a);});_0x3d0c66['count']=_0x183e8f[_0x0197('0x9b')];_0x3d0c66['rows']=_0x183e8f;return _0x3d0c66;});}else{return _0xc7a2b8[_0x382e03[_0x0197('0x15')]][_0x0197('0xb0')]({'where':_0x5e5a4b[_0x0197('0x8b')]})[_0x0197('0x9')](function(_0x34c897){_0x3d0c66['count']=_0x34c897;if(_0x9e0161['query'][_0x0197('0xaa')]){if(_0x382e03[_0x0197('0x15')]===_0x0197('0x1d')){_0x5e5a4b[_0x0197('0xab')]=[{'model':_0xc7a2b8[_0x0197('0x72')],'as':_0x0197('0xb1'),'attributes':['id','name','color'],'required':_0x9e0161[_0x0197('0x91')][_0x0197('0xb2')]?!![]:![]},{'model':_0xc7a2b8['Tag'],'as':'ThroughTags','attributes':['id',_0x0197('0xf'),_0x0197('0xb3')],'through':_0x9e0161['query'][_0x0197('0xb2')]?{'attributes':[],'where':{'TagId':_0x9e0161[_0x0197('0x91')][_0x0197('0xb2')]||undefined}}:{},'required':_0x9e0161[_0x0197('0x91')][_0x0197('0xb2')]?!![]:![]}];}else{_0x5e5a4b[_0x0197('0xab')]=[{'all':!![]}];}}return _0xc7a2b8[_0x382e03['childModel']][_0x0197('0xe')](_0x5e5a4b);})[_0x0197('0x9')](function(_0x14015a){_0x3d0c66[_0x0197('0xb4')]=_0x14015a;if(_0x4d4771===_0x0197('0x34')&&_0x9e0161['query'][_0x0197('0xb5')]===_0x0197('0xb6')){var _0x2b803c=[];for(var _0x1cde68=0x0;_0x1cde68<_0x3d0c66[_0x0197('0xb4')][_0x0197('0x9b')];_0x1cde68++){_0x2b803c[_0x0197('0x99')](_0x5e38e4(_0x0197('0xb7'),_0x3d0c66['rows'][_0x1cde68][_0x0197('0xb8')]));_0x2b803c[_0x0197('0x99')](_0x5e38e4('sms',_0x3d0c66[_0x0197('0xb4')][_0x1cde68][_0x0197('0xb8')]));_0x2b803c[_0x0197('0x99')](_0x5e38e4(_0x0197('0xb9'),_0x3d0c66[_0x0197('0xb4')][_0x1cde68]['dataValues']));_0x2b803c['push'](_0x5e38e4(_0x0197('0xba'),_0x3d0c66[_0x0197('0xb4')][_0x1cde68][_0x0197('0xb8')]));_0x2b803c[_0x0197('0x99')](_0x5e38e4(_0x0197('0xbb'),_0x3d0c66[_0x0197('0xb4')][_0x1cde68]['dataValues']));_0x2b803c['push'](_0x5e38e4(_0x0197('0xbc'),_0x3d0c66[_0x0197('0xb4')][_0x1cde68][_0x0197('0xb8')]));}return Promise['all'](_0x2b803c)[_0x0197('0x9')](function(){return _0x3d0c66;});}return _0x3d0c66;});}});}}});};